WO app returning old data?
WO app returning old data?
- Subject: WO app returning old data?
- From: Wes James <email@hidden>
- Date: Mon, 6 Dec 2004 16:58:54 -0700
I have a woapp that seems like it is returing old data and not current
data. The openbase table had some data in a field like this: "SLIDE
M1". The field should have had just "M1" for the data in that field
for all rows. There were many rows that data entry persons put the
word SLIDE in at the begging of the string.
I then ran an update:
update slide set
call_number=substring(call_number,6,length(call_number)) where
call_number like '%slide%'
to change all the rows with SLIDE in the field text to all text
without the SLIDE at the beginning.
I now do a "select * from slide where return results 20" to look at
the data and it appears that the SLIDE text has been removed. I do
"select count(*) from slide where call_number like '%slide%'" and it
returns 0.
But when I get into the woapp and do a search the SLIDE text appears
in the results. I have web caching off on the server (with osx.3.6
using default apache install).
Where are these ghosts results coming from? I removed all cache from
my browser and nothing....
OK... I just stopped the woa instance and restarted it. Now the
ghosts are gone. Hmmm. So if data is updated, it won't show until
the instance is restarted? Seems odd that I need to restart an
instance when data is updated.
Any light on this?
thanks,
wj
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden