Re: Moving to Railo

[Tom McNeer]

Seems likely that you may need to modify your manager code - not for Railo
specifically, but rather because of the use of Tomcat, which would be true
for CF10/11, too. There are docs and blog posts available relative to
creating a new site in Railo.

On Tue, Dec 23, 2014 at 4:08 PM, Maureen  wrote:
>
>
> Railo is excellent.  The community around Railo is excellent.  The
> Google group for Railo, which I think you have already found is one of
> the best resources for support of a product that I have experienced.
>
> https://groups.google.com/forum/#!forum/railo
>
> The installers are out there, including ones on Bitnami.
>
> If you are not committed 100% to your new host, I would suggest you
> check out Viviotech.net - without a doubt the best hosting company on
> earth.
>
>
>
> On Tue, Dec 23, 2014 at 3:49 PM, Mik Muller  wrote:
> >
> > Hey all,
> >
> > I'm moving my server to a new company who does not offer CF licenses on
> a monthly basis, though they do have some CF experience. The server they
> offered me was too good to pass up*, so I'm going for it.
> >
> > I've been using CF9, and rather than buy a new CF license outright
> (ouch), I thought I'd look into Railo, and am looking to the community for
> advice.
> >
> > Anyone here using Railo and have recommendations in terms of
> installation and configuration?  I've been to GetRailo.org and com and find
> the documentation to be a little paltry, especially regarding the
> installation and the best configuration for various situations.
> >
> > I will be hosting only my own websites, about 210 so far, broken down
> into four CF applications, ie; there are 185 sites running one application;
> 10 running another, etc.  I also have about a dozen static HTML sites, so
> I'll need IIS on the box.
> >
> > I've written a manager app for two of the applications to create the IIS
> instance, the folders, the database, the DSN, and the DNS. My guess is I'll
> have to add some code to support the Railo architecture... or maybe not. In
> either case, most new websites, and soon all of them, will be created on my
> server by one of these manager apps.
> >
> > Any advice would be appreciated.
> >
> > Thanks,
> >
> > Mik
> >
> >
> > * Two Hex-Core processors, 192GB RAM, 1.8TB SAS RAID5 HD
> >
> >
> >
> > 
> > Michael Muller
> > Admin, MontagueMA.net Website
> > ...a project of MontagueWebWorks.com
> > (413) 320-5336
> > http://www.MontagueMA.net
> >
> > Eschew Obfuscation
> >
> >
> >
> >
> >
> >
>
> 

~|
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:359874
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: need a host

[Tom McNeer]

+1 for KickAss. They've always been very responsive for me.

On Thu, Nov 20, 2014 at 9:39 AM, Rick Faircloth 
wrote:

>
> I've always gotten quick, personal attention to any issues that may arise.
>
>
> On 11/19/2014 9:27 PM, Rick Eidson wrote:
> > I posted about this last week... Yes, you are right. It seems they have
> > become a bit drone like. Before with a tech problem things seems more
> > personable.
> >
> >
> >
> > Rick
> >
> > -Original Message-
> > From: Rick Faircloth [mailto:r...@whitestonemedia.com]
> > Sent: Wednesday, November 19, 2014 7:41 PM
> > To: cf-talk
> > Subject: Re: need a host
> >
> >
> > KickAssVPS.com
> >
> > Been with them for years; very little trouble; always quick with support.
> >
> > They even tailor VPS's for me.
> >
> >
> > On 11/19/2014 7:49 PM, Brian Thornton wrote:
> >> So sorry to bring up an old thread. BUt things have changed at Hostek.
> >> Simple common sense have changed into support phone scripts,
> >> unresponsive tickets, beuracy over account confirmatino over the
> >> phone.
> >>
> >> Some examples:
> >> EXAMPLE 1:
> >> Me: "Hi Can you make this change on the account since the online
> >> portal is not working using the username and password you provided?"
> >> Hostek Support: "Yes as long as you answer your secret question with
> >> the correct answer."
> >> Me: "Sure what is the question that you'd like me to answer?"
> >> Hostek: "Sir due to confidentiality, I cant give you the question or
> >> the answer but you can login online to get the question."
> >> Me: "I understand that but I'm calling since the autogenerated
> >> password you just created and emailed me isn't valid this cannot login
> >> to the portal. If I can't login how would I get the question or the
> >> answer and if I could login I wouldn't be calling you."
> >> Hostek: "Well sir, if you like you can login and change your password
> >> if you like."
> >>
> >> or EXAMPLE 2:
> >> Me: When you setup a VPS server for a client you gave them a username
> >> and password for RDS to the machine, however your policy is to block
> >> all access unless the IP address is whitelisted. What is the password
> >> to login to add an IPto the whitelist table?"
> >> Hostek: "Sorry sir, that's a different password that you will need to
> >> login with. I don't have access to it, to allow you to reset it, or to
> >> create a new one. You will need to login to change it."
> >>
> >> etc etc..
> >>
> >> So kudos to Hostek for being CF tailored, but folks they have become
> > drones.
> >> I recommend the others found at:
> >> http://www.adobe.com/uk/products/coldfusion-family/hosting-partners.ht
> >> ml
> >>
> >> On Sun, Jul 20, 2014 at 5:19 PM, Stephen Hait 
> > wrote:
> >>> Just switched a client from Newtek to Hostek and everyone's a lot
> > happier.
> >>> CF11, though, not sure about CF9.
> >>>
> >>>
> >>> On Sun, Jul 20, 2014 at 5:09 PM, Matthew Smith
> >>> 
> >>> wrote:
> >>>
>  not newtek, no hostmedia.co.uk(no mssql), no viviotek.  Any
> suggestions?
> 
>  Need cf 9 and ms sql.  Thanks.
> 
>  --
>  Regards,
>  chedder is bedder
> 
> 
> 
> >
> >
> >
>
> 

~|
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:359689
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Sending SMS

[Tom McNeer]

Like Pete, I've used Twilio's services, though it's most useful if you're
also receiving SMS messages. It's been a long time since i used them, but
if you decide to do so, I probably have some old code that might get you
started.

But if you're only sending, never receiving, the email-to-text option is
simpler.

On Wed, Nov 19, 2014 at 9:16 AM, Pete Freitag  wrote:

>
> I've worked quite a bit with Twilio for sending and receiving text messages
> in CF: https://www.twilio.com/ they have a REST api, that is pretty easy
> to
> use: https://www.twilio.com/docs/api/rest/sending-messages
>
> --
> Pete Freitag - Adobe Community Professional
> http://foundeo.com/ - ColdFusion Consulting & Products
> http://hackmycf.com - Is your ColdFusion Server Secure?
> http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10
> minutes
>
>
> On Tue, Nov 18, 2014 at 6:09 PM, Rick Sanders  wrote:
>
> >
> > Hey guys,
> >
> > Does anyone know a service I can use for sending sms messages from cold
> > fusion? I want to make an app that notifies someone by sms when their
> > product is ready.
> >
> > Kind Regards,
> >
> > Rick Sanders
> >
> > Canada:  USA:
> > 171 Main St   1205 N. Second Ave
> > Dartmouth, NS  Siler City, NC
> > T: 902-401-7689   T: 919-799-9076
> > W: www.webenergy.ca  W:
> > www.webenergyusa.com
> >
> >
> >
> >
>
> 

~|
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:359678
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9.02 administrator hack

[Tom McNeer]

Wil - understood. I just appreciate the fact that so many people are
willing to help.

And I apologize for panicking over what was just a fairly simple local
virus (now removed).

But when you're working on a server that runs critical sites for one of
your clients, and you start seeing injections into your CF admin login
page, you get a tiny bit concerned. Especially when you've tried to follow
as many of Pete's lockdown guide recommendations as you could.

Thanks to everyone, and sorry for the trouble.

On Wed, Nov 12, 2014 at 6:19 PM, Wil Genovese  wrote:

>
> Tom - I missed the email that Mark sent with that same blog post (which
> was written by me). Mark and I tag team this stuff regularly.
>
>
>
>
> Wil Genovese
> Sr. Web Application Developer/
> Systems Administrator
> CF Webtools
> www.cfwebtools.com
>
> wilg...@trunkful.com
> www.trunkful.com
>
> On Nov 12, 2014, at 4:27 PM, Tom McNeer  wrote:
>
> >
> > 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  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:359640
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

[Tom McNeer]

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  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

Re: FW: CF9.02 administrator hack

[Tom McNeer]

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  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

[Tom McNeer]

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

[Tom McNeer]

Hi Mark,

On Wed, Nov 12, 2014 at 12:33 PM, Mark A Kruger 
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

CF9.02 administrator hack

[Tom McNeer]

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: Java iterator problem

[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

Java iterator problem

[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:





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: HttpOnly session cookie setting ignored in CF10

[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

Re: HttpOnly session cookie setting ignored in CF10

[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  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

[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
 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  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  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

[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 wrote:

>
> 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

HttpOnly session cookie setting ignored in CF10

[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: 500 there is no web application configured to service your request

[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  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  wrote:
>
> >
> > Hello All.
> >
> >
> >
> > My computer went through the automatic updates last night and since I
> > get the following message:
> >
> >
> >
> >
> > 500   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

[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

[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

Re: Difficulty in creating a dynamic query

[Tom McNeer]

Hi Matt,


On Tue, Jan 22, 2013 at 5:22 PM, Matt Quackenbush wrote:

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

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

Re: Difficulty in creating a dynamic query

[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  wrote:

> Coldfusion is just going to see #sqlStatement# as a block
> of literal text, so it will pass
>
>  WHERE firstName LIKE  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

Difficulty in creating a dynamic query

[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:

 OR lastName LIKE
))
 )" />

And then do:


#sqlStatement#



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: activeLink(string)

[Tom Small]

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: activeLink(string)

[Tom Small]

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)

[Tom Small]

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)

[Tom Small]

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)

[Tom Small]

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

activeLink(string)

[Tom Small]

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: search email list to extract data in spreadsheet

[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

Re: search email list to extract data in spreadsheet

[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

[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

[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

search email list to extract data in spreadsheet

[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: ORM Relationship Issue

[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

[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

[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

[Tom Small]

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

Combo comparison operator

[Tom Small]

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

[Tom Small]

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

Re: Software Project Development Process

[Tom Small]

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: Anyone use/used Flinthosts in the UK?

[Tom Small]

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

Re: Software Project Development Process

[Tom Small]

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: Software Project Development Process

[Tom Small]

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

[Tom Small]

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

[Tom Small]

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

Software Project Development Process

[Tom Small]

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

Array conversion issue

[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

Array conversion issue

[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

Re: cannot convert the value "x" to a boolean

[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: cannot convert the value "x" to a boolean

[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

cannot convert the value "x" to a boolean

[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 =  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:


WHERE u.email LIKE  OR
  r.rolename LIKE  OR  
  u.isactive =  
 

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: Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

[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

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

[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: 'Users',

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',
handler: function

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

[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

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

[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: Grid filter textbox

[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:'Frederick County 
MD, Public Schools Check Registers'
   }
  }),
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: Grid filter textbox

[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

Grid filter textbox

[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: Filter row plugin

[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

[Tom Small]

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

[Tom Small]

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

[Tom Small]

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

[Tom Small]

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

[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

[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

Re: Convert queries for ext

[Tom Small]

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 queries for ext

[Tom Small]

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

[Tom Small]

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

[Tom Small]

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

[Tom Small]

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: 'Users',

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

[Tom Small]

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

[Tom Small]

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

[Tom Small]

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)]);
}
});






 
 
 
 

  

   SELECT user_pk,email,isactive,userroleid
   FROM users
   ORDER BY #arguments.sort#
 
 

 
 
 





  
  
  
  
  
   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;
 




~|
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

Convert queries for ext

[Tom Small]

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: extjs4 designer

[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

Re: Convert php to cfm

[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: Convert php to cfm

[Tom Small]

Hi Andrew, thanks for your help and 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:349379
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Convert php to cfm

[Tom Small]

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

 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

extjs4 designer

[Tom Small]

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

Extjs4

[Tom Small]

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

Re: cfquery and json

[Tom Small]

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

cfquery and json

[Tom Small]

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: ORM global event handler

[Tom Small]

Hi Cameron, thanks for the reply and I am not running it directly from cfc. 
Maybe it is something that I have done wrong in the code, although have checked 
and re-checked. In addition, have included in application.cfc - 
this.ormsettings.eventhandling; this.ormsettings.eventhandler (which is mapped 
to the cfc)

Will start afresh tomorrow as it is usually the small issues that take the 
longest to solve, although once found is always remembered.

Thanks again! 

~|
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:349253
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ORM global event handler

[Tom Small]

Hi Matt

Thanks for your reply. I am following a book by John Whish "ColdFusion ORM" and 
have pasted his exmaple;

component implements="cfide.orm.IEventHandler"
{
public void function preLoad( any entity )
{
logEvent( "preload", arguments.entity );
}
public void function postLoad( any entity )
{
logEvent( "postload", arguments.entity );
}
public void function preInsert( any entity )
{
logEvent( "preinsert", arguments.entity );
var timestamp = now();
if ( StructKeyExists( arguments.entity, "setCreated" ) )
{
arguments.entity.setcreated( timestamp );
}
if ( StructKeyExists( arguments.entity, "setUpdated" ) )
{
arguments.entity.setupdated( timestamp );
}
}
public void function postInsert( any entity )
{
logEvent( "postinsert", arguments.entity );
}
public void function preUpdate( any entity, Struct oldData )
{
if ( StructKeyExists( arguments.entity, "setUpdated" ) )
{
arguments.entity.setupdated( Now() );
}
logEvent( "preupdate", arguments.entity );
}
public void function postUpdate( any entity )
{
logEvent( "postupdate", arguments.entity );
}
public void function preDelete( any entity )
{
logEvent( "predelete", arguments.entity );
}
public void function postDelete( any entity )
{
logEvent( "postdelete", arguments.entity );
}
private void function logEvent( required string event, required
CFC )
{
var message = "Entity: #getMetaData( cfc ).fullname#, Event:
#event#";
WriteLog( type="event", file="ormevent.log", text=message );
}
} 

~|
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:349251
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

ORM global event handler

[Tom Small]

Hi I am attempting to run a global event handler although get getting error:

function keyword is missing in FUNCTION declaration.
The CFML compiler was processing:
A script statement beginning with component on line 7, column 2.
A cfscript tag beginning on line 2, column 2.
 
The error occurred in 
C:\ColdFusion9\wwwroot\orm\model\aop\GlobalEventHandler.cfc: line 7
5 : */ 
6 : 
7 :  component implements="CFIDE.orm.IEventHandler"
8 :  {
9 : 

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:349249
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ORM Linkedtable

[Tom Small]

Hi Cameron,

Thanks for your advice and support in this matter. I took your advise and 
purchased the ColdFusion ORM book, which has very good examples and is an 
excellent read.


~|
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:349199
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Save Form Data to XML file

[Tom Jones]

Thanks, this works great. I really had thought there might have been a simple 
function to to do this :-)

thanks again,
tom

>So, if you have an arbitrary number of columns and when you submit the 
>form you get:
>
>form.align=left,left,...
>form.dname=Agent Version,Allow Client,...
>
>then you can do:
>
>colCount = listLen(form.align);
>xml = "";
>for (i = 1;  i LTE colCount; i++) {
> xml &= "";
> xml &= "#listGetAt(form.align, i)#";
> xml &= "#listGetAt(form.dname, i)#";
> ...
> xml &= "";
>}
>xml = "#xml#";
>
>
>On 12/14/11 8:43 PM, Tom Jones wrote:
>> 

~|
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:349166
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Save Form Data to XML file

[Tom Jones]

Hello,
I have been searching all over cf-talk archives and on google and I don't see a 
good example on how to save form data to a xml file. 

So what I'm doing right now is, I have a xml file and read that and then 
display it in a form so the it can be edited. Here is an example on what I'm 
thinking. What I'm struggling with is the form data is not returned as an array 
of structs where I could easily create a xml file from, it's just coma 
separated lists.

Thanks,
tom





Order
Display Name
Align Text
Hide
Column Width









 




 

~|
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:349157
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ORM Linkedtable

[Tom Small]

> Hi Cameron,
> 
> Should have added that I am attempting to link the 'users' table 
> (one-to-many) with the 'userrole' table.

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:349071
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ORM Linkedtable

[Tom Small]

Hi Cameron,

Below is a snippet of code, and appreciate your assistance in this matter...














  



























---


















 



   













---

















~|
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:349070
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ORM Linkedtable

[Tom Small]

Hi Cameron

I am not having any errors as I have a limited understanding and have followed 
the adobe tutorials... 

Although I am having trouble understanding how to create a relationship between 
more than one table. 

I have linked the core table 'Clients' to the sub-table 'Whitelabel' 
(one-to-one), 'Users' (one-to-many) and 'Users' to Userrole' (one-to-many).

My issue is how to link the foreign keys in the 'Users' to the 'Userroles'

Appreciate any help on this matter!


Mysql code:

CREATE TABLE clients (
clientid INTEGER(11) NOT NULL AUTO_INCREMENT,
clientname VARCHAR(50) NOT NULL,
isactive VARCHAR(1) NOT NULL,
departmentname VARCHAR(50) NOT NULL,
departmentaddress TEXT NOT NULL,
contactname VARCHAR(50) NOT NULL,
contactemail VARCHAR(50) NOT NULL,
contacttelephone VARCHAR(50) NOT NULL,
accounttype VARCHAR(50) NOT NULL,
startdate DATE NOT NULL,
expirydate DATE NOT NULL,
paymentmethod TEXT NOT NULL,
notes TEXT,
PRIMARY KEY (clientid),
UNIQUE (clientname)
)
ENGINE=InnoDB;


CREATE TABLE whitelabel (
whitelabelid INTEGER(11) NOT NULL,
whitelabel VARCHAR(1) NOT NULL DEFAULT 0,
logo VARCHAR(50) NOT NULL,
topbar VARCHAR(50) NOT NULL,
loginpagehtml TEXT NOT NULL,
whitelabelemail VARCHAR(50),
whitelabeltelephone VARCHAR(50),
whitelabelwebsite VARCHAR(50),
whitelabeladdress TEXT,
PRIMARY KEY (clientid),
FOREIGN KEY (clientid)
REFERENCES clients (clientid)
ON UPDATE CASCADE
ON DELETE CASCADE
)
ENGINE=InnoDB;


CREATE TABLE userrole (
userroleid INTEGER(11) NOT NULL AUTO_INCREMENT,
rolename VARCHAR(50) NOT NULL,
PRIMARY KEY (userroleid),
UNIQUE (rolename)
)
ENGINE=InnoDB;

CREATE TABLE users (
userid INTEGER(11) NOT NULL AUTO_INCREMENT,
email VARCHAR(50) NOT NULL,
password VARCHAR(255) NOT NULL,
title VARCHAR(5) NOT NULL,
firstname VARCHAR(50) NOT NULL,
lastname VARCHAR(50) NOT NULL,
position VARCHAR(50) NOT NULL,
isactive VARCHAR(1) NOT NULL,
userroleid INTEGER(11) NOT NULL,
showassistance VARCHAR(1) NOT NULL DEFAULT 1,
failedloginattempts VARCHAR(1) NOT NULL DEFAULT 0,
passwordexpires DATETIME NOT NULL,
PRIMARY KEY (userid),
UNIQUE (email),
UNIQUE (title,firstname,lastname),
FOREIGN KEY (userid)
REFERENCES clients (clientid)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (userid)
REFERENCES userrole (userroleid)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (userroleid)
REFERENCES userrole (userroleid)
ON UPDATE CASCADE
ON DELETE CASCADE
)
ENGINE=InnoDB;









~|
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:349068
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

ORM Linkedtable

[Tom (Re-Base)]

Hi I am new to Coldfsuion ORM and want to linked 3 tables. Table C and A has
a (one-to-one relationship), Table A and B has a (one-to-many relationship),
thanks

 

 

CREATE TABLE C (

searchid INTEGER(11) NOT NULL AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

PRIMARY KEY (searchid)

)

ENGINE=InnoDB;

 

CREATE TABLE A (

testid INTEGER(11) NOT NULL AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

PRIMARY KEY (testid)

)

ENGINE=InnoDB;

 

CREATE TABLE B (

findid INTEGER(11) NOT NULL AUTO_INCREMENT,

numid INTEGER(11) NOT NULL,

PRIMARY KEY (findid),

FOREIGN KEY (findid)

REFERENCES A (testid)

ON UPDATE CASCADE

ON DELETE CASCADE,

FOREIGN KEY (findid)

REFERENCES C (searchid)

ON UPDATE CASCADE

ON DELETE CASCADE

)

ENGINE=InnoDB;

 

I would appricayed some help

 

Regards 
 

Tom Small BSc (Hons), MBCS

Technical Director 

Re-Base Ltd

Database Solutions

 

Contact Details:

Email:  <mailto:rich...@j7group.net>  <mailto:t...@re-base.net>
t...@re-base.net   <http://www.j7group.net/><http://www.j7group.net/> 

Website:  <http://www.re-base.net/>  <http://www.re-base.net/>
www.re-base.net 

Tel: +44 (0)207 111 7768

 

LinkedIn:  <http://uk.linkedin.com/pub/tom-small/29/81a/365>
http://uk.linkedin.com/pub/tom-small/29/81a/365

Twitter:  <http://twitter.com/#!/Re_Base> http://twitter.com/#!/Re_Base

 

Re-Base Ltd

31 Harley Street

London

W1G 9QS

 

Company Number: 05613376

VAT Number: 924 9392 93



-- 
This e-mail is confidential and privileged. If you are not the intended
recipient please accept our apologies; please do not disclose, copy or
distribute information in this e-mail or take any action in reliance on its
contents: to do so is strictly prohibited and may be unlawful. Please inform
us that this message has gone astray before deleting it. Thank you for your
co-operation. 

 



~|
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:349066
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: arraydeleteat display issue

[Tom Connolly]

>ArrayDeleteAt returns true\false based on the success of the operation. Both
>your samples create the impression you want to display that value. Try this,
>
>
>
>

That worked, thanks!  I did not want to output the return but couldn't get the 
command to run without the cfoutput.  

-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:348195
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

arraydeleteat display issue

[Tom Connolly]

When the following code runs I get a "YES" diplayed on the page:



   #ArrayDeleteAt(session.order_array,7)#



I tried changing the code to this to get rid of the "YES" output but it still 
appears:




#arrayDelete#



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:348068
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Coldfuion 9 and ORM

[Tom Small]

Hi Jonah

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:347552
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Coldfuion 9 and ORM

[Tom (J7 Group)]

Hi, 

 

We have an application that uses several data sources, and have read an
article
(http://www.adobe.com/devnet/coldfusion/articles/coldfusion9_orm.html) that
says; Hibernate integration can work with only one data source within a
given ColdFusion application. 

 

If this is the case, then is there a way around this?

 

 

Regards 
 
Tom Small BSc (Hons), MBCS
 
Director
J7IS Ltd
Web Application Development  

 

E:   <mailto:t...@j7group.net> t...@j7group.net 
 
W:  <http://www.j7group.net> www.j7group.net 

 www.re-base.net 

  <http://uk.linkedin.com/pub/tom-small/29/81a/365>
http://uk.linkedin.com/pub/tom-small/29/81a/365 

 

G:   <http://www.linkedin.com/e/-5vqu99-go5vt4s1-8/vgh/3930370/>
http://www.linkedin.com/e/-5vqu99-go5vt4s1-8/vgh/3930370/ 

 

 

T:  +44 (0)207 111 7768

 

J7 Group

31 Harley Street

London

W1G 9QS



 

Company Number: 05613376
VAT Number: 924 9392 93 
 

-- 
This e-mail is confidential and privileged. If you are not the intended
recipient please accept our apologies; please do not disclose, copy or
distribute information in this e-mail or take any action in reliance on its
contents: to do so is strictly prohibited and may be unlawful. Please inform
us that this message has gone astray before deleting it. Thank you for your
co-operation. 

 




~|
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:347545
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

jqgrid and file upload

[Tom Jones]

Hello,
Does anyone have a working example on how to integrate a file upload in to a 
jqgrid edit?

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:343767
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: coldfusion service stop rsponding or CPU goes up tp 100%

[tom vallee]

also i saw that jrun.exe memory is always growing, it was at 5 590 405 kb.

is it normal?

is it because in jvm.settings i put 8gb of java jeap size ? 

~|
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:343648
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

JVM configuration Problem

[erik tom]

My CPU is running almost 100%. I am using windows 7 64 bit 6G ram. I have the 
following arguments set but it is still slow.

Please help

java.args=-server  -Xms1224m -Xmx1224m -Dsun.io.useCanonCaches=false 
-XX:MaxPermSize=250m -XX:TargetSurvivorRatio=50 -XX:+UseConcMarkSweepGC 
-XX:CompileThreshold=1 -XX:+UseParNewGC -XX:+CMSIncrementalMode  
-XX:+AggressiveOpts -XX:ThreadStackSize=128k -XX:+DisableExplicitGC 
-XX:CMSInitiatingOccupancyFraction=80  
-Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/flex/jars,{application.home}/../wwwroot/WEB-INF/cfform/jars
-XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Xbatch 
-Dcoldfusion.rootDir={application.home}/../ 
-Dcoldfusion.libPath={application.home}/../lib 
-Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/flex/jars,{application.home}/../wwwroot/WEB-INF/cfform/jars
 

~|
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:343581
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: java.lang.OutOfMemoryError: Java heap space

[tom vallee]

i should replace -XX:+UseConcMarkSweepGC and  -XX:+UseParNewGC or only 
-XX:+UseConcMarkSweepGC

with : XX:+UseParallelGC 


~|
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:343346
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm