- August 6, 2011
- Introduction to HTM5 local data storage
I am doing some research on HTML5 supported client side local storage.
HTML5 introduces some new concept to store information on client pc. It is very help and opens a new dimension to create offline applications.
For local storage, HTML5 accepts use of SQLite database. Each of the method uses SQLite database. There are main three methods:
2. Web SQL
- By VIkas
- August 4, 2011
- CF Builder Error: "Unhandled event loop execution" when trying install new software
Got new project and started working this, going through documentation provided by client and where he mention code repository will be Git. Well, we use SVN for code version but never used Git, I do have idea about GIT and account in Github site but never get chance to look into it. As ususal to start with GIT first of all I look for eclipse plugin for this and found one at http://eclipse.org/egit/. Thoguht to give try and click menu "Help >> Install New Software..." and get alert need to start builder with administrator. I guess this is because CFBuilder installed on program files folder which usually require administrative access to add/remove files in it. So restarted cfbuilder with administrative access and again click on same menu but this time nothing happen, tried twice, thrice but nothing happen.
- July 20, 2011
- Camera and read directory was not working in BlackBerry 5.0 PhoneGap application - solved
Camera and read directory was not working in BlackBerry models with OS 5.0 when using PhoneGap.
I had deleted json2.js file reference from my html page, because I was not using this js library anywhere in my project.
After spending 2 hours, I realize that this file was used by PhoneGap js api to use camera and read directory, specially in 5.0 OS devices.
I didn't find significance of this file in PhoneGap documentation. That's why developers will survive in open source market.
- By Vikas
- July 8, 2011
- Get Drives list using ColdFusion in window
For one of my project where we were building file manager to give selection of server file, here we need list of drive letters to allow user to switch over drive. But I realize that cfdirectory doesn't give list of drives but obvioiusly our second choise is Java File component.
Below is code will retrive list of all drives ...
- June 24, 2011
- ColdFire not working with Firefox 5.
1. Download coldfire project and unzip it.
2. Find coldfire.xpi and extract it using 7zip.
3. Open install.rdf file and replace maxVersion tag with <em:maxVersion>5.*</em:maxVersion>.
4. replace em:version with <em:version>18.104.22.168</em:version>.
5. Zip again and later change extension to 'xpi'.
6. Remove exiting firebug and coldfire from firefox extension.
7. Download Firebug 1.7.3 (Not 1.8.* beta).
8. Drag and drop new .xpi file to firefox. Once installed restart it.
- June 20, 2011
- Forward Engineering Visio 2007 Database model to sql server
This is first ever I was trying for Visio Database model to design database without knowing that forward engineering doesn't support on Visio 2007. I googled it lot about this but doesn't find such direct option for forward engineering of Database model. After bit on searching I found that "Orthogonal Software Corporation" provide toolbox which let you export as xml of your database diagram and using xslt file (provided by Orthogonal Software Corportation) you can generate sql script.
- June 18, 2011
- jquery mobile error avoiding tip
For last month I am using jquery mobile. I’ve gone through lots of issues and learned a lot.
Web is good but when it comes with browser, HTML and java-scripts it becomes more buggy!
Generally I use chrome for development, and jquery mobile works perfect as it based on web-kit.
I tested and published my code, for desktop testing I use Firefox and chrome (not testing on IE as its jquery mobile). But when I open it in Android device, I see only half of the page rendering. And this is because of I made mistake in mark up language.
I forgot to close div tag and closed with li tag. In Firefox and chrome its ignored, but in safari it rendered differently.
See this code and output in chrome and safari, you will get the idea what i’m taking about.
Conclusion: While testing you web app IE is your acid test, while targeting web-kit or jquery mobile, safari is your acid test.
- By Vikas
- June 11, 2011
- SQL Query to list out all Identity column
Once I want to get the list of all tables which contains the identity column. After some googling finally I got the sql query which return all the tables which has identity column. It will also return column name, the Seed Values, Increment Values and Current Identity Column value of the table.
SELECT TABLE_NAME, c.name AS ColumnName, IDENT_SEED(TABLE_NAME) AS Seed, IDENT_INCR(TABLE_NAME) AS Increment, IDENT_CURRENT(TABLE_NAME) AS Current_Identity FROM INFORMATION_SCHEMA.TABLES INNER JOIN sys.tables t ON t.name = TABLE_NAME INNER JOIN sys.columns c ON t.object_id = c.object_id AND c.is_identity = 1 WHERE OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'TableHasIdentity') = 1 AND TABLE_TYPE = 'BASE TABLE'
- June 10, 2011
- Enable/disable link button in jquery Mobile
I am developing mobile application, where I use jquery Mobile.
Buttons can be created by input tag, button tag and even link tag. See examples:
- By Vikas
- June 10, 2011
- Run BlackBerry PhoneGap Application on other BlackBerry Models
I am currently developing BlackBerry Application using PhoneGap.
Basically PhoneGap is a BlackBerry WebWork project. Eclipse has plugins for that.
But when you use this Eclipse plugin, you can have only three simulators listed to test you Application.
- By Vikas