Re: FW: Error Diagnostic Information ?
If I remember correctly... I would get these from time to time when my cfml was causing the CFserver to Restart. Usually associated with a query that was upsetting in some way. And always baffling until I tried the queries by pasting into another query tool or some such... Perhaps cf is throwing up on the query result... the error message perhaps ... just wild guesses actually. At 09:50 AM 7/23/02, you wrote: >OK. I never ask unless I am stumped. > >I'm sure somebody has run into this b/c when I do a search on the 'Net >for the error, I get links to various other CFM web pages that have >thrown the error while being indexed by the search engines. > >Here goes First the stats: > >Server: Windows NT 4.0 ~ I suspect with all the most current updates >(Shared host~ XO Communications) CF Server: 4.5 ~ patched and updated I >hope! >Database: Access 2000 (Sorry, I can't afford a Lexus either.) >Connection: OC48 dual redundant to the backbone (so they say!) > >Client: >OS: Windows 98/2000/XP >Browser: IE6 >Connection: DSL >Cache: Clear w/ 1 meg storage setting and "Every visit..." checked. > >XX >ERROR::: > >XX > >Error Occurred While Processing Request >Error Diagnostic Information >An error occurred while attempting to establish a connection to the >service. > >The most likely cause of this problem is that the service is not >currently running. You can use the 'Services' Control Panel to verify >that the service is running and to restart it if necessary. > >Windows NT error number 2 occurred. > >XX >PAGE >CODE >:: >XX > > > >select * >from agentid >where customerid=#customerid# > > > > > > > >This page uses frames, but your browser doesn't support them. > > > > >I made absolute paths out of the individual frames for ease of lookup... >It is broken either way, absolute or relative. > >This error happens intermittently...sometimes often, other times it >takes several refreshes to get it to happenclearing the cache helps >ensure the error is seen. > >Sometimes one frame will work, other times 2 frame pages will resolve >and one will not...there is no rhyme or reason I can see. > >I have tried to isolate this as a browser issue or an OS problem, but I >really think it is either a codeing problem or a Server issue. ( I'm >praying it's their fault and they can fix it.) > >The most I could find out about "Windows NT error number 2" is that it >means "Page not found" (Duhuh... Another egregious waste of syntax by >our good friends at MS!) > > > > > >This, CF Developers, is your missionshould you choose to accept >it. > > >This message will self destruct in 5..4...3...2 > >Thanks. >Michael Pool >[EMAIL PROTECTED] > > > > > > > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX CFM/JSP/Servlets/Beans Compile?
You can find this discussion in a thread responded to by Pete Ruckelshaus: 'CFMX Spidering for cache' on June 18th... I think it is cfml code that spiders some directories and compiles what it finds. It seems like this is something that should be built into the start procedures for CFMX... perhaps throttled down 50% to allow users to still hit the site. At 08:51 PM 7/22/02, you wrote: >Yes there is, and it was posted to this list a while back. I can not >find the message though. Try searching the archives. > >-- >jon >mailto:[EMAIL PROTECTED] > >Monday, July 22, 2002, 8:48:05 PM, you wrote: > >JE> Sorry for the Re-Post.. but does anybody have any ideas? >JE> Hi All, >JE> I was wondering if there is a Command/Utility to compile JSP/CFM pages >JE> in CFMX.. like a comand line utility rather than having to RUN the >JE> the pages. How are Java Beans/Servlets compiled in CFMX? >JE> Do you have use TOMCAT/JRUN? or just put the Beans/Servlets(classes) in >JE> the WEB-INF\cfclasses directory? > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX caching...
At 09:52 PM 7/11/02, you wrote: >Sounds like Apache. > >-Original Message- >From: mark brinkworth [mailto:[EMAIL PROTECTED]] >Sent: Friday, 12 July 2002 2:38 PM >To: CF-Talk >Subject: RE: CFMX caching... I wish is was just Apache. I just installed CFMX onto a Win2k box with IIS. The problem is following CFMX around. Works fine in CF5 but the browser cache holds nothing if the contents came from a post. Just to test things I have been posting and then hitting the back button on lots of sites without a problem... but now mine is throwing this infernal error. It has been awhile so I will restate the trouble here from a post July 9th: - I switched to CFMX a few days ago... (early July now) Suddenly (when clicking back) Many pages declare the Warning: Page has Expired. The page you requested was created using information you submitted in a form. This page is no longer available. To resubmit your information and view this Web page, click the Refresh button. This is NEW behavior in just the last few days and I am having trouble tracking it down. I have pulled out all the META caching tags like: but I am still getting all the Warnings. Prior to CFMX I had no problems backing up across the pages... Anyone know what might be doing this? -- Thanks, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX JDBC Drivers
Thank Ryan, That was a great idea. It works for me too... but yes I do expect a performance hit. Brian At 02:23 PM 7/22/02, you wrote: >As a temporary fix, you could always try an ODBC Socket connection. Here's >what you do: set the DEN in the Windows ODBC Admin, then go to the admin >panel in MX and select the ODBC Socket driver. Then select your DSN you set >up in the ODBC Admin and there you go. Could be a performance hit, but at >least it will get you going until you can tweak the other setup. > >Ryan Kime > >-Original Message- >From: Alexander Sherwood [mailto:[EMAIL PROTECTED]] >Sent: Monday, July 22, 2002 4:12 PM >To: CF-Talk >Subject: CFMX JDBC Drivers > > >Man, this is maddening. > >I have CFMX installed on a Win2K box that can make JDBC connections using >the supplied drivers to several different SQL Server 2000 boxes. I cannot, >however, make a connection to an instance of SQL Server 2000 Enterprise >Edition. > >A thread on the CF Forums had several posts from users with similar >problems. Most just reinstalled their OS and CFMX, which I refuse to do at >this point. With this being the only apparent fix, it would seem that the >problem lies within CFMX, despite the fact that my server can connect to >non-Enterprise instances of SQL Server 2000. I could not find anything that >would lead me to believe that SQL 2K Enterprise needs special configuration >or prep for JDBC connections. > >I also tried to get the MSFT JDBC Drivers working (with info from this >list) and I could not get it to work either. > >The exact error message: "The root cause was that: java.sql.SQLException: >SQLException occurred in JDBCPool while attempting to connect, please check >your username, password, URL, and other connectivity info." All of the >connection info is correct. > >Judging by the sheer number of posts in the forumn at macromedia.com, I >assume that this is not a "1 user" configuration problem. > >Any ideas or similar problems??!?! > > >Thanks, > >-- >Alex Sherwood >PHS Collection Agency >THE COLLECTORS >301.215.4200 T >301.664.6834 F >www.phs-net.com > >FAQ: http://www.thenetprofits.co.uk/coldfusion/faq >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmx and SQL Server Data Source Configuration
YES, just confirmed connection using username and password via ODBC control panel... then went back to CFAdministrator and tried various ways of making it connect... still a failure. At 02:22 PM 7/22/02, you wrote: >> I have been attempting to get the datasource configuration >> module of the CFMX Administrator to accept my configuration >> settings I made in the SQL Administrator... Not sure what to >> try next. I expect I have something bassakwards seeing as how >> I'm not really SQL server savvy. > >Are you able to verify an ODBC connection with that username and password >through the ODBC Control Panel? > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmx and SQL Server Data Source Configuration
At 01:21 PM 7/22/02, you wrote: >In CF 5, you could use trusted connections via Windows authentication to >talk to SQL Server. In CF MX, you can't do that; your SQL Server will need >to allow "native" SQL logins (usernames and passwords) I have SQL Admin rights. I deleted the DSN that lives in the Windows/Control Panel/Datasources dialog. Then in the SLQ Administrator I clicked to allow both SLQ and Window Logins. Next I Explicitly made a username associated with the particular database and assigned a password. > and you'll have to >put them in your datasource configuration or within USERNAME and PASSWORD >attributes of CFQUERY. I have been attempting to get the datasource configuration module of the CFMX Administrator to accept my configuration settings I made in the SQL Administrator... Not sure what to try next. I expect I have something bassakwards seeing as how I'm not really SQL server savvy. >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmx and SQL Server Data Source Configuration
I just upgraded from CF5 to CFMX by Uninstalling CF5 and then Installing CFMX. For the last three hours I have been trying to re-establish datasource connections to SQL server which is running on the same box without any luck. This is the error: --- Connection verification failed for data source: cfusion_clientreg []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Any hints from anyone who has already done this? Thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Need quick SQL Server Advice
Paul, Doug Thanks! At midnight things get blurry At 11:48 PM 7/17/02, you wrote: >SELECT TOP 8 * >FROM SPCData, Device > WHERE SPCData.SPCDitem_ID = 1 > AND SPCData.SPC_Device_ID = Device.Device_ID > ORDER BY SPCData_ID DESC > > > > >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.375 / Virus Database: 210 - Release Date: 10/7/2545 > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Need quick SQL Server Advice
I have a query that works well with postgreSQL I just uploaded the code to a SQL Server installation and this query is failing with the Error: --- Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near 'LIMIT'. SQL = "SELECT * FROM SPCData, Device WHERE SPCData.SPCDitem_ID = 1 AND SPCData.SPC_Device_ID = Device.Device_ID ORDER BY SPCData_ID DESC LIMIT 8" My guess is that SQLSERVER has another Verb besides Limit to restrict the rows returned to 8. What would that be? Thanks, Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: curious about application.cfm behavior
Yes, CF moves up the directory tree looking for an application.cfm and uses the first one it comes across. At 08:24 AM 7/17/02, you wrote: >Hello everyone, > >I came across a behavior today that I was never previously aware of. Just thought I'd >share and see what exactly is happening. > >Say you have two applications, one in webroot/parent/ and one in >webroot/parent/child/. Also, say that there is NO application.cfm in >webroot/parent/child/ but there IS in webroot/parent/. It seems that any request to a >page in webroot/parent/child/ will "reach up" and run application.cfm in the >webroot/parent/ directory. When I put an application.cfm in webroot/parent/child/, >this no longer happened. > >Is this a known "feature" of ColdFusion? I've never read about it, and never noticed >it happen. We're running CFMX on Win2000 Server with IIS 5. > >Anyone have any comments on this? > >Thanks >Mike Mertsock >Alfred University Webteam > > >_ >Supercharge your e-mail with a 25MB Inbox, POP3 Access, No Ads >and NoTaglines --> LYCOS MAIL PLUS. >http://www.mail.lycos.com/brandPage.shtml?pageId=plus >FAQ: http://www.thenetprofits.co.uk/coldfusion/faq >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing Queries in Application Scope
Ben, Please clarify for me. I'm a bit slow as others on the list can attest to. ;-) Are you saying that in the background, CFMX will upload patches and hotfixes? And then CFMX will install those patches and hotfixes on the CFMX server? Thanks, Brian At 11:23 AM 7/12/02, you wrote: >Todd, > >I was in Newton this week and spent some time with the CF team, they are >reviewing this right now. A service pack is not out of the question, but >as I said, none is planned right now. > >The good news is that CFMX was designed to very easily allow patches or >hotfixes, CFMX itself looks for them and loads them automatically if >present (without needing a full reinstall as was the case in prior >CF's), so there are other options beyond service packs (options that can >be created and deployed far quicker and easier if needed). > >Now, I am not saying they'll be a patch or hotfix yet, but I am saying >that the few known problems areas (COM being the biggest) are being >looked at right now, and as soon as the engineering team has worked out >what the best course of action is they'll be an announcement. > >Heck, I'll post a message here myself as soon as I hear anything. > >--- Ben > > > > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Friday, July 12, 2002 2:07 PM >To: CF-Talk >Subject: RE: Storing Queries in Application Scope > > >Ben, > >What about 3rd party upgrades...? Example given: Axis - Are those being > >released in the form of a patch or perhaps instructions on how to do it? > >Same thing with the jre? > >Just curious. > >~Todd > >On Fri, 12 Jul 2002, Ben Forta wrote: > >> Douglas, >> >> Well, if you are planning to wait for an SP you could end up waiting >> for a long long time, there is no SP scheduled at this time. >> >> And while there have been posts here about problems upgrading, realize > >> that there are a couple of thousand subscribers to this list (and far >> less than that are regular contributors) and that is a very small >> percentage of the CF user base - the reality is that most users have >> not experienced upgrade problems at all. With the exception of COM >> (which is being looked at) and the documented changes (e.g. advanced >> security, dynamic database connections) this has actually been a very >> painless upgrade for most (far less painful than say CF3.x to CF4 or >> CF4 to CF4.5). >> >> Hope this helps. >> >> --- Ben > >-- > >Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | >Team Macromedia Volunteer for ColdFusion | >http://www.macromedia.com/support/forums/team_macromedia/ | >http://www.flashCFM.com/ - webRat (Moderator)| >http://www.ultrashock.com/ - webRat (Back-end Moderator) | > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: importing .dbfs into Access...
Rewrite the script to do it in pieces. My guess... a guess mind you... is that you are most likely running out of memory. At 09:58 AM 7/12/02, you wrote: >Hello CF Gurus, > >I need to write a script that will import a 180MEG dbf file into an empty Access >table. My first attempt at going about this was a simple script that >queried the dbf file, then a 2nd query imported the results of the 1st query into the >Access table. When testing on files around 9MEGS the script worked fine >but attempting to import the 180MEG database that I need, the script crashes. Any >other ideas or approaches as to how to get this file imported (besides manually in >Access) would be appreciated. > >Thanks in advanced for any help > >-Paul > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFmail can only deliver to our domain name...
Just an idea you might want to check out... If you are being hosted by an ISP and you are not in control of your SMPT server you might find that it is rejecting them because the from:address is not allowed to be off the domain the SMPT is serving. At 07:51 AM 7/12/02, you wrote: >I sent 180 different emails generated from our db in that way: > >BATCH #1: >to myself with the From being '[EMAIL PROTECTED]' and the To: >'[EMAIL PROTECTED]' >Worked just fine. > >BATCH #2: >to myself with the From being '[EMAIL PROTECTED]' and the To: >'[EMAIL PROTECTED]' >Worked just fine. > >BATCH #3: >to myself with the From being a list of 180 different emails not related to our >domain name: 'circumvista.com' such as '[EMAIL PROTECTED]' and 3 emails that were: >'[EMAIL PROTECTED]' >'[EMAIL PROTECTED]' >'[EMAIL PROTECTED]' > >and the To: '[EMAIL PROTECTED]' > >Results: only the 3 above emails sent to our domain were successfully received >all other ones were dumped in the undeliverable bin and transferring them in the >spool would just dump them again. > >I did the tests twice each time with the same results. >Our box is scanned daily for virus by Norton with the latest updates. >Does someone can explain this weird behavior of CFmail? >It used to work just fine with hundred's of emails. > >Thanks in advance, > >Philippe Varichon > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Alter Column syntax in Oracle?
This should help: http://info-it.umsystem.edu/oradocs/doc/server/doc/SQL73/ch4a.htm#toc064 At 12:42 AM 7/12/02, you wrote: >I want to change a varchar2 field from 10 characters to 50. I can't >seem to get the syntax right. I'm not all that familiar with Oracle. >What am I doing wrong here? This and all the variations I can dream up >aren't working. > >ALTER TABLE users ALTER COLUMN ( UserName VARCHAR2(50) ); > >Any insight would be really appreciated! > >--Matt Robertson-- >MSB Designs, Inc. >http://mysecretbase.com > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX caching...
Peter I'm listening... :-) At 09:52 PM 7/11/02, you wrote: >Sounds like Apache. > >-Original Message- >From: mark brinkworth [mailto:[EMAIL PROTECTED]] >Sent: Friday, 12 July 2002 2:38 PM >To: CF-Talk >Subject: RE: CFMX caching... > > >You are right, that gives little away at all. Not sure which way to go from >here to solve this one. > > >>From: Brian Scandale <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>To: CF-Talk <[EMAIL PROTECTED]> >>Subject: RE: CFMX caching... >>Date: Thu, 11 Jul 2002 02:01:42 -0700 >> >>That worked like a champ Mark. These are the two results... Nothing >>obvious >>to me as to why I can backup into the previous page without having to >>repost with CF5 but not CFMX. >> >>- >>This is from CFMX/Apache --- backs up but forces a RePost >>- >>Connection Keep-Alive >>Content-Typetext/html; charset=UTF-8 >>DateThu, 11 Jul 2002 08:37:25 GMT >>Explanation OK >>Http_VersionHTTP/1.1 >>Keep-Alive timeout=15, max=500 >>Server Apache/1.3.23 (Unix) (Red-Hat/Linux) mod_ssl/2.8.7 >>OpenSSL/0.9.6b >>DAV/1.0.3 PHP/4.1.2 mod_perl/1.26 >>Status_Code 200 >>Transfer-Encoding chunked >>content-length 0 >> >>- >>This is CF5/IIS --- backsup WITHOUT forcing a RePost >>- >>CONTENT-TYPE text/html >>DATE Thu, 11 Jul 2002 08:46:59 GMT >>EXPLANATION OK >>HTTP_VERSION HTTP/1.1 >>PAGE-COMPLETION-STATUS Normal >>SERVER Microsoft-IIS/5.0 >>STATUS_CODE 200 >> >> >> >> >>At 07:52 PM 7/10/02, you wrote: >> >You can see the headers by getting CF to display them after doing a >>CFHTTP. >> >Try this >> > >> >Put the following code in a file in the web root: >> > >> > >> >Then place a file called x.cfm in the web root, that just does >> >something simple like >> > >> > >> >Then run the first file. You should get a dump of the HTTP headers >> >that >>were >> >sent back. What headers do you get? >> > >> >Cheers, >> >Mark >> > >> > >> > >> > >> > >> >>From: Brian Scandale <[EMAIL PROTECTED]> >> >>Reply-To: [EMAIL PROTECTED] >> >>To: CF-Talk <[EMAIL PROTECTED]> >> >>Subject: RE: CFMX caching... >> >>Date: Wed, 10 Jul 2002 10:52:25 -0700 >> >> >> >>Just noticed that the included header from my last post was stripped >> >>out because it contained a cut and paste of the header... >> >>htlm,javascript >>and >> >>all... I'll try again with the javascript pulled out and the tags >>mangled. >> >> >> >>- the top of the file with the header >> >>!-- Application --> >> >>!-- index --> >> >>html>head> >> >>title>WIPtrac - WORK IN PROCESS Mfg Execution Systems/title> >> >>link rel="STYLESHEET" type="text/css" href="msie.css"> >> >>meta http-equiv="Content-Type" content="text/html; >> >>charset=iso-8859-1"> /head> body leftmargin="0" topmargin="0" >> >>onLoad="firstFocus()"> >> >> end -- >> >> >> >>just a normal looking header section. >> >> >> >> >> >>At 01:28 AM 7/10/02, you wrote: >> >> >At 12:55 AM 7/10/02, you wrote: >> >> >>The first question you have to ask yourself is, what changed? >> >> > >> >> >Just pulled CF5 off a dev machine and put CFMX up... then the >> >> >trouble >> >>started. >> >> >the same code still works well on a CF5 production machine. >> >> > >> >> >>Are you >> >> >>sure the only difference is CFMX? What web server are you using? >> >> > >> >> >Still using the same ole apache that was being used with CF5... >> >> >but >>now >> >>the annoying RePost Messages all over the place!!! Very annoying. >> >> > >> >> >The production machine is IIS and CF5 >> >> > >> >> > >> >> >> Are you >> >> >>now using CFMX's built-in web server instead of an external one >> >> >>like with CF 5? >> >> >> >> >> >>Generally speaking, page expiration is based on web server >> >> >>generated headers. >> >> > >> >> >S Glad you asked. ;-) This is the header off the CFMX >> >> >machine... >> >>looks Just like the header off the CF5 machine with the exception of >> >>the variation in the Javascript... CFMX now references the cfform >> >>scripts rather than pasting them into the header. >> >> > >> >> > >> > >> > >> > >> > >> > >> > >> > >> > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX caching...
That worked like a champ Mark. These are the two results... Nothing obvious to me as to why I can backup into the previous page without having to repost with CF5 but not CFMX. - This is from CFMX/Apache --- backs up but forces a RePost - Connection Keep-Alive Content-Typetext/html; charset=UTF-8 DateThu, 11 Jul 2002 08:37:25 GMT Explanation OK Http_VersionHTTP/1.1 Keep-Alive timeout=15, max=500 Server Apache/1.3.23 (Unix) (Red-Hat/Linux) mod_ssl/2.8.7 OpenSSL/0.9.6b DAV/1.0.3 PHP/4.1.2 mod_perl/1.26 Status_Code 200 Transfer-Encoding chunked content-length 0 - This is CF5/IIS --- backsup WITHOUT forcing a RePost - CONTENT-TYPE text/html DATE Thu, 11 Jul 2002 08:46:59 GMT EXPLANATION OK HTTP_VERSION HTTP/1.1 PAGE-COMPLETION-STATUS Normal SERVER Microsoft-IIS/5.0 STATUS_CODE 200 At 07:52 PM 7/10/02, you wrote: >You can see the headers by getting CF to display them after doing a CFHTTP. >Try this > >Put the following code in a file in the web root: > > >Then place a file called x.cfm in the web root, that just does something >simple like > > > >Then run the first file. You should get a dump of the HTTP headers that were >sent back. What headers do you get? > >Cheers, >Mark > > > > > >>From: Brian Scandale <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>To: CF-Talk <[EMAIL PROTECTED]> >>Subject: RE: CFMX caching... >>Date: Wed, 10 Jul 2002 10:52:25 -0700 >> >>Just noticed that the included header from my last post was stripped out >>because it contained a cut and paste of the header... htlm,javascript and >>all... I'll try again with the javascript pulled out and the tags mangled. >> >>- the top of the file with the header >>!-- Application --> >>!-- index --> >>html>head> >>title>WIPtrac - WORK IN PROCESS Mfg Execution Systems/title> >>link rel="STYLESHEET" type="text/css" href="msie.css"> >>meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> >>/head> >>body leftmargin="0" topmargin="0" onLoad="firstFocus()"> >> end -- >> >>just a normal looking header section. >> >> >>At 01:28 AM 7/10/02, you wrote: >> >At 12:55 AM 7/10/02, you wrote: >> >>The first question you have to ask yourself is, what changed? >> > >> >Just pulled CF5 off a dev machine and put CFMX up... then the trouble >>started. >> >the same code still works well on a CF5 production machine. >> > >> >>Are you >> >>sure the only difference is CFMX? What web server are you using? >> > >> >Still using the same ole apache that was being used with CF5... but now >>the annoying RePost Messages all over the place!!! Very annoying. >> > >> >The production machine is IIS and CF5 >> > >> > >> >> Are you >> >>now using CFMX's built-in web server instead of an external one like >> >>with CF 5? >> >> >> >>Generally speaking, page expiration is based on web server generated >> >>headers. >> > >> >S Glad you asked. ;-) This is the header off the CFMX machine... >>looks Just like the header off the CF5 machine with the exception of the >>variation in the Javascript... CFMX now references the cfform scripts >>rather than pasting them into the header. >> > >> > > > > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL question...
Thanks a zillion Nelson! Knew it had to be easy... just never used that before but it works Great! At 08:00 PM 7/10/02, you wrote: >Oops I forgot the "/" on the : > > > > >- Original Message - >From: "Nelson Winters" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, July 10, 2002 10:56 PM >Subject: Re: SQL question... > > >> Here's one way to do it using the group parameter of cfoutput. >> >> >> >> >> >> >> >> #PartType# >> #PartName# >> #InStock# >> >> >> >> >> SubTotal: >> >> #Total# >> >> >> >> >> - Original Message - >> From: "Brian Scandale" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Wednesday, July 10, 2002 10:34 PM >> Subject: SQL question... >> >> >> > I now this is quite simple... however I need clues to get me started... >> > How does one go about breaking out the various subtotals from a dataset? >> > >> > Example: >> > In this example table there are multiples of the same parttype. >> > >> > parttype partnameinstock >> > --- >> > carparts mufflerX 25 >> > carparts mufflerY 15 >> > carparts engineSA 12 >> > carparts wheel12 27 >> > planeparts wingZ 9 >> > planeparts rudderQ3 >> > planeparts engineRR 2 >> > >> > Would typically do something like this in CF >> > >> > Select * >> > From parts >> > Order by parttype >> > >> > >> > >> >#thelist.PartType##thelist.PartName# >> > >> > >> > Would like to be able to generate subtotals...like this: >> > >> > parttype partname instock >> > --- >> > carparts mufflerX 25 >> > carparts mufflerY 15 >> > carparts engineSA 12 >> > carparts wheel1227 >> > SUBTOTAL - - >> > 79 >> > >> > planeparts wingZ 9 >> > planeparts rudderQ 3 >> > planeparts engineRR 2 >> > SUBTOTAL --- -- >> > 14 >> > >> > Thanks for any and all hints. ;-) >> > Brian >> > >> > >> > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL question...
I now this is quite simple... however I need clues to get me started...
How does one go about breaking out the various subtotals from a dataset?
Example:
In this example table there are multiples of the same parttype.
parttype partnameinstock
---
carparts mufflerX 25
carparts mufflerY 15
carparts engineSA 12
carparts wheel12 27
planeparts wingZ 9
planeparts rudderQ3
planeparts engineRR 2
Would typically do something like this in CF
Select *
From parts
Order by parttype
#thelist.PartType##thelist.PartName#
Would like to be able to generate subtotals...like this:
parttype partname instock
---
carparts mufflerX 25
carparts mufflerY 15
carparts engineSA 12
carparts wheel1227
SUBTOTAL - -
79
planeparts wingZ 9
planeparts rudderQ 3
planeparts engineRR 2
SUBTOTAL --- --
14
Thanks for any and all hints. ;-)
Brian
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX caching...
Just noticed that the included header from my last post was stripped out because it contained a cut and paste of the header... htlm,javascript and all... I'll try again with the javascript pulled out and the tags mangled. - the top of the file with the header !-- Application --> !-- index --> html>head> title>WIPtrac - WORK IN PROCESS Mfg Execution Systems/title> link rel="STYLESHEET" type="text/css" href="msie.css"> meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> /head> body leftmargin="0" topmargin="0" onLoad="firstFocus()"> end -- just a normal looking header section. At 01:28 AM 7/10/02, you wrote: >At 12:55 AM 7/10/02, you wrote: >>The first question you have to ask yourself is, what changed? > >Just pulled CF5 off a dev machine and put CFMX up... then the trouble started. >the same code still works well on a CF5 production machine. > >>Are you >>sure the only difference is CFMX? What web server are you using? > >Still using the same ole apache that was being used with CF5... but now the annoying >RePost Messages all over the place!!! Very annoying. > >The production machine is IIS and CF5 > > >> Are you >>now using CFMX's built-in web server instead of an external one like >>with CF 5? >> >>Generally speaking, page expiration is based on web server generated >>headers. > >S Glad you asked. ;-) This is the header off the CFMX machine... looks Just like >the header off the CF5 machine with the exception of the variation in the >Javascript... CFMX now references the cfform scripts rather than pasting them into >the header. > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX caching...
At 12:55 AM 7/10/02, you wrote:
>The first question you have to ask yourself is, what changed?
Just pulled CF5 off a dev machine and put CFMX up... then the trouble started.
the same code still works well on a CF5 production machine.
>Are you
>sure the only difference is CFMX? What web server are you using?
Still using the same ole apache that was being used with CF5... but now the annoying
RePost Messages all over the place!!! Very annoying.
The production machine is IIS and CF5
> Are you
>now using CFMX's built-in web server instead of an external one like
>with CF 5?
>
>Generally speaking, page expiration is based on web server generated
>headers.
S Glad you asked. ;-) This is the header off the CFMX machine... looks Just like
the header off the CF5 machine with the exception of the variation in the
Javascript... CFMX now references the cfform scripts rather than pasting them into the
header.
WIPtrac - WORK IN PROCESS Mfg Execution Systems
function loadinparent(url, closeSelf){
self.opener.location = url;
if(closeSelf) self.close();
}
var newWin;
function popUp(page, name, details) {
newWin=window.open(page, name, details);
newWin.focus();
return false;
}
function firstFocus() {
if (document.forms.length > 0) {
for (j=0;j
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access on CFMX Linux?
Perhaps just dump the subscriber list to a csv file, and use that as the input to your app... Assuming it's a once a month affair it could work. At 11:14 PM 7/9/02, you wrote: >Thanks Matt, Peter for your advise. > >The situation I'm in is my customer is given MS Access databases which >contains subscribers' info. He needs to use the data to generate >newsletter emails to these subscribers. Unfortunately, the hosting setup >is on Linux and that's what I was concerned about. Part of my app will >be to to read in targeted subscribers in the database and send the email >newsletter out. From your responses, does that mean the best way would >be to migrate the data from the MS Access database to MySQL/Postgres >everytime? > >Thank you and regards >David Siew > > >-Original Message- >From: Matt Liotta [mailto:[EMAIL PROTECTED]] >Sent: 10 July 2002 13:47 >To: CF-Talk >Subject: RE: Access on CFMX Linux? > > >Generally speaking, nothing should be referred to as a database unless >it is ACID compliant. MySQL is not ACID compliant therefore it makes >more sense to think of it as a SQL interface to a file system than a >database. > >Matt Liotta >President & CEO >Montara Software, Inc. >http://www.montarasoftware.com/ >V: 415-577-8070 >F: 415-341-8906 >P: [EMAIL PROTECTED] > >> -Original Message- >> From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, July 09, 2002 10:26 PM >> To: CF-Talk >> Subject: RE: Access on CFMX Linux? >> >> Like MySQL >> >> -Original Message- >> From: Matt Liotta [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, 10 July 2002 3:20 PM >> To: CF-Talk >> Subject: RE: Access on CFMX Linux? >> >> >> Well, yes and no. It is possible to run MS Access using Wine, but I >would >> highly recommend against it. If you are just looking for a cheap (free >> even) >> database that is easy to use and works with CFMX then check out some >of >> the >> open source databases. >> >> Matt Liotta >> President & CEO >> Montara Software, Inc. >> http://www.montarasoftware.com/ >> V: 415-577-8070 >> F: 415-341-8906 >> P: [EMAIL PROTECTED] >> >> > -Original Message- >> > From: David Siew [mailto:[EMAIL PROTECTED]] >> > Sent: Tuesday, July 09, 2002 10:25 PM >> > To: CF-Talk >> > Subject: Access on CFMX Linux? >> > >> > Hi all, >> > >> > Sorry. I havent got experience with CF on Linux. >> > >> > Is there anyway that I can set up a MS Access database as a >datasource >> > on a Linux server installed with CFMX? Any advise is much >appreciated. >> > >> > Thank you and regards >> > David >> > >> > >> >> > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access on CFMX Linux?
Yeah, perhaps true but truthfully mySQL smokes as a readonly filesystem... Different tools for different problems. Hey while you're at it maybe one of you geniuses can help me get my head around my problem with CFMX vs CFM5 causing a "Refresh to Repost the Form Data" notice on the exact same code but with only the server being different. I have a two urls available I can send off list to test with if you think you might have an idea. The current discussions today (RE: CFMX caching...) give insight but still no Cigar! Any takers? At 11:28 PM 7/9/02, you wrote: >You may be shocked to realize that I disagree. While conforming to the >exact definition of an RDBMS doesn't require one to be ACID compliant, >it is assumed that ACID compliance is a standard feature of a database. >If you want to debate on definitions then surely I would lose. However, >if you take a look at the expectations of database customers, you will >see that ACID compliance is assumed. Thus, any RDBMS that isn't ACID >compliant should be pointed out as such to keep people from finding out >the hardware. > >If you want to talk theory a little then you might look at what >functionality differentiates a database from a file system. You might be >surprised to learn that MySQL is closer to a SQL front-ended file system >than the traditional idea of a database. Again, ACID compliance being >the main difference. > >For those interested in history, you might check out MySQL's roots. >Again you will see that MySQL started out as a really complex file >system that is slowly making its way towards that of a traditional >database. > >Matt Liotta >President & CEO >Montara Software, Inc. >http://www.montarasoftware.com/ >V: 415-577-8070 >F: 415-341-8906 >P: [EMAIL PROTECTED] > >> -Original Message- >> From: Dave Watts [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, July 09, 2002 11:21 PM >> To: CF-Talk >> Subject: RE: Access on CFMX Linux? >> >> > Generally speaking, nothing should be referred to as a >> > database unless it is ACID compliant. >> >> That seems like an awfully stringent definition. How do you justify >that >> restriction on a common term of art which generally is interpreted >pretty >> broadly? There are lots of databases that aren't adequate for handling >> transactions, but that doesn't mean they're not databases. They might >not >> be >> GOOD databases, but that's another thing entirely. >> >> Dave Watts, CTO, Fig Leaf Software >> http://www.figleaf.com/ >> voice: (202) 797-5496 >> fax: (202) 797-5444 >> > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Skimmin the list.......? [oT]
Way to go critz... Yep. I got the same Spam today too. At 04:16 PM 7/9/02, you wrote: >oi CF-Talk,!! > > I use this addy only for this list. (almost positive) today I received an > email to it from: [EMAIL PROTECTED] ><[EMAIL PROTECTED]> (The Recruitment Consultant) > > someone here sucking off the list ? > >-- >Critz >Certified Advanced Bald White Barefoot ColdFusion Developer > >Crit[s2k] - > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX caching...
At 07:12 PM 7/9/02, you wrote: >I can give you the definitive answer on this after much research. It is >caused by the following: > >1) The user submits a form as a 'post' >2) The browser displays the results of the post >3) The user goes to another page >4) The user hits the back button to return to the results page from the >post >5) The browser has dropped the page from its cache >6) Wisely, the browser asks you if you would like to re-post the form >vars that generated the results page. If it automatically did this for >you, it could trigger repurchases and all other kinds of mayhem. Yes... I understand the above... I only put the javascript:history.back(); in places where it makes sense to use it. The problem is repeatable ... the EXACT same code using the EXACT same computer & browser against CF5 does not ask to repost while against CFMX it does. Looking at the headers shows them to be IDENTICAL... unless you are referring to header information that is not displayed using ViewSource. I'm WAY stumped. >The simplest solution to this is to change your form to 'get' instead of >'post'. This will cause the browser to change all of your form vars to >url vars on the fly. Thus when the user hits the back button, if the >page is no longer cached the browser will reload it without issuing the >workflow-killing refresh error because there is assumed to be no chance >(by convention) of danger. This solution is quite simple and is employed >by ebay. The only limit I know of is url length, which I found to be for >IE 6 about 1250 characters (I forget the exact figure). Could work on some pages... Unfortunately some forms hold 100 plus hidden fields. >There is another way to approach this, to use a javascript trick to try >to change order of the results page in the browser's history so that it >gets confused and will re-post the form without asking permission. I >haven't tried this and I can't speak to whether or not it works. Interesting... but would rather just find the cause and set the appropriate switches to make it stop happening. >So, the reason why this intermittent plague of non-cached form results >happens is related to either 1) the browser version of the user and when >it decides to purge its cache, or 2) the headers and/or meta tags >returned by the server which help it make that decision. While some >browsers give this error 100% of the time, others do it every now and >then, and typically longer into a browsing session. My assumption is >that MX has a different header which is causing a different action by >the browser, although you might have just changed out your browser >without realizing it. For reference, Netscape and Mozilla have this >behavior, too. It is the natural and correct behavior once the cache has >been purged. The optimal solution is getting the browser to always cache >*your* server's pages, but killing the error is the second best option. > >To research further yourself, search in google groups with the text of >your warning. There are hundreds of people asking this very same >question. > >Matt >-- >Matt Wisdom >CTO >Turbo Squid > > > >> -Original Message- >> From: Brian Scandale [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, July 09, 2002 7:39 PM >> To: CF-Talk >> Subject: CFMX caching... >> >> I switched to CFMX a few days ago... >> >> Suddenly (when clicking back) Many pages declare the Warning: Page has >> Expired. The page you requested was created using information you >submitted in a >> form. This page is no longer available. >> >> To resubmit your information and view this Web page, click the Refresh >button. >> >> >> This is NEW behavior in just the last few days and I am having trouble >tracking it >> down. >> >> I have pulled out all the META caching tags like: >> >> >> >> but I am still getting all the Warnings. >> >> Prior to CFMX I had no problems backing up across the pages... Anyone >know >> what might be doing this? >> >> Thanks, >> Brian >> >> >> > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMX caching...
I switched to CFMX a few days ago... Suddenly (when clicking back) Many pages declare the Warning: Page has Expired. The page you requested was created using information you submitted in a form. This page is no longer available. To resubmit your information and view this Web page, click the Refresh button. This is NEW behavior in just the last few days and I am having trouble tracking it down. I have pulled out all the META caching tags like: but I am still getting all the Warnings. Prior to CFMX I had no problems backing up across the pages... Anyone know what might be doing this? Thanks, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfusion_verifymail error in CFMX
The CFusion_VerifyMail(server,port,timeoutInterval) function generates an error in CFMX. Anyone know of a suitable replacement? Thanks, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF SQL Tool
Hey Trent... the zip is missing the style.css file... At 07:18 PM 7/8/02, you wrote: >I apologize.. They are fixed now. > >-- Original Message -- >from: "Tilbrook, Peter" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >date: Tue, 9 Jul 2002 11:09:34 +1000 > >Both of your CF SQL Tool links are for the .rar file :) > >-Original Message- >From: Clint Tredway [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, 9 July 2002 4:14 AM >To: CF-Talk >Subject: CF SQL Tool > > >I have updated my SQL tool and if you would like to help beta test it go >here. > >http://www.factorxsoftware.com/download/ > >I would appreciate any feedback. this is feature complete for version 1 and >I need help testing it for bugs. > >To use the tool, just unzip it on your server and you are good to go. It is >not encrypted because there is no point to encrypt it. It is also IE 5+ >only. > >Thanks, >Clint > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
date field formats in CFMX
I have experienced a difference between CF5 and CFMX in default display of date
database fields.
In CF5 a date database field would display as: 2002-05-01 00:00:00
In CFMX it shows up unformatted as: {ts '2002-05-01 00:00:00'}
I can take care of it by using the DateFormat function... however I was wondering if
there is something else I could do before I go tackle 300 plus cfm files???
FYI: Datetime database fields still display as in CF5: 2002-05-01 14:21:59 ; with the
appropriate time properly displayed. I'm using a postgreSQL backend.
Thanks to anyone who has some insight.
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF SQL Tool
And the .rar file throws errors when i use WinRar 2.80 on it. At 06:09 PM 7/8/02, you wrote: >Both of your CF SQL Tool links are for the .rar file :) > >-Original Message- >From: Clint Tredway [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, 9 July 2002 4:14 AM >To: CF-Talk >Subject: CF SQL Tool > > >I have updated my SQL tool and if you would like to help beta test it go >here. > >http://www.factorxsoftware.com/download/ > >I would appreciate any feedback. this is feature complete for version 1 and >I need help testing it for bugs. > >To use the tool, just unzip it on your server and you are good to go. It is >not encrypted because there is no point to encrypt it. It is also IE 5+ >only. > >Thanks, >Clint > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX editors...
I was at ebay last night... no cfStudio 5 for sale. Then I did amazon... then I did google. The amazon links you found ... like I found last night; the first is cfServer 5 the second... I don't have a homesite installation to upgrade the third... cfstudio5 is OUT OF STOCK Oh yeah, I get the idea all right. Now I just wish I could find a Trial Edition somewhere. wish me luck, Brian At 09:55 AM 7/6/02, you wrote: > I am sure that giving away the product (while still keeping a copy) is >against something in the license agreement. I'm sure the fact that the >product is no longer being sold does not invalidate the license agreement. > > My best advice is to keep an eye out on eBay and/or start calling places >to see if they still have some in stock. > >http://www.amazon.com/exec/obidos/ASIN/B5MIW5/qid=1025974341/sr=1-1/ref=sr_1_1/102-4497083-4807319 > >(If you have CF Studio or Dreamweaver already) > >http://www.amazon.com/exec/obidos/ASIN/B5U8W2/qid=1025974341/sr=1-5/ref=sr_1_5/102-4497083-4807319 > >(If you have Homesite) > >http://www.amazon.com/exec/obidos/ASIN/B5U2FZ/qid=1025974341/sr=1-7/ref=sr_1_7/102-4497083-4807319 > >(CF Studio stand alone) > > >You get the idea... > >http://www.amazon.com/exec/obidos/ASIN/B5U8W0/qid=1025974341/sr=1-4/ref=sr_1_4/102-4497083-4807319 > >(This one seems like a mis-marked version of CF Server) > > >At 09:49 AM 7/6/2002 -0700, you wrote: >>Let's hope not! >> >>If it's not for sale anywhere I don't really see the problem. >> >>At 09:36 AM 7/6/02, you wrote: >> >> does anyone want to share? >> > >> > >> >Share what...a jail cell? :) >> > >> > >> > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX editors...
Didn't they have a Trial download at one time? I never downloaded it. Perhaps someone has that available? At 09:36 AM 7/6/02, you wrote: >> does anyone want to share? > > >Share what...a jail cell? :) > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX editors...
Let's hope not! If it's not for sale anywhere I don't really see the problem. At 09:36 AM 7/6/02, you wrote: >> does anyone want to share? > > >Share what...a jail cell? :) > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX editors...
Well I was thinking Studio5 yesterday but I couldn't find it anywhere... Is it still available? If not does anyone want to share? At 05:59 AM 7/6/02, you wrote: >Studio 4.5.2 can be updated. These links were posted by Todd. > >-Craig > >CFMX Tag Updaters: >http://www.macromedia.com/software/coldfusionstudio/productinfo/resources/ta >g_updaters/ > >CFMX Help: >http://download.macromedia.com/pub/homesite/updates/cfml_ref.zip > >~Todd > >>>-Original Message- >>>From: Brian Scandale [mailto:[EMAIL PROTECTED]] >>>Sent: Saturday, July 06, 2002 12:44 AM >>>To: CF-Talk >>>Subject: CFMX editors... >>> >>> >>>Curious as to what everyone is using now... It might save me a >>>bunch of time. >>> >>>I've been using CFStudio 4.5.2 but now that I've loaded CFMX onto >>>the development server I was wanting to use the new charting tags >>>etc and an editor that supported the help for the new tags... >>> >>>thanks, >>>Brian >>> >>> >>> >>> > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMX editors...
Curious as to what everyone is using now... It might save me a bunch of time. I've been using CFStudio 4.5.2 but now that I've loaded CFMX onto the development server I was wanting to use the new charting tags etc and an editor that supported the help for the new tags... thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: coldfusionMX and postgresql
Thank you Dave, That was EXACTLY what I needed. and Thank you Jochem! It's guys like you who make this list rock! At 04:33 PM 7/5/02, you wrote: >> Having trouble getting coldfusion to access postgresql >> tables... >> >> Recall that in 5.0 I just needed to make an ODBC driver >> available... >> >> What are the steps to get it running in MX ? > >Jochem van Dieten was good enough to put this together: >http://jochem.vandieten.net/coldfusion/postgresql/ > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
coldfusionMX and postgresql
Having trouble getting coldfusion to access postgresql tables... Recall that in 5.0 I just needed to make an ODBC driver available... What are the steps to get it running in MX ? Thanks, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Unpacking JAR files...
Great, So the tag doesn't work properly and we're prohibited from fixing it. Kinda like you buying a car and being told... by law you are not permitted to tinker with the engine to make it perform better for your environment. Intellectual property is sort of an oxymoron. Stealing software is one thing. However fair use, like making personal copies of my CD is a right, established by the courts... which will eventually become applied to digital mediums as well. We just have to go around in circles for a few or more years until that becomes self evident. To quote a reader of Infoworld this week... How many people go around citing Milton when they say... "All hell broke loose". It's his. He authored it. We all use it. There, I feel better. At 10:37 AM 7/2/02, you wrote: >>Now my next task is to decompile them? > >FYI you might want to check the license, it probably prohibits decompiling. >And they may be obfuscated. > >_ >Pete Freitag ([EMAIL PROTECTED]) >CTO, CFDEV.COM >ColdFusion Developer Resources >http://www.cfdev.com/ > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Unpacking JAR files...
Yep, that worked. Thank you. Now my next task is to decompile them? At 09:12 AM 7/2/02, you wrote: >oi Brian!! > >you could just use winrar to open it up www.rarsoft.com > > >-- >Critz >Certified Adv. ColdFusion Developer > >Crit[s2k] - > >Tuesday, July 2, 2002, 12:05:28 PM, you wrote: > >BS> I am trying to unpack one of the jar files shipped with cf5 to see if it might be >possible to add some features to the cfgraph tag. > >BS> the jar command entered at the prompt seems to run and then hangs... with no cpu >cycles being consumed by jar according to the task manager. > >BS> Am I nuts or is it not possible to unpack some jar files? > >BS> thanks to any java gurus out there. >BS> Brian > >BS> > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Unpacking JAR files...
I am trying to unpack one of the jar files shipped with cf5 to see if it might be possible to add some features to the cfgraph tag. the jar command entered at the prompt seems to run and then hangs... with no cpu cycles being consumed by jar according to the task manager. Am I nuts or is it not possible to unpack some jar files? thanks to any java gurus out there. Brian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFGRAPH Replacement?
I'm searching for a replacement for cfgraph if anyone can point me... I need to display several data sets on one graph. VERY much appreciated. Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Javascript, form input colors and Netscape
Thanks Jon, That's a WAY cool link and it will be VERY useful in the future as I tune my CSS Style sheets... However, my question still remains... Using JAVASCRIPT to address form properties... how does one color an input window in Netscape? I'm hearing that it's not possible for Netscape 4.0 series browsers but it's not an authoritive statement that I've heard yet. My searches turn up nothing definitive. Anyone? Brian At 04:47 PM 6/26/02, you wrote: >http://www.mako4css.com/cssforms.htm > >----- Original Message - >From: "Brian Scandale" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, June 26, 2002 7:29 PM >Subject: Javascript, form input colors and Netscape > > >> Does anyone know how to use javascript to change the background color of >an form element with Netscape 4.0? >> >> I have been using statements like this for IE and Netscape 6.0+ >> -- >> frm.elements[itemNumber].style.background = "#00FF00"; >> -- >> >> but it does not work with Netscape 4.0 browsers... > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Javascript, form input colors and Netscape
Does anyone know how to use javascript to change the background color of an form element with Netscape 4.0? I have been using statements like this for IE and Netscape 6.0+ -- frm.elements[itemNumber].style.background = "#00FF00"; -- but it does not work with Netscape 4.0 browsers... Thanks to anyone who has experience in this. Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: String Manipulation troubles
Sorry All Stupid Operator Error: It works... I just can't read. That's what I get for 2am morning sessions. Brian At 09:05 AM 6/26/02, you wrote: >It works for me > >Ade > >-Original Message----- >From: Brian Scandale [mailto:[EMAIL PROTECTED]] >Sent: 26 June 2002 08:50 >To: CF-Talk >Subject: String Manipulation troubles > > >Why doesn't this statement catch the "]" character? > >Or a better question is How do i branch on that character... chr(93) doesn't >work either. > > >temp = #temp# > > >temp = #temp# Yep It Works! > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: String Manipulation troubles
Right... an email typo indeed ;-( At 09:01 AM 6/26/02, you wrote: >Just to make sure it was an email-only typo > >You did not close the cfset tag with a > > >Jerry Johnson > >>>> [EMAIL PROTECTED] 06/26/02 11:09AM >>> >First off,trim your var in the if statement and then change the "IS" to "eq". I have >had this problem before and by always trimming my vars and using eq instead of is, I >have had far less problems like this. > >HTH >Clint > >-- Original Message -- >from: Brian Scandale <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >date: Wed, 26 Jun 2002 00:49:35 -0700 > >Why doesn't this statement catch the "]" character? > >Or a better question is How do i branch on that character... chr(93) doesn't work >either. > > >temp = #temp# > > >temp = #temp# Yep It Works! > > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: String Manipulation troubles
Tried it Clint, see below... It does NOT test True for the Square Bracket. Does this have something to do with Regular Expressions? What's the proper way to test for the ] character? temp = #temp# temp = #temp# Yep It Works! At 08:09 AM 6/26/02, you wrote: >First off,trim your var in the if statement and then change the "IS" to "eq". I have >had this problem before and by always trimming my vars and using eq instead of is, I >have had far less problems like this. > >HTH >Clint > >-- Original Message ------ >from: Brian Scandale <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >date: Wed, 26 Jun 2002 00:49:35 -0700 > >Why doesn't this statement catch the "]" character? > >Or a better question is How do i branch on that character... chr(93) doesn't work >either. > > >temp = #temp# > > >temp = #temp# Yep It Works! > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
String Manipulation troubles
Why doesn't this statement catch the "]" character? Or a better question is How do i branch on that character... chr(93) doesn't work either. temp = #temp# temp = #temp# Yep It Works! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS / CF ReInstall Question...
Hi Dave, What all needs to be set? I'd look myself at what is currently set except that the machine is reporting 'Can't find path: when trying to Open the IIS Management Console That's why we're going to have IIS Reinstalled. At 12:12 PM 6/24/02, you wrote: >> If I reinstall IIS on a Win2k Server will I have to reinstall >> CF 5.0 as well? > >No, but if you don't, you'll have to manually configure IIS to send CFML >files to the CF server. This is pretty easy to do, though - just look in >your IIS management console, right-click on either the machine name (to >configure all virtual servers) or an individual virtual server, select >"Properties", go to the "Home Directory" tab, click the "Configuration" >button, and add the appropriate file extension mappings to >\CFUSION\bin\ISCF.DLL, which is the ISAPI extension for CF 5. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS / CF ReInstall Question...
Thanks Dave!!! Really appreciate this information. Brian At 12:12 PM 6/24/02, Dave Watts wrote: >> If I reinstall IIS on a Win2k Server will I have to reinstall >> CF 5.0 as well? > >No, but if you don't, you'll have to manually configure IIS to send CFML >files to the CF server. This is pretty easy to do, though - just look in >your IIS management console, right-click on either the machine name (to >configure all virtual servers) or an individual virtual server, select >"Properties", go to the "Home Directory" tab, click the "Configuration" >button, and add the appropriate file extension mappings to >\CFUSION\bin\ISCF.DLL, which is the ISAPI extension for CF 5. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IIS / CF ReInstall Question...
If I reinstall IIS on a Win2k Server will I have to reinstall CF 5.0 as well? Thanks. At 11:03 AM 6/24/02, you wrote: >The only way might be through the Jrun OEM program...Where they sell >licenses to include the Jrun app server as part of your product...I'm >assuming they may or possibly already have a licensing plan for a CFMX >approach. Not sure though... > >As far as stand alone compiled applications...don't believe that's possible >just yet...at least nothing straight forward that I know of.. > >Stace > >-Original Message- >From: Josh Trefethen [mailto:[EMAIL PROTECTED]] >Sent: Monday, June 24, 2002 1:42 PM >To: CF-Talk >Subject: protecting source code with MX > >Hello all! > >I have heard mention of a better way to protect source code with MX (better >than the encode capabilities of previous CF versions). > >Has anyone heard anything about this or have any experience with this? > >I have an application which I sell to large corporations. The software, >along with CFServer is installed on the customer premises, and I do not wish >for the code to be decrypted and changed or copied. > >Since MX is Java Based, are there any new ways to compile or encrypt our >code so it is safe? > >Any other ideas would be great! > > > >Thanks, > >Josh Trefethen >Certified ColdFusion Developer >President, exciteworks, Inc. >http://exciteworks.com > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DNS Havoc!!
I'm getting your new ip address when I ping. You are probably just getting the results of cached DNS entries... it should clear up in a couple of hours. P.S. about half of the pings are timing out. At 02:29 PM 6/13/02 -0500, you wrote: >I'm getting the nw IP from both 207.x.x.x and 68.x.x.x > >-mk > >-Original Message- >From: Phoeun Pha [mailto:[EMAIL PROTECTED]] >Sent: Thursday, June 13, 2002 1:47 PM >To: CF-Talk >Subject: SOT: DNS Havoc!! > > >Hey guys i just switched to a new host for the website www.entelligence.com > >But for some reason it still pings to the old host IP address >Can you guys Ping the site and tell me (directly to my email) what address >you get? > >The new host IP is 66.28.113.146 >The old host IP is 209.113.73.92 > >The wierd thing is the other coputers in my office are pointing to the new >site! I have set up my DNS information correctly too, but it's still >pointing to the old site. ahhh!!! > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ridiculous Problem!
I think this is because you are missing this file :\Inetpub\wwwroot\Main\ide.cfm I belive I read that somewhere recently. At 04:25 PM 6/5/02 -0400, you wrote: >Bud, > >What is '/' mapped too? Also, are you hosting multiple sites on the >webserver? Which one is CFIDE physically located in? When CFMX was >installed, did you choose Standalone or...? > >~Todd > >At 01:20 PM 6/5/2002 -0700, you wrote: >>Well.. if this is the case for this person, I don't know. But you will have >>this problem if the CFIDE directory is not located in the root of the site, >>which is also set in the CF admin under mappings not sure how it does in MX. >>I have not messed with it yet. >> >>Shawn Regan >> >>-Original Message- >>From: Shawn Regan [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, June 05, 2002 1:14 PM >>To: CF-Talk >>Subject: RE: Ridiculous Problem! >> >> >>It sounds like you still don't have your CFIDE mapping correct. >> >> >>Shawn Regan >> >>-Original Message- >>From: UXB Internet [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, June 05, 2002 1:03 PM >>To: CF-Talk >>Subject: RE: Ridiculous Problem! >> >> >>And people ask me why I don't rush to upgrade all the time. Let me know >>what you find Bud, I have the same configuration (I think my dev box even >>has the same internal IP number ) >> >> >>Best regards, >> >>Dennis Powers >>UXB Internet - A Web Design and Hosting Company >>tel: (203)879-2844 fax: (203)879-6254 >>http://www.uxbinternet.com/ >>http://dennis.uxb.net/ >> >> >>-Original Message- >>From: Bud [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, June 05, 2002 7:13 AM >>To: CF-Talk >>Subject: Ridiculous Problem! >> >>OK. I've got CF 4.51 on my development box. I also run WebSite Pro on >>the dev box, which I just upgraded to the latest version, which I'd >>also done on the real server with no problem. >> >>I can access the CF Login page thru >>http://192.168.0.5/CFIDE/administrator/index.cfm >> >>But when I try to log in I get >> >>/CFIDE/administrator/index.cfm not found >> >>The mappings are correct. I can make a link to >>href="/CFIDE/administrator/index.cfm" >>from anywhere in WWWRoot and it loads fine. >> >>I've even gone so far as to create a new mapping to WWWRoot\CFIDE\ >>and also saved the login page source code and used a complete URL to >>form action="http://192.168.0.5/CFIDE/administrator/index.cfm";. >> >>127.0.0.1 acts the same way if I try to access it straight from the dev box. >>Cookies are enabled. >>It does this from any computer hooked to the dev box. >> >>Does anyone have any clue at all what can be happening here? It's >>like eeevery day I get up ready to work and it's something. Like >>a Gremlin conspiracy to stop me from making money. >>-- >> >>Bud Schneehagen - Tropical Web Creations >> >>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >>ColdFusion Solutions / eCommerce Development >>[EMAIL PROTECTED] >>http://www.twcreations.com/ >>954.721.3452 >> >> >> >> > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does posting to cf-talk via the fuseware.com newsgroup actually makeit out to the list members?
if that is where you mailed this from then YES, it made it to me. At 11:07 PM 6/3/02 -0400, you wrote: >On Mon, 03 Jun 2002 17:26:25 -0400, in cf-talk you wrote: > >>Anyone? >> >>TIA >>Geo > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
A table design puzzle
I have a table relationship puzzle to solve... thought I might run it by the list before I commit to tables and code... A factory builds integrated circuits on silicon wafers, 25 wafers to a lot. Each Lot has a unique ID. The 25 wafers each have a unique serialized ID. The wafers can transfer between lots. Eventually the wafers are cut up into 50 individual circuits each with their unique ID(think Pentiums). The heritage of each circuit can be traced to the wafer and the wafer can be traced to all the Lots it was ever a part of. It is possible that each circuit could be further split into several sub circuits. This is at least three levels now... LotID -WaferID -CircuitID -SubCircuitID If I make it typical relationship table structure there would be a table for each level with children related to the parent... SubCircuit relates to -Circuit relates to -Wafer I was thinking to make it generic so that we could have any ole number of levels of part division... SerialTable -serialtable_ID -serial_number -parent_serialtable_ID - sort of a self referencing table structure... Anyone ever build anything like this before? Anyone Care to point out any gotchas you are aware of before I begin? Thanks again! ~Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug ... style sheet bug ... looking for workaround
Yes I have checked but perhaps I don't know how to search their knowledge base...
none of my searches has turned up anything of value...
At 01:50 AM 6/3/02 -0500, you wrote:
>Have you checked MS site for a possible fix?
>
>Steven Lancaster
>Barrios Technology
>NASA/JSC
>281-244-2444 (voice)
>[EMAIL PROTECTED]
>
>
>
>-----Original Message-
>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>Sent: Monday, June 03, 2002 1:48 AM
>To: CF-Talk
>Subject: RE: IE 6.0 Bug ... style sheet bug ... looking for workaround
To: [EMAIL PROTECTED] Subject: IE 6.0 Bug ... style sheet bug ... looking for
workaround
I just installed a large project on a site that is used exclusively with IE 6.0 and
suddenly some very simple text is not displaying inside forms.
So I hit it with IE 5.5 and all is OK.
I am having trouble with Free Form text that floats above Select Boxes not displaying
unless I drag the scroll bar to force IE to repaint the screen... the text is there,
but not displayed until the scroll bar drag forces IE to repaint the section as it
comes into view a second time... THIS ONLY happens above the FIRST Select Box on the
page.
I jerked the .css file and put 1 style sheet tag into the header section to
demonstrate the problem. Removing the 'background: 66' from the style sheet solves
the problem at the expense of the entire site design.
Pulled most of my hair out by now.
You can reproduce this BUG with this simple html code below... if you are running IE
6.0
Any Ideas?? what a workaround might be??
Once again, thanks for Looking at this.
~Brian
--
--
<!--
FORM { font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size : 11px;
background : 66;
border : thin outset }
-->
ADDING ITEM DETAIL - CHOOSE A PART TYPE
Select Part Type
BACKLIGHT
MILLENIA
TETRUS
TSUNAMI
Select Part
THE FIRST PART NUMBER A THE FIRST PART NAME
TSV C TSUNAMI-VITEX
--
here it is again
--
Perhaps this Exclaimed one (!) one is a readable copy if the first one formats and
displays as a web document in your Email reader.
ADDING ITEM DETAIL - CHOOSE A PART TYPE
Select Part Type
BACKLIGHT
MILLENIA
TETRUS
TSUNAMI
Select Part
THE FIRST PART NUMBER A THE FIRST PART NAME
TSV C TSUNAMI-VITEX
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug ... style sheet bug ... looking for workaround
Tried that... and a zillion other things too. ;-(
Are you running IE 6.0 and see the problem??
At 11:09 PM 6/2/02 -0700, you wrote:
>Brian,
>
>Try adding a pound sign before the rgb color value.
>
>background: #66;
>
>Robert
>
>> -Original Message-
>> From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>> Sent: Sunday, June 02, 2002 12:28 PM
>> To: CF-Talk
>> Subject: IE 6.0 Bug ... style sheet bug ... looking for workaround
>>
>>
>> I just installed a large project on a site that is used
>> exclusively with IE 6.0 and suddenly some very simple text is not
>> displaying inside forms.
>>
>> So I hit it with IE 5.5 and all is OK.
>>
>> I am having trouble with Free Form text that floats above Select
>> Boxes not displaying unless I drag the scroll bar to force IE to
>> repaint the screen... the text is there, but not displayed until
>> the scroll bar drag forces IE to repaint the section as it comes
>> into view a second time... THIS ONLY happens above the FIRST
>> Select Box on the page.
>> I jerked the .css file and put 1 style sheet tag into the header
>> section to demonstrate the problem. Removing the 'background:
>> 66' from the style sheet solves the problem at the expense of
>> the entire site design.
>>
>> Pulled most of my hair out by now.
>>
>> You can reproduce this BUG with this simple html code below... if
>> you are running IE 6.0
>>
>> Any Ideas?? what a workaround might be??
>>
>> Once again, thanks for Looking at this.
>> ~Brian
>> --
>> --
>>
>>
>>
>> <!--
>> FORM { font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
>> font-size : 11px;
>> background : 66;
>> border : thin outset }
>> -->
>>
>>
>>
>>
>>
>>
>>
>>
>> ADDING ITEM DETAIL - CHOOSE A PART TYPE
>>
>> Select Part Type
>> > onclick="this.form.submit()">
>> BACKLIGHT
>> MILLENIA
>> TETRUS
>> TSUNAMI
>>
>>
>>
>>
>>
>>
>>
>>
>> Select Part
>> > onclick="this.form.submit()">
>> THE FIRST PART NUMBER A THE
>> FIRST PART NAME
>> TSV C TSUNAMI-VITEX
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> here it is again
>> --
>>
>> Perhaps this Exclaimed one (!) one is a readable copy if the
>> first one formats and displays as a web document in your Email reader.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ADDING ITEM DETAIL - CHOOSE A PART TYPE
>>
>> Select Part Type
>> > onclick="this.form.submit()">
>> BACKLIGHT
>> MILLENIA
>> TETRUS
>> TSUNAMI
>>
>>
>>
>>
>>
>>
>>
>>
>> Select Part
>> > onclick="this.form.submit()">
>> THE FIRST PART NUMBER A THE
>> FIRST PART NAME
>> TSV C TSUNAMI-VITEX
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IE 6.0 Bug ... style sheet bug ... looking for workaround
I just installed a large project on a site that is used exclusively with IE 6.0 and suddenly some very simple text is not displaying inside forms. So I hit it with IE 5.5 and all is OK. I am having trouble with Free Form text that floats above Select Boxes not displaying unless I drag the scroll bar to force IE to repaint the screen... the text is there, but not displayed until the scroll bar drag forces IE to repaint the section as it comes into view a second time... THIS ONLY happens above the FIRST Select Box on the page. I jerked the .css file and put 1 style sheet tag into the header section to demonstrate the problem. Removing the 'background: 66' from the style sheet solves the problem at the expense of the entire site design. Pulled most of my hair out by now. You can reproduce this BUG with this simple html code below... if you are running IE 6.0 Any Ideas?? what a workaround might be?? Once again, thanks for Looking at this. ~Brian -- -- ADDING ITEM DETAIL - CHOOSE A PART TYPE Select Part Type BACKLIGHT MILLENIA TETRUS TSUNAMI Select Part THE FIRST PART NUMBER A THE FIRST PART NAME TSV C TSUNAMI-VITEX -- here it is again -- Perhaps this Exclaimed one (!) one is a readable copy if the first one formats and displays as a web document in your Email reader. ADDING ITEM DETAIL - CHOOSE A PART TYPE Select Part Type BACKLIGHT MILLENIA TETRUS TSUNAMI Select Part THE FIRST PART NUMBER A THE FIRST PART NAME TSV C TSUNAMI-VITEX __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug??
>
>Forms are green Tables inside forms have rows that are yellow... this sets off
>two different forms inside one page nicely...
I will give your ideas some thought and see how I might use them again... this is
only a problem with IE 6.0
and the two files I created demonstrate the error if running 6.0
thanks for working this with me.
Brian
>Thought I would chime in on this...
>
>The form element doesn't seem to like css properties that much so I would
>suggest defining a css class and using it on a table that wraps around the
>form. Define it by naming something with a period in front of the name, then
>use the "class=" within the appropriate table tag. I would also separate out
>the input box definitions if you have font-specific stuff. Something like
>this:
>
>form-color {
>background-color : #66;
>}
>
>input {
>font-family : Arial, Helvetica, sans-serif;
>font-size : 16px;
>}
>
>-
>
>
>
>
>
>
>
>
>Hope that helps!
>
>
>Ryan Kime
>
>-Original Message-
>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, May 30, 2002 9:00 PM
>To: CF-Talk
>Subject: IE 6.0 Bug??
>
>
>Just installed on a site that is exclusively IE 6.0 and suddenly some very
>simple text is not displaying...
>
>So I hit it with IE 5.5 and all is OK.
>
>Next I pulled the View/Source output apart and everything looks OK.
>
>Discovered that if I pull the background statement,(SeeBelow) out of the
>css file then it displays properly... but that's a bummer because that
>ruins the esthetics of the page.
>
>Is there something wrong with my .css statement that anyone can tell?
>
>FORM { font-size : 11px;
>background : #66; <---theBadActor
>border : thin outset;
>}
>
>Thanks for Looking at this.
>
>~Brian
>
>
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Upper Function Replacement?
What replaces the SQL UPPER() function ins SQL Server? It's used to return the upper case of it's argument... It's complaining that "Argument data type text is invalid for argument 1 of upper function" thanks again! ~Brian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IE 6.0 Bug??
I have the problem reduced to a simple .html file and a .css style sheet that goes
with it if someone want to take a crack at it... :-)
At 08:14 PM 5/30/02 -0700, you wrote:
>Changing to "...-color:" in the FORM .css file statement effects no-change. it
>still renders the color and causes the text to not display... unless I drag the
>scroll bar causing the browser to re-paint the scrolled area of the page. Then the
>text becomes visible.
>
>
>I don't want the entire page background to be #66 in color so I have not used
>that approach..
>
>It's maddening at the moment! Pulling the color statement out leaves the Form
>white...
>
>
>At 10:01 PM 5/30/02 -0400, you wrote:
>>2 suggestions
>>1 - move it into the body tag
>>body {
>>background-color: #66;
>>}
>>
>>2 - background-color: #66;
>>
>>one of those should do it - I recommend #1
>>jay miller
>>
>>Brian Scandale wrote:
>>
>>> Just installed on a site that is exclusively IE 6.0 and suddenly some very simple
>text is not displaying...
>>>
>>> So I hit it with IE 5.5 and all is OK.
>>>
>>> Next I pulled the View/Source output apart and everything looks OK.
>>>
>>> Discovered that if I pull the background statement,(SeeBelow) out of the .css file
>then it displays properly... but that's a bummer because that ruins the esthetics of
>the page.
>>>
>>> Is there something wrong with my .css statement that anyone can tell?
>>>
>>> FORM { font-size : 11px;
>>> background : #66; <---theBadActor
>>> border : thin outset;
>>> }
>>>
>>> Thanks for Looking at this.
>>>
>>> ~Brian
>>>
>>>
>>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IE 6.0 Bug??
Changing to "...-color:" in the FORM .css file statement effects no-change. it
still renders the color and causes the text to not display... unless I drag the scroll
bar causing the browser to re-paint the scrolled area of the page. Then the text
becomes visible.
I don't want the entire page background to be #66 in color so I have not used
that approach..
It's maddening at the moment! Pulling the color statement out leaves the Form
white...
At 10:01 PM 5/30/02 -0400, you wrote:
>2 suggestions
>1 - move it into the body tag
>body {
>background-color: #66;
>}
>
>2 - background-color: #66;
>
>one of those should do it - I recommend #1
>jay miller
>
>Brian Scandale wrote:
>
>> Just installed on a site that is exclusively IE 6.0 and suddenly some very simple
>text is not displaying...
>>
>> So I hit it with IE 5.5 and all is OK.
>>
>> Next I pulled the View/Source output apart and everything looks OK.
>>
>> Discovered that if I pull the background statement,(SeeBelow) out of the .css file
>then it displays properly... but that's a bummer because that ruins the esthetics of
>the page.
>>
>> Is there something wrong with my .css statement that anyone can tell?
>>
>> FORM { font-size : 11px;
>> background : #66; <---theBadActor
>> border : thin outset;
>> }
>>
>> Thanks for Looking at this.
>>
>> ~Brian
>>
>>
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IE 6.0 Bug??
Just installed on a site that is exclusively IE 6.0 and suddenly some very simple text
is not displaying...
So I hit it with IE 5.5 and all is OK.
Next I pulled the View/Source output apart and everything looks OK.
Discovered that if I pull the background statement,(SeeBelow) out of the .css file
then it displays properly... but that's a bummer because that ruins the esthetics of
the page.
Is there something wrong with my .css statement that anyone can tell?
FORM { font-size : 11px;
background : #66; <---theBadActor
border : thin outset;
}
Thanks for Looking at this.
~Brian
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
inhibit form password cacheing
How does one inhibit the password caching request that browsers make when users enter their passwords into forms? I thought there was a meta tag but I can't find it. doesn't work... it only prevents caching the page... Any directions would be appreciated. Thanks ~Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server Restarts
This seems like the most likely explanation at this time... The logs look just fine... very few errors and days apart. Mostly just my restarts from time to time... running on a Linux box. thanks Cameron ~Brian At 01:01 PM 5/26/02 -0400, you wrote: >Is this on a development server where you are constantly changing the code? >I've had a similar experience with CF development environments where they >slow down over time as you are editing the pages. I haven't seen that >behavior in production, but I have in development. I suspect it has to do >with CF's internal pcode cache becoming fragmented over time as it's >changed, but knowing nothing about CF's internal pcode and memory >management, I could be totally wrong. > >I always keep a bat file on the development server's desktop for restarting >the server. Makes it very easy to restart the server quickly when you need >to. > >-- >@ECHO ON > >net stop "Cold Fusion Application Server" >net start "Cold Fusion Application Server" > >@ECHO OFF >PAUSE >-- > >Hope that helps! > >-Cameron > >- >Cameron Childress >Sumo Consulting Inc. >--- >cell: 678-637-5072 >aim: cameroncf >email: [EMAIL PROTECTED] > > >> -Original Message- >> From: Brian Scandale [mailto:[EMAIL PROTECTED]] >> Sent: Saturday, May 25, 2002 6:03 PM >> To: CF-Talk >> Subject: Server Restarts >> >> >> Over the last several days I notice that the Server is taking >> longer and longer to post the pages I am developing. >> >> After a ReStart everything is snappy again!! >> >> For example... Multiple ReLoad's of the page shows 4000 >> +/- 200 milliseconds. After ReStart it now is showing 1500 +/- >> 200 milliseconds. >> >> I am looking for advice on how to chase down this problem. >> >> Thanks to the Gurus, >> >> Brian >> >> > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Server Restarts
Over the last several days I notice that the Server is taking longer and longer to post the pages I am developing. After a ReStart everything is snappy again!! For example... Multiple ReLoad's of the page shows 4000 +/- 200 milliseconds. After ReStart it now is showing 1500 +/- 200 milliseconds. I am looking for advice on how to chase down this problem. Thanks to the Gurus, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CSS trouble
I'm using a .css file to manage the look of a site. The site allows for some user configurable content via soEditor that I then display in a cell in a table. That content inherits the .css file setting and ignores much of the users designs. I'm wondering how I leave the .css settings off this particular cell in a table. Off to try a few more ideas. ~Brian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: False "template file ... encrypted and its data has been corrupte d" error
Send me one of the files and I'll try it on my Linux CF installation... send one that would run. At 12:20 PM 5/17/02 -0400, you wrote: >I got the error below. > >I wrote my file in DW4, edited it in CF Studio 4, saved and tested it on an >IIS server. When I uploaded it to an HP/UX box running apache I got the >error below. I opened up VI, edited the file, everything looks normal, >completely normal, and even saved the file. I went through the upload, >test, check, test, edit, test scenario twice with the same file, a couple >different times with other files. At all times, I get the error below. > >The files are not encrypted nor are they corrupted. > >I believe there was a problem with the installation, but I can't figure out >what that problem was. I do not have much UNIX experience, but I've been >working with CF on windows since 1996. Has anyone run across this error >before? Someone has to have seen this before... > >Thanks, > >Don > > > > Error Diagnostic Information > > Cannot load template file //newtest3.cfm > > The template file exists, however, it either cannot be opened for reading, >or it is encrypted and its data has been corrupted > > Date/Time: Fri May 17 09:08:17 2002 > Browser: Mozilla/4.79 [en] (Windows NT 5.0; U) > Remote Address: 0.0.0.0 > HTTP Referer: [unknown origin] > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: server crashing... Caught a fatal signal - More Info
Deduced that it only happens when the SQL error is in a table in the same PostgreSQL database as the Client Variable Store. When I switch to another PostgreSQL database or use the Registry(Linux), I get normal CF-SQL errors. too weird At 10:51 PM 5/16/02 -0700, you wrote: >Still happening... the server.log file shows: >-- >"Fatal","9225","05/16/02","22:42:12",,"Caught a fatal signal (11) - Aborting" >"Information","1024","05/16/02","22:42:16",,"The ColdFusion Application Server >started." >-- > >any ideas where to look? > >At 12:54 PM 5/11/02 +0100, you wrote: >>Brian, >> >>A long shot, but have you checked your disk space? Check logs too >> >>Dave >> >>-Original Message- >>From: Brian Scandale [mailto:[EMAIL PROTECTED]] >>Sent: 11 May 2002 04:52 >>To: CF-Talk >>Subject: server crashing... >> >> >>Server keeps crashing suddenly... Because a Simple SELECT Statement with a >>bad spelling for a column. >> >>Usually I get a error message telling me attribute (bad spelling variable) >>does not exist. >> >>But suddenly the last few hours... the CF server is crashing... see error >>below... I just rebooted the Computer yet... the error persists... I'm >>baffled. >> >>I turned off > >>thanks for any ideas. >>Brian >> >>-- Error Msg in IE5.5 - >>Error Occurred While Processing Request >>Error Diagnostic Information An error occurred while attempting to establish >>a connection to the server. The most likely cause of this problem is that >>the server is not currently running. Verify that the server is running and >>restart it if necessary. Unix error number 2 occurred: No such file or >>directory >> >> >> > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: server crashing... Caught a fatal signal (11) - Aborting
Still happening... the server.log file shows: -- "Fatal","9225","05/16/02","22:42:12",,"Caught a fatal signal (11) - Aborting" "Information","1024","05/16/02","22:42:16",,"The ColdFusion Application Server started." -- any ideas where to look? At 12:54 PM 5/11/02 +0100, you wrote: >Brian, > >A long shot, but have you checked your disk space? Check logs too > >Dave > >-Original Message- >From: Brian Scandale [mailto:[EMAIL PROTECTED]] >Sent: 11 May 2002 04:52 >To: CF-Talk >Subject: server crashing... > > >Server keeps crashing suddenly... Because a Simple SELECT Statement with a >bad spelling for a column. > >Usually I get a error message telling me attribute (bad spelling variable) >does not exist. > >But suddenly the last few hours... the CF server is crashing... see error >below... I just rebooted the Computer yet... the error persists... I'm >baffled. > >I turned off >thanks for any ideas. >Brian > >-- Error Msg in IE5.5 - >Error Occurred While Processing Request >Error Diagnostic Information An error occurred while attempting to establish >a connection to the server. The most likely cause of this problem is that >the server is not currently running. Verify that the server is running and >restart it if necessary. Unix error number 2 occurred: No such file or >directory > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Inserting into 2 tables with a relationship
I suggest using the custom tag... Max_ID from the Macromedia Custom Tag library. It is well documented. Then search the archives for discussions on use of the tag. I use this exclusively now and avoid AutoIncrementing primary key fields like the plague. hth Brian At 10:49 AM 5/16/02 -0500, you wrote: >I have a database with 2 tables one has a relationship with the other and >when I do an insert I need to insert into table 1 and insert into table 2 >with an var_id field that has not been generated until table 1 has been >inserted into.. I am not sure what to do or how to do it.. I am using CF 5 >and Access.. > >Steven Lancaster >Barrios Technology >NASA/JSC >281-244-2444 (voice) >[EMAIL PROTECTED] > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: check for mixed case plus a numeric
Perfect... thank you.
At 01:37 PM 5/13/02 +0200, you wrote:
>bOK = Refind("[A-Z]",pass) AND ReFind("[a-z]",pass) AND
>ReFind("[0-9]",pass)
>
>-Original Message-
>From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
>Sent: maandag 13 mei 2002 13:13
>To: CF-Talk
>Subject: Re: check for mixed case plus a numeric
>
>
>Brian Scandale wrote:
>
>>Trying to check for mixed case, and at least one digit in a prospective
>
>>password.
>>
>>Any ... snippets that might help me get started??
>>
>>Thanks,
>>Brian
>>
>>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
server crashing...
Server keeps crashing suddenly... Because a Simple SELECT Statement with a bad spelling for a column. Usually I get a error message telling me attribute (bad spelling variable) does not exist. But suddenly the last few hours... the CF server is crashing... see error below... I just rebooted the Computer yet... the error persists... I'm baffled. I turned off http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
check for mixed case plus a numeric
Trying to check for mixed case, and at least one digit in a prospective password. Any ... snippets that might help me get started?? Thanks, Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session cookies to expire immediately on browser close
This is what I use I picked it up off I don't actually remember where but it works great. - this is what I use --- At 02:04 PM 5/10/02 +0800, you wrote: > hihi.. where am i suppose to put this.. if i want to set cookie to expire when >browser close.?? > > > >is it at application.cfm? > > >cheers >han > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF MailServer On-Line Check?
Howie,
You Rock! Thanks!
I was just getting ready to decrypt the admin modules to try and find it... Now I
don't have to.
Once again, Thanks!
At 09:22 PM 5/9/02 -0400, you wrote:
>It's an undocumented function:
>
>cfusion_verifymail(server,port,timeout)
>
>If it connects properly, the result is an empty string. If it cannot connect it is:
>"Unable to connect to mail server."
>
>Example:
>
>cfusion_verifymail("mail.domain.com",25,10)
>
>HTH,
>
>--
>Howie Hamlin - inFusion Project Manager
>On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101
>inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
>>>> Find out how iMS Stacks up to the competition:
>http://www.coolfusion.com/imssecomparison.cfm
>
>- Original Message -
>From: "Brian Scandale" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, May 09, 2002 6:51 PM
>Subject: CF MailServer On-Line Check?
>
>
>> I seem to recall there was a way to get CF to check if a mailserver is up and
>responding... but searching the forums I can't seem
>to find anything.
>>
>> Would someone please direct me?
>>
>> thanks,
>> Brian
>>
>>
>
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF MailServer On-Line Check?
I seem to recall there was a way to get CF to check if a mailserver is up and responding... but searching the forums I can't seem to find anything. Would someone please direct me? thanks, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:
Justin, Matt, Ok, I get it now... Thanks for the heads up. At 12:08 AM 5/5/02 -0400, you wrote: >> There really is no reason to ever have a comparison in a tag as >> you can't do logic with it or assign the result to a value. Most likely >> the programmer made a mistake and since CF never threw an error, he or >> she didn't notice. > >Actually, you can use operators to set a variable to a boolean value if you >want to... > > > >.and then use that variable as a boolean during logic operations... > > > > > >Why would someone want to do this? Not sure.. I've never had a use for it >personally, but the functionality is there if you need it. Simply saying > will have the expression be evaluated to true, but the result >will simply be tossed out, as was happening to the original poster. > >-Justin Scott, Lead Developer > Sceiron Internet Services, Inc. > http://www.sceiron.com > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:
that was me... took me forever to catch the error... i kept looking at the code... damn... There really is no reason to ever have a comparison in a tag as >you can't do logic with it or assign the result to a value. Most likely >the programmer made a mistake and since CF never threw an error, he or >she didn't notice. > >-Matt > >> -----Original Message- >> From: Brian Scandale [mailto:[EMAIL PROTECTED]] >> Sent: Saturday, May 04, 2002 7:05 PM >> To: CF-Talk >> Subject: RE: >> >> Thanks for the info Matt can you give me an example of how one >would >> use the second expression in my mind it just seems that it would >be >> used to set SomeVar... what??? true or false? >> >> Is that what it was doing? >> >> >> >> >> >> At 05:01 PM 5/4/02 -0700, you wrote: >> >Any valid expression can be inside of a tag. Comparing two >> >variables is a valid expression. >> > >> >-Matt >> > >> >> -Original Message- >> >> From: Brian Scandale [mailto:[EMAIL PROTECTED]] >> >> Sent: Saturday, May 04, 2002 4:40 PM >> >> To: CF-Talk >> >> Subject: >> >> >> >> What's the Difference between these two? >> >> >> >> >> >> >> >> vs >> >> >> >> >> >> >> >> >> >> I've been chasing a bug using the latter expression for 10 hours... >> >until >> >> I noticed the improper use of EQ. No compile error was generated >these >> >> last 10 hours making me think that perhaps there is a purpose to >the >> >> latter expression. >> >> >> >> >> >> >> >> >> > >> > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:
Thanks for the info Matt can you give me an example of how one would use the second expression in my mind it just seems that it would be used to set SomeVar... what??? true or false? Is that what it was doing? At 05:01 PM 5/4/02 -0700, you wrote: >Any valid expression can be inside of a tag. Comparing two >variables is a valid expression. > >-Matt > >> -Original Message- >> From: Brian Scandale [mailto:[EMAIL PROTECTED]] >> Sent: Saturday, May 04, 2002 4:40 PM >> To: CF-Talk >> Subject: >> >> What's the Difference between these two? >> >> >> >> vs >> >> >> >> >> I've been chasing a bug using the latter expression for 10 hours... >until >> I noticed the improper use of EQ. No compile error was generated these >> last 10 hours making me think that perhaps there is a purpose to the >> latter expression. >> >> >> >> > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf-talk@houseoffusion.com
Whats up with this ? Seems like the comparison is allowing any 'ole case to cause the asod = #asod# Attributes.password = #Attributes.password# GoodLogin = #GoodLogin# - --- output is cut and pasted here--- - asod = aa Attributes.password = aaaAAA GoodLogin = YES __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf-talk@houseoffusion.com
What's the Difference between these two? vs I've been chasing a bug using the latter expression for 10 hours... until I noticed the improper use of EQ. No compile error was generated these last 10 hours making me think that perhaps there is a purpose to the latter expression. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cache size
open a terminal window... dos box... whatever you call it now... type cd \ to get to the root... type dir *.cf /s the last line output will be a summation of the size of all *.cfm files. Repeat for each drive in your system that you want a summary for. At 05:39 PM 5/2/02 -0700, you wrote: >I was wondering if anyone knows of a fast way to determine the total >file size of all .cfm templates in your server? I need to adjust my >cache size and going thru directory by directory would take forever. > > > > >Douglas Brown >Email: [EMAIL PROTECTED] > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF_HierMenus
I've been trying to use this tag for a few days now and can't seem to figure out how to populate it from a database. ...ANY in the middle of the tag seems to blow it up. Anyone using this tag successfully??? Throw me a bone ;-) Thanks guys, Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFGraph precision problem
Off the top of my head... perhaps it's the use of quotes that's the key??? At 12:42 PM 4/18/02 -0700, you wrote: >I am using the following code to display a graph data item. I am using >numberformat function, but the graph ignores it. > "__._")#> >Anyone know how I can set the precision to one decimal place? >Thanks, >Ray > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL insanity...
Why not do a join... something like this I expect...
>
>SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
>tally
sermons.title etc, speakers.initials
>FROM sermons_details
JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num
JOIN speakers ON sermons.speaker = speaker.full_name
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them. Works like a
At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there :)
>
>Here's the deal: we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days. Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number. This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them. Works like a
>champ. The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name, speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out. Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too. Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL server and Interval data type
Ahh yes Jochem... so true, However my puzzle still remains... what/how is that handled
in SQL Server... I did notice that one source says to import interval data into SQL
server set up a char field
Now I'm wondering how that would work inside CF... trying to process it that is...
At 09:12 PM 4/16/02 +0200, you wrote:
>Mark A. Kruger - CFG wrote:
>> Ok - explain the interval data type. what is it and what does it contain?
>
>Interval data type contains an interval (copy/paste from manual):
>Type interval [ (precision) ]
>Description for time intervals
>Storage 12 bytes
>Earliest -17800 years
>Latest17800 years
>Resolution1 microsecond
>
>Usage:
>Quantity Unit [Quantity Unit...] [Direction]
>Quantity: number
>Unit: second, minute, hour, day, week, month, year, decade,
>century, millennium, or abbreviations or plurals of these units;
>Direction:empty or "Ago"
>
>Examples:
>'1 12:59:10'
>'1 day 12 hours 59 min 10 sec'
>'1 day 10 sec'
>'16 centuries 1 sec'
>SELECT datefield + 5 * intervalfield - Cast('1 sec' AS INTERVAL) AS duedate
>etc.
>
>PostgreSQL Date/Time handling is cool and compliant :-)
>
>Jochem
>
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL server and Interval data type
I have built an application using PostgreSQL and it's interval data type to hold things like the time between two events etc (as you might expect) I am now required to deploy that app on SQL server too... and I just discovered they have no interval data type... or at least it looks that way to me... (no sql server gurus available where I am). Not sure how I am going to handle this yet... So I am looking for any sort of sage advise that you all might have for me at this point. thanks in advance, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Preventing SQL injection attacks...?
There is a custom tag... on the developers exchange that I've been using... It searches the caller.form.fieldnames structure looking for all sorts of nasty includes. After just reading it again I think I can also make it filter url submitted input as well. Anyone here use or have comments on this tags limitations? Was an easy first step for me but I am suddenly worried about url hacks as well. Brian At 08:17 AM 4/12/02 -0700, you wrote: >Hi all, > >Had some interesting errors in our logs yesterday. It appears that someone's >trying to hack our database by inserting SQL query language into the URL >string. > >We're doing all the standard security measures, including filtering for >single quotes, using database passwords, and the like, and we locked out >their IP immediately. But really, how do you prevent this? Any >ideas/feedback out there? > >Ian > >Portent Interactive >Helping clients build customer relationships on the web since 1995 >Consulting, design, development, measurement >http://www.portentinteractive.com > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server Install and CF
Tony, You say Don't install books on-line on the server... ahhh... I should install somewhere else then? Because you find most of your answers there? thanks, Brian At 04:43 PM 4/10/02 -0400, you wrote: >actually you have 3 questions ;) > > >1) Just install the server and the client connections. Don't install the >Books Online on the server. > >2) SQL Server is fully ANSI 92 compliant. you shouldn't have a problem >except if you used certain functions that are supported in PostgresSQL and >not SQL Server. > >3) The Book Online is the best for SQL server. you could probably find 95% >of your answers there. If you can't find your answer there, hit >groups.google.com. MS also has a SQL Server section www.microsoft.com/sql > >Anthony Petruzzi >Webmaster >954-321-4703 >[EMAIL PROTECTED] >http://www.sheriff.org > > >-Original Message- >From: Brian Scandale [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, April 10, 2002 4:16 PM >To: CF-Talk >Subject: SQL Server Install and CF > > >Just sold our first CF app... a large manufacturing system. It is based on >our previous client server mfg systems. > >The Installation environment is Windows 2000, SQL Server 2000, and CF5. > >Our development environment is RedHat 7.2, PostgreSQL 7.1, and CF5. > >Two Questions: > >1. Was wondering if anybody has any sage advice about how we install SQL >Server. We have never installed or used it but have been told that there are >several options we might want to select when we install. > >2. Since we were careful to use Generic SQL queries (ANSI 92) we think that >it should run with few adjustments to the code. Is that reasonable? > >3. What might be considered great source material for learning more about >SQL Server? > >ok, three questions ;) > >thanks guys, >Brian > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Server Install and CF
Just sold our first CF app... a large manufacturing system. It is based on our previous client server mfg systems. The Installation environment is Windows 2000, SQL Server 2000, and CF5. Our development environment is RedHat 7.2, PostgreSQL 7.1, and CF5. Two Questions: 1. Was wondering if anybody has any sage advice about how we install SQL Server. We have never installed or used it but have been told that there are several options we might want to select when we install. 2. Since we were careful to use Generic SQL queries (ANSI 92) we think that it should run with few adjustments to the code. Is that reasonable? 3. What might be considered great source material for learning more about SQL Server? ok, three questions ;) thanks guys, Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: listing all form variables
Sure Jim,
try this
Form Variables
There are no form variables
Form.#Key#: #Evaluate("Form." & Key)#
At 12:43 PM 4/8/02 -0400, you wrote:
>Can CF output a list of all the form variables passed to a page?
>I vaguely remember this being possible but i don't remember how to do it.
>
>jim
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF on Redhat 7.1
Jim, I'm running CF5 very successfully first on RH7.1 and now 7.2 with apache and postgreSQL ... cfinstall handles it very well. However my similar problem arose when I used the RH GUI tool to make any configuration changes to apache. It ended up removing the cfinstall changes. So I now only modify httpd.conf with a text editing tool. hope this helps, Brian At 05:29 PM 4/5/02 -0500, you wrote: >We did that, but to no avail.. > >hmm... > >- j > >-Original Message- >From: Don Vawter [mailto:[EMAIL PROTECTED]] >Sent: Friday, April 05, 2002 5:00 PM >To: CF-Talk >Subject: Re: CF on Redhat 7.1 > > > From the cfdocs. > > >To configure Red Hat and Apache: > 1.. Shut down Apache with the following command: >/etc/rc.d/init.d/httpd stop >2.. To check whether your version of Apache is built with EAPI, run this >command: >httpd -V >If the output contains the line -D EAPI, you have an EAPI version of Apache. > > 3.. Open the file /etc/httpd/conf/httpd.conf in a text editor. >1.. If you are not running an EAPI version of Apache, in the section >LoadModule, add this line: >LoadModule coldfusion_module >/opt/coldfusion/webserver/apache/mod_coldfusion_standard.so >If you are running an EAPI, add this line: > >LoadModule coldfusion_module >/opt/coldfusion/webserver/apache/mod_coldfusion_EAPI.so >2.. In the section AddModule, add this line: >AddModule mod_coldfusion.c >3.. Save the file. > 4.. Restart Apache with this command: >/etc/rc.d/init.d/./httpd start >To configure SuSE/Cobalt and Apache: > 1.. To check whether your version of Apache is built with EAPI, run this >command: >httpd -V >If the output contains the line -D EAPI, you are running an EAPI server. >(SuSE requires an EAPI version of mod.coldfusion.so.) > > 2.. Shut down Apache with the following command: >/etc/rc.d/apache stop >3.. Open the file /etc/httpd/httpd.conf in a text editor. >1.. In the section LoadModule, add the following lines: >LoadModule mmap_static_module /usr/lib/apache/mod_mmap_static.so >LoadModule setenvif_module /usr/lib/apache/mod_setenvif.so >LoadModule coldfusion_module >/opt/coldfusion/webserver/apache/mod_coldfusion_EAPI.so >2.. In the section AddModule, add the following lines: >ClearModuleList >AddModule mod_mmap_static.c >AddModule mod_vhost_alias.c >AddModule mod_so.c >AddModule mod_setenvif.c >AddModule mod_coldfusion.c >3.. Save the file. > 4.. Create a symbolic link from the EAPI version of the ColdFusion Server >module to the /usr/lib/apache directory, to ensure that the EAPI module is >executable: >chmod 755 /opt/coldfusion/webserver/apache/mod_coldfusion_EAPI.so > ln -s /opt/coldfusion/webserver/apache/mod_coldfusion_EAPI.so >/usr/lib/apache/mod_coldfusion.so >5.. Open the file /etc/rc.d/apache in a text editor. >1.. Look for the following lines: >if ! test "$HTTPD_SEC_MOD_SAPCGI" == "no" ; then > test -e /usr/lib/apache/mod_fastcgi_sap.so || \ > test $(/usr/sbin/httpd -l | grep "mod_fastcgi_sap.c") = >"mod_fastcgi_sap.c" 2> /dev/null \ > && MODULES="-D SAP_CGI $MODULES" && echo -n " SAP-fastcgi" >fi >2.. Add these lines directly below the previous lines: >if ! test "$HTTPD_SEC_MOD_COLDFUSION" == "no" ; then > test -e /usr/lib/apache/mod_coldfusion.so && MODULES="-D COLDFUSION >$MODULES" && echo -n " Coldfusion" >fi >6.. Restart Apache with this command: >/etc/rc.d/apache start > >°¿° > ~ >Don Vawter > >- Original Message - >From: "Jim Curran" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, April 05, 2002 2:53 PM >Subject: CF on Redhat 7.1 > > >> Hi all, >> >> I'm installing Coldfusion 5 under RedHat Linux 7.1 for the first time. >Went >> through all the install steps as directed and the coldfusion processes are >> all running, but .cfm documents are processed just as straight-ahead >> txt/html documents. >> >> I've been over this a number of times, even tried uninstalling and clean >> re-installing but the situation remains the same. I'm guessing I'm missing >> something fairly simple, probably in the Apache setup? >> >> Any help would be greatly appreciated. >> thanks, >> >> -j >> >> -Original Message- >> From: Ian Lurie [mailto:[EMAIL PROTECTED]] >> Sent: Friday, April 05, 2002 4:43 PM >> To: CF-Talk >> Subject: RE: RegEx newbie help... >> >> >> Yup, as soon as I saw it it made sense - one of those days for me, I >> guess... >> >> -Original Message- >> From: Jerry Johnson [mailto:[EMAIL PROTECTED]] >> Sent: Friday, April 05, 2002 1:41 PM >> To: CF-Talk >> Subject: Re: RegEx newbie help... >> >> >> And if you are wondering why, >> >> <[^>]*> >> >> in english: >> >> a < followed by zero or more characters that are not a > followed by a > >> >> Jerry Johnson >> >> >> >>> [EMAIL PROTECTED] 04/05/02 04:26PM >>> >> rereplace(st,'<[^>]*>','',"all") should do it >> >> + >> ~ >> Don Vawter >> >> - Original Message - >> From: "Ian Lurie" <[EMAIL PROTECTED]> >> To: "CF-Talk" <
SQL Order By weirdness
Does anyone recognize why this list seems Out of Order? I am getting an odd result when using a calculation as the argument of an ORDER BY Statement... SELECT Starts, Rejects FROM History ORDER BY ((Starts-Rejects)/Starts) Hist.StartsHist.Rejects((Starts-Rejects)/Starts) This is the result... Out of Order Whats Up? Thanks for any insight! Starts Rejects Yield 100 20 80.00% 100 5 95.00% 10 2 80.00% 10 2 80.00% 100 0 100.00% __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF 5 Pro License Agreement (what if change of mind on platform?)
Hi Tracy, I've had the same question from time to time across the years... you get any definitive answer to that question yet? Would love to hear it. Thanks, Brian At 07:46 PM 3/29/02 -0600, you wrote: >If someone purchases the CF5 Pro for Windows, has a mind change & decides he >wants to run a linux server, is there a painful process to go through with >Macromedia or is the current license ok to do the install on a linux box ? > I know it will install and take the key, but I need to be sure its ok and the >legal thing to do. > > > Thanks >- Tracy > >-- >Visit "The Most Powerful Tool on the Farm" at http://www.ifarm.com >Get the latest on Ag News, Market Reports, FREE email, and much more. > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql and alias names
I have a query that is giving me a bit of a problem. SELECT * FROM History LEFT OUTER JOIN Op ON History.Op_ID = Op.Op_ID LEFT OUTER JOIN TravelerD ON History.TravelerD_ID = TravelerD.TravelerD_ID LEFT OUTER JOIN Notes ON History.History_ID = Notes.History_ID WHERE History.Device_ID = #theLot.Device_ID# ORDER by History.Date_Out TravelerD and Notes both share a field named TravelerD_ID. When there is not a matching Notes record, theHistory.TravelerD_ID from the query field ends up empty even though there is a TravelerD record that matches the query... the 2nd left outer join relates to it. How does one query tables that share common field names in this case. I can't seem to work out the alias technique here. As an aside history.op_id ALWAYS has a match in op history.travelerd_id does NOT always have a match in travelerd history.history_id does NOT always have a match in notes am I using the Left Outer Join properly here? thanks, Brian __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL case insensitive search ???
I guess I need to explain it better then. Yes the % is a wildcard in front of the search string.. and behind it too in my example HOWEVER, the search string itself is NOT case insensitive... so it will only find exactmatch of searchstring Example '%he%' finds 'the' but not 'THE' I would like to find regardless of case... How is that done? At 09:38 PM 3/14/02 -0800, you wrote: >it should be case insensitive to begin with? > >All '%searchString%' does is cause your query to table scan the whole >table since the wildcard is in front. > >J. > >John Wilker >Web Applications Consultant, and Author >Macromedia Certified ColdFusion Developer >President/Founder, Inland Empire CFUG. >www.red-omega.com > >"more people are killed by donkeys than by airplane crashes each year" > > >-Original Message- >From: Brian Scandale [mailto:[EMAIL PROTECTED]] >Sent: Thursday, March 14, 2002 9:36 PM >To: CF-Talk >Subject: SQL case insensitive search ??? > > >how does one go about structuring a case insensitive search on a text >field in a database? > >Currently using > >WHERE Table.FieldName LIKE '%searchString%' > >Thanks, >Brian > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL case insensitive search ???
how does one go about structuring a case insensitive search on a text field in a database? Currently using WHERE Table.FieldName LIKE '%searchString%' Thanks, Brian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Question About Query Caching
Now I'm a bit confused... I thought that as long as the query had not expired that cf would return the cashed results... regardless of which page called the query... particularly if the query name and slq were identical. ??? am I getting marauded by a donkey? At 01:36 PM 3/13/02 -0800, you wrote: >LOL. Oops, yeah I sure did. My bad. > >J. > > > >John Wilker >Web Applications Consultant, and Author >Macromedia Certified ColdFusion Developer >President/Founder, Inland Empire CFUG. >www.red-omega.com > >"more people are killed by donkeys than by airplane crashes each year" > > >-Original Message- >From: Bud [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, March 13, 2002 1:27 PM >To: CF-Talk >Subject: RE: Question About Query Caching > > >On 3/13/02, John Wilker penned: >>My idea would be to put a query with the same name on the page that >>updates the database. The new query will overwrite the cached one as >>long as the SQL is different, then the first time some one runs the >>real query it will re cache that one. > >You mean as long as the SQL is IDENTICAL. >-- > >Bud Schneehagen - Tropical Web Creations > >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] >http://www.twcreations.com/ 954.721.3452 > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: popUp Window trouble
Thanks Conrad,
I'll see what this info might do to help.
One thing you mention I don't want to do. I don't want the child window to close when
the parent window access a different URL. The info in the child window can still be
necessary to the user.
As far as different definitions goes... EVEN clicking the same Detail popsUp a New
Instance of the Detail.
My original question is at the bottom of this post... and still very much a mystery.
At 02:14 AM 3/13/02 +0200, you wrote:
>If the created window has different definitions, a new instance of the
>window will be created.
>Using the same variable ref container for both will cause the first
>instances reference to be
>lost as well. Also, it would also be better to close any children
>windows that may happen to
>be open when the current window is closed or references a different URL.
>
>Try the following
>
>
>
><!--
> var newWin;
> window.name = "theAppWindow";
> function popUp(page, name, details) {
>if(typeof(newWin != 'undefined') {
> if(newWin.name != name) newWin.close(); // First closes popUp
>Window if it exists.
>}
>newWin=window.open(page, name, details);
>newWin.focus();
>return false;
> }
>
> function popUpClose() {
>if(typeof(newWin != 'undefined') newWin.close();
> }
>
> window.onunload = popUpClose;
>//-->
>
>
>
>
>Help
>
>DETAILS>
>
>
>
>Conrad
>
>-Original Message-
>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>Sent: 12 March 2002 08:18 PM
>To: CF-Talk
>Subject: RE: popUp Window trouble
>
>
>Steve,
>
>It does work. It uses the same window for all the Help instances but
>every instance of Details opens a new window.
>
>Anybody else have an idea?
>
>thanks,
>Brian
>
>At 03:43 AM 3/12/02 -0500, you wrote:
>>That looks like it should work...
>>
>>window.open('url', 'windowName', 'properties');
>>
>>The only thing I noticed is the name is pretty long, "theDetailWindow",
>
>>not sure if it matters but you could try using a shorter name.
>>
>>Other then that I noticed you have the href set in the link. When I
>>use a link to popup a window with the onclick even I usually set the
>>href to "#" or "javascript:void(0)"
>>
>>_
>>steve oliver
>>senior internet developer
>>atnet solutions, inc.
>>http://www.atnetsolutions.com
>>
>>
>>-Original Message-
>>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, March 12, 2002 3:00 AM
>>To: CF-Talk
>>Subject: popUp Window trouble
>>
>>
>>One of my popUps always uses the same window for display... as
>>expected. The other always generates a new window... (which clutters
>>the desktop and uses resources). Both are called from the same page.
>>
>>I have a header that always has a help button in it. It calls help.cfm
>>which pops up a help window with the contents of #Client.HelpIs#. If I
>>navigate to a new page and press help, the old help window repopulates
>>with New help info.
>>
>>Another page has a list of items each with a button for "Details" by
>>each lineitem. Every press of the detail button brings up a new
>>DetailWindow, ...even If I press the SAME Detail button. I am looking
>>for all details to use the same window.
>>
>>As far as I can tell it is identical code... so I'm at a adjust this.
>>
>>The code:
>>
>>
>><!--
>>window.name = "theAppWindow";
>>var newWin;
>>function popUp(page, name, details) {
>>newWin=window.open(page, name, details);
>>newWin.focus();
>>return false;
>>}
>>//-->
>>
>>
>>
>>
>>Help
>>
>>DETAILS>
>>
>>
>>
>>As it so happens... the href= is of no consequence... i can put
>>anything in there... it's the popUp('page' that counts.
>>
>>Anybody know how I might start trying to fix this?
>>
>>thanks,
>>Brian
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: popUp Window trouble
Steve,
It does work. It uses the same window for all the Help instances but every instance of
Details opens a new window.
Anybody else have an idea?
thanks,
Brian
At 03:43 AM 3/12/02 -0500, you wrote:
>That looks like it should work...
>
>window.open('url', 'windowName', 'properties');
>
>The only thing I noticed is the name is pretty long, "theDetailWindow",
>not sure if it matters but you could try using a shorter name.
>
>Other then that I noticed you have the href set in the link. When I use
>a link to popup a window with the onclick even I usually set the href to
>"#" or "javascript:void(0)"
>
>_
>steve oliver
>senior internet developer
>atnet solutions, inc.
>http://www.atnetsolutions.com
>
>
>-Original Message-
>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, March 12, 2002 3:00 AM
>To: CF-Talk
>Subject: popUp Window trouble
>
>
>One of my popUps always uses the same window for display... as expected.
>The other always generates a new window... (which clutters the desktop
>and uses resources). Both are called from the same page.
>
>I have a header that always has a help button in it. It calls help.cfm
>which pops up a help window with the contents of #Client.HelpIs#. If I
>navigate to a new page and press help, the old help window repopulates
>with New help info.
>
>Another page has a list of items each with a button for "Details" by
>each lineitem. Every press of the detail button brings up a new
>DetailWindow, ...even If I press the SAME Detail button. I am looking
>for all details to use the same window.
>
>As far as I can tell it is identical code... so I'm at a adjust this.
>
>The code:
>
>
><!--
>window.name = "theAppWindow";
>var newWin;
>function popUp(page, name, details) {
>newWin=window.open(page, name, details);
>newWin.focus();
>return false;
>}
>//-->
>
>
>
>
>Help
>
>DETAILS>
>
>
>
>As it so happens... the href= is of no consequence... i can put anything
>in there... it's the popUp('page' that counts.
>
>Anybody know how I might start trying to fix this?
>
>thanks,
>Brian
>
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
popUp Window trouble
One of my popUps always uses the same window for display... as expected.
The other always generates a new window... (which clutters the desktop and uses
resources). Both are called from the same page.
I have a header that always has a help button in it. It calls help.cfm which pops up a
help window with the contents of #Client.HelpIs#. If I navigate to a new page and
press help, the old help window repopulates with New help info.
Another page has a list of items each with a button for "Details" by each lineitem.
Every press of the detail button brings up a new DetailWindow, ...even If I press the
SAME Detail button. I am looking for all details to use the same window.
As far as I can tell it is identical code... so I'm at a adjust this.
The code:
Help
DETAILS>
As it so happens... the href= is of no consequence... i can put anything in there...
it's the popUp('page' that counts.
Anybody know how I might start trying to fix this?
thanks,
Brian
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
