Search results for query: *

all is well on the form displaying dynamically with the data. now i'm working on processing the form info thought a bit confused. first, how am i going to be able to retrieve the results from the dynamically created select names? i will have them named 1, 2 and 3 (taken from the QuestionID)...

If I may reply to my own question. lol After some hours of reading and trial and error I've been able to set up a single query to display each questions with a drop down box of answers. The SQL statement I used was as follows: <cfquery name="getQuestionsAndAnswers" datasource="burningsouls">...

I am currently working on creating a poll for my website (www.burningsouls.com), however, it's a bit more than a poll, what i call a 'top ten'. the idea behind it is for people to be able to vote for their favorite album, song and video. i want to display all 3 voting options on the same page...

Thanks so much Nick, you've really helped a lot on this project! I hope to go live with it as soon as I switch to a server that supports CF. I put the second Update query in a separate command. Is it possible to combine the IntCount and Newest Update queries into one query? I'm sure you can...

Can you not edit your own posts??? I have the macro running through Access just fine, it counts each Interp for each Track, then the second command updates the TrackList table with the IntCount for each song! Thanks so much for that JOIN command, I need to look into these more. Now, my next...

Update: I was able to create a macro and set the action to RunSQL and I entered the updated SQL in and it created the table and counted the Interpretations just fine. However, you said to create a query first, then have the macro run the queries...is this step necessary or can I just have the...

Nick, I'm not quite familiar with creating macros in Access. Also, I assume I'm making these queries in Access, however, do I need to put the SQL code in the Expression Builder? If so, it says I have an incorrect syntax and I can't spot it. When this macro is working, it should be able to...

Well I messed around with all kinds of ways to count the record within each track, but couldn't get it to work so I'm back at having a Count Field. You mentioned running a periodic query to reset all of the totals. I think I tried doing something like this but couldn't figure it out. And how...

Nick, Thank you very much for the help. Since posting this and checking the link Zmr posted, I was able to create the tables exactly as you showed above! However, you brought up the point of counting the records. The problem I'm facing is this: When running the query to display all the...

thanks for that link. i found a better way to separate the albums and the tracklist...working on a couple tables for those now... would still like to modify the interpretations table a bit...that download didn't have much info on something like that...

I've been doing web design for 10 years now and just now teaching myself some ColdFusion. Installation and everything is fine, can run queries, etc... For reference, my site that I wish to change over to some CF stuff is at http://www.burningsouls.com. I am working on the song interpretations...