Cannot Update
-
hello there,i know its not the righ place to ask some query,im cannot access my database in a query pane..i made a database where the username column has value and the password has none for e.g Username:93838383 and password:?..i just want to update the password column inputed by the user I make the query in th stord procedure but th error said: Incomplete SET clause..unable to parse query text i just want someone to check out the query and pls tell me what wrong or incomplete to my query UPDATE UserTable SET ((UserTable.[password] = [@password]) WHERE ((UserTable.username = [@username]) another thing is whenever the user visit the site,when the user type the password,it could not be updated anymore..unless i just want to use "select clause" because password column have now values... here is the query SELECT COUNT(*) AS Num_of_User FROM UserTable WHERE (((UserTable.username)=[@username]) AND ((UserTable.pasword)=[@password])); error:unable to parse query text it is correct query for accessing the values from the database? im using a visual web developer IDE thanx for helping
-
hello there,i know its not the righ place to ask some query,im cannot access my database in a query pane..i made a database where the username column has value and the password has none for e.g Username:93838383 and password:?..i just want to update the password column inputed by the user I make the query in th stord procedure but th error said: Incomplete SET clause..unable to parse query text i just want someone to check out the query and pls tell me what wrong or incomplete to my query UPDATE UserTable SET ((UserTable.[password] = [@password]) WHERE ((UserTable.username = [@username]) another thing is whenever the user visit the site,when the user type the password,it could not be updated anymore..unless i just want to use "select clause" because password column have now values... here is the query SELECT COUNT(*) AS Num_of_User FROM UserTable WHERE (((UserTable.username)=[@username]) AND ((UserTable.pasword)=[@password])); error:unable to parse query text it is correct query for accessing the values from the database? im using a visual web developer IDE thanx for helping
blitz2bleach wrote:
I make the query in th stord procedure but th error said: Incomplete SET clause..unable to parse query text
Count your parentheses. Also, don't you want to specify the parameters @password and @username instead of the fields [@password] and [@username]?
blitz2bleach wrote:
error:unable to parse query text
Same here, don't you want to specify the parameters @username and @password instead of the fields [@username] and [@password]? Check the spelling of the field pasword / password.
--- single minded; short sighted; long gone;