Cant get the values from the NTEXT fields

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Cant get the values from the NTEXT fields

    Unfortunately I have to use the ODBC driver in order to connect to the SQL 2000
    personal edition on my development workstation. but this is still causing
    problems...

    My sql statement within the cfquery tag is simply a select * from [table], but
    when I try to output the ntext field it is blank... When I check the database
    value it has content... please help...

    ii_bar Guest

  2. Similar Questions and Discussions

    1. Add values of two fields
      Good day, I just want to know if it is possible using developers toolbox to sum values of two fields (field1 + field2 =field3) where field3 is the...
    2. 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...
    3. Adding values from various fields..
      Hello, i'm trying to add a few values from multiple fields from 1 table. like: field a1 = 10 field a2 = 12 field a3 = 15 field a4 = 3
    4. Concatenate fields with no values
      I am running CF 5 with SQL Server 2000. I am looking to concatenate a person name, but not all names have a suffix or middle name. Sample SQL:...
    5. how to update and retrieve ntext fields in my asp code
      how to update and retrieve ntext fields in my asp code PLEASE HELP
  3. #2

    Default Re: Cant get the values from the NTEXT fields

    see -

    [url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=1027433&highlight _key=y&keyword1=ntext[/url]
    cf_jimmy Guest

  4. #3

    Default Re: Cant get the values from the NTEXT fields

    Thanks!!!
    ii_bar Guest

Posting Permissions

  • You may not post new threads
  • You may 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