RegEx to strip HTML
Does anyone know a RegEx to strip HTML tags from a string? I've done a search but can't make sense of the RegEx's that have turned up (Perl - eek! what's that?!? - j/k ;-) Thanks -- 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: RegEx to strip HTML
cfset VAR = REReplace(VAR, "[^]*", "", "All") If theres a text : sometag lalalala sometag bababa it will remove the sometag's and return "lalalalala babababa" Tom Espen Pedersen developer www.pixelduck.com - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 10:58 AM Subject: RegEx to strip HTML Does anyone know a RegEx to strip HTML tags from a string? I've done a search but can't make sense of the RegEx's that have turned up (Perl - eek! what's that?!? - j/k ;-) Thanks -- 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: Urgent (can any one help me out)
Hi Michael Thanx for yr suggestion. But i gone thru code. i feel its ok. i donno why its happening like this. Here i will be attaching that file. Pls can u spend yr valuable time on over it. I think u must understand that code. If any suggestion pls let me know. Thanx Ramesh --- Michael Dinowitz [EMAIL PROTECTED] wrote: Looks like you've got some bad code in one or more of the templates. It could be an outside resource that has to be CFLOCKed, could be a resource that's crashing. Whatever it is, the cause isn't CFSCHEDULE. Note the agent for each error. CFSCHEDULE uses an agent of CFSCHEDULE. This is something else (your own scheduler?) Here's what I'd do: 1. Check out any code that touched 'outside resources' like CFFILE, CFDIRECTORY, CFREGISTRY, etc. Lock all these exclusively. 2. Review the code for bugs and logic errors. 3. make sure the page runs outside of the scheduled event. 4. If worst comes to worst, call in an expert to look the code over. Hi everybody Here we have been facing the problem with scheduler tasks. Actually we r running 5 schedular tasks per day in different timings. One schedular task it generates 2 MB text file for report. We donno exactly what happend internally, but often system was crashing and giving the below message. Pls can any body help me out. Its very urgent. Pls let me know if u require any info in detail regarding this one. "Error","TID=330","12/08/00","19:02:08","128.88.255.122","Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; Aim Package version 1.07.8)","unknown exception conditionP CFMLInterpreterImp::writeEmergencyMessagePPDate/Time: 12/08/00 19:02:08BRBrowser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; Aim Package version 1.07.8)BRRemote Address: 128.88.255.122BRHTTP Referer: http://www.ordernet.asiapac.hp.com/ordernet/index.cfmP" And often we used to get this below error occurs. "Error","TID=160","12/11/00","10:06:28","128.88.255.34","Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)","unknown exception conditionP CFMLInterpreterImp::writeEmergencyMessagePPDate/Time: 12/11/00 10:06:28BRBrowser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)BRRemote Address: 128.88.255.34BRHTTP Referer: https://www.ordernet.asiapac.hp.com/ordernet/send_orderrequest/ezb_send_po_x ml.cfmP" Any body knows about regarding these TID nums. and have u guys faced such a kind of problems. IS there any changes do i need to do in coldfusion administrator.. Pls help me out asap.. Thanx in advance Ramesh ~~ 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: CF-Talk-list V1 #23
Could anybody tell me where can I find more info. about when the ColdFusion 5 is going to launch, what's new in it and will there be anything regarding Java. Anything regarding this is welcome. Rajesh Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
unknown exception condition TagCFMail::sendMessage
Hello, I have a wierd error after sending eMail to a list: Looks like this: addresses (Records=2, Time=12ms) SQL = SELECT interessent_email FROMinteressenten WHERE kunden_id = 'xyz' AND interessent_rubriken LIKE '%[abcdefghij]%'; Error Occurred While Processing Request Error Diagnostic Information unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (37:1) to (41:35). ^ Has somebody an idea, what this is??? How I can cure 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: RegEx to strip HTML
cfset VAR = REReplace(VAR, "[^]*", "", "All") If theres a text : sometag lalalala sometag bababa it will remove the sometag's and return "lalalalala babababa" Thanks a lot - I'll give that a go. -- 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: CF/JRun Studio
So does anyone know, is it OK to have them both installed so long as you only have one open at a time? I *was" planning to install JRun Studio later this week but now I'm not so sure... Is this the same as the Homesite/CF Studio problem that was discussed on the list a while ago? Nick -Original Message- From: Lord, Heath [mailto:[EMAIL PROTECTED]] Sent: Monday, December 11, 2000 5:23 PM To: CF-Talk Subject: RE: CF/JRun Studio Yes. It hosed my install when I tried having them both open at the same time. However, I was so frustrated at this point that I uninstalled JRUN Studio and CF Studio, did the CF Studio reinstall, and that's all I use now. Heath ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: squished table phenomenon - please help!
call me cynical but... spam anyone? -Original Message- From: C Kong [mailto:[EMAIL PROTECTED]] Sent: 12 December 2000 06:59 To: CF-Talk Subject: Re: "squished" table phenomenon - please help! thank you greg, bob, jon hall, scott wood, jennifer, and remyomi! help very much appreciated and it worked! i've actually printed out all the advice each one of you have given me and they are sitting in a file, so when i win the powerball lottery soon, i will rememebr you all! thank you again guys! colin ~~ 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: unknown exception condition TagCFMail::sendMessage
Can you give us your whole cfquery / cfmail ? Uwe Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de - Original Message - From: "Stadie" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 11:45 AM Subject: unknown exception condition TagCFMail::sendMessage Hello, I have a wierd error after sending eMail to a list: Looks like this: addresses (Records=2, Time=12ms) SQL = SELECT interessent_email FROMinteressenten WHERE kunden_id = 'xyz' AND interessent_rubriken LIKE '%[abcdefghij]%'; Error Occurred While Processing Request Error Diagnostic Information unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (37:1) to (41:35). ^ Has somebody an idea, what this is??? How I can cure 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: squished table phenomenon - please help!
call me cynical but... spam anyone? How can thanking someone be called spam? He was obviously joking about the lottery at the bottom, but it certainly doesn't look like spam to me... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: squished table phenomenon - please help!
call me cynical but... spam anyone? OK, you're cynical. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: outlook
Sorry about the OT question, but was wondering if anyone knows a way to make all messages I recieve from this list get marked as read automatically? I just am not wanting my email notification going off every 10 minutes but still want it to alert me when other mail arrives. I am using Outlook 2000. Why not just move the CF-Talk messages to another folder? Create a Folder, Move a message into that folder, Click "Organize", change the first option to "sent to" and click Create It'll now automatically shift all CF-Talk messages to your CF-Talk folder, that way you can see all other messages in your InBox Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: 12 December 2000 04:59 To: CF-Talk Subject: OT: outlook Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 ~~ 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: SQL question
Whew . . . I'm still in one piece after that wind last night . . . What's the best way to query a column in a table that has a comma delimited list? For example, in the query below: If B_xRef is a comma delimited list, what's the most effecient way to find all the Table_b rows that contain the value of A_xRef (which is a single value) SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE A.A_xRef IN B.B_xRef (or something to this effect?) Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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: schedule help
Absolutely not. There are two ways taht you can CFSCHEDULE. One that lets you write the code and it will automatically make teh schedule for you on the admin side without have to dole out admin privileges to every developer and the other is to actually make it on the admin side. I did a CFSchedule and I actually didn't like it. My situation was one where I had this really long loading .cfm file and needed to get a static ..htm version of the .cfm file. Well, I got the page but it made a .htm page with all that white space that is emblematic of the processing that is going on the server side with .cfm file. So the actual .htm file, neglecting the white space, was a 10 kb file but the file cfschedule made was 739 kb, so it took equally as long as the actual .cfm file. I heard from a friend that CF 4.5 would get rid of this white space or you can use reg script to take care of the .htm file with all the white space. Good luck. Rob From: Scott Wood [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: schedule help Date: Mon, 11 Dec 2000 21:20:49 -0700 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBBFF1F430066D821EECECF1F7A8CBCA04; Mon Dec 11 23:33:02 2000 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Mon, 11 Dec 2000 23:33:33 -0500 From [EMAIL PROTECTED] Mon Dec 11 23:34:21 2000 Message-id: [EMAIL PROTECTED] I have never used Cfschedule but you should be able to simply place that file in each directory that is being used. In doing this, the CF applicaion server will pick it up.. Hope that helps.. (Ihave the same problem w/ my service provider).. G. Scott Wood Developer HMWeb.com 520-742-2611 Ext.135 -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 11, 2000 9:07 PM To: CF-Talk Subject: schedule help Do you have to have access to the CF Administrator in order to make use of cfschedule? My ISP won't give me access for some strange reason (grin) but looking at the docs it seems like I should just be able ti use the tag. Yes? If that's so, is this code that I need to make a specific page run once every hour? cfschedule action="UPDATE" url="http://www.crazycanines.com/mypage.cfm" task="aname" operation="HTTPRequest" startdate="12/05/00" starttime="10:00 AM" interval="3600" Thanks for any help you can give me. jay ~~ 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: CF_ThreeSelectsRelated nate Weiss
Hi Fng, Nate is a busy guy and his tag is open source, so you can s=do the mod yourself. The issue is (') in JavaScript, you need to escape it like this:- \' Luckily CF has a built in function to do this called JSStringFormat() Use this and your problems should be solved. It's good to know about the tags you use too.. Justin MacCarthy -Original Message- From: FARRAH NG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 1:41 AM To: CF-Talk Subject: CF_ThreeSelectsRelated Hi Nate Weiss, I have download the CF_ThreeSelectsRelated you have created. I ran a SQL server query to retrieve the Section ID, Department ID and the name of the Manager belongs to that department and section. The problem some of the names in our SQL server has quote or double quotes, like 0'Connor or O'Hara and your custom tag cannot populate the box where the manager name should go. Please advise how i should modify your tag to take of this situation. I tried to put the DE function in the evaluate statements but it does not solve the problem. I would appreciate much if some insight will be given. thanks Fng -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today for FREE account at http://www.hotvoice.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: SQL question
Bad batch of Chilli? -Original Message- From: Dave Hannum [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 12:33 PM To: CF-Talk Subject:OT: SQL question Whew . . . I'm still in one piece after that wind last night . . . What's the best way to query a column in a table that has a comma delimited list? For example, in the query below: If B_xRef is a comma delimited list, what's the most effecient way to find all the Table_b rows that contain the value of A_xRef (which is a single value) SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE A.A_xRef IN B.B_xRef (or something to this effect?) Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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: LDAP using CF? OT
There is a LDAP tag in ColdFusion, is this what you want? Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 1:12 AM To: CF-Talk Subject: LDAP using CF? OT Hi guys, Anyone know of a way to connect LDAP to a odbc datasource? Once there the CF can run, so yes, this off topic sorry... Any help would be helpful... -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
Webserver and win 2000 Help
I have just upgraded to win 2000 and all works fine however I cannot get the personal webserver to allow me to view my local server at http://127.0.01 etc etc nor allow cf studio to browse the cf pages any words of wisdom would be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.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: Testing for dates in a span
Well, let me make sure first - you are dealing with real dates, right? Not string representations of dates? Dealing with real dates, you can use simple compare operations - LT, EQ and GT to bracket a range. If you're dealing with stringsuI'd really suggest that you get them into date format ;) I'm not entirely sure what you mean by span. I presume that you're talking about a date range. What I see that you'll need is 2 if statements, each with 4 compare sections. Probably easier just to write it out. If you're not doing anything with dates that are in both ranges, just write the conditions so it ignores them. CFIF ( ( (myDate GT oldBeginDate) AND (myDate LT oldEndDate) ) AND NOT ( (myDate LT newBeginDate) AND (myDate GT newEndDate) ) ) !--- date is in the range of old but not new --- /CFIF Brian -Original Message- From: Chris Martin [mailto:[EMAIL PROTECTED]] Sent: Monday, December 11, 2000 5:17 PM To: CF-Talk Subject: Testing for dates in a span Hey everyone. I was wondering if it is possible to check if a given dates exists in a span (maybe and InSpan() function?) Basically, I need to create two spans, old and new. Any date that is in old, but not in new, must be deleted. Any dates that are in new but not old must be added. Any dates that are in both old and new can be left alone. The way things look now, I think its going to take lots of cfif, cfelseif, cfesle statements. Anyone have any ideas? thanks, Chris Martin ~~ 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
CFFTP error code 1
I am getting a Cold Fusion error code 1 every time I try to connect by FTP with CFFTP. The codes should be correct because this option worked correctly before I formated and reinstalled everything. The FTP server and the account used work fine. I connnected with different FTP clients. What could cause this error and how can I fix it? ~~ 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: SQL question
There's no nice way that I know of (putting a list in a field is a relational database no-no); the specific kludge would depend on what sort of database you're using. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 7:33 AM To: CF-Talk Subject: OT: SQL question Whew . . . I'm still in one piece after that wind last night . . . What's the best way to query a column in a table that has a comma delimited list? For example, in the query below: If B_xRef is a comma delimited list, what's the most effecient way to find all the Table_b rows that contain the value of A_xRef (which is a single value) SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE A.A_xRef IN B.B_xRef (or something to this effect?) Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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: SQL question
There isn't really a good way, because this not a RDBMS-friendly way of storing the data. Once the list is stored in a database, it's just a text field like any other.CF knows that a string can also be a list, but SQL doesn't. You would need to normalise the data, i.e. store each item in the list as a separate record, if you're after an efficent solution. Nick -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 12:33 PM To: CF-Talk Subject: OT: SQL question Whew . . . I'm still in one piece after that wind last night . . . What's the best way to query a column in a table that has a comma delimited list? For example, in the query below: If B_xRef is a comma delimited list, what's the most effecient way to find all the Table_b rows that contain the value of A_xRef (which is a single value) SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE A.A_xRef IN B.B_xRef (or something to this effect?) Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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: SQL question
It's in an MS SQL Server 7 - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 8:30 AM Subject: RE: SQL question There's no nice way that I know of (putting a list in a field is a relational database no-no); the specific kludge would depend on what sort of database you're using. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 7:33 AM To: CF-Talk Subject: OT: SQL question Whew . . . I'm still in one piece after that wind last night . . . What's the best way to query a column in a table that has a comma delimited list? For example, in the query below: If B_xRef is a comma delimited list, what's the most effecient way to find all the Table_b rows that contain the value of A_xRef (which is a single value) SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE A.A_xRef IN B.B_xRef (or something to this effect?) Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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: SQL question
If it's SQL you cold use the Like statement perhaps: SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE B.B_xRef LIKE '%' + A.A_xRef + '%' but it aint that efficient -- Andrew Ewings Project Manager 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 419 4235 -- 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 12 December 2000 13:31 To: CF-Talk Subject: RE: SQL question There's no nice way that I know of (putting a list in a field is a relational database no-no); the specific kludge would depend on what sort of database you're using. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 7:33 AM To: CF-Talk Subject: OT: SQL question Whew . . . I'm still in one piece after that wind last night . . . What's the best way to query a column in a table that has a comma delimited list? For example, in the query below: If B_xRef is a comma delimited list, what's the most effecient way to find all the Table_b rows that contain the value of A_xRef (which is a single value) SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE A.A_xRef IN B.B_xRef (or something to this effect?) Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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: ColdFusion to make bar codes
Ahh .. sorry. I forgot to mention that. I'm just used to developing for Intranet settings where stuff like that usually isn't a problem :) Todd Ashworth - Original Message - From: "Top-Link Tech (John Ceci)" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 11, 2000 12:39 PM Subject: RE: ColdFusion to make bar codes | Side note to Todd's response, the user will have to have the font installed | to see it properly... ~~ 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: Online Auction Software
AbleCommerce has an auction software package that looks pretty darn good and there is also http://www.beyondsolutions.com/ .The BeyondSolutions looked decent and highly configurable. Just a couple avenues to investigate for you. Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. Check out the ALL NEW www.InvadingSpecies.com site as well as the rest of our lineup... www.OFAH.org - The flagship site for the O.F.A.H. www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom tag Cf_Excel - error
Hi, We've been using the custom tag Cf_Excel. (the custom tag allows to take write a dynamic query and output the contents of that query to MS Excel.) It worked fine until we had to reinstall all our server. (coldfusion server + IIS + Mspackoffice) Now, we've got the 405 http error (405 Method Not Allowed). To obtain the excel spreadsheet, we've got to put the following url : (the ct_excel tag is on the whatever.cfm page a href="whatever.cfm/excelfile.xls"Download/a When We try the following syntax : a href="whatever.cfm?excelfile.xls"Download/a (note the "?" instead of "/", it opens coldfusion studio and the opened file contains the data of the spreadsheet ! We tried another test: we cut the file extension like: a href="whatever.cfm?excelfile"Download/a , that launchs a message box allowing to download the file. We don't want to download the file, we want that the contents of the query appears in an excel spreadsheet which itself is contained in browser. Do you have any idea of what we could have forgotten in the configuration of the server? Thanks in advanced Laure ~~ 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: unknown exception condition TagCFMail::sendMessage
This error is a CF4.5 bug. I think you can get rid of it by installing the latest service pack (at least I hope you can). At 05:45 AM 12/12/2000 , you wrote: Hello, I have a wierd error after sending eMail to a list: Looks like this: addresses (Records=2, Time=12ms) SQL = SELECT interessent_email FROMinteressenten WHERE kunden_id = 'xyz' AND interessent_rubriken LIKE '%[abcdefghij]%'; Error Occurred While Processing Request Error Diagnostic Information unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (37:1) to (41:35). ^ Has somebody an idea, what this is??? How I can cure 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: CF/JRun Studio
I loaded both on the same Win2k machine. Luckily it didn't break anything, but Jrun Studio won't run at all. That is extremely annoying since I would like to be able to use both. Has anyone figured out a sneaky way to get them both to run? Also .. on a side note: Don't install JRun server on you CF machine either. Things just start going way screwy when you have CF Studio, Server, Spectra, JRun Studio, and Server all on one machine ;) Can't we all just get along? Todd Ashworth - Original Message - From: "Lord, Heath" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 11, 2000 12:22 PM Subject: RE: CF/JRun Studio | Yes. | It hosed my install when I tried having them both open at the same time. | However, I was so frustrated at this point that I uninstalled JRUN Studio | and CF Studio, did the CF Studio reinstall, and that's all I use now. | | Heath | | -Original Message- | From: Dylan Bromby [mailto:[EMAIL PROTECTED]] | Sent: Friday, December 08, 2000 11:47 PM | To: CF-Talk | Subject: CF/JRun Studio | | | Has a JRun Studio install hosed anyone else's CF Studio? ~~ 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: Webserver and win 2000 Help
Edit your "hosts" file in your c:\winnt\system32\drivers\etc\hosts file. Something like this: 127.0.0.1 localhost Then run the command "nbtstat -R" You can also add additional mappings to this file as needed. Also, check in IIS to make sure you have index.cfm listed as in the default documents list. Hope this helps. Shane Witbeck -- Original Message -- From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 12 Dec 1997 22:41:27 +1000 I have just upgraded to win 2000 and all works fine however I cannot get the personal webserver to allow me to view my local server at http://127.0.01 etc etc nor allow cf studio to browse the cf pages any words of wisdom would be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.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
cflocation on IE 5.0 for Mac
Hello, It looks like any CFLOCATION with more than one variable attached does not work in IE 5.0 for the Mac. Has anyone found a workaround to this? Example code: cflocation url = "nextPage.cfm?CountID=#CountID#AcctID=#AcctID#UserLevel=#UserLevel#" Thank you very much for any help! Craig ~~ 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: CF/JRun Studio
I have them both installed and I don't have any problems. I have not opened them at the same time though. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 5:14 AM To: CF-Talk Subject: RE: CF/JRun Studio So does anyone know, is it OK to have them both installed so long as you only have one open at a time? I *was" planning to install JRun Studio later this week but now I'm not so sure... Is this the same as the Homesite/CF Studio problem that was discussed on the list a while ago? Nick -Original Message- From: Lord, Heath [mailto:[EMAIL PROTECTED]] Sent: Monday, December 11, 2000 5:23 PM To: CF-Talk Subject: RE: CF/JRun Studio Yes. It hosed my install when I tried having them both open at the same time. However, I was so frustrated at this point that I uninstalled JRUN Studio and CF Studio, did the CF Studio reinstall, and that's all I use now. Heath ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Webserver and win 2000 Help
I'd add the MS loopback adapter to you network settings... Justin -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 1:49 PM To: CF-Talk Subject: Re: Webserver and win 2000 Help Edit your "hosts" file in your c:\winnt\system32\drivers\etc\hosts file. Something like this: 127.0.0.1 localhost Then run the command "nbtstat -R" You can also add additional mappings to this file as needed. Also, check in IIS to make sure you have index.cfm listed as in the default documents list. Hope this helps. Shane Witbeck -- Original Message -- From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 12 Dec 1997 22:41:27 +1000 I have just upgraded to win 2000 and all works fine however I cannot get the personal webserver to allow me to view my local server at http://127.0.01 etc etc nor allow cf studio to browse the cf pages any words of wisdom would be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.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
Site Statistics
I'd like to set up my own custom site statistics page on my server which would count page views, etc... Has anyone done this in Cold Fusion before, or seen any pre-made scripts? If not, what advice would you give me prior to starting this? Thanks, Peter ~~ 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: CF/JRun Studio
I remember someone talking about a RunMultiple copy (something like that ) setting in the REG , but I have no idea what it does J -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 1:58 PM To: CF-Talk Subject: RE: CF/JRun Studio I have them both installed and I don't have any problems. I have not opened them at the same time though. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 5:14 AM To: CF-Talk Subject: RE: CF/JRun Studio So does anyone know, is it OK to have them both installed so long as you only have one open at a time? I *was" planning to install JRun Studio later this week but now I'm not so sure... Is this the same as the Homesite/CF Studio problem that was discussed on the list a while ago? Nick -Original Message- From: Lord, Heath [mailto:[EMAIL PROTECTED]] Sent: Monday, December 11, 2000 5:23 PM To: CF-Talk Subject: RE: CF/JRun Studio Yes. It hosed my install when I tried having them both open at the same time. However, I was so frustrated at this point that I uninstalled JRUN Studio and CF Studio, did the CF Studio reinstall, and that's all I use now. Heath ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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
Anyone else see this error?
This template works fine in my development environment. I've copied it every way I can think of to the test environment (identical to the development environment) and I get this error. I can't find any information on it at Allaire, so I'm looking for some input. Has anyone else encountered this? CF 4.0.1, Oracle8, NT, IIS all with latest service packs. Heath Error Occurred While Processing Request Error Diagnostic Information Cannot load template file E:\HOSTED_SITES\NEW.SR.COM\SOCCER\PLAYER\PLAYERPAGE.CFM The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted Date/Time: 12/12/00 08:59:57 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Template: E:\hosted_sites\new.sr.com\soccer\player\playerpage.cfm ~~ 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: SQL question
I don't believe this will work. At 01:32 PM 12/12/00 +, you wrote: SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE B.B_xRef LIKE '%' + A.A_xRef + '%' You could instead do a query to get a list of all the A_xRef and then do a CFLOOP over them with CFLOOP QUERY="MyQuery" CFQUERY blah.. SELECT B.B_xRef FROM Table_b B WHERE B.B_xRef LIKE '%#MyQuery.A_xRef#%' /CFQUERY /CFLOOP As the original poster of the above noted it's obviously not that efficient. best, paul ~~ 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: Anyone else see this error?
whats the NEW.SR.COM bit? seems a tad strange? maybe thats to do with the error.? N ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premium Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.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: SQL question
It should do. I've just tried it in SQL Server 7 and it seemed to. Try itlet me know what you het. You have to split up the % and the field name so that SQL can build the string. You will need to add a further 2 quotes if it is a characher field. i.e. WHERE B.B_xRef LIKE "'%" + A.A_xRef + "%'" -- Andrew Ewings Project Manager 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 419 4235 -- 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 12 December 2000 14:10 To: CF-Talk Subject: RE: SQL question I don't believe this will work. At 01:32 PM 12/12/00 +, you wrote: SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE B.B_xRef LIKE '%' + A.A_xRef + '%' You could instead do a query to get a list of all the A_xRef and then do a CFLOOP over them with CFLOOP QUERY="MyQuery" CFQUERY blah.. SELECT B.B_xRef FROM Table_b B WHERE B.B_xRef LIKE '%#MyQuery.A_xRef#%' /CFQUERY /CFLOOP As the original poster of the above noted it's obviously not that efficient. best, paul ~~ 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: IIS mappings from CF
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark, You may also want to take a look at some code Lewis Sellers has written to accomplish this exact task: http://www.intrafoundation.com/ihtkdocs/iis/docs/index.htm Aaron Johnson, MCSE, MCP+I MINDSEYE, Inc. phn617.350.0339 fax949.350.8884 icq66172567 [EMAIL PROTECTED] ___ "Never forget that only dead fish swim with the stream." -- Malcolm Muggeridge ___ - -Original Message- From: Picker, Mark P [mailto:[EMAIL PROTECTED]] Sent: Monday, December 11, 2000 7:39 PM To: CF-Talk Subject: IIS mappings from CF Hi All, I am working on a project and have come across a problem. I need a coldfusion page to setup some aspects of the IIS settings. I thought it would be simple and I would find the settings in the registry, but nope. :( Does anybody know how to access, change, create IIS settings from within CF? Thanks Mark Picker Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOjY0gDp1Dv+56bwcEQLelgCeIHkTpbO2M2zYFFOMZtAHKicv9WAAoL4d yVGNQIdXEhe/V0M0IjzAKI+o =qr0+ -END PGP SIGNATURE- ~~ 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: Anyone else see this error?
I got this error (or one very similar to it) once. Whenever I would save my page to the live server, my file would get screwed up. When I opened it, it was actually all garbled up. All of the tags were in the wrong order and they all had the wrong attributes. I tried deleting and resaving the file several times, but with no luck. I finally had to delete the copy on the development machine and the live machine and open a backup copy on the development machine and redo my changes. I have no idea what caused it and I haven't seen it happen since. Does your page look ok if you open it from the test machine? Todd Ashworth Web Developer/Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 - Original Message - From: "Lord, Heath" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 9:09 AM Subject: Anyone else see this error? | This template works fine in my development environment. I've copied it | every way I can think of to the test environment (identical to the | development environment) and I get this error. I can't find any information | on it at Allaire, so I'm looking for some input. Has anyone else | encountered this? | | CF 4.0.1, Oracle8, NT, IIS all with latest service packs. | | Heath | | | Error Occurred While Processing Request | Error Diagnostic Information | Cannot load template file | E:\HOSTED_SITES\NEW.SR.COM\SOCCER\PLAYER\PLAYERPAGE.CFM | | The template file exists, however, it either cannot be opened for reading, | or it is encrypted and its data has been corrupted | | Date/Time: 12/12/00 08:59:57 | Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) | Template: E:\hosted_sites\new.sr.com\soccer\player\playerpage.cfm ~~ 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: Anyone else see this error?
No, it is a virtual directory. Works fine, allows us to have several sites (via dsn) at the same ip address for development. Heath -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 9:21 AM To: CF-Talk Subject: RE: Anyone else see this error? whats the NEW.SR.COM bit? seems a tad strange? maybe thats to do with the error.? N ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premium Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.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: SQL question
I guess I had implicitly assumed only one row would match. You could fix it by testing for RecordCount NEQ 0 in each loop and incrementing a list. But the inefficiencies illustrate the inherent inefficiency of storing a list in a column if you want to query the column as you intend. As others have noted, depending on how much time this takes with your data, you might want to consider normalizing. best, paul At 09:15 AM 12/12/00 -0500, you wrote: Yea, that's not effecient. That could potentially generate 12 - 14 queries in the loop. You could instead do a query to get a list of all the A_xRef and then do a CFLOOP over them with CFLOOP QUERY="MyQuery" CFQUERY blah.. SELECT B.B_xRef FROM Table_b B WHERE B.B_xRef LIKE '%#MyQuery.A_xRef#%' /CFQUERY /CFLOOP As the original poster of the above noted it's obviously not that efficient. best, paul ~~ 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: Anyone else see this error?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Heath, Are you by chance using SourceSafe? I get that error message sometimes when I save a file in SS and then reload the page immediately. Usually fixes itself within a couple seconds. Aaron Johnson, MCSE, MCP+I MINDSEYE, Inc. phn617.350.0339 fax949.350.8884 icq66172567 [EMAIL PROTECTED] ___ "Never forget that only dead fish swim with the stream." -- Malcolm Muggeridge ___ - -Original Message- From: Lord, Heath [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 9:09 AM To: CF-Talk Subject: Anyone else see this error? This template works fine in my development environment. I've copied it every way I can think of to the test environment (identical to the development environment) and I get this error. I can't find any information on it at Allaire, so I'm looking for some input. Has anyone else encountered this? CF 4.0.1, Oracle8, NT, IIS all with latest service packs. Heath Error Occurred While Processing Request Error Diagnostic Information Cannot load template file E:\HOSTED_SITES\NEW.SR.COM\SOCCER\PLAYER\PLAYERPAGE.CFM The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted Date/Time: 12/12/00 08:59:57 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Template: E:\hosted_sites\new.sr.com\soccer\player\playerpage.cfm ~~ 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: Anyone else see this error?
Problem solved by restarting the service... Learn something new every day I guess. Yes, we are using sourcesafe, and we tried reloading several times, still failed. Oh well, restrating the server worked. Thanks all Heath -Original Message- From: Lord, Heath [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 9:09 AM To: CF-Talk Subject: Anyone else see this error? This template works fine in my development environment. I've copied it every way I can think of to the test environment (identical to the development environment) and I get this error. I can't find any information on it at Allaire, so I'm looking for some input. Has anyone else encountered this? CF 4.0.1, Oracle8, NT, IIS all with latest service packs. Heath Error Occurred While Processing Request Error Diagnostic Information Cannot load template file E:\HOSTED_SITES\NEW.SR.COM\SOCCER\PLAYER\PLAYERPAGE.CFM The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted Date/Time: 12/12/00 08:59:57 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Template: E:\hosted_sites\new.sr.com\soccer\player\playerpage.cfm ~~ 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: Bulk imports into database - what about ORACLE?
does anyone have any suggestions for bulk imports into oracle? is there an equivalent SQL statement for oracle? we have been using data junction, but we're looking for an in house solution. -mike -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 8:18 PM To: CF-Talk Subject: Re: Bulk imports into database I use the following for BULK INSERTs cfquery name="InsertInitial" DATASOURCE="#DSN#" USERNAME="#user#" PASSWORD="#pass#" BULK INSERT Victor FROM 'D:\FR\FileResource\101-200.csv' WITH ( FIELDTERMINATOR=',', ROWTERMINATOR=' ' ) /cfquery Very fast! best, paul At 03:06 PM 12/4/00 -0600, you wrote: Actually, Enterprise Manager is just a front-end to SQL Server, and you'd want to automate the "back end", not the "front end". For SQL Server, take a look at "BULK INSERT" (look in the Books Online). It allows you to take a text file containing your data, and bulk insert that data (duh) into a table you specify. The syntax is a bit trickier than that, but fairly simple. ~~ 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: Bulk imports into database - what about ORACLE?
does anyone have any suggestions for bulk imports into oracle? Have you got SQL*Loader? (it's an Oracle utility) Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: outlook
Make a rule for it, that's what I do, so that when it comes down from the server, it gets put into a folder and I believe that marking it read, mite be able to be setup up, not sure, or if your reading all the messages here, and not in your mail, just have a rule delete them upon download, which wont be permanent delete, unless you set the delete folder to permanently delete upon exit Philip Arnold - ASP wrote: Sorry about the OT question, but was wondering if anyone knows a way to make all messages I recieve from this list get marked as read automatically? I just am not wanting my email notification going off every 10 minutes but still want it to alert me when other mail arrives. I am using Outlook 2000. Why not just move the CF-Talk messages to another folder? Create a Folder, Move a message into that folder, Click "Organize", change the first option to "sent to" and click Create It'll now automatically shift all CF-Talk messages to your CF-Talk folder, that way you can see all other messages in your InBox Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: 12 December 2000 04:59 To: CF-Talk Subject: OT: outlook Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 ~~ 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: What are the recognized CF variable scopes?
Jeff, I'm with you. When I raised this issue in December '99, Dave Watts pointed out that just because you can do something doesn't mean that you should. -David On Wed 06 Dec 2000 Jeffry Houser [EMAIL PROTECTED] wrote: Shouldn't custom tags be coded to be as self-contained as possible? If you need to access values in the custom tag, wouldn't it make more sense to pass them as attributes to the custom tag, as opposed to globally defining them? ~~ 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: SQL question
I think a simple "like" will give you false matches - %1% can match1, 11, 121, etc. This is more complicated but I believe it will work: /* create table test_match (the_key int, the_sought varchar(50)) create table test_find (a_key int, finder varchar(50)) insert into test_match values (1, '1,2,3,4,10,11') insert into test_match values (2, '1,2,3,4,12') insert into test_find values (1, '10') insert into test_find values (2, '12') */ select test_match.the_key, test_find.a_key from test_match, test_find where (patindex('%,' + test_find.finder + ',%', test_match.the_sought) + patindex(test_find.finder + ',%', test_match.the_sought) + patindex('%,' + test_find.finder, test_match.the_sought)) 0 or of course you could normalize as others have recommended. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 8:30 AM To: CF-Talk Subject: Re: SQL question It's in an MS SQL Server 7 - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 8:30 AM Subject: RE: SQL question There's no nice way that I know of (putting a list in a field is a relational database no-no); the specific kludge would depend on what sort of database you're using. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 7:33 AM To: CF-Talk Subject: OT: SQL question Whew . . . I'm still in one piece after that wind last night . . . What's the best way to query a column in a table that has a comma delimited list? For example, in the query below: If B_xRef is a comma delimited list, what's the most effecient way to find all the Table_b rows that contain the value of A_xRef (which is a single value) SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE A.A_xRef IN B.B_xRef (or something to this effect?) Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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: Site Statistics
Advice. hhhm.. First off, list out exactly what stats you want and get them manually from the logs you will be using. Get an evaluation copy of Web Trends if you want to get some other ideas. I am assuming that you will be working with the raw logs from your web server. My advice on that is DON'T!!! Use CF to convert the logs to an ODBC database. If you have it converted, then great. That will make things a lot easier. Also make sure your web server is set to the fullest logging. With that you can get more detailed tracking of your users. Other than that, everything will be SQL queries. But to get your own statistics that make sense will take a lot of work. Planning will be very in-depth for this project. Oh, one last bit of advice. "Measure twice, cut once." Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 08:04 To: CF-Talk Subject: Site Statistics I'd like to set up my own custom site statistics page on my server which would count page views, etc... Has anyone done this in Cold Fusion before, or seen any pre-made scripts? If not, what advice would you give me prior to starting this? Thanks, Peter ~~ 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
Cookie problem
Is anyone haveing problems with CFCookie in Netscape version 4.76? We are writing a cookie and it works fine in all test versions of Internet Explorer and Netscape version 6. Any clues? TIA, Dolan Trout INFORMS, Inc. ~~ 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: What are the recognized CF variable scopes?
In essence, refering to variables outside the scope of a tag is analogous to using global variables in other languages, something that was frowned upon in the books I read and the courses I took. The proper way, then, would be to explicitly pass all necessary parameters to a tag, and eliminate the uncertainty. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: David Shadovitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, December 12, 2000 10:29 AM Subject: Re: What are the recognized CF variable scopes? Jeff, I'm with you. When I raised this issue in December '99, Dave Watts pointed out that just because you can do something doesn't mean that you should. -David On Wed 06 Dec 2000 Jeffry Houser [EMAIL PROTECTED] wrote: Shouldn't custom tags be coded to be as self-contained as possible? If you need to access values in the custom tag, wouldn't it make more sense to pass them as attributes to the custom tag, as opposed to globally defining them? ~~ 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: Site Statistics
Well I'm working with a small sized website, maybe 1000 hits per week. I'd like to track which pages are being viewed, which is about it. I thought about just incrementing a count in a DB or text file with each page view... I dunno. That's why I was asking the group. * -Original Message- * From: Russel Madere [mailto:[EMAIL PROTECTED]] * Sent: Tuesday, December 12, 2000 10:48 AM * To: CF-Talk * Subject: RE: Site Statistics * * * Advice. hhhm.. * * First off, list out exactly what stats you want and get them * manually from * the logs you will be using. Get an evaluation copy of Web * Trends if you * want to get some other ideas. * * I am assuming that you will be working with the raw logs * from your web * server. My advice on that is DON'T!!! Use CF to convert * the logs to an * ODBC database. If you have it converted, then great. That * will make things * a lot easier. Also make sure your web server is set to the * fullest logging. * With that you can get more detailed tracking of your users. * * Other than that, everything will be SQL queries. But to get your own * statistics that make sense will take a lot of work. * Planning will be very * in-depth for this project. * * Oh, one last bit of advice. * * "Measure twice, cut once." * * *Russel Madere, Jr. Senior Web Developer *ICQ: 5446158 http://www.TurboSquid.com * * Some days you eat the bear; some days the bear eats 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: Webserver and win 2000 Help
make sure you have maped .cfm in the mime file types for the serve your running. [EMAIL PROTECTED] 12/12/00 09:02AM I'd add the MS loopback adapter to you network settings... Justin -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 1:49 PM To: CF-Talk Subject: Re: Webserver and win 2000 Help Edit your "hosts" file in your c:\winnt\system32\drivers\etc\hosts file. Something like this: 127.0.0.1 localhost Then run the command "nbtstat -R" You can also add additional mappings to this file as needed. Also, check in IIS to make sure you have index.cfm listed as in the default documents list. Hope this helps. Shane Witbeck -- Original Message -- From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 12 Dec 1997 22:41:27 +1000 I have just upgraded to win 2000 and all works fine however I cannot get the personal webserver to allow me to view my local server at http://127.0.01 etc etc nor allow cf studio to browse the cf pages any words of wisdom would be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.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: Site Statistics
there's a nice tool we use for complete website stats... check it out it process mainly apache (ncsa) log format but with iis you have "convlog" which convert iis format to ncsa.. the best is to set logfile type in iis as ncsa. http://www.netstore.de/Supply/http-analyze/ demo stats: http://www.netstore.de/stats/ - Original Message - From: "Peter Benoit" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 4:53 PM Subject: RE: Site Statistics Well I'm working with a small sized website, maybe 1000 hits per week. I'd like to track which pages are being viewed, which is about it. I thought about just incrementing a count in a DB or text file with each page view... I dunno. That's why I was asking the group. * -Original Message- * From: Russel Madere [mailto:[EMAIL PROTECTED]] * Sent: Tuesday, December 12, 2000 10:48 AM * To: CF-Talk * Subject: RE: Site Statistics * * * Advice. hhhm.. * * First off, list out exactly what stats you want and get them * manually from * the logs you will be using. Get an evaluation copy of Web * Trends if you * want to get some other ideas. * * I am assuming that you will be working with the raw logs * from your web * server. My advice on that is DON'T!!! Use CF to convert * the logs to an * ODBC database. If you have it converted, then great. That * will make things * a lot easier. Also make sure your web server is set to the * fullest logging. * With that you can get more detailed tracking of your users. * * Other than that, everything will be SQL queries. But to get your own * statistics that make sense will take a lot of work. * Planning will be very * in-depth for this project. * * Oh, one last bit of advice. * * "Measure twice, cut once." * * *Russel Madere, Jr. Senior Web Developer *ICQ: 5446158 http://www.TurboSquid.com * * Some days you eat the bear; some days the bear eats 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: CF/JRun Studio
-Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] I remember someone talking about a RunMultiple copy (something like that ) setting in the REG , but I have no idea what it does J That just might actually work, I wish I could try it but I don't have Jrun Studio. The registry hack involves adding a new key. Open regedit, open HKCU/Software/Allaire/Studio45. Add a new key named "AllowMultipleInstances" and set its value to "1". On my machine I can have two instances of Studio running at once. Of course I never actually do that, but it's fun to be able to. In the case of JRun Studio, you may have to add a similar hack to it's registry entries. Maybe not. Good luck in this if you decide to try it. I should add that registry hacks can be harmful to your programs, so be careful. -- Bruce ~~ 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: RegEx to strip HTML
Tom, While we're on the subject of regex, do you know how to strip hidden characters from a string (chr(10) and the like)? Also, regex is not one of my strong suits, have you got any good links on the subject? Thanks -- Bruce -Original Message- From: Tom Espen Pedersen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 4:14 AM To: CF-Talk Subject: Re: RegEx to strip HTML cfset VAR = REReplace(VAR, "[^]*", "", "All") If theres a text : sometag lalalala sometag bababa it will remove the sometag's and return "lalalalala babababa" Tom Espen Pedersen developer www.pixelduck.com - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 10:58 AM Subject: RegEx to strip HTML Does anyone know a RegEx to strip HTML tags from a string? I've done a search but can't make sense of the RegEx's that have turned up (Perl - eek! what's that?!? - j/k ;-) Thanks -- 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: RegEx to strip HTML
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruce, Check out the function in CF: StripCR -- Returns string with all carriage return characters removed. For more information, check your studio docs. Aaron Johnson, MCSE, MCP+I MINDSEYE, Inc. phn617.350.0339 fax949.350.8884 icq66172567 [EMAIL PROTECTED] ___ "Never forget that only dead fish swim with the stream." -- Malcolm Muggeridge ___ - -Original Message- From: Bruce Heerssen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 11:08 AM To: CF-Talk Subject: RE: RegEx to strip HTML Tom, While we're on the subject of regex, do you know how to strip hidden characters from a string (chr(10) and the like)? Also, regex is not one of my strong suits, have you got any good links on the subject? Thanks - -- Bruce -Original Message- From: Tom Espen Pedersen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 4:14 AM To: CF-Talk Subject: Re: RegEx to strip HTML cfset VAR = REReplace(VAR, "[^]*", "", "All") If theres a text : sometag lalalala sometag bababa it will remove the sometag's and return "lalalalala babababa" Tom Espen Pedersen developer www.pixelduck.com - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 10:58 AM Subject: RegEx to strip HTML Does anyone know a RegEx to strip HTML tags from a string? I've done a search but can't make sense of the RegEx's that have turned up (Perl - eek! what's that?!? - j/k ;-) Thanks -- 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: Site Statistics
Shiloh Jennings has an app to do this for WebSite Pro: http://shiloh.shanje.com/utils/odbclogging/ best, paul At 09:48 AM 12/12/00 -0600, you wrote: I am assuming that you will be working with the raw logs from your web server. My advice on that is DON'T!!! Use CF to convert the logs to an ODBC database. If you have it converted, then great. ~~ 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: Access ODBC error
i am using the free CF hosting at CFresources, so i'm accessing the thing through an FTP account. Presumabley the ODBC datasource has been set for me. Yet when i run a simple insert or select * i get this error - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, i'm using an Access DB Thanx in advance ~~ 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
Help Desk App
Good Day, Looking for a good Help Desk Cold Fusion Application. Any Ideas??? Robert ~~ 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
Bug in CFFILE
I believe I've read on this list that there is a bug in CFFILE on CF 4.5.1? Is this correct? What is the nature of the bug? What specific versions including patch numbers are affected? Thanks in advance for you help. Benjamin Fitts Web Developer uclick, LLC www.uclick.com [EMAIL PROTECTED] Get your favorite comics emailed daily for FREE! Visit uComics.com - The best comics site in the universe! http://uComics.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: RegEx to strip HTML
Here's a link that I find useful... http://www.psyberspace.net/coldfusion/coding/strings/regex.cfm Brian -Original Message- From: Bruce Heerssen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 11:08 AM To: CF-Talk Subject: RE: RegEx to strip HTML Tom, While we're on the subject of regex, do you know how to strip hidden characters from a string (chr(10) and the like)? Also, regex is not one of my strong suits, have you got any good links on the subject? Thanks -- Bruce -Original Message- From: Tom Espen Pedersen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 4:14 AM To: CF-Talk Subject: Re: RegEx to strip HTML cfset VAR = REReplace(VAR, "[^]*", "", "All") If theres a text : sometag lalalala sometag bababa it will remove the sometag's and return "lalalalala babababa" Tom Espen Pedersen developer www.pixelduck.com - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 10:58 AM Subject: RegEx to strip HTML Does anyone know a RegEx to strip HTML tags from a string? I've done a search but can't make sense of the RegEx's that have turned up (Perl - eek! what's that?!? - j/k ;-) Thanks -- 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: Access ODBC error
Whats the url fo CFresources free hosting? -Original Message- From: war ape [mailto:[EMAIL PROTECTED]] Sent: 12 December 2000 16:22 To: CF-Talk Subject: Re: Access ODBC error i am using the free CF hosting at CFresources, so i'm accessing the thing through an FTP account. Presumabley the ODBC datasource has been set for me. Yet when i run a simple insert or select * i get this error - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, i'm using an Access DB Thanx in advance ~~ 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
from 12,000 to 12000
could someone share the easiest way to go from 12,000 to 12000. is there a function that does this? thanks for the help. keith ~~ 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 Desk App
What features are you looking for? -Original Message- From: netman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 10:17 AM To: CF-Talk Subject: Help Desk App Good Day, Looking for a good Help Desk Cold Fusion Application. Any Ideas??? Robert ~~ 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 Desk App
A fellow CFUGer has a company that has one. Their web site is at www.scorpiosoft.com. I haven't used the app, but it might be worth a look-see. Bob -Original Message- From: netman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 11:17 AM To: CF-Talk Subject: Help Desk App Good Day, Looking for a good Help Desk Cold Fusion Application. Any Ideas??? Robert ~~ 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 Desk App
Looking for Web Submission from users or techs, ticket tracking (status Que's, etc..). Technotes area would be nice. Just the basics or a little more. We also need to be able to atleast test it. Doesn't need to pretty, we can do that. Thanks, Robert Filipovich - Original Message - From: "Clint Tredway" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 11:47 AM Subject: RE: Help Desk App What features are you looking for? -Original Message- From: netman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 10:17 AM To: CF-Talk Subject: Help Desk App Good Day, Looking for a good Help Desk Cold Fusion Application. Any Ideas??? Robert ~~ 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: from 12,000 to 12000
cfset field_value = replace(field_value, "," , "") -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 11:47 AM To: CF-Talk Subject: from 12,000 to 12000 could someone share the easiest way to go from 12,000 to 12000. is there a function that does this? thanks for the help. keith ~~ 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: from 12,000 to 12000
#NumberFormat("12,000", "9")# Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: "Wurst, Keith D." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 11:47 AM Subject: from 12,000 to 12000 could someone share the easiest way to go from 12,000 to 12000. is there a function that does this? thanks for the help. keith ~~ 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: SQL 7 database transfer from one server to another
Check out sp_change_users_login to recover "phantom" logins. Works like a charm. best, paul At 02:47 PM 12/1/00 -0500, you wrote: There's one problem that I ran into with moving databases with sp_attach_db on SQL Server 7. If you've specified any logins for that database within the original database server, the database will still have those logins when you attach it to the new server. You won't be able to delete the logins, either; they'll be "phantom" logins. ~~ 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: OT: Mac images won't open on a PC
Neither PhotoShop nor Paintshop Pro give a t**s what colour format the file is in, it will only make a difference if you save it for web use without first converting it to RGB an no web browser (as far as I know) will support CMYK colour jpegs. Aside from that the original poster said he thought they were GIF files, and they are neither CMYK or RGB colour, they are indexed colour. - Original Message - From: "Chad Gray" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 11, 2000 10:25 PM Subject: Re: OT: Mac images won't open on a PC The files are probably in CMYK not RGB. At 09:21 PM 12/11/00 +, you wrote: Open the file in a text editor and the first few characters will tell you the file format. 8BIM is psd 8BPS is psd EPSF is eps JPEG is jpg GIFf is gif PDF is pdf TIFF is tif A more complete list is at http://www.macdisk.com/macsigen.php3 -- James Smith [EMAIL PROTECTED] Brainbench transcript ID: 822462 http://www.brainbench.com/transcript.jsp?pid=822462 - Original Message - From: "Daniel Lancelot" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 11, 2000 5:48 PM Subject: RE: OT: Mac images won't open on a PC If they are another format, use photoshop's File, open as command - then select a file and change the filetype. If you get anything appearing in the preview window, then youve got the correct format (probably best to try common formats first e.g. photoshop eps, psd, tif) HTH Dan -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: 11 December 2000 17:43 To: CF-Talk Subject: Re: OT: Mac images won't open on a PC It sounds as if the file extensions were mislabeled. In other words, they're not gifs. Since file extensions are unnecessary on macs, many mac users don't understand them. Some may even think that adding or changing an extension changes the file type. If they're an image format at all, Photoshop or something should open them even if they are a mac format like pict. HTH, Doug Jordon Jeff Fongemie wrote: This is so off topic, but I've failed everywhere else on this one! I'm working with a designer who gave me images as .gif files. Many of them won't open with anything on my PC. It's not a file naming thing, just won't open?? Photoshop won't open them, browser can't view them. I've worked with lots of other Mac users w/ no problems. Any idea on what's going on here?? Jeff Jeff Fongemie ___ Internet Developer For Hire http://www.fongemie.com ph: 603 356-6034 fax: 1 801 912 1692 ~~ 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 Desk App
As Bob mentioned you can test drive Virtual Help Desk (VHD). The link to the demo version is bellow. If you need more information send me an e-mail Thanks Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "netman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 12:11 PM Subject: Re: Help Desk App Looking for Web Submission from users or techs, ticket tracking (status Que's, etc..). Technotes area would be nice. Just the basics or a little more. We also need to be able to atleast test it. Doesn't need to pretty, we can do that. Thanks, Robert Filipovich - Original Message - From: "Clint Tredway" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 11:47 AM Subject: RE: Help Desk App What features are you looking for? -Original Message- From: netman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 10:17 AM To: CF-Talk Subject: Help Desk App Good Day, Looking for a good Help Desk Cold Fusion Application. Any Ideas??? Robert ~~ 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: from 12,000 to 12000
could someone share the easiest way to go from 12,000 to 12000. is there a function that does this? thanks for the help. Replace(myString,",","","all") will get rid of all commas Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
LDAP using CF? OT
Is anyone doing authentication without a cookie? Best ways? -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
code to compare cfquery recordsets?
Has anyone written a module to compare queries? I'd just like to know if two queries are identical or not, I don't care how they're different. --- Martin Herbener [EMAIL PROTECTED] Kentucky Department of Education ~~ 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
session variable problem
htmlDIVHi,/DIV DIVnbsp;/DIV DIVI am having the strangest problem with a session variable. I set it in my application.cfm file and this is the code:/DIV DIVnbsp;/DIV DIVlt;CFLOCK SCOPE="SESSION" TIMEOUT="30" TYPE="EXCLUSIVE"gt;BRlt;CFIF NOT IsDefined("session.UserID")gt;BRnbsp;lt;CFSET session.UserID = #GetVar.UserID#gt;BRlt;/CFIFgt;BRlt;/CFLOCKgt;/DIV DIVnbsp;/DIV DIV2 out of the 3 people where I work can use the website just fine. The 3rd person has their session variable set but when I try and output it, nothing shows up. I know the session variable has been set because if I do a lt;cfif isDefined("session.userid")gt; 'Yes I exist' lt;cfelsegt;I don't existlt;/cfifgt; Itnbsp; gives me a 'Yes, I exist'. I even deleted it by using lt;cfset structdelete("session.userid")gt; and ran the lt;cfifgt; statement again and it said 'I don't exist'. When I do lt;cfoutputgt;#session.Userid#lt;/cfoutputgt; nothing shows up? My website is dependent on the UserId to see certain pages so obviously it is not working for this 3rd person in my group. I'm stumped. Help, please./DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV DIVSal/DIVbr clear=allhrGet more from the Web. FREE MSN Explorer download : a href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html ~~ 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: session variable problem
check to see if they've got both cookies and in memory cookies turned on or off. - Original Message - From: "S R" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 12, 2000 1:02 PM Subject: session variable problem htmlDIVHi,/DIV DIVnbsp;/DIV DIVI am having the strangest problem with a session variable. I set it in my application.cfm file and this is the code:/DIV DIVnbsp;/DIV DIVlt;CFLOCK SCOPE="SESSION" TIMEOUT="30" TYPE="EXCLUSIVE"gt;BRlt;CFIF NOT IsDefined("session.UserID")gt;BRnbsp;lt;CFSET session.UserID = #GetVar.UserID#gt;BRlt;/CFIFgt;BRlt;/CFLOCKgt;/DIV DIVnbsp;/DIV DIV2 out of the 3 people where I work can use the website just fine. The 3rd person has their session variable set but when I try and output it, nothing shows up. I know the session variable has been set because if I do a lt;cfif isDefined("session.userid")gt; 'Yes I exist' lt;cfelsegt;I don't existlt;/cfifgt; Itnbsp; gives me a 'Yes, I exist'. I even deleted it by using lt;cfset structdelete("session.userid")gt; and ran the lt;cfifgt; statement again and it said 'I don't exist'. When I do lt;cfoutputgt;#session.Userid#lt;/cfoutputgt; nothing shows up? My website is dependent on the UserId to see certain pages so obviously it is not working for this 3rd person in my group. I'm stumped. Help, please./DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV DIVSal/DIVbr clear=allhrGet more from the Web. FREE MSN Explorer download : a href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html ~~ 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: session variable problem
At 10:02 AM 12/12/00 -0800, you wrote: Hi, I am having the strangest problem with a session variable. I set it in my application.cfm file and this is the code: CFLOCK SCOPE="SESSION" TIMEOUT="30" TYPE="EXCLUSIVE" CFIF NOT IsDefined("session.UserID") CFSET session.UserID = #GetVar.UserID# /CFIF /CFLOCK 2 out of the 3 people where I work can use the website just fine. The 3rd person has their session variable set but when I try and output it, nothing shows up. I know the session variable has been set because if I do a cfif isDefined("session.userid") 'Yes I exist' cfelseI don't exist/cfif It gives me a 'Yes, I exist'. I even deleted it by using cfset structdelete("session.userid") and ran the cfif statement again and it said 'I don't exist'. When I do cfoutput#session.Userid#/cfoutput nothing shows up? My website is dependent on the UserId to see certain pages so obviously it is not working for this 3rd person in my group. I'm stumped. Help, please. Try printing the session variable. If somehow the session variable were empty, it might still exist and this code would have these results if session.userid is "". Instead of printing "Yes I exist" print "User ID:"#session.userid# ~~ 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: Access ODBC error
On 12/12/00, war ape penned: Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, i'm using an Access DB Thanx in advance Sounds like a problem on the server. I've never seen that one if a datasource is named wrong or something. -- 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: session variable problem
At 12:35 PM 12/12/00 -0600, you wrote: At 10:02 AM 12/12/00 -0800, you wrote: Hi, I am having the strangest problem with a session variable. I set it in my application.cfm file and this is the code: CFLOCK SCOPE="SESSION" TIMEOUT="30" TYPE="EXCLUSIVE" CFIF NOT IsDefined("session.UserID") CFSET session.UserID = #GetVar.UserID# /CFIF /CFLOCK 2 out of the 3 people where I work can use the website just fine. The 3rd person has their session variable set but when I try and output it, nothing shows up. I know the session variable has been set because if I do a cfif isDefined("session.userid") 'Yes I exist' cfelseI don't exist/cfif It gives me a 'Yes, I exist'. I even deleted it by using cfset structdelete("session.userid") and ran the cfif statement again and it said 'I don't exist'. When I do cfoutput#session.Userid#/cfoutput nothing shows up? My website is dependent on the UserId to see certain pages so obviously it is not working for this 3rd person in my group. I'm stumped. Help, please. Try printing the session variable. If somehow the session variable were empty, it might still exist and this code would have these results if session.userid is "". Instead of printing "Yes I exist" print "User ID:"#session.userid# After rereading your message I see that you may have already tried this. Sorta. This is user tracking and it's probably hitting a database and querying for the logon id and password at the beginning. If there aren't any records returned but you don't check to see if there are records returned, and you set userid from the query set (which is empty), you will get this kind of problem. In other words, if you aren't testing for records to actually be returned by this query, instead of booting a bad login, you are allowing the person into the system with an empty userid. I'm not saying that this is necessarily what is happening, but it will cause the symptoms you mentioned. The user could be logging in incorrectly so no record is returned and this would be the effect. ~~ 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
Webmonkey Cart - anyone modified it?
An old client of mine has asked me to add some functionality to a shopping cart he has had done, it appears the people who did it used the example files from Webmonkeys CF Shopping cart tutorial with some modification to use worldpay. The requested functionality is to calculate shipping using UPS and the total weight of all items ordered (UK based site by the way). I was wondering if anyone had done anything similar or had any pointers? TIA ~~ 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: Why Won't CF4.5 run smoothly on Win2k?
Can you post your query that that this is trying to run when it errors? - Steve -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 9:20 AM To: CF-Talk Subject: Why Won't CF4.5 run smoothly on Win2k? Why won't CF4.5 run smoothly on Win2k and what on earth causes this error? The site worked fine a couple of days ago ... now it's throwing these errors left and right. Error Diagnostic Information unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag Joshua Miller Web Development Eagle Technologies Group, Inc. Business Solutions for the Next Generation www.eagletgi.com [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
OT: DBF into Access
Greetings I am producing a CF web application for a client who has his inventory available in a DBF file. Im developing in Access (for later conversion to SQL Server) and I want to be able to import their data into Access. If I import it as a DBF file I cant change field properties or anything. Is there a way to import it and convert into a native Access table? TIA Jonathan Karlen Jonathan R. Karlen President Karlen Internet Solutions, Inc. Web Site and Application Development http://www.karlen.com [EMAIL PROTECTED] (914)-923-2116 ~~ 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: cftransaction .. single threaded?
I understand that CF doesn't have the notion of constants, but I thought that by setting cfset application.constInt = 5 and by never changing it during the execution of the application in fact (for all practical purposes) we declared a constant. It seams that the general agreement among people on the list is that even in those cases we should use readonly locks (or set them up with request scope). Which probably is OK but if you have 100 (or more of those) to set them up for each page it looks to me like a waste of time (even if very small, which probably is less than having 50 readonly locks on each page). Ben Forta in the August edition of CFDJ said that if you are ABSOLUTELY sure that a variable (application,session or server) doesn't change you can leave out the readonly lock. So my question is: should we lock constants or no? I'd strongly recommend locking all instances of persistent memory variables (Session, Application, Server), no matter what. Ben Forta won't come out to fix your application if it crashes. If you would rather not have CFLOCKs sprinkled throughout your code, you have a couple of options. You could copy the Application scope to a structure in local memory at the top of a script which will need it. Or, if you want to emulate constants, you could simply use the Request scope, which is my recommendation. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List w/ delims
For the record: You can use more than one symbol for a list delimiter if you assign it to a variable first: cfset delim = "||*||" cfloop list="#list#" delimiter="#delim#". Don't ask why, it just works that way This really depends on what you mean by "using more than one symbol for a list delimiter". If you mean that you can use a multi-character string as a list delimiter, this is not the case. If, on the other hand, you mean that you can specify multiple characters, any one of which may be used as a delimiter, you don't need to assign those characters to a variable first. Here's a code sample that demonstrates both of these points. Both CFLOOPs will output the same thing - the numbers 1 through 4 on four separate lines. If you could specify a multi-character delimiter, one or both CFLOOPs would output "1:2" on the first line, then "3:4" on the second line. If assigining the characters to a variable first made a difference, the first one would output the numbers on four lines, and the second one would output two on each line. cfset demolist = "1:2:;3;4" cfloop list="#demolist#" index="i" delimiters=":;" cfoutput#i#/cfoutputbr /cfloop br cfset mydelims = ":;" cfloop list="#demolist#" index="i" delimiters="#mydelims#" cfoutput#i#/cfoutputbr /cfloop Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using JavaScript to validate non-cfinput fields in a cffor m
Is it possible to mix html form fields and cfinput fields in a page and use JavaScript to validate the html form fields while still using cfform validation for cfinput fields? You can certainly do this. Here's an example:... That doesn't work if you include a cfinput field like Paul originally asked. I just tested (see http://hksi.net/test-cfform.cfm) on CF4.5.1, and CF just writes the "return validateme(this)" at the end of it's auto-generated script that is triggered by the onsubmit event. The reference to "this", in that case, has no meaning to the script, and passes validation even with no value in IE5 SP1. True enough. This is a good point. Unfortunately, when I occasionally throw together a code sample, it's easy for me to forget some of the subtle issues that it might raise. I should have used a specific reference, instead of using the "this" reference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion vs. ASP.NET
I think just about everyone hates Dallas now, but I'm partial living in the D.C. area. It's a pretty nice area, I think. By the way, your clustering lesson at the DC CFUG last week was excellent. Thanks! I'm glad you enjoyed it! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LDAP using CF? OT
Is anyone doing authentication without a cookie? Best ways? There are two issues here. One is, how do you perform authentication. This doesn't have anything to do with cookies, generally. You have some list of users, and you check some information provided by a user against that list. The list can be stored anywhere you like - in a database, in an LDAP repository, in a file on the web server's filesystem, whatever. The other issue is, once you have authenticated a user, how do you maintain that user's information across multiple HTTP requests - how do you maintain state. Most developers rely on cookies for this, since they are very easy to use - "fire and forget", so to speak. You don't have to use cookies for this, though; you simply have to make sure that every page request from that user passes a unique token back to the server, either through the URL itself, through form data, or through cookies. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfapplication woes
I have a website with an application.cfm file; then I add a couple of tags from Allaire's developer's exchange each with their own application.cfm. If I just paste all in to my original I often get errors and sometimes the tag will have it's own variables which can/will conflict with my original ones. There's an acronym I've heard quite often: TANSTAFL "There ain't no such thing as a free lunch." The same is true with any free code you get from the developers' exchange. You'll have to integrate it, and possibly change it, so that it works within your applications. Most custom tags don't require their own Application.cfm, though. Can I have 2 cfapplications named separately in one application tag? If so how does cold fusion know when to end one cfapplication (as it doesn't have an closing tag) You can place two CFAPPLICATION tags in the same application.cfm, but you really, REALLY, don't want to do that. That certainly wouldn't be a best practice - or even an acceptable practice! Any help on best practices would be appreciated as I am now totally confused. Unfortunately, for best practices to get you out of trouble here, you'd have to adhere to them, and the developer who created the other code would also have to adhere to them. Since that developer may not have, you'll have to dig into the code and make it work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What is difference between Express, Professional Enterprise
Hi, was wondering if anyone knows what the nuts bolts functional differences are between Cold Fusion Express, Professional and Enterprise. At what stage does one need to go with Professional and then at what stage is it advisable to go for Enterprise vs. just getting a hardware based load balancing solution? I understand that CF Express does not have Verity or e-mail features. What other limitations differ it from Professional? Thanks. ~~ 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: Postgres CF - good marriage or doomed to divorce?
Does anyone have experience utilizing Postgres with CF or Interbase with CF? Am wondering how far either can scale before one needs to move to an Oracle, etc. ~~ 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 TIMES OUT ON LONG SCRIPT
I am running a script that, basically, loops over a file of about 225,000 lines (opened via CFFILE), parses the separate data elements from the fields in each line, puts each substring in a variable, then does an insert query of that record, using the variables, into a couple of tables in an MS SQL 2000 database. Once the entire file has been read, parsed and inserted, I clear the file variable, send a javascript document.write to an html fram to show the progressopen the next template (have also used a CFINCLUDE), which resets some flags in the database via an UPDATE. After the insert query, I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Any ideas? John Grubb ~~ 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: What is difference between Express, Professional Enterprise
TeraTech offers a tag poster which displays which tags are available in Express and which are not. The documentation on allaire.com also states the differences. I know CFUPDATE and CFINSERT are also not supported in CFExpress, if you use those. I also remember reading that express doesn't support CFOBJECT, though I may be mistaken. Coldfusion professional is a fully functional server, but doesn't come with the additional software included with enterprise. Enterprise is shipped with ODBC Drivers, a version of ClusterCats, and other nice amenities. I don't remember all the differences, to be honest... but allaire's site must offer documentation regarding the additional features you get when moving to the enterprise version of their server. ~Simon Simon Horwith Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 3:23 AM To: CF-Talk Subject: Re: What is difference between Express, Professional Enterprise Hi, was wondering if anyone knows what the nuts bolts functional differences are between Cold Fusion Express, Professional and Enterprise. At what stage does one need to go with Professional and then at what stage is it advisable to go for Enterprise vs. just getting a hardware based load balancing solution? I understand that CF Express does not have Verity or e-mail features. What other limitations differ it from Professional? Thanks. ~~ 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: What is difference between Express, Professional Enterprise
Hi, was wondering if anyone knows what the nuts bolts functional differences are between Cold Fusion Express, Professional and Enterprise. Yup, they are right here ColdFusion 4.5 Feature Comparison Matrix http://www.allaire.com/documentcenter/partners/CF45ServerFeatureMatrix.doc At what stage does one need to go with Professional and then at what stage is it advisable to go for Enterprise vs. just getting a hardware based load balancing solution? There are so many variables involved. There's no way for anyone to accurately answer that question without the intimate knowledge of your app that is impossible via mailing list. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 ~~ 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=upload accetps all file types
I've never used the CFFILE upload before, and I'm trying to limit uploads to gifs and jpegs. My syntax is: cffile action="upload" accept="image/gif, image/jpg, image/jpeg" etc but any format is accepted. I can test the content with cfif and file.contentsubtype variable, but isn't the cffile tag supposed to do this?. Has anyone ever encoutered this? TIA, Doug ~~ 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: SERVER TIMES OUT ON LONG SCRIPT
A reasonable guess: Servers have a limit on the number of transactions they can handle at one time without doing a commit. I don't remember specifics, so I'm not even going to guess at the size. From what I can see, this sounds like the server is filling up its transaction buffer and dumping you. You could do a commit after every X records, but that has a problem too; if your script crashes in the middle, you have some records that have been processed and some that haven't. With a file of 225K lines, that could get a little hairy to find the stopping point. Personally, I'd break the big file apart into smaller ones that the server can handle. Brian -Original Message- From: John Grubb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 3:31 PM To: CF-Talk Subject: SERVER TIMES OUT ON LONG SCRIPT I am running a script that, basically, loops over a file of about 225,000 lines (opened via CFFILE), parses the separate data elements from the fields in each line, puts each substring in a variable, then does an insert query of that record, using the variables, into a couple of tables in an MS SQL 2000 database. Once the entire file has been read, parsed and inserted, I clear the file variable, send a javascript document.write to an html fram to show the progressopen the next template (have also used a CFINCLUDE), which resets some flags in the database via an UPDATE. After the insert query, I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Any ideas? John Grubb ~~ 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=upload accetps all file types
That is a limitation of the browser. Use server side processing to see if the file is actually what you want. -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 2:56 PM To: CF-Talk Subject: cffile action="upload" accetps all file types I've never used the CFFILE upload before, and I'm trying to limit uploads to gifs and jpegs. My syntax is: cffile action="upload" accept="image/gif, image/jpg, image/jpeg" etc but any format is accepted. I can test the content with cfif and file.contentsubtype variable, but isn't the cffile tag supposed to do this?. Has anyone ever encoutered this? TIA, Doug ~~ 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: SERVER TIMES OUT ON LONG SCRIPT
I don't suppose the file is in comma or tab delimited format? Your message implies that. If it is, you can use it as a coldfusion datasource. That should significantly speed up the process. You can also use sql statements and CF together to step through the records if necessary. hth - Bruce -Original Message- From: John Grubb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 2:31 PM To: CF-Talk Subject: SERVER TIMES OUT ON LONG SCRIPT I am running a script that, basically, loops over a file of about 225,000 lines (opened via CFFILE), parses the separate data elements from the fields in each line, puts each substring in a variable, then does an insert query of that record, using the variables, into a couple of tables in an MS SQL 2000 database. Once the entire file has been read, parsed and inserted, I clear the file variable, send a javascript document.write to an html fram to show the progressopen the next template (have also used a CFINCLUDE), which resets some flags in the database via an UPDATE. After the insert query, I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Any ideas? John Grubb ~~ 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