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.