How's about cutting and pasting the error, along with the debug
outputted query.
J
On Fri, 03 Nov 2000 08:13:45 -0800, in cf-talk you wrote:
>I was using the following query:
>
><cfquery name="AddUser" datasource="NOW">
>INSERT INTO Users
>(First,Last,Ride,Fav_Place)
>VALUES('#First#','#Last#','#Ride#','#Fav_Place#')
></cfquery>
>
>But it was giving me an error. None of the fields are numeric, they are all texted
>fields. But when I used the following query:
>
><cfinsert tablename="Users" datasource="NOW">
>
>This one worked, but why didn't they other one?
>
>Jeremy
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
>with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
