Radicore Forum: Bug Reports » ERROR CREATING WHERE CLAUSE WHEN USING SEARCH

Home » RADICORE development » Bug Reports » ERROR CREATING WHERE CLAUSE WHEN USING SEARCH (ERROR CREATING WHERE CLAUSE WHEN USING SEARCH)

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

Re: ERROR CREATING WHERE CLAUSE WHEN USING SEARCH [message #7231 is a reply to message #7230]

Tue, 16 October 2018 05:19

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Within the condition "if ($GLOBALS['mode'] == 'list' || $GLOBALS['mode'] == 'read' || $GLOBALS['mode'] == 'search' ) {" you are manually inserting the column 'usuarioturnocaja' into the field specifications for the 'detalleventa' table, and the framework qualifies the column with that table name because it thinks that the column exists within that table. Try adding the property 'nondb' = 'y' and the framework will ignore that entry and not qualify the column name with the wrong table name.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

[Updated on: Wed, 17 October 2018 04:31]

Report message to a moderator

[Message index]

		ERROR CREATING WHERE CLAUSE WHEN USING SEARCH By: edortizq on Tue, 16 October 2018 02:30
		Re: ERROR CREATING WHERE CLAUSE WHEN USING SEARCH By: AJM on Tue, 16 October 2018 05:19
		Re: ERROR CREATING WHERE CLAUSE WHEN USING SEARCH By: edortizq on Tue, 16 October 2018 09:22

Previous Topic:	Regex and Sql Queries containing +
Next Topic:	LIST3 - no paging area for "middle" as of 2.10

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jul 27 00:02:17 EDT 2025

Total time taken to generate the page: 0.01301 seconds