Re: ADODB Recordset / Text field bug...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Jun 8, 12:58 pm, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
Blue Streak wrote:
This is driving me nuts!!! I have one text field and one varchar
field in my SELECT statement (SELECT * FROM Table...)

http://www.aspfaq.com/show.asp?id=2096

and only the
first line is returning a value from the recordset. For the sake of
this example fieldA is text and fieldB is varchar(250).

So, are we to assume that you are using SQL Server? It appears to be based
on the datatypes. What version of SQL?







I have the statements:

rs("fieldA").Value - I get the value from here
rs("fieldB").Value - This is blank (when I *know* there is data in
it!)

I try it again as:

rs("fieldB").Value - This returns a value
rs("fieldA").Value - This is blank

If I have an Int field or anything else like, rs("IntField").Value, it
returns a value like it should no matter where the line is. However,
it is not true for a text field.

Is this a known bug?
Is there a patch / workaround for this?
What the FUDGE is going on here!?!

Yes, it's a known bug, and it's related to your use of selstar, and, as
seems likely, your use of ODBC. Seehttp://databases.aspfaq.com/database/how-do-i-deal-with-memo-text-hyp...
andhttp://www.aspfaq.com/show.asp?id=2126

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"- Hide quoted text -

- Show quoted text -

Thx.

FYI, I am using MDAC 2.8 and MSDE 2000.

.

Relevant Pages

  • Re: Cross Database Join, C++ program set up confusion
    ... Well what kind of data are you returning if it is not in Recordset? ... Recordset is returned (it is fractionally faster as ADO does not waste time ... If the default database is db1 on the ... It is a function of SQL Server. ...
    (microsoft.public.vc.database)
  • Re: Full-Text Results to MS Access
    ... Being new to SQL Server and ADO, ... (My database was started in pre-ADO days so the Access ... like a true/false flag, a value, etc., but if the result is a recordset, I ... based on some full-text search criteria. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: type argument in OpenRecordset method
    ... For efficiency reasons you should always open the least-functional recordset ... Since you are using SQL Server linked tables, you have a choice of three: ... dbOpenSnapshot: recordset can't be updated, but you can navigate in it. ... Dim strExec As String ...
    (comp.databases.ms-access)
  • Re: Implementation of full text
    ... There is no documented way of accessing the MSSearch catalogs directly other ... tables in SQL Server to identify the row the hit occurs in. ... table to a client from an extended stored procedure. ... To use the recordset returned from the ESP as a virtual table>. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Upsizing issue
    ... >>> half the application because of stupid Recordset problem. ... You could link the SQL Server ... magnitude as modifying the original ASP pages. ...
    (microsoft.public.inetserver.asp.db)