Page 2 of 2

How to store files and retrieve the excel file to database

Posted: Sun Sep 23, 2012 5:06 pm
by bindu

yes it is working if dont use the query parameter then it is returning all the records. Do i need to map the query parameter to something which i didn't do as shown in the above screenshot


How to store files and retrieve the excel file to database

Posted: Sun Sep 23, 2012 9:55 pm
by maxkatz

I'm not 100% sure I understand what you are trying to do. You are getting data from SQLite database to create a query against Tiggzi database?


How to store files and retrieve the excel file to database

Posted: Mon Sep 24, 2012 2:50 am
by bindu

no i am using Tiggzi database only. i have created the SchedulesDB database using Tiggzi database link http://io.tiggzi.com . Now i want to query this database based on the where condition. How do i modify my service request parameters


How to store files and retrieve the excel file to database

Posted: Mon Sep 24, 2012 3:21 am
by bindu

Please find the below screenshot.

I have used the where request parameter as {'dc':'Bangalore'} then iam getting only those records whose dc is Bangalore. Now i want the value of dc to retrieved from localStorage.

as {"dc":" '+localStorage.getItem('dc')+' "} but this gives [] as the response.

Image


How to store files and retrieve the excel file to database

Posted: Mon Sep 24, 2012 3:31 am
by bindu

Hey Max Got this working .. Thanks for the help :) .. I have one more question.. If there are no records then i want to display the message like no records found message how can i do this?


How to store files and retrieve the excel file to database

Posted: Mon Sep 24, 2012 3:57 am
by maxkatz

Glad it's working.

Add a Label component and hide it by default (uncheck Visible). When you run the service and it returns no data, add some text to the label and make it visible. You can do it in service's success event.