dynamic data exchange --Please Help!

[2cxc]

Hello, I have a list box (named "myName&quot on the main stage with items in it, there is also a dynamic text box named "display". I'm trying to select an item in the list box and have the dynamic text box display database values relating to that item. I'm using ASP and have the server side aspect done. The ASP page takes write a variable string to send back to Flash and then the response.write sends the name and value pairs to the page so flash can get them.

The flash movie is just 1 frame and i have these actions on it own layer

myName.setChangeHandler("myHandler");
//Custom handler for myName
//This handler is called each time selection is
//changed.
myHandler = function (component) {
	myVars = new LoadVars();
	myVars.curName = myName.getSelectedIndex()+1;
	myVars.onLoad = displayInfo;
	myVars.sendAndLoad("wpg.asp", myVars);
};

//Extracts db info and displays it using HTML
displayInfo = function () {
	display.htmlText = "";
	myTotal = this["total"];
	if (myTotal != 0) {
		display.htmlText += &quot;<font color=\&quot;#999999\&quot; size=\&quot;11\&quot;><b>There are <font color=\&quot;#CC6600\&quot;><i>&quot;+myTotal+&quot;</i></font> entries for this month</b></font><br>&quot;;
		for (var i = 0; i<this[&quot;total&quot;]; i++) {
			display.htmlText += &quot;<font color=\&quot;#CC6600\&quot; size=\&quot;11\&quot;><b>&quot;+this[&quot;myName&quot;+i]+&quot;</b></font><br>&quot;;
			display.htmlText += &quot;<font size=\&quot;11\&quot;><b>&quot;+this[&quot;myAddress&quot;+i]+&quot;</b></font><br>&quot;;
			display.htmlText += &quot;<font size=\&quot;11\&quot;>&quot;+this[&quot;myPhone&quot;+i]+&quot;</font><br><br>&quot;;
		}
	} else {
		display.htmlText += &quot;<b>No Entries.</b>&quot;;
	}		
};

I've tried to fool around with this and the else statement ("No Entries.&quot is the only thing i can get to display. Any ideas why this may be?? Please Help

Here's part of the ASP code:

Dim curName, responseVars, counter
curName = Request ("curName")
counter = 0
Set connDB = Server.CreateObject("ADODB.Connection")
connDB.Open "DBQ=" & Server.MapPath("\menu\wegmnu.mdb") & ";" & _
"DRIVER=Microsoft Access Driver (*.mdb)"
sql = "SELECT * FROM rerans WHERE [name] = '"&curName&"'" 
Set rs = connDB.Execute(sql)
while not rs.eof
	responseVars = responseVars & "name"  & counter &  "=" & rs("name") & "& address"  & counter &  "=" & rs("address") & "& phone"  & counter &  "=" & rs ("phone") & "& cusine"  & counter &  "=" & rs ("cusine") & "& eat"  & counter &  "=" & rs ("eat") & "& menu"  & counter &  "=" & rs ("menu")
 counter = counter + 1
 rs.movenext
wend
responseVars = responseVars & "total=" & counter
Response.Write(responseVars)
set rs = nothing
....

 

[2cxc]

Ill try to explain my problem with more simplified code:

Hello, I have a list box on the main stage with items in it (qwer with data = qwer, asdf w/ data = asdf, zxcv w/ data = zxcv, and qwe w/ data = qwe) there is also a dynamic text box named "display". I'm trying to select an item in the list box and have the dynamic text box display database values relating to that item. I'm using ASP and have the server side aspect done, no errors. The ASP page writes a variable string to send back to Flash and then the response.write sends the name and value pairs to the page so flash can get them. I think i narrowed the problem down to this part:
myVars.curName = myName.getSelectedIndex()+1;
but am not sure

The flash movie is just 1 frame and i have these actions on it own layer

myName.setChangeHandler("myHandler");
myHandler = function (component) {
	myVars = new LoadVars();
	myVars.curName = myName.getSelectedIndex()+1;
	myVars.onLoad = displayLogs;
	myVars.sendAndLoad("logbook.asp", myVars);
};
//Extracts log info and displays it using HTML
displayLogs = function () {
	display.htmlText = "";
		for (var i = 0; i<this[&quot;total&quot;]; i++) {
display.htmlText += &quot;<font color=\&quot;#CC6600\&quot; size=\&quot;11\&quot;><b>&quot;+this[&quot;myRnam&quot;+i]+&quot;</b></font><br>&quot;;

display.htmlText += &quot;<font size=\&quot;11\&quot;><b>&quot;+this[&quot;myAddress&quot;+i]+&quot;</b></font><br>&quot;;

display.htmlText += &quot;<font size=\&quot;11\&quot;>&quot;+this[&quot;myCusine&quot;+i]+&quot;</font><br><br>&quot;;

display.htmlText += &quot;<font size=\&quot;11\&quot;>&quot;+this[&quot;myEat&quot;+i]+&quot;</font><br><br>&quot;;

display.htmlText += &quot;<font size=\&quot;11\&quot;>&quot;+this[&quot;myPhone&quot;+i]+&quot;</font><br><br>&quot;;
		}		
};

Any ideas why when i click on the items in the list box nothing displays in the dynamic text box?

Revelent parts of the asp code i'm using is:

theSQL = "SELECT * FROM logbook WHERE (rnam = '&curName&')"
'Run the query
set rs = db.Execute(theSQL)

'Write a variable string to send back to Flash
while not rs.eof
	responseVars = responseVars & "myRnam" & counter & "=" & rs("rnam") & "&myAddress" & counter & "=" & rs("address") & "&myCusine" & counter & "=" & rs ("cusine") & "&myEat" & counter & "=" & rs ("eat") & "&myPhone" & counter & "=" & rs ("phone") & "&"
	counter = counter + 1
 rs.movenext
wend
responseVars = responseVars & "total=" & counter

'Send the name and value pairs back to Flash
Response.Write(responseVars)
'Destroy objects
set rs = nothing
set db = nothing

The database has values for each column of each record. The column values are all set to text (using access 2k db) and the names are as such:
rnam, address, phone, eat, cusine

Any thoughts?

 

[2cxc]

well i got it going. I have to say that dynamic data exchange with a database or xml rocks with flash!