RESOLVED: Error clearing dynamic Client Variables.
Hey all, I figured out how to do this, and whew! It wasn't easy. And it doesn't make sense to me..but it works. I had to se the variable first, and then call it in the DeleteClientVariable function. Totally crazy, but it worked. Also, in ANOTHER deleteclientvariable statement, I had to use QUOTES around the variable name, whereas you would notice in this one I did not. More weirdness :( Here is the code for the other one which involves a WDDX thingy. (special thanks to Sandy for showing me this neat code :) ) CFIF ISDefined("client.EquipmentForm")> INSERT INTO tblEquipEntry VALUES (tblequipentry_seq.nextval,#TheMainID#,'#Evaluate('EquipmentForm.choosee quip#counter#')#',#Evaluate('EquipmentForm.hours#counter#')#) See? I had to wrap EquipmentForm in single quotes for it to work! Totally weird! :-\ -Gel ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error clearing dynamic Client Variables.
I don't understand why you need the evaluate function inside the isdefined. - Original Message - From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 3:31 PM Subject: Error clearing dynamic Client Variables. > Hi folks! > > Can anyone tell me why I am getting erorrs with this code? > > I am trying to delete all my client.comments_#whatever# variables. > > > > > > > IsDefined("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd') > #")#")> > > #Evaluate("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd') > #")#")# > > > > DeleteClientVariable("Client.Comment_#Evaluate("#DateFormat(CurrentDate, > 'mmdd')#")#")> > > > > > > > > > > The IsDefined() statement works, but the DeleteClientVariable statement > doesn't. > > IT doesn't delete anything :-\ > > -Gel > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error clearing dynamic Client Variables.
OK but wouldn't if be a lot simpler to have your isdefined like this: and why do you need all the extra evaluates etc. - Original Message - From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 1:44 PM Subject: RE: Error clearing dynamic Client Variables. > The IsDefined statement works.. > It drops into the CFIF statement correctly..and then it is supposed to > delete the client variables. > > The Deleteclientvariable is the one that isn't working. > > -Angel > > > -Original Message- > From: Don Vawter [mailto:[EMAIL PROTECTED]] > > Mixing single and double quotes in your isdefined statement > > - Original Message - > From: "Angel Stewart" <[EMAIL PROTECTED]> > > > > > > > > > > > > > > > IsDefined("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd > > ') > > #")#")> > > > > > #Evaluate("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd') > > #")#")# > > > > > > > > > DeleteClientVariable("Client.Comment_#Evaluate("#DateFormat(CurrentDat > > e, > > 'mmdd')#")#")> > > > > > > > > > >> DateFormat(#CurrentDate#,'mm/dd/')> > > > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Error clearing dynamic Client Variables.
I just had this same problem. The problem is that you are not supposed to use the word "client." in the deleteclient variable statement. For example: <--- Correct Way. instead of: <--- Wrong Way. Hope this helps. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 12:44 PM To: CF-Talk Subject: RE: Error clearing dynamic Client Variables. The IsDefined statement works.. It drops into the CFIF statement correctly..and then it is supposed to delete the client variables. The Deleteclientvariable is the one that isn't working. -Angel -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Mixing single and double quotes in your isdefined statement - Original Message - From: "Angel Stewart" <[EMAIL PROTECTED]> > > > > > > > IsDefined("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd > ') > #")#")> > > #Evaluate("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd') > #")#")# > > > > DeleteClientVariable("Client.Comment_#Evaluate("#DateFormat(CurrentDat > e, > 'mmdd')#")#")> > > > > >DateFormat(#CurrentDate#,'mm/dd/')> > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Error clearing dynamic Client Variables.
The IsDefined statement works.. It drops into the CFIF statement correctly..and then it is supposed to delete the client variables. The Deleteclientvariable is the one that isn't working. -Angel -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Mixing single and double quotes in your isdefined statement - Original Message - From: "Angel Stewart" <[EMAIL PROTECTED]> > > > > > > > IsDefined("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd > ') > #")#")> > > #Evaluate("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd') > #")#")# > > > > DeleteClientVariable("Client.Comment_#Evaluate("#DateFormat(CurrentDat > e, > 'mmdd')#")#")> > > > > >DateFormat(#CurrentDate#,'mm/dd/')> > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error clearing dynamic Client Variables.
Mixing single and double quotes in your isdefined statement - Original Message - From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 1:31 PM Subject: Error clearing dynamic Client Variables. > Hi folks! > > Can anyone tell me why I am getting erorrs with this code? > > I am trying to delete all my client.comments_#whatever# variables. > > > > > > > IsDefined("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd') > #")#")> > > #Evaluate("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd') > #")#")# > > > > DeleteClientVariable("Client.Comment_#Evaluate("#DateFormat(CurrentDate, > 'mmdd')#")#")> > > > > > > > > > > The IsDefined() statement works, but the DeleteClientVariable statement > doesn't. > > IT doesn't delete anything :-\ > > -Gel > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error clearing dynamic Client Variables.
Hi folks! Can anyone tell me why I am getting erorrs with this code? I am trying to delete all my client.comments_#whatever# variables. #Evaluate("Client.Comment_#Evaluate("#DateFormat(CurrentDate,'mmdd') #")#")# The IsDefined() statement works, but the DeleteClientVariable statement doesn't. IT doesn't delete anything :-\ -Gel ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists