[thelist] Cold Fusion problem

[Howell, Katie]

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

<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.
</tip>


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