Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: 05 January 2005 01:46
To: CF-Talk
Subject: Re: SQL group by instead of cfoutput group?
>Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically
>ensure that you don't have any duplicate rows in you
lol!
actually it woulda been nice as i was in kentucky and the ice storm knocked out
power out for 3 days, so we huddled around the coal stove
-- Original Message --
From: S. Isaac Dealey <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Wed, 5
> tiz amazing and i will leave it at that as im trying to be
> good :) (i got coal in stockings this yr)
So Santa says to a kid "you should be good, you don't want to get coal
in your stocking" and the kid asks "what's coal?" and Santa says
"well... it's kind of a rock that burns"... and the kid s
hehe
i tried not to, i really did! but it just kept knawin at me haha
i think most ppl just get wrong impression from me, i dont say things to well
on here sometimes though (ok all the time)
but its all good
i even refrained from slappin up that big post from after ebay pulled all its
.net stu
>there isnt some whifty nifty whizbang thing from .net 4 that?
You are a trip dude!! I KNEW you were gonna post with somethin like this. I
KNEW it!!
Hell, I don't blame you though! Ya got me!
I don't have time to learn .net for this project. For me, CF is kinda like
sittin in front of a warm
there isnt some whifty nifty whizbang thing from .net 4 that?
-- Original Message --
From: Will Tomlinson <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Tue, 04 Jan 2005 21:46:11 -0400
>>Just add 'DISTINCT' after 'SELECT' and SQL Server will
What is the sql you have now?
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 8:46 PM
To: CF-Talk
Subject: Re: SQL group by instead of cfoutput group?
>Just add 'DISTINCT' after 'SELECT' and SQL Server will automat
>Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically
>ensure that you don't have any duplicate rows in your result set. Oh,
>and go check out CFQUERYPARAM and use it. It'll save you lots of
>headaches.
I tried DISTINCT and it still returns duplicate prodmodelcodes. How can I wee
Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically
ensure that you don't have any duplicate rows in your result set. Oh,
and go check out CFQUERYPARAM and use it. It'll save you lots of
headaches.
cheers,
barneyb
On Tue, 04 Jan 2005 21:04:20 -0400, Will Tomlinson <[EMAIL PROT
9 matches
Mail list logo
