Monthly Archives: February 2015

xampp redirects localhost to website

Make sure the first entry in conf/extra/httpd-hosts.conf is this <VirtualHost *:80> ServerAdmin webmaster@dummy-host.example.com DocumentRoot “C:Xampphtdocs” ErrorLog “c:Projects/logslocal.co-error.log” CustomLog “c:Projectslogslocal.co-access.log” common <Directory “c:Projectshtdocs”> Require all granted </Directory> </VirtualHost>

Posted in Uncategorized | Leave a comment

Error: Apache shutdown unexpectedly xampp

16:50:25 [Apache] Status change detected: running 16:50:26 [Apache] Status change detected: stopped 16:50:26 [Apache] Error: Apache shutdown unexpectedly. 16:50:26 [Apache] This may be due to a blocked port, missing dependencies, 16:50:26 [Apache] improper privileges, a crash, or a shutdown by … Continue reading

Posted in Uncategorized | 2 Comments

How to pass parameters in Stimulsoft MRT Report

1. First declare your parameters in the datasource, parameter section. 2. Then simply pass it in the format exec fetch_student_date @rollno, @class

Posted in Stimulsoft Tutorials | Tagged , , | Leave a comment

SQL Cascaded JOIN

This is a form of JOIN that I was not aware of too after working with SQL for so many years. It’s syntax is as below: SELECT * from TABLE1 JOIN TABLE2 JOIN TABLE3 ON TABLE1.id=TABLE2.id ON TABLE2.id=TABLE3.id That is … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

analyse sql query

The following regex can be used to get the table name from an sql query (^from) *([a=zA-Z0-9_]*) or better (from|JOIN)[ n]*([a=zA-Z0-9_]*) Group 1 (^from) is used to get location of table. Group 2 (([a=zA-Z0-9_]*) is used to get table name … Continue reading

Posted in Uncategorized | Leave a comment

favicon not showing

You have updated your favicon but it is not showing. Even worse you are seeing the old default favicon after refreshing the page so many times. You even cleared the cache but even then it is the old favicon that … Continue reading

Posted in Tutorials/Tips | Tagged , | Leave a comment

invoke delegate with parameters

Download Ping Example Code (10kb) The following is a simple code to invoke a delegate with parameter. I created this to update label control on the form asynchronously. I did not quite work I was hoping for but the code … Continue reading

Posted in Tutorials/Tips | Tagged , , , | 1 Comment

AP.NET misplaced tags can give you big headache

I was trying to add a new tab to the existing 2 tabs. I copied some 250 lines of code of the second tab, changed all IDS and ControlIDs for validation etc and finally made the code work. But only … Continue reading

Aside | Posted on by | Tagged , | Leave a comment

How to add program to Windows Service?

If you want to add your own program to Windows Service (as you might want to keep track of things), there is an excellent utility that you can use. It is called NSSM Non-Sucking Service Manager. Download it from the … Continue reading

Posted in Utilities | Leave a comment

Add a linked Server in SSMS

I was having issue with running a linked server query and getting the following error Msg 11529, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1 The metadata could not be determined because every code path results in an error; see … Continue reading

Posted in SQL Server 2008, Tutorials/Tips | Tagged , | Leave a comment