Hi guys,
I have an unusual problem, but I will try maybe Ill be lucky.
Im working on DVD rental (catalogue) application with Flash MX 2004, Flash Studio Pro and Using MS Access Database. Im almost done except the part where I want to make exploring movies by name of actor/actress.
Actually whats happen: Im getting records (items) from DB and add to the ComboBox component of Flash, and this part going well, but I cannot resolve the part where I need to full List component with movies in which plays intended actor/actress.
I use separator to get items from DB and after I use this command to tell FSP to get all rows where name Tom Cruise appear.
I have function that shows items in List Box component but it doesnt matter.
My problem is here:
I put records into Combo on next way:
and after I use some variable to choose the names:
variable = evt.target.selectedItem;
then coming main part and my problem actually:
fscommand("flashstudio.selectfromdb", "\"SELECT * FROM mytable WHERE actors='"+variable+"' ORDER BY naslov ASC\"");
Where Im wrong, tell me if someone know, cause I have similar option within app and it works perfectly with an array and exploring movies by first name of movies title.
Sorry if I boring,
Thanks in advance