It took me a while to figure out how to correctly output the results of a query with Cold Fusion as an XML formatted response. I had seen plenty of tutorials on how to actually write the XML file out on the web directory, but I wanted it available online so I could query it with AJAX and format the
Other News
More DB2 9 Fundamentals Certification Exam Tips
(Troy Coleman) Continuing on the theme of DB2 certification, let’s return to the planning section of the exam 730, “DB2 9 Fundamentals.” This section requires you to understand what tools are available, so we’ll review them and the menu options they fall under within the DB2 Control Center.
How I built the NOW_USEC() UDF for MySQL
(Xaprb) Last week I wrote about my efforts to measure MySQL’s replication speed precisely. The most important ingredient in that recipe was the user-defined function to get the system time with microsecond precision. This post is about that function, which turned out to be surprisingly easy to write
Oracle BI EE 10.1.3.3/2 – Presentation Layer Translation
(Venkatakrishnan J) Another interesting question came up in the forums today for which there is no proper documentation or rather incomplete documentation. The question was how do we Externalize Presentation Layer i.e enable translation of Presentation Layer depending on the User Logged in Language.
ASP.NET Compilation Models
(Jim Cheshire) In this chapter, learn the details of how ASP.NET applications are compiled. This information is not vital to your success as an ASP.NET developer, but having an understanding of the architecture of your development environment always makes you a better developer.
Using SQLCMD, SQL Server Show Posted
New SelectViews Show Posted Watch: SelectViews: Special On the Road Edition – Images in the Database, Push vs. Pull Replication and More. Previously… Watch: SQLonCall: How to Hire a DBA – Part 3/3 – The Interview. Questions to ask, answers to look for, interpreting the responses, making the decision. Watch: SelectViews – Replication, Part-Time DBAs, 60-Second Tip of the Day […]
A review of z/OS 1.9 features
(Robert Crawford) Announced in August 2007, IBM’s mainframe operating system, z/OS 1.9, is now generally available. This release of the operating system has its share of large and small enhancements. What follows are the ones that caught my eye. If you want more information, I suggest reading the z/
Automated E-mail Reports
(Andrew Mooney) This application will create simple HTML reports from a SQL Server database and automatically email them. It is a console application that takes a single XML file as an argument. This XML file contains all the settings for each report. Windows Task Scheduler is used start the applica
Optimized and predictable Ajax applications
(Judith Myerson) Wouldn’t it be nice for developers if all browsers, computer models, and Ajax application users were the same? Maybe, but the reality is that they are not. Developers face a myriad of challenges when developing applications that behave predictably across browsers, computers, and ind
Give Your Applications Mapping Capabilities, Part 2
(Bruno Zambetti) Google Earth (GE) provides a powerful 3D environment that you can use to provision your application with rich interactive 3D features. You can render points, lines or areas located at any point on earth—using either local, static, or positional data downloaded from the web. Your web