Dreamweaver - fields not showing up in asp (using sql)

Author

fields not showing up in asp (using sql)

lugave

2005-01-24, 7:18 pm

I have converted to an MSSQL database and am able to connect. But some of my
field data is not shoing up in my asp pages, even though they have the same
format. and currency fields are not showing at all.

Tom Muck

2005-01-24, 7:18 pm

"lugave" <webforumsuser@macromedia.com> wrote in message
news:ct3for$n4h$1@forums.macromedia.com...
> I have converted to an MSSQL database and am able to connect. But some of
my
> field data is not shoing up in my asp pages, even though they have the
same
> format. and currency fields are not showing at all.

Is it a text or ntext field? If so, put the fieldname last in your SQL
statement.

--
-------------------------------------------
Tom Muck
co-author Dreamweaver MX 2004: The Complete Reference
http://www.tom-muck.com/

Extending Knowledge, Daily
http://www.CommunityMX.com/

CMBergin

2005-01-24, 7:18 pm

My guess is you converted from Access and you made the mistake of using
"text" fields, thinking they were the same as an Access "text" field.

Your choices are
1.) Change all text fields to varchar fields of an appropriate length (8000
characters max., use the smallest number you can).
2) Continue to use text fields, but when you create your recordset, list
each field you're retrieving (don't use SELECT *), and have all text fields
at the end of the list; if there's more than one, list them from left to
right in the order they're defined in the table.

"lugave" <webforumsuser@macromedia.com> wrote in message
news:ct3for$n4h$1@forums.macromedia.com...
> I have converted to an MSSQL database and am able to connect. But some of
my
> field data is not shoing up in my asp pages, even though they have the
same
> format. and currency fields are not showing at all.
>