msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

ColdFusion bug or feature?

Consider this simple ColdFusion code (CFMX Ent 7.0.1.116466 and Oracle DB 8.1.7.4): Continue reading…

4 Comments | Filed in ColdFusion | Tags:


maxlength: Firefox vs. IE

I bumped into an issue while testing one of my ColdFusion applications. The issue is how Firefox and IE render HTML. Take the following HTML input tag in test.htm for example:

<input name="field" type="text" value="1234" maxlength="3">

Now, if you view it in Firefox (1.5.0.1) you will only see 123 in the input box. However, if you view it in IE (6.0) you will see 1234. Looks like Firefox truncates the value based on the maxlength attribute, but IE does not.

However, in the example above, both browsers do not allow you to enter a value more than 3 characters in length.

2 Comments | Filed in ColdFusion, Firefox, Tips | Tags: , ,


LOBs Gotcha in ColdFusion

A few weeks ago I wrote a post about how to Save/Download files to/from Oracle using ColdFusion. The example I used in the post was about saving Excel files as a BLOB in an Oracle table.

Today, I ran across an issue with file sizes greater than 244 KB. I was testing with a 7 MB Excel file. The file was correctly saved in Oracle and I could see that the BLOB size was indeed 7MB (using dbms_lob.getlength). However, when I tried to download it, it would not download more than 244 KB.

After some research, it turns out that, in the ColdFusion administrator (CFMX V7), if you go to Data Sources under Data & Services and edit the data source you used to retrieve the BLOB, there is a setting under the Advanced Settings to Enable binary large object retrieval (BLOB). In my case, it was unchecked. So, make sure to check this checkbox if you want to return the entire contents of any BLOB column in the database for your data source. If not checked, ColdFusion MX retrieves the amount specified in the BLOB Buffer setting, which, in my case, was 250000 bytes or approximately 244 KB. That explains it!

To summarize, if your application uses BLOBs or CLOBs to store/retrieve data from the database and you do not know (or do not want to enforce) what the maximum size of your BLOB or CLOB data is, make sure to check the Enable binary large object retrieval (BLOB) or Enable long text retrieval (CLOB) settings for your datasource in the ColdFusion administrator.

4 Comments | Filed in ColdFusion, Oracle | Tags: ,


Search AFM KB and read MXNA blogs from Google toolbar

Adobe (formerly Macromedia) Internet Explorer users, now it is your turn. With the release of the latest Google toolbar for IE, now it is possible to add custom buttons to the toolbar that will let you visit and search your favorite websites and keep up with interesting feeds. So, I went ahead and created two custom buttons, one for searching Adobe Knowledge Base, another for reading blogs from MXNA: Continue reading…

Comments Off | Filed in ColdFusion, Technology | Tags: , , , ,


Saving/Downloading files to/from Oracle using ColdFusion

Here is how to store and download Excel files to/from an Oracle database using ColdFusion.

Continue reading…

34 Comments | Filed in ColdFusion, Oracle | Tags: ,


PLSQL Ranks 12th

According to the TIOBE Programming Community Index for January 2006, PL/SQL is the 12th most popular programming language, down from 11 last year. ColdFusion is 16th, up from 25th. The top 3 are Java, C and C++. Does this mean that I have to sharpen my Java and C skills to be competitive? (via)

5 Comments | Filed in ColdFusion, Oracle, Technology | Tags:


ATTENTION bloggers

If you are an Oracle blogger or a Macromedia (now Adobe) blogger, you are invited to add yourself to the bloggers group on frappr and Google groups.

Oracle bloggers, please go to frappr.com/oraclebloggers to add yourself. Clicking on the Group Forums link will take you to groups.google.com/group/OraBloggers, you can register yourself there too. Note that only bloggers who are aggregated by OraBlogs or OraNA are eligible to join the group.

Adobe (previously Macromedia) bloggers, please go to frappr.com/mxbloggers to add yourself. Clicking on the Group Forums link will take you to groups.google.com/group/MXBloggers, you can register yourself there too. Note that only bloggers who are aggregated by MXNA are eligible to join the group.

1 Comment | Filed in ColdFusion, Interesting, Oracle | Tags: ,


HTTP POST from inside Oracle

A while ago Robert and Pete blogged about Oracle’s UTL_HTTP package. Robert gave an example of how to use this package to request a web page from the Internet into Oracle and Pete mentioned that you could do the opposite, i.e. post data from Oracle to the Internet. Recently I had a requirement to do just that, HTTP post data from the Oracle database to another web server. So, I wrote the following generic procedure util_pkg.http_post. Here it is followed by an example of how to use it (tested on 9.2): Continue reading…

23 Comments | Filed in ColdFusion, Oracle | Tags: , , ,


Ajax bathroom cleaner and more

Yes, there is that and there is also “Asynchronous JavaScript and XML”.

Jesse James Garrett, the person who invented the acronym AJAX, defines it:

Ajax isn’t a technology. It’s really several technologies, each flourishing in its own right, coming together in powerful new ways. Ajax incorporates:

  • standards-based presentation using XHTML and CSS;
  • dynamic display and interaction using the Document Object Model;
  • data interchange and manipulation using XML and XSLT;
  • asynchronous data retrieval using XMLHttpRequest;
  • and JavaScript binding everything together.

    Continue reading…

Comments Off | Filed in ColdFusion, Oracle, Technology | Tags:


Web Development with Firefox

I came across a useful web page about using Firefox as a web development and testing tool. Firefox has some useful built-in tools like: Continue reading…

1 Comment | Filed in ColdFusion, Firefox, Tips | Tags: , ,