Search results for query: *

sigh ... i got it i had an extra } in there wow sorry for wasting the thread space lol

I have five text inputs 4 are user entered values 1 is to display the total I am trying to get the total to display the total of all four boxes. This is my javascript code... function calcTotal(NewClaim) { A = document.NewClaim.delegate1percent.value; A = A * 1; B =...

I figured it out. I was wrong on what the issue was. It was telling me my variable was undefined but that is because is did not set it to "" if there was no result so that fixed my problem.

Hello, I am trying to pull a user selected color from a database and use it in my td tag to change the background color of the cell. This is used on a calendar. I want the user to be able to color code events. The string being stored currently is in the format of #6699FF and I can pull it...

That did the trick thank you for figuring that out and explaining it so nicely, I feel dumb i didnt figure that out lol. I tried every combination under the sun of that join condition and nothing...You are very helpful thanks =]

Hey r937 I tried the code you pasted and it gave me this error Error Executing Database Query. Join expression not supported. If you want to figure out why this isn't working then be my guest but for now i will stick with the other solution =] hehe Im running coldfusion 7 and sql server 2005

Hey that works!! it returns the quiz the user didnt take was it suppose to return all the quizes? because i just wrote another query to match the quizes the user took and that will work just fine. Regardless thanks so much for the help this will make my application so much more user friendly =]...

Oh oops i didnt realize he was running MX

Yeah i got that to work before but the problem is it doesnt work based on username it will bring back all the records in the database not just the user i want I need it to pull the users records and pull all the quizes in the database that werent pulled for the user...GuJu i tried adding...

<cfquery name="chkQuiz" datasource="DATES"> SELECT examlog.examID, examlog.quizID, examlog.completed, examlog.uname, Quiz.quizID, Quiz.quizName, Quiz.certificate FROM Quiz LEFT JOIN examlog ON Quiz.quizID = examlog.quizID WHERE ((examlog.uname)="#usname#") </cfquery> <cfoutput query="chkQuiz">...

Are you trying to update the other dropdowns based on the selected input from the first dropdown?

reply or use cftextarea and type required="yes

OK, I have two tables in my database one is called Quiz and one is called examlog. The quiz table holds the name of all the possible Quizes for a user. The examlog holds the information when a user takes a quiz and is only recorded if they get 100 on it. So Lets say i have three quizes(quiz1...

I having this issue when i use an innerjoin in the cfquery tag. I am trying to join my two tables on a certain id then when all is said and done i need to spit out the ID to the page. My query is <cfquery name="getQuestion" datasource="DATES"> SELECT question.questionID, question.quizID...

Hey i figured it out it did not like my quotes in the where statement i changed the quotes from " " to ' ' and it works. In case anyone wanted to know =]

Hello, I was using an access database to run this web application and i just switched it over to sql server 2005 the databases are identical same column names and everything. But when i switched the datasources on the coldfusion page from the access datasource to the sql datasource the...

Wow...lol i think i need to read up on reserved words. thanks for the help again lol

Son of a ... Ill be so mad lol

The same one as before Syntax error in UPDATE statement. The error occurred in C:\CFusionMX7\wwwroot\DATES\update_action.cfm: line 16 14 : FULL = <cfqueryparam value="#Form.FULL#" cfsqltype="cf_sql_bit"> 15 : WHERE ID = <cfqueryparam value="#Form.ID#" 16 ...

Heres my new code which makes sense to me but im getting the error in sql update statement...god i hate this error lol <td> <input type="checkbox" name="FULL" <cfif "#FULL#" IS "YES">checked="checked" </cfif> value="#FULL#">Yes </td> <cfif not isdefined("Form.FULL")> <cfset...