SQL results (Chapter 20)

Results 1 to 2 of 2

Thread: SQL results (Chapter 20)

  1. #1
    Join Date
    Dec 1969

    Default SQL results (Chapter 20)

    In Chapter 20, I create the Products database with the exact inventory listed in the book. When I run the example ASP code I come out with different results than what the book shows. For example, when I run the SQL code "SELECT * FROM Products WHERE Price <= '100' ORDER BY Price DESC" only 1 product that is under $100 returns from the database when in there are actually 6 under $100. Please help... Thank you

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL results (Chapter 20)

    I guess you use a string in stead of a Numeric field.<BR>Try:<BR>WHERE val(Price) &#060;= 100<BR><BR>Vinzz

Posting Permissions

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