RE: DNS question
i used them for a while, they went Tango Uniform multiple times while i did so. hey, it's free, but you get what you pay for. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 2:26 PM To: CF-Talk Subject: Re: DNS question Take a look at www.granitecanyon.com for free DNS hosting... There's also plenty of "public dns" places out there that will do DNS hosting for you for cheap. -Novak - Original Message - From: "Bryan F. Hogan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 9:35 AM Subject: RE: DNS question > You could, I don't know if they will do it for you though. If they can they > will most likely charge some sort of fee. > But if they don't there are many companies such as mine that can handle this > for you. I can't believe there is a hosting company that does not offer DNS > though. Kind of eccentric to me. > > -Original Message- > From: Phoeun Pha [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 12:02 PM > To: CF-Talk > Subject: DNS question > > > Hey guys > > I have a site that was registered through Verio (verio.com). And now I am > going to have ti hosted on a new site, and my host has given me the IP > address for the site. However, the host doesn't have a DNS service. > > What do I do? Right now, the verio guys are my DNS service. DO i call them > to tell them to make an update to their DNS information? can u do that? > > Thanks > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DNS question
if i remember correctly, verio specifically does NOT offer domain pointing. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 12:02 PM To: CF-Talk Subject: DNS question Hey guys I have a site that was registered through Verio (verio.com). And now I am going to have ti hosted on a new site, and my host has given me the IP address for the site. However, the host doesn't have a DNS service. What do I do? Right now, the verio guys are my DNS service. DO i call them to tell them to make an update to their DNS information? can u do that? Thanks __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cflocation and a popup
right, there wouldn't be. you call the function at this point, not define
it.
function popUpb(URL) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(home_login.cfm, '" + id + "',
'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,wid
th=580,height=580,bgcolor=#11');");
}
...
...
popUpb('www.foo.com');
-Original Message-
From: Kodjo Ackah [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 1:49 PM
To: CF-Talk
Subject: RE: Cflocation and a popup
No joy to this either!
function popUpb(URL) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(home_login.cfm, '" + id + "',
'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,wid
th=580,height=580,bgcolor=#11');");
}
Kodjo ackah
Principal Consultant
concrete-media.com
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does cgi.http_referer ALWAYS work?
perhaps also the standard (and good!) advice for security. the less a person knows about a given setup, the less handles they have to use to crack into it. chris -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 8:18 PM To: CF-Talk Subject: Re: Does cgi.http_referer ALWAYS work? On 7/1/02 9:22 AM, "S. Isaac Dealey" <[EMAIL PROTECTED]> wrote: >>> Do some firewalls prevent browsers passing on this variable? >> >> Yes > > I guess this would typically be the firewall at the user's location preventing > the data going out, rather than the firewall at the server's location > preventing the data coming in... I'm not sure I understand the reasoning > behind either tho... Why would a network admin want to prevent this info going > out? > Fear __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF vs. ASP
as much as we all love CF, it is NEVER a good idea to "put all your eggs in one basket". let me repeat that for emphasis. IT IS NEVER A GOOD IDEA TO KEEP ALL YOUR EGGS IN ONE BASKET. in my own experience, companies are more likely to be in favor of someone with one or two specialties, but with a smattering of other things the candidat is "good at, but not expert". as a former hirer myself, it says to me that the person is not a "all problems are nails" person, and is willing to look at the best way to get the job done, rather than the "best way to use the one thing i know to do the job". there are light years of difference between the two. chris olive -Original Message- From: Perez, Jimmy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 3:44 PM To: CF-Talk Subject: CF vs. ASP Hello all, I am a CF certified developer (missed advanced by three points) but am thinking of expanding my horizons/marketability. I have started getting up to speed in ASP/VBScript but the question keeps coming up: should I even spend any time doing this or should I just concentrate on CF? The more e-mails I read in this list, the more I realize how powerful CF is, but should I keep all my eggs in one basket so to speak? Any good advice? TIA Jimmy __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Variable names in CFMX
neither. it just is. chris -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 1:31 AM To: CF-Talk Subject: RE: Variable names in CFMX Sorry, I didn't saw it. It's a bug or a "feature"? :o) I found it when dealing with dynamic variables name such as 1a,1b,1c,1d,2a,2b,2c,3d and so forth. I think this is a very common thing isn't? []'s Alex > -- Mensagem original --- > > De : "Christopher Olive" <[EMAIL PROTECTED]> > Para: CF-Talk <[EMAIL PROTECTED]> > Cc : > Data: Sun, 25 Aug 2002 01:26:47 -0400 > Assunto : RE: Variable names in CFMX > > i believe that this came up in a previous thread. as a reprise, the "D" > denotes "decimal notation", and as such, is equal to 55 (in which th e > decimal (as opposed to hex/octal) notation) is the default. > > -Original Message- > From: Alex Hubner [mailto:[EMAIL PROTECTED]] > Sent: Sunday, August 25, 2002 1:00 AM > To: CF-Talk > Subject: Re: Variable names in CFMX > > > Hi folks, this is little bit offtopic but it's very weird: > > > > Equal!Different > > The CFMX outputs "Equal"... Does anybody have a clue about what migh t > it be? This is syntax problem when converting it to Java? I didn't > see any mention to that in the CFMX docs. > > By the way: CFMX still "typeless"? And what about when the CFMX code > is converted to Java code? How the JIT decides which data type a > variable has? > > Abraços! > Alex > > > -- Mensagem original --- > > > > De : "Jim McAtee" <[EMAIL PROTECTED]> > > Para: CF-Talk <[EMAIL PROTECTED]> > > Cc : > > Data: Sat, 24 Aug 2002 21:25:48 -0600 > > Assunto : Re: Variable names in CFMX > > > > Funny you should mention that. About a month ago I was trying to de > vise a > > naming convention for CF variables used as constants in a particul ar > > application. I don't bother using variable prefixes in my applica ti > ons, but > > was hoping to use a leading underscore to denote a "constant". Of c > ourse, > > in CF5 it was invalid. > > > > Jim > > > > > > - Original Message - > > From: "Michael Dinowitz" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Saturday, August 24, 2002 9:08 PM > > Subject: Re: Variable names in CFMX > > > > > > > I agree that there's no meaning for them and it'll be even more co > nfusing > > to people coming from other languages such as perl. Personally, I' m > never > > going to use them. > > > Even in another arcane naming convention. > > > > > > > > > > On Saturday, August 24, 2002, at 07:22 , Michael Dinowitz wrot e: > > > > > > > > > > > > > > > #_new# #$new# > > > > > > > > Maybe it's in preparation for the VAX port? ;) > > > > > > > > I can think of no value whatsoever for allowing either of thes e. > They do > > > > not contribute to readability and there's every chance that so me > bright > > > > spark will come along and 'invent' some cryptic meaning for th em > in yet > > > > another arcane naming convention :( > > > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Variable names in CFMX
i believe that this came up in a previous thread. as a reprise, the "D" denotes "decimal notation", and as such, is equal to 55 (in which the decimal (as opposed to hex/octal) notation) is the default. -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 1:00 AM To: CF-Talk Subject: Re: Variable names in CFMX Hi folks, this is little bit offtopic but it's very weird: Equal!Different The CFMX outputs "Equal"... Does anybody have a clue about what might it be? This is syntax problem when converting it to Java? I didn't see any mention to that in the CFMX docs. By the way: CFMX still "typeless"? And what about when the CFMX code is converted to Java code? How the JIT decides which data type a variable has? Abraços! Alex > -- Mensagem original --- > > De : "Jim McAtee" <[EMAIL PROTECTED]> > Para: CF-Talk <[EMAIL PROTECTED]> > Cc : > Data: Sat, 24 Aug 2002 21:25:48 -0600 > Assunto : Re: Variable names in CFMX > > Funny you should mention that. About a month ago I was trying to de vise a > naming convention for CF variables used as constants in a particular > application. I don't bother using variable prefixes in my applicati ons, but > was hoping to use a leading underscore to denote a "constant". Of c ourse, > in CF5 it was invalid. > > Jim > > > - Original Message - > From: "Michael Dinowitz" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, August 24, 2002 9:08 PM > Subject: Re: Variable names in CFMX > > > > I agree that there's no meaning for them and it'll be even more co nfusing > to people coming from other languages such as perl. Personally, I'm never > going to use them. > > Even in another arcane naming convention. > > > > > > > On Saturday, August 24, 2002, at 07:22 , Michael Dinowitz wrote: > > > > > > > > > > > > #_new# #$new# > > > > > > Maybe it's in preparation for the VAX port? ;) > > > > > > I can think of no value whatsoever for allowing either of these. They do > > > not contribute to readability and there's every chance that some bright > > > spark will come along and 'invent' some cryptic meaning for them in yet > > > another arcane naming convention :( > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Exchange and CFMAIL
ah. 5.5. i was talking about 2000. 5.5. handles relay differently, but the box and checkbox should say something to that effect. http://www.exchangeadmin.com/Articles/Index.cfm?ArticleID=7696 has complete instructions on how to secure relay on 5.5. notice that it has to be at least exchange 5.5 SP2. -Original Message- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 18, 2002 7:09 PM To: CF-Talk Subject: Re: MS Exchange and CFMAIL My IT person can't seem to find "Only the IPs below" on the relay tab in exchange for Exchange 5.5. What is he missing here? Jim Watkins - Original Message - From: "Christopher Olive" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 10:43 AM Subject: RE: MS Exchange and CFMAIL > > Actually, you can allow "Only the IPs below" on the relay tab in exchange, > and enter the IP of the web server. > > i also usually use SMTP on IIS, however, if the web box is in a domain with > the Exchange box, exchange likes to grab the mail instead of letting IIS > handle it. it's strange, but i've noticed that behaviour here. it may be > that IIS recognizes exchange in the domain, and uses its own SMTP as a smart > relay, though. > > chris olive > > -Original Message- > From: Robert Everland [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 8:34 AM > To: CF-Talk > Subject: RE: MS Exchange and CFMAIL > > > In order to let CF relay, Exchange has to allow everyone relay, or CF has to > be on the same box as Exchange, neither of these are good options. I just > use the built in SMTP that comes with IIS, works pretty good. > > Robert Everland III > Web Developer Extraordinaire > Dixon Ticonderoga Company > http://www.dixonusa.com > > -Original Message- > From: Jim Watkins [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 14, 2002 10:45 PM > To: CF-Talk > Subject: MS Exchange and CFMAIL > > > My IT person cannot seem to set MS Exchange Server so that it will allow the > Coldfusion Server to Relay mail. Could someone point me in the right > direction on this? > > Thanks, > > Jim Watkins > > > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Exchange and CFMAIL
Actually, you can allow "Only the IPs below" on the relay tab in exchange, and enter the IP of the web server. i also usually use SMTP on IIS, however, if the web box is in a domain with the Exchange box, exchange likes to grab the mail instead of letting IIS handle it. it's strange, but i've noticed that behaviour here. it may be that IIS recognizes exchange in the domain, and uses its own SMTP as a smart relay, though. chris olive -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:34 AM To: CF-Talk Subject: RE: MS Exchange and CFMAIL In order to let CF relay, Exchange has to allow everyone relay, or CF has to be on the same box as Exchange, neither of these are good options. I just use the built in SMTP that comes with IIS, works pretty good. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 10:45 PM To: CF-Talk Subject: MS Exchange and CFMAIL My IT person cannot seem to set MS Exchange Server so that it will allow the Coldfusion Server to Relay mail. Could someone point me in the right direction on this? Thanks, Jim Watkins __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win 232 error
IIRC, the message means that the network pipe to the DB closed down. of course, that was mostly in regards to SQL server, in my experience. -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 11:45 AM To: CF-Talk Subject: RE: Win 232 error > from "net helpmsg 232" > > "The pipe is being closed". > > Is this application running against SQL server? Oracle 8i __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win 232 error
from "net helpmsg 232" "The pipe is being closed". Is this application running against SQL server? -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 11:28 AM To: CF-Talk Subject: Win 232 error I'm seeing a LOT of this in my server.log: "Error","TID=217","08/12/02","10:37:40","Error number 232 occurred attempting to close connection to web server." "Error","TID=217","08/12/02","10:37:40","Windows NT error number 232 occurred." Any clues as to what it might be? -- Al Everett Allied Office Supplies www.askallied.com mailto:[EMAIL PROTECTED] v: 973-594-3209 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client Variables vs. Session Variables
true, only strings/ints. however, you can serialize your structures/arrays with WDDX and store the packets as client vars to do an end run around that. chris -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 12:10 AM To: CF-Talk Subject: RE: Client Variables vs. Session Variables we recently converted our entire product to client vars since we needed to move into a clustered servers. But only limitation that I know of is the type and size of the data you are storing. I beleive you can not do any type of structures or arrays as client varibles. Only strings or Int. matt -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 11:45 PM To: CF-Talk Subject: Re: Client Variables vs. Session Variables Nope, single server ... it is a distributed app that is currently using Session variables ... and most people who use it are on shared servers and such ... I just really like the client variables for a shopping cart so the cart can hang around .. the session variables timeout ... but I just am curious as to why some would use one over the other in a basic setup. Paul Giesenhagen QuillDesign - Original Message - From: "Matthew Friedman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 09, 2002 10:51 PM Subject: RE: Client Variables vs. Session Variables > are you in a clustered server configuration? > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 09, 2002 11:35 PM > To: CF-Talk > Subject: Client Variables vs. Session Variables > > > Which and why would you prefer either one of these to hold shopping cart > information. > > Curious as to reason why one over the other. > > Thank you > Paul Giesenhagen > QuillDesign > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf-talk quiz ...
that's why you should use www.tightvnc.com. :) -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 7:27 PM To: CF-Talk Subject: RE: cf-talk quiz ... Your kidding me, its Friday?!* I had no idea, this week has been a big waste with downed servers. I swear PCanywhere is a little &^%$! Be very cerful when you install PCanywhere. Its gets it's grubby little hooks everywhere and can cause some serious issues Brook At 04:06 PM 09/08/02 -0700, you wrote: >I can tell I am not too sophisticated, I am going to find a joint that has >some bloody good beers, hope everyone has a great weekend. > >Kind Regards - Mike Brunt, CTO >Webapper >http://www.webapper.com >Downey CA Office >562.243.6255 >AIM - webappermb > >"Webapper - Making the NET work" > > >-Original Message- >From: Vernon Viehe [mailto:[EMAIL PROTECTED]] >Sent: Friday, August 09, 2002 3:39 PM >To: CF-Talk >Subject: RE: cf-talk quiz ... > > >h. None of the above. (Worn out from the week, out looking for the nearest >establishment that can mix a decent Manhattan.) > > > -Original Message- > > From: Dan Haley [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 09, 2002 3:20 PM > > To: CF-Talk > > Subject: cf-talk quiz ... > > > > > > Sheesh, it's quiet in here today ... > > > > Is that because: > > > > a) everyone is off registering for devcon, a conference those > > of us in the > > Telecom industry won't be going to this year (and didn't go > > to last year ... > > boohoo) > > > > b) everyone is over on cf-community continuing their > > 'conversations' and I > > forgot to subscribe so I'm missing out ... > > > > c) Michael's in a mood and has his finger on the delete key > > as posts come in > > (or is that Judith's finger?) ... just kidding HOF team! > > > > d) a new federal holiday today that my employer didn't tell > > me about ... > > possibly Matt Liotta Appreciation Day ... just kidding Matt! > > > > e) Bill Wheatley is in vocab rehab ... not kidding Bill! ;) > > > > f) the single guys are off learning Flash in case there are any cute > > designers at the conference this year ... get back to your > > desk Phillip! > > > > g) one or more of the above > > > > > > Ahh, it's one of those days ... had to do it ... hasn't the > > list been great > > lately! > > > > Dan > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: createdatetime(??)
24 isn't a valid 24 hour clock hour. midnight is 00:00:00. just before it
comes 23:59:59.
chris olive.
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 5:56 PM
To: CF-Talk
Subject: RE: createdatetime(??)
The quotes work okay, with any combination other than "24" as the hour. As
soon as I put 24 in, it fails.
At 10:31 PM 02/08/02 +0100, you wrote:
>Try taking out the quotes, I don't think you need them. 12am is midday,
12pm
>is 24:00...
>
>I think :O)
>
>Ade
>
>-Original Message-
>From: Brook Davies [mailto:[EMAIL PROTECTED]]
>Sent: 02 August 2002 22:40
>To: CF-Talk
>Subject: createdatetime(??)
>
>
>When using the createdatetime() function, the format must use a 24 hour
>clock right?
>
>I'm a wee bit confused, how do you show 12am and 12pm. Isn't 12AM 24:00
>hours?? I get an error when trying to create a 12AM time like this:
>
>#createdatetime("2002","8","2","24","00","00")#
>
>Any idea why? I'm sure I'm missing something obvious...
>
>Brook
>
>
>
>
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and SQL
store it as a string. the only reason to store something as a numerical value (int, float, etc) is if you plan to do mathematical things to it. SSNs don't really need that, so string storage would be your best bet. chris -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:35 PM To: CF-Talk Subject: RE: CF and SQL Any clue on how I can display a social security... Im having problems if the first digit is a zero How do I format the number so it displays all of the digits??? -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:24 PM To: CF-Talk Subject: Re: CF and SQL Do a select from the table with the ID you are going to use in the update, if the select query returns a recordcount > 0 then update it, if not then don't. HTH Clint -- Original Message -- from: "Tangorre, Michael" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 31 Jul 2002 14:22:59 -0400 Ok, I am interested in peoples opinions on the following: Is it best practice to check for a records existence before attempting to update it? And what would the best way to go about that be? Michael Tangorre MillenniuM Information Systems 1101 Wilson Blvd, Suite 1200 Arlington, Virginia 22209 (703) 341-1438 This email contains MillenniuM Information Systems, LLC. privileged information. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Collecting Email to put into verity
do you have the emails in an email client? most can dump to a flat tab delimited style file. if you can do that, import them into access/sql, then use verity to index the table. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:01 PM To: CF-Talk Subject: Collecting Email to put into verity I have been asked to create an email archive search engine for an email list server I am a member of. The list server is out on a box that we have no control over. So I was thinking of using CFpop to collect the email then write the emails to txt files so Verity can index them. I have not used CFpop yet, but I would assume I would need CFfile to write the txt files. It sounds like a kludge and will be slow. The list only get about 50 emails a day though. Is there another way of collecting the email so verity can index them? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL on form submission
that's not strictly correct. (before i begin, i always SSL the form itself, since it gives the users warm fuzzies). when a user calls up a form and enters data into it, the data is still on their local PC. it has not gone "over the wire" yet. if the form's action page is HTTPS, when the user submits the form, the request *and all its data* are encrypted. but, as i said, i prefer to encrypt the form so the user can see the little glowing lock (or whatnot) and feel good. chris -Original Message- From: Joel Firestone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 11:17 AM To: CF-Talk Subject: Re: SSL on form submission Well, if I understand it correctly, the SSL secures the data being transferred. If you only use it on the action page, and not the submission itself, the data going from form.cfm to action.cfm would not be secure. But if form.cfm is in SSL, then it would be secure. HTH - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 11:05 AM Subject: RE: SSL on form submission > That is the safe way I would assume.. but is it necessary? > > > > -Original Message- > From: Joel Firestone [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 30, 2002 9:58 AM > To: CF-Talk > Subject: Re: SSL on form submission > > I always do it for the form. The submission would then be protected. > > HTH > > - Original Message - > From: "Chad Gray" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 30, 2002 10:55 AM > Subject: SSL on form submission > > > > Im wondering if when a form is submitted at what point do you request > > SSL? > > > > Do you want the form to be covered under SSL as the user is filling it > > out? https://www/form.cfm > > > > Or do you leave the form http://www/form.cfm and use > > https://www/action.cfm"; method="POST"> enough to encrypt > > the data being passed to the action page? > > > > Just curious > > > > > > > > > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple User Authorization
more or less. you have a table of groups with the associated permissions. (edit, delete, etc). then a table with the group(s) to which a user belongs. otherwise, correct. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 4:55 PM To: CF-Talk Subject: Re: Multiple User Authorization So you have table that holds the users information and their roles say, edit,delete,gifts,orders,settings <--- those are the rolls that a user has access too. Then when the user logs in, you build a structure that is request.security.edit/request.security.delete ...with all of the users approvals... and save that struct to a session/client variable? Then are you doing a simple ...go to login Am I going down the right path? Paul Giesenhagen QuillDesign - Original Message - From: "Dan Haley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 29, 2002 3:38 PM Subject: RE: Multiple User Authorization > Not NT ... we did something similar to what he's suggesting. We set up > 'roles' in a lookup table in the database, then in our user maintenance > screen we can check which roles a user has. This comma-delimited string of > numbers goes into their 'state' that we maintain also in the database. When > a page loads we create a structure called request.security and fill it with > boolean values for all the roles. Then on any page you can check for > request.security.name_of_some_role and if true, they are a member. > > Dan > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 29, 2002 1:32 PM > To: CF-Talk > Subject: Re: Multiple User Authorization > > > No, these will be individuals and not groups. Are you talking about > permissions on an NT box? > > Paul Giesenhagen > QuillDesign > > > would a group style set of permissions be a good idea? give permissions > to > > the groups, then assign people to them (NT/Win2K ACLs, really). it'll cut > > down on overhead a bit. > > > > -Original Message- > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 29, 2002 4:05 PM > > To: CF-Talk > > Subject: Multiple User Authorization > > > > > > I am looking for suggestions on a user authorization method. > > > > Basically, I have multiple users with various different access levels > > thourghout the application. Some can get into some places while others > > can't, and even some can get in everywhere. > > > > There are basically 20 different location restrictions. My question would > > be what would be the best way/practice to tackle this. > > > > Here is what I have come up with (but think it's a bit cumbersome). > > > > Setup table with the 20 different access columns > > (editor,admin,colors,settings,gifts ect...) and give them a 1 or 0 > > > > Then when the user logs in build a struct with the access levels and check > > the struct for that access level (1) when entering a page if 0, send them > > away to the beggining. > > > > Seems a bit cumbersome ... so I am looking for alternatives. > > > > Any thoughts? > > > > I appreciate your input > > > > Paul Giesenhagen > > QuillDesign > > > > > > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple User Authorization
that's exactly the sort of thing i'm suggestion. group ACLs in the application itself, not the OS. -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 4:39 PM To: CF-Talk Subject: RE: Multiple User Authorization Not NT ... we did something similar to what he's suggesting. We set up 'roles' in a lookup table in the database, then in our user maintenance screen we can check which roles a user has. This comma-delimited string of numbers goes into their 'state' that we maintain also in the database. When a page loads we create a structure called request.security and fill it with boolean values for all the roles. Then on any page you can check for request.security.name_of_some_role and if true, they are a member. Dan -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:32 PM To: CF-Talk Subject: Re: Multiple User Authorization No, these will be individuals and not groups. Are you talking about permissions on an NT box? Paul Giesenhagen QuillDesign > would a group style set of permissions be a good idea? give permissions to > the groups, then assign people to them (NT/Win2K ACLs, really). it'll cut > down on overhead a bit. > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 29, 2002 4:05 PM > To: CF-Talk > Subject: Multiple User Authorization > > > I am looking for suggestions on a user authorization method. > > Basically, I have multiple users with various different access levels > thourghout the application. Some can get into some places while others > can't, and even some can get in everywhere. > > There are basically 20 different location restrictions. My question would > be what would be the best way/practice to tackle this. > > Here is what I have come up with (but think it's a bit cumbersome). > > Setup table with the 20 different access columns > (editor,admin,colors,settings,gifts ect...) and give them a 1 or 0 > > Then when the user logs in build a struct with the access levels and check > the struct for that access level (1) when entering a page if 0, send them > away to the beggining. > > Seems a bit cumbersome ... so I am looking for alternatives. > > Any thoughts? > > I appreciate your input > > Paul Giesenhagen > QuillDesign > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple User Authorization
would a group style set of permissions be a good idea? give permissions to the groups, then assign people to them (NT/Win2K ACLs, really). it'll cut down on overhead a bit. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 4:05 PM To: CF-Talk Subject: Multiple User Authorization I am looking for suggestions on a user authorization method. Basically, I have multiple users with various different access levels thourghout the application. Some can get into some places while others can't, and even some can get in everywhere. There are basically 20 different location restrictions. My question would be what would be the best way/practice to tackle this. Here is what I have come up with (but think it's a bit cumbersome). Setup table with the 20 different access columns (editor,admin,colors,settings,gifts ect...) and give them a 1 or 0 Then when the user logs in build a struct with the access levels and check the struct for that access level (1) when entering a page if 0, send them away to the beggining. Seems a bit cumbersome ... so I am looking for alternatives. Any thoughts? I appreciate your input Paul Giesenhagen QuillDesign __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: problems with SSL and host-headers
yes. yes i did write that. co. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:19 PM To: CF-Talk Subject: Re[2]: problems with SSL and host-headers Hello Christopher, Monday, July 29, 2002, 4:43:40 PM, you wrote: CO> right. this changes the "one of three" rule for site identification in IIS. CO> three things identify a virtual site in IIS: CO> 1) IP address. CO> 2) Port number. CO> 3) Host header. CO> change at least one of the three, and you have a "different site" in IIS. CO> SSL will not work, however, if you're using host headers as your "one of CO> three". CO> chris CO> -Original Message- CO> From: WebMaster [mailto:[EMAIL PROTECTED]] CO> Sent: Monday, July 29, 2002 9:37 AM CO> To: CF-Talk CO> Subject: Re: problems with SSL and host-headers CO> They were correct. Since IIS can't see the header, your request is going to CO> be sent directly to port 443, which is most likely listened to by the CO> default or admin virtual domain.. \ CO> However, this is possible. I have done this in the past using the undefined CO> ports starting at 28000. If you set your SSL port to 28000 for that virtual CO> domain, this should work. You just have to remember to code all your links CO> to point to the correct port. CO> - Original Message - CO> From: "Christopher Olive" <[EMAIL PROTECTED]> CO> To: "CF-Talk" <[EMAIL PROTECTED]> CO> Sent: Monday, July 29, 2002 9:28 AM CO> Subject: RE: problems with SSL and host-headers >> pretty much correct. in IIS, you cannot use host headers to differentiate >> sites AND use an SSL cert on those sites. the request is encrypted >> (obviously, it's SSL), and IIS can't see the encrypted host header to know >> which site to send it to (and which SSL cert to use to decrypt it). >> >> -Original Message- >> From: cf-talk [mailto:[EMAIL PROTECTED]] >> Sent: Saturday, July 27, 2002 5:16 PM >> To: CF-Talk >> Subject: OT: problems with SSL and host-headers >> >> >> Hi list, >> I have a CF-shared box with >> one IP-adress. >> I would like to do the following: >> Having access to https://subdomain.domain.com:443 >> I have a valid certificate for this subdomain from Thawte >> but when I try to connect to that URL >> I get an error, that there is no such server. >> I am sure it has s.th. to do with host-headers. >> Someone else told me, that you can only run one certificate >> with one port (e.g. 443) on the same IP using host-headers (HTTP 1.1) >> Can s.o. verify this ? >> Thanks Uwe >> >> CO> __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: problems with SSL and host-headers
right. this changes the "one of three" rule for site identification in IIS. three things identify a virtual site in IIS: 1) IP address. 2) Port number. 3) Host header. change at least one of the three, and you have a "different site" in IIS. SSL will not work, however, if you're using host headers as your "one of three". chris -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 9:37 AM To: CF-Talk Subject: Re: problems with SSL and host-headers They were correct. Since IIS can't see the header, your request is going to be sent directly to port 443, which is most likely listened to by the default or admin virtual domain.. \ However, this is possible. I have done this in the past using the undefined ports starting at 28000. If you set your SSL port to 28000 for that virtual domain, this should work. You just have to remember to code all your links to point to the correct port. - Original Message - From: "Christopher Olive" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 29, 2002 9:28 AM Subject: RE: problems with SSL and host-headers > pretty much correct. in IIS, you cannot use host headers to differentiate > sites AND use an SSL cert on those sites. the request is encrypted > (obviously, it's SSL), and IIS can't see the encrypted host header to know > which site to send it to (and which SSL cert to use to decrypt it). > > -Original Message- > From: cf-talk [mailto:[EMAIL PROTECTED]] > Sent: Saturday, July 27, 2002 5:16 PM > To: CF-Talk > Subject: OT: problems with SSL and host-headers > > > Hi list, > I have a CF-shared box with > one IP-adress. > I would like to do the following: > Having access to https://subdomain.domain.com:443 > I have a valid certificate for this subdomain from Thawte > but when I try to connect to that URL > I get an error, that there is no such server. > I am sure it has s.th. to do with host-headers. > Someone else told me, that you can only run one certificate > with one port (e.g. 443) on the same IP using host-headers (HTTP 1.1) > Can s.o. verify this ? > Thanks Uwe > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: problems with SSL and host-headers
pretty much correct. in IIS, you cannot use host headers to differentiate sites AND use an SSL cert on those sites. the request is encrypted (obviously, it's SSL), and IIS can't see the encrypted host header to know which site to send it to (and which SSL cert to use to decrypt it). -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 5:16 PM To: CF-Talk Subject: OT: problems with SSL and host-headers Hi list, I have a CF-shared box with one IP-adress. I would like to do the following: Having access to https://subdomain.domain.com:443 I have a valid certificate for this subdomain from Thawte but when I try to connect to that URL I get an error, that there is no such server. I am sure it has s.th. to do with host-headers. Someone else told me, that you can only run one certificate with one port (e.g. 443) on the same IP using host-headers (HTTP 1.1) Can s.o. verify this ? Thanks Uwe __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Quickbooks integration?
I did this a few months ago. go to quickbooks.com and look for their import/export forum. you can dump the DB files to IIF (their import ASCII files) and use QB to import them there. -Original Message- From: Pardeep [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 6:29 AM To: CF-Talk Subject: CF and Quickbooks integration? Does anyone have any exp. in CF and Quickbooks integration? Am trying to figure out how to take info in a DB and insert into Quickbooks. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using Text lists variable in SQL "IN" operator
what's the actual problem?
at a look, try putting 's around the IN clause stuff.
(dbo.answer_rating.eval_email IN ('#manager_direct_staff#')
-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 7:05 PM
To: CF-Talk
Subject: Using Text lists variable in SQL "IN" operator
I'm having difficulty using the "IN" operator condition on a text list
dynamically generated from previous query. Any suggestions?
SELECT userid
FROM emp
WHERE status='A'
AND level = 2
start with userid='#ATTRIBUTES.manager#'
connect by sup_emp_no=prior emp_no
and emp_no <> sup_emp_no
SELECT AVG(dbo.answer_rating.answer_value) as category_avg
FROMdbo.answer_rating
WHERE (dbo.answer_rating.site_id = #ATTRIBUTES.site_id#)
AND
(dbo.answer_rating.question_id IN
(#category_qid#)) AND
(dbo.answer_rating.eval_email IN
(#manager_direct_staff#)) AND
(dbo.answer_rating.self = 'n')
In this case, I am having some problems using the "manager_direct_staff"
list variable.
Thanks SQL experts!
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: record linking prob
it's because the CFOUTPUT doesn't have a queryname attached. any references to searchresults.fieldname will refer to the first record returned from that query (as correctly mentioned previously be several responses.) chris -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 3:33 PM To: CF-Talk Subject: RE: record linking prob here is the whole file ... not sure exactly what you want ... still learning here =) . i need to sit down and go through it to see why it now works SELECT * FROM RecordTable ORDER BY Title ASC Material Results Material RESULTS Records #StartRow_searchResults# to #EndRow_searchResults# of #searchResults.RecordCount#Title Author Date #searchResults.Title # #searchResults.Author# #dateformat(searchResults.Date, "/mm/dd")# Records #StartRow_searchResults# to #EndRow_searchResults# of #searchResults.RecordCount# __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: record linking prob
could you post the remaining code around it? i'm assuming that you're using CFLOOP or CFOUTPUT. just those parts would be helpful. and as a checkbrain exerercise, IS there more than one record? -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:35 PM To: CF-Talk Subject: record linking prob Hey I am a newbie here and am having abit of troubles ... i am trying to link together a brief results page to a full details page. i am able to create the link, but when I click on it, it always brings me to the same record ... here is my source: #searchResults.Title# . no matter when I click on it I always get record one ... any suggestions would be appreciated. thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query
try...
SELECT c.id, c.description
FROM
choicetable c
WHERE
c.productid = '#URL.productid#'
AND c.id NOT IN (
SELECT
pc.choiceid
FROM
productchoicetable pc
WHERE
pc.productid = '#URL.productid#'
)
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 10:22 AM
To: CF-Talk
Subject: OT: SQL Query
I have a query that I am trying to get all my descriptions from my
choiceTable that are not found in my productChoiceTable that have a
productid of a url.product value. Basically if a choice id is found in the
productChoiceTable that also has the url.productid in the productid column,
it is discarded in the result.
Here is my table layout:
choiceTable
id, choice, description
productChoiceTable
id,choiceid,productid
SELECT c.id, c.description
FROM choiceTable c, productChoiceTable pc
WHERE c.id = pc.choiceid
AND pc.productid NOT IN ('#url.productid#')
Any suggestions apreciated!
Paul Giesenhagen
QuillDesign
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: coldfusion search
consider that the % sign is the "wildcard" match for ANSI SQL. if you put it after the search term in the LIKE clause (as you did with BEGINS_WITH), you search for something that has . the is the % sign. now, you want something that will match any characters before and after the search term. put the % on both sides of the search term. like so... -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:04 PM To: CF-Talk Subject: coldfusion search Hi ... i am a newbie to CF ... I was wondering if some one could help me figure out how to make a search box that can do a "contains" search ... i can get the begins with and the equals, but not contains ... see below thanks! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quick Help
Believe it's ListLast(CGI.script_name, "/"). this is OTC, so you might want to check the name of the CGI variable. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 11:35 AM To: CF-Talk Subject: Quick Help I know I asked yesturday and got the answer but all of our emails have been purged so Can someone quick tell me how to grab just the page name from the browser... For example I want to set pagename = index.cfm How do I get the index.cfm -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 10:10 AM To: CF-Talk Subject: NEW (ColdFusion MX or ColdFusion 4.5) and Session Variables (Bug) Ok Ok... Tested on ColdFusion MX on a Solaris 7 with Apache 1.3.26 Web Server ColdFusion 4.5 on Windows NT with IIS Web Server Both when hitting refresh after the page is already running the session.cartquantity becomes inaccurate at a different rate... if I hit refresh a short time the error is small if I hit refresh a longer time into the code the error is greater. The Loop was put in to simulate the slow speed of the page while connected to the AS400. What should I test next?? I am all ears? well as much as I can be... I even put some locks around where I am setting the session variables to something. It looks like it is not rerunning the page from the top when I hit refresh. -- Code -- Before Everything: Session.Carttotal:#session.carttotal# Session.CartQuantity:#session.cartquantity# SELECT * FROMOreckDealerCart WHERE OreckDealer_id = #session.dealer_id# select sum(quantity) As CartTotal FROMOreckDealerCart WHERE OreckDealer_id = #session.dealer_id# Before Query: Session.Carttotal:#session.carttotal# Session.CartQuantity:#session.cartquantity# In Query: Session.Carttotal:#session.carttotal# Session.CartQuantity:#session.cartquantity# Quantity 1:#quantity# Session.CartQuantity:#session.cartquantity# Quantity 2:#quantity# #session.cartquantity# Items #dollarformat(session.carttotal)# Total > -Original Message- > From: Stacy Young [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 25, 2002 8:51 AM > To: CF-Talk > Subject: RE: ColdFusion MX and Session Variables (Bug) > > > We are and have been using session scope heavily. I can't say > I've seen this > problem yet...will let you know...we're about to QA our first > MX project. > > Stace > > -Original Message- > From: Nathan Stanford [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 25, 2002 8:56 AM > To: CF-Talk > Subject: RE: ColdFusion MX and Session Variables (Bug) > > > -Original Message- > > From: Jon Hall [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 24, 2002 4:19 PM > > To: CF-Talk > > Subject: Re: ColdFusion MX and Session Variables > > > > > > What about that session.dealer_id? > > Yes when adding Testing Variables the out put stayed the same. > > Is it staying consistent? What > > about the actual data? Is there some other query somewhere writing > > data that is affecting the price and or quantity variables, which I > > assume are coming from the qry_checkoutcart query, but I'm not sure, > > because they aren't scoped...hint hint :) > > They are not scoped because there is a AS400 Query and they can not be > scoped because there is no resultset coming back from the AS400. > Price is not coming from qry_checkoutcart but I guess I could go scope > quantity. We > have tried several drivers with ColdFusion MX on a Solaris 7 > with Apache > 1.3.26 Web Server. When we tried the same thing on the NT it > seemed to be > fine. We even created a test page outside the application to > verify it was > not linked to any other page. > > > Who out there is working on a Solaris 7 with ColdFusion and Apache? > > > Testing Code Below > > > > > > > SELECT * > FROMOreckDealerCart > WHERE OreckDealer_id = #session.dealer_id# > > > > > > > > > > > > > > > > > >request.cartquantity=#request.cartquantity#+#qry_checkoutcart. > quantity#> > > > > #session.dealer_id# > #session.carttotal# > #session.cartquantity# > #price# X #quantity# = #subtotal# > > > > >alt="View Cart"> > > > > #session.cartquantity# Items > #dollarformat(session.carttotal)# Total > > > > > > > > > > > > > > > > -- > > Jon > > mailto:[EMAIL PROTECTED] > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/ind
RE: SQL Delete Trigger
should those be INs instead of =s? WHERE coupon_id IN (SELECT coupon_id FROM deleted) ? how many rows come back from deleted? -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 7:53 PM To: CF-Talk Subject: OT: SQL Delete Trigger This is my first attempt at a trigger. I have the following code, but it doesn't seem to be deleting the records from the respondant or question table. Any ideas why? CREATE TRIGGER trg_DeleteCoupon ON coupon FOR DELETE AS DELETE FROM respondant WHERE coupon_id = (SELECT coupon_id FROM deleted) DELETE FROM question WHERE coupon_id = (SELECT coupon_id FROM deleted) Thx, Duane __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS Problem - HELP!
Hey, no problem. After having been wrong so many times in my life, it's nice to hear a dissenting viewpoint. :) (now if i could just get the people to whom i'm emailing my resumes to admit the same...preferably followed by a "for the job!")... :) i'm in touch. i've been reading this list for 2+ years. although, feel free to drop me a private line if you need something... Chris Olive -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:02 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Chris, You were right! (You've got to love it when someone says that.) The client has their 'staging' server - which is actually a single site they test multiple sites on in subdirectories. Whereas their live environment, has the site sitting in it's own directory. Just as you described. Thus, making it impossible to use "/" root level referencing because your testing on one server that is configured differently than the live server. The client had original informed us their staging enviroment was configured the same as their live enviroment. And this being an internal server, we weren't able to confirm anything. I'm going to work with my Project Manager and the client on possible resolutions. Thanks for all of your help! Keep in touch. - Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:46 PM To: CF-Talk Subject: RE: IIS Problem - HELP! I would very much appreciate it if you'd stop reading my mind. :) Seriously, that's exactly it. I'lll await your answer. Good luck. Chris Olive -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:59 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Hmm... I think I know where your going - What if their staging IS completely different than their live - and when they are testing, it's on a stripped down version of IIS that supports only one site, with subdirectories, and their testing on that subdirectory. "/" would be usesless in referencing. Good thought! I'll get back to you with the answer, hopefully that is the issue. Thanks! Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:15 PM To: CF-Talk Subject: RE: IIS Problem - HELP! right. are the client's directory structures the same on both machines? i'm looking for something like this... dev box: http://clienturl points to / / - has all root files /images - has all appropriate images staging - http://clienturl points to / /clientname - has all root files /clientname/images - has image files. c -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:50 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Yes, the source of the image tag is correct. Everything works fine on our development enviroment for referencing from the root (ie "/images/something.gif"), however on their staging server it does not. It only works if it is referenced either "../images/something.gif" or "images/something.gif". It's not a matter of the code, it's a matter of the server settings to get it to accept the "/" reference for root. - Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:31 PM To: CF-Talk Subject: RE: IIS Problem - HELP! take a look at the page. do a view source. look at the SRC of the IMG tag. is it actually correct? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS Problem - HELP!
I would very much appreciate it if you'd stop reading my mind. :) Seriously, that's exactly it. I'lll await your answer. Good luck. Chris Olive -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:59 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Hmm... I think I know where your going - What if their staging IS completely different than their live - and when they are testing, it's on a stripped down version of IIS that supports only one site, with subdirectories, and their testing on that subdirectory. "/" would be usesless in referencing. Good thought! I'll get back to you with the answer, hopefully that is the issue. Thanks! Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:15 PM To: CF-Talk Subject: RE: IIS Problem - HELP! right. are the client's directory structures the same on both machines? i'm looking for something like this... dev box: http://clienturl points to / / - has all root files /images - has all appropriate images staging - http://clienturl points to / /clientname - has all root files /clientname/images - has image files. c -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:50 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Yes, the source of the image tag is correct. Everything works fine on our development enviroment for referencing from the root (ie "/images/something.gif"), however on their staging server it does not. It only works if it is referenced either "../images/something.gif" or "images/something.gif". It's not a matter of the code, it's a matter of the server settings to get it to accept the "/" reference for root. - Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:31 PM To: CF-Talk Subject: RE: IIS Problem - HELP! take a look at the page. do a view source. look at the SRC of the IMG tag. is it actually correct? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS Problem - HELP!
right. are the client's directory structures the same on both machines? i'm looking for something like this... dev box: http://clienturl points to / / - has all root files /images - has all appropriate images staging - http://clienturl points to / /clientname - has all root files /clientname/images - has image files. c -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:50 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Yes, the source of the image tag is correct. Everything works fine on our development enviroment for referencing from the root (ie "/images/something.gif"), however on their staging server it does not. It only works if it is referenced either "../images/something.gif" or "images/something.gif". It's not a matter of the code, it's a matter of the server settings to get it to accept the "/" reference for root. - Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:31 PM To: CF-Talk Subject: RE: IIS Problem - HELP! take a look at the page. do a view source. look at the SRC of the IMG tag. is it actually correct? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS Problem - HELP!
take a look at the page. do a view source. look at the SRC of the IMG tag. is it actually correct? -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:25 PM To: CF-Talk Subject: RE: IIS Problem - HELP! IIS Version - 5 Win2k box - The images appears broken. I can't give you a url because it's a protected internal server of the clients. Thanks! - Paul -Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 21, 2002 11:18 AM To: CF-Talk Subject: RE: IIS Problem - HELP! What version of IIS? Do they get an error, or is the image just broken? What's the URL? chris olive -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 5:13 PM To: CF-Talk Subject: OT: IIS Problem - HELP! Calling all of the IIS geniuses on this list! I know this is a CF list, but I'm sure there are a few of you. :) I have a client whose server appears not to allow relative referencing from the root - Example: "/images/SomePic.gif" In order for them to reference any images they have to use the relative dot notation from whichever directory they are in - Example "../../images/SomePic.gif" Does anyone know how this may have been disabled in IIS? And if so, how to re-enable referencing from the root. THANKS!!! - Paul __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Card Processors
unfortunately, i don't have control over their choice of payment gateways. c -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 11:03 AM To: CF-Talk Subject: RE: Card Processors You might want to check out TrustCommerce (www.trustcommerce.com). They have a Java CFX and the transaction process is very fast. Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Card Processors
sweet. do i need an account to download it first? it looks like i do. co -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 10:29 AM To: CF-Talk Subject: RE: Card Processors You can download their custom tag from within the manager tool... We are using it and it works fined for us.. -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 10:28 AM To: CF-Talk Subject: RE: Card Processors revivfying a dead topic... just tasked by a client to research verisign's payflow to "see if i think it'll work with their website"... (love specific assignments...:)) when you say "they" have a CF function for it, who's they? verisign? i saw a "manager.verisign.com" control panel type thing, where they claim i can download their SDK. is this where i get the custom tag? from a usability standpoint, how's the cf tag? have you had technical problems with verisign? (i should bite my tongue for THAT. :)) co. -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 10:43 AM To: CF-Talk Subject: RE: Card Processors We used payflow and they have a CF function for it. It works fine, with an ok management system -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 9:51 AM To: CF-Talk Subject: Card Processors Has any one had any experience with Paymentech as a credit card processor? How did integration go, were there any canned CF tools you were able to use? Thanks, Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Card Processors
revivfying a dead topic... just tasked by a client to research verisign's payflow to "see if i think it'll work with their website"... (love specific assignments...:)) when you say "they" have a CF function for it, who's they? verisign? i saw a "manager.verisign.com" control panel type thing, where they claim i can download their SDK. is this where i get the custom tag? from a usability standpoint, how's the cf tag? have you had technical problems with verisign? (i should bite my tongue for THAT. :)) co. -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 10:43 AM To: CF-Talk Subject: RE: Card Processors We used payflow and they have a CF function for it. It works fine, with an ok management system -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 9:51 AM To: CF-Talk Subject: Card Processors Has any one had any experience with Paymentech as a credit card processor? How did integration go, were there any canned CF tools you were able to use? Thanks, Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia selling partner information?
I don't recall, when i was a partner, anywhere saying that i could use the partner list as a non-optin email list. of course, i harbor no real hard feelings about the whole thing. it's a tough old marketing world right now. -Original Message- From: Jennifer Hanes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:59 PM To: CF-Talk Subject: RE: Macromedia selling partner information? PaperThin regrets the inconvenience of a recent email distributed to current and past Macromedia partners. PaperThin intended solely to introduce the company to other Macromedia partners, who may have an interest in content management solutions. Macromedia did not sell the contact information which was used. Macromedia does provide a means for partners to post their contact information; the email addresses posted on those listings were used. We directed that introduction to those individuals listed as the primary contact for their organization, under the assumption that these individuals might have interest in receiving information from other Macromedia partners. PaperThin regrets any inconvenience this may have caused to current or past Macromedia partners. Jennifer F. Hanes Vice President, Marketing & Operations PaperThin, Inc. [EMAIL PROTECTED] www.paperthin.com > -Original Message- > From: Meg-Ann Meaney [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 5:29 PM > To: CF-Talk > Subject: FW: Macromedia selling partner information? > > Hello: > > Neither Allaire nor Macromedia sold the Allaire partner > names. I am investigating how this may have occurred, but > understand that companies have "screen scraped" company names > from the website. As past partners, there would have been a > time when you were included in search results intended for > customers to locate partners with a particular expertise. > > I will update you when I learn more. > > Best regards, > Meg Meaney > Director, Partner Programs > Macromedia, Inc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing efficient CFIF statements
no, no problem. but linguistic/semantic/heuristic/epistemologic theory is a hobby, and i spend too much time/effort looking at what people most likely mean sometimes. :) c -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 3:46 PM To: CF-Talk Subject: RE: Writing efficient CFIF statements sounds like Christopher is got a new problem with CFIF/IIF??? too much coffee??? :) -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 3:30 PM To: CF-Talk Subject: RE: Writing efficient CFIF statements We're getting mired in semantics. We're technically both correct. but we can continue the conversation, if you like. :) -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:50 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements A Boolean value is a logical TRUE or FALSE. In some languages, this is represented as 0 and 1 or 0 and non-zero, but that's an implementation detail. -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:33 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements but it IS a boolean. 1 and 0 are boolean yes and no (in most languages). chris olive -Original Message- From: Patrick McElhaney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:59 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements If QueryResults is supposed to be a boolean, isn't it better to make it a boolean? Doesn't that make it easier to understand the intent of the code? The above statement tells me that QueryResults holds the number of records in the query. If I output the variable, I'll get a number. This tells me that QueryResults is a boolean, and represents whether the query has any records. If I output the variable, I'll get "YES" or "NO." Patrick > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 8:25 AM > To: CF-Talk > Subject: Re: Writing efficient CFIF statements > > > This thread is odd. As Tim pointed out earlier, any non-zero > value evaluates as TRUE so you can just say > and be done with it. > That's far cleaner for the eye. > > > - Original Message - > From: "Patrick McElhaney" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 17, 2002 12:20 AM > Subject: RE: Writing efficient CFIF statements > > > > Clean and fast: > > > > > > > > Patrick > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing efficient CFIF statements
We're getting mired in semantics. We're technically both correct. but we can continue the conversation, if you like. :) -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:50 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements A Boolean value is a logical TRUE or FALSE. In some languages, this is represented as 0 and 1 or 0 and non-zero, but that's an implementation detail. -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:33 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements but it IS a boolean. 1 and 0 are boolean yes and no (in most languages). chris olive -Original Message- From: Patrick McElhaney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:59 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements If QueryResults is supposed to be a boolean, isn't it better to make it a boolean? Doesn't that make it easier to understand the intent of the code? The above statement tells me that QueryResults holds the number of records in the query. If I output the variable, I'll get a number. This tells me that QueryResults is a boolean, and represents whether the query has any records. If I output the variable, I'll get "YES" or "NO." Patrick > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 8:25 AM > To: CF-Talk > Subject: Re: Writing efficient CFIF statements > > > This thread is odd. As Tim pointed out earlier, any non-zero > value evaluates as TRUE so you can just say > and be done with it. > That's far cleaner for the eye. > > > - Original Message - > From: "Patrick McElhaney" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 17, 2002 12:20 AM > Subject: RE: Writing efficient CFIF statements > > > > Clean and fast: > > > > > > > > Patrick > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia selling partner information?
I just received this as well. I'm no longer a partner, either. Chris Olive -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 2:29 PM To: CF-Talk Subject: Macromedia selling partner information? The follow unsolicited email was received to a Disposable Email Address only used for my now expired Allaire Cold Fusion Partner program registration. I cannot even check my preferences as I no longer have an account. Anyone else get this and does anyone recall if the partners policy provides for the selling of our information? Justin > -Original Message- > From: Eric Long [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 1:59 PM > To: [EMAIL PROTECTED] > Subject: PaperThin Offers Powerful, Affordable Content Management > Solution > > Are you looking for an affordable, full-featured content > management solution for your customers? > > Then consider PaperThin's award-winning CommonSpot Content Server 3.0. > Call me today if you'd like to learn more about > CommonSpot Content Server, the leading ColdFusion-based > content management solution. > > Sincerely, > > > Eric Long > PaperThin, Inc. > www.paperthin.com > 781-934-7838 x 217 > [EMAIL PROTECTED] > > > > PaperThin respects your need for privacy. If you do not > wish to receive further communications from PaperThin, > you can unsubscribe by replying to this email with the > word "REMOVE" in the subject line. > > > > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing efficient CFIF statements
but it IS a boolean. 1 and 0 are boolean yes and no (in most languages). chris olive -Original Message- From: Patrick McElhaney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:59 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements If QueryResults is supposed to be a boolean, isn't it better to make it a boolean? Doesn't that make it easier to understand the intent of the code? The above statement tells me that QueryResults holds the number of records in the query. If I output the variable, I'll get a number. This tells me that QueryResults is a boolean, and represents whether the query has any records. If I output the variable, I'll get "YES" or "NO." Patrick > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 8:25 AM > To: CF-Talk > Subject: Re: Writing efficient CFIF statements > > > This thread is odd. As Tim pointed out earlier, any non-zero > value evaluates as TRUE so you can just say > and be done with it. > That's far cleaner for the eye. > > > - Original Message - > From: "Patrick McElhaney" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 17, 2002 12:20 AM > Subject: RE: Writing efficient CFIF statements > > > > Clean and fast: > > > > > > > > Patrick > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscript for in vs cfloop collection...
try removing the # signs from around the collection name, and if that
doesn't work, double your ""'s inside the outside ""s...
examples:
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 3:56 PM
To: CF-Talk
Subject: cfscript for in vs cfloop collection...
Perhaps someone else can see what I am doing wrong here (cf5). I've had this
problem in the past, and just included the code inline with a cfloop around
my cfscript, but now I want to convert the code to a UDF...
Here is the code.
This works fine:
This throws an invalid parser construct error at the second parentheses (yes
I have tried both single and double quotes):
for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
Am I wrong in assuming that cfloop-collection and cfscript for-in loops are
the same?
jon
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ping & TraceRt from a web page?
CFEXECUTE? -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 3:23 PM To: CF-Talk Subject: OT: Ping & TraceRt from a web page? Sorry for the OT post, if anybody has any input on this, you can email me off list. Thank you. I know there are services on the web for this, so I know it's possible. I would like to put a link on one of my pages to ping or tracert a specific IP. Simply put, I would like to mimic the DOS commands via this link. Anybody know how I can do this? Thanks in advance. Ryan J. Pieszak Applications Engineer Ziphany, LLC. (716) 510-0379 www.ziphany.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting Up SQL 7 Database in MX
do you have usernames and passwords defined in the CFAdmin? -Original Message- From: Double Down [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 8:09 PM To: CF-Talk Subject: Setting Up SQL 7 Database in MX I just installed CFMX and when I went to my data sources page I see that there is an error on all SQL 7 databases. I checked my ODBC Administrator and the database is connected through there. How do I set if up in the CF Administrator? TIA DDINC __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 4 million messages per hour - is it possible?
you could do one of two things, actually. 1) use CFFILE to write a raw message to the SMTP queue directory. simple format, really. let the SMTP queue handle routing and such. 2) use CFOBJECT and CDO to create an SMTP mail object native to windows. create it, write a message using the object's methods, send. rinse, repeat. co. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 8:42 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? We did use CF to generate the email files. I can't say how, but I can tell you that using and to accomplish writing millions of files in a short period of time is not a problem. -Matt > -Original Message- > From: Jeff Green [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 01, 2002 5:02 PM > To: CF-Talk > Subject: RE: 4 million messages per hour - is it possible? > > That makes sense :) > > Did CF call a componet that wrote the files to the queue. > > I dont assume you did the following but I must ask to make sure. Did you > happen to write the files by querying the DB for addresses then looping > over > the query (Ive heard cfloop is very slow) and using cffile to write the > email to the mail server's queue? > > jeff > > -Original Message- > From: Matt Liotta [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 01, 2002 4:32 PM > To: CF-Talk > Subject: RE: 4 million messages per hour - is it possible? > > > Nope, can't be done using cfmail. We wrote files directly to the mail > server's queue. > > -Matt > > > > -Original Message- > > From: Jeff Green [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 01, 2002 4:10 PM > > To: CF-Talk > > Subject: RE: 4 million messages per hour - is it possible? > > > > How exactly is this cf driven. Cant imagine you did it with cfmail. > > > > Jeff > > > > -Original Message- > > From: Matt Liotta [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 01, 2002 3:25 PM > > To: CF-Talk > > Subject: RE: 4 million messages per hour - is it possible? > > > > > > I developed a system using LSMTP that could easily do 4 million > messages > > per hour that was driven from CF. > > > > -Matt > > > > > > > -Original Message- > > > From: Mark Warrick [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, July 01, 2002 3:15 PM > > > To: CF-Talk > > > Subject: 4 million messages per hour - is it possible? > > > > > > Hello, > > > > > > Has anyone had experience in creating an emailing solution driven by > > > ColdFusion and SQL on any platform with any mail server that is > > capable of > > > handling 4 million deliveries an hour? If so, would you care to > share > > > what > > > software you used to make it happen? And do you have a live example > > of a > > > company using the system? > > > > > > ---mark > > > > > > > > > Mark Warrick ([EMAIL PROTECTED]) > > > Founder, Fusioneers.com / CTO, ZapConnect.com > > > Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 > > > http://www.warrick.net / http://www.fusioneers.com > > > http://www.zapconnect.com > > > ICQ: 125160 AIM: markwarric Yahoo: Serengeti > > > > > > > > > > > > > > > > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Firewall configuration for CF and SQL (sort of OT)
out of curiosity, why would you want to separate the CF API from the webserver with regards to security? that setup doesn't seem to lend itself to being more secure. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 5:47 PM To: CF-Talk Subject: RE: Firewall configuration for CF and SQL (sort of OT) The only thing that should be in your DMZ is a web server with port 443 and 80 open through the firewall...You need can point the web server connector to a remote CF machine to render your templates Stace -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 2:36 PM To: CF-Talk Subject: Re: Firewall configuration for CF and SQL (sort of OT) On 6/27/02, Dustin Snell [Unisyn Software, LLC] penned: >We are attempting to secure our network which was admittedly *not secure* >before. So, we have purchased a 3COM Superstack 3 firewall which is up and >running and seems to be working great. I am wondering what the recommended >topology should be for the Web Server (which is Windows 2000 Server, running >IIS and Coldfusion 4.5) and the SQL Server (diff machine, Windows 2000 >Server, SQL 2000). It seems to me that the web server should be in the DMZ >(in front of the firewall) but I have the following questions. > > > >1) Should the SQL Server be behind the firewall? The answer seems to me to >be yes - if so, what port do I have to open to allow communication between >the Web/CF Server and the SQL Server so that they can still talk to each >other. Our intranet (LAN users) and website (WAN) users need to access the >same database. > I can't say I'm an expert my any means, but I have both my web server and SQL Server behind the firewall.The only access I allow to the SQL box is to TCP/IP on port 1433 for Enterprise Manager and the port for my Remote administration software, and then only from certain IP addresses. I won't let any clients access the SQL Server unless they have a static IP Address, which I haven't needed to at this point. If I get a client with dialup that needs to access SQL Server through Ent. Mgr., I'll cross that bridge then. Not sure why you'd put the web server in the DMZ. I have just the ports needed to be open for the web server, 80, 443, 21, 8383, 8484, (both for web mail) 25, 110, 53 (DNS and mail are currently running on the mail server, but I'm moving mail to a dedicated server in the next week or so). I block all UDP traffic except to port 53 (DNS). I only open the port for my remote administration to my IP address here at home. Once I get mail moved, I'll only have ports 80, 443 and 21 and 53 open to the web server. Hopefully, I'll have the money one day for a dedicated DNS server and can close port 53 also. :) > >These other questions are more off topic but help would still be *very much >* appreciated > >2) For servers in the DMZ, is there any rational reason for them to be in >the domain? Wouldn't it be more secure to keep those machines as >standalone (non-domain) machines so that if they are compromised, all >domain machines are still behind the firewall? The only benefit I can see >to keeping them in the domain is group policy. Can't answer domain questions. My servers are all standalone. >Misc... even more OT: > >3) For those running DNS servers in house, is it customary for you to >actually have a dedicated DNS machine? Or do you, as we currently do, use a >server for dual purpose (maybe it would be an FTP Server and a DNS Server). >Also, are there any "plug and play" DNS "network appliances" available that >wouldn't require a $1000+ license of Windows 2000 server? I can't answer the appliance question, but I'm running DNS using Bind for NT. It's pretty simple and works well. You could probably get a cheap box running Linux and run Bind to avoid the cost of Windows. That's probably what I'll do when I move DNS off the web server. Hope that helped a little. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Firewall configuration for CF and SQL (sort of OT)
oh, and as a side note, i run DNS on two sub $400 machines (each) using RH 7.2 and BIND 9.x. chris. -Original Message- From: Dustin Snell [Unisyn Software, LLC] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 4:33 PM To: CF-Talk Subject: Re: Firewall configuration for CF and SQL (sort of OT) I agree, thanks for your help! -Dustin Snell Unisyn Software, LLC - Original Message - From: "Christopher Olive" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 1:17 PM Subject: RE: Firewall configuration for CF and SQL (sort of OT) > putting the webserver in the DMZ is a good idea, since the majority of web > server compromises are via port 80 anyway. and the principle of the DMZ > (isolated public servers such that, if they are compromised, they cannot be > used as bastion hosts for attacks) applies here. > > -Original Message- > From: Bud [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 2:36 PM > To: CF-Talk > Subject: Re: Firewall configuration for CF and SQL (sort of OT) > > > On 6/27/02, Dustin Snell [Unisyn Software, LLC] penned: > >We are attempting to secure our network which was admittedly *not secure* > >before. So, we have purchased a 3COM Superstack 3 firewall which is up and > >running and seems to be working great. I am wondering what the recommended > >topology should be for the Web Server (which is Windows 2000 Server, > running > >IIS and Coldfusion 4.5) and the SQL Server (diff machine, Windows 2000 > >Server, SQL 2000). It seems to me that the web server should be in the > DMZ > >(in front of the firewall) but I have the following questions. > > > > > > > >1) Should the SQL Server be behind the firewall? The answer seems to me > to > >be yes - if so, what port do I have to open to allow communication between > >the Web/CF Server and the SQL Server so that they can still talk to each > >other. Our intranet (LAN users) and website (WAN) users need to access > the > >same database. > > > > I can't say I'm an expert my any means, but I have both my web server > and SQL Server behind the firewall.The only access I allow to the SQL > box is to TCP/IP on port 1433 for Enterprise Manager and the port for > my Remote administration software, and then only from certain IP > addresses. I won't let any clients access the SQL Server unless they > have a static IP Address, which I haven't needed to at this point. If > I get a client with dialup that needs to access SQL Server through > Ent. Mgr., I'll cross that bridge then. > > Not sure why you'd put the web server in the DMZ. I have just the > ports needed to be open for the web server, 80, 443, 21, 8383, 8484, > (both for web mail) 25, 110, 53 (DNS and mail are currently running > on the mail server, but I'm moving mail to a dedicated server in the > next week or so). I block all UDP traffic except to port 53 (DNS). I > only open the port for my remote administration to my IP address here > at home. Once I get mail moved, I'll only have ports 80, 443 and 21 > and 53 open to the web server. Hopefully, I'll have the money one day > for a dedicated DNS server and can close port 53 also. :) > > > > >These other questions are more off topic but help would still be *very > much > >* appreciated > > > >2) For servers in the DMZ, is there any rational reason for them to be in > >the domain? Wouldn't it be more secure to keep those machines as > >standalone (non-domain) machines so that if they are compromised, all > >domain machines are still behind the firewall? The only benefit I can > see > >to keeping them in the domain is group policy. > > Can't answer domain questions. My servers are all standalone. > > >Misc... even more OT: > > > >3) For those running DNS servers in house, is it customary for you to > >actually have a dedicated DNS machine? Or do you, as we currently do, use > a > >server for dual purpose (maybe it would be an FTP Server and a DNS > Server). > >Also, are there any "plug and play" DNS "network appliances" available > that > >wouldn't require a $1000+ license of Windows 2000 server? > > > I can't answer the appliance question, but I'm running DNS using Bind > for NT. It's pretty simple and works well. You could probably get a > cheap box running Linux and run Bind to avoid the cost of Windows. > That's probably what I'll do when I move DNS off the web server. > > Hope that helped a little. > -- > > Bud Schneehagen - Tropical Web Creations >
RE: Firewall configuration for CF and SQL (sort of OT)
putting the webserver in the DMZ is a good idea, since the majority of web server compromises are via port 80 anyway. and the principle of the DMZ (isolated public servers such that, if they are compromised, they cannot be used as bastion hosts for attacks) applies here. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 2:36 PM To: CF-Talk Subject: Re: Firewall configuration for CF and SQL (sort of OT) On 6/27/02, Dustin Snell [Unisyn Software, LLC] penned: >We are attempting to secure our network which was admittedly *not secure* >before. So, we have purchased a 3COM Superstack 3 firewall which is up and >running and seems to be working great. I am wondering what the recommended >topology should be for the Web Server (which is Windows 2000 Server, running >IIS and Coldfusion 4.5) and the SQL Server (diff machine, Windows 2000 >Server, SQL 2000). It seems to me that the web server should be in the DMZ >(in front of the firewall) but I have the following questions. > > > >1) Should the SQL Server be behind the firewall? The answer seems to me to >be yes - if so, what port do I have to open to allow communication between >the Web/CF Server and the SQL Server so that they can still talk to each >other. Our intranet (LAN users) and website (WAN) users need to access the >same database. > I can't say I'm an expert my any means, but I have both my web server and SQL Server behind the firewall.The only access I allow to the SQL box is to TCP/IP on port 1433 for Enterprise Manager and the port for my Remote administration software, and then only from certain IP addresses. I won't let any clients access the SQL Server unless they have a static IP Address, which I haven't needed to at this point. If I get a client with dialup that needs to access SQL Server through Ent. Mgr., I'll cross that bridge then. Not sure why you'd put the web server in the DMZ. I have just the ports needed to be open for the web server, 80, 443, 21, 8383, 8484, (both for web mail) 25, 110, 53 (DNS and mail are currently running on the mail server, but I'm moving mail to a dedicated server in the next week or so). I block all UDP traffic except to port 53 (DNS). I only open the port for my remote administration to my IP address here at home. Once I get mail moved, I'll only have ports 80, 443 and 21 and 53 open to the web server. Hopefully, I'll have the money one day for a dedicated DNS server and can close port 53 also. :) > >These other questions are more off topic but help would still be *very much >* appreciated > >2) For servers in the DMZ, is there any rational reason for them to be in >the domain? Wouldn't it be more secure to keep those machines as >standalone (non-domain) machines so that if they are compromised, all >domain machines are still behind the firewall? The only benefit I can see >to keeping them in the domain is group policy. Can't answer domain questions. My servers are all standalone. >Misc... even more OT: > >3) For those running DNS servers in house, is it customary for you to >actually have a dedicated DNS machine? Or do you, as we currently do, use a >server for dual purpose (maybe it would be an FTP Server and a DNS Server). >Also, are there any "plug and play" DNS "network appliances" available that >wouldn't require a $1000+ license of Windows 2000 server? I can't answer the appliance question, but I'm running DNS using Bind for NT. It's pretty simple and works well. You could probably get a cheap box running Linux and run Bind to avoid the cost of Windows. That's probably what I'll do when I move DNS off the web server. Hope that helped a little. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pointing multiple sites to the same IP
if you want a hand, let me know on or off list. co. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 12:06 AM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Yeah - I should give it a shot. -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 10:55 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP hey, i try to be nice. :) although, you could use my method to redirect traffic to the site so your clients won't get that message. co. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 11:31 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Chris, You give me too much credit. This is my "pro-bono" box. I set it up myself and I can tell you that there's no custom 403.3 setup. The server has a single IP and about 5 virtual sites mapped to it. The only one with a CERT is "secure.cfwebtools.com". Apparently, since it's the only 443 port listening - it gets the SSL traffic by default. It does generate an initial error message regarding the CERT not matching the host info. Mark -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 10:03 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP they probably have a custom 403.3 error setup in IIS for www.necfug.com. it most likely redirects to secure.cfwebtools.com. i did that for a site i did for DOD. co. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 9:08 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Also, If you go to an SSL connection for any other site on this box: https://www.necfug.com, it automatically resolves to https://secure.cfwebtools.com/ which then redirects to that charity auction site. I guess since secure.cf... is the only site handling SSL, it serves as the default. -mk -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 8:03 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Bud, We kinda figured out why this works in spite of the MS article (or I guess as additional information to the article) . I only have one cert on this box - therefore the web server doesn't have any conflicts - it basically knows that any SSL request will be served with that one cert. mark -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 7:51 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP On 6/26/02, Mark A. Kruger - CFG penned: >Tom, > >... maybe I should. Here is an example of a secure site that is >"virtually" hosted. > >https://secure.cfwebtools.com/bgc/index.cfm > >check it out. secure.cfwebtools.com 204.77.185.157 Can you tell us of another domain using that IP Address? cfwebtools.com 204.77.185.168 www.cfwebtools.com 204.77.185.168 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pointing multiple sites to the same IP
hey, i try to be nice. :) although, you could use my method to redirect traffic to the site so your clients won't get that message. co. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 11:31 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Chris, You give me too much credit. This is my "pro-bono" box. I set it up myself and I can tell you that there's no custom 403.3 setup. The server has a single IP and about 5 virtual sites mapped to it. The only one with a CERT is "secure.cfwebtools.com". Apparently, since it's the only 443 port listening - it gets the SSL traffic by default. It does generate an initial error message regarding the CERT not matching the host info. Mark -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 10:03 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP they probably have a custom 403.3 error setup in IIS for www.necfug.com. it most likely redirects to secure.cfwebtools.com. i did that for a site i did for DOD. co. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 9:08 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Also, If you go to an SSL connection for any other site on this box: https://www.necfug.com, it automatically resolves to https://secure.cfwebtools.com/ which then redirects to that charity auction site. I guess since secure.cf... is the only site handling SSL, it serves as the default. -mk -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 8:03 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Bud, We kinda figured out why this works in spite of the MS article (or I guess as additional information to the article) . I only have one cert on this box - therefore the web server doesn't have any conflicts - it basically knows that any SSL request will be served with that one cert. mark -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 7:51 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP On 6/26/02, Mark A. Kruger - CFG penned: >Tom, > >... maybe I should. Here is an example of a secure site that is >"virtually" hosted. > >https://secure.cfwebtools.com/bgc/index.cfm > >check it out. secure.cfwebtools.com 204.77.185.157 Can you tell us of another domain using that IP Address? cfwebtools.com 204.77.185.168 www.cfwebtools.com 204.77.185.168 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mail server
are you running IIS? if so, just use the builtin SMTP server. -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 10:08 PM To: CF-Talk Subject: Mail server How would I set up a mail server on my dev box to test mail functions. Is there a small footprint, pretty simple bit of software people use etc. Currently I point to our corporate mail server but would like this to run on the dev box. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** 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. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pointing multiple sites to the same IP
they probably have a custom 403.3 error setup in IIS for www.necfug.com. it most likely redirects to secure.cfwebtools.com. i did that for a site i did for DOD. co. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 9:08 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Also, If you go to an SSL connection for any other site on this box: https://www.necfug.com, it automatically resolves to https://secure.cfwebtools.com/ which then redirects to that charity auction site. I guess since secure.cf... is the only site handling SSL, it serves as the default. -mk -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 8:03 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Bud, We kinda figured out why this works in spite of the MS article (or I guess as additional information to the article) . I only have one cert on this box - therefore the web server doesn't have any conflicts - it basically knows that any SSL request will be served with that one cert. mark -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 7:51 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP On 6/26/02, Mark A. Kruger - CFG penned: >Tom, > >... maybe I should. Here is an example of a secure site that is >"virtually" hosted. > >https://secure.cfwebtools.com/bgc/index.cfm > >check it out. secure.cfwebtools.com 204.77.185.157 Can you tell us of another domain using that IP Address? cfwebtools.com 204.77.185.168 www.cfwebtools.com 204.77.185.168 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NT Firewalls
try tinysoftware.com's tiny firewall. or, as the astute poster before me noted, get a firewall device/box. try smoothwall.org. christopher olive ATNET Solutions, Inc 410.931.4092 www.atnetsolutions.com -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 4:52 AM To: CF-Talk Subject: SOT: NT Firewalls Running public CF Servers, what firewall software do you all use on your NT boxes? -- James Smith - [EMAIL PROTECTED] http://www.xsite.ltd.uk - Xsite Limited -- As a computer, I find your faith in technology amusing. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Select SSL via code based on domain name?
no, host headers and SSL are mutually exclusive (if sharing IPs). at least with IIS. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 4:09 PM To: CF-Talk Subject: OT?: Select SSL via code based on domain name? Hello all, If I have two domain names assigned to the same IP/site, but each of these domain names have their own SSL certificate, is there any way in the code to specify what SSL cert is used based on the domain name used to get to the site? Thanks for any help. Ryan J. Pieszak Applications Engineer Ziphany, LLC. (716) 510-0379 www.ziphany.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Scary SQL non-error on multiple inserts
right. because when you lump several statements together via CFQUERY, only the
information from the last one is returned (IIRC).
try moving it to the last slot, see what happens.
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 4:08 PM
To: CF-Talk
Subject: Scary SQL non-error on multiple inserts
I came across a scary sql non-error. Thought I'd share. It can be convenient to toss
multiple insert statements into one cfquery. Consider the below code where the field
'Description' is varchar(10):
INSERT INTO Table (Code, Description) VALUES ('a', 'yo')
INSERT INTO Table (Code, Description) VALUES ('b', 'this string is too long')
INSERT INTO Table (Code, Description) VALUES ('c', 'yo')
This will not throw an error. (I am using CF 4.5/SQL Server 2K)
If you did the second statement first, it will throw a sql data truncation error. In
the above case, it will insert the first and third row, but not the second.
If you do 3 separate s, then of course, the second would throw an error.
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
you actually don't need a stored proc for this SET NOCOUNT ON; INSERT ... SELECT @@Identity as newid; SET NOCOUNT OFF; now foo.newid will be your new ID. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:14 AM To: CF-Talk Subject: RE: Query help Kris, In your Stored Proc you can use one of SQL's own variables @@identity to get the row id for the record you have just inserted. Simply assign @@identity to a local var et voilà! HTH Stephen DECLARE @id as int INSERT INTO tableFoo (Col1,Col2,Col3) VALUES (a,b,c) SELECT @@identity = @id SELECT @id -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 14:06 To: CF-Talk Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Computer Professionals / Cold Fusion Programmer
whoops. my bad. i worked for the DoD (Department of Defense :)) for 2.5 years, and the TLAs (Three Letter Acronyms) fly fast and thick. :) www.acronymfinder.com is my friend. :) christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:52 PM To: CF-Talk Subject: RE: Computer Professionals / Cold Fusion Programmer i know the questions are coming, here are the answers. IANAL: I Am Not A Lawyer IE: Id Est (Latin: That Is) IIRC: If I Recall/Remember Correctly chris, i think you do this on purpose! v/r, Jeff -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:47 PM To: CF-Talk Subject: RE: Computer Professionals / Cold Fusion Programmer IANAL, but i believe this is only for "tax exempt" employees (IE, part timers). and this NEVER sticks for us in courts, IIRC. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:31 PM To: CF-Talk Subject: Computer Professionals / Cold Fusion Programmer Does anyone know how the law works for salaried employees, regarding Computer Professionals? Is there a minimum salary? Computer Professionals - A new law provides for increased hourly minimum pay for exempt computer professionals. The minimum salary requirement for exempt computer professionals rose from $41 per hour in 2001 to $42.64 in 2002. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Computer Professionals / Cold Fusion Programmer
IANAL, but i believe this is only for "tax exempt" employees (IE, part timers). and this NEVER sticks for us in courts, IIRC. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:31 PM To: CF-Talk Subject: Computer Professionals / Cold Fusion Programmer Does anyone know how the law works for salaried employees, regarding Computer Professionals? Is there a minimum salary? Computer Professionals - A new law provides for increased hourly minimum pay for exempt computer professionals. The minimum salary requirement for exempt computer professionals rose from $41 per hour in 2001 to $42.64 in 2002. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing sql server dts package from cf
you can also create an SP that executes your DTS package, then call the SP from CF with CFQUERY. that's what we do here, since i've had mixed results instantiating a COM object as CFCOMET recommends. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:07 AM To: CF-Talk Subject: RE: executing sql server dts package from cf Steven, There are a couple of ways to do this. The first using CFObject is outlined on cfcomet.com. Antoher way is to run DTS using cfexecute as follows. HTH, Dave -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 15:12 To: CF-Talk Subject: executing sql server dts package from cf I've never done this. Where can I find information? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Wishlist
this is sort of correct. with all deference to mr forta, a more accessible example of a race condition is one that ray camden uses. if you have in a script, multiple people may be executing this simultaneously. this can be a Bad Thing(tm) sometimes. when the users hit that line, you CANNOT depend that the variable has been incremented once for any given user. some other user may have caused the increment. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 7:15 PM To: CF-Talk Subject: Re: CF Wishlist I believe race conditions are where you are setting a variable multiple times per request or session, and your code relies on the changing value to execute properly. For example if you had: To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 5:22 PM Subject: Re: CF Wishlist What is "race" conditions? Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector Commerce Builder > You need to lock to prevent race conditions. If that is why you were > locking then yes, you should. > > But you do not need to lock to prevent memory corruption. So, if that > was the only reason you were locking, then no need. > > > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 5:02 PM > To: CF-Talk > Subject: RE: CF Wishlist > > > > > > > From: "Raymond Camden" <[EMAIL PROTECTED]> > > > > > > cflock is _not_ necessary for memory issues anymore. You > > still need it > > > for logical reasons. For example: > > > > > > application.x = application.x + 1 > > > > Whoah - not been following this thread closely, but did I miss > > something? You don't need to habitually lock Session, Server and > > Application variables anymore in CFMX? > > > > Correct. But, it doesn't hurt either. I'll probably continue using it > just to be safe. > > === > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > Email: [EMAIL PROTECTED] > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTTP 500 - Internal server error
is it a form result page? check to see if the action page is an actual extant page. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:46 PM To: CF-Talk Subject: HTTP 500 - Internal server error Well... I was plugging away, working on a project- When all of a sudden I got an "HTTP 500 - Internal server error" on one particular page... It's not a CF error msg, but an IIS error msg - Any ideas what I might have done wrong? The file APPEARS to be fine, I can open it, edit it, etc. TIA! -Lou __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Pivot table WAS: SQL Question
look into pivot tables in the Books Online. that'll do it. you might also want to use an SP, they'll handle it faster. return the data set of the pivot table to CF, and you're in. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 9:49 AM To: CF-Talk Subject: SQL Question Hey folks, I have a table like this: id foreign id value 1 1 1 2 1 2 3 1 3 4 2 1 5 2 2 6 2 3 Regular old normalized table right? Well I need to get it into columns like this: foreignID value1 value2 value3 1 1 2 3 2 1 2 3 Now I know it is possible, but difficult. I would do it with CF but no matter how high I set the time out in my administrator, and my web server it times out, or says page cannot be displayed. It is pulling huge amounts of data, then outputting it it an Excel spread sheet. We tried to do it with a DTS package and the use SQL Mail to send it, but couldn't get that to work reliably. TIA. Tim Heald ACP/CCFD :) Application Development www.schoollink.net __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORACLE CLOB, single quotes double quotes turn into question marks
if MS "Smartquotes" is turned on, cutting and pasting into Oracle/SQL Server will blow up. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Carl [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 4:03 PM To: CF-Talk Subject: ORACLE CLOB, single quotes double quotes turn into question marks Anyone know why single quotes and double quotes that are cut and pasted from MS Word into a text area change into question marks when inserted into an ORACLE clob column? It seems to work fine if the user types them directly into the text area. Any work arounds are appreciated. Thanks! Carl __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Free SSL Certificate?
install MS's Certificate server. you'll get errors that "the cert is from an unrecognized vendor" from some browsers (until you update your trusted CA list), but it's free., christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 1:55 PM To: CF-Talk Subject: OT: Free SSL Certificate? Anybody know where I can get a free SSL certificate to turn on the encryption on my webserver? I just need something to turn on the encryption for some Development servers, nothing fancy. I used to use Verisign's Trial Certificate, but they haven't responded in any way for a couple days now. I tried Thawte (they want my passport number, social security number, or drivers license number) and GeoTrust. I've heard to snakeoil.com (!!) but can't find them. I'm trying to make my own Certificate using SSLeay, but I'm not making much headway. Any help out there? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: end of month function
the easy way would be to take the date, do a firstofmonth(dateadd("m", 1)) to it.
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Perez, Percy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 11:33 AM
To: CF-Talk
Subject: end of month function
Hello all,
Is there a End of month function in ColdFusion...
I am trying to get the end of month for a date.
excel has one, but I could not find one under the help files.
eg:
eomonth(1-15-2002) would return 1-31-2002
and of course, before I build one, I figure I ask first.
Thanks
Percy E Perez
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session variable question
win2k network? check the IIS logs, see what source IPs they're coming from. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:29 AM To: CF-Talk Subject: RE: Session variable question They access it via http://machinename.domain.com:portnumber port 80 is blocked internally so we run the server on a different port for people to access it via url. Ben At 11:22 AM 4/23/2002, you wrote: >how are they accessing the application? with the machine's local >(internal) name, or with www.blahblah.com (or whatever)? > >christopher olive >cto, vp of web development, vp it security >atnet solutions, inc. >410.931.4092 >http://www.atnetsolutions.com > > >-Original Message- >From: Ben Densmore [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, April 23, 2002 11:19 AM >To: CF-Talk >Subject: RE: Session variable question > > >There is no Proxy server, at the moment the IP addresses are static. I >thought maybe the machines were using the same IP Address, but they are not. > >Ben > > >At 11:14 AM 4/23/2002, you wrote: > >are they running behind a proxy sever? it's entirely possible that they > >appear to be coming from the same IP address, confusing the server. > > > >christopher olive > >cto, vp of web development, vp it security > >atnet solutions, inc. > >410.931.4092 > >http://www.atnetsolutions.com > > > > > >-Original Message- > >From: Ben Densmore [mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, April 23, 2002 10:58 AM > >To: CF-Talk > >Subject: Session variable question > > > > > >I have seen this asked in the cf forums on macromedias site but don't see a > >clear answer so hopefully someone here can give me a clue. We have an order > >entry app running internally. I have 2 people that are in our sales dept > >that keep turning into one another while logged in. An example is, salesman > >A will be logged in and have administrative rights while salesman B will be > >logged in on another machine, doesn't have admin rights, but all of a > >sudden salesman B will have access to all the Admin stuff and be logged in > >as salesman A. One other weird thing is if salesman A logs out, it kills > >the session for salesman B. All session variables have been locked when > >they are created. The only thing I can think that might be happening is > >that the cfid and cftoken for these 2 guys are the same? we have about 25 > >people using this system and only these 2 people have this problem. If > >someone could give me an idea of what's going on I would really > appreciate it. > > > >Thanks, > >Ben Densmore > > > > > > > > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session variable question
how are they accessing the application? with the machine's local (internal) name, or with www.blahblah.com (or whatever)? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:19 AM To: CF-Talk Subject: RE: Session variable question There is no Proxy server, at the moment the IP addresses are static. I thought maybe the machines were using the same IP Address, but they are not. Ben At 11:14 AM 4/23/2002, you wrote: >are they running behind a proxy sever? it's entirely possible that they >appear to be coming from the same IP address, confusing the server. > >christopher olive >cto, vp of web development, vp it security >atnet solutions, inc. >410.931.4092 >http://www.atnetsolutions.com > > >-Original Message- >From: Ben Densmore [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, April 23, 2002 10:58 AM >To: CF-Talk >Subject: Session variable question > > >I have seen this asked in the cf forums on macromedias site but don't see a >clear answer so hopefully someone here can give me a clue. We have an order >entry app running internally. I have 2 people that are in our sales dept >that keep turning into one another while logged in. An example is, salesman >A will be logged in and have administrative rights while salesman B will be >logged in on another machine, doesn't have admin rights, but all of a >sudden salesman B will have access to all the Admin stuff and be logged in >as salesman A. One other weird thing is if salesman A logs out, it kills >the session for salesman B. All session variables have been locked when >they are created. The only thing I can think that might be happening is >that the cfid and cftoken for these 2 guys are the same? we have about 25 >people using this system and only these 2 people have this problem. If >someone could give me an idea of what's going on I would really appreciate it. > >Thanks, >Ben Densmore > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session variable question
are they running behind a proxy sever? it's entirely possible that they appear to be coming from the same IP address, confusing the server. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 10:58 AM To: CF-Talk Subject: Session variable question I have seen this asked in the cf forums on macromedias site but don't see a clear answer so hopefully someone here can give me a clue. We have an order entry app running internally. I have 2 people that are in our sales dept that keep turning into one another while logged in. An example is, salesman A will be logged in and have administrative rights while salesman B will be logged in on another machine, doesn't have admin rights, but all of a sudden salesman B will have access to all the Admin stuff and be logged in as salesman A. One other weird thing is if salesman A logs out, it kills the session for salesman B. All session variables have been locked when they are created. The only thing I can think that might be happening is that the cfid and cftoken for these 2 guys are the same? we have about 25 people using this system and only these 2 people have this problem. If someone could give me an idea of what's going on I would really appreciate it. Thanks, Ben Densmore __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Optimal settings for LIMIT SIMULTANEOUS REQUESTS
when i took the server performance tuning class (with dave watts!), we were told the only way to REALLY get a good number for that is to load test your application with different setting in simultaneous requests. look at the data, and it'll reveal the "optimal" setting. that being said, we didn't cover hosting multiple sites, so load testing them ALL and taking an average might be a PITA. we didn't discuss ways to mitigate this. to be completely fair, i was running a one site only machine for the DOD, and didn't think to ask this question. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 9:41 AM To: CF-Talk Subject: Re: Optimal settings for LIMIT SIMULTANEOUS REQUESTS Bud, thanks for your response. So you've set your simultaneous requests limit to 50 and your performance is fine and you've minimized your time outs, that's interesting. Anyone have any comments on that ?? At 08:34 PM 4/23/2002, you wrote: >On 4/23/02, John Innit penned: > >Our web server is a P3 500 with 512KB RAM running WIN2K/ IIS & CF 4.5.1 > >our DB server is also a P3 500 with 512KB RAM running WIN2K and SQL > >SERVER 2000 > >I've read the rule of thumb for the limit simultaneous requests should be > >2x or 3x the number of processors on the box, as we have 1 processor on our > >web server does this mean our setting should be only 2 simultaneous > >requests??? This seems frighteningly low to me!! currently we have it set > >to 15. - am I missing something here ? > >Well, when I had mine set to the recommended settings I used to get >dozens of timeouts daily in the application.log. Every couple days >I'd go in and raise it by 5 and the number of timeouts would >decrease. When I got to 45 they went away. I then made it 50 and >never get timeouts and the performance hasn't suffered. Right now I'm >hosting about 40 CF sites on the box, with about half running Access >as the database and the other half running SQL on a separate box. >Some of the SQL sites are pretty busy getting hundreds of visitors >daily with one doing close to 2,000 visitors daily. I do get some >ConnectWrite SQL Server ODBC timeout errors, an average of about 4 a >day, which I can live with. > >My web server is running dual 533 Mz PIIIs with 1 GB RAM. The SQL >Server is a single PIII 833 Mz with 512 MB RAM. >-- > >Bud Schneehagen - Tropical Web Creations > >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >ColdFusion Solutions / eCommerce Development >[EMAIL PROTECTED] >http://www.twcreations.com/ >954.721.3452 > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quickbooks IIF File
is qbXML XML 1.0? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:30 AM To: CF-Talk Subject: RE: Quickbooks IIF File > > actually, the quickbooks timer program spits out timer files in > IIF. then QB can read them in. we've done some preliminary > testing, and it looks quite possible. > This is indeed correct. I've got the quickbooks --> my application about 90% completed, without any problem except that there are some inconsistencies with the data. Unfortunately, quality of information out of my application will only be as good as the quality of the data going into it. Also, I've seen the SDK and it doesn't look like it is complete yet. There seem to be some elements missing. QuickBooks has created a XML implementation called qbXML (or qXML), but it looks like it is still in its infancy and requires creation of com objects to work with it. Wouldn't a qbXML to WDDX function be fun? David Schmidt __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quickbooks IIF File
actually, the quickbooks timer program spits out timer files in IIF. then QB can read them in. we've done some preliminary testing, and it looks quite possible. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Eric Mathews [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 3:58 PM To: CF-Talk Subject: RE: Quickbooks IIF File We started on a project that was going to do something like this (right before funding was cut and the team was sent on permanent vacation). We only found two tools: OfficeQ by DataBlox http://www.datablox.com/ Linkbook ODBC Driver http://www.hcit.co.uk/LinkBook/ The ODBC driver was buggy at best, and we didn't have time to evaluate the DataBlox offering. The problem we found is that the makers of QuickBooks are for one reason or another keeping their DB proprietary. They've released just enough info to allow the construction of a way to export data from IIF's, but to the best of my knowledge you can't import to one. I'm in a much happier place now (that also uses Quickbooks) and would love for someone to tell me #1 I'm Wrong and #2 Here's how you do it. Cheers! -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 3:48 PM To: CF-Talk Subject: RE: Quickbooks IIF File Hehe... Me Three! Working on an export/import for timer/quickbooks :) Dave Schmidt > -----Original Message- > From: Christopher Olive [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 12:27 PM > To: CF-Talk > Subject: RE: Quickbooks IIF File > > > i'll have to "me too" that one. i'm working on that exact process today. > > christopher olive > cto, vp of web development, vp it security > atnet solutions, inc. > 410.931.4092 > http://www.atnetsolutions.com > > > -Original Message- > From: Jim Gurfein [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 2:25 PM > To: CF-Talk > Subject: Quickbooks IIF File > > > Hi Group, > > I need to create an IIF file of invoices that can be imported into > Quickbooks. Does anyone have a sample, customtag or otherwise to > speed the > process? > > Any help would be greatly appreciated. > > > Sincerely yours, > > Jim Gurfein > President, CEO > RestaurantRow.com, Inc. > http://www.restaurantrow.com > 914.921.3200 ext 101 > 914.921.9190 fax > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quickbooks IIF File
i'll have to "me too" that one. i'm working on that exact process today. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 2:25 PM To: CF-Talk Subject: Quickbooks IIF File Hi Group, I need to create an IIF file of invoices that can be imported into Quickbooks. Does anyone have a sample, customtag or otherwise to speed the process? Any help would be greatly appreciated. Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDirectory Network Drive - Help!!!!
keep in mind that drives are mapped on an account-by-account basis. so, if i'm a user on your machine, the path you have mapped to M:\ in your account is NOT accessible by me. that being said, the CF service runs as LocalSystem, by default. this account will NOT have any mapped drives (if memory serves). if you've changed that, the user under which CF runs must have the drive mapped in THAT profile. more elegant solution: use a UNC for CFFILE and CFDIRECTORY. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: S V [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:41 AM To: CF-Talk Subject: CFDirectory Network Drive - Help I am using CF 4.5 with IIS 4. Despite successfully making a mapping to a drive on another machine thru "Mapping a drive", the cold fusion server seems unable to see this server when I try to browse in the "Mapping" section of Cold Fusion Administrator. I can see this drive thru Windows explorer or Command prompt, But CF is unable to do so. This means that CFDirectory or CFFile cannot work. Is there anything that I have to do , or install or setup to get this connection to work? Any help or direction is appreiciated! Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UNION vs JOIN
ah. . While they are not the issue, it may be work reexamining how you have your tables constructed. for example, looks like you can fold the three "detail" tables into one. if we consider that this layout is a priori, and the scenario is as outlined below, then you're probably looking for SELECT template FROM department_table WHERE ID = #URL.owner# UNION SELECT template FROM product_table WHERE ID = #URL.owner# UNION SELECT template FROM content_table WHERE ID = #URL.owner# this is off the top of my head. should be fairly close, though. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:39 AM To: CF-Talk Subject: Re: UNION vs JOIN Ok, here it is: fusion_table id | owner | sub_object | type | sort | status department_table id | title | description | content | status | TEMPLATE product_table id | title | description | content | status | TEMPLATE various other columns content_table id | title | description | content | status | TEMPLATE The fusion table combines the id values from the other three tables, in the two columns OWNER and SUB_OBJECT. All owners can have multiple sub_objects and sub_objects can become owners. The type field is one of three values department, product, or content So if I have id's 1 = department 2 = department 3 = product 4 = product 5 = content and my fusion table looks like this: owner | sub_object | type 12 department 23 product 24 product 25 content Owner 1 has the sub_object 2 (sub_department) owner 2 has the sub objects 3,4 (products) and 5(content item). So if I have a link loading up ID=4 the product and want to view it's records, "go.cfm?owner=4" I want to write a query that will get the template out of the appropriate table ... I do not want to do a run this query run this query run this query I would like to run a query that will "Join or Union" the tables to get the TEMPLATE so I can tell which template to use. I would rather not duplicate the data and keep the template attached to each item. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder > can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table? > > christopher olive > cto, vp of web development, vp it security > atnet solutions, inc. > 410.931.4092 > http://www.atnetsolutions.com > > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 11:00 AM > To: CF-Talk > Subject: Re: UNION vs JOIN > > > I am combining the results of three tables that are very similar in their > setup and the fourth table holds all the relationships. > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector v2.0 - Commerce Builder > > > > they do different things, really. what are you trying to accomplish? > > > > christopher olive > > cto, vp of web development, vp it security > > atnet solutions, inc. > > 410.931.4092 > > http://www.atnetsolutions.com > > > > > > -Original Message- > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 18, 2002 10:18 AM > > To: CF-Talk > > Subject: OT: UNION vs JOIN > > > > > > Is there a significant difference in performance using a UNION on four > > tables versus a JOIN on four tables? > > > > Thanks > > > > Paul Giesenhagen > > QuillDesign > > http://www.quilldesign.com > > SiteDirector v2.0 - Commerce Builder > > > > > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UNION vs JOIN
can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:00 AM To: CF-Talk Subject: Re: UNION vs JOIN I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder > they do different things, really. what are you trying to accomplish? > > christopher olive > cto, vp of web development, vp it security > atnet solutions, inc. > 410.931.4092 > http://www.atnetsolutions.com > > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 10:18 AM > To: CF-Talk > Subject: OT: UNION vs JOIN > > > Is there a significant difference in performance using a UNION on four > tables versus a JOIN on four tables? > > Thanks > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector v2.0 - Commerce Builder > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UNION vs JOIN
they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: weird insert/update error
i remember this as well. my CEO had the same problem (he dabbles in programming). make sure IUSR_MACHINENAME has write perms to the directory in which the MDB file resides. it needs them to create the LDB file. this is, of course, if you have anonymous access enabled. if you search MS's site, they give 4 or 5 possible solutions to this problem. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 2:59 PM To: CF-Talk Subject: RE: weird insert/update error just right click on the database file you copied over. make sure the web client or what ever your server calls it has read/write privileges to the db. that's it. -paul -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 2:44 PM To: CF-Talk Subject: RE: weird insert/update error I am receiving the same error message after migrating an app from my laptop (wok, CIF, Silk) to our dev box (same). Can you tell me what permissions needed to be reset/set? All seems to be in order. (I have also checked, per earlier comment, both MAC versions and they are the same (2.6). did this help you at all?) -Craig Thomas -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:23 PM To: CF-Talk Subject: RE: weird insert/update error found the problem when i copied the files & the data base to the server, the file permissions where reset. i had to allow web users to be able to write to the database. kind of odd, never ran into this before. should be fine now. -paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:50 AM To: CF-Talk Subject: RE: weird insert/update error no. download the MDAC checker from MS (http://www.microsoft.com/mdac) and run it at the server console. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:27 AM To: CF-Talk Subject: RE: weird insert/update error ok. can i do that in cf admin? -paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:06 AM To: CF-Talk Subject: RE: weird insert/update error check the MDAC version on the production box. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:31 AM To: CF-Talk Subject: weird insert/update error ok i have this little app. runs just fine on my local host using cf 5.0 server it also runs just fine on our cf 4.51 production server winNT but when i move it to a 5.0 production server that is win2k i get the error below same files, same db, same odbc's... any ideas. thanks -paul Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:1) to (10:26). __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: inetinfo.exe taking 99% of CPU?
what do the logs say? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 9:45 AM To: CF-Talk Subject: RE: inetinfo.exe taking 99% of CPU? Nope -- ANY CF script, even without any database processing, loops, etc. David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 9:46 AM To: CF-Talk Subject: RE: inetinfo.exe taking 99% of CPU? is it any particular CF script? if so, perhaps there's an infinite loop or somesuch. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:53 PM To: CF-Talk Subject: SOT: inetinfo.exe taking 99% of CPU? Hello all, I've run into a problem with my local development machine (Win2k, IIS, CF 4.5). For some bizarre reason today whenever I try to run a CF script, the INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only way I can get it to release is to reboot. I have tried uninstalling and reinstalling IIS, but that didn't help. Has anyone else run into this problem with inetinfo before? Any ideas why this started happening, and how I can make it stop? :) TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Results where value starts with A thru G
maybe WHERE Left(, 1) BETWEEN 'A' AND 'G' ? this is SQL server, maybe access. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 5:13 PM To: CF-Talk Subject: Results where value starts with A thru G What is the best way to get all of the records where a specific column is LIKE 'A%' through 'G%' ? -chris.alvarado [application.developer] 4 Guys Interactive, Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: parsing CFML
please read MY explanation. if i was to use profanity, i'm quite capable of doing it myself. "Read the FINE bottom of the email". christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Reba [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:54 PM To: CF-Talk Subject: RE: parsing CFML NOW WAS ALL THAT NECESSARY? I APOLOGIZE FOR MY IGNORANCE BUT I MOST CERTAINLY DON'T DESERVE ANY PROFANITY! -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:43 PM To: CF-Talk Subject: RE: parsing CFML Read the *** Bottom of the email -Original Message- From: Reba [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:41 PM To: CF-Talk Subject: RE: parsing CFML I give what does RTFBOTE stand for? -Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:09 PM To: CF-Talk Subject: RE: parsing CFML RTFBOTE, Reba. unsubscribe notices at the bottom. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Reba [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:03 PM To: CF-Talk Subject: RE: parsing CFML UH OH! THERE IS A PROBLEM WITH WHAT I'M ASSUMING CAME FROM THE CFHUB SITE. I JUST TRIED TO SIGN UP AND NOW I AM GETTING ALL THESE EMAILS! -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:49 PM To: CF-Talk Subject: Re: parsing CFML You can use a tool like soXML. But is your CFML valid XML? Do you close your cfsets, for example? - Original Message - From: "James Sleeman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 9:51 PM Subject: parsing CFML > Hi all, > this is a bit of a strange request I guess. I want to parse CFML > files like they were XML files, so that I can access the structure of > the (well formed, no overlapping with html etc) cfml. For example, so > that I can do something like > > > > > I just saw a cfcase, it's value was > #parsecf[i].value# and the content of this cfcase > is #parsecf[i].contents#... > > . etc . > > > > > has anybody done anything like this ?? > > --- > James Sleeman > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT Reba.. whoops
www.acronymfinder.com christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:53 PM To: CF-Talk Subject: Re: OT Reba.. whoops I have troubles with that crap myself. The short ones are ok like HTH etc... but what the F&#~ is FGITLMDN and how would I have a clue? "Success is a journey, not a destination!!" Doug Brown - Original Message - From: "Joseph Thompson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 1:42 PM Subject: OT Reba.. whoops > lol... yes, CF-Talk is a great resource but does get rather busy. I hope > your unsubscribe goes well. > > > I really think the CF-Talk should have been a little more explicit in what > > it actually did. > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: parsing CFML
actually, read the FINE bottom of the email. i don't know reba, so i wouldn't curse at her. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:43 PM To: CF-Talk Subject: RE: parsing CFML Read the Fucking Bottom of the email -Original Message- From: Reba [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:41 PM To: CF-Talk Subject: RE: parsing CFML I give what does RTFBOTE stand for? -Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:09 PM To: CF-Talk Subject: RE: parsing CFML RTFBOTE, Reba. unsubscribe notices at the bottom. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Reba [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:03 PM To: CF-Talk Subject: RE: parsing CFML UH OH! THERE IS A PROBLEM WITH WHAT I'M ASSUMING CAME FROM THE CFHUB SITE. I JUST TRIED TO SIGN UP AND NOW I AM GETTING ALL THESE EMAILS! -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:49 PM To: CF-Talk Subject: Re: parsing CFML You can use a tool like soXML. But is your CFML valid XML? Do you close your cfsets, for example? - Original Message - From: "James Sleeman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 9:51 PM Subject: parsing CFML > Hi all, > this is a bit of a strange request I guess. I want to parse CFML > files like they were XML files, so that I can access the structure of > the (well formed, no overlapping with html etc) cfml. For example, so > that I can do something like > > > > > I just saw a cfcase, it's value was > #parsecf[i].value# and the content of this cfcase > is #parsecf[i].contents#... > > . etc . > > > > > has anybody done anything like this ?? > > --- > James Sleeman > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: parsing CFML
RTFBOTE, Reba. unsubscribe notices at the bottom. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Reba [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:03 PM To: CF-Talk Subject: RE: parsing CFML UH OH! THERE IS A PROBLEM WITH WHAT I'M ASSUMING CAME FROM THE CFHUB SITE. I JUST TRIED TO SIGN UP AND NOW I AM GETTING ALL THESE EMAILS! -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:49 PM To: CF-Talk Subject: Re: parsing CFML You can use a tool like soXML. But is your CFML valid XML? Do you close your cfsets, for example? - Original Message - From: "James Sleeman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 9:51 PM Subject: parsing CFML > Hi all, > this is a bit of a strange request I guess. I want to parse CFML > files like they were XML files, so that I can access the structure of > the (well formed, no overlapping with html etc) cfml. For example, so > that I can do something like > > > > > I just saw a cfcase, it's value was > #parsecf[i].value# and the content of this cfcase > is #parsecf[i].contents#... > > . etc . > > > > > has anybody done anything like this ?? > > --- > James Sleeman > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Newbie question on variables
attributes is the scope that is used within a custom tag. it's the variables passed during the custom tag call. so... within the custom tag, ATTRIBUTES.var1 and .var2 would be BAR and BAZ, respectively. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:52 PM To: CF-Talk Subject: Newbie question on variables I'm familiar with form.* variables, server.*, user.*, and session.*, but I notice an attributes.* variable being used in a lot of code I see on this list. What is this used for? Is it part of a structure? T __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query a Query or SQL Syntax (Not IN)
no problem, man. WHERE head IN (ass)? :) christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:14 AM To: CF-Talk Subject: RE: Query a Query or SQL Syntax (Not IN) I was out of the office on Friday, but this worked like a charm. Thanks for all your help. On the name thing, I'm just following SOP here. If you can make someone else have a potty mouth, do it (it's great fun in meetings). At least I don't need a header table or variable (maybe I can work that in later). -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 11:20 AM To: CF-Talk Subject: RE: Query a Query or SQL Syntax (Not IN) should you have a ValueList(asstaken.assname) in your last recordset? as it is, you're trying to exclude a *query variable#, not a list of names. IE: Select empl from AssList,asstaken Where empl NOT IN (#ValueList(AssTaken.assname)#) as a side note, very...interesting variable naming. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 11:01 AM To: CF-Talk Subject: Query a Query or SQL Syntax (Not IN) I've got two queries from different data sources, and I want to find records in the First, that are not in the second (a non-compliance report) Shouldn't I be able to do a NOT IN in a Query of Query? My code is as follows (Ass is short for Associate): Select AssName from Intranet.PBS.App_StraightTalk Select empl,locnum,first_name,last_name,last_hire From associate Where last_hire > '12/24/2001' Select empl from AssList,asstaken Where empl NOT IN (AssTaken) What am I doing wrong, or how should I do this? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query a Query or SQL Syntax (Not IN)
should you have a ValueList(asstaken.assname) in your last recordset? as it is, you're trying to exclude a *query variable#, not a list of names. IE: Select empl from AssList,asstaken Where empl NOT IN (#ValueList(AssTaken.assname)#) as a side note, very...interesting variable naming. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 11:01 AM To: CF-Talk Subject: Query a Query or SQL Syntax (Not IN) I've got two queries from different data sources, and I want to find records in the First, that are not in the second (a non-compliance report) Shouldn't I be able to do a NOT IN in a Query of Query? My code is as follows (Ass is short for Associate): Select AssName from Intranet.PBS.App_StraightTalk Select empl,locnum,first_name,last_name,last_hire From associate Where last_hire > '12/24/2001' Select empl from AssList,asstaken Where empl NOT IN (AssTaken) What am I doing wrong, or how should I do this? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do you change this number 70.0500 to 70.05?
try making the field "decimal" with a scale of 2. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:08 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Anyone have any idea how to change a number thats being outputted from a table as 70.0500 to 70.05 with only 2 decimal points. Is this doable thru a change in SQL 2000 or a change in the query itself? I'm doing an email merge, and the tag used won't allow formatting of anything within the body of the email, so the data has to be correctly formatted before being inserted into the email. The above number is a dollar amount owed by customers past due, so it need to be displayed in the email as $70.05 and right now shows as $70.0500 Appreciate any insights. Thanks. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: SQL Server Connection
does the database server have a publicly acessible IP address? if so, just crate the ODBC source on the ISP for the site, and point it to that IP. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 3:11 PM To: CF-Talk Subject: FW: OT: SQL Server Connection Hi all, I have a website that's accessing a sql database on the same network. Starting next week, I'd have to move my website to an ISP. My Question is how should I set up the connection to my SQL server database which will stay in-house? I can't'move the database because we also have other in-house applications connecting to the same database. What's the best way to do this? Should I create a duplicate database on the ISP server just for the website. and sync it with our main database here? any potential problems with doing this? Any advice would be appreciated. Thanks. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client Variable Database Storage
i think he's referring to the CFID and CFTOKEN storage that CF does. that requires the registry (really bad!), an ODBC source (best!), or cookies (fair to middling). christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:52 PM To: CF-Talk Subject: RE: Client Variable Database Storage If you don't expect a lot of traffic, just use session variables. I only use client variables on sites that will either have a lot of traffic, or ones that I would like to move one day to a clustered enviroment. Use session variables (with locking), it will make your life easier. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:50 PM To: CF-Talk Subject: RE: Client Variable Database Storage Matt and Tony, Thanks for the quick response. Your messages confirmed some of my assumptions. Here's what my hosting company support had to say about it: > Hi Chris, we create a DSN for each individual client who wants CV > storage. You could use either an AccessDB or an MSSQL db for this. It > is probably best to have an empty one, as the CF Administrator will > create the tables necessary. As you already have a DSN associated with > this account an additional one would incur a $5/month charge. You could > avoid this charge by using your current database for CV storage, as the > table names that are created are fairly unique. However, do this at > your own risk. Please let us know if you have any further questions. I think I will be able to work with just having them configure my already existing datasource to store client vars. It's for a fairly small site and I don't really expect lots of traffic. Thanks again. Chris Montgomery[EMAIL PROTECTED] Airtight Web Services Web Development, Web Project Management, Software Sales Macromedia Sales & Consulting Partner 210-490-3249/888-745-7603 > -Original Message- > From: Matt Robertson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 03, 2002 1:28 PM > To: CF-Talk > Subject: RE: Client Variable Database Storage > > > Chris, > > You can put your client vars in any dsn you like, so long as you specify > that dsn as a client var repository in the CF Administrator. If you've > already created your tables, just leave the ''create tables'' choice > unchecked when you do the above. > > This lets you specify multiple client var datasources, one for each > client assuming each client has its own dsn. You may or may not want to > do that. I used to but mostly don't anymore, preferring instead to > keeping those w/generic needs in a server-wide db. I have some clients > whose expirations differ from the norm, so I break them out into their > own db's. > > I'm not sure this is something you can really manage with a shared host. > You'll have to ask them directly if they can set you up. > > --Matt Robertson-- > MSB Designs, Inc. > http://mysecretbase.com > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Order by clause
ah. by a PARTICULAR letter. :) WHERE Left(fieldname, 1) = 'letterinquestion' christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 2:07 PM To: CF-Talk Subject: RE: SQL Order by clause this would not do it. wat i weant was ordering a column starting with, for example,letter E, instead of A. -Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 7:26 AM To: CF-Talk Subject: RE: SQL Order by clause ORDER BY Left(, 1) christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 7:52 PM To: CF-Talk Subject: OT: SQL Order by clause Hi all, How do I do an order by clause start with an alphabet letter. ? Is that possible ? Thanks Thanh __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Can't insertinto SQL2K ... any ideas?
you shouldn't be inserting into an IDENTITY key, really. let the DB generate the ID. what's the SQL you're using? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 30, 2002 11:07 AM To: CF-Talk Subject: CF Can't insertinto SQL2K ... any ideas? My server's using CF5 and SQL2K. I can insert into a table using the query analyser, and I can have CF query the datasource no problem. But when it goes to insert into the database, using the same SQL I used in the query analyser, it hiccups. I get a error messages as follows: [quote] ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'memberid', table 'btcmsa.dbo.Newsletter'; column does not allow nulls. INSERT fails. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (9:99). [/quote] Here's the SQL I used to set up the table: [quote] CREATE TABLE [Newsletter] ( [memberid] [int] IDENTITY (1, 1) NOT NULL , [name] [varchar] (255) NULL , [email] [varchar] (255) NULL , [emailtype] [int] NULL , [messagesentwhen] [datetime] NULL , [messagesent] [bit] NOT NULL ) ON [PRIMARY] GO [/quote] The field it's complaining about, "memberid" is a primary key. The SQL in the CFQUERY tag works fine in query analyser. I have tried it with and without username, password, dbtype in the CFQUERY tag. IS this the problem?? I'm thinking the problem is the SERVER doesn't have permissions to insert into the database - it needs to be set up as database owner and hasn't been. Which means I have to focus the SysAdmin's eye on it and that's not easy at Easter time. IS there anything else I should look for? Something I might have overlooked? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Order by clause
ORDER BY Left(, 1) christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 7:52 PM To: CF-Talk Subject: OT: SQL Order by clause Hi all, How do I do an order by clause start with an alphabet letter. ? Is that possible ? Thanks Thanh __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REPOST: Re: CDONTS and ReplyTo
i agree. asp is designed as a COM wrapper. however, i wasn't asking ease of coding. i was asking efficiency of the scripting engine in regards to instantiating/manipulating objects. i'd lean toward ASP being more effient in that regard, as well (after all, it was designed to do that). i was just asking if anyone had empirical evidence. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 12:47 PM To: CF-Talk Subject: RE: REPOST: Re: CDONTS and ReplyTo > i don't know if that's entirely correct. is ASP more > efficient at creating/manipulating objects than CF? that's > all the calls do, at the base level. In general, it's certainly easier to work with COM interfaces in ASP compared to CF, with all the clunkiness in CFOBJECT. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REPOST: Re: CDONTS and ReplyTo
i don't know if that's entirely correct. is ASP more efficient at
creating/manipulating objects than CF? that's all the calls do, at the base level.
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 12:30 PM
To: CF-Talk
Subject: REPOST: Re: CDONTS and ReplyTo
Actually, why don't you just use an ASP page to send your mail via CDONTS rather than
going thru the CF Server? It should be more efficient since CDONTS is intrinsic to
IIS. My 2 cents.
Your page would then be similar to this:
'-Send Email
dim objMail
Set objMail = Server.CreateObject("CDONTS.NewMail")
If err.number>0 then%>
Error Occured:
Error Number=<%=err.number%>
Error Descr<%=err.description%>
Help Context=<%=err.helpcontext%>
Help Path=<%=err.helppath%>
Native Error=<%=err.nativeerror%>
Source=<%=err.source%>
<%
Else
objMail.BodyFormat = 0
objMail.MailFormat = 0
objMail.From = strEmail
objMail.To = strToEmail
objMail.Subject = "Contact Form from " & strName
objMail.Body = strContents
objMail.Send
Set objMail = Nothing
End If
%>
- Original Message -
From: Dave Jones
To: CF-Talk
Sent: Thursday, March 28, 2002 11:29 AM
Subject: CDONTS and ReplyTo
Can someone tell me how to set the Reply-To header when using
CDONTS in ColdFusion? These assignments do NOT work:
Thanks,
Dave Jones
NetEffect
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS 5 WWW-Server and writing of logfiles
you're correct, of course. my apologies. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 3:07 PM To: CF-Talk Subject: RE: IIS 5 WWW-Server and writing of logfiles > well, you can change the location of the logs when creating > the virtual domains. point them at the same file. of > course, you may run into some SERIOUS concurrency issues with > two ISAPI processes writing to the file at the same time. as > far as i've seen (YMMV, of course), the process holds the > file open until it hits the rotation point. i can't predict > that good things will happen when you ask two procs to have > the same file open. In the IIS management console, I don't think it's possible to point two virtual servers to the same file. You can simply point them to a directory, and they'll then create a subdirectory within that directory based on the internal virtual service name (W3SVCx). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS 5 WWW-Server and writing of logfiles
well, you can change the location of the logs when creating the virtual domains. point them at the same file. of course, you may run into some SERIOUS concurrency issues with two ISAPI processes writing to the file at the same time. as far as i've seen (YMMV, of course), the process holds the file open until it hits the rotation point. i can't predict that good things will happen when you ask two procs to have the same file open. what are you hoping to accomplish, though? perhaps there's another way around this. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:42 PM To: CF-Talk Subject: RE: IIS 5 WWW-Server and writing of logfiles Nope - I think not. No matter where you point your log file directory, IIS will create a subdirectory indexed to the order your domains have been created in (w3svc1-2-3 etc.). I doubt you are going to be able to change this - you could try hacking up the registry I suppose . -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:37 PM To: CF-Talk Subject: OT: IIS 5 WWW-Server and writing of logfiles Hi list, is there a way to write under MS-IIS 5 (Win2000) with two virtual domains (One IP, via host-deader) in one (the same) log-file ? I haven't figured out, how to do it, since IIS is installing a new logfile when installing a new virtual domain. Thanks for your ideas. Uwe __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
yes. i actually posted this a few weeks ago. search the archives. if you can't find it, i'll dig out the code again. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:10 PM To: CF-Talk Subject: SQL Question Besides using xp_cmdshell does any know how to execute a dts package from a stored procedure? Joshua Tipton __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time Issue
from the docs: "NOW: Returns the current date and time of the computer running the ColdFusion server" christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 4:58 PM To: CF-Talk Subject: Re: Time Issue I know that Now() uses GMT. If this is the case, do you know how to avoid this. - Original Message - From: "Marlon Moyer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 2:50 PM Subject: Re: Time Issue > Is it GMT time by chance? > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, March 25, 2002 3:45 PM > Subject: Time Issue > > > > I am using cfmail to send some emails - when I receive the email it says > it > > was sent at 1:30 this morning instead of the appropriate time this > afternoon > > (that I sent it). The system time is correct. Any ideas? > > > > Thanks > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
