RE: Filemaker connection
Chris - The table has to be *open* already (preferably on another machine or it'll be well slow) and we've had problems with Filemaker server - so use the Client instead. HTH, ask if it doesn't -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: 05 August 2000 00:38 To: [EMAIL PROTECTED] Subject: Filemaker connection I need to read some data from a filemaker 5 table. I've got the filemaker odbc stuff installed. I've configured the DSN. When I try to query from the database though, I get this error: ODBC Error Code = S0002 (Base table not found) [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Invalid database name. I know that the datasource is being seen, the database is named stuff.fp5 (and I've tried using stuff.fp5 as the name of the database as well...). My cfquery is: cfquery datasource="fmaker" name="fmakertest" select ID from stuff /cfquery Anyone else had luck querying a filemaker 5 table from cf (4.5.1) c -- Chris Lott -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Spectra/Coldfusion problems and any work arounds please:-)
Ok the 15360 was already there, I tried upsizing the policy store as you said and still it fails. Now if I haven't had any of these on the system before why does it refuse to work, I could imagine upsizing if the database was full of information but not from a fresh install of both Spectra/CF :-) I have tried everything now and still can't get it too work, and here in Australia the reps will charge $3k a day to fix the problem I don't have this sort of money. Allaire should come out sure, but not at that cost:-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, 7 August 2000 3:07 PM To: [EMAIL PROTECTED] Subject: Re: Spectra/Coldfusion problems and any work arounds please:-) Few things come to mind: (I'm assuming you are running them on Win2k Advanced Server and NT 4.0 Server, not the professional and workstation , respectively) 1. did you set the decimal value to 15360 in the HKEY_LOCAL_MACHINE\SOFTWARE\Netegrity\SiteMinder\CurrentVersion\Database (regedit) or at least at your server machine. If that doesn't work, try this: 2. Upsize your database from Access to SQL Server 7.0 for policy store. this following note is written by Raymond Camden: Your best bet is to upsize. Here is a URL on how to upsize to SQL Server: http://www.allaire.com/Handlers/index.cfm?ID=14566Method=Full Warning - you must be -very- careful when upsizing. If you run into problems, try the following two urls, they both detail various logging features you can turn on to help debug adv. sec. problems. I can say from experience that this process can be a bit frustrating at times, but I think Allaire knows this and is working on making it rock solid. Once you get it there, your good to go! http://www.allaire.com/Handlers/index.cfm?ID=14588Method=Full http://www.allaire.com/Handlers/index.cfm?ID=11432Method=Full Keep me posted- Rob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Forwarding mail which is sent to unknown postboxes ?
Problem ist solved: There is a function on the mail-server called: catchrest I took that and it works now. Thank you all. Uwe - Original Message - From: "Gordon Burns" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 05, 2000 8:57 PM Subject: Re: Forwarding mail which is sent to unknown postboxes ? At 19:02 05/08/00 +0200 cftalk said Howie, I know you didn't make an ad. It was just a joke. :-) But I have heard so many good news on IMS that I had to mention this. Ims is great because it is so configurable, this sort of thing is simple to do. It may be that the action you are looking for could be under the "unknown user action" or some such option with a similar name. This could be set for 1. Return mail to sender. 2. Send it to another mail address. 3. Reject mail altogether. What happens if you send mail to an unknown user at the moment? Does it bounce back to you or vanish! Gordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: (syntax) variable naming conventions
Also you might want to take a quick look at http://msdn.microsoft.com/library/backgrnd/html/msdn_20naming.htm "The Leszynski/Reddick Guidelines for Microsoft Access" which is based on Hungarian notation. Pretty clunky if you ask me though. I mean, you can tell a table name refers to a table without needing to put "tbl" in front. 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to limit size of upload files using CFFILE??
Unfortunately, that's not currently possible with JavaScript. The only client-side solution is signed applet of some sort, Java or ActiveX, that has file-system permissions. And even then the fact that they have access to a users harddrive/network is highly dubious and not something that should be encouraged as it is a massive security risk and prone to abuse. I would think Hotmail and Yahoomail and the like have some way of limiting the size of attachments before they're actually sent to the server... Hotmail certainly doesn't. If you upload a file attachment that it deems is too large then it just doesn't send it without telling you that it hasn't been sent! Sorry that I've not been of any help. Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFLOCK presentation
Sorry should have been a heading of RE: CFLOCK presentation. My bad guys -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 8:42 AM To: '[EMAIL PROTECTED]' Subject: RE: cf_location custom tag Before you give a smart comment over what I said, the least you could do is not just look at references for scope in the index of the Danesh book. All those pages you gave mention nothing about scope in cflock. They talk about other scopes. Look at your answers before you send them. My last comment still stands, in the Danesh book it says ColdFusion 4.5 but how they are showing locking is using the 4.x method. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 8:00 AM To: cftalk Subject: cf_location custom tag scope pp 451, 457, 505, 766, 139-141 cflock 4.5 pp 483 At 07:38 AM 7/08/00 , you wrote: I have it, it isn't showing 4.5 lock. Now where does it even mention scope in there. Bob Everland -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 11:45 PM To: [EMAIL PROTECTED] Subject: RE: CFLOCK presentation In addition to Jeremy's reference list, I'd also recommend Danesh's new book "Mastering Coldfusion 4.5" too. It has a fairly lucid presentation on using CFLock and also offers a different twist on the rest of CF than Ben's books. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 -Original Message- From: Ang=E9l Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 03, 2000 9:04 AM To: [EMAIL PROTECTED] Subject: Re: CFLOCK presentation snip It seems I need to do a lot more reading and research. Is there anything after Ben Forta's books to read on CF?? -Gel --- = - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_talk = or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- = --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit=20 http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_talk = or=20 send a message to [EMAIL PROTECTED] with 'unsubscribe' in= =20 the body. Seamus Campbell BookBusiness - Netinfo www.bookbusiness.com.au [EMAIL PROTECTED] ph 02 6297 4883 fax 02 6297 8464 mob 0416 055 171 In the Book Business? You need BookBusiness!=20 --=_7257365==_.ALT Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable scope pp 451, 457, 505, 766, 139-141 cflock 4.5 pp 483 At 07:38 AM 7/08/00 , you wrote: I have it, it isn't showing 4.5 lock. Now where does it even mention scope in there. Bob Everland -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 11:45 PM To: [EMAIL PROTECTED] Subject: RE: CFLOCK presentation In addition to Jeremy's reference list, I'd also recommend Danesh's new book "Mastering Coldfusion 4.5" too. It has a fairly lucid presentation on using CFLock and also offers a different twist on the rest of CF than Ben's books. Chris Montgomery= [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 -Original Message- From: Ang=E9l Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 03, 2000 9:04 AM To: [EMAIL PROTECTED] Subject: Re: CFLOCK presentation snip It seems I need to do a lot more reading and research. Is=20 there anything after Ben Forta's books to read on CF?? -Gel = -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?side= bar=3Dlistsbody=3Dlists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe'= in the body. = -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsa= mp;body=3Dlists/cf_talk or send a message to= [EMAIL PROTECTED] with 'unsubscribe' in the body.= Seamus Campbell BookBusiness - Netinfo www.bookbusiness.com.au = nbsp; [EMAIL PROTECTED] ph 02 6297 4883 fax 02 6297 8464 mob 0416= 055 171 In the Book Business? You need BookBusiness! --=_7257365==_.ALT--
RE: CF Studio
are you out of disk space? that was happening to me when my HD was full. Chris Olive, DOEHRS Website Administrator -Original Message- From: Ken M. Mevand [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 1:49 AM To: 02 cf-talk Subject: CF Studio anyone has experienced this - after saving a document in studio, close it, then open, the entire file is empty? this has happened many times, and is very, very costly. -ken -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: crystal reports and CF
You are correct that CR was bundled "at one stage", unfortunately it is no longer sold this way. I believe version 4.0 was the first to leave it out (someone correct me if I'm wrong here), so older books still refer to it as part of the ColdFusion package. There is a tag for calling Crystal Reports (CFREPORT), but it does not work well with the latest releases of Crystal Reports (version 8). If you really need Crystal Reports, I've been told it's best just to use Crystal's reporting engine rather that can pull from a database rather than trying to integrate it with ColdFusion. Norman Elton Information Technology College of William Mary On Mon, 7 Aug 2000, Phil Palmer wrote: Can anyone tell me how the licensing of Crystal Reports and CF works? I have documentation which implies that a version of Crystal comes with CF but I have scanned the disks for CF Server and CF Studio versions 4.0 and 4.5 but I cannot see it. It doesnt seem to have installed by default. Am I incorrect in assuming that it was bundled as part of CF at one stage? Regards Phil Palmer Technical Director Engage Technology Pty Ltd e [EMAIL PROTECTED] p 0414 353 246 w www.engagetechnology.com.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Do u us Intranets ?
Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif Kiamil Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [SNMP/MRTG Through ColdFusion]
CF 4.01/NT 4.0 and Cisco Routers. That's pretty much what I was asking, whether or not someone had written a front end for MRTG or, better yet, a fully functional app in ColdFusion. We'd prefer not to run Perl if at all possible, but if necessary, we'll put up a separate server for MRTG running Active Perl, at which point, we probably wouldn't even bother with the ColdFusion front end. It would be nice, however, to integrate MRTG or a similar app into everything else we're doing, especially if it involved one less server with one less application on running on it. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 9:07 PM To: [EMAIL PROTECTED] Subject: Re: [SNMP/MRTG Through ColdFusion] what version of CF are you using? what OS? what are you trying to accomplish? you could write a front end to the mrtg.cfg file but i am not sure if thats what your asking. "Benjamin S. Rogers" [EMAIL PROTECTED] wrote: Has anyone developed a tag/applet that talks SNMP? Better yet has anyone developed a ColdFusion app similar to MRTG (or even a ColdFusion MRTG wrapper)? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarÿstsbodyÿsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif, Sounds like you need to look in to a design methodology, that allows you to add/remove applications without it affecting other parts of the application as a whole. The method I use (and quite a lot of other CF developers worldwide) is Fusebox. See http://www.fusebox.org/ for more information. Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfindex error - try #2
Hi Folks, No one responded last time I posted this message, so I thought I'd try one more time. When attempting to index a collection on our production server, using the same code that works on the development server, I get the following error: Error occurred in tag CFINDEX Internal Error: Purge failed Error Code: -23 Any one encountered this before? Thoughts? -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
But a lot of the application need each other -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:26 To: [EMAIL PROTECTED] Subject: RE: Do u us Intranets ? Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif, Sounds like you need to look in to a design methodology, that allows you to add/remove applications without it affecting other parts of the application as a whole. The method I use (and quite a lot of other CF developers worldwide) is Fusebox. See http://www.fusebox.org/ for more information. Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: URL - UN - ENCODE - does this exist as function??
Look up 'URLEncodedFormat' 'URLDecode' ;) - Original Message - From: "PC" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 04, 2000 10:17 PM Subject: URL - UN - ENCODE - does this exist as function?? I can't seem to find the opposite of the illustrious urlencode function that CF provides .. I am hoping to be able to effciently translate encodings back to their original form ??? Any ideas?? TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
Do you know how to use the Debugging environment within ColdFusion Studio 4.5. Kwasi Date-Bah System Developer iMediapoint.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
Yea, but the Intranet is getting to big -Original Message- From: kwasi [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:47 To: '[EMAIL PROTECTED]' Subject: RE: Do u us Intranets ? Do you know how to use the Debugging environment within ColdFusion Studio 4.5. Kwasi Date-Bah System Developer iMediapoint.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
Then you should consider using the fusebox method with sub-fuseboxes. By 'need each other' do you mean that there are links to each other or that there is a coding dependency. I would suggest you need to look at what you have designed and remove interdependence if at all possible. Adam Reynolds -- From: Rif Kiamil[SMTP:[EMAIL PROTECTED]] Sent: 07 August 2000 14:19 To: '[EMAIL PROTECTED]' Subject: RE: Do u us Intranets ? But a lot of the application need each other -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:26 To: [EMAIL PROTECTED] Subject: RE: Do u us Intranets ? Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif, Sounds like you need to look in to a design methodology, that allows you to add/remove applications without it affecting other parts of the application as a whole. The method I use (and quite a lot of other CF developers worldwide) is Fusebox. See http://www.fusebox.org/ for more information. Regards Stephen -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Combo box
Hello everyone!!! Does anyone have some nifty code that lets me have a combo box, ie. an input type=text field combined with a collection of hardcoded choices in an input type=select? Do I just have text input field with the same name as the select box? How does this work? Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
REF: Enabling Debugging within ColdFusion Studio 4.5
how do you Enable Debugging within ColdFusion Studio 4.5? Kwasi Date-Bah System Developer iMediapoint.com Ltd [EMAIL PROTECTED] www.iMediapoint.com Office: 020 7598 3060 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
We have 100's of forums that are sales people use to do their job. When a form is submitted it is also logged under the Account Log application. But also the Call Sheet application may also log things on the account log. But some of the forums may change setting on the Call Sheets . To u get what I mean -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:46 To: '[EMAIL PROTECTED]' Subject:RE: Do u us Intranets ? Then you should consider using the fusebox method with sub-fuseboxes. By 'need each other' do you mean that there are links to each other or that there is a coding dependency. I would suggest you need to look at what you have designed and remove interdependence if at all possible. Adam Reynolds -- From: Rif Kiamil[SMTP:[EMAIL PROTECTED]] Sent: 07 August 2000 14:19 To: '[EMAIL PROTECTED]' Subject: RE: Do u us Intranets ? But a lot of the application need each other -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:26 To: [EMAIL PROTECTED] Subject: RE: Do u us Intranets ? Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif, Sounds like you need to look in to a design methodology, that allows you to add/remove applications without it affecting other parts of the application as a whole. The method I use (and quite a lot of other CF developers worldwide) is Fusebox. See http://www.fusebox.org/ for more information. Regards Stephen -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Single quotes in CF
Hello all, I am wrapping up my first project in Cold Fusion and I was wondering how CF handles the single quote issue. Currently, whenever I insert a record, I do the following: Insert into (name) values(replace(argument, "'", "''")) and that seems to work. Should I use the preservesinglequotes function to query a value which has a single quote in it? Any advice would be greatly appreciated. Thanks in advance, Brandon Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
We have 100's of forums that are sales people use to do their job. When a form is submitted it is also logged under the Account Log application. But also the Call Sheet application may also log things on the account log. But some of the forums may change setting on the Call Sheets . To u get what I mean Fusebox is ideal for that. Fusebox helps you build circuit applications, which are smaller applications within your larger app. You can call these smaller apps via form, url, cfmodule or even as a custom tag. What this means is that when you change one cicuit app, all the others don't change too. You simply keep calling you call sheet app in exactly the same way even though your application log app may have changed... Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
Do you change your databases or your code? Miguel Gonzalez www.ibcmass.com mailto:[EMAIL PROTECTED] -Mensaje original- De: Rif Kiamil [mailto:[EMAIL PROTECTED]] Enviado el: lunes 7 de agosto de 2000 15:01 Para: '[EMAIL PROTECTED]' Asunto: Do u us Intranets ? Importancia: Alta Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif Kiamil Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Combo box
This is a multi-part message in MIME format. --=_NextPart_000_001E_01C0005A.104ECBF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit A standard HTML select should do, no? Select multiple="no" name="whatever" size="1" OPTION value="choice1" OPTION value="choice2" OPTION value="choice3" OPTION value="choice4" OPTION value="choice5" /Select John McKown, VP of Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 - Dover, DE 19901 Dover: 302.736.5515, Toll Free: 888.432.7965, Fax: 302.736.5945 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] , Web Site: http://www.Delaware.Net Delaware.Net is now an official domain name registrar! Register your domain names with us for only $20 per year! Simply visit my company's web site at http://Register.Delaware.Net to get started. Or change your existing hosting to Delaware.net and save yourself money. -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 9:47 AM To: '[EMAIL PROTECTED]' Subject: Combo box Importance: High Hello everyone!!! Does anyone have some nifty code that lets me have a combo box, ie. an input type=text field combined with a collection of hardcoded choices in an input type=select? Do I just have text input field with the same name as the select box? How does this work? Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_NextPart_000_001E_01C0005A.104ECBF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLE/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR/HEAD BODY PFONT face=3DVerdana size=3D2A standard HTML select should do, = no?/FONT/P BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px" PFONT face=3DVerdana size=3D2STRONGlt;Select multiple=3D"no" = name=3D"whatever"=20 size=3D"1"gt;BRlt;OPTION value=3D"choice1"gt;BRlt;OPTION=20 value=3D"choice2"gt;BRlt;OPTION = value=3D"choice3"gt;BRlt;OPTION=20 value=3D"choice4"gt;BRlt;OPTION=20 = value=3D"choice5"gt;BRlt;/Selectgt;/STRONG/FONT/P/BLOCKQUOTE= PFONT size=3D2FONT face=3DVerdanaJohn McKown, VP of Business=20 ServicesBRDelaware.Net, Inc.BR30 Old Rudnick Lane, Suite 200 - = Dover, DE=20 19901BRDover: 302.736.5515, Toll Free: 888.432.7965, Fax:=20 302.736.5945BRE-mail: [EMAIL PROTECTED] lt;/FONTA=20 href=3D"mailto:[EMAIL PROTECTED]"FONT=20 face=3DVerdanamailto:[EMAIL PROTECTED]/FONT/AFONT = face=3DVerdanagt; , Web=20 Site: /FONTA href=3D"http://www.Delaware.Net" target=3D_blankFONT=20 face=3DVerdanahttp://www.Delaware.Net/FONT/ABRBRFONT=20 face=3DVerdana=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3DBRDelaware.Net=20 is now an official domain name registrar!BRRegister your domain names = with us=20 for only $20 per year!BRSimply visit my company's web site at = /FONTA=20 href=3D"http://Register.Delaware.Net" target=3D_blankFONT=20 face=3DVerdanahttp://Register.Delaware.Net/FONT/AFONT = face=3DVerdana to get=20 started.BROr change your existing hosting to Delaware.net and save = yourself=20 money.BR=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3DBRBRBRBRBRBRgt;=20 -Original Message-BRgt; From: Mike Deane [/FONTA=20 href=3D"mailto:[EMAIL PROTECTED]"FONT=20 face=3DVerdanamailto:[EMAIL PROTECTED]/FONT/AFONT=20 face=3DVerdana]BRgt; Sent: Monday, August 07, 2000 9:47 AMBRgt; = To:=20 '[EMAIL PROTECTED]'BRgt; Subject: Combo boxBRgt; = Importance:=20 HighBRgt;BRgt;BRgt; Hello everyone!!!BRgt;BRgt; Does = anyone have=20 some nifty code that lets me have a combo box, ie. anBRgt; input = type=3Dtext=20 field combined with a collection of hardcoded choices inBRgt; an = input=20 type=3Dselect?BRgt;BRgt; Do I just have text input field with the = same name=20 as the select box?BRgt; How does this work?BRgt;BRgt; Thank=20 you.BRgt; /mdeaneBRgt;=20 --BRgt= ;=20 BRgt; Archives: /FONTA=20 href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20 target=3D_blankFONT=20 face=3DVerdanahttp://www.mail-archive.com/cf-talk@houseoffusion.com//FO= NT/ABRFONT=20 face=3DVerdanagt; To Unsubscribe visitBRgt; /FONTA=20
Null Values check
Hi All, I am getting an error when I write a code like: cfif tempValue eq null ... /cfif If I write cfif tempValue eq "" ... /cfif Then the null values are not being checked. Can someone tell me how do you check for null values? Appreciate. A.B. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Null Values check
CF doesn't have any notion of NULL, you need to either cfif tempValue eq "" OR cfif not Len(tempValue) Steve -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 15:45 To: [EMAIL PROTECTED] Subject: Null Values check Hi All, I am getting an error when I write a code like: cfif tempValue eq null ... /cfif If I write cfif tempValue eq "" ... /cfif Then the null values are not being checked. Can someone tell me how do you check for null values? Appreciate. A.B. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Null Values check
Hi All, I am getting an error when I write a code like: cfif tempValue eq null ... /cfif If I write cfif tempValue eq "" ... /cfif Null values can't use EQ or =, you need to ask cfif tempValue is NULL -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Enabling Debugging within ColdFusion Studio 4.5
you need to set up developmental mapping and a start page Dana E. Johnson Sr. Web Developer CIT VTF/Technology Financing Services [EMAIL PROTECTED] (904) 620-7458 -Original Message- From: kwasi [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 8:59 AM To: '[EMAIL PROTECTED]' Subject: REF: Enabling Debugging within ColdFusion Studio 4.5 how do you Enable Debugging within ColdFusion Studio 4.5? Kwasi Date-Bah System Developer iMediapoint.com Ltd [EMAIL PROTECTED] www.iMediapoint.com Office: 020 7598 3060 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFOutput Group By
I am trying to group all messages together with the same subject for a forum. When I do that, I have to use CFOUTPUT group="subject" (where "Subject" is the field name). Here's the problem. I need the messages to be sorted by current date/time first and then by subject. Is there a way to use the ORDER BY clause in SQL to order the results by date/time and then also group the results by subject? Everytime I try to order by date, then by time, then by subject, it displays all the messages. Thanks in advance! Greg Albert -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Do u us Intranets ?
We also add new table to are MSSQL 7 database as well. But we don't change column names and we all most never add new columns to the tables. But the code can change a lot. Does any body run a big intranet? -Original Message- From: Miguel [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 15:26 To: '[EMAIL PROTECTED]' Subject:RE: Do u us Intranets ? Do you change your databases or your code? Miguel Gonzalez www.ibcmass.com mailto:[EMAIL PROTECTED] -Mensaje original- De: Rif Kiamil [mailto:[EMAIL PROTECTED]] Enviado el: lunes 7 de agosto de 2000 15:01 Para: '[EMAIL PROTECTED]' Asunto: Do u us Intranets ? Importancia: Alta Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif Kiamil Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to get part of string?
Won't that return: is a really It starts at position 6 and returns the next 11 characters? Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Shane Pitts [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 6:55 PM To: [EMAIL PROTECTED] Subject: RE: How to get part of string? CFSET original_string = "this is a really short message" CFSET new_string = mid(original_string, 6, 11) new string = "is a r" message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFOutput Group By
I am trying to group all messages together with the same subject for a forum. When I do that, I have to use CFOUTPUT group="subject" (where "Subject" is the field name). Here's the problem. I need the messages to be sorted by current date/time first and then by subject. Is there a way to use the ORDER BY clause in SQL to order the results by date/time and then also group the results by subject? Everytime I try to order by date, then by time, then by subject, it displays all the messages. Thanks in advance! You'll have to ORDER BY the field with which you want to group your CFOUTPUT data before any other fields. You should be able to ORDER BY subject, date, time. This will let you group all messages with the same subject together, in date/time order. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Studio
I've seen it once or twice. I've also saved a file, closed it, opened it and the changes were not there. Thought it was just me. I kind of feel a little better now. :-) I haven't been able to pick up on a pattern of what might be causing it though. Slow network connection maybe? Athelene [EMAIL PROTECTED] -Original Message- From: Ken M. Mevand [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 12:49 AM To: 02 cf-talk Subject: CF Studio anyone has experienced this - after saving a document in studio, close it, then open, the entire file is empty? this has happened many times, and is very, very costly. -ken -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFFILE problem on linux
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Who is your httpd running as and does it have access to the file system? Mike - -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Sunday, August 06, 2000 10:36 PM To: [EMAIL PROTECTED] Subject:CFFILE problem on linux Hi there, I'm trying to get CFFILE working on a linux box. ColdFusion is running as a user called coldfusion which has group write privileges to my HTML directory. If I log in as the coldfusion user I can create directories and files in the HTML directory OK. However, when I try to do a CFFILE ACTION="WRITE" into that same directory I get a permissions error. I am not running advanced security. What is going on? - Rob Keniger - -- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOY7YVXYFmKomMlANEQJ1xgCaA52FfQ0evBi9hlQbM6oTtod3RCcAnRso kMZdsWNAOplgtcqcy7F98wXY =ihDF -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help with CFQUERY/Update
Ok i am very confused. I am trying to update one field with the following statement: CFQUERY Datasource="#dsn#" name="update1" Update Rates_And_Charges SET passengers_enplaned_domestic = #form.passengers_enplaned_domestic# Where Member_number = '#form.Member_Number#' /CFQUERY It returns back the following: update1 (Records=0, Time=62ms) SQL = Update Rates_And_Charges SET passengers_enplaned_domestic = 456466 Where Member_number = '00' Saying it found ZERO records to update. However if i run a similar query: CFQUERY name="edit" datasource="#dsn#" SELECT passengers_enplaned_domestic FROM Rates_And_Charges WHERE Member_number = '#form.Member_number#' /CFQUERY edit (Records=1, Time=0ms) SQL = SELECT passengers_enplaned_domestic FROM Rates_And_Charges WHERE Member_number = '00' Its finds one records with the SAME EXACT where statement. Any clues why the first continues to find NO RECORD?? --- Kelly Matthews Internet Development Coordinator AAAE 703.578.2509 [EMAIL PROTECTED] http://www.airportnet.org --- -Original Message- From: Mike Sullivan [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 11:39 AM To: '[EMAIL PROTECTED]' Subject: RE: CFFILE problem on linux -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Who is your httpd running as and does it have access to the file system? Mike - -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Sunday, August 06, 2000 10:36 PM To: [EMAIL PROTECTED] Subject: CFFILE problem on linux Hi there, I'm trying to get CFFILE working on a linux box. ColdFusion is running as a user called coldfusion which has group write privileges to my HTML directory. If I log in as the coldfusion user I can create directories and files in the HTML directory OK. However, when I try to do a CFFILE ACTION="WRITE" into that same directory I get a permissions error. I am not running advanced security. What is going on? - Rob Keniger - -- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOY7YVXYFmKomMlANEQJ1xgCaA52FfQ0evBi9hlQbM6oTtod3RCcAnRso kMZdsWNAOplgtcqcy7F98wXY =ihDF -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with CFQUERY/Update
This is a multi-part message in MIME format. --=_NextPart_000_055B_01C00086.D50005A0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Help with CFQUERY/UpdateThe update is working fine. It is just that = CFQUERY does not return a recordcount of rows updated, inserted or = deleted. A quirk to be sure. All you have to do is look at the = database to see if the update was successful.=20 DC - Original Message -=20 From: Kelly Matthews=20 To: '[EMAIL PROTECTED]'=20 Sent: Monday, August 07, 2000 15:36 Subject: Help with CFQUERY/Update Ok i am very confused. I am trying to update one field with the = following=20 statement:=20 CFQUERY Datasource=3D"#dsn#" name=3D"update1"=20 Update Rates_And_Charges=20 SET passengers_enplaned_domestic =3D = #form.passengers_enplaned_domestic#=20 Where Member_number =3D '#form.Member_Number#'=20 /CFQUERY=20 It returns back the following:=20 update1 (Records=3D0, Time=3D62ms)=20 SQL =3D Update Rates_And_Charges=20 SET passengers_enplaned_domestic =3D 456466=20 Where Member_number =3D '00'=20 Saying it found ZERO records to update. However if i run a similar = query:=20 CFQUERY name=3D"edit" datasource=3D"#dsn#"=20 SELECT passengers_enplaned_domestic=20 FROM Rates_And_Charges=20 WHERE Member_number =3D '#form.Member_number#'=20 /CFQUERY =20 edit (Records=3D1, Time=3D0ms)=20 SQL =3D SELECT passengers_enplaned_domestic=20 FROM Rates_And_Charges=20 WHERE Member_number =3D '00'=20 Its finds one records with the SAME EXACT where statement.=20 Any clues why the first continues to find NO RECORD??=20 ---=20 Kelly Matthews=20 Internet Development Coordinator=20 AAAE=20 703.578.2509=20 [EMAIL PROTECTED]=20 http://www.airportnet.org=20 ---=20 -Original Message-=20 From: Mike Sullivan [SMTP:[EMAIL PROTECTED]]=20 Sent: Monday, August 07, 2000 11:39 AM=20 To: '[EMAIL PROTECTED]'=20 Subject: RE: CFFILE problem on linux=20 =20 -BEGIN PGP SIGNED MESSAGE-=20 Hash: SHA1=20 =20 Who is your httpd running as and does it have access to the file=20 system?=20 Mike=20 =20 - -Original Message-=20 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]=20 Sent: Sunday, August 06, 2000 10:36 PM=20 To: [EMAIL PROTECTED]=20 Subject: CFFILE problem on linux=20 =20 =20 =20 Hi there,=20 =20 I'm trying to get CFFILE working on a linux box. ColdFusion is=20 running as a user=20 called coldfusion which has group write privileges to my HTML=20 directory. If I=20 log in as the coldfusion user I can create directories and files in=20 the HTML=20 directory OK.=20 =20 However, when I try to do a CFFILE ACTION=3D"WRITE" into that same = directory I=20 get a permissions error.=20 =20 I am not running advanced security.=20 =20 What is going on?=20 =20 - =20 Rob Keniger=20 =20 =20 - = --=20 - =20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit=20 = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= l=20 k or send a message to [EMAIL PROTECTED] with=20 'unsubscribe' in the body.=20 =20 -BEGIN PGP SIGNATURE-=20 Version: PGPfreeware 6.5.3 for non-commercial use = http://www.pgp.com=20 =20 iQA/AwUBOY7YVXYFmKomMlANEQJ1xgCaA52FfQ0evBi9hlQbM6oTtod3RCcAnRso=20 kMZdsWNAOplgtcqcy7F98wXY=20 =3DihDF=20 -END PGP SIGNATURE-=20 = -= -=20 =20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit=20 = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or=20 send a message to [EMAIL PROTECTED] with = 'unsubscribe' in=20 the body.=20 = -= -=20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_055B_01C00086.D50005A0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEHelp with CFQUERY/Update/TITLE META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2The update is working fine.nbsp; It is = just that=20 CFQUERY does not return a recordcount of rows
RE: crystal reports and CF
Just as a follow up: I wrote in earlier about this same issue. I have since upgraded my Crystal Reports version from 7 to 8. I installed the CR Web piece and it works quite well on its own. I'd recommend that you get the Developers version if you plan to do more sophisticated work with it. Athelene [EMAIL PROTECTED] -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 8:03 AM To: CF-Talk Group (E-mail) Subject: Re: crystal reports and CF You are correct that CR was bundled "at one stage", unfortunately it is no longer sold this way. I believe version 4.0 was the first to leave it out (someone correct me if I'm wrong here), so older books still refer to it as part of the ColdFusion package. There is a tag for calling Crystal Reports (CFREPORT), but it does not work well with the latest releases of Crystal Reports (version 8). If you really need Crystal Reports, I've been told it's best just to use Crystal's reporting engine rather that can pull from a database rather than trying to integrate it with ColdFusion. Norman Elton Information Technology College of William Mary On Mon, 7 Aug 2000, Phil Palmer wrote: Can anyone tell me how the licensing of Crystal Reports and CF works? I have documentation which implies that a version of Crystal comes with CF but I have scanned the disks for CF Server and CF Studio versions 4.0 and 4.5 but I cannot see it. It doesnt seem to have installed by default. Am I incorrect in assuming that it was bundled as part of CF at one stage? Regards Phil Palmer Technical Director Engage Technology Pty Ltd e [EMAIL PROTECTED] p 0414 353 246 w www.engagetechnology.com.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFOutput Group By
Hi Dave-- Thanks for your help. That's what I used, but it's still showing the messages by subject. Shouldn't it though, as we have it ordered by subject, then by date, then by time? I guess I wasn't specific enough... What I need to do is display only one (the most recent) subject and ordered by date/time. Here's what I'd like the forum to look like: Message DateTime -- -- Sample 8/7/00 10:30 Example Msg.8/4/00 9:45 Test Mesg. 8/1/00 13:45 Where "Sample", "Example Msg.", and "Test Mesg." are linked to multiple records... meaning, someone posted a number of messages with the subject "Sample", "Example Msg." and "Test Mesg." and I only want the group of messages to display once, showing the most recent message and subject. Hopefully this helps to clarify. Thanks in advance! Greg Albert -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 11:34 AM To: [EMAIL PROTECTED] Cc: Albert, Gregory Mitchell (Greg) Subject: RE: CFOutput Group By I am trying to group all messages together with the same subject for a forum. When I do that, I have to use CFOUTPUT group="subject" (where "Subject" is the field name). Here's the problem. I need the messages to be sorted by current date/time first and then by subject. Is there a way to use the ORDER BY clause in SQL to order the results by date/time and then also group the results by subject? Everytime I try to order by date, then by time, then by subject, it displays all the messages. Thanks in advance! You'll have to ORDER BY the field with which you want to group your CFOUTPUT data before any other fields. You should be able to ORDER BY subject, date, time. This will let you group all messages with the same subject together, in date/time order. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dynamic Queries in Valuelist
Hi, I need to setup a valuelist using a dynamic query. From what I can tell, this doesn't seem to be possible. What I need is a way to drop a list of a varying number of items from a varying number of queries, and cache all of the results. Performance is key. - Geoff B -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Security Link icon not showing
Would anyone know why the security icon is not showing on the browser once the page is launched within a frame. Is there a work around that problem? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
The action page
Hi All, What is the action page of a form, if the 'action' attribute in the form tag is not specified? i.e form name="MyForm" Method="post" Some HTML tags... input type="Submit" value="OK" /form From my experimentation it was discovered that the action page is the form page. This means that the same page will be loaded again when the submit button is clicked. So now my question is, Who decides what the action page is and how. I assume it should be the WebServer and not the CFServer. So in that case, does the Webserver use the URL to decide the action page or is it some CGI variable or something in HTTP?? Thanks Kedar Desai Differential Technologies Fairfax, VA __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Security Link icon not showing
Would anyone know why the security icon is not showing on the browser once the page is launched within a frame. Is there a work around that problem? Thats probably because the outer page which sets your frameset is insecure. Why don't you put the whole of the page on your secure server and reload all the frames on your secure server, rather than framing your secure page? Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Formatting Data
I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Security Link icon not showing
Hi there, I am trying to make the connection to an ole object from the CF. I saw your application and could understand from the description that it utilizes such a connection. Could you please give me a tip on it ? Thanks. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
I'm not sure if this is what you're looking for, but try useing grouped outputs: CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: Formatting Data I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: The action page
[Who decides what the action page is and how.] If ACTION is not specified, *the browser* sets it to the current page (not the server). For all intents and porposes, no ACTION is equivalent to ACTION="#CGI.SCRIPT_NAME#". -R -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
Don't forget your order by CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test ORDER BY FieldOne /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput Thank you, Katrina Chapman ColdFusion Web Developer Systems Development -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 9:55 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: Formatting Data I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
HI, It didn't reaaly change the display Here is my code: cfloop query="SearchResults" cfquery name="qryDisplayResults" datasource="#application.settings.dsn#" dbtype="ODBC" Select * From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program /cfquery cfoutput query="qryDisplayResults" group="program" br#qryDisplayResults.Program#br cfoutput#Nomenclature#brbr/cfoutput /cfoutput /cfloop -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: Formatting Data I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cf_stockgrabber doesnt work
Hi,
I am trying to use the CF_StockGrabber custom tag and it works fine when I
leave the action page as the one on the author's public website, but when I
try and point it to the 'demo.cfm' action page on my server I receive an
error that says,
"Error resolving parameter GetQuotes'
MyQuery = Evaluate("#QueryName#")
Has anyone tried to use this custom tag? Does it work for you? I installed
all the files in the correct place. Is there a better one you know of?
Thanks
Sal
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
First things first. Don't select * Select program, nomenclature From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program Secondly change your output to cfoutput query="qryDisplayResults" group="program" br#Program#br cfoutput #Nomenclature#brbr /cfoutput /cfoutput This should fix it. --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:15 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data HI, It didn't reaaly change the display Here is my code: cfloop query="SearchResults" cfquery name="qryDisplayResults" datasource="#application.settings.dsn#" dbtype="ODBC" Select * From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program /cfquery cfoutput query="qryDisplayResults" group="program" br#qryDisplayResults.Program#br cfoutput#Nomenclature#brbr/cfoutput /cfoutput /cfloop -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: Formatting Data I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFHTTP Question
I am using an example straight out of the Advanced book of CF. I want to do a CFHTTP POST and post data to a form. However using the exmaple shown below, I get a HTTP 404 Error. Both files reside in the same directory. I have checked and re-checked the spelling of the files. Any idea whats wrong? THIS IS CFHTTP_5.CFM cfhttp url="http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm" method="POST" cfhttpparam name="form_test" type="formfield" value="1" cfhttpparam type="URL" name="url_test" value="2" cfhttpparam type="CGI" name="cgi_test" value="3" cfhttpparam type="COOKIE" name="cookie_test" value="4" /cfhttp cfoutput#cfhttp.filecontent#/cfoutput THIS IS CFHTTP_6.CFM html head titleCFHTTP Post Test/title /head body The following was posted via cfhttp_5.cfmbr br br cfoutput Form: #form.form_test#br URL: #url.url_test#br Cookie: #cookie.cookie_test# CGI: #cgi.cgi_test# /cfoutput /body /html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHTTP Question
This is a multi-part message in MIME format. --=_NextPart_000_0607_01C00095.813B5410 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable CFHTTP QuestionYou have to specify the PORT as an attribute for CFHTTP = as opposed to placing it directly in the URL. DC - Original Message -=20 From: Randy Adkins=20 To: [EMAIL PROTECTED]=20 Sent: Monday, August 07, 2000 17:29 Subject: CFHTTP Question I am using an example straight out of the Advanced book of CF.=20 I want to do a CFHTTP POST and post data to a form.=20 However using the exmaple shown below, I get a HTTP 404 Error.=20 Both files reside in the same directory. I have checked and re-checked = the spelling of the files.=20 Any idea whats wrong?=20 THIS IS CFHTTP_5.CFM=20 cfhttp url=3D"http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm" = method=3D"POST"=20 cfhttpparam name=3D"form_test" type=3D"formfield" value=3D"1"=20 cfhttpparam type=3D"URL" name=3D"url_test" value=3D"2"=20 cfhttpparam type=3D"CGI" name=3D"cgi_test" value=3D"3"=20 cfhttpparam type=3D"COOKIE" name=3D"cookie_test" value=3D"4"=20 /cfhttp=20 cfoutput#cfhttp.filecontent#/cfoutput=20 THIS IS CFHTTP_6.CFM=20 html=20 head=20 titleCFHTTP Post Test/title=20 /head=20 body=20 The following was posted via cfhttp_5.cfmbr=20 br=20 br=20 cfoutput=20 Form: #form.form_test#br=20 URL: #url.url_test#br=20 Cookie: #cookie.cookie_test#=20 CGI: #cgi.cgi_test#=20 /cfoutput=20 /body=20 /html=20 = -= -=20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_0607_01C00095.813B5410 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLECFHTTP Question/TITLE META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2You have to specify the PORT as an = attribute for=20 CFHTTP as opposed to placing it directly in the URL./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2DC/FONT/DIV DIVnbsp;/DIV BLOCKQUOTE=20 style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px" DIV style=3D"FONT: 10pt arial"- Original Message - /DIV DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"BFrom:/B=20 A href=3D"mailto:[EMAIL PROTECTED]" = [EMAIL PROTECTED]Randy=20 Adkins/A /DIV DIV style=3D"FONT: 10pt arial"BTo:/B A=20 href=3D"mailto:[EMAIL PROTECTED]"=20 [EMAIL PROTECTED][EMAIL PROTECTED]/A /DIV DIV style=3D"FONT: 10pt arial"BSent:/B Monday, August 07, 2000 = 17:29/DIV DIV style=3D"FONT: 10pt arial"BSubject:/B CFHTTP Question/DIV DIVBR/DIV PFONT size=3D2I am using an example straight out of the Advanced = book of=20 CF./FONT BRFONT size=3D2I want to do a CFHTTP POST and post data = to a=20 form./FONT /P PFONT size=3D2However using the exmaple shown below, I get a HTTP = 404=20 Error./FONT BRFONT size=3D2Both files reside in the same = directory. I have=20 checked and re-checked/FONT BRFONT size=3D2the spelling of the=20 files./FONT /P PFONT size=3D2Any idea whats wrong?/FONT /P PFONT size=3D2THIS IS CFHTTP_5.CFM/FONT /P PFONT size=3D2lt;cfhttp url=3D"A=20 href=3D"http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm"=20 target=3D_blankhttp://test.fss.gsa.gov:81/sales/cfhttp_6.cfm/A"=20 method=3D"POST"gt;/FONT BRFONT size=3D2nbsp;lt;cfhttpparam=20 name=3D"form_test" type=3D"formfield" value=3D"1"gt;/FONT BRFONT = size=3D2nbsp;lt;cfhttpparam type=3D"URL" name=3D"url_test" = value=3D"2"gt;/FONT=20 BRFONT size=3D2nbsp;lt;cfhttpparam type=3D"CGI" = name=3D"cgi_test"=20 value=3D"3"gt;/FONT BRFONT size=3D2nbsp;lt;cfhttpparam = type=3D"COOKIE"=20 name=3D"cookie_test" value=3D"4"gt;/FONT BRFONT=20 size=3D2lt;/cfhttpgt;/FONT /P PFONT = size=3D2lt;cfoutputgt;#cfhttp.filecontent#lt;/cfoutputgt;/FONT=20 /PBR PFONT size=3D2THIS IS CFHTTP_6.CFM/FONT /P PFONT size=3D2lt;htmlgt;/FONT BRFONT = size=3D2lt;headgt;/FONT=20 BRFONT size=3D2lt;titlegt;CFHTTP Post Testlt;/titlegt;/FONT = BRFONT=20 size=3D2lt;/headgt;/FONT /P PFONT size=3D2lt;bodygt;/FONT BRFONT size=3D2The following = was posted=20 via cfhttp_5.cfmlt;brgt;/FONT BRFONT size=3D2lt;brgt;/FONT = BRFONT=20 size=3D2lt;brgt;/FONT BRFONT size=3D2lt;cfoutputgt;/FONT = BRFONT=20 size=3D2Form: #form.form_test#lt;brgt;/FONT BRFONT = size=3D2URL:=20 #url.url_test#lt;brgt;/FONT BRFONT size=3D2Cookie:=20 #cookie.cookie_test#/FONT BRFONT
Single quotes in CF
Hello all, I am wrapping up my first project in Cold Fusion and I was wondering how CF handles the single quote issue. Currently, whenever I insert a record, I do the following: Insert into (name) values(replace(argument, "'", "''")) and that seems to work. Should I use the preservesinglequotes function to query a value which has a single quote in it? Any advice would be greatly appreciated. Thanks in advance, Brandon Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
Tha didn't change anything. Am I having a problem because it is in a loop? -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 1:24 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data First things first. Don't select * Select program, nomenclature From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program Secondly change your output to cfoutput query="qryDisplayResults" group="program" br#Program#br cfoutput #Nomenclature#brbr /cfoutput /cfoutput This should fix it. --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:15 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data HI, It didn't reaaly change the display Here is my code: cfloop query="SearchResults" cfquery name="qryDisplayResults" datasource="#application.settings.dsn#" dbtype="ODBC" Select * From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program /cfquery cfoutput query="qryDisplayResults" group="program" br#qryDisplayResults.Program#br cfoutput#Nomenclature#brbr/cfoutput /cfoutput /cfloop -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: Formatting Data I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Javascript and CF
I have question about using JS and CF. What I wanted the following to do is
build a list of parts in a SELECT command. ALlow the user to select the
part they want and then reload the page with the part number select.
The calling program is call "EndItemAddEdit.cfm" and of course I want to
call in the same window the same program.
Thanks for the help
SCRIPT LANGUAGE="JavaScript"
function goThere() {
var list = document.forms[0].urlList
location = list.options[list.selectedIndex].value
}
/SCRIPT
SELECT NAME="ENDITEMPN" onClick="goThere()"
cfoutput query="EndItemLU"
OPTION
VALUE="EndItemAddEdit.cfm?ENDITEMPN=#ENDITEMPN#"#ENDITEMPN#/OPTION
/CFOUTPUT
/select
Jim Ray
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
This is a multi-part message in MIME format. --=_NextPart_000_001B_01C00079.D6846EA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I have about to finish an CF/app that will require printed output. I'm = looking for suggestions as to what softqware to use. TIA. Regards, Paige --=_NextPart_000_001B_01C00079.D6846EA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2I have about to finish an CF/app that = will require=20 printed output. I'm looking for suggestions as to what softqware to = use.nbsp;=20 TIA./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Regards,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Paige/FONT/DIV/BODY/HTML --=_NextPart_000_001B_01C00079.D6846EA0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Print Output
This is a multi-part message in MIME format. --=_NextPart_000_0036_01C00079.F8B9C1A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I have about to finish an CF/app that will require printed output. I'm = looking for suggestions as to what softqware to use. TIA. Regards, Paige --=_NextPart_000_0036_01C00079.F8B9C1A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIV DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2I have about to finish an CF/app that = will require=20 printed output. I'm looking for suggestions as to what softqware to = use.nbsp;=20 TIA./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Regards,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Paige/FONT/DIV/DIV/BODY/HTML --=_NextPart_000_0036_01C00079.F8B9C1A0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Crystal Reports Professional
Phil Palmer asked: Can anyone tell me how the licensing of Crystal Reports and CF works? I have documentation which implies that a version of Crystal comes with CF but I have scanned the disks for CF Server and CF Studio versions 4.0 and 4.5 but I cannot see it. It doesnt seem to have installed by default. I was about to ask a similar question, Phil... According to Ben Forta in his book "The Cold Fusion Web Application Kit" Allaire has chosen Crystal Reports as the report writer to be bundled with their applications. We use Allaire's HomeSite 4.5 here but it's not bundled with HomeSite either So if anyone can answer this question that would be great! Thanks, Wendy Wendy Cheng Systems Librarian U. S. Food and Drug Administration -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cflocation in netscape
]I have a piece of code that uses cflocation after doing some ]update queries. ]In IE, it works fine, but in Netscape a page comes up that ]states: "Object Moved" and then "this document may be found here". ]The hyperlinked 'here' works, redirecting to the url in the ]cflocation. What is the problem? If I understand how cflocation works, the tag re-writes the redirect to the document header so that when the document is loaded, the redirect takes place automatically. At times, however, the header may get corrupt (causing the condition that you described above). I've found that this usually happens when you're calling cflocation from a template that already contains HTML code. One of the things that you may want to do is make sure that your cflocation statement is called before any code gets generated (ie -- before the html,head, and body tags). The other thing that has worked in the past for us is to append a 'fake' url variable to the redirect address (if it doesn't have one): cflocation url="http://www.myapplication.com/index.cfm?0=1" Lastly, you can also use the cfheader tag to perform the redirect: cfheader name="Refresh" value="0; URL=http://www.myapplication.com/index.cfm" Note that the value before the semicolon (in this case 0) is used to represent the delay to be enforced prior to performing the url redirect. I hope this information helps; please let me know how you make out. On another note, if my understanding of this condition is mistaken please feel free to chime in. Good luck! :-) Best Wishes and Regards, Abraham Lloyd Senior Developer www.onproject.com Working Together, Apart. onProject.com Inc. [EMAIL PROTECTED] p 407.302.9708 f 973.971.9971 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
You might be. Can we see the template in action? --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:45 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data Tha didn't change anything. Am I having a problem because it is in a loop? -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 1:24 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data First things first. Don't select * Select program, nomenclature From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program Secondly change your output to cfoutput query="qryDisplayResults" group="program" br#Program#br cfoutput #Nomenclature#brbr /cfoutput /cfoutput This should fix it. --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:15 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data HI, It didn't reaaly change the display Here is my code: cfloop query="SearchResults" cfquery name="qryDisplayResults" datasource="#application.settings.dsn#" dbtype="ODBC" Select * From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program /cfquery cfoutput query="qryDisplayResults" group="program" br#qryDisplayResults.Program#br cfoutput#Nomenclature#brbr/cfoutput /cfoutput /cfloop -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: Formatting Data I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Combo box
My bad. I just realized that the code I responded with was not complete. Here you go: A standard HTML select should do, no? Select multiple="no" name="whatever" size="1" OPTION value="choice1"choice1/option OPTION value="choice2"choice2/option OPTION value="choice3"choice3/option OPTION value="choice4"choice4/option OPTION value="choice5"choice5/option /Select John McKown, VP of Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 - Dover, DE 19901 Dover: 302.736.5515, Toll Free: 888.432.7965, Fax: 302.736.5945 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] , Web Site: http://www.Delaware.Net Delaware.Net is now an official domain name registrar! Register your domain names with us for only $20 per year! Simply visit my company's web site at http://Register.Delaware.Net to get started. Or change your existing hosting to Delaware.net and save yourself money. -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 9:47 AM To: '[EMAIL PROTECTED]' Subject: Combo box Importance: High Hello everyone!!! Does anyone have some nifty code that lets me have a combo box, ie. an input type=text field combined with a collection of hardcoded choices in an input type=select? Do I just have text input field with the same name as the select box? How does this work? Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFFILE problem on linux
If you have error logs they might give you some idea. For instance, if there is some other username being used for some reason (not that I know what reason that would be) you may be able to trace down the username in the error log. I'm not sure what kinds of logging are available but I know that you can track that in Solaris. You should be able to track it in Linux also. At 03:35 PM 8/7/00 +1000, you wrote: Hi there, I'm trying to get CFFILE working on a linux box. ColdFusion is running as a user called coldfusion which has group write privileges to my HTML directory. If I log in as the coldfusion user I can create directories and files in the HTML directory OK. However, when I try to do a CFFILE ACTION="WRITE" into that same directory I get a permissions error. I am not running advanced security. What is going on? Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Studio replacing characters
Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFSCHEDULE Question
I'm trying to generate some static pages of a directory listing, one page for each letter A through Z. I intend to generate these pages once each month on my development system, then FTP to a non- CF enabled Website. Below is some code showing how I'm trying (unsuccessfully) to do it. CFSCHEDULE is not creating the static pages, and CFLOOP is not creating distinct pages, but one page with all listings on it. Can this even be done? application.cfm: - cfparam name = application.TYPEBUS default = "" cfparam name = application.DIRNAME default = "" cfparam name = application.letter default = "a" schedule.cfm: cfschedule action="UPDATE" task="MakePage" operation="HTTPRequest" url="http://64.248.98.147/Stage/lacanadaflintridge" startdate="#DateFormat(Now())#" starttime="#TimeFormat(Now())#" interval="1" resolveurl="No" publish="Yes" file="diralpha_#application.letter#.html" path="\\Imedcoserver\IMEDCO C\InetPub\wwwroot\Stage\lacanadaflintridge\alpha" cfinclude template="topalpha.cfm" topalpha.cfm: - cfloop index="letter" list="a,b,c" cfquery name="diralpha" datasource="#DSN#" dbtype="ODBC" select BUSACCES.TYPEBUS, BUSACCES.DIRNAME from BUSACCES where DIRNAME like '#letter#%' order by DIRNAME; /cfquery cfset application.letter = letter body cfinclude template="alpha.cfm" cfschedule action="RUN" task="MakePage" /cfloop /body alpha.cfm: - (this template simply formats the output of the directory) Thanks very much for any help! -- Ron Connelly The Internet:Works [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Crystal Reports Professional
We are using CR with CF. It was not bundled with CF after 4x. When you purchase CR PRO and I think all versions you will get the server software with it. I think for us I have about 400.00 dollars in it. Also I have read that tag in CFREPORT tag does not work with CR 8.0. We wrote a CFM page that detects if browser in Netscape or IE and interfaces with the java or activex viewers. For us this works well plus gave us more control over the report viewer and got around passing long url variables and in our shop only browsers I was worried about was IE and Netscape. Thanks David - Original Message - From: "Wendy Cheng" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, August 07, 2000 11:10 AM Subject: Crystal Reports Professional Phil Palmer asked: Can anyone tell me how the licensing of Crystal Reports and CF works? I have documentation which implies that a version of Crystal comes with CF but I have scanned the disks for CF Server and CF Studio versions 4.0 and 4.5 but I cannot see it. It doesnt seem to have installed by default. I was about to ask a similar question, Phil... According to Ben Forta in his book "The Cold Fusion Web Application Kit" Allaire has chosen Crystal Reports as the report writer to be bundled with their applications. We use Allaire's HomeSite 4.5 here but it's not bundled with HomeSite either So if anyone can answer this question that would be great! Thanks, Wendy Wendy Cheng Systems Librarian U. S. Food and Drug Administration -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Studio replacing characters
gt is the symbol for just as lt is the symbol for It will still display the same - Original Message - From: "Hondo Burney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 4:20 PM Subject: Studio replacing characters Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: The action page
Don't do this. It is the web BROWSER that decides. It could change on you in the future. At 09:38 AM 8/7/00 -0700, Planet CF wrote: Hi All, What is the action page of a form, if the 'action' attribute in the form tag is not specified? i.e form name="MyForm" Method="post" Some HTML tags... input type="Submit" value="OK" /form From my experimentation it was discovered that the action page is the form page. This means that the same page will be loaded again when the submit button is clicked. So now my question is, Who decides what the action page is and how. I assume it should be the WebServer and not the CFServer. So in that case, does the Webserver use the URL to decide the action page or is it some CGI variable or something in HTTP?? Thanks Kedar Desai Differential Technologies Fairfax, VA __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Studio replacing characters
But the problem is it's not a display. It will cause problems. If it does it on a CF tag it will give and "invalid token found" error. If it does it on an HTML tag it will break the display of the page. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:36 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters gt is the symbol for just as lt is the symbol for It will still display the same - Original Message - From: "Hondo Burney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 4:20 PM Subject: Studio replacing characters Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Studio replacing characters
option value="3" cfif getproduct.status is3 SELECTED /cfif Unavailable/option In this example it is in the HTML. It shouldn't replace it if it is part of a tag. - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 1:46 PM Subject: RE: Studio replacing characters But the problem is it's not a display. It will cause problems. If it does it on a CF tag it will give and "invalid token found" error. If it does it on an HTML tag it will break the display of the page. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:36 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters gt is the symbol for just as lt is the symbol for It will still display the same - Original Message - From: "Hondo Burney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 4:20 PM Subject: Studio replacing characters Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHTTP Question
That was it. Thanks, I just overlooked that one. Man, if it was a snake I would be DEAD!! It happens to us all at one time or another. - Original Message - From: "David E. Crawford" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 1:32 PM Subject: Re: CFHTTP Question : This is a multi-part message in MIME format. : : --=_NextPart_000_0607_01C00095.813B5410 : Content-Type: text/plain; : charset="Windows-1252" : Content-Transfer-Encoding: quoted-printable : : CFHTTP QuestionYou have to specify the PORT as an attribute for CFHTTP = : as opposed to placing it directly in the URL. : : DC : : - Original Message -=20 : From: Randy Adkins=20 : To: [EMAIL PROTECTED]=20 : Sent: Monday, August 07, 2000 17:29 : Subject: CFHTTP Question : : : I am using an example straight out of the Advanced book of CF.=20 : I want to do a CFHTTP POST and post data to a form.=20 : : However using the exmaple shown below, I get a HTTP 404 Error.=20 : Both files reside in the same directory. I have checked and re-checked = : : the spelling of the files.=20 : : Any idea whats wrong?=20 : : THIS IS CFHTTP_5.CFM=20 : : cfhttp url=3D"http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm" = : method=3D"POST"=20 :cfhttpparam name=3D"form_test" type=3D"formfield" value=3D"1"=20 :cfhttpparam type=3D"URL" name=3D"url_test" value=3D"2"=20 :cfhttpparam type=3D"CGI" name=3D"cgi_test" value=3D"3"=20 :cfhttpparam type=3D"COOKIE" name=3D"cookie_test" value=3D"4"=20 : /cfhttp=20 : : cfoutput#cfhttp.filecontent#/cfoutput=20 : : : : THIS IS CFHTTP_6.CFM=20 : : html=20 : head=20 : titleCFHTTP Post Test/title=20 : /head=20 : : body=20 : The following was posted via cfhttp_5.cfmbr=20 : br=20 : br=20 : cfoutput=20 : Form: #form.form_test#br=20 : URL: #url.url_test#br=20 : Cookie: #cookie.cookie_test#=20 : CGI: #cgi.cgi_test#=20 : : /cfoutput=20 : /body=20 : /html=20 : : = : -= : -=20 : Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 : To Unsubscribe visit = : http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= : lk or send a message to [EMAIL PROTECTED] with = : 'unsubscribe' in the body. : : : --=_NextPart_000_0607_01C00095.813B5410 : Content-Type: text/html; : charset="Windows-1252" : Content-Transfer-Encoding: quoted-printable : : !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" : HTMLHEADTITLECFHTTP Question/TITLE : META content=3D"text/html; charset=3Dwindows-1252" = : http-equiv=3DContent-Type : META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR : STYLE/STYLE : /HEAD : BODY bgColor=3D#ff : DIVFONT face=3DArial size=3D2You have to specify the PORT as an = : attribute for=20 : CFHTTP as opposed to placing it directly in the URL./FONT/DIV : DIVnbsp;/DIV : DIVFONT face=3DArial size=3D2DC/FONT/DIV : DIVnbsp;/DIV : BLOCKQUOTE=20 : style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = : 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px" : DIV style=3D"FONT: 10pt arial"- Original Message - /DIV : DIV=20 : style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = : black"BFrom:/B=20 : A href=3D"mailto:[EMAIL PROTECTED]" = : [EMAIL PROTECTED]Randy=20 : Adkins/A /DIV : DIV style=3D"FONT: 10pt arial"BTo:/B A=20 : href=3D"mailto:[EMAIL PROTECTED]"=20 : [EMAIL PROTECTED][EMAIL PROTECTED]/A /DIV : DIV style=3D"FONT: 10pt arial"BSent:/B Monday, August 07, 2000 = : 17:29/DIV : DIV style=3D"FONT: 10pt arial"BSubject:/B CFHTTP Question/DIV : DIVBR/DIV : PFONT size=3D2I am using an example straight out of the Advanced = : book of=20 : CF./FONT BRFONT size=3D2I want to do a CFHTTP POST and post data = : to a=20 : form./FONT /P : PFONT size=3D2However using the exmaple shown below, I get a HTTP = : 404=20 : Error./FONT BRFONT size=3D2Both files reside in the same = : directory. I have=20 : checked and re-checked/FONT BRFONT size=3D2the spelling of the=20 : files./FONT /P : PFONT size=3D2Any idea whats wrong?/FONT /P : PFONT size=3D2THIS IS CFHTTP_5.CFM/FONT /P : PFONT size=3D2lt;cfhttp url=3D"A=20 : href=3D"http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm"=20 : target=3D_blankhttp://test.fss.gsa.gov:81/sales/cfhttp_6.cfm/A"=20 : method=3D"POST"gt;/FONT BRFONT size=3D2nbsp;lt;cfhttpparam=20 : name=3D"form_test" type=3D"formfield" value=3D"1"gt;/FONT BRFONT = : : size=3D2nbsp;lt;cfhttpparam type=3D"URL" name=3D"url_test" = : value=3D"2"gt;/FONT=20 : BRFONT size=3D2nbsp;lt;cfhttpparam type=3D"CGI" = : name=3D"cgi_test"=20 : value=3D"3"gt;/FONT BRFONT size=3D2nbsp;lt;cfhttpparam = : type=3D"COOKIE"=20 : name=3D"cookie_test" value=3D"4"gt;/FONT BRFONT=20 : size=3D2lt;/cfhttpgt;/FONT /P : PFONT = : size=3D2lt;cfoutputgt;#cfhttp.filecontent#lt;/cfoutputgt;/FONT=20 : /PBR : PFONT size=3D2THIS IS CFHTTP_6.CFM/FONT /P : PFONT
RE: Studio replacing characters
That's the point Kevin. It shouldn't but it is. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters option value="3" cfif getproduct.status is3 SELECTED /cfif Unavailable/option In this example it is in the HTML. It shouldn't replace it if it is part of a tag. - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 1:46 PM Subject: RE: Studio replacing characters But the problem is it's not a display. It will cause problems. If it does it on a CF tag it will give and "invalid token found" error. If it does it on an HTML tag it will break the display of the page. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:36 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters gt is the symbol for just as lt is the symbol for It will still display the same - Original Message - From: "Hondo Burney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 4:20 PM Subject: Studio replacing characters Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFTRANSACTION
Can someone explain what the book means by "CFTRANSACTION implements transaction,and rollback processing."??? What is roll back processing? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Do u us Intranets ?
I work on a small piece of a huge intranet. IMHO, managing something very large is not something that is accomplished by programming skills or tricks. The focus needs to be elsewhere. You need to study up on software lifecycle/design methodology (unfortunately, Fusebox is merely a programming method, not a software lifecycle methodology -- at least right now). Specifically, the problems you're referring to are better handled by analysis and scenario testing, not a coding methodology. Not a great read, or fun implementing. I'd much rather write code, but I've come to realize that a successful development hinges on what you do when you're not programming, and programming is only a small piece of the puzzle. -- Billy Cravens [EMAIL PROTECTED] Rif Kiamil wrote: We also add new table to are MSSQL 7 database as well. But we don't change column names and we all most never add new columns to the tables. But the code can change a lot. Does any body run a big intranet? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Studio replacing characters
hey.. you have an extra symbol in there... you have: option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option get rid of the after the value="3" it should be: option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option -Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:04 PM To: [EMAIL PROTECTED] Subject: RE: Studio replacing characters That's the point Kevin. It shouldn't but it is. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters option value="3" cfif getproduct.status is3 SELECTED /cfif Unavailable/option In this example it is in the HTML. It shouldn't replace it if it is part of a tag. - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 1:46 PM Subject: RE: Studio replacing characters But the problem is it's not a display. It will cause problems. If it does it on a CF tag it will give and "invalid token found" error. If it does it on an HTML tag it will break the display of the page. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:36 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters gt is the symbol for just as lt is the symbol for It will still display the same - Original Message - From: "Hondo Burney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 4:20 PM Subject: Studio replacing characters Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFTRANSACTION
"Undoing" what you just did. Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:05 PM To: [EMAIL PROTECTED] Subject: CFTRANSACTION Can someone explain what the book means by "CFTRANSACTION implements transaction,and rollback processing."??? What is roll back processing? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Studio replacing characters
In that example what tag is part of I can't see any? - Original Message - From: "Katrina Chapman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 2:04 PM Subject: RE: Studio replacing characters That's the point Kevin. It shouldn't but it is. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters option value="3" cfif getproduct.status is3 SELECTED /cfif Unavailable/option In this example it is in the HTML. It shouldn't replace it if it is part of a tag. - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 1:46 PM Subject: RE: Studio replacing characters But the problem is it's not a display. It will cause problems. If it does it on a CF tag it will give and "invalid token found" error. If it does it on an HTML tag it will break the display of the page. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:36 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters gt is the symbol for just as lt is the symbol for It will still display the same - Original Message - From: "Hondo Burney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 4:20 PM Subject: Studio replacing characters Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
includes in a table
can you do cfincludes in a table -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Coldfusion Training..
A company that we just did a CF solution for, wants CF training, from Beginner- Intermediate. Do any of you know of any resources that we can send them to if we don't wish to do this ourselves? And if we do decide to do this ourselves, are there training materials available from Allaire or elsewhere for this? -Gel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: includes in a table
At 12:11 PM 8/7/00 -0700, you wrote: can you do cfincludes in a table I assume so. Are you sending this because you have gotten an error message? If so, send us the message. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFLOCK (Docs dont make sense)
From all the discussions we've had recently on CFLOCK I was sure I understood it. That was until I re-read the manual on CFLOCK! (Developing Web Applications with Cold Fusion Pg. 202) !--- Lock session variables to assign form values to them. To lock session variables, you should get the session ID with the sessionID member variable. --- CFLOCK SCOPE="Session" TIMEOUT="30" TYPE="Exclusive" CFPARAM Name=session.size Default=#form.size# CFPARAM Name=session.color Default=#form.color# /CFLOCK Um.. excuse me... perhaps I'm dense but I don't see the "sessionID member variable" anywhere in this example... Is this just another example of rotten documentation or am I really just missing the point? --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Coldfusion Training..
Depending on your location, I have attended Figleaf's training and found it to be very good and thorough. www.figleaf.com - Original Message - From: "Angél Stewart" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 3:24 PM Subject: Coldfusion Training.. : A company that we just did a CF solution for, wants CF training, from : Beginner- Intermediate. : : Do any of you know of any resources that we can send them to if we don't : wish to do this ourselves? : : And if we do decide to do this ourselves, are there training materials : available from Allaire or elsewhere for this? : : -Gel : : : -- : Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Studio replacing characters
option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option Actually, this is the way it was originally, but when I cut and pasted the example, I cut it from the Studio altered code. So your observation of the additional "" after the option value="3" means that Studio is inserting the "" symbol AND replacing the the intended "" with a ";gt" This is messed up. It should not be doing any character replacing. ---Hondo--- At 12:24 PM 8/7/00 -0700, Dan Haley wrote: There are two closing "" for the option tag. That would probably confuse CF Studio and it would throw in the gt; thinking it is part of the display. This: option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option Should be: option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option Dan -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters option value="3" cfif getproduct.status is3 SELECTED /cfif Unavailable/option In this example it is in the HTML. It shouldn't replace it if it is part of a tag. - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 1:46 PM Subject: RE: Studio replacing characters But the problem is it's not a display. It will cause problems. If it does it on a CF tag it will give and "invalid token found" error. If it does it on an HTML tag it will break the display of the page. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:36 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters gt is the symbol for just as lt is the symbol for It will still display the same - Original Message - From: "Hondo Burney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 4:20 PM Subject: Studio replacing characters Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing tag symbol "" with the html code "gt;" For instance, about every 4 or 5 times I save the document it will replace this line : option value="3" cfif getproduct.status is 3SELECTED/cfifUnavailable/option with this one option value="3" cfif getproduct.status is 3SELECTED/cfifgt;Unavailable/option I have tried turning off the "automaticly convert special characters" function. Also, it sometimes will apend some variation of the following to my files as I save them "23:10". This is more an annoyance than a real problem, but i would still like to figure out why it does this. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
Thank pou very much for helping me. I think it was becasue of the loop, because I redid my code layout and now it is working ( so far ) -Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 2:15 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data You might be. Can we see the template in action? --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:45 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data Tha didn't change anything. Am I having a problem because it is in a loop? -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 1:24 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data First things first. Don't select * Select program, nomenclature From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program Secondly change your output to cfoutput query="qryDisplayResults" group="program" br#Program#br cfoutput #Nomenclature#brbr /cfoutput /cfoutput This should fix it. --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:15 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data HI, It didn't reaaly change the display Here is my code: cfloop query="SearchResults" cfquery name="qryDisplayResults" datasource="#application.settings.dsn#" dbtype="ODBC" Select * From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program /cfquery cfoutput query="qryDisplayResults" group="program" br#qryDisplayResults.Program#br cfoutput#Nomenclature#brbr/cfoutput /cfoutput /cfloop -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: CFQuery name="test" datasource="#application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: Formatting Data I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Quick Poll - What d you want in a host?
Okay guys, I would like to know what everyone considers important in a CF hosting environment. Are you looking for a development environment, or a place to host things for your customers? or both? what other requirements do you have for a host? In case you couldn't tell, we are considering opening our servers up to outside developers -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts I want whatever you have Will pay postage *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Coldfusion Training..
I started with the Skill Building CBT and then after 6 months and a few projects went to advanced training. This approach worked for me. I was able to get the basics on my own time and fairly inexpensively. The in-class time was invaluable though. I wanted to take the class-time in advanced training instead of Fast Track. Sitting with Dave for three days and getting his take on things was awesome!! Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:25 PM To: [EMAIL PROTECTED] Subject: Coldfusion Training.. A company that we just did a CF solution for, wants CF training, from Beginner- Intermediate. Do any of you know of any resources that we can send them to if we don't wish to do this ourselves? And if we do decide to do this ourselves, are there training materials available from Allaire or elsewhere for this? -Gel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Coldfusion Training..
I'm in Trinidad..in the Caribbean. Wherever the training is I will have to take a flight. heh heh. I went to Alliare.com and saw their training schedule with locations. Have any of you attended these courses? I am interested in the Advanced CF Development. However, would it be illegal or against licensing for us to purchase say 5 of the CF Development CD,and use that as our Training Materials per say, to walk these 5 people through a sort of CF introductory course? -Gel - Original Message - From: Randy Adkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Depending on your location, I have attended Figleaf's training and found it to be very good and thorough. www.figleaf.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Upgrading SQL 6.5 - 7.0?
Hi Has anyone on list overseen a project to upgrade a CF site's SQL backend from v6.5 to 7.0? I've been asked to quote a price for this project ... and haven't a clue what this entails (I'm familiar with SQL 7, but not 6.5) Any advice/related experience would be greatly appreciated. * john * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Coldfusion Training..
How would you like a personal CF trainer, for say, oh, I don't know, a week or two? Sharon At 03:51 PM 8/7/2000 -0400, Angél Stewart wrote: I'm in Trinidad..in the Caribbean. Wherever the training is I will have to take a flight. heh heh. I went to Alliare.com and saw their training schedule with locations. Have any of you attended these courses? I am interested in the Advanced CF Development. However, would it be illegal or against licensing for us to purchase say 5 of the CF Development CD,and use that as our Training Materials per say, to walk these 5 people through a sort of CF introductory course? -Gel - Original Message - From: Randy Adkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Depending on your location, I have attended Figleaf's training and found it to be very good and thorough. www.figleaf.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Quick Poll - What d you want in a host?
large selection of custom tags plus the liberty of adding my own and to have system dsn's added a.s.a.p -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:52 PM To: [EMAIL PROTECTED] Subject: Quick Poll - What d you want in a host? Okay guys, I would like to know what everyone considers important in a CF hosting environment. Are you looking for a development environment, or a place to host things for your customers? or both? what other requirements do you have for a host? In case you couldn't tell, we are considering opening our servers up to outside developers -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts I want whatever you have Will pay postage *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
referencing SQL proceedures
Hi How would I programmatically reference a SQL 6.5 stored procedure? Thanks! * john * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
column not found
Hello,
After editing my form and adding the 'addresstwo' column to my access table,
I still get the error below. I converted the dbase from Access 97 to 2000
but have done this before w/no problems.
Any Access savy people out these have a clue please?
Thanks.
Robert O.
---
Error Diagnostic Information
ODBC Error Code = S0022 (Column not found)
[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains
the following unknown field name: 'Addresstwo'. Make sure you have typed the
name correctly, and try the operation again.
SQL = "INSERT INTO wwebsales
(Orderdate,wweb,daterequired,salesrep,repemail,emailbox,
remarksaddpages,Acctnumber,Institution,fte,databases,pricemodel,
numberofsites,similusers,Address,Addresstwo,City,State,zip,Country,Contact,P
hone,Email,fax,contacttime,techcontact,techphone,techemail,techfax,uniquepsw
ds,ipautologin,iplist,proxyserver,proxycontact,Patronautologin,autologinWils
onWeb,proxyautologin,Patronauthenticate,RefPgLibvalid,otherautologin,erlserv
erid,serveropsystem,wwebinterface,wfwinterface,otherinterface,Usagesinglesit
e,Usagemultisite,UsagereportsComments,dynaholdings,opacversion,opacurl,holdi
ngs,holdingscomments,customerlogin,validation,refervalidationpage,validlibca
rds, Functionality,Comments) VALUES ('07-Aug-00','WilsonWeb Marketing
Trial','test','k','[EMAIL PROTECTED]','l','l','l','l','l','l','','l','l',
'kj',';lkj','lk','LA','kj','Kazakhstan','jl','kj','l','lkj','l','kj','jl','l
k','kj','','','','','','','','','','','','lkj','--','','','
','--','---','','',''
,'','','','','','','','','')"
Data Source = "WWEBSALES"
talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Quick Poll - What d you want in a host?
1. Open development (including the liberty to add/change databases / ODBC drivers at will ")) 2. Open CGI-BIN folders ") -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 4:11 PM To: [EMAIL PROTECTED] Subject: RE: Quick Poll - What d you want in a host? large selection of custom tags plus the liberty of adding my own and to have system dsn's added a.s.a.p -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:52 PM To: [EMAIL PROTECTED] Subject: Quick Poll - What d you want in a host? Okay guys, I would like to know what everyone considers important in a CF hosting environment. Are you looking for a development environment, or a place to host things for your customers? or both? what other requirements do you have for a host? In case you couldn't tell, we are considering opening our servers up to outside developers -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts I want whatever you have Will pay postage *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Coldfusion Training..
I don't want to undermine Sharon, but I just ran across a claim of Fast Track to Cold Fusion for $549 @ https://www.cln.iupui.edu/continue/fall_2000/catalog.asp?dept=Computer-Netwo rking . The difference (normally $1195) would pay for air fair to Indianapolis - if this is not an abridged class. Paul Sizemore Finish Line -Original Message- From: Sharon DiOrio [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Coldfusion Training.. How would you like a personal CF trainer, for say, oh, I don't know, a week or two? Sharon At 03:51 PM 8/7/2000 -0400, Angél Stewart wrote: I'm in Trinidad..in the Caribbean. Wherever the training is I will have to take a flight. heh heh. I went to Alliare.com and saw their training schedule with locations. Have any of you attended these courses? I am interested in the Advanced CF Development. However, would it be illegal or against licensing for us to purchase say 5 of the CF Development CD,and use that as our Training Materials per say, to walk these 5 people through a sort of CF introductory course? -Gel - Original Message - From: Randy Adkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Depending on your location, I have attended Figleaf's training and found it to be very good and thorough. www.figleaf.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Coldfusion Training..
Already offered. :) Actually, my company has me going to some places for personal (and company) cf training. How would you like a personal CF trainer, for say, oh, I don't know, a week or two? Sharon At 03:51 PM 8/7/2000 -0400, Angél Stewart wrote: I'm in Trinidad..in the Caribbean. Wherever the training is I will have to take a flight. heh heh. I went to Alliare.com and saw their training schedule with locations. Have any of you attended these courses? I am interested in the Advanced CF Development. However, would it be illegal or against licensing for us to purchase say 5 of the CF Development CD,and use that as our Training Materials per say, to walk these 5 people through a sort of CF introductory course? -Gel - Original Message - From: Randy Adkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Depending on your location, I have attended Figleaf's training and found it to be very good and thorough. www.figleaf.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Upgrading SQL 6.5 - 7.0?
All in all, it was one of the smoothest upgrades (of that relative magnitude) I've ever done. We upgraded about 20 or so databases of varying size and complexity. The only issues we ran into were the fault of bad programming on the developer's part. Some badly designed SQL Queries quit running after the upgrade. On the average, each query took only a moment to fix. For instance, the SQL Server 7 syntax validator seems to be a little more judicious about what it will let pass: SQL Server 6.5 only seems to check whether or not a character, word or phrase is allowed but not necessarily the syntax in which it is used (e.g. stray semi-colons). The only other issue we had was also the fault of bad programming on the developer's side. Some of our developers got into the bad habit of using some reserved words. If I remember correctly, SQL Server prefixed an underscore to column names named after a word that SQL Server 7 put into use (e.g. "Date"). Where we got hit the hardest was with a table that was named "Logins." I don't believe "Logins" was on the reserved list, but SQL Server 7 adds several more system tables to each database, one of which is called "Logins." In this instance, the data simply did not transfer. We had to import the data separately into a table of a different name, change a few foreign key constraints, and change the SQL queries that used the table. None of which was terribly difficult. Anyway, everything you need to perform the upgrade should be on the SQL Server 7 CD ROM. After the upgrade, you'll just have to test your sites and monitor the ColdFusion error logs to determine what errors are occurring because of the upgrade. The SQL Server upgrade utility will notify you upon completion if any data fails to transfer from SQL Server for whatever reason. I believe it pipes it out to a text file, if I remember correctly. In any case, go for it. In our collective opinion, SQL Server 7 is a vastly superior product. In our situation it solved far more problems than it caused. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: JB Mentzer [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:59 PM To: [EMAIL PROTECTED] Subject: Upgrading SQL 6.5 - 7.0? Hi Has anyone on list overseen a project to upgrade a CF site's SQL backend from v6.5 to 7.0? I've been asked to quote a price for this project ... and haven't a clue what this entails (I'm familiar with SQL 7, but not 6.5) Any advice/related experience would be greatly appreciated. * john * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Hosts in the Boston Area
Hi All, Can any of you fellow cf'ers in New England recommend a CF hoster in the Boston area? Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cf_stockgrabber doesnt work
oops. I'm running CF 4.0. Does cf_stockgrabber not work with CF 4??
From: "Michael Slatoff" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: cf_stockgrabber doesnt work
Date: Mon, 07 Aug 2000 10:31:41 -0700
I had the same problem when I had CF Server 4.5 running. Try upgrading to
4.51. Fixed the problem for me.
Michael Slatoff
www.slatoff.com
-Original Message-
From: "S R" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 07 Aug 2000 10:14:03 PDT
Subject: cf_stockgrabber doesnt work
Hi,
I am trying to use the CF_StockGrabber custom tag and it works fine
when I
leave the action page as the one on the author's public website, but
when I
try and point it to the 'demo.cfm' action page on my server I receive
an
error that says,
"Error resolving parameter GetQuotes'
MyQuery = Evaluate("#QueryName#")
Has anyone tried to use this custom tag? Does it work for you? I
installed
all the files in the correct place. Is there a better one you know of?
Thanks
Sal
___
_
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Line Breaks in Access Notes Field
This is a multi-part message in MIME format. --=_NextPart_000_0002_01C0008E.B196A5D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit BEGIN QUESTION When using CFOUTPUT, is there a way to make the data that is in Access Memo fields wrap without losing the line breaks and without using the PRE tag. /END QUESTION WHY I AM ASKING I have a customer with an access database that we "web-enabled" with CF. He has a really long notes field that has employee comments in it, and each comment starts on a new line with a line break.Some of the lines are especially long, so using the HTML PRE tag is no good, because it makes the page 2000 pixels wide I had the data populating a text box and then he called complaining because his customers could not print the page. /WHY I AM ASKING Thanks in advance John McKown, VP of Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 - Dover, DE 19901 Dover: 302.736.5515, Toll Free: 888.432.7965, Fax: 302.736.5945 E-mail: [EMAIL PROTECTED], Web Site: http://www.Delaware.Net Delaware.Net is now an official domain name registrar! Register your domain names with us for only $20 per year! Simply visit my company's web site at http://Register.Delaware.Net to get started. Or change your existing hosting to Delaware.net and save yourself money. --=_NextPart_000_0002_01C0008E.B196A5D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR/HEAD BODY DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000 DIVFONT face=3DArial size=3D2SPAN = class=3D709373820-07082000lt;BEGIN=20 QUESTIONgt;/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000When = using CFOUTPUT,=20 is there a way to make the data that is in Access Memonbsp;fields wrap = without=20 losing the line breaks and without using the lt;PREgt;=20 tag./SPAN/FONT/DIV/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN = class=3D709373820-07082000lt;/END=20 QUESTIONgt;/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D709373820-07082000/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN = class=3D709373820-07082000lt;WHY I AM=20 ASKINGgt;/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000I have = a customer=20 with an access database that we "web-enabled" with = CF./SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000He has = a really long=20 notes field that has employee comments in it, and each comment starts on = a new=20 line with a line break.nbsp;nbsp;nbsp; Some of the lines are = especially long,=20 so using the HTML lt;PREgt; tag is no good, because it makes the page = 2000=20 pixels wide :(nbsp;nbsp; /SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000I had = the data=20 populating a text box and then he called complaining because his = customers could=20 not print the page./SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000FONT = face=3DArial=20 size=3D2SPAN class=3D709373820-07082000lt;/WHY I AM=20 ASKINGgt;/SPAN/FONT/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000FONT = face=3DArial=20 size=3D2SPAN = class=3D709373820-07082000/SPAN/FONT/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000FONT = face=3DArial=20 size=3D2SPAN class=3D709373820-07082000Thanks in=20 advance/SPAN/FONT/SPAN/FONT/DIV PFONT size=3D2John McKown, VP of Business ServicesBRDelaware.Net, = Inc.BR30=20 Old Rudnick Lane, Suite 200 - Dover, DE 19901BRDover: 302.736.5515, = Toll Free:=20 888.432.7965, Fax: 302.736.5945BRE-mail: A=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A, Web Site: A=20 href=3D"http://www.delaware.net/"=20 target=3D_blankhttp://www.Delaware.Net/ABRBR=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DBRDelaware.Net= =20 is now an official domain name registrar!BRRegister your domain names = with us=20 for only $20 per year!BRSimply visit my company's web site at A=20 href=3D"http://register.delaware.net/"=20 target=3D_blankhttp://Register.Delaware.Net/A to get started.BROr = change your=20 existing hosting to Delaware.net and save yourself=20 money.BR=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3DBRBR/FONT/P DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_0002_01C0008E.B196A5D0-- -- Archives:
Re: Afraid of long CFOUTPUT... (help!)
Off the top of my head, I know you can't use a CFMAIL tag inside CFOUTPUT, I'm sure they're are several others as well. But from what I remember, Cold Fusion error messages mentioning whether or not a tag can be nested inside a CFOUTPUT are pretty descriptive as such. Therefore if you get some sort of error message, it's time to modify your code appropriately. As far as one REALLY big output is concerned, typically I like to break down a page into as many smaller cfoutputs as possible. Granted it's a minimal performance impact and makes the code look a little cleaner IMHO. Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 08/07 1:32 PM ARGHH The Cold Fusion Documentation strikes again! Help! CFML Language Reference Pg. 131: "CFLOOP allows you to loop over tags that can not be used inside CFOUTPUT" I cannot find ANY mention of WHICH tags cannot be used inside a CFOUTPUT!? What tags is this line referring to?!!? Help! I am planning to wrap my entire pages inside one big CFOUTPUT. Now I found this cryptic line in the documentation. Does anyone know what it is referring to? At 11:11 PM 8/4/00 -0400, Peter Theobald wrote: Before I go ahead with CFOUTPUT at the top of the page and /CFOUTPUT at the bottom of the page and a whole 'lotta page in between... I am afraid that running some other CF tags inside a CFOUTPUT might cause trouble. Is there *anything* that might get hurt by being inside a CFOUTPUT? CFQUERY? SQL? INCLUDE? --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Urgent: Sql 6.5 Guru Question
Hello everyone,
Got a problem here that I can't seem to figure out. I have a tab-delimited
text file containing 3 cols, (can_id, votes, % votes) that I need to import
into a SQL 6.5 table containing these three columns (and others) that needs
to be updated on a regular basis - updating existing records, not inserting
new ones.
My first guess would have been bcp, but as near as I can tell, this only
works on data copying operations, so it won't allow me to perform an UPDATE
type of action on the table I want to update. I'm used to working with SQL
7.0, which would let me save this as a DTS package, so my t-sql stored proc
syntax is a little rough.
Here is what I've got so far, which is full of errors:
if exists (select * from sysobjects where id =
object_id('dbo.update_election_output') and sysstat 0xf = 4)
drop procedure dbo.update_election_output
GO
/***
Object: Stored Procedure dbo.update_election_output
Script Date: 8/7/00 11:15am
Last Updated On: Never!
***/
CREATE PROCEDURE update_election_output
@election_results_file varchar(255)
AS
/***
Update election results from FTP source file.
***/
CREATE TABLE #election_updates
(
textstring varchar(255) null
)
select 'Getting Election Results'
INSERT #election_updates
EXEC ('EXEC master..xp_cmdshell ''type '+@election_results_file+)
select 'Updating Election Results Table...'
UPDATE a
SET a.votes = SUBSTRING(textstring,8,15)
SET a.percent_votes = SUBSTRING(textstring,16,23)
FROM elections_output a
WHERE EXISTS
(
SELECT *
FROM #election_updates
WHERE a.can_id = SUBSTRING(textstring,1,7)
)
/***
Cleanup and Grant appropriate permissions.
***/
DROP TABLE #election_results
GO
Is this the right way to go about this? Would it be better to use bcp to
copy the data into a temp table and then write an update statement to update
the master table?
Thanks,
Ryan
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
