--- 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!
>
______________________________________________________________________
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=coldfusiona
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
