remote site MySQL or local Access?
Hi all, I have a non-profit site that I look after. It used to be all manually updated HTML but they are looking at expanding it a bit and I'd like to transfer some of the updating from myself to the committee members. As they are not well-funded, at the moment I'm thinking of using frames, hosting the CF elements of the site on CFM-Resources (the free account to start with, although I would consider paying the one of the other options myself later on if it was going to be more reliable) and the static pages/framesets on their donated Australian university hosting space and domain name. (The domain name is a subdomain of the university's and is quite well known to their audience, so they can't change it or move it elsewhere, before someone suggests that). With regards to the database I have two options that I can see: use the Access dsn that is part of the CFM-Resources account, or use MySQL which is installed on the Linux web server at the Australian university. I'm not sure if MySQL is actually all that much better than Access (the traffic on the site is really low, about 10-15 visitors per day at the moment) or if accessing a remote database would be too slow (and is it even possible?). Does anyone forsee any major flaws in my master plan or have any recommendations? Suggestions please! Thanks, Kay. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help please
Hi gang, Iam a Cf guy since 1.5 years.I changed my company expecting a assignment in US.As the market slowed down there,my new employer is making me sit at his place. The problem is that he don't have any CF work and the other teams wont allow me inside their domain. Should i stick with CF or change to some other domain?Whats the trend at US? Can someone suggest a way out until the US markets gear up again? Expecting some serious suggestions. Thank you. Ramakrishna ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: remote site MySQL or local Access?
From: Garza, Jeff [mailto:[EMAIL PROTECTED]] What server are they running on? Unix, WinNT ??? This sounds like it might be best to look at a different tool. Perhaps Perl on Unix or ASP on NT... Perl running the DBI for MySQL cranks! Just a thought. They are running Linux... apart from that I don't really know. About four months ago they promised to install PHP on the box for me but they claim they are having difficulties getting it installed and don't have enough time to sort it out. I was willing to learn a little PHP but as it's way overdue now and I don't get any money from it I think it would be best to stick with what I know, which is CF. If you decide to go ahead with it, you'll be better off using the Access DSN on CFM-Resources. The performance hit of going across the pond multiple times would probably be too much. I've stored hundreds of tables in a single access DB. Shouldn't be too much of a problem. That was kinda what I was thinking... it's just that there are so many horror stories about using Access that I was a little reluctant to trust it. What about CFM-resources.com? I realise that with free hosting you get what you pay for, but CF hosting in Australia is ridiculously expensive compared to what I've seen in the US. I was thinking I could start out on the free account and if it all works out well and I can convince someone to pay for it, upgrade to a paid account later. Does anyone have any experience with their paid hosting? Is it any more reliable than the free? And if not, are there any other "budget" CF hosts out there I might consider? Thanks again, K. Original Message- From: Kay Smoljak To: CF-Talk Sent: 3/22/01 10:52 PM Subject: remote site MySQL or local Access? Hi all, I have a non-profit site that I look after. It used to be all manually updated HTML but they are looking at expanding it a bit and I'd like to transfer some of the updating from myself to the committee members. As they are not well-funded, at the moment I'm thinking of using frames, hosting the CF elements of the site on CFM-Resources (the free account to start with, although I would consider paying the one of the other options myself later on if it was going to be more reliable) and the static pages/framesets on their donated Australian university hosting space and domain name. (The domain name is a subdomain of the university's and is quite well known to their audience, so they can't change it or move it elsewhere, before someone suggests that). With regards to the database I have two options that I can see: use the Access dsn that is part of the CFM-Resources account, or use MySQL which is installed on the Linux web server at the Australian university. I'm not sure if MySQL is actually all that much better than Access (the traffic on the site is really low, about 10-15 visitors per day at the moment) or if accessing a remote database would be too slow (and is it even possible?). Does anyone forsee any major flaws in my master plan or have any recommendations? Suggestions please! Thanks, Kay. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Need some parsing help
Should I go through the route of len and right functions to accomplish the following. I have a email adress. ([EMAIL PROTECTED]) I want to parse just the domain and return juanvaldez.com THen insert it into a field. Should I Find the char of @ then get the len of the string (21) Then grab fron the @ (5) to 61 for the len og 16 then insert it? Any other ideas? -brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I get NT user name into CGI_AUTH_USER
Thanks John and Jeff that was it. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 17:03 To: CF-Talk Subject: RE: How do I get NT user name into CGI_AUTH_USER Check in IIS. When I've wanted to capture NT Usernames I've had to turn off "anonymous access" in IIS so that it records the nt information. I'm not sure about in internet sites, my experience was with an intranet app, but that might help you some. J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer Office: 909-943-8428 www.red-omega.com http://www.red-omega.com 15 people are known to have been crushed to death tilting soda machines towards them in order to receive free soda. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:48 AM To: CF-Talk Subject: How do I get NT user name into CGI_AUTH_USER Where do I go to do this. I've inherited a site that uses it, which I've copied to a development server. On the live site AUTH_TYPE=NTLM AUTH_USER=ntusername whereas it is empty on the dev server. I'm using NT4 CF4.5 and the IIS that comes with Option pack 4. Thanks ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Need some parsing help
Just use cfset domain = ListLast(String,"@") since you don't know how many letters will be before the @. Sincirely Tom Espen Pedersen developer @ www.pixelduck.com [EMAIL PROTECTED] - Original Message - From: "Brian Thornton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 8:36 AM Subject: Need some parsing help Should I go through the route of len and right functions to accomplish the following. I have a email adress. ([EMAIL PROTECTED]) I want to parse just the domain and return juanvaldez.com THen insert it into a field. Should I Find the char of @ then get the len of the string (21) Then grab fron the @ (5) to 61 for the len og 16 then insert it? Any other ideas? -brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Need some parsing help
Stuff like this with one delimiter, I go the lazy way ;-) #listlast(emailAddress,"@") # That should do the trick, without getting into too much code. jon - Original Message - From: "Brian Thornton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 2:36 AM Subject: Need some parsing help Should I go through the route of len and right functions to accomplish the following. I have a email adress. ([EMAIL PROTECTED]) I want to parse just the domain and return juanvaldez.com THen insert it into a field. Should I Find the char of @ then get the len of the string (21) Then grab fron the @ (5) to 61 for the len og 16 then insert it? Any other ideas? -brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: remote site MySQL or local Access?
Well certainly on the $5.99 account you get what you pay for... It doesn't seem to go down quite as much as the free sites, maybe twice a month? Not good... but still good value... Depends how critical the site is - For a small charity site etc Id say it was reasonable... -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 07:21 To: CF-Talk Cc: Garza, Jeff Subject: RE: remote site MySQL or local Access? From: Garza, Jeff [mailto:[EMAIL PROTECTED]] What server are they running on? Unix, WinNT ??? This sounds like it might be best to look at a different tool. Perhaps Perl on Unix or ASP on NT... Perl running the DBI for MySQL cranks! Just a thought. They are running Linux... apart from that I don't really know. About four months ago they promised to install PHP on the box for me but they claim they are having difficulties getting it installed and don't have enough time to sort it out. I was willing to learn a little PHP but as it's way overdue now and I don't get any money from it I think it would be best to stick with what I know, which is CF. If you decide to go ahead with it, you'll be better off using the Access DSN on CFM-Resources. The performance hit of going across the pond multiple times would probably be too much. I've stored hundreds of tables in a single access DB. Shouldn't be too much of a problem. That was kinda what I was thinking... it's just that there are so many horror stories about using Access that I was a little reluctant to trust it. What about CFM-resources.com? I realise that with free hosting you get what you pay for, but CF hosting in Australia is ridiculously expensive compared to what I've seen in the US. I was thinking I could start out on the free account and if it all works out well and I can convince someone to pay for it, upgrade to a paid account later. Does anyone have any experience with their paid hosting? Is it any more reliable than the free? And if not, are there any other "budget" CF hosts out there I might consider? Thanks again, K. Original Message- From: Kay Smoljak To: CF-Talk Sent: 3/22/01 10:52 PM Subject: remote site MySQL or local Access? Hi all, I have a non-profit site that I look after. It used to be all manually updated HTML but they are looking at expanding it a bit and I'd like to transfer some of the updating from myself to the committee members. As they are not well-funded, at the moment I'm thinking of using frames, hosting the CF elements of the site on CFM-Resources (the free account to start with, although I would consider paying the one of the other options myself later on if it was going to be more reliable) and the static pages/framesets on their donated Australian university hosting space and domain name. (The domain name is a subdomain of the university's and is quite well known to their audience, so they can't change it or move it elsewhere, before someone suggests that). With regards to the database I have two options that I can see: use the Access dsn that is part of the CFM-Resources account, or use MySQL which is installed on the Linux web server at the Australian university. I'm not sure if MySQL is actually all that much better than Access (the traffic on the site is really low, about 10-15 visitors per day at the moment) or if accessing a remote database would be too slow (and is it even possible?). Does anyone forsee any major flaws in my master plan or have any recommendations? Suggestions please! Thanks, Kay. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfscheduler weird thing...
coldfusion scheduling is notoriuosly unreliable. I've recreating these symptoms over and over, and followed various threads in the allaire forums about it, but never seen a straight answer. I suspect it's nothing to do with CF per se, that it's something set in windows somewhere which causes the cfscheduler not to work on some servers - but I've no idea where/what that setting is. (never tried using CFSCHEDULE on linux) If you want to be sure you're code will work, use the scheduling service built into the OS (NT 'at' or Linux 'cron'). There are some custom tags available to make using these as easy as using CFSCHEDULE. I think there is actually a CFX_SCHEDULE. Mark At 12:03 AM 3/23/2001, you wrote: I got a scheduler website where users can set some meeting and having a feature to be notified by email at a specific time. What i've do, is creating a new task with cfschedule to be executed one time at a specific date. Everything work fine except one thing : the cf server doesn't see my new task untill i edit/update it via cf panel. (so it's manually) Someone know why? My interval refresh is set to 5 minutes.. i've made some tests and was checking the schedule log files, and that's how i explain this trouble : i think there is something more under the cf automated task panel when editing a task that i doesn't have when using cfschedule tag.. any ideas? Daive [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Survey: Web-based WYSIWIG editing tool
5) Other - IE5 (though IE5.5 has more granular object control) Hi All, Just a quick survey to appease my curiosity... If you use a web-based WYSYWIG editing tool, what do you use? 1) ActiveEdit (www.cdev.com) 2) eWebEditPro (www.ektron.com) 3) ezEdit (www.siteobjects.com) 4) HTMLArea (www.iautomated.com/products) 5) Other I am currently using ActiveEdit, and am curious as to what others are using. Thanks, Cameron Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Textbox validation
the BEST way to do it is to use javascript validation, and if it doesn't meet your criteria, popup a message and focus on that field. that's it :) If the user has JavaScript disabled, simply implementing client-side validation wouldn't catch errors. If you're *only* going to implement one method and cannot dictate what browser a client should use or it's settings (as in an Intranet), it *has* to be ColdFusion validation. If you've got time left over on the project, go back through your application and add in the JavaScript as a courtesy. The most complete solution would be to use JavaScript initially and then re-validate the data when it's been returned to the server. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio: Export RDS Settings?
It's just registry stuff. Open RegEdit, browse to HKEY_CURRENT_USER/Software/Allaire/RemoteServers, and with RemoteServers highlighted, go to Registry -- Export. This will save a .reg file, which you can run on the new machine. Ahhh, thanks for the info! Now I feel like a klutz... ;-) -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscheduler weird thing...
coldfusion scheduling is notoriuosly unreliable. Does anyone know if this is going to be addressed in ColdFusion 5.0? I've *never* managed to get a scheduled event to work and have to resort to other applications which trigger batch files to open a browser and pass it a URL as a parameter... pain! -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Textbox validation
You should use javascript, that way the page does not have to get submitted for the validation to occur. Just have the onChange event for the box call a function that parses the value of the text box for spaces or whatever. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 7:39 PM To: CF-Talk Subject: Textbox validation Hi, On one textbox I need to prohibit users entering more than one word - I don't want them to enter a space. What's the best way of doing this - Javascript, or Cold Fusion after the form has been posted? Thanks. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Textbox validation
Really the best way is *both*. JavaScript is much nicer from a user interface point of view. But if the validation is important you need to do it again on the server, because you can't guarantee the user has JavaScript running in their browser. Nick -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 12:39 AM To: CF-Talk Subject: Textbox validation Hi, On one textbox I need to prohibit users entering more than one word - I don't want them to enter a space. What's the best way of doing this - Javascript, or Cold Fusion after the form has been posted? Thanks. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Survey: Web-based WYSIWIG editing tool
Yes, Spectra 1.5 does come with eWebEditPro integrated. Lanny Udey Hofstra University [EMAIL PROTECTED] Friday, March 23, 2001 Mark Ireland wrote: I heard it will come with the new Macromedia Spectra (start getting used to it) Can anyone confirm this? I'm just in the process of developing a site that will use a web based HTML editor and if this is the case I may need to explore eWebEditPro as I am currently using ezEdit -- If it turns out that there is a God, I don't think that he's evil. But the worst that you can say about him is that basically he's an underachiever. Woody Allen email: [EMAIL PROTECTED] web: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Any LDAP Guru's here? Authentication Problem
quick question. i want to use NDS LDAP to authenticate ALL the users of our intranet. my problem that there are 2 servers. both have the same tree name? will this cause me problems. if so is there a way around it? any ideas would be great -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE ACTION=copy and NAMECONFLICT
I'm using CFFILE to copy a file from one directory to another on the server. What happens if the file already exists? It's telling me that I can't use the NAMECONFLICT attribute when the ACTION is "copy": Attribute set validation error in tag CFFILE The tag has an invalid attribute combination: the value of the tag switch attribute 'ACTION' which is now 'COPY' requires a different combination of attributes. For the same switch attribute value the following unknown attributes have been provided: (NAMECONFLICT). Does it just automatically overwrite the file in the destination folder? Have I got to use CFTRY and CATCH instead? Seems nuts not to have this built into the CFFILE tag directly... -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Calling Custom Tags in CFSCRIPT
Hi All, In CF Version 4.5 is it possible to call a custom Tag from with in a CFScript block EG cfif x gt 1 cf_Foo In="x" out="y" /cfif cfoutputthe x^2 = #y#/cfoutput How would you convert the CF_Foo into the cfscript block? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscheduler weird thing...
I've *never* managed to get a scheduled event to work and have to resort to other applications which trigger batch files to open a browser and pass it a URL as a parameter... pain! err, there's no need to do that. There is an executable you can use to process CFML templates via the command line. Have a look at: http://www.allaire.com/Handlers/index.cfm?ID=3328Method=Full Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calling Custom Tags in CFSCRIPT
How would you convert the CF_Foo into the cfscript block? You can't. :| You can't use any cf tags within cfscript One of the many limitations of cfscript - which is a shame. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, 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: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 12:59 To: CF-Talk Subject: Calling Custom Tags in CFSCRIPT Hi All, In CF Version 4.5 is it possible to call a custom Tag from with in a CFScript block EG cfif x gt 1 cf_Foo In="x" out="y" /cfif cfoutputthe x^2 = #y#/cfoutput How would you convert the CF_Foo into the cfscript block? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calling Custom Tags in CFSCRIPT
No. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 12:59 To: CF-Talk Subject: Calling Custom Tags in CFSCRIPT Hi All, In CF Version 4.5 is it possible to call a custom Tag from with in a CFScript block EG cfif x gt 1 cf_Foo In="x" out="y" /cfif cfoutputthe x^2 = #y#/cfoutput How would you convert the CF_Foo into the cfscript block? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calling Custom Tags in CFSCRIPT
I thought as much but just wanted to make sure I'd not missed an undocumented feature. Roll on CF5.0! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 12:51 To: CF-Talk Subject: RE: Calling Custom Tags in CFSCRIPT How would you convert the CF_Foo into the cfscript block? You can't. :| You can't use any cf tags within cfscript One of the many limitations of cfscript - which is a shame. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, 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: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 12:59 To: CF-Talk Subject: Calling Custom Tags in CFSCRIPT Hi All, In CF Version 4.5 is it possible to call a custom Tag from with in a CFScript block EG cfif x gt 1 cf_Foo In="x" out="y" /cfif cfoutputthe x^2 = #y#/cfoutput How would you convert the CF_Foo into the cfscript block? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscheduler weird thing...
From past experience with CFSchedule, make sure the website/template that is being called (ie, http://mywebsite.com/check_this.cfm ) is not located on an non-standard port. Meaning the template should be able to be called from a normal HTTP Request. If it is behind an obscure port such as: http://mywebsite.com:8088/check_this.cfm This will not work. Hopefully this is addressed in CF 5.0 but not the case in 4.01 or 4.5 Hope this helps. Randy -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 7:31 AM To: CF-Talk Subject: RE: cfscheduler weird thing... coldfusion scheduling is notoriuosly unreliable. Does anyone know if this is going to be addressed in ColdFusion 5.0? I've *never* managed to get a scheduled event to work and have to resort to other applications which trigger batch files to open a browser and pass it a URL as a parameter... pain! -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS packages
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 There's also some great example code at www.cfcomet.com under SQL Server on how to do it with CFOBJECT and COM. We've used it pretty extensively here since CFEXECUTE and xp_cmdshell are highly secured processes in our environment (anal-retentive and paranoid sysadmins, I guess ;) :) Joe Joseph Cruz Wharton Computing and Information Technology Programmer/Analyst 3620 Locust Walk Suite 400 SH-DH Philadelphia, PA 19104-6302 [EMAIL PROTECTED] 215-898-1220(w) 215-573-2798(f) 215-308-0657(p) 215-768-2071(m) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 11:13 PM To: CF-Talk Subject: RE: DTS packages cfexecute dtsrun.exe "package name" or you can run a stored porcedure which will do this. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:39 PM To: CF-Talk Subject: DTS packages Does anyone know if it is possible to call a dts package on command? If so what is the code? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
template and thread...
Hi, does anyone know that how template behavior? My question is: when I have a bunch of CFInclude template="../includes/1.cfm" CFInclude template="../includes/2.cfm" CFInclude template="../includes/3.cfm" .. .. CFInclude template="../includes/N.cfm" are the CF process in the 1/2/3 order? or they process everything ( 1/2/ ... N ) at the same time ? according to what I understand, it should be in order, but my page behavior funny, e.g. 3.cfm depends on the result of 1.cfm, sometimes it works, sometimes it tells me that the result is empty... Please confirm with me for that. Thank you. Mei ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Auctions
Hi, I'm looking to develop an auction section on our current site, and I've been looking through the dozens of options in the developers gallery. If anyone has experiences (good or bad!) with using auctions, I'd like to hear them. Thanks, Fiachra. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Survey: Web-based WYSIWIG editing tool
5) Other :: Ultra Dev! -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: Cameron [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 10:43 PM To: CF-Talk Subject: Survey: Web-based WYSIWIG editing tool Hi All, Just a quick survey to appease my curiosity... If you use a web-based WYSYWIG editing tool, what do you use? 1) ActiveEdit (www.cdev.com) 2) eWebEditPro (www.ektron.com) 3) ezEdit (www.siteobjects.com) 4) HTMLArea (www.iautomated.com/products) 5) Other I am currently using ActiveEdit, and am curious as to what others are using. Thanks, Cameron Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Textbox validation
Thanks for all the replies. The reason I need to prevent more than one word being entered, is I'm finding it impossible to use wildcard filtering using Access' Instr function (any clues anyone?) - for example, if the search string contained "Bass Guitar" it would only return True if it *matches* it, and not if it's similar (Like). Anyways, thanks - going to do what Aidan suggests, and add the Javascript when I have time. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com Really the best way is *both*. JavaScript is much nicer from a user interface point of view. But if the validation is important you need to do it again on the server, because you can't guarantee the user has JavaScript running in their browser. Nick -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 12:39 AM To: CF-Talk Subject: Textbox validation Hi, On one textbox I need to prohibit users entering more than one word - I don't want them to enter a space. What's the best way of doing this - Javascript, or Cold Fusion after the form has been posted? Thanks. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RDS problem solved
Hi all Finally I solved the problem. It wasn't possible to delete the RDSs right clicking and deleting in the file manager. I had to go to the windows register and look for the keys which correspond to each RDS server I've created. These keys include all the settings I've done in CFStudio. I removed them and voila... Thank you very much for your help Bye Manuel _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: template and thread...
I'm pretty sure it is in order, so variables you set in 1 are available in 2. Try that and see. At 01:17 PM 3/23/2001, you wrote: Hi, does anyone know that how template behavior? My question is: when I have a bunch of CFInclude template="../includes/1.cfm" CFInclude template="../includes/2.cfm" CFInclude template="../includes/3.cfm" .. .. CFInclude template="../includes/N.cfm" are the CF process in the 1/2/3 order? or they process everything ( 1/2/ ... N ) at the same time ? according to what I understand, it should be in order, but my page behavior funny, e.g. 3.cfm depends on the result of 1.cfm, sometimes it works, sometimes it tells me that the result is empty... Please confirm with me for that. Thank you. Mei ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
determine if user is active?
My bank disconnects me after 5 minutes, how can I reproduce this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE ACTION=copy and NAMECONFLICT
Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag? Steve -- Stephen Galligan ColdFusion Developer Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 12:57 To: CF-Talk Subject: CFFILE ACTION="copy" and NAMECONFLICT I'm using CFFILE to copy a file from one directory to another on the server. What happens if the file already exists? It's telling me that I can't use the NAMECONFLICT attribute when the ACTION is "copy": Attribute set validation error in tag CFFILE The tag has an invalid attribute combination: the value of the tag switch attribute 'ACTION' which is now 'COPY' requires a different combination of attributes. For the same switch attribute value the following unknown attributes have been provided: (NAMECONFLICT). Does it just automatically overwrite the file in the destination folder? Have I got to use CFTRY and CATCH instead? Seems nuts not to have this built into the CFFILE tag directly... -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
server.log error
Hi. What would cause this error? Is it written when CF times out after trying to connect to a datasource? Or is it something else? TIA "Error","TID=150","03/21/01","21:10:39","Unable to write reply -- timed out writing data back to web server." "Error","TID=150","03/21/01","21:10:39","Windows NT error number 1460 occurred." -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: determine if user is active?
Body onLoad settimeout (5 minutes worth of milliseconds) when that timeout has been reached have the session end, window close or whatever -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 8:35 AM To: CF-Talk Subject: determine if user is active? My bank disconnects me after 5 minutes, how can I reproduce this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: determine if user is active?
If you mean what I think you mean - you do know you posted to the CF-Talk and not the bank's complaints email? ;) - then you need to use session or client variables (the former is likely to be more relevant) - you can set a local timeout in your Application.cfm with the following code: cfapplication name="Whatever" sessionmanagement="yes" sessiontimeout="#createtimespan(0,0,5,0)#" Where the timespan function is (day,hour,minute,second) HTH James "The Force is strong in this one..." - Darth Vader -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 13:35 To: CF-Talk Subject: determine if user is active? My bank disconnects me after 5 minutes, how can I reproduce this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfscheduler weird thing...
mmmh do you know how to make it work without opening a IE "window" with AT ? :) that's my only trouble with that hehe daive - Original Message - From: "Mark Woods" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 3:10 AM Subject: Re: cfscheduler weird thing... coldfusion scheduling is notoriuosly unreliable. I've recreating these symptoms over and over, and followed various threads in the allaire forums about it, but never seen a straight answer. I suspect it's nothing to do with CF per se, that it's something set in windows somewhere which causes the cfscheduler not to work on some servers - but I've no idea where/what that setting is. (never tried using CFSCHEDULE on linux) If you want to be sure you're code will work, use the scheduling service built into the OS (NT 'at' or Linux 'cron'). There are some custom tags available to make using these as easy as using CFSCHEDULE. I think there is actually a CFX_SCHEDULE. Mark At 12:03 AM 3/23/2001, you wrote: I got a scheduler website where users can set some meeting and having a feature to be notified by email at a specific time. What i've do, is creating a new task with cfschedule to be executed one time at a specific date. Everything work fine except one thing : the cf server doesn't see my new task untill i edit/update it via cf panel. (so it's manually) Someone know why? My interval refresh is set to 5 minutes.. i've made some tests and was checking the schedule log files, and that's how i explain this trouble : i think there is something more under the cf automated task panel when editing a task that i doesn't have when using cfschedule tag.. any ideas? Daive [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfloop
Hi all, I,m not sure if you can nest cfloop but I'm not getting any errors but the desired result is not working. This is my code, cfloop index="item" list="#form.callsign#" cfquery name="qry_getvehicle" datasource="#application.dsn#" username="#application.gateway#" password="#application.key#" SELECT callsign, vowner, dt, Lat, Lon, Speed, Direction, Veh_Reg FROMdbo.vehicles WHERE vowner = 224 /cfquery /cfloop cfset start = 1 cfset max = qry_getvehicle.recordCount cfparam name="icon" default="" cfloop index="Loopcount" from="#start#" to="#max#" cfif Loopcount eq max cfset icon = "xhair" cfelse cfset icon = "target" /cfif cfset allCars = "" cfloop query="qry_getvehicle" startrow="#start#" endrow="#max#" cfif allCars neq "" cfset allCars = allCars ";" /cfif cfset allCars = replace(allCars #qry_getvehicle.lon# "," #qry_getvehicle.lat# ",#icon#," #qry_getvehicle.callsign#," ","","ALL") /cfloop /cfloop What I am trying to do is on the last loop set my icon to a crosshair image, else set it to a target. I thought by nesting my loop this would have worked. I suppose I should be doing a 'while condition' within the cfloop instead, but I'm not too sure. If anyone could help me on this I'd appreciate, thanx in advance.. JMC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMail replacement for Linux
Thanks for some good ideas all. The issue is that the client has a dynamic form that lets them generate e-mail lists on the fly by matching a number of profile options. The email lists can vary from 10 - 10,000 addresses depending. So, something like majordomo won't work too well. We looked at using SQL Server's mailer, but it was not clear how to add custom headers like content-type: text/html or content-type: multipart/choice. I was hoping there would be a cfx_mail-type replacement that would work on Linux. What we have now is CF formats the message bodies in HTML and text format, and passes the address list and other message data to a java class. The java class sends the mail directly into sendmail over a standard telnet socket. It works, but we had to add a 'sleep' period between calls - it was overrunning sendmail - so now it's slow. Ah well, speed or stability - that is the question :-) Thanks again for all the good suggestions. Jeff -Original Message- From: Richard Kuryk [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:06 PM To: CF-Talk Subject: RE: CFMail replacement for Linux not running linux but why can't you just execute mail with your email text and let sendmail kickit off just like a perl script would do? cfexecute name="mail" Rich -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 1:18 PM To: CF-Talk Subject: CFMail replacement for Linux Does anyone know of a CFMail replacement that will run on Linux? We need to allow a client to send 10,000 plus e-mails in one shot, possibly several times a day. CFMail (on their server) handles about 3,000 with little trouble, but above that, threads start hanging, the server restarts over and over, and of course, we lose all the sessions, etc. If I can't find a replacement I think I'll have to write the message bodies and addresses to temp tables and send them in batches every x minutes.. anyone have a better solution? Thanks, Jeff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ORACLE Native Driver Bug?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all. By way of background, we've created an application that keeps tracks of a user's click stream within a site. We've run into a curious problem; when the following query is executed in Cold Fusion Ent 4.5.1 SP2 on Win2K SP1, CF's memory usage explodes and eventually crashes the server (usage hovers around 250MB and then jumps to 1.8GB, paging starts to occur, and then we're out of virtual memory and a hard reboot is necessary). However, if we execute the query against a Microsoft ODBC for ORACLE data source, it runs without a hitch. If anyone is willing or able to test this particular scenario on their DEVELOPMENT servers (watch them carefully; the CF Server's memory is gobbled up in 50MB chunks) so we can gather more data points, that would be great! Thanks a lot in advance! Joe We've isolated a single recordset that causes this to crash; other recordsets don't seem to effect in the same way. Here are the details: ERRANT QUERY: = SELECT page_id, min(click_sequence) as click_sequence, (sum(time_end - time_start)*24*60*60) as total_time FROM learnlab.click_detail_1415 WHEREsession_id = '1415' ANDtime_end is not null GROUP BY page_id UNION SELECT page_id, min(click_sequence), 0 as total_time FROM learnlab.click_detail_1415 WHERE session_id = '1415' AND time_end is null GROUP BY page_id TABLE DESCRIPTION: === Column NameNull?Type - -- SESSION_ID NOT NULL NUMBER(5) PAGE_IDNOT NULL VARCHAR2(10) CLICK_SEQUENCE NOT NULL NUMBER(5) TIME_START NOT NULL DATE TIME_ENDDATE PREV_PAGE_IDVARCHAR2(10) NEXT_PAGE_IDVARCHAR2(10) INTRO_FLAG CHAR(1) TABLE CONTENTS: === SESSION_ID PAGE_IDCLICK_SEQU TIME_START TIME_END PREV_PAGE_ NEXT_PAGE_ I - -- -- -- - -- -- - 1415 CATEGORIES 18 17-MAR-0117-MAR-01 INTROPROD FUTNWCOV N 1415 CATEGORIES 53 17-MAR-0117-MAR-01 INTROPROD INTERVIEWS N 1415 CATEGORIES 55 17-MAR-0117-MAR-01 INTERVIEWS INTERVIEWS N 1415 CATEGORIES 59 17-MAR-0117-MAR-01 INTERVIEWS REVIEWSN 1415 CATEGORIES 61 17-MAR-0117-MAR-01 REVIEWSMAINMENU3 N 1415 CATEGORIES 64 17-MAR-0117-MAR-01 INTROPROD INTERVIEWS N 1415 CATEGORIES 76 17-MAR-0117-MAR-01 INTPOINT INTERVIEWS N 1415 CATEGORIES 83 17-MAR-0117-MAR-01 INTERVIEWS INTERVIEWS N 1415 CATEGORIES 91 17-MAR-0117-MAR-01 INTERVIEWS REVIEWSN 1415 CATEGORIES 97 17-MAR-0117-MAR-01 REVIEWSPRINT N 1415 CATEGORIES119 17-MAR-0117-MAR-01 PRINT REVIEWSN 1415 CATEGORIES121 17-MAR-0117-MAR-01 REVIEWSPRINT N 1415 CATEGORIES125 17-MAR-0117-MAR-01 PRINT REVIEWSN 1415 CATEGORIES129 17-MAR-0117-MAR-01 REVIEWSWEBINFON 1415 CATEGORIES138 17-MAR-0117-MAR-01 WEBINFOTVADS N 1415 CATEGORIES145 17-MAR-0117-MAR-01 TVADS MAINMENU3 N 1415 CATEGORIES148 17-MAR-0117-MAR-01 INTROPROD INTROEXIT N 1415 FUTACCID 12 17-MAR-0117-MAR-01 FUTCALIF FUTKILLER N 1415 FUTACCID 47 17-MAR-0117-MAR-01 FUTCALIF FUTKILLER N 1415 FUTCALIF 11 17-MAR-0117-MAR-01 FUTEASTFUTACCID N 1415 FUTCALIF 46 17-MAR-0117-MAR-01 FUTEASTFUTACCID N 1415 FUTEAST10 17-MAR-0117-MAR-01 FUTOPENS FUTCALIF N 1415 FUTEAST45 17-MAR-0117-MAR-01 FUTOPENS FUTCALIF N 1415 FUTEXPENSE 14 17-MAR-0117-MAR-01 FUTKILLER FUTNETWORK N 1415 FUTEXPENSE 49 17-MAR-0117-MAR-01 FUTKILLER FUTNETWORK N 1415 FUTINTRO6 17-MAR-0117-MAR-01 INTROTOC FUTNWCOV N 1415 FUTKILLER 13 17-MAR-0117-MAR-01 FUTACCID FUTEXPENSE N 1415 FUTKILLER 48 17-MAR-0117-MAR-01 FUTACCID FUTEXPENSE N 1415 FUTNETWORK
Re: DTS packages
Thanks! cfexecute dtsrun.exe "package name" or you can run a stored porcedure which will do this. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:39 PM To: CF-Talk Subject: DTS packages Does anyone know if it is possible to call a dts package on command? If so what is the code? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find position in a list
Use listFind(list [, delimiter]) HTH, Duane -Original Message- From: James Maltby [mailto: Sent: Friday, March 23, 2001 9:28 AM To: CF-Talk Subject: Find position in a list Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find position in a list
You need GetToken() to get the next/previous values once you get the position of the original substring. --Dylan -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 6:34 AM To: CF-Talk Subject: RE: Find position in a list Use listFind(list [, delimiter]) HTH, Duane -Original Message- From: James Maltby [mailto: Sent: Friday, March 23, 2001 9:28 AM To: CF-Talk Subject: Find position in a list Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find position in a list
James, Try this cfset list="23,24,27,30,543,675,980" !--- current_number would be dynamic, right now it's set to 543 --- cfset current_number=543 cfset position=ListFind(list,current_number) cfloop list="#list#" index="count" cfset previous_number=ListGetAt(list,position-1) cfset next_number=ListGetAt(list,position+1) /cfloop cfoutput Previous Number: #previous_number#br Current Number: #current_number#br Next Number: #next_number# /cfoutput You will run into problems with the first and last number in the list but this should give you a start and i'm sure you'll be able to find a workaround. Dennis Baldwin -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:28 AM To: CF-Talk Subject: Find position in a list Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Any LDAP Guru's here? Authentication Problem
speaking of this, how does one 'authenticate'? I'm having trouble getting this to work. Do I cfldap once anonymously to get the userid based on user inputed info then cfldap again with userid and password supplied this time. If cfldap pulls back a record, then authentication happend, correct? I'm told passwords are generally SHA1 hashed in LDAP directories, does CFLDAP do the hashing? - Douglas Knudsen Leveraged Technologies Group Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 03/23/2001 09:27 AM To: Douglas Knudsen/ATL/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: Subject: Re: Any LDAP Guru's here? Authentication Problem Initally I would say no. Point your cfldap to an ip of the ldap server. Will y ou need to authenticate to both servers? Neither tree can see each other can th ey? If one of the servers can give you access to all the users context thats al l your should need. If you need to authenticate to both do the first query with the first IP do a user search then do the second query with the second server. Once you fin d the user context make sure you authenticate to the right ip. [EMAIL PROTECTED] 03/23/01 07:51AM quick question. i want to use NDS LDAP to authenticate ALL the users of our intranet. my problem that there are 2 servers. both have the same tree name? will this cause me problems. if so is there a way around it? any ideas would be great -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Querying NT directory permissions?
Hey all, I apologize in advance if this topic has already been discussed ad nauseum, but I'm not even sure where to begin looking in the archives for this.(I did search, but haven't found anything yet to help me out.) Here's what I need to do. Our department sets up all directories for web publishers within our company. We have an online form that users fill out to request web space, and then someone on our team sets it up. We would like to build an application that will display: --all of the current web sites (i.e. "folders"), --all GROUPS that have permission to access the folder, --all INDIVIDUALS that have permission to access the folder, --the entire CONTENTS of each folder and any file-level permissions, --Disk space usage, --number of files of each type (.doc, .pdf, .xls, etc.) --Any primary and secondary publishers to the site, as well as associated passwords (if possible. Of course this is for our team's eyes only!) We do not want to have to store this information in a database--we want to pull it right off of the NT box itself. I know I can use CFDIRECTORY to display the directory contents, and I can find the number of each file type, but how can I display permissions and disk space? Is that even possible? Publishers all use FrontPage, so we will have one server for all of the FrontPage sites, and a completely separate server for all of our CF apps. If anyone has done something similar I would love to know how you implemented it. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: determine if user is active?
Or even: meta http-equiv="Refresh" content="300;url=timeout.cfm" At 07:45 AM 3/23/01, you wrote: Body onLoad settimeout (5 minutes worth of milliseconds) when that timeout has been reached have the session end, window close or whatever -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 8:35 AM To: CF-Talk Subject: determine if user is active? My bank disconnects me after 5 minutes, how can I reproduce this? -=-=-=-=-=-=-=-=-=-=-=-=- Ben Dyer Senior Internet Developer Imaginuity Interactive http://www.imaginuity.com -=-=-=-=-=-=-=-=-=-=-=-=- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find position in a list
Thanx everyone - have solved the problem now J -Original Message- From: dennis baldwin [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 14:43 To: CF-Talk Subject: RE: Find position in a list James, Try this cfset list="23,24,27,30,543,675,980" !--- current_number would be dynamic, right now it's set to 543 --- cfset current_number=543 cfset position=ListFind(list,current_number) cfloop list="#list#" index="count" cfset previous_number=ListGetAt(list,position-1) cfset next_number=ListGetAt(list,position+1) /cfloop cfoutput Previous Number: #previous_number#br Current Number: #current_number#br Next Number: #next_number# /cfoutput You will run into problems with the first and last number in the list but this should give you a start and i'm sure you'll be able to find a workaround. Dennis Baldwin -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:28 AM To: CF-Talk Subject: Find position in a list Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find position in a list
i don't think this will work because you don't know how long the string before or after the original substring is. so how would you know what position to specify for ListGetAt()? that's why i think GetToken() would work... -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 6:38 AM To: CF-Talk Subject: Re: Find position in a list use the listFind() and listGetAt() functions At 02:28 PM 3/23/2001, you wrote: Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find position in a list
heh scratch my last comment, i think it will work... i'm off to find some coffee... -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 6:38 AM To: CF-Talk Subject: Re: Find position in a list use the listFind() and listGetAt() functions At 02:28 PM 3/23/2001, you wrote: Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find position in a list
Thanx guys - solved the problem now! J -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 14:41 To: CF-Talk Subject: RE: Find position in a list You need GetToken() to get the next/previous values once you get the position of the original substring. --Dylan -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 6:34 AM To: CF-Talk Subject: RE: Find position in a list Use listFind(list [, delimiter]) HTH, Duane -Original Message- From: James Maltby [mailto: Sent: Friday, March 23, 2001 9:28 AM To: CF-Talk Subject: Find position in a list Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:Find position in a list
James, I am attaching a CFX tag I wrote that will do what you need. It's called ListGetChunk and it allows you to extract a portion of a list. You could use it like this: cfset MyList = "23,24,27,30,543,675,980" cfset Start = ListFind(MyList, 543) - 1 cfset Max = 3 cfx_ListGetChunk List="#MyList#" Start="#Start#" Max="#Max#" NewList="NewList" !--- NewList would now contain 30,543,675 --- cfset First = ListFirst(NewList) cfset Last = ListLast(NewList) Hope that helps, Chris -- Original Message From: "James Maltby"[EMAIL PROTECTED] Subject: Find position in a list Date: Fri, 23 Mar 2001 14:28:16 - Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying NT directory permissions?
Check out http://www.intrafoundation.com/intranethostingtoolkit.html I haven't used it, but I think it contains all of the functionality you're looking for. Bob -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: March 23, 2001 9:47 AM To: CF-Talk Subject: Querying NT directory permissions? Hey all, I apologize in advance if this topic has already been discussed ad nauseum, but I'm not even sure where to begin looking in the archives for this.(I did search, but haven't found anything yet to help me out.) Here's what I need to do. Our department sets up all directories for web publishers within our company. We have an online form that users fill out to request web space, and then someone on our team sets it up. We would like to build an application that will display: --all of the current web sites (i.e. "folders"), --all GROUPS that have permission to access the folder, --all INDIVIDUALS that have permission to access the folder, --the entire CONTENTS of each folder and any file-level permissions, --Disk space usage, --number of files of each type (.doc, .pdf, .xls, etc.) --Any primary and secondary publishers to the site, as well as associated passwords (if possible. Of course this is for our team's eyes only!) We do not want to have to store this information in a database--we want to pull it right off of the NT box itself. I know I can use CFDIRECTORY to display the directory contents, and I can find the number of each file type, but how can I display permissions and disk space? Is that even possible? Publishers all use FrontPage, so we will have one server for all of the FrontPage sites, and a completely separate server for all of our CF apps. If anyone has done something similar I would love to know how you implemented it. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE ACTION=copy and NAMECONFLICT
Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag? That's what I'd done - added NAMECONFLICT="makeunique" and ColdFurion threw the error message pasted into the last post. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Multiple Inputs (was Re: Textbox validation)
Will, Have you considered treating the textbox string as a list, breaking it apart for your query (in your example) "bass" OR "guitar" OR "other list item". This way you can allow your users to enter multiple words. The part I'm not sure about is how my example below affects performance (I'm still new to things like database tuning) e.g. mySearchParams = "Bass Guitar Music" CFSET SearchLen = ListLen(mySearchParams) CFSET SearchArr = ListToArray(mySearchParams) CFSET SeachFormat = "" CFLOOP FROM="1" TO="#SearchLen#" INDEX="x" CFIF SearchFormat EQ "" CFSET SearchFormat = "myColName = """ "#SearchArr[x]#""" CFELSE CFSET SearchFormat = " OR myColName = """ "#SearchArr[x]#""" /CFIF /CFLOOP CFQUERY ... SELECT blah1, blah2, blah3 FROM myTable WHERE #SearchFormat# /CFQUERY From: "W Luke" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Textbox validation Date: Fri, 23 Mar 2001 13:30:28 - Thanks for all the replies. The reason I need to prevent more than one word being entered, is I'm finding it impossible to use wildcard filtering using Access' Instr function (any clues anyone?) - for example, if the search string contained "Bass Guitar" it would only return True if it *matches* it, and not if it's similar (Like). Anyways, thanks - going to do what Aidan suggests, and add the Javascript when I have time. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com Really the best way is *both*. JavaScript is much nicer from a user interface point of view. But if the validation is important you need to do it again on the server, because you can't guarantee the user has JavaScript running in their browser. Nick -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 12:39 AM To: CF-Talk Subject: Textbox validation Hi, On one textbox I need to prohibit users entering more than one word - I don't want them to enter a space. What's the best way of doing this - Javascript, or Cold Fusion after the form has been posted? Thanks. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
lock problems
I keep seeing this error, and my app seems to freeze from time to time. Any ideas what I should look for? Unable to acquire lock for single threaded sessions within timeout period. Please raise the request timeout limit to lengthen the time available to acquire the lock. My locks all look like this: CFLOCK TIMEOUT="30" THROWONTIMEOUT="Yes" TYPE="EXCLUSIVE" SCOPE="SESSION" ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: determine if user is active?
the bank disconnects in 5 minutes? or after 5 minutes of inactivity? seems odd if it's the former, because you could be in the middle of a transaction. the meta and onLoad solutions will work like the former (kick in 5 no matter what) not the latter (kick after no action for 5 minutes). -Original Message- From: Ben Dyer [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 6:48 AM To: CF-Talk Subject: RE: determine if user is active? Or even: meta http-equiv="Refresh" content="300;url=timeout.cfm" At 07:45 AM 3/23/01, you wrote: Body onLoad settimeout (5 minutes worth of milliseconds) when that timeout has been reached have the session end, window close or whatever -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 8:35 AM To: CF-Talk Subject: determine if user is active? My bank disconnects me after 5 minutes, how can I reproduce this? -=-=-=-=-=-=-=-=-=-=-=-=- Ben Dyer Senior Internet Developer Imaginuity Interactive http://www.imaginuity.com -=-=-=-=-=-=-=-=-=-=-=-=- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find position in a list
heh my second post posted first. how wierd is that. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 6:51 AM To: CF-Talk Subject: RE: Find position in a list i don't think this will work because you don't know how long the string before or after the original substring is. so how would you know what position to specify for ListGetAt()? that's why i think GetToken() would work... -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 6:38 AM To: CF-Talk Subject: Re: Find position in a list use the listFind() and listGetAt() functions At 02:28 PM 3/23/2001, you wrote: Hi Let's imagine I've got a list of id numbers and a specific id number within this list. How could I output the "next" id number in the list and the "previous" id number in the list, depending on the id number I have? e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or 675, then if I get 675 I need to get 543 or 980, etc. etc. TIA James "The Force is strong in this one..." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Processing Times and Servers Under Load
In general what kind of cf processing times can a server handle under moderate load, say in the neighborhood of 50,000 hits a day. I have been re-writing the front page portal of an ecommerce site and I think with query caching and some streamlining of code I have it down as far as I can (320 ms processing time). Will this stand up to moderate load? What kind of numbers should I be aiming for? Duane Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help please
Personally, my advice is to learn everything. That way you can go one way or the other. Makes you available for multiple jobs, as well as some places that need multiple skills. At this point and time, most of the work appears to be in ASP, and there's a healthy chunk of Perl out there. Though you don't wait until you need to a job to learn these skills; it's hard to learn enough fast enough. Always think forwards. "Suggest a way out"? McDonald's is always hiring. :) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Venkata Ramakrishna wrote: Hi gang, Iam a Cf guy since 1.5 years.I changed my company expecting a assignment in US.As the market slowed down there,my new employer is making me sit at his place. The problem is that he don't have any CF work and the other teams wont allow me inside their domain. Should i stick with CF or change to some other domain?Whats the trend at US? Can someone suggest a way out until the US markets gear up again? Expecting some serious suggestions. Thank you. Ramakrishna ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Boy - here's a dandy Microsoft Security Bulletin MS01-017
Thanks for the heads up Dave, but didn't Microsoft put a moratorium on posting the text of Security Updates to mailing lists? I seem to recall that this was a big issue with BugTraq. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Dave Hannum wrote: Take note if you go to pages that try to install components so that you can view or operate components on the page (such as java applets, etc . . . ) Dave - Original Message - From: "Microsoft Product Security" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 10:42 AM Subject: Microsoft Security Bulletin MS01-017 The following is a Security Bulletin from the Microsoft Product Security Notification Service. Please do not reply to this message, as it was sent from an unattended mailbox. -BEGIN PGP SIGNED MESSAGE- - -- Title: Erroneous VeriSign-Issued Digital Certificates Pose Spoofing Hazard Date: 22 March 2001 Software: All Microsoft customers should read the bulletin. Impact: Attacker could digitally sign code using the name "Microsoft Corporation". Bulletin: MS01-017 Microsoft encourages customers to review the Security Bulletin at: http://www.microsoft.com/technet/security/bulletin/MS01-017.asp. - -- Issue: == VeriSign, Inc., recently advised Microsoft that on January 30 and 31, 2001, it issued two VeriSign Class 3 code-signing digital certificates to an individual who fraudulently claimed to be a Microsoft employee. The common name assigned to both certificates is "Microsoft Corporation". The ability to sign executable content using keys that purport to belong to Microsoft would clearly be advantageous to an attacker who wished to convince users to allow the content to run. The certificates could be used to sign programs, ActiveX controls, Office macros, and other executable content. Of these, signed ActiveX controls and Office macros would pose the greatest risk, because the attack scenarios involving them would be the most straightforward. Both ActiveX controls and Word documents can be delivered via either web pages or HTML mails. ActiveX controls can be automatically invoked via script, and Word documents can be automatically opened via script unless the user has applied the Office Document Open Confirmation Tool. However, even though the certificates say they are owned by Microsoft, they are not bona fide Microsoft certificates, and content signed by them would not be trusted by default. Trust is defined on a certificate-by-certificate basis, rather than on the basis of the common name. As a result, a warning dialogue would be displayed before any of the signed content could be executed, even if the user had previously agreed to trust other certificates with the common name "Microsoft Corporation". The danger, of course, is that even a security-conscious user might agree to let the content execute, and might agree to always trust the bogus certificates. VeriSign has revoked the certificates, and they are listed in VeriSign's current Certificate Revocation List (CRL). However, because VeriSign's code-signing certificates do not specify a CRL Distribution Point (CDP), it is not possible for any browser's CRL-checking mechanism to download the VeriSign CRL and use it. Microsoft is developing an update that rectifies this problem. The update package includes a CRL containing the two certificates, and an installable revocation handler that consults the CRL on the local machine, rather than attempting to use the CDP mechanism. Versions of the update are being prepared for all Microsoft platforms released since 1995. However, because of the large number of platforms that must be tested, the patches are not available at this writing. Until the update is available, we urge customers to take some or all of the following steps to protect themselves should they encounter hostile code signed by one of the certificates. - Visually inspect the certificates cited in all warning dialogues. The two certificates at issue here were issued on 29 and 30 January 2001, respectively. No bona fide Microsoft certificates were issued on these dates. The FAQ and Knowledge Base article Q293817 provide complete details regarding both certificates. - Install the Outlook Email Security Update (http://www.officeupdate.com/2000/downloadDetails/Out2ksec.htm) to prevent mail-borne programs from being launched, even via signed components, and install the Office Document Open Confirmation Tool (http://officeupdate.microsoft.com/downloadDetails/confirm.htm) to force web pages to request permission before opening Office documents. - Consider temporarily removing the
Re: Form Submission -- Revisited (UltraDev 4)
Your talking apples and oranges. FrontPage has some proprietary scripts that run on the server that handle things like confirmation pages, email functionality, etc. UD4/ColdFusion do not come with this. You develop the logic yourself. Of course UltraDev comes with server behaviors, as well as giving you the ability to add or create additional ones. I do not recall this being a default behavior; perhaps someone has put one on the Ultradev Developer's Exchange. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] James Taavon wrote: Hey Everyone! I posted a message a little while back regarding submission forms in Dreamweaver. Let me ask the same again, but using UltraDev 4. I used to create forms in submission forms FrontPage and use the Form properties to assign a confirmation page, tell what fields to save a send the info in the form of an email. Know what I mean? Anyway, can I duplicate that same functionality in UltraDev or do I need to link the form to an external cgi script to perform the desired action. James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: determine if user is active?
Yes, it's when I'm inactive they prompt me with a "You better do something or we'll kick you off" type of message. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 10:13 AM To: CF-Talk Subject: RE: determine if user is active? the bank disconnects in 5 minutes? or after 5 minutes of inactivity? seems odd if it's the former, because you could be in the middle of a transaction. the meta and onLoad solutions will work like the former (kick in 5 no matter what) not the latter (kick after no action for 5 minutes). -Original Message- From: Ben Dyer [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 6:48 AM To: CF-Talk Subject: RE: determine if user is active? Or even: meta http-equiv="Refresh" content="300;url=timeout.cfm" At 07:45 AM 3/23/01, you wrote: Body onLoad settimeout (5 minutes worth of milliseconds) when that timeout has been reached have the session end, window close or whatever -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 8:35 AM To: CF-Talk Subject: determine if user is active? My bank disconnects me after 5 minutes, how can I reproduce this? -=-=-=-=-=-=-=-=-=-=-=-=- Ben Dyer Senior Internet Developer Imaginuity Interactive http://www.imaginuity.com -=-=-=-=-=-=-=-=-=-=-=-=- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscheduler weird thing...
Are you sure this is the case, this seems very, very strange. I don't think I've ever needed to schedule a http request on Windows that connected to a port other than 80, but I have on linux without any difficulty. The problems I have experienced with CF scheduling are generally with the CFSCHEDULE tag, not ColdFusion scheduling in general. Scheduled tasks added using the administrator run fine while tasks added/updated using the tag simply don't run (though you can run scheduled tasks using CFSCHEDULE). Behaviour is not consistent, or I haven't done enough testing to determine a definite pattern, though if I recall correctly, restarting the server did result in the scheduled tasks set using CFSCHEUDLE running fine. I can't remember whether restarting the CF Executive or CF App Server services had the same result. To be honest I don't have time to beta test allaire's software. There have been complaints about CFSCHEDULE since v3, and it still doesn't work reliably, so I just don't use it. Mark At 01:04 PM 3/23/2001, you wrote: From past experience with CFSchedule, make sure the website/template that is being called (ie, http://mywebsite.com/check_this.cfm ) is not located on an non-standard port. Meaning the template should be able to be called from a normal HTTP Request. If it is behind an obscure port such as: http://mywebsite.com:8088/check_this.cfm This will not work. Hopefully this is addressed in CF 5.0 but not the case in 4.01 or 4.5 Hope this helps. Randy -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 7:31 AM To: CF-Talk Subject: RE: cfscheduler weird thing... coldfusion scheduling is notoriuosly unreliable. Does anyone know if this is going to be addressed in ColdFusion 5.0? I've *never* managed to get a scheduled event to work and have to resort to other applications which trigger batch files to open a browser and pass it a URL as a parameter... pain! -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Any LDAP Guru's here? Authentication Problem
Michael, Could you go a little more indepth, I am working with LDAP for the first time and just can't quite get IT... I can pull a user from the LDAP server, I can search and return multiple results...I can't seem to get what a successful login is... Is it that I get a empty recordset (which is what is happening now) or is it that I get the user record back??? Thanks, John -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:15 AM To: CF-Talk Subject: Re: Any LDAP Guru's here? Authentication Problem Once you get the full user context. Do another query/or your first query, supply that(the full context) in the username field, and the password in the password field. CFldap does the rest. If you get an error the username/password isn't right. If nothing happens it was right and they have authenticated. [EMAIL PROTECTED] 03/23/01 09:50AM speaking of this, how does one 'authenticate'? I'm having trouble getting this to work. Do I cfldap once anonymously to get the userid based on user inputed info then cfldap again with userid and password supplied this time. If cfldap pulls back a record, then authentication happend, correct? I'm told passwords are generally SHA1 hashed in LDAP directories, does CFLDAP do the hashing? - Douglas Knudsen Leveraged Technologies Group Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 03/23/2001 09:27 AM To: Douglas Knudsen/ATL/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: Subject: Re: Any LDAP Guru's here? Authentication Problem Initally I would say no. Point your cfldap to an ip of the ldap server. Will y ou need to authenticate to both servers? Neither tree can see each other can th ey? If one of the servers can give you access to all the users context thats al l your should need. If you need to authenticate to both do the first query with the first IP do a user search then do the second query with the second server. Once you fin d the user context make sure you authenticate to the right ip. [EMAIL PROTECTED] 03/23/01 07:51AM quick question. i want to use NDS LDAP to authenticate ALL the users of our intranet. my problem that there are 2 servers. both have the same tree name? will this cause me problems. if so is there a way around it? any ideas would be great -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help please
Dont just stick to Web based tools, get to grips with conventional programming languages as well, such as VB, C++, JAVA. and others. Even if its just a matter of installing a standard edition of the software and getting to grips with the syntax and format and quirks of the language. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 15:33 To: CF-Talk Subject: Re: Help please Personally, my advice is to learn everything. That way you can go one way or the other. Makes you available for multiple jobs, as well as some places that need multiple skills. At this point and time, most of the work appears to be in ASP, and there's a healthy chunk of Perl out there. Though you don't wait until you need to a job to learn these skills; it's hard to learn enough fast enough. Always think forwards. "Suggest a way out"? McDonald's is always hiring. :) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Venkata Ramakrishna wrote: Hi gang, Iam a Cf guy since 1.5 years.I changed my company expecting a assignment in US.As the market slowed down there,my new employer is making me sit at his place. The problem is that he don't have any CF work and the other teams wont allow me inside their domain. Should i stick with CF or change to some other domain?Whats the trend at US? Can someone suggest a way out until the US markets gear up again? Expecting some serious suggestions. Thank you. Ramakrishna ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Regular expression Help
Greetings All, I am in the process of developing a small headache with Regular Expressions... I have looked at all of the examples I could find on the archives of this mailing list and other web pages but I still just don't get it.. I think I will pickup the O'Reilly book that I have seen at another job before on regular expressions but for now I am asking the list for help.. What I am trying to do is parse through an HTML source page an look for a specfic string.. for example.. meta name="pubdate" content="Fri, 23 Mar 2001 07:00:00 GMT" I would like to grab everything from this string from " to GMT" Thanks in Advance... Mallory Woods This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email and any such files in error and that any use, dissemination, forwarding, printing or copying of this email and/or any such files is strictly prohibited. If you have received this email in error please immediately notify [EMAIL PROTECTED] and destroy the original message and any such files. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscheduler weird thing...
At 03:22 PM 3/23/2001, you wrote: err, there's no need to do that. There is an executable you can use to process CFML templates via the command line. Have a look at: http://www.allaire.com/Handlers/index.cfm?ID=3328Method=Full Thanks. I don't want to sound ungrateful, but with several ColdFusion servers, presumably what they suggest would mean setting up an instance of the scheduled event software on each. Well, that depends on what your scheduled task does. To be honest I can't think of a situation where a scheduled task would do something which affects multiple servers which could not be achieved by running tasks on one server. Then again, it is Friday afternoon and my brain is concentrating on coming up with the fastest route to the pub through Dublin's nasty traffic jams. The way it is at the moment, there's a load of open IE windows when I get into work but at least all the scheduled events are managed from one place. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Finding a space in a string..
Hi dee ho all, Would this find a space in a string? CFSET pos= #Find(Chr(20),'tempdefendant')# Because..it ain't working for some reason. I also tried CFSET pos= #Find(' ','tempdefendant')# BUt that results in POS being 0 all the time. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Passing query back to page through caller in custom tag
I am trying to write a custom tag that will perform a generic select and bring back a query to the page. Has anyone had any experience passing a query structure back to the page through the caller variable? I am having trouble with this. I also experimented briefly with looping through the query passing the values to a struct and then passing that struct back to the caller (couldn't get that to work either). It also seemed like it was not worth it in terms of overhead if I had to loop through the query and make a call to the database. If you could email the list and me directly I would appreciate it, I am in digest mode. Thanks, David Caplan 36 w 20 st | nyc 10011 | 212.929.7644 Ext.136 | www.fusebox.com | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Regular expression Help
OT: are there any statistics on how many developers regexp has made bald? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
crystal report report
Hi all, here is my code: CFREPORT REPORT="Report1.rpt" {Class.Class_ID} = "3" /CFREPORT here is my Error Diagnostic Information: Report not completed (the report server was busy) The requested report could not be completed because the server was extremely busy serving other report requests. Please notify the site administrator that the default TIMEOUT for the report server should be increased. any ideas? thanks a lot! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Regular expression Help
Re: use of regular expressions for parsing html One can reliably use regular expressions to parse html if it is html that you have direct and full editorial control over. That is, if you hand edit the html, AND you can keep all your requirements in mind, then you can use with some success regular expressions to parse html. Otherwise, if you are trying to parse pages from the net, you can be pretty certain to run into serious stumbling blocks (ie the perverse things people and applications do in the name of writing or generating html). For instance, if I knew that the meta tag would _always_ be the format you described, I use a regular expression like content="([^"]*)" and know that the stuff between the parens would be what I wanted. However, I see html all the time that adds newlines arbitrarily at white space... which means that you have to somehow make certain that you know where to stop parsing... -- Larry W. Virden URL: mailto:[EMAIL PROTECTED] URL: http://www.purl.org/net/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
pdf merging?
I know how to create a dynamic pdf however how do you merge several pdf's into the same document so the user can print the documents just once? Thanks, Nathan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE ACTION=copy and NAMECONFLICT
I believe you'll have to check for the existence of the file name using CFDIRECTORY first. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:08 AM To: CF-Talk Subject: RE: CFFILE ACTION="copy" and NAMECONFLICT Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag? That's what I'd done - added NAMECONFLICT="makeunique" and ColdFurion threw the error message pasted into the last post. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Finding a space in a string..
Try ASCII 32. That is the space character. jon - Original Message - From: "Angél Stewart" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 11:27 AM Subject: Finding a space in a string.. Hi dee ho all, Would this find a space in a string? CFSET pos= #Find(Chr(20),'tempdefendant')# Because..it ain't working for some reason. I also tried CFSET pos= #Find(' ','tempdefendant')# BUt that results in POS being 0 all the time. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding a space in a string..
The following returns 8 in cf 4.5.1 cfset x = Find(" ", "tempdef endant") Duane -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 11:27 AM To: CF-Talk Subject: Finding a space in a string.. Hi dee ho all, Would this find a space in a string? CFSET pos= #Find(Chr(20),'tempdefendant')# Because..it ain't working for some reason. I also tried CFSET pos= #Find(' ','tempdefendant')# BUt that results in POS being 0 all the time. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding a space in a string..
Try CFSET pos = Find(" ",tempdefendant, "1") Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:27 AM To: CF-Talk Subject: Finding a space in a string.. Hi dee ho all, Would this find a space in a string? CFSET pos= #Find(Chr(20),'tempdefendant')# Because..it ain't working for some reason. I also tried CFSET pos= #Find(' ','tempdefendant')# BUt that results in POS being 0 all the time. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscheduler weird thing...
Well, that depends on what your scheduled task does. To be honest I can't think of a situation where a scheduled task would do something which affects multiple servers which could not be achieved by running tasks on one server. Maybe I read the Allaire article wrong, but I assumed that if you want to use the method they suggest (calling the executable and passing it parameters), you would have to reference the physical path to the template you wanted to run, ie D:\Inetpub\wwwroot\directory\file.cfm. With several servers and a range of sites on each, I assumed you'd have to set up the scheduling software on each machine that had a site for which you wanted to run a scheduled event (...if that made any sense whatsoever!). And ditto about that Friday-feeling *uggh* "I can almost feel my neural transmitters shutting down." (C H - Watterson) -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression Help
This works. CFSET theString = "meta name=""pubdate"" content=""Fri, 23 Mar 2001 07:00:00 GMT""" CFSET st = reFindNoCase("(content="")(.*)(GMT"")",theString,1,"TRUE") CFOUTPUT#mid(theString,st.pos[3],st.len[3])#/CFOUTPUT The two pieces are: 1) Creating the regularExpression 2) understanding the use of the "return subexpressions" attribute of reFind; check the documentation. I learned something just now about using it with a paren-ed regular expression. -Original Message- From: Mallory Woods [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 10:17 AM To: CF-Talk Subject: Regular expression Help Greetings All, I am in the process of developing a small headache with Regular Expressions... I have looked at all of the examples I could find on the archives of this mailing list and other web pages but I still just don't get it.. I think I will pickup the O'Reilly book that I have seen at another job before on regular expressions but for now I am asking the list for help.. What I am trying to do is parse through an HTML source page an look for a specfic string.. for example.. meta name="pubdate" content="Fri, 23 Mar 2001 07:00:00 GMT" I would like to grab everything from this string from " to GMT" Thanks in Advance... Mallory Woods This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email and any such files in error and that any use, dissemination, forwarding, printing or copying of this email and/or any such files is strictly prohibited. If you have received this email in error please immediately notify [EMAIL PROTECTED] and destroy the original message and any such files. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE ACTION=copy and NAMECONFLICT
Nameconflict is only used when action=upload. Thanks. So if you're trying to copy a file into a directory that already has a file of that name, how can you specify what action to take? Doesn't it makes sense to be able to provide a NAMECONFLICT attribute for that eventuality? BTW, that was more of a rhetorical question aimed at Allaire... -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports Version?
Does CR 8.5 work ok with CF 4.51? If not, what version works? TNX for any comments. Rick Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: crystal report report
I get this periodically due apparently to a memory leak in an ODBC driver or something. What solves it immediately is stopping and restarting the CF services. There was a cf-talk thread on Wed. 3/21: Stopping/starting CF with NT "AT" that addressed doing this automatically with CF running on NT or Win2K. HTH. Ben -Original Message- From: Chang Liu [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 8:50 AM To: CF-Talk Subject: crystal report report Hi all, here is my code: CFREPORT REPORT="Report1.rpt" {Class.Class_ID} = "3" /CFREPORT here is my Error Diagnostic Information: Report not completed (the report server was busy) The requested report could not be completed because the server was extremely busy serving other report requests. Please notify the site administrator that the default TIMEOUT for the report server should be increased. any ideas? thanks a lot! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression Help
Mallory, Try this: cfset newVar=REFind(varWithHTML,'meta name="pubdate"[^]+') That should return the string; meta name="pubdate" content="[some date]" Which you can then extract the date from. Good luck! Douglas Malcolm -Original Message- From: Mallory Woods [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 8:17 AM To: CF-Talk Subject: Regular expression Help Greetings All, I am in the process of developing a small headache with Regular Expressions... I have looked at all of the examples I could find on the archives of this mailing list and other web pages but I still just don't get it.. I think I will pickup the O'Reilly book that I have seen at another job before on regular expressions but for now I am asking the list for help.. What I am trying to do is parse through an HTML source page an look for a specfic string.. for example.. meta name="pubdate" content="Fri, 23 Mar 2001 07:00:00 GMT" I would like to grab everything from this string from " to GMT" Thanks in Advance... Mallory Woods This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email and any such files in error and that any use, dissemination, forwarding, printing or copying of this email and/or any such files is strictly prohibited. If you have received this email in error please immediately notify [EMAIL PROTECTED] and destroy the original message and any such files. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Multiple Inputs (Fixed a Mistake!)
Oops - that's what I get for writing code on the fly. Try this instead: !--- mySearchParans is just an example of a possible search string --- CFSET mySearchParams = "Guitar Case and string" CFSET SearchArr = ListToArray(mySearchParams, " ") CFSET SearchLen = ArrayLen(SearchArr) CFSET SearchFormat = "null" CFOUTPUTLen:#SearchLen#/CFOUTPUT CFLOOP FROM="1" TO="#SearchLen#" INDEX="x" CFIF SearchFormat EQ "null" CFSET SearchFormat = "myColName = """ "#SearchArr[x]#""" CFELSE CFSET SearchFormat = "#SearchFormat#" " OR myColName = """ "#SearchArr[x]#""" /CFIF /CFLOOP CFQUERY ... SELECT blah1, blah2, blah3 FROM myTable WHERE #SearchFormat# /CFQUERY From: "Jeanne Sarfaty Glazer" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Multiple Inputs (was Re: Textbox validation) Date: Fri, 23 Mar 2001 10:09:49 -0500 Will, Have you considered treating the textbox string as a list, breaking it apart for your query (in your example) "bass" OR "guitar" OR "other list item". This way you can allow your users to enter multiple words. The part I'm not sure about is how my example below affects performance (I'm still new to things like database tuning) e.g. mySearchParams = "Bass Guitar Music" CFSET SearchLen = ListLen(mySearchParams) CFSET SearchArr = ListToArray(mySearchParams) CFSET SeachFormat = "" CFLOOP FROM="1" TO="#SearchLen#" INDEX="x" CFIF SearchFormat EQ "" CFSET SearchFormat = "myColName = """ "#SearchArr[x]#""" CFELSE CFSET SearchFormat = " OR myColName = """ "#SearchArr[x]#""" /CFIF /CFLOOP CFQUERY ... SELECT blah1, blah2, blah3 FROM myTable WHERE #SearchFormat# /CFQUERY From: "W Luke" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Textbox validation Date: Fri, 23 Mar 2001 13:30:28 - Thanks for all the replies. The reason I need to prevent more than one word being entered, is I'm finding it impossible to use wildcard filtering using Access' Instr function (any clues anyone?) - for example, if the search string contained "Bass Guitar" it would only return True if it *matches* it, and not if it's similar (Like). Anyways, thanks - going to do what Aidan suggests, and add the Javascript when I have time. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com Really the best way is *both*. JavaScript is much nicer from a user interface point of view. But if the validation is important you need to do it again on the server, because you can't guarantee the user has JavaScript running in their browser. Nick -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 12:39 AM To: CF-Talk Subject: Textbox validation Hi, On one textbox I need to prohibit users entering more than one word - I don't want them to enter a space. What's the best way of doing this - Javascript, or Cold Fusion after the form has been posted? Thanks. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with SQL statement
I'm doing a select from three tables, and my query is timing out. The problem is probably coming from the fact that there is not always a record in the m.POS_ARC_HEADX table. Is there a way to restructure this query so it still checks the m.POS_ARC_HEADX but does not die if no record exists? Is there another reason this query might be dying? cfquery name="InvoiceDetail" datasource="triad.udd" dbtype="ODBC" SELECT m.POS_ARC_HEAD.DocNo, m.POS_ARC_HEAD.CrName, m.POS_ARC_SKU.SKU, m.POS_ARC_SKU.Description, m.POS_ARC_HEADX.PersonAuthToCharge FROM m.POS_ARC_HEAD, m.POS_ARC_HEADX, m.POS_ARC_SKU WHERE m.POS_ARC_HEAD.DocNo = m.POS_ARC_HEADX.DocNo AND m.POS_ARC_HEADX.DocNo = m.POS_ARC_SKU.DocNo AND m.POS_ARC_HEADX.DocNo = "#URL.RetrieveDoc#" /cfquery You can handle the missing records in the POS_ARC_HEADX table by using an outer join. The syntax varies a little depending on what database you are using, so I'd suggest checking the SQL help that comes with the database. You may want to change the second WHERE condition to join to the POS_ARC_HEAD table instead of the POS_ARC_HEADX, unless you intend to exclude records that may be in POS_ARC_SKU but are not in POS_ARC_HEADX. As far as the query timing out, the query will run a lot faster if you have an index on the DocNo field in all three tables. Depending on the size of the tables that may make a big difference. Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (646) 638-3444 http://www.hallofsports.com .. . . where the legends live on ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding a space in a string..
use a regular expression off the top of my head try CFSET pos= RedFind("[[:Space:]]","#tempdefendant#") Syntax cold be wrong, but it's not far off, look in the help on refind() to get it exact. -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 16:27 To: CF-Talk Subject: Finding a space in a string.. Hi dee ho all, Would this find a space in a string? CFSET pos= #Find(Chr(20),'tempdefendant')# Because..it ain't working for some reason. I also tried CFSET pos= #Find(' ','tempdefendant')# BUt that results in POS being 0 all the time. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding a space in a string..
I am assuming that tempdefendant is a variable however this statement will read it as a string. Since there is no space in tempdefendant as a string you will get a zero. Do this instead. CFSET pos=Find(" ","#tempdefendant#") -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 8:27 AM To: CF-Talk Subject: Finding a space in a string.. Hi dee ho all, Would this find a space in a string? CFSET pos= #Find(Chr(20),'tempdefendant')# Because..it ain't working for some reason. I also tried CFSET pos= #Find(' ','tempdefendant')# BUt that results in POS being 0 all the time. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pdf merging?
www.activepdf.com PDF Server Toolkit www.digapp.com (AppendPDF) www.pdflib.com - i beleive the latest incarnation/beta of this lib supports FLAT pdf merging Steve - Original Message - From: "Nathan Stanford" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 8:40 AM Subject: pdf merging? I know how to create a dynamic pdf however how do you merge several pdf's into the same document so the user can print the documents just once? Thanks, Nathan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding a space in a string..
If I remember correctly, the way you've got that statement Find function is looking for a space in the string 'tempdefendant', which will always be 0. Try taking the quote marks off of tempdefendant, like so: CFSET pos= #Find(' ',tempdefendant)# HTH Hatton Hi dee ho all, Would this find a space in a string? CFSET pos= #Find(Chr(20),'tempdefendant')# Because..it ain't working for some reason. I also tried CFSET pos= #Find(' ','tempdefendant')# BUt that results in POS being 0 all the time. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE ACTION=copy and NAMECONFLICT
you cannot use NAMECONFLICT with the Copy Action. You can only use it with the Upload Action. If you have to use the copy action your going to have to create more logic to figure out if the file has the same name. This will be a combination of CFDIRECTORY, CFFILE, and some CFIF statements. At 10:51 AM 3/23/01 -0600, you wrote: I believe you'll have to check for the existence of the file name using CFDIRECTORY first. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:08 AM To: CF-Talk Subject: RE: CFFILE ACTION="copy" and NAMECONFLICT Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag? That's what I'd done - added NAMECONFLICT="makeunique" and ColdFurion threw the error message pasted into the last post. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Why wont this advance to the next record
Appreciate it someone could tell me why this wont advance to the next record, keep getting 404 error object not found !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN" cfparam name="firstrow" default="1" CFIF IsDefined("URL.first") cfset firstrow = url.first /CFIF Cfset startnextpage = Firstrow + 1 CFPARAM Name="ID" Default=1 HTML HEAD cfquery name="selectcandidate" datasource="interview" dbtype="ODBC" SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile FROMinterview WHERE ID=#ID# /cfquery TITLEInterview Candidates/TITLE /HEAD BODY bgcolor="6699ff" !--- include toolbar.cfm--- cfinclude template="Toolbar.cfm" cfoutput query="Selectcandidate" startrow="#firstrow#" maxrows="1" table cellpadding="10" tr tdID/tdbr td#id#/tdbr /tr tr tdCandidate Name/tdbr td#EmpCandidate#/tdbr /tr tr tdSkill Background/td td#SKillBackground#/td /tr tr tdStatus/td td#Status#/td /tr tr tdRecruiter/td td#Recruiter#/td /tr /table BRBR a href="cfoutput-default2.cfm?First=#StartNextPage#"Next Record/a /cfoutput /body Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE ACTION=copy and NAMECONFLICT
I believe you'll have to check for the existence of the file name using CFDIRECTORY first. doh! of course... thanks *sheepish look* -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pdf merging?
Nathan, Sometime ago, I remember seeing a toolkit on activepdf.com that allowed you to merge pdf's together. I never got a chance to use it, but I do remember seeing some CF examples for it as well. HTH, Tim Painter - Original Message - From: "Nathan Stanford" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 11:40 AM Subject: pdf merging? I know how to create a dynamic pdf however how do you merge several pdf's into the same document so the user can print the documents just once? Thanks, Nathan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding a space in a string..
Take the quotes off of tempdefendant; it's checking the string (which doesn't have any spaces) rather than a variable. -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 10:27 AM To: CF-Talk Subject: Finding a space in a string.. Hi dee ho all, Would this find a space in a string? CFSET pos= #Find(Chr(20),'tempdefendant')# Because..it ain't working for some reason. I also tried CFSET pos= #Find(' ','tempdefendant')# BUt that results in POS being 0 all the time. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: crystal report report
Ben, Thank you very much! - Original Message - From: "Braver, Ben" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 12:03 PM Subject: RE: crystal report report I get this periodically due apparently to a memory leak in an ODBC driver or something. What solves it immediately is stopping and restarting the CF services. There was a cf-talk thread on Wed. 3/21: Stopping/starting CF with NT "AT" that addressed doing this automatically with CF running on NT or Win2K. HTH. Ben -Original Message- From: Chang Liu [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 8:50 AM To: CF-Talk Subject: crystal report report Hi all, here is my code: CFREPORT REPORT="Report1.rpt" {Class.Class_ID} = "3" /CFREPORT here is my Error Diagnostic Information: Report not completed (the report server was busy) The requested report could not be completed because the server was extremely busy serving other report requests. Please notify the site administrator that the default TIMEOUT for the report server should be increased. any ideas? thanks a lot! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Northpoint DSL shutting down all operations
If any of you have DSL connections to the net, you should aware that Northpoint, one of the primary backbone DSL providers is shutting down all operations effective immediately. Even if they are not your primary vendor, there is a good change they are the supplier to your vendor, so you should check. http://www.northpointcom.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: freelance board
a while back someone posted a link to a site where you can go to bid on public contracts for development etc. Happen to remember the URL? thanks, -chris.alvarado [developer] - VerticalNet This message is intended only for the use of the Addressee(s) and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, dissemination of this communication is prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify [EMAIL PROTECTED] immediately. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Very, very, very bad day
Hey all, early this morning, I was working on project A. I needed a javascript image roll over template so I opened up an FTP from another project (which we'll call project B) i did way back, and downloaded the template. I was using FTP explorer to do this. I worked a few more hours, then set an alarm to wake myself up so I can FTP Project A to the hosting computer. When I woke up, there was no alarm, i guess i didn't set it right, and i was VERY late for work, so i rushed and dragged Project A's files into the FTP explorer, not realizing that it was connected to the Project B's site, not Project A. I screamed as I tried to press cancel. The index files have been replaced, and so have the images, because I used the same naming scheme now, i suck. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Database Images
This is a multi-part message in MIME format. --=_NextPart_000_0002_01C0B382.A20C2840 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit When you store an image in the database, how do you go about displaying it on the HTML page? Right now, I am simply storing the URL in the DB to the image file on the hard drive, but looking to storing them in the actual SQL Server dataabase as another solution. I just wanted to find out how one would go about doing this and get any feedback from those who have used this technique. Brad Squires --=_NextPart_000_0002_01C0B382.A20C2840 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR/HEAD BODY DIVFONT face=3DArial size=3D2SPAN class=3D250591518-23032001When = you store an=20 image in the database, how do you go about displaying it on the HTML = page? Right=20 now, Inbsp;am simply storing the URL in the DB to the image file on the = hard=20 drive, but looking to storing them in the actual SQL Server dataabase as = another=20 solution. I just wanted to find out how one would go about doing this = and get=20 any feedback from those who have used this = technique./SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D250591518-23032001/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN class=3D250591518-23032001Brad=20 Squires/SPAN/FONT/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_0002_01C0B382.A20C2840-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists