[thelist] Cold Fusion problem

[Howell, Katie]

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 !