[quote]Populating an Array with database data

[SWFKit]

move360 say:

I am evaluating SWFkit and specifically looking to use it for a Access database application. I would like to populate an array with data from a database. Can you post a quick example of this? For example here is a simple Select statement.

record = conn.Execute("Select name from table1 where available = 1");

I would like to place the data into an array in Flash.

Thanks,

Move360

[SWFKit]

move360 say:

I guess to answer my own question, record would actaully be my array and I would just need to use the AcitveX functions to access what I need. Is this correct?

I see that in the database example I downloaded from your site.

But here is another questions. Let's take the Select I posted before:

record = conn.Execute("Select name from table1 where available = 1");

Let's say I have 10 records returned that all have available=1. They are Ed, Mike, Jim, Terry, Ray, Fred, Amy, Jill, Terra, Marlee.

Now to display the first one is pretty easy and I see that in your example. I could do something like this.

FlashPlayer.bindData("Name");

But what if I have 3 fields in my SWF. They are Name1, Name2, and Name3.

I want to show the first 3 names that were returned from the Select.

How can this be done?

[SWFKit]

move360 say:

Okay, looking at the ADODB ActiveX functions there is no way to do what I need.

So, the only solution would be to get the record from my SELECT....

record = conn.Execute("Select name from table1 where available = 1");

...into an array in Flash.

Any ideas?

[SWFKit]

if you want to show the first 3 names,just select the first 3 record,and join them into a String object,then bind the String to swf.

FFish Script:

FlashPlayer.bindData("names");
record = conn.Execute("Select name from table1 where available = 1");
record.MoveFirst();
var names = record.Fields(1).Value.toString();
for (i = 0; i < 2; i ++)
{
  record.MoveNext();
  names += "||" + record.Fields(1).Value.toString();
}
FlashPlayer.names = names;
FlashPlayer.updateData(false);

in the actionscript:

var names;
yourArray = new Array();
yourArray = names.split("||");

[SWFKit]

move360 say:

Thanks. I will give this a try.

Cheers.

[SWFKit]

move360 say:

I have not been able to get this to work. Does the SWFkit have any suggestions?