Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
test with empty query
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  7 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Hugo Ahlenius  
View profile  
 More options Apr 24 2012, 6:18 am
From: "Hugo Ahlenius" <fraxi...@oxel.net>
Date: Tue, 24 Apr 2012 12:18:51 +0200
Local: Tues, Apr 24 2012 6:18 am
Subject: test with empty query
Hi,

I was working with an application now, and I noticed that it is doing tests:

<cfif query.column>
        --- do something
</cfif>

If the query is empty (no rows), then this fails on OpenBD - I assume it
returns false on ACF. Is this known/documented? Is this a compability issue
to fix?

Thanks,
Hugo

--
Hugo Ahlenius
fraxi...@oxel.net


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jari Ketola  
View profile  
 More options Apr 24 2012, 7:50 am
From: Jari Ketola <ket...@gmail.com>
Date: Tue, 24 Apr 2012 04:50:07 -0700 (PDT)
Local: Tues, Apr 24 2012 7:50 am
Subject: Re: test with empty query

ColdFusion sure can lead to strange coding conventions. Sometimes it seems
you can throw just about anything at <cfif> and it will sort itself out. =)

I'm not a CF programmer myself, so I resort to "more conventional" methods.
isDefined() is your friend here.

<cfif isDefined("query.column")>
 // do stuff
</cfif>

Can you guess what

<cfset myVar="true"/>
<cfoutput>
 #myVar# is #isBoolean(myVar)#
</cfoutput>

outputs? My guess would have been "true is FALSE", but it seems things
aren't always so black and white. Or zero and one.

 Jari

P.S. The correct answer is "true is YES". Now that's what I call an
enthusiastic boolean!


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Nitai @ Razuna  
View profile  
 More options Apr 24 2012, 8:01 am
From: "Nitai @ Razuna" <ni...@razuna.com>
Date: Tue, 24 Apr 2012 14:01:41 +0200
Local: Tues, Apr 24 2012 8:01 am
Subject: Re: [OpenBD] Re: test with empty query
and to add to this, simply do a your query.recordcount to check for
any records in the query at all…

Kind Regards,
Nitai

--
See for yourself how easy it is to manage files today. Join the revolution!

Razuna - Hosted Digital Asset Management Solution
http://www.razuna.com/

Razuna - Open Source Digital Asset Management
http://www.razuna.org/

Twitter - http://twitter.com/razunahq
Facebook - http://www.facebook.com/razunahq
Support Platform - http://getsatisfaction.com/razuna


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Hugo Ahlenius  
View profile  
 More options Apr 24 2012, 8:48 am
From: "Hugo Ahlenius" <fraxi...@oxel.net>
Date: Tue, 24 Apr 2012 14:48:54 +0200
Local: Tues, Apr 24 2012 8:48 am
Subject: RE: test with empty query
Yes,

I agree, and I have already modified the code, but is this a compability issue? The application that I loaded off riaforge (tested on ACF) didn't work out of the box!

:)

--
Hugo Ahlenius
fraxi...@oxel.net


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Matthew Woodward  
View profile  
 More options Apr 24 2012, 8:52 am
From: Matthew Woodward <m...@mattwoodward.com>
Date: Tue, 24 Apr 2012 05:52:25 -0700
Local: Tues, Apr 24 2012 8:52 am
Subject: Re: [OpenBD] RE: test with empty query

On Tue, Apr 24, 2012 at 5:48 AM, Hugo Ahlenius <fraxi...@oxel.net> wrote:
> I agree, and I have already modified the code, but is this a compability
> issue?

Please file a ticket for it so it's at least on the radar:
http://code.google.com/p/openbluedragon/issues/list

Thanks.

--
Matthew Woodward
m...@mattwoodward.com
http://blog.mattwoodward.com
identi.ca / Twitter: @mpwoodward

Please do not send me proprietary file formats such as Word, PowerPoint,
etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Alan Williamson  
View profile  
 More options Apr 24 2012, 4:42 pm
From: Alan Williamson <a...@aw20.co.uk>
Date: Tue, 24 Apr 2012 16:42:41 -0400
Local: Tues, Apr 24 2012 4:42 pm
Subject: Re: [OpenBD] RE: test with empty query

mmm i would put this down to one of those infamous ACF quirks that i
really don't want to be adding in and bloating up the engine.

On 24/04/2012 08:52, Matthew Woodward wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Hugo Ahlenius  
View profile  
 More options Apr 25 2012, 3:37 am
From: "Hugo Ahlenius" <fraxi...@oxel.net>
Date: Wed, 25 Apr 2012 09:37:50 +0200
Local: Wed, Apr 25 2012 3:37 am
Subject: RE: test with empty query
| mmm i would put this down to one of those infamous ACF quirks that i
| really don't want to be adding in and bloating up the engine.

I had a feeling that was the case, now it is documented anyways - I filed a
bug report for it:
http://http://code.google.com/p/openbluedragon/issues/detail?id=464
...and I made a note in the wiki:
http://wiki.openbluedragon.org/wiki/index.php/CFQUERY#Unsupported_Fea...

(and I am about to file a bug report for the application, ProjectTracker)

Cheers,
Hugo

| On 24/04/2012 08:52, Matthew Woodward wrote:
|
|       On Tue, Apr 24, 2012 at 5:48 AM, Hugo Ahlenius

| <fraxi...@oxel.net> wrote:

|
|
|               I agree, and I have already modified the code, but is
| this a compability issue?
|
|
|       Please file a ticket for it so it's at least on the radar:
|       http://code.google.com/p/openbluedragon/issues/list
|
|
|
| --
| online documentation: http://openbd.org/manual/
| google+ hints/tips: https://plus.google.com/115990347459711259462
| http://groups.google.com/group/openbd?hl=en

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »