Database Connectivity w/o Server

[FrankEinstein]

Hello,

I'm wondering if anyone has used Flash Studio Pro in the past. I have a project where I need to connect to a database (Microsoft Access) and query that database for keywords. Preferrably keywords contained as a list in one of my fields. I tried doing this in Flash Studio Pro 1.5 and I was able to query the database with a:

SELECT * FROM Locations WHERE Company = 'CompanyName'

However, when I tried using LIKE, rather than =, it would only return results that were exactly the same as the field (rather than contained within it). On top of that, I want to page the results, because I might have numerous records. Whenever I tried to load the variables into a Movie Clip, it wouldn't do it. The program appeared to have what I needed for this project, but now I'm not sure. So I was wondering if anyone else has used it or had any success pulling this off? Or if not, does anyone suggest another program for this? I might have to look into using Director instead, but I'm not even sure about that. Any help or advice would be appreciated.

Thanks!!

[FrankEinstein]

I forgot to mention, this is all going on a CD-ROM. I'm sure that'll throw an even bigger monkeywrench into the whole thing :(

[tg]

try:

SELECT * FROM Locations WHERE Company LIKE '%CompanyName%'


the '%' are wild card characters, if they don't work try *... access likes the *, but the % should work.