How to store files and retrieve the excel file to database

Sun Sep 23, 2012 5:06 pm

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

Sun Sep 23, 2012 9:55 pm

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?

Mon Sep 24, 2012 2:50 am

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

Mon Sep 24, 2012 3:21 am

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.

Mon Sep 24, 2012 3:31 am

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?

Mon Sep 24, 2012 3:57 am

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.