Inserting scripts into DB

[Pico_Train]

Hi there,

I am inserting approximately 5000 records into a SQL DB. Some of the inserts are fine. No problem. But once there is a bit of html code in them, they bug out. so if there is a <p> tag, the inserts fail.

How do I avoid this in asp and SQL. I am a php mysql kinda guy...

Thanks!

[darrenG]

do you have any error messages?

[Pico_Train]

I thanks for the reply. I did but don't remember what it was.

It in the end it didn't like this character <.

So i replaced all the < with &lt; and then in the template searched for &lt; and replaced it back with <. Everything went well so I'm happy with that!

Cheers!