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