insert null in to unique identifier

stewart_smith1 wrote:
> <cfset VARIABLES.QRYTEST = Application.dbbatchUpdate.test(variables.bupd.dsnC, '')>
> i keep getting the error "element test passed to function is not of type guid".

Because an empty string '' is not a valid guid.


> also tried changing the argument type to any, and the cf_sql_type to be a char but still no luck .

That would work for CF. But assuming your column type is uniqueidentifier, MS SQL would throw an error because an empty string '' is not a valid uniqueidentifier


> <cfargument name="test" type="guid" required="no" />
> <cfqueryparam cfsqltype="cf_sql_idstamp" value="#arguments.test#">

That will cause an error if nothing was passed in for arguments.test


> i am trying to insert a null value in to a sql server database

I'm assuming "itemID" is not your table's primary key since you're trying to set the value to NULL. If it were the PK, that would be troubling ... ;-)

Anyway, you need to read up on cfqueryparam's "null" attribute. If null="true" or null= "yes" a NULL value will be passed to the database. If you want really want to pass a empty string "" to your function, you could skip the type checking and use type="any". Then use "null" in your cfqueryparam

<cfargument name="test" type="any" required="no" default="" />
...
<cfqueryparam cfsqltype="cf_sql_idstamp" value="#arguments.test#" null="#not len(trim(arguments.test))#">

Or you could keep the type checking and make the argument optional. Then inside the function, set a default value if the UUID was not passed.