Sql functions in cfquery

[ddfff]

I have a userdefined sql function called propercase.

when I execute a query from enterprise manager,

select propercase(firstname) from names

it works.

When I try and use it in cfquery tag, it does not recognize the function.

What can I do?

 

[TruthInSatire]

Your code looks fine to me. hint, hint.

If you don't ask the right questions, you don't get the right answers. A question asked in the right way often points to its own answer. Asking questions is the ABC of diagnosis. Only the inquiring mind solves problems.

-Quote by Edward Hodnett

 

[ecobb]

Write a stored procedure and just execute it from CF, or recreate the UDF in CF.



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[ecobb]

Write a Stored Procedure on the database and just execute it from CF, or recreate the UDF in CF.



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[ecobb]

Crap! I knew that was going to happen! (-:



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher