I need some helps

what should I do, if I want to delete all the information in the table on the browser after log off

so if someone press back button he can't see the content of the table ( in the same ie window)anymore.

can you give me an example in asp?

thanks



~yanti

Not by ASP, Yanti. You're talking about deleting something from within the 

browser's cache, effectively. The server running the ASP has no control 

over this, since hitting the "back" button doesn't actually send any 

message between the server and the client. You might be able to do this in 

Javascript, but you'd need to submit the question on the JavaScript list 

(under markup). You might want to explain the problem in a little more 

detail, too.



Daniel Walker

Wrox Press



On 08/18/00, ""yanti fitri eka zalti" wrote:

> I need some helps

what should I do, if I want to delete all the information in the table on 

the browser after log off

so if someone press back button he can't see the content of the table ( in 

the same ie window)anymore.

can you give me an example in asp?

thanks



~yanti

> I need some helps

> what should I do, if I want to delete all the information in the table on

the browser after log off

> so if someone press back button he can't see the content of the table ( in

the same ie window)anymore.

> can you give me an example in asp?

> thanks

>

Hi Yanti,



You must simply execute a DELETE command in the page you will use to logo

off



'Connection

Set dbCon = Server.CreateObject("ADODB.Connection")

dbCon.Open ("Your String")



'Recordset

Set rsDelete = Server.CreateObject("ADODB.Recordset")



'Command

DeleteSQL = "DELETE* FROM YOURTABLE"



'Execute

rsDelete.Open DeleteSQL , dbCon, 2, 3



Game over.

Hope it will be useful ...



Jaco

> Not by ASP, Yanti. You're talking about deleting something from within the

> browser's cache, effectively. The server running the ASP has no control

> over this, since hitting the "back" button doesn't actually send any

> message between the server and the client. You might be able to do this in

> Javascript, but you'd need to submit the question on the JavaScript list

> (under markup). You might want to explain the problem in a little more

> detail, too.



Yes, that's correct because you cannot delete browser's cache by ASP.

Sorry for the misunderstanding ...



Jaco

hi,

I want to know what is the sql syntax to know that the SELECT command doesn't return any records at all

thanks



~yanti

hi yanti,



can you be more specific on what you want to do?



if you say 



	select col1, col2,... from tableNm where 0>1;



the above sql will not return any records though tableNm has records in it.



krishna





> -----Original Message-----

> From:	yanti fitri eka zalti 

> Sent:	Thursday, August 24, 2000 5:18 AM

> To:	ASP Databases

> Subject:	[asp_databases] help

> 

> hi,

> I want to know what is the sql syntax to know that the SELECT command

> doesn't return any records at all

> thanks

> 

> ~yanti

> 

> 

> ---

> You are currently subscribed to asp_databases 


> $subst('Email.Unsub')

> 

> 

> 

you can ask: if not recordset_name.EOF then... (do anything you want with

the recordset) ... Else  (it's empty recordset) End if



-----Original Message-----

From: mkrishna - Internet Mail 

Sent: Thursday, August 24, 2000 3:27 PM

To: ASP Databases

Subject: [asp_databases] RE: help





hi yanti,



can you be more specific on what you want to do?



if you say 



	select col1, col2,... from tableNm where 0>1;



the above sql will not return any records though tableNm has records in it.



krishna





> -----Original Message-----

> From:	yanti fitri eka zalti 

> Sent:	Thursday, August 24, 2000 5:18 AM

> To:	ASP Databases

> Subject:	[asp_databases] help

> 

> hi,

> I want to know what is the sql syntax to know that the SELECT command

> doesn't return any records at all

> thanks

> 

> ~yanti

> 

>