Thanks Peter
> "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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272140
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
