I figured it out by using the Timestamp part of the database, I used
this code...cfif gets people out of jams...
<CFQUERY NAME="reich2a" DATASOURCE="jgrn" USERNAME="jgr" 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>Affiliation: #AFFILIATION#
<br>County Assigned: #CountyAssigned#
<br>
Additional Information:<br>
<CFIF Vol_E IS "1" AND Timestamp LESS THAN "01/30/2002">On Email List?:
Yes<cfelseif VOL_E IS "0" AND Timestamp GREATER THAN "01/30/2002">On
Email List? Yes<cfelse>On Email List: No</cfif>
<br>
<CFIF Vol_M IS "1" AND Timestamp LESS THAN "01/29/2002">Would Like to
Contribute Now: Yes<cfelseif VOL_M IS "0" AND Timestamp GREATER THAN
"01/30/2002">Would Like to Contribute Now: Yes<cfelse>Would Like to
Contribute Now: No</cfif>
<br>
<CFIF Vol_V IS "1" AND Timestamp LESS THAN "01/29/2002">Your Vote for
Reich: Yes<cfelseif VOL_V IS "0" AND Timestamp GREATER THAN
"01/30/2002">Your Vote for Reich: Yes<cfelse>Your Vote for Reich:
No</cfif>
<br>
<CFIF Vol_T IS "1" AND Timestamp LESS THAN "01/29/2002">Would Like to
Contribute Sometime: Yes<cfelseif VOL_T IS "0" AND Timestamp GREATER
THAN "01/30/2002">Would Like to Contribute Sometime: Yes<cfelse>Would
Like to Contribute Sometime: No</cfif>
<br>
<CFIF Vol_HP IS "1" AND Timestamp LESS THAN "01/29/2002">Reception or
House Party: Yes<cfelseif VOL_HP IS "0" AND Timestamp GREATER THAN
"01/30/2002">Reception or House Party: Yes<cfelse>Reception or House
Party: No</cfif>
<br>
<CFIF Vol_S IS "1" AND Timestamp LESS THAN "01/29/2002">Arrange to
Attend or Speak at Event: Yes<cfelseif VOL_S IS "0" AND Timestamp
GREATER THAN "01/30/2002">Arrange to Attend or Speak at Event:
Yes<cfelse>Arrange to Attend or Speak at Event: No</cfif>
<br>
<CFIF Vol_CORP IS "1" AND Timestamp LESS THAN "01/29/2002">A Business
that Can Offer Resources?: Yes<cfelseif VOL_CORP IS "0" AND Timestamp
GREATER THAN "01/30/2002">A Business Than can offer Resources:
Yes<cfelse>A Business that Can Offer Resources: No</cfif>
<br><br>Additional Information for Volunteering:<br>
<br><CFIF Exp_PolOrg IS "1" AND Timestamp LESS THAN
"01/29/2002">Political Organizing?: Yes<cfelseif Exp_PolOrg IS "0" AND
Timestamp GREATER THAN "01/30/2002">Political Organizing:
Yes<cfelse>Political Organizing?: No</cfif>
<br><CFIF Exp_Student IS "1" AND Timestamp LESS THAN
"01/29/2002">Campus Organizing?: Yes<cfelseif Exp_Student IS "0" AND
Timestamp GREATER THAN "01/30/2002">Campus Organizing:
Yes<cfelse>Campus Organizing?: No</cfif>
<br><CFIF Exp_Issues IS "1" AND Timestamp LESS THAN
"01/29/2002">Expertise in Specific Issues?: Yes<cfelseif Exp_Issues IS
"0" AND Timestamp GREATER THAN "01/30/2002">Expertise in Specific
Issues?: Yes<cfelse>Expertise in Specific Issues?: No</cfif>
<br><CFIF Exp_Technology IS "1" AND Timestamp LESS THAN
"01/29/2002">Expertise in Technology Issues?: Yes<cfelseif
Exp_Technology IS "0" AND Timestamp GREATER THAN "01/30/2002">Expertise
in Technology Issues: Yes<cfelse>Expertise in Technology Issues?:
No</cfif>
<br><CFIF Exp_PR IS "1" AND Timestamp LESS THAN "01/29/2002">General
Communications, Media: Yes<cfelseif Exp_PR IS "0" AND Timestamp GREATER
THAN "01/30/2002">General Communications, Media: Yes<cfelse>General
Communications, Media: No</cfif>
<br>
<CFIF Exp_FR IS "1" AND Timestamp LESS THAN "01/29/2002">Fundraising,
Development: Yes<cfelseif Exp_FR IS "0" AND Timestamp GREATER THAN
"01/30/2002">Fundraising, Development: Yes<cfelse>Fundraising,
Development: No</cfif>
<br>
<CFIF Exp_Sched IS "1" AND Timestamp LESS THAN "01/29/2002">Scheduling:
Yes<cfelseif Exp_Sched IS "0" AND Timestamp GREATER THAN
"01/30/2002">Scheduling: Yes<cfelse>Scheduling?: No</cfif>
<hr>
</cfoutput>
<hr>
<br>
<br>
</BODY>
</HTML>
--- Julia Green <[EMAIL PROTECTED]> wrote:
> --- Julia Green <[EMAIL PROTECTED]> wrote:
> > Date: Thu, 31 Jan 2002 15:47:32 -0800 (PST)
> > From: Julia Green <[EMAIL PROTECTED]>
> > Subject: Please help with output of Binaries
> > Reply-to: [EMAIL PROTECTED]
> > To: CF-Talk <[EMAIL PROTECTED]>
> >
> > 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!
> >
>
>
______________________________________________________________________
Get Your Own Dedicated Windows 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=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
