It's always those quotes and commas that get me!
Good idea on the help....I was not wanting to run the server on my machine
because it's already slowing with PWS and CF running....so I've been
developing against Access, and then uploading to my server (SQL). Guess I
should install it here at least for the help.
Thanks!
D
*************
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-----Original Message-----
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 5:35 PM
To: CF-Talk
Subject: RE: query dates
Don't use the quotes around your datepart in MS-SQL. I just verified that
in the SQL Help; if you haven't installed it, you should.
-----Original Message-----
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 4:15 PM
To: CF-Talk
Subject: query dates
Can someone tell me how to specify part of a date in SQL 2000?
i.e. WHERE DatePart('m',eventdate) = #thismonth#
Worked fine in Access....
Also, until I can get more SQL books, is there a good online resource for
stuff like this? All I can find are basic tutorials and performance tips....
TIA!!
*************
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
