SELECT * FROM history WHERE follow_date = '#today#' AND status = "Open" AND technician = "Dani"
[allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => DaniFusionWeb [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> > Serial_Number: #Serial_Number# who:#who# what:#what# resolution:#resolution# [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => aberfoylee [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> SELECT * FROM history WHERE follow_date = '#today#' AND status = "Open" AND technician = "Dani" Serializing CFML data...

Resulting WDDX packet is:

<cfoutput>#wddxText#</cfoutput> [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => DaniFusionWeb [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 10 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> SELECT * FROM history WHERE follow_date = '#today#' AND status = "Open" AND technician = "Dani" Serializing CFML data...

Resulting WDDX packet is:

<cfoutput>#info#</cfoutput> Deserializing WDDX packet...

The recordset data is:...

#Serial_Number#
#Follow_Date#
#Status#
#Technician#

The information is:

#serial_number#
#who#
#what#
#resolution#

[allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => DaniFusionWeb [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 11 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> CFSchedule, CFmail and CFoutput - Macromedia ColdFusion

CFSchedule, CFmail and CFoutput - Macromedia ColdFusion

Hi everybody. I have a simple question that I couldn't find how to solve it yet. I have set on the CF Server a scheduled task to run a Query every day at 3.00 am. This task queries the 'history' table on my 'Service' Database. Where it finds that the column 'FollowUp_Date' is equal to Today's Date, it sends an email to the technician who created that record. Since I'm not able to use the ColdFusion Server as a mail server (I couldn't figure out why), I'm passing all the query results to another page on another ColdFusion Server. My ...

  1. #1

    Default CFSchedule, CFmail and CFoutput

    Hi everybody. I have a simple question that I couldn't find how to solve it
    yet. I have set on the CF Server a scheduled task to run a Query every day at
    3.00 am. This task queries the 'history' table on my 'Service' Database. Where
    it finds that the column 'FollowUp_Date' is equal to Today's Date, it sends an
    email to the technician who created that record. Since I'm not able to use the
    ColdFusion Server as a mail server (I couldn't figure out why), I'm passing all
    the query results to another page on another ColdFusion Server. My query page
    put all the results on hidden text fields and then, by using <body
    onLoad='doent.forms[0].submit()'> the values are passed to the server. I
    have my cfoutput at the beginning of the form, so it can loop, set values and
    send as many times as records are found. But for some reason, I only get 1
    email. For some reason a cannot get more that the first record found. I'll
    attach the code, may be someone can see what I'm doing wrong. Thanks a lot

    <!--- Define variable "today" and assign today's date to it. --->
    <CFSET today = "#DateFormat(Now())#">


    <!--- Technician: Dani. We search all the records where the follow_date is
    equal to today's date, the status is open and the tech is Richard --->
    <cfquery name="sendDs" datasource="service" >

    SELECT * FROM history
    WHERE follow_date = '#today#'
    AND status = "Open"
    AND technician = "Dani"

    </cfquery>
    <cfoutput query="sendDs">
    <html>
    <head>
    <title></title>
    </head>


    <body onLoad="doent.forms[0].submit()">

    <form name="send" action="http://www.ColdFusionServer.com/trysend.cfm"
    method="POST">


    <input type="Hidden" name="Serial_Number" Value="#Serial_Number#" Size="20"
    maxlength="35" readonly>
    <input type="Hidden" name="who" Value="#who#" Size="20" maxlength="35"
    readonly>
    <input type="Hidden" name="what" Value="#what#" Size="20" maxlength="35"
    readonly>
    <input type="Hidden" name="resolution" Value="#resolution#" Size="20"
    maxlength="35" readonly>



    </form>


    </body>
    </html>
    </cfoutput>

    DaniFusionWeb Guest

  2. #2

    Default Re: CFSchedule, CFmail and CFoutput

    DaniFusionWeb wrote:
    > Hi everybody. I have a simple question that I couldn't find how to solve it
    > yet. I have set on the CF Server a scheduled task to run a Query every day at
    > 3.00 am. This task queries the 'history' table on my 'Service' Database. Where
    > it finds that the column 'FollowUp_Date' is equal to Today's Date, it sends an
    > email to the technician who created that record. Since I'm not able to use the
    > ColdFusion Server as a mail server (I couldn't figure out why), I'm passing all
    > the query results to another page on another ColdFusion Server. My query page
    > put all the results on hidden text fields and then, by using <body
    > onLoad='doent.forms[0].submit()'> the values are passed to the server. I
    > have my cfoutput at the beginning of the form, so it can loop, set values and
    > send as many times as records are found. But for some reason, I only get 1
    > email. For some reason a cannot get more that the first record found. I'll
    > attach the code, may be someone can see what I'm doing wrong. Thanks a lot
    I don't see anywhere in your code that you're doing a cfoutput or cfloop
    to loop through the query data, so it will only pull the first record.
    Were you planning on submitting the form for every email, or were you
    trying to send all the data over in a single submission?

    If you have to go this route, I'd really suggest looking into using WDDX
    to send your query object from one server to the other, and do this
    using cfhttp instead of using javascript to submit the form.
    Serializing and deserializing WDDX data is really simple and would do
    the trick far better than what it looks like you're trying to do here.

    Overall this seems like a really klunky solution. As a suggestion, I'd
    say try and figure out why you can't send email from the original
    server. There has to be a solution of some sort for that problem--you
    might ask your mail server administrator about what's going on.

    Matt

    --
    Matt Woodward
    Team Macromedia - ColdFusion
    mpwoodward *TMM* Guest

  3. #3

    Default Re: CFSchedule, CFmail and CFoutput

    Hello, It looks like you are making this more complicated than it needs to be.
    The reason why you are only receiving one email is because the cf scheduler
    runs the file once so it submits only once. Here are my suggestions: 1.
    Verify your mail settings in the cf administrator 2. Change your scheduled
    task to run trysend.cfm instead of the file you attached below. 3. Create a
    new trysend.cfm and add the following code:

    <cfquery name="sendDs" datasource="service" >
    SELECT * FROM history
    WHERE follow_date = '#DateFormat(Now())#'
    AND status = "Open"
    AND technician = "Dani"
    </cfquery>

    <cfloop query="sendDs">
    <cfmail to="johndoe.com" from="janedoe.com" subject="hello world" <!--any
    more params you have--> >
    Serial_Number: #Serial_Number#
    who:#who#
    what:#what#
    resolution:#resolution#
    </cfmail>
    </cfloop>

    aberfoylee Guest

  4. #4

    Default Re: CFSchedule, CFmail and CFoutput

    The cfoutput is at the begining of the form, after the query. I forgot to
    mention something. The database is on a local server and the trysend.cfm is on
    a remote server because I cannot set the mail server locally, it wont work.

    DaniFusionWeb Guest

  5. #5

    Default Re: CFSchedule, CFmail and CFoutput

    Thanks Matt. I'm new to WDDX. Regarding the mail server, it is really weird. I
    have my laptop with cf server and the mail server works fine. When I take my
    laptop to my office, it stops working. I have to find out the problem. Dani

    DaniFusionWeb Guest

  6. #6

    Default Re: CFSchedule, CFmail and CFoutput

    aberfoylee, thanks for your answer.

    I have my database on my local server and I'm using an external mail server. That is why it is getting a bit more complicated.

    Dani
    DaniFusionWeb Guest

  7. #7

    Default Re: CFSchedule, CFmail and CFoutput

    DaniFusionWeb wrote:
    > Thanks Matt. I'm new to WDDX. Regarding the mail server, it is really weird. I
    > have my laptop with cf server and the mail server works fine. When I take my
    > laptop to my office, it stops working. I have to find out the problem. Dani
    >
    I think I responded to that issue in an earlier post--what mail server
    are you using when you're at home, your home one or your corporate one?
    Have you talked to your corporate mail server admin about the issue?

    --
    Matt Woodward
    Team Macromedia - ColdFusion
    mpwoodward *TMM* Guest

  8. #8

    Default Re: CFSchedule, CFmail and CFoutput

    Matt May be I'm a bit confused. When I setup the mail server in the coldfusion
    administrator page, does the ISP I'm using affect it? For example, If I use
    bell at home and msn at work, will that make a difference? I had thought that
    the ISP had nothing to do with the mail server, as long as my server and the
    mail server were valids. In the other hand, is there any other way to 'submit'
    the results of a query when I'm running the query locally and the results
    should be passed to a remote page? You mentioned that I should use CFhttp
    instead of javascript to submit the form...would that fix the problem? To be
    honest, I have never used cfhttp yet. I have to learn. In my case, how should I
    use it? What I need to achieve is this: 1) The query gets the records where
    the follow up date is iqueal to today's date. 2) It sends an email for each
    record found. So the idea is: Query getDate finds 2 records, the form is
    submitted twice, the technician gets 2 emails with the info about each follow
    up he or she should do 'today'. Thanks Matt fro your help. P.S.: Do you
    charge overtime for working on Sunday? =)

    DaniFusionWeb Guest

  9. #9

    Default Re: CFSchedule, CFmail and CFoutput

    DaniFusionWeb wrote:
    > Matt May be I'm a bit confused. When I setup the mail server in the coldfusion
    > administrator page, does the ISP I'm using affect it? For example, If I use
    > bell at home and msn at work, will that make a difference? I had thought that
    > the ISP had nothing to do with the mail server, as long as my server and the
    > mail server were valids.
    Most ISPs will block access to their mail server unless you're on their
    network, hence your inability to access your home ISP's mail server from
    your office. Can't you use a different mail server while you're at
    work? Maybe I don't understand your situation, but why would you want
    to be using your home ISP's mail server when you're in the office?
    > In the other hand, is there any other way to 'submit'
    > the results of a query when I'm running the query locally and the results
    > should be passed to a remote page? You mentioned that I should use CFhttp
    > instead of javascript to submit the form...would that fix the problem?
    You would use cfhttp to post the form data. Check the livedocs for details:
    [url]http://tinyurl.com/3ztmj[/url]
    > To be
    > honest, I have never used cfhttp yet. I have to learn. In my case, how should I
    > use it? What I need to achieve is this: 1) The query gets the records where
    > the follow up date is iqueal to today's date. 2) It sends an email for each
    > record found. So the idea is: Query getDate finds 2 records, the form is
    > submitted twice, the technician gets 2 emails with the info about each follow
    > up he or she should do 'today'.
    No, you wouldn't have to submit the form twice. Here's what I'd do:

    1. Resolve your mail server issue so you don't have to do this in the
    first place. :-)

    2. If that isn't possible, run your query and use WDDX to serialize your
    query object as a WDDX packet. This query will contain ALL your data.
    You do not have to submit the form more than once; just pull all the
    data you're going to want to email once and send all this data over to
    the other server.
    [url]http://tinyurl.com/4jlxf[/url]

    3. Use cfhttp to post this WDDX data to a processing page on the other
    server.

    4. Use cfwddx again to deserialize your WDDX packet back into a query
    object.

    5. Loop through the query object and send all your emails.
    > Thanks Matt fro your help. P.S.: Do you
    > charge overtime for working on Sunday? =)
    >
    Ha--I wish! ;-) Hope this helps.

    Matt

    --
    Matt Woodward
    Team Macromedia - ColdFusion
    mpwoodward *TMM* Guest

  10. #10

    Default Re: CFSchedule, CFmail and CFoutput

    Hi Matt, good morning. Thanks for all your help. I am trying to find
    information on how to pass the WDDX packet to the page on the server by using
    the cfhttp tag. Let me show you what I'm doing, since I didn't get a good
    result.

    <!--- Define variable "today" and assign today's date to it. --->
    <CFSET today = "#DateFormat(Now())#">


    <!--- Technician: Dani. We search all the records where the follow_date is
    equal to today's date, the status is open and the tech is Dani --->
    <cfquery name="sendDs" datasource="service" >

    SELECT * FROM history
    WHERE follow_date = '#today#'
    AND status = "Open"
    AND technician = "Dani"

    </cfquery>

    <html>
    <head>
    <title></title>
    </head>


    <!--- Serialize data to WDDX format. --->
    Serializing CFML data...<p>
    <cfwddx action = "cfml2wddx" input = #sendDs# output = "wddxText">

    <!--- Display WDDX XML packet. --->
    Resulting WDDX packet is:
    <xmp><cfoutput>#wddxText#</cfoutput></xmp>

    <cfhttp
    method="POST"
    url="http://www.ColdFusionServer.com/trysend.cfm">
    <cfhttpparam
    name="ref"
    value="TEST"
    type="FORMFIELD">
    </cfhttp>

    <!--- the following code is on the coldfusionserver.com --->

    <cfwddx
    action="WDDX2CFML"
    input="#Trim( cfhttp.filecontent )#"
    output="sendDs">

    DaniFusionWeb Guest

  11. #11

    Default Re: CFSchedule, CFmail and CFoutput

    Hi Matt, I got it working locally, this is, I'm able to send the WDDX
    information to another page, deserialize it in my other page and loop thru it.
    So far so good. But as I told you, WDDX and CFHTTP is new to me. I was trying
    to find info on the internet on how to set the values in order to see the
    results also in a remote page with no luck. Here are my to pages (local):
    Could you help me please on what to modify in order to get the values on a
    remote page? Thanks

    <!--- This is my local cfm file. --->


    <!--- Define variable "today" and assign today's date to it. --->
    <CFSET today = "#DateFormat(Now())#">


    <!--- Technician: Dani. We search all the records where the follow_date is
    equal to today's date, the status is open and the tech is Richard --->
    <cfquery name="sendDs" datasource="service" >

    SELECT * FROM history
    WHERE follow_date = '#today#'
    AND status = "Open"
    AND technician = "Dani"

    </cfquery>

    <html>
    <head>
    <title></title>
    </head>


    <!--- Serialize data to WDDX format. --->
    Serializing CFML data...<p>
    <cfwddx
    action = "cfml2wddx"
    input = #sendDs#
    output = info>

    <!--- Display WDDX XML packet. --->
    Resulting WDDX packet is:
    <xmp><cfoutput>#info#</cfoutput></xmp>

    <cfhttp
    method="POST"
    url="http://192.168.0.212:8500/mail.cfm" >
    <cfhttpparam
    name="ref"
    value="#info#"
    type="FORMFIELD">



    </cfhttp>


    <!--- Deserialize to a variable named wddxResult. --->
    Deserializing WDDX packet...<p>
    <cfwddx action = "wddx2cfml" input =#info# output = "qnew">


    The recordset data is:...<p>
    <cfoutput query = qnew>
    #Serial_Number# <br>#Follow_Date#<br> #Status#<br> #Technician#<br><br>
    </cfoutput><p>

    <cfinclude template="mail.cfm">

    </body>
    </html>


    <!--- This is my remote cfm file. It works when local, but something is not
    well configured when sending the info to a remote server.--->
    <!--- Could you help me please? --->

    <cfoutput>
    <cfwddx
    action="WDDX2CFML"
    input="#info#"
    output="newDs">
    </cfoutput>
    The information is:<br><br>
    <cfoutput query="newDs">
    #serial_number#<br>#who#<br>#what#<br>#resolution# <br><br>
    </cfoutput>

    DaniFusionWeb Guest

  12. #12

    Default Re: CFSchedule, CFmail and CFoutput

    DaniFusionWeb wrote:
    > Hi Matt, I got it working locally, this is, I'm able to send the WDDX
    > information to another page, deserialize it in my other page and loop thru it.
    > So far so good. But as I told you, WDDX and CFHTTP is new to me. I was trying
    > to find info on the internet on how to set the values in order to see the
    > results also in a remote page with no luck. Here are my to pages (local):
    > Could you help me please on what to modify in order to get the values on a
    > remote page? Thanks
    Honestly I think maybe I got a bit off-track with my explanation, so
    based on what you're trying to do, I think this is the approach you
    should take. This will involve two separate pages.

    First page has your query, the WDDX serialization of the query data, and
    a form with a single hidden input that you set to the value of the WDDX
    packet. Again, you're going to serialize your entire query and do one
    submit, not multiple submits. At the bottom of this page you put a
    submit command for the form in a javascript block. In my testing you
    could NOT do this in body onload because the form values didn't get set
    prior to the form getting submitted.

    Second page is the page to which the form submits. On this page you
    deserialize your WDDX packet back into a CF query object and use that to
    send your emails.

    Hope that clarifies, and sorry for getting off on a tangent with my
    explanation. I was breezing through this and thought "Just use cfhttp!"
    but based on what you're trying to accomplish you really need to submit
    the form as opposed to using cfhttp.

    Matt

    --
    Matt Woodward
    Team Macromedia - ColdFusion
    mpwoodward *TMM* Guest

Similar Threads

  1. cfschedule
    By redevolve in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: July 28th, 02:15 AM
  2. Need Cfschedule Help
    By J?J in forum Macromedia ColdFusion
    Replies: 5
    Last Post: May 31st, 04:47 PM
  3. CFMAIL nexted in CFOUTPUT not sending all emails
    By carlu in forum Macromedia ColdFusion
    Replies: 3
    Last Post: March 30th, 04:59 PM
  4. cfmail - Attribute validation error for tag CFMAIL.
    By CF_Hack in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: March 11th, 05:45 AM
  5. <cfschedule>
    By drdagwood in forum Coldfusion - Getting Started
    Replies: 6
    Last Post: March 8th, 11:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •