Order of SQL large text columns?

Results 1 to 2 of 2

Thread: Order of SQL large text columns?

  1. #1
    Join Date
    Dec 1969

    Default Order of SQL large text columns?

    I&#039;m at the end of my rope here. The following code is doing selects against an SQL database with tables that contain large text fields. The error returned is:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80020009&#039; <BR><BR>Errors occurred <BR><BR>? <BR>In a previous post Moshe referenced<BR>http://support.microsoft.com/support/kb/articles/Q175/2/39.ASP <BR><BR>I&#039;ve looked at the article but still don&#039;t get it. Why after the<BR>first begin - end block of code, if I un-comment any one line in the second block the error referenced above appears. I&#039;m pulling the text fields into the record sets in the column order they appear in the SQL(7.0) table. Note that I created a new page with<BR>just the bare minimum in it, did not output any long text fields to the browser and was able to use both blocks of code. There is something going on with those dang long text fields. <BR><BR>&#060;%<BR>&#039;begin first<BR>sel_asn=Request.Form("f_apusn")<BR>multSQ L = "Select * from APUtrans where APU_SN =&#039;"& sel_asn & "&#039;"<BR>con.open objConn <BR>Set multRST = con.execute (multSQL) <BR>&#039;end first<BR>%&#062;<BR>&#060;%<BR>&#039;begin second<BR>tmp_fail_key=multRST("primary_apu_fail_m ode")<BR>&#039;findSQL = "Select * from wapufail where primary_apu_fail_mode = &#039;" & tmp_fail_key & "&#039;"<BR>&#039;Set findRST = con.execute (findSQL)<BR>&#039;end second<BR>%&#062;<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Order of SQL large text columns?

    See if this helps<BR><BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=80

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts