# getDataSetByQuery problem

**URL:** <https://forum.servoy.com/t/getdatasetbyquery-problem/3092>\
**Category:** Classic Servoy\
**Created:** [November 18, 2004, 1:45pm UTC](https://forum.servoy.com/t/getdatasetbyquery-problem/3092 "2004-11-18T13:45:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gstein](https://avatars.discourse-cdn.com/v4/letter/g/c89c15/32.png) [@gstein](https://forum.servoy.com/u/gstein)\
**Post date:** [November 18, 2004, 1:45pm UTC](https://forum.servoy.com/t/getdatasetbyquery-problem/3092/1 "2004-11-18T13:45:07Z")

</div>

I am trying to write a method the value of one field in one record of a table. It seemed getDataSetByQuery is the best way to do this, but its not working.

Here is my code:

```auto
var myField = arguments[0]
var myTable = arguments[1]
var myWhere = arguments[2]

var mySql = "Select " + myField + " From " + myTable
if (myWhere > "") 
	mySql = mySql + " Where " + myWhere
	
var dataset = databaseManager.getDataSetByQuery(currentcontroller.getServerName(),mySql,null,1);	
application.output(mySql)
application.output("dataset[0] "+dataset[0]+" dataset[1] "+dataset[1]);

```

Am I doing something wrong and/or is there a better way to do this?

---

<div class="post-metadata">

**Author:** ![maarten](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@maarten](https://forum.servoy.com/u/maarten)\
**Post date:** [November 18, 2004, 1:55pm UTC](https://forum.servoy.com/t/getdatasetbyquery-problem/3092/2 "2004-11-18T13:55:11Z")

</div>

> if (myWhere \> “”)

Is this if-statement supposed to say “when myWhere has a value” ?  
Because in that case do this:

> if(myWhere)

---

<div class="post-metadata">

**Author:** ![gstein](https://avatars.discourse-cdn.com/v4/letter/g/c89c15/32.png) [@gstein](https://forum.servoy.com/u/gstein)\
**Post date:** [November 18, 2004, 2:02pm UTC](https://forum.servoy.com/t/getdatasetbyquery-problem/3092/3 "2004-11-18T14:02:33Z")

</div>

The Sql is getting generated fine, even with the if (myWhere \> “”) syntax. Thats not the problem.

The problem is getting the result from that Sql.

---

<div class="post-metadata">

**Author:** ![maarten](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@maarten](https://forum.servoy.com/u/maarten)\
**Post date:** [November 18, 2004, 2:25pm UTC](https://forum.servoy.com/t/getdatasetbyquery-problem/3092/4 "2004-11-18T14:25:11Z")

</div>

myField = dataset.getValue(1, 1); //set column with value in row1 column1