UPDATE JobInfoUpload
SET CheckedOut='Yes', CheckedOutBy='#InSol.Name#'
WHERE FileID = #URL.FileID#
-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
>
>
>
> UPDATE JobInfoUpload
>
well, you do have your where clause reversed, and with apostrophes. is it a
numeric field? if so, take out the 's, reverese it, and you should be good.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Chad Gray [mailto:[EMAIL P
I think you need single quotes around the second value you are setting, and
your where clause looks backwards:
Change: CheckedOutBy=#InSol.Name#
To: CheckedOutBy='#InSol.Name#'
Change: Where '#URL.FileID#' = JobInfoUpload.FileID
To: Where JobInfoUpload.FileID = '#URL.FileID#'
(You may need to lo
Actually the problem is with your s
You don't need them within
Try this:
UPDATE JobInfoUpload
SET CheckedOut = 'Yes',
CheckedOutBy = #InSol.Name#
Where JobInfoUpload.FileID = '#URL.FileID#'
- - - Jeanne
- Original Message -
From: "Chad G
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:
UPDATE JobInfoUpload
SET CheckedOut='Yes',
CheckedOutBy='#InSol.Name#'
Where JobInfoUpload.Fil
Switch the where statement to
UPDATE JobInfoUpload
SET CheckedOut='Yes',
CheckedOutBy=#InSol.Name#
Where JobInfoUpload.FileID = '#URL.FileID#'
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 1
or maybe this (use field = value):
UPDATE JobInfoUpload
SET CheckedOut='Yes', CheckedOutBy=#InSol.Name#
Where JobInfoUpload.FileID = '#URL.FileID#'
> -Message d'origine-
> De: Chad Gray [SMTP:[EMAIL PROTECTED]]
> Date: Thursday, November 30, 2000 11:52 A
try this:
UPDATE JobInfoUpload
SET CheckedOut=1, CheckedOutBy=#InSol.Name#
Where '#URL.FileID#' = JobInfoUpload.FileID
> -Message d'origine-
> De: Chad Gray [SMTP:[EMAIL PROTECTED]]
> Date: Thursday, November 30, 2000 11:52 AM
> À:CF-Talk
> Objet:
Do you have your clause flip-flopped?
Where '#URL.FileID#' = JobInfoUpload.FileID
Should be:
Where JobInfoUpload.FileID='#URL.FileID#'
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 10:51 AM
Subject: UPDAT
Chad, are you sure, you have the right datasourcename ?
It looks more like the raw DB-name you used.
Uwe
Mail: [EMAIL PROTECTED]
WWW: www.sdsolutions.de
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 5:51 PM
you don't need the cfoutputs in the query, just the # signs will do, and you
probably need single quotes around #insol.name#. Also, if
JobInfoUpload.FileID is a numeric field then you need to remove the single
quotes from #URL.FileID#. Also, I'd reverse the where clause parameters to
make it mor
Chad, you probably just need single quotes around
'#InSol.Name#' Single quotes let the database know
that you are inserting a string, for instance into a
TEXT field. They're easy to forget by mistake.
(and you may also be missing a (but that's
not likely the cause of your problem here))
Eron
You don't need the s inside of a .
Also, you need single quotes around #InSol.name#, or else the database
thinks "chad" is a field name and will compain when it can't find it.
Todd Ashworth
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent
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: 301-497-
Here are a couple of things. When you get too few parameters, you have
messed up your SQL statement: here is where you messed up:
Checkedoutby needs single quotes around it like checked out.
I don't know if this is mandatory or not, but you might want to switch
JobInfoUpload.FileID and #URLFil
15 matches
Mail list logo