|
Home > Archive > IIS ASP > June 2006 > Changing order of recordsets creates non results
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Changing order of recordsets creates non results
|
|
|
| Hi,
I have used ASP for years using MS Access and have used MSSQL quite a lot as
well. I have never came across something like this before.
MSSQL table names and types:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc
When I have the recordset in the order as follows, all works well:
(Recordset2.Fields.Item("ProductName").Value)
(Recordset2.Fields.Item("ShortDescription").Value)
(Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does'nt show.
Anybody got any ideas on this?
Kindest regards,
Kevin
| |
| Aaron Bertrand [SQL Server MVP] 2006-06-21, 7:21 pm |
| http://www.aspfaq.com/2188
"Kevin" <kmickl@yaoo.com> wrote in message
news:eTtV8LXlGHA.3740@TK2MSFTNGP02.phx.gbl...
> Hi,
> I have used ASP for years using MS Access and have used MSSQL quite a lot
> as well. I have never came across something like this before.
>
> MSSQL table names and types:
>
> ProductName nvarchar
> ShortDescription nText
> ThumbNail nvarchar
> etc
>
> When I have the recordset in the order as follows, all works well:
> (Recordset2.Fields.Item("ProductName").Value)
> (Recordset2.Fields.Item("ShortDescription").Value)
> (Recordset2.Fields.Item("Thumbnail").Value)
>
> Though if I have the Thumbnail first the description does'nt show.
>
> Anybody got any ideas on this?
>
> Kindest regards,
> Kevin
>
>
|
|
|
|
|