tag:blogger.com,1999:blog-5127275476496996887Thu, 29 Oct 2009 09:37:37 +0000http://tips.p2psys.com/noreply@blogger.com (George S.)Blogger13125tag:blogger.com,1999:blog-5127275476496996887.post-8732459459132935407Thu, 29 Oct 2009 09:36:00 +00002009-10-29T09:37:38.156ZMySQLPHPWhen developing a multi-lingual web site, you may run into a situation when string data containing non-latin characters is not saved correctly to the database or the string data gets truncated. For example, recently we've had an interesting case. A string consisting of all Unicode characters was saved correctly while a string containing even a single accented character (e.g. Brésil which is http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/VQKTs77XsVE/fixing-incorrect-string-value-errors-in.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/10/fixing-incorrect-string-value-errors-in.htmltag:blogger.com,1999:blog-5127275476496996887.post-7483261815131340303Fri, 11 Sep 2009 12:45:00 +00002009-09-11T13:51:30.246+01:00PHPGenerating random strings is a frequently used programming technique. Random string are practically everywhere. For example, you may need to generate a random password, e-mail activation code, various keys and so on. Strangely enough, most of the programming languages and development platforms don't have such functionality built-in. Today we'll look how to develop this in PHP. To have a clear http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/VJBezLxySJM/generating-random-strings-in-php.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/09/generating-random-strings-in-php.htmltag:blogger.com,1999:blog-5127275476496996887.post-3715245013208952478Tue, 08 Sep 2009 17:19:00 +00002009-09-08T18:20:31.396+01:00.NETC#Nullable types is a great addition to the .NET framework. Having nullable types allows us write cleaner code. However, nullable types can be a source of problems, especially if you are still not well familiar with them. While there is no rocket science involved with nullable types, for beginner developers nullable types seem complex. Under the hood, nullable types are instances of the http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/Q672MzqcrLc/fun-with-nullables-nullable-object-must.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/09/fun-with-nullables-nullable-object-must.htmltag:blogger.com,1999:blog-5127275476496996887.post-2947178123392711516Sat, 05 Sep 2009 13:24:00 +00002009-09-05T14:24:45.930+01:00Visual Studio Visual Studio has a nice feature to add existing files to a project and the process if simple and straightforward. What about adding an existing folder to a project? This is especially useful if you accidentally remove a folder from a project. A typical action done by developers in this case is to create a new folder in the project, add existing files there, delete the existing folder and then http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/Mk3BpZ21JGg/how-to-add-existing-folder-to-visual.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/09/how-to-add-existing-folder-to-visual.htmltag:blogger.com,1999:blog-5127275476496996887.post-4453967310152344469Wed, 02 Sep 2009 11:35:00 +00002009-09-02T12:35:35.180+01:00MySQLPHPIf you insert a new row in a table that contains AUTO_INCREMENT field, oftentimes you may be interested in getting the value of the auto incremented field. This is a very common scenario if the value of the auto incremented field acts as a foreign key in other tables. There are plenty examples. For example, if you have Orders table, it most likely contains auto incremeted Id field and OrderItems http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/CJ3K3RxM37c/how-to-get-unique-id-for-last-inserted.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/09/how-to-get-unique-id-for-last-inserted.htmltag:blogger.com,1999:blog-5127275476496996887.post-7937718008111838486Tue, 01 Sep 2009 21:08:00 +00002009-09-01T22:11:56.518+01:00GeneralWe are glad to announce that from now on you can follow our team and particularly this blog on Twitter. We will be updating our Twitter feed when new posts are published. Our Twitter feed will also serve for general news from P2PSYS Development Studio.Stay tuned and follow us on Twitter at http://twitter.com/p2psyshttp://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/ZKE4TC3_zTM/follow-us-on-twitter.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/09/follow-us-on-twitter.htmltag:blogger.com,1999:blog-5127275476496996887.post-2571545521567474743Wed, 26 Aug 2009 13:49:00 +00002009-08-26T15:16:37.517+01:00MySQLPHPIf you want to format MySQL's DATETIME type field in PHP, you have several options. So, let's quickly review them.Option 1. The first option is to use MySQL's built in DATE_FORMAT function. For example, the following SQL command:SELECT DATE_FORMAT('2009-10-19 22:23:00', '%M %d, %Y');will return this formatted output: October 19, 2009.However, just in case you don't want to alter the SQL commands http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/xvi9IvpxVbg/format-mysql-datetime-in-php.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/08/format-mysql-datetime-in-php.htmltag:blogger.com,1999:blog-5127275476496996887.post-3132458360089924325Tue, 25 Aug 2009 17:29:00 +00002009-08-25T18:58:35.798+01:00C#You know what? Sometimes, the most obvious and easy questions are those that are the most frequently asked. One of such questions about C# is the difference between the cast syntax and the as operator. This is sometimes referred to as prefix-casting and as-casting.Without giving much thought to the difference, you may think that having two constructs for casting is somewhat redundant. However, http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/IgZODlluXxw/difference-between-c-cast-syntax-and-as.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/08/difference-between-c-cast-syntax-and-as.htmltag:blogger.com,1999:blog-5127275476496996887.post-5035258577900481422Sat, 22 Aug 2009 12:30:00 +00002009-08-22T15:51:11.742+01:00MySQLDatabasesString concatenation is a frequently used operation in programming languages and in SQL as well. In many programming languages + operator is used for string concatenation. There are exceptions of course. Take PHP, where dot (.) is used for string concatenation. The same is true for SQL. For example, in Oracle you can use a double pipe () or a special operator CONCAT. Microsoft implementations (http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/SbTZeYir4tQ/string-concatenation-in-mysql.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/08/string-concatenation-in-mysql.htmltag:blogger.com,1999:blog-5127275476496996887.post-329902405956301782Fri, 21 Aug 2009 20:00:00 +00002009-09-08T18:21:04.954+01:00.NETASP.NETASP.NET's FormView web control has a ChangeMode method to programmatically switch the FormView control between Edit, Insert, and Read-only modes. However, this method can be a source of many headaches. If you are calling the ChangeMode method but the FormView does not actually change the mode (e.g. to Edit mode from Insert mode) then keep on reading. You will certainly run into the above http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/mYZFaJEEeXE/formviewchangemode-problems.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/08/formviewchangemode-problems.htmltag:blogger.com,1999:blog-5127275476496996887.post-8239977723283602668Fri, 21 Aug 2009 16:09:00 +00002009-08-21T17:40:00.485+01:00JavaAndroidGoogle Android is an amazing mobile operating system. At the same time, Android is the youngest mobile system and as such in our opinion has the most potential for new developers. If you have ever programmed for Symbian operating system, you know what complicated it is. Android, on the opposite is an elegant system and the development is done in Java (though native code is possible but is usuallyhttp://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/zzv51Wb5dEA/best-ide-for-android-development.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/08/best-ide-for-android-development.htmltag:blogger.com,1999:blog-5127275476496996887.post-2430822534259461763Thu, 20 Aug 2009 20:33:00 +00002009-08-22T15:53:13.972+01:00PHPSEORemoving PHPSESSID from URLs is quite easy. However, beginner PHP developers usually struggle with this problem. If you don't think that having the PHPSESSID in your URL is not a problem, then think twice. First, this problem makes your website less search engine friendly. Secondly, having PHPSESSID in a URL increases security risks. Finally, it just ruins the aesthetics of your URLs. So, let's http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/Qbo41mLHcuk/how-to-get-rid-of-phpsessid.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/08/how-to-get-rid-of-phpsessid.htmltag:blogger.com,1999:blog-5127275476496996887.post-1324351566605051503Thu, 20 Aug 2009 18:55:00 +00002009-08-20T20:00:31.029+01:00GeneralWelcome to a new blog created by P2PSYS Development Studio developers for fellow developers out there. The main purpose of this blog to share our experience and knowledge with the development community.Knowledge is power and sharing knowledge is vitally important for making development community more effective and efficient.Our plan is to post short but concise posts about different aspects of http://feedproxy.google.com/~r/FreshTipsForDevelopers/~3/nhCTjR6lJi0/welcome-to-fresh-tips-for-developers.htmlnoreply@blogger.com (George S.)0http://tips.p2psys.com/2009/08/welcome-to-fresh-tips-for-developers.html