Page 3 of 7

Creating a search with 2 variables

Posted: Fri Mar 01, 2013 6:23 pm
by Chris Ross

Should I set a local storage variable on "county" or "restaurant"? Then maybe paste the javascript??


Creating a search with 2 variables

Posted: Fri Mar 01, 2013 6:37 pm
by Kateryna Grynko

Request parameter "where" sets conditions for choise not all, but definite values. Parameter:code{ "County": "...", "Restaurant": "..."}/code


Creating a search with 2 variables

Posted: Fri Mar 01, 2013 6:47 pm
by Chris Ross

So.......I need to setup a local storage in my query page, and on the answer page I need to set where to the local storage and add the JavaScript.....correct?


Creating a search with 2 variables

Posted: Fri Mar 01, 2013 6:59 pm
by Chris Ross

okay, i need to take a break. This is frustrating me.......


Creating a search with 2 variables

Posted: Fri Mar 01, 2013 7:38 pm
by Kateryna Grynko

Yes, you're right. You should add JS code I adviced (https://getsatisfaction.com/tiggzi/to...) that is needed to create a request:code{"county": ..., "restaurant": ...}/codeand send it in "where" parameter.


Creating a search with 2 variables

Posted: Sat Mar 02, 2013 6:09 pm
by Chris Ross

yes ma'am, I used excel and saved my database as a csv file


Creating a search with 2 variables

Posted: Sat Mar 02, 2013 6:18 pm
by Chris Ross

I tried it again, but it's still displaying all of my grades, not the one specified. i'll take some snapshots to post. Maybe I have the "where" parameter attached to the wrong thing??


Creating a search with 2 variables

Posted: Sat Mar 02, 2013 6:25 pm
by Chris Ross

Creating a search with 2 variables

Posted: Sat Mar 02, 2013 7:01 pm
by maxkatz

Have you tried running the where clause in the database console? There is a Query button that allows you to test the query.


Creating a search with 2 variables

Posted: Sat Mar 02, 2013 8:30 pm
by Chris Ross

I'll do that
thank you