Query Cache Help

[humbleprogrammer]

Hi,

I have a VB front end that works against a MySQL backend. There is a search module that displays matching records and allows you to edit and delete records. If records are deleted and the user than does another search, the results still display the deleted records even though they are no longer in the table. I am assuming this is a cache issue. I don't want to eliminate the cache in fear of performance degrade but would like to give the user the option to refresh which would clear the query cache. Has anyone done this before or does anyone have a better solution?

Thanks in advance!

http://www.gosmart4u.com/

 

[Bastien]

Use the refresh method to repaint the screen, the deleted record should not be there then

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[BNPMike]

Have you tried SQL_NO_CACHE?