Hey Leon,
Then you should be looking for Server.HTMLEncode() that converts are HTML tags within the resume as shown below. The following conversion will take place before adding the resume in the DB
< - <
> - >
& - &
' - '
" - "e;
Otherwise alteast you have to replace the single quotes if any within the resume with two Single quotes. As single quotes have special meaning in sql, just to negate that this has to be done.
Code:
Dim strResume
strResume = Replace(Request.Form("sResume"),"'","''")
OR
Try this...
Code:
Dim strResume
strResume = Server.HTMLEncode(Request.Form("sResume"))
Use this strResume variable in your SQL statement for storing the resume in your database. That should work.
Also take a look at this link -
QueryString Has a Maximum Length. Though not certain about the fixed length, there is a limit(just above 2 kb including the URL), and it is not endless at all.
Hope that helps.
Cheers!
_________________________
- Vijay G
Strive for Perfection
