Incomplete XML causes problems
Hello, I've written a simple Yahoo RSS XML parser which you can see here: http://www.warrick.net/yahoo_rss_reader.cfm If you enter a search term that matches current news, the script works fine. However, if there are no matching stories, the XML returned is incomplete and an error is returned stating that some part of the XML that the code references is missing. I've tried evaluating the cfhttp.filecontent for the existence of certain things such as We did not find results for which you can see if you click through on the link this script generates. But the error still occurs. So what I need is some sort of error checking which will stop the XML from parsing if no news results are returned. Here's the script so far. Thanks! ---mark cfoutput form action=#script_name# method=post input type=text name=search_term size=30 / input type=submit value=Display Yahoo News Articles / /formbr / br / /cfoutput cfparam name=RSS_URL default= cfparam name=search_term default= cfif search_term neq cfset search_term = #Replace(search_term, , +, All)# /cfif cfif search_term neq cfset RSS_URL = http://news.search.yahoo.com/news/rss?p=#search_term#ei=UTF-8fl=0x=wrt; cfhttp throwonerror=yes url=#rss_url# method=get timeout=10/cfhttp !--- cfoutput#cfhttp.filecontent#/cfoutput --- cfif cfhttp.filecontent does not contain gif false cfset xmlDoc = XMLParse(cfhttp.filecontent) !--- cfdump var=#xmldoc# --- cfoutput #xmlDoc.rss.channel.title.xmlText#br a href=#xmlDoc.rss.channel.link.xmlText##xmlDoc.rss.channel.link.xmlText#/abr #xmlDoc.rss.channel.lastBuildDate.xmlText#br hr cfloop from=1 to=#ArrayLen(xmlDoc.rss.channel.item)# index=i p a href=#xmlDoc.rss.channel.item[i].link.xmlText##xmlDoc.rss.channel.item[i].title.xmlText#/abr / #xmlDoc.rss.channel.item[i].description.xmlText#br / /p /cfloop /cfoutput /cfif /cfif ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227015 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Incomplete XML causes problems
Ok guys - rookie move on my part. Using the conditional IsDefined works perfectly in stopping the XML from parsing when no news results are returned. Here's the complete working code: cfoutput form action=#script_name# method=post input type=text name=search_term size=30 / input type=submit value=Display Yahoo News Articles / /formbr / br / /cfoutput cfparam name=RSS_URL default= cfparam name=search_term default= cfif search_term neq cfset search_term = #Replace(search_term, , +, All)# /cfif cfif search_term neq cfset RSS_URL = http://news.search.yahoo.com/news/rss?p=#search_term#ei=UTF-8fl=0x=wrt; cfhttp throwonerror=yes url=#rss_url# method=get timeout=10/cfhttp !--- cfoutput#cfhttp.filecontent#/cfoutput --- cfif cfhttp.filecontent does not contain gif false cfset xmlDoc = XMLParse(cfhttp.filecontent) !--- cfdump var=#xmldoc# --- cfif IsDefined(xmlDoc.RSS.CHANNEL.ITEM) cfoutput #xmlDoc.rss.channel.title.xmlText#br a href=#xmlDoc.rss.channel.link.xmlText##xmlDoc.rss.channel.link.xmlText#/abr #xmlDoc.rss.channel.lastBuildDate.xmlText#br hr cfloop from=1 to=#ArrayLen(xmlDoc.rss.channel.item)# index=i p a href=#xmlDoc.rss.channel.item[i].link.xmlText##xmlDoc.rss.channel.item[i].title.xmlText#/abr / #xmlDoc.rss.channel.item[i].description.xmlText#br / /p /cfloop /cfoutput cfelse cfoutput No current news stories matched your search criteria strong#search_term#/strong. /cfoutput /cfif /cfif /cfif ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227017 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Alexa Web Information Service aka AWS
Has anyone successfully managed to get the new Alexa Web Information Service aks AWS to work with ColdFusion? I'm interested in building a set of tools for the following AWS funtions: Web Search: User enter a keyword. Alexa (Amazon) responds with a list of the top 100 websites matching that phrase. URL Information: User clicks on one of the top 100 sites for more info. A page displays all relevant Alexa data (not just a link to Alexa). Browse Category: Using AWS, retrieve a list of web site categories. Drill down to web search for top 100, URL Info for detail. Any help (free or otherwise) would be appreciated. ---mark ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226696 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
US-CA-Orange County - ColdFusion / Internet Marketing, SEO Specialist
Mark Warrick PO Box 1874 Orange, CA 92856-0874 Email: [EMAIL PROTECTED] Phone: 714-280-6253 URL: http://www.warrick.net OBJECTIVE: Seeking a full-time job or contracted assignment doing full-cycle web applications development, web design, web server administration and internet marketing. I'm willing to work onsite anywhere in Orange County and via telecommute anywhere else. I would prefer contracts, but am open to hearing about permanent positions as well. SAMPLE URLS: http://www.zapconnect.com http://www.hbsintl.com http://www.finncomfort.com http://www.thinkshoesusa.com http://www.verbaladvantage.com http://www.madeinoc.com http://www.sandiegocountybusinesses.com http://www.madeinshasta.com http://www.kinetictravel.net http://www.fusioneers.com http://www.performancecombos.net EXPERIENCE: 1/2001 - Present ZapConnect.com Santa Ana, CA I have been developing and promoting the ZapConnect.com website and database since its inception several years ago. The site is a robust SQL database driven by ColdFusion of over 100,000 companies and 80,000 products. It features advanced searching technology that is hundreds of times more accurate than other search engines. I have been responsible for all technical operations of the business including the development of the website itself, taking care of the co-located server, networking, hardware, planning, budgeting, and everything else necessary to make the business plan a reality. I also plan out all the marketing strategies, execute those plans, and measure the results of each test plan for effectiveness. The website is used by thousands of people a day in the medical field who find us 80% of the time on other search engines. 2/2000 - Present Fusioneers.com Santa Ana, CA Freelance Web Developer Wrote various applications with ColdFusion and SQL. Hired and managed contracted developers. Initiated sales calls, participated in client meetings, and wrote contracts. Handled all business issues. 11/1999 - 1/2000 Good Products, Inc. Tustin, CA Lead Internet Applications Developer Wrote specifications and developed a prototype application of FireRiver.com with ColdFusion and Oracle. Hired and managed contracted developers. 7/1999 - 10/1999 Planet Media Corporation Orange, CA Internet Applications Developer Wrote specifications and developed a sales lead tracking system for ATL Products (Quantum) with ColdFusion and SQL. 12/1998 - 6/1999 Net Explorer, Inc. Irvine, CA Lead New Media Developer Developed an online catalog of Hasbro's Star Wars toys with ColdFusion and Oracle. Coordinated and managed contracted developers. 6/1998 - 11/1998 CTX Data Services, Inc. Diamond Bar, CA Manager of Web Development Wrote specifications and developed various applications used company-wide for tracking RMA's with ColdFusion and SQL. 12/1997 - 5/1998 Online Connecting Point Irvine, CA I*Net Applications Developer Wrote various applications with ColdFusion, MS Access and PERL. Created layouts and web graphics. 5/1997 - 8/1997 Newport Internet Services Newport Beach, CA Web Programmer Wrote various applications with ColdFusion, MS Access and PERL. Created layouts and web graphics. 9/1996 - 5/1997 DELTA INTERNET SERVICES Anaheim, CA Web Programmer Wrote various applications with ColdFusion and MS Access. Created layouts and web graphics. EDUCATION: Orange Coast College Costa Mesa, CA Attended between 1993 to 1999. Cumulative GPA: 3.33. SKILLS: Skill Name Skill Level Last Used/Experience Coldfusion Expert Currently used/6 years Cold Fusion Expert Currently used/6 years HTML Expert Currently used/7 years Windows NT Administration Expert Currently used/5 years Networking - Peer Network Expert Currently used/5 years Microsoft Word Expert Currently used/11 years Microsoft Excel Intermediate Currently used/11 years Microsoft Access Expert Currently used/6 years PhotoShop Expert Currently used/6 years _JavaScript Intermediate Currently used/4 years Fusebox Expert Currently used/4 years ASP Beginner 2 years ago/3 years Perl Beginner 3 years ago/2 years Data Modeling Expert Currently used/4 years Data Normalization Expert Currently used/4 years Data Optimization Expert Currently used/4 years Oracle Beginner 2 years ago/1 years Sybase Beginner 2 years ago/1 years PhotoShop Expert Currently used/5 years Illustrator Beginner Currently used/2 years DHTML Beginner Currently used/2 years _JavaScript Intermediate Currently used/5 years Web Design Expert Currently used/5 years Web Graphics Expert Currently used/5 years Windows 98 Expert Currently used/3 years Windows NT Expert Currently used/4 years Windows ME Intermediate Currently used/1 years Windows 2000 Beginner Currently used/1 years Web Server Expert Currently used/4 years FTP server Expert Currently used/4 years mail server Expert Currently used/3 years DNS Server Beginner 2 years ago/1 years DHCP Server Intermediate
Need help with XML to JavaScript
Hello, Been a while since I've asked for help so hopefully this plea works! Basically, I want to provide data from my database to other websites in the form of simple cut and paste JavaScript code which other webmasters can include in their plain HTML websites. It's a simple data structure - your basic address book stuff: company name, address, phone, etc. Can anyone provide a simple example of how another website, using JavaScript alone, can query my system to return an XML package back to them which is then interpreted on their end with the simple JavaScript I give them? I'm sure this is pretty common since I see it done with newsfeeds and such all the time. ---mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212861 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Project sign-off agreement
Hello All, Does anybody have a basic project sign-off agreement that they could send me? I'd appreciate it! Thanks. ---mark - Discover Yahoo! Find restaurants, movies, travel more fun for the weekend. Check it out! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
regular expression help
Hello, I've got a form field in which I want to allow people to enter HTML tags (formatted stories for the web), but only a limited set of them such as heading, bold, and italic tags so that they don't mess up the overall formatting of the page. What I'd like to do is automatically strip out any other HTML tag (or JavaScript, CSS, DHTML, etc.) from the submission but leave the safe tags. I'm thinking that using a regular expression string to do this would be the way to go, however there is something to consider about that idea. The data ends up in an NTEXT field in the SQL database which is capable of storing a lot of data and I suspect people might be typing as much as a few pages of text into this field. So I'm worried that a regular expression might take too long to parse through all the entered text. Perhaps I'm missing something obvious here. Anyone have any suggestions? ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti __ 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
4 million messages per hour - is it possible?
Hello, Has anyone had experience in creating an emailing solution driven by ColdFusion and SQL on any platform with any mail server that is capable of handling 4 million deliveries an hour? If so, would you care to share what software you used to make it happen? And do you have a live example of a company using the system? ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti __ 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: 4 million messages per hour - is it possible?
Paris (and others), I like the optimistic tone of your message. It brings me hope that I might actually be able to pull this off. I was thinking along the same lines that a distributed solution with a powerful piece of mailing software would probably be the best idea. Plus of course, distributing the physical machines across multiple networks. If I get the chance to build this, I'm sure I'll be back to ask more questions and also to share my observations as I develop the system. If I don't get the chance, I'll post the offer here for anybody else who is interested. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:32 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? holly cow... 4 million geez... I am not asking who this is for.. that's a gross amount of emails... First off, I haven't created such a tool... Let's talk about theory here... With CF you can expect how many simultaneous pages per second performance wise? 50-100 on a nice box with tight code.. optimization, etc... so let's be optimistic... 100 x 60 seconds = 6000 messages per minute 6000 per min * 60 minutes = 360, messages per hour... per box... that's about 6 times the spool limit.. which is about 65k files... putting that aside... you need about 10-15 servers essentially with a distributed cooperative pooling mechanism to handle this... ideally... You also need a damn fast DNS or multiple local servers to reduce lookup times... Ideally, if you scrap the mail server need (which would be expensive, clogged, nightmare) and utilized a CF friendly mail server like iMS and ripped the mailing to a giant database table... had a scheduled event whereby each machine grabbed a range, worked it and recorded status errors etc to database and purged valid already mailed stuff or put in another table.. and talked maybe directly SMTP versus the need of a server well then it would be doable... recommend MySQL here... cheap and damn fast but with the machines I mentioned... you might also need some good bandwidth considering the volume of mail and the potential size of the emails themselves... That's my input... -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com (p) 1-212-655-4477 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 6:15 PM To: CF-Talk Subject: 4 million messages per hour - is it possible? Hello, Has anyone had experience in creating an emailing solution driven by ColdFusion and SQL on any platform with any mail server that is capable of handling 4 million deliveries an hour? If so, would you care to share what software you used to make it happen? And do you have a live example of a company using the system? ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti __ 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
automatic error exception
I'm building an error-trapping template which I'd like to be automatically emailed to me. I've figured out how to use CFERROR to display the problem to the screen, but how do I go about sending that to me automatically? There must be something I'm missing here. Is it perhaps a javascript technique that automatically posts the contents of a form on the same page? I'm curious to know how everyone else handles this. Thanks. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti __ 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: Canadian needs to know how US SSN values work
A valid SSN is formated like this: xxx-xx-. The first three digits have to do with zip code of the person's place of birth. Prior to 1973 it was the local Social Security field office number. * The first three digits will never be 000. * The first three digits will never be above 770. The next two digits are the Group number, which has to do with the order in which SSN's are issued within a particular geographical area. * The next two digits will never be 00. The last four digits are the serial number of the individual. Based upon the other two codes, there can only be a possible high number at any point in time. A list of those high numbers can be found here: http://www.ssa.gov/foia/highgroup.htm * The last four digits will never be . For more information on validating SSN's go to: http://www.cpsr.org/cpsr/privacy/ssn/ssn.structure.html ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 2:52 PM To: CF-Talk Subject: OT: Canadian needs to know how US SSN values work Forgive my lack of knowledge, but I need to write javascript validation code for US Social Security Numbers (SSN). In Canada, our equivalent numbers (SIN) has a specific length, and the sequence of numbers must pass validation (i.e. 111 111 111 is NOT a valid SIN, even though it has the right number of characters). I have found a number of SSN validation routines, but they seem to only check for blank values, and to make sure the SSN value (without any separators) is nine characters. Is this sufficent enough? Do the numeric values need to be a specific sequence? Thanks in advance. And sorry for the stupid simple question (for most of you I'd imagine). Shawn Grover __ 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: automatic error exception
Awesome! Thanks so much for the idea. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 3:32 PM To: CF-Talk Subject: Re: automatic error exception Here's one way I do it, very simple and does not try to get into specific solutions for specific errors: Surround your entire page in CFTRY/CFTRY and, just before the /CFTRY, plug in this: CFCATCH TYPE=MissingIncludeCFINCLUDE TEMPLATE=catch_include.cfm/CFCATCH CFCATCH TYPE=DatabaseCFINCLUDE TEMPLATE=catch_database.cfm/CFCATCH CFCATCH TYPE=AnyCFINCLUDE TEMPLATE=catch_any.cfm/CFCATCH These transmit slightly different errmsgs depending on the error type. Here's catch_any.cfm. Its set up so if I'm on my dev server it just displays an error scrn rather than emailing anything anywhere. uhoh.cfm, referenced at bottom, is a kind/gentle ''Oops'' html page displayed to the unlucky visitor. A site-wide error handler implemented via Administrator is a better way to do this, IMHO. But you need server admin access to go there. CFSET variables.DNOW =#CreateODBCDateTime(now())# CFIF NOT CompareNoCase(CGI.REMOTE_ADDR,127.0.0.1) DIV ALIGN=LEFT CFOUTPUT TABLE BORDER=1 BGCOLOR=##00 TRTD BERROR TYPE:/B #CFCATCH.type# BRBMESSAGE:/B #CFCATCH.Message# HRBDETAIL:/B #CFCATCH.Detail# BPAGE:/B #CGI.PATH_TRANSLATED# BRBREFERRER:/B #CGI.HTTP_REFERER# BRBQuery String:/B #CGI.QUERY_STRING# BRBREMOTE ADDR:/B #CGI.REMOTE_ADDR# BRBREMOTE HOST:/B #CGI.REMOTE_HOST# BRBREMOTE IDENT:/B #CGI.REMOTE_IDENT# BRBREMOTE USER:/B #CGI.REMOTE_USER# BRBBROWSER:/B #CGI.HTTP_USER_AGENT# P#variables.DNOW# /TD/TR/TABLE /CFOUTPUT /DIV CFELSE CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=#CFCATCH.type# SERVER=mail.their.com TYPE=HTML BMESSAGE:/B #CFCATCH.Message#HR BDETAIL:/B #CFCATCH.Detail# BRBPAGE:/B #CGI.PATH_TRANSLATED# BRBREFERRER:/B #CGI.HTTP_REFERER# BRBQuery String:/B #CGI.QUERY_STRING# HRBSERVER:/B #CGI.SERVER_NAME# BRBREMOTE ADDR:/B #CGI.REMOTE_ADDR# BRBREMOTE HOST:/B #CGI.REMOTE_HOST# BRBREMOTE IDENT:/B #CGI.REMOTE_IDENT# BRBREMOTE USER:/B #CGI.REMOTE_USER# BRBBROWSER:/B #CGI.HTTP_USER_AGENT# P#variables.DNOW# CFMAILPARAM NAME=Reply-To VALUE=[EMAIL PROTECTED] CFMAILPARAM NAME=Message-ID VALUE=#CreateUUID()#@mail.lelandwest.com /CFMAIL CFLOCATION URL=uhoh.cfm ADDTOKEN=No /CFIF --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Mark Warrick [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 21 Jun 2002 14:54:07 -0700 I'm building an error-trapping template which I'd like to be automatically emailed to me. I've figured out how to use CFERROR to display the problem to the screen, but how do I go about sending that to me automatically? There must be something I'm missing here. Is it perhaps a javascript technique that automatically posts the contents of a form on the same page? I'm curious to know how everyone else handles this. Thanks. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti __ 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: LinkPoint
I've done it. Here's the code. This is valuable code, so if you can please throw a bone my way. !-- begin act_public_cart_linkpoint.cfm -- cfsetting enablecfoutputonly=yes CFSET Chargetype_Auth = 0 !--- Funds Captured upon approval, funds will be set to transfer --- CFSET Chargetype_Sale = 0 !--- Funds Captured upon approval, funds will be set to transfer --- CFSET Chargetype_Preauth = 1 !--- Funds Reserved upon approval, Postauth will be needed to transfer funds --- CFSET Chargetype_Postauth = 2 !--- Reserved funds will be transferred, use upon shipping a hardgood --- CFSET Chargetype_Credit = 3 !--- Return or Refund of funds that were, AUTH, SALE or POSTAUTH --- CFSET Chargetype_Error = 0 !--- this option no longer used, please disregard --- CFSET Result_Live = 0 !--- Run transactions in LIVE mode, transaction charges apply --- CFSET Result_Good = 1 !--- Run transactions in TEST mode, no transaction charges --- CFSET Result_Duplicate = 2 !--- Return a duplicate transaction result --- CFSET Result_Decline = 3 !--- Return a decline transaction result --- CFSET Esdtype_None = 0 !--- Electronic softgood download type none --- CFSET Esdtype_Softgood = 1 !--- Electronic softgood download type file --- CFSET Esdtype_Key = 2 !--- Electronic softgood download type key (serial number) --- !--- ITEMID, DESCRIPTION, ITEMPRICE, ITEMQTY, SOFTFILE, ESDTYPE, ITEMSERIAL, ITEMOPTION, ITEMCHOICE --- CFSET ItemContext = queryNew(ITEMID, DESCRIPTION, ITEMPRICE, ITEMQTY) cfloop query=get_order_lineitems CFSET TempValue = queryAddRow(ItemContext) CFSET TempValue = querySetCell(ItemContext, ITEMID, #ID_PRODUCT#) CFSET TempValue = querySetCell(ItemContext, DESCRIPTION, #PRODUCT_NAME#) CFSET TempValue = querySetCell(ItemContext, ITEMPRICE, VA_PRICE) CFSET TempValue = querySetCell(ItemContext, ITEMQTY, quantity) /cfloop CFX_LinkAPI REQSTORENAME = 123456 REQKEYFILE = c:\\cfusion\\customtags\\123456.pem REQHOSTADDR = secure.linkpt.net REQPORT = 1139 ORDERUSERID = #session.id_contact# ORDERBCOMPANY = #BILLING_COMPANY# ORDERBCOUNTRY = #BILLING_COUNTRY_CODE# ORDERBNAME = #BILLING_FIRST_NAME# cfif BILLING_MIDDLE_NAME neq #BILLING_MIDDLE_NAME# /cfif#BILLING_LAST_NAME# ORDERBADDR1 = #BILLING_ADDRESS1# #BILLING_ADDRESS2# ORDERBCITY = #BILLING_CITY# ORDERBSTATE = cfif BILLING_STATE_CODE neq #BILLING_STATE_CODE#cfelse#BILLING_STATE_OTHER#/cfif ORDERBZIP = #BILLING_ZIP# ORDERSNAME = #SHIPPING_FIRST_NAME# cfif SHIPPING_MIDDLE_NAME neq #SHIPPING_MIDDLE_NAME# /cfif#SHIPPING_LAST_NAME# ORDERSADDR1 = #SHIPPING_ADDRESS1# #SHIPPING_ADDRESS2# ORDERSCITY = #SHIPPING_CITY# ORDERSSTATE = cfif SHIPPING_STATE_CODE neq #SHIPPING_STATE_CODE#cfelse#SHIPPING_STATE_OTHER#/cfif ORDERSZIP = #SHIPPING_ZIP# ORDERSCOUNTRY = #SHIPPING_COUNTRY_CODE# ORDERPHONE = #BILLING_DAY_PHONE# #BILLING_EVENING_PHONE# #SHIPPING_DAY_PHONE# #SHIPPING_EVENING_PHONE# ORDERFAX = null ORDERCOMMENTS = null ORDERCARDNUMBER = #CREDIT_CARD_NUMBER# ORDERCHARGETYPE = #Chargetype_Auth# ORDERCARDEXPMONTH = #CREDIT_CARD_EXP_MM# ORDERCARDEXPYEAR = #CREDIT_CARD_EXP_YY# ORDEREMAIL = #BILLING_EMAIL# ORDERRESULT = #Result_Good# ORDERSHIPPINGPRICE = #shipping_total# ORDERTAX = #TAX# QUERY = ItemContext !--- Result mode set to #RESULT_LIVE# when live --- !--- now write the result code back to the database --- cfquery name=check_result_code datasource=#session.dsn# UPDATE ORDERS SET ORDER_RESPONSE_CODE = '#CSIOrderFieldApproved#', ORDER_REF = '#CSIOrderFieldRef#', ORDER_CODE = '#CSIOrderFieldCode#', ORDER_ERROR = '#CSIOrderFieldError#', ORDER_NUM = '#CSIOrderFieldOrdernum#' WHERE ID_ORDER = #id_order# /cfquery !--- CFOUTPUT PRE Api Version:#APIVersion# Order Time: #CSIOrderFieldTime# Order Ref: #CSIOrderFieldRef# Approved Status:#CSIOrderFieldApproved# Order Code: #CSIOrderFieldCode# Order Error:#CSIOrderFieldError# Order Num: #CSIOrderFieldOrdernum# Esd Links : #CSIEsdLinks# /PRE /CFOUTPUT --- cfsetting enablecfoutputonly=no !-- end act_public_cart_linkpoint.cfm -- ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 8:40 AM To: CF-Talk Subject: LinkPoint Anyone here using Linkpoint and there CFX tag? I'm pulling my hair out try to figure out how
RE: Accessing Microsoft Access and SQL db's on CD
Shawn, Scroll down. Click on the links below the reference to MicroWeb. And yes you can run a fully dynamic website from a CD with this product. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 7:28 AM To: CF-Talk Subject: RE: Accessing Microsoft Access and SQL db's on CD What is the freeware product, you are talking about? What can it do? Anything to do with running apps from a CD? Shawn Regan -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 19, 2002 5:26 PM To: CF-Talk Subject: Re: Accessing Microsoft Access and SQL db's on CD Yea it is cool. I had come across it when someone referred to it on another list and said they had success. Everyone thought I was nuts about creating datadriven daatabase sites on a CD. I was just hoping that these guys may have had some competitors so I had some choices.. also - they don't refer to CF at all - . but good luck jay Mark Warrick wrote: Jason, That's a freeware product. And it's VERY interesting. I'm glad you found that. I'm going to have to give that a try. You can actually use PHP, PERL and MySQL to create a database driven website that you can send out on a CD. WOW. Uh, MM, I think you missed the boat on this one! :) ---mark Mark Warrick ( [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net http://www.warrick.net / http://www.fusioneers.com http://www.fusioneers.com http://www.zapconnect.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti === = -Original Message- From: Jason Miller [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, June 18, 2002 9:44 PM To: CF-Talk Subject: Re: Accessing Microsoft Access and SQL db's on CD Mark, Unfortunately if it were for a demonstration - I am already there.. I run WinNT and CF and an IIS server.. BUT this is for creation on a CD. SO not demonstration. I am taking a completly dynamic site. Creating it in it's own isolated little world ( a CD ) and passing it out to multiple customers on multiple OS's - So the cd really must contain everything it would need. There is a product call microWeb - http://www.indigostar.com/microweb.htm http://www.indigostar.com/microweb.htm http://www.indigostar.com/microweb.htm http://www.indigostar.com/microweb.htm but I am not sure if it is on the money - been around a while.. But I was hoping for other solutions and suggestions. Again - this is not a demo and I am not walking in anywhere with a machine. This is a project for a client - who wants his entire dynamic site to run on a CD. thanks! jason Mark Warrick wrote: For demonstrations, I use a laptop which mirrors the server setup as closely as possible. I run WinNT, a mail server, and SQL on the little guy for the most realistic affect. Trust me, it sells. If you're stuck in the non-server O/S world, you can export your SQL database to Access and use that as the DSN. I prefer using Apache over Microsoft's PWS for many reasons, so I'd recommend that as the web server. There's plent of Win9X-based SMTP servers out there like PostCast and you can even run a full-blown SMTP server on the same machine. If the database is Access you can recreate all th e reports and forms within Access. Half the work would already have been done if you already wrote everything with ColdFusion. SQL databases can be exported to Access. One thing I have no clue about is taking a client/server application and automatically porting it to a standalone application. I can think of numerous issues that could come up, but Visu al basic comes to mind. I realize all these options take work. But hey - if somebody comes up with the majical solution to port an extremely complex website onto a CD for a decent price, you've got a buyer here. ---mark Mark Warrick ( [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / E fax: 801-730-7289 http://www.warrick.net http://www.warrick.net http://www.warrick.net http://www.warrick.net / http://www.fusioneers.com http
RE: /CFusion to D:/CFusion Advice..
Sure, Make a mirror copy of drive C onto drive D and then physically remove the drives from the machine and reorder them so that drive D is the master and drive C is the slave. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 8:58 AM To: CF-Talk Subject: C:/CFusion to D:/CFusion Advice.. OK... i messed up. i updated cf server on the C Drive. without having enough space left over for the virus scans other things to run.. is there a way to move the C:/CFusion to D:/CFusion with out a uninstall reinstall??? any advice or suggestions would be appreciated. you can laugh now... i know i need to rebuild the box, but have no real time or money for it. thanks. -paul __ 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: cfif... not working properly?
How about something like this? #DirectoryExists(C:\temp\test\data\123\)# ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 10:55 AM To: CF-Talk Subject: cfif... not working properly? Hi, In this example the results from my #URLDecode(dir)# is C:\temp\test\data\123\ I'm trying to check is the directory data exists in the variable and if so, do something else. The syntax below is not working properly. What am I doing wrong? cfif ListFindNoCase(URLDecode(dir),\data) h5You are in the data directory/h5 cfelse h5You are somewhere else/h5 /cfif __ 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: How can i filter more than one file type in cfdirectory
Unfortunately, you can only apply one filter at a time, but here's a sample syntax for looking for JPG's: CFDIRECTORY ACTION=list DIRECTORY=c:\inetpub\wwwroot\whatever NAME=mydirectory FILTER=*.jpg SORT=name DESC You could loop the script for each type of file you're trying to list like this: cfset file_types = *.jpg,*.gif cfloop list=#file_type# index=ii CFDIRECTORY ACTION=list DIRECTORY=c:\inetpub\wwwroot\whatever NAME=mydirectory FILTER=*.jpg SORT=name DESC cfoutput query=mydirectory cfif (name neq .) and (name neq ..) and (name neq index.cfm) and (size neq 0) #Name# #Round(DecimalFormat(size/1000))#k /tr /cfif /cfoutput /cfloop ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 12:41 PM To: CF-Talk Subject: How can i filter more than one file type in cfdirectory i need to filter for jpg's AND gif's in cfdirectory filter anyone know how i can do this?? __ 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
testing..... I'm back
OK it's been a while since I've been around here. I figure I may as well try to participate again. Let's see if I still know anything about ColdFusion. ;) ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti __ 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: Crysatal Reports - for sale
OK with all this talk of Crytal Reports, I figured I throw out this offer. To anybody who's interested in buying the latest version of Crystal Reports Professional, I've got the 4.5 Professional (single user, I think) version in a sealed box. Buying this from me would save you at least $300.00 vs. purchasing the latest full Pro version. Make an offer. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Steve Drucker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 11:36 AM To: CF-Talk Subject: RE: Crysatal Reports Crystal Decisions www.crystaldecisions.com Regards, Steve Drucker CEO Fig Leaf Software -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 2:28 PM To: CF-Talk Subject: RE: Crysatal Reports Seagate -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 2:25 PM To: CF-Talk Subject: OT: Crysatal Reports Um, who makes Crystal Reports? __ 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: Getting to an Access DB on a remote machine
In theory, you would setup a mapped network drive to the remote machine by using either the DNS name or IP address of the remote machine followed by the name of the shared drive. But if you don't have a T-1 on both ends, the connection speed may be too slow to maintain or even connect. So, for example, if the DNS name of the remote machine was www.fusioneers.com, and the shared drive was public, then you'd setup a network drive with the following path: \\www.fusioneers.com\public From there, you would select it as though the .MDB file was on your local machine since you would have a mapped drive on your local machine. But in practice, I've never seen it work. I tried it with a DSL connection on my end (restricted to 128k upstream) with multiple T-1's on the other end and still couldn't get at it. But you may be able to if you've got a super fast connection. OK so maybe I'm better at networking than CF these days. ;) ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 11:25 AM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine How would I do that? I have gone into data sources and looked for where I can set it up by giving it an ip address or whatever, and I can't seem to find it. By remote I don't mean even on the same network, maybe not even in the same country. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 10:13 AM To: CF-Talk Subject: RE: Getting to an Access DB on a remote machine You can create a DSN on the CF machine that points the access file on the remote machine. Shawn Regan -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 10:02 PM To: CF-Talk Subject: Getting to an Access DB on a remote machine Hey, I was wondering if anyone knew how to get CF to talk to an access DB on a remote machine? Here's my thing. Client buys products from vender. Vender has product list in an access db. Client wants to be able to automatically update it's available product line without waiting for updates. Now I am thinking there should be an easy way to register the Access db as an odbc data source, then on clients machine use that. But I can't seem to find a straight ODBC driver. Seems to be all product specific. We need this to be able to go to MX, so no dns-less connections or whatever. I am sorry if this is something I should know how to do. I don't often work with windows based servers, and almost never with Access when I do. TIA Tim __ 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: California Stats sales tax by county
A comma delimited database is available here: http://www.boe.ca.gov/sutax/pam71.htm However, in general, I believe most tax accountants would tell you to just use the highest tax rate of the state. Most people won't complain and the FTB certainly won't complain if you collect too much tax. Talk to your accountant though before implementing this - it's a lot more complicated than just knowing which counties charge which rates. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 1:11 PM To: CF-Talk Subject: California Stats sales tax by county Does anyone have a compiled list of the various sales tax rates by county for California? Just finishing up an e-commerce site, and I didn't know the state tax was broken down this way.. grr.. Thanks in advance! Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com http://www.digitalstormfront.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: Accessing Microsoft Access and SQL db's on CD
For demonstrations, I use a laptop which mirrors the server setup as closely as possible. I run WinNT, a mail server, and SQL on the little guy for the most realistic affect. Trust me, it sells. If you're stuck in the non-server O/S world, you can export your SQL database to Access and use that as the DSN. I prefer using Apache over Microsoft's PWS for many reasons, so I'd recommend that as the web server. There's plent of Win9X-based SMTP servers out there like PostCast and you can even run a full-blown SMTP server on the same machine. If the database is Access you can recreate all the reports and forms within Access. Half the work would already have been done if you already wrote everything with ColdFusion. SQL databases can be exported to Access. One thing I have no clue about is taking a client/server application and automatically porting it to a standalone application. I can think of numerous issues that could come up, but Visual basic comes to mind. I realize all these options take work. But hey - if somebody comes up with the majical solution to port an extremely complex website onto a CD for a decent price, you've got a buyer here. ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti -Original Message- From: Digital Internet Limited [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 02, 2000 5:32 AM To: CF-Talk Subject: Re: Accessing Microsoft Access and SQL db's on CD Personally I use a laptop for client demonstrations SB - Original Message - From: Jason Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 7:35 PM Subject: Re: Accessing Microsoft Access and SQL db's on CD Hello everyone, I need to copy a few of my coldfusion sites onto CD for clients. Most of them running MS access or sql databases. I will be using a combination of director and flash to do the user interface - but do not wisht o convert data and modify all the queries to work with some of the Director database solutions out there. Has anyone any links or products that allow the creation of a database to reside on a CD as a mini ODBC type driver where all the queries can be executed from the db on the cd? I would love to be able to make the queries go to the net for latest information - but too many people will have slow or unreliable questions.. So I need to as effortlessly as possible recreate a whole coldfusion/ database scenario on a CD. Any help or direction is appreciated. Thanks, Jason __ 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: setting cf admin password - 2 questions
You can unencrypt the templates that make up the CF Administrator and use only the ones that handle the password changes. ---mark === Mark Warrick, Founder of Fusioneers.com Email: [EMAIL PROTECTED] / [EMAIL PROTECTED] Phone: 714-547-5386 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti === -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Friday, October 19, 2001 5:38 PM To: CF-Talk Subject: setting cf admin password - 2 questions Hi all, I'm wondering how can you set the cf administrator password using a regular cf page? I can get the password no problem. I just want to set my own but not via the administrator. Also, getting the password for Cf4, has that changed in cf5 or can you use the same code? brbrbrMark Smeets/stranger0/ICQ #1062196 My new email: [EMAIL PROTECTED] Mr. West, not every situation requires your patented approach of shoot first, shoot later, shoot some more and then when everybody's dead try to ask a question or two - Wild Wild West A Stranger's Domain http://24.113.34.178/stranger Official Splitting Adam Homepage http://www.splittingadam.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: controlling GROUP ACCESS
First of all, giving everyone the same username and password is a mistake. Nobody should EVER share the same login information. Next, you're going to need to figure out a way to track usage. The easiest way is to track by IP address, however if everyone is behind a proxy or firewall, that won't work. Another way to track them is by using cookies. You associate the cookie on their machine with their user info. Whatever means you use to track the user, next you need a table to track concurrent sessions. As soon as a user logs in, you make an entry to the usage table. When the number of users reaches 20, you would prevent the next user from logging in. Another thing your probably going to want to do is implement an auto logout feature like many of the online banking sites have. This will prevent somebody from walking away from their desk for extended periods - thereby causing the next person to not be able to login because potentially all the concurrent sessions would be in use. If you are hosting the code itself on your own server, you will be able to protect it and enforce the usage rules. However, if you give it to the client and let them host it under their control, well, then nothing really would stop them cracking open the code to eliminate all your security measures. ---mark -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 3:00 AM To: CF-Talk Subject: controlling GROUP ACCESS Hi, I have a website that produces some information. No one can see my information except registered users. I give every user a UserName and Password to access his account. I want to add a new type of registration. Some of the big organizations asked me to provide them with a special registration. They want to buy 20 licences for 20 PCs for a year. All the 20 PCs should login with the same username and password at the same time. Or I may provide them with a software that makes them already logged in. I need any suggestion about this kind of GROUP ACCESS to a website. How to sell a number of licences to a customer. Regards, Hamid Hossain ~~ 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: Help with dedicated server
Most ISPs that offer dedicated services also rent you all the software as well, so in most cases you don't need to buy anything. That should be included in the monthly lease. Two servers is probably going to run you between $1600-$2000 per month for a decent ISP, but you can get it much cheaper if you go with a smaller network. You can manage your servers with PC Anywhere. You need at least a cable modem connection to do that effectively. The sound of one hand clapping would depend upon the friction of the air, water, or whatever surface it's clapping against. You should know what your expected traffic levels are upfront based upon the logs you should already be keeping. This will be a factor in pricing. For example, if you're running a porn site, you're probably going to pay high fees for excess bandwidth charges. Keep in mind that a lot of hosting companies are in trouble right now because the whole internet economy is in a slump. Just because a company is big doesn't mean that they are stable. With that in mind, always have a backup plan. If you can afford the hardware and software, I recommend bringing everything inhouse. If you need a more detailed analysis, I have a document I prepared for one of my previous clients which goes into much deeper detail - email me directly if you're interested. ---mark -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 2:52 PM To: CF-Talk Subject: Help with dedicated server I am getting ready to help the move a web site to a dedicated server. I have know idea where yet. It is currently load balanced on two servers running CF server 4.5 and Informix. Can anyone give me some advice, words of caution, or things to look for when I go to pick out the company to host us? I need help with things like: Do I buy CF Server 5 or does that usually come with a service? How do I manage the server when its half way across the US? What is the sound of one hand clapping? How do I find out how much band width I need? You get the idea. TIA Phillip ~~ 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: How to find out the page to send 'em back to
To add to this discussion, don't forget to append the Query String as well. cfset return_url = #script_name#?#query_string# And make sure you surround any redirect with a conditional that stops a loop if the user is looking at the login form. cfif fuseaction does not contain login cflocation url=#path_to_login#/index.cfm?fuseaction=login_formreturn_url=#URLEncodedF ormat(return_url)# addtoken=yes /cfif Since you're not using cookies or session vars, you'll have to pass the CFID and CFTOKEN between all page requests or come up with a unique number to pass around. Of course, this leaves your system wide open because you would be passing those unique identifiers through form and url variables, but hey you gotta do what you gotta do. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 7:07 AM To: CF-Talk Subject: RE: How to find out the page to send 'em back to Hmmm, maybe I don't understand the full scope of what you're asking, but seems like you could do this: - When a user hits a secure page, redirect to the login page with a URL variable containing the page they hit (for example, .cflocation url=login.cfm?referer=#cgi.script_name#). - Pass that URL variable to the form processing page via a hidden form field. - If the user is authenticated, use the hidden field to redirect back to the page they were originally trying to hit. - If the user is not authenticated, use the hidden field to redirect back to the login page with the hidden field as a URL variable (starts the whole process over). Hope that works for you! Ryan -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 8:47 AM To: CF-Talk Subject: How to find out the page to send 'em back to I am working on a login system that has so many limitations you couldn't imagine it. I want to have the actual login form and processing page as a single pair of templates in a single location for the whole site. If any page requires a user to be logged in, and they're not, they'll be sent to this page and then sent back to the original page once satisfactorily logged in against a table in the datasource. Not so difficult you'd have thought. So let me put some limitations on there and see if it's still so easy: No client variables. Not allowed - all state management has to be in our site's own datasources No session variables - it's a clustered environment. No custom tags permitted Ok, so I could have the referring page add it's own location to the parameters passed to the login page. Except that #cgi.path_info# doesn't work. Gives null as a response. So the login page could use #http_referrer# (which does work) to specify where to sent the user back. But what happens when the login page goes round fhe second time or third time because they've put in the wrong password or something. It'll only have the correct #http_referrer# the first time through the page won't it? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~~ 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: Url as Data Source
If you're talking about setting up a remote ODBC connection to something like SQL server, then yes, so long as that domain name maps to a specific IP address, you can use it in your connection string. Is that what you meant? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = -Original Message- From: ronmyers [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 9:26 AM To: CF-Talk Subject: Url as Data Source Is it possible to use a url as a datasource (newbie question) ~~ 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: OT IIS question
I don't recommend against IIS but I do recommend against putting Front Page customers and ColdFusion customers on the same box. Front Page is for amateurs, and amateurs should be separated from the people that know what they're doing. Get the NT Option Pack 4.0 and all the latest hotfixes and updates. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = -Original Message- From: David Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 9:32 AM To: CF-Talk Subject: OT IIS question Thanks all on the list, your emails have helped a lot in learning CF. We have a very small shop and I'm trying to figure out how to upgrade IIS to 4 or 5.I thought this happened when we loaded SP6 on the NT40 but when I go to IIS server manager help it tells me am running IIS 3. Also when I run the new lock down tool it tells me it won't run on this version of IIS. Question is am I reading version number correctly in the IIS manager and if so how do you upgrade your IIS. I have looked at MS site found all the patches just have not found the IIS server upgrades. I understand a lot people don't recommend IIS but it's what I've got to use. I would like to upgrade server because we have a couple people have FP sites that are having trouble so I would like to get server updated to latest IIS server and FP extensions and patches. Coldfusion and Seagate stuff is running great. Thanks for the help David Green Configuration NT 4.0 sp6 CF 5.0 IIS 3 (I think) Seagate Page Server 8.0 FP2000 extensions ~~ 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: Auto Refresh
How about fixing the javascript so that when focus is lost (i.e., the user backs into the form again) it will reset itself? Other than that, you could disable the back button and force the use to use links, which would reset the form because calling a CFM template would generally cause the browser to refresh itself - especially if you're appending urls with a random number. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = -Original Message- From: cf kaizen [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 11:04 AM To: CF-Talk Subject: Auto Refresh Hi There, Upon hitting the back button to go back to a page with the twoSelectsRelated tag on it, the first select box maintains its selected option, whereas the second select box reverts to the options available had the first option in the first select box been selected, causing an error when the user resubmits the form. I've been trying to force a refresh of the page, but my refresh code causes havoc on the two select boxes. Any ideas? Thanks, Andy ~~ 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
WARNING!!! COLDFUSIONPARTNERS.COM
Just in case anyone else has been contacted by Glenn Milo Farineau regarding the purchase of the domain name coldfusionpartners.com, I want you all to know that we already have an agreement in place. I haven't heard from the guy since I gave him what he wanted for the domain name (a case of beer), but I'm going to assume for now that he's simply busy. I thought I'd pass along the information just in case anyone else is in negotiations with him to let you know that it's already sold. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = ~~ 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: 2 Submit Buttons on one form
Just to add to all of this. One of the suggestions was to look for the existence of a form variable carried through, based upon the name of the submit button. Although this will work, it's easier to name both submit buttons the same, and use a CFSWITCH to load in the appropriate template based upon the VALUE of the submit button (the visible button title). For example, I use this for all delete confirmation templates. form action=#script_name# method=post input type=hidden name=fuseaction value=#fuseaction# input type=hidden name=id_record value=#id_record# input type=submit name=delete value=No input type=submit name=delete value=Yes /form ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 9:23 AM To: CF-Talk Subject: RE: 2 Submit Buttons on one form Got it - many thanks for all your responses. :o) Mark -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:23 AM To: CF-Talk Subject: 2 Submit Buttons on one form Is it possible to place two submit buttons on one form, each button calling a different action (template). If so, how would it be done? Thanks, Mark ~~ 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
reading an XLS file into a query...
Hello All, Here's what I want to do: User uploads an XLS file (column names will always be consistent) - this I've got figured out. CF reads the XLS file into a query and dumps the data into a SQL table. - part of this I can't figure out. I know how to read from a text file and do an import into SQL that way, however, my problem is that I need to read DIRECTLY from an XLS file that has been uploaded. NO DSN connections are allowed. I'm thinking maybe a COM object? What do you all think? Where should I start hunting for knowledge? I've tried CFFILE, CFHTTP, and CFCONTENT. None of those do the trick. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = ~~ 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: Anyone know what these cf errors mean?
Neither of those files are standard files within the CFIDE directory structure, so I would say that you've probably got some bad CFML code running on the server which is looking for non-existent files. Search through all the templates for those filenames to locate the culprit. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 12:05 PM To: CF-Talk Subject: Anyone know what these cf errors mean? Our entire logfile is filled with these two errors, something keeps looking for the files serverinfo.cfm and getmetricdataXML.cfm. It happens every minute like clockwork. -- HTTP/1.0 404 Object Not Found. The template specified, Q:\Inetpub\wwwroot\xxx\cfide\mib\serverinfo.cfm, does not exist. -- HTTP/1.0 404 Object Not Found. The template specified, Q:\Inetpub\wwwroot\xxx\cfide\mib\getmetricdataXML.cfm, does not exist. -- Thanks, Dave ~~ 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: Home Office Firewall
I hear Blackice is pretty good. I've used McAfee's firewall as well. They both do a great job of blocking traffic. Unfortunately, on a development server that caused me problems and I ended up passing on that idea. They're more trouble than they're worth for me. Your situation may be different. Blackice works on NT and 2000. McAfee is only for 95/98/ME. Don't be fooled by the cable/dsl routers. The packaging is misleading. Although network translation does provide a level of enhanced security since the end user doesn't know the internal IP, a good hacker can still get through the router and get to your machine. However, if you find a cable/dsl router that has a built-in firewall (the most expensive ones have a real firewall) you should be OK. If you're on a modem, you have little to worry about to begin with. Blackice or McAffee whould be sufficient in that case. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 10:27 AM To: CF-Talk Subject: Home Office Firewall Any ideas on home firewall software? I run a cold fusion server and ftp server from home so I can backup work, and work remotely and when I am at school and what not. What would be some good firewall protection to implemement on the server? Mike ~~ 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: Next/Previous
=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##currentrow#nbsp;/td td bgcolor=#currentrowbgcolor# align=topfont face=#session.fontface# size=#session.tablefontsize# a href=#session.web_root_path#/companies/index.cfm?fuseaction=companies_detai leregnum=#eregnum#reset_search=1#ename#/abr #estreet1# cfif Trim(estreet2) neq br #estreet2#br /cfif cfif Trim(ophone) neq br #ophone# /cfif nbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##ecity#nbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##estate#nbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##ezip#cfif Trim(ezipext) neq -#ezipext#/cfifnbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##ecounty#nbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##ecountry#nbsp;/td cfif session.groups contains 1 td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize#a href=#session.web_root_path#/admin/companies/index.cfm?fuseaction=admin_com panies_editid_registration=#id_registration#Edit/a/td /cfif /tr /cfoutput cfoutput tr td colspan=3font face=#session.fontface# size=#session.fontsize#a href=#script_name#?fuseaction=#fuseaction#start=1ename=#URLEncodedFormat( ename)#county=#URLEncodedFormat(county)#state=#URLEncodedFormat(state)#so rtby=enamesearch_option=#URLEncodedFormat(search_option)#Original Device Companies Search Results/anbsp;/td td colspan=5 align=rightfont face=#session.fontface# size=#session.fontsize# cfif get_companies.recordcount gt 10 a href=#script_name#?fuseaction=#fuseaction#start=#PrevStart#ename=#URLEnco dedFormat(ename)#county=#URLEncodedFormat(county)#state=#URLEncodedFormat( state)#sortby=#sortby#search_option=#URLEncodedFormat(search_option)#Pre vious #maxrows#/a nbsp; a href=#script_name#?fuseaction=#fuseaction#start=#NextStart#ename=#URLEnco dedFormat(ename)#county=#URLEncodedFormat(county)#state=#URLEncodedFormat( state)#sortby=#sortby#search_option=#URLEncodedFormat(search_option)#Nex t #maxrows#/a /cfif nbsp;/td /tr /cfoutput /table /cfif /cfif = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 11:09 AM To: CF-Talk Subject: Next/Previous Anyone have code for a good previous and next record display. I can write one but I am feeling lazy. TIA, Joshua Tipton ~~ 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 INTELLIGENT AGENT QUESTION
Interesting. On the same note, does anyone know how to: 1) Login to a password protected site. 2) Run a query 3) Strip out all HTML and bring back data only from search results. I've looked into Regular Expressions to do this. Is that what you would recommend? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 11:07 AM To: CF-Talk Subject: Re: CF INTELLIGENT AGENT QUESTION If its webserver password protection then the CFHTTP tag can have the password in it. If it's cookie based then do the following: 1. Call a page that sets the cookie. 2. read the cookie from the CFHTTP header info 3. call the next page while sending the cookie as a CFHTTPPARAM 4. repeat as needed At 01:54 PM 7/31/01, you wrote: Is it possible to use CFHTTP to connect to a web site and establish an on going session? What I am trying to accomplish is to have the agent go into a password protected site, then query the search engine on that site and retrieve individual web pages from the links that are returned. If this is not possible does anybody know of any third party software that can accomplish this task? Steven Lewis ADNET Lead ColdFusion Developer Office: 703-845-3996 Pager: 703-219-5759 ~~ 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: can't connect to mail server
Check your /cfusion/mail/undelivr directory for a backlog of undelivered emails. Check your /cfusion/log/mail.log for specific error messages that the mail server sends back. Make sure you have permission to relay on the mail server. Since CF cannot pass a username/password combo to the mail server for authentication that means that the mail server must be able to relay based upon your CF server's IP address. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:39 PM To: CF-Talk Subject: can't connect to mail server Are there any ideas as to why Cold Fusion cannot connect to a mail server? You can rule out the mail server being down or change of address because I just tested it using a non-cold fusion program and I received an email. When I go to the CF Admin and 'verify' the mail server connection I get 'Unable to connect to server'. It was working last week and today all of a sudden I send any emails via CFmail or Cf_aspmail ~~ 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: default.ida?
I'm getting quite a few requests like this: 00:38:13 202.109.105.67 GET /default.ida 401 02:20:36 24.130.170.100 GET /default.ida 401 02:50:41 194.7.47.130 GET /default.ida 401 04:00:45 65.2.171.167 GET /default.ida 401 04:55:53 211.172.176.231 GET /default.ida 401 05:49:07 12.98.100.6 GET /default.ida 401 06:33:12 63.17.76.22 GET /default.ida 401 06:35:31 216.85.123.121 GET /default.ida 401 07:00:16 200.176.48.234 GET /default.ida 401 07:52:00 163.180.18.14 GET /default.ida 401 08:21:23 210.181.179.242 GET /default.ida 401 08:47:19 210.255.176.132 GET /default.ida 401 08:57:43 216.104.158.213 GET /default.ida 401 09:00:22 210.122.124.118 GET /default.ida 401 10:32:16 139.130.84.98 GET /default.ida 401 11:31:56 24.128.34.95 GET /default.ida 401 12:10:29 209.239.84.85 GET /default.ida 401 12:14:58 61.145.108.35 GET /default.ida 401 12:27:16 203.248.108.241 GET /default.ida 401 13:37:05 211.99.96.131 GET /default.ida 500 13:46:58 202.107.224.234 GET /default.ida 401 14:01:32 63.222.244.124 GET /default.ida 401 14:12:54 155.229.77.166 GET /default.ida 401 15:22:40 210.106.239.202 GET /default.ida 401 Interestingly though, my server is password protected. Does IIS log the request even if the page doesn't exist, and even if it did, couldn't be access due to the password protection anyway? I've applied the Code Red patch already. I guess I'm safe! ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 9:44 AM To: CF-Talk Subject: RE: default.ida? You had better never give out your FQDN either.. you can find the IP from that pretty easily.. lol Jeff Beer Senior Programmer Architect Hydrogen Media, Inc (727) 530-5500 x303 [EMAIL PROTECTED] -Original Message- From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 11:18 AM To: CF-Talk Subject: RE: default.ida? sorry for asking!!! I didn't think you'd take me seriosuly! Wow, I'd change the IPs also; that is good advice. Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED] This Email contains MillenniuM Information Systems, LLC Privileged Information which is Customer or Business Sensitive. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 11:05 AM To: CF-Talk Subject: RE: default.ida? Might be an idea to go away and change the IP addresses on your servers now and abandon these two for all eternity Never put this kind of information out on the list. You are openning yourself up to abuse by the few unscrupulous people on this list... Stephen -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 15:50 To: CF-Talk Subject: RE: default.ida? 193.122.20.5 - Production 193.122.20.8 - Development Why? -Original Message- From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 3:34 PM To: CF-Talk Subject: RE: default.ida? whats yur ip? :-) Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED] This Email contains MillenniuM Information Systems, LLC Privileged Information which is Customer or Business Sensitive. -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 10:32 AM To: CF-Talk Subject: RE: default.ida? -Original Message- I don't actually think it's hysteria mate, do you want to see a copy of my IDS logs Not really, no. They tend to be boring and full of kidz getting 404's. :-) I did say IDS logs though, they filter out all the crap and only show me the ISAPI Extension Overflow errors. There are a large number of attacks going on as I write this Woo-wee - where have you been ? An ongoing scan of your system
RE: Home Office Firewall
Sounds like a good idea. Is there a minimum hardware requirement for that? Is it easy to setup? I've got a spare PII 233 I could use. Do think that's sufficient? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 11:05 AM To: CF-Talk Subject: Re: Home Office Firewall I run FreeBSD for my firewall and have 3 servers on the inside. At 01:26 PM 8/2/01 -0400, you wrote: Any ideas on home firewall software? I run a cold fusion server and ftp server from home so I can backup work, and work remotely and when I am at school and what not. What would be some good firewall protection to implemement on the server? Mike ~~ 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
selecting top n records
I need to select the top selling products from a table of lineitems. Top selling products would be those whose ID_PRODUCT shows up the most in the ORDERS_LINEITEMS table. Any clues from the SQL gurus out there? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = ~~ 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
FW: selecting top n records - RESOLVED
Here's the answer to the question for anyone who is curious. cfquery name=get_top_products_counts datasource=#session.dsn# SELECT TOP 3 COUNT(ID_PRODUCT) as thecount, ID_PRODUCT FROM ORDER_LINEITEMS GROUP BY ID_PRODUCT /cfquery = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:07 PM To: cf-talk Subject: selecting top n records I need to select the top selling products from a table of lineitems. Top selling products would be those whose ID_PRODUCT shows up the most in the ORDERS_LINEITEMS table. Any clues from the SQL gurus out there? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = ~~ 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: CFIF Confusion
I'm not certain why the SQL statements you noted below would work the way they do, but it's possible that the fields are padded with extra spaces around the yes which is causing a problem. Converting the field type from varchar to integer will solve the problem. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 7:07 AM To: CF-Talk Subject: CFIF Confusion Hello! I'm working with SQL Server 2000 and I have a query I'm confused about. There's a field (FIELD1) that's defined as a VARCHAR. The field contains either Yes or No. I SELECT all records and then want to display somthing different if FIELD1 is a Yes or No. The following structure works: cfif FIELD1 IS NOT No Bunch of code /cfif This structure does not work: cfif FIELD1 IS Yes Bunch of code /cfif I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx ~~ 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 Datatype Datetime
Yes, it's fine to have a null value in a datetime field, but you have to be sure you're not passing anything other than a datetime value into it. It's possible that you're trying to send in a blank value, which is actually a set of spaces as opposed to nothing at all, which would be a null value. What I do is put a CFIF around the parts of the SQL statement that involve dates. If there's no date present, I just do nothing with that field. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 28, 2001 10:38 PM To: CF-Talk Subject: SQL Datatype Datetime Is it possible to have a null Datetime field although I have allowed nulls, it still complains. Or would it be better to have a very distant past date... ~~ 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: word forms
Yes, you can create functionality similar to that found in MS Word, but the functionality is somewhat limited. The limitations in question aren't because of ColdFusion, but rather the various browsers you have to deal with. You can probably get something real close with a mixture of DHTML, JavaScript, and JavaApplets. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 12:54 PM To: CF-Talk Subject: word forms i work alot with forms in word. is there a way to replicate some of the features that i can do in word to coldfusion? for example, i can have a form that when u double click on the link to the form..the first thing u see i a pop-up where u can fill in the form fields from this popup box. then when u click submit...it automatically pre-fills the form for u. so u can print it or email it. does anyone have an example of this for the web? thanks so much, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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 7.0
I believe that's NTEXT (16). You can verify that by exporting an Access database with a memo field into SQL. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:28 AM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ 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: Opening a new Window
Are you taking about where on the screen it would open? If so, I believe that's a DHTML issue. Otherwise, you can read up on how to create windows at http://www.irt.org. I recommend searching the net for DHTML tutorials or buy a book. Someone else on this list might be able to tell you exactly how to do it though. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: ronmyers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:02 AM To: CF-Talk Subject: Opening a new Window HI I am a newbie at Using CF and HTML in general, But I am having fun learning. My problem is I am opening a new window. I know how to set the size How do I set the location where it opens. Thanks Ron ~~ 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 7.0
Andrew, NTEXT provides for a farily large amount of data (for example, an entire resume). If you want something bigger than what SQL can handle, you should just use CFFILE to create text files to store the data. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:05 AM To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ 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 7.0
How is that field type incompatible with ColdFusion? I use it and it seems to be working fine. Am I missing something here? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:10 AM To: CF-Talk Subject: RE: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! Try ntext ntext is UNICODE, and since CF45 aren't UNICODE compatible, this won't do anything for you apart from eat twice the hard disk space Until CF6/Neo comes out, it's easier to use text, varchar and the like rather than their N equivalents... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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 7.0
Have you counted the characters of whatever text it is you're trying to insert into the SQL field? And can you insert this same text into Access, but not a SQL ntext field? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:29 AM To: CF-Talk Subject: RE: SQL 7.0 I have this now and there is a field of text I need to place into this field and it complains that the size is to small!!! -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 2:02 AM To: CF-Talk Subject: RE: SQL 7.0 I believe that's NTEXT (16). You can verify that by exporting an Access database with a memo field into SQL. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:28 AM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ 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: MySQL Front
Linked tables in Access to the SQL db works pretty well as a GUI front end. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 11:10 AM To: CF-Talk Subject: OT: MySQL Front Does anyone have a favorite MySQL GUI interface for a Win 2K box? I like MySQL-Front so far, but im wondering if there is something better to maintain and connect to a MySQL database on a IRIX server. Thanks, Chad ~~ 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 7.0
I appreciate the explanation. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 11:22 AM To: CF-Talk Subject: RE: SQL 7.0 The difference between NTEXT and TEXT is that NTEXT supports Unicode data. The price for this is that it takes twice as much space on your server to store NTEXT data as it does to store TEXT data. Consequently, SQL Server will only let you store half as much NTEXT data as TEXT data. ColdFusion does not understand Unicode data as such so you cannot manipulate Unicode data. Therefore, if you are working in a ColdFusion environment, you generally gain no benefit using the NTEXT datatype as oposed to the TEXT datatype. So, it is not that NTEXT is incompatible, but rather, an unnecessary use of system resources. There are always exceptions, of course. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 1:10 PM To: CF-Talk Subject: RE: SQL 7.0 How is that field type incompatible with ColdFusion? I use it and it seems to be working fine. Am I missing something here? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:10 AM To: CF-Talk Subject: RE: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! Try ntext ntext is UNICODE, and since CF45 aren't UNICODE compatible, this won't do anything for you apart from eat twice the hard disk space Until CF6/Neo comes out, it's easier to use text, varchar and the like rather than their N equivalents... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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 7.0
Wait sec. Which website are the books online at? lol ; ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:34 PM To: CF-Talk Subject: RE: SQL 7.0 you're kidding! it's THAT easy??? ;-) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:34 PM To: CF-Talk Subject: RE: SQL 7.0 I'm dying to know how you figure that out... Something tells me I should probably know. There's no magic involved. Here's how I did it. 1. Open SQL Server Books Online. 2. Search for text. 3. Copy field length into email message. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (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: strange recurring error
This is a tough one to diagnose. Basically what's happening is that the CF Server is restarting itself, and the reason is probably because of too many unresponsive requests. You can adjust the threshold settings in the Administrator, or simply turn off the CF Server's auto-restart functions, but ultimately the problem most likely lies with your code. You can track slow pages under the logging functionality in the Administrator to figure out which templates are causing the problems. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Kirk Boecker [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:54 PM To: CF-Talk Subject: strange recurring error anyone ever run into this error message? Error,TID=1628,07/27/01,12:02:55,An error occurred while attempting to establish a connection to the service.PThe 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. PWindows NT error number 2 occurred. we seem to get it about 20 times a day in the logs - and dont know why - when we actually get this on screen, a simple refresh always works to get the page - but this is obvioulsy not good. Kirk ~~ 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
how to re-enable CFREGISTRY?
OK I made a mistake. In the CFAdministrator, I disabled the CFREGISTRY tag. And then I discovered that once you do that, you can no longer use the CFAdministrator. Great. So, how do I get that thing turned back on now? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = ~~ 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: how to re-enable CFREGISTRY?
OK nevermind guys I answered my own question You have to do this with REGEDIT. The registry key is: HKEY_LOCAL_MACHINE SOFTWARE Allaire ColdFusion CurrentVersion Server EnableCFREGISTRY Set the EnableCFREGISTRY tag to 1, then restart the CF Application Server service. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 1:10 PM To: CF-Talk Subject: how to re-enable CFREGISTRY? OK I made a mistake. In the CFAdministrator, I disabled the CFREGISTRY tag. And then I discovered that once you do that, you can no longer use the CFAdministrator. Great. So, how do I get that thing turned back on now? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = ~~ 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: multiple search mess
Try this: cfquery name=getcurr SELECT * FROMcurric_topic, curriculum WHERE NOT ID_FIELD = 0 !--- insert various conditional SQL statements here --- AND #pullcurrtopic.topic_field_code# 0 AND curric_topic.curricula_id = curriculum.curricula_id AND activity_code 0 /cfquery = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Janice Kepka [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 2:02 PM To: CF-Talk Subject: multiple search mess Hi all! I'm allowing users to search for water education programs. They are allowed to search by as many fields as they want, which could be a lot of fields. So far, I am looping over the submitted list of fields but what I'm getting is a list of results based on each individual chosen field, not one list based on all of the chosen fields. I need to somehow dynamically create the multiple 'AND' statements in the SQL query to get only the records the user wants. This all works fine if I hard code in all of the qualifying fields in the SQL but how do I do it dynamically? It seems like this shouldn't be that difficult...perhaps I've been looking at this too long. Any help would be greatly appreciated. Please be specific about implementation. Sometimes I have a hard time translating the suggestions I see on the list into implementation. Here is the code that generates a list for each option. cfloop index=ListElement list=#form.topic# !--- Pulls the field code name from the form-passed info --- cfquery name=pullcurrtopic SELECT * FROMtopic_option WHERE topic_field_code = '#ListElement#' /cfquery !--- Pulls out all of the curriculum that have the above field code checked in the database. There has to be a join with the curriculum table in order to get at the name of the curriculum. --- cfquery name=getcurr SELECT * FROMcurric_topic, curriculum WHERE #pullcurrtopic.topic_field_code# 0 AND curric_topic.curricula_id = curriculum.curricula_id AND activity_code 0 /cfquery cfoutput query=getcurr#curricula_name#br/cfoutput /cfloop Thanks! Janice Kepka Web Coordinator 303 Hiram Smith Hall 1545 Observatory Drive Madison, WI 53706 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 ~~ 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: come on Forta !
Would anyone like the complete code and database to the recommended reading section of my personal site? If so, respond to me directly. Hamid, this would solve your problem. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 2:39 PM To: CF-Talk Subject: RE: come on Forta ! Come on Forta! I knew that should be a linker table for all many to many relations. I tried to shorten the chart. I am a good student who read most of your books, Ben. still need the help: Books --- BookAuthors --- Authors | |- BookCategories --- Categories | |- BookLanguages --- Languages As you can see, Three tables are linked to (Books) table in many to many relations. I want to output a list of all books with all (Authors), (Categories) and (Languages) of each single book. Could you please help me with the best way doing that. In another way, Can I do it with a single query?!. Regards, Hamid Hossain --- Ben Forta [EMAIL PROTECTED] wrote: Not the ideal design, change it to this: Books --- BookAuthors --- Authors | |- BookCategories --- Categories | |- BookLanguages --- Languages All relationships are one to many (one on the left and right, many in the center). Will make your life much easier. --- Ben -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 11:52 AM To: CF-Talk Subject: come on Forta ! Hi folks, I'v just ordered Ben Forta's new book. I am woundering if I will find a way to solve this problem. I have the following database tables: --- many -- Authors | (Table) | | | Books - many - many -- Categories (Table) | (Table) | | | --- many -- Languages (Table) As you can see, Three tables are linked to (Books) table in many to many relations. I want to output a list of all books with all (Authors), (Categories) and (Languages) of each single book. Could you please help me with the best way doing that. In another way, Can I do it with a single query?!. Any CF code will be appreciated. Regards, Hamid Hossain ~~ 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: shopping cart
That's a pretty broad question. There are many ways to do this, but I wouldn't try setting temporary variables such as by using cookies or session vars to store that info. I use a shopping cart table to store the items. Once the order is complete, I move the items to a line items table. If anyone bails out of their shopping cart session, I'll know because there will be an old shopping cart session (previous to today). ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 1:26 PM To: CF-Talk Subject: shopping cart currently, when a user clicks BUY ME for a product, the info for that product goes into an array (Price, id, desrctiption, quantity). whats a better way to do it? ~~ 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: Duplicate Templates
Are you saying that ALL of the templates that are included in this Fuseaction are being repeated? It helps to add HTML comments at the beginning and end of each file which state the file's name. That way you can just view the source and you'll see where the problems are occuring. Try adding in each sub-template one at a time until the problem happens again. Also, are any of your sub-templates including other templates? (which would be a no-no) ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Greg [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 7:05 PM To: CF-Talk Subject: Duplicate Templates Anyone on the job tonight have any ideas why a template is being displayed twice, yet in the debug info it only shows it once? DSP_CANNOtINSERT.CFM is the culprit. When I view source I see 2 whole templates running! !doctype...head and all twice. It's probably something dumb, but I'm fried! Execution Time 485 milliseconds 4 ms C:\CFUSION\CUSTOMTAGS\CUSTOMTAGS\FORMURL2ATTRIBUTES.CFM 0 ms C:\CFUSION\CUSTOMTAGS\CUSTOMTAGS\MISCELLANEOUS\DEBUGGER.CFM 0 ms C:\INETPUB\WWWROOT\HSMN\APPLICATION.CFM 14 ms C:\INETPUB\WWWROOT\HSMN\EXTRANET\APP_GLOBALS.CFM 10 ms C:\INETPUB\WWWROOT\HSMN\EXTRANET\PROJECTS\GAMBRO\APP_LOCALS.CFM 3 ms C:\INETPUB\WWWROOT\HSMN\EXTRANET\PROJECTS\GAMBRO\SCANMERGE\APP_LOCALS.CFM 358 ms C:\INETPUB\WWWROOT\HSMN\EXTRANET\PROJECTS\GAMBRO\SCANMERGE\DSP_CANNOTINSERT. CFM 36 ms C:\INETPUB\WWWROOT\HSMN\EXTRANET\QUERIES\QRY_GLOBALS.CFM 60 ms STARTUP, PARSING, SHUTDOWN ~~ 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: Maintenance Manager for websites
CFSCHEDULE ? MS Outlook? A Palm Pilot? A calendar? = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: nyon [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 7:38 PM To: CF-Talk Subject: Re: Maintenance Manager for websites Hi, I am running a few websites and also holding a job. Therefore, I don't have much time to keep track of the changes needed to the sites. Is there a software, online service, etc which can 1. notify me to change my question in my polls (after 1 month) or 2. remind me to send the weekly newsletter and other tasks to keep the site 'fresh'. Thanks Nyon ~~ 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: Thumbnails
Adobe Photoshop 5.0 and newer versions as well as various other batch-processing
programs can create all the thumbnails for you.
Once you've got the images processed, you can use code such as the templates below to
display the images. For a working example of this code, take a look at my personal
site - photo section, high-bandwidth area.
!-- begin display_photo_list.cfm --
cfinclude template=header.cfm
!--- script language=JavaScript1.1
!-- Begin
function right(e){
if (navigator.appName=='Netscape'
(e.which==3||e.which == 2))
return false;
else if(navigator.appName=='Microsoft Internet Explorer'
(event.button==2||event.button==3)){
alert(Please don't steal my images. Thanks.);
return false;
}
return true;
}
document.onmousedown=right;
if(document.layers)window.captureEvents(Event.MOUSEDOWN);
window.onmousedown=right;
//End--
/script ---
cfset center_color = F4B642
cfset center_align = center
cfset center_valign = middle
center
table width=100% cellpadding=5 cellspacing=0 border=0
CFDIRECTORY DIRECTORY=#GetDirectoryFromPath(GetTemplatePath())#/photography/small
NAME=myDirectory
cfoutput query=myDirectory
cfif (size neq 0) and (name does not contain .cfm) and (name does not contain
.txt)
cfset enlarged_file_name = #ReplaceNoCase(#name#,_sm,, ALL)#
cfset caption_file_name =
#ReplaceNoCase(#enlarged_file_name#,.jpg,.txt,ALL)#
tr
td valign=middlefont face=#fontface# size=#fontsize#a
href=display_photo.cfm?photo=#enlarged_file_name# target=_windowimg
src=photography/small/#name#/a/font/td
td valign=middlefont face=#fontface# size=#fontsize#
!--- TEST #session.rootpath#/photography/captions/#caption_file_name# ---
!--- note: comment this out and uncomment the text file initialization code below to
create files automatically for all the thumbnails ---
cfinclude template=photography/captions/#caption_file_name#
/font/td
/tr
!---initialize text files---
!--- cffile action=WRITE
file=#GetDirectoryFromPath(GetTemplatePath())#/photography/captions/#caption_file_name#
output=#caption_file_name# text addnewline=Yes ---
/cfif
/cfoutput
/table
/center
cfinclude template=footer.cfm
!-- end display_photo_list.cfm --
cfinclude template=header.cfm
script language=JavaScript1.1
!-- Begin
function right(e){
if (navigator.appName=='Netscape'
(e.which==3||e.which == 2))
return false;
else if(navigator.appName=='Microsoft Internet Explorer'
(event.button==2||event.button==3)){
alert(Please don't steal my images. Thanks.);
return false;
}
return true;
}
document.onmousedown=right;
if(document.layers)window.captureEvents(Event.MOUSEDOWN);
window.onmousedown=right;
//End--
/script
form action= method=post onSubmit=self.close()
input type=submit value=Close
/form
CFIF FileExists(#template_path_enlarged_photos_directory#/#photo#)
cfoutput
img src=#web_path_enlarged_photos_directory#/#photo#
/cfoutput
CFELSE
Sorry! An error occured. This file does not exist.
/cfif
form action= method=post onSubmit=self.close()
input type=submit value=Close
/form
cfinclude template=header.cfm
---mark
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
-Original Message-
From: admin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 9:39 AM
To: CF-Talk
Subject: Thumbnails
Can anyone recommend the most efficient way to create thumbnail images from a
directory dynamically.
~~
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: Connecting to the SQL server remotely
Try setting up an ODBC connection with the Windows Control Panel first. If you can connect to a remote SQL server that way it will work with ColdFusion as well. In this case, the problem is that you've got is that the connection type set to Trusted Connection, which means you would have to be logged in to Windows as the username/password combo that the remote server expects. Since ColdFusion normally runs as a system account, it wouldn't be able to pass along the correct username/password combo to the remote SQL server for authentication. Also, the remote SQL server must be setup to allow SQL-based authentication. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 10:10 AM To: CF-Talk Subject: Connecting to the SQL server remotely Hello, I am trying to connect to my SQL box remotely - it works fine when the server is sitting on a private (192.168.x.x) IP, but when I switch the box to be visible on the net, I get a message (not associated with a trusted SQL connection...) when trying to register the server in the EM. Thanks for any help. ~~ 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: HELP: CFmail Error
Yes. It means your disk is full. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 9:16 AM To: CF-Talk Subject: HELP: CFmail Error Does anyone know what this error means? Error Occurred While Processing Request Error Diagnostic Information Error occurred while attempting to spool mail message to file (spool directory = 'C:\CFUSION\MAIL\SPOOL\', recipient='[EMAIL PROTECTED]', subject='Comments and Suggestions') The disk is full. (Filename=C:\CFUSION\MAIL\SPOOL\CFM232.TMP) The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (15:1) to (17:43) in the template file D:\shares\www\lmsg_int\business_development\cic\forms\cic_contacts_action..cf m The specific sequence of files included or processed is: D:\SHARES\WWW\LMSG_INT\BUSINESS_DEVELOPMENT\CIC\FORMS\CIC_CONTACTS_ACTION..CF M ~~ 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: CFFORM vs. CFGRID
Why not enter the products directly into the Access database? I wouldn't recommend CFGRID or CFFORM. Those are limited functions. You can loop through 10 record entries at a time the same way you would loop through a shopping cart to update quantities. There's just a bunch more fields involved. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: John Paitel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 9:55 AM To: CF-Talk Subject: CFFORM vs. CFGRID Hey all... Question about editing database information. I have an inventory database that I want users to be able to update via a web interface. For the initial entry, I have a screen that enters a single item, then updates the database (Access at the moment). For editing purposes, I'd like them to be able to edit up to 10 records at a time. Is this suited more to CFGRID, or CFFORM? (As you can tell, I am on the newer side of the CF fence.) And, does CFGRID handle entering in 10 new records at a time? Or should I stick with the single page entry? (Users sometimes will be entering in quite a few new items, and single screen entry gets long and tedious). Any opinions? Or is there something even better out there that I haven't seen yet? John Paitel ~~ 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: CFFORM vs. CFGRID
) VALUES (#ID_CART_LINEITEM#, #session.id_cart#, #ID_PRODUCT_FREE#, 1) /cfquery /cfif /cfloop /cfif !--- cfoutput ID_CART_LINEITEM: #ID_CART_LINEITEM# - Qty.: #quantity#br /cfoutput --- /cfloop cflocation url=#script_name#?fuseaction=#fuseaction# addtoken=no /cfif !-- end act_public_cart_update_lineitems.cfm -- Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: John Paitel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 11:33 AM To: CF-Talk Subject: RE: CFFORM vs. CFGRID Why not enter the products directly into the Access database? This is not my inventory, it is their inventory. There may be multiple locations entering in their own inventory. (Think more along the lines of an office inventory rather than a store inventory). I wouldn't recommend CFGRID or CFFORM. Those are limited functions. Ok, alternatives? You can loop through 10 record entries at a time the same way you would loop through a shopping cart to update quantities. There's just a bunch more fields involved. Array type? Remember, I am somewhat new to this part of it. John ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric === -Original Message- From: John Paitel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 9:55 AM To: CF-Talk Subject: CFFORM vs. CFGRID Hey all... Question about editing database information. I have an inventory database that I want users to be able to update via a web interface. For the initial entry, I have a screen that enters a single item, then updates the database (Access at the moment). For editing purposes, I'd like them to be able to edit up to 10 records at a time. Is this suited more to CFGRID, or CFFORM? (As you can tell, I am on the newer side of the CF fence.) And, does CFGRID handle entering in 10 new records at a time? Or should I stick with the single page entry? (Users sometimes will be entering in quite a few new items, and single screen entry gets long and tedious). Any opinions? Or is there something even better out there that I haven't seen yet? John Paitel ~~ 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 Query
May we see the query? The best thing to do is to write your SQL statements to search on as few a number of fields as possible, especially when you're doing full-text searching. Turning on full-text indexing in SQL will increase the performance a little bit. Turning your SQL statements into stored procedures may also help. Cacheing queries definitely helps. Avoid using open LIKE statements wherever possible (LIKE %#var#%). If you can't avoid using LIKE operators in your SQL statements, then at least try to limit the searching capability to BEGINS WITH, ENDS WITH, IS EXACTLY rather than ANY PART. Also, avoid multi-table joins to increase performance. Has anyone written a book that specifically covers this subject? I'd buy it. Ben? How about you buddy? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: David Clay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 1:50 PM To: CF-Talk Subject: SQL Query I am looking for help on a way to query a table fast and efficiently. I am currently using a ODBC connection to SQL2000 Server with a simple CFQUERY tag doing the query. For a table with 18K records, it takes 14 seconds. I know this is not doing something correct!! Any help designing new query statements or set up of CF or SQL2000 Servers would be helpful. Thank you for your time. Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 303.770.8506 ~~ 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: CFERROR
In IIS, you can customize the error templates. So you could theoretically create CFML error template for each condition which would do the same thing as CFERROR. Each webserver platform is different, but most have the capability to use custom error templates. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 4:04 PM To: CF-Talk Subject: CFERROR Hello all Need a little help with CFERROR. CFERROR Type=Exception Template=error.cfm Mailto=emailaddress I have placed the tag in my application.cfm and it seems to be working, except for 404 Object not Found errors. all errors generated once a page has started processing seemed to be caught, even 404s generated from custom tags not being found, but if a link is broken , A href or in a form post, I still get the standard white page with the 404 error message. What can I do to catch this error? I'm using WINT and CF 5.0 Thanks Rodney ~~ 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: cfmail error with attachment
Looks like you're trying to attach a file to your CFMAIL message, so check the path to the attachments directory to make sure it's the same as wherever the file is stored. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 6:04 PM To: CF-Talk Subject: cfmail error with attachment hi all, i got this error when i tried to send an email with attachment, anyone help please? Error Occurred While Processing Request Error Diagnostic Information Unable to attach file. Cannot attach 'C:\testing.txt' to the mail message. The file does not exist The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (1:1) to (4:14). Date/Time: Wed Jul 25 08:46:35 2001 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; MyIE 2.4) Remote Address: 210.19.20.19 ~~ 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: Questions to ask for CF developer
I agree with a few of the other people here. It's kind of ridiculous to ask someone to take a ColdFusion test. I mean, that's sort of like asking a secretary to take a typing test. You either know your stuff or you don't. You'll find out very quickly whether the person has the technical knowledge they claim to have, and if you don't have enough knowledge of ColdFusion to be able to know any different, well then shame on you for trying to act like you ColdFusion by putting a test in front of me. Whomever is going to manage these developers had best know their stuff as well! ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 5:52 AM To: CF-Talk Subject: OT: Questions to ask for CF developer I've just been asked to prepare some questions for possible new employees. He wants it general but able to gauge their knowledge. This is a 2nd interview type deal- the first one people stated yeah I have X yrs experience with CF. We don't want to get too nitty gritty but we do want to get a feel for how well they do know it. Any ideas? I need answers quickly- they are doing call backs this afternoon. Thanks. j ~~ 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: Questions to ask for CF developer
By the way, on the same note, I was once given a one-hour ColdFusion test to see if I could build a simple contact database within an hour. I finished the application in one hour, 5 minutes. I failed the test, and in my opinion, so did the company. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 4:53 AM To: CF-Talk Subject: RE: Questions to ask for CF developer I agree with a few of the other people here. It's kind of ridiculous to ask someone to take a ColdFusion test. I mean, that's sort of like asking a secretary to take a typing test. You either know your stuff or you don't. You'll find out very quickly whether the person has the technical knowledge they claim to have, and if you don't have enough knowledge of ColdFusion to be able to know any different, well then shame on you for trying to act like you ColdFusion by putting a test in front of me. Whomever is going to manage these developers had best know their stuff as well! ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 5:52 AM To: CF-Talk Subject: OT: Questions to ask for CF developer I've just been asked to prepare some questions for possible new employees. He wants it general but able to gauge their knowledge. This is a 2nd interview type deal- the first one people stated yeah I have X yrs experience with CF. We don't want to get too nitty gritty but we do want to get a feel for how well they do know it. Any ideas? I need answers quickly- they are doing call backs this afternoon. Thanks. j ~~ 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: (OT) Access SQL Statement
= Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = With Access and SQL, you put the NOT before an otherwise true condition. WHERE NOT StartTime BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 18:30:00 ---mark -Original Message- From: Skyward Internet Technology [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 9:52 AM To: CF-Talk Subject: (OT) Access SQL Statement I'm used to Oracle, so I always choke on Access stuff . . . How do you do a NOT BETWEEN in Access? (Note: StartTime is a Date/Time Field) EX: SELECT StartTime FROM myTalbe WHERE StartTime NOT BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 18:30:00 ORDER BY StartTime Thanks, Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (OT) Access SQL Statement
Comparing dates is a pain in the *%% as I'm sure you've found. Try formatting the dates as ODBCDateTimeFormat() inside the SQL statement. If you can't set the date with that function, the database isn't going to read it correctly either. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Skyward Internet Technology [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:05 PM To: CF-Talk Subject: Re: (OT) Access SQL Statement A dump of the PriSched table reveals that STime and ETime look like such: 1899-12-30 06:00:00 1899-12-30 07:00:00 1899-12-30 07:00:00 1899-12-30 11:00:00 So, what does the following query not work? SELECT STime, ETime, Name, Describe FROM PriSched WHERE ((NOT STime BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 18:30:00) OR (ETime BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 18:30:00)) AND ((NOT STime BETWEEN 1899-12-30 21:00:00 AND 1899-12-30 00:00:00) OR (ETime BETWEEN 1899-12-30 21:00:00 AND 1899-12-30 00:00:00)) ORDER BY STime, ETime It throws the following error. I've matched the datatypes in the SQL. [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '((NOT STime BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 18:30:00) OR (ETime BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 18:30:00)) AND ((NOT STime BETWEEN 1899-12-30 21:00'. Thanks, Dave - Original Message - From: Mark Warrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 20, 2001 12:38 PM Subject: RE: (OT) Access SQL Statement = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = With Access and SQL, you put the NOT before an otherwise true condition. WHERE NOT StartTime BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 18:30:00 ---mark -Original Message- From: Skyward Internet Technology [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 9:52 AM To: CF-Talk Subject: (OT) Access SQL Statement I'm used to Oracle, so I always choke on Access stuff . . . How do you do a NOT BETWEEN in Access? (Note: StartTime is a Date/Time Field) EX: SELECT StartTime FROM myTalbe WHERE StartTime NOT BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 18:30:00 ORDER BY StartTime Thanks, Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cross-posting: data type mismatch
IN SQL, the INT datatype supports numbers up to: 2,147,483,647 and -
2,147,483,647
Your number exceeds the maximum allowable limit for that datatype:
12,222,333,444,545,456
In SQL, you would use the field type to BINARY and set the field
length to
whatever you think the max number of numbers could be. In MS Access,
you
would set the field type to Number, with the attribute of Double.
When you output the number with CF, be sure to use the NumberFormat
mask (or
a similar mask), otherwise the number would appear as follows:
1.3334445455E+16
---mark
=
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 3:25 AM
To: CF-Talk
Subject: cross-posting: data type mismatch
Hi guys,
Brain drain going on here. I am getting this error message with a
simple
query:
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
criteria
expression.
SQL = INSERT INTO tbl_test (testname, testnumber) VALUES ('will',
1333444545456)
Data Source = dsntest
This is the code:
cfquery datasource=liquidid-payments name=addtest
INSERT INTO tbl_test
(testname, testnumber)
VALUES ('#Form.testname#', #Form.testnumber#)
/cfquery
And the Access2000 db is set up as follows:
testname is a VARCHAR 510
testnumber is a INTEGER 4
I must have done hundreds of these kind of queries. They ALWAYS work,
at
least I'm sure they do. I've tried putting '' around the value for
testnumber but then get an
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range
(null)
Any ideas people??
Will Swain
Hot Horse Ltd
http://www.hothorse.com
e: [EMAIL PROTECTED]
t: 01273 675375
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
test - please ignore
This is a test. Please ignore. = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: F***edcompany.com report
Well I see that as a bummer for the employees, but as a very good decision for Macromedia. Allaire should have stuck with their core competency (ColdFusion) 2 years ago. By the way, I think it's F***ed that we have to pay for the F***edcompany.com now. The fees are pretty steep for the average joe. I imagine those monthly fees would be no big deal for large companies though. It's all valuable information. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 12:35 PM To: CF-Talk Subject: SOT: F***edcompany.com report Rumor has it Macromedia is gonna start laying people off (up to 250 people) starting this week. They're doing it quietly in small groups over the next few weeks so that they don't have to issue a press release. Apparently the people being hit the hardest are employees that were acquired when Macromedia bought Allaire. They've already stopped development on the (Allaire) Spectra product line and now they are doing the same to Allaire's JRun. doh ... JRun is going away? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Counting Sessions
Well it's actually an approximation. What you can do is once a user hits the site, record the CFID and CFTOKEN or whatever other persistent var you want to use to a database along with the current date and time. And upon each subsequent page views, update the database. At the same time you would poll the DB to see how many users have hit the site within a time frame like oh say, one minute. Simple. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 11:41 AM To: CF-Talk Subject: Counting Sessions How does a web site know that there are 26 users on our site right now... oh, wait, now 27?? Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Counting Sessions
Dylan, I learn something everyday. Thanks. Is there a specific function in CF which will display those counts on the WinNT platform? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 11:54 AM To: CF-Talk Subject: RE: Counting Sessions the specifics depend on the OS, but generally speaking, the web server's open threads/processes are counted. -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 11:41 AM To: CF-Talk Subject: Counting Sessions How does a web site know that there are 26 users on our site right now... oh, wait, now 27?? Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Lists
Before we get into a long discussion about how to compare two lists, why are you inserting multiple values of the same type into a single field vs. having a lookup table? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: David Clay [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 2:40 PM To: CF-Talk Subject: Lists I have more than 1 value in a table field (values=test1,test2) How can I query those to match one of those values with a value of another table? Thank you fro your help. Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 303.770.8506 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FileMaker and Cold Fusion
When you say consistency, could you be a bit more specific? According to the documentation, FileMaker Pro DB's are supported. Perhaps you could show us the error code that's coming up to help us help you diagnose the problem. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Malcolm Taylor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 10:18 PM To: CF-Talk Subject: FileMaker and Cold Fusion We're having consistency problems using the FileMaker ODBC driver to allow ColdFusion 4.5.1 to insert records into a FileMaker database and I'm wondering if anyone on the list has experience with this sort of datasource. When I talked to FileMaker's technical support, they told me that they hadn't tested their ODBC driver with ColdFusion and that they therefore wouldn't be able to help further. Any advice would be greatly appreciated. Thanks, Malcolm Taylor ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Simple Database Structure Question, Flat or Relational?
That's proper database design, but don't you think you're pushing it a bit? I mean, there are only so many years and year numbers never change. I think it would be just as appropriate to just use the 4-digit year in the lookup (BrandYearModel) table, and would doing that speed up the queries a little bit. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 10:13 AM To: CF-Talk Subject: Re: Simple Database Structure Question, Flat or Relational? I think I will set it up this way: These tables are no-brainers: Brand (BrandID, otherbrandinfo) Year (YearID, year) Model (ModelID, othermodelinfo) The intersection tables can get a little confusing. I would set it up this way, with one Intersection table: BrandYearModel (BrandID, YearID, ModelID) Given the brand, you can get the years. Given the brand and year you can get the models. At 07:23 AM 06/26/2001 -0400, you wrote: Hello cf-talk, I need to design a product compatability guide for a client. I'm looking for the best database setup. 1. We need a drill down feature for product brand, product year, and product model. A user will first choose the Brand, then the year, then the model. 2. I'll use cfselect to make the drop down boxes that will populate based on the previous selection. Choose a brand, then the years available will show in a CFSELECT on the following page, then models on the next page ect. So, I have a relational database one to many for Models to Brands respectively, but what would be the best way to add in model year. Do I add a new table just for model years, and have that many to one with Brands, and have models be many to one with year? Or, just have the year as another field in the Model table? Any advice here to save me from stumbling through the above options to see what works best would be very much appreciated. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: oracle long table corrupts itself... ideas?
Interesting. This is another good argument for using a key table guys. Anyway, run the Oracle stored procedure to generate a number, then check for the existence of that number in the primary key field in the table you want to insert into. If the number exists, generate another number and repeat the loop infinitely until you get an open key. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 12:10 PM To: CF-Talk Subject: oracle long table corrupts itself... ideas? (Diagnostic Data: using Oracle 8i, ColdFusion 4.51 SP2, Oracle native drivers) I have a table where I store user session information. At some point over time, the index corrupts itself and i begin to get foreign key constraints because it'll attempt to insert a row using a key ID that has already been used. Ironically, it is also the only table in the database that includes a field of the data type long. Is that just a coincidence or could there be a correlation? If not, what else could be corrupting my index? or is it something other than my index? any help is greatly appreciated! -mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Drop-down menu and redirect based on selection
First of all, don't use CFFORM. In fact, NEVER use CFFORM. Roll your own JavaScripts for validation instead. Second, use the following code for your nav form: form action=redirect.cfm method=post onChange select name=theurl onChange=document.forms[0].submit() option value=http://www.fusioneers.com;Fusioneers.com option value=http://www.warrick.net;Mark's Personal Site option value=http://www.houseoffusion.com;House of Fusion /select input type=submit value=Go! /form And last, make sure you've got backup code just in case the user doesn't have JavaScript turned on: ---redirect.cfm--- cflocation url=#form.theurl# addtoken=no ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 12:18 PM To: CF-Talk Subject: RE: Drop-down menu and redirect based on selection Hi, I have the following dropdown menu. I would like to be able to redirect to a new page based on one of the selections below. I'm not sure of the proper syntax. CFFORM ACTION=index.cfm METHOD=GET ENABLECAB=Yes NAME=form2 nbsp;nbsp; SELECT NAME=md SIZE=1 CLASS=dirlinks onChange=parent.location='http://url' option value=url selectedhttp://url1/option option value=urlhttp://url2/option option value=urlhttp://url3/option option value=urlhttp://url4/option option value=urlhttp://url5/option /select /CFFORM ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Drop-down menu and redirect based on selection
No, you've thought it out thoroughly. We just differ on opinions is all. As you pointed out, the parameters of CFFORM are very limited. The issue about validation on the backend is a totally separate issue and I agree with you 100%. The reason I say you shouldn't use CFFORM is twofold: the inherent limitations and the fact that if you never write your own JavaScript validation scripts, you'll never truly understand what's going on when problems arise. It's kind of like using a WYSIWYG editor to create your site. Sure you can do it, but in doing so you loose control of the code. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:31 PM To: CF-Talk Subject: Re: Drop-down menu and redirect based on selection | First of all, don't use CFFORM. In fact, NEVER use CFFORM. Roll your own | JavaScripts for validation instead. Why not? For _simple_ validation, it's quick, it's easy, and it does the job. Besides, when you combine it with CF validation and then database validation on top of that, it's not quite as critical that the JS gets it 100% all the time. Besides, what if some wiseguy makes a copy of your form, alters the JS and then submits it to your site. At that point, it's the CF and database validation that really matter. Now, I know there are ways to prevent something like that from happening, but my point is, to me, JS is just a nice thing I do for the users to save them some time. I don't rely on it for any type of serious data validation/formatting. So, for me, the default stuff in cfform works just fine, unless I need the data stored in some format other than the CF_javascript will accept. Is there something I am not thinking about that I should be? Todd - Original Message - From: Mark Warrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 3:55 PM Subject: RE: Drop-down menu and redirect based on selection | First of all, don't use CFFORM. In fact, NEVER use CFFORM. Roll your own | JavaScripts for validation instead. | | Second, use the following code for your nav form: | | form action=redirect.cfm method=post onChange | select name=theurl onChange=document.forms[0].submit() | option value=http://www.fusioneers.com;Fusioneers.com | option value=http://www.warrick.net;Mark's Personal Site | option value=http://www.houseoffusion.com;House of Fusion | /select | input type=submit value=Go! | /form | | And last, make sure you've got backup code just in case the user doesn't | have JavaScript turned on: | | ---redirect.cfm--- | cflocation url=#form.theurl# addtoken=no | | ---mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Simple Database Structure Question, Flat or Relational?
Nope, I'm suggesting the same thing as Jeff Houser suggested with one
exception. Instead using a lookup table for years, I suggest just using a
column labled ModelYear and using the 4-digit year. Additionally, I would
format that field as a Date/Time field rather than a numerical or text field
so that you can perform proper Date calculations use proper Between search
limiters.
Lookup Tales:
Brand (BrandID, otherbrandinfo)
Model (ModelID, othermodelinfo)
Intersection table:
BrandYearModel (BrandID {INT, fk brand.brandid}, YearID {date/time}, ModelID
{INT, fk model.modelid})
---mark
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 2:11 PM
To: CF-Talk
Subject: Re: Simple Database Structure Question, Flat or Relational?
Mark, are you suggesting one flat table?
Jeff Fongemie
Mark Warrick [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
That's proper database design, but don't you think you're
pushing it a bit?
I mean, there are only so many years and year numbers never
change. I think
it would be just as appropriate to just use the 4-digit year in
the lookup
(BrandYearModel) table, and would doing that speed up the
queries a little
bit.
---mark
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 10:13 AM
To: CF-Talk
Subject: Re: Simple Database Structure Question, Flat or Relational?
I think I will set it up this way:
These tables are no-brainers:
Brand (BrandID, otherbrandinfo)
Year (YearID, year)
Model (ModelID, othermodelinfo)
The intersection tables can get a little confusing. I would set
it up this
way, with one Intersection table:
BrandYearModel (BrandID, YearID, ModelID)
Given the brand, you can get the years. Given the brand and
year you can
get the models.
At 07:23 AM 06/26/2001 -0400, you wrote:
Hello cf-talk,
I need to design a product compatability guide for a client. I'm
looking for the best database setup.
1. We need a drill down feature for product brand,
product year, and
product model. A user will first choose the Brand, then the year,
then the model.
2. I'll use cfselect to make the drop down boxes that
will populate based on the previous selection. Choose a
brand, then
the years available will show in a CFSELECT on the following page,
then models on the next page ect.
So, I have a relational database one to many for Models to Brands
respectively, but what would be the best way to add in model year.
Do I add a new table just for model years, and have that
many to one
with Brands, and have models be many to one with year?
Or, just have the year as another field in the Model table?
Any advice here to save me from stumbling through the above
options to see
what works best would be very much appreciated.
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
Internet Guns For Hire
(603) 356-0768
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 Move data
The simplest way would be to use the import or export features of SQL server to connect the two servers together and transfer the database. Although, if that's not an option, you could also try backing up the SQL database and restoring it on the other server or you can export the SQL database to Access, import it to the other SQL server, and reset all the constraints manually. There's many other ways to do it as well. Perhaps if you could explain the situation more clearly, we could provide you with a solution that best fits your needs. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 10:34 AM To: CF-Talk Subject: SQL2000 Move data I need to move an entire data base from one SQL Server to anouther with ftp or zipdisk/cdrom. How is this done Thanks Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: making list update dynamic
Can we see the database schema? Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 9:03 AM To: CF-Talk Subject: making list update dynamic I have made some pages that display in columns and are updatable. There are actually over 50 entries they can make which are split between several pages. To update just the page the user is editing I have hardcoded the point on the list that should be updated. Well if all stayed exactly the same this would be fine. However, I need to make this more robust. 1. I will be having 4 different user groups that will need to update only their information. Each group has a different amount of entries to update. So for each group I currently would have to do a separate set of hardcoded if/else statements. 2. It is set up that if there is a change in one section it throws all my index(skilloffset) numbers off. They need to be able to add/subtract change what they want to be updated. So basically I want to take the attached code and make it dynamic. The CourseID is used by all groups. That is the one part that is used universally-it's the subgroups of this courseid that is unique to each group. (ie: each have reading as a course- but the reading skills are differnt for each of my four groups). So I'd like to make it something like CFIF CourseID=1 CFSET SkillOffset=#skilloffset# /CFIF I keep getting when I try to make it dynamic-indexes must always start with 1... Any ideas? Thanks, j !---Sets up SkillOffset. SkillOffset will set where in the list the update should occur. This will depend on which course they are updating.--- CFPARAM NAME=SkillOffset Default= CFIF CourseID IS 1 or CourseID IS 2 CFSET SkillOffset=0 CFELSEIF CourseID IS 3 or CourseID IS 4 CFSET SkillOffset=14 CFELSEIF CourseID IS 5 or CourseID IS 6 or CourseID IS 7 CFSET SkillOffset=25 CFELSEIF CourseID IS 8 CFSET SkillOffset=39 CFELSEIF CourseID IS 9 CFSET SkillOffset=47 /CFIF !---Query loop to perfomr the update on the Grades table--- CFLOOP INDEX=X FROM=1 TO=#ListLen(GradeforSubject)# CFQUERY NAME=EditGrades DATASOURCE=#Request.maindsn# UPDATE Grades SET GradeForSubject='#ListGetAt(attributes.GradeForSubject,X)#' WHERE PERMNUM='#CLIENT.PERMNUM#' and SkillID=#Evaluate(X + SkillOffset)# /CFQUERY /CFLOOP -- -- -- !---In case you need it this is from my display page TABLE border CFOUTPUT query=Subjects group=SkillID TR TD colspan=2#Skill#/TD CFOUTPUT TDnbsp;nbsp; CFIF Val(GetSubjects.GradeForSubject)#GradeForSubject# CFELSE INPUT type=Hidden name=GradesID value=#GetSubjects.GradesID# INPUT name=GradeForSubject value=#UCase(GradeForSubject)# size=5 /CFIF /TD CFSET CourseID=GetSubjects.CourseID CFSET PERMNUM=GetSubjects.PERMNUM INPUT type=HIDDEN name=CLIENT.PERMNUM value=#CLIENT.PERMNUM# /CFOUTPUT /TR /CFOUTPUT /TABLE ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL question
H Try this: Select * from products where hidden = 1 AND DIM = 200 AND (COLOR1 = 'gold' OR COLOR2 = 'gold') AND WKSTN = 2 Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 10:33 AM To: CF-Talk Subject: SQL question Im wondering why this SQL statement would bring up results where DIM is greater then 200? I think it has something to do with the OR statement, but i dont know why. Select * from products where hidden = 1 AND DIM = 200 AND COLOR1 = 'gold' OR COLOR2 = 'gold' AND WKSTN = 2 Here is my Output: ProductID : 3 Dim : 600 Color1 : blue Color2 : gold WKSTN : 4 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: double action form
Use a local CFML template to process the local DB write and then CFLOCATION with all the attributes the remote server needs. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Jay E Wigginton [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 3:08 PM To: CF-Talk Subject: double action form I was wondering if there is a means to have a form when submitted perform two functions... I have a form that allows people to subscribe to an electronic newsletter... the form is located on my web site and the form's action statement is a URL to an outsourced company's web site... what I want to do is record the form input locally into a CSV file as well... any suggestions on how to accomplish this with a single form and click. thanks Jay ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server query
You've got a semi-colon at the end of your SQL statement. Although this would work fine in the SQL Query tool, within a CFQUERY it will not. Also, you don't need to specify the entire object path to the table, just the tablename itself. This has nothing to do with the error you got; it's just an FYI. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 10:34 AM To: CF-Talk Subject: SQL Server query I'm having difficulty getting a test template to work after setting up MSDE and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so it may be something obvious... I get this error: - CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY)... - The error comes from this very simple template: CFQUERY NAME=test DATASOURCE=my_SQLServerDb USERNAME=my_username PASSWORD=my_password SELECT * FROM my_SQLServerDb.dbo.WebPages; /CFQUERY Don't know if it could be a permissions error. I'm still coming up to speed with how they work in SQL Server. I do have the ODBC datasource for this db set up with the username and password shown in the query, and I've set Object Permissions for the WebPages table to include the use of SELECT for this username ... Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Files Explorer !!
Hamid, Open up the /cfide/administrator/filedialog/index.cfm file. This will show you exactly how you can create an applet tree similar to the windows explorer. Of course, you'll need the decrypter. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 3:32 AM To: CF-Talk Subject: Files Explorer !! Hi All, I want to make Files Explorer showing me directories and files of a specified directory. I don't know if it is available for coldfusion to offer Full-Directory structure with all sub-directories. any suggestions, Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: STRONG REFRESH PROBLEM
The simplest way to prevent proxies from caching your pages is to appened a random number the end of each query string (URL) in the website. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 4:39 AM To: CF-Talk Subject: OT: STRONG REFRESH PROBLEM I'm having a weird problem with my site and local ISP: I update pages frequently on our www.imvamp.com page, but somehow new pages are not retrieved immediatly by our local users who use ISP1!! ISP2 local users and all other people from abroad can view the new pages just fine. ISP1 takes some time to serve the new pages, as if some proxy server is giving the old pages for the next 12-24 hours and updating it's records only after a day! is there a way to eliminate this caching? will specifiyng a no-cache/refresh tag in the server's html will help? will the ISP1 proxy server even consider this tag when it retrieves pages? Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. I don't live in fantasy; I just work there... http://www.imvamp.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server query
Interesting. My opinion on the matter is don't fix something that isn't broken. Your first query, where you name the columns, is actually better anyway. SELECT * should be avoided whenever possible. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 1:59 PM To: CF-Talk Subject: RE: SQL Server query I've discovered the CFQUERY actually works fine if the SQL is like this: SELECT field1, field2 FROM Table (with or without the semi-colon) but it fails on: SELECT * FROM Table Could this be an MDAC version issue? When I installed Ent Mgr, it apparently installed MDAC 6, according to the results of Component Checker. If it's MDAC-related, how tricky is it to go back to MDAC 2.1 SP2? Gene Kraybill On 20 Jun 2001, at 9:05, Mark Warrick wrote: You've got a semi-colon at the end of your SQL statement. Although this would work fine in the SQL Query tool, within a CFQUERY it will not. Also, you don't need to specify the entire object path to the table, just the tablename itself. This has nothing to do with the error you got; it's just an FYI. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 10:34 AM To: CF-Talk Subject: SQL Server query I'm having difficulty getting a test template to work after setting up MSDE and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so it may be something obvious... I get this error: - CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY)... - The error comes from this very simple template: CFQUERY NAME=test DATASOURCE=my_SQLServerDb USERNAME=my_username PASSWORD=my_password SELECT * FROM my_SQLServerDb.dbo.WebPages; /CFQUERY Don't know if it could be a permissions error. I'm still coming up to speed with how they work in SQL Server. I do have the ODBC datasource for this db set up with the username and password shown in the query, and I've set Object Permissions for the WebPages table to include the use of SELECT for this username ... Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Desperate for Hosting
Cheap hosting with 24-hour access to tech support? Hm How cheap is cheap in your mind? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 10:13 AM To: CF-Talk Subject: Desperate for Hosting Ok, I desperately need a cheap and reliable 24 hour support service, hosting! if anybody could suggest where i can look it would be of great help! I've checked out a lot of what's on the net, but i'd like some personlized views/experince! Thanks! = Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Desperate for Hosting
That's a pretty good deal, but did you read the fine print? ABI Hosting's technical support services are limited to hosting, server, network, and domain issues. and Requests for services not included in your account is subject to an hourly charge of $45. On the service prices page you'll notice that they charge a 1/2 minimum for all tech support calls. Those charges could add up pretty fast. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Kevin Merker [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 8:39 AM To: CF-Talk Subject: Re: Desperate for Hosting ABI Hosting 100 mail accounts Complete CF hosting w/Access $19.95 mo. SQL 7 is more http://www.abihosting.com - Original Message - From: Mark Warrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 18, 2001 8:49 AM Subject: RE: Desperate for Hosting Cheap hosting with 24-hour access to tech support? Hm How cheap is cheap in your mind? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 10:13 AM To: CF-Talk Subject: Desperate for Hosting Ok, I desperately need a cheap and reliable 24 hour support service, hosting! if anybody could suggest where i can look it would be of great help! I've checked out a lot of what's on the net, but i'd like some personlized views/experince! Thanks! = Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
dynamic var names
Does anyone know how to set dynamic variable names? Here's the situation. For each product in a shopping cart, I need to pull up the applicable shipping options and shipping charges and then create a number of vars which I'll use to increment the total shipping charge for the whole order for all items and all possible shipping methods. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic var names
Yes - my provider's DNS servers are lightning fast.
OK - this solves one problem, but not the 2nd part of the problem which is
that I need to increment the shipping costs.
I loop through a list of product ids first.
While in the loop, I do a lookup to the shipping options lookup table for
the product in the current step of the loop. The result is between 1 and 5
or so different shipping options (costs).
Then the loop continues to the next product.
So basically what I need to do is this
Check for the existence of shipping_cost#currentrow#.
If the var exists, increment it with the current shipping cost for the
current product. Otherwise set the var with the current shipping cost.
At the end, I should have a certain number of vars based upon the available
shipping methods.
Does that make sense?
---mark
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 10:29 AM
To: [EMAIL PROTECTED]
Subject: Re: dynamic var names
Looks like your one of the few with good DNS.
Oh, and you can do this:
CFSET variable#id# = 5
OR
CFSET SetVariable('variable'id, 5)
- Original Message -
From: Mark Warrick [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, June 18, 2001 1:23 PM
Subject: dynamic var names
Does anyone know how to set dynamic variable names?
Here's the situation.
For each product in a shopping cart, I need to pull up the applicable
shipping options and shipping charges and then create a number of vars
which
I'll use to increment the total shipping charge for the whole order for
all
items and all possible shipping methods.
---mark
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Repairing an Outlook PST file
OK guys I'm really sorry but I don't know where else to turn for advice on this one.. Outlook is acting up on me. My PST file is only about 270 MB. What's happening is that Outlook is locking up on me and I can hear the hard drive making funny noises while it apparently tries to read or write to the file. This is only happening with Outlook and the drive isn't very old so I doubt anything else could be causing the problem. This may very well be the last message I send out of Outlook today as a result of the problem. I'm crossing my fingers. Does anyone know how to repair the PST file? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager connection to SQL Server
The SQL Enterprise Manager will default to port 1433, so unless you changed it, I wouldn't worry about that. Try re-establishing the connection with the Client Network Utility. Also, try using a different authentication routine. For example, login to Win98 as the username/password combo you would use to connect to the SQL server and then try using trusted connection instead of SQL authentication. If all else fails, call the ISP and have them walk you through it. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 11:14 AM To: CF-Talk Subject: Enterprise Manager connection to SQL Server Newcomer to SQL Server... I'm attempting to use Enterprise Manager to connect via an ISP to a SQL Server 2000 db on a shared host. I was successful in doing that on Friday, but after installing MSDE on my Win98 dev laptop, the connection always failed (Server does not exist or access denied). I've uninstalled MSDE and reinstalled Enterprise Mgr, still to no avail. I CAN successfully ping the db, and I've confirmed that the Client Network Utility is set up to use TCP/IP as the protocol. My hosting service says I should confirm that I can use Port 1433, but I'm unsure how to do that or how to further diagnose what's happening. Any help appreciated! Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coding Standards.....
I've adopted it as the standard for development. I hire only developers who follow that standard. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: Richard Kuryk [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 6:43 AM To: CF-Talk Subject: Coding Standards. I was wondering what people think about setting up fusebox as a development standard that everyone has to follow? I agree there should be standards such as naming standards, variable naming conventions, commenting style standards, coding style standards ( indents ) etc... Also since CF 5.0 is now out and you can have user defined functions and libraries of functions, how does this impact fusebox? What kind of standards does your employer have in place? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCONTENT Strikes Again...Viewing a file
Uhm try renaming the document field to something else. That might be a reserved word. Also, use real HTML, not CFFORM. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 6:34 AM To: CF-Talk Subject: CFCONTENT Strikes Again...Viewing a file I have a three button form that gives a user the option to view, replace or delete a file. The latter two work just fine, but viewing the file is giving me an error and I am not sure why. It opens MSWORD and displays an error that it can't resolve the form variable. All the code looks right, but I am not I am not perfect. Any input would be appreciated. Thanks in advance. Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #form.document# IS View Error near line 14, column 22. Error resolving parameter FORM.DOCUMENT The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (CFIF), occupying document position (14:1) to (14:32). Date/Time: 06/14/2001 09:27:09 AM Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; Hotbar 2.0) Remote Address: 127.0.0.1 Query String: id=1 FORM FILE (response2.cfm) cfform name=documents action=doc_action.cfm?id=#Trim(newdoc.id)# method=POST input type=Submit name=document value=View input type=Submit name=document value=Replace input type=Submit name=document value=Detach /cfform ACTION FILE (doc_action.cfm) cfquery name=Get datasource=lsarprod select * from lsardba.tbl_response where id = '#url.id#' /cfquery cfquery name=Submissions datasource=lsarprod select * from lsardba.tbl_cases, lsardba.tbl_users where lsardba.tbl_users.fullname = lsardba.tbl_cases.assigned and lid = '#url.id#' /cfquery cfif #form.document# IS View cfinclude template=view_doc.cfm cfelseif #form.document# IS Replace cfinclude template=upload2.cfm cfelseif #form.document# IS Detach cfquery name=Delete_Doc datasource=lsarprod delete from lsardba.tbl_response where id = '#url.id#' /cfquery font face=Arial size=2strongDocument cfoutput#Trim(get.document)#/cfoutput for Case number cfoutput#Trim(get.id)#/cfoutput has been removed./strong/font br br font face=Arial size=2 cfoutput a href=response.cfm?lid=#Trim(get.id)#user=#UrlEncodedFormat(Trim( submissions.username))#strongReturn/strong/a /cfoutput /font /cfif VIEW_DOC.CFM cfquery name=Get datasource=lsarprod select * from lsardba.tbl_response where id = '#url.id#' /cfquery cfcontent type=application/msword file=C:\Inetpub\wwwroot\Intranet-Secure\lsar_db2\responses\#Trim( get.document)# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
