Problem with an sql

Results 1 to 2 of 2

Thread: Problem with an sql

  1. #1
    Join Date
    Dec 1969

    Default Problem with an sql

    When I use the following statement:<BR><BR>sql = "SELECT Catalog.Product, Catalog.Description, Catalog.PartNumber, Catalog.YearBegin, Catalog.YearEnd, Catalog.OurPrice FROM [Catalog] WHERE (((Catalog.Product) Like &#039;" & Request.QueryString("Brand") &"*&#039;) AND ((Catalog.Model)=&#039;" & Request.QueryString("Model") & "&#039;)) ORDER BY Product"<BR><BR>no records are being returns, but the problem is that both of the querystrings are controlled as to always return some sort of the value.<BR><BR>I think the problem lies in the "Like" arguement because I want to bring back any records that begin with the same characters.<BR><BR>I&#039;m sorry if that was confusing. Please help.

  2. #2
    Join Date
    Dec 1969

    Default RE: Problem with an sql

    try using % instead of *<BR><BR>if that doesn&#039;t work, response.write the sql string, and see if everything is correct.

Posting Permissions

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