Radicore Forum: Bug Reports » Losing $where when fixed selection is not present

Home » RADICORE development » Bug Reports » Losing $where when fixed selection is not present

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

Re: Losing $where when fixed selection is not present [message #2272 is a reply to message #2242]

Mon, 17 August 2009 11:37

gpatti
Messages: 287
Registered: August 2008

Senior Member

I'm really sorry for the confusion. I wasn't being careful when I said earlier it was being called from a LIST2 transaction.

And you are quite right about the foreign key. I wrote this code months ago and when I check I have taken rdcaccount_id from $_SESSION and added rdcaccount_id to _cm_filterWhere().

Your alterations to bracket the OR statements have indeed solved the problem - so thank you for that.

I'd still like to ask about trapping and modifying selections made by a user: in another situation I have a navigation button on a LIST2 transaction that calls another LIST2 transaction with exactly the same parent and child tables (this is simply so that I can split different functionality over different screens). I've noticed that if a user makes a selection before pressing the navigation button I get an error because the primary key is missing in the receiving task (presumably because the $selection takes precedence over the $where). However, in this case I don't want the $selection to be used anyway - I want it to be ignored. If there was a way of doing this I would be able to prevent the missing key error (which confuses the user as the solution is to remove the selections they made). Hope this is explained clearly enough - let me know if not.

Graham

Report message to a moderator

[Message index]

		Losing $where when fixed selection is not present By: gpatti on Mon, 10 August 2009 07:39
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 10 August 2009 10:49
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 10 August 2009 11:33
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 10 August 2009 11:29
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 10 August 2009 11:57
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 06:57
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 08:49
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 09:20
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 09:39
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 09:36
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 09:55
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 11:09
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 11:37
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 13:15
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 13:59
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 15:15
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 17:26
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 18:38
		Re: Losing $where when fixed selection is not present By: gpatti on Tue, 18 August 2009 04:58
		Re: Losing $where when fixed selection is not present By: AJM on Tue, 18 August 2009 05:17
		Re: Losing $where when fixed selection is not present By: gpatti on Tue, 18 August 2009 05:32
		Re: Losing $where when fixed selection is not present By: AJM on Tue, 18 August 2009 06:24
		Re: Losing $where when fixed selection is not present By: gpatti on Thu, 27 August 2009 11:24
		Re: Losing $where when fixed selection is not present By: AJM on Thu, 27 August 2009 11:55
		Re: Losing $where when fixed selection is not present By: gpatti on Thu, 27 August 2009 12:23

Previous Topic:	isnull clause being filtered out of $where with scriptNext()
Next Topic:	Recover Password is encrypted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon May 11 14:12:13 EDT 2026

Total time taken to generate the page: 0.01752 seconds