Beautiful...........worked great, thanks a lot my friend. Note: in php it is not looking clumsy.........i used an appending string while looping around the fetched data, then used trim function to make the changes(was able to do that three additional lines of code).
On Mar 20, 1:32 pm, Liono <[email protected]> wrote: > thanks, I will try building a string and then passing it as > coordinates. > > On Mar 20, 1:13 pm, Andy Cater <[email protected]> wrote: > > > This is probably a really crappy way of doing it but I am building them > > through a loop like this: > > <% > > LMCTypeData = "" > > LMCTypeName = "" > > do until rs.EOF > > If LMCTypeData = "" then > > LMCTypeData = rs.Collect("Count") > > Else > > LMCTypeData = LMCTypeData & "," & rs.Collect("Count") > > End if > > If LMCTypeName = "" then > > LMCTypeName = rs.Collect("Count") & " " & > > rs.Collect("NewAppChangeType") > > Else > > LMCTypeName = LMCTypeName & "|" & rs.Collect("Count") & " " & > > rs.Collect("NewAppChangeType") > > End if > > rs.MoveNext > > loop%> > > > <%Response.Write("<img src='" & > > "http://chart.apis.google.com/chart?cht=bvs&chd=t:"; & LMCTypeData & > > "&chs=355x200&chtt=" & LMClosedCnt & "+Closed+Requests&chdlp=r&chdl=" & > > LMCTypeName & "'/>")%> > > > On Fri, Mar 20, 2009 at 12:03 PM, Liono <[email protected]> wrote: > > > > I am trying to createdynamicchartswith values retrieved from a > > > database. > > > I am facing some problem as to how to pass the coordinates values > > > through an array ? > > > How would I pass the values if I don't know the array elements ?, I > > > have to insert "|" or "," after every value of a coordinate but > > > nothing after the last element. > > > Can I get some pointer for this ? thanks. > > > > example: > > > chd=t:<?=$testNumbers[0]?>,<?=$testNumbers[1]?>,<?=$testNumbers[2]?>,<? > > > =$testNumbers[3]?>|150,500,200,600& > > > > chly=<?=$testText[0]?>|<?=$testText[1]?>|<?=$testText[2]?>|<?=$testText > > > [3]?>& --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
