So now I'm trying to create in Oracle the tables for the poll.But when I try to create the first one, which references another table, I get the error, missing right parenthesis.The only other relational work that I've done was in mySQL so I'm sure that it's a syntax or keywordOracle issue.
Here's
I'm also working on a poll systems and I decided to keep the number
for each option in the same table as the option and just increment the
value for example
id_poll (fk)
id_poll_option (pk)
poll_option
poll_option_description
poll_option_votes
if you are going to put the votes in a
to the database its value is the
answered, a hidden field for the pollID and your in business
_
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 09, 2004 7:39 AM
To: CF-Talk
Subject: poll DB
I'm doing a poll and determined this morning that I should use a
relational DB.It's
This crap is getting annoying
Your message is a reply to anothers post and is more than 100 lines of
text. Unless you are
a major writer, your probably adding a lot of the previous replies. Please
trim your posts
when replying. Thank you.
Looks good to me, here is a layout from one I did
But then wouldn't I be writing an entry in the pollDB for every time that it's answered?
So, when I make a poll, I write an entry for every different option/answer available.Then I also write an entry for every answer made?Am I understanding correctly?
It doesn't seem like a good use of DB space
I'm building a polling app into my cms right now.Sorry but I haven't
built the Oracle versions of the table installers yet, but I can use
the mySQL versions cuz its the simplest sql to post.If this can
help, great.If anyone has any comments on my design I'd appreciate
them as this is a work in
I'm doing a poll and determined this morning that I should use a
relational DB.It's pretty basic, but it is my first one so I'd
appreciate it if y'all could check out the code before I go down this
path.
!-- a list of polls.Write to db once for each answer and then
group on display ** is this
you may also want to throw in a voted by and record their ip into it
so they cant keep voting.
On Thu, 9 Sep 2004 07:38:38 -0400, Daniel Kessler [EMAIL PROTECTED] wrote:
I'm doing a poll and determined this morning that I should use a
relational DB.It's pretty basic, but it is my first one so
you may also want to throw in a voted by and record their ip into it
so they cant keep voting.
I thought of doing that, but it would exclude community computers and since many of our audience is low-income, alot of their access is community-oriented.
So otherwise, I'm doing the right thing and
I'm also working on a poll systems and I decided to keep the number for each option in the same table as the option and just increment the value for example
id_poll (fk)
id_poll_option (pk)
poll_option
poll_option_description
poll_option_votes
if you are going to put the votes in a seperate
10 matches
Mail list logo