 | | | Solved: Remoting WDDX Packet Truncation | Solved: Remoting WDDX Packet Truncation 2004-03-10 - By Richard
Back
Thought I'd better post this for the archive incase anyone else encounters
it.
To do with any truncation occurring when inserting large amounts of data
such as WDDX packets into a database such as SQL2000. The problem was
narrowed down to Coldfusion, in the CFadmin DataSources section you can
specify the max size for a given DataSource's "Long Text" field, which by
default is 64kb, same for "Blob's" even tho the DB is already fine.
Hope that helps anyone...
-- -- Original Message -- --
From: "EECOLOR" <eecolor@(protected)>
To: <flashcoders@(protected)>
Sent: Monday, March 08, 2004 1:29 PM
Subject: Re: [Flashcoders] Remoting WDDX Packet Truncation
> Do u see the all of the data when u return it to Flash Directly?
>
> In the 'online books' of SQL 2000 i found:
>
>
>
> Handling Larger Data Values
>
> When the ntext, text, and image data values get larger, however, they must
> be handled on a block-by-block basis. Both Transact-SQL and the database
> APIs contain functions that allow applications to work with ntext, text,
> and image data block by block.
>
> The database APIs follow a common pattern in the ways they handle long
> ntext, text, and image columns:
> * To read a long column, the application simply includes the ntext,
> text, or image column in a select list, and then binds the column to a
> program variable large enough to hold a reasonable block of the data. The
> application then executes the statement and uses an API function or method
> to retrieve the data into the bound variable one block at a time.
> * To write a long column, the application executes an INSERT or UPDATE
> statement with a parameter marker (?) in the place of the value to be
> placed in the ntext, text, or image column. The parameter marker (or
> parameter in the case of ADO) is bound to a program variable large enough
> to hold the blocks of data. The application goes into a loop where it
first
> moves the next set of data into the bound variable, and then calls an API
> function or method to write that block of data. This is repeated until the
> entire data value has been sent.
>
> Greetz Erik
>
> At 13:19 8-3-2004, you wrote:
> >I was hoping it would be that but unfortunately not :( The fields are of
> >type "Text", SQL2000).
> >
> >-- -- Original Message -- --
> >From: "EECOLOR" <eecolor@(protected)>
> >To: <flashcoders@(protected)>
> >Sent: Monday, March 08, 2004 12:11 PM
> >Subject: Re: [Flashcoders] Remoting WDDX Packet Truncation
>
>
> =-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> Supported by Fig Leaf Software
> =-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> Be sure to check the archives and the wiki:
> http://chattyfig.figleaf.com/
> =-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> http://chattyfig.figleaf.com/cgi-bin/ezmlm-cgi?1:mss:106298
> =-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> To unsubscribe send a blank e-mail to:
> Normal Mode: flashcoders-unsubscribe@(protected)
> Digest Mode: flashcoders-digest-unsubscrive@(protected)
>
>
=-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
Supported by Fig Leaf Software
=-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
Be sure to check the archives and the wiki:
http://chattyfig.figleaf.com/
=-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
http://chattyfig.figleaf.com/cgi-bin/ezmlm-cgi?1:mss:106514
=-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
To unsubscribe send a blank e-mail to:
Normal Mode: flashcoders-unsubscribe@(protected)
Digest Mode: flashcoders-digest-unsubscrive@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|