Click here to Skip to main content
15,917,455 members

The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
ScottM120-Oct-10 4:30
ScottM120-Oct-10 4:30 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Electron Shepherd20-Oct-10 4:46
Electron Shepherd20-Oct-10 4:46 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
ScottM120-Oct-10 4:59
ScottM120-Oct-10 4:59 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Electron Shepherd20-Oct-10 5:08
Electron Shepherd20-Oct-10 5:08 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
ScottM120-Oct-10 5:23
ScottM120-Oct-10 5:23 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Electron Shepherd20-Oct-10 5:37
Electron Shepherd20-Oct-10 5:37 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
ScottM120-Oct-10 21:08
ScottM120-Oct-10 21:08 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 4:19
Richard A. Dalton20-Oct-10 4:19 
I go with Parameters all the way, even if I'm generating the SQL in Code.

The only downside of Parameters is that it's hard to grab the exact SQL (including values) that is being sent to the DB.

As for escape characters. On occasions when I have gone that route My escaping was always done inside a single function. There's no way I'd go around escaping SQL strings willy nilly.

In fact it goes further than that. When I'm building SQL in my App all contact with the Database is filtered through one specific DB class which wrapps ADO or whatever.

So the argument that you might "forget" to escape a particular query doesn't really stand up if you are doing this stuff correctly.

-Rd
Hit any user to continue.

GeneralRe: Stored Procs, Packages, Views...Pah! Pin
wout de zeeuw20-Oct-10 10:54
wout de zeeuw20-Oct-10 10:54 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
AspDotNetDev20-Oct-10 11:11
protectorAspDotNetDev20-Oct-10 11:11 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Tomz_KV20-Oct-10 2:06
Tomz_KV20-Oct-10 2:06 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 2:43
Richard A. Dalton20-Oct-10 2:43 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Electron Shepherd20-Oct-10 2:46
Electron Shepherd20-Oct-10 2:46 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Tomz_KV20-Oct-10 3:12
Tomz_KV20-Oct-10 3:12 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Electron Shepherd20-Oct-10 3:17
Electron Shepherd20-Oct-10 3:17 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 3:26
Richard A. Dalton20-Oct-10 3:26 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
richard_k26-Oct-10 22:09
richard_k26-Oct-10 22:09 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
JasonPSage20-Oct-10 3:31
JasonPSage20-Oct-10 3:31 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 4:24
Richard A. Dalton20-Oct-10 4:24 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
richard_k26-Oct-10 22:11
richard_k26-Oct-10 22:11 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
YSLGuru20-Oct-10 10:20
YSLGuru20-Oct-10 10:20 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 23:32
Richard A. Dalton20-Oct-10 23:32 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
wout de zeeuw20-Oct-10 11:42
wout de zeeuw20-Oct-10 11:42 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 23:42
Richard A. Dalton20-Oct-10 23:42 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
wout de zeeuw21-Oct-10 0:45
wout de zeeuw21-Oct-10 0:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.