andreasfc
Posts: 26
|
| Posted: 01/24/2007, 6:16 AM |
|
I want to make some queries for reports within Codecharge but cannot fins a good manual for on how to make totals for columns etc.
I can do it very easily with Ms Access but don't now how to do it with CodeCharge yet.
Is it also possible to create a for/query where I can do filtering on a date later than today?
And how do I create a search filter for a minimum date and a maximum date?
I am mostly using PHP/MySql
Thanx
|
 |
 |
peterr
Posts: 5971
|
| Posted: 01/24/2007, 12:33 PM |
|
I recommend starting with CCS tutorials in the Help file because they explain how to configure queries to search for data entered by users on a Web page. For example:
A part of one tutorial: http://docs.codecharge.com/studio31/html/QuickStart/Cre...earchParam.html
A part of another tutorial: http://docs.codecharge.com/studio31/html/QuickStart/Cre...archParams.html
In case you don't need to use external value, for example to display records later than today, you can either copy the full SQL query from MS Access into CCS Visual Query Builder (SQL mode), or you can do this visually like above only change parameter's "Condition Type" to "Expression" and type any valid expression that your database will recognize, like "> Date()" or "> Now()".
Also see:
http://forums.codecharge.com/posts.php?post_id=44758
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
