Alphabetizing

Results 1 to 2 of 2

Thread: Alphabetizing

  1. #1
    rbenedict Guest

    Default Alphabetizing

    How can I sort a database when displaying it on my webpage? I currently have:<BR>sqlstmt = "SELECT * from inventory order by Product Name"<BR>rs.open sqlstmt, connectme<BR><BR>But I get an error when I try to view the page:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression &#039Product Name&#039. <BR><BR>/inventory.asp, line 13 <BR><BR>Any help?<BR>Raymond<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    13

    Default RE: Alphabetizing

    you may want to try bracketing the column name:<BR>[Product Name]<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
  •