Question
sms status
Hi i have setup the sms utility and its working well sending
sms, i now need to get the status of the sms back into my system,
i am just using the main.cfc but i am not sure what to do here?
all i want to do is have a sql stored proc update my database by passing in the Status and the id number from the sent sms.
<cffunction name="onBuddyStatus">
<cfargument name="CFevent" type="struct" required="YES"/>
<cfstoredproc procedure="spUpdateStaus" datasource="#datasource#">
<cfprocparam type="In" cfsqltype="cf_sql_varchar" dbvarname="ReferenceNumber" value="#ReferenceNumber#" null="No">
<cfprocparam type="In" cfsqltype="cf_sql_varchar" dbvarname="Status" value="#Status#" null="No">
</cfstoredproc>
</cffunction>
i am just using the main.cfc but i am not sure what to do here?
all i want to do is have a sql stored proc update my database by passing in the Status and the id number from the sent sms.
<cffunction name="onBuddyStatus">
<cfargument name="CFevent" type="struct" required="YES"/>
<cfstoredproc procedure="spUpdateStaus" datasource="#datasource#">
<cfprocparam type="In" cfsqltype="cf_sql_varchar" dbvarname="ReferenceNumber" value="#ReferenceNumber#" null="No">
<cfprocparam type="In" cfsqltype="cf_sql_varchar" dbvarname="Status" value="#Status#" null="No">
</cfstoredproc>
</cffunction>
