any errors reported in application.log?
| [EMAIL PROTECTED] (Terry Riley)
23/04/2004 10:58
|
To: [EMAIL PROTECTED] cc: Subject: [ cf-dev ] ValueList problem? |
In one of our apps (CF5), we send out a bulk email (well, about 8000 max)
once in a while to encourage subscribers (job seekers) to either update
their subscription preferences or remove themselves from the mailing list.
At some future point, we check who has bothered to update, and if they
haven't within a certain period, we assume non-interest (or even
non-delivery of the email) and delete them automagically using a batch
program.
Part of the original mailing code is to create a valuelist of IDs for
those requiring to be mailed, which, after CFMAIL has done its bit, is
used to update a datetime field (SQL2K) with the day's date (see below).
On our development server (XP) it works as advertised, even with a
valuelist containing 8000+ 4-digit IDs. However, on the live server (NT),
this part of the code does not appear to have executed, although the 8000
emails have been sent.
Is there a limit to the size of a ValueList()? If not, anyone have any
possible explanation as to why this doesn't work?
<!--- initial query --->
<cfset user_update_list = #ValueList(get_users.UID)#>
<!--- cfmail stuff --->
<cfquery name="foo_update" datasource="#request.DSN#">
UPDATE userlist
SET update_request = #CreateODBCDate(Now())#
WHERE UID IN (#user_update_list#)
</cfquery>
Cheers
Terry Riley
--
These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
