Combobox problem (probably obvious answer)

[cjhsb]

Hi all,

Firstly let me excuse myself by saying I'm pretty new to Flash.

I've read a number of posts on this and other boards regarding problems with comboboxes and managed to work my Actionscript around into something that I feel should be working as a result.  However, I can't find the specific answer to my quandry, and I'm tearing my hair out trying to fix it on my own!

The idea is pretty simple - populate a Combobox with one column from a Dataset.

Here's my script so far:

trace(TentTypesDataSet.schema);
var lo:Object = {};
lo.afterLoaded = function(){
trace ("Lo function triggered (dataset loaded)");
   count = TentTypesDataSet.length;
trace ("RS function triggered");
trace(count);
   for(i=0;i<count;i++)
   {
TentTypesCB.addItem(TentTypesDataSet.NAME.getItemAt(i),TentTypesDataSet.NAME.getItemAt(i));
trace (i);
trace (TentTypesDataSet.NAME.getItemAt(i));
   }
}
TentTypesDataSet.addEventListener("afterLoaded", lo);



The debug output from this reads as follows:

<properties><property name="ID"><type name="Integer" original="false"><validation className="mx.data.types.Int"><settings /></validation></type></property><property name="NAME"><type name="String" original="false"><validation className="mx.data.types.Str"><settings /></validation></type></property><property name="SIZE"><type name="String" original="false"><validation className="mx.data.types.Str"><settings /></validation></type></property><property name="INFO"><type name="String" original="false"><validation className="mx.data.types.Str"><settings /></validation></type></property><property name="PRICE"><type name="String" original="false"><validation className="mx.data.types.Str"><settings /></validation></type></property><property name="IMAGE"><type name="String" original="false"><validation className="mx.data.types.Str"><settings /></validation></type></property></properties>
Lo function triggered (dataset loaded)
RS function triggered
4
0
undefined
1
undefined
2
undefined
3
undefined


It seems obvious to me that I'm not calling the values stored in the column called NAME correctly, as everything else appears to work.

Can anyone out there please tell me how to correctly call the data held in NAME, as TentTypesDataSet.NAME.getItemAt(i) doesn't work nor do any of the logical alternatives I have tried.

Many thanks in advance (and for my hair too!)

Carl

[Jorge Solis]

Should be:

 TentTypesDataSet.getItemAt(i).NAME

Where NAME is the name of the column

Jorge

[cjhsb]

Should be:

 TentTypesDataSet.getItemAt(i).NAME

Where NAME is the name of the column

Jorge

Thanks for the quick reply Jorge, it's much appreciated.

I thought when I read that somehow I had missed trying it that way round, but no, that still gives me the same output of 4 lots of undefineds. 

Any other ideas?

[Jorge Solis]

Inspect your row:

trace (i);
row = TentTypesDataSet.etItemAt(i);
for(z in row) trace(z+":"+row[z])

Jorge

[cjhsb]

Inspect your row:

trace (i);
row = TentTypesDataSet.etItemAt(i);
for(z in row) trace(z+":"+row[z])

Jorge

Ok, that added like so:

trace(TentTypesDataSet.schema);
var lo:Object = {};
lo.afterLoaded = function(){
trace ("Lo function triggered (dataset loaded)");
   count = TentTypesDataSet.length;
trace ("RS function triggered");
trace(count);
   for(i=0;i<count;i++)
   {
TentTypesCB.addItem(TentTypesDataSet.getItemAt(i).NAME,TentTypesDataSet.getItemAt(i).NAME);
trace (i);
row = TentTypesDataSet.getItemAt(i);
for(z in row) trace(z+":"+row[z]);
trace (TentTypesDataSet.getItemAt(i).NAME);
   }
}
TentTypesDataSet.addEventListener("afterLoaded", lo);

Adds nothing to the output window:

Lo function triggered (dataset loaded)
RS function triggered
4
0
undefined
1
undefined
2
undefined
3
undefined

Hope that helps?

[Jorge Solis]

Sorry, thinking in a datagrid not in a dataset. Check docs, getItemAt is a method of datagrid. Use mydataset.next() and myDataset.currentItem.NAME to get values. Example code on Flash manual.

Jorge

[cjhsb]

Sorry, thinking in a datagrid not in a dataset. Check docs, getItemAt is a method of datagrid. Use mydataset.next() and myDataset.currentItem.NAME to get values. Example code on Flash manual.

Jorge

Ah yes that would indeed do it - no need to apologise - it was my mistake to start with!

Works great now, thanks again Jorge!