hi, i just can't nunderstand why this sql query doesn't work :(

here comes the code:



UPDATE namestest SET namestest.Description = 'E-mail addressE-mail 

address', nametest.order = 1, nametest.shown = 1, nametest.required = 

1, namestest.stmsg = 'valid e-mail address \(e.g.: user@h...)', 

namestest.onBlur = 'clstat();isEmail(this);' WHERE (((test.fieldnamlist)

='email')) 

Microsoft OLE DB Provider for ODBC Drivers error '80040e10' 



[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 

4. 



/mytest/UserReg/userscr.asp, line 10 





the code, which uses this query is the following:

<%

 sqlstr= Request.Form("sql")

 If sqlstr <> "" Then

 	Response.Write(sqlstr)

 	dc.Execute sqlstr,,adCmdText+adExecuteNoRecords

 End If

%>



if somebody could help me, please, do so!!!!





 peter

Your field names are spelt incorrectly. You are updating a field called

"namestest", but you refer to it 4 times as "nametest". The database is

thinking that these are parameters that you are not supplying values for.



This is covered in my faq on 80040e10 errors:

http://www.adopenstatic.com/faq/80040e10.asp#scenario2



Cheers

Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Zsoldos Péter" <paz@c...>

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, June 26, 2001 12:43 AM

Subject: [asp_databases] could somebody help me finding the miistake?





: hi, i just can't nunderstand why this sql query doesn't work :(

: here comes the code:

:

: UPDATE namestest SET namestest.Description = 'E-mail addressE-mail

: address', nametest.order = 1, nametest.shown = 1, nametest.required 

: 1, namestest.stmsg = 'valid e-mail address \(e.g.: user@h...)',

: namestest.onBlur = 'clstat();isEmail(this);' WHERE (((test.fieldnamlist)

: ='email'))

: Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

:

: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

: 4.