# ASP-FLASH question

**URL:** <https://forum.kirupa.com/t/asp-flash-question/110480>\
**Category:** Uncategorized\
**Created:** [May 16, 2004, 10:01pm UTC](https://forum.kirupa.com/t/asp-flash-question/110480 "2004-05-16T22:01:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zebdaag](https://avatars.discourse-cdn.com/v4/letter/z/53a042/32.png) [@zebdaag](https://forum.kirupa.com/u/zebdaag)\
**Post date:** [May 16, 2004, 10:01pm UTC](https://forum.kirupa.com/t/asp-flash-question/110480/1 "2004-05-16T22:01:41Z")

</div>

I want to work with \_root and a variable where the variable is out of a database.

So I got this as ASP(file Nav\_02.asp)|

```auto
<!--#include file="connection.asp"-->
<% 
 SQL = "SELECT * FROM ipadres WHERE ID= 1"
 Set r = conn.Execute(SQL) 
 Do While Not r.EOF 
 Response.Write "a=" & r("Name")
 r.MoveNext
 loop 
%>

```

Then on a MC in Flash I have this actionscript|

```auto
onClipEvent(data) {
 a = button_01
 _root.a = {_x: 100, _y: 50};
}
onClipEvent (load) {
loadVariables ("Nav_02.asp", this);
}

```

but this doesn’t work…what to do??