incorrect syntax

**todd2006** · todd2006, February 13th, 2009 12:20 PM

Hi,

Here is my asp code

Code:

set rs = Conn.execute("EXEC dbo.Get_Info @email=" &sentemail)

passing a parameter to the stored procedure

and here is the stored procedure

Code:

Create PROCEDURE [dbo].[Get_Info]
@email varchar(5000)

As
Select * From dbo.Registration 
          where Email = @email

it gives an error

Incorrect syntax near '-'.

and the error is on this line

set rs = Conn.execute("EXEC dbo.Get_Info @email=" &sentemail)

any idea

**mehere** · mehere, February 13th, 2009 12:25 PM

try this:

Code:

set rs = Conn.execute("EXEC dbo.Get_Info '" & sentemail & "'")

**todd2006** · todd2006, February 13th, 2009 12:31 PM

mehere,

thanks it worked out but if i am passing two parameters how will my query be then

**mehere** · mehere, February 13th, 2009 12:43 PM

they should be separated by commas and in the same order as they are in your stored proc
something like this:

Code:

set rs = Conn.execute("EXEC dbo.Get_Info '" & sentemail & "','" & username & "'")

**todd2006** · todd2006, February 13th, 2009 12:48 PM

you know that you are one smart girl in this forum.

I have a small request since you are good with sql.

Can you look at this post and tell me whats going wrong

Top problem - SQL Development

the output parameter is just not working

**mehere** · mehere, February 13th, 2009 12:55 PM

i've never done output parameters and i don't have sql server on this pc to test. let me see if i can find something and i'll let you know if i do in that thread.

Thread: incorrect syntax

LinkBack

Thread Tools

Display

incorrect syntax

Similar Threads

Update Syntax

New Syntax Highlight BBCode

syntax error? Expected ')'

Syntax Error with Arrays

syntax

Bookmarks

Bookmarks

Posting Permissions