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!
>
>
> 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 ('#thisowsid#', '#thistype#', '#thisdate#', '#thiscapacity#',
>'#thislength#',
> '#thiswidth#', '#thisheight#', '#thismanufacturer#', '#thisserial#',
>'#thisdischarge#',
> '#thisrepairs#', '#thisrepairdates#', '#thiscleaning1#',
>'#thiscleaning2#', '#Thiscontractorname#',
> '#thiscontractoraddress#', '#thiscontractorPOC#',
>'#thiscontractorphone#', '#thislicense#',
> '#thissludge#', '#thissample#', '#thislocationid#', '#thissiteid#')
>
>
>gives this result with dummy data:
>
>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
>statement.
>
>
>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', 'jkl', 'jk',
>'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
>'jk', 'jk', 'jk', 'jk', '02', '27A25')"
>
>
>
>Thanks for you help!
>
>
>Erika Foster
>engineering-environmental Management
>Applications Developer
>(505) 866-1654
>[EMAIL PROTECTED]
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 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 such as access. : : Also, "date" is a reserved word, so you'll want to change it in your : database to something like "mydate" or "thisdate." Hm...type might be a : reserved word, too...but I'm not sure on that one. : : Hope that helps you along. : : -Deanna : : : : : Deanna Schneider : Interactive Media Developer : UWEX Cooperative Extension Electronic Publishing Group : 103 Extension Bldg : 432 N. Lake Street : Madison, WI 53706 : (608) 265-7923 : : : : -- : Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 such as access. Also, "date" is a reserved word, so you'll want to change it in your database to something like "mydate" or "thisdate." Hm...type might be a reserved word, too...but I'm not sure on that one. Hope that helps you along. -Deanna Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 syntax error in the following INSERT INTO
> statement - someone with good eyes, please help me out!
>
>
> 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 ('#thisowsid#', '#thistype#', '#thisdate#', '#thiscapacity#',
> '#thislength#',
> '#thiswidth#', '#thisheight#', '#thismanufacturer#', '#thisserial#',
> '#thisdischarge#',
> '#thisrepairs#', '#thisrepairdates#', '#thiscleaning1#',
> '#thiscleaning2#', '#Thiscontractorname#',
> '#thiscontractoraddress#', '#thiscontractorPOC#',
> '#thiscontractorphone#', '#thislicense#',
> '#thissludge#', '#thissample#', '#thislocationid#', '#thissiteid#')
>
>
> gives this result with dummy data:
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
>
>
> 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', 'jkl',
'jk',
> 'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
> 'jk', 'jk', 'jk', 'jk', '02', '27A25')"
>
>
>
> Thanks for you help!
>
>
> Erika Foster
> engineering-environmental Management
> Applications Developer
> (505) 866-1654
> [EMAIL PROTECTED]
>
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Insert INTO syntax error - HELP
Yeah - everything is a string field in this table because it has to be -
OWSID and siteid could both be alphanumeric.
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 3:03 PM
Subject: 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', 'jkl', 'jk', 'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk',
: > 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
: > '02', '27A25')"
:
: Are the owsid and siteid fields string fields? If not, that's probably
your
: problem.
:
: Dave Watts, CTO, Fig Leaf Software
: http://www.figleaf.com/
: voice: (202) 797-5496
: fax: (202) 797-5444
:
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Insert INTO syntax error - HELP
Good chance that you're using some Access reserved words, especially date
and type; you can check Access help for a list of reserved words. Change
the names of any fields that are reserved words.
-Original Message-
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 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!
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 ('#thisowsid#', '#thistype#', '#thisdate#', '#thiscapacity#',
'#thislength#',
'#thiswidth#', '#thisheight#', '#thismanufacturer#', '#thisserial#',
'#thisdischarge#',
'#thisrepairs#', '#thisrepairdates#', '#thiscleaning1#',
'#thiscleaning2#', '#Thiscontractorname#',
'#thiscontractoraddress#', '#thiscontractorPOC#',
'#thiscontractorphone#', '#thislicense#',
'#thissludge#', '#thissample#', '#thislocationid#', '#thissiteid#')
gives this result with dummy data:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
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', 'jkl', 'jk',
'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
'jk', 'jk', 'jk', 'jk', '02', '27A25')"
Thanks for you help!
Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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', 'jkl', 'jk', 'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk',
> 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
> '02', '27A25')"
Are the owsid and siteid fields string fields? If not, that's probably your
problem.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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!
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 ('#thisowsid#', '#thistype#', '#thisdate#', '#thiscapacity#',
'#thislength#',
'#thiswidth#', '#thisheight#', '#thismanufacturer#', '#thisserial#',
'#thisdischarge#',
'#thisrepairs#', '#thisrepairdates#', '#thiscleaning1#',
'#thiscleaning2#', '#Thiscontractorname#',
'#thiscontractoraddress#', '#thiscontractorPOC#',
'#thiscontractorphone#', '#thislicense#',
'#thissludge#', '#thissample#', '#thislocationid#', '#thissiteid#')
gives this result with dummy data:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
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', 'jkl', 'jk',
'jk', 'jk', 'jk;', 'jkl', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk', 'jk',
'jk', 'jk', 'jk', 'jk', '02', '27A25')"
Thanks for you help!
Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
