About viralpatel.net

viralpatel-profileHey Everyone! I’m Viral Patel. Welcome to my technology blog!

I created this blog to narrate my coding and technology learning experiences. I like sharing my experiments and ideas with everyone by writing articles on latest technological trends.

I work for an IT company as Technology Lead and in my leisure time I bake new recipes for applications and try my hands on latest trends on programming.

Primarily I write about Java, JEE, Spring, Hibernate, jQuery, PHP, CakePHP, Maven, Web 2.0, Cloud and the list goes on…. Of late I am trying new technologies such as Google app engine, play framework etc and I love it.

Not all the articles that you find on this blog are written by me. Intermittently my friends / colleagues share some very useful tips and tricks.

I write simple apps / tutorials to learn a new technology in my spare time. Here’s a list of things that I’ve done in the past.

Taj Operating System – TAJ is India’s first Object oriented multitasking, multithreading operating system created from scratch. It is written in C++ and assembly. Its 32-bit Protected mode Operating System. Read more about Taj on its homepage.

eazyDiary – Easy way to write / manage your personal diary online without any hassels and manage all your events and people you share your day with. This app is created using Play! framework in Java and hosted on Google’s very own cloud – Google App engine.

eazyBookmark – An easy way to synchronize your bookmarks between different computers. All you need to do is to add your links in eazyBookmark. Also you can login into eazyBookmark using your Google Account. So no hassle of rememberring passwords. The application is being hosted on Google app engine.

Realtime search – A real time search experience using purely Javascript and Google Search API

Spring 3 article series – A series of 7 articles on Spring 3 MVC which explains different aspects such as form handling, tiles plugin integration, internationalization / localization, themes in spring mvc etc.

Struts 2 article series – A series of 7 articles on Struts 2 which explains different features such as Validations, Interceptors, Tiles plugin integration, Ajax on Struts 2 etc.

Articles cited by other websites

Springsource
http://www.springsource.org/node/2997

DZone
http://java.dzone.com/users/viralpatel

Theserverside.com
http://www.theserverside.com/discussions/thread.tss?thread_id=61080

I’d love to hear from you! Say hello to me in comments section below, or if you’re shy then email me on viralpatel.net(at)gmail.com or follow me @viralpatelnet

149 Comments

  1. Sarita Patel says:

    Your website alwways provide me with lot of good information. Thank you.

  2. sanket patel says:

    Hey…
    I m impressed with blog..
    it’s having nice content…
    wants to b in contact with you..

  3. sandeep says:

    Great collection……

    hard to find such a site by gujarati…..
    keep it up…

  4. Hai says:

    I’m very impressed with this blog. You’ve done a very great job in giving useful tutorials.

  5. Surendra jha says:

    i am very impressed from your blog,
    and get lots of Solutions of my problem.
    Thanks ………………..

  6. phil says:

    Bon site pour les débutants, continuez ! thanks

  7. Viral Patel says:

    @all – thank you for your comments :) I will try to share more and more about new treading technologies.

  8. Renish says:

    Hi,
    You have made very useful website for new programmers and tutorials are superb..
    I learned Struts2 using your site only.

  9. prince says:

    That’s great site for newbie
    Keep it up to help for new learners…

    • Viral Patel says:

      @Prince – Thanks a lot :-)

      • correction says:

        Its Prince on Price. :p

  10. vaishali says:

    Great work Viral…Keep it up….

  11. good work dude………….tell me something about python career……….

  12. Grace says:

    Thanks u so much ..
    I am so lucky to find out your site :)

  13. Viral Patel says:

    Nice work man…
    keep it up…

  14. H-LEECH says:

    thanks brother nice work , keep it up

  15. Archana says:

    HI, Thank you so much… your site really helped me in understanding many things.

  16. Nice work mate! You have setup a really nice blog and lots of useful stuff. I am going to bookmark and read more of your articles.. Cheers!

  17. Lucky Bhumkar says:

    Thanx for sharing valuable information… salutes your ambitious work…

  18. Suren Dias says:

    your web site is great, i am from sri lanka and im using your web site regularly. thanks for the information you provide.

  19. Viral….
    Nice example of Struts2-Hibernate. Keep posting some more such examples.

  20. Srinivas says:

    Thanks Viral Patel. This is really is a great effort. Way to go!!!!

  21. vijay says:

    1 number

  22. Kinjan Ajudiya says:

    hiii viral,

    This very nice work done by you.People like me who are fresher in any technology can learn easily …Thanks buddy..keep it uppp…

  23. Name says:

    Hi Viral,
    i am surfing on ur site since 2 hours and it is very interesting, what i read for me!
    Thanks for the compressed and not too long Know-How ….

  24. Charles Owen says:

    Viral,

    This is a great site. I’ve learned quite a bit and will come back to this as a resource.

    Chuck

  25. Brijesh Kumar says:

    This is good for new things learning. Please continue….

  26. Laxman says:

    hi varal,
    your blog provides great information about struts framework….!

  27. nitin pawar says:

    Its great stuff I expect more on clouds like app engine amazon ECC and IBM smart cloud provide basic tutorial for those also for security of web service

  28. Hi Viral

    Wonderful work . I remembered my good old days in Bangalore when we used to exchange technologies with each other . We were a group of enthusiastic techno freaks always eager to help each other under the tag name of Gujju chaps.

    Those were awesome days . Thanks again for your wonderful blog and I would love to be in touch with you

    Cheers

    Sandeep

  29. Viral Thakkar says:

    your blog provides great information.!!

  30. Rakesh says:

    Hi Viral,
    Thank you so much for providing these kind of tutorials which helps us to learn new concepts in a quicker and eazier way….Keep up your goodwork……

    your presentation is too good….

    Thanks
    Rakesh

  31. Mansa says:

    Hey!!!! your website is too good for a quick and clear picture of new and great information’s on new technologies,,,,,thanks for it

    • Viral Patel says:

      @Mansa – Thanks a lot :) I really appreciate your words. Hope I would write more about new technologies. Do read more on this website and also share if you like. Thanks.

  32. kevin says:

    hello, thanks for your help and i get some information that i need ,

  33. Vishal says:

    Hi Viral

    Would you mind sharing your experience with Google App Engine?

    Thanks
    Vishal

  34. Rakesh says:

    Your website is a great teacher!!

    • Viral Patel says:

      Thanks Rakesh.. For the wonderful comment.. :)

  35. Chetan Jadhav says:

    Very good technical blog.
    I am learning struts2 from your blog.
    Thanks

  36. vishwaprakash says:

    hi viral
    its really a great collection and blogs i just love to read it …. keep going
    thx.

  37. Raja says:

    Can’t stop……Bookmarked

  38. Hiren Vyas says:

    it’s great to see that some one like you providing such good tutorial and help to needy. i really surprise when i found this blog. i’m mca student currently pursuing my internship using framework struts 2 and hibernate. please guide me to become good programmer. Thank You.

  39. Tom says:

    Hello Viral,

    I am new to your web site and i am new to eclipse IDE. I enjoy your teaching material so much. You are very good teacher. I find most of the thing i need. There is one more thing i need that i’d like to ask you if you don’t mind. Could you help me by pointing me a good web services tutorial for beginning in Eclipse Indigo. Thanks.

    Tom

  40. Debdutta says:

    Hey Viral.. Really u r a real gem .. Excellent initiative.. I must say U hv really great enthu to enlighten us … Thanx a lot buddy

    • Viral Patel says:

      Thanks a lot buddy! I appreciate your words :)

  41. ankit says:

    sir i want to know that how to that how to set text fields of a web site page which is hosting on another server with the the data enter in my web page… which is running on local host . also how to call submit function of that web PAGE WITH OUT actually CLICKING IT……………

    sir plz.. reply as soon as you can…..

  42. Ankit says:

    Hi.
    These r very useful stuffs.Thanx for sharing.I like ur OS too.:-)

  43. daniel says:

    i am a beginner in struts 2 development and your tutorials help me so much! thanks!

  44. sjain says:

    Hey Viral! I am looking for someone who can develop a custom search api on google. I thpugh you might be helpful. Email me

  45. Nupur Chaube says:

    Great Efforts! Keep it up!!!

  46. kumar says:

    man u rocks……..superb website…..

  47. Darshit Joshi says:

    Hello Viral,
    Your post has been very useful to me learning Struts 2.
    Thank you very much. Keep it up!

  48. sanket says:

    thanks viral …its really nice one ….its really helpfull to me ..again thanks a lot ..

  49. Vikas says:

    Thanks for the wonderful posts!

  50. Deepika Rawat says:

    Your blog provides a lot of information about new technologies…. Since I got know bout your this blog, I am always here continuously and take help to enhance my knowledge :P …….. Thanks :) :)

  51. Anurag says:

    nice blog buddy keep up the good work , this site is really useful.

  52. GB (London) says:

    Very helpful blog for beginners on technologies you cover. Great work!

  53. phphunger says:

    wow…nice blog patel..i liked your blog…very informative…good work..keep rocking…

  54. Amit says:

    Hello Viral,
    its pleasure to hve friendship with u.

  55. prabhat says:

    nice work dude……keep it on …

  56. Suyash Jain says:

    hi pal,

    very good site… i too want to use the same template for my site… can u help me in this….

  57. Hitesh Saliya says:

    Jsn viral,

    Its me, Hitesh Saliya, your classsmate.

    Good blog….

    Keep it up!!!!!!!!!!!!

    • Viral Patel says:

      Hey Dude :) Good to hear from you! Hope you doing well.

      • Yes… Enjoying here in Gujarat …
        Settled in gandhinagar.
        Did the progress : 2 childs :)

  58. Torsten says:

    Hey Viral,
    you really helped me a lot realizing my damned JQuery Autocompletion-jsp! Thanks a lot for that!
    I really like the way you restrict your example-code to the most important, then it’s very easy to see how it works and what is crucial!
    Keep on helping the world!
    Torsten (from Germany)

  59. subbbiah says:

    really super tutorial

  60. Prashant says:

    Hi Patel,

    I am looking for a Google CSE customizing and have not found a reliable answer and hence checking with you…

    The customization that I am looking for on google CSE is to give the user three different options of searching from the same search box.

    a. Custom Search the Site..
    b. Custom Search a list of URLs
    c. Search the web.

    The idea is to have a radio button so that the user can choose if he wants to search the site, the list of links or the web.

    Is this possible?

  61. amit says:

    Hi viral,
    amazing work ….. I wanted to be your friend.. can we ?
    i like your attitude …. how old are you ? ur work is too good

    send me email

    tc

  62. Swadeep says:

    Hi Viral,
    I liked your site and tutorials.
    Whihc template you use for this site!

    Thanks
    Swadeep

  63. Abhilash sharma says:

    Hii Viral,
    Your blog is really very helpful for beginners.You understand the areas of beginners where to focus and starting from very basic you make the learner comfortable and confident.your blog about struts helped me a lot to work on struts.thnx buddy.keep it up….thnx a lot..

  64. Vishal Patel says:

    Hi i am trying to check boolean value true or false in if condition inside tag in struts2. My code is as below

    But every time its goes into else condition. can anyone help me out??

    Can u pls mail me solution??

  65. Behzad says:

    Dear viralpatel,

    I’m beginner in web programming.
    I’m looking for the best IT institute in India to learn java and JEE and some good frameworks.
    For this reason I would ask you that where is the best place for learning which i mentioned ? and why is good there?

    Regards
    Behzad from Iran

  66. sharman says:

    nice work dude keep on.
    .

  67. Berni says:

    Thank you for your pages. I stumbled in with your “20 very useful Java code snippets for Java Developers” and ended up surfing most of your stuff. I especially like that it all is well written and almost all of it has good code examples and links to where you got it from.
    Is it procrastination if I end up coding stuff inspired by your site that I don’t need in my current project? I don’t think so. Who knows when I’ll need QR-Codes ;-)

  68. Shamshul says:

    Nice work

  69. nishanthjohn says:

    Best tutorial ever found.Very helpful in understanding the concepts.Provided with a lot of examples.Thank you very much.

  70. Adil says:

    hai
    I want to develop an android app to send sms messages with speech recognising interface. Could you please help me to develop it.

  71. Dolly says:

    Nice blog Viral.. i love eazyDiary, thanks!

  72. Prasad says:

    Hi Viral,

    I m trying to find information about deploying a Favicon Icon to my application.
    Could you please pass on the detailed information about how this icon is added to your application ?

    Thanks

  73. sunny says:

    Hi Viral,
    Is the feature of importing existing bookmarks to eazyBookmark is available. If yes, then plz tell the steps to follow….

  74. tushar says:

    Hi Viral Patel :)
    Cool :) Nice :) Blog :) Buddy
    keep up the good work :),
    this site is really useful :)
    Thanks A Lot

  75. Gopi Shiva Krishna says:

    Hi Viral patel,

    Your blog is amazing, it answered all my questions.

    Best tutorial ever found.Very helpful in understanding the concepts.Provided with a lot of examples.Thank you very much.

    Thanks a ton ViralPatel.. :-)

  76. shweta says:

    hey i want make image processing app in android . want to effects (sepia,blur,snowwhite etc……)
    .there is inbuilt class in android i.e. media.EffectFactory ,it contains string functions . can u tell me how to implement those functions in my code

  77. Prashant says:

    nice blog viral… keep it up…

  78. Aditya B says:

    hey,
    Viral, This is really a gr8 blog. I had some problms in struts, but now they are clear. Wow cant believe that learning struts wud be so easy..!
    Anyways Thanks a Lot..!
    Bye.
    Aditya B

  79. Chiranjiv says:

    Hi Viral Patel,
    I have jsp view in which value from controller are displayed using display tag I want to add a new column with check box, so when i check a particular check box and click update , defined controller should be able to get that particular selected row corresponding value and process it further. Please suggest me the way to do it

    Thanks in Advance
    Chiranjiv

  80. Rajesh says:

    Hi Viral,

    Im new bee to IT industry. Currently i joined in a small concern as a java developer. Many of my troubles in development has been solved by your tutorials. Thanks a lot. And im here for asking you a favor? Since im a new bee i know Java,J2ee,Servlets, Jsp. I want to add up stuffs. can you help me out like den vat i hav 2 learn? which r all useful for my career. Im very passionate towards coding. Thanks in advance

  81. lalit says:

    sir i am creating “e-shopping” project on J2EE so give me guide for “how to online transaction ? ” .

    sir help me …..

  82. Taichiseal says:

    Hi Viral
    I came across your blog/post while searching for a way to replace the Google Reader Shared Items widget on my blog ahead of the death of GR on 01July2013. I am thinking perhaps I can “save” the items I want to share on Feedly, then find a way to push them onto a Blogger widget. Or push “Archived” items from Pocket. Do you think that will work? If so, how can I do the “pushing” to Blogger ?
    Regards
    Taichiseal / Singapore

  83. Abhijit says:

    Viral

    I am stuck with this one for a long time and cannot find a way out. Please help me out.

    I have two tables applicant and DS_1350. One applicant will have one ds1350 record and the applicant_id (auto generated) in the applicant is foreign key to the ds1350. When I try to populate the Applicant class with DS1350 data in it and save, the foreign key in the ds1350 table is getting saved as null, the row is created though. Parent is fine.

    @Entity
        @Table(name = "applicant")
        public class Applicant implements Serializable {
            	private static final long serialVersionUID = -8634638904962909584L;
            	// Primary id required by Hibernate
        	@Id
        	@GeneratedValue(strategy=IDENTITY)
        	@Column(name = "applicant_id", nullable=false, unique=true)
                private Long applicantId; // Unique id for each applicant
            	@OneToOne(cascade = CascadeType.ALL)
        	@Fetch(value = FetchMode.SELECT)
        	@JoinColumn(name = "applicant_id", referencedColumnName= "applicant_id")
        	private DS1350 ds1350;
        }
        @Entity
        @Table(name = "ds_1350")
        public class DS1350 implements Serializable {
        	private static final long serialVersionUID = -7370747595057569296L;
            	// Primary id required by Hibernate
        	@Id
        	@GeneratedValue(strategy=IDENTITY)
        	@Column(name = "ds_1350_id", nullable=false, unique=true)
        	private Long ds1350Id;
        
        	@Column(name = "applicant_id", unique=true, nullable=false)
        //    @GeneratedValue(generator="gen")
        //	@GenericGenerator(name = "gen", strategy = "foreign", parameters = @Parameter(name = "property", value = "applicant"))
        	private Long applicantId; // Unique id for each applicant
        
        	@Column(name = "ds1350_no", length = 50)
            private String ds1350Number;    
        }
         public class ApplicantDaoTest {
        	@Autowired
        	private ApplicantDao applicantDao;
        	private Applicant applicant;
        	private DS1350 ds1350 = new DS1350();
        	@BeforeClass
        	public static void beforeClass() {
        	}
            	@AfterClass
        	public static void afterClass() {
        	}
            	@Before
        	public void setup() {
        		this.initApplicant();
        	}    	
        	@After
        	public void teardown() {
        	}
        	private void initApplicant() {
        		applicant = new Applicant();
        		
        		applicant.setFirstName("John");
        		
        		Calendar calendar = Calendar.getInstance();
        		applicant.setDob(calendar);
        		
        		applicant.setSsn("123456789");
        		applicant.setCreatedBy("JUNIT");
        		applicant.setCreatedDate(Calendar.getInstance());
        		applicant.setModifiedBy("JUnit");
        		applicant.setModifiedDate(Calendar.getInstance());
        		
        		this.initDS1350();
        		
        	}    
        	private void initDS1350 () {		
        		ds1350.setDs1350Number("ds1350Number");
        		ds1350.setCreatedBy("JUNIT");
        		ds1350.setCreatedDate(Calendar.getInstance());	
        		
        		applicant.setDs1350(ds1350);
        	}    	
        	@Test
        	public void testSaveApplicant() {
        		Long applicantId = applicantDao.saveApplicant(applicant);
        		applicant = applicantDao.getApplicantByPrimaryKey(applicantId);
        		assertTrue("ds1350Number".equals(applicant.getDs1350().getDs1350Number()));
        	}
            
        }
    

    Applicant table (Parent)

    Ds1350 table (child)

    The applicant_id is null here which should have been 6000386 and that’s the issue.

  84. You are doing a good job and many of the beginners like me are referring this blog for some references.

    Thank you !

  85. vishal jain says:

    Hi Viral,
    You are doing a great job by sharing so much useful information.
    Recently I’ve also started blogging, my links are in:
    https://en.gravatar.com/jvishal
    People like you are always kind of inspiration to me.

    Thanks,
    Vishal

  86. H Thaker says:

    Hello,

    Content on your blog is very informative.

    This is really a kind of “Knowledge Sharing” platform.

    Keep up the good work…

    Thanks,

    H Thaker

  87. Ram says:

    Truly very informative and really helpful, great job!

    Thanks,
    Ram

  88. Rohit Kapdi says:

    Hello,
    Nice website and a different one for IT people.
    So any plain to work on .net and ms-sql.

  89. Sandip says:

    Good work viral.Pls write tutorial on spring and velocity integration.

  90. veerendra kumar says:

    I am doing my practice(HIBERNATE,SPRING ) with the help of ur articles and my own, plz provide more examples both(xml+annotations based) thank you so much for you & ur team members……………

  91. Prince says:

    Please send me some example for creating custom action bar in android.
    Thank You very much!!!!!!!!

  92. Nirav says:

    you look hot..

  93. isha says:

    Hello Sir,
    I’m new to android.I’m working on a project in which user can see his call details,sms details and data pack details of a month.sir can you please give me the code for sms and data pack details.It would help me alot.I’m new to java language also please help me asap.
    Thank You

  94. kiran annaluri says:

    Viral, This is really useful blog to the knowledge seekers…Keep it up and all the best

  95. Happy says:

    Hey, I read you are using wordpress on your site. Can you tell what theme you are using for this site ?

  96. Sangita says:

    Hi Viral,
    I m impressed with blog..
    it’s having nice content…
    wants to b in contact with you.

  97. Paridhi says:

    I am stuck..i am not getting code to send image in message(MMS) in android… Please help.. !!!
    Waiting for your soon update for the same.

  98. Archana says:

    hi viral patel!
    we are following your blog for our project its nice!
    but in all your examples, after saving an record into db only that same record its displaying! not the dynamic record that means if we give any id that particular record should display in the jsp page .that example is not there! i request you to post that example (using spring+hibernate+struts2)!if that example is already exist please share the link!
    i am trying but unable to get solution. i just need that example………….

    please do the need full.

    regards
    archana

  99. Vipul Patel says:

    Hi Viral,
    I need your help to build some Drag n Drop UI Concept..so please send me your contact information.

    Regards,
    Vipul

  100. Justin says:

    Hi Viral,

    Thanks for the informative blog that you have created.
    I have really learnt a lot from your tutorials as your explanation is clear and easy to understand.
    Appreciate that you can continue to post more in future :)

    Cheers,
    Justin

  101. Mahesh Patil says:

    Hi Viral,

    Nice to refer your site and blogs…. It is really helpful and informative.
    I need your suggestions on cookieless wep site development and authentication.

    Currently we are facing issue in captcha values , struts token autentication etc…
    It is all working fine if we enable the cookies for third party. However since we can’t ask users to enable cookies we need some solution on the same.

    Pl. suggest

    Thanks
    Mahesh

  102. Dinesh says:

    Hi thansk for information and tutorail.

    • narayana says:

      nice tutorial

  103. Rina Patel says:

    Hi Viral,
    your posts are very informative.learnt a lot from you.thanks.keep it up

    • calipus says:

      Hi Viral Patel,
      A big thanks for your posts. I am a regular reader of your blog and looking forward to some interesting posts on node.js. Please do add some posts related to the same.

  104. Anaida says:

    Hey Viral,
    Like your tutorial on Angularjs. I want some more on that describing $stateParameter and resolve. I am working on a project and used ui-router for the same. Want to pass parameter as a object so that can get all the values in other state. Can you give some example on this?

    Thanks in advance,
    Take care,

  105. Satya says:

    Is comment disabled on post? I saw the form and submitted a comment but did not received any response on the page. So, just informing you.

  106. Hi Viral,

    I like all your posts and fan of you and wanna learn angularjs and object oreinted javascript so can you please provide me some basic stuff so i can learn

  107. Chris Sanjiv Xavier says:

    Hi Virat can you tell me the how to auto.profile file would be for the greenplum database connection

  108. Vijay says:

    Hi Viral,

    Could you please post article about Podcast tutorial and I want to start podcasting in for technical vlog.

    Thanks,
    Vijay

  109. Anu says:

    Hi Viral,

    I was expecting lot of Dojo Tuts from you, i was been working as dojo begginer since there no exact documentation for it rahter than dojotoolkit org i expect you to post some cleared and expalined very well tuts as all above for dojo also

  110. ara says:

    congrats buddy and all the best

  111. Paulina says:

    I would like to know if you have any blog about a small app to detect the device that a person is using when browsing(PC/Mobile) using Spring.

    Thanks

  112. Paulina says:

    BTW your site is awesome very good exercises.

  113. harshida says:

    Hi viral,

    Is it possible in api controller in multiple get method with same datatype parameter.
    if possible than how to use with angular routing?

    • Imran Khan says:

      Interesting blog

  114. kartikpatel says:

    hello mr. viral patel

    i want to join with you and i want many help .so i want your skype account or any other contact that give me response any time

  115. Mukesh says:

    I need your help.I want to know good domain hosting site for Java web technology . I am interested in software development business . I have 2 year experience . I am working on jsp,servlet,hibenrate,struts,spring ,mysql 4.1.html,css,jscript.

  116. Haresh Prajapati says:

    Hi viral,

    How HashMap values() method works? Compiled code of hashmap values method is shown as
    public Collection values()
    {
    Collection localCollection = this.values;
    return this.values = new Values(null);
    }

    private final class Values extends AbstractCollection
    {
    private Values()
    {
    }

    public Iterator iterator()
    {
    return HashMap.this.newValueIterator();
    }
    public int size() {
    return HashMap.this.size;
    }
    public boolean contains(Object paramObject) {
    return HashMap.this.containsValue(paramObject);
    }
    public void clear() {
    HashMap.this.clear();
    }
    }
    here in statement
    return this.values = new Values(null);
    there is not any single argument constructor of private final Values class though how code works fine?

    • name says:

      Witch compiler did you use.

  117. Bhavik Patel says:

    You are doing great job.. I am regular reader of your blog.
    I want to request your for Explore more articles on Angular.js.

    Regards
    Bhavik Patel

  118. Santosh Kumar Chourasiya says:

    well done!

  119. Rohit Debnath says:

    Hi Viral,

    I am a reader of your articles. I really enjoy your tutorials are easy to follow. Recently i came across Cygnite PHP Framework – The new Cool Kid. Looks good and promising but new to PHP world. I am interested to develop my coming project using Cygnite.

    I would like to see tutorial step by step of below –

    i. Insert, Update, Delete with Jquery, Ajax using Cygnite Framework.

    It will be really helpful for me to proceed if you please write in your next article.

    Thank you!

    With Regards,
    Rohit

  120. anil says:

    As a regular reader of your blog, i find it as one of the very giid written article for bith experienced and novice technical persons.

  121. Jayganesh says:

    0 down vote favorite

    I am trying to design a print page in which values such as amount,amount in words,date will be read from server side (here jsp scriptlet).On taking print of this page on a blank cheque, the scriplet values should appear against corresponding labels.

    I have written html code to adjust these values:

    The page size is defined in css as:

    body {
        height: 4in;
        width: 8in;
        position:absolute;
    }

    The widths defined above are calculated by manually measuring cheque dimensions in mm and then converting it to pixels. When I take print out the values dont appear in front of corresponding labels as expected.

  122. Naveen says:

    Hi Viral,
    How to create the tree structure in angularjs.Each node with different views(like html forms,tables).

  123. pavzie says:

    I am impressed with your blog and content. I need to currently setup a technical blog. Can you give me some tips about your hosting details.

    Thanks again!

  124. Sai says:

    Hi Viral sir
    Is any post by you where web application which is built without using maven.
    A simple application with spring, hibernate, struts but without maven.

  125. Saurabh says:

    Hello Viral,
    Thanks for all great sharing. One thing I want to inform you, viralpatel.net is getting hanged very frequently from few days. I was trying to read your blogs on Angular Js but screen get freeze after ~1 minute. Some time it also crashesh shockwave player and we need to close tab. Can you please fix it ? looks like s3.buysellads.com taking forever to load

  126. krishna says:

    hi

    good example of angular js controller.. and I want to see more example of angular. I am angular beginner.
    also show example of dependency injection concept.

  127. susovan says:

    Hi Viral, Just came across your blog while searching a solution. Good work buddy. All the best.

  128. Brahma says:

    Excellent postings. thank you!

  129. RohitSG says:

    yes, here is a good stuff

  130. Saurabh Patel says:

    OPB As Currency
    Dim SqlUpd As String

    Public Function CalBal(amount As Currency) As Currency
    Set Db = CurrentDb
    DoCmd.SetWarnings False
    ””” ///////////// Calculate balance in Alltran
    Set Dt2 = Db.OpenRecordset(“Select mainid,opbal,clbal,tt,id from alltrn where tt=’OP’ order by mainid”)
    If (Dt2.RecordCount > 0) Then
    OPB = 0#
    Do While Not Dt2.EOF
    OPB = Dt2(“opbal”)

    Set Dt1 = Db.OpenRecordset(“Select id,tbno,trno,tt,mainid,amount,opbal,clbal from qalltrn where mainid=” & Dt2(“mainid”) & ” and tti -1 order by mainid,tdate,tti,tt,tbno”)
    If (Dt1.RecordCount > 0) Then
    Do While Not Dt1.EOF
    CLB = OPB + Dt1(“amount”)
    SqlUpd = “update alltrn set opbal=” & OPB & “,clbal=” & CLB & ” where id=” & Dt1(“ID”).Value & ” and tt='” & Dt1(“tt”).Value & “‘ and mainid=” & Dt1(“mainid”).Value
    Db.Execute (SqlUpd)
    ‘DoCmd.RunCommand (SqlUpd)
    OPB = CLB
    Dt1.MoveNext
    Loop
    Else
    CLB = OPB
    SqlUpd = “update alltrn set opbal=” & OPB & “,clbal=” & CLB & ” where id=” & Dt2(“ID”).Value & ” and tt='” & Dt2(“tt”).Value & “‘ and mainid=” & Dt2(“mainid”).Value
    ‘DoCmd.RunSQL (SqlUpd)
    Db.Execute (SqlUpd)
    End If

    SqlUpd = “update LMaster set Clbal=” & CLB & ” where lid =” & Dt2(“mainid”)
    Db.Execute (SqlUpd)
    ‘DoCmd.RunSQL (SqlUpd)
    CLB = 0#
    Dt1.Close

    Dt2.MoveNext
    Loop
    Dt2.Close

    End If
    End Function

    how convert all above vba(access) code in to sql store procedure or function

  131. Saurabh Patel says:

    CLB is also Currency type variable

  132. Saurabh Patel says:

    any one can help me?

Leave a Reply

Your email address will not be published. Required fields are marked *