Re: cfssetting showdebugoutput

I am using access='remote' in my cffunction method: so Used cfsetting showdebugoutput=no after the cfcomponent but with no effect. I dont see any output, but I donot see any result in my grid. below is the jquery function calling the cfc: script type=text/javascript

Javascript Cfquery

Hi All - I am trying to do the following: script language=text/javascript function abc(arg1, arg2) { cfquery name=q datasource=.. select * from table1 where col1 = arg1 /cfquery .. } /script Is it possible to pass javascript arguments to a coldfusion

Array Error

Hi All - I am trying to do the following in my code. cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData = arrayNew(1) /

Re: Array Error

Hi All - I am trying to do the following in my code. cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData

cfssetting showdebugoutput

Hi All - I am using jqgrid to display some data. This works when I turn off the Request Debugging Output in Coldfusion Administrator. I do not have access to Administrator page at my work. Using cfsetting showdebugoutput = false also does not help. Is there a way I can disable request

Algorithms

Hi All- This question is not directly related to Coldfusion. I just came across the below lectures on algorithms from MIT. Does it help to know those concepts to get better in Coldfusion?

Re: Need suggestion to achieve this functionality

I don't understand your implementation so I can't answer the question properly. Why the fascination with cfgrid? Are you updating text input fields in the grid or is it some other functionality that you want to implement from cfgrid? Sorting, paging, etc? Please explain. Yes, I would be

Re: Need suggestion to achieve this functionality

I user JQuery treeview for the tree functionality. To recurse through the directory with a recursive custom tag in the 'tags' directory cfif not compareNoCase(type,dir) and not name contains _thumbs cfelseif not name contains _thumbs and not name contains .db and name neq

Re: Need suggestion to achieve this functionality

I user JQuery treeview for the tree functionality. To recurse through the directory with a recursive custom tag in the 'tags' directory cfif not compareNoCase(type,dir) and not name contains _thumbs cfelseif not name contains _thumbs and not name contains .db and name neq

Need suggestion to achieve this functionality

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 -

Flex/Coldfusion Open source projects

Hi All - What are the best active projects in Flex, Coldfusion or both. I am good in Coldfusion, but I never got a chance to work in advanced topics. Also, I am very interested in learning Flex and I want to learn by contributing to existing projects. Also, it would be great if anyone can

Question on form variables

Hi All - This might be a silly question, but I am confused with below scenario...I have some form variables set on a page, and clicking on submit button, I go to second page, where I am dumping these form variables...Some of the variable values show up as empty string, but when I see the form

Re: Question on form variables

Yes, I am setting the hidden variables Setting a variable into the FORM scope on page one, will not automatically put those variables, or their values, into the FORM scope on page two. You'd need to add a hidden form field on page one, and populate it's value from the FORM variable you're

Re: Question on form variables

Yes, you are right. So you're saying that when you inspect the FORM scope, by cfdumping it, on page two that the variables are there? But when you output them by themselves (FORM.varOne) they're empty? andy Yes, I am setting the hidden variables Setting a variable into the FORM scope on

Re: Question on form variables

Thank you All..There was some other place where this variable was getting overwritten... Are you cfparaming those variables at the top of page two? Are you cfincluding any code that might overwrite those variables? andy Yes, you are right.

Re: Question on form variables

, the default is get if not set. Sent from my iPhone On 7 Sep 2010, at 20:00, fun and learning funandlrnn...@gmail.com wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp

Style sheets with cfcontent

Hi All - I am trying to export some data to excel, and the CSS styles do not seem to be working. It works fine when I use inline style attribute, but when I use class attributes and link to the external stylesheet, it does not seem to be working. I am using MS Office 2003. Did anyone face

Navigation Issue.

Hi All - I have a directory structure as follows: folder1 - Includes - index.cfm folder2 - index2.cfm I have some links on index.cfm which on clicking goes to index2.cfm in folder2. I am using javascript, and the action attribute is: document.forms[0].action = ../folder2/index2.cfm.

CSS and cfcontent

Hi All- Does linked CSS document apply styles to the HTML within cfcontent (type=excel). I do not see any CSS formatting in the excel document... ~| Order the Adobe Coldfusion Anthology now!

coverting string to a numeric value

Hi All- is there a way I can convert a string to number in coldfusion. I could not see any related functions to do this? Thanks ~| Order the Adobe Coldfusion Anthology now!

URL Path question

Hi All - I have a dropdown which calls a javascript function on onchange event. The onchange function is as follows: function on_change(arg1) { document.forms[0].action = Include/index.cfm?var1= + arg1; document.forms[0].method = post;

Query of queries question

HI All - I have a query which returns the result set like below. The column names are like 1990, 1991, 1992 and there are certain amount for each year 1990 1991 1992 1000 5000 6000 2000 2000 3000 I have a query of query which finds the sum of the amounts for year 1990, and I use the query

Re: Query of queries question

than just summing the number you entered. In some databases you can force the issue by surrounding the column header in quotations (Sum('1990')) but you cannot count on that, you are better off renaming your column headers as I said earlier. Jim Eisenhauer On Wed, Jun 9, 2010 at 8:27 AM, fun

Re: Query of queries question

:41 AM, fun and learning funandlrnn...@gmail.comwrote: Thanks you all for the replies. Prepending a variable before the year helped me ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion

coldfusion and dynamic query columns

I have a query which has static as well as dynamic columns. something like below: cfset vMarks = marks1, marks2, marks3 cfquery name=querymarks datasource = abc SELECT firstname, lastname, cfloop from=1 to=listlen(vMarks) index=index marks_#index# cfif #index# NEQ

reading dynamic sql columns in coldfusion

I have a query which has static as well as dynamic columns. something like below: cfset vMarks = marks1, marks2, marks3 cfquery name=querymarks datasource = abc SELECT firstname, lastname, cfloop from=1 to=listlen(vMarks) index=index marks_#index# cfif #index# NEQ listlen(vMarks),/cfif

transposing sql rows as columns

Hi All - I have a query which returns result set as follows: year amt_type amount 2001 vacation 1000 2001 medical 1000 2001 college 15000 2002 vacation 800 2002 medical 1000 2002 college 1 2003 vacation 400 2003 medical 2000 2003 college 8. I am trying to make the years 2001,

AJAX Question

Looks like the AJAX forums is not active, so I thought I will post my question here. What is the difference between onload and onreadystatechange event in AJAX? Can either of the function be used to check if the XMLHTTPRequest state has been changed?

Javascript elements not recognized

Hi All, I am trying to do the following: script language=javascript cfquery name=test datasource=test select a from table1 /cfquery cfif #test.recordcount# neq 0 document.forms[0].method = post; document.forms[0].target = _blank;

sql method in cfcatch

Hi All - I am using try/catch around a cfquery. When I am trying to output #cfcatch.sql# or #cfcatch.where#, I get an error that SQl or where is undefined in cfcatch. These two used to work for me before. I have no issues with cfcatch.message or cfcatch.detail. Can anyone let me know what

cfcatch issue

hi all- I am using try/catch around a cfquery, and when I use #cfcatch.SQl# within cfcatch, I get an error saying sql is undefined in cfcatch. The same happens with #cfcatch.where#. Everything is fine with #cfcatch.detail#, #cfcatch.message#. I have been working with #cfcatch.sql# and

what is wrong with this code

Hi All, I know this is coldfusion forum, but can any one tell me what I am missing to make the fileName get within quotes in javascript. I am getting everything right except in callURL, the fileName is sent as argument, but the real value is not enclosed within quotes. I tried different

Re: what is wrong with this code

I think this'll work: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\fileName\)'Link1/a; On Thu, Apr 15, 2010 at 3:58 PM, fun and learning funandlrnn...@gmail.comwrote: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1

Re: what is wrong with this code

callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ(\ + fileName + \)'Link1/a; Does not work..Shows syntax error. On 4/15/2010 4:58 PM, fun and learning wrote: Hi All, I know this is coldfusion forum, but can any one tell me what I am missing to make

Re: what is wrong with this code

Oops, put the +'s back in: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On Thu, Apr 15, 2010 at 4:07 PM, fun and learning funandlrnn...@gmail.comwrote: Nope, it displays the following a href='##' onClick='javascript:return parent.frames[1

cfquery within javascript

hi, I am trying to do the following: I wrote a cfquery within javascript function as below: script language=javascript1.2 type=text/javascript cfquery name=query1 datasource=abc /cfquery cfif query1.recordcount neq 0 cfoutput query = query1 cfquery name=query2 datasource=abc

Eclipse search question

Hi, Is there a way in Eclipse (I am using CFEclipse) to search for something in the entire project folder. I see that option of searching the entire folder in Dreamweaver, but not in eclipse unless I am missing something. Can any one please clarify this? Thanks.

resetting form variables

Hello All, I am trying to do the following: I have a web page which has all form variables populated based on previous page selection. One such variable is current year. There is a link called 'previous year data' which upon clicking opens a new page for the previous year and shows previous

test

Hello, This is a a test message. My previous two posts are not displayed on house of fusion ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

resetting form variables

Hello All, I am trying to do the following: I have a web page which has all form variables populated based on previous page selection. One such variable is current year. There is a link called 'previous year data' which upon clicking opens a new page for the previous year and shows previous

how to maintain source code

Hello All - Have any of you faced a situation where the place you work does not have a version control software, and in that case what are the best way to maintain code files on your development machine? Thanks. ~| Want to

sample ldap

Hi All, Is there a sample or example ldap for learning purposes? I am learning LDAP for implementing in Coldfusion Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of

IDE for coldfusion 9

Hi, Can anyone tell me if there is a new CFEclipse plugin for Coldfusion 9? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: IDE for coldfusion 9

Yes the latest version of CFE has a CF 9 dictionary. i.e. It supports CF9 syntax. G! On Tue, Feb 9, 2010 at 2:13 PM, fun and learning funandlrnn...@gmail.comwrote: Hi, Can anyone tell me if there is a new CFEclipse plugin for Coldfusion 9? Hi All, Thanks a lot for the information. I

coldfusion interview questions

Hi, Can anyone suggest if there any ebook available related to coldfusion interview questions or any other sources... Thanks, ~| Want to reach the ColdFusion community with something they want? Let them know on the House of

Re: difference between cfproperty and variables defined with This scope

CF 9 changed this significantly. With CF 9, using CFPROPERTY actually creates a public variable in addition to creating documentation. In addition to that, it also creates accessors and mutators (setters and getters). It doesn't actually generate visible code in your CFC, but those methods

difference between cfproperty and variables defined with This scope

Hi All, Can anyone please tell me the difference between cfproperty tag and variables defined using this scope. Both are used to define CFC properties? ~| Want to reach the ColdFusion community with something they want? Let

Coldfusion and oracle stored procedure

Hi All - I was learning on oracle stored procedures and retrieving the results from Coldfusion. I am using ref cursor for reading a table in the database. The procedure is as follows: create or replace PROCEDURE EMP_REF_CURSOR AS TYPE cur_emp IS REF CURSOR RETURN EMPLOYEES%ROWTYPE;

cfsqltype error

Hi All, I am getting the following error when I am trying to insert data into the database: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER The line one which the error is shown is using a cfqueryparam cfsqltype=cf_sql_varchar value = #somevalue# but the error says cf_sql_integer. can anyone

reading a flat file

Hi, I have a flat file with rows of data as follows: 12/12/2009,AL,Alabama 12/12/2009,AK,Arkansas I am able to read the file using cffile read action. Once I read the file, I should be able to compare the state in the flat file with customer state(which is retrieved from a database). I need

Storing uploaded files

Hi, I am working on a functionality where the user has to upload files. Most of the files or almost all files would be of pdf format. What is the best way to store these files? On the server or on database? Thanks. ~| Want

Strange problem when navigating to a coldfusion page

Hi All, I am getting an error as follows when I am trying to navigate to a coldfusion page on my computer. File not found:/Trying/Jsonlearn/admin/setup/setup.cfm but the URL I was trying was http://127.0.0.1/Trying/Jsonlearn/json1.cfm. Can anyone please help me in knowing what is causing

Deleting a node from XML document

Hi All, Can anyone please help me on finding out how to delete an element with element id courses.specialization2 in the following XML structure? ?xml version=1.0 encoding=UTF-8 ? error pages page descr=Specialization id=specialization_name elements

Re: Include one form within another

Thanks for the solution Dave... In the form I am creating, sometimes the user would be presented with a link to enroll themselves (This would happen before the actual form submission). So, when they click that which takes them to another form, those form fields should get prepoulated

Re: Coldfusion Date format question

Hi All, Thanks a lot for the answers. It works now... Thanks Using cfsqltype=cf_sql_timestamp will definitely solve that problem. I expect you're just trying to give an example, but if all you're trying to do is move values from one table to another, you can do this en-mass with

Include one form within another

Hi All, I am faced with a peculiar situation. I have a form, which has a save link at the end of finishing the form. In the form, I have used Javascript to show/display some other hyperlink, and it has its own href attibute and am passing variables with it as URL scope. But now, I need to

Re: Include one form within another

In the form I am creating, sometimes the user would be presented with a link to enroll themselves (This would happen before the actual form submission). So, when they click that which takes them to another form, those form fields should get prepoulated with the form fields that I need to pass

Coldfusion Date format question

Hello All, I have an issue inserting date and time together into a database table from coldfusion. Right now, I am using cfquery to get records from a particular table, in which one of the field is date, and its value in the database is something like 2/14/2007 9:10:12 AM. I am performing

eGate and coldfusion

Hello everyone, Can anyone explain me what is egate and what are sub and pub in an egate? Has anyone used this one with Coldfusion? I know my question is very vague, but I do not find any precise information about egate. It would be great if any one can explain me this. Thanks.

<    1   2