Click here to Skip to main content
16,004,927 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionDesign question for a Plugin Framework Pin
ssack20-Jul-07 3:26
ssack20-Jul-07 3:26 
AnswerRe: Design question for a Plugin Framework Pin
led mike20-Jul-07 5:25
led mike20-Jul-07 5:25 
GeneralRe: Design question for a Plugin Framework Pin
ssack20-Jul-07 5:43
ssack20-Jul-07 5:43 
QuestionHow to generate code from Rational Rose Diagrams? Pin
FishiFishi19-Jul-07 21:10
FishiFishi19-Jul-07 21:10 
AnswerRe: How to generate code from Rational Rose Diagrams? Pin
led mike20-Jul-07 4:55
led mike20-Jul-07 4:55 
AnswerRe: How to generate code from Rational Rose Diagrams? Pin
Dan Neely20-Jul-07 5:30
Dan Neely20-Jul-07 5:30 
AnswerHow to generate code from Rational Rose Diagrams? Pin
EngMai25-Jul-07 19:13
EngMai25-Jul-07 19:13 
QuestionPost processing a sql string Pin
Paddy Boyd19-Jul-07 6:03
Paddy Boyd19-Jul-07 6:03 
We have a section of our application that deals with reporting, using MS reporting services. We also have a custom data extension that performs some post processing on the datasets returned (basically stripping out records that the runtime user would not be authorised to see).

The current method we are using is to run the sql, generate a dataset, check to see if it contains sensitive data (looking at column names) and then loop through the rows, removing those that are not required.

Obviously, this is a lot slower than it would be to just alter the sql to remove these rows using criteria in the where clause, but we can't see a way to robustly parse the sql to establish

A) That the query is actually accessing sensitive data.
B) Where we can insert our chunk of sql into the where clause.

For simple reports, this is relatively easy, but as some of the reports are considerably more complex and the sql will contain calls to functions and in some cases creating temp tables, it rapidly becomes more complex.

So, the question - does anyone know of a robust method of taking a string of arbitrary sql and parsing to allow us to alter the where clause of whichever part of it returns data?
AnswerRe: Post processing a sql string Pin
Urs Enzler20-Jul-07 1:03
Urs Enzler20-Jul-07 1:03 
GeneralRe: Post processing a sql string Pin
Paddy Boyd20-Jul-07 1:05
Paddy Boyd20-Jul-07 1:05 
Questionbox or line ? Pin
tim_gunning18-Jul-07 23:58
tim_gunning18-Jul-07 23:58 
AnswerRe: box or line ? Pin
Brady Kelly19-Jul-07 4:49
Brady Kelly19-Jul-07 4:49 
GeneralRe: box or line ? Pin
tim_gunning19-Jul-07 4:59
tim_gunning19-Jul-07 4:59 
QuestionBusiness Object or Individual Parameters? Pin
Michael Sync17-Jul-07 21:02
Michael Sync17-Jul-07 21:02 
AnswerRe: Business Object or Individual Parameters? Pin
Pete O'Hanlon18-Jul-07 9:33
mvePete O'Hanlon18-Jul-07 9:33 
GeneralRe: Business Object or Individual Parameters? Pin
Michael Sync18-Jul-07 16:21
Michael Sync18-Jul-07 16:21 
AnswerRe: Business Object or Individual Parameters? Pin
led mike18-Jul-07 11:54
led mike18-Jul-07 11:54 
AnswerRe: Back up of sharepoint web doccuments Pin
Pete O'Hanlon18-Jul-07 9:28
mvePete O'Hanlon18-Jul-07 9:28 
Questionbuild a website like google or youtube, may be like yahoo Pin
theamsun16-Jul-07 21:47
theamsun16-Jul-07 21:47 
AnswerRe: build a website like google or youtube, may be like yahoo Pin
Pete O'Hanlon16-Jul-07 23:39
mvePete O'Hanlon16-Jul-07 23:39 
JokeRe: build a website like google or youtube, may be like yahoo Pin
lost in transition 17-Jul-07 9:23
lost in transition 17-Jul-07 9:23 
GeneralRe: build a website like google or youtube, may be like yahoo Pin
Pete O'Hanlon17-Jul-07 9:26
mvePete O'Hanlon17-Jul-07 9:26 
GeneralRe: build a website like google or youtube, may be like yahoo Pin
alex.barylski19-Jul-07 13:47
alex.barylski19-Jul-07 13:47 
AnswerRe: build a website like google or youtube, may be like yahoo Pin
martin_hughes18-Jul-07 9:47
martin_hughes18-Jul-07 9:47 
GeneralRe: build a website like google or youtube, may be like yahoo Pin
Dave Kreskowiak18-Jul-07 10:24
mveDave Kreskowiak18-Jul-07 10:24 

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.