PLEASE READ CAREFULLY
(Technical info - Using CF 4.5.2 to query MS Access 97 SR2 database for a
text field and date field for unknown number of recordnumbers)
OK. I have flushed the query by making a dynamically changing query name
(I.E. cfquery name="shipments#uniquefield#") and made the page reload using
both unique html calls (I.E. updatecart.cfm?ID=#uniquefield2#") and
(meta http-equiv="pragma" content="no-cache")
(META HTTP-EQUIV="Expires" CONTENT="Mon, 06 Jan 1990 00:00:01 GMT")
codes.
It even loads itself into a second page with the exact same code with all
NEW uniquefields. There is no way (that I see) this query can get "old"
data.
BUT, that's exactly what it's doing. It grabs the data previous to updating
the database (even though the database has been verifyably updated before
this query.)
I've even rewritten the query to see if it was just how the query was
written. It still occasionally grabs "old" data.
In short, grabbing this particular information sometimes grabs "old" data
instead of what is verifyably in the database.
This problem does not occur on ANY other queries throughout the entire site.
Original Query
(cfquery name="shipments#uniquefield#" datasource="mine" dbtype="ODBC")
SELECT shipdate, shipmethod, Count(*) as totalCount
FROM shopcart
WHERE MyCart = '#url.cart#'
Group by shipdate, shipmethod(/cfquery)
Different Query asking for same
(cfquery name="shipments#uniquefield#" datasource="mine" dbtype="ODBC")
SELECT shipdate, shipmethod
FROM shopcart
WHERE MyCart = '#url.cart#'
(/cfquery)
Both Queries often come out with "old" data.
Why is this data stuck? Why is this only happening with this info? Why am I
being tortured like this?
HELP!!!!!!
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
