Search results

  1. cantvchicago

    Unable to renew licenses

    Speaking of licenses, I have a paid onPrem WIN v18 License which I'm trying to upgrade to onPrem Debian v20 but I don't want to tear my phones down without having an idea what's going to happen. I would have posted in the appropriate thread, but the forum won't let me post unless I have a paid...
  2. cantvchicago

    Upgrade to v20 methods

    I'm in the same ocean but my boat is a little different. I opted to abandon the Windows platform and host an on-prem Debian VM for 3cx. so it was a clean install. Everything went well but now I'm looking at two PBX instances on on my LAN and on 3cx.com. The new 3cx v20 on the new Debian VM...
  3. cantvchicago

    Database Access Tool for SQL integration

    FIgured it out. This works. Perfectly. Which does in fact, output THIS: [ CONCATENATE("insert into dbo.tblCallData values ('",session.ani,"','",NOW(),"','",CallerInput.Buffer,"')") ] Entering that Manually seems like it would have added something. But what ever. Just noticed your...
  4. cantvchicago

    Database Access Tool for SQL integration

    That's not shooting in the dark, Ernesto, it's trying something new. It also isn't wrong. It's also very much SQL. Assigning a value to a SQL variable (sqlInsertStatement) and then using it in subsequent queries wherever an expression is allowed, such as in a WHERE clause or in an INSERT...
  5. cantvchicago

    Database Access Tool for SQL integration

    Well, it might LOOK that way, but I assure you the room is well lit and I am taking careful aim. I'm trying different approaches to build a functional SQL Statement in the Syntax that CFD can complile correctly. I've never had to fight against it like this. I checked out the links you offered...
  6. cantvchicago

    Database Access Tool for SQL integration

    I am. It isn't working. Is there a trick to getting the expression editor to output the SQL statement I want to execute or is it just a matter of getting the expression built correctly? is the expression in the screenshot built correctly?
  7. cantvchicago

    Database Access Tool for SQL integration

    Hi Ed, Thanks for responding. Yes, In that example, directly copied from the SQL Statement field in the Database Access configuration screen, session.callid is sans quotation marks around it... ...but that was output from the Expression Editor. It wasn't a manual entry. I was under the...
  8. cantvchicago

    Database Access Tool for SQL integration

    This is what the Compiler sees. I used the expression editor for this and there appears to be an error STILL in the connection String after the Hostname. Is THIS what I'm after?
  9. cantvchicago

    Database Access Tool for SQL integration

    So I am able to run this query from my SQL Client: INSERT INTO dbo.tbldtmf ("ID", "CallTime", "DTMF") Values (12,372024,109) SQL creates a new record in the table. But this 3CX CFD Database Access SQL Statement: CONCATENATE("INSERT INTO dbo.tbldtmf (\"ID\",\"CallTime\", \"DTMF\")...
  10. cantvchicago

    Database Access Tool for SQL integration

    THIS IS the ACTUAL error thrown by 3cx when I load this CallFlow.
  11. cantvchicago

    Database Access Tool for SQL integration

    Update: NO JOY. still unable to pass data into a new record in a current table. Connection String: "Server=HOST\NamedSqlInstance;database=sqldb;UserID=sqluser;Password=sqluserpass;" Using this connection string throws and "Unexpected Escape" error at "OST\Nam". But that's the standardest...
  12. cantvchicago

    Database Access Tool for SQL integration

    Thanks Ed, Looks like I should be asking this question over in the SQL Forums. LOL! I'll give it a try. Thanks again. Jason
  13. cantvchicago

    Database Access Tool for SQL integration

    Hi All, Attempting to output CallerInput.Buffer to a new record in a table in my SQL back end... with NO luck. My flow ends with a WebService REST POST of the data to another server for further processing which works great. My problem starts with the Database Access Tool... It just does...
  14. cantvchicago

    Caller Input Valid Range Condition

    I read the three other posts about this, but need an update and more precise and complete instructions. My super simple call flow needs to limit the VALUE of the DTMF digits collected in CallerInput to a range between 1 and 108. But where do I place the conditional component? The...
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom