[ic] Searching a table other than products
Interchange User
interchange-users@icdevgroup.org
Thu May 8 08:44:01 2003
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>
------------------------------------------------------------------------
--------