Emmz
Posts: 0
Joined: Sat Jun 23, 2012 11:06 pm

Dynamic query data in Rest Service ?

Updating database using multipal local storage variables.. ? eg.

INSERT INTO 'tech_activity' ('Tech ID', 'Date Time Posted', 'REF', 'Activity Type', 'Activity Info') VALUES ("value1","value2","value3","value4","value5")

When I can't map more than 1 item (values) to the query.

I tried This {TechActivityURL}?key={key}+query={query} in the Rest service URL but it places "+" in the spaces of the query

Basically...
I want the URL loaded from LocalVar(I can do that)
also The query and values from LocalVars and or input Fields..

Any suggestions?
Thanks again for your help !

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Dynamic query data in Rest Service ?

If I understand the question correctly, for request parameters, you can get data from local storage using its API:

code
localStorage.getItem('key');
/code

Emmz
Posts: 0
Joined: Sat Jun 23, 2012 11:06 pm

Dynamic query data in Rest Service ?

You mean in JS like this?
return INSERT INTO 'tech_activity' ('Tech ID') VALUES ("localStorage.getItem('ID')") ;
etc

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Dynamic query data in Rest Service ?

Yes, or first set it to a variable and then use in query.

Emmz
Posts: 0
Joined: Sat Jun 23, 2012 11:06 pm

Dynamic query data in Rest Service ?

I used direct localStorage.getItem('ID') within the return statment and it works perfect !!
Thanks again Max !

Return to “Issues”