Please help!! arrange ....

Results 1 to 3 of 3

Thread: Please help!! arrange ....

  1. #1
    yesterday Guest

    Default Please help!! arrange ....

    Hi,<BR><BR>I was wondering if someone out there could assist me with the following code<BR><BR>rs.Open "news", dbc, adOpenForwardOnly,adLockReadOnly,adCmdTable<BR><BR >I wish to arrange the articles from the news table by its id number,descending to ascending. <BR><BR>I appreciate any help

  2. #2
    Join Date
    Dec 1969

    Default RE: Please help!! arrange ....

    Try this :<BR><BR><BR>rs.Open "SELECT * FROM news ORDER BY id DESC", dbc, adOpenForwardOnly,adLockReadOnly,adCmdText<BR><BR> <BR>MikeD

  3. #3
    Web Developer Guest

    Default RE: Please help!! arrange ....

    change this <BR>rs.Open "news", dbc, adOpenForwardOnly,adLockReadOnly,adCmdTable<BR>to <BR>rs.Open "select articles from news order by ID ASC", dbc, adOpenForwardOnly,adLockReadOnly,adCmdTable<BR><BR ><BR><BR>

Posting Permissions

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