.NET Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Programming > .NET Development
Reload this Page

VBScript - Database - Recordset - Filtering by part of stored date?

Discuss Filtering by part of stored date? in the .NET Development forum on ASP Free.
Filtering by part of stored date? .NET Development forum discussing the Microsoft languages including C#, VB.NET, ASP.NET and others. Learn various methods of problem solving unique to the .NET technologies.

Record onscreen activity, your voice & webcam video. Turn everyday presentations into HD-quality videos.

For perfectly clear screencasts every time.
At the IBM® developerWorks Developer Knowledge Center you'll find resources for FREE ekits, Tutorials, Webcasts, Trial Downloads and more.


We cover the world of technology like no one else, constantly updating you with the best information available on open source software, Microsoft technologies, hardware and news from around the world.

Try Camtasia Studio today!
Visit the IBM® Developer Knowledge Center today!
Sign up today!

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Page 1 of 2 1 2 >
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old October 26th, 2009, 09:14 AM
bazzanoid bazzanoid is offline
Contributing User
Click here for more information.
  
Join Date: Nov 2004
Posts: 153 bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 2 Days 17 h 33 m 57 sec
Reputation Power: 7
VBScript - Database - Recordset - Filtering by part of stored date?
Afternoon,

I've tried googling but can't find the appropriate syntax for what i need, felt it best to ask!!

I have a drop down menu that passes month and year variables through a post, i.e. if the user selects January 2010 it will return as the querystring

Quote:
...&month=01&year=2010


In the database table, stored in the 'date' field, is a short date dd/MM/yyyy.

What syntax should i use to finalise this select statement when i want to select all records for the chosen month and year?

Code:
 SELECT * from dailystock WHERE date querystring month and year bit here ORDER BY date DESC


Any advice appreciated!
Reply With Quote
  #2  
Old October 27th, 2009, 05:44 AM
Jonathan8146 Jonathan8146 is offline
Contributing User
ASP Free Intermediate (1500 - 1999 posts)
  
Join Date: Mar 2005
Posts: 1,708 Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 2 Weeks 1 Day 3 h 50 m 45 sec
Reputation Power: 177
Quote:
Originally Posted by bazzanoid
Afternoon,

I've tried googling but can't find the appropriate syntax for what i need, felt it best to ask!!

I have a drop down menu that passes month and year variables through a post, i.e. if the user selects January 2010 it will return as the querystring



In the database table, stored in the 'date' field, is a short date dd/MM/yyyy.

What syntax should i use to finalise this select statement when i want to select all records for the chosen month and year?

Code:
 SELECT * from dailystock WHERE date querystring month and year bit here ORDER BY date DESC


Any advice appreciated!

Something like
Code:
StartDateStr = "1 " & MonthName(Month(month)) & " " & year
EndDate = DateAdd("m",1,StartDate)
EndDateStr = Day(EndDate) & " " & MonthName(Month(EndDate)) & " " & Year(EndDate)

SELECT * from dailystock WHERE date between '" & StartDateStr  & "' and '" & EndDateStr & "'  ORDER BY date DESC
Reply With Quote
  #3  
Old October 27th, 2009, 07:27 AM
sync_or_swim's Avatar
sync_or_swim sync_or_swim is offline
Moderator
Click here for more information.
  
Join Date: Mar 2006
Location: South Wales
Posts: 3,461 sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level) 
Time spent in forums: 2 Months 1 Day 16 h 50 m 26 sec
Reputation Power: 1806
Jonathan's suggestions looks good, I just wanted to add that there are built in functions which allow you to return specifc parts of a date. The syntax is dependant upon the type of database you are using but in SQLServer you can use DatePart:
Code:
SELECT * from dailystock WHERE DATEPART(Month, [date]) = " & Request.Querystring("month") & " " & _
"AND DATEPART(year, [date]) = " & Request.Querystring("year") & " " & _ 
"ORDER BY [date] DESC"

I think that Access uses Month/Year, eg:
Code:
SELECT * from dailystock WHERE Month([date]) = " & Request.Querystring("month") & " " & _
"AND Year([date]) = " & Request.Querystring("year") & " " & _ 
"ORDER BY [date] DESC"

And in Oracle you can use TO_CHAR to specify a date format that ignores days, something like:
Code:
SELECT * from dailystock WHERE TO_CHAR(date, 'MON-YYYY') = '" & MonthName(Request.Querystring("month"), True) & "-" & _
Request.Querystring("year") & "' " & _ 
"ORDER BY date DESC"
Comments on this post
Jonathan8146 agrees: Ooh, much nicer!
Reply With Quote
  #4  
Old October 27th, 2009, 01:13 PM
bazzanoid bazzanoid is offline
Contributing User
Click here for more information.
  
Join Date: Nov 2004
Posts: 153 bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 2 Days 17 h 33 m 57 sec
Reputation Power: 7
Looks good to me sync, I'll give it a whack in the morning when I get to the office.

Thanks!
Reply With Quote
  #5  
Old October 28th, 2009, 07:05 AM
bazzanoid bazzanoid is offline
Contributing User
Click here for more information.
  
Join Date: Nov 2004
Posts: 153 bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 2 Days 17 h 33 m 57 sec
Reputation Power: 7
Using VBScript within asp pages, so a small modification to accept it was needed, and i now get a syntax error:

Code:
objRS = objConn.Execute("SELECT * from dailystock WHERE DATEPART(Month," & Request.Querystring("month") & ") AND DATEPART(year," & Request.Querystring("year") & ") ORDER BY date DESC")
Reply With Quote
  #6  
Old October 28th, 2009, 07:07 AM
sync_or_swim's Avatar
sync_or_swim sync_or_swim is offline
Moderator
Click here for more information.
  
Join Date: Mar 2006
Location: South Wales
Posts: 3,461 sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level) 
Time spent in forums: 2 Months 1 Day 16 h 50 m 26 sec
Reputation Power: 1806
You need to specify the name of your field that contains the date, the format for datepart is DATEPART(datepart, fieldname), try this:
Code:
objRS = objConn.Execute("SELECT * from dailystock WHERE DATEPART(Month,[date]) = " & Request.Querystring("month") & " AND DATEPART(year, [date]) = " & Request.Querystring("year") & " ORDER BY date DESC")
Reply With Quote
  #7  
Old October 28th, 2009, 08:11 AM
bazzanoid bazzanoid is offline
Contributing User
Click here for more information.
  
Join Date: Nov 2004
Posts: 153 bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 2 Days 17 h 33 m 57 sec
Reputation Power: 7
Thanks for the help sync, but unfortunately still a syntax error.... specifically:

Quote:
System.Runtime.InteropServices.COMException: [MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[date]) = AND DATEPART(year, [date]) = ORDER BY date DESC' at line 1




Version info: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Reply With Quote
  #8  
Old October 28th, 2009, 08:18 AM
sync_or_swim's Avatar
sync_or_swim sync_or_swim is offline
Moderator
Click here for more information.
  
Join Date: Mar 2006
Location: South Wales
Posts: 3,461 sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level) 
Time spent in forums: 2 Months 1 Day 16 h 50 m 26 sec
Reputation Power: 1806
You havent said what type of database you are using, is it sqlserver?

Also, can you post the contents of your sql statement so we can see exactly what is being executed?
Code:
Dim sql 
sql = "SELECT * from dailystock WHERE DATEPART(Month,[date]) = " & Request.Querystring("month") & " AND DATEPART(year, [date]) = " & Request.Querystring("year") & " ORDER BY date DESC"
Response.Write(sql)
Response.End
objRS = objConn.Execute(sql)
Reply With Quote
  #9  
Old October 28th, 2009, 08:21 AM
sync_or_swim's Avatar
sync_or_swim sync_or_swim is offline
Moderator
Click here for more information.
  
Join Date: Mar 2006
Location: South Wales
Posts: 3,461 sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level)sync_or_swim User rank is General 12nd Grade (Above 100000 Reputation Level) 
Time spent in forums: 2 Months 1 Day 16 h 50 m 26 sec
Reputation Power: 1806
Having re-read your error message it looks as if you are using MYSQL, if this is the case I think you need to use Day/Month/Year as my Access example. Check out the MYSQL date commands

The more info you give us from the start the better the reply you will get.
Reply With Quote
  #10  
Old October 28th, 2009, 08:54 AM
bazzanoid bazzanoid is offline
Contributing User
Click here for more information.
  
Join Date: Nov 2004
Posts: 153 bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 2 Days 17 h 33 m 57 sec
Reputation Power: 7
Still getting the same syntax error.... i've tried it with and without the '[]' around the date field, still no joy...

Code:
objRS = objConn.Execute("SELECT * from dailystock WHERE Month(date) = " & Request.Querystring("month") & " AND Year(date) = " & Request.Querystring("year") & " ORDER BY date DESC")


This is starting to give me a headache!
Reply With Quote
  #11  
Old October 28th, 2009, 09:03 AM
micky's Avatar
micky micky is offline
Couch Potato Wizard
Click here for more information. Click here for more information
 
Join Date: Jan 2005
Location: India
Posts: 12,259 micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)  Folding Points: 1480 Folding Title: Novice Folder
Time spent in forums: 5 Months 4 Days 2 m 48 sec
Reputation Power: 2179
Quote:
Originally Posted by bazzanoid
Thanks for the help sync, but unfortunately still a syntax error.... specifically:

Version info: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
So this is a .NET question!!

Anyway, post the output of the query here and if you can, then run it in MySql's query runner.
__________________
Laziness is my religion and Sunday is my God

Get the Mantra!
Reply With Quote
  #12  
Old October 28th, 2009, 09:04 AM
Jonathan8146 Jonathan8146 is offline
Contributing User
ASP Free Intermediate (1500 - 1999 posts)
  
Join Date: Mar 2005
Posts: 1,708 Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 2 Weeks 1 Day 3 h 50 m 45 sec
Reputation Power: 177
Quote:
Originally Posted by bazzanoid
Still getting the same syntax error.... i've tried it with and without the '[]' around the date field, still no joy...

Code:
objRS = objConn.Execute("SELECT * from dailystock WHERE Month(date) = " & Request.Querystring("month") & " AND Year(date) = " & Request.Querystring("year") & " ORDER BY date DESC")


This is starting to give me a headache!


Write out your query string before attempting to execute it to make sure there is noting wrong with it
Code:
Response.Write "SELECT * from dailystock WHERE Month(date) = " & Request.Querystring("month") & " AND Year(date) = " & Request.Querystring("year") & " ORDER BY date DESC"
Reply With Quote
  #13  
Old October 28th, 2009, 09:24 AM
bazzanoid bazzanoid is offline
Contributing User
Click here for more information.
  
Join Date: Nov 2004
Posts: 153 bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level)bazzanoid User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 2 Days 17 h 33 m 57 sec
Reputation Power: 7
Thanks Jon - turns out the form isn't submitting the inputted month/year data... works fine if i manually type in the querystring to the url.

If anyone has a clue why this isn't passing the month and year through the url, please enlighten me!! works fine on every other page!!

Code:
<form action="stocktotals.aspx?filter=yes" method="post" name="filter">
<div align="center">Filter historical data by date range<br />
<select name="month" id="month">
	<option>&nbsp;</option>
	<option value="01">January</option>
	<option value="02">February</option>
	<option value="03">March</option>
	<option value="04">April</option>
	<option value="05">May</option>
	<option value="06">June</option>
	<option value="07">July</option>
	<option value="08">August</option>
	<option value="09">September</option>
	<option value="10">October</option>
	<option value="11">November</option>
	<option value="12">December</option>
</select>
<select name="year" id="year">
	<option>&nbsp;</option>
	<option value="2009">2009</option>
	<option value="2010">2010</option>
	<option value="2011">2011</option>
	<option value="2012">2012</option>
	<option value="2013">2013</option>
	<option value="2014">2014</option>
	<option value="2015">2015</option>
	<option value="2016">2016</option>
	<option value="2017">2017</option>
	<option value="2018">2018</option>
	<option value="2019">2019</option>
</select>
<input type="submit" value="Go!" />
</div></form>
Reply With Quote
  #14  
Old October 28th, 2009, 09:26 AM
Jonathan8146 Jonathan8146 is offline
Contributing User
ASP Free Intermediate (1500 - 1999 posts)
  
Join Date: Mar 2005
Posts: 1,708 Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level)Jonathan8146 User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 2 Weeks 1 Day 3 h 50 m 45 sec
Reputation Power: 177
Quote:
Originally Posted by bazzanoid
Thanks Jon - turns out the form isn't submitting the inputted month/year data... works fine if i manually type in the querystring to the url.

If anyone has a clue why this isn't passing the month and year through the url, please enlighten me!! works fine on every other page!!

Code:
<form action="stocktotals.aspx?filter=yes" method="post" name="filter">
<div align="center">Filter historical data by date range<br />
<select name="month" id="month">
	<option>&nbsp;</option>
	<option value="01">January</option>
	<option value="02">February</option>
	<option value="03">March</option>
	<option value="04">April</option>
	<option value="05">May</option>
	<option value="06">June</option>
	<option value="07">July</option>
	<option value="08">August</option>
	<option value="09">September</option>
	<option value="10">October</option>
	<option value="11">November</option>
	<option value="12">December</option>
</select>
<select name="year" id="year">
	<option>&nbsp;</option>
	<option value="2009">2009</option>
	<option value="2010">2010</option>
	<option value="2011">2011</option>
	<option value="2012">2012</option>
	<option value="2013">2013</option>
	<option value="2014">2014</option>
	<option value="2015">2015</option>
	<option value="2016">2016</option>
	<option value="2017">2017</option>
	<option value="2018">2018</option>
	<option value="2019">2019</option>
</select>
<input type="submit" value="Go!" />
</div></form>

Because you're using method="post" and you should be using method="get".

For Post use Request.Form
For Get use Request.QueryString
Comments on this post
micky agrees!
Reply With Quote
  #15  
Old October 28th, 2009, 09:27 AM
micky's Avatar
micky micky is offline
Couch Potato Wizard
Click here for more information. Click here for more information
 
Join Date: Jan 2005
Location: India
Posts: 12,259 micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)micky User rank is General 18th Grade (Above 100000 Reputation Level)  Folding Points: 1480 Folding Title: Novice Folder
Time spent in forums: 5 Months 4 Days 2 m 48 sec
Reputation Power: 2179
You are using POST in your form method, so you should use
Request.Form("month")
Reply With Quote
Reply
Page 1 of 2 1 2 >

Viewing: ASP Free Forums > Programming > .NET Development > VBScript - Database - Recordset - Filtering by part of stored date?

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump





 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.
 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.
 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.
 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.
 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 Hosted by Hostway. 
For more Enterprise Application Development news, visit eWeek