Hi, I am attempting to design a site for my band that will display
time-sensitive information on a few of its pages taken from data
entered in an admin control panel. I am running into problems with
dates. I have an Access database set up with a table called 'Dates',
with field names including 'month',(text) 'day',(numeric)
'year',(numeric) and some other fields for other information. I have
another table labeled "Months", with a field for the month names (I
have that table dynamically linked to a list menu in the admin area to
enter the month). I tried to just enter a single date (ie.
01/12/2005), I kept getting errors in access with that field when
entering the date.
I don't know if this is a good approach to entering dates into a
database, what I want to accomplish is this:
1) Create a recordset that will compare that curent date [()now?] to
the date in the recordset and display the record if they match.
Example- If my band is playing a show on January 10th, then ONLY on
January 10th, I want the website to display :"Tonight, at the....."
2)Create a recordset that will display current and upcoming dates and
not display dates that have passed.
3)I have a news area set up also in the database, I would like to
paste HTML into a textbox and have the website display the code as
HTML. I have not looked into this yet, this may be easy, maybe not-
just thought I would ask while I was here.
Thanks for any help and advise- Robbie
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
