Use this function. You are trying to directly update the rows of a query.
*QuerySetCell*(*query*, *column_name*, *value* [, *row_number *])
Wes
On 5/16/07, Ian Skinner <[EMAIL PROTECTED]> wrote:
>
> Can anybody see an issue with the following CFScript? I have confirmed
> that the if clauses turn true at the appropriate times, but for some
> reason the strings are not being modified when they are.
>
>
>
> <cfoutput query="Shipped">
>
> <cfscript>
>
> line = "";//init
>
> if (left(UnitNo,5) EQ "W0358")
>
> {
>
> UnitNo = "=" & UnitNo & "00";
>
> }
>
> line = line & UnitNo & ", ";//BloodID
>
>
>
> if (left(Component,1) EQ "E")
>
> {
>
> Component = "=<" & Component & "00";
>
> }
>
> else
>
> {
>
> Component = "0" & Component;
>
> }
>
> line = line & Component & ", ";//ProductCode
>
> ....
>
> </cfscript>
>
> </cfoutput>
>
>
> Confidentiality Notice: This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278341
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
