why isn't my code working, page comes up blank after I add where

[lcostello]

 The report will bring up information until I add the where clause, then it comes up blank. Can anyone explain to me why this would be happening?

 

 

Code:

SELECT     C6NOTES."NOTE_TYPE" AS C6NOTES_NOTE_TYPE,     C6NOTES."NENTERDATE" AS C6NOTES_NENTERDATE,     C6NOTES."NOTE_DESC" AS C6NOTES_NOTE_DESC,     C6NOTES."STAFF_CD" AS C6NOTES_STAFF_CD,     C6CLIENT."CLIENT_ID" AS C6CLIENT_CLIENT_ID,     C6CLIENT."LFULLNAME" AS C6CLIENT_LFULLNAMEFROM     "DBA"."C6CLIENT" C6CLIENT INNER JOIN "DBA"."C6NOTES" C6NOTES ON C6CLIENT."C4_ID" = C6NOTES."C4_ID"WHEREC6NOTES_NOTE_TYPE>=$P{from_type}andC6NOTES_NOTE_TYPE<=$P{to_type}andC6NOTES_STAFF_CD>=$P{from_staff_cd}andC6NOTES_STAFF_CD<=$P{to_staff_cd} and isnull(C6NOTES_NENTERDATE,convert(date,'1/1/1800',101)) >= convert(date,isnull($P{from_date},'1/1/1800'),101)     and isnull(C6NOTES_NENTERDATE,convert(date,'1/1/1800',101)) <= convert(date,$P{to_date},101)ORDER BYC6NOTES_STAFF_CD ASC