RE: Studio Development Mapping
You need to register your server at the Allaire web site and they send you a full document set for free (Administering and Studio). I registered on a Monday and had the manuals only three days later (not bad considering I'm DownUnder). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Smith Sent: Friday, 18 May, 2001 4:13 PM To: CF-Talk Subject: RE: Studio Development Mapping Where do you get that? I have Studio 4.5 but Allaire didn't ship a manual for it. Did your copy come in the box with the manual for CFAS 4.5? Is there only one manual for CFAS 4.5: Administering ColdFusion Server 4.5 best, paul At 11:23 AM 5/18/01 +1000, you wrote: Using ColdFusion Studio 4.5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Smith Sent: Friday, 18 May, 2001 11:14 AM To: CF-Talk Subject: RE: Studio Development Mapping Hm... Not on those pages in any manual I have. Which manual are you referring to? best, paul At 10:45 AM 5/18/01 +1000, you wrote: In the manual on pages 8 and 119. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Smith Sent: Friday, 18 May, 2001 2:45 AM To: CF-Talk Subject: Studio Development Mapping Where are the instructions in Studio for the subject? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio Development Mapping
So you're telling me that even though I've always purchased my Allaire products from Allaire, they don't know it, eh? Sheeesh! best, paul At 04:36 PM 5/18/01 +1000, you wrote: You need to register your server at the Allaire web site and they send you a full document set for free (Administering and Studio). I registered on a Monday and had the manuals only three days later (not bad considering I'm DownUnder). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Smith Sent: Friday, 18 May, 2001 4:13 PM To: CF-Talk Subject: RE: Studio Development Mapping Where do you get that? I have Studio 4.5 but Allaire didn't ship a manual for it. Did your copy come in the box with the manual for CFAS 4.5? Is there only one manual for CFAS 4.5: Administering ColdFusion Server 4.5 best, paul At 11:23 AM 5/18/01 +1000, you wrote: Using ColdFusion Studio 4.5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Smith Sent: Friday, 18 May, 2001 11:14 AM To: CF-Talk Subject: RE: Studio Development Mapping Hm... Not on those pages in any manual I have. Which manual are you referring to? best, paul At 10:45 AM 5/18/01 +1000, you wrote: In the manual on pages 8 and 119. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Smith Sent: Friday, 18 May, 2001 2:45 AM To: CF-Talk Subject: Studio Development Mapping Where are the instructions in Studio for the subject? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Configuring CF45 for Java
Hi All, The problem I am experiencing is that I have developed a Java Applet that creates a Menu system, It works fine on the development macine with Java installed but when I check on another Machine there I get a Class not found Exception. I have assumed that this is becuase CF isn't set up to run JVM and doesnt have the necessary classes on the system. Is this true? and How do you configure the Java settings in CF4.5 so that you can utilise classes? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
profanity checker
Hi all, I posted this a few days ago, and was directed towards some custom tags, but none of them seem to work exactly how I want them, and I would like to come up with something myself. I have a Access db table which contains a list of badwords, and 3 ratings for each. The administrator sets the profanity rating, with 1 being the most strict and 3 the least. Assuming it is set to 1, the badwords should be replaced with corresponding number of *. So, I run a query, selecting all the badwords and their corresponding 'cleaned up' versions. Then I need to loop over a form field, checking each word in it to see if it matches a badword, and replacing it with it's 'cleaned up' version if it does. !--- Pull out all the bad words from the database --- cfquery name=getprofanities datasource=#APPLICATION.chatdsn# SELECT ID, badword, rate1 FROM tbl_profanity /cfquery !--- Loop over the profanity list and compare with words in the bodytext --- cfloop query=getprofanities cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword, getprofanities.rate1, ALL) /cfloop This code doesn't seem to work, and to be honest I'm not surprised, but my head seems to be somewhere else today and I just can't get it!!! Any help anyone..please?? :) TIA Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Flash classes?
is it possible to use flash to update the client's display with data bieng pulled by cf from a database if so how is this done? Thanks KOla -Original Message- From: Paul Mone [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 00:28 To: CF-Talk Subject: RE: CF and Flash classes? I've done some presentations to the local CFUG (San Diego) on this topic. 1) Using ColdFusion and Flash together. Learn how to make a user login and address book. 2) Using ColdFusion, Flash, and WDDX together. Learn how to create a news article browser and bar graph. I could share the materials with you if you email me off list. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] 619.222.7082 -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:43 AM To: CF-Talk Subject: CF and Flash classes? Has anyone seen any workshops, or classes on how to integrate Flash and Cold Fusion yet? Thanks, Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
High usage web sites.
Hi, Anyone have experience of using Coldfusion with very large usage web sites? Somewhere in the region of 240k - 250k page impressions an hour. If so, what sort of hardware would be needed? I know it's a bit vague, the site would be fairly basic database searches through say, 40-50k records, so we'd probably have to go for a seperate db server. Thanks in advance for any help. Regards, Craig. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPS XML
Right now the need is for their Rate System. Eventually we will add other services. The UPS Docs are clear enough from their end that I feel I will be able to work it once I get started. I just need a base to get going. Mel -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:43 PM To: CF-Talk Subject: RE: UPS XML Are you looking to track packages from your web page -Original Message- From: Mel Wade [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:03 PM To: CF-Talk Subject: UPS XML I'm looking for a UPS XML integration starting place where I won't have to reinvent the whole wheel. Mel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: defining french table in oracle
Hi, While language support depends on the database install, most installations include support for Western European languages. If you use the proper NLS specifier and pass that to oracle then you can support languages with no problem. SELECT TO_CHAR(sale_date, 'Day DD Month HH24:MI:SS') as nice_sale_date FROM sales WHERE sales_id=3939 This would return -Original Message- From: FARRAH NG [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 20:03 To: CF-Talk Subject: defining french table in oracle Hi everybody, Does anyone has the experience of creating a oracle database to store french characters ? Please give me advise of how to do this, if anyone has this experience before. thanks -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: defining french table in oracle
Oops forgot to say the rest! SELECT TO_CHAR(sale_date, 'Day DD Month HH24:MI:SS') as nice_sale_date FROM sales WHERE sales_id=3939 This would return Nice_sale_date -- Wednesday 25 October 2000 00:16:13 if you do the same query and add the NLS specifier SELECT TO_CHAR(sale_date,'Day DD Month HH24:MI:SS','NLS_DATE_LANGUAGE=FRENCH') as nice_sale_date FROM sales WHERE sales_id=3939 you get it in français Nice_sale_date -- Mercredi 25 Octobre 2000 00:16:13 Hth s -Original Message- From: FARRAH NG [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 20:03 To: CF-Talk Subject: defining french table in oracle Hi everybody, Does anyone has the experience of creating a oracle database to store french characters ? Please give me advise of how to do this, if anyone has this experience before. thanks -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: profanity checker
cfloop query=getprofanities cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword, getprofanities.rate1, ALL) /cfloop One mistake is the use of quotes. In a function, if you do Function(foo), foo is a string. But you want to use the value of getprofanities.badword, so you don't use the quotes. Try rewriting it like so: cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword,getprofanities.rate1, ALL) You also don't need the getprofanities. in front of badword and rate1. Since you are looping over the query, it is implied. Another thing you may want to look out. Consider the case where Clinton is the bad word. What happens if I do: C l i n t o n Your checker won't find that word. What I've done in the past is to take the bad word and translate it into a regex that looks like this: C[[:space:]]l[[:space:]]etc This will make it match the test above. You would also change ReplaceNoCase w/ REReplaceNoCase. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: [Re: Native Drivers - Oracle80]]
Remember that each database can have multiple schemas; a schema is really just a set of tables (and indexes, triggers, etc) that belong to a user. But if you've got user A who owns schema B in database XYZ, and your application needs access to the tables in schema B, then you can use user A's userid and password in CF admin for that datasource. You can also, if you like, create another user C and give that user whatever rights are needed to the tables (indexes, etc) in schema A. clear as mud, eh? -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 6:09 PM To: CF-Talk Subject: Re: [RE: [Re: Native Drivers - Oracle80]] Thank you so much for your assistance. I finally make it work. One more question if I can. If I create a user A who owns the schema of XYZ database with a password. Should I put user A for CF Login? Please advise. Salute, Julia Phu [EMAIL PROTECTED] wrote: First make sure that you can connect to the database using an Oracle tool like SQLPlus from the console of the CF server. Oracle has its own set of userids and passwords, so you'll have to create (or know) an oracle userid and password. And the service name is what you will put in the host string spot in CF Admin. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: profanity checker
It looks to me like you are setting the variable newlist equal to the form field after a replace. The problem lies mostly that every time you loop over this you reset the variable. So of the list result from the query has no matches then your variable will be equal to the original form field. The second problem I see is the variables you are passing the function. On a final note you said the administrator could set the level. I don't see a where clause in the query. However, try this. cfset newlist = #form.bodytext# cfloop query=getprofanities cfset newlist = ReplaceNoCase(#newlist#, #getprofanities.badword#, #getprofanities.rate1#, ALL) /cfloop -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 5:22 AM To: CF-Talk Subject: profanity checker Hi all, I posted this a few days ago, and was directed towards some custom tags, but none of them seem to work exactly how I want them, and I would like to come up with something myself. I have a Access db table which contains a list of badwords, and 3 ratings for each. The administrator sets the profanity rating, with 1 being the most strict and 3 the least. Assuming it is set to 1, the badwords should be replaced with corresponding number of *. So, I run a query, selecting all the badwords and their corresponding 'cleaned up' versions. Then I need to loop over a form field, checking each word in it to see if it matches a badword, and replacing it with it's 'cleaned up' version if it does. !--- Pull out all the bad words from the database --- cfquery name=getprofanities datasource=#APPLICATION.chatdsn# SELECT ID, badword, rate1 FROM tbl_profanity /cfquery !--- Loop over the profanity list and compare with words in the bodytext --- cfloop query=getprofanities cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword, getprofanities.rate1, ALL) /cfloop This code doesn't seem to work, and to be honest I'm not surprised, but my head seems to be somewhere else today and I just can't get it!!! Any help anyone..please?? :) TIA Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Report Solution (long)--My shared experience
Okay, all. I just spent 4 days tearing my hair out trying to figure out how to pass CF variables to a Crystal Report(8) (while hiding the db userid and password). I searched the archives and the Allaire site and noticed that many other people have been gnashing their teeth over the same topic, so I thought I would share our solution. It's not pretty, and I'm not looking forward to supporting it, but it will do until we can upgrade to 5.0. Is it just me, or does anyone else here feel like sometimes the only solution is to slap some duct tape on the problem? ;) Hopefully this will help someone else out. And, if anyone out there has any other ideas on how this could have been done, I welcome the input. So, here it is... Crystal Reports Case study Goal: To pass user-specified parameters from a ColdFusion web page to Crystal Reports for display through the user's browser. Scenario: ColdFusion Server 4.0 running on NT, IIS4 (we'll call it the CF Server) Trying to access a Crystal report (8) (we'll call it report.rpt) on a DIFFERENT server (we'll call it the report server) that is NOT running CF (IIS4 and the Crystal Reports Web Component Server). Challenge: We needed a way to access and display these reports from ColdFusion without passing the database username/password information in the source code. We also are having users enter their NT userid and password when they request a report, and we are calling an Oracle stored procedure on the CF action page to validate the id/pw. If it's valid, a session id is returned, which we need to pass to the Crystal report. Details:Our first thought was that this project would be simple because we could just pass all of our variables as either URL or hidden form variables. However, I realized that the Crystal report prompts for both a database id and password. I could not pass it as a hidden form variable, because a hidden form field is only hidden from the display, not from the source code. I then thought that we could use Encrypt() to encrypt the userid/pw and pass it in a URL or form variable. This would not work, though, because the Crystal report would have no way to decrypt it. The Encrypt() function would only have been useful to us if we were passing information from a CF page TO another CF page. Not being too familiar with Crystal Reports (I am not creating them--someone else is), I wasn't sure if Crystal Reports even has a similar Decrypt() function. So Why didn't we use the CFREPORT TAG? Well, believe me, I would have liked to. But, no matter what I did, I just could NOT get it to work. Even after combing through the archives and the Allaire site and implementing all of the suggestions, I still kept getting errors like the report server is too busy (even though I knew I was the only one on it), File does not exist or is not in a directory that is accessible to the ColdFusion service (this one happened whether I was calling the report on the report server, or whether I was calling the report from the SAME directory using an absolute path.), and a host of other errors. Final solution: We ended up creating the actual form in Coldfusion, then using another CF template for the action page. On that page, we called our stored procedure to verify that a valid employee was logging in. If not, an error is displayed indicating such. If so, then a continue button is displayed and all of the fields from the first form are carried over via hidden form fields (minus the db userid/pw). Both of these CF templates are on the CF server, of course. This form on the CF action page (that displays the continue button) submits to an ASP page that is sitting on the report server. That ASP page then passes all of the form fields from the CF page, as well as the database userid/pw to the crystal report (on the report server). TIPS: Go to www.crystaldecisions.com, and in their download area, search for ASPXMPS8. These are all of the ASP examples that you should need. Specifically, we used the SimpleSetLogonInfo.asp file as our primary example for doing this, as well as SimpleParameterFields.asp. Just rename the template and replace their database info with your own. Our variable names were Param1, Param2, Param3, etc., and we were sure to name them as such when we were passing them from the CF template. The Crystal Report will expect the parameters to come in order, so make sure that the first value that you are passing to the report (i.e. Param1) is the first prompt that would pop up in the report (after the db logon and password info). THE GOOD NEWS: According to my MM rep, CF 5.0 will provide complete support for Crystal Reports 8.0. I hope so, because I'm not looking forward to going through this for the dozen or more reports that we're going to have to call! J ~~ Structure your ColdFusion code with Fusebox. Get the official book
Re: High usage web sites.
We do. We serve about 3 million pages per day lately, with our hourly peaks usually in the 400-500K range. About half of these are CF based - ranging from very simple no-query pages to pages with a dozen queries. The most hit pages have 2-3 queries on them. Our DB server is a Sun E450 4x400MHz, 4GB RAM, Oracle 8i. Our CF Servers are 8 Dell 2300/2400 boxes. All are Dual PIII, ranging from 400 to about 600MHz. 2GB RAM each, 2x9 or 2x18GB 10K drives mirrored. They run NT4 and IIS4, CF4.51 SP2. No other software. With this setup, we're capable of about 1 million CF pages per hour, or a 4x spike over normal peak traffic. Beyond that, we switch over to more aggressive DB caching, losing freshness in the content as a result - but its worth it. These boxes are load balanced with Big/IP boxes. Most, if not all, CF Pages return in under 50ms on onloaded servers. On loaded servers (ie, at about 2x our normal peak traffic (or about 500K pages per hour)), we see 300-600ms response time on many pages. At full load (1M pages per hour), response times are in the 1-2 second range. At this point, we implement query caching on previously uncached queries, and our response time drops back under a second, as we rise to about 2M pages per hour. We can't get past 2M pages per hour (or about 70 pages per second per CF Server). As we load on clients, response time increases, but thruput remains constant. Treaking CF threads has not helped positively. Think we're just at the limit of CF for our application mix. Hope this helps. Craig Dudley wrote: Hi, Anyone have experience of using Coldfusion with very large usage web sites? Somewhere in the region of 240k - 250k page impressions an hour. If so, what sort of hardware would be needed? I know it's a bit vague, the site would be fairly basic database searches through say, 40-50k records, so we'd probably have to go for a seperate db server. Thanks in advance for any help. Regards, Craig. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Will MM Create Server-Side Image Editing Tools For CF?
Thanks. I will take a look at that. John McKown Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 Local: 302-736-5515 Toll Free: 888-432-7965 Fax: 302-736-5945 Cellular: 302-423-0605 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web Site: http://www.delaware.net -Original Message- From: Peter Stolz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 11:41 PM To: CF-Talk Subject: RE: Will MM Create Server-Side Image Editing Tools For CF? Take a look at CFX_DynamicImage in the tag gallery. It does everything you want and more. I believe it's commercial though. HTH P. -Original Message- From: John McKown [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 11:21 PM To: CF-Talk Subject: Will MM Create Server-Side Image Editing Tools For CF? I have several CFX tags that can resample images and create thumbnails dynamically, but they leave me wanting more. Since Macromedia is mainly a graphics company, why don't they take some of the image editing tools in fireworks and make them scriptable on the server with CF? It would be great to be able to resample, sharpen, adjust contrast, levels, color, crop, etc. using a web browser. AOL and others are already doing this. For instance, I built a pretty cool content management solution for real estate agents, but most agents are too inexperienced with photo editing programs like Photoshop, or they just simply don't own any. Just getting the photos out of the camera seems to be a major chore for most of them. Since this is the weakest link in the application, any way to give them the power to edit the photo online would make things a lot simpler for them. Comments? John McKown, Owner Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 e-mail: [EMAIL PROTECTED] icq: 1812513 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Performance Tuning
Good Morning List I have read posts talking about Allaire Consultants that come into a company and play around with your CF setup in the hopes of boosting performance. We are thinking about bringing in such a person. I'm fishing for information on how we set something like this up. Is it through Allaire/MM directly or do we need to get in touch with an Allaire Partner in our area (NC)? If we need to get in touch with a partner locally, can anyone pass along some recommendations? Thanks,. Tim Bahlke ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: High usage web sites.
Thanks Edward, very useful info. Regards, Craig. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
[Re:] RE: defining french table in oracle
Hi, my problem is i have to put the french text like this one : Le revenu d'exploitation par action selon la comptabilité de caisse1, du deuxième trimestre sest établi à 0,84 $ contre 0,84 $ pour la même période de lexercice précédent into my database table. I am developing a site in which the admin section allows both english and french entries. The English version works perfect but when i try to put a french text into the oracle table, the CFQuery sent the text to the oracle table but somehow some of the french characters stored in the table column is changed. It looks like oracle has changed some of the french characters when it is stored in the column. So when CFQuery select retrieves the french text stored in the table and displayed on the web page, the text is different from the original one. I am trying to use SQL Plus to insert a french text but an error ORA-01756: quoted string not properly terminated returns. I believe it is because of the existing single quotes in the french text which screw up the SQL insert statement. Anyone has any idea to deal with this kind of problems ? On Fri, 18 May 2001 12:19:20 +0100 Stephen Galligan wrote: Oops forgot to say the rest! SELECT TO_CHAR(sale_date, 'Day DD Month HH24:MI:SS') as nice_sale_date FROM sales WHERE sales_id=3939 This would return Nice_sale_date -- Wednesday 25 October 2000 00:16:13 if you do the same query and add the NLS specifier SELECT TO_CHAR(sale_date,'Day DD Month HH24:MI:SS','NLS_DATE_LANGUAGE=FRENCH') as nice_sale_date FROM sales WHERE sales_id=3939 you get it in français Nice_sale_date -- Mercredi 25 Octobre 2000 00:16:13 Hth s -Original Message- From: FARRAH NG [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 20:03 To: CF-Talk Subject: defining french table in oracle Hi everybody, Does anyone has the experience of creating a oracle database to store french characters ? Please give me advise of how to do this, if anyone has this experience before. thanks -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report Solution (long)--My shared experience
I haven't done anything like this but may have to soon. Question: is there anything stopping a user from creating an html page on their desktop with a form that posts to the report server ASP page, just like your action page does? If not, it appears that anyone could run any report if they can figure out what to put in the form fields. Or is there a step I missed? -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:49 AM To: CF-Talk Subject: Report Solution (long)--My shared experience Okay, all. I just spent 4 days tearing my hair out trying to figure out how to pass CF variables to a Crystal Report(8) (while hiding the db userid and password). I searched the archives and the Allaire site and noticed that many other people have been gnashing their teeth over the same topic, so I thought I would share our solution. It's not pretty, and I'm not looking forward to supporting it, but it will . ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report Solution (long)--My shared experience
Sorry I didn't reply sooner. I had this solution but chose not to post it for fear of all the ASP flames. We were presented with a similar problem and resolved it much the same way. We were faced with an additional problem in that we had an integrated security system which was handled through the application.cfm. We addressed this problem by setting a flag and capturing the users ipaddress in the database prior to the page that calls asp report file. When the user returns to the cold fusion pages after the report the first item of business is was to check the flag and ipaddress. If they didn't match then we booted them. Finally we ran a scheduled stored procedure on the database to check the flag and if it remained for more then a set period of time it was reset. On a final note. CF 5.0 may not resolve your problem. In a response from Ben Forta he indicated that the cfreport tag will return html only. This is fine if this is what you want. We on the other hand required the crystal activex viewer. Maybe Ben could chime in on this and give us a confirmation. John Hancock -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:49 AM To: CF-Talk Subject: Report Solution (long)--My shared experience Okay, all. I just spent 4 days tearing my hair out trying to figure out how to pass CF variables to a Crystal Report(8) (while hiding the db userid and password). I searched the archives and the Allaire site and noticed that many other people have been gnashing their teeth over the same topic, so I thought I would share our solution. It's not pretty, and I'm not looking forward to supporting it, but it will do until we can upgrade to 5.0. Is it just me, or does anyone else here feel like sometimes the only solution is to slap some duct tape on the problem? ;) Hopefully this will help someone else out. And, if anyone out there has any other ideas on how this could have been done, I welcome the input. So, here it is... Crystal Reports Case study Goal: To pass user-specified parameters from a ColdFusion web page to Crystal Reports for display through the user's browser. Scenario: ColdFusion Server 4.0 running on NT, IIS4 (we'll call it the CF Server) Trying to access a Crystal report (8) (we'll call it report.rpt) on a DIFFERENT server (we'll call it the report server) that is NOT running CF (IIS4 and the Crystal Reports Web Component Server). Challenge: We needed a way to access and display these reports from ColdFusion without passing the database username/password information in the source code. We also are having users enter their NT userid and password when they request a report, and we are calling an Oracle stored procedure on the CF action page to validate the id/pw. If it's valid, a session id is returned, which we need to pass to the Crystal report. Details:Our first thought was that this project would be simple because we could just pass all of our variables as either URL or hidden form variables. However, I realized that the Crystal report prompts for both a database id and password. I could not pass it as a hidden form variable, because a hidden form field is only hidden from the display, not from the source code. I then thought that we could use Encrypt() to encrypt the userid/pw and pass it in a URL or form variable. This would not work, though, because the Crystal report would have no way to decrypt it. The Encrypt() function would only have been useful to us if we were passing information from a CF page TO another CF page. Not being too familiar with Crystal Reports (I am not creating them--someone else is), I wasn't sure if Crystal Reports even has a similar Decrypt() function. So Why didn't we use the CFREPORT TAG? Well, believe me, I would have liked to. But, no matter what I did, I just could NOT get it to work. Even after combing through the archives and the Allaire site and implementing all of the suggestions, I still kept getting errors like the report server is too busy (even though I knew I was the only one on it), File does not exist or is not in a directory that is accessible to the ColdFusion service (this one happened whether I was calling the report on the report server, or whether I was calling the report from the SAME directory using an absolute path.), and a host of other errors. Final solution: We ended up creating the actual form in Coldfusion, then using another CF template for the action page. On that page, we called our stored procedure to verify that a valid employee was logging in. If not, an error is displayed indicating such. If so, then a continue button is displayed and all of the fields from the first form are carried over via hidden form fields (minus the db userid/pw). Both of these CF templates are on the CF server, of course. This form on the CF action page (that displays the continue button) submits to an ASP page that is sitting on the report server. That ASP page
CF-driven In-browser HTML editor
Hello, First question: Has anyone out there seen a Cold Fusion tag or app driving an in-browser HTML editor for folks who need to submit content to a web page but don't know HTML? Second question: http://www.siteobjects.com/ offers EzEdit and SoEdit which fit the bill perfectly - but after two days I am unable to get either to work properly. Has anyone had any luck with this? Thanks. -Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: High usage web sites.
Nice posting. Thanks! The following (50ms) appears low to me. (But what do I know?) Do these pages have relatively little content delivered from DB to page by CF? I have a Yellow Pages application I'm working on. It typically takes longer than 50ms to deliver a list of 100 Yellow Page Headings, or 50 usiness Listings (Business Name, Contact, City, BitAnd calcs/display), to a page from a cached query on an unloaded server (single PIII 800MHz). best, paul At 07:51 AM 5/18/01 -0500, you wrote: Most, if not all, CF Pages return in under 50ms on onloaded servers. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Notes database connection
Lloyd, Lotus has a product called LEI that you can use to query data from ODBC data sources (SELECT, INSERT, etc.). We use it in some of our Notes apps to get data from our AS400 as well as a SQL server. Best regards, Rob Thanks to everyone who responded. It is disappointing that no one has had any success in doing what we are needing to do, which is exchanging data between Notes and our SQL Server database. We just wanted to get names, addresses, phone numbers, etc. out of our db and into the Notes Personal Address Book for our sales people to download into their Palms. Sounds like a simple thing, but I guess we'll have to wait for Bill to buy and kill Notes before we can get this app written. If anyone has any other ideas, we'd like to hear them. BTW, I did hear about ZMerge and have downloaded an eval. If it works I'll repost and let everyone know about it. Thanks again, Loyd Campbell Bank One International Corp. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
deleting records in a dbase III table
I am stumped as to why I cannot delete records from a dbase III dbf file that is defined as an odbc source using the MS dbase 3 ODBC driver. I can update, insert, but no delete. Any and all suggestions would be greatly appreciated. Terry The datasource is defined as test.dbf and pointing to the directory the dbf files are located. The table I am using is work.dbf. I am using delete from work ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-driven In-browser HTML editor
Hello Jason, cant really answer your second question but, as for the first I use HTML_Area (the lite version at present). You can download this from Alliares tag gallery, I think it is pretty good but there are a few idiosyncracies with it and it is deffinately worth paying to get the full version with the unencrypted source code. Cheers, Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 14:12 To: CF-Talk Subject: CF-driven In-browser HTML editor Hello, First question: Has anyone out there seen a Cold Fusion tag or app driving an in-browser HTML editor for folks who need to submit content to a web page but don't know HTML? Second question: http://www.siteobjects.com/ offers EzEdit and SoEdit which fit the bill perfectly - but after two days I am unable to get either to work properly. Has anyone had any luck with this? Thanks. -Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report Solution (long)--My shared experience
hmmm. Good question. Yes, I suppose they could do that. Depending on how you set up your Crystal Report, however, you probably could make it more difficult for them to 'guess' what fields the report is expecting. For example, this is what my final CF page has in the source code: FORM NAME=continue ACTION=http://our.report.server.com/callreport.asp; METHOD=POST onSubmit=return _CF_checkcontinue(this) input type=hidden name=reportname value=whatever.rpt input type=hidden name=DSN value=yourDSN input type=hidden name=DB_SID value=yourdbschema input type=hidden name=param1 value=firstReportPrompt input type=hidden name=param2 value=1001 input type=hidden name=param3 value=0902 input type=hidden name=param4 value=1 input type=hidden name=param5 value=1 input type=hidden name=param6 value=1 input type=hidden name=param7 value= input type=hidden name=param8 value= input type=hidden name=param9 value=ALL input type=hidden name=param10 value=ALL Since the prompt values are being passed from a template, the report will not prompt the user for any of the needed values when the report displays in the browser. So, even though they may see in the source code that param2 is 1001, they may not figure out that the report is requesting (in MMYY format), the start of the fiscal year for the year that the user chose from the form dropdown list (in this case, 2001). Likewise, there is logic in my CF page to determine the end of the fiscal year, based on their choice (2001) from the previous page. See what I mean? Likewise, for param9/10, they would have no idea what ALL indicates, nor would they be able to guess what the other possible values would be. In our case, however, we are granting access to any employee to run any report (hey, I don't call the shots--that's how the group asked me to build it :), so we aren't too concerned with people taking the time to do something like that. The only reason that we are asking for an NT id and password is just so that we can validate that it is, in fact, a valid employee logging on. We may change this somewhere down the line and actually restrict access to certain reports, I don't know. Our whole concern with not exposing the db id/pw was because we didn't want people to be able to bypass reports and gain access to the actual Oracle db. If we DO end up restricting access based on groups somewhere down the road, I will be sure to post an update! :) Good luck! Original Message Follows From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Report Solution (long)--My shared experience Date: Fri, 18 May 2001 09:01:21 -0400 I haven't done anything like this but may have to soon. Question: is there anything stopping a user from creating an html page on their desktop with a form that posts to the report server ASP page, just like your action page does? If not, it appears that anyone could run any report if they can figure out what to put in the form fields. Or is there a step I missed? -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:49 AM To: CF-Talk Subject: Report Solution (long)--My shared experience Okay, all. I just spent 4 days tearing my hair out trying to figure out how to pass CF variables to a Crystal Report(8) (while hiding the db userid and password). I searched the archives and the Allaire site and noticed that many other people have been gnashing their teeth over the same topic, so I thought I would share our solution. It's not pretty, and I'm not looking forward to supporting it, but it will .. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Harpoon: Disappearing Form Elements
I'm using the great new Harpoon Cascading Menu, and I have a search form on the page with the menu, and on mouse over of the menu, the menu expands and the pop up select in the form disappears. I've tried moving the form around, moving it to a different layer, and only including those two elements on a page. Am I doing something wrong? What else could be causing this? Code follows. Paul Sizemore Finish Line 3308 N Mitthoeffer Rd Indianapolis, IN 46235 W: 317-899-1022 ext 3516 cfinclude template=Menu_Flash.cfm table tr td form action=Index.cfm?AppID=99 method=post name=Submit id=Submit style=normaltext input class=normaltext type=text name=textfield maxlength=30 size=10 : select name=select class=normaltext option selectedPerson/option optionDocument/option /select input type=hidden name=MaxRows2 value=100 input type=submit name=Submit2 value=Go class=normaltext height=12 /td /tr /table ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: High usage web sites.
Over 50ms from a cached query? That sounds kinda high to me. Just to make sure we're talking about the same thing, I'm measuring from the page processing time in the DEBUG info for that page, not what the load generator or anything else is telling me. What other operations are you doing on the data. If I'm pulling info from a cached query and dumping it into a table (and that's about it), then I'm almost always under 50ms. Do you have a lot of other application overhead in an Application.cfm file or anything? We don't use a lot of custom tags, as there seems to be about a 10-20ms overhead for each entry into a custom tag. I figure this is from setting up scopes, etc. Not sure if CF5 has alleviated any of that. Paul Smith wrote: Nice posting. Thanks! The following (50ms) appears low to me. (But what do I know?) Do these pages have relatively little content delivered from DB to page by CF? I have a Yellow Pages application I'm working on. It typically takes longer than 50ms to deliver a list of 100 Yellow Page Headings, or 50 usiness Listings (Business Name, Contact, City, BitAnd calcs/display), to a page from a cached query on an unloaded server (single PIII 800MHz). best, paul At 07:51 AM 5/18/01 -0500, you wrote: Most, if not all, CF Pages return in under 50ms on onloaded servers. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-driven In-browser HTML editor
First question: Has anyone out there seen a Cold Fusion tag or app driving an in-browser HTML editor for folks who need to submit content to a web page but don't know HTML? We use HTMLAREA by iAutomated, http://www.iautomated.com/store/default.cfm?iid=2. Pretty happy with it so far. -- Tim Bahlke ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: deleting records in a dbase III table
Is there an error returned? If memory serves me right, DBaseIII also uses a command called: PACK Not sure it is needed in this case however. -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 9:18 AM To: CF-Talk Subject: deleting records in a dbase III table I am stumped as to why I cannot delete records from a dbase III dbf file that is defined as an odbc source using the MS dbase 3 ODBC driver. I can update, insert, but no delete. Any and all suggestions would be greatly appreciated. Terry The datasource is defined as test.dbf and pointing to the directory the dbf files are located. The table I am using is work.dbf. I am using delete from work ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 4.5.2 docs update
Here's a page with late changes and additions to the CF Server and Studio documentation: http://www.allaire.com/documents/cf45docs/cfupdate.htm I've long been bothered by the inability to maintain horizontal cursor position in Studio. Didn't know that Studio has addressed this. The ColdFusion 4.5.2 documentation is available at http://www.allaire.com/developer/documentation/ColdFusion.cfm -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [the big export]
yes, import. I'm using SQL 2000 I know that there is a DTS object but I don't know how can I use it to transfer 1000s of txt files easily... Help!! :) - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 6:44 PM Subject: Re: [the big export] By export I assume you mean import. Also what database are you using? Almost every database has an import feature or an import command. Michael Lugassy [EMAIL PROTECTED] wrote: I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: the big export
thanks for the tip, paul! I keep seeing this learn VB tips and I was wondering - are there any good and quick resources on learning VB on the net? something you know about?? Michael. - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 12:49 AM Subject: RE: the big export This is definately something I would consider off-line processing. In most cases, CF is not suitable for these types of tasks, espcially if it's a task that you'll have to repeat on scheduled basis. If this is a one-time event (are you sure? :) ) then you can way the time for development vs. time of processing. one time operation? Developing it in CF is probably the quickest solution. Won't be the quickest app in the world. recurring task? Do it in C, or even better, VB. It would be quicker to develop this in VB than C, and the performance increase that C would give you is probably negligible. Writing an offline recurring task like this in CF would be a mis-use of your CFServer's resources. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] 619.222.7082 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:49 AM To: CF-Talk Subject: the big export I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: EnableCFoutputOnly not cutting the mustard in Custom Tag
Patricia and others, Thanks for your replies, everyone. Patricia's solution is the sort of answer I was looking for. I didn't want to use a trimmed caller variable, as doing so is three times more complicated than just getting the results via the custom tag itself. Fine for me, but I intend this to be used by others in my company, and the simpler the usage the better. So, I can use: cf_MyCustomTag Instead of : cf_MyCustomTag cfoutput#trim(myCallerVariable)#/cfoutput See the value in this? Hope it helps someone else. There is a way for my tag to set a caller variable, however, without automatically outputting the custom tags result in place of the custom tag call: cf_MyCustomTag returnOutput=No cfoutput#myCallerVariable#/cfoutput !--- this doesn't need a trim, since it's not the variable itself that had been getting the extra spaces --- The returnOutput is an optional attribute in my tag, and you omit it to return the value in place of the custom tag call itself. Thanks again, Jamie P.S. Here is a third alternative, if, for some reason, you're avoiding tags in your custom tag (just a use of the CF comment markers): cfsetting enablecfoutputonly=Yes!--- Author: Jamie Jackson Name: MyCustomTag ---!--- ---cfparam name=attributes.conversion default=!--- ---cfparam name=attributes.dateTime default=!--- ---cfparam name=attributes.returnOutput default=Yes!--- ---cfscript Processing code here /cfscript On Thu, 17 May 2001 16:49:15 -0400, in cf-talk you wrote: Use CFSCRIPT/CFSCRIPT in conjunction with CFSETTING CFSCRIPT will cancel ALL output... even that inside of CFOUTPUT tags. So I suggest this configuration (tried and testing in CF pages that send info to MM Generator.. one of the pickiest White Space haters on the planet). cfsetting enablecfoutputonly=yes CFscript [all kinds of stuff here, building one string] /cfscript cfoutput#thestring#/cfoutput |-Original Message- |From: Jamie Jackson [mailto:[EMAIL PROTECTED]] |Sent: Thursday, May 17, 2001 4:01 PM |To: CF-Talk |Subject: EnableCFoutputOnly not cutting the mustard in Custom Tag | | |I've got a custom tag which returns a small string, but I can't get |rid of the extra spaces around the string when it's called. This has |screwed me up several times, and I haven't found a solution yet. |EnableCFoutputOnly gets rid of most of the garbage whitespace, but it |leaves a space to the left and right of the desired output string. | |### Custom Tag |cfsetting enableCFoutputOnly=yes |cfscript |FinalValue = result_of_a_bunch_of_processing; |writeOutput(FinalValue); |/cfscript |cfsetting enableCFoutputOnly=no | |### Calling Script |FinalValue = cf_MyCustomTag | |## Results in Browser ## |FinalValue = result_of_a_bunch_of_processing | |But, I would like to see: |FinalValue = result_of_a_bunch_of_processing | |See those spaces that show up? What's causing them? How do I get rid |of them? | |Obviously there are workarounds, such as: |*Send the string back to the calling script with caller.FinalValue | |However, I would like to know if this can work without going the |caller-scope route. | |Thanks, |Jamie | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: deleting records in a dbase III table
Are you getting an error? If so what is it please post the code and I'll take a look... I have worked a bit with dbf files and may be able to help. Also helpfull would be the os and cf version you are using. Thanks, Frederic Terry Troxel wrote: I am stumped as to why I cannot delete records from a dbase III dbf file that is defined as an odbc source using the MS dbase 3 ODBC driver. I can update, insert, but no delete. Any and all suggestions would be greatly appreciated. Terry The datasource is defined as test.dbf and pointing to the directory the dbf files are located. The table I am using is work.dbf. I am using delete from work ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: the big export
Aaron, the DTS sounds VERY good and USEFUL on paper, but I didn't know how to use it on MULTIPLE files where the datasource, is, in fact, 100s of 1000s of txt files.. do you know how to batch import a complete directory, for example? Michael. - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 5:34 AM Subject: Re: the big export If this is going into SQL Server, why not use DTS within SQL Server to do this? If it is going to be more than a one time thing, then you could make a CF page to upload the files to the server and then execute the DTS package via CF. - Original Message - From: Jason Lotz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 3:55 PM Subject: Re: the big export What exactly do you mean? You could use VB, C, C++, ASP, ColdFusion, etc. Are you asking what would be fastest? If so, I would recommend VB or C, but I have no idea what languages you know. Why don't you just write it in CF if you are most familiar with it and just let it run for awhile? No matter what language you use, it's not going to be quick. - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 9:48 AM Subject: the big export I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-driven In-browser HTML editor
Second question: http://www.siteobjects.com/ offers EzEdit and SoEdit which fit the bill perfectly - but after two days I am unable to get either to work properly. Has anyone had any luck with this? SoEdit is still early beta with several features missing. I use EzEdit in a few places without any problems. What issues are you seeing? Ken ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-driven In-browser HTML editor
I have used EZedit and it works fine. Send me an example of your code and the paths to the ezedit files and I will try and help you. Terry - Original Message - From: Jason Blum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 6:12 AM Subject: CF-driven In-browser HTML editor Hello, First question: Has anyone out there seen a Cold Fusion tag or app driving an in-browser HTML editor for folks who need to submit content to a web page but don't know HTML? Second question: http://www.siteobjects.com/ offers EzEdit and SoEdit which fit the bill perfectly - but after two days I am unable to get either to work properly. Has anyone had any luck with this? Thanks. -Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: CF vs Perl]
http://www.faqs.org/faqs/www/cgi-faq/ another programmer [EMAIL PROTECTED] wrote: Watch the I thinks I'd bet because it's just that, not I have observed or I know I think Perl, in the past, would've been frowned upon because the execution of the perl engine would've been required for every request, but now it's a part of Apache... if it's compiled as so... which'd lessen the overhead. (correct me if I'm wrong, I read this awhile ago and my memory isn't so good anymore ;-) I'd bet CF would use more resources, generally CF does use more constant memory resources, because it holds DB connections for applications and usually session/server/application variables. Perl is unlikely to do so, as most web application servers frown on holding on to DB connections, because it's usually the programmers code not the web application servers code that 'hold' the connections, and are usually implemented... in not the best fashion. However, while it is using more memory, it also gains speed because of this. Easy application session management means it's more likely to be used which'd mean faster access to such resources (shared information), and the DB connections don't have to be opened/closed all the time, and can be limited to strict number. Speed wise, I'd think CF would be quicker if Perl doesn't keep a cache of requested files... As for on-request memory, I'd think each request would demand more memory for Perl... reasoning: the libraries used and the methods Perl programmers would probably use. cf_outburstie. I'm a guessing idjit, everything I say is wrong, don't trust a word I say blah! and people (I mean me, not anyone else) who don't use 2 programming languages at a similar level/usage should keep their opinions to themselves on comparisons/cf_outburst These are just my thoughts, I haven't used Perl in a web environment for just over a year, and I certainly didn't use it very much. Most of the companys code was being translated into CF at the time... I'd like to hear of anyone on this list who actually uses perl (I do, but rarely) to voice their knowledge... btw is the compiler 'perl' the language 'Perl'? man, i've been hanging out for Perl CD bookshelf second edition for awhile... my copy is meant to arrive in June according to the bookstore... hope they're right... I _do_ love Perl, but rarely have the time to use it at the moment :-( - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 5:10 AM Subject: CF vs Perl Hi all. I'm curious what the difference is, resource-wise, between CF and Perl for doing stuff like writing to a database, sending out simple forms, etc. Does CF use much more of the server's resources? Or is it comparable? Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: profanity checker
Thanks Raymond, I will look at that regular expression, as I can see it being a loophole, people putting spaces between letters. Like your choice for a bad word!! Cheers Will -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 13:22 To: CF-Talk Subject: RE: profanity checker cfloop query=getprofanities cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword, getprofanities.rate1, ALL) /cfloop One mistake is the use of quotes. In a function, if you do Function(foo), foo is a string. But you want to use the value of getprofanities.badword, so you don't use the quotes. Try rewriting it like so: cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword,getprofanities.rate1, ALL) You also don't need the getprofanities. in front of badword and rate1. Since you are looping over the query, it is implied. Another thing you may want to look out. Consider the case where Clinton is the bad word. What happens if I do: C l i n t o n Your checker won't find that word. What I've done in the past is to take the bad word and translate it into a regex that looks like this: C[[:space:]]l[[:space:]]etc This will make it match the test above. You would also change ReplaceNoCase w/ REReplaceNoCase. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: profanity checker
Thanks John, It seems to be working now. Incidentally, there wasn't a where clause yet, I have added it now. Many Thanks Will -Original Message- From: John [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 13:39 To: CF-Talk Subject: RE: profanity checker It looks to me like you are setting the variable newlist equal to the form field after a replace. The problem lies mostly that every time you loop over this you reset the variable. So of the list result from the query has no matches then your variable will be equal to the original form field. The second problem I see is the variables you are passing the function. On a final note you said the administrator could set the level. I don't see a where clause in the query. However, try this. cfset newlist = #form.bodytext# cfloop query=getprofanities cfset newlist = ReplaceNoCase(#newlist#, #getprofanities.badword#, #getprofanities.rate1#, ALL) /cfloop -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 5:22 AM To: CF-Talk Subject: profanity checker Hi all, I posted this a few days ago, and was directed towards some custom tags, but none of them seem to work exactly how I want them, and I would like to come up with something myself. I have a Access db table which contains a list of badwords, and 3 ratings for each. The administrator sets the profanity rating, with 1 being the most strict and 3 the least. Assuming it is set to 1, the badwords should be replaced with corresponding number of *. So, I run a query, selecting all the badwords and their corresponding 'cleaned up' versions. Then I need to loop over a form field, checking each word in it to see if it matches a badword, and replacing it with it's 'cleaned up' version if it does. !--- Pull out all the bad words from the database --- cfquery name=getprofanities datasource=#APPLICATION.chatdsn# SELECT ID, badword, rate1 FROM tbl_profanity /cfquery !--- Loop over the profanity list and compare with words in the bodytext --- cfloop query=getprofanities cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword, getprofanities.rate1, ALL) /cfloop This code doesn't seem to work, and to be honest I'm not surprised, but my head seems to be somewhere else today and I just can't get it!!! Any help anyone..please?? :) TIA Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: EnableCFoutputOnly not cutting the mustard in Custom Tag
iif(isdefined('myVar'),de(''),setvariable('myVar',myDefaultValue)); The following requires less typing (and is more intuitive to me). It is equivalent, isn't it? if (NOT isdefined('myVar')) { myVar = MyDefaultValue; } Thanks for your reply, Jamie On Fri, 18 May 2001 11:19:09 +1000, in cf-talk you wrote: Dear Jamie, Please try the below code to emulate a 'cfparam' from within a 'cfscript' block !---begin test code !--- Try the following code with 1. the //myVar =2; line commented out, result should be myVar has a value of '1' 2. the //myVar =2; line uncommented, result should be myVar has a value of '2' --- cfscript //myVar = 2; mydefaultValue = 1; iif(isdefined('myVar'),de(''),setvariable('myVar',myDefaultValue)); /cfscript cfoutput #myVar# /cfoutput !---end test code Good luck, Jared Clinton Software Engineer Maxi Multimedia NEC Australia. -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, 18 May 2001 7:34 To: CF-Talk Subject: RE: EnableCFoutputOnly not cutting the mustard in Custom Tag 1) Nope... as of yet no way to do a cfparam inside of cfscript. That whole limitation of only function calls valid from within cfscript and all. As of my knoweldge this still is the case in cf 5. 2) I also believe this is nope. Check my post (came in just after your self-posted solution). |-Original Message- |From: Jamie Jackson [mailto:[EMAIL PROTECTED]] |Sent: Thursday, May 17, 2001 4:40 PM |To: CF-Talk |Subject: Re: EnableCFoutputOnly not cutting the mustard in Custom Tag | | |Actually, if I modify the code as follows, I can get rid of the space |(smash all the preceding and following tags together). However, this |brings up another question that I asked a while ago: Is there still no |slick way to do a cfscript version of cfparam? Also, is the |smashing together of tags (a bit messy) the only way to accomplish my |original goal? | |Here is the working code: | |cfsetting enableCFoutputOnly=yescfparam name=1 |default=cfparam name=2 default=cfparam name=3 |default=cfscript |FinalValue = result_of_a_bunch_of_processing; |writeOutput(FinalValue); |/cfscriptcfsetting enableCFoutputOnly=no | |Thanks, |Jamie | |On Thu, 17 May 2001 16:01:09 -0400, Jamie Jackson [EMAIL PROTECTED] |wrote: | |I've got a custom tag which returns a small string, but I can't get |rid of the extra spaces around the string when it's called. This has |screwed me up several times, and I haven't found a solution yet. |EnableCFoutputOnly gets rid of most of the garbage whitespace, but it |leaves a space to the left and right of the desired output string. | |### Custom Tag |cfsetting enableCFoutputOnly=yes |cfscript |FinalValue = result_of_a_bunch_of_processing; |writeOutput(FinalValue); |/cfscript |cfsetting enableCFoutputOnly=no | |### Calling Script |FinalValue = cf_MyCustomTag | |## Results in Browser ## |FinalValue = result_of_a_bunch_of_processing | |But, I would like to see: |FinalValue = result_of_a_bunch_of_processing | |See those spaces that show up? What's causing them? How do I get rid |of them? | |Obviously there are workarounds, such as: |*Send the string back to the calling script with caller.FinalValue | |However, I would like to know if this can work without going the |caller-scope route. | |Thanks, |Jamie | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: High usage web sites.
what website are we talking about? ibsys.com? - Original Message - From: Edward Smith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 2:51 PM Subject: Re: High usage web sites. We do. We serve about 3 million pages per day lately, with our hourly peaks usually in the 400-500K range. About half of these are CF based - ranging from very simple no-query pages to pages with a dozen queries. The most hit pages have 2-3 queries on them. Our DB server is a Sun E450 4x400MHz, 4GB RAM, Oracle 8i. Our CF Servers are 8 Dell 2300/2400 boxes. All are Dual PIII, ranging from 400 to about 600MHz. 2GB RAM each, 2x9 or 2x18GB 10K drives mirrored. They run NT4 and IIS4, CF4.51 SP2. No other software. With this setup, we're capable of about 1 million CF pages per hour, or a 4x spike over normal peak traffic. Beyond that, we switch over to more aggressive DB caching, losing freshness in the content as a result - but its worth it. These boxes are load balanced with Big/IP boxes. Most, if not all, CF Pages return in under 50ms on onloaded servers. On loaded servers (ie, at about 2x our normal peak traffic (or about 500K pages per hour)), we see 300-600ms response time on many pages. At full load (1M pages per hour), response times are in the 1-2 second range. At this point, we implement query caching on previously uncached queries, and our response time drops back under a second, as we rise to about 2M pages per hour. We can't get past 2M pages per hour (or about 70 pages per second per CF Server). As we load on clients, response time increases, but thruput remains constant. Treaking CF threads has not helped positively. Think we're just at the limit of CF for our application mix. Hope this helps. Craig Dudley wrote: Hi, Anyone have experience of using Coldfusion with very large usage web sites? Somewhere in the region of 240k - 250k page impressions an hour. If so, what sort of hardware would be needed? I know it's a bit vague, the site would be fairly basic database searches through say, 40-50k records, so we'd probably have to go for a seperate db server. Thanks in advance for any help. Regards, Craig. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: deleting records in a dbase III table
Here is what is returned: Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC dBase Driver] Could not delete from specified tables. SQL = delete from work Data Source = test.dbf SQL = delete from work The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:52). - Original Message - From: Adkins, Randy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 6:38 AM Subject: RE: deleting records in a dbase III table Is there an error returned? If memory serves me right, DBaseIII also uses a command called: PACK Not sure it is needed in this case however. -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 9:18 AM To: CF-Talk Subject: deleting records in a dbase III table I am stumped as to why I cannot delete records from a dbase III dbf file that is defined as an odbc source using the MS dbase 3 ODBC driver. I can update, insert, but no delete. Any and all suggestions would be greatly appreciated. Terry The datasource is defined as test.dbf and pointing to the directory the dbf files are located. The table I am using is work.dbf. I am using delete from work ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-driven In-browser HTML editor
Another option is eWebEditPro by Ektron (www.ektron.com) eWebEdit is actually the editor used in Spectra. --- Billy Cravens HR Systems, Sabre [EMAIL PROTECTED] -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:31 AM To: CF-Talk Subject: RE: CF-driven In-browser HTML editor First question: Has anyone out there seen a Cold Fusion tag or app driving an in-browser HTML editor for folks who need to submit content to a web page but don't know HTML? We use HTMLAREA by iAutomated, http://www.iautomated.com/store/default.cfm?iid=2. Pretty happy with it so far. -- Tim Bahlke ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dedicated Hosting
I'm about to start a personal project which requires a dedicated server, anyone can recommened the cheapest DEDICATED server? NT/WIN2K a must. Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Performance Tuning
Check out http://www.allaire.com/services/consulting/ J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Losing - If at first you don't succeed, failure may be your style. ~despair.com -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 5:48 AM To: CF-Talk Subject: CF Performance Tuning Good Morning List I have read posts talking about Allaire Consultants that come into a company and play around with your CF setup in the hopes of boosting performance. We are thinking about bringing in such a person. I'm fishing for information on how we set something like this up. Is it through Allaire/MM directly or do we need to get in touch with an Allaire Partner in our area (NC)? If we need to get in touch with a partner locally, can anyone pass along some recommendations? Thanks,. Tim Bahlke ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-driven In-browser HTML editor
i am using ezedit - I'll send you my code. very very basic implementation - but good enough for my paltry standards. Eric From: [EMAIL PROTECTED] (Jason Blum) Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: CF-driven In-browser HTML editor Date: Fri, 18 May 2001 09:12:17 -0400 Hello, First question: Has anyone out there seen a Cold Fusion tag or app driving an in-browser HTML editor for folks who need to submit content to a web page but don't know HTML? Second question: http://www.siteobjects.com/ offers EzEdit and SoEdit which fit the bill perfectly - but after two days I am unable to get either to work properly. Has anyone had any luck with this? Thanks. -Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTRANSACTION
AHH... Use the ISOLATION attribute for additional control over how the database engine performs locking during the transaction. This is what I was looking for!! -Original Message- From: Semrau, Steven L Mr SRA [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 1:14 PM To: CF-Talk Subject: RE: CFTRANSACTION Are you saying that the example in the documentation with regards to using the ACTION of /ROLLBACK and /COMMIT does not work? I haven't had a need to use CFTRANSACTION in 4.5 as of yet. From Documentation: Within the transaction block, you can commit a transaction by nesting the cftransaction ACTION=COMMIT/ tag or roll the transaction back by nesting the cftransaction ACTION=ROLLBACK/ tag within the block. Within one transaction block, you can write queries to more than one database; however, you must commit or rollback the transaction to a particular database prior to writing a query to another database. By using CFML error handling, you have control over whether each transaction is to be committed based on the success or failure of the database query. Use the ISOLATION attribute for additional control over how the database engine performs locking during the transaction. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 2:54 PM To: CF-Talk Subject: RE: CFTRANSACTION As I understand it, CFtransaction ONLY does just that...it rolls back all database operations within it if any of them fails. The only way I'm aware of to be sure that there is no transaction between one query and another is to use cflock around themor, if using SQL, to retrieve the new ID with @@identity in the same query. D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 1:46 PM To: CF-Talk Subject: Re: CFTRANSACTION I don't think a flaw in CFTRANSACTION would not necessarily be a candidate for causing this kind of problem. CFTRANSACTION is concerned with defining a set of (usually) database operations as a transaction for roll back purposes. Most of the problems we've had with this tag stem from misuse as opposed to reliability of the tag. Are there problems with this tag that I am not familiar with Brian - Original Message - From: Bill King [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 11:47 AM Subject: RE: CFTRANSACTION Speaking of purpose-free the CFTRANSACTION is not even reliable for multiple queries. I had a problem with users on a high-volume site having OrderIDs duplicated and caused major problems. I fixed it by getting the ID within my order query with that lovely SET NO COUNT option in SQL 7. I wonder if there are going to be any improvements in the future of this tag? - BILL - -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 10:06 AM To: CF-Talk Subject: RE: CFTRANSACTION Yes, as written this use of CFTRANSACTION is purpose-free. I'll have to remember that phrase... extrememly diplomatic! Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: the big export...ColdFusion.NET?
Michael, before you go and learn VB, realize that vb is morphing into vb.net. Although the syntax is similar, the changes/improvements are quite drastic. You may want to skip picking up a book on the old VB and concentrate on learning the new stuff. Microsofts site is a great place to start though. bigfatsegue The whole dotNet thing is very interesting... Microsofts try at interpreted code, like java. Which leads me to think back to Macromedia's repeatedly saying dotNet in the press release that they were commited to dotNet. It isn't too far of a stretch to say that Neo may be ported to dotNet, and specifically C#, which is basically java anyway. The more I think about it, the more I think it's a no brainer for Macromedia to do a C# port. It will probably run much faster on Windows. The only risk would be confusing the users as to which is better. That's my random Friday thought. Anyone have any comments? /bigfatsegue jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:57 AM Subject: Re: the big export thanks for the tip, paul! I keep seeing this learn VB tips and I was wondering - are there any good and quick resources on learning VB on the net? something you know about?? Michael. - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 12:49 AM Subject: RE: the big export This is definately something I would consider off-line processing. In most cases, CF is not suitable for these types of tasks, espcially if it's a task that you'll have to repeat on scheduled basis. If this is a one-time event (are you sure? :) ) then you can way the time for development vs. time of processing. one time operation? Developing it in CF is probably the quickest solution. Won't be the quickest app in the world. recurring task? Do it in C, or even better, VB. It would be quicker to develop this in VB than C, and the performance increase that C would give you is probably negligible. Writing an offline recurring task like this in CF would be a mis-use of your CFServer's resources. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] 619.222.7082 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:49 AM To: CF-Talk Subject: the big export I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: profanity checker
This is a bit off topic, but back in the 'old days', I wrote a curse word checker that had the option to replace the curse word with what I called 'cartoon cursing'. Ie, it would change Clinton to $%^@!@# : === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 10:09 AM To: CF-Talk Subject: RE: profanity checker Thanks Raymond, I will look at that regular expression, as I can see it being a loophole, people putting spaces between letters. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: profanity checker
This is really no way to check for all kinds of bad words. Let's use the Clinton scenario wCiLlIlNiTaOmN If you look closely you see I put the word willion in between where there were space for clinton. The only way to insure there are no bad words is if you have a place where you can manually screen each thing that is put through. If not you will only get the ones that are above abvious. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 10:09 AM To: CF-Talk Subject: RE: profanity checker Thanks Raymond, I will look at that regular expression, as I can see it being a loophole, people putting spaces between letters. Like your choice for a bad word!! Cheers Will -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 13:22 To: CF-Talk Subject: RE: profanity checker cfloop query=getprofanities cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword, getprofanities.rate1, ALL) /cfloop One mistake is the use of quotes. In a function, if you do Function(foo), foo is a string. But you want to use the value of getprofanities.badword, so you don't use the quotes. Try rewriting it like so: cfset newlist = ReplaceNoCase(bodytext, getprofanities.badword,getprofanities.rate1, ALL) You also don't need the getprofanities. in front of badword and rate1. Since you are looping over the query, it is implied. Another thing you may want to look out. Consider the case where Clinton is the bad word. What happens if I do: C l i n t o n Your checker won't find that word. What I've done in the past is to take the bad word and translate it into a regex that looks like this: C[[:space:]]l[[:space:]]etc This will make it match the test above. You would also change ReplaceNoCase w/ REReplaceNoCase. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Configuring CF45 for Java
The problem I am experiencing is that I have developed a Java Applet that creates a Menu system, It works fine on the development macine with Java installed but when I check on another Machine there I get a Class not found Exception. I have assumed that this is becuase CF isn't set up to run JVM and doesnt have the necessary classes on the system. Is this true? I'm a bit confused. If it's an applet, it shouldn't need to run anything on the server, generally. The applet and its supporting classes get downloaded to the browser. If this is the case, it sounds like you simply didn't move all of the classes needed to the appropriate web directory. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: deleting records in a dbase III table
Can you delete a single record, e.g. delete where key=value ? - Original Message - From: Terry Troxel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 9:16 AM Subject: Re: deleting records in a dbase III table : Here is what is returned: : : Error Diagnostic Information : ODBC Error Code = S1000 (General error) : : [Microsoft][ODBC dBase Driver] Could not delete from specified tables. : : SQL = delete from work : : Data Source = test.dbf : : SQL = delete from work : : The error occurred while processing an element with a general identifier of : (CFQUERY), occupying document position (2:1) to (2:52). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: High usage web sites.
No, all the sites that are listed on the map: http://www.ibsys.com/aboutus/map.html Michael Lugassy wrote: what website are we talking about? ibsys.com? - Original Message - From: Edward Smith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 2:51 PM Subject: Re: High usage web sites. We do. We serve about 3 million pages per day lately, with our hourly peaks usually in the 400-500K range. About half of these are CF based - ranging from very simple no-query pages to pages with a dozen queries. The most hit pages have 2-3 queries on them. Our DB server is a Sun E450 4x400MHz, 4GB RAM, Oracle 8i. Our CF Servers are 8 Dell 2300/2400 boxes. All are Dual PIII, ranging from 400 to about 600MHz. 2GB RAM each, 2x9 or 2x18GB 10K drives mirrored. They run NT4 and IIS4, CF4.51 SP2. No other software. With this setup, we're capable of about 1 million CF pages per hour, or a 4x spike over normal peak traffic. Beyond that, we switch over to more aggressive DB caching, losing freshness in the content as a result - but its worth it. These boxes are load balanced with Big/IP boxes. Most, if not all, CF Pages return in under 50ms on onloaded servers. On loaded servers (ie, at about 2x our normal peak traffic (or about 500K pages per hour)), we see 300-600ms response time on many pages. At full load (1M pages per hour), response times are in the 1-2 second range. At this point, we implement query caching on previously uncached queries, and our response time drops back under a second, as we rise to about 2M pages per hour. We can't get past 2M pages per hour (or about 70 pages per second per CF Server). As we load on clients, response time increases, but thruput remains constant. Treaking CF threads has not helped positively. Think we're just at the limit of CF for our application mix. Hope this helps. Craig Dudley wrote: Hi, Anyone have experience of using Coldfusion with very large usage web sites? Somewhere in the region of 240k - 250k page impressions an hour. If so, what sort of hardware would be needed? I know it's a bit vague, the site would be fairly basic database searches through say, 40-50k records, so we'd probably have to go for a seperate db server. Thanks in advance for any help. Regards, Craig. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Best way to limit access to a specific template from only previous template?
What is the best way to limit access to a specific template? Template2 can only be accessed via template1. Disallowing user access to template2 simply by typing in the specific url for template2. I see where CFABORT can limit access to a ip addresses as exampled in the manual Advanced Application Development, page 520; CFIF Left(CGI.RMOTE_ADDR, 11) NEQ 208.193.16. H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF Can I modify the code so that it can limit via the calling template? Thanks, Jerre ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to limit access to a specific template from only previous template?
There are probably a few ways you can do this. 1) You can check cgi.http_referer(check my spelling on that). It returns the URL of the page where you came from. 2) Don't have a page2.cfm! Have page1.cfm link to itself, and if the proper URL variable is returned, you can CFINCLUDE the contents of page2. Of course, someone could bookmark the new url, ie, page1.cfm?load2=1. You could use a form on page 1, and if IsDefined(Form.LoadPage2) is defined, then load page 2. That would stop people from bookmarking page2 (at least as far as I know), but it wouldn't prevent someone from putting the form on a different page and doing ACTION=yourserver/page1.cfm. Ditto for the URL solution. 3) Maybe set asession var on page1, and if it doesn't exist on page2, push them back? Of course, people could still link to page2, but their link would only work if the user had actually gone to page1 sometime in the last X minutes, where X is your sessiontimeout. I'm just rambling now. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 11:59 AM To: CF-Talk Subject: Best way to limit access to a specific template from only previous template? What is the best way to limit access to a specific template? Template2 can only be accessed via template1. Disallowing user access to template2 simply by typing in the specific url for template2. I see where CFABORT can limit access to a ip addresses as exampled in the manual Advanced Application Development, page 520; CFIF Left(CGI.RMOTE_ADDR, 11) NEQ 208.193.16. H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to limit access to a specific template from only p revious template?
CFIF #CGI.HTTP_REFERER# IS template.cfm *** AUTHORIZED CFELSE *** NOT AUTHORIZED /CFIF -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 11:59 AM To: CF-Talk Subject: Best way to limit access to a specific template from only previous template? What is the best way to limit access to a specific template? Template2 can only be accessed via template1. Disallowing user access to template2 simply by typing in the specific url for template2. I see where CFABORT can limit access to a ip addresses as exampled in the manual Advanced Application Development, page 520; CFIF Left(CGI.RMOTE_ADDR, 11) NEQ 208.193.16. H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF Can I modify the code so that it can limit via the calling template? Thanks, Jerre ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfsilent - what's its function?
What exactly does CFSILENT do? They're a custom tag I'm using which I had to make a modification to - when I ran it locally, it worked fine, but uploading it to the live site revealed that my hosters don't have it installed. I removed cfsilent from the code, and tested it, and the code worked but only on a limited basis. Can anyone shed any light on what cfsilent does? Thanks Will -- Will Free Classifieds -=- www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfsilent - what's its function?
Stealing from the CFDocs: CFSILENT suppresses all output that is produced by the CFML within the tag's scope. CFSILENT CFSET a=100 CFSET b=99 CFSET c=b-a CFOUTPUT#c#/CFOUTPUT /CFSILENT === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 12:11 PM To: CF-Talk Subject: cfsilent - what's its function? What exactly does CFSILENT do? They're a custom tag I'm using which I had to make a modification to - when I ran it locally, it worked fine, but uploading it to the live site revealed that my hosters don't have it installed. I removed cfsilent from the code, and tested it, and the code worked but only on a limited basis. Can anyone shed any light on what cfsilent does? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfsilent - what's its function?
Is it the slide out menu one by any chance ? I had this error earlier. I just assumed it was the fact that I dont have cold Fusion 4.5. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 17:11 To: CF-Talk Subject: cfsilent - what's its function? What exactly does CFSILENT do? They're a custom tag I'm using which I had to make a modification to - when I ran it locally, it worked fine, but uploading it to the live site revealed that my hosters don't have it installed. I removed cfsilent from the code, and tested it, and the code worked but only on a limited basis. Can anyone shed any light on what cfsilent does? Thanks Will -- Will Free Classifieds -=- www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: deleting records in a dbase III table
I am using nt4 cf 4.01 Microsoft][ODBC dBase Driver] Could not delete from specified tables. Here is the error that is thrown. You can see my sql call in it as well. I am trying to delete all the records. I have made a workaround by creating a blank dbf and dbt and then deleting the files and copying the blanks as the originals to start over. But I really would like to be able to delete or know why I can't. I too have been working with dbf files for awhile. Terry SQL = delete from work Data Source = test.dbf SQL = delete from work The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:52). - Original Message - From: C Frederic Valone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 6:58 AM Subject: Re: deleting records in a dbase III table Are you getting an error? If so what is it please post the code and I'll take a look... I have worked a bit with dbf files and may be able to help. Also helpfull would be the os and cf version you are using. Thanks, Frederic Terry Troxel wrote: I am stumped as to why I cannot delete records from a dbase III dbf file that is defined as an odbc source using the MS dbase 3 ODBC driver. I can update, insert, but no delete. Any and all suggestions would be greatly appreciated. Terry The datasource is defined as test.dbf and pointing to the directory the dbf files are located. The table I am using is work.dbf. I am using delete from work ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to limit access to a specific template from only previous template?
You should be able to use the referrer, right? #cgi.http_referer# Something like this maybe: CFIF cgi.http_referer does not contain template1.cfm H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF And yes, the word referer is spelled wrong in the variable: cgi.http_referer -Craig [EMAIL PROTECTED] -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 10:59 AM To: CF-Talk Subject: Best way to limit access to a specific template from only previous template? What is the best way to limit access to a specific template? Template2 can only be accessed via template1. Disallowing user access to template2 simply by typing in the specific url for template2. I see where CFABORT can limit access to a ip addresses as exampled in the manual Advanced Application Development, page 520; CFIF Left(CGI.RMOTE_ADDR, 11) NEQ 208.193.16. H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF Can I modify the code so that it can limit via the calling template? Thanks, Jerre ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Two Questions for the price of one!
It really doesn't matter what I put for the requesttimeout. It breaks way before that. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 4:14 PM To: CF-Talk Subject: RE: Two Questions for the price of one! Query String: fuseaction=getmessagesrequesttimeout=300 Sounds to me like the process it timing out before it has a chance to download all the mail. You would think that 5 minutes would be enough time though to pull 1600 message though...unless we are not talking about standard text only messages. If you have a rather big attachment in the mail that could put it over the 5 minute time limit. Just taking a guess here. Dan Phillips -Original Message- From: Craig Bowes [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 4:54 PM To: CF-Talk Subject: Two Questions for the price of one! I have two related questions: I am trying to pull in emails from a pop server using cfpop and database them. However, the account I need to pull from has some 1600 emails in it. cfpop doesn't seem to want to cooperate. It gives me the following error: Error Occurred While Processing Request Error Diagnostic Information unknown exception condition unknown error while executing a tag. Date/Time: 05/17/01 15:13:45 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) Remote Address: 66.80.49.128 HTTP Referer: http://www.hospitalityadventures.com/admin/index.cfm?fuseaction=menu Query String: fuseaction=getmessagesrequesttimeout=300 Please inform the site administrator mailto:[EMAIL PROTECTED] that this error has occurred (be sure to include the contents of this page in your message to the administrator). Just a little cryptic, eh? My code seems to work fine if I check my own email account which is why I suspect it is the amount of messages it is trying to pull. I put maxes for the queries but I'm not certain that helps the cfpop tag in the retrieval process. Here's my code: CFPOP action=GETALL name=Messages attachmentpath=#request.attachpath# maxrows=50 generateuniquefilenames=Yes server=#request.messageserver# username=#request.messageusername# password=#request.messagepassword# 1) What am I doing wrong here? I even tried some of the custom POP tags out there and they failed also. 2) Someone mentioned pulling the cftalk mailing list messages from outlook into a database through VB or VBA. Does anyone know of this and would it be a viable solution? Thanks, -Craig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfsilent - what's its function?
Thanks - sorry I didn't look there first. Is there any reason why my hosters would disable this tag? It's on a NT 4 box. Will - Original Message - From: Raymond Camden [EMAIL PROTECTED] Newsgroups: gradwell.lists.cftalk Sent: Friday, May 18, 2001 5:21 PM Subject: RE: cfsilent - what's its function? Stealing from the CFDocs: CFSILENT suppresses all output that is produced by the CFML within the tag's scope. CFSILENT CFSET a=100 CFSET b=99 CFSET c=b-a CFOUTPUT#c#/CFOUTPUT /CFSILENT === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 12:11 PM To: CF-Talk Subject: cfsilent - what's its function? What exactly does CFSILENT do? They're a custom tag I'm using which I had to make a modification to - when I ran it locally, it worked fine, but uploading it to the live site revealed that my hosters don't have it installed. I removed cfsilent from the code, and tested it, and the code worked but only on a limited basis. Can anyone shed any light on what cfsilent does? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problems with inserting a date fields (Using Native Driver, AS/400)
Can anybody tell me why I am getting this error? Thanks, James cffile action=UPLOAD filefield=documents destination=/inq2/netscape/suitespot/intranet-docs/dllr/secured-docs/lsar/pdf nameconflict=OVERWRITE cfif #date_closed# IS NOT cfset str_date_closed = #date_closed# cfelse cfset str_date_closed = NULL /cfif cfquery name=NewCase datasource=lsar_prod insert into lsar.submissions (lid, assignedto, constituent, doc_date, dead_date, subtype, subject, subjdetail, received, tone, enteredby, date_assigned, date_closed, addressedto, documents, draft, assignedby, completed) values ('#form.lid#', '#form.assignedto#', '#form.constituent#', '#CreateODBCDate(form.doc_date)#', '#CreateODBCDate(form.dead_date)#', '#form.subtype#', '#form.subject#', '#form.subjdetail#', '#form.received#', '#form.tone#', 'Sandy Crisafulli', '#CreateODBCDate(form.date_assigned)#', #str_date_closed#, '#form.addressedto#', '#File.ServerFile#', '#form.draft#', 'Sandy Crisafulli', 'Incomplete') /cfquery IBM][CLI Driver][AS] SQL0104N An unexpected token 2001 was found following . Expected tokens may include: ) ,. SQLSTATE=42601 SQL = insert into lsar.submissions (lid, assignedto, constituent, doc_date, dead_date, subtype, subject, subjdetail, received, tone, enteredby, date_assigned, date_closed, addressedto, documents, draft, assignedby, completed) values ('10006', 'Barry Rubin', '', '{d '2001-05-11'}', '{d '2001-05-09'}', '', '', '', '', '', 'Sandy Crisafulli', '{d '2001-05-03'}', NULL, '', '10006.pdf', '', 'Sandy Crisafulli', 'Incomplete') ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Download Software From The CF Server
Thank you all for your help. It worked. Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:Re: Download Software From The CF Server Author: [EMAIL PROTECTED] Date: 5/17/01 2:41 PM I used the CFCONTENT tag to download the zipped software package. Internet Explorer understands that it is a zip file but Netscape downloads it as a html file. The code follows: cfcontent type=application/x-zip file=c:\inetpub\webpub\sshtest\ssh.zip deletefile=No The following code solved this problem: cfcontent type=application/x-compress file=c:\inetpub\webpub\sshtest\ssh.zip deletefile=No Now the downloading is processed successfully by Internet Explorer and Netscape. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report Solution (long)--My shared experience
I don't understand your point here. Could you explain in more detail, pleas? best, paul At 01:27 PM 5/18/01 +, you wrote: hmmm. Good question. Yes, I suppose they could do that. Depending on how you set up your Crystal Report, however, you probably could make it more difficult for them to 'guess' what fields the report is expecting. For example, this is what my final CF page has in the source code: FORM NAME=continue ACTION=http://our.report.server.com/callreport.asp; METHOD=POST onSubmit=return _CF_checkcontinue(this) input type=hidden name=reportname value=whatever.rpt input type=hidden name=DSN value=yourDSN input type=hidden name=DB_SID value=yourdbschema input type=hidden name=param1 value=firstReportPrompt input type=hidden name=param2 value=1001 input type=hidden name=param3 value=0902 input type=hidden name=param4 value=1 input type=hidden name=param5 value=1 input type=hidden name=param6 value=1 input type=hidden name=param7 value= input type=hidden name=param8 value= input type=hidden name=param9 value=ALL input type=hidden name=param10 value=ALL Since the prompt values are being passed from a template, the report will not prompt the user for any of the needed values when the report displays in the browser. So, even though they may see in the source code that param2 is 1001, they may not figure out that the report is requesting (in MMYY format), the start of the fiscal year for the year that the user chose from the form dropdown list (in this case, 2001). Likewise, there is logic in my CF page to determine the end of the fiscal year, based on their choice (2001) from the previous page. See what I mean? Likewise, for param9/10, they would have no idea what ALL indicates, nor would they be able to guess what the other possible values would be. In our case, however, we are granting access to any employee to run any report (hey, I don't call the shots--that's how the group asked me to build it :), so we aren't too concerned with people taking the time to do something like that. The only reason that we are asking for an NT id and password is just so that we can validate that it is, in fact, a valid employee logging on. We may change this somewhere down the line and actually restrict access to certain reports, I don't know. Our whole concern with not exposing the db id/pw was because we didn't want people to be able to bypass reports and gain access to the actual Oracle db. If we DO end up restricting access based on groups somewhere down the road, I will be sure to post an update! :) Good luck! Original Message Follows From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Report Solution (long)--My shared experience Date: Fri, 18 May 2001 09:01:21 -0400 I haven't done anything like this but may have to soon. Question: is there anything stopping a user from creating an html page on their desktop with a form that posts to the report server ASP page, just like your action page does? If not, it appears that anyone could run any report if they can figure out what to put in the form fields. Or is there a step I missed? -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:49 AM To: CF-Talk Subject: Report Solution (long)--My shared experience Okay, all. I just spent 4 days tearing my hair out trying to figure out how to pass CF variables to a Crystal Report(8) (while hiding the db userid and password). I searched the archives and the Allaire site and noticed that many other people have been gnashing their teeth over the same topic, so I thought I would share our solution. It's not pretty, and I'm not looking forward to supporting it, but it will .. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to limit access to a specific template from only p revious template?
Be care using CGI variables. This method is extremely easy to hack. Albert. -Mensaje original- De: Adkins, Randy [mailto:[EMAIL PROTECTED]] Enviado el: viernes, 18 de mayo de 2001 18:09 Para: CF-Talk Asunto: RE: Best way to limit access to a specific template from only p revious template? CFIF #CGI.HTTP_REFERER# IS template.cfm *** AUTHORIZED CFELSE *** NOT AUTHORIZED /CFIF -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 11:59 AM To: CF-Talk Subject: Best way to limit access to a specific template from only previous template? What is the best way to limit access to a specific template? Template2 can only be accessed via template1. Disallowing user access to template2 simply by typing in the specific url for template2. I see where CFABORT can limit access to a ip addresses as exampled in the manual Advanced Application Development, page 520; CFIF Left(CGI.RMOTE_ADDR, 11) NEQ 208.193.16. H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF Can I modify the code so that it can limit via the calling template? Thanks, Jerre ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problems with inserting a date fields (Using Native Driver, AS/400)
My guess is either date_closed can not be null in the DB or NULL is not the correct way to insert a null value into your particular DB. Try running the insert sql statement thru a DB tool ... Query Analyzer for MS-SQL ... and resolve the problem there. Then move back to CF. Good luck, Bill In a message dated Fri, 18 May 2001 1:01:17 PM Eastern Daylight Time, James Taavon [EMAIL PROTECTED] writes: Can anybody tell me why I am getting this error? Thanks, James cffile action=UPLOAD filefield=documents destination=/inq2/netscape/suitespot/intranet-docs/dllr/secured-docs/lsar/pdf nameconflict=OVERWRITE cfif #date_closed# IS NOT cfset str_date_closed = #date_closed# cfelse cfset str_date_closed = NULL /cfif cfquery name=NewCase datasource=lsar_prod insert into lsar.submissions (lid, assignedto, constituent, doc_date, dead_date, subtype, subject, subjdetail, received, tone, enteredby, date_assigned, date_closed, addressedto, documents, draft, assignedby, completed) values ('#form.lid#', '#form.assignedto#', '#form.constituent#', '#CreateODBCDate(form.doc_date)#', '#CreateODBCDate(form.dead_date)#', '#form.subtype#', '#form.subject#', '#form.subjdetail#', '#form.received#', '#form.tone#', 'Sandy Crisafulli', '#CreateODBCDate(form.date_assigned)#', #str_date_closed#, '#form.addressedto#', '#File.ServerFile#', '#form.draft#', 'Sandy Crisafulli', 'Incomplete') /cfquery IBM][CLI Driver][AS] SQL0104N An unexpected token 2001 was found following . Expected tokens may include: ) ,. SQLSTATE=42601 SQL = insert into lsar.submissions (lid, assignedto, constituent, doc_date, dead_date, subtype, subject, subjdetail, received, tone, enteredby, date_assigned, date_closed, addressedto, documents, draft, assignedby, completed) values ('10006', 'Barry Rubin', '', '{d '2001-05-11'}', '{d '2001-05-09'}', '', '', '', '', '', 'Sandy Crisafulli', '{d '2001-05-03'}', NULL, '', '10006.pdf', '', 'Sandy Crisafulli', 'Incomplete') ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to limit access to a specific template from only p revious template?
Be care using CGI variables. This method is extremely easy to hack. Albert. -Mensaje original- De: Craig Bowes [mailto:[EMAIL PROTECTED]] Enviado el: viernes, 18 de mayo de 2001 18:24 Para: CF-Talk Asunto: RE: Best way to limit access to a specific template from only previous template? You should be able to use the referrer, right? #cgi.http_referer# Something like this maybe: CFIF cgi.http_referer does not contain template1.cfm H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF And yes, the word referer is spelled wrong in the variable: cgi.http_referer -Craig [EMAIL PROTECTED] -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 10:59 AM To: CF-Talk Subject: Best way to limit access to a specific template from only previous template? What is the best way to limit access to a specific template? Template2 can only be accessed via template1. Disallowing user access to template2 simply by typing in the specific url for template2. I see where CFABORT can limit access to a ip addresses as exampled in the manual Advanced Application Development, page 520; CFIF Left(CGI.RMOTE_ADDR, 11) NEQ 208.193.16. H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF Can I modify the code so that it can limit via the calling template? Thanks, Jerre ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best way to limit access to a specific template from only p revious template?
Why not store some sort of authorization code as session variable? Chris [EMAIL PROTECTED] - Original Message - From: Albert Feliu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 6:21 PM Subject: RE: Best way to limit access to a specific template from only p revious template? Be care using CGI variables. This method is extremely easy to hack. Albert. -Mensaje original- De: Craig Bowes [mailto:[EMAIL PROTECTED]] Enviado el: viernes, 18 de mayo de 2001 18:24 Para: CF-Talk Asunto: RE: Best way to limit access to a specific template from only previous template? You should be able to use the referrer, right? #cgi.http_referer# Something like this maybe: CFIF cgi.http_referer does not contain template1.cfm H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF And yes, the word referer is spelled wrong in the variable: cgi.http_referer -Craig [EMAIL PROTECTED] -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 10:59 AM To: CF-Talk Subject: Best way to limit access to a specific template from only previous template? What is the best way to limit access to a specific template? Template2 can only be accessed via template1. Disallowing user access to template2 simply by typing in the specific url for template2. I see where CFABORT can limit access to a ip addresses as exampled in the manual Advanced Application Development, page 520; CFIF Left(CGI.RMOTE_ADDR, 11) NEQ 208.193.16. H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF Can I modify the code so that it can limit via the calling template? Thanks, Jerre ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfsilent - what's its function?
I don't think you can disable it. It's not on the list of tags that can be turned off. Are you use the server is 4.5? I don't remember your original email, but I believe you said that your code was failing because of the presence of this tag. Are you sure then that the server you are using is 4.5? Maybe its 4.01 instead? === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 12:25 PM To: CF-Talk Subject: Re: cfsilent - what's its function? Thanks - sorry I didn't look there first. Is there any reason why my hosters would disable this tag? It's on a NT 4 box. Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report Solution (long)--My shared experience
Sure. If you have a Crystal Report that is accessed directly through a URL, and not by passing parameters via a web page, and that Crystal Report expects certain input from a user, Crystal Reports will display a series of javascript-like prompts for the user to fill in. So, for example, one of the reports we have might have a series of prompts starting with group name to report on, start month for the fiscal year, end month for the fiscal year, etc. One all of the parameters have been supplied, the report will run. Since we are accessing the Crystal Report via a web page, those parameters are passed automatically from the page to the Crystal Report, so the user is never prompted for them (they would instead be asked for the information from the web page itself). In my situation, my web form only asks for 4 pieces of information: the group to report on, the fiscal year to report on, and the user's NT id and password. In the source code, all of the paramters (ten, in my case) are listed as param1, param2, param3, etc. It just so happens that for param1, I assign the value of #form.group#, because the Crystal report is expecting the group name to be supplied first. Param2 and Param3 are the start month and end month for the fiscal year that the user chose from a dropdown list labled fiscal year. We'll assume they chose 2001 in this case. In my action page, I use CF functions to take the year 2001 and determine the start and end of that fiscal year (1001 and 0902, in MMYY format). So in the source code you see param2=1001 and param3=0902. The user may be able to look at the source code and see what these values are, but they don't know what I've done to arrive at those numbers or what they stand for. In addition, I have several other hidden fields in that CF template that were not provided by the user's input. So if they looked at the source code, they don't know what param4=1 means, or how it changes the report. Now, I am not suggesting in any way that the users would not be able to figure this out, or that they would not be able to just copy and paste the hidden fields as is to generate a report. Sure they could. But, in my case, if they have made it this far to where they are able to view the source code for this page, then they have been granted access to this report anyway. It's important to note that I am dealing strictly with an inTRAnet here, so I'm not as concerned about security hacks. Our biggest concern was hiding the db username and password. I'm pretty sparse on my knowledge of Crystal Reports, but I wonder if you could also specify in the Crystal Report a specific user name and password? I dunno. I'm not sure of the capabilities of Crystal Reports. HTH :) Terri Original Message Follows From: Paul Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Report Solution (long)--My shared experience Date: Fri, 18 May 2001 10:06:51 -0700 I don't understand your point here. Could you explain in more detail, pleas? best, paul At 01:27 PM 5/18/01 +, you wrote: hmmm. Good question. Yes, I suppose they could do that. Depending on how you set up your Crystal Report, however, you probably could make it more difficult for them to 'guess' what fields the report is expecting. For example, this is what my final CF page has in the source code: FORM NAME=continue ACTION=http://our.report.server.com/callreport.asp; METHOD=POST onSubmit=return _CF_checkcontinue(this) input type=hidden name=reportname value=whatever.rpt input type=hidden name=DSN value=yourDSN input type=hidden name=DB_SID value=yourdbschema input type=hidden name=param1 value=firstReportPrompt input type=hidden name=param2 value=1001 input type=hidden name=param3 value=0902 input type=hidden name=param4 value=1 input type=hidden name=param5 value=1 input type=hidden name=param6 value=1 input type=hidden name=param7 value= input type=hidden name=param8 value= input type=hidden name=param9 value=ALL input type=hidden name=param10 value=ALL Since the prompt values are being passed from a template, the report will not prompt the user for any of the needed values when the report displays in the browser. So, even though they may see in the source code that param2 is 1001, they may not figure out that the report is requesting (in MMYY format), the start of the fiscal year for the year that the user chose from the form dropdown list (in this case, 2001). Likewise, there is logic in my CF page to determine the end of the fiscal year, based on their choice (2001) from the previous page. See what I mean? Likewise, for param9/10, they would have no idea what ALL indicates, nor would they be able to guess what the other possible values would be. In our case, however, we are granting access to any employee to run any report (hey, I don't call the shots--that's how the group asked me to
Help with CFDEV
Ok, I need help can some one please help me. I don't know what I am doing wrong. I have included the error and my code on both pages. I keep getting this error: Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (6:1) to (6:84). Date/Time: 05/17/01 12:21:22 CODE: PAGE 1 !DOCTYPE html public -//W3C//DTD HTML 4.0 Transitional//EN HTML HEAD TITLEUntitled/TITLE CFQUERY name=define datasource=#application.db# select * from pages where id = 3 /CFQUERY /HEAD BODY CFOUTPUT TABLE width=600 TR TD FORM action=edit2.cfm method=post !---CF_ACTIVEDIT ds= fieldname= table=pages inc= type=edit primarykey=id primarykeyvalue= cutcopypaste=yes upload=yes redoundo=yes#define.htmlcode# --- cf_activedit inc=activedit/inc/ type=edit ds=alliance table=pages image=no#define.htmlcode# /CF_ACTIVEDIT input type=hidden name=id value=3 CENTERBR INPUT type=submit value=SAVE/CENTER /TD /TR /TABLE /FORM /CFOUTPUT /BODY /HTML CODE: PAGE 2 !DOCTYPE html public -//W3C//DTD HTML 4.0 Transitional//EN HTML HEAD TITLEUntitled/TITLECFSET form.htmlcode = #ATTRIBUTES.FIELDNAME# cfupdate datasource=#application.db# tablename=pages formfields=htmlcode, id CFOUTPUT /HEAD BODY BRBRFONT face=arial Finished/FONT /CFOUTPUT /BODY /HTML ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with CFDEV
Looks like CFUPDATE is failing because your trying to update a record that doesn't exist. I see in your code that you hard coded the ID to 3. Does that record exist? === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: CF Crazy [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 1:46 PM To: CF-Talk Subject: Help with CFDEV Ok, I need help can some one please help me. I don't know what I am doing wrong. I have included the error and my code on both pages. I keep getting this error: Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (6:1) to (6:84). Date/Time: 05/17/01 12:21:22 CODE: PAGE 1 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Deep Into Oracle 8.0.5
I am deeper into Oracle 8.0.5 than I wish to be...but I know someone here can help me. Currently, I have an application that connects to Oracle using Native Drivers. Recently, I have noticed that when I view Oracle Sessions (using Oracle Tools, Instance Manager), when I close my browser session, the Oracle connection that was opened by ColdFusion remains INACTIVE for an hour or more. Does anyone know how to kill the Oracle SessionID that is created when a user logs out of a ColdFusion application? I am using Coldfusion 4.5 SP2, Windows 2K SP1, with Oracle 8.0.5 on a different box. Hopefully, those of you who can help me understand my question. I don't know how else to word it. Thanks In Advance, Debbie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Another Question About Database Connections Using Oracle
Here I go again... Where can I find specific information on how CF connects to an Oracle DB using Native Drivers? In the CF Administrator, under data sources, Native Drivers, what happens when I select the option Maintain Database Connections. Does this mean that only one connection per client is made when accessing an application? If I deselect this box, will multiple sessions be opened each time a query is executed on a page during a user's session? Obviously, I'm lost. But I know among this group there has got to be an Oracle guru. Thanks Again, Debbie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Syntax Output??
How can I display a tag syntax within a .cfm page without executing the tag? Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax Output??
You mean you want to display CF... on screen? Same way you would do HTML. Either manually change to lt; and to gt;, or, if it's a file, use CFFILE to read it and do the change w/ regex. Also, I _think_ someone wrote a CFX to do exactly this, plus some other formatting things. I want to say it's one of the big CF sites but I can't remember which. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Alii Design [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 2:11 PM To: CF-Talk Subject: Syntax Output?? How can I display a tag syntax within a .cfm page without executing the tag? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Integration with LiveLink?
Anyone out there doing any sort of integration with the LiveLink document management product from OpenText? tia, Reed Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problems with inserting a date fields (Using Native Driver, AS/400)
Actually, the NULL value is ok. The insertion works correctly on my local machine, but I am using ODBC with Client Access to connect to AS/400 where I am using a Native Driver connection using DB2 Connect on the production side since CF is running on Solaris on Production and Windows on my local machine. [EMAIL PROTECTED] wrote: My guess is either date_closed can not be null in the DB or NULL is not the correct way to insert a null value into your particular DB. Try running the insert sql statement thru a DB tool ... Query Analyzer for MS-SQL ... and resolve the problem there. Then move back to CF. Good luck, Bill In a message dated Fri, 18 May 2001 1:01:17 PM Eastern Daylight Time, James Taavon [EMAIL PROTECTED] writes: Can anybody tell me why I am getting this error? Thanks, James cffile action=UPLOAD filefield=documents destination=/inq2/netscape/suitespot/intranet-docs/dllr/secured-docs/lsar/pdf nameconflict=OVERWRITE cfif #date_closed# IS NOT cfset str_date_closed = #date_closed# cfelse cfset str_date_closed = NULL /cfif cfquery name=NewCase datasource=lsar_prod insert into lsar.submissions (lid, assignedto, constituent, doc_date, dead_date, subtype, subject, subjdetail, received, tone, enteredby, date_assigned, date_closed, addressedto, documents, draft, assignedby, completed) values ('#form.lid#', '#form.assignedto#', '#form.constituent#', '#CreateODBCDate(form.doc_date)#', '#CreateODBCDate(form.dead_date)#', '#form.subtype#', '#form.subject#', '#form.subjdetail#', '#form.received#', '#form.tone#', 'Sandy Crisafulli', '#CreateODBCDate(form.date_assigned)#', #str_date_closed#, '#form.addressedto#', '#File.ServerFile#', '#form.draft#', 'Sandy Crisafulli', 'Incomplete') /cfquery IBM][CLI Driver][AS] SQL0104N An unexpected token 2001 was found following . Expected tokens may include: ) ,. SQLSTATE=42601 SQL = insert into lsar.submissions (lid, assignedto, constituent, doc_date, dead_date, subtype, subject, subjdetail, received, tone, enteredby, date_assigned, date_closed, addressedto, documents, draft, assignedby, completed) values ('10006', 'Barry Rubin', '', '{d '2001-05-11'}', '{d '2001-05-09'}', '', '', '', '', '', 'Sandy Crisafulli', '{d '2001-05-03'}', NULL, '', '10006.pdf', '', 'Sandy Crisafulli', 'Incomplete') ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: deleting records in a dbase III table
just grasping at staws here because it has been a long long time. Do you really want to delete all records? I think you would use: DELETE * from work (note *) - Original Message - From: Terry Troxel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 8:16 AM Subject: Re: deleting records in a dbase III table Here is what is returned: Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC dBase Driver] Could not delete from specified tables. SQL = delete from work Data Source = test.dbf SQL = delete from work The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:52). - Original Message - From: Adkins, Randy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 6:38 AM Subject: RE: deleting records in a dbase III table Is there an error returned? If memory serves me right, DBaseIII also uses a command called: PACK Not sure it is needed in this case however. -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 9:18 AM To: CF-Talk Subject: deleting records in a dbase III table I am stumped as to why I cannot delete records from a dbase III dbf file that is defined as an odbc source using the MS dbase 3 ODBC driver. I can update, insert, but no delete. Any and all suggestions would be greatly appreciated. Terry The datasource is defined as test.dbf and pointing to the directory the dbf files are located. The table I am using is work.dbf. I am using delete from work ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: EnableCFoutputOnly not cutting the mustard in Custom Tag
I didn't want to use a trimmed caller variable, as doing so is three times more complicated than just getting the results via the custom tag itself. Fine for me, but I intend this to be used by others in my company, and the simpler the usage the better. So, I can use: cf_MyCustomTag Instead of : cf_MyCustomTag cfoutput#trim(myCallerVariable)#/cfoutput See the value in this? No. If you don't want white space around the returned string then there's no reason it should be returned by the custom tag! Trim it within the tag. Also, for maximum flexibility (and safety) you should pass in the name of the caller variable, rather than using a predetermined name. cf_MyCustomTag inputstuff=48 variable=myVariable cfoutput#myVariable#/cfoutput Your custom tag then does something like: cfparam name=variable !--- processing to arrive at a value within the internal variable called 'returnvalue' ... --- cfset temp = SetVariable(caller.#attributes.variable#, Trim(returnvalue)) Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Displaying recordsets?
Hi all! I am trying to figure out how to display my recordsets in groups of 5... you see this on search engines, etc... where you can display the first 5 or 10, then hit the next button for the next set, etc... The examples in my books show how to limit a recordset, but not how to display a set, with the next (and subsequent) sets on another page. Can anyone help??? Thanks in advance! A.Cregar Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax Output??
Sometimes I just try to make a problem more complex than it should be. lt; and gt; were just to simple of an answer and work just fine. Thanks for your help, Rich -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 2:08 PM To: CF-Talk Subject: RE: Syntax Output?? You mean you want to display CF... on screen? Same way you would do HTML. Either manually change to lt; and to gt;, or, if it's a file, use CFFILE to read it and do the change w/ regex. Also, I _think_ someone wrote a CFX to do exactly this, plus some other formatting things. I want to say it's one of the big CF sites but I can't remember which. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Alii Design [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 2:11 PM To: CF-Talk Subject: Syntax Output?? How can I display a tag syntax within a .cfm page without executing the tag? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with ActiveEdit - OPPS
Hi, You are using Activedit with type=edit which is now deprecated, and not the recommended way to do it. It looks like you are probably using version 2.0 (am I right?) In 2.0 you can use type=form which will allow you to use activedit like a textarea... cf_activedit fieldname=htmlcode inc=activedit/inc image=false #define.htmlcode# /cf_activedit ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying recordsets?
I currently use the following code in a few different places in my application. It works fast and goodI am posting it because many people helped me getting started using CF and I hope to continue the traditionIf you come up with something better that is awesome, just post it for others to use...Stango !--- This code assumes that you are displaying the records in groups of five--- cfquery name=the_query_you_are_using datasource=your_datasource Query meat goes here /cfquery cfif isDefined('get_previous') cfset number = get_previous - 8 cfset end = get_previous - 4 cfif number lte 0 cfset number = 1 /cfif cfelse cfif number is 1 cfset end = number + 4 cfelse cfset end = number + 4 /cfif /cfif cfloop query=the_query_you_are_using startrow=#number# endrow=#end# Display meat goes here /cfloop cfif the_query_you_are_using.recordcount gte 5 cfif end gt 5 input type=button Value=Previous onClick=document.location='ProgressNotes_Sel.cfm?get_previous= cfoutput#Evaluate(end-1)#/cfoutputplusotherformvariables' /cfif /cfif cfif end lt the_query_you_are_using.recordcount input type=button Value=Next onClick=document.location='ProgressNotes_Sel.cfm?number=cfoutput#Evaluate (end+1)#/cfoutputplusotherformvariables' /cfif !--- YOU CAN USE THIS LAST PART TO SHOW THE USER EXACTLY WHAT RECORD THEY ARE CURRENTLY LOOKING ON--- cfif end gt get_services.recordcount cfset last = get_services.recordcount cfelse cfset last = end /cfif cfoutput#get_services.recordcount# recordcfif get_services.recordcount neq 1s/cfif returnedshowing recordcfif number neq get_services.recordcounts #number# through/cfif #last#/cfoutput ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying recordsets?
Sure... Use the maxrow and startrow attributes of cfoutput... cfoutput maxrows=5 startrow=#url.lastrecord#/cfoutput Where url.lastrecord would be where you need to start (for page 3 it would be 15) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: IIS4 Log file
I have two servers. One server logs browser, and computer information like this: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) This computer has CF 4.5, and Webtrends loaded on it. The other server (IIS4 also, but without CF4.5, and Webtrends) does not log this information. Anyone know why? TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS4 Log file
Check your logging properties in IIS. Open IIS, right click on the master site, properties, Edit WWW Service. The Web Site tab should now be displayed, At the bottom click Properties near where it says Enable Logging. Click the Extended Properties tab. Now just make sure all the attributes you want logged are checked. Win2k does this too for some reason on a default install. Hope that fixes it! ;-) Dan Phillips cfxhosting.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 3:12 PM To: CF-Talk Subject: OT: IIS4 Log file I have two servers. One server logs browser, and computer information like this: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) This computer has CF 4.5, and Webtrends loaded on it. The other server (IIS4 also, but without CF4.5, and Webtrends) does not log this information. Anyone know why? TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS4 Log file
did you select these items in the Logging configuration on both machines? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 3:12 PM To: CF-Talk Subject: OT: IIS4 Log file I have two servers. One server logs browser, and computer information like this: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) This computer has CF 4.5, and Webtrends loaded on it. The other server (IIS4 also, but without CF4.5, and Webtrends) does not log this information. Anyone know why? TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do I create Boolean field with create table in access?
How do I create Boolean field with create table in access? what other field types are available? Thanks mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS4 Log file
The only log format that has the Extended Properties tab is the W3C Extended log format and if memory serves this format is not comma delimited. Both computers are setup to use the IIS Log Format and that format does not have an extended properties tab. So it is kind of strange that they dont log the same. At 03:22 PM 5/18/2001 -0400, you wrote: Check your logging properties in IIS. Open IIS, right click on the master site, properties, Edit WWW Service. The Web Site tab should now be displayed, At the bottom click Properties near where it says Enable Logging. Click the Extended Properties tab. Now just make sure all the attributes you want logged are checked. Win2k does this too for some reason on a default install. Hope that fixes it! ;-) Dan Phillips cfxhosting.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 3:12 PM To: CF-Talk Subject: OT: IIS4 Log file I have two servers. One server logs browser, and computer information like this: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) This computer has CF 4.5, and Webtrends loaded on it. The other server (IIS4 also, but without CF4.5, and Webtrends) does not log this information. Anyone know why? TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Deep Into Oracle 8.0.5
In CF Admin for a particular datasource there is a setting maintain database connections and another setting Connection timeout. If you check maintain database connections, then CF will keep a connection to the database open for as long as connection timeout after its last use. So if you have page1.cfm and page2.cfm, both accessing the datasource MyOracle, and a user runs page1 and a few minutes later runs page2, the CF server will reuse the connection it made to run queries for page1 in order to run queries for page2. If connection timeout minutes pass with no use of a given connection the CF server will close that connection. Make sense? -Original Message- From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 1:52 PM To: CF-Talk Subject: Deep Into Oracle 8.0.5 I am deeper into Oracle 8.0.5 than I wish to be...but I know someone here can help me. Currently, I have an application that connects to Oracle using Native Drivers. Recently, I have noticed that when I view Oracle Sessions (using Oracle Tools, Instance Manager), when I close my browser session, the Oracle connection that was opened by ColdFusion remains INACTIVE for an hour or more. Does anyone know how to kill the Oracle SessionID that is created when a user logs out of a ColdFusion application? I am using Coldfusion 4.5 SP2, Windows 2K SP1, with Oracle 8.0.5 on a different box. Hopefully, those of you who can help me understand my question. I don't know how else to word it. Thanks In Advance, Debbie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS4 Log file
Change your Active log format to W3C Extended Log File Format Then make sure your WebTrends is pointing to ex* and not in*.. - Original Message - From: Christopher Olive, CIO [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 2:29 PM Subject: RE: IIS4 Log file did you select these items in the Logging configuration on both machines? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 3:12 PM To: CF-Talk Subject: OT: IIS4 Log file I have two servers. One server logs browser, and computer information like this: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) This computer has CF 4.5, and Webtrends loaded on it. The other server (IIS4 also, but without CF4.5, and Webtrends) does not log this information. Anyone know why? TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I create Boolean field with create table in access?
Access has a yes/no type that you can use as a Boolean-esque field. Checking for Yes/No and I think you can check for existence as the yes as well. Not sure on the last part. Hope that helps. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Losing - If at first you don't succeed, failure may be your style. ~despair.com -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 12:49 PM To: CF-Talk Subject: How do I create Boolean field with create table in access? How do I create Boolean field with create table in access? what other field types are available? Thanks mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
rebuilding mod_coldfusion
I probably have a very simple question but I have not been able to find the answer anywhere. I want to rebuild the mod_coldfusion.so file but it keeps returning an error as follows: apxs:Break: Command failed with rc=255 Does anybody know what the problem is? Jeff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do I create Boolean field with create table in access?
It's called a Yes/No field in Access. Access will take either 1/0 or True/False values. Use 1/0 to maintain compatibility with MS SQL Server. Internally, I think it's stored at 0 and -1, go figure. How do I create Boolean field with create table in access? what other field types are available? Thanks mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I create Boolean field with create table in access?
The Yes/No data type is Boolean. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists