CFTALK List Problems

2010-01-12 Thread Robert Harrison

Is this working??? I can't update my mailing lists and I've used to contact
form on House of Fusion and it's giving hard CF Errors. Is there anyone that
can help me with list problems?


Robert B. Harrison
Director of Interactive Services
Austin  Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be .

Plug in to our blog: AW Unplugged
http://www.austin-williams.com/unplugged
 

__ Information from ESET Smart Security, version of virus signature
database 4763 (20100112) __

The message was checked by ESET Smart Security.

http://www.eset.com
 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329571
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFTALK List Problems

2010-01-12 Thread John M Bliss

List is working.

On Tue, Jan 12, 2010 at 8:22 AM, Robert Harrison rob...@austin-williams.com
 wrote:


 Is this working??? I can't update my mailing lists and I've used to contact
 form on House of Fusion and it's giving hard CF Errors. Is there anyone
 that
 can help me with list problems?


 Robert B. Harrison
 Director of Interactive Services
 Austin  Williams
 125 Kennedy Drive, Suite 100
 Hauppauge NY 11788
 P : 631.231.6600 Ext. 119
 F : 631.434.7022
 http://www.austin-williams.com

 Great advertising can't be either/or.  It must be .

 Plug in to our blog: AW Unplugged
 http://www.austin-williams.com/unplugged


 __ Information from ESET Smart Security, version of virus signature
 database 4763 (20100112) __

 The message was checked by ESET Smart Security.

 http://www.eset.com


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329572
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFTALK List Problems

2010-01-12 Thread Jason Fisher

Yep.  Don't know about the site, but the mail list is working fine.




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329573
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CFTALK List Problems

2010-01-12 Thread brad

 Is there anyone that can help me with list problems?

FYI, if you're having problems with the list, or even more so, the HOF
site; the proper course of action is generally to E-mail the
administrator of both directly.  He usually responds in good time.

Michael Dinowitz 
mdino...@houseoffusion.com

~Brad






~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329574
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


List Problems

2007-11-12 Thread Robert Harrison
I posted two emails to the list this morning. They never showed.

Are there list problems today?


Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .




~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293138
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Delimited list problems - a bug?

2007-01-26 Thread Richard Kroll
Hey all,
One of my team members just brought to me something strange that to me
seems as if it's a bug.  If you use multiple delimiters to create a
list, and then use a single delimiter to fashion a sub-list, CF treats
the sub-list as two elements.  Here is an example:

cfset myList = 'element 1||element2||element3'

cfoutput
Single list using || as delim brbr
length = #listLen(myList, '||')# br  !--- This will produce 3
as expected ---
element1 = #listFirst(myList, '||')# br !--- 'element1' as
expected ---
element2 = #listGetAt(myList, 2, '||')# br!--- 'element2' as
expected ---
element3 = #listLast(myList, '||')# br !--- 'element3' as
expected ---
/cfoutput

br
br

cfset myNewList = 'element 1||element2a|element2b||element3'
!--- now add a sub-list using a single pipe char ---
Sublist using | as delim in a list using || as delim
cfoutput
length = #listLen(myNewList, '||')# br !--- returns 4?? ---
element1 = #listFirst(myNewList, '||')# br!--- 'element1' as
expected ---
element2 = #listGetAt(myNewList, 2, '||')# br !---
'element2a' wth?!?  This should return 'element2a|element2b' ---
element3 = #listLast(myNewList, '||')# br !--- 'element3' as
expected ---
/cfoutput

If I am explicitly telling CF that the delimiter is two pipes, why would
it stop when finding only one?  I tried this with other delimiters and
found the same behavior.  Am I crazy or does this appear to be a bug?

Rich Kroll 


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267725
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Delimited list problems - a bug?

2007-01-26 Thread Dave Phillips
If I remember right, when using multiple delimiters, they have to be
different, because two delimiters of the same character are treated as one
by ColdFusion.  I don't know if that has anything to do with the unexpected
results you are getting, but I do know that has caused me problems in the
past.

Hope this helps.  If I can find the reference, I'll post it.

Dave

-Original Message-
From: Richard Kroll [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 26, 2007 10:15 AM
To: CF-Talk
Subject: Delimited list problems - a bug?


Hey all,
One of my team members just brought to me something strange that to me seems
as if it's a bug.  If you use multiple delimiters to create a list, and then
use a single delimiter to fashion a sub-list, CF treats the sub-list as two
elements.  Here is an example:

cfset myList = 'element 1||element2||element3'

cfoutput
Single list using || as delim brbr
length = #listLen(myList, '||')# br  !--- This will produce 3 as
expected ---
element1 = #listFirst(myList, '||')# br !--- 'element1' as
expected ---
element2 = #listGetAt(myList, 2, '||')# br!--- 'element2' as
expected ---
element3 = #listLast(myList, '||')# br !--- 'element3' as
expected --- /cfoutput

br
br

cfset myNewList = 'element 1||element2a|element2b||element3'
!--- now add a sub-list using a single pipe char ---
Sublist using | as delim in a list using || as delim
cfoutput
length = #listLen(myNewList, '||')# br !--- returns 4?? ---
element1 = #listFirst(myNewList, '||')# br!--- 'element1' as
expected ---
element2 = #listGetAt(myNewList, 2, '||')# br !--- 'element2a'
wth?!?  This should return 'element2a|element2b' ---
element3 = #listLast(myNewList, '||')# br !--- 'element3' as
expected --- /cfoutput

If I am explicitly telling CF that the delimiter is two pipes, why would it
stop when finding only one?  I tried this with other delimiters and found
the same behavior.  Am I crazy or does this appear to be a bug?

Rich Kroll 




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267726
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Delimited list problems - a bug?

2007-01-26 Thread Ian Skinner
If I am explicitly telling CF that the delimiter is two pipes, why would it 
stop when finding only one?  I tried this with other delimiters and found the 
same behavior.  Am I crazy or does this appear to be a bug?


NOPE, it is not a bug but defiantly not an intuitive way for this to work.
But it is explained this way in the documentation.  When you provide a list of 
delimiters it is not an AND list, it is an OR list.  That means the list will 
be broken on any single character in the list.  See if this example does not 
clarify the behavior for you a little bit.


cfset myList = 'element 1|element2,element3'

Single list using '|' OR ',' as delim brbr
length = #listLen(myList, '|,')# br  
element1 = #listFirst(myList, '|,')# br 
element2 = #listGetAt(myList, 2, '|,')# br
element3 = #listLast(myList, '|,')# br 
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

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:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267728
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Delimited list problems - a bug?

2007-01-26 Thread Jerry Johnson
You are reading the multiple delimiter wrong.

From the docs:

delimiters
 A string or a variable that contains one. Character(s) that separate list
elements. Default: comma.
***
If this parameter contains more than one character, ColdFusion processes
each occurrence of each character as a delimiter.
***

http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt212.htm

To do what you want, I often do a search and replace on the double, making
it another single character (I often use the degree symbol, since it seldom
shows up in my text).

Jerry


On 1/26/07, Richard Kroll [EMAIL PROTECTED] wrote:

 Hey all,
 One of my team members just brought to me something strange that to me
 seems as if it's a bug.  If you use multiple delimiters to create a
 list, and then use a single delimiter to fashion a sub-list, CF treats
 the sub-list as two elements.  Here is an example:

 cfset myList = 'element 1||element2||element3'

 cfoutput
 Single list using || as delim brbr
 length = #listLen(myList, '||')# br  !--- This will produce 3
 as expected ---
 element1 = #listFirst(myList, '||')# br !--- 'element1' as
 expected ---
 element2 = #listGetAt(myList, 2, '||')# br!--- 'element2' as
 expected ---
 element3 = #listLast(myList, '||')# br !--- 'element3' as
 expected ---
 /cfoutput

 br
 br

 cfset myNewList = 'element 1||element2a|element2b||element3'
 !--- now add a sub-list using a single pipe char ---
 Sublist using | as delim in a list using || as delim
 cfoutput
 length = #listLen(myNewList, '||')# br !--- returns 4?? ---
 element1 = #listFirst(myNewList, '||')# br!--- 'element1' as
 expected ---
 element2 = #listGetAt(myNewList, 2, '||')# br !---
 'element2a' wth?!?  This should return 'element2a|element2b' ---
 element3 = #listLast(myNewList, '||')# br !--- 'element3' as
 expected ---
 /cfoutput

 If I am explicitly telling CF that the delimiter is two pipes, why would
 it stop when finding only one?  I tried this with other delimiters and
 found the same behavior.  Am I crazy or does this appear to be a bug?

 Rich Kroll


 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267730
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Delimited list problems - a bug?

2007-01-26 Thread Richard Kroll
 But it is explained this way in the documentation.  When you provide a
 list of delimiters it is not an AND list, it is an OR list.  

Thanks.  I did not even consult the doc's on this, I made the assumption
that multiple delimiters were treated in an AND fashion.  I guess I now
know what they mean by the saying Making assumptions...

Thanks for the clarification guys.

I can't say that I've ever run into a situation where I needed the OR
operation, seems to me the AND operation is more natural.  I don't
suppose there is any way to accomplish what my coworker is going for?

Rich Kroll


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267734
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Delimited list problems - a bug?

2007-01-26 Thread Dave Watts
 I can't say that I've ever run into a situation where I 
 needed the OR operation, seems to me the AND operation is 
 more natural.  I don't suppose there is any way to accomplish 
 what my coworker is going for?

Sure. Replace the substring that you want to use as a list delimiter with a
single character, then do your list operation. For the single character, be
careful to use something that's unlikely to be in your data already. I like
to use a non-printable character for this, like the Bell character (ASC 7, I
think).

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267737
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Delimited list problems - a bug?

2007-01-26 Thread Scott Weikert
I've done similar things, but I've used different delimeters, i.e.

element 1|element 2a:element 2b|element 3

using a pipe as the primary delim and a colon as the secondary delim. 
Works great.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267748
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Delimited list problems - a bug?

2007-01-26 Thread Everett, Al \(NIH/NIGMS\) [C]
Sure. Replace the substring that you want to use as a list delimiter
with a single character, then do your list operation. For the single
character, be careful to use something that's unlikely to be in your
data already. I like to use a non-printable character for this, like
the Bell character (ASC 7, I think).

I like to use CHR(30) for that, which is the record separator
character.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267759
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Digest mode list problems

2006-09-06 Thread Earl, George
I'm having all kinds of issues with my cf-talk and cf-community digests.
Are those of you who get the single message feed having problems too? 

George

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252204
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


More weird HOF list problems

2005-06-30 Thread James Holmes
It seems that a few hours ago I stopped getting any of my HOF lists
mail at my gmail account. The only stuff I'm getting now is CF-Talk,
to my other (old) email addy. I changed my settings many days ago to
leave just my gmail account in the HOF profile, so I'm not sure what's
up.

Does anyone have any ideas?

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210965
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


list problems - empty fields

2002-11-23 Thread Seamus Campbell
Hi

I'm reading a txt file which has 3 fields to a line
eg

14||'Maggin, Elliot S.'
15||'Maine, Charles Eric'
16|1|'McCaffrey, Anne'

but often the second field is empty

Lists don't believe an empty field exists so I keep getting errors when I 
try to loop over the list to import to a database

How can I make the list a true believer? (in accepting empty fields?)

Or is there an alternative way to import the data?  (access database and 
ColdFusion 5)

Help please
Many thanks in advance
seamus

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: list problems - empty fields

2002-11-23 Thread Kym Kovan
Hi Seamus,

I'm reading a txt file which has 3 fields to a line
eg

14||'Maggin, Elliot S.'
15||'Maine, Charles Eric'
16|1|'McCaffrey, Anne'

but often the second field is empty

Lists don't believe an empty field exists so I keep getting errors when I 
try to loop over the list to import to a database

How can I make the list a true believer? (in accepting empty fields?)

Use the replace() function to change the adjacent delimiters pairs to pairs with 
something you know is a null for the relevant field. 

Say change || to |.|.


--

Yours,

Kym

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Re: list problems - empty fields

2002-11-23 Thread Seamus Campbell
thanks Kym
I was trying something like that but had the syntax wrong so assumed I was 
on the wrong track.
Thanks again
Seamus

At 10:06 PM 23/11/02 , you wrote:
Hi Seamus,

 I'm reading a txt file which has 3 fields to a line
 eg
 
 14||'Maggin, Elliot S.'
 15||'Maine, Charles Eric'
 16|1|'McCaffrey, Anne'
 
 but often the second field is empty
 
 Lists don't believe an empty field exists so I keep getting errors when I
 try to loop over the list to import to a database
 
 How can I make the list a true believer? (in accepting empty fields?)

Use the replace() function to change the adjacent delimiters pairs to 
pairs with something you know is a null for the relevant field.

Say change || to |.|.


--

Yours,

Kym


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: list problems - empty fields

2002-11-23 Thread stas
There is a custom tag on DevEx - CSV2Query that will convert a list to a
query. It will handle empty fields for you, and you could probably get
better functionality for what your doing with a list.

 -Original Message-
 From: Seamus Campbell [mailto:[EMAIL PROTECTED]] 
 Sent: Saturday, November 23, 2002 5:38 AM
 To: CF-Talk
 Subject: list problems - empty fields
 
 
 Hi
 
 I'm reading a txt file which has 3 fields to a line
 eg
 
 14||'Maggin, Elliot S.'
 15||'Maine, Charles Eric'
 16|1|'McCaffrey, Anne'
 
 but often the second field is empty
 
 Lists don't believe an empty field exists so I keep getting 
 errors when I 
 try to loop over the list to import to a database
 
 How can I make the list a true believer? (in accepting empty fields?)
 
 Or is there an alternative way to import the data?  (access 
 database and 
 ColdFusion 5)
 
 Help please
 Many thanks in advance
 seamus
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: list problems - empty fields

2002-11-23 Thread Jon Hall
Saturday, November 23, 2002, 5:37:57 AM, you wrote:
SC I'm reading a txt file which has 3 fields to a line
SC eg

SC 14||'Maggin, Elliot S.'
SC 15||'Maine, Charles Eric'
SC 16|1|'McCaffrey, Anne'

SC but often the second field is empty

SC Lists don't believe an empty field exists so I keep getting errors when I 
SC try to loop over the list to import to a database

SC How can I make the list a true believer? (in accepting empty fields?)

listToArray(list, |) might do the trick. Then each of your fields
would be an element in the array, even the null ones.

SC Or is there an alternative way to import the data?  (access database and 
SC ColdFusion 5)

Set up an ODBC Text Datasource for the file if you have a text driver
on the machine. It requires less code, and is magnitudes faster than
converting a csv to a query with CF logic. Once the datasource is set
up, it's one cfquery to convert the entire csv to a query.

cfquery datasource=textDSN name=qry
SELECT *
FROM [foo.csv]
/cfquery

I know CF5 Enterprise comes with the Merant text drivers, and the
Microsoft text drivers work very nice as well. I'm just not sure if they
get installed with Access or just with SQL Server.

You could also try bypassing all the insanity directly and using
the Link Table function to link the text file directly to the
database. No need to do anything then...the text file is already part
of the database.

-- 
jon
mailto:[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



CF Talk list problems?

2002-06-11 Thread Shawn Grover

Am I the only one receiving messages I received already this morning or
yesterday?  I've seen 5 or 6 message (at least the ones I've read) that were
duplicates...

Just thought I'd mention it in case no one else has.

Shawn Grover
Object Programmer
[EMAIL PROTECTED]

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Talk list problems?

2002-06-11 Thread Ryan Kime

You are not alone...

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 11, 2002 4:32 PM
To: CF-Talk
Subject: CF Talk list problems?


Am I the only one receiving messages I received already this morning or
yesterday?  I've seen 5 or 6 message (at least the ones I've read) that were
duplicates...

Just thought I'd mention it in case no one else has.

Shawn Grover
Object Programmer
[EMAIL PROTECTED]
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Talk list problems?

2002-06-11 Thread Michael Dinowitz

Has this been for all messages or just some? Are there any patterns such as time or 
topic? I've been doing a lot of work on the new archives 
(www.houseoffusion.com/cf_lists) but I doubt there's anything going on there that 
would affect CF-Talk. The more you can tell me about the problems, the easier it'll be 
for me to hunt down the problem.
Thanks

At 05:32 PM 6/11/02, you wrote:
Am I the only one receiving messages I received already this morning or
yesterday?  I've seen 5 or 6 message (at least the ones I've read) that were
duplicates...

Just thought I'd mention it in case no one else has.

Shawn Grover
Object Programmer
[EMAIL PROTECTED]


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Talk list problems?

2002-06-11 Thread Jon Hall

I saw one duplicate today...I haven't really noticed any others.

First one was recieved: Mon, 10 Jun 2002 16:16:02 -0400
Second one received: Tue, 11 Jun 2002 17:27:32 -0400
Shawn Regan [EMAIL PROTECTED]
Subject RE: DIV question

The Date header on both was exactly the same:
Mon, 10 Jun 2002 13:13:34 -0700

jon
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 11, 2002 6:27 PM
Subject: Re: CF Talk list problems?


 Has this been for all messages or just some? Are there any patterns such
as time or topic? I've been doing a lot of work on the new archives
(www.houseoffusion.com/cf_lists) but I doubt there's anything going on there
that would affect CF-Talk. The more you can tell me about the problems, the
easier it'll be for me to hunt down the problem.
 Thanks

 At 05:32 PM 6/11/02, you wrote:
 Am I the only one receiving messages I received already this morning or
 yesterday?  I've seen 5 or 6 message (at least the ones I've read) that
were
 duplicates...
 
 Just thought I'd mention it in case no one else has.
 
 Shawn Grover
 Object Programmer
 [EMAIL PROTECTED]
 
 
 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Talk list problems?

2002-06-11 Thread Shawn Grover

This has only been for some messages (the Shawn Regan message was one, but I
also saw some of Dave Watt's messages duplicated).  It is NOT happening for
all messages, and seems to be a bit sporadic.

Don't know what more I can tell you - other than sending the duplicate
messages to you.  That'll take me a bit of time to dig out, so email me
offlist if you need that.

Thanks Mike.

Shawn Grover

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 4:50 PM
To: CF-Talk
Subject: Re: CF Talk list problems?


I saw one duplicate today...I haven't really noticed any others.

First one was recieved: Mon, 10 Jun 2002 16:16:02 -0400
Second one received: Tue, 11 Jun 2002 17:27:32 -0400
Shawn Regan [EMAIL PROTECTED]
Subject RE: DIV question

The Date header on both was exactly the same:
Mon, 10 Jun 2002 13:13:34 -0700

jon
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 11, 2002 6:27 PM
Subject: Re: CF Talk list problems?


 Has this been for all messages or just some? Are there any patterns such
as time or topic? I've been doing a lot of work on the new archives
(www.houseoffusion.com/cf_lists) but I doubt there's anything going on there
that would affect CF-Talk. The more you can tell me about the problems, the
easier it'll be for me to hunt down the problem.
 Thanks

 At 05:32 PM 6/11/02, you wrote:
 Am I the only one receiving messages I received already this morning or
 yesterday?  I've seen 5 or 6 message (at least the ones I've read) that
were
 duplicates...
 
 Just thought I'd mention it in case no one else has.
 
 Shawn Grover
 Object Programmer
 [EMAIL PROTECTED]
 
 
 

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: list problems

2001-01-11 Thread lsellers


 Excuse me, folks, but has anyone else had trouble getting
 messages from the
 list? I didn't receive anything for several hours and now am getting
 messages, but no backlog. Is it the list or my system?

The list server fell asleep again. That or everyone woke up at midnight
after a nice nap and started posting to it.

I favour the first explaination.

(ie, same here.)

--min



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: list problems

2001-01-11 Thread Howie Hamlin

I see the same thing from here...

Regards,

Howie

- Original Message -
From: "Hal Helms" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 12:46 AM
Subject: OT: list problems


 Excuse me, folks, but has anyone else had trouble getting messages from
the
 list? I didn't receive anything for several hours and now am getting
 messages, but no backlog. Is it the list or my system?

 Hal Helms
 == See www.ColdFusionTraining.com for info on "Best Practices with
 ColdFusion  Fusebox" training, Jan 22-25 ==



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: list problems

2001-01-11 Thread Russel Madere

I had a complete drought yesterday from 2PM CST until after 5PM CST.
Nothing from House of Fusion at all.

Russel


  Russel Madere, Jr. Senior Web Developer
  ICQ: 5446158   http://www.TurboSquid.com

Some days you eat the bear; some days the bear eats you.



 -Original Message-
 From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 11, 2001 02:24
 To: CF-Talk
 Subject: Re: list problems


 I see the same thing from here...

 Regards,

 Howie

 - Original Message -
 From: "Hal Helms" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Thursday, January 11, 2001 12:46 AM
 Subject: OT: list problems


  Excuse me, folks, but has anyone else had trouble getting messages from
 the
  list? I didn't receive anything for several hours and now am getting
  messages, but no backlog. Is it the list or my system?
 
  Hal Helms
  == See www.ColdFusionTraining.com for info on "Best Practices with
  ColdFusion  Fusebox" training, Jan 22-25 ==




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: list problems

2001-01-11 Thread Michael Dinowitz

When I got back from a parent/teacher meeting yesterday I found the list was
down. When I dug through it I found that the problem was a base64 encoded
message that was causing my CF template to bomb. I use a CF template to
parse ALL mail for the lists to clean it up, check it for viruses and such.
I removed the mail and all the old posts went through. You should have the
old messages for the day (102 total for the lists at time of problem). It my
be backlogged based on your mailserver and I'll check that out.


 Excuse me, folks, but has anyone else had trouble getting messages from
the
 list? I didn't receive anything for several hours and now am getting
 messages, but no backlog. Is it the list or my system?

 Hal Helms
 == See www.ColdFusionTraining.com for info on "Best Practices with
 ColdFusion  Fusebox" training, Jan 22-25 ==


 -Original Message-
 From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 10, 2001 11:05 PM
 To: CF-Talk
 Subject: query to struct?


 does anyone knows how to convert a query result set to a structure?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: list problems

2001-01-11 Thread Greg Wolfinger

Hal:

The same thing is happening with me to and I have a pretty reliable network
and a brand spanking new Dell i800 laptop with plenty of juice, so I think
its the list.

--=@ greg @=--
- Original Message -
From: "Hal Helms" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 12:46 AM
Subject: OT: list problems


 Excuse me, folks, but has anyone else had trouble getting messages from
the
 list? I didn't receive anything for several hours and now am getting
 messages, but no backlog. Is it the list or my system?

 Hal Helms
 == See www.ColdFusionTraining.com for info on "Best Practices with
 ColdFusion  Fusebox" training, Jan 22-25 ==


 -Original Message-
 From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 10, 2001 11:05 PM
 To: CF-Talk
 Subject: query to struct?


 does anyone knows how to convert a query result set to a structure?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: list problems

2001-01-11 Thread Philip Arnold - ASP

 The same thing is happening with me to and I have a pretty
 reliable network
 and a brand spanking new Dell i800 laptop with plenty of juice, so I think
 its the list.

Funnily enough, PC speed has little to do with email speed - I could run a
P100 through a T1 link and it'd work faster over the internet than a Dual
PIII-933... Strange that.

Although you was probably only showing off g

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: list problems

2001-01-11 Thread Greg Wolfinger

 Although you was probably only showing off g

Hell Yeh I was, I spent enough money on the damn thing.  It rides up front
with a seatbelt on when I go to and from work.

--=@ greg @=---
- Original Message -
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 1:09 PM
Subject: RE: list problems


  The same thing is happening with me to and I have a pretty
  reliable network
  and a brand spanking new Dell i800 laptop with plenty of juice, so I
think
  its the list.

 Funnily enough, PC speed has little to do with email speed - I could run a
 P100 through a T1 link and it'd work faster over the internet than a Dual
 PIII-933... Strange that.

 Although you was probably only showing off g

 Philip Arnold
 Director
 Certified ColdFusion Developer
 ASP Multimedia Limited
 T: +44 (0)20 8680 1133

 "Websites for the real world"

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 **



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: list problems

2001-01-10 Thread Hal Helms

Excuse me, folks, but has anyone else had trouble getting messages from the
list? I didn't receive anything for several hours and now am getting
messages, but no backlog. Is it the list or my system?

Hal Helms
== See www.ColdFusionTraining.com for info on "Best Practices with
ColdFusion  Fusebox" training, Jan 22-25 ==


-Original Message-
From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 11:05 PM
To: CF-Talk
Subject: query to struct?


does anyone knows how to convert a query result set to a structure?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Anyone else having list problems?

2000-06-06 Thread Stephen Garrett


I've been having this problem for many many months, and only from
cftalk. Usually about a dozen or so every day.

At 05:07 PM 6/2/2000 -0400, Bud wrote:
Hi. For the second time this week, I check my mail and the first 
thing I get is an error message: Error while checking mail. The 
attachment was corrupted. An illegal character was found. From there, 
I proceed to download approximately 1,000 e-mails, all from cf-talk. 
This happened about 2 weeks ago also. Quite a pain and plays havoc 
with my Eudora. They come through real fast, about 5 a second, and 
are all are marked as having encoding errors. Is it the listserv, or 
mindspring?
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Stephen Garrett
GPS
[EMAIL PROTECTED]   (360) 896-2714
ICQ# 10776767
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Anyone else having list problems?

2000-06-03 Thread Bud

Hi. For the second time this week, I check my mail and the first 
thing I get is an error message: Error while checking mail. The 
attachment was corrupted. An illegal character was found. From there, 
I proceed to download approximately 1,000 e-mails, all from cf-talk. 
This happened about 2 weeks ago also. Quite a pain and plays havoc 
with my Eudora. They come through real fast, about 5 a second, and 
are all are marked as having encoding errors. Is it the listserv, or 
mindspring?
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.