Re: cfx_pwcardcrypt (was: encrypt credit card field?)

2001-06-21 Thread Kay Smoljak

On Fri, 22 Jun 2001 14:13:33 +1000, "Peter Tilbrook"
<[EMAIL PROTECTED]> wrote:
>4) It is relatively inexpensive considering its power and usefulness
>(AUD$50.00 - about US$20.00 or there abouts).

While all your other very flattering comments are in fact true (thank you -
I can see the tag blushing right now), the prices listed on the web site are
already in US dollars. The single license (one server) costs US$49 and the
unlimited license is US $299. Considering the cost of a commercial PGP
license, I think it's very good value.

Regards,
Kay.
__
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!

Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au

Tools for developers: http://developer.perthweb.com.au
-- cfx_pwimageproc: image processing tool
-- cfx_pwcardcrypt: credit card validation and encryption



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



personal web server that will work with win 98 and coldfusion

2001-06-21 Thread Parra, Fernando

 
 
"I am using cold fusion single server 4 with cold fusion but every time I
load single server it asks
me for the personal web server on my computer. I have tried several free web
servers that work well
for FTP, HTTTP, and ISAPI but lack things such as SSL. single server does
not automatically detect these servers.
do you know where I can get a personal web server that will work with win 98
and cold fusion."
 
 
Thanks,
 
 
Fernando


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

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



RE: cfx_pwcardcrypt (was: encrypt credit card field?)

2001-06-21 Thread Peter Tilbrook

Regarding this tag - it is very good for these reasons.

1)  It's fast:

For the actual credit card checking, even using the full 2048 bit keys it
is almost instantaneous. Generating the keys in the first place takes a
while (depending on the level of encryption you require) but you should only
need to do this once. Un-encrypting - even 2048 takes about 3-5 seconds on a
modest server.

2)  It's written in C++ - and appears to be efficient code.

It is easy to install as a CFX also.

3)  The messages the tag generates are verbose meaning if a card is rejected
it tells you why - meaning you can return the reason to the browser or
process code based upon the result.

4)  It is relatively inexpensive considering its power and usefulness
(AUD$50.00 - about US$20.00 or there abouts).

5)  You can try it for FREE at http://www.developer.perthweb.com.au/

6)  It's Australian made! That has to be good!

I'm doing final testing for an application using this tag and have already
requested an invoice from Perthweb to pay the bargain registration cost.

Cheers!

Peter Tilbrook
Chief Web Developer
Lunar Power Internet Technologies
Unit 1, 26-28 Winchcombe Court
Mitchell, ACT, 2911
AUSTRALIA

Phone: (02) 6242 
Fax: (02) 6242 6655
Email: [EMAIL PROTECTED]
Web: http://www.lunarpower.com.au


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

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



Re: how to do a loop? ...or something.

2001-06-21 Thread Aimee Abbott

Gene, Thanks!

Unfortunately not that simple.  It doesn't pass a null value.  If I have 
three of them and only two addresses I get a list with only two elements in 
it, not two and a null.  My *current* idea is to put the default
Aimee,
>
>Here's one possible way:
>
>The form fields for the addresses, all named "address", will produce
>a comma-delimited list with as many elements as people. That is,
>even if some of the address fields are blank, the form will still pass
>those to the action template.
>
>I assume you're also using a unique ID number for each contact,
>so you could populate the initial form with hidden input fields, like
>this, to pass the ID numbers retrieved via your second query:
>
>VALUE="#ContactID#">
>
>Then you should be able to loop through the ContactIDs using LIST
>functions, something like this to save the info:
>
>
>
> 
> 
> UPDATE Contacts
> SET Name="#ListGetAt(Form.Name, Counter)#",
> Address="#ListGetAt(Form.Address, Counter)#"
> WHERE ContactID=#ThisContactID#
> 
>
>
>ListGetAt combined with the Counter number will keep the
>information in sync...
>
>Gene Kraybill
>LPW & Associates
>Mansfield, PA
>
>On 21 Jun 2001, at 20:27, Aimee Abbott wrote:
>
> >
> > Hello everyone!
> >
> > I have a database of companys, names, contacts and addresses.  Not all
> > companys have contact addresses.  I am setting up a form that will allow
> > people to come and change their address.  They will get to the form by
> > entering a url with a primary key at the end of it.  This will query up 
> the
> > company and then a second query will get the people.  The second gets the
> > contact names and addresses -- there can be as many as a dozen
> > contacts.  That is the one I am having trouble with.  What I have done is
> > set it up so (in simple form)
> >
> > 
> > 
> > 
> > 
> >
> > 
> > name: 
> > address: 
> > 
> >
> > 
> > Now, like I said there can be a lot of contact names.
> >
> > So, then on the next page where I save it in the database, what do I 
> do?  I
> > get the information in the form of a list. Where
> > #name#=bob, mary, alice, harry, john
> > but not everyone has an address so I might get
> > #address#=chicago, minneapolis, rome
> >
> > I need to some how match these up somehow and update the record.  Any idea
> > how I can go about doing this?
> >
> > I have thought about the first page having some sort of number appended on
> > to the end of the variable name so the form would somehow have name1,
> > name2, name3, name4 but I don't actually know how to do that.
> >
> > Or from the second page, can I access individual list elements?  And even
> > if I could, how could I know that bob is from chicago, mary is blank and
> > alice is from minneapolis?
> >
> > If I haven't explained this well enough please let me know!
> >
> > Thanks much!
> >
> >
> >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: Duplicate name conflict error message

2001-06-21 Thread Kay Smoljak

On Thu, 21 Jun 2001 13:30:42 -0400, <[EMAIL PROTECTED]> wrote:
>I'm getting a 'Duplicate name conflict' error message.  I'm unable to solve
it, because the code in which it is appearing is over 1,000 lines long.
Also, the error message states:
>"The error occurred while processing an element with a general identifier
of (CFINPUT), occupying document position (380:1) to (381:39)."
>
>This doesn't help me, because line 280 contains only the code  and
line 381 is completely blank, with nothing on it at all.  I don't
understand, therefore, how the message could refer to line 381, position 39.

Hi Hubert,

Are you counting the line numbers in your code or in the browser's output?
You'll probably find that they are different, due to CF adding whitespace
when it processes the page. I usually paste the "view source" output in to
CF Studio so I can see the line numbers.

HTH,
K.
__
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!

Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au

Tools for developers: http://developer.perthweb.com.au
-- cfx_pwimageproc: image processing tool
-- cfx_pwcardcrypt: credit card validation and encryption



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



Re: how to do a loop? ...or something.

2001-06-21 Thread kraybill

Aimee,

Here's one possible way:

The form fields for the addresses, all named "address", will produce 
a comma-delimited list with as many elements as people. That is, 
even if some of the address fields are blank, the form will still pass 
those to the action template.

I assume you're also using a unique ID number for each contact, 
so you could populate the initial form with hidden input fields, like 
this, to pass the ID numbers retrieved via your second query:



Then you should be able to loop through the ContactIDs using LIST 
functions, something like this to save the info:





UPDATE Contacts
SET Name="#ListGetAt(Form.Name, Counter)#",
Address="#ListGetAt(Form.Address, Counter)#"
WHERE ContactID=#ThisContactID#



ListGetAt combined with the Counter number will keep the 
information in sync...

Gene Kraybill
LPW & Associates
Mansfield, PA

On 21 Jun 2001, at 20:27, Aimee Abbott wrote:

> 
> Hello everyone!
> 
> I have a database of companys, names, contacts and addresses.  Not all 
> companys have contact addresses.  I am setting up a form that will allow 
> people to come and change their address.  They will get to the form by 
> entering a url with a primary key at the end of it.  This will query up the 
> company and then a second query will get the people.  The second gets the 
> contact names and addresses -- there can be as many as a dozen 
> contacts.  That is the one I am having trouble with.  What I have done is 
> set it up so (in simple form)
> 
> 
> 
> 
> 
> 
> 
> name: 
> address: 
> 
> 
> 
> Now, like I said there can be a lot of contact names.
> 
> So, then on the next page where I save it in the database, what do I do?  I 
> get the information in the form of a list. Where
> #name#=bob, mary, alice, harry, john
> but not everyone has an address so I might get
> #address#=chicago, minneapolis, rome
> 
> I need to some how match these up somehow and update the record.  Any idea 
> how I can go about doing this?
> 
> I have thought about the first page having some sort of number appended on 
> to the end of the variable name so the form would somehow have name1, 
> name2, name3, name4 but I don't actually know how to do that.
> 
> Or from the second page, can I access individual list elements?  And even 
> if I could, how could I know that bob is from chicago, mary is blank and 
> alice is from minneapolis?
> 
> If I haven't explained this well enough please let me know!
> 
> Thanks much!
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: cfx_pwcardcrypt (was: encrypt credit card field?)

2001-06-21 Thread Kay Smoljak

On Thu, 21 Jun 2001 14:48:37 -0400, Bud <[EMAIL PROTECTED]> wrote:
>Cool. Are there any licensing caveats? I purchased CFX_PGP a year or
>so ago, built some nice stuff to use it, and then find out it's
>16,000 for a PGP commercial license.

Hi Bud,

No, the whole reason we built it was because PGP was so expensive - way out
of our client's price range. It uses the open source RSA algorithm.

Regards,
Kay.
__
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!

Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au

Tools for developers: http://developer.perthweb.com.au
-- cfx_pwimageproc: image processing tool
-- cfx_pwcardcrypt: credit card validation and encryption



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



RE: CF and Excel

2001-06-21 Thread David Shadovitz

David,

You got that error because Excel is not registered on your server.  Assuming 
that Excel is in fact installed on your server, you can register it by 
following the directions at 
http://www.cfcomet.com/cfcomet/Other/index.cfm?ArticleID=32381637-0922-41CA-  
BBE305C2D66A7025#2.

Note that this technique creates an Excel file on the server, which users can 
then download.  A simpler method is to use CFCONTENT and CFHEADER to send the 
data to the Excel application on your users' machines.

-David

On Thursday, June 21, 2001 4:51 PM, David Baskin 
[SMTP:[EMAIL PROTECTED]] wrote:
> Hello, i've been tasked with taking data out of a SQL database and inserting
> it into an excel spread sheet. I went to CFComet and read through their
> instructions and ran their sample code, but i cannot get it to work. I get
> the following error:
>
> Error Diagnostic Information
> Error trying to create object specified in the tag.
>
> COM error 0x80040154. Class not registered
>
> Does anyone know how best to connect and write to excel and if there is a
> good tutorial that i can learn from. Creating and connecting to objects is
> new to me, so i'm a little lost. Thanks for any help.
>
> david
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: double action form

2001-06-21 Thread Jay E Wigginton

duh!  for some reason that never even came to mind and I use cflocation all
the time... :)

thanks
Jay

-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 8:25 PM
To: CF-Talk
Subject: RE: double action form


Use a local CFML template to process the local DB write and then CFLOCATION
with all the attributes the remote server needs.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Jay E Wigginton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 3:08 PM
> To: CF-Talk
> Subject: double action form
>
>
> I was wondering if there is a means to have a form when submitted perform
> two functions... I have a form that allows people to subscribe to an
> electronic newsletter... the form is located on my web site and the form's
> action statement is a URL to an outsourced company's web site...
> what I want
> to do is record the form input locally into a CSV file as well... any
> suggestions on how to accomplish this with a single form and click.
>
> thanks
> Jay
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



how to do a loop? ...or something.

2001-06-21 Thread Aimee Abbott


Hello everyone!

I have a database of companys, names, contacts and addresses.  Not all 
companys have contact addresses.  I am setting up a form that will allow 
people to come and change their address.  They will get to the form by 
entering a url with a primary key at the end of it.  This will query up the 
company and then a second query will get the people.  The second gets the 
contact names and addresses -- there can be as many as a dozen 
contacts.  That is the one I am having trouble with.  What I have done is 
set it up so (in simple form)







name: 
address: 



Now, like I said there can be a lot of contact names.

So, then on the next page where I save it in the database, what do I do?  I 
get the information in the form of a list. Where
#name#=bob, mary, alice, harry, john
but not everyone has an address so I might get
#address#=chicago, minneapolis, rome

I need to some how match these up somehow and update the record.  Any idea 
how I can go about doing this?

I have thought about the first page having some sort of number appended on 
to the end of the variable name so the form would somehow have name1, 
name2, name3, name4 but I don't actually know how to do that.

Or from the second page, can I access individual list elements?  And even 
if I could, how could I know that bob is from chicago, mary is blank and 
alice is from minneapolis?

If I haven't explained this well enough please let me know!

Thanks much!


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

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



RE: double action form

2001-06-21 Thread Mark Warrick

Use a local CFML template to process the local DB write and then CFLOCATION
with all the attributes the remote server needs.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Jay E Wigginton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 3:08 PM
> To: CF-Talk
> Subject: double action form
>
>
> I was wondering if there is a means to have a form when submitted perform
> two functions... I have a form that allows people to subscribe to an
> electronic newsletter... the form is located on my web site and the form's
> action statement is a URL to an outsourced company's web site...
> what I want
> to do is record the form input locally into a CSV file as well... any
> suggestions on how to accomplish this with a single form and click.
>
> thanks
> Jay
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



CF and Excel

2001-06-21 Thread David Baskin

Hello, i've been tasked with taking data out of a SQL database and inserting
it into an excel spread sheet. I went to CFComet and read through their
instructions and ran their sample code, but i cannot get it to work. I get
the following error:

Error Diagnostic Information
Error trying to create object specified in the tag.

COM error 0x80040154. Class not registered

Does anyone know how best to connect and write to excel and if there is a
good tutorial that i can learn from. Creating and connecting to objects is
new to me, so i'm a little lost. Thanks for any help.

david


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

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



Re: IIF vs if,else

2001-06-21 Thread Bud

On 6/20/01, Cameron penned:
>if () {}), else ( or else {}).
>
>I tested a simple block of code using IIF and  
>& IIF ran twice as slow...
>
>I can't see any major advantage by using it... yeah, it is kinda 
>similar to i = (true?1 : 2); in javascript but it's really slow case 
>of the implicit evaluate() on each part. Would be better if it was 
>implicit & made explicit, IF NEEDED.
>
>Can anyone give me a decent reason why IIF is better that ?

The only reason in the world that I know of to use IIF() is if you 
must have an if statement inside of cf tag.

In other words,



will break, whereas



will work.
-- 

Bud Schneehagen - Tropical Web Creations

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

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

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



double action form

2001-06-21 Thread Jay E Wigginton

I was wondering if there is a means to have a form when submitted perform
two functions... I have a form that allows people to subscribe to an
electronic newsletter... the form is located on my web site and the form's
action statement is a URL to an outsourced company's web site... what I want
to do is record the form input locally into a CSV file as well... any
suggestions on how to accomplish this with a single form and click.

thanks
Jay


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

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



Re: CF Navigation

2001-06-21 Thread phumes1


I'm looking for a menu navigation for a site that is similar to the windows 
environment.

Does anyone know of some nice ones?


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

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



RE: Problem with radio buttons #2

2001-06-21 Thread Sicular, Alexander

post the code

Alexander Sicular
Chief Technology Architect
The Neurological Institute of New York
Columbia University
212.305.1318
as867 {at} columbia [dot] edu


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 3:00 PM
> To: CF-Talk
> Subject: Problem with radio buttons #2
> 
> 
> Hi,
> 
> A while back, I wrote to this list about a problem with 
> checked radio buttons I'd been having, in that some were 
> showing as checked, while others were not.  In each case the 
> code used was the same, as I'd copied and pasted it, only 
> changing field names.
> 
> I'd been advised that I probably had nesting problems on the 
> form, and that I should validate the form.  I did so, and 
> corrected all errors that were discovered.  However, the 
> problem with the checked radio buttons not showing as checked 
> has continued.  What else should I consider, to solve this problem?
> 
> Hubert
> ---
> Hubert Earl
> 
> ICQ#: 16199853
> 
> My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as
US$7.50 each, less if you purchase 2 or more. Also being sold:  the
Genealogy of Jamaica CD-ROM
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: Is it possible to break out the code in a table from a file that is read in

2001-06-21 Thread Bill Davidson

I think the easiest way to do it is to modify the file slightly so that the
 for that piece of that table is different, so you can find it, like do
, which is perfectly legal, but it is different from the other 's
(or use a title="key" attribute or something).

", variable_that_contains_the_table_code) + 5>
", variable_that_contains_the_table_code,
begin_pos) -1>


Something like that should work.  I think.  If you use a different qualifier
instead of , just replace that bit.

-Bill
brainbox

- Original Message -
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 11:52 AM
Subject: Is it possible to break out the code in a table from a file that is
read in


> I sent this post yesterday and did not receive any kind of response, so I
> wanted to try once more.  Excuse me if it is too simple, but I am puzzled
on
> it.
>
> I have a file that has the code in it for a table.
> Is there a way that I can break out this table code into say q query or
> something that can be used?  I only want parts of the table code.
>
> For instance:
> 
>   
> Header
> Code1
> Code2
>   
> 
> I wan to be able to extract only the Code 2 cells of each row in the
table.
>
> Hope this makes sense.
>
> TIA
>
>
> Larry Juncker
> Senior Cold Fusion Developer
> Heartland Communications Group, Inc.
> [EMAIL PROTECTED]
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Foreign Key Constraint

2001-06-21 Thread Bryan Love

impossible.  You can set this DB schema up if you like, but you CANNOT
create a legitimate foreign key - the DB enforces all foreign keys strictly
at the time of the transaction.

This sounds fundamental - you may want to re-evaluate your schema (perhaps
put DEcisionID foreign key in the Appt_2 table?).


Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]



-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 9:03 AM
To: CF-Talk
Subject: Foreign Key Constraint





I have 2 tables - tblAppointment_1 and tblAppointment_2.  I want to set up a

foreign key in appointment_1 to connect it to Appointment_2.  My question 
is, if the Appointment_1 record is created a few weeks before Appointment_2,

will this be a problem because the foreign key will be null for a period of 
time?  ie...appt_1 record is created first.  Then, after some time, Appt_2 
record is created and appt_1 record is updated(inserting the CASACID).

Appt_1 Appt_2

DEcisionID(PrimaryKey)CasacID(PrimaryKey)
date  date
firstname outcome
lastname
CASACID(ForeighKey)
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Mysteriously vanishing application variables

2001-06-21 Thread Bryan Love

You shouldn't use the STRUCTCLEAR() function because you are inadvertantly
deleting application.applicationName.  Application.applicationName is a
variable that is ONLY created the FIRST time a  tag is
used with a unique name.  In other words it's created the first time the
application is run and if you delete it then it won't be created again
UNLESS you change the application name OR restart the server.  

I'm not sure how the absence of this variable affects the CF server, but you
can bet it's not good.  CF needs this variable to run an application
properly, but to what extent I'm not sure.

to see what I mean put this code immediately after your CFAPPLICATION tag
and CHANGE THE NAME OF THE APPLICATION:



#i#




You'll notice the first time you run the new code
APPLICATION.APPLICATIONNAME is the created, but your STRUCTCLEAR() deletes
it and it does not appear again for subsequent requests.

Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]



-Original Message-
From: Stuart Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 9:09 AM
To: CF-Talk
Subject: Mysteriously vanishing application variables


Hello,

I have an application that seems to mysteriously lose it's application
variables and then throws the 'parameter cannot be resolved' error.
Shouldn't be due to timing out because the problem will pop up in the middle
of a session. Anyway, there is code that checks for
IsDefined(APPLICATION.GlobalsDefined) and sets them if not. When the page is
refreshed, the application variables are back. The problem only occurs
rarely and seemingly at random. I know that doesn't help, but I'm
stumped

Here's the code:




  















StructClear( APPLICATION );










Anyone else have this happen to them?

Thanks in advance.

--Stuart


Stuart Miller   
Rocom New Media
t: 01937 487492
e: [EMAIL PROTECTED]
w: http://www.rocom.co.uk   



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

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

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



RE: CF-Talk-list V1 #38

2001-06-21 Thread Ron Hornbaker

I've seen about 3 messages in the last several days. MD says DNS is to
blame. (?)

-Ron

> -Original Message-
> From: Cameron [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 3:56 PM
> To: CF-Talk
> Subject: Re: CF-Talk-list V1 #38
>
>
> Hmmm, is something up with the list?
>
> Cause usually I get atleast one large (>40K) digest a day,
> usually a few small ones too.
>
> But yesterday I had no emails, & today I get digest #38 with
> only one message. & last Tuesday (list time) I got three small
> digests (biggest was 6K)...
>
> Seems the list is a lot slower at the moment for some strange reason...
>
> Cameron


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

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



Re: CF-Talk-list V1 #38

2001-06-21 Thread Michael Dinowitz

The list is still strange because of the DNS. I have the old box still up to
catch those who can't get to the new one and that sounds like where you are.
Do a ping of HoF and you'll probably see 207.31.122.140 which is the old
address. You should start seeing the new box any time now.


Hmmm, is something up with the list?

Cause usually I get atleast one large (>40K) digest a day, usually a few
small ones too.

But yesterday I had no emails, & today I get digest #38 with only one
message. & last Tuesday (list time) I got three small digests (biggest was
6K)...

Seems the list is a lot slower at the moment for some strange reason...

Cameron

- Original Message -
From: "CF-Talk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 3:10 AM
Subject: CF-Talk-list V1 #38


> CF-Talk-list   Thu, 21 Jun 2001   Volume 1 :
Number 38
>
> In this issue:
>
> Re: encrypt credit card field?
>
>
> --
>
> Date: Thu, 21 Jun 2001 22:31:01 +0800
> From: "Kay Smoljak" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Subject: Re: encrypt credit card field?
> Message-ID: <[EMAIL PROTECTED]>
>
> Tom,
>
> Have a look at our cfx_pwcardcrypt tag, http://developer.perthweb.com.au.
We
> designed it for a client storing cc numbers for monthly subscriptions, it
> uses RSA public key crypto.
>
> HTH,
> K.
>
> On Thu, 21 Jun 2001 08:43:19 -0500, "Tom Davison"
<[EMAIL PROTECTED]>
> wrote:
> >How would you go about securing credit card info in an access database?
Is
> it possible?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Multi Lingual websites /chinese/english/french

2001-06-21 Thread Brook Davies

A client has asked me to create  a multi lingual site. I have no experience 
doing this. The site would be using SQL Server 7.0 and IIS4.0 CF 4.5 maybe 5.0.

What do I need to look out for? What are the technical issues surrounding 
storing Chinese characters in a database and rendering them to the screen? 
Thanks!

Brook Davies
Maracasmedia Inc.


At 08:55 AM 22/06/01 +1200, you wrote:
>Hmmm, is something up with the list?
>
>Cause usually I get atleast one large (>40K) digest a day, usually a few 
>small ones too.
>
>But yesterday I had no emails, & today I get digest #38 with only one 
>message. & last Tuesday (list time) I got three small digests (biggest was 
>6K)...
>
>Seems the list is a lot slower at the moment for some strange reason...
>
>Cameron
>
>- Original Message -
>From: "CF-Talk" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, June 22, 2001 3:10 AM
>Subject: CF-Talk-list V1 #38
>
>
> > CF-Talk-list   Thu, 21 Jun 2001   Volume 1 : 
> Number 38
> >
> > In this issue:
> >
> > Re: encrypt credit card field?
> >
> >
> > --
> >
> > Date: Thu, 21 Jun 2001 22:31:01 +0800
> > From: "Kay Smoljak" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Subject: Re: encrypt credit card field?
> > Message-ID: <[EMAIL PROTECTED]>
> >
> > Tom,
> >
> > Have a look at our cfx_pwcardcrypt tag, 
> http://developer.perthweb.com.au. We
> > designed it for a client storing cc numbers for monthly subscriptions, it
> > uses RSA public key crypto.
> >
> > HTH,
> > K.
> >
> > On Thu, 21 Jun 2001 08:43:19 -0500, "Tom Davison" 
> <[EMAIL PROTECTED]>
> > wrote:
> > >How would you go about securing credit card info in an access 
> database?  Is
> > it possible?
> >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: SQL Server DTS question MORE INFO

2001-06-21 Thread Jeff Green


I removed all the triggers associated with the HostAdID field.  The ExitID
field stated to give the the same trouble, so I had to remove all triggers
on that field as well.  And it worked fine, anyone any idea why I had to
remove the triggers?

jeff

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 12:52 PM
To: CF-Talk
Subject: OT: SQL Server DTS question


Hi all got a SQL Server DTS question for ya

Im trying to DTS my DB from my dev SQL to production SQL.

Im this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name'HostAdID'

Is HostAdID some sort of reserved word?

When I do this DTS I transfer objects not just tables. (I want my triggers
and all that good stuff)
btw - even when this does work my relationship properties dont get
transfered

So I renamed the column to AHID and it still breaks, Im thinking cause of a
trigger or something maybe?

When I strictly just copy the tables it works fine, even with my column
named HostAdID.

Can anyone offer me any advice?

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

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



RE: IIF vs if,else

2001-06-21 Thread Bryan Love

it's not.  I've never found a reason to use IIF over CFIF.  It's only saving
grace is that when you are using an IF statement to set attributes inside a
 tag (like CLASS=), IIF won't cause Studio to screw up the color scheme
of your code.

;)


Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]



-Original Message-
From: Cameron [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 4:03 PM
To: CF-Talk
Subject: IIF vs if,else


Ok, after a bit of testing... can anyone tell me what the advantage of IIF
over if ( or if () {}), else ( or else {}).

I tested a simple block of code using IIF and  & IIF
ran twice as slow...

I can't see any major advantage by using it... yeah, it is kinda similar to
i = (true?1 : 2); in javascript but it's really slow case of the implicit
evaluate() on each part. Would be better if it was implicit & made explicit,
IF NEEDED.

Can anyone give me a decent reason why IIF is better that ?

Cameron Junge
Web Developer
Strongnet
[EMAIL PROTECTED]
http://www.strongnet.co.nz
Ph: +64 9 414 2492
Fax: +64 9 414 2960

"You play with a Mac until you break it,
You play with a PC until it works."


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

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

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



Re: CF-Talk-list V1 #38

2001-06-21 Thread Cameron

Hmmm, is something up with the list?

Cause usually I get atleast one large (>40K) digest a day, usually a few small ones 
too.

But yesterday I had no emails, & today I get digest #38 with only one message. & last 
Tuesday (list time) I got three small digests (biggest was 6K)...

Seems the list is a lot slower at the moment for some strange reason...

Cameron

- Original Message - 
From: "CF-Talk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 3:10 AM
Subject: CF-Talk-list V1 #38


> CF-Talk-list   Thu, 21 Jun 2001   Volume 1 : Number 38
> 
> In this issue:
> 
> Re: encrypt credit card field?
> 
> 
> --
> 
> Date: Thu, 21 Jun 2001 22:31:01 +0800
> From: "Kay Smoljak" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Subject: Re: encrypt credit card field?
> Message-ID: <[EMAIL PROTECTED]>
> 
> Tom,
> 
> Have a look at our cfx_pwcardcrypt tag, http://developer.perthweb.com.au. We
> designed it for a client storing cc numbers for monthly subscriptions, it
> uses RSA public key crypto.
> 
> HTH,
> K.
> 
> On Thu, 21 Jun 2001 08:43:19 -0500, "Tom Davison" <[EMAIL PROTECTED]>
> wrote:
> >How would you go about securing credit card info in an access database?  Is
> it possible?
> __
> Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
> Internet Solutions for your business!
> 
> Level 9/105 St George's Tc - Perth - Western Australia
> Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
> Visit Perth online! : www.perthweb.com.au
> 
> Tools for developers: http://developer.perthweb.com.au
> -- cfx_pwimageproc: image processing tool
> -- cfx_pwcardcrypt: credit card validation and encryption
> 
> --
> 
> End of CF-Talk-list V1 #38
> **
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> 


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



Problem with radio buttons #2

2001-06-21 Thread hearl

Hi,

A while back, I wrote to this list about a problem with checked radio buttons I'd been 
having, in that some were showing as checked, while others were not.  In each case the 
code used was the same, as I'd copied and pasted it, only changing field names.

I'd been advised that I probably had nesting problems on the form, and that I should 
validate the form.  I did so, and corrected all errors that were discovered.  However, 
the problem with the checked radio buttons not showing as checked has continued.  What 
else should I consider, to solve this problem?

Hubert
---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as US$7.50 each, 
less if you purchase 2 or more. Also being sold:  the Genealogy of Jamaica CD-ROM




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

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



Quote in query string.

2001-06-21 Thread Erika Foster

I have a query that is 'archiving' posts in my discussion forums.  The
problem is - if the message starts out with a ' or a " then I get a syntax
error when executing my insert query.

How do I get around this?  Thanks!

Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]


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

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



OT: SQL Server DTS question

2001-06-21 Thread Jeff Green

Hi all got a SQL Server DTS question for ya

Im trying to DTS my DB from my dev SQL to production SQL.

Im this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name'HostAdID'

Is HostAdID some sort of reserved word?

When I do this DTS I transfer objects not just tables. (I want my triggers
and all that good stuff)
btw - even when this does work my relationship properties dont get
transfered

So I renamed the column to AHID and it still breaks, Im thinking cause of a
trigger or something maybe?

When I strictly just copy the tables it works fine, even with my column
named HostAdID.

Can anyone offer me any advice?

Thanks in advance,
Jeff


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

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



OT: RIM / Go.America Support Forum

2001-06-21 Thread Steve Reich

Hello developers

Due to a lack of peer resources, I have started a mailing list specifically
for those developing web content for the RIM 850/950 Pager and RIM 857/957
Handheld. This is primarily focused towards development on GoAmerica's
Go.Web platform, but not limited to such. Topics include integration with
application servers (such as CF, ASP, PHP, CGI), graphics, layout, user
security, navigation, session strategies, etc. I would highly recommend to
anyone doing development for these devices to come and join me at RIMZOO!

Home Page: http://groups.yahoo.com/group/RIMZOO
Post message: [EMAIL PROTECTED]
Subscribe:  [EMAIL PROTECTED]
Unsubscribe:  [EMAIL PROTECTED]
List owner:  [EMAIL PROTECTED]

For more information on the Go.Web SDK and RIM emulator, check out
http://www.goamerica.net/partners/developers/. Please pass this on to anyone
who you feel may benefit from it. If you have questions or comments, please
feel free to contact me off list.


Thanks,
Steve Reich


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

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



Re: Duplicate name conflict error message

2001-06-21 Thread Michel Gagnon

Do you have a CFInserted document?

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 2:30 PM
Subject: Duplicate name conflict error message


> Hi,
>
> I'm getting a 'Duplicate name conflict' error message.  I'm unable to
solve it, because the code in which it is appearing is over 1,000 lines
long.  Also, the error message states:
> "The error occurred while processing an element with a general identifier
of (CFINPUT), occupying document position (380:1) to (381:39)."
>
> This doesn't help me, because line 280 contains only the code  and
line 381 is completely blank, with nothing on it at all.  I don't
understand, therefore, how the message could refer to line 381, position 39.
>
> I'd appreciate any advice as to how to solve the error.
>
> Hubert
>
> ---
> Hubert Earl
>
> ICQ#: 16199853
>
> My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
> Check out the art print bargains available! Beautiful prints as low as
US$7.50 each, less if you purchase 2 or more. Also being sold:  the
Genealogy of Jamaica CD-ROM
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Basket problem

2001-06-21 Thread Michel Gagnon

Hi!

I have a small problem.
I have a delete button set up that deletes
items in the basket.  Only that if the person 
accidentally added the same item twice and want to remove one,
it deletes both.















Is there another way of doing this?

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

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



Re: Duplicate name conflict error message

2001-06-21 Thread James Taavon


It is probably because you have two form elements with the same name.
Hope that helps.




[EMAIL PROTECTED] wrote:
> 
> Hi,
> 
> I'm getting a 'Duplicate name conflict' error message.  I'm unable to solve it, 
>because the code in which it is appearing is over 1,000 lines long.  Also, the error 
>message states:
> "The error occurred while processing an element with a general identifier of 
>(CFINPUT), occupying document position (380:1) to (381:39)."
> 
> This doesn't help me, because line 280 contains only the code  and line 381 is 
>completely blank, with nothing on it at all.  I don't understand, therefore, how the 
>message could refer to line 381, position 39.
> 
> I'd appreciate any advice as to how to solve the error.
> 
> Hubert
> 
> ---
> Hubert Earl
> 
> ICQ#: 16199853
> 
> My Jamaican Art, Craft & More Online Store: 
>http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
> Check out the art print bargains available! Beautiful prints as low as US$7.50 each, 
>less if you purchase 2 or more. Also being sold:  the Genealogy of Jamaica CD-ROM
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



CFX_GIFGD on Linux?

2001-06-21 Thread Evan Lavidor

Does anyone know if there's a CFX tag with the features of CFX_GIFGD or
CFX_IMAGE that runs on CF Linux?

Thanks,

Evan

--
-=-=-=-=-=-=-=-=-=-
Evan Lavidor
Circle.com Boston
Tel: 617-585-3107
Fax: 617-585-3091
-=-=-=-=-=-=-=-=-=-


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

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



Test

2001-06-21 Thread Michael Ross

Not getting any emails just testing to see if I get this..


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

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



Problem with

2001-06-21 Thread Tom Espen Pedersen

We've encountered a problem on one of our customers servers.
We use  to grab a wddx packet from an outside the house server.
This has worked perfectly up until tuesday 19th.
The error we get is : Connection Failure

we suspected this to be a bug in CF 4.5 so we upgraded the server to 4.5.1
sp2.

Has anyone encountered errors like this ? and how did you solve them ?
A reinstall of CF server is the last thing we wanna do since they've got
alot of services running on that machine.

Sincirely
Tom Espen Pedersen
[EMAIL PROTECTED]



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

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



Oracle Full text search

2001-06-21 Thread Kevan . Windle

Does Oracle have any full text search facility? I can't find any mention of
it anywhere. 


**

The opinions expressed in this E-mail are those  of  the individual  and
not  necessarily  the  company.  This E-mail and  any files transmitted 
with it are confidential and solely for the use of the intended recipients

**

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

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



cfx_pwcardcrypt (was: encrypt credit card field?)

2001-06-21 Thread Bud

On 6/21/01, Kay Smoljak penned:
>Tom,
>
>Have a look at our cfx_pwcardcrypt tag, http://developer.perthweb.com.au. We
>designed it for a client storing cc numbers for monthly subscriptions, it
>uses RSA public key crypto.

Cool. Are there any licensing caveats? I purchased CFX_PGP a year or 
so ago, built some nice stuff to use it, and then find out it's 
16,000 for a PGP commercial license.
-- 

Bud Schneehagen - Tropical Web Creations

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

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

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



Duplicate name conflict error message

2001-06-21 Thread hearl

Hi,

I'm getting a 'Duplicate name conflict' error message.  I'm unable to solve it, 
because the code in which it is appearing is over 1,000 lines long.  Also, the error 
message states: 
"The error occurred while processing an element with a general identifier of 
(CFINPUT), occupying document position (380:1) to (381:39)."

This doesn't help me, because line 280 contains only the code  and line 381 is 
completely blank, with nothing on it at all.  I don't understand, therefore, how the 
message could refer to line 381, position 39.

I'd appreciate any advice as to how to solve the error.

Hubert

---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as US$7.50 each, 
less if you purchase 2 or more. Also being sold:  the Genealogy of Jamaica CD-ROM




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

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



display problem

2001-06-21 Thread S R

I am trying to out put this variable and I keep getting a 'error resolving 
parameter ROW' error. I don't understand it. Here's my code:
 
                         
 Members

list here
#roleId#
#EprUser.GetEventOutput("CallListParticipantsInRole", "Success")#
#EprUser.TableRows("Rst_Table")#
  #EprUser.TableData("Rst_Table", row, "LoginID")#   thanks for your helpGet your FREE download of MSN Explorer at http://explorer.msn.com";>http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Mysteriously vanishing application variables

2001-06-21 Thread Andrew Tyrone

What could be happening is that you are setting an application variable somewhere 
other than your application.cfm file(s) and trying to read it in another template.  If 
the application times out, then that application variable wouldn't exist on the 
execution of the said template, but all the application vars you set after you checked 
to see if the APPLICATION.GlobalsDefined variable was defined WOULD exist.  In a 
nutshell, are you reading an application var that no default is being set for in your 
application.cfm file(s) ?  If so change your timeout but more importantly make sure 
your app vars are accounted for to avoid this problem.

-Andy

> -Original Message-
> From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 12:39 PM
> To: CF-Talk
> Subject: RE: Mysteriously vanishing application variables
> 
> 
> You are setting app variables to timeout in one hour.  A more typical
> setting would be measured in days.  Typically the 2 day default is what i
> use.  Try increasing the setting a little (CreateTimeSpan( 2, 0, 
> 0, 0 )) and
> I think your problem will go away.
> 
> -Cameron
> 
> 
> Cameron Childress
> elliptIQ Inc.
> p.770.460.7277.232
> f.770.460.0963
> 
> Join the ColdFusion Mafia!
> http://stats.distributed.net/rc5-64/tmsummary.php3?team=865184487
> 
> 
> 
> 
> > -Original Message-
> > From: Stuart Miller [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, June 21, 2001 12:09 PM
> > To: CF-Talk
> > Subject: Mysteriously vanishing application variables
> >
> >
> > Hello,
> >
> > I have an application that seems to mysteriously lose it's application
> > variables and then throws the 'parameter cannot be resolved' error.
> > Shouldn't be due to timing out because the problem will pop up in
> > the middle
> > of a session. Anyway, there is code that checks for
> > IsDefined(APPLICATION.GlobalsDefined) and sets them if not. When
> > the page is
> > refreshed, the application variables are back. The problem only occurs
> > rarely and seemingly at random. I know that doesn't help, but I'm
> > stumped
> >
> > Here's the code:
> >
> > 
> >  >clientmanagement="Yes"
> >setclientcookies="No"
> >applicationtimeout="#CreateTimeSpan( 0, 1, 0, 0 )#"
> >clientstorage="ClientVars">
> >
> > 
> >
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > 
> >
> > 
> >  >  throwontimeout="Yes"
> >  name="STOAT_APP_GLOBALS"
> >  type="EXCLUSIVE">
> >
> > 
> > 
> > StructClear( APPLICATION );
> > 
> >
> > 
> >
> > 
> >
> > 
> >
> > 
> >
> > Anyone else have this happen to them?
> >
> > Thanks in advance.
> >
> > --Stuart
> >
> >
> > Stuart Miller
> > Rocom New Media
> > t: 01937 487492
> > e: [EMAIL PROTECTED]
> > w: http://www.rocom.co.uk
> >
> >
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: SQL question

2001-06-21 Thread Chad Gray

AH i didnt know you could use parentheses!  Cool... thanks for the help!




At 10:48 AM 6/21/2001 -0700, you wrote:
>it's because of the way you've structured the query.
>
>SQL is reading it like this:
>
>WHERE
>
>hidden = 1 AND DIM <= 200 AND COLOR1 = 'gold'
>
>OR
>
>COLOR2 = 'gold' AND WKSTN >= 2
>
>so your output of COLOR2=gold and WKSTN=4 is right in line with the 2nd half
>of the OR query.
>
>you should have:
>
>where hidden = 1 AND
> DIM <= 200 AND
> WKSTN >= 2 AND
> (COLOR1 = 'gold' OR
> COLOR2 = 'gold')
>
>i think that should do it.
>
>-Original Message-
>From: Chad Gray [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, June 21, 2001 10:33 AM
>To: CF-Talk
>Subject: SQL question
>
>
>Im wondering why this SQL statement would bring up results where DIM is
>greater then 200?  I think it has something to do with the OR statement,
>but i dont know why.
>
>Select *
>from products
>where hidden = 1 AND
> DIM <= 200 AND
> COLOR1 = 'gold' OR
> COLOR2 = 'gold' AND
> WKSTN >= 2
>
>
>
>Here is my Output:
>ProductID : 3
>Dim : 600
>Color1 : blue
>Color2 : gold
>WKSTN : 4
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: SQL question

2001-06-21 Thread Mark Warrick

H

Try this:

Select *
from products
where hidden = 1
AND DIM <= 200
AND (COLOR1 = 'gold' OR COLOR2 = 'gold')
AND WKSTN >= 2


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
 

> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 10:33 AM
> To: CF-Talk
> Subject: SQL question
> 
> 
> Im wondering why this SQL statement would bring up results where DIM is 
> greater then 200?  I think it has something to do with the OR statement, 
> but i dont know why.
> 
> Select *
> from products
> where hidden = 1 AND
>   DIM <= 200 AND
>   COLOR1 = 'gold' OR
>   COLOR2 = 'gold' AND
>   WKSTN >= 2
> 
> 
> 
> Here is my Output:
> ProductID : 3
> Dim : 600
> Color1 : blue
> Color2 : gold
> WKSTN : 4
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: SQL question

2001-06-21 Thread Don Vawter

Because you havent forced it to alter natural precedence

Try:

Select *
from products
where hidden = 1 AND
DIM <= 200 AND
( COLOR1 = 'gold' OR COLOR2 = 'gold' )
AND
WKSTN >= 2

(I have to ASSume that is what you want)

The rule I follow is: Parentheses are cheap. Use freely.



- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 11:33 AM
Subject: SQL question


> Im wondering why this SQL statement would bring up results where DIM is
> greater then 200?  I think it has something to do with the OR statement,
> but i dont know why.
>
> Select *
> from products
> where hidden = 1 AND
> DIM <= 200 AND
> COLOR1 = 'gold' OR
> COLOR2 = 'gold' AND
> WKSTN >= 2
>
>
>
> Here is my Output:
> ProductID : 3
> Dim : 600
> Color1 : blue
> Color2 : gold
> WKSTN : 4
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: SQL question

2001-06-21 Thread Dylan Bromby

it's because of the way you've structured the query.

SQL is reading it like this:

WHERE

hidden = 1 AND DIM <= 200 AND COLOR1 = 'gold'

OR

COLOR2 = 'gold' AND WKSTN >= 2

so your output of COLOR2=gold and WKSTN=4 is right in line with the 2nd half
of the OR query.

you should have:

where hidden = 1 AND
DIM <= 200 AND
WKSTN >= 2 AND
(COLOR1 = 'gold' OR
COLOR2 = 'gold')

i think that should do it.

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 10:33 AM
To: CF-Talk
Subject: SQL question


Im wondering why this SQL statement would bring up results where DIM is
greater then 200?  I think it has something to do with the OR statement,
but i dont know why.

Select *
from products
where hidden = 1 AND
DIM <= 200 AND
COLOR1 = 'gold' OR
COLOR2 = 'gold' AND
WKSTN >= 2



Here is my Output:
ProductID : 3
Dim : 600
Color1 : blue
Color2 : gold
WKSTN : 4
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



SQL question

2001-06-21 Thread Chad Gray

Im wondering why this SQL statement would bring up results where DIM is 
greater then 200?  I think it has something to do with the OR statement, 
but i dont know why.

Select *
from products
where hidden = 1 AND
DIM <= 200 AND
COLOR1 = 'gold' OR
COLOR2 = 'gold' AND
WKSTN >= 2



Here is my Output:
ProductID : 3
Dim : 600
Color1 : blue
Color2 : gold
WKSTN : 4


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

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



RE: making list update dynamic

2001-06-21 Thread Mark Warrick

Can we see the database schema?


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 9:03 AM
> To: CF-Talk
> Subject: making list update dynamic
>
>
>
>  I have made some pages that display in columns and are
> updatable. There are
> actually over 50 entries they can make which are split between several
> pages. To update just the page the user is editing I have hardcoded the
> point on the list that should be updated. Well if all
> stayed exactly the same this would be fine. However, I need to make this
> more robust.
>
>  1. I will be having 4 different user groups that will need to update only
> their information. Each group has a different amount of entries to
> update. So for each group I currently would have to do a separate set of
> hardcoded if/else statements.
> 2. It is set up that if there is a change in one section it throws all my
> index(skilloffset) numbers off. They need to be able to add/subtract
> change what they want to be updated.
> So basically I want to take the attached code and make it dynamic. The
> CourseID is used by all groups. That is the one part that is used
>  universally-it's the subgroups of this courseid that is unique to each
> group. (ie: each have reading as a course- but the reading skills are
>   differnt for each of my four groups). So I'd like to make
> it something
> like
>   
>   
>   
>
>   I keep getting when I try to make it dynamic-"indexes must always
> start with 1..." Any ideas? Thanks,
>   j
>
>   
>   
>   
>   
>
>   
>   
>
>   
>   
>
>   
>   
>
>   
>   
>   
>
>   
>   
>   
>   UPDATE Grades
>   SET GradeForSubject='#ListGetAt(attributes.GradeForSubject,X)#'
>   WHERE  PERMNUM='#CLIENT.PERMNUM#' and SkillID=#Evaluate(X +
> SkillOffset)#
>   
>   
>
> --
> --
> --
>   
>   
>   
>   
>   #Skill#
>   
>     
>   #GradeForSubject#
>   
>   
>size="5">
>   
>   
>   
>   
>   
>   
>   
>   
>   
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Mysteriously vanishing application variables

2001-06-21 Thread Cameron Childress

You are setting app variables to timeout in one hour.  A more typical
setting would be measured in days.  Typically the 2 day default is what i
use.  Try increasing the setting a little (CreateTimeSpan( 2, 0, 0, 0 )) and
I think your problem will go away.

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

Join the ColdFusion Mafia!
http://stats.distributed.net/rc5-64/tmsummary.php3?team=865184487




> -Original Message-
> From: Stuart Miller [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 12:09 PM
> To: CF-Talk
> Subject: Mysteriously vanishing application variables
>
>
> Hello,
>
> I have an application that seems to mysteriously lose it's application
> variables and then throws the 'parameter cannot be resolved' error.
> Shouldn't be due to timing out because the problem will pop up in
> the middle
> of a session. Anyway, there is code that checks for
> IsDefined(APPLICATION.GlobalsDefined) and sets them if not. When
> the page is
> refreshed, the application variables are back. The problem only occurs
> rarely and seemingly at random. I know that doesn't help, but I'm
> stumped
>
> Here's the code:
>
> 
> clientmanagement="Yes"
>setclientcookies="No"
>applicationtimeout="#CreateTimeSpan( 0, 1, 0, 0 )#"
>clientstorage="ClientVars">
>
> 
>
> 
> 
>   
>   
> 
>
> 
> 
>
>   
>   throwontimeout="Yes"
>name="STOAT_APP_GLOBALS"
>type="EXCLUSIVE">
>
>   
>   
>   StructClear( APPLICATION );
>   
>
>   
>
>   
>
>   
>
> 
>
> Anyone else have this happen to them?
>
> Thanks in advance.
>
> --Stuart
>
>
> Stuart Miller
> Rocom New Media
> t: 01937 487492
> e: [EMAIL PROTECTED]
> w: http://www.rocom.co.uk
>
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


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

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



RE: Mysteriously vanishing application variables

2001-06-21 Thread Sandy Clark

Since you aren't setting cookies, are you sure you are passing CFID/CFTOKEN
in every URL, Form Submittal and CFLocation?

Is there some specific place that it seems to lose its variables?

-Original Message-
From: Stuart Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 9:09 AM
To: CF-Talk
Subject: Mysteriously vanishing application variables


Hello,

I have an application that seems to mysteriously lose it's application
variables and then throws the 'parameter cannot be resolved' error.
Shouldn't be due to timing out because the problem will pop up in the middle
of a session. Anyway, there is code that checks for
IsDefined(APPLICATION.GlobalsDefined) and sets them if not. When the page is
refreshed, the application variables are back. The problem only occurs
rarely and seemingly at random. I know that doesn't help, but I'm
stumped

Here's the code:




















StructClear( APPLICATION );










Anyone else have this happen to them?

Thanks in advance.

--Stuart


Stuart Miller
Rocom New Media
t: 01937 487492
e: [EMAIL PROTECTED]
w: http://www.rocom.co.uk



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


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

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



making list update dynamic

2001-06-21 Thread Janine Jakim


 I have made some pages that display in columns and are updatable. There are
actually over 50 entries they can make which are split between several
pages. To update just the page the user is editing I have hardcoded the
point on the list that should be updated. Well if all
stayed exactly the same this would be fine. However, I need to make this
more robust.

 1. I will be having 4 different user groups that will need to update only
their information. Each group has a different amount of entries to
update. So for each group I currently would have to do a separate set of
hardcoded if/else statements.
2. It is set up that if there is a change in one section it throws all my
index(skilloffset) numbers off. They need to be able to add/subtract
change what they want to be updated.
So basically I want to take the attached code and make it dynamic. The
CourseID is used by all groups. That is the one part that is used
 universally-it's the subgroups of this courseid that is unique to each
group. (ie: each have reading as a course- but the reading skills are
  differnt for each of my four groups). So I'd like to make it something
like
  
  
  

  I keep getting when I try to make it dynamic-"indexes must always
start with 1..." Any ideas? Thanks,
  j 


  
  
  

  
  

  
  

  
  

  
  
  

  
  
  
  UPDATE Grades
  SET GradeForSubject='#ListGetAt(attributes.GradeForSubject,X)#'
  WHERE  PERMNUM='#CLIENT.PERMNUM#' and SkillID=#Evaluate(X +
SkillOffset)#
  
  
 

--
  
  
  
  
  #Skill#
  
    
  #GradeForSubject#
  
  
  
  
  
  
  
  
  
  
  
   

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

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



Mysteriously vanishing application variables

2001-06-21 Thread Stuart Miller

Hello,

I have an application that seems to mysteriously lose it's application
variables and then throws the 'parameter cannot be resolved' error.
Shouldn't be due to timing out because the problem will pop up in the middle
of a session. Anyway, there is code that checks for
IsDefined(APPLICATION.GlobalsDefined) and sets them if not. When the page is
refreshed, the application variables are back. The problem only occurs
rarely and seemingly at random. I know that doesn't help, but I'm
stumped

Here's the code:




  















StructClear( APPLICATION );










Anyone else have this happen to them?

Thanks in advance.

--Stuart


Stuart Miller   
Rocom New Media
t: 01937 487492
e: [EMAIL PROTECTED]
w: http://www.rocom.co.uk   



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



Re: CF 5.0 Problems?

2001-06-21 Thread Michael Dinowitz

In CF 4.x and earlier there were datasources in the allaire section of the
registry. When moving stuff over, I found that they are now stored only (or
so it seems) in the odbc.ini location. You may have to move them over in the
registry by hand. I'll look at my old and new reg at home for more info.


> I installed 5.0 and now ALL my datasources fail. Nothing has changed.
> Has this happened to anyone else?
> Kelly
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: CF 5.0 Problems?

2001-06-21 Thread Garza, Jeff

Did you by chance have the CFAS Service set to start under a user account
other than system?  I found that my CF upgrade installed the CF service
under the system account again.  Had to reset and re-start CF.  

HTH,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, June 21, 2001 8:33 AM
To: CF-Talk
Subject: CF 5.0 Problems?


I installed 5.0 and now ALL my datasources fail. Nothing has changed.
Has this happened to anyone else?
Kelly
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



CF 5.0 Problems?

2001-06-21 Thread Kelly Matthews

I installed 5.0 and now ALL my datasources fail. Nothing has changed.
Has this happened to anyone else?
Kelly

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

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



RE: Cache sp result set

2001-06-21 Thread Garza, Jeff

Yes, but you'll have to use CFQUERY to call your SP.  So that limits you to
a single result set and you cannot use CFQUERYPARAM.  Unless your
recordset(s) are really large, you're better off using CFSTOREDPROC to call
the SP.  I guess in a worst case scenario, you could store the query in a
application or session scoped variable and call it from there...

HTH,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, June 20, 2001 9:52 PM
To: CF-Talk
Subject: Cache sp result set


Is there any way to cache the result set returned by a stored proced in SQL
Server 2000, CF 5

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

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



CFQUERY and DEBUG

2001-06-21 Thread kraybill

How can I switch the DEBUG param of CFQUERY on or off, using 
a URL variable? (My hosting provider has this turned off in CF 
Administrator, and I'd like to be able to selectively display this info 
to resolve some live server issues. The query string "Mode=Debug" 
throws -- or is set to throw? -- a standard HTTP 500 error.)

You can't put the conditional clause INSIDE the opening 
CFQUERY tag, and even the following option throws an error:








SELECT * FROM Table
WHERE ID=2


Is there a way to do this short of repeating the entire CFQUERY 
statement for both conditions? 

I'm also wondering if anyone knows of a custom tag that will 
basically emulate the standard var and query debugging output, 
again for selective use in shared hosting situations. Had a look at 
the Allaire Dev Exchange, but maybe someone can recommend 
one...

Gene Kraybill

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

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



Problem with radio buttons

2001-06-21 Thread hearl

Hi,

I've built a form in which I've built radio buttons a number of times, each time with 
one of the options checked.  However, only some of the buttons show the check.  Below 
is an example of each:

no check showing:

Yes
No


check showing:

Yes
No


If the problem isn't a difference in the code between the two examples, what might be 
some other factors that I should consider?

Hubert---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as US$7.50 each, 
less if you purchase 2 or more. Also being sold:  the Genealogy of Jamaica CD-ROM




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

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



Mysteriously vanishing application variables

2001-06-21 Thread Stuart Miller

Hello,

I have an application that seems to mysteriously lose it's application
variables and then throws the 'parameter cannot be resolved' error.
Shouldn't be due to timing out because the problem will pop up in the middle
of a session. Anyway, there is code that checks for
IsDefined(APPLICATION.GlobalsDefined) and sets them if not. When the page is
refreshed, the application variables are back. The problem only occurs
rarely and seemingly at random. I know that doesn't help, but I'm
stumped

Here's the code:




  















StructClear( APPLICATION );










Anyone else have this happen to them?

Thanks in advance.

--Stuart

Stuart Miller   
Rocom New Media
t: 01937 487492
e: [EMAIL PROTECTED]
w: http://www.rocom.co.uk   



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

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



DevCon 2001 Community Site

2001-06-21 Thread Howie Hamlin

My company will be exhibiting iMS at the upcoming Macromedia DevCon 2001 October 
22-24.  Since we thought it was a good idea to set
up a community of both attendees and sponsors we created a DevCon Community site.

This site allows you to register and get the word out that you will be attending the 
conference.  You can make plans to meet other
people that you know from ColdFusion lists and also plan to attend third-party events 
that are not listed in the official Macromedia
information.  There is also a page of links to conference information including links 
to the Swan and Dolphin hotel sites.

If you want to, you can also commune with other attendees on the DevCon 2001 email 
list.  the email list is open to any DevCon
related mail.

Plan ahead and make the most of your visit to DevCon 2001!

You can join the DevCon community from:

http://www.coolfusion.com/devcon

I look forward to meeting many of you personally in October!

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server




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

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



Re: Are All Posting Getting Through To This List?]

2001-06-21 Thread Michael Dinowitz

Most, if not all of the posts from the last few days are filtering in. As
this is a reply to your message, I think the turnaround is better. :)
I remember when DNS was a 1 day affair, not a week of hell. Either I'm old
or the net is hundreds of times bigger. Or both. :)


> Well, I see that my posting of Monday "Re: IIS authentication with
> Netscape LDAP" has shown up today, Thursday.  I hope that the turn
> around time improves.  This is a very valuable discussion group which I
> am fortunate to access.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: encrypt credit card field?

2001-06-21 Thread Lanny R. Udey

Hi
I would like to say that we just started using it (and registered it). It works great 
- we looked for quite awhile to find something that did everything that this tag does. 

Lanny Udey
Hofstra University

>>> [EMAIL PROTECTED] Thursday, June 21, 2001 >>>
Tom,

Have a look at our cfx_pwcardcrypt tag, http://developer.perthweb.com.au. We
designed it for a client storing cc numbers for monthly subscriptions, it
uses RSA public key crypto.

HTH,
K.

On Thu, 21 Jun 2001 08:43:19 -0500, "Tom Davison" <[EMAIL PROTECTED]>
wrote:
>How would you go about securing credit card info in an access database?  Is
it possible?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



[Re: Are All Posting Getting Through To This List?]

2001-06-21 Thread Jerre Hale

Well, I see that my posting of Monday "Re: IIS authentication with
Netscape LDAP" has shown up today, Thursday.  I hope that the turn
around time improves.  This is a very valuable discussion group which I
am fortunate to access.


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

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



RE: How to set up jumps within a CF form?

2001-06-21 Thread Zachary S. Bedell

Your form shouldn't be making a round trip to the server like that when
you click on an anchor link.  It sounds like the browser is getting
confused.

Make sure the spelling and case of your link with the #continue on it is
EXACTLY the same as the link that gets you to the form in the first
place.  Even tho NTFS isn't case sensitive, the HTTP protocol *is*.
Browsers have to assume that DisplayForm.cfm and displayform.cfm are two
different pages.  Make sure you use the same spelling & capitalization
everywhere, and you shouldn't get the "error resolving parameter" since
the page shouldn't be sent back the server at that point anyways...

That said, the suggestion of using CFPARAM to define all the variables
you expect to get is a very good one -- you should always try to
gracefully handle any kind of end user error rather than have CF throw
up an ugly cryptic error message.

In this particular case, tho, you shouldn't ever be getting to that
error since the browser shouldn't be re-requesting this page from the
server.  It already has a copy of it in cache, and assuming all your
URLs are setup right, it'll just jump around on the page as it should.

Best regards,
Zac Bedell

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, June 20, 2001 4:45 PM
> To: CF-Talk
> Subject: Re: How to set up jumps within a CF form?
> 
> 
> Thanks.  When I used double hashes, the form worked ok.  
> However, when I clicked on the jump my computer, instead of 
> going to the target spot, read the code from the very 
> beginning of the form and coming across empty field values 
> (because, after all, I'm still making the form and I haven't 
> filled it in yet), gave me the following error message:
> 
> "Error resolving parameter CUSTFIRSTNAME
> 
> ColdFusion was unable to determine the value of the parameter."
> 
> This is a problem, because I'm building this form as a 
> demonstration, and the person evaluating it is likely to 
> check if the jump works before putting in data.  How can I 
> stop my computer from reading the code above the jump?
> 
> Hubert
> 
> ---
> Hubert Earl
> 
> ICQ#: 16199853
> 
> My Jamaican Art, Craft & More Online Store: 
> http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
> Check out the art print bargains available! Beautiful prints 
> as low as US$7.50 each, less if you purchase 2 or more. Also 
> being sold:  the Genealogy of Jamaica CD-ROM
> 
> 
> - Original Message -
> From: Don Vawter <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Wednesday, June 20, 2001 2:15 PM
> Subject: Re: How to set up jumps within a CF form?
> 
> 
> > Escape the hash -  displayform.cfm##continue
> >
> > - Original Message -
> > From: <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 20, 2001 9:43 AM
> > Subject: How to set up jumps within a CF form?
> >
> >
> > > Hi,
> > >
> > > I'd like to enable the user of a form I'm creating to be able to 
> > > jump
> from
> > one section to the other.  However, the HTML code for such a jump 
> > contains the character '#' (as in  > href="displayform.cfm#continue">) which
> the
> > CF server tries to interpret, resulting in an error message 
> (I guess 
> > it's what would be called a 'reserved' character for CF).
> > >
> > > Is there any other way to achieve such a jump, which would be 
> > > acceptable
> > to CF?
> > >
> > > Hubert
> > > ---
> > > Hubert Earl
> > >
> > > ICQ#: 16199853
> > >
> > > My Jamaican Art, Craft & More Online Store:
> > http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
> > > Check out the art print bargains available! Beautiful 
> prints as low 
> > > as
> > US$7.50 each, less if you purchase 2 or more. Also being sold:  the 
> > Genealogy of Jamaica CD-ROM
> > >
> > >
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: encrypt credit card field?

2001-06-21 Thread Kay Smoljak

Tom,

Have a look at our cfx_pwcardcrypt tag, http://developer.perthweb.com.au. We
designed it for a client storing cc numbers for monthly subscriptions, it
uses RSA public key crypto.

HTH,
K.

On Thu, 21 Jun 2001 08:43:19 -0500, "Tom Davison" <[EMAIL PROTECTED]>
wrote:
>How would you go about securing credit card info in an access database?  Is
it possible?
__
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!

Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au

Tools for developers: http://developer.perthweb.com.au
-- cfx_pwimageproc: image processing tool
-- cfx_pwcardcrypt: credit card validation and encryption



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



HELP!! VERITY is making me pull my hair out!!

2001-06-21 Thread Larzz



Does anybody have any solutions to the following problem that I am having:

I have a verity collection that pulls data out of a database.

I have one column in the database database that consists of a list of
keywords, i.e. (dead trees,Meta Lake,Meta Lake Mt. St.
Helens,mountain,Mountains,Mt. St. Helens,National
Monument,USA,volcanic,Volcano,Volcanoes,Washington State).

When I perform a search through the collection for "Mt. St. Helens", I get 0
results. Even though I know that that search string is in the database.

Any suggestions how I can get this to work.?
Thank
Jason Larson
[EMAIL PROTECTED]


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

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



Re: Are All Posting Getting Through To This List?

2001-06-21 Thread Michael Dinowitz

Back posts are starting to get through and get out. There were DNS issue
with the move.



> I sent a posting to this list on Monday the 18th and it still has not
> shown up on the list.  I am sending the posting to
> [EMAIL PROTECTED]  Is this part of the problem?
>
> Thanks,
>
> Jerre
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



encrypt credit card field?

2001-06-21 Thread Tom Davison

How would you go about securing credit card info in an access database?  Is it 
possible?  

Thanks

Tom


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

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



RE: auto downloading

2001-06-21 Thread Dylan Bromby

Try:




Of course, include the appropriate values for FILENAME (just the filename
and extension, don't include path info) and FILEPATH (full path on the drive
including the filename).


-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 5:51 AM
To: CF-Talk
Subject: auto downloading


Hi guys,

I am writing an application that allows a user to download pdf's or word
docs.

They enter their membership details, and once authorised select what type of
a particular document they want to download.

I would like the download process to start automatically as soon as they
make this selection, instead of them having to right click on a link and
selecting 'Save As' to download the file.

How would I go about this

TIA

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

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



Test ignore

2001-06-21 Thread Perez, Bismark

just a test, have not receive anything sine yesterday morning.

Bismarck Perez


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

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



Are All Posting Getting Through To This List?

2001-06-21 Thread Jerre Hale

I sent a posting to this list on Monday the 18th and it still has not
shown up on the list.  I am sending the posting to
[EMAIL PROTECTED]  Is this part of the problem?

Thanks,

Jerre


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

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



auto downloading

2001-06-21 Thread Will Swain

Hi guys,

I am writing an application that allows a user to download pdf's or word
docs.

They enter their membership details, and once authorised select what type of
a particular document they want to download.

I would like the download process to start automatically as soon as they
make this selection, instead of them having to right click on a link and
selecting 'Save As' to download the file.

How would I go about this

TIA

Will


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

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



Mail Spooling in CF5

2001-06-21 Thread river

With CF Server 4.5, the mail spool does not work perfect.  Whenever a
connection to the mail server is busy, messages get moved to Undelivr and
get stuck there forever.  Although I could run a little script that takes
care of it, I was wondering if this issue was somehow solved in CF5.  Does
anybody know?

Thanks for help.



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

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