Hi, does jdbc sql syntax differ so much from standard sql syntax that this
works? I haven't found any part of the jdbc spec that indicates this,
could you provide a reference?
In normal sql, mycolumn = null has truth value unknown, not true if the
mycolumn entry is null. (null is not a value, null = null is unknown, not
true or false: you have to supply the missing values for both nulls to
determine truth or falsity)
I haven't tried this, however:
if you always want just null values,
<query>mycolumn is null</query>
if you want a parameter:
<query>(mycolumn = {0}) or ((mycolumn is null) and ({0} is null))</query>
david jencks
On 2001.07.09 12:28:55 -0400 Fred Loney wrote:
> <query>mycolumn = {0}</query>
>
> and pass null argument to finder method.
>
> Keerthi P wrote:
>
> > Hi all,
> > how to declare a finder in jaws.xml if i need to select rows if a
> field's value is null.
> > for eg: my oracle query is "select * from table where mycolumn is
> null". Could any one of you tell
> > me the equivalent <finder> construct that i can use in jaws
> >
>
> --
> Fred Loney
> Spirited Software, Inc.
> [EMAIL PROTECTED]
>
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
