SQL Statement?

Results 1 to 3 of 3

Thread: SQL Statement?

  1. #1
    KevP75@yahoo.com Guest

    Default SQL Statement?

    I have a database of jokes, where the table has 2 fields (Date:Joke). I'm trying to post this on my website, but i want to display one record per day according to the current date. Everything I've tried so far only resulted in me pulling more hair out. PLEASE HELP!!! How can I filter by (current date)???

  2. #2
    <eop> Guest

    Default post your select statement.


  3. #3
    Culture Guest

    Default RE: SQL Statement?

    "select joke from table where jokedate = #" & date() & "# "<BR><BR><BR>If you have "date" as the column name - change it - its a reserved word. Use something like "jokedate"<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