Quantcast

Monthly Archives: February 2006

Smooth scrolling image list

By carson | Published: February 16, 2006
I had someone ask me about fitting more images in a small area and the way flickr does their image scrolling came to mind. I wanted to see how hard it was to do and as it turns out it isn't hard to do at all thanks to script.aculo.us. I'm making this as simple as I [...]
Posted in programming | Tagged | 33 Comments

No javascript detection

By carson | Published: February 15, 2006
Have you ever wondered what you can do if someone doesn't have javascript turned on and it is needed on the page they are sitting at? Well here is the answer: <html>   <head>     <noscript><meta http-equiv="refresh" content="0; URL=nojscript.html"/></noscript>   </head>   <body>     A javascript test.   </body> </html> If the user doesn't have javascript turned on they will be redirected [...]
Posted in web design | Tagged | 2 Comments

Fun with Oracle Strings

By carson | Published: February 14, 2006
Today I needed to find a way to count the number of unique email domains in a table. I figured there was a way of getting the index of a string in another string and sure enough there is. This did the trick in Oracle: SELECT count(1), SUBSTR(email, INSTR(email, '@', 1, 1)+1) FROM SOMETABLE GROUP BY [...]
Posted in database administration | Tagged | Leave a comment

JDBC + Batch updates + Non-Standard == Oracle

By carson | Published: February 11, 2006
I recently ran into an issue where doing a large number of inserts and updates in an Oracle 8i database was taking forever. I was already using a prepared statement and commiting only after a certain number of rows. After some digging I found out that there is a special Oracle way of doing batch [...]
Posted in java | Leave a comment