Re: CFMX problems with null variables
Hello KDJ, This is the very first time I post something, although I've been signed up to it for years. I'd like to greet you all first of all :) And greetings from DownUnder :-) Whenever I have a form and I send its contents to another cf document, if one of the fields was empty, it interprets the variable as not existant. I.e. input name=testtext type=text On the next page, if I left that field blank, when trying to do a #testtext# it says it doesn't exist. This is a browser dependent problem. If you do: input name=testtext type=text value= then most browsers will send an empty variable (except extremely old Netscape AFAIK) if there is no entry made. That problem wouldn't be so big if it wasn't that today I realized that it happens with loops. For example: cfloop index=nopi list=black||yellow| |green delimiters=| cfoutputMy Color is: #nopi# /cfoutputbr /cfloop It returns: My Color is: black My Color is: yellow My Color is: My Color is: green See what I mean? Since the 2nd element is empty, the internal variable just doesn't exist... This is standard CF behaviour with lists. Adjacent delimiters are treated as one delimiter so you need to put something between them. Try something like: cfset listVariable = replace(listVariable, ||, | |, all) That will force the delimiters apart and then you can strip out the spacer afterwards if you need to. -- Yours, Kym [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flex Flash Tree Menu performance resolved, again?
Dick, It works for me. Does flex create a source file (FLA), or just the swf ? It seems to take time for loading. Message appears immediately, but the loading messages starts the 1st time the pages runs. Its appears on other times later(ie. refresh), but loads faster. Are you using CFMX enterprise or standard? TIA, Patrick Whittingham United Space Alliance -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 8:55 PM To: CF-Talk Subject: Flex Flash Tree Menu performance resolved, again? I sent the email (below) earlier but noone could access the examples. I think it is fixed now --long story -- trying to get things working with latest JVM. HTH Dick There were several threads last week re the poor performance of the Flex Flash tree menu. I commented that the one on the Flex Code explorer was one of the slowest I'd seen. I wrote my own Flex Tree example and the performance was consistent with the Code Explorer -- disappointing. Christian Cantrell suggested a resolution -- set the openDuration parameter of the tree function to 0 (the default is 250 ms): mx:Tree openDuration=0 This does resolve the jerkiness and most of the delay when opening and closing nodes. you can see the difference at: http://67.124.145.42/cfusion/Flex/CFFlexTree.cfm vs http://67.124.145.42/cfusion/Flex/CFFlexTree1.cfm 1)Get both up side-by-side. 2) Then, starting at the bottom, open enough nodes to get the scroll bar working pretty good, 3) Scroll to the top and open/close the top node If there is delay downloading, it is because the site is on my dev box, along with MySQL, Sybase, and a couple of real-time streamers. HTH Dick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What is this?
On Tuesday 13 Apr 2004 03:02 am, Dick Applebaum wrote: Can I do anything to reject/detect/sabotage the sender to discourage this sort of thing? Yes, you can come up with a mod_rewrite rule to 404 it or whatever.. In general the request will be coming from a zombie / own3d computer, so there is not much you can do. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flex Flash Tree Menu performance resolved, again?
On Apr 13, 2004, at 3:49 AM, Whittingham, P wrote: It works for me. Does flex create a source file (FLA), or just the swf ? It seems to take time for loading. Message appears immediately, but the loading messages starts the 1st time the pages runs. Its appears on other times later(ie. refresh), but loads faster. Are you using CFMX enterprise or standard? Flex doesn't need a FLA (Flash Source file). A Flex document is, in fact, a source file containing XML and Action Script that defines the structure and procedure of the client-side application. you can see a simple example of CF creating a Flex source at Ben's Blog: http://www.forta.com/blog/index.cfm?mode=eentry=1038 The Flex source gets compiled to a .SWF file I am using CFMX for J2EE/JRun which is the equivalent of Enterprise. One final comment. I haven't done much Flex coding yet, but I really like it compared to Flash coding--- no timeline/movie orientation, and no Flash IDE (which drives me crazy!) HTH Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX cfhttp bug?
Yes, with no effect. On Apr 12, 2004, at 9:45 PM, Geoff Bowers wrote: Have you tried specifying a specific character set with the appropriate attribute in CFHTTP? -- geoff http://www.daemon.com.au/ Dick Applebaum wrote: I ran into an odd bug? when trying to upgrade CF 5 program to CFMX 6.1. The program populates a db from a text file using CFHTTP. I used the actual program and text file from CF 5. I couldn't find any discussion of this in LiveDocs. This cost me several hours of frustration, as the error message is not obviously (to me) referring to a data error. Is there a way around this -- I really want to use the bullet char in the text file)? (used the same technique on a bunch of older CF sites) TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
passing multiple CF vaules to a javascript variable
I am outputting style name values using CF query-results. I'm making those values available to _javascript_ in a variable so I can use the values in an onClick event. If I only needed the variable's last style name value returned by the query, I could use the following: cfoutput script language=_javascript_ type=text/_javascript_ !-- function targetid(){ return #menu_bmarkLink#; } -- /script /cfoutput cfoutput query=Q_menu li A HREF="" cfif q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink# cfelse##Ans > ext# /a /li /cfoutput The complication arises because I want each iteration of the onClick event to hold a different value for the style name variable. What do I have to do to iterate through the style name values from the query so each onClick event iteration has a different value - like this: liA HREF="" cfif q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink# cfelse##Ans /cfif#q_menu.menu_Text# /a /li li A HREF="" cfif q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink# cfelse##Ans /cfif#q_menu.menu_Text# /a /li li A HREF="" cfif q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink# cfelse##Ans /cfif#q_menu.menu_Text# /a /li Thank you in advance!! I've got an app in development that hinges on this code!!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Odd CF / Javascript Question
Here is an interesting one. Is there a way to use a _javascript_ trigger like onclick to update a record in a database WITHOUT calling a new CF template and refreshing the screen? The idea is that there are multiple check boxes on the screen, each representing a record. A user clicks the check box and it updates the associated record with a CFQUERY update.Any help would be appreciated. Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Odd CF / Javascript Question
On Tuesday 13 Apr 2004 13:02 pm, Jeff Waris (Jeff Waris [EMAIL PROTECTED]) wrote: Is there a way to use a _javascript_ trigger like onclick to update a record in a database WITHOUT calling a new CF template and refreshing the screen? The idea is that there are multiple check boxes on the screen, each Search for 'neuromancer' in the archives. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Odd CF / Javascript Question
Is there a way to use a _javascript_ trigger like onclick to update a record in a database WITHOUT calling a new CF template and refreshing the screen? The idea is that there are multiple check boxes on the screen, each representing a record. A user clicks the check box and it updates the associated record with a CFQUERY update.Any help would be appreciated. You need to use something server side to interact with the DB to update the record, _javascript_ is client side. However, you can look into the JSAPI client/server gateway at http://www.pengoworks.com/. Read up on the gateway, I think it is probably what you are looking for. Some others will chime in with some more recent discussions on this gateway topic, but I have only used the one referenced above. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Odd CF / Javascript Question
You can not do it without calling a CF template, but you can do it without refreshing your screen. Create a hidden frame to handle requests to the server without refreshing the current screen. Call the template to update the record in that hidden frame. Pascal -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: dinsdag 13 april 2004 14:02 To: CF-Talk Subject: Odd CF / _javascript_ Question Here is an interesting one. Is there a way to use a _javascript_ trigger like onclick to update a record in a database WITHOUT calling a new CF template and refreshing the screen? The idea is that there are multiple check boxes on the screen, each representing a record. A user clicks the check box and it updates the associated record with a CFQUERY update.Any help would be appreciated. Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RDS servlet errors
On Monday 12 Apr 2004 18:33 pm, [EMAIL PROTECTED] wrote: D:\inetpub\wwwroot\scenario1\myminutes\index.htm.LCK (The system cannot find the file specified) java.io.FileNotFoundException: Isn't that how DreamWeaver does it's locking ? Maybe that is causing files to vanish halfway through something. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Configuration and Settings Migration Wizard ( WAS Re: help, cfmx 6.1 just hangs! )
On Saturday 10 Apr 2004 23:34 pm, Josh [EMAIL PROTECTED] wrote: For those of you familiar with the install process the first screen is the Configuration and Settings Migration Wizard It comes up just fine, but after I enter my admin password...it hangs. I guess it is trying to migrate something it can't - did you completly rm all previous CF installs ? Do you have remotly mounted filesystems (that could cause a directory search to hang, for instance) ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
checking form elements in CF with JavaScript
Hi all, Im trying to use a simple _javascript_ form validation with my CF code. The validation should check both text fields and radio buttons/checkboxes. So far the radio button part does not work. This is the code: script language='_javascript_' !-- function check_form() { for (i = 0; i document.forms[0].elements.length; i++) { checkElement = document.forms[0].elements[i]; if (checkElement.name == 'InstEthn') {if (checkElement.value.length 255) { alert(text too long.); return false;} } if (checkElement.name == 'InstLang') {if (checkElement.value.length 255) { alert(text too long.); return false;} } if (checkElement.name == 'InstEthn') {if (checkElement.value.length 1) { alert(The Instructor Ethnicity field is empty.); return false;}} if (checkElement.name == 'InstLang') {if (checkElement.value.group1 == undefined) { alert(Question 3 was not answered.); return false;}} As it is now, the InstLang field gives the user the Question 3 was not answered message, even when that radio button is checked. Any alternatives/fixes for this code? Thanks a lot, Roberto Perez [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
You can do what you want -- but I can't understand your code -- so here goes cfquery name=getStyle SELECT styleName FROM styleDB /cfquery cfoutput query=getStyle brsome stuff #styleName# some other stuff /cfoutput will provide getStyle.RecordCount linesof output, 1 for each row in the query the #styleName# in each line of output will contain the styleName corresponding to the one in getStyle.CurrentRow HTH Dick On Apr 13, 2004, at 5:07 AM, Joy Holman wrote: I am outputting style name values using CF query-results. I'm making those values available to _javascript_ in a variable so I can use the values in an onClick event. If I only needed the variable's last style name value returned by the query, I could use the following: cfoutput script language=_javascript_ type=text/_javascript_ !-- function targetid(){ return #menu_bmarkLink#; } -- /script /cfoutput cfoutput query=Q_menu li A HREF="" cfif q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink# cfelse##Ans > ext# /a /li /cfoutput The complication arises because I want each iteration of the onClick event to hold a different value for the style name variable. What do I have to do to iterate through the style name values from the query so each onClick event iteration has a different value - like this: liA HREF="" cfif q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink# cfelse##Ans > /cfif#q_menu.menu_Text# /a /li li A HREF="" cfif q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink# cfelse##Ans > /cfif#q_menu.menu_Text# /a /li li A HREF="" cfif q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink# cfelse##Ans /cfif#q_menu.menu_Text# /a /li Thank you in advance!! I've got an app in development that hinges on this code!!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: RDS servlet errors
yup, did some digging and it seems these errors are related to DWMX.Now, the thing is, I just tested this, I have the check in/out turned off in DWMX, yet I still see these errors.Seems DWMX is doing something wrong here. Doug -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 8:40 AM To: CF-Talk Subject: Re: RDS servlet errors On Monday 12 Apr 2004 18:33 pm, [EMAIL PROTECTED] wrote: D:\inetpub\wwwroot\scenario1\myminutes\index.htm.LCK (The system cannot find the file specified) java.io.FileNotFoundException: Isn't that how DreamWeaver does it's locking ? Maybe that is causing files to vanish halfway through something. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Configuration and Settings Migration Wizard ( WAS Re: help, cfmx 6.1 just hangs! )
Yes, you can bypass that wizard by editing the adminconfig.xml file, check out this technote about the wizard hanging o Installing ODBC Services and apply the same steps: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink.htm #hangs http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink.ht m#hangs Christine -Original Message- From: Josh [mailto:[EMAIL PROTECTED] Sent: Saturday, April 10, 2004 6:35 PM To: CF-Talk Subject: Configuration and Settings Migration Wizard ( WAS Re: help, cfmx 6.1 just hangs! ) OK, I have narrowed this down further.I have installed and reinstalled CF a few times.I can get .cfm files running, but I cannot get past the initial admin screen after install. For those of you familiar with the install process the first screen is the Configuration and Settings Migration Wizard It comes up just fine, but after I enter my admin password...it hangs. Does anyone know technically what this screen does behind the scenes? Is there a workaround for this?Can I bypass this screen by editing the xml config files directly? Thanks! -Josh Josh wrote: We are running Apache 2.0.46 Any ideas? Much Thanks Dave Watts wrote: I am running CFMX 6.1 on RHEL3 with Apache. What version of Apache are you using? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Using ABS in CF 5
Why would 3E-005be shown when using #abs(NumberFormat(getRate.Rate)'_.__'))#? instead of0.25, which is the value in the db (and the value returned when Select ABS(.25) is run) If I take the abs away, the number is shown correctly...? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using ABS in CF 5
From: Kristen Winsor Why would 3E-005be shown when using #abs(NumberFormat(getRate.Rate)'_.__'))#? instead of0.25, which is the value in the db (and the value returned when Select ABS(.25) is run) If I take the abs away, the number is shown correctly...? Try putting the ABS() inside the NUMBERFORMAT() What's happening is that you're specifying the format, then telling CF to display it how it wants with the ABS() [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Web Services and CFMX6.1 -- Why doesn't it work?
I'm at my wit's end here, folks.I don't know why my idiotic hello world web service just isn't working.Here's a path to my madness: helloworld.cfc cfcomponent cffunction name=getMessage access=remote returntype=string output=false cfargument name=name type=string required=yes cfreturn Hello arguments.name , web service is working. /cffunction /cfcomponent --- hello_component.cfm (to check if the CFC is working) cfinvoke component=helloworld method=getMessage returnvariable=aString cfinvokeargument name=name value=Bozo/ /cfinvoke cfoutput#aString#/cfoutput Output: Hello Bozo, web service is working. --- helloworld.cfc?wsdl Output: works fine, displays the XML --- hello.cfm cfinvoke webservice=http://localhost/ws/helloworld.cfc?wsdl method=getMessage returnvariable=aString cfinvokeargument name=name value=Bozo/ /cfinvoke cfoutput#aString#/cfoutput Output: Could not generate stub objects for web service invocation. Name: http://localhost/ws/helloworld.cfc?wsdl. WSDL: http://localhost/ws/helloworld.cfc?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=1: Missing whitespace before SYSTEM literal URI. -- What the hell am I doing wrong?Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using ABS in CF 5
what are you looking to end up with if the value that you start with is 0.25 tony. -Original Message- From: Kristen Winsor [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:16 AM To: CF-Talk Subject: Using ABS in CF 5 Why would 3E-005be shown when using #abs(NumberFormat(getRate.Rate)'_.__'))#? instead of0.25, which is the value in the db (and the value returned when Select ABS(.25) is run) If I take the abs away, the number is shown correctly...? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using ABS in CF 5
It looks like it rounds the number. Try #NumberFormat(abs(getRate.Rate),'_.__')# -Original Message- From: Kristen Winsor [mailto:[EMAIL PROTECTED] Sent: dinsdag 13 april 2004 15:16 To: CF-Talk Subject: Using ABS in CF 5 Why would 3E-005be shown when using #abs(NumberFormat(getRate.Rate)'_.__'))#? The parantheses are wrong, but I suppose it's a typo in the mail. instead of0.25, which is the value in the db (and the value returned when Select ABS(.25) is run) If I take the abs away, the number is shown correctly...? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfx_getImage error! Don't know what's causing it
Hello Everybody, I'm really hoping that someone will help me. A lot of people have used the cfx_getImage tag to open up office documents (word,excel, blah). I thought I'll use it to do the same. The documents are stored on the database table as binary objects. I registered the cfx tag in the administrator. I'm calling it on the page like this: cfquery name=getAttachmentDetails datasource=db select * from Attachment where id = '#url.id#' /cfquery CFX_GETIMAGE DATASOURCE=db USER=dbUserName PASSWORD=dbPassword SQL=select filename FROM Attachment WHERE id = '#url.id#' OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName# I get this error message: The error occurred in E:\inetpub\wwwroot\viewattachment.cfm: line 8 6 : CFX_GETIMAGE 7 : DATASOURCE=db 8 : USER=dbUserName 9 : PASSWORD=dbPassword 10 : SQL=select filename FROM Attachment WHERE id = '#url.id#' (USER=dbUserName is in bold) SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 Does anybody know why I'm getting this error? I would really appreciate your help Regards, cfcoder __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: JS select box question
I have a form for entering the billing address and shipping address. I've found a js script that works very nicely for copying the contents of text fields from the billing fields to the shipping fields when a checkbox is checked. The problem comes in when trying to copy the state selected in the billing section drop down box to the shipping state selection drop down box I'm not sure that's possible, but I'm sure this has been addressed before. Does anyone have a recommendation for this? TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JS select box question
tim, not really an answer, but if they are just saying yes this address is this address make the field a text box, and disabled... why would they need to change it if they are saying, this is correct, and make these fields match the above fields tw -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:44 AM To: CF-Talk Subject: SOT: JS select box question I have a form for entering the billing address and shipping address. I've found a js script that works very nicely for copying the contents of text fields from the billing fields to the shipping fields when a checkbox is checked. The problem comes in when trying to copy the state selected in the billing section drop down box to the shipping state selection drop down box I'm not sure that's possible, but I'm sure this has been addressed before. Does anyone have a recommendation for this? TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JS select box question
document.theForm.shippingState.selectedIndex = document.theForm.billingState.selectedIndex; Assuming your two selects have the same options Pascal -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: dinsdag 13 april 2004 15:44 To: CF-Talk Subject: SOT: JS select box question I have a form for entering the billing address and shipping address. I've found a js script that works very nicely for copying the contents of text fields from the billing fields to the shipping fields when a checkbox is checked. The problem comes in when trying to copy the state selected in the billing section drop down box to the shipping state selection drop down box I'm not sure that's possible, but I'm sure this has been addressed before. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX problems with null variables
From: Kym Kovan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: CFMX problems with null variables Date: Tue, 13 Apr 2004 17:07:56 +1000 Hello KDJ, This is the very first time I post something, although I've been signed up to it for years. I'd like to greet you all first of all :) And greetings from DownUnder :-) Whenever I have a form and I send its contents to another cf document, if one of the fields was empty, it interprets the variable as not existant. I.e. input name=testtext type=text On the next page, if I left that field blank, when trying to do a #testtext# it says it doesn't exist. This is a browser dependent problem. If you do: input name=testtext type=text value= then most browsers will send an empty variable (except extremely old Netscape AFAIK) if there is no entry made. That problem wouldn't be so big if it wasn't that today I realized that it happens with loops. For example: cfloop index=nopi list=black||yellow| |green delimiters=| cfoutputMy Color is: #nopi# /cfoutputbr /cfloop It returns: My Color is: black My Color is: yellow My Color is: My Color is: green See what I mean? Since the 2nd element is empty, the internal variable just doesn't exist... This is standard CF behaviour with lists. Adjacent delimiters are treated as one delimiter so you need to put something between them. Try something like: cfset listVariable = replace(listVariable, ||, | |, all) That will force the delimiters apart and then you can strip out the spacer afterwards if you need to. Or you could use this UDF to change your list to an array with nulls and loop over the array instead: http://www.cflib.org/udf.cfm?id=1022 Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
btw, my application is running on cfmx. I just can't see why the code would error. I've checked the value passed to the USER attribute and it is correct. Hello Everybody, I'm really hoping that someone will help me. A lot of people have used the cfx_getImage tag to open up office documents (word,excel, blah). I thought I'll use it to do the same. The documents are stored on the database table as binary objects. I registered the cfx tag in the administrator. I'm calling it on the page like this: cfquery name=getAttachmentDetails datasource=db select * from Attachment where id = '#url.id#' /cfquery CFX_GETIMAGE DATASOURCE=db USER=dbUserName PASSWORD=dbPassword SQL=select filename FROM Attachment WHERE id = '#url.id#' OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName# I get this error message: The error occurred in E:\inetpub\wwwroot\viewattachment.cfm: line 8 6 : CFX_GETIMAGE 7 : DATASOURCE=db 8 : USER=dbUserName 9 : PASSWORD=dbPassword 10 : SQL=select filename FROM Attachment WHERE id = '#url.id#' (USER=dbUserName is in bold) SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 Does anybody know why I'm getting this error? I would really appreciate your help Regards, cfcoder __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web Services and CFMX6.1 -- Why doesn't it work?
Sung, Don't get too frustrated. The problem here is that you are not invoking the webservice through the correct path,Try: cfinvoke webservice=http://localhost:8500/ws/helloworld.cfc?wsdl http://localhost:8500/ws/helloworld.cfc?wsdl Let me know how it goes, Michael Corbridge _ From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:31 AM To: CF-Talk Subject: Web Services and CFMX6.1 -- Why doesn't it work? I'm at my wit's end here, folks.I don't know why my idiotic hello world web service just isn't working.Here's a path to my madness: helloworld.cfc cfcomponent cffunction name=getMessage access=remote returntype=string output=false cfargument name=name type=string required=yes cfreturn Hello arguments.name , web service is working. /cffunction /cfcomponent --- hello_component.cfm (to check if the CFC is working) cfinvoke component=helloworld method=getMessage returnvariable=aString cfinvokeargument name=name value=Bozo/ /cfinvoke cfoutput#aString#/cfoutput Output: Hello Bozo, web service is working. --- helloworld.cfc?wsdl Output: works fine, displays the XML --- hello.cfm cfinvoke webservice=http://localhost/ws/helloworld.cfc?wsdl method=getMessage returnvariable=aString cfinvokeargument name=name value=Bozo/ /cfinvoke cfoutput#aString#/cfoutput Output: Could not generate stub objects for web service invocation. Name: http://localhost/ws/helloworld.cfc?wsdl. WSDL: http://localhost/ws/helloworld.cfc?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=1: Missing whitespace before SYSTEM literal URI. -- What the hell am I doing wrong?Any ideas? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JS select box question
Yeah, I guess you're right... I think I'm trying to make this more complicated than it needs to be I wanted to make it kinda cool so that when they clicked the checkbox that says use same address for shipping it filled in the shipping fields with those entries in the billing address fields... I'm going to get coffee now I might try Pascal's suggestion -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:42 AM To: CF-Talk Subject: RE: JS select box question tim, not really an answer, but if they are just saying yes this address is this address make the field a text box, and disabled... why would they need to change it if they are saying, this is correct, and make these fields match the above fields tw -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:44 AM To: CF-Talk Subject: SOT: JS select box question I have a form for entering the billing address and shipping address. I've found a js script that works very nicely for copying the contents of text fields from the billing fields to the shipping fields when a checkbox is checked. The problem comes in when trying to copy the state selected in the billing section drop down box to the shipping state selection drop down box I'm not sure that's possible, but I'm sure this has been addressed before. Does anyone have a recommendation for this? TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: checking form elements in CF with JavaScript
Try checking for the checked attribute instead of the value attribute. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JS select box question
oh yeah, of course, his is the way to do it but, in my estimation a bit unneeded, since a drop down is for choices, and a text box for something that is absolute...but truly its up to you and how you want to design it... later tw -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:03 AM To: CF-Talk Subject: RE: JS select box question Yeah, I guess you're right... I think I'm trying to make this more complicated than it needs to be I wanted to make it kinda cool so that when they clicked the checkbox that says use same address for shipping it filled in the shipping fields with those entries in the billing address fields... I'm going to get coffee now I might try Pascal's suggestion -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:42 AM To: CF-Talk Subject: RE: JS select box question tim, not really an answer, but if they are just saying yes this address is this address make the field a text box, and disabled... why would they need to change it if they are saying, this is correct, and make these fields match the above fields tw -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:44 AM To: CF-Talk Subject: SOT: JS select box question I have a form for entering the billing address and shipping address. I've found a js script that works very nicely for copying the contents of text fields from the billing fields to the shipping fields when a checkbox is checked. The problem comes in when trying to copy the state selected in the billing section drop down box to the shipping state selection drop down box I'm not sure that's possible, but I'm sure this has been addressed before. Does anyone have a recommendation for this? TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JS select box question
Just a note of thanks Pascal.. those couple lines of code worked -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:03 AM To: CF-Talk Subject: RE: JS select box question Yeah, I guess you're right... I think I'm trying to make this more complicated than it needs to be I wanted to make it kinda cool so that when they clicked the checkbox that says use same address for shipping it filled in the shipping fields with those entries in the billing address fields... I'm going to get coffee now I might try Pascal's suggestion -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:42 AM To: CF-Talk Subject: RE: JS select box question tim, not really an answer, but if they are just saying yes this address is this address make the field a text box, and disabled... why would they need to change it if they are saying, this is correct, and make these fields match the above fields tw -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:44 AM To: CF-Talk Subject: SOT: JS select box question I have a form for entering the billing address and shipping address. I've found a js script that works very nicely for copying the contents of text fields from the billing fields to the shipping fields when a checkbox is checked. The problem comes in when trying to copy the state selected in the billing section drop down box to the shipping state selection drop down box I'm not sure that's possible, but I'm sure this has been addressed before. Does anyone have a recommendation for this? TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX JRun Services on Windows 2000
CFMX for J2EE, Windows 2000. I've got a number of CF instance running on the server. However only 3 services are running connected to JRun. Admin, Default, and CFusion. (The 3 default instances jrun creates when you install CF) When the server is rebooted, only the 3 default services are restarted. All other instances are not. Looking into the services that are there, shows the same executable (jrunsvc.exe), yet there are no startup parameters to differentiate them. I'm curious as to what the difference is between the three since they all run the same executable. A solution, which seems a bit sloppy, is to create a scheduled task that runs on system startup, which makes the appropriate command line execution. (jrun.exe -start myCFInstance) Is there anyway to add these instance as services like the default cfusion one that is created during the initial install of the server? -adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Services and CFMX6.1 -- Why doesn't it work?
Hi Michael, Thanks, but that doesn't seem to work, either. I don't understand why I'd use port 8500...I'm not using the built-in webserver, I'm using IIS? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Disappearing/reappearing application variables...
Is there any reason application variables would disappear before the application timeout set in Application.cfm file? I have the following code, which initializes an application based CFC if it does not already exist.I put in a cflog tag to let me know how often it rebuilds itself and it seems to re-initialize every 1-2 hours, even though I have the application timeout set to 12 hours in the cfapplication tag (and the server timeout is still set to the default 2 days for application vars.) cfif NOT StructKeyExists(application, SomeCFC) OR 0 cflock name=CreateSomeCFC#application.ApplicationName# timeout=10 throwontimeout=Yes type=Exclusive cfscript // i create the SomeCFC application.SomeCFC=CreateObject(component, SomeCFC).Init(); /cfscript /cflock !--- i update the SomeCFC log file --- cflog text=SomeCFC initialized [#GetBaseTemplatePath()# :: #cgi.Remote_Addr#] file=SomeCFC /cfif The CFC contains a semi-boatload of configuration data, cached structs, etc; but I've definitely worked with larger amounts of persistent data before...could this be an issue?Is there anyway to check how much is too much with memory vars?As usual, any help would be greatly appreciated- Tyler S PS: I'm also going to add another conditional statement within the lock to re-check if the struct exists, I've just been forcing the re-init by changing the 0 to a 1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Recipe Application
Does anyone know of a good recipe application?No specific requirements, so open to all suggestions. TIA, Issac [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How to streamline a request that uses many cfquery statements?
This feels like a dumb question, but here goes . . . Am I correct that in a CF template that has, say, 15 cfquery statements the cfquery statements are submitted one at a time with each subsequent cfquery not submitted until the previous cfquery returns? I.e., if all 15 queries have to run and there is no logic in the markup that arranges or rearranges the order in which the queries run do they run one at a time in sequence from top to bottom? Is there a way to have multiple queries running from the same cf template at the same time? We produce a report that is essentially three reports bundled into one and displayed one after the other. Currently we run 15 queries (3*5) to create this report and it takes 3 - 3 1/2 minutes for the queries to complete. Logically it seems that we could run the three report processes concurrently and independently and then assemble them into the final report when the answer sets come back which should dramatically speed up the process. Is there a way to do this with CF? (We're using Oracle 8i, CF5, migrating to CFMX 6.1, on Windows 2000 Advanced Server.) Thanks! George [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Disappearing/reappearing application variables...
Is there any reason application variables would disappear before the application timeout set in Application.cfm file? If the application timeout in the CF Administrator is less than what it is set in your cfapplication tag.Did you check the admin setting? Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to streamline a request that uses many cfquery statements?
Stored Procedures? -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED] Sent: dinsdag 13 april 2004 16:40 To: CF-Talk Subject: How to streamline a request that uses many cfquery statements? This feels like a dumb question, but here goes . . . Am I correct that in a CF template that has, say, 15 cfquery statements the cfquery statements are submitted one at a time with each subsequent cfquery not submitted until the previous cfquery returns? I.e., if all 15 queries have to run and there is no logic in the markup that arranges or rearranges the order in which the queries run do they run one at a time in sequence from top to bottom? Is there a way to have multiple queries running from the same cf template at the same time? We produce a report that is essentially three reports bundled into one and displayed one after the other. Currently we run 15 queries (3*5) to create this report and it takes 3 - 3 1/2 minutes for the queries to complete. Logically it seems that we could run the three report processes concurrently and independently and then assemble them into the final report when the answer sets come back which should dramatically speed up the process. Is there a way to do this with CF? (We're using Oracle 8i, CF5, migrating to CFMX 6.1, on Windows 2000 Advanced Server.) Thanks! George [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MX: Scheduler firing off too often
Hey folks - I've got an MX box (Windows) with a oddly behaving scheduler. I've got a single task in the list, that fires off once every three minutes. I've got the task aborting early, but not before it sends me a quickie time-stamped email. Every once in a while, I'll get two or three emails with the same time (sans seconds) on it. I did this due to prior behavior of this box's scheduler - when testing this particular task, when I added it to the scheduler initially, it worked great. Took it out... put it back... then it was running TWICE. Took it out... put it back again... it would run THREE times. Any thoughts on what the issue may be, and how to resolve it? Thanks in advance, --Scott [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web Services and CFMX6.1 -- Why doesn't it work?
Sung, Sorry - my bad,I connect up to the built in webserver for testing. However, I note that I get the same error you get if the path to the cfc is incorrect. Can you browse the cfc? _ From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:21 AM To: CF-Talk Subject: Re: Web Services and CFMX6.1 -- Why doesn't it work? Hi Michael, Thanks, but that doesn't seem to work, either. I don't understand why I'd use port 8500...I'm not using the built-in webserver, I'm using IIS? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MX: Scheduler firing off too often
Ack, should have said Linux instead of Windows there. At 08:45 AM 4/13/2004, you wrote: Hey folks - I've got an MX box (Windows) with a oddly behaving scheduler. I've got a single task in the list, that fires off once every three minutes. I've got the task aborting early, but not before it sends me a quickie time-stamped email. Every once in a while, I'll get two or three emails with the same time (sans seconds) on it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to streamline a request that uses many cfquery statements?
Sounds like you should be doing some stored procedures. - Original Message - From: Earl, George We produce a report that is essentially three reports bundled into one and displayed one after the other. Currently we run 15 queries (3*5) to create this report and it takes 3 - 3 1/2 minutes for the queries to complete. Logically it seems that we could run the three report processes concurrently and independently and then assemble them into the final report when the answer sets come back which should dramatically speed up the process. Is there a way to do this with CF? (We're using Oracle 8i, CF5, migrating to CFMX 6.1, on Windows 2000 Advanced Server.) Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Recipe Application
A friend developed planyourmeals.com Not sure if he's making the code available (or if you need the code) but it allows people to share recipes, and once you choose a recipe, it gives you a weekly shopping list based on the meals you plan. John -Original Message- From: Issac Rosa [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:37 AM To: CF-Talk Subject: Recipe Application Does anyone know of a good recipe application?No specific requirements, so open to all suggestions. TIA, Issac [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX JRun Services on Windows 2000
Is there anyway to add these instance as services like the default cfusion one that is created during the initial install of the server? You need to register them as services by running jrunsvc.exe from the command line with the appropriate parameters. jrunsvc -install cfusion2 cfusion2 (or something like that). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to streamline a request that uses many cfquery statements?
Earl, George said: Am I correct that in a CF template that has, say, 15 cfquery statements the cfquery statements are submitted one at a time with each subsequent cfquery not submitted until the previous cfquery returns? I.e., if all 15 queries have to run and there is no logic in the markup that arranges or rearranges the order in which the queries run do they run one at a time in sequence from top to bottom? Correct. Is there a way to have multiple queries running from the same cf template at the same time? Write a multi-threaded Java/C customtag. We produce a report that is essentially three reports bundled into one and displayed one after the other. Currently we run 15 queries (3*5) to create this report and it takes 3 - 3 1/2 minutes for the queries to complete. Logically it seems that we could run the three report processes concurrently and independently and then assemble them into the final report when the answer sets come back which should dramatically speed up the process. Not necessarily. If the db-server is continuously stressed out concurrent queries will not help. There even is a considerable chance they will hurt, for instance through trashing the buffers. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX JRun Services on Windows 2000
Adam, You can try this command to add a CF server service on Windows: {Jrun_home}\binjrunsvc -install cfusion2 Macromedia JRun CFusion2 Server Macromedia JRun CFusion2 Server Hua -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:19 AM To: CF-Talk Subject: CFMX JRun Services on Windows 2000 CFMX for J2EE, Windows 2000. I've got a number of CF instance running on the server. However only 3 services are running connected to JRun. Admin, Default, and CFusion. (The 3 default instances jrun creates when you install CF) When the server is rebooted, only the 3 default services are restarted. All other instances are not. Looking into the services that are there, shows the same executable (jrunsvc.exe), yet there are no startup parameters to differentiate them. I'm curious as to what the difference is between the three since they all run the same executable. A solution, which seems a bit sloppy, is to create a scheduled task that runs on system startup, which makes the appropriate command line execution. (jrun.exe -start myCFInstance) Is there anyway to add these instance as services like the default cfusion one that is created during the initial install of the server? -adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Services and CFMX6.1 -- Why doesn't it work?
Yup, I can browse it just fine.If I use the ?wsdl after the helloworld.cfc, I generate the XML file fine, too. And even stranger...I'm doing this because we're evaluating Vignette, which has nice interactivity with web services.This web service is recognized and fully usable by Vignette!So it only fails here, on CFMX.Very, very strange... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web Services and CFMX6.1 -- Why doesn't it work?
Sung Woo, Try hitting this in your web browser: http://localhost/ws/helloworld.cfc What do you get? If it's a blank page then webservices are set up correctly, if you get an error, then there's still work to be done. Let us know what you get. Ryan -Original Message- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:21 AM To: CF-Talk Subject: Re: Web Services and CFMX6.1 -- Why doesn't it work? Hi Michael, Thanks, but that doesn't seem to work, either. I don't understand why I'd use port 8500...I'm not using the built-in webserver, I'm using IIS? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MX: Scheduler firing off too often
Scott, I have the same issue with my CFMX 6.1 box on W2K.It only happens sometimes, maybe once every month.I haven't found a cure for it, only a workaround.I have a lengthy scheduled task that runs at 3am once a week, but if it runs during business hours, it can create some problems.So I wrapped a simple CFIF statement around it -- i.e., cfif this script is running before 2:55am or after 3:15am, then don't run it. Yeah, it's stupid, but it's a workaround.Since you have yours firing off pretty often, I'm not sure if this will work for you...but maybe other people will have some ideas. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Services and CFMX6.1 -- Why doesn't it work?
I don't get a blank page, but I do get a redirect to the component browser, which looks something like this: ws.helloworld Component helloworld hierarchy: WEB-INF.cftags.component ws.helloworld path: E:\webroot\ws\helloworld.cfc properties: methods: getMessage * - private method getMessage remote string getMessage ( required string name ) Output: supressed Parameters: name: string, required, name [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web Services and CFMX6.1 -- Why doesn't it work?
I tested on my server, it worked. So the code is fine. You may want to check your server config. Hua -Original Message- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:31 AM To: CF-Talk Subject: Web Services and CFMX6.1 -- Why doesn't it work? I'm at my wit's end here, folks.I don't know why my idiotic hello world web service just isn't working.Here's a path to my madness: helloworld.cfc cfcomponent cffunction name=getMessage access=remote returntype=string output=false cfargument name=name type=string required=yes cfreturn Hello arguments.name , web service is working. /cffunction /cfcomponent --- hello_component.cfm (to check if the CFC is working) cfinvoke component=helloworld method=getMessage returnvariable=aString cfinvokeargument name=name value=Bozo/ /cfinvoke cfoutput#aString#/cfoutput Output: Hello Bozo, web service is working. --- helloworld.cfc?wsdl Output: works fine, displays the XML --- hello.cfm cfinvoke webservice=http://localhost/ws/helloworld.cfc?wsdl method=getMessage returnvariable=aString cfinvokeargument name=name value=Bozo/ /cfinvoke cfoutput#aString#/cfoutput Output: Could not generate stub objects for web service invocation. Name: http://localhost/ws/helloworld.cfc?wsdl. WSDL: http://localhost/ws/helloworld.cfc?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=1: Missing whitespace before SYSTEM literal URI. -- What the hell am I doing wrong?Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOLVED: CFMX JRun Services on Windows 2000
Thanks, that did the trick. -adam -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 02:56 PM To: 'CF-Talk' Subject: RE: CFMX JRun Services on Windows 2000 Is there anyway to add these instance as services like the default cfusion one that is created during the initial install of the server? You need to register them as services by running jrunsvc.exe from the command line with the appropriate parameters. jrunsvc -install cfusion2 cfusion2 (or something like that). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web Services and CFMX6.1 -- Why doesn't it work?
You said IIS, do you have the virtual directory for JrunScripts in this web? -Original Message- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:02 AM To: CF-Talk Subject: Re: Web Services and CFMX6.1 -- Why doesn't it work? I don't get a blank page, but I do get a redirect to the component browser, which looks something like this: ws.helloworld Component helloworld hierarchy: WEB-INF.cftags.component ws.helloworld path: E:\webroot\ws\helloworld.cfc properties: methods: getMessage * - private method getMessage remote string getMessage ( required string name ) Output: supressed Parameters: name: string, required, name _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Disappearing/reappearing application variables...
Yea, the Administrator's timeout for application vars is set to 2 days, and I have my cfapplication tag asking for 12 hours...any other ideas? Tyler _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:43 AM To: CF-Talk Subject: RE: Disappearing/reappearing application variables... Is there any reason application variables would disappear before the application timeout set in Application.cfm file? If the application timeout in the CF Administrator is less than what it is set in your cfapplication tag.Did you check the admin setting? Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Stay in Domain...?
Ok I have one for you... I have this site that I am working on... http://65.218.34.47 http://65.218.34.47/and it is going to be somewhat template based for our users. Basically we have Division leaders that will get one of these sites to help with recruiting new people. Each site will be personalized for the Division things like menus, schedules, testimonials and a few other things will be dynamic information. What I would like to do also is have it to where if the recruiting division has their own domain name like www.recruitme.com http://www.recruitme.com/and I have the domain pointing to our servers, how can I make the site stay in the domain when the main site is www.ugaonline.com http://www.ugaonline.com/ . Does this make sense?... We will have about 130 recruiting divisions that will all have their own domain name. But we have only one website. I would like anyone with the domain name to stay in their domain when someone is referred from their site instead of being redirected like I have done in the past. Is there a way to do this... I was planning on reading the host header and using ColdFusion to determine the incoming site and display the recruiting districts information dynamically using the domain name as unique variable. Any ideas... thanks.. Neal Bailey Internet Marketing Manager E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Disappearing/reappearing application variables...
Are there any other application.cfm on this server instnace. If so do they all have different application names? -Adam -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 02:43 PM To: 'CF-Talk' Subject: RE: Disappearing/reappearing application variables... Is there any reason application variables would disappear before the application timeout set in Application.cfm file? If the application timeout in the CF Administrator is less than what it is set in your cfapplication tag.Did you check the admin setting? Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
can someone please respond to my post! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Services and CFMX6.1 -- Why doesn't it work?
Thanks for all your help, guys.I tried the snippet on my production server, and sure enough, it runs just fine.So I guess it is my server config.What could it be, though?I don't understand what inside CF could cause this, when all evidence points to the file being exactly where it should be.The Mappings on both production and test are identical... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Services and CFMX6.1 -- Why doesn't it work?
Ryan -- yes, I do have that vdir on both production and test... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Stay in Domain...?
Well, the easiest way would be to just make all of your links relative. Then, no matter what name they come in on, everything works.If you have to provide full domain names, just use cgi.http_host to get the current domain name/host that the user came in on. John Burns -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:09 AM To: CF-Talk Subject: Stay in Domain...? Ok I have one for you... I have this site that I am working on... http://65.218.34.47 http://65.218.34.47/and it is going to be somewhat template based for our users. Basically we have Division leaders that will get one of these sites to help with recruiting new people. Each site will be personalized for the Division things like menus, schedules, testimonials and a few other things will be dynamic information. What I would like to do also is have it to where if the recruiting division has their own domain name like www.recruitme.com http://www.recruitme.com/and I have the domain pointing to our servers, how can I make the site stay in the domain when the main site is www.ugaonline.com http://www.ugaonline.com/ . Does this make sense?... We will have about 130 recruiting divisions that will all have their own domain name. But we have only one website. I would like anyone with the domain name to stay in their domain when someone is referred from their site instead of being redirected like I have done in the past. Is there a way to do this... I was planning on reading the host header and using ColdFusion to determine the incoming site and display the recruiting districts information dynamically using the domain name as unique variable. Any ideas... thanks.. Neal Bailey Internet Marketing Manager E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_getImage error! Don't know what's causing it
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. This error says the table Attachment doesn't exist in the database. Does it exist in your DATASOURCE=db? -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:33 AM To: CF-Talk Subject: cfx_getImage error! Don't know what's causing it Hello Everybody, I'm really hoping that someone will help me. A lot of people have used the cfx_getImage tag to open up office documents (word,excel, blah). I thought I'll use it to do the same. The documents are stored on the database table as binary objects. I registered the cfx tag in the administrator. I'm calling it on the page like this: cfquery name=getAttachmentDetails datasource=dbselect * from Attachment where id = '#url.id#' /cfquery CFX_GETIMAGE DATASOURCE=db USER=dbUserName PASSWORD=dbPassword SQL=select filename FROM Attachment WHERE id = '#url.id#' OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName# I get this error message: The error occurred in E:\inetpub\wwwroot\viewattachment.cfm: line 8 6 : CFX_GETIMAGE 7 : DATASOURCE=db 8 : USER=dbUserName 9 : PASSWORD=dbPassword 10 : SQL=select filename FROM Attachment WHERE id = '#url.id#' (USER=dbUserName is in bold) SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 Does anybody know why I'm getting this error? I would really appreciate your help Regards, cfcoder __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
this is what is dumped in the Stack Trace: coldfusion.tagext.DerivedNativeCFXException: Error occurred in tag CFX_GETIMAGE at coldfusion.tagext.NativeCfx.processRequest(Native Method) at coldfusion.tagext.CfxTag.doStartTag(CfxTag.java:110) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfviewattachment2ecfm50240.runPage(E:\inetpub\wwwroot\tempDocumentsFolder\viewattachment.cfm:8) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX JRun Services on Windows 2000
ok, now how can I get rid of the default 'cfusion' instance. When I try jrunsvc -remove cfusion, it says the specified service does nto exist. -adam -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 03:06 PM To: 'CF-Talk' Subject: SOLVED:CFMX JRun Services on Windows 2000 Thanks, that did the trick. -adam -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 02:56 PM To: 'CF-Talk' Subject: RE: CFMX JRun Services on Windows 2000 Is there anyway to add these instance as services like the default cfusion one that is created during the initial install of the server? You need to register them as services by running jrunsvc.exe from the command line with the appropriate parameters. jrunsvc -install cfusion2 cfusion2 (or something like that). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
yes it does. I've double checked it. I don't have the source for the dll (.cpp file). I was using the getImage.dll on another project and thought I can reuse it. Tell me, does the .cpp file specify the dsn name? Because if it does then I'll get this error because the dsn name used in that project is different from the dsn name I'm using on this project. Do you have the .cpp files for this dll? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
In that email, that you are sending to your self, you may also want to add a few CGI vars to see where and what is calling that cfm page.One time Google some how found a .cfm page that I had scheduler set to run once a week and every time Google spidered the site it would run that page. HTTP_REFERER: b#CGI.HTTP_REFERER#/bbr HTTP_USER_AGENT: b#CGI.HTTP_USER_AGENT#/bbr REMOTE_ADDR: b#CGI.REMOTE_ADDR#/bbr Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] http://www.vividmedia.com www.vividmedia.com 608.270.9770 _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:48 AM To: CF-Talk Subject: Re: MX: Scheduler firing off too often Ack, should have said Linux instead of Windows there. At 08:45 AM 4/13/2004, you wrote: Hey folks - I've got an MX box (Windows) with a oddly behaving scheduler. I've got a single task in the list, that fires off once every three minutes. I've got the task aborting early, but not before it sends me a quickie time-stamped email. Every once in a while, I'll get two or three emails with the same time (sans seconds) on it. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting books
I recommend Tom's book, as well.I worked on the ColdFusion section, so I know it's comprehensive.:) Christian On Apr 12, 2004, at 11:49 AM, Dave Carabetta wrote: Sorry for the crosspost all . . . I know that Tom Muck's book Flash Remoting: The Definitive Guide has gotten solid reviews. I looked at it in a bookstore once and it seemed pretty comprehensive. I just don't do much with remoting, so I can't give you any real world feedback. http://www.amazon.com/exec/obidos/ASIN/059600401X/104-8416979-6521558 Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
I'm placing the query results of several fields into an HTML list. The href of each generated link includes an onClick event. Because of that, I need to create a _javascript_ variable that holds the values of the style name field from the query. I don't know how to populate the style name variable for each list item. Thanks for your interest and your assistance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
I changed the code a select statement a bit. I appended 'dbo.' before the table name. CFX_GETIMAGE DATASOURCE=db USER=dbUserName PASSWORD=dbPassword SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName# This was the error I was getting before I made the above change: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 And this is what I get now: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. pcbErrorMsg = 97 Notice the difference in the pcbErrorMsg value. Does that tell you anything? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Web + v5.0
Has anyone heard of this product:Web + v5.0 -- It is supposed to be easier to use and less expensive than CF. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_getImage error! Don't know what's causing it
Any chance attachment is a reserved keyword?Maybe you should do select [filename] from dbo.[Attachment] where id = '01057870' I don't know if that would make any difference, but I know I've had trouble in the past with using reserved words. John Burns -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:52 AM To: CF-Talk Subject: Re: cfx_getImage error! Don't know what's causing it I changed the code a select statement a bit. I appended 'dbo.' before the table name. CFX_GETIMAGE DATASOURCE=db USER=dbUserName PASSWORD=dbPassword SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName# This was the error I was getting before I made the above change: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 And this is what I get now: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. pcbErrorMsg = 97 Notice the difference in the pcbErrorMsg value. Does that tell you anything? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PDF Report Generation from ColdFusion
I posted this message earlier. Does anybody know how to create a report in PDF format from an existing ColdFusion report? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX JRun Services on Windows 2000
ok, now how can I get rid of the default 'cfusion' instance. When I try jrunsvc -remove cfusion, it says the specified service does nto exist. I think the default service name is Macromedia JRun CFusion Server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Disappearing/reappearing application variables...
Yep, it's a brand new CFMX install, with three separate sites with 3 separate application names. Someone was complaining about a JRun connection closed error a couple days ago and I'm beginning to wonder if the server's hanging, then restarting itself, which would then cause my application vars to reset. But when I view the logs, the only log file I can find that says anything about ColdFusion starting/stopping is the server.log, and the only record it has of ColdFusion started was 5 days ago when the server was first installed...is this the correct place for checking CFMX service starts/restarts to check my theory, or is there somewhere else I can look? Tyler S _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:13 AM To: CF-Talk Subject: Re: Disappearing/reappearing application variables... Are there any other application.cfm on this server instnace. If so do they all have different application names? -Adam -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 02:43 PM To: 'CF-Talk' Subject: RE: Disappearing/reappearing application variables... Is there any reason application variables would disappear before the application timeout set in Application.cfm file? If the application timeout in the CF Administrator is less than what it is set in your cfapplication tag.Did you check the admin setting? Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Some sample code would really help here as JS is picky about syntax. That said... I'll assume you're popping open a window ;-) here's some psuedo-code cfoutput > /cfoutput Then have a _javascript_ function in the HEAD block that takes 2 arguments.So all you're doing is setting the values of the arguments passed to the function with CF vars. Hope that helps Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 8:44 AM Subject: Re: passing multiple CF vaules to a _javascript_ variable I'm placing the query results of several fields into an HTML list. The href of each generated link includes an onClick event. Because of that, I need to create a _javascript_ variable that holds the values of the style name field from the query. I don't know how to populate the style name variable for each list item. Thanks for your interest and your assistance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_getImage error! Don't know what's causing it
Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. Table CallComments_attachment doesn't exist in the database? Or it isn't owned by dbo? -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:52 AM To: CF-Talk Subject: Re: cfx_getImage error! Don't know what's causing it I changed the code a select statement a bit. I appended 'dbo.' before the table name. CFX_GETIMAGE DATASOURCE=db USER=dbUserName PASSWORD=dbPassword SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName# This was the error I was getting before I made the above change: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 And this is what I get now: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. pcbErrorMsg = 97 Notice the difference in the pcbErrorMsg value. Does that tell you anything? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PDF Report Generation from ColdFusion
People already responded to you.There are many custom tags out there to convert to PDF.I believe the macromedia exchance has html2pdf which will convert a page you output using CF to PDF. John Burns -Original Message- From: Ruben Ghosal [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:58 AM To: CF-Talk Subject: PDF Report Generation from ColdFusion I posted this message earlier. Does anybody know how to create a report in PDF format from an existing ColdFusion report? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access 2003 ODBC
- Original Message - From: Samuel R. Neff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 12, 2004 8:07 PM Subject: RE: Access 2003 ODBC Access 2000 is the last major release of the Jet engine, so the data portion of the database, what you're using through CF, is exactly the same for Access 2000 and Access 2003.There's no point in upgrading for just a data back-end. The Jet team was disbanded soon after Access 2000 was released, most of them going to the MSDE group.MS is interested in migrating everyone to MSDE/MSSQL and blindly ignoring the fact that you need a DBA to use these options. HTH, Thanks.That helps, but it's still not clear whether that means you can or cannot use an Access 2003 with the last version of the Jet engine. There's no reason to 'upgrade' to Access 2003, just that someone with Access 2003 installed on their workstations would probably find it more convenient to use Access 2003 on the server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
I've got my code in the first post of this thread. Based on the code you've written, it looks like I would get all the values in one onClick event. I need to generate one value per onClick. Each onClick is within an li that holds other query results, so I can't just loop through the stylename variable within one onClick. Am I making any sense? Thanks for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access 2003 ODBC
Thanks. That helps, but it's still not clear whether that means you can or cannot use an Access 2003 with the last version of the Jet engine. There's no reason to 'upgrade' to Access 2003, just that someone with Access 2003 installed on their workstations would probably find it more convenient to use Access 2003 on the server. There's no need to have any version of Access on the server. If you have the latest version of Jet on your server, it can read Access 2000 and 2003 files, without requiring any additional installation. Jet used to be bundled with MDAC, but it's now available separately (although you'll still want the latest version of MDAC too, typically): http://msdn.microsoft.com/data/downloads/updates/default.aspx#jet Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
At 09:35 AM 4/13/2004, you wrote: In that email, that you are sending to your self, you may also want to add a few CGI vars to see where and what is calling that cfm page.One time Google some how found a .cfm page that I had scheduler set to run once a week and every time Google spidered the site it would run that page. That's a damn fine idea. Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
where do you want to loop thru the style name? 1) when creating the html/js with CF/ 2) when the user initiates the js onClick? if 1) above, where what format is the list of styles? Dick On Apr 13, 2004, at 9:23 AM, Joy Holman wrote: I've got my code in the first post of this thread. Based on the code you've written, it looks like I would get all the values in one onClick event. I need to generate one value per onClick. Each onClick is within an li that holds other query results, so I can't just loop through the stylename variable within one onClick. Am I making any sense? Thanks for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web + v5.0
oddly enough I hadnt until I checked my mail today, I got a cd today to mario. someone must have gotten ahold of our addresses/titles/etc, and sent this out..i bet we arent the only ones on this list to have gotten their promo cd. I wonder who gave our info away??? tony -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:53 AM To: CF-Talk Subject: OT: Web + v5.0 Has anyone heard of this product:Web + v5.0 -- It is supposed to be easier to use and less expensive than CF. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX JRun Services on Windows 2000
Thanks again. I had tried the full display name, but I neglected the quotes before. -adam -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 04:04 PM To: 'CF-Talk' Subject: RE: CFMX JRun Services on Windows 2000 ok, now how can I get rid of the default 'cfusion' instance. When I try jrunsvc -remove cfusion, it says the specified service does nto exist. I think the default service name is Macromedia JRun CFusion Server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web + v5.0
not to mention the freakin thing uses #'s -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:34 PM To: CF-Talk Subject: RE: Web + v5.0 oddly enough I hadnt until I checked my mail today, I got a cd today to mario. someone must have gotten ahold of our addresses/titles/etc, and sent this out..i bet we arent the only ones on this list to have gotten their promo cd. I wonder who gave our info away??? tony -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:53 AM To: CF-Talk Subject: OT: Web + v5.0 Has anyone heard of this product:Web + v5.0 -- It is supposed to be easier to use and less expensive than CF. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Yes, I want to output the stylenames as the html code is generated. Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. Here's the code with the CF list. cfqueryname=q_menu datasource=mchfaq SELECT * from qa_menu order by menu_sortText /cfquery cfoutput cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)# script language=_javascript_ type=text/_javascript_ !-- function targetid(){ return #bmarklinkList#; } -- /script /cfoutput ul cfoutput query=q_menu liAHREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans /a/li /cfoutput /ul Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. I've substituted style name values where the js goes, like so: liA HREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans /a /li liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink#cfelse##Ans /a /li liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink# cfelse##Ans /li I'd really like this to work. I think I could use this code a lot. Thanks again. Joy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How many class files do YOU have?
Brook, Well I was curious about your question so i went ahead and took a look at how many class files we have.We also create cfm files on the fly for new accounts etc.On checking we have 25,759 class files in the cfclasses directory.All the suggestions below are accurate.Be sure to set your template cache as high as is reasonable with the memory you have.Also the jvm settings mentioned are very important.These things should all make a huge difference in your performance. Mark -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 12:25 PM To: CF-Talk Subject: How many class files do YOU have? I repoted to this list awhile ago about really long start up times for one of my apps on the first run. It seems that this problem has been resolved by defragging the HD? The C:\CFusionMX\wwwroot\WEB-INF\cfclasses folder had a lot of fragmented files as well as other areas on the HD. Does that make sense? Anyhow, I have 6,591 class files in my class folder taking up about 80 megs. So, I am curious now how many class files ya'll have on your servers? And another question related to disk usage; what are the guidelines for a paging file and is it needed if you have lots of physical ram? The reason I ask is because I wonder if a fragmented HD, and a page file on that disk might cause problems. I've had some JavaOutOfMemory errors, so I am looking for answers everywhere :) Brook _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
I didn't see any code and without it I'm afraid I'm not getting you.I can say that what I posted will work...it shows you the how to get the vars into JS...it's up to you to pass the correct vars based on your code (nested loops etc.) ;-) If you can re-post the code I'm sure the lights will come on ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 9:23 AM Subject: Re: passing multiple CF vaules to a _javascript_ variable I've got my code in the first post of this thread. Based on the code you've written, it looks like I would get all the values in one onClick event. I need to generate one value per onClick. Each onClick is within an li that holds other query results, so I can't just loop through the stylename variable within one onClick. Am I making any sense? Thanks for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web + v5.0
I have to say that I'm amazed every time I find one of these smaller web application servers/scripting languages.Don't we have enough?PLEASE? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:46 PM To: CF-Talk Subject: RE: Web + v5.0 not to mention the freakin thing uses #'s -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:34 PM To: CF-Talk Subject: RE: Web + v5.0 oddly enough I hadnt until I checked my mail today, I got a cd today to mario. someone must have gotten ahold of our addresses/titles/etc, and sent this out..i bet we arent the only ones on this list to have gotten their promo cd. I wonder who gave our info away??? tony -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:53 AM To: CF-Talk Subject: OT: Web + v5.0 Has anyone heard of this product:Web + v5.0 -- It is supposed to be easier to use and less expensive than CF. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
If you find that the page is being run by something other than CFSCHEDULE try something like this cfif left(http_user_agent,10) is not CFSCHEDULEcfabort/cfif Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:29 AM To: CF-Talk Subject: RE: MX: Scheduler firing off too often At 09:35 AM 4/13/2004, you wrote: In that email, that you are sending to your self, you may also want to add a few CGI vars to see where and what is calling that cfm page.One time Google some how found a .cfm page that I had scheduler set to run once a week and every time Google spidered the site it would run that page. That's a damn fine idea. Thanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
I finally figured out why I was getting the error. I went to the ODBC Administrator under Administrative Tools and re-configured the dsn. For some reason my database was not selected under the change the default database to section. I set it to db tested the connection successfully and it all works. Thank you all for your help. Best Regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
You use a SELECT * This is usually a bad habit as it makes the SQL engine do extra work degrades performance -- in this case, it also causes confusion.' What is the name of the column in the query that contains the style name? Dick On Apr 13, 2004, at 9:53 AM, Joy Holman wrote: Yes, I want to output the stylenames as the html code is generated. Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. Here's the code with the CF list. cfquery name=q_menu datasource=mchfaq SELECT * from qa_menu order by menu_sortText /cfquery cfoutput cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)# script language=_javascript_ type=text/_javascript_ !-- function targetid(){ return #bmarklinkList#; } -- /script /cfoutput ul cfoutput query=q_menu liA HREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans /a/li /cfoutput /ul Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. I've substituted style name values where the js goes, like so: liA HREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans /a /li liA HREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink#cfelse##Ans /a /li liA HREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink# cfelse##Ans /li I'd really like this to work. I think I could use this code a lot. Thanks again. Joy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Yes, I want to output the stylenames as the html code is generated. Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. Here's the code with the CF list. cfqueryname=q_menu datasource=mchfaq SELECT * from qa_menu order by menu_sortText /cfquery cfoutput cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)# script language=_javascript_ type=text/_javascript_ !-- function targetid(){ return #bmarklinkList#; } -- /script /cfoutput ul cfoutput query=q_menu liAHREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans /a/li /cfoutput /ul Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. I've substituted style name values where the js goes, like so: liA HREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans /a /li liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink#cfelse##Ans /a /li liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink# cfelse##Ans /li I'd really like this to work. I think I could use this code a lot. Thanks again. Joy I didn't see any code and without it I'm afraid I'm not getting you. I can say that what I posted will work...it shows you the how to get the vars into JS...it's up to you to pass the correct vars based on your code (nested loops etc.) ;-) If you can re-post the code I'm sure the lights will come on ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 9:23 AM Subject: Re: passing multiple CF vaules to a _javascript_ variable I've got my code in the first post of this thread. Based on the code you've written, it looks like I would get all the values in one onClick event. I need to generate one value per onClick. Each onClick is within an li that holds other query results, so I can't just loop through the stylename variable within one onClick. Am I making any sense? Thanks for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Yes, I want to output the stylenames as the html code is generated. Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. Here's the code with the CF list. cfqueryname=q_menu datasource=mchfaq SELECT * from qa_menu order by menu_sortText /cfquery cfoutput cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)# script language=_javascript_ type=text/_javascript_ !-- function targetid(){ return #bmarklinkList#; } -- /script /cfoutput ul cfoutput query=q_menu liAHREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans /a/li /cfoutput /ul Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. I've substituted style name values where the js goes, like so: liA HREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans /a /li liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink#cfelse##Ans /a /li liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink# cfelse##Ans /li Thanks. Joy where do you want to loop thru the style name? 1) when creating the html/js with CF/ 2) when the user initiates the js onClick? if 1) above, where what format is the list of styles? Dick On Apr 13, 2004, at 9:23 AM, Joy Holman wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web + v5.0
Tony Weeg wrote: I wonder who gave our info away??? Maybe if more of us had clicked on those ads in the cf-talk mails, Michael wouldn't have had to sell our info. :) Seriously, it's a good question. I can't imagine Macromedia would have. Is everyone who's received this Web+ CD subscribed to the CF Developer's Journal?I wouldn't put it past Sys-Con. Scott -- --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
I finally got it to work. I went to the ODBC section under Administrative Tools re-configured the settings explicting selecting my database under the change the default database to section of the DSN Configuration. I don't know why it didn't select it in the first place, but it don't matter now, it just works. Thank you all for your help cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
Have a different problem now, actually I have a question. If the user makes changes to the document, is it possible to save the changes directly back to the database when the user selects the File-Save option from the menu or ctrl-s. CFX_GETIMAGE DATASOURCE=db USER=dbUserName PASSWORD=dbPassword SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName# CFHEADER NAME=Content-Type VALUE=application/msexcel CFHEADER NAME=Content-Disposition VALUE=inline; filename=testDoc.xls CFCONTENT TYPE=application/msexcel FILE=E:\inetpub\wwwroot\testDocs.xls deletefile=Yes The above code loads the document in a browser. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
menu_bmarkLink is the name of the column in the query that contains the style name You use a SELECT * This is usually a bad habit as it makes the SQL engine do extra work degrades performance -- in this case, it also causes confusion.' What is the name of the column in the query that contains the style name? Dick On Apr 13, 2004, at 9:53 AM, Joy Holman wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
Have a different problem now, actually I have a question. If the user makes changes to the document, is it possible to save the changes directly back to the database when the user selects the File-Save option from the menu or ctrl-s. CFX_GETIMAGE DATASOURCE=db USER=dbUserName PASSWORD=dbPassword SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName# CFHEADER NAME=Content-Type VALUE=application/msexcel CFHEADER NAME=Content-Disposition VALUE=inline; filename=testDoc.xls CFCONTENT TYPE=application/msexcel FILE=E:\inetpub\wwwroot\testDocs.xls deletefile=Yes The above code opens the document in a new browser [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Null Pointer from CFQUERY
I am testing out an application that we want to migrate to CFMX (currently CF5).I am getting a NullPointerException from one of my queries when I use jConnect 5.5 (Sybase 12.5) instead of the Sybase driver that ships with CFMX.We want to use jConnect because all of our Java apps use that and we ran into other issues with the driver that ships with CFMX.Here is the query: CFQUERY NAME=NameTest DATASOURCE=jConn SELECT FirstNme FROM etrade..Bank WHERE BankId = 'WF' /CFQUERY As you can see, there are no variables in the query so the NullPointerException is not caused by an undefined var.The FROM clause is referencing a view that actually references another view in another database.We have other queries set up this same way that work fine under jConnect 5.5. The stacktrace just says: java.lang.NullPointerException no other information.Anyone have any ideas? Thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]