upgrade JRE version and latest vista..
Hi We are going forward these upgrades. Do you have any idea impacts on following changes on server.. Java Runtime Engine version 1.5_11 upgrading to Microsoft Vista Enterprise-wide use client-side Java Runtime Engine I appreciate your advises or comments.. Thanks for your help. Regards Ramesh Version Information Server Details Server Product ColdFusion MX Version 7,0,0,91690 Edition Enterprise Serial Number CED700-52460-07253-54426 Operating System Windows 2003 OS Version 5.2 JVM Details Java Version 1.4.2_11 Java Vendor Sun Microsystems Inc. Java Vendor URL http://java.sun.com/ Java Home d:\j2sdk1.4.2_11\jre Java File Encoding Cp1252 Java Default Locale en_US File Separator \ Path Separator ; Line Separator Chr(13) User Name SYSTEM User Home C:\Documents and Settings\Default User User Dir D:\CFusionMX7\runtime\bin Java VM Specification Version 1.0 Java VM Specification Vendor Sun Microsystems Inc. Java VM Specification Name Java Virtual Machine Specification Java VM Version 1.4.2_11-b06 Java VM Vendor Sun Microsystems Inc. Java VM Name Java HotSpot(TM) Server VM Java Specification Version 1.4 Java Specification Vendor Sun Microsystems Inc. Java Specification Name Java Platform API Specification Java Class Version 48.0 CF Server Java Class Path ;D:/CFusionMX7/runtime/../lib/ant-launcher.jar; D:/CFusionMX7/runtime/../lib/ant.jar; D:/CFusionMX7/runtime/../lib/axis.jar; D:/CFusionMX7/runtime/../lib/bcel.jar; D:/CFusionMX7/runtime/../lib/cdo.jar; D:/CFusionMX7/runtime/../lib/cdohost.jar; D:/CFusionMX7/runtime/../lib/cf4was.jar; D:/CFusionMX7/runtime/../lib/cf4was_ae.jar; D:/CFusionMX7/runtime/../lib/cfmx-ssl.jar; D:/CFusionMX7/runtime/../lib/cfusion.jar; D:/CFusionMX7/runtime/../lib/commons-beanutils-1.5.jar; D:/CFusionMX7/runtime/../lib/commons-collections-2.1.jar; D:/CFusionMX7/runtime/../lib/commons-digester-1.3.jar; D:/CFusionMX7/runtime/../lib/commons-discovery.jar; D:/CFusionMX7/runtime/../lib/commons-logging-1.0.2.jar; D:/CFusionMX7/runtime/../lib/commons-logging-api-1.0.2.jar; D:/CFusionMX7/runtime/../lib/commons-net-1.2.2.jar; D:/CFusionMX7/runtime/../lib/crystal.jar; D:/CFusionMX7/runtime/../lib/flashgateway.jar; D:/CFusionMX7/runtime/../lib/httpclient.jar; D:/CFusionMX7/runtime/../lib/ib6addonpatch.jar; D:/CFusionMX7/runtime/../lib/ib6core.jar; D:/CFusionMX7/runtime/../lib/ib6swing.jar; D:/CFusionMX7/runtime/../lib/ib6util.jar; D:/CFusionMX7/runtime/../lib/im.jar; D:/CFusionMX7/runtime/../lib/iText.jar; D:/CFusionMX7/runtime/../lib/iTextAsian.jar; D:/CFusionMX7/runtime/../lib/izmado.jar; D:/CFusionMX7/runtime/../lib/jakarta-oro-2.0.6.jar; D:/CFusionMX7/runtime/../lib/java2wsdl.jar; D:/CFusionMX7/runtime/../lib/jaxrpc.jar; D:/CFusionMX7/runtime/../lib/jdom.jar; D:/CFusionMX7/runtime/../lib/jeb.jar; D:/CFusionMX7/runtime/../lib/jintegra.jar; D:/CFusionMX7/runtime/../lib/ldap.jar; D:/CFusionMX7/runtime/../lib/ldapbp.jar; D:/CFusionMX7/runtime/../lib/log4j.jar; D:/CFusionMX7/runtime/../lib/macromedia_drivers.jar; D:/CFusionMX7/runtime/../lib/mail.jar; D:/CFusionMX7/runtime/../lib/msapps.jar; D:/CFusionMX7/runtime/../lib/pbclient42RE.jar; D:/CFusionMX7/runtime/../lib/pbembedded42RE.jar; D:/CFusionMX7/runtime/../lib/pbserver42RE.jar; D:/CFusionMX7/runtime/../lib/pbtools42RE.jar; D:/CFusionMX7/runtime/../lib/poi-2.5.1-final-20040804.jar; D:/CFusionMX7/runtime/../lib/poi-contrib-2.5.1-final-20040804.jar; D:/CFusionMX7/runtime/../lib/ri_generic.jar; D:/CFusionMX7/runtime/../lib/saaj.jar; D:/CFusionMX7/runtime/../lib/smack.jar; D:/CFusionMX7/runtime/../lib/smpp.jar; D:/CFusionMX7/runtime/../lib/STComm.jar; D:/CFusionMX7/runtime/../lib/tools.jar; D:/CFusionMX7/runtime/../lib/tt-bytecode.jar; D:/CFusionMX7/runtime/../lib/vadmin.jar; D:/CFusionMX7/runtime/../lib/verity.jar; D:/CFusionMX7/runtime/../lib/vparametric.jar; D:/CFusionMX7/runtime/../lib/vsearch.jar; D:/CFusionMX7/runtime/../lib/wc50.jar; D:/CFusionMX7/runtime/../lib/webchartsJava2D.jar; D:/CFusionMX7/runtime/../lib/wsdl2java.jar; D:/CFusionMX7/runtime/../lib/wsdl4j.jar; D:/CFusionMX7/runtime/../lib/xalan.jar; D:/CFusionMX7/runtime/../lib/xercesImpl.jar; D:/CFusionMX7/runtime/../lib/xml-apis.jar; D:/CFusionMX7/runtime/../lib/; D:/CFusionMX7/runtime/../gateway/lib/examples.jar; D:/CFusionMX7/runtime/../gateway/lib/; D:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-awt-util.jar; D:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-css.jar; D:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-ext.jar; D:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-transcoder.jar; D:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-util.jar;
avoid duplicate columns in query..
Hi This is my code.. cfloop index=listitem list=#form.fieldnames# cfif (lcase(left(listitem,4)) is sql_) or (lcase(left(listitem,7)) is hidden_) cfif fields neq cfset fields = #fields#, /cfif !--- replace single quotes with double quotes for SQL --- cfset temp = replace(evaluate('form.#listitem#'), ', '', ALL) !--- loose _xxx for cold fusion date handling 'oddities' --- cfset field_name = listitem cfif lcase(right(field_name,4)) is _xxx cfset field_name = left(field_name, (len(field_name)-4)) /cfif cfset field_value = temp !-- if the value to be updated is the ignore_me value, set the value to NULL -- cfif temp eq #defaults.ignore_me# cfset temp = NULL cfelse !--- wrap it is quotes --- cfset temp = #q##temp##q# /cfif cfif ListFindNoCase(#form.date_fields#, listitem) neq 0 cfset temp = to_date(#temp#, #q##defaults.oracle_date_format##q#) cfif #listitem# EQ lcase(SQL_VISIT_DATE_XXX) cfset vdate = #temp# /cfif cfelseif ListFindNoCase(#form.datetime_fields#, listitem) neq 0 cfset temp = to_date(#temp#, #q##defaults.oracle_datetime_format##q#) /cfif !--- build the id=1, name=bob part of the update SQL --- cfif lcase(left(listitem,4)) is sql_ !--- trim the field_name for pk_field_value or pk2_field_value --- cfset field_name = right(field_name, (len(field_name)-4)) cfset temp = #field_name# = #temp# cfelseif (lcase(left(listitem,7)) is hidden_) !--- trim the field_name for pk_field_value or pk2_field_value --- cfset field_name = right(field_name, (len(field_name)-7)) cfset temp = #field_name# = #temp# /cfif !--- save the values for the keys for this record--- cfif lcase(field_name) eq lcase(pk2_field_name) cfset pk2_field_value = field_value /cfif cfset fields = #fields##temp# !---for debug--- cfset list1 = list1 #field_name#, /cfif /cfloop list1 = PATIENT_INITIALS, GENDER, RACE_ID, BIRTH_DATE, OTHER_ID1, OTHER_ID2, STATE_ID, COUNTRY_ID, ZIP_POSTAL_CODE, PREFIX_ID, FIRST_NAME, MIDDLE_INITIAL, LAST_NAME, SUFFIX, PATIENT_INITIALS, GENDER, ADDRESS_ID, RACE_ID, BIRTH_DATE, REFERRED_BY_TYPE, CONTACT_FOR_ANOTHER_STUDY_IND, REFERRED_BY, AVAILABLE, REFERRAL_TYPE_ID, AVAILABLE_DAYS, WORK_PHONE, WORK_PHONE_EXTENSION, FAX_NUMBER, HOME_PHONE, EMAIL1, EMAIL2, OTHER_ID1, OTHER_ID2, RESPONSIBLE_PARTY_ID, NOTES, in this list1 also we can see those duplicate columns.. so we need to avoid before building the update query.. When i execute this queryfollowing database error is showing saying that duplication column name found.. Error Executing Database Query. update patient set update patient set PATIENT_INITIALS = 'AAA', GENDER = '1', RACE_ID = '4', BIRTH_DATE = to_date('10-Oct-2003', 'dd-Mon-'), OTHER_ID1 = '', OTHER_ID2 = '', STATE_ID = '2', COUNTRY_ID = NULL, ZIP_POSTAL_CODE = '', PREFIX_ID = '5', FIRST_NAME = 'Ann', MIDDLE_INITIAL = '', LAST_NAME = 'Albert', SUFFIX = '', PATIENT_INITIALS = 'AAA', GENDER = '1', ADDRESS_ID = '100046', RACE_ID = '4', BIRTH_DATE = '10-Oct-2003', REFERRED_BY_TYPE = '1', CONTACT_FOR_ANOTHER_STUDY_IND = 'N', REFERRED_BY = '', AVAILABLE = '0', REFERRAL_TYPE_ID = '', AVAILABLE_DAYS = '0', WORK_PHONE = '', WORK_PHONE_EXTENSION = '', FAX_NUMBER = '', HOME_PHONE = '', EMAIL1 = '', EMAIL2 = '', OTHER_ID1 = '', OTHER_ID2 = '', RESPONSIBLE_PARTY_ID = '', NOTES = '', date_modified = SYSDATE, modified_by = USER where patient_id = 11 here we can see PATIENT_INITIALS and some other columns are being displayed twice. so how to avoid duplicate columns in this loop.. appreciate for yr ideas... Thanks ramesh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
No more data available to read..
Hi Guys, Here I am getting following error unexpectedly. Error Executing Database Query. [Macromedia][Oracle JDBC Driver]No more data available to read. Pls let me know if you have any great suggestion to resolve this error. We are using 6.1 MX version. Thanks Ramesh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFTRANSACTION problem
Hi, Suddenly I am getting following error in cfm page. Data source Ora8 verification failed. The root cause was that: java.sql.SQLException: Usernames and Passwords for all the database tags within CFTRANSACTION must be the same. Really that will be greatly appreciate for any suggestions. Thanks ramesh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Not able to start the ColdFusion MX Application Server from servi ces.
Hi, I am not able to start the coldfusion application service. Giving following error.. The ColdFusion MX Application Server service terminated with service-specific error 2. Could not start ColdFusion MX Application Server on local computer.. Any ideas ? Thanks ramesh ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137886 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
small article...
Hi Guys, Hi I want to share with you guys about this article. :) LOVE YOUR JOB, BUT NEVER FALL IN LOVE WITH YOUR COMPANY BECAUSE U NEVER KNOW WHEN COMPANY STOPS LOVING YOU - Narayana Murthy Extract of Mr. Narayana Murthy's Speech during Mentor Session : I know people who work 12 hours a day, six days a week, or more. Some people do so because of a work emergency where the long hours are only temporary. Other people I know have put these hours for years. I don't know if they are working all these hours, but I do know they are in the office this long. Others put in long office hours because they are addicted to the workplace. Whatever the reason for putting in overtime, working long hours over the long term is harmful to the person and to the organization. There are things managers can do to change this for everyone's benefit. Being in the office long hours, over long periods of time, makes way for potential errors. My colleagues who are in the office long hours frequently make mistakes caused by fatigue. Correcting these mistakes requires their time as well as the time and energy of others. I have seen people work Tuesday through Friday to correct mistakes made after 5 PM on Monday. Another problem is that people who are in the office long hours are not pleasant company. They often complain about other people (who aren't working as hard); they are irritable, or cranky, or even angry. Other people avoid them. Such behavior poses problems, where work goes much better when people work together instead of avoiding one another. As Managers, there are things we can do to help people leave the office. First and foremost is to set the example and go home ourselves. I work with a manager who chides people for working long hours. His words quickly lose their meaning when he sends these chiding groups e-mails with a time-stamp of 2 AM, Sunday. Second is to encourage people to put some balance in their lives. For instance, here is a guideline I find helpful: 1) Wake up, eat a good breakfast, and go to work. 2) Work hard and smart for eight or nine hours. 3) Go home. 4) Read the comics, watch a funny movie, dig in the dirt, play withyour kids, etc. 5) Eat well and sleep well. This is called recreating. Doing steps 1, 3, 4, and 5 enable step 2. Working regular hours and recreating daily are simple concepts. They are hard for some of us because that requires personal change. They are possible since we all have the power to choose to do them. In considering the issue of overtime, I am reminded of my oldest son. When he was a toddler, if people were visiting the apartment, he would not fall asleepno matter how long the visit, and no matter what time of day it was. He would fight off sleep until the visitors left. It was as if he was afraid that he would miss something. Once our visitors' left, he would go to sleep. By this time, however, he was over tired and would scream through half the night with nightmares. He, my wife, and I, all paid the price for his fear of missing out. Perhaps some people put in such long hours because they don't want to miss anything when they leave the office. The trouble with this is that events will never stop happening. That is life!! Things happen 24 hours a day. Allowing for little rest is not ultimately practical. So, take a nap. Things will happen while you're asleep, but you will have the energy to catch up when you wake. Hence LOVE YOUR JOB BUT NEVER FALL IN LOVE WITH YOUR COMPANY Have a great day ahead !! regards, Rajiva Srivastava HRD-DEL == Thanks Ram ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137337 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Regarding CFMX6.1 - Macromedia Installation support/Fixes require d
Hi I am facing two major problems with ColdFusionMX6.1 version. The first one is when the sql query returns no record. In this case, we get no data to read error message. The second one happens with java classes. In CFMX4.5, the java class by default reads the properties file from c:\winnt\system32 but in CFMX6.0/6.1 it is looking at C:\CFusionMX\runtime\bin. For more details about the bug, please visit the below link http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid= 690270 The first error is almost killing the entire application. This issue throws a warning message in CFMX6.0 and in CFMX6.1 it is an error message. The reason for writing to installation support is, I am not getting this error message when I upgrade CFMX6.0 to CFMX6.1. However when I install CFMX6.1 directly, the CFMX server throws an error message. The only way to avoid or work around this bug at this stage is to install CFMX6.0 and update the same with CFMX updater 3 patch and then upgrade it to CFMX6.1. Please consider this as an urgent issue to be resolved at the earliest. Any feedback in this regard will help our organization in our future planning and release of our product. Expecting a reply ASAP.. Thanks ramesh ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
displaying CGI variables.. ?
Hi, How to display all CGI variable info thru programmatically.. Thanks ramesh ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
cf4.5.1 and CFMX
Hi, Here I have installed two versions of coldfusion (CF4.5.1 and CFMX) But it 4.5.1 is working fine with http://localhost/login.cfm (going thru IIS here) using path : c:\inetpub\wwwroot\ and even CFMX (6.0) version is also working fine. http://localhost:8500/login.cfm using path : c:\CfusionMX\wwwroot\ so here I would like to avoid to use 8500 when I use cfmx version. Becos I want to go thru IIS only here. So is there any command we have where we can internally switch from cf4.5.1 to CFMX version when I want to use cfmx version url. (note : I want to run both versions in my machines since some times I need to work on cf4.5 and some times I need to work on CFMX version.) Appreciate your great ideas... thanks Ramesh ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Debugger for Oracle storeprocedures
Hi Dave, OraEdit Pro is really awesome.. I like it.. thanks for your great help.. :) Thanks ramesh -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 4:09 PM To: CF-Talk Subject: RE: Debugger for Oracle storeprocedures Have you tried PL/SQL Developer from AllAround Solutions. http://www.allroundautomations.nl/products.html OraEdit Pro is really good too, and much cheaper than TOAD ($99 for single user license). It has built-in integration with all the major version control packages too, which is convenient. http://www.dkgas.com/oraeditpro.htm Regards, Dave. _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Debugger for Oracle storeprocedures
Hi, Anybody knows good debugger for Oracle Stored Procedures? Thanks ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Debugging problem
When i do debug the code in my localhost (CF4.5.1), its giving me following error in pop up box. Is there any suggestions. An error occured on the RDS Server (Local Hostname:localhost): The ColFusion Remote Development Server failed to connect to debugger sessio. This may have occured for one of the following reasons: An invalid start url was used to start the session (404 error). Check the validity of the URL. RDS timed out waiting for a debugger connection to a busy CFAS Server. Check the timeout value and increase it if necessary. The ColdFusion Application Server is no tcurrently running. Verify that the server is running and restart it if necessary. Thanks ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFadmin page..
Hi, This is my CFMX admin url.. http://localhost:8500/CFIDE/administrator/index.cfm but I want to see another machine's cf admin where I am running cfmx too.. I was trying like this. http://xx.xx.xx.xx:8500/CFIDE/administrator/index.cfm but it showing page cann't be displayed.. thanks ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
net send
Sorry this is not CF related question.. pls forgive me.. Net send command is not working suddenly in cmd prompt on my machine. ? Thanx ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
encrypt to decrypt format
Hi, I downloaded one custom tag which is in encrypt format.. Can I do decrypt that file since I want to enhance that code. Any links available in web where I can do change the format? Thanks ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFContent tag in CFMX..
Hi, Here I am using following tag in CFMX. cfcontent type=application/x-msexcel file=#path# deletefile=Yes But it showing error message in popup window like Internet Explorer cannot download. Internet Explorer was not able to open this Internetsite. The requested site is either unavailable or cannot be found. Pleas e try again later. And In CF4.5.1 that same code is working fine and opening excel document also.. Am I doing anything wrong here in cfmx.. or do we need to change then syntax of cfcontent tag in cfmx version. Really appreciate for suggestions also.. Thanks ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfadmin password
Sorry.. I forgot my cfadmin (cf4.5.1) password.. is there anywhere I can see.. again..? Thanks ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFadmin page..
Hi Doug, But that opens cf4.5 admin page.. in remote machine we have both (cf4.5 and CFMX environments.) I want to open cfmx environment in remote machine.. Thanks -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 3:41 PM To: CF-Talk Subject: Re: CFadmin page.. I am able to reach CF Admin on a remote server using http://xx.xxx.xx.xx/CFIDE/administrator/index.cfm without using the port number. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == If you are not satisfied with my service, my job isn't done! - Original Message - From: Ramesh Deva [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 3:18 PM Subject: CFadmin page.. | Hi, | | This is my CFMX admin url.. | | http://localhost:8500/CFIDE/administrator/index.cfm | | but I want to see another machine's cf admin where I am running cfmx too.. | | I was trying like this. | | http://xx.xx.xx.xx:8500/CFIDE/administrator/index.cfm | | | but it showing page cann't be displayed.. | | | | | thanks | ramesh | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFContent tag in CFMX..
Hi, Here I am using following tag in CFMX. cfcontent type=application/x-msexcel file=#path# deletefile=Yes But it showing error message in popup window like Internet Explorer cannot download. Internet Explorer was not able to open this Internetsite. The requested site is either unavailable or cannot be found. Pleas e try again later. And In CF4.5.1 that same code is working fine and opening excel document also.. Am I doing anything wrong here in cfmx.. or do we need to change then syntax of cfcontent tag in cfmx version. Really appreciate for suggestions also.. Thanks -Original Message- From: Ramesh Deva [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 5:14 PM To: CF-Talk Subject: CFContent tag in CFMX.. Hi, Here I am using following tag in CFMX. cfcontent type=application/x-msexcel file=#path# deletefile=Yes But it showing error message in popup window like Internet Explorer cannot download. Internet Explorer was not able to open this Internetsite. The requested site is either unavailable or cannot be found. Pleas e try again later. And In CF4.5.1 that same code is working fine and opening excel document also.. Am I doing anything wrong here in cfmx.. or do we need to change then syntax of cfcontent tag in cfmx version. Really appreciate for suggestions also.. Thanks ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFStoredproc problem in CFMX..
Hi, I thought to give an email separately.. Here I am giving the testcode which I executed in cfmx version and CF4.5.1 version. But I am expecting value '4' from following code. I will be getting that value in only CF4.5.1 but not in CFMX. Is it unknown cfmx bug or do we need to change any attributes kind of things when we use cfstoreproc in cfmx. Really appreciated for your suggestions also.. = cfstoredproc procedure=pkg_security.sp_check_security datasource=#defaults.dsn# username=#client.user_name# password=#client.password# !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=user_id_in value=100023 !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=object_id_in value=1 null=yes !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=function_name_in value=patient !--- Replaced the deprecated attribute 'cfvarname' by 'variable' attribute --- cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable =access_key_out dbvarname=access_key_out /cfstoredproc cfset test = #access_key_out# cfoutput#test#/cfoutput test value is 4 in cf4.5.1 and test value is 0 in cfmx .. why it is so like that.. ? Thanks in advance.. Best regards Sachin. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFStoredproc is giving incorrect value in CFMX version. but getti ng correct value in cf4.5 version.. --- URGENT
Hi Here I am giving the testcode which I executed in cfmx version and CF4.5.1 version. But I am expecting value '4' from following code. I will be getting that value in only CF4.5.1 but not in CFMX. Is it unknown cfmx bug or do we need to change any attributes kind of things when we use cfstoreproc in cfmx. Really I would appreciate even if you give your suggestions.. = cfstoredproc procedure=pkg_security.sp_check_security datasource=#defaults.dsn# username=#client.user_name# password=#client.password# !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=user_id_in value=100023 !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=object_id_in value=1 null=yes !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=function_name_in value=patient !--- Replaced the deprecated attribute 'cfvarname' by 'variable' attribute --- cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable =access_key_out dbvarname=access_key_out /cfstoredproc cfset test = #access_key_out# cfoutput#test#/cfoutput test value is 4 in cf4.5.1 and test value is 0 in cfmx .. why it is so like that.. ? Thanks in advance.. Best regards Sachin. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFStoredproc problem..
Hi, Here I am giving the testcode which I executed in cfmx version and CF4.5.1 version. But I am expecting value '4' from following code. I will be getting that value in only CF4.5.1 but not in CFMX. Is it unknown cfmx bug or do we need to change any attributes kind of things when we use cfstoreproc in cfmx. Really appreciated for your suggestions also.. = cfstoredproc procedure=pkg_security.sp_check_security datasource=#defaults.dsn# username=#client.user_name# password=#client.password# !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=user_id_in value=100023 !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=object_id_in value=1 null=yes !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=function_name_in value=patient !--- Replaced the deprecated attribute 'cfvarname' by 'variable' attribute --- cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable =access_key_out dbvarname=access_key_out /cfstoredproc cfset test = #access_key_out# cfoutput#test#/cfoutput test value is 4 in cf4.5.1 and test value is 0 in cfmx .. why it is so like that.. ? Thanks in advance.. Best regards Sachin. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFStoredproc problem in CFMX..
Hi, I thought to give an email separately.. Here I am giving the testcode which I executed in cfmx version and CF4.5.1 version. But I am expecting value '4' from following code. I will be getting that value in only CF4.5.1 but not in CFMX. Is it unknown cfmx bug or do we need to change any attributes kind of things when we use cfstoreproc in cfmx. Really appreciated for your suggestions also.. = cfstoredproc procedure=pkg_security.sp_check_security datasource=#defaults.dsn# username=#client.user_name# password=#client.password# !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=user_id_in value=100023 !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=object_id_in value=1 null=yes !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=function_name_in value=patient !--- Replaced the deprecated attribute 'cfvarname' by 'variable' attribute --- cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable =access_key_out dbvarname=access_key_out /cfstoredproc cfset test = #access_key_out# cfoutput#test#/cfoutput test value is 4 in cf4.5.1 and test value is 0 in cfmx .. why it is so like that.. ? Thanks in advance.. Best regards Sachin. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFStoredproc is giving incorrect value in CFMX version. but getti ng correct value in cf4.5 version.. --- URGENT
Hi Here I am giving the testcode which I executed in cfmx version and CF4.5.1 version. But I am expecting value '4' from following code. I will be getting that value in only CF4.5.1 but not in CFMX. Is it unknown cfmx bug or do we need to change any attributes kind of things when we use cfstoreproc in cfmx. Really I would appreciate even if you give your suggestions.. = cfstoredproc procedure=pkg_security.sp_check_security datasource=#defaults.dsn# username=#client.user_name# password=#client.password# !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=user_id_in value=100023 !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=object_id_in value=1 null=yes !--- TRACK #160 - Security Update --- cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=function_name_in value=patient !--- Replaced the deprecated attribute 'cfvarname' by 'variable' attribute --- cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable =access_key_out dbvarname=access_key_out /cfstoredproc cfset test = #access_key_out# cfoutput#test#/cfoutput test value is 4 in cf4.5.1 and test value is 0 in cfmx .. why it is so like that.. ? Thanks in advance.. Best regards Sachin. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
coldfusion-asp
Hi Could we call from asp to coldfusion page. our one server (Java) they are posting one "xmlpacket" variable info to our cfm page. but it is not displaying whole information when we displaying in cfm page. so before that one i thougt to call convert.asp page before sending xmlpacket variable info to cfm page. Here i am giving asp code. This code i need to execute before cfm. So that one can i call cfm page and pass the xmlpacket variable info(converted). % Response.ContentType = "text/xml" set ModuleManager = Application.Value("ModuleManager") set SOAPServiceManager = Application.Value("SOAPServiceManager") set proxy = GetObject("java:com.pcorder.services.order.soap.http.PresentationSOAPProxy") proxy.setModuleManager(ModuleManager) proxy.setSOAPServiceManager(SOAPServiceManager) methodStr = "" byteCount = Request.TotalBytes xmlMethodRequest = Request.BinaryRead(byteCount) for i = 1 to byteCount methodStr = methodStr Chr(CStr(AscB(MidB(xmlMethodRequest,i,1 next xmlMethodResponse = proxy.doCallFromASP(methodStr) Response.Write(xmlMethodResponse) % Other wise can i use any command in coldfusion what asp exactly does above. Thanks regards Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
how to read xml data
Hi i am facing with big problem. Actually One server(java) is posting data to our coldfusion server by calling our coldufusion page (test.cfm). they are posting variable info as a xmlpacket = "---xmldata---" but when we are receiving from coldfusion we are displaying "form.xmlpacket" information, then it showing half of the xml only when that xmldata contains "". Can i read full xml data (even if they give "" data) by using any method or custom tag. and i would appreceiate if your valuable suggestions also. Pls if any one does not understand pls let me know. Thanks in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
how to delete mailserver log file(if exceeds the limitation size)
Hi, can any body faced the problem like mail log is exceeding and giving interpretation error(unknown exception condition error) our mail log size is some 300MB is there. I am trying to delete the whole information. but it is deleting and again populating information(may be database or some where, exactly i am not sure) Once maillog exceeds some limmitation size then it is giving above error when i open maillog thru coldfusion administration. I would appreciate your valuable suggestions also. thanks in advance ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
how can we execute command lines from coldfusion
Hi, how can we execute command lines from coldfusion. Thanks regards ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
urgent (How can we bypass web server when data contains amp;)
Hi Here i am in loop.. Actually here we are receiving one variable information(form.xmlpacket) from "posting system" but when they have "" data (Like address field = "abrothers") they are converting into "amp;" for further processing to xmlparsers (in our system) This data they are posting properly to our cold fusion server(and we have one webserver (IIS) is also there in between their server and our coldfusion application server. When they are sending data to us(contains "amp;"), i could n't able to see whole data in that variable("form.xmlpacket"). After "amp;" data is not displaying. I hope (may be) web server is stopping to send after "amp;" data Any how is there any way to read the whole data with "amp;" . I believe you understand well. And i have one doubt if we post from first system to second system, Then will it be comes thru first system web server or directly it comes thru to second web server to second system. Awaiting your response or valuable suggestion Thanks Regards Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
urgent (How can we bypass web server when data contains amp;)
Hi Here i am in loop.. Actually here we are receiving one variable information(form.xmlpacket) from "posting system" but when they have "" data (Like address field = "abrothers") they are converting into "amp;" for further processing to xmlparsers (in our system) This data they are posting properly to our cold fusion server(and we have one webserver (IIS) is also there in between their server and our coldfusion application server. When they are sending data to us(contains "amp;"), i could n't able to see whole data in that variable("form.xmlpacket"). After "amp;" data is not displaying. I hope (may be) web server is stopping to send after "amp;" data Any how is there any way to read the whole data with "amp;" . I believe you understand well. And i have one doubt if we post from first system to second system, Then will it be comes thru first system web server or directly it comes thru to second web server to second system. Awaiting your response or valuable suggestion Thanks Regards Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
urgent (How can we bypass web server when data contains amp;)
Hi Here i am in loop.. Actually here we are receiving one variable information(form.xmlpacket) from "posting system" but when they have "" data (Like address field = "abrothers") they are converting into "amp;" for further processing to xmlparsers (in our system) This data they are posting properly to our cold fusion server(and we have one webserver (IIS) is also there in between their server and our coldfusion application server. When they are sending data to us(contains "amp;"), i could n't able to see whole data in that variable("form.xmlpacket"). After "amp;" data is not displaying. I hope (may be) web server is stopping to send after "amp;" data Any how is there any way to read the whole data with "amp;" . I believe you understand well. And i have one doubt if we post from first system to second system, Then will it be comes thru first system web server or directly it comes thru to second web server to second system. Awaiting your response or valuable suggestion Thanks Regards Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: urgent (How can we bypass web server when data contains amp;)
Hi Any one has faced this type of problem... here again i am in loop.. Actually here we are receiving one variable information(form.xmlpacket) from "posting system" but when they have "" data (Like address field = "abrothers") they are converting into "amp;" for further processing to xmlparsers (in our system) This data they are posting properly to our cold fusion server(and we have one webserver (IIS) is also there in between their server and our coldfusion application server. When they are sending data to us(contains "amp;"), i could n't able to see whole data in that variable("form.xmlpacket"). After "amp;" data is not displaying. I hope (may be) web server is stopping to send after "amp;" data Any how is there any way to read the whole data with "amp;" . I believe you understand well. i would appreciate your suggestion also Thanks Regards Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: urgent (How can we bypass web server when data contains amp;)
Hi Any one has faced this type of problem... here again i am in loop.. Actually here we are receiving one variable information(form.xmlpacket) from "posting system" but when they have "" data (Like address field = "abrothers") they are converting into "amp;" for further processing to xmlparsers (in our system) This data they are posting properly to our cold fusion server(and we have one webserver (IIS) is also there in between their server and our coldfusion application server. When they are sending data to us(contains "amp;"), i could n't able to see whole data in that variable("form.xmlpacket"). After "amp;" data is not displaying. I hope (may be) web server is stopping to send after "amp;" data Any how is there any way to read the whole data with "amp;" . I believe you understand well. i would appreciate your suggestion also Thanks Regards Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: urgent (How can we bypass web server when data contains amp;)
Hi Any one has faced this type of problem... here again i am in loop.. Actually here we are receiving one variable information(form.xmlpacket) from "posting system" but when they have "" data (Like address field = "abrothers") they are converting into "amp;" for further processing to xmlparsers (in our system) This data they are posting properly to our cold fusion server(and we have one webserver (IIS) is also there in between their server and our coldfusion application server. When they are sending data to us(contains "amp;"), i could n't able to see whole data in that variable("form.xmlpacket"). After "amp;" data is not displaying. I hope (may be) web server is stopping to send after "amp;" data Any how is there any way to read the whole data with "amp;" . I believe you understand well. i would appreciate your suggestion also Thanks Regards Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
transfer excel data to sql server db thru programmatically (urgent!)
Hi all, I have one cfm page which allows to me to select one excel file and after that when i submit the page then wat ever i selected data from xls file data has to be insert into specified table.. And we are using window NT and CF4.5.1. and MS sql server 7.0. Is there any custom tag avaialble in allaire.. or any indirect way we have to approach??? I would appreciate if u give yr valuable suggestions. Actually this one already posted in to cf-talk.. but my problem was not solved.. Pls let me know any one faced this problem earlier.. Thanks in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
transfer excel data to sql server db thru programmatically (urgent!)
Hi all, I have one cfm page which allows to me to select one excel file and after that when i submit the page then wat ever i selected data from xls file data has to be insert into specified table.. And we are using window NT and CF4.5.1. and MS sql server 7.0. Is there any custom tag avaialble in allaire.. or any indirect way we have to approach??? I would appreciate if u give yr valuable suggestions. Actually this one already posted in to cf-talk.. but my problem was not solved.. Pls let me know any one faced this problem earlier.. Thanks in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
transfer excel data to sql server db thru programmatically (urgent!)
Hi all, I have one cfm page which allows to me to select one excel file and after that when i submit the page then wat ever i selected data from xls file data has to be insert into specified table.. And we are using window NT and CF4.5.1. and MS sql server 7.0. Is there any custom tag avaialble in allaire.. or any indirect way we have to approach??? I would appreciate if u give yr valuable suggestions. Actually this one already posted in to cf-talk.. but my problem was not solved.. Pls let me know any one faced this problem earlier.. Thanks in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
transfer excel data to sql server db thru programmatically (urgent!)
Hi all, I have one cfm page which allows to me to select one excel file and after that when i submit the page then wat ever i selected data from xls file data has to be insert into specified table.. And we are using window NT and CF4.5.1. and MS sql server 7.0. Is there any custom tag avaialble in allaire.. or any indirect way we have to approach??? I would appreciate if u give yr valuable suggestions. Actually this one already posted in to cf-talk.. but my problem was not solved.. Pls let me know any one faced this problem earlier.. Thanks in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can i send data to CFWDDX(action = wddxtocfml)for processing
Thanx for your kind response.. Yes, i used like that also.. but no result.. Here i am giving indetail..Pls go thru once.. I hope can understand easily.. And read comment lines also From following line onwards Just paste in to yr coldfusion.. so u can read it easily.. Here i explained the problem by giving the comments.. Pls any one faced this type of problem. how we can solve it.. Can we send the "" data in to CFWDDX (action = wddxtocfml).. !--- This is my xmlpacket contains data,here i am replacing with ~ data.. --- cfset form.xmlpacket = Replace(form.xmlpacket,"","~","ALL") cffile action="WRITE" file="#Received_EZB_PO_XML_Filename#" output="#form.xmlpacket#" addnewline="No" !--- Start (Use XMLDOM.load to check if EZB PO XML conforms to DTD or not) --- cffile action="READ" file="#Received_EZB_PO_XML_Filename#" variable="EZB_OrderXML" cffile action="WRITE" file="#EZB_OrderXML_TempFile#" output="#EZB_OrderXML#" addnewline="No" !--- Cretaing object of xml dom --- cfobject type="COM" name="xmlDoc" class="Microsoft.XMLDOM" action="CREATE" cfset xmlDoc.load("#EZB_OrderXML_TempFile#") !--- Parsing the data of Received_EZB_PO_XML_Filename --- CFX_J CLASS = "CFXJ_Parse" XML = "#Received_EZB_PO_XML_Filename#" XSL = "#WDDX_PO_XML_XSL_Filename#" cffile action="WRITE" file="#Path#\wddx\wddx#timeformat(now(),'Hmmss')#.txt" output="#wddx_packet#" cfset wddx_packet = Replace(wddx_packet,"~","","ALL") !--- My question is can i do like this becos when i debug this programme i am getting error here.. --- CFWDDX ACTION="WDDX2JS" INPUT="#wddx_packet#" OUTPUT="WDDXPacket" TOPLEVELVARIABLE="Whatever" !--- *** --- !--- cfset var1 = Replace(var1,"~","","ALL") --- !--- cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" --- cfwddx action="WDDX2CFML" input="#var1#" output="EZB_PO_WDDX" cfoutput09 "#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#"/cfoutput !--- Appended by ramesh deva on 18/1/01 --- 10 #EZB_PO_WDDX.Header.BillToPerson.Address[1].City# 11 cfset aacity = Replace(#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#,"~","","ALL") 12 cfoutput #aacity# /cfoutput !--- Actually i want to remove that ~ mark and replace wi
Can i send data to CFWDDX(action = wddxtocfml)for processing
Thanx for your kind response.. Yes, i used like that also.. but no result.. Here i am giving indetail..Pls go thru once.. I hope can understand easily.. And read comment lines also From following line onwards Just paste in to yr coldfusion.. so u can read it easily.. Here i explained the problem by giving the comments.. Pls any one faced this type of problem. how we can solve it.. Can we send the "" data in to CFWDDX (action = wddxtocfml).. !--- This is my xmlpacket contains data,here i am replacing with ~ data.. --- cfset form.xmlpacket = Replace(form.xmlpacket,"","~","ALL") cffile action="WRITE" file="#Received_EZB_PO_XML_Filename#" output="#form.xmlpacket#" addnewline="No" !--- Start (Use XMLDOM.load to check if EZB PO XML conforms to DTD or not) --- cffile action="READ" file="#Received_EZB_PO_XML_Filename#" variable="EZB_OrderXML" cffile action="WRITE" file="#EZB_OrderXML_TempFile#" output="#EZB_OrderXML#" addnewline="No" !--- Cretaing object of xml dom --- cfobject type="COM" name="xmlDoc" class="Microsoft.XMLDOM" action="CREATE" cfset xmlDoc.load("#EZB_OrderXML_TempFile#") !--- Parsing the data of Received_EZB_PO_XML_Filename --- CFX_J CLASS = "CFXJ_Parse" XML = "#Received_EZB_PO_XML_Filename#" XSL = "#WDDX_PO_XML_XSL_Filename#" cffile action="WRITE" file="#Path#\wddx\wddx#timeformat(now(),'Hmmss')#.txt" output="#wddx_packet#" cfset wddx_packet = Replace(wddx_packet,"~","","ALL") !--- My question is can i do like this becos when i debug this programme i am getting error here.. --- CFWDDX ACTION="WDDX2JS" INPUT="#wddx_packet#" OUTPUT="WDDXPacket" TOPLEVELVARIABLE="Whatever" !--- *** --- !--- cfset var1 = Replace(var1,"~","","ALL") --- !--- cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" --- cfwddx action="WDDX2CFML" input="#var1#" output="EZB_PO_WDDX" cfoutput09 "#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#"/cfoutput !--- Appended by ramesh deva on 18/1/01 --- 10 #EZB_PO_WDDX.Header.BillToPerson.Address[1].City# 11 cfset aacity = Replace(#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#,"~","","ALL") 12 cfoutput #aacity# /cfoutput !--- Actually i want to remove that ~ mark and replace wi
Can i send data to CFWDDX(action = wddxtocfml)for processing
Thanx for your kind response.. Yes, i used like that also.. but no result.. Here i am giving indetail..Pls go thru once.. I hope can understand easily.. And read comment lines also From following line onwards Just paste in to yr coldfusion.. so u can read it easily.. Here i explained the problem by giving the comments.. Pls any one faced this type of problem. how we can solve it.. Can we send the "" data in to CFWDDX (action = wddxtocfml).. !--- This is my xmlpacket contains data,here i am replacing with ~ data.. --- cfset form.xmlpacket = Replace(form.xmlpacket,"","~","ALL") cffile action="WRITE" file="#Received_EZB_PO_XML_Filename#" output="#form.xmlpacket#" addnewline="No" !--- Start (Use XMLDOM.load to check if EZB PO XML conforms to DTD or not) --- cffile action="READ" file="#Received_EZB_PO_XML_Filename#" variable="EZB_OrderXML" cffile action="WRITE" file="#EZB_OrderXML_TempFile#" output="#EZB_OrderXML#" addnewline="No" !--- Cretaing object of xml dom --- cfobject type="COM" name="xmlDoc" class="Microsoft.XMLDOM" action="CREATE" cfset xmlDoc.load("#EZB_OrderXML_TempFile#") !--- Parsing the data of Received_EZB_PO_XML_Filename --- CFX_J CLASS = "CFXJ_Parse" XML = "#Received_EZB_PO_XML_Filename#" XSL = "#WDDX_PO_XML_XSL_Filename#" cffile action="WRITE" file="#Path#\wddx\wddx#timeformat(now(),'Hmmss')#.txt" output="#wddx_packet#" cfset wddx_packet = Replace(wddx_packet,"~","","ALL") !--- My question is can i do like this becos when i debug this programme i am getting error here.. --- CFWDDX ACTION="WDDX2JS" INPUT="#wddx_packet#" OUTPUT="WDDXPacket" TOPLEVELVARIABLE="Whatever" !--- *** --- !--- cfset var1 = Replace(var1,"~","","ALL") --- !--- cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" --- cfwddx action="WDDX2CFML" input="#var1#" output="EZB_PO_WDDX" cfoutput09 "#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#"/cfoutput !--- Appended by ramesh deva on 18/1/01 --- 10 #EZB_PO_WDDX.Header.BillToPerson.Address[1].City# 11 cfset aacity = Replace(#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#,"~","","ALL") 12 cfoutput #aacity# /cfoutput !--- Actually i want to remove that ~ mark and replace wi
Can i send data to CFWDDX(action = wddxtocfml)for processing
Thanx for your kind response.. Yes, i used like that also.. but no result.. Here i am giving indetail..Pls go thru once.. I hope can understand easily.. And read comment lines also From following line onwards Just paste in to yr coldfusion.. so u can read it easily.. Here i explained the problem by giving the comments.. Pls any one faced this type of problem. how we can solve it.. Can we send the "" data in to CFWDDX (action = wddxtocfml).. !--- This is my xmlpacket contains data,here i am replacing with ~ data.. --- cfset form.xmlpacket = Replace(form.xmlpacket,"","~","ALL") cffile action="WRITE" file="#Received_EZB_PO_XML_Filename#" output="#form.xmlpacket#" addnewline="No" !--- Start (Use XMLDOM.load to check if EZB PO XML conforms to DTD or not) --- cffile action="READ" file="#Received_EZB_PO_XML_Filename#" variable="EZB_OrderXML" cffile action="WRITE" file="#EZB_OrderXML_TempFile#" output="#EZB_OrderXML#" addnewline="No" !--- Cretaing object of xml dom --- cfobject type="COM" name="xmlDoc" class="Microsoft.XMLDOM" action="CREATE" cfset xmlDoc.load("#EZB_OrderXML_TempFile#") !--- Parsing the data of Received_EZB_PO_XML_Filename --- CFX_J CLASS = "CFXJ_Parse" XML = "#Received_EZB_PO_XML_Filename#" XSL = "#WDDX_PO_XML_XSL_Filename#" cffile action="WRITE" file="#Path#\wddx\wddx#timeformat(now(),'Hmmss')#.txt" output="#wddx_packet#" cfset wddx_packet = Replace(wddx_packet,"~","","ALL") !--- My question is can i do like this becos when i debug this programme i am getting error here.. --- CFWDDX ACTION="WDDX2JS" INPUT="#wddx_packet#" OUTPUT="WDDXPacket" TOPLEVELVARIABLE="Whatever" !--- *** --- !--- cfset var1 = Replace(var1,"~","","ALL") --- !--- cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" --- cfwddx action="WDDX2CFML" input="#var1#" output="EZB_PO_WDDX" cfoutput09 "#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#"/cfoutput !--- Appended by ramesh deva on 18/1/01 --- 10 #EZB_PO_WDDX.Header.BillToPerson.Address[1].City# 11 cfset aacity = Replace(#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#,"~","","ALL") 12 cfoutput #aacity# /cfoutput !--- Actually i want to remove that ~ mark and replace wi
replace function problem
Hi, Thanx for yr response.. Actually i used it.. but no result.. Pls from the following line onwards copy into cfm page then u can read easily.. Here i explained the problem by giving the comments.. Pls any one faced this type of problem. how we can solve it.. Can we send the "" data in to CFWDDX (action = wddxtocfml).. !--- This is my xmlpacket contains data,here i am replacing with ~ data.. --- cfset form.xmlpacket = Replace(form.xmlpacket,"","~","ALL") cffile action="WRITE" file="#Received_EZB_PO_XML_Filename#" output="#form.xmlpacket#" addnewline="No" !--- Start (Use XMLDOM.load to check if EZB PO XML conforms to DTD or not) --- cffile action="READ" file="#Received_EZB_PO_XML_Filename#" variable="EZB_OrderXML" cffile action="WRITE" file="#EZB_OrderXML_TempFile#" output="#EZB_OrderXML#" addnewline="No" !--- Cretaing object of xml dom --- cfobject type="COM" name="xmlDoc" class="Microsoft.XMLDOM" action="CREATE" cfset xmlDoc.load("#EZB_OrderXML_TempFile#") !--- Parsing the data of Received_EZB_PO_XML_Filename --- CFX_J CLASS = "CFXJ_Parse" XML = "#Received_EZB_PO_XML_Filename#" XSL = "#WDDX_PO_XML_XSL_Filename#" cffile action="WRITE" file="#Path#\wddx\wddx#timeformat(now(),'Hmmss')#.txt" output="#wddx_packet#" cfset wddx_packet = Replace(wddx_packet,"~","","ALL") !--- My question is can i do like this becos when i debug this programme i am getting error here.. --- CFWDDX ACTION="WDDX2JS" INPUT="#wddx_packet#" OUTPUT="WDDXPacket" TOPLEVELVARIABLE="Whatever" !--- *** --- !--- cfset var1 = Replace(var1,"~","","ALL") --- !--- cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" --- cfwddx action="WDDX2CFML" input="#var1#" output="EZB_PO_WDDX" cfoutput09 "#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#"/cfoutput !--- Appended by ramesh deva on 18/1/01 --- 10 #EZB_PO_WDDX.Header.BillToPerson.Address[1].City# 11 cfset aacity = Replace(#EZB_PO_WDDX.Header.BillToPerson.Address[1].City#,"~","","ALL") 12 cfoutput #aacity# /cfoutput !--- Actually i want to remove that ~ mark and replace with again.. can we do on " EZB_PO_WDDX " If yes then how can we solve..
Replace function
Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Replace function
Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Replace function
Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Replace function(very urgent)
Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how to retrieve excel data and to put into DB
Hi Here my problem.. I have excel sheet with data.. I need to provide cfm page to them to upload the excel sheet(This one i know) and when they submit the query after uploading the file, then it send to our sqlserver 7.0 database.. Is there any custom tag available to process this one.. Please do you have any idea about it how to do it. Thanks in advance Ramesh --- Dylan Bromby [EMAIL PROTECTED] wrote: it's undocumented. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 1:38 AM To: CF-Talk Subject: RE: how to retrieve excel data and to put into DB 3) I use CFUSION_DISABLE_CONNECTIONS([DSN],1) to force CF to release the lock on the Excel file Where is this documented? I've searched everything I've got and the Allaire website and found nothing... If it's an "undocumented feature", then I'll have to play with it for this exact reason - I currently use Access with a Link Table... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
how to retrieve excel data and to put into DB
Hi all, How can you retrieve the excel sheet data and to put in to database.. Is there any tag avaialble,, Thanx in advace Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
white spaces in xml packet view source
Hi Actually our programme takes xml packet from other system and process then if any error then generate the errorxml packet or if not then it generates successxml packet. So when i got successxml packet. That i pasted here which i am seeing in my browser.. But problem is when i see view source then it showing 3 empty rows in note pad.. I mean 4 th row onwards showing (in 4 th row also 2nd column onwards) the source.. But i need to remove those white spaces.. Is there any thing i have to change the programme or ...? has anybody faced this problem ? ?xml version="1.0" encoding="UTF-8" ? - OrderAcknowledgement type="SUCCESS" version="1.1.0" sourceIdentifier96-023-6446/sourceIdentifier requestedDateTime20001221 015728 -0800/requestedDateTime acknowledgedDateTime20001221 075334 +0800/acknowledgedDateTime - Header orderReferenceNumberpo_2113/orderReferenceNumber requestOrderReferenceNumberpo_2113/requestOrderReferenceNumber - OrderStatus code65536/code /OrderStatus /Header /OrderAcknowledgement Thanx Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists