# So close yet no data being written to one field in database

**URL:** <https://forum.kirupa.com/t/so-close-yet-no-data-being-written-to-one-field-in-database/237246>\
**Category:** Uncategorized\
**Created:** [August 28, 2007, 3:00pm UTC](https://forum.kirupa.com/t/so-close-yet-no-data-being-written-to-one-field-in-database/237246 "2007-08-28T15:00:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![somnamblst](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@somnamblst](https://forum.kirupa.com/u/somnamblst)\
**Post date:** [August 28, 2007, 3:00pm UTC](https://forum.kirupa.com/t/so-close-yet-no-data-being-written-to-one-field-in-database/237246/1 "2007-08-28T15:00:31Z")

</div>

I have 5 text fields & 1 list box component. I have found lots of examples of databases passing data to Flash but not vice versa.

I realized that unlike the text inputs I had to set a variable for the list box I call OnlineAdTypes. I feel like I am very close because I do now see undefined rather than a blank field

Here is my AS

```auto
on(press){
function doSubmit()
{
userData = new LoadVars();
var myListbox = OnlineAdTypes;
userData.Name = Name;
userData.Advertiser = Advertiser;
userData.TypeAd = TypeAd;
userData.When = When;
userData.NonAdCustomOnline = NonAdCustomOnline;
userData.OnlineAdTypes = OnlineAdTypes.getSelectedItems();
userData.send
("processForm.asp",0,"post");
gotoAndStop(5);
}

```

my script processForm.asp

```auto
<%@language = "VBScript" %>
<%
strName = Request.Form("Name")
strAdvertiser = Request.Form("Advertiser") 
strTypeAd = Request.Form("TypeAd")
strWhen = Request.Form("When")
strOnlineAdTypes = Request.Form("OnlineAdTypes")
strNonAdCustomOnline = Request.Form("NonAdCustomOnline")
 
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=\\content\main_data\sharedDB\onlineAdCounter.mdb;"  
SQL = "INSERT INTO contacts (Name, Advertiser, TypeAd, When, OnlineAdTypes, NonAdCustomOnline) VALUES ('"&strName&"','"&strAdvertiser&"','"&strTypeAd&"','"&strWhen&"','"&strOnlineAdTypes&"','"&strNonAdCustomOnline&"' )"
conn.Execute SQL, recaffected
 
Response.Write(strName) & "<br>"
Response.Write(strAdvertiser) & "<br>"
Response.Write(strTypeAd) & "<br>"
Response.Write(strWhen) & "<br>"
Response.Write(strOnlineAdTypes) & "<br>"
Response.Write(strNonAdCustomOnline) & "<BR/><br/>"
Response.Write(recAffected)
%> 

```

the FLA

[http://cincinnati.com/test/artistForm5.fla](http://cincinnati.com/test/artistForm5.fla)