 | | | Remoting WDDX Packet Truncation | Remoting WDDX Packet Truncation 2004-03-08 - By EECOLOR
Back
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)
Earn $52 per hosting referral at Lunarpages.
|
|
|