Use the quotes around text strings, but not around any number or date values. HTH Katie -----Original Message----- From: Robin Hastings [mailto:hastingsr at mrrl.org] Sent: Monday, February 12, 2001 12:19 PM To: Thelist at Lists. Evolt. Org Subject: [thelist] Cold Fusion problem Hi! I'm having problems with an insert statement in one of my pages that is driving me nuts! I'm getting a "syntax error" and I'm sure it is just the quotes that I'm using, but I've never really understood the use of quotes in SQL - so I can't figure out how to make it work. The statement is: <CFQUERY NAME="insert" DataSource="book"> INSERT INTO tblBook (item, author, pub, date, price, condition, format, cat, desc) VALUES ('#form.item#', '#form.author#', '#form.pub#', #form.date#, #form.price#, '#form.condition#', '#form.format#', '#form.cat#', '#form.desc#') </CFQUERY> This is the latest incarnation - I've tried it a couple of different ways. If anyone can help I'd be eternally grateful!!! I'd send the URL, but it is in a protected directory - you understand... ;) Robin Hastings Webmistress - InterTec Designs robin at intertecdesigns.com http://www.intertecdesigns.com --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !