Flash/ASP problem
- Started
- Last post
- 8 Responses
- Brooklyn
Hey guys!
I'm not really into programing, but I need to come up with something quick. Here's the deal.
I have an .MDB file with 4 columns and 10 rows. My .ASP file is working properly as I can see it on the web showing all the entries in my DB.
My problem is that in Flash, I have 4 text fields that need to have the entire content of the .MDB (the 4 columns) but it's only showing the last or first row.
How can I put everything in Flash, in my textfields? Here's my Flash code :
loadVariables("tourdates.asp", "POST");
Help anyone?
Thanks ALOT!
B
- mr_flaco0
How are you setting up your data to send to flash - a query string?
Also, how are you assigning the data to the text fields?
Post a little more info about whats going on in there ...
- Brooklyn0
Here's my ASP code :
- Brooklyn0
Hum, this didnt work... Here it is again :
Set DataConn = Server.CreateObject("ADODB.Conne...
DataConn.Open "Driver=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("tourdates.mdb")Set cmdTemp = Server.CreateObject("ADODB.Comma...
Set rstContacts = Server.CreateObject("ADODB.Recor...cmdTemp.CommandText = "Select * From tourdates"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConnrstContacts.Open cmdTemp, , 1, 3
Do while not rstContacts.eof
Response.write "bands=" & Server.URLEncode(rstContacts("ba... & "&"
Response.write "venue=" & Server.URLEncode(rstContacts("ve... & "&"
Response.write "city=" & Server.URLEncode(rstContacts("ci... & "&"
Response.write "day=" & Server.URLEncode(rstContacts("da... & "&"
rstContacts.movenext
looprstContacts.Close
DataConn.Close
- Brooklyn0
And in my Flash file :
Text fields are named :
strBands
strVenue
strCity
strDayThe "load var" action is :
loadVariables("tourdates.asp", "", "GET");
On a frame
- ********0
It's not as simple as setting your text fields to multiline?
- Brooklyn0
Unfortunatly, not :-(
- ********0
are you declaring your variables in your initial Flash file? Your asp will read those and dB will use 'em.
- mr_flaco0
looks like the asp is doing its thing...at least it looks like it without seeing the output.
So you have no other code in your file to set the text fields to that text? If that is true your vars in the query string and the text field names dont match...
I write an extra var at the end of the string to know all of the data is loaded, say '&loaded=1' then have a loop in flash that waits until that var becomes true, then do this:
if (loaded==1){
strBands.text = bands;
strVenue.text = venue;
etc...Dunno if that helps, but its hard to say what the issue is w/o seeing the file...