I have a database with a master - detail relationshio between two tables. The database is basically a snapshot in time for each office. so imagine that my master table is: id (auto increment), date, office_id 1 , 2010-4-1, 100 2 , 2010-4-2, 100 3 , 2010-4-3, 100 4 , 2010-4-4, 100 5 , 2010-4-1, 101 6 , 2010-4-2, 101 7 , 2010-4-3, 101 8 , 2010-4-4, 101 I want to get the id number for the last update date from the master table so I did the following: SELECT id, max(upload_date) as upload_date, office_id from master group by office_id What I want is the id number associated with the latest date, so I WANT id, date, office 4, 2010-4-4,100 8, 2010-4-4,101 What I get is: 1, 2010-4-4,100 5, 2010-4-4,101 I get the max date, but the first id number. Normally I'd do a cursor in a procecure to get it, but the ISP has to grant the pivs each time the sp is modified so I am trying to do this in a simple query since it is called from php. As a work around, I am doing a max(id) as well since I figured that the highest id would always be associated with the latest date, but I don't want to make that assumption. Does anyone know how to build the query correctly to get the id associated with the latest date?

I published a C# Forms application to a directory on my server called ... /www/appBeta/ and the installation folder URL was /appBeta/ Everything worked and we decided to take the application live. So I changed my publish folder to /www/app/ and the installation folder URL to /app/ and it seems that Visual Studio has cached the installation folder of Beta/ It correctly published the application to the /www/app/ directory, but the setup in that directory references the /appBeta/ directory. I have shut down and restarted VS, I have rebooted my computer and I have gone through the publishing wizard again. The directories are correct in my project setting, but the published version has the OLD directory for the installation folder. Why is it doing this? I have seen I can go back and manually change the installation URL, but it is frustrating to see my project settings are not applied. Where is this old directory getting cached and how to I remove it so I can do a clean build and publish with the correct settings?

Thank you for the information. You are correct! Now I have a more interesting question. The WebBrowser object is installed with the suite of office products and I found a link on the microsoft site that allows people to install those objects, but when they click the link it says they must have MS office installed. So how do I take the Active-X control my application was built on and distribute it? It is a network application and I need to be able to distribute everything the user needs to run, but I can't force people to go buy office. Any thoughts on that?

I have a network application built using C# and for the most part 99% of my users have no problems with it. I have a few users that don't have IE installed and are using Firefox as their main browser and they have reported strange behavior in my application. One user was savvy enough to install IE and saw the display issues went away. This puzzled me since I would assume when you distribute a .NET 3.5 application that it would install all of the required components. Why would an installation of IE 7 or 8 improve the look inside my application? More importantly, why is the application not working properly without IE installed. I guess that is the bigger question here. Also, I have users telling me they can't click buttons and such. I am puzzled by this since it is merely a browser control. They should be able to click buttons and navigate as they wish. 99% of my user base is funtioning flawlessly, so I know it is not the application, but the environment. Any ideas where to look? The WebControl seems to be part of the 2.0 Framework.

I have an application that users collect data using a webbrowser control and a paser behind it to collect the data. When complete, users login in to a central site and we post the data collected. We have a clever user that has changed their hosts file to redirect the posting to a server they hosted where they then have access to the data. We are going to go with an SSL approach, but I need to make sure when we post the data that we are posting to the correct server and not a server someone has spoofed by changing their hosts file to point to a different server. We'd like to be able to establish a SSL connection to our server and validate the certificate in code. We are using the webbrowser control and I am not sure how to access the certificate so that we can see if we are indeed connected to the correct server. Any hints on how I might do this or where I might look?

I have another strange issue. I deployed my project with "available online ony" and it works fine for everyone except for one particular user. This user is on a college campus and is apparently using http proxy. Is there a specific port used when executing or something I need to be aware of to help troubleshoot this issue more? It is only for one user. It works fine for everyone else. Here is the log: The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.1.3 {version} Running checks for package 'Windows Installer 3.1', phase BuildList The following properties have been set for package 'Windows Installer 3.1': Running checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true Result of checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' 'Windows Installer 3.1' RunCheck result: No Install Needed Running checks for package '.NET Framework 3.5 SP1', phase BuildList Reading value 'SP' of registry key 'HKLM\Software\Microsoft\NET Framework Setup\NDP\v3.5' Read integer value 1 Setting value '1 {int}' for property 'DotNet35SP' The following properties have been set for package '.NET Framework 3.5 SP1': Property: [DotNet35SP] = 1 {int} Running checks for command 'DotNetFX35SP1\dotNetFx35setup.exe' Result of running operator 'ValueGreaterThanEqualTo' on property 'DotNet35SP' and value '1': true Result of checks for command 'DotNetFX35SP1\dotNetFx35setup.exe' is 'Bypass' '.NET Framework 3.5 SP1' RunCheck result: No Install Needed Launching Application. URLDownloadToCacheFile failed with HRESULT '-2146697211'

Thank you all for the input. By using a combination of solutions recommended, I was able to detect the condition. After the navigated event fires, I set a timer and if the documentcomplete event does not fire in the specified time, I can immediately detect the issue and alert the user. This is an acceptible work around for now. I will dig more in to the issue later. Thank you all for the advice.

I like the idea of digging in to this deeper. I need to figure out what is causing this event not to fire and this seems like a very good way to help isolate it. Thank you.

Dave, Thank you for the reply. Your recommendation makes sense. However, I was unaware that I am not guaranteed a DocumentCompleted event for each successful navigation. What would couse the DocumentCompelted not to fire? The strange thing is, I can see the page in the browser and I can interact with it, so the page has loaded (or so it seems), but again no DocumentCompleted event. Can you elaborate on when I can expect the event to fire and when not to? thanks for the reply. Jon

I have a C# 3.5 Windows form application that uses the webbrowser control. This control is used to navigate through a website, where I have a parsing engine that pulls data off the site and stores it in a file. The customer navigates to the site, presses the "record" button and the parsting starts. The parser is triggered by the DocumentComplete event. This works very well, but I have seen that this event sometimes does not fire. The customer has to navigate through 500 pages and by the time they get to page 500, we found that we are missing maybe 5-6 of the pages. We have traced the problem to be that the documentcomplete event is not firing all the time. My debug code indicates that the navigating and havigated events have fired correctly, but not the document complete. At the end of the 500 page run, I have 500 navigating events, 500 navigated events and a variable number of documentcompelte events, ranging from 490-495. We have not traced it to any single page, but are unable to figure out what is causing this. We even added a sound that beeps when the page loads and have found pages that load in the browser and are viewable, but the sound does not play because the event didn't fire. Any thoughts what might be causing this?