[ACFUG Discuss] Hopefully this list still exists

[Frank Moorman]

As the subject line states... hopefully this mail list still exists...

I came across something interesting today... (and very stressful before 
I figured it out...)


I migrated code from a CF10 server to a CF11 server. And I had a major 
bug because of it. It seems like the function of ListAppend changed.


The Migration docs mentioned how there were changes to the CFScript way 
of using list functions... but I did not see any mention of changes to 
the CFML tag functionality.


I had this code inside a loop:

ListAppend(UpdateString,arguments.DrawIds[loopix])>


But it turns out that where CF10 and before would append UpdateString 
with the additional value and store nonsense in devnull, CF11 changes 
the way it works. In the above function in now stores the combination in 
the devnull variable.


ListAppend(UpdateString,arguments.DrawIds[loopix])>


The above does work in CF11 also which seems to be how to change it to 
work on a minimal level.


Hope everyone is well if this maillist still gets out,
Enjoy all,

Frank Moorman

Re: [ACFUG Discuss] Hopefully this list still exists

[Ajas Mohammed]

Thanks for the email. I for one used to enjoy the challenges in this group
with people sending their issues.

I hope we can bring it back through this group emails or any other means as
long as we are actively getting requests.

Thanks,

On Wednesday, August 31, 2016, Frank Moorman 
wrote:

> As the subject line states... hopefully this mail list still exists...
>
> I came across something interesting today... (and very stressful before I
> figured it out...)
>
> I migrated code from a CF10 server to a CF11 server. And I had a major bug
> because of it. It seems like the function of ListAppend changed.
>
> The Migration docs mentioned how there were changes to the CFScript way of
> using list functions... but I did not see any mention of changes to the
> CFML tag functionality.
>
> I had this code inside a loop:
>
>  nts.DrawIds[loopix])>
>
> But it turns out that where CF10 and before would append UpdateString with
> the additional value and store nonsense in devnull, CF11 changes the way it
> works. In the above function in now stores the combination in the devnull
> variable.
>
>  nts.DrawIds[loopix])>
>
> The above does work in CF11 also which seems to be how to change it to
> work on a minimal level.
>
> Hope everyone is well if this maillist still gets out,
> Enjoy all,
>
> Frank Moorman
>
>

-- 

iUseDropbox(http://db.tt/63Lvone9)
http://ajashadi.blogspot.com
We cannot become what we need to be, remaining what we are.
No matter what, find a way. Because thats what winners do.
You can't improve what you don't measure.
Quality is never an accident; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.

Re: [ACFUG Discuss] Hopefully this list still exists

[Cameron Childress]

Folks are still on the list, though I am not sure the list management tool
are visible anymore.

The acfug.org domain actually just auto-renewed - so I think we are still
good as long as the list software is actually running

-Cameron

On Wed, Aug 31, 2016 at 5:23 PM, Ajas Mohammed  wrote:

> Thanks for the email. I for one used to enjoy the challenges in this group
> with people sending their issues.
>
> I hope we can bring it back through this group emails or any other means
> as long as we are actively getting requests.
>
> Thanks,
>
>
> On Wednesday, August 31, 2016, Frank Moorman 
> wrote:
>
>> As the subject line states... hopefully this mail list still exists...
>>
>> I came across something interesting today... (and very stressful before I
>> figured it out...)
>>
>> I migrated code from a CF10 server to a CF11 server. And I had a major
>> bug because of it. It seems like the function of ListAppend changed.
>>
>> The Migration docs mentioned how there were changes to the CFScript way
>> of using list functions... but I did not see any mention of changes to the
>> CFML tag functionality.
>>
>> I had this code inside a loop:
>>
>> > nts.DrawIds[loopix])>
>>
>> But it turns out that where CF10 and before would append UpdateString
>> with the additional value and store nonsense in devnull, CF11 changes the
>> way it works. In the above function in now stores the combination in the
>> devnull variable.
>>
>> > nts.DrawIds[loopix])>
>>
>> The above does work in CF11 also which seems to be how to change it to
>> work on a minimal level.
>>
>> Hope everyone is well if this maillist still gets out,
>> Enjoy all,
>>
>> Frank Moorman
>>
>>
>
> --
> 
> iUseDropbox(http://db.tt/63Lvone9)
> http://ajashadi.blogspot.com
> We cannot become what we need to be, remaining what we are.
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>


-- 
Cameron Childress
--
p:   678.637.5072
im: cameroncf
facebook  | twitter
 | google+

RE: [ACFUG Discuss] Hopefully this list still exists

[Charlie Arehart]

Dude, they’re getting the band back together! :-) 

So Frank, on your observation, can you offer a simple 2-3 line proofcase? I 
realize you gave us code, but not with the values you’re really using for the 
vars.

Sometimes, when you create such an example, you find out that it’s not what you 
thought. But if it is, then others could at least readily try it on their own 
systems, and if there’s no solution found, you could then include it in a bug 
report to Adobe.

I’ve not heard of this problem you report, so I’m inclined to think there may 
be another explanation. But let’s see. Hope that’s helpful.

/charlie

 

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress
Sent: Wednesday, August 31, 2016 05:03 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Hopefully this list still exists

 

Folks are still on the list, though I am not sure the list management tool are 
visible anymore.

 

The acfug.org domain actually just auto-renewed - so I think we are still good 
as long as the list software is actually running

 

-Cameron

 

On Wed, Aug 31, 2016 at 5:23 PM, Ajas Mohammed  wrote:

Thanks for the email. I for one used to enjoy the challenges in this group with 
people sending their issues. 

 

I hope we can bring it back through this group emails or any other means as 
long as we are actively getting requests.

 

Thanks,



On Wednesday, August 31, 2016, Frank Moorman  
wrote:

As the subject line states... hopefully this mail list still exists...

I came across something interesting today... (and very stressful before I 
figured it out...)

I migrated code from a CF10 server to a CF11 server. And I had a major bug 
because of it. It seems like the function of ListAppend changed.

The Migration docs mentioned how there were changes to the CFScript way of 
using list functions... but I did not see any mention of changes to the CFML 
tag functionality.

I had this code inside a loop:



But it turns out that where CF10 and before would append UpdateString with the 
additional value and store nonsense in devnull, CF11 changes the way it works. 
In the above function in now stores the combination in the devnull variable.



The above does work in CF11 also which seems to be how to change it to work on 
a minimal level.

Hope everyone is well if this maillist still gets out,
Enjoy all,

Frank Moorman



-- 
 

iUseDropbox(  http://db.tt/63Lvone9) 
http://ajashadi.blogspot.com
We cannot become what we need to be, remaining what we are.
No matter what, find a way. Because thats what winners do.
You can't improve what you don't measure.
Quality is never an accident; it is always the result of high intention, 
sincere effort, intelligent direction and skillful execution; it represents the 
wise choice of many alternatives.

 





 

-- 

Cameron Childress
--
p:   678.637.5072

im: cameroncf

facebook   | twitter 
  | google+ 
 

 

RE: [ACFUG Discuss] Hopefully this list still exists

[Troy Jones]

I’m glad to see this list still exists. I leaned on it heavily in my earlier 
career ☺

Thank you,

Troy Jones
Technical Manager
Third Wave Digital
1841 Hardeman Ave.
Macon, GA 31201
t...@thirdwavedigital.com
www.thirdwavedigital.com

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Charlie Arehart
Sent: Wednesday, August 31, 2016 6:17 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Hopefully this list still exists

Dude, they’re getting the band back together! :-)

So Frank, on your observation, can you offer a simple 2-3 line proofcase? I 
realize you gave us code, but not with the values you’re really using for the 
vars.

Sometimes, when you create such an example, you find out that it’s not what you 
thought. But if it is, then others could at least readily try it on their own 
systems, and if there’s no solution found, you could then include it in a bug 
report to Adobe.

I’ve not heard of this problem you report, so I’m inclined to think there may 
be another explanation. But let’s see. Hope that’s helpful.

/charlie

From: ad...@acfug.org [mailto:ad...@acfug.org] On 
Behalf Of Cameron Childress
Sent: Wednesday, August 31, 2016 05:03 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Hopefully this list still exists

Folks are still on the list, though I am not sure the list management tool are 
visible anymore.

The acfug.org domain actually just auto-renewed - so I think 
we are still good as long as the list software is actually running

-Cameron

On Wed, Aug 31, 2016 at 5:23 PM, Ajas Mohammed 
mailto:ajash...@gmail.com>> wrote:
Thanks for the email. I for one used to enjoy the challenges in this group with 
people sending their issues.

I hope we can bring it back through this group emails or any other means as 
long as we are actively getting requests.

Thanks,


On Wednesday, August 31, 2016, Frank Moorman 
mailto:stretch...@franksdomain.net>> wrote:
As the subject line states... hopefully this mail list still exists...

I came across something interesting today... (and very stressful before I 
figured it out...)

I migrated code from a CF10 server to a CF11 server. And I had a major bug 
because of it. It seems like the function of ListAppend changed.

The Migration docs mentioned how there were changes to the CFScript way of 
using list functions... but I did not see any mention of changes to the CFML 
tag functionality.

I had this code inside a loop:



But it turns out that where CF10 and before would append UpdateString with the 
additional value and store nonsense in devnull, CF11 changes the way it works. 
In the above function in now stores the combination in the devnull variable.



The above does work in CF11 also which seems to be how to change it to work on 
a minimal level.

Hope everyone is well if this maillist still gets out,
Enjoy all,

Frank Moorman


--

iUseDropbox(http://db.tt/63Lvone9)
http://ajashadi.blogspot.com
We cannot become what we need to be, remaining what we are.
No matter what, find a way. Because thats what winners do.
You can't improve what you don't measure.
Quality is never an accident; it is always the result of high intention, 
sincere effort, intelligent direction and skillful execution; it represents the 
wise choice of many alternatives.




--
Cameron Childress
--
p:   678.637.5072
im: cameroncf
facebook | 
twitter | 
google+


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2016.0.7752 / Virus Database: 4647/12850 - Release Date: 08/21/16
Internal Virus Database is out of date.

Re: [ACFUG Discuss] Hopefully this list still exists

[Ajas Mohammed]

Yeah, like Charlie mentioned few samples would be great.

Agree with Troy, I also learned so much just by keeping up with the group.
It's amazing how much you can learn by just reading others code.

If no one has objections , then we should start using the group again.

Thanks,

On Wednesday, August 31, 2016, Troy Jones  wrote:

> I’m glad to see this list still exists. I leaned on it heavily in my
> earlier career J
>
>
>
> Thank you,
>
>
>
> Troy Jones
>
> Technical Manager
>
> Third Wave Digital
>
> 1841 Hardeman Ave.
>
> Macon, GA 31201
>
> t...@thirdwavedigital.com
> 
>
> www.thirdwavedigital.com
>
>
>
> *From:* ad...@acfug.org 
> [mailto:ad...@acfug.org ]
> *On Behalf Of *Charlie Arehart
> *Sent:* Wednesday, August 31, 2016 6:17 PM
> *To:* discussion@acfug.org
> 
> *Subject:* RE: [ACFUG Discuss] Hopefully this list still exists
>
>
>
> Dude, they’re getting the band back together! :-)
>
> So Frank, on your observation, can you offer a simple 2-3 line proofcase?
> I realize you gave us code, but not with the values you’re really using for
> the vars.
>
> Sometimes, when you create such an example, you find out that it’s not
> what you thought. But if it is, then others could at least readily try it
> on their own systems, and if there’s no solution found, you could then
> include it in a bug report to Adobe.
>
> I’ve not heard of this problem you report, so I’m inclined to think there
> may be another explanation. But let’s see. Hope that’s helpful.
>
> /charlie
>
>
>
> *From:* ad...@acfug.org 
> [mailto:ad...@acfug.org ]
> *On Behalf Of *Cameron Childress
> *Sent:* Wednesday, August 31, 2016 05:03 PM
> *To:* discussion@acfug.org
> 
> *Subject:* Re: [ACFUG Discuss] Hopefully this list still exists
>
>
>
> Folks are still on the list, though I am not sure the list management tool
> are visible anymore.
>
>
>
> The acfug.org domain actually just auto-renewed - so I think we are still
> good as long as the list software is actually running
>
>
>
> -Cameron
>
>
>
> On Wed, Aug 31, 2016 at 5:23 PM, Ajas Mohammed  > wrote:
>
> Thanks for the email. I for one used to enjoy the challenges in this group
> with people sending their issues.
>
>
>
> I hope we can bring it back through this group emails or any other means
> as long as we are actively getting requests.
>
>
>
> Thanks,
>
>
>
> On Wednesday, August 31, 2016, Frank Moorman  > wrote:
>
> As the subject line states... hopefully this mail list still exists...
>
> I came across something interesting today... (and very stressful before I
> figured it out...)
>
> I migrated code from a CF10 server to a CF11 server. And I had a major bug
> because of it. It seems like the function of ListAppend changed.
>
> The Migration docs mentioned how there were changes to the CFScript way of
> using list functions... but I did not see any mention of changes to the
> CFML tag functionality.
>
> I had this code inside a loop:
>
>  arguments.DrawIds[loopix])>
>
> But it turns out that where CF10 and before would append UpdateString with
> the additional value and store nonsense in devnull, CF11 changes the way it
> works. In the above function in now stores the combination in the devnull
> variable.
>
>  arguments.DrawIds[loopix])>
>
> The above does work in CF11 also which seems to be how to change it to
> work on a minimal level.
>
> Hope everyone is well if this maillist still gets out,
> Enjoy all,
>
> Frank Moorman
>
>
>
> --
> 
>
> iUseDropbox(http://db.tt/63Lvone9)
> http://ajashadi.blogspot.com
> We cannot become what we need to be, remaining what we are.
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
>
>
>
>
>
> --
>
> Cameron Childress
> --
> p:   678.637.5072
>
> im: cameroncf
>
> facebook  | twitter
>  | google+
> 
>
>
> --
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7752 / Virus Database: 4647/12850 - Release Date: 08/21/16
> Internal Virus Database is out of date.
>


-- 

iUseDropbox(http://db.tt/63Lvone9)
http://ajashadi.blogspot.com
We cannot become what we need to be, remaining what we are.
No matter what, find a way. Because thats what winners do.
You can't improve what you don't measure.
Quality is never an accident; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.

Re: [ACFUG Discuss] Hopefully this list still exists

[Arun Nallan]

Yes it helped me in the past though I always read it I usually don't
respond... When I try to attend the newer group tech lunches...I usually
miss them a lot due to my work schedule...

Now I'm totally away from CF though eager to know what's happening around..
currently in Oracle e-commerce, Java, j2ee after switching to Flex from CF
in an intermediate project during the down time

Frank may have found a bug and a workaround too! Nice to see all the
messages

On Aug 31, 2016 8:16 PM, "Ajas Mohammed"  wrote:

> Yeah, like Charlie mentioned few samples would be great.
>
> Agree with Troy, I also learned so much just by keeping up with the group.
> It's amazing how much you can learn by just reading others code.
>
> If no one has objections , then we should start using the group again.
>
> Thanks,
>
> On Wednesday, August 31, 2016, Troy Jones 
> wrote:
>
>> I’m glad to see this list still exists. I leaned on it heavily in my
>> earlier career J
>>
>>
>>
>> Thank you,
>>
>>
>>
>> Troy Jones
>>
>> Technical Manager
>>
>> Third Wave Digital
>>
>> 1841 Hardeman Ave.
>>
>> Macon, GA 31201
>>
>> t...@thirdwavedigital.com
>>
>> www.thirdwavedigital.com
>>
>>
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Charlie
>> Arehart
>> *Sent:* Wednesday, August 31, 2016 6:17 PM
>> *To:* discussion@acfug.org
>> *Subject:* RE: [ACFUG Discuss] Hopefully this list still exists
>>
>>
>>
>> Dude, they’re getting the band back together! :-)
>>
>> So Frank, on your observation, can you offer a simple 2-3 line proofcase?
>> I realize you gave us code, but not with the values you’re really using for
>> the vars.
>>
>> Sometimes, when you create such an example, you find out that it’s not
>> what you thought. But if it is, then others could at least readily try it
>> on their own systems, and if there’s no solution found, you could then
>> include it in a bug report to Adobe.
>>
>> I’ve not heard of this problem you report, so I’m inclined to think there
>> may be another explanation. But let’s see. Hope that’s helpful.
>>
>> /charlie
>>
>>
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Cameron
>> Childress
>> *Sent:* Wednesday, August 31, 2016 05:03 PM
>> *To:* discussion@acfug.org
>> *Subject:* Re: [ACFUG Discuss] Hopefully this list still exists
>>
>>
>>
>> Folks are still on the list, though I am not sure the list management
>> tool are visible anymore.
>>
>>
>>
>> The acfug.org domain actually just auto-renewed - so I think we are
>> still good as long as the list software is actually running
>>
>>
>>
>> -Cameron
>>
>>
>>
>> On Wed, Aug 31, 2016 at 5:23 PM, Ajas Mohammed 
>> wrote:
>>
>> Thanks for the email. I for one used to enjoy the challenges in this
>> group with people sending their issues.
>>
>>
>>
>> I hope we can bring it back through this group emails or any other means
>> as long as we are actively getting requests.
>>
>>
>>
>> Thanks,
>>
>>
>>
>> On Wednesday, August 31, 2016, Frank Moorman 
>> wrote:
>>
>> As the subject line states... hopefully this mail list still exists...
>>
>> I came across something interesting today... (and very stressful before I
>> figured it out...)
>>
>> I migrated code from a CF10 server to a CF11 server. And I had a major
>> bug because of it. It seems like the function of ListAppend changed.
>>
>> The Migration docs mentioned how there were changes to the CFScript way
>> of using list functions... but I did not see any mention of changes to the
>> CFML tag functionality.
>>
>> I had this code inside a loop:
>>
>> > nts.DrawIds[loopix])>
>>
>> But it turns out that where CF10 and before would append UpdateString
>> with the additional value and store nonsense in devnull, CF11 changes the
>> way it works. In the above function in now stores the combination in the
>> devnull variable.
>>
>> > nts.DrawIds[loopix])>
>>
>> The above does work in CF11 also which seems to be how to change it to
>> work on a minimal level.
>>
>> Hope everyone is well if this maillist still gets out,
>> Enjoy all,
>>
>> Frank Moorman
>>
>>
>>
>> --
>> 
>>
>> iUseDropbox(http://db.tt/63Lvone9)
>> http://ajashadi.blogspot.com
>> We cannot become what we need to be, remaining what we are.
>> No matter what, find a way. Because thats what winners do.
>> You can't improve what you don't measure.
>> Quality is never an accident; it is always the result of high intention,
>> sincere effort, intelligent direction and skillful execution; it represents
>> the wise choice of many alternatives.
>>
>>
>>
>>
>>
>>
>>
>> --
>>
>> Cameron Childress
>> --
>> p:   678.637.5072
>>
>> im: cameroncf
>>
>> facebook  | twitter
>>  | google+
>> 
>>
>>
>> --
>>
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2016.0.7752 / Virus Database: 4647/12850 - Release Date: 08/21/16
>> Internal Virus Databas

Re: [ACFUG Discuss] Hopefully this list still exists

[Frank Moorman]

Charlie,

Here is the actual code (though the SQL is a little slimmed down for 
clarity.)






UPDATE tbl_inspection_form_draws
   SET last_user= cfsqltype="CF_SQL_SMALLINT" value="#session.UserID#">,
   draw_note= cfsqltype="CF_SQL_VARCHAR" value="#arguments.DrawNotes[loopix]#" 
maxlength="200">,
   completion_percent   = cfsqltype="CF_SQL_TINYINT" value="#Val(arguments.CompPercent[loopix])#">,
   prior_completion_percent = cfsqltype="CF_SQL_TINYINT" 
value="#Val(arguments.OrigCompPercent[loopix])#">,
   last_inspection_date = cfsqltype="CF_SQL_TIMESTAMP" value="#InspectionDateTime#">,
   last_update  = cfsqltype="CF_SQL_TIMESTAMP" value="#CurrentDateTime#">
 WHERE draw_id = value="#arguments.DrawIds[loopix]#">;





UPDATE tbl_inspection_form_draws
   SET prior_completion_percent = cfsqltype="CF_SQL_TINYINT"   value="100">,
   status   = cfsqltype="CF_SQL_CHAR"  value="C" maxlength="1">,
   last_update  = cfsqltype="CF_SQL_TIMESTAMP" value="#CurrentDateTime#">
 WHERE inspection_form_id   = cfsqltype="CF_SQL_INTEGER" value="#arguments.FormID#">

   AND draw_id  NOT IN (#UpdateString#)


As you can tell The ListAppend is right in the middle. Essentially I am 
updating an inspection form. Arrays with the values of every line item 
changed are passed into this function. The list is used to create a 
comma separated value of every line item id that was updated. The value 
is then used in the second query to make changes to every line item not 
updated within the specified inspection form.


After the code was moved to the new CF11 server (from a CF10 server) We 
noticed that the prior completion percent was set to 100 in every case 
(and tracked it down to the 2nd query here.) According to the svn log, 
the component containing this code has not changed since 6/27/2014. (and 
I know this particular section was not changed in a longer period of time.)


In tracking down the error and determining exactly what happened I 
basically added a result attribute to the queries and dumped them to 
verify that the proper values where being initially set and added a 
bunch of dumps for the other variables.. I also added a SELECT statement 
to verify that there was not some weird database connector problem on 
the new server.


result="">







SELECT * from tbl_inspection_form_draws
WHERE draw_id = value="#arguments.DrawIds[loopix]#">;

 



The dumps came back and pointed the finger at the ListAppend statement. 
UpdateString was not changing and staying with the initial value of 0. 
The devnull variable was being changed constantly to 0 & the value of 
the current draw. (It was changing to 0 and the current draw id with 
each iteration, it was not expanding draws due to the way it was written.


In addition I had added a result attribute to the second query as well 
as another SELECT * and DUMP. It also confirmed that the #UpdateString# 
was only passing a single value of 0 to the SQL. Which essentially 
caused all rows to update instead of just the rows that were not changed 
by the first SQL.


I left the cfdumps in the code and changed the line to:

ListAppend(UpdateString,arguments.DrawIds[loopix])>


At this point UpdateString was expanding with each iteration of the loop 
appending the new draw id. The way it was functioning on the old server 
with CF10.



On 08/31/2016 06:16 PM, Charlie Arehart wrote:


Dude, they’re getting the band back together! :-)

So Frank, on your observation, can you offer a simple 2-3 line 
proofcase? I realize you gave us code, but not with the values you’re 
really using for the vars.


Sometimes, when you create such an example, you find out that it’s not 
what you thought. But if it is, then others could at least readily try 
it on their own systems, and if there’s no solution found, you could 
then include it in a bug report to Adobe.


I’ve not heard of this problem you report, so I’m inclined to think 
there may be another explanation. But let’s see. Hope that’s helpful.


/charlie

*From:*ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Cameron 
Childress

*Sent:* Wednesday, August 31, 2016 05:03 PM
*To:* discussion@acfug.org
*Subject:* Re: [ACFUG Discuss] Hopefully this list still exists

Folks are still on the list, though I am not sure the list management 
tool are visible anymore.


The acfug.org  domain actually just auto-renewed - 
so I think we are still good as long as the list software is actually 
running


-Cameron

On Wed, Aug 31, 2016 at 5:23 PM, Ajas Mohammed > wrote:


Thanks for the email. I for one used to enjoy the challenges in this 
group with people sending their issues.


I hope we can bring it back through this group emails or any othe

Re: [ACFUG Discuss] Hopefully this list still exists

[Kevin Hellriegel]

Frank, looking back at CF9, you had to set your variable to the
listappend(). Perhaps in CF10 they changed the functionality or was an
unintentional "feature"? Here's a link to the CF9 doc

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6d71.html

Slightly unrelated, is anyone running CF 2016 / version 12? I'm hoping to
upgrade our site from CF 8 in Q4. Just curious if anyone has run into any
quirks?

Glad to see the list is still alive and kicking!

Kevin

On Wed, Aug 31, 2016 at 8:45 PM, Frank Moorman 
wrote:

> Charlie,
>
> Here is the actual code (though the SQL is a little slimmed down for
> clarity.)
>
> 
> 
> 
> 
> UPDATE tbl_inspection_form_draws
>SET last_user=  cfsqltype="CF_SQL_SMALLINT" value="#session.UserID#">,
>draw_note=  cfsqltype="CF_SQL_VARCHAR" value="#arguments.DrawNotes[loopix]#"
> maxlength="200">,
>completion_percent   =  cfsqltype="CF_SQL_TINYINT" value="#Val(arguments.CompPercent[loopix])#">,
>prior_completion_percent =  cfsqltype="CF_SQL_TINYINT" value="#Val(arguments.
> OrigCompPercent[loopix])#">,
>last_inspection_date =  cfsqltype="CF_SQL_TIMESTAMP" value="#InspectionDateTime#">,
>last_update  =  cfsqltype="CF_SQL_TIMESTAMP" value="#CurrentDateTime#">
>  WHERE draw_id =  value="#arguments.DrawIds[loopix]#">;
> 
> 
> 
> 
> UPDATE tbl_inspection_form_draws
>SET prior_completion_percent =  cfsqltype="CF_SQL_TINYINT"   value="100">,
>status   =  cfsqltype="CF_SQL_CHAR"  value="C" maxlength="1">,
>last_update  =  cfsqltype="CF_SQL_TIMESTAMP" value="#CurrentDateTime#">
>  WHERE inspection_form_id   =  cfsqltype="CF_SQL_INTEGER" value="#arguments.FormID#">
>AND draw_id  NOT IN (#UpdateString#)
>
> 
>
> As you can tell The ListAppend is right in the middle. Essentially I am
> updating an inspection form. Arrays with the values of every line item
> changed are passed into this function. The list is used to create a comma
> separated value of every line item id that was updated. The value is then
> used in the second query to make changes to every line item not updated
> within the specified inspection form.
>
> After the code was moved to the new CF11 server (from a CF10 server) We
> noticed that the prior completion percent was set to 100 in every case (and
> tracked it down to the 2nd query here.) According to the svn log, the
> component containing this code has not changed since 6/27/2014. (and I know
> this particular section was not changed in a longer period of time.)
>
> In tracking down the error and determining exactly what happened I
> basically added a result attribute to the queries and dumped them to verify
> that the proper values where being initially set and added a bunch of dumps
> for the other variables.. I also added a SELECT statement to verify that
> there was not some weird database connector problem on the new server.
>
>  result="">
> 
> 
>
> 
> 
> 
> SELECT * from tbl_inspection_form_draws
> WHERE draw_id =  value="#arguments.DrawIds[loopix]#">;
>  
> 
>
>
> The dumps came back and pointed the finger at the ListAppend statement.
> UpdateString was not changing and staying with the initial value of 0. The
> devnull variable was being changed constantly to 0 & the value of the
> current draw. (It was changing to 0 and the current draw id with each
> iteration, it was not expanding draws due to the way it was written.
>
> In addition I had added a result attribute to the second query as well as
> another SELECT * and DUMP. It also confirmed that the #UpdateString# was
> only passing a single value of 0 to the SQL. Which essentially caused all
> rows to update instead of just the rows that were not changed by the first
> SQL.
>
> I left the cfdumps in the code and changed the line to:
>
>  arguments.DrawIds[loopix])>
>
> At this point UpdateString was expanding with each iteration of the loop
> appending the new draw id. The way it was functioning on the old server
> with CF10.
>
>
>
> On 08/31/2016 06:16 PM, Charlie Arehart wrote:
>
> Dude, they’re getting the band back together! :-)
>
> So Frank, on your observation, can you offer a simple 2-3 line proofcase?
> I realize you gave us code, but not with the values you’re really using for
> the vars.
>
> Sometimes, when you create such an example, you find out that it’s not
> what you thought. But if it is, then others could at least readily try it
> on their own systems, and if there’s no solution found, you could then
> include it in a bug report to Adobe.
>
> I’ve not heard of this problem you report, so I’m inclined to think there
> may be another explanation. But let’s see. Hope that’s helpful.
>
> /charlie
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org ] *O

RE: [ACFUG Discuss] Hopefully this list still exists

[Troy Jones]

We’ve got one production environment running it right now. All others are CF10. 
The only thing that threw me was the removal of the need for the CFIDE folder. 
Took me a minute and I found Charlie’s blog on it.

Other than that, it’s functionally no different for us although we don’t make 
use of most of the more off-the-beaten-path features.

Thank you,

Troy Jones
Technical Manager
Third Wave Digital
1841 Hardeman Ave.
Macon, GA 31201
t...@thirdwavedigital.com
www.thirdwavedigital.com

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Kevin Hellriegel
Sent: Wednesday, August 31, 2016 9:02 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Hopefully this list still exists

Frank, looking back at CF9, you had to set your variable to the listappend(). 
Perhaps in CF10 they changed the functionality or was an unintentional 
"feature"? Here's a link to the CF9 doc

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6d71.html

Slightly unrelated, is anyone running CF 2016 / version 12? I'm hoping to 
upgrade our site from CF 8 in Q4. Just curious if anyone has run into any 
quirks?

Glad to see the list is still alive and kicking!

Kevin

On Wed, Aug 31, 2016 at 8:45 PM, Frank Moorman 
mailto:stretch...@franksdomain.net>> wrote:
Charlie,

Here is the actual code (though the SQL is a little slimmed down for clarity.)





UPDATE tbl_inspection_form_draws
   SET last_user= ,
   draw_note= ,
   completion_percent   = ,
   prior_completion_percent = ,
   last_inspection_date = ,
   last_update  = 
 WHERE draw_id = ;




UPDATE tbl_inspection_form_draws
   SET prior_completion_percent = ,
   status   = ,
   last_update  = 
 WHERE inspection_form_id   = 
   AND draw_id  NOT IN (#UpdateString#)


As you can tell The ListAppend is right in the middle. Essentially I am 
updating an inspection form. Arrays with the values of every line item changed 
are passed into this function. The list is used to create a comma separated 
value of every line item id that was updated. The value is then used in the 
second query to make changes to every line item not updated within the 
specified inspection form.

After the code was moved to the new CF11 server (from a CF10 server) We noticed 
that the prior completion percent was set to 100 in every case (and tracked it 
down to the 2nd query here.) According to the svn log, the component containing 
this code has not changed since 6/27/2014. (and I know this particular section 
was not changed in a longer period of time.)

In tracking down the error and determining exactly what happened I basically 
added a result attribute to the queries and dumped them to verify that the 
proper values where being initially set and added a bunch of dumps for the 
other variables.. I also added a SELECT statement to verify that there was not 
some weird database connector problem on the new server.








SELECT * from tbl_inspection_form_draws
WHERE draw_id = ;
 



The dumps came back and pointed the finger at the ListAppend statement. 
UpdateString was not changing and staying with the initial value of 0. The 
devnull variable was being changed constantly to 0 & the value of the current 
draw. (It was changing to 0 and the current draw id with each iteration, it was 
not expanding draws due to the way it was written.

In addition I had added a result attribute to the second query as well as 
another SELECT * and DUMP. It also confirmed that the #UpdateString# was only 
passing a single value of 0 to the SQL. Which essentially caused all rows to 
update instead of just the rows that were not changed by the first SQL.

I left the cfdumps in the code and changed the line to:



At this point UpdateString was expanding with each iteration of the loop 
appending the new draw id. The way it was functioning on the old server with 
CF10.


On 08/31/2016 06:16 PM, Charlie Arehart wrote:
Dude, they’re getting the band back together! :-)

So Frank, on your observation, can you offer a simple 2-3 line proofcase? I 
realize you gave us code, but not with the values you’re really using for the 
vars.

Sometimes, when you create such an example, you find out that it’s not what you 
thought. But if it is, then others could at least readily try it on their own 
systems, and if there’s no solution found, you could then include it in a bug 
report to Adobe.

I’ve not heard of this problem you report, so I’m inclined to think there may 
be another explanation. But let’s see. Hope that’s helpful.

/charlie

From: ad...@acfug.org [mailto:ad...@acfug.org] On 
Behalf Of Cameron Childress
Sent: Wednesday, August 31, 2016