Poll Won't Post to DB

I setup my poll, it looks great and works great except that it's not recording results to the DB. It doesn't give any errors - simply displays 0 responses and 0% for all the answers.

Not sure where to trouble shoot first - the DB connection seems to be working as I can access.

Also - the AJAX results post isn't working. Did I have to do something to add an element to my page zone for this to display? The pop-up works fine so I'm using that for now.

Ideas?
Rebecca Warriner
rwarriner@hitachiconsulting.com

[jford]

Rebecca,

Have you made any changes to the source code of the application? Specifically, have you edited processResponse.asp in the root directory?

This is the page that handles posting the response to the database, so is the most likely source of the problem.

Also, are you using the SQL Server database or one of the two Access Databases?

Finally, does the browser have javascript enabled?

Thanks,

James
Prezza Technologies

I did change a few things in process master. I commented out 2 lines with the copy right code and I changed the line to increase height of the popup for the display. That's it. I'm one of those kind of developers - should I try to restore this page from the zip and see if that fixes it?
<!-- CORRECTION - I edited the poll output include file -->
"width=" & (intWidth * 2) & ",height=" & (intHeight * 2.5) &

The page does have javaScript enabled and I'm using SQL Server.

Thanks!
R

[jford]

Yes, I would recommend restoring the file.

I restored the file and no change.

Maybe it's in my settings?
Poll - General:
Post Response - I can't get any of these to do anything different. They all just do the pop-up (with no writing to the DB)

Results - Refresh Page & Show Results - just refreshes page but results don't show up.
Pop-up - shows popup window (no writing to DB)
AJAX - doesn't do anything. Am I supposed to add something to my page to make AJAX work?

Are there any dependencies between these 2 settings maybe?


Rebecca

I created a new poll - very basic - just "TEST" for questions, answers, etc. I got one response and can't vote again. Something to do with only letting each machine only vote once, maybe...?

[jford]

Each machine should only be able to vote once unless the "Allow user to respond again" display option is selected. If this option is not selected, when you refresh the page, you should not see the voting screen but instead the summary of the results. Is this what you are seeing?

No - I have this selected and it just displays the poll again.

[jford]

If you have this option selected, you should be able to vote again. However, your second vote should not be recorded in the database. If however, you vote differently, the change should be reflected in the database.

When you say that AJAX option does nothing, do you mean that a postback still occurs or that nothing happens, i.e. the results never display?

The 2nd votes are not being recorded. Something to do with the cookie maybe?

The AJAX option just really doesn't do anything. Could be tied to the first issue. Let's figure that out first.