Re: Should jsstringformat do more?

[Jerry Johnson]

If anyone really feels strongly about this, they should create a
function that does what they want, name it something more useful and
specific, and place it on cflib.org

Then put a note on the livedocs pointing to the new function.

Finally, watch and see how many people then go download the function
that "fixes" JSStringFormat.

If enough people do so, I can almost guarantee that the Adobe dev
staff will take notice, and look at including that or a similar
function in the next version of cf.

This would be both useful, and possibly educational.

On Jan 2, 2008 1:45 AM, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>  >>Then the context of jsstringformat should be widened.
>
> Ok, then call it JSstringInHTMLformat. ;-)

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295695
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Should jsstringformat do more?

[Claude Schneegans]

 >>Then the context of jsstringformat should be widened.

Ok, then call it JSstringInHTMLformat. ;-)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295694
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Should jsstringformat do more?

[s. isaac dealey]

>  >>Therefore, jsstringformat should format strings the way
> SerializeJSON does.
> 
> I don't agree:
> The purpose of jsstringformat is to make a string safe as a Javascript 
> string in a Javascript context, no more.
> JSON is a text format that is completely language independent, not only 
> Javascript, but also HTML,
> big difference. The context is much wider, so the escaping must be more 
> agreessive.

Then the context of jsstringformat should be widened. 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295693
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Should jsstringformat do more?

[Claude Schneegans]

 >>I don't think it's a good idea for one of these functions to
"guess" that I want to remove something that isn't a metacharacter when in
fact I may not.

Exact.
Another good example is the MSHTML editor which absolutizes relative 
link addresses
accordingly to the directory in which the editor is run, which can be 
quite different from the real context.
If I want relative address, I don't need any one to make it absolute, 
especially if it does it wrong.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295692
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Should jsstringformat do more?

[Claude Schneegans]

 >>Therefore, jsstringformat should format strings the way
SerializeJSON does.

I don't agree:
The purpose of jsstringformat is to make a string safe as a Javascript 
string in a Javascript context, no more.
JSON is a text format that is completely language independent, not only 
Javascript, but also HTML,
big difference. The context is much wider, so the escaping must be more 
agreessive.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295691
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Could not generate stub objects for web service invocation

[sam menon]

Thanks for all the help, I fixed the problem
Thank you so much for the help 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295690
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Could not generate stub objects for web service invocation

[Dave Watts]

> I tried with the following code , but its giving Element 
> XMLROOT.ITEM is undefined in XMLDOC. 
> is ITEM a property/method of XMLDocument?

I have no idea what's in your XML document, but you should be able to see
what's in there, and how to reference the contents as nested structures and
arrays, by using CFDUMP to show the contents of your XML document object.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295689
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfmail question

[Seamus Campbell]

brilliant - many thanks

Seamus

>> So how can I get multiple records in the one cfmail.
>
>Use CFLOOP within your CFMAIL tag.
>
>Dave Watts, CTO, Fig Leaf Software 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295688
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Could not generate stub objects for web service invocation

[sam menon]

I tried with the following code , but its giving Element XMLROOT.ITEM is 
undefined in XMLDOC. 
is ITEM a property/method of XMLDocument?

https://b2b.ratestogo.com/WS/Services/Content/Content.asmx/HotelList?AffiliateID=543444&Password=dsfsdf&CityName=Adelaide";
 method="GET"  throwOnError="Yes"/>




#xmlDoc#








#item.HotelID.xmltext#
Hotel  #item.HotelName.xmltext#




 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295687
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Could not generate stub objects for web service invocation

[Dave Watts]

>  url="https://b2b.ratestogo.com/WS/Services/Content/Content.asm
> x/HotelList?AffiliateID=57&Password=gdfgdf&CityName=Adelai
> de" method="GET" name="onerow"  throwOnError="Yes"/>

The NAME attribute of CFHTTP isn't used unless your CFHTTP returns text that
can be directly converted to a query object. Take it out.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295686
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Could not generate stub objects for web service invocation

[sam menon]

thnaks for the suggestion
But I am not able to get the data, this is my code

https://b2b.ratestogo.com/WS/Services/Content/Content.asmx/HotelList?AffiliateID=57&Password=gdfgdf&CityName=Adelaide";
 method="GET" name="onerow"  throwOnError="Yes"/>

#XmlParse(onerow)#


#xmlDoc#

Output for the above url(Web service) will be like this

  
- http://www.w3.org/2001/XMLSchema"; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; 
xmlns="http://b2b.RatesToGo.com/WS/Services/";>
- 
  525 
  Freedom Adelaide Meridien 
  4 
  North Adelaide 
  Adelaide 
  Hotel 
  20 
  AUD 
  89. 
  


For my code I am getting the following error:

The column name "" is invalid.  
Column names must be valid variable names. They must start with a letter and 
can only include letters, numbers, and underscores.  



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295685
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Could not generate stub objects for web service invocation

[Dave Watts]

> they are specifying SOAP , http get and post methods to get 
> the data, how can I use that in coldfusion?

Just use CFHTTP, since they support HTTP GET and POST.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295684
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Could not generate stub objects for web service invocation

[sam menon]

if you try to acces the following url

https://b2b.ratestogo.com/WS/Services/Content/Content.asmx?op=HotelList

they are specifying SOAP , http get and post methods to get the data, how can I 
use that in coldfusion?
It didn't not display the data for you as the affiliate id and password are not 
a valid data 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295683
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Could not generate stub objects for web service invocation

[Dave Watts]

> I need to get the contents (xml) data from the above url and 
> have to insert them into a database.
> I am trying to create an object which stores the xml values, 
> but I am not sure how to use in the web service as I m new to 
> web services.

If you just go to that URL and get XML containing the data you want, that
URL isn't a SOAP web service. You could then just use CFHTTP to fetch the
XML.

When I go to that URL myself, I don't get XML, though.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295682
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Could not generate stub objects for web service invocation

[sam menon]

I need to get the contents (xml) data from the above url and have to insert 
them into a database.
I am trying to create an object which stores the xml values, but I am not sure 
how to use in the web service as I m new to web services.
ANy help would be much appreciated 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295681
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Could not generate stub objects for web service invocation

[Dave Watts]

> How can i change the following code to get the values
> 
> 
>   o = 
> createObject("webservice","https://b2b.ratestogo.com/WS/Servic
> es/Content/Content.asmx/HotelList?AffiliateID=1&Password=t
> est123&CityName=Chicago");
> 
> 
> It will retrieve the data in xml format, if i test the url it 
> works fine but not if I try to invoke it as a web service, Do 
> I need to make any changes to the code??

I'm not sure exactly what you're asking. You're creating an object, but
you're not invoking a method. Also, typically, SOAP services don't accept
URL parameters.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295680
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfmail question

[Dave Watts]

> So how can I get multiple records in the one cfmail.

Use CFLOOP within your CFMAIL tag.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295679
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Could not generate stub objects for web service invocation

[sam menon]

Now its working in our web server not on clients server...

How can i change the following code to get the values


o = 
createObject("webservice","https://b2b.ratestogo.com/WS/Services/Content/Content.asmx/HotelList?AffiliateID=1&Password=test123&CityName=Chicago";);






It will retrieve the data in xml format, if i test the url it works fine but 
not if I try to invoke it as a web service, Do I need to make any changes to 
the code??

Thanks for the help


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295678
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Could not generate stub objects for web service invocation

[sam menon]

Hi,
  I am getting the following error
Could not generate stub objects for web service invocation, when i tried to 
execute a sample web service.
How to check whether web service site is working or not

I tried using the following code



o = 
createObject("webservice","http://www.xmethods.net/sd/2001/CurrencyExchangeService.wsdl";);
stArgs = structNew();
stArgs.country1 = "united states";
stArgs.country2 = "united states";

stArgs.commandName="getRate";
q=o.CommandHandler(argumentCollection=stArgs);





 

Please help me to resolve this issue

Thanks


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295677
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Flex to CF using Mapping

[Dale Fraser]

I have done this before but can't get it to work this time (first time with
CF8).

 

I am using Flex to connect to CFC's via mapping. I have enabled mapping use
in the XML and restarted the server but I get this error.

 

[RPC Fault faultString="[MessagingError message='Destination 'ColdFusion'
either does not exist or the destination has no channels defined (and the
application does not define any default channels.)']"
faultCode="InvokeFailed" faultDetail="Couldn't establish a connection to
'ColdFusion'"]

 at
mx.rpc::AbstractInvoker/http://www.adobe.com/2006/flex/mx/internal::invoke()
[E:\dev\flex_3_beta3\sdk\frameworks\projects\rpc\src\mx\rpc\AbstractInvoker.
as:264]

 at
mx.rpc.remoting.mxml::Operation/http://www.adobe.com/2006/flex/mx/internal::
invoke()[E:\dev\flex_3_beta3\sdk\frameworks\projects\rpc\src\mx\rpc\remoting
\mxml\Operation.as:204]

 at
mx.rpc.remoting::Operation/send()[E:\dev\flex_3_beta3\sdk\frameworks\project
s\rpc\src\mx\rpc\remoting\Operation.as:120]

 at Function/http://adobe.com/AS3/2006/builtin::apply()

 at
mx.rpc.remoting.mxml::Operation/send()[E:\dev\flex_3_beta3\sdk\frameworks\pr
ojects\rpc\src\mx\rpc\remoting\mxml\Operation.as:177]

 at Function/http://adobe.com/AS3/2006/builtin::apply()

 at
mx.rpc::AbstractService/http://www.adobe.com/2006/actionscript/flash/proxy::
callProperty()[E:\dev\flex_3_beta3\sdk\frameworks\projects\rpc\src\mx\rpc\Ab
stractService.as:292]

 at
DataGrid1/___DataGrid1_Button1_click()[F:\DataGrid1\src\DataGrid1.mxml:17]

 

 

It seems to be asking for a Channel, but I want to using a mapping and not
define channels.

 

Regards

Dale Fraser

 

http://learncf.com

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295676
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfmail question

[Seamus Campbell]

Hi and thanks. But if I do that I only get one record from the query and there 
are usually multipple records.
If do this:

#stock_id# - #author# #title# - 
#number_of_books# - #DollarFormat(price)#  #br#

inside the cfmail tag I get an "Invalid tag nesting configuration" error.

So how can I get multiple records in the one cfmail.

Ta

Seamus

>You've passed a query to cfmail so it acts the same as:
>
>
>
>
>
>Try removing the query attribute.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295675
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfmail question

[Adrian Lynch]

You've passed a query to cfmail so it acts the same as:





Try removing the query attribute.

Adrian
http://www.adrianlynch.co.uk/

-Original Message-
From: Seamus Campbell
Sent: 02 January 2008 00:15
To: CF-Talk
Subject: cfmail question


Hi

I have the following code (at end of this email)
I want to send one email to admin_email but the code below sends multiple
emails - one for each record produced by the query.
I can't see why this is happening - any help gratefully received


SELECT token, stock_id, title, number_of_books, price, author
FROM tbl_shopping_cart_orders
WHERE token = '#token_ID#'








#stock_id# - #author# #title# - #number_of_books# - #DollarFormat(price)#
#br#




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295674
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

cfmail question

[Seamus Campbell]

Hi

I have the following code (at end of this email)
I want to send one email to admin_email but the code below sends multiple 
emails - one for each record produced by the query. 
I can't see why this is happening - any help gratefully received


SELECT token, stock_id, title, number_of_books, price, author
FROM tbl_shopping_cart_orders
WHERE token = '#token_ID#'








#stock_id# - #author# #title# - #number_of_books# - #DollarFormat(price)#  #br#

 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295673
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Looping and CFIFs

[Phillip M. Vector]

That worked. Thanks. :)

Dominic Watson wrote:
> Ah, sorry I didn't test it!
> 
> You will need to use: position[field][currentRow].
> 
> The currentRow is relative to the query that is being looped (with cfoutput
> or cfloop) so you can use that instead of your count variable.
> 
> Dominic
> 
> 
> 
> 
> On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote:
>> Thanks..
>>
>> When I do that, I get  Complex object types cannot be converted to
>> simple values.
>>
>> When I try the second solution, I get ..
>>
>> cannot convert the value of type class coldfusion.sql.QueryColumn to a
>> boolean
>>
>> Any ideas? :)
>>
>> Dominic Watson wrote:
>>> Hi Philip, instead of doing:
>>>
>>> 
>>>
>>> Do:
>>>
>>> 
>>>
>>> Also, and this is personal preference, you can treat the 1 or 0 values
>> as
>>> booleans so you could also write it as:
>>>
>>> ... or > positions[field]>...
>>> Dominic
>>>
>>>
>>>
>>>
>>>
>>>
>>> On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote:
 I'm trying to loop over a list of table columns and use the "selected"
 option on the select tag to set it yes or no based on the value.. But I
 can't seem to figure out how to do this as I can't indent a # within a
>> #
 pair.

 Any ideas on how to make the check to see if it's 1 or 0 work?

 ===



>>> method="post">


#position#

>>>

>> "DownloadGames,SeeSchedules,SeeStatus,SetStatus,EnterGames,SeeEmail,Employee,JobSettings">


>>>>>> 'positions.#Field#' EQ 1>
 Selected

>Yes

>>>>>> 'positions.#Field#' EQ 0>
 Selected

>No





>>> Name="ListingOrder_#Count#"
 value="#Positions.ListingOrder#" size="3">
>>> value="#Positions.id#">





>>>
>>
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295672
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Looping and CFIFs

[Dominic Watson]

Ah, sorry I didn't test it!

You will need to use: position[field][currentRow].

The currentRow is relative to the query that is being looped (with cfoutput
or cfloop) so you can use that instead of your count variable.

Dominic




On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote:
>
> Thanks..
>
> When I do that, I get  Complex object types cannot be converted to
> simple values.
>
> When I try the second solution, I get ..
>
> cannot convert the value of type class coldfusion.sql.QueryColumn to a
> boolean
>
> Any ideas? :)
>
> Dominic Watson wrote:
> > Hi Philip, instead of doing:
> >
> > 
> >
> > Do:
> >
> > 
> >
> > Also, and this is personal preference, you can treat the 1 or 0 values
> as
> > booleans so you could also write it as:
> >
> > ... or  positions[field]>...
> >
> > Dominic
> >
> >
> >
> >
> >
> >
> > On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote:
> >> I'm trying to loop over a list of table columns and use the "selected"
> >> option on the select tag to set it yes or no based on the value.. But I
> >> can't seem to figure out how to do this as I can't indent a # within a
> #
> >> pair.
> >>
> >> Any ideas on how to make the check to see if it's 1 or 0 work?
> >>
> >> ===
> >>
> >>
> >>
> >> >> method="post">
> >>
> >>
> >>#position#
> >>
> >> >>
> >>
> "DownloadGames,SeeSchedules,SeeStatus,SetStatus,EnterGames,SeeEmail,Employee,JobSettings">
> >>
> >>
> >> >> >> 'positions.#Field#' EQ 1>
> >> Selected
> >>
> >>>Yes
> >>
> >> >> >> 'positions.#Field#' EQ 0>
> >> Selected
> >>
> >>>No
> >>
> >>
> >>
> >>
> >>
> >> >> Name="ListingOrder_#Count#"
> >> value="#Positions.ListingOrder#" size="3">
> >> >> value="#Positions.id#">
> >>
> >>
> >>
> >>
> >>
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295671
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Looping and CFIFs

[Phillip M. Vector]

Thanks..

When I do that, I get  Complex object types cannot be converted to 
simple values.

When I try the second solution, I get ..

  cannot convert the value of type class coldfusion.sql.QueryColumn to a 
boolean

Any ideas? :)

Dominic Watson wrote:
> Hi Philip, instead of doing:
> 
> 
> 
> Do:
> 
> 
> 
> Also, and this is personal preference, you can treat the 1 or 0 values as
> booleans so you could also write it as:
> 
> ... or ...
> 
> Dominic
> 
> 
> 
> 
> 
> 
> On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote:
>> I'm trying to loop over a list of table columns and use the "selected"
>> option on the select tag to set it yes or no based on the value.. But I
>> can't seem to figure out how to do this as I can't indent a # within a #
>> pair.
>>
>> Any ideas on how to make the check to see if it's 1 or 0 work?
>>
>> ===
>>
>>
>>
>>> method="post">
>>
>>
>>#position#
>>
>>>
>> "DownloadGames,SeeSchedules,SeeStatus,SetStatus,EnterGames,SeeEmail,Employee,JobSettings">
>>
>>
>>>> 'positions.#Field#' EQ 1>
>> Selected
>>
>>>Yes
>>
>>>> 'positions.#Field#' EQ 0>
>> Selected
>>
>>>No
>>
>>
>>
>>
>>
>>> Name="ListingOrder_#Count#"
>> value="#Positions.ListingOrder#" size="3">
>>> value="#Positions.id#">
>>
>>
>>
>>
>>
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295670
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Looping and CFIFs

[Dominic Watson]

Hi Philip, instead of doing:



Do:



Also, and this is personal preference, you can treat the 1 or 0 values as
booleans so you could also write it as:

... or ...

Dominic






On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote:
>
> I'm trying to loop over a list of table columns and use the "selected"
> option on the select tag to set it yes or no based on the value.. But I
> can't seem to figure out how to do this as I can't indent a # within a #
> pair.
>
> Any ideas on how to make the check to see if it's 1 or 0 work?
>
> ===
>
>
>
> method="post">
>
>
>#position#
>
>
> "DownloadGames,SeeSchedules,SeeStatus,SetStatus,EnterGames,SeeEmail,Employee,JobSettings">
>
>
> 'positions.#Field#' EQ 1>
> Selected
>
>>Yes
>
> 'positions.#Field#' EQ 0>
> Selected
>
>>No
>
>
>
>
>
> Name="ListingOrder_#Count#"
> value="#Positions.ListingOrder#" size="3">
> value="#Positions.id#">
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295669
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Should jsstringformat do more?

[s. isaac dealey]

> -- It is a rather sneaky gotcha' and no one seems to care-- Everyone 
> (almost) seems to be saying "yeah, so what?  That's TECHINCALLY right."

Which happens to be one of my biggest peeves... Like the guys who say
that javascript is "technically correct" when you ask it to perform 10/1
or some similar division and it spits back a number with a long decimal
value. It's "technically correct!" -- forget that it's basically useless... 

> This whole conversation has reminded me of programmers diligently
> defending their code by insisting "But, it's working as designed!!!".
> Meanwhile, the users are saying, "That's great, but it still doesn't
> help us solve the problem."

Yeah, what Cooper talks about in Inmates. 

> Maybe I should write a udf to sanitize strings to be safe for html
> script tags.  How does that sound?

That's what I did. I wrapped jsstringformat with a replace of "/" so
that they're all preceded by the \ escape character -- which is proper
escaping in javascript, so it solves the problem, always works, and
never causes any new problems. I do think it escapes more characters
than SerializeJSON does tho -- I haven't looked specifically, but for
example if there's an http url in it, it turns it into http:\/\/ which I
don't think SerializeJSON does... but that's fine since the it doesn't
hurt anything to escape those characters... I suspect there's a PHP
function that does it that way too, because I remember seeing some url's
in some javascript created by PHP that looked like that a while back. 



-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295668
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Looping and CFIFs

[Phillip M. Vector]

I'm trying to loop over a list of table columns and use the "selected" 
option on the select tag to set it yes or no based on the value.. But I 
can't seem to figure out how to do this as I can't indent a # within a # 
pair.

Any ideas on how to make the check to see if it's 1 or 0 work?

===






#position#





 Selected

>Yes


 Selected

>No











~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295667
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Should jsstringformat do more?

[Brad Wood]

Thanks for the remarks Claude.   I do fully understand the mechanics
behind why the error occurs.  I guess you could say my beef/confusion is
that:

-- For once, CF doesn't have a pre-built way escape something and it
seems odd. (Although, it has been called an "edge case")
-- It is a rather sneaky gotcha' and no one seems to care-- Everyone
(almost) seems to be saying "yeah, so what?  That's TECHINCALLY right."


As vindicating as those remarks are, they don't help anyone solve the
problem.  Once again, it appears I always seem to expect too much from
ColdFusion.  :)

This whole conversation has reminded me of programmers diligently
defending their code by insisting "But, it's working as designed!!!".
Meanwhile, the users are saying, "That's great, but it still doesn't
help us solve the problem."

Although mentally stimulating, I would have preferred we wasted our
energy thinking how CF could be enhanced to assist in solving this
problem elegantly-- not arguing why it is "working as designed".  If
that means that jsstringformat should be left alone, and
htmlscriptformat should be built, then so be it.  

Maybe I should write a udf to sanitize strings to be safe for html
script tags.  How does that sound?

~Brad

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295666
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SUM Question

[morchella]

mssql2000

On Jan 1, 2008 3:07 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:

> You may have to use the QoQ.. if you bring the count up into the outer
> query you'll have to use GROUP BY defeating the sum() (unless you're
> using Oracle in which you can do a sum over. What RDBMS are you using?
>
>
> On Jan 1, 2008 1:47 PM, morchella <[EMAIL PROTECTED]> wrote:
> > thats what i just said.
> > i can now get #get_totals.Sumtotal#
> > but not #get_totals.total#
> >
> > where befor i could get either using a qoq.
> >
> > 
> > Select SUM(total) AS Sumtotal
> > From (
> >Select Count(*) AS total
> >From employees
> >WHERE emp_assigned = #get_Emp.usr_id#
> >) AS derived_table
> > 
> > On Jan 1, 2008 2:38 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:
> >
> > > use
> > > query.sumtotal
> > >
> > >
> >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295665
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: If It Ain't Broke

[s. isaac dealey]

> Thanks for the input Isaac. 

Welcome.

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295664
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Should jsstringformat do more?

[s. isaac dealey]

> JSStringFormat, XMLFormat, URLEncodedFormat, HTMLCodeFormat, and
> HTMLEditFormat take existing strings and remove any metacharacters
> from them. They sanitize the string - make it "safe" - for the
> specific target environment in which the string will be used. The
> specific metacharacters in question depend on the target environment
> in question - JavaScript, XML, URLs, HTML. I don't think it's a good
> idea for one of these functions to "guess" that I want to remove
> something that isn't a metacharacter when in fact I may not. For
> example, I wouldn't want URLEncodedFormat to remove SQL commands
> embedded in a string, even though I don't generally want SQL commands
> in URLs. It's the programmer's job to deal with those specific cases.

I never recommended that it remove anything. If you put \ in front of /
in a javascript literal, the literal then contains the same / that was
in the string before, it just doesn't break if it happens to be inside a
pair of script tags and has the string  in it. So it would
continue to work if you used 

")#');"> 

The same way that this would work 

alert('#jsstringformat("")#');

It's simply more sanitized than it is given the current behavior.

The comparison to having UrlEncodedFormat remove SQL commands is a
straw man argument in this case, because it's not analogous to what I've
suggested. It might have been analogous if I'd suggested that it should
replace "" with "" -- which is conspicuously not what I
suggested.

I'll concede if anyone can produce an example of a case in which
escaping the string would actually cause a problem. No one in this
thread has done that still that I can tell. You're still arguing against
a simple solution to a problem with no obvious side-effects on the basis
of the fear that there might be some ambiguous problem caused by it that
you can't forsee or articulate... in spite of the fact that the solution
has been tested and proven to work. Doom saying for the sake of doom
saying. Lets stop flying places, 'cause that's not natural, God would
have given us wings if he wanted us to fly.


-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295663
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Record Set Paging

[Massimo Foti]

This is a custom tag, not a CFC. Maybe it could fit your needs anyway:
http://www.olimpo.ch/tmt/tag/querynav/

  
Massimo Foti, web-programmer for hire
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com
  


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295662
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Should jsstringformat do more?

[s. isaac dealey]

> If it's a bug, it is only in the CMS that did not make sure the HTML
> code it produces was right. Not in the HTML parser. The HTML parser
> does not parse the Javascript code, so obviously, the parser must rely
> on its end tag  to resume parsing HTML code. This imply that
> by definition the JS code cannot contain anywhere the string
> "".

I agree. Therefore, jsstringformat should format strings the way
SerializeJSON does. 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295661
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Should jsstringformat do more?

[s. isaac dealey]

>  >>This
> has nothing to do with the "safety" of JavaScript string literals at
> all, and everything to do with HTML.
> 
> Absolutely.

Totally irrelevant.

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295660
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Should jsstringformat do more?

[Dave Watts]

> > > In spite of the fact that SerializeJSON() handles it correctly.
> > 
> > That's a different function, designed to do a different thing. Your 
> > comparison is analogous to complaning that XMLFormat doesn't behave 
> > like CFWDDX.
> 
> That's one of the dumbest things I've ever heard in my life. 

You obviously need to get out more, then.

SerializeJSON and CFWDDX allow you to take things that aren't strings at
all, like queries, structures, etc, and convert them to strings.

JSStringFormat, XMLFormat, URLEncodedFormat, HTMLCodeFormat, and
HTMLEditFormat take existing strings and remove any metacharacters from
them. They sanitize the string - make it "safe" - for the specific target
environment in which the string will be used. The specific metacharacters in
question depend on the target environment in question - JavaScript, XML,
URLs, HTML. I don't think it's a good idea for one of these functions to
"guess" that I want to remove something that isn't a metacharacter when in
fact I may not. For example, I wouldn't want URLEncodedFormat to remove SQL
commands embedded in a string, even though I don't generally want SQL
commands in URLs. It's the programmer's job to deal with those specific
cases.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295659
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SUM Question

[Greg Morphis]

You may have to use the QoQ.. if you bring the count up into the outer
query you'll have to use GROUP BY defeating the sum() (unless you're
using Oracle in which you can do a sum over. What RDBMS are you using?


On Jan 1, 2008 1:47 PM, morchella <[EMAIL PROTECTED]> wrote:
> thats what i just said.
> i can now get #get_totals.Sumtotal#
> but not #get_totals.total#
>
> where befor i could get either using a qoq.
>
> 
> Select SUM(total) AS Sumtotal
> From (
>Select Count(*) AS total
>From employees
>WHERE emp_assigned = #get_Emp.usr_id#
>) AS derived_table
> 
> On Jan 1, 2008 2:38 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:
>
> > use
> > query.sumtotal
> >
> >
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295658
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Woops, I've F***ed up my rich text editor.

[Will Tomlinson]

>I guess I should switch to TinyMCE, huh Will? 
>
>Rick

Just tired of seeing everyone get FCK'ed up by the built-in when TinyMCE/CFFM 
is virtually painless.  :)


Will 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295657
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SUM Question

[morchella]

thats what i just said.
i can now get #get_totals.Sumtotal#
but not #get_totals.total#

where befor i could get either using a qoq.


Select SUM(total) AS Sumtotal
>From (
Select Count(*) AS total
From employees
WHERE emp_assigned = #get_Emp.usr_id#
) AS derived_table

On Jan 1, 2008 2:38 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:

> use
> query.sumtotal
>
>


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295656
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SUM Question

[Greg Morphis]

use
query.sumtotal

On Jan 1, 2008 1:16 PM, morchella <[EMAIL PROTECTED]> wrote:
> ok..
> i did this
>
> 
> Select SUM(total) AS Sumtotal
> From (
>Select Count(*) AS total
>From employees
>WHERE emp_assigned = #get_Emp.usr_id#
>) AS derived_table
> 
>
> but now i cant call the variable total to show with in my page?
> it shows Sumtotal just fine..
>
> i have tried
> get_totals.derived_table.total
> get_totals.total
> derived_table.total
>
>
> On Jan 1, 2008 1:32 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:
>
>
> > use a subquery..
> >
> > select sum(foo) as daSum
> > from
> > (
> >  select count(goo) as foo
> >  from table
> >  where hoo = 1
> > )
> >
> >
> >
> > On Jan 1, 2008 12:14 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote:
> > > yeah
> > > i was trying to sum on the result of the count
> > > if i do this i only get the last result, not the sum of all
> > >
> > > 
> > >Select Count(*) AS total
> > >From employees
> > >WHERE emp_assigned = #get_Emp.usr_id#
> > > 
> > >
> > > 
> > >Select SUM(total) AS Sumtotal
> > >From employees
> > > 
> > >
> > > name value
> > > p1 25
> > > p2 30
> > > p3 10
> > >
> > > totalvalue 10
> > > should be 65
> > >
> > >
> > >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295655
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SUM Question

[morchella]

ok..
i did this


Select SUM(total) AS Sumtotal
>From (
Select Count(*) AS total
From employees
WHERE emp_assigned = #get_Emp.usr_id#
) AS derived_table


but now i cant call the variable total to show with in my page?
it shows Sumtotal just fine..

i have tried
get_totals.derived_table.total
get_totals.total
derived_table.total


On Jan 1, 2008 1:32 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:

> use a subquery..
>
> select sum(foo) as daSum
> from
> (
>  select count(goo) as foo
>  from table
>  where hoo = 1
> )
>
>
>
> On Jan 1, 2008 12:14 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote:
> > yeah
> > i was trying to sum on the result of the count
> > if i do this i only get the last result, not the sum of all
> >
> > 
> >Select Count(*) AS total
> >From employees
> >WHERE emp_assigned = #get_Emp.usr_id#
> > 
> >
> > 
> >Select SUM(total) AS Sumtotal
> >From employees
> > 
> >
> > name value
> > p1 25
> > p2 30
> > p3 10
> >
> > totalvalue 10
> > should be 65
> >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295654
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Should jsstringformat do more?

[Claude Schneegans]

 >>This
has nothing to do with the "safety" of JavaScript string literals at all,
and everything to do with HTML.

Absolutely.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295653
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Should jsstringformat do more?

[Claude Schneegans]

 >>If I enter "the End of " and it gets butchered when it goes
somewhere else, that's a bug.

If it's a bug, it is only in the CMS that did not make sure the HTML 
code it produces was right.
Not in the HTML parser.
The HTML parser does not parse the Javascript code, so obviously,
the parser must rely on its end tag  to resume parsing HTML code.
This imply that by definition the JS code cannot contain anywhere the 
string "".

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295652
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Should jsstringformat do more?

[Claude Schneegans]

 >>I think it is obvious that
"" is not a "safe" string under certain JavaScript conditions.

The problem is not with Javascript here, it is with the HTML parser.
The HTML parser considers that the JS code is only
alert('
and passes it to the JS engine. The engine does what it can with what it 
gets.

I think one must remember that there are two layers involved:
the first layer HTML defines the ... as containing 
anything except
the string "".

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295651
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Woops, I've F***ed up my rich text editor.

[Rick Faircloth]

What's that buzzing noise?

Shoo fly!

Oh, never mind, it's only Will!  :o)

Hey, I just saw a demo of TinyMCE and it has a
"full-screen" toggle button! I want that!  Why
doesn't FCKeditor have one?

I guess I should switch to TinyMCE, huh Will? 

Rick

> -Original Message-
> From: Will Tomlinson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 01, 2008 1:15 PM
> To: CF-Talk
> Subject: Re: Woops, I've F***ed up my rich text editor.
> 
> >Has anyone got any ideas as to what's going wrong?
> >
> >
> 
> Psst pssst
> 
> TinyMCE/CFFM will fix it.
> 
> Will
> 




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295650
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SUM Question

[morchella]

OK...
very cool.
i am not familiar with sub queries.
will have to google.


On Jan 1, 2008 1:32 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:

> use a subquery..
>
> select sum(foo) as daSum
> from
> (
>  select count(goo) as foo
>  from table
>  where hoo = 1
> )
>
>
>
> On Jan 1, 2008 12:14 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote:
> > yeah
> > i was trying to sum on the result of the count
> > if i do this i only get the last result, not the sum of all
> >
> > 
> >Select Count(*) AS total
> >From employees
> >WHERE emp_assigned = #get_Emp.usr_id#
> > 
> >
> > 
> >Select SUM(total) AS Sumtotal
> >From employees
> > 
> >
> > name value
> > p1 25
> > p2 30
> > p3 10
> >
> > totalvalue 10
> > should be 65
> >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295649
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SUM Question

[Greg Morphis]

use a subquery..

select sum(foo) as daSum
from
(
  select count(goo) as foo
  from table
  where hoo = 1
)



On Jan 1, 2008 12:14 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote:
> yeah
> i was trying to sum on the result of the count
> if i do this i only get the last result, not the sum of all
>
> 
>Select Count(*) AS total
>From employees
>WHERE emp_assigned = #get_Emp.usr_id#
> 
>
> 
>Select SUM(total) AS Sumtotal
>From employees
> 
>
> name value
> p1 25
> p2 30
> p3 10
>
> totalvalue 10
> should be 65
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295648
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Woops, I've F***ed up my rich text editor.

[Todd]

Won't fixed what he did.  He modified his default  and it's not
working.  TimyMCE/CFFM will only fix it if he chooses to ignore what he just
modified.

On Jan 1, 2008 1:15 PM, Will Tomlinson <[EMAIL PROTECTED]> wrote:

> >Has anyone got any ideas as to what's going wrong?
> Psst pssst
>
> TinyMCE/CFFM will fix it.
>
> Will
>


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295647
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SUM Question

[morchella]

nm

just had to nest  


honestly i already have all every thing i need dont inside of a nested loop.
but some one said doing it with q0q inside nested ouptuts would put less
strain on the server.

Is this true?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295646
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Woops, I've F***ed up my rich text editor.

[Will Tomlinson]

>Has anyone got any ideas as to what's going wrong?
>
> 

Psst pssst

TinyMCE/CFFM will fix it. 

Will


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295645
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SUM Question

[Paul Ihrig]

yeah
i was trying to sum on the result of the count
if i do this i only get the last result, not the sum of all


Select Count(*) AS total
From employees
WHERE emp_assigned = #get_Emp.usr_id#



Select SUM(total) AS Sumtotal
From employees


name value
p1 25
p2 30
p3 10

totalvalue 10
should be 65


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295644
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SUM Question

[Charlie Griefer]

specify the column name that you're trying to SUM

On Jan 1, 2008 9:55 AM, morchella <[EMAIL PROTECTED]> wrote:
> ok not sure what i am doing wrong
> in my out put it does the count just fine, but i cant get it to SUM up the
> totals.
>
> error:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '*'.
>
>
> 
> Select Count(*) AS total,
> SUM(*) AS Sumtotal
> From employees
> WHERE emp_assigned = #get_Emp.usr_id#
> 
>
> name value
> p1 25
> p2 30
> p3 10
>
> totalvalue should be 65
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295643
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SUM Question

[morchella]

ok not sure what i am doing wrong
in my out put it does the count just fine, but i cant get it to SUM up the
totals.

error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '*'.



Select Count(*) AS total,
SUM(*) AS Sumtotal
From employees
WHERE emp_assigned = #get_Emp.usr_id#


name value
p1 25
p2 30
p3 10

totalvalue should be 65


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295642
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: 2008 conferences of interest

[Sean Corfield]

On Jan 1, 2008 8:32 AM, Adam Haskell <[EMAIL PROTECTED]> wrote:
> If you have any interest in Java I strongly suggest No Fluff Just Stuff.
> Honestly even if Java is not your thing it really offers a good wealth of
> content not Java specific like agile programming, OO concepts, Functional
> Programming.

Good points. If we're recommending more general "good conferences"
then I would suggest SD West / SD East. I went to SD West a few years
back and it blew my mind and really got the creative juices flowing.
Highly recommended.

http://www.sdexpo.com/

(SD West is in March, SD East aka SD Best Practices is in Boston in October).
-- 
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295641
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: 2008 conferences of interest

[Adam Haskell]

If you have any interest in Java I strongly suggest No Fluff Just Stuff.
Honestly even if Java is not your thing it really offers a good wealth of
content not Java specific like agile programming, OO concepts, Functional
Programming.  The sessions are just like the title no fluff just straight
into a subject and good discussions. My favorite part of NFJS is it is a
traveling conference so generally there is no travel budget (as they visit
many of the major cities in the US) and the others in attendance are from
the area so its a good local networking experience.

http://www.nofluffjuststuff.com/

Adam Haskell

On Dec 31, 2007 10:54 AM, Andy Matthews <[EMAIL PROTECTED]> wrote:

> Hey everyone...I've got a question about conferences...
>
> My boss just asked our team to indicate which (if any) conference we might
> wish to attend this year. I know about the big ones:
>
> CFUnited
> MAX
> CFObjective
>
> But I also don't want to limit myself to only CF conferences. I'd also be
> interested in attending conferences about Flash, Flex, Javascript, etc.
>
> Would you all mind listing out a few conferences that you've heard of, and
> that might be included in the technology list above?
>
> 
>
> Andy Matthews
> Senior ColdFusion Developer
>
> Office:  877.707.5467 x747
> Direct:  615.627.9747
> Fax:  615.467.6249
> [EMAIL PROTECTED]
> www.dealerskins.com 
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295640
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Woops, I've F***ed up my rich text editor.

[Rick Faircloth]

Hi, Robert... and happy new year!

Your issue with the rich cftextarea and the file uploads
sounds exactly like what happened with me.

The solution for me was to further modify the
config.cfm file (FCKeditor\editor\filemanager\upload\cfm\config.cfm)
on line 30.

I had to change the "config.serverPath" value to a hard coded value,
since FCKeditor isn't running directly off the root of the application
using it.  I found notes concerning this one line 30 of that file.
I stumbled upon them while looking for a solution to the same problem
you seem to be having.

You also have to change the "config.serverPath" value to the same
value as above for the config.cfm file in
FCKeditor\editor\filemanager\browser\default\connectors\cfm\config.cfm.

If your situation meets the criteria for changing the config.serverPath
as mentioned on line 30 of both the config.cfm files mentioned above,
trying hard coding the "config.serverPath" to a local system value such as
E:\inetpub\webroot\userfiles\ or whatever path leads to the "userfiles"
folders you're using.

Rick


> -Original Message-
> From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 01, 2008 8:13 AM
> To: CF-Talk
> Subject: Woops, I've F***ed up my rich text editor.
> 
> Good morning guys! Happy new year to you all.
> 
> 
> 
> So, 2008 is already causing me stress and woe :-D I'm hoping you guys can
> give me a hand. This morning I've been working on a small dynamic CMS for a
> friends site and took the new rich cftextarea out for the first time. It
> worked nicely!
> 
> 
> 
> I then followed the steps on Rakshith's blog to get file uploads working on
> it, however I now seem to have broken the entire thing, after completing all
> the steps in the post I went to the page with my editor on it to find the
> editor not loading, just an empty white container, and a JavaScript error in
> the status bar of my browser.
> 
> 
> 
> http://www.rakshith.net/blog/?p=41
> 
> 
> 
> I've gone over and over the steps in that blog article and can't see what it
> is that's causing me the issue, everything looks to be exactly as it should
> be.
> 
> 
> 
> Has anyone got any ideas as to what's going wrong?
> 
> 
> 
> Thanks,
> 
> 
> 
> Rob
> 




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295639
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Woops, I've F***ed up my rich text editor.

[Robert Rawlins - Think Blue]

Good morning guys! Happy new year to you all.

 

So, 2008 is already causing me stress and woe :-D I'm hoping you guys can
give me a hand. This morning I've been working on a small dynamic CMS for a
friends site and took the new rich cftextarea out for the first time. It
worked nicely!

 

I then followed the steps on Rakshith's blog to get file uploads working on
it, however I now seem to have broken the entire thing, after completing all
the steps in the post I went to the page with my editor on it to find the
editor not loading, just an empty white container, and a JavaScript error in
the status bar of my browser.

 

http://www.rakshith.net/blog/?p=41

 

I've gone over and over the steps in that blog article and can't see what it
is that's causing me the issue, everything looks to be exactly as it should
be.

 

Has anyone got any ideas as to what's going wrong?

 

Thanks,

 

Rob



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295638
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: If It Ain't Broke

[Brad Wood]

Thanks for the input Isaac.  I dunno-- the more I've talked about it,
the more I've convinced myself that maybe jsstringformat really does do
all it should do.  (This has been a good- thought provoking thread for
me)  I just wish I could feel better about the solution of manually
escaping the script tags when placing your JS in an HTML script block.
Edge case or not, like I said before-- it just doesn't feel right.  It
doesn't seem bullet-proof.

That is probably because I have a knee-jerk reaction to code that looks
like someone is going through extra trouble to code something in a
complicated way to make it work.  Generally when I see that is means you
aren't doing something right in the first place.  Like when someone adds
a distinct or a group by to a query not because they need it, but
because that was the only way they could get rid of their dupes due to
their poorly crafted joins.  When I have to manually escape script tags
it just reeks of "wrong".  Like there should be a better, bullet-proof
way if I just re-thought my code.

Unfortunately, there doesn't seem to be an elegant answer to this one
that will give me the warm fuzzies as I code it.

~Brad

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295637
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Should jsstringformat do more?

[Brad Wood]

> To completely cover the latter, if you need to emit a JS string
containing > a literal "" within a HTML SCRIPT block, you
manually split it > > and you're done.  

Still seems like duct tape-- but I agree that does seem to be the most
(and only?) appropriate way to handle it.

> If you think there is a bug in the docs, you should enter a comment
> to that effect.

Not a bug so much as an information deficiency.  I think these gotcha's
would be worth mentioning.  I went to add a comment to the CF7 docs, but
it appears someone beat me to it.

> However, I don't see how you can reasonably assume that 
> jsStringFormat would do anything about context-sensitive rules.

I did pose the question, but I do believe I have come to the conclusion
that jsstringformat should not be aware of its context.  That being
said, I wish the docs would officially mention it.  Take xmlformat() for
example.  Can't you put absolutely anything into it and not break your
XML?  Shouldn't you be able to feed _anything_ into htmleditformat() and
know that the results can safely be placed into a form field's value?
Why then, should people be expected to assume jsstringformat to be any
different?  It just seems like CF has a nice and tidy, bullet-proof way
of escaping strings for any possible scenario under the sun with the
glaring exceptions of this hardly documented behavior.  For this I have
to resort to manually kludging up by script tags and it just doesn't
feel right.


> Worth mentioning (for your comment) is that quotes cause a similar
issue
> with jsStringFormatted embedded within HTML tag event handlers.  You
need > to use htmlEditFormat (or whatever) to convert the JS to valid 
> HTML, because that's the context it's used in.

Hmm, good point. I had forgotten about that.  At least the answer here
should be bullet-proof as long as you do   That
"feels right" to me. 

Thanks for the good input Barney.

~Brad

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295636
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4