[ic] Searching a temporary mysql database table

[Michael McInally]

I have successfully generated a temporary mysql table in interchange,
however, I am unable to search it.

When I try to do the simplest query: SELECT * FROM `test`;

I receive the error:

your search file a valid database reference, was 'test'.

Here is my query string:

search.html?mv_searchtype=sql&mv_matchlimit=50&mv_sql_query=SELECT%20*%20FROM%20test

I have also tried:

search.html?mv_searchtype=db&mv_matchlimit=50&mv_sql_query=SELECT%20*%20FROM%20test


Does anybody have any suggestions?


-- 

Michael McInally
Software Developer
Picasso Fish
mcinallym at picassofish.com
(519)-426-8981