Software / Technology Tips

While working on a community project, this is what I learned. In my site a custom flash player is used to play the videos. That player can be customized for each member. They can create their own player with the selected videos and publish it in their site. So they want to know how many…

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 that we feel inspired to write about. I am writing about the problem I encountered while working with entity datamodel. After discussing with the team…

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 or subquery. table: Table from which row of output refer. type: ‘ALL’ , This will indicate full table scan for each combination of rows, which…

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 WHERE UserName = AND UserID = NOTE: Here connceting to database and SQL injection(SQL Attack) is control by coldfusion attribute ie datasource and cfqueryparam in…

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        Bob             Bette     Software Engg     0  INSERT INTO users (Id,FirstName,LastName,JobTitle,AlreadyInserted) values(1,‘Albert‘,’Roger’,’Software Engg’,0); When I will execute this query it will give me an error as “Duplicate…

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 – ************************************************************ // File to write the error log // file_to_search = 'c:testFile.txt'; // Details about the error to log // savecontent variable="data" { WriteOutput('' & "--------------------------"); WriteOutput(''…

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 local development server, I was facing some problems, while in the production server all were working fine. The difference I found only that I had…

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 does not get inserted in any particular order into the data pages. As a result the SQL Server has to do more reads to access…

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 that we can access photo library of the device. But in case we want to create custom views within the application for photo albums, for…

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 sdk as: NSString* fql = ; NSDictionary* params = ; call:@”facebook.fql.query” params:params]; But you will find out status and friend names are found to be…