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
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