Problem with passing values to popup

[Mark Henderson]

Here is my dilemma. I'm using Matt Robinson's mail script (found here http://mysecretbase.com/Slowing_Down_CFMAIL.cfm) to slow down cfmail. However, I want to open the cfmail page in a popup window (launched from a form)  and have certain form fields passed to this window. Some code will help explain. In the form, the client chooses which database they want to mail to....

=========================
in dsp_emailUsers.cfm
<cfparam name="subject" default="">
<cfparam name="emailtype" default="">
<cfparam name="town" default="">
<cfparam name="whichtable" default="">

<script type="text/_javascript_">
function formpop() {
formWin = window.open('http://www.urlname/newsletter/admin/ebomb_pop.cfm?&bombsaway=true&subject=form.subject&emailtype=form.emailtype&whichtable=form.whichtable&town=form.town','ScapeBomb','width=300,height=300,toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes');
if (formWin && !formWin.closed)
formWin.focus();
return true;
}

</script>

  <h2>S'cape Mailer </h2>
  <cfoutput>
  <form method="post" action="" name="scapemailer"  class="center" formpop()"></cfoutput>
      Subject: <br />
      <input type="text" name="subject" size="50" style="margin-top:5px;" />
        <input type="radio" name="emailtype" value="text" class="radio" />
        Plain text
        <input type="radio" name="emailtype" value="html" class="radio" />
        HTML<br /><br />
        Choose a database:
        <input type="radio" name="whichtable" value="client_test" class="radio" />
        Send Test
        <input type="radio" name="whichtable" value="client" class="radio" />
        Go Live
      </div>   
      <input name="submit" type="submit" value="Send mail" class="button" />
    </div>
  </form>

  <cfelse>
  <cflocation URL=""> </cfif>

THis seems to be fine, UNTIL it goes to query the email database with the whichtable variable...

in the  ebomb_pop.cfm file
=================

<cfset admin_mail = "[EMAIL PROTECTED]">
<cfset ebomb_filename = "scapebomb_test.html">
<cfset request.dsn="scape">
<!--- TEST THREAD --->

<!--- Run Rate is the number of seconds between refresh --->
<cfset variables.RunRate=20>

<!---
Query Run is the number of query rows (email addresses)
that will be processed on each execution of this template
--->
<cfset variables.QueryRun=5>

<!---
pull the email addresses.  Cache this query since its
going to be re-used every few seconds.
--->
<cfquery
   datasource="#request.dsn#"
   name="MailList"
   cachedwithin="#CreateTimeSpan(0,1,0,0)#">
   SELECT
     email
   FROM
     #whichtable#
   WHERE
     email IS NOT NULL
</cfquery>
etc etc

it barfs and returns a whacky msaccess application error about 'C:\winnt\form.mdb could not be found'. But if I hardcode either client, or client_test, everything works fine. Any ideas why this is happening? It's quite odd , bcos on the post process page of the original form, I checked by outputting the value #whichtable#, and here things are just fine (it always displays either client or client_test depending on which I have chosen).

Maybe I need to use _javascript_ to call the values in the popup?

Regards
Mark H

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---