Re: Writing huge data to excel

2014-07-01 Thread funand learning
ax. > > HTH, > Jon > > On Jul 1, 2014, at 10:03 AM, funand learning > wrote: > > > > > Hi, > > > > I am working on exporting data to excel with multiple sheets. The sheets > > are dynamic and may range from 2 to more than 5. What is the best

Writing huge data to excel

2014-07-01 Thread funand learning
Hi, I am working on exporting data to excel with multiple sheets. The sheets are dynamic and may range from 2 to more than 5. What is the best way to handle this? 1) Use cfspreadsheet or APACHE POI? Do these support dynamic creation of sheets? I have tried with cfspreadsheet but only the last sh

Issue with cfspreadsheet

2014-05-20 Thread funand learning
Hi All - I am creating multiple sheets of data using cfspreadsheet and using the script here http://cfsimplicity.com/16/forcing-values-to-be-inserted-into-spreadsheets-as-textto force few columns to be treated as text. The issue I am facing is, when number of records for all the sheets combined r

Loading message for excel pages

2014-05-13 Thread funand learning
All - I have a following link http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358648 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.house

Re: Displaying page loading message

2014-03-25 Thread funand learning
thank you Jonah. Your solution helped On Mon, Mar 24, 2014 at 5:00 PM, .jonah wrote: > > Display a page with the "loading" message then a client-side (meta or > js) redirect to the slow page. > > On 3/24/14 1:53 PM, fun and learning wrote: > > All, > > > > I have an issue with displaying a pag

Re: Element undefined in SESSION scope

2013-08-07 Thread funand learning
I see that session variables are persisting only after turning on 'use J2EE session variables' setting in coldfusion admin. Here is the link to the question I posted on stackoverflow http://stackoverflow.com/questions/18093985/coldfusion-enabling-j2ee-session-variables-vs-coldfusion-session-variab

Re: Element undefined in SESSION scope

2013-08-06 Thread funand learning
at 3:07 PM, funand learning wrote: > I am just setting up a variable to capture cgi.http_referer. > > . Initially, the variable was > set up as > > > This variable is defined on a form, which submits to itself. I want to > capture the initial cgi.http_referer value when the

Re: Element undefined in SESSION scope

2013-08-06 Thread funand learning
I am just setting up a variable to capture cgi.http_referer. . Initially, the variable was set up as This variable is defined on a form, which submits to itself. I want to capture the initial cgi.http_referer value when the user first lands on the form and save it to database upon successful su

Re: Standard w3c tags

2013-04-23 Thread funand learning
I have been asked to add standard meta tags to the web pages. I was only aware of couple them like description and content-type, and wanted to make sure about remaining meta tags On Tue, Apr 23, 2013 at 11:14 AM, Dave Watts wrote: > > > Thank you all > > It might be worthwhile for you to tell u

Re: Standard w3c tags

2013-04-23 Thread funand learning
Thank you all On Tue, Apr 23, 2013 at 11:09 AM, Dave Watts wrote: > > > Well sure, there may be. Any browser can support whatever the heck they > > wanted. But if you want to know the *official* list, the spec is your > best > > bet. > > Fortunately, using name meta tags doesn't even require br

Re: Standard w3c tags

2013-04-23 Thread funand learning
Apart from the example list provided, are there more meta tags? On Tue, Apr 23, 2013 at 10:52 AM, Raymond Camden wrote: > > Maybe I'm confused, but wouldn't the spec (your link) be the standard? > > > On Tue, Apr 23, 2013 at 10:41 AM, funand learning > wrote: >

Standard w3c tags

2013-04-23 Thread funand learning
All - What are the list of standard meta tags defined in w3c other than the below given at http://www.w3.org/wiki/HTML/Elements/meta I posted the same question in stackoverflow http://stackoverflow.com/questions/16171686/list-of-standard-w3c-meta-tags Thanks ~~~

Re: Impact of cross site scripting in google search appliance

2013-03-26 Thread funand learning
Ok. With existing XSLT, when I use alert statement in GSA URL, it throws an alert statement but the search results return a message "No results available". but when I use the same search term in google.com, it does not throw any alert statement. Do you think I need to update XSLT to not execute a

Re: Impact of cross site scripting in google search appliance

2013-03-26 Thread funand learning
Dave, What do you mean when you said that it is possible to modify default XSLT and do dangerous things with inputs? Thanks On Tue, Mar 26, 2013 at 1:04 PM, Dave Watts wrote: > > > On our websites, we use google search appliance (GSA). When a user > enters a > > search term, and submits the f

Re: Impact of cross site scripting in google search appliance

2013-03-26 Thread funand learning
Dave, What do you mean when you said that it is possibe to modify default XSLT and do dangerous things with inputs? Thanks, Lavanya On Tue, Mar 26, 2013 at 1:04 PM, Dave Watts wrote: > > > On our websites, we use google search appliance (GSA). When a user > enters a > > search term, and submi

Impact of cross site scripting in google search appliance

2013-03-26 Thread funand learning
All - On our websites, we use google search appliance (GSA). When a user enters a search term, and submits the form, it goes to GSA.We are using GET method hence the search term is passed as a URL variable. There is chance of tampering the search term in the URL, for example adding alert statemen

Re: Issue with Session scope

2013-03-15 Thread funand learning
sure, since I've never set an >> >app timeout so short. :-) >> > >> >HTH >> > >> > >> >On Fri, Mar 15, 2013 at 11:18 AM, funand learning >> >wrote: >> > >> >> >> >> I did enable sessio

Re: Issue with Session scope

2013-03-15 Thread funand learning
> > On 3/15/13 11:24 AM, "Matt Quackenbush" wrote: > > > > >Your application timeout is seriously set to 10 seconds?? I suspect that > >would hose sessions pretty quickly, but not sure, since I've never set an > >app timeout so short. :-) > >

Re: Issue with Session scope

2013-03-15 Thread funand learning
I did enable session management using cfapplication tag. Below is the piece of code On Fri, Mar 15, 2013 at 12:15 PM, Bobby wrote: > > Sounds like your sessions aren't persisting across requests. There could > be a couple of reasons but the most common, from what I've seen, is that > people

Re: question on cfloop

2013-02-28 Thread funand learning
I am sorry, I wasn't clear. the "to" is arraylen. Sometimes the arraylen is 1 #j# --this returns 2 On Thu, Feb 28, 2013 at 6:34 PM, Phillip Vector wrote: > > Why are you looping from 1 to 1? That isn't a loop. > > On Thu, Feb 28, 2013 at 7:22 PM, fun and learning > wrote: > > > > I

Question about CF Patches

2013-02-20 Thread funand learning
All - Has anybody faced a problem where you have to clear browser cache for application that requires log in? We have applied patches two weeks back, but last week we were not able to login into an application until the browser cache was cleared, and it repeated again yesterday too. This never ha

Re: Coldfusion app response slow

2013-02-18 Thread funand learning
. > > > On Mon, Feb 18, 2013 at 3:40 PM, funand learning >wrote: > > > > > All - > > > > Would there be a performance hit if the server monitor is enabled for > long > > periods of time? > > > > On Tue, Feb 5, 2013 at 1:57 PM, Russ Michaels

Re: Coldfusion app response slow

2013-02-18 Thread funand learning
All - Would there be a performance hit if the server monitor is enabled for long periods of time? On Tue, Feb 5, 2013 at 1:57 PM, Russ Michaels wrote: > > Fusionreactor does not have all the info thar the server monitor does, the > server monitor is better for drilling down into memory usage.

Issues after applying Coldfusion patches

2013-02-13 Thread funand learning
All - Our admins have been applying patches to our Coldfusion servers (version 8). They said most of the patches affect coldfusion admin. During testing coldfusion administrator after applying patches, I found that verifying databases would throw this error There was an error accessing this page.

Re: Coldfusion log file setting

2013-02-07 Thread funand learning
I figured appFolderCF might be a share created for JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion On Thu, Feb 7, 2013 at 1:46 PM, fun and learning wrote: > > All - > > I have a question related to the Coldfusion directory structure > > I have the main folder which has all coldfus

Re: Coldfusion app response slow

2013-02-06 Thread funand learning
Thank you all for you replies. I will try server monitoring and keep you posted On Tue, Feb 5, 2013 at 1:57 PM, Russ Michaels wrote: > > Fusionreactor does not have all the info thar the server monitor does, the > server monitor is better for drilling down into memory usage. > > Regards > Russ

Re: Coldfusion app response slow

2013-02-05 Thread funand learning
Thanks for your reply. As of now, I do not see any useful information from Coldfusion server monitor (accessed via coldfusion admin). The only information I see on overview page is *JVM Memory(used/total) MB - 107/177.* Do I need to turn on "Start Monitoring"/"Start profiling"/"Start Memory track

Re: Changes do not show up on live website

2012-12-14 Thread funand learning
Thanks a lot for your replies. We found the issue and its a very silly one. We used to have a script that copies files from test server to prod server. I never had to bother what the folder name in prod was as script was written long back and we just run it. Recently the script was broken due to s

Re: Changes do not show up on live website

2012-12-14 Thread funand learning
a > production environment. However it has not been my job to troubleshoot > this sort of thing for a number of years now, so I would not take my advice > as gold. > > -- > Adam > > > > On 14 December 2012 16:13, funand learning > wrote: > > > > &

Re: Changes do not show up on live website

2012-12-14 Thread funand learning
Another question. Is it safe to delete those files? Coldfusion does not use any of those files, right? On Fri, Dec 14, 2012 at 10:05 AM, Adam Cameron < adamcameroncoldfus...@gmail.com> wrote: > > Sorry, yes. > > -- > Adam > > On 14 December 2012 16:04, funand learn

Re: Changes do not show up on live website

2012-12-14 Thread funand learning
are these cfclasses in WEB-INF folder? On Fri, Dec 14, 2012 at 9:56 AM, Adam Cameron < adamcameroncoldfus...@gmail.com> wrote: > > OK, but what about the files in cfclasses? It's unlikely there's old ones > in there if the setting is off, but sometimes there's some cruft lying > around. > > -- >

Re: cfftp error 533

2012-12-06 Thread funand learning
ok very silly mistake on my part. I was using the wrong directory name in the code. On Wed, Dec 5, 2012 at 10:15 PM, fun and learning wrote: > > Hi All - > > I am trying to ftp files using cfftp coldfusion tag. It worked fine until > this evening, and all of a sudden, the following error is bei

Re: duplicate keys in rss xml feed

2012-12-05 Thread funand learning
Ray, Thanks for the suggestion on keys being available as array under the node. I was able to get the values for duplicate keys. Below is the code I used, I guess it can be improved upon On Wed, Dec 5, 2012 at 2:54 PM, Raymond Camden wrote: > > It should be available as

Re: cflocation not working

2012-11-15 Thread funand learning
I put this code in application.cfm, but when I put it in some other common include file it works. How to make this work in application.cfm file? On Thu, Nov 15, 2012 at 11:42 AM, Robert Harrison < rob...@austin-williams.com> wrote: > > Your problem is the cgi vars. Test it without the if stateme

Re: cflocation not working

2012-11-15 Thread funand learning
I see "/test/folder1" On Thu, Nov 15, 2012 at 11:32 AM, Raymond Camden wrote: > > So when you output cgi.http_url, what do you see? > > > > On Thu, Nov 15, 2012 at 11:31 AM, fun and learning > wrote: > > > > > Hi All - > > > > I am using the following code to redirect a page > > > > > > >

Re: The requested URL not found

2012-07-24 Thread funand learning
What if the URL is getting converted to friendlyURLs? How can this be handled? On Tue, Jul 24, 2012 at 9:14 AM, Russ Michaels wrote: > > Add the fikename to the url and it should work. > > Regards > Russ Michaels > On Jul 24, 2012 3:11 PM, "funand learning" >

Re: The requested URL not found

2012-07-24 Thread funand learning
Yes, the URL looks like http://abc.com/?visitfrom=youtube<http://www.abc.com/?visitfrom=youtube> On Tue, Jul 24, 2012 at 8:59 AM, Will Swain wrote: > > Possibly being daft here, but do you have the http:// prefix? > > will > > -Original Message-

The requested URL not found

2012-07-24 Thread funand learning
Hi All, We have youtube video with a link to our website embedded on it. The URL has query string as below: www.abc.com/?visitfrom=youtube The above URL is causing an error as "The requested URL /?visitfrom=youtube not found on this server. Could this be happening due to "/" before the start o

finding html tags

2012-06-07 Thread funand learning
Hi All - I am trying to find if a particular string has html tags in it. For example I am using the following line of code to see if p tags exist #FindNoCase("",htmlCodeFormat(myStr))# The above always returns 0. Do I need to use regex to achieve the desired result?

Re: FarCry CMS question

2012-05-09 Thread funand learning
Yes you are right. go.cfm is using URL.path where as farcry 6 is using furl variable. I am using farcry 6. I have read through the docs, and its not mentioned clearly anywhere about the friendlyURL. Can you tell me if my understanding is correct below: 1) User requests a page with url like www.ex

Re: Question on scopes

2011-09-19 Thread funand learning
es and therefore the same session. > > To do this you'll probably need to pass the year along in the URL as you > go from page-to-page. > > On 9/19/11 8:10 AM, funand learning wrote: > > @Russ. I am not sure I understand what you are saying. > > > > if my index.

Re: Question on scopes

2011-09-19 Thread funand learning
@Russ. I am not sure I understand what you are saying. if my index.cfm is as follows: 2000 2001 2002 2003 The second page is as follows: *results.cfm* Go to next page *onemorepage.cfm* Go to search page I have application.cfm too which has the following line: so

Re: Question on scopes

2011-09-19 Thread funand learning
Thanks for the replies. I got my scenario wrong I guess. So when the user select a year say '2000' and proceeds to next page to see some data for that year. then he clicks 'ctrl + n' to open new window. and now he wants to select a different year say 2003 and want to see 2003 data. The purpose for

Re: Question on scopes

2011-09-18 Thread funand learning
Thanks for the answer. Between session, client and cookie, I think i will have to use client/cookie to store the values because I will need the values to be available for multiple browsers. I mean, the user might want to open a new browser using 'CTRL + N', so the value of tax year on new window s

Re: coldfusion spreadsheet leading zeroes issue

2011-08-17 Thread funand learning
I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/d

Re: coldfusion spreadsheet leading zeroes issue

2011-08-17 Thread funand learning
makes the column display as a character field by default. It is > used specifically to handle leading zeros. > > Brian Cain > > On Tue, Aug 16, 2011 at 3:22 PM, funand learning >wrote: > > > > > If I use a single quote as leading character, then thta single quote &

Re: coldfusion spreadsheet leading zeroes issue

2011-08-16 Thread funand learning
If I use a single quote as leading character, then thta single quote would appear in excel sheet right? At what point should I remove the quote? Can anything be done on database side. I mean can the query be formatted in any way? On Tue, Aug 16, 2011 at 2:41 PM, Brian Cain wrote: > > You could

cfgrid bind question

2010-12-04 Thread funand learning
Hi All- I am trying to use cfgrid, as below . I also have a application.cfm file which is checking for a URL variable as below: The problem is the call to remote cfc is checking for this URL variable. How can I pass a URL variable in the bind attribute? Thanks ~

Re: cfselect and autosuggest

2010-11-17 Thread funand learning
Yes cfselect does not have autosuggest attribute. On Wed, Nov 17, 2010 at 11:15 AM, morgan l wrote: > > I'm pretty sure cfselect doesn't have a built-in autosuggest. > > On Wed, Nov 17, 2010 at 10:08 AM, Azadi Saryev >wrote: > > > > > On 17/11/2010 22:13 , fun and learning wrote: > > > without

Re: cfssetting showdebugoutput

2010-10-12 Thread funand learning
I am using access="remote" in cffunction, and immediately after the tag. This does not work either. i also tried using cfsetting in application.cfm with no use. Any other alternatives I can try? On Sun, Oct 10, 2010 at 7:40 PM, enigment wrote: > > I'm pretty certain that "no", "false", and "

Re: Comma Prepending to a form variable

2010-05-18 Thread funand learning
name. > Your action page will insert a comma in the form fields to delimit the > fields. > > Paul Alkema > http://paulalkema.com/ > > -----Original Message- > From: funand learning [mailto:funandlrnn...@gmail.com] > Sent: Tuesday, May 18, 2010 1:50 PM > To: cf-ta

Comma Prepending to a form variable

2010-05-18 Thread funand learning
Hi All, I have a form variable which contains a list of names like when I go from the current page to another page and I check the above form value, I have it as I am getting that extra comma before the first value. How to make sure I do not have that extra comma? Thanks ~~~

Extra Comma prepends to a form variable

2010-05-18 Thread funand learning
Hi All, I have a form variable which contains a list for example ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://w

Re: what is wrong with this code

2010-04-15 Thread funand learning
Hey Jason, It works for me too...Thanks a lot... On Thu, Apr 15, 2010 at 5:29 PM, Jason Fisher wrote: > > This works for me: > > function jscript1(){ > var theString = "screen1.cfm"; > > var fileName = theString.substring(0,theString.lastIndexOf(".")); > > callURL =

Getting frame name in Coldfusion

2010-04-14 Thread funand learning
Is there a way to determine the frame's name in coldfusion? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf

Re: Eclipse search question

2010-04-10 Thread funand learning
Thanks a lot for the replies..it works for me On Sat, Apr 10, 2010 at 11:47 PM, Greg Morphis wrote: > > Ctrl + H and change the scope?.. I usually only have a couple projects > open so Workspace works for me > > On Sat, Apr 10, 2010 at 10:36 PM, fun and learning > wrote: > > > > Hi, > > >

Re: test

2010-04-07 Thread funand learning
Actually, I am not able to see my post on houseoffusion.com website. I am able to get them to my gmail immediately.. On Wed, Apr 7, 2010 at 12:32 PM, Michael Dinowitz < mdino...@houseoffusion.com> wrote: > > Actually it is a header, though maybe not one you would expect. > > Each email message s

Difference between 3 tier architecture and MVC pattern

2010-01-18 Thread funand learning
Hi All, I was trying to understand the concepts of fusebox and came across MVC design pattern, Can anyone please help me in understanding the difference between MVC and 3 tier architecture. I am confused as both are concerened with separation of layers? Thanks.

Re: reading a flat file

2009-11-01 Thread funand learning
Got it...Thanks On Sun, Nov 1, 2009 at 3:54 PM, fun and learning wrote: > > 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

Re: Strange problem when navigating to a coldfusion page

2009-07-25 Thread funand learning
Thanks a lot Claude. There was an application.cfc file in the webroot which I did not notice. Now its working... On Sat, Jul 25, 2009 at 3:52 PM, Claude Schneegans < schneeg...@internetique.com> wrote: > > >>Can anyone please help me in knowing what is causing this problem? > > May be some redi

Re: directorywatcher event gateway...doesn't work for me

2009-05-06 Thread funand learning
Is the gateway instance running in Coldfusion admin? You are saying that you have changed a file in the directory?.Was it running fine before the changes? Is the CF path in the admin same as the one in the configuration directory? On Fri, May 1, 2009 at 6:02 PM, Yuliang Ruan wrote: > > So I'm se

CF Report Builder and Excel format

2009-04-17 Thread funand learning
Hi Everyone, I was trying to display a report in excel format in report builder. It shows the data, but I do not find the print button options, whereas I can see it with other formats. Is this the way it is, or do I need to format anything more within my report for showing up the print button o