Complex PROC Question

Complex to me, anyways. I posted this quite a bit ago, although the question was different, and you guys pointed out what was wrong, which saved me lots of headaches and coffee, so hopefully you guys can point out what is wrong this time.

This PROC is used in a search engine type script I wrote that searches through a database of magazine articles. You can search with just a name or description, or a range of dates. You can also search for all articles posted after a date, or before a date. On the perl side, I pass it 4 parameters, $querry_string, the description or name, $datefrom and $dateto, which specifies a range of dates, and $slice, which is which slice of results to return, like 1-10.

The script *mostly* works, it works correctly with two dates or no dates are specified, however it will not work with only one date filled in. ( See querry2 in the proc ) Any ideas what is wrong? When I run the line in Querry Analyzer it works, but in the script, it finds 0 results no matter what.


CREATE PROC [dbo].[search_querry_results](
@datefrom datetime = NULL,
@datetodatetime = NULL,
@querry_string varchar(60),
@slice int
)
AS

DECLARE @querry nvarchar(2000)
DECLARE @querry2 nvarchar(2000)
DECLARE @querry3 nvarchar(2000)


-- Care of blind dude

SET @querry = 'SELECT TOP ' + CAST(@slice AS varchar(100))
+ ' * FROM FREETEXTTABLE( Exponent, *, ''' + @querry_string
+ ''' ) as ct JOIN Exponent AS e ON ct.[KEY] = e.[Key] WHERE date > '''
+ CAST( @datefrom AS varchar(30)) + ''' AND date < '''
+ CAST(@dateto AS varchar(30)) + ''' ORDER BY Rank DESC'

SET @querry2 = 'SELECT TOP ' + CAST(@slice AS varchar(100))
+ ' * FROM FREETEXTTABLE( Exponent, *, ''' + @querry_string
+ ''' ) as ct JOIN Exponent AS e ON ct.[KEY] = e.[Key] WHERE date < '''
+ CAST(@dateto AS varchar(30)) + ''' ORDER BY Rank DESC'


SET @querry3 = 'SELECT TOP ' + CAST(@slice AS varchar(100))
+ ' * FROM FREETEXTTABLE( Exponent, *, ''' + @querry_string
+ ''' ) as ct JOIN Exponent AS e ON ct.[KEY] = e.[Key] ORDER BY Rank DESC'


BEGIN
IF ( @datefrom IS NOT NULL ) AND ( @dateto IS NOT NULL )
EXEC sp_executesql @querry

ELSE


IF ( @dateto IS NOT NULL ) AND ( @datefrom IS NULL)
EXEC sp_executesql @querry2


ELSE


IF ( @datefrom IS NULL ) AND (@dateto IS NULL )
EXEC sp_executesql @querry3
END
GO


There is the code. Let me know if you can come up with something, im all out of ideas. Thanks

-ruhk