If you ever had to perform log mining in Oracle prior to 10g, you will be pleasantly surprised by how easy and fast it is in 10g. After using 10g for several years, I finally got a chance to use log miner in 10g. Until now, flashback queries were always enough to recover errant deletes and updates. Allow me to explain.
I’d like to present you with a few ideas for products that might make life a little bit easier: the skimmer sock, the floating fire pit, laptop legs and the scanner shredder.
Rather than creating insert and update queries in ColdFusion against an Oracle database, this function can generate the code for you. I haven’t added cfqueryparam to check the datatypes, but that would be ideal at helping prevent SQL Injection attacks.
If you use table and column comments, you can create an Oracle function that will create insert and update forms for you complete with table formatting and data type form fields that are limited to the number of chars in a column.
XHR or XMLHttpRequest is arguably the cornerstone of the web 2.0 schlock and, honestly, I think it does add a great deal of value to a web application when you can execute requests and not lose your context. For example, given a list of 500+ comments to review and edit, it’s nice to be able to edit them in place rather than, edit, submit, and scroll to find where you left off. That said, I […]