Re: General Sql question

2004-12-04 Thread Jochem van Dieten
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

General Sql question

2004-12-03 Thread Steve Grosz
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

Re: General Sql question

2004-12-03 Thread SGreen
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

Re: General Sql question

2004-12-03 Thread Steve Grosz
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

Re: General Sql question

2004-12-03 Thread Chris
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

general sql question

2001-10-18 Thread Chris Blessing
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

RE: general sql question

2001-10-18 Thread Leon Noble
/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

RE: general sql question

2001-10-18 Thread Chris Blessing
. ;) 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

Re: general sql question

2001-10-18 Thread Rafal Jank
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 _/_/_/_/

RE: general sql question

2001-10-18 Thread Jay Fesco
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:

RE: general sql question

2001-10-18 Thread Chris Blessing
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