BorlandTalk.com

Jim Beauchemin · Guest

Hi All -

Having an issue with my web server refreshing the browser view properly.
Using ADOconnection to SQL and displaying with a TDatasetTableProducer. I
send a filter param into the dll via queryfileds - the problem is that once
you enter the url with filter, you have to refresh the browser to see the
filtered view? Anyone know what I am doing wrong?

Help! -jim

Del Murray · Guest

You may be encountering a problem where the browser thinks you are sending
the identical page back and he is referring to his cache instead of your
newly transmitted page. Try clearing the browsers cache and then testing
again. Sometimes you have to force the old cached pages out. If it
continues, then set the page to automatically expire.

Jim Beauchemin · Guest

Thanks for the info. Del. I also thought that this was a Cache issue and
had already set "check for new page" to Automatically.

It appears that the view I get, no matter what filter I send in, renders the
last view - then when I refresh the page, I get my filtered view?

Here is a sample of my url:

http://jbeauchemin.idx.com/bvtweb2/iCustomer.dll/Main?Filter=A_Support

Here is a sample of my code - all pretty straight forward - any other
eas? -jim

procedure TWebModule1.WebModule1MainAction(Sender: TObject;
Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
begin

Item := '';
Item := Request.QueryFields.Values['Filter'];

If trim(Item) = 'A_Support' then begin
dst1.Caption := 'Web customers - Filter = {all customers active with
Support group}';
adoQuery1.Close;
adoQuery1.SQL.Clear;
adoQuery1.SQL.Add('Select * from Customer where (Status = ''Support''
and Active = ''Y'')');
adoQuery1.Open;
end;
end;

"Del Murray" <delm (AT) mchsi (DOT) com> wrote

Lewis Howell · Guest

Don't know if this will help your situation, but ave you tried setting to
page to no-cache in your meta tags?

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">

Lewis Howell

"Jim Beauchemin" <james_beauchemin (AT) idx (DOT) com> wrote

Del Murray · Guest

what happened to response.content := ??? something?

Jim Beauchemin · Guest

Del -

My bulb is not as bright as it use to be... You hit the exact cause (no
response back to the table component after filter was applied !). Thank
you for your help - much appreciated !! -jim

"Del Murray" <delm (AT) mchsi (DOT) com> wrote

Jim Beauchemin · Guest

Thank you Lewis - another great of code to file away. -jim

"Lewis Howell" <lou_junkmail (AT) yahoo (DOT) com> wrote