VoiceGuide IVR Software Main Page
Jump to content

Find date between dates

Recommended Posts

Hello

We want to find if a phone is our database and have some criteria like the expiredate between 2 dates

The query is the

SELECT Tel,DateExpire,AREA,CODE,CARD,phone,Price,paratirisi,DatelastRenewal FROM Customers WHERE DateExpire between #1/1/2017# And #12/30/2017# and (tel=right('$RV_CIDNUMBER',10) or area =right('$RV_CIDNUMBER',10) or phone= right('$RV_CIDNUMBER',10))

If the query returns a row we want to go to a specific module and if not to go to other module.

The problem is that its always goes to the same module like it never find the row.

I am sending you the logs and the script.

What we have wrong?

Thank you

log.JPG

logs.zip

Share this post


Link to post

Suggest you take a look Suggest taking a look at the [ExpireDat] module's configuration.

Looks like [ExpireDat] module is set to use a (non-existing) ODBC connection.

Other database query modules in the script just specify to use C:\Expires\Syndromes.mdb database directly, without ODBC. And traces show that other modules can read that database with no problems. But [ExpireDat] module throws an error as the ODBC connector does not exist.

If you can post the "Expires 2016 2017.vgs" script file we can open in the Script Designer and point out the configuration error.

 

NB. Trace shows:
 

115134.843  6   3   2 state [ExpireDat] DB Query
115134.844  6   3   2       db    strDatabaseName=[C:\Expires\Syndromes.mdb] strDbConnectString=[ODBC;DRIVER={Microsoft Access Driver (*.mdb)}] sAdoNetFactoriesAvailable=[|System.Data.Odbc|System.Data.OleDb|System.Data.OracleClient|System.Data.SqlClient|System.Data.SQLite|Npgsql|]
115134.844  6   3   2       db    did not find ado.net data provider : C:\Expires\Syndromes.mdb
115134.844  6   3   2       db    PlayOnHoldFile
115134.844  6   3   2       moh file not specified
115134.844  6   3   2       db    using ado.net ODBC data provider : OdbcConnection/OdbcCommand/etc
115134.849  6   3   2       db    odbc  RunQuery_Odbc [ExpireDat], db=[], connect=[DRIVER={Microsoft Access Driver (*.mdb)}], sql=[SELECT Tel,DateExpire,AREA,CODE,CARD,phone,Price,paratirisi,DatelastRenewal FROM Customers WHERE DateExpire between #1/1/2017# And #12/30/2017#]
115134.849  6   3   2       odbc  DSN not specified, using a DSN-less ODBC connection.
115134.849  6   3   2       db    odbc  thread init (threadpool)
115134.849  6   3   2       db    odbc  thread started (threadpool)
115134.849  6   3   2 t     timer set   30 sec : EV_TIMEOUT_HANGUP
115134.867 15   3   2       db    odbc  connection create call.
115134.868 15   3   2       db    odbc  connection open call.
115134.875  4   3   2       db    oledb ConnectAndRun_OleDb thread completed.
115135.149 15   3   2 ERROR v0.0.0.0 (2013-05-02 23:45:07.90) ConnectAndRun_Odbc init : ERROR [IM006] [Microsoft][?????????? ???????????? ???????? ODBC] ? SQLSetConnectAttr ??? ???????????? ???????? ???????

   ?? System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   ?? System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   ?? System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
   ?? System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   ?? System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   ?? System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   ?? System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   ?? System.Data.Odbc.OdbcConnection.Open()
   ?? �.�.�()
115135.149 15   3   2       db    completed.  SqlQueryType=ERROR, RowsCount=0, sRv=
115135.149 15   3   2       db    completed. iRunWait=1, WavPlayWasStarted=0, WavPlayHasNowFinished=0
115135.149 15   3   2       db    completed. strError=ERROR [IM006] [Microsoft][?????????? ???????????? ???????? ODBC] ? SQLSetConnectAttr ??? ???????????? ???????? ???????
115135.149 15   3   2       path {ERROR [IM006] [Microsoft][?????????? ???????????? ???????? ODBC] ? SQLSetConnectAttr ??? ???????????? ???????? ???????} not found
115135.149 15   3   2       path {ERROR} not found
115135.149 15   3   2       path {error} not found
115135.149 15   3   2       FindNextVgmTitleInPathList: next module title is=[Database]
115135.150 15   3   2       RunModule_AddToTaskQueue [Database Query,[Database],11]

 

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
×