Multi-Relational Database
I have a table (Software Table) in a database that is linked with a many to one relation to another table (Computer Table). I wrote a simple ASP page to return the records for the software table which shares a one to many realtion with the Computer Table.
One (Software Table) to Many (Computer Table)
At persent the only records that are returned are the ones from the software table. Is there some way to return or display the many computers (one to many) for each record.I cant think how to start to do this. Can I link to computer table and have a drop down that lists the many computers?a better way to display this information?
View Complete Forum Thread with Replies
Related Forum Messages:
Relational Database Fields
Is their a way to check with asp-code if a database field is relational with another field (from another table)? For example: If fieldname = relational Then... End If
View Replies !
Connecting Relational Database
i have been thru a couple of books on ASP working with IIS 5.0 but still havent figured out how to connect to a MS Access database. the problem is with the SQL which i dont know well. My database has 6 related tables. It's for inventory control. The 1st table has the catagort the 2nd has the machines per category, the 3rd has machine parts per machine and so on. what I have been trying to do is to view the database for the latest updates per machine (which for now i am updating manually for the time being ) but the code dosent work and i get some errors one of which is " use an updateable qurrey" and others are related to SQl with every modification i make.
View Replies !
Multi Database Connection
I have written a asp application whihc uses a number of pages and each page connects to a sql database. Currently I have the connection script coded on each page however if i need to change the database I have to change every page. I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page
View Replies !
ASP And Relational Databases
What i need to do is build 2 tables below with the following fields: tblUsers id name address postcode tblShop id product Now i need to build a relation between the two id fields but what i relaly need to know is how to retreve the data in the tblUsers from the id in the tblShop through asp. This is like for a shop
View Replies !
Designing Relational Databases
I have an interview for job which requires following: 1.Modeling and Designing Relational Databases 2.Database applications for the web 3.Server side Programming using PHP 4.Macromedia Flash and Dynamic Data 5.Internet and Web Protocols 6.Installing Apache Web Server, PHP and MySQL 7.Authentication and Security 8.Integrating Streaming media into web development 9.Understanding Mobile Communications can anyone pls suggest me what Dynamic Data in point 4 means?Also what is Integrating Streaming Media of point 8?and when it says mobile communication.
View Replies !
Adding A Relational Table
I have a database which contains 2 tables. One which contains standard information (which every record has) and then the other, which is a relational table and is just a long list of records with different attributes that apply to various id numbers found in the first table. Both tables are contain records with the same ID number. Now, I have an ASP file that accesses the MDB file and displays it in XML format. I have it working for only the first table. However, I was wondering how I would go about getting entries from the second table entered. So it would display the items from the first table on 1 line - and then add on anything from the 2nd table that applies to that ID - all on one line. Code:
View Replies !
Multi-field Database "order By"
Is it possible to retrieve data with ASP sorted on 2 fields? I've tried : SELECT * FROM [TableName] ORDER By Field1 AND Field 2 But it gives an error. I've searched the internet on this topic to no avail. Is it possible?
View Replies !
Multi-purpose DLL
I released to open source a while back but forgot to post in here a DLL that was used in some of our older developments. It's not really a live project, but may be of use to peeps in here given some of the recent queries:Quote: DBSite: Written in Visual Basic this DLL helps solve issues for ASP web developers, e.g. handling uploads, safe parameter population for stored procedures (sql injection checks), SQL XML calls, file system browsing, etc.
View Replies !
Multi Tab Page
How can i create a multi tab page in asp.net 2.0? create a frame and a number of page with hyperlink? Would i have some directives?
View Replies !
Multi Tables
How can I update/delete a record which is linked to another table with a unique field. I know the select inner join, but no update/delete.
View Replies !
Multi-join
Trying to join three tables and find the records which DON'T match OR have less than x number of matches.Not sure how to go about it.keep getting matching fields only.
View Replies !
Multi Page
I need to create in asp/access/javascript a questionnaire that shows a single question on each page of which there are five then after the last question create a new record in the access db and write the answers.
View Replies !
Multi Updates
lets say we have a ms db with two cols id value 1 4 2 7 3 9 4 1 is there a simple way of updating all the value fields with one form? so i can have the page lay the four value's out in a list, the user could then edit them and hit update and this would update all the value fields. i can update single records no problem but have no idea where to start with this one.
View Replies !
.:·Dynamic Multi-dymansional
As part of the development of a shopping basket function, I've a two dimensional aray which I'm storing in the session variable. I want the array to be dynamic to store any amount of products which may added. I am getting a problem when trying to write to the second row to the array, saying that the subscript is out of range... You can see an example of this at: http://www.foulkestudios.com/session.asp I am getting what should be the first empty row by getting rows=UBound(myArray,2) I'm then trying to add into the next row by using rows + 1
View Replies !
Multi-user Applications
I am b-testing a community site, with currently 1,000 or so membership, and low concurrency, say no more than 5 on-line at once. The site is hosted on a shared server, which is sufferening from intermittent accute slowness, affecting all other hosted sites as well as mine. The finger of suspicion is pointing at me and possible sloppy code. As this is the first site I have done of this nature, could someone recommend reading matter (knowledge bases etc), especially coding samples, in connection with data connections (opening and closing connections and objects) and record locking issues, which if improperly coded, could contribute to throughput bottlenecks due to inefficient use of resources so that I can check out my pages and correct any nasties..
View Replies !
Multi-server Code
I am think to write a code that will need more then 2 servers. Can anyone give me some information to do code like that? Like yahoo, google, msn.
View Replies !
Multi-page Application
I need to develop an application that will span 12 or so pages, and on the last page, it lets the user review the data and then insert it all. This is kind of like selling something on eBay, you give it information, click next, enter more info and then at the end you review and submit the item. I was thinking about sessions, but some of the fields are pretty big, like varchar(5000) so I didn't know if there was a way to handle these big fields.
View Replies !
Multi-Lingual Web Site
I am in the process of developing several web sites that will accommodate up to 3 or 4 languages. The sites are not that complex, but will use an Access database for some data presentation/storage. Each page will have a series of flags for respective languages. Ideally, if someone enters on a "gateway" page for say Gallery, and they choose another language, I would like the same page to display but in a different language (there might be a page for each language, but if I can avoid that I'd rather). So here are my thoughts on how to approach this. Have a session var for language preference and set it in a Global.asa file. I would think it could be set dependant on the origin of the request, .de, .co.uk, .it, etc. Then, if the code is not too verbose, use Case statements in the code to display content based on language preference. One thing of a bit challenging for me is that if the "flags" are in an include file, how can I get them to when clicked go to a script, change the session variable and return to the page from which it was clicked. Am I on the right track with this approach.
View Replies !
Multi-page Displaying
I have a database full of info and I have display.asp which I want to display 10 items at a time so I have display.asp?page=1, display.asp?page=2, etc. How do I go about actually filtering the database to only produce 10 results per page? I was trying to use: results.Move 10 and things like that, but I'm not sure of the best way around this.
View Replies !
Multi Record Update
I have a table in the db and one field in the db is an email field various records can have the same email address in. When an email address changes from x to y I want to be able to change an email address x in every record in the table to y, how would I do this?
View Replies !
Multi-user Project
I was wondering if anyone had any links to some resources / tutorials or could offer up some help with regards to my current project. The concept is pretty simple. Multiple user login - which are then presented with a page where they need to answer some questions (drop-down responses). These responses are then checked against the answers and the points are then added and the results list the different users in descending order. Help and suggestions with any part of this would be greatly appreciated! I know this will be linked to a database (open to suggestions about which to use) and then how to structure my tables.
View Replies !
Order From Multi Select
Will the Request.form show the correct order that they were displyed in or will it do something different. I have been testing and it always shows the order they were displayed.Is this just coincidental?
View Replies !
Multi Email Addresses
Simple question no doubt - I am trying to send an email to a form variable as well as a list of addresses, but I can't seem to get it to work. Please help. I want to combine these two lines - what is the syntax? Code: MyCDONTSMail.To= "xxxxxxx@nzl.xerox.com" Code: MyCDONTSMail.To= creat_email They work individually (I have declared creat_email).
View Replies !
Re-populating Multi-select
I have two multi-select boxes...selLeft and selRight. The user moves choices from selLeft to selRight with arrow buttons. selLeft is populated using XML. My question is, when clearing everything on the screen, how do I repopulate selLeft, without losing items in selRight or repeating items left in selLeft. I'm a newbie and not familiar with the code used to build the multi select box in the first place. Code:
View Replies !
Multi Language Search
Iam working on a search that needs to fetch words from other languages for any given word entered in english. I use an access database to store the english words and its equalent words in other languages. For example: When i search for chinese equalent of Invoice (or any other word), the retrieved result is?.
View Replies !
Multi Language Site
I am currently creating a multi-language site using ASP .NET and was wondering what people think the best way to do this. Keeping a session variable of the users's choice? Cookies?
View Replies !
Multi Level Menu
how I can make a dhtml menu into a dynamic menu that pulls its links from an access database instead of the hardcoded html. I would like to know because I'm working on a site that needs such a menu and most of my administrators using my site don't understand html and won't be able to update the menu unless I can give them a simple form that allows them to add links.
View Replies !
Multi Checkbox Insert
I have a form that is passing a number to check box values with the same name (productID) but different values (numerical values). It is also passing a warehouseID as a hidden field. I need to dump these values into an access table called wtbProductWarehouses with fields titled ProductID and WarehouseID. What is the code that I need to write to have it loop through all of the productID values and individually add each one to the db while also adding the warehouseID with it.
View Replies !
Multi Checkbox Selection
i have 5 checkboxes in one asp page, I am trying to get the values of all checkbox that are checked using for each loop but I dnt get any result,just a blank page. Herez my code where I am trying to get the values of all check boxes Code: for each cid in request.Form("chk") response.Write cid & "<br>" next
View Replies !
Multi Queries Done In ASP Pages
The following statement works fine in SQL Query Analyser: SELECT count(*) as a from NEWUSERS WHERE activated='Y'; SELECT count(*) as b from NEWUSERS WHERE activated='N' -- It returns two values, yet when I have it in a .asp file, it only displays the first value. Is there anyway around this, without making two connections to the DB, and running two seperate queries?
View Replies !
Multi Lingua Web Sites Using ASP
I am currently maintaining a web site for my company's product. The existing site is in English and written in ASP. Currently, my boss plan to add 2 more languages version to the site (Malay and Chinese). So that when user click on the "Chinese" link, the Chinese version of the site will be displayed and click on the "Malay" version, the Malay version of the site will be displayed. I know that I can either duplicate another 2 sets of the same files with different languages and my job consider done. But the mainatance in the future will be a headache for me. So, I was planning to use XML for this purpose, can anyone show me the proper way that I can learn to use XML with ASP? What type of XML Editor should I use? Or is there any other way to deal with this purpose? Any good references I can get from the Internet?
View Replies !
Multi Checkbox Selection - ASP
i have 5 checkboxes in one asp page, I am trying to get the values of all checkbox that are checked using for each loop but I dnt get any result, just a blank page. Herez my code where I am trying to get the values of all check boxes: for each cid in request.Form("chk") response.Write cid & "<br>" next
View Replies !
Retrieve Multi Dim Array Value
I needed to print the values of a multidim array. I know it can be done by saying <%=array(i,j)%>. But my array is three dimensional and doesn't print any values if i say <%=array(i,j,k)%>. This array was declared as Dim vretdata and what it does it retrieves data from the database through a function. Code:
View Replies !
Reading From Multi Folders (FSO)
How can i set FSO to read from more that one folder at a time. I would like to get a list of files from more that one directory, i have code that gets the file list from one folder but how i can make it get the files from another folder also ? eg. Set Folder to more than one folder Code:
View Replies !
Retrieve A Particular Multi-dim Array Value
I needed to print the values of a multidim array. I know it can be done by saying <%=array(i,j)%>. But my array is three dimensional and doesn't print any values if i say <%=array(i,j,k)%>. This array was declared as Dim vretdata and what it does it retrieves data from the database through a function. Code:
View Replies !
Updating Multi Table
I have two table : order and orderdetail. I want to update these tables which one order can have many orderdetail. Can someone give reference how to do it ? I want to make sure all update process have to be success or cancel the process and give some error message.
View Replies !
Multi Page Form
I am writing a multi page form. I am using hidden input statements to pass my variables between different pages. Now I want to provide a page whereusers can update the previous entered data. The form at this point is populated through the hidden variables. But as I submit after making any changes. the hidden values instad of updating get an extra value. Is there any way to get around it.
View Replies !
Multi Page Form To Email.
I have been investigating how to create a multi page form in Frontpage that eventually will allow an emailed result. I can write the asp to "post" from one page to the next easily enough but when it comes to the last page, I can't figure out how to email the results. the syntax "response.write" will write to a web page but it won't fill in the content of am email. I thought of putting the "response.write" inside the body of a CDO.message but that leads to the next question... While looking at threads about the subject I keep seeing that I should use CDO (or CDONTS) or a third party app like aspmail. All of which, from what I can gather, use IIS SMTP service to function. The problem I will have is that I have Exchange 5.5 on the same machine so the SMTP on IIS won't start since ex5.5 uses that port. I have ex2k on another machine that I will soon move the users over to so that will free up the IIS port but I would prefer using the new mail server for this when it is running. Is there a method for using the ex5.5/ex2k mail system for sending the asp generated email? or perhaps another technique? I would prefer to just write it but if I have to buy something I will.
View Replies !
Multi Dimensional Array In Form
what i want to do is have a (multi dimensional?) array, so that each second dimension represnts a row of radiobuttons. The trouble is i don't know what to name the arrays as. Obviously for each row the names for the different radio buttons will be the same, meaning you can only select one. in php you could do it with a single array as you name each row of radio button differently: 1st row: name='array[0]' 2nd: name='array[1]' in asp it doesn't look like you can do it this way, because to create a similar array you'd do something like 1st row: name='array' 2nd name='array' then use split in the recipient script. This does not work however, because each radiobutton (on all rows) has the same name, and therefore when you click one all the rest on every row are unclicked..
View Replies !
Multi File HTTP Download
Anyone been able to get a multi file HTTP download working with ASP? I have a single file download working fine with the usual setting the content type, file name, stream the file from ADO.Stream, etc.
View Replies !
How To Save Multi-name Into One Field, And Display Only One
From my system, it allow product has multi-category, so I need to save all category names which one product belong to into one field on a database, and record saved like " nameA|nameB|nameC " - seperate by "|". question 1: the second time when i update the record for same product name, how to have a record like "nameA|nameB" After multi-category name saved, then, i would like to generate a navigate name with the link like home > nameB > name of product question2: so how can i retrieved only one name from category field.
View Replies !
Creating A Form With Multi Select
I am trying to create a form where you may have more than one person at a meeting, but want to have them be related to the same meeting. I have a mulitple select text area and if you select more than one, all the records are being added to the same row. so if I picked the following three people: (Person ID/Desc) 1 - mickey mouse 2 - donald duck 3 - goofy The row in the data base would look like this: (Meeting ID/ Person ID) 1 - 1,2,3 But I would like to do this: (Meeting ID/ Person ID) 1 - 1 1 - 2 1 - 3 I hope this makes sense, if it does does anyone have a suggest on how to best do this?
View Replies !
Multi-Dimentional Dynamic Array
I want to save the details of a SQL search into an Array, Im dabbling and tryin the script below but i get an error Script: SQL = "select item, number from table" Set rsTarg = Conn.Execute(SQL) i = 0 Dim TargArray() Redim TargArray(i, 1) do until rsTarg.eof TargArray(i, 0) = rsTarg("item") TargArray(i, 1) = rsTarg("number") i = i + 1 Redim Preserve TargArray(i, 1) rsTarg.movenext loop rsTarg.close i = i -1
View Replies !
Script Inputing Multi Rows
Can you look at this and see if anyone has any ideas why the row is inserted four times! It seems that if I don't include the NOCOUNT then it works fine, as soon as its used - problem. Code:
View Replies !
Multi Drop Down Search Boxes
I am strugling to make a Multi Drop Down Search boxes. The main concept is to be able to make a search following some pre-defined dropdown boxes. I would like to search for a specific event in mathematics (for exampel) from a specific time (between different centurie). - boex1 has a series of categories (Doctors, mathematicians..) - BoxA has a range of centuries from 1500 to 2000 (1500- 1600...) - BoxB has a range of centuries from 1500 to 2000 (1500- 1600...)
View Replies !
Multi-programming-language ASP Scripts
For the past couple of months we've been developing a fair number of sites and sub-sites for an intranet site using a mix of JScript and VBScript. Personally I disklike ASP and consider it an inferior scripting environment compared to Perl, PHP or Java, and the only reason I consented to work on this project was that I could use JScript (hello!.. real hashtables, exception handling etc.). The problem we're having at the moment, is that one developer only does VBScript, and I will only write large amounts of code if I use JScript. But various aspects of the sites are merging, and we're having problems passing varbles two and from VBScript and JScript. One hacked up solution i've used is as follows: Code:
View Replies !
Creating Multi Dimensional Arrays On The Fly
I am trying to setup a 2 dimensional array which i can populate on the fly with data coming frtom a database. I understand that you have to set a specfic size for the array in ASP, but I am looking at making the array dynamic and using the Redim function to increase the size by 1 each time. Code:
View Replies !
|
TRACKER
