Update Record by Date then pick Random from Query
I have been making a ad system that randomly selects a ad. Code below works. !--- Calls up record table --- CFQUERY DATASOURCE=#request.dsn# NAME=GetADs SELECT top 1 * FROM dbo.#request.stationName#_banner_top WHERE (page_location = 'Front Page') OR (page_location2 = 'Front Page') OR (page_location3 = 'Front Page') OR (page_location = 'Every Page') OR (page_location2 = 'Every Page') OR (page_location3 = 'Every Page') ORDER BY newID() /CFQUERY Now though I want to add the function of disabling the ad if the date_remove passes. To disable I want the status column to be 1 instead of 0. Then I want to randomly pick an ad from a list of the enabled ads only. This is what I came up with. I call all the records then loop through them and if they are old then change the status to disable(1). cfset todayDate = Now() cfset todayDate2 = #dateformat(todayDate, 'mm/dd/')# !---Calls all records so I can loop--- CFQUERY DATASOURCE=#request.dsn# NAME=GetADsAll SELECT * FROM dbo.#request.stationName#_banner_top /CFQUERY !---Loop though GetADsAll if Remove Date is Old then Disable--- cfloop query=GetADsAll cfif #GetADsAll.date_remove# LT #todayDate2# CFQUERY datasource=#request.dsn# name=qDisableAd UPDATE dbo.#request.stationName#_banner_top SET status = 1 WHERE ADID = #GetADsAll.ADID# /CFQUERY /cfif /cfloop I know its all pieced together noob-like so if any help cleaning it up would be greatly appreciated. So my problem from here is taking the two parts and putting them together where the random query only shows the records with the status of 0(enabled) I tried putting this code with an AND status = 0 but that doesnt seem to work.. even the 1s show. !--- Calls up record table --- CFQUERY DATASOURCE=#request.dsn# NAME=GetADs SELECT top 1 * FROM dbo.#request.stationName#_banner_top WHERE (page_location = 'Front Page') OR (page_location2 = 'Front Page') OR (page_location3 = 'Front Page') OR (page_location = 'Every Page') OR (page_location2 = 'Every Page') OR (page_location3 = 'Every Page') AND status = 0 ORDER BY newID() /CFQUERY ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322143 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update Record by Date then pick Random from Query
Try adding parenthesis around all the ORs, so: SELECT top 1 * FROM dbo.#request.stationName#_banner_top WHERE status = 0 AND ( page_location = 'Front Page' OR page_location2 = 'Front Page' OR page_location3 = 'Front Page' OR page_location = 'Every Page' OR page_location2 = 'Every Page' OR page_location3 = 'Every Page' ) ORDER BY newID() Dominic 2009/5/4 Sin Tec tooles...@gmail.com: SELECT top 1 * FROM dbo.#request.stationName#_banner_top WHERE (page_location = 'Front Page') OR (page_location2 = 'Front Page') OR (page_location3 = 'Front Page') OR (page_location = 'Every Page') OR (page_location2 = 'Every Page') OR (page_location3 = 'Every ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Session variable wierdness
I've got an issue with session variables that keeps popping up in my log files. I do a check at the beginning of templates that check for the existence of a certain session variable, and bounce them out to a different page if necessary. But then later on in the same template, I'm getting a failure of the existence of that session variable. Something like so: Line 1-4: make sure session + other variables exist, if not, bounce to login page. Line 5: cfif not isdefined(session.templateID)cflocation url=chooseTemplate.cfm/cfif Line 400: cfoutput#session.templateID#/cfoutput Line 400 generates an error saying that session.templateID is undefined. I cannot replicate this at all, but it shows up 3-4 times a day in my logs. Can anybody shed some light on this extremely puzzling behavior? I'm still stuck on CF 7 if that makes a difference. Thanks, Michael ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322145 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update Record by Date then pick Random from Query
Maybe I mis-understood what you said about this, but you mentioned a complex process for determining which ones are active still. If you have column in the table for each banner that represents the date it expires, then you can use this directly as a filter to prevent it's selection. You don't need to loop over and manually expire each one. Like this: SELECT top 1 * FROM dbo.#request.stationName#_banner_top WHERE date_remove #CreateODBCDate(Now())# AND status = 0 AND ( page_location = 'Front Page' OR page_location2 = 'Front Page' OR page_location3 = 'Front Page' OR page_location = 'Every Page' OR page_location2 = 'Every Page' OR page_location3 = 'Every Page' ) ORDER BY newID() HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Session variable wierdness
Michael, How often does this happen? I have had some intermittent session issues that pop up very rarely and are never reproducible. I have narrowed it down to this issue, so it might help you? Or at least point you in the right direction: http://www.bennadel.com/blog/1536-ColdFusion-Session-Management-And-Asynchronous-Page-Requests.htm Good luck! -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322147 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
billing
Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322148 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: billing
Chad, Speaking from fairly vast experience I would say the following: 1) Agree in advance on the rate. 2) Find a way to communicate these hours are racking up as it happens. The worst thing is to surprise them. You really want to work hard to communicate as the hours are worked so they have all the bad news up front. 3) If you break the rate down based on size or scope then make it based on advanced payment or immediate payment. We offer a reduced rate to customers who buy hours in advance and that has helped both our cash flow and our negotiating position tremendously. Sometimes we also offer a discount to paygo customers for immediate payment. The discount works out to a bit of a break off of our highest rate, but still less of a break than our block hours customers. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Monday, May 04, 2009 12:54 PM To: cf-talk Subject: billing Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322149 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update Record by Date then pick Random from Query
Thank you both. The parenthesis around all the ORs worked. Some of my first code had the Date in the Where but I am using the enable/disable so that the Admin knows if the ad contract is up or not. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322150 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: billing
A practice I usually do is invoice weekly on a project. I rarely do 'quoted' jobs anymore, however I do give a guesstimate if the client wants one. I don't have the relationship that you have with your client, but if you have racked up legitimate hours on a project, I would charge them full price. If you want to give them a 'forever' discounted rate, then you can discount the billing on the invoice, but let the client know what the original price was. I would not suggest discounting the billing, at least not until the client has asked for it, and given sufficient reason. William -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Monday, May 04, 2009 10:54 AM To: cf-talk Subject: billing Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: billing
I've seen this for ongoing, monthly, recurring hours (only) where you'd auto-bill them for use-em-or-lose-em hours with a price structure something like: 4 hrs/month - $400 8 hrs/month - $720 16 hrs/month - $1280 etc ...with extra hours available as-needed @ the most expensive rate... On Mon, May 4, 2009 at 12:53 PM, Chad Gray cg...@careyweb.com wrote: Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: billing
Man...you're in a bit of a tough situation...I've been there myself. One thing you could do to reduce the freakout factor is offer to let them pay the bill in installments, i.e. half or a third at a time. -- Josh -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Monday, May 04, 2009 10:54 AM To: cf-talk Subject: billing Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Call .jar files like .exes with CF8
I'm trying to execute a .jar file with some parameters from a cfc and then use the file it generates afterward. But, Google and I cannot seem to figure out how you execute .jars in CFML. This is an epic fail: cfexecute name = #expandPath( '/my.jar' )# arguments = -o etc outputFile = #expandPath( '/mechanics/framework/compressor/output.txt' )# /cfexecute I've tried placing the java keyword in the beginning of the name parameter, java -jar, as well as both variations in the arguments param but no luck. Thank you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Call .jar files like .exes with CF8
The solution was providing a full path to the java.exe like so if anyone's curious: cfexecute name = x:\serverware\coldfusion8\...\java.exe arguments=-jar yourJar.jar [ options ] /cfexecute On Mon, May 4, 2009 at 1:24 PM, David McGuigan davidmcgui...@gmail.comwrote: I'm trying to execute a .jar file with some parameters from a cfc and then use the file it generates afterward. But, Google and I cannot seem to figure out how you execute .jars in CFML. This is an epic fail: cfexecute name = #expandPath( '/my.jar' )# arguments = -o etc outputFile = #expandPath( '/mechanics/framework/compressor/output.txt' )# /cfexecute I've tried placing the java keyword in the beginning of the name parameter, java -jar, as well as both variations in the arguments param but no luck. Thank you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322155 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: billing
It depends on the value you provided. Is the program worth the $40,000 or so? Will they be making a lot of money off of it? If so, I wouldn't discount it after the fact. Do what you did on the previous projects.. that is what they are expecting. If the website doesn't appear elaborate, they are going to freak out seeing such a bill, but if it is obvious that it took a lot of work, there shouldn't be a problem. What I do in cases like this is send in weekly updates on what has been done, showing them what is accomplished to get feedback on it, and also tell them how many hours were put in so far.. So they can see if it starts to get out of hand.It is probably too late for you, but you could show them what you have so far and how many hours have been used, and tell them what needs to be done to finish the project, and offer to cut some features if they reached thier budget. Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: billing
Thanks for all the feedback. The original site was a $20k project in 2002. Now this redesign which is more complex is hitting the $40k range. I went back and looked closer at all the billing we have done in the past ( I was not in charge at that time of billing ) and I feel this new price is legitimate for the amount of labor we have in it. For these projects in the future I will be doing weekly billing... I have always liked to tell the customer that we wont bill them until the project is complete and they are absolutely happy with the result according to the quote we provide. I kind of got in that mindset and did not want to charge them until the project was done. Thanks! Learned my lesson. -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Monday, May 04, 2009 3:49 PM To: cf-talk Subject: Re: billing It depends on the value you provided. Is the program worth the $40,000 or so? Will they be making a lot of money off of it? If so, I wouldn't discount it after the fact. Do what you did on the previous projects.. that is what they are expecting. If the website doesn't appear elaborate, they are going to freak out seeing such a bill, but if it is obvious that it took a lot of work, there shouldn't be a problem. What I do in cases like this is send in weekly updates on what has been done, showing them what is accomplished to get feedback on it, and also tell them how many hours were put in so far.. So they can see if it starts to get out of hand.It is probably too late for you, but you could show them what you have so far and how many hours have been used, and tell them what needs to be done to finish the project, and offer to cut some features if they reached thier budget. Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322157 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache and ColdFusion Trouble
I am still not figuring this out! Does anyone have ideas? -Jason Hi Maureen, Are you running apache 2.2x? Yes. Can you perform a restart (apachectl restart or apachectl stop| apachectl start) and watch to see how things load and post back? Sure, I did an apachectl stop, tailed and did a start here is what is spit back: [Sun May 03 23:10:19 2009] [info] removed PID file /etc/httpd/run/httpd.pid (pid=4377) [Sun May 03 23:10:19 2009] [notice] caught SIGTERM, shutting down [Sun May 03 23:10:34 2009] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Sun May 03 23:10:34 2009] [notice] jrApache[init] JRun 4.0 (Build 108673) Apache 2.2 module - Mar 14 2008 01:19:38 [Sun May 03 23:10:34 2009] [notice] Digest: generating secret for digest authentication ... [Sun May 03 23:10:34 2009] [notice] Digest: done [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: wikikalendar.info [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: whatsgoodorbad.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: waterfordwindowandglass.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: thejasonandannettefoundation.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: thejasonandannettefoundation.org [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: sheldony.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: johnandlinda.us [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: andrew.jasonslack.name [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: jasonslack.name [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: 281bowl.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: 67. 23.34.37 [Sun May 03 23:10:34 2009] [info] APR LDAP: Built with OpenLDAP LDAP SDK [Sun May 03 23:10:34 2009] [info] LDAP: SSL support available [Sun May 03 23:10:34 2009] [notice] jrApache[init] JRun 4.0 (Build 108673) Apache 2.2 module - Mar 14 2008 01:19:38 [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24700 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24700 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24703 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24703 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24704 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24704 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24705 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24705 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24706 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24706 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24707 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24707 for (*) [Sun May 03 23:10:35 2009] [debug]
Re: Apache and ColdFusion Trouble
can you enable web server in cf and see what happens? do you need mod_proxy and ldap supprt? have you enabled sandbox security? On Mon, May 4, 2009 at 17:29, Jason Slack applesl...@gmail.com wrote: I am still not figuring this out! Does anyone have ideas? -Jason Hi Maureen, Are you running apache 2.2x? Yes. Can you perform a restart (apachectl restart or apachectl stop| apachectl start) and watch to see how things load and post back? Sure, I did an apachectl stop, tailed and did a start here is what is spit back: [Sun May 03 23:10:19 2009] [info] removed PID file /etc/httpd/run/httpd.pid (pid=4377) [Sun May 03 23:10:19 2009] [notice] caught SIGTERM, shutting down [Sun May 03 23:10:34 2009] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Sun May 03 23:10:34 2009] [notice] jrApache[init] JRun 4.0 (Build 108673) Apache 2.2 module - Mar 14 2008 01:19:38 [Sun May 03 23:10:34 2009] [notice] Digest: generating secret for digest authentication ... [Sun May 03 23:10:34 2009] [notice] Digest: done [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: wikikalendar.info [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: whatsgoodorbad.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: waterfordwindowandglass.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: thejasonandannettefoundation.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: thejasonandannettefoundation.org [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: sheldony.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: johnandlinda.us [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: andrew.jasonslack.name [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: jasonslack.name [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: 281bowl.com [Sun May 03 23:10:34 2009] [debug] util_ldap.c(1949): LDAP merging Shared Cache conf: shm=0x7f02f0260c48 rmm=0x7f02f0260ca0 for VHOST: 67. 23.34.37 [Sun May 03 23:10:34 2009] [info] APR LDAP: Built with OpenLDAP LDAP SDK [Sun May 03 23:10:34 2009] [info] LDAP: SSL support available [Sun May 03 23:10:34 2009] [notice] jrApache[init] JRun 4.0 (Build 108673) Apache 2.2 module - Mar 14 2008 01:19:38 [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24700 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24700 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24703 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24703 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24704 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24704 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24705 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24705 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24706 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1967): proxy: initialized single connection worker 0 in child 24706 for (*) [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1854): proxy: grabbed scoreboard slot 0 in child 24707 for worker proxy:reverse [Sun May 03 23:10:34 2009] [debug] proxy_util.c(1873): proxy: worker proxy:reverse already initialized [Sun May 03
Re: Apache and ColdFusion Trouble
I dont need mod_proxy or ldap. Can you tell me how to enable CF web server? can you enable web server in cf and see what happens? do you need mod_proxy and ldap supprt? have you enabled sandbox security? On Mon, May 4, 2009 at 17:29, Jas ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache and ColdFusion Trouble
I would disable any module in apache you don't need. poke around in jrun.xml - it's probably the easiest way to enable http in CF. you can double check your jrun port there too. On Mon, May 4, 2009 at 17:46, Jason Slack applesl...@gmail.com wrote: I dont need mod_proxy or ldap. Can you tell me how to enable CF web server? can you enable web server in cf and see what happens? do you need mod_proxy and ldap supprt? have you enabled sandbox security? On Mon, May 4, 2009 at 17:29, Jas ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache and ColdFusion Trouble
Can you tell me how to enable CF web server? http://www.adobe.com/support/coldfusion/adv_development/config_builtin_webserver/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: billing
In the case of 'no pay until complete', the situation has arisen in the past where the concept of 'complete' was at issue. We worked it out well, and both of us got good on the deal, but hopefully mentioning this will work as a word of caution... Clients don't always know the 'ins and outs' of our business, so their terminology tends to differ. (I recently have had the same functionality called different things in a meeting - modal window, ajax exploder, grayedout popup window..., just as an example). The differences between 'not complete' and 'additional functionality' is an area where some customers don't see the difference. Part of our jobs with customers like this is not only to protect ourselves with policies that make sense, is also to help educate the client. I have worked with people who require a portion up front before getting started, sometimes with 'milestones' for the next portion of the money. I have worked with people who start on a hand-shake. I have worked with people who invoice periodically (like I do). The most important thing is to do things in a way that makes you feel fiscally protected and the client understands/accepts. If you do things on a 'special' basis to win a client over, make sure that the 'special' method is an introductory thing and that in the future they will adhere to your current methodology. Be careful. As there are many supposed programmers out there that will take a client's money and never produce any results, there are many client's out there that will take your productivity and refuse to pay you for your work, sending you to a lawyer to recover your fees. Stay tuned for my next rant, 'Make it a practice to develop on your own servers' William -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Monday, May 04, 2009 1:06 PM To: cf-talk Subject: RE: billing Thanks for all the feedback. The original site was a $20k project in 2002. Now this redesign which is more complex is hitting the $40k range. I went back and looked closer at all the billing we have done in the past ( I was not in charge at that time of billing ) and I feel this new price is legitimate for the amount of labor we have in it. For these projects in the future I will be doing weekly billing... I have always liked to tell the customer that we wont bill them until the project is complete and they are absolutely happy with the result according to the quote we provide. I kind of got in that mindset and did not want to charge them until the project was done. Thanks! Learned my lesson. -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Monday, May 04, 2009 3:49 PM To: cf-talk Subject: Re: billing ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache and ColdFusion Trouble
Hi Maureen, OK, so I did: [r...@server1 ~]# apachectl stop [r...@server1 ~]# /opt/coldfusion8/bin/coldfusion stop [r...@server1 ~]# nano /opt/coldfusion8/runtime/servers/coldfusion/SERVER-INF/jrun.xml chanced built-in webserver to deactivated = false saved and exited [r...@server1 ~]# /opt/coldfusion8/bin/coldfusion start CF start, I get an error: Configuring the web server connector (Launched on the first run of the ColdFusion 8 start script) Running apache connector wizard... === There was an error while running the connector wizard Connector installation was not successful === == ColdFusion 8 has been started. ColdFusion 8 will write logs to /opt/coldfusion8/logs/cfserver.log == I can then hit 67.23.34.37:8500, I get an empty directory listing because there are no files there since I picked apache when I installed. if I try hitting just 67.23.34.37 I get a Page Load Error The cfserver.log says: Starting Macromedia JRun 4.0 (Build 108673), coldfusion server 05/04 22:46:28 warning Unable to open /opt/coldfusion8/runtime/lib/license.properties 05/04 22:46:30 info JRun Naming Service listening on *:2930 05/04 22:46:32 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 05/04 22:46:33 info JRun Web Server listening on *:8500 05/04 22:46:33 info JRun Proxy Server listening on *:51800 05/04 22:46:33 info Deploying enterprise application Adobe_ColdFusion_8 from: file:/opt/coldfusion8/ 05/04 22:46:33 info Deploying web application Adobe ColdFusion 8 from: file:/opt/coldfusion8/ 05/04 22:46:36 INFO License Service: Flex 1.5 CF Edition enabled 05/04 22:46:36 INFO Starting Flex 1.5 CF Edition 05/04 22:46:36 user JSPServlet: init 05/04 22:46:38 user ColdFusionStartUpServlet: init 05/04 22:46:38 user ColdFusionStartUpServlet: ColdFusion: Starting application services 05/04 22:46:38 user ColdFusionStartUpServlet: ColdFusion: VM version = 10.0-b19 05/04 22:46:39 Information [main] - Starting logging... 05/04 22:46:39 Information [main] - Starting license... 05/04 22:46:40 Information [main] - Enterprise Edition enabled 05/04 22:46:40 Information [main] - Starting crypto... 05/04 22:46:40 Information [main] - Installed JSafe JCE provider: Version 3.6 RSA Security Inc. Crypto-J JCE Security Provide$ 05/04 22:46:40 Information [main] - Starting security... 05/04 22:46:40 Information [main] - Starting scheduler... 05/04 22:46:40 Information [main] - Starting WatchService... 05/04 22:46:40 Information [main] - Starting debugging... 05/04 22:46:40 Information [main] - Starting sql... 05/04 22:46:40 Information [main] - Starting mail... 05/04 22:46:40 Information [main] - Starting runtime... 05/04 22:46:41 Information [main] - CORBA Configuration not enabled 05/04 22:46:41 Information [main] - Starting cron... 05/04 22:46:41 Information [main] - Starting registry... 05/04 22:46:41 Information [main] - Starting client... 05/04 22:46:42 Information [main] - Starting xmlrpc... 05/04 22:46:43 Information [main] - Starting graphing... 05/04 22:46:43 Information [main] - Starting verity... 05/04 22:46:43 Information [main] - Starting archive... 05/04 22:46:43 Information [main] - Starting document... 05/04 22:46:43 Information [main] - Starting eventgateway... 05/04 22:46:43 Information [main] - Starting Event Backend Handlers. 05/04 22:46:43 Information [main] - Initialized EventRequestDispatcher with a Thread Pool size of 10. 05/04 22:46:43 Information [main] - Initializing EventRequestHandler 05/04 22:46:43 Information [main] - Starting Event Gateways. 05/04 22:46:43 Information [main] - Starting FlexAssembler... 05/04 22:46:44 Information [main] - Starting .NET... 05/04 22:46:44 Information [main] - Starting Monitoring... 05/04 22:46:44 Information [main] - ColdFusion started 05/04 22:46:44 user ColdFusionStartUpServlet: ColdFusion: application services are now available 05/04 22:46:44 user CFMxmlServlet: init 05/04 22:46:44 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 05/04 22:46:44 INFO Macromedia Flex Build: 87315.134646 05/04 22:46:48 user CFSwfServlet: init 05/04 22:46:48 user CFCServlet: init 05/04 22:46:49 user FlashGateway: init 05/04 22:46:49 user MessageBrokerServlet: init 05/04 22:46:51 user CFFormGateway: init 05/04 22:46:51 user CFInternalServlet: init Server coldfusion ready (startup time: 24 seconds) -Jason I would disable any module in apache you don't need. poke around in jrun.xml - it's probably the easiest way to enable http in CF. you can double check your jrun port there too. On Mon, May 4, 2009 at 17:46, Jas ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial
Re: Apache and ColdFusion Trouble
OK, so I got myself to a state where I can hit :8500 with /opt/coldfusion8/wwwroot as my root I stopped apache and changed jrun.xml to use port 80 and I am broken again. Everything i do it CF and cgi, so do I even need apache? if I could get CF on port 80 would this nor work using the built-in web-server? Thoughts? -Jason Can you tell me how to enable CF web server? http://www.adobe.com/support/coldfusion/adv_development/config_builtin_webserver/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4