Simple update question 2

[Sajtz]

I'm trying to update my database. Look at this simple example.
<%
wonid_user = Session(&quot;username&quot
Uppdatera = &quot;SELECT * FROM users WHERE username = &quot;I want to know what to write here in order to get the value from wonid_user&quot;

%>

 

[Bastien]

wonid_user = Session(&quot;username&quot
Uppdatera = &quot;SELECT * FROM users WHERE username = &quot; & wonid_user

hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[Sajtz]

I get this error message when I use the code above:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

If I use this line
Uppdatera = &quot;SELECT * FROM users WHERE username = 'my_username' &quot;
it works just fine.. but then the username is not dymanic.

 

[GaryC123]

Uppdatera = &quot;SELECT * FROM users WHERE username = '&quot; & my_username & &quot;'&quot; Saturday 12.00

20.00

3.00am

Sunday [img http

 

[Bastien]

sorry, assumed that wonid-user was a numeric field not alpha Bastien

There are many ways to skin this cat,
but it still tastes like chicken