Issue with update command and sql server 2000

[fldbryan]

OK, It's been awhile for me using Sql Server so I'm feeling slow. I upsized my access database to SS 2000 Desktop Edition. I relinked and everything looks good. I also verified that I can add data to my fields that are represented as memo (ntext(16)). I am now converting the asp.net application from access to Sql Server. When I issue this command:

UPDATE tblCandidateNotes SET Note=&quot;<font color=''Blue''>This is a test of a memo system. And mor and mor and more<br><hr><font color=''Black''>01/22/2004 10:29:53 AM ()<br><font color=''Blue''>More data.&quot; WHERE noteid=6

I get this error. Identifier is too long. max length is 128.

Obviously I'm missing something here. What is it?

 

[Lekar]

Change the double quotes with single quotes to enclose the string:

UPDATE tblCandidateNotes SET Note='<font color=''Blue''>This is a test of a memo system. And mor and mor and more<br><hr><font color=''Black''>01/22/2004 10:29:53 AM ()<br><font color=''Blue''>More data.' WHERE noteid=6

Hope this help.
Lenin.

 

[fldbryan]

Sheesh that was too easy. So &quot; limits to 128 and ' doesn't? Well now I know. Thanks.