Thanks, I'm making progress now with CFHTTP and CFHTTPPARAM. One problem remains: I'd prefer for the user to see the results of the SMS send, rather than the results of the DB update which is all I can seem to get returned to the user - is there anyway to set CFHTTP to make sure all that is returned from the user is the result of the remote form post? Here is what I've got:
<cftransaction action=""> <cftry>
<CFHTTP METHOD="POST" URL=""> <CFHTTPPARAM TYPE="FormField" NAME="gw_pin" VALUE="#Form.gw_pin#">
<CFHTTPPARAM TYPE="FormField" NAME="mesg_to_send" VALUE="#Form.mesg_to_send#">
<CFHTTPPARAM TYPE="hidden" NAME="finalPage" VALUE="#Form.mesg_to_send#">
<CFHTTPPARAM TYPE="hidden" NAME="resultpage" VALUE="html/sendresult.html">
</CFHTTP>
<cfquery name="UpdateCalllogEntry" datasource="#request.app.dsn#">
UPDATE RAS.TABLE_CALL_LOG
SET X_CALL_LOG_NOTES = <cfqueryparam value="#Form.mesg_to_send#" CFSQLType="CF_SQL_CHAR">
WHERE X_CALL_LOG_ID = <cfqueryparam value="#url.logid#" CFSQLType="CF_SQL_NUMERIC">;
</cfquery>
<cfcatch type="Any">
<cfset OktoCommit = FALSE>
</cfcatch>
</cftry>
<cfif OKtoCommit>
<cftransaction action=""> <cfelse>
<cftransaction action=""> </cfif>
</cftransaction>
-----Original Message-----
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: 12 January 2004 12:51 pm
To: CF-Talk
Subject: RE: Two Destinations for POST form?
Do an initial post to a local page, then insert these details. Then you can
do a CFHTTP post to the SMS provider
HTH
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 12:47
To: CF-Talk
Subject: Two Destinations for POST form?
Afternoon all, I trust you had a good weekend?
I've got a form that sends a textarea message to an SMS service. This is
simple enough, but I want to record the very same message (and who sent it)
on the local site's database, meaning the form would have to POST to two
destinations. Is this possible? Any ideas?
Cheers,
Rob
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
