Web Wiz Support and Community Forums : Getting my Username to go past 15 charter https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 18:05:54 +0000 Tue, 02 Aug 2005 12:45:25 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=14395 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Getting my Username to go past 15 charter : If you want 25 characters, I&#039;d...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post88066.html#88066 Author: dpyers
Subject: 14395
Posted: 02 August 2005 at 12:45pm

If you want 25 characters, I'd set the db field to 40 and the trimstuff to 25. The expansion of characters to prevent sql injectionhappens after the trim when it's posted to either access or mssql.]]> Tue, 02 Aug 2005 12:45:25 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post88066.html#88066 <![CDATA[Getting my Username to go past 15 charter : no thats done in both versions. so...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post88065.html#88065 Author: dj air
Subject: 14395
Posted: 02 August 2005 at 12:07pm

no thats done in both versions.

so you have to account for it within the access database also
]]> Tue, 02 Aug 2005 12:07:18 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post88065.html#88065 <![CDATA[Getting my Username to go past 15 charter : dpyers wrote:Don&#039;t forget...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post88056.html#88056 Author: wolfman
Subject: 14395
Posted: 02 August 2005 at 8:44am

Originally posted by dpyers dpyers wrote:

Don't forget to change the size of the field in the database as well.
The db field size is longer than 15 characters because the update routine replaces characters that could be used for sql injection attacks (e.g. ', [, ", etc.) with their decimal equivalents. You need to have extra space in the db field to hold those replacement characters.
 
This would be for SQL only, correct?  I am using an access dbase.
]]> Tue, 02 Aug 2005 08:44:25 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post88056.html#88056 <![CDATA[Getting my Username to go past 15 charter : Don&#039;t forget to change the...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post83615.html#83615 Author: dpyers
Subject: 14395
Posted: 21 May 2005 at 3:51pm

Don't forget to change the size of the field in the database as well.
The db field size is longer than 15 characters because the update routine replaces characters that could be used for sql injection attacks (e.g. ', [, ", etc.) with their decimal equivalents. You need to have extra space in the db field to hold those replacement characters.
]]> Sat, 21 May 2005 15:51:52 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post83615.html#83615 <![CDATA[Getting my Username to go past 15 charter : Make sure you remember to change...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post83558.html#83558 Author: TheLee
Subject: 14395
Posted: 20 May 2005 at 11:20pm

Make sure you remember to change the maxlength and trim in all the other pages that it exists in as well, such as the private messanger pages and the pop up search for username page,etc ]]> Fri, 20 May 2005 23:20:14 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post83558.html#83558 <![CDATA[Getting my Username to go past 15 charter : Nevermind i found the Trim string. Thanks...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79739.html#79739 Author: gregcaulder
Subject: 14395
Posted: 24 March 2005 at 1:02pm

Nevermind i found the Trim string.

Thanks for the help.

Greg
]]> Thu, 24 Mar 2005 13:02:11 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79739.html#79739 <![CDATA[Getting my Username to go past 15 charter : I see. So it trims the length...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79738.html#79738 Author: gregcaulder
Subject: 14395
Posted: 24 March 2005 at 1:00pm

I see. So it trims the length to 15 charcters. So if someone were toregister with something longer the n15 charcters it would be trimmed nomatter what down to 15 charters before entering the database.

How would i go about editing this trimming factor. I lookd in thecommon.asp file and found nothing. Which files will i need to edit, andif possibley what lines of code are they located in?


Greg
]]> Thu, 24 Mar 2005 13:00:19 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79738.html#79738 <![CDATA[Getting my Username to go past 15 charter : Yes change the amount the input...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79733.html#79733 Author: WebWiz-Bruce
Subject: 14395
Posted: 24 March 2005 at 12:02pm

Yes change the amount the input is Trimmed by that I metioned in my last post.]]> Thu, 24 Mar 2005 12:02:50 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79733.html#79733 <![CDATA[Getting my Username to go past 15 charter : Is there anyway to get around...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79730.html#79730 Author: gregcaulder
Subject: 14395
Posted: 24 March 2005 at 11:41am

Is there anyway to get around it or to change it from only reading 15 charters?]]> Thu, 24 Mar 2005 11:41:49 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79730.html#79730 <![CDATA[Getting my Username to go past 15 charter : When the form entry is read in...]]> https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79701.html#79701 Author: WebWiz-Bruce
Subject: 14395
Posted: 24 March 2005 at 5:29am

When the form entry is read in in the regsiter.asp file a 'Trim' is run on the entry to reduce it down to 15 characters.]]> Thu, 24 Mar 2005 05:29:31 +0000 https://forums.webwiz.net/getting-my-username-to-go-past-15-charter_topic14395_post79701.html#79701