Archive of:
 CF-Talk
Cold Fusion - Technical
home
24 hour view
quick stats
weekly updates
all tallylists
corporate solutions
archive your favorite
help / feedback
About Cold Fusion :
product's home
product's list home
|
|
Archived TallyList / CF-Talk:
Subject: Re: Update in CFquery is failing, somone code check this ?
 Bud (237p/+2r) Posted: Tuesday 01 May 2001
This post: 88 views, +0 rating
On 5/1/01, Thomas Chiverton penned: >I have: ><cfquery name="update2" datasource="ps_skills"> >update con_list set note = 'dr' where userid = #session.userid# and skill = >#form.skill# ></cfquery> >And it is dieing with: >ODBC Error Code = 37000 (Syntax error or access violation) >[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. >SQL = "update con_list set note = 'dr' where userid = 32715281 and skill = >1"
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. --
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development buddy@twcreations.com http://www.twcreations.com/ 954.721.3452
Similar Subject Line Posts (+/- two weeks of this post)
| FW: Update in CFquery is failing, somone code check this ? FIXED | 02 May 2001 |
(55 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(60 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(56 v/ +0 r) |
| Re: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(53 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? FIXED | 01 May 2001 |
(66 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(60 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(59 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(60 v/ +0 r) |
| Re: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(61 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? FIXED | 01 May 2001 |
(49 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(59 v/ +0 r) |
| OT: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(57 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(53 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(56 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(54 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(50 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(57 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(68 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(57 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(50 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(59 v/ +0 r) |
| Re: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(57 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(59 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(54 v/ +0 r) |
| RE: Update in CFquery is failing, somone code check this ? | 01 May 2001 |
(56 v/ +0 r) |
| Send a reply to the CF-Talk list! |
 |
NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!) |
|
