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 #1994 is a reply to message #1990]

Mon, 20 April 2009 08:51

gpatti
Messages: 283
Registered: August 2008

Senior Member

Because the error crashes the system the SQL is not written out to the log file. However, the following is written out to the screen:

Fatal Error: MySQL error: 1052 - Column 'rdcaccount_id' in where clause is ambiguous (# 1052).

SQL query: SELECT SQL_CALC_FOUND_ROWS * FROM exam, candidate WHERE exam.candidate_id = candidate.candidate_id AND candidate.active_ind = 'Y' AND candidate.exam_ind = 'Y' AND session_id = '12' AND branch_id='F' AND rdcaccount_id IN ('1', '7') ORDER BY exam.session_id, exam.syllabus_type_id, exam.branch_id

Error in line 466 of file 'C:\xampp\includes\dml.mysqli.class.inc'.

The transaction is an ADD4 pattern.

Please let me know if there is any further info I need to provide.

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 Nov 28 22:53:24 EST 2024

Total time taken to generate the page: 0.01095 seconds