sending a db row to client

[FireSmartFox]

I want to put one db row result to a SFSObject to send it to the user. There are max. 1-2 rows at the same time and for some reasons I want to do separate submits, not the complete result.

Code: Select all

ISFSArray res = dbManager.executeQuery(sql, new Object[] {});
               if (res.size() > 0) {
                  for (int i = 0; i < res.size(); i++) {
                     ISFSObject temp = res.getSFSObject(i);
                     
                     SFSObject resObj = new SFSObject();
                     resObj.putSFSArray("dbzeile", res.getSFSArray(i));
                     // ...
                  }
               }

The last line with the putSFSArray causes a conversion error

com.smartfoxserver.v2.entities.data.SFSObject cannot be cast to com.smartfoxserver.v2.entities.data.ISFSArray

What is the easiest why to put one db row into the Sfsobject?

[Lapo]

Hi,
I am not sure I understand. The query returns 1-2 rows max but you want to send them separately?
That doesn't sound too efficient. It's usually better to send data in one batch, unless it's very big or there's some other particular reason.

The simpler thing to do here is to just send the whole SFSArray returned by the executeQuery method.
Just wrap it into and SFSObject and send it:

Code: Select all

ISFSArray dbRes = dbManager.executeQuery(sql, new Object[] {});

if (dbRes.size() > 0)
{
   ISFSObject resp = new SFSObject();
   resp.putSFSArray("data", dbRes);
   
   send("command", resp, ... recipients...);
}

Hope it helps

[FireSmartFox]

Hi,
I am not sure I understand. The query returns 1-2 rows max but you want to send them separately?

Yes.

That doesn't sound too efficient. It's usually better to send data in one batch, unless it's very big or there's some other particular reason.

There are. The receiver for each row are different, so in the loop I assign each row to a different receiver depending to the row values.

The simpler thing to do here is to just send the whole SFSArray returned by the executeQuery method.
Just wrap it into and SFSObject and send it:

Yes, I know this possibility from the example code of the documentation. But it doesn't fit to my requirement to have different receiver which shouldn't get all rows or if I want to add some information to the single requests.

[Lapo]

There are. The receiver for each row are different, so in the loop I assign each row to a different receiver depending to the row values.

Okay, makes sense.

Yes, I know this possibility from the example code of the documentation. But it doesn't fit to my requirement to have different receiver which shouldn't get all rows or if I want to add some information to the single requests.

Every item in the result SFSArray is an SFSObject, containing the data for each column in your "SELECT" statement. You just need to send the SFSObject itself, extracted from the SFSArray.

Hope it helps