Skip navigation
Currently Being Moderated

SQLAssembler and Nulls

Jan 3, 2013 11:54 AM

Tags: #adobe #data #adobe_livecycle

I have a question about the correct use of a SQL Assembler destination.  It seems that the SQL Assembler does not handle NULLs when data is passed to it from the flex client.   If I have a value object with a NULL string attribute, SQL Assembler doesn't seem to recognize that the attribute exists.  When performing an update a "Missing IN or OUT parameter at index:: xxx" error appears in the log.  

 

If I change the code to make sure the string attribute in question has an empty string instead of a NULL before being passed to the server, the error goes away.

 

Is this by design?  What is the proper way to handle this?

 

thanks.

 
Replies

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points