# Seelct record from db

**URL:** <https://forum.servoy.com/t/seelct-record-from-db/17889>\
**Category:** Classic Servoy\
**Created:** [April 4, 2014, 7:34am UTC](https://forum.servoy.com/t/seelct-record-from-db/17889 "2014-04-04T07:34:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DEK4](https://avatars.discourse-cdn.com/v4/letter/d/c68b51/32.png) [@DEK4](https://forum.servoy.com/u/DEK4)\
**Post date:** [April 4, 2014, 7:34am UTC](https://forum.servoy.com/t/seelct-record-from-db/17889/1 "2014-04-04T07:34:04Z")

</div>

Hi!

I need to load an record from DB with a SQL query.

This is my actual code:

```auto
/** @type {JSFoundset} */
var _fs = databaseManager.getFoundSet(globals.databaseName,_parTableName)
var query = 'SELECT * FROM '+_parTableName+' WHERE id'+_parTableName+' = ?';

var dataset = databaseManager.getDataSetByQuery(globals.databaseName, query, _parPKs, -1);
_fs = databaseManager.getFoundSet(dataset.createDataSource('memTable'+globals.getUUID()))
_fs.loadAllRecords()

```

I try also but I have an error:

```auto
_fs.loadAllRecords(query, _parPKs)
 com.servoy.j2db.dataprocessing.DataException: ERROR: subquery has too many columns

```

I need the record stored into the DB, in this way I get it but it’s slow…any suggestion??

thanks

---

<div class="post-metadata">

**Author:** ![jasantana](https://avatars.discourse-cdn.com/v4/letter/j/e79b87/32.png) [@jasantana](https://forum.servoy.com/u/jasantana)\
**Post date:** [April 4, 2014, 11:37am UTC](https://forum.servoy.com/t/seelct-record-from-db/17889/2 "2014-04-04T11:37:30Z")

</div>

For your second option you must not query for \*, just the PK

---

<div class="post-metadata">

**Author:** ![DEK4](https://avatars.discourse-cdn.com/v4/letter/d/c68b51/32.png) [@DEK4](https://forum.servoy.com/u/DEK4)\
**Post date:** [April 4, 2014, 1:19pm UTC](https://forum.servoy.com/t/seelct-record-from-db/17889/3 "2014-04-04T13:19:33Z")

</div>

Is this secure 100% that I get the record from the DB and NOT from the cache?

---

<div class="post-metadata">

**Author:** ![jasantana](https://avatars.discourse-cdn.com/v4/letter/j/e79b87/32.png) [@jasantana](https://forum.servoy.com/u/jasantana)\
**Post date:** [April 4, 2014, 3:25pm UTC](https://forum.servoy.com/t/seelct-record-from-db/17889/4 "2014-04-04T15:25:29Z")

</div>

I’d say yes.

BTW. Reading your post again I see you are using loadAllRecords(). You should use just loadRecords()