"VARHCHAR" - I have no idea how I wrote that. :'(
Just to note that the cfqueryparam would of course be on the value side of an
appropriate insert/update SQL statement within a cfquery, etc.
> 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272139
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
