What is the text of the error message?
As CFINSERT just inserts whatever fields are passed to it, my guess is that
one of '#First#','#Last#','#Ride#','#Fav_Place#' is not being passed to the
template.
Bob
-----Original Message-----
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: November 3, 2000 11: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]
