[thelist] Difference between CF 5 and CF MX?

Phillip M. Vector phillipmvector at comcast.net
Thu Apr 8 09:22:40 CDT 2004

This code is supposto take each characters id and count how many resource
levels are stored on the table (I wanted to put a number quanity there, but
the processing was making my brain hurt).

Then it applies it to a formula and adds money to their account every day.

I have CFMX installed on my machine here and the following works great.

My server I actually run the page from keeps giving everyone the same amount
(It looks like the level of the last character checked).

So ... What do I need to change to get it to work with CF5?


<cfquery datasource="A6261_main_test" name="Richpeople"> select DISTINCT
Character_ID from Table_Backgrounds where Name = 'Resources'

<cfloop Query="richpeople">

<cfquery datasource="A6261_main_test" name="resources"> select Character_ID
from Table_Backgrounds where Name = 'Resources' AND

<cfset total = (((((#resources.recordcount# *
500)-498+(#randrange(0,6)#)-3)) *#days#)+ #character.moneyinbank#)>

<cfquery datasource="A6261_main_test">
update Table_Character
SET Moneyinbank = #total#, Last_Updated = #createodbcdate(now())# Where


More information about the thelist mailing list