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 version for
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
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
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
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
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
/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
.
;)
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;
But that's not legal. Any thoughts
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
_/_/_/_/
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 Mystery Words:
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() combined
with DISTINCT is a 3.23.2+ feature
11 matches
Mail list logo