RE: Setting up a poll database

2000-12-17 Thread John J. Kirker
Hi John, Here's some code a guy in our office gave me a while back for this: For example, if I was retrieving the responses from a Yes/No survey, I could run the following: SELECT column , Count(*) FROM table GROUP BY column The results could be: column

Re: Setting up a poll database

2000-12-17 Thread Joseph Thompson
I just finished helping a user on my site with a similiar project. Maybe you can glean something from that? http://cfhub.com/discussion/viewmessages.cfm?Forum=11Topic=90 The idea there was simply have one table with the "Poll Questions" and one table with "Poll Answers". The answer table had

Re: Setting up a poll database

2000-12-17 Thread John Allred
John, Thanks for the quick reply. I can get this query working in the query builder, but I can't figure out how to display it. It looks like a structure. A little more help? Thanks, --John "John J. Kirker" wrote: Hi John, Here's some code a guy in our office gave me a while back for

RE: Setting up a poll database

2000-12-17 Thread sknyppy
Webtricks has some source code available for creating a poll. http://www.webtricks.com/SourceCode/ Dave Bosky -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 17, 2000 4:28 PM To: CF-Talk Subject: Re: Setting up a poll database I just