Problem with '&' character, not able to update ID in SQL table

[teenaguptha]

Hi all,

In my code, i have a ProductID which contains '&' character like "pen&pencil".I tried to update this as "pen&paper" from front end into database.But,database doesn't accept this changes..it remains as "pen&pencil"..Actually,I have created stored procedure for "update" and calling that in my code behind file.From front-end form , i'm entering new value and trying to update it. My code for update is as below -



@ProductID char(15),

@NewProductID char(15) = NULL,

Update ProductTable SET ProductID = @NewProductID WHERE ProductID = @ProductID

Please help me out.

Thanks in advance,



Teena

 

[jbenson001]

did you trace through your code? Are you sure you are passing the NEW value to your SP? Did you run the SP on it's own in SSMS to make sure it works as expected?

 

[jmeckley]

does it fail? if so what is the full exception (type, message, stack trace)?
what does your actual code look like. what you provided above is conceptual and doesn't help.

Jason Meckley
Programmer

faq855-7190
faq732-7259