Notice the quotes I added around #insol.name#. Try it. Although
I don't think it should make a difference, I'd swap the where
condition too. As below:
cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC"
UPDATE JobInfoUpload
SET CheckedOut='Yes',
Where JobInfoUpload.FileID = '#URL.FileID#'
/cfquery
- - - Jeanne
- Original Message -
From: "Chad Gray" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 30, 2000 11:51 AM
Subject: UPDATE on a MS Access Database
Im trying a UPDATE on a A
to lose the single quotes on this one - is it a numeric
field?)
Also, try replacing 'Yes' with True (no quotes)
Bob
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database
Im trying a UPDATE
UPDATE JobInfoUpload
SET CheckedOut='Yes', cfoutputCheckedOutBy='#InSol.Name#'
WHERE FileID = #URL.FileID#/cfoutput
-David
On Thu, 30 Nov 2000 11:51:48 -0500 Chad Gray [EMAIL PROTECTED] writes:
Im trying a UPDATE on a Access database, and im getting an error
cfquery name="addtoCJM"
PROTECTED]]
Sent: Thursday, November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database
Im trying a UPDATE on a Access database, and im getting an error
cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC"
UPDATE JobInfoUploa
Im trying a UPDATE on a Access database, and im getting an error
cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC"
UPDATE JobInfoUpload
SET CheckedOut='Yes', cfoutputCheckedOutBy=#InSol.Name#
Where '#URL.FileID#' = JobInfoUpload.FileID/cfoutput
/cfquery
and #URLFileID# around. Field names come first.
HTH
Brandon
Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access
Chad,
Is your last line of code switched around? Should it read
Where JobInfoUpload.FileID = '#URL.FileID#'
instead?
Mark
Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD 20708-4038
Ph:
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 30, 2000 11:51 AM
Subject: UPDATE on a MS Access Database
| Im trying a UPDATE on a Access database, and im getting an error
|
|
| cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC"
|
here))
Eron
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database
Im trying a UPDATE on a Access database, and im
getting an error
cfquery name="addtoCJM" datasource="
Horwith
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 220
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a
ber 30, 2000 5:51 PM
Subject: UPDATE on a MS Access Database
Im trying a UPDATE on a Access database, and im getting an error
cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC"
UPDATE JobInfoUpload
SET CheckedOut='Yes', cfoutputChe
1 AM
Subject: UPDATE on a MS Access Database
Im trying a UPDATE on a Access database, and im getting an error
cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC"
UPDATE JobInfoUpload
SET CheckedOut='Yes', cfoutputChec
De: Chad Gray [SMTP:[EMAIL PROTECTED]]
Date: Thursday, November 30, 2000 11:52 AM
À: CF-Talk
Objet:UPDATE on a MS Access Database
Im trying a UPDATE on a Access database, and im getting an error
cfquery name="addtoCJM" datasource="CJM.mdb" dbtype=&
Message d'origine-
De: Chad Gray [SMTP:[EMAIL PROTECTED]]
Date: Thursday, November 30, 2000 11:52 AM
À: CF-Talk
Objet:UPDATE on a MS Access Database
Im trying a UPDATE on a Access database, and im getting an error
cfquery name="addtoCJM" datasource=
iginal Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database
Im trying a UPDATE on a Access database, and im getting an error
cfquery name="addtoCJM" datasource="CJM.mdb" dbtype
16 matches
Mail list logo