This content has been marked as final. Show 6 replies
do you have any control over the WSDL method itself? if so, that'd be a better place to look at converting an empty string to a NULL value on the insert (assuming it's doing a SQL insert).
or maybe something like this:
Thanks for the reply. I'm at a stand still at the moment. I'm still learning WSDL while doing this project. I'm not doing any database query or store at this point. I don't have control over the wsdl method. It's from a thrid party vendor. Here's the WSDL link not sure if you can see anything I could possible leave out. I've googled for how to set a variable to null and it looks like you can not do it in coldfusion MX. Is that true?
Here's the wsdl link http://voyager3.expedata.net/ExpeData_DAWS/DAWS.asmx?WSDL
the link to pete freitag's site in my previous post suggests some workarounds for setting/sending NULL values.
Yeah I did look at the example and tried to do something similar, but it did not work. I also tried to do it where I created my datastructure from a sql query of null values. Seems to working fine, but when tryingto connect to the api from the wsdl it fails. I think there's is no way around this problem as the connect portion is rejecting.
if you did your query in CF, it will convert the null values to empty strings.
pete's blog entry explains how to preserve the null. if pete's entry didn't do it, google for ColdFusion null. there has to be some way to javacast() the null to a true null.
Will Do. I've been googling for it the past few days and came up short. I've posted this on a few forums and hopefully someone know how.