Created by: Phil Blette on 26-02-2010 09:03:23 PM I have logic in my CVP app that invokes SQL that creates an element data variable named STARTDATE if a record is found. I then check for the presence of the variable STARTDATE as a decision. The problem is that once it's found the first time, if the caller loops back in and goes thru the logic again, the element data variable is still there from the first time. Is there a way to delete the actual variable STARTDATE, not just clear the contents, but delete the variable?
Subject: Re: New Message from Phil Blette in Customer Voice Portal (CVP) - CVP - All Replied by: Janine Graves on 27-02-2010 06:00:58 AM That's actually a bug in the Database element, which existed in CVP 3.1, then was fixed in 4.0, and re-introduced in 4.1 and 7.0 (Now that's progress!)
The way around it is this. In the Data tab of the Database element, create the element data STARTDATE, with some initial value like ; or ~ and create it BEFORE the element executes. When that elements executes and goes to the DB, if there's no STARTDATE, then it won't overwrite the initial value. So, in your decision element, instead of testing if the STARTDATE element data exists, test if it has the initial value or not.
This only works because you're creating Element data within the Data tab of the actual Database element.
Hope this helps.
Cisco Developer Community Forums wrote: > Phil Blette has created a new message in the forum "CVP - All Versions": > > -------------------------------------------------------------- > I have logic in my CVP app that invokes SQL that creates an element > data named STARTDATE if a record is found. > I then check for the presence of STARTDATE as a decision. > The problem is that once it's found the first time, if the caller > loops back in and goes thru the logic again and the element data is > still there from the first time. > Is there a way to delete it? > -- > To respond to this post, please click the following link: > > <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2000397> > > or simply reply to this email.
Subject: RE: Re: New Message from Phil Blette in Customer Voice Portal (CVP) - CVP - Replied by: Phil Blette on 02-03-2010 04:46:16 PM Janine, Yes, that helps and it resolves the problem. Thanks for the info. Looking forward to the fix again (or not) in the next release. Phil
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
