Welcome!

Default behaviour of the entity datamodel while setting the default value of a field in SQL's field designer

What should be the default behavior of LINQ-to-Entities while setting the default value of a field in SQL’s field designer ? Sometimes it’s difficult to come up with a topic…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
EXPLAIN your query in MySQL

EXPLANATION: id: This is a sequential number of the SELECT within the query. select_type: type of SELECT. Currently it shows SIMPLE because it is using single table without any UNION…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Creating Connection Object

Run a SQL query in cfscript by creating a connection string by accessing the servicFactory If we want to execute a Query like underneath in cfscript:– SELECT UserName,Email,UserType FROM UserInfo…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
MySQL: Using “ON DUPLICATE KEY UPDATE” while inserting record

Example: – I have a users table having following records :- Id       FirstName       LastName     JobTitle    AlreadyInserted 1        Albert          Roger     Software Engg     0     2        albert          Joseph    w Engg            0 3       …

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
How to write ColdFusion error log file in cfscript

I would like to share a small TIP which may help you all in recording errorLog in text file. I have written a piece of code like – ************************************************************ //…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
While working with AJAX ColdFusion Debugging may break your Ajax calls

In one of my recent project, at most of the occasions I was using Ajax and ColdFusion CFC to get the records from DB. But in some cases, in my…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
SQL Server Index – II (Clustered Index)

Why clustered index is important Suppose we have a table where no indexes have been defined and we are inserting lots of records to the table. In this case, the data…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Using Groups: How to retrieve data from Photos Application in iOS device

n many a application, we need to fetch photos from Photos application of the iOS device. And for that developer normally use UIImagePickerView that has a default layout and using…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
FQL, Permission , Facebook and iPhone

Select name, status from user where uid in (select uid2 from friend where uid1 = ) After setting up session and logging in ,a request is made using Facebook iOS…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!