|
Hallo,
my company works on Rational Suit 2003
if you created the class digram, you should open it then go to tools menu,and select the programming language, then you can see the Create Code option, select it, so the code will be generated if there is no errors in your digram.
Best Wishes, Good Luck
Eng. Mai...
|
|
|
|
|
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?
|
|
|
|
|
I don't have a real solution for your problem but a simple idea.
After reading your message I assume that you know the structure of the result (schema).
Therefore it should be possible to wrap your query:
select <only permitted="" columns="">
from <the original="" query="">where <additional restrictions="">
This way you can get rid of the unwanted data on the db server.
-^-^-^-^-^-
no risk no funk
|
|
|
|
|
No, and this is really the problem, the sql that we are passed could contain largely anything.
|
|
|
|
|
morning all (or afternoon/evening depending where you are....)
I'm not sure if this is the right place to ask, I think it is, but feel free to move it mr(s) admin if need to be to somewhere more appropriate.
I was really just after peoples thoughts, so here goes....If I have a page/area divided up into subareas but these are changeable in size what would be the best way to do it? I was thinking originally about just drawing lines (having the x/y of the start point and the length), but then throught its not really the line I'm interested in but the area it encloses so I suppose I would want to be able to draw boxes (similar to divs in a webpage is the best way of decribing it, its basically for laying out information within the application but allowing the user to resize areas) so I would need x/y and w/h. Would that be a more sensible approach ? Or ...(and heres hoping is there something already within the windows api that would handle this - some sort of table type structure would probably do it, just so long as i could return the values of each of the cells. Could I do something with multiple panels maybe, I'd need to maintain the coords etc of them but at least that would give me something *physical* to work with, suppose I should go and play around a bit and see what comes of it.
anyway, like I said it was really just to see if anyone thought I was barking up the wrong tree, had completely missed something that was out there or thought maybe i was going in the right direction.
cheers
tim
|
|
|
|
|
You don't say what you're using. In WinForms, .NET 2.0, you can use a nested set of SplitContainer controls to host whatever else you need in the divisions you mention.
|
|
|
|
|
hi brady
sorry, i suppose that might have helped....doh!
SplitContainer controls sound exactly like the thing I was after, I knew there'd be something rather than me bodging in some sort of tawdry effort that only kind of half works.
thanks for the pointer
tim
|
|
|
|
|
I was arguing with my friends about sending the business object over a web service.
Some of my friends said that they don't pass the busineess object (eg: Employee ) to Webservice. Instead, they used to pass the individual parameter (eg: empId, empName, empAddress ) to WebService. Because they think that sending the business object over a webservice is not good practice.
I don't understand why this is not good practice. I used to send the custom business object to webservice in several project. It works fine.. Plus, it's so easy if I wanna add some properties (eg: empPhone, empEMail ) to my business object because I dont need to add the individual parameter in each and every webmethods whenever I made changes to my BO.
I'd like to hear your opinion about this. What do you think?
Thanks in advance.
|
|
|
|
|
Nope - your business object is the way that I'd go. As long as it's serializable, you should be fine. I suspect that they are thinking along the lines that the serialized object is going to be much more information that individual parameters, and hence is going to take more bandwidth - but if you are dealing with corporate systems this tends not to be too much of an issue.
Really, you've got to ensure that your business object doesn't grow to be too big and balance this with the convenience of passing this over.
|
|
|
|
|
|
Michael Sync wrote: Some of my friends said that they don't pass the busineess object (eg: Employee ) to Webservice. Instead, they used to pass the individual parameter (eg: empId, empName, empAddress ) to WebService.
That is not really tracking for me. There is not really a "object" approach to WebServces. There are really only Two types and then of course the REST approach which in now considered a Third type. The two main types are RPC versus Document Centric (now referred to as Service Oriented Architecture as in this definition[^])
Anyway if what you guys are arguing about is RPC vs Document Centric, the RPC approach has been recognized as inferior for a few years now as pointed out in that Wikipedia page.
|
|
|
|
|
OK - I let the last one pass, but I've got to point out to you that this is a forum and Design and Architecture. How does your query relate to this in any way?
|
|
|
|
|
|
Wow. You don't ask for much, do you? Are you just trying to get rich on the back of other peoples ideas, because as a business plan that's not very effective.
|
|
|
|
|
Shut your mouth cyber-slave and get to back to coding his web site.;P
God Bless,
Jason
Paul Conrad wrote:
Chuck Norris keeps the hamsters going whenever Chris is gone on vacation. Just stares them down and they keep the servers going
|
|
|
|
|
|
Haha....thats what I was thinking.
I'm finding the only constant in software development is change it self.
|
|
|
|
|
theamsun wrote: can you guide me for a high level design for the site
At a strictly high level, you'll need:
1 x Computer
1 x Connection to the Internet
1 x Web Server Software & some HTML pages to serve from the Web Server Software
"It was the day before today.... I remember it like it was yesterday."
-Moleman
|
|
|
|
|
|
I would double that as a backup; and dont forget a UPS. Cant do without.
|
|
|
|
|
What about web page editor/tools? Should we just point him to vi ?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I hope he will allow Pete to choose his own set of tools.
|
|
|
|
|
Like what Pete said in my sig. He could just use Notepad or Vi, throw some html tags at the webserver and see if they "stick"
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Luc Pattyn wrote: I hope he will allow Pete to choose his own set of tools.
Nope - I'm a lackey. I get to use what the boss tells me.
Oh, how I hope that I get promoted from lackey to henchman someday.
|
|
|
|
|
Hi there.
I am working on an application that shall be used as a local frontend to an online image database. The application shall display a list of images matching specific criteria as thumbnails and, upon click, will show the images in full size. The server has a list of newly added content which shall be presented to the user on startup, ideally showing every new content since the last synchronisation.
The problem is that a rather "small" number of images (~30 that is) will eat up several megs of disk space (~10 MB). I don't want to rely on the users having a broadband connection and also can't afford to let my application eat hunderts of megs of disk space, so apparently there is a need of some clever caching behaviour.
Now I have never done this before and don't even know how a regular web browser handles caching, so I need some information to get me started or even better, some ideas on how to solve this.
If it matters, I am working on .NET with C# since I hope that this will give me the possibility to port the project later to tge Mono platform.
Any help would be appreciated!
Regards,
Markus
|
|
|
|