Retrieving Data From Other Tables
if there is two tables. for example
Table 1: IC No, Name
Table 2: IC, No, Address
IC No are primary keys
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?
View Replies
ADVERTISEMENT
from the client side is possible to create a XMLHTTPREQUEST object to retrieve data ( in async way ) from web services, or simple from a asp page like this :
----- myasp.asp -----
<% response.write("<info>hello</info>") %>
----------------------
how can i accomplish this, but from the server side using ASP and ASP.Net ?
View Replies
View Related
I've created asp reports getting datas from Oracle. The server im using is 8i while client is 9i. Does Asp support oracle 9i. I mean while retrieving numeric datas from oracle it displays only 0. But if the same query is run in oracle to test it, it displays properly.
Do I have to download any patch or driver where IIS is compatible with oracle 9i. Any ideas whats wrong. Did u guyz understand what im trying to say. For ur better understanding Im sending a doc attachment.
View Replies
View Related
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig/default.asp
or
http://localhost/site/craig/test.asp
or
http://localhost/site/craig/roger.asp?dan=1
is there anyway of retrieving the word craig so to use it in the page, I just want the word Craig
This is because i could have other addresses that are for example
http://localhost/site/jon/default.asp
or
http://localhost/site/jon/test.asp
or
http://localhost/site/jon/roger.asp
where i need to retrieve the word jon
at the moment i use the code
strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "")
intStart = instrRev(strURL, "/") + 1
strName = mid(strURL, intStart)
this worked fine until new pages are added ie a page that isnt default.asp
Obviously i cant use strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "") because default.asp will change...
View Replies
View Related
I am submitting data to a database field, and the data is being submitted in the following manner to a table in the database:
5,3,4,4,3,3,4,5,4,5,5
It's all comma delimeted. Now, what I would like to do is have an update page in which a user can update these values. I am trying to place the values in a repeated text box that corresponds with a repeated question.
The questions that I am displaying are in a repeated field and each question has a text box that will hold the value that corresponds to. I would like to be able to bring in each value into a repeated text box. Right now, each repeated text box contains the above information. (5,3,4,4,3,3,4,5,4,5,5). Is this possible?
View Replies
View Related
I have a search set up on my site to compare between two <select> values and the value in the data base, but not sure if I have the sql statment correct, my search returns all rows from the table, I want specific row that is between one form select and another... ie. below
for this particular example I want to know if the database AD_PRICE field is between <select name=price> and <select name=price1> and if so, return the only those rows, currently all rows are being returned... Code:
View Replies
View Related
does any one just help me with the an example of retrieving data from access data base?
View Replies
View Related
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample:
Photo #1 when clicked goes to: info.asp?no=1
Photo #2 when clicked goes to: info.asp?no=2
so on so forth..
the database fields are:
no
picname
date
details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
View Replies
View Related
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies
View Related
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...
View Replies
View Related
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:
View Replies
View Related
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:
View Replies
View Related
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 ?
View Replies
View Related
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:
View Replies
View Related
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!
View Replies
View Related
i have 2 tables;
table01:
fields are
field01,field02,field03,field04,field05
and another table
table02:
fields are
field01,field02
when someone submits the form, i want to add the infos supplied by the user to be added to these 2 tables.
field01 & field02 shall be added to tables 1 & 2;
&
field03,field04 & field05 to table01 only
i tried using this code:
myquery = "INSERT INTO table01 (field01,field02,field03,field04,field05) VALUES ('" & f1 & "','" & f2 & "','" & f3 & "','" & f4 & "','" & f5 & "')"
myquery2 = "INSERT INTO table02 (field01,field02) VALUES ('" & f1 & "','" & f2 & "')"
adocon.execute myquery,myquery2
but this one only adds to the first table.
can someone tell me how to fix the problem?
View Replies
View Related
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..
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
Now I did the following and got this error massage:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/New Folder/1form.asp, line 305
Response.Write "<td><input class="formpagetablefield" type="text" name="tradeid" size="6" Value="& trim(rsTable("tradeid"))%"></td>
I dont't know if the code below will work. Can someone tell me if it is correct in principle: Code:
View Replies
View Related
When a new record is inserted into access db it creates an id, how can I return this value for a record I have just created?
View Replies
View Related
I have the following code in my form:
Response.Write("<form name='Testing'>");
Response.Write("<INPUT type=hidden id='Testing_txtbox'
name='Testing_txtbox' value='a simple test'>");
Response.Write("</form>");
If I type the following in the very next line, I get a value of
"undefined".
Response.Write("value="+Request.Form("Testing_txtbox"));
why this won't work. and how I can retrieve values of hidden controls via Server side code?
View Replies
View Related
I have a DTD xml doc and need to read the data from it and display it using ASP.
View Replies
View Related
I want to know if there is a way to retrieve the tag from the URL, I don't know if thats its name, so I'll just explain what it is:
showmsg.asp?FID=mn&ID=2467#2529
the tag, as I call it is what follows the # sign, the number 2529, in this case. so, is there a way I can retrieve the tag with ASP, by the request object, or any other way, any Ideas? Another thing I wanted to know, not related to this subject, is how do I change value of a textarea that is placed in another window with VBscript or JAVA. is it possible?
View Replies
View Related
I have three different tables I will be pulling stuff from: user_info, img_inv, activitylog:
user_info I will be using their ID and state
img_inv I will be using part number
activitylog I will be using part number and date
I'm trying to select the part number from the activities list and match it with the img_inv to make sure it still exist. If it exist I want it to do a total count of how many times it has been looked at by 7 states within a given quarter. Code:
View Replies
View Related
I want to retrieve the value of a cookie to make a form a little more user friendly (our intranet is configured to set a cookie for User First Name, Last Name and Email when they log in)
Unfortunately I can't figure out how to retrieve the value of the cookie. I've been trying:
<%
Response.write Request.Cookies(UserLName)
%>
But it gives me an error - I used Checky to make sure the cookies are there and they do exist:
Name:mascot
Value: UserLName=Tarby
Can someone give me some advice?
View Replies
View Related
i want some help in how to retrieve values from multiple selection listbox. i want the values retrived to be used in the search which i perform from the database. i m doing a search feature which u all often see in job search sites. so someone selects multiple cities to search in i want that to include that in my search query.
View Replies
View Related
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig
is there anyway of retrieving the word craig so to use it in the page
This is because i could have other addresses that are for example
http://localhost/site/Jon
where i need to retrieve the word jon
View Replies
View Related
I have a form that send values to a second page. i m trying to compare the values received from the form with other values retrieved from a database. so if a value already exists then an error message is displayed. in order to compare the values i need to print them on the second page but I m bit stuck with this. i used request.form("category") in order to retrieve the values from the form but it doesn t work.
View Replies
View Related
I am trying to get a field populated in an oracle database with a time stamp of when a form is submitted.
I have found out that there is a table in Oracle called DUAL which holds the current date and time. At present i can populate the date when the form is submitted using objrs('sub_date')=date() but when i query the database the time element of the field sub_date, the time displayed is 00:00 which is the default time.
So can anyone give me any help in how i can capture the time. I know about select to_char(sub_date,'DD-MON-YYYY HH24:MI') which will bring up the time but i can seem to populate the field sub_date with the time.
View Replies
View Related
I am trying to retrieve the page name. I know this is possible using Server Variable PATH_INFO. The problem I am having though is that when I get to a page in one of my subdirectories the subdirectory name is displayed.
Example: my page index.asp is in the the admin directory so the PATH_INFO displays as /admin/index.asp. How can I strip the page name out so I get index.asp. I cannot use the function Right() since the page name could be any length.
View Replies
View Related
How to retrieve "Last modified" & "FileName" from all files in a specific folder (called MyDocs) and display on the ASP page?
eg. (in MyDocs folder)
- MikesWork.doc
- MyResume.xls
- HouseExpenses.xls
Situation
Let's assume that i just modified MyResume.xls file and save it today(10/30/2003) on my computer, then i upload it into the internet. On my asp page, i want to show all files Filename (Last Modified) in MyDocs folder.
eg.
Your Documents
1. MikesWork.doc (last modified 10/24/2003)
2. MyResume.xls (last modified 10/30/2003)
3. HouseExpenses.xls (last modified 9/15/2003)
I know it has to do with fso or something close to it... but totally have no idea (zero) of its logic or how it works. Please help me by giving me with full example.
View Replies
View Related