has anyone tried to deploy the newsapp on sqlserver 2000?
 
i try and have found a problem that could have implications for other situations aswell
 
the newsapp has a hierachy of news, and the top news has a parent with the value null ie. no parent
 
this is fine except the findByParent finder generates sql like this:
select....where parent = $1
 
and in sqlserver this return nothing when called with null as an argument. in this case you have to write  '...where parent IS null' to get a resultset.
 
how an this be resolved? if indeed it can?
 
sincerely
morten wilken

Reply via email to