Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » Creating filters
Creating filters [message #294] Mon, 25 September 2006 15:58 Go to next message
ecw201 is currently offline  ecw201
Messages: 1
Registered: September 2006
Junior Member
This really is a great way to set up a web application. I have a question regarding searching/filtering data that appear in LIST2 screens. How would you go about creating an "on the fly" search to filter out data from a LIST1 screen to a LIST2 screen? The search you currently have works great, but what if you'd like to search within a range of integer field values or dates, rather than only a specific value.
Also, is there any way you can think of implementing a saved search function that would allow for a way to change the sql_where of a list screen based on values in another table?

Thanks!! I hope these questions make sense.

[Updated on: Mon, 25 September 2006 17:14]

Report message to a moderator

Re: Creating filters [message #295 is a reply to message #294] Mon, 25 September 2006 19:12 Go to previous message
AJM is currently offline  AJM
Messages: 2312
Registered: April 2006
Location: Surrey, UK
Senior Member
If you want to enter a range of values as search criteria then take a look at http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq52. For a working example take a look at http://www.tonymarston.net/php-mysql/menuguide/audit_dtl(sea rch).html

If you want to generate other search criteria then you can put whatever code you like into the _cm_pre_getData() method.

Previous Topic: Different users per database
Next Topic: Display field from related table
Goto Forum:

Current Time: Sun Jan 29 07:51:55 EST 2023

Total time taken to generate the page: 0.02645 seconds