Generating a .txt document with CF
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
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
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
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?)
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?)
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
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
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
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?
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?
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
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
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
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
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
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
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)
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
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
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
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.