So, what was the "incredibly annoying SQL syntax error" ?? Did it give you
any clues? Did you try <CFOUTPUT>ing the text of the query before executing
to make sure it looks right?
-----Original Message-----
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 03, 2000 7:42 PM
To: CF-Talk
Subject: SQL Syntax Error
Hi there,
I've got this whole application running perfecto on my development machine
running CF 4.5.1. I upload it to the web server running 4.01 and I'm
getting this incredibly annoying SQL syntax error on the action page. Can
someone spot what the problem might be??? Much appreciated,
<cfquery name="addrow" datasource="Personnel">
INSERT INTO Tshirt (orderid, style, color, quantity, size)
VALUES (#thisorderid#, #thisstyle#, '#thiscolor#', #thisquantity#,
'#thissize#')
</cfquery>
Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
