I'm completely stumped on how to write a loop for this.
I want to generate a dynamic list of links (years) and another of months based on the publish dates i have in my database. So if a month is not present the code would omit it.
I have two dates, example would be 10/1/2006 and the current date 9/8/2007. How would I loop through and print out every month between these two dates with the year?
October 2006
November 2006
December 2006
January 2007
etc...
September 2007
Been playing with the function DateDiff, and with it it's easy to calculate the difference in years/months/days between two dates. However, if i wanted to calculate the difference in Years, Months, Days, Hours, Seconds (a la Ebay bids) how can I do this? Is it easy or complicated?
View Replies View RelatedI'm trying to see all the records in the database older than 2 years from today, and I can't seem to be getting it to go.
SELECT * FROM comments WHERE (currentdate < 2002 - 07 - 20) ORDER BY
currentdate
I get null records returned, even though I can see some records as old as 1995. When I run the command like this however, it returns all the rows.
SELECT * FROM comments WHERE (currentdate > 2002 - 07 - 20) ORDER BY
currentdate
I'm creating a site that pulls details from a database & display it on screen. Problem is that there's sometimes loads of data which makes the page huge. What I want it to do is display ten and a next page link to display the next ten. Like the way Google displays results. Problem is I don't know how to generate pages on the fly. So the question is can it be done and does ne1 know how to do it?
View Replies View RelatedI'm using the input File method for users to upload their files to a folder on a website, I wanted to store the filename in the database but the information that is produced from the input File is an absolute path to the file on the users system (ie. c:/usersfolder/usersfile.doc)
where as I only want the filename (usersfile.doc). I am presuming that this is going to be a Split method but is there a decent place to find a tutorial on this. I've had a good google but can't seem to find anything.
is it possible to seperate the values in a textarea in ASP ?
sentence number 1 is by example: Car
sentence number 2 is by example: truck
when i post the asp page ( and form offcourse ) both car and truck is putted in one thing(string)
How can i seperate the two at the receiving asp page:
this is the idea ( syntax is bull**** )
frankie(1) = Request.Form("kindoftransportation[1]")
frankie(2) = Request.Form ("kindoftransportation[2]")
OR do i need javascript to this kind of stuff?
I'm supposed to make a presentation of ASP+/ASP.NET but the problem is: I haven't found any good material I don't want any M$-propaganda... I'm not looking for coding examples, but articles which would help me to introduce the technology to people that have never heard of it.
I haven't done ASP.NET much myself and that's why I'd like to find some material to read - to find out is it worth moving from ASP to ASP+.
I am building a site in which users will submit articles. Like a cms. However, I want the ability for articles that are over one page long to span or continue on the next page. That is, a link is provided at the end of page 1 that links to page 2 etc of same article?
View Replies View RelatedDoes anyone have codes or articles related how to make Yahoo-like directory-based serach engine which the categories of the post can be change from one to another, theoretically expandable to unlimited level of directories, etc.
View Replies View Relatedi'm trying to count how many months there are between 2 dates... and the dates look like this
7/1/2004
8/1/2004
9/1/2004
10/1/2004
11/1/2004
12/1/2004
1/1/2005
2/1/2005
its 4 drop down box's looks like this
From: |Month drop down | |Year| To: | month drop down| |Year| ..
I'm currently working for a website that has over 20,000 articles that we're looking to clean up. Ultimately we'd like to have our content seperated from our html and graphics so that we can always manipulate it in any way we want.
Any suggestions? How do large new sites store their articles? Should I be using XML?
I have an Access database that I'm using with ASPMaker to create the .ASP files. My records are basic daily reports dating back several years, with a "Date" field (mm/dd/yyyy) and then a couple of other fields.
I've set up a filter in ASPMaker to display only one month at a time instead of the whole list, or just 29/30/31 days. Code:
I need a way of putting say 10 to 20 bullet points in one table field in an
Access database
- say seperate them with a special character, then build a bulletted list on
my page.
If I can get the page to detect each special character, insert a new bullet
and move on to the next occurance in the string... Code:
How can I select only articles from the current year? I have a datestamp column and the date it stored like this: 2004-06-18 00:00:00.000
The time is always all zeros so I have been having problems with it.
Is it possible to select all twelve months in one select query either from a single field name or through an alias name?
I have a field name that conatins dates, and I would like to arrange the value of each month in a grid, jan-dec, monday-saturday. can I accomplish this with one select statement using an access db?
give me a few tutorials or articles which completely teach you SQL server, or atleast what you need to know to make ASP applications for other people.
I've only ever used Access, and I'm afraid SQL server works differently. I always use SQL queries e.g INSERT..., DELETE..., UPDATE..., SELECT.. and never use the recordset's functions e.g .AddNew..etc.
I have this form where in i calculate the number of months
between 2 dates.It calculates only if both the textboxes have values.
And then i display this in another text box.
The user has to enter the date in DD/MM/YYYY format. user can select
date from calender popup. Apart from selecting the user can also type in
the date.
I am using a function which splits the date entered by the user
into DD MM YYYY and then compares each of these values to see
if its in the valid range like day is between 1-31, month between 1-12
etc.
But i m having a problem. If the user enters characters instead of digits,
my system accepts it in the first box without giving error and then when
the user selects a proper date in 2 textbox its gives an error: 1 is null
or not an object. this error comes at the place where mt function splits
the entire date string into DD MM YYYY.
Could someone please give ne a solution, a way to format the date so that
i let the user enter first 2 digits and then a "/" and then 2 digits and then a
"/" and then 4 digits only.