Flash - ASP - Access

[The Lore]

Hmm..
Can anyone help?
I am fairly new to action scripting (done a little from tutorials but not a huge amount)

However I should point out I do know ASP pretty well...

Anyway my question is,

If I have a flash 5 movie, in which I want text to come out of a access database, preferably using ASP..

How do I go about it...?...

I have searched the tutorials but haven't found anything to help..

Am I missing something, is there a tutorial that could help??

Many Thanks, in advance...

L.

[sjdeere]

I don't know asp that well but I was able to load in text from a microsoft access database into a flash movie using ASP - thanks to this great tutorial/s

http://63.236.73.180/articles/flash/

http://63.236.73.180/articles/flash2/index.asp


if anyone finds other similar tutorials please post here

---------------------------------
My Problems

I want to create a diary system ie not just pull in the text but also order by data and spilt into headed columns etc.. I know how to do it using Ultra Dev / html/asp

Any tips on the key bit of code to sort by a field and getting this into flash.

The flash 2 link shows how to call the mailto client I just want to make it a simple URL I think


The tutorial email link pulled from database - results is a recordset EmailAddress is a field in a table

results = results & "<A HREF=" & Chr(34) & "mailto:" & _
oRS("EmailAddress") & Chr(34) & "><u>" & _
oRS("EmailAddress") & "</u></A>" & _
vbCrLf

can anyone make this code just a simple Url link not a maito one.

I think the key thing in this tutorial is that you have to url endode everything thats sent to flash.

I have a diary system which displays HEADING, DATE, SECTION, can I display the data in the 3 heading cloumns and order by these database field in a flash movie ?

Does this require Flash Generator for this kind of thing.

How can you split things horizontally do you table it like you would in Ultra Dev?

I know the text box in flash can be set to html ?

[NerdInside]

What kinda data base? If it is a username in, info out. That can be done without ASP. Reply what kind it is.

[sjdeere]

the database is microsoft access

there is a table called diary with the fields

date
heading
section


there is a another table tblSecurity

username
password
level


I will be using the stuff in tblsecurity for a login admin page area which will then allow an administraor to alter the diary content
this won't be visible to web users visiting the flash site. (back end) - no problems here

problem
I just want to display DATE HEADING SECTION content in columns in FLASH and be able to order the colum display ie by date or heading or section.


If I don't need ASP then how do I go about things ????

Thanks
[Edited by sjdeere on 06-11-2001 at 06:41 AM]