macromedia.coldfusion.database_access
[Top] [All Lists]

Re: function within SELECT statement

Subject: Re: function within SELECT statement
From: "Dan Bracuk" <webforumsuser@xxxxxxxxxxxxxx>
Date: Thu, 24 Apr 2008 02:24:52 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

The subquery in the select clause might be returning more than row.  That's a 
problem.

 I'm not sure you can run cf functions inside queries like this.  As a 
workaround, run it with just the math part first.  Then loop through the 
results and apply the function to that column.


<Prev in Thread] Current Thread [Next in Thread>