Cosmocentral - cosmocentral.com - Diary of an Entrepreneur Web Developer
General Information:
Latest News:
Insert Max int Type Primary Column Value + 1 – Microsoft Sql 3 Mar 2011 | 12:29 pm
If you have a primary column of type int, you need to insert unique values for it, best approach is set the column IS IDENTITY type true with identity seed 1. That way you wont have to worry about it....
Get Column Names of Table – Microsoft Sql 3 Mar 2011 | 11:10 am
This is how you can get the name of the columns from a table in MS SQL. SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = ‘TableName’ And if you want them as a comma separated li...
innerText Does Not Work on FireFox – JavaScript 23 Feb 2011 | 07:37 am
If you happen to try use the JavaScript property innerText on an element you wont get it work with FireFox browser. The reason is FireFox does not have a property innerText, rather they use a propert...
Just in time debugger keeps popping up in Visual Studio 2008 8 Feb 2011 | 03:15 pm
With VS 2008 this is an odd thing that just in time debugger keeps popping up when you have javascript url set with a script tag on the page. For example I find it very annoying as it keeps popping ...
Cannot find either column dbo or the user-defined function or aggregate or the name is ambiguous – Microsoft SQL 27 Jan 2011 | 07:25 am
You might get into this error when try to select from a table valued function in Microsoft SQL. Lets say you have a table-valued function named Test. If you call the function like this Select dbo.t...
Asp Menu Hiding Behind Page Elements 22 Jan 2011 | 07:00 am
If your asp menu elements hide behind other elements on the page, this could be a potential solution for you. Surround the asp menu in a div with a z-index style with it. <div style=”z-index:200″> ...
HTTP Error 403.1 – Forbidden: Execute access is denied – IIS 7 Jan 2011 | 08:45 am
In cases you have asp pages on your website but you get this error when you try to view the page on the browser. If you are getting this error there are two things to check. Make sure that you have a...
Byte Conversion Formula 5 Jan 2011 | 12:13 pm
This might be confusing for some people converting bytes for storage media etc. Here are the basics: 1 byte = 8 bits 1 kilobyte (K / Kb) = 2^10 bytes = 1,024 bytes 1 megabyte (M / MB) = 2^20 bytes...
jQuery, $ is Not Defined 31 Dec 2010 | 12:50 pm
If you get javascript errors like jQuery is Not Defined or $ is Not Defined its almost always the case you are either not referencing the jquery javascript file or reference is wrong. if you are ...
Too many characters in character literal – Asp .Net with JavaScript 20 Nov 2010 | 07:04 am
When you try to build a javascript string in asp .net you might bump into this error. The common cause of this not escaping the characters that need to be escaped. For example: StringBuilder sb=new ...
