data.asp

access the database using Flash MX. Please remember that Flash is unable to natively access a databa

<%
'Author: Rafay Bin Ali
'email:  [e-mail]
'URL:    http://rafayali.blogspot.com
        'http://cyberdev.visit.ws


record=request("Record")
Set objconn=server.createobject("adodb.connection")
objconn.open "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("names.mdb")
set objrecord=server.createobject("adodb.recordset")

set objrecord=objconn.execute("select * from mydbdata where firstName like'" & record & "'")

if objrecord.eof or objrecord.bof then

Response.Write "errorMsg=Not Found&firstName=&lastName=&City="
response.end
else

Response.Write "errorMsg=Found&firstName=" & server.URLEncode(objrecord.fields("firstName")) & "&" & _

"lastName=" & server.URLEncode(objrecord.fields("lastName")) & "&" & _

"City=" & server.urlencode(objrecord.fields("City"))


end if
%>