[Dnfbb-developers] [ dnfbb-Bugs-1568624 ] Dynamic SQL Exception - User Search

[SourceForge.net <no...@so...>]

Bugs item #1568624, was opened at 2006-10-01 08:32
Message generated for change (Comment added) made by sbosanquet
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=784889&aid=1568624&group_id=152364

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: UI
>Group: Being Fixed as you look
Status: Open
>Resolution: Accepted
Priority: 5
Submitted By: Bosie (sbosanquet)
Assigned to: Bosie (sbosanquet)
Summary: Dynamic SQL Exception - User Search

Initial Comment:
If you enter a ' characher as a user search parameter 
the following unhandled exception is generated:

Server Error in '/' Application.
-------------------------------------------------------
-------------------------

Dynamic SQL Error SQL error code = -104 Unexpected end 
of command 
Description: An unhandled exception occurred during 
the execution of the current web request. Please 
review the stack trace for more information about the 
error and where it originated in the code. 

Exception Details: 
DotNetForum.Library.Exceptions.UserException: Dynamic 
SQL Error SQL error code = -104 Unexpected end of 
command

Source Error: 

An unhandled exception was generated during the 
execution of the current web request. Information 
regarding the origin and location of the exception can 
be identified using the exception stack trace below.  

Stack Trace: 


[UserException: Dynamic SQL Error
SQL error code = -104
Unexpected end of command]
   DotNetForum.Library.DAL.FirebirdDB.UserSearch
(UserSession Session, String Text, Boolean Ascending, 
UserSearchCriteria SortBy, Int32 Count)
   DotNetForum.Library.BOL.Users.Search(UserSession 
Session, String SearchText, Boolean Ascending, 
UserSearchCriteria SortBy, Int32 Count)
   
DotNetForum.WebSite.Users.Members.UserSearch1_OnUserSea
rch(Object sender, UserSearchEventArgs e)
   
DotNetForum.WebSite.Users.Controls.UserSearch.btnSearch
_Click(Object sender, EventArgs e)
   System.Web.UI.WebControls.Button.OnClick(EventArgs 
e) +108
   
System.Web.UI.WebControls.Button.System.Web.UI.IPostBac
kEventHandler.RaisePostBackEvent(String eventArgument) 
+57
   System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String 
eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1292

 


----------------------------------------------------------------------

>Comment By: Bosie (sbosanquet)
Date: 2006-10-01 08:59

Message:
Logged In: YES 
user_id=1025541

UI changes implemented.  DB code changes still to do

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=784889&aid=1568624&group_id=152364