SQL (From Learn ASP in 21 Days)

Results 1 to 2 of 2

Thread: SQL (From Learn ASP in 21 Days)

  1. #1
    Join Date
    Dec 1969

    Default SQL (From Learn ASP in 21 Days)

    I am doing BP3 in the Learn Active Server Pages 3.0 in 21 days book by Mitchell and Atkinson.<BR><BR>When I enter the following sql (from Listing BP3.1 [p. 695] I get an error saying "Syntax Error in FROM clause":<BR><BR>strSQL = "SELECT Day, EventTitle FROM Event WHERE Month = " & _<BR>Month(dbCurrentDate) & " AND Year = " & Year(dbCurrentDate) & _<BR>" ORDER BY Day ASC"<BR><BR>I am connecting to the db via Microsoft.Jet.OLEDB.4.0 (to an Access DB).<BR><BR>Any thoughts?

  2. #2
    Papa Zito Guest

    Default RE: SQL (From Learn ASP in 21 Days)

    What is "dbCurrentDate" from?<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