Re: Updating content via email
The problem with UUID is that they aren't human-friendly. On Thu, Apr 28, 2011 at 10:11 PM, Phillip Vector vec...@mostdeadlygame.comwrote: Instead of order number, make it the order ID (and use a UUID)? On Thu, Apr 28, 2011 at 6:19 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: Well, what I'm thinking is to have a specific email address that would get checked by the app via a scheduled task using cfpop. Order number would be in the subject, grab the body of the email and dump it into the order communications table with the timestamp coming from the email. The point for potential problems is if the wrong order number is put in the subject field. I'm sure there are more, but that's the one that worries me. On Thu, Apr 28, 2011 at 8:45 PM, John M Bliss bliss.j...@gmail.com wrote: I have. Having trouble thinking of generalities/gotchas to share with you. Can you think of any more specific questions? On Thu, Apr 28, 2011 at 7:41 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I'm in the planning stages of building an industry-specific (think along the lines of limited production and custom bicycle frames) customer service application. Much of the communication between customer and crafstman is meant to be via a web interface, but I'd also like to allow communication via email, but have the contents of those emails be culled from a specific email address and added to the customer record. What I'm wondering is if anyone here has done this sort of content update via email, and what suggestions you would have for approach and architecture? Thanks Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Updating content via email
take a look at www.kayako.com their ticketing system is the most popular available and is quite customisable, you can add custom fields to collect custom information form users, and you can create rules to process tickets in different ways, so maybe it will do what you need. You can choose to do everything via email, the web interface or both. On Fri, Apr 29, 2011 at 11:55 AM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: The problem with UUID is that they aren't human-friendly. On Thu, Apr 28, 2011 at 10:11 PM, Phillip Vector vec...@mostdeadlygame.comwrote: Instead of order number, make it the order ID (and use a UUID)? On Thu, Apr 28, 2011 at 6:19 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: Well, what I'm thinking is to have a specific email address that would get checked by the app via a scheduled task using cfpop. Order number would be in the subject, grab the body of the email and dump it into the order communications table with the timestamp coming from the email. The point for potential problems is if the wrong order number is put in the subject field. I'm sure there are more, but that's the one that worries me. On Thu, Apr 28, 2011 at 8:45 PM, John M Bliss bliss.j...@gmail.com wrote: I have. Having trouble thinking of generalities/gotchas to share with you. Can you think of any more specific questions? On Thu, Apr 28, 2011 at 7:41 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I'm in the planning stages of building an industry-specific (think along the lines of limited production and custom bicycle frames) customer service application. Much of the communication between customer and crafstman is meant to be via a web interface, but I'd also like to allow communication via email, but have the contents of those emails be culled from a specific email address and added to the customer record. What I'm wondering is if anyone here has done this sort of content update via email, and what suggestions you would have for approach and architecture? Thanks Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
mkvdk.exe Error E0-0401 (Vdb): Couldn't find vdb descriptor C:\Collections\00000000.wld
Hi, While performing index operation , an error was logged in my reIndex.out file. mkvdk.exe (Fri Apr 29 04:46:30 2011): Error E0-0401 (Vdb): Couldn't find vdb descriptor C:\Collections\PTCB_3_Content\assists\.wld Even though .wld exists in that location.it is unable to find. Kindly let me know , how to fix. Environment: CFMX7 standard WIN 2003 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can't open cfadmin after installing CFBuilder Beta 2
Hi, all... Can anyone think of something I may have set when installing CFBuilder Beta 2 that would cause the CFAdmin not to open? (CF9) I've installed CFB a couple of times trying to get CFAdmin running, but when I try to go to http://127.0.0.1/cfide/administrator/index.cfm the browser just churns away, and finally throws an error. Same is true with localhost/cfide... I've currently uninstalled CFB Beta 2, trying to get the cfadmin back, but no luck to this point. CF is running in local services. I can get sites that I've set up in the hosts file with local domains, such as: local.galbreath.com But no response from localhost or 127.0.0.1. Suggestions? Thanks! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't open cfadmin after installing CFBuilder Beta 2
On Fri, Apr 29, 2011 at 11:34 AM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, all... Can anyone think of something I may have set when installing CFBuilder Beta 2 that would cause the CFAdmin not to open? (CF9) is localhost (default site) still setup/on in IIS? I never had any problems with this on CFBuilder 2 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't open cfadmin after installing CFBuilder Beta 2
are you missing a port number http://127.0.0.1:8500/cfide/administrator/index.cfm On Fri, Apr 29, 2011 at 11:34 AM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, all... Can anyone think of something I may have set when installing CFBuilder Beta 2 that would cause the CFAdmin not to open? (CF9) I've installed CFB a couple of times trying to get CFAdmin running, but when I try to go to http://127.0.0.1/cfide/administrator/index.cfm the browser just churns away, and finally throws an error. Same is true with localhost/cfide... I've currently uninstalled CFB Beta 2, trying to get the cfadmin back, but no luck to this point. CF is running in local services. I can get sites that I've set up in the hosts file with local domains, such as: local.galbreath.com But no response from localhost or 127.0.0.1. Suggestions? Thanks! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
In IIS 7, the default web site, under Edit Bindings has one listing: type: http host name: (blank) port: 80 ip address: * binding information: (blank) When I choose to edit that entry, I get: type: http ip address: all unassigned (in the dropdown for ip address I get also: 172.16.0.254 (I set this up for local http access via domain in the hosts file) 192.168.56.1 (not sure what that ip is for at this point) 192.168.1.101 (typical internal router ip)) post: 80 host name: blank I don't recall having to have 127.0.0.1 in that list, but maybe by running alternate ip addresses for local http domain access, I need that entry as a choice in the dropdown??? I just started using an alternate ip address for local http domain access, such as local.galbreath.com, recently, but I'm fairly certain I've accessed the cfadmin since starting that practice. Maybe I should give the All Unassigned ip address the host name of localhost??? I'll try that. I wanted to type these questions in my replay for other's reference who might have the same problem. Rick -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, April 29, 2011 11:37 AM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 On Fri, Apr 29, 2011 at 11:34 AM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, all... Can anyone think of something I may have set when installing CFBuilder Beta 2 that would cause the CFAdmin not to open? (CF9) is localhost (default site) still setup/on in IIS? I never had any problems with this on CFBuilder 2 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
I tried with and without the port number appended to the IP address...both got the same cannot display the webpage response... -Original Message- From: Scott Stewart [mailto:webmas...@sstwebworks.com] Sent: Friday, April 29, 2011 11:59 AM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 are you missing a port number http://127.0.0.1:8500/cfide/administrator/index.cfm On Fri, Apr 29, 2011 at 11:34 AM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, all... Can anyone think of something I may have set when installing CFBuilder Beta 2 that would cause the CFAdmin not to open? (CF9) I've installed CFB a couple of times trying to get CFAdmin running, but when I try to go to http://127.0.0.1/cfide/administrator/index.cfm the browser just churns away, and finally throws an error. Same is true with localhost/cfide... I've currently uninstalled CFB Beta 2, trying to get the cfadmin back, but no luck to this point. CF is running in local services. I can get sites that I've set up in the hosts file with local domains, such as: local.galbreath.com But no response from localhost or 127.0.0.1. Suggestions? Thanks! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't open cfadmin after installing CFBuilder Beta 2
On Fri, Apr 29, 2011 at 1:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: I tried with and without the port number appended to the IP address...both got the same cannot display the webpage response... actually my admin page doesn't come up with ip address either. I need to use localhost. http://localhost/CFIDE/administrator/index.cfm in IIS my default website is localhost on *80 path is %SystemPath%\initpub\wwwroot hosts file is 127.0.0.1localhost wwwroot has CFIDE directory in it. I'm assuming your wwwroot directory doesn't have the CFIDE directory anymore. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
I can't get the admin with 127.0.0.1 or localhost. My webroot is on a different drive than c:, so I use virtual directories under the default web site to access CF Admin. It's been this way for awhile and has worked until now... I'll try adding 127.0.0.1 localhost to my hosts file. I think I've tried that, however. -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, April 29, 2011 1:22 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 On Fri, Apr 29, 2011 at 1:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: I tried with and without the port number appended to the IP address...both got the same cannot display the webpage response... actually my admin page doesn't come up with ip address either. I need to use localhost. http://localhost/CFIDE/administrator/index.cfm in IIS my default website is localhost on *80 path is %SystemPath%\initpub\wwwroot hosts file is 127.0.0.1localhost wwwroot has CFIDE directory in it. I'm assuming your wwwroot directory doesn't have the CFIDE directory anymore. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
Nope... adding 127.0.0.1 localhost to the hosts file didn't help or change anything. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, April 29, 2011 1:32 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 I can't get the admin with 127.0.0.1 or localhost. My webroot is on a different drive than c:, so I use virtual directories under the default web site to access CF Admin. It's been this way for awhile and has worked until now... I'll try adding 127.0.0.1 localhost to my hosts file. I think I've tried that, however. -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, April 29, 2011 1:22 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 On Fri, Apr 29, 2011 at 1:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: I tried with and without the port number appended to the IP address...both got the same cannot display the webpage response... actually my admin page doesn't come up with ip address either. I need to use localhost. http://localhost/CFIDE/administrator/index.cfm in IIS my default website is localhost on *80 path is %SystemPath%\initpub\wwwroot hosts file is 127.0.0.1localhost wwwroot has CFIDE directory in it. I'm assuming your wwwroot directory doesn't have the CFIDE directory anymore. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't open cfadmin after installing CFBuilder Beta 2
On Fri, Apr 29, 2011 at 1:41 PM, Rick Faircloth r...@whitestonemedia.comwrote: Nope... adding 127.0.0.1 localhost to the hosts file didn't help or change anything. System Restore Time :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
It seems that 127.0.0.1 or localhost is just totally unresponsive... but everything seems to be set up correctly. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, April 29, 2011 1:42 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 Nope... adding 127.0.0.1 localhost to the hosts file didn't help or change anything. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, April 29, 2011 1:32 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 I can't get the admin with 127.0.0.1 or localhost. My webroot is on a different drive than c:, so I use virtual directories under the default web site to access CF Admin. It's been this way for awhile and has worked until now... I'll try adding 127.0.0.1 localhost to my hosts file. I think I've tried that, however. -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, April 29, 2011 1:22 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 On Fri, Apr 29, 2011 at 1:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: I tried with and without the port number appended to the IP address...both got the same cannot display the webpage response... actually my admin page doesn't come up with ip address either. I need to use localhost. http://localhost/CFIDE/administrator/index.cfm in IIS my default website is localhost on *80 path is %SystemPath%\initpub\wwwroot hosts file is 127.0.0.1localhost wwwroot has CFIDE directory in it. I'm assuming your wwwroot directory doesn't have the CFIDE directory anymore. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with CFMAIL
On Thu, Apr 28, 2011 at 5:14 PM, Russ Michaels r...@michaels.me.uk wrote: The file is attached to the email probably because the original sender is sending emails in Rich Text Format, so I would check this with your users who are reporting the problem. see this http://email.about.com/od/outlooktips/qt/Prevent_Winmail_dat_Attachments_from_Being_Sent_in_Outlook.htm That is EXACTLY it. A couple weeks ago, someone added a contact to our exchange global address book for our ticketing system. If I send a message to the ticketing system by typing in the address, it works fine. If I send it by choosing that contact from the address book.. POOF! Winmail.dat I sent the above link to our exchange guy to fix this. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
That sounds like a problem with your TCP/IP configuration. Can you try reinstalling the protocal? -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: 29 April 2011 18:54 To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 It seems that 127.0.0.1 or localhost is just totally unresponsive... but everything seems to be set up correctly. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, April 29, 2011 1:42 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 Nope... adding 127.0.0.1 localhost to the hosts file didn't help or change anything. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, April 29, 2011 1:32 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 I can't get the admin with 127.0.0.1 or localhost. My webroot is on a different drive than c:, so I use virtual directories under the default web site to access CF Admin. It's been this way for awhile and has worked until now... I'll try adding 127.0.0.1 localhost to my hosts file. I think I've tried that, however. -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, April 29, 2011 1:22 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 On Fri, Apr 29, 2011 at 1:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: I tried with and without the port number appended to the IP address...both got the same cannot display the webpage response... actually my admin page doesn't come up with ip address either. I need to use localhost. http://localhost/CFIDE/administrator/index.cfm in IIS my default website is localhost on *80 path is %SystemPath%\initpub\wwwroot hosts file is 127.0.0.1localhost wwwroot has CFIDE directory in it. I'm assuming your wwwroot directory doesn't have the CFIDE directory anymore. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Q re new CF9 Spreadsheet* functions
The Excel approach seemed like a winner but in the end, I had to ditch it. In the end, I hit what appears to be a well-known problem and a known limitation for cfspreadsheet. The current design of the spreadsheet functionality makes it hard (impossible?) to optimally share cell formats across cells and that makes Excel hit an internal limit. Excel then decides on its own which cells will not receive any formatting. I am setting the cell formats for a few hundred cells in the worksheet although there are only 4 or 5 truly unique formats. That works fine until I then create many similar sheets within the same workbook. When you open the XLS in Excel, you get an error message re Too many different cell formats. (see http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=82627 for Adobe's bug report and http://support.microsoft.com/kb/213904 for background info) My theory then is that every time you call spreadsheetFormatRow or spreadsheetFormatCell, the underlying library CF uses does not optimize how the format is applied. I experimented but couldn't see a way through the CF API to force it to be smarter. In the end, I had to back off to making a PDF which, with CF's PDF library CSS limitations meant no rotated text. In the meantime, a few notes to help those in the future: - when setting a format struct's rotation value, use a string for negative values, i.e. format.rotation = '-60' or you'll get an exception. - I could not get formats to work at all unless I set a cell value, even if to an empty string. This leads to another problem: - Setting cell values is SLOW. I looped through a grid of 20x16 cells, setting them to the empty string. That added generation time of 8 seconds. - Setting column widths and row heights was unreliable for me unless I did that after all cell formats were set. - It's unclear what the value is that is passed to spreadsheetSetRowHeight/ColumnWidth. The doc says it's in points. When I set it to X and then look at the resulting spreadsheet in Excel, Excel tells me a different value than X. db ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't open cfadmin after installing CFBuilder Beta 2
It seems that 127.0.0.1 or localhost is just totally unresponsive... but everything seems to be set up correctly. Can you ping that address and name from a command prompt? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't open cfadmin after installing CFBuilder Beta 2
That sounds like a problem with your TCP/IP configuration. Can you try reinstalling the protocal? This is less likely than a configuration problem with IIS. Make sure you can't ping the address or name before you take this drastic step. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
I think something more serious is going on... I'm unable to successfully use System Restore (Win 7 Home Premium). It always gives a message after attempting to run of unable to access a file... it gives no clue what the file is, however. I had some access issues several days ago via the local ip address entered into my hosts file. I had to change some permissions to get that working. Perhaps I've messed up some permissions somewhere that are now affecting localhost connectivity. During a Windows Update yesterday, I also experienced my first BSOD in a long, long, time...and never since moving to Win 7. I may have a looong weekend ahead of system wipe and reinstall to get everything working properly. If anyone has any other ideas, I'd love to hear them. I'm going to start taking notes on my current system configuration and planning a reinstall of everything. Thanks! Rick -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Friday, April 29, 2011 2:18 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 That sounds like a problem with your TCP/IP configuration. Can you try reinstalling the protocal? -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: 29 April 2011 18:54 To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 It seems that 127.0.0.1 or localhost is just totally unresponsive... but everything seems to be set up correctly. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, April 29, 2011 1:42 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 Nope... adding 127.0.0.1 localhost to the hosts file didn't help or change anything. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, April 29, 2011 1:32 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 I can't get the admin with 127.0.0.1 or localhost. My webroot is on a different drive than c:, so I use virtual directories under the default web site to access CF Admin. It's been this way for awhile and has worked until now... I'll try adding 127.0.0.1 localhost to my hosts file. I think I've tried that, however. -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, April 29, 2011 1:22 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 On Fri, Apr 29, 2011 at 1:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: I tried with and without the port number appended to the IP address...both got the same cannot display the webpage response... actually my admin page doesn't come up with ip address either. I need to use localhost. http://localhost/CFIDE/administrator/index.cfm in IIS my default website is localhost on *80 path is %SystemPath%\initpub\wwwroot hosts file is 127.0.0.1localhost wwwroot has CFIDE directory in it. I'm assuming your wwwroot directory doesn't have the CFIDE directory anymore. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
Yes, I can run ping localhost from a command prompt and get: Pinging WSM-MAIN [::1] with 32 bytes of data: Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Ping statistics for ::1: Packets: Sent = 4, Received = 4, Lost = 0 0% loss, Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, April 29, 2011 3:28 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 That sounds like a problem with your TCP/IP configuration. Can you try reinstalling the protocal? This is less likely than a configuration problem with IIS. Make sure you can't ping the address or name before you take this drastic step. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Q re new CF9 Spreadsheet* functions
There's also JExcelAPI for generating Excel files. Way nicer API than POI, and I've got a custom tag somewhere around here for using it, if you're interested. Really though, I'd recommend using JasperReports. It's an *awesome* reporting engine, and has a *kick ass* GUI report editor (that is cross platform, BTW). You can export in PDF, Excel, PPT, and about 10 other formats. Really just excellent stuff, and way, *way* better than the sorta hit-and-miss style editing required for many other solutions (like HTML = PDF). Just thought I'd toss those out there. Using JasperReports is great for offloading processing as well (if you're going to be generating a bunch of stuff). :Den -- Every existing thing is born without reason, prolongs itself out of weakness, and dies by chance. Jean-Paul Sartre On Fri, Apr 29, 2011 at 12:24 PM, Dave Burns wrote: The Excel approach seemed like a winner but in the end, I had to ditch it. In the end, I hit what appears to be a well-known problem and a known limitation for cfspreadsheet. The current design of the spreadsheet functionality makes it hard (impossible?) to optimally share cell formats across cells and that makes Excel hit an internal limit. Excel then decides on its own which cells will not receive any formatting. I am setting the cell formats for a few hundred cells in the worksheet although there are only 4 or 5 truly unique formats. That works fine until I then create many similar sheets within the same workbook. When you open the XLS in Excel, you get an error message re Too many different cell formats. (see http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=82627 for Adobe's bug report and http://support.microsoft.com/kb/213904 for background info) My theory then is that every time you call spreadsheetFormatRow or spreadsheetFormatCell, the underlying library CF uses does not optimize how the format is applied. I experimented but couldn't see a way through the CF API to force it to be smarter. In the end, I had to back off to making a PDF which, with CF's PDF library CSS limitations meant no rotated text. In the meantime, a few notes to help those in the future: - when setting a format struct's rotation value, use a string for negative values, i.e. format.rotation = '-60' or you'll get an exception. - I could not get formats to work at all unless I set a cell value, even if to an empty string. This leads to another problem: - Setting cell values is SLOW. I looped through a grid of 20x16 cells, setting them to the empty string. That added generation time of 8 seconds. - Setting column widths and row heights was unreliable for me unless I did that after all cell formats were set. - It's unclear what the value is that is passed to spreadsheetSetRowHeight/ColumnWidth. The doc says it's in points. When I set it to X and then look at the resulting spreadsheet in Excel, Excel tells me a different value than X. db ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't open cfadmin after installing CFBuilder Beta 2
Yes, I can run ping localhost from a command prompt and get: Pinging WSM-MAIN [::1] with 32 bytes of data: Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Ping statistics for ::1: Packets: Sent = 4, Received = 4, Lost = 0 0% loss, In your TCP/IP configuration, disable IPv6 and make sure IPv4 is enabled, and try again. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with CFMAIL
Exchange causes all kinds of problems, it has so many bugs and oddities and works differently to every other mail server and simple things become so complex. We had a lot of problems with our own ticketing system when we switched to exchange, it didn't take long for me to hate exchange and switch to google apps, no more problems now :-) One of the biggest issues was that exchange does not keep the original recipient address when you send to an alias, it replaces it with the mailbox name, this totally screws up ticketing systems. On 29 Apr 2011 19:16, Rick Root rick.r...@gmail.com wrote: On Thu, Apr 28, 2011 at 5:14 PM, Russ Michaels r...@michaels.me.uk wrote: The file is attached to the email probably because the original sender is sending emails in Rich Text Format, so I would check this with your users who are reporting the problem. see this http://email.about.com/od/outlooktips/qt/Prevent_Winmail_dat_Attachments_from_Being_Sent_in_Outlook.htm That is EXACTLY it. A couple weeks ago, someone added a contact to our exchange global address book for our ticketing system. If I send a message to the ticketing system by typing in the address, it works fine. If I send it by choosing that contact from the address book.. POOF! Winmail.dat I sent the above link to our exchange guy to fix this. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
I'm not sure if I've disabled IPv6 correctly, but I went into the Network and Sharing Center, opened the Local Area Connection configuration dialog for the connection, and unchecked IPv6. I can tell you that the network connection dialog states that IPv6 has no connectivity. One thing to note is that when I click on the Diagnose button, I get the message, Your computer appears to be correctly configured, but the device or resource (DNS Server) is not responding. Just for additional info, when I try to browse to http://127.0.0.1/cfide/administrator/index.cfm, I get a 404, The webpage cannot be found. However, it's apparently accessing the directory, because the CF favicon is displayed on the tab. When I try to browse to http://localhost/cfide/administrator/index.cfm, the browsers grinds away trying to connect, (and does access the directory, including displaying the favicon for CF) but then the browser times out with a message referring to the DNS. (I would give you the message, but the browser is still grinding away without timing out...) -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, April 29, 2011 5:35 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 Yes, I can run ping localhost from a command prompt and get: Pinging WSM-MAIN [::1] with 32 bytes of data: Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Ping statistics for ::1: Packets: Sent = 4, Received = 4, Lost = 0 0% loss, In your TCP/IP configuration, disable IPv6 and make sure IPv4 is enabled, and try again. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't open cfadmin after installing CFBuilder Beta 2
can you browse the default website (not the cfadmin), i.e. do regular html pages display. since you disabled IPv6, can you still ping and tracert localhost in your hosts files does localhost point to 127.0.0.1 is cf definitely running ? On Fri, Apr 29, 2011 at 11:47 PM, Rick Faircloth r...@whitestonemedia.comwrote: I'm not sure if I've disabled IPv6 correctly, but I went into the Network and Sharing Center, opened the Local Area Connection configuration dialog for the connection, and unchecked IPv6. I can tell you that the network connection dialog states that IPv6 has no connectivity. One thing to note is that when I click on the Diagnose button, I get the message, Your computer appears to be correctly configured, but the device or resource (DNS Server) is not responding. Just for additional info, when I try to browse to http://127.0.0.1/cfide/administrator/index.cfm, I get a 404, The webpage cannot be found. However, it's apparently accessing the directory, because the CF favicon is displayed on the tab. When I try to browse to http://localhost/cfide/administrator/index.cfm, the browsers grinds away trying to connect, (and does access the directory, including displaying the favicon for CF) but then the browser times out with a message referring to the DNS. (I would give you the message, but the browser is still grinding away without timing out...) -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, April 29, 2011 5:35 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 Yes, I can run ping localhost from a command prompt and get: Pinging WSM-MAIN [::1] with 32 bytes of data: Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Ping statistics for ::1: Packets: Sent = 4, Received = 4, Lost = 0 0% loss, In your TCP/IP configuration, disable IPv6 and make sure IPv4 is enabled, and try again. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
Just for additional info, when I try to browse to http://127.0.0.1/cfide/administrator/index.cfm, I get a 404, The webpage cannot be found. However, it's apparently accessing the directory, because the CF favicon is displayed on the tab. are you sure that's not from your browser cache? No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3603 - Release Date: 04/28/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
Hi Rick, Get to a command prompt and type: ipconfig /all that shows you all of your tcp/ip settings. check that the DNS servers listed are correct and that your IP address is correct. If they are, type: ipconfig /all mystuff.txt to create a file then post the contents of mystuff.txt here so we can take a look. In your TCP/IP settings do you have a static IP address and an IP address IP address set, or are you picking them up from your ISP's DHCP server? Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3603 - Release Date: 04/28/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
Can't get anything that uses localhost or 127.0.0.1 to show. I can ping and tracert localhost successfully. CF is definitely running. When I use local domains (domains I've entered into my hosts file for development) everything shows as it should. It's just localhost and 127.0.0.1 that don't want to play. ??? -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, April 29, 2011 6:59 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 can you browse the default website (not the cfadmin), i.e. do regular html pages display. since you disabled IPv6, can you still ping and tracert localhost in your hosts files does localhost point to 127.0.0.1 is cf definitely running ? On Fri, Apr 29, 2011 at 11:47 PM, Rick Faircloth r...@whitestonemedia.comwrote: I'm not sure if I've disabled IPv6 correctly, but I went into the Network and Sharing Center, opened the Local Area Connection configuration dialog for the connection, and unchecked IPv6. I can tell you that the network connection dialog states that IPv6 has no connectivity. One thing to note is that when I click on the Diagnose button, I get the message, Your computer appears to be correctly configured, but the device or resource (DNS Server) is not responding. Just for additional info, when I try to browse to http://127.0.0.1/cfide/administrator/index.cfm, I get a 404, The webpage cannot be found. However, it's apparently accessing the directory, because the CF favicon is displayed on the tab. When I try to browse to http://localhost/cfide/administrator/index.cfm, the browsers grinds away trying to connect, (and does access the directory, including displaying the favicon for CF) but then the browser times out with a message referring to the DNS. (I would give you the message, but the browser is still grinding away without timing out...) -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, April 29, 2011 5:35 PM To: cf-talk Subject: Re: Can't open cfadmin after installing CFBuilder Beta 2 Yes, I can run ping localhost from a command prompt and get: Pinging WSM-MAIN [::1] with 32 bytes of data: Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Reply from ::1: time1ms Ping statistics for ::1: Packets: Sent = 4, Received = 4, Lost = 0 0% loss, In your TCP/IP configuration, disable IPv6 and make sure IPv4 is enabled, and try again. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
I've been using F5 to refresh (doesn't that bypass cache?) but I went ahead and cleared the cache in case that was the problem... it didn't help. And it's happening the same way in FF as in IE. -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Friday, April 29, 2011 7:36 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 Just for additional info, when I try to browse to http://127.0.0.1/cfide/administrator/index.cfm, I get a 404, The webpage cannot be found. However, it's apparently accessing the directory, because the CF favicon is displayed on the tab. are you sure that's not from your browser cache? No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3603 - Release Date: 04/28/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't open cfadmin after installing CFBuilder Beta 2
Ok... I've got the stuff... here you go: Windows IP Configuration Host Name . . . . . . . . . . . . : WSM-MAIN Primary Dns Suffix . . . . . . . : Node Type . . . . . . . . . . . . : Hybrid IP Routing Enabled. . . . . . . . : No WINS Proxy Enabled. . . . . . . . : No Ethernet adapter Local Area Connection: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Intel(R) 82578DC Gigabit Network Connection Physical Address. . . . . . . . . : 90-FB-A6-2B-54-98 DHCP Enabled. . . . . . . . . . . : No Autoconfiguration Enabled . . . . : Yes IPv4 Address. . . . . . . . . . . : 172.16.0.254(Preferred) Subnet Mask . . . . . . . . . . . : 255.255.255.255 IPv4 Address. . . . . . . . . . . : 192.168.1.101(Preferred) Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.1.1 DNS Servers . . . . . . . . . . . : 68.87.68.166 68.87.74.166 NetBIOS over Tcpip. . . . . . . . : Enabled Ethernet adapter VirtualBox Host-Only Network: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : VirtualBox Host-Only Ethernet Adapter Physical Address. . . . . . . . . : 08-00-27-00-18-1E DHCP Enabled. . . . . . . . . . . : No Autoconfiguration Enabled . . . . : Yes Link-local IPv6 Address . . . . . : fe80::2133:4df9:9bcb:a5aa%16(Preferred) IPv4 Address. . . . . . . . . . . : 192.168.56.1(Preferred) Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : DHCPv6 IAID . . . . . . . . . . . : 352845863 DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-A6-E3-CF-90-FB-A6-2B-54-98 DNS Servers . . . . . . . . . . . : fec0:0:0:::1%1 fec0:0:0:::2%1 fec0:0:0:::3%1 NetBIOS over Tcpip. . . . . . . . : Enabled Tunnel adapter isatap.{AC78372A-C87F-49F1-8A40-0FE633211D17}: Media State . . . . . . . . . . . : Media disconnected Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Microsoft ISATAP Adapter Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0 DHCP Enabled. . . . . . . . . . . : No Autoconfiguration Enabled . . . . : Yes Tunnel adapter Teredo Tunneling Pseudo-Interface: Media State . . . . . . . . . . . : Media disconnected Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Teredo Tunneling Pseudo-Interface Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0 DHCP Enabled. . . . . . . . . . . : No Autoconfiguration Enabled . . . . : Yes Tunnel adapter isatap.{4548BFF0-7CEE-45F0-B33D-35E74BC0A95A}: Media State . . . . . . . . . . . : Media disconnected Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Microsoft ISATAP Adapter #2 Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0 DHCP Enabled. . . . . . . . . . . : No Autoconfiguration Enabled . . . . : Yes -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Friday, April 29, 2011 7:43 PM To: cf-talk Subject: RE: Can't open cfadmin after installing CFBuilder Beta 2 Hi Rick, Get to a command prompt and type: ipconfig /all that shows you all of your tcp/ip settings. check that the DNS servers listed are correct and that your IP address is correct. If they are, type: ipconfig /all mystuff.txt to create a file then post the contents of mystuff.txt here so we can take a look. In your TCP/IP settings do you have a static IP address and an IP address IP address set, or are you picking them up from your ISP's DHCP server? Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3603 - Release Date: 04/28/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Choosing Today's Records from a MySQL Database
Hi geniuses! I have a MySQL table with a field (fieldtype = timestamp) named DateTime, and whenever a record is added to this table, the DateTime field automatically enters the current date and time. In a query, I want to choose only those records that were entered today, like this: WHERE ColumnName.DateTime = today How do I format the today part of the WHERE clause? Sco ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Choosing Today's Records from a MySQL Database
Something like this? Where date(columnName) = date(now()) .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Scott Williams [mailto:myscottwilli...@yahoo.com] Sent: Friday, April 29, 2011 10:20 PM To: cf-talk Subject: Choosing Today's Records from a MySQL Database Hi geniuses! I have a MySQL table with a field (fieldtype = timestamp) named DateTime, and whenever a record is added to this table, the DateTime field automatically enters the current date and time. In a query, I want to choose only those records that were entered today, like this: WHERE ColumnName.DateTime = today How do I format the today part of the WHERE clause? Sco ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Choosing Today's Records from a MySQL Database
yes. From: Bobby Hartsfield bo...@acoderslife.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, April 29, 2011 7:40 PM Subject: Re: Choosing Today's Records from a MySQL Database Something like this? Where date(columnName) = date(now()) .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Scott Williams [mailto:myscottwilli...@yahoo.com] Sent: Friday, April 29, 2011 10:20 PM To: cf-talk Subject: Choosing Today's Records from a MySQL Database Hi geniuses! I have a MySQL table with a field (fieldtype = timestamp) named DateTime, and whenever a record is added to this table, the DateTime field automatically enters the current date and time. In a query, I want to choose only those records that were entered today, like this: WHERE ColumnName.DateTime = today How do I format the today part of the WHERE clause? Sco ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm