Amazon Price mistake

This was just funny, while researching ice cream and yogurt makers, I came across an entry for a Salton YM9 1-Quart Yogurt Maker which typically cost up to $30 (yogurt makers in general) but I found one on Amazon for: $100,000.00

Not sure if the link will work for long (until it's fixed?)



Too Funny!

I <3 Oracle

Lies!!

For my own future reference, to get the last inserted ID (being created by the trigger from a sequence because auto increment is non existant) simply do this:

SELECT schema.sequence_name.currval as the_id FROM dual

Yep.. simple eh? I couldn't find that anyplace online, so I'll try and include some descriptive keywords I searched for like last inserted ID, auto_increment, last_number, OK I think that's enough.

Tschüss!

Why would an upgrade change all the settings?

A couple months ago, we decided that on a single machine, outside our regular development/staging/production environment to setup upgrade to PHP5, so I could test all teh sites, fix any problems, before we go ahead and upgrade all the machines.

I've been so busy since then, only yesterday did I get a chance to glance at the upgraded server. Turns out.. they installed PHP5, and went ahead and disabled mysql, oracle, pear, gd and well.. everything else.

How would I ever possibly be able to use this as a web server running data driven sites?? When I say "upgrade" I usually mean "Just like it is, except the newer version".

I've sent off the email to ask them to actually configure it in the same way as all the other servers, lets see how long this takes before I crack and do it myself.

Live Search - auto complete off!

Just for fun, I decided to write a live search version of the main movie DB.

It was much quicker/easier than I thought.. since it's basically just ajax!

I call the ajax->php bit "onkeyup".

Do the DB query, and write it to a list which appears in a div under the form field.

I think it should be harder!!!

Oh and.. autocomplete="off" in the form tag turns off the browser autocomplete.

I'll post snippets another time, although it's pretty darn obvious eh?