general assistance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

baggyman - 27 Aug 2006 22:16 GMT

Hi hope you can help.
Firstly I'm new to using Flash to access info from a database, but not Flash
or Databases though.
I have an MS SQL Server Database which holds my shopping cart info. Each
product has an associated product image.
What I'm trying to do:
Allow users to search for products by region (this site is selling bottles of
wine) then display a product image in a horizontal scrolling gallery. As the
user hovers over a particular product more details are shown below. Users can
then enter the number of bottles they would like and add them to my basket.
(alternatively click on a link to go to my existing cart page which allows
users to update their basket)
There are over 1,200 products to search through.

I thought about manually creating some XML files which contain the relevant
search results but this means that when updating the product info - eg moving
to a different region - someone would have to manually chaneg the xml file.

Surely the result scan be created dynamically along with teh relevant image
gallery & more product info.

How can this be done?

Reply to this Message

Motion Maker - 31 Aug 2006 11:40 GMT

Look at the Flash XML.load or Flash XML.sendAndLoad methods and their
examples. They will guide you to the Flash side of receiving or sending and
receiving XML data.

http://livedocs.macromedia.com/flash/8/main/00002872.html
http://livedocs.macromedia.com/flash/8/main/00002879.html

The serverside receiving and generating the XML will depend on your server
side libraries.

A nice side is that in order test loading XML you can create a sample XML
file and use just the XML.load to get the practice. Or you can create a
basic serverside script that just returns XML such as using Response.write
in ASP and then you can test the XML.sendAndLoad without parsing the send
data until you use the XML parsers say in ASP. The rest is then you need to
deal with your database.

Signature

Lon Hosford
www.lonhosford.com
Flash, Actionscript and Flash Media Server examples:
http://flashexamples.hosfordusa.com
May many happy bits flow your way!

> Hi hope you can help.
> Firstly I'm new to using Flash to access info from a database, but not
[quoted text clipped - 27 lines]
>
> How can this be done?

Reply to this Message

Webmaster Forum / Flash / Data Integration / August 2006

general assistance