In updating a column of a table, I encounter an error message that says there too few parameters!
Show some *relevant* code
Below is the code:<BR>'open database<BR> name1= Request.form("newname")<BR> sql="UPDATE tablename SET tablecolumn='name1'WHERE ID=myID"<BR> oConn.execute(sql)<BR> 'close database<BR> oConn.close<BR>
sql="update tablename set tablecolumn='"&name1&"' where id="&myid<BR><BR>(if myid is a variable)
Still getting the same error message that there are too few parameters.
did you insert a space before *where*?<BR>it shouldn't give you an error.....
Unfortunately, it is giving me an error. The full error is:<BR>Microsoft OLE DB Provider for ODBC Drivers error '80040e10' <BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <BR><BR>
sorry...can't help you more...i'm still learning myself.