select where (last question)

Results 1 to 3 of 3

Thread: select where (last question)

  1. #1
    krane Guest

    Default select where (last question)

    rst_DB.Source = "select * from farmacias WHERE Localidade=" & request("DE") & " Order By Nome"<BR><BR>i can&#039;t put this work :(<BR><BR>parameters. Expected 1.<BR>/des_farmacias.asp, line 49<BR><BR>tks

  2. #2
    Eddie Campbell Guest

    Default RE: select where (last question)

    You didn&#039;t do it like I said. You need &#039; quotes around the text field you are seaching for e.g. the reult must read <BR>"Select * from farmacias where localidade=&#039;aveiro&#039; Order By Nome"<BR><BR>so copy this exactly:<BR><BR>rst_DB.Source = "select * from farmacias WHERE Localidade=&#039;" & request("DE") & "&#039; Order By Nome" <BR>

  3. #3
    krane Guest

    Default RE: select where (last question)

    Tks... a l0t :)

Posting Permissions

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