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_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_CODE = 'ROSE',
>
> CMP_CD = 'E03360',
>
> SCAN_DATE = {ts '2007-06-13 00:00:00'}
>
>
>
> WHERE
>
> USER_ID = 'iskinner' AND
>
> ENTRY_DATE = {ts '2007-06-13 09:03:43'} AND
>
> UNIT_NO = 'W115905000001' AND
>
> CMP_CD = 'E0929W'
>
>
>
> The second statement throws this error: "[Macromedia][Oracle JDBC
> Driver][Oracle]ORA-00942: table or view does not exist" but as the first
> statement works just fine, I must assume that some other issue is at
> play here.
>
>
>
>
>
>
> Confidentiality Notice: This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281056
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
