if i wanna list data from 2 tables at the same time, is that possible. i have 2 tables: itemsorderd and orders, which both have OrderID.
now i want to list the 2 fields from itemsorder which are Quantity and ProductID, as well as all the fields from orders, which contains the shipping details. how can i do that in a single SQL statement ? also if i wanna delete all these datas associated with the OrderID, how can i do that ?
I develop a .asp app that reads its data from an Access DB "A", and I have a desktop app with a FoxPro DB "B".
How can I insert data from a table in DB "A" to a table in DB "B". Im new to asp and I really know only the basic's, so who can guide me to a tutorial or where can I dowload an example...
im currently working on a login system, and its the first time i have had to use an inner join. basically i have 2 tables, an attendance table and a member table. the attendance table contains the following: Code:
I have two tables. Table1 contains the names of training classes being offered and Table2 has the names of the people who are going to attend. The code below lists the classes being offered and a links to add, remove, and view other employees that are attending that class.
I only want the remove button to appear if you have already signed up for the class. I also only want the remove button to appear if the username cookie equals the username of the person that is signed up for the class which means the employee that wants to be removed from the class has to do it. My insert code (not shown) puts the username in the cookie into the Table2.
I tried using this code to accomplish what I wanted above but it does not display the remove button if the person is signed up and trying to remove themself. Code:
There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID 1 4 1 7 1 9 1 10 etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
I want to create another Database using ASP, this I can do. However, what is the easiest way to copy tables from one DB to this new DB?
I dont really want to have to write the SQL to create each table and then to use a 'select into' code for table, especially as I have around 15 tables to do!
I have 3 tables (MS Access) and I would like to display the content of all three tables alphabetically on a .asp page I have no problem displaying a list from each of the individual tables, but I am stumped when I try to display a combined listing..
I have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.
Imagine an asp-script that retrieves data from a database and returns an HTML with table of the retrieved data, allowing user to edit some values and delete rows. The issue occurred after deleting a row. Lets say the initial table was: Code:
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
I am displaying a list of data from a sql database. I have hyperlinked each field as i want the user to be able to click on this link, the page refreshes and all entries that are the same as the user clicked on are at the top of the list. I am using a query string as the link.
I'll get right to the point. I'm displaying an alphabetical listing of names from a recordset in the following manner: A abe alex ... B barb bob ... C craig etc...
Presently, I'm using a for..next statement to cycle through the alphabet, and displaying the matching names for each letter via a loop. Here is the code:
display just a listing of files in this manner.For example.If i select D: drive it should give me all files in root directory and sub folders and sub sub folders.
The operation is like a dos command dir /s/o/b
I am using this for sitmap for one of my client, who has more than 100 folders and 50 sub folder and 10 sub sub folders that he has more than 7000 html pages
I am tring to build a registration online form that participants will be able to choose from about 75 diferent courses divided into various sessions and choosing a course per session.The problem I have is that I cant figure out the best way to do this: 1. either to make them static pages and then submit the values the participant chooses into a database and use the values for billing etc. Like this i will be able to validate / control what the users chooses e.g they dont choose overlapping courses. 2 my second option is to list them in a database and then list them on my page , which is easier but how do I validate what the participant chooses and how do I move the values to the next page and making sure the right course goes to the right session.
Is it possible to list directories of different computers in a network?
For instance, I have the script on "server 1", "server 2" is another computer in its network places under the same domain. I want to have a asp or asp.net script list the contents of "server 2" from "server 1".
Is this possible? all the asp scripts Ive seen so far can only list files from the computer/server its on.
I've managed to get file listings, do textstreams, move around in the file system a bit, just wondering how I get folder listings as I would file listings... Here's what I've tried, but it's not quite working:
Set objFile=objFSO.GetFile(strPhysicalPath) Set objFolder=objFile.ParentFolder Set objFolderFolders=objFolder.Folders
For Each objFolderItem in objFolderFolders mess=mess & "<tr><td><a href=""" & objFileItem.Name & """>" & objFolderItem.Name & "</td><td></td><td></td><td></td><td></td></tr>" Next [/vbs]
I have been searching google and other search engines and have not come up with anything for this question of mine. Maybe I'm not typing in the right stuff. I am writing a couple of scripts that require me to display a list of information from a database from one catagory. I have never needed to do this before and am trying to find out how I should go about doing it
Assume I enter number 1 in "from" and 10 in "to" - I want the ASP to return: 1,2,3,4,5,6,7,8,9,10 and insert this into an Access database over 10 rows into the 'number' field.
At work I was asked to add a link to a directory listing page. This page is with the link is located behind a secure page requiring a username and password. When I added the link I also went to iis and checked to make this directory have directory browsing listing checked.
Everything is fine however now this directory is open if you just post the complete link to it in the URL bypassing the login page. Is this a nornal behavoir and is their anything that can be done to make it prevent it to be opened?
as i enter text in the textbox i want to narrow down there result in the box below that has all the listing of the products. i.e as i enter 'a' in textbox it will filter all products starting with 'a' then if i enter 'b' as second character it will show onlythose products that are starting with 'ab'... so how could i do that.
anyone know of a good ASP Application that will allow me to do featured listings/ or sponsored listings on a page? These need to be text based links - like google style probably.
What the above code is supposed to do, obviously, is write a person's e-mail address out, and at the same time include that address in a hyperlink so that someone could e-mail that person. The problem is that it doesn't show up. There is no error code or anything- the output just does not show up.
I would like to list all files and folders on a password protected directory (basick auth). I know how to list all files and folders in a normal directory but i don't know how to do so for a password protected one, due to the fact that i couldn't find any article/book that explains how to do so and also the fact that to the best of my knowledge there is no way to pass a username and a password to the File object in order to authenticate to the webserver as an other user, all i could think of was to pass the user/pass to this directory in the header (with response.AddHeader ) but that doesn't seem to work (even though i am not sure i used the correct syntax for the header).
I have an access db with 5 fields, ID, Category, BusinessName, Address and Phone. I want to list the records like so but can't think how my loop and check to see if the category has been changed should look. Can anyone help?
I have an Access Database with only one table (tblBooks) with 5 fields: id, TestNumber, Book, Author, ReadingLevel, PointValue. I would like to have alphabetical listing of the records displayed by hyperlinks on the top of the page like:
<Previous All | A | B | C | ....| Y | Z | Others Next>
Also would like to have only 25 records per page and bottom page numbering. I know this is a newbie question but I haven't being able to figure it out.