declare them before the AS?
-----Original Message-----
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 12:38
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] SQL question
Okay...
I am getting an error which says I haven't declared two variables. Whereas,
the variables are declared directly above this.
Here is the code:
CREATE PROCEDURE spblah
@lstblah varchar(1000)
AS
DECLARE @list varchar(1000)
DECLARE @patternNum INTEGER
SELECT @list = @lstblah
SELECT @patternNum = CHARINDEX(',', @list)
CREATE TABLE #mid (
mid int NOT NULL
) ON [PRIMARY]
GO
WHILE (@patternNum > 0)
BEGIN
INSERT INTO #mid (mid) VALUES ( CAST(SUBSTRING(@list, 0,
@patternNum) as int) )
SELECT @list = SUBSTRING(@list, @patternNum + 1, Len(@list) -
@patternNum)
SELECT @patternNum = CHARINDEX(',', @list)
END
-- rest of Stored Procedure...
GO
Now it's telling me I haven't declared the variable @list and @patternNum,
but not at the top, it's in the WHILE statement.
Anyone?
Paul
-------------------------------------------
Paul Johnston
PJ Net Solutions Ltd
http://www.pjnetsolutions.com
[EMAIL PROTECTED]
+44 (0)7866 573013
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
