Search results for query: *

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...

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. :)

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

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...

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...

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)...

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...

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

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...

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 -...

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...

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?

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

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 + '%')

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...

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...