Code: Select all
sql="select id as myid from users";
queryRes=db.executeQuery(sql);
row=(DataRow)queryRes.get(0);
row.getItem("myid"); //does not work
row.getItem("id"); //does work
please tell me there is a way to get this to work?!
Code: Select all
sql="select id as myid from users";
queryRes=db.executeQuery(sql);
row=(DataRow)queryRes.get(0);
row.getItem("myid"); //does not work
row.getItem("id"); //does work
Code: Select all
SELECT
user.first_name, user.last_name, user.user_name, user.password, role.name AS roleName, partner.name AS parterName, partner.prefix AS partnerPrefix
FROM user
INNER JOIN
role ON user.r_role = role.id
INNER JOIN
partner ON user.r_partner = partner.id
WHERE user_name = ?
LIMIT 1;
Code: Select all
String roleName = row.getSFSObject(0).getUtfString("roleName"); //role name
String partnerName = row.getSFSObject(0).getUtfString("partnerName"); //role name
Code: Select all
trace(ExtensionLogLevel.WARN,"row JSON: " + row.getSFSObject(0).toJson().toString());
Code: Select all
{"user_name":"testuser","first_name":"John","name":"All Partners","prefix":"","last_name":"Smith","password":"testpass"}
Lapo wrote:Check this post -> viewtopic.php?p=3612#3612
Code: Select all
_server.executeQuery(theSql, _server.QUERY_INT_KEYS)
Code: Select all
trace(tempRow.getData());
Return to “Server Side Extension Development”
Users browsing this forum: No registered users and 38 guests