WHERE and date fields

Results 1 to 2 of 2

Thread: WHERE and date fields

  1. #1
    Join Date
    Dec 1969

    Default WHERE and date fields

    I can get this to work with only the first date comparison, but when I add the 2nd ("selected3") it doesn&#039;t:<BR><BR>sql = "SELECT * FROM ServiceStats Where Census &#062;= #" & Request.Form("selected") & "# and Census &#060;= #" & Request.Form("selected3") & "# ORDER by ClientName "<BR><BR>Those darn quotes again. Any thoughts?<BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: WHERE and date fields

    Response.write your sql string prior to trying to execute it, you may not be pulling in a value or something<BR><BR>mj

Posting Permissions

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