Re: [ACFUG Discuss] HostMySite observations?
Oh hey sorry I was out of pocket the last couple of days. The new VPS provider I'm using is kickassvps.com. I run a Windows VPS with CF and SQL Server there for roughly $100 a month compared to the $195 a month I paid for the same with HMS. On Fri, Feb 1, 2013 at 10:25 AM, Paul Morton pmor...@pmorton.com wrote: Dusty, And your new VPS provider is…..? Inquiring minds want to know! ** ** Paul Morton ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Friday, February 01, 2013 9:15 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] HostMySite observations? ** ** From total hosting stardom to complete has-been. I used to think they were the best thing since sliced bread but now they're just plain difficult to deal with and just not the same HostMySite that developers used to love. I use them only because I still have a few shared sites left there and I plan to move those eventually. I also had to move my Windows VPS and CF setup because they just suddenly discontinued the service on it and tried to force me to moving to their new cloud service at more than double the cost. We found another reliable VPS provider for almost half of the original cost of their VPS service they discontinued and the new provider we found has not only saved us a ton of money but they've done a far better job than HMS has done since they went downhill. Ironically I think about 1 year after killing my VPS service, they started offering it again but it's too late it was too much work to move it and the new provider is better and the cost is only half what I was paying HMS. Dusty ** ** On Fri, Feb 1, 2013 at 9:58 AM, Adam Churvis a...@productivityenhancement.com wrote: For those of you who have been hosting your or your clients' sites on HostMySite for a number of years, how would you describe their quality trend over time? ** ** Thanks in advance for your replies. ** ** Respectfully, ** ** Adam Churvis Productivity Enhancement ** ** -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law.
Re: [ACFUG Discuss] HostMySite observations?
And I've been completely happy with the service. I rarely ever need support because there is rarely any problems but when I do they're support has treated me well. On Sun, Feb 3, 2013 at 2:06 PM, Dusty Hale du...@dustyhale.com wrote: Oh hey sorry I was out of pocket the last couple of days. The new VPS provider I'm using is kickassvps.com. I run a Windows VPS with CF and SQL Server there for roughly $100 a month compared to the $195 a month I paid for the same with HMS. On Fri, Feb 1, 2013 at 10:25 AM, Paul Morton pmor...@pmorton.com wrote: Dusty, And your new VPS provider is…..? Inquiring minds want to know! ** ** Paul Morton ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Friday, February 01, 2013 9:15 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] HostMySite observations? ** ** From total hosting stardom to complete has-been. I used to think they were the best thing since sliced bread but now they're just plain difficult to deal with and just not the same HostMySite that developers used to love. I use them only because I still have a few shared sites left there and I plan to move those eventually. I also had to move my Windows VPS and CF setup because they just suddenly discontinued the service on it and tried to force me to moving to their new cloud service at more than double the cost. We found another reliable VPS provider for almost half of the original cost of their VPS service they discontinued and the new provider we found has not only saved us a ton of money but they've done a far better job than HMS has done since they went downhill. Ironically I think about 1 year after killing my VPS service, they started offering it again but it's too late it was too much work to move it and the new provider is better and the cost is only half what I was paying HMS. Dusty ** ** On Fri, Feb 1, 2013 at 9:58 AM, Adam Churvis a...@productivityenhancement.com wrote: For those of you who have been hosting your or your clients' sites on HostMySite for a number of years, how would you describe their quality trend over time? ** ** Thanks in advance for your replies. ** ** Respectfully, ** ** Adam Churvis Productivity Enhancement ** ** -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law. -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient
[ACFUG Discuss] Strange cfdocument issue. Wondered if anyone might be able to offer advice.
I'm having a strange issue with cfdocument in the Safari browser only. Everywhere else it works just as expected. I've used cfdocument to create a PDF download from an HTML document. It works perfect except in Safari it downloads the actual cfm document and file name instead of the created PDF. I'm googling and researching this issue now but if anyone has any helpful info they could pass along it would be greatly appreciated. As always thanks for listening :-) Dusty
Re: [ACFUG Discuss] running coldfusion apps on Mac
Hey I've been slammed and just now came back to this thread. I just glanced at the first few minutes of this clip. Funny. I can relate. I'm not going to leave ColdFusion though anytime soon :-). I'm now too deep in work to figure out the ins and outs of running it all on mac but I am at least using a mac and running it all on a fresh install of Win 7 using VMWare. I'm loving this new MacBook Retina and the 16gb of memory and solid state drive. I'll come back to the CF install on Mac soon though and thanks for all the info and help. Dusty On Wed, Nov 28, 2012 at 8:48 PM, Steve Ross nowhid...@gmail.com wrote: Setting up CF and the installer woes. On Wednesday, November 28, 2012, Charlie Arehart wrote: Steve, are you referring to the latter part of this thread (about Rick wanting off the list)? Or are you referring to the original discussion about running CF on Mac? Just curious. ** ** /charlie ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Steve Ross *Sent:* Wednesday, November 28, 2012 1:10 PM *To:* ACFUG ColdFusion Discussion *Subject:* Re: [ACFUG Discuss] running coldfusion apps on Mac ** ** This reminds me of a lot of the stuff in this: Dear ColdFusion - I'm breaking up with you. http://www.youtube.com/watch?v=I1KjX5NOD7c Not trolling nor trying to start a flame war and CF still pays the bills but, there are a lot of REALLY good points in it regardless of if you agree with the overall message. ** ** -Steve ** ** On Thu, Nov 22, 2012 at 8:28 PM, R Coe ric...@gmail.com wrote: yeah i didnt mean to hollar, I appreciate the information though, I love this ACFUG but when I signed up there were two different sites and I must have lost my way to this mailing list, Just need to change my settings, didnt realize this was going out to a user - please forgive me brother - happy thanksgiving , wish you the best - ** ** Rick C ** ** - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Steve Ross web application interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law.
Re: [ACFUG Discuss] running coldfusion apps on Mac
I do have the CFIDE mapped in the other sites too. CF seems to execute fine. I think this is a problem in IIS or something. This is what I'm actually running into now: Windows 7 Pro with IIS 7.5 1. CF and SQL successfully installed and datasources are set up and working. 2. As long as I use the default site in IIS everything things seems to work fine. Even if I point the site to a different folder other that default wwwroot folder, all is well. 3. If I add new site and point that to a different folder (like c:\websites\mysite) there are problems. For example I added a new CF site on a different port 88 and browse it with http://localhost:88. It pulls up the homepage inside the root folder just fine and it executes CF code. However, any other page inside of a subfolder generates a 404 error and in the error it displays the path to the default wwwroot folder (c:\Inetpub\wwwroot\subfoldername) instead of the actual path set up in the IIS site (c:\websites\mysite). For now I'm solving the issue by just changing the default website in IIS to point to the correct folder (c:\websites\mysite). However, now I'm stuck with only being able to run one site so hopefully I'll figure out a solution soon. Thanks for listening ;-) Dusty On Tue, Nov 20, 2012 at 4:48 PM, william beers bbe...@beersconsulting.comwrote: Just throwing out some ideas but you should have CFIDE mapped in the other sites as a virtual directory I think. That may help you execute cf pages on the non-default website. From: Dusty Hale du...@dustyhale.com Reply-To: discussion@acfug.org Date: Tuesday, November 20, 2012 4:51 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] running coldfusion apps on Mac Well I kind of abandoned the idea and today actually I installed CF 10 in the new Win 7 Pro Virtual Machine (vmware) I've set up. I added a new site in IIS and have configured that to work with CF and created an ODBC via CF admin for the site (it works). The problem I'm now running into is that sites in IIS don't seem to work correctly unless it's all in the default site and in the default wwwroot folder. The new IIS site I set up does work when I pull up the homepage. However, if I browse to any page located in a subfolder, I get a 404 error even though the page does exist and the in the 404 error it shows the physical path to the wwwroot folder even though the site was set up in IIS to point to c:\websites\mysite\ ... I've tried everything known to man and have been googling all day about it and still nothing. I'm totally stuck and frustrated. Now I'm thinking about going back to the idea of putting CF on the mac side but I'm confused if I should install a web server on the mac side or use the built in webserver in CF and I would really like to understand why I can't get sites on the IIS side to work unless they're in the default site and wwwroot folder. If anyone has any insight to that it would be most appreciated. Thanks, Dusty On Thu, Nov 15, 2012 at 12:02 PM, Steve Ross nowhid...@gmail.com wrote: http://www.virtualbox.org/manual/ch06.html#network_hostonly On Thu, Nov 15, 2012 at 1:00 PM, Steve Ross nowhid...@gmail.com wrote: Are you using Virtualbox? Sounds like you could use host only mode on the VM to do something like that but, I haven't ever used it. I just typically go into my /etc/hosts on my mac and change the IP if the windows vm's IP changes. On Tue, Nov 13, 2012 at 9:13 PM, Dusty Hale du...@dustyhale.com wrote: Steve thanks for the info. I'm familiar with configuring a hosts file on a Windows machine. I'm not sure if the IP on my VM is dynamically assigned or not so this is a concern. I seem to remember in the past hitting an IIS site on the VM from the mac side and always having to change the IP. If you have any other info about how to solve that problem, please share and if not I will google up something to try and resolve that. Are you saying I could configure the hosts file on the VM for this. If you have an example line from your hosts file that would be awesome :-) Thanks again, Dusty On Tue, Nov 13, 2012 at 7:28 PM, Steve Ross nowhid...@gmail.comwrote: Yup, That is my setup. Simply install CF and create a DSN to your VM. I typically like to add something to my /etc/hosts to point to sql server incase you dynamically assign an IP for your VM. So I have in my /etc/hosts a definition for sql.vm and point that at the IP for my VM's sql server instance. I like it better than creating a shared drive and creating a smb share. That always seems clunky. Also, apache will let you setup n vhosts so you can actually run apps without having to muck with creating a different context etc for the apps to run under. Hope that helps. On Tue, Nov 13, 2012 at 7:48 PM, Dusty Hale du...@dustyhale.comwrote: I'm loading up VMWare and Win 7 Pro on a new macbook and was planning to install CF and SQL Server on Win 7 virtual machine. However
Re: [ACFUG Discuss] running coldfusion apps on Mac
Hi Charlie: I just read your email. I think it accurately describes what is happening. I did run the server config tool yesterday but I didn't remove first. Today I've been focused on doing actual coding instead of the new installation but I'm about to jump over and play with it some more. I'll let you know what happens and thanks again for the advice :-) Dusty On Tue, Nov 20, 2012 at 10:01 PM, Charlie Arehart char...@carehart.orgwrote: Dusty, there are a few potential problems. First, are you saying that you installed CF10 telling it to connect to IIS during the installer, telling it to run with “all sites”? And then after that, did you load up the CF Admin with localhost or 127.0.0.1 (which worked), but now find that when you added a new IIS site, and are trying to browse pages there, it’s not working (except in the root)? In that case, the problem may not be so much “with CF10”, but rather due to a difference in IIS 7 (which also applied to 9.0.1). Only 9.0.1 and 10 are supported for IIS 7, unless one runs in IIS 6 compatibility mode (and to some other manual tweaks to get earlier releases to work.) And one of the differences of running CF 9.0.1 or 10 against IIS 7 in its native mode is that, even if you may tell it to configure “all sites”, it (IIS) no longer causes newly added sites to inherit all the settings set for the server. So as Mark said, you need to re-run the CF web server config tool whenever you add a site, to remove and re-add the option to connect “all sites”. It’s annoying, but again it’s not new in CF 10. It’s just that often people “moving to 10” are also “moving to Windows 7” or “moving to Windows 2008” for the first time, likely running a shiny new install of IIS 7, which (unless you change it) is running in native IIS 7 mode (versus IIS 6 Compat mode.) As such, they then experience this “difference” connecting CF to IIS 7. The need to do this reconfiguration on new sites is indeed documented in the CF 9.0.1 and 10 docs, and in the config tool, and the installer, but people often miss it (expecting that things work as they always have, and that the discussion is not something “new”, I think.) Here, also, is another gotcha: in Windows 7 and 2008, there’s also new security (better, but tighter and it gets in the way sometimes compared to old experience/expectations). I have seen many people who, even though their user “was a Windows administrator account” or “in the Admin group”, they still needed to choose manually to “run as administrator” when launching the CF web server config tool. If you use the GUI, right-click on it in StartAll ProgramsAdobeColdFusion xWed Server Configuration and choose “run as administrator”. If using the command line, do that same right-click trick when opening the command prompt. Let us know if any of that helps. /charlie ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Tuesday, November 20, 2012 4:51 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] running coldfusion apps on Mac ** ** Well I kind of abandoned the idea and today actually I installed CF 10 in the new Win 7 Pro Virtual Machine (vmware) I've set up. I added a new site in IIS and have configured that to work with CF and created an ODBC via CF admin for the site (it works). The problem I'm now running into is that sites in IIS don't seem to work correctly unless it's all in the default site and in the default wwwroot folder. The new IIS site I set up does work when I pull up the homepage. However, if I browse to any page located in a subfolder, I get a 404 error even though the page does exist and the in the 404 error it shows the physical path to the wwwroot folder even though the site was set up in IIS to point to c:\websites\mysite\ ... I've tried everything known to man and have been googling all day about it and still nothing. I'm totally stuck and frustrated. Now I'm thinking about going back to the idea of putting CF on the mac side but I'm confused if I should install a web server on the mac side or use the built in webserver in CF and I would really like to understand why I can't get sites on the IIS side to work unless they're in the default site and wwwroot folder. If anyone has any insight to that it would be most appreciated. ** ** Thanks, Dusty On Thu, Nov 15, 2012 at 12:02 PM, Steve Ross nowhid...@gmail.com wrote:* *** http://www.virtualbox.org/manual/ch06.html#network_hostonly ** ** ** ** On Thu, Nov 15, 2012 at 1:00 PM, Steve Ross nowhid...@gmail.com wrote:** ** Are you using Virtualbox? ** ** Sounds like you could use host only mode on the VM to do something like that but, I haven't ever used it. I just typically go into my /etc/hosts on my mac and change the IP if the windows vm's IP changes. ** ** ** ** On Tue, Nov 13, 2012 at 9:13 PM, Dusty Hale du...@dustyhale.com wrote
Re: [ACFUG Discuss] running coldfusion apps on Mac
Charlie: Yea I think that was it. I was running the tool yesterday when I started troubleshooting but I had also told CF to config all sites during the install and then when I tried running the tool yesterday I didn't removed things first. Today I tried again and removed all sites first then re-added. Now all the sites seem to work. Thanks again for your help and advice. Dusty On Wed, Nov 21, 2012 at 1:14 PM, Dusty Hale du...@dustyhale.com wrote: Hi Charlie: I just read your email. I think it accurately describes what is happening. I did run the server config tool yesterday but I didn't remove first. Today I've been focused on doing actual coding instead of the new installation but I'm about to jump over and play with it some more. I'll let you know what happens and thanks again for the advice :-) Dusty On Tue, Nov 20, 2012 at 10:01 PM, Charlie Arehart char...@carehart.orgwrote: Dusty, there are a few potential problems. First, are you saying that you installed CF10 telling it to connect to IIS during the installer, telling it to run with “all sites”? And then after that, did you load up the CF Admin with localhost or 127.0.0.1 (which worked), but now find that when you added a new IIS site, and are trying to browse pages there, it’s not working (except in the root)? In that case, the problem may not be so much “with CF10”, but rather due to a difference in IIS 7 (which also applied to 9.0.1). Only 9.0.1 and 10 are supported for IIS 7, unless one runs in IIS 6 compatibility mode (and to some other manual tweaks to get earlier releases to work.) And one of the differences of running CF 9.0.1 or 10 against IIS 7 in its native mode is that, even if you may tell it to configure “all sites”, it (IIS) no longer causes newly added sites to inherit all the settings set for the server. So as Mark said, you need to re-run the CF web server config tool whenever you add a site, to remove and re-add the option to connect “all sites”. It’s annoying, but again it’s not new in CF 10. It’s just that often people “moving to 10” are also “moving to Windows 7” or “moving to Windows 2008” for the first time, likely running a shiny new install of IIS 7, which (unless you change it) is running in native IIS 7 mode (versus IIS 6 Compat mode.) As such, they then experience this “difference” connecting CF to IIS 7. The need to do this reconfiguration on new sites is indeed documented in the CF 9.0.1 and 10 docs, and in the config tool, and the installer, but people often miss it (expecting that things work as they always have, and that the discussion is not something “new”, I think.) Here, also, is another gotcha: in Windows 7 and 2008, there’s also new security (better, but tighter and it gets in the way sometimes compared to old experience/expectations). I have seen many people who, even though their user “was a Windows administrator account” or “in the Admin group”, they still needed to choose manually to “run as administrator” when launching the CF web server config tool. If you use the GUI, right-click on it in StartAll ProgramsAdobeColdFusion xWed Server Configuration and choose “run as administrator”. If using the command line, do that same right-click trick when opening the command prompt. Let us know if any of that helps. /charlie ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Tuesday, November 20, 2012 4:51 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] running coldfusion apps on Mac ** ** Well I kind of abandoned the idea and today actually I installed CF 10 in the new Win 7 Pro Virtual Machine (vmware) I've set up. I added a new site in IIS and have configured that to work with CF and created an ODBC via CF admin for the site (it works). The problem I'm now running into is that sites in IIS don't seem to work correctly unless it's all in the default site and in the default wwwroot folder. The new IIS site I set up does work when I pull up the homepage. However, if I browse to any page located in a subfolder, I get a 404 error even though the page does exist and the in the 404 error it shows the physical path to the wwwroot folder even though the site was set up in IIS to point to c:\websites\mysite\ ... I've tried everything known to man and have been googling all day about it and still nothing. I'm totally stuck and frustrated. Now I'm thinking about going back to the idea of putting CF on the mac side but I'm confused if I should install a web server on the mac side or use the built in webserver in CF and I would really like to understand why I can't get sites on the IIS side to work unless they're in the default site and wwwroot folder. If anyone has any insight to that it would be most appreciated. ** ** Thanks, Dusty On Thu, Nov 15, 2012 at 12:02 PM, Steve Ross nowhid...@gmail.com wrote: http://www.virtualbox.org/manual/ch06.html
Re: [ACFUG Discuss] running coldfusion apps on Mac
Well I kind of abandoned the idea and today actually I installed CF 10 in the new Win 7 Pro Virtual Machine (vmware) I've set up. I added a new site in IIS and have configured that to work with CF and created an ODBC via CF admin for the site (it works). The problem I'm now running into is that sites in IIS don't seem to work correctly unless it's all in the default site and in the default wwwroot folder. The new IIS site I set up does work when I pull up the homepage. However, if I browse to any page located in a subfolder, I get a 404 error even though the page does exist and the in the 404 error it shows the physical path to the wwwroot folder even though the site was set up in IIS to point to c:\websites\mysite\ ... I've tried everything known to man and have been googling all day about it and still nothing. I'm totally stuck and frustrated. Now I'm thinking about going back to the idea of putting CF on the mac side but I'm confused if I should install a web server on the mac side or use the built in webserver in CF and I would really like to understand why I can't get sites on the IIS side to work unless they're in the default site and wwwroot folder. If anyone has any insight to that it would be most appreciated. Thanks, Dusty On Thu, Nov 15, 2012 at 12:02 PM, Steve Ross nowhid...@gmail.com wrote: http://www.virtualbox.org/manual/ch06.html#network_hostonly On Thu, Nov 15, 2012 at 1:00 PM, Steve Ross nowhid...@gmail.com wrote: Are you using Virtualbox? Sounds like you could use host only mode on the VM to do something like that but, I haven't ever used it. I just typically go into my /etc/hosts on my mac and change the IP if the windows vm's IP changes. On Tue, Nov 13, 2012 at 9:13 PM, Dusty Hale du...@dustyhale.com wrote: Steve thanks for the info. I'm familiar with configuring a hosts file on a Windows machine. I'm not sure if the IP on my VM is dynamically assigned or not so this is a concern. I seem to remember in the past hitting an IIS site on the VM from the mac side and always having to change the IP. If you have any other info about how to solve that problem, please share and if not I will google up something to try and resolve that. Are you saying I could configure the hosts file on the VM for this. If you have an example line from your hosts file that would be awesome :-) Thanks again, Dusty On Tue, Nov 13, 2012 at 7:28 PM, Steve Ross nowhid...@gmail.com wrote: Yup, That is my setup. Simply install CF and create a DSN to your VM. I typically like to add something to my /etc/hosts to point to sql server incase you dynamically assign an IP for your VM. So I have in my /etc/hosts a definition for sql.vm and point that at the IP for my VM's sql server instance. I like it better than creating a shared drive and creating a smb share. That always seems clunky. Also, apache will let you setup n vhosts so you can actually run apps without having to muck with creating a different context etc for the apps to run under. Hope that helps. On Tue, Nov 13, 2012 at 7:48 PM, Dusty Hale du...@dustyhale.comwrote: I'm loading up VMWare and Win 7 Pro on a new macbook and was planning to install CF and SQL Server on Win 7 virtual machine. However, this is just a thought and I'm curious if anyone has ever run a CF server on the Mac side but use an SQL Server database that would reside on the Win 7 virtual machine. I'm sure this is probably possible but is it a good idea or does anyone have any thought about this? -Dusty -- Steve Ross web application interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law. -- Steve Ross web application interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] -- Steve Ross web application interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding
[ACFUG Discuss] running coldfusion apps on Mac
I'm loading up VMWare and Win 7 Pro on a new macbook and was planning to install CF and SQL Server on Win 7 virtual machine. However, this is just a thought and I'm curious if anyone has ever run a CF server on the Mac side but use an SQL Server database that would reside on the Win 7 virtual machine. I'm sure this is probably possible but is it a good idea or does anyone have any thought about this? -Dusty
Re: [ACFUG Discuss] running coldfusion apps on Mac
Steve thanks for the info. I'm familiar with configuring a hosts file on a Windows machine. I'm not sure if the IP on my VM is dynamically assigned or not so this is a concern. I seem to remember in the past hitting an IIS site on the VM from the mac side and always having to change the IP. If you have any other info about how to solve that problem, please share and if not I will google up something to try and resolve that. Are you saying I could configure the hosts file on the VM for this. If you have an example line from your hosts file that would be awesome :-) Thanks again, Dusty On Tue, Nov 13, 2012 at 7:28 PM, Steve Ross nowhid...@gmail.com wrote: Yup, That is my setup. Simply install CF and create a DSN to your VM. I typically like to add something to my /etc/hosts to point to sql server incase you dynamically assign an IP for your VM. So I have in my /etc/hosts a definition for sql.vm and point that at the IP for my VM's sql server instance. I like it better than creating a shared drive and creating a smb share. That always seems clunky. Also, apache will let you setup n vhosts so you can actually run apps without having to muck with creating a different context etc for the apps to run under. Hope that helps. On Tue, Nov 13, 2012 at 7:48 PM, Dusty Hale du...@dustyhale.com wrote: I'm loading up VMWare and Win 7 Pro on a new macbook and was planning to install CF and SQL Server on Win 7 virtual machine. However, this is just a thought and I'm curious if anyone has ever run a CF server on the Mac side but use an SQL Server database that would reside on the Win 7 virtual machine. I'm sure this is probably possible but is it a good idea or does anyone have any thought about this? -Dusty -- Steve Ross web application interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law.
Re: [ACFUG Discuss] How would you feel about doing a contract job in Costa Rica
Charlie is correct. San Jose has both the nice and the very very gnarly. I don't go to San Jose very often and I fly in and out of Liberia actually which is an hour North of Tamarindo. I do go to San Jose occasionally though for shopping and I stay in the nicer areas like Escazu which is near the only Apple store in Costa Rica ;-) ... Life in Tamarindo is much different than San Jose and yes as Charlie says that's why I don't live near the big city. Tamarindo is 4 hours North of San Jose and centrally located to numerous amazing and famous beaches like Playa Flamingo, Playa Grande (turtle reserve), Playa Avellanas, and Playa Negra. The town itself is rustic and full of wonderful people and culture. They nickname the town TamaGringo because most of the businesses there are owned by Americans and other foreigners. Everyone speaks english so there is no need to know spanish beyond a few basic words. There is very little violent crime and no vandalism that I have ever seen. However burglaries can and do happen but certainly not any worse than anywhere I've lived in Atlanta. I live in an apartment with gates much the same way I lived in Atlanta except that it's warm all year and the apartment is a few steps away from the beach :-). Internet access and 3g cell phone service are good but there is a little more than normal downtime as compared to US. It's not bad though. Once every couple of months they'll announce an organized power outage which usually is during the week for several hours and all the local ex-pat online workers (mostly SEO's and Blogger types) meet at the local Subway Sandwich shop to work on projects and use their power generators. It's kind of cool actually to see all the faces there of online workers that have transformed their lives into an adventure. There are also two amazing private schools in Playa Flaming and my daughter will be attending one of them in Fall of 2013. Both schools are are owned by Americans and have an American curriculum with a bilingual focus. Dusty On Tue, Oct 30, 2012 at 10:15 PM, Charlie Arehart char...@carehart.orgwrote: Wow, wouldn’t that be funny, indeed, if we might have hooked up there and yet have not been able to for a while here in Atlanta. Indeed, when was the last time you got down to a meeting, for everyone to enjoy your company? :-) Anyway, enjoy the trip and the country. Just be prepared: it’s not all rainforest, beach, and nature’s beauty. The San Jose city and suburbs have more a feel of South Central LA, with nearly all houses (the nice and the gnarly) having not only bars on their windows, but iron fences several feet high surrounding them, then topped with barbed wire and/or concertina wire. I just can’t imagine living in an environment where you have that sort of constant fear of burglary, vandalism, or worse. But again though, the people and nature are indeed wonderful. I’m sure Dusty (and others) would say “and that’s why I don’t live in or near the big city”. Still, just be aware of that distinction (and oh, there’s the traffic in the city and suburbs, too!) ** ** /charlie ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Erika L. Rich *Sent:* Tuesday, October 30, 2012 9:33 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] How would you feel about doing a contract job in Costa Rica ** ** Charlie! That's incredible. We are going to just miss each other! Charles and I will be there for 3 weeks from mid-November. That would have been pretty funny if we managed to hook up in Costa Rica, but yet haven't been able to make it down there again to see you guys in Alpharetta. :) We are looking forward to Costa Rica and it will be a research trip to scope out great places to live (part-time) and work. I hear many great things about the country and I am sure we will enjoy ourselves immensely. Cheers, Erika ** ** - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com -
[ACFUG Discuss] How would you feel about doing a contract job in Costa Rica
Dear ACFUG members: First, I'm posting this to discussion because this is not yet a job offering but something I want to discuss and get a feel for. It's been a while since I've used this list so I hope it reaches all of you. It's been even longer since I lived in Atlanta. Six years ago I relocated from Atlanta to the very famous small surf and beach town in Costa Rica known as Tamarindo. This is the same town as seen in one of the most famous surf movies of all time Endless Summer (Endless Summer II actually). I've been working remotely from this amazing place for 6 years now and I love it so much and it has taught me many new things about life. For starters I was always a surfer. I grew up surfing in Florida so relocating to Costa Rica was much like getting back to my roots and surf life. I also learned how to speak Spanish and live simple and greatly reduced my cost of living and need to acquire assets I don't really need or use (fancy cars, fancy cloths, fancy lifestyle) and refocused my life on the things that matter all while maintaining my web developer career largely based on my ColdFusion and SQL Server knowledge. Free time, family, friends, the beach, surfing community, etc are all things that mean the world to me. So about now you're asking yourself: Why is this guy emailing acfug about this? Well you see, life has just presented a new opportunity to me and several people who I will hire on a contract basis. In the past three years I have developed solutions for a particular client that sells medical information subscriptions and the data is stored in SQL Server and delivered through ColdFusion apps (and some .NET ugg!). The projects were very successful and I now have a budget to actually open a new office and hire a small devoted team of 3 to 5 people. The team would be comprised of a Project Manager (me), a graphic and layout designer, an interface coding guru (html5, css4, jQuery, etc), and one or two application developers (CF, SQL, jQuery, AJAX). The best part is that the office will be in Downtown Tamarindo, Costa Rica in one of the best buildings in town and centrally located to everything. This is on the Northern Pacific Side with amazing nature, beaches, culture, surfing waves, ocean fishing, volcanoes, rock climbing, white water rafting, monkeys, iguanas, and all kinds of other things that make it such an amazing place. Tamarindo also has an amazing community full of culture, restaurants, night clubs, and tour companies all centered in a town where you don't need a car (walk or bike will do). So I thought I would start this adventure today by putting this little feeler email out and ask the acfug community members about how you would feel about taking a 1 year contract position (option to renew would be possible if we have successful launches) which may pay a little less but provide an amazing experience in an amazing place. For example, I would be looking for several top notch developers but I would only be able to pay a basic salary of around 35K with a little relocation help and I realize that is not great pay for a senior developer. However the tradeoff is in the experience of getting to live and work in Costa Rica. There are no special visa requirements because we will not be doing business in Costa Rica. The work we will do are all for a US based client so we'd pretty much be working from a private office with a work hard and play hard philosophy. The work schedule may very well be based around the local Tide Charts and surf reports :-) and surfing would be highly encouraged. How would you feel about this situation? If there's nothing tying you down, would ya do it? Yes, No, Maybe? Any thought? Be sure to Google Tamarindo Costa Rica and check out some sites and photos of this beautiful place. Thanks for listening! And as we say in CR: Pura Vida, -- Dusty Hale Email: du...@dustyhale.com Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law.
Re: [ACFUG Discuss] How would you feel about doing a contract job in Costa Rica
I'll keep this list posted as this evolves and assuming this plays out the way it appear to be playing out, we would be looking to put a team together by early to mid January. Thanks again for listening :-) ... my heart warms just thinking about it. Dusty On Tue, Oct 30, 2012 at 5:10 PM, Wes Byrd w...@dynapp.com wrote: “surfer” even. lol ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Wes Byrd *Sent:* Tuesday, October 30, 2012 5:03 PM *To:* discussion@acfug.org *Subject:* RE: [ACFUG Discuss] How would you feel about doing a contract job in Costa Rica ** ** This sounds right up Charlie Earhart’s alley. He seems like a cool hip server kinda guy. ;-P ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Tuesday, October 30, 2012 4:29 PM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] How would you feel about doing a contract job in Costa Rica ** ** Dear ACFUG members: ** ** First, I'm posting this to discussion because this is not yet a job offering but something I want to discuss and get a feel for. ** ** It's been a while since I've used this list so I hope it reaches all of you. It's been even longer since I lived in Atlanta. Six years ago I relocated from Atlanta to the very famous small surf and beach town in Costa Rica known as Tamarindo. This is the same town as seen in one of the most famous surf movies of all time Endless Summer (Endless Summer II actually). I've been working remotely from this amazing place for 6 years now and I love it so much and it has taught me many new things about life. For starters I was always a surfer. I grew up surfing in Florida so relocating to Costa Rica was much like getting back to my roots and surf life. I also learned how to speak Spanish and live simple and greatly reduced my cost of living and need to acquire assets I don't really need or use (fancy cars, fancy cloths, fancy lifestyle) and refocused my life on the things that matter all while maintaining my web developer career largely based on my ColdFusion and SQL Server knowledge. Free time, family, friends, the beach, surfing community, etc are all things that mean the world to me. ** ** So about now you're asking yourself: Why is this guy emailing acfug about this? Well you see, life has just presented a new opportunity to me and several people who I will hire on a contract basis. In the past three years I have developed solutions for a particular client that sells medical information subscriptions and the data is stored in SQL Server and delivered through ColdFusion apps (and some .NET ugg!). The projects were very successful and I now have a budget to actually open a new office and hire a small devoted team of 3 to 5 people. The team would be comprised of a Project Manager (me), a graphic and layout designer, an interface coding guru (html5, css4, jQuery, etc), and one or two application developers (CF, SQL, jQuery, AJAX). The best part is that the office will be in Downtown Tamarindo, Costa Rica in one of the best buildings in town and centrally located to everything. This is on the Northern Pacific Side with amazing nature, beaches, culture, surfing waves, ocean fishing, volcanoes, rock climbing, white water rafting, monkeys, iguanas, and all kinds of other things that make it such an amazing place. Tamarindo also has an amazing community full of culture, restaurants, night clubs, and tour companies all centered in a town where you don't need a car (walk or bike will do).* *** ** ** So I thought I would start this adventure today by putting this little feeler email out and ask the acfug community members about how you would feel about taking a 1 year contract position (option to renew would be possible if we have successful launches) which may pay a little less but provide an amazing experience in an amazing place. For example, I would be looking for several top notch developers but I would only be able to pay a basic salary of around 35K with a little relocation help and I realize that is not great pay for a senior developer. However the tradeoff is in the experience of getting to live and work in Costa Rica. There are no special visa requirements because we will not be doing business in Costa Rica. The work we will do are all for a US based client so we'd pretty much be working from a private office with a work hard and play hard philosophy. The work schedule may very well be based around the local Tide Charts and surf reports :-) and surfing would be highly encouraged. ** ** How would you feel about this situation? If there's nothing tying you down, would ya do it? Yes, No, Maybe? Any thought? Be sure to Google Tamarindo Costa Rica and check out some sites and photos of this beautiful place. ** ** Thanks for listening! And as we say in CR: ** ** Pura Vida
[ACFUG Discuss] testing list email please respond
I can't seem to get an email to disscus...@acfug.org. If you receive this please reply. I get messages from the list just can't seem to get on to the list. Thanks, Dusty
Re: [ACFUG Discuss] testing list email please respond
Thanks. Seems to work now. I'm not sure why I couldn't get my other messages through. Dusty On Tue, Sep 18, 2012 at 4:02 PM, Troy Jones t...@dynapp.com wrote: Received ** ** Troy Jones ** ** [image: da_logo_70x263]* ** ___ ** * *Troy Jones* | Director of Technical Services | Dynapp Inc | 1-800-830-5192 ext. 603 | dynapp.com http://www.dynapp.com/ | facebook.com/dynapp http://www.facebook.com/dynapp ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Tuesday, September 18, 2012 6:02 PM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] testing list email please respond ** ** I can't seem to get an email to disscus...@acfug.org. If you receive this please reply. I get messages from the list just can't seem to get on to the list. Thanks, Dusty ** ** - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Phone (Costa Rica): +011.506.8693.3823 Skype: dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law. image001.jpg
[ACFUG Discuss] cfwindow - how to change the grey border in the header?
Does anyone know how to change the grey curvy border in the headerStyle of a cfwindow? Changing the border for the body using CSS is no problem but when when I add CSS for the border in the headerStyle attribute it does nothing. I'm able to change the background color of the header no problem but it looks really funny with the default grey curvy border. I'm trying to get it to match the border color I set for the bodyStyle attribute. Thanks in advance for any help or advice!! Dusty
[ACFUG Discuss] hostmysite.com ... hosting.com
I've been using a CF+ VPS server at hostmysite for years now and all has been well. However just got an email yesterday that they are terminating VPS services with the option to stay on at only triple the price haha ... So time to move on of course. Does anyone have thoughts on a good VPS or similar dedicated type solution for CF. I really need a Windows server (that's what I know), CF, and SQL Server, etc. I've never had to do a big migration like this so the only way I know how at the moment is to move all the sites and database over one by one. Ouch!!! I've been looking into kickassvps.com. If anyone has any thought to share it would be much appreciated. Thanks for listening :) Dusty
Re: [ACFUG Discuss] Old CF Studio Record Viewer Wizard
I can't say that I exactly remember how to use those files. I'm wonder if I can download the ol CF studio somewhere? I can't really seem to find it so far. On Tue, Dec 14, 2010 at 11:27 PM, Forrest C Gilmore fcg0...@wctel.netwrote: To refresh my memory, I did a little digging in the folders on my PC. It turns out that the Record Viewer Wizard code is associated with Homesite. There is one VTW file and three WIZML files that make up the Viewer code. Can you make use of these files? Forrest C. Gilmore == On 12/14/2010 5:18 PM, Dusty Hale wrote: Does anyone know if there is some kind of tool anywhere that resembles the old CF Studio record viewer wizard? This was a tool that would spit out an add/edit/delete system for a single database table. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com
[ACFUG Discuss] Old CF Studio Record Viewer Wizard
Does anyone know if there is some kind of tool anywhere that resembles the old CF Studio record viewer wizard? This was a tool that would spit out an add/edit/delete system for a single database table.
[ACFUG Discuss] xmlrpc.cfc xmlrpc2coldfusion method
I'm using xmlrpc.cfc to to transform an xml-rpc packet into a coldfusion struct. It seems simple enough but it's spitting back a structure that hold an array which holds a structure of structures. In this case I'm trying to capture and retain the value of id (see attached image with screenshot of a cfdump). I can't seem to remember how to reference this variable being it's buried within a struct holding an array holding a struct of struct. At least I think that's what the cfdump is telling me. Could someone take a quick peak at this image and tell me how I would reference id. attachment: cfdump.gif
Re: [ACFUG Discuss] xmlrpc.cfc xmlrpc2coldfusion method
Thanks Steve. I'm having a blonde moment :) ... On Thu, Dec 9, 2010 at 8:40 PM, Steve Ross nowhid...@gmail.com wrote: Struct.params[1].login.session.id Steve Ross 912.344.8113 On Dec 9, 2010, at 8:23 PM, Dusty Hale du...@climbonline.com du...@climbonline.com wrote: I'm using xmlrpc.cfc to to transform an xml-rpc packet into a coldfusion struct. It seems simple enough but it's spitting back a structure that hold an array which holds a structure of structures. In this case I'm trying to capture and retain the value of id (see attached image with screenshot of a cfdump). I can't seem to remember how to reference this variable being it's buried within a struct holding an array holding a struct of struct. At least I think that's what the cfdump is telling me. Could someone take a quick peak at this image and tell me how I would reference id. cfdump.gif -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com
Re: [ACFUG Discuss] bizarre issue with output from cfquery
There is one Cold Fusion datasource that points to a system datasource that uses the MS text file driver. It allows me to query any of the csv files I have in a folder. For example: cfquery name=myname datasource=mydata select phone, fax from [pathToFolder]\[filname].csv /cfquery Then as a test scenario I output as follows: cfloop query=myname pPhone: cfif len(phone)#phone#cfelse[empty]/cfif br /Fax: cfif len(fax)#fax#cfelse[empty]/cfif/p /cfloop There's no problems with HTML. Also to confirm, you don't have to define a datasource to one file. You can set up a datasource in CF that points to a machine user datasource to an entire folder and then query multiple files. I query the files individually though (no joins). For the most part it works great. So last night I emptied the file in question and started add the data back line by line (it only has 25 records/lines). I inspected the data manually and see nothing wrong with it. Correct number of commas. No escape character problems, etc. When adding data back I get really bizzare behavior. For example, the first few records output fine as long as the phone number in the first record DOES contain dashes (even though other below it don't), however REMOVE the dashes from the phone number in the first record and then suddenly all phone numbers with dashes (in other records) output empty. Then it gets more bizzarre because I'm adding the data to the file line by line trying to find something strange about the data itself and once I add line 5 of the data back, the empty phone string starts happening again. Yet inspecting the data, I really find absolutely nothing wrong. I've also notice that if I add any non numeric character to a phone number, it also outputs empty. Ironically, table1 (another csv file) which is identical in structure, does not have this problem (it has different but similar data in it). I also realized that file1 also has this problem but I wasn't catching it because there was only one phone number in the data that contained dashes and it also outputs empty. I've concluded that somehow it will not output the phone or fax field unless it contains a int type data (number). Adding any non-numeric character to the phone or fax will cause it to output empty. Yet I'm using text files and there is no way to configure data types that I'm aware of. On Wed, Sep 8, 2010 at 4:33 AM, Charlie Arehart char...@carehart.orgwrote: I’m curious about a couple of things: - you refer to “two tables(files) in the tdatabase”, but being CSV files, there is no “database”, right? Do you mean in “the datasource”? If so, why/how would you have two CSV files defined in one datasource? Does anything change if you create two DSNs, one for each file? Or if you flip the order of their definition in the one datasource (or database)? That’s just a wild guess. The bigger questions are the two. - when you say things “are outputting” funky, are you outputting them as HTML? Have you looked at the underlying HTML source (in the browser)? Maybe the data is there, but something else is causing them to appear to be “empty”. I’ve seen it happen. As an alternative to doing “view source” all the time, you can also use HTMLCodeFormat in CFML for the output you’re generating, to show the resulting HTML on screen as the tags that would be built , rather than seeing the result of the HTML being rendered on screen. Not much, but hope that helps. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Tuesday, September 07, 2010 9:42 PM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] bizarre issue with output from cfquery Has anyone ever experienced anything like this: 1. I have an ODBC datasource set up to query comma delimited text files. Works great except 2. I have two tables(files) in the tdatabase and both are identical in structure and both have a phone number field. In both tables some of the phone numbers contain dashes and some don't. 3. When I query table one and test the output, no problem, works great. When I query table two, also works fine except one very bizarre thing. The phone numbers with dashes are outputting as empty or null. Phone numbers that don't have dashes output as normal. So I've been struggling with this issue and don't see how it's possible being that both table are identical in structure. Since they're not identical in data, I assume it has to be something data related but still can find nothing wrong. Does anyone have any experience with CF and using text files as a database and had a problem like this. Any thought or advice is greatly appreciated. Kind regards, Dusty -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com - To unsubscribe from this list
[ACFUG Discuss] bizarre issue with output from cfquery
Has anyone ever experienced anything like this: 1. I have an ODBC datasource set up to query comma delimited text files. Works great except 2. I have two tables(files) in the tdatabase and both are identical in structure and both have a phone number field. In both tables some of the phone numbers contain dashes and some don't. 3. When I query table one and test the output, no problem, works great. When I query table two, also works fine except one very bizarre thing. The phone numbers with dashes are outputting as empty or null. Phone numbers that don't have dashes output as normal. So I've been struggling with this issue and don't see how it's possible being that both table are identical in structure. Since they're not identical in data, I assume it has to be something data related but still can find nothing wrong. Does anyone have any experience with CF and using text files as a database and had a problem like this. Any thought or advice is greatly appreciated. Kind regards, Dusty
Re: [ACFUG Discuss] disappearing variable values
Yes that was it. For a test I removed the application.cfm file and then that corrected the problem so then I went through the application.cfm and see there was also cfparam name=url.donorid default= in the application.cfm file. So obviously the first tag was canceling out the second. Thanks Charlie. That should have been obvious to me. I thought too much into this and look right passed the obvious. Dusty On Wed, Jul 14, 2010 at 11:10 AM, Charlie Arehart char...@carehart.orgwrote: Yep, that’s indeed a possible cause. To be clear, this is why my last point asserted that a test should involve confirming that no application.cfm code was influencing things. There can be lots of possible explanations. Once that proved it was the problem, it would be more obvious then that he’d need to look at the application.cfm/cfc that was influencing things. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Steve Ross *Sent:* Wednesday, July 14, 2010 10:51 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] disappearing variable values You aren't doing any variable scope copying in your app.cfm are you? Sometimes people choose to make their form vars and their url vars combined so they only have to check one... just a thought. On Wed, Jul 14, 2010 at 10:47 AM, Charlie Arehart char...@carehart.org wrote: Dusty, I really can’t see “donorid” being something the CF would have a problem with. :-) Let’s see if we can get to the bottom of this. First, to be clear, I tested it on CF8 (8.0.1) and did not experience it. Let’s confirm: are you on 8 or 8.0.1, just in case that may make a difference. But I suspect it’s something else. Second, are you saying that if you run the code right now (on your server), you still have the problem? Third, how about this: if you drop it into a new template that has no code other than this, does it still happen? Finally, if you put that file into a new directory with a blank application.cfm (so that you’re not inheriting any other), does it still happen? As I tell people all the time when they bring me in to consult on solving CF troubleshooting problems (big or small), there is always an explanation—it just isn’t always what it seems at first. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Wednesday, July 14, 2010 2:02 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] disappearing variable values I've had a similar thing with url variable: cfparam name=url.myvariable default=The Sky is Blue cfparam name=url.donorid default=Roses Are Red pThe value of url.myvariable is: cfoutput#url.myvariable#/cfoutput/p pThe value of url.donorid is: cfoutput#url.donorid#/cfoutput/p cfif url.donorid is pIt's Empty/p/cfif cfabort For some reason url.donorid always disappears unless there is an actual passed variable in the url. However, in theory the cfparam tag should set the default if none in the url. But no. It comes out an empty string. Here's the really strange thing because it seems to be just the variable name donorid and if I change the name then no problem. I'm on CF8 and this little quirk drove me nuts in an application trying to figure out why. On Tue, Jun 22, 2010 at 5:23 PM, Troy Jones t...@dynapp.com wrote: I am having a perplexing issue. Has anyone ever had an instance where it seemed as if a variable just “poofs” into thin air? For example, when I run the following code: cfdump var=#attributes# cfdump var=#pageID# cfdump var=#thisPage# cfset testVar = thisPage.form_id cfoutputthisPage.form_id = #testVar#/cfoutput cfif attributes.mode is do cfset thisForm = application.com.lib.getData(vformfields,form_id = #testVar#,field_sortorder) The variable “testVar” exists up until the setting of “thisForm” which I’ve verified with the cfdumps. At that point, when #testVar# is called, it is passing a NULL value to the SQL statement and throwing an error. I’ve tried recreating the error with a standard cfquery tag just to see if something was getting jacked up in the function call, but it had the same result. It’s as if the value just ran away and left. I’ve never seen anything quite like it and have run out of tails to chase, so to speak. This is on CF9 Enterprise, for anyone who needs it and any help would be greatly appreciated. Troy Jones - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta
Re: [ACFUG Discuss] disappearing variable values
I've had a similar thing with url variable: cfparam name=url.myvariable default=The Sky is Blue cfparam name=url.donorid default=Roses Are Red pThe value of url.myvariable is: cfoutput#url.myvariable#/cfoutput/p pThe value of url.donorid is: cfoutput#url.donorid#/cfoutput/p cfif url.donorid is pIt's Empty/p/cfif cfabort For some reason url.donorid always disappears unless there is an actual passed variable in the url. However, in theory the cfparam tag should set the default if none in the url. But no. It comes out an empty string. Here's the really strange thing because it seems to be just the variable name donorid and if I change the name then no problem. I'm on CF8 and this little quirk drove me nuts in an application trying to figure out why. On Tue, Jun 22, 2010 at 5:23 PM, Troy Jones t...@dynapp.com wrote: I am having a perplexing issue. Has anyone ever had an instance where it seemed as if a variable just “ poofs” into thin air? For example, when I run the following code: cfdump var=#attributes# cfdump var=#pageID# cfdump var=#thisPage# cfset testVar = thisPage.form_id cfoutputthisPage.form_id = #testVar#/cfoutput cfif attributes.mode is do cfset thisForm = application.com.lib.getData(vformfields,form_id= # testVar#,field_sortorder) The variable “testVar” exists up until the setting of “thisForm” which I’ve verified with the cfdumps. At that point, when #testVar# is called, it is passing a NULL value to the SQL statement and throwing an error. I’ve tried recreating the error with a standard cfquery tag just to see if something was getting jacked up in the function call, but it had the same result. It’s as if the value just ran away and left. I’ve never seen anything quite like it and have run out of tails to chase, so to speak. This is on CF9 Enterprise, for anyone who needs it and any help would be greatly appreciated. Troy Jones - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com
Re: [ACFUG Discuss] disappearing variable values
LOL yea this is rather strange and in theory I agree donorid should not be the cause but if I do change the name, the problem is gone. Of course it's one of those no big deal things because I can easily work around the problem but it leaves me with much curiosity :) Here's the output I get (right now): -- CF Version: 8,0,1,195765 The value of url.myvariable is: The Sky is Blue The value of url.donorid is: It's Empty - The above is the output for this code: cfparam name=url.myvariable default=The Sky is Blue cfparam name=url.donorid default=Roses Are Red pcfoutputCF Version: #Server.ColdFusion.ProductVersion#/cfoutput/p pThe value of url.myvariable is: cfoutput#url.myvariable#/cfoutput/p pThe value of url.donorid is: cfoutput#url.donorid#/cfoutput/p cfif url.donorid is pIt's Empty/p/cfif cfabort On Wed, Jul 14, 2010 at 10:47 AM, Charlie Arehart char...@carehart.orgwrote: Dusty, I really can’t see “donorid” being something the CF would have a problem with. :-) Let’s see if we can get to the bottom of this. First, to be clear, I tested it on CF8 (8.0.1) and did not experience it. Let’s confirm: are you on 8 or 8.0.1, just in case that may make a difference. But I suspect it’s something else. Second, are you saying that if you run the code right now (on your server), you still have the problem? Third, how about this: if you drop it into a new template that has no code other than this, does it still happen? Finally, if you put that file into a new directory with a blank application.cfm (so that you’re not inheriting any other), does it still happen? As I tell people all the time when they bring me in to consult on solving CF troubleshooting problems (big or small), there is always an explanation—it just isn’t always what it seems at first. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Wednesday, July 14, 2010 2:02 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] disappearing variable values I've had a similar thing with url variable: cfparam name=url.myvariable default=The Sky is Blue cfparam name=url.donorid default=Roses Are Red pThe value of url.myvariable is: cfoutput#url.myvariable#/cfoutput/p pThe value of url.donorid is: cfoutput#url.donorid#/cfoutput/p cfif url.donorid is pIt's Empty/p/cfif cfabort For some reason url.donorid always disappears unless there is an actual passed variable in the url. However, in theory the cfparam tag should set the default if none in the url. But no. It comes out an empty string. Here's the really strange thing because it seems to be just the variable name donorid and if I change the name then no problem. I'm on CF8 and this little quirk drove me nuts in an application trying to figure out why. On Tue, Jun 22, 2010 at 5:23 PM, Troy Jones t...@dynapp.com wrote: I am having a perplexing issue. Has anyone ever had an instance where it seemed as if a variable just “poofs” into thin air? For example, when I run the following code: cfdump var=#attributes# cfdump var=#pageID# cfdump var=#thisPage# cfset testVar = thisPage.form_id cfoutputthisPage.form_id = #testVar#/cfoutput cfif attributes.mode is do cfset thisForm = application.com.lib.getData(vformfields,form_id = #testVar#,field_sortorder) The variable “testVar” exists up until the setting of “thisForm” which I’ve verified with the cfdumps. At that point, when #testVar# is called, it is passing a NULL value to the SQL statement and throwing an error. I’ve tried recreating the error with a standard cfquery tag just to see if something was getting jacked up in the function call, but it had the same result. It’s as if the value just ran away and left. I’ve never seen anything quite like it and have run out of tails to chase, so to speak. This is on CF9 Enterprise, for anyone who needs it and any help would be greatly appreciated. Troy Jones - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com
Re: [ACFUG Discuss] disappearing variable values
To add to my last message I also ran this code on my production server (slightly older version) and still the same thing: --- CF Version: 8,0,0,176276 The value of url.myvariable is: The Sky is Blue The value of url.donorid is: It's Empty --- On Wed, Jul 14, 2010 at 11:05 AM, Dusty Hale du...@climbonline.com wrote: LOL yea this is rather strange and in theory I agree donorid should not be the cause but if I do change the name, the problem is gone. Of course it's one of those no big deal things because I can easily work around the problem but it leaves me with much curiosity :) Here's the output I get (right now): -- CF Version: 8,0,1,195765 The value of url.myvariable is: The Sky is Blue The value of url.donorid is: It's Empty - The above is the output for this code: cfparam name=url.myvariable default=The Sky is Blue cfparam name=url.donorid default=Roses Are Red pcfoutputCF Version: #Server.ColdFusion.ProductVersion#/cfoutput/p pThe value of url.myvariable is: cfoutput#url.myvariable#/cfoutput/p pThe value of url.donorid is: cfoutput#url.donorid#/cfoutput/p cfif url.donorid is pIt's Empty/p/cfif cfabort On Wed, Jul 14, 2010 at 10:47 AM, Charlie Arehart char...@carehart.orgwrote: Dusty, I really can’t see “donorid” being something the CF would have a problem with. :-) Let’s see if we can get to the bottom of this. First, to be clear, I tested it on CF8 (8.0.1) and did not experience it. Let’s confirm: are you on 8 or 8.0.1, just in case that may make a difference. But I suspect it’s something else. Second, are you saying that if you run the code right now (on your server), you still have the problem? Third, how about this: if you drop it into a new template that has no code other than this, does it still happen? Finally, if you put that file into a new directory with a blank application.cfm (so that you’re not inheriting any other), does it still happen? As I tell people all the time when they bring me in to consult on solving CF troubleshooting problems (big or small), there is always an explanation—it just isn’t always what it seems at first. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Wednesday, July 14, 2010 2:02 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] disappearing variable values I've had a similar thing with url variable: cfparam name=url.myvariable default=The Sky is Blue cfparam name=url.donorid default=Roses Are Red pThe value of url.myvariable is: cfoutput#url.myvariable#/cfoutput/p pThe value of url.donorid is: cfoutput#url.donorid#/cfoutput/p cfif url.donorid is pIt's Empty/p/cfif cfabort For some reason url.donorid always disappears unless there is an actual passed variable in the url. However, in theory the cfparam tag should set the default if none in the url. But no. It comes out an empty string. Here's the really strange thing because it seems to be just the variable name donorid and if I change the name then no problem. I'm on CF8 and this little quirk drove me nuts in an application trying to figure out why. On Tue, Jun 22, 2010 at 5:23 PM, Troy Jones t...@dynapp.com wrote: I am having a perplexing issue. Has anyone ever had an instance where it seemed as if a variable just “poofs” into thin air? For example, when I run the following code: cfdump var=#attributes# cfdump var=#pageID# cfdump var=#thisPage# cfset testVar = thisPage.form_id cfoutputthisPage.form_id = #testVar#/cfoutput cfif attributes.mode is do cfset thisForm = application.com.lib.getData(vformfields,form_id = #testVar#,field_sortorder) The variable “testVar” exists up until the setting of “thisForm” which I’ve verified with the cfdumps. At that point, when #testVar# is called, it is passing a NULL value to the SQL statement and throwing an error. I’ve tried recreating the error with a standard cfquery tag just to see if something was getting jacked up in the function call, but it had the same result. It’s as if the value just ran away and left. I’ve never seen anything quite like it and have run out of tails to chase, so to speak. This is on CF9 Enterprise, for anyone who needs it and any help would be greatly appreciated. Troy Jones - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com
Re: [ACFUG Discuss] disappearing variable values
Yea I'm familiar with that from the Fusebox days where form and url become attribute scope but no none of that in this app. On Wed, Jul 14, 2010 at 10:50 AM, Steve Ross nowhid...@gmail.com wrote: You aren't doing any variable scope copying in your app.cfm are you? Sometimes people choose to make their form vars and their url vars combined so they only have to check one... just a thought. On Wed, Jul 14, 2010 at 10:47 AM, Charlie Arehart char...@carehart.orgwrote: Dusty, I really can’t see “donorid” being something the CF would have a problem with. :-) Let’s see if we can get to the bottom of this. First, to be clear, I tested it on CF8 (8.0.1) and did not experience it. Let’s confirm: are you on 8 or 8.0.1, just in case that may make a difference. But I suspect it’s something else. Second, are you saying that if you run the code right now (on your server), you still have the problem? Third, how about this: if you drop it into a new template that has no code other than this, does it still happen? Finally, if you put that file into a new directory with a blank application.cfm (so that you’re not inheriting any other), does it still happen? As I tell people all the time when they bring me in to consult on solving CF troubleshooting problems (big or small), there is always an explanation—it just isn’t always what it seems at first. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Wednesday, July 14, 2010 2:02 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] disappearing variable values I've had a similar thing with url variable: cfparam name=url.myvariable default=The Sky is Blue cfparam name=url.donorid default=Roses Are Red pThe value of url.myvariable is: cfoutput#url.myvariable#/cfoutput/p pThe value of url.donorid is: cfoutput#url.donorid#/cfoutput/p cfif url.donorid is pIt's Empty/p/cfif cfabort For some reason url.donorid always disappears unless there is an actual passed variable in the url. However, in theory the cfparam tag should set the default if none in the url. But no. It comes out an empty string. Here's the really strange thing because it seems to be just the variable name donorid and if I change the name then no problem. I'm on CF8 and this little quirk drove me nuts in an application trying to figure out why. On Tue, Jun 22, 2010 at 5:23 PM, Troy Jones t...@dynapp.com wrote: I am having a perplexing issue. Has anyone ever had an instance where it seemed as if a variable just “poofs” into thin air? For example, when I run the following code: cfdump var=#attributes# cfdump var=#pageID# cfdump var=#thisPage# cfset testVar = thisPage.form_id cfoutputthisPage.form_id = #testVar#/cfoutput cfif attributes.mode is do cfset thisForm = application.com.lib.getData(vformfields,form_id = #testVar#,field_sortorder) The variable “testVar” exists up until the setting of “thisForm” which I’ve verified with the cfdumps. At that point, when #testVar# is called, it is passing a NULL value to the SQL statement and throwing an error. I’ve tried recreating the error with a standard cfquery tag just to see if something was getting jacked up in the function call, but it had the same result. It’s as if the value just ran away and left. I’ve never seen anything quite like it and have run out of tails to chase, so to speak. This is on CF9 Enterprise, for anyone who needs it and any help would be greatly appreciated. Troy Jones - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Steve Ross web application interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] -- Dusty Hale - President Hale Technologies, Inc. Email: du...@dustyhale.com Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com
[ACFUG Discuss] validating credit card numbers with CF
Does anyone have a CF code snippet for validating credit cards numbers? Dusty
Re: [ACFUG Discuss] validating credit card numbers with CF
Thanks shawn. Would that be as simple as doing this: cfif not refind(^((4\d{3})|(5[1-5]\d{2})|(6011))-?\d{4}-?\d{4}-?\d{4}|3[4,7]\d{13}$,trim(form.card_number),1) !--- do something --- /cfif On Wed, Mar 10, 2010 at 11:12 AM, shawn gorrell chees...@yahoo.com wrote: ^((4\d{3})|(5[1-5]\d{2})|(6011))-?\d{4}-?\d{4}-?\d{4}|3[4,7]\d{13}$ -- *From:* Dusty Hale du...@climbonline.com *To:* discussion@acfug.org *Sent:* Wed, March 10, 2010 11:05:47 AM *Subject:* [ACFUG Discuss] validating credit card numbers with CF Does anyone have a CF code snippet for validating credit cards numbers? Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
I did end up re doing the entire query in a cfquery tag instead of the connection string. I also used the queryparam tags like below. Seems to have resolved the error and hopefully prevents SQL injection too. Thanks On Wed, Jan 27, 2010 at 5:30 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Dusty, How about something like this? cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# select [donorid] , [occupation] , [race] , [haircolor] , [hairtexture] , [eyecolor] , [religion] , [bloodtype] , [height] , [weight] , [heightmetric] , [weightmetric] , [reportedpregnancy] , [opendonorid] , [infomp3avail] , [ethnicity] , [cmvstatus] , [DateEntered] , [ARTavail] , [ARTonly] , [SelectDonors] from [v_websearch] where [available] = 1 cfif len(drpHairColor) and [haircolor] like cfqueryparam value=#drpHairColor#% cfsqltype=cf_sql_varchar / /cfif /cfquery Qualify the columns and the view and query param the search string. This may also add some legibility as well. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 4:25 PM, Dusty Hale du...@climbonline.com wrote: I also stopped using the cfquery tag and now it works: cfscript classLoader = createObject(java, java.lang.Class); classLoader.forName(sun.jdbc.odbc.JdbcOdbcDriver); dm = createObject(java,java.sql.DriverManager); con = dm.getConnection(jdbc:odbc:DRIVER={SQL Server};Database= application.db_name ;Server= application.dbserver_name ;, application.db_user, application.db_pword); qText = Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 ; if(len(drpHairColor)){ qText = qText AND haircolor like ' drpHairColor %' ; } if(len(drpEyeColor)){ qText = qText AND eyecolor like ' drpEyeColor %' ; } if(len(drpEthnic)){ qText = qText AND ethnicity like ' drpEthnic %' ; } if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } //if(chkAudioFile){ //qText = qText AND InfoMP3Avail = 1 ; //} if(chkOpenId){ qText = qText AND OpenDonorID = 1 ; } if(chkCanadian){ qText = qText AND CanadianCompliantAvail = 1 ; } if(len(drpRace)){ qText = qText AND race like ' drpRace %' ; } if(len(drpReligion)){ qText = qText AND religion like ' drpReligion %' ; } if(len(drpBloodType)){ qText = qText AND bloodtype like ' drpBloodType %' ; } if(len(drpHeight)){ if(drpHeight eq 1-66){ qText = qText AND heightregular 507 ; } if(drpHeight eq 67-71){ qText = qText AND heightregular 512 AND heightregular 507 ; } if(drpHeight eq 72-76){ qText = qText AND heightregular 605 AND heightregular 512 ; } if(drpHeight eq 77-100){ qText = qText AND heightregular 604 ; } } if(IsNumeric(txtWeight1) AND IsNumeric(txtWeight2)){ if(chkWeight is kg){ qText = qText AND weightmetric = txtWeight2 AND weightmetric = txtWeight1 ; } else{ qText = qText AND weight = txtWeight2 AND weight = txtWeight1 ; } } if(len(drpCMVstatus)){ qText = qText AND cmvstatus like ' drpCMVstatus %' ; } if(chkART){ qText = qText AND ARTavail IS NOT NULL ; } if(chkSelect){ qText = qText AND SelectDonors IS NOT NULL ; } qText = qText ORDER BY donorid; st = con.createStatement(); rs = st.ExecuteQuery(qText); q = createObject(java, coldfusion.sql.QueryTable).init(rs); stRecordCount = con.createStatement(); rs2 = stRecordCount.ExecuteQuery(Select count(*) AS MyCount FROM tbldonors where available = 1); qRecordCount = createObject(java, coldfusion.sql.QueryTable).init(rs2); /cfscript On Wed, Jan 27, 2010 at 4:18 PM, Forrest C. Gilmore fcg0...@wctel.netwrote: Can you show me the exact code you used when you tried PreserveSingleQuotes? According to the documentation, This function is useful in SQL statements to defer
Re: [ACFUG Discuss] CF blogs
That's Tom that's just the kind of input I was looking for. I downloaded Mango last night. Seems easy to install. I like what I see so far. One of the guys at the office wrote me this morning to tell me he opened an account at blogger.com and ask me if we should run multiple blogs. One integrated into our site and another one at blogger.com. I didn't know what to tell him. I'm not a blog expert or anything but at the moment I don't know how it would help to have two which would basically have the same info on it. Does anyone know if would help or hurt to post the same content to multiple blogs? Good thing? Bad thing? Dusty On Thu, Jan 28, 2010 at 11:02 AM, Tom McNeer tmcn...@gmail.com wrote: Dusty, I'm not sure you'll be able to determine a most preferred: blog. But I think you'll find strong supporters both for Ray Camden's BlogCFC (which has been around forever, but is frequently updated) and Mango Blog, from the folks at ASFusion. You can find both at RIAForge, I think. For some reason, Mango Blog isn't showing up in the search there, although a number of plugins for it do. But you can find it at mangoblog.org. Mango, in particular, is built for skinning. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] CF blogs
Those are very good reasons. Ease of skin is very important in the project I've been assigned. Thanks again to all for the input. Dusty On Thu, Jan 28, 2010 at 12:58 PM, Andrew phi1...@gmail.com wrote: I switched from BlogCFC to Mango for multiple reasons. 1. It's EXTREMELY easy to skin and modify the designs for it 2. It's got a solid plugin architecture that lets you add any functionality that you may think is missing without compromising the engine as a whole 3. It's got an extremely well designed admin console that automatically notifies you of updates, not just to the engine, but to skins as well I feel that BlogCFC is a good starter blog for anyone wanting to use a CF blog engine. Mango, to me, just seems like a much more elegant and professional piece of software. I've told Ray as much and he agrees. BlogCFC is a hobby for him, not something he can dedicate a lot of time to maintain. Mango is something that Nauhel and Laura have time to dedicate to and it shows. My two cents. Andy Powell On Thu, Jan 28, 2010 at 11:53 AM, shawn gorrell chees...@yahoo.comwrote: I've been using Ray's BlogCFC since he first released it. Modified it slightly and haven't done a single upgrade. Has worked well for me, so I had no reason to stay up to date. -- *From:* Dusty Hale du...@climbonline.com *To:* discussion@acfug.org *Sent:* Thu, January 28, 2010 11:49:48 AM *Subject:* Re: [ACFUG Discuss] CF blogs That's Tom that's just the kind of input I was looking for. I downloaded Mango last night. Seems easy to install. I like what I see so far. One of the guys at the office wrote me this morning to tell me he opened an account at blogger.com and ask me if we should run multiple blogs. One integrated into our site and another one at blogger.com. I didn't know what to tell him. I'm not a blog expert or anything but at the moment I don't know how it would help to have two which would basically have the same info on it. Does anyone know if would help or hurt to post the same content to multiple blogs? Good thing? Bad thing? Dusty On Thu, Jan 28, 2010 at 11:02 AM, Tom McNeer tmcn...@gmail.com wrote: Dusty, I'm not sure you'll be able to determine a most preferred: blog. But I think you'll find strong supporters both for Ray Camden's BlogCFC (which has been around forever, but is frequently updated) and Mango Blog, from the folks at ASFusion. You can find both at RIAForge, I think. For some reason, Mango Blog isn't showing up in the search there, although a number of plugins for it do. But you can find it at mangoblog.org. Mango, in particular, is built for skinning. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
Yea that's a good point Dean. Will cfqueryparam tags solve that? Also if using a connection string approach as opposed to a cfquery tag, what's the best way to deal with SQLInjection? I know what SQLinjection is and I'm sure I should probably be more concerned with it that I have been in the past. Thanks for pointing that out and I'm going to make it a point to do better in that area. Dusty On Wed, Jan 27, 2010 at 6:29 PM, Dean H. Saxe d...@fullfrontalnerdity.comwrote: D'oh! Anyone else see the classic SQLinjection vuln here... -- Dean H. Saxe A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children. -- John James Audubon On Wed, Jan 27, 2010 at 11:47 AM, Dusty Hale du...@climbonline.com wrote: Teddy here's how I build the qText string part where the quotes are: if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne teddyrpa...@gmail.com wrote: Dusty, What type of single quotes are those? What is the source of the text? Was the query copied and pasted from a Microsoft document? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale du...@climbonline.com wrote: Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 Called from D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 Called from D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 Called from D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 Called from D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 Called from D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 : /cfscript 148 : cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# 149 : #qText# 150 : /cfquery - Here's the SQL code in the qText variable. Please note that it runs fun in Query Analyzer. Also note that no division is being used. Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid -- Any advise or thought on this of course is greatly appreciated. Dusty -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] CF blogs
I'm very curious to know which ColdFusion blog is the most preferred in the CF community. I've read some really good things about Mango Blog. I've been given the task of redesigning and reorganizing a blog for the company I'm currently working for. We currently have an older version WP blog. Several problems that I've been asked by my boss to solve: 1. We want a tighter integration with our existing website which is a custom site built with CF and MS SQL 2005. It has very custom and specialized features including it's own login system (Permission based using bitAnd that Hal Helms taught me years ago). The folks at our office never liked the WP blog because it has its own user system and we were never able to tie it to our user system (shared login type of thing). Maybe the new blog doesn't even need a login. We'd also like to output posts on our other websites which are all CF sites. Mango seems like a good fit because we can keep the blog data in the same SQL Server database so I'm assuming I could use CF to output posts directly in the skin of our other sites? 2. I need a blog that I can customize the look with our existing website skin. I also have to say that I suck at doing pure CSS layouts so I still use tables. I do use CSS just not in a pure layout. If that is a problem, I may even outsource that to a person with solid CSS layout skills. 3. Our older WP blog honestly is just too much for any of our staff to use. Everytime they try to post stuff they always manage to screw up the formatting of have some kind of issue and I end up redoing every post they make. I hate web based WSIWYG editors so I just code a post with hand coded clean HTML and inline CSS styles in every tag. I do it in DW and copy paste it over into WP. Anyway I am not a pro blogger nor do I claim to have great blogging knowledge. Any thoughts or opinions are greatly appreciated and please if I can somehow return the favor or contribute in some way, please let me know. Also just to let everyone know. I lived and worked as a CF developer in Atlanta for some years and used to occasionally attend ACFUG meetings. It's been some time since Atlanta and I'm living and traveling in places where there are little to no technical user groups like this. So technically I'm not in Atlanta anymore but I'm looking to be more involved with one or more groups like this remotely. So if there are any little things I can do to help, I'm down with that. Thanks, Dusty
[ACFUG Discuss] a very strange sql error that only happens when using CF
Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in *D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149* *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 : /cfscript 148 : cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# *149 : #qText#* 150 : /cfquery - Here's the SQL code in the qText variable. Please note that it runs fun in Query Analyzer. Also note that no division is being used. Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid -- Any advise or thought on this of course is greatly appreciated. Dusty
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
No I just basically output the query before it gets to the cfquery tag. That outputs it on the page instead of running the query in CF. Then I copied the query into SQL Studio and it runs fine. However when I run the same query in a cfquery tag I get the message. No division is being used. The single quotes are just straight ASCII text. No evil MS Word. On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Dusty, What type of single quotes are those? What is the source of the text? Was the query copied and pasted from a Microsoft document? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale du...@climbonline.com wrote: Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in *D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149* *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 :/cfscript 148 :cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# *149 : #qText#* 150 :/cfquery - Here's the SQL code in the qText variable. Please note that it runs fun in Query Analyzer. Also note that no division is being used. Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid -- Any advise or thought on this of course is greatly appreciated. Dusty -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
Craig do you have a link to that thread? Many thanks, Dusty On Wed, Jan 27, 2010 at 2:38 PM, craig.nas...@atl.frb.org wrote: Looking out on the internet, I came across an interesting article that might point to the issue - take a look at the surrounding threads on here for further info - not sure this will be the solution - just an ideasounds the very same as what you're seeing. Thanks, Craig Nassal Federal Reserve Bank of Atlanta 1000 Peachtree St. N.E. Atlanta, Ga 30309-4470 (404)498-8437 craig.nas...@atl.frb.org Dusty Hale du...@climbonline.com Sent by: ad...@acfug.org 01/27/10 02:25 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] a very strange sql error that only happens when using CF Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 Called from D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 Called from D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 Called from D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 Called from D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 Called from D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 :/cfscript 148 :cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# 149 :#qText# 150 :/cfquery - Here's the SQL code in the qText variable. Please note that it runs fun in Query Analyzer. Also note that no division is being used. Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid -- Any advise or thought on this of course is greatly appreciated. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
Teddy here's how I build the qText string part where the quotes are: if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Dusty, What type of single quotes are those? What is the source of the text? Was the query copied and pasted from a Microsoft document? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale du...@climbonline.com wrote: Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in *D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149* *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 :/cfscript 148 :cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# *149 : #qText#* 150 :/cfquery - Here's the SQL code in the qText variable. Please note that it runs fun in Query Analyzer. Also note that no division is being used. Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid -- Any advise or thought on this of course is greatly appreciated. Dusty -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2210) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358) at cfsearch2ecfm984473465.runPage(D:\websites\xytexcom_stage2\htdocs\search.cfm:48) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) On Wed, Jan 27, 2010 at 3:00 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Dusty, As a source of troubleshooting, have you put the SQL string into the cfquery statement in its final form? I am wondering if the SQL runs correctly in the cfquery before the dynamic evaluation. cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_ pword# **Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid /cfquery Does this run correctly? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:47 PM, Dusty Hale du...@climbonline.com wrote: Teddy here's how I build the qText string part where the quotes are: if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Dusty, What type of single quotes are those? What is the source of the text? Was the query copied and pasted from a Microsoft document? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale du...@climbonline.comwrote: Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in *D
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
Yep that runs fine. This is really strange. The value of the qText variable is the same as the query below yet when I stuff #qText# in there, it somehow doubles the quotes by itself. Damn I just don't get how it could or would do that. If I output the value of the qText variable on a page, quotes are correct. Have you ever seen anything like this? Thanks, Dusty On Wed, Jan 27, 2010 at 3:00 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Dusty, As a source of troubleshooting, have you put the SQL string into the cfquery statement in its final form? I am wondering if the SQL runs correctly in the cfquery before the dynamic evaluation. cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_ pword# **Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid /cfquery Does this run correctly? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:47 PM, Dusty Hale du...@climbonline.com wrote: Teddy here's how I build the qText string part where the quotes are: if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Dusty, What type of single quotes are those? What is the source of the text? Was the query copied and pasted from a Microsoft document? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale du...@climbonline.comwrote: Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in *D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149* *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 : /cfscript 148 : cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# *149 : #qText#* 150 : /cfquery - Here's the SQL code in the qText variable. Please note that it runs fun in Query Analyzer. Also note that no division is being used. Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid -- Any advise or thought on this of course is greatly appreciated. Dusty -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
Very familiar with that function but in this case. That's not it. If I remember correctly that function is to preserve single quotes that might be in the string like: 'It's a problem' in this case the string never has a quote: select * from mydonors where donorid like '%ABC123%' On Wed, Jan 27, 2010 at 3:36 PM, Forrest C. Gilmore fcg0...@wctel.netwrote: Go into CF Help and look up the Preservesinglequotes function. Forrest C. Gilmore Dusty Hale wrote: Yep that runs fine. This is really strange. The value of the qText variable is the same as the query below yet when I stuff #qText# in there, it somehow doubles the quotes by itself. Damn I just don't get how it could or would do that. If I output the value of the qText variable on a page, quotes are correct. Have you ever seen anything like this? Thanks, Dusty On Wed, Jan 27, 2010 at 3:00 PM, Teddy R. Payne teddyrpa...@gmail.commailto: teddyrpa...@gmail.com wrote: Dusty, As a source of troubleshooting, have you put the SQL string into the cfquery statement in its final form? I am wondering if the SQL runs correctly in the cfquery before the dynamic evaluation. cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_ pword# Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid /cfquery Does this run correctly? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:47 PM, Dusty Hale du...@climbonline.com mailto:du...@climbonline.com wrote: Teddy here's how I build the qText string part where the quotes are: if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com wrote: Dusty, What type of single quotes are those? What is the source of the text? Was the query copied and pasted from a Microsoft document? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale du...@climbonline.com mailto:du...@climbonline.com wrote: Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in *D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149* *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 : /cfscript 148 : cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# *149 : #qText#* 150 : /cfquery - Here's the SQL code in the qText variable. Please note that it runs fun in Query Analyzer. Also note that no division is being used. Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
Just to rule it out though I tried it. Didn't help though. On Wed, Jan 27, 2010 at 3:36 PM, Forrest C. Gilmore fcg0...@wctel.netwrote: Go into CF Help and look up the Preservesinglequotes function. Forrest C. Gilmore Dusty Hale wrote: Yep that runs fine. This is really strange. The value of the qText variable is the same as the query below yet when I stuff #qText# in there, it somehow doubles the quotes by itself. Damn I just don't get how it could or would do that. If I output the value of the qText variable on a page, quotes are correct. Have you ever seen anything like this? Thanks, Dusty On Wed, Jan 27, 2010 at 3:00 PM, Teddy R. Payne teddyrpa...@gmail.commailto: teddyrpa...@gmail.com wrote: Dusty, As a source of troubleshooting, have you put the SQL string into the cfquery statement in its final form? I am wondering if the SQL runs correctly in the cfquery before the dynamic evaluation. cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_ pword# Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid /cfquery Does this run correctly? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:47 PM, Dusty Hale du...@climbonline.com mailto:du...@climbonline.com wrote: Teddy here's how I build the qText string part where the quotes are: if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com wrote: Dusty, What type of single quotes are those? What is the source of the text? Was the query copied and pasted from a Microsoft document? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale du...@climbonline.com mailto:du...@climbonline.com wrote: Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in *D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149* *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 : /cfscript 148 : cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# *149 : #qText#* 150 : /cfquery - Here's the SQL code in the qText variable. Please note that it runs fun in Query Analyzer. Also note that no division is being used. Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
So just to let you all know. I did find a solution. I basically rolled my code back to the way it was yesterday because it always worked before. Then I made the same little update I made today AGAIN (just adding a reference to one other column in the query). Now it works. I still don't for the life of me get how I can output the string of SQL and run it fine in both a query analyzer and and in a cfquery tag yet when I pass it in as a variable, CF adds additional single quotes on its own. That is a new and very bizarre thing to see for me. Well I can't figure out but I did at least get past it so I can move on but still the curiosity is killing me. Thanks to all that replied and have a great day and a great rest of the week. On Wed, Jan 27, 2010 at 3:53 PM, Dusty Hale du...@climbonline.com wrote: Just to rule it out though I tried it. Didn't help though. On Wed, Jan 27, 2010 at 3:36 PM, Forrest C. Gilmore fcg0...@wctel.netwrote: Go into CF Help and look up the Preservesinglequotes function. Forrest C. Gilmore Dusty Hale wrote: Yep that runs fine. This is really strange. The value of the qText variable is the same as the query below yet when I stuff #qText# in there, it somehow doubles the quotes by itself. Damn I just don't get how it could or would do that. If I output the value of the qText variable on a page, quotes are correct. Have you ever seen anything like this? Thanks, Dusty On Wed, Jan 27, 2010 at 3:00 PM, Teddy R. Payne teddyrpa...@gmail.commailto: teddyrpa...@gmail.com wrote: Dusty, As a source of troubleshooting, have you put the SQL string into the cfquery statement in its final form? I am wondering if the SQL runs correctly in the cfquery before the dynamic evaluation. cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_ pword# Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 AND donorid like '%9986%' ORDER BY donorid /cfquery Does this run correctly? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:47 PM, Dusty Hale du...@climbonline.com mailto:du...@climbonline.com wrote: Teddy here's how I build the qText string part where the quotes are: if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com wrote: Dusty, What type of single quotes are those? What is the source of the text? Was the query copied and pasted from a Microsoft document? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com mailto:teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale du...@climbonline.com mailto:du...@climbonline.com wrote: Hi: I've run into a very strange issue. I have a cfc which has a cfquery tag in it. I recently added one field the SQL in the query and am getting an error I've never seen before. I can't seem to dig out any info to solve this. If anyone is familiar, please share. Of course when I output the SQL and run in a SQL Studio Query window, the query runs fine with no errors. Here the error I see in CF: - [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred in *D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149* *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 149 *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: line 139 *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 147 : /cfscript 148 : cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
I also stopped using the cfquery tag and now it works: cfscript classLoader = createObject(java, java.lang.Class); classLoader.forName(sun.jdbc.odbc.JdbcOdbcDriver); dm = createObject(java,java.sql.DriverManager); con = dm.getConnection(jdbc:odbc:DRIVER={SQL Server};Database= application.db_name ;Server= application.dbserver_name ;, application.db_user, application.db_pword); qText = Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 ; if(len(drpHairColor)){ qText = qText AND haircolor like ' drpHairColor %' ; } if(len(drpEyeColor)){ qText = qText AND eyecolor like ' drpEyeColor %' ; } if(len(drpEthnic)){ qText = qText AND ethnicity like ' drpEthnic %' ; } if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } //if(chkAudioFile){ //qText = qText AND InfoMP3Avail = 1 ; //} if(chkOpenId){ qText = qText AND OpenDonorID = 1 ; } if(chkCanadian){ qText = qText AND CanadianCompliantAvail = 1 ; } if(len(drpRace)){ qText = qText AND race like ' drpRace %' ; } if(len(drpReligion)){ qText = qText AND religion like ' drpReligion %' ; } if(len(drpBloodType)){ qText = qText AND bloodtype like ' drpBloodType %' ; } if(len(drpHeight)){ if(drpHeight eq 1-66){ qText = qText AND heightregular 507 ; } if(drpHeight eq 67-71){ qText = qText AND heightregular 512 AND heightregular 507 ; } if(drpHeight eq 72-76){ qText = qText AND heightregular 605 AND heightregular 512 ; } if(drpHeight eq 77-100){ qText = qText AND heightregular 604 ; } } if(IsNumeric(txtWeight1) AND IsNumeric(txtWeight2)){ if(chkWeight is kg){ qText = qText AND weightmetric = txtWeight2 AND weightmetric = txtWeight1 ; } else{ qText = qText AND weight = txtWeight2 AND weight = txtWeight1 ; } } if(len(drpCMVstatus)){ qText = qText AND cmvstatus like ' drpCMVstatus %' ; } if(chkART){ qText = qText AND ARTavail IS NOT NULL ; } if(chkSelect){ qText = qText AND SelectDonors IS NOT NULL ; } qText = qText ORDER BY donorid; st = con.createStatement(); rs = st.ExecuteQuery(qText); q = createObject(java, coldfusion.sql.QueryTable).init(rs); stRecordCount = con.createStatement(); rs2 = stRecordCount.ExecuteQuery(Select count(*) AS MyCount FROM tbldonors where available = 1); qRecordCount = createObject(java, coldfusion.sql.QueryTable).init(rs2); /cfscript On Wed, Jan 27, 2010 at 4:18 PM, Forrest C. Gilmore fcg0...@wctel.netwrote: Can you show me the exact code you used when you tried PreserveSingleQuotes? According to the documentation, This function is useful in SQL statements to defer evaluation of a variable reference until runtime. Seems to be just what you need, but it must be used properly. *Example B*: Consider this code: cfset list0 = '1','2''3' cfquery sql = select * from foo where bar in (#list0#) ColdFusion escapes the single-quote characters in the list as follows: 1, 2, 3 The cfquery tag throws an error. You code this function correctly as follows: cfquery sql = select * from foo where bar in (#preserveSingleQuotes(list0)#) This function ensures that ColdFusion evaluates the code as follows: '1', '2', '3' -- Forrest C. Gilmore === Dusty Hale wrote: Just to rule it out though I tried it. Didn't help though. On Wed, Jan 27, 2010 at 3:36 PM, Forrest C. Gilmore fcg0...@wctel.netwrote: Go into CF Help and look up the Preservesinglequotes function. Forrest C. Gilmore Dusty Hale wrote: Yep that runs fine. This is really strange. The value of the qText variable is the same as the query below yet when I stuff #qText# in there, it somehow doubles the quotes by itself. Damn I just don't get how it could or would do that. If I output the value of the qText variable on a page, quotes are correct. Have you ever seen anything like this? Thanks, Dusty On Wed, Jan 27, 2010 at 3:00 PM, Teddy R. Payne teddyrpa...@gmail.commailto: teddyrpa...@gmail.com wrote: Dusty, As a source of troubleshooting, have you put the SQL string into the cfquery statement
Re: [ACFUG Discuss] a very strange sql error that only happens when using CF
I may have to do that because now I have another issue LOL. While using the connection string approach, it works great on our production server. However I can't for the life of me get connections strings like this to work on my development server (Mac Book with VMWare Win XP CF 8) so I'm likely going to do something like cfif production server !--- use connection string approach cfelseif my Mac Book !--- use cfquery tag --- cfelse !--- give up and go to the nearest bar and begin drinking vodka shots --- /cfif Muchos Gracias Teddy. I'm knockin off but will try this in the morning. On Wed, Jan 27, 2010 at 5:30 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Dusty, How about something like this? cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# select [donorid] , [occupation] , [race] , [haircolor] , [hairtexture] , [eyecolor] , [religion] , [bloodtype] , [height] , [weight] , [heightmetric] , [weightmetric] , [reportedpregnancy] , [opendonorid] , [infomp3avail] , [ethnicity] , [cmvstatus] , [DateEntered] , [ARTavail] , [ARTonly] , [SelectDonors] from [v_websearch] where [available] = 1 cfif len(drpHairColor) and [haircolor] like cfqueryparam value=#drpHairColor#% cfsqltype=cf_sql_varchar / /cfif /cfquery Qualify the columns and the view and query param the search string. This may also add some legibility as well. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jan 27, 2010 at 4:25 PM, Dusty Hale du...@climbonline.com wrote: I also stopped using the cfquery tag and now it works: cfscript classLoader = createObject(java, java.lang.Class); classLoader.forName(sun.jdbc.odbc.JdbcOdbcDriver); dm = createObject(java,java.sql.DriverManager); con = dm.getConnection(jdbc:odbc:DRIVER={SQL Server};Database= application.db_name ;Server= application.dbserver_name ;, application.db_user, application.db_pword); qText = Select donorid, occupation, race, haircolor, hairtexture, eyecolor, religion, bloodtype, height, weight, heightmetric, weightmetric, reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where available = 1 ; if(len(drpHairColor)){ qText = qText AND haircolor like ' drpHairColor %' ; } if(len(drpEyeColor)){ qText = qText AND eyecolor like ' drpEyeColor %' ; } if(len(drpEthnic)){ qText = qText AND ethnicity like ' drpEthnic %' ; } if(len(txtDonorId)){ qText = qText AND donorid like '% txtDonorId %' ; } //if(chkAudioFile){ //qText = qText AND InfoMP3Avail = 1 ; //} if(chkOpenId){ qText = qText AND OpenDonorID = 1 ; } if(chkCanadian){ qText = qText AND CanadianCompliantAvail = 1 ; } if(len(drpRace)){ qText = qText AND race like ' drpRace %' ; } if(len(drpReligion)){ qText = qText AND religion like ' drpReligion %' ; } if(len(drpBloodType)){ qText = qText AND bloodtype like ' drpBloodType %' ; } if(len(drpHeight)){ if(drpHeight eq 1-66){ qText = qText AND heightregular 507 ; } if(drpHeight eq 67-71){ qText = qText AND heightregular 512 AND heightregular 507 ; } if(drpHeight eq 72-76){ qText = qText AND heightregular 605 AND heightregular 512 ; } if(drpHeight eq 77-100){ qText = qText AND heightregular 604 ; } } if(IsNumeric(txtWeight1) AND IsNumeric(txtWeight2)){ if(chkWeight is kg){ qText = qText AND weightmetric = txtWeight2 AND weightmetric = txtWeight1 ; } else{ qText = qText AND weight = txtWeight2 AND weight = txtWeight1 ; } } if(len(drpCMVstatus)){ qText = qText AND cmvstatus like ' drpCMVstatus %' ; } if(chkART){ qText = qText AND ARTavail IS NOT NULL ; } if(chkSelect){ qText = qText AND SelectDonors IS NOT NULL ; } qText = qText ORDER BY donorid; st = con.createStatement(); rs = st.ExecuteQuery(qText); q = createObject(java, coldfusion.sql.QueryTable).init(rs); stRecordCount = con.createStatement(); rs2 = stRecordCount.ExecuteQuery(Select count(*) AS MyCount
Re: [ACFUG Discuss]
You can create an RSS feed using the cffeed tag. I've successfully used the tag to read and parse other RSS feeds so I can't offer any advice on creating feeds but it can be done and I believe you can create a feed from a query as the example from livedocs shows: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_01.html Dusty On Tue, May 5, 2009 at 7:20 PM, techsupport techsupp...@hirenet.net wrote: I'm looking for help getting pointed in the right direction for a good place that details how to create RSS files to transfer data from my website over to Twitter, Facebook, etc. Any ideas? Kristine Macauley 678-852-6175 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
[ACFUG Discuss] Re: calling a CFC with PHP
Hi thanks again to those who responded off list. I've been researching and trying different things with PHP to try and do this but I'm stumped and giving up for now. The concept of CFCs are very clear to me and I know how to use them in CF and do so often. However, the whole remote web service call thing is really foreign to me and I just don't know enough about it to be able to accomplish this. I understand completely what web services do and what they can accomlish I just don't know any thing about SOAP, WDSL, ect to be able to understand what I need to do and my PHP experience is bare minimum. So I have talked myself into moving the entire app over to CF where I can code it fully understanding everything. Thanks again, Dusty On Wed, Apr 29, 2009 at 3:53 PM, Dusty Hale du...@climbonline.com wrote: Hi I'm now researching how to call a web service (a cfc) with PHP. If anyone has a link with good info or a PHP code snippet for this, please let me know. The return variable in the CFC is just an HTML formatted message so I'm hoping for simplicity. Thanks, Dusty
[ACFUG Discuss] calling a CFC with PHP
Hi I'm now researching how to call a web service (a cfc) with PHP. If anyone has a link with good info or a PHP code snippet for this, please let me know. The return variable in the CFC is just an HTML formatted message so I'm hoping for simplicity. Thanks, Dusty
[ACFUG Discuss] calling a CFC with PHP
Hi I'm now researching how to call a web service (a cfc) with PHP. If anyone has a link with good info or a PHP code snippet for this, please let me know. The return variable in the CFC is just an HTML formatted message so I'm hoping for simplicity. Thanks, Dusty -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] creating a web service with cf
Allen yes very well said this is exactly what I was planning on doing. LOL, however, I may have talked the person I'm doing this with into moving the site over to a server with CF. Many thanks to you and to all for the responses on this. I really appreciate it. Dusty On Fri, Apr 17, 2009 at 7:28 AM, axunderw...@ups.com wrote: There's really not a problem with doing what you say - many will say it's bad practice, but a way to avoid getting all the bad practice responses, do something like this. Have a function in your cfc that returns your query. Then have another function that will format that particular query into an html table. That will do two things for you. One, you can separate your data layer from your display layer, and if in the future you feel that you need that query for more than just displaying HTML tables, you can easily just call that function. So no, there's no problem with wanting to just return an HTML table. You can do that, just separate out your data function and your html formatting functions. Give that a shot. As John said below, from php you would just call the page as follows: http://url_to_cfc/yourcfc.cfc?methodname=yourmethod - be sure to get rid of the returnFormat=json if you're going to be outputting html. Allen -- *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Thursday, April 16, 2009 6:37 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] creating a web service with cf I guess my thought was that I didn't want to deal with a php array. I don't have so much php experience so I was hoping to just output (or echo) that one variable that would be returned all formatted into HTML for presentation on the page. This would allow me to do pretty much all the work with CF. Does that make any sense? The main reason I am thinking this way is because I feel comfortable coding with CF but not so comfortable with PHP and it is something I don't want to spend very much time on. Dusty On Thu, Apr 16, 2009 at 6:01 PM, John Mason ma...@fusionlink.com wrote: You're adding a lot more work to this than is necessary. Just call the cfc method (which will return a standard query) like so.. url_to_cfc/yourcfc.cfc?methodname=yourmethodreturnFormat=json This should provide you with a proper json string. Then on the php side use json_decode() to decode the string into a php array. You should be good too go with that and it'll take a lot less work. John ma...@fusionlink.com Dusty Hale wrote: Hi thank you Allen, John, and Brooks for the responses. I was actually planning on keeping the query result in the cfc and formatting the results in HTML table rows and pushing that into a cfsavecontent variable=myresults and then sending that returning that variable to the web service. So in PHP I was hoping to just spit out that variable somehow to display the results in the HTML table rows. Does that sound like it would work? Can anyone see any problems with doing it this way. Security is not too much of an issue here it is just some categories of sponsor information. Muchos Gracias, Dusty On Thu, Apr 16, 2009 at 10:36 AM, ma...@fusionlink.com mailto: ma...@fusionlink.com wrote: You can simply specify the return type as either wddx or json. PHP has (or at least had) a wddx reader. And json is common now, so I suspect php has functions for that as well. If you do specify the return type, do it in the url not on the attribute of the cffunction. It keeps your web service agnostic so to speak. John ma...@fusionlink.com mailto:ma...@fusionlink.com - Original Message - From: brooks.wil...@atl.frb.org mailto:brooks.wil...@atl.frb.org [mailto:brooks.wil...@atl.frb.org mailto:brooks.wil...@atl.frb.org] To: discussion@acfug.org mailto:discussion@acfug.org Sent: Thu, 16 Apr 2009 08:01:21 -0400 Subject: Re: [ACFUG Discuss] creating a web service with cf sure - but you need to decide on a data format. does php support cf query type? i doubt it - you will likely need to change the query to an array. Dusty Hale du...@dustyhale.com mailto:du...@dustyhale.com Sent by: ad...@acfug.org mailto:ad...@acfug.org 04/16/2009 01:02 AM Please respond to discussion@acfug.org mailto:discussion@acfug.org To discussion@acfug.org mailto:discussion@acfug.org cc Subject [ACFUG Discuss] creating a web service with cf I have a need which I think would be a good fit to create a web service but since I have never developed a web service I thought to get some other opinions. I have a site which is hosted on a Linux box with php and no CF. I need for part of this site to use a database and make a little admin app to manage it. Well I am lazy and don't want to do this with PHP and MySQL mainly because I know CF and SQL so I
Re: [ACFUG Discuss] creating a web service with cf
Hi thank you Allen, John, and Brooks for the responses. I was actually planning on keeping the query result in the cfc and formatting the results in HTML table rows and pushing that into a cfsavecontent variable=myresults and then sending that returning that variable to the web service. So in PHP I was hoping to just spit out that variable somehow to display the results in the HTML table rows. Does that sound like it would work? Can anyone see any problems with doing it this way. Security is not too much of an issue here it is just some categories of sponsor information. Muchos Gracias, Dusty On Thu, Apr 16, 2009 at 10:36 AM, ma...@fusionlink.com wrote: You can simply specify the return type as either wddx or json. PHP has (or at least had) a wddx reader. And json is common now, so I suspect php has functions for that as well. If you do specify the return type, do it in the url not on the attribute of the cffunction. It keeps your web service agnostic so to speak. John ma...@fusionlink.com - Original Message - From: brooks.wil...@atl.frb.org [mailto:brooks.wil...@atl.frb.org] To: discussion@acfug.org Sent: Thu, 16 Apr 2009 08:01:21 -0400 Subject: Re: [ACFUG Discuss] creating a web service with cf sure - but you need to decide on a data format. does php support cf query type? i doubt it - you will likely need to change the query to an array. Dusty Hale du...@dustyhale.com Sent by: ad...@acfug.org 04/16/2009 01:02 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] creating a web service with cf I have a need which I think would be a good fit to create a web service but since I have never developed a web service I thought to get some other opinions. I have a site which is hosted on a Linux box with php and no CF. I need for part of this site to use a database and make a little admin app to manage it. Well I am lazy and don't want to do this with PHP and MySQL mainly because I know CF and SQL so I just want to do this with what I am used to. So my thought was that I could create a CFC that would act as a web service that the PHP site could call remotely. All it needs to do is get some data from the SQL server and display it in HTML. So I though I could generate the result HTML in the CFC and the PHP site could call it remotely. Again the PHP site is not on the same server as the CFC so it would be a remote call. This is basically what a web service is for right? Would this approach work? Thanks so much in advance for any replies. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
Re: [ACFUG Discuss] creating a web service with cf
I guess my thought was that I didn't want to deal with a php array. I don't have so much php experience so I was hoping to just output (or echo) that one variable that would be returned all formatted into HTML for presentation on the page. This would allow me to do pretty much all the work with CF. Does that make any sense? The main reason I am thinking this way is because I feel comfortable coding with CF but not so comfortable with PHP and it is something I don't want to spend very much time on. Dusty On Thu, Apr 16, 2009 at 6:01 PM, John Mason ma...@fusionlink.com wrote: You're adding a lot more work to this than is necessary. Just call the cfc method (which will return a standard query) like so.. url_to_cfc/yourcfc.cfc?methodname=yourmethodreturnFormat=json This should provide you with a proper json string. Then on the php side use json_decode() to decode the string into a php array. You should be good too go with that and it'll take a lot less work. John ma...@fusionlink.com Dusty Hale wrote: Hi thank you Allen, John, and Brooks for the responses. I was actually planning on keeping the query result in the cfc and formatting the results in HTML table rows and pushing that into a cfsavecontent variable=myresults and then sending that returning that variable to the web service. So in PHP I was hoping to just spit out that variable somehow to display the results in the HTML table rows. Does that sound like it would work? Can anyone see any problems with doing it this way. Security is not too much of an issue here it is just some categories of sponsor information. Muchos Gracias, Dusty On Thu, Apr 16, 2009 at 10:36 AM, ma...@fusionlink.com mailto: ma...@fusionlink.com wrote: You can simply specify the return type as either wddx or json. PHP has (or at least had) a wddx reader. And json is common now, so I suspect php has functions for that as well. If you do specify the return type, do it in the url not on the attribute of the cffunction. It keeps your web service agnostic so to speak. John ma...@fusionlink.com mailto:ma...@fusionlink.com - Original Message - From: brooks.wil...@atl.frb.org mailto:brooks.wil...@atl.frb.org [mailto:brooks.wil...@atl.frb.org mailto:brooks.wil...@atl.frb.org] To: discussion@acfug.org mailto:discussion@acfug.org Sent: Thu, 16 Apr 2009 08:01:21 -0400 Subject: Re: [ACFUG Discuss] creating a web service with cf sure - but you need to decide on a data format. does php support cf query type? i doubt it - you will likely need to change the query to an array. Dusty Hale du...@dustyhale.com mailto:du...@dustyhale.com Sent by: ad...@acfug.org mailto:ad...@acfug.org 04/16/2009 01:02 AM Please respond to discussion@acfug.org mailto:discussion@acfug.org To discussion@acfug.org mailto:discussion@acfug.org cc Subject [ACFUG Discuss] creating a web service with cf I have a need which I think would be a good fit to create a web service but since I have never developed a web service I thought to get some other opinions. I have a site which is hosted on a Linux box with php and no CF. I need for part of this site to use a database and make a little admin app to manage it. Well I am lazy and don't want to do this with PHP and MySQL mainly because I know CF and SQL so I just want to do this with what I am used to. So my thought was that I could create a CFC that would act as a web service that the PHP site could call remotely. All it needs to do is get some data from the SQL server and display it in HTML. So I though I could generate the result HTML in the CFC and the PHP site could call it remotely. Again the PHP site is not on the same server as the CFC so it would be a remote call. This is basically what a web service is for right? Would this approach work? Thanks so much in advance for any replies. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA
Re: [ACFUG Discuss] Images as Checkboxes
I did this years ago using JavaScript. I don't have that code handy but I can sort of explain it: You use the onclick event handler in JS to swap the images out and set a JS variable to true or false and then also use JS to submit and pass that variable along. Dusty On Fri, Mar 27, 2009 at 2:38 PM, Cody Wehunt c...@wehunt.net wrote: I was thinking about something, and I am not sure if I have ever seen it or not. Can anyone make recommendations on a control or a way to make images act like check boxes? Thanks, Cody - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
[ACFUG Discuss] creating a web service with cf
I have a need which I think would be a good fit to create a web service but since I have never developed a web service I thought to get some other opinions. I have a site which is hosted on a Linux box with php and no CF. I need for part of this site to use a database and make a little admin app to manage it. Well I am lazy and don't want to do this with PHP and MySQL mainly because I know CF and SQL so I just want to do this with what I am used to. So my thought was that I could create a CFC that would act as a web service that the PHP site could call remotely. All it needs to do is get some data from the SQL server and display it in HTML. So I though I could generate the result HTML in the CFC and the PHP site could call it remotely. Again the PHP site is not on the same server as the CFC so it would be a remote call. This is basically what a web service is for right? Would this approach work? Thanks so much in advance for any replies. Dusty
Re: [ACFUG Discuss] Looking for a CF Host
I second the recommendation on Google Apps. I've used for a year or so and it has been a blessing for me. I was under the impression it is not free anymore though since it is no longer in Beta. Am I missing something about that. I got in when it was still in Beta and it still runs great for me at no cost. Dusty On Mon, Mar 9, 2009 at 4:11 PM, Howard Fore howard.f...@hofo.com wrote: By email if you mean that you're looking to host the domain's email at the same place, I'd suggest instead that you use Google Apps for the email. Free for under 25 accounts per domain, easy, and if your webhost happens to go down for technical reasons, you still have your email. http://google.com/a/ -- Howard Fore, howard.f...@hofo.com The universe tends toward maximum irony. Don't push it. - Jeff Atwood On Mon, Mar 9, 2009 at 3:11 PM, PEYTONTODD07 peytont...@comcast.netwrote: Hi all, I will be looking soon for a host for a small CF site I'll be writing. The main consideration at this point is cost, since the site is likely to involve nothing more complicated than data (e.g. SQL Server), passwords, and e-mail. Any suggestions? Thanks, Peyton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Website: www.DustyHale.com Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754
Re: re[2]: [ACFUG Discuss] excel or csv to database table
Just a quick note back to Charlie: Thanks again for the good advice. Although I never messed with cfhttp getting it to work with .csv, I was able to use the information you sent me on configuring DSN for text files and my app is now working great with it. Also thanks again for providing a good resource like cf411. Kind regards, Dusty On Thu, Mar 12, 2009 at 5:19 PM, Dusty Hale du...@climbonline.com wrote: Another reason I like this approach better: Using the cfquery tag as oppose to cfhttp allows me to use the cachedwithin attribute and since it is the same results all the time, it will be less overhead (again I assume). Dusty On Thu, Mar 12, 2009 at 5:15 PM, Dusty Hale du...@climbonline.com wrote: Sweet thanks for the reminder about that. I set up a DSN and CF datasource for the text files and works great. I personally like this approach better than the cfhttp tag because I think it will be easier to keep the files outside of the webroot. Also it solves the .csv problem at the same time (i think :-) Thanks again for your very good advice and help. Dusty On Thu, Mar 12, 2009 at 2:55 PM, Charlie Arehart char...@carehart.orgwrote: Well, Dusty, the blog entry I’d pointed to (in a note on Monday) was from 2002. It uses a feature (from CF5, no longer available) to do DSN-less connections, thus the connectstring. Instead, use the more recent entry by Mark Kruger, which I pointed to below in a more recent note. Also, what about the more significant point I was making: that your attempt to use CFHTTP with a csv file failed (when a txt worked) because of a likely web server problem? PS Thanks, Shane, for your thoughts on the other thread. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Thursday, March 12, 2009 8:56 AM *To:* discussion@acfug.org *Subject:* Re: re[2]: [ACFUG Discuss] excel or csv to database table Hi Charlie and many thanks for the good advice. I got curious about running real queries on text files. I have done this some years ago using a DSN. I looked over your blog post on the zip code data. When I try to use this approach though I get the following error that the attribute connectstring does not exist for the cfquery tag (strange). The tag does not have an attribute called connectstring. The valid attribute(s) are name, datasource, dbtype, sql, username, password, maxrows, blockfactor, timeout, dbname, cachedafter, cachedwithin, result, debug. On Mon, Mar 9, 2009 at 6:54 PM, Charlie Arehart char...@carehart.org wrote: Dusty, I wonder if your problem isn’t a CF one, but a web server one. I’d bet when you try to retrieve the file as a CSV, the web server steps in and changes the mime type to something other than plain text, and therefore CF (and the CFHTTP) gets something other than what they expected. (BTW, that code you show below doesn’t come from my site, per se, but maybe you got it from a link off of it). I just ran a test of some working code (adapted from an example Ben Nadel put together). It works fine for me, whether file is called .txt or .csv. I’ve attached the files here. Do they work for you (may need to adjust the url in the cfm page)? If not, then I’d think the web server is your issue. (You could also request the CSV in your browser, or—to remove browser processing from the analysis--do your CFHTTP without the NAME attribute, which then just reads it as a text file. Dump the entire CFHTTP scope, to see the cfhttp.mimetype. Anyway, here’s a simpler way to read in a CSV as a database (one I do link to from my CF411 site, and which would be easier than the older approach I mentioned in my last note), which doesn’t rely on CFHTTP or then get bothered by any web server mapping issues: http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv Hope that’s helpful. /charlie - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com -
Re: re[2]: [ACFUG Discuss] excel or csv to database table
Hi Charlie and many thanks for the good advice. I got curious about running real queries on text files. I have done this some years ago using a DSN. I looked over your blog post on the zip code data. When I try to use this approach though I get the following error that the attribute connectstring does not exist for the cfquery tag (strange). The tag does not have an attribute called connectstring. The valid attribute(s) are name, datasource, dbtype, sql, username, password, maxrows, blockfactor, timeout, dbname, cachedafter, cachedwithin, result, debug. On Mon, Mar 9, 2009 at 6:54 PM, Charlie Arehart char...@carehart.orgwrote: Dusty, I wonder if your problem isn’t a CF one, but a web server one. I’d bet when you try to retrieve the file as a CSV, the web server steps in and changes the mime type to something other than plain text, and therefore CF (and the CFHTTP) gets something other than what they expected. (BTW, that code you show below doesn’t come from my site, per se, but maybe you got it from a link off of it). I just ran a test of some working code (adapted from an example Ben Nadel put together). It works fine for me, whether file is called .txt or .csv. I’ve attached the files here. Do they work for you (may need to adjust the url in the cfm page)? If not, then I’d think the web server is your issue. (You could also request the CSV in your browser, or—to remove browser processing from the analysis--do your CFHTTP without the NAME attribute, which then just reads it as a text file. Dump the entire CFHTTP scope, to see the cfhttp.mimetype. Anyway, here’s a simpler way to read in a CSV as a database (one I do link to from my CF411 site, and which would be easier than the older approach I mentioned in my last note), which doesn’t rely on CFHTTP or then get bothered by any web server mapping issues: http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv Hope that’s helpful. /charlie PS I’d like to add, since someone said they didn’t realize it, that this sort of troubleshooting is indeed what I do for a living. I’m happy to answer questions free here on the list, as I do so often. But I just want to note that if someone ever is in a pinch and doesn’t want to wait for free answers, or doesn’t want to publicize their problem, or it may be too much to communicate in email, I’m available for as little time as may be needed to solve a problem. More at carehart.org/consulting/. *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Monday, March 09, 2009 3:15 PM *To:* discussion@acfug.org *Subject:* Re: re[2]: [ACFUG Discuss] excel or csv to database table Thanks again. I tried the approach below which was recommended on cf411.com. It works as long as the file extension is .txt. When using the .csv extension, it throws an error Variable onerow does not exist. I am fine with just using the .txt extention but if anyone has any clue why or how I could use a .csv extension, I would love to hear it. Thanks again for the replies. It always helps to hear others opinions. Dusty *Building a query from a delimited text file* The cfhttp tag can create a ColdFusion query object form the response body. To do so, the response body must consist of lines of text, with each line having fields that are delimited by a character that identifies the column breaks. The default delimiter is a comma (,). The response data can also use a text qualifier; the default is a double-quotation mark (). If you surround a string field in the text qualifier, the field can contain the delimiter character. To include the text qualifier in field text, escape it by using a double character. The following line shows a two-line request body that is converted into a query. It has three comma-delimited fields: Field1,Field2,Field3 A comma, in text,A quote: Oh My!,Plain text Run the following code to show how ColdFusion treats this data: cfhttp method=Get url=127.0.0.1:8500/tests/escapetest.txt name=onerow cfdump var=#onerow#br - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Website: www.DustyHale.com Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754
Re: re[2]: [ACFUG Discuss] excel or csv to database table
Sweet thanks for the reminder about that. I set up a DSN and CF datasource for the text files and works great. I personally like this approach better than the cfhttp tag because I think it will be easier to keep the files outside of the webroot. Also it solves the .csv problem at the same time (i think :-) Thanks again for your very good advice and help. Dusty On Thu, Mar 12, 2009 at 2:55 PM, Charlie Arehart char...@carehart.orgwrote: Well, Dusty, the blog entry I’d pointed to (in a note on Monday) was from 2002. It uses a feature (from CF5, no longer available) to do DSN-less connections, thus the connectstring. Instead, use the more recent entry by Mark Kruger, which I pointed to below in a more recent note. Also, what about the more significant point I was making: that your attempt to use CFHTTP with a csv file failed (when a txt worked) because of a likely web server problem? PS Thanks, Shane, for your thoughts on the other thread. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Thursday, March 12, 2009 8:56 AM *To:* discussion@acfug.org *Subject:* Re: re[2]: [ACFUG Discuss] excel or csv to database table Hi Charlie and many thanks for the good advice. I got curious about running real queries on text files. I have done this some years ago using a DSN. I looked over your blog post on the zip code data. When I try to use this approach though I get the following error that the attribute connectstring does not exist for the cfquery tag (strange). The tag does not have an attribute called connectstring. The valid attribute(s) are name, datasource, dbtype, sql, username, password, maxrows, blockfactor, timeout, dbname, cachedafter, cachedwithin, result, debug. On Mon, Mar 9, 2009 at 6:54 PM, Charlie Arehart char...@carehart.org wrote: Dusty, I wonder if your problem isn’t a CF one, but a web server one. I’d bet when you try to retrieve the file as a CSV, the web server steps in and changes the mime type to something other than plain text, and therefore CF (and the CFHTTP) gets something other than what they expected. (BTW, that code you show below doesn’t come from my site, per se, but maybe you got it from a link off of it). I just ran a test of some working code (adapted from an example Ben Nadel put together). It works fine for me, whether file is called .txt or .csv. I’ve attached the files here. Do they work for you (may need to adjust the url in the cfm page)? If not, then I’d think the web server is your issue. (You could also request the CSV in your browser, or—to remove browser processing from the analysis--do your CFHTTP without the NAME attribute, which then just reads it as a text file. Dump the entire CFHTTP scope, to see the cfhttp.mimetype. Anyway, here’s a simpler way to read in a CSV as a database (one I do link to from my CF411 site, and which would be easier than the older approach I mentioned in my last note), which doesn’t rely on CFHTTP or then get bothered by any web server mapping issues: http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv Hope that’s helpful. /charlie - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Website: www.DustyHale.com Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754
Re: re[2]: [ACFUG Discuss] excel or csv to database table
Another reason I like this approach better: Using the cfquery tag as oppose to cfhttp allows me to use the cachedwithin attribute and since it is the same results all the time, it will be less overhead (again I assume). Dusty On Thu, Mar 12, 2009 at 5:15 PM, Dusty Hale du...@climbonline.com wrote: Sweet thanks for the reminder about that. I set up a DSN and CF datasource for the text files and works great. I personally like this approach better than the cfhttp tag because I think it will be easier to keep the files outside of the webroot. Also it solves the .csv problem at the same time (i think :-) Thanks again for your very good advice and help. Dusty On Thu, Mar 12, 2009 at 2:55 PM, Charlie Arehart char...@carehart.orgwrote: Well, Dusty, the blog entry I’d pointed to (in a note on Monday) was from 2002. It uses a feature (from CF5, no longer available) to do DSN-less connections, thus the connectstring. Instead, use the more recent entry by Mark Kruger, which I pointed to below in a more recent note. Also, what about the more significant point I was making: that your attempt to use CFHTTP with a csv file failed (when a txt worked) because of a likely web server problem? PS Thanks, Shane, for your thoughts on the other thread. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Thursday, March 12, 2009 8:56 AM *To:* discussion@acfug.org *Subject:* Re: re[2]: [ACFUG Discuss] excel or csv to database table Hi Charlie and many thanks for the good advice. I got curious about running real queries on text files. I have done this some years ago using a DSN. I looked over your blog post on the zip code data. When I try to use this approach though I get the following error that the attribute connectstring does not exist for the cfquery tag (strange). The tag does not have an attribute called connectstring. The valid attribute(s) are name, datasource, dbtype, sql, username, password, maxrows, blockfactor, timeout, dbname, cachedafter, cachedwithin, result, debug. On Mon, Mar 9, 2009 at 6:54 PM, Charlie Arehart char...@carehart.org wrote: Dusty, I wonder if your problem isn’t a CF one, but a web server one. I’d bet when you try to retrieve the file as a CSV, the web server steps in and changes the mime type to something other than plain text, and therefore CF (and the CFHTTP) gets something other than what they expected. (BTW, that code you show below doesn’t come from my site, per se, but maybe you got it from a link off of it). I just ran a test of some working code (adapted from an example Ben Nadel put together). It works fine for me, whether file is called .txt or .csv. I’ve attached the files here. Do they work for you (may need to adjust the url in the cfm page)? If not, then I’d think the web server is your issue. (You could also request the CSV in your browser, or—to remove browser processing from the analysis--do your CFHTTP without the NAME attribute, which then just reads it as a text file. Dump the entire CFHTTP scope, to see the cfhttp.mimetype. Anyway, here’s a simpler way to read in a CSV as a database (one I do link to from my CF411 site, and which would be easier than the older approach I mentioned in my last note), which doesn’t rely on CFHTTP or then get bothered by any web server mapping issues: http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv Hope that’s helpful. /charlie - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Website: www.DustyHale.com Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 -- Dusty Hale Website: www.DustyHale.com Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754
Re: [ACFUG Discuss] excel or csv to database table
Many thanks Charlie. I just got in the office and read this. Honestly I have been out of the ACFUG loop for a bit and completely forgot about these resources. So I will give this some loving :-) ... My other thought would be ask if you think it would be ok to just use the files themselves as the database rather than import and use MS SQL. This way the files could just be uploaded to the server and overwritten when they need to be updated. There are basically 5 files with some location data in it that are used for a specialized dealer locator app. My thought was maybe I could just read the files into a select query and then loop the query to filter the records to be displayed. There will never be more than several hundred records in the excel files. However the site that will use it may have a fair amount of traffic so I didn't know if reading the files might become a problem. Perhaps I could read them into a cached query to solve that problem? Does anyone see any reason why this approach would not work? Dusty On Fri, Mar 6, 2009 at 4:23 PM, Charlie Arehart char...@carehart.orgwrote: No love from anyone for CF411. :-( How can I get people to say, whenever anyone asks “what tools are there to do xyz”, to tell them to check out cf411.com. I’m not selling anything there. :-) It exists precisely to help with these questions. Dusty, check out: Excel File Processing Tools http://www.cf411.com/#excel for several different kinds and dozens of different resources for doing CF/Excel processing, in both directions. I realize you may wonder if I can say which of these many excel approaches would be best for what you need, but I’m afraid I can’t vouch for any. With 700+ tools/resources on the list (in 125+ categories), I really can’t use them all. But I do offer brief descriptions and links, which should help you consider the options. (I also did an article presenting this info in the last FAQU, in my back page column, if you have that.) Hope that’s helpful. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Friday, March 06, 2009 9:31 AM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] excel or csv to database table Hi I need to implement some CF code that does this and before I write all the code, I thought certainly there has got to be a custom tag or cfc that already does this: 1. Upload excel or csv file to server. 2. Import the excel sheet or csv file into a database table. I found an upload custom tag and now I am looking for any advise or recommendation on a custom tag or cfc or piece of code that will handle the import part. If anyone knows of a good solution for this, please share. Much appreciation! Thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Website: www.DustyHale.com Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754
Re: re[2]: [ACFUG Discuss] excel or csv to database table
Thanks again. I tried the approach below which was recommended on cf411.com. It works as long as the file extension is .txt. When using the .csv extension, it throws an error Variable onerow does not exist. I am fine with just using the .txt extention but if anyone has any clue why or how I could use a .csv extension, I would love to hear it. Thanks again for the replies. It always helps to hear others opinions. Dusty *Building a query from a delimited text file* The cfhttp tag can create a ColdFusion query object form the response body. To do so, the response body must consist of lines of text, with each line having fields that are delimited by a character that identifies the column breaks. The default delimiter is a comma (,). The response data can also use a text qualifier; the default is a double-quotation mark (). If you surround a string field in the text qualifier, the field can contain the delimiter character. To include the text qualifier in field text, escape it by using a double character. The following line shows a two-line request body that is converted into a query. It has three comma-delimited fields: Field1,Field2,Field3 A comma, in text,A quote: Oh My!,Plain text Run the following code to show how ColdFusion treats this data: cfhttp method=Get url=127.0.0.1:8500/tests/escapetest.txt name=onerow cfdump var=#onerow#br On Mon, Mar 9, 2009 at 2:11 PM, Mischa Uppelschoten ext 10 mischa.uppelscho...@bankersx.com wrote: : My other thought would be ask if you think it would be ok to just use the : files themselves as the database rather than import and use MS SQL. This way : the files could just be uploaded to the server and overwritten when they need : to be updated. There are basically 5 files with some location data in it that : are used for a specialized dealer locator app. My thought was maybe I could : just read the files into a select query and then loop the query to filter the : records to be displayed. There will never be more than several hundred : records in the excel files. However the site that will use it may have a fair : amount of traffic so I didnt know if reading the files might become a : problem. Perhaps I could read them into a cached query to solve that problem? : I have a similar situation where my excel file updates a few times per week and I need to read it just once and the format does not change: you can define an ODBC DSN to the file and read that from CF like any other true database. After the definition is done and is working (inspect the schema.ini file, it will make sense once you look at it), you could even just replace the excel file with a new version without doing anything else. Only drawback I can think of is that it's slightly more difficult to combine your excel data with any data housed on your db server if you don't truly insert it in a table. /m - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com- -- Dusty Hale Website: www.DustyHale.com Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754
Re: [ACFUG Discuss] excel or csv to database table
Thanks Blake I did glance at this blog post. My needs are very basic though. Just a simple read of the csv file and import its records into a db table. I'm not opposed to just writing some of my own code for this but just thought there might be something really quick and easy to use. This post seems to focus on doing the exact opposite of what I need (query to spreadsheet). I'm still on the hunt for a quick solution but if I don't come up with something super easy and quick to use, I think I may just roll my own code out. Thanks again, Dsuty On Fri, Mar 6, 2009 at 9:42 AM, bki...@ups.com wrote: Dusty, I have used the Java POI tool in the past. It's easy to implement, it is very fast (even at thousands of records and multiple worksheets) at reading/building an excel document. I found this link on Ben Nadel's blog, he has built a nice cfc utility to do the work for you, you may just have change a few mappings. http://www.bennadel.com/blog/469-Creating-Microsoft-Excel-Files-Using-ColdFusion-And-POI.htm You should definitely be able to use it to read the excel file and then insert into the db, as far as a custom tag to do both (file upload read), I do not have that. If you don't specifially need the file you can use the POI utility to read it on the fly and then import. Blake Blake Kiser UPS - Business Information Analysis SCS - S530A 12380 Morris Rd. Alpharetta, GA 30005 (678) 746-4679, atlas 480-4679 -- *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale *Sent:* Friday, March 06, 2009 9:31 AM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] excel or csv to database table Hi I need to implement some CF code that does this and before I write all the code, I thought certainly there has got to be a custom tag or cfc that already does this: 1. Upload excel or csv file to server. 2. Import the excel sheet or csv file into a database table. I found an upload custom tag and now I am looking for any advise or recommendation on a custom tag or cfc or piece of code that will handle the import part. If anyone knows of a good solution for this, please share. Much appreciation! Thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Dusty Hale Website: www.DustyHale.com Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754
[ACFUG Discuss] wireframes and prototype
Back in the day I used to use Fusebox 3 and to get it started often times wireframing and prototyping. I was wondering if folks out there are still doing this? If any new wireframe or prototype tools are available? I think I am about to dive into a new project and start out with some wireframing and move to a prototype first. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] Saving DW settings
Has anyone used the method below to save DW settings and sites in order to port over to a new install? Just want to make sure it works before I try it. -- Saving Dreamweaver settings _ I need to reformat my hdd and reload the os and programs. Is there a way to save all the settings (i.e remote server details and other site and preference settings) in one place so that they can be easily reintroduced into Dreamweaver after it has been reinstalled. I couldn't see an appropriate folder for this in the Dreamweaver Application Data folders. Thanks. # http://www.webdeveloper.com/forum/showpost.php?p=701921postcount=2 2 Old http://www.webdeveloper.com/forum/images/statusicon/post_old.gif 01-23-2007, 04:57 PM http://www.webdeveloper.com/forum/member.php?u=58110 sticks464 sticks464 is offline http://www.webdeveloper.com/forum/images/statusicon/user_offline.gif Registered User Join Date: Apr 2006 Posts: 221 Dreamweaver _ To save your configuration it has to be done outside Dreamweaver. You want to backup your configuration files to disk (cd). Go to Documents and Settings/main user/Application Data/Macromedia/Dreamweaver 8 (or whatever version you have) and copy the configuration folder to a cd. Then after reformating and reinstalling Dreamweaver, replace the configuration folder with the one you saved. The main user is the user with the macromedia configuration files in it. Under Documents and Settings there may be 2-4 users and you want the main user(the name on mine is HP_Administrator). - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - post_old.gifuser_offline.gif
RE: [ACFUG Discuss] CFMAIL issue
It might be that the email server you specified requires authentication. Are you passing the username and password of the email account your trying to send mail from? cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] server=mail.joe.com username=[EMAIL PROTECTED] password=foo Testing 123 ... /cfmail _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: 06/23/2008 1:10 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CFMAIL issue Can anyone tell me where to look if I'm having issues with mail not being sent. I've gone through the Administrator and verified my mail server connection (Connection Verification Successful) but emails are not being sent. I look in the log files and there are no log entries mail.log, mailsent.log for the test email I am trying to send. Are there settings that I'm missing somewhere? I'm trying to fix and application that is supposed to be emailing reports daily. The developer that was working on it was let go and the application quit sending the daily emails. I've been tasked with correcting the issue and time is critical. Any ideas would be greatly appreciated. Thanks, Jeff - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CFMAIL issue
you might need to add the username and password attributes to your cfmail tag. Most email servers require authentication and if not they should. Otherwise anyone could use the email server to send out spam and other junk. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: 06/23/2008 2:01 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CFMAIL issue Thanks for the quick responses. Here is the version information: Server Details Server Product ColdFusion MX Version 7,0,2,142559 Edition Standard Serial Number CPD700-57133-17219-06784 Operating System Windows 2003 OS Version 5.2 and this is the simple sample code I'm running CFMAIL to = [EMAIL PROTECTED] from = [EMAIL PROTECTED] subject = test email failto=[EMAIL PROTECTED] type=html server=123.456.789.98 port=25 THIS IS A TEST EMAIL. /CFMAIL The email works fine on the dev server but not on the production server. There are 8 different reports that are all scheduled. I have run the directly in the browser and there are no errors being thrown. Nothing is being written to the logs, but I have not looked in those directories. I'll request access and check them out. Thanks again. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] column contains (quotes) and comma ,
try this: input type=text name=xyz value='#xyz#' size=15 I think that might do what your asking. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajas Mohammed Sent: 06/12/2008 4:26 PM To: discussion@acfug.org Subject: [ACFUG Discuss] column contains (quotes) and comma , Hi, I am displaying result set from a query in form fields like this, where column xyz contains value like this ajas, mohd i.e. with the quotes and comma. tdinput type=text name=xyz value=#xyz# size=15/td The form doesnt not show the contents of the column because of the quotes. So I am using replace function to remove the quotes. This works fine. See below. tdinput type=text name=xyz value=#Replace(xyz,,,All)# size=15/td This results in ajas,mohd being shown in the text form field. How do I make the column xyz's value to appear in form field with quotes without using the replace function. Any ideas? Or Do I have to tell client not to send values with quotes going forward? -- Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] column contains (quotes) and comma ,
of course this example may have problems too. It's not valid code for one thing and you might have the same problem with single quotes. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: 06/12/2008 4:31 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] column contains (quotes) and comma , try this: input type=text name=xyz value='#xyz#' size=15 I think that might do what your asking. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajas Mohammed Sent: 06/12/2008 4:26 PM To: discussion@acfug.org Subject: [ACFUG Discuss] column contains (quotes) and comma , Hi, I am displaying result set from a query in form fields like this, where column xyz contains value like this ajas, mohd i.e. with the quotes and comma. tdinput type=text name=xyz value=#xyz# size=15/td The form doesnt not show the contents of the column because of the quotes. So I am using replace function to remove the quotes. This works fine. See below. tdinput type=text name=xyz value=#Replace(xyz,,,All)# size=15/td This results in ajas,mohd being shown in the text form field. How do I make the column xyz's value to appear in form field with quotes without using the replace function. Any ideas? Or Do I have to tell client not to send values with quotes going forward? -- Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Coldfusion server Host
I use hostmysite.com. They're probably a little more cost but service is really good. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Forrest C. Gilmore Sent: 06/10/2008 11:34 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Coldfusion server Host I am using Hostek.com. They are very low cost but give great service and performance. Forrest C. Gilmore = xman30097 wrote: Hi Guys, Can anybody provide some good ColdFusion Server Hosting company information? Thanks in advance. Xiaojun Jiang - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
I found a work around for now by creating a copy of the live database on my VPS server at HostMySite. Not a great way to develop but will get me by for now. I think you're right the best thing would be to just install express. I just wonder how I ended up installing the eval in the first place LOL. My only thought was that if I purchased a license and applied it to the eval, then I could revive the database. If I install express, I don't think it has any kind of import export abilities so I wasn't yet sure how I would pull down the data from the live database. I have a license for Red Gate so I will likely install that and use it to synch the data. Thanks everyone for listening to my desperate pleas for help. I suppose it could be much worse LOL. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/10/2008 12:51 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Yes, that's my understanding too. But why not just install the free SQL Express edition? Is it that your bandwidth is enough for email but not a large download? (Or maybe you're writing from your phone?) I think you may find that you can't apply a license to SQL Server to update the eval edition to purchase. I seem to recall running into that hassle once before, but hopefully someone will have better news. You mentioned fearing you'd need to buy a new machine or fly back if you couldn't resolve this: isn't there some way to get good bandwidth, even at some dear cost, to do the download? /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 10, 2008 10:47 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I think the cost for a developer license of SQL Server is in the neighborhood of $50 - and it's the equivalent of enterprise. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Tuesday, June 10, 2008 10:28 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Haha poor little me in Costa. Yes beautiful country. I'm in Tamarindo shooting surfing photos (my side job) and trying to carry on development at the same time. I could have sworn I installed SQL Express but I think you are right because it doesn't say express in the event viewer. It might be easier for me to just pay the license rather than having to uninstall, reinstall, then piece the database back together (being that I can't get to it now). I can't seem to figure out how to just purchase the license though. Hopefully there is a development price. Do you know anything about this? Many thanks for your help. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/10/2008 9:52 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Are you sure that's SQL Server Express? Yes, it should be free with no eval period. It sure sounds like it's the full version (not the express). Does the error in Event Viewer identify the source as the express edition? In my machine, it shows specifically as MSSQL$SQLEXPRESS? I see a couple other instances of people asserting your problem, and they said their only solution was to remove and reinstall. I really wonder though if they are really looking at errors from the Express edition. I'll trust your reply to confirm things in your case. :-) If you have no choice, are you able to uninstall/reinstall? BTW, though I received this before your other note about being desperate in Costa Rica (a seeming contradiction for such a beautiful country), I see that you sent this 2nd, so it seems you've at least targeted the real source of the problem, right? Glad that the suggestion to look in event viewer helped. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Monday, June 09, 2008 9:28 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I checked event viewer under application. The errors for SQL say the evaluation period is over. I'm using SQL express though and thought it was free. Does this sound right? Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/09/2008 8:47 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Are you looking in the Windows Event Viewer, or SQL Server log files, to get more info? Also, as for your info on running multiple IIS sites on XP, there are still other ways including the free tool IISAdmin, at http://www.firstserved.net/help/downloads. Doesn't get around the limitation of *running* more than one at a time, but at least is an interface option over the command line option below. Hope that helps someone. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
Charlie do you happen to know the default location of the data files? I can't seem to locate the file. I also search with Windows desktop search but no luck yet. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/11/2008 11:47 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Well, if you install Express on the same machine that had the eval, the new Express edition could read the SQL Server files (MDF, LDF) that were created there. No need to import/export. You'd just create the DB new in Express but point it at the existing files. I'm pretty sure that would work. Anyone know for sure? /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Wednesday, June 11, 2008 11:04 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I found a work around for now by creating a copy of the live database on my VPS server at HostMySite. Not a great way to develop but will get me by for now. I think you're right the best thing would be to just install express. I just wonder how I ended up installing the eval in the first place LOL. My only thought was that if I purchased a license and applied it to the eval, then I could revive the database. If I install express, I don't think it has any kind of import export abilities so I wasn't yet sure how I would pull down the data from the live database. I have a license for Red Gate so I will likely install that and use it to synch the data. Thanks everyone for listening to my desperate pleas for help. I suppose it could be much worse LOL. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
I will definitely try that and let you know if it works. It will likely be a day or two before I get around to it. Can't thank you enough for the suggestions. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/11/2008 11:47 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Well, if you install Express on the same machine that had the eval, the new Express edition could read the SQL Server files (MDF, LDF) that were created there. No need to import/export. You'd just create the DB new in Express but point it at the existing files. I'm pretty sure that would work. Anyone know for sure? /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Wednesday, June 11, 2008 11:04 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I found a work around for now by creating a copy of the live database on my VPS server at HostMySite. Not a great way to develop but will get me by for now. I think you're right the best thing would be to just install express. I just wonder how I ended up installing the eval in the first place LOL. My only thought was that if I purchased a license and applied it to the eval, then I could revive the database. If I install express, I don't think it has any kind of import export abilities so I wasn't yet sure how I would pull down the data from the live database. I have a license for Red Gate so I will likely install that and use it to synch the data. Thanks everyone for listening to my desperate pleas for help. I suppose it could be much worse LOL. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
Actually it appears that I may already have it installed because Outlook Business Manager uses it. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/11/2008 11:47 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Well, if you install Express on the same machine that had the eval, the new Express edition could read the SQL Server files (MDF, LDF) that were created there. No need to import/export. You'd just create the DB new in Express but point it at the existing files. I'm pretty sure that would work. Anyone know for sure? /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Wednesday, June 11, 2008 11:04 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I found a work around for now by creating a copy of the live database on my VPS server at HostMySite. Not a great way to develop but will get me by for now. I think you're right the best thing would be to just install express. I just wonder how I ended up installing the eval in the first place LOL. My only thought was that if I purchased a license and applied it to the eval, then I could revive the database. If I install express, I don't think it has any kind of import export abilities so I wasn't yet sure how I would pull down the data from the live database. I have a license for Red Gate so I will likely install that and use it to synch the data. Thanks everyone for listening to my desperate pleas for help. I suppose it could be much worse LOL. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
Hey disregard that I found them. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: 06/11/2008 12:11 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Charlie do you happen to know the default location of the data files? I can't seem to locate the file. I also search with Windows desktop search but no luck yet. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/11/2008 11:47 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Well, if you install Express on the same machine that had the eval, the new Express edition could read the SQL Server files (MDF, LDF) that were created there. No need to import/export. You'd just create the DB new in Express but point it at the existing files. I'm pretty sure that would work. Anyone know for sure? /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Wednesday, June 11, 2008 11:04 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I found a work around for now by creating a copy of the live database on my VPS server at HostMySite. Not a great way to develop but will get me by for now. I think you're right the best thing would be to just install express. I just wonder how I ended up installing the eval in the first place LOL. My only thought was that if I purchased a license and applied it to the eval, then I could revive the database. If I install express, I don't think it has any kind of import export abilities so I wasn't yet sure how I would pull down the data from the live database. I have a license for Red Gate so I will likely install that and use it to synch the data. Thanks everyone for listening to my desperate pleas for help. I suppose it could be much worse LOL. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
SQL Studio Express doesn't seem to let me change the file names to point to the data files. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/11/2008 11:47 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Well, if you install Express on the same machine that had the eval, the new Express edition could read the SQL Server files (MDF, LDF) that were created there. No need to import/export. You'd just create the DB new in Express but point it at the existing files. I'm pretty sure that would work. Anyone know for sure? /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Wednesday, June 11, 2008 11:04 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I found a work around for now by creating a copy of the live database on my VPS server at HostMySite. Not a great way to develop but will get me by for now. I think you're right the best thing would be to just install express. I just wonder how I ended up installing the eval in the first place LOL. My only thought was that if I purchased a license and applied it to the eval, then I could revive the database. If I install express, I don't think it has any kind of import export abilities so I wasn't yet sure how I would pull down the data from the live database. I have a license for Red Gate so I will likely install that and use it to synch the data. Thanks everyone for listening to my desperate pleas for help. I suppose it could be much worse LOL. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] OT: problem with IIS on XP Pro.
Hi I used the method below to run multiple sites in IIS on XP Pro. It has always worked fine until today. Now the extra site I have always been able to use is not working. The default site still works fine. All other I get the generic Cannot find server error. If anyone know why this might be happening or a remedy for it, I would greatly appreciate it. I already tried deleting the second site and recreating it but same thing happens. The only other thing I know to do is maybe uninstall IIS completely and reinstall it and try again. In the server versions of Windows, you can have multiple versions of web sites installed into IIS and running simultaneously. You can install and run more than one web site within IIS in the professional version of Windows XP or Windows 2000. You just have to pull a trick to modify the IIS metabase to that it is aware of the additional sites. The user interface does not support creating more than one web site. Also, you still will not be able to have more than one site running at the same time. To create the second web site: * Create a command prompt window. * Type cd \Inetpub\Adminscripts and press enter. * Find out what the highest numbered site you currently have is. You can do that by typing adsutil.vbs ENUM /P W3SVC If you have never done this process before, the highest numbered site should be 1. * Add one to the highest numbered site. Then run this command: adsutil.vbs COPY W3SVC/1 W3SVC/x Where x is replaced by the new numbered site. For example if you run the enum command and the highest numbered site is 4, then type this: adsutil.vbs COPY W3SVC/1 W3SVC/5 * Run the IIS Manager. You should find a new site has been created. It will be an exact copy of site #1, so you will need to change a few things. Go into the properties for the web site. Change the site name, and the virtual directory for the root of the web site to point to another location on the hard disk. Usually, you will create a new subdirectory under Inetpub and point the virtual directory at that. * To use the site, you must first stop the currently running site, then start the new site. To delete a site, first stop it if it is running (bad things happen if you don't!). Then type: adsutil.vbs DELETE W3SVC/x Where x is the number of the site you want to delete. - Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
ok I feel like a goof ball. It seems CF service is stopping itself for some reason so it has nothing to do with IIS. If anyone know why CF and SQL would stop by themselves? _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: 06/09/2008 3:27 PM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: problem with IIS on XP Pro. Hi I used the method below to run multiple sites in IIS on XP Pro. It has always worked fine until today. Now the extra site I have always been able to use is not working. The default site still works fine. All other I get the generic Cannot find server error. If anyone know why this might be happening or a remedy for it, I would greatly appreciate it. I already tried deleting the second site and recreating it but same thing happens. The only other thing I know to do is maybe uninstall IIS completely and reinstall it and try again. In the server versions of Windows, you can have multiple versions of web sites installed into IIS and running simultaneously. You can install and run more than one web site within IIS in the professional version of Windows XP or Windows 2000. You just have to pull a trick to modify the IIS metabase to that it is aware of the additional sites. The user interface does not support creating more than one web site. Also, you still will not be able to have more than one site running at the same time. To create the second web site: * Create a command prompt window. * Type cd \Inetpub\Adminscripts and press enter. * Find out what the highest numbered site you currently have is. You can do that by typing adsutil.vbs ENUM /P W3SVC If you have never done this process before, the highest numbered site should be 1. * Add one to the highest numbered site. Then run this command: adsutil.vbs COPY W3SVC/1 W3SVC/x Where x is replaced by the new numbered site. For example if you run the enum command and the highest numbered site is 4, then type this: adsutil.vbs COPY W3SVC/1 W3SVC/5 * Run the IIS Manager. You should find a new site has been created. It will be an exact copy of site #1, so you will need to change a few things. Go into the properties for the web site. Change the site name, and the virtual directory for the root of the web site to point to another location on the hard disk. Usually, you will create a new subdirectory under Inetpub and point the virtual directory at that. * To use the site, you must first stop the currently running site, then start the new site. To delete a site, first stop it if it is running (bad things happen if you don't!). Then type: adsutil.vbs DELETE W3SVC/x Where x is the number of the site you want to delete. - Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
So now that I figured out CF was stopping and causing this, I have that going again. But SQL will not start. Everytime I try to push the start button I get an error that says sometimes services stop because they have no work to do. I've tried rebooting. Does anyone know why SQL would stop itself and then refuse to start again? _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: 06/09/2008 3:27 PM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: problem with IIS on XP Pro. Hi I used the method below to run multiple sites in IIS on XP Pro. It has always worked fine until today. Now the extra site I have always been able to use is not working. The default site still works fine. All other I get the generic Cannot find server error. If anyone know why this might be happening or a remedy for it, I would greatly appreciate it. I already tried deleting the second site and recreating it but same thing happens. The only other thing I know to do is maybe uninstall IIS completely and reinstall it and try again. In the server versions of Windows, you can have multiple versions of web sites installed into IIS and running simultaneously. You can install and run more than one web site within IIS in the professional version of Windows XP or Windows 2000. You just have to pull a trick to modify the IIS metabase to that it is aware of the additional sites. The user interface does not support creating more than one web site. Also, you still will not be able to have more than one site running at the same time. To create the second web site: * Create a command prompt window. * Type cd \Inetpub\Adminscripts and press enter. * Find out what the highest numbered site you currently have is. You can do that by typing adsutil.vbs ENUM /P W3SVC If you have never done this process before, the highest numbered site should be 1. * Add one to the highest numbered site. Then run this command: adsutil.vbs COPY W3SVC/1 W3SVC/x Where x is replaced by the new numbered site. For example if you run the enum command and the highest numbered site is 4, then type this: adsutil.vbs COPY W3SVC/1 W3SVC/5 * Run the IIS Manager. You should find a new site has been created. It will be an exact copy of site #1, so you will need to change a few things. Go into the properties for the web site. Change the site name, and the virtual directory for the root of the web site to point to another location on the hard disk. Usually, you will create a new subdirectory under Inetpub and point the virtual directory at that. * To use the site, you must first stop the currently running site, then start the new site. To delete a site, first stop it if it is running (bad things happen if you don't!). Then type: adsutil.vbs DELETE W3SVC/x Where x is the number of the site you want to delete. - Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
I checked event viewer under application. The errors for SQL say the evaluation period is over. I'm using SQL express though and thought it was free. Does this sound right? Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/09/2008 8:47 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Are you looking in the Windows Event Viewer, or SQL Server log files, to get more info? Also, as for your info on running multiple IIS sites on XP, there are still other ways including the free tool IISAdmin, at http://www.firstserved.net/help/downloads. Doesn't get around the limitation of *running* more than one at a time, but at least is an interface option over the command line option below. Hope that helps someone. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Monday, June 09, 2008 3:47 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. So now that I figured out CF was stopping and causing this, I have that going again. But SQL will not start. Everytime I try to push the start button I get an error that says sometimes services stop because they have no work to do. I've tried rebooting. Does anyone know why SQL would stop itself and then refuse to start again? _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: 06/09/2008 3:27 PM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: problem with IIS on XP Pro. Hi I used the method below to run multiple sites in IIS on XP Pro. It has always worked fine until today. Now the extra site I have always been able to use is not working. The default site still works fine. All other I get the generic Cannot find server error. If anyone know why this might be happening or a remedy for it, I would greatly appreciate it. I already tried deleting the second site and recreating it but same thing happens. The only other thing I know to do is maybe uninstall IIS completely and reinstall it and try again. In the server versions of Windows, you can have multiple versions of web sites installed into IIS and running simultaneously. You can install and run more than one web site within IIS in the professional version of Windows XP or Windows 2000. You just have to pull a trick to modify the IIS metabase to that it is aware of the additional sites. The user interface does not support creating more than one web site. Also, you still will not be able to have more than one site running at the same time. To create the second web site: . Create a command prompt window. . Type cd \Inetpub\Adminscripts and press enter. . Find out what the highest numbered site you currently have is. You can do that by typing . adsutil.vbs ENUM /P W3SVC If you have never done this process before, the highest numbered site should be 1. . Add one to the highest numbered site. Then run this command: . adsutil.vbs COPY W3SVC/1 W3SVC/x Where x is replaced by the new numbered site. For example if you run the enum command and the highest numbered site is 4, then type this: adsutil.vbs COPY W3SVC/1 W3SVC/5 . Run the IIS Manager. You should find a new site has been created. It will be an exact copy of site #1, so you will need to change a few things. Go into the properties for the web site. Change the site name, and the virtual directory for the root of the web site to point to another location on the hard disk. Usually, you will create a new subdirectory under Inetpub and point the virtual directory at that. . To use the site, you must first stop the currently running site, then start the new site. To delete a site, first stop it if it is running (bad things happen if you don't!). Then type: adsutil.vbs DELETE W3SVC/x Where x is the number of the site you want to delete. - Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile
RE: [ACFUG Discuss] CFLayout with Tabs and Forms
Yea I didn't mess around with it much. I figured there was probably a way to overcome that. Glad to hear you found it. Thanks and I may take you up on that sometime in the future. I'm on vacation this week and trying not to think about development LOL. I'm sitting here in a bar in Tamarindo, Costa Rica. Just finished a great day of surfing perfect waves :-) _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 06/02/2008 9:25 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFLayout with Tabs and Forms I have played with this as well. I dug into it and figured out how to modify the styles the tag produces. If you need more info on how to override the default styles, let me know Dusty Hale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/2008 12:34 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] CFLayout with Tabs and Forms I played around with it a little. Works great in FireFox. Very buggy in IE 6. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Fore Sent: 05/29/2008 10:53 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CFLayout with Tabs and Forms I haven't played with CFLayout but what you want to do is to call the submit method on the form in Javascript. So if the HTML has two forms, foo and bar, and you wanted to submit the foo form, you'd call document.foo.submit(). If the forms aren't named, you'll have to call them in the forms array like document.forms[1].submit(). Howard On Thu, May 29, 2008 at 9:51 PM, Clarke Bishop mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: So, now that I've figured out how to secure the page, I'm working on a multi-part form. I came across the new CFLayout tag in CF8 and it lets you setup a number of Tabs that can each contain different content. I already had my multi-part form broken into separate include files, so I just specified the include for each tab and it looks great! The only thing is I want to submit the included form whenever the tab changes. I found a way to add a listener and capture the TabChange event, but it seems to be adding multiple form objects to the DOM, and I haven't been able to find a way to submit the correct form yet. When I started playing with CFLayout, I wasn't planning to get sucked into Ajax/Spry. But, the tabs just look so cool! So, has anyone done anything like this? Also, any pointers on how to troubleshoot this kind of problem. I've started trying to use FireBug, but I still need to learn to use it better. Thanks for any ideas! Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com/ FusionLink - -- Howard Fore, mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] The universe tends toward maximum irony. Don't push it. - Jeff Atwood - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com/ FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com/ FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http
RE: [ACFUG Discuss] CFLayout with Tabs and Forms
I played around with it a little. Works great in FireFox. Very buggy in IE 6. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Fore Sent: 05/29/2008 10:53 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CFLayout with Tabs and Forms I haven't played with CFLayout but what you want to do is to call the submit method on the form in Javascript. So if the HTML has two forms, foo and bar, and you wanted to submit the foo form, you'd call document.foo.submit(). If the forms aren't named, you'll have to call them in the forms array like document.forms[1].submit(). Howard On Thu, May 29, 2008 at 9:51 PM, Clarke Bishop [EMAIL PROTECTED] wrote: So, now that I've figured out how to secure the page, I'm working on a multi-part form. I came across the new CFLayout tag in CF8 and it lets you setup a number of Tabs that can each contain different content. I already had my multi-part form broken into separate include files, so I just specified the include for each tab and it looks great! The only thing is I want to submit the included form whenever the tab changes. I found a way to add a listener and capture the TabChange event, but it seems to be adding multiple form objects to the DOM, and I haven't been able to find a way to submit the correct form yet. When I started playing with CFLayout, I wasn't planning to get sucked into Ajax/Spry. But, the tabs just look so cool! So, has anyone done anything like this? Also, any pointers on how to troubleshoot this kind of problem. I've started trying to use FireBug, but I still need to learn to use it better. Thanks for any ideas! Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Howard Fore, [EMAIL PROTECTED] The universe tends toward maximum irony. Don't push it. - Jeff Atwood - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] error handling
I was wondering if anyone wanted to discuss best approaches to error handling for cf sites. I want to implement some very basic error handling for one of my sites. Basically I just don't want the ugly cf errors to display for users of the site. I would also like to be notified via email when an error happens and better yet get the error information. Is the best approach still the cferror tag? Is there a newer or better approach or best practice? Anyone got some code they could share? Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Speed and resources: better to do client or session var?
I second that. I think however, and there is a big I think there that technically the request scope is the fastest but of course it doesn't maintain state so probably not what you want. If the variables don't change values then you could consider the application scope. -d _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Mason Sent: 05/27/2008 4:43 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Speed and resources: better to do client or session var? Session variables are faster generally and solve all the issues you need. There are always trade offs. For example saving the info in a session scope with take up the server's memory as oppose to saving the info in a client variable cookie, etc. But in most cases, approx. 98% of the time, the session scope is the way to go. Client variables really aren't needed in most cases unless you are using clusters or trying to limit memory usage, etc., but you're not in any of those situations. John Mason [EMAIL PROTECTED] 770.337.8363 www.FusionLink.com - ColdFusion and Flex hosting Now offering VPS Plans running with VMware technology Now offering ColdFusion 8 Enterprise hosting FREE Subversion hosting _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derrick Peavy Sent: Tuesday, May 27, 2008 9:06 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Speed and resources: better to do client or session var? Probably discussed to death 10 years ago, 5 years ago, one day ago. I don't know. Can't find definitive answers. Wondering... Does anyone think or dare I ask does anyone know if one type of variable structure is faster or less resource intensive than another? In particular, I have an app where I am using client variables for a lot of very simple integer values. I could just as easily use session. The client storage option is a database and so, the larger the number of client variables in the app, and the larger the number of users (visitors), then the larger that database becomes. Again, these are simple values such as one char text values, 1-8 digit integers, etc., Nothing complex. So, does anyone have strong feelings as to which structure would be better for purposes of speed (overall page load), and system resources - larger database for client variables versus more memory used for session? _ Derrick Peavy Sales and Web Services CollegeClassifieds.com http://www.collegeclassifieds.com A Service of Universal Advertising, inc. ___ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Multiple Application.CFC files
I haven't tried this with Application.cfc but this does work in Application.cfm so I assume it would work. Just use one app file and put some code like this in it: cfset thisPath = ExpandPath(*.*) cfset thisDirectory = GetDirectoryFromPath(thisPath) cfset folderName = listlast(thisDirectory,\) cfif folderName is secure Do login routine /cfif I just tried it and seems to do what you describe. -Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clarke Bishop Sent: 05/23/2008 6:53 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Multiple Application.CFC files In my webroot, I am trying to setup a secure directory where a login is required. I got some good ideas the other day from Doug, but I'm still having trouble. Here's what I'm trying to do /webroot/ accessibleStuff.cfm /secure/ stuffThatRequiresLogin.cfm So, anything in the secure directory requires a login. Now, I've got an Application.cfc in my webroot. All, I have to do, is put another Application.cfc in the secure directory and check for login. Problem 1. CF only processes one Application.cfc. So, when I add the second Application.cfc, all my session initialization, error handling, etc. in webroot.Application doesn't run. I think the answer to this is to make the second Application.cfc extend webroot.Application, but maybe there's a better way. Problem 2. When I did have the second Application.cfc extend webroot.Application, cfm pages in the secure directory don't fire the OnSessionStart event located in webroot.Application. My plan was to test the value of SESSION.IsLoggedIn, but it's failing because IsLoggedIn did not get initialized by OnSessionStart. What am I missing? Is there a better way to do this? Thanks, Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] FW: the old record viewer wizard
LOL I was already looking into cfgrid. Almost done with it I think. But I would much prefer it to run in Flash rather than the Java applet it seems to generate. I am trying to figure that out now but would appreciate any quick advice anyone may be able to give about that. Thanks, Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 12:18 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard Well, even though I'm not familar with the tool you used to use and I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and higher are very fast to use. You can quickly add buttons for adding or deleting rows, while simply highlighting and editing a row allows it to update. There were some bugs with those initially, but several hot fixes for CF 7 cleared up most of my problems. Is anyone here familiar with the record viewer wizard from CF Studio (eons ago)? If anyone knows of some new and quick way to generate a web based add/edit/delete feature for one table in an SQL Server database, please let me know. Many years ago I used the record viewer wizard in CF Studio to do this. I was hoping that there is a newer and better way to do this like some how binding a form to a database table. Thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] FW: the old record viewer wizard
Thanks I switched it over to Flash. However now the grid doesn't seem to update the changes when entered. I'm sure there is probably some other attribute I need to use or something. I'll try to figure it out. Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 4:37 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard cfgrid name = name format = Flash LOL I was already looking into cfgrid. Almost done with it I think. But I would much prefer it to run in Flash rather than the Java applet it seems to generate. I am trying to figure that out now but would appreciate any quick advice anyone may be able to give about that. Thanks, Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 12:18 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard Well, even though I'm not familar with the tool you used to use and I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and higher are very fast to use. You can quickly add buttons for adding or deleting rows, while simply highlighting and editing a row allows it to update. There were some bugs with those initially, but several hot fixes for CF 7 cleared up most of my problems. Is anyone here familiar with the record viewer wizard from CF Studio (eons ago)? If anyone knows of some new and quick way to generate a web based add/edit/delete feature for one table in an SQL Server database, please let me know. Many years ago I used the record viewer wizard in CF Studio to do this. I was hoping that there is a newer and better way to do this like some how binding a form to a database table. Thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] FW: the old record viewer wizard
Thanks I do have the cfgridupdate going as well. It worked perfect when using applet but not Flash. The action page is the same page. Code below if you see anything I am doing wrong please let me know. The primary key is all set on the table. !--- If the gridEntered form field has been tripped, perform the gridupdate on the table specified in the database. Using the default value keyonly = yes allows us to change only the information that differs from the previous grid --- cfif IsDefined(form.gridEntered) cfgridupdate grid = FirstGrid datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# tableName = tblARTavail keyonly=yes /cfif cfquery name=q datasource=#application.dsn_name# username=#application.db_user# password=#application.db_pword# select record_id, donorid, ARTonly from tblARTavail /cfquery !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 / titleUntitled Document/title /head body cfform action = index.cfm method = POST enableCAB = Yes cfgrid name = FirstGrid format=flash width = 500 height=300 query = q insert = Yes delete = Yes sort = Yes font = Tahoma bold = No italic = No appendKey = Yes highlightHref = No gridDataAlign = LEFT gridLines = Yes rowHeaders = Yes rowHeaderAlign = LEFT rowHeaderItalic = No rowHeaderBold = No colHeaders = Yes colHeaderAlign = LEFT colHeaderItalic = No colHeaderBold = No selectColor = Red selectMode = EDIT pictureBar = No insertButton = To insert deleteButton = To delete sortAscendingButton = Sort ASC sortDescendingButton = Sort DESC cfgridcolumn name = record_id header = Record ID dataAlign = LEFT bold = Yes italic = No select = No display = Yes headerBold = No headerItalic = No cfgridcolumn name = donorid header = DONORID dataAlign = LEFT bold = Yes italic = No select = Yes display = Yes headerBold = No headerItalic = No cfgridcolumn name = ARTonly header = ARTonly headerAlign = LEFT dataAlign = LEFT bold = Yes italic = No select = Yes display = Yes headerBold = No headerItalic = Yes /cfgrid pcfinput type=submit name=gridEntered value=Save/p /cfform /body /html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 5:30 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard Well, you still need to have an action page. On the action page you'd have the cfgridupdate tag: cfgridupdate grid = gridname dataSource = data source name tableName = table name username = data source username password = data source password tableOwner = table owner tableQualifier = qualifier keyOnly = yes or no It's very important to have the primary key for your table on the grid itself, but you can have it hidden if you want - but the cfgridupdate tag will not work correctly if you don't have the primary key somewhere on the grid. Thanks I switched it over to Flash. However now the grid doesn't seem to update the changes when entered. I'm sure there is probably some other attribute I need to use or something. I'll try to figure it out. Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 4:37 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] FW: the old record viewer wizard cfgrid name = name format = Flash LOL I was already looking into cfgrid. Almost done with it I think. But I would much prefer it to run in Flash rather than the Java applet it seems to generate. I am trying to figure that out now but would appreciate any quick advice anyone may be able to give about that. Thanks, Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver Sent: 05/16/2008 12:18 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] FW: the old record viewer wizard Well, even though I'm not familar with the tool you used to use and I'm not a flash fan - but cfgrid types of flash forms in CFMX 7 and higher are very fast to use. You can quickly add buttons for adding or deleting rows, while simply highlighting and editing a row allows it to update. There were some bugs with those initially, but several hot fixes for CF 7 cleared up most of my problems. Is anyone here familiar with the record viewer wizard from CF Studio (eons ago)? If anyone knows of some new and quick way to generate a web based add/edit/delete feature for one table in an SQL Server database, please let me know. Many years ago I used the record viewer wizard in CF Studio to do this. I was hoping that there is a newer and better way to do this like some how binding a form to a database table. Thanks, Dusty
RE: [ACFUG Discuss] Best way to download a PDF file
_ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clarke Bishop Sent: 05/01/2008 11:02 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Best way to download a PDF file I have a 2 MB PDF that I get's downloaded via a CFM page so that I can do some tracking of who downloads the page. It seems there are two ways to make this work: #1 cfcontent type=application/pdf file=myFile.pdf reset=yes Normally, this would just open the PDF in the browser. - OR - #2 cfheader name=Content-Disposition value=attachment; filename=myFile.pdf cfcontent type=application/pdf file=myFile.pdf reset=yes This prompts the user whether they want to save or open the document. Here are my questions: 1. My client thought that some users would not know how to click the save icon in the Adobe Reader plug-in to save the PDF to their local drive. So, option 2 would be better as it give them the choice. But, my users are coming to the page from a link in an email and option 2 leaves open a blank web browser after the open/save dialog. This might be confusing, too. Is there another option that will work better? Can I download the page and then redirect them to a download complete page? Or, maybe I should send them to a landing page from the e-mail link and then let them download from there? 2. With either option, sometimes the file fails to fully download, and the PDF displays with an error message: There was an error opening this document. The file is damaged and could not be repaired I added cfsetting requestTimeOut=600 To try and prevent this problem. But, somewhere I saw that the requestTimeOut doesn't apply to CFContent, so I'm not sure this really helps. The problem was hard to duplicate since it seems to be bandwidth-dependent. So, I turned on throttling in Charles, and selected a 56K modem to force low bandwidth. It seems to download consistently for about 2 minutes (About 25% of the 2MB file), and then just hangs for about 4.5 minutes and produces the error. I removed the cfsetting tag and got essentially the same behavior -- It goes for 2 minutes, then hangs for Once I deploy this, I expect thousands of downloads, and I don't want to have to handle a bunch of support calls. Any ideas on how to best handle the user interface and prevent this download timeout would be very much appreciated. Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Best way to download a PDF file
It sounds like you answered a lot of your own questions about how to organize download screens. You could redirect them after download or send to a download page either would work I would think. About your problem with the download timeout or getting cut off. I had this same problem with the use of cfcontent and see the note from a previous thread if your website hosting company uses SeeFusion: 1. The webserver has a monitoring service software on it call SeeFusion on it that troubleshoots problem web application scripts that might interfere with other sites on the server. This enforces some rules for shared server websites. One rule is called a forced 50 second timeout. 2. During some testing we noticed that downloaded files were getting interrupted at 50 seconds so we think the downloads were timing out for some folks in the case were the download was taking more than 50 seconds. Some of these files are as large as 15mb so obviously will take longer than 50 seconds for some folks. My code was already configured to run as long as 2000 seconds, however, this monitoring service that is on the server overrides my application code that tell the server to allow 2000 seconds. 3. Hosting has configured SeeFusion to exclude the script that handles the download. 4. Hope this is not confusing. Let me know if you have questions about it. -- Hope this helps. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clarke Bishop Sent: 05/01/2008 11:02 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Best way to download a PDF file I have a 2 MB PDF that I get's downloaded via a CFM page so that I can do some tracking of who downloads the page. It seems there are two ways to make this work: #1 cfcontent type=application/pdf file=myFile.pdf reset=yes Normally, this would just open the PDF in the browser. - OR - #2 cfheader name=Content-Disposition value=attachment; filename=myFile.pdf cfcontent type=application/pdf file=myFile.pdf reset=yes This prompts the user whether they want to save or open the document. Here are my questions: 1. My client thought that some users would not know how to click the save icon in the Adobe Reader plug-in to save the PDF to their local drive. So, option 2 would be better as it give them the choice. But, my users are coming to the page from a link in an email and option 2 leaves open a blank web browser after the open/save dialog. This might be confusing, too. Is there another option that will work better? Can I download the page and then redirect them to a download complete page? Or, maybe I should send them to a landing page from the e-mail link and then let them download from there? 2. With either option, sometimes the file fails to fully download, and the PDF displays with an error message: There was an error opening this document. The file is damaged and could not be repaired I added cfsetting requestTimeOut=600 To try and prevent this problem. But, somewhere I saw that the requestTimeOut doesn't apply to CFContent, so I'm not sure this really helps. The problem was hard to duplicate since it seems to be bandwidth-dependent. So, I turned on throttling in Charles, and selected a 56K modem to force low bandwidth. It seems to download consistently for about 2 minutes (About 25% of the 2MB file), and then just hangs for about 4.5 minutes and produces the error. I removed the cfsetting tag and got essentially the same behavior -- It goes for 2 minutes, then hangs for Once I deploy this, I expect thousands of downloads, and I don't want to have to handle a bunch of support calls. Any ideas on how to best handle the user interface and prevent this download timeout would be very much appreciated. Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] QoQ question
Hey Scott long time man. Hope you're well. Hey this is just a thought. I really don't have much experience doing QoQ but couldn't you do something like creating a column alias in one of those queries so it doesn't have a space in it in the query itself? Again I may be way off but just thought I would offer that. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Councill Sent: 04/17/2008 4:25 PM To: discussion@acfug.org Subject: [ACFUG Discuss] QoQ question I am writing a query of query where the result set in the original query has spaces in the field names. I know when you are querying a database, you use [Field Name] as the syntax but CF is throwing an error when I do this with the QoQ. Any ideas how I can call the fieldname with spaces in a QoQ? J. Scott Councill Software Engineer II Direct: 404.601.4390 Cell: 804.267.9555 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Spunlogic Expect More From the Web http://www.spunlogic.com/?CMP=EMC-OutlookSig www.spunlogic.com Looking for insights and tips on all aspects of interactive marketing? Visit http://www.spunlogic.com/blog/?CMP=EMC-OutlookSig Spunlogic's Blog for a look inside the minds of a leading interactive agency. - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Doing CF development on a MAC
I just wanted to say thanks to everyone who offered advice and suggestions related to this topic of doing CF on MAC. I am making plans now to purchase a MacBook Pro and also decided to purchase the lease on the dell gear I have which also included licensed versions of the CS2 web bundle double suite. Adobe will upgrade me to the CS3 Master suite for $1390 under the Windows version then I have to get a platform change on that license which will only cost the price of shipping. During the transition, I still have the Dell notebook to get me by if I get in trouble with the MAC. So that's the plan. Thanks again to all. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Ford Sent: 04/13/2008 1:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Doing CF development on a MAC Being in a stereotypical corporate environment, I have to use a Windows machine at work but I've used nothing but Macs at home for years. There is nothing I can't do on my Mac that I can't do on my Windows PC, though as some have mentioned there are some things in a corporate world that are a little more efficiently geared towards Windows. Here are some of the things I use daily on my Mac for development and work-a-day activities: * Eclipse with Flex Builder, CFEclipse, Adobe's ColdFusion extensions and various other plug-ins. * TextMate (my programmers text editor of choice). BBEdit, TextWrangler (a free editor by the makers of BBEdit), and Smultron are also good. * ColdFusion 8. Since Mac OSX has Apache built-in, I was able to integrate CF with it fairly easily. * Cisco VPN (for connecting to work). I also use Shimo, a fantastic free front-end for Cisco VPN that makes connecting/disconnecting a breeze. * Microsoft Office, in particular Entourage for working with Exchange. * Remote Desktop Connection (Microsoft's RDP client). * Terminal (OSX's command-line). * Safari, Firefox, and Opera for testing. * Aqua Data Studio (I use this versus Microsoft's Enterprise Manager and Oracle's tools) * MySQL (for occasional light-weight projects, otherwise I use SQL Server on our development servers at work) * CSSEdit (a great shareware CSS editor) * Plaxo (a great free service that I have installed on both my Exchange calendars and contacts in sync with my home's Address Book and iCal programs). * X-Mind or Freemind (for the occasional mindmap). * OmniGraffle (similar to Visio, but in my opinion produces nicer looking results). * Snapz Pro X (I mainly use it for making demos). * Yummy FTP (my FTP client of choice, though there are a ton of great FTP clients for OSX). * Adobe Creative Suite. Some of the above is commercial, some shareware, and some freeware. The most expensive items were Microsoft Office, Adobe's Creative Suite, and Aqua Data Studio. Most others are either free or I got through shareware bundles from macheist.com or macupdate.com. Flex Builder 3 licenses are fully cross-platform now, greatly simplifying things there. Hope this helps some. Kevin - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] Doing CF development on a MAC
OK this is probably a good question for Dean! I am now highly considering getting a mac to further develop the creative aspects of what I do. I understand that some developers have moved to Mac and use the VMWare to run windows applications. My questions are: If developing on a Mac would I install things like Photoshop and Illustrator on the Mac OS or would I be doing it through the VMWare on Windows. I currently have the Adobe CS2 Web Bundle suite running on my pc under Win XP so I am not even sure yet that the software I have will run on the Mac OS (I have to check on that). I plan to upgrade to the full Adobe Master Collection with all the great new CS3 tools so I wonder if I have to order it for Mac or Windows or if the software package will install on either. I am hoping either :-) ... I am researching now but would appreciate any quick answers if any one has time. Thanks, Dusty - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Doing CF development on a MAC
Hey I would also be interested to here from anyone else who develops CF on a mac. I'm just curious how many members of this list are doing it. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Powell Sent: 04/11/2008 12:36 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Doing CF development on a MAC When you upgrade, I believe you can upgrade to the mac version from PC version. I've heard of people trying to run these apps in VMs, with little success b/c they're so resource intensive. Just my two cents. ap On Apr 11, 2008, at 12:26 PM, Dusty Hale wrote: OK this is probably a good question for Dean! I am now highly considering getting a mac to further develop the creative aspects of what I do. I understand that some developers have moved to Mac and use the VMWare to run windows applications. My questions are: If developing on a Mac would I install things like Photoshop and Illustrator on the Mac OS or would I be doing it through the VMWare on Windows. I currently have the Adobe CS2 Web Bundle suite running on my pc under Win XP so I am not even sure yet that the software I have will run on the Mac OS (I have to check on that). I plan to upgrade to the full Adobe Master Collection with all the great new CS3 tools so I wonder if I have to order it for Mac or Windows or if the software package will install on either. I am hoping either :-) ... I am researching now but would appreciate any quick answers if any one has time. Thanks, Dusty - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Doing CF development on a MAC
Derrick yes that is exactly the kind of information I need. My hope was that I would not have to run all the Adobe software on the Windows OS and it sounds like that is the case but I guess I need to get the Mac version of all the software. So the question might be can I upgrade my CS2 products to Mac Version CS3 products? Andrew's response indicated I might be able to do that so I am going to do more research and/or contact Adobe about that today. I'll share the outcome. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derrick Peavy Sent: 04/11/2008 12:44 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Doing CF development on a MAC Dusty: The software will NOT install on both. You can run it all under Windows through VMWare, but it sounds like what you will end up doing is running everything on the PC and nothing on the mac. I develop on a mac. I use BBEdit (text editor) for code, safari/firefox for browser testing, and either 1) upload CFM files to stage server (mimic of production server) or 2) Run locally under CF or Blue Dragon. So, where is the need for the PC? (BTW - that's not flame bait, that's just my approach). _ Derrick Peavy Sales and Web Services CollegeClassifieds.com http://www.collegeclassifieds.com A Service of Universal Advertising, inc. ___ On Apr 11, 2008, at 12:26 PM, Dusty Hale wrote: OK this is probably a good question for Dean! I am now highly considering getting a mac to further develop the creative aspects of what I do. I understand that some developers have moved to Mac and use the VMWare to run windows applications. My questions are: If developing on a Mac would I install things like Photoshop and Illustrator on the Mac OS or would I be doing it through the VMWare on Windows. I currently have the Adobe CS2 Web Bundle suite running on my pc under Win XP so I am not even sure yet that the software I have will run on the Mac OS (I have to check on that). I plan to upgrade to the full Adobe Master Collection with all the great new CS3 tools so I wonder if I have to order it for Mac or Windows or if the software package will install on either. I am hoping either :-) ... I am researching now but would appreciate any quick answers if any one has time. Thanks, Dusty - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Doing CF development on a MAC
I just spoke with Adobe directly and you can switch your license from pc to mac. However, they claim they no longer have CS2 products to distribute so you can only do this if you're already using CS3 products. Dusty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Childress Sent: 04/11/2008 12:56 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Doing CF development on a MAC Dusty- If you are going to switch to a mac I'd try to run everything on the native mac OS that you can. IIRC, Adobe will allow you to switch your PC based licenses to mac based ones, but there may be a catch or two attached. Seems I remember something about only being able to do that once per license. Currently there is very little that you can't do on a mac, so unless there is a program not available for mac or one which you can't move the license on - I'd try to keep it all running on the mac os if possible. -Cameron On Fri, Apr 11, 2008 at 12:26 PM, Dusty Hale [EMAIL PROTECTED] wrote: OK this is probably a good question for Dean! I am now highly considering getting a mac to further develop the creative aspects of what I do. I understand that some developers have moved to Mac and use the VMWare to run windows applications. My questions are: If developing on a Mac would I install things like Photoshop and Illustrator on the Mac OS or would I be doing it through the VMWare on Windows. I currently have the Adobe CS2 Web Bundle suite running on my pc under Win XP so I am not even sure yet that the software I have will run on the Mac OS (I have to check on that). I plan to upgrade to the full Adobe Master Collection with all the great new CS3 tools so I wonder if I have to order it for Mac or Windows or if the software package will install on either. I am hoping either :-) ... I am researching now but would appreciate any quick answers if any one has time. Thanks, Dusty - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Anyone ever have this cfinput or cfselect validation issue?
Good point I think I also now remember running into this when I try to mix my own js ... _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mischa Uppelschoten ext 10 Sent: 03/27/2008 3:48 PM To: Web Site Subject: re: [ACFUG Discuss] Anyone ever have this cfinput or cfselect validation issue? Yes, I've had that and IIRC it had something to do with my own form validation that I added. Have you tried a CFFORM/CFINPUT on a virgin page without any added js? : I am coding a form and trying to use the built in CF(MX 7) validations to the : CFINPUT and CFSELECT tags. : : When I submitthe form, the js that CF writes is throwing errors (Object : expected). The fucntionality is something Ive used before and did not have : this problem. : : I was trying to validate email format and that something was selected. : : Any ideas? : : : - : Annual Sponsor - Figleaf Software : : To unsubscribe from this list, manage your profile @ : http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform : : For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists : Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ : List hosted by FusionLink : - Mischa Uppelschoten The Banker's Exchange, LLC. 4200 Highlands Parkway SE Suite A Smyrna, GA 30082-5198 Phone:(404) 605-0100 ext. 10 Fax:(404) 355-7930 Web: http://www.BankersX.com www.BankersX.com Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN --- Original Message --- From: Jeff Howard mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] To: mailto:discussion@acfug.org discussion@acfug.org Date: Thu, 27 Mar 2008 14:48:23 -0400 Subject: [ACFUG Discuss] Anyone ever have this cfinput or cfselect validation issue? I am coding a form and trying to use the built in CF(MX 7) validations to the CFINPUT and CFSELECT tags. When I submit the form, the js that CF writes is throwing errors (Object expected). The fucntionality is something I've used before and did not have this problem. I was trying to validate email format and that something was selected. Any ideas? - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] looking for opinions on duplicate form submissions
If you don't have time to learn ajax why not split it into several screens: Screen 1 User fills out form clicks Continue instead of submit. Don't upload any file on this screen though Put the form data into a session var and check the db for dups. Screen 2 Present duplicate message offer to continue or cancel instead of the save option. Screen 3 File uploader. Screen 4 Thank you ... bla bla ... complete ... Now if you check the db and no possible duplicates then skip screen 2. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: 03/20/2008 11:45 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions This is an internal application and js is enabled on all machines and everyone MUST use IE here. The issue here is that the user must be the one to decide if it is a duplicate. I'm merely notifying the user that there is a submission already that looks identical to what they submitted. Then it's up to the user to decide if they're duplicating the work of someone else or their own. So I have to query the db and display to the end user which form(s) already exist that contain the same data as theirs does and request that they review and then 'save' or 'cancel'. Is this something best suited for Ajax or is there an equally as efficient way to accomplish this without the use of Ajax? - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] looking for opinions on duplicate form submissions
Probably not as graceful as the ajax approach but it will get the job done. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: 03/20/2008 1:28 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions Funny, this is exactly what I said I might do while I was just at lunch. The wizard version of the form where the duplicate check happens right before the file upload. I was still in the middle of weighing the pros and cons eating my sandwhich and decided to check here to see if any new ideas were posted. btw, thanks everyone for you help/suggestions. On Thu, Mar 20, 2008 at 12:26 PM, Dusty Hale [EMAIL PROTECTED] wrote: If you don't have time to learn ajax why not split it into several screens: Screen 1 User fills out form clicks Continue instead of submit. Don't upload any file on this screen though Put the form data into a session var and check the db for dups. Screen 2 Present duplicate message offer to continue or cancel instead of the save option. Screen 3 File uploader. Screen 4 Thank you ... bla bla ... complete ... Now if you check the db and no possible duplicates then skip screen 2. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: 03/20/2008 11:45 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions This is an internal application and js is enabled on all machines and everyone MUST use IE here. The issue here is that the user must be the one to decide if it is a duplicate. I'm merely notifying the user that there is a submission already that looks identical to what they submitted. Then it's up to the user to decide if they're duplicating the work of someone else or their own. So I have to query the db and display to the end user which form(s) already exist that contain the same data as theirs does and request that they review and then 'save' or 'cancel'. Is this something best suited for Ajax or is there an equally as efficient way to accomplish this without the use of Ajax? - Annual Sponsor - Figleaf http://www.figleaf.com/ Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - Annual Sponsor - Figleaf http://www.figleaf.com/ Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] How does one use cfmail?
It really has nothing to do with the sender's server or the recipient server. You just need a mail server that will allow your application access it. A lot of mail servers are set up to not allow that kind of thing or otherwise we could just be using anyone's mail server in our cfmail tag. If you do use your own mail server then you may also need to pass in the username and password for the email your email box. Did you try that? I believe there are additional attributes username=blabla password=blabla ... give that a try if you haven't already done so. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peyton Todd Sent: 03/20/2008 2:01 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] How does one use cfmail? No luck so far. The company which allegedly handles their e-mail (USA.net) tells me the SMTP server to use is exchange.usa.net, and at least when I enter that in the 'mail' dialog of the CF Administrator, then put a check by Verify Mail Server Connection and submit it, it does respond with Connection Verification Successful. But whether I use server='exchange.usa.net' in the cfmail tag, or just let it use what's in the CF Adminstrator, the office manager at my client's site tells me he sees nothing from me in his e-mail Inbox. (I have my e-mail address in the from='sender' parm of the tag, and my name in the subject line parm of the tag). If we assume that this means what I was given as the SMTP server name is incorrect, how do I find the correct name? I'll be at their site tomorrow and can look on their server, but where would I look? The guy at the USA.net help desk said the place to look is in the mail icon in Settings -- Control Panel. He said there should be profiles there with the correct information. However, when I click the Mail icon there on my own computer just to educate myself, there are not profiles to be seen. And when I called the office manager at the client's place of business and asked him to look for the Mail icon in Settings -- Control Panel on their web server, he said he could find no such icon in the Control Panel. (I'm almost certain that PC is running Windows Server 2003, while I'm running XP Professional.) Also, I'm unclear as to whose server we're talking about here: the one used by the sender or the one used by the recipient of the e-mail message? Peyton -Original Message- From: Dusty Hale Sent: Mar 19, 2008 11:28 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] How does one use ? Also I assume you will be moving the app to a different server after you test it locally. Where ever you host it at should be able to provide you with an SMTP server name to use. If you plan to use the server attribute rather than configuring it in cf admin, you might consider setting a variable in your application.cfm file with the value of the server name so you can easily change it. Or better yet you might do something like: cfif cgi.server_name is localhost cfset request.mymailserver = mail.someserver.com cfelseif cgi.server_name is somedomain.com or cgi.server_name is www.somedomain.com cfset request.mymailserver = mail.someotherserver.com cfelse !--- throw some kind of error --- /cfif then in your cfmail tag do cfmail to=blabla from=blabla subject=hello world server=#request.mymailserver# bla bla /cfmail And if you have multiple instances of cfmail you might do the same for the to and from email addresses. -Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: 03/19/2008 11:11 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] How does one use cfmail? typically the server stuff is set in the admin, thus encapsulating the developer from needing that info. Check out http://livedocs.adobe.com/coldfusion/8/htmldocs/basiconfig_11.html You will need the email servers SMTP info. I doubt you will be able to send email vial mail.earthlink.net though due to relaying restrictions. Is your client using a host? DK On Wed, Mar 19, 2008 at 9:58 PM, Peyton Todd [EMAIL PROTECTED] wrote: This question will probably be easy for nearly every ACFUGGER except me: I want to use the cfmail tag, and my question is: what do they mean by the 'server'? For example, in testing the site I'm building on my own PC as local server, I plan to send the e-mail messages from the site I'm building to myself. My e-mail address is [EMAIL PROTECTED], so that's how I'm filling in the to=recipient parameter of cfmail (Incidentally, does the from=sender parameter make any difference if the recipient will not be replying? In this case the recipient will be the office manager on the same LAN as the web server itself, and he'll always know where the e-mails come from). But the hard part is what to put for the server. I've tried webmail.atl.earthlink.net, which is were I get my e-mail. And I've tried just earthlink.net by itself, and just mindspring.com. But nothing appears