CREATE PROCEDURE update_image_status_y
@image_id INT
AS
UPDATE images
SET image_document_head = 'y'
WHERE id = @image_id
-----Original Message-----
From: brob [mailto:[EMAIL PROTECTED]
Sent: maandag 17 november 2003 17:40
To: CF-Talk
Subject: Stored PROCEDURE syntax
THis i what i have
CREATE PROCEDURE update_image_status_y
(
@image_id INT
)
UPDATE images
SET image_document_head = 'y'
WHERE id = @image_id
But i get a "Incorrect SYntax near the keyword UPDATE" what's up?!
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
