I am accessing a database using the following command: SELECT SensorID, State, NumKey, MAX(DateTimeEvent) FROM Sensors GROUP BY SensorID The SensorID and DateTimeEvent match but State and NumKey are not from the same row as SensorID and DateTimeEvent. The State and NumKey are coming from the first entry found in the table. So the command returns the following: SensorID - ABC123 State - 0 NumKey - 16 DateTimeEvent - 2009-11-17 13:00:00 But the State and NumKey, associated with the SensorID ABC123 and DateTimeEvent 2009-11-17 13:00:00 are 4 and 46 so looking at the row in the table it is: SensorID - ABC123 State - 4 NumKey - 46 DateTimeEvent - 2009-11-17 13:00:00 Any idea what is going on? What I am trying to do is sort on SensorID and pick the row with the highest DateTimeEvent. Thanks, Jim

I told my daughter age 7 to hold her breath, it was OK as I would be breathing. She looked at me oddly but complied. When she could no longer hold her breath she blew it out gasping. I asked why she let out her breath. She yelled angrily, "DADDY, YOU CAN'T BREATHE FOR ME. I HAD TO BREATHE OR I WOULD DIE!" I smiled and quietly told her, "Just as breathing is essential to life and can be done only by you for you, so is thinking. Do not ever believe that you can let someone else do your thinking."

Thanks for your help. Jim

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Yes, I want to apply a Mercator Projection but I don't think I was clear with my orginal question, I'll try again. Only part of the map is visible at any given time. What happens when the user reaches the left/right edge of the map in order to see more they must scroll to the opposite edge. Similar to a huge mercator projection painted on a 500 foot long sheet of paper lying flat on the ground. You reach the end of the paper and if you want to see more of the map you have to go back to the other edge (what I have now). If what you are interested in is over or close to the split you are always going back and forth. Now picture that same map on cyclinderical tower which has a 500 foot diameter. The two edges of the map meet and you don't have to go back and forth (what I want to have). I have attempted to do this by using an oversized map (shows 380 degrees of longtitude when viewed completely) and resetting the X location. I haven't been able to get this to work. Any ideas? Jim

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

I orginally posted this in the C# form (the language I am trying to write this in) and recieved no responses :( . Thought I would try here before giving up. I am trying to allow wrapping of a world map from east to west or west to east (the map is split down the Pacific Ocean). Thus the map would appear to be a cylinder not a rectangle. As the user scrolls across the dividing line the other map edge appears. I thought this would be resonable but I have not been able to find much searching (map, warpping and scrolling appear in many contexts). Any help would be greatly appericated. Thanks, Jim

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

I am trying to allow wrapping of a world map from east to west or west to east (the map is split down the Pacific Ocean). Thus the map would appear to be a cylinder not a rectangle. As the user scrolls across the dividing line the other map edge appears. I thought this would be resonable but I have not been able to find much searching (map, warpping and scrolling appear in many contexts). Any help would be greatly appericated. If I should move this to the graphics board please let me know. Thanks, Jim

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

I think this might be what you are looking for, all 1434 pages[^]

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Or you could just by one on the $10 homes in Detroit and save a bundle on closing costs.

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Oakman wrote:

What could I have written that would have made my meaning clearer

Nothing, your meaning was clear. Which is why I disagree with you. The electricity grid is infrastructure. While only marginally better than Wikipedia, the US Gov DOE agrees[^]

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Oakman wrote:

new electricity grid

You are wrong to put the electricity grid in with pork. The black out in the midwest and northeast in 2003 (I think I have the year correct) was in part a result of a poor grid. Electricity costs can be higher due to bottle necks in the grid. According to the American Society of Civil Engineers the grid remains a cause for deep concern among experts[^].

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

If you are considering all levels of government. Just last week, there was a municipal election and I felt two of the candidates for mayor were good choices and had to choose the better candidate. Otherwise never always the lesser of two evils. Jim

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

I am taking a class on Databases. As a project assignment I need to write about an 'important database subject (such as query optimization, database design, distributed databases)'. I was hoping someone would be willing to offer some other important database subjects that may not have received much attention. If you have a topic please share, no I am NOT asking anyone to provide any research or writing.

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Hard to believe, note the '****'[^]. Wouldn't want the world to know Hitler ever lived or was the leader of the Nazi party. So much for learning from history.

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

In moderate defense the full study[^](the abstract is here[^]if the password protection works) has no mention of the bends. The National Geographic article can be found here.[^]

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

I have am trying to find the difference between factor and coefficient. Searching shows they both are used a lot but I have been unable to find a good comparison of the two (various online dictionary definitions aren't a lot of help). What I have been able to find implies they are the same - the coefficient of friction (ratio of tangential force to the perpendicular normal force) and drag factor (total acceleration force divided by weight). Each results in a multiplicative number. What am I missing? What is the difference?

The American people should be eternally grateful to Old Europe for having spiked the Bush-McCain plan to bring Georgia into NATO.[^]

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Man's Prayer: "I'm a man, but I can change, if I have to, I guess."

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

I am using 3rd party hardware and as a result, their software (off to a bad start) and their response to this question is deal with it. I can't change the hardware. The problem is the hardware produces a 3 byte value which is stored as an int, ie in 4 bytes. The 3 bytes are stored in the three most significant bytes of the int and the least significant byte of the int is left as 0. If the 3 bytes were 12 34 56 they would be stored as 12 34 56 00. Thus if one tries to pull the bytes out as ints the appearance is the value has been multiplied. My solution at the moment is to bit shift each element in the array by 8. The arrays can be large. Any ideas about a faster approach? Thanks Jim

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Thanks Mark.

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

I am coding with C# in VS2005 (may be able to get access to VS2008). I will take a look at GDI+, thanks. Jim

this thing looks like it was written by an epileptic ferret Dave Kreskowiak

My hope is (was?) there is some other method other than a bitmap I can use to avoid or reduce the decimation. Side note, the bitmap appears to be hard coded to a max of 32K. Yes, if there are more pixels than the bitmap will hold there will be some kind of decimation. Jim

this thing looks like it was written by an epileptic ferret Dave Kreskowiak