Re: my final 1064 error

Matthew >SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate, Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID >FROM Vouchers >WHERE (((DateDiff('d',[StartDate],Date()))>=0) AND ((DateDiff('d',[EndDate],Date()))<=0)); Square brackets and your DateDiff syntax are MS

my final 1064 error

Here is my final problem that I am struggling to overcome... SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate, Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID FROM Vouchers WHERE (((DateDiff('d',[StartDate],Date()))>=0) AND ((DateDiff('d', [EndDate],Date()))<=0

Re: SQLquery: delimiter // - #1064 error

o: Dave Kennedy; mysql@lists.mysql.com Subject: RE: SQLquery: delimiter // - #1064 error Hi Dave, The DELIMITER statement is a command to the mysql client not an SQL statement. This is why phpAdmin is objecting. Here are a listing of the mysql client commands http://dev.mysql.com/doc/refm

RE: SQLquery: delimiter // - #1064 error

ssage- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 2:59 PM To: Dave Kennedy; mysql@lists.mysql.com Subject: RE: SQLquery: delimiter // - #1064 error Hi Dave, The DELIMITER statement is a command to the mysql client not an SQL statement. Th

RE: SQLquery: delimiter // - #1064 error

148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Dave Kennedy [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 November 2005 9:25 AM To: mysql@lists.mysql.com Subject: SQLquery: delimiter // - #1064

SQLquery: delimiter // - #1064 error

Windows XP phpMyAdmin 2.7.0-rc1 MySQL 5.0.16-nt running on localhost as [EMAIL PROTECTED] The DELIMITER statement works in the command line, but not in phpmyadmin (see error below) mysql> DELIMITER // mysql> use mysql // Database changed mysql> PHPmyadmin === DELIMITER

Re: 1064 error

Schalk Neethling wrote: > 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 M

Re: 1064 error

Thanks Roger, I wondered whether it was the spaces that caused the problem. Roger Baklund wrote: Schalk Neethling wrote: 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

Re: 1064 error

Schalk Neethling wrote: 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

1064 error

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