RE: Adding User to CDOSYS Email Notification

RE: Adding User to CDOSYS Email Notification (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

evanesnard -> RE: Adding User to CDOSYS Email Notification (5/26/2006 14:38:30)
I guess I don't quite understand "setting the session". Spooky Login has always set the session for me and then I just pull whatever I want from the session. About 50 other values are available to me in that session, but for some odd reason, the column that is "AutoNumber" doesn't seem to be getting grabbed in the session. I tested that once by going into the DB and changing the column to not be AutoNumber and then the value was carried in the session.

rdouglass -> RE: Adding User to CDOSYS Email Notification (5/26/2006 14:48:21)
Can you paste any code that sets the record to being cancelled?

evanesnard -> RE: Adding User to CDOSYS Email Notification (5/26/2006 15:39:48)

The User logs into Spooky Login and they are directed to a page where a DRW is automatically ran which displays that specific User's Ads. At this point, a session is already established by Spooky Login.

Next to each one of the User's ads is a "Cancel" link which has a paramenter in it. The Cancel links looks like this:

<a href="Ad_Cancel.asp?Ad_ID=<%=FP_FieldURL(fp_rs,"Ad_ID")%>">

The user clicks on that link and it takes them to Ad_Cancel.asp and Ad_Cancel.asp has a DRW which looks like:

<%
fp_sQry="SELECT * FROM Ads WHERE (Ad_ID =  ::Ad_ID::)"
fp_sDefault="Ad_ID="
fp_sNoRecords="No records returned."
fp_sDataConn="Signup"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&UserID=3&UserName=202&Password=202&x_Firstname=202&x_Lastname=202&x_Country=202&x_City=202&x_Email=202&Advertiser_ID=202&Action_Last=202&Action_Last_Date=135&Action_Last_UserID=202&Action_History=203&Action_History_Date=203&Action_History_UserID=203&Disposition=202&Ad_Status=202&Ad_ID=3&Ad_Country=202&Ad_State=202&Ad_City=202&Ad_Category=202&Ad_Category_Details=202&Business_or_Individual=202&Company_Name=202&Individual_Name=202&Company_Formed=202&Business_Hours=202&Business_Address=202&Business_Country=202&Business_State=202&Business_City=202&Business_Zip_Code=202&Service_Type=202&Service_Details=202&Service_Area=202&Service_Qualifications=202&Service_Degrees_Certifications=202&Service_References=202&Rates=202&Payment_Terms=202&Payment_Accepted=202&Payment_Accepted_Comments=202&Contact_First_Name=202&Contact_Last_Name=202&Contact_Country=202&Contact_State=202&Contact_City=202&Contact_Zip_Code=202&Contact_Phone_1=202&Contact_Phone_2=202&Contact_Pager=202&Contact_Pager_PIN=202&Contact_Email=202&Contact_IM=202&Contact_Website=202&Contact_Time=202&Terms_Of_Use=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=9
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

Ad_Cancel.asp then goes to Ad_Cancel_Confirmation.asp which posts the actual "Cancel" update to the DB for that specific Ad_ID.

Ad_Cancel_Confirmation.asp has the following code which actually posts the Update to the record in the DB:

UPDATE Ads SET Action_Last = ::Action_Last::, Action_Last_Date = ::Action_Last_Date::, Action_Last_UserID = ::Action_Last_UserID::, Action_History = ::Action_History::, Action_History_Date = ::Action_History_Date::, Action_History_UserID = ::Action_History_UserID::, Disposition = ::Disposition::, Ad_Status = '::Ad_Status::' WHERE Ad_ID = ::Ad_ID::

rdouglass -> RE: Adding User to CDOSYS Email Notification (5/26/2006 15:44:34)
quote: Ad_Cancel_Confirmation.asp has the following code What I'm trying to say is do it anywhere on that page like this: <%session("Ad_ID") = Request("Ad_ID")%> That's all there is to it. Really. We don't need Spooky Login for that nor has it anything to do with Spooky Login. All we want to do is set the session for that Ad_ID wherever we can read it with ASP. Does that make any sense?

evanesnard -> RE: Adding User to CDOSYS Email Notification (5/26/2006 15:58:07)
Now, I'm following you. Sorry, I wasn't familiar with the statement <%session("Ad_ID") = Request("Ad_ID")%> and have never had to set a session. All of the sessions I've been using up until now have been automatically set by SL. I'm glad you've taught me how to set a session like that. Thanks and sorry for the confusion. I placed the <%session("Ad_ID") = Request("Ad_ID")%> code on the page and the Ad_ID is now displaying in the email body. Thanks again for all your patience and help on this.

rdouglass -> RE: Adding User to CDOSYS Email Notification (5/26/2006 16:11:17)
quote: Thanks again for all your patience and help on this. No prob - I'll send the next session Q your way. [:D]

evanesnard -> RE: Adding User to CDOSYS Email Notification (5/26/2006 16:48:18)
Oh, I forgot one more thing. Now that the whole function is working correctly, how do I change "user@domain.com" to the User's actual email address where there email address is recorded in x_Email DB column and that value is carried in the session? call sendEmail("me@mydomain.com","me@mydomain.com","Cancelled Ad",strText) call sendEmail ("me@mydomain.com","user@userdomain.com","Your Cancelled Ad",strText2)%> I tried this but it didn't work: call sendEmail("me@mydomain.com","Session("x_Email")","Your Cancelled Ad",strText2)%> I got: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error. More information about this error may be available in the server error log. Errr...Never mind. I got it now. I did not need the quotes around Session("x_Email") I now have the following and it's working great. call sendEmail("me@mydomain.com",Session("x_Email"),"Your Cancelled Ad",strText2)%> Thanks again

Page: << < prev 1 [2]

0.0625