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,
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',
, 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
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
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
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
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
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,
8 matches
Mail list logo