Re: Anyone know anything about this new ColdFusion conference?
+1 On 1 Feb 2011, at 02:31, Ben Forta wrote: I officially nominate this thread as the least productive on cf-talk ever. --- Ben Mark Drew Railo Technologies UK Professional Open Source skype: mark_railo email: m...@getrailo.com gtalk: m...@getrailo.com tel:+44 7971 85 22 96 tel (int): +13474485715 web:http://www.getrailo.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:341784 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone know anything about this new ColdFusion conference?
Dave, your right it doesn't seem to have made much difference yet, but as I have said many times before is the fact that the cf community does not cover the entire cf user base. There are a huge number of developers and users out there who do not participate in the community. Customers with CF driven websites on shared hosting etc, most of these people do not even know when a new version of CF comes out, let alone that there is an open source alternative. Even many within the community still don't know of the OSS alternatives. So just as you cannot build a website and they will come, you also can't just release an OSS cfml engine and expect everyone to know about it. Until CFML makes it into the main stream web media and is given some decent coverage then I don't really see how things can change. Currently CF gets nothing more than the odd mention/article. I recently had a letter published in a major net mag (unknown to me) which asked the editor why does CF rarely get mentioned and drew attention to the OSS alternatives and that you could use both for free on www.cfmldeveloper.com. Even this minor coverage resulted in a small surge of visits to www.cfmldeveloper.com, so I think that in itself shows that there is still interest and potential new users out there. I think the difficulties in getting Railo installed and working has been a big block for many, and the team did rather assume that being a developer meant you know about running a server, which is just not true as the average developer only knows how to code not run a server or maintain an OS, and thankfully has been addressed now with a new installer. Look at any PHP forum and you will see plenty of PHP developers who struggle to get PHP working properly or getting php apps to work locally, what you can also see is that many of these developers simply develop directly on their hosts servers and don't worry about those issues. This has always been a plus for CF, while the whole Java/Servlets container/CF setup is actually very complex, Adobe's click, install, go has always made it easy, but this still causes issues for many as they still need to get a web server, mail server and db server running as well which comes with its own challenges. There has always been a plethora of free/cheap php hosts out there to accommodate the php developers which has no doubt helped tremendously, and cfmldeveloper.com tries to do the same for cf developers, but I suspect very few people know about it outside the community, and those are the people you do want to know about resources that will help them with CFML, but how to get the word out is the problem. On Tue, Feb 1, 2011 at 4:38 AM, Dave Watts dwa...@figleaf.com wrote: Why do you think it's absurd to think that open source engines will bring more people? Because it doesn't seem to have done so, so far. Because the niche in which CF is popular doesn't seem to care that much about open source or free. Because there are plenty of other open source engines in other languages, and people who care a lot about that seem to have mostly already moved to one of those. Do you think the only thing that makes a language worth something, is how much it costs? No. I'm not sure where you got that from my previous responses. What about my argument about one in the bush, vs. none in the bush? That's not an argument, it's speculation. And say Adobe did drop CF-- do you think that would spell the end of the language? Yeah, I do. I don't think that everyone would switch to comparatively unknown, new alternatives. If a big company like Adobe can't guarantee the future of CF, why would anyone think that these other people can? 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:341785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone know anything about this new ColdFusion conference? [spamtrap bayes][spamtrap heur]
then move it there. +1 On Tue, Feb 1, 2011 at 2:49 AM, Paul Hastings p...@sustainablegis.comwrote: On 2/1/2011 12:46 PM, denstar wrote: First off, this portion of the discussion probably belongs on cf-community. then move it there. ~| 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:341786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Form Validation Issue using cfinput AND jquery
Sorry if this ends up being a dupe post. I'm working on a client site that already had a CF Form in place using cfinput and validation via required=yes We added some select boxes that are required and as most of you know CF forms don't really validate those. So, I am using jquery to validate the select boxes when the form is submitted. The problem I am running into is this: The jquery portion works AND the CF validation errors are thrown as well. But if I fill in all the selects that are validated via jquery and do not to fill in the fields that are being required via cfinput required=yes, the error is thrown but the form still submits. Is this because of the jquery on submit validation? Has anyone run into this before, is there an easy fix, outside of moving the cfinput validation into the jquery validation? Kelly Matthews Web Developer http://www.cfwebtools.com blog: http://kellymatthews.wordpress.com Twitter: @webdiva ~| 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:341787 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Form Validation Issue using cfinput AND jquery
I generally try to roll my own validation and just use form instead. You can much nicer validation. However with that being said I believe whatever you define in onSubmit=return bla will only fire if the cf validation passes. Ray explains it here: http://www.coldfusionjedi.com/index.cfm/2008/1/11/Ask-a-Jedi-Mixing-cfform-validation-and-ajaxbased-functions On Tue, Feb 1, 2011 at 12:02 PM, Kelly Matthews webd...@gmail.com wrote: Sorry if this ends up being a dupe post. I'm working on a client site that already had a CF Form in place using cfinput and validation via required=yes We added some select boxes that are required and as most of you know CF forms don't really validate those. So, I am using jquery to validate the select boxes when the form is submitted. The problem I am running into is this: The jquery portion works AND the CF validation errors are thrown as well. But if I fill in all the selects that are validated via jquery and do not to fill in the fields that are being required via cfinput required=yes, the error is thrown but the form still submits. Is this because of the jquery on submit validation? Has anyone run into this before, is there an easy fix, outside of moving the cfinput validation into the jquery validation? Kelly Matthews Web Developer http://www.cfwebtools.com blog: http://kellymatthews.wordpress.com Twitter: @webdiva ~| 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:341788 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Form Validation Issue using cfinput AND jquery
Is your JQuery validation returning false? Here is how I see it (I'm assuming here so don't shoot me)... CFValidation = false JQuery = true One result is true so it processes. CFValidation = true JQuery = false Same One result is true so it processes. CFValidation = false JQuery = false Both are false processing ends. CFValidation = true JQuery = true Both are true so it processes. You either need to change your cfvalidation to be jquery, or build a wrapper function for both validation that checks to make sure that both validate before moving on. Just a simple function that is, if CF or JQuery is false return false, if both true return true. Steve -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, February 01, 2011 12:16 PM To: cf-talk Subject: Re: Form Validation Issue using cfinput AND jquery I generally try to roll my own validation and just use form instead. You can much nicer validation. However with that being said I believe whatever you define in onSubmit=return bla will only fire if the cf validation passes. Ray explains it here: http://www.coldfusionjedi.com/index.cfm/2008/1/11/Ask-a-Jedi-Mixing-cffo rm-validation-and-ajaxbased-functions On Tue, Feb 1, 2011 at 12:02 PM, Kelly Matthews webd...@gmail.com wrote: Sorry if this ends up being a dupe post. I'm working on a client site that already had a CF Form in place using cfinput and validation via required=yes We added some select boxes that are required and as most of you know CF forms don't really validate those. So, I am using jquery to validate the select boxes when the form is submitted. The problem I am running into is this: The jquery portion works AND the CF validation errors are thrown as well. But if I fill in all the selects that are validated via jquery and do not to fill in the fields that are being required via cfinput required=yes, the error is thrown but the form still submits. Is this because of the jquery on submit validation? Has anyone run into this before, is there an easy fix, outside of moving the cfinput validation into the jquery validation? Kelly Matthews Web Developer http://www.cfwebtools.com blog: http://kellymatthews.wordpress.com Twitter: @webdiva ~| 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:341789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Form Validation Issue using cfinput AND jquery
I'm not sure that's correct. Using the same scenarios (and assuming the jquery validation is defined in onsubmit with return specified) here's my understanding: CFValidation = false - validation ends. JQuery = doesn't get processed. Form Doesn't Submit CFValidation = true JQuery = false - validation ends Form Doesn't Submit. CFValidation = false - validation ends. JQuery = doesn't get processed. Form Doesn't Submit. CFValidation = true JQuery = true *confetti* You either need to change your cfvalidation to be jquery, or build a wrapper function for both validation that checks to make sure that both validate before moving on. I don't _think_ that's true. However I could be wrong. ~| 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:341790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Hosting
Can anyone recommend a decent yet cheap web host for ColdFusion? Right now I'm hosting my site at DreamHost (Simple wordpress as CMS site). I didn't see anyone mention this, but for cheap hosting, but good service, you may want to consider looking at Railo hosting through Alurium.com. Personally I wouldn't touch GoDaddy hosting with a 20-foot pole. CF or otherwise. Horrible experiences with them. --- Mary Jo ~| 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:341791 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL Join Woes
Hello All! I'm trying my first Join of two tables and not having the best of luck... One table holds just a part number off our top 200 products, the second table holds a part number along with all the information that accompanies that part. I'm trying to pull back all the data from the information table that has a matching part number in my top 200 table. Here are a few ways i have tried : SELECT DISTINCT PartNumber FROM GriffinDataRevised WHERE PartNumber IN (SELECT part_number FROM Top200) -- This one brings back 15k results with tons of duplicates SELECT * FROM GriffinDataRevised WHERE PartNumber = (SELECT Part_Number FROM Top200 WHERE Top200.part_number = 'GriffinDataRevised.PartNumber') -- This one, no results shown SELECT DISTINCT PartNumber FROM GriffinDataRevised INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number WHERE Top200.part_number = GriffinDataRevised.PartNumber -- This one returns 98 results when there should be 200. I'm still trying to confirm if there are duplicate PN's in the list. Thank you, Aaron ~| 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:341792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
On 2/1/2011 9:41 AM, Aaron Renfroe wrote: Hello All! SELECT DISTINCT PartNumber FROM GriffinDataRevised INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number WHERE Top200.part_number = GriffinDataRevised.PartNumber INNER JOIN will enforce a filter that will only return records in a given 'partnumber' is in BOTH tables. The return of 98 recrods would indicate that there are only 98 values of 'partnumber' that are in both tables. If that is expected and known behavior then what you want is an OUTER JOIN that says return all records from one table PLUS any records from the other table IF they match. IE FROM GriffinDataRevised LEFT OUTER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number This will return all the records from the table on the LEFT side of the JOIN 'GriffinDataRevised' OR FROM GriffinDataRevised RIGHT OUTER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number This will return all the recrods from the table on the RIGHT side of the JOIN, 'Top200' Some database management systems support the FULL OUTER JOIN that will return unmatched records from BOTH sides of the join. ~| 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:341793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
a standard join looks like this.. select foo from a join b on a.id = b.id So yours would look something like SELECT PartNumber FROM GriffinDataRevised d JOIN Top200 t on d.partnumber = t.part_number You're not technically doing a join, you're doing a sub query. On Tue, Feb 1, 2011 at 11:41 AM, Aaron Renfroe mossma...@gmail.com wrote: Hello All! I'm trying my first Join of two tables and not having the best of luck... One table holds just a part number off our top 200 products, the second table holds a part number along with all the information that accompanies that part. I'm trying to pull back all the data from the information table that has a matching part number in my top 200 table. Here are a few ways i have tried : SELECT DISTINCT PartNumber FROM GriffinDataRevised WHERE PartNumber IN (SELECT part_number FROM Top200) -- This one brings back 15k results with tons of duplicates SELECT * FROM GriffinDataRevised WHERE PartNumber = (SELECT Part_Number FROM Top200 WHERE Top200.part_number = 'GriffinDataRevised.PartNumber') -- This one, no results shown SELECT DISTINCT PartNumber FROM GriffinDataRevised INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number WHERE Top200.part_number = GriffinDataRevised.PartNumber -- This one returns 98 results when there should be 200. I'm still trying to confirm if there are duplicate PN's in the list. Thank you, Aaron ~| 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:341794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
Hello Ian and thank you! I have tried both the left and right joins, the RIGHT join brought back the 15k results again, the LEFT join was bringing back so many that i killed the browser before it hurt something :) JOINS: SELECT * FROM GriffinDataRevised LEFT OUTER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number --This one seemed like a infinite loop was happening, crashed browser from results. SELECT * FROM GriffinDataRevised RIGHT OUTER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number 15k results again So if i know that its true that the Top200 table has 200 distinct part numbers and that the information table may have all 200 part numbers why how would i accomplish just getting the matching results for the 200 part numbers in the GriffinData table? It may be possible that the 98 results are the only parts that exist in the larger information table. But my query was still running wrong, correct? 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:341795 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
On 2/1/2011 10:22 AM, Aaron Renfroe wrote: Hello Ian and thank you! But my query was still running wrong, correct? Not necessarily, maybe your data is wrong. You may need to provide some more description on what data is in each of these tables and how you are trying to utilize it before we can help much more. IS there a ONE TO ONE or a ONE TO MANY relationship between Top200 and GriffinDataRevised? If ONE TO MANY, do you not want all the record from the MANY side? IF not all the records, which record of the MANY is the one that you want? ~| 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:341796 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
I guess it could be both. While some part numbers can fit multiple years, makes, and models of a vehicle others just fit one. The top 200 are our best selling radiators. In theory, i want to hit the master table, pull out all the information on the radiator based on the part number being supplied from the top 200. Here is a query with all the fields from the Master table, and the Top 200 table has nothing but a part number: SELECT GriffinDataRevised.PartNumber, GriffinDataRevised.Make, GriffinDataRevised.Model, GriffinDataRevised.Year, GriffinDataRevised.Engine, GriffinDataRevised.Edition, GriffinDataRevised.TransCooler, GriffinDataRevised.OilCooler, GriffinDataRevised.HorsePower, GriffinDataRevised.Comments, GriffinDataRevised.Outlets, GriffinDataRevised.TubeSize, GriffinDataRevised.Rows, GriffinDataRevised.CoreSize, GriffinDataRevised.Revision FROM GriffinDataRevised INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.part_number WHERE GriffinDataRevised.PartNumber = Top200.part_number ORDER BY Make DESC Does that help? Thank you so much for bearing with me. On another not, the query that brought back 98 results may have been working right, i found another 78 records in another table for race car radiators, i'm almost guessing that the last few are in another table that would make the total 200 records. But i'm now getting an error that the part_number field is ambiguous. Ugh Thank you! On Tue, Feb 1, 2011 at 1:47 PM, Ian Skinner h...@ilsweb.com wrote: On 2/1/2011 10:22 AM, Aaron Renfroe wrote: Hello Ian and thank you! But my query was still running wrong, correct? Not necessarily, maybe your data is wrong. You may need to provide some more description on what data is in each of these tables and how you are trying to utilize it before we can help much more. IS there a ONE TO ONE or a ONE TO MANY relationship between Top200 and GriffinDataRevised? If ONE TO MANY, do you not want all the record from the MANY side? IF not all the records, which record of the MANY is the one that you want? ~| 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:341797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
On 2/1/2011 11:35 AM, Aaron M Renfroe wrote: But i'm now getting an error that the part_number field is ambiguous. Ugh That just means that the field is in both (multiple) tables and the database wants you to tell it which table you want to use to get the value for this column to use in this record set. Just prepend that column name with a table name. You seem to be doing that in all the fields except the 'Make' field in the ORDER BY clause. Just add a table name to that field as well. ~| 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:341798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
On 2/1/2011 11:35 AM, Aaron M Renfroe wrote: On another note, the query that brought back 98 results may have been working right, i found another 78 records in another table for race car radiators, i'm almost guessing that the last few are in another table that would make the total 200 records. Then you are probably looking at three SELECT statements to return all the desired data for the record set. My first choice would probably to do all three SELECTS in a single query with a UNION clause to combine them into one record set. But this is not the only option available. ~| 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:341799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
Thank you! I will research the UNION Clause. You have been a great help! On Tue, Feb 1, 2011 at 3:13 PM, Ian Skinner h...@ilsweb.com wrote: On 2/1/2011 11:35 AM, Aaron M Renfroe wrote: On another note, the query that brought back 98 results may have been working right, i found another 78 records in another table for race car radiators, i'm almost guessing that the last few are in another table that would make the total 200 records. Then you are probably looking at three SELECT statements to return all the desired data for the record set. My first choice would probably to do all three SELECTS in a single query with a UNION clause to combine them into one record set. But this is not the only option available. ~| 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:341800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL query question
Since everyone should be in a SQL Join state of mind...here's another one. I have a weird issue that I haven't been able to narrow down yet. I'm trying to add a new field to one of my tables to store some additional information, but once I add the column, my previously working query breaks. Here's the query (obviously the person that originally wrote it is in the 'the fewer characters, the better' camp): SELECT p.*, pt.*, pm.Type AS mtype, s.fname AS sfname, s.lname AS slname, pa.DateActive AS PenAmountDate, pa.MonthlyAmount AS PenAmt, pa.Note AS PenAmtNote, s.SSN AS sssn, s.DOB AS sdob, spm.Type AS smt FROM PensionerMedicalType spm INNER JOIN PensionerSpouse s ON spm.MedicalID = s.MedicalType RIGHT OUTER JOIN PensionersActive p INNER JOIN PensionerType pt ON p.PensionerType = pt.PensionerTID LEFT OUTER JOIN PensionAmounts pa ON p.PenActID = pa.PenID LEFT OUTER JOIN PensionerMedicalType pm ON p.MedicalType = pm.MedicalID ON s.SpouseID = p.Spouse WHERE (p.PenActID = cfqueryparam cfsqltype=cf_sql_integer value=#id# AND pa.active = 1) As soon as I add a column named 'lifeInsType' to the PensionersActive (p) table, I get the following error when the same query runs: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. What am I overlooking? ~| 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:341801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Any Experiences with MediaSpa?
Fellow ColdFusion Community Members: Has anyone had any experience with MediaSpa, located in Rye, NY? I'm looking for any feedback - good / bad / indifferent. Please respond off-list to jobs [at] accessiblecomputing [dot] com. Thank you in advance! Sincerely, ~Christian ~| 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:341802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL query question
This might be an issue I've had to deal with before. Do something to change the fingerprint (no idea what the correct term would be) of the query - or restart cf. By change the fingerprint, it could be something as simple ad swapping p.* and pt.* (swapping as in their ordinal position in the select clause). In the past, what has happened is I'll have some query with at least one * in the select statement followed by one or more columns and I add a column to whatever I was selecting * from. If the query stays the same, it uses the same result-set template (again, im making up words - no idea what its really called) It doesn't know to check the underlying structure of the table. But the newly added column gets returned by the db - offsetting all the columns in the rest of the result set. So as crazy as it sounds - just change something in the sql, and give it a try. It doesn't have to actually change anything about what the query does - adding ,getdate() as helloworld will fix it - and then you can undo the change after one successful run. I assume this is something on CF's side - as restarting the CF service also fixes it. On Tue, Feb 1, 2011 at 4:23 PM, Debbie Morris deb_mor...@comcast.netwrote: Since everyone should be in a SQL Join state of mind...here's another one. I have a weird issue that I haven't been able to narrow down yet. I'm trying to add a new field to one of my tables to store some additional information, but once I add the column, my previously working query breaks. Here's the query (obviously the person that originally wrote it is in the 'the fewer characters, the better' camp): SELECT p.*, pt.*, pm.Type AS mtype, s.fname AS sfname, s.lname AS slname, pa.DateActive AS PenAmountDate, pa.MonthlyAmount AS PenAmt, pa.Note AS PenAmtNote, s.SSN AS sssn, s.DOB AS sdob, spm.Type AS smt FROM PensionerMedicalType spm INNER JOIN PensionerSpouse s ON spm.MedicalID = s.MedicalType RIGHT OUTER JOIN PensionersActive p INNER JOIN PensionerType pt ON p.PensionerType = pt.PensionerTID LEFT OUTER JOIN PensionAmounts pa ON p.PenActID = pa.PenID LEFT OUTER JOIN PensionerMedicalType pm ON p.MedicalType = pm.MedicalID ON s.SpouseID = p.Spouse WHERE (p.PenActID = cfqueryparam cfsqltype=cf_sql_integer value=#id# AND pa.active = 1) As soon as I add a column named 'lifeInsType' to the PensionersActive (p) table, I get the following error when the same query runs: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. What am I overlooking? ~| 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:341803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL query question
On 2/1/2011 1:23 PM, Debbie Morris wrote: What am I overlooking? The evil of using * in SELECT clauses. When that is done, database drivers are know to cache the columns and datatypes of the SQL queries. Then somebody comes along and changes the database structure, like you adding a field. Now the database structure does not match the cached structure stored by the database driver and this type of disconnect occurs. The solution: Replace those p.* and pt.* short cuts with that actual columns you need in your record set. ~| 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:341804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL query question
On 2/1/2011 2:21 PM, Charlie Stell wrote: I assume this is something on CF's side - as restarting the CF service also fixes it. Not ColdFusion itself, but the database drivers used by ColdFusion and the cached (pooled) data source settings. Changing the Datasource to not used pooled settings might eliminate the caching of the database columns and types. But I have never tried it, having long ago accepted the better practice of not using * in my SQL. ~| 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:341805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL query question
The evil of using * in SELECT clauses. I'm with Ian on this 100%. Often times developers think that using * will be faster, and easier and allow more flexibility. However that couldn't be further from the truth as you are seeing now. Take Ian's advice and define each column you want from your query. The added bonus is that there's no extra overhead associated with returning columns you aren't using. ~| 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:341806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL query question
I'm 100% with you guys on this as well. Replacing the hundreds of select * from all the existing code here is one of my seemingly never ending tasks. I should have addressed that first before attempting to add anything else to the mix. I'm done installing my Windows updates for the evening, so I'll tackle this again in the morning. Thanks for the help! Debbie -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, February 01, 2011 5:41 PM To: cf-talk Subject: Re: SQL query question The evil of using * in SELECT clauses. I'm with Ian on this 100%. Often times developers think that using * will be faster, and easier and allow more flexibility. However that couldn't be further from the truth as you are seeing now. Take Ian's advice and define each column you want from your query. The added bonus is that there's no extra overhead associated with returning columns you aren't using. ~| 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:341807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion 8: Does something like a cfContinue exist?
I'm running Coldfusion 8. Trying to use a cfloop over a query. I need to go to the next index/user/database-row if some condition is met after generating my report. I asked yesterday, was given CFcontinue but tried it today and it's only for ColdFusion 9. Here's what I've tried: Method: cfthrow type=continue Result: Behaves like a Break Method: cfscript Continue; /cfscript Result: Behaves like a Break Please 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:341808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8: Does something like a cfContinue exist?
Adam, as I suggested yesterday (if you are pre cf8) you will need to do some conditional evaluation. pseudo code: set var doContinue = false; if ( conditions are met ) { doContinue = true; } if ( doContinue ) { -- put all the rest of your processing code here and only run it if your conditions were met. } On Tue, Feb 1, 2011 at 6:26 PM, Adam Bourg adam.bo...@gmail.com wrote: I'm running Coldfusion 8. Trying to use a cfloop over a query. I need to go to the next index/user/database-row if some condition is met after generating my report. I asked yesterday, was given CFcontinue but tried it today and it's only for ColdFusion 9. Here's what I've tried: Method: cfthrow type=continue Result: Behaves like a Break Method: cfscript Continue; /cfscript Result: Behaves like a Break Please 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:341809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8: Does something like a cfContinue exist?
*should be pre cf9. sorry. On Tue, Feb 1, 2011 at 6:39 PM, Michael Grant mgr...@modus.bz wrote: Adam, as I suggested yesterday (if you are pre cf8) you will need to do some conditional evaluation. pseudo code: set var doContinue = false; if ( conditions are met ) { doContinue = true; } if ( doContinue ) { -- put all the rest of your processing code here and only run it if your conditions were met. } On Tue, Feb 1, 2011 at 6:26 PM, Adam Bourg adam.bo...@gmail.com wrote: I'm running Coldfusion 8. Trying to use a cfloop over a query. I need to go to the next index/user/database-row if some condition is met after generating my report. I asked yesterday, was given CFcontinue but tried it today and it's only for ColdFusion 9. Here's what I've tried: Method: cfthrow type=continue Result: Behaves like a Break Method: cfscript Continue; /cfscript Result: Behaves like a Break Please 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:341810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ideas on additional resources to use in job search
Lesson ignored. On Thu, Jan 27, 2011 at 10:34 PM, Maureen mamamaur...@gmail.com wrote: Bluntly..stop begging for a job. Your frequent postings over the years have alienated any prospective employer who reads them. And your current bout of sarcasm and criticism of posters on the CF-TALK list isn't buying you any friends either. You need to take a long hard look at unprofessional your behavior on these lists are, because if you continue in your current path, you will never find work in the CF ar ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4422 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Any Experiences with MediaSpa?
Fellow ColdFusion Community Members: Has anyone had any experience with MediaSpa, located in Rye, NY? I'm looking for any feedback - good / bad / indifferent. Please respond off-list to jobs [at] accessiblecomputing [dot] com. Thank you in advance! Sincerely, ~Christian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4423 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
this conversation about mediaspa
To all, so that you all know I didn't start this one he came to me asking. perhaps some good will come out of it though and whether if you think its professional or not, it is only right that companies and other developers treat each other with the same respect and try not to crucify each other. i am as guilty as the next guy in this too, so before you go on your holy run there Maureen calm down. we wonder why coldfusion is dying. the answer is simple. look in the mirror. Mike ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4424 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Re: other companies and developers to watch out for
Add me to your list. I just think you are a big dickhead. Sent from my iPad On Feb 1, 2011, at 6:07 PM, mftr...@att.net mftr...@att.net wrote: I ve accepted the fact that I will not probably get another job from this list so you know what who cares. So i might as well empty the closet on all those who I think have done a lot of damage to our career field. companies and developers to watch out for mediaspa - for whatever reason if you get on their bad side watch out colony1 - i ve added mr. adams company because he made an attempt at trying to crucify me in a public arena. i tried apologizing to no avail. i have also worked for adam in the past. i always thought we parted ways on a good note. guess i was wrong. talk about grudges. topofmind - this is an atlanta company that asked to interview twice then said we change our minds even though they told me they were going to hire me. heck i tried apologizing too even though they wronged me. oh well. elliot kayne - another gentleman that said he would hire me then backed out. wish you guys would make up your mind. by the way he runs onlinecorp.com and quickcart.com. watch out he will string you along too. superwarehouse.com - rand will talk to you but wont return your emails once hes made up his mind. ken fergurson - wow . an oldie but goodie. even had a few people asked about him. hope you didnt ruin your career either. maureen with a gmail address - another attempt at crucifying me. seems like a double standard here. you tell me i am disturbing you but you call me out in public too. I do want to thank the gentleman at Adobe who will remain nameless for the free copy of cfbuilder. Alas it wasn't meant to be. I do think there are more good people than bad, but the bad do leave an odor. So anyone who may have a question regarding the above I will give my perspective. I know i also hear from some of you but I dont really care because lets face i wont get a job from here and to be honest i dont think i want one. Mike Firth ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4427 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Re: other companies and developers to watch out for
Does this mean you'll unsubscribe from the list? I'm sure a number of people have asked you to do so (respectfully). I sincerely wish you the best of luck in your next career choice. On Tue, Feb 1, 2011 at 4:07 PM, mftr...@att.net mftr...@att.net wrote: I ve accepted the fact that I will not probably get another job from this list so you know what who cares. So i might as well empty the closet on all those who I think have done a lot of damage to our career field. companies and developers to watch out for mediaspa - for whatever reason if you get on their bad side watch out colony1 - i ve added mr. adams company because he made an attempt at trying to crucify me in a public arena. i tried apologizing to no avail. i have also worked for adam in the past. i always thought we parted ways on a good note. guess i was wrong. talk about grudges. topofmind - this is an atlanta company that asked to interview twice then said we change our minds even though they told me they were going to hire me. heck i tried apologizing too even though they wronged me. oh well. elliot kayne - another gentleman that said he would hire me then backed out. wish you guys would make up your mind. by the way he runs onlinecorp.com and quickcart.com. watch out he will string you along too. superwarehouse.com - rand will talk to you but wont return your emails once hes made up his mind. ken fergurson - wow . an oldie but goodie. even had a few people asked about him. hope you didnt ruin your career either. maureen with a gmail address - another attempt at crucifying me. seems like a double standard here. you tell me i am disturbing you but you call me out in public too. I do want to thank the gentleman at Adobe who will remain nameless for the free copy of cfbuilder. Alas it wasn't meant to be. I do think there are more good people than bad, but the bad do leave an odor. So anyone who may have a question regarding the above I will give my perspective. I know i also hear from some of you but I dont really care because lets face i wont get a job from here and to be honest i dont think i want one. Mike Firth ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4428 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Re: other companies and developers to watch out for
Well said. Sent from a mobile device. Please excuse any typos. On Feb 1, 2011, at 6:15 PM, Ray Champagne r...@raychampagne.com wrote: Add me to your list. I just think you are a big dickhead. Sent from my iPad On Feb 1, 2011, at 6:07 PM, mftr...@att.net mftr...@att.net wrote: I ve accepted the fact that I will not probably get another job from this list so you know what who cares. So i might as well empty the closet on all those who I think have done a lot of damage to our career field. companies and developers to watch out for mediaspa - for whatever reason if you get on their bad side watch out colony1 - i ve added mr. adams company because he made an attempt at trying to crucify me in a public arena. i tried apologizing to no avail. i have also worked for adam in the past. i always thought we parted ways on a good note. guess i was wrong. talk about grudges. topofmind - this is an atlanta company that asked to interview twice then said we change our minds even though they told me they were going to hire me. heck i tried apologizing too even though they wronged me. oh well. elliot kayne - another gentleman that said he would hire me then backed out. wish you guys would make up your mind. by the way he runs onlinecorp.com and quickcart.com. watch out he will string you along too. superwarehouse.com - rand will talk to you but wont return your emails once hes made up his mind. ken fergurson - wow . an oldie but goodie. even had a few people asked about him. hope you didnt ruin your career either. maureen with a gmail address - another attempt at crucifying me. seems like a double standard here. you tell me i am disturbing you but you call me out in public too. I do want to thank the gentleman at Adobe who will remain nameless for the free copy of cfbuilder. Alas it wasn't meant to be. I do think there are more good people than bad, but the bad do leave an odor. So anyone who may have a question regarding the above I will give my perspective. I know i also hear from some of you but I dont really care because lets face i wont get a job from here and to be honest i dont think i want one. Mike Firth ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4429 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm