I set up an Access table with checkboxes and yes/no capacity. My email
and resulting form work and produce Yeses and Nos next to the checkbox
subject with this code...
On Email List? #IIf(isdefined("form.Vol_E"), DE('Yes'), DE('No'))#
But my problem is I set up a search form, whose code is beneath my
signature, and I have tried reich2a.Vol_E etc, and when I use the code
above, it produces all yesses even if some of the checkboxes are
unchecked. Now I have results that when I add a record by a form, the
ones I check have a 0 next to them, and unchecked have nothing -- but
the old records (the ones I haven't added in the table), have 1 for yes
and 0 for no next to the checkbox out put.
Does this make sense? Code for search.cfm and search2.cfm is below...
I am trying ideally to get output of yeses and nos, but 1s and 0s from
the ones I submit will do.
search2.cfm
<CFQUERY NAME="reich2a" DATASOURCE="jgrn123" USERNAME="jgrn"
DBTYPE="ODBC" PASSWORD="pwd">
SELECT *
FROM Email9d
WHERE Firstname='#FORM.txtFirstName#' AND
Lastname='#FORM.txtLastName#' OR Phone='#FORM.Phone#'
</CFQUERY>
<html>
<head>
<title>Search Results for Submissions</title>
</head>
<body>
<H1>SEARCH RESULTS FOR SUBMISSION</H1>
<br>
<hr>
<cfoutput query="reich2a">
Timestamp: #Timestamp#
<br>
ID: #ID#
<br>
CODE: #CODE#
<BR>
First Name: #Firstname#
<br>
Last Name: #Lastname#
<br>
Home Telephone: #Phone#
<br>
Work Telephone: #WORK_PHONE#
<br>
Mobile Phone: #MOBILE_PHONE#
<BR>
Misc Phone: #MISC_PHONE#
<BR>
Home Address:<br>
Address: #Address1# #Address2#
<br>
City/State/ZipCode: #City# #State# #Zip#
<br>
Work Address:<br>
Address: #WORK_MAIL#
<br>
City/State/ZipCode: #WORK_CITY# #WORK_STATE# #WORK_ZIP#
<br>
<br>Email: #Email#
<BR>Email2: #Email2#
<br>Comments: #COMMENTS#
<br>Occupation: #OCCUPATION#
<br>Occupation: #AFFILIATION#
<br>County Assigned: #CountyAssigned#
<br>
Additional Information:<br>
On Email List? #Vol_E#
<br>Would like to Contribute Now: #Vol_M#
<br>Your Vote for Reich?: #Vol_V#
<br>Would like to Contribute Sometime: #Vol_T#
<br>Reception or House Party: #Vol_HP#
<br>Arrange to Attend or Speak at an Event: #Vol_S#
<br>A Business that can offer resources?: #Vol_CORP#
<br>Additional Information for Volunteering:<br>
<br>Political Organizing?: #Exp_PolOrg#
<br>Campus Organizing?: #Exp_Student#
<br>Expertise in Specific Issues?: #Exp_Issues#
<br>Computer Expertise?: #Exp_Technology#
<br>General Communications, Media: #Exp_PR#
<br>Fundraising, Development: #Exp_FR#
<br>Scheduling: #Exp_Sched#
<hr>
</cfoutput>
<hr>
<br>
<br>
</BODY>
</HTML>
search.cfm
<html>
<head>
<title>Search Engines for Submissions</title>
</head>
<H1>SEARCH FOR SUBMISSION</H1>
<body>
<form action="search2.cfm" method="post">
<h3>Please enter supporter's first and last name, and home phone.</h3>
<br>
First Name:<br>
<INPUT TYPE="TEXT" NAME="txtFirstName">
<br>
Last Name:<br>
<INPUT TYPE="TEXT" NAME="txtLastName">
<br>
Main Phone:<br>
<INPUT TYPE="TEXT" NAME="Phone">
<br>
<INPUT TYPE="SUBMIT" VALUE="PROCESS"><INPUT TYPE="RESET" VALUE="CLEAR">
</FORM>
</BODY>
</HTML>
=====
Julia Computer Consulting
Web Design @ Reasonable Prices
PO Box 279, Watertown MA 02471-0279
Email: [EMAIL PROTECTED]
http://www.juliagreen.com
Phone: 617-926-3413
Fax: 617-812-5935
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
