Access and Active Server Page

G

Guest

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/SBDX/Scripts/edit_agency_script.asp, line 33

I all the sudden started getting this error when doing my SQL updates.
Using:

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "SBDX2","",""
uSql = "UPDATE PROFILE SET AGENCY_NAME='" & AGName & "',
RESPONDENT_FIRSTNAME='" & FName & "', RESPONDENT_LASTNAME='" & LName & "',
POSITION_IN_AGENCY='" & position & "', OTHER_POSITION_COMMENT_TXT='" &
otherPosition & "', STREET_ADDRESS_1='" & address1 & "', STREET_ADDRESS_2='"
& address2 & "', ZIP_CODE='" & agencyZip & "', ZIP_PLUS_FOUR='" & agencyPlus4
& "', RESPONDENT_PHONE_NUMBER='" & agencyPhone & "', RESPONDENT_PHONE_EXT='"
& agencyExt & "' WHERE AGENCY_PROFILE_ID='" & eapid & "'"

'Response.Write "DEBUG SQL: " & uSQL & "<HR>"
conn.Execute(uSql)

can someone help me with why or what added information I need to provide?
 
G

Guest

Hmm. I do repect your question.. but not so sure you were kind in NOT
directing me to the right place. Oh well your forgiven. :)

The problem BTW. Is that in the "Table Design" one of the columns had a
space. Zip Code, and this caused a problem in my sql statement.

Does that qualify. I found the answer on my own though.


mscertified said:
What does this have to do with table design?

DanjoMan said:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/SBDX/Scripts/edit_agency_script.asp, line 33

I all the sudden started getting this error when doing my SQL updates.
Using:

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "SBDX2","",""
uSql = "UPDATE PROFILE SET AGENCY_NAME='" & AGName & "',
RESPONDENT_FIRSTNAME='" & FName & "', RESPONDENT_LASTNAME='" & LName & "',
POSITION_IN_AGENCY='" & position & "', OTHER_POSITION_COMMENT_TXT='" &
otherPosition & "', STREET_ADDRESS_1='" & address1 & "', STREET_ADDRESS_2='"
& address2 & "', ZIP_CODE='" & agencyZip & "', ZIP_PLUS_FOUR='" & agencyPlus4
& "', RESPONDENT_PHONE_NUMBER='" & agencyPhone & "', RESPONDENT_PHONE_EXT='"
& agencyExt & "' WHERE AGENCY_PROFILE_ID='" & eapid & "'"

'Response.Write "DEBUG SQL: " & uSQL & "<HR>"
conn.Execute(uSql)

can someone help me with why or what added information I need to provide?
Click to expand...
Click to expand...
 
Top