[ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Stored Procedures

[Allan Cliff]

I know have stripped this to find the problem.
I now get [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name '%a%'. 
error.

Any more ideas?

Thanks
Allan

-----------------------------------------------

CREATE PROC GetMessages2

@searchtext varchar (100)

AS 

DECLARE @query varchar(1000)
 
SET @query = 'SELECT * FROM Messages'

SET @query = @query + ' WHERE 1=1'

IF @searchtext <> ''
 SET @query = @query +  ' AND Message LIKE "'  + '%' + @searchtext + '%"'

EXEC(@query)
GO