cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
60
Views
0
Helpful
0
Comments
cdnadmin
Community Member
This document was generated from CDN thread

Created by: null on 21-09-2006 04:43:20 PM
What is the proper format for writing session or element data to a external DB? My connectivity to the external source is fine and configured properly. I just want to be able to write data that I have stored as element or session to the external database. Thanks, Angie

Subject: RE: SQL Insert in Database Element
Replied by: Michael Bochynski on 21-09-2006 09:13:54 PM
Angie,

You can use the built-in Database element to communicate with the external database. This element allows to use regular SQL queries, such as SELECT, INSERT and UPDATE, which you could use for entering data to the database.

Please refer to the Element Specifications guide for further details about the built-in Database element.

Regards,
Michael

Subject: RE: SQL Insert in Database Element
Replied by: null on 22-09-2006 05:30:57 PM
I am using the DB Element. That isn't my issue. The guide is very specific about how to retrieve data. It is the insert function that has little documentation.

Subject: RE: SQL Insert in Database Element
Replied by: Michael Bochynski on 22-09-2006 05:50:25 PM
Angie,

The INSERT function is a standard SQL statement, not a Call Services function, and specific to a database you use. Call Services will just forward the whole statement to the DB driver and your database. Hence, whatever your driver/database supports, Call Services supports as well.

I would suggest referring to the database documentation for further details on the INSET statement. If you use MySQL, you can refer to http://dev.mysql.com website for full documentation.

Hope it explains everything,
Michael
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Quick Links