Re: UPDATE on a MS Access Database

2000-12-01 Thread Jeffry Houser
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',

Re: UPDATE on a MS Access Database

2000-12-01 Thread Jeanne Sarfaty Glazer
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

RE: UPDATE on a MS Access Database

2000-12-01 Thread Bob Silverberg
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

Re: UPDATE on a MS Access Database

2000-12-01 Thread David Shadovitz
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"

RE: UPDATE on a MS Access Database

2000-12-01 Thread Christopher Olive, CIO
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

UPDATE on a MS Access Database

2000-11-30 Thread Chad Gray
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

RE: UPDATE on a MS Access Database

2000-11-30 Thread Brandon Behrens
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

Re: UPDATE on a MS Access Database

2000-11-30 Thread mark_wimer
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:

Re: UPDATE on a MS Access Database

2000-11-30 Thread Todd Ashworth
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" |

RE: UPDATE on a MS Access Database

2000-11-30 Thread Eron Cohen
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="

RE: UPDATE on a MS Access Database

2000-11-30 Thread Simon Horwith
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

Re: UPDATE on a MS Access Database

2000-11-30 Thread cf-talk
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

Re: UPDATE on a MS Access Database

2000-11-30 Thread Chris Michl
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

RE: UPDATE on a MS Access Database

2000-11-30 Thread Gilles Ratte
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=&

RE: UPDATE on a MS Access Database

2000-11-30 Thread Gilles Ratte
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=

RE: UPDATE on a MS Access Database

2000-11-30 Thread Doug Powell
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