Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramesh.g
Starting Member
11 Posts |
 Posted - 2010-10-05 : 07:21:43
|
MY stored procedure is below which work properly
ALTER PROCEDURE [dbo].[placement_pundit_advance_search] --'UploadDate between ''01/01/1900 00:00:00'' and ''5/10/2010 00:00:00'''
@SearchCriteria varchar(525)
AS
declare @sql varchar(max)
BEGIN
set @sql = 'SELECT jr.BackGround,Convert(datetime, jr.UploadDate,103) as UploadDate ,jr.Career,jr.Credentials,jr.CVDetails,jr.Email,jr.JSPerID,jr.JSProfID,jr.Phone,jr.Suitability,Convert(datetime,UploadDate,103) as UploadDate,bk.point2,bk.point1,bk.point3 FROM JobSeeker_Professional jr
Inner Join background bk On jr.BackGround=bk.backid where ' + @SearchCriteria
exec(@sql)
END
but when i execute it through browser it gives error below
An expression of non-boolean type specified in a context where a condition is expected, near 'UploadDate between ''01/01/1900 00:00:00'' and ''05/10/2010 00:00:00'' '.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An expression of non-boolean type specified in a context where a condition is expected, near 'UploadDate between ''01/01/1900 00:00:00'' and ''05/10/2010 00:00:00'' '.
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-10-05 : 08:06:28
|
Please do not cross post:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151082 |
 |
|
|
|
|
|
date between query