How does one veiw there ms access database in flash?
How does one view a specified table in flash?
Ive gone through an asp tutorial on sending info from flash through asp to the access database file, which is what i want.
Ive attached what my problems are with the flash fla. Its extremely rough and nowhere near the final stage
i havnt specified the location of asp yet
Your assistance would be much appreciiated.
its not working because of your sql statement
SQL = “INSERT INTO contacts (FirstName, LastName, Phone) VALUES (’”&strFirst&"’,’"&strLast&"’,’"&strPhone&"’)"
you dont have a table name called contacts in your database. you have data1 & data2. one of those should be renamed to contacts or change you sql statement to read
SQL = “INSERT INTO data1 (FirstName, LastName, Phone) VALUES (’”&strFirst&"’,’"&strLast&"’,’"&strPhone&"’)"
edit; you also gave your textboxes in flash instance names and not variable names
also you have spaces in the field names of your database
ie. First Name Last Name.
if you read the tutorial fully, it explains that you should print your DQL statement before trying to execute. you have to be sure everything matches eachother.
as far as displaying record set in flash, i am currently working on that tutorial, but here’s a working example with no comments or anything.
:: Copyright KIRUPA 2024 //--