Re: Setting client variable datasource via config.xml
On Fri, Aug 12, 2011 at 12:06 AM, Brook Davies wrote: I'm trying to set all my apps properties via a config file to make deployment between dev, production servers easy. Problem is the application vars that are read via onApplicationStart() are not available within the opening part of the application.cfc and when I try to set these properties inside onRequestStart() they do not work. Should I be able to set these in onRequestsStart()? We have moved those parts of the configuration required for code outside the methods in Application.cfc to the onServerStart() method of Server.cfc. That only works because we deploy one application per instance though. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:346716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration
I have separate application pools for each site/instance and they're all set up to use the same user account, so I would think either all would work or none. Regardless, when I decided to try tackling this again yesterday afternoon, I was able to access each of the sites from my PC, so at least that part is straightened out (I think). Straightened out the last issue with the cfusion instance this morning, so I think I'm good to go now. Thanks for all the suggestions!! Debbie -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, August 10, 2011 7:57 PM To: cf-talk Subject: Re: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration If it is an IIS problem then you need to make sure that the application pool also has correct permissions, and that the user is a member of the IISURS or IWAM group (I forget which) On Wed, Aug 10, 2011 at 9:27 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: Debbie, I'll check but you may need your IIS services to run as the same user as well. Also, take a look at the *instance*-out.log for any issues when starting the instance -Mark -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Wednesday, August 10, 2011 3:25 PM To: cf-talk Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration I have all of my instances running as Windows services, so I changed it on all 4 of those (cfusion, intranet, intranetDev, and wwwDev). All 4 services are using the same domain account, which is also a member of the local administrators group. I just double-checked the security on the folders for each of the sites and the local administrators group has permissions for all those directories as well as the JRun4 directory. -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, August 10, 2011 4:12 PM To: cf-talk Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration Debbie, Which services did you change accounts on? If you changed CF services to run under an account then that user account will need permissions to various folders on the server (like the jrun4 folder for example). -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Wednesday, August 10, 2011 2:51 PM To: cf-talk Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration To add a little more info, I'm able to access all three sites through the browser on the server console, so CF works fine locally for all three sites. It's just when I try to access the sites on ports 81 and 82 from the network that I get the error. Does that mean it's an IIS or IP configuration issue? Thanks, Debbie -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Wednesday, August 10, 2011 3:14 PM To: cf-talk Subject: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration I've got a server (west-intranet, 10.2.1.46) running CF 9.01 on Windows Server 2008 R2 with IIS 7. I previously had multiple instances running, but I had to change my service properties to a user account so that I could access network printers, and now everything has gone to heck in a handbasket. At this point, the only site that I'm able to access is the Intranet site running on port 80. When trying to access the sites on other ports, I get a connection timeout error. I've even managed to muck it up enough so that I can't even get into the cfusion server to look at the instances defined. Any suggestions on what I can look at to straighten this out? IIS: Intranet - port 80 intranetDev-port 81 wwwDev-port 82 wsconfig: [ localhost:intranet ] Internet Information Server (IIS) : intranet [ localhost:intranetDev ] Internet Information Server (IIS) : intranetDev [ localhost:wwwDev ] Internet Information Server (IIS) : wwwDev ~| 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:346717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration
Excellent! -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Friday, August 12, 2011 8:22 AM To: cf-talk Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration I have separate application pools for each site/instance and they're all set up to use the same user account, so I would think either all would work or none. Regardless, when I decided to try tackling this again yesterday afternoon, I was able to access each of the sites from my PC, so at least that part is straightened out (I think). Straightened out the last issue with the cfusion instance this morning, so I think I'm good to go now. Thanks for all the suggestions!! Debbie -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, August 10, 2011 7:57 PM To: cf-talk Subject: Re: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration If it is an IIS problem then you need to make sure that the application pool also has correct permissions, and that the user is a member of the IISURS or IWAM group (I forget which) On Wed, Aug 10, 2011 at 9:27 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: Debbie, I'll check but you may need your IIS services to run as the same user as well. Also, take a look at the *instance*-out.log for any issues when starting the instance -Mark -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Wednesday, August 10, 2011 3:25 PM To: cf-talk Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration I have all of my instances running as Windows services, so I changed it on all 4 of those (cfusion, intranet, intranetDev, and wwwDev). All 4 services are using the same domain account, which is also a member of the local administrators group. I just double-checked the security on the folders for each of the sites and the local administrators group has permissions for all those directories as well as the JRun4 directory. -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, August 10, 2011 4:12 PM To: cf-talk Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration Debbie, Which services did you change accounts on? If you changed CF services to run under an account then that user account will need permissions to various folders on the server (like the jrun4 folder for example). -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Wednesday, August 10, 2011 2:51 PM To: cf-talk Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration To add a little more info, I'm able to access all three sites through the browser on the server console, so CF works fine locally for all three sites. It's just when I try to access the sites on ports 81 and 82 from the network that I get the error. Does that mean it's an IIS or IP configuration issue? Thanks, Debbie -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Wednesday, August 10, 2011 3:14 PM To: cf-talk Subject: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration I've got a server (west-intranet, 10.2.1.46) running CF 9.01 on Windows Server 2008 R2 with IIS 7. I previously had multiple instances running, but I had to change my service properties to a user account so that I could access network printers, and now everything has gone to heck in a handbasket. At this point, the only site that I'm able to access is the Intranet site running on port 80. When trying to access the sites on other ports, I get a connection timeout error. I've even managed to muck it up enough so that I can't even get into the cfusion server to look at the instances defined. Any suggestions on what I can look at to straighten this out? IIS: Intranet - port 80 intranetDev-port 81 wwwDev-port 82 wsconfig: [ localhost:intranet ] Internet Information Server (IIS) : intranet [ localhost:intranetDev ] Internet Information Server (IIS) : intranetDev [ localhost:wwwDev ] Internet Information Server (IIS) : wwwDev ~| 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:346718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration
are you running windows 2008 by any chance? If so don;t forget that the firewall is enabled by default, this has caught me out several times now as I am still maining maintaining windows 2003 servers, and has been the cause of things not working as services or applications get blocked. Russ -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| 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:346719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration
Yes, it's Server 2008 R2. I did modify the firewall settings the other day, so it's possible that might be why it's working now. I'm not necessarily sure that I made the *correct* changes though. Right now I have it turned off for the Domain and Private profiles and turned on for Public. Domain is the one I turned off the other day. This server is inside the firewall, connected to our network, with CF using a domain account to logon. Is there a better way I should have these firewall profiles configured? -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, August 12, 2011 9:38 AM To: cf-talk Subject: Re: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration are you running windows 2008 by any chance? If so don;t forget that the firewall is enabled by default, this has caught me out several times now as I am still maining maintaining windows 2003 servers, and has been the cause of things not working as services or applications get blocked. Russ -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| 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:346720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Spam:*******, Re: RETS - Real Estate Standards Organization - XML feed - anyone have any experience
Hi Wil, Thanks for the note.. A couple of questions When you mention use phRets you're suggesting using a php server to accomplish the data retrieval tasks? With regard to the amount of data that is retrieved each time we connect to the RETS server... currently I pull information via an FTP feed. I connect to the their FTP site and look for the latest ftp zip file. These zip files allow me to add and delete properties from my aggregate database. Is there some sort of query language with RETS that allows me to do the same incremental update throughout the day? Finally, I run my own CF server... allow I'm no expert on incorporating a JAVA API into CF I know that it is possible. Have you looked at RETS IQ Java RETS Library? http://wiki.rets.org/wiki/RETS_IQ_Java_RETS_Library What do you think about using such a library? Thanks again! Wayne On 8/6/2011 12:50 PM, Wil Genovese wrote: Wayne, I spent over 5 years working with Real Estate data and the RETS servers. The misfortunate part of RETS is that there is NOT a standard. Every MLS market implements RETS differently. I've written a RETS client in ColdFusion once. It's market specific and the client owns the code. The best I can suggest is to look at phRets and decided if you want to use that or rewrite that to ColdFusion. The thing to remember it that it's all XML. NExt you have to make http calls to get the meta data, then parse that out then do another http call to get the next level meta data and parse that out. You keep doing this until you have all the meta data that describes the entire data structure. Then create the structure in your DB. Then you start doing http calls to get the data. If the market is a large MLS market, you may have problems with memory limits in the JVM. I've had to run upwards of 4Gb or more in the heap and setup fairly aggressive garbage collections. Your server side needs to be fast. The process of RETS means the code will be running for maybe an hour or more (depending on the data set) and could be making hundreds of HTTP calls. Getting images is almost as fun. But I found I could get them with ColdFusion via RETS and save them to a drive rather quickly. The data is in binary format and may not seem obvious at first when you make the first RETS object call. But ColdFusion will process the data and you can save the image. I just looked in my junk code folder where I keep all sorts of test code snippets. I found some RETS test code that may help you. I'll send it privately. Good Luck! Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Aug 6, 2011, at 2:36 PM, Wayne Gregor wrote: I need to convert over a couple of real estate website that are currently receiving MLS data via an hourly FTP feed. The new system handed down by the National Association of Realtors is RETShttp://www.rets.org/. Do any of you know if there are any CFC functions out there that would make it easier for me to interface with this new system? -- *Wayne Gregori* Office: 510-895-1066 Cell: 510-219-3887 w...@sfnet.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:346721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 and beyond
Well sort of.we developed our platform after about a decade of work with BC fisheries.but it's a globally available platform and is in use in the Northeast US and BCmore coming online soon.and a new website for it. We've actually dropped OpenBD for AIR onboardOpenBD was great, but for us AIR is betterso no slagging of OpenBD here...was quite impressed with it and the team behind it. Cheers On Thu, 2011-08-11 at 15:09 -0400, Larry Lyons wrote: Well the shy can of course be a personal decision. For me I check out alternatives to give my clients the best possible service and so I know what is availablebut they...that's me ;-) it was also the ability to have a complete web app running onboard fishing vessels disconnectedwith about 50 MB footprint! Cheers I take it was for a BC Fisheries 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:346722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Setting client variable datasource via config.xml
Good Solution, thanks!
-Original Message-
From: Brian Kotek [mailto:brian...@gmail.com]
Sent: August-11-11 9:47 PM
To: cf-talk
Subject: Re: Setting client variable datasource via config.xml
Right, set up a function that you call to get the variables, and have it
read the XML the first time, and on any subsequent calls just use the XML
already loaded rather than load it again.
On Fri, Aug 12, 2011 at 12:17 AM, Matt Quackenbush
quackfu...@gmail.comwrote:
No, you cannot do
cfset this.clientStorage = application.gs.clientVarDataSource /
You might get away with that after the application has already been
init'd, but even then it would be a false positive and would stop
working as soon as the application timed out or the application server
was restarted.
However,
you *can* do something like so:
this.clientStorage = getClientStorageDatasource();
function getClientStorageDatasource()
{
// read your xml file and extract the variable
return theDatasource;
}
HTH
On Thu, Aug 11, 2011 at 10:57 PM, Brook Davies cft...@logiforms.com
wrote:
But can you set this.clientstorage that way? Because It seems
setting
that
property within onRequestStart() does not work. In my requestStart
method
I
call another method which sets a client var. If I set the
this.client[(storage|Management|etc] in the onRequestStart, I get an
error
that the client scope is not enabled when I try to set a client var
in a method called from there.
Sorry to be using client variables Nathan :(
Brook
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: August-11-11 5:45 PM
To: cf-talk
Subject: Re: Setting client variable datasource via config.xml
I used to have this issue as well, you obviously cannot read read
app
vars
that do not exist yet and you cannot create them until the
application scope is initialised.
The way I got round this is to have 2 XML files.
One that contains the init variables that need to exist before the
application scope is initialised, and I load these into request
scope onapplicationstart. Once this is done, I then load the global
config into the application scope.
On Thu, Aug 11, 2011 at 11:06 PM, Brook Davies
cft...@logiforms.com
wrote:
I'm trying to set all my apps properties via a config file to make
deployment between dev, production servers easy. Problem is the
application vars that are read via onApplicationStart() are not
available within the opening part of the application.cfc and when
I try to set these properties inside onRequestStart() they do not
work.
Should I be able to set these in onRequestsStart()?
cfcomponent output=false extends=coldfireApplication
cfset this.clientManagement= true
cfset this.setClientCookies= true
cfset this.setDomainCookies= false
cfset this.clientStorage =
application.gs.clientVarDataSource
~|
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:346723
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Clustering / Instances multiple domains
That's only possible if you use Verity as a standalone product (not free), sadly. SOLR (free!) supports this, however, but you'd need to convert everything over to SOLR collections. I believe there's a function in the admin to do that conversion. I haven't used Verity in a while (thankfully) but I seem to recall a separate installer from Adobe being available for Verity, so that you could install it on a different machine than CF. 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 onsit ~| 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:346724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Setting client variable datasource via config.xml
Hmm, are you sure that would work, as you still surely need to initialise
the application first before checking if anything exist as
OnApplicationstart will run first.
So if your application settings are coming form the XML file, you need them
even before the Application initialises and checks for the existence of the
application vars.
On Fri, Aug 12, 2011 at 5:19 PM, Brook Davies cft...@logiforms.com wrote:
Good Solution, thanks!
-Original Message-
From: Brian Kotek [mailto:brian...@gmail.com]
Sent: August-11-11 9:47 PM
To: cf-talk
Subject: Re: Setting client variable datasource via config.xml
Right, set up a function that you call to get the variables, and have it
read the XML the first time, and on any subsequent calls just use the XML
already loaded rather than load it again.
On Fri, Aug 12, 2011 at 12:17 AM, Matt Quackenbush
quackfu...@gmail.comwrote:
No, you cannot do
cfset this.clientStorage = application.gs.clientVarDataSource /
You might get away with that after the application has already been
init'd, but even then it would be a false positive and would stop
working as soon as the application timed out or the application server
was restarted.
However,
you *can* do something like so:
this.clientStorage = getClientStorageDatasource();
function getClientStorageDatasource()
{
// read your xml file and extract the variable
return theDatasource;
}
HTH
On Thu, Aug 11, 2011 at 10:57 PM, Brook Davies cft...@logiforms.com
wrote:
But can you set this.clientstorage that way? Because It seems
setting
that
property within onRequestStart() does not work. In my requestStart
method
I
call another method which sets a client var. If I set the
this.client[(storage|Management|etc] in the onRequestStart, I get an
error
that the client scope is not enabled when I try to set a client var
in a method called from there.
Sorry to be using client variables Nathan :(
Brook
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: August-11-11 5:45 PM
To: cf-talk
Subject: Re: Setting client variable datasource via config.xml
I used to have this issue as well, you obviously cannot read read
app
vars
that do not exist yet and you cannot create them until the
application scope is initialised.
The way I got round this is to have 2 XML files.
One that contains the init variables that need to exist before the
application scope is initialised, and I load these into request
scope onapplicationstart. Once this is done, I then load the global
config into the application scope.
On Thu, Aug 11, 2011 at 11:06 PM, Brook Davies
cft...@logiforms.com
wrote:
I'm trying to set all my apps properties via a config file to make
deployment between dev, production servers easy. Problem is the
application vars that are read via onApplicationStart() are not
available within the opening part of the application.cfc and when
I try to set these properties inside onRequestStart() they do not
work.
Should I be able to set these in onRequestsStart()?
cfcomponent output=false extends=coldfireApplication
cfset this.clientManagement= true
cfset this.setClientCookies= true
cfset this.setDomainCookies= false
cfset this.clientStorage =
application.gs.clientVarDataSource
~|
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:346725
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to write this MySQL query...
Hi, guys... I've been writing, research, and re-writing a query over and over trying to get the correct (ie, trustworthy) results, but can't make it work. How would I write a query that would: - find all propertyID's from a table that had duplicate photo200 field values I've tried every variation of this I can think of: select propertyID, count(photo200) as NumPhoto200 from rentalphotos group by photo200 having NumPhoto200 1 That's not working. Any suggestions, clues, hints?? Thanks! Rick ~| 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:346726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to write this MySQL query...
Doesn't the count have to be count(*) but otherwise it looks fine to me. On Sat, Aug 13, 2011 at 3:44 AM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, guys... I've been writing, research, and re-writing a query over and over trying to get the correct (ie, trustworthy) results, but can't make it work. How would I write a query that would: - find all propertyID's from a table that had duplicate photo200 field values I've tried every variation of this I can think of: select propertyID, count(photo200) as NumPhoto200 from rentalphotos group by photo200 having NumPhoto200 1 That's not working. Any suggestions, clues, hints?? Thanks! Rick ~| 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:346727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to write this MySQL query...
I'd think grouping by propertyID as well would be a good startotherwise you're just getting ALL duplicate photo200 values across ALL properties. What is wrong with your results? that may help us help you Rick ;-) A brute force way is to: select propertyID, count(photo200) as NumPhoto200 from rentalphotos group by propertID, photo200 then a QoQ that does SELECT propertyID FROM [firstQueryName] WHERE NumPhoto200 1 A little ugly but it would get ya past this ;-) Cheers On Fri, 2011-08-12 at 13:44 -0400, Rick Faircloth wrote: Hi, guys... I've been writing, research, and re-writing a query over and over trying to get the correct (ie, trustworthy) results, but can't make it work. How would I write a query that would: - find all propertyID's from a table that had duplicate photo200 field values I've tried every variation of this I can think of: select propertyID, count(photo200) as NumPhoto200 from rentalphotos group by photo200 having NumPhoto200 1 That's not working. Any suggestions, clues, hints?? Thanks! Rick ~| 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:346728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to write this MySQL query...
- find all propertyID's from a table that had duplicate photo200 field values If you mean _different_ propertyID's sharing the same photo200 value, you would need to count by the photo200 column instead. Then match it with the propertyID. One option is using a join. Another would be a subquery using where exists ... select r.propertyID, pc.photo200, pc.TimesUsed from rentalphotos r inner join ( select photo200, count(*) as TimesUsed from rentalphotos group by photo200 having count(*) 1 ) pc on pc.photo200 = r.photo200 ~| 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:346729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to write this MySQL query...
Thanks, guys... I decided to try Leigh's suggestion first, and it worked. Thanks for the suggestions, everyone! Rick :o) -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Friday, August 12, 2011 2:02 PM To: cf-talk Subject: Re: How to write this MySQL query... - find all propertyID's from a table that had duplicate photo200 field values If you mean _different_ propertyID's sharing the same photo200 value, you would need to count by the photo200 column instead. Then match it with the propertyID. One option is using a join. Another would be a subquery using where exists ... select r.propertyID, pc.photo200, pc.TimesUsed from rentalphotos r inner join ( select photo200, count(*) as TimesUsed from rentalphotos group by photo200 having count(*) 1 ) pc on pc.photo200 = r.photo200 ~| 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:346730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to write this MySQL query...
Rick - If you do not need the TimesUsed count, you might also try the WHERE EXISTS approach to compare performance. -Leigh ~| 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:346731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to write this MySQL query...
Thanks, Leigh... I just needed to run a query to see if a client was putting photos with identical names in their database. There were... I need to add a date-time stamp or append a UUID to their filenames, or something to make sure they are unique. The query was just to generate a report and show them why photos were appearing with the wrong properties. Thanks for your help! Rick -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Friday, August 12, 2011 4:05 PM To: cf-talk Subject: RE: How to write this MySQL query... Rick - If you do not need the TimesUsed count, you might also try the WHERE EXISTS approach to compare performance. -Leigh ~| 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:346732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to write this MySQL query...
Ah. Ad-hoc. Gotcha. (Can you tell I have been tuning monster sql queries all day? Here is to a sql free weekend! ;-) -Leigh ~| 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:346733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Clustering / Instances multiple domains
I've used the standalone installer, but it's been a good long time. I think it only accepts requests from localhost, or some such pain in the arse deal. -- Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog twitter.com/ophbalance ~| 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:346734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Clustering / Instances multiple domains
there is no such restriction, otherwise CF would not be much use in a production environment if no-one could connect to it would it :-) On Fri, Aug 12, 2011 at 10:38 PM, Matthew Williams mai...@geodesicgrafx.com wrote: I've used the standalone installer, but it's been a good long time. I think it only accepts requests from localhost, or some such pain in the arse deal. -- Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog twitter.com/ophbalance ~| 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:346735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) IIS Log files
My apologies for this off topic issue but this is about the best collection of web talent to ask. We use IIS (and CF of course) and the economy has caused us to have many clients come and go, mostly go I am afraid. I am in the position where we need to manage and remove the old IIS log files/folders when we remove a website from the servers. Currently we are doing it manually but someone must have a utility that will read the IIS config and then either remove or report on folders in the IIS log directory. In short what utilities are people using other than parsing (we use analog) are available to manage the files/folder automatically? My searches have come up empty for anything that will handle what is missing from the IIS config. Thanks Dennis Powers UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 W: http://www.uxbinternet.com W: http://www.ctbusinesslist.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:346736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) IIS Log files
try this, i have been using it for years to clean up IIS logs. http://www.iislogs.com/ Russ On Fri, Aug 12, 2011 at 11:20 PM, UXB denn...@uxbinternet.com wrote: My apologies for this off topic issue but this is about the best collection of web talent to ask. We use IIS (and CF of course) and the economy has caused us to have many clients come and go, mostly go I am afraid. I am in the position where we need to manage and remove the old IIS log files/folders when we remove a website from the servers. Currently we are doing it manually but someone must have a utility that will read the IIS config and then either remove or report on folders in the IIS log directory. In short what utilities are people using other than parsing (we use analog) are available to manage the files/folder automatically? My searches have come up empty for anything that will handle what is missing from the IIS config. Thanks Dennis Powers UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 W: http://www.uxbinternet.com W: http://www.ctbusinesslist.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:346737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Clustering / Instances multiple domains
The restriction isn't for CF, I meant for Verity. It's been my understanding that the only way to get a full on Verity install that multiple servers could connect to was to pay for a fullblown license. -- Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog twitter.com/ophbalance ~| 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:346738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Clustering / Instances multiple domains
ah sorry yes in that case your right, verity will only search localhost, so it is only good for 1 site unless you pay for it. On Sat, Aug 13, 2011 at 1:36 AM, Matthew Williams mai...@geodesicgrafx.comwrote: The restriction isn't for CF, I meant for Verity. It's been my understanding that the only way to get a full on Verity install that multiple servers could connect to was to pay for a fullblown license. -- Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog twitter.com/ophbalance ~| 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:346739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) IIS Log files
We use IIS (and CF of course) and the economy has caused us to have many clients come and go, mostly go I am afraid. I am in the position where we need to manage and remove the old IIS log files/folders when we remove a website from the servers. Currently we are doing it manually but someone must have a utility that will read the IIS config and then either remove or report on folders in the IIS log directory. I'm not in a position to need this, but if I did I'd write a script that creates (and destroys) IIS instances and handles their log files simultaneously. You can use the sample scripts in the adminscripts directory as a starting point, and you might find something more complete at iis.net. 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:346740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Clustering / Instances multiple domains
I've used the standalone installer, but it's been a good long time. I think it only accepts requests from localhost, or some such pain in the arse deal. No, the localhost limitation applies to the spider. The standalone Verity will accept requests from other IP addresses. 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:346741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
