Column Name in getDatasetByQuery result?

Classic Servoy
1

Hi Folks

I’m using getDataSetByQuery and I can get the value of a row/column from its index. I want to select the value using the column name, though I may not know the position of that column in the index.

Is there a syntax I can use to do ‘dataset.getValue(myColumnName)’ ?

Appreciate feedback.

2

You can use:

dataset.myColumnName

for example with a loop:

	var dataset = databaseManager.getDataSetByQuery(currentcontroller.getServerName(),"SELECT myColumnName FROM myTable",null,-1);

	for (var i = 1; i <= dataset.getMaxRowIndex(); i++) {
		dataset.rowIndex = i;
		application.output(dataset.myColumnName);
	}
3

Joas:
You can use:

dataset.myColumnName

for example with a loop:

	var dataset = databaseManager.getDataSetByQuery(currentcontroller.getServerName(),"SELECT myColumnName FROM myTable",null,-1);

for (var i = 1; i <= dataset.getMaxRowIndex(); i++) {
	dataset.rowIndex = i;
	application.output(dataset.myColumnName);
}

Thanks Joas, so to get the value its just dataset.myColumnName.getValue() ??

4

Kahuna:
Thanks Joas, so to get the value its just dataset.myColumnName.getValue() ??

No, without the .getValue, just dataset.myColumnName:

var x = dataset.myColumnName;
5

Joas:

Kahuna:
Thanks Joas, so to get the value its just dataset.myColumnName.getValue() ??

No, without the .getValue, just dataset.myColumnName:

var x = dataset.myColumnName;

Great thanks Bud

6

Joas:

Kahuna:
Thanks Joas, so to get the value its just dataset.myColumnName.getValue() ??

No, without the .getValue, just dataset.myColumnName:

var x = dataset.myColumnName;

Joas - on testing that syntax returns a null value - where using the getValue(1,2) returns the correct value (integer)?

vweight = dataset.getValue(1,2); Correct.

application.output(‘Dataset by Column Name :’ + dataset.cui_itconf_pipe_horz_45); Returns Null.

Am I missing something?

7

Did you set the rowindex to 1?

Can you post your script?

8

Joas:
Did you set the rowindex to 1?

Thats what I missed Joas - works a treat now - thanks again.