Welcome to WebmasterWorld Guest from 3.227.233.55

Forum Moderators: ocean10000

Message Too Old, No Replies

Inserting scripts into DB

     
4:48 pm on Mar 18, 2009 (gmt 0)

Preferred Member

10+ Year Member

joined:Jan 4, 2005
posts:621
votes: 0


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!

3:08 pm on Mar 19, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 19, 2006
posts:92
votes: 0


do you have any error messages?
10:30 am on Mar 21, 2009 (gmt 0)

Preferred Member

10+ Year Member

joined:Jan 4, 2005
posts:621
votes: 0


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!

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members