Monthly Archives: September 2006

5 posts

Oracel Date function

When it comes to handling date and time, Oracle PL/SQL is not as easy or convenient as Microsoft SQL. For instance, with MS SQL, you can write a query like: SELECT * FROM SomeTable WHERE DateAdded = ’09-29-2006 08:00:00 AM’ But with PL/SQL, the above query will not run and will generate an error message like ‘not a valid month’. To make it work, you have to use “To_Date” function to convert the DateTime string […]

How to make a HTML table fill the whole screen

When creating a table with width=100%, the table will not fill the whole screen and there is a thin white space between the screen and the top, left, and right side of the table. To make the table actually fill the whole screen, we need to use CSS. In the CSS file, add “margin: 0px; padding: 0px;” to the Body tag as follows: Body { … margin: 0px; padding: 0px; } If you use FireFox, […]

File size limitations with the File Field Control in ASP.NET

By default, the maximum size of a file to be uploaded to the server using the File Field control is around 4MB. But we can make some changes in either the machine.config or web.config to increase or decrease the size limitations: In the machine.config file, find a node called <httpRuntime> that looks like the following: <httpRuntime executionTimeout = “90” maxRequestLength = “4096” useFullyQualifiedRedirectUrl = “false” minFreeThreads = “8” minLocalRequestFreeThreads = “4” appRequestQueueLimit = “1000” /> […]

Designer causes a Just-In-Time Error

Recently, I am getting a Just-In-Time error with Visual Studio.NET 2003, and the error is very unpredictable. It happens when I am working in the Designer. Last time it happened was when I selected a TextBox control and moved my mouse over the Properties Window(I set my Properties Window ‘Auto Hide’), then I got a dialog box that stated “Just-In-Time Debugging. An exception ‘System.ExecutionEngineException’ has occurred in DefaultDomain.” And then I got a choice of […]

Run server control event handler before executing javascript

Sometimes, we need to run the event handler of a server control before executing some javascript code. For instance, when user clicks a button called “Save and Close Window”, the application saves data into database, then closes the window automatically. How can we accomplish this? We can’t add an “onclick” javascript to the button’s attributes, because if we do, then the application will run the javascript code and thus close the window before it even […]