Adobe Community : All Content - All Communities

Why is cfajax.js not initially loading in mobile platform/version?

forums_noreply@adobe.com — Wed, 08 Oct 2014 13:23:50 GMT

I am on a team developing and supporting a CF10 web application that is used on both desktop and mobile (iPad) platforms. I have a form with 2 CFSELECTs which are bound to CFCs.

There are views for both the desktop and mobile version. They are virtually identical *except* for the mobile form fields are in <div> tags instead of an HTML table. They both use the same CFSELECT code:

<cfoutput>
 <cfselect name="region" selected="#rc.region#" bind="cfc:applications.theApp.model.services.myApp.getRegions('#rc.DSN#',{district})" bindOnLoad="true">
 </cfselect>
</cfoutput>

The desktop version works as expected, the region options change based on the 'district' select box option,but the mobile version will not work on initial page load.

Using Chrome to emulate the mobile version, I noticed in the console that cfajax.js does not load the first time the page is accessed. The CFSELECT form fields shows no options.

But, if I F5 refresh the page, cfajax.js does load. The CFSELECTs appear to show no options *until* I click on them, and even then they don't quite behave correctly.

Why doesn't cfajax.js load on the initial page access?

Any help or suggestions would be greatly appreciated!

Query Of Query of ordered result set error in CFSCRIPT in CF10

forums_noreply@adobe.com — Tue, 08 Jul 2014 17:03:30 GMT

I have come across a very interesting error when doing a query of a query inside a CFSCRIPT tag...

I get a result set back from a SQL Server stored procedure. It is a list of metric names (METRIC_ID) and the actual metric measurements.

I need to pull the METRIC_ID from this result set to do a JOIN on another query that has display and other formatting attributes for display in a web page.

The following code executes with no errors when the query is unordered:

var displayDataQuery = new Query();

displayDataQuery.setName("joinedQuery");

displayDataQuery.setDBType("query");

displayDataQuery.setAttributes(qry1 = fullMetricsListQuery);

displayDataQuery.setAttributes(qry2 = arguments.cubeData);

displayDataQuery.setSQL("SELECT METRIC_ID FROM qry2");

var tempResultSet = displayDataQuery.execute();

var cubeMetricIDList = tempResultSet.getResult();

When I take the same exact query results from the same stored procedure, but it's ordered by an ORDER BY clause, this statement;

var tempResultSet = displayDataQuery.execute();

throws the following error - "The value '' cannot be converted to a number." That's 2 single quotes, signifying an empty string between "value" and "cannot."

Wait, what??? I just want a list of metric names, varchars. Why is there a conversion error...?

The error ultimately points back to ColdFusion10\cfusion\CustomTags\com\adobe\coldfusion\base.cfc, line 445.

OK, this is where this takes an interesting turn...

Starting at line 444 in base.cfc, Line 445 bolded in red:

<cfloop index="i" from="2" to="#ArrayLen(sqlArray)#">

</cfif>

#getPreserveSingleQuotes(sqlArray[i])#

</cfloop>

</cfif>

So if I understand this correctly, when I have an unordered query, this code in base.cfc reads the SQL set in displayDataQuery.setSQL("SELECT METRIC_ID FROM qry2"), but doesn't when the query is ordered by METRIC_ID...?

Ah, wait... the CFDUMP when using an ordered data set says something else...

query
RESULTSET
CACHED	false
EXECUTIONTIME	4
SQL	SELECT * FROM qry1 ORDER BY METRIC_ID, LOCATION

I'm pretty much stumped why the same data in unordered set works while in an ordered set causes this error.

Any and all helpful suggestions or clues will be greatly appreciated!!!

Sporadic coldfusion.runtime.CfJspPage$ArrayBoundException

forums_noreply@adobe.com — Mon, 09 Dec 2013 20:36:18 GMT

I have the following loop, going through an array, and trimming the of element i and then overwriting the element with the trimmed value:

for(a=1; a <= ArrayLen(arguments.locationHeaders); a++){

arguments.locationHeaders[a] = Trim(arguments.locationHeaders[a]);

}

Every so often I get an error stating The element at position X cannot be found.

I'm looping through the very array I'm editing! How can I be OOB...?

If I refresh the browser it works fine.

CF Builder trial reinstallation issue.

forums_noreply@adobe.com — Mon, 30 Sep 2013 16:26:44 GMT

Back in June I installed the CF Builder trial on my work machine. 2 days later I had to uninstall it due to our software compliance policies. I *maybe* used it twice, and have been using our standard Eclipse (Juno) with CFEclipse plugin IDE. We are planning on migrating away from DW and will either stick with Eclipse/CFEclipse or move to CF Builder, if we can trial it!

Fast forward to last week. All the issues have been taken care of, I'm free to install CF Builder and evaluate it for possible purchase by my team. I download latest trial install, go through installation, and am promptly told at first activation of the new install my trial period has expired!

Yes, I did install it over 60 days ago, but I almost immediately uninstalled it once I was notified it was a no-no and did not use it.

Retrieving large result sets from Oracle DB

forums_noreply@adobe.com — Thu, 11 Dec 2008 21:11:11 GMT

I have a webbased app which in a dev environment retrieves 41K records on the initial db query for display to the user. I cache the query as the user wants to be able to page through the result set, displaying 20 records at a time in the GUI.

The initial db query to retrieve 41K records takes around 25 seconds to move from the db box to the CF server box. We are expecting 10 times the amount of records in production!

The current method used is a CFC function containing the SQL query.

Does anyone have any ways to speed this up, or am I at the mercy of the network?

Any help will be greatly appreciated!

Using a CFQUERYPARAM list IN stmt not working

forums_noreply@adobe.com — Wed, 25 Jun 2008 19:45:04 GMT

I have a query I am running against an Oracle 9i db that has to check a list of codes.

The query listed at the bottom of this post returns expected results using
AND fec.ERROR_CODE IN (# PreserveSingleQuotes(errCodeList)#)

If I try to use
AND fec.ERROR_CODE IN (<CFQUERYPARAM list="yes" value="#errCodeList#"> )
the query returns 0 rows.

OK, here's the "intersting"part. If I change
IN (<CFQUERYPARAM list="yes" value="#errCodeList#"> )
to
NOT IN (<CFQUERYPARAM list="yes" value="#errCodeList#"> )
passing the same exact list the query returns rows!!! I get the opposite results I want, but the query still returns rows. I'm passing the same exact list to the query whether I use PreserveSingleQuotes, CFQUERYPARAM and using both IN and NOT IN constraints.

Why does NOT IN work and IN fail for the same list? Yes, the data is there, I have (at least) triple-checked.

The output from CF debug I get when using CFQUERYPARAM:
SELECT DISTINCT f.field_name,
f.label,
f.field_id,
f.input_type,
f.ERROR_CODE ,
gf.sort_order
FROM group_field gf,
FIELD f,
field_error_code fec
WHERE gf.GROUP_ID = (SELECT GROUP_ID FROM form_group WHERE form_id = ?)
AND gf.field_id = f.field_id
AND f.field_id = fec.FIELD_ID
AND fec.ERROR_CODE IN (?,?,?,?)
ORDER BY gf.sort_order

Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FORM_NAME
Parameter #2(cf_sql_varchar) = '130'
Parameter #3(cf_sql_varchar) = '131'
Parameter #4(cf_sql_varchar) = '132'
Parameter #5(cf_sql_varchar) = '133'

It appears a single-quoted, comma-delimted list is being passed to the db for the query.

Any help anyone can give will be greatly appreciated!

Does CFSTOREDPROC leave Oracle cursors open?

forums_noreply@adobe.com — Thu, 19 Jun 2008 16:35:33 GMT

I have an Oracle stored procedure I call that opens a cursor:

CREATE OR REPLACE procedure trialProc(c_test out sys_refcursor)
is
begin
open c_test for
SELECT *
FROM emp;
end;
/

My calling code in CF:
<cfstoredproc procedure = "trialProc" dataSource = "#request.dsn#" debug = "Yes">
<cfprocresult name = qOutResultSet>
</cfstoredproc>

From what I've read, when using CFPROCRESULT the cursor gets loaded into a result set. When this happens, does the cursor get closed by Oracle or CF Server? I don't want to leave a bunch of connections to the db open, as there is a finite amount and eventually they will all be used and then my app will come to a screeching halt.

Any info anyone can provide will be greatly appreciated.

javascript and dynamically named checkboxes

forums_noreply@adobe.com — Thu, 14 Jun 2007 20:37:37 GMT

We have a page that has Select/Deselect All buttons to check/uncheck all the checkboxes in the form. The checkboxes are dynamically named:

<cfoutput query="qHoldAdj">
<cfinput type="checkbox" name="select_#qHoldAdj.CURRENTROW#">
</cfoutput>

There are also other field types in this form, so currently this is the JS we have to select all the checkboxes:

function selectAll()
{
var objForm=document.forms.validateAdj;
var m=objForm.length;
for (var i=0; i<m; i++){
var e=objForm.elements ;
if (e.type=='checkbox' && e.name!='approve'){
e.checked=true;
}
}
}

With 6 form fields per line, when we spit out over 100 rows a page, firing off this JS freezes the page for a bit while it runs through every single form field, decides if its a cb or not, then checks it if it is. Ugh!

What would be nice if we could reference the checkboxes by name, eliminate 80% of the work per row. Problem is the names are dynamic and referencing them in JS is a headache we haven't figured out how to cure yet.

Anybody have an idea of how to do this...?