[ cf-dev ] ValueList problem?

2004-04-23 Thread Terry Riley
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

Re: [ cf-dev ] ValueList problem?

2004-04-23 Thread Terry Riley
in application.log? [EMAIL PROTECTED] (Terry Riley) 23/04/2004 10:58 Please respond to dev 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

Re: [ cf-dev ] ValueList problem?

2004-04-23 Thread duncan . cumming
: [ cf-dev ] ValueList problem? Unfortunately, Duncan, I don't have (easy) access (someone else's live server), but the original failure seems to have happened at end March, so doubt if they had data that far back, even if I could! I'll ask, though... Cheers Terry --Original Message

Re: [ cf-dev ] ValueList problem?

2004-04-23 Thread Terry Riley
on how many values you put into an IN ( ) clause in SQL. [EMAIL PROTECTED] (Terry Riley) 23/04/2004 11:28 Please respond to dev To: [EMAIL PROTECTED] cc: Subject:Re: [ cf-dev ] ValueList problem? Unfortunately, Duncan, I don't have

Re: [ cf-dev ] ValueList problem?

2004-04-23 Thread Terry Riley
of a ValueList, but there might be an issue on how many values you put into an IN ( ) clause in SQL. [EMAIL PROTECTED] (Terry Riley) 23/04/2004 11:28 Please respond to dev To: [EMAIL PROTECTED] cc: Subject:Re: [ cf-dev ] ValueList problem

RE: [ cf-dev ] ValueList problem?

2004-04-23 Thread Snake Hollywood
Have u tried putting a try/catch block around the query to see if it errors doing the IN statement? -Original Message- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 14:40 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] ValueList problem? To Hell with it! Just

RE: [ cf-dev ] ValueList problem?

2004-04-23 Thread Terry Riley
--Original Message- Have u tried putting a try/catch block around the query to see if it errors doing the IN statement? -Original Message- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 14:40 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] ValueList problem

Re: [ cf-dev ] ValueList

2003-09-15 Thread Tom Smith
it rocks my world when I use it!:) - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: Cfug Dev List (E-mail) [EMAIL PROTECTED] Sent: Friday, September 12, 2003 4:27 PM Subject: [ cf-dev ] ValueList Isn't ValueList() a bloody great function? I've always known about

[ cf-dev ] ValueList

2003-09-12 Thread Adrian Lynch
Isn't ValueList() a bloody great function? I've always known about it but never really used it. Isn't CF great :OD -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency

Re: [ cf-dev ] ValueList

2003-09-12 Thread Ian Westbrook
Isn't CF great :OD yep. best thing since html itself, IMHO... Ian W -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency --

RE: [ cf-dev ] ValueList

2003-09-12 Thread Snake Hollywood
Don't forget quotedvaluelist() -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 16:27 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] ValueList Isn't ValueList() a bloody great function? I've always known about it but never really used

RE: [ cf-dev ] ValueList

2003-09-12 Thread Adrian Lynch
Even better! -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 17:00 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] ValueList Don't forget quotedvaluelist() -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 12

Re: [ cf-dev ] ValueList

2003-09-12 Thread Damian Watson
and great-two-for-the-price-of-oneValueList() - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 12, 2003 5:18 PM Subject: RE: [ cf-dev ] ValueList Even better! -Original Message- From: Snake Hollywood [mailto:[EMAIL

RE: [ cf-dev ] ValueList

2003-09-12 Thread Snake Hollywood
Go change your password damian -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 17:30 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] ValueList and great-two-for-the-price-of-oneValueList() - Original Message - From: Adrian