954,525 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Complex Question: Saving large articles to the DB

Hi all,

I'm pretty new to Perl and already I'm finding myself lost. I have created a form for my website that allows users to enter news articles (a textarea) and then my code saves the text entered ($Text) to the database. I have set the Text to longtext through SQL, because these articles are relatively long, but for some reason whenever I try to input new data, it takes me to a blank screen and the url is my setArticle.cgi (where I am saving $Text and updating it to the DB). When I submit articles that are shorter, about 2 paragraphs long, the script works fine. Any reason why this is being difficult? Sorry if it isn't clear. Thanks so much!

-Mckenzie

MckeMowse
Newbie Poster
1 post since Jul 2006
Reputation Points: 10
Solved Threads: 0
 

You will probably find that length is not the issue, but that you have characters in your input that are causing problems with your SQL insert. Make sure that all characters are suitably escaped.

kbcnetau
Newbie Poster
1 post since Apr 2005
Reputation Points: 10
Solved Threads: 1
 

Good Call

Comatose
Taboo Programmer
Team Colleague
2,910 posts since Dec 2004
Reputation Points: 361
Solved Threads: 215
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You