Radicore Forum: How To » override auto rdcaccount_id clause in a manually extended SQL

Home » RADICORE » How To » override auto rdcaccount_id clause in a manually extended SQL

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

override auto rdcaccount_id clause in a manually extended SQL [message #1990]

Sun, 19 April 2009 11:07

gpatti
Messages: 283
Registered: August 2008

Senior Member

Tony,

In a _cm_getInitialDataMultiplefunction within a table class I have manually extended $this->sql_from and $this->sql_where to include data from a second table to achieve some desired functionality. Both the tables include the rdcaccount_id column.

I'm using getData_raw to retrieve the data.

Unfortunately this is now generating an ambiguous reference to rdcaccount_id (the table name is not explicitly stated in the generated SQL).

Can you give me a pointer to resolve this please?

Thanks,

Graham

[Updated on: Sun, 19 April 2009 11:15]

Report message to a moderator

[Message index]

		override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Sun, 19 April 2009 11:07
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Sun, 19 April 2009 18:36
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Sun, 19 April 2009 19:37
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Mon, 20 April 2009 05:25
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 08:51
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Mon, 20 April 2009 11:03
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 11:59
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 12:46
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 08:57
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 09:15
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 09:34
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 09:45
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 10:11
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 11:07
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Thu, 23 April 2009 04:47
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Thu, 23 April 2009 05:16

Previous Topic:	Use Messages[] in a LIST1 transaction
Next Topic:	Dynamic Task Selection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Sep 12 18:21:11 EDT 2024

Total time taken to generate the page: 0.01298 seconds