Professional Web Applications Themes

CFMX and NTEXT fields - Coldfusion Database Access

I have a SQL table that includes 2 NTEXT fields. When I do a cfquery such as SELECT * FROM MYFILE, I get no value back for these fields. Playing around with it a bit more, the only way I've been able to get values back is if I list all the fields (rather than the metacharacter *) and then only if the NTEXT fields are the last ones in the list. Is there some other way to deal with these fields in CFMX? Server settings? Options? The only NTEXT stuff I've really seen is about having to pre-pend an ...

  1. #1

    Default CFMX and NTEXT fields

    I have a SQL table that includes 2 NTEXT fields. When I do a cfquery such as
    SELECT * FROM MYFILE, I get no value back for these fields. Playing around with
    it a bit more, the only way I've been able to get values back is if I list all
    the fields (rather than the metacharacter *) and then only if the NTEXT fields
    are the last ones in the list.

    Is there some other way to deal with these fields in CFMX? Server settings?
    Options? The only NTEXT stuff I've really seen is about having to pre-pend an
    "N" in front of the value when using CFQUERY to update the field. Haven't found
    anything on pure select.

    Note that this query works fine under CF5, but is giving me fits under CFMX.

    Thanks, in advance, for any help you can give.



    yoderd1956 Guest

  2. #2

    Default Re: CFMX and NTEXT fields

    How big are the NTEXT fields' data?

    Anything over a certain size requires that CLOB (Long Text Retrieval) be
    enabled in the datasource in the CF Administrator. (I think it's actually
    required anyway if you use NTEXT at all, but I can't remember exactly.)

    NTEXT really isn't recommended unless you have no alternative or have no idea
    how long the text could be (and may exceed NVARCHAR's limits). NVARCHAR with a
    high limit value will generally work better.



    SafariTECH Guest

  3. #3

    Default Re: CFMX and NTEXT fields

    Size varies. I believe we originally had nvarchar of 2000 and then someone
    blew through that and instead of making it a bigger nvarchar field, it was
    changed to the ntext. Had worked fine till we loaded CFMX and I started
    testing the page.

    We checked the CLOB option but this doesn't seem to have made a difference.
    That is, if I do select * from.... I still get nothing back for my ntext
    fields, but if I list all fields in the select statement, making sure the ntext
    fields are last, I get the data without a hitch.

    yoderd1956 Guest

  4. #4

    Default Re: CFMX and NTEXT fields

    I'm having the same problem... any solutions? I'm using SQL Server 2005 Express.
    redtopia Guest

Similar Threads

  1. MS SQL 2005 and ntext
    By cheftimo in forum Coldfusion Database Access
    Replies: 3
    Last Post: March 15th, 04:10 AM
  2. Cant get the values from the NTEXT fields
    By ii_bar in forum Coldfusion Database Access
    Replies: 2
    Last Post: October 3rd, 03:36 PM
  3. ntext formatting
    By Darren Woodbrey in forum ASP Database
    Replies: 1
    Last Post: April 22nd, 03:37 AM
  4. how to update and retrieve ntext fields in my asp code
    By el_sherif in forum ASP Database
    Replies: 3
    Last Post: July 31st, 07:38 PM
  5. nText
    By Rocky in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 8th, 12:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139