ok here is the query code. i am running spectra.
Queries
qGetRecords (Records=0, Time=0ms)
SQL =
select * from plpinstances
where
plpid
= ?
and
username
= ?
Query Parameter Value(s) -
Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39
Parameter #2 = system
qGetRecords (Records=1, Time=15ms)
SQL =
select * from wddxdata
where
plpid
= ?
Query Parameter Value(s) -
Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39
qGetRecords (Records=0, Time=0ms)
SQL =
select * from plpinstances
where
plpid
= ?
Query Parameter Value(s) -
Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39
----------------------------------------------------------------------------
----
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 01004 (Data truncated)
[Microsoft][ODBC SQL Server Driver]Fractional truncation
SQL = "insert into plpinstances (
dtexpires,plpid,plpinstanceid,username,wddxid ) values ( ? ,? ,? ,? ,? )"
Query Parameter Value(s) -
Parameter #1 = 36651.4121181
Parameter #2 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39
Parameter #3 = 87150BD4-218A-11D4-BF53000629EE5322
Parameter #4 = system
Parameter #5 = 87150BD3-218A-11D4-BF53000629EE5322
Data Source = "slogis"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:67) in the template file
C:\PROGRAM
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_RECORDINSERT_BP.CFM.
-----Original Message-----
From: Fred T. Sanders [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 05, 2000 9:31 AM
To: [EMAIL PROTECTED]
Subject: Re: data truncation??
You'll need to show the query code as well.
----- Original Message -----
From: "AKBAR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 04, 2000 8:25 PM
Subject: data truncation??
> hello everybody,
>
> can anyone plzz tell me wat this error stands for?? i am
not able to proceed
> further.
>
> plzz, tell me the solution for this.
>
> thanx in advance
>
> akbar
>
> Error Diagnostic Information
> ODBC Error Code = 01004 (Data truncated)
> [Microsoft][ODBC SQL Server Driver]Fractional truncation
> The error occurred while processing an element with a
general identifier of
> (CFQUERY), occupying document position (3:1) to (3:67).
>
> ----------------------------------------------------------
--------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the
body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.