| Author |
 Topic Search  Topic Options
|
ToJaRo 
Groupie
Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Signature Max Character
Posted: 25 December 2006 at 3:59am |
|
Is there a way to change the max characters allowed in the users signature. I see that 200 is the current limit... but how would I change it if I wanted to up it?
|
|
|
 |
ToJaRo
Groupie
Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 December 2006 at 4:07am |
I have found the signature_preview file that has some things that may be related... just wanna check.
'Read in the message to be previewed from the cookie set
strSignature = Mid(Request.Form("signature"), 1, 200) - Do I change this to reflect the max sig count?
'Take the signature down to 255 characters max to prevent database errors
strSignature = Mid(strSignature, 1, 255) - Maybe I should not change it?????
|
|
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 December 2006 at 5:36am |
|
Without going into the code at this time, what I recall off the top of my head is...
255 sounds like it's a small text field type in the db. You'd probably need to change the field type to a larger type of text field. The exact field type for a larger text field would depend upon the db being used.
I don't recall if the sig field was run through the function to replace characters that might be used in an sql injection attack. but I imagine it would be. If so, one displayed character might be represented by a 4 character entity which means the b field must be larger than the max displayed characters.
The sig file is probably validated in javascript client side as well as in server side script. You might have to change both.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
<SKATER
Newbie
Joined: 19 August 2006
Location: United States
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 March 2007 at 2:31am |
|
I too am in need of longer sig lines. please explain the coding to be done. thanks.
Edited by <SKATER - 10 March 2007 at 4:01am
|
|
acechan
Newbie
Joined: 30 August 2003
Location: Switzerland
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 May 2007 at 10:22am |
Same here. We need to put image links with very long URL addresses and files names, and 200 chars is not enough.
Please help...
Edited by acechan - 21 May 2007 at 10:23am
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 May 2007 at 10:56am |
|
You ned to chnage the code that ToJaRo mentions.
You will also need to change the field type in the database to 'memo' for access or a larger text size in SQL Server. However, it is set at the present limit in the database as larger file size larger than 255 will mean your database will not perform as fast and require more storage and more server memory.
|
|
|
|
acechan
Newbie
Joined: 30 August 2003
Location: Switzerland
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 May 2007 at 11:02am |
OK, thanks a lot, Borg, my question was more about the changes I had to make in the database!
|
|
<SKATER
Newbie
Joined: 19 August 2006
Location: United States
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 May 2007 at 3:51pm |
 -boRg- wrote:
You ned to chnage the code that ToJaRo mentions.
You will also need to change the field type in the database to 'memo' for access or a larger text size in SQL Server. However, it is set at the present limit in the database as larger file size larger than 255 will mean your database will not perform as fast and require more storage and more server memory.
|
where in the database is this info? and how do you change it?
|
|
