I have a little problem with displaying asp results in flash, I hope someone can help me. I’ve managed to display images referenced in a database in ASP before. Using the following:-
<IMG SRC = “images/small/<% =rs( “image” )%>” border=“0”>
However, i am now trying to display the contents of a table, in a MS Access database, in Flash. I have the code below which shows the first 4 fields (Name, Telephone, City & Notes) I’ve created the firth field which is Img. This field holds the image reference.
I’m just not sure how to make the images display in Flash. The code i am using is below:-
<%
Set DataConn = Server.CreateObject(“ADODB.Connection”)
DataConn.Open “Driver=Microsoft Access Driver (*.mdb);DBQ=” & Server.MapPath(“AddressBook.mdb”)
Set cmdTemp = Server.CreateObject(“ADODB.Command”)
Set rstContacts = Server.CreateObject(“ADODB.Recordset”)
cmdTemp.CommandText = “Select * From Contacts”
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
rstContacts.Open cmdTemp, , 1, 3
rstContacts.Move CLng(Request(“Record”))
Response.write “Name=” & Server.URLEncode(rstContacts(“Name”)) & “&”
Response.write “Telephone=” & Server.URLEncode(rstContacts(“Telephone”)) & “&”
Response.write “City=” & Server.URLEncode(rstContacts(“City”)) & “&”
Response.write “Notes=” & Server.URLEncode(rstContacts(“Notes”)) & “&”
Response.write “TotalRecords=” & rstContacts.RecordCount
rstContacts.Close
DataConn.Close
%>
Any help or ideas would be greatly appreciated.
Steve