RE: access iif count
Power to the sub queries! FOR SQL Server: SELECT (SELECT Count(*) FROM Survey WHERE success=1) as SuccessYes, (SELECT Count(*) FROM Survey WHERE success=0) as SuccessNo, (SELECT Count(*) FROM Survey WHERE OtherFlag=32) as CountThirtyTwos For Oracle, same thing but you add 'FROM dual' at the end: Access should work as SQL server but I have not tried months ago. Jaime/ -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 11:17 AM To: CF-Talk Subject: access iif count Hi folks, I'm trying to use IIF in a query to count a bunch of yes/no values. Here's what I'm trying that doesn't work (both count the total rows): cfquery name="countyesnos" datasource="#dsn#" SELECT COUNT(IIF (success = 1, 1, 0)) as successyes, COUNT(iif (success = 0, 1, 0)) as successno FROM survey/cfquery I know I could do this: SELECT COUNT(success) as successyes FROM survey WHERE success = 1 to get the right answer, but I want to be able to do it for several yes/no fields all in one query. I know I'm just putting something in the wrong place or something. Help? Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Encrypting a credit card field...
Also, when you use Encrypt() it will convert to binary format. Therefore, before storing in a non-binary compatible field or database you need to convert the encrypted string to base64 via ToBase64(). After extracting the information from the database for decryption use ToBinary(), then ToString(), then Decrypt(). This is required because ToBinary() is needed to convert back from base64, but, Decrypt() takes a string as its first argument so you need to convert the binary string to a string string ;), then Decrypt(). Whew, did you get all of that? Here are examples: Encrypt() - #ToBase64(Encrypt(FORM.CC_Number, "#APPLICATION.str_Key#"))# Decrypt() - #Decrypt(ToString(ToBinary(qry_GetUserInfo.CC_Number)), "#APPLICATION.str_Key#")# Justin MacCarthy - Original Message - From: "Mark W. Breneman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 3:46 PM Subject: Encrypting a credit card field... Good day, I am looking for a solution for encrypting a credit card field with CF 4.5 and SQL 7. I know about CFX_PGP. It sounds like just what I need but I would like to know if there are other solutions. Does any one know of any other encryption custom tag or of a stored proc for SQL 7 that will encrypt a field with a fair amount of security? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Great Writeup on Autobytel.com - Way to go Doug!
Thanks Dave!!! --Doug -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 7:50 AM To: CF-Talk Subject: Great Writeup on Autobytel.com - Way to go Doug! This is a multi-part message in MIME format. --=_NextPart_000_0005_01C02870.9DA701F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit As most of us know, Autobytel.com is CF backend. Doug contributes a lot to the list. Congrats Doug! http://www.andovernews.com/cgi-bin/news_story.pl?308300/topstories Dave --=_NextPart_000_0005_01C02870.9DA701F0 Content-Type: application/octet-stream; name="The Andover News Network.url" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="The Andover News Network.url" [DEFAULT] BASEURL=http://www.andovernews.com/cgi-bin/news_story.pl?308300/topstories [InternetShortcut] URL=http://www.andovernews.com/cgi-bin/news_story.pl?308300/topstories Modified=A06005DD9128C0015C --=_NextPart_000_0005_01C02870.9DA701F0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: performance white papers
The real question here wasn't whether CFMAIL was the best tag written, but rather that it's the easiest to explain to a layman-level customer. Show them the code example provided below then show them the CFMAIL equivalent of your example. Very quickly the customer can see that it's going to be easier and faster to code their application, easier to maintain (perhaps even on their own) yet provides all the functionality of other programs. If you're not a CFMAIL fan, use CFQUERY... the point is the same... simplicity in coding makes for faster coding. --Doug -Original Message- From: Heath Lord [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 7:47 AM To: CF-Talk Subject: RE: performance white papers I beg to differ. Using the CFMAILPARAM in 4.5, you can send multiple attachments and custom header information. cfmail to="" from="" subject="" cfmailparam name="header-name" value="header-value" /cfmail Heath -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 10:46 AM To: CF-Talk Subject: RE: performance white papers For the uninitiated, how (roughly) do you send email with ASP? I don't use it so I don't know, but I am often asked why a client should fork out for CF when they can have ASP.. seems like a good example. Something like this, with the excellent (and free) JMail component by dimac.com: Set JMail = Server.CreateObject("JMail.SMTPMail") JMail.ServerAddress = SMTPServer JMail.Sender = WelcomeMessageSender JMail.Subject = WelcomeMessageSubject JMail.Body = WelcomeMessageBody JMail.AddRecipient EmailAddr JMail.Execute Set JMail = nothing Not that tough, was it? And the bonus is that JMail, like most real popular COM objects, has roughly 30 or so methods you can call on to do advanced stuff that's impossible or impractical with CFMail, like error trapping, custom headers, multiple attachments, etc. -ron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Encrypting a credit card field...
For some reason I just though of this, but I want to make sure ecommerce people know about this, so: Here's general tip for everyone who does ecommerce... You should use input type="text" autocomplete="off" for form fields that are used for credit card numbers, or other sensitive data. With this option turned on MSIE's autocomplete will remember everything you type into forms, and that data is stored un-encrypted on the client's computer. __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM / NETDesign Inc. ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 1:18 PM To: CF-Talk Subject: Re: Encrypting a credit card field... There is a cfx_blowfish somewhere , good security less cpu overhead than PGP or you chould role your own For BlowFish www.counterpane.com and directly http://www.ejim.co.uk/module/encrypt/index.cfm Justin MacCarthy - Original Message - From: "Mark W. Breneman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 3:46 PM Subject: Encrypting a credit card field... Good day, I am looking for a solution for encrypting a credit card field with CF 4.5 and SQL 7. I know about CFX_PGP. It sounds like just what I need but I would like to know if there are other solutions. Does any one know of any other encryption custom tag or of a stored proc for SQL 7 that will encrypt a field with a fair amount of security? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Relief from redundancy?
I used to do that, then I started setting some of these "common change items" as variables in the application.cfm. You want to change the background on all pages? One line of code. cfset REQUEST.background = "image.gif" The best part is, because you control how you're using the variable, you don't have to worry about "accidentally" replacing something that belongs. Sharon At 01:00 PM 9/27/2000 -0500, Gavin Myers wrote: I've used Extended Find/Replace quite a bit to run long tedious stuff, like when people say "can you make the background cornflower blue instead of white? because white is so blah, i know that our site spans over 160,000 cfm pages but i'm sure you can do it!" It works for things like that as long as you can find a similarity to replace... otherwise i suggest drinking heavily --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Delay
Use CF_BLOCK from the Tag Gallery. This is the tag's description as written by the author: "This tag simply stops the execution of the current template for the specified number of seconds. No loops or temporary files. Does not consume ANY server resources. It uses only two nested CFLOCKs that form a deadlock for the given time. The page execution stops without any ColdFusion activity during the blocking period" P. -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 2:14 PM To: CF-Talk Subject: RE: Delay why not make a delay w/javascript? SCRIPT LANGUAGE="JavaScript" !-- Hide from old browsers // Copyright © 1999 Doug Popeney // Created by Doug Popeney ([EMAIL PROTECTED]) // JavaScript Made Easy!! - http://www.easyjavascript.com function startTimer(){ var time= new Date(); hours= time.getHours(); mins= time.getMinutes(); secs= time.getSeconds(); closeTime=hours*3600+mins*60+secs; closeTime+=10; Timer(); } function Timer(){ var time= new Date(); hours= time.getHours(); mins= time.getMinutes(); secs= time.getSeconds(); curTime=hours*3600+mins*60+secs if(curTime=closeTime) location = "YOUR REDIRECTING LINK" else timeLeft(); } function timeLeft(){ count = closeTime-curTime; document.timer.counter.value = count + " secs." window.setTimeout("Timer()",1000) } // -- -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 9:52 AM To: CF-Talk Subject: RE: Delay Try using getTickCount: THIS SHOULD CREATE A 2 SECOND TIMER!! CFSET tickBegin = GetTickCount() CFLOOP FROM="1" TO = "1" index = "index" CFSET tickEnd = GetTickCount() CFIF tickEnd - tickBegin IS 2000 CFBREAK OR YOU COULD PUT THE CFLOCATION RIGHT HERE, INSTEAD /CFIF /CFLOOP ~Simon -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 9:07 PM To: CF-Talk Subject: Re: Delay I use a CFLOOP to create a delay. CFLOOP Index="Timer" From="1" to="15000" STEP="1" /cfloop There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, September 25, 2000 9:58 PM Subject: Delay Can anyone help please? I'm trying to set up a delay in page without using a meta tag. I've tried this but it relocates straight way. Do I need to tell it that the values are specifically dates? TIA! !--- Create a 2 second delay --- CFSET Beginning = Now() CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# CFLOOP condition="Difference LT 2" CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# /CFLOOP !--- Relocate to the menu page --- cflocation url="test_id.cfm" addtoken="No" Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
6 hours for the list
It has taken over 6 hours for the list to send messages.. any ideas? Jim Taylor Web Centric Central http://130.13.69.228 [EMAIL PROTECTED] Home Office: 480-496-0712 Cell Phone : 602-576-0508 Fax:: 208-474-8305 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Duplicate emails
up to 7 duplicates of some messages...and it's getting really old! Sorry to bother everyone, but has anyone else been getting lots of duplicate emails from this list? Thanks, Bob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cf sbs
First of all, accept one truth Your server WILL go down at some point, plan accordingly. Also, as far as servers supported, legally unless you buy multiple licenses you can't run multiple small business servers. However the rule that would apply is 1 domain per network, not one server per network. To date, I have never found a way around this one. However you can run multiple sbs servers on a network without a problem. Any specific issues between sbs and CF? Not offhand they do work ok together. Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 09/27 7:49 AM This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_000_01C02892.1A45EB60 Content-Type: multipart/alternative; boundary="_=_NextPart_001_01C02892.1A45EB60" --_=_NextPart_001_01C02892.1A45EB60 Content-Type: text/plain; charset="iso-8859-1" Hi all We have a Small Business Server with around 25 clients. At the moment we have cf server running on a client 98 machine (small intranet and development). We are building a cf intranet application that will run on nt server. Firstly, are there any issues between sbs and cf 4.5.1, this server must not go down. Secondly, I believe that sbs supports only one server per network, is this true and can we get around it. Any pearls of wisdom appreciated. cheers Rich --_=_NextPart_001_01C02892.1A45EB60 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD BODY DIVFONT face=VerdanaFONT size=2HSPAN class=780171009-27092000i all/SPAN/FONT/FONT/DIV DIV DIVFONT face=VerdanaFONT size=2SPAN class=780171009-27092000/SPAN/FONT/FONTnbsp;/DIV DIVFONT face=VerdanaFONT size=2SPAN class=780171009-27092000We have a Small Business Server with around 25 clients. At the moment we have cf server running on a client 98 machine (small intranet and development). We are building a cf intranet application that will run on nt server. /SPAN/FONT/FONT/DIV DIVFONT face=VerdanaFONT size=2SPAN class=780171009-27092000/SPAN/FONT/FONTnbsp;/DIV DIVFONT face=VerdanaFONT size=2SPAN class=780171009-27092000Firstly, are there any issues between sbs and cf 4.5.1, this server must not go down.nbsp;/SPAN/FONT/FONT/DIV DIVFONT face=VerdanaFONT size=2SPAN class=780171009-27092000/SPAN/FONT/FONTnbsp;/DIV DIVFONT face=VerdanaFONT size=2SPAN class=780171009-27092000Secondly, I believe that sbs supports only one server per network, is this true and can we get around it. Any pearls of wisdomnbsp;appreciated./SPAN/FONT/FONT/DIV DIVFONT face=Verdana size=2/FONTnbsp;/DIV DIVFONT face=Verdana size=2SPAN class=780171009-27092000cheers/SPAN/FONT/DIV DIVFONT face=Verdana size=2SPAN class=780171009-27092000/SPAN/FONTnbsp;/DIV DIVFONT face=Verdana size=2SPAN class=780171009-27092000Rich/SPAN/FONT/DIV/DIV DIVFONT face=Verdana size=2/FONTnbsp;/DIV/BODY/HTML --_=_NextPart_001_01C02892.1A45EB60-- --_=_NextPart_000_01C02892.1A45EB60 Content-Type: application/octet-stream; name="Richard Moger (E-mail).vcf" Content-Disposition: attachment; filename="Richard Moger (E-mail).vcf" BEGIN:VCARD VERSION:2.1 N:Moger;Richard FN:Richard Moger (E-mail) ORG:James Villa Holidays Ltd TITLE:IT Manager TEL;WORK;VOICE:+44 (01732) 840846 TEL;CELL;VOICE:+44 (0777) 953 8192 TEL;WORK;FAX:+44 (01732) 872093 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Regents Court=0D=0ALondon Road;Addington;Kent;ME19 5PL;United Kingdom LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Regents Court=0D=0ALondon Road=0D=0AAddington, Kent ME19 5PL=0D=0AUnited Kin= gdom EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:2707T003119Z END:VCARD --_=_NextPart_000_01C02892.1A45EB60-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Progress re ColdFusion SP2
Yesterday I posted on this list and sent to Damon Cooper at Allaire my request that as well as releasing a Server SP2, they release a fixed Studio too. Studio has been a bugbear of mine (and lots of other people too) for ages, and the correspondence between me, Allaire and their Australian Distributor, Firmware Design has been long and continuing. To my astonishment and pleasant surprise, within half an hour of posting my message, I had a response from Damon saying he's passing it to the Studio group, and this was immediately followed by a message from the Studio group, thanking me for my message. They've already done some of the fixes we want, and they should appear in the next version (More specifics below) But no confirmation yet that Allaire will be releasing a new Studio along with the new server. I"ll keep this list posted if anything else happens. The fixes I requested and Allaire's responses are listed here: (1) Resource hog. This is NOT the same as RAM hog. You can add all the ram you like but its the main memory that's the issue here. I'm not sure but I believe that even on a 512MB RAM machine you still only have (I think) 1MB of resources. Allaire sez: We've made quite a bit of progress in alleviating resource usage (since the last public Beta). I won't say its perfect, but this is still an on-going focus with Studio 4.52. (2) Installation file downloaded from Allaire's site and also on the released CD contains invalid DLLs Allaire didn't have a clear idea of the problem, so I have sent them more specific details of what I believe the issue is. (3) The resource tabs once docked don't stay put They attach to the mouse pointer sometimes and sometimes when you open studio they're scattered all over the desktop and have to be rounded up and docked again. ALLAIRE SEZ: There is a new option in the Settings dialog (in the last public Beta) under the General section which allows users to "lock" the resource tabs, and prevent them from being dragged off. (4) Deployment wizard doesnt properly Will only work if you have all the folders created already, and you have to deploy your entire project or it will crash studio and often bring down the whole system with it. I have sent them specifics on this too. Cheers Mike Kear [EMAIL PROTECTED] www.afp.zip.com.au Windsor, NSW, Australia AFP Web Development AFP Electronic Forms AFP Models -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Suppress debug for a single template...
cfsetting enablecfoutputonly="No" showdebugoutput="No" This should do the trick :-) -Original Message- From: Rice, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 4:00 PM To: CF-Talk Subject: Suppress debug for a single template... Isn't there a CF tag or function to suppress debug output just for a single template? I seem to remember seeing something about that one time but can no longer find the information. David L. Rice Web Applications Developer Nation Tax, Inc. [EMAIL PROTECTED] Direct: 205.380.8164 Demo our services @ www.nationtax.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OMG!!!!!
I just got off the phone with a company and they said that that were goning ro change from coldfusion to Asp beause coldfusion does not fit their international language requirments... Does anyone know what they were talking about. I am talking that some major cold coldfusion fusion houses here in phoenix are changing .and have put a coding freeze on for their company.. any one know about this Most likely that annoying lack of full (or any) unicode support. --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Duplicate emails
On 9/27/00, Bob Silverberg penned: Sorry to bother everyone, but has anyone else been getting lots of duplicate emails from this list? Yes. It happens every couple weeks. You'll get used to it. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Access 2000 remote install
Question. Are you just wanting to use Access files? Or do you need the Access GUI? If you just want to run files, then you don't even need Access. Just put the latest MDAC on your server. If you do need the whole shebang, then from the Access disc, you can choose which components you wish to install. Dave - Original Message - From: John Elder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 1:18 PM Subject: Access 2000 remote install Is there a way to install Access 2000 remotely without uploading the entire Office 2000 CD? TIA, John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: super random
CF 4.5 (maybe 4.01 too) offers the UUID for creating even greater unique numbers. Dave - Original Message - From: Gavin Myers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 2:05 PM Subject: super random double question cfset x = Randrange(1, 9) cfset x2 = Randrange(1, 9) cfset y = Randrange(1, 9) cfset y2 = Randrange(1, 9) cfset ran = "#x##x2##y##y2#" Question #1 i figgure the chances of hitting the same number twice is like 1 in 10x32 but as i remember with ye old BASIC programming: In basic you never have a truly random number unless you create a random number unless you randomize timer i'm assuming that this is done automatically with most programming languages 1984 does anyone know how cf gets its random number, does it run it off the timer? what are the chances of hitting the same query the same .01 second of another person? Or does it do more then run of the timer. Question #2 Is the code i'm using above "fine"? Or should I use a different method to get a random number (it can be random numbers and characters or whatever)? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Autonumber?
In Oracle, you have a separate sequencing table, and you reference it to insert your next record number. Dave - Original Message - From: Mark Warrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 12:49 PM Subject: RE: Autonumber? You don't have to, and in fact you shouldn't. Databases do that for you. In Access, use the field type "Autonumber". In SQL, create an INT field, NO NULLS, IDENTITY, IDENTITY SEED (some starting number), IDENTITY INCREMENT (some number increment). With SQL 7.0, this is all very obvious. With 6.5 you may have to do some reading. With Oracle, you would create a stored (shoot what do you call it?) auto-incrementing stored procedure of some sort (help me out here guys - it's been a while). But anyway, you call a stored procedure of some sort with Oracle. That's one difference between that platform and Microsoft's stuff. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 7:44 AM To: CF-Talk Subject: Autonumber? How can I have Cf create a unique order id for each order placed though the store I am building? Thanks, Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Force sessiontimeout??
Hello all, StructDelete may have been a solution in CF4.0 and earlier. Has anyone seen this post by allaire? http://www.allaire.com/handlers/index.cfm?ID=14143Method=FullPageCall=/sup I dont know how you guys are getting structDelete to work with CF4.5. Please read the above documentation by allaire. Maybe its working with CF4.5.1 and SP1, have not tested it yet. Appretiate any help. Thanks Joe - Original Message - From: "Sean Brown" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 11:31 AM Subject: RE: Force sessiontimeout?? that will kill all session on every page request (until the tiimeout is increased) --in effec disabling sessions. If you just want to kill your current session, create a page (killSession.cfm) and put this in it: cfset StructClear(Session) This will delete the session of the user that requests the page. /s -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 9:51 AM To: CF-Talk Subject: Force sessiontimeout?? Hello all, Does the Code below kill the session and destroy the session variables? CFAPPLICATION NAME="TEST" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,0,0,0)#" Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Configuring a Datasource on a Different Server
Be careful using mapped drives, if you should change users some of those things don't stay connected. Also if you reboot the server the mapped drive might not reconnect until you log in. At 04:18 PM 9/27/2000 -0400, you wrote: make the cold fusion application server user accessible and executable... namely the administrator Then go ahead and do a shared folder as an f drive or whatever. put the datasoruces in there. That should do it. Chris Martin - Original Message - From: "Alan Wolf" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 11:06 Subject: Configuring a Datasource on a Different Server Is there a way to configure a datasource on another server other than the one CF is running on? I tried \\servername\sharepoint\database.mdb but the verification failed. The machine is another server in my NT domain. I'm running CF 4.5.1 on NT 4 SP5 and IIS 4. Thanks. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Drill down click menu navigation!
Ok I have burnt my brain enough on this, and can't seem to get the logic right. I know I am close but it doesn't seem to work the way it is supposed to:-) What I am trying to achieve is simple enough, the below array is static at the moment but will be created on the fly later. The idea is that first time use it displays the very top hierarchy as links so you should get. Research Analysis Commentary Product Learning The Team The clicking on any of the links should then decide to do one of two things, if its a link to display another page then go of and display this page. Otherwise it should display the next list of options. Research Australia New Zealand Asia Pacific Analysis Commentary Product Learning The Team I think you get the general idea, now this is a custom tag that is passed a variable from the url, which is something like 1-1-2. This is then used to be able to say this is top position 1, child 1 or position 1 and child 2 of child 1. The code for the custom tag is listed below, can anyone see what I am trying to achieve where I am going wrong and correct it if need be. For the life of me I can't seem to function to figure this out and it really is driving me round the bend. maybe the Array isn't right or whatever. I just need a helping hand to debug this thing:-) Array: cfscript Example = ArrayNew(1); Example[1] = ArrayNew(1); Example[1][1] = "Research"; Example[1][2] = ArrayNew(1); Example[1][2][1] = "Australia"; Example[1][2][2] = ArrayNew(1); Example[1][2][2][1] = "Morning Update"; Example[1][2][2][2] = "Economic Update"; Example[1][2][2][3] = "Weekly Market Update"; Example[1][2][2][4] = "Markets Update (Monthly)"; Example[1][2][2][5] = "ANZ Economic Outlook"; Example[1][2][2][6] = "ANZ Global Economic Update"; Example[1][2][2][7] = "$A Interest Rate Outlook"; Example[1][2][2][8] = "ANZ Job Advertisments"; Example[1][2][2][9] = "ANZ Rural Outlook"; Example[1][2][2][10] = "ANZ Property Outlook"; Example[1][2][2][11] = "Forecasts"; Example[1][2][3] = "New Zealand"; Example[1][2][4] = "Asia Pacific"; Example[2] = ArrayNew(1); Example[2][1] = "Analysis"; Example[3] = ArrayNew(1); Example[3][1] = "Commentary"; Example[4] = ArrayNew(1); Example[4][1] = "Product"; Example[5] = ArrayNew(1); Example[5][1] = "Learning"; Example[6] = ArrayNew(1); Example[6][1] = "The Team"; /cfscript Code: cfparam name="attributes.array" default="" type="array" cfparam name="attributes.selected" default="" cfparam name="attributes.Level" default=0 type="numeric" cfset Example = attributes.array cfset strArray = attributes.selected cfset nLevel = attributes.Level cfif not IsArray(Example) cfoutputError: more detailed information is needed/cfoutput cfabort /cfif cfparam name="blnMenu" default="0" cfif nLevel lte ListLen(attributes.selected) cfif strArray neq "" cfset blnMenu=ListGetAt(attributes.selected,nLevel,"-") /cfif /cfif cfoutput cfloop index="item" from=1 to="#ArrayLen(Example)#" a href="index.cfm?menu=#item###research"img src="arrow_1e.gif" height="9" width="12" border=0#Example[item][1]#/abr cfif blnMenu eq item cfif nlevel lte ListLen(attributes.selected,"-") cfset NextLevel=nLevel cf_cfs_navDisplay array="#Example[item]#" selected="#menu#" Level="#NextLevel#" /cfif /cfif /cfloop /cfoutput regards Andrew Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 September 2000 06:13 To: CF-Talk Subject: RE: Cheap CF Hosting FOUND If you can live without the usual security issue tags (CFFILE, CFOBJECT, etc) take look at Dantor.com. $10 / month CF 4.0 hosting (basic account -- self service everything through a CF interface) on T3s. Support is about average via email, but they do respond and everything works -- I have two domains on there servers and I'm pretty happy with them. Well... since I'm replying to a large backlog of email today anyway, what the heck I "temporarily" parked intrafoundation.com and fourthfoundation.com with www.paconline.net a year or two ago intending to change over to something more expensive later on. Frankly, for $25 a month they're not all that bad. Occasionally ftp or email is unavailable, but usually only for a few minutes. Course, I only do about 600 to 700mb of traffic a month, and don't do any heavy db on them so... that could be completely different. Mainly I chose them because mainframe.ca was sitting there at the time. And I thought it was cool to share rackspace with the people who made the "money for nothing" video. ;-) --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL
RE: Autonumber?
I want the autonumber id to be displayed as a query on the checkout page for the customer as well. I can't do this if I let the database assign the number. Rich -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 12:50 PM To: CF-Talk Subject: RE: Autonumber? You don't have to, and in fact you shouldn't. Databases do that for you. In Access, use the field type "Autonumber". In SQL, create an INT field, NO NULLS, IDENTITY, IDENTITY SEED (some starting number), IDENTITY INCREMENT (some number increment). With SQL 7.0, this is all very obvious. With 6.5 you may have to do some reading. With Oracle, you would create a stored (shoot what do you call it?) auto-incrementing stored procedure of some sort (help me out here guys - it's been a while). But anyway, you call a stored procedure of some sort with Oracle. That's one difference between that platform and Microsoft's stuff. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 7:44 AM To: CF-Talk Subject: Autonumber? How can I have Cf create a unique order id for each order placed though the store I am building? Thanks, Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Suppress debug for a single template...
Spectra has a "cfa_stripdebugger" tag that apparently "Strips ColdFusion debugging output from the bottom of a page.". Probably not much use - but I did find this: 'Generating debug information for an individual page You can view the parameters and CGI environment variables for an individual application page without turning on the global debug settings in the ColdFusion Administrator. Simply append the parameter "mode=debug" to the end of the URL. www.myserver.com/cfdocs/test.cfm?mode=debug' and also this: 'Generating debug information for an individual query You can view debug information for an individual query by putting the debug attribute into the opening CFQUERY tag: CFQUERY NAME="TestQuery" DATASOURCE="CompanyInfo" debug SELECT * FROM TestTable /CFQUERY When this query runs, it places the debug information into the output page where the query is placed.' Note that I'm using 4.5.1 - it might not apply to earlier versions. Hope this helps! Cheers! Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ICQ: 666275 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: Rice, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 September 2000 6:00 To: CF-Talk Subject: Suppress debug for a single template... Isn't there a CF tag or function to suppress debug output just for a single template? I seem to remember seeing something about that one time but can no longer find the information. David L. Rice Web Applications Developer Nation Tax, Inc. [EMAIL PROTECTED] Direct: 205.380.8164 Demo our services @ www.nationtax.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Any web-based message board software that can do this?
This is a multi-part message in MIME format. --CD01BFD9EB790CB195C41678 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Howdy -- I have been looking for (preferably but not necessarily commercial) web-based message board software that meets certain specific requirements. I have looked at more than 20 packages but still have come up empty-handed. If anybody knows of any packages that can meet these requirements, I'd sure appreciate it if you would clue me in. 1) Supports an essentially unlimited number of forums and users (approximately 250,000 new forums and users will be created each year). 2) Because of (1), pricing must be either a flat (reasonable ;-) fee for unlimited use, or literally no more than a few pennies per forum and/or user. 3) Web-based *and* programmatic interfaces for creating new forums, new users, and assigning permissions for users to access forums and for subscribing users to forums. 4) E-mail notification of a forum's subscribed users that a new message has been posted to the forum; the e-mail must contain a URL that will get a subscribed user *directly* to the new message (after the user's userid/password have been entered), not just to the forum's listing of messages. It is imperative that the e-mail notification *not* contain the actual forum posting. 5) Although this should be transparent to the package, it's an absolute requirement so I'll mention it anyway: all sessions with the web-based message board must be in secure (SSL, https://...) mode. 6) Access to any forum requires user authentication. Default authentication mechanism can be internal, but hooks must be present to allow external user authentication mechanism if desired. 7) There must be hooks to allow external processing every time a message is posted to any forum. 8) Postings can be made to a forum via the web or e-mail. 9) Full audit trail of *all* activity throughout the message board, preferably with audit trail reporting and analysis tools included. 10) Front-end (i.e., design of the web pages seen by the user) must be customizable by the system administrator. Customizability need only apply to the look and feel of the overall site, not necessarily to the individual forum/user. Thanks for any help you can provide! -- Larry Afrin, M.D. Medical University of South Carolina [EMAIL PROTECTED] --CD01BFD9EB790CB195C41678 Content-Type: text/x-vcard; charset=us-ascii; name="afrinl.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Lawrence B. Afrin, M.D. Content-Disposition: attachment; filename="afrinl.vcf" begin:vcard n:Afrin, M.D.;Lawrence tel;fax:843-792-3200 tel;work:843-792-4271 x-mozilla-html:FALSE org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University of South Carolina version:2.1 email;internet:[EMAIL PROTECTED] title:Assistant Professor of Medicine adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 96 Jonathan Lucas Street;Charleston;SC;29425;USA x-mozilla-cpt:;0 fn:Afrin, M.D., Lawrence end:vcard --CD01BFD9EB790CB195C41678-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Was Getting Outlook information - MS Digital Dashboard
Microsoft's "Digital Dashboard" might assist here. Check out the link below for more information. http://www.microsoft.com/solutions/km/DigitalDashboard.htm Cheers! Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ICQ: 666275 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 September 2000 6:36 To: CF-Talk Subject: Re: Getting Outlook information slipstick.com has some relevant information. more to follow. we are going to do the samething here. From: "Claremont, Timothy S" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Getting Outlook information Date: Wed, 27 Sep 2000 13:12:48 -0400 My company uses Microsoft Outlook as the mail client. I am wondering if I can grab information from outlook and put it on my customized intranet home page. For instance, can I put a link in my coldfusion page that calls the user's Outlook calendar and shows it on the page? What about the number of new messages, etc? Basically I want to grab the features of the "Outlook Today" tools in outlook. Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: sql question
I have to wonder why the same Users_ID would be registered for the same class 4 times(a very large person needing 4 seats??) That aside. Add an Identity field for the table. class_registration_ID. Then delete from class_registration where class_registration_ID = theIDnumber - Original Message - From: "Gavin Myers" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 1:58 PM Subject: ot: sql question here's what i'm doing delete from class_registration where users_id='123123' and class_id='4242424' here's what the table looks like name users_id class_id gavin 123123 4242424 gavin 123123 4242424 gavin 123123 4242424 gavin 123123 4242424 what i want to do is delete only 1 of those rows suggestions? thanks, Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Protecting Content / content leeching... A CF method?
on 9/28/00 7:28 AM, Nadir Ait-Laoussine at [EMAIL PROTECTED] wrote: Now, I've been recommended to user CFCONTENT, the problem with CFCONTENT is that it just spews out the content, so a PDF file (even if I specify the mime type) will come not come out as a PDF file, but some garbled text. What MIME type are you using for PDFs? What you describe works perfectly for me. You could also try using CF directory mappings - these will prevent anyone directly accessing the files if you point them outside the Web root directory. Rob Keniger [EMAIL PROTECTED] big bang solutions http://www.bigbang.net.au p +61 7 3311 2733 f +61 7 3311 2744 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Autonumber?
This is a multi-part message in MIME format. --18DED34028AA5599808DB230 Content-Type: multipart/alternative; boundary="642EBD9C7220BF144AD611F4" --642EBD9C7220BF144AD611F4 Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit hmm, there's been lots of UUID vs Identity column emails on this list personally I prefer identity columns If you are using Access, then create a field and set it to 'Autonumber' or if you are using SQL Server, set the column as an identity column. "HappyToad.com" wrote: How do I use UUID? -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 12:31 PM To: CF-Talk Subject: RE: Autonumber? use UUID ~Simon -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 10:44 AM To: CF-Talk Subject: Autonumber? How can I have Cf create a unique order id for each order placed though the store I am building? Thanks, Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --642EBD9C7220BF144AD611F4 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html hmm, there's been lots of UUID vs Identity columnnbsp; emails on this list personally I prefer identity columns pIf you are using Access, then create a field and set it to 'Autonumber'nbsp; or if you are using SQL Server, set the column as an identity column. brnbsp; brnbsp; brnbsp; brnbsp; p"HappyToad.com" wrote: blockquote TYPE=CITEHow do I use UUID? p-Original Message- brFrom: Simon Horwith [a href="mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/a] brSent: Wednesday, September 27, 2000 12:31 PM brTo: CF-Talk brSubject: RE: Autonumber? puse UUID p~Simon p-Original Message- brFrom: HappyToad.com [a href="mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/a] brSent: Wednesday, September 27, 2000 10:44 AM brTo: CF-Talk brSubject: Autonumber? pHow can I have Cf create a unique order id for each order placed though the brstore I am building? pThanks, brRich p br-- brArchives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"http://www.mail-archive.com/cf-talk@houseoffusion.com//a brTo Unsubscribe visit bra href="http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or brsend a message to [EMAIL PROTECTED] with 'unsubscribe' in brthe body. br br-- brArchives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"http://www.mail-archive.com/cf-talk@houseoffusion.com//a brTo Unsubscribe visit bra href="http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or brsend a message to [EMAIL PROTECTED] with 'unsubscribe' in brthe body. p-- brArchives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"http://www.mail-archive.com/cf-talk@houseoffusion.com//a brTo Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body./blockquote /html --642EBD9C7220BF144AD611F4-- --18DED34028AA5599808DB230 Content-Type: text/x-vcard; charset=us-ascii; name="nickslay.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Nick Slay Content-Disposition: attachment; filename="nickslay.vcf" begin:vcard n:Slay;Nick tel;cell:0414 810284 tel;home:02 4381 0284 tel;work:02 4381 0284 x-mozilla-html:FALSE url:http://www.webbods.com.au org:Webbods Pty Ltd
Re: Encrypting a credit card field...
Simple solution - DON'T display the credit card number at any time unless the page is secured with strong SSL encryption and even then avoid it if possible. Use client or session variables to store the CC number - don't use hidden form fields or URL parameters even if you use encryption on the values. You cannot be too careful with credit card numbers. -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Autonumber?
on 9/28/00 7:41 AM, HappyToad.com at [EMAIL PROTECTED] wrote: How do I use UUID? cfset uniqueid=createUUID() -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help with CFHTTP building a query from a CSV
I am saving an Excel spreadsheet as a CSV (Comma Separated Values) file. I import it into my web site by uploading it with CFFILE, then building a query out of it using CFHTTP. The problem is the CSV format saves each field as data separated by commas, and ONLY if there is a comma inside the data of the field it surrounds the field with quotes. CFHTTP, as far as I can tell, can only behave in one of two ways: If textdelimiter='"' (quotes the default) then every field MUST be surrounded by quotes or it bombs with an error or if textdelimiter='' (none) then any quotes around data are brought into the query as part of the value. This is pretty brain-dead behavior... Is it just the way it is, or perhaps the 4.5.1 patch fix this? By the way, I cannot use Nate Weiss's CSVtoQuery tag since it is a DLL and I am running on Linux. Test code follows: testfile.csv: "First","Second","Third","Fourth" "a","b","c","d" "1","2","3","4" testimport.cfm: (open angle bracket changed to '[' so my email program doesn't get confused) [html[body [cfif IsDefined("csvfile") [cffile action="upload" destination="/home/httpd/html/data.csv" filefield="csvfile" mode=664 nameconflict="overwrite" [cfhttp url="http://localhost/data.csv" method="get" name="dataqry" [table border=1 [tr [cfloop index="cols" list="#dataqry.ColumnList#" [cfoutput[td#cols#[/td[/cfoutput [/cfloop [/tr [cfoutput query="dataqry" [tr [cfloop index="f" list="#dataqry.ColumnList#" [td#evaluate(f)#[/td [/cfloop [/tr [/cfoutput [/table [/cfif [hr [cfform action="#cgi.script_name#" method=post enctype="multipart/form-data" Upload CSV file: [input type=file name="csvfile" [input type="submit" value="Upload" [/cfform [/body[/html --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting Outlook information
If you use roaming profiles, and your profiles are stored on a server that CF can access. Then you can read in the outlook data file (username.pst), and use the Outlook COM object with CFOBJECT, to read it. I remember seeing this somewhere, but I can't recall where. __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM / NETDesign Inc. ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 5:27 PM To: CF-Talk Subject: RE: Getting Outlook information Before I start this discussion let me say that there are some serious privacy concerns here. If the Intranet can access the data, then it really isn't secure. One question I have is: Does your company use Exchange as the mail server with Outlook? If so, then yes you can. Exchange uses Active Directories which are an extention of LDAP. You can use CFLDAP to get almost anything off the Exchange server. I'm not up on the specifics anymore, I had to drop that project over a year ago and have since changed jobs. Also, this will only access data on the Exchange Server. If the user has calendar itmems in a Peersonal Folder, then they are not easily accessible to Cold Fusion. VBScript or JScript in the page itself may be able to, but I have never investigated this. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 12:13 To: CF-Talk Subject: Getting Outlook information My company uses Microsoft Outlook as the mail client. I am wondering if I can grab information from outlook and put it on my customized intranet home page. For instance, can I put a link in my coldfusion page that calls the user's Outlook calendar and shows it on the page? What about the number of new messages, etc? Basically I want to grab the features of the "Outlook Today" tools in outlook. Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Costing a private project..
Between $40/hr and $150/hr depending on your experience, your skill, your sales ability, your client's needs, your client's budget, and how nicely you can tie a necktie :-) Look on guru.com and compare your skillset to others to get a better idea. At 08:08 AM 9/27/00 -0300, Angél Stewart wrote: Ahhh..ok :) Thanks guys and gals! How much per hour, does a Coldfusion Consultant of Intermediate level with about 1 1/2 years experience command in the UK/US markets now? -Gel -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 27 September 2000 06:09 To: CF-Talk Subject: RE: Costing a private project.. Break down the project into to tasks, each of which should be no longer than 3 days, preferably 1 day or less. Once you have got all the tasks defined put them end to end, assume a 5 day week and bingo that's how long it will take you. Set mini-milestones. If you slip a milestone by 20% because of poor estimation (you will never get this perfect), increase all your estimates by 20%. Identify tasks you are poor at estimating...re-estimate... Read Rapid Development: Taming Wild Software Schedules by Steve McConnel (also read his Code Complete) and his very good Software Project Survival Guide -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: TO ALL: Request for ColdFusion SP2 Input
Thread-safe Sybase drivers on Linux would be nice :-) At 08:50 AM 9/27/00 -0400, Damon Cooper wrote: Folks, ColdFusion Service Pack 2 is under construction, and I'd like to get your feedback on what you believe to be Must-Be-Fixed items. While Service Pack 1 focused heavily on stability and performance issues (across platform and Unix-specific), we'd like to nail as many serious feature and tag bugs as possible, although the release cycle will be significantly shorter (shooting for an early November release). Currently, here's a summary of bug fixes slated for SP2: 18965 Native Oracle CLOB support 18389 Security/Solaris Cfexec restart of Security Proxy 17873 Informix 2.3 2.5 client lib support 15776 CFMAIL recipients truncated at 246 characters 18191,18237,18314 CFHTTP Post failure (but redirects must still be an absolute url) 18338, 17121LSNumberFormat and NumberFormat problems 16663 MIME attached over regular WAP gateway (UTF-8). 19010 CFFILE/move problem on Unix file systems 17601 COM Threading Model Changes 18311 CFHTTP 'Connection Failure' error if the status code is 204 18246 CFPOP unknown exception condition 18811 POP3 enhancement 18058, 16875Applet interface in CFAdmin problems with parm fields 18607 MSAccess bug hangs CF on Win2k/SP1 18579 Secuirty Administration Bug - cfm file change 17543 Locale Date Support - Solaris 10115 European dates broken in Solaris CF 4.5+ 19003 CFFTP connection bug 12523 Unix, LSParseDateTime only functions for US english. 18991 CFHTTP on Linux crash with 4k content 18234, 17792MS SQLServer problems on Linux 18778 Scheduled tasks don't run with CFREGISTRY disabled I can't promise anything, but this release is for you, and I want to make sure you're heard. Please either post to the list or send email directly to me at [EMAIL PROTECTED] and reference your Allaire Issue/Bug # if you have one. Thanks Damon Cooper ColdFusion Release Manager Allaire -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Costing a private project..
What does it cost to join this list (after your free three month period is up)? At 06:07 AM 9/27/00 -0700, paul smith wrote: What was the question? At 01:27 PM 9/27/00 +0100, you wrote: Any where from around £35 - 100, the higher figure if you have specific industry experiance to add to a project -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: TO ALL: Request for ColdFusion SP2 Input
Cold Fusion Studio crashes a Win98 system every time due to resource problems. At 08:50 AM 9/27/00 -0400, Damon Cooper wrote: Folks, ColdFusion Service Pack 2 is under construction, and I'd like to get your feedback on what you believe to be Must-Be-Fixed items. While Service Pack 1 focused heavily on stability and performance issues (across platform and Unix-specific), we'd like to nail as many serious feature and tag bugs as possible, although the release cycle will be significantly shorter (shooting for an early November release). Currently, here's a summary of bug fixes slated for SP2: 18965 Native Oracle CLOB support 18389 Security/Solaris Cfexec restart of Security Proxy 17873 Informix 2.3 2.5 client lib support 15776 CFMAIL recipients truncated at 246 characters 18191,18237,18314 CFHTTP Post failure (but redirects must still be an absolute url) 18338, 17121LSNumberFormat and NumberFormat problems 16663 MIME attached over regular WAP gateway (UTF-8). 19010 CFFILE/move problem on Unix file systems 17601 COM Threading Model Changes 18311 CFHTTP 'Connection Failure' error if the status code is 204 18246 CFPOP unknown exception condition 18811 POP3 enhancement 18058, 16875Applet interface in CFAdmin problems with parm fields 18607 MSAccess bug hangs CF on Win2k/SP1 18579 Secuirty Administration Bug - cfm file change 17543 Locale Date Support - Solaris 10115 European dates broken in Solaris CF 4.5+ 19003 CFFTP connection bug 12523 Unix, LSParseDateTime only functions for US english. 18991 CFHTTP on Linux crash with 4k content 18234, 17792MS SQLServer problems on Linux 18778 Scheduled tasks don't run with CFREGISTRY disabled I can't promise anything, but this release is for you, and I want to make sure you're heard. Please either post to the list or send email directly to me at [EMAIL PROTECTED] and reference your Allaire Issue/Bug # if you have one. Thanks Damon Cooper ColdFusion Release Manager Allaire -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: query exchange 5.5 ldap
I have very basic phonelist app that connects to an exchange 5.5 server. I link to an access database to add additional profile information. like pictures, and stuff. Very basic. but I'll package and (very) briefly document and forward to you. I'll post in the exchange as well. It has Alpha hotlinks for first and last names, departmental hot links, and a search box. We can stumble together. but please don't let me hold back other responses, I have lots of questions about this there ldap schtuff. Eric From: Mike Sullivan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: query exchange 5.5 ldap Date: Wed, 27 Sep 2000 15:50:17 -0700 Greetings, I am trying to query my ldap server on exchange 5.5. I can't seem to identify the attribute / values that exchange wants to see. I am sure that the basic setup is ok as I can query the public ldap servers, but exchange seems to have different attribute names (?) and I can't seem to find any additional info on just how the query should be formulated. Here is an example of my query: cfldap server="172.16.0.105" action="query" name="test" start="ou=*" !--- I also tried "cityhall", the name of our --- !--- exchange organization. --- attributes="cn" filter="cn=m*" !--- with or without filters, same result --- cfoutput query="test" . What comes up is this error: "No such object..." Has anyone done this with exchange? Thanks Mike -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ColdFusion SP2
I'll bet you are running NT or Win2K. It crashes Win98 very quickly. It has the same resource leaks under NT, but NT is just better at handling it. At 07:17 PM 9/27/00 +0100, James Smith wrote: Interesting, I am running CFStudio just fine on a 96Mb laptop. My current memory usage is reported at 222Mb (big swap file :-) and the only trouble I have is an error AFTER the program has shut down! I regularly have CFStudio open for a complete 8 hour day with no crashes (if I can convince windows to run that long) with Dreamweaver opened at regular intervals through the period and PhotoShop running most of it. Sure there are some slowdowns when switching between apps at the page file goes crazy, but once the foreground app is fully active and running from real RAM things get back to regular speed and no crashing. I am not saying studio is perfect, and I don't use a lot of it's "advanced" features like deployment so there must be areas I haven't fully explored the crashability of, but for the most part it seems to be one of the most stable apps I run. -- James Smith [EMAIL PROTECTED] - Original Message - From: "William J Wheatley" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 4:03 PM Subject: Re: ColdFusion SP2 well now that we are talking about Studio my 2 cents. I get alot of crashes on it too for no reason most of the time when it manages to suck down my 500 megs of ram on my personal box =) which was added just to be able to let me have CF DreamWeaver/UltraDev open at the same time since they are both way to hoggy but i've found CF to be more so. And also there is a bug that when you save a file sometimes it does not show as being saved (it stays blue). And personally for me the most annoying thing for me was that STUDIO screws up me being able to ALT-TAB through apps it keeps CF on top unless i do a little trick i've learned to do. But have them fix that alt-tab bug and i'll buy you all CF_BEER mugs Thanks! =) Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ot: sql question
This hurts to look at. Is that the entire table? Or are there additional fields that make those rows unique? If it's the entire table, why do you have identical rows, and why do you want to retain them? If there's more to the table, extend your 'where' clause to identify the unique row that you want to delete. I suppose you could delete all of these rows and then reinsert one, with a CFTRANSACTION around the delete and insert. Also, if the id's are numeric, omit the quotes. -David On Wed, 27 Sep 2000 13:58:57 -0500 Gavin Myers [EMAIL PROTECTED] writes: here's what i'm doing delete from class_registration where users_id='123123' and class_id='4242424' here's what the table looks like name users_idclass_id gavin 123123 4242424 gavin 123123 4242424 gavin 123123 4242424 gavin 123123 4242424 what i want to do is delete only 1 of those rows suggestions? thanks, Gavin YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Drill down click menu navigation!
Ok I have burnt my brain enough on this, and can't seem to get the logic right. I know I am close but it doesn't seem to work the way it is supposed to:-) What I am trying to achieve is simple enough, the below array is static at the moment but will be created on the fly later. The idea is that first time use it displays the very top hierarchy as links so you should get. Research Analysis Commentary Product Learning The Team The clicking on any of the links should then decide to do one of two things, if its a link to display another page then go of and display this page. Otherwise it should display the next list of options. Research Australia New Zealand Asia Pacific Analysis Commentary Product Learning The Team I think you get the general idea, now this is a custom tag that is passed a variable from the url, which is something like 1-1-2. This is then used to be able to say this is top position 1, child 1 or position 1 and child 2 of child 1. The code for the custom tag is listed below, can anyone see what I am trying to achieve where I am going wrong and correct it if need be. For the life of me I can't seem to function to figure this out and it really is driving me round the bend. maybe the Array isn't right or whatever. I just need a helping hand to debug this thing:-) Array: cfscript Example = ArrayNew(1); Example[1] = ArrayNew(1); Example[1][1] = "Research"; Example[1][2] = ArrayNew(1); Example[1][2][1] = "Australia"; Example[1][2][2] = ArrayNew(1); Example[1][2][2][1] = "Morning Update"; Example[1][2][2][2] = "Economic Update"; Example[1][2][2][3] = "Weekly Market Update"; Example[1][2][2][4] = "Markets Update (Monthly)"; Example[1][2][2][5] = "ANZ Economic Outlook"; Example[1][2][2][6] = "ANZ Global Economic Update"; Example[1][2][2][7] = "$A Interest Rate Outlook"; Example[1][2][2][8] = "ANZ Job Advertisments"; Example[1][2][2][9] = "ANZ Rural Outlook"; Example[1][2][2][10] = "ANZ Property Outlook"; Example[1][2][2][11] = "Forecasts"; Example[1][2][3] = "New Zealand"; Example[1][2][4] = "Asia Pacific"; Example[2] = ArrayNew(1); Example[2][1] = "Analysis"; Example[3] = ArrayNew(1); Example[3][1] = "Commentary"; Example[4] = ArrayNew(1); Example[4][1] = "Product"; Example[5] = ArrayNew(1); Example[5][1] = "Learning"; Example[6] = ArrayNew(1); Example[6][1] = "The Team"; /cfscript Code: cfparam name="attributes.array" default="" type="array" cfparam name="attributes.selected" default="" cfparam name="attributes.Level" default=0 type="numeric" cfset Example = attributes.array cfset strArray = attributes.selected cfset nLevel = attributes.Level cfif not IsArray(Example) cfoutputError: more detailed information is needed/cfoutput cfabort /cfif cfparam name="blnMenu" default="0" cfif nLevel lte ListLen(attributes.selected) cfif strArray neq "" cfset blnMenu=ListGetAt(attributes.selected,nLevel,"-") /cfif /cfif cfoutput cfloop index="item" from=1 to="#ArrayLen(Example)#" a href="index.cfm?menu=#item###research"img src="arrow_1e.gif" height="9" width="12" border=0#Example[item][1]#/abr cfif blnMenu eq item cfif nlevel lte ListLen(attributes.selected,"-") cfset NextLevel=nLevel cf_cfs_navDisplay array="#Example[item]#" selected="#menu#" Level="#NextLevel#" /cfif /cfif /cfloop /cfoutput regards Andrew Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 September 2000 06:13 To: CF-Talk Subject: RE: Cheap CF Hosting FOUND If you can live without the usual security issue tags (CFFILE, CFOBJECT, etc) take look at Dantor.com. $10 / month CF 4.0 hosting (basic account -- self service everything through a CF interface) on T3s. Support is about average via email, but they do respond and everything works -- I have two domains on there servers and I'm pretty happy with them. Well... since I'm replying to a large backlog of email today anyway, what the heck I "temporarily" parked intrafoundation.com and fourthfoundation.com with www.paconline.net a year or two ago intending to change over to something more expensive later on. Frankly, for $25 a month they're not all that bad. Occasionally ftp or email is unavailable, but usually only for a few minutes. Course, I only do about 600 to 700mb of traffic a month, and don't do any heavy db on them so... that could be completely different. Mainly I chose them because mainframe.ca was sitting there at the time. And I thought it was cool to share rackspace with the people who made the "money for nothing" video. ;-) --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL
RE: access iif count
For Access try SUM instead of COUNT cfquery name="countyesnos" datasource="#dsn#" SELECT SUM(IIF(success = 1, 1, 0)) AS successyes, SUM(IIF(success = 0, 1, 0)) AS successno FROM survey /cfquery P. -Original Message- From: Jaime Garza [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 7:24 PM To: CF-Talk Subject: RE: access iif count Power to the sub queries! FOR SQL Server: SELECT (SELECT Count(*) FROM Survey WHERE success=1) as SuccessYes, (SELECT Count(*) FROM Survey WHERE success=0) as SuccessNo, (SELECT Count(*) FROM Survey WHERE OtherFlag=32) as CountThirtyTwos For Oracle, same thing but you add 'FROM dual' at the end: Access should work as SQL server but I have not tried months ago. Jaime/ -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 11:17 AM To: CF-Talk Subject: access iif count Hi folks, I'm trying to use IIF in a query to count a bunch of yes/no values. Here's what I'm trying that doesn't work (both count the total rows): cfquery name="countyesnos" datasource="#dsn#" SELECT COUNT(IIF (success = 1, 1, 0)) as successyes, COUNT(iif (success = 0, 1, 0)) as successno FROM survey/cfquery I know I could do this: SELECT COUNT(success) as successyes FROM survey WHERE success = 1 to get the right answer, but I want to be able to do it for several yes/no fields all in one query. I know I'm just putting something in the wrong place or something. Help? Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Updating 2 databases on 2 seperate servers using one form submission
I have dual sites running on 2 separate cf servers is there a way that I can update both databases when I am using one of my database update forms so that with one click of the form submit button it will take the form data and update both databases at the same time Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Cant nest CFLOOPs !
Peter make them lists. Cfset names = valuelist(myquery.name) etc then use listgetat - Original Message - From: "Peter Theobald" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, September 26, 2000 8:42 PM Subject: Cant nest CFLOOPs ! I just found out that if you nest CFLOOPs with Queries the inner CFLOOP will undo the outer loops query variable bindings! In other words: CFLOOP QUERY="myquery" name is #myquery.name# (this works)br CFLOOP QUERY="liststates" state is #liststates.state# (this works)br name is #myquery.name# (this DOES NOT WORK!) It always shows the FIRST RECORD of myquery!br /cfloop /cfloop Can this be?! In my real-world program my outer loop is querying a table with 30 fields! Do I actually have to put them all in temporary variables in order to "pass" them down into the inner loop? This stinks! -- - Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ColdFusion SP2 Input
Mr. Damon Cooper; There are two specific issues with CF right now that I have come across and have torn my hair out with. The second is "fixed" with different coding methods, but the first requires close interaction (read: bugging of) with my ISP. 1) Additional Parameters with CFHTTP (and CFFTP) The problem arose when CFHTTPing through the CacheFlow server at my ISP (I'm co-located). The CFHTTP information was always out of date (weather stuff). First I ripped apart CF. Then I ripped apart NT. Then I went looking - and found that the cache server couldn't handle the CFHTTP command - and failed to pull fresh information with the request. In long talks to my ISP and the VERY helpful staff at CacheFlow (I cc'ed a few of the emails to [EMAIL PROTECTED] with no response), I found that I could correct the problem by passing a few commands along with the CFHTTP. Well, if running CGI or PHP - I could. But CF's CFHTTP doesn't allow me to pass unique variables/text through that the CacheFlow server (or ANY cache system) can read. Finally, the ISP was manually able to adjust settings on the CacheFlow server for the individual site I was CFHTTPing from. 2) CFLOCATION and COOKIES I think EVERY developer I know (unless in a situation to be warned by others in a workgroup) has spent hours trying to figure out why cookies won't set on a page that is CFLocated. Can we fix this and have the cookies set BEFORE the page re-locates? Thank you for your time. Stephen R. Cassady Publisher Cofounder, Spank! Youth Culture Online wb. http://www.spankmag.com em. [EMAIL PROTECTED] About Spankmag.com! - Launched 01 November 1995, Spank! Youth Culture Online is a flagship quality youth online-lifestyle magazine (http://www.spankmag.com), and the very first-ever of it's kind. Spank!s online services offer users cool reviews, informative features, opinions, contests, cartoons and areas to express their own thoughts and ideas. At the heart of Spank!s services is original, fresh, content built by a team of editors from North America and around the world. True to it's nature, Spank! leverages this talent into a peer to peer meeting of youth (14 - 26) from around the world. Free of censorship, open to ideas, Spank! weeds out the parental guidance side found in most youth journals designed by adults. Spank! is the playground and stepping stone for youth. -- Date: Wed, 27 Sep 2000 08:50:44 -0400 From: Damon Cooper [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED], "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: TO ALL: Request for ColdFusion SP2 Input Message-ID: [EMAIL PROTECTED] Folks, ColdFusion Service Pack 2 is under construction, and I'd like to get your feedback on what you believe to be Must-Be-Fixed items. While Service Pack 1 focused heavily on stability and performance issues (across platform and Unix-specific), we'd like to nail as many serious feature and tag bugs as possible, although the release cycle will be significantly shorter (shooting for an early November release). Currently, here's a summary of bug fixes slated for SP2: 18965 Native Oracle CLOB support 18389 Security/Solaris Cfexec restart of Security Proxy 17873 Informix 2.3 2.5 client lib support 15776 CFMAIL recipients truncated at 246 characters 18191,18237,18314 CFHTTP Post failure (but redirects must still be an absolute url) 18338, 17121LSNumberFormat and NumberFormat problems 16663 MIME attached over regular WAP gateway (UTF-8). 19010 CFFILE/move problem on Unix file systems 17601 COM Threading Model Changes 18311 CFHTTP 'Connection Failure' error if the status code is 204 18246 CFPOP unknown exception condition 18811 POP3 enhancement 18058, 16875Applet interface in CFAdmin problems with parm fields 18607 MSAccess bug hangs CF on Win2k/SP1 18579 Secuirty Administration Bug - cfm file change 17543 Locale Date Support - Solaris 10115 European dates broken in Solaris CF 4.5+ 19003 CFFTP connection bug 12523 Unix, LSParseDateTime only functions for US english. 18991 CFHTTP on Linux crash with 4k content 18234, 17792MS SQLServer problems on Linux 18778 Scheduled tasks don't run with CFREGISTRY disabled I can't promise anything, but this release is for you, and I want to make sure you're heard. Please either post to the list or send email directly to me at [EMAIL PROTECTED] and reference your Allaire Issue/Bug # if you have one. Thanks Damon Cooper ColdFusion Release Manager Allaire -- Archives:
RE: Delay
Yup and take one of those threads from you multi threaded server environemnt and lock it up for 2 seconds20% fall in server perfomance...bingo. :) -- From: Simon Horwith[SMTP:[EMAIL PROTECTED]] Sent: 27 September 2000 15:51 To: CF-Talk Subject: RE: Delay Try using getTickCount: THIS SHOULD CREATE A 2 SECOND TIMER!! CFSET tickBegin = GetTickCount() CFLOOP FROM="1" TO = "1" index = "index" CFSET tickEnd = GetTickCount() CFIF tickEnd - tickBegin IS 2000 CFBREAK OR YOU COULD PUT THE CFLOCATION RIGHT HERE, INSTEAD /CFIF /CFLOOP ~Simon -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 9:07 PM To: CF-Talk Subject: Re: Delay I use a CFLOOP to create a delay. CFLOOP Index="Timer" From="1" to="15000" STEP="1" /cfloop There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, September 25, 2000 9:58 PM Subject: Delay Can anyone help please? I'm trying to set up a delay in page without using a meta tag. I've tried this but it relocates straight way. Do I need to tell it that the values are specifically dates? TIA! !--- Create a 2 second delay --- CFSET Beginning = Now() CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# CFLOOP condition="Difference LT 2" CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# /CFLOOP !--- Relocate to the menu page --- cflocation url="test_id.cfm" addtoken="No" Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 ** ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ** ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OMG!!!!!
Sounds like someone has not analysed the requirements very well. We have been using CF for over four years. Certainly there are problems with character representations at times ... nothing that we have not been able to work around. Once and awhile someone tries to code in ASP. So far whether from lack of preparation or time none of the projects have been neither particularly successful or easy to maintain. Have a look at our site http://www.ancitel.it or http://www.anci.it . Search functions with verity have never worked brillantly in Italian but that could also be that we have not studied it well. john forrester [EMAIL PROTECTED] - Original Message - From: "Jim Taylor" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 8:32 PM Subject: OMG! I just got off the phone with a company and they said that that were goning ro change from coldfusion to Asp beause coldfusion does not fit their international language requirments... Does anyone know what they were talking about. I am talking that some major cold coldfusion fusion houses here in phoenix are changing .and have put a coding freeze on for their company.. any one know about this Jim Taylor Web Centric Central http://130.13.69.228 [EMAIL PROTECTED] Home Office: 480-496-0712 Cell Phone : 602-576-0508 Fax:: 208-474-8305 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: O'Reilly Website
Found a tag related to this myself, if anyone else is interested: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3476BA-2830-11D4-AA 9700508B94F380method=Full Cheers Will - Original Message - From: "W Luke" [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Monday, September 25, 2000 11:16 AM Subject: O'Reilly Website Hi, My latest task given to me by my Boss is a little complicated (for me, anyhow). I've got to Automate the entry of Domains onto the server via a nice Web Interface - at the moment we are using O'Reilly's Website Professional version 2.4. I presume, although I don't *know* for certain, that this is a cfregistry thing. If anyone has done this, or something similar, any tips or hints would be much appreciated. Cheers all Will -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Any web-based message board software that can do this?
Have you looked at Allaire Forums? It'll support most of your requirements. I'm unsure about limitations on the application. -Original Message- From: Lawrence B. Afrin, M.D. [SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 04:30 To: CF-Talk Subject: Any web-based message board software that can do this? This is a multi-part message in MIME format. --CD01BFD9EB790CB195C41678 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Howdy -- I have been looking for (preferably but not necessarily commercial) web-based message board software that meets certain specific requirements. I have looked at more than 20 packages but still have come up empty-handed. If anybody knows of any packages that can meet these requirements, I'd sure appreciate it if you would clue me in. 1) Supports an essentially unlimited number of forums and users (approximately 250,000 new forums and users will be created each year). 2) Because of (1), pricing must be either a flat (reasonable ;-) fee for unlimited use, or literally no more than a few pennies per forum and/or user. 3) Web-based *and* programmatic interfaces for creating new forums, new users, and assigning permissions for users to access forums and for subscribing users to forums. 4) E-mail notification of a forum's subscribed users that a new message has been posted to the forum; the e-mail must contain a URL that will get a subscribed user *directly* to the new message (after the user's userid/password have been entered), not just to the forum's listing of messages. It is imperative that the e-mail notification *not* contain the actual forum posting. 5) Although this should be transparent to the package, it's an absolute requirement so I'll mention it anyway: all sessions with the web-based message board must be in secure (SSL, https://...) mode. 6) Access to any forum requires user authentication. Default authentication mechanism can be internal, but hooks must be present to allow external user authentication mechanism if desired. 7) There must be hooks to allow external processing every time a message is posted to any forum. 8) Postings can be made to a forum via the web or e-mail. 9) Full audit trail of *all* activity throughout the message board, preferably with audit trail reporting and analysis tools included. 10) Front-end (i.e., design of the web pages seen by the user) must be customizable by the system administrator. Customizability need only apply to the look and feel of the overall site, not necessarily to the individual forum/user. Thanks for any help you can provide! -- Larry Afrin, M.D. Medical University of South Carolina [EMAIL PROTECTED] --CD01BFD9EB790CB195C41678 Content-Type: text/x-vcard; charset=us-ascii; name="afrinl.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Lawrence B. Afrin, M.D. Content-Disposition: attachment; filename="afrinl.vcf" begin:vcard n:Afrin, M.D.;Lawrence tel;fax:843-792-3200 tel;work:843-792-4271 x-mozilla-html:FALSE org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University of South Carolina version:2.1 email;internet:[EMAIL PROTECTED] title:Assistant Professor of Medicine adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 96 Jonathan Lucas Street;Charleston;SC;29425;USA x-mozilla-cpt:;0 fn:Afrin, M.D., Lawrence end:vcard --CD01BFD9EB790CB195C41678-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Webtrends
Hi! We are using Webtrends Log Analyzer 5.0 But we found out that pur graphs don't look so good. Here are some examples: http://www.btc-city.com/logs/DEFAULT10.jpg http://www.btc-city.com/logs/DEFAULT22.jpg http://www.btc-city.com/logs/DEFAULT23.jpg How can we change sharpnes in Webtrends reports? Bye, Iztok -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Webtrends
If you want us to look, we need the user name and pwd . . . .g Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: "Iztok Polanic" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 5:05 AM Subject: Webtrends Hi! We are using Webtrends Log Analyzer 5.0 But we found out that pur graphs don't look so good. Here are some examples: http://www.btc-city.com/logs/DEFAULT10.jpg http://www.btc-city.com/logs/DEFAULT22.jpg http://www.btc-city.com/logs/DEFAULT23.jpg How can we change sharpnes in Webtrends reports? Bye, Iztok -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: updating two databases with one form submit (WAS: RE:)
You might want to put an insert trigger on your 'primary' database tables. When a record is inserted, the trigger would insert the same record into the other database. Also, same thing goes for updates and deletes. -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 5:29 AM To: CF-Talk Subject: I have dual sites running on 2 separate cf servers is there a way that I can update both databases when I am using one of my database update forms so that with one click of the form submit button it will take the form data and update both databases at the same time Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Any web-based message board software that can do this?
Look at Twister from Software.com. It isn't free, they don't have an NT version, but will scale like you want it too. Using news as the backend and a web interface is the best solution to discussion forums. Moreover it gives you the flexibility of using a News client or web browser. - Steve -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 5:00 AM To: CF-Talk Subject: RE: Any web-based message board software that can do this? Have you looked at Allaire Forums? It'll support most of your requirements. I'm unsure about limitations on the application. -Original Message- From: Lawrence B. Afrin, M.D. [SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 04:30 To: CF-Talk Subject: Any web-based message board software that can do this? This is a multi-part message in MIME format. --CD01BFD9EB790CB195C41678 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Howdy -- I have been looking for (preferably but not necessarily commercial) web-based message board software that meets certain specific requirements. I have looked at more than 20 packages but still have come up empty-handed. If anybody knows of any packages that can meet these requirements, I'd sure appreciate it if you would clue me in. 1) Supports an essentially unlimited number of forums and users (approximately 250,000 new forums and users will be created each year). 2) Because of (1), pricing must be either a flat (reasonable ;-) fee for unlimited use, or literally no more than a few pennies per forum and/or user. 3) Web-based *and* programmatic interfaces for creating new forums, new users, and assigning permissions for users to access forums and for subscribing users to forums. 4) E-mail notification of a forum's subscribed users that a new message has been posted to the forum; the e-mail must contain a URL that will get a subscribed user *directly* to the new message (after the user's userid/password have been entered), not just to the forum's listing of messages. It is imperative that the e-mail notification *not* contain the actual forum posting. 5) Although this should be transparent to the package, it's an absolute requirement so I'll mention it anyway: all sessions with the web-based message board must be in secure (SSL, https://...) mode. 6) Access to any forum requires user authentication. Default authentication mechanism can be internal, but hooks must be present to allow external user authentication mechanism if desired. 7) There must be hooks to allow external processing every time a message is posted to any forum. 8) Postings can be made to a forum via the web or e-mail. 9) Full audit trail of *all* activity throughout the message board, preferably with audit trail reporting and analysis tools included. 10) Front-end (i.e., design of the web pages seen by the user) must be customizable by the system administrator. Customizability need only apply to the look and feel of the overall site, not necessarily to the individual forum/user. Thanks for any help you can provide! -- Larry Afrin, M.D. Medical University of South Carolina [EMAIL PROTECTED] --CD01BFD9EB790CB195C41678 Content-Type: text/x-vcard; charset=us-ascii; name="afrinl.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Lawrence B. Afrin, M.D. Content-Disposition: attachment; filename="afrinl.vcf" begin:vcard n:Afrin, M.D.;Lawrence tel;fax:843-792-3200 tel;work:843-792-4271 x-mozilla-html:FALSE org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University of South Carolina version:2.1 email;internet:[EMAIL PROTECTED] title:Assistant Professor of Medicine adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 96 Jonathan Lucas Street;Charleston;SC;29425;USA x-mozilla-cpt:;0 fn:Afrin, M.D., Lawrence end:vcard --CD01BFD9EB790CB195C41678-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net -- Archives:
RE: Any web-based message board software that can do this?
We are trying out cfboards. It looks pretty good and you can buy the source licence. Done if 100% fusebox if that is an advantage. It is at www.cfboards.com I should note that we haven't run it in production yet though. I have no affiliation with the company. Lanny Udey Hofstra University Mike Connolly [EMAIL PROTECTED] Thursday, September 28, 2000 Have you looked at Allaire Forums? It'll support most of your requirements. I'm unsure about limitations on the application. -Original Message- From: Lawrence B. Afrin, M.D. [SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 04:30 To: CF-Talk Subject: Any web-based message board software that can do this? This is a multi-part message in MIME format. --CD01BFD9EB790CB195C41678 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Howdy -- I have been looking for (preferably but not necessarily commercial) web-based message board software that meets certain specific requirements. I have looked at more than 20 packages but still have come up empty-handed. If anybody knows of any packages that can meet these requirements, I'd sure appreciate it if you would clue me in. 1) Supports an essentially unlimited number of forums and users (approximately 250,000 new forums and users will be created each year). 2) Because of (1), pricing must be either a flat (reasonable ;-) fee for unlimited use, or literally no more than a few pennies per forum and/or user. 3) Web-based *and* programmatic interfaces for creating new forums, new users, and assigning permissions for users to access forums and for subscribing users to forums. 4) E-mail notification of a forum's subscribed users that a new message has been posted to the forum; the e-mail must contain a URL that will get a subscribed user *directly* to the new message (after the user's userid/password have been entered), not just to the forum's listing of messages. It is imperative that the e-mail notification *not* contain the actual forum posting. 5) Although this should be transparent to the package, it's an absolute requirement so I'll mention it anyway: all sessions with the web-based message board must be in secure (SSL, https://...) mode. 6) Access to any forum requires user authentication. Default authentication mechanism can be internal, but hooks must be present to allow external user authentication mechanism if desired. 7) There must be hooks to allow external processing every time a message is posted to any forum. 8) Postings can be made to a forum via the web or e-mail. 9) Full audit trail of *all* activity throughout the message board, preferably with audit trail reporting and analysis tools included. 10) Front-end (i.e., design of the web pages seen by the user) must be customizable by the system administrator. Customizability need only apply to the look and feel of the overall site, not necessarily to the individual forum/user. Thanks for any help you can provide! -- Larry Afrin, M.D. Medical University of South Carolina [EMAIL PROTECTED] --CD01BFD9EB790CB195C41678 Content-Type: text/x-vcard; charset=us-ascii; name="afrinl.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Lawrence B. Afrin, M.D. Content-Disposition: attachment; filename="afrinl.vcf" begin:vcard n:Afrin, M.D.;Lawrence tel;fax:843-792-3200 tel;work:843-792-4271 x-mozilla-html:FALSE org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University of South Carolina version:2.1 email;internet:[EMAIL PROTECTED] title:Assistant Professor of Medicine adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 96 Jonathan Lucas Street;Charleston;SC;29425;USA x-mozilla-cpt:;0 fn:Afrin, M.D., Lawrence end:vcard --CD01BFD9EB790CB195C41678-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
RE: Autonumber?
That is exactly what I wanted. I appreciate it. thanks, Rich -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 6:07 PM To: CF-Talk Subject: Re: Autonumber? One useful way is this: CFSET OrderID = #DateFormat(Now(), "mmdd")##TimeFormat(Now(), "hhmmss")##RandRange(1000,)# OrderID = 18 digit unique number This gives you exact date and time for the order number. Now you have both order number and date/time info for analysis and the 5 digit random number tagged to end prevents dupes (unless you have ultra-high-never-before-heard-of-order-volume on your site). Dave - Original Message - From: HappyToad.com [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 10:44 AM Subject: Autonumber? How can I have Cf create a unique order id for each order placed though the store I am building? Thanks, Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Instant Messaging in Cold Fusion
There was an article in the August 2000 edition of ColdFusion Developer's Journal that suggests a method of doing this using application structures. It might give you some ideas. Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 3:11 PM To: CF-Talk Subject: Instant Messaging in Cold Fusion Does anyone know of any reliable instant messaging application in Cold Fusion. at the Developer's Exchange at the Allair website there is a "Quick Message" application which I downloaded and doesn't work... Anyone got any ideas? Ron Gallagher [EMAIL PROTECTED] http://www.RateMyFace.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: updating two databases with one form submit (WAS: RE:)
thanks for the suggestion regarding the insert trigger however I have no idea how I do that so your further guidance would be appreciated please keep in mind that for the moment all this is being done using access 200 database not sql - Original Message - From: "Jeff Beer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 9:31 PM Subject: RE: updating two databases with one form submit (WAS: RE:) You might want to put an insert trigger on your 'primary' database tables. When a record is inserted, the trigger would insert the same record into the other database. Also, same thing goes for updates and deletes. -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 5:29 AM To: CF-Talk Subject: I have dual sites running on 2 separate cf servers is there a way that I can update both databases when I am using one of my database update forms so that with one click of the form submit button it will take the form data and update both databases at the same time Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Autonumber?
I am getting the following error when I tried to use the code you sent me. Error Diagnostic Information Just in time compilation error Invalid parser construct found on line 16 at position 49. ColdFusion was looking at the following text:#Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFSET tag occupying document position (16:1) to (16:6). Apparently it doesn't like having 2 ## in a row. This is exactly what I wanted to have, so I'd like to get it properly set up. Any ideas? Rich -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 6:07 PM To: CF-Talk Subject: Re: Autonumber? One useful way is this: CFSET OrderID = #DateFormat(Now(), "mmdd")##TimeFormat(Now(), "hhmmss")##RandRange(1000,)# OrderID = 18 digit unique number This gives you exact date and time for the order number. Now you have both order number and date/time info for analysis and the 5 digit random number tagged to end prevents dupes (unless you have ultra-high-never-before-heard-of-order-volume on your site). Dave - Original Message - From: HappyToad.com [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 10:44 AM Subject: Autonumber? How can I have Cf create a unique order id for each order placed though the store I am building? Thanks, Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Webtrends
Hi! Sorry...here they are: www.abak.net/webtrends Please provide any info you can. Tnx!!! Bye, Iztok - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 13:24 Subject: Re: Webtrends If you want us to look, we need the user name and pwd . . . .g Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: "Iztok Polanic" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 5:05 AM Subject: Webtrends Hi! We are using Webtrends Log Analyzer 5.0 But we found out that pur graphs don't look so good. Here are some examples: http://www.btc-city.com/logs/DEFAULT10.jpg http://www.btc-city.com/logs/DEFAULT22.jpg http://www.btc-city.com/logs/DEFAULT23.jpg How can we change sharpnes in Webtrends reports? Bye, Iztok -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT -- Database Question
It's difficult to build a good data model from the limited amount of information provided, but assuming that is _all_ the information you need to store, the quickest answer (not necessarily the best), would be to store the data in two tables. Order Table --- OrderID Quantity CardID OrderInfo Table --- OrderID (which is also a FK to the Order Table) ProofRequired CustomerComments ReorderNumber DealerPONumber DealerNote OperatorInitial OperatorNote This would potentially save space, but makes your model more complicated. If you really want to model it properly (i.e., normalized), you should consider whether you are looking at a supertype/subtype situation, in which you might end up with many tables. For example: Order Table --- OrderID Quantity CardID OrderInfo Table --- OrderID (which is also a FK to the Order Table) ProofRequired CustomerComments ReorderNumber OrderDealer Table - OrderID (which is also a FK to the Order Table) DealerPONumber DealerNote OrderOperator Table --- OrderID (which is also a FK to the Order Table) OperatorInitial OperatorNote You would do this if there was a logical grouping of optional attributes. For example, if it were often the case that you needed to store DealerPONumber and DealerNote, but _not_ OperatorInitial and OperatorNote. Of course, you also have the option of storing everything in one big table. This would depend on your storage and performance considerations. Hope this is what you were looking for, Bob -Original Message- From: Craig A. Zingerline [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 4:12 PM To: CF-Talk Subject: Slightly OT -- Database Question Hello, I have a question regarding database design. I have an application that will take information for orders. This application will have certain required fields and certain optional fields. I am wondering what the best table structure breakdown will work best for this application, as you will see there are many more optional fields than required fields: Required Information: OrderID Quantity CardID Optional fields: RushDelivery ProofRequired CustomerComments ReorderNumber DealerPONumber DealerNote OperatorInitial OperatorNote Thank you for any help/suggestions! Sincerely, Craig -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CGI. Auth_user timeout??
Hello All, Does anyone know whether or how the "CG.AUTH_USER" timesout or does it timeout at all. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Costing vs. Price Fixing
I believe the big difference between costing and price fixing is: Costing - Getting a feel for what is the average cost Price fixing- A majority of the community agreeing to maintain a minimum cost. Salary surveys are everywhere and many job postings carry salary expectations. I just don't see the problem here. I get paid $10/hr for CF, SQL, JavaScript and html analysing/coding/project co-ordination on 6 domains as well as developing an internet marketing strategy for the largest conservation organization in Ontario. But I'm not bitter..;) Guy J. McDowell Webmaster Ontario Federation of Anglers and Hunters -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OMG!!!!!
Yes allaire has siad that Unicode will be part of CF5. Should be a sideeffect of using Java anyway... ~J - Original Message - From: "Paul Hastings" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 11:22 AM Subject: Re: OMG! Most likely that annoying lack of full (or any) unicode support. thai, etc. works fine provided its english + one langauge per page. chinese japanese are tougher but i guess workable. once you get into multiple langauges its unicode or nothing. if you're careful, you can use unicode text from a db w/cf. in any case, unicode cf5 were once metioned together on the same day. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: updating two databases with one form submit (WAS: RE:)
You are stuffed then. Write it in coldfusion as a double insert/update. -- From: AustralianAccommodation.com Pty. Ltd.[SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 13:01 To: CF-Talk Subject: Re: updating two databases with one form submit (WAS: RE:) thanks for the suggestion regarding the insert trigger however I have no idea how I do that so your further guidance would be appreciated please keep in mind that for the moment all this is being done using access 200 database not sql - Original Message - From: "Jeff Beer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 9:31 PM Subject: RE: updating two databases with one form submit (WAS: RE:) You might want to put an insert trigger on your 'primary' database tables. When a record is inserted, the trigger would insert the same record into the other database. Also, same thing goes for updates and deletes. -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 5:29 AM To: CF-Talk Subject: I have dual sites running on 2 separate cf servers is there a way that I can update both databases when I am using one of my database update forms so that with one click of the form submit button it will take the form data and update both databases at the same time Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT -- Database Question
I guess it all depends on the potential size of the database. If it is going to be large and you want to search on it quickly then what tends to happen these days is people start of with a normalized data structure and then de-normalize until they reach a happy medium...aka data warehousing. Even better use WDDX!..you can have the data that you need to search on in seperate fields and chuck the rest of it into a field using WDDXCF then deciphers it. This may well be overkill for what you are doing but just a thought -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: 28 September 2000 13:03 To: CF-Talk Subject: RE: Slightly OT -- Database Question It's difficult to build a good data model from the limited amount of information provided, but assuming that is _all_ the information you need to store, the quickest answer (not necessarily the best), would be to store the data in two tables. Order Table --- OrderID Quantity CardID OrderInfo Table --- OrderID (which is also a FK to the Order Table) ProofRequired CustomerComments ReorderNumber DealerPONumber DealerNote OperatorInitial OperatorNote This would potentially save space, but makes your model more complicated. If you really want to model it properly (i.e., normalized), you should consider whether you are looking at a supertype/subtype situation, in which you might end up with many tables. For example: Order Table --- OrderID Quantity CardID OrderInfo Table --- OrderID (which is also a FK to the Order Table) ProofRequired CustomerComments ReorderNumber OrderDealer Table - OrderID (which is also a FK to the Order Table) DealerPONumber DealerNote OrderOperator Table --- OrderID (which is also a FK to the Order Table) OperatorInitial OperatorNote You would do this if there was a logical grouping of optional attributes. For example, if it were often the case that you needed to store DealerPONumber and DealerNote, but _not_ OperatorInitial and OperatorNote. Of course, you also have the option of storing everything in one big table. This would depend on your storage and performance considerations. Hope this is what you were looking for, Bob -Original Message- From: Craig A. Zingerline [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 4:12 PM To: CF-Talk Subject: Slightly OT -- Database Question Hello, I have a question regarding database design. I have an application that will take information for orders. This application will have certain required fields and certain optional fields. I am wondering what the best table structure breakdown will work best for this application, as you will see there are many more optional fields than required fields: Required Information: OrderID Quantity CardID Optional fields: RushDelivery ProofRequired CustomerComments ReorderNumber DealerPONumber DealerNote OperatorInitial OperatorNote Thank you for any help/suggestions! Sincerely, Craig -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Autonumber?
With Oracle you need a sequence and a trigger script. The trigger fires on insert and pulls the next number from the sequence. I can provide samples of each if you need. -Deanna Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting Outlook information
Look here towards the bottom Dain has been able to log on to the exchage server http://www.cfm-resources.com/members/comet/forum/ViewThread.cfm?ThreadID=D5F C2DFE-4101-49FB-B7699011B9740E7C You will need Outlook on the server unfortunately but if it's an intranet who cares. To see what else he has there go to http://www.cfm-resources.com/members/comet he has some interesting things going on there. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 4:40 PM To: CF-Talk Subject: Re: Getting Outlook information you could install Outlook Web Access ad bastardize the code for your purposes. From: "Claremont, Timothy S" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Getting Outlook information Date: Wed, 27 Sep 2000 13:12:48 -0400 My company uses Microsoft Outlook as the mail client. I am wondering if I can grab information from outlook and put it on my customized intranet home page. For instance, can I put a link in my coldfusion page that calls the user's Outlook calendar and shows it on the page? What about the number of new messages, etc? Basically I want to grab the features of the "Outlook Today" tools in outlook. Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: access iif count
Thanks Jaime, But, it doesn't work. Syntax Error. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: access iif count
Thanks Peter. That did it. I swear I tried that. Oh well. Brain burp. -Deanna Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion SP2 -install issues
I don't remember if SP1 worked this way or not, but my biggest request would be for EVERY new version of CF - be able to be installed without having installed a previous version. I ran into trouble once where my webserver died. I had to rebuild everything. I forget which version of CF it was, but it wouldn't install. I had to install the previous version first. Luckily I had CDs of many versions with me (the server is co-located an hour from my house). I installed the next most recent version, then tried to install the current version, and it still wasn't happy. I had to go back, unistall CF, then install an even older version, then the current version allowed me to install it. It was a big waste of time - while my webserver was down. It would have been much worse if I didn't have the previous cds with me. That may be an acceptable form of copy protection for a game, but not for a server product, where lost time is money. Al Musella, DPM President Musella Foundation For Brain Tumor Research Information virtualtrials.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Configuring a Datasource on a Different Server
According to other responses I have received, CF by default does not allow access to remote shares for security reasons (makes sense), and uses the local system account. I setup a cfuser account and gave it appropriate NT permissions to the folder I needed and it works. I'm only doing this until I can port the database to the Web server and then I will change it back to the local system account. -Original Message- From: CF [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 4:58 PM To: CF-Talk Subject: Re: Configuring a Datasource on a Different Server I ran into a problem with logins when I did this. In other words, CF is running as a certain user. That user MUST have access to the remote file. I'd like to open a thread on what user CF should run as, cuz I'm un certain about this issues related to it. Thanks, Peter Janett New Media One Web Services WEB HOSTING FOR WEB DEVELOPERS - Sun, IRIX, NT, Linux - PHP, MySQL, Perl, Cold Fusion, MS SQL, ASP, SSI, SSL http://www.newmediaone.net [EMAIL PROTECTED] (303)828-9882 - Original Message - From: Alan Wolf [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 9:06 AM Subject: Configuring a Datasource on a Different Server Is there a way to configure a datasource on another server other than the one CF is running on? I tried \\servername\sharepoint\database.mdb but the verification failed. The machine is another server in my NT domain. I'm running CF 4.5.1 on NT 4 SP5 and IIS 4. Thanks. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFTRANSACTION only works in same page?
i have a complex transaction that i have grouped into multiple includes. i am trying to wrap them into a transaction so that if any part fails, i can rollback. cftransaction action="begin" cfinclude template="part1.cfm" (if exception, rollback) cfinclude template="part2.cfm" (if exception, rollback) cfinclude template="part3.cfm" (if exception, rollback) /cftransaction however, if i have an error in part2, everything in part1 is still committed. AND, if i try to set cftransaction action="rollback"/ to any included file, it gives me an error saying that it's not wrapped in a cftransaction. am i to assume from this that i can't use cftransaction to group includes? seriously? thanx to any that reply -mike -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
date question in Query
This is a multi-part message in MIME format. --=_NextPart_000_0017_01C02930.A6560C40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am running a query to grab values from my db between a range of dates. = the only problem is that it only seems to grab the values from first = date, can someone tell me how I can get dates between the dates picked = on my form using this query? SELECT dt_OrderHistoryHeader.* FROM dt_OrderHistoryHeader,dt_ShipToAddr WHERE dt_OrderHistoryHeader.BusinessunitFK =3D #BusinessUnit# AND dt_OrderHistoryHeader.ShiptoAddrFK =3D dt_ShiptoAddr.ShiptoAddrID AND dt_ShipToAddr.ShiptoAddrID in (SELECT ShipToAddrID from dt_ShipToAddr WHERE dt_ShiptoAddr.ShiptoAddrID =3D dt_OrderHistoryHeader.ShiptoAddrFK) AND DATEVALUE(MID$(dt_OrderHistoryHeader.OrderHistoryDate,3,2)+'/'+ MID$(dt_OrderHistoryHeader.OrderHistoryDate,1,2)+'/'+ MID$(dt_OrderHistoryHeader.OrderHistoryDate,5,4)) =3D = DATEVALUE('#orderhistoryStartDate#') AND DATEVALUE(MID$(dt_OrderHistoryHeader.OrderHistoryDate,3,2)+'/'+ MID$(dt_OrderHistoryHeader.OrderHistoryDate,1,2)+'/'+ MID$(dt_OrderHistoryHeader.OrderHistoryDate,5,4)) = DATEVALUE('#orderhistoryEndDate#') Thanks Ben Densmore --=_NextPart_000_0017_01C02930.A6560C40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I am running a query to grab values = from my db=20 between a range of dates. the only problem is that it only seems to grab = the=20 values from first date, can someone tell me how I can get dates between = the=20 dates picked on my form using this query?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SELECT=20 dt_OrderHistoryHeader.*BRFROMBRdt_OrderHistoryHeader,dt_ShipToAddrBR= WHEREBRdt_OrderHistoryHeader.BusinessunitFK=20 =3D #BusinessUnit#BRANDBRdt_OrderHistoryHeader.ShiptoAddrFK =3D=20 dt_ShiptoAddr.ShiptoAddrIDBRnbsp;ANDBRdt_ShipToAddr.ShiptoAddrID in = (SELECT=20 ShipToAddrID = fromBRdt_ShipToAddrBRWHEREBRdt_ShiptoAddr.ShiptoAddrID =3D=20 dt_OrderHistoryHeader.ShiptoAddrFK)BRANDBRDATEVALUE(MID$(dt_OrderHist= oryHeader.OrderHistoryDate,3,2)+'/'+BRMID$(dt_OrderHistoryHeader.OrderH= istoryDate,1,2)+'/'+BRMID$(dt_OrderHistoryHeader.OrderHistoryDate,5,4))= =20 gt;=3D=20 DATEVALUE('#orderhistoryStartDate#')BRANDBRDATEVALUE(MID$(dt_OrderHis= toryHeader.OrderHistoryDate,3,2)+'/'+BRMID$(dt_OrderHistoryHeader.Order= HistoryDate,1,2)+'/'+BRMID$(dt_OrderHistoryHeader.OrderHistoryDate,5,4)= )=20 lt; DATEVALUE('#orderhistoryEndDate#')/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks/FONT/DIV DIVFONT face=3DArial size=3D2Ben Densmore/FONT/DIV/BODY/HTML --=_NextPart_000_0017_01C02930.A6560C40-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ColdFusion SP2
I'll bet you are running NT or Win2K. You loose your bet, I have win98. It crashes Win98 very quickly. It has the same resource leaks under NT, but NT is just better at handling it. Not mine it doesn't -- James Smith [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Costing vs. Price Fixing
Guy, how long have you been working (since college). Also, not that it really matters, but what did you study in college (or university)? It has been my experience that even new grads can expect at LEAST 30k right out of school in most canadian cities other than Toronto and Vancouver, where it would be more like 40k. So that is about $15/ hour. I think you can get more, and should. Jim - Original Message - From: "Guy J. McDowell" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 8:22 AM Subject: Costing vs. Price Fixing I believe the big difference between costing and price fixing is: Costing - Getting a feel for what is the average cost Price fixing- A majority of the community agreeing to maintain a minimum cost. Salary surveys are everywhere and many job postings carry salary expectations. I just don't see the problem here. I get paid $10/hr for CF, SQL, JavaScript and html analysing/coding/project co-ordination on 6 domains as well as developing an internet marketing strategy for the largest conservation organization in Ontario. But I'm not bitter..;) Guy J. McDowell Webmaster Ontario Federation of Anglers and Hunters -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
In search of security solutions for ColdFusion apps and Unix
Here are some of the issues that I am asked about with regards to Unix and use of Coldfusion: Developers often resist having database user ids and passwords embedded into ColdFusion admin databases. This is not secure (since the ColdFusion admin now has info that they may, in fact, not be cleared to see). What are the alternatives for passing owner and password on through to the underlying database (such as Oracle, etc) If one DOES embed the user id/password, then one still has to implement some sort of security mechanism, since the .cfm files need to be readable by user "nobody" if the web server is running in the default configuration. What practices helps one prevent making modified versions of the .cfm pages and accessing the data? Sometimes a solution is implemented where one runs the ww server as a specific userid. However, this results in an increasing number of servers, which then one has to administrate, deal with upgrades, hangs, etc. Are there some articles addressing these issues and detailing some best practices? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Career Advice?
consider starting a Cold Fusion users group in your area. I have been thinking of doing that in Winnipeg. Got a board room, access to a projector. And a core group to attend. If there are any fellow Winnipeggers that are interested let me know. email me at [EMAIL PROTECTED] Also, is there a CFUG UG? Eric From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF Career Advice? Date: Wed, 27 Sep 2000 16:06:36 -0700 An excellent idea Mark! This definitely helps demonstrate your skills. Also, consider starting a Cold Fusion users group in your area. Announce on CF-TALK that you wish to start one in your area and give a date and time of the first meeting. Encourage "newbies" and non-CF developers to attend to hear what it's all about then give a quick Intro to CF presentation to help get others started. Once they see how easy it is to get started, you'll have a group to work with and can start growing. --Doug -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 8:11 AM To: CF-Talk Subject: RE: CF Career Advice? Build a web site demonstrating your skills in HTML, ColdFusion, and SQL. The best way to learn is to teach someone else, so, perhaps you can put together a tutorial site for other newbies. But anyway, by building the site, you will be accomplishing two things: first off, you'll have created a good web site. Secondly, your potential employer should have no doubts that you know your stuff. In other words, do this, and I can pretty much guarantee that you're going to get a job. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 5:30 AM To: CF-Talk Subject: CF Career Advice? Hello Folks, Wow. I have s much to learn. Just when I think I am getting to know CF, I come across this discussion list and I realize I am barely scratching the surface. I could really use some help in the professional development area. Situation: New college grad working at a province-wide non-profit in a relatively rural area, that wants the world while recompensing me on the same level as McBurger flipper and is not willing to invest anything in professional development. Now the choice here is obvious - get another job! But where? How? Every CF Developer wanted ad asks for far more than I have or can learn in the boondocks. Is anyone looking for a junior CF Developer? (Qualifying factor - in Ontario, Canada or willing to sponsor) I really want to learn so much more about web developing yet I cannot seem to find the opportunities. (Yes, I realize I am whining at this point.) Please advise. Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out all of our websites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. www.OFAH.org - the flagship site of the Ontario Federation of Anglers Hunters. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
RE: Costing vs. Price Fixing
I assume you know you can make more, but you're working for the non-profit because you support its goals. There are things more important than money, fortunately. -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 7:23 AM To: CF-Talk Subject: Costing vs. Price Fixing I believe the big difference between costing and price fixing is: Costing - Getting a feel for what is the average cost Price fixing- A majority of the community agreeing to maintain a minimum cost. Salary surveys are everywhere and many job postings carry salary expectations. I just don't see the problem here. I get paid $10/hr for CF, SQL, JavaScript and html analysing/coding/project co-ordination on 6 domains as well as developing an internet marketing strategy for the largest conservation organization in Ontario. But I'm not bitter..;) Guy J. McDowell Webmaster Ontario Federation of Anglers and Hunters -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: In search of security solutions for ColdFusion apps and Unix
I would suggest sending this to the cf-linux list but... Developers often resist having database user ids and passwords embedded into ColdFusion admin databases. This is not secure (since the ColdFusion admin now has info that they may, in fact, not be cleared to see). What are the alternatives for passing owner and password on through to the underlying database (such as Oracle, etc) Username Passord attributes in CFSTOREDPROC or CFQUERY ??? If one DOES embed the user id/password, then one still has to implement some sort of security mechanism, since the .cfm files need to be readable by user "nobody" if the web server is running in the default configuration. use cfencode ?? Better than nothing but not REALLY secure. What practices helps one prevent making modified versions of the .cfm pages and accessing the data? Readable not writtable ... ~Justin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Career Advice?
CF in the Peg! Who knew? I run the Ottawa group, and have found it a GREAT career boost for me. Contact Amy Brooks at Allaire ([EMAIL PROTECTED]). She runs the CFUGs and is a great person. Jim - Original Message - From: "Eric Dawson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 10:24 AM Subject: RE: CF Career Advice? consider starting a Cold Fusion users group in your area. I have been thinking of doing that in Winnipeg. Got a board room, access to a projector. And a core group to attend. If there are any fellow Winnipeggers that are interested let me know. email me at [EMAIL PROTECTED] Also, is there a CFUG UG? Eric From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF Career Advice? Date: Wed, 27 Sep 2000 16:06:36 -0700 An excellent idea Mark! This definitely helps demonstrate your skills. Also, consider starting a Cold Fusion users group in your area. Announce on CF-TALK that you wish to start one in your area and give a date and time of the first meeting. Encourage "newbies" and non-CF developers to attend to hear what it's all about then give a quick Intro to CF presentation to help get others started. Once they see how easy it is to get started, you'll have a group to work with and can start growing. --Doug -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 8:11 AM To: CF-Talk Subject: RE: CF Career Advice? Build a web site demonstrating your skills in HTML, ColdFusion, and SQL. The best way to learn is to teach someone else, so, perhaps you can put together a tutorial site for other newbies. But anyway, by building the site, you will be accomplishing two things: first off, you'll have created a good web site. Secondly, your potential employer should have no doubts that you know your stuff. In other words, do this, and I can pretty much guarantee that you're going to get a job. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 5:30 AM To: CF-Talk Subject: CF Career Advice? Hello Folks, Wow. I have s much to learn. Just when I think I am getting to know CF, I come across this discussion list and I realize I am barely scratching the surface. I could really use some help in the professional development area. Situation: New college grad working at a province-wide non-profit in a relatively rural area, that wants the world while recompensing me on the same level as McBurger flipper and is not willing to invest anything in professional development. Now the choice here is obvious - get another job! But where? How? Every CF Developer wanted ad asks for far more than I have or can learn in the boondocks. Is anyone looking for a junior CF Developer? (Qualifying factor - in Ontario, Canada or willing to sponsor) I really want to learn so much more about web developing yet I cannot seem to find the opportunities. (Yes, I realize I am whining at this point.) Please advise. Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out all of our websites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. www.OFAH.org - the flagship site of the Ontario Federation of Anglers Hunters. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives:
RE: Webtrends
WHAT?? How are you getting Webtrends Log Analyzer 5.0 to do jpgs? I asked Webtrends if it was possible they said not at this time only PNG files. So I proceeded to tell them what I thought about having a reference to using jpgs in the index but no content on the page it referenced. Typo in the manual. BTW the folder is password protected. And, using the png format most likely would fix your problem. Also check for quality settings with the jpgs. Or try gifs. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Iztok Polanic [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 4:05 AM To: CF-Talk Subject: Webtrends Hi! We are using Webtrends Log Analyzer 5.0 But we found out that pur graphs don't look so good. Here are some examples: http://www.btc-city.com/logs/DEFAULT10.jpg http://www.btc-city.com/logs/DEFAULT22.jpg http://www.btc-city.com/logs/DEFAULT23.jpg How can we change sharpnes in Webtrends reports? Bye, Iztok -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
synchronous vs non-synchronous ccard processing
Does anyone know the difference between synchronous vs non-synchronous credit card processing, and/or where I might learn more about it? ~Simon Simon Horwith Senior Developer Fig Leaf Software, Inc. 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFINCLUDE problems
Can you not include files in the following manner? Notes: CF Server has the mapping, so does IIS, and if you view the page I'm trying to include directly or link to it, it works fine. I am attempting to do this: CFINCLUDE TEMPLATE="/acb/webpage.cfm?WebPage_ID=20DID=9" but when I do this, I get this message: Template file not found. HTTP/1.0 404 Object Not Found Note: If you wish to use an absolute template path (e.g. TEMPLATE="/mypath/index.cfm") with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE="index.cfm" or TEMPLATE="../index.cfm") does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. BUT, if I do this: cfset y="/acb/webpage.cfm?webpage_id=20did=9" CFOUTPUTA HREF="#y#"y/A/CFOUTPUT the link works just fine. Problem is, I don't want a link, I want to include it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Delay
Stop it! You are hogging a Server Thread while you do this. This really is horrendous programming technique. -- From: Simon Horwith[SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 14:32 To: CF-Talk Subject: RE: Delay actually, I think CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount()-Start LT Time" /cfloop Would be most efficient. thanks for correcting me. ~Simon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 2:22 PM To: CF-Talk Subject: Re: Delay why not just use CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount() LT start + Time" /cfloop much shorter and simpler. Will still eat up your CPU though. - Original Message - From: "Simon Horwith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 4:01 PM Subject: RE: Delay slight fix on my end. use MOD to avoid executing on every pass, and GTE because you may exceed the desired delay by a few millisecs.: THIS SHOULD CREATE A ONE MINUTE TIMER!! CFSET tickBegin = GetTickCount() CFLOOP FROM="1" TO = "1" index = "index" CFIF index MOD 100 IS 0 CFSET tickEnd = GetTickCount() CFIF tickEnd - tickBegin GTE 6 CFBREAK /CFIF /CFIF /CFLOOP ~Simon -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 9:14 PM To: CF-Talk Subject: Re: Delay There really should be a 'pause' tag that does not use much cpu. I doubt that I am the first to say this but I will repeat myself on the allaire forums. At 10:06 PM 25/09/00 -0300, you wrote: I use a CFLOOP to create a delay. CFLOOP Index="Timer" From="1" to="15000" STEP="1" /cfloop There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, September 25, 2000 9:58 PM Subject: Delay Can anyone help please? I'm trying to set up a delay in page without using a meta tag. I've tried this but it relocates straight way. Do I need to tell it that the values are specifically dates? TIA! !--- Create a 2 second delay --- CFSET Beginning = Now() CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# CFLOOP condition="Difference LT 2" CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# /CFLOOP !--- Relocate to the menu page --- cflocation url="test_id.cfm" addtoken="No" Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 * ** * This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. * ** * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - -- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To
RE: ColdFusion SP2 -install issues
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I don't remember if SP1 worked this way or not, but my biggest request would be for EVERY new version of CF - be able to be installed without having installed a previous version. CF_Gripe Can I say AMEN to that?! It seems like some versions of CFAS are happy if you just have a previous serial number, but others wanted to see a full application installed. Proof of ownership by providing a serial number seems quite sufficient. Given the incompatibilities introduced by installing certain versions of CFAS, I think it's unreasonable that you need to install an older version and increase your potential for problems. ESPECIALLY when you consider that certain versions of CFAS are know to mess up the MDAC installations on Win2k. It's really inexcusable... I didn't pay for a software subscription to beat my head against the wall every time I try to install the software... /CF_Gripe Sorry... I feel better now... Regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOdNe6QraVoMWBwRBEQLkaACfXZy+LmLMLEz7rfgFACrYGd4/P7cAoNiE RPL9nymRnlc0EqhY0lJuGnAG =zDPe -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cnencode parameters
This is a multi-part message in MIME format. --=_NextPart_000_000B_01C14810.44B36A50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Could anybody please give me a command line to encode a directory? (or = does this have to be done file by file?) Thanks! --=_NextPart_000_000B_01C14810.44B36A50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Could anybody please give me a command = line to=20 encode a directory? (or does this have to be done file by file?)=20 Thanks!/FONT/DIV/BODY/HTML --=_NextPart_000_000B_01C14810.44B36A50-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
Well, if that's what you really want to do, one way would be to set up a datasource reference on each server to the db on the other server, create a list of the datasources, and loop through them on your form action page. CFSET dbList = "db1,db2" CFLOOP index="db" list="dbList" CFQUERY name="whatever" datasource=db DB statements /CFQUERY /CFLOOP -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 4:29 AM To: CF-Talk Subject: I have dual sites running on 2 separate cf servers is there a way that I can update both databases when I am using one of my database update forms so that with one click of the form submit button it will take the form data and update both databases at the same time Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Need some help here, unknown error SQL 7008N
This is a multi-part message in MIME format. --327729A9AA7CC339FC1F4ECE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I checked to see what the error meant and it said this: SQL7008N REXX variable "variable" contains inconsistent data. Cause: A variable that contained inconsistent data was passed to REXX. The command cannot be processed. Action: If the variable is an SQLDA, verify that the data and length fields have been assigned correctly. If it is a REXX variable, verify that the type of data is appropriate to the command where it is being used. What is a REXX varible anyway? I checked my data types and lengths and they all check out. What could be causing this error??? I am using AS/400 on the back-end. cfquery name="NewRequest" datasource="OIMDBADM" insert into oimdbadm.newreq (time, date, agency, reqtype, requester, req_email, phone, due_date, title, descrip, id, assigned) values ('#time#', '#date#', '#form.agency#', '#form.reqtype#', '#form.requester#', '#form.req_email#', '#form.phone#', '#form.due_date#', '#form.title#', '#form.descrip#', '#form.id#', '#form.assigned#') /cfquery --327729A9AA7CC339FC1F4ECE Content-Type: text/x-vcard; charset=us-ascii; name="jtaavon.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for James Taavon Content-Disposition: attachment; filename="jtaavon.vcf" begin:vcard n:Taavon;James tel;cell:(443) 506-2117 tel;fax:(410) 333-5203 tel;work:(410) 767-3415 x-mozilla-html:FALSE org:Department of Labor, Licensing and Regulation;Office of Information and Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Senior Web Developer adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201; fn:James Taavon end:vcard --327729A9AA7CC339FC1F4ECE-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
quick question
What is the information in CGI.HTTP_USER_AGENT? For Netscape I get: Mozilla/4.08 [en] (Win98; U ;Nav) and for IE I get: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98) I am writing a page logging application, and I would like to know as much about the user as possible. What can I do about taking this information and (say) extracting the OS information? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Delay
correct. I don't preach server side timers, I just replied to somebody's question. They need a timer, written in CF and running server-side only. This was the best code I could come up with to do that. I think what they are actually after is something like a 10 second delay, not one minute, but the code is still the best I can think of. Any suggestions as to a better way to do this ON THE SERVER? ~Simon -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:15 AM To: CF-Talk Subject: RE: Delay Stop it! You are hogging a Server Thread while you do this. This really is horrendous programming technique. -- From: Simon Horwith[SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 14:32 To: CF-Talk Subject: RE: Delay actually, I think CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount()-Start LT Time" /cfloop Would be most efficient. thanks for correcting me. ~Simon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 2:22 PM To: CF-Talk Subject: Re: Delay why not just use CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount() LT start + Time" /cfloop much shorter and simpler. Will still eat up your CPU though. - Original Message - From: "Simon Horwith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 4:01 PM Subject: RE: Delay slight fix on my end. use MOD to avoid executing on every pass, and GTE because you may exceed the desired delay by a few millisecs.: THIS SHOULD CREATE A ONE MINUTE TIMER!! CFSET tickBegin = GetTickCount() CFLOOP FROM="1" TO = "1" index = "index" CFIF index MOD 100 IS 0 CFSET tickEnd = GetTickCount() CFIF tickEnd - tickBegin GTE 6 CFBREAK /CFIF /CFIF /CFLOOP ~Simon -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 9:14 PM To: CF-Talk Subject: Re: Delay There really should be a 'pause' tag that does not use much cpu. I doubt that I am the first to say this but I will repeat myself on the allaire forums. At 10:06 PM 25/09/00 -0300, you wrote: I use a CFLOOP to create a delay. CFLOOP Index="Timer" From="1" to="15000" STEP="1" /cfloop There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, September 25, 2000 9:58 PM Subject: Delay Can anyone help please? I'm trying to set up a delay in page without using a meta tag. I've tried this but it relocates straight way. Do I need to tell it that the values are specifically dates? TIA! !--- Create a 2 second delay --- CFSET Beginning = Now() CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# CFLOOP condition="Difference LT 2" CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# /CFLOOP !--- Relocate to the menu page --- cflocation url="test_id.cfm" addtoken="No" Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 * ** * This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. * ** * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - -- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
Re: Delay
WaitFor 1.0 Using this component you can pause your ASP app for a specified time, wait until a file exists or wait until the component can get exclusive read/write permissions to a file http://www.serverobjects.com/comp/waitfor.zip Use it with CFOBJECT and save in processing. NEVER USE CFLOOP FOR A WAIT PROCESS!!! Stop it! You are hogging a Server Thread while you do this. This really is horrendous programming technique. -- From: Simon Horwith[SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 14:32 To: CF-Talk Subject: RE: Delay actually, I think CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount()-Start LT Time" /cfloop Would be most efficient. thanks for correcting me. ~Simon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 2:22 PM To: CF-Talk Subject: Re: Delay why not just use CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount() LT start + Time" /cfloop much shorter and simpler. Will still eat up your CPU though. - Original Message - From: "Simon Horwith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 4:01 PM Subject: RE: Delay slight fix on my end. use MOD to avoid executing on every pass, and GTE because you may exceed the desired delay by a few millisecs.: THIS SHOULD CREATE A ONE MINUTE TIMER!! CFSET tickBegin = GetTickCount() CFLOOP FROM="1" TO = "1" index = "index" CFIF index MOD 100 IS 0 CFSET tickEnd = GetTickCount() CFIF tickEnd - tickBegin GTE 6 CFBREAK /CFIF /CFIF /CFLOOP ~Simon -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 9:14 PM To: CF-Talk Subject: Re: Delay There really should be a 'pause' tag that does not use much cpu. I doubt that I am the first to say this but I will repeat myself on the allaire forums. At 10:06 PM 25/09/00 -0300, you wrote: I use a CFLOOP to create a delay. CFLOOP Index="Timer" From="1" to="15000" STEP="1" /cfloop There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, September 25, 2000 9:58 PM Subject: Delay Can anyone help please? I'm trying to set up a delay in page without using a meta tag. I've tried this but it relocates straight way. Do I need to tell it that the values are specifically dates? TIA! !--- Create a 2 second delay --- CFSET Beginning = Now() CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# CFLOOP condition="Difference LT 2" CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# /CFLOOP !--- Relocate to the menu page --- cflocation url="test_id.cfm" addtoken="No" Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 * ** * This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. * ** * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - -- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFINCLUDE problems
The answer is in that message; it thinks you're referencing and absolute path. Use the relative path syntax if you don't want to create a mapping. -Original Message- From: Gina Shillitani [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 10:21 AM To: CF-Talk Subject: CFINCLUDE problems Can you not include files in the following manner? Notes: CF Server has the mapping, so does IIS, and if you view the page I'm trying to include directly or link to it, it works fine. I am attempting to do this: CFINCLUDE TEMPLATE="/acb/webpage.cfm?WebPage_ID=20DID=9" but when I do this, I get this message: Template file not found. HTTP/1.0 404 Object Not Found Note: If you wish to use an absolute template path (e.g. TEMPLATE="/mypath/index.cfm") with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE="index.cfm" or TEMPLATE="../index.cfm") does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. BUT, if I do this: cfset y="/acb/webpage.cfm?webpage_id=20did=9" CFOUTPUTA HREF="#y#"y/A/CFOUTPUT the link works just fine. Problem is, I don't want a link, I want to include it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Career Advice?
In Canada is Cold Fusion not that Cold :) I couldn't resist :) Neil - Original Message - From: "Eric Dawson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 28, 2000 10:24 AM Subject: RE: CF Career Advice? consider starting a Cold Fusion users group in your area. I have been thinking of doing that in Winnipeg. Got a board room, access to a projector. And a core group to attend. If there are any fellow Winnipeggers that are interested let me know. email me at [EMAIL PROTECTED] Also, is there a CFUG UG? Eric From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF Career Advice? Date: Wed, 27 Sep 2000 16:06:36 -0700 An excellent idea Mark! This definitely helps demonstrate your skills. Also, consider starting a Cold Fusion users group in your area. Announce on CF-TALK that you wish to start one in your area and give a date and time of the first meeting. Encourage "newbies" and non-CF developers to attend to hear what it's all about then give a quick Intro to CF presentation to help get others started. Once they see how easy it is to get started, you'll have a group to work with and can start growing. --Doug -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 8:11 AM To: CF-Talk Subject: RE: CF Career Advice? Build a web site demonstrating your skills in HTML, ColdFusion, and SQL. The best way to learn is to teach someone else, so, perhaps you can put together a tutorial site for other newbies. But anyway, by building the site, you will be accomplishing two things: first off, you'll have created a good web site. Secondly, your potential employer should have no doubts that you know your stuff. In other words, do this, and I can pretty much guarantee that you're going to get a job. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 5:30 AM To: CF-Talk Subject: CF Career Advice? Hello Folks, Wow. I have s much to learn. Just when I think I am getting to know CF, I come across this discussion list and I realize I am barely scratching the surface. I could really use some help in the professional development area. Situation: New college grad working at a province-wide non-profit in a relatively rural area, that wants the world while recompensing me on the same level as McBurger flipper and is not willing to invest anything in professional development. Now the choice here is obvious - get another job! But where? How? Every CF Developer wanted ad asks for far more than I have or can learn in the boondocks. Is anyone looking for a junior CF Developer? (Qualifying factor - in Ontario, Canada or willing to sponsor) I really want to learn so much more about web developing yet I cannot seem to find the opportunities. (Yes, I realize I am whining at this point.) Please advise. Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out all of our websites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. www.OFAH.org - the flagship site of the Ontario Federation of Anglers Hunters. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit
Re: Combo box
There's an unencryted (modifiable) tag available on the Allaire Site (called ComboBox.cfm) that does precisely what you want to do -- using Javascript to divide the functionality between the two form elements and allowing each to influence and know (somewhat) what the other is doing. If you want to see how this tag operates I make use of it on my CoGasPrices.com site in the modify section allowing users to modify a record by selecting an existing field value OR to enter new data that will then be available for selection the next time. You can check it out at -- http://www.cogasprices.com/in_mod.cfm?stationID=407 Just in case anyone else has energy to put into this -- I do intend to modify this tag to address a couple of shortcomings (the author concedes it was done in haste) such as returning a previous initial "value" to the "other" tag when it regains focus and a couple of other things I need for it do that it presently doesn't. Should anyone else improve on this tag please do let me know so I don't reinvent the wheel -- and if there is any interest I'll be glad to advise of what modifications I make to it. If someone has already done a better job delivering this functionality (with a tag or straight code) that this tag does -- I would also sure like to hear about that. Thanks, Dru At 20:52 8/14/2000 -0700, you wrote: ASP Today has a good article, "Using JavaScript to Create Combo Boxes," to do as Philip suggests. See http://www.asptoday.com/articles/2808.htm -David On Wed, 9 Aug 2000 11:14:33 +0100 "Philip Arnold - ASP" [EMAIL PROTECTED] writes: Does anyone have some nifty code that lets me have a combo box, ie. an input type=text field combined with a collection of hardcoded choices in an input type=select? Do I just have text input field with the same name as the select box? How does this work? You're running into a HTML limit here What I do is put an "Other" option at the bottom of the Select, and have a text box for entering the Other option into YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: TO ALL: Request for ColdFusion SP2 Input
Peter: We do not have control over the Sybase drivers on linux that you are speaking about. Those come directly from Sybase, and Sybase has publicly stated that the drivers a non-thread-safe due to the whacked threading model on Linux. I agree with them, the threading model has been whacked, however, with the 2.4 kernel, the threading model has been re-written to allow for a better threading structure and model. Time will have to tell on this one. disclosure: i work for allaire, and am also a linux developer -Jesse -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 1:46 AM To: CF-Talk Subject: Re: TO ALL: Request for ColdFusion SP2 Input Thread-safe Sybase drivers on Linux would be nice :-) At 08:50 AM 9/27/00 -0400, Damon Cooper wrote: Folks, ColdFusion Service Pack 2 is under construction, and I'd like to get your feedback on what you believe to be Must-Be-Fixed items. While Service Pack 1 focused heavily on stability and performance issues (across platform and Unix-specific), we'd like to nail as many serious feature and tag bugs as possible, although the release cycle will be significantly shorter (shooting for an early November release). Currently, here's a summary of bug fixes slated for SP2: 18965 Native Oracle CLOB support 18389 Security/Solaris Cfexec restart of Security Proxy 17873 Informix 2.3 2.5 client lib support 15776 CFMAIL recipients truncated at 246 characters 18191,18237,18314 CFHTTP Post failure (but redirects must still be an absolute url) 18338, 17121LSNumberFormat and NumberFormat problems 16663 MIME attached over regular WAP gateway (UTF-8). 19010 CFFILE/move problem on Unix file systems 17601 COM Threading Model Changes 18311 CFHTTP 'Connection Failure' error if the status code is 204 18246 CFPOP unknown exception condition 18811 POP3 enhancement 18058, 16875Applet interface in CFAdmin problems with parm fields 18607 MSAccess bug hangs CF on Win2k/SP1 18579 Secuirty Administration Bug - cfm file change 17543 Locale Date Support - Solaris 10115 European dates broken in Solaris CF 4.5+ 19003 CFFTP connection bug 12523 Unix, LSParseDateTime only functions for US english. 18991 CFHTTP on Linux crash with 4k content 18234, 17792MS SQLServer problems on Linux 18778 Scheduled tasks don't run with CFREGISTRY disabled I can't promise anything, but this release is for you, and I want to make sure you're heard. Please either post to the list or send email directly to me at [EMAIL PROTECTED] and reference your Allaire Issue/Bug # if you have one. Thanks Damon Cooper ColdFusion Release Manager Allaire - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: quick question
Hi Simon, I am currently working on a similar project... ick question What is the information in CGI.HTTP_USER_AGENT? For Netscape I get: Mozilla/4.08 [en] (Win98; U ;Nav) and for IE I get: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98) These values are provided by the browser and as such are provided in any format that Netscape or IE chooses. I don't see much option but to capture the results from a variety of browsers and then write code to compensate for each type. Mozilla is an organization that produced one of the first open-source browsers and such has been cloned to a greater or lesser degree by these browsers. You can access www.mozilla.org for more info. Mozilla sounds like a cross between a Japanese monster and a stooge. Regards, Anthony Geoghegan. Lead Developer, IFTN http://www.wow.ie mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Delay
egg-knowledged!! use of a COM object would definitely be the best way to do this. Whether or not that method is available to whomever originally posed the question of how to create a server side pause with cf code, is a mystery. If he has access to CFOBJECT, this is a much better solution. ~Simon -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:49 AM To: CF-Talk Subject: Re: Delay WaitFor 1.0 Using this component you can pause your ASP app for a specified time, wait until a file exists or wait until the component can get exclusive read/write permissions to a file http://www.serverobjects.com/comp/waitfor.zip Use it with CFOBJECT and save in processing. NEVER USE CFLOOP FOR A WAIT PROCESS!!! Stop it! You are hogging a Server Thread while you do this. This really is horrendous programming technique. -- From: Simon Horwith[SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 14:32 To: CF-Talk Subject: RE: Delay actually, I think CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount()-Start LT Time" /cfloop Would be most efficient. thanks for correcting me. ~Simon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 2:22 PM To: CF-Talk Subject: Re: Delay why not just use CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount() LT start + Time" /cfloop much shorter and simpler. Will still eat up your CPU though. - Original Message - From: "Simon Horwith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 4:01 PM Subject: RE: Delay slight fix on my end. use MOD to avoid executing on every pass, and GTE because you may exceed the desired delay by a few millisecs.: THIS SHOULD CREATE A ONE MINUTE TIMER!! CFSET tickBegin = GetTickCount() CFLOOP FROM="1" TO = "1" index = "index" CFIF index MOD 100 IS 0 CFSET tickEnd = GetTickCount() CFIF tickEnd - tickBegin GTE 6 CFBREAK /CFIF /CFIF /CFLOOP ~Simon -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 9:14 PM To: CF-Talk Subject: Re: Delay There really should be a 'pause' tag that does not use much cpu. I doubt that I am the first to say this but I will repeat myself on the allaire forums. At 10:06 PM 25/09/00 -0300, you wrote: I use a CFLOOP to create a delay. CFLOOP Index="Timer" From="1" to="15000" STEP="1" /cfloop There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, September 25, 2000 9:58 PM Subject: Delay Can anyone help please? I'm trying to set up a delay in page without using a meta tag. I've tried this but it relocates straight way. Do I need to tell it that the values are specifically dates? TIA! !--- Create a 2 second delay --- CFSET Beginning = Now() CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# CFLOOP condition="Difference LT 2" CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# /CFLOOP !--- Relocate to the menu page --- cflocation url="test_id.cfm" addtoken="No" Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 * ** * This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. * ** * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit
RE: Delay
CF_BLOCK P. -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:36 AM To: CF-Talk Subject: RE: Delay correct. I don't preach server side timers, I just replied to somebody's question. They need a timer, written in CF and running server-side only. This was the best code I could come up with to do that. I think what they are actually after is something like a 10 second delay, not one minute, but the code is still the best I can think of. Any suggestions as to a better way to do this ON THE SERVER? ~Simon -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:15 AM To: CF-Talk Subject: RE: Delay Stop it! You are hogging a Server Thread while you do this. This really is horrendous programming technique. -- From: Simon Horwith[SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 14:32 To: CF-Talk Subject: RE: Delay actually, I think CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount()-Start LT Time" /cfloop Would be most efficient. thanks for correcting me. ~Simon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 2:22 PM To: CF-Talk Subject: Re: Delay why not just use CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount() LT start + Time" /cfloop much shorter and simpler. Will still eat up your CPU though. - Original Message - From: "Simon Horwith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 4:01 PM Subject: RE: Delay slight fix on my end. use MOD to avoid executing on every pass, and GTE because you may exceed the desired delay by a few millisecs.: THIS SHOULD CREATE A ONE MINUTE TIMER!! CFSET tickBegin = GetTickCount() CFLOOP FROM="1" TO = "1" index = "index" CFIF index MOD 100 IS 0 CFSET tickEnd = GetTickCount() CFIF tickEnd - tickBegin GTE 6 CFBREAK /CFIF /CFIF /CFLOOP ~Simon -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 9:14 PM To: CF-Talk Subject: Re: Delay There really should be a 'pause' tag that does not use much cpu. I doubt that I am the first to say this but I will repeat myself on the allaire forums. At 10:06 PM 25/09/00 -0300, you wrote: I use a CFLOOP to create a delay. CFLOOP Index="Timer" From="1" to="15000" STEP="1" /cfloop There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, September 25, 2000 9:58 PM Subject: Delay Can anyone help please? I'm trying to set up a delay in page without using a meta tag. I've tried this but it relocates straight way. Do I need to tell it that the values are specifically dates? TIA! !--- Create a 2 second delay --- CFSET Beginning = Now() CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# CFLOOP condition="Difference LT 2" CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# /CFLOOP !--- Relocate to the menu page --- cflocation url="test_id.cfm" addtoken="No" Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 * ** * This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. * ** * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - -- ---
RE: Delay
what is cf_block? ~Simon -Original Message- From: Peter Stolz [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:57 AM To: CF-Talk Subject: RE: Delay CF_BLOCK P. -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:36 AM To: CF-Talk Subject: RE: Delay correct. I don't preach server side timers, I just replied to somebody's question. They need a timer, written in CF and running server-side only. This was the best code I could come up with to do that. I think what they are actually after is something like a 10 second delay, not one minute, but the code is still the best I can think of. Any suggestions as to a better way to do this ON THE SERVER? ~Simon -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:15 AM To: CF-Talk Subject: RE: Delay Stop it! You are hogging a Server Thread while you do this. This really is horrendous programming technique. -- From: Simon Horwith[SMTP:[EMAIL PROTECTED]] Sent: 28 September 2000 14:32 To: CF-Talk Subject: RE: Delay actually, I think CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount()-Start LT Time" /cfloop Would be most efficient. thanks for correcting me. ~Simon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 2:22 PM To: CF-Talk Subject: Re: Delay why not just use CFSET Start=GetTickCount() CFSET Time=6 cfloop condition="GetTickCount() LT start + Time" /cfloop much shorter and simpler. Will still eat up your CPU though. - Original Message - From: "Simon Horwith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, September 27, 2000 4:01 PM Subject: RE: Delay slight fix on my end. use MOD to avoid executing on every pass, and GTE because you may exceed the desired delay by a few millisecs.: THIS SHOULD CREATE A ONE MINUTE TIMER!! CFSET tickBegin = GetTickCount() CFLOOP FROM="1" TO = "1" index = "index" CFIF index MOD 100 IS 0 CFSET tickEnd = GetTickCount() CFIF tickEnd - tickBegin GTE 6 CFBREAK /CFIF /CFIF /CFLOOP ~Simon -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 9:14 PM To: CF-Talk Subject: Re: Delay There really should be a 'pause' tag that does not use much cpu. I doubt that I am the first to say this but I will repeat myself on the allaire forums. At 10:06 PM 25/09/00 -0300, you wrote: I use a CFLOOP to create a delay. CFLOOP Index="Timer" From="1" to="15000" STEP="1" /cfloop There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, September 25, 2000 9:58 PM Subject: Delay Can anyone help please? I'm trying to set up a delay in page without using a meta tag. I've tried this but it relocates straight way. Do I need to tell it that the values are specifically dates? TIA! !--- Create a 2 second delay --- CFSET Beginning = Now() CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# CFLOOP condition="Difference LT 2" CFSET Ending = Now() CFSET Difference = #DateDiff( "s", Beginning, Ending )# /CFLOOP !--- Relocate to the menu page --- cflocation url="test_id.cfm" addtoken="No" Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 * ** * This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. * ** * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
RE: CFINCLUDE problems
I did create the mapping though... it is in CF Server: Logical Path Directory Path / C:\INETPUB\WWWROOT\ /acb/ C:\Inetpub\wwwroot\acb\acb\ -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:44 AM To: CF-Talk Subject: RE: CFINCLUDE problems The answer is in that message; it thinks you're referencing and absolute path. Use the relative path syntax if you don't want to create a mapping. -Original Message- From: Gina Shillitani [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 10:21 AM To: CF-Talk Subject: CFINCLUDE problems Can you not include files in the following manner? Notes: CF Server has the mapping, so does IIS, and if you view the page I'm trying to include directly or link to it, it works fine. I am attempting to do this: CFINCLUDE TEMPLATE="/acb/webpage.cfm?WebPage_ID=20DID=9" but when I do this, I get this message: Template file not found. HTTP/1.0 404 Object Not Found Note: If you wish to use an absolute template path (e.g. TEMPLATE="/mypath/index.cfm") with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE="index.cfm" or TEMPLATE="../index.cfm") does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. BUT, if I do this: cfset y="/acb/webpage.cfm?webpage_id=20did=9" CFOUTPUTA HREF="#y#"y/A/CFOUTPUT the link works just fine. Problem is, I don't want a link, I want to include it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: TO ALL: Request for ColdFusion SP2 Input
Peter, the Sybase Open Client for Linux threading issue has nothing to do with Allaire or ColdFusion. The issue is that Open Client for Linux is currently single threaded. From Sybase: "The current releases of OpenClient for Linux are NOT thread-safe. I'm told this is because of the thread-safe issues within Linux the libio - libpthread combination. Much development work is going on within this arena. We have decided with not releasing the threadsafe libraries until the known LinuxThreads issues are resolved." "...the Linux OpenClient 11.1.1 version is not thread safe. It is scheduled for 12.5 the last time I looked." Here are some references: http://webforums.sybase.com/nntp/nd58.nsf/docid/7f2c456f0362933d67523d4c c92f8a4d http://webforums.sybase.com/nntp/nd58.nsf/docid/735711d681681b03ad4743cc 3da7c977 http://webforums.sybase.com/nntp/nd33.nsf/docid/c403d2b1120d10c5bcbc605e f832ba6f - Date: Thu, 28 Sep 2000 01:45:39 -0400 From: Peter Theobald [EMAIL PROTECTED] To: Damon Cooper [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: TO ALL: Request for ColdFusion SP2 Input Message-ID: [EMAIL PROTECTED] Thread-safe Sybase drivers on Linux would be nice :-) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Delay
I think the CFX_Sleep tag someone mentioned sounds perfect. Maybe someone mentioned some problems with this method that I missed or something. RPS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.