Insert INTO syntax error - HELP

I can't find the syntax error in the following INSERT INTO statement - someone with good eyes, please help me out! cfquery name="addrow" datasource="#dbname#" INSERT INTO OWS (owsid, type, date, capacity, length, width, height, manufacturer, serial, discharge, repairs, repairdates,

RE: Insert INTO syntax error - HELP

SQL = "INSERT INTO OWS (owsid, type, date, capacity, length, width, height, manufacturer, serial, discharge, repairs, repairdates, cleaning1, cleaning2, contractorname, contractoraddress, contractorPOC, contractorphone, license, sludge, sample, locationid, siteid) VALUES ('1', 'jkl', 'jkl',

RE: Insert INTO syntax error - HELP

, 2000 4:52 PM To: [EMAIL PROTECTED] Subject: Insert INTO syntax error - HELP I can't find the syntax error in the following INSERT INTO statement - someone with good eyes, please help me out! cfquery name="addrow" datasource="#dbname#" INSERT INTO OWS (owsid, type, date, cap

Re: Insert INTO syntax error - HELP

NTO syntax error - HELP : SQL = "INSERT INTO OWS (owsid, type, date, capacity, length, : width, height, manufacturer, serial, discharge, repairs, : repairdates, cleaning1, cleaning2, contractorname, : contractoraddress, contractorPOC, contractorphone, license, : sludge, sample, loc

Re: Insert INTO syntax error - HELP

I assume owsid and locationid are numbers, they should not have single quotes around them. - Original Message - From: "Erika Foster" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 18, 2000 1:52 PM Subject: Insert INTO syntax error - HELP I can't find the sy

Re: Insert INTO syntax error - HELP

Right off the bat, I'd say...do you have any number fields? Like, for instance, your id field? If it's a number, leave off the ' marks. Also, you'll probably need to do something like this: createodbcdate(thisdate) to convert the date field into an odbc format (assuming an odbc type database

Re: Insert INTO syntax error - HELP

Thanks everyone! Changing the DATE field name did the trick. Erika - Original Message - From: "Deanna L. Schneider" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 18, 2000 3:15 PM Subject: Re: Insert INTO syntax error - HELP : Right off the bat, I'd say...do yo

Re: Insert INTO syntax error - HELP

Are all your fields character/text fields? At 2:52 PM -0600 7/18/2000, Erika Foster wrote: I can't find the syntax error in the following INSERT INTO statement - someone with good eyes, please help me out! cfquery name="addrow" datasource="#dbname#" INSERT INTO OWS (owsid, type, date,