From: Schalk Neethling (schalkvolume4.com)
Date: Sun Sep 18 2005 - 18:08:44 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Greetings

What might be causing the 1064 error in the following query?

SELECT mem_number, first_name, last_name, area_represented,
joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge
+ Eastern Cape Classic + SA Model Super Star + KZN Model GP + Mpumalanga
GP + Glam Slam Model Challenge + Model Man Woman + SA Look of the Year +
SA Face of the Year + KZN Classic + Eastern Cape GP + Western Cape
Classic + Free State Classic + North West GP + Northern Province Classic
+ SA Model Open + Cover Search + Champion of Champions + Northern Cape
Classic + Goldfields Model GP + Limpopo Classic + SA Model Portfolio +
Top Model Challenge + Gauteng Model Classic + Year of the Model AS
total_points
FROM modelcup.ab_leader_board

All of the rows does exist in the table and all row names are correct. TYIA!

--
Kind Regards
Schalk Neethling
Web Developer.Designer.Programmer.President
Volume4.Business.Solution.Developers
emotionalize.conceptualize.visualize.realize
Landlines
Tel: +27125468436
Fax: +27125468436
Web
email:schalkvolume4.com
Global: www.volume4.com
Messenger
Yahoo!: v_olume4
AOL: v0lume4
MSN: volume4_hotmail.com

We support OpenSource
Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/
 
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error, please contact the sender and please delete all traces of this material from all devices.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]