Sorry about the slightly OT nature, but quick question on postgres -
I have a column that is of type bytea, is it actually possible to
insert a NULL value into it?
It is confgured to be nullable, but whenever I try and insert null
into the database using a <cfqueryparam>
like so:
<cfquery datasource="transfer_unit_postgres">
INSERT INTO tbl_BigStuff(bigstuff_clob,bigstuff_blob,bigstuffid)
VALUES
( <cfqueryparam null="true" cfsqltype="cf_sql_varchar"> ,
<cfqueryparam null="true" cfsqltype="cf_sql_blob"> ,
<cfqueryparam value="#createUUID()#" cfsqltype="cf_sql_varchar"> )
</cfquery>
I get the following error:
ERROR: column "bigstuff_blob" is of type bytea but expression is of type oid
However, if I write it like this:
<cfquery datasource="transfer_unit_postgres">
INSERT INTO tbl_BigStuff(bigstuff_clob,bigstuff_blob,bigstuffid)
VALUES
( <cfqueryparam null="true" cfsqltype="cf_sql_varchar"> ,
NULL ,
<cfqueryparam value="#createUUID()#" cfsqltype="cf_sql_varchar"> )
</cfquery>
Works just fine... so now I'm totally confused! :oD
Anyone got any help?
Mark
--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
