Access and Active Server Page

[DanjoMan]

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?

 

[mscertified]

What does this have to do with table design?

 

[DanjoMan]

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.

What does this have to do with table design?

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?