session

Can anyone tell me whats wrong with this...

At the beginning of the ASP file is this:

Session("id") = Request.QueryString("id")


Command = "SELECT * FROM webdata where id = " & Session("id")

help help ....


Cheers

well, I have no idea what's wrong since you did not show us any error message, but look if you have a value in Request.QueryString("id") by simply do a Response.write(Request.QueryString("id")).
The second thing that could be wrong is that the value might be a string("0" is NOT the same as 0). In the SQL-string you treat id as a number(int) so you might want to convert it(to be sure it really is a int): cInt(Request.QueryString("id")) or int(Request.QueryString("id")).

hope this helps!
/David

Here's the error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id ='.

/gazcomp/default.asp, line 221

I've done this but still 0

Session("id") = cInt(Request.QueryString("id"))

another possible problem could be that you use POST instead of GET in the form-page. if this is the case, Request.QueryString("id") will be empty and therfore you will get an error.

I think GET is the default value when you create a form and do not specify a form-method.
/David

I've got it working but.... please click here i'm flippin lost know.. it wont update the edited file.

http://www.vbforums.com/showthread.p...threadid=74435

I've got it working but.... please click here i'm flippin lost know.. it wont update the edited file.

http://www.vbforums.com/showthread.p...threadid=74435

I've got it working but.... please click here i'm flippin lost know.. it wont update the edited file.

http://www.vbforums.com/showthread.p...threadid=74435

I've got it working but.... please click here i'm flippin lost know.. it wont update the edited file.

http://www.vbforums.com/showthread.p...threadid=74435