What was the error you were given?

-----Original Message-----
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 8:14 AM
To: CF-Talk
Subject: cfinsert


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=sts 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?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to