Are these executing in one cfquery block? If so, do you need a command
separator between the statements (mysql uses ";" for example)?
Now, there where two examples of the same tag running but
with different values.
See my follow-up for a solution, but I have a question of why the
solution was
you're sure the second one is bombing? Can you try the page with JUST
that one? Exclude the 1st one. Also vice versa, try the other one the
same way.
Yes, I'm sure. This was a case of the same query being run with
different data. See my follow up on a working solution, but I would
like to know
Ok, I have go it to work, but I would like to know why.
This code works:
UPDATE INTRANET.TRAK_CMP
SET LOC_CODE = '#FORM.LOCCODE#',
CMP_CD = '#newCompCode#',
SCAN_DATE = #CreateODBCDateT
nybody see why the first SQL statement works but the
second throws an error.
UPDATE INTRANET.TRAK_CMP
SET
LOC_CODE = 'ROSE',
CMP_CD = '018251',
SCAN_DATE = {ts '2007-06-13 00:00:00'}
WHERE
USER_ID = 'iskinner' AND
ENTRY_DATE = {ts
you're sure the second one is bombing? Can you try the page with JUST
that one? Exclude the 1st one. Also vice versa, try the other one the
same way.
On 6/13/07, Ian Skinner <[EMAIL PROTECTED]> wrote:
> UPDATE INTRANET.TRAK_CMP
>
> SET
>
> LOC_CODE = 'ROSE',
>
> CMP_CD = '018251',
>
> SCAN_D
UPDATE INTRANET.TRAK_CMP
SET
LOC_CODE = 'ROSE',
CMP_CD = '018251',
SCAN_DATE = {ts '2007-06-13 00:00:00'}
WHERE
USER_ID = 'iskinner' AND
ENTRY_DATE = {ts '2007-06-13 09:28:58'} AND
UNIT_NO = 'FN09427' AND
CMP_CD = '018250'
UPDATE INTRANET.TRAK_CMP
SET
LOC_
6 matches
Mail list logo