This article explains in the most simpliest terms how to use action script to connect to SQL Server via an ashx file in order to post data from your flash application.
First, you build a flash game that keeps track …
Month: March 2012
Flash CS5.5 and AS3 – Flash (AS3) / ASHX (ASP.Net) / SQL Server – Get
This article explains in the most simpliest terms how to use action script to connect to SQL Server via an ashx (ASP.Net) file in order to extract data for display in your flash application.
First, you build a flash game …
Flash CS5.5 and AS3 – Flash (AS3) / PHP / MySQL – Post
This article explains in the most simpliest terms how to use action script to connect to MySQL via a php file in order to post data from your flash application.
First, you build a flash game that keeps track of …
Flash CS5.5 and AS3 – Flash (AS3) / PHP / MySQL – Get
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 …
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 …