Fetching information from microsoft access to flash with ASP with ASP

programming
1

im looking for is a code which allows me to check the information without using the flash application…for example …viewing the file in IE and when the correct user log in a smallwindow will appear saying that the pserson has logged in for example … [Welcome Syed] and the user’s loggin info will be recorded in the database in any means whether its by a tick or just an indication…

2

ok well here goes

login.asp


<% @Language="VBScript"
<% 
	un=request("un") 'request form login variables
	pw=request("pw")


Dim conn, rsNames  'delcare some vars

MyPath=Server.MapPath("database.mdb") 

Set conn=Server.CreateObject("ADODB.Connection") 

conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ 
	"DBQ=" & MyPath 

SQL= "SELECT * FROM ADMIN"  

Set rsNames = conn.Execute(SQL)  'execute the sql query

		
			Match = "no"
		
			Session("un")=un
	        Session("ps")=ps
			

Do While Not rsNames.EOF 'execute sql query until no more entries

If un=rsNames("USERNAME") And pw=rsNames("PASSWORD") Then
			
		Match= "yes"

	    End if
%>		

<% rsNames.MoveNext %>

<% Loop %>

<% Response.Write (Match) 
	    If Match= "yes" then 
		Response.Redirect un & "yourprotectedpage.asp" 'this can be the page you want to protect
	    End If
%>

that will check a db with a table called ADMIN with fields called USERNAME, PASSWORD

to say “Welcome Digitalosophy” use the something like this


<% name=Request.Form("USERNAME") %>
<%=("name") %> 'shortcut for
<% Response.Write("name") %>
3

this is in the asp…yea…(im using notepad) …but how abt the flash codes… ? i currently trying to figure out previous examples…

4

what?

im looking for is a code which allows me to check the information without using the flash application

???

5

ohh… got missed up there… what i meant was… check the information without using flash application as the reference…ya know when u add “trace” it will display the output in flash…what i was looking for , is a code which will display the output which is e.g “welcome to starworld” either by popping out a screen or just displaying it on the browser…

6

sorry for the vagueness… :slight_smile:

7

well you can display it on the browser a number of ways, either way you need some server side script to send that info to the browser. i would say the easiest way is


<%= myVar %>

in you case you will need to pull the data from the asp script


<% 
   un=request("un")
   Response.Write ("un") %>

that will output the users name to the browser.

you can pass that var to flash if u’d like and load the vars(AS) and print them