[thelist] Cold Fusion problem

Robin Hastings hastingsr at mrrl.org
Mon Feb 12 11:18:14 CST 2001


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






More information about the thelist mailing list