Convert to an array like this:
<cfset MyArray = MyList.split('|')/>
Then insert a null like this:
<cfqueryparam value="#MyArray[i]#" null="#NOT Len(MyArray[i])#"
cfsqltype="CF_SQL_VARHCHAR"/>
> HI
> I have this pipe delimited list
> suppose A||C
> Now the middle one is blank. How can i store this list so that i can
> track the middle one as blank and later when i update the DB i can
> update this null as something else in DB?
>
> ARray i guess wont work because they will consider this as 2 elements
> only rather than 3
>
> How i can approach this.
>
> Thanks
DG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
