Ask a Question related to Coldfusion Database Access, Design and Development.
-
Monizzle #1
UDF inside CFQuery?
Should UDFs work when called inside a SQL statement?
I tried to use a UDF in a SELECT AS statement, but no luck.
For example:
<cfquery name="name" datasource="dsn">
SELECT
stripNonAlpha(spacesToUnderscores(tbl_books.book_a uthor&'-'&tbl_books.book_title
))) AS media_image
FROM table;
</cfquery>
Monizzle Guest
-
cfquery bug...still?
Hi, I have ColdFusion MX7,0,0,91690. I am trying to utilize the attached code. I am passing the query (it's easier for my implementation) in a... -
Calling Multiple Stored Procedures inside a cfquery
All, I have ColdFusion page that contains a Company dropdown, a To Date and From Date and submit button The user can select an ?individual... -
cfquery
I am trying to use debug in a query and it is a no go(should show at bottom of page). the query is working because I am getting recordcounts. Then... -
cfinclude, cfquery inside loops
was going through and debugging code for a web app. Came across someone's code that cfinclude a query inside a loop! If going by interpreted logic,... -
Dynamic temp. datagrid col.gen. -Session access inside a class inside a UserCtrl
Hello Dear Professionals: Based on this document:... -
-
Dan Bracuk #3 Re: UDF inside CFQuery?
A better idea is to use the udf to create a new variable with your udf, and use that variable in your query.
Dan Bracuk Guest
-
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
