SELECT * FROM ACTIVITY WHERE ACT_ID IN(NULL)
does work in Oraclesorry for my bad info.
No idea if it will work in other DBs
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EM
Ah, honestly do not know if it returns any or not in Oracle since I never or
rarely have used it. I just know it works because I tried it earlier.
On 3/8/06, Jim Wright <[EMAIL PROTECTED]> wrote:
>
> I think he is saying that it won't work the same as IS NULL. It
> doesn't error out, but it also
I think he is saying that it won't work the same as IS NULL. It
doesn't error out, but it also doesn't return any NULL records. At
least that is the way it is in SQL Server...is Oracle the same?
On 3/8/06, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> Works in Oracle, at least it does in 9i, do not k
Works in Oracle, at least it does in 9i, do not know for certain on the
other versions.
On 3/8/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> NULL should NOT work in an IN clause.
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone:
I don't knowyou posted it ;-)
I only answered the IN portion regarding cfqueryparam.
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems
So you're saying that it's an inappropriate use of the null parameter.
Wasn't that part of the original question?
- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Wednesday, March 08, 2006 4:26 PM
Subject: R
NULL should NOT work in an IN clause.
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
~~
Going off the recordcount would definately be less typing and easier on the
eyes. :)
Yes when it comes out to null="Yes" then it is the same as if you typed in
WHERE ID IN (NULL)
On 3/8/06, Jim McAtee <[EMAIL PROTECTED]> wrote:
>
> I suppose this would work just as well, since recordid is a prim
Talk"
Sent: Wednesday, March 08, 2006 3:29 PM
Subject: Re: SQL IN and cfqueryparam lists
>I believe that null will work but I'd use the listlen function. Mine
>would
> look something like:
>
> Not(YesNoFormat(ListLen(ValueList(AnotherQuery.RecordID
>
>
I believe that null will work but I'd use the listlen function. Mine would
look something like:
Not(YesNoFormat(ListLen(ValueList(AnotherQuery.RecordID
On 3/8/06, Jim McAtee <[EMAIL PROTECTED]> wrote:
>
> Is it necessary to designate list="yes" for a cfsqlqueryparam value if the
> value is
> Is it necessary to designate list="yes" for a cfsqlqueryparam value if the
yes...absolutely required
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.elec
Is it necessary to designate list="yes" for a cfsqlqueryparam value if the
value is already a comma delimitted list? Or is that exactly what the
attibute is to be used for?
Is the following a valid use of the 'null' attribute?
WHERE recordid IN
()
12 matches
Mail list logo
