No I haven't found any use for it outside of cfquery -- it was after all
specifically designed to short-circuit the default cfquery behavior... This
particular function is intended only to be used in cfqueries...
#request.tapi.db.concatenate("blah","blah2","yadda")#
This is an attempt at building some (not comprehensive) db-platform
independant code for Tapestry to allow multiple db's on a single codebase.
Most of it comes about as a result of differences between MS SQL Server and
Oracle -- in particular this function for concatenation because SQL Server
uses + and Oracle uses || for concatenation (which I find just confusing
because || in C/C++/Java/JavaScript means "or", although I suspect some
other language(s) use it for concatenation, I'm just not familiar with
them).
Interresting results from your previous message tho. I guess I have to set a
function local variable prior to using preservesinglequotes() ... It's
really odd I have to wonder why the function doesn't just see the string
output from the arraytolist() function.
> Do you think preservesinglequotes() is actually meaningful
> outside a
> cfquery? If you inspect the result of the function I think
> you'll see the
> same thing with or without....
> ----- Original Message -----
> From: "S. Isaac Dealey" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, March 24, 2003 7:21 AM
> Subject: unknown parser error from UDF
>> Using
>>
>> CF 5
>> Win2K Server
>> IIS 5
>>
>> I have the following in a template
>>
>> <cfscript>
>> function dbconcatenate() {
>> return preservesinglequotes(ArrayToList(arguments," +
>> "));
>> }
>> request.tapi.tStor("dbconcatenate","db.concatenate");
>> </cfscript>
>>
>> The cfscript block contains several other functions as
>> well, however, the
>> odd thing is that no matter what I comment out, unless I
>> comment out the
>> _entire_ template, CF Studio (4.5) reports the unknown
>> parser error. CF
>> Server on the other hand has no problem with the template
>> as long as I
>> comment out the preservesinglequotes() function -- i.e.
>> no problem with
>> this:
>>
>> return /*preservesinglequotes(*/ArrayToList(arguments," +
>> ")/*)*/;
>>
>> Anybody have any ideas?
>>
>> s. isaac dealey 954-776-0046
>>
>> new epoch http://www.turnkey.to
>>
>> lead architect, tapestry cms http://products.turnkey.to
>>
>> tapestry api is opensource http://www.turnkey.to/tapi
>>
>> certified advanced coldfusion 5 developer
>> http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
>>
>>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Signup for the Fusion Authority news alert and keep up
> with the latest news in ColdFusion and related topics.
> http://www.fusionauthority.com/signup.cfm
> Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
> ubscribe.cfm?user=633.558.4
s. isaac dealey 954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
