Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Searching for empty fields

Quote Reply
Searching for empty fields
Using the admin search area, is it possible to search for empty fields? For example, say that Description fields have content in them, some don't. I want to find all the Descriptions that don't have content so that I can add it. This is just an example. It's the same question for other fields too. At present, leaving the Description search field empty and doing an "Exact" match search returns all entries, whether full or empty.

Thanks for any help :)

Thanks,
--Jo
Quote Reply
Re: [iplay] Searching for empty fields In reply to
Hi,

I don't think thats possible.

It can easily be done in MySQL, to find the links with empty values though.

SQL Monitor

SELECT ID FROM glinks_Links WHERE Description = ""

Hope that helps

Cheers

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!
Quote Reply
Re: [Andy] Searching for empty fields In reply to
Many thanks Andy

Slightly different Q: with normal links it's possible to search for duplicate links (urls). What if this is not a links directory but a glossary of terms. There are no external http:// links to search for. Is it possible to search for duplicate entries of the same term (ie under Title)?

Thanks...

Thanks,
--Jo

Last edited by:

iplay: Aug 3, 2008, 7:16 PM
Quote Reply
Re: [iplay] Searching for empty fields In reply to
Hi,

That could be done with something similar to:

http://www.gossamer-threads.com/...?post=297717#p297717

Where it looks to see if the count is > 1, and if so - return it to you in the template.

Afraid I don't have time to look into that for you though today, sorry.

Cheers

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!