Are you using select * to get the records? If so, get rid of that and
name the select columns from p.
select p.area, p.bedrooms, p.bathrooms
from ...
etc
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 4 October 2010 11:28, Rick Faircloth ric...@whitestonemedia.com
I tried the group by, but as I suspected, that only
would work to eliminate duplicate *records*. What I was
getting is duplicate *fields* within each record.
However, James has the solution. See my reply to him...
Thanks, Michael!
Rick
-Original Message-
From: Michael Grant
Yes, distinct or a group by.
This should work:
select *
fromproperties p
where p.mls_number not in ( select pc.mls_number from
properties_copy pc where pc.mls_number is not null and pc.mls='hmls' )
and p.mls = 'hmls'
and p.mls_number is not null
And if not
Yes, once I got the query working (except for the duplicate fields)
I swapped to select * to avoid having to type the 50 or so fields
involved. It works elsewhere, so I figured it should here.
But as soon as I starting specifically naming the fields, the
duplication cleared up.
I would love to
I swapped to select * to avoid having to type the 50 or so
fields involved.
SOT: Point of note, regardless of how tedious this task may seem you should
always select only the fields you are using. Unless you know that you are
using all fields in a table and that the table columns will never
Naming all the columns also prevents issues with incorrect pooled
statements being cached when you add a column to the DB.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 4 October 2010 22:14, Michael Grant mgr...@modus.bz wrote:
SOT: Point of note, regardless of how
In any join query, when you select *, you'll get all columns from both
tables you've joined. It doesn't matter if the columns are named the
same; since they are in different tables they are providing different
data and are returned as separate columns.
--
WSS4CF - WS-Security framework for CF
Donnie, if you have CF8 or higher, you might find TrafficMunkey does the trick.
My company is releasing this as a free download today. It's a framework that
allows you to use real URLs while still retaining all of the benefits of a
framework, like site templates and exit actions.
For your
Hi All-
This question is not directly related to Coldfusion. I just came across the
below lectures on algorithms from MIT. Does it help to know those concepts to
get better in Coldfusion?
Were you the one asking for a way to generate the url's from the database?
Then this may be the solution for you.
http://www.helicontech.com/ape/
particularly this feature.
http://www.helicontech.com/ape/doc/mod_seo.htm
Russ
Subject: Fake URLS
From: Donnie Carvajal
Date: Fri, 1 Oct 2010
I don't understand your implementation so I can't answer the question properly.
Why the fascination with cfgrid? Are you updating text input fields in the grid
or is it some other functionality that you want to implement from cfgrid?
Sorting, paging, etc? Please explain.
Hi all,
I'm trying to install the W3C Validator on a windows machine. It uses
Perl to do the validations, and I have tried both ActivePerl and
Strawberry Perl. I've tried installing one of the needed perl Modules
(SGML:Parser:OpenSP) and I can't seem to get it to work.
I installed OpenSP
I'm trying to install the W3C Validator on a windows machine. It uses
Perl to do the validations, and I have tried both ActivePerl and
Strawberry Perl. I've tried installing one of the needed perl Modules
(SGML:Parser:OpenSP) and I can't seem to get it to work.
I installed OpenSP (part of
Oh yes! The problem isn't specifically with perl, it is with installing
the required Perl Module SGML:Parser:OpenSP.
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Monday, October 04, 2010 3:23 PM
To: cf-talk
Subject: Re: WOT: W3C Validator install on Windows
For those of you who have used FCKEditor over the years may already know the
new CKEditor has split away from the file uploading and creating CKFinder.
Both tools so far have been awesome and I've been trying to incorporate them
both into our sites with pretty good success except the merging
I don't understand your implementation so I can't answer the question
properly. Why the fascination with cfgrid? Are you updating text input
fields in the grid or is it some other functionality that you want to
implement from cfgrid? Sorting, paging, etc? Please explain.
Yes, I would be
Good day, CFers,
I'm looking for beta testers for a new framework. We've been using it with
MillionMunkeys sites for the past year, but now we want to make it available to
the entire CF community as a free download, and see if it helps others as much
as it helps us, plus how the community
Honestly, I think you could get it working in cfgrid but it seems like you
are trying to build something that would require more info of scope to hash
out how it would work. This is where I step off this thread...
~|
Order the
The topics on that page won't be obviously beneficial to most
ColdFusion programmers.
-Mike Chabot
On Mon, Oct 4, 2010 at 12:25 PM, fun and learning
funandlrnn...@gmail.com wrote:
Hi All-
This question is not directly related to Coldfusion. I just came across the
below lectures on
The topics on that page won't be obviously
beneficial to most ColdFusion programmers.
I agree, with a note that these topics appear to be lower-level in nature
than CF programmers have to deal with. CF is essentially an abstraction of
Java at this point, which itself is a high-level language
On Mon, Oct 4, 2010 at 9:25 AM, fun and learning
funandlrnn...@gmail.com wrote:
This question is not directly related to Coldfusion. I just came across the
below lectures on algorithms from MIT. Does it help to know those concepts to
get better in Coldfusion?
I'd say that it is definitely worthwhile to have an understanding of
how algorithms work. Programmers should have a rough understanding of
whether the way they are tackling a problem is O(n) or O(n^2) for
instance. Is it better to solve a problem iteratively or recursively?
You probably won't
Using input type=file works great to let a user point to a file...
but how do you let the user browse and point to a Directory?
I am trying to figure out how to let a user browse to a particular
directory location on their network and then capture that location for
future use. In this instance
Using input type=file works great to let a user point to a file...
but how do you let the user browse and point to a Directory?
I am trying to figure out how to let a user browse to a particular
directory location on their network and then capture that location for
future use. In this
also u do not need to remember the path as this is the default behaviour of
windows. When you open a browse window it always takes you to the last
location you used.
On Tue, Oct 5, 2010 at 12:15 AM, Dave Watts dwa...@figleaf.com wrote:
Using input type=file works great to let a user point to
Well the purpose is to capture and store the Directory as part of a
configuration routine. Then days in the future other users of the
application will trigger it to process some datafiles... but
coldfusion needs to know where those datafiles are located. The
current user has no idea where they
AIR is not the only method, but you can't get it done with just html. You will
need A java applet or flash or air or some other program that can talk to the
system as well as your app.
--
William Seiter
On Oct 4, 2010, at 4:39 PM, Gonzo Rock gonzor...@gmail.com wrote:
You might be best off just having them type it in, and complain if it
doesn't exist. These are users at a high enough level that they're
configuring things, yes? Maybe the simplest solutions is the best.
Dave
On Mon, Oct 4, 2010 at 7:47 PM, William Seiter will...@seiter.com wrote:
AIR is not
agh! Just noticed that techniques developed to capture the
network path no longer work... c:/fakepath Expect that is
because of a security upgrade that has occurred with browsers in the
last few years... as hinted at by Dave Watts when he said... not
possible.
Yes perhaps typing it in
agh! Just noticed that techniques developed to capture the
network path no longer work... c:/fakepath Expect that is
because of a security upgrade that has occurred with browsers in the
last few years... as hinted at by Dave Watts when he said... not
possible.
To the best of my
I am glad you said that. I thought it was me. I never had a software
company be as rude to me as smartertools. They detected that I had
the software running on 2 servers and sent me a really rude invoice
asking me to pay for the second licence. I wrote back explaining how
the licence
Since version 3 no longer requires an API key for the Google Maps API, does
anyone know a way around CF's restriction of needing one for using cfmap?
Eric
~|
Order the Adobe Coldfusion Anthology now!
Hi,
We have an urgent requirement for Web Developer in MD, please review the
job description and forward your resume with expected hourly rate.
Here is the job description:
Title: Web Developer - Cold Fusion
Location: Patuxent River , MD
Duration: 3 months contract to hire
Description:
33 matches
Mail list logo