skip to main
|
skip to sidebar
e2e | eLectrolytes 2 eLectrons
Web Development
Wednesday, June 15, 2011
SQL replace() blank stuff
Will never return 0
select replace('','',0)
Will return zero if the value is ''
select case when '' = '' then 0 else 1 end
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
About Me
Joe Banken
Minnesota, United States
ColdFusion Developer
View my complete profile
Tags
ColdFusion
(39)
ColdMVC
(12)
Design
(2)
Hover Technology
(2)
How To's
(34)
Java
(1)
Javascript
(6)
PHP
(2)
SQL
(12)
Theory
(10)
xml
(3)
Blog Archive
▼
2011
(17)
►
December
(3)
Full Calender JS - unique event id's
Full Calendar JS
Railo Annotations
►
July
(2)
cfsavecontent vs CSS when wanting to add styles.
Submit button name when posting form in JS
▼
June
(5)
Developer Phases
Hover Bike
Writing text over an image
SQL replace() blank stuff
SQL Selects ='s
►
April
(2)
HQL vs. SQL
ColdMVC: Quick start now available
►
March
(1)
ColdMVC: get an object's parents
►
February
(2)
ColdMVC: Number Tag
ColdMVC: Binding
►
January
(2)
Type Ahead Searches with jQuery
CF9 computed properties
►
2010
(28)
►
December
(5)
DSL's or Domain Specific Languages
Getting all the URL params in Javascript
Search Areas
MS SQL GUID lengths
ColdMVC: AJAX call
►
October
(1)
CF9 hibernate file includes.
►
August
(4)
ColdMVC: Plugging in fckeditor
ColdMVC: Deploying my first app.
Select Top N Rows Per Group
ColdMVC: Basic CMS app request handling
►
July
(4)
Declaring a variable with same name as a column in...
ColdMVC: Flatten an array of objects with children...
CF9 ormsetting dialect
ColdMVC: Parse checkboxes or radios generically
►
June
(1)
CSS hierarchy wish
►
May
(1)
From SQL to HQL
►
April
(3)
ColdMVC: Create your own Helpers.
Entity Name is same for two CFCs
Exploring ColdMVC
►
March
(6)
Just Do It : Programming to the Nike Approach.
Simplicity vs. DRY code
Small == Big
Indexed views, not using your indexes
StructSort() does not sort your keys
Tell the join how to join.
►
February
(3)
Developer's Inspiration
value-of-select inside an xslt tag's attribute
Playing with cfloop's file attribute
►
2009
(19)
►
December
(1)
listAppend()...Why?
►
November
(1)
Break it up
►
September
(4)
The cowering developer.
PHP and checkboxes with the same name
Adding a node to an existing xml object
►
August
(3)
►
June
(1)
►
May
(3)
►
April
(2)
►
March
(4)
ColdMVC Resources
ColdMVC Google Groups
Ryan Ricard
Tony Nelson
Subscribe to reader.
Posts
Atom
Posts
Comments
Atom
Comments
0 comments:
Post a Comment