Windows Authentication:Users with apostrophes

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
keithBromley Members Profile Find Members Posts Newbie Joined: 09 June 2009 Status: Offline Points: 10	Post Options Post Reply Quote keithBromley Report Post Thanks(0) Quote Reply Topic: Windows Authentication:Users with apostrophes Posted: 09 June 2009 at 2:29pm
	A very minor thing, but some of our domain users have apostrophes in their names and even in their email addresses. Auto-registration fails for these users in functions\functions_windows_authentication.asp, windowsAuthentication()_get_check_username easily solved with another replace()... Keith

keithBromley Members Profile Find Members Posts Newbie Joined: 09 June 2009 Status: Offline Points: 10	Post Options Post Reply Quote keithBromley Report Post Thanks(0) Quote Reply Posted: 09 June 2009 at 2:31pm
	I should have said... This is in MS SQL Server version of web wiz forums v9.56 Keith

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 09 June 2009 at 2:38pm
	Changing line 161 to the following should fix the issue:- "WHERE " & strDbTable & "Author.Username = '" & formatSQLInput(strUserName) & "';"
	Web Wiz Forums Hosting ASP.NET Web Hosting

keithBromley Members Profile Find Members Posts Newbie Joined: 09 June 2009 Status: Offline Points: 10	Post Options Post Reply Quote keithBromley Report Post Thanks(0) Quote Reply Posted: 09 June 2009 at 2:50pm
	I used: "WHERE " & strDbTable & "Author.Username = '" & Replace(strUserName, "'", "''") & "';" but your suggestion is better, thank you!

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.