Get the value of the vars and run it directly in the db so you get a
meaningfull error message
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: 01 May 2001 13:26
To: CF-Talk
Subject: RE: Update in CFquery is failing, somone code check this ?
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
