CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 Change page count on grid navigator with SQL modified datasource

Print topic Send  topic

Author Message
csierra

Posts: 123
Posted: 07/23/2009, 12:28 AM

Hello all, i have a datagrid wich it's datasource.sql property is heavily modified on the beforeexecuteselect event, upon many conditions, and it does work fine BUT itīs navigator does not reflect the page numbers accordingly. e.g. the datasource on desingtime is a plain query, wich by default returns, letīs say, 3 pages; the grid then is forced to retreive only certain rows, letīs say 3 rows, or 1 page only, the navigator does not update the pagination correctly so, in the same event I am trying to reference the navigator to modify itīs datasource.sql property too, but no joy here; i am trying:
gridname.navigator.datasource.sql = sqlstring but I get an error that says variable not declared, why?

Is there a way to reference the navigator upon itīs grid.datasource? the event is fired and then we have grid.datasource as the sender, so I am thinking of something like

Dim ogrid

Set oGrid = Sender.PARENT -> do we have something alike? to then try
oGrid.Navigator.DataSource.SQL = SQLString

Any Ideas appreciated
_________________
Yes! I Can!!!
View profile  Send private message
csierra

Posts: 123
Posted: 07/23/2009, 12:43 AM

I was lost, it is the DataSource.CountSQL property wich has to be affected...

by the way I am wondering if I am asking too silly questions or is that oeveryone is just too busy to answer or what? I have posted at least 5 topics within the last month without a single comment on any of em... I am wondering too if it is just that ASP 3.0 is sooo death that everybody is moving to PHP... I am in the dilemma of learining PHP versos .NET and dont know where to move...
_________________
Yes! I Can!!!
View profile  Send private message
Oper


Posts: 1190
Posted: 09/16/2009, 3:17 PM

the question is no rellated to a specific program just a bit unclear
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message

Add new topic Subscribe to topic   


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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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