I decided to re-write the code

and I am doing a simple query now:-

CREATE PROCEDURE [dbo].[stpEventsSearchResultNew]

@searchstring varchar(100),

@dtFrom datetime,

@dtTo datetime,

@searchtype int

AS

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[debug_SP_table]') and OBJECTPROPERTY(id,...

oh

it created the table and returned two rows now

DateFrom 1/1/2000

DateTo 1/1/2099

it returns no results

I know what u are trying to tell me

but that @searchtype is set to 0 when the user does not click on the...

but in the stored proc I have the following:-

If @searchtype = 0

BEGIN

Select * from pod_Events WHERE e_title LIKE @searchstring or e_description LIKE @searchstring

END

else

BEGIN

I mean this stored proc was working...

ok this is the SQL statement

exec stpEventsSearchResult @searchstring = '%%', @dtFrom = 'Jan 1 2000 12:00AM', @dtTo = 'Jan 1 2099 12:00AM', @searchtype = -1, @region = 0,...

no table created

Sorry did not understand what catch SP call with Profiler, i am a newbie on sql server

Ok i executed that code.

I assume its supposed to be with my tables right?

Cause there is nothing there

Sorry but where do I put this code?

I tried to put it after my stored proc but gave me an error

'@dtFrom not declared

I am doing this:-

Dim myToDate As DateTime = Convert.ToDateTime(txtDateTo.Text)

and passing myToDate.

I noticed that It was still passing the argument as text so I changed it to Date ie:-

ByVal dtFrom...

I do not know what is exactly wrong.

The problem is that since i arranged the dates to datetime, its not working. So I am assuming that its the problem.

I...

thanks mate!

Thanks I solved it like this:-

conn =

New SqlConnection

conn.ConnectionString = ConnectionString

' return the players pk_player

cmd =

New SqlCommand

cmd.CommandType = CommandType.StoredProcedure

cmd.Connection...

Thanks Frank,

I will look into them after I finish my MCSD exams

Hi Remi, thanks, it worked like this:-

SET @strSQL = @strSQL + ' WHERE im_id LIKE ''%'+@inputSearchText+'%''

OR im_name LIKE ''%'+@inputSearchText+'%''

OR im_desc LIKE ''%'+@inputSearchText+'%'''

Thanks for your help