CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 where is my where clause (PHP/MYSQL)

Print topic Send  topic

Author Message
stephenk
Posted: 09/25/2003, 9:44 AM

I am trying to dynamically change my where clause in a grid form

On other pages I managed to modify it in two ways
(before execute select event.)
If the first didnt work the second did:

1)
<code>
Global $gridname;
$gridname->ds->Where = "new clause";
</code>

2)
<code>
Global $pagename;
$pagename->gridname->ds->Where = "new clause";
</code>

I now have a page in which neither works
Please help me
Karen
Posted: 09/25/2003, 9:40 PM

Try the first option in the Before Build Select event. Just an idea and hope it works.

-Karen
stephenk
Posted: 09/26/2003, 12:20 AM

I solved the problem by having a bogus where clause in the datasource.
-The clause must have a default value
-If it doesn't it seems that the property is never initialised

Thanks Karen for helping

   


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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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