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

Losing $where when fixed selection is not present [message #2242]

Mon, 10 August 2009 07:39

gpatti
Messages: 283
Registered: August 2008

Senior Member

I have a bug that seems to have been introduced in a recent upgrade (it doesn't occur in my production environment running 1.48 but does occur in my dev environment running 1.50). I'm struggling to track where it is going wrong in debug - hoping you will be able to help me track it down...

I have a table of items and descriptions. I have a second table containing rdcaccount_id and the item_id from the first table, and amounts. So a user can specify their own amounts for the items in the master table.

Updating of the amounts works perfectly, and the framework handles the rdcaccount_id automatically.

I also have two output2 tasks to print reports of the charges
1) Current amounts only (by setting curr/hist = 'C' in fixed selection)
2) All amounts (leave fixed selection blank)

For some reason I have to pass the rdcaccount_id to these tasks manually using _cm_getWhere() to ensure I only get the relevant rows (is this a bug also?) - the framework is not providing it automatically. In 1.48 this approach works OK.

However, in 1.50 only the 'current amounts' report is working correctly. The 'all amounts' report is displaying amounts for all rdcaccount_id (seems to be being filtered out somewhere, but I can't find where). The only difference between the tasks is the presence of the fixed selection criteria.

Can you help?

Thanks,

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: Sun Jul 06 17:29:51 EDT 2025

Total time taken to generate the page: 0.02046 seconds