:: Forum >> Version 2 >>

How about from a SQL Query?

More information on this topic is available in the documentation section: /active.howto/.

Anyone have sucess with this?
shuxclams
Wednesday, November 30, 2005
What is your question? You are pretty criptic, please provide a little more information and someone might be able to assist you.
Jim Hunter
Wednesday, November 30, 2005
That would be pretty helpful!

Jim, I think shuxclams is referring to using data from an SQL query to populate the grid.
Aaron P.
Wednesday, November 30, 2005
try using an xml data island. That way you don't have to loop through the recordset manually. There are examples of this in this forum. I did it and added a stylesheet, and it works great.
Jim Shaffer
Monday, December 5, 2005
can we format our mysql data's to xml format?????
ngn
Friday, December 9, 2005
no. you can't.
johny
Wednesday, December 21, 2005
Of course you can. Depending on how you are populating the grid. You can certainly format a query result into XML form.

This is just PHP pseudo-code, and by no way complete

while($row=mysql_fetch_assoc($result))
{
     
$xml .= "<mytag>".$row[field]."</mytag>";
}
 
Or course it would need to be correct format. But YES, you can do it.

A slick way would be to call an AJAX procedure to get the new XML, and then call the function that would populate the data. Unfortunately I am just starting to learn the code, and can't inform you of the actual call. Maybe Jim or Alex could reflect some insight.
Tony
Wednesday, December 21, 2005



This topic is archived.

Back to /active.howto/

Documentation:

Forum search