Trouble with INSERT INTO table

I'm having some trouble with my code and I'm not sure what the issue is. Basically, I have a form that is passing the information on to another asp page in order to add the info to the database. The error that I'm getting states:

Number of query values and destination fields are not the same


I checked the code, but don't know what the issue is? I'm guessing it's something to do with the two date values, but I'm not sure.

StrSql = "INSERT INTO Clients (CLIENT_NAME, CLIENT_STREET, CLIENT_CITY, CLIENT_ZIP, CLIENT_PHONE, CLIENT_GeneratorID, CLIENT_StartDATE, CLIENT_StopDATE, CLIENT_DESC) VALUES ('" & chkString(request("NAME")) & "', '" & chkString(request("STREET")) & "', '" & chkString(request("CITY")) & "', '" & chkString(request("STATE")) & "', '" & chkString(request("ZIP")) & "', '" & chkString(request("PHONE")) & "', '" & chkString(request("GeneratorID")) & "', '" & chkString(request("StartDATE")) & "', '" & chkString(request("StopDATE")) & "', '" & chkString(request("DESC")) & "')"

and for future reference...

"Number of query values and destination fields are not the same"

means that the # of items don't match, so in

INSERT INTO table (....these column names...) VALUES (...these values....)

don't have the same number or items, and directly from the code you posted:

Items in Column Name section of Insert:
CLIENT_NAME
CLIENT_STREET
CLIENT_CITY
CLIENT_ZIP
CLIENT_PHONE
CLIENT_GeneratorID
CLIENT_StartDATE
CLIENT_StopDATE
CLIENT_DESC
(9 items total)

Items in right side:
chkString(request("NAME"))
chkString(request("STREET"))
chkString(request("CITY"))
chkString(request("STATE"))
chkString(request("ZIP"))
chkString(request("PHONE"))
chkString(request("GeneratorID"))
chkString(request("StartDATE"))
chkString(request("StopDATE"))
chkString(request("DESC"))
(10 items)

since 9 != 10, SQL spit out that error and told you exactly what's wrong :)

 

nothing to be absent minded about...

just trust the error messages, read what they are telling you.....  makes programming a lot easier