Hi, I'm going crazy from this flash form that SendAndLoad() posts to and asp page then in the same movie a text box gets the asp values. I have an uncommented sql in the asp code below with all other things commented the whole process works fine except the checkboxes selected to begin the whole dynamic data exchange are useless cause they are not use in the retreival of records (I hope you understand so far!). If I comment the sql that I was talking about link this --> 'sql = "SELECT * FROM logbook WHERE cusine IN ('CHINESE')" and I uncomment the array and its respective sql and run the dynamic data process from the start nothing is displayed in the text box. SO i ran the checkbox sripts that sendAndLoad with a geturl in it and pointed the getUrl to the asp page, so the movie would switch to the asp page so i can see the errors. The weird thing is i response wrote the array and all items where there, I response wrote the sql and it was in proper format, everything checks out but nothing is in the text box back on the movie, and trust me i waited for quite some time hoping. Its like the flash movie is reading the asp code and doen't like a dynamically formatted sql? :?: The ASP checks out and the whole flash to asp and back to flash dynamic process work only with a non-dynamic sql. Any ideas?
arrCuisines = array("AFRICAN","CARIBBEAN","CHINESE","CONTINENTAL","DUTCH",......")
For each cuisine In arrCuisines
If Request.Form(cuisine) = "true" Then
strInList = strInList & "'" & cuisine & "',"
arrCuisines = ""
strInList = Left(strInList, len(strInList)-1)
Set connDB = Server.CreateObject("ADODB.Connection")
connDB.Open "DBQ=" & Server.MapPath("\fpdb\db.mdb") & ";" & _
"DRIVER=Microsoft Access Driver (*.mdb)"
sql = "SELECT * FROM logbook WHERE cusine IN (" & strInList & ")"
// i could select the chinese chechbox and response.write the
//sql and i would get exactly the same sql as is commented below
//and no data in the text box but if i comment the
//dynamic sql and uncomment the below sql below i get the
//info in the text box, another words all works fine.
'sql = "SELECT * FROM logbook WHERE cusine IN ('CHINESE')"
Set rs = connDB.Execute(sql)
Do While Not rs.EOF
collect =collect & Ername&","
collects =collects & Eeat&","
Counter = 1
Response.Write "Counter=" & Counter
Set rs = Nothing
Set connDB = Nothing
Any thoughts on this?