I am currently out of the office and will return on Monday, August 21. Any urgent
concerns should be forwarded to David McCormick or Mary Prosceno.
>>> CF-Talk 08/12/00 22:42 >>>
CF-Talk Sat, 12 Aug 2000 Volume 1 : Number 137
In this issue:
Re: CF-Talk V1 #136 (Out of office)
RE: File name with query string in JS function
RE: SQL Question (sorta OT)
RE: Page Breaks
[MEETING] NCCFUG Meeting 8/16/00
problem with mail attachements
<cfudate> and missing table
AW: <cfudate> and missing table
Version 4.5.1 memory leak fixed?
Fusebox conference...
ValueList Question ...
RE: Version 4.5.1 memory leak fixed?
Re: Version 4.5.1 memory leak fixed?
Re: Version 4.5.1 memory leak fixed?
RE: ValueList Question ...
Escape '&' in URL?
RE: Escape '&' in URL?
RE: ValueList Question ...
RE: Version 4.5.1 memory leak fixed?
Re: Version 4.5.1 memory leak fixed?
CFCache and newtork drives?
Other ways to skin the cat?
Re: ValueList Question ...
Re: Optimization tips collection
CF_Newbie
RE: Escape '&' in URL?
Re: CF_Newbie
Re: CF_Newbie
Re: CF_Newbie
Re: CF_Newbie
RE: CF_Newbie
Re: CF_Newbie
Re: CF_Newbie
Re: CF_Newbie
Re: CF_Newbie
test
TEST - I am trying to get rid of the 'mime' format in my messages
Re: CF_Newbie
Re: TEST - I am trying to get rid of the 'mime' format in my
messages
Updating a remote db from local csv file
Re: CF_Newbie
RE: Other ways to skin the cat?
----------------------------------------------------------------------
Date: Sat, 12 Aug 2000 06:30:52 -0400
From: "Julie Hopple" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: CF-Talk V1 #136 (Out of office)
Message-ID: <[EMAIL PROTECTED]>
I am currently out of the office and will return on Monday, August 21. =
Any urgent concerns should be forwarded to David McCormick or Mary =
Prosceno.
>>> CF-Talk 08/12/00 06:41 >>>
CF-Talk Sat, 12 Aug 2000 Volume 1 : Number =
136
In this issue:
Queries
Re: Announcing: CF_OUTPUTPG - the example file
Re: Announcing: CF_OUTPUTPG - the example file
Re: CFTHROW
RE: Verity vs. Freetext
RE: CFFILE problem on Linux
----------------------------------------------------------------------
Date: Fri, 11 Aug 2000 22:36:39 -0400
From: "Andrew" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Queries
Message-ID: <010501c00406$24f206d0$0100000a@rudebwoy>
This is a multi-part message in MIME format.
------=3D_NextPart_000_0102_01C003E4.9D6F5580
Content-Type: text/plain;
charset=3D"iso-8859-1"
Content-Transfer-Encoding: quoted-printable
2 Questions.
1. Just curious, is it possible to do a query across two different =3D
datasources? I have a table in one datasource and I would like to do =3D
some kind of join query on another table that would make things simple =3D
except that the other table is in another datasource. Is it possible to =
=3D
do the query regardless of the fact that the tables are in different =3D
datasources?
2. Is it possible to do a query on a query result set? I have the =3D
results from a CFQUERY but I was wondering if one could then do a query =
=3D
using the query results as if it was a table itself?
Andrew Hewitt
Web Application Developer
webworld studios inc.
------=3D_NextPart_000_0102_01C003E4.9D6F5580
Content-Type: text/html;
charset=3D"iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D3D"text/html; charset=3D3Diso-8859-1" =3D
http-equiv=3D3DContent-Type>
<META content=3D3D"MSHTML 5.00.2920.0" name=3D3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D3D#ffffff>
<DIV> </DIV>
<DIV><FONT face=3D3DArial size=3D3D2>2 Questions.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D3DArial size=3D3D2>1. Just curious, is it possible =
=3D
to do a query=3D20
across two different datasources? I have a table in one datasource =
=3D
and I=3D20
would like to do some kind of join query on another table that would =3D
make things=3D20
simple except that the other table is in another datasource. Is it =
=3D
possible to do the query regardless of the fact that the tables are in =3D
different=3D20
datasources?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D3DArial size=3D3D2>2. Is it possible to do a query =
=3D
on a query=3D20
result set? I have the results from a CFQUERY but I was wondering =
=3D
if one=3D20
could then do a query using the query results as if it was a =
table=3D20
itself?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D3DArial size=3D3D2>
<DIV>Andrew Hewitt</DIV>
<DIV>Web Application Developer</DIV>
<DIV>webworld studios inc.</DIV>
<DIV> </DIV></FONT></DIV></BODY></HTML>
------=3D_NextPart_000_0102_01C003E4.9D6F5580--
------------------------------
Date: Fri, 11 Aug 2000 22:42:33 -0400
From: Peter Theobald <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Announcing: CF_OUTPUTPG - the example file
Message-ID: <[EMAIL PROTECTED]>
Sorry - any of you with HTML based email didn't see the source code, you =
saw the OUTPUT (kind-of)
Here again is the example file:
<pre>
<!---
// Testpg.cfm
// Peter Theobald 8/10/2000
// [EMAIL PROTECTED]
//
// This file is a simple example of using the CF_OUTPUTPG module
// Make sure outputpg.cfm is in the same directory or in your CustomTags =
directory
--->
<!---
// replace this with your own favorite query
// make it 3 columns if you want to keep
// all the formatting the same as whats already below.
--->
<cfquery name=3D"q_users" datasource=3D"#MyDSN#">
select UserName, UserType, Email
from Users
</cfquery>
<html><body>
This is a test of custom tag CF_OUTPUTPG.<p>
<cfparam name=3D"url.startrow" default=3D"1">
<table border=3D1 width=3D50%><tr><td>User</td><td>Type</td><td>Email</td><=
/tr>
<cf_outputpg query=3D"q_users" startrow=3D"#url.startrow#">
<tr><td>#UserName#</td><td>#UserType#</td><td>#Email#</td></tr>
</cf_outputpg>
</table>
<table border=3D0 width=3D50%>
<tr><cfoutput>
<td><a href=3D"testpg.cfm?startrow=3D#outputpg.prevstart#">PREV PAGE</a></t=
d>
<td align=3Dcenter>Page #outputpg.thispage# of #outputpg.numpages#</td>
<td align=3Dright><a href=3D"testpg.cfm?startrow=3D#outputpg.nextstart#">NE=
XT PAGE</a></td>
</cfoutput></tr></table>
</body></html>
</pre>
---------------------------------------------------------------------------=
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
------------------------------
Date: Fri, 11 Aug 2000 23:12:33 -0400
From: "Phil Labonte" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Announcing: CF_OUTPUTPG - the example file
Message-ID: <00b301c0040b$29d7be10$f2bb7018@cr716804a>
test
----- Original Message -----
From: "Peter Theobald" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 10:42 PM
Subject: Re: Announcing: CF_OUTPUTPG - the example file
> Sorry - any of you with HTML based email didn't see the source code, you
saw the OUTPUT (kind-of)
>
> Here again is the example file:
>
> <pre>
> <!---
> // Testpg.cfm
> // Peter Theobald 8/10/2000
> // [EMAIL PROTECTED]
> //
> // This file is a simple example of using the CF_OUTPUTPG module
> // Make sure outputpg.cfm is in the same directory or in your CustomTags
directory
> --->
>
> <!---
> // replace this with your own favorite query
> // make it 3 columns if you want to keep
> // all the formatting the same as whats already below.
> --->
> <cfquery name=3D"q_users" datasource=3D"#MyDSN#">
> select UserName, UserType, Email
> from Users
> </cfquery>
>
> <html><body>
>
> This is a test of custom tag CF_OUTPUTPG.<p>
> <cfparam name=3D"url.startrow" default=3D"1">
>
> <table border=3D1
width=3D50%><tr><td>User</td><td>Type</td><td>Email</td></tr>
>
> <cf_outputpg query=3D"q_users" startrow=3D"#url.startrow#">
> <tr><td>#UserName#</td><td>#UserType#</td><td>#Email#</td></tr>
> </cf_outputpg>
>
> </table>
>
> <table border=3D0 width=3D50%>
> <tr><cfoutput>
> <td><a href=3D"testpg.cfm?startrow=3D#outputpg.prevstart#">PREV =
PAGE</a></td>
> <td align=3Dcenter>Page #outputpg.thispage# of #outputpg.numpages#</td>
> <td align=3Dright><a href=3D"testpg.cfm?startrow=3D#outputpg.nextstart#">=
NEXT
PAGE</a></td>
> </cfoutput></tr></table>
> </body></html>
>
> </pre>
>
>
> -------------------------------------------------------------------------=
-
-
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 Fax 1.212.679.8032
>
> -------------------------------------------------------------------------=
-
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_talk=
or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
Date: Sat, 12 Aug 2000 01:26:18 +0000
From: "Gene Kraybill" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: "Miriam Hirschman" <[EMAIL PROTECTED]>
Subject: Re: CFTHROW
Message-ID: <[EMAIL PROTECTED]>
Miriam Hirschman wrote:=20
=20
> How Do I define my own error in a cfthrow? I would like to say if the =
error
> is an invalid search criteria then....
Try something like this:
<CFTRY>
<CFIF SearchCriteria IS Invalid>
<CFTHROW TYPE=3D"MyCustomError" MESSAGE=3D"Your Search Criteria =
are Invalid">
</CFIF>
<CFCATCH TYPE=3D"MyCustomError">
#CFCATCH.Message#
</CFCATCH>
</CFTRY>
Basically the idea is to wrap the CFTHROW in conditional code so that it =
creates an error=20
when certain conditions are met. You then "catch" the error by referring =
to it with the=20
TYPE parameter using CFCATCH, and display the defined error message using =
CFCATCH.Message=20
(and CFCATCH.Detail, if you define that as well).
Gene Kraybill
------------------------------
Date: Sat, 12 Aug 2000 00:14:25 -0700
From: "James" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Verity vs. Freetext
Message-ID: <[EMAIL PROTECTED]>
I would like to try this too. This would certainly be a cheaper alternative=
than
Texis. If you don't mind, could you email me the code to use this off =
list.
James
[EMAIL PROTECTED]
-----Original Message-----
From: Tom [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 11:10 AM
To: [EMAIL PROTECTED]
Subject: Re: Verity vs. Freetext
A product I use for full-text indexing and searching is called textdb
(www.webest.dk)
It's a small and cheap product. It's not as straight-forward to use as
mssql fulltext, but it's furociously quicker than mssql or oracle (and
presumably verity with comparisons of it being slower than sql7).
I have a db with 500,000 records containing descriptions ranging from 5k =
to
1 meg of data, and ANY search I do is finished within half a second. I can
do a wildcard "a" search, or a very complex conditional query using =
"sounds
like" operators, and still get my results back in that amount of time. =
Not
sure if version 4 is out yet, but version 3.whatever didn't support =
phrases,
the new version does (and is just as quick as before).
Building the full text index also blows away the competition. It's not as
rich in features as teh others, and has a couple other limitations - but =
raw
speed (both building, updating, and retrieving) blows ms sql and oracle
(context stuff and intermedia) out of the water. I can build an index in
about 20 minutes on multiple fields against the 500k record database - =
this
is from scratch.
It works as a com object, so you need to use cfobject (which I have sample
code for it) - but this still works very quickly.
Not sure about how it works with thai, but it's very impressive nonetheless=
.
well, that's my 2 cents.
Tom
----- Original Message -----
From: Paul Hastings <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 10, 2000 12:13 PM
Subject: Re: Verity vs. Freetext
> > Which would be faster - a verity collection, or using SQL 7's =
Full-text
> > indexing? We are probably talking about well over 20,000 individual
> > records.
>
> i didn't see any answers to this so...from our work sql server 7
> full text indexing beats verity flat out if you have to come back
> to the db for row details. besides the obvious hit of having to
> re-query the db, verity doesn't cache queries, etc. its also a
> shotgun search thru the "body" of your text data which may be
> from several columns & thus hard or impossible to id. on top of
> that verity doesn't work w/thai language ;-)
>
>
> -------------------------------------------------------------------------=
-
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_talk=
or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
---------------------------------------------------------------------------=
-
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_talk=
or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sat, 12 Aug 2000 00:41:51 -0700
From: "James" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: CFFILE problem on Linux
Message-ID: <[EMAIL PROTECTED]>
Just a thought, make sure that cffile is enabled on the CF Administrator.
If it isn't you won't be able to write to any directory.
-----Original Message-----
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: CFFILE problem on linux
If you have error logs they might give you some idea. For instance, if
there is some other username being used for some reason (not that I know
what reason that would be) you may be able to trace down the username in
the error log. I'm not sure what kinds of logging are available but I know
that you can track that in Solaris. You should be able to track it in =
Linux
also.
At 03:35 PM 8/7/00 +1000, you wrote:
>Hi there,
>
>I'm trying to get CFFILE working on a linux box. ColdFusion is running as
>a user
>called coldfusion which has group write privileges to my HTML directory. =
If
I
>log in as the coldfusion user I can create directories and files in the
HTML
>directory OK.
>
>However, when I try to do a <CFFILE ACTION=3D"WRITE"> into that same
directory I
>get a permissions error.
>
>I am not running advanced security.
>
>What is going on?
>
>--------
>Rob Keniger
>
>
>--------------------------------------------------------------------------=
-
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_tal=
k or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
---------------------------------------------------------------------------=
-
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_talk=
or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
End of CF-Talk V1 #136
**********************
---------------------------------------------------------------------------=
---
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk or send a message to [EMAIL PROTECTED]=
m with 'unsubscribe' in the body.
------------------------------
Date: Sat, 12 Aug 2000 15:37:27 +0100
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: File name with query string in JS function
Message-ID: <[EMAIL PROTECTED]>
> The error description follows:
>
> Error in expression:
>
> url.sort = "thumbnail"
>
> Invalid conditional expression. Perhaps you are using = instead of EQ
> or IS
> to compare values.
>
> The error occurred while processing an element with a general
> identifier of
> (CFIF), occupying document position (2:1) to (2:29).
>
> The correct template gets called, but when the first line,
> which reads, "<cfif url.sort = "thumbnail">" is reached, the error occurs.
Can I just say it's got NOTHING to do with your JavaScript - that "=" should
not be in the CFIF, it should be "is"
<cfif url.sort is "thumbnail">
HTH
Philip Arnold
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.
**********************************************************************
------------------------------
Date: Sat, 12 Aug 2000 15:45:20 +0100
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: SQL Question (sorta OT)
Message-ID: <[EMAIL PROTECTED]>
> > I would like to add "omit <> 'yes' " to the WHERE clause. When I
> > do this, the
> > query returns 0 records (unmodified, it returns 25 records).
> AND NOT omit = 'yes'
In addition to Kevin's comments, some flavors of SQL (especially SQL Server)
treat NULL differently - so "NOT omit='Yes'" will ignore NULL values as it's
only looking for string values, it might be worth using;
AND (NOT omit='yes' OR omit IS NULL)
Try both and see what happens...
Philip Arnold
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.
**********************************************************************
------------------------------
Date: Sat, 12 Aug 2000 15:52:20 +0100
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Page Breaks
Message-ID: <[EMAIL PROTECTED]>
> Is it possible to do a page break or a Page eject between forms.
>
> We are currently using:
>
> <h1 style="page-break-before: always"><h1>
>
> This seems to work in netscapre but not IE.
IE has a very odd usage on CSS, some of it works properly, others don't work
at all...
Maybe you could use a <br style="page-break-after: alwasy"> before the <h1>
and see if that works... I've not tested it though
Philip Arnold
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.
**********************************************************************
------------------------------
Date: Sat, 12 Aug 2000 10:49:35 -0600
From: Annette Kunovic <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Subject: [MEETING] NCCFUG Meeting 8/16/00
Message-ID: <[EMAIL PROTECTED]>
This is the Northern Colorado ColdFusion Users Group.
http://www.nccfug.com
Since we are having the meeting in the evening this time, make sure you
RSVP by TUESDAY ( http://www.nccfug.com) if you plan to attend. The
building elevator is locked at night so even if you could get past the
security guard, you would have to walk up 32 flights of stairs. If you
RSVP (again by Tuesday, 8/15/00) instead, your name will be on the
"NCCFUG Meeting" list and you can ride the elevator in comfort. Wouldn't
that be nice?
Date: Wednesday, August 16, 2000
Time: 6-8pm
Place: Holland and Hart, Qwest building downtown Denver
Topic: Building Large Applications with Fusebox
Lead by: Erik Madsen, Macedon Mediature
AGENDA:
I. Welcome and News
II. Erik Madsen, Macedon Mediature
ATTENDANCE NOTE:
There is no charge for attending the meeting but please RSVP your
attendance. The RSVP form can be found at the bottom of
http://www.nccfug.com/meetings/
NEXT MEETING:
September 26th. 3-5pm.
MISCELLANEOUS:
Conference room and equipment courtesy of Holland and Hart. Refreshments
and snacks courtesy of Trilemetry, Inc.
Annette
[EMAIL PROTECTED]
http://www.nccfug.com
------------------------------
Date: Sat, 12 Aug 2000 13:02:09 -0400
From: "Christopher S Martin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: problem with mail attachements
Message-ID: <000a01c0047f$0d472d20$d4696fd1@chrisjr>
Hello again. I am trying to write a web based email client, and I have a
minor problem. It does everything fine, except for dealing with
attachments. Specifically, I have code in the view message page that checks
for the existence of attachments. This does not ,however, seem to work
Here's what I get:
An error occurred while evaluating the expression:
ParamterExists(Message.Attachments)
----------------------------------------------------------------------------
----
Error resolving parameter MESSAGE.ATTACHMENTS
The column ATTACHMENTS is not present in the query named MESSAGE. It is
likely that you have misspelled the name of the column.
Any idea what could be causing this?
Chris Martin
[EMAIL PROTECTED]
www.fsenablers.com
www.fslink.com
------------------------------
Date: Sat, 12 Aug 2000 12:45:17 -0400
From: "Trusz, Andrew" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: <cfudate> and missing table
Message-ID: <2160A70CD4D7D2119C940008C7B1CF1510003B@HYEXM01>
Hello,
Having trouble with <CFUPDATE>. The table being updated is not found in the
datasource even though the data to be updated has just been extracted from
that table. Database is Oracle 8
Tag is <cfupdate datasource="billygoat" tablename="main_table">.
Any help?
andy
------------------------------
Date: Sat, 12 Aug 2000 19:08:52 +0200
From: "Elmar Nubbemeyer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: AW: <cfudate> and missing table
Message-ID: <E1FA5D2E9030D4119E670048544B8A161E04@ZEUS>
when using oracle and cfinsert or cfupdate, you have to capitalize the
Tablenames, otherwise it won't work---
i it's not recommendable to use cfinsert or cfupdate when the db is oracle,
because they are about ten times slower then an cfquery tag with update and
insert instructions (al least on CFAS 4.0)
elmar
-----Urspr*ngliche Nachricht-----
Von: Trusz, Andrew [mailto:[EMAIL PROTECTED]]
Gesendet: Samstag, 12. August 2000 18:45
An: '[EMAIL PROTECTED]'
Betreff: <cfudate> and missing table
Hello,
Having trouble with <CFUPDATE>. The table being updated is not found in the
datasource even though the data to be updated has just been extracted from
that table. Database is Oracle 8
Tag is <cfupdate datasource="billygoat" tablename="main_table">.
Any help?
andy
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body
------------------------------
Date: Sat, 12 Aug 2000 10:35:24 -0700
From: PC <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Version 4.5.1 memory leak fixed?
Message-ID: <00f701c00483$b2a2e260$[EMAIL PROTECTED]>
Is this a stable platform yet?
------------------------------
Date: Sat, 12 Aug 2000 13:22:56 -0400
From: "Bill Killillay" <[EMAIL PROTECTED]>
To: "FuseBox List" <[EMAIL PROTECTED]>,
"Cf-Talk" <[EMAIL PROTECTED]>
Subject: Fusebox conference...
Message-ID: <000001c00481$f48011a0$0200a8c0@bill>
I am planning on going to the upcoming Fusebox Conference 2000 being put on
by Steve Nelson and I was wondering if anybody in Southern Tennessee or GA
is planning on driving up that way and would be interested in car pooling up
that way. I live in Chattanooga and am planning on driving up Friday
afternoon. The date is 16th of September for the conference. If your
planning on going and are interested, please feel free to call me. Thanks.
Bill Killillay
Senior Web Developer
Allaire Cold Fusion Consulting Partner
http://www.allaire.com/Partners/Partners.cfm?PartnerID=7561
phone ----- 888-306-4590
alt phone - 423-876-7330
fax ------- 423-876-7334
email ----- [EMAIL PROTECTED]
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
"Opportunities are usually disguised as hard work,
so most people don't recognize them"
-Ann Landers-
"An investment in Knowledge always pays the best interest."
-Benjamin Franklin-
"A product's only late once, but it can suck forever."
-Ben Spees, Ambrosia Software-
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
------------------------------
Date: Sat, 12 Aug 2000 10:54:16 -0700
From: PC <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: ValueList Question ...
Message-ID: <011701c00486$55513cd0$[EMAIL PROTECTED]>
I am a little unsure of the way this function works ... does it result in a
comma delimited string purely?
eg., if I alter a column from a query like
<cfset emailto = valuelist(#member.email#)>
Assuming there are say 5 email addresses in this result/email column...
could I use #emailto# in the "To:" field of a <CFMAIL> email as is?
Would it look like "[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], etc.?
TIA
------------------------------
Date: Sat, 12 Aug 2000 13:50:48 -0400
From: Zachary Bedell <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE: Version 4.5.1 memory leak fixed?
Message-ID: <[EMAIL PROTECTED]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
It wasn't for us... We went back to 4.0.1... YMMV, tho..
Best regards,
Zac Bedell
> -----Original Message-----
> From: PC [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 12, 2000 1:35 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Version 4.5.1 memory leak fixed?
>
>
> Is this a stable platform yet?
>
> --------------------------------------------------------------
> ----------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
Comment: Please use PGP!!!
iQA/AwUBOZWOeAraVoMWBwRBEQL2qQCg0t/f+rggAxTvB5O19vRej1RCp3QAnjxt
31TIq2rnZndurSg0jjWj2mQH
=1sDh
-----END PGP SIGNATURE-----
------------------------------
Date: Sat, 12 Aug 2000 14:20:39 -0400
From: "Ken Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Version 4.5.1 memory leak fixed?
Message-ID: <001b01c0048a$05666b10$[EMAIL PROTECTED]>
Works great for me.
Ken Wilson
----- Original Message -----
From: PC <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 1:35 PM
Subject: Version 4.5.1 memory leak fixed?
> Is this a stable platform yet?
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sat, 12 Aug 2000 14:28:52 -0400
From: Peter Theobald <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], <[EMAIL PROTECTED]>
Subject: Re: Version 4.5.1 memory leak fixed?
Message-ID: <[EMAIL PROTECTED]>
<html>
<font size=3>On the Allaire support forum I think everyone reached a
consensus that Windows-NT can handle the resource memory leak better.
Cold Fusion Studio 4.5 crashes Windows-98 very quickly.<br>
<br>
At 02:20 PM 8/12/00 -0400, Ken Wilson wrote:<br>
<blockquote type=cite cite>Works great for me.<br>
<br>
Ken Wilson<br>
<br>
<br>
<br>
----- Original Message -----<br>
From: PC <[EMAIL PROTECTED]><br>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]><br>
Sent: Saturday, August 12, 2000 1:35 PM<br>
Subject: Version 4.5.1 memory leak fixed?<br>
<br>
<br>
> Is this a stable platform yet?<br>
><br>
>
--------------------------------------------------------------------------<br>
----<br>
> Archives:
<a href="http://www.mail-archive.com/[email protected]/"
eudora="autourl">http://www.mail-archive.com/[email protected]/</a><br>
> To Unsubscribe visit<br>
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or<br>
send a message to [EMAIL PROTECTED] with 'unsubscribe' in<br>
the body.<br>
<br>
------------------------------------------------------------------------------<br>
Archives: <a href="http://www.mail-archive.com/[email protected]/"
eudora="autourl">http://www.mail-archive.com/[email protected]/</a><br>
To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body. </font></blockquote><br>
<br>
-<font
size=3>--------------------------------------------------------------------------<br>
Peter Theobald, Chief Technology Officer<br>
LiquidStreaming <a href="http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com</a><br>
[EMAIL PROTECTED]<br>
Phone 1.212.545.1232 Fax 1.212.679.8032<br>
</font></html>
------------------------------
Date: Sat, 12 Aug 2000 14:35:22 -0400
From: "Jason Aden" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: ValueList Question ...
Message-ID: <[EMAIL PROTECTED]>
That is correct, except no spaces after the commas. You also have
quotedValueList() which will give you the same list but with single quotes
around it.
hth,
Jason
Web Application Developer
webworld studios, inc.
-----Original Message-----
From: PC [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 12, 2000 1:54 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: ValueList Question ...
I am a little unsure of the way this function works ... does it result in a
comma delimited string purely?
eg., if I alter a column from a query like
<cfset emailto = valuelist(#member.email#)>
Assuming there are say 5 email addresses in this result/email column...
could I use #emailto# in the "To:" field of a <CFMAIL> email as is?
Would it look like "[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], etc.?
TIA
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sat, 12 Aug 2000 11:39:10 -0700
From: "Ron Connelly" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Escape '&' in URL?
Message-ID: <3995375E.3314.1DB1B731@localhost>
Is there a way to escape the & character in a variable name being
passed in a URL? I am creating all the links manually on the
submit (menu) page, and so could easily type in the escape
character in the link.
Thanks very much.
--
Ron Connelly
The Internet:Works
[EMAIL PROTECTED]
------------------------------
Date: Sat, 12 Aug 2000 14:48:08 -0400
From: "Jason Aden" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Escape '&' in URL?
Message-ID: <[EMAIL PROTECTED]>
Ron,
Use the URLEncodedFormat("string goes here") function. It'll transform all
special characters into a format that works for the URL. For instance, it'll
change the "&" to "%26".
Jason
Web Application Developer
webworld studios, inc.
-----Original Message-----
From: Ron Connelly [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 12, 2000 2:39 PM
To: [EMAIL PROTECTED]
Subject: Escape '&' in URL?
Is there a way to escape the & character in a variable name being
passed in a URL? I am creating all the links manually on the
submit (menu) page, and so could easily type in the escape
character in the link.
Thanks very much.
--
Ron Connelly
The Internet:Works
[EMAIL PROTECTED]
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sat, 12 Aug 2000 20:14:05 +0100
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: ValueList Question ...
Message-ID: <[EMAIL PROTECTED]>
> I am a little unsure of the way this function works ... does it
> result in a
> comma delimited string purely?
>
> eg., if I alter a column from a query like
>
> <cfset emailto = valuelist(#member.email#)>
>
> Assuming there are say 5 email addresses in this result/email column...
> could I use #emailto# in the "To:" field of a <CFMAIL> email as is?
>
> Would it look like "[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], etc.?
Yes and (very slightly) no
A ValueList does make a comma separates list, and in CFMail it will appear
as the list of emails, but without the space after the commas
Also, some SMTP servers don't like commas between emails, so you should put
semi-colons instead
Now, under CF4 (not sure about CF4.5) you could only send a CFMail to 40
recipients, also, you usually don't want everybody knowing who else got the
email, so I would say to loop through the query and send an individual email
to each person singly - more stress for the email server, but you're
guaranteed that it'll hit everyone and without them knowing the rest of the
list
Hope this answers
Philip Arnold
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.
**********************************************************************
------------------------------
Date: Sat, 12 Aug 2000 12:28:34 -0700
From: Dan Haley <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: Version 4.5.1 memory leak fixed?
Message-ID: <[EMAIL PROTECTED]>
Ken,
What platform and OS are you on? We have 4.5 and I'm wondering whether to
up to 4.5.1 or not. We are on NT 4.0 SP5 with plans to go to Windows 2000
soon. I haven't researched the benefits yet, I've just seen lots of people
complain about it on here.
Thanks,
Dan
-----Original Message-----
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 12, 2000 11:21 AM
To: [EMAIL PROTECTED]
Subject: Re: Version 4.5.1 memory leak fixed?
Works great for me.
Ken Wilson
----- Original Message -----
From: PC <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 1:35 PM
Subject: Version 4.5.1 memory leak fixed?
> Is this a stable platform yet?
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sat, 12 Aug 2000 15:36:53 -0400
From: "Ken Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Version 4.5.1 memory leak fixed?
Message-ID: <002b01c00494$ab2455d0$[EMAIL PROTECTED]>
We're using a mix of NT4 SP5 and Win2000, in each case running CF Server
v4.5.1
Ken
> What platform and OS are you on? We have 4.5 and I'm wondering whether to
> up to 4.5.1 or not. We are on NT 4.0 SP5 with plans to go to Windows 2000
> soon. I haven't researched the benefits yet, I've just seen lots of
people
> complain about it on here.
>
> Thanks,
> Dan
>
> -----Original Message-----
> From: Ken Wilson [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 12, 2000 11:21 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Version 4.5.1 memory leak fixed?
>
>
> Works great for me.
>
> Ken Wilson
>
>
>
> ----- Original Message -----
> From: PC <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, August 12, 2000 1:35 PM
> Subject: Version 4.5.1 memory leak fixed?
>
>
> > Is this a stable platform yet?
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sat, 12 Aug 2000 12:46:50 -0700
From: "Mooner Ent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: CFCache and newtork drives?
Message-ID: <002b01c00496$0ee618a0$7b1610cf@desktop>
In the CFCache tag you can specify "cache directory", ie. c:\my
docs\cftemp\.
I'm on the road and don't a have a shared or networked hard drive near me.
That in conjunction with a nightmare I had last night is making me nervous.
I dreamt I couldn't use a file server to serve up cached cfm files!
In addition, in a load balanced in environment, I want to make sure all the
servers share the same cfcache mapping file.
Would someone in the list confirm for me that the cfcache tag will access a
shared/networked drive?
Your insights are greatly appreciated. TIA
Rick
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
------------------------------
Date: Sat, 12 Aug 2000 14:45:28 -0500
From: sebastian palmigiani <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Other ways to skin the cat?
Message-ID: <[EMAIL PROTECTED]>
I have stored a query result into an application variable. I then want to be
able to filter just one record from it. The only way I have been able to do
this is by using a query loop and then passing it the CurrentRow variable
from the query record set and using it for both the "startrow" and the
"endrow" in the query loop. Are there other ways to do it?
<cfloop query="Application.Books" startrow="#URL.CurrentRow#"
endrow="#URL.CurrentRow#">
<cfoutput>
Title: #Title#<br>
Author: #AuthorLastName#
</cfoutput>
</cfloop>
Sebastian
------------------------------
Date: Sat, 12 Aug 2000 15:56:19 -0400
From: "Fred T. Sanders" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: ValueList Question ...
Message-ID: <006f01c00497$61dfbec0$1b130cd8@FRED>
You can change the delimiters to whatever you want to, but yeah it defaults
to comma's
#valuelist(queryname.columnName,"||")#
would give you:"[EMAIL PROTECTED]||[EMAIL PROTECTED]||[EMAIL PROTECTED]||etc.
#valuelist(queryname.columnName,",")# or #valuelist(queryname.columnName)#
would give you:"[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],etc.
#valuelist(queryname.columnName,"/")#
would give you:"[EMAIL PROTECTED][EMAIL PROTECTED][EMAIL PROTECTED]/etc.
----- Original Message -----
From: "PC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 1:54 PM
Subject: ValueList Question ...
> I am a little unsure of the way this function works ... does it result in
a
> comma delimited string purely?
>
> eg., if I alter a column from a query like
>
> <cfset emailto = valuelist(#member.email#)>
>
> Assuming there are say 5 email addresses in this result/email column...
> could I use #emailto# in the "To:" field of a <CFMAIL> email as is?
>
> Would it look like "[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], etc.?
>
> TIA
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
Date: Sat, 12 Aug 2000 13:03:12 -0700
From: "Jordan Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Optimization tips collection
Message-ID: <02df01c00498$5872c2f0$4829e8d8@lightning>
I would argue about a few of your suggestions,
First don't use compare() instead of <cfif foo IS 'bar'> since compare is
case sensitive
You can not do <cftag name="foo"> value=#var#> on any type of strings
Always avoid IIF() because it is up to 4x slower then <cfif> even if it is
nested
Don't lock the request scope, because it is thread safe by design!
Lock application, session, & server scopes
Take Care,
Jordan Clark
----- Original Message -----
From: "Ed Toon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 10, 2000 5:47 AM
Subject: Optimization tips collection
> Hey folks,
>
> Seeing as I was finally forced to change from digest to immediate (damnit
;)
> I thought I'd send out another request for more optimization tips. I'm
> mostly looking for Cold Fusion tips... Things like NT & SQL Server configs
> would only serve to scare me. Although... I wonder if anyone ever made a
> list of things that were wrong with 4.0.1 on Solaris and how to fix
them...
> Anyways, here's my current list of CF knowledge that I force pitiful
> underlings to obey. Hopefully we'll get some kind of compilation going.
>
> Ed Toon.
>
> -----------------------
>
> Use cfscript wherever possible, for as long as possible
>
> Boolean evaluation wherever possible
>
> Scope all the variables that you can
>
> Use cfmodule instead of short hand annotation for custom tags
>
> Use cfinclude instead of cfmodule wherever possible
>
> Use cfquery's instead of cfinserts, etc.
>
> Cache queries that seldom change and are universal to all users of the
site
>
> Use stored procedures for non-cacheable queries
>
> Make sure your queries are return only what you need
>
> Always name rows in queries, instead of select *
>
> <cfset #x# = "#Func(y)#"> is bad
> <cfset x = Func(y)> is good
> <cfscript>x = Func(y);</cfscript> is spiffy keen
>
> Ise functions instead of operators wherever possible, e.g. Find/FindNoCase
> instead of CONTAINS, CompareNoCase instead of "var is 'whatever'
>
> CFHTTP resolveUrl=yes does DNS lookups -- slow
>
> Locale functions (LSFunc) are slower than English-only functions
>
> Cache queries with the same return every time
>
> Prepublish pages that are the same every time
>
> <cftag name="foo" value="#var#"> is slower than <cftag name="foo"
> value=#var#>
>
> Use cfswitch instead of cfif
>
> Use IIF to avoid deeply nested if statements. Avoid IIF otherwise
>
> Structures are referenced, but arrays are copied, so if you're using large
> arrays and you try to do something like LocalCustomerArray =
> DataStore.CustomerArrays[CustomerID] you'll end up copying the entire
array,
> which is ok if you just want the data, but is never gonna change the
> DataStore unless you do DataStore.CustomerArrays[CustomerID] =
> LocalCustomerArray again. think twice before copying big arrays
>
> Arrays are dynamic (and they start at 1!)... thus you can't count on
> myArray[15] continuing to be myArray[15] for very long.
>
> CFLOCK all references to Session variables
>
> CFLOCK all references to Application, Server and Request variables that
> might be altered
> over the life of the [Application,Server,Request]
>
> Consider using <cfsetting enablecfoutputonly="yes"> or automatic
whitespace
> reduction to reduce overall page size. cfsetting is faster if it's only
done
> a few times, but if it ends up getting set fifty times in the course of
> processing one request, you probably want automatic reduction
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sat, 12 Aug 2000 15:03:47 -0600
From: "Darren Labrum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: CF_Newbie
Message-ID: <000801c004a0$cf736aa0$6eac0ed0@vaio>
This is a multi-part message in MIME format.
------=_NextPart_000_0005_01C0046E.83F72620
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello there,
I have a question that I think will be answered really fast from all of =
you advanced developers. I am having problems populating a pull down =
menu. For some reason it will repeat records in the pull down menu. =
For example, here is a sample of a simple little code I did:
<select name=3D"Cuisine">
<cfoutput query=3D"guide">
<option value=3D"#CuisineID#">#Cuisine#
</cfoutput> =20
</select>
Now correct me if I am wrong but is that context look correct?
The way this will get displayed is like this:
(the pull down menu will look like this)
Idaho Falls
Idaho Falls
Boise
Boise
Twin Falls
Twin Falls
They repeat and I don't understand why is does that? I only have three =
towns in the database (Idaho Falls, Boise, and Twin Falls)
Yes, I do have the query at the top of the page correct also. =20
Any thoughts from the Cold Fusion Guru's of the group?
Thanks,
Darren
------=_NextPart_000_0005_01C0046E.83F72620
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello there,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a question that I think will be =
answered=20
really fast from all of you advanced developers. I am having =
problems=20
populating a pull down menu. For some reason it will repeat =
records in the=20
pull down menu. For example, here is a sample of a simple =
little code=20
I did:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2> <select=20
name=3D"Cuisine"><BR> <cfoutput =
query=3D"guide"><BR> <option=20
value=3D"#CuisineID#">#Cuisine#<BR> </cfoutput> =
<BR> </select></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Now correct me if I am wrong but is =
that context=20
look correct?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>The way this will get displayed is like =
this:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>(the pull down menu will look like=20
this)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Idaho Falls</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Idaho Falls</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Boise</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Boise</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Twin Falls</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Twin Falls</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>They repeat and I don't understand why =
is does=20
that? I only have three towns in the database (Idaho Falls, Boise, =
and=20
Twin Falls)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Yes, I do have the query at the top of =
the page=20
correct also. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Any thoughts from the Cold Fusion =
Guru's of the=20
group?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Darren</FONT></DIV></BODY></HTML>
------=_NextPart_000_0005_01C0046E.83F72620--
------------------------------
Date: Sat, 12 Aug 2000 14:07:23 -0700
From: "Ron Connelly" <[EMAIL PROTECTED]>
To: "Jason Aden" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: Escape '&' in URL?
Message-ID: <39955A1B.30209.1E396C84@localhost>
Great! Thanks Jason. One more question:
If I have a target specified in that URL, where does it go; After the
template called and before the '?', or at the very end??
Thanks again.
On 12 Aug 2000, at 14:48, Jason Aden wrote:
> Ron,
>
> Use the URLEncodedFormat("string goes here") function. It'll transform all
> special characters into a format that works for the URL. For instance, it'll
> change the "&" to "%26".
>
> Jason
> Web Application Developer
> webworld studios, inc.
>
> -----Original Message-----
> From: Ron Connelly [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 12, 2000 2:39 PM
> To: [EMAIL PROTECTED]
> Subject: Escape '&' in URL?
>
>
> Is there a way to escape the & character in a variable name being
> passed in a URL? I am creating all the links manually on the
> submit (menu) page, and so could easily type in the escape
> character in the link.
>
> Thanks very much.
>
>
> --
>
> Ron Connelly
> The Internet:Works
> [EMAIL PROTECTED]
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or s
end a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
--
Ron Connelly
The Internet:Works
[EMAIL PROTECTED]
------------------------------
Date: Sat, 12 Aug 2000 17:12:45 -0400
From: Frank Priest <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: CF_Newbie
Message-ID: <[EMAIL PROTECTED]>
The problem is in your query Darren,
You need to
SELECT DISTINCT CuisineID, Cuisine
Frank
At 03:03 PM 8/12/2000 -0600, you wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0005_01C0046E.83F72620
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Hello there,
>
>I have a question that I think will be answered really fast from all of =
>you advanced developers. I am having problems populating a pull down =
>menu. For some reason it will repeat records in the pull down menu. =
>For example, here is a sample of a simple little code I did:
>
> <select name=3D"Cuisine">
> <cfoutput query=3D"guide">
> <option value=3D"#CuisineID#">#Cuisine#
> </cfoutput> =20
> </select>
>
>Now correct me if I am wrong but is that context look correct?
>
>The way this will get displayed is like this:
>
>(the pull down menu will look like this)
>
>Idaho Falls
>Idaho Falls
>Boise
>Boise
>Twin Falls
>Twin Falls
>
>They repeat and I don't understand why is does that? I only have three =
>towns in the database (Idaho Falls, Boise, and Twin Falls)
>
>Yes, I do have the query at the top of the page correct also. =20
>
>Any thoughts from the Cold Fusion Guru's of the group?
>
>Thanks,
>
>Darren
>
>------=_NextPart_000_0005_01C0046E.83F72620
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>Hello there,
>
>I have a question that I think will be = answered=20 really fast from all
>of you advanced developers. I am having = problems=20 populating a pull
>down menu. For some reason it will repeat = records in the=20 pull down
>menu. For example, here is a sample of a simple = little code=20 I did:
>
> <select=20 name=3D"Cuisine">
> <cfoutput = query=3D"guide">
> <option=20 value=3D"#CuisineID#">#Cuisine#
> </cfoutput> =
> </select>
>
>Now correct me if I am wrong but is = that context=20 look correct?
>
>The way this will get displayed is like = this:
>
>(the pull down menu will look like=20 this)
>
>Idaho Falls
>Idaho Falls
>Boise
>Boise
>Twin Falls
>Twin Falls
>
>They repeat and I don't understand why = is does=20 that? I only have
>three towns in the database (Idaho Falls, Boise, = and=20 Twin Falls)
>
>Yes, I do have the query at the top of = the page=20 correct also.
>
>Any thoughts from the Cold Fusion = Guru's of the=20 group?
>
>Thanks,
>
>Darren
>
>------=_NextPart_000_0005_01C0046E.83F72620--
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------
Date: Sat, 12 Aug 2000 15:24:12 -0600
From: "Darren Labrum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: CF_Newbie
Message-ID: <001301c004a3$a9c64ea0$51ac0ed0@vaio>
Hi there,
Frank, thanks for the response. I put in SELECT DISTINCT in my query but I
still get repeating records when I populate the drop down menu.
I just can't determine what is going on here.
Thanks,
Darren
----- Original Message -----
From: Frank Priest <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 3:12 PM
Subject: Re: CF_Newbie
> The problem is in your query Darren,
> You need to
>
> SELECT DISTINCT CuisineID, Cuisine
>
> Frank
>
>
>
> At 03:03 PM 8/12/2000 -0600, you wrote:
> >This is a multi-part message in MIME format.
> >
> >------=_NextPart_000_0005_01C0046E.83F72620
> >Content-Type: text/plain;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: quoted-printable
> >
> >Hello there,
> >
> >I have a question that I think will be answered really fast from all of =
> >you advanced developers. I am having problems populating a pull down =
> >menu. For some reason it will repeat records in the pull down menu. =
> >For example, here is a sample of a simple little code I did:
> >
> > <select name=3D"Cuisine">
> > <cfoutput query=3D"guide">
> > <option value=3D"#CuisineID#">#Cuisine#
> > </cfoutput> =20
> > </select>
> >
> >Now correct me if I am wrong but is that context look correct?
> >
> >The way this will get displayed is like this:
> >
> >(the pull down menu will look like this)
> >
> >Idaho Falls
> >Idaho Falls
> >Boise
> >Boise
> >Twin Falls
> >Twin Falls
> >
> >They repeat and I don't understand why is does that? I only have three =
> >towns in the database (Idaho Falls, Boise, and Twin Falls)
> >
> >Yes, I do have the query at the top of the page correct also. =20
> >
> >Any thoughts from the Cold Fusion Guru's of the group?
> >
> >Thanks,
> >
> >Darren
> >
> >------=_NextPart_000_0005_01C0046E.83F72620
> >Content-Type: text/html;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: quoted-printable
> >
> ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> >Hello there,
> >
> >I have a question that I think will be = answered=20 really fast from all
> >of you advanced developers. I am having = problems=20 populating a pull
> >down menu. For some reason it will repeat = records in the=20 pull down
> >menu. For example, here is a sample of a simple = little code=20 I did:
> >
> > <select=20 name=3D"Cuisine">
> > <cfoutput = query=3D"guide">
> > <option=20 value=3D"#CuisineID#">#Cuisine#
> > </cfoutput> =
> > </select>
> >
> >Now correct me if I am wrong but is = that context=20 look correct?
> >
> >The way this will get displayed is like = this:
> >
> >(the pull down menu will look like=20 this)
> >
> >Idaho Falls
> >Idaho Falls
> >Boise
> >Boise
> >Twin Falls
> >Twin Falls
> >
> >They repeat and I don't understand why = is does=20 that? I only have
> >three towns in the database (Idaho Falls, Boise, = and=20 Twin Falls)
> >
> >Yes, I do have the query at the top of = the page=20 correct also.
> >
> >Any thoughts from the Cold Fusion = Guru's of the=20 group?
> >
> >Thanks,
> >
> >Darren
> >
> >------=_NextPart_000_0005_01C0046E.83F72620--
> >
>
>---------------------------------------------------------------------------
---
> >Archives: http://www.mail-archive.com/[email protected]/
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
Date: Sat, 12 Aug 2000 17:33:30 -0400
From: Frank Priest <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: CF_Newbie
Message-ID: <[EMAIL PROTECTED]>
Do you have "Idaho Falls" in there with two id's?
Try
<cfoutput query="guide" group="Cuisine">
or let's see your query
At 03:24 PM 8/12/2000 -0600, you wrote:
------------------------------
Date: Sat, 12 Aug 2000 14:30:36 -0700
From: "David Green" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: CF_Newbie
Message-ID: <001c01c004a4$8e9745c0$[EMAIL PROTECTED]>
Am new CF to but I would try to switch that CFOUTPUT to a CFLOOP. Maybe the
output is doing it twice since the variable it in the cfoutput twice. Here
is copy of some code I did.
Good Luck
<cfselect name="LNI_STO" size="6" multiple>
<option value="ALL" selected>All Sub SER's</option>
<option value="'Unassigned'">Unassigned</options>
<cfloop query="LIST_STO" >
<OPTION
value="'<cfoutput>#list_STO.C_STO#</cfoutput>'"><cfoutput>#LIST_STO.C_STO#</
cfoutput></option>
</cfloop>
</cfselect>
----- Original Message -----
From: "Darren Labrum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 2:24 PM
Subject: Re: CF_Newbie
> Hi there,
>
> Frank, thanks for the response. I put in SELECT DISTINCT in my query but
I
> still get repeating records when I populate the drop down menu.
>
> I just can't determine what is going on here.
>
> Thanks,
>
> Darren
> ----- Original Message -----
> From: Frank Priest <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, August 12, 2000 3:12 PM
> Subject: Re: CF_Newbie
>
>
> > The problem is in your query Darren,
> > You need to
> >
> > SELECT DISTINCT CuisineID, Cuisine
> >
> > Frank
> >
> >
> >
> > At 03:03 PM 8/12/2000 -0600, you wrote:
> > >This is a multi-part message in MIME format.
> > >
> > >------=_NextPart_000_0005_01C0046E.83F72620
> > >Content-Type: text/plain;
> > > charset="iso-8859-1"
> > >Content-Transfer-Encoding: quoted-printable
> > >
> > >Hello there,
> > >
> > >I have a question that I think will be answered really fast from all of
=
> > >you advanced developers. I am having problems populating a pull down =
> > >menu. For some reason it will repeat records in the pull down menu. =
> > >For example, here is a sample of a simple little code I did:
> > >
> > > <select name=3D"Cuisine">
> > > <cfoutput query=3D"guide">
> > > <option value=3D"#CuisineID#">#Cuisine#
> > > </cfoutput> =20
> > > </select>
> > >
> > >Now correct me if I am wrong but is that context look correct?
> > >
> > >The way this will get displayed is like this:
> > >
> > >(the pull down menu will look like this)
> > >
> > >Idaho Falls
> > >Idaho Falls
> > >Boise
> > >Boise
> > >Twin Falls
> > >Twin Falls
> > >
> > >They repeat and I don't understand why is does that? I only have three
=
> > >towns in the database (Idaho Falls, Boise, and Twin Falls)
> > >
> > >Yes, I do have the query at the top of the page correct also. =20
> > >
> > >Any thoughts from the Cold Fusion Guru's of the group?
> > >
> > >Thanks,
> > >
> > >Darren
> > >
> > >------=_NextPart_000_0005_01C0046E.83F72620
> > >Content-Type: text/html;
> > > charset="iso-8859-1"
> > >Content-Transfer-Encoding: quoted-printable
> > >
> > ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > >Hello there,
> > >
> > >I have a question that I think will be = answered=20 really fast from
all
> > >of you advanced developers. I am having = problems=20 populating a
pull
> > >down menu. For some reason it will repeat = records in the=20 pull
down
> > >menu. For example, here is a sample of a simple = little code=20 I
did:
> > >
> > > <select=20 name=3D"Cuisine">
> > > <cfoutput = query=3D"guide">
> > > <option=20 value=3D"#CuisineID#">#Cuisine#
> > > </cfoutput> =
> > > </select>
> > >
> > >Now correct me if I am wrong but is = that context=20 look correct?
> > >
> > >The way this will get displayed is like = this:
> > >
> > >(the pull down menu will look like=20 this)
> > >
> > >Idaho Falls
> > >Idaho Falls
> > >Boise
> > >Boise
> > >Twin Falls
> > >Twin Falls
> > >
> > >They repeat and I don't understand why = is does=20 that? I only have
> > >three towns in the database (Idaho Falls, Boise, = and=20 Twin Falls)
> > >
> > >Yes, I do have the query at the top of = the page=20 correct also.
> > >
> > >Any thoughts from the Cold Fusion = Guru's of the=20 group?
> > >
> > >Thanks,
> > >
> > >Darren
> > >
> > >------=_NextPart_000_0005_01C0046E.83F72620--
> > >
> >
>
>---------------------------------------------------------------------------
> ---
> > >Archives: http://www.mail-archive.com/[email protected]/
> > >To Unsubscribe visit
> > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > >send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > >the body.
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sat, 12 Aug 2000 17:59:36 -0400
From: "Duane Boudreau" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: CF_Newbie
Message-ID: <[EMAIL PROTECTED]>
> Hello there,
>
> I have a question that I think will be answered really fast from all of =
> you advanced developers. I am having problems populating a pull down =
> menu. For some reason it will repeat records in the pull down menu. =
> For example, here is a sample of a simple little code I did:
>
> <select name=3D"Cuisine">
> <cfoutput query=3D"guide">
> <option value=3D"#CuisineID#">#Cuisine#
> </cfoutput> =20
> </select>
>
> Now correct me if I am wrong but is that context look correct?
>
> The way this will get displayed is like this:
>
> (the pull down menu will look like this)
>
> Idaho Falls
> Idaho Falls
> Boise
> Boise
> Twin Falls
> Twin Falls
Are you running a relational query? That is are you grabbing data from two
tables?
If so you need to do something like this to remove dupliucates:
SELECT CuisineTable.CuisineID, CuisineTable.Cuisine
FROM CuisineTable, Restaurants
WHERE CuisineTable.CuisineID = Restaurants.CuisineID
Try sending your query to the list.
HTH,
Duane Boudreau
Director, Web Technologies
Ektron, Inc.
------------------------------
Date: Sat, 12 Aug 2000 15:06:31 -0700
From: [EMAIL PROTECTED] (paul smith)
To: [EMAIL PROTECTED]
Subject: Re: CF_Newbie
Message-ID: <[EMAIL PROTECTED]>
Are you using Access97?
If so, it implements a non-standard "Distinct"
It finds a distinct ROW when you specify more
than one column.
So to get distinct CITIES you need to filter your query,
or select City ONLY to populate your drop-down a la:
SELECT Distinct City
best, paul
(If I remember a right from when I went 'round & 'round
with Access a while ago)
At 03:03 PM 8/12/00 -0600, you wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0005_01C0046E.83F72620
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Hello there,
>
>I have a question that I think will be answered really fast from all of =
>you advanced developers. I am having problems populating a pull down =
>menu. For some reason it will repeat records in the pull down menu. =
>For example, here is a sample of a simple little code I did:
>
> <select name=3D"Cuisine">
> <cfoutput query=3D"guide">
> <option value=3D"#CuisineID#">#Cuisine#
> </cfoutput> =20
> </select>
>
>Now correct me if I am wrong but is that context look correct?
>
>The way this will get displayed is like this:
>
>(the pull down menu will look like this)
>
>Idaho Falls
>Idaho Falls
>Boise
>Boise
>Twin Falls
>Twin Falls
>
>They repeat and I don't understand why is does that? I only have three =
>towns in the database (Idaho Falls, Boise, and Twin Falls)
>
>Yes, I do have the query at the top of the page correct also. =20
>
>Any thoughts from the Cold Fusion Guru's of the group?
>
>Thanks,
>
>Darren
>
>------=_NextPart_000_0005_01C0046E.83F72620
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>Hello there,
>
>I have a question that I think will be = answered=20 really fast from all
>of you advanced developers. I am having = problems=20 populating a pull
>down menu. For some reason it will repeat = records in the=20 pull down
>menu. For example, here is a sample of a simple = little code=20 I did:
>
> <select=20 name=3D"Cuisine">
> <cfoutput = query=3D"guide">
> <option=20 value=3D"#CuisineID#">#Cuisine#
> </cfoutput> =
> </select>
>
>Now correct me if I am wrong but is = that context=20 look correct?
>
>The way this will get displayed is like = this:
>
>(the pull down menu will look like=20 this)
>
>Idaho Falls
>Idaho Falls
>Boise
>Boise
>Twin Falls
>Twin Falls
>
>They repeat and I don't understand why = is does=20 that? I only have
>three towns in the database (Idaho Falls, Boise, = and=20 Twin Falls)
>
>Yes, I do have the query at the top of = the page=20 correct also.
>
>Any thoughts from the Cold Fusion = Guru's of the=20 group?
>
>Thanks,
>
>Darren
>
>------=_NextPart_000_0005_01C0046E.83F72620--
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------
Date: Sat, 12 Aug 2000 16:08:10 -0600
From: "Darren Labrum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: CF_Newbie
Message-ID: <001f01c004a9$cda1efe0$9aac0ed0@vaio>
Hey Paul,
Actually I am using Access 2000. Is there anything that you know I should
be aware of using this database?
Thanks,
Darren
----- Original Message -----
From: paul smith <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 4:06 PM
Subject: Re: CF_Newbie
> Are you using Access97?
>
> If so, it implements a non-standard "Distinct"
> It finds a distinct ROW when you specify more
> than one column.
>
> So to get distinct CITIES you need to filter your query,
> or select City ONLY to populate your drop-down a la:
>
> SELECT Distinct City
>
> best, paul
>
> (If I remember a right from when I went 'round & 'round
> with Access a while ago)
>
> At 03:03 PM 8/12/00 -0600, you wrote:
> >This is a multi-part message in MIME format.
> >
> >------=_NextPart_000_0005_01C0046E.83F72620
> >Content-Type: text/plain;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: quoted-printable
> >
> >Hello there,
> >
> >I have a question that I think will be answered really fast from all of =
> >you advanced developers. I am having problems populating a pull down =
> >menu. For some reason it will repeat records in the pull down menu. =
> >For example, here is a sample of a simple little code I did:
> >
> > <select name=3D"Cuisine">
> > <cfoutput query=3D"guide">
> > <option value=3D"#CuisineID#">#Cuisine#
> > </cfoutput> =20
> > </select>
> >
> >Now correct me if I am wrong but is that context look correct?
> >
> >The way this will get displayed is like this:
> >
> >(the pull down menu will look like this)
> >
> >Idaho Falls
> >Idaho Falls
> >Boise
> >Boise
> >Twin Falls
> >Twin Falls
> >
> >They repeat and I don't understand why is does that? I only have three =
> >towns in the database (Idaho Falls, Boise, and Twin Falls)
> >
> >Yes, I do have the query at the top of the page correct also. =20
> >
> >Any thoughts from the Cold Fusion Guru's of the group?
> >
> >Thanks,
> >
> >Darren
> >
> >------=_NextPart_000_0005_01C0046E.83F72620
> >Content-Type: text/html;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: quoted-printable
> >
> ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> >Hello there,
> >
> >I have a question that I think will be = answered=20 really fast from all
> >of you advanced developers. I am having = problems=20 populating a pull
> >down menu. For some reason it will repeat = records in the=20 pull down
> >menu. For example, here is a sample of a simple = little code=20 I did:
> >
> > <select=20 name=3D"Cuisine">
> > <cfoutput = query=3D"guide">
> > <option=20 value=3D"#CuisineID#">#Cuisine#
> > </cfoutput> =
> > </select>
> >
> >Now correct me if I am wrong but is = that context=20 look correct?
> >
> >The way this will get displayed is like = this:
> >
> >(the pull down menu will look like=20 this)
> >
> >Idaho Falls
> >Idaho Falls
> >Boise
> >Boise
> >Twin Falls
> >Twin Falls
> >
> >They repeat and I don't understand why = is does=20 that? I only have
> >three towns in the database (Idaho Falls, Boise, = and=20 Twin Falls)
> >
> >Yes, I do have the query at the top of = the page=20 correct also.
> >
> >Any thoughts from the Cold Fusion = Guru's of the=20 group?
> >
> >Thanks,
> >
> >Darren
> >
> >------=_NextPart_000_0005_01C0046E.83F72620--
> >
>
>---------------------------------------------------------------------------
---
> >Archives: http://www.mail-archive.com/[email protected]/
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
Date: Sat, 12 Aug 2000 16:13:35 -0600
From: "Darren Labrum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: CF_Newbie
Message-ID: <000501c004aa$8fff5280$9aac0ed0@vaio>
I tried to change the query around to this:
SELECT CityData.CityID, CityData.City, CuisineData.CuisineID,
CuisineData.Cuisine
FROM CityData, CuisineData
and I received two of each city again in my drop down menu.
Darren
----- Original Message -----
From: Darren Labrum <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 3:03 PM
Subject: CF_Newbie
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0005_01C0046E.83F72620
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hello there,
>
> I have a question that I think will be answered really fast from all of =
> you advanced developers. I am having problems populating a pull down =
> menu. For some reason it will repeat records in the pull down menu. =
> For example, here is a sample of a simple little code I did:
>
> <select name=3D"Cuisine">
> <cfoutput query=3D"guide">
> <option value=3D"#CuisineID#">#Cuisine#
> </cfoutput> =20
> </select>
>
> Now correct me if I am wrong but is that context look correct?
>
> The way this will get displayed is like this:
>
> (the pull down menu will look like this)
>
> Idaho Falls
> Idaho Falls
> Boise
> Boise
> Twin Falls
> Twin Falls
>
> They repeat and I don't understand why is does that? I only have three =
> towns in the database (Idaho Falls, Boise, and Twin Falls)
>
> Yes, I do have the query at the top of the page correct also. =20
>
> Any thoughts from the Cold Fusion Guru's of the group?
>
> Thanks,
>
> Darren
>
> ------=_NextPart_000_0005_01C0046E.83F72620
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Hello there,</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>I have a question that I think will be =
> answered=20
> really fast from all of you advanced developers. I am having =
> problems=20
> populating a pull down menu. For some reason it will repeat =
> records in the=20
> pull down menu. For example, here is a sample of a simple =
> little code=20
> I did:</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2> <select=20
> name=3D"Cuisine"><BR> <cfoutput =
> query=3D"guide"><BR> <option=20
> value=3D"#CuisineID#">#Cuisine#<BR> </cfoutput> =
> <BR> </select></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Now correct me if I am wrong but is =
> that context=20
> look correct?</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>The way this will get displayed is like =
>
> this:</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>(the pull down menu will look like=20
> this)</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Idaho Falls</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Idaho Falls</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Boise</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Boise</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Twin Falls</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Twin Falls</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>They repeat and I don't understand why =
> is does=20
> that? I only have three towns in the database (Idaho Falls, Boise, =
> and=20
> Twin Falls)</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Yes, I do have the query at the top of =
> the page=20
> correct also. </FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Any thoughts from the Cold Fusion =
> Guru's of the=20
> group?</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Darren</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0005_01C0046E.83F72620--
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
Date: Sat, 12 Aug 2000 15:23:53 -0700
From: "David Green" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: CF_Newbie
Message-ID: <00a501c004ab$ff21d560$[EMAIL PROTECTED]>
Like I said am new to this but doesn't there need to be a where or Join on
the two databases. I am guessing with this your getting records from both
databases not a single record of the two databases. If there is a key
between the two data bases I think you need a where statement if you don't
have keys between the two data bases maybe you need a subquery then in the
where statement link by city names. Just guessing
Good Luck
David
SELECT CityData.CityID, CityData.City, CuisineData.CuisineID,
CuisineData.Cuisine
FROM CityData, CuisineData
----- Original Message -----
From: "Darren Labrum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 3:13 PM
Subject: Re: CF_Newbie
> I tried to change the query around to this:
>
>
> SELECT CityData.CityID, CityData.City, CuisineData.CuisineID,
> CuisineData.Cuisine
> FROM CityData, CuisineData
>
> and I received two of each city again in my drop down menu.
>
> Darren
> ----- Original Message -----
> From: Darren Labrum <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, August 12, 2000 3:03 PM
> Subject: CF_Newbie
>
>
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_0005_01C0046E.83F72620
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hello there,
> >
> > I have a question that I think will be answered really fast from all of
=
> > you advanced developers. I am having problems populating a pull down =
> > menu. For some reason it will repeat records in the pull down menu. =
> > For example, here is a sample of a simple little code I did:
> >
> > <select name=3D"Cuisine">
> > <cfoutput query=3D"guide">
> > <option value=3D"#CuisineID#">#Cuisine#
> > </cfoutput> =20
> > </select>
> >
> > Now correct me if I am wrong but is that context look correct?
> >
> > The way this will get displayed is like this:
> >
> > (the pull down menu will look like this)
> >
> > Idaho Falls
> > Idaho Falls
> > Boise
> > Boise
> > Twin Falls
> > Twin Falls
> >
> > They repeat and I don't understand why is does that? I only have three
=
> > towns in the database (Idaho Falls, Boise, and Twin Falls)
> >
> > Yes, I do have the query at the top of the page correct also. =20
> >
> > Any thoughts from the Cold Fusion Guru's of the group?
> >
> > Thanks,
> >
> > Darren
> >
> > ------=_NextPart_000_0005_01C0046E.83F72620
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <HTML><HEAD>
> > <META content=3D"text/html; charset=3Diso-8859-1" =
> > http-equiv=3DContent-Type>
> > <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
> > <STYLE></STYLE>
> > </HEAD>
> > <BODY bgColor=3D#ffffff>
> > <DIV><FONT face=3DArial size=3D2>Hello there,</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>I have a question that I think will be
=
> > answered=20
> > really fast from all of you advanced developers. I am having =
> > problems=20
> > populating a pull down menu. For some reason it will repeat =
> > records in the=20
> > pull down menu. For example, here is a sample of a simple =
> > little code=20
> > I did:</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2> <select=20
> > name=3D"Cuisine"><BR> <cfoutput =
> > query=3D"guide"><BR> <option=20
> >
value=3D"#CuisineID#">#Cuisine#<BR> </cfoutput> =
> > <BR> </select></FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Now correct me if I am wrong but is =
> > that context=20
> > look correct?</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>The way this will get displayed is like
=
> >
> > this:</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>(the pull down menu will look like=20
> > this)</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Idaho Falls</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>Idaho Falls</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>Boise</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>Boise</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>Twin Falls</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>Twin Falls</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>They repeat and I don't understand why
=
> > is does=20
> > that? I only have three towns in the database (Idaho Falls, Boise,
=
> > and=20
> > Twin Falls)</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Yes, I do have the query at the top of
=
> > the page=20
> > correct also. </FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Any thoughts from the Cold Fusion =
> > Guru's of the=20
> > group?</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Darren</FONT></DIV></BODY></HTML>
> >
> > ------=_NextPart_000_0005_01C0046E.83F72620--
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sun, 13 Aug 2000 08:30:56 +1000
From: "Geoff Cook" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: test
Message-ID: <001901c004ac$fbca7790$6da72dcb@geoff>
This is a multi-part message in MIME format.
------=_NextPart_000_0016_01C00500.CD395780
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
test
------=_NextPart_000_0016_01C00500.CD395780
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>test</FONT></DIV></BODY></HTML>
------=_NextPart_000_0016_01C00500.CD395780--
------------------------------
Date: Sun, 13 Aug 2000 08:37:43 +1000
From: "Geoff Cook" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: TEST - I am trying to get rid of the 'mime' format in my messages
Message-ID: <006801c004ad$ee40eea0$6da72dcb@geoff>
test
------------------------------
Date: Sat, 12 Aug 2000 18:43:33 -0400
From: Frank Priest <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: CF_Newbie
Message-ID: <[EMAIL PROTECTED]>
Since the two tables don't seem to be related you should probably run two
separate queries
<cfquery name="query1" datasource="#dsn#">
SELECT DISTINCT
CuisineData.CuisineID,
CuisineData.Cuisine
FROM CuisineData
</cfquery>
<cfquery name="query2" datasource="#dsn#">
SELECT DISTINCT
CityData.CityID,
CityData.City
FROM CityData
</cfquery>
>SELECT CityData.CityID, CityData.City, CuisineData.CuisineID,
>CuisineData.Cuisine
>FROM CityData, CuisineData
>
>and I received two of each city again in my drop down menu.
>
>Darren
>----- Original Message -----
>From: Darren Labrum <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, August 12, 2000 3:03 PM
>Subject: CF_Newbie
>
------------------------------
Date: Sat, 12 Aug 2000 17:54:19 -0500
From: Russel Madere <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: TEST - I am trying to get rid of the 'mime' format in my
messages
Message-ID: <[EMAIL PROTECTED]>
It looks like it worked.
At 08:37 08.13.2000 +1000, you wrote:
>test
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------
Date: Sun, 13 Aug 2000 09:06:46 +1000
From: "Geoff Cook" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Updating a remote db from local csv file
Message-ID: <007801c004b1$fd2162c0$6da72dcb@geoff>
Hi everybody I am new to this list and looking forward to learning from your
posts.
I am new to ColdFusion so need lots of help. I would like to be able to
update/overwrite a table in a remote Access data base from a local csv or
excel file. It has been suggested that I use WDDX, does anyone have any
idea how this works.
I also have these two scripts which use an array but I have been unable to
make them work. Can anyone help?
----------------------------------------------------------------------------
---
<cffile action="read" file="c:\your\path\to\file.txt"
variable="theVariable">
<cfset delim=chr(13)>
<cfset delim2=",">
<cfloop index="x" from="1" to="#listlen(theVariable,delim)#">
<cfset value1 = listgetat(theVariable,x,delim2)>
<cfset value2 = listgetat(theVariable,(x + 1),delim2)>
<cfset value3 = listgetat(theVariable,(x + 2),delim2)>
<cfquery datasource="myDSN">
insert into myTable(value1,value2,value3)
values(#value1#,'#value2#',#value3#)
</cfquery>
</cfloop>
----------------------------------------------------------------------------
-------
<!-- Loading CSV file into array -->
<cfoutput>
<cffile action="read" file="#file#" variable="csv">
<cfset #csv# = #Replace(csv,chr(13),"#delim#","all")#>
<cfset #csv# = #Replace(csv,chr(10),"","all")#>
<cfset csvdata = ArrayNew(2)>
<cfset arraysize = 1>
<cfset counter = #Find("#delim#",#csv#,1)#>
<cfloop condition="#counter# GT 0">
<cfloop index="y" from = "1" to = "#fieldnum#">
<cfif #counter# EQ 1>
<cfset csvdata[#arraysize#][#y#] = "">
<cfelseif #counter# GT 1>
<cfset csvdata[#arraysize#][#y#] =
#Left(csv,(counter-1))#>
</cfif>
<cfif #Len(csv)# GT 0>
<cfset #csv# = #RemoveChars(csv,1,counter)#>
</cfif>
<cfset counter = #Find("#delim#",csv,1)#>
</cfloop>
<cfset csvdata[#arraysize#][#y#] = #csv#>
<cfset arraysize = arraysize + 1>
</cfloop>
<cfset arraysize = arraysize - 1>
</cfoutput>
------------------------------------------------------------------------
------------------------------
Date: Sat, 12 Aug 2000 16:30:31 -0700
From: [EMAIL PROTECTED] (paul smith)
To: [EMAIL PROTECTED]
Subject: Re: CF_Newbie
Message-ID: <[EMAIL PROTECTED]>
Don't know. I use SQL7.
Haven't bothered to get Access2000
best, paul
At 04:08 PM 8/12/00 -0600, you wrote:
>Actually I am using Access 2000. Is there anything that you know I should
>be aware of using this database?
------------------------------
Date: Sat, 12 Aug 2000 21:31:11 -0400
From: "Abraham Lloyd" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Other ways to skin the cat?
Message-ID: <[EMAIL PROTECTED]>
Sebastian,
]I have stored a query result into an application
]variable. I then want to be able to filter just
]one record from it. The only way I have been
]able to do this is by using a query loop and
]then passing it the CurrentRow variable from
]the query record set and using it for both the
]"startrow" and the "endrow" in the query loop.
]Are there other ways to do it?
You can also pull specific rows from a query using array notation. By
referencing the row number you would like to display after the query name
(ex. '#Application.Books[url.currentrow]#') the same way you would reference
an array element you can accomplish the same results.
]<cfloop query="Application.Books" startrow="#URL.CurrentRow#"
]endrow="#URL.CurrentRow#">
]
] <cfoutput>
] Title: #Title#<br>
] Author: #AuthorLastName#
]
] </cfoutput>
]
]</cfloop>
Instead of the loop, try this:
<cfoutput>Title: #Application.Books[URL.CurrentRow].title#</cfoutput>
<cfoutput>Author: #Application.Books[URL.CurrentRow].author#</cfoutput>
I hope this helps. Good luck!
Best Wishes and Regards,
Abraham Lloyd
Senior Developer
www.onproject.com
Working Together, Apart.
onProject.com Inc.
[EMAIL PROTECTED]
p 407.302.9708
f 973.971.9971
------------------------------
End of CF-Talk V1 #137
**********************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
