Skip to main content
CampHeato
Participant
May 27, 2007
Answered

DW 8.02/CS3 and SQL ntext fields

  • May 27, 2007
  • 3 replies
  • 401 views
I am having trouble with ntext fields showing up in my pages. When I test the query inside DW, a single record will show the ntext field value as undefined. If I test a query that returns multiple records, the ntext field value is undefined for the first record, but the other records have the correct values for the ntext field.

I actually found a post that I did 14 months ago in a DW forum, and I answered my own question with a CursorType of 2 or 3. However, DW CS3 commands do not allow this, so now I am back to needing a solution.

I am using the ASP/VBScript Server Model on IIS and Microsoft SQL Server 2000 - 8.00.2039 (Build 3790: Service Pack 1)
This topic is closed to new replies. Start a new post to keep the conversation going.
Correct answer CampHeato
I found this Tech Note, http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=kb00153 after many hours of searching the web. To answer your question, the NTEXT field is now last in the SQL connection, and that solved the problem. The other alternative, so that I did not have to change select statements in all of my queries, was to move the NTEXT field to the last in the table. That way, the SELECT * will work.

The Tech Note suggests a custom connection string, but I have not tried that to see what impact that has.

3 replies

Newsgroup_User
Inspiring
May 29, 2007
In your recordset, is the "ntext" field being called last?




"CampHeato" <webforumsuser@macromedia.com> wrote in message
news:f3b13e$4md$1@forums.macromedia.com...
>I am having trouble with ntext fields showing up in my pages. When I test
>the
> query inside DW, a single record will show the ntext field value as
> undefined.
> If I test a query that returns multiple records, the ntext field value is
> undefined for the first record, but the other records have the correct
> values
> for the ntext field.
>
> I actually found a post that I did 14 months ago in a DW forum, and I
> answered
> my own question with a CursorType of 2 or 3. However, DW CS3 commands do
> not
> allow this, so now I am back to needing a solution.
>
> I am using the ASP/VBScript Server Model on IIS and Microsoft SQL Server
> 2000
> - 8.00.2039 (Build 3790: Service Pack 1)
>


CampHeatoAuthorCorrect answer
Participant
May 29, 2007
I found this Tech Note, http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=kb00153 after many hours of searching the web. To answer your question, the NTEXT field is now last in the SQL connection, and that solved the problem. The other alternative, so that I did not have to change select statements in all of my queries, was to move the NTEXT field to the last in the table. That way, the SELECT * will work.

The Tech Note suggests a custom connection string, but I have not tried that to see what impact that has.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices