[thelist] Cold Fusion problem

Howell, Katie Kathleen.Howell-1 at ksc.nasa.gov
Mon Feb 12 11:29:59 CST 2001

oops....you do need them around dates.....sorry.  And for that boo-boo a

<tip type="coldfusion">
Can't seen to get that blasted insert query to work?  Try inserting just the
first value, if that works add the second etc. until you find which one
you've messed up the syntax on.  Time consuming, but it works.

-----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


 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)
    ('#form.item#', '#form.author#', '#form.pub#', #form.date#,
#form.price#, '#form.condition#', '#form.format#', '#form.cat#',
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

For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt ! 

More information about the thelist mailing list