*should be pre cf9. sorry.
On Tue, Feb 1, 2011 at 6:39 PM, Michael Grant 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;
> }
>
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
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:
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,
>
> 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 yo
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 setting
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.
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
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
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.
He
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 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 record
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 r
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
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
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
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 GriffinDa
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
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 tha
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 inform
>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.
P
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
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 a
I generally try to roll my own validation and just use 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/
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
>>then move it there.
+1
On Tue, Feb 1, 2011 at 2:49 AM, Paul Hastings wrote:
>
> 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.
>
>
~
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
dr
+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 2
27 matches
Mail list logo