Another 6 Oracle goodies

Written on 25 July 2011, 12:16pm

Tagged with: ,

Continuing the Oracle Cheat Sheet 🙂

1. Create an Oracle user


create user xxx identified by yyy;
grant connect, resource, unlimited tablespace to xxx [identified by yyy];
grant create session to xxx;

2. Extend tablespace


ALTER DATABASE
DATAFILE  'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF'
RESIZE 1000M;

link

3. Invoking UNIX commands from SQL*Plus

You can invoke a UNIX command from SQL*Plus by using “HOST COMMAND”:

host ls -la *.sql 

lists all SQL files in the current directory
(more…)

CF 8 bug: ColdFusion injecting cfscript in HTML head

Written on 20 July 2011, 02:13pm

Tagged with: , ,

I recently encountered the following ColdFusion problem:
I had a HTML page where the head node contained an attribute: <head lang="fr">
The same page was also using some cfform tags.
On the CF 8 server, ColdFusion automatically injects two <script> statements immediately after <head, but ignoring any other attribute. So, in our case, the resulting HTML code was:

<head <script type="text/javascript" src="/CFIDE/scripts/cfform.js"></script>
<script type="text/javascript" src="/CFIDE/scripts/masks.js"></script>
lang="fr">

Useless to say, this was breaking a lot of things in the design and the validation of the page.
(more…)

Garmin 3760 – quick review

Written on 22 June 2011, 04:18pm

Tagged with: , ,

I know that this blog is mainly about web development, but when I get new devices, I feel like I have to share. Must be the smell of the fresh hardware 🙂
I recently bought a Garmin 3760 sat nav system from amazon.co.uk.
With less than 9mm thick, the 3760 is the Thinnest Navigator in the World.
garmin 3760

Indeed, the size of the navigator is the first things that you will notice when opening the box.

Some drawbacks

  • When the device is in stand by (screen turned off) you don’t know how to hold it. On the iPhone, you have the home button on the bottom. On Garmin 3760, the power button (in fact, the only physical button) is placed on the bottom right sidebar. Not the best place to put it, if you ask me, as you will need two hands to switch it on and off.
  • Screen orientation: it advertises dual orientation (landscape and portrait). But it’s not similar to the one on the iPhones: you have only one position for the portrait and one for the landscape (to compare, the iPhones have two positions for portrait-mode and two for landscape mode). Not a big issue, just something to be noted
  • The touch screen is a little too sensitive sometimes (compared to the iPhone)
  • When connected to computer via USB, you cannot use the device
  • The picture viewer is quite slow. But it’s not like someone would buy the device for the picture viewer 🙂

And the good points

(more…)