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

Re: override auto rdcaccount_id clause in a manually extended SQL [message #1992 is a reply to message #1990]

Sun, 19 April 2009 19:37

gpatti
Messages: 283
Registered: August 2008

Senior Member

The error message displayed is: Fatal Error: MySQL error: 1052 - Column 'rdcaccount_id' in where clause is ambiguous (# 1052).
It's because I am joining to a 2nd table, and both tables contain rdcaccount_id, but the generated SQL has " AND rdcaccount_id in ('1', 'n')" as part of the WHERE clause. It would need to have " AND table_name.rdcaccount_id IN.."

Let me know if you need further info on how I have actually set up the $where clause, although the rdcaccount_id reference is being automatically added to the where clause by the framework. I can't see how I can change it.

Graham

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 20:35:29 EDT 2024

Total time taken to generate the page: 0.01131 seconds