Untitled Document
 
 
Forums
Subject: select all
Prev Next
You are not authorized to post a reply.

Author Messages
brianc
Posts:29

08/15/2007 12:04 AM  
Wondering why Select All is not a stored proc?
brianc
Posts:29

09/05/2007 2:39 AM  
can this please be changed in the next release...

instead of using a stored proc (its commented out)

'Return CType(SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName

it uses inline sql...

please :)
SoCanI
Posts:47

09/05/2007 8:03 AM  
It uses inline SQL because:

The module templates allow for dynamic sorting and filtering of the records. In order to allow for this and close any Sql Injection security holes a dynamic approach was taken that forces a specific SQL keyword structure.

If you have a better suggestion for this, we're all ears, so to speak :)
You are not authorized to post a reply.



ActiveForums 3.7
 



Join Now!

 
 
Copyright 2007 by SoCanI
Privacy Statement  Terms Of Use