Click to See Complete Forum and Search --> : flash - database connectivity


himanshu200
May 29th, 2002, 06:05 AM
hi,

i wish to make a connection between my database and flash.
i am able to pass the data from flash to my database via ASP.
now the problem is that i am not able to show the retrieved information from the database to the flash.

what i am having is a database table and i am sending you the content of the asp page which i have made.

following is the ASP code

=============================================

<%@ Language=VBScript %>

<%



uname1 = request.form("uname")

set conn = Server.CreateObject("ADODB.Connection")
odconnstr1 = "Provider=SQLOLEDB;Server=icorp-net;uid=sa;pwd=admin;database=OperatorDirect"
conn.Open odconnstr1
set RS = Server.CreateObject("ADODB.RecordSet")
sql="SELECT * FROM hospitality_registration where username= '"& uname1 &"'"
response.write sql
oRS.Open sql, odconnstr1


Response.Write "contact name=" & Server.URLEncode(RS("c_person")) & _
"&password=" & Server.URLEncode(RS("password")) & _
"&Username=" & Server.URLEncode(RS("username"))


RS.Close
Set oRS = Nothing

Set oConn = Nothing
%>
========================================

on the flash side, i have made a movie with 3 different frames.
in first frame i am having an input box through which i am entering the username with the editable text box. i am calling a second frame in the action of the button on first frame.
in second frame, i am calling the asp page, the code of which i am sending you.

in third frame, i wish to show the data retrieved through the ASP page but i do not know how to show the retrieved data...?

i have gone through ur sample example a number of times but i am not getting it....

please help me out in presenting the data...

thanks and regards,

Himanshu