Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sooty70

    Basic OO question

    Good tips. The reason I am even here posting these questions is because I read UML Distilled Second Edition and I wanted to make myself a "better" coder. I've been in QA for the last 3 years and I was in development / DBA work before that. I'm trying to get back on the development track but...
  2. Sooty70

    Basic OO question

    Thanks again Steve. Performance is never going to be a problem on this site even if I went to the database every single time, it's not very heavily used. I guess I could measure it in hits / week. :)
  3. Sooty70

    Basic OO question

    I wish I could edit my posts. :) I understand the above code is flawed. The return type for loadComps is defined as void and it should be Vector i.e. Vector loadComps() Anyway, the code is piecemeal and only to help describe the process as opposed to being actual, working code. Cheers, Max
  4. Sooty70

    Basic OO question

    You can join the players, playerCompetition, and competition tables to instantiate a player object with a collection of associated active competetions. And a similar query when you instantiate a competition, to give it a collection of players." This is the key piece right here. I understand...
  5. Sooty70

    Basic OO question

    Thanks Steve, that helps. [1] The Administrator is a Player and you are correct, sometimes both roles can be played simultaneously. The difference between an Administrator and a Player is just access to certain pages and commands. [2] People register using a self-register page. Registration...
  6. Sooty70

    Basic OO question

    To clarify a little on the above let me use an example. Here are some Competitions as they are stored in the database: Comp02, 1, 2002, [NULL], 0 Comp03, 1, 2003, [NULL], 0 Comp04, 1, 2004, [NULL], 1 The fields are : competition name administrator Id year password isCurrent (boolean flag)...
  7. Sooty70

    Basic OO question

    Hi Folks, Most of my background has been working with databases so I tend to think about problems in terms of data. I know that objects can contain data but thinking of them as simply data holders can be a bad thing. I've been trying to correct myself in the way that I think of objects. I've...
  8. Sooty70

    Running ColdFusion and .NET on IIS

    Hi Jerasi, What sort of monitoring tools do you use? We run CF behind IIS and we are getting lots of HTTP issues (500 and 503 errors). I want to try and figure out if there is something that I can tweak but I don't really know where to start. Cheers, Max
  9. Sooty70

    IIS Newbie

    Hi folks, I'm completely new to IIS. I am load testing our Cold Fusion application and when the load is increased beyind X virtual users I start seeing lots of 500 and 503 errors. None of the application servers are being overloaded - cpu % very rarely spikes over 30% on the cold fusion...
  10. Sooty70

    Simple question - SQL Server RID interpretation

    Anybody know the answer to this? I would have thought that something like the row identifier (RID) should be documented in SQL BOL but I can't see it. Let me correct that, I've seen an explanation for RID aa:bb:cc but not RID aa:bb:cc:dd. My understanding is: aa - database if bb - file cc -...
  11. Sooty70

    Stored Proc variable '%' doesn't seem to work

    I agree with your second point, I only select * if I actually need all the columns. I would be interested to learn more about the performance ramifications of using * though. Do you know of any papers? Mike~ didn't mean to hijack your thread but I think you have an answer now so maybe it's...
  12. Sooty70

    Stored Proc variable '%' doesn't seem to work

    Incidentally, why should you never use select *? I think that as a rule of thumb it is good practice to list out all the column names and that re-ordering the column list, adding / removing columns is easier but do you have different reasons?
  13. Sooty70

    Stored Proc variable '%' doesn't seem to work

    Ahhhh, does SQL Server use the + sign as an escape character?
  14. Sooty70

    Stored Proc variable '%' doesn't seem to work

    You are looking for messages like '%@Message%', presumably you want to search for message like the contents of @Message? Try this: WHERE (dbo.tblEntries.MessageID LIKE '%' + @Message + '%')
  15. Sooty70

    Query with HTML variable

    Are you doing this in ASP? You can't do it in plain old HTML. If you want to run a query that uses data entered by a user then you need to POST the data to the ASP, run the query, generate the HTML and then send it back to the client. There are a couple of ways you can do this. You could...
  16. Sooty70

    Simple question - SQL Server RID interpretation

    Hi Folks, I've been looking high and low for the answer to this question for the last couple of hours with no success. I've switched on the trace 1204 to try and figure out what the cause of some deadlocks are. I already kinda know but I want to be exact. In the log I see this: RID...

Part and Inventory Search

Back
Top