[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