On Fri, 03 Dec 2004 10:58:30 -0700, Steve Grosz wrote:
>
> I wrote my query as
> select Cust_ID, Cust_Name
> from mailings
> where ucase(Name) = ucase(Cust_Name)
>
> When it runs, I get a error:
> You have an error in your SQL syntax; check the manual that corresponds
> to your MySQL server versi
Does Name exist as a column in your table, or is it a ColdFusion variable?
I know very little about how ColdFusion works, but it does parse the
query, and alter it, before it gets sent to ODBC. Just looks like it's
using ucase(Name) as a coldfusion function, then replacing it in the query.
Just
I am writing this by hand, and is being used within Coldfusion.
MySql is v 4.1.7 and I am connecting via ODBC.
Steve
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Your sample query is not valid SQL. What tool/language are you using to
> run this query? There must be something int
Your sample query is not valid SQL. What tool/language are you using to
run this query? There must be something interpreting what you entered and
mis-representing your query to the MySQL server. Without that piece of the
puzzle I am completely in the dark.
It would also help to know what versio
I am kinda new to SQL, and am having a problem trying to get something done.
I'm trying to search for usernames in one of my tables. The name is
stored as firstname lastname.
I wrote my query as
select Cust_ID, Cust_Name
from mailings
where ucase(Name) = ucase(Cust_Name)
When it runs, I get a er
r 18, 2001 10:53 AM
To: Chris Blessing; [EMAIL PROTECTED]
Subject: RE: general sql question
>
> I have a feeling this has something to do with running 3.22
> instead of 3.23.
> ;)
>
> Whadya think?
>
Oops... Yup, according to page 57 of Mr. Dubois' MySQL COUNT() combine
>
> I have a feeling this has something to do with running 3.22
> instead of 3.23.
> ;)
>
> Whadya think?
>
Oops... Yup, according to page 57 of Mr. Dubois' MySQL COUNT() combined
with DISTINCT is a 3.23.2+ feature...
I'll be interested to see the proper answer to this... (besides 'upgrade' -
I
> > select count(distinct(email)) from subscribes;
> >
> > But that's not legal. Any thoughts/ideas you all could send in would be
> > great. TIA!
> >
> > Chris Blessing
> > [EMAIL PROTECTED]
> > http://www.330i.net
> >
Try:
select count(distinct email) from subscribes;
Jay Fesco
Magical M
>
> select count(distinct(email)) from subscribes;
select count(distinct email) from subscribes;
should work just fine
Magic word: sql
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_
stead of 3.23.
;)
Whadya think?
-Chris
-Original Message-
From: Matthias Ragaz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 10:32 AM
To: Chris Blessing; [EMAIL PROTECTED]
Subject: Re: general sql question
>
>select count(distinct(email)) from subscribes;
>
>B
/manual_MySQL_Optimization
.html#MySQL_indexes
cheers
Leon
-Original Message-
From: Chris Blessing [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 15:20
To: Leon Noble
Subject: RE: general sql question
Leon-
Thank you very much for your help. I tried what you stated below and I
think the
Hi all-
I know this might seem simple, but for some reason I'm stumped. What I'm
trying to do is get a count (from one table) of all the distinct values in a
particular field. So for example, I'd be trying to find out how many unique
email addresses are in the table.
Right now I'm doing this w
12 matches
Mail list logo
