Let me see if I'm reading this correctly...

You're trying to enter data from the parent page, and then refresh the
iframe to display the new data, correct???

If this is so, it's not SQL caching the data, it's IIS... chuck this at the
top of your asp page (within <% %> tags) response.ExpiresAbsolute 
"1/1/2000" and you should be set

Cheers

Colin MacKenzie


-----Original Message-----
From: Peter Scribner [mailto:plscribner@w...]
Sent: Saturday, November 30, 2002 9:27 AM
To: sql language
Subject: [sql_language] Does SQL2000 cache writes?

Hi all,

I would appreciate any advice anyone can provide with this strange
problem. The question isn't really SQL language related but I didn't know
where else to put it.

In my web page I use an ILayer to get and display a recordset with several
columns.  This happens both at page load and at any time the user adds or
deletes a record to/from the database table.

Works great on load; works sometimes when changes are made. The
(javascript) function call in both cases is exactly the same. There seems
to be no pattern to when it will and when it will not bring back the
changed table contents.  I know that the table IS changed and that the
ILayer SHOULD bring the new data back. Like I said, sometimes yes and
sometimes no.

It occured to me that maybe SQL 2000 caches newly written records until
some buffer or something is full and that's why the performance is
intermittent.  Doesn't sound right but it's the only thing I can think of.
By the way, the write of a new record is followed immediately by the
ILayer SRC page reading the table for changes.  I have no idea if that's
pertinent.

If anyone can offer a clue I would be most appreciative.  Thanks in
advance for your help.

Peter