I just finished fixing an issue for one of my clients that I wanted to share. I Googled for hours and couldn't find a fix, so now that I have found the cure, wanted to share it. Hopefully this will help someone in the future. The Symptom My user goes to a business website to access reports that were written with Crystal Reports. Their website offers to install the Crystal Reports Viewer (ActiveX control). You acknowledge that you want to install it and you get the following error: Internet Explorer Security Warning Windows has found a problem with this file. Name: activexviewer.cab Publisher: Unknown Publisher I do not believe it matters for this problem, but the user is using Internet Explorer 7. The Cure It appears that the vendor offering these reports is using an older version of Crystal Reports (2003) and the certificate on their ActiveX control is no longer valid. The cure is to tell Internet Explorer to not check the certificate on installs (which is a security risk),...
Open the command prompt (Start – > CMD) and type the following command: wmic bios get serialnumber Another command that will also print the model number (or make) of your computer is: wmic csproduct get name, identifyingnumber
Using MySQL, I can do something like select hobbies from peoples_hobbies where person_id = 5; and get: shopping fishing coding but instead I just want 1 row, 1 col: shopping, fishing, coding Answer: select person_id , group_concat ( hobbies separator ', ' ) from peoples_hobbies group by person_id ;