date:20100916


Am I just tired or is this a little redundant? Set a local var equal to the
cookie value, then overwrite the cookie value with the local var value?
Surely I'm just reading this wrong.

On Thu, Sep 16, 2010 at 8:35 PM, Andrew Scott wrote:

>
> You should be doing something like this.
>
> isDefined("Cookie.CFTOKEN")>
>
>
>
>
>
>
> Regards,
> Andrew Scott
> http://www.andyscott.id.au/
>
>
> > -Original Message-
> > From: Duncan [mailto:duncan.lox...@gmail.com]
> > Sent: Friday, 17 September 2010 8:29 AM
> > To: cf-talk
> > Subject: duplication of cookies on each request
> >
> >
> > Hi Folks,
> >
> > I have a cookie dupication problem that I cannot get my head around. This
> is
> > a duplication of my thread on cf-aussie, so apologies to those who are
> seeing
> > this twice.
> >
> > See this page for example.
> >
> > http://www.biowishtechnologies.com/au/information/our-
> > company1/senior-management-team/lorenzo-gella/
> >
> > If you click through a few pages on this site, then view the cookies that
> have
> > been set for it you will see they have been multiplied a lot of times, I
> am
> > guessing unnecessarily. I believe these cookies should be set only once
> in
> the
> > root of the site. This happens for the CF and Google Analytics cookies.
> >
> > This issue appears to occur on CF9 in development and in CF8 on live. I
> have
> > tried different combinations of cfcookie and settings but nothing seems
> to
> > stop it happening. I believe that this issue is causes Internet Explorer
> users to
> > receive a blank page every now and again because the limit on the number
> > of cookies is being reached.
> >
> > In our application.cfc we have used this code in onRequestStart() to set
> UID,
> > and cf vars  > expires="never">
> >   > value="#Client.cftoken#">
> >
> > I have tried to use domain="www.biowishtechnologies.com" path="/" but it
> > makes no difference.
> >
> > The application is set out like this:
> >
> > 
> > 
> > 
> > 
> > 
> >
> > We have also removed all cfcookie tags, and then CF set the jsessionid in
> a
> > cookie. This has no change. We also moved the cookie tags into the
> > onSessionStart, but again no difference.
> >
> > I put some logging in to my on session start and on app start, and here
> is
> > what I found:
> >
> > application set as follows:
> >
> > 
> > 
> > 
> > 
> >
> > 
> >
> > creates one jsessionid cookie & 4 x GA cookies _utma _utmb _utmc _utmz
> > (all in lowercase)
> >
> > go to a sub page
> >
> > get an extra 2 x jsessionid cookies, 2 more sets of GA cookies but this
> time
> > the names are in uppercase
> >
> > go to a third page
> >
> > I get 3 more jsessionid cookies (now a total of 6, and now have a set of
> 8
> > utma cookies.
> >
> > The logging suggests that the session stays, and that the onsessionstart
> is
> > only called once.
> >
> > "Information","jrpp-
> > 11","09/16/10","13:06:45","LOCAL.BIOWISH.LOCAL","running
> > app new session"
> > "Information","jrpp-
> > 11","09/16/10","13:06:45","LOCAL.BIOWISH.LOCAL","running
> > app on req start"
> >
> > "Information","jrpp-
> > 11","09/16/10","13:07:35","LOCAL.BIOWISH.LOCAL","running
> > app on req start"
> >
> > "Information","jrpp-
> > 11","09/16/10","13:08:29","LOCAL.BIOWISH.LOCAL","running
> > app on req start"
> >
> > --
> >
> > The exact same thing is happening on live with the GA cookies too. This
> leads
> > me to think its not about the CF code. Why would the Google Analytics
> > cookies be replicated and increased each request?
> >
> > Thanks!
> >
> > --
> > Duncan I Loxton
> > duncan.lox...@gmail.com
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337164
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: duplication of cookies on each request


OT: You should really pre-load those mouse over images for the tabs. WHen I
mouse over I get a big ole' whitespace while the image loads.

On Thu, Sep 16, 2010 at 6:29 PM, Duncan  wrote:

>
> Hi Folks,
>
> I have a cookie dupication problem that I cannot get my head around. This
> is
> a duplication of my thread on cf-aussie, so apologies to those who are
> seeing this twice.
>
> See this page for example.
>
>
> http://www.biowishtechnologies.com/au/information/our-company1/senior-management-team/lorenzo-gella/
>
> If you click through a few pages on this site, then view the cookies that
> have been set for it you will see they have been multiplied a lot of times,
> I am guessing unnecessarily. I believe these cookies should be set only
> once
> in the root of the site. This happens for the CF and Google Analytics
> cookies.
>
> This issue appears to occur on CF9 in development and in CF8 on live. I
> have
> tried different combinations of cfcookie and settings but nothing seems to
> stop it happening. I believe that this issue is causes Internet Explorer
> users to receive a blank page every now and again because the limit on the
> number of cookies is being reached.
>
> In our application.cfc we have used this code in onRequestStart() to set
> UID, and cf vars  expires="never">
> 
> 
>
> I have tried to use domain="www.biowishtechnologies.com" path="/" but it
> makes no difference.
>
> The application is set out like this:
>
> 
>
>
>
>
>
> We have also removed all cfcookie tags, and then CF set the jsessionid in a
> cookie. This has no change. We also moved the cookie tags into the
> onSessionStart, but again no difference.
>
> I put some logging in to my on session start and on app start, and here is
> what I found:
>
> application set as follows:
>
>
>
>
>
>
>
>
> creates one jsessionid cookie & 4 x GA cookies _utma _utmb _utmc _utmz (all
> in lowercase)
>
> go to a sub page
>
> get an extra 2 x jsessionid cookies, 2 more sets of GA cookies but this
> time
> the names are in uppercase
>
> go to a third page
>
> I get 3 more jsessionid cookies (now a total of 6, and now have a set of 8
> utma cookies.
>
> The logging suggests that the session stays, and that the onsessionstart is
> only called once.
>
>
> "Information","jrpp-11","09/16/10","13:06:45","LOCAL.BIOWISH.LOCAL","running
> app new session"
>
> "Information","jrpp-11","09/16/10","13:06:45","LOCAL.BIOWISH.LOCAL","running
> app on req start"
>
>
> "Information","jrpp-11","09/16/10","13:07:35","LOCAL.BIOWISH.LOCAL","running
> app on req start"
>
>
> "Information","jrpp-11","09/16/10","13:08:29","LOCAL.BIOWISH.LOCAL","running
> app on req start"
>
> --
>
> The exact same thing is happening on live with the GA cookies too. This
> leads me to think its not about the CF code. Why would the Google Analytics
> cookies be replicated and increased each request?
>
> Thanks!
>
> --
> Duncan I Loxton
> duncan.lox...@gmail.com
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337163
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: duplication of cookies on each request

2010-09-16 Thread Andrew Scott


You should be doing something like this.








Regards,
Andrew Scott
http://www.andyscott.id.au/


> -Original Message-
> From: Duncan [mailto:duncan.lox...@gmail.com]
> Sent: Friday, 17 September 2010 8:29 AM
> To: cf-talk
> Subject: duplication of cookies on each request
> 
> 
> Hi Folks,
> 
> I have a cookie dupication problem that I cannot get my head around. This
is
> a duplication of my thread on cf-aussie, so apologies to those who are
seeing
> this twice.
> 
> See this page for example.
> 
> http://www.biowishtechnologies.com/au/information/our-
> company1/senior-management-team/lorenzo-gella/
> 
> If you click through a few pages on this site, then view the cookies that
have
> been set for it you will see they have been multiplied a lot of times, I
am
> guessing unnecessarily. I believe these cookies should be set only once in
the
> root of the site. This happens for the CF and Google Analytics cookies.
> 
> This issue appears to occur on CF9 in development and in CF8 on live. I
have
> tried different combinations of cfcookie and settings but nothing seems to
> stop it happening. I believe that this issue is causes Internet Explorer
users to
> receive a blank page every now and again because the limit on the number
> of cookies is being reached.
> 
> In our application.cfc we have used this code in onRequestStart() to set
UID,
> and cf vars  expires="never">
>   value="#Client.cftoken#">
> 
> I have tried to use domain="www.biowishtechnologies.com" path="/" but it
> makes no difference.
> 
> The application is set out like this:
> 
> 
> 
> 
> 
> 
> 
> We have also removed all cfcookie tags, and then CF set the jsessionid in
a
> cookie. This has no change. We also moved the cookie tags into the
> onSessionStart, but again no difference.
> 
> I put some logging in to my on session start and on app start, and here is
> what I found:
> 
> application set as follows:
> 
> 
> 
> 
> 
> 
> 
> 
> creates one jsessionid cookie & 4 x GA cookies _utma _utmb _utmc _utmz
> (all in lowercase)
> 
> go to a sub page
> 
> get an extra 2 x jsessionid cookies, 2 more sets of GA cookies but this
time
> the names are in uppercase
> 
> go to a third page
> 
> I get 3 more jsessionid cookies (now a total of 6, and now have a set of 8
> utma cookies.
> 
> The logging suggests that the session stays, and that the onsessionstart
is
> only called once.
> 
> "Information","jrpp-
> 11","09/16/10","13:06:45","LOCAL.BIOWISH.LOCAL","running
> app new session"
> "Information","jrpp-
> 11","09/16/10","13:06:45","LOCAL.BIOWISH.LOCAL","running
> app on req start"
> 
> "Information","jrpp-
> 11","09/16/10","13:07:35","LOCAL.BIOWISH.LOCAL","running
> app on req start"
> 
> "Information","jrpp-
> 11","09/16/10","13:08:29","LOCAL.BIOWISH.LOCAL","running
> app on req start"
> 
> --
> 
> The exact same thing is happening on live with the GA cookies too. This
leads
> me to think its not about the CF code. Why would the Google Analytics
> cookies be replicated and increased each request?
> 
> Thanks!
> 
> --
> Duncan I Loxton
> duncan.lox...@gmail.com


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337162
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Problem with getting cfhttp to do a post

2010-09-16 Thread Andrei Kondrashev


If POST from a browser works AND it is NOT an authetication issue, you should 
be able
successuly POST using CFHTTP or CFX_HTTP5.

Wondering, why do you have encoded="no" set?  Browsers, do URL-encoding of 
values before POST.
So, you might be rejected, because some values you are posting are not decoded
properly on their side.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337161
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Wrapping text before writing to an image

2010-09-16 Thread Leigh


I am 99% sure at least one of the open source cfc's has an existing function 
for wrapping.  Maybe check the ImageUtils.cfc ?

-Leigh


  

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337160
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe


thanks for everyones help, its now solved! 

the reason i am building it through a string is because it is interacting with 
various extjs grids, which apply filters. i have a generic function that 
creates the havingclause to filter the data.

i ran the havingclause through a loop printing out 1 character at a time. the 
apostophe was printed as '%apos;' even though it appeared as ' in the sql 
statement!

have taken on board comments re cfqueryparam and now that this error is fixed 
will update it to include the sql injection

thanks for all the help  :)


> hi, we are running a cfquery with the following sql statement:
> 
> SELECT viewname, categoryname FROM views LEFT OUTER JOIN 
> viewcategories on views.categoryid = viewcategories.categoryid GROUP 
> BY viewname HAVING categoryname IN ("'s") ORDER BY viewname ASC 
> LIMIT 0, 300
> 
> if we type this directly into mysql it works fine, similarly if we 
> type it directly into a  it works fine. however the having 
> clause is getting built from following code and is causing the 
> problem:
> 
> 
> 
> 
  
> 
> 
>  />
> 
> the problem is occuring due to the apostrophe '. we have tried 
> preserveSingleQuotes but still does not work.
> 
> is there any way around this? 
> 
> thanks 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337159
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

duplication of cookies on each request

2010-09-16 Thread Duncan

Hi Folks,

I have a cookie dupication problem that I cannot get my head around. This is
a duplication of my thread on cf-aussie, so apologies to those who are
seeing this twice.

See this page for example.

http://www.biowishtechnologies.com/au/information/our-company1/senior-management-team/lorenzo-gella/

If you click through a few pages on this site, then view the cookies that
have been set for it you will see they have been multiplied a lot of times,
I am guessing unnecessarily. I believe these cookies should be set only once
in the root of the site. This happens for the CF and Google Analytics
cookies.

This issue appears to occur on CF9 in development and in CF8 on live. I have
tried different combinations of cfcookie and settings but nothing seems to
stop it happening. I believe that this issue is causes Internet Explorer
users to receive a blank page every now and again because the limit on the
number of cookies is being reached.

In our application.cfc we have used this code in onRequestStart() to set
UID, and cf vars

I have tried to use domain="www.biowishtechnologies.com" path="/" but it
makes no difference.

The application is set out like this:

We have also removed all cfcookie tags, and then CF set the jsessionid in a
cookie. This has no change. We also moved the cookie tags into the
onSessionStart, but again no difference.

I put some logging in to my on session start and on app start, and here is
what I found:

application set as follows:

creates one jsessionid cookie & 4 x GA cookies _utma _utmb _utmc _utmz (all
in lowercase)

go to a sub page

get an extra 2 x jsessionid cookies, 2 more sets of GA cookies but this time
the names are in uppercase

go to a third page

I get 3 more jsessionid cookies (now a total of 6, and now have a set of 8
utma cookies.

The logging suggests that the session stays, and that the onsessionstart is
only called once.

"Information","jrpp-11","09/16/10","13:06:45","LOCAL.BIOWISH.LOCAL","running
app new session"
"Information","jrpp-11","09/16/10","13:06:45","LOCAL.BIOWISH.LOCAL","running
app on req start"

"Information","jrpp-11","09/16/10","13:07:35","LOCAL.BIOWISH.LOCAL","running
app on req start"

"Information","jrpp-11","09/16/10","13:08:29","LOCAL.BIOWISH.LOCAL","running
app on req start"

The exact same thing is happening on live with the GA cookies too. This
leads me to think its not about the CF code. Why would the Google Analytics
cookies be replicated and increased each request?

Thanks!

--
Duncan I Loxton
duncan.lox...@gmail.com

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337158
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Consuming webservices using CF8

2010-09-16 Thread Olav Andreas Antonsen

I don't think the problem is related to the proxy, because I get the same 
problem
when I try to consume a simple (local) test ws.

wsargs = structnew();
wsargs.refreshwsdl="yes";
wsargs.savejava="yes";
//wsargs.proxyServer = "proxy";
//wsargs.proxyPort = "8080";
//wsargs.wsdl2JavaArgs = "-D -v -w -W";
ws =
createObject("webservice","http://localhost:8500/eCID/ecws/ecoaa.cfc?wsdl",wsargs);

org.apache.axis.ConfigurationException: org.xml.sax.SAXException: Fatal Error:
URI=null Line=40: The string "--" is not permitted within comments.
org.xml.sax.SAXException: Fatal Error: URI=null Line=40: The string "--" is not
permitted within comments. at
org.apache.axis.utils.XMLUtils$ParserErrorHandler.fatalError(XMLUtils.java:723) 
at
org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source) at
org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at
org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) a

The "sad" part is that I'm not having any problems consuming the same ws using 
C# ;-(

Debugging my C# testapp reveals that this is the request I'm sending:

http://schemas.xmlsoap.org/soap/envelope/";
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/";
xmlns:tns="http://ecws.ecid"; xmlns:types="http://ecws.ecid/encodedTypes";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";>
  http://schemas.xmlsoap.org/soap/encoding/";>

  sd
  sd

And this is the response I'm getting:

ResponseCode: 200 (OK)
Connection:close
Content-Type:text/xml; charset=utf-8
Date:Thu, 16 Sep 2010 14:27:48 GMT
Server:JRun Web Server

http://schemas.xmlsoap.org/soap/envelope/";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>

http://schemas.xmlsoap.org/soap/encoding/";
xmlns:ns1="http://ecws.ecid";>
  BINGO

>I'm thinking it must be the proxy because this works fine for me:
>
>
>wsargs = structnew();
>ws = createObject("webservice","
>http://ws.fraudlabs.com/zipcodeworldUS_webservice.asmx?wsdl",wsargs);
>
>
>
>On Thu, Sep 16, 2010 at 9:10 AM, OLav Andreas Antonsen wrote:
>
>> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337157
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Vmware and CF 8+


Greg, more powerful servers use more juice, generate more heat and have a
bigger carbon footprint, ask any data centre or google will garnish more
details for you.

HTH

On Thu, Sep 16, 2010 at 7:04 PM, Rick Faircloth wrote:

>
> Mercy... I hope it's worth it.
> (And I hope you're working for a company that's footing
> the bill! :o)
>
>
> -Original Message-
> From: Brook Davies [mailto:cft...@logiforms.com]
> Sent: Thursday, September 16, 2010 1:59 PM
> To: cf-talk
> Subject: RE: Vmware and CF 8+
>
>
> Oh yeah, I didn't mention there was a 750.00 setup cost too :)
>
> -Original Message-
> From: Rick Faircloth [mailto:r...@whitestonemedia.com]
> Sent: September-16-10 9:36 AM
> To: cf-talk
> Subject: RE: Vmware and CF 8+
>
>
> Wow, and *extra* $300 for per *month* for an upgraded circuit?
> Sounds like at least a very extravagant charge for a one-time
> upgrade on their end, which *may* have cost $300 *one time*...
>
> If they told me it would be an *extra* $300 per *month*, I'd say
> forget that and find myself another spot for co-location.
>
> Just .02 on that situation, but sorry, I have no advice on the
> vmware aspect.
>
> However, I can say that I could purchase the use of 3 complete
> virtual servers running Win 2008 Server and CF8 or 9 and all the
> support I need for the cost of your circuit upgrade of $300 per month.
> (and about 18 months and zero downtime with my current VPS provider...)
>
> Rick
>
>
>
> -Original Message-
> From: Brook Davies [mailto:br...@logiforms.com]
> Sent: Thursday, September 16, 2010 12:26 PM
> To: cf-talk
> Subject: Vmware and CF 8+
>
>
> Hi People,
>
> So I have this monster Dell 6850 with 32 gigs of ram and 4 X Intel
> 2.67GHz/2M/667 Xeon Dual Core 7020. I bought it not realizing my colocation
> facility was going to want to charge me an extra 300.00 per month for the
> upgraded circuit to support the 240V power requirements.
>
> The only way that this makes any sense to me is if I can segment this
> machine into 2 or more vmware servers (for CF). I have zero experience and
> only a passing knowledge of vmware. Would it make sense to do this? Can any
> one offer their opinions and/or point me in the right direction?
>
> Brook
>
>
>
>
>
>
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337156
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Wrapping text before writing to an image

2010-09-16 Thread Eric Roberts


OK...on to the next project...

We have a function that is currently using cfx_imageflare that creates an
800x600 black image and puts whatever text you want on it.  If the text goes
longer than the image, it wraps it.  Any ideas on how do do this in CF or
java?  the CF Wrap function doesn't work for this purpose as the
ImageDrawText function doesnt seem to recognize line breaks.  The only think
my searching found was a word wrap function in a class (that is an extension
of java.lang.Object called sim.utils.WordWrap...apparently this is not a
standard java library and I couldn't find any source to get a copy.  I could
do something to break the quote up into several vars to simulate different
lines, but I would like something a litte friendlier than that ;-)  I really
hate to reinvent the wheel if i don;t have to.  If anyone has any ideas, I
would appreceiate it.

Eric


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337155
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe

2010-09-16 Thread Jason Fisher


If it was MSSQL, you would want single quotes, so more like this:



SELECT viewname, categoryname FROM views LEFT OUTER JOIN viewcategories on 
views.categoryid = viewcategories.categoryid GROUP BY viewname HAVING 0 = 0 
AND categoryname IN ('''s') ORDER BY viewname ASC LIMIT 0, 300 
Instead of setting your "havingClause" variable and messing with 
preserveSingleQuotes(), can you just do this?



SELECT viewname, categoryname
FROM views LEFT OUTER JOIN
viewcategories ON views.categoryid = viewcategories.categoryid
GROUP BY viewname
HAVING 0 = 0 
AND categoryname IN (  )
ORDER BY viewname ASC LIMIT 0, 300




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337154
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe


thanks, although the problem is there is no error to catch. when we run a 
cfdump of the query, the sql is as follows:

SELECT viewname, categoryname FROM views LEFT OUTER JOIN viewcategories on 
views.categoryid = viewcategories.categoryid GROUP BY viewname HAVING 0 = 0 AND 
categoryname IN ("'s") ORDER BY viewname ASC LIMIT 0, 300 

it just doesnt pull out the data, but if we copy it directly into mysql command 
line it works fine

we do not even know how to trace the error as how can it work in mysql command 
line but not in coldfusion? completely lost on this one!



>Wrap your actual cfquery with cftry and then cfoutput the variable cfcatch.sql
>
>
> ...
>   type="Database">#cfcatch.sql#
>
>
>Then post that sql here.
>
>Rick 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337153
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFM 1.32 Released

On Thu, Sep 16, 2010 at 1:32 PM, Rick Root  wrote:
> D'oh.
>
> It's "class"
>
> I changed it to "clazz" and it worked.
>
> Checked into subversion!

updated the download file too

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337152
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Vmware and CF 8+

2010-09-16 Thread Rick Faircloth

Mercy... I hope it's worth it.
(And I hope you're working for a company that's footing
the bill! :o)

-Original Message-
From: Brook Davies [mailto:cft...@logiforms.com] 
Sent: Thursday, September 16, 2010 1:59 PM
To: cf-talk
Subject: RE: Vmware and CF 8+

Oh yeah, I didn't mention there was a 750.00 setup cost too :)

-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: September-16-10 9:36 AM
To: cf-talk
Subject: RE: Vmware and CF 8+

Wow, and *extra* $300 for per *month* for an upgraded circuit?
Sounds like at least a very extravagant charge for a one-time
upgrade on their end, which *may* have cost $300 *one time*...

If they told me it would be an *extra* $300 per *month*, I'd say
forget that and find myself another spot for co-location.

Just .02 on that situation, but sorry, I have no advice on the
vmware aspect.

However, I can say that I could purchase the use of 3 complete
virtual servers running Win 2008 Server and CF8 or 9 and all the
support I need for the cost of your circuit upgrade of $300 per month.
(and about 18 months and zero downtime with my current VPS provider...)

Rick

-Original Message-
From: Brook Davies [mailto:br...@logiforms.com] 
Sent: Thursday, September 16, 2010 12:26 PM
To: cf-talk
Subject: Vmware and CF 8+

Hi People,

So I have this monster Dell 6850 with 32 gigs of ram and 4 X Intel
2.67GHz/2M/667 Xeon Dual Core 7020. I bought it not realizing my colocation
facility was going to want to charge me an extra 300.00 per month for the
upgraded circuit to support the 240V power requirements. 

The only way that this makes any sense to me is if I can segment this
machine into 2 or more vmware servers (for CF). I have zero experience and
only a passing knowledge of vmware. Would it make sense to do this? Can any
one offer their opinions and/or point me in the right direction?

Brook

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337151
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Vmware and CF 8+

2010-09-16 Thread Brook Davies

Oh yeah, I didn't mention there was a 750.00 setup cost too :)

-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: September-16-10 9:36 AM
To: cf-talk
Subject: RE: Vmware and CF 8+

Wow, and *extra* $300 for per *month* for an upgraded circuit?
Sounds like at least a very extravagant charge for a one-time
upgrade on their end, which *may* have cost $300 *one time*...

If they told me it would be an *extra* $300 per *month*, I'd say
forget that and find myself another spot for co-location.

Just .02 on that situation, but sorry, I have no advice on the
vmware aspect.

However, I can say that I could purchase the use of 3 complete
virtual servers running Win 2008 Server and CF8 or 9 and all the
support I need for the cost of your circuit upgrade of $300 per month.
(and about 18 months and zero downtime with my current VPS provider...)

Rick

-Original Message-
From: Brook Davies [mailto:br...@logiforms.com] 
Sent: Thursday, September 16, 2010 12:26 PM
To: cf-talk
Subject: Vmware and CF 8+

Hi People,

So I have this monster Dell 6850 with 32 gigs of ram and 4 X Intel
2.67GHz/2M/667 Xeon Dual Core 7020. I bought it not realizing my colocation
facility was going to want to charge me an extra 300.00 per month for the
upgraded circuit to support the 240V power requirements. 

The only way that this makes any sense to me is if I can segment this
machine into 2 or more vmware servers (for CF). I have zero experience and
only a passing knowledge of vmware. Would it make sense to do this? Can any
one offer their opinions and/or point me in the right direction?

Brook

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337150
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFM 1.32 Released

D'oh.

It's "class"

I changed it to "clazz" and it worked.

Checked into subversion!

Rick

On Thu, Sep 16, 2010 at 1:26 PM, Rick Root  wrote:
> It's this line of javascript causing the problem in IE
>
> for (var class in classes2) {
>
> Here's test code that errors at that line:
>
> 
> var classes = 'foo bar bar2 bar3 bar4';
> var classes2 = classes.split(' ');
> var actions = 
> 'download,delete,rename,copymove,editimage,unzip,editfile,viewsource';
> var arrActions = actions.split(',');
> alert(classes2.length);
> for (class in classes2) {
>        for (var action in arrActions) {
>                if ( classes2[class] == 'cffm-menu-'+arrActions[action] ) {
>                        alert('ok');
>                }
>        }
> }
> 
>
> Any

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337149
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Vmware and CF 8+

2010-09-16 Thread Greg Luce


Russ,

240v power supplies run more efficiently than 120v. The voltage being double
doesn't mean it uses more electricity. It'll actually probably use LESS. The
fee is probably to do with logistics. They may not have 240v circuits run to
all their racks.
-- 
Greg Luce
Luce Consulting Services, Inc.
www.luceconsulting.net
(863) 273-0289



On Thu, Sep 16, 2010 at 12:54 PM, Russ Michaels  wrote:

>
> Rick,
>
> in the current climate companies have to be responsible for their energy
> efficiency and carbon footprint, and data centres are increasingly aware of
> this and often have strict guidelines with regards to power usage.In
> addition power hungry servers like this will usually run quite hot, which
> will overheat the rack. Each rack has a max voltage output and generally
> should not exceed this.
> So it may be that Brooks mega server is using the same power as 3-4 regular
> servers, meaning that they can put less in the rack so as to stay within
> the
> voltage and temp limits. the extra cost is probably to cover that loss.
>
> Some data centres wouldn't even let you do it period.
>
> Of course it may also be that he is not hosting directly with the data
> centre as most hosts do not own the data centre, in which case the host
> also
> has to adhere to the data centres restrictions and incur additional costs.
>
> Russ
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337148
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFM 1.32 Released


It's this line of javascript causing the problem in IE

for (var class in classes2) {

Here's test code that errors at that line:


var classes = 'foo bar bar2 bar3 bar4';
var classes2 = classes.split(' ');
var actions = 
'download,delete,rename,copymove,editimage,unzip,editfile,viewsource';
var arrActions = actions.split(',');
alert(classes2.length);
for (class in classes2) {
for (var action in arrActions) {
if ( classes2[class] == 'cffm-menu-'+arrActions[action] ) {
alert('ok');
}
}
}


Anyone know why IE is failing there?

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337147
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFM 1.32 Released

On Thu, Sep 16, 2010 at 1:12 PM, Greg Luce  wrote:
>
> Works in chrome but broken js in IE 8.

Oh hell.

Forgot to test it in IE!  DAMN YOU IE!!

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337146
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFM 1.32 Released

I added the index.cfm =)

On Thu, Sep 16, 2010 at 12:43 PM, Will Tomlinson  wrote:
>
>>Demo: http://www.opensourcecf.com/cffm/demo
>
>
> Rick, the demo doesn't come up:
>
> HTTP Status 404 - /cffm/demo/
>
> Thanks,
> Will
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337145
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFM 1.32 Released

2010-09-16 Thread Greg Luce

Works in chrome but broken js in IE 8.
-- 
Greg Luce
Luce Consulting Services, Inc.
www.luceconsulting.net
(863) 273-0289

On Thu, Sep 16, 2010 at 12:43 PM, Will Tomlinson wrote:

>
> >Demo: http://www.opensourcecf.com/cffm/demo
>
>
> Rick, the demo doesn't come up:
>
> HTTP Status 404 - /cffm/demo/
>
> Thanks,
> Will
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337144
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Vmware and CF 8+

2010-09-16 Thread Justin Scott


> Would it make sense to do this?

Absolutely!  Several months ago we began consolidating some of our older
servers on to a Dell 2950 with 32GB and lots of RAIDed hard drive space.  We
installed VMware ESXi on the base machine and then copied the ISO images for
our server installs.  We use vSphere to manage it remotely.  It doesn't have
all of the features of the paid VMware solutions, but it's enough to run a
bunch of virtual machines which all hum along nicely without any trouble.

I believe that ESXi only supports two processors though, so you likely
wouldn't be able to take full advantage with the free version.


-Justin Scott



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337143
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Vmware and CF 8+


Rick,

in the current climate companies have to be responsible for their energy
efficiency and carbon footprint, and data centres are increasingly aware of
this and often have strict guidelines with regards to power usage.In
addition power hungry servers like this will usually run quite hot, which
will overheat the rack. Each rack has a max voltage output and generally
should not exceed this.
So it may be that Brooks mega server is using the same power as 3-4 regular
servers, meaning that they can put less in the rack so as to stay within the
voltage and temp limits. the extra cost is probably to cover that loss.

Some data centres wouldn't even let you do it period.

Of course it may also be that he is not hosting directly with the data
centre as most hosts do not own the data centre, in which case the host also
has to adhere to the data centres restrictions and incur additional costs.

Russ


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337142
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Vmware and CF 8+

2010-09-16 Thread denstar

On Thu, Sep 16, 2010 at 10:25 AM, Brook Davies wrote:
...
> The only way that this makes any sense to me is if I can segment this
> machine into 2 or more vmware servers (for CF). I have zero experience and
> only a passing knowledge of vmware. Would it make sense to do this? Can any
> one offer their opinions and/or point me in the right direction?

I've been digging on Xen lately.  Before that I was using ESXi.

You can turn that machine into like, 4 to 8 VMs, easy, depending on
how much ram and processors you want to give each.

VMs freaking roxor.

:Den

-- 
In the infancy of societies, the chiefs of state shape its
institutions; later the institutions shape the chiefs of state.
Charles de Montesquieu

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337141
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFM 1.32 Released

2010-09-16 Thread Will Tomlinson


>Demo: http://www.opensourcecf.com/cffm/demo


Rick, the demo doesn't come up:

HTTP Status 404 - /cffm/demo/

Thanks,
Will 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337140
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Vmware and CF 8+

2010-09-16 Thread Rick Faircloth


Wow, and *extra* $300 for per *month* for an upgraded circuit?
Sounds like at least a very extravagant charge for a one-time
upgrade on their end, which *may* have cost $300 *one time*...

If they told me it would be an *extra* $300 per *month*, I'd say
forget that and find myself another spot for co-location.

Just .02 on that situation, but sorry, I have no advice on the
vmware aspect.

However, I can say that I could purchase the use of 3 complete
virtual servers running Win 2008 Server and CF8 or 9 and all the
support I need for the cost of your circuit upgrade of $300 per month.
(and about 18 months and zero downtime with my current VPS provider...)

Rick



-Original Message-
From: Brook Davies [mailto:br...@logiforms.com] 
Sent: Thursday, September 16, 2010 12:26 PM
To: cf-talk
Subject: Vmware and CF 8+


Hi People,

So I have this monster Dell 6850 with 32 gigs of ram and 4 X Intel
2.67GHz/2M/667 Xeon Dual Core 7020. I bought it not realizing my colocation
facility was going to want to charge me an extra 300.00 per month for the
upgraded circuit to support the 240V power requirements. 

The only way that this makes any sense to me is if I can segment this
machine into 2 or more vmware servers (for CF). I have zero experience and
only a passing knowledge of vmware. Would it make sense to do this? Can any
one offer their opinions and/or point me in the right direction?

Brook






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337139
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Vmware and CF 8+


If you are running windows 2008 then you don't need vmware, you have hyper-v
built right in, and as this is a new machine your CPU and mobo will have
hyper-v support built in as well.
I'd read on that first before you go making more work for yourself.

Russ

-Original Message-
From: Brook Davies [mailto:br...@logiforms.com] 
Sent: 16 September 2010 17:26
To: cf-talk
Subject: Vmware and CF 8+


Hi People,

So I have this monster Dell 6850 with 32 gigs of ram and 4 X Intel
2.67GHz/2M/667 Xeon Dual Core 7020. I bought it not realizing my colocation
facility was going to want to charge me an extra 300.00 per month for the
upgraded circuit to support the 240V power requirements. 

The only way that this makes any sense to me is if I can segment this
machine into 2 or more vmware servers (for CF). I have zero experience and
only a passing knowledge of vmware. Would it make sense to do this? Can any
one offer their opinions and/or point me in the right direction?

Brook






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337138
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Vmware and CF 8+

2010-09-16 Thread Brook Davies


Hi People,

So I have this monster Dell 6850 with 32 gigs of ram and 4 X Intel
2.67GHz/2M/667 Xeon Dual Core 7020. I bought it not realizing my colocation
facility was going to want to charge me an extra 300.00 per month for the
upgraded circuit to support the 240V power requirements. 

The only way that this makes any sense to me is if I can segment this
machine into 2 or more vmware servers (for CF). I have zero experience and
only a passing knowledge of vmware. Would it make sense to do this? Can any
one offer their opinions and/or point me in the right direction?

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337137
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Rounding Numbers

2010-09-16 Thread Jeanmarie Richardson

Thanks All!  This is what I needed!

> Beat me to it, Phillip, but she'll want ceiling() to get the upper 
> 1000:
> 
> 
> 
> 
> 
> 
> From: "Phillip Vector" 
> Sent: Thursday, September 16, 2010 10:54 AM
> To: "cf-talk" 
> Subject: Re: Rounding Numbers
> 
> Couldn't you divide it by 1000 then round, then multiply by 1000?
> 
> 
> 
> I don't know if that will work and it's early in the morning, so the
> code may be wrong, but I suspect you get the idea.
> 
> On Thu, Sep 16, 2010 at 7:37 AM, Jeanmarie Richardson  net> wrote:
> >
> > Hi --
> >
> > I need to round numbers consistently to the highest 1000. ï¿½Is there 
> a CF Function that will do this? ï¿½I found something called 
> intervalRound from Rob Rusher but it rounds to the nearest 1000 
> (rounding down in some cases) which is not what I need. ï¿½An example 
> would be great!
> >
> > 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337136
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Migrating from CFMX6.1 to CF9 (Win2K3,SQL2K)

2010-09-16 Thread Sean Henderson


1. Anyone have a reason why CGI.path_info would be empty?
2. Other gotchas, tips and or headaches?
This is a big version jump and I cannot be the only one to have done it.  
Searching this forum with "CFMX6.1 CF9" and similar didn't yield much. TIA -Sean


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337135
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CFFM 1.32 Released


Okay, I've finished updating CFFM to version 1.32

- removed uploadify (flash based uploader), replaced with fileuploader
jquery plugin
- added context menus for file actions (delete, copy, download, etc)
- fixed a "bug" where CFFM didn't work in BlueDragon 7.1 becaue
bluedragon didn't auto-uppercase struct elements

Still compatible back to old versions of BD and CF (6.1) as far as I know ...

Demo: http://www.opensourcecf.com/cffm/demo
Download:  http://www.opensourcecf.com/cffm/download.cfm
Subversion:  http://svn.riaforge.org/cffm
Project Page: http://cffm.riaforge.org

Thanks.  Enjoy!

Rick

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337134
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Really odd problem - cpu utilization at idle


just remove the license key to revert to developer mode. it is in one of the
neo xml files.



On Thu, Sep 16, 2010 at 4:08 PM, Mark A. Kruger wrote:

>
> Dan,
>
> If the problem is client vars it is not enough to  simply switch it to a
> DB.
> CF will still try to clean up the registry keys  because, while client vars
> are no longer stored there "by default", that storage is still available to
> CF to use. I always manually delete that file or (more risky) remove the
> registry from the defaults - by editing the xml file.
>
> Sorry for being pedantic - there's every chance this is not even your issue
> - I just want to be sure to cover all bases :)
>
> -Mark
>
>
>
> -Original Message-
> From: Dan Baughman [mailto:dan.baugh...@gmail.com]
> Sent: Thursday, September 16, 2010 9:44 AM
> To: cf-talk
> Subject: Re: Really odd problem - cpu utilization at idle
>
>
> Ok I switched it to use an empty database for the client vars.
>
> Also I do have the option of dropping back to developer mode.  I
> googled and didn't see how to do drop back to developer mode, is this
> an XML file somewhere?
>
> Thanks for suggestions so far, all.
>
> On 9/16/10, Mark A. Kruger  wrote:
> >
> > Russ,
> >
> > You can remove the Registry manually from the XML config file and restart
> > the CF server... this will mean CF will not include the registry in the
> > purge -  at least that was one point of my post.  But some aps will
> specify
> > registry as the storage mechanism, so this could cause you other issues.
> >
> > -mark
> >
> >
> > Mark A. Kruger, MCSE, CFG
> >
> >
> >
> > -Original Message-
> > From: Russ Michaels [mailto:r...@michaels.me.uk]
> > Sent: Thursday, September 16, 2010 8:15 AM
> > To: cf-talk
> > Subject: Re: Really odd problem - cpu utilization at idle
> >
> >
> >
> >
> >
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337133
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Rounding Numbers

This should be pretty simple.

On Thu, Sep 16, 2010 at 10:37 AM, Jeanmarie Richardson wrote:

>
> Hi --
>
> I need to round numbers consistently to the highest 1000.  Is there a CF
> Function that will do this?  I found something called intervalRound from Rob
> Rusher but it rounds to the nearest 1000 (rounding down in some cases) which
> is not what I need.  An example would be great!
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337132
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe


Wrap your actual cfquery with cftry and then cfoutput the variable cfcatch.sql


 ...
  #cfcatch.sql#


Then post that sql here.

Rick

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337131
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Really odd problem - cpu utilization at idle

Dan,

If the problem is client vars it is not enough to  simply switch it to a DB.
CF will still try to clean up the registry keys  because, while client vars
are no longer stored there "by default", that storage is still available to
CF to use. I always manually delete that file or (more risky) remove the
registry from the defaults - by editing the xml file.

Sorry for being pedantic - there's every chance this is not even your issue
- I just want to be sure to cover all bases :)

-Mark

-Original Message-
From: Dan Baughman [mailto:dan.baugh...@gmail.com] 
Sent: Thursday, September 16, 2010 9:44 AM
To: cf-talk
Subject: Re: Really odd problem - cpu utilization at idle

Ok I switched it to use an empty database for the client vars.

Also I do have the option of dropping back to developer mode.  I
googled and didn't see how to do drop back to developer mode, is this
an XML file somewhere?

Thanks for suggestions so far, all.

On 9/16/10, Mark A. Kruger  wrote:
>
> Russ,
>
> You can remove the Registry manually from the XML config file and restart
> the CF server... this will mean CF will not include the registry in the
> purge -  at least that was one point of my post.  But some aps will
specify
> registry as the storage mechanism, so this could cause you other issues.
>
> -mark
>
>
> Mark A. Kruger, MCSE, CFG
>
>
>
> -Original Message-
> From: Russ Michaels [mailto:r...@michaels.me.uk]
> Sent: Thursday, September 16, 2010 8:15 AM
> To: cf-talk
> Subject: Re: Really odd problem - cpu utilization at idle
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337130
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Rounding Numbers

2010-09-16 Thread Jason Fisher

Beat me to it, Phillip, but she'll want ceiling() to get the upper 1000:

From: "Phillip Vector" 
Sent: Thursday, September 16, 2010 10:54 AM
To: "cf-talk" 
Subject: Re: Rounding Numbers

Couldn't you divide it by 1000 then round, then multiply by 1000?

I don't know if that will work and it's early in the morning, so the
code may be wrong, but I suspect you get the idea.

On Thu, Sep 16, 2010 at 7:37 AM, Jeanmarie Richardson  wrote:
>
> Hi --
>
> I need to round numbers consistently to the highest 1000. ï¿½Is there a CF 
> Function that will do this? ï¿½I found something called intervalRound from 
> Rob Rusher but it rounds to the nearest 1000 (rounding down in some cases) 
> which is not what I need. ï¿½An example would be great!
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337129
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Rounding Numbers

2010-09-16 Thread Ian Skinner

  On 9/16/2010 7:37 AM, Jeanmarie Richardson wrote:
> Hi --
>
> I need to round numbers consistently to the highest 1000.  Is there a CF 
> Function that will do this?

Combined with some basic math, yes.

#ceiling(4397/1000) * 1000#

Replace the literally value '4397' with useful variables.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337128
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Rounding Numbers

2010-09-16 Thread Phillip Vector

Couldn't you divide it by 1000 then round, then multiply by 1000?

I don't know if that will work and it's early in the morning, so the
code may be wrong, but I suspect you get the idea.

On Thu, Sep 16, 2010 at 7:37 AM, Jeanmarie Richardson  wrote:
>
> Hi --
>
> I need to round numbers consistently to the highest 1000.  Is there a CF 
> Function that will do this?  I found something called intervalRound from Rob 
> Rusher but it rounds to the nearest 1000 (rounding down in some cases) which 
> is not what I need.  An example would be great!
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337127
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Rounding Numbers

2010-09-16 Thread Jeanmarie Richardson


This is the script that I am currently using:


/**
* Rounds any real number to a user specified interval.
* 
* @param nNumber  The number to round. (Required)
* @param nInterval  The number to round to. (Required)
* @param bOption  Used to calculate percentage for rounding. (Optional)
* @return Returns a number. 
* @author Rob Rusher (r...@robrusher.com) 
* @version 1, July 20, 2005 
*/
function intervalRound(nNumber, nInterval){
var nMultipler = fix(nNumber / nInterval); // How many times does the 
interval go into intNumber
var bOption = 0;

if(arrayLen(arguments) GTE 3 AND arguments[3])
if(((nNumber mod nInterval) / nInterval) gte .5) bOption = 1; // 
Calculate percentage for rounding option.

return (nInterval * nMultipler) + (bOption * nInterval);
}




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337126
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Rounding Numbers

2010-09-16 Thread Jeanmarie Richardson


Hi --

I need to round numbers consistently to the highest 1000.  Is there a CF 
Function that will do this?  I found something called intervalRound from Rob 
Rusher but it rounds to the nearest 1000 (rounding down in some cases) which is 
not what I need.  An example would be great! 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337125
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Really odd problem - cpu utilization at idle

2010-09-16 Thread Dan Baughman

Ok I switched it to use an empty database for the client vars.

Also I do have the option of dropping back to developer mode.  I
googled and didn't see how to do drop back to developer mode, is this
an XML file somewhere?

Thanks for suggestions so far, all.

On 9/16/10, Mark A. Kruger  wrote:
>
> Russ,
>
> You can remove the Registry manually from the XML config file and restart
> the CF server... this will mean CF will not include the registry in the
> purge -  at least that was one point of my post.  But some aps will specify
> registry as the storage mechanism, so this could cause you other issues.
>
> -mark
>
>
> Mark A. Kruger, MCSE, CFG
>
>
>
> -Original Message-
> From: Russ Michaels [mailto:r...@michaels.me.uk]
> Sent: Thursday, September 16, 2010 8:15 AM
> To: cf-talk
> Subject: Re: Really odd problem - cpu utilization at idle
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337124
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe

2010-09-16 Thread Jason Fisher


Or instead of using a variable, if you can just put the clause in the SQL 
statement, let the list param do the work for you:


HAVING categoryname IN (  )





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337123
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Consuming webservices using CF8

2010-09-16 Thread John M Bliss


I'm thinking it must be the proxy because this works fine for me:


wsargs = structnew();
ws = createObject("webservice","
http://ws.fraudlabs.com/zipcodeworldUS_webservice.asmx?wsdl",wsargs);



On Thu, Sep 16, 2010 at 9:10 AM, OLav Andreas Antonsen wrote:

>
> I recently upgraded to CF8 and Im not able to consume webservices from my
> dev edition on my personal PC.
>
> I have tried making my own simple test webservice, but Im not able to
> consume them using CF. (Im able to consume the ws using .Net or Java, but
> not from CF itself).
>
> I always get the following error:
>
> org.apache.axis.ConfigurationException: org.xml.sax.SAXException: Fatal
> Error: URI=null Line=40: The string "--" is not permitted within comments.
>
> This is the code Im using:
>
> 
> wsargs = structnew();
> wsargs.proxyServer = "proxy";
> wsargs.proxyPort = "8080";
> ws = createObject("webservice","
> http://ws.fraudlabs.com/zipcodeworldUS_webservice.asmx?wsdl",wsargs);
> 
>
> I know that the WSDL is ok since the WS works in .Net and Java. I also know
> that I can retrieve the wsdl using
>
> http://ws.fraudlabs.com/zipcodeworldUS_webservice.asmx?wsdl";
> result="myRes" proxyserver="proxy" proxyport="8080"/>
>
> So why do I get the The string "--" is not permitted within comments.
> error?
>
> I know that
> 1.  I get the same error for all ws I try to consume from CF, even
> simple test ws made using CF.
> 2.  The ws work, because I can consume them using .Net and Java.
> 3.  CFINVOKE gives me the same error
>
> Thanks,
> Olav, Oslo, Norway
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337122
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Consuming webservices using CF8

2010-09-16 Thread OLav Andreas Antonsen

I recently upgraded to CF8 and Iâm not able to consume webservices from my
dev edition on my personal PC.

I have tried making my own simple test webservice, but Iâm not able to
consume them using CF. (Iâm able to consume the ws using .Net or Java, but
not from CF itself).

I always get the following error:

org.apache.axis.ConfigurationException: org.xml.sax.SAXException: Fatal Error:
URI=null Line=40: The string "--" is not permitted within comments.

This is the code Iâm using:

wsargs = structnew();
wsargs.proxyServer = "proxy";
wsargs.proxyPort = "8080";
ws =
createObject("webservice","http://ws.fraudlabs.com/zipcodeworldUS_webservice.asmx?wsdl",wsargs);

I know that the WSDL is ok since the WS works in .Net and Java. I also know
that I can retrieve the wsdl using

http://ws.fraudlabs.com/zipcodeworldUS_webservice.asmx?wsdl";
result="myRes" proxyserver="proxy" proxyport="8080"/>

So why do I get the âThe string "--" is not permitted within comments.â
error?

I know that
1. I get the same error for all ws I try to consume from CF, even simple
test ws made using CF.
2. The ws work, because I can consume them using .Net and Java.
3. CFINVOKE gives me the same error

Thanks,
Olav, Oslo, Norway

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337121
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe

2010-09-16 Thread Ian Skinner


  On 9/16/2010 6:44 AM, Richard White wrote:
> thanks for the replies, although the preserveSingleQuotes doesnt work

You should be looking at the actual SQL that is being sent to the 
database.  It would be provide clear evidence of what is wrong.

Looking at this line:


You may want to investigate the listQualify() function.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337120
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe


thanks for the replies, although the preserveSingleQuotes doesnt work


> hi, we are running a cfquery with the following sql statement:
> 
> SELECT viewname, categoryname FROM views LEFT OUTER JOIN 
> viewcategories on views.categoryid = viewcategories.categoryid GROUP 
> BY viewname HAVING categoryname IN ("'s") ORDER BY viewname ASC 
> LIMIT 0, 300
> 
> if we type this directly into mysql it works fine, similarly if we 
> type it directly into a  it works fine. however the having 
> clause is getting built from following code and is causing the 
> problem:
> 
> 
> 
> 
  
> 
> 
>  />
> 
> the problem is occuring due to the apostrophe '. we have tried 
> preserveSingleQuotes but still does not work.
> 
> is there any way around this? 
> 
> thanks 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337119
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Really odd problem - cpu utilization at idle


Russ,

You can remove the Registry manually from the XML config file and restart
the CF server... this will mean CF will not include the registry in the
purge -  at least that was one point of my post.  But some aps will specify
registry as the storage mechanism, so this could cause you other issues.

-mark


Mark A. Kruger, MCSE, CFG



-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Thursday, September 16, 2010 8:15 AM
To: cf-talk
Subject: Re: Really odd problem - cpu utilization at idle




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337118
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Really odd problem - cpu utilization at idle


I would also add that it is actually not possible to STOP the registry being
used via CF. So if you have other sites on the server which you do not
control they could also be causing you issues.
In order to stop the registry being used you have to deny access to the
registry key to EVERYONE.
I have always used COOKIE as the default storage for years now and it has
worked fine.



--
Russ Michaels
www.cfmldeveloper.com - Supporting the CF community since 1999
FREE ColdFusion/Railo hosting for developers.

blog: www.michaels.me.uk


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337117
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Really odd problem - cpu utilization at idle


Er... sorry

Mark A. Kruger, MCSE, CFG
(402) 408-3733 ext 105
Skype: markakruger
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com



-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Thursday, September 16, 2010 8:11 AM
To: cf-talk
Subject: Re: Really odd problem - cpu utilization at idle


You mean Dan, not Russ :-)

On Thu, Sep 16, 2010 at 2:07 PM, Mark A. Kruger
wrote:

>
> Russ,
>
> I would still move it to a datasource...  see this post.
>
>
>
http://www.coldfusionmuse.com/index.cfm/2009/10/27/registry.bad.datasource.g
> ood
>
> Sometimes you are created entries even though you are not using client
> vars.
>
> What makes me think this is that you are indicating that the only thing
> running is the internal processes... the server is generally idle so
> something the server does on its own is the culprit.
>
> -Mark
>
>
> -Original Message-
> From: Russ Michaels [mailto:r...@michaels.me.uk]
> Sent: Thursday, September 16, 2010 3:38 AM
> To: cf-talk
> Subject: Re: Really odd problem - cpu utilization at idle
>
>
> If you have the option to temporarily switch it to developer mode, you
will
> be aable to access the server monitor.
>
> Russ
>
> On Thu, Sep 16, 2010 at 12:41 AM, Dan Baughman
> wrote:
>
> >
> > Russ: I have ColdFusion 9 standard, when I click on server monitor in
the
> > cfadmin it says not available for this version
> >
> > Mark: It is set to registry, but this is one site that does not use any
> > CLIENT. variables it uses all SESSION.  The purge period is set to 1
hour
> > and 7 minutes.
> >
> > On Wed, Sep 15, 2010 at 5:36 PM, Mark A. Kruger  > >wrote:
> >
> > >
> > > Dan,
> > >
> > > What's the setting for client vars?
> > >
> > > -mark
> > >
> > > Mark A. Kruger, MCSE, CFG
> > > (402) 408-3733 ext 105
> > > Skype: markakruger
> > > www.cfwebtools.com
> > > www.coldfusionmuse.com
> > > www.necfug.com
> > >
> > >
> > >
> > > -Original Message-
> > > From: Russ Michaels [mailto:r...@michaels.me.uk]
> > > Sent: Wednesday, September 15, 2010 6:31 PM
> > > To: cf-talk
> > > Subject: Re: Really odd problem - cpu utilization at idle
> > >
> > >
> > > have you tried using the built in server monitor to diagnose the
> problem
> > ?
> > >
> > >
> > > On Thu, Sep 16, 2010 at 12:27 AM, Dan Baughman
> > > wrote:
> > >
> > > >
> > > > Hi list,
> > > >
> > > > I have an issue where after sitting idle for a while JRUN spikes to
> > 100%
> > > of
> > > > it's cpu usage and just sits there.  I ran it and did some stack
> traces
> > > and
> > > > it wasn't even serving any web pages. Process monitor yielded that
> > > > Jrun.exe's only IO activity was rescanning some XML files in the
> > > ColdFusion
> > > > install folder.  We pulled the server from production and this issue
> > > recurs
> > > > if its just sitting there by itself.tor
> > > >
> > > > Any suggestions on how to figure out what JRUN is doing ??  I've
> never
> > > had
> > > > this problem before.
> > > >
> > > >
> > > > Thanks
> > > > Dan
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
>
>
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337116
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Really odd problem - cpu utilization at idle


You mean Dan, not Russ :-)

On Thu, Sep 16, 2010 at 2:07 PM, Mark A. Kruger wrote:

>
> Russ,
>
> I would still move it to a datasource...  see this post.
>
>
> http://www.coldfusionmuse.com/index.cfm/2009/10/27/registry.bad.datasource.g
> ood
>
> Sometimes you are created entries even though you are not using client
> vars.
>
> What makes me think this is that you are indicating that the only thing
> running is the internal processes... the server is generally idle so
> something the server does on its own is the culprit.
>
> -Mark
>
>
> -Original Message-
> From: Russ Michaels [mailto:r...@michaels.me.uk]
> Sent: Thursday, September 16, 2010 3:38 AM
> To: cf-talk
> Subject: Re: Really odd problem - cpu utilization at idle
>
>
> If you have the option to temporarily switch it to developer mode, you will
> be aable to access the server monitor.
>
> Russ
>
> On Thu, Sep 16, 2010 at 12:41 AM, Dan Baughman
> wrote:
>
> >
> > Russ: I have ColdFusion 9 standard, when I click on server monitor in the
> > cfadmin it says not available for this version
> >
> > Mark: It is set to registry, but this is one site that does not use any
> > CLIENT. variables it uses all SESSION.  The purge period is set to 1 hour
> > and 7 minutes.
> >
> > On Wed, Sep 15, 2010 at 5:36 PM, Mark A. Kruger  > >wrote:
> >
> > >
> > > Dan,
> > >
> > > What's the setting for client vars?
> > >
> > > -mark
> > >
> > > Mark A. Kruger, MCSE, CFG
> > > (402) 408-3733 ext 105
> > > Skype: markakruger
> > > www.cfwebtools.com
> > > www.coldfusionmuse.com
> > > www.necfug.com
> > >
> > >
> > >
> > > -Original Message-
> > > From: Russ Michaels [mailto:r...@michaels.me.uk]
> > > Sent: Wednesday, September 15, 2010 6:31 PM
> > > To: cf-talk
> > > Subject: Re: Really odd problem - cpu utilization at idle
> > >
> > >
> > > have you tried using the built in server monitor to diagnose the
> problem
> > ?
> > >
> > >
> > > On Thu, Sep 16, 2010 at 12:27 AM, Dan Baughman
> > > wrote:
> > >
> > > >
> > > > Hi list,
> > > >
> > > > I have an issue where after sitting idle for a while JRUN spikes to
> > 100%
> > > of
> > > > it's cpu usage and just sits there.  I ran it and did some stack
> traces
> > > and
> > > > it wasn't even serving any web pages. Process monitor yielded that
> > > > Jrun.exe's only IO activity was rescanning some XML files in the
> > > ColdFusion
> > > > install folder.  We pulled the server from production and this issue
> > > recurs
> > > > if its just sitting there by itself.tor
> > > >
> > > > Any suggestions on how to figure out what JRUN is doing ??  I've
> never
> > > had
> > > > this problem before.
> > > >
> > > >
> > > > Thanks
> > > > Dan
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337115
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Really odd problem - cpu utilization at idle

Russ,

I would still move it to a datasource...  see this post.

http://www.coldfusionmuse.com/index.cfm/2009/10/27/registry.bad.datasource.g
ood

Sometimes you are created entries even though you are not using client vars.

What makes me think this is that you are indicating that the only thing
running is the internal processes... the server is generally idle so
something the server does on its own is the culprit.

-Mark

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Thursday, September 16, 2010 3:38 AM
To: cf-talk
Subject: Re: Really odd problem - cpu utilization at idle

If you have the option to temporarily switch it to developer mode, you will
be aable to access the server monitor.

Russ

On Thu, Sep 16, 2010 at 12:41 AM, Dan Baughman
wrote:

>
> Russ: I have ColdFusion 9 standard, when I click on server monitor in the
> cfadmin it says not available for this version
>
> Mark: It is set to registry, but this is one site that does not use any
> CLIENT. variables it uses all SESSION.  The purge period is set to 1 hour
> and 7 minutes.
>
> On Wed, Sep 15, 2010 at 5:36 PM, Mark A. Kruger  >wrote:
>
> >
> > Dan,
> >
> > What's the setting for client vars?
> >
> > -mark
> >
> > Mark A. Kruger, MCSE, CFG
> > (402) 408-3733 ext 105
> > Skype: markakruger
> > www.cfwebtools.com
> > www.coldfusionmuse.com
> > www.necfug.com
> >
> >
> >
> > -Original Message-
> > From: Russ Michaels [mailto:r...@michaels.me.uk]
> > Sent: Wednesday, September 15, 2010 6:31 PM
> > To: cf-talk
> > Subject: Re: Really odd problem - cpu utilization at idle
> >
> >
> > have you tried using the built in server monitor to diagnose the problem
> ?
> >
> >
> > On Thu, Sep 16, 2010 at 12:27 AM, Dan Baughman
> > wrote:
> >
> > >
> > > Hi list,
> > >
> > > I have an issue where after sitting idle for a while JRUN spikes to
> 100%
> > of
> > > it's cpu usage and just sits there.  I ran it and did some stack
traces
> > and
> > > it wasn't even serving any web pages. Process monitor yielded that
> > > Jrun.exe's only IO activity was rescanning some XML files in the
> > ColdFusion
> > > install folder.  We pulled the server from production and this issue
> > recurs
> > > if its just sitting there by itself.tor
> > >
> > > Any suggestions on how to figure out what JRUN is doing ??  I've never
> > had
> > > this problem before.
> > >
> > >
> > > Thanks
> > > Dan
> > >
> > >
> > >
> >
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337114
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe

yea so don't forget to do your own SQL injection protection as well.

On Thu, Sep 16, 2010 at 1:54 PM, Rick Root  wrote:

>
> Aside from my trepidations about generating SQL like this because it
> prevents you from using , what you're looking for is
> #preserveSingleQuotes()#
>
> coldfusion automatically escapes any single quotes in variables that
> are within a  tag so if your query SQL is a variable
>
> 
> select blah blah blah
> from blah
> group by blah
> #preserveSingleQuotes(havingClause)#
> 
>
> Otherwise, the single quotes get doubled up and you'll get errors.
>
> Rick
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337113
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe

I'm with Rick. You should really change it up a wee bit so you can use
cfqueryparam. It has many advantages.

On Thu, Sep 16, 2010 at 8:54 AM, Rick Root  wrote:

>
> Aside from my trepidations about generating SQL like this because it
> prevents you from using , what you're looking for is
> #preserveSingleQuotes()#
>
> coldfusion automatically escapes any single quotes in variables that
> are within a  tag so if your query SQL is a variable
>
> 
> select blah blah blah
> from blah
> group by blah
> #preserveSingleQuotes(havingClause)#
> 
>
> Otherwise, the single quotes get doubled up and you'll get errors.
>
> Rick
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337112
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfquery not returning results with apostrophe


Aside from my trepidations about generating SQL like this because it
prevents you from using , what you're looking for is
#preserveSingleQuotes()#

coldfusion automatically escapes any single quotes in variables that
are within a  tag so if your query SQL is a variable


select blah blah blah
from blah
group by blah
#preserveSingleQuotes(havingClause)#


Otherwise, the single quotes get doubled up and you'll get errors.

Rick

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337111
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Is there a way to force lock release on Access database? (CF9)


This has not worked since CF5 i'm afriad.

On Thu, Sep 16, 2010 at 12:56 PM, Bobby Hartsfield wrote:

>
> If I recall, when we would need to upload a new copy of an MDB it would say
> it was in use and not allow it. We would just run a bad query against it
> and
> then it would allow us to overwrite it. " Select 1 from
> soemTableThatDoesntExist"
>
> Maybe that will work for you. It has been a lng time since I used
> an
> Access database so it may or may not work anymore.
>
> There is also the "Suspend all client connections" setting within the CF
> Admin (there is for SQL Server datasources at least). I'm sure you can
> change that value programmatically through the admin API.
>
>
> .:.:.:.:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
>
> -Original Message-
> From: Mike Kear [mailto:afpwebwo...@gmail.com]
> Sent: Wednesday, September 15, 2010 11:58 AM
> To: cf-talk
> Subject: Is there a way to force lock release on Access database? (CF9)
>
>
> I have to make an Access database containing updated data from my
> SQLServer database,  which can be downloaded by my users by FTP.I
> can make the Access database a coldfusion datasource,  and fill it up
> with the data I want,  but I need to release it from the lock
> ColdFusion puts on it.  Does anyone have a technique for releasing
> that lock nowdays?   (I'm using CF9 Enterprise).
>
> IN CF5, which is the last time i used Access with ColdFusion, it was
> a simple case of doing an invalid query but that doesnt work in MX
> days.   There was a non-documented function once as well ...
> CFusion_DBConnections_Flush( )   ... but that's not valid in CF9.
>
> Has anyone found a way to break that connection programmatically in CF9?
>
> --
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337110
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

cfquery not returning results with apostrophe


hi, we are running a cfquery with the following sql statement:

SELECT viewname, categoryname FROM views LEFT OUTER JOIN viewcategories on 
views.categoryid = viewcategories.categoryid GROUP BY viewname HAVING 
categoryname IN ("'s") ORDER BY viewname ASC LIMIT 0, 300

if we type this directly into mysql it works fine, similarly if we type it 
directly into a  it works fine. however the having clause is getting 
built from following code and is causing the problem:




  



the problem is occuring due to the apostrophe '. we have tried 
preserveSingleQuotes but still does not work.

is there any way around this? 

thanks 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337109
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Web Service and SSL

2010-09-16 Thread Bobby Hartsfield


I believe you can add the invalid cert to the java key store to solve that.
I've done it a couple of times but would still have to look up the steps on
Google.
 
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 

-Original Message-
From: Matt Williams [mailto:mgw...@gmail.com] 
Sent: Thursday, September 09, 2010 7:47 AM
To: cf-talk
Subject: Web Service and SSL


I'm invoking a web service that when browsed gives a security certificate
warning. This is a temporary issue and will be fixed. But to use it now,
does anyone know if there is a way to make the web service call ignore or
accept the certificate warning?







~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337108
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Is there a way to force lock release on Access database? (CF9)

2010-09-16 Thread Bobby Hartsfield


If I recall, when we would need to upload a new copy of an MDB it would say
it was in use and not allow it. We would just run a bad query against it and
then it would allow us to overwrite it. " Select 1 from
soemTableThatDoesntExist"

Maybe that will work for you. It has been a lng time since I used an
Access database so it may or may not work anymore.

There is also the "Suspend all client connections" setting within the CF
Admin (there is for SQL Server datasources at least). I'm sure you can
change that value programmatically through the admin API.


.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 
-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com] 
Sent: Wednesday, September 15, 2010 11:58 AM
To: cf-talk
Subject: Is there a way to force lock release on Access database? (CF9)


I have to make an Access database containing updated data from my
SQLServer database,  which can be downloaded by my users by FTP.I
can make the Access database a coldfusion datasource,  and fill it up
with the data I want,  but I need to release it from the lock
ColdFusion puts on it.  Does anyone have a technique for releasing
that lock nowdays?   (I'm using CF9 Enterprise).

IN CF5, which is the last time i used Access with ColdFusion, it was
a simple case of doing an invalid query but that doesnt work in MX
days.   There was a non-documented function once as well ...
CFusion_DBConnections_Flush( )   ... but that's not valid in CF9.

Has anyone found a way to break that connection programmatically in CF9?

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337107
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]

On Thu, Sep 16, 2010 at 12:04 AM, Paul Hastings  wrote:
>
> On 9/16/2010 2:45 AM, Rick Root wrote:
>> http://www.opensourcecf.com/1/2010/09/Example-of-using-JavaCSV-CSVReader-class-to-read-CSV-files.cfm
>
> pretty sure the numeric columns for csvReader are 0 based (ie 1st column is
> referenced as 0 not 1).
>
> yes, i'm too lazy to register on your blog.

I like it that way ;)

You're right, this line:

should be

Rick

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337106
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Really odd problem - cpu utilization at idle