Free text verity search in CF

2000-08-13 Thread Roger Lim 

Guys,

may I know how do I achieve searching only part of the word in verity search
without using any wildcard? For example, I just type "ho" in the textbox and
all the words that consists of "ho" will be found.

thanks

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Double Dimesion ArraySorting

2000-08-13 Thread Vincent 

Thanks a ton! I'll work on that !

cheers,
vin


-Original Message-
From: JustinMacCarthy <>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, August 11, 2000 5:52 PM
Subject: Re: Double Dimesion ArraySorting


>Build a structure (associative array) where you have
> the value you are trying to sort (array[x][5]) as the keyname
>and the array[x]  as the keyvalue


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

cfgrid and submit buttons

2000-08-13 Thread Phil Palmer 

Dear all

When I use a CFGRID on a form and then submit the form, all the details
about the current row in the grid are passed through.  This is when I
use a 'submit' button which calls a javascript function which does a 
submit of the form.  

If i replace the 'submit' button with a gif of a button and do the same 
onclick event to the same javascript function the details of the grid are 
NOT passed through by the form.

The details are :

CF version 4.5 on NT

If the code is :




The submit button works ok but the gif doesnt when the javascript function
is :

function update_onclick()
{
  the_form.submit()
}   

Any ideas

Phil Palmer
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Mail Archives

2000-08-13 Thread Eric Dawson 

whoops. I did go to houseoffusion.com though.


From: "Brian Thornton" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: Re: Mail Archives
Date: Wed, 13 Sep 2000 21:08:36 -0600

look at the footer... :)
- Original Message -
From: Eric Dawson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 8:58 PM
Subject: Mail Archives


 > Where are the cftalk archives housed?
 > 
 > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
 >
 > 
--

 > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 > 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/cf-talk@houseoffusion.com/
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.


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Mail Archives

2000-08-13 Thread Brian Thornton 

look at the footer... :)
- Original Message -
From: Eric Dawson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 8:58 PM
Subject: Mail Archives


> Where are the cftalk archives housed?
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.

Mail Archives

2000-08-13 Thread Eric Dawson 

Where are the cftalk archives housed?

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: CF-Talk V1 #139 (Out of office)

2000-08-13 Thread Brian Thornton 

Can we say annoying?
- Original Message -
From: Julie Hopple <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 8:34 PM
Subject: Re: CF-Talk V1 #139 (Out of office)


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/13/00 22:44 >>>

CF-TalkSun, 13 Aug 2000  Volume 1 : Number
139

In this issue:

Re: Using  tag... comments?
Re: Using  tag... comments?
Oracle Time...again
Help - writeEmergencyMessage Error !
mySQL,cf,W2K: possible?
Re: Help - writeEmergencyMessage Error !
Re: [mySQL,cf,W2K: possible?]
RE: [mySQL,cf,W2K: possible?]
RE: [mySQL,cf,W2K: possible?]
RE: More elegant way of passing URL variables?
Re: Oracle Time...again
RE: Queries
RE: user interface resources/groups
Re: Database problems
RE: user interface resources/groups
RE: user interface resources/groups
Dynamic Filefield in CFFILE?
RE: user interface resources/groups
nesting queries
Re: nesting queries
Re: nesting queries
RE: nesting queries
RE: nesting queries
RE: nesting queries


--

Date: Sun, 13 Aug 2000 06:58:31 -0400
From: Bud <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Using  tag... comments?
Message-ID: 

On 8/13/00, Britta Wingenroth penned:
>I'm building a site that will take credit card information online on SSL
but
>send it to the business to be processed by hand.  I need for the mail that
>gets sent from the  tag to be encrypted.  Apparently PGP is
>installed on my ISP, but the SysAdmins don't know how to use it.
>
>I'm thinking of buying the cfx_pgp tag from the allaire site... has anyone
>used it?  Any comments?  Is it secure just with using the free version of
>PGP6 and this tag?  Are there any other products out there that would do
the
>same thing for $150?
>
>Thanks for any feedback!

Yep. Pretty easy. I use it to store credit card information in a
database of recurring monthly billing. I tried all kinds of stuff,
cfx_hash, cf_cryption, cf_encryption. Nothing does what it's supposed
to do. This is probably the most secure method anyway.

Here is the tag, subject being the string to encrypt;



Not exactly sure how you would get their public key into the keyring
on the ISPs server, maybe by importing from a public keyserver. I'm a
little new to PGP and have never tried that, but there is also a
parameter "KEYSERVER" that you'd replace KEYRING above with and put a
FQDN to a public keyserver to get the recipient's public key. I would
presume it may be quicker using a keyring right on the server though,
if possible. After running the tag above, you'd just place the
variable #PGPOut# into the cfmail body. You can also specify your own
variable name.

To see a quick demo:

http://www.twcreations.com/pgp/
--

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

--

Date: Sun, 13 Aug 2000 07:00:26 -0400
From: Bud <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Using  tag... comments?
Message-ID: 

I forgot to mention. I'm not sure if this will work with the freeware
version of PGP. I don't think so.
--

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

--

Date: Sun, 13 Aug 2000 10:31:43 -0400
From: Scott Mulholland <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: Oracle Time...again
Message-ID: <014811FC8CC2D1118B3800104B63EBE6010F4CF1@ADMIN>

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/plain;
charset="iso-8859-1"

I am using the following statement to insert a date/time string into an
Oracle table (date field type):

update MyTable
set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
#TimeFormat(Now(),"hh:mm:ss tt")#')

I keep getting the error message: ORA-01843: not a valid month

Any ideas?

Thanks,
Scott

--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/html;
charset="iso-8859-1"








I am using the
following statement to insert a date/time string into an Oracle table (date
field type):
 
update
MyTable
set
API_UPDATE
= TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
tt")#')
 
I keep getting
the
error message: ORA-01843: not a valid
month

 
Any
ideas?
 
Thanks,
Scott

-

Re: CF-Talk V1 #139 (Out of office)

2000-08-13 Thread Julie Hopple 

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/13/00 22:44 >>>

CF-TalkSun, 13 Aug 2000  Volume 1 : Number 139

In this issue:

Re: Using  tag... comments?
Re: Using  tag... comments?
Oracle Time...again
Help - writeEmergencyMessage Error !
mySQL,cf,W2K: possible?
Re: Help - writeEmergencyMessage Error !
Re: [mySQL,cf,W2K: possible?]
RE: [mySQL,cf,W2K: possible?]
RE: [mySQL,cf,W2K: possible?]
RE: More elegant way of passing URL variables?
Re: Oracle Time...again
RE: Queries
RE: user interface resources/groups
Re: Database problems
RE: user interface resources/groups
RE: user interface resources/groups
Dynamic Filefield in CFFILE?
RE: user interface resources/groups
nesting queries
Re: nesting queries
Re: nesting queries
RE: nesting queries
RE: nesting queries
RE: nesting queries


--

Date: Sun, 13 Aug 2000 06:58:31 -0400
From: Bud <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Using  tag... comments?
Message-ID: 

On 8/13/00, Britta Wingenroth penned:
>I'm building a site that will take credit card information online on SSL but
>send it to the business to be processed by hand.  I need for the mail that
>gets sent from the  tag to be encrypted.  Apparently PGP is
>installed on my ISP, but the SysAdmins don't know how to use it.
>
>I'm thinking of buying the cfx_pgp tag from the allaire site... has anyone
>used it?  Any comments?  Is it secure just with using the free version of
>PGP6 and this tag?  Are there any other products out there that would do the
>same thing for $150?
>
>Thanks for any feedback!

Yep. Pretty easy. I use it to store credit card information in a 
database of recurring monthly billing. I tried all kinds of stuff, 
cfx_hash, cf_cryption, cf_encryption. Nothing does what it's supposed 
to do. This is probably the most secure method anyway.

Here is the tag, subject being the string to encrypt;



Not exactly sure how you would get their public key into the keyring 
on the ISPs server, maybe by importing from a public keyserver. I'm a 
little new to PGP and have never tried that, but there is also a 
parameter "KEYSERVER" that you'd replace KEYRING above with and put a 
FQDN to a public keyserver to get the recipient's public key. I would 
presume it may be quicker using a keyring right on the server though, 
if possible. After running the tag above, you'd just place the 
variable #PGPOut# into the cfmail body. You can also specify your own 
variable name.

To see a quick demo:

http://www.twcreations.com/pgp/
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

--

Date: Sun, 13 Aug 2000 07:00:26 -0400
From: Bud <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Using  tag... comments?
Message-ID: 

I forgot to mention. I'm not sure if this will work with the freeware 
version of PGP. I don't think so.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

--

Date: Sun, 13 Aug 2000 10:31:43 -0400
From: Scott Mulholland <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: Oracle Time...again
Message-ID: <014811FC8CC2D1118B3800104B63EBE6010F4CF1@ADMIN>

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/plain;
charset="iso-8859-1"

I am using the following statement to insert a date/time string into an
Oracle table (date field type):
 
update MyTable
set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
#TimeFormat(Now(),"hh:mm:ss tt")#')
 
I keep getting the error message: ORA-01843: not a valid month 
 
Any ideas?
 
Thanks,
Scott

--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/html;
charset="iso-8859-1"








I am using the 
following statement to insert a date/time string into an Oracle table (date 
field type):
 
update 
MyTable
set 
API_UPDATE 
= TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss 
tt")#')
 
I keep getting the 
error message: ORA-01843: not a valid month 

 
Any 
ideas?
 
Thanks,
Scott

--_=_NextPart_001_01C00533.33F6C520--

--

Date: Sun, 13 Aug 2000 08:40:18 -0700
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]

RE: nesting queries

2000-08-13 Thread Sharon DiOrio 

Half asleep.  Norman's got the right answer on this one.

Sharon

At 09:52 PM 8/13/2000 -0400, Norman Elton wrote:
>From the looks of it, you're trying to get an output like:
>
>---
>City 1
>   Neighborhood A
>   Neighborhood B
>   Neighborhood C
>
>City 2
>   Neighborhood D
>   Neighborhood E
>   Neighborhood F
>---
>
>If so, try this:
>
>---
>
>   select city, neighborhood
>   from areas
>   order by city, neighborhood
>
>
>
>   #City#
>   
>   #Neighborhood#
>   
>   
>
>---
>
>The query returns all the neighborhoods and their corresponding cities,
>sorted for a nice pretty output (this is actually important if your cities
>appear out of alphabetical order in the database).
>
>The first CFOUTPUT tells ColdFusion that you will be outputting the query,
>and you want to group the output by city. The code outside the second
>CFOUTPUT is only executed once per city. The code inside the second CFOUTPUT
>is then executed once per record (i.e. in this case, once per neighborhood).
>Once a new city is reached, this inner loop stops and the process starts
>over again with the first CFOUTPUT.
>
>Hope this helps. If this wasn't what you were trying to do, well now you
>know!
>
>Norman Elton
>Information Technology
>College of William & Mary
>
>-Original Message-
>From: Mark Ireland [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, August 13, 2000 9:13 PM
>To: [EMAIL PROTECTED]
>Subject: Re: nesting queries
>
>
>
>Its is as easy as
>>where city = '#cities.city#'
>
>
>
>At 09:09 PM 13/08/00 -0400, you wrote:
>>also a novice, and am stuck. Am trying to nest a query theoretically like
>>the following...
>>
>>
>>   select city
>>   from areas
>>
>>
>>#city#
>>
>>
>>select neighborhood
>>from areas
>>where city = '#city#'
>> 
>> #neighborhood#
>>
>>
>>
>>I know this has got to be quite simple to do, but I'm just lost in all the
>>unfamiliar phrases and documentation. Can anyone tell me the trick?
>>
>>Cheers,
>>
>>Mark
>
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>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.mail-archive.com/cf-talk@houseoffusion.com/
>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.mail-archive.com/cf-talk@houseoffusion.com/
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.

RE: nesting queries

2000-08-13 Thread Norman Elton 

Well I see responses are rolling, and I've already noticed a problem in
mine... the CFQUERY line should read:



Insert the name of your datasource (as configured in the CF Administrator)
into the "...".

Norman Elton
Information Technology
College of William & Mary

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

RE: nesting queries

2000-08-13 Thread Norman Elton 

>From the looks of it, you're trying to get an output like:

---
City 1
Neighborhood A
Neighborhood B
Neighborhood C

City 2
Neighborhood D
Neighborhood E
Neighborhood F
---

If so, try this:

---

select city, neighborhood
from areas
order by city, neighborhood



#City#

#Neighborhood#



---

The query returns all the neighborhoods and their corresponding cities,
sorted for a nice pretty output (this is actually important if your cities
appear out of alphabetical order in the database).

The first CFOUTPUT tells ColdFusion that you will be outputting the query,
and you want to group the output by city. The code outside the second
CFOUTPUT is only executed once per city. The code inside the second CFOUTPUT
is then executed once per record (i.e. in this case, once per neighborhood).
Once a new city is reached, this inner loop stops and the process starts
over again with the first CFOUTPUT.

Hope this helps. If this wasn't what you were trying to do, well now you
know!

Norman Elton
Information Technology
College of William & Mary

-Original Message-
From: Mark Ireland [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 9:13 PM
To: [EMAIL PROTECTED]
Subject: Re: nesting queries



Its is as easy as
>where city = '#cities.city#'



At 09:09 PM 13/08/00 -0400, you wrote:
>also a novice, and am stuck. Am trying to nest a query theoretically like
>the following...
>
>
>   select city
>   from areas
>
>
>#city#
>
>
>select neighborhood
>from areas
>where city = '#city#'
> 
> #neighborhood#
>
>
>
>I know this has got to be quite simple to do, but I'm just lost in all the
>unfamiliar phrases and documentation. Can anyone tell me the trick?
>
>Cheers,
>
>Mark


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.

Re: nesting queries

2000-08-13 Thread Sharon DiOrio 

You've almost got it.  Try this:


   select city
   from areas


#city#


select neighborhood
from areas
where city = '#city#'
 
 #neighborhoods.neighborhood#



HTH,
Sharon

At 09:09 PM 8/13/2000 -0400, Mark Davies wrote:
>also a novice, and am stuck. Am trying to nest a query theoretically like
>the following...
>
>
>   select city
>   from areas
>
>
>#city#
>
>
>select neighborhood
>from areas
>where city = '#city#'
> 
> #neighborhood#
>
>
>
>I know this has got to be quite simple to do, but I'm just lost in all the
>unfamiliar phrases and documentation. Can anyone tell me the trick?
>
>Cheers,
>
>Mark
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>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.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: nesting queries

2000-08-13 Thread Mark Ireland 


Its is as easy as
>where city = '#cities.city#'



At 09:09 PM 13/08/00 -0400, you wrote:
>also a novice, and am stuck. Am trying to nest a query theoretically like
>the following...
>
>
>   select city
>   from areas
>
>
>#city#
>
>
>select neighborhood
>from areas
>where city = '#city#'
> 
> #neighborhood#
>
>
>
>I know this has got to be quite simple to do, but I'm just lost in all the
>unfamiliar phrases and documentation. Can anyone tell me the trick?
>
>Cheers,
>
>Mark

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

nesting queries

2000-08-13 Thread Mark Davies 

also a novice, and am stuck. Am trying to nest a query theoretically like
the following...


   select city
   from areas


#city#


select neighborhood
from areas
where city = '#city#'
 
 #neighborhood#



I know this has got to be quite simple to do, but I'm just lost in all the
unfamiliar phrases and documentation. Can anyone tell me the trick?

Cheers,

Mark

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

RE: user interface resources/groups

2000-08-13 Thread Dave Watts 

> I don't know about the book, but the ideas on the
> http://www.cooper.com/ website have a lot in common
> with those in "Streetwise Relationship Marketing on the
> Internet",
> http://www.amazon.com/exec/obidos/ASIN/1580622550/002-1005726-6333617,
> which is the single best book I've seen on the subject
> in quite a while.

The book slightly predates the popularity of the internet, really (1995),
but it's still just as valid as it ever was.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Dynamic Filefield in CFFILE?

2000-08-13 Thread Eldo Lukman - Monitor 

Hi All,

Is it possible at all to specify a dynamic value for the 'filefield'
parameter in a CFFILE tag? I have a code that dynamically build a form from
the database, and I need to be able to dynamically specify a dynamic
filefield in the processing bit.

The doco says that you cannot use the # sign to specify the
filefield. Is there a way around this?

thanks in advance,

---
Eldo Lukman
Multimedia Programmer
Monitor Interactive Communications Pty Ltd
ACN: 050 036 283
Level 2, 4-14 Foster Street
Surry Hills, NSW 2010
AUSTRALIA
Telephone: +61 2 9219 8956
Facsimile: +61 2 9219 8950
E-mail: [EMAIL PROTECTED]
Mobile: 0418 265 829
Web Site: http://www.monitorinteractive.com.au/
--- 

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

RE: user interface resources/groups

2000-08-13 Thread paul smith 

The 47 reviews of the book on www.amazon.com are a must read.

best,  paul

At 08:30 PM 8/13/00 -0400, you wrote:
>Although it's neither a website nor a user group, I'd strongly recommend
>taking a look at Alan Cooper's book "About Face - The Essentials of User
>Interface Design". You can find out more about it at http://www.cooper.com/.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

RE: user interface resources/groups

2000-08-13 Thread paul smith 

I don't know about the book, but the ideas on the http://www.cooper.com/ 
website have a lot in common with those in "Streetwise Relationship 
Marketing on the Internet",
http://www.amazon.com/exec/obidos/ASIN/1580622550/002-1005726-6333617,
which is the single best book I've seen on the subject in quite a while.

best,  paul

At 08:30 PM 8/13/00 -0400, you wrote:
>Although it's neither a website nor a user group, I'd strongly recommend
>taking a look at Alan Cooper's book "About Face - The Essentials of User
>Interface Design". You can find out more about it at http://www.cooper.com/.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Database problems

2000-08-13 Thread John Allred 

Katrina,

You and Dan removed a huge weight that had made lots of stuff difficult.
Moving the CFLOCATION outside the CFTRANSACTION did the trick.

Thanks so much,
--John

"Chapman, Katrina" wrote:
> 
> Try This.
> 
> 
> 
>   (insert query)
> 
> 
> 
>   (get last entered record)
> 
> 
> 
> 
> 
> 
> 
> 
> There was an error.
> 
>
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

RE: user interface resources/groups

2000-08-13 Thread Dave Watts 

> can anyone suggest any user interface focused websites or user groups?
>
> i'm interested in researching application standards like:
>  -  button naming (Save or Submit? Edit or Modify?)
>  -  button placement (Save before Cancel or Cancel before Save?)
>  -  current trends (tabbed, explorer-like menus, etc)
>  -  UI critique of current software (MacOS, Windows) and websites

Although it's neither a website nor a user group, I'd strongly recommend
taking a look at Alan Cooper's book "About Face - The Essentials of User
Interface Design". You can find out more about it at http://www.cooper.com/.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

RE: Queries

2000-08-13 Thread Dave Watts 

> 1.  Just curious, is it possible to do a query across two
> different datasources? I have a table in one datasource and
> I would like to do some kind of join query on another table
> that would make things simple except that the other table is
> in another datasource. Is it possible to do the query regardless
> of the fact that the tables are in different datasources?

No, you can't generally do this from within CF. You do have some options,
though. Your database may allow referencing other databases from within your
query; SQL Server 7, for example, lets you do some things like this. Also,
you can simply query each datasource, then merge the query results within
CF. This will require a little CF code, but I believe there are custom tags
available (one called CF_MERGEQUERY comes to mind) which will do this.

> 2.  Is it possible to do a query on a query result set? I have
> the results from a CFQUERY but I was wondering if one could then
> do a query using the query results as if it was a table itself?

No, you can't use SQL to filter recordsets after you've retrieved them.
However, again, you can build something analogous to this using CFML to
filter your recordset.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Oracle Time...again

2000-08-13 Thread Joseph Eugene 

Scott,
The date format is Oracle is very picky. Its worth having an
Oracle sql referrence book.

If you just want the current date
"update MyTable
set API_UPDATE = 'Sysdate'"
This will update the date field to the current oracle db date.

If you want to manually update the date with CF
you have to use the format
"12-Jun-2000"
The month should be abbreviated to 3 chars

Thanks
Joe





- Original Message -
From: "Scott Mulholland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 10:31 AM
Subject: Oracle Time...again


> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> --_=_NextPart_001_01C00533.33F6C520
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> I am using the following statement to insert a date/time string into an
> Oracle table (date field type):
>
> update MyTable
> set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
> #TimeFormat(Now(),"hh:mm:ss tt")#')
>
> I keep getting the error message: ORA-01843: not a valid month
>
> Any ideas?
>
> Thanks,
> Scott
>
> --_=_NextPart_001_01C00533.33F6C520
> Content-Type: text/html;
> charset="iso-8859-1"
>
> 
> 
> 
>
>
> 
> 
> I am using the
> following statement to insert a date/time string into an Oracle table
(date
> field type):
>  size=2> 
> update
> MyTable
> set
> API_UPDATE
> = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
> tt")#')
>  size=2> 
> I keep getting
the
> error message: ORA-01843: not a valid
month
> 
>  
> Any
> ideas?
>  size=2> 
>  size=2>Thanks,
> Scott
>
> --_=_NextPart_001_01C00533.33F6C520--
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.

RE: More elegant way of passing URL variables?

2000-08-13 Thread Norman Elton 

Is this code (CF_DecryptURL) available? I've searched the 'net and the
Developer's Exchange but can't find it.

Thanks!

Norman Elton
Information Technology
College of William & Mary

- Original Message -
From: "JustinMacCarthy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 9:21 AM
Subject: Re: More elegant way of passing URL variables?


> Encrypt  the url 
> I wrote a couple of tags that encrypt/ decrypt query_strings
>
> so instead of index.cfm?value=6&name=jim
>
> You get
>
> page2.cfm?94946560A4946560B495214551E01031C1D1A.
> and on page2 you include 
>
> and you can still use url.value and url.name etc
>
> I don't have it handy at the moment though and it chould do with
> more testing but I'll end it to you over the weekend if you want ...
>
> ~ Justin
>
> - Original Message -
> From: "Milks, Jim" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 11, 2000 4:49 PM
> Subject: More elegant way of passing URL variables?
>
>
> > Hi,
> > I am dynamically generating a list of customers, on which a user can
click
> > to go to a detailed page. To do this, I am putting the customerID into a
> URL
> > variable in the A HREF path. But the client doesn't want to see the
value
> in
> > the address bar, as they consider it a security risk.
> >
> > What would be a better solution? A hidden FORM field for each item, and
> have
> > the HREF call Javascript which posts the form? The problem with that us
I
> > will get all of the form fields in the detail page, unless the JS passes
a
> > value to indicate the field I want, but hen I essentially have the same
> > problem
> >
> > Any input appreciated.
> >
> > James
>
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > 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/cf-talk@houseoffusion.com/
> 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.


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.

RE: [mySQL,cf,W2K: possible?]

2000-08-13 Thread Chris Straight 

What you need to do is create a system DSN under your odbc control pannel
with all the pertinent information. Once that is done then ColdFusion
recognizes that DS as a valid one under the coldfusion administrator...

---
Chris Straight
Web Applications Developer
University of Oregon Bookstore, inc.
895 E. 13th Ave
Eugene, OR 97401
(541) 346-4331
http://www.uobookstore.com

-Original Message-
From: Mark Davies [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 8:58 PM
To: [EMAIL PROTECTED]
Subject: RE: [mySQL,cf,W2K: possible?]


thanks, I've got myodbc installed but can you tell me which ODBC driver I
use? It isn't showing MYODBC -- should it? OR do I use a MS driver?

Mark

___
nyc: 917-922-5279 cell
nyc: 212-431-9002 work
 uk: 07957-138858
fax: 530-239-8059
[EMAIL PROTECTED]

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, August 13, 2000 3:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [mySQL,cf,W2K: possible?]
>
>
> yes. you need MyODBC.
>
> "Mark Davies" <[EMAIL PROTECTED]> wrote:
> I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
> development. Is this possible? I've got everything up and running, but I
> can't seem to define the datasource in the CF app server. Is it possible?
>
> Any help much appreciated.
>
> Mark
> [EMAIL PROTECTED]
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.
>
>
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.

RE: [mySQL,cf,W2K: possible?]

2000-08-13 Thread Mark Davies 

thanks, I've got myodbc installed but can you tell me which ODBC driver I
use? It isn't showing MYODBC -- should it? OR do I use a MS driver?

Mark

___
nyc: 917-922-5279 cell
nyc: 212-431-9002 work
 uk: 07957-138858
fax: 530-239-8059
[EMAIL PROTECTED]

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, August 13, 2000 3:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [mySQL,cf,W2K: possible?]
>
>
> yes. you need MyODBC.
>
> "Mark Davies" <[EMAIL PROTECTED]> wrote:
> I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
> development. Is this possible? I've got everything up and running, but I
> can't seem to define the datasource in the CF app server. Is it possible?
>
> Any help much appreciated.
>
> Mark
> [EMAIL PROTECTED]
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.
>
>
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: [mySQL,cf,W2K: possible?]

2000-08-13 Thread double-down 

yes. you need MyODBC.

"Mark Davies" <[EMAIL PROTECTED]> wrote:
I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
development. Is this possible? I've got everything up and running, but I
can't seem to define the datasource in the CF app server. Is it possible?

Any help much appreciated.

Mark
[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Help - writeEmergencyMessage Error !

2000-08-13 Thread Eron Cohen 

Hi Jonathan,

I have also gotten this error message in ColdFusion 4.51 on Windows NT.  And
it mysteriously came and went, I have only seen it twice and never saw it
again.  I found another person who's experienced this issue too on
forums.allaire.com.  He believes that its related to the numberformat() and
dollarformat() functions.  Just out of curiousity, are you using either one
of these on the page in question?

I don't know of anything official from Allaire about this.

Eron

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 11:40 AM
Subject: Help - writeEmergencyMessage Error !


>
> Hi guys,
>
> one of the servers I'm working with gave me the following error
> message for a few minutes straight :
>
> Error occurred while processing request
>
> Error Diagnostic Information
>
> unknown exception condition
>
> CFMLInterpreterImp::writeEmergencyMessage
>
> It returned to normal afterwards, but now I'm wondering if there's
> something serious gone wrong! Has anyone encountered this before?
> Any ideas on what might be happening?
>
> Thanks in advance,
>
> J
>
> -
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.

mySQL,cf,W2K: possible?

2000-08-13 Thread Mark Davies 

I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
development. Is this possible? I've got everything up and running, but I
can't seem to define the datasource in the CF app server. Is it possible?

Any help much appreciated.

Mark
[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Help - writeEmergencyMessage Error !

2000-08-13 Thread jonathan_fisher99 


Hi guys,

one of the servers I'm working with gave me the following error
message for a few minutes straight :

Error occurred while processing request

Error Diagnostic Information

unknown exception condition

CFMLInterpreterImp::writeEmergencyMessage

It returned to normal afterwards, but now I'm wondering if there's
something serious gone wrong! Has anyone encountered this before?
Any ideas on what might be happening? 

Thanks in advance,

J

-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Oracle Time...again

2000-08-13 Thread Scott Mulholland 

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/plain;
charset="iso-8859-1"

I am using the following statement to insert a date/time string into an
Oracle table (date field type):
 
update MyTable
set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
#TimeFormat(Now(),"hh:mm:ss tt")#')
 
I keep getting the error message: ORA-01843: not a valid month 
 
Any ideas?
 
Thanks,
Scott

--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/html;
charset="iso-8859-1"








I am using the 
following statement to insert a date/time string into an Oracle table (date 
field type):
 
update 
MyTable
set 
API_UPDATE 
= TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss 
tt")#')
 
I keep getting the 
error message: ORA-01843: not a valid month 

 
Any 
ideas?
 
Thanks,
Scott

--_=_NextPart_001_01C00533.33F6C520--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Using tag... comments?

2000-08-13 Thread Bud 

I forgot to mention. I'm not sure if this will work with the freeware 
version of PGP. I don't think so.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Using tag... comments?

2000-08-13 Thread Bud 

On 8/13/00, Britta Wingenroth penned:
>I'm building a site that will take credit card information online on SSL but
>send it to the business to be processed by hand.  I need for the mail that
>gets sent from the  tag to be encrypted.  Apparently PGP is
>installed on my ISP, but the SysAdmins don't know how to use it.
>
>I'm thinking of buying the cfx_pgp tag from the allaire site... has anyone
>used it?  Any comments?  Is it secure just with using the free version of
>PGP6 and this tag?  Are there any other products out there that would do the
>same thing for $150?
>
>Thanks for any feedback!

Yep. Pretty easy. I use it to store credit card information in a 
database of recurring monthly billing. I tried all kinds of stuff, 
cfx_hash, cf_cryption, cf_encryption. Nothing does what it's supposed 
to do. This is probably the most secure method anyway.

Here is the tag, subject being the string to encrypt;



Not exactly sure how you would get their public key into the keyring 
on the ISPs server, maybe by importing from a public keyserver. I'm a 
little new to PGP and have never tried that, but there is also a 
parameter "KEYSERVER" that you'd replace KEYRING above with and put a 
FQDN to a public keyserver to get the recipient's public key. I would 
presume it may be quicker using a keyring right on the server though, 
if possible. After running the tag above, you'd just place the 
variable #PGPOut# into the cfmail body. You can also specify your own 
variable name.

To see a quick demo:

http://www.twcreations.com/pgp/
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: problem with mail attachements

2000-08-13 Thread David Shadovitz 

Wanna show us some code?

On Sat, 12 Aug 2000 13:02:09 -0400 "Christopher S Martin"
<[EMAIL PROTECTED]> writes:
> 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?

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Flushing cached queries

2000-08-13 Thread David Shadovitz 

Dana, set the cachedwithin time to 0.
(Still no city, eh?)
-David

> If you are caching queries, is there a way to force CF
> to flush them?


YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Re: Using tag... comments?

2000-08-13 Thread Terry Riley 

In-Reply-To: <000901c004f4$acd4c350$88177318@cr32783a>

>>>
I'm thinking of buying the cfx_pgp tag from the allaire site... has anyone
used it?  Any comments?  Is it secure just with using the free version of
PGP6 and this tag?  Are there any other products out there that would do 
the same thing for $150?
>>>

Yes, I'm using it. Was easy enough to set up. If PGP is set up on the ISP, 
all that should be required is the key for the PGP email recipient. Make 
sure that ISP has a license for the server from the CFX_PGP vendor.

You can test out on your development machine using the 60-day free trial 
version of CFX_PGP (and the PGP free version). The installation/use 
instructions that come with the tag are concise. If you don't have an SMTP 
server, you can at least review the sent message (encrypted) in 
Cfusion\mail\undelivd.

Other products? Don't know

Terry Riley
Riley Varea Associates, London, UK 

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Using tag... comments?

2000-08-13 Thread Britta Wingenroth 

I'm building a site that will take credit card information online on SSL but
send it to the business to be processed by hand.  I need for the mail that
gets sent from the  tag to be encrypted.  Apparently PGP is
installed on my ISP, but the SysAdmins don't know how to use it.

I'm thinking of buying the cfx_pgp tag from the allaire site... has anyone
used it?  Any comments?  Is it secure just with using the free version of
PGP6 and this tag?  Are there any other products out there that would do the
same thing for $150?

Thanks for any feedback!

Sincerely,

Britta Wingenroth
Web Development & Design
West Coast Web
__
[EMAIL PROTECTED]
(604) 737-4332


Britta

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.