Konstantin Berman writes:
 > Hi.
 > 
 > I try to run the following query with DBD:ADO driver:
 > -----------------------------------------------------
 > set nocount on
 > 
 > declare @beforedate datetime,
 >      @date datetime,
 >      @casinoid int,
 >      @playertype INT,
 >      @gamingserverID int,
 >      @date2order datetime,
 >         @Month integer,
 >         @Year  integer,
 >         @DAY INT,
 >         @currdate datetime,
 >         @strDate varchar(30) 
 >      
 > SET @currdate = GetDate() 

Err... that should be 

       select @currdate = getdate()

(same with all the other variable assignements.)

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
[EMAIL PROTECTED] - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com

Reply via email to