[cisco-voip] IP Phone Services interact with an external SQLDatabase

[Aurelien FACHAUX]

Hi,

Here you will find a sample code in which I used a database connexion to get 
some data.

<%@ Language=VBScript %>

<!--#include file="connexion.inc"-->

<%
dim var_total
dim SQL, RS

SQL = "select * from TTABLE where CLAUSE_WHERE order by FIELD ASC"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.open SQL,MaConnection,0,1

RS.movefirst
while (not RS.eof)
      var_total = var_total + RS("cost")
      RS.movenext
wend
%>

<%
Response.ContentType = "text/xml"
%>

<CiscoIPPhoneText>
  <Title>Cout total</Title>
  <Prompt>Faîtes votre choix</Prompt>
  <Text><%response.write var_total%>
  </Text>
  <SoftKeyItem>
    <Name>MaJ</Name>
    <URL>SoftKey:Update</URL>
    <Position>2</Position>
  </SoftKeyItem>
  <SoftKeyItem>
    <Name>&lt;&lt;</Name>
    <URL>http://prev.asp</URL>
    <Position>1</Position>
  </SoftKeyItem>
  <SoftKeyItem>
    <Name>&gt;&gt;</Name>
    <URL>http://next.asp</URL>
    <Position>3</Position>
  </SoftKeyItem>
  <SoftKeyItem>
    <Name>Menu</Name>
    <URL>http://menu_url.asp</URL>
    <Position>4</Position>
  </SoftKeyItem>
</CiscoIPPhoneText>

<%
MaConnection.Close
Set MaConnection = Nothing
%>

I hope it will help you...

Best regards.

Aurélien.

>From: "Santiago Felipe Perez" <santiago.felipe at acens.com>
>To: <cisco-voip at puck.nether.net>
>Subject: [cisco-voip] IP Phone Services interact with an external 
>SQLDatabase
>Date: Thu, 20 Jan 2005 13:37:33 +0100
>
>  <http://www.acens.com/index.php3?acuerdo=firma>
>
>Has anybody any experience in developing ip phone services that interact
>with external SQL Databases?
>
>I have been studying the behaviour of Personal Adress Book Service in
>Callmanager and, this service, gets the data from Callmanager LDAP. I want
>to achieve the same goal but getting the data of our contacts from an
>external SQL Database.
>
>Can you recommend me any document? Have you got any .asp samples?
>
>Thanks a lot,
>
>Santiago Felipe Pérez
>Ingeniero de Redes
>acens Technologies S.A.	  email <http://www.acens.com/firma/firma03.gif>
><mailto:santiago.felipe at acens.com> santiago.felipe at acens.com    teléfono
><http://www.acens.com/firma/firma02.gif>  93 363 33 47
>
>_______________________________________________
>cisco-voip mailing list
>cisco-voip at puck.nether.net
>https://puck.nether.net/mailman/listinfo/cisco-voip

_________________________________________________________________
MSN Actions Solidaires : volontaire à l'étranger 
http://www.msn.fr/actionssolidaires/Default.asp?Ath=f