Generating a .txt document with CF

2001-06-26 Thread Michel Gagnon

Hi!

For transaction purposes, I need to generate
a text document with certain variables.

I have no idea how to do this.

TAI,

Michael


~~
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.

cfset newBasket = queryNew(ID, Quantity)

cfloop query=session.basket
!--- Add anything that isn't in the delete list ---
cfif Not(ListFind(Form.ID, ID))
cfset tmp = queryAddRow(newBasket)
cfset tmp = querySetCell(newBasket, ID, ID)
cfset tmp = querySetCell(newBasket, Quantity, quantity)
/cfif
/cfloop
!--- set the basket to the new values ---
cfset session.basket = newBasket


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 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 /TR 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



Confirming a deletion

2001-06-15 Thread Michel Gagnon

Hi!

Is there a way that we can verify that data has been found
and removed from the database?
I was thinking of using #rem.recordcount#,
but it doesn't seem to work with a delete.  Here's an example:

CFQUERY DATASOURCE=store name=rem
 DELETE FROM Listserv
 WHERE ID = #FORM.CID#
/cfquery
~~
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



Challenging dillemma (double values?)

2001-06-06 Thread Michel Gagnon

Hi!

I have a little challenging question for you.
I have a build your own computer system 
page where customers can choose what parts 
they want in their system.  There is a javascript
that calculates everything on the fly.
This javascript needs to have the price
as the value:

option value=#price##PartName#/option

But, I also need to pass the partID to the server, not the price.
Is there a way that we could have the best of both world?
The calculating javascript and the PartID's to send to the 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: Challenging dillemma (double values?)

2001-06-06 Thread Michel Gagnon

Great idea!
Why didn't I think of that?

But how do we parse variables with cold fusion?

Thanks!!

Michael

- Original Message -
From: Kevin Schmidt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 11:25 AM
Subject: Re: Challenging dillemma (double values?)


 You could put both values in the value= and then parse them out.  Have
 javascript pull the price info and CF pull out the part ID.  You could
 seperate them with a delimeter like * to make it easier.

 Kevin

 - Original Message -
 From: Michel Gagnon [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, June 06, 2001 8:16 AM
 Subject: Challenging dillemma (double values?)


  Hi!
 
  I have a little challenging question for you.
  I have a build your own computer system
  page where customers can choose what parts
  they want in their system.  There is a javascript
  that calculates everything on the fly.
  This javascript needs to have the price
  as the value:
 
  option value=#price##PartName#/option
 
  But, I also need to pass the partID to the server, not the price.
  Is there a way that we could have the best of both world?
  The calculating javascript and the PartID's to send to the 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



Shopping cart problem - no cookies, no deal

2001-06-05 Thread Michel Gagnon

Hi!

I have created a web site that uses a shopping cart.
I used the example in Ben Forta's book (2nd ed.),
chapter 24.  It states that the application.cfm
checks to see if the client browser accepts cookies.
If not, the CFID and CFTOKEN will be appended to all links in the
application...

It works perfectly when the browser's cookies options are enabled,
but if I disabled them, the item that I add to the basket apears,
but when I get another item or view the shopping cart, everything is gone.

What could be causing this?
__
Michael Gagnon


~~
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: Shopping cart problem - no cookies, no deal

2001-06-05 Thread Michel Gagnon

 I did that.  Could it be something else?

Thanks!

- Original Message -
From: Alii Design [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2001 12:46 PM
Subject: RE: Shopping cart problem - no cookies, no deal


 You need to add the CFID and CFTOKEN to every URL link and form link.
 Rich

 -Original Message-
 From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, June 05, 2001 10:53 AM
 To: CF-Talk
 Subject: Shopping cart problem - no cookies, no deal


 Hi!

 I have created a web site that uses a shopping cart.
 I used the example in Ben Forta's book (2nd ed.),
 chapter 24.  It states that the application.cfm
 checks to see if the client browser accepts cookies.
 If not, the CFID and CFTOKEN will be appended to all links in the
 application...

 It works perfectly when the browser's cookies options are enabled,
 but if I disabled them, the item that I add to the basket apears,
 but when I get another item or view the shopping cart, everything is gone.

 What could be causing this?
 __
 Michael Gagnon

~~
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: Shopping cart problem - no cookies, no deal - resolved

2001-06-05 Thread Michel Gagnon

Thanks everyone!

I found my problem, and it was a stupid mistake!!  :-(
I had CFOUTPUT tags within CFFORMS.
I had done an extended replace.  How stupid can you be.

Regards,

Michael Gagnon

- Original Message -
From: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2001 12:12 PM
Subject: Re: Shopping cart problem - no cookies, no deal


 On 6/5/01, Michel Gagnon penned:
 Hi!
 
 I have created a web site that uses a shopping cart.
 I used the example in Ben Forta's book (2nd ed.),
 chapter 24.  It states that the application.cfm
 checks to see if the client browser accepts cookies.
 If not, the CFID and CFTOKEN will be appended to all links in the
 application...
 
 It works perfectly when the browser's cookies options are enabled,
 but if I disabled them, the item that I add to the basket apears,
 but when I get another item or view the shopping cart, everything is
gone.
 
 What could be causing this?

 Check to see if the url contains cfid=cftoken=xx at the end
 of EVERY link when cookies are disabled. if not, then the session
 will die wherever you don't pass it.
 --

 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



Re: Removing items from the shopping basket?

2001-06-04 Thread Michel Gagnon

Pardon my ignorance, but how would you use arrays (or structures)
to create a basket?  I'm looking for the best, efficient, way of
doing this.

Thanks!!

Michael Gagnon


- Original Message -
From: Ben Forta [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 4:42 PM
Subject: RE: Removing items from the shopping basket?


 Michel,

 If you are going to use queries than there is no clean way to remove
rows -
 best bet would be to have another column with an active flag. To delete
 you just set it to 0 and then ignore it in further processing. The only
way
 to actually remove a row is to copy the query except for that row (which
 would not be efficient).

 If you use arrays or structures (for example) then you could remove rows
 easily.

 --- Ben


 -Original Message-
 From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 01, 2001 2:03 PM
 To: CF-Talk
 Subject: Removing items from the shopping basket?


 Hi!

 I've got a shopping basket going:

 cfset tempValue = queryAddRow(session.basket)
 cfset tempValue = querySetCell(session.basket, ID,  form.ID)
 cfset tempValue = querySetCell(session.basket, Quantity,
form.quantity)

 But I can't find the instructions on how to delete items
 from the basket.

~~
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



Removing items from the shopping basket?

2001-06-01 Thread Michel Gagnon

Hi!

I've got a shopping basket going:

cfset tempValue = queryAddRow(session.basket)
cfset tempValue = querySetCell(session.basket, ID,  form.ID)
cfset tempValue = querySetCell(session.basket, Quantity, form.quantity)

But I can't find the instructions on how to delete items 
from the basket.


~~
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



CFFTP indicator

2000-06-17 Thread Michel Gagnon

Hi!

Is there a way to add a counter or any
other indicator that shows the
client that the file is uploading
or let him know that the file has finnished
uploading?

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



CFFTP Indicator

2000-06-17 Thread Michel Gagnon

Hi!

Is there a way to add a counter or any
other indicator that shows the
client that the file is uploading
or let him know that the file has finished
uploading?

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



CFFTP upload indicator

2000-05-11 Thread Michel Gagnon

Hi!

Is there a way to add a counter or any
other indicator that shows the
client that the file is uploading?

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



CFFTP action=exists on server--give message and stop

2000-05-10 Thread Michel Gagnon

Hi!

I'm trying to get CFFTP to verify if a file already exists
on the server. If so, give a message and stop here, if not, 
go on with the rest of the code.  I know, this is probably 
so easy that I can't see it.

CFFTP  ACTION="Open"
USERNAME="user" PASSWORD="pass" 
SERVER="ftp.somewhere.com"
CONNECTION="studies"
STOPONERROR="Yes"

CFFTP  ACTION="Exists" 
CONNECTION="studies"  
ITEM="#FORM.Nom#" 
REMOTEFILE="studies/files/#FORM.nom#"

CFIF #cfftp.returnvalue# eq 1
Error, the file already exists
cfelse
Go on.
/cfif
TIA!
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFFTP, exists on server problem

2000-05-09 Thread Michel Gagnon

I'm trying to get CFFTP to verify if a file already exists
on the server. If so, stop here, if not, go on with the 
rest of the code.  I know, this is probably so easy
that I can't see it.

CFFTP  ACTION="Open"
USERNAME="user" PASSWORD="pass" 
SERVER="ftp.somewhere.com"
CONNECTION="studies"
STOPONERROR="Yes"

CFFTP  ACTION="Exists" 
CONNECTION="studies"  
ITEM="#FORM.Nom#" 
REMOTEFILE="studies/files/#FORM.nom#"

CFIF #cfftp.returnvalue# eq 1
Error, the file already exists
cfelse
Go on.
/cfif
TIA!
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Setting a variable

2000-05-03 Thread Michel Gagnon

Hi!

Is there a way to set a variable with the content of
another variable as part of the name.

Something like this, but that works.

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



To wildcard or not to wildcard (the SELECT statement)

2000-04-12 Thread Michel Gagnon

When we query with a star (*) in the SELECT statement,
does MS-Access return all the fields, even if they are empty?

I have over 50 fields in a perticuar table, but some pages only
use 3 or 4 of them.  The rest are empty.

For performances sake, am I better off using:

CFQUERY DATASOURCE="CSM" NAME="Data"
 SELECT a1,a2,a3
 FROM test
/cfquery

instead of:

CFQUERY DATASOURCE="CSM" NAME="Data"
  SELECT *
 FROM test
/cfquery

Will it make a difference in speed?
(It would be alot simpler to use the *

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



NSlookup on email domains

2000-04-07 Thread Michel Gagnon

Hi!

Is there a way that we could get Cold Fusion to
do an NSLookup of an e-mail address domain?

I was thinking of mabe using the WHOIS query
from networksolutions.

http://www.networksolutions.com/cgi-bin/whois/whois?STRING=yahoo.com

Any ideas?

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



Passing form variables through frames

2000-03-29 Thread Michel Gagnon

Hi!

Is there a way to pass form variables throught a frameset?

Tx!

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



Re: CFIF Problem with OR

2000-03-24 Thread Michel Gagnon

I tried without the quotes also

- Original Message -
From: "Fred Sanders" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 24, 2000 3:49 PM
Subject: Re: CFIF Problem with OR


 I would guess the quotes, ID is a number and your telling it a string
 - Original Message -
 From: "Michel Gagnon" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, March 24, 2000 1:47 PM
 Subject: CFIF Problem with OR


  Hi there!
 
  What is wrong with this statement?
 
  CFIF (ID IS NOT "1") OR (ID IS NOT "13") OR (ID IS NOT "4") OR (ID IS
NOT
  "43")
 
  I also tried:
 
  CFIF ID IS NOT "1,13,4,43"
 
  It executes what's inside even if ID is 43
 
  Any ideas?
 

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

 --

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

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