|
| |
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
 |
access to an ASP page - 9/14/2004 2:04:58
Hey, I have a problem to get into the same ASP file for example
dim product_id
set product_id=Request.QueryString("product_id")
dim conn13
set conn13=server.CreateObject("ADODB.connection")
conn13.Open "dsn=teknion"
dim sql13,rs13,sql14
set rs13=server.CreateObject("ADODB.recordset")
set rs15=server.CreateObject("ADODB.recordset")
sql13="select * from products where product_id=" & product_id
sql15="select * from storymenu where story_id=" & product_id
rs13.Open sql13,conn13
rs15.Open sql15,conn13
Response.Write "<a href=" & "default.asp?story_id=" & rs15("story_id") & "><img src='../images/" & rs13("menu1") & "'></a>"
%>
The name of the file is default.asp ,can I link to the same file?
|
|
|
|
BeTheBall
Posts: 6365
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: access to an ASP page - 9/14/2004 9:35:07
Sorry wizard, can't say as I can follow the yellow brick road on this one. Can you elaborate a little? The above code appears sound, is there something wrong with it?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: access to an ASP page - 9/14/2004 14:36:34
sorry' I didn't understand you
the reason I open 2 recordset is because I am using 2 tables at my database
| |
|
|
|
BeTheBall
Posts: 6365
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: access to an ASP page - 9/14/2004 14:56:38
Explain in more detail your original question. What are you trying to do and what in the code you posted is the problem.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: access to an ASP page - 9/15/2004 7:17:38
look at the link:http://www.teknion.com/products/systems_transit/default.asp?country=canada
you will see that the menu in blue in in database but it is calling to the same page' I want to do the same think
| |
|
|
|
BeTheBall
Posts: 6365
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: access to an ASP page - 9/15/2004 10:01:54
That is determined by the form. The form submits to the same page. The code for the form is:
<form action="default.asp" method="get">
When the form is submitted, the criteria for the SQL statement is updated to whatever was chosen in the dropdown. Make sense?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: access to an ASP page - 9/15/2004 17:14:43
Thanks, I will check it out today later
I hope it will work for me.
Elen
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
