the question mark is really there?
----- Original Message -----
From: "AKBAR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 04, 2000 8:44 PM
Subject: RE: data truncation??
> 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\_RECORDI
NSERT_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=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=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.