Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem adding form vairbales
sigh ... i got it i had an extra } in there wow sorry for wasting the thread space lol- knightjb1
- Post #2
- Forum: Javascript
-
Problem adding form vairbales
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 =...- knightjb1
- Thread
- Replies: 2
- Forum: Javascript
-
Using a variable for bgcolor in TD tag
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. -
Using a variable for bgcolor in TD tag
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... -
coldfusion code problem
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 =] -
coldfusion code problem
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 -
coldfusion code problem
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 =]... -
cfinput rquired for textarea
Oh oops i didnt realize he was running MX -
coldfusion code problem
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... -
coldfusion code problem
<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">... -
Submit multiple forms with one button
Are you trying to update the other dropdowns based on the selected input from the first dropdown? -
cfinput rquired for textarea
reply or use cftextarea and type required="yes -
coldfusion code problem
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... -
Inner join issue
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...- knightjb1
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
invalid column name in cfquery with sql server 2005
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 =] -
invalid column name in cfquery with sql server 2005
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... -
problem with updating date in cfquery using access
Wow...lol i think i need to read up on reserved words. thanks for the help again lol -
problem with updating date in cfquery using access
Son of a ... Ill be so mad lol -
problem with updating date in cfquery using access
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 ... -
problem with updating date in cfquery using access
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...
