|
| |
|
|
jsims
Posts: 42
From: Denver CO USA
Status: offline
 |
Can Access/FP serve up new content daily? - 3/22/2001 20:44:00
I want to use Access/FP to automatically insert a different "fact of the day" each day on our web site. We have several dozen facts now (which we'll store as memo entries in Access) and small graphics that go with each one. Eventually, we want to have something different for every day of the year.Any advice on how should we set this up in our DB and what kind of query to use in FP to automatically update this content each day? We will be constructing data access pages so the staff can continue to add new factoids. I know that there are scripts to do this, but they aren't very flexible when it comes to adding new stuff and would quickly bog down our pages with this much content. Thanks in advance for any advice! ------------------
Jim Sims
jsims@policycom.com [This message has been edited by jsims (edited 03-22-2001).] [This message has been edited by jsims (edited 03-22-2001).]
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Can Access/FP serve up new content daily? - 3/23/2001 20:21:00
In its simplest form, I would use a database with perhaps 4 columnsID,date,text,imagepath The image path would not store the image, just the relative path to the image. Youd use that to display it.
Your text field would be "memo" if you expect more than 255 chr's Each query would be "where DateField between thisdate and thatdate" Your database would specify the date that the text was to be used. The other end would be to create a faster version where the file is dynamically created and perhaps stored as a text file or a server variable so that the database is not overworked. ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
|
|
jsims
Posts: 42
From: Denver CO USA
Status: offline
|
RE: Can Access/FP serve up new content daily? - 3/26/2001 20:17:00
Spooky --Regarding your suggestion at the end of your post, how would one go about implementing this? Thanks! ------------------
Jim Sims
jsims@policycom.com
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Can Access/FP serve up new content daily? - 3/26/2001 23:14:00
You could use an application based variable in your global.asa fileie <%Application("QuoteOfDay") = "Quote"%> Then in each page, write it : <%= Application("QuoteOfDay")%> Your global.asa file can be scripted to query the database each day, and do it only once (as opposed to querying for each user) So you would
Check date > New ? > Yes > query database for todays record > add to application variable Also :
If not date > Check variable has value > No? > query database for todays record > add to application variable ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
|
|
jsims
Posts: 42
From: Denver CO USA
Status: offline
|
RE: Can Access/FP serve up new content daily? - 3/26/2001 23:39:00
Spooky --Thanks loads. That's a great suggestion and should solve lots of problems I've been facing lately. Wish I was more of a coder, though. Where would you suggest I go to find someone I can hire to add this code properly to my global.asa file (assuming you're all tied up with projects)? Thanks! ------------------
Jim Sims
jsims@policycom.com
| |
|
|
|
jsims
Posts: 42
From: Denver CO USA
Status: offline
|
RE: Can Access/FP serve up new content daily? - 3/26/2001 23:55:00
Spooky --As a follow up, our "fun facts" don't need to correlate to a particular date. Say I have only 20 to start with, and want to rotate them every 20 days. Then, as we add more, we lengthen the rotation period. Would that be more difficult to do? ------------------
Jim Sims
jsims@policycom.com
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
