Hi,
Thats exactly what I ended up doing.
dim ggd
dim ggd2
while NOT gamesdisplay.EOF
ggd = gamesdisplay("gamecount") &","
gamesdisplay.movenext()
ggd2 = ggd2 & ggd
wend
and then ran a LEN on the results
Left(ggd2,Len(ggd2)-1)
Which removed the trailing comma as you suggested. So basically
exactly as you said.
Very cool, thanks for the help, works a treat now.
Chris
On May 13, 7:16 pm, ncalarco <[email protected]> wrote:
> Well, can you build your data string out prior to creating your image?
>
> If you can store your data in some variable prior to adding it to the
> image, you can just do some simple string manipulation to strip the
> last comma off.
>
> I.e:
>
> WHILE NOT gamesdisplayyearly.EOF
>
> strData &= gamesdisplayyearly("gamecount") & ","
>
> gamesdisplayyearly.MoveNext()
>
> strData = Mid(strData, 1, Len(strData) - 1)
>
> then, just add strData to your img src?
>
> Just a suggestion.
>
> -N
>
> On May 12, 6:06 am, ChrisPols <[email protected]> wrote:
>
>
>
> > Hi,
>
> > I couldn't think of a proper question to search for my problem.
>
> > My graphs are working correctly to a point, but i'm unable to get my
> > head around fixing a certain statement.
>
> > Here's my code for google charts:
>
> > <img src="http://chart.apis.google.com/chart?
> > chs=350x250
> > &chd=t:0<%while NOT gamesdisplayyearly.EOF%>,<
> > %=(gamesdisplayyearly("gamecount"))%><%gamesdisplayyearly.movenext()%><
> > %wend%>
> > &chxl=2:|<%while NOT datedisplayyearly.EOF%>|<
> > %=datedisplayyearly("months")%><%datedisplayyearly.movenext()%><%wend
> > %>|1:||3:|
>
> > My problem is the above bit of code. I'm running a while statement to
> > go over the data, but Google charts needs a comma as a separator. The
> > only workaround I managed is to start it with 0 and put in a comma
> > directly after that, so that you don't get a comma at the end of the
> > statement.
> > The data should read: 768,447,338,2287 - I end up with
> > 768,447,338,2287, (which causes google charts to break), so I do it
> > this way (as above) 0,768,447,338,2287 and it works. But I don't want
> > the 0 there.
> > I bet this is an easy repeat concept I just don't know it.
> > Any ideas?
>
> > Thanks a lot,
> > Chris
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Google Chart 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
> > athttp://groups.google.com/group/google-chart-api?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google Chart 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
> athttp://groups.google.com/group/google-chart-api?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Google Chart 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-chart-api?hl=en.
