what SQL command in DB read or set command do I use to take the info gather from Get Call Contact Info ?
Any thoughts on how I can look at the first 3 digits of a calling number and do a db read ?
My table has nchar with all area codes and states listed. based on the calling number I need to look into the first 3 digits and look up state.
Calling_Number - string variable
select * from tb_State where AC = $Calling_Number
works but returns 0, as I need to only see the left 3 digits/char. if I issue the same statement in SQL query analyser with the value defined it works.
select * from tb_State where AC = LEFT(6091231234,3) it matches left 609 and returns state info.
But if the use the left statement in IPCC it throws java object error does not like anything after the $ sign with the variable.
Any thoughts on how I can look at the first 3 digits of a calling number and do a db read