.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

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

Page 2 - 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 2 of 2 < 1 2
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #16  
Old October 28th, 2009, 09:35 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
I'll just go and sit in the corner and mumble quietly to myself.

Thanks guys, problem solved......
Reply With Quote
  #17  
Old October 28th, 2009, 09:41 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
I'll just go and sit in the corner and mumble quietly to myself.

Thanks guys, problem solved......


It's usually the simple things that really put the spanner in the works!
Reply With Quote
  #18  
Old October 28th, 2009, 09:43 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
Glad its solved now

Its always a good idea first to response.write the variables and query
__________________
Laziness is my religion and Sunday is my God

Get the Mantra!
Reply With Quote
  #19  
Old October 28th, 2009, 10:00 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
Definitely will do from now on.... now i can get back to solving another annoying missing variables problem....
Reply With Quote
  #20  
Old October 28th, 2009, 11:49 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
Glad you sorted out your issue, its usually the simplest things that we miss, but a fresh pair of eyes usually sees the problem!!

I just wanted to point out that you should be able to make your dropdown code more dynamic, eg:
Code:
<%
Dim temp
Function pad(x)
	If Len(x) = 0 Then x = "0" & x
	pad = x
End Function
%>
<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>
	<%
	For temp = 1 to 12
		Response.Write("<option value="" & pad(temp) & "">" & MonthName(temp) & "</option>")
	Next
	%>
</select>
<select name="year" id="year">
	<option>&nbsp;</option>
	<%
	For temp = 0 to 10
		Response.Write("<option value="" & Year(Date) + CInt(temp) & "">" & Year(Date) + CInt(temp) & "</option>")
	Next
	%>
</select>
<input type="submit" value="Go!" />
</div></form>
Reply With Quote
  #21  
Old October 28th, 2009, 12:15 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
Good plan sync, transferred your code over and it promptly gave me a BC30289: Statement cannot appear within a method body. End of method assumed. error on 'function pad(x)'

Any clues?
Reply With Quote
  #22  
Old October 28th, 2009, 12:18 PM
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
Is this .Net you're using?
Reply With Quote
  #23  
Old October 28th, 2009, 12:22 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
Yep, although much of the coding is classic ASP/VBS, thanks to my predecessor coding the whole website completely backwards. Once i've got all the features in I need, i'm going to start the lonnngggg process of getting it all up to scratch, and then some!

Microsoft .NET Framework Version:2.0.50727.42
ASP.NET Version:2.0.50727.42
Reply With Quote
  #24  
Old October 28th, 2009, 12:29 PM
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
OK, I've moved this thread to the .Net forum. With regards the error, this should work but you will need to move the pad function outside of any sub/function that it is in. Try moving it to the top of the page.
Reply With Quote
Reply
Page 2 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 2 Hosted by Hostway. 
For more Enterprise Application Development news, visit eWeek