Problem with Access database and SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm having a problem editing the code using Frontpage 2003 to allow me to do
this:

fp_sQry="SELECT * FROM Services WHERE Week = " & DatePart("ww", Date)

Unfortunately when I edit the (grey) code I can't seem to arrive at a
similar solution. What I get it something like ...DatePart(""ww"",Date)
which won't work.

I am trying to compare the week number of the year against the week value in
the database to make the page always current.

Thanks.
 
First, I hope you're not hand-modifying DRW code. FP will "correct" that and
overwrite it at random. Instead, specify a custom query on page 2 of the
wizard.

As to your SQL statement, I think you need DatePart("ww", Date())

Note the () after Date().

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
Back
Top