from:"tom"


Hi,

I've just discovered that one of my servers, running 9.02, has been hacked.
I'm not sure of the update level, because the hack is visible in the
administrator and prevents its use.

It's not the old h.cfm hack. I haven't been able to find any references to
what I'm seeing, but I hope someone else knows what's up.

I have not seen any obvious problems caused in the sites delivered from the
server. It became evident when I tried to log in to the admin today to
check on something.

The immediate symptoms are that an ad appears in an iframe below the CF
Admin login inputs; the username input label has been restyled and appears
to have a link behind it.

A recurring popup says The page at b1.zcxbtm.com says: WARNING, Your Java
version is outdated, have security risks, Please update now.

Naturally, none of this is visible in View Source. No reference to other
files and scripts. The View Source is identical to one on a non-hacked
server.

The CF Admin is not publicly accessible - at least not normally. I can see
that a site was added and used temporarily which had a virtual directory
pointing to the admin, most likely one created by running the config tool.
That site is dead now, but it could easily have been a vector at one time.

The CF service _is_ running under the System account. I know this is bad
practice, but I didn't set up the server.

Any suggestions for troubleshooting this would be greatly appreciated. And
I'll certainly be happy provide any other details I can.

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Re: FW: CF9.02 administrator hack


Hi Mark,

On Wed, Nov 12, 2014 at 12:33 PM, Mark A Kruger mkru...@cfwebtools.com
wrote:

 My one questions is you say that view source is identical from a hacked and
 non hacked  server - that seems odd.


Extremely. That's why I mentioned it. I both looked through the source in a
browser and saved it and did a file compare locally. There was no evidence
of any additional scripting.



 This one uses the missing file handler:

 http://www.coldfusionmuse.com/index.cfm/2013/12/5/attack.vector.missing.temp
 late.handler


Thanks. Yes, I had already read that post, and now I've read the second.

But it doesn't seem to have been the former (I'll explain in a minute), and
while the latter situation is possible (there is one area where an image
could be uploaded to a web-accessible directory), the form is secured by an
admin login. So it's less likely.

What's terminally weird is that I just remoted in to the server again, and
the problem has disappeared. I know that doesn't mean it's gone, but the
admin is appearing, and working, cleanly now. And the missing template
handler input field is blank, so I guess it wasn't that particular attack.

And the only change I had made was to delete the old, temporary site I
mentioned, the one that did accidentally have a virtual directory for
CFIDE, from IIS. The site was not running, and hadn't been for a long time.
But it did still exist as an entry in IIS.

I can't imagine how that change would make a difference. It's just the only
change that was made between my two logins.

Obviously, I still hope someone has seen a similar attack, because I'm not
all that relieved that the symptom has gone away.

Thanks for your suggestions. If I need more formal help, I'll definitely
yell.



 and can alter files.

 This one that uses the (bad) practice of moving files to a URL accessible
 folder before checking them - or relying JUST on the file extension.

 http://www.coldfusionmuse.com/index.cfm/2009/9/18/script.insertion.attack.ve
 ctor

 Either one of these is capable of producing an iframe or adding content to
 files etc. Of course there are others - bad news I know. Sometimes the best
 solution in these cases (the one that gives you the most reassurance and
 least amount of time spent) is to reinstall on a pristine server - from a
 repo if you have it.

 -Mark

 P.S. let CFWT know if you need formal help on this.

 Mark Kruger - CFG
 CF Webtools
 www.cfwebtools.com
 www.coldfusionmuse.com
 O: 402.932.3318
 E: mkru...@cfwebtools.com
 Skype: markakruger



 -Original Message-
 From: Tom McNeer [mailto:tmcn...@gmail.com]
 Sent: Wednesday, November 12, 2014 10:40 AM
 To: cf-talk
 Subject: CF9.02 administrator hack


 Hi,

 I've just discovered that one of my servers, running 9.02, has been hacked.
 I'm not sure of the update level, because the hack is visible in the
 administrator and prevents its use.

 It's not the old h.cfm hack. I haven't been able to find any references to
 what I'm seeing, but I hope someone else knows what's up.

 I have not seen any obvious problems caused in the sites delivered from the
 server. It became evident when I tried to log in to the admin today to
 check on something.

 The immediate symptoms are that an ad appears in an iframe below the CF
 Admin login inputs; the username input label has been restyled and appears
 to have a link behind it.

 A recurring popup says The page at b1.zcxbtm.com says: WARNING, Your Java
 version is outdated, have security risks, Please update now.

 Naturally, none of this is visible in View Source. No reference to other
 files and scripts. The View Source is identical to one on a non-hacked
 server.

 The CF Admin is not publicly accessible - at least not normally. I can see
 that a site was added and used temporarily which had a virtual directory
 pointing to the admin, most likely one created by running the config tool.
 That site is dead now, but it could easily have been a vector at one time.

 The CF service _is_ running under the System account. I know this is bad
 practice, but I didn't set up the server.

 Any suggestions for troubleshooting this would be greatly appreciated. And
 I'll certainly be happy provide any other details I can.

 --
 Thanks,

 Tom

 Tom McNeer
 MediumCool
 http://www.mediumcool.com
 1735 Johnson Road NE
 Atlanta, GA 30306
 404.589.0560




 

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

Re: FW: CF9.02 administrator hack


I appreciate all the suggestions - and I especially appreciate when you
step in, Dave.

Certainly, I'm considering a clean installation.

But as a followup: Dave's comment about the problem is almost certainly in
the browser itself or some other piece of malware installed on the client
brings up lots of other possibilities.

To be clear (since some other folks have misunderstood this), I can't say
that this hack appears *only* in the CF Admin login page, or only in the CF
Admin. I have the browser on the server set to the CF admin as a default,
because that's what I use the browser for - administering CF. So the hacks
appeared immediately after the browser was started and the first page
loaded -- which *happened* to be the CF Admin.

It's entirely possible, as Dave suggests, that the problem isn't related to
CF at all, now that we've discussed it.

That doesn't make it less of a problem. In fact, it means there are lots of
other possible vectors.

On Wed, Nov 12, 2014 at 3:29 PM,  wrote:


  One is that, while it doesn't show
 up in the view source for a given page, a JS library referenced in the
 page has been compromised to rewrite page content.

 Of course, this is quite possible in theory, however it would imply that
 the hacker has already hacked the server, and one could ask what he is
 still trying to hack.


 

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

Re: FW: CF9.02 administrator hack


One more followup: whatever this is, it isn't related to CF. I jumped to
the wrong conclusion.

The problem reappeared when I was in the CF admin page, long after I'd
logged on.

But then I opened another browser and purposely asked for a local page that
didn't exist. The IIS error page contained ads.

Again, this doesn't make me feel a whole lot better. But folks should know
that this is not a new CF attack.

On Wed, Nov 12, 2014 at 3:56 PM, Tom McNeer tmcn...@gmail.com wrote:

 I appreciate all the suggestions - and I especially appreciate when you
 step in, Dave.

 Certainly, I'm considering a clean installation.

 But as a followup: Dave's comment about the problem is almost certainly
 in the browser itself or some other piece of malware installed on the
 client brings up lots of other possibilities.

 To be clear (since some other folks have misunderstood this), I can't say
 that this hack appears *only* in the CF Admin login page, or only in the
 CF Admin. I have the browser on the server set to the CF admin as a
 default, because that's what I use the browser for - administering CF. So
 the hacks appeared immediately after the browser was started and the first
 page loaded -- which *happened* to be the CF Admin.

 It's entirely possible, as Dave suggests, that the problem isn't related
 to CF at all, now that we've discussed it.

 That doesn't make it less of a problem. In fact, it means there are lots
 of other possible vectors.

 On Wed, Nov 12, 2014 at 3:29 PM,  wrote:


  One is that, while it doesn't show
 up in the view source for a given page, a JS library referenced in the
 page has been compromised to rewrite page content.

 Of course, this is quite possible in theory, however it would imply that
 the hacker has already hacked the server, and one could ask what he is
 still trying to hack.


 

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

Re: FW: CF9.02 administrator hack


Wil,

Thanks. I'd already checked that. Mark chimed in earlier, and it's his post.

Pete,

Thanks. I was so concerned that the server was compromised in a way that
would affect its performance as a server, I hadn't had a chance to start
googling the text itself.

And Dave,

Thanks again. Yes, it's just a client-side problem. And Pete seems to have
identified the particular hack.

On Wed, Nov 12, 2014 at 5:13 PM, Dave Watts dwa...@figleaf.com wrote:


   One is that, while it doesn't show up in the view source for a given
 page, a JS library referenced in
   the page has been compromised to rewrite page content.
 
  Of course, this is quite possible in theory, however it would imply that
 the hacker has already hacked
  the server, and one could ask what he is still trying to hack.

 That's pretty obvious: the client. Lots of server hacks are pretty
 trivial in their effect on the server, and are ultimately aimed at
 compromising clients (whether the client is a browser or a search
 engine).

 Dave Watts, CTO, Fig Leaf Software
 1-202-527-9569
 http://www.figleaf.com/
 http://training.figleaf.com/

 Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business
 (SDVOSB) on GSA Schedule, and provides the highest caliber vendor-
 authorized instruction at our training centers, online, or onsite.

 

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

Java iterator problem

2013-12-04 Thread Tom McNeer


Hi,

I am attempting to use Google's libphonenumber library to find, match and
parse phone numbers within text strings.

I load the libphonenumber jar using Javaloader and create an instance of
the PhoneUtil class.

I create a test string of:

Here is one phone number (212) 555-1212 and here is a second 312-555-1212
and a third +1 404 555 1212

I then call PhoneUtil.findNumbers(testString,US). This should return
matches of phone numbers in pretty much any recognized US format within the
string.

The return from the findNumbers() method has an iterator() method. So it
seems to me I should be able to loop and dump the matched objects, with
something like:

cfloop condition=result.iterator().hasNext()
cfdump var=#result.iterator().next()#
/cfloop

However, this creates what appears to be an infinite loop. I'm guessing
it's because the loop isn't really looping through the iterator's
collection, but rather simply reading a static true from the hasNext()
initial value, and always dumping the first entry in the iterator's
collection.

Of course, I know so little about Java, I could be completely wrong.

But if one of you folks who understands better than I how to manipulate
Java within ColdFusion could point out the error of my ways, I'd certainly
appreciate it.



-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Re: Java iterator problem

2013-12-04 Thread Tom McNeer


And the winning answer is: Jon's method!!

I'm sure you're right about restarting the loop.

And thanks, Dave.



-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Re: HttpOnly session cookie setting ignored in CF10

2013-10-07 Thread Tom McNeer

Hi Dave,

Somehow, I missed your reply to this post earlier. Thanks very much for
stepping in.

I've tried your suggestions, and (assuming I'm changing the correct files),
the cookies are still httpOnly.

I made the changes shown in the StackOverflow article in
{CFDirectory}/cfusion/runtime/conf/web.xml (setting the http-only attribute
to false, of course). I also made the same changes in
{CFDirectory}/cfusion/wwwroot/WEB-INF/web.xml.

Neither had any effect: the cookies were still httpOnly.

I attempted to make the change described in your second link. I added a
useHttpOnly = false / attribute within the Context element in
{CFDirectory/cfusion/runtime/conf/context.xml. However, this prevented the
service from working for some reason. It seemed to break the connector in
some way, since the isapi-redirect.dll could not be found.

I can only guess that ColdFusion is overriding the Tomcat config - though
the use of httpOnly cookies is set to false in the CF Admin, and shows
correctly as var name=httpOnlySessionCookieboolean
value=false//var within neo-runtime.xml.

And I mentioned this earlier, but my Application.cfc has:
this.sessioncookie.httponly=false.

And finally, I have confirmed that other sites/applications on the same
server are returning httpOnly session cookies.

On Thu, Oct 3, 2013 at 2:16 PM, Dave Watts dwa...@figleaf.com wrote:

The problem appears to be that the session cookies are being set as
HttpOnly, and can't be accessed by the Flex call (just as they would fail
on an ajax call).

However, I am not able to get CF to send the cookies as HttpOnly=false. I
have unchecked both the Secure and HttpOnly options in the CF Admin. And
my
Application.cfc contains this.sessioncookie.httponly=false.

Yet despite this, and restarting the CF service just from fun, when I
access the dev site and examine the cookie content (in multiple
browsers),
the cookies (jsession, CFID and CFTOKEN) are all set as httpOnly=true.

Does anyone have any thoughts on this?

Assuming you're running CF 10 on Tomcat, you can probably make the
appropriate changes in Tomcat's configuration files. I haven't tried
to do this, but you might go here for a start:

http://stackoverflow.com/questions/17991090/tomcat-7-sessionid-cookie-disable-http-only-and-secure

http://tomcat.apache.org/migration-7.html#Session_cookie_configuration

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

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

Re: HttpOnly session cookie setting ignored in CF10

2013-10-07 Thread Tom McNeer


Not a dumb question at all. As dumb a mistake as that is, I've done it many
times.

However, in this case, I've cleared the cookies and checked multiple
browsers.

What has changed - and I should have mentioned this before - is that the
CFID and CFTOKEN cookies are no longer http-only. However, the jsessionid
is still http-only.

Guess I could turn off the use of jsessions, but obviously I'd rather not
do that.


On Mon, Oct 7, 2013 at 10:48 AM, Dave Watts dwa...@figleaf.com wrote:


  I've tried your suggestions, and (assuming I'm changing the correct
 files),
  the cookies are still httpOnly.

 This may be a dumb question, but have you cleared your browser's
 cookies before retesting?

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

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

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

Re: HttpOnly session cookie setting ignored in CF10

2013-10-07 Thread Tom McNeer


 Are you getting both when you visit a single application? That doesn't
 sound right. You should get one or the other.


I'm getting both. As far as I can remember, that's always been true.

I just confirmed that all three - CFID, CFTOKEN and JSESSIONID - are
returned from my live CF9 sites, too.

Doesn't make sense, but it's that way.

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

HttpOnly session cookie setting ignored in CF10

2013-10-03 Thread Tom McNeer


Hi,

I have a client application which uses a Flex front end. It runs on CF9,
but I have recently updated my dev server to CF10.

Part of the application allows files to be uploaded to the server. A
problem has existed for a long time that would cause an error when posting
a file upload to a CF routine because the session information, which is
normally passed correctly on data requests, is not passed on an upload.

The traditional workaround has been to include the jsessionid as a URL
param when calling the CF page. And this works fine for me on the live CF9
site.

But the same routine is failing on my dev server.

The problem appears to be that the session cookies are being set as
HttpOnly, and can't be accessed by the Flex call (just as they would fail
on an ajax call).

However, I am not able to get CF to send the cookies as HttpOnly=false. I
have unchecked both the Secure and HttpOnly options in the CF Admin. And my
Application.cfc contains this.sessioncookie.httponly=false.

Yet despite this, and restarting the CF service just from fun, when I
access the dev site and examine the cookie content (in multiple browsers),
the cookies (jsession, CFID and CFTOKEN) are all set as httpOnly=true.

Does anyone have any thoughts on this?

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Re: HttpOnly session cookie setting ignored in CF10

2013-10-03 Thread Tom McNeer


Mark,

Thanks for the reply.

Yes, that's the technique I've been using. The jsessionid is passed via
FlashVars to the SWF. And the jsessionid is then passed from the SWF as a
URL variable in the upload call.

This is what's working on the live CF9 site. But on my CF10 dev server, I'm
getting a 302 redirect, which is what occurred in CF9 before I learned to
pass the jsessionid with the request.

It's not the lack of the session information that's the problem (I don't
think). It's that regardless of my server and application settings, the
session cookies are set as HttpOnly, and thus the variable in the request
from the SWF is not recognized.

At least, that's my current theory.


On Thu, Oct 3, 2013 at 11:46 AM, Mark A Kruger mkru...@cfwebtools.comwrote:


 Tom,

 Can you pass the cookie into your SWF from the calling page using flash
 vars
 and JS?

 -mark

 -Original Message-
 From: Tom McNeer [mailto:tmcn...@gmail.com]
 Sent: Thursday, October 03, 2013 10:05 AM
 To: cf-talk
 Subject: HttpOnly session cookie setting ignored in CF10


 Hi,

 I have a client application which uses a Flex front end. It runs on CF9,
 but I have recently updated my dev server to CF10.

 Part of the application allows files to be uploaded to the server. A
 problem has existed for a long time that would cause an error when posting
 a file upload to a CF routine because the session information, which is
 normally passed correctly on data requests, is not passed on an upload.

 The traditional workaround has been to include the jsessionid as a URL
 param when calling the CF page. And this works fine for me on the live CF9
 site.

 But the same routine is failing on my dev server.

 The problem appears to be that the session cookies are being set as
 HttpOnly, and can't be accessed by the Flex call (just as they would fail
 on an ajax call).

 However, I am not able to get CF to send the cookies as HttpOnly=false. I
 have unchecked both the Secure and HttpOnly options in the CF Admin. And my
 Application.cfc contains this.sessioncookie.httponly=false.

 Yet despite this, and restarting the CF service just from fun, when I
 access the dev site and examine the cookie content (in multiple browsers),
 the cookies (jsession, CFID and CFTOKEN) are all set as httpOnly=true.

 Does anyone have any thoughts on this?

 --
 Thanks,

 Tom

 Tom McNeer
 MediumCool
 http://www.mediumcool.com
 1735 Johnson Road NE
 Atlanta, GA 30306
 404.589.0560




 

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

Re: 500 there is no web application configured to service your request

2013-08-15 Thread Tom McNeer


The service could be hung up and deliver the error you saw, but still
_appear_ to be running within the services panel.

Try restarting the service.


On Thu, Aug 15, 2013 at 1:55 PM, Monique Boea moni...@atlaref.org wrote:


 I checked in services and its running

 -Original Message-
 From: Russ Michaels [mailto:r...@michaels.me.uk]
 Sent: Thursday, August 15, 2013 1:43 PM
 To: cf-talk
 Subject: Re: 500 there is no web application configured to service your
 request


 usually means that cf is not running


 On Thu, Aug 15, 2013 at 6:34 PM, Monique Boea moni...@atlaref.org wrote:

 
  Hello All.
 
 
 
  My computer went through the automatic updates last night and since I
  get the following message:
 
 
 
 
  500  https://groups.google.com/d/topic/cfaussie/BoA4YjZRJbM there is
  no web application configured to service your request
 
 
 
 
  Thoughts?
 
 
 
 
 
 
 
 
 
 



 

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

Re: Database inserts seem to timeout

2013-05-16 Thread Tom McNeer


Sorry for the delay in replying to folks. I appreciate the responses, but
so far none have solved the problem.

Per Mike, I have placed each individual insert (there will be thousands of
them) in its own transaction. I have not specified a isolation level; if
someone thinks that could make a difference, please let me know.

I also set incredibly long timeouts (like 2000 minutes) on the database
connection, to test Russ's thought.

Neither changed anything. The routine stopped inserting records after about
the same amount of time.

Anyone else have any thoughts on what might be happening, or how I might
diagnose what's happening?




-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Re: Database inserts seem to timeout

2013-05-10 Thread Tom McNeer


@Chris,

Thanks for the thought. Placing things in a array would require me to wrap
existing routines with new code, rather than iterating over the routines
that create these records on a periodic basis. While that might be helpful,
I'd still like to know why the insert statements simply stop. It seems
unlikely that working through an array would be much faster.

It does make me think, however, that perhaps CF is failing at some point,
even though there's no error, and no longer making the calls to the
database. However, I'm not sure how to deterrnine this, since the request
never errors out or even returns.

@Russ,

Thanks. I'm aware that the DSN has a timeout; but unless I'm wrong, it's
completely different from a CF timeout. While the latter times out a
request that takes too long, my impression is that the Timeout setting on
the DSN is the number of minutes that CF will maintain an unused connection
to the datasource before kiiling the connection.

In this case, the connection is hardly unused. And even if the connection
were closed, CF should establish a new connection.



-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Difficulty in creating a dynamic query

2013-01-22 Thread Tom McNeer


Hi,

I need to build up a complex dynamic query statement. I have built methods
to add queryParam statements, and built up valid SQL.

If I do:

cfset sqlStatement = SELECT DISTINCT tableName.ID FROM tableName
LEFT OUTER JOIN secondTable ON tableName.ID=secondTable.fkID
WHERE ( tableName.clientID = 'D35DAF11-DCB2-4341-B26C-0D31325CD51B' AND
tableName.otherID IN
 (SELECT otherID FROM thirdTable WHERE (firstName LIKE
cfqueryparam cfsqltype=cf_sql_varchar value=%bar% / OR lastName LIKE
cfqueryparam cfsqltype=cf_sql_varchar value=%bar% /))
 ) /

And then do:

cfquery name=foo
#sqlStatement#
/cfquery


I get an error from the SQL Server driver that points to the first part of
the client ID - Incorrect syntax near 'D35DAF11' and a nextException
that says Incorrect syntax near ''.

Yet if I paste the above statement directly into the cfquery tag, it runs
perfectly.

Can anyone suggest where I'm going wrong, please? I suppose it could be a
single quotes problem of some sort. But certainly preserveSingleQuotes has
no affect. And if I wrap the first varchar (the clientID) in a queryParam
statement, it simply eliminates the first error and immediately shows the
Incorrect syntax near ''. error.

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Re: Difficulty in creating a dynamic query

2013-01-22 Thread Tom McNeer


Thanks for the replies. The answer to Steve, Bill and Matt is, the query is
far too dynamic to be built inside a cfquery without a million cfif or
switch/case statements.

In fact, that sort of thing is what we're trying to replace. The existing
routine is a cfquery tag that has stacks of specific logic, and it's
already almost unmaintainable. The current requirement means there will be
literally hundreds of possible combinations of parameters and operators.

I've built lots and lots of dynamic queries in the manner you suggest, and
I understand your concern. It just won't work in this case. Please take my
word for it.

On Tue, Jan 22, 2013 at 4:47 PM, Bill Moniz hydro.b...@gmail.com wrote:

 Coldfusion is just going to see #sqlStatement# as a block
 of literal text, so it will pass

  WHERE firstName LIKE cfqueryparam cfsqltype=cf_sql_varchar
 value=%bar% /

 into the DB exactly as written.


It appears you may well be correct. But that's exactly what I'm trying to
determine for certain. Do you know that this is the case, or are you
assuming it to be so?

Believe me, I'm not trying to be argumentative. I've combed the docs and
Googled extensively before asking my question here.

I suppose that's the key question: if a query statement containing
queryParam statements is output within a cfquery tag, does CF try to
interpret the tags, or simply pass the plain text to the driver?

It does seem as if Bill is correct, and CF simply passes the queryParam tag
as text to the driver. Can anyone confirm for certain this is true, or
point to anywhere in the docs this is dealt with?

Thanks to everyone for their suggestions.

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Re: Difficulty in creating a dynamic query

2013-01-22 Thread Tom McNeer


Hi Matt,


On Tue, Jan 22, 2013 at 5:22 PM, Matt Quackenbush quackfu...@gmail.comwrote:


 It is a fact that using cfqueryparam outside of cfquery will result in
 it being seen by CF as purely string text. It will never be executed as an
 actual cfqueryparam.


Good. Or rather, not good, but thanks for the confirmation.


 I obviously do not know what you're dealing with, specifically, but it
 sounds like you have a god query on your hands, and it really needs to be
 split up into separate methods/functionality. That is, of course, from the
 outside looking in. :-)


You're absolutely correct: it is a god query. Unfortunately, there's no
way to split it up in this case.

But thanks very much for your advice.


-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

activeLink(string)


I am using your cfLib component âactiveLink(string)â which works great.. 

Searching for a solution to the following question, and would appreciate any 
advice on this matter:
 
When the links are found, for example on a web page - I want to open each link 
to extract the data to an excel spreadsheet. I know how to extract the data to 
be displayed on a spreadsheet, although having problems opening a link. 

Is there a way to do this, and if so can you point me to an example?

Tom

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

Re: activeLink(string)


Have been using cfhttp although found activeLink simple to use. If there is a 
better way can you let me know?

Tom 

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

Re: activeLink(string)


I have sent him an email and got it from cfLib. You mentioned cfhttp - can you 
point me in the right direction? 

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

Re: activeLink(string)


I have look over this but could not workout how to achieve my issue.. 

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

Re: activeLink(string)


It is hyperlinks on a web page that once clicked opens data about a person, for 
example name, email, position, telephone - this is the link and thanks for your 
reply - http://rg.kcl.ac.uk/staffprofiles/?by=A 

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

Re: activeLink(string)


I have been looking at screen scraping using cfhttp and found something from 
cfLib that works just as good. I will solve it, so no problems and thanks for 
your reply 

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

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small


Hi Attila,
 
Thanks for your email and I should of been much clearer in my previous email.
Hi John,

Another questions - what if I wanted to extract information from a list of 
emails found on web (http://rg.kcl.ac.uk/staffprofiles/?by=A) and run some code 
that can extract details from each email link and store each details in a excel 
spreadsheet.
 
I know how to add a list of emails from a spreadsheet and send then to clients 
although not sure how to extract it from a website?
 
Hope that this make sense and if you need more information please let me know.
 
Thanks again for you help  advise.
 
Tom

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

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small


Sorry about the first part of my previous email...

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

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small


J.J,

Thanks for your replay. 

The main reason why I need to extract the information onto a spreadsheet is to 
save time (instead of doing it manually) - we work with several universities in 
the UK and store their information in our database - to promote our 
product/services.

You mentioned that although difficult (email address javascript protected) it 
is possible. 

Is there a way that I could obtain sample code of how to do this?

Tom

Tom,

You would use CFHTTP to get the HTML and then parse the data from there.

I will say that the website you sent is trying its best for you not to
do what you are doing. If you look in the HTML it clearly has the
email address javascript protected which doesn't mean you can't do
it, it just means it is going to be a little more difficult.

Why can't you just contact the college for the information? If they
aren't going to give it to you then maybe you don't need it :-)


-J.J.
 

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

search email list to extract data in spreadsheet

2013-01-17 Thread Tom Small


Hi,

Can someone advise me on the following..

I want to know the best way to search through a list of emails and extract the 
information (e.g. first, address, position, address, etc) into an excel 
spreadsheet.

Appreciate any advice on this issue.

Tom

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

Re: search email list to extract data in spreadsheet

2013-01-17 Thread Tom Small


Hi John,

Thanks for the link.

Tom 

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

Re: ORM Relationship Issue

2012-11-27 Thread Tom McNeer


Hi Jeff,

You've got the fkcolumn thing backwards.

property name=Owner fieldtype=many-to-one cfc=com.user.User
 fkcolumn=idUsers missingRowIgnored=true;


In your Client object, the fkcolumn for the Owner is the column/property
within the Client which references the primary key of the Owner/User record.

So Hibernate is looking for the column in the fkcolumn attribute on your
Client object, not the User. And obviously, it's not there.

Try 'fkcolumn=idOwner.'



-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Re: Progressbar interacting with server

2012-07-08 Thread Tom Small


Hi Guust

Thanks for your reply although I am currently using ColdFusion 9 and noticed - 
WebSocket in point-to-point communication is developed for ColdFusion 10.

If this is the case, is there an alternative that can work with the version 
that I am using?

Tom 


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

Progressbar interacting with server

2012-07-07 Thread Tom Small


Hi

I have a Progressbar that is developed with Ext JS 4 and want to know how to 
write ColdFusion server code that can keep track of the progress and pass it 
back to the progress bar..

Tom


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

Re: Software Project Development Process


Hi Mark

Due to the size of the project we were looking an alternative UML diagramming
tools. A lot of people have suggested reviewing Agile to management a large 
software project. 


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

Re: Software Project Development Process


Hi Will, 

Thanks and will take a look although it might not be suitable for a large 
project. 


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

Combo comparison operator


Hi 

I have a search toolbar that work OK, although now I want to add a Combobox 
comparison operator (AND/OR/NOT) â so when a user selects, for example AND it 
can filter the data (stored in MySQL db) based on the data in the grid. 

Can someone point my in the right direction and have been searching for an 
examples although so far no luck.

Tom 


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

Re: Software Project Development Process


Hi Mark

I initially wanted to know if there was an alternative to UML for a large 
project, and although we have reviewed Argile, we will be using UML.

We are using MVC framework and the UI designs can be modelled using UML (design 
pattern). Sorry if my initial post caused any confusion.

Tom 


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

Software Project Development Process


Hi 

We are about the start our first large project, and in the past I have with 
have been using UML although in my opinion it has its limitations and is not 
flexible for ColdFusion and ExtJS 4. 

Could anyone advise me on a standardize-general purpose modelling tool that can 
be used for ColdFusion/ ExtJS 4 project?

Thanks

Tom 


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

Re: Software Project Development Process


Hi Russ I will give it a try 


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

Re: Software Project Development Process


Hi Russ 

Thanks for the email although 'pencil' does not offer the flexibly that we 
require. 


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

Re: Software Project Development Process


Hi Cameron

Thanks for your email greatly appreciated. 


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

Re: Software Project Development Process


We use UML for object oriented analysis and design.. 


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

Re: Anyone use/used Flinthosts in the UK?


We used flinthost in the past although had problems with bandwidth and customer 
service. Tested various hosting companies and decided to moved to Rackspace and 
have been with them for over 5 years.

Tom


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

Array conversion issue

2012-05-18 Thread Tom Rigas


Hello friends,

I am trying (in Javascript an Coldfusion) to convert: 
{val1:member,val2:book,val3:journal,val4:new_member,val5:cds},
 into this: { member,book,journal,new_member,cds}

Notice that I am trying to eliminate quotes.

Is it possible to achieve that? How can I do it?

Thanks
Tom

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

Array conversion issue

2012-05-18 Thread Tom Rigas


Hello friends,

I am trying (in Javascript an Coldfusion) to convert: 
{val1:member,val2:book,val3:journal,val4:new_member,val5:cds},
 into this: { member,book,journal,new_member,cds}

Notice that I am trying to eliminate quotes.

Is it possible to achieve that? How can I do it?

Thanks
Tom

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

cannot convert the value x to a boolean

2012-04-30 Thread Tom Small


Hi, I have a loop that searches for keywords, although when I search for 
'string' values get an error: cannot convert the value x to a boolean.

If I remove the statement: u.isactive = cfqueryparam 
value=#IIF(arguments.query, 1, 0)# then only finds 'string' keywords with no 
errors.

If I run the code below it only finds 'boolean' keywords and when I enter a 
'string' value produces the error above.

This is a snippet of my code:

cfloop list=#arguments.query# index=keyword delimiters= ,;
WHERE u.email LIKE cfqueryparam value=%#arguments.query#% OR
  r.rolename LIKE cfqueryparam value=%#arguments.query#% OR  
  u.isactive = cfqueryparam value=#IIF(arguments.query, 1, 0)# 
/cfloop 

Thanks 

Tom 

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

Re: cannot convert the value x to a boolean

2012-04-30 Thread Tom Small


I see two issues. First, you are trying arguments.query like a list,
but you don't use the value. Ie, you said, loop over it and put the
value in keyword, but your code never uses it.

Secondly - you seem to be wanting to treat the keywords as booleans.
That's not going to work.




Hi Ray thanks for the reply. 

Can you tell me how I should treat the boolean, and do I need to place the 
boolean within an cfif statement?

Appreciate your advice.

Tom 

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

Re: cannot convert the value x to a boolean

2012-04-30 Thread Tom Small


You can check to see if a value can be treated as a boolean by
checking isBoolean().




Hi Ray 

thanks 

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

Re: Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

2012-01-23 Thread Tom Small


Hi Andrew I have modified my grid to a live-search-grid 

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

Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

2012-01-22 Thread Tom Small


I am trying to replace my grid with 'Live-Search-Grid' plugin. Would appreciate 
some help!

Thanks 

Tom 

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

Re: Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

2012-01-22 Thread Tom Small


Ok Andrew thanks, and have posted the same question on extjs forum. Is it 
possible for me to send you a snippet of my code? Thanks Tom 

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

Re: Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

2012-01-22 Thread Tom Small


// configure whether filter query is encoded or not (initially)
var encode = false;

// configure whether filtering is performed locally or remotely (initially)
var local = true;

var filters = {
ftype: 'filters',
   
// encode and local configuration options defined previously for easier 
reuse
encode: encode, // json encode the filter query
local: local,   // defaults to false (remote filtering)

filters: [{//id filter
type: 'numeric',
dataIndex: 'USER_PK'
}, 
{//email filter
type: 'string',
dataIndex: 'EMAIL',

}, 
{//is active filter
type: 'boolean',
dataIndex: 'ISACTIVE'
}, 
{//user role id filter
type: 'numeric',
dataIndex: 'USERROLEID'
}]
};


Ext.define('MyApp.view.ui.UsersDetail', {
extend: 'Ext.panel.Panel',
style: margin: 0px auto 0px auto;, // center the form panel
frame: true,
height: 450,
width: 410,
autoScroll: true,
layout: {//panel layout
align: 'stretch',
type: 'vbox'
},
title: 'span class=gridPanelTextUsers/span',

initComponent: function() {
var me = this;  

Ext.applyIf(me, {
items: [
{//grid panel data columns
xtype: 'gridpanel',
itemId: 'grid',
store: 'UserStore',
features: [filters],// filter-grid 
plugin feature
flex: 1,
columns: [
{//id column
xtype: 'numbercolumn',
width: 40,
dataIndex: 'USER_PK',
filter: {type: 'int'},
format: 0
},
{//email column
xtype: 'gridcolumn',
width: 165,
dataIndex: 'EMAIL',
filter: {type: 'string',test: 
/^{0}/},//https://github.com/nene/filter-row
text: 'Email'
},
{//is active column
xtype: 'booleancolumn',
width: 80,
dataIndex: 'ISACTIVE',
filter: {type: 'boolean'},
text: 'Is Active'
},
{//user role id column
xtype: 'numbercolumn',
width: 90,
dataIndex: 'USERROLEID',
filter: {type: 'int'},
text: 'Role',
format: 0
}
],
 
viewConfig: {

}
}
],


dockedItems: [
{//button toolbar
xtype: 'toolbar',
flex: 1,
dock: 'top',
items: [
{//add button
xtype: 'button',
id:'addbutton',
iconCls: 'addIcon',
text: 'Add',
handler: function(){
alert('Add button clicked!');
}
},
{//edit button
xtype: 'button',
id:'editbutton',
iconCls: 'editIcon',
text: 'Edit',
handler: function(){
 alert('Edit button clicked!');
}
},
{//delete button
xtype: 'button',
id:'deletebutton',
iconCls: 'deleteIcon',
text: 'Delete',
handler: function(){
 alert('Delete button clicked!');
}
},
{
xtype: 'tbseparator'
},
{//import button
xtype: 'button',
id:'importbutton',
iconCls: 'importIcon',
text: 'Import',

Grid filter textbox

2012-01-21 Thread Tom Small


Hi I am attempting to search for data in a grid via a textfield. Have 
downloaded a plugin which works in 
part(http://www.learnsomethings.com/2011/10/12/extjs4-clearable-grid-filter-textbox-that-uses-delayedtask-to-avoid-sending-data-on-every-keypress/#comment-2022),
 although now I need a plug-in that can search row(s) in a grid? Have look 
online and can not find anything that I can get my head around, as I am new the 
extjs4 and coldfusion.

Thanks

Tom 

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

Re: Grid filter textbox

2012-01-21 Thread Tom Small


Hi Andrew thanks for the reply and will take a look on extjs forum 

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

Re: Grid filter textbox

2012-01-21 Thread Tom Small


Hi Andrew, I have looked on ext forums and attempted to apply the examples to 
my grid, although there are no errors it still is not searching. Have followed 
a post (see below) and although it works in part, I can not make it search a 
row in the grid. I think that problems I am having is with applying the 
following:

// Main viewport
   var viewport = Ext.create('Ext.Viewport', {
  id: 'main_viewport',
  layout: 'border',
  items: [
  Ext.create('Ext.Component', {
   region: 'north',
   height: 25, 
   autoEl: {
tag: 'div',
html:'h1 style=margin-left:10px; margin-top:6px; 
font-weight:bold; font-family:Arial, Helvetica, sans-serifFrederick County 
MD, Public Schools Check Registers/h1'
   }
  }),
check_register_grid
]
});
check_register_grid.getStore().setExtraParam('sort','check_pay_to');
check_register_grid.getStore().setExtraParam('dir','ASC');
check_register_grid.store.loadPage(1);
});

My view is define as: Ext.define('MyApp.view.ui.UsersDetail', {extend: 
'Ext.panel.Panel',initComponent: function() {var me = this; Ext.applyIf(me, 
{items: [.

Would appreciate any help on this issue,.

Thanks 
Tom 

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

Re: Filter row plugin

2012-01-17 Thread Tom Small


Steve thanks for pointing me in the right direction 

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

Re: Filter row plugin


Hi Andrew, thought I had a solution to the flier grid issue although can not 
solve the problem. I am using ext designer to generate the code (class) to 
filter columns in the grid and have attempted to follow various examples, 
although having no luck so far. Is it possible for me to send you a snippet of 
my code? As always would appreciate any help on this matter. I am getting an 
error; grid.getColumnModel is not a function
[Break On This Error] var cm = grid.getColumnModel();

the example I have been following is: https://github.com/nene/filter-row  

Thanks 
Tom 

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

Re: Filter row plugin


Hi Andrew, thanks for the advice also I think the example code I am using is 
for ext3 and not 4, and I believe the columnModel approach was removed, maybe 
that is why I am getting issues. I will send a snippet of my code the your 
email address, if that is OK? In the meantime will try to work on the issue.

Thanks Tom 

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

Re: Filter row plugin


Thanks for the advice 

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

Re: Filter row plugin


grid.selectionModel() is produces an error 

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

Re: Filter row plugin

2012-01-15 Thread Tom Small


Thanks Andrew I have found a solution on the forum 

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

Filter row plugin

2012-01-14 Thread Tom Small


Hi, I have built a grid via ext designer and want to know if there is a plugin 
that will enable that data in the grid to be filtered... Have attempted to 
follow various examples although they do not represent the code as a class. I 
would appreciate any help.

Thanks 

Tom 

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

Convert queries for ext


Hi, I am using a cfc that converts queries to ext grid. When I run the code 
keep getting error. Would appreciate any help on this issue:
 
'Unable to parse the JSON returned by the server: You're trying to decode an 
invalid JSON String:â 

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

Re: Convert queries for ext


Hi Andrew this is my store and ConvertQueriesForExt.cfc:

Ext.define('MyApp.store.UserStore', {
extend: 'Ext.data.Store',

constructor: function(cfg) {
var me = this;
cfg = cfg || {};
me.callParent([Ext.apply({
autoLoad: true,
storeId: 'UserStore',
proxy: {
type: 'ajax',
url: '/orm_2/view/user/app/store/ConvertQueriesForExt.cfc',
reader: {
type: 'json',
idProperty: 'name',
root: 'users'
}
},
fields: [
{
name: 'user_pk',
allowBlank:false,
type: 'int'
},
{
name: 'email',
sortType: 'asText',
type: 'string'
},
{
name: 'isactive',
type: 'boolean'
},
{
name: 'userroleid',
sortType: 'asInt',
type: 'int'
}
]
}, cfg)]);
}
});



cfcomponent output=false

cffunction name=getUsers access=remote returnformat=json output=false 
hint=Gets list/detail of posts
 cfargument name=limit type=numeric required=no
 cfargument name=start type=numeric required=no
 cfargument name=sort required=no type=string
 
cfset var userData = 
  
cfquery name=userData datasource=orm_2
   SELECT user_pk,email,isactive,userroleid
   FROM users
   ORDER BY #arguments.sort#
 /cfquery
 
cfset clist = 'user_pk,email,isactive,userroleid'
 cfset arrayRecords = 
convertQueryToExtJSON(userData,clist,arguments.limit,arguments.start)
 cfset s = {rows=arrayRecords,dataset=#userData.recordcount#}
 cfreturn s /
/cffunction



cffunction name=ConvertQueryToExtJSON returntype=any access=public
  cfargument name=query type=query required=yes /
  cfargument name=clist type=string required=yes /
  cfargument name=limit type=numeric required=yes /
  cfargument name=start type=numeric required=yes /
  cfscript
   arrayRecords = ArrayNew(1);
   if(arguments.start==0) {
counter = 1;
   }
   else {
counter = arguments.start;
   }
   for(i=1;i=arguments.limit;i++)  {
strResults = structNew();
for(x=1;x=listLen(clist);x++) {
 strResults[ucase(listGetAt(clist,x))] = 
query[listGetAt(clist,x)][counter];
}
arrayRecords[i] = strResults;
counter = counter+1;
  }
  return arrayRecords;
 /cfscript

/cffunction
/cfcomponent

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

Re: Convert queries for ext


Hi Andrew thanks for your reply and it is now return json format although my 
problem now is the data not shown in the grid. I would appreciate any help...

{ROWS:[{EMAIL:s@gosh.org.uk,USER_PK:1,ISACTIVE:1,USERROLEID:1}],DATASET:1}

Thanks 

Tom 

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

Re: Convert queries for ext


Hi Matt, can you please simplify your reply as I am new to extjs and coldfusion.

Thanks
Tom 

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

Re: Convert queries for ext


Hi Andrews, here is the code for my grid. Thanks Tom

---
Ext.define('MyApp.view.ui.UsersDetail', {
extend: 'Ext.panel.Panel',
style: margin: 0px auto 0px auto;, // center the form panel
frame: true,
height: 450,
width: 410,
autoScroll: true,
layout: {
align: 'stretch',
type: 'vbox'
},
title: 'span class=gridPanelTextUsers/span',

initComponent: function() {
var me = this;

Ext.applyIf(me, {
items: [
{
xtype: 'gridpanel',
itemId: 'grid',
store: 'UserStore',
flex: 1,
columns: [
{
xtype: 'numbercolumn',
width: 40,
dataIndex: 'user_pk',
format: 0
},
{
xtype: 'gridcolumn',
width: 165,
dataIndex: 'email',
text: 'Email'
},
{
xtype: 'booleancolumn',
width: 80,
dataIndex: 'isactive',
text: 'Is Active'
},
{
xtype: 'numbercolumn',
width: 90,
dataIndex: 'userroleid',
text: 'Role',
format: 0
}
],
viewConfig: {

}
}
],
dockedItems: [
{
xtype: 'toolbar',
flex: 1,
dock: 'top',
items: [
{
xtype: 'button',
iconCls: 'addIcon',
text: 'Add'
},
{
xtype: 'button',
iconCls: 'editIcon',
text: 'Edit'
},
{
xtype: 'button',
iconCls: 'deleteIcon',
text: 'Delete'
},
{
xtype: 'tbseparator'
},
{
xtype: 'button',
iconCls: 'importIcon',
text: 'Import'
},
{
xtype: 'tbseparator'
},
{
xtype: 'button',
iconCls: 'exportIcon',
text: 'Export'
}
]
},
{
xtype: 'toolbar',
flex: 1,
dock: 'top',
items: [
{
xtype: 'textfield',
width: 323
},
{
xtype: 'tbspacer'
}
]
}
]
});

me.callParent(arguments);
}
}); 

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

Re: Convert queries for ext


Hi Andrew, thanks for your help 

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

Re: Convert queries for ext


Hi Andrew,

Problem solved and thanks for all your help and support.

Tom

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

Re: Convert queries for ext


Hi Matt,

Problem solved and thanks for all your help and support.

Tom 

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

Re: Convert queries for ext


Hi Steve,

Problem solved and thanks for all your help and support.

Tom 

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

Re: Convert php to cfm

2012-01-11 Thread Tom Small


Hi Andrew, I am using ColdFusion9 and have downloaded json (serialize and 
deserialize) from cflibs. Although this may sound naive, can you tell me where 
to include both files, also how to cfoutput it via json to my datastore  as I 
am a newbie... 

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

Re: extjs4 designer

2012-01-11 Thread Tom Small


Hi Steve, thanks for the link

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

cfquery and json


Hi I am new to coldfusion 9 and extjs 4 and like to know how to pass a cfquery 
to a mysql table, and then covert the data to json to populate a grid..

Would appreciate some help on this matter also if there are any tutorials for 
newbies.

Thanks 

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

Re: cfquery and json


Thanks for your assistance 

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

Extjs4


Hi, I have built a grid panel via extjs4 and want to link the data store to a 
mysql table, which is stored locally on my machine. Is there any examples for 
newbie that will walk me through how to achieve this?

thanks 

Tom 

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

extjs4 designer


Hi, I have built a grid panel via extjs designer and want to link the data 
store to a 
mysql table, which is stored locally on my machine. Is there any examples for 
newbie that will walk me through how to achieve this?

thanks 

Tom 

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

Convert php to cfm


Hi, I need to convert php to coldfusion. Would appreciate some help, thanks

?php
#First we include our credentials file
# FileName=connect.php
$hostname = localhost;
$database = nimsoftslmdev;
$username = root;
$password = xxx;

#And now we connect to the database
//connection String

//connection String
$con = mysql_connect($hostname, $username, $password) or die('Could not 
connect: ' . mysql_error());
//select database
mysql_select_db($database, $con);
//Select The database
$bool = mysql_select_db($database, $con);
if ($bool === False){
print can't find $database;
}


$start = ($_REQUEST[start] == null)? 0 : $_REQUEST[start];
$limit = ($_REQUEST[limit] == null)? 200 : $_REQUEST[limit];

// Gather all pending requests
$query = SELECT
nimid,
level,
message,
source
FROM nas_alarms ;

$query .=  ORDER BY level ASC ;
$query .=  LIMIT .$start.,.$limit;

$result = mysql_query($query, $con); 

// Here we do the count
$query_c = SELECT
nimid,
level,
message,
source
FROM nas_alarms ;

//get total
$count_result = mysql_query($query_c, $con);
$total = mysql_num_rows($count_result);

if (mysql_num_rows($result)  0){
while($obj = mysql_fetch_object($result))
{
$arr[] = $obj;
}

// Now create the json array to be sent to our datastore

$myData = array('myInventory' = $arr, 'totalCount' = $total);
echo json_encode($myData);
return;
exit();

}

else { // If no requests found, we return nothing

$myData = array('myInventory' = '', 'totalCount' = '0');
echo json_encode($myData);
return;
exit();

}

? 

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

Re: Convert php to cfm