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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to