Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

How to write the information in an SQL database table?

Hi, I have a probelm on IPCC using DB WRITE command when trying to write the some information of caller into an SQL table. For example, I have two fields on the TEST table, SessionID and CallerID. After I use DB Write command on scripting, I found there was no any information inserted into the table.

Here is my SQL command used:

INSERT TEST (SessionID,CallerID) Values ('12345','AAAAA')

What's wrong with the DB Write command?

2 REPLIES
Bronze

Re: How to write the information in an SQL database table?

Hi,

I think you forgot to put in the INTO key word, the SQL insert statement should look like

INSERT INTO table-1 [(column-list)] VALUES (value-list)

so in your case it would be

INSERT INTO TEST [SessionID,CallerID] VALUES ('12345','AAAAA')

Moreover, you can test if it works from this step itself. Click the Test tab, in the 'SQL Command entered' field enter the sql command and click execute.

Check the result in the no. of Rows altered. This will confirm whether your SQL statements are working ot not.

Hope that helps.

New Member

Re: How to write the information in an SQL database table?

Thanks for your reply. The keyword of INTO is not an issue. I finally figured out. It is because of the SQL-2000 and SQL 6.0 /6.5's compatibility level issue. I used SQL-2000 SERVER

275
Views
0
Helpful
2
Replies