ColdFusion Forum

Hello I'm trying to make a sertain radio button the default. How would I get about doing this? Here is my coding so far: <td> Edit&nbsp;<input type="radio" name="Ptype" value="Edit"<cfif #Session.PType# IS "Edit">CHECKED</cfif> onClick="this.form.submit();">&nbsp;&nbsp;&nbsp;Print&nbsp;<input type="radio" name="Ptype" value="Print"<cfif...

I am trying to show a category, for example shoes and then show all the shoes in that category and then show the next category and all the products in that category and so on. I am able to show all the products but the category part I can't think of how to do. I have this so far displaying the products: <CFLOOP QUERY="Prods"...

I get this error while using the cfspreadsheet. I do not get the error in the development environment but I get it in the staging environment. The error -- "coldfusion.excel.ExcelProcessException: An exception occurred while using action=write."

Hello, I recently moved my scripts over to a server running Coldfusion MX instead of 5. Now the scripting I'm using to upload a file doesn't work. I've checked it and it all looks okay - any ideas why it isn't working? The path quoted by the CF variable is an absolute one: //marlin/assetinl/scripts/TaskBank/Docstore

Hello i"m trying to use two check boxes when selected I want it to change how it does the order by. So far I have this: <CFIF isDefined("Form.artist") IS "YES"> ORDER BY products.artist </CFIF> <CFIF isDefined("Form.qoo") IS "YES"> ORDER BY products.QtyOnOrder DESC </CFIF>

I have created two tables Films and Expenses. The variables Films table – FilmsID, MovieTitle, PitchText, AmountBudgeted, RatingID, Summary, and DateInTheathers And in Expenses table – ExpenseID, FilmsID, ExpenseAmount, Description, ExpenseDate. FilmsID need to be entered to these two tables as it’s the unique id. I can’t find the...

I have a table which display quest_id,quest_no, quest_malay, quest_eng and delete. After I click button delete I want to set my table row quest_malay and quest_eng into null. this is my coding UPDATE SURVEY_QUESTION SET quest_malay = <cfqueryparam cfsqltype="cf_sql_varchar" value="">, quest_eng = <cfqueryparam cfsqltype="cf_sql_varchar"...

hye. I have a little problem about loopping statement. This is the code.. <cfloop query="getQuest"> <cfset count=0> <cfquery name="chechking" datasource="#ds#"> select status_flag from survey_question where status_flag = 'N' </cfquery> count = count+1;

I have query which count all data in table and I try to display the output of count but I got an error here the code <cfquery name="countDATA" datasource="#ds#"> select count(quest_id) from survey_question </cfquery> <cfset t = #countDATA#> #t#

Hello, I am trying to autosubmit a hidden form. So far I have...... but it sends me into an infinite loop. Anyone got any ideas. I am such a noob... <form method="post" name="form1" action="<cfoutput>#CurrentPage#</cfoutput>">

what can be the problem? Since i tried to write this values like: <cfset totResponse = #GETTOTSCORE1.a# + #GETTOTSCORE2.b# + #GETTOTSCORE3.c#> <cfset avg = #GetSum1.score1# + #GetSum2.score2# + #GetSum3.score3#> <cfset totAVG = avg / #totResponse#> first calculation to calculate total response and I got error in value...

Hye all.. In my html, it display the value of average for each question in table. So the problem is the value of average for each question is in the looping function. So how can I pass the value of average for each question into bar chart which is out of the looping? <form name="survey_form" method="post" action="#currentfile#"> <table>...

I want to create a javascript which check reference no from database eg: first user insert reference no in textbox, mouse. and the second user insert reference no also in textbox, mouse. so here I want to create an alert which display the popup to the second user that reference no "mouse" is already taken. really need ur help thanks :)

hey there. really need ur help.. my problem is I want to insert all value into db in uppercase this is my code.. <cfquery name="insrt_srvy" datasource="#ds#"> INSERT INTO SURVEY_HEADER (REF_NO) VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" value="#ref_no#">) </cfquery>

Hi all, I have created three radio buttons in my coldfusion page and working fine. But now i want to execute query, depending on the button selected. ex: <td><input type="radio" name="Env" value="DEV" checked > Dev</td> <td><input type="radio" name="Env" value="STG" checked > STG</td> <td><input type="radio"...

hi, I am working on survey App in this i have to collect answers i have one problem while saving multiplechoice with other type of question.<cfcase value="multiplechoicemultiother"> <cfif StructkeyExists(answer,"answerValue") AND NOT isNumeric(answer.answervalue) AND Find("other,",answer.answervalue)> <cfquery name="insertresult">...

I have the class file below that will get a PDF file and converts into 64 bit format. package com.washgas.kubra.client; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.net.MalformedURLException; import java.net.URL; import java.text.DateFormat;

Hi i am having a issue, when i run it on crome and firefox executing same. but when i opened IE7 the table alignment is callapsed,can you any one helpout to oveer come this issue and it also working on IE8 and IE9.

I'm not highly technical, and this is probably something simple, but here is my dilemma, where I am attempting to retrieve a single record using a variable name in the query. First, I define some variables: <cfset datasource = 'MyDatabase'> <cfset query_tbl = 'MyDatabaseTable'> <cfset field1 = 'actual_fieldname1'><!--- FIRST field in...

Below is my action page: Please help, <cfquery datasource="digitalnewspapers1" name="digitalnewspapers1"> SELECT digitalnewspapers1.filename, digitalnewspapers1.dateofissue, digitalnewspapers1.county, digitalnewspapers1.title From digitalnewspapers1 WHERE 0=0 <cfif #FORM.filename# is not ""> AND FILENAME LIKE...

Hello I have a Coldfusion page that goes to a sql 2008 server. I'm trying to make it convert what ever the user enters to all upper case. So far I tried this Values ('#Form.UPPER(Artist)#', but so far it errors out saying "The UPPER method was not found". How would I go about so it will change anything in the Artist field to upper case? Thanks

OK now I'm having issues when an item is edited. I got the new items to work in upper case. Now I can't get it to covert the edited field to alway be in upper case. Here's the coding: <cfupdate Datasource="#datasource#" tablename="Items" formfields="ItemID,Artist>. I tried both Ucase(Artist) and UPPER(Artist). Ucase has no errors, but doesn't do...

I have a coldfusion .cfm page for creating a new request where a select dropdown is placed which populates a list of users from the database, While creating a new request, the current user will check the select user drop down for user names, if the specific user is not present, he will click to add a new user hyper link next to it and open a pop...

Hi, I'm trying to create a stacked series chart using cfchart where the stack has multiple values. For example, my columns could be feedback codes, with the values being a stack of the count of the type of action taken. I can generate the columns, but can't find a way to split the stack into the count of the action taken type. Any...

Form: <!-- Sign up FORM --> <cfoutput> <form method="post" action="HomeShow_submit.cfm"> <input type="hidden" name="UserID" value="#RemoveChars(CGI.Auth_User, 1, Find('\', CGI.Auth_User))#"> <input type="hidden" name="Fname" value="#User.fname#"> <input type="hidden" name="Lname" value="#User.lname#"> <input type="hidden"...