RE: Stored PROCEDURE syntax

[Eric Creese]

you are missing an AS after the name of your new procedure if you are using SQL.

-----Original Message-----
From: brob [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 10:40 AM
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]

---