# ASP Access Query - does not clear result!

**URL:** <https://forum.kirupa.com/t/asp-access-query-does-not-clear-result/173007>\
**Category:** Uncategorized\
**Created:** [December 20, 2005, 10:04am UTC](https://forum.kirupa.com/t/asp-access-query-does-not-clear-result/173007 "2005-12-20T10:04:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![onetwo](https://avatars.discourse-cdn.com/v4/letter/o/3d9bf3/32.png) [@onetwo](https://forum.kirupa.com/u/onetwo)\
**Post date:** [December 20, 2005, 10:04am UTC](https://forum.kirupa.com/t/asp-access-query-does-not-clear-result/173007/1 "2005-12-20T10:04:11Z")

</div>

I am retrieving data from an Access database using ASP.

Everything works fine until I make changes in the database and want to read the data. It seems as if the program remembers the old data string.

I can not get the updated data into my program ?

Also if I close my internet explorer and start the program again the updated data are not retrieved. Why is that and what can I do about it ?

Here is the script being used to elaborate my data:

loadVariables (“business\_mng\_list.asp”, this);

onClipEvent(data)  
{  
\_root.Application.Content.biz\_mng1.removeAll()

\_global.biz\_mng\_db=results.split(";")  
dd\_len=\_global.biz\_mng\_db.length  
for ( i=0; i\<dd\_len-2; i++){  
\_root.Application.Content.biz\_mng1.addItem({label: \_global.biz\_mng\_db\*,data: \_global.biz\_mng\_db[i+1]});

i++  
}

\_root.Application.Content.biz\_mng1.text=""  
results.removeAll()  
}