Results 1 to 5 of 5

Thread: ORDER BY

  1. #1
    Nathan Masek Guest

    Default ORDER BY

    Ok ... I use a crappy OLE-DB driver with my ASP because I use this weird kind of database. Problem is, it doesnt support ORDER BY. SO if I want to do ORDER BY in my SQL then I have to use my ODBC driver. That brings up a couple new problems. The ODBC driver first is VERY slow (literally like 10 times slower than OLE-DB). Second, it doesnt work well with WHERE clauses.<BR><BR>So what I want to do is ALWAYS use my OLE-DB driver. <BR>Does anyone know of another way to order a recordset without using the ORDER BY statement?<BR><BR>- Thanks<BR>- Nathan Masek

  2. #2
    Heaven's Martini Guest

    Default RE: ORDER BY

    sure.<BR><BR>I would pull your rs into getrows (recordset into an array)<BR><BR>then sort the array.<BR><BR>I have the sort code for a 2-d array that is built with getrows if you so desire.

  3. #3
    Join Date
    Dec 1969

    Default I do ...

    I do desire!<BR>Gimme Gimme Gimme ::Hands outstretched - fingers wiggling::<BR>=]

  4. #4
    Heaven's Martini Guest

    Default send mail

    send me an email,<BR><BR>it would get all mangled in this forum<BR><BR>composer[at].emeraldsys[dot]com

  5. #5
    Heaven's Martini Guest

    Default editted version


Posting Permissions

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