Post reply

text data type retrieval?

  • March 10, 2004 at 2:45 pm

    #161701

    I have 2 databases on the same server that essentially have the same structure and data. One is used for development and one for QA.

    I have a developer trying to query the data from a text field from Cold Fusion MX. The data bigger than 64,000 characters. From Database A (Development), every last bit of the data is returned. But from Database B (QA) only 64,000 characters are returned. Same query, same Cold Fusion template. The only difference is the databases.

    I cannot think of any setting I would have changed to account for the differences in the behavior between the databases. Any ideas?

    Here is the CF query

    SELECT txtSessionPacket

     FROM tblLookupSession

     WHERE CFID = #val(COOKIE.CFID)#

     AND CFTOKEN = '#COOKIE.CFTOKEN#'

     
    Thanks for any help!

  • March 15, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 15, 2004 at 12:46 pm

    #498814

    What happens when you try to retrieve the data without CF?

    GaryA

     

  • March 15, 2004 at 7:36 pm

    #498882

    Cross,

    There is a TEXTSIZE property, which by default is 64KB (i.e. 64,000). Check it on both databases via I belive SELECT @@TEXTSIZE and the way to set it is by SET TEXTSIZE function. Check BOL and hopefully this should resolve your problem. Let me know if it works,

     

    Cheers,

    Digesh

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply