| 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> |
|---|---|---|
| ||
| Previous by Date: | function within SELECT statement, romeogq |
|---|---|
| Next by Date: | Re: function within SELECT statement, Dan Bracuk |
| Previous by Thread: | function within SELECT statement, romeogq |
| Next by Thread: | Re: function within SELECT statement, Dan Bracuk |
| Indexes: | [Date] [Thread] [Top] [All Lists] |