Adobe Community : Unanswered Discussions - Advanced Techniques

cfprint and UPS labels

forums_noreply@adobe.com — Sat, 08 Nov 2014 14:21:34 GMT

I am trying to use CFPRINT to print UPS labels to a network printer. The starting labels (png files) are great and I can print them locally to the zebra printer and they work wonderfully. The barcodes produced by CFPRINT however are of such poor quality that the barcode scanner cannot read them. My research shows that jpedal resizes the images to 72 dpi which is just not crisp enough for a scanner. I read about using a jpedal setting: org.jpedal.upscale=2 but I have no clue as to where you would utilize this.

Any suggestions using on how to fix this using Coldfusion. Any suggestions using php or asp.net (other technologies we support internally)??

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 to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Sun, 19 Oct 2014 10:39:49 GMT

Hi,

I have just created simple wsdl example:

My Component:

          <cfif #arguments.login# eq "abcdef" and #arguments.password# eq "123456">
                  <cfxml variable="soapRes">
                        <kps_response>
                            <message>OK</message>
                            <token>354dfdffsdf</token>
                         </kps_response>

                    </cfxml>
             <cfelse>
                     <cfthrow type="MyException" message="INVALID LOGIN" errorcode="1000" />
         </cfif>

      <cfreturn soapRes >
    </cffunction>

</cfcomponent>

Its generating wsdl and no problem with response but when generating any error like username and password does not match then it's generating fault code like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<faultcode>soapenv:Server.userException</faultcode>

<faultstring>coldfusion.xml.rpc.CFCInvocationException: [coldfusion.runtime.CustomException : INVALID LOGIN. ]</faultstring>

<ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">HOST_NAME</ns1:hostname>

</detail>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

But I want customize Fault Code like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<faultstring>INVALID LOGIN</faultstring>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

Fault Code and Fault String should be customize and I don't want detail tag completely. In old ColdFusion version like ColdFusion 8 displaying detail tag with <ns1:stackTrace xmlns:ns1="http://xml.apache.org/axis/"> coldfusion.xml.rpc.CFCInvocationException: and so on.

Any suggestions on how to create customize faultcode and faultstring is very helpful.

Thanks!!

Cfspreadsheet

forums_noreply@adobe.com — Sun, 19 Oct 2014 01:18:26 GMT

Hi, I have a question regarding cfspreadsheet....So I'm using cfspreadshseet to create excel spreadsheets for reporting purposes. My page allows a user to select whatever columns from the database to include in the report. So here is an example:

The spreadsheet could look like this:

First Name-------------Last Name-------------Organization-------------Address-------------City-------------State----- --------Zip-------------Concern

Joe Smith Sample 12 main denver co 80513 concerns go here

My question is this, if Joe has more than 1 concern I get multiple rows with joe's info...is there a way I can loop the concerns and only have 1 row for joe?

Thanks,

Steve

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!

Issue with .net integration

forums_noreply@adobe.com — Wed, 08 Oct 2014 02:59:03 GMT

We installed a new CF11 server on a win2008 with iis7. the .Net ver is v2.0.50727
We have this code :

<cfobject

type="dotnet"

class="System.DirectoryServices.DirectoryEntry"

assembly="#dllPath#"

name="site">

to allow us to contact to the IIS directory to later create a Virtual Directory on it.
On the prev CF9/2008/iis7 /.net v2.0.50727 this worked great.

ON the new server I get this error :
Ensure that the DotNet agent is running and you have provided the correct host and port information-DotNet Side does not seem to be running.

We made several checks to make sure that the .NET integration with CF works - and it does, We used a simple example of a "math dll" from the wed and it worked with out any issue.
But when we try to communicate with the .Net assembly we get the error.

ANY suggestions will be highly appreciated

Thanks

Is it possible to create and then search a collection from within a coldfusion ap?

forums_noreply@adobe.com — Fri, 03 Oct 2014 17:56:54 GMT

Is possible to search a database to limit the number of pdf's to search -- then use the output from the search to create a collection index it and then keyword search the new collection all within one coldfusion ap?

The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

forums_noreply@adobe.com — Fri, 19 Sep 2014 19:43:24 GMT

I've done this a thousand times. I have a stored proc that returns data. I give the resultset a name. I output it with cfoutput query =queryname. Now it's failing for every column in the query. But if I do a cfdump with the queryname as a var, I get the data -- with the exact column names in my cfoutput.

CF9, SQL Server.

How can you determine from within CF if cookies are enabled in the browser you are using?

forums_noreply@adobe.com — Sat, 13 Sep 2014 22:06:09 GMT

I need to know if the user has cookies enabled when he logs into my website so I can tell him/her to enable them. If they are not enabled, the SessionID will be lost and session vars will not work.

Clearing Session and/or App variables with Log-out Page?

forums_noreply@adobe.com — Sun, 17 Aug 2014 19:21:54 GMT

Greetings

I have 3 distinct user types for my app- admins, appraisers and clients.

All have their own directories and each directory has it's own Application.cfm:

1) <cfapplication name="appraiseri"

applicationtimeout="#CreateTimeSpan(0,2,0,0)#"

clientmanagement="Yes"

sessionmanagement="Yes"

sessiontimeout="#CreateTimeSpan(0,2,0,0)#"

SetClientCookies="Yes">

2) <cfapplication name="appraiserview" ......

3) <cfapplication name="clientview" .......

Each have their own login which simply uses their ID in the DB as the session variable.

login_do.cfm:

1) Appraisers: <CFIF auth_direct_appraiser.RecordCount NEQ 0 >

2) Admins: <cfset Session.user_id =auth_direct.staff_ID> ......

3) Clients: <cfset Session.processor_user_id =auth_direct_processor.processor_ID>

I have had a session persisting for a week now- I have no idea how to get rid of it, and if one simply hits the "login" submit button with no UN or PW, it runs a query on a client (the same one) ?

My logout page is not working at all- if the code were correct, it would clear any session variable? I have not really set an app variable (except timeout) so no need to clear that?

Here is the code:

</CFIF>

</CFLOOP>

</CFLOCK>

alert("You have been logged out from the XXXXX Intranet")

location.href='login.cfm';

</SCRIPT>

Any help would be appreciated- this is leaving a huge security gap in the app right now.

Thanks

General problem communicating with SOAP-API

forums_noreply@adobe.com — Fri, 08 Aug 2014 10:58:21 GMT

Hello,

does anybody know whats wrong with this basic code?

Whatever I post to this API, I always get back the API itself.. Strange. Maybe someone could try this code?

</cfhttp>

Normally I put SOAP-content in the last cfhttpparam-tag but the API doesnt care about what I'm posting so I think the problem is anywhere else.

I tried to deal with the api using SOAP-UI, that wor´ks.

Any Ideas?

Thank you

Problem is more detailed described here: SOAP-API is not talking to me

In CF 9 can I create a custom page URLs, similar to Wordpress?

forums_noreply@adobe.com — Sun, 03 Aug 2014 04:25:47 GMT

I would like to create a function for my clients to create a custom page URL similar tot what Wordpress can can do. So my client's can customize the page URL info for example http:/www.novospa.ca/guinot-skin-care-products/

Is this doable and how would I do it?

Problem with Application Scope

forums_noreply@adobe.com — Mon, 28 Jul 2014 22:23:24 GMT

We use dynamic text on our websites.

The dynamic text available in different languages is stored in structures in the Application scope. Each resource bundle has its own variable to store its variables. They can be called using the following format:

#Application.StructName[Session.locale].Variable#

The first part is the name of the structure variable. With brackets, the variable for the locale is passed in, specifying which part of the structure to use. The last part is the specific variable within the resource bundle to use.

If we add new variables in the Application Scope will not be immediately seen.

The application scope can easily be refreshed by calling any page in the website and adding “refresh” as a variable in the URL.

This is the Application.cfc function to refresh the application scope:

We have a problem on one of our site.

When we call any page with 'refresh' url the site goes down, it says 'Locale is undefined in Session...', ONLY for one of our sites. It does not happen with other sites.

That is driving us crazy.

Is there some cold fusion specialist that can sense in which direction to move to try to resolve the problem?

Thank you for your help.

displaying coldfusion reports thru Asp.Net site

forums_noreply@adobe.com — Sat, 26 Jul 2014 22:49:09 GMT

I am new to coldfusion and have inherited a project from work that involves coldfusion apps that produces reports. I want to create a ASP.Net App with a new front end that will link to the coldfusion apps and display the reports.....any ideas? Thanks in advance

Disable cffunction accepting undeclared arguments?

forums_noreply@adobe.com — Thu, 17 Jul 2014 15:05:12 GMT

I have a lot of function calls with long lists of arguments and sometimes they can get mismatched (invoke with invokeargument status, function argument status_code). Coldfusion allows this to happen and makes the undeclared argument available in the arguments scope. Is there any way to disable this behavior so it only allows declared arguments and throws and error when it gets passed an argument that it doesn't expect?

Calendar code preformance issue

forums_noreply@adobe.com — Wed, 16 Jul 2014 18:10:54 GMT

I took the below from a function I'm using to render a weekly calendar similar to outlooks weekly calender view. The problem is when I start entering HTML outputs it begins to run very slow. I have another function that returns the events in a structure but if I loop the structure to find events it crashes the browser with a timeout. Can someone tell me what I'm doing wrong, is there a better way??

var local = StructNew();

//Copy the URL and Form structures into REQUEST

REQUEST.Attributes = StructCopy(URL);

StructAppend( REQUEST.Attributes,FORM);

//Define a default opening date

REQUEST.DefaultDate = Fix(Now());

//START *** time increments

local.dtTimeIncrement=5;

local.dtTimeStart=1;

local.dtTimeEnd=24;

local.dteventsPerTime=1;

try{

local.dtThisWeek = (REQUEST.Attributes.date - DayOfWeek( REQUEST.Attributes.date ) +1);

} catch(any excpt) {

local.dtThisWeek = (REQUEST.DefaultDate -DayOfWeek( REQUEST.DefaultDate ) +1);

}

local.dtPrevWeek = DateAdd( "ww", -1, local.dtThisWeek );

local.dtNextWeek = DateAdd( "ww", 1, local.dtThisWeek );

local.dtLastDayOfWeek = (local.dtNextWeek - 1);

local.dtFirstDay = local.dtThisWeek;

local.dtLastDay = local.dtLastDayOfWeek;

if ((Year( local.dtThisWeek ) NEQ Year( REQUEST.DefaultDate )) OR (Month( local.dtThisWeek ) NEQ Month( REQUEST.DefaultDate )) OR (Week( local.dtThisWeek ) NEQ Week( REQUEST.DefaultDate ))){

REQUEST.DefaultDate = Fix( local.dtThisWeek );

}

//**BEGIN *** Loop the clock HOURS from start time to end time

for (local.i = local.dtTimeStart; local.i <= local.dtTimeEnd; local.i++) {

local.DateVal=CreateDateTime(year(REQUEST.DefaultDate), month(REQUEST.DefaultDate), day(REQUEST.DefaultDate), local.i, 00, 00);

//**BEGIN *** LOOP THE WEEK FOR EACH TIME SLOT

for (local.j = local.dtFirstDay; local.j <= local.dtLastDay; local.j++) {

local.dtDayTime=CreateDateTime(year(Fix(local.j)),month(Fix(local.j)),day(Fix(local.j)), local.i, 00, 00);

}

//**END *** LOOP THE WEEK FOR EACH TIME SLOT

//**BEGIN *** Loop the clock MINUTES from start to end

for (local.k = 1; local.k <= local.TimeIncSel; local.k++) {

local.DateVal=CreateDateTime(year(REQUEST.DefaultDate), month(REQUEST.DefaultDate), day(REQUEST.DefaultDate), local.i, local.k*local.dtTimeIncrement, 00);

//**BEGIN *** LOOP THE WEEK FOR EACH TIME SLOT

for (local.l = local.dtFirstDay; local.l <= local.dtLastDay; local.l++) {

local.dtDayTime=CreateDateTime(year(Fix(local.l)),month(Fix(local.l)),day(Fix(local.l)), local.i, local.k*local.dtTimeIncrement, 00);

}

//**END *** LOOP THE WEEK FOR EACH TIME SLOT

}

//**END *** Loop the clock MINUTES from start to end

}

//**END *** Loop the clock HOURS from start time to end time

CF11 Object doesn't support property or method 'getColumnModel', Unable to get property 'tagName'

forums_noreply@adobe.com — Wed, 16 Jul 2014 12:05:19 GMT

I have many pages that use CFGRID and most of those pages use script to manipulate either the grid itself or data within the grids. All of the scripting worked fine in CF9 and CF10. While testing it on CF11, none of the code works. To me it appears that changes were made in the ext-js imports that are not backwards compatible. The first error thrown is the "Object doesn't support property or method 'getColumnModel'", with the source being the file that I am calling. The code I typically use to call it is:

changeStatus = function () {

grid = ColdFusion.Grid.getGridObject('gridName');

cm = grid.getColumnModel();

cm.setRenderer(18,ChangeSomething);

}

That error is followed by "Unable to get property 'tagName' of undefined or null reference", with the source being {site}/cfide/scripts/ajax/ext/ext-all.js.

Did the format to call the getColumnModel get changed in ColdFusion 11?

Message was edited by: DONALD BAERT

Database Design Question: What are the consequences of using a "One Table to Rule Them All" Approach?

forums_noreply@adobe.com — Wed, 18 Jun 2014 01:06:05 GMT

I have a MSSQL database schema question that I’d love to have the community's opinion on. I’m looking for the optimal way of storing one-to-many relationships for a variety of table combinations.

I’m familiar with the basic idea of relationship tables (the green table links Table1 to Table2):

Table1 Table2 Table1Table2

Table1ID Table2ID Table1Table2ID

Table1ID

Table2ID

What I’m trying to do though is to be able to link multiple tables together using a single relationship table. I’m using my server-side code to specify which tables are being linked (green table is relationship table and the red column indicates which table is being linked to Table1):

Table1 Table2 Table3 Table1TableX

Table1ID Table2ID Table3ID Table1TableXID

Table1ID

TableXID

TableX

In the above example, I’m using the column “TableX” to define which tables (Table2 or Table3) is being joined to Table1. This brings me to my first question: What are the consequences of doing things this way? Am I going to encounter a serious performance hit when records get into the 1000s+ ? I realize that I’ll have to enforce table integrity on the application layer and I’m okay with that aspect. I've been developing my application like this for quite a while now and so far it has worked out pretty well in keeping my database structure simplified.

Now I’m looking to simplify things even further and create a “one table to rule them all” approach. Basically, I’d like to create 1 relationship table that would control the relationships between all of my other tables. In this method I specify in the column values which tables are being connected. For example: (green table below is the relationship table and red tables point to the tables that are linked)

Table1 Table2 Table3 Table4 Relationships

Table1ID Table2ID Table3ID Table4ID RelationshipsID

ParentTable

ChildTable

ParentID

ChildID

Am I totally crazy here? Or would a setup like this be a viable solution for linking multiple tables together in a single place? So far the only consequences that I see are that my SELECT queries are a little more complex because I have to specify which tables are linked. For example, a simple joined query which looked like this:

SELECT *

FROM Table1 t1 INNER JOIN

Table1Table2 tt ON t1.Table1ID = tt.Table1ID INNER JOIN

Table2 t2 ON tt.Table2ID = t2.Table2ID

Now becomes:

SELECT *

FROM Table1 t1 INNER JOIN

(SELECT ParentID, ChildID

FROM Relationships

WHERE ParentTable = ‘Table1’

AND ChildTable = ‘Table2’

) tt ON t1.ParentID = t1.Table1ID INNER JOIN

Table2 t2 ON tt.ChildID = t2.Table2ID

So aside from having my queries be a little more complex, the database structure looks a lot cleaner when it’s all diagramed out. Do you think this is a bad idea to develop a database this way? If so, why?

Thanks for taking the time to check this out… I’d be curious to know your thoughts.

Password Protect all .cfm files in a directory?

forums_noreply@adobe.com — Thu, 12 Jun 2014 17:53:02 GMT

Greetings

Can anyone share the code one one put within the application.cfm to password-protect all the files in that directory?

The UN & PW are stored in a DB - of course I could create a session_ID and protect each page individually, which I have been doing for years, but in this case, the pages are being loaded using a half-*ss CMS and the users, other than saving files as .cfm, will not be responsible to leave the code on each page.

In the DB, the user name is subscriber_email, the password is subscriber_password.

Thanks for any help.

barcode scan

forums_noreply@adobe.com — Tue, 10 Jun 2014 13:48:42 GMT

Hi,

The form I have with several fields on it such as ProductID, Description, Price, ect. The back-end database is storing the information of these fields. I have the sheet list of all productID and scanner to scan the productid barcode. The productID is can into the productID field from the form. My question is how can I populate the Description and Price of each productID when it’s scan?

Thanks

CF10 Scheduled Task Event Handling Question

forums_noreply@adobe.com — Mon, 09 Jun 2014 14:06:11 GMT

I have some questions about hooking up error handling in CF10 for a scheduled task. I have a cfc ready to go handle the errors. In the coldfusion administrator what exactly do I put down for a path? The example says a.b.server. Is there a specific folder that I need to place the cfc or just path it to wherever I put it? Does it need to be inside the cfusion directory somewhere?

Dynamically give a name to cfimage

forums_noreply@adobe.com — Sat, 24 May 2014 00:59:18 GMT

I Have a page that displays a series of available items for the public to purchase. each of these items displays an image of the product. My cfimage code is made to scale-to-fit the stored image. normally the displayed results will all shoe different products and their corps pounding images. When I use the code below all of my different products will show the same image instead of showing the images that are linked to each product via a file path stored in the database. Is there a way to set the "name="myImage" dynamically so that each image will display and scale properly?

Unable to preserve indentation in cfgrid

forums_noreply@adobe.com — Mon, 19 May 2014 19:56:04 GMT

I have a cfgrid bound to a query in a cfc. The query indents one of the columns with blank spaces dependent on a hierarchy, like:

...

SELECT regularColumn, indentedColumn = replicate(CHAR(32),((Hlevel-1)*2))+' '+indentedColumn

...

Query works fine, i can see the indents in SQL server manager, but they never make it back to cfgrid. If i pick any other "visible" character works fine.

Any ideas?

Thanks

cf9 cfselect bind

forums_noreply@adobe.com — Fri, 16 May 2014 22:51:17 GMT

I have multiple dropdown lists on a form that are interdependent on each other. So, I'm using cfselects with binding based on selection of the previous drop down.

Here's the scenario:

Each 'sales representative' is assigned a number of clients. In turn, the clients are assigned a designated customer service rep.

I have a form that is using a cfselect to bind the clients displayed in the client list based on which sales representative is selected.

Once the 'client' is selected, I would like the next drop down list to populate with all customer service reps but have the rep that is actually assigned to the client be the default selected item in the drop down (e.g., selected="selected"). I need all service reps listed because there are instances that a case will be assigned to a different service rep than the default.

I have scoured the web and reviewed many examples but am still at a loss.

In my research found something similar to the code I'm using in the cfc (below) to pull the a list of all service reps and compare to see if the rep id is the client's designated rep.

<cfset result[i+1][3]=true> is being populated correctly, however this does not carry over to my cfselect to indicate the item selected.

Is there a different way I need to go about this?

Please ask if I'm not being clear in what I need this to do.

THANKS in advance for any assistance!

Code snippet:

SELECT

service_rep_id

,CONCAT(first," ",last) as svc_rep_name

FROM

svc_reps

</cfquery>

SELECT

rep_id

FROM

client_reps

WERE

client_id ='#arguments.clientId#'

and rep_type="svc"

</cfquery>

</cfif>

</cfloop>

</cfif>

</cffunction>

cfmessagebox error whatever parameters

forums_noreply@adobe.com — Tue, 13 May 2014 09:51:15 GMT

Whatever parameters are used in the CfmessageBox,

I get that error :

buttonType attribute is valid only for messagebox type "confirm".

Running CF9.0

Example code:

Thanks for help.

How to capture the reconfigure event on ajax grid?

forums_noreply@adobe.com — Mon, 12 May 2014 16:02:57 GMT

In CF9 i have a cfgrid bound to a hidden field and a cfc query component.

Then i have a select box where the onChange() event triggers a js function which updates the hidden field with the select value and triggers the cfc, populating the grid with new data.

In this js function, i'm trying to add an event that would trigger a chunk of code when the grid is refreshed, like:

function myFunc(val) {

document.getElementById('myHiddenField').value=val;

ColdFusion.Grid.refresh('myGrid',true);

var grid = ColdFusion.Grid.getGridObject('myGrid');

grid.addEvents('reconfigure');

grid.on('reconfigure',function(){

alert("Grid changed!");

});

}

I don't get an error but the function never executes, don't get the alert. If i change the event to something that happens AFTER the grid gets refreshed, like grid.addEvents('click') it works fine. What am I missing?

Thanks

CF11 cfgrid with binding.

forums_noreply@adobe.com — Sat, 10 May 2014 12:36:45 GMT

CF11 cfgrid with binding not work like with CF10. Example

	bind="cfc:focasaDBAccess.getInfo({cfgridpage},
	{cfgridpagesize},
	{cfgridsortcolumn},
	{cfgridsortdirection},
	{internet},{agentur})">

This dont work. Only with one additional arguments. Either "internet" or "agentur". With CF10 this work with much more additional arguments.

Thanks

Detlef

how does cf11 cfgrid binding works with additional arguments

at least eight or more.

Thanks for support

Detlef

How To Re-Compile ONE Component in Real-Time Without CF Restart?

forums_noreply@adobe.com — Wed, 07 May 2014 20:11:20 GMT

Is there a way?

I've seen tricks for restarting the application, but I suspect this still kills all active sessions, and we have quite a few going on.

I just have one CFC I need to recompile to get some changes in place, but I don't want to upset the entire apple cart.

Is there a way?

RLS

Crosstab - array error

forums_noreply@adobe.com — Wed, 07 May 2014 14:24:50 GMT

get the following error with my code below. Please Help.

Table will be rows = dscgrd, columns = dsckcrse, rows x cols = count of dsckextid. All grouped by teacher_anumber.

0 is not greater than zero or less than or equal to 0.
The range passed to ArraySet must begin with a number greater than zero and less than or equal to the second number.

The error occurred in C:/ColdFusion10/cfusion/wwwroot/CFIDE/groups/crosstabs.cfm: line 41
39 : GROUP="dscgrd"> 40 : <tr><th>#dscgrd#</th> 41 : <CFSET temp = ArraySet(course_idarray, 0, b, "N/A")>

<CFQUERY NAME="crosstabquery" DATASOURCE="LIISthinkgate">
SELECT     teacher_anumber, dsckcrse, dsckextid, dscgrd
    FROM     evaluationstudentcourse
ORDER BY     dscgrd, dsckcrse
</CFQUERY>

<CFQUERY NAME="crosstabcolumns" DBTYPE="query">
SELECT distinct     dsckcrse
    FROM             crosstabquery
ORDER BY             dsckcrse
</CFQUERY>

------------------------------------------------------------
<table>
<CFOUTPUT QUERY="crosstabquery"
          GROUP="dscgrd">
<tr><th>#dscgrd#</th>
<CFSET temp = ArraySet(course_idarray, 0, b, "N/A")>



<CFOUTPUT>
   <CFSET i = ListFind(course_idlist
                  , crosstabquery.dsckcrse)>
   <CFSET temp = ArraySet(course_idarray, i, i, crosstabquery.dsckcrse)>
</CFOUTPUT>
<CFSET rowtotal=0>
<CFLOOP index="j" FROM="1" TO="#b#">
   <td>#course_idarray[j]#</td>
   <CFSET rowtotal=rowtotal+course_idarray[j]>
</CFLOOP>
<td>#rowtotal#</td>
</tr>
</CFOUTPUT>
</table>

cfform flash not getting recognized

forums_noreply@adobe.com — Tue, 29 Apr 2014 18:43:57 GMT

Hi,
Our server recently had a migration. The previous server contained cf7 and new one has cf10. After the migration, one of our application using cfform format flash is not working now. A 'mxml.cfswf' file seems to be not rendering correctly while inspecting the console.
Is there any prerequisite for the cfform flash to get worked in cf 10?

Any help is appreciated.

How get unique option fileds in a dynamic dropdown box

forums_noreply@adobe.com — Tue, 22 Apr 2014 12:18:42 GMT

I'm trying to get single select options in a dropdown menu.

The data is coming from two database.

My CFQuery looks like

<cfquery name="related" datasource="ISSUE">
SELECT sparprod
FROM Related
where Active = 'Yes'
union all
select sparprod from TBL_issue
WHERE issue_number = <cfqueryparam value="#URL.issue_number#" cfsqltype="cf_sql_numeric">
ORDER BY sparprod ASC
</cfquery>

<td>

<option value="#related.sparprod#" <cfif (isDefined("rs_issue.sparprod") AND related.sparprod EQ rs_issue.sparprod)>selected="selected"</cfif>>#related.sparprod#</option>

</cfoutput>

</select>

And the output in the dropdown box looks like

PRODUCTS

SPARES

HOW can i have only ONE TIME Spares.

I've got this problem with all my dynamic dropdown boxes.

Thanks

For your help in advance

Klaas

Need ideas for page refresh

forums_noreply@adobe.com — Tue, 22 Apr 2014 11:36:54 GMT

I have an application that I have built that scans in a drivers license and OCR's the data, archives the image etc. I have the coldfusion page set up so it refreshes every couple of seconds. When the ID is scanned with the scanner and the query row is generated I output all of the scanned data and image to the page. Everything is working great with all that. I have a small little issue though.

Since the initial page is refreshing every few seconds waiting for the scan to happen that means that the drop down nav links in the header are refreshing too. There is a reports menu in the navigation that has around 10 links in a drop down for different types of reports. If someone drops it down and is taking time looking at the report names the page will refresh and the menu closes.

Once the ID is scanned it no longer refreshes every couple of seconds, I disable it. So its only an issue until the ID is scanned.

Any ideas for a way to refresh the page looking for a query recordcount to be >= 1 but not refresh the header?

Detect Flash using CF8

forums_noreply@adobe.com — Wed, 16 Apr 2014 11:03:14 GMT

I need to detect whether a browser has flash installed and active, and if not I will switch to an alternative set of code.

Can anybody tell me how I can test for an active flash installation? (on CF8)

Thanks

Mark

What is script syntax for passing form to REST?

forums_noreply@adobe.com — Thu, 10 Apr 2014 19:22:14 GMT

I'm lost. I am attempting to pass a FORMFIELD-parameter via the DELETE-method to a REST-function using script language.

I want to delete a resource. I get "Method not allowed", only "GET,OPTIONS,HEAD", so the DELETE-method is not understood.

I would apprechiate any meaningful input.

---------(service call)-------------

form.CategoryIDDelete = "X,Y,Z"

httpSvc = new http();
httpSvc.setMethod("DELETE");
httpSvc.setCharset("utf-8");
httpSvc.addParam(type="formfield", name="CategoryIDDelete", value="#FORM.CategoryIDDelete#");
httpSvc.setUrl("http://data.myDomain.net/rest/restService/categories");
res = httpSvc.send().getPrefix();
writeDump(res);
writeDump(FORM);

------------------------------------

...calls the rest service function in the registred REST component.
Here I call CategoryIDDelete "catIDs".

---------(service function)---------

remote Array function delCategory(string catIDs restArgSource="FORM") httpMethod="DELETE" restpath="{catIDs}" produces="application/json" {

var resp = [];

if (len(catIDs) > 0) {
...
}
return resp;

}

-------------------------------------

I am uncertain about many things; restArgSource="FORM", restPath="{catIDs}", and why DELETE is not an allowed method.

Need help with auto suggest - Return multiple fields

forums_noreply@adobe.com — Tue, 08 Apr 2014 15:06:31 GMT

I am having a hard time getting my autosuggest to work. I have a cfinput where a person can type in a last name. I then want to return the full name and employee ID of the person and bind them to two different cfinputs. Here is my cfc:

SELECT PERSONNEL.NAME_LAST_FIRST_MID, PERSONNEL.EMPLID, MST_LD.EMPLID

FROM MST_LD LEFT JOIN PERSONNEL ON MST_LD.SYREDU_SUID = PERSONNEL.EMPLID

WHERE ((MST_LD.PRIMARY_AFFIL_STATUS)= 'Active') AND ((MST_LD.EMPLID) Is Not Null)) AND PERSONNEL.NAME_LAST like <cfqueryparam cfsqltype="cf_sql_varchar" value="#ucase(arguments.search)#%" />

order by name_last, name_first , EMPLID ASC

</cfquery>

<cftry>

</cftry>

</cfloop>

</cffunction>

</cfcomponent>

Application Slowness with Coldfusion 7

forums_noreply@adobe.com — Tue, 01 Apr 2014 10:12:37 GMT

We have been having a problem where the server occasionally running very slow or simply hanging. Performance is uneven sometimes it works fast, sometimes very slow.

Environment:
------------
Windows server 2003 STD SP2 (X86)
IIS 6

Any pointers/help are greatly appreciated!

Thanks!

Retrieving all IPs belonging to FaceBook

forums_noreply@adobe.com — Sat, 29 Mar 2014 11:41:14 GMT

Please let me know if you can help me with the following, I would be happy to pay for time to help create this code

I need a script which is capable of retrieving ALL of the Facebook IP numbers based on their AS32934 record, so that we have a list of ALL IPv4 IP's that they could potentially utilize.

It would need to run on a ColdFusion 8 server

Perhaps these IP's could be retrieved from arin.net?

According to facebook the follow command should work

whois -h whois.radb.net -- '-i origin AS32934' | grep ^route

The script will output a list of all IP's which we will then be able to insert into our SQL database.

Thanks

Mark

Passing parameters to Java JT400 object

forums_noreply@adobe.com — Fri, 28 Mar 2014 14:41:15 GMT

I need to pass a byte array as my input and an int as the output length for the Class ProgramCall.

My error is

parameterList[0] (null): Parameter value is not valid.

My thoughts are

I think (but I'm not completely sure) I'm having trouble because I'm passing a Coldfusion Array where a Java Array is needed to pass the arguments.

Coldfusion arrays start at index 1 and Java Arrays start at index 0.

(1) Am I correct in what I believe is causing my error?

(2) How can I convert the Coldfusion Array to a Java Array?

Here is the documentation for Java JT400 object Class ProgramCall

http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/rzahh/javadoc/com/ibm/as400/access/ ProgramCall.html

Here is my code

Testing IP against a group of IPs

forums_noreply@adobe.com — Thu, 27 Mar 2014 22:18:11 GMT

Does anybody out there have a simple solution to scanning a range of IP's against a user's IP?

Let's say I have a group of IP's

123.456.654.10/50

111.222.333.444.5/20

I need a script where I guess I could put in the min and max and scan for a match against the end users IP #remote_addr#

So I'd be looking at all IP's in the range:

123.456.654.10

to 123.456.654.50

And the

111.222.333.444.5

111.222.333.444.20

Appreciate any help

Thanks

Mark

issue with onRequestStart query info

forums_noreply@adobe.com — Tue, 18 Mar 2014 01:05:48 GMT

I have a shopping cart that works from main code with VD on IIS.
So all the code is places in one directory, and for each store I create a Virtual directory on the IIS
so a store link will look like this :

www.shoppingcart.com/store/XXXXX
when the xxx is the prefix of that store.
in the application.cfc ONREQUERSTSTART I take the last part of the URL and match it with the PREFIX I in the list of stores on the DB.
to get the prefix I do this :

Then to get the right store info I used to do this :
<cfset qreadStoreInfo = application.cfc.StoreDetails.read(filterStorePrefix request.store. prefix)>

It all worked well (for over 4yrs) till about 2-3 moths ago (or at least then one of the client complained) when we start seeing the WRONG output of store info, like stores were "mixed" some how – totally randomly.

After following it for a few days I noted that the query that is returned from the CFC is for the wrong store.

At first I thought it’s the request.store.prefix not "stored" by the time I get to the query line so I changed this :

Yet I still get the wrong value back from the Query, and when looking at the Query I can see that the VALUE been sent in is wrong, even that I know for sure that I sent in the right value, since in the email I do an out put of the info on the page.

Did any one encountered any thing like this before ?
Any leads on how to maybe start handling ?

Is there a way that if the client is looking at 2 site at the same time thus queries can get "mixed", even that they are done on the ONREQUEST part of the application.cfc (IE each page should be processed on its own)

Fixing Security Vunerabilities in CF8

forums_noreply@adobe.com — Fri, 14 Mar 2014 14:58:34 GMT

I was looking at CF8 server vunerabilities, such as this one http://www.youtube.com/watch?v=CzXLLZ8ohZU where a user can easily get into the CF admin, add a shell and then basically do what they heck on our server.

Can anybody tell me how to make sure that this particular vunerability has been taken care of, is it part of a particular service pack, when I say service pack I mean cummulative hot fix, like CHF 4 http://helpx.adobe.com/coldfusion/kb/cumulative-hot-fix-4-coldfusion.html

CHF is just another term for a service pack I guess, and CHF 4 appears to be the last cummulative fix up.

My only concern is that if we had been compromised that even a hotfix would not remove any shells, although I could not find any, I am not a hacker, and those guys are very good at hiding things.

Ahh..after posting this I then saw the link to security

http://helpx.adobe.com/coldfusion/kb/cumulative-hot-fix-4-coldfusion.html#main_Security

It looks like quite a bit of work, no wonder so many people jumped ship from CF

Appreciate any guidance on this

Thanks

Mark

Back after 6 months

forums_noreply@adobe.com — Fri, 14 Mar 2014 14:53:08 GMT

Just want to say hello to everybody after being away for about 6 months, it's literally taken me that long to get somebody from the Adobe Indian tech support team to get me access to my account after Adobe changed my password due to their security breach.

Not cool.... Multiple hour long chats over months, promises to fix it after they kept sending me a request email that NEVER turned up, I finally found somebody that signed me up for another service and used that to get me access here, I was about to give up on Adobe, and ColdFusion.

Is there anybody even in here anymore! ;-)

Mark

Delay for

forums_noreply@adobe.com — Tue, 04 Mar 2014 01:17:14 GMT

I've added an AutoSuggest script to my site that offers suggestions as the user types their search keyword(s). The script works great except that it performs a search with every keystroke. I have spent the past 3 days trying out different jquery scripts that will for when a user stops typing before sending the search request, but I cannot get any of them to work correctly. Some prevent the search from being sent until the user clicks OUT of the search box, but I need a script that will work when the user stops typing for (xxx ms). I have include my code below in hopes someone might be able to help.

BTW: I do not know jquery or javascript much at all. I can often look at a script and know what to edit, but that's about it. Even this script for the AUTOSUGGEST was from a post I found online.

CSS

------------------------------------------------------------

div.autosuggest{position:absolute;float:left;width:460px;margin-left:-200px;}

input.autosuggestinput{ z-index:1000000;}

div.autosuggestcontainer {position:relative;top:.3em;width:100%;background-color:#FFFFFF;font-size:11px;font-famil y:Arial, Helvetica, sans-serif}

</style>

------------------------------------------------------------

FORM

------------------------------------------------------------

</cfform>

------------------------------------------------------------

CFDIV

--------------------------------------------------------

</div>

GETRESULTS.CFM

--------------------------------------------------------

<CFSEARCH

Name="getresults2"

Collection="store"

Type="simple"

CRITERIA="#ucase(url.search)#"

Maxrows="15">

<a href="#path#/detail.cfm?pid=#key#">#title#</a>

</div>

</CFOUTPUT>

I am hoping someone has a simple script that will allow a delay before the search request is sent to the GETRESULTS.CFM page and returned into the CFDIV.

Thank you,

Ron

Encoding of UTF8 Characters in URL Strings

forums_noreply@adobe.com — Mon, 03 Mar 2014 18:59:55 GMT

I need to link to a URL that has a right single quotation mark in it (u+2019).

This is it: "/News/Case-Studies/UNICEF-Headquarters’-Redesigned-Lobby-Space"

When I paste the link in to a browser, it works.

When I create a link with this URL as the href and click on it, it works.

When I put it in a <CFLocation> tag, it does not work. I need to make this work.

When I take the URL from a browser address bar and paste it into a text editor, it converts the right single quote to the percent-encoded string "%E2%80%99". I have not been able to recreate this encoding. URLEncodedFormat() yields a completely different string.

When I parse the url and note the ASCii value of each character, I get three characters for the right single quote: 226 8634 8482.

I came up with an encoding that worked, but resulted in special characters in the address bar of the browser (don't remember what the technique was at this point).

What encoding can I perfrom at the CF server to duplicate the proper UTF8 encoded string of %E2%80%99?

Any help would be appreciated.

XML POST not sucessful

forums_noreply@adobe.com — Sun, 23 Feb 2014 19:33:13 GMT

Hi,

My ColdFusion 10 server is not responding to http POST requests with XML body (like you use for web services or soap requests).

I need to setup a web services interface on my server that allows to accept XML form submits from the Adobe DPS server.

(http://www.adobe.com/devnet/digitalpublishingsuite/articles/dps-entitlement.html)

I have been using Ben Nadel's posting to get up to speed on XML post submits (http://www.bennadel.com/blog/745-Posting-XML-With-ColdFusion-CFHttp-And-CFHttpParam.htm), but I'm running into a problem because it seems my ColdFusion 10 server (on windows 7, with IIS) is not responding to XML POST requests. I've build a simple post cfm script, and a receiver cfm script, but any request is only timing out.

If I do a simple POST with formfields, then it works:


<cfset strURL = "my server" />


<cfsavecontent variable="strXML">
    <credentials>
        <emailAddress>joeblank@smooth.com</emailAddress>
        <password>stupid</password>
    </credentials>
</cfsavecontent>

<cfhttp timeout="50"
url="#strURL#" method="POST" result="request_results">

<cfhttpparam type="FORMFIELD" name="username" value="thisuser">
<cfhttpparam type="FORMFIELD" name="password" value="that1234">
</cfhttp>

<cfdump var="#request_results#">

If I replace the formfield httpparams with a XML type httpparam then the request just times out.


<cfset strURL = "my server" />

<cfhttp timeout="50"
url="#strURL#" method="POST" result="request_results">

<cfhttpparam

type="XML" value="#strXML.Trim()#"

</cfhttp>

<cfdump var="#request_results#">

I searched on the web and have not found any solution. Currently I assume the problem is somewhere with firewall, or IIS, because that's the part I don't know much about how to find the issue or fix it.

I did verify with Fiddler that my request is sent sucessfully from my development server to my development server, as well as from my development server to an ISP hosted production server, but both servers do not respond.

Any help is very much appreciated!

Thanks

Franz

CFSearch returning empty results

forums_noreply@adobe.com — Fri, 21 Feb 2014 22:04:04 GMT

I followed the steps from Ray Camden's website to use the data import handlers for indexing a collection http://www.raymondcamden.com/index.cfm/2012/11/1/Some-tips-for-working-with-Data-Import-Ha ndlers-in-ColdFusion-10#c5FB2381E-E361-4453-99BCFB2F2097BF62. My collection is being populated but when I try to use cfsearch to return results it comes back empty if I add a criteria to the search. Without a criteria results are returned. Here is the cfsearch tag I am using - has anyone else had similar issue and if so how did you resolve it?

<cfsearch

name = "mySearch"

collection = "FORD OEM"

maxRows="200"

criteria="window"

type="dismax">

Strange Behavior When Working with Nested Query Objects

forums_noreply@adobe.com — Thu, 13 Feb 2014 01:57:17 GMT

I just posted a comment over on Ben Nadel's site about this issue but I wanted to get some feedback from my fellow ColdFusion developers to see if anyone else has ever experienced this issue:

I have a function within a CFC that creates a query object and then nests another query object inside it (masterQuery > subQuery). The CFC returns the query object and to make things easier I loop through the query columns and bring everything into the local VARIABLES scope using the following format: "#a#" = masterQuery["#a#"] where "a" is the name of the query column.

After I had all of the query columns in the VARIABLES scope I tried to run a QofQ on the subQuery and low and behold I got an error message:

"coldfusion.sql.QueryColumn cannot be cast to coldfusion.sql.QueryTable"

However, when I tried a different method for bringing the masterQuery columns to the VARIABLES scope, I was able to get it to work: "#a#" = evaluate('masterQuery.#a#')

After doing some playing around using GetMetaData().getName() to determine what ColdFusion was seeing when a variable was set using masterQuery["#a#"] vs evaluate('masterQuery.#a#') I learned that ColdFusion continues to see the variable as a type: "QueryColumn" instead of its actual type (string, query, array, struct, etc...).

Currently the only way I can get CF to recognize the proper type is to use the evaluate() function. What's even more annoying is that you can't reference columns in the nested query so masterQuery.subQuery.TestColumn1[2] produces an error message.

I wonder if this a bug within ColdFusion 10. I haven't tested it in any earlier versions and after extensive searching I couldn't find anyone else with a similar problem. Regardless I thought it was pretty interesting and noteworthy.

If you want to see some sample code to generate this error for yourself, here it is:

http://pastebin.com/pBkjUtxc

Message was edited by: Henweigh99

HTTP status code to return when attacked

forums_noreply@adobe.com — Tue, 04 Feb 2014 21:13:55 GMT

My question is not specific to ColdFusion, I know how to set HTTP status codes.

What I am wondering is if anyone knows of any best practices for what to do when a known attack comes into a site. I am speaking primarally of specifically formatted URLs of people scanning to find weaknesses in my sites.

I have collected a large number of URLs that we get scanned for regularly that are clear attempts to locate weaknesses.

Should I?

Send a 404 telling them the attacked page does not exists
Send a 503 making them think it errored
Send a 200 with a blank page making them think they go to a real page
Something else I havn't concidered

I am trying to avoid any sort of escalation on their part thinking they can hit my site harder, IE, if they get a 503, might they believe that my site could be weak and they step up the attack...

Any thoughts would be greatly apreciated.

Thanks

How would you generate a cfimage from an ajax call?

forums_noreply@adobe.com — Wed, 29 Jan 2014 13:29:39 GMT

I have a bunch of form fields that are all bound to a single drop down selection. When an option is selected I need to fill in a bunch of form fields with data. The last part is that I need to retrieve an image that is stored in sql server an image field and output the image on the page. All of the form fields are populating properly based on the cfc I am using. I can generate the image with a straight query output but cannot figure out how to trigger the generation of the image when the cfselect option changes.

Any thoughts?

cant get the font on PDF document and alignment

forums_noreply@adobe.com — Mon, 27 Jan 2014 15:51:21 GMT

I cant get the font on PDF document and alignment eventhough I have margins to 0 still getting some space from the top and left side.

I have added fonts to CF Admin and restarted too still same issue. I am able to see fonts are added in CF Admin.

Adobe Community : Unanswered Discussions - Advanced Techniques

cfprint and UPS labels

AJAX-Powered Related Select Boxes -

How to handle Coldfusion SOAP Web Service Errors

Cfspreadsheet

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

Issue with .net integration

Is it possible to create and then search a collection from within a coldfusion ap?

The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

How can you determine from within CF if cookies are enabled in the browser you are using?

Clearing Session and/or App variables with Log-out Page?

General problem communicating with SOAP-API

In CF 9 can I create a custom page URLs, similar to Wordpress?

Problem with Application Scope

displaying coldfusion reports thru Asp.Net site

Disable cffunction accepting undeclared arguments?

Calendar code preformance issue

CF11 Object doesn't support property or method 'getColumnModel', Unable to get property 'tagName'

Database Design Question: What are the consequences of using a "One Table to Rule Them All" Approach?

Password Protect all .cfm files in a directory?

barcode scan

CF10 Scheduled Task Event Handling Question

Dynamically give a name to cfimage

Unable to preserve indentation in cfgrid

cf9 cfselect bind

cfmessagebox error whatever parameters

How to capture the reconfigure event on ajax grid?

CF11 cfgrid with binding.

How To Re-Compile ONE Component in Real-Time Without CF Restart?

Crosstab - array error

0 is not greater than zero or less than or equal to 0.

cfform flash not getting recognized

How get unique option fileds in a dynamic dropdown box

Need ideas for page refresh

Detect Flash using CF8

What is script syntax for passing form to REST?

Need help with auto suggest - Return multiple fields

Application Slowness with Coldfusion 7

Retrieving all IPs belonging to FaceBook

Passing parameters to Java JT400 object

Testing IP against a group of IPs

issue with onRequestStart query info

Fixing Security Vunerabilities in CF8

Back after 6 months

Delay for

Encoding of UTF8 Characters in URL Strings

XML POST not sucessful

CFSearch returning empty results

Strange Behavior When Working with Nested Query Objects

HTTP status code to return when attacked

How would you generate a cfimage from an ajax call?

cant get the font on PDF document and alignment

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