ProductCart Shopping Cart Software Forums : Registry search https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 04:51:48 +0000 Thu, 26 May 2011 10:35:08 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4486 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Registry search : Probably just an issue with...]]> https://forum.productcart.com/registry-search_topic4486_post17622.html#17622 Author: DevDuo
Subject: 4486
Posted: 26-May-2011 at 10:35am

Probably just an issue with your use of AND and OR.

You may need to group some conditions, example...

WHERE active=1 AND (name='frank' OR lastname='jones')

-Ted


Edited by DevDuo - 26-May-2011 at 10:47am]]> Thu, 26 May 2011 10:35:08 +0000 https://forum.productcart.com/registry-search_topic4486_post17622.html#17622 <![CDATA[Registry search : Thanks, Ted.We tried something...]]> https://forum.productcart.com/registry-search_topic4486_post17615.html#17615 Author: virtualimage
Subject: 4486
Posted: 25-May-2011 at 9:17am

Thanks, Ted.

We tried something along those lines  but we were receiving every entry from the registry. I'll give it another shot from scratch and post my results. Thanks, again.

-Quinn
]]> Wed, 25 May 2011 09:17:51 +0000 https://forum.productcart.com/registry-search_topic4486_post17615.html#17615 <![CDATA[Registry search : Hi there,Not sure what version...]]> https://forum.productcart.com/registry-search_topic4486_post17537.html#17537 Author: DevDuo
Subject: 4486
Posted: 17-May-2011 at 3:18pm

Hi there,

Not sure what version you are using, but you could try the following...

in ggg_srcGR.asp remove the last name and registry name rows.

Rename the label of the first field (cname) to something like Name: instead of First Name.

 You can either do this in the language file or inline.

In ggg_srcGRb.asp populate cname, clastname, and cregname all with the posted cname...

example...
cname=getUserInput(request("cname"),0)
clastname=getUserInput(request("cname"),0)
cregname=getUserInput(request("cname"),0)
emonth=getUserInput(request("emonth"),0)
eyear=getUserInput(request("eyear"),0)


Then change your AND's to OR's for the corresponding variables in the lines where the SQL query is being built, and this should produce an aggregate result set.

Always back up your files before modding. The above was not tested, but should work in theory... proceed as such...

Take care...
Ted





Edited by DevDuo - 17-May-2011 at 3:21pm]]> Tue, 17 May 2011 15:18:10 +0000 https://forum.productcart.com/registry-search_topic4486_post17537.html#17537 <![CDATA[Registry search : Hi all,Our shoppers are finding...]]> https://forum.productcart.com/registry-search_topic4486_post17529.html#17529 Author: virtualimage
Subject: 4486
Posted: 16-May-2011 at 3:55pm

Hi all,

Our shoppers are finding the gift registry search function challenging.
Is there a way to code the registry search so that there is only one box but the search query will search all of the fields: (cname, clastname, cregname)

Basically if any of the fields match - the appropriate registries are returned.

Thanks very much in advance for your help.

Cheers,

Quinn

]]> Mon, 16 May 2011 15:55:11 +0000 https://forum.productcart.com/registry-search_topic4486_post17529.html#17529