If the field is marked as text, shouldn't there be ticks around the
variables then?
Like so:
<cfquery name="update2" datasource="ps_skills">
update con_list set note = 'dr'
where userid = #session.userid# and skill = '#form.skill#'
</cfquery>
Is uderid a text field or is skill a text field?
Erika
(with a *K*)
"Whatever you can do, or dream you can, begin it. Boldness has genius,
power, and magic in it." - Goethe
-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 8:08 AM
To: CF-Talk
Subject: RE: Update in CFquery is failing, somone code check this ?
> Off the top of my head it looks like note may be a number field. In
> which case you will get that error if you try to insert anything but
> a number.
Nope, its an Acess ODBC datasource, and the field is marked as text, length
50.
Next :-)
Regards,
Thomas Chiverton
Intranet Architect and Desktop Analyst
01565 757 909
It's not a job, it's an adventure
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
