cfcharts not displaying
Hi, if anyone know please help me. My cf flash charts are not displaying in production, but displaying in test site,where i can check that. Thanks®ards, Rama ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
decrypt values ms-access
Hi , How can i get the decrypted value inside my ms-access query, b'coz that query result i need to compare with another query which has decrypted values. Rama ~| 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-talk/message.cfm/messageid:325332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid loading data
Grid itself is taking long time to load the data, why it is happening like that >Rama, > >IMO, 62 MS is not a significant enough difference in time to be worrying >about page loading > >Dave > >On Mon, Aug 10, 2009 at 7:07 AM, RamaDevi Dobbala wrote: > >> ~| 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-talk/message.cfm/messageid:325316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid loading data
Mozilla:Time=7110ms, Records=109 IE:Time=7172ms, Records=109 >HI Rama, > >can you please provide more information? How many records are you tying to >load. What is the time difference? > >Dave > >On Fri, Aug 7, 2009 at 11:42 AM, RamaDevi Dobbala wrote: > >> ~| 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-talk/message.cfm/messageid:325314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid loading data
hi , If i am using cfgrid in IE, while it is loading data it is taking more time,how can i reduce that,if any one knows please help me in this. Rama ~| 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-talk/message.cfm/messageid:325269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid displaying data
Hi Frnds, My problem is i am displaying my query data through cfgrid,i am able to display but problem is in the same page i have print option for that data, in that data is not coming completly(firefox browser) and if my browser is IE even that some of the data is not coming why? Rama ~| 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-talk/message.cfm/messageid:325177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
current row number in cfgrid
Hi frnds, how can i get current row number inside cfgrid , if any one know please tell . Rama ~| 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-talk/message.cfm/messageid:325029 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
code formatting in Eclipse IDE for coldfusion
hi frnds, hi can we do the code formatting for coldfusion in Eclipse IDE, what settigns we need to do, if any one know please tell me. Rama ~| 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-talk/message.cfm/messageid:324860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid customization
hi frnds, how to customize the cfgrid, based on the no.of columns i am returning that many cfgridcolumns i need to display automatically, how can i do that, please any one can help me... Rama ~| 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-talk/message.cfm/messageid:324805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery
select iif(lm.user_id = s.lead_mgr, (lm.first + ' ' + lm.last) , s.lead_note) as leadMgr, iif(lm.user_id = s.AREA_MGR_RDO, lm.first + ' ' + lm.last , s.Area_Note) as director , iif(lm.user_id = s.sdir_ndir, lm.first + ' ' + lm.last , s.sdir_note) as sndir , iif(lm.user_id = s.vice_pre, lm.first + ' ' + lm.last , s.vice_note) as vicePre , iif(lm.user_id = s.fast_mgr, lm.first + ' ' + lm.last , s.fast_note) as fastMgr , from sourcebook_1 s,user_info lm where s.active = 1 and (lm.user_id = s.lead_mgr or lm.user_id = s.AREA_MGR_RDO or lm.user_id = s.sdir_ndir or lm.user_id = s.vice_pre or lm.user_id = s.fast_mgr) and s.office_id not in(36,37,38,73) order by s.office_number i am writing like this, it is working fine, thanks for your response >I think you want it this way, using a CASE statement for the leadmgr >column. I also moved all your subselects into left joins, which should >give a bit better performance. > > >select >s.address + ' ' + s.address2 + ' ' + s.address3 + ',' + s.city + ',' + >s.state + ',' + s.city as office_address, >leadmgr = case >when (lm.user_id is null) then lm.lead_note >else lm.first + ' ' + lm.last >end, >amr.first + ' ' + amr.last as director, >sn.first + ' ' + sn.last as SDIRNDIR, >vp.first + ' ' + vp.last as VICEPRE, >fm.first + ' ' + fm.last as FASTMGR >from sourcebook_1 s left outer join >user_info lm on s.lead_mgr = lm.user_id left outer join >user_info amr on s.area_mgr_rdo = amr.user_id left outer join >user_info sn on s.sdir_ndir = sn.user_id left outer join >user_info vp on s.vice_pre = vp.user_id left outer join >user_info fm on s.fast_mgr = fm.user_id >where active = 1 >and office_id not in (36,37,38,73) >order by office_number > ~| 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-talk/message.cfm/messageid:324803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfquery
select address + ' ' + address2 + ' ' + address3 + ',' + city + ',' + state + ',' + city as office_address, (select first + ' ' + last as full from user_info where user_id =lead_mgr ) as leadmgr, (here if user_id neq lead_mgr i have to return lead_note column) how to do this...please help me (select first + ' ' + last as full from user_info where user_id = AREA_MGR_RDO ) as director, (select first + ' ' + last as full from user_info where user_id = SDIR_NDIR) as SDIRNDIR, (select first + ' ' + last as full from user_info where user_id = VICE_PRE ) as VICEPRE, (select first + ' ' + last as full from user_info where user_id = FAST_MGR ) as FASTMGR from sourcebook_1 where active = 1 and office_id not in(36,37,38,73) order by office_number ~| 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-talk/message.cfm/messageid:324789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
input type="image" onclick jscript
Hi frnds, How to call a javascript function on this function is not calling why? Rama ~| 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-talk/message.cfm/messageid:324731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iif
ya my case should be like that, but i need to pass that result to the cfgrid, along with some ohter rows >IIF is a ColdFusion method, you can't use it in SQL like that. What you're >probably looking for is CASE: > >CASE WHEN u.userid = s.lead_mgr THEN u.first ELSE s.lead_note END AS leadMgr > >Francois Levesque >http://blog.critical-web.com/ > > >On Mon, Jul 20, 2009 at 9:31 AM, RamaDevi Dobbala wrote: > >> ~| 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-talk/message.cfm/messageid:324717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
iif
select s.office_name,u.userid,s.lead_mgr,iIf(u.userid = s.lead_mgr, u.first , s.lead_note ) as leadMgr from sourcebook_1 s ,user_info u where s.active = 1 and office_id not in(36,37,38,73) order by s.office_number is this is correct comparision,please tell me ~| 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-talk/message.cfm/messageid:324714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgridcolumn
Hi frnds, can we give cfgridcolumn name="not in query" which is not there in that query, i have to getr that from some other query, how to get that, if i want to write condition for that column value based on that i have loop some other query and then assing that value to this filed, is it possible, if not give me anyother solution... ~| 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-talk/message.cfm/messageid:324662 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid
select *,Area_Mgr_RDO as Director,Area_Note as dire_Note, IsNull(address,'') +IsNull(address2,'') + IsNull(address3,'') + IsNull(city,'') + IsNull(state,'') + IsNull(zip,'') +IsNull(country,'') as office_address from sourcebook_1 i am writings like this, but still it is giving the error >You would want to wrap each column in the query in an IsNull(coulmnName,'') > >Dave > >On Fri, Jul 17, 2009 at 8:46 AM, RamaDevi Dobbala wrote: > >> ~| 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-talk/message.cfm/messageid:324646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid
if i use like this, if any value is getting null value means all the value is becoming null, how to avoid this > concatenate the 3 columns into one in your query. eg: > > SELECT address1 + ', ' + address2 + ', ' + address3 AS address > FROM sometable > > > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > On 17/07/2009 17:42, RamaDevi Dobbala wrote: > > Hi frnds, > > > > i need to pass address column to cfgrid column, but in my table i > have 3 columns for that address(address,state,city), but while > displaying i have to keep these three into the CFGRIDCOLUMN how to > give that. > > > > > > > > ~| 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-talk/message.cfm/messageid:324643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid
Hi frnds, i need to pass address column to cfgrid column, but in my table i have 3 columns for that address(address,state,city), but while displaying i have to keep these three into the CFGRIDCOLUMN how to give that. ~| 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-talk/message.cfm/messageid:324637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfgrid
Hi frnds, can we give more than one column name in cfgridcolumn tag, and also how to set query result to a variable. Rama ~| 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-talk/message.cfm/messageid:324633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
custom tags
Hi frnds, select primary_id, backup_id from ta_user_level where active=yes and primary_id = #arguments.user_id# in this function i am getting primary acces people and backup_id but iam allowing peolpe only if he is primary, if i want to access the back up people also then what i have to do, my frnd asked me to write custom tag for that, i am not gettign what to do can u suggest me... ~| 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-talk/message.cfm/messageid:324507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
tag
Hi frnds, i have code like this.. Rama before rama i am getting one circle , how to decrese that circle size. Rama ~| 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-talk/message.cfm/messageid:324481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how to get alerts in coldfusion like javascript
Hi Frnds, Here is my problem... I have a search field Search button is an image,if i click on that button after text entered it is giving the result by going to corresponding action, but if don't give any text i have to get an alert how to achive this, if the search string neq to "" it is going to action if it is null i should get alert() Rama ~| 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-talk/message.cfm/messageid:324454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
script.js file inside cfoutput
hi frnds, i have a problem like . . .Here i have my date field, where i have to insert .js file, where ever i am insert it is not taking the file i am calling js function like this javascript:showID(..) error is this ColdFusion was looking at the following text: javascript . . . ~| 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-talk/message.cfm/messageid:324422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
iterating loop
hi frnds, can any one help me here is my question i have 2 file datatrac.csv,datatrac-ag.csv, action for both the files is same but i have to iterate the loop 2 times based on file name, for that how to check file name which is the file and what is the action(through these 2 files i have to insert the data into DB by deleting the previous data) this is very urgent can any one help me on this. ~| 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-talk/message.cfm/messageid:324377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: how to get the absolute path
no, i am including my file in another file there i am giving include like this it is working fine, but i want to give path instead of that , how to give that. >expandPath() is the function you're probably looking for. > >Hope that helps! > >Warm regards, >Jordan Michaels >Vivio Technologies >http://www.viviotech.net/ >Open BlueDragon Steering Committee >Adobe Solution Provider > > >RamaDevi Dobbala wrote: >> now ia m using /../../foldername/filename i am using >> i want to remove those dots, >> how i need to give >> >> ~| 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-talk/message.cfm/messageid:324347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how to get the absolute path
now ia m using /../../foldername/filename i am using i want to remove those dots, how i need to give ~| 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-talk/message.cfm/messageid:324344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how to find file particular file name from a list
Hi Dudes, can anyone suggest me, how to find a particular file from the list of file names. ..Rama ~| 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-talk/message.cfm/messageid:324341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reg:Last modified Date for file
ya exactly, i have all permission on that file.This file path is absolute path. >what does your #application.domainname# var evaluate to? is it an >absolute path, i.e. C:\somedir\blahblahblah ? > >also, check permissions on that folder. can CF access it at all? can CF >read a file from that folder? > > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > > >On 07/07/2009 17:31, RamaDevi Dobbala wrote: >> ~| 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-talk/message.cfm/messageid:324291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reg:Last modified Date for file
File Last modified date:#dateformat(fileDate,' d ')# even i tried with this, it's not printing. >datelastmodified is there in that, but why it is not printing that?. > > >>>Adrian ~| 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-talk/message.cfm/messageid:324289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reg:Last modified Date for file
In some other place i am using the same file path there it is giving correct result only,but not here why? >make sure that >1) the path you specify in DIRECTORY attribute is a) correct and b) full >absolute path (not relative) >2) those files actually exist in that directory > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > > >On 07/07/2009 17:15, RamaDevi Dobbala wrote: >> ~| 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-talk/message.cfm/messageid:324288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reg:Last modified Date for file
datelastmodified is there in that, but why it is not printing that?. >datatrac.csv was last modified on : >datatrac-ag.csv was last modified on : >query > ATTRIBUTES DATELASTMODIFIEDDIRECTORY MODENAME > SIZETYPE > >it's printing the structure not the values: > > >>Dump qGetLastdateModified to see what's being returned as your code looks >>sound. >> >>Adrian ~| 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-talk/message.cfm/messageid:324287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reg:Last modified Date for file
datatrac.csv was last modified on : datatrac-ag.csv was last modified on : query ATTRIBUTES DATELASTMODIFIEDDIRECTORY MODENAME SIZETYPE it's printing the structure not the values: >Dump qGetLastdateModified to see what's being returned as your code looks >sound. > >Adrian ~| 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-talk/message.cfm/messageid:324285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reg:Last modified Date for file
#page# was last modified on : #DateFormat(qGetLastdateModified.dateLastModified, "mm/dd/")# i am wrikting this query but i am not able to see date, for me just i am able to see till this ( #page# was last modified on :), after this modified date is not printing, why it is happening like this, is there any thing wrong in this code? > > >will return a query object listing all of the files. if you do a >of that query, you'll see the dateLastModified as one of the available >columns. > >On Tue, Jul 7, 2009 at 2:38 AM, RamaDevi Dobbala wrote: > >> >> I need help on this, can any one tell me that, how can i get the last >> modified date of a file, because every day my file is going to update i.e >> some scheduler is runnign for that.Just i need last modified date of that >> file. >> >> ~| 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-talk/message.cfm/messageid:324282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Reg:Last modified Date for file
I need help on this, can any one tell me that, how can i get the last modified date of a file, because every day my file is going to update i.e some scheduler is runnign for that.Just i need last modified date of that file. ~| 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-talk/message.cfm/messageid:324279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
