VoiceGuide IVR Software Main Page
Jump to content

Indentyfing Data From Database

Recommended Posts

I try to identify null value in $RV. VG not recognizing null value getted from DB in evaluate expression.

 

How to detect null value in Evaluate Expression?

 

Other problem: in one EE module VG not detecting value to find path.

 

130837.836 7 28 10 RunModule start Evaluate, [eliminate timeout], iModuleIdx=1021, previous: vgm=1021, vgs=18:18
130837.836 7 28 10 state [eliminate timeout] Evaluate [$RV[get_menu_1_settings_managermenu_akcja]]
130837.837 7 28 10 rv replace start [$RV[get_menu_1_settings_managermenu_akcja]]
130837.837 7 28 10 rv replace end
130837.837 7 28 10 eval
130837.836 264 28 10 db odbc query completed.
130837.838 7 28 10 VGMTYPE_EVALEXPR InvokeMember Eval Exception : Exception has been thrown by the target of an invocation.
130837.838 7 28 10 eval InvokeMember Eval returned
130837.838 7 28 10 rvns add eliminate timeout_Input|SUB
130837.838 7 28 10 rvns add eliminate timeout|
130837.839 7 28 10 Eval Expr result:[]
130837.839 7 28 10 matching path not found [], try boolean paths.


131045.221 7 7 3 RunModule start Evaluate, [eliminate timeout], iModuleIdx=692, previous: vgm=692, vgs=12:12
131045.222 7 7 3 state [eliminate timeout] Evaluate [$RV[get_menu_1_settings_managermenu_akcja]]
131045.222 7 7 3 rv replace start [$RV[get_menu_1_settings_managermenu_akcja]]
131045.222 7 7 3 rv replace end [EX]
131045.223 7 7 3 eval [EX]
131045.220 274 7 3 db odbc query completed.
131045.223 7 7 3 objReturn is NULL for input=[EX], try with Cstr
131045.224 7 7 3 eval InvokeMember Eval returned
131045.224 7 7 3 rvns add eliminate timeout_Input|EX
131045.225 7 7 3 rvns add eliminate timeout|EX
131045.225 7 7 3 Eval Expr result:[EX]
131045.226 7 7 3 path {EX} found (at offset 129)
131045.226 7 7 3 FindNextVgmTitleInPathList: next module title is=[update polaczenia po txt]
131045.226 7 7 3 t timer clear (force=False)

 

In paths:

on {SUB} goto [update polaczenia po txt]
on {EX} goto [update polaczenia po txt]

Share this post


Link to post

In the Evaluate Expression module please try using quotes around the $RV being evaluated, like this:

 

"$RV[get_menu_1_settings_managermenu_akcja]"

Share this post


Link to post

With quotes working properly.

 

How to identify empty (null) value of variable )to sign "true" for path?

 

Data in database is NULL so how to store NULL in VG variable?

 

111811.609 7 28 10 eval InvokeMember Eval returned
111811.609 7 28 10 rvns add eliminate timeout_Input|""
111811.609 7 28 10 rvns add eliminate timeout|
111811.610 7 28 10 Eval Expr result:[]
111811.610 7 28 10 matching path not found [], try boolean paths.
111811.610 7 28 10 FindNextVgmTitleInPathList: next module title is=[update polaczenia po txt]
111811.610 7 28 10 matching path found (Boolean False)
111811.610 7 28 10 t timer clear (force=False)

Share this post


Link to post

Can you please post a fuller trace?

 

Looks like the path taken was the fail/false path, which seems appropriate in this case.

Any reason why you would not want to use the fail/false path?

Share this post


Link to post

In case I'm looking for "null" value and not listing any possibly value in path.

 

Or how to detect $RV has any not empty value?

Share this post


Link to post

Please post the full trace capturing the call and advise which RV is assigned the returned null data.

 

(Most likely the $RV would be actually assigned a zero-length string for any null values).

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×