Adobe Community : All Content - All Communities

AJAX-Powered Related Select Boxes -

forums_noreply@adobe.com — Wed, 22 Oct 2014 13:53:42 GMT

Hi folks...I'm being driven crazy by this seemingly simple task.

I have 4 selectboxes, each AJAX-driven, grabbing items from a database, and then populating the next box in turn. Once a submit button is clicked next to the set of dropdowns, the information in the boxes are sent to a processing script where session variables are set and returned.

They all preload by default. They all properly load the next dropdown as you'd expect.

The problem is, I've found that if none of the boxes are touched and the default values are left, an error occurs when the submit button is clicked, and after dismissing the error popup, the 4th box becomes empty. This only happens if the 4th (last) dropdown is left to its default value. Once any other value other than the default one is selected, everything works as expected.

The error:

Bind failed for select box Transact, value and/or display attributes must be specified on the cfselect tag when binding to a query.

The form:

<tr>

</td>

</tr>

<tr>

</cfif>

</td>

</tr>

<tr>

</cfif>

</td>

</tr>

<tr>

</cfif>

</td>

</tr>

It seems like for whatever reason, the script has a problem with the default value loaded for that last box. I've checked the database, nothing strange about the values loaded by default at all. Any ideas guys??

Thanks in advance!

How Can I Get the current value of a binded field for use in a conditional statement?

forums_noreply@adobe.com — Mon, 05 Aug 2013 15:02:35 GMT

Hey guys, I have a CFGRID that's bound to some form fields:

<tr>

<td align="right">First Name 1:</td>

<td align="right">DL Number 1:</td>

</tr>

When, clicking on the CFGRID rows, the data in the form fields changes, as expected.

However, I'd like to make some other stuff happen conditionally based on current values of one or more of the form fields.

How can access, for example, the current contents of {SearchResultsGrid.fname1} in a CFIF statement?

Thanks in advance for any help you can give me

Updating CFGRID Bind to CFINPUT textbox

forums_noreply@adobe.com — Mon, 22 Jul 2013 18:21:33 GMT

Hey folks, I'm using a plain CFGRID (CF 8) to output a query resultset on the same page (in other words, not using a CFC or anything), for example:

<cfgrid name = "SearchResultsGrid"

height="250"

query = "checklist_search"

font="arial" fontsize="12" appendkey="yes" griddataalign="left" gridlines="yes" rowheaderalign="left" colheaderalign="center" selectmode="row" enabled="yes" visible="yes" format="html" autowidth="true" selectcolor="##578DCA">

<cfgridcolumn name = "lname_busname1" header = "Last Name" headerbold="yes" headeralign="center" width="100">

<cfgridcolumn name = "fname1" header = "First Name" headeralign="center" headerbold="yes" width="100">

<cfgridcolumn name = "address" header = "Address" headerbold="yes" headeralign="center">

<cfgridcolumn name = "trans_cat" header = "Category" headerbold="yes" headeralign="center" width="125">

<cfgridcolumn name = "trans_subcat" header = "Transaction" headerbold="yes" headeralign="center" width="125">

<cfgridcolumn name = "date" header = "Date" headerbold="yes" headeralign="center">

<cfgridcolumn name = "id" header = "Checklist Number" headerbold="yes" headeralign="center" width="125">

<cfgridcolumn name = "dob1" display="no">

<cfgridcolumn name = "fname2" display="no">

<cfgridcolumn name = "lname_busname2" display="no">

</cfgrid>

I'm then getting results (after the initial load) reflected in several textboxes:

<tr>

<td align="right">First Name 1:</td>

<td><cfinput name="Data_FName1" type="text" class="inputs_nomargin" bind="{SearchResultsGrid.fname1}"></td>

<td align="right">Last/Business Name 1:</td>

<td><cfinput name="Data_LNameBus1" type="text" class="inputs_sm_nomargin" bind="{SearchResultsGrid.lname_busname1}"></td>

</tr>

My problem, of course, is that selecting different rows on the CFGRID doesn't update my group of textboxes, it only loads data from the first row of results.

I see many examples doing this using CFC's, but.............how can I just have the textboxes update accordingly as I click down the rows of results when I have created my query on the same page the CFGRID and textboxes are?

Thanks!!

Please help me understand Categories within Verity search (CF8)

forums_noreply@adobe.com — Tue, 20 Nov 2012 14:56:56 GMT

I'm not sure why I can't understand how categories work within Verity, but the documentation isn't helping much, and web searches are yielding anything either.

Here's what I'm doing; I have a folder that contains a few subfolders...in these are PDF files. I have a collection setup that recursively indexed all documents, and allows me to search for them, no problem. This works.

What I'd like to do is create categories in this collection that correspond to the folders the files are in. For example, the structure could be:

Main Folder

-Folder 1

-Folder 2

-Folder 3

-Folder A

-Folder B

So the category names would be Folder 1, Folder 2, Folder 3, etc.

So when I search, I can allow the users to select checkboxes to search only certain categories.

My question is, how do I do this when I re-index the collection? Am I going to be forced to create a separate collection for EVERY category and subcategory? And then search multiple collections when using CFSEARCH?

Very confused, thanks in advance for any help

How could this query be coded?

forums_noreply@adobe.com — Wed, 22 Aug 2012 17:18:22 GMT

I'm racking my brain trying to figure this one out...this is an old query of mine being retooled...

DB has a field for MONTH and a field for YEAR...as well as HOURS for each record.

This query is pulling a sum of hours for a date range, that will be a year from Oct to Sep.

So I want a query that says:

Select * from October to December of Last Year, AND all months from January of the current year up to a "selected" month.

I have setup for current year, prior year, and selected month (from a dropdown list).

I've already tried something like:

SELECT SUM(hours) AS Total FROM TABLENAME

WHERE service_year = #session.prior_year# AND service_month >= 10 AND service_month <=12 AND service_year = #session.selected_year# AND service_month >= 1 AND service_month <= #session.selected_month#

No dice of course, logically that doesn't work anyway after looking at it.

Any ideas? I've tried various forms of evaluation levels of operators, no dice.

Thanks in advance!

How can I put a timed pause between CFMAIL sendouts?

forums_noreply@adobe.com — Thu, 02 Aug 2012 15:50:33 GMT

A preface, this is not marketing e-mailing I'm discussing, it's already opted-in government notifications requested by the customers.

This is driving me absolutely crazy. I've got a working SQL query that pulls a number or records (e-mail addresses), then sends out a series of mailings in batches (still working on that part).

What I'm stuck on is how in the world can I pause the CFMAIL processings between batches? For example, I want to send 500 e-mails, pause for 10 minutes, send the next 500, etc.

CFTHREAD looks kinda like what I might need but I'm not sure.

We're afraid of sending all at once (probably no more than 5,000 to 10,000 total) in fear of being blacklisted. Usually this app will only send 100 to 500 at a time.

Thanks in advance for any help you guys can give!

This is for CF8, incidentally.

Strange DW 8 Issues - No Color Coding, Split View Greyed Out

forums_noreply@adobe.com — Tue, 10 Apr 2007 20:34:36 GMT

Hi folks- DW 8 (and even the 8.02 update I installed today) has been acting completely strange the last few weeks....here are the issues I'm having, all at the same time:

Code coloring is suddenly gone, even though Code Coloring is still turned on....all text is black with a white background
Usually when opening a file (usually .asp or .cfm), the code will show strangely, you can see this at http://www.timgilbreath.com/screen_dw8.gif
With some Sites, when attempting to view Remote Files (that worked fine before), the app will crash and produce the error "Unable to find files in Configurations/Behaviors/Events. No behaviors will be available. Please reinstall the application."
Split and Design Views are greyed out (as you can see in the above screenshot)

Any ideas? I've completely uninstalled and reinstalled DW8 twice....no success....

Thanks in advance for any help you can give me!

Strange Error when connecting to a Remote Site

forums_noreply@adobe.com — Thu, 08 Feb 2007 16:53:35 GMT

Hi folks.......I have a few connections/FTP sites setup in DW, suddenly, when I try to connect to the remote server on some, I get the following message:

Unable to find files in Configurations/Behaviors/Events. No behaviors will be available. Please reinstall the application.

Then it shuts down. I've reinstalled (not sure completely though, since all my sites and old history in DW was available, I did it through add/remove and made sure the dreamweaver folder was gone).......and still the same problem....anyone else know what this could be and how to fix it?

Thanks!

T

Cold Fusion Version - What do I need?

forums_noreply@adobe.com — Thu, 29 Jun 2006 19:24:05 GMT

Hi guys/gals-

Quick easy question....I've worked with CF for around 3 years now, but am about to face my first employment requiring me to purchase/install it on a server...here's my question. If I've got a single Windows server, that hosts 2 to 5 websites, can I get by with the Standard edition of CFMX 7, or do I have to buy the Enterprise version? What are the differences between the two in respect to how many websites it can support?

Thanks!

T

New Install on Server - What Version Do I Need to Buy?

forums_noreply@adobe.com — Thu, 29 Jun 2006 19:28:41 GMT