RE: Declared SQL variables in select statement error

looks good! Michael Traher -Original Message- From: Chris More [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 15:50 To: CF-Talk Subject: Declared SQL variables in select statement error Why can I execute this statement fine in MS SQL Analyzer: DECLARE @q1 varchar(7) SELECT @q1 = period

RE: Declared SQL variables in select statement error

riginal Message- From: Chris More [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 09:50 AM To: CF-Talk Subject: Declared SQL variables in select statement error Why can I execute this statement fine in MS SQL Analyzer: DECLARE @q1 varchar(7) SELECT @q1 = period_name FROM adj_periods WHER

Declared SQL variables in select statement error

Why can I execute this statement fine in MS SQL Analyzer: DECLARE @q1 varchar(7) SELECT @q1 = period_name FROM adj_periods WHERE period_id = 1 And If I try to do this in CF: DECLARE @q1 varchar(7) SELECT @q1 = period_name FROM adj_periods WHERE period_id = 1 I get this error: QUERY The Q