CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Get data from SELECT in grid

Print topic Send  topic

Author Message
Jeroen
Posted: 07/26/2002, 3:32 AM

I want to get data from the query I made in a grid. I can do this simply by making a label and selecting the field I want to show. But I want to get data from it without using a label, because I don't want the grid to show it.
I made an updatable grid. I made a label which I assigned the following code

global $shopping_partsl1;
$quantity = $shopping_partsl1->Alt_quantity->GetValue();
$partid = $shopping_partsl1->partid2->GetValue();
$quantityinput = "<input name=\"$partid\" value=\"$quantity\" dir=rtl size=4>";
$shopping_partsl1->Alt_quantity->SetValue($quantityinput);

Now this all works fine. But now I'm stuck with the partid2 label in my grid, and this is what I don't want. And I don't want to make a hundred extra db queries. So what can I do to get the partid data from the query that is made in the grid? Normally I would do this with mysql_fetch_array or something.

Or if there is a simple way to make the label not to show, that would also be a simple sollution.

Guest
Posted: 07/27/2002, 6:19 AM

hmm.., may be you can add hidden field to the form
Jeroen
Posted: 07/27/2002, 11:17 AM

How smart is that! That I didn't think of that, lol. Somethings I'm thinking the hardway when the solution is very simple. Thank you :)

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.