Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Need Help With Date Math		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

AliasMoze
New Member

USA
55 Posts
Posted - 07 August 2002 :  07:06:59  Show Profile  Visit AliasMoze's Homepage
I'm putting together a SQL query, and I need help.

I'm getting two variables from the user (via queryString) -- these are month and year.

What I want to do is limit the results to the topics that were posted within this month and year. Alas, my ASP kung fu is no good, and I have no idea how to do this.

Thanks, in advance, for the help:)

AliasMoze
"That activates my hilarity unit."

Edited by - AliasMoze on 07 August 2002 07:07:53

Kat
Advanced Member

United Kingdom
3065 Posts
Posted - 07 August 2002 :  07:46:00  Show Profile  Visit Kat's Homepage
Select Month, Year from <table> WHERE month = month(Now) AND year = year(Now)

pseudo-code above should give you an idea.

KatsKorner

Installation Help | Snitz Mods | Forum Hosting
Go to Top of Page

AliasMoze
New Member

USA
55 Posts
Posted - 07 August 2002 :  09:04:24  Show Profile  Visit AliasMoze's Homepage
I'm actually trying to get topics with dates that match a particular month, say March of 2000.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07