[thelist] ASP & Access - Using the same variable twice
Christian Anderson
ckanderson at powersurfr.com
Sat Nov 24 22:09:46 CST 2001
Hey everyone, long time no question asking from me :)
Anyway, I am working on something in ASP using an Access database, and its
not working like I think it would. I after I pull some info from the
database, I want to use a few of the pieces of data more than once, but its
just not letting me. I can use each one only one time, and if I try and
call it again it wont work. For example this is the code that Im working
with:
<%
number = request.querystring("number")
SQL=("SELECT * FROM t_kawaguchiko WHERE aID = " & number & ";")
set conn = server.createobject("ADODB.Connection")
conn.open "photobase"
set store=conn.execute(SQL)
%>
So then I have some variable that I can call with <%= store(1) %> etc... so
if I have
My name is: <%= store(1) %>
I am whatever years old, bla bla bla bla bla, etc etc
on and on and on
...dont forget to email me, and dont forget that my name is <%= store(1) %>
!
So anyway, I call that <%= store(1) %> thing 2 times, and the second time I
call it, nothing shows up.
What can I do so it will allow me to use the same stuff more than once?
Thanks!
Christian Anderson
URL: http://www.photokyo.com
More information about the thelist
mailing list