Re: Anyone know anything about this new ColdFusion conference?

2011-02-01 Thread Mark Drew
+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

Re: Anyone know anything about this new ColdFusion conference?

2011-02-01 Thread Russ Michaels
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

Re: Anyone know anything about this new ColdFusion conference? [spamtrap bayes][spamtrap heur]

2011-02-01 Thread Gerald Guido
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.

Form Validation Issue using cfinput AND jquery

2011-02-01 Thread Kelly Matthews
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

Re: Form Validation Issue using cfinput AND jquery

2011-02-01 Thread Michael Grant
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:

RE: Form Validation Issue using cfinput AND jquery

2011-02-01 Thread DURETTE, STEVEN J (ATTASIAIT)
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

Re: Form Validation Issue using cfinput AND jquery

2011-02-01 Thread Michael Grant
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 -

Re: Coldfusion Hosting

2011-02-01 Thread Mary Jo Sminkey
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.

SQL Join Woes

2011-02-01 Thread Aaron Renfroe
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

Re: SQL Join Woes

2011-02-01 Thread Ian Skinner
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

Re: SQL Join Woes

2011-02-01 Thread Greg Morphis
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

Re: SQL Join Woes

2011-02-01 Thread Aaron Renfroe
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

Re: SQL Join Woes

2011-02-01 Thread Ian Skinner
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

Re: SQL Join Woes

2011-02-01 Thread Aaron M Renfroe
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

Re: SQL Join Woes

2011-02-01 Thread Ian Skinner
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

Re: SQL Join Woes

2011-02-01 Thread Ian Skinner
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

Re: SQL Join Woes

2011-02-01 Thread Aaron M Renfroe
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

SQL query question

2011-02-01 Thread Debbie Morris
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.

Any Experiences with MediaSpa?

2011-02-01 Thread Christian N. Abad
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

Re: SQL query question

2011-02-01 Thread Charlie Stell
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

Re: SQL query question

2011-02-01 Thread Ian Skinner
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.

Re: SQL query question

2011-02-01 Thread Ian Skinner
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

Re: SQL query question

2011-02-01 Thread Michael Grant
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

RE: SQL query question

2011-02-01 Thread Debbie Morris
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,

Coldfusion 8: Does something like a cfContinue exist?

2011-02-01 Thread Adam Bourg
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:

Re: Coldfusion 8: Does something like a cfContinue exist?

2011-02-01 Thread Michael Grant
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

Re: Coldfusion 8: Does something like a cfContinue exist?

2011-02-01 Thread Michael Grant
*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;

Re: ideas on additional resources to use in job search

2011-02-01 Thread Cameron Childress
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

Any Experiences with MediaSpa?

2011-02-01 Thread Christian N. Abad
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

this conversation about mediaspa

2011-02-01 Thread Michael Firth
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

Re: other companies and developers to watch out for

2011-02-01 Thread Ray Champagne
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

Re: other companies and developers to watch out for

2011-02-01 Thread Seth MacPherson
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

Re: other companies and developers to watch out for

2011-02-01 Thread Adam Cohen
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: