Doug-
If I were in your shoes, I would load the data into an application
structure. Hitting your db for every banner request will quickly bring the
system to its knees. You could simply create an array in the application
scope, and use that as your database "table".
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 3:48 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Forcing a query refresh
Katrina,
The reason I say it's not running the query again is because of the same
information
that is being presented to me.
I am using a query to grab and pull a web banner for my Home page.
What I do is grab the top most banner from the list of banners,
store the info in a variable, put that banner to the bottom of the list
and then display the variable as the banner.
So if I hit refresh, a new banner should appear. Since it doesn't
always work, I am trying to figure it out.
Thanks.
Doug
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 9:42 AM
To: [EMAIL PROTECTED]
Subject: Re: Forcing a query refresh
How do you know that it's not running the query again? What browser are
you using. If you hold control while you click refresh that will force it
to make the call back to your server for the latest information.
--Katrina
====================
Katrina Chapman
Consultant
Ameriquest Mortgage
dford@midrangecom
puting.com (Doug To:
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Ford) cc:
Subject: Forcing a query
refresh
05/03/00 09:33 AM
Please respond to
cf-talk
Hi Folks,
What's the best way of forcing a query to always
run instead of it being cached?
I am pulling a record from a DB and displaying it,
but when I do a refresh/reload it doesn't
run the query again.
What's the best way of doing that?
Thanks,
Doug
------------------------------------------------------------------------
------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------
------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
