OR operator in searches

Thu, 23 Aug 2012 08:48:48 -0700

If I have a search such as domain.com/testviewer.php?product_keyword=Hammers
this produces all the records with the word "Hammers" in the product field.

If I use domain.com/testviewer.php?product_query=Hammers+Nails
this produces all the records that have the word "Hammers" AND the word "Nails" in the product field.

If I want to return all the records that have "Hammers" OR "Nails" in the product field is there a way to do that?

Thanks.

Re: [Jason] RSS & XML help

Wed, 08 Aug 2012 14:54:28 -0700

Hi Jason,
I started a 2nd level support request for this a couple days ago and I called yesterday to see if it had been received and Ross said it was in the queue, but could you check to see if anyone can lend a hand here? Or is there an explanation of outputting XML somewhere that you could reference? Thanks.

Re: [Jason] Preview problem

Wed, 08 Aug 2012 14:51:23 -0700

Thanks Jason, this fixed the issue. Much appreciated.

Preview problem

Wed, 08 Aug 2012 08:11:39 -0700

I have a multi record section and I have set viewer urls for the list and detail pages. When in CMS Builder and modifying a record, there is a preview button but when clicked I receive this message:
"Preview isn't supported when website membership uses separate login or alternate table name."
What am I doing wrong?

RSS & XML help

Mon, 06 Aug 2012 00:39:32 -0700

In trying to understand how CMS Builder can generate XML or produce RSS content, I keep seeing links in various posts to this RSS tutorial that used to be here:
http://www.interactivetools.com/docs/cmsbuilder/rss_feeds.html
Now that link is broken. I have 2.15 and there is an RSS feed area in the code generator, but that returns a "Forbidden" error indicating I don't have permission to access admin.php even though the generator works fine for producing the other types of code. Thanks for the help.

Re: [Jason] Search options

Wed, 01 Aug 2012 15:22:42 -0700

Thanks Jason, works nicely. Much appreciated. Any easy way to get rid of the resulting %2C for the commas in the URLs? Thanks again.

Search options

Wed, 01 Aug 2012 05:47:14 -0700

If you check out http://wmcyo.com/teams.php you will see that under the "Team Index & Search" header, I have two independent dropdown menus that simply direct people to search URL's. One is for GRADE LEVEL and one for TOWN.

Both dropdown menus function as expected based on how the page is coded, but what I would like is for the two dropdown menus to be related. Meaning, that if I select Grade 3-4 in the first dropdown and then Holyoke in the second dropdown, I should get the Grade 3-4 teams in Holyoke. Right now the dropdown menus are independent of each other. I know I could put these search options into one form and have a submit button, but part of this is that I want to generate URL's that can be bookmarked and the other part is that I don't want there to be a submit button.

The ideal thing would be that there would be multiple dropdowns, one for each category, that by default would be set to "ALL TEAMS"...then every time someone selected a value from the dropdown it would go to the appropriate URL based on the collective dropdown values.

Also, it would be great if the selected value held in the dropdown menu, instead of resetting to the default. That way people could see what they have selected. For instance in my example above, the person would see "3-4" in the left dropdown menu and "Holyoke" in the right dropdown menu and be at this URL:
http://wmcyo.com/teams.php?grade_level,content_keyword=3-4&title,content_keyword=Holyoke

Any advice would be much appreciated.

Automatically replacing text

Mon, 02 Jun 2008 09:34:59 -0700

I would like to set it up so that the Summary field in the Article Editor is scanned for certain words/phrases/code and then that text is replaced by other code. What I'm trying to accomplish is that everytime a reference to say "Book Club" appears it will be a link to the Book Club page. But I don't want users to have to type Book Club and then go through the process of linking it up. I'd like them to be able to type clublink or some other unique text and have that be replaced automatically with the code for the link. I accomplish this in other scripts with perl's substitution function such as:

$summary =~ s/clublink/Book Club<\/a>/gi;

I just don't know how to go about it in AM2 or where to put it. Thanks.