This article explains in the most simpliest terms how to use action script to connect to MySQL via a php file in order to extract data for display in your flash application.
First, you build a flash game that keeps …
Author: James
SQL Server – Concatenate a column of multiple data rows into one generated column
Let’s say you have a table called ‘car_make’ and another table called ‘car_model’. There is a one to many relationship between make and model. You want to bring back a result set of all makes, 1 row per make, but …
SQL Server – Calculate age based on date of birth
Let’s say you have a database column called date_of_birth and you want to calculate the person’s age and create a new column called Age. It can be done like this:
(CONVERT(char,GETDATE(),112)*1-CONVERT(char, date_of_birth,112))/10000 As Age…
SQL Server – How to get First and Last day of current and previous month without time
Get first day of current month
SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP), 0) AS FirstDayOfCurrentMonth
Get last day of current month
SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) +1, -1) AS LastDayOfCurrentMonth
Get first day of previous month
SELECT DATEADD(month, DATEDIFF(month, 0, GETDATE())-1, …
Microsoft Visual Studio 2010 – How to add recaptcha and have it work with Microsoft’s CreateUserWizard
Let’s say you create a web site, and you want to add recaptcha to the aspx page where clients can sign up for an account. Instead of a custom sign up form, you instead use Microsoft’s CreateUserWizard control. I’ll explain …
Microsoft Visual Studio 2010 – How to Set Up Forms Authentication for Your ASP.NET Web Site
After developing a web site that uses Forms Authentication, you need to create a SQL database that stores the client’s log-in information along with any profiles. The tool that creates the tables in your database that is needed for your …
Microsoft Visual Studio 2010 – How to pre-compile your “Web Site” and FTP only portions of your site to your Host.
You decided to build a “Web Site” and not a “Web Solution”. You proceed to use the PUBLISH utility in Visual Studio and publish your entire site to your host. You later make a change to your Web Site and …
SQL Server Reporting Services (SSRS) – When to use OUTER APPLY instead of LEFT OUTER JOIN for complex SQL Statements
Scenario:
You create a report. You have one parameter called ‘CITY’ which contains all valid cities in the state of Florida. This parameter is used to report on all citizens that live in a particular city.
You have two tables.…
SQL Server Reporting Services (SSRS) – How to remove the first character of a multi valued report parameter when displaying the parameter in a textbox
There are times when you want to display in a textbox on your report the value of a multi valued parameter. If blank is a valid value for your parameter, you don’t want to display the comma in your textbox …
Silverlight – Silverlight plugin installed but not recognized as installed
This issue relates to Internet Explorer only. This problem does not affect Chrome or Firefox.
First, try this:
http://support.microsoft.com/kb/2608523
If that does not work or you get an error stating permission issues with AgControl.AgControl, then try this:
1. Run regedit …