Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
Go to Bottom
sp_TopicIcon
SQL Connector - MessageLog and MessageOut IDs?
sp_NewPost Add Reply sp_NewTopic Add Topic
January 25, 2016
9:01 am
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

Hello Robert,

The SQL Connector supports two fields that Diafaan SMS Server does not use and that is carried from the MessageOut to the MessageLog table, the 'UserId' field and the 'UserInfo' field. You can use either one of them to store your own message ID to keep track of the message status.

Regards, Henk

January 24, 2016
3:16 pm
Robert Covington
Guest
Guests
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

Hello,
We've been developing using the SQL connector under the assumption that when inserting a row into the MessageOut table, the @@IDENTITY you get from it will be the same as the Id in the MessageLog table. However, after some thousand incoming/outgoing messages, this does not seem to be the case anymore. Is there any way to track messages between the two tables to confirm that the message has indeed been processed, and retrieve its status code and status text?

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488