OOT: Getting Charset ??
Hi, how can I get a charset of a language if in the IE options of Encoding is Cyrillic(Windows) from a foreign website??? If I viewsource, it can't be written to notepad, replace by words For ex. the site is : http://www.interfax.ru . Ex. charset=ISO-8859-1 ??? TIA, Fisichella. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Getting Charset ??
> Hi, how can I get a charset of a language if in the IE options of what are you asking? how to find the locale a browser is using? examine/parse cgi.http_accept_language or what charset is used for cyrllic? iso-8859-5 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Getting Charset ??
I need that ISO-8859-5. Yup, that's it, how you get this number ??? - Original Message - From: "Paul Hastings" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 5:11 PM Subject: Re: Getting Charset ?? > > Hi, how can I get a charset of a language if in the IE options of > > what are you asking? how to find the locale a browser is using? > examine/parse cgi.http_accept_language > > or what charset is used for cyrllic? iso-8859-5 > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Getting Charset ??
Sorry, but when I set this ISO-8859-5 into mydatabase, the pages doesn't show like the web, it asking me to install Cyrillic, not Cyrillic-window, as I see on my IE encoding when I browse the http://www.interfax.ru Any idea ??? - Original Message - From: "Paul Hastings" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 5:11 PM Subject: Re: Getting Charset ?? > > Hi, how can I get a charset of a language if in the IE options of > > what are you asking? how to find the locale a browser is using? > examine/parse cgi.http_accept_language > > or what charset is used for cyrllic? iso-8859-5 > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slight OT: SQl problem
Hi,
I am trying to run a query that checks through a list of postcodes, this list comes in
a comma separated list (eg N12, N13, N15 (these are english postcodes)). The problem
is that I want to use a LIKE in my AND clause that checks the postcode. So my query
looks like this:
select PropertyID
PropertyAddress,
Town
fromProperties
where Town = '#attributes.Town#'
AND Postcode IN ('#replace(attributes.PostCode,",","','",'All')#')
But this leads to some properties being missed out, so I would ideally like to use
LIKE in my AND clause so it reads:
AND Postcode LIKE '#attributes.Postcode#%'
The problem here is how do I deal with the comma separated list of Postcodes.
Any ideas anyone ?
Stephen
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slight OT: SQl problem
Stephen,
instead of using '#replace(attributes.PostCode,",","','",'All')#')
try using:
ListQualify(list, qualifier [, delimiters ] [, elements ])
as
AND postcode IN (#listqualify(attributes.postcode, "'")#)
This will create:
AND postcode IN ('BH2','NN1','MK10' etc etc etc)
---
Rich Wild
Senior Web Developer
---
e-mango Tel: 01202 755 300
Gild House Fax: 01202 755 301
74 Norwich Avenue West
Bournemouth Mailto:[EMAIL PROTECTED]
BH2 6AW, UK http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---
> -Original Message-
> From: Stephen Adams [mailto:[EMAIL PROTECTED]]
> Sent: 05 March 2002 11:06
> To: CF-Talk
> Subject: Slight OT: SQl problem
>
>
> Hi,
>
> I am trying to run a query that checks through a list of
> postcodes, this list comes in a comma separated list (eg N12,
> N13, N15 (these are english postcodes)). The problem is that
> I want to use a LIKE in my AND clause that checks the
> postcode. So my query looks like this:
>
> selectPropertyID
> PropertyAddress,
> Town
> from Properties
> where Town = '#attributes.Town#'
> AND Postcode IN ('#replace(attributes.PostCode,",","','",'All')#')
>
> But this leads to some properties being missed out, so I
> would ideally like to use LIKE in my AND clause so it reads:
>
> AND Postcode LIKE '#attributes.Postcode#%'
>
> The problem here is how do I deal with the comma separated
> list of Postcodes.
>
> Any ideas anyone ?
>
> Stephen
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What happened to the tag gallery????
I have spent the last 30 minutes looking around the Macromedia site and they've either pulled the tag gallery down or hidden it because they don't want us to find it any more .. they'd rather us read wanky articles about things we might possibly need to know if we ever come across the exact same thing as the person who wrote the article. Note that the tip of the day isn't indexed in any way . you have to just look at the days tip and hope it has something to do with what you might need. And in the mean time there's no sign of the tag gallery, when I do need to get a tag I saw there a year ago. Anyone know where it is? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What happened to the tag gallery????
its hard to find but here it is... http://devex.macromedia.com/developer/gallery/index.cfm -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 11:18 To: CF-Talk Subject: What happened to the tag gallery I have spent the last 30 minutes looking around the Macromedia site and they've either pulled the tag gallery down or hidden it because they don't want us to find it any more .. they'd rather us read wanky articles about things we might possibly need to know if we ever come across the exact same thing as the person who wrote the article. Note that the tip of the day isn't indexed in any way . you have to just look at the days tip and hope it has something to do with what you might need. And in the mean time there's no sign of the tag gallery, when I do need to get a tag I saw there a year ago. Anyone know where it is? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What happened to the tag gallery????
Mike, > I have spent the last 30 minutes looking around the Macromedia site and > they've either pulled the tag gallery down or hidden it because they don't > want us to find it any more .. they'd rather us read wanky articles about > things we might possibly need to know if we ever come across the exact same > thing as the person who wrote the article. Note that the tip of the day > isn't indexed in any way . you have to just look at the days tip and hope > it has something to do with what you might need. > > And in the mean time there's no sign of the tag gallery, when I do need to > get a tag I saw there a year ago. > Homepage --> Designer & Developer Short Cut --> Macromedia Exchange dropdown --> ColdFusion Takes you to http://www.macromedia.com/go/home_desdev_ex_cf All without leaving the home page ;o) Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What happened to the tag gallery????
Mike Kear wrote: >I have spent the last 30 minutes looking around the Macromedia site and >they've either pulled the tag gallery down or hidden it because they don't >want us to find it any more .. they'd rather us read wanky articles about >things we might possibly need to know if we ever come across the exact same >thing as the person who wrote the article. Note that the tip of the day >isn't indexed in any way . you have to just look at the days tip and hope >it has something to do with what you might need. > >And in the mean time there's no sign of the tag gallery, when I do need to >get a tag I saw there a year ago. > > >Anyone know where it is? > http://devex.macromedia.com/developer/gallery/SearchResults.cfm?keywords=sql and it's ft..nice to see they fixed it verity k2 or they repaired the verity collection? z __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What happened to the tag gallery????
Ah there's the problem .. I have got used to ignoring all flash movies and jumping over them if I can, just like I ignore all banner ads. Looks like I'm going to have to start looking at some of them. Thanks Stephen.But of course it's down. Murphy's law strikes again. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Mike, > I have spent the last 30 minutes looking around the Macromedia site and > they've either pulled the tag gallery down or hidden it because they don't > want us to find it any more .. they'd rather us read wanky articles about > things we might possibly need to know if we ever come across the exact same > thing as the person who wrote the article. Note that the tip of the day > isn't indexed in any way . you have to just look at the days tip and hope > it has something to do with what you might need. > > And in the mean time there's no sign of the tag gallery, when I do need to > get a tag I saw there a year ago. > Homepage --> Designer & Developer Short Cut --> Macromedia Exchange dropdown --> ColdFusion Takes you to http://www.macromedia.com/go/home_desdev_ex_cf All without leaving the home page ;o) Regards Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Getting Charset ??
> I need that ISO-8859-5. Yup, that's it, how you get this number ??? i read a lot, for starters: http://www.unicode.org/ http://www.microsoft.com/globaldev/ http://www.i18ngurus.com/ ben forta's cf5 advanced book __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Getting Charset ??
> Sorry, but when I set this ISO-8859-5 into mydatabase, the pages doesn't > show like the web, it asking me to install Cyrillic, not Cyrillic-window, as > I see on my IE encoding when I browse the http://www.interfax.ru ISO-8859-5 should be the same as windows-1251. what db? does the db box have cyrillic locale loaded? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Certification for 5.0 rolling over to next version?
welcome to the world of professional certification :) :P "Dave Carabetta" <[EMAIL PROTECTED]> on 03/04/2002 06:04:07 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: Re: CF Certification for 5.0 rolling over to next version? I remember way back when they upgraded my CF 4.5 cert to 5.0 withou t making me take the test, they said in the generic letter that Neo (now called ColdFusion MX) would require actually re-taking an upated cert test. If you think about it, it makes sense considering all the new features in CF MX. ;) Regards, Dave. - Original Message - From: "Garza, Jeff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 06:16 PM Subject: CF Certification for 5.0 rolling over to next version? > I'm thinking of taking the plunge and getting certified, but I'm curi ous if > the certification for CF5.0 will carry over to the next version. Or will a > completely separate test be needed. I'd hate to waste the money no w and > have to re-certify with the next version Anyone from Macr omedia want to > chime in on this? > > Jeff Garza > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Application Models
Can someone lend a guiding light here? what are the differences and or similarities between Fusebox, .Net, and JSP Struts? Can a parallel comparison be made or are they all too different? Thanks- Savan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Hal Helms to speak at Orlando CFUG @ 7pm
Hal Helms, one of the driving forces behind the fusebox methodology (www.fusebox.org) is speaking tonight at our user group meeting. Meeting is today at 7 at our Lake Mary location. Check out our homepage www.cforlando.com for directions. Robert Everland III Dixon Ticonderoga __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Server Stats/Analayze Program
I'm currently evaluating DeepMetrix's livestats6 vs. WebTrends pacakge. Can anyone recommend or share his experience? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server Stats/Analayze Program
Jason, I have Livestats 6.0 installed. Had WebTrend's installed years ago. Livestats 6.0 is very comprehensive. On my machine it took DAYS to read a year's worth of server log files and then I had some questions about the accuracy of the Who's On stats which seemed incorrect. Afterwards it stopped working because my machine's hole out of the firewall was plugged and Livestats needed access to thier server for license verification of some sort. Tech support was helpful, but compared to thier previous version, Livestats 5.0, version 6.0 was a bear for me. Hope this helps (HTH) Robert Orlini webteam HW Wilson -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 8:55 AM To: CF-Talk Subject: OT: Server Stats/Analayze Program I'm currently evaluating DeepMetrix's livestats6 vs. WebTrends pacakge. Can anyone recommend or share his experience? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Large Query return
I have the need to display a query that is returning 43000 plus rows. The query itself is in a storedproc and completing within 30ms. But the output either through cfgrid or table is very slow. Any suggestions on how to speed this up. I know its a huge query and wish i could change it. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Large Query return
Make a previous/next interface! -Original Message- From: David Brown [mailto:[EMAIL PROTECTED]] Sent: dinsdag 5 maart 2002 15:16 To: CF-Talk Subject: Large Query return I have the need to display a query that is returning 43000 plus rows. The query itself is in a storedproc and completing within 30ms. But the output either through cfgrid or table is very slow. Any suggestions on how to speed this up. I know its a huge query and wish i could change it. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Large Query return
I don't believe you will be able to speed this up without changing the query/storedproc. Other than that, I would make sure that there are no nested html tables (can slow browser interpretation), and I might conside r a hardware solution (ram, cpu, etc...). I can't think of any other way to speed that up. :( Dave -Original Message- From: David Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:16 AM To: CF-Talk Subject: Large Query return I have the need to display a query that is returning 43000 plus rows. Th e query itself is in a storedproc and completing within 30ms. But the outp ut either through cfgrid or table is very slow. Any suggestions on how to speed this up. I know its a huge query and wish i could change it. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
The cf process
Ok I've been using cf for awhile and have been asked about the process- how it sends info to/from db, etc. I explained it and to illustrate showed diagrams from Forta's and Wrox's books on How ColdFusion Works- (client request--webserver passes to cf--cf processes all cfml tags--cf returns html to web server). That wasn't good enough- they want to know the exact process, all the files that are used- what permissions are needed on files/directories of each server (web/cf/sql), etc as the pages are being processed, any and all services used, any temporary files made. So I'm now trying to explain exactly how a login works however, I haven't been able to give the detail that's requested- I guess I just know the generic part that cfquery passes to sql by way of datasource- etc but don't know if it leaves any temp files,etc. (And I haven't been able to find it) Thanks in advance, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The cf process
Wow! It sounds like you are in need of some collaboration. Is this for a customer, or is it for some internal managers? Do you have a network adm in and a database administrator that can help you give this presentation? I f you do, I strongly suggest spreading this requirement around the office : ) Not many CF developers would even have the time to tackle all this themselves, not to mention the detail skills (no offense to those that can/do). -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:50 AM To: CF-Talk Subject: The cf process Ok I've been using cf for awhile and have been asked about the process- h ow it sends info to/from db, etc. I explained it and to illustrate showed diagrams from Forta's and Wrox's books on How ColdFusion Works- (client request--webserver passes to cf--cf processes all cfml tags--cf returns h tml to web server). That wasn't good enough- they want to know the exact process, all the fil es that are used- what permissions are needed on files/directories of each server (web/cf/sql), etc as the pages are being processed, any and all services used, any temporary files made. So I'm now trying to explain exactly how a login works however, I haven't been able to give the detai l that's requested- I guess I just know the generic part that cfquery passe s to sql by way of datasource- etc but don't know if it leaves any temp files,etc. (And I haven't been able to find it) Thanks in advance, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT percentage of Broadband v.s. Dial up
CNET radio just stated that 51% are currently on broadband. They did not mention (or I did not hear) the source for that figure. > -Original Message- > From: Chad Gray [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 6:10 PM > To: CF-Talk > Subject: OT percentage of Broadband v.s. Dial up > > > Anyone have a link to statistics showing percentage of users with > broadband > v.s. dial up? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The cf process
> Ok I've been using cf for awhile and have been asked > about the process- how it sends info to/from db, etc. > I explained it and to illustrate showed diagrams from > Forta's and Wrox's books on How ColdFusion Works- (client > request--webserver passes to cf--cf processes all cfml > tags--cf returns html to web server). That wasn't good > enough- they want to know the exact process, all the > files that are used- what permissions are needed on > files/directories of each server (web/cf/sql), etc as > the pages are being processed, any and all services used, > any temporary files made. So I'm now trying to explain > exactly how a login works however, I haven't been able to > give the detail that's requested- I guess I just know > the generic part that cfquery passes to sql by way of > datasource- etc but don't know if it leaves any temp > files,etc. (And I haven't been able to find it) To the best of my knowledge, CF doesn't create any temporary files except when accepting uploaded files. As for permissions, those may vary depending on the operating system and web server used, and the way CF integrates with that web server. You might find this permissions discussion, which covers NT, IIS 4, and CF 4.x, useful: http://www.defusion.com/articles/index.cfm?ArticleID=89 In general, the web server (or in the case of IIS, which does impersonation, the IIS anonymous user account or a specific impersonated user account - a logged-in user) will need read/execute rights on CF scripts (.cfm, .dbm), and the CF server, which by default on Windows runs as SYSTEM, will need execute rights on those same scripts. On Windows, with IIS, you can actually tighten this a bit - users only need execute rights, and CF only needs read rights. The CF server account will need read/execute permissions on the appropriate binaries in the \CFUSION directory, and read/write permissions on the appropriate registry keys. The CF server will need execute permissions on database client binaries. The only services involved here are the web server and the CF Application Server. SQL databases, such as SQL Server and Oracle, have their own methods for handling permissions. Typically, you'd need to create a user within the database, assign that user the appropriate rights, and use the username and password for that user within your CF datasource or application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Application Models
> Can someone lend a guiding light here? what are the > differences and or similarities between Fusebox, .Net, > and JSP Struts? Can a parallel comparison be made or > are they all too different? Well, .NET isn't an application model, in the sense that Jakarta Struts is. You can write all of your code as ASP.NET, for example, without separating or organizing it within separate tiers. Microsoft wouldn't recommend that, I'm sure, though. Struts is just a particular implementation of the Model-View-Controller application framework concept, in which JSP is used for the "client" or "View" tier (HTML generation), EJBs are used to provide the "Model" tier (which provides a useful abstraction of data - the "View" developer wouldn't have to know anything about the actual structure of back-end data within an SQL database, for example), and the Struts package itself acts as the "Controller" - JSP programmers can invoke data requests and other data-tier logic through Struts itself. Note that Model-View-Controller is a generic idea, while Struts is a specific implementation, and you actually use a JAR file containing the Struts code. I'll refrain from commenting on Fusebox, beyond saying that I don't think it's directly comparable to either of the other two, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Server Stats/Analayze Program
As far as I'm concerned DeepMetrix needs to go back to the drawing board with LiveStats. I've got LiveStats 6 installed using MySQL on a dual processor 1.26 MHz PIII with 2 MB ram. I've done what I can to tune MySQL, throwing almost a GB of ram at it and it still constantly pegs both processors at 100% for 70-80% of the time. The databases that LiveStats creates are enormous, with indexes typically twice the size of the actual data. I found out that DeepMetrix has such a poor handle on the organization of the tables that it's virtually impossible to delete old data from the stats history. That is, if at the end of 2002, you wanted to delete stats from prior to the year 2002, you can't do it. You would have to literally delete the site and then reimport 2002's logs. Otherwise, the tables grow indefinitely. Oh, and when you delete a virtual site from LiveStats, it doesn't even drop the site's tables. I don't think these guys have a very good handle on db design. I suspect this is why MySQL is struggling to keep up with the stats for just 100 sites. LiveStats 5 was _much_ less resource intensive, but we had problems with databases constantly getting corrupted. Check out Urchin @ http://www.urchin.com.; I've heard nothing but good things about it. For a service provider, it may get pricey, though. Jim - Original Message - From: "Jason Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 6:54 AM Subject: OT: Server Stats/Analayze Program > I'm currently evaluating DeepMetrix's livestats6 vs. WebTrends pacakge. > Can anyone recommend or share his experience? > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOCK throwontimeout="no
> If you've got a cflock with throwontimeout="no", does it > skip over the block of code within the cflock, or does it > enter it if the timeout expires? It won't execute the code within the block if the timeout expires, no matter what you've set THROWONTIMEOUT to. Note that the TIMEOUT attribute specifies how long this instance of CFLOCK will wait to gain access, not how long it can take to run itself. If you set THROWONTIMEOUT to "no", it'll fail silently rather than throwing a catchable exception, I think, in the event that the CFLOCK runs out of time. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: OT percentage of Broadband v.s. Dial up
After you posted this I was kind of interested myself... I think it really depends on who you ask but this one seemed non-biased: http://cyberatlas.internet.com/markets/broadband/article/0,,10099_982021,00.html There is a nice chart at the bottom showing growth rates. Dialup was still the leader at %80 but w/little growth - whereas the cable/dsl markets were taking off. jim >> Anyone have a link to statistics showing percentage of users with >> broadband >> v.s. dial up? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The cf process
Dave Watts wrote: > > To the best of my knowledge, CF doesn't create any temporary files except > when accepting uploaded files. Access ODBC driver sometimes creates them. Either in the \winnt\ or the \winnt\system32\ dir. Jochem __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Threads
Question, the limit simultaneous request setting, does that set it so cf allocates one thread for every process? So it does not create child threads from the parent thread for another process - like in unix,java? Just trying to get a grasp on exactly how CF handles threads. Any advice is appreciated. TIA, Deb _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.; __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do you prevent web pages/images from being SAVED
> Does anyone know how to prevent: > > 1. Preventing a web page from being saved when being viewed > in a browser and > 2. Preventing the images on the page from being saved > > Is there some technique or maybe a program that enables this? The short answer is that, if you allow people to download your HTML and images onto their own computers, no, you can't prevent anything. That's the nature of the web. There are various techniques for making this more difficult, but there are always ways to circumvent those techniques - and those ways usually aren't too difficult. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Threads
> Question, the limit simultaneous request setting, does that > set it so cf allocates one thread for every process? So it > does not create child threads from the parent thread for > another process - like in unix,java? Just trying to get a > grasp on exactly how CF handles threads. Any advice is > appreciated. First, let me qualify this by saying I'm not exactly sure how threading is handled by CF on Unix platforms. On Windows, CF creates as many "worker" threads as you specify in the CF Administrator within the setting you mentioned. CF has one thread which acts as a dispatcher to those worker threads. If CF receives more requests than it has threads that aren't busy, those requests are queued. On Windows, at least, this model is supposed to be more efficient than creating threads at runtime as they may be needed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Convert Dynamic web to static
Hello all Is there a program out that can take a dynamice web site (i.e coldfusion w/querys) and convert it to a static web pages (just HTML/java) so that it can then be ported and run some were with out coldfusion for a demo type prentation. THanks for any info __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Dynamic web to static
Do a CFDIRECTORY and list all the files. Then loop through each using CFHTTP and write the results for each to a file. Just a thought... Rick Eidson -Original Message- From: Bruce, Rodney (SIGNAL) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 9:51 AM To: CF-Talk Subject: Convert Dynamic web to static Hello all Is there a program out that can take a dynamice web site (i.e coldfusion w/querys) and convert it to a static web pages (just HTML/java) so that it can then be ported and run some were with out coldfusion for a demo type prentation. THanks for any info __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Dynamic web to static
There are some web spider programs you can us to spider a site and save it to your hard drive. Shawn Regan Applications Developer pacifictechnologysolutions -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 7:44 AM To: CF-Talk Subject: RE: Convert Dynamic web to static Do a CFDIRECTORY and list all the files. Then loop through each using CFHTTP and write the results for each to a file. Just a thought... Rick Eidson -Original Message- From: Bruce, Rodney (SIGNAL) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 9:51 AM To: CF-Talk Subject: Convert Dynamic web to static Hello all Is there a program out that can take a dynamice web site (i.e coldfusion w/querys) and convert it to a static web pages (just HTML/java) so that it can then be ported and run some were with out coldfusion for a demo type prentation. THanks for any info __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Dynamic web to static
> Is there a program out that can take a dynamice web site > (i.e coldfusion w/querys) and convert it to a static web > pages (just HTML/java) so that it can then be ported and > run some were with out coldfusion for a demo type > prentation. Two of my favorites for this (both free) are wget and httrack (both easily found via google). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The cf process
> > To the best of my knowledge, CF doesn't create any > > temporary files except when accepting uploaded files. > > Access ODBC driver sometimes creates them. Either in the > \winnt\ or the \winnt\system32\ dir. That figures. Just another reason to dislike Access. Sheesh. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Convert Dynamic web to static
Use CFHTTP to read the page output then use CFFILE to save it as an HTML file. Dave - Original Message - From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 10:51 AM Subject: Convert Dynamic web to static Hello all Is there a program out that can take a dynamice web site (i.e coldfusion w/querys) and convert it to a static web pages (just HTML/java) so that it can then be ported and run some were with out coldfusion for a demo type prentation. THanks for any info __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Large Query return
Don't use tables. Use and to create something l ike a table. The problem with tables is that the browser's gotta wait unti l the whole table is delivered before the page is rendered. With and s, the browser will immediately display the contents. In conjunction with the tag, it should appear to output much faster. > -Original Message- > From: David Brown [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 6:16 AM > To: CF-Talk > Subject: Large Query return > > > I have the need to display a query that is returning 43000 plus > rows. Th > e > query itself is in a storedproc and completing within 30ms. But > the outp > ut > either through cfgrid or table is very slow. Any suggestions on > how to > speed this up. > > I know its a huge query and wish i could change it. > > ___ _ __ > Get Your Own Dedicated Windows 2000 Server > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > Instant Activation · $99/Month · Free Setup > http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: WebTV Test Browser
I used to know where to get the WebTV simulator which we now need due to an increasing (!) number of users on a site of ours...but I don't anymore. Anyone?? Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Dynamic web to static
Black Widow sorta does it: http://www.zdnet.com/downloads/stories/info/0,10615,27616,00.html Thanks, Jason -Original Message- From: Bruce, Rodney (SIGNAL) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 8:51 AM To: CF-Talk Subject: Convert Dynamic web to static Hello all Is there a program out that can take a dynamice web site (i.e coldfusion w/querys) and convert it to a static web pages (just HTML/java) so that it can then be ported and run some were with out coldfusion for a demo type prentation. THanks for any info __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Dynamic web to static
Thanks for the replies, will check into the ones dave mentioned and play around with the other options as well. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 9:10 AM To: CF-Talk Subject: Re: Convert Dynamic web to static Use CFHTTP to read the page output then use CFFILE to save it as an HTML file. Dave - Original Message - From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 10:51 AM Subject: Convert Dynamic web to static Hello all Is there a program out that can take a dynamice web site (i.e coldfusion w/querys) and convert it to a static web pages (just HTML/java) so that it can then be ported and run some were with out coldfusion for a demo type prentation. THanks for any info __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
whats wrong with DateFormat()
Ok I put DateFormat(day(now()), 'dd') on a page and instead of returning 05 it gave me 04. If I put day(now()) on a page I get 5. If I put day(5) on a page I get 4. If I put DateFormat(now(), 'mmdd') on a page I get 20020305 Why? TAI Phillip Broussard Tracker Marine Group 417-873-5957 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do you prevent web pages/images from being SAVED
If this is a controlled environment (like an Intranet), you might be able to create an Active X control (or VB app) to view the code and graphics with. This would allow you to do things like disable everything but the left mouse button (including keyboard). I'm sure it would be fairly easy to do in VB. Also, you could PDF the document (with security). No matter what type of security you use, someone, somewhere will be able to crack it. You just need to make sure that someone is outside of your target user group. Paul Sizemore Finish Line 3308 N Mitthoeffer Rd Indianapolis, IN 46235 W: 317-899-1022 ext 3516 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 10:53 AM To: CF-Talk Subject: RE: How do you prevent web pages/images from being SAVED > Does anyone know how to prevent: > > 1. Preventing a web page from being saved when being viewed > in a browser and > 2. Preventing the images on the page from being saved > > Is there some technique or maybe a program that enables this? The short answer is that, if you allow people to download your HTML and images onto their own computers, no, you can't prevent anything. That's the nature of the web. There are various techniques for making this more difficult, but there are always ways to circumvent those techniques - and those ways usually aren't too difficult. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: site performance questions
I agree with Matt. We have an intensive room booking applicaton which bui
lds
a grid with time slots open and reserved. It need to loop thru every X,Y
co-ordinate to check the status.
We shaved 9 secs by using the Compare functions.
- Original Message -
From: "Matt Robertson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 5:24 PM
Subject: Re: site performance questions
> If you have to choose between more than a couple of items use CFSWITCH,
whi
> ch is a pretty straightforward case evaluation tool that speeds up
processi
> ng quite a bit over blocks of CFIF/CFELSE/CFELSEIF statements.
>
> If you use CFIFs, Look into using Compare() and CompareNoCase() in test
s
fo
> r equivalency. They're much faster, but a bit harder to grasp than the
sta
> ndard ''cfif this eq that'' syntax.
>
> CFSET variables.blah="Y"
> CFIF NOT CompareNoCase(variables.blah,"Y")
>...variables.blah is ''Y''...
> CFELSE
>...variables.blah is not ''Y''
> /CFIF
>
> http://www.fusionauthority.com/alert/index.cfm?alertid=5#Tech2
>
> ---
> Matt Robertson[EMAIL PROTECTED]
> MSB Designs, Inc., www.mysecretbase.com
> ---
>
>
> -- Original Message --
> from: Tony Schreiber <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> date: Mon, 4 Mar 2002 17:16:24 -0500 (EST)
>
> I'm not sure, but talk around this list has said that iif() is SLOWER t
han
> cfif...
>
> > Not alot of performance issues, but you could consider using iif()
> > instead of a bunch of
> >
> >
> >
> >
> > Doug Brown
> > - Original Message -
> > From: "Gilbert Midonnet" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, March 04, 2002 1:41 PM
> > Subject: site performance questions
> >
> >
> > > I'm redesigning a site and I have questions regarding how the use o
f
> > > and affects performance.
> > >
> > > 1. I have a drop-down navigation in a top frame. I would like to pu
t
> > the
> > > graphics in the nav to change according to the section the user is
in
> > and am
> > > wondering about how my alternatives affect load time.
> > >
> > > a. For each navigation element use an if-else. If user is in
> > > directory A show {graphicA_on} else {graphicA_off}. If user is in
> > directory
> > > B show {graphicB_on} else (graphicB_off}.
> > > b. Use
> > >
> > > 2. Each page has a hardcoded left-side navigation with each page
> > having the
> > > corresponding link highlighted. Of course this leads to maintenance
> > > problems. I would like to use
> > >
> > > if this.document.url = url then X else Y in an include file or
> > > cfapplication file.
> > >
> > >
> > > The coding is simple. I'm concerned about performance. How does mu
ch
> > does
> > > this if-elses and includes slow things down? On average there are
> > 20,000
> > > page hits/day.
> > >
> > > TIA
> > >
> > >
> > > Gilbert Midonnet
> > > BrokerTec USA, LLC
> > > (201) 209-7843
> > >
> > >
> > >
> > >
> > >
>
> ---
--
>
> > ---
> > > ---
> > > This message is for the named person's use only. It may contain
> > > confidential, proprietary or legally privileged information. No
> > > confidentiality or privilege is waived or lost by any mistransmissi
on.
> > If
> > > you receive this message in error, please immediately delete it and
> > all
> > > copies of it from your system, destroy any hard copies of it and
> > notify the
> > > sender. You must not, directly or indirectly, use, disclose,
> > distribute,
> > > print, or copy any part of this message if you are not the intended
> > > recipient.
> > >
> > >
> > >
> > >
> >
>
>
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: whats wrong with DateFormat()
Just to confirm this, I get 04 also... -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 8:16 AM To: CF-Talk Subject: whats wrong with DateFormat() Ok I put DateFormat(day(now()), 'dd') on a page and instead of returning 05 it gave me 04. If I put day(now()) on a page I get 5. If I put day(5) on a page I get 4. If I put DateFormat(now(), 'mmdd') on a page I get 20020305 Why? TAI Phillip Broussard Tracker Marine Group 417-873-5957 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF linux hosting?
Matt, If it is just a development site - I would be more than happy to give you access to one of our development servers for code testing and debugging. Feel free to get back to me via email offlist if this helps you out! ./Nick Nick Richards Customer Service and Support Group Flare Network Operations Center Flare Networks Inc. http://www.flarenetworks.com [EMAIL PROTECTED] On Mon, 4 Mar 2002, Matt Robertson wrote: > Does anyone know of a commercial host that offers CF (4.5x, preferably) > on Linux and allows CFFILE? I need to set up a temp acct for a month or > so to test some code in a linux environment. I want the CFFILE to test > path settings and limited file/image uploading. Nothing live, just me > checking to make sure what should work really does. > > --Matt Robertson-- > MSB Designs, Inc. > http://mysecretbase.com > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: whats wrong with DateFormat()
try this - take the one thats appropriate #DateFormat(now())# #DateFormat(now(), "mmm-dd-")# #DateFormat(now(), " d, ")# #DateFormat(now(), "mm/dd/")# #DateFormat(now(), "d-mmm-")# #DateFormat(now(), "ddd, dd, ")# #DateFormat(now(), "d/m/yy")# Paul Melanophy Web Applications Developer 133 - 137 Lisburn Road Belfast N. Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W http://www.biznet-solutions.com -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 16:16 To: CF-Talk Subject: whats wrong with DateFormat() Ok I put DateFormat(day(now()), 'dd') on a page and instead of returning 05 it gave me 04. If I put day(now()) on a page I get 5. If I put day(5) on a page I get 4. If I put DateFormat(now(), 'mmdd') on a page I get 20020305 Why? TAI Phillip Broussard Tracker Marine Group 417-873-5957 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT percentage of Broadband v.s. Dial up
51% of users listing to CNET radio, maybe... .. but the real figues are closer to 15%. http://www.netaction.org/broadband/dsl/section1.html (These stats are from July 2001, but I doubt adoption rates have climbed at too massive a pace since then) -- jon - jon roig online community services manager epilepsy foundation tel: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 10:19 AM To: CF-Talk Subject: RE: OT percentage of Broadband v.s. Dial up CNET radio just stated that 51% are currently on broadband. They did not mention (or I did not hear) the source for that figure. > -Original Message- > From: Chad Gray [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 6:10 PM > To: CF-Talk > Subject: OT percentage of Broadband v.s. Dial up > > > Anyone have a link to statistics showing percentage of users with > broadband > v.s. dial up? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: WebTV Test Browser
http://developer.msntv.com/Tools/WebTVVwr.asp This is the whole site for developers http://developer.msntv.com/ adnd maybe a code validation site: Web Page 'Purifier' - Free on-the-web HTML checker allows viewing a page 'purified' to HTML 2.0, HTML 3.2, HTML 4.0, or WebTV 1.1. standards. http://www.delorie.com/web/purify.html Jerry Johnson >>> [EMAIL PROTECTED] 03/05/02 11:08AM >>> I used to know where to get the WebTV simulator which we now need due to an increasing (!) number of users on a site of ours...but I don't anymore. Anyone?? Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: whats wrong with DateFormat()
The function day() returns a simple number between 1 and 31. It expects a date/time object. The number "5" is a date/time object, but it doesn't represent the day "4". The function dateformat expects a date/time object, a string that looks like a date, or a numeric representation of a date object. I guess t he number "5" has a day of "4". - Original Message - From: Phillip Broussard <[EMAIL PROTECTED]> Date: Tuesday, March 5, 2002 9:15 am Subject: whats wrong with DateFormat() > Ok I put DateFormat(day(now()), 'dd') on a page and instead of > returning05 it gave me 04. > If I put day(now()) on a page I get 5. > If I put day(5) on a page I get 4. > If I put DateFormat(now(), 'mmdd') on a page I get 20020305 > > Why? > > TAI > > Phillip Broussard > Tracker Marine Group > 417-873-5957 > > > ___ _ __ > Dedicated Windows 2000 Server > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > Instant Activation · $99/Month · Free Setup > http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:OT: WebTV Test Browser
I've always downloaded one from http://developer.msntv.com/ HTH Hatton "Eric J Hoffman" <[EMAIL PROTECTED]> wrote on 3/5/2002 11:08:20 AM: > >I used to know where to get the WebTV simulator which we now need due >to an increasing (!) number of users on a site of ours...but I don't >anymore. Anyone?? > >Regards, > >Eric J. Hoffman >Director of Internet Development >DataStream Connexion, LLC >(formerly Small Dog Design) > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT percentage of Broadband v.s. Dial up
I miss heard the original statement. According to Nielson's net ratings, 20% are broadband and account for 51% of the net's activity. > -Original Message- > From: jon [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 11:23 AM > To: CF-Talk > Subject: RE: OT percentage of Broadband v.s. Dial up > > > 51% of users listing to CNET radio, maybe... > > .. but the real figues are closer to 15%. > http://www.netaction.org/broadband/dsl/section1.html > > (These stats are from July 2001, but I doubt adoption rates have > climbed at > too massive a pace since then) > -- jon __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: whats wrong with DateFormat()
I can understand why the number 5 may not work but when I use DateFormat(day(now()), 'dd') I still get a date of yesterday. This just doesn't seem right. Phillip > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 10:25 AM > To: CF-Talk > Subject: Re: whats wrong with DateFormat() > > The function day() returns a simple number between 1 and 31. It > > expects a date/time object. The number "5" is a date/time object, > but > > it doesn't represent the day "4". > > The function dateformat expects a date/time object, a string that looks > > > like a date, or a numeric representation of a date object. I guess t > he > > number "5" has a day of "4". > > > > - Original Message - > From: Phillip Broussard <[EMAIL PROTECTED]> > Date: Tuesday, March 5, 2002 9:15 am > Subject: whats wrong with DateFormat() > > > Ok I put DateFormat(day(now()), 'dd') on a page and instead of > > > returning05 it gave me 04. > > > If I put day(now()) on a page I get 5. > > If I put day(5) on a page I get 4. > > If I put DateFormat(now(), 'mmdd') on a page I get 20020305 > > > > > > Why? > > > > > > TAI > > > > > Phillip Broussard > > Tracker Marine Group > > 417-873-5957 > > > > > > > > ___ > _ > __ > > Dedicated Windows 2000 Server > > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > > Instant Activation . $99/Month . Free Setup > > http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona > > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion > com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb > ar=lists > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: whats wrong with DateFormat()
Dateformat expects a full date. If you try #dateformat("5", 'dd')#,
which
is essentially what you are telling dateformat to work with, you'll get
"4"
returned... not sure why... I would have it throw an error if it's not
a
valid date. Why not just use #dateformat(now(), 'dd')# to get the
desired
result "5"?
Cheers,
Jeff Garza
-Original Message-
From: Phillip Broussard
To: CF-Talk
Sent: 3/5/02 9:33 AM
Subject: RE: whats wrong with DateFormat()
I can understand why the number 5 may not work but when I use
DateFormat(day(now()), 'dd') I still get a date of yesterday. This just
doesn't seem right.
Phillip
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 10:25 AM
> To: CF-Talk
> Subject: Re: whats wrong with DateFormat()
>
> The function day() returns a simple number between 1 and 31. It
>
> expects a date/time object. The number "5" is a date/time object,
> but
>
> it doesn't represent the day "4".
>
> The function dateformat expects a date/time object, a string that
looks
>
>
> like a date, or a numeric representation of a date object. I guess t
> he
>
> number "5" has a day of "4".
>
>
>
> - Original Message -
> From: Phillip Broussard <[EMAIL PROTECTED]>
> Date: Tuesday, March 5, 2002 9:15 am
> Subject: whats wrong with DateFormat()
>
> > Ok I put DateFormat(day(now()), 'dd') on a page and instead of
>
> > returning05 it gave me 04.
>
> > If I put day(now()) on a page I get 5.
> > If I put day(5) on a page I get 4.
> > If I put DateFormat(now(), 'mmdd') on a page I get 20020305
>
> >
>
> > Why?
>
> >
>
> > TAI
> >
>
> > Phillip Broussard
> > Tracker Marine Group
> > 417-873-5957
> >
>
> >
>
> > ___
> _
> __
> > Dedicated Windows 2000 Server
> > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
> > Instant Activation . $99/Month . Free Setup
> > http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
>
> > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion
> com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb
> ar=lists
> >
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Queries Are Running Too Long
Hi Guys! Can anybody tell why this query is taking SEVENTEEN SECONDS to run? I'm looping through a bunch of form variables, and this query is taking 12 to 14 seconds every time (but this first time) to run. I'm running SQL Server and CF Server off my laptop, but it didn't started running this slow until lately. Updating to SQL Server SP2 had no effect. UpdateTimeEntry (Records=1, Time=17095ms) SQL = -- ID: /_PM/includes/get_approver_field.cfm, v1.1.0 4/6/2001 4:45:10 PM dbabbitt (71726827) SET NOCOUNT ON -- Set it up so that you can see if the update actually occurred DECLARE @rowcount INT DECLARE @Audit_ID INT -- Attempt to set the clockin UPDATE Time_Actual SET -- Payroll approves all Approved_House_Manager = 1, Approved_Human_Resources = 1, Approved_Payroll = 1 WHERE Time_Actual_ID = 34552 SET @rowcount = @@ROWCOUNT -- Assume our audit table has a new record in it if we return a row count IF @rowcount > 0 BEGIN SELECT @Audit_ID = MAX(IDENTITYCOL) FROM Time_Actual_Audit UPDATE Time_Actual_Audit -- The user here is the approver SET Users_ID = 1427 WHERE (Time_Actual_Audit_ID = @Audit_ID) END SET NOCOUNT OFF __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX_XMLParser
Hello All, I am trying to get the CFX_XMLParser from cfdev.com working but I am having problems with the cfloop. Here is what I have http://www.somewhere.com http://www.helloall.com "> Status: #obj.result.status# SearchTerm: #obj.result.SearchRequest# ResponseTime: #obj.result.ResponseTime# #Evaluate(#obj.result.record[#Index#].Title.CDATA_ELEMENT#)# The error I am getting is Just in time compilation error Invalid parser construct found on line 33 at position 13. ColdFusion was looking at the following text: obj.result.record[Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was static text occupying document position (31:49) to (33:1). Does anyone know how to fix this??? Thanks Joel __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to Initialize Array within a Structure
I am trying to establish an array within a structure. When I expire the
structure programmatically (calling logout.cfm) and return to the form,
however, the array is not initialized and new choices are printed out with
the old (for example: if I choose "blue" the first time through and "red"
the second time through, printing the array the second time shows both
"blue" and "red"). Twelve is the number of possible choices for "issue".
What am I missing? Does expiring the session not cause
[NOT IsDefined("SESSION.LetterWiz")] to evaluate as true?
Thanks!
Trey
-- index.cfm
logout.cfm ---
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The cf process
Dave, CFCACHE creates temp files in a specified directory - and caching a query does as well I believe. The other thing that comes to mind is the cfusion/mail/* directories (if they are using cfmail) all use file creation to process outgoing mail. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 7:19 AM To: CF-Talk Subject: RE: The cf process > Ok I've been using cf for awhile and have been asked > about the process- how it sends info to/from db, etc. > I explained it and to illustrate showed diagrams from > Forta's and Wrox's books on How ColdFusion Works- (client > request--webserver passes to cf--cf processes all cfml > tags--cf returns html to web server). That wasn't good > enough- they want to know the exact process, all the > files that are used- what permissions are needed on > files/directories of each server (web/cf/sql), etc as > the pages are being processed, any and all services used, > any temporary files made. So I'm now trying to explain > exactly how a login works however, I haven't been able to > give the detail that's requested- I guess I just know > the generic part that cfquery passes to sql by way of > datasource- etc but don't know if it leaves any temp > files,etc. (And I haven't been able to find it) To the best of my knowledge, CF doesn't create any temporary files except when accepting uploaded files. As for permissions, those may vary depending on the operating system and web server used, and the way CF integrates with that web server. You might find this permissions discussion, which covers NT, IIS 4, and CF 4.x, useful: http://www.defusion.com/articles/index.cfm?ArticleID=89 In general, the web server (or in the case of IIS, which does impersonation, the IIS anonymous user account or a specific impersonated user account - a logged-in user) will need read/execute rights on CF scripts (.cfm, .dbm), and the CF server, which by default on Windows runs as SYSTEM, will need execute rights on those same scripts. On Windows, with IIS, you can actually tighten this a bit - users only need execute rights, and CF only needs read rights. The CF server account will need read/execute permissions on the appropriate binaries in the \CFUSION directory, and read/write permissions on the appropriate registry keys. The CF server will need execute permissions on database client binaries. The only services involved here are the web server and the CF Application Server. SQL databases, such as SQL Server and Oracle, have their own methods for handling permissions. Typically, you'd need to create a user within the database, assign that user the appropriate rights, and use the username and password for that user within your CF datasource or application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ListContains NOT functioning properly - Help!
Help!
When I'm looping over a list Campaign.Vehicles that's coming from a SQL
table varchar field I'm getting strange results from ListContains.
Looping over Vehicles.code=
"siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" - several rows from
a database call.
Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a 'static' database
record.
When Vehicles.code = "SiteSpin" the below
"ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4.
checked>
#Vehicles.Name#
Actual output to screen from testing:
Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
Vehicles.Code: siteSpin
ListContains - 4
As far as I can see from the output above siteSpin is only in the list
Campaign.Vehicles once. Can anybody see something I can't. I've tried
specifying the delimiter as a comma, changing the delimiter to a ~, setting
the database field to a variable, changing the delimiters of that variable
and I've tried all of those things with ListContainsNoCase as well. I've
even tried changing the datatype of my SQL database field to nvarchar, ntext
etc! Please help, this is holding up a very profitable ad campaign from
being served on my site!
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ListContains NOT functioning properly - Help!
ListCOntains returns the index, not the # of matches.
===
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
> -Original Message-
> From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 12:32 PM
> To: CF-Talk
> Subject: ListContains NOT functioning properly - Help!
>
>
> Help!
>
> When I'm looping over a list Campaign.Vehicles that's coming
> from a SQL
> table varchar field I'm getting strange results from ListContains.
>
> Looping over Vehicles.code=
> "siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" -
> several rows from
> a database call.
>
> Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a
> 'static' database
> record.
>
> When Vehicles.code = "SiteSpin" the below
> "ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4.
>
>
> "#Vehicles.Code#")>checked>
> #Vehicles.Name#
>
>
> Actual output to screen from testing:
> Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
> Vehicles.Code: siteSpin
> ListContains - 4
>
> As far as I can see from the output above siteSpin is only in the list
> Campaign.Vehicles once. Can anybody see something I can't.
> I've tried
> specifying the delimiter as a comma, changing the delimiter
> to a ~, setting
> the database field to a variable, changing the delimiters of
> that variable
> and I've tried all of those things with ListContainsNoCase as
> well. I've
> even tried changing the datatype of my SQL database field to
> nvarchar, ntext
> etc! Please help, this is holding up a very profitable ad
> campaign from
> being served on my site!
>
> Mark Kecko
> The Computer Guy
> MediaPost Communications
> [EMAIL PROTECTED]
> http://www.mediapost.com
> (203)222-0330 ext309
>
> "Imagination is the one weapon in the war against reality."
> Jules de Gaultier
>
>
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The cf process
> CFCACHE creates temp files in a specified directory - and > caching a query does as well I believe. Yes, CFCACHE creates temp files. Caching a query, however, doesn't, although creating a persistent query through RDS does. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ListContains NOT functioning properly - MORE!
Sorry if my original message is hard to get, just try running this code in a
test page. Are the results as expected?
What's wrong here?
checked>
#i#
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:32 PM
To: CF-Talk
Subject: ListContains NOT functioning properly - Help!
Help!
When I'm looping over a list Campaign.Vehicles that's coming from a SQL
table varchar field I'm getting strange results from ListContains.
Looping over Vehicles.code=
"siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" - several rows from
a database call.
Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a 'static' database
record.
When Vehicles.code = "SiteSpin" the below
"ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4.
checked>
#Vehicles.Name#
Actual output to screen from testing:
Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
Vehicles.Code: siteSpin
ListContains - 4
As far as I can see from the output above siteSpin is only in the list
Campaign.Vehicles once. Can anybody see something I can't. I've tried
specifying the delimiter as a comma, changing the delimiter to a ~, setting
the database field to a variable, changing the delimiters of that variable
and I've tried all of those things with ListContainsNoCase as well. I've
even tried changing the datatype of my SQL database field to nvarchar, ntext
etc! Please help, this is holding up a very profitable ad campaign from
being served on my site!
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: submitting forms with mozilla
Thanks, but I wonder if there's a larger issue. The site I'm working on
uses Verisign's Paylink. Mozilla always fails their validation tho IE
doesn't. Since Mozilla is supposed to be HTML compliant, I wondered if
there was a form attribute that needed to be set. If an email address is
correctly formatted but throws an error where other browsers don't then
maybe it's sending the data differently.
Douglas Brown wrote:
> try this
>
>
> (REFindNoCase("[[:alnum:]_\.\-]+@([[:alnum:]_\.\-]+\.)+[[:alpha:]]{2,4}",
> address))>
> True
>
> False
>
>
>
>
>
>
>
> "Success is a journey, not a destination!!"
>
>
>
> Doug Brown
> - Original Message -
> From: "Douglas Jordon" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, March 04, 2002 3:25 PM
> Subject: submitting forms with mozilla
>
>
>
>>When I submit a form with mozilla, this validation(which I got from
>>
> this
>
>>list, thank you) always fails, although it will work in IE:
>>
>>>
>>
> refindnocase('(^[a-z0-9]([._-]?[a-z0-9]+)*+\@[a-z0-9]+([.-]?[a-z0-9]+)*\.
> [a-
>
>>z]{2,3}$)', trim(form.email), 1)>
>>valid
>>
>>invalid
>>
>>
>>
>>I've tried all of these various ENCTYPE attributes:
>>"multipart/form-data" | "application/x-www-form-urlencoded" |
>>
> "text/plain"
>
>>Anyone ever run across this?
>>
>>TIA,
>>
>>Doug Jordon
>>
>>
>
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Queries Are Running Too Long
> Can anybody tell why this query is taking SEVENTEEN SECONDS > to run? I'm looping through a bunch of form variables, and > this query is taking 12 to 14 seconds every time (but this > first time) to run. I'm running SQL Server and CF Server > off my laptop, but it didn't started running this slow until > lately. Updating to SQL Server SP2 had no effect. Nothing within the query struck me as an obvious problem (although I didn't read it that carefully). My two suggestions are: 1. Use the debugging information that SQL Server provides. Run the query from within Query Analyzer, and set SHOWPLAN options or use the graphical execution plan display in SQL Server 2000. 2. Take a look at your indexes. Have you created indexes that will best suit your search queries as the amount of data grows larger? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
can someone see a problem with this!!!
Hello everyone, I must be missing something. I keep getting an error "data mismatch in criteria". But it looks right to me? What am I missing? I may be looking too hard. UPDATE stores SET storename='#Form.storename#', map='#Form.map#', description='#Form.description#', salestart='#Form.salestart#', saleend='#Form.saleend#', saleinfo='#Form.saleinfo#', wwwlink='#Form.wwwlink#', mensapparel=#Form.mensapparel#, womensapparel=#Form.womensapparel#, maternity=#Form.maternity#, AccessoriesJewelry=#Form.AccessoriesJewelry#, ChildrenApparel=#Form.ChildrenApparel#, FoodDrink=#Form.FoodDrink#, toysgames=#Form.toysgames#, HomeFurnishings=#Form.HomeFurnishings#, music=#Form.music#, Shoes=#Form.Shoes#, saletitle='#Form.saletitle#' WHERE storeID=#Variables.RecordID# Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Tuesday, March 05, 2002, at 12:45:05 PM __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can someone see a problem with this!!!
Are: mensapparel=#Form.mensapparel#, womensapparel=#Form.womensapparel#, maternity=#Form.maternity#, AccessoriesJewelry=#Form.AccessoriesJewelry#, ChildrenApparel=#Form.ChildrenApparel#, FoodDrink=#Form.FoodDrink#, toysgames=#Form.toysgames#, HomeFurnishings=#Form.HomeFurnishings#, music=#Form.music#, Shoes=#Form.Shoes#, All numbers? If not then they should have '#form.whatever#' around... And any date/numeric fields should have none... J -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 17:47 To: CF-Talk Subject: can someone see a problem with this!!! Hello everyone, I must be missing something. I keep getting an error "data mismatch in criteria". But it looks right to me? What am I missing? I may be looking too hard. UPDATE stores SET storename='#Form.storename#', map='#Form.map#', description='#Form.description#', salestart='#Form.salestart#', saleend='#Form.saleend#', saleinfo='#Form.saleinfo#', wwwlink='#Form.wwwlink#', mensapparel=#Form.mensapparel#, womensapparel=#Form.womensapparel#, maternity=#Form.maternity#, AccessoriesJewelry=#Form.AccessoriesJewelry#, ChildrenApparel=#Form.ChildrenApparel#, FoodDrink=#Form.FoodDrink#, toysgames=#Form.toysgames#, HomeFurnishings=#Form.HomeFurnishings#, music=#Form.music#, Shoes=#Form.Shoes#, saletitle='#Form.saletitle#' WHERE storeID=#Variables.RecordID# Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Tuesday, March 05, 2002, at 12:45:05 PM __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can someone see a problem with this!!!
I assume all of the fields from mensapparel down, and also saleinfo, are number fields? will -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 17:47 To: CF-Talk Subject: can someone see a problem with this!!! Hello everyone, I must be missing something. I keep getting an error "data mismatch in criteria". But it looks right to me? What am I missing? I may be looking too hard. UPDATE stores SET storename='#Form.storename#', map='#Form.map#', description='#Form.description#', salestart='#Form.salestart#', saleend='#Form.saleend#', saleinfo='#Form.saleinfo#', wwwlink='#Form.wwwlink#', mensapparel=#Form.mensapparel#, womensapparel=#Form.womensapparel#, maternity=#Form.maternity#, AccessoriesJewelry=#Form.AccessoriesJewelry#, ChildrenApparel=#Form.ChildrenApparel#, FoodDrink=#Form.FoodDrink#, toysgames=#Form.toysgames#, HomeFurnishings=#Form.HomeFurnishings#, music=#Form.music#, Shoes=#Form.Shoes#, saletitle='#Form.saletitle#' WHERE storeID=#Variables.RecordID# Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Tuesday, March 05, 2002, at 12:45:05 PM __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: can someone see a problem with this!!!
Hello cf-talk, On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote: WS> I assume all of the fields from mensapparel down, and also saleinfo, are WS> number fields? WS> will Well, the fields are yes/no in an Access. So, it looks like that is really a number field. 1 or 0? So single quotes? WS> -Original Message- WS> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] WS> Sent: 05 March 2002 17:47 WS> To: CF-Talk WS> Subject: can someone see a problem with this!!! WS> Hello everyone, WS> I must be missing something. I keep getting an error "data mismatch in WS> criteria". WS> But it looks right to me? What am I missing? I may be looking too WS> hard. WS> WS> UPDATE stores WS> SET storename='#Form.storename#', WS> map='#Form.map#', WS> description='#Form.description#', WS> salestart='#Form.salestart#', WS> saleend='#Form.saleend#', WS> saleinfo='#Form.saleinfo#', WS> wwwlink='#Form.wwwlink#', WS> mensapparel=#Form.mensapparel#, WS> womensapparel=#Form.womensapparel#, WS> maternity=#Form.maternity#, WS> AccessoriesJewelry=#Form.AccessoriesJewelry#, WS> ChildrenApparel=#Form.ChildrenApparel#, WS> FoodDrink=#Form.FoodDrink#, WS> toysgames=#Form.toysgames#, WS> HomeFurnishings=#Form.HomeFurnishings#, WS> music=#Form.music#, WS> Shoes=#Form.Shoes#, WS> saletitle='#Form.saletitle#' WS> WHERE storeID=#Variables.RecordID# WS> WS> Best regards, WS> Jeff Fongemie mailto:[EMAIL PROTECTED] WS> _ WS> Composed on Tuesday, March 05, 2002, at 12:45:05 PM WS> __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: can someone see a problem with this!!!
Hello cf-talk, On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote: WS> I assume all of the fields from mensapparel down, and also saleinfo, are WS> number fields? all of the fields from mensapparel down are yes/no boolean fields in Access. saletitle is text, salestart/end are dates. I don't get it, it still looks right. WS> -Original Message- WS> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] WS> Sent: 05 March 2002 17:47 WS> To: CF-Talk WS> Subject: can someone see a problem with this!!! WS> Hello everyone, WS> I must be missing something. I keep getting an error "data mismatch in WS> criteria". WS> But it looks right to me? What am I missing? I may be looking too WS> hard. WS> WS> UPDATE stores WS> SET storename='#Form.storename#', WS> map='#Form.map#', WS> description='#Form.description#', WS> salestart='#Form.salestart#', WS> saleend='#Form.saleend#', WS> saleinfo='#Form.saleinfo#', WS> wwwlink='#Form.wwwlink#', WS> mensapparel=#Form.mensapparel#, WS> womensapparel=#Form.womensapparel#, WS> maternity=#Form.maternity#, WS> AccessoriesJewelry=#Form.AccessoriesJewelry#, WS> ChildrenApparel=#Form.ChildrenApparel#, WS> FoodDrink=#Form.FoodDrink#, WS> toysgames=#Form.toysgames#, WS> HomeFurnishings=#Form.HomeFurnishings#, WS> music=#Form.music#, WS> Shoes=#Form.Shoes#, WS> saletitle='#Form.saletitle#' WS> WHERE storeID=#Variables.RecordID# WS> Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ListContains NOT functioning properly - MORE!
Looks to me like you ListContains function needs a
delimiter.
ListContains("#Vehicles#", "#i#", ",")
Hope that helps.
Kevin
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 10:43 AM
To: CF-Talk
Subject: ListContains NOT functioning properly - MORE!
Sorry if my original message is hard to get, just try
running this code in a
test page. Are the results as expected?
What's wrong here?
checked>
#i#
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:32 PM
To: CF-Talk
Subject: ListContains NOT functioning properly - Help!
Help!
When I'm looping over a list Campaign.Vehicles that's coming
from a SQL
table varchar field I'm getting strange results from
ListContains.
Looping over Vehicles.code=
"siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" -
several rows from
a database call.
Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a
'static' database
record.
When Vehicles.code = "SiteSpin" the below
"ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")"
returns 4.
checked>
#Vehicles.Name#
Actual output to screen from testing:
Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
Vehicles.Code: siteSpin
ListContains - 4
As far as I can see from the output above siteSpin is only
in the list
Campaign.Vehicles once. Can anybody see something I can't.
I've tried
specifying the delimiter as a comma, changing the delimiter
to a ~, setting
the database field to a variable, changing the delimiters of
that variable
and I've tried all of those things with ListContainsNoCase
as well. I've
even tried changing the datatype of my SQL database field to
nvarchar, ntext
etc! Please help, this is holding up a very profitable ad
campaign from
being served on my site!
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation 7 $99/Month 7 Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can someone see a problem with this!!!
What are the values contained in those form fields? (I'm Assuming they are check boxes) - j -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 1:09 PM To: CF-Talk Subject: Re: can someone see a problem with this!!! Hello cf-talk, On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote: WS> I assume all of the fields from mensapparel down, and also saleinfo, are WS> number fields? all of the fields from mensapparel down are yes/no boolean fields in Access. saletitle is text, salestart/end are dates. I don't get it, it still looks right. WS> -Original Message- WS> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] WS> Sent: 05 March 2002 17:47 WS> To: CF-Talk WS> Subject: can someone see a problem with this!!! WS> Hello everyone, WS> I must be missing something. I keep getting an error "data mismatch in WS> criteria". WS> But it looks right to me? What am I missing? I may be looking too WS> hard. WS> WS> UPDATE stores WS> SET storename='#Form.storename#', WS> map='#Form.map#', WS> description='#Form.description#', WS> salestart='#Form.salestart#', WS> saleend='#Form.saleend#', WS> saleinfo='#Form.saleinfo#', WS> wwwlink='#Form.wwwlink#', WS> mensapparel=#Form.mensapparel#, WS> womensapparel=#Form.womensapparel#, WS> maternity=#Form.maternity#, WS> AccessoriesJewelry=#Form.AccessoriesJewelry#, WS> ChildrenApparel=#Form.ChildrenApparel#, WS> FoodDrink=#Form.FoodDrink#, WS> toysgames=#Form.toysgames#, WS> HomeFurnishings=#Form.HomeFurnishings#, WS> music=#Form.music#, WS> Shoes=#Form.Shoes#, WS> saletitle='#Form.saletitle#' WS> WHERE storeID=#Variables.RecordID# WS> Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can someone see a problem with this!!!
well the error points to the criteria field, so have you checked what #Variables.RecordID# is? put #Variables.RecordID# right before your query to check. is StoreID defined to be the datatype of #Variables.RecordID#? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 1:09 PM To: CF-Talk Subject: Re: can someone see a problem with this!!! Hello cf-talk, On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote: WS> I assume all of the fields from mensapparel down, and also saleinfo, are WS> number fields? all of the fields from mensapparel down are yes/no boolean fields in Access. saletitle is text, salestart/end are dates. I don't get it, it still looks right. WS> -Original Message- WS> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] WS> Sent: 05 March 2002 17:47 WS> To: CF-Talk WS> Subject: can someone see a problem with this!!! WS> Hello everyone, WS> I must be missing something. I keep getting an error "data mismatch in WS> criteria". WS> But it looks right to me? What am I missing? I may be looking too WS> hard. WS> WS> UPDATE stores WS> SET storename='#Form.storename#', WS> map='#Form.map#', WS> description='#Form.description#', WS> salestart='#Form.salestart#', WS> saleend='#Form.saleend#', WS> saleinfo='#Form.saleinfo#', WS> wwwlink='#Form.wwwlink#', WS> mensapparel=#Form.mensapparel#, WS> womensapparel=#Form.womensapparel#, WS> maternity=#Form.maternity#, WS> AccessoriesJewelry=#Form.AccessoriesJewelry#, WS> ChildrenApparel=#Form.ChildrenApparel#, WS> FoodDrink=#Form.FoodDrink#, WS> toysgames=#Form.toysgames#, WS> HomeFurnishings=#Form.HomeFurnishings#, WS> music=#Form.music#, WS> Shoes=#Form.Shoes#, WS> saletitle='#Form.saletitle#' WS> WHERE storeID=#Variables.RecordID# WS> Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFApplication
From what I have understood, CFAPPLICATION by default will not expire client variables on browser close. I have clientmanagement turned on session management turned off, client storage to an odbc datasource and set client cookies turned off. What I am trying to do is pass CFID and CFTOKEN on each link, but want to test for this value and if the CGLOBAL.LVISIT from the client storage tables is greater than 10 minutes then redirect them back to the main index.cfm page. Any Ideas --- Graham Pearson, System Administrator / Webmaster Northern Indiana Educational Services Center Http://support.niesc.k12.in.us Email: [EMAIL PROTECTED] Voice (800) 326-5642 or (219) 254-0111 Fax (219) 254-0148 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Rotating banners
Hello- I am developing a banner rotating tool and need some ideas on how to best handle a requirement. I have gotten the tool to a point where it displays banners randomly- no problem. Now what I need to do is give certain banners more "weight" than others: some banners need to be displayed more frequently than the rest. The code that I have below gives equal weight to each banner; I need to find a way to give some banners more prevalence on our pages. SELECT i.*, a.advert_name FROM images i, advertiser a WHERE i.id = #activeBanners[randomId]# and i.advert_id = a.advert_id Any ideas? Thanks in advance, Elizabeth __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help...
Hi all, I 'm stuck. The below code reads and displays the contents of my database. SELECT sti, ID FROMfontsti ORDER BY sti [#GetFontFamily.ID#] #GetFontFamily.sti# This displays something like... [1] aachen.sti [2] accolade.sti [3] adelon.sti [4] amelia.sti [5] american-unciale.sti [6] angelo.sti [7] avantgarde.sti [8] ballantines.sti [9] bamberg.sti [10] baskerville.sti [11] bauhaus.sti [12] belfast.sti [13] bernstein.sti [14] birch.sti [15] Blackoak.sti [16] boascript.sti [17] bodoni.sti [18] bookman.sti [19] borderpi-15159.sti [20] boutique.sti I have an external file that I'm reading in that I want to compare against the above list and display the appropriate ID numbers. Below is the contents of my ASCII file and the code. file.txt amelia angelo ballantines baskerville belfast [#GetFontFamily.ID#] #Trim(i)#.sti This is what gets displayed: [1] amelia [1] angelo [1] ballantines [1] baskerville [1] belfast How can I display the following? [4] amelia [6] angelo [8] ballantines [10] baskerville [12] belfast __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Rotating banners
i've done this by using time. it's kind of 2 fold. Weight 6 ad1,ad2,ad3,ad4 weight 3 ad5, ad6, ad7, ad8 -I'd assign the "weight" of each banner before hand. -Grab the last digit in the seconds of the current time. -Display an ad from the weight group that corresponds w/ the time integ er i.e. if the last digit in the time was 6 it would display an ad w/ a weight of 6 or higher and if it was 3 it'd display ads from the 3 weight group. if i wanted an ad to have a chance of being displayed 70% of the time i 'd set it to weight 3. make sense? i would actually like to see a cleaner way of doing but th at works. Savan Elizabeth Walter <[EMAIL PROTECTED]> on 03/05/2002 12:14:29 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: Rotating banners Hello- I am developing a banner rotating tool and need some ideas on how to be st handle a requirement. I have gotten the tool to a point where it dis plays banners randomly- no problem. Now what I need to do is give certain banners more "weight" than others: some banners need to be displayed more frequently than the rest. The code that I have below gives equal wei ght to each banner; I need to find a way to give some banners more prevalence on our pages. SELECT i.*, a.advert_name FROM images i, advertiser a WHERE i.id = #activeBanners[randomId]# and i.advert_id = a.advert_id Any ideas? Thanks in advance, Elizabeth __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: can someone see a problem with this!!!
Hello cf-talk, On Tue, 5 Mar 2002, at 13:12:20 you carefully wrote: JC> What are the values contained in those form fields? (I'm Assuming they are JC> check boxes) JC> - j The values are 1 or 0, they are radio buttons. JC> -Original Message- JC> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] JC> Sent: Tuesday, March 05, 2002 1:09 PM JC> To: CF-Talk JC> Subject: Re: can someone see a problem with this!!! JC> Hello cf-talk, JC> On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote: WS>> I assume all of the fields from mensapparel down, and also saleinfo, are WS>> number fields? JC> all of the fields from mensapparel down are yes/no boolean JC> fields in Access. JC> saletitle is text, salestart/end are dates. JC> I don't get it, it still looks right. WS>> -Original Message- WS>> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] WS>> Sent: 05 March 2002 17:47 WS>> To: CF-Talk WS>> Subject: can someone see a problem with this!!! WS>> Hello everyone, WS>> I must be missing something. I keep getting an error "data mismatch in WS>> criteria". WS>> But it looks right to me? What am I missing? I may be looking too WS>> hard. WS>> WS>> UPDATE stores WS>> SET storename='#Form.storename#', WS>> map='#Form.map#', WS>> description='#Form.description#', WS>> salestart='#Form.salestart#', WS>> saleend='#Form.saleend#', WS>> saleinfo='#Form.saleinfo#', WS>> wwwlink='#Form.wwwlink#', WS>> mensapparel=#Form.mensapparel#, WS>> womensapparel=#Form.womensapparel#, WS>> maternity=#Form.maternity#, WS>> AccessoriesJewelry=#Form.AccessoriesJewelry#, WS>> ChildrenApparel=#Form.ChildrenApparel#, WS>> FoodDrink=#Form.FoodDrink#, WS>> toysgames=#Form.toysgames#, WS>> HomeFurnishings=#Form.HomeFurnishings#, WS>> music=#Form.music#, WS>> Shoes=#Form.Shoes#, WS>> saletitle='#Form.saletitle#' WS>> WHERE storeID=#Variables.RecordID# WS>> JC> Best regards, JC> Jeff Fongemie mailto:[EMAIL PROTECTED] JC> __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rotating banners
Gotcha. Interesting solution- I wouldn't have thought to do it that way. I'll give it a shot! Thanks a lot, Elizabeth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 1:29 PM To: CF-Talk Subject: Re: Rotating banners i've done this by using time. it's kind of 2 fold. Weight 6 ad1,ad2,ad3,ad4 weight 3 ad5, ad6, ad7, ad8 -I'd assign the "weight" of each banner before hand. -Grab the last digit in the seconds of the current time. -Display an ad from the weight group that corresponds w/ the time integ er i.e. if the last digit in the time was 6 it would display an ad w/ a weight of 6 or higher and if it was 3 it'd display ads from the 3 weight group. if i wanted an ad to have a chance of being displayed 70% of the time i 'd set it to weight 3. make sense? i would actually like to see a cleaner way of doing but th at works. Savan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: can someone see a problem with this!!!
Hello Kathryn, On Tue, 5 Mar 2002, at 13:15:02 you carefully wrote: kwc> well the error points to the criteria field, so have you checked what kwc> #Variables.RecordID# is? kwc> put kwc> #Variables.RecordID# right before your kwc> query kwc> to check. kwc> is StoreID defined to be the datatype of #Variables.RecordID#? Yes, with the above test, the query is getting the storeid needed. Yes storeis is variables.recordid. For the fun of it, I just changed the query to a and revisit this later. I must be looking too hard, and overlooking something obvious. kwc> -Original Message- kwc> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] kwc> Sent: Tuesday, March 05, 2002 1:09 PM kwc> To: CF-Talk kwc> Subject: Re: can someone see a problem with this!!! kwc> Hello cf-talk, kwc> On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote: WS>> I assume all of the fields from mensapparel down, and also kwc> saleinfo, are WS>> number fields? kwc> all of the fields from mensapparel down are yes/no boolean kwc> fields in Access. kwc> saletitle is text, salestart/end are dates. kwc> I don't get it, it still looks right. WS>> -Original Message- WS>> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] WS>> Sent: 05 March 2002 17:47 WS>> To: CF-Talk WS>> Subject: can someone see a problem with this!!! WS>> Hello everyone, WS>> I must be missing something. I keep getting an error "data mismatch kwc> in WS>> criteria". WS>> But it looks right to me? What am I missing? I may be looking too WS>> hard. WS>> > WS>> UPDATE stores WS>> SET storename='#Form.storename#', WS>> map='#Form.map#', WS>> description='#Form.description#', WS>> salestart='#Form.salestart#', WS>> saleend='#Form.saleend#', WS>> saleinfo='#Form.saleinfo#', WS>> wwwlink='#Form.wwwlink#', WS>> mensapparel=#Form.mensapparel#, WS>> womensapparel=#Form.womensapparel#, WS>> maternity=#Form.maternity#, WS>> AccessoriesJewelry=#Form.AccessoriesJewelry#, WS>> ChildrenApparel=#Form.ChildrenApparel#, WS>> FoodDrink=#Form.FoodDrink#, WS>> toysgames=#Form.toysgames#, WS>> HomeFurnishings=#Form.HomeFurnishings#, WS>> music=#Form.music#, WS>> Shoes=#Form.Shoes#, WS>> saletitle='#Form.saletitle#' WS>> WHERE storeID=#Variables.RecordID# WS>> kwc> Best regards, kwc> Jeff Fongemie mailto:[EMAIL PROTECTED] kwc> __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Multi Processor Server Config
I have just recieved my new CF Server 5 upgrade and have a brand new system with multi processors. Does anyone know how to configure the server so that it takes full advantage of both these processors? I am running win2000 with IIS. Thanks, Ray Bujarski 858-845-7669 858-636-9900 pgr [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Rotating banners
I would think that you would loop through your query, and build a list. For each query record, loop from 1 to the weight value, and add the bannerID to the a list called bannerIDList for each nested loop. This way if you have one banner with bannerID=301 and weight=2, and a second banner with bannerID=302 and weight=10, the list would look like: "301,301,302,302,302,302,302,302,302,302,302,302" Then you could pull a random ID from this list and run the query. >>> Elizabeth Walter <[EMAIL PROTECTED]> 03/05/02 01:14PM >>> Hello- I am developing a banner rotating tool and need some ideas on how to best handle a requirement. I have gotten the tool to a point where it displays banners randomly- no problem. Now what I need to do is give certain banners more "weight" than others: some banners need to be displayed more frequently than the rest. The code that I have below gives equal weight to each banner; I need to find a way to give some banners more prevalence on our pages. SELECT i.*, a.advert_name FROM images i, advertiser a WHERE i.id = #activeBanners[randomId]# and i.advert_id = a.advert_id Any ideas? Thanks in advance, Elizabeth __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multi Processor Server Config
> I have just recieved my new CF Server 5 upgrade and have > a brand new system with multi processors. Does anyone know > how to configure the server so that it takes full advantage > of both these processors? I am running win2000 with IIS. You shouldn't have to do anything, really, as Win2K should take care of that for you automatically. Typically, you might have a higher optimal value within the "Limit Simultaneous Requests" setting in the Settings page of the CF Administrator, but you really have to load-test to find that optimal value anyway. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: simple cfloop
try this for your query select, this, that, theotherthing from tblName where id IN (#form.ids#) -Original Message- From: Sorgatz, Rex [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 8:33 PM To: CF-Talk Subject: simple cfloop Beginner CFer with an easy question. The situation: the user selects the rows to query based upon ticking checkboxes. So, this is the first page: Using a list and a cfloop to return multiple columns in only the rows the user selects, what would the tally.cfm page look like? I'm looking at something like this, but I know it's wrong: SELECT this, that, theotherthing FROM tblName WHERE ID = #id# #this##that##theotherthing# Thanks for your help. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFConf news - ColdFusion MX and Flash MX
You are invited to ColoradoTechCon, CFNorth and CFUN-02. Learn ColdFusion, Flash and Java to help you program great websites! - Michael Smith, TeraTech, Inc http://www.teratech.com/ * Colorado Tech Con 3/14 - 3/15 Denver CO http://www.coloradotechcon.com/ * CFNORTH 5/4 - 5/5 Toronto, Canada http://www.cfnorth.com/ * CFUN-02 6/15 - 6/16 Washington DC http://www.cfconf.com/cfun-02/ more details below: Colorado Tech Con * http://www.coloradotechcon.com/ March 14 & 15, 2002 Sponsored and organized by GT Alliance As you may have already heard today; Macromedia announced the release of Flash MX and ColdFusion MX. We are now able to tell everyone that Flash MX will be covered extensively during the Colorado Macromedia Technology Conference(CMTC). There will be many seminars during the conference that will feature detailed information about this new version of Flash. The CMTC is the first regional event in the nation to offer detailed information about this new product. Allen Ellison of Macromedia will be presenting several seminars about Flash MX and all the new features including: Flash MX for Designers Flash MX for Developers The CMTC is a 2-day conference covering ColdFusion, Flash and Emerging Technologies. The conference features 90 minute seminars by industry experts in Internet design and development. Check the website for full details. Space is limited and registration is only $250, so register online or by phone today. For more information about Flash MX and ColdFusion MX check the links below. http://www.macromedia.com/macromedia/proom/pr/2002/flash_mx.html http://www.macromedia.com/macromedia/proom/pr/2002/flash_mx_apps.html http://www.macromedia.com/software/flash/ Join us for the Colorado Macromedia Technology Conference. Taking place March 14 & 15, 2002 in Denver, Colorado at the Colorado Convention Center. Covering Flash, ColdFusion, Java and Emerging Technologies, this conference will help any IT professional refine and increase their knowledge and skills. This will be an intesive 2 days of 90 minute seminars on indepth information on many advanced topics. If you want to know about the future of ColdFusion, JRun or Flash you cannot afford to miss this conference. Participants will take part in four tracks including: .Web Design .Application Architecture .Application Development .Emerging Technologies Hot topics such as Neo, The Future of JRun, ColdFusion & Flash Integration, The Future of Flash, XML, Enterprise Web Services, .Net Integration, UML, and Agile Programming will be covered. Featured Speakers from the Macromedia Technology Team .Edwin Smith- The inspiration behind ColdFusion Neo .Tim Buntel- The ColdFusion Neo product manager .Tom Reilly- The lead JRun architect. .Ben Forta- The ColdFusion Product Evangelist Featured Designers .Eric Jordon - Ceo and Chief Designer of award winning 2 Advanced Studios .Mike Cina and Mike Young- We Work For Them (www.weworkforthem.com) Also speaking are industry professionals such as Jim Foley(Electric Rain), Doug Nottage(Autobytel), author of Programming ColdFusion Rob Brooks-Bilson, Emily Kim (GT Alliance), Gary Rosenzweig(Clever Media) and Macromedia's Allen Ellison, Raymond Camden, and Mike Nimer. For a full list of speakers please check the website. Conference registration includes 2 days of seminars, a reception and various product raffles. Registration is now available on-line at www.coloradotechcon.com, by calling 970.224.1335 or by e-mailing [EMAIL PROTECTED] Sponsored by: GT Alliance(www.gtalliance.com) GT Alliance is a Macromedia Premier Sales, Training and Consulting Partner Our New Winter/Spring 2002 Training Course Schedule is now available! Visit us online at www.gtalliance.com/training.cfm for course information and to register. Electric Rain (www.erain.com) Check out Electric Rain's industry-leading, Swift 3D v2 standalone app, Swift 3D plug-ins for 3ds max and Lightwave, 3D-to-vector solutions for Macromedia Flash, (SWF), (EPS), (AI), and (SVG). Breckenridge Communications (www.breckcomm.com) Breckenridge Communications empowers companies by helping them extend their business model around Internet markets and technologies. Macromedia (www.macromedia.com), Granularity Information Architecture (www.granularity..com), TeraTech ( www.teratech.com ) --- CFNORTH *** http://www.cfnorth.com/ May 4th - 5th, 2002 Toronto, Canada Use Reg discount code CFNTECH361 $195 CAN $120 regular price $225 CAN $140 Keynote speakers are Jeremy Allaire and Robert Diamond. Guest speaker Ben Forta. This is the perfect opportunity to learn, network and talk with professional developers from this community and from around the globe about your products, the latest tricks, techniques and innovations in ColdFusion and Internet development. CFNORTH UPDATE issue No.2 CFNorth ColdFusion Developers Conference, MAY 4-5 Toronto Eaton Centre Marriott Hotel: TORON
RE: Multi Processor Server Config
In win2k, i dont remember exactly where it is, you can assign certain processes to a processor manually. Dave Watts <[EMAIL PROTECTED]> on 03/05/2002 12:48:25 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: Multi Processor Server Config > I have just recieved my new CF Server 5 upgrade and have > a brand new system with multi processors. Does anyone know > how to configure the server so that it takes full advantage > of both these processors? I am running win2000 with IIS. You shouldn't have to do anything, really, as Win2K should take care of that for you automatically. Typically, you might have a higher optimal val ue within the "Limit Simultaneous Requests" setting in the Settings page o f the CF Administrator, but you really have to load-test to find that optimal value anyway. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sorry to flood the List BUT.... ListContains NOT functioning properly!
Sorry, but... Why does the below code check 4 boxes when there's only 3
items in the List???
Please help!!! This is costing my company a good deal of cash! - Just copy
and paste the code into a test page and run it, you'll see, I hope.
checked>
#i#
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:32 PM
To: CF-Talk
Subject: ListContains NOT functioning properly - Help!
Help!
When I'm looping over a list Campaign.Vehicles that's coming from a SQL
table varchar field I'm getting strange results from ListContains.
Looping over Vehicles.code=
"siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" - several rows from
a database call.
Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a 'static' database
record.
When Vehicles.code = "SiteSpin" the below
"ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4.
checked>
#Vehicles.Name#
Actual output to screen from testing:
Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
Vehicles.Code: siteSpin
ListContains - 4
As far as I can see from the output above siteSpin is only in the list
Campaign.Vehicles once. Can anybody see something I can't. I've tried
specifying the delimiter as a comma, changing the delimiter to a ~, setting
the database field to a variable, changing the delimiters of that variable
and I've tried all of those things with ListContainsNoCase as well. I've
even tried changing the datatype of my SQL database field to nvarchar, ntext
etc! Please help, this is holding up a very profitable ad campaign from
being served on my site!
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Macromedia's XML Resource Feed
Hi, Has anyone used Macromedia's resource feed with CF located at http://www.macromedia.com/desdev/articles/xml_resource_feed.html How is it done? I've done XML parsing with Moreover's XML feeds using WDDX, but this is different. Here's my feeble code: http://www.macromedia.com/desdev/resources/macromedia_resources.xml";> The error is: unknown element encountered I know I'm probably way off in using WDDX to parse the xml doc here. Any help here greatly appreciated. Thanks! Andrew __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorry to flood the List BUT.... ListContains NOT functioning properly!
Isn't it because "spin" IS contained in the list? in siteSpin?
Kathryn Butterly
Web Developer
Washington Mutual Finance
813 632-4490
[EMAIL PROTECTED]
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 1:59 PM
To: CF-Talk
Subject: Sorry to flood the List BUT ListContains NOT functioning
properly!
Sorry, but... Why does the below code check 4 boxes when there's only 3
items in the List???
Please help!!! This is costing my company a good deal of cash! - Just
copy
and paste the code into a test page and run it, you'll see, I hope.
checked>
#i#
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:32 PM
To: CF-Talk
Subject: ListContains NOT functioning properly - Help!
Help!
When I'm looping over a list Campaign.Vehicles that's coming from a SQL
table varchar field I'm getting strange results from ListContains.
Looping over Vehicles.cod=
"siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" - several rows
from
a database call.
Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a 'static'
database
record.
When Vehicles.code = "SiteSpin" the below
"ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4.
checked>
#Vehicles.Name#
Actual output to screen from testing:
Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
Vehicles.Code: siteSpin
ListContains - 4
As far as I can see from the output above siteSpin is only in the list
Campaign.Vehicles once. Can anybody see something I can't. I've tried
specifying the delimiter as a comma, changing the delimiter to a ~,
setting
the database field to a variable, changing the delimiters of that
variable
and I've tried all of those things with ListContainsNoCase as well.
I've
even tried changing the datatype of my SQL database field to nvarchar,
ntext
etc! Please help, this is holding up a very profitable ad campaign from
being served on my site!
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cgi.path_info
Everyone: Is there a setting in apache that would turn on/off the ability to read the cgi.path_info variable in Cold Fusion? The server is Linux Red Hat running CF 4.5. When I try to read the path info, I just get an empty string. Another server with the same setup returns the variable fine. Thanks. Joel F. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorry to flood the List BUT.... ListContains NOT functioning properly!
The function (ListContains) is doing exactly what it's suppose to and I
can
see why it's returning 4.
ListContains: Returns the index of the first item that contains a
specified
substring. The search is case-sensitive. If the substring is not found
in
the list items, it returns zero (0).
Hence, when it comes across the word (site) in the codes list it does
find
the (case-sensitive) word of (site) within your vehicles list. You may
want
to use listFind() instead.
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 1:59 PM
To: CF-Talk
Subject: Sorry to flood the List BUT ListContains NOT functioning
properly!
Sorry, but... Why does the below code check 4 boxes when there's only 3
items in the List???
Please help!!! This is costing my company a good deal of cash! - Just
copy
and paste the code into a test page and run it, you'll see, I hope.
checked>
#i#
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:32 PM
To: CF-Talk
Subject: ListContains NOT functioning properly - Help!
Help!
When I'm looping over a list Campaign.Vehicles that's coming from a SQL
table varchar field I'm getting strange results from ListContains.
Looping over Vehicles.cod=
"siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" - several rows
from
a database call.
Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a 'static'
database
record.
When Vehicles.code = "SiteSpin" the below
"ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4.
checked>
#Vehicles.Name#
Actual output to screen from testing:
Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
Vehicles.Code: siteSpin
ListContains - 4
As far as I can see from the output above siteSpin is only in the list
Campaign.Vehicles once. Can anybody see something I can't. I've tried
specifying the delimiter as a comma, changing the delimiter to a ~,
setting
the database field to a variable, changing the delimiters of that
variable
and I've tried all of those things with ListContainsNoCase as well.
I've
even tried changing the datatype of my SQL database field to nvarchar,
ntext
etc! Please help, this is holding up a very profitable ad campaign from
being served on my site!
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality."
Jules de Gaultier
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorry to flood the List BUT.... ListContains NOT functioning properly!
Mark,
You want to use ListFind(), not ListContains() in your example below.
ListContains() is going to return a position for "site" since "site" is
contained in "siteMinute", "siteNews", "site" and "siteSpin". ListFind()
will only find matching values. ListContains() will return a match if
the string being searched for is found within any part of the item of a
list.
-Dan
> -Original Message-
> From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 1:59 PM
> To: CF-Talk
> Subject: Sorry to flood the List BUT ListContains NOT functioning
> properly!
>
> Sorry, but... Why does the below code check 4 boxes when there's only
3
> items in the List???
> Please help!!! This is costing my company a good deal of cash! - Just
copy
> and paste the code into a test page and run it, you'll see, I hope.
>
>
>
>
>
>
> checked>
> #i#
>
>
> Mark Kecko
> The Computer Guy
> MediaPost Communications
> [EMAIL PROTECTED]
> http://www.mediapost.com
> (203)222-0330 ext309
>
> "Imagination is the one weapon in the war against reality."
> Jules de Gaultier
>
>
>
>
>
> -Original Message-
> From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 12:32 PM
> To: CF-Talk
> Subject: ListContains NOT functioning properly - Help!
>
>
> Help!
>
> When I'm looping over a list Campaign.Vehicles that's coming from a
SQL
> table varchar field I'm getting strange results from ListContains.
>
> Looping over Vehicles.code=
> "siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" - several
rows
> from
> a database call.
>
> Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a 'static'
> database
> record.
>
> When Vehicles.code = "SiteSpin" the below
> "ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4.
>
>
> "#Vehicles.Code#")>checked>
> #Vehicles.Name#
>
>
> Actual output to screen from testing:
> Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
> Vehicles.Code: siteSpin
> ListContains - 4
>
> As far as I can see from the output above siteSpin is only in the list
> Campaign.Vehicles once. Can anybody see something I can't. I've
tried
> specifying the delimiter as a comma, changing the delimiter to a ~,
> setting
> the database field to a variable, changing the delimiters of that
variable
> and I've tried all of those things with ListContainsNoCase as well.
I've
> even tried changing the datatype of my SQL database field to nvarchar,
> ntext
> etc! Please help, this is holding up a very profitable ad campaign
from
> being served on my site!
>
> Mark Kecko
> The Computer Guy
> MediaPost Communications
> [EMAIL PROTECTED]
> http://www.mediapost.com
> (203)222-0330 ext309
>
> "Imagination is the one weapon in the war against reality."
> Jules de Gaultier
>
>
>
>
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia's XML Resource Feed
You will need to use true XML parsing. There are tags in the Tag library that will do this. Most of them will create a structure, or an array of structures that you can look through and display. At 12:54 PM 3/5/2002 -0600, you wrote: >Hi, > >Has anyone used Macromedia's resource feed with CF located at > >http://www.macromedia.com/desdev/articles/xml_resource_feed.html > >How is it done? I've done XML parsing with Moreover's XML feeds using WDDX, >but this is different. Here's my feeble code: >>"http://www.macromedia.com/desdev/resources/macromedia_resources.xml";> > > > > > >The error is: > >unknown element encountered > >I know I'm probably way off in using WDDX to parse the xml doc here. Any >help here greatly appreciated. > >Thanks! >Andrew > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorry to flood the List BUT.... ListContains NOT functioning properly!
I think you may want to use ListFind instead. That will generate the
intended result, I believe. ListFind checks the entire list element
whereas ListContains looks at any part of a list element.
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 1:59 PM
To: CF-Talk
Subject: Sorry to flood the List BUT ListContains NOT functioning
properly!
Sorry, but... Why does the below code check 4 boxes when there's only 3
items in the List??? Please help!!! This is costing my company a good
deal of cash! - Just copy and paste the code into a test page and run
it, you'll see, I hope.
checked>
#i#
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality." Jules de
Gaultier
-Original Message-
From: Mark M. Kecko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:32 PM
To: CF-Talk
Subject: ListContains NOT functioning properly - Help!
Help!
When I'm looping over a list Campaign.Vehicles that's coming from a SQL
table varchar field I'm getting strange results from ListContains.
Looping over Vehicles.code=
"siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" - several rows
from a database call.
Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a 'static'
database record.
When Vehicles.code = "SiteSpin" the below
"ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4.
checked>
#Vehicles.Name#
Actual output to screen from testing:
Campaign.Vehicles: siteMinute,siteNews,site,siteSpin
Vehicles.Code: siteSpin
ListContains - 4
As far as I can see from the output above siteSpin is only in the list
Campaign.Vehicles once. Can anybody see something I can't. I've tried
specifying the delimiter as a comma, changing the delimiter to a ~,
setting the database field to a variable, changing the delimiters of
that variable and I've tried all of those things with ListContainsNoCase
as well. I've even tried changing the datatype of my SQL database field
to nvarchar, ntext etc! Please help, this is holding up a very
profitable ad campaign from being served on my site!
Mark Kecko
The Computer Guy
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309
"Imagination is the one weapon in the war against reality." Jules de
Gaultier
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rotating banners
I don't think this will work well Yes, you have listed the banner ID's in the proper percentage, but there is no guarantee that the random number will match that weighting. For instance, a random number generator could (in theory) produce "1,1,1,1,1,1,4,5,1,1". Now, if the ID at position 1 was weighted for 10%, they are really getting more than 10% in this case. The problem being that you can't rely on a random number to pick the weighted elements. A different option would be to maybe do like Ben mentioned below in creating a list or array of the elements, but randomly distribute the IDs within the Array (you've already determined how many there should be of each ID based on the weight). Then, you just need to loop through the list or array, showing the next element. This would result in the proper weighting, I think. Then again, I've never had to worry about rotating banners - but I'm normally good at finding holes in solutions (sorry Ben). Shawn Grover -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 11:35 AM To: CF-Talk Subject: Re: Rotating banners I would think that you would loop through your query, and build a list. For each query record, loop from 1 to the weight value, and add the bannerID to the a list called bannerIDList for each nested loop. This way if you have one banner with bannerID=301 and weight=2, and a second banner with bannerID=302 and weight=10, the list would look like: "301,301,302,302,302,302,302,302,302,302,302,302" Then you could pull a random ID from this list and run the query. >>> Elizabeth Walter <[EMAIL PROTECTED]> 03/05/02 01:14PM >>> Hello- I am developing a banner rotating tool and need some ideas on how to best handle a requirement. I have gotten the tool to a point where it displays banners randomly- no problem. Now what I need to do is give certain banners more "weight" than others: some banners need to be displayed more frequently than the rest. The code that I have below gives equal weight to each banner; I need to find a way to give some banners more prevalence on our pages. SELECT i.*, a.advert_name FROM images i, advertiser a WHERE i.id = #activeBanners[randomId]# and i.advert_id = a.advert_id Any ideas? Thanks in advance, Elizabeth __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFApplication
I would use the Brian Kotek's customtag called cf_clienttimeout and you wouldn't have to pass the CFID/CFTOKEN around. Then -Original Message- From: Graham Pearson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:20 PM To: CF-Talk Subject: CFApplication From what I have understood, CFAPPLICATION by default will not expire client variables on browser close. I have clientmanagement turned on session management turned off, client storage to an odbc datasource and set client cookies turned off. What I am trying to do is pass CFID and CFTOKEN on each link, but want to test for this value and if the CGLOBAL.LVISIT from the client storage tables is greater than 10 minutes then redirect them back to the main index.cfm page. Any Ideas --- Graham Pearson, System Administrator / Webmaster Northern Indiana Educational Services Center Http://support.niesc.k12.in.us Email: [EMAIL PROTECTED] Voice (800) 326-5642 or (219) 254-0111 Fax (219) 254-0148 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia's XML Resource Feed
Andrew, First, i am glad you noticed the feed. It just went live yesterday. second, it is not a WDDX XML document (just XML). you can view the DTD here: http://www.macromedia.com/desdev/resources/macromedia_resources.xml"/ basically, you will need to use a COM or Java XML parser with CF 5 and parse the data. Of course, you can abstract all of the parsing away in a custom tag. (note, that the DTD is not linked in the document, so make sure when you parse you do not try to validate it). does that help? let me know if you have any other questions... mike chambers [EMAIL PROTECTED] > -Original Message- > From: Andrew Peterson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 1:54 PM > To: CF-Talk > Subject: Macromedia's XML Resource Feed > > > Hi, > > Has anyone used Macromedia's resource feed with CF located at > > http://www.macromedia.com/desdev/articles/xml_resource_feed.html > > How is it done? I've done XML parsing with Moreover's XML > feeds using WDDX, but this is different. Here's my feeble code: > > "http://www.macromedia.com/desdev/resources/ma> cromedia_resources.xml"> > > > > output="MacroNews"> > > The error is: > > unknown element encountered > > I know I'm probably way off in using WDDX to parse the xml > doc here. Any help here greatly appreciated. > > Thanks! > Andrew > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia's XML Resource Feed
So the question is why not WDDX? Neil - Original Message - From: "Mike Chambers" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 2:08 PM Subject: RE: Macromedia's XML Resource Feed > Andrew, > > First, i am glad you noticed the feed. It just went live yesterday. > > second, it is not a WDDX XML document (just XML). you can view the DTD > here: > > http://www.macromedia.com/desdev/resources/macromedia_resources.xml"/ > > basically, you will need to use a COM or Java XML parser with CF 5 and > parse the data. Of course, you can abstract all of the parsing away in a > custom tag. (note, that the DTD is not linked in the document, so make > sure when you parse you do not try to validate it). > > does that help? let me know if you have any other questions... > > mike chambers > > [EMAIL PROTECTED] > > > -Original Message- > > From: Andrew Peterson [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 05, 2002 1:54 PM > > To: CF-Talk > > Subject: Macromedia's XML Resource Feed > > > > > > Hi, > > > > Has anyone used Macromedia's resource feed with CF located at > > > > http://www.macromedia.com/desdev/articles/xml_resource_feed.html > > > > How is it done? I've done XML parsing with Moreover's XML > > feeds using WDDX, but this is different. Here's my feeble code: > > > > > "http://www.macromedia.com/desdev/resources/ma> > cromedia_resources.xml"> > > > > > > > > > output="MacroNews"> > > > > The error is: > > > > unknown element encountered > > > > I know I'm probably way off in using WDDX to parse the xml > > doc here. Any help here greatly appreciated. > > > > Thanks! > > Andrew > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multi Processor Server Config
> In win2k, i dont remember exactly where it is, you can assign > certain processes to a processor manually. Yes, you can, but usually you don't want to. To do this, you need to download a separate tool from MS, if I recall correctly. Or maybe it's in a resource kit. In my experience, however, this hasn't been necessary for optimal CF performance - you're better off letting the OS handle this rather than binding processes to specific CPUs. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
