The :443 port (which is added in IE) is supposed to be removed internally before the query is sent. Are you getting the query url from firebug?
On Thu, Jul 29, 2010 at 8:34 PM, Colin M <[email protected]> wrote: > Query: > select E, count(A) where N != 'cancelled' and (E = 845) and D = 1656 > group by E > > URL: > > https://spreadsheets.google.com:443/tq?key=XXX&gid=0&tqx=out:csv&tq=select%20E%2C%20count%28A%29%20where%20N%20%21%3D%20%27cancelled%27%20and%20%28E%20%3D%20845%29%20and%20D%20%3D%201656%20group%20by%20E > > Also a user reported doing frequent re-sorting of the sheet, not sure > if it is related. I occasionally get timeouts too (10 seconds). Would > increasing the timeout wait decrease the chances of timeouts? The > queries complete in under a second when there are no errors. > > Thanks, > Colin > > On Jul 28, 12:40 pm, Badtnik <[email protected]> wrote: > > Hey Colin, > > Can you send an example query URL please? > > > > thanks > > badtnik > > > > > > > > On Wed, Jul 28, 2010 at 5:55 PM, Colin M <[email protected]> wrote: > > > Any idea why a Google Spreadsheet query would occasionally return a > > > 409 response code ("Conflict")? The API is read-only so this makes no > > > sense to me.. My query is using aggregation and returning a CSV format > > > and it happens maybe once a day. The spreadsheet is for the most part > > > append-only but there are possibly a few users viewing or editing the > > > spreadsheet simultaneous to the query. > > > > > Thanks, > > > Colin > > > > > -- > > > 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]><google-visualization- > api%[email protected] <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]<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.
