# Loading sound from database in Flash

**URL:** <https://forum.kirupa.com/t/loading-sound-from-database-in-flash/166975>\
**Category:** Uncategorized\
**Created:** [October 24, 2005, 2:52pm UTC](https://forum.kirupa.com/t/loading-sound-from-database-in-flash/166975 "2005-10-24T14:52:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![toth](https://avatars.discourse-cdn.com/v4/letter/t/a88e4f/32.png) [@toth](https://forum.kirupa.com/u/toth)\
**Post date:** [October 24, 2005, 2:52pm UTC](https://forum.kirupa.com/t/loading-sound-from-database-in-flash/166975/1 "2005-10-24T14:52:48Z")

</div>

_[size=2][color=#800080]Hello,_

_I’m working on a site that loads variables from a datase through ASP._  
_It’s no problem to load a tekst in a dynamic text field._  
_Here’s the code:_

_Loading variable from data.asp in Flash_

[/color][/size]

```auto
loadVariablesNum("data.asp", 0, "GET");

```

[size=2][color=#800080]  
_data.asp file_

[/color][/size]

```auto
 <% 
Dim rsAudio
Dim rsAudio_numRows
 
Set rsAudio = Server.CreateObject("ADODB.Recordset")
rsAudio.ActiveConnection = MM_flashASP_STRING
rsAudio.Source = "SELECT * FROM pageAudio ORDER BY ID ASC"
rsAudio.CursorType = 0
rsAudio.CursorLocation = 2
rsAudio.LockType = 1
rsAudio.Open()
 
rsAudio_numRows = 0
 
Response.Write "AudioTrack=" & Server.URLEncode(rsAudio("AudioTrack")) & "&AudioFile=" & Server.URLEncode(rsAudio("AudioFile"))
 
rsAudio.Close()
Set rsAudio = Nothing
%>

```

[size=2][color=#800080]  
_The table **AudioTrack** is the name of the audiofile_  
_The table **AudioFile** is the adress to the mp3 file (ex. audio/sound01.mp3)_

_I can load the text in a dynamic textfield by giving it the variable AudioTrack_  
_But how do I do it to load the mp3 sound file??_

_greetz, toth 8D_

[/color][/size]