Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Inyathy  
#1 Posted : Tuesday, May 2, 2017 1:23:38 PM(UTC)
Inyathy

Rank: Member

Groups: Registered
Joined: 12/6/2016(UTC)
Posts: 16
South Africa
Location: Johannesburg

Thanks: 2 times
Hi,
I have DBExecute Query onButtonClicked in Mobile Together (SELECT LogonID, Password FROM Table WHERE LogonID = :Logon AND Password = :Password) and assigned the relevent XPath values to :Logon and :Password.

When button is "clicked", the query executes with no erros and the relevent row is retrieved.

Am I correct in understanding that the query result is stored in the mt$MT_DBExecute_Result variable (Store Results of SELECT statements in mt$MT_DBExecute_Result is checked)and if so, how do I dispaly the mt$MT_DBExecute_Result variable values in a attribute in PERSISTENT/root?

I have checked the manuals and only found "This variable can then be used in XPath expressions elsewhere on the page to provide the result of the DB Execute action." - but does not say how?

HELP!!
bbv  
#2 Posted : Tuesday, May 2, 2017 7:08:51 PM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 495

Was thanked: 87 time(s) in 87 post(s)
You can make your life a lot easier if you use instead of DBExecute a new page source with the same SQL query. A page source will show you a whole structure of what you get.

If you still want to stick to using DBExecute, then the result is always in the same format, as it would come in a page source, i.e. DB/RowSet/Row/@attribute. Which means you address it with:

$MT_DBExecute_Result/DB/RowSet/Row/@attribute
Inyathy  
#3 Posted : Wednesday, May 3, 2017 11:45:48 AM(UTC)
Inyathy

Rank: Member

Groups: Registered
Joined: 12/6/2016(UTC)
Posts: 16
South Africa
Location: Johannesburg

Thanks: 2 times
Hi bbv
Yip, indeed I used a new page source with SQL query and all working well - Thank you! -
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.