7 comments

Add a comment…

Sign in

prestine

Your email address

Check!

invalid email

(thinking…)

Reset

or sign in with

• 
• 

UserVoice password

Forgot password?

Create a password

Your name

I agree to the terms of service

You'll receive a confirmation email with a link to create a password (optional).

Signed in as (Sign out)

Close

Close

Post comment Submitting...

• AdminSean Corfield (Admin, Railo Technologies) commented  ·  December 10, 2009 11:21  ·  Flag as inappropriate  ·  Delete

  I agree with Adrian that this is too tied to your application's data and is not an appropriate feature for the language or for Railo (and if we add it, code that uses it won't run on other CFML engines!). I'll leave this suggestion open for a while longer but my inclination is to decline it.

• Randy Merrill commented  ·  December 10, 2009 06:42  ·  Flag as inappropriate  ·  Delete

  A zero length string... is a zero length string, not a null.

• zac.spitzer commented  ·  December 10, 2009 03:49  ·  Flag as inappropriate  ·  Delete

  really simple oracle style, a zero length string is null

• Adrian Lynch commented  ·  August 01, 2009 02:55  ·  Flag as inappropriate  ·  Delete

  Exactly. Unless I'm completely missing something here, auto doen't seem like it would be anything special. Leave it to us to decide when to pass a NULL.

• Randy Merrill commented  ·  July 31, 2009 06:12  ·  Flag as inappropriate  ·  Delete

  Couldn't you also do: <cfqueryparam value="#arguments.ServiceName#" cfsqltype="cf_sql_varchar" null="#len(arguments.ServiceName)#"> or <cfqueryparam value="#arguments.ServiceName#" cfsqltype="cf_sql_varchar" null="#len(arguments.ServiceName) EQ 0#">

• Adrian Lynch commented  ·  July 31, 2009 05:50  ·  Flag as inappropriate  ·  Delete

  But what would cause NULL to be used? An empty string for character types? A zero for numeric types? This is too tied into your application's data, null="yes|no" is the way to go for this I feel.

• Sundvor commented  ·  July 31, 2009 01:13  ·  Flag as inappropriate  ·  Delete

  I fully support this idea as the IIF statements are adding a lot of noise to my code. E.g.
  ServiceName = <cfqueryparam value="#arguments.ServiceName#" cfsqltype="cf_sql_varchar" null="#iif(len(arguments.ServiceName),de('NO'),de('YES'))#">
  should really just have to be :
  ServiceName = <cfqueryparam value="#arguments.ServiceName#" cfsqltype="cf_sql_varchar" null="auto">