dcsimg
A Flash Developer Resource Site

Results 1 to 5 of 5

Thread: Help >>>> SQL / Flash

  1. #1
    the other one
    Join Date
    Mar 2001
    Posts
    96
    We have succesfully got flash to interact with our SQL db ( I am quite proud to have eventually got this working after on off tinkering for 3 Months, dont give up).

    What i would like to do now is sen out a mail to 10 people ( flash embedded into the mail) somehow flash must dynamically have a id in it that must pulll the relevant information for this person out of the db.


    The part I do not have know how to do is to assign an id to the html/ flash mail file.

    Any help out there Please.

    kindest
    Craig

  2. #2
    Registered User
    Join Date
    Feb 2001
    Posts
    13,044
    Hi,

    since it is possible that the movie daes not display in the mail, it is best to format the html with
    <embed src="http://yoursite.com/movie.swf?id=33">
    and corresponding <object> tag and have the text part of the mail suggest to open http://yoursite.com/movie.swf?id=33
    The movie would then loadvariables with the id value to retrieve database details

    Privacy problem: what happens if the recipient of that mail is curious about id=32 ?

    Musicman

  3. #3
    the other one
    Join Date
    Mar 2001
    Posts
    96
    Hi Musicman,
    I have a working version that parses a variable from html to my flash file via JavaScript, but after some tests have found out that the new MS security patch does not allow javascrips or other scripts to run without some user intervention 8-(.

    I am interested to pursue your suggestion.

    This may be a silly question but how do I get the flash file residing at http://yoursite.com/movie.swf to interpret the variable from the mail to draw in the appropriate data ???

    As for the privacy issue -: the identifier I would use is their email address, so it would be more difficult.

    Looking forward to any possible light you can throw on the subject.

    Kindest

  4. #4
    Senior Front End Developper
    Join Date
    Dec 2000
    Location
    Montréal
    Posts
    568
    Look at my post about the flash param, flashVars

    http://board.flashkit.com/board/show...hreadid=366740

  5. #5
    the other one
    Join Date
    Mar 2001
    Posts
    96

    Thank You

    Thanks all,

    I got it up and running.

    Kindest

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center