RE: History list
Thanks Jon - didn't consider cookies and haven't used them before. This also assumes that the end user has cookies enabled. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 August 2000 4:43:PM To: [EMAIL PROTECTED] Subject: Re: History list What about setting cookies? Use five cookies named LocationX and on each page loop through them all and append the current page and remove the oldest. Then loop through the cookies and print the links. Jon - Original Message - From: Parker, Kevin <[EMAIL PROTECTED]> To: CF Talk (E-mail) <[EMAIL PROTECTED]> Sent: Friday, August 11, 2000 12:45 AM Subject: History list > This may actually be best achieved with a JavaScript solution so I apologise > if some regard it as OT. > > We're deploying one of our large manuals to the web (which is currently > distributed as a Win 3.1 help file - those were the days) as HTML. One of > its features (the win help version) is that it has a history function and > users can back track. I want to try an emulate this for the last 5 or so > pages the user was on. > > I know you can do this by using a href and using history - 1, history -2 etc > but rather than have a simple image or bit of static text with a link I want > to actually try to produce a small list with the name of the page they were > on, linked to that page (the link can use history -1 etc but I want to > actually get the name of the page if I can). After all users won't remember > what the page was 5 clicks ago but it will help them if they can see the > name of the page. The history function in JavaScript doesn't appear to > provide this info. > > Any clue please. > > > > 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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Latest WDDX_COM.DLL
In-Reply-To: <001401c00317$c18f77b0$[EMAIL PROTECTED]> Thanks, Dave Terry Riley Riley Varea Associates, London, UK --Original Message-- > > Can anyone enlighten me as to the latest version of the WDDX > > COM object? > > > > I can't find anything on the Allaire site that shows that > > anything has been 'issued' since the 4.0.1 upgrade. > > > > The one on my machine is version 1,0,0,1 dated 9 April 99. > > Have you checked http://www.wddx.org/? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: History list
What about setting cookies? Use five cookies named LocationX and on each page loop through them all and append the current page and remove the oldest. Then loop through the cookies and print the links. Jon - Original Message - From: Parker, Kevin <[EMAIL PROTECTED]> To: CF Talk (E-mail) <[EMAIL PROTECTED]> Sent: Friday, August 11, 2000 12:45 AM Subject: History list > This may actually be best achieved with a JavaScript solution so I apologise > if some regard it as OT. > > We're deploying one of our large manuals to the web (which is currently > distributed as a Win 3.1 help file - those were the days) as HTML. One of > its features (the win help version) is that it has a history function and > users can back track. I want to try an emulate this for the last 5 or so > pages the user was on. > > I know you can do this by using a href and using history - 1, history -2 etc > but rather than have a simple image or bit of static text with a link I want > to actually try to produce a small list with the name of the page they were > on, linked to that page (the link can use history -1 etc but I want to > actually get the name of the page if I can). After all users won't remember > what the page was 5 clicks ago but it will help them if they can see the > name of the page. The history function in JavaScript doesn't appear to > provide this info. > > Any clue please. > > > > 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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
History list
This may actually be best achieved with a JavaScript solution so I apologise if some regard it as OT. We're deploying one of our large manuals to the web (which is currently distributed as a Win 3.1 help file - those were the days) as HTML. One of its features (the win help version) is that it has a history function and users can back track. I want to try an emulate this for the last 5 or so pages the user was on. I know you can do this by using a href and using history - 1, history -2 etc but rather than have a simple image or bit of static text with a link I want to actually try to produce a small list with the name of the page they were on, linked to that page (the link can use history -1 etc but I want to actually get the name of the page if I can). After all users won't remember what the page was 5 clicks ago but it will help them if they can see the name of the page. The history function in JavaScript doesn't appear to provide this info. Any clue please. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Certified?
I took the beta and most of the people at my office took the 'normal' version. There's a list of who took it on the Allaire site: http://www.allaire.com/handlers/index.cfm?ID=16642 > Has anyone taken the Allaire CF Certification test yet? > > -John- > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
> In getcontent.cfm, it set thistag.generatedcontent="", which did > not seem to > work when calling with cfmodule. That's weird. I just tried this: file1.cfm: Comment this out using cf_ Comment this out using cfmodule file2.cfm: "> and it worked fine. Maybe in some circumstance it doesn't work? But in this simple case it does. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF, ODBC and 64k data
> > Is there some imposed limit which would cause CF accessing an > > MSSQL7 db thru > > ODBC? I am trying to submit 64k + of data via a post but the data > > is getting > > truncated. Has anyone else ever seen this? Is there a work > around or fix? > > > > Duane, > > Something that came up in discusion on the UK CFUG Dev List that you might > be interested in > > We were dicussion ODBC vs OLE DSNs for Access databases. > Allaire recommends that you use OLE as the connection to databases for > robustness. However, thats not what I'm trying to say. It came > up that OLE > is actually the native database connection method for SQL7 and therefore > Access2000 (as it uses the SQL7 db engine). > > Whether using OLE instead of ODBC will solve your data size > problem or not I > don't (having never really used OLE), but it will help with robustness and > performance. I believe that the ODBC drivers for SQLServer7 are actually native drivers. Microsoft just put an ODBC interface on it. I think I heard this being discussed at CFUN-2K. Duane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: VERY SAD (was )
> > We tried using the applets for a couple of internet > > applications and had very limited success. The applets > > would load sporadically on end user's machines. Netscape > > would rarely display the applets. IE was much better but > > sometimes pages would require refreshes to get the applets > > to load. We haven't tried the applets since early 4.01 so > > they may have been improved since. > > That's interesting. We've never used them for real internet applications, > but we used to use them quite a bit for intranet applications, > and were very > successful in that regard. For example, we deployed an application where > there were several thousand clients, all using Netscape 3 or 4, and no one > reported that as a problem. > > However, I'd agree that they're not suitable for non-controlled > environments, as people might not have Java enabled, or might not have > virtual machines, or might have a Java-killing firewall setup. It got to the point that our clients "requested" (AKA ordered) us to remove them from their sites. There customers were complaining quite a bit. We removed them and never looked back. In any instance now where we would consider using a CFGRID - usually in an admin section, we use and warn users that IE is required. I am in the process of investigating ways of using flash instead of . Duane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT eWebeditPro & CFML
> Duane, > > Here is the best way that I can find to accomplish this. > > Create the eWebEditPro variable in the editor, and in places > where the CFML > was going to go, insert a place marker, such as > %location1%, %location2%, etc Then when it comes time for CF > to display > the output after it is retrieved from the database, perform the required > replace functions on the place markers as in > . After all of > the replace functions have been performed on all of the place markers, > simply display the value of the variable, and your dynamic data > is enclosed > within. > > There might be a better way, but no that I can think of at the > moment. This > way allows all of your formatting to stay in place and the place > markers are > already there for the data to go into. > > Let me know what you think. Great idea! I'll have tech support post it as a solution to this. Thanks Dan, Duane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
There was no error, it just did not work the same as when run without cfmodule. As in: ... produced different output to ... In getcontent.cfm, it set thistag.generatedcontent="", which did not seem to work when calling with cfmodule. Perhaps cfmodule sends a complete copy of the environment to the tag, whereas the tag would normally receive a reference to the actual environment (and so could modify it). David Matthew Walker wrote: > > > I would actually disagree with that. > > > > Someone in our office tried calling a custom tag that alters the generated > > content with cfmodule, and it did not work correctly, even though > > it worked when > > called the standard way. He used at the end too. > > What are you disagreeing with? I have it working fine. Using is > not a non-standard way. What was the error? > > * you can use instead of > * you can use instead of > > > Are there any functional differences between using and ? > Apart from how you specify the location of the template, I'm not aware of > any. That doesn't mean there aren't any, because there are a lot of things > I'm not aware of. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Preventing Browsers Cacheing a .cfm file
A bit hefty, but it's the technically correct method, and one of the few that will AOL's proxies will pay attention to: Michael J. Sheldon http://www.desertraven.com/ Make a fast friend, adopt a greyhound! -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 20:45 To: [EMAIL PROTECTED] Subject: Preventing Browsers Cacheing a .cfm file This is a multi-part message in MIME format. --=_NextPart_000_00C4_01C0039A.5121F240 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is the a code that will successfully prevent a .cfm page from being = cached on a users browser that will work effectively across browsers Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] --=_NextPart_000_00C4_01C0039A.5121F240 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is the a code that will successfully = prevent a =20 .cfm page from being cached on a users browser that will work = effectively across=20 browsers Kind Regards Claude Raiola=20 (Director)AustralianAccommodation.com Pty. Ltd.Website: http://www.AustralianAccommodation.com">www.AustralianAccommodati= on.comEmail:=20 mailto:[EMAIL PROTECTED]">Director@AustralianA= ccommodation.com --=_NextPart_000_00C4_01C0039A.5121F240-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
> I would actually disagree with that. > > Someone in our office tried calling a custom tag that alters the generated > content with cfmodule, and it did not work correctly, even though > it worked when > called the standard way. He used at the end too. What are you disagreeing with? I have it working fine. Using is not a non-standard way. What was the error? * you can use instead of * you can use instead of Are there any functional differences between using and ? Apart from how you specify the location of the template, I'm not aware of any. That doesn't mean there aren't any, because there are a lot of things I'm not aware of. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problem carrying over form values.
You can try replacing the " with some string you know the person will not enter, like §, or some other character entity. Then you can get that data from the hidden form field and convert it back before entering it into the database. Jason Web Application Developer webworld studios, inc. -Original Message- From: ColdFusionKid [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 4:25 PM To: [EMAIL PROTECTED] Subject: Problem carrying over form values. Hey guys, I was hoping you could help me on this one... Ok, on one of my forms I have a textarea field that people will type stuff in. Then, they press submit and it goes to a page that displays what they typed and lets them 'approve' it before actually entering it into the database. It all works fine unless they type in something like this in one of the text area pages: The dog said, "Hey now!" Then when they press 'submit' and go to the page that lets them look everything over before they add it into the database I carry the fields over my putting them on that page as hidden fields. The problem is, the " " around the words Hey now! will make one of the hidden fields look like this: So the only thing that makes it into the database is "The dog said, ". How do I get around this? What is the correct way to carry the form fields across multiple pages without this error happening? I know I could do something like replacing all the " " with nothing, but I'd like to keep the formatting of the person's original message. Can I do this? Please help, thanks! Cody - Original Message - From: "Dan Haley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 3:10 PM Subject: RE: Comma/Number Problem > Wow, take back what I said in my last message . . . I could have sworn the > last time this came up I tested it, and it worked . . . val("10,500") DOES > NOT equal 10500. It must be because CF thinks 10,500 is a list, but > val("10,500") comes back as 10. > > Slap me silly on this one . . . go with the "cleanNumber" setup mentioned by > Sean G. > > Dan > > -Original Message- > From: Don Vawter [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 12:26 PM > To: [EMAIL PROTECTED] > Subject: Re: Comma/Number Problem > > > How about newstring=replace(oldstring,",","","ALL") > > - Original Message - > From: "S R" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, August 10, 2000 1:24 PM > Subject: Comma/Number Problem > > > > Hi, > > > > I am trying to add a bunch of numbers to get a total value. It works fine > > unless someone uses a comma to separate 'thousands': > > > > Ex. 10,500 > > > > How do I get rid of the comma before I add it up?? > > > > EX. 10500 > > > > Thanks > > > > Sal > > > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=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=lists&body=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?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Preventing Browsers Cacheing a .cfm file
>Is the a code that will successfully prevent a .cfm page from being = >cached on a users browser that will work effectively across browsers Yes. You should set up a variable (preferably in your application.cfm) that sets a random number and append that to all your URLs, eg: Click here to go to the non-cached page The URL will end up something like: newpage.cfm?nc=12314. The dummy argument is ignored by the browser. This will force the browser to get new pages because all the URLs are different. I had big caching problems with Mac Internet Explorer 4.5 before implementing this. Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Preventing Browsers Cacheing a .cfm file
This is a multi-part message in MIME format. --=_NextPart_000_00C4_01C0039A.5121F240 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is the a code that will successfully prevent a .cfm page from being = cached on a users browser that will work effectively across browsers Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] --=_NextPart_000_00C4_01C0039A.5121F240 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is the a code that will successfully = prevent a =20 .cfm page from being cached on a users browser that will work = effectively across=20 browsers Kind Regards Claude Raiola=20 (Director)AustralianAccommodation.com Pty. Ltd.Website: http://www.AustralianAccommodation.com">www.AustralianAccommodati= on.comEmail:=20 mailto:[EMAIL PROTECTED]">Director@AustralianA= ccommodation.com --=_NextPart_000_00C4_01C0039A.5121F240-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
I would actually disagree with that. Someone in our office tried calling a custom tag that alters the generated content with cfmodule, and it did not work correctly, even though it worked when called the standard way. He used at the end too. David Matthew Walker wrote: > > > > I just signed up with an ISP that does shared web hosting. > > > i use to a stand alone machine and inserting my custom tags > > > in the /customtags directory under my CF install. How would/should > > > an ISP implement this kind of capability on a shared service where > > > multiple sites are using one install of CF? > > > The ISP will probably have you copy your custom tags directory under your > > root. You can either copy the custom tag to which ever directory > > you wish to > > call the tag from or you can put the tags in one central directory and use > > cfmodule to call your tags. > > I'm in the same situation. I place a customtags folder under the root of the > site. Annoyingly, I can't use absolute paths (beginning with a /) to point > to it (has to be set up on the server) so every time I want to call a custom > tags I have to use a relative link with . One thing to note is > that custom tags that have a closing tag (e.g. ) will still > work -- you just use instead. > > I'd really like to see notes in the Fusebox spec about using it in a shared > environment like this. The number of CF Web hosting services is only going > to grow > > Regards, > Matthew Walker > Electric Sheep Web Co. > http://www.electricsheep.co.nz/ > > -- > Tel +64-3-374 2137 > Fax +64-3-377 7930 > Mobile +64-25-605 5747 > P O Box 13-907, Armagh > Christchurch 8031 > New Zealand > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Certified?
Has anyone taken the Allaire CF Certification test yet? -John- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is there a variable for a query's name?
> I must be the most unarticulate person on these lists. Yes. It's "inarticulate." -David-who-did-better-on-the-English-part-of-the-SAT-than-on-the-math-par t-but-who-works-as-a-programmer-anyway 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: "Need your help desperately..."
"Scott, Andrew" <[EMAIL PROTECTED]>wrote: >Andrea Scott >ANZ eCommerce Centre >* Ph 9273 0693 >* [EMAIL PROTECTED] So which is it? Andrew or Andrea? Or are there multiple personalities all fighting each other? :-) Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: "Need your help desperately..."
I would agree with this, for the simple fact I hold no degrees in anything. But I am a very quick learner, and work hard to achieve what I set out to do. I have 20 years programming experience, and have dabbled in a lot of languages. I have a very impressive resume, and the ability to sell my skills. I did think the CF certificate would make it easier to say you know CF, but what about programming logic this is a lot harder to learn and comes from experience. I see the Allaire Certificate for CF a waste of my time, only because I believe in my ability to do the work and think that my work in the industry will be enough to keep working in it. regards Andrea Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: 11 August 2000 10:41 To: [EMAIL PROTECTED] Subject: RE: "Need your help desperately..." With all due respect as a fellow CF developer, if you expect a certification to get you a job, then you are cheating yourself. Show good work and stay in the forefront and it doesn't matter who cheated and who studied for the test. I know a few people that had to cheat the MS exams just to get their foot in the door. Couldn't afford college, just enough money to cheat a certification. Now they are some of the finest network admins out there. An exam is nothing more than a review. If the piece of paper makes you more confident... good. That's all it's truly good for. And quite honestly, within the past year or so (disregard the years prior - the 'static' years), I haven't met a single successful developer / designer who didn't have any good work to show for it. But i HAVE met quite a few 'certified' unemployed 'developers'. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Multiple value Select
Sorry I couldn't get back in time.. i was on a road trip. thanks for the extra push Katrina, I was stumbling, there. -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 3:10 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select It works!!! Thank you so much to everyone who helped along the way. My goal is to one day be 1/10th as helpful to the list as the list has been to me. At this point (given how much I get and how little I now know), that's a huge goal. Thanks again. Athelene -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: Multiple value Select I am using Outlook Express, and have it set up to reply to messages in their original format, which in this case is HTML, or to compose new messages in plain text. For some reason the list is not properly handling the mime conversion. To see if perhaps this is fixed, I have changed it to send in plain text only, regardless of the format of the incoming message. It has been annoying to me, because other messages besides mine have been turned to mush. DC - Original Message - From: "Chapman, Katrina" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 09, 2000 17:03 Subject: RE: Multiple value Select > The 3D shouldn't be there. It's because a very bad David;) is sending > messages in HTML format, or some format other than plain text. Just > remove > any 3D's you may have copied and it should work. > > --K > > -Original Message- > From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 09, 2000 8:50 AM > To: '[EMAIL PROTECTED]' > Subject: RE: Multiple value Select > > > OK. I copied the code into the document. Now it's not liking the first > quote in the CFSELECT statement: > > > > Did I just misunderstand what the 3D represented? Is there just a > syntax > error I'm not seeing. Tried to find some reference to it in the books I > have (I assumed it stood for dimension?) with no luck. > > TIA, > > Athelene > > -Original Message- > From: David E. Crawford [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 09, 2000 7:42 AM > To: [EMAIL PROTECTED] > Subject: Re: Multiple value Select > > > This is a multi-part message in MIME format. > > --=_NextPart_000_00EF_01C001FF.3F8198C0 > Content-Type: text/plain; > charset="Windows-1252" > Content-Transfer-Encoding: quoted-printable > > RE: Multiple value SelectOk, now we have a bit of information. > > Try this: > > =20 > =20 > >ListFindNoCase(EditNameQry.PracticeGroup,GetPG.PG)>=20 > =20 > =20 > =20 > =20 >#PG# =20 > =20 > =20 > > > > Change the order of the parameters to the = > Listfindnocase()/Listcontains() functions. If EditNameQry.PracticeGroup > = > is a comma seperated list and GETPG.PG is a single value, this should = > work. > > > > DC > > > > - Original Message -=20 > From: Gieseman, Athelene=20 > To: '[EMAIL PROTECTED]'=20 > Sent: Tuesday, August 08, 2000 21:36 > Subject: RE: Multiple value Select > > > No. That field would have multiple items in a comma-delimited format. > = > Not=20 > even the first option is selected.=20 > > Athelene=20 > > -Original Message-=20 > From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]=20 > Sent: Tuesday, August 08, 2000 4:33 PM=20 > To: [EMAIL PROTECTED]=20 > Subject: RE: Multiple value Select=20 > > > > This may be a stupid question but the query EditNameQry is only = > pulling one=20 > value for PracticeGroup. Right? If not I'm sure that when you > "view=20 > source" you'll see that more than one option is "SELECTED". That will > = > > confuse the browser and it will stay on the first option.=20 > > --K=20 > > -Original Message-=20 > From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20 > Sent: Tuesday, August 08, 2000 2:04 PM=20 > To: [EMAIL PROTECTED]=20 > Subject: RE: Multiple value Select=20 > > > > Yo may have a point.. try putting quotes around = > EditNameQry.PracticeGroup.=20 > > Plus, if I replace=20 > > =20 > with=20 > > =20 > > the Agribusiness option is selected. So I think I'm doing something = > wrong=20 > in how I'm using the second parameter of the ListContains.=20 > > -Original Message-=20 > From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20 > Sent: Tuesday, August 08, 2000 4:18 PM=20 > To: '[EMAIL PROTECTED]'=20 > Subject: RE: Multiple value Select=20 > > > > No luck. I think there's a problem in that the listcontains isn't = > finding=20 > any matches. I can't figure out why. I display the previously = > selected=20 > items in another part of the form and it is identical to the options = > in the=20 > database. There is a comma sepa
CFLOCK and CFINCLUDE
This is a multi-part message in MIME format. --=_NextPart_000_0303_01C0030D.97C80460 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit Since CFLOCK topics seems to be all the rage recently... If I CFINCLUDE a template within a lock, will the included template be locked as well? For example: I'm guessing that the code in file2.cfm WILL be locked, due to the nature of CFINCLUDE. How about for CFMODULE? Thanks in advance, Seth Petry-Johnson Argo Enterprise and Associates --=_NextPart_000_0303_01C0030D.97C80460 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIII+DCCAqsw ggIUoAMCAQICAwK37jANBgkqhkiG9w0BAQQFADCBlDELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdl c3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UE CxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAx OTk5LjkuMTYwHhcNMDAwNjA5MDQyMTIzWhcNMDEwNjA5MDQyMTIzWjBJMR8wHQYDVQQDExZUaGF3 dGUgRnJlZW1haWwgTWVtYmVyMSYwJAYJKoZIhvcNAQkBFhdzZXRoQGFyZ29lbnRlcnByaXNlLmNv bTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxA83MlfgaZLW39mrcBRBfRdRa9/UPl6M26qE caUhQcMW66UyxV/Xi7WK0uKqPpYoCyo327ZN92tUFMZNI5kZC6VATN3reeWio2bffeC0bwm4vKzQ fPXnOz7dCOdcrzWZL+Dt/Qf+5VxoMsDtbiwUDg3dASSIWJFFuXNYfo1fyh0CAwEAAaNVMFMwIgYD VR0RBBswGYEXc2V0aEBhcmdvZW50ZXJwcmlzZS5jb20wDAYDVR0TAQH/BAIwADAfBgNVHSMEGDAW gBSIq/Fgg2ZV9ORYx0YdwGG9I9fDjDANBgkqhkiG9w0BAQQFAAOBgQAn4BFAYqTTdeMfQ3T8vPaW W+BLJ02KZX4QMU0iWjf7b2MYYqb0BxwZcr+r5UmT99nGRPVoVKS/OgikLXHm98wPEy8Ye9LZXTTN XF43kwMGPDG2G6urhJvpXI98FFK9biRJzZ28GBqLOPw/vHB57gk8J9YeyRSxWqzTgkwsJSFvEzCC AxQwggJ9oAMCAQICAQswDQYJKoZIhvcNAQEEBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX ZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRp bmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1Ro YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1h aWxAdGhhd3RlLmNvbTAeFw05OTA5MTYxNDAxNDBaFw0wMTA5MTUxNDAxNDBaMIGUMQswCQYDVQQG EwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRQwEgYDVQQHEwtEdXJiYW52aWxsZTEPMA0GA1UE ChMGVGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29u YWwgRnJlZW1haWwgUlNBIDE5OTkuOS4xNjCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAs2la l9TQFgt6tcVd6SGcI3LNEkxL937Px/vKciT0QlKsV5Xje2F6F4Tn/XI5OJS06u1lp5IGXr3gZfYZ u5R5dkw+uWhwdYQc9BF0ALwFLE8JAxcxzPRB1HLGpl3iiESwiy7ETfHw1oU+bPOVlHiRfkDpnNGN FVeOwnPlMN5G9U8CAwEAAaM3MDUwEgYDVR0TAQH/BAgwBgEB/wIBADAfBgNVHSMEGDAWgBRyScJz NMZV9At2coF+d/SH58ayDjANBgkqhkiG9w0BAQQFAAOBgQBrxlnpMfrptuyxA9jfcnL+kWBI6sZV 3XvwZ47GYXDnbcKlN9idtxcoVgWL3Vx1b8aRkMZsZnET0BB8a5FvhuAhNi3B1+qyCa3PLW3Gg1Kb +7v+nIed/LfpdJLkXJeu/H6syg1vcnpnLGtz9Yb5nfUAbvQdB86dnoJjKe+TCX5V3jCCAy0wggKW oAMCAQICAQAwDQYJKoZIhvcNAQEEBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJu IENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAm BgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhh d3RlLmNvbTAeFw05NjAxMDEwMDAwMDBaFw0yMDEyMzEyMzU5NTlaMIHRMQswCQYDVQQGEwJaQTEV MBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0 ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQw IgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNv bmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANRp19Sw lGRbcelH2AxRtupykbCEXn0tDY97Et+FJXUodDpCLGMnn5V7S+9+GYcdhuqj3bnOlmQawhRuRKx8 5o/oTQ9xH0A4pgCjh3j2+ZSGXq3qwF5269kUo11uenwMpUtVfwYZKX+emibVars4JAhqmMex2qOY kf152+VaxBy5AgMBAAGjEzARMA8GA1UdEwEB/wQFMAMBAf8wDQYJKoZIhvcNAQEEBQADgYEAx+yS fk749ZalZ2IqpPBNEWDQb41gWGGsJrtSNVwIzzD7qEqWih9iQiOMFw/0umScF6xHKd+dmF7SbGBx XKKs3Hnj524ARx+1DSjoAp3kmv0T9KbZfLH43F8jJgmRgHPQFBveQ6mDJfLmnC8Vyv6mq4oHdYsM 3VGEa+T40c53ooExggHCMIIBvgIBATCBnDCBlDELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rl cm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMU Q2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAxOTk5 LjkuMTYCAwK37jAJBgUrDgMCGgUAoH0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG 9w0BCQUxDxcNMDAwODExMDA1NzI2WjAeBgkqhkiG9w0BCQ8xETAPMA0GCCqGSIb3DQMCAgEoMCMG CSqGSIb3DQEJBDEWBBQFo5UtjNv3Eq946vALOrb8zrC2+jANBgkqhkiG9w0BAQEFAASBgLUFL1Hx 03cldQ6uvXQK4s5yNrCwMVlYJnYXXWgOhUPmLkI42w9JhkBQoBGJCnaagTcOlbRdaAtCl0+lI0Dy kWpwjTVv+bySdpTxN08T0ovIe9a30PF8F3RRhREHgX8TcyWMr5uU0j/IH+ZI+KpwvUCLnPBUo9wK FroBGm9Dr/GM --=_NextPart_000_0303_01C0030D.97C80460-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Email database
I think I recall some time ago on this list someone was talking about placing all your email in a database, might have even been a CF app. Can anyone point me in the right direction please? 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: "Need your help desperately..."
With all due respect as a fellow CF developer, if you expect a certification to get you a job, then you are cheating yourself. Show good work and stay in the forefront and it doesn't matter who cheated and who studied for the test. I know a few people that had to cheat the MS exams just to get their foot in the door. Couldn't afford college, just enough money to cheat a certification. Now they are some of the finest network admins out there. An exam is nothing more than a review. If the piece of paper makes you more confident... good. That's all it's truly good for. And quite honestly, within the past year or so (disregard the years prior - the 'static' years), I haven't met a single successful developer / designer who didn't have any good work to show for it. But i HAVE met quite a few 'certified' unemployed 'developers'. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
> > I just signed up with an ISP that does shared web hosting. > > i use to a stand alone machine and inserting my custom tags > > in the /customtags directory under my CF install. How would/should > > an ISP implement this kind of capability on a shared service where > > multiple sites are using one install of CF? > The ISP will probably have you copy your custom tags directory under your > root. You can either copy the custom tag to which ever directory > you wish to > call the tag from or you can put the tags in one central directory and use > cfmodule to call your tags. I'm in the same situation. I place a customtags folder under the root of the site. Annoyingly, I can't use absolute paths (beginning with a /) to point to it (has to be set up on the server) so every time I want to call a custom tags I have to use a relative link with . One thing to note is that custom tags that have a closing tag (e.g. ) will still work -- you just use instead. I'd really like to see notes in the Fusebox spec about using it in a shared environment like this. The number of CF Web hosting services is only going to grow Regards, Matthew Walker Electric Sheep Web Co. http://www.electricsheep.co.nz/ -- Tel +64-3-374 2137 Fax +64-3-377 7930 Mobile +64-25-605 5747 P O Box 13-907, Armagh Christchurch 8031 New Zealand -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Crazy MS Outlook/Access Question
You can probably use ADSI and VBScript to do it. There is a way to manipulate Outlook using ADSI John I want to know if anyone has ever attempted the impossible and how it was done. I have about 300 names in an Access database that I would like to send a mass email to, but the Access database did not contain their email addresses. What I was thinking is since they all work for the same company maybe I could do a query from MS Outlook and populate my database with their emails from Outlook, doing a simple WHERE statement that would match their First and Last names. Is this possible or should I get started on manually entering their addresses?? Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Optimization tips collection
There is a lot of conflicting information on how to properly set up an Access datasource. For me anyway, I've found that Access sites are much more stable when the database connection is NOT persistent, and the max number of connections is set to around 5. Regards, Chris On 8/10/00, Dave Watts penned: >This article only applies to Microsoft Access. If you're using Access, >maintaining database connections may cause memory leak and stability >problems. Of course, if you're using Microsoft Access, you may have all >kinds of problems that you can't fix by dropping database connections. There was in article in CFDJ that said ALWAYS maintain database connections with Access and set the max number of connections to 1. I set mine to 2 just to be risqué. :) -- Bud Schneehagen - Tropical Web Creations -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Crazy MS Outlook/Access Question
Try this (it seems to work in Access 2000): File -> Get External Data -> Import Under "Files of Type:", choose Outlook() It will walk you through importing your address book into a table. From there you should be able to query the address book. This is assuming you've got all the addresses stored locally on your computer. If you're connecting to a server through LDAP (to an NT server presumably), you'd have to use which is no fun. Reply if this helps... Good luck! Norman Elton Information Technology - Network Engineering College of William & Mary -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 8:00 PM To: [EMAIL PROTECTED] Subject: Crazy MS Outlook/Access Question Hi, I want to know if anyone has ever attempted the impossible and how it was done. I have about 300 names in an Access database that I would like to send a mass email to, but the Access database did not contain their email addresses. What I was thinking is since they all work for the same company maybe I could do a query from MS Outlook and populate my database with their emails from Outlook, doing a simple WHERE statement that would match their First and Last names. Is this possible or should I get started on manually entering their addresses?? Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Crazy MS Outlook/Access Question
Hi, I want to know if anyone has ever attempted the impossible and how it was done. I have about 300 names in an Access database that I would like to send a mass email to, but the Access database did not contain their email addresses. What I was thinking is since they all work for the same company maybe I could do a query from MS Outlook and populate my database with their emails from Outlook, doing a simple WHERE statement that would match their First and Last names. Is this possible or should I get started on manually entering their addresses?? Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
I put my custom tags in the folder with the templates that call them. CF looks there first. I tried having my ISP put them in the CustomTags folder on the server, but somehow they would periodically vanish. Gary Groomer - Original Message - From: <[EMAIL PROTECTED]> To: <:> Sent: Thursday, August 10, 2000 7:25 PM Subject: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!! > hey All, > > I just signed up with an ISP that does shared web hosting. > i use to a stand alone machine and inserting my custom tags > in the /customtags directory under my CF install. How would/should > an ISP implement this kind of capability on a shared service where > multiple sites are using one install of CF? > > Please help. > > - D > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
> hey All, > > I just signed up with an ISP that does shared web hosting. > i use to a stand alone machine and inserting my custom tags > in the /customtags directory under my CF install. How would/should > an ISP implement this kind of capability on a shared service where > multiple sites are using one install of CF? The ISP will probably have you copy your custom tags directory under your root. You can either copy the custom tag to which ever directory you wish to call the tag from or you can put the tags in one central directory and use cfmodule to call your tags. Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Optimization tips collection
On 8/10/00, Dave Watts penned: >This article only applies to Microsoft Access. If you're using Access, >maintaining database connections may cause memory leak and stability >problems. Of course, if you're using Microsoft Access, you may have all >kinds of problems that you can't fix by dropping database connections. There was in article in CFDJ that said ALWAYS maintain database connections with Access and set the max number of connections to 1. I set mine to 2 just to be risqué. :) -- 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?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can CF be run on a machine which is also running Service Pack 6 Alpha?
The problem is that there is a tag or two that don't work on SP 6. I can't remember which one(s), but you may be able to find it on the Allaire site. That's where I first read about the problem. Jason Web Application Developer webworld studios, inc. -Original Message- From: Wayne, Kurt [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 11:36 AM To: '[EMAIL PROTECTED]' Subject: Can CF be run on a machine which is also running Service Pack 6 Alpha? We're trying to move a web site to a designated box with our host (Navisite). However, we've been told that there are problems with installing CF on a machine using this SP. The person who said this didn't specify what the problems were...I'm having to rely on it second-hand. What problems are there, and are there ways around it? Thanks, gang. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
hey All, I just signed up with an ISP that does shared web hosting. i use to a stand alone machine and inserting my custom tags in the /customtags directory under my CF install. How would/should an ISP implement this kind of capability on a shared service where multiple sites are using one install of CF? Please help. - D -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
hey All, I just signed up with an ISP that does shared web hosting. i use to a stand alone machine and inserting my custom tags in the /customtags directory under my CF install. How would/should an ISP implement this kind of capability on a shared service where multiple sites are using one install of CF? Please help. - D -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
hey All, I just signed up with an ISP that does shared web hosting. i use to a stand alone machine and inserting my custom tags in the /customtags directory under my CF install. How would/should an ISP implement this kind of capability on a shared service where multiple sites are using one install of CF? Please help. - D -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie: Sessions
I find session variables much more useful than cookies. I mainly use cookies for storing information about the user for the next time he comes to the site. I always put the user's profile in the session scope, shopping cart data, queries taylored to that user, etc. You can store any datatype in the session scope, which is not true of cookies. Let's say you had a query that got all the products John Smith had bought in the last 3 months. Where are you going to store that? If you only use that data on one page, just store it locally. But if John can click on one of the puchases and get more info, then go back to the full-listing, you don't want to be running that query every time he clicks a link. If you store it in the session scope, you don't have to run the query every time. Just use #session.queryName.columnName# instead. Jason Web Application Developer webworld studios, inc. -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 3:09 PM To: [EMAIL PROTECTED] Subject: Newbie: Sessions I am trying to understand sessions and trying to know when I should use them. So far I have done every thing with cookies. Is there a good place to read about sessions online? Also, I was told not to use them at all by one of the guys in the office. Is there a reason why? Thanks Art Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Connecting with CFLDAP
> I have been using the softartisans nta_user.dll to validate > users against their nt domain accounts for access to our corporate > intranet. We have just been taken over and I have been asked to > validate users against an LDAP server instead. We set up a new > LDAP server and I am having trouble getting this to work and > wanted some troubleshooting advice. > > My tag reads: > >action="query" > name="results" > attributes="cn" > server="#form.server#" > start="cn=#form.name#" > > > > If I plug in the bigfoot server I get a result but when I use my > local server it returns "No such object" - the IT guys assure me > there is data in there and I have seen some of it. I know that cn > is a valid attribute. I tried using a login and password but the > result doesn't change. Typically, when it returns "No such object", that's because there is, in fact, no such object in the schema. Try using another LDAP client to connect; most mail clients provide some sort of LDAP lookup capability. If you can, get one of the IT guys to do it in front of you with a standard LDAP client. If they can do it, then it's a problem in your code; if not, it's a problem in their schema. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Alert
Are you sending the user to another page, or continuing with processing after this? If so, remember that javascript is client-side. Any CF will ALWAYS run BEFORE this javascript is executed. With a CFABORT, you stop there, the page is sent to the user, and he gets the alert. Without that, all processing continues as normal. Jason webworld studios, Inc. -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 5:10 PM To: [EMAIL PROTECTED] Subject: Alert I have a code similar to following code: ... alert("Note that you are exceeding the limit!") ... When the condition is true, The pop up window appears only when I have an statement after . If I remove the statement, then the user is not getting the alert pop up dialog box. This seems to be little strange. Can someone tell me where I am going wrong? Appreciate. A.B. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Optimization tips collection
> In an Allaire article they suggest these items, in order to > improve ODBC connectivity: > > "Regardless of whether you use OLE DB or ODBC connections, > here are some additional steps that can improve your Access > database connectivity: > > On the Server Settings page in ColdFusion Administrator, > set Limit Simultaneous Requests to 5-7 per processor. > In ColdFusion Administrator, modify every Access ODBC > Datasource and set the following (you will need to click the > CF Settings button to see these): > > Buffer Size = 0 (ODBC only) > Page Timeout = 600 (ODBC only) > Uncheck Maintain Database Connections " > > My questions are: > > 1. Is there any affect on setting the buffers=0 > 2. Any noticeable affect on "Uncheck Maintain Database Connections" > > I have read previous info from Allaire that "Uncheck Maintain > Database Connections " could cause a performace degradation. This article only applies to Microsoft Access. If you're using Access, maintaining database connections may cause memory leak and stability problems. Of course, if you're using Microsoft Access, you may have all kinds of problems that you can't fix by dropping database connections. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Talking With Actuate
Anyone have advice on getting Cold Fusion to talk with the Actuate Reporting server? There appears to be multiple interfaces which can be pursued. I was hoping someone had plowed this ground before, and can make a recommendation on the best interface to use. Thanks. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What is: Team Allaire?
Disclaimer... all that cool free software (yeah, we have it too).. is NFR and not for PRODUCTION USE. ;> Gregory --- annex.com, Inc. - http://www.annex.com/ --- - If you EcoBuild it, they will come. - - http://www.ecobuilder.com/ - --- > -Original Message- > From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 7:05 AM > To: [EMAIL PROTECTED] > Subject: Re: What is: Team Allaire? > > > Hey genius add it up...2 copies of spectra NT and SL $15 K each to > purchase...JRun 5K, 4 Copies 4.5 Ent (LX,HP,SL,NT) at 5K a > pop. That alone > is 55K plus you get CF Studio and Homesite. > - Original Message - > From: "LISTS" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, August 10, 2000 8:01 AM > Subject: RE: What is: Team Allaire? > > > > > > We became a hosting partner. Cost - close to $1700.00 Why? > Well, because > > before we could sign up we had to own a subscription. The > only way to get > a > > subscription was to own copy of CF 4.5. The subscription > was $500, the > > upgrade was about $600, and then the Hosting Program fee was $495. > > > > Yes, we received all the FREE "Not For Resale" software, > Not $50K worth > > but...we already own all of it anyway. Since we are a CF > hosting company, > > and have been for some time, we have already purchased CF Server, > Homesite, > > CF Studio etc. > > > > Yes, we have access to the members only portion of the Web > site, which > seems > > to be all sales related in favor of Allaire. But, the real reason we > signed > > up was to be listed on their Web site as a hosting partner. > We are listed, > > but, only in the Florida section. And, to get to us, a user > has to fill > out > > a form selecting Florida and scrolling through until we pop > up. I know > that > > there are many Hosting Partners, and it would be hard to > post them all on > a > > static page, but not impossible, the way it's done at > AbleCommerce's site. > > At the AC site we receive many leads. At Allaire - none to date. > > > > I know that they (Allaire) have a growing business and they > are "hot" > right > > now, but, if you ask, Do I think the Hosting Partner > program is worth it? > I > > would have to answer - No! Maybe at $495 annually it may be > worth it. > Also, > > it definitely would be worth while if they included some > level of support > in > > the package...but they don't. I mean, we are committed to > the company, we > > have invested a ton of money in the company, the least they > could do, for > an > > annual fee, is answer some of our questions once in a > while. Instead, for > > the annual fee, they provide us with marketing and sales > material. Well, > we > > don't really sell the product, we host it and support it. > This is just my > > opinion and in no way is meant to be a slight on the > ColdFusion product. > It > > is a good product (most of the time :-) ) but I think the > company needs to > > be a "little" more generous. > > > > John Cesta > > > > > > > > I recently became a Allaire Alliance partner. I think it > is well worth > the > > $450. You get over $50K worth of software access to new > betas and yes a > > members only portion of the site. The cost is definetely > small compared > to > > what you get. > > > > Kevin Schmidt > > Internet Services Manager > > Peterson, WIlliams & Bizer > > Office: 734.995.5000 > > Mobile: 734.649.4843 > > > > - Original Message - > > From: "Angel Stewart" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, August 10, 2000 5:08 AM > > Subject: What is: Team Allaire? > > > > > > > Hello boys and girls :-) > > > > > > I was just wondering, who are Team Allaire, and how does > one join this > > elite > > > group? > > > > > > Does becoming a basic Consulting/technological partner > allow you access > to > > > special resources etc. (especially sales and marketing > resources) and > put > > > you in, or give you access to Team Allaire?? > > > > > > I am once more forced to do a "Cost Justification" for > the US450.00 to > > sign > > > up as a Consulting/Technology partner, and was looking > for anything more > > > that I can add beside the benefits listed on the website. > > > > > > *sigh* > > > > > > -Gel > > > p.s. I heard that Team Allaire was a part of Majestic 12;-P > > > > > > > > -- > > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > To Unsubscribe visit > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list s/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: Latest WDDX_COM.DLL
> Can anyone enlighten me as to the latest version of the WDDX > COM object? > > I can't find anything on the Allaire site that shows that > anything has been 'issued' since the 4.0.1 upgrade. > > The one on my machine is version 1,0,0,1 dated 9 April 99. Have you checked http://www.wddx.org/? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: in one query refers to 2 different odbc sources
Not at the same time I do not think that is possible from a pure CF standpoint, perhaps the DB can do it.. but ill assume it cant.. You can do two seperate queries with one query based on data from the second. SELECT junkID FROM SomeTable SELECT barID FROM SomeOtherTable WHERE Foo1.recordcount < 10 Something like that might help? Or you may consider merging databases or making the data more friendly for this type of situation. Just some thoughts, i realize thats not a solution to your problem so these are just suggestions :-\ Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: thanh nguyen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 4:56 PM To: [EMAIL PROTECTED] Subject: in one query refers to 2 different odbc sources I have 2 databases located on the 2 different NT servers, Is there any way i can write one query that refers to different odbc sources, if yes, how and the syntax, thanks Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Array Confusion
Thanks a lot!! >From: "DJMixes.Com" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: <[EMAIL PROTECTED]> >Subject: Re: Array Confusion >Date: Thu, 10 Aug 2000 16:13:12 -0400 > >You would use loop. > > > SELECT Quantity, ID FROM TestTable > > > to="#GetNumbers.RecordCount#"> > > > > > >Derek > >"S R" <[EMAIL PROTECTED]> wrote in message >news:<[EMAIL PROTECTED]>... > > How do I populate a one dimensional array from a query?? I'm having >trouble > > figuring out how I make the 'Array number' dynamic: > > > > > > SELECT Quantity, ID FROM TestTable > > > > > > > > > > > > > > > > > > > > > > > > > > #QuantityTotal[??]# > > > > > > Thanks > > > > Sal > > > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > >-- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Comma/Number Problem
Thanks a lot. It worked!!! Sal >From: Sean German <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >Subject: RE: Comma/Number Problem >Date: Thu, 10 Aug 2000 17:08:34 -0400 > >K, > >Fair enough. The expression removes all characters that aren't a digit or >decimal point(0-9 or .). > >rereplace(vartocleanup, "[^0-9\.]+", "", "ALL") > >Whether you prefer that or Don's newstring=replace(oldstring,",","","ALL") >depends on the source of the numbers. If you have some legacy data or >other >controlled source where you know the only issue will be commas, Don's >replace will do ya just fine. If there's a chance you might face other >non-numeric characters (currency symbols, etc.), the rereplace would be >more >appropriate. Right tool for the job and all that. > >HTH, > > >Sean G. > > >-Original Message- >From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 10, 2000 4:09 PM >To: [EMAIL PROTECTED] >Subject: RE: Comma/Number Problem > > >No offense to you Shawn but with new people, which he obvioulsy is as he >doesn't know about replace, you should probably explain what this does >instead of just supplying it. > >--K >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Comma/Number Problem
Good Job! You get a gold star for the day! --K -Original Message- From: Sean German [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 2:09 PM To: '[EMAIL PROTECTED]' Subject: RE: Comma/Number Problem K, Fair enough. The expression removes all characters that aren't a digit or decimal point(0-9 or .). rereplace(vartocleanup, "[^0-9\.]+", "", "ALL") Whether you prefer that or Don's newstring=replace(oldstring,",","","ALL") depends on the source of the numbers. If you have some legacy data or other controlled source where you know the only issue will be commas, Don's replace will do ya just fine. If there's a chance you might face other non-numeric characters (currency symbols, etc.), the rereplace would be more appropriate. Right tool for the job and all that. HTH, Sean G. -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 4:09 PM To: [EMAIL PROTECTED] Subject: RE: Comma/Number Problem No offense to you Shawn but with new people, which he obvioulsy is as he doesn't know about replace, you should probably explain what this does instead of just supplying it. --K -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Alert
I have a code similar to following code: ... alert("Note that you are exceeding the limit!") ... When the condition is true, The pop up window appears only when I have an statement after . If I remove the statement, then the user is not getting the alert pop up dialog box. This seems to be little strange. Can someone tell me where I am going wrong? Appreciate. A.B. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Comma/Number Problem
K, Fair enough. The expression removes all characters that aren't a digit or decimal point(0-9 or .). rereplace(vartocleanup, "[^0-9\.]+", "", "ALL") Whether you prefer that or Don's newstring=replace(oldstring,",","","ALL") depends on the source of the numbers. If you have some legacy data or other controlled source where you know the only issue will be commas, Don's replace will do ya just fine. If there's a chance you might face other non-numeric characters (currency symbols, etc.), the rereplace would be more appropriate. Right tool for the job and all that. HTH, Sean G. -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 4:09 PM To: [EMAIL PROTECTED] Subject: RE: Comma/Number Problem No offense to you Shawn but with new people, which he obvioulsy is as he doesn't know about replace, you should probably explain what this does instead of just supplying it. --K -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: in one query refers to 2 different odbc sources
Who is the vendor for the databases? - Original Message - From: "thanh nguyen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 4:55 PM Subject: in one query refers to 2 different odbc sources > I have 2 databases located on the 2 different NT servers, Is there any way i > can write one query that refers to different odbc sources, if yes, how and > the syntax, > thanks > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFX Wizard and header files
Ditto! Thanks Bill > -Original Message- > From: Jeremy Allen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 2:17 PM > To: [EMAIL PROTECTED] > Subject: RE: CFX Wizard and header files > > > :-) Could you mail those to me as well.. Please :) > > Jeremy Allen > [EMAIL PROTECTED] > [Insert cool title here] > > -Original Message- > From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 1:49 PM > To: [EMAIL PROTECTED] > Subject: RE: CFX Wizard and header files > > > Done ... offlist of course :) > > Joe Hoffman mailto:[EMAIL PROTECTED] > National Institutes of Health > Center for Information Technology > Division of Computer System Services > > -Original Message- > From: Brian Silvers [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 11:45 AM > To: [EMAIL PROTECTED] > Subject: CFX Wizard and header files > > > Can anyone email me the wizard file and headers needed to compile CFX > tags. I faintly remember that there was a problem with CF not installing > the wizard and headers. Was this problem ever resolved? If not can > anyone email it to me directly at > [EMAIL PROTECTED] or post it on the list if anyone else wants it? > > much appreciated and thanks!, > Brian Silvers aka KungFusion > > -- > -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
in one query refers to 2 different odbc sources
I have 2 databases located on the 2 different NT servers, Is there any way i can write one query that refers to different odbc sources, if yes, how and the syntax, thanks Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Calling all Crystal Report Gurus
I figured it out. Thanks for listening. :) /mdeane -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 3:22 PM To: '[EMAIL PROTECTED]' Subject: Calling all Crystal Report Gurus Importance: High Problem: We have a database schema as follows: Column Headings: Date Param | Value Row 1 # usr 8 Row 2 # usr 9 Row 2 # sys 80 Row 2 # sys 71 Row 2 # idle 12 Row 2 # idle 20 What I want to do is build a line graph that shows how all these 3 vary even though the values that I want to differentiate on are all in the same column (Param). Any ideas? Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie: Sessions
Hello, Argument for using session variables: We have a company directory with free listings for members of the natural food products industry (very recently released). We will give out login and passwords to companies (upon approval of their company as verifiable) so that they can either change information (address, phone numbers etc) and also so that they may "Upgrade" their listing to incorporate a lot of tools (very similar to the Thomas Register). When a user logs in we cannot be sure they are doing so from their personal home/office computer and since we do not want to leave a variety of differently named cookies that would contain information about the company on machines in public kiosks we decided to manipulate this information using session variables that store database values and some temporary values that a user may change when logged in via a form.. We use the session variables because they maintain state throughout the 15 odd screens that a user may go through (depending on how much they upgrade) in order to pull info user specific data from a database and from forms which then allows the user to update their information. This system has worked well for us. If I had to maintain any other type of variables from page to page in my application I think this project would be a lot less portable (right now adding a component is really easy since it is very fuse box like and the session variables get set in one file which get included in all the pages of the application.' If you had asked me 6 months ago if I would ever use session variables I probably would have said "NO" but this was one place I have found them very useful. > > Art Broussard wrote: > > > I am trying to understand sessions and trying to know when I should use > > them. So far I have done every thing with cookies. Is there a good place to > > read about sessions online? > > > > Also, I was told not to use them at all by one of the guys in the office. Is > > there a reason why? > > > > Thanks > > > > Art -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: QUERY QUESTION
Kelly, All I can do is guess since I don't know your db design but here goes: -Run your first query -Run this query SELECT COUNT(SI_Item_ID) AS SI_Item_ID_COUNT, SI_Item_ID FROM SI_ITEMS2 WHERE SI_ITEM_ID IN (#SI_Item_ID#) AND SI_Opsrpt_ID = #ValueList(qgetsi.SI_Opsrpt_ID)# GROUP BY SI_Item_ID -output like this #SI_Item_ID_COUNT# - #SI_Item_ID# I would also suggest that you not do SELECT * but specify the fields you want instead. It may take a little more work but will make debugging and/or interpreting your code much easier. hth, Kevin At 02:04 PM 8/10/00 -0400, you wrote: >Ok here is my perdicament. Yours worked fine > > SELECT * > FROM SI_ITEMS2 > WHERE SI_ITEM_ID IN (#SI_Item_ID#) > AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# > >however what I am really trying to do is get a count. >So say there are 3 SI_OPSRPT_ID's >and i pass 5 item_ids i want to do a count of how many times >each ITEM shows up within those 3 reports. >I'm still somewhat new at getting things to query and display properly. >would want the output to be something like. > > From this date to this date (i pass the date range thats what determines how >many SI_opsrpt_id's will be included): >There were 7 instances of this Item. >??? >Kelly >--- >Kelly Matthews >Internet Development Coordinator >AAAE >703.578.2509 >[EMAIL PROTECTED] >http://www.airportnet.org >--- snip > > -Original Message- > > From: Kelly Matthews [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 10, 2000 12:14 PM > > To: '[EMAIL PROTECTED]' > > Subject: QUERY QUESTION > > > > > > Ok I have 2 queries I am running the first is: > > > > > > SELECT * > > FROM SelfInspection > > WHERE 0=0 > > > > AND SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND > > #CREATEODBCDate(form.date2)# > > > > > > This runs fine... > > > > Next one is: > > > > > > > > SELECT * > > FROM SI_ITEMS2 > > WHERE SI_ITEM_ID = #TheITem# > > AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# > > > > > > > > This seems to run fine but comes back with ONE record when it should come > > back with THREE: > > > > Results: > > qgetitems (Records=1, Time=0ms) > > SQL = SELECT * FROM SI_ITEMS2 > > WHERE SI_ITEM_ID = 19 AND > > SI_Opsrpt_ID = 5 > > SELECT * FROM SI_ITEMS2 > > WHERE SI_ITEM_ID = 13 > > AND SI_Opsrpt_ID = 5 > > SELECT * FROM > > SI_ITEMS2 > > WHERE SI_ITEM_ID = 15 > > AND SI_Opsrpt_ID = 5 > > > > It only appears to bring back ONE record however it should bring back 3 > > because > > ID 5 is in there with item id 19,15 and 13 but it seems to only pick up > > and > > display the first one > > Do I need to change my query > > Kelly > > -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problem carrying over form values.
Hey guys, I was hoping you could help me on this one... Ok, on one of my forms I have a textarea field that people will type stuff in. Then, they press submit and it goes to a page that displays what they typed and lets them 'approve' it before actually entering it into the database. It all works fine unless they type in something like this in one of the text area pages: The dog said, "Hey now!" Then when they press 'submit' and go to the page that lets them look everything over before they add it into the database I carry the fields over my putting them on that page as hidden fields. The problem is, the " " around the words Hey now! will make one of the hidden fields look like this: So the only thing that makes it into the database is "The dog said, ". How do I get around this? What is the correct way to carry the form fields across multiple pages without this error happening? I know I could do something like replacing all the " " with nothing, but I'd like to keep the formatting of the person's original message. Can I do this? Please help, thanks! Cody - Original Message - From: "Dan Haley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 3:10 PM Subject: RE: Comma/Number Problem > Wow, take back what I said in my last message . . . I could have sworn the > last time this came up I tested it, and it worked . . . val("10,500") DOES > NOT equal 10500. It must be because CF thinks 10,500 is a list, but > val("10,500") comes back as 10. > > Slap me silly on this one . . . go with the "cleanNumber" setup mentioned by > Sean G. > > Dan > > -Original Message- > From: Don Vawter [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 12:26 PM > To: [EMAIL PROTECTED] > Subject: Re: Comma/Number Problem > > > How about newstring=replace(oldstring,",","","ALL") > > - Original Message - > From: "S R" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, August 10, 2000 1:24 PM > Subject: Comma/Number Problem > > > > Hi, > > > > I am trying to add a bunch of numbers to get a total value. It works fine > > unless someone uses a comma to separate 'thousands': > > > > Ex. 10,500 > > > > How do I get rid of the comma before I add it up?? > > > > EX. 10500 > > > > Thanks > > > > Sal > > > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Verity vs. Freetext
> A product I use for full-text indexing and searching is called textdb > (www.webest.dk) interesting but some of their claims seem, well unsupported in some cases (slow index creation in sql server, sorting, subsets) and are flat wrong (the sql server ranking for instance) in others. i'd also be a bit queasy about using activeX. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Array Confusion
You would use loop. SELECT Quantity, ID FROM TestTable Derek "S R" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > How do I populate a one dimensional array from a query?? I'm having trouble > figuring out how I make the 'Array number' dynamic: > > > SELECT Quantity, ID FROM TestTable > > > > > > > > > > > > > #QuantityTotal[??]# > > > Thanks > > Sal > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Verity vs. Freetext
Tom: It's not only inexpensive, from http://www.webest.dk/eng/host.asp it looks like it's free to ISPs Please do send me the code you offered for CFOBJECT, and anything else I need to get started (that you can part with). Thanks! It looks interesting! best, paul At 01:10 PM 8/10/00 -0500, you wrote: >A product I use for full-text indexing and searching is called textdb >(www.webest.dk) > >It's a small and cheap product. It's not as straight-forward to use as >mssql fulltext, but it's furociously quicker than mssql or oracle (and >presumably verity with comparisons of it being slower than sql7). > >I have a db with 500,000 records containing descriptions ranging from 5k to >1 meg of data, and ANY search I do is finished within half a second. I can >do a wildcard "a" search, or a very complex conditional query using "sounds >like" operators, and still get my results back in that amount of time. Not >sure if version 4 is out yet, but version 3.whatever didn't support phrases, >the new version does (and is just as quick as before). > >Building the full text index also blows away the competition. It's not as >rich in features as teh others, and has a couple other limitations - but raw >speed (both building, updating, and retrieving) blows ms sql and oracle >(context stuff and intermedia) out of the water. I can build an index in >about 20 minutes on multiple fields against the 500k record database - this >is from scratch. > >It works as a com object, so you need to use cfobject (which I have sample >code for it) - but this still works very quickly. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Comma/Number Problem
No offense to you Shawn but with new people, which he obvioulsy is as he doesn't know about replace, you should probably explain what this does instead of just supplying it. --K -Original Message- From: Sean German [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:51 PM To: '[EMAIL PROTECTED]' Subject: RE: Comma/Number Problem This is something I've picked up from this list. cleanNumber = rereplace(vartocleanup, "[^0-9\.]+", "", "ALL") HTH,, Sean G. -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 3:24 PM To: [EMAIL PROTECTED] Subject: Comma/Number Problem Hi, I am trying to add a bunch of numbers to get a total value. It works fine unless someone uses a comma to separate 'thousands': Ex. 10,500 How do I get rid of the comma before I add it up?? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Latest WDDX_COM.DLL
Can anyone enlighten me as to the latest version of the WDDX COM object? I can't find anything on the Allaire site that shows that anything has been 'issued' since the 4.0.1 upgrade. The one on my machine is version 1,0,0,1 dated 9 April 99. TIA Terry Riley -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Comma/Number Problem
use a | as your delimiter. That is the think that is SHIFT-\ - Original Message - From: "S R" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 12:24 PM Subject: Comma/Number Problem > Hi, > > I am trying to add a bunch of numbers to get a total value. It works fine > unless someone uses a comma to separate 'thousands': > > Ex. 10,500 > > How do I get rid of the comma before I add it up?? > > EX. 10500 > > Thanks > > Sal > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Comma/Number Problem
Wow, take back what I said in my last message . . . I could have sworn the last time this came up I tested it, and it worked . . . val("10,500") DOES NOT equal 10500. It must be because CF thinks 10,500 is a list, but val("10,500") comes back as 10. Slap me silly on this one . . . go with the "cleanNumber" setup mentioned by Sean G. Dan -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:26 PM To: [EMAIL PROTECTED] Subject: Re: Comma/Number Problem How about newstring=replace(oldstring,",","","ALL") - Original Message - From: "S R" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 1:24 PM Subject: Comma/Number Problem > Hi, > > I am trying to add a bunch of numbers to get a total value. It works fine > unless someone uses a comma to separate 'thousands': > > Ex. 10,500 > > How do I get rid of the comma before I add it up?? > > EX. 10500 > > Thanks > > Sal > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie: Sessions
--09D037249F15994409D994AD Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit As a relative newbie myself I can tell you I had a pretty hard time trying to understand them using the Ben Forta book, it didn't cover it well and had lots of buggy code (which really surprised me since the rest of the book was pretty much excellent). I got the Cold Fusion 4 for Dummies book and that helped me quite a bit. Some people don't like the dummies books because they consider them too stupid, but in this case it really helped me. Also, another CF person I know like the Mastering Cold Fusion book. Maybe that one has a good chapter. Tammy Art Broussard wrote: > I am trying to understand sessions and trying to know when I should use > them. So far I have done every thing with cookies. Is there a good place to > read about sessions online? > > Also, I was told not to use them at all by one of the guys in the office. Is > there a reason why? > > Thanks > > Art > > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --09D037249F15994409D994AD Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit As a relative newbie myself I can tell you I had a pretty hard time trying to understand them using the Ben Forta book, it didn't cover it well and had lots of buggy code (which really surprised me since the rest of the book was pretty much excellent). I got the Cold Fusion 4 for Dummies book and that helped me quite a bit. Some people don't like the dummies books because they consider them too stupid, but in this case it really helped me. Also, another CF person I know like the Mastering Cold Fusion book. Maybe that one has a good chapter. Tammy Art Broussard wrote: I am trying to understand sessions and trying to know when I should use them. So far I have done every thing with cookies. Is there a good place to read about sessions online? Also, I was told not to use them at all by one of the guys in the office. Is there a reason why? Thanks Art Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com">http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --09D037249F15994409D994AD-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Comma/Number Problem
Or, evn easier - val("somenumber") . . . val("10,500") = 10500 Dan -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:26 PM To: [EMAIL PROTECTED] Subject: Re: Comma/Number Problem How about newstring=replace(oldstring,",","","ALL") - Original Message - From: "S R" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 1:24 PM Subject: Comma/Number Problem > Hi, > > I am trying to add a bunch of numbers to get a total value. It works fine > unless someone uses a comma to separate 'thousands': > > Ex. 10,500 > > How do I get rid of the comma before I add it up?? > > EX. 10500 > > Thanks > > Sal > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problem with counting???
Ok here are my current queries, thanks to Ben I got that part working. Query 1: I pass a date range: SELECT * FROM SelfInspection WHERE SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND #CREATEODBCDate(form.date2)# That works fine. then I have this next query, with a sub query, that checks the SI_Items2 table to see what items where checked for each qgetsi.SI_OPSRPT.ID. SELECT SI_ITEM_NAME FROM SI_ITEMS WHERE si_item_id IN ( SELECT si_item_id FROM SI_ITEMS2 WHERE SI_ITEM_ID IN (#SI_Item_ID#) AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID#) Group by si_item_name Ok for the query above its deal with 2 tables one is SI_ITEMS which simply have an SI_ITEM_ID and a name SI_ITEM_NAME the 2nd table SI_ITEMS2 has the item id SI_ITEM_ID and the report number SI_OPSRPT_ID this table gets updated when someone fills out a report if they select 3 items when filling out the report the ONE report number is plopped in to SI_ITEMS2 with each item id. SO if there were 3 items selected when entering report 5 it would enter: SI_OPSRPT_ID SI_ITEM_ID 5 12 5 15 5 16 And then you can refer back to table SI_ITEMS and/or SelfInspection to get the particulars about the ITEM ID or the REPORT ID. So now I want to run a report between specific dates that will show how many times an item was reported on within that period. Ok lets say the item I wanted to run a report on was Rubber. (although someone may want to run a report on multiple items too_ The 2nd query I posted above will run for EACH qgetsi.si_opsrpt_id since I have it within the tags. So the results look something like: qgetitems (Records=1, Time=0ms) SQL = SELECT SI_ITEM_NAME FROM SI_ITEMS WHERE si_item_id IN ( SELECT si_item_id FROM SI_ITEMS2 WHERE SI_ITEM_ID IN (5) AND SI_Opsrpt_ID = 5) and then if it finds it again: qgetitems (Records=1, Time=0ms) SQL = SELECT SI_ITEM_NAME FROM SI_ITEMS WHERE si_item_id IN ( SELECT si_item_id FROM SI_ITEMS2 WHERE SI_ITEM_ID IN (5) AND SI_Opsrpt_ID = 14) So say it found rubber twice. Now in my output. How do I get that count. I messed around with COUNT but being that it runs each query separately for eacy report id i didnt see a way to count it properly. I just want the output to be something like >From this date to that date: there were 2 Rubber problems. what am i missing? Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Challenge response problem
We are having a problem installing CF on a Windows 2000 machine - we get a username and password challenge response when requesting a CF document (html ok). We found the problem discussed in KB article 10334 and have implemented all the suggestions in the article but the problem persists - any ideas? Article 10334: http://www.allaire.com/Handlers/index.cfm?ID=10334&Method=Full Thanks Susan -- Susan Gallegos Educational Communications and Technology College of Agriculture and Life Sciences The University of Arizona 520-621-7181 [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically updating one select list based upon the selection in another
I would recommend Nate Weiss' CF_TwoSelectsRelated or CF_ThreeSelectsRelated tags which perform the functions you request; your preselections will be based on their order in the query rather than an absolute selection, but I think they'll do what your looking for. Truman -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:27 PM To: [EMAIL PROTECTED] Subject: dynamically updating one select list based upon the selection in another I have an update form in which the the user can choose an option from a select list. When this form is initially displayed, the current info from the database is automatically selected. This field happens to contain the names of various departments in our division. Each department has a default individual assigned to it (meaning that when a department is selected from the list, the information submitted will automatically be routed to the default person for that group). The field below that is a dynamically populated select list of all of the people in our division. If a user so chooses, they can override the default person assigned to a group, and specify someone else from this list. Now, here's what I want to do. When the form is first displayed, I want both the department select list AND the people list to have the current value in the db displayed (i.e. the department it will be routed to and the default contact person's name in that department). If, however, the user changes the name of the department to route to, I would like the list below it to automatically then select the default contact person's name for that department. In a nutshell, the first list will drive what is selected in the second list, but I want the second list to be independent (the first list will not change what is selected if I make a different selection in the second list). I'm assuming I will have to (ugh) use a javascript for this? Admittedly, I am neither a javascript guru nor a coldfusion guru. Can anyone provide me with some direction on this? Thanks in advance! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Comma/Number Problem
This is something I've picked up from this list. cleanNumber = rereplace(vartocleanup, "[^0-9\.]+", "", "ALL") HTH,, Sean G. -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 3:24 PM To: [EMAIL PROTECTED] Subject: Comma/Number Problem Hi, I am trying to add a bunch of numbers to get a total value. It works fine unless someone uses a comma to separate 'thousands': Ex. 10,500 How do I get rid of the comma before I add it up?? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFFile access problem
I wouldn't be surprised if, even with just one copy of the code executing, there would be a delay between when you delete and when you can write; this would be up to the OS and I don't think CFLOCK would help. You could CFTRY/CFCATCH in a CFLOOP so you wouldn't have to build in a delay: Could you use CFFILE append instead of delete/write? Or log to a DB which takes care of these problems for you? -Original Message- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 11:31 AM To: [EMAIL PROTECTED] Subject: RE: CFFile access problem Good point. I've noticed that some of the file contention problems seem to disappear if I use a loop to introduce a brief delay between a CFFILE Delete and a CFFILE Write operation on the same file. Is that to be expected, and should CFLOCK solve that problem (it seems that there are still some file contention or access problems). Gene Kraybill > from [EMAIL PROTECTED] > It could be contention for that file by your application. You could either > CFLOCK that CFFILE operation, or if you don't mind losing some writes you > could use CFTRY/CFCATCH to prevent end users from seeing the error. > From: Gene Kraybill [mailto:[EMAIL PROTECTED]] > We have a simple logging system on one of our sites, and occasionally see > this error: > > Error processing CFFILE > > Error attempting to write data to > > target file 'E:/Web/ThisSite/counter/ShowPage_8_Day10.log'. > > Error: The file could not be accessed. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie: Sessions
The easiest explanation I can think to tell you is this. Instead of making a cookie do this Then wherever you need that variable you use #session.test# It's that simple. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 3:09 PM To: [EMAIL PROTECTED] Subject: Newbie: Sessions I am trying to understand sessions and trying to know when I should use them. So far I have done every thing with cookies. Is there a good place to read about sessions online? Also, I was told not to use them at all by one of the guys in the office. Is there a reason why? Thanks Art Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Comma/Number Problem
How about newstring=replace(oldstring,",","","ALL") - Original Message - From: "S R" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 1:24 PM Subject: Comma/Number Problem > Hi, > > I am trying to add a bunch of numbers to get a total value. It works fine > unless someone uses a comma to separate 'thousands': > > Ex. 10,500 > > How do I get rid of the comma before I add it up?? > > EX. 10500 > > Thanks > > Sal > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Printing with Javascript function
While we are on the topic of printing with javascript, I got a bug report today about a print function not working on Macs. So far as I can tell, the JavaScript window.print() function causes an error in IE on Macs, and does nothing at all in Netscape on Macs. Has anyone else encountered this? Is there a workaround/fix? Dana Larose JavaScript Monkey Canadian Web Design & Consulting Inc. A: 701-281 McDermot Avenue (McDermot & King) P: 204-946-5155 C: 204-228-0477 F: 204-946-5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Canadian Web Design & Consulting Inc. client engagement contract. > -Original Message- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 2:22 PM > To: [EMAIL PROTECTED] > Subject: Re: Printing with Javascript function > > > Tried the code, but did not print. So what I did was start from scratch > with what I thought would work right, but it still double prompts me, > once when the window is first open and then a second time after hitting > "OK" in the browser print window (if using Netscape). I will keep > trying. Oh, you were right, the first alert message to print does not do > anything as you suspected. > > > > > > Anthony Geoghegan wrote: > > > > |I can't remember who I talked with before, but I got assistance on > > |launching a new window with my data and prompting the user whether they > > |wanted to print the screen. What I am using works, but it > > |double prompts > > |me for printing and I am not sure why. Here is my code. > > | > > | > > | > > | > > > > Hi James > > > > You have called doit twice. > > I bet the first doit makes no differnce as to whether it prints or not. > > do something like this: > > > > > > > > > > > > This was quick and I didn't get to test it. > > > > Regards, > > Anthony Geoghegan > > Lead Developer > > Ireland Film and Television Net > > 26 South Frederick Street > > Dublin 2 > > Ireland > > Tel: +353 1 671 3664 > > Fax: +353 1 671 0763 > > Web: www.iftn.ie www.wow.ie > > mailto:[EMAIL PROTECTED] > > > > NOTICE: > > This communication is confidential. The copyright in this communication > > belongs to Ireland Film & Television Net (IFTN) or a third party. > > > > If you are not the intended recipient of this communication > please delete > > and destroy all copies and telephone IFTN on +353 1 671 3664 > immediately. > > If you are the intended recipient of this communication you > should not copy, > > disclose or distribute this communication without the authority of IFTN. > > > > Any views expressed in this communication are those of the > individual sender > > except where the sender specifically states those are of view of IFTN. > > > > Except as required by law IFTN does not represent, warrant, > and/guarantee > > that the integrity of this communication has been maintained or that the > > communication is free of virus, interception or interference. > > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Calling all Crystal Report Gurus
Problem: We have a database schema as follows: Column Headings: Date Param | Value Row 1 # usr 8 Row 2 # usr 9 Row 2 # sys 80 Row 2 # sys 71 Row 2 # idle 12 Row 2 # idle 20 What I want to do is build a line graph that shows how all these 3 vary even though the values that I want to differentiate on are all in the same column (Param). Any ideas? Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Comma/Number Problem
Hi, I am trying to add a bunch of numbers to get a total value. It works fine unless someone uses a comma to separate 'thousands': Ex. 10,500 How do I get rid of the comma before I add it up?? EX. 10500 Thanks Sal Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFFile access problem
Good point. I've noticed that some of the file contention problems seem to disappear if I use a loop to introduce a brief delay between a CFFILE Delete and a CFFILE Write operation on the same file. Is that to be expected, and should CFLOCK solve that problem (it seems that there are still some file contention or access problems). Gene Kraybill > from [EMAIL PROTECTED] > It could be contention for that file by your application. You could either > CFLOCK that CFFILE operation, or if you don't mind losing some writes you > could use CFTRY/CFCATCH to prevent end users from seeing the error. > From: Gene Kraybill [mailto:[EMAIL PROTECTED]] > We have a simple logging system on one of our sites, and occasionally see > this error: > > Error processing CFFILE > > Error attempting to write data to > > target file 'E:/Web/ThisSite/counter/ShowPage_8_Day10.log'. > > Error: The file could not be accessed. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Printing with Javascript function
Tried the code, but did not print. So what I did was start from scratch with what I thought would work right, but it still double prompts me, once when the window is first open and then a second time after hitting "OK" in the browser print window (if using Netscape). I will keep trying. Oh, you were right, the first alert message to print does not do anything as you suspected. Anthony Geoghegan wrote: > > |I can't remember who I talked with before, but I got assistance on > |launching a new window with my data and prompting the user whether they > |wanted to print the screen. What I am using works, but it > |double prompts > |me for printing and I am not sure why. Here is my code. > | > | > | > | > > Hi James > > You have called doit twice. > I bet the first doit makes no differnce as to whether it prints or not. > do something like this: > > > > > > This was quick and I didn't get to test it. > > Regards, > Anthony Geoghegan > Lead Developer > Ireland Film and Television Net > 26 South Frederick Street > Dublin 2 > Ireland > Tel: +353 1 671 3664 > Fax: +353 1 671 0763 > Web: www.iftn.ie www.wow.ie > mailto:[EMAIL PROTECTED] > > NOTICE: > This communication is confidential. The copyright in this communication > belongs to Ireland Film & Television Net (IFTN) or a third party. > > If you are not the intended recipient of this communication please delete > and destroy all copies and telephone IFTN on +353 1 671 3664 immediately. > If you are the intended recipient of this communication you should not copy, > disclose or distribute this communication without the authority of IFTN. > > Any views expressed in this communication are those of the individual sender > except where the sender specifically states those are of view of IFTN. > > Except as required by law IFTN does not represent, warrant, and/guarantee > that the integrity of this communication has been maintained or that the > communication is free of virus, interception or interference. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie: Sessions
I am trying to understand sessions and trying to know when I should use them. So far I have done every thing with cookies. Is there a good place to read about sessions online? Also, I was told not to use them at all by one of the guys in the office. Is there a reason why? Thanks Art Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FULL TEXT vs VERITY OPINIONS
What do you recommend -- what are the relative strengths of each? Appreciate the thoughts!! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
IE Browser Cache-Help
I have a page in my application which I do not wish to cache. I have put the META tag to prevent caching as follows: Also i tried CFHTTP header: but IE still is able to cache pages. Netscape responds well. Any clues. I wish to programatically control this. I have no control over the Server Configurations. Thanks in advance, Bill Thanks, Bob Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFX Wizard and header files
Ditto for me too! Thanks, Chris Lomvardias [EMAIL PROTECTED] -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 2:17 PM To: [EMAIL PROTECTED] Subject: RE: CFX Wizard and header files :-) Could you mail those to me as well.. Please :) Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 1:49 PM To: [EMAIL PROTECTED] Subject: RE: CFX Wizard and header files Done ... offlist of course :) Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: Brian Silvers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 11:45 AM To: [EMAIL PROTECTED] Subject: CFX Wizard and header files Can anyone email me the wizard file and headers needed to compile CFX tags. I faintly remember that there was a problem with CF not installing the wizard and headers. Was this problem ever resolved? If not can anyone email it to me directly at [EMAIL PROTECTED] or post it on the list if anyone else wants it? much appreciated and thanks!, Brian Silvers aka KungFusion -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
dynamically updating one select list based upon the selection in another
I have an update form in which the the user can choose an option from a select list. When this form is initially displayed, the current info from the database is automatically selected. This field happens to contain the names of various departments in our division. Each department has a default individual assigned to it (meaning that when a department is selected from the list, the information submitted will automatically be routed to the default person for that group). The field below that is a dynamically populated select list of all of the people in our division. If a user so chooses, they can override the default person assigned to a group, and specify someone else from this list. Now, here's what I want to do. When the form is first displayed, I want both the department select list AND the people list to have the current value in the db displayed (i.e. the department it will be routed to and the default contact person's name in that department). If, however, the user changes the name of the department to route to, I would like the list below it to automatically then select the default contact person's name for that department. In a nutshell, the first list will drive what is selected in the second list, but I want the second list to be independent (the first list will not change what is selected if I make a different selection in the second list). I'm assuming I will have to (ugh) use a javascript for this? Admittedly, I am neither a javascript guru nor a coldfusion guru. Can anyone provide me with some direction on this? Thanks in advance! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFX Wizard and header files
:-) Could you mail those to me as well.. Please :) Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 1:49 PM To: [EMAIL PROTECTED] Subject: RE: CFX Wizard and header files Done ... offlist of course :) Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: Brian Silvers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 11:45 AM To: [EMAIL PROTECTED] Subject: CFX Wizard and header files Can anyone email me the wizard file and headers needed to compile CFX tags. I faintly remember that there was a problem with CF not installing the wizard and headers. Was this problem ever resolved? If not can anyone email it to me directly at [EMAIL PROTECTED] or post it on the list if anyone else wants it? much appreciated and thanks!, Brian Silvers aka KungFusion -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Connecting with CFLDAP
I have been using the softartisans nta_user.dll to validate users against their nt domain accounts for access to our corporate intranet. We have just been taken over and I have been asked to validate users against an LDAP server instead. We set up a new LDAP server and I am having trouble getting this to work and wanted some troubleshooting advice. My tag reads: If I plug in the bigfoot server I get a result but when I use my local server it returns "No such object" - the IT guys assure me there is data in there and I have seen some of it. I know that cn is a valid attribute. I tried using a login and password but the result doesn't change. Can anyone help me with this?? Clare -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Test for Javascript versions and Javascript on
> I have a page which is written with JS 1.2. I would like to > write a portal > page which will test for JS on, and JS 1.0 and 1.1, and have one > conditional > CFLOCATION for (JS 1.2 and have it turned on,) and send everyone else to > the text version of the page. Is there a custom tag to do this, or does > anyone have a snippet of code they would be willing to share? Why not just do it with JS? You're running an old crumbly browser, so upgrade! Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Verity vs. Freetext
A product I use for full-text indexing and searching is called textdb (www.webest.dk) It's a small and cheap product. It's not as straight-forward to use as mssql fulltext, but it's furociously quicker than mssql or oracle (and presumably verity with comparisons of it being slower than sql7). I have a db with 500,000 records containing descriptions ranging from 5k to 1 meg of data, and ANY search I do is finished within half a second. I can do a wildcard "a" search, or a very complex conditional query using "sounds like" operators, and still get my results back in that amount of time. Not sure if version 4 is out yet, but version 3.whatever didn't support phrases, the new version does (and is just as quick as before). Building the full text index also blows away the competition. It's not as rich in features as teh others, and has a couple other limitations - but raw speed (both building, updating, and retrieving) blows ms sql and oracle (context stuff and intermedia) out of the water. I can build an index in about 20 minutes on multiple fields against the 500k record database - this is from scratch. It works as a com object, so you need to use cfobject (which I have sample code for it) - but this still works very quickly. Not sure about how it works with thai, but it's very impressive nonetheless. well, that's my 2 cents. Tom - Original Message - From: Paul Hastings <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 12:13 PM Subject: Re: Verity vs. Freetext > > Which would be faster - a verity collection, or using SQL 7's Full-text > > indexing? We are probably talking about well over 20,000 individual > > records. > > i didn't see any answers to this so...from our work sql server 7 > full text indexing beats verity flat out if you have to come back > to the db for row details. besides the obvious hit of having to > re-query the db, verity doesn't cache queries, etc. its also a > shotgun search thru the "body" of your text data which may be > from several columns & thus hard or impossible to id. on top of > that verity doesn't work w/thai language ;-) > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: QUERY QUESTION
Ok here is my perdicament. Yours worked fine SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID IN (#SI_Item_ID#) AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# however what I am really trying to do is get a count. So say there are 3 SI_OPSRPT_ID's and i pass 5 item_ids i want to do a count of how many times each ITEM shows up within those 3 reports. I'm still somewhat new at getting things to query and display properly. would want the output to be something like. >From this date to this date (i pass the date range thats what determines how many SI_opsrpt_id's will be included): There were 7 instances of this Item. ??? Kelly --- Kelly Matthews Internet Development Coordinator AAAE 703.578.2509 [EMAIL PROTECTED] http://www.airportnet.org --- > -Original Message- > From: Ben Forta [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 1:45 PM > To: [EMAIL PROTECTED] > Subject: RE: QUERY QUESTION > > Robert, actually, that would not work. As the same query name is used each > time each subsequent query would overwrite the prior one. If you ever need > to execute queries in a loop like that you must be sure to > programmatically > adjust the query name as well (perhaps by using a counter). > > --- Ben > > > -Original Message- > From: Hinojosa, Robert [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 1:36 PM > To: '[EMAIL PROTECTED]' > Subject: RE: QUERY QUESTION > > > Put the loop outside the query tag. > > > > SELECT * > FROM SI_ITEMS2 > WHERE SI_ITEM_ID = #TheITem# > AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# > > > > > Robert Hinojosa > WebDeveloper > 512.912.3775 > [EMAIL PROTECTED] > www.cirrus.com > > -Original Message- > From: Kelly Matthews [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 12:14 PM > To: '[EMAIL PROTECTED]' > Subject: QUERY QUESTION > > > Ok I have 2 queries I am running the first is: > > > SELECT * > FROM SelfInspection > WHERE 0=0 > > AND SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND > #CREATEODBCDate(form.date2)# > > > This runs fine... > > Next one is: > > > > SELECT * > FROM SI_ITEMS2 > WHERE SI_ITEM_ID = #TheITem# > AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# > > > > This seems to run fine but comes back with ONE record when it should come > back with THREE: > > Results: > qgetitems (Records=1, Time=0ms) > SQL = SELECT * FROM SI_ITEMS2 > WHERE SI_ITEM_ID = 19 AND > SI_Opsrpt_ID = 5 > SELECT * FROM SI_ITEMS2 > WHERE SI_ITEM_ID = 13 > AND SI_Opsrpt_ID = 5 > SELECT * FROM > SI_ITEMS2 > WHERE SI_ITEM_ID = 15 > AND SI_Opsrpt_ID = 5 > > It only appears to bring back ONE record however it should bring back 3 > because > ID 5 is in there with item id 19,15 and 13 but it seems to only pick up > and > display the first one > Do I need to change my query > Kelly > -- > -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: First JSP Fusebox Site?
We are not directly sharing any variables between jsp and CF. However, we transfer some variable values via URL, cookie, and through the database. There are lots of ways to share data. Occasionally, we'll make an HTTP request from CF to JSP, or vice versa, with the params in the URL. The receiving script will then take the params, set local variables, and execute some code, and give the response back via the http request. we also have the ability to read CF client variables from JSP (it's just a query to the data source). However, we decided not to attempt to set or update client vars. Also, CFOBJECT can be used to access java directly, although we are not using it. > Are you sharing jsp and cfm variables? At 12:35 AM 8/10/2000 -0400, you wrote: >Nice job Jeff, >this is one of the fastest sites I've seen in a long time The pages >just pop on the screen. > > >At 12:42 PM 8/9/2000 -0700, you wrote: > >http://BIGWORDS.com launched a new fuseboxed site this morning, using a JSP > >/ J2EE / CF combo running Weblogic and Cold Fusion on a combination of NT > >and Sun machines. > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. !j! The mark of mediocrity is searching for the precedent. !jeff! sherwood Director of BIGWORDS.com Web Site Design / JEDI BIGWORDS.com worker#2 .r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: "Need your help desperately..."
Angel, I've never see a 'Brain Dump' site that you might be referring to so I can't comment on that. But I know there are many kinds of exams for which there exist study materials, sample questions from old exams, etc., that sometimes are even recommended by the people who create the real exams. As long as nobody's trafficking in current questions it's not cheating. 'In University' (you must be not from the US) I never once took an exam that I had any expectation had exactly the same questions on it as a prior exam. Professors always ask new questions for each exam, or at least reword them so students can't simply memorize answers from an earlier exam and cheat that way. The only few exceptions are standardized tests like SATs used for college entrance screening, for which the questions are the same for a long time and are therefore guarded closely against the kind of cheating that the CF developer's exam is vulnerable to for the same reason. In college of course people study from old exams to get some kind of idea about what to expect on the next exam. Enlightened professors sometimes make old exams available. A very enlightened graduate department I was in (Physiology, UC Davis) even maintained collections of old exams in the library that students could check out, and they were encouraged to by the professors. This made the playing field level for everyone and was very constructive. The professors took them into account so that they never re-used old questions exactly as they had appeared on previous exams. Similarly, there are books of sample (old) SAT questions that many people use to study from, but these never contain the questions for the current exam. However, in no case is it considered 'not cheating' to traffic in specific questions and/or answers for a current exam (which is what we're talking about with the CF certification exam), whether it's the SAT or any college exam. And yes, anybody who does THAT is definitely 'cheapening' the efforts of the honest test-takers. That's similar to buying a term paper from one of those low-life services that sells them to cheaters. The fellow who emailed me didn't ask 'was it hard or was it easy', he is clearly looking for clueless people to feed him specific questions from the CF certification exam. Thats an attempt to cheat, pure and simple. Regards, Karl Simanonok Original Message: Date: Wed, 9 Aug 2000 19:41:05 -0300 From: "Angel Stewart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: "Need your help desperately..." Message-ID: <00b601c00252$e7eb3860$[EMAIL PROTECTED]> Ehhmm.. You think that looking at "Brain dump" sites is "Cheating" and diluting the worth of the ACPP exam? In University..did you ever go through Past Papers for the courses you were doing? Or ask the people that have done the exam before what sort of questions came.. was it hard.. was it easy.. what should be you're focus in the exam..things you should watch out for etc.?? Do you think that people who did that were "cheapening" their University exams? Do you think they were cheating? Just curious. -Gel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFX Wizard and header files
Done ... offlist of course :) Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: Brian Silvers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 11:45 AM To: [EMAIL PROTECTED] Subject: CFX Wizard and header files Can anyone email me the wizard file and headers needed to compile CFX tags. I faintly remember that there was a problem with CF not installing the wizard and headers. Was this problem ever resolved? If not can anyone email it to me directly at [EMAIL PROTECTED] or post it on the list if anyone else wants it? much appreciated and thanks!, Brian Silvers aka KungFusion -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: First JSP Fusebox Site?
thanks a lot. That's what sun equipment and a stringent graphics budget buys ya! j At 12:35 AM 8/10/2000 -0400, Frank Priest wrote: >Nice job Jeff, >this is one of the fastest sites I've seen in a long time The pages >just pop on the screen. > > >At 12:42 PM 8/9/2000 -0700, you wrote: > >http://BIGWORDS.com launched a new fuseboxed site this morning, using a JSP > >/ J2EE / CF combo running Weblogic and Cold Fusion on a combination of NT > >and Sun machines. > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. !j! The mark of mediocrity is searching for the precedent. !jeff! sherwood Director of BIGWORDS.com Web Site Design / JEDI BIGWORDS.com worker#2 .r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: QUERY QUESTION
Robert, actually, that would not work. As the same query name is used each time each subsequent query would overwrite the prior one. If you ever need to execute queries in a loop like that you must be sure to programmatically adjust the query name as well (perhaps by using a counter). --- Ben -Original Message- From: Hinojosa, Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 1:36 PM To: '[EMAIL PROTECTED]' Subject: RE: QUERY QUESTION Put the loop outside the query tag. SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = #TheITem# AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# Robert Hinojosa WebDeveloper 512.912.3775 [EMAIL PROTECTED] www.cirrus.com -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:14 PM To: '[EMAIL PROTECTED]' Subject: QUERY QUESTION Ok I have 2 queries I am running the first is: SELECT * FROM SelfInspection WHERE 0=0 AND SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND #CREATEODBCDate(form.date2)# This runs fine... Next one is: SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = #TheITem# AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# This seems to run fine but comes back with ONE record when it should come back with THREE: Results: qgetitems (Records=1, Time=0ms) SQL = SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 19 AND SI_Opsrpt_ID = 5 SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 13 AND SI_Opsrpt_ID = 5 SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 15 AND SI_Opsrpt_ID = 5 It only appears to bring back ONE record however it should bring back 3 because ID 5 is in there with item id 19,15 and 13 but it seems to only pick up and display the first one Do I need to change my query Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What is: Team Allaire?
So I could get all of this for 450? Just a user that refers others to cf? We don't have any cf trainning in columbus ohio? -paul -Original Message- From: Michael Sheldon [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 11:23 AM To: [EMAIL PROTECTED] Subject:RE: What is: Team Allaire? >>What is the license restriction on CF Ent, for example? Not for resale, not for production use. It's useful for development and demonstration purposes, but you cannot use it for hosting real sites. Michael J. Sheldon http://www.desertraven.com/ Make a fast friend, adopt a greyhound! -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 07:09 To: [EMAIL PROTECTED] Subject: Re: What is: Team Allaire? So are you telling me I should have become an Allaire Alliance partner instead of subscribing to CF & Studio? What is the license restriction on CF Ent, for example? best, paul At 09:05 AM 8/10/00 -0500, you wrote: >Hey genius add it up...2 copies of spectra NT and SL $15 K each to >purchase...JRun 5K, 4 Copies 4.5 Ent (LX,HP,SL,NT) at 5K a pop. That alone >is 55K plus you get CF Studio and Homesite. > > > > > I recently became a Allaire Alliance partner. I think it is well worth >the > > $450. You get over $50K worth of software access to new betas and yes a > > members only portion of the site. The cost is definetely small compared >to > > what you get. > > > > Kevin Schmidt -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Array Confusion
How do I populate a one dimensional array from a query?? I'm having trouble figuring out how I make the 'Array number' dynamic: SELECT Quantity, ID FROM TestTable #QuantityTotal[??]# Thanks Sal Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: QUERY QUESTION
Kelly, You can't execute 3 SELECT statements in a single query that way. You should combine them into one statement that might look something like this: SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID IN (#SI_Item_ID#) AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# --- Ben -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 1:14 PM To: '[EMAIL PROTECTED]' Subject: QUERY QUESTION Ok I have 2 queries I am running the first is: SELECT * FROM SelfInspection WHERE 0=0 AND SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND #CREATEODBCDate(form.date2)# This runs fine... Next one is: SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = #TheITem# AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# This seems to run fine but comes back with ONE record when it should come back with THREE: Results: qgetitems (Records=1, Time=0ms) SQL = SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 19 AND SI_Opsrpt_ID = 5 SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 13 AND SI_Opsrpt_ID = 5 SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 15 AND SI_Opsrpt_ID = 5 It only appears to bring back ONE record however it should bring back 3 because ID 5 is in there with item id 19,15 and 13 but it seems to only pick up and display the first one Do I need to change my query Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: QUERY QUESTION
Put the loop outside the query tag. SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = #TheITem# AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# Robert Hinojosa WebDeveloper 512.912.3775 [EMAIL PROTECTED] www.cirrus.com -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:14 PM To: '[EMAIL PROTECTED]' Subject: QUERY QUESTION Ok I have 2 queries I am running the first is: SELECT * FROM SelfInspection WHERE 0=0 AND SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND #CREATEODBCDate(form.date2)# This runs fine... Next one is: SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = #TheITem# AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID# This seems to run fine but comes back with ONE record when it should come back with THREE: Results: qgetitems (Records=1, Time=0ms) SQL = SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 19 AND SI_Opsrpt_ID = 5 SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 13 AND SI_Opsrpt_ID = 5 SELECT * FROM SI_ITEMS2 WHERE SI_ITEM_ID = 15 AND SI_Opsrpt_ID = 5 It only appears to bring back ONE record however it should bring back 3 because ID 5 is in there with item id 19,15 and 13 but it seems to only pick up and display the first one Do I need to change my query Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(IIS) Customer file uploads - restrictions of file types
We are getting requests from our customers to upload files to a password secured area of our site so they can share them with other users from their company, as well as with our internal people. The intent is for files like Excel, Word, and Powerpoint documents. Some of the restrictions we need to do are pretty straightforward, like who can upload, who can delete, total file size, etc., but what pitfalls do I need to watch out for from a server security standpoint? We are on IIS 4.0, Windows NT 4.0 SP5, CF4.5 ENT, with plans to go to Win2000. Is it as simple as restricting certain executable file types? All advice is truly appreciated . . . unless Dave Watts sends me more code from our site . . . whoops . . . :) Thanks, Dan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can CF be run on a machine which is also running Service Pack 6 Alpha?
Well Currently I am running CF4.5 Professional on SP6a and haven't had any problems at all. I think he might be afraid of running anything critical on SP6a or mabey he has legitimate concerns that I am not aware of. He does have a reputation to keep up for that company and not being reliable is the last thing they want. Chris Straight -Original Message- From: Wayne, Kurt [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 4:36 PM To: '[EMAIL PROTECTED]' Subject: Can CF be run on a machine which is also running Service Pack 6 A lpha? We're trying to move a web site to a designated box with our host (Navisite). However, we've been told that there are problems with installing CF on a machine using this SP. The person who said this didn't specify what the problems were...I'm having to rely on it second-hand. What problems are there, and are there ways around it? Thanks, gang. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
sorry!
This is a multi-part message in MIME format. --=_NextPart_000_01BC_01C002BE.B794D4C0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable .. about the vacation message - I thought I had disabled it for = cf-talk... Additionally, I asked a question a couple of days ago and have not heard = back yet. The message subject read: CFFILE upload gives Error 5 on NT anyone have any feedback or similar experiences??? Joyce E. Evans WebMaster Healthwell.com=20 (303) 998-9278 --=_NextPart_000_01BC_01C002BE.B794D4C0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable .. about the vacation message - I = thought I had=20 disabled it for cf-talk... Additionally, I asked a=20 question a couple of days ago and have not heard back yet. The message = subject=20 read: CFFILE upload gives Error 5 on NT anyone have any feedback or similar=20 experiences??? Joyce E. = EvansWebMasterHealthwell.com=20 (303) 998-9278 --=_NextPart_000_01BC_01C002BE.B794D4C0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: COM Objects?
Never mind, I figured it out. Pretty slick stuff actually. Thanks again Ben Forta and his books. > -Original Message- > From: Bill Killillay [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 10, 2000 11:29 AM > To: Cf-Talk > Subject: COM Objects? > > > How does one go about calling a com object from ColdFusion? > > Bill > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.