[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>
------------------------------------------------------------------------ 
--------