Full Text Index Searching

June 18, 2012 6:23PM

Hi

I want to query a SQL Server database using a full text search and a parameter from Omniscope. The query I want to run is:

select * from tblMY_TABLE where contains((Col1, Col2, Col3), {{MyParam}})

which may equate

select * from tblOrders where contains((SupplierName, InvoiceDescription, PO_Description), 'generator')

I can type my SQL into the database table block on the datamanager pallette but when I try and use a paramater it doesn't work. Any ideas?

Thanks

Andy

chris · June 19, 2012 4:04AM

Hi,

Could you try putting single quotes around your parameter. Does that work? If you are still having problems could you post the error message your receive.

June 21, 2012 4:50PM

Hi Chris

Have put single quotes around the parameter and get this error:

Error with block "SQL Param Search"
Database error
An error occurred connecting to or querying the database.
Invalid parameter index 1.

If I put a quote in the parameter and not in the SQL then I get:

Error with block "SQL Param Search"
Database error
An error occurred connecting to or querying the database.
Invalid state, the Connection object is closed.

Thanks

Andy

chris · June 22, 2012 6:27AM

Hi Andrew,

We are investigating this issue and will get back to you shortly.

Chris

Welcome!

Categories

Ideas Parade