[SOLVED] WHERE NOT EXISTS(subquery)

jamesarthur · Postby **jamesarthur** » Mon Feb 10, 2014 2:47 pm

Is there a way in groupoffice to do a WHERE NOT EXISTS subquerry?

Postby **mschering** » Mon Feb 10, 2014 3:56 pm

Yes, but you have to use addRawCondition();

jamesarthur · Postby **jamesarthur** » Wed Feb 12, 2014 10:38 am

Hi

Yes this worked. I did

addRawCondition('NOT', '('.$subquery.')', 'EXISTS')

Postby **mschering** » Wed Feb 12, 2014 12:26 pm

Yes, make sure $subquery is not vulnarable to injections because when using addRawCondition there are no security checks.

jamesarthur · Postby **jamesarthur** » Thu Feb 13, 2014 1:31 pm

Good point! - My subquery doesn't have any data fields - it's purely of the form

SELECT * FROM `table2`
WHERE `table1`.`id` = `table2`.`id`

but if there was data needing escaping, I would need to use addBindParam..

Postby **mschering** » Thu Feb 13, 2014 3:14 pm

Spot on, addBindParam is the safest.