[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