Thanks Justin :)
couple more ?'s
I havent done much with cfc's beyond the typical show, insert, delete,
update.....
ok so first ? is if the method is even correct, this is what i imagine it
should be
<!--- check to see if email is in the database --->
<cffunction name="checkSubscription"
access="public"
returntype="boolean"
hint="checks to see if email is in the database"
output="true">
<!--- define arguments --->
<cfargument name="tbl_email" type="string" required="yes">
<cfargument name="tbl_name" type="string" required="no">
<cfargument name="tbl_comments" type="string" required="no">
<cfset var dupEmail = "">
<!--- check database for email address --->
<cfquery name="dupEmail" datasource="#request.datasource#"
username="#request.username#" password="#request.password#">
SELECT tbl_email
FROM jtbl_mailingList
WHERE tbl_email = <cfqueryparam value="#tbl_email#"
cfsqltype="cf_sql_varchar">
</cfquery>
<cfreturn dupEmail.recordCount gt 0>
</cffunction>
-------------------------------------------------------------------------------------
on the subscribe page i have a form which submits to itself then checks the
existance of the form submission and creates object with form variables
<!--- if the subscribe form was submitted --->
<cfif StructKeyExists(form, "subscribe")>
<!--- invoke subscribe cfc --->
<cfset contactForm = createObject("component","rrcfc.subscribe").addSubscriber(
tbl_name="#form.name#",
tbl_email="#form.email#",
tbl_comments="#form.comments#"
)>
</cfif>
second ? is lets say it submits and the email is not found in the db how do i
get the error message back to this page and how do i call it?
also if the email is found how do i then invoke the unsubscribe() method from
the checkSubscription() method?
tia again
~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom and
abuse at the same time."
----------------------------------------
From: "Justin D. Scott" <[EMAIL PROTECTED]>
Sent: Sunday, October 30, 2005 9:59 PM
To: CF-Talk <[email protected]>
Subject: RE: cfc ?
> i cant quite figure this out
> what would be the best way to do this
There are a couple of options off the top of my head.
One would be to create a checkSubscription() method that would return a
boolean value depending on whether the e-mail address was subscribed. If it
is, call the unsubscribe method. If not, display your error. This is
probably the better choice. You can re-use the checkSubscription() method
when someone tries to join the list so it will not add a duplicate, for
example.
The other method would be to use your existing code, but prepend a bit value
to the front of your return value. Example:
After calling the method, you can check the bit value using
listFirst(unSubscriber) to determine if it was successful, and perform
whatever action was needed. Then you can listRest(unSubscriber) to
display/extract your error message.
-Justin Scott
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222698
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
