Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
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.
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: