Adobe Community : Unanswered Discussions - Rich Forms

flash forms wmode is not allowing other html content to float above it

forums_noreply@adobe.com — Thu, 05 Jun 2014 16:12:50 GMT

Using Ext-JS drop down menus and the flash cfgrid with the wmode set to anything has no effect. According to the docs, set wMode to transparent or opaque and everything else should float over it. It doesn't do anything and I am starting to remember why I never used this feature before. Adobe, tell me how to fix this yesterday please!

BC forms the required* is ignored allowing empty submissions

forums_noreply@adobe.com — Fri, 01 Nov 2013 11:07:55 GMT

BC forms the required* option is being ignored allowing empty submissions any ideas?

CFGRIDCOLUMN not accepting type="date" in CF8

forums_noreply@adobe.com — Sat, 14 Sep 2013 21:33:16 GMT

I recently coded a CFGRID using CF9 with date fields using type="date". The date fields appear nicely with a little calendar to the right of the cell. I now realize that I have to have this working on a CF8 server. Is there any fix or addition that I can code to implement this calendar feature in CF8?

<cfgrid

name="taskGrid"

bind="cfc:QuestionsDAO.GetEmployeeGroupObjectiveQuestions({cfgridpage}, {cfgridpagesize}, {cfgridsortcolumn}, {cfgridsortdirection},#employeeID#,{groupID},{scaleName})"

gridlines="yes"

colheaderalign="center"

colheaders="yes"

format="html"

align="middle"

width="1200"

colheadertextcolor="blue"

style="border: groove 3px black"

striperows="true"

striperowcolor="##CAE4FF"

autowidth="yes"

title="Task List for #getPOname.poname# as of #DateFormat(now(), 'mm/dd/yyyy')#"

collapsible="true"

pagesize="30"

selectmode="edit"

onchange="cfc:QuestionsDAO.saveObjectiveDates({cfgridaction}, {cfgridrow}, {cfgridchanged},{scaleName})"

onerror="catchGridError"

</cfgrid>

Thanks!

more than 1 function in cfform tag "onSubmit"

forums_noreply@adobe.com — Thu, 12 Sep 2013 08:21:31 GMT

i need to call atleast 3 javascript functions in a form

using "onSubmit" works fine with one function but when i try to add another nothing happens....

<cfform

action="postpage.cfm" method="POST"

target="_self"

onsubmit="if(document.getElementById('Agree').checked) { return true; } else { alert('You must agree to the Terms and Conditions'); return false; }">

"return checkEmail(this);" is one of the funtions. it checks to see if 2 cfinputs are the same

how do i add multiple functions to onSubmit

tnx in advance

Using datefield, is there a way for the calendar to display multiple months?

forums_noreply@adobe.com — Tue, 02 Jul 2013 18:48:18 GMT

I've got a couple of cfinput datefields that show the current month when you select the calendar icon. Because these fields are used to select the "From" and "To" dates for reports, I need the calendar to actually show dates in the past. It would be great if one click would show the previous three months.

Can that be done?

How can I remove the pagination controls in but leave the delete button

forums_noreply@adobe.com — Tue, 28 May 2013 14:12:18 GMT

I have a <cfgrid> (coldfusion 8) and I am trying to remove the pagination controls (There will only ever be 1 page) but leave the delete button.

Or alternatively, remove the footer (which I figured out how to do) and add the delete button to each row.

(And yes I need the grid)

I've tried overriding the CSS both with a <style> tag on the page and Ive also tried using a function calleled on load to change the disply to none (which works in firebug when I manually do it)

Neither seem to work. I;ve searched all over and tried various things, but nothing seems to accomplish waht I need. Any help would be most appreciated.

****Code***********

<cfajaxproxy

cfc = "AddSelectedOptions"

jsclassname = "AddSelectedOptions">

<html>

<head>

var cfc = new AddSelectedOptions();

//cfc.setErrorHandler(showError);

cfc.setCallbackHandler(handleResult);

function showWin(){

alert('Button 1 works!!! :-)');

}

function showWin2(){

alert('Button 2 works!!! :-)');

}

function delSelected()

{

var selectedRecord = grid.getSelections();

var delID = selectedRecord[0].data.ID;

if(confirm('Delete User : ' + selectedRecord[0].data.FIRSTNAME))

{

cfc.delSelectedCats(delID);

};

}

function AddSelected(SessionId)

{

var Cat = document.getElementById("SelCategory");

var CatSelIndex =Cat.selectedIndex;

var CatId = Cat.options[CatSelIndex].value;

var SubCat = document.getElementById("SelSubCat");

var SubCatSelIndex =SubCat.selectedIndex;

var SubCatId = SubCat.options[SubCatSelIndex].value

cfc.AddSelectedOptions(CatId,SubCatId ,SessionId);

}

function handleResult(res)

{

ColdFusion.Grid.refresh('SelectedCategories',false);

}

var gridRender = function()

{

grid = ColdFusion.Grid.getGridObject('SelectedCategories'); //Get grid object

//overwrite existing grid footer with new div, Ext.id() will assign unique id to footer

var bbar = Ext.DomHelper.overwrite(grid.bbar,{tag:'div',id:Ext.id()},true);

//Create new PaginToolbar and render it to bbar (grid footer)

gbbar = new Ext.PagingToolbar({

renderTo:bbar,

store: grid.store,

pageSize: 10,

displayInfo: true,

displayMsg: '<b>Showing {0} - {1} out of {2}</b>',

emptyMsg: "<b>No Record</b>"

});

};

</script>

#ext-gen67{Display:None;visibility:hidden;};

#ext-gen59{Display:None;visibility:hidden;};

#ext-gen75{Display:None;visibility:hidden;};

#ext-gen76{Display:None;visibility:hidden;};

#ext-gen79{Display:None;visibility:hidden;};

</style>

</head>

<body>

Select Category and Subcategory

<table>

<tr>

<th>Category</th><td colspan="2">

<cfselect name="SelCategory"

bind="cfc:AddIncident.Categories()"

bindonload="true"

id="SelCategory"

class="field_150"

style="width:150px;"/>

</td>

<th>SubCategory</th>

<cfselect name="SelSubCat"

bind="cfc:AddIncident.SubCategories({SelCategory})"

bindonload="true"

class="field_150"

id="SelSubCat"

onChange="AddSelected('999');"/>

</td>

</tr>

</table>

<h4>Click on a row and select delete to remove.. will figure out how to add a delete button to each row</h4>

<cfgrid

name = "SelectedCategories"

format="html"

bindOnLoad="yes"

bind="cfc:SelectedOptions.getSlectedGrid({cfgridpage},{cfgridpagesize},{cfgridsortcolumn}, {cfgridsortdirection},'999')"

preservePageOnSort="true"

selectmode="edit"

delete="yes"

DeleteButton="Delete"

selectOnLoad="no"

font="Verdana"

fontsize="11"

label="True"

stripeRows="true"

stripeRowColor="##D9CCFF"

selectColor="##994FE6"

pagesize="5"

onChange="cfc:AddSelectedOptions.delSelectedCats({cfgridaction},{cfgridrow},{cfgridchanged })"

</cfgrid>

</cfform>

cfinput type="datefield" giving error with value CF10

forums_noreply@adobe.com — Tue, 02 Apr 2013 17:15:57 GMT

I have a form that was working in CF9 but now that I've moved over to CF10, it is generating an error.

I had it working without the mask, but tried it to see if it would fix the problem.

I am getting the error: 10/19/2011 is an invalid date or time string.

If I'm displaying the date as month day year, then the date as it is displayed is correct.

Am I missing something or has something changed between CF9 and CF10?

Thanks.

Sue

Binding Form Elements to Query Data

forums_noreply@adobe.com — Fri, 15 Mar 2013 03:07:43 GMT

Hello,

I have a simple form thatI'm binding query data to so I can populates a cselect box and, based on the selection, populate cfinput boxes. I have the code for this form in a <cfinclude template> and it is working just as designed.

But strangely enough, if I wrap the <cfinclude> code that contains my form in <cfdiv> tags, the binding breaks.

What would be causing that? Any help would be super greatly appreciated.

-Brian

Main Page Code with form:

<cfdiv>

</cfdiv>

CFInclude File:

<img src="images/service_vehicle.png" alt="Vehicle Log" /> <strong>Vehicle Log </strong> </legend>

<tr>

<td><label>Service Vehicle:</label></td>

</cfselect> </td>

</tr>

<tr>

<td>Origin:<br />

</tr>

<tr>

<td>Destination:</td>

</tr>

<tr>

<td><label>Start Odometer:</label></td>

</tr>

<tr>

<td>End Odometer:</td>

</tr>

<tr>

<td><label>Total mileage:</label></td>

</tr>

<tr>

<td><label>Expenses:</label></td>

</tr>

<tr>

</tr>

</table>

</fieldset>

</td></tr></table></cfform>

CFCS

select vehicle_name

from vehicles

where active = '1'

</cfquery>

</cfoutput>

</cffunction>

SELECT mileage

FROM vehicles

WHERE vehicle_name = <cfqueryparam value="#ARGUMENTS.vehicle_name#" cfsqltype="cf_sql_varchar">

</cfquery>

</cfoutput>

</cffunction></cfcomponent>

CFSELECT getting ELEMENT is undefined in FORM

forums_noreply@adobe.com — Thu, 31 Jan 2013 04:23:25 GMT

Found quite a few items on this topic when searching the web, but nothing applied.

I have a CFSELECT that searches a database for the options, and has its own blank option. On the cfselect i have a selected="". When I display the form, the selected isn't highlighted. If I don't highlight something on the field, when I click the submit button, that form field is not sent (doesn't appear in the CFDUMP. If I select the option value and press submit, it then gets passed.

						<cfselect name="Position_Club"
							required="No"
							message="Please assign Club Position"
							size="4"
							selected=""
							query="get_DropDownPositionClub"
							Display="Position"
							Value="Position_Code"
							queryPosition="below"
							Multiple="Yes">
							<option value="">None</option>
						</cfselect>

Around this code I placed another cfselect with all the option values, and they do go into the form when I press select. Before I update the code, it was using flash HTML and it worked fine. It looked like:

<cfformgroup type="horizontal" label="Club Position(s)">
	<cfselect name="Position_Club"
		required="No"
		message="Please assign Club Position"
		size="4"
		query="get_DropDownPositionClub"
		selected=""
		Display="Position"
		Value="Position_Code"
		queryPosition="below"
		width="300"
		Multiple="Yes">
		<option value = ""> None
	</cfselect>

Code any ideas?

HTML CFGRID not passing all modified values

forums_noreply@adobe.com — Wed, 19 Dec 2012 20:22:56 GMT

I've got an HTML type CFGRID (using CF10) and keep running into this issue where it's not passing all the fields that I modify. Say I have 5 rows, and I modify the same 3 columns in all 5 rows (entering prices). All 15 cells get the little red modified indicator, but when I submit the form, the resulting form variables don't contain all the changes. I'm dumping out the form object, and looking at the "grid.rowstatus.action" array to find which rows need updating, as well as the individual arrays containing each column's data.

I can't see any pattern to why it sometimes omits rows or even just cells I've modified. And it's not always the same, and sometimes it gets it right. I haven't been able to find any references to similar behavior, so I'm kind of stumped, and at this point, I may have to ditch the cfgrid and try a JQuery grid of some sort to see if it works better.

Anyone have any ideas?

CFGrid field corrupt. CF version 9.02

forums_noreply@adobe.com — Mon, 17 Dec 2012 16:46:19 GMT

Hi I'm getting this error reported here http://www.raymondcamden.com/index.cfm/2008/8/25/Bug-with-Ajax-HTML-Grid-and-File-Upload-F orms . I am using versaion 9.02. Can anyone tell me if this bug has been fixed yet?

I have read in various places semi-colons can cause problems, but I don;t have any semi-colons on my grid....

Thanks,

Ian.

cfgrid (type=flash) - how to capture in-cell keystroke event?

forums_noreply@adobe.com — Thu, 08 Nov 2012 20:42:09 GMT

Yep, I'm maintaining a Flash type cfform that was authored a few years ago. The application is on CF9 now.

How can my application sense when a user has keypressed within a CFGRID cell?

I've introduced a change event listener to the cfgrid via the onchange tag attribute. The event fires when the mouse clicks within any cell.

But keyboard navigation or individual cell keystrokes to not trigger a change, even when traversing to another cell via Tab or Enter.

I've also tried using the keyDown event, but that is only triggered when navigating the overall grid. It does not fire when a cell has focus - the user is typing within it.

keyUp doesn't work either, nor does keypress, keydown, keyup or any of my other exhaustive deriviation attempts. I've tried to locate a complete list of AS 2.0 event names, but have had no luck, even within Adobe's own pdf docs. If anyone has an example from their own personal museam, I'd love to see it.

Did I mention that this is a Flash cfform? Thought so...

cfinput type=datefield not working in some browsers

forums_noreply@adobe.com — Tue, 02 Oct 2012 15:02:04 GMT

I'm using Cold Fusion 9 and have a form that is working fine in IE8 and Safari on my desktop, and is not working one someone's laptop and it doesn't work on my iPad.

When I say doesn't work, the box is still there for the date and you can enter it manually, but instead of that nice date picker, there is a box with a question mark in it.

I've checked my iPad (safari) and it says that javascript is on. Based on other message threads I've added ids to the fields (no change) and added name and id and format to the cfform tag (no change).

The form is online and live here:

https://www.ute-sei.org/forms/rvp-staff-expenseclaim.cfm

I'm missing something, but I don't know what.

Thanks.

Sue

Dynamically adding form fields

forums_noreply@adobe.com — Mon, 06 Aug 2012 14:20:30 GMT

I am using CF10 on IIS

I have a data entry form where the user can enter the various medical diagnosis attributed to a medical encounter. Right now I have the list set to 25 dx.

What I would like to do is make the list dynamic, so that if you enter a dx, the form automatically adds a data entry field for the NEXT dx. Note that the field name and type is exactly the same. It will just populate the value as a list.

So, on the change event of a dx, it would add a new row to the data entry page to allow for the next dx. This would allow the operator to enter an unlimited number of dx into a single form.

I dont want the page to move on to another page to add the next dx. That would be simple, I realize. The customer would much prefer the dynamic route on a single page.

Thoughts?

jquery validation engine and CF issue.

forums_noreply@adobe.com — Sun, 05 Aug 2012 12:54:54 GMT

Hello;

I'm working on a simple coldfusion contact form. I am trying to use a jquery plug - in with it, I have the plug in working with no problem, but it won't reload the page to allow the coldfusion to execute if all fields are valid. I'm posting my code.. can anyone help me? I think I need to add a call for the page to reload with the variables to my script.. not sure how I do that.

function beforeCall(form, options){

if (window.console)

console.log("Right before the AJAX form validation call");

return true;

}

// Called once the server replies to the ajax form validation request

function ajaxValidationCallback(status, form, json, options){

if (window.console)

console.log(status);

if (status === true) {

alert("the form is valid!");

// uncomment these lines to submit the form to form.action

form.validationEngine('detach');

form.submit();

// or you may use AJAX again to submit the data

}

jQuery(document).ready(function(){

jQuery("#formID").validationEngine({

ajaxFormValidation: true,

onAjaxFormComplete: ajaxValidationCallback,

});

</script

and here is what sets off the coldfusion, it's all on the same page, one page mailing it and so on..

<cfmail............

</cfform>

thank you bla bla bla
</cfif>

that's it without getting into the form and all of that. I have the validation working, not able to send the message. I know it's because ajax/jquery aren't reloading the page, how do I make it do that?

Thank you!

cfautosuggest in CF 9.0.1

forums_noreply@adobe.com — Sun, 01 Apr 2012 21:03:33 GMT

I am running into issues implementing autosuggest with CF9.01.

test.cfm is extremely simple:

</cfform>

AutoSuggest.cfc says:

</cffunction>

</cfcomponent>

As you can see, I am creating a static array (the real one will of course depend on the text in the cfinput box).

This CFC works fine if I invoke it from a CFM page; I get an array with the names.

But it does nothing in this form.

I saw Adam's response re using oncfcrequest, and can't figure out what change to make. I added the cffunction to application.cfc, and that did not do the trick.

What am I missing?

Thx.

Multiple cftextareas not showing in Firefox 11?

forums_noreply@adobe.com — Fri, 30 Mar 2012 13:42:37 GMT

After upgrading to Firefox 11, any page with multiple CFTEXTAREA richtext fields results in the second field not displaying at all. Commenting out the first field allows the second field to show without issue. Both fields have individual ID and NAME attributes as follows:

<td><cftextarea id="email_header_html" name="email_header_html" height="125" width="550" richtext="true" toolbar="Basic" wrap="virtual"><cfoutput>#qry_get_sale.email_header_html#</cfoutput></cftextarea></td>

</tr>

<td><cftextarea id="email_footer_html" name="email_footer_html" height="150" width="550" richtext="true" toolbar="Basic" wrap="virtual"><cfoutput>#qry_get_sale.email_footer_html#</cfoutput></cftextarea></td>

</tr>

Note that this works fine in IE8+, as well as previous versions of Firefox.

Any clues? Much appreciated.

Update FCKEditor

forums_noreply@adobe.com — Sun, 04 Mar 2012 20:36:46 GMT

Hello,

Is there any easy way of updating FCKEditor bundled with ColdFusion to latest version of CKEditor? If not, then I will just stop using <cftextarea> and make the rich text implementation myself...

CF form to Access: auto fill date and numbering

forums_noreply@adobe.com — Fri, 18 Nov 2011 21:45:23 GMT

I have a very simple CF form that processes to an Access 2007 database. My boss would like me to add a few things:

1. Change the current date field to auto fill the date into the db.

2. Have an invisible field that enters the current year into it's own column.

3. Have each entry follow a progressive numbering system that resets on January 1st each year.

My ColdFusion knowledge is rudimentary at best, I've combed through forums and Google searches and the solutions I've found either don't fit the specifications, or get into advanced concepts I don't know how to apply yet. Can someone explain it simply, or is it not possible without getting into masks and loops I don't know how to use?

Multi-page Form

forums_noreply@adobe.com — Wed, 09 Nov 2011 15:13:13 GMT

I have a multi-page form, which is basic. The form's first page is to post a new person's fist and last name. The second page is for the person's current address. Of course, there's more objects/database fields than this, but I need page 1 to go to page 2 smoothly, and without much pause. Page 2 is the exact same person as page 1. The ID for the person is created on page 1, somehow.

How do I get the 2nd page form to know it's the same person on page 1? Do I use call_number =form.ID or ID=ID or what? Does the form on each page have be the same name? Does the ACTION have to be the name of the next page in the form (page2), or the name of the page which submits the data?

PAGE 1 "The Name"

SELECT *

FROM people_table;

</CFQUERY>

<HTML>

<HEAD>

<TITLE>Add an Entry.</TITLE>

</HEAD>

<BODY>

<TABLE>

<TR>

<TD>

<FORM

ACTION="p_in.cfm"

METHOD="post"

NAME="formNewPersonPage1">

<INPUT

TYPE="hidden"

NAME="peopleID">

<INPUT

TYPE="hidden"

NAME="entry_date_time"

VALUE="now()">

Your First Name:

<INPUT

TYPE="text"

NAME="people_nm_f"

SIZE="30"

id="First name">

<P>

Your Last Name:

<INPUT

TYPE="text"

NAME="gb_entry_nm_l"

SIZE="30"

id="Last name">

<BR>

<P>

Checkbox if Male:

<INPUT

TYPE="checkbox"

NAME="people_nm_male_x">

</TD>

</TR>

</TABLE>

</FORM>

</BODY>

</HTML>

____________________________________________________

PAGE 2 "The Current Address"

<CFQUERY DATASOURCE="people" NAME="nw">
      SELECT *
      FROM people_table
      WHERE formNewPersonPage1.peopleID=ID;
</CFQUERY>
<HTML>
<HEAD>
<TITLE>Add an Entry Page 2</TITLE>
</HEAD>
<BODY>
<TABLE>
      <TR>
           <TD>
               <FORM
                    ACTION="p_in.cfm"
                    METHOD="post"
                    NAME="formNewPersonPage2">
Your Street #:
     <INPUT
          TYPE="text"
          NAME="peopleStreetNbr"
          SIZE="30">

Your City:
     <INPUT
          TYPE="text"
          NAME="peopleCity"
          SIZE="30">
<BR>
Your State:
<P>
     <INPUT
          TYPE="text"
          NAME="peopleState"
          SIZE="30">
<P>
          </TD>
     </TR>
</TABLE>
</FORM>
</BODY>
</HTML>

CFForm inside CFWindow not submitting asynchronous

forums_noreply@adobe.com — Fri, 23 Sep 2011 08:35:34 GMT

Hey everybody

I'm having an application, which is already running (within Mura CMS). Now I moved the application to another installation. And in there, a CFForm that runs inside a CFWindow doesn't submit asynchronous anymore. The action-url is opened in the browser-window (as a normal request).

CFIDE is mapped in IIS and ColdFusion Administrator and is available (otherwise, cfwindow and cfajaxproxy wouldn't work neither). Now it seems to me, that the problem lies within a newer version of Mura CMS and therefore my questions are:

What are the possibilities to cause this error / misbehaviour?
Where should I look?
I checked the Doctype already and I'm also using CFAjaxImport.
Neither Firebug nor Chrome are throwing any JS-Errors.

Thanks for any hint :-)

Cheers

Boris

Ps: Is there an adverb "asynchronously"?

Cfgrid customization and notifications

forums_noreply@adobe.com — Tue, 20 Sep 2011 18:57:01 GMT

I am working with HTML CFGRID as first time in CF9, I found that you can Delete, Update and Add records easier using this component. But I have some questions about working with this feauture: - Is there a way to validate form cells when trying to update or add the records? Validate maximum length and type. - When adding insert button it will create 2 more buttons cancel and save, Can i customize labels for that button? My app is spanish written. - How would be the easiest way to style the grid - How can i notify the user when a record has been updated or can't be updated because of an error or a new record has been created? I attach code for the cfgrid, I am using a component too. ----------------------cfgrid ------------- ----------Component--------

SELECT actividad_id, actividad_resultado_esperado, actividad_resultado_obtenido, actividad_horas_asignadas, subseccion_dsc, 0, actividad_asignada, seccion_dsc, actividad.subseccion_id, subseccion_apartado_id, apartado_dsc, act_alineada_planeacion FROM actividad, seccion, subseccion,apartado WHERE actividad.seccion_id = seccion.seccion_id AND actividad.seccion_id = subseccion.seccion_id AND actividad.subseccion_id = subseccion.subseccion_id AND apartado.seccion_id =* actividad.seccion_id AND apartado.subseccion_id =* actividad.subseccion_id AND apartado.apartado_id =* actividad.apartado_id AND empleado_id = #Arg_empleado_id# AND periodo_id = #Arg_periodo_id# AND anio = #Arg_anio# AND actividad.seccion_id= #Arg_Seccion_id# AND actividad.apartado_id = #bApartado# ORDER BY #ARGUMENTS.gridsortcolumn# #ARGUMENTS.gridsortdir# ORDER BY actividad.subseccion_id ASC; SELECT '' as actividad_id, '(0) Registros encontrados' as actividad_resultado_esperado, '' as actividad_horas_asignadas, '' as apartado_dsc

UPDATE actividad SET #colname# = '#value#' WHERE actividad_id = #ARGUMENTS.gridrow.actividad_id#

DELETE FROM actividad WHERE actividad_id = #ARGUMENTS.gridrow.actividad_id# INSERT INTO [actividad] ([empleado_id] ,[seccion_id] ,[subseccion_id] ,[actividad_id] ,[apartado_id] ,[anio] ,[periodo_id] ,[cve_grupo] ,[actividad_resultado_esperado] ,[actividad_horas_asignadas] ,[actividad_asignada]) VALUES (#Arg_empleado_id# ,#Arg_Seccion_id# ,1 ,#ARGUMENTS.gridrow.actividad_id# ,#bApartado# , #Arg_anio# ,#Arg_periodo_id# ,'AAA101' ,'#ARGUMENTS.gridrow.actividad_resultado_esperado#' ,#ARGUMENTS.gridrow.actividad_horas_asignadas# ,1) Apologies, an error has occurred. Please try again later.

dateField calendar widget is obscured by other form fields

forums_noreply@adobe.com — Tue, 30 Aug 2011 21:52:30 GMT

See image below. This is an HTML form with the datefield expanding calendar. Unfortunately, the calendar is showing up below other form fields. Is there any way to fix this? This happens in IE but not Firefox (and telling people to just use Firefox is not an option).

forums.adobe.com

forums_noreply@adobe.com — Wed, 06 Jul 2011 11:12:45 GMT

Pls i need help on this issue,i just started programming and i'm building an application where different sections of a company will be able to view their own section only, on logging in i.e they wont have access to other sections of the company, how do i validate using CFIF statements and database together before allowing a worker in?pls detailed process is needed

autosuggest to poulate rest of form

forums_noreply@adobe.com — Fri, 17 Jun 2011 09:43:15 GMT

I have a rather simple form for a music venue. As the user types in the name it searches the database for a match. That works perfectly. What I'd like to do is fill in the rest of the fields with address,city,state etc.

Right now the name works perfectly but for the rest I get the entire array. Before anything is entered it shows every listing in the database as a comma delimited string.

Here are some snippets.

<label for="locName">Location</label>
            <cfinput name="locName" id="locName" type="text" value="#form.locName#" size="20" maxlength="100"
      autosuggest="CFC:calendarcfc.locations.ajaxlocs ({cfautosuggestvalue})" showAutosuggestLoadingIcon="true" />

            <label for="locAddress">Address</label>
            <cfinput name="locAddress" id="locAddress" type="text" value="#form.locAddress#" bind="CFC:calendarcfc.locations.ajaxlocs({locName})" bindonload="true"/>

The cfc

<cffunction name="ajaxlocs" access="remote" returntype="array">
      <cfargument name="suggestValue" required="true">
    <cfset arr.retNames = arrayNew(1)>
    <cfquery name="ajaxlocs">
      select * from eventlocations
    </cfquery>
    <cfloop query="ajaxLocs">
        <cfif FindNoCase(arguments.suggestValue,locName)>
          <cfset arrayAppend(arr.retNames,locName)>
          <cfset arrayAppend(arr.retNames,locAddress)>
          <cfset arrayAppend(arr.retNames,locCity)>
          <cfset arrayAppend(arr.retNames,locState)>
          <cfset arrayAppend(arr.retNames,locZip)>
          <cfset arrayAppend(arr.retNames,locPhone)>
          <cfset arrayAppend(arr.retNames,locSite)>
      </cfif>
    </cfloop>
    <cfreturn arr.retNames>
</cffunction>

Thank you in advance.

post key from array into value upon submit

forums_noreply@adobe.com — Sat, 14 May 2011 00:17:00 GMT

Hello,

I am new to ColdFusion and new to this forum, so be kind please. I have a form the gets a select list from an array and I need the key of the array to post into another hidden field upon submission of the form. I have some javaScript validation before the array, so maybe I could include something there, but I just can't figure it out. This is what I have so far:

    document.Form1.submit();        // Submit the page

    document.Form1.action = "contact_us_ty.cfm"    // Second target

    document.Form1.target = "contact_us_ty.cfm";

    document.Form1.submit();        // Submit the page

    return true;
}
-->
</script>
<cfset subject[1] = "Choose Subject or Recipient" />
<cfset subject[2] = "Alexis de Tocqueville Society" />
<cfset subject[3] = "Campaign" />
<cfset subject[4] = "Donations" />
<cfset subject[5] = "Feedback" />
<cfset subject[6] = "Getting Help" />
<cfset subject[7] = "Planned Giving" />
<cfset subject[8] = "UW Community Fund" />

<html>

<body>
        <form name="Form1" action="contact_us_ty" method="post">
            <input type="hidden" name="_pid" value="0" />
            <input type="hidden" name="_fid" value="0" />
            <input type="hidden" name="recipient" value= "NEED THE KEY HERE" />
            <input type="hidden" name="subject" value= "Website Contact Us Email" />
            <table width="*" bgcolor="#ffffff" border="0" cellspacing="0" cellpadding="2">
                <tr valign="middle">
                      <td align="right"><strong>Name: </strong></td>
                      <td><input type="text" name="name" size="30" value="" /></td>
                  </tr>
                <tr valign="middle">
                      <td align="right"><strong>Email Address: </strong></td>
                      <td><input type="text" name="email" size="30" value="" /></td>
                  </tr>
                <tr valign="middle">
                      <td align="right"><strong>Subject: </strong></td>
                      <td>
                        <select name="subject" id="subject"><cfloop array="#subject#" index="i"><cfoutput><option>#i#</option></cfoutput></cfloop>       </select>
                     </td>
                  </tr>
                <tr valign="top">
                      <td align="right"><strong>Message: </strong></td>
                      <td><textarea cols="30" rows="8" name="message"></textarea></td>
                  </tr>
                <tr valign="top">
                  <td> </td>
                  <td align="left"><input type="submit" name="button1" value="Submit" onclick="return OnButton1();" /></td>
              </tr>
          </table>
       </form>

</html>

Any help is greatly appreciated.

Thanks,

sLe2222

Textbox value based on menu list selected value

forums_noreply@adobe.com — Wed, 04 May 2011 12:46:48 GMT

Hi experts,

i am wodering what is the best way to have a textbox assigned a value based on a listmenu selected value.

i have the following tables

ID / item / color / price

1 / item1 / red / 5$

2 /item2/ green / 2$

10/item10/purple/10$

i have a listmenuwith all items listed.

and i have 2 other textboxes that should get the color and prices respectiveley..

How can i do that. ?

thanks

Why do I get "The form data has expired." every time with Flash formatted CFFORM moved to CF 9.1?

forums_noreply@adobe.com — Mon, 18 Apr 2011 17:40:11 GMT

We are moving a ColdFusion site from CF8 to CF9.1 and have discovered that any CFForm that was uses Flash as it's format keeps giving us the "The form data has expired." error almost every time we visit the page containing the form. We have fiddled with the timeout settings and even tried to add the various "cfheader" workarounds that some people have mentioned when getting this error, but to no avail. To be clear this works perfectly on CF8 *and* it works on our CF 9.1 QA server, but for some reason fails on the Live Server. Supposedly the Live server completely matches the QA server, but the behavior is sure different in this instance.

What could be the issues? What Apache or CF settings might I look into? Could there be some weird permissions error on the generated swf form file or some other obscure reason? I am totally in the dark and can't figure out why ColdFusion keeps thinking the form data has expired.

Please, any ideas would be welcome.

Thanks!

text box validation

forums_noreply@adobe.com — Thu, 31 Mar 2011 16:24:07 GMT

i have a form with 7 seven check boxes. If the user does not check at least one of them one. I do not want the form to submit and alert the user to check at least one check box. I am beginner - intermeidate at best with cf8 and have not found a solution yet to do the job, Please see code and form below. Any help is appreicated MUCH! thanks jim

<table width="490" border="1" style="color:#000000; border-collapse:collapse;">
                        <tr bgcolor="#eeeeeee">
                          <td><input type="checkbox" name="fundamentals" value="Session 1 Mobility 3.0.4 Fundamentals - 25 May @ 8:30AM- 11:30AM" /></td>
                          <td>Session 1 Mobility 3.0.4 Fundamentals</td>
                          <td>25 May @ 8:30AM- 11:30AM</td>
                        </tr>
                        <tr bgcolor="#eeeeee">
                          <td><input type="checkbox" name="reports" value="Session 2 Mobility Custom Reports - 25 May @ 12:45PM - 4:00PM" /></td>
                          <td>Session 2 Mobility Custom Reports</td>
                          <td>25 May @ 12:45PM - 4:00PM</td>
                        </tr>
                        <tr bgcolor="#ffd940">
                          <td><input type="checkbox" name="pms" value="Session 3 Mobility Pavement Management - 26 May @ 8:30AM - 10:30AM"/></td>
                          <td>Session 3 Mobility Pavement Management</td>
                          <td>26 May @ 8:30AM - 10:30AM</td>
                        </tr>
                        <tr bgcolor="#ffd940">
                          <td><input type="checkbox" name="map" value="Session 4 Mobility Map - 26 May @ 10:45AM - 12:00PM"/></td>
                          <td>Session 4 Mobility Map </td>
                          <td>26 May @ 10:45AM - 12:00PM</td>
                        </tr>
                        <tr bgcolor="#ffd940">
                          <td><input type="checkbox" name="report2" value="Session 5 Custom Reports Level 2 - 26 May @ 1:15PM - 4:00PM" /></td>
                          <td>Session 5 Custom Reports Level 2</td>
                          <td>26 May @ 1:15PM - 4:00PM</td>
                        </tr>
                        <tr bgcolor="#eeeeee">
                          <td><input type="checkbox" name="mms" value="Session 6 Maintenance Management Workshop - 27 May @ 8:30AM- 11:30AM" /></td>
                          <td>Session 6 Maintenance Management Workshop</td>
                          <td>27 May @ 8:30AM- 11:30AM</td>
                        </tr>
                        <tr bgcolor="#eeeeee">
                          <td><input type="checkbox" name="rol" value="Session 7 RAP Online - 27 May @ 12:45PM - 4:00PM" /></td>
                          <td>Session 7 RAP Online</td>
                          <td>27 May @ 12:45PM - 4:00PM</td>
                        </tr>
                      </table>

radio button

forums_noreply@adobe.com — Tue, 01 Mar 2011 18:16:30 GMT

I have a form with the first field as a radio button followed by 6 checkboxes. If the user checks the radion button I want to disable the 6 checkbox choices. I have not been able to figure out the logic to do it - or can it be done. see form code and image below - thanks jim

<cfform action="confirmReg.cfm" method="post" width="540">
            <fieldset>
            <legend>Registration Form</legend>

            <table width="530"style="border-collapse:collapse;">
   <tr>
<td valign="top"><cfinput type="radio" name="completeSession" value=""> </td>

<td colspan="3"> <em><strong>Attend all three days (Entire Session)</strong></em><br /><br />

</td>
</tr>


<tr>
    <th width="33" rowspan="2" scope="row">DAY 1</th>
    <td width="63" rowspan="2"><cfinput type="checkbox" name="fundamentals" value="">      <br />      <cfinput type="checkbox" name="custom" value=""></td>
    <td width="294">Session 1 Mobility 3.0.4 Fundamentals</td>
    <td width="112">8:30AM- 11:30PM</td>
</tr>
<tr>
    <td height="27">Session 2 Mobility Custom Reports</td>
    <td>12:45PM - 4:00PM</td>

</tr>

<tr>
    <th width="33" rowspan="2" scope="row">DAY 2</th>
    <td width="63" rowspan="2"><cfinput type="checkbox" name="pms" value="">      <br />      <cfinput type="checkbox" name="map" value=""></td>
    <td width="294">Session 3 Mobility Pavement Management</td>
    <td width="112">8:30AM- 11:30PM</td>
</tr>
<tr>
    <td height="27">Session 4 Mobility Map</td>
    <td>12:45PM - 4:00PM</td>

</tr>

<tr>
    <th width="33" rowspan="2" scope="row">DAY 3</th>
    <td width="63" rowspan="2"><cfinput type="checkbox" name="advReport" value="">      <br />      <cfinput type="checkbox" name="mms" value=""></td>
    <td width="294">Mobility Custon Reports Level 2</td>
    <td width="112">8:30AM- 11:30PM</td>
</tr>
<tr>
    <td height="27">Maintenance Management Workshop</td>
    <td>12:45PM - 4:00PM</td>

</tr>
</table>

             </fieldset>

            </cfform>

CF inside a Spry ToolTip

forums_noreply@adobe.com — Sat, 26 Feb 2011 16:30:03 GMT

I've not tried it yet but am curious if anybody has any experience with it or if it's even possible. I know any valid HTML will work inside those but I'm wondering if a simple CF email contact form inside a Spry Tooltip will function as intended. What problems might I run into and is this simply a bad idea on its face?

how to pass value from select box to cfc to get data back from cfc

forums_noreply@adobe.com — Thu, 24 Feb 2011 16:37:29 GMT

select Box
1234
4567
8976
5677
4536

Hi I nee help for one of my issue i am trying to solve

here is the scenario on top figure, i had a selct box on left side and when page loads i need to show information for example for 1234 on right side.

when user selects any item on select box then i have to pass that id to CFC to get data depending up on this selected id.

I am using CF8 and cfform type ="flash"

any ideas or examples on this that will help .

Thanks

Editable HTML CFGrid Issue

forums_noreply@adobe.com — Fri, 04 Feb 2011 23:56:11 GMT

Hi,

I am a bit new at using HTML CFGrid. I have a Coldfusion 9 environment and although I have given correct parameters I get a strange Javascript Error of Exception Thrown and not Caught, when I try to Insert more than one row in the Grid.

The first row gets inserted correctly, but when I click Insert button for second row this error comes up.

Here's the simple code I am using:

</cfgrid>

</cfform>

Any help will be greatly appreciated.

Abhi..

FCKeditor toolbar is wonky

forums_noreply@adobe.com — Fri, 21 Jan 2011 00:34:03 GMT

In IE9 (not sure about IE8), the Richtext toolbar shows the icons off to the left side of the page, verticle piled on top of one another. If you mouse over the toolbar spaces where the icons *should* be, they show up.

Any ideas why that might be happening?

Any suggestions on a better tool for rich text editing? Ideally it would support file uploads.

CFFORM inside CFWINDOW (target)

forums_noreply@adobe.com — Fri, 19 Nov 2010 11:45:18 GMT

I have a cfform inside a cfwindow, so when i submit it, the cfwindow content reloads.

However, if I used a traditional html <form> inside the window it would reload the whole page.

What I want is using cfform (beacuse of the validation goodies) but keeping reloading the whole page.

How can I do?

IT'S IMPORTANT, PLEASE!

jQuery inside CFWINDOW

forums_noreply@adobe.com — Fri, 19 Nov 2010 10:39:44 GMT

I load an empty <cfwindow> with a script similar to:

ColdFusion.navigate("/include/xxx.cfm","productWindow");
ColdFusion.Window.show("productWindow");

I need to use jQuery inside that cfwindow.

Looking around me, I added this function to the included cfml page:

ColdFusion.Event.registerOnLoad(initValidation,null,false,true);

The initValidation and the jquery inclusion are defined in the main page (not the cfwindow), which is good but...

if I write alert("hello"); inside initValidation .... it works!

if i write something which uses jquery.... fail!

Any experience?

cfselect bind error

forums_noreply@adobe.com — Mon, 08 Nov 2010 19:39:14 GMT

I upgraded CF 8.0.1 to 9.0.1 on a windows 2003 server.

Under CF 8.0.1 cfselect with bind to a cfc that is stored in a directory under the root, but not the application's directory, functioned fine and showed 4 related selects. After the upgrade to CF 9.0.1, no changes to code etc, js error: Exception thrown and not caught (http://servername/CFIDE/scripts/ajax/package/cfajax.js, line 804 (throw new SyntaxError("parseJSON");). When turning on AJAX logger, the cfc is invoked and returns the value pairs, however the cfselect does not get populated.

What am I missing?

I cannot get the grid to format to the exact row width

forums_noreply@adobe.com — Thu, 04 Nov 2010 12:20:39 GMT

I am using an html cfgrid to display 3 columns. The problem I am seeing is that even when there are not enough rows returned to reguire a scroll bar there is a right margin that is the width of the scrollbar causing the grio look "funny" I need to get the grid to size correctly without this margin.

Any thoughts? I have tried using css styling but it is ignored.

Thanks

[Sorting not working] with CFGRID + Binding

forums_noreply@adobe.com — Tue, 02 Nov 2010 09:23:10 GMT

My Products.cfc is:

<cffunction name="getProducts" access="remote" returntype="any" output="yes">
        <cfargument name="page">
        <cfargument name="pageSize">
        <cfargument name="gridsortcolumn">
        <cfargument name="gridsortdirection">
        <cfif ARGUMENTS.gridsortcolumn EQ ""><cfset ARGUMENTS.gridsortcolumn = "artcod"></cfif>
        <cfif ARGUMENTS.gridsortdirection EQ ""><cfset ARGUMENTS.gridsortdirection = "ASC"></cfif>
        <cfquery name="qryProducts" datasource="#this.DSN#" result="result">
            SELECT * FROM articoli
            ORDER BY 
                <cfqueryparam cfsqltype="cf_sql_varchar" value="#ARGUMENTS.gridsortcolumn#"> 
                <cfqueryparam cfsqltype="cf_sql_varchar" value="#ARGUMENTS.gridsortdirection#">
        </cfquery>
        <cfreturn QueryConvertForGrid(qryProducts, page, pageSize)>
    </cffunction>

The query params work correctly, my query runs in the right way but.... the returning JSON is not sorted!

Could this be an error in the queryconvert function?

However my cfgrid doesn't work:

<cfset args = StructNew()>
<cfset args.name = "ProductsGrid">
<cfset args.format = "html">
<cfset args.bindOnLoad = "true">
<cfset args.bind = "cfc:Products.getProducts({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})">
<cfset args.stripeRows = true>
<cfset args.selectColor = "##D9E8FB">
<cfset args.selectmode = "edit">
<cfset args.onchange = "cfc:Products.editProduct({cfgridaction},{cfgridrow},{cfgridchanged})">

<cfform>
    <cfgrid attributeCollection="#args#" pagesize="20">
        <cfgridcolumn name="artid" display="false">
        <cfgridcolumn name="artcod" header="xxx">
        <cfgridcolumn name="artdes" header="Descrizione" width="250">
        <cfgridcolumn name="artdesrc" header="xxx">
        <cfgridcolumn name="artcodpr" header="xxx">
        <cfgridcolumn name="artcodbar" header="xxx">
        <cfgridcolumn name="artprzacq" header="xxx">
        <cfgridcolumn name="artprzvend" header="xxx">
    </cfgrid>
</cfform>

What am I missing?

with Required="Yes" not working

forums_noreply@adobe.com — Tue, 26 Oct 2010 01:41:39 GMT

I have this cfselect:

<CFSELECT name="country" SIZE="1" REQUIRED="Yes" message = "Please select a country">
                  <OPTION value=" ">Choose a Country</OPTION>
                  <OPTION VALUE="AF">Afghanistan [AF]</OPTION>
                 <OPTION VALUE="AL">Albania [AL]</OPTION>
                 <OPTION VALUE="DZ">Algeria [DZ]</OPTION>
               etc.

</CFSELECT>

However, according to CF8 manual on the Required parameter:

Note: This attribute has no effect if you omit the size attribute or set it to 1, because the browser always submits the displayed item. You can work around this issue: format forms by having an initial option tag with value=" " (notice the space character between the quotation marks).

yes: a list element must be selected when the form is submitted.
no

I tried to "work around" with and without the SIZE but CF still will NOT detect that the user did not select a country. What is wrong? The screen displays Choose a Country and it will pass.

Help with cfform datefield and formating

forums_noreply@adobe.com — Wed, 13 Oct 2010 09:39:38 GMT

Hi,

I have a flash form and using the cfinput type= datefield, but the datefomat is displayed in US format 10/13/2010 but I would like the

format 2010-10-13, so how do I do that?

Thx for the help

Martin

cftextarea - Switching Dictionaries Based on Session Variable

forums_noreply@adobe.com — Tue, 05 Oct 2010 17:29:50 GMT

I'm wondering if anyone has come across the following issue. We have an app that switches interface components based on the users session language, we want to somehow switch the reference to the dictionary that is used by the FCKeditor - any ideas on how we might do that?

Need suggestion to achieve this functionality

forums_noreply@adobe.com — Fri, 01 Oct 2010 16:55:00 GMT

Hi,

I was looking at cfgrid and cftree functionality. Is it possible to incorporate cftree within cfgrid. if I can create a tree like structure in cfgrid. I am looking for something like below: The hyphens would be replaced by checkboxes...

- Folders

- subdfolder1

- subsubfolder1

- subsubfolder2

- subfolder2

- subsubfolder1

- subsubfolder2

- Folder2

- etc...

I am looking for something rich looking solution. It would be great if you can give some suggestion on these

CFGRID not displaying data from query

forums_noreply@adobe.com — Tue, 21 Sep 2010 07:40:38 GMT

Hello,

I have a very simple query, which is being used to populate cfgrid. The headers and paging display, the grid behaves as if it's laoding data, but never does. I've run the query in the background and it returns 4 rows.The CFC calling the query simpy takes in the parameters and returns the query.

The code is as follows:

</cfgrid>

There seems to be a javascript error on the page, which says Exception thrown but not caught, could this be the cause of the problem?

Thanks.

radio onClick cfselect enable= true

forums_noreply@adobe.com — Wed, 15 Sep 2010 19:56:04 GMT

Can not get onClick syntax to work correctly. Help is much appreciated.

<cfformgroup type="horizontal">
<cfformitem type="text" width="300" enabled="yes">How did you learn of our online process?</cfformitem>

      <cfselect disabled="true" visible="yes" name="newspaper" id="newspaper" multiple="no" width="250" >
               <option value="">Select one</option>
               <option value="1">option 1</option>
               <option value="2">option 2</option>
               <option value="3">option 3</option>
    </cfselect>
</cfformgroup>

     <cfselect disabled="true" visible="yes" name="JCenter" id="JCenter" multiple="no" width="250" >
          <option value="">Select one</option>
          <option value="1">option 1</option>
          <option value="2">option 2</option>
          <option value="3">option3</option>
    </cfselect>

</cfformgroup>

</cfform>

Form submit not behaving as expected

forums_noreply@adobe.com — Wed, 08 Sep 2010 10:37:36 GMT

I have a form that has a submit button. The action page is action.cfm. Action.cfm executes cfscript to restart a cfusion server instance. While the restart code is working, the problem i have is at the end of the action.cfm when i cflocation back to the initial form page. The problem is that when i click the submitt button a second time it does not work. If i click the submit button a thrid time it does work. The pattern that emerges is that every other click works after the first click.

I have looked at page caching and other things i have found on the net that look as though could be the problem, but what i think this boils down to is that my understanding of the fundamentals is not where it needs to be for form submissions. I have also tired self submitting form, which i had no luck with either. Again, probably my bad but i am open to best practice and ease of use suggestions.

Any help is greatly appreciated. Thanks in advance.

The code below is in a file named restartit.cfm

<cfform name="myform" action="http://123.456.789.123:8301/restart.cfm" method="post">
<cfinput type ="button" onclick="document.myform.submit();" name="fbutton" value="restart">
</cfform>

Here is restart.cfm

<cfscript>

     //relevant code here

</cfscript>

<cflocation url="http://123.456.789.123:8301/restartit.cfm" addtoken="no">

recap:

goto restartit.cfm and you will see a button. click the button the restart.cfm is run and cflocation back to restartit.cfm. This time when clicking on the button, it does not restart the server. Click it again, and it will restart the server.

Fyi, this is not restarting the server that it is hosinting the page. It is a different server instance killing a different server.

How to disable Saturdays and Sundays in cfinput datefield?

forums_noreply@adobe.com — Mon, 30 Aug 2010 14:35:04 GMT

How do you disable Saturdays and Sundays in a cfinput type datefield?

In Flash form and Flex, we only need to use disabledDays=[0,6]

For example,

<cfinput
type="datefield"

id="valuationDate_txt"

          name="valuationDate_txt"
          mask="dd/mm/yyyy" width="50"
          value="#lsdateformat(now(),'dd/mm/yyyy')#"
          onFocus="valuationDate_txt.disabledDays = [0,6];">

How do we make the disabledDays=[0,6] work with the cfinput type datefield?

Thanks and regards.

Richtext editors not showing up on tabs

forums_noreply@adobe.com — Fri, 27 Aug 2010 08:44:53 GMT

Can someone tell me why the richtext editors are not showing up on tabs 2 and 3?

I'm using CF9.0.1.

<cflayoutarea title="Tab 1">
<cftextarea name="text1" richtext="yes">
CF8 Rich Text Editor 1</cftextarea>
</cflayoutarea>

<cflayoutarea title="Tab 2">
<cftextarea name="text2" richtext="yes">
CF8 Rich Text Editor 2</cftextarea>
</cflayoutarea>

<cflayoutarea title="Tab 3">
<cftextarea name="text3" richtext="yes">
CF8 Rich Text Editor 3</cftextarea>
</cflayoutarea>

</cflayout>

</cfform>

Funky CFgrid problems!

forums_noreply@adobe.com — Wed, 25 Aug 2010 13:17:36 GMT

We recently upgraded our CF9 servers with the latest patch from adobe. (I know stupid me:) Ever since then we are having issues with all of our CFgrids. The alignment on the columns and the titles are all off, even though the columns add up to the size of the grid. No amount of fiddling will make it work unless you adjust the column size on the page. I suspect it is a CSS problem but cannot find it.

For an example of that see:

Strange formatting with cfgrid

Mar 22, 2010

I can live with that. I cannot live with this!

The second issue is that when you submit the grid to a new page the contents of the highlighted row do not get submitted to that page. As you can image that is a problem. All of these grids were working fine until I updated the CF9 servers.

I am going to post theses as potential bugs but I was wondering if anyone else is having issues with Cfgrid?

Mike

How to passing cf variable xml content to SpryXMLDataSet

forums_noreply@adobe.com — Tue, 17 Aug 2010 08:10:23 GMT

I have an cf object which calls a method which returns an XML string. Now like to access the XML-data by a SpryXMLDataSet. Is this possible?