hey please can u give some useful links for sql server query...m using sql database and want to access data from table..
On Monday, August 6, 2012 9:35:02 PM UTC+5, asgallant wrote: > > Chances are, you cannot connect directly to a SQL server database, as the > API doesn't have any support for directly querying databases; you have to > have some intermediary script that parses your query, queries the database, > and returns the requested data into the requisite JSON format. > > If you have a SQL server interface already set up, then you might be > better off using a custom AJAX call to the server and handling all the > formatting client-side. > > On Monday, August 6, 2012 12:01:44 PM UTC-4, Nutan Ranee wrote: >> >> What if a try to connect using connection string for sql server database? >> In this case what would be its connection string datasource url. >> >> On Mon, Aug 6, 2012 at 9:23 PM, asgallant >> <[email protected]<javascript:> >> > wrote: >> >>> This uses a query: >>> http://code.google.com/apis/ajax/playground/?type=visualization#data_source_request >>> >>> >>> Set the URL in the Query object constructor. >>> >>> >>> On Monday, August 6, 2012 12:49:38 AM UTC-4, Nutan Ranee wrote: >>>> >>>> Can you please provide me an example for providing URL in a Query, I >>>> guess the url which I was giving was wrong. There was no connection >>>> established and hence it was giving me 404 Bad request. >>>> >>>> On Saturday, 4 August 2012 07:57:51 UTC+5:30, asgallant wrote: >>>>> >>>>> Fetching data from your database involves more than just changing the >>>>> URL in a Query - your server has to have a script set up to interpret the >>>>> query and return data in the appropriate format. The visualization team >>>>> built JSP and python libraries for doing that, and there are threads on >>>>> this forum about putting data from a database into a JSON representation >>>>> of >>>>> a DataTable in PHP. >>>>> >>>>> As far as the 404 error goes, I'd have to see your complete js code to >>>>> see what might be the problem. >>>>> >>>>> On Friday, August 3, 2012 8:43:35 AM UTC-4, Nutan Ranee wrote: >>>>>> >>>>>> Hello, >>>>>> I'm new for using Google APIs and is looking for a snippet which >>>>>> could help me out in using goggle visualization API. My motive is to add >>>>>> dynamic data instead of using data from spreadsheets. The API which I >>>>>> was >>>>>> using looks for getting data from remote could not explain this(ref : >>>>>> Setting the Query from JavaScript >>>>>> Collapse | Copy Code >>>>>> https://developers.google.com/**chart/interactive/docs/** >>>>>> querylanguage#Setting_the_**Query_in_the_Data_Source_URL<https://developers.google.com/chart/interactive/docs/querylanguage#Setting_the_Query_in_the_Data_Source_URL> >>>>>> ). >>>>>> I added a datasource url but it gives me an error as Microsoft >>>>>> JScript runtime error: google.visualization.Query: Not Found [404]. >>>>>> Please >>>>>> help me in getting remote data from my database instead of spreadsheets. >>>>>> Thanks in advance. >>>>>> Nutan >>>>> >>>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Google Visualization API" group. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msg/google-visualization-api/-/y_fQeQsUaMYJ. >>> >>> To post to this group, send email to >>> [email protected]<javascript:> >>> . >>> To unsubscribe from this group, send email to >>> [email protected] <javascript:>. >>> For more options, visit this group at >>> http://groups.google.com/group/google-visualization-api?hl=en. >>> >> >> >> >> -- >> Nutan R >> >> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
