Radicore Forum: How To » _cm_popupcall giving unexplained result

Home » RADICORE » How To » _cm_popupcall giving unexplained result

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

_cm_popupcall giving unexplained result [message #1623]

Wed, 10 September 2008 11:26

gpatti
Messages: 283
Registered: August 2008

Senior Member

I'm trying to filter the results of a popup by modifying the where string in _cm_popupcall to join to additional tables using a foriegn key selected fom a dropdown.

This was working fine until I changed my datamodel. I've added a third table through an additional join in the where. The SQL is correct, but the popup is now retrieving all rows from the target table.

The relationships are all defined correctly - so is there something else that might override the $where in _cm_popupcall?

Report message to a moderator

Re: _cm_popupcall giving unexplained result [message #1630 is a reply to message #1623]

Wed, 10 September 2008 15:51

AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK

Senior Member

You cannot use _cm_popupCall() to specify any joins to any database tables. All you can do is modify the $where string which is passed to the popup. Any joins must therefore be done within the popup and not the task which calls the popup.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: _cm_popupcall giving unexplained result [message #1632 is a reply to message #1623]

Thu, 11 September 2008 04:38

gpatti
Messages: 283
Registered: August 2008

Senior Member

Thanks - that's fixed it once again!

Report message to a moderator

Previous Topic:	Submenu question
Next Topic:	File upload as control in table column?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 25 00:25:16 EDT 2024

Total time taken to generate the page: 0.00984 seconds