Sorry about the link. It was just an example of the query where it says "select B,C,D,E". I didn't intend for it to actually link.
The following link is the page where I learned about what I am trying to do. http://blog.ouseful.info/2009/05/18/using-google-spreadsheets-as-a-databace-with-the-google-visualisation-api-query-language/ These two links are the spreadsheet and query. https://spreadsheets.google.com/ccc?key=tYK02LkiX1h0uQCFb8i-uKw&hl=en&authkey=COim074N#gid=0 https://spreadsheets.google.com/tq?tqx=out:html&tq=select%20A,B%20where%20B%20contains%20%22Option%204%22&key=tYK02LkiX1h0uQCFb8i-uKw&hl=en&authkey=COim074N#gid=0 What I want to do is have a link where it will do a query that is something like "where A contains today", so that everyday the link will query that day. So the same link will pull all the rows where column A contains "11/23/2010" on 11/23/2010 and on the next day (11/24/2010) all the rows where A contains "11/24/2010". Sorry, this feels rather difficult to describe clearly. There are few problems I am having. The first is that it doesn't seem to take "today" as a valid query. If there is something that it WILL take, that would be best. If I have to actually do it by each individual day, it would be nice to be able to query it using the actual formatted way: "11/24/2010". But the time stamp is actually a decimal number that represents the day: "40505.861400463". It will only take the decimal number in the url. I think that's about as descript and clear as I can get. If you have any more questions let me know. What I would like to do is have something On Nov 23, 3:14 am, Viz Kid <[email protected]> wrote: > Hi > > I'm not sure what you meant (and I cannot see the spreadsheet you linked > to). > Please try to explain in more details and possibly provide > an accessible example spreadsheet. > > Best, > Viz Kid > > > > > > > > On Fri, Nov 19, 2010 at 6:11 AM, Deliman96 <[email protected]> wrote: > > Hello, > > > I am trying to query a google spreadsheet using the url like so: > > >http://spreadsheets.google.com/tq?tqx=out:html&tq=%20select%20B,C,D,E... > > > What I would like to do is have a code that will always query it > > according to "today" ( what ever day it may be at the time) right now > > I tried to use the "where A contains '40496'" but that is only for a > > single day. I would like it to be dynamic. > > > Thanks > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google Visualization API" group. > > To post to this group, send email to > > [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<google-visualization- > > api%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
