Flash :: Flash, Access, ASP

[f8] Array Access Notation To Access A MC Within A MC?
Hi,
can one access the contents of a movieclip - that contains another mc - using Array Access notation??

I am loading a bunch of similar (ie, based on the same template) external swfs individually on level0 on the main timeline. because there are many swfs, i want to control the button/mcs in those external swfs from the main timeline. i have a different number of buttons in each swf, and each button goes to a different label. so i am trying to figure how to dettermine the name of the loaded swf, in order to get to the buttons inside that swf...

I was thinking to name each label the same name as the corresponding button object name. and each button/label name be derived from the name of the containing swf... I could put the name of the swf in a variable, and use it as a gotoAndStop() argument...,

i can provide code, but i'm lost and it's gotten messy...

Any ideas GReatly appreciated.

Flash To Access
is there a way for flash to right data to an access database

MS Access Into Flash
Does anybody know how to link databases into Flash for use in let's say creating of a addressbook?
Thanks
Toris

Flash 5 And Access
I'm trying to do some dynamic pages for a club site. The application I'm working on is to retrieve member information (i.e., names, locations, email, etc.) from an Access 2000 database. I'd like to be able to have a listing of each members name as the menu and once you select a name, you can pull up that person's profile from the database.

I'm pretty certain that I can do it using ASP - though I haven't done any of the code yet. What I'm wondering is how/if I can do it using Flash 5. I'm developing everything on a Win 2k pro machine with IIS 5 installed, but I plan to migrate it to a web hosting service. I did a search of these forums and the tutorials, but came up kind of blank.

Where could I find some information on how to do this? (assuming I can)

Flash/ASP/MS Access
I have created an asp login for a site that checks an access database table for the username/password that works very well in html and asp. I was trying to dress up my initial page where you type in your username/password with flash, however I could not get it to work (imagine that). Basically I have 1 form with 2 fields {username/password}in it with a submit button and reset button. Does anyone know where I can find a tutorial on this or maybe someone might have a fix for this? Thanks for your time.
Regards ...
"Doc"

Using Access With Flash
hi all,
can anyone please tell me how to use access with a flash movie without using a server? there is a search function in it..

Flash And MS Access
Is it possible to connect a Flash 5 Presentation with a Access database.

I am in Scotland and I am doing a project for my degree. It is going to be a shopping page. We are using ASP for transactions and login , registration.

I would like it so when you click on a item to purchase it will take you to a transaction page with all information filled in so the user does not have to do this manually.

Cheers

derek

Access And Flash 5 ?
I want to retrieve and update information from a database (Access 2000) using flash 5, where can I learn to integrate this programs.

What do I need to know?

Flash 5 And Access. Help
I want to retrieve and update information from a database (Access 2000) using flash 5, where can I learn to integrate this programs.

What do I need to know?
Examples ?
tutorials?

Access To Asp To Flash Help
Hello,

I am an asp/vb programmer testing a application that builds a menu in flash based on fields stored in a access table.

Currently i am able to pass the information from asp to flash via sql and asp

[pages.asp]
(to simplify i will just write the output rather than show you my connection method)

Response.Write "&output=Home,Services,Products,Contact,whatever&t extColor=000000&Counter=1&"

[test.swf]

Frame 1
loadVariablesNum("pages.asp", 0);

Frame 2
if (_root.Counter == 1) {
gotoAndStop(3);
} else {
gotoAndPlay(1);
}

frame 3

// depth
depth = -1;
// hide the origional clips
Name._visible = 0;
// split up the array by looking for the commas
Name_array = output.split(",");
// get the length of the array
Name_length = Name_array.length;
// set the start y position (x position depends on where you put it on the screen)
yposition = 38;
// looping everything
for (i=0; i<Name_length; i++) {
// Name
duplicateMovieClip(Name, "Name" add i, depth);
setProperty("Name" add i, _y, yposition);
Name.Name = Name_array[1];
set("Name" add i add ".info", Name_array[i]);
depth--;
yposition = yposition+30;
}

I would like to be able to set the color for each button in this loop. I would also like to be able to set the hyperlink in each of these buttons. The instance of the button is "Name" and the dynamic text variable is "info". I struggle somewhat with the actionscript syntax but am able to move along with little information so any guidance helps.

thanx in advance
T

HELP Flash To ASP To Access
I have tried almost all the download examples of Flash to ASP to Access. Everyone I have extracted to a folder on my desk top. I have not yet found any to work. I have been able to get flash to pul data in from a txt file but want to learn how to pull from an access database. can some one set up a working example and assist me in learning this? Please this is important for me and my job.

Thank you!

From MS Access Into Flash
What is the best way to call forth information and objects stored in a relational database (preferably MS Access) into a Flash based interface?

Thank you for any thoughts.

Flash & Asp & Access
hi,
I have a current website written in asp (jscript) and uses access databases. I would like to make a flash port. I've seen tutorials that allow 1 item to pulled at a time so you might see a screen...

Item Name : Redeemer
Item Cost : $ 3,000,000
Description : blah blah blah

<< Prev Item Next Item >>

*** Call the above an 'Item View' ***

but I need to list multiple items. I was thinking I could save 'Item View' as a symbol and create (script?) several instances of it and load each one with corresponding database information. so you would get...

Item Name : Redeemer
Item Cost : $ 125,000,000
Description : blah blah blah

Item Name : Flak Cannon
Item Cost : $ 22,000,000
Description : blah blah blah

Item Name : Rocket Gun
Item Cost : $ 8,750,000
Description : blah blah blah

.... so on ...

<< Prev Page Next Page >>

I'ld really appreciate any help on this.

thanks,
.:AlphaOne:.

Flash And Access
Hi

Ive asked this before but as i only have t'internet at the library by the time some kind soul has replied I am on my merry way home

I have 400 products in an access database which is linked to a website via ASP using html and css. I dont want to use html and css i want to make the whole thing in Flash. Is there anyway of importing data into Flash MX2004. The products all have names, descriptions, thumbnails and large pics. At the moment i have flash objects above and to the left of the the imported data but it looks rubbish! I want to do it all in Flash

Can anyone solve this problem

Email me at yourmum100@hotmail.com if you can and we can come to an arrangement

thanks in advance

Rambona

How To Flash <-> Access DB
Hi,

how can Flash communicate with an access-database?
Or is the only way: loadVariables and ASP?

Thankx in advance
Genius

Flash And Access
I'm pretty new to flash mx, at least the action script part, but I figure flash is the way to go here as I've seen examples and flash it what they done it in. Any way I have an access database with a table that has all the US zips and lat an lon values, and I have another table with stores that relate by the zip. I want to take a US map and populate it with dots corresponding with the locations in the store table, thus a new store gets added then a new dot appears, now I thought of ways to do this mabie adding a X and Y value in the zip table for each zip code according to where it would be located on the map, but is that the only way as I would have to put them for every zip 42,000 round about, that would be a lot of work, seems there would be an easier way I just have no idea where to start anyone seen this done before? and if adding x and y values was the only way to go haw would I call that in actionscript to make a movieclip dot and loop it through so that it places for each record in the store table. I'm just lost at this point so I'll leave it to the experts! I'm using asp as backend and flash MX.

FLASH MX With ACCESS DB And ASP
Please help me.

I,m bringing data from an access database with an ASP page in a Dinamic field multilined in Flash MX but the problem is I have lots of lines and the result came in a unique line.

For example:

I have a list of names and it came like this:

name1name2name3name4name5

How can I use it like...

name1
name2
name3
.
.
.

Thanks a lot for helping me guys.

Flash + MS Access?
Hi

I am shortly to tackle a web site, where the client wants authorised users to be able to update the contents of a particular table in MS Access.

Before I volunteered to do a version in Flash (as the Client loves all the bells and whistles that comes with Flash), I just wanted to sound others out.

For example, how trick is it to link a Flash web site to an MS Access table, and allow certain users to update data?

Any advice, tips, examples would be greatly appreciated as I am a noviec when it comes to Flash.

Thanks in advance.

GT

Access DB In Flash?
I have extensive data contained in a Microsoft Access database that is currently powering www.omnisoul.com. We want to use Flash MX exclusively for the new site, but we want to continue using this Access Database. Would anyone be able to show me a stripped-down simple example of how to take the functionality of the ASP strings currently there and use the same concept in Flash?

Are we going to have to migrate the data to a new database type?

I think I just need help getting started, once I get the idea/concept and basic code I'll be able to take it from there. I'm pretty good with Flash MX otherwise - the database inclusion is a new step for me.

Thanks in advance!

Flash Asp Access
REMOVED

How Do I Access Flash?
How do I access Flash?

Flash And Access
Hey Guys, I'm trying to display information contained in an Access database in my flash movie. I've been searching online through various articles but they are all 4-5 years old. Any help on how to do this and what other software I may need besides Flash MX and Access would be appreciated.

Flash ASP And Ms Access
Does anyone know where there is a flash fla showing how to download data from a large msaccess database? I'm desparate to know. A million thanks in abvance.

The Best Way From Access To Flash
Hi, guys,

I need your advice on this one: which is the best way to get data from DB (I'm using Access and asp) to Flash MX? I'm trying to show the list of the last 10 added articles (titles - this is also link to a page articles.asp?article=..., date the article was added). So the content has to change when the new article is added.

THX for the help.

Flash 8 And Access
Hey all. Just a random question. Is it possible to use flash to import information into Flash 8 from a Acess database? I doubt it's possible but just thought i would ask.

Thanks

Flash, Access, ASP
You can help me if you have knowledge of integrating Flash, Access, and ASP.

There are several tutorials on how to integrate the three of these and so far I can get that far.

I'm loading variables from a database that should show in Flash. I can load the first variable of each column in the database. However, I cannot list them. I don't know whether ASP or the actionscript should tell the variables to list. So far I can't figure anything out though.

This is the ASP I'm using:

Code:
<%
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "Driver=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("software.mdb")

Set cmdTemp = Server.CreateObject("ADODB.Command")
Set rstSoftwareList = Server.CreateObject("ADODB.Recordset")

cmdTemp.CommandText = "Select * From SoftwareList"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn

rstSoftwareList.Open cmdTemp, , 1, 3

rstSoftwareList.Move CLng(Request("Record"))

Response.write "Software=" & Server.URLEncode(rstSoftwareList("Software")) & "&"
Response.write "Numbers=" & Server.URLEncode(rstSoftwareList("Numbers")) & "&"
Response.write "TotalRecords=" & rstSoftwareList.RecordCount

rstSoftwareList.Close
DataConn.Close
%>

This is the actionscript I've placed on the movieclip containing two text fields:

Code:
onClipEvent (data) {
Software = Software;
Numbers = Numbers;
}
onClipEvent (load) {
CurrentRecord = 0;
loadVariables("data.asp?Record=0", this);
_root.softwareArray = this.software.split(",");
_root.numbersArray = this.numbers.split(",");
}

This is a visual example of what happens now:
http://www.coe.unt.edu/gal/newsites/flash/software.swf
It should display:
AAA 111
BBB 222
CCC 333
etc.

Thanks for all of your help!

Flash ASP & Access
Hi all,

I have created a small interface that searches a database of people based on criteria the user inputs. It returns the results and the user selects an individual from the results. It then returns the information for that individual. The user then adjusts some info and submits the adjusted info to the database. This all works.

The problem come when you search for an select and individual that you have already updated the information for. On this second time through the adjusted information doesn't appear. If I close the html window and open it again and then search for the individual, the updated info does appear.

I'm using LoadVars to send and load the results to the ASP pages.

I know this is vague, but has anyone experienced this before? Any thoughts?

_t

Flash And Access
Hi!
Is it possible to connect Flash with Access DB? If I want to have, for example, a references to some files (text, music, video...), users etc in the DB and display it in Flash (including the possibility to upload new files and to write the info to the DB). Is it possible? And if it is - then how? How do I connect Flash to DB and display all the info I need/want?
I'd be great to see some example files (.fla+.mdb)!

Thank you very much in advance!

Flash MX, ASP & ACCESS
what's wrong here? I can connect to the DB

flash MC with:

var - login
var - password

login button:

on (release, keyPress "<Enter>") {
mode = "login";
go = "";
duplicate = "";
loadVariables("post.asp", "", "POST");
login = "";
Password = "";
}

firstframe:labelad (""login");
if (go == "true") {
gotoAndStop ("welcome");
}
if (go == "false") {
gotoAndStop ("error");
}
if (duplicate == "true") {
gotoAndStop ("submit");
}

secondframe:
gotoAndPlay("login");

post.asp file:

<%@LANGUAGE="VBSCRIPT"%>

<%
'helps us debug our code

'here are our variables
dim oConn
dim oRs
dim strSql
dim strLogin
dim strPassword
dim strNewLogin
dim strNewPassword
dim strNewName
dim strNewAddress
dim strNewTelephone
dim strNewEmail
dim login
dim mode

'our string variables equal our form variables
strNewLogin = Request("newlogin")
strNewPassword = Request("newpassword")
strNewName = Request("newname")
strNewAddress = Request ("newaddress")
strNewTelephone = Request ("newtelephone")
strNewEmail = Request ("newemail")
strLogin = Request("login")
strPassword = Request("Password")
mode = Request("mode") 'mode will either be login or submit

'create the database connection
Set oConn = Server.CreateObject("ADODB.Connection")
'open the database
'oConn.Open "\mypath

'open the recordset
Set oRs = Server.CreateObject("ADODB.Recordset")

'if the mode is submit
if mode = "submit" then
strSql = "Select * From login Where login='"& strNewLogin & "'"
oRs.Open strSql,oConn,1,3
if oRs.EOF then
oRs.AddNew 'add a new record
oRs("login") = strNewLogin 'new login name
oRs("Password") = strNewPassword 'new password
oRs ("name") = strNewName 'new name
oRs ("address") = strNewAddress 'new address
oRs ("telephone") = strNewTelephone 'new telephone
oRs ("email") = strNewEmail 'new email
oRs("date") = Date()
oRs.Update 'update the recordset
Response.Write ("duplicate=false")
else
Response.Write ("duplicate=true")
end if
end if

'if the mode is login then
if mode = "login" then
strSql = "Select * From login Where login='"& strLogin & "' " & _
" And Password= '" & strPassword & "';"
oRs.Open strSql,oConn,1,3
if oRs.EOF then
'the go variable sent back to the movie is false
Response.Write ("go=false")
else
'we found it
Response.Write ("return="&oRs("Login") & "&go=true")
end if
end if

'clean up and close
set oRs = nothing
set oConn = nothing
%>

After I click on "login" button nothing happens, and when I check the post.asp files no error message

Thanks,

URL To Access Flash
Hello to the person reading this.
I have an HTML page that references a flash file module9.exe with an URL. The flash file is supposed to read a text file module9_source.txt when invoked through the URL, but does not. When I manuver to the directory with the browser and open the file module9.exe directly, it works - it reads the text file. Can someone please explain why this happens and how I can fix it. I can put the absolute path in my link, but the correct way would be to use an URL in case the server name changes.

Tnak you,
j_may

Is It Possible To Access SQL From Within Flash?
Is it at all possible to access MySQL from within flash? Any links to an example of where someone is moving data back and forth?

Flash With ASP + Access
doing a small asp/database project for college,

wanting to use flash. Does flash mx support asp?

Flash/ASP/Access
hi,
could someone provide me with a basic flash/asp/access sample that shows reading off a database into flash? i've searched the net but can't find a easy enough example (yes i'm stupid! ). i just want to add some basic dynamic text to a flash project i'm working on... thanks

tx

Access DB>ASP> Flash - Please Help
Greetings,

Before you read below, note that all of this stemmed form this tutorial:
http://www.kirupa.com/developer/acti...s_database.htm

I have created a flash movie that uses a form to submit information through ASP back to an Access DB using this line of code:

on(press){
loadVariablesNum("http://localhost/web/processForm.asp",0,"post");
gotoAndPlay(20);
}

What I'm confused about is how to get that data back out of Access into Flash.

I'm using the following ASP code to do what I think is the correct retreival :

<%@language = "VBScript" %>
<%
Dim conn
Dim strSQL
Dim rs

lookup = request.form("sslookup")

set conn = server.createobject("ADODB.Connection")
conn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:/Database/example.mdb"
set rs = Server.CreateObject("ADODB.Recordset")

strSQL = "SELECT * FROM contacts Where message='"&lookup&"';"

rs.open strSQL, conn

Do While not rs.EOF
Response.Write (rs("FirstName"))
Response.Write "<br>"

rs.movenext

Loop

rs.Close
Set rs = nothing
set conn = nothing
%>

And this code in flash to try and get it :

on(press){
loadVariablesNum("http://localhost/web/accessForm.asp",0,"post");
}

I'd like to populate text fields within flash with my data from access.

Thanks in advance for any help.

FTP Access Via Flash O.o
Hello I have a little problem.. i'm trying to access an ftp account via flash but.. i've tried everything i could imagine without result. I was wondering if there is something possible like:

getURL("ftp://user:password@ip/", "_blank");

Have anyone tried something similar?
Thanks in advance.

Flash & Access
Someone can help me with this, I did a submit form in flash, I have the asp file and the access database, but when I press the submit buton doesn't work, everything is the site already, I use getURL processForm.asp, 0, post, there is a better way to do this?

Thanks to all the people of this forum, I need help.

Maolink.

Flash With ASP + Access
doing a small asp/database project for college,

wanting to use flash. Does flash mx support asp?

Flash -> ASP -> MS Access
Hey,

I am having a problem getting a variable from send from ASP to Flash. Everything else works i can actualy POST vars from flash to ASP the to ms Access but at the end of adding a new usr password and type i would like to check if i get back a value posted from asp. I have created something similar before and it works great. i just can not find whats wrong in this one. Any help at all would be great. Here is the ASP and AS2.0

Code:
<%
Dim UserName, Password, usrType
UserName = trim(request("flaUser"))
usrPass = trim(request("flaPass"))
usrType = trim(request("flaType"))

Dim cn2
set cn2=Server.CreateObject("ADODB.Connection")
cn2.Provider="Microsoft.Jet.OLEDB.4.0"
DSNtemp = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("DatabaseSomedata.mdb; User Id=Admin; Password=")
cn2.Open DSNtemp

SQLstmt = "INSERT INTO Users (UserName, usrPass, Type) VALUES ('" & UserName & "', '" & usrPass & "', '" & usrType & "')"

cn2.execute SQLstmt
cn2.close
set cn2 = nothing
'set SQLstmt = nothing

Dim mainMessage
mainMessage="message1=1"
response.Write(mainMessage)
%>

Code:
_root.btnAdd.onRelease = function() {
var result_lv:LoadVars = new LoadVars();
result_lv.onLoad = function() {
if (this.message1 == "1") {

_root.txtError.text = "Added";
} else {
_root.txtError.text = "Cound Not add record!!!!" + message1.text;
}
};
var send_lv:LoadVars = new LoadVars();
send_lv.flaUser = _root.txtUser.text;
send_lv.flaType = _root.txtType.text;
send_lv.flaPass = _root.txtPass.text;

send_lv.sendAndLoad("addrow.asp",result_lv,"POST");
};
Thanks in advance

FAQ With Flash, Access And Php/asp....
Hello!

I have to make a FAQ section from a access database, PHP/ASP and my flash movie. I have two rows (among others) in my database q and a. When i go to my FAQ section in the flash page, i whant all the questions to be fetched fram the database. (I have that working.) But the challenge now, is that every question "string" has to become a lank, that opens a popupsite whith the correct answer from the database.

How can i do this? I tryed a few thing but I have to say i'm lost...

THANX goos

Remote Flash And Asp Access From Flash In Opera, Firefox
Hi All,

The real situation is that.
I have a flash and asp in same domain - domainA
I would like to use the same flash from another domains.

It works in IE in such way
<PARAM NAME=movie VALUE="

Flash Form To Access To Asp
Anyone know a solution to this.

I have a form in flash where i enter address information in one field, so it looks like this:

Shane M.
Addressline1
AddressLine2

My question is, when you type in the address into the single text box, you hit the enter keey after each line, so after shane m. Hit enter, then addressline1, hit enter.

Well that information on the form is then put into an access database via an asp script i made.

The problem I have is that i have another ASP script that pulls the information from the access database to display it as html. I can not get the asp script to see those (ENTER-Line Feeds) that were made in the flash form. I have tried the following asp code without any luck.

address = oRs("ADDRESS")
addresstemp = Replace(address, vbCrLf, "<'BR'>") (without the ( ' ) )

Response.Write(addresstemp)

the addres still all comes out on one line without LineBreaks, so i know the character stored in the database for the linebreaks isn't the vbcrlf anyone know what it is?

Shane

How Do I Get Flash To Access A Database On A CD...
I am trying to produce a CD using flash as the front end. I would like to know if it is possible to search and publish information from a database on the CD.

Would it be possible to use Visual Basic as the bridge from the database to flash?

cheers,

El-nig

Flash To Access & Back Again
I'm having a bit of trouble and would be very grateful for some help. I've been using Flash for a while and have developed a CBT package using Flash 5, so can do the basics.

I would like to expand my product to interact with a database. The purpose of this would be to track quiz scores and which elements of the training have been completed etc.

I'm not too hot on programming and therefore can not write VB, ASP etc, but may be able to follow and adapt an example. Does anyone know of a tutorial, or example files to get me started? Please? I really don't want to have to learn Perl just to do this.

The interface with Dreamweaver looks like it may be easier, but I'd prefer to keep it in Flash if possible.

Anyone??

FTP Access Via Flash Movie?
Hello and thanks for your time.

I am wondering if it is possible to upload and download to an FTP account via a GUI on either a flash movie or html page?

Any help would be greatly appreciated

Cheers

Microsoft Access And Flash?
anyone know how to tell flash to take a list of values out of an Access database, or even an ASP script?

Possible To Have Web Flash Access CDROM XML?
We need to have some server based Flash attempt to access a CDROM so that it can tell our server if they have the right CDROM in for playback. We basically want to ask the Flash to load some XML from the CDROM.

It would seem from reading MM's MX Security White Paper that this is impossible. Is there any way to privilege this with signing? Our product consists of a trusted hybrid rich media application with CDROM delivering video and web-based Flash delivering enhanced content. We're looking for a way to tell if the user has put the right CD in.

Any ideas would be appreciated...

TIA,

idealord