Does this work?

Results 1 to 3 of 3

Thread: Does this work?

  1. #1
    Marianne Guest

    Default Does this work?

    typefac = Request.Form("fac")<BR><BR>strSQL = "SELECT * FROM " & typefac & "WHERE ddate = #" & firstDate & "#;" <BR><BR>I has error. if anyone knows how to do the query as above, pls help. or else i might have to do a very very long page consists of many case statement.<BR><BR>

  2. #2
    Eddie Campbell Guest

    Default RE: Does this work?

    I think you need to put a space before the WHERE word. If that doesn&#039t fix it, try doing a response.write strSQL and see what you get.

  3. #3
    Yash Guest

    Default RE: Check the Query Again

    Is ur query same as u have typed ?<BR>"SELECT * FROM " & typefac & "WHERE ddate = #" & firstDate & "#;" <BR><BR>If yes try putting a space before where and/or the variable typefac should be properly parsed using single quotes. I gues ur back end is Access it itz MS SQl server then # wont work<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