[ic] Searching a table other than products
Mike Heins
interchange-users@icdevgroup.org
Thu May 8 09:08:00 2003
Quoting Interchange User (interchange@framework.cx):
> Hi folks,
>
> Using IC 4.9.7-200305010658 on Mac OS 10.2, MySQL 4.1.
>
> I've gone over the searching documents, but I still can't get what I
> think is a simple search to work. I am trying to search a table other
> than products, and hitting a snag. I'm using MySQL to store the data
> in a table called nc_redArticle.
>
> The documentation at
> http://www.icdevgroup.org/i/dev/
> docfly.html?id=jQv9hDY2&mv_arg=icdatabase06%2e11 says the following:
>
> ------------------------------------------------------------------------
> --------
> Be Careful if using SQL! If the database is change and not exporte
> with [tag export products][/tag], searches will not be successful.
> ------------------------------------------------------------------------
> --------
>
>
> So I tried to insert the export tag (which seems to work, as I get
> back a "1" on the page, and a file called "nc_redArticle.txt" appears
> in the products directory) and the following search field. However, no
> matter what I search on, using all sorts of combinations, case
> sensitive, etc., I always get no results found.
>
>
> ------------------------------------------------------------------------
> --------
> [tag export nc_redArticle][/tag]
> <form action="[area search]" method=post>
> Search:<br>
> [set testname]su=yes/fi=nc_redArticle/sf=title[/set]
> <input type=hidden name=mv_profile value=testname>
> <input type=text name=mv_searchspec size=15 value="">
> </form>
Don't use slashes.
[set testname]
su=yes
fi=nc_redArticle
sf=title
[/set]
--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.513.523.7621 <mike@perusion.com>
Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer