Hi,

I want to search for all entries where a specific column does not contain a given substring. Does anyone know if that is possible?

Thanks, Jasper

BTW I posted this question here becuase it is related to GT::SQL::Base::build_query_cond(), but not to a specific product.

---

http://www.bookings.org

Your best bet is to post this in the right forum for the product you are trying to do this with, or possibly the SQL and DAtabase forum

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Newer versions of GT::SQL support passing in:

column-ne=foo

(ne for not equal).

Chers,

Alex
--
Gossamer Threads Inc.

Doesn't column-ne=foo get translated to the SQL statement column <> 'X' instead of to column NOT LIKE 'X' (the first query returns true on 'XY' whereas the second query would return false)?

Jasper

---

http://www.bookings.org

Does anyone know if this is at all possible? If not, I will have to modify GT/SQL/Base.pm to add this feature. How should I do that? Should I just change the code and remember it so I can change it again in future versions, or is there a way to post my suggested change to GT, so it might be added to future versions of GT software?

Thanks, Jasper

---

http://www.bookings.org