Re: VTM Files
There is an online wizard that will create the vtm file and the default template for your custom tag and then email you the resulting files. http://www.netwebapps.com/mytags/main.cfm You can play around with it and get a feel for how vtm files are written. The final page will allow you to pick a type of control for each of your entries as well as adding in the standard event and style sheet tabs that are used with the tag editors that come with studio/homesite. Bryan LaPlante - Original Message - From: Steve Reich [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 7:26 PM Subject: VTM Files Does anyone know of any online resources for writing .vtm files? Specifically, I'm looking for a way to have a color picker popup for the user to select a color. Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Breaking up cfoutput
Sound like you are looking for the group attribute of the cfoutput tag. Here is a snippet from the help file. GROUP Optional. Specifies the query column to use when you group sets of records together. Use this attribute if you have retrieved a record set ordered on a certain query column. For example, if you have a record set that is ordered according to Customer_ID in the CFQUERY tag, you can group the output on Customer_ID. The GROUP attribute, which is case sensitive, eliminates adjacent duplicates in the case where the data is sorted by the specified field. See the GROUPCASESENSITIVE attribute for information about specifying a case insensitive grouping. - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 6:21 AM Subject: Breaking up cfoutput Hi, I need to break up a Cfoutput query=... somehow - I have no idea whether or not this is possible. Here's the query: cfquery name=fad datasource=#db1# SELECT * FROM advert_details WHERE town = '#url.thetown#' OR (natpaid = Yes AND nationwide = Yes) ORDER by town, start_date, nationwide /cfquery Now, say 10 records are found whose .natpaid and .nationwide both equal No. And 4 are found whose natpaid and nationwide equal Yes, making 14 results. When outputting the results, I ideally want to alternate and have one result shown where natpaid AND nationwide = No, and then one where natpaid AND nationwide = Yes...and so on. I've seen this work before, I think, where sites include commercial advertising mid-output on a search query. Fantasy or a possibility? Cheers Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JS tag keyboard shortcut
are you talking about code templates. Press F8 and expand the editor section to see the code templates section and you will see at the bottom of the dialog where it says [ctrl + j] is the keyboard short-cut that invokes the code template. Bryan LaPlante - Original Message - From: Tristram Charnley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 3:58 AM Subject: JS tag keyboard shortcut I've forgotten the keyboard shortcut in Studio for inserting a Javascript opening/closing tag. Can anyone remind me? Tristram Charnley ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SELECT
I imagine you are pulling your list from a database and using the query of a cfoutput, just add this code to it. select cfoutput query=mybooknames cfif name is form.namecfset selected = selectedcfelsecfset selected = /cfif option value=#name# #selected##name#/option /cfoutput /select there is a way to do it in one line with iif() but I can't remember that one right off. Bryan - Original Message - From: Tony Hicks [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, September 30, 2001 5:00 AM Subject: SELECT Hey Guys... I have a problem, my site, www.bibleclicks.com has one request from people that send me feedback.. they want me to set it so that when a user selects a book and searches, the book remains selected on the next page.. the problem comes in here: It would take about 75 cfif tags to do it and some of them would be long.. my host is generous with bandwidth but.. I'm smart, I don't want to push the limits.. is there an easy way to do this? Thanks, Tony Hicks ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF path question...
getDirectoryFromPath(script_name) should give you what you want. Bryan LaPlante - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, September 16, 2001 3:37 PM Subject: CF path question... I have one of these unique issues that presents itself... Eseentially to solve such I need to rip out the current server_name and another value which is the directory location where the ccurent files is located on the CF server... I know of Script_name - howeve it includes the file as well ... could parse it, however. Also aware of PATH_INFO but it has the same problem... Is there another CGI or CF feature that will just give me the path minus the filename? I am certain many people have had to work around this if not... How have you gone about such? -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Prepared statements
I have two questions. When you set up a dsn in the CF there is a check box that says Create stored procedures for prepared statements. Do I need to check that box to get cfquery's to work that include cfqueryparam's? Second question, if it does create a stored proc for my query would I just continue to run the query with the cfqueryparam or would I need to run it as a stored procedure? Bryan LaPlante President Network Web Applications Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Looping through a CFfile upload
cfloop index=file list=#form.fieldnames# delimiters=, cfif file is not submit cffile action=UPLOAD filefield=#file# destination=c:\destination\ nameconflict=MAKEUNIQUE /cfif /cfloop - Original Message - From: Brent Goldman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 4:58 PM Subject: RE: Looping through a CFfile upload Hi, If you upload multiple files, you have to use multiple FILE form fields. If you have multiple form fields, then you just need to access them how you would access any form field. -Brent -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 5:45 AM To: CF-Talk Subject: Looping through a CFfile upload Has anyone had call to allow multiple file uploads from a single form submit and if so how did you approach it? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ava script
In IE the form tag can have a property of autocomplete set to false and the form elements won't do that. Bryan - Original Message - From: Andy Ewings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 6:50 AM Subject: ava script | OK another Javascript teaser. | | I have written a function which changes the value in text box 2 when the | value text box 1 changes. I call this function in the onchange event of | text box 1. By definition of the onchange event this function should run if | and only if the value in text box 1 is different when focus is lost to when | focus was gained. When I enter the form the value in text box 1 is blank. | I start to type in something and IE recognises that what I am trying to type | in I've entered before (much like when you attempt to go to a URL that is in | the browser history). I select the entry from the drop down list I get and | hit tab to tab off the text box. When I do this the function is not called. | However when I do not select it from the drop down list and type it in | manually it does call the function!does anyone know why this is | happening and what I can do to stop the browser trying to predict what I'm | typing in ? | | -- | Andrew Ewings | Project Manager | Thoughtbubble Ltd | http://www.thoughtbubble.net | -- | United Kingdom | http://www.thoughtbubble.co.uk/ | Tel: +44 (0) 20 7387 8890 | -- | New Zealand | http://www.thoughtbubble.co.nz/ | Tel: +64 (0) 9 488 9131 | -- | The information in this email and in any attachments is confidential and | intended solely for the attention and use of the named addressee(s). Any | views or opinions presented are solely those of the author and do not | necessarily represent those of Thoughtbubble. This information may be | subject to legal, professional or other privilege and further distribution | of it is strictly prohibited without our authority. If you are not the | intended recipient, you are not authorised to disclose, copy, distribute, or | retain this message. Please notify us on +44 (0)207 387 8890. | | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UDF best practices
I am getting pretty good results with saving my udf's in the session scope. see the tutorial at http://www.kcfusion.org/Presentations/cflp.zip Bryan - Original Message - From: Correa, Orlando (ITSC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 9:02 PM Subject: RE: UDF best practices | If I have a page request that calls several templates during the | request... | | For Example: | | + application.cfm | + myUDF.cfm | + index.cfm | + cfinclude template1.cfm | + cfmodule template2.cfm | | Should I be able to include myUDF.cfm in the application.cfm file and it | will be available to index.cfm, template1.cfm, and template2.cfm as myUDF()? | Currently I'm getting Error resolving parameter myUDF with this setup when | calling it from template2.cfm... | | If I set server.myUDF = myUDF() in application.cfm I get an The number of | arguments passed to a user-defined function cannot be less than the number | of parameters in its definition. This call to myUDF passes 0 arguments, but | 2 parameters are defined.. So when I pass in two dummy variables | server.myUDF = myUDF('x','x') I get an The symbol you have provided | (server.myUDF) is not the name of a function. in the calling page... Would | I need to make the arguments non-required to make this work properly... | | In this particular case, I'm running this in a hosted environment, so I | don't have access to put them in the /cfide/udf/ folder. | | Any insight would be appreciated... | | Orlando | | -Original Message- | From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, August 08, 2001 11:40 AM | To: CF-Talk | Subject: RE: UDF best practices | | | You could but what about re-usability outside the application. This is the | reason for the CFINCLUDE of the UDF. There's nothing stopping you from just | putting a UDF in the application.cfm or anywhere on a template. Only | limitation is that a UDF used as part of a CFINCLUDE must be defined before | it's to be used where a page based one can be anywhere on the page (even | after the UDF call). | | At 12:59 PM 8/8/01, you wrote: | Couldn't you just put them in the application.cfm for your application?? | | -Original Message- | From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] | Sent: 08 August 2001 15:11 | To: CF-Talk | Subject: Re: UDF best practices | | | 1. In the admin set the server variables to auto-lock | 2. run the template containing the UDFs before the application runs or on | machine startup. | 3. Set a CFLOCK with a scope of server | 4. Set each UDF to a variable in the scope server | CFSET Server.Test=Test() | 5. Call the UDF on any page without using a CFINCLUDE of it | CFSET name=Server.Test('michael') | | This is slightly slower than having the UDFs in a CFINCLUDE that's included | into the page. It's a better practice to do the following: | | 1. Create a small library of UDF's in a template (i.e. all data validation | in one file and all text manipulation in another). | 2. Save these UDF library templates in the CFIDE/UDF directory. | 3. Use a CFINCLUDE Template=/cfide/udf/text.cfm in the template you | want to use UDFs in. | | | At 08:59 AM 8/8/01, you wrote: | | Anyone know what's the best way to set a UDF as a global function for use | by | all tags (custom, includes, etc.)... or does one in fact have to include | the | function code locally in each file that's being called during a page | request? | | Thanks, | Orlando | | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Verity index problems
Try action=Purge first before you update. Bryan LaPlante - Original Message - From: Carlo van Wyk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 1:50 PM Subject: Verity index problems | Whenever I update my verity index after adding files, the index is updated. | However, whenever I update the verity after deleting files from the indexed | directory, it seems as if the index is not updated. I still get search | results from files that is already deleted. | | The code I use to update my index is included. Please advise. | | CFSET IndexCollection = coldfusion | CFSET IndexDirectory = c:\development\coldfusion\ | CFSET IndexRecurse = YES | CFSET IndexExtensions = .pdf, .doc, .htm, .html, .txt, .cfm, .html, .asp | CFSET IndexLanguage = english | | cfindex action=update | collection=#IndexCollection# | key=#IndexDirectory# | type=PATH | extensions=#IndexExtensions# | recurse=Yes | | Regards | Carlo | FAQ: http://www.thenetprofits.co.uk/coldfusion/faq | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFScript?
I am trying to create a custom tag for CF5 that will find functions in the body of the tag and run them dynamically. The end result of the tag will be saving or caching those user defined functions into the variable scope of my choice. This much of the tag I have working properly. I don't know if there is any way from inside a custom tag to dynamically run content inside of cfscript tags like so. CFSCRITP thistag.generatedContent; /CFSCRIPT Any idea's on how I could accomplish this. The tag looks like this in the calling template CF_FunctionCache Scope=Application function myFunction(){ // do stuff } /CF_FunctionCache ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFX and the caller scope?
I wish I had more information about how the request.class was written in the cfx.jar file. I would like to write my own support for the pageContext() into it. It would be nice at the very least to have support for session, application, request and caller scope. As usual I want something that the application is not supposed to do, or is it? - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 23, 2001 12:02 AM Subject: RE: CFX and the caller scope? | I have a lot of cfml custom tags and I am learning to write | them in Java. I have looked in the cf-talk and cfx-talk archives | as well as all the Allaire doc's I could find and searched via | google finding no information about interacting with the different | scopes of the calling template. | | Is it possible to communicate with the different scopes, session, | application, caller and so on? | | No, it's not, unfortunately. If I recall correctly, you can pass in string | attributes, and your custom tag can manipulate query objects, and that's it. | | Dave Watts, CTO, Fig Leaf Software | http://www.figleaf.com/ | voice: (202) 797-5496 | fax: (202) 797-5444 | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Regexp help
I need some help from one of the RegExp guru's. I am trying to get a list of function names from my page for example the following functions name resides in the page at position 9 to 17. I need a regular expression that will find everything between the word function and the parenthesis character ( so that I can get the word addition into a list. Here is what I have so far. cfset funcName = refindnocase(([function]+) [ ]+ \(,thistag.generatedcontent,1,true) function addition(a,b){ somevar = a + b; return somevar; } Bryan LaPlante ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: [Custom Tag Question] ThisTag.GeneratedContent...
Try saving the content in a variable first. cfset content = thistag.generatedContent then clear the content. cfset thistag.generatedContent = then do your replacement. cfoutput#ReplaceNoCase(content, 'do NOT', 'do')#/cfoutput - Original Message - From: Jamie Jackson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 10:38 AM Subject: [Custom Tag Question] ThisTag.GeneratedContent... | Please tell me if the following is possible, and how: I want to stifle | the output of the area between cf_MyTag and /cf_MyTag. | | Here is a simplified example: I the following output: Hello World, I | do want to display this sentence. | | ### Calling script ###: | cf_MyTag | Hello, World, I do NOT want to display this sentence. | /cf_MyTag | | ### MyTag.cfm (custom tag) ###: | cfoutput#ReplaceNoCase(ThisTag.GeneratedContent, 'do NOT', | 'do')#/cfoutput | | Currently, this displays: | Hello, World, I do NOT want to display this sentence. Hello, World, I | do want to display this message. (Obviously, I don't want the first | sentence displayed.) | | Is this best handled by cfsetting cfoutputonly=yes, or is there | another way that's already built into the custom tag framework? | | 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
Learning CFX
I am learning to write cfx tag in Java. If anyone is aware of open source tags that I can learn from I would like to download them. Thanks Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Learning CFX
Thank you sir. I am finding that either there docs are really poor or cfx tags have know way of knowing what is going on in the page. There seems to be no access to any variable scope like application, session, client and so on - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 16, 2001 7:24 AM Subject: RE: Learning CFX | Bryan, | FYI, ColdFusion v5.0 comes with 5 java CFX examples in | \CFUSION\cfx\java\distrib\examples\ | | | --- | Paul Mone | Ninthlink Consulting Group | [EMAIL PROTECTED] | http://www.ninthlink.com | 619.222.7082 | | | -Original Message- | From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] | Sent: Monday, July 16, 2001 4:57 AM | To: CF-Talk | Subject: Learning CFX | | | I am learning to write cfx tag in Java. If anyone is aware of open source | tags that I can learn from I would like to download them. | | Thanks | | Bryan LaPlante | 816-347-8220 | [EMAIL PROTECTED] | http://www.netwebapps.com | Web Development | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: table column names
Try this. CFQUERY NAME=QryResult DATASOURCE= MAXROWS= DBTYPE=ODBC /CFQUERY TABLE TR CFLOOP INDEX=ColumnName LIST=#QryResult.ColumnList# DELIMITERS=, TDCFOUTPUT#ColumnName#/CFOUTPUT/TD /CFLOOP CFOUTPUT QUERY=QryResult /TR TR CFLOOP INDEX=CellValue LIST=#QryResult.ColumnList# DELIMITERS=, TD#Evaluate(QryResult. #CellValue#)#/TD /CFLOOP /CFOUTPUT /TR /TABLE - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 16, 2001 5:32 PM Subject: table column names | Hello | | Is there a way to get the column names from a table, if you don't | know them. | I am passing a table name to a page then need to look up information in that | table. because I am going to be passing a number of table names, I can't | use column names from any one table. | The tables are of various sizes with anywhere from 4 to 20 columns. | | how can I display the query results? | example: | | CFQUERY | Select * | from #tblname#; | /CFQUERY | | The query itself works fine, but I dont know how to get to the results | | Thanks for any help | Rodney | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 Services
I will approach this from the NT point of view since you didn't say what OS your on. In user manager for domains you will see user rights under the policies menu. Click the checkbox labeled show advanced user rights in the user rights policy dialog. Choose access this computer from a network from the drop down menu and add the user that CF server is logged in as to the list of users. Double check the choice for log on as a service also gives permission to that user if it isn't already. Hope that helps. Bryan - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 16, 2001 4:14 PM Subject: CF Services | Hello again | | I'm hoping someone can help with permissions for the CF services. | by default CF logs on as the SYSTEM. but for security we don't want this. | | I have created a user account for CF. but am having problems with figuring | out what permissions it needs to run. | | CF executive and CF RDS seem to be running fine. | | CF Application Services I have worked on until I am down to what I hope is | the last error. | When I try to start it I get the error Error 2140 an internal Windows NT | error occurred. | When I view the Logs (all three), there are no errors or failures listed. | | Does anyone know how to set up what permissions CF needs (file and | registry). | Also for MSSQL server will me what I have also been trying to set up and am | having a registry permission failure I cant find. | | FYI: the system was really tightened down. the base line is only | Administrator and System have any privileges or permissions, both registry | and files. Each user account is set up individually as they are | created/needed. | | Thanks for any help | Rodney | | | | | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX and the caller scope?
I have a lot of cfml custom tags and I am learning to write them in Java. I have looked in the cf-talk and cfx-talk archives as well as all the Allaire doc's I could find and searched via google finding no information about interacting with the different scopes of the calling template. Is it possible to communicate with the different scopes, session, application, caller and so on? I also tried to invoke the javadoc on cfx.jar file to see if I could take a look at the class documentation and I keep getting a class constructor expected error so the html docs never get created. Any insight or help would be appreciated. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Define and Call UD-Functions
There is a tutorial you can download from the KCfusion (Cold Fusion user group in Kansas city) that shows you how to package udf's and load them once per life of the server if you choose the server scope. The tutorial says you can use any scope you want. http://www.kcfusion.org/ Look in the download section for Packaging UDF's - Original Message - From: Wagner Patrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 11, 2001 10:25 AM Subject: Define and Call UD-Functions | Hi there! | | I just started playing around with the UserDefined-functions in CF5 and | found a strange issue making it nearly impossible to | get any value of it. | | For example when defining global-functions in the application.cfm there | seems to be no way to use these in a sub-called customtag. | Is there a possiblity to reference the function created on top within the | customtag without defining it new? | | Or simply, is there a way to make the functions available in the | request-(scope)? | | | Best Regards | | Patrick Wagner | Application Engineer | conceptware ag | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Host provider needed
I have a friend that is looking for a Cold Fusion host that supports a web based shopping cart client so that he does not need to know programming to sell his products. Any body have suggestions. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Contents of textarea formfield getting stripped out after quotation mark
When you do the insert statement use PreserveSingleQuotes(form.textarea) around your value. CF puts escape characters around the single quotes so they don't crash your query. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 8:53 AM Subject: Contents of textarea formfield getting stripped out after quotation mark | I'm having a problem and can't figure out why. | Using Access97 for the backend, I submit a form with a textarea tag. If there | are quotation marks in the textarea tag, everything in the textarea from | where the quotation marks begin is stripped out when the textarea formfield | is inserted into the database. | | Why is everything from the quotation mark on, stripped out upon insert??? | | How can I get that stuff to NOT be stripped out? | | Thanks, | | Jo-Anne Head | [EMAIL PROTECTED] | | 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
test
Please disregard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
KCfusion meeting tomorrow
Hey KCfusion and local CFUG'ers Tomorrow Girish Kshirsagar will give a presentation on how to estimate software costs in a project. He shared a little bit of it with me already and it looks very interesting. The meeting will start at 7:pm like always. You can find the meeting location and a map at http://www.kcfusion.org See you there Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Need decryptor tag for CFUG presentation
I agree with you Raymond, I think as a producer of software I am offering a fair approach to the folks out there that are new to Cold Fusion. For every Application that I write and offer for sale I also make available all of the custom tags and components that it took to build that software. If your like most people the biggest reason for decrypting a template is to see how it was built rather than to steal it from the author. If you buy CF application from me, it is not because you can not build it yourself but rather you don't have the time. So if I offer you the tool to build it yourself and then offer the end product for sale I would hope you would take the initiative to learn the components instead of hack into the finished product. Not all companies take the same approach but I think most of the A/MM partners do, at least the ones that are CFUG managers. My .02 cents - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 8:45 AM Subject: RE: Need decryptor tag for CFUG presentation | Correct me if I'm wrong, and I'm saying this as Ray Camden, not Ray Camden | of Macromedia, but isn't use of this decryptor illegal? Should we so | casually discuss a piece of a software that is probably illegal to use? | | Also, in general, unless you encrypt your OWN files, you should not be | decrypting other people's templates. If you _do_ encrypt your files, you can | contact Tech support for help. Therefore, there is no need for this | software. | | Am I wrong here? And let's not discuss wether it's right or wrong, I'm | talking about legality. | | === | 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: Jones, Matt [mailto:[EMAIL PROTECTED]] | Sent: Friday, June 08, 2001 9:37 AM | To: CF-Talk | Subject: RE: Need decryptor tag for CFUG presentation | | | http://shrewm.net/cfd/ | | -Original Message- | From: Alii Design [mailto:[EMAIL PROTECTED]] | Sent: Friday, June 08, 2001 8:30 AM | To: CF-Talk | Subject: RE: Need decryptor tag for CFUG presentation | | | That website is gone http://shroom.dv8.org/cfd/ I was looking for it | recently and it has been down. | Is there another? | 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: How to get a list of all tables in a given datasource - and how to combine queries
That's very cool Clint, have you written a web version of the sql client so that you can query the database and see your result set's? Bryan - Original Message - From: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 9:01 AM Subject: Re: How to get a list of all tables in a given datasource - and how to combine queries | Getting all the tables for a SQL database is simple. Just query the system table 'sysobjects' with this query: | | Select name,xtype from sysobjects where xtype = 'u' and name not like 'dt%' Order By Name | | For your second question it will take some logic to do what you want. Go look at this app that I am writting. It is a web based sql manager. | | www.factorxsoftware.com/sqlmanager | | HTH | | Clint | | -- Original Message -- | From: JoshMEagle [EMAIL PROTECTED] | Reply-To: [EMAIL PROTECTED] | Date: Fri, 08 Jun 2001 08:34:07 -0400 | | Have two questions | | First, given the name of a datasource, how do I go about finding what tables | are contained in the datasource via CF (not just opening SQL Server) | | Second, I have a query of all the datasources on my server using | cfregistry that is returned as a query ... how can I combine this | information with the query to display the tables into one query? Is this | even possible? | | THANKS! | | Joshua Miller | Web Development | Eagle Technologies Group | Technology Solutions for the Next Generation | www.eagletgi.com | [EMAIL PROTECTED] | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT BUT URGENT: IIS stability
A similar thing happened to me and the cause of the memory saturation was a security site I had used RDS security or advanced security. If you are using the native cfauthenticate cfauthorize tags in a security setting, go look at siteminder in perfMon and see how much memory it has tied up. It seemed unrelated at the time I had problems, but replacing it with another solution for security remedied the problem. Bryan - Original Message - From: Alistair Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 12:02 PM Subject: OT BUT URGENT: IIS stability | Hi guys ( gals) | | Sorry for the OT post, but I REALLY need help on this one, people's jobs | are on the line. | | We have a serious problem with stability on IIS 5, Win 2K, CF 4.5.2. IIS | has suddenly started to die. Symptoms include - | | - Existing virtual directories get lost. VDir's that have been working | fine for 6 months suddenly return This page cannot be displayed IIS | errors. If you delete the VDir and recreate it, it works again. | | - CF pages take forever to return. Flat HTML pages are responding | reasonably well, but all the images now take forever to download. | Restarting the CF service seems to help, but only for about half an | hour, then it returns. | | - FTP transfer rates have gone down from over 200K / second to about 5 | BYTES / second. | | My first thought was a runaway CF process somewhere, but when we look at | performance monitor on the CF/IIS server, CPU usage is only at 5% and | memory usage is minimal. Then we thought it might be persistent database | locks, but we've eliminated that. Performance monitor on the DB server | shows only minimal CPU / memory usage too. | | We have CF and IIS on one server (Dual PIII 800, 1.3GB RAM) and SQL | running on another. The SQL server is set up as the domain controller. | CFSTAT shows that the database response time is fine, it's just taking | ages for requests to get to from the server. | | I know that at my last job, IIS was rebuilt as a regular maintenance | task every two or three months. This installation of IIS has been for | the last five or six months until this last week. And no code has | changed in the last three weeks. | | Has anyone else had similar problems? How often do you all have to | rebuild / re-install IIS ? I need some figures to give to the management | ASAP, as they're starting to growl for blood. | | Mail me directly if you like | | Cheers, | | Alistair Davidson | Senior Web Developer | Rocom New Media | www.rocomx.net | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Login Management
Chaz, I built a couple of free custom tags that replace CF's advanced security with a database solution. I also sell a management console to manipulate the database. You can find all of the tutorials and documentation at http://www.netwebapps.com/products/securitymanager/introduction.cfm Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development - Original Message - From: Chaz Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 3:38 PM Subject: Login Management | Hi there, | | Can either of you recommend a nicely built login management application built with Cold Fusion, which would allow me to assign permissions to varying categories of users? | | Thanks, | Chuck | | Find the best deals on the web at AltaVista Shopping! | http://www.shopping.altavista.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
CF 5 Eval
Is anyone else evaluating or currently using CF 5? I have got some examples I would like to share with you about getting tons of user defined functions to run in memory instead of having to load them at the top of ever page. It is kind of the same effect you would get from caching a query except with a function instead. Anyway before I go into it. Anybody? Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 5 Eval
Ok let me get the sleep out of my eye's. I am going to keep responding to my own post in an effort to keep the progression of the responses cleaner. I don't all my presentations together yet but I will probably present this subject to my cfug in Kansas city meeting after next. Here is what I found about User defined functions. Raymond Camden and Rob Brooks-Bilson are leading a project called Common Function Library Project at http://www.cflib.org/. They have put together 4 libraries of udf's complete with documentation and examples, very helpful in getting you started with udf's. The notion of loading a group of functions using cfinclude at the top of ever template that requires access to said functions, well I am thinking it's too heavy. go download http://www.netwebapps.com/projects/cflp.zip this zip file while I go get my coffee and I will explain what I have done to allow you to drop these libraries into you custom tags folder and only have to load them once pre session,application,request or server occurrence, which ever you choose. Bryan - Original Message - From: Bryan LaPlante [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 1:43 AM Subject: CF 5 Eval | Is anyone else evaluating or currently using CF 5? I have got | some examples I would like to share with you about getting tons of user | defined functions to run in memory instead of having to load them at the top | of ever page. It is kind of the same effect you would get from caching a | query except with a function instead. | | Anyway before I go into it. Anybody? | | Bryan LaPlante | 816-347-8220 | [EMAIL PROTECTED] | http://www.netwebapps.com | Web Development | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 5 Eval
The zip file in the previous post contains 4 custom tags and their editors. The STRLIB.cfm file would be copied to your custom tag directory under CFUSION\CustomTags. All of the tag editors are the same with the exception that they each output a tag by there own name, but all of these tags have a common attribute which is the SCOPE attribute. Here is a break down of what the custom tag does. 1. First check to see if the SCOPE attribute is present in the call to the custom tag. CFIF NOT IsDefined( 'Attributes.SCOPE' ) HR H4Missing Attribute/H4 You need to specify a value for the [ BSCOPE/B ] attribute. This attribute is required for the BCF_STRLIB/B tag. HR CFABORT CFELSE CFSET scopeVar = Attributes.SCOPE /CFIF 2. Setting that scopeVar variable will allow me to load the function into a scope when the tag is finished running them. 3. using concatenation to create a string that can be used in the isDefined() function any function in your custom tag would be chosen to see if it exists in the scope chosen by the user. -- CFSET evalString = scopeVar '.IsEmail' !--- Check to see if the scope named above contains the isEmail function. If it does then do not run the rest of the tag, otherwise build the function library and assign it to the requested scope. --- CFIF NOT IsDefined(#evalString#) -- 4. If the above returns true or does not find the IsEmail function in the scope attribute, for example if the scope attribute was session and the tag had already been run once, the value session.email would already be present and the condition above would return false. If the condition above returns false then the rest of the custom tag stops running and returns you to the rest of your page processing. 5. Given the above is true the next thing to do is run all of the function inside a set of cfscript tags. --- CFSCRIPT function isEmail(){ return testing with this string of text; } /CFSCRIPT --- 6. This next loop is where the assignment will take place. First set up a list of scope names to be searched. -- scopelist = server,application,session; CFLOOP INDEX=func LIST=IsEmail,other,Functions,In,The,Library DELIMITERS=, 6a. Check to see if the scope chosen by the user is found in the scopelist CFIF ListContains(scopelist,Lcase(trim(scopeVar))) -- 6b. If it is, Use cflock to prevent multiple users from writing to the same variable name at the same time. --- CFLOCK TIMEOUT=10 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=#scopeVar# CFSET Evaluate(scopeVar . func = func) /CFLOCK -- 6c. Other wise in the case of a request scope or local variable just assign the function name to a variable of it's own name --- CFELSE CFSET Evaluate(scopeVar . func = func) /CFIF /CFLOOP - After the custom tag runs it will not need to run again unless you chose the request scope in which case it is not persistent and the tag will run again and again for each new page request.. 7. To access your function in the session scope for example you would refer to it as: -- CFOUTPUT #session.IsEmail('[EMAIL PROTECTED]')# /cfoutput Ever request after the tag has already run will come right from the session structure and as a result your function call will run just like it was a native function call like Len() or ListContains(). That's pretty much it in a nut shell. - Original Message - From: Bryan LaPlante [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 9:11 AM Subject: Re: CF 5 Eval | Ok let me get the sleep out of my eye's. | | I am going to keep responding to my own post in an effort to keep the | progression of the responses cleaner. I don't all my presentations together | yet but I will probably present this subject to my cfug in Kansas city | meeting after next. | | Here is what I found about User defined functions. Raymond Camden and Rob | Brooks-Bilson are leading a project called Common Function Library Project | at http://www.cflib.org/. | They have put together 4 libraries of udf's complete with documentation and | examples, very helpful in getting you started with udf's. | | The notion of loading a group of functions using cfinclude at the top of | ever template that requires access to said functions, well I am thinking | it's too heavy. go download http://www.netwebapps.com/projects/cflp.zip this | zip file while I go get my coffee and I will explain what I have done to | allow you to drop these libraries into you custom tags folder and only have | to load them once pre session,application,request or server occurrence, | which ever you choose
Re: cfhttp/cffile locking?
You only need to use scope on server, application and session. To single thread another resource like cfhttp, cffile or cfregistry use the name attribute instead. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, June 03, 2001 5:50 AM Subject: cfhttp/cffile locking? | I've heard that I need to lock cffile and cfhttp also? | Is that right? | what SCOPE should I use?! | | -=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: Store Query in APPLICATION variable
You should look into the CACHEDAFTER and CACHEDWITHIN attributes of the CFQUERY tag. This will allow you to keep queries in memory for a period of time that you indicate using the CreateTimeSpan(days, hours, minutes, seconds) function. Every time the query is run with exactly the same parameters it will be served from memory not requiring an additional trip to the database. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development - Original Message - From: Hamid Hossain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 12:39 AM Subject: Store Query in APPLICATION variable | Hi folks, | | I want to store a query results in an APPLICATION | variable. So, it will be available for all users with | making the call through ODBC every time. | | for examble: | | the query may be for Countries like: | | cfquery datasource=DS name=GetCountries | SELECT * FROM Countries | /cfquery | | then, I will use it with a loop to make HTML drop-down | menu with SELECT | | Is there a way to do that ? please tell me if it is | important to use CFLOCK with the previous code. | | Thanks | Hamid Hossain | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF5 and UDF's
Is anyone playing with user defined functions? I can not find any doc's on the subject in cfdocs or in studio. I wander if there is a way to do what I am trying below CFSCRIPT function mydate(){ if (arguments is ) d = now(); else d = arguments[1]; return DateFormat(d); } /CFSCRIPT CFOUTPUT#mydate(01/01/2001)#/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: CF5 and UDF's
Thanks, I was walking past the kitchen table and picked up a copy this months cfdj and read Ben Forta's article. That got me to thinking how could I put all of my function in one place and load them up only once per visit to the web site and not cfinclude them on ever page. I wrote this cool little custom tag that lets you pick your scope like session, application, request and then the tag loops through the function names assigning them to the that scope. Now I am thinking about building a wizard like my custom tag wizard that will let you go in an package all of your functions into a library by way of a custom tag. What d-ya think. Bryan - Original Message - From: Dain Anderson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 9:29 AM Subject: Re: CF5 and UDF's | Bryan, | | In UDF's, you can use the ArrayLen() function to check for the existence of | passed values: | | CFSCRIPT | function mydate() | { | var d = ; | if(ArrayLen(Arguments)) | d = Arguments[1]; | else | d = Now(); | return DateFormat(d); | } | /CFSCRIPT | | CFOUTPUT#mydate(01/01/2001)#/CFOUTPUT | | Dain Anderson | Caretaker, CF Comet | http://www.cfcomet.com/ | | | - Original Message - | From: Bryan LaPlante [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Saturday, June 02, 2001 4:04 AM | Subject: CF5 and UDF's | | | Is anyone playing with user defined functions? I can not find any doc's on | the subject in cfdocs or in studio. I wander if there is a way to do what | I | am trying below | | CFSCRIPT | function mydate(){ | if (arguments is ) |d = now(); |else |d = arguments[1]; | | return DateFormat(d); | } | /CFSCRIPT | | CFOUTPUT#mydate(01/01/2001)#/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: CF5 and UDF's
Yes, the custom tag I built was for the _strlib function library, I'll send you a copy off line if you like and you can check it out. - Original Message - From: Dain Anderson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 9:51 AM Subject: Re: CF5 and UDF's | Now I am thinking about building a wizard like my custom tag wizard that | will let you go in an package all of your functions into a library by way | of | a custom tag. What d-ya think. | | Hey, have at it :-) | | Have you seen the Common Function Library Project yet? | | http://www.cflib.org/ | | Dain Anderson | Caretaker, CF Comet | http://www.cfcomet.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: Securing user created sub-directories
If the only file types in those directories are cfm pages you can put some code in the application.cfm file to check for a login otherwise if there are images and htm pages in the directory any user could view those files with out cf knowing about it. Bryan - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 1:40 PM Subject: Securing user created sub-directories My goal is to allow a person to create sub-directories at will and let them assign a UserAcct/Password to the sub-directory in order to view the directories contents. Need to prevent someone from typing in the url and viewing the contents without first logging in with a valid UserAcct/Password. Can this be done using ColdFusion/IIS? Thanks, Dave Bosky HTC Web Application Developer Macromedia Certified ColdFusion Developer 843.369.8613 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: COOKIE expiration :((
You may already be doing this but the value should be EXPIRES=NEVER not timeout Bryan - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 3:27 AM Subject: COOKIE expiration :(( I'm getting really frustrated from this CFCOOKIE thing. Apparently, after I assign the cookie with Timeout=Never the cookie is deleted and terminated every time the user closes the browser. I tried to change Timeout to 14 days, but it didn't help. Closing the browser terminates the cookie. Is there a diffrent way to assign cookies? PLEASE HELP!!! -=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: Logon Attempts
To resolve the problem put this code into login.cfm cfif isDefined(client.counterVar) cfset client.counterVar = IncrementValue(client.counterVar) cfelse cfset client.counterVar = 1 /cfif You can use cfinclude or call the login.cfm as a custom tag, either way the client scope will persist to the next page load where you can check it for the appropriate action. - Original Message - From: Jerry Staple [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:35 AM Subject: Logon Attempts Could anyone inform tell me what would be the best way to implement a logon page where the user gets 3 attempts to logon,after the 3 attempts the user is directed elsewhere.I have tried setting a variable on the application page then adding +1 when it goes to the Logon_Action.cfm but to no avail. Help Regards Jerry Staple Web Applications Developer Biznet Solutions 133 - 137 Lisburn Road Belfast BT9 7AG www.biznet-solutions.com Tel: +44 (0)28 90205652 Fax: +44 (0)28 9022 3223 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Paste Screen Capture into a browser and submit it
If you are on an intranet and you just need to get to the users screen, you may want to look at this kind of solution. http://www.uk.research.att.com/vnc/ - Original Message - From: Don VanMeter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:00 AM Subject: Paste Screen Capture into a browser and submit it I am stumped. Are there any CF Gods out there? I need to add the capability of a user to paste a screen capture(alt - print screen) of a windows application error, into a browser form without the user having to open another application, save the image , close the application, find the saved file, select it and then upload it. I am not talking about text, I am talking about the bitmap created from a screen capture . I don't know if it resides in the clipboard. The user needs to be able to paste it into a browser page and submit it. I tried CFX_DynamicImage and it brought my server to it's knees. Any Ideas? Thanks, Don ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: whitespace
I use cf_LessWhiteSpace from the tag gallery http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34784E-2830-11D4-AA 9700508B94F380method=Full - Original Message - From: nagesh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 25, 2001 2:08 PM Subject: whitespace hi all, i really fed up with the white space which is generated in the text file by coldfusion(4.5). This happens when client(outlook) is reading the data which is in output tags and trying to write into the text(log) file. Do we have anything by which we can remove/trim the white space before it goes to text file. Because the problem here is with the white space the size of the file is getting increased like anything. I know about cfsetting enablecfoutputonly=yes tag. but i want something powerful than that. Any ideas would be greatly appreciated. Thanks nagesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: whitespace
Could you clarify for me how you are using outlook as a client to read output from CF. I am a little confused when you say text file when talking about using outlook. What I'm hearing is you are using outlook to read a text file but I don't think that is what you are intending to say, or is it? Bryan - Original Message - From: nagesh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 25, 2001 3:15 PM Subject: RE: whitespace Hi bryan, thanks for the response. But i used even that tag too. And i tried with option available in settings in the administrator to suppress the whitespace. Is there any otherway around to overcome this problem. Because, the textfile is going to generated by the outputs of the 3 to 4 coldfusion files. -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 3:50 PM To: CF-Talk Subject: Re: whitespace I use cf_LessWhiteSpace from the tag gallery http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34784E-2830-11D4-AA 9700508B94F380method=Full - Original Message - From: nagesh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 25, 2001 2:08 PM Subject: whitespace hi all, i really fed up with the white space which is generated in the text file by coldfusion(4.5). This happens when client(outlook) is reading the data which is in output tags and trying to write into the text(log) file. Do we have anything by which we can remove/trim the white space before it goes to text file. Because the problem here is with the white space the size of the file is getting increased like anything. I know about cfsetting enablecfoutputonly=yes tag. but i want something powerful than that. Any ideas would be greatly appreciated. Thanks nagesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFX resources
Funny you would post this just now. I was just searching the web for that very subject when I stumbled upon a site that looks like they have written their own version of the Allaire docs. I don't know how different or alike they might be but here is the url. http://nesen.unl.edu/cfdocs/Advanced_ColdFusion_Development/11_Building_Cold Fusion_Extensions/adv11.htm Bryan - Original Message - From: dave fauth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 24, 2001 3:55 PM Subject: Re: CFX resources what languages do you want At 01:32 PM 5/24/2001 -02-30, you wrote: Hi all, No matter how much I look I cannot seem to locate a good reference for creating CFX tags. I've been through the Allaire doc's but I want to know what other languages you can use to create CFX tags. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ Toronto ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 DBMS select distinct
Sorry for the off topic but how do you select distinct only on one of several items in a select statement. I only want the unique names from the query below but this doesn't seem to be working. Winnt 4 sp6 CF 4.5.2 Access or SQL 6.5 select r.ResourceID, distinct r.Name, r.Description, p.ApplicationID from Resources as r LEFT OUTER JOIN Policies as p ON r.ResourceID = p.ResourceID The error message Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Cannot include Memo, OLE, or Hyperlink Object when you select unique values (r.Description). Thanks in advance for your help Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT DBMS select distinct
Ok I see where you are going with this. your suggested work around does get the unique values but the output duplicates the same value the number of time it is referenced in the table. I will play around with it and worse case I will just use the group field in the cfoutput. Thanks for the heads up. Bryan - Original Message - From: John [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 24, 2001 10:20 PM Subject: RE: OT DBMS select distinct The key word distinct does not work that way. It will only allow duplicate record sets but does nothing for individual fields unless it is a one field query. A work around is as follows but depending on the data set . Hope this helps. John select r.ResourceID, r.Name, r.Description, p.ApplicationID from Resources as r LEFT OUTER JOIN Policies as p ON r.ResourceID = p.ResourceID where r.name in (select distinct name from resources) -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 10:04 PM To: CF-Talk Subject: OT DBMS select distinct Sorry for the off topic but how do you select distinct only on one of several items in a select statement. I only want the unique names from the query below but this doesn't seem to be working. Winnt 4 sp6 CF 4.5.2 Access or SQL 6.5 select r.ResourceID, distinct r.Name, r.Description, p.ApplicationID from Resources as r LEFT OUTER JOIN Policies as p ON r.ResourceID = p.ResourceID The error message Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Cannot include Memo, OLE, or Hyperlink Object when you select unique values (r.Description). Thanks in advance for your help Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: NT User authentication
CF has this ability through advanced security. There is a bit of a learning curve but once you figure it out it makes sense why it works the way it does. Start reading the docs and when you get stuck email the group and I'll keep an ear out for you. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 9:02 PM Subject: Re: NT User authentication Yes, But I want to check the password too. Thanks Neil - Original Message - From: John Wilker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 9:47 PM Subject: RE: NT User authentication Assuming this will be running on an intranet where users will have to login to NT, you can access their NT login name with #REMOTE_USER# it should return domain/username you'll need to turn anonymous access off in IIS in order to make the variable record. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Pepsi's Come Alive With the Pepsi Generation translated into Pepsi Brings Your Ancestors Back From the Grave in Chinese. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 6:36 PM To: CF-Talk Subject: Re: NT User authentication No no, I want to have a login page that compares the username and password to the NT user database :) Thanks, Neil - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 7:29 PM Subject: RE: NT User authentication Turn off anonymous access, use NT/Challenge Response and or Plain Text(netscape). Remove the IUSR_Machinename from the dirctory ACL. And make sure to allow system access to the directories othwise your default install of CF can't access the scripts to run. HTH Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 2:37 PM To: CF-Talk Subject: NT User authentication I am looking for a method where the website can authenticate against the NT user database. Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: VTML edit tag dialogs: attributes with no value?
Use the free custom tag wizard at http://www.netwebapps.com/mytags/main.cfm .. On the last screen you get a chance to choose the type of control you want associated with your input and choosing a checkbox from the drop down gives your vtm file that default behavior. CF_CUSTOMTAGWIZARD TAGNAME=sample [EMAIL PROTECTED] EMAILMESSAGE=thanks for useing our tag wiz SENDASHTML=false The sendashtml is a checkbox and if left unchecked it outputs with the value of false or true if checked. Bryan - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 1:03 AM Subject: Re: VTML edit tag dialogs: attributes with no value? In CF Studio: Select the tag selector tab in the resources area. (Next to the help tab) Then select the little yellow gear with the hint Edit Tag Definition. (Half way up on the gray separation bar) Use this to edit all your VTMs, it's a breeze. Rob Rusher Flare Networks Inc. 233 Linden Street Fort Collins, CO 80524 (970) 498-9196 Office (303) 884-7044 Cell (970) 472-1775 Fax [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.flarenetworks.com -- -- This email and any accompanying documents contain information belonging to the sender which may be confidential and legally privileged. This information is only for the use of the intended individual or entity to whom this electronically transmitted message is sent. If you are not the intended recipient, any disclosure, copying, distribution, or action taken in reliance on the contents of the information contained in this transmission is strictly prohibited. If you receive this transmission in error, please call Flare Networks collect at 970-689-1294 and delete the message and any attachments. -- -- - Original Message - From: Kay Smoljak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 9:48 PM Subject: Re: VTML edit tag dialogs: attributes with no value? On Mon, 21 May 2001 08:23:08 -0400, Raymond Camden [EMAIL PROTECTED] wrote: You can do a conditional output by using WIZIF So, your VTML portion of the TAGLAYOUT portion can do this: mytag WIZIF fieldname EQ 'true'TEXT_BOLD = 1/WIZIF This way it would only show up if true, not false or not selected at all. Thanks, but is there any way of doing this in the EDITORLAYOUT? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: cfcatch and email
Never tried to do that inside of a cfcatch block before but could you just populate a variable with the email message and then outside the try block check to see if the message is not empty and then send an email if so? Bryan - Original Message - From: sebastian palmigiani [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 10:39 PM Subject: cfcatch and email I want to send an email with database error info using cftry/cfcatch. But it is not working. Am I trying to do something that can't be done within a cfcatch block? Sebastian --- cftry cfquery name='foo' datasource='foo' Select * from members /cfquery cfcatch type=database !--- EMail WebMaster --- cfmail from=[EMAIL PROTECTED] type=HTML to=[EMAIL PROTECTED] subject=Database Error Date: #DateFormat(Now(), MM D, YYY)# #TimeFormat(Now(), h:mm tt)#br Error Type: #CFCATCH.Type#br Message: #CFCATCH.Message#br Template: #CGI.CF_Template_Path#br Referer: #CGI.HTTP_Referer#brbr Details: #CFCATCH.Detail#brbr /cfmail cflocation url=index.cfm?go=Error --- /cfcatch /cftry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: VTML edit tag dialogs: attributes with no value?
I'm in the middle of adding a project to source safe, give me a sec and I will grab a vtm file to see if you can change something to accommodate that. Bryan - Original Message - From: Kay Smoljak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 7:12 AM Subject: Re: VTML edit tag dialogs: attributes with no value? On Tue, 22 May 2001 02:35:20 -0500, Bryan LaPlante [EMAIL PROTECTED] wrote: Use the free custom tag wizard at http://www.netwebapps.com/mytags/main.cfm .. On the last screen you get a chance to choose the type of control you want associated with your input and choosing a checkbox from the drop down gives your vtm file that default behavior. CF_CUSTOMTAGWIZARD TAGNAME=sample [EMAIL PROTECTED] EMAILMESSAGE=thanks for useing our tag wiz SENDASHTML=false The sendashtml is a checkbox and if left unchecked it outputs with the value of false or true if checked. OK, that's my problem... the tag takes parameters like this: cfx_pwimageproc text_draw=testing text text_bold -- would create text in bold cfx_pwimageproc text_draw=testing text -- would create text NOT bolded if the attribute was written as TEXT_BOLD=true or TEXT_BOLD=false it would still turn out bolded, because when the tag runs it is checking for the existence of the attribute. If the attribute TEXT_BOLD is not included the effect will not be applied. If the attribute TEXT_BOLD is included, the effect will be applied. It doesn't matter what the value of the attribute is. It could be TEXT_BOLD=who_gives_a_toss and the text will still come out bold. I can do this in Tag Insight by specifying the attribute as type flag... there doesn't seem to be an equivalent for the tag editor dialog box. K. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: VTML edit tag dialogs: attributes with no value?
Ok I got it. I did this like 4 times with bad results so be careful how you type it in. This is the line from one of my tags that tag editors that I got to work like you want. It thinks checked it true and not checked is false but don't forget the single quotes or it will through an error. WIZIF edtThrowOnError EQ 'true'$$SpacingGap$${DefaultCase('ThrowOnError')}=$${Q}$$edtThrowOnError$${ Q}WIZSET SpacingGap = VertSpacingGap/WIZIF How does everyone else feel about this behavior, I can update the custom tag wizard to use this output instead of the current behavior that shows check box attributes whether they are checked or not. Your input would be appreciated. Bryan - Original Message - From: Kay Smoljak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 7:12 AM Subject: Re: VTML edit tag dialogs: attributes with no value? On Tue, 22 May 2001 02:35:20 -0500, Bryan LaPlante [EMAIL PROTECTED] wrote: Use the free custom tag wizard at http://www.netwebapps.com/mytags/main.cfm .. On the last screen you get a chance to choose the type of control you want associated with your input and choosing a checkbox from the drop down gives your vtm file that default behavior. CF_CUSTOMTAGWIZARD TAGNAME=sample [EMAIL PROTECTED] EMAILMESSAGE=thanks for useing our tag wiz SENDASHTML=false The sendashtml is a checkbox and if left unchecked it outputs with the value of false or true if checked. OK, that's my problem... the tag takes parameters like this: cfx_pwimageproc text_draw=testing text text_bold -- would create text in bold cfx_pwimageproc text_draw=testing text -- would create text NOT bolded if the attribute was written as TEXT_BOLD=true or TEXT_BOLD=false it would still turn out bolded, because when the tag runs it is checking for the existence of the attribute. If the attribute TEXT_BOLD is not included the effect will not be applied. If the attribute TEXT_BOLD is included, the effect will be applied. It doesn't matter what the value of the attribute is. It could be TEXT_BOLD=who_gives_a_toss and the text will still come out bold. I can do this in Tag Insight by specifying the attribute as type flag... there doesn't seem to be an equivalent for the tag editor dialog box. K. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Could someone test this
I uploaded a free wizard to the tag gallery at Allaire and stupid me I wasn't paying attention and I made the download link relative to the Allaire web site. I just went back in and fixed it. It looks like it is working. Just so I will know that my browser is not caching the result. Would one of you kindly go to the tag gallery and click on the custom tag wizard and then click on the link at the top to see if it starts the wizard. Your help is very much appreciated. http://devex.allaire.com/developer/gallery/index.cfm Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Dynamic Queries (RecordCount)
you should be able to just output the queryname.recordcount. make sure it is spelled correctly Bryan - Original Message - From: Steve Reich [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 6:06 PM Subject: Dynamic Queries (RecordCount) How do I set a variable equal to the recordcount of this query? Here's what I've been trying ~CODE cfset queryName = MyQuery cfquery name=#queryName# datasource=#application.dns# dbtype=ODBC username=#application.dns_username# password=#application.dns_password# cachedwithin=#CreateTimeSpan(0,0,10,0)# SELECT * FROM data WHERE dataid = #dataid# /cfquery cfset queryCount= evaluate(queryName .recordcount) cfoutput#queryCount#/cfoutput cfabort ~CODE This code returns the following error: ~ERROR Error Diagnostic Information An error occurred while evaluating the expression: queryCount=evaluate(queryName .RecordCount) Error near line 109, column 7. An error has occurred while processing the expression: 21.RecordCount Invalid parser construct found on line 1 at position 4. ColdFusion was looking at the following text: RecordCount Invalid expression format. The usual cause is an error in the expression structure. ~ERROR Seems like I've done this a million times, but I'm not hitting on all cylinders today. The name of the query is an integer if that makes any difference. Can somebody point out the obvious for me? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Could someone test this
Thank you everyone who replied to me off list. Sometimes I don't know were my head is at. Bryan - Original Message - From: Bryan LaPlante [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 6:27 PM Subject: Could someone test this I uploaded a free wizard to the tag gallery at Allaire and stupid me I wasn't paying attention and I made the download link relative to the Allaire web site. I just went back in and fixed it. It looks like it is working. Just so I will know that my browser is not caching the result. Would one of you kindly go to the tag gallery and click on the custom tag wizard and then click on the link at the top to see if it starts the wizard. Your help is very much appreciated. http://devex.allaire.com/developer/gallery/index.cfm Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Bizarre Error: Server/Studio Duplicating Carriage Returns
There is an option in studio's settings under tools (F8) that will allow you to choose your file settings so that a saved document uses the OS type of document structure. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development - Original Message - From: Willy Ray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 12:17 PM Subject: Bizarre Error: Server/Studio Duplicating Carriage Returns I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1. When I save a template through RDS, for every carriage return I enter as I code, I get two carriage returns on the saved document. Example: I write: html head titleHello/title /head When I re-open the file it looks like this: html head titleHello/title /head What's worse, If I make a little change, like, change the Hello to Hello, World and re-save the template, the next time I open it, it looks like this: html head titlehello, world/title /head Big problem. I've got a template with only about 20 lines of actual code on it, but it's up to about 14000 lines, due to this problem. I have studio on two different machines, and it doesn't seem to matter which I use. Also, this is not happening from the same two workstations if I write to an NT machine through RDS, or through windows networking. Any ideas? Willy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFINPUT -- not validating Integer
Here is an experment that did and it works for IE, someone on the list may have the equivilent for NS. Here are the docs for all the char codes. http://msdn.microsoft.com/workshop/author/dhtml/reference/charsets/charset1. asp Basicaly I just added an event to the input tag after it was loaded and told it to check every key strock for the keyCode 46 (.) and return keyCode = 0 instead. It's not pretty but it may give you some idea's. Heres the page html head script function addValidation() { document.foo.barr.attachEvent('onkeypress',badChar) } function badChar() { if (event.keyCode == 46 event.srcElement.value.length = 0) { event.keyCode = 0; alert(); return true; } } /script /head body onload=addValidation() CFFORM ACTION=#SCRIPT_NAME# METHOD=POST ENABLECAB=Yes NAME=foo CFINPUT TYPE=Text NAME=barr MESSAGE=no way VALIDATE=integer REQUIRED=yes SIZE=10 BR INPUT TYPE=submit VALUE=go /CFFORM SCRIPT /script /body /html - - Original Message - From: Michael S. Kimmett [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 4:37 PM Subject: CFINPUT -- not validating Integer Howdy, I am trying to get the CFINPUT Tag to validate an integer on a form. The darn tag will validate SSN, zipcodes, etc, but when I enter the integer parameter and test the validation using the following value ( .3 or any value that starts with a decimal point ) the javascript validation fails ( the js allows the value to pass). Does anyone know if this is a bug in CF 4.5 and something that I will just have to live with? Michael CFFORM Name=Test ACTION=appCFINPUTTEST.cfm CFINPUT Type=Text Name=Number1 Required=yes validate=integer Message=You did not provide a correct Integer! Size=20 Maxlength=30 BR INPUT Type=Submit Name=Submit Value=Submit /CFFORM ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: IE4 and Required Fields w/ CFINPUT
If the radio buttons are the only difficulty you are having in IE4, it would be easier to just make one of them checked and not use cfinput for that element, that way you are sure to get a value. Bryan - Original Message - From: Ray Bujarski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 2:45 PM Subject: Re: IE4 and Required Fields w/ CFINPUT Make sure your cfform tag has a name AND the cfinput type has a name specified At 03:27 PM 5/14/2001 -0400, you wrote: Ok, My form works like a champ in Netscape and I run into no problems in IE5 but I get a javascript error in IE4. Since I have no javascript on the page I can only assume it is the javascript that is auto-generated by my CFINPUT TYPE=Radio REQUIRED=Yes ... ... Anyone else run into problems using required=yes under IE4? Is there any way around it? Matt Hood ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session/Application Locking
I would like a copy of that attachment. We just had Daryl Banttari a Macromedia consultant speak to our CF user group last Tuesday in Kansas City and he did a presentation on performance tuning that included some eye opening information on locking variables. The power point presentation is available on our CFUG web site at http://www.kcfusion.org/ Thanks Bryan LaPlante - Original Message - From: Mike Brunt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 13, 2001 10:55 AM Subject: RE: Session/Application Locking Thank you and my apologies to all on the list, the attachment is only 21kb, if anyone wants it, please let me know. Kind Regards - Mike Brunt -Original Message- From: ibtoad To: CF-Talk Sent: 5/13/01 11:46 AM Subject: RE: Session/Application Locking Attachments don't work on this list. Rich -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 11:23 AM To: CF-Talk Subject: RE: Session/Application Locking I have attached an article by Jim Schley of Macromedia which gives a good explanantion of locking. There is also a paper by Ben Forta. Hope this helps. Kind Regards - Mike Brunt Macromedia Consulting -Original Message- From: Michael Lugassy To: CF-Talk Sent: 5/13/01 5:48 AM Subject: Session/Application Locking Hi, can someone please explain how can I lock session/application/other shared variables in order NOT to lose them? I know there is a timeout and/or readonly attribute but I can't seem to understand what to use and where. if you can clarify, I would be more then grateful. BTW: I don't want to use CF automatic lock. 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 5.0 graphs
Just as a heads up, if you have personal custom tags or download any from the tag gallery and you would like a personal tag editor for them, go to http://www.netwebapps.com/mytags/main.cfm and use the free custom tag wizard. After you put in the parameters for the tag it will email you a .vtm file for the tag editor. If you want to click on the banner adds the spongers make it possible to offer this tool for free. Bryan LaPlante - Original Message - From: Kevin Gilchrist [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 12:29 PM Subject: CF 5.0 graphs Hi All, I'm just starting to play with the new CFGRAPH tag and I was wondering if anyone's created any tag editor's for it? I guess one will appear for Studio 5.0 but just wondering anyway. If no-one has I might just take a stab at it myself... Thanks, Kevin Kevin Gilchrist Senior Consultant RedSiren Technologies Inc. (412) 281 4427 ext 466 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Query Help!!
did you really mean to put the tick marks around the '#session.total#' or did you mean to pass that as an integer without the tick marks? Bryan - Original Message - From: ibtoad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 3:01 PM Subject: Query Help!! Does anyone see any problems with the following query: cfquery name=get_shipratedollars datasource=#config.datasource# Select shiprate from shipratesdollars WHERE '#session.total#' = shipfrom and '#session.total#' = shipto /cfquery I can not figure out why I am getting incorrect results. Sometimes it will pull more than one record and sometimes it will pull the max record only. Here is a copy of the table I am using named shipratedollars. ID shiprate shipfrom shipto 1 4.00 0.00 50.00 2 6.00 50.01 100.00 3 8.00100.01 200.00 4 12.00200.01 300.00 5 18.00300.01 500.00 6 25.00500.01 750.00 7 40.00750.01 1000.00 8 50.00 1000.01 1500.00 9 70.00 1500.01 2000.00 10 100.00 2000.009.00 Thansk, 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: Query Help!!
Sound like the data type for that field is not integer or currency as the output would suggest. That's probably why you are getting the mixed results. If it is possible I would convert the data and type in that field to currency and you may get better results. Bryan - Original Message - From: ibtoad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 6:04 PM Subject: RE: Query Help!! When I get rid of the tick marks I get: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. Rich -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:48 PM To: CF-Talk Subject: Re: Query Help!! did you really mean to put the tick marks around the '#session.total#' or did you mean to pass that as an integer without the tick marks? Bryan - Original Message - From: ibtoad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 3:01 PM Subject: Query Help!! Does anyone see any problems with the following query: cfquery name=get_shipratedollars datasource=#config.datasource# Select shiprate from shipratesdollars WHERE '#session.total#' = shipfrom and '#session.total#' = shipto /cfquery I can not figure out why I am getting incorrect results. Sometimes it will pull more than one record and sometimes it will pull the max record only. Here is a copy of the table I am using named shipratedollars. ID shiprate shipfrom shipto 1 4.00 0.00 50.00 2 6.00 50.01 100.00 3 8.00100.01 200.00 4 12.00200.01 300.00 5 18.00300.01 500.00 6 25.00500.01 750.00 7 40.00750.01 1000.00 8 50.00 1000.01 1500.00 9 70.00 1500.01 2000.00 10 100.00 2000.009.00 Thansk, 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: JS:URL Parameter in window.open
Try building your string first and then pass it to window.open() in a variable. - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 9:40 AM Subject: JS:URL Parameter in window.open does anyone know something like this will work: window.open('file.cfm?name=value', ... ) (does not seem to be working.) is there another easy way to control window size while passing a parameter in the URL??? TNX if you can help. Rick Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: syntax error when inserting date
Remember that date is a key word in sql and will produce undesired results if a field in a table is named date as in your code snippet. insert into class_schedule (classID, location, date) Try changing the field name to aDate or lastupdated or something. Bryan - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 3:06 PM Subject: RE: syntax error when inserting date Your problem is most likely due to the format of the date. If the data field in the database is of type 'Date' you would have to use CreateODBCDate(Form.Date) in order to change the text to an ODBC date format. Regards, Rob Rusher Spectra Architect, Certified ColdFusion Instructor + Developer, Certified Java Programmer email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] phone: 303-885-7044 plan, build and integrate interactive applications and e-business services to enhance knowledge sharing, e-commerce and business communications initiatives -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 8:02 AM To: CF-Talk Subject: syntax error when inserting date Hi all, My action template is supposed to insert classID, location and date into a table in my database. When creating new records in the form I provide, I want the user to be able to supply a comma delimited list of dates. I think the loop in the action template successfully extracts individual dates from the date list, but there is a syntax error in the insert command. Everything works if I don't try to insert the date, so that must be where the syntax error occurs. Can anybody tell me what my date syntax error is? Thanks in advance! Megan The action template code is shown below CFIF IsDefined(FORM.scheduleID) CFUPDATE DATASOURCE=calkayak TABLENAME=class_schedule CFELSE cfoutput cfset dategroup=form.date cfloop index=x from=1 to=#ListLen(dategroup)# cfset onedate=ListGetAt(dategroup,#x#) cfquery datasource=calkayak insert into class_schedule (classID, location, date) values(#form.classID#, '#form.location#', '#onedate#') /cfquery /cfloop /cfoutput /CFIF 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: Quick DB Design
go to Allaire devX and grab the securePack download. there is a custom tag in there that will create a DB structure for roll based community security. You can add as many groups as you want and the cf_addremoveuser tag will allow you add users and do group assignments on the fly. There is a management console that goes with the secure pack called security manager you can get that from my site for a fee, but the custom tags are free. Bryan LaPlante http://www.netwebapps.com - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 06, 2001 11:38 AM Subject: Quick DB Design I'm trying to normalize a table to best hold the following data: username, group1, group2, group3, group4... groupN... there are 1000s of unique usernames, and 1s of unique groups every user can subscribe to 1-1 diffrent groups (so I don't know how much group colums to put). I need somehow to maintain a list of subscribed groups for each user. is there a better way then 2 fields like the following: username (nvarchar(30) groups (longtext) = group1,group3,group15,group7,group9 ? 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: Object Oriented CFML
That's awesome man, I want to take some time and read about it. Do you have a design interface beyond the availability of the vtm editors? don't forget I have a free tool for creating vtm's on line at http://www.netwebapps.com/mytags/main.cfm Bryan LaPlante - Original Message - From: Craig Bowes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 2:30 PM Subject: Object Oriented CFML Ok, here is a little poll for you guys. How many of you are using SmartObjects and how many of you are using CFObjects? I know there's a ton of Fusebox people but I'm looking for the people using object oriented CFML. Tell me what you are using, if you like it, and for how long. Thanks! -Craig http://www.smart-objects.com/ http://www.cfobjects.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: Inexpensive Hosting
http://www.cfdeveloper.co.uk/ Free - Original Message - From: Guy McDowell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 8:52 AM Subject: Inexpensive Hosting G'day eh? I'm trying to find very inexpensive CF hosting to no avail. Something under $20 CDN is preferred. I need to host my personal/resume site along with some CF examples I have done. Thought I saw someone post something about hosting for $5.95 a month If there is nothing like that, then is it possible for me to institute CF Server Express within my own account/directory on a regular hosting package of the WinNT variety? Guy www.guymcdowell.com 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: Inexpensive Hosting
the cfdeveloper site is having technical difficulty this morning. I'll post a mail here when it comes back on line. - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 9:45 AM Subject: RE: Inexpensive Hosting try looking at www.cfdeveloper.co.uk HTH Mike -Original Message- From: Guy McDowell [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 3, 2001 14:52 To: CF-Talk Subject: Inexpensive Hosting G'day eh? I'm trying to find very inexpensive CF hosting to no avail. Something under $20 CDN is preferred. I need to host my personal/resume site along with some CF examples I have done. Thought I saw someone post something about hosting for $5.95 a month If there is nothing like that, then is it possible for me to institute CF Server Express within my own account/directory on a regular hosting package of the WinNT variety? Guy www.guymcdowell.com 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: Finding the last item in a loop
!--- start count outsite of loop --- cfset count = 1 cfloop query=qry_show_event_sponsors !--- check each iteration of the loop to see if count equals the total records --- #EventSponserName#cfif count is not qry_show_event_sponsors.RecordCount,/cfif !--- increment the count at the end of each loop --- cfset count = IncrementValue(count) /cfloop - Original Message - From: Chris Martin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 10:12 AM Subject: Finding the last item in a loop IS it possible to find the last item in a loop? Right now I have this: cfloop query=qry_show_event_sponsors #EventSponserName#, /cfloop Is it possible to check if the #EventSponsorName# is the last item in the record set, and then not display the comma? I.E. cfloop query=qry_show_event_sponsors #EventSponserName#cfif something,/cfif /cfloop Thanks in advance Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfexecute problems
If the program you are trying to communicate with was build to support the COM interface (probably a .dll) then you can use CFOBJECT. Look for the OleViewer on Microsoft's site it will show you the methods and properties of the program if you have no 3rd party documentation. If you are trying to talk to an exe, you might try using the outputfile property of CFEXECUTE to output the return value of the call to a txt file and then read it back into a variable on the page with cffile. Bryan - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 9:35 AM Subject: Re: cfexecute problems * Team Allaire * I don't think it's possible. CFEXECUTE does a single command line call. It doesn't 'hold' the connection open at all. For that you need something like COM (or the other CFOBJECT techs). Anyone know how to use cfexecute with a command line program that requires user input after the first line? That is, how do you tell cfexecute that you want to do the first bit, then simulate pressing return, then do the next bit, etc I've tried passing \n, \r, #chr(10)#, #chr(13) and even actually enclosing a real carriage return between quotes and it won't work. Any help would be great. TIA, Aaron Cooper, BSc Application Developer, Freeserve.com Plc The Observatory, 36-41 Clerkenwell Close, London EC1R OAU T: 0207 553 4992 M: 07799 191 589 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT - Good list for HTML questions
here is one. http://www.wdvl.com - Original Message - From: Perez, Bismark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 10:16 AM Subject: OT - Good list for HTML questions Hello there, Can somebody recommend a good list to ask HTML questions, I have this page which looks good under IE, but some how it looks terribly wrong under NS, or if there is a site that will shed light on how to do things so they'll be cross-browser... TIA Bismarck Perez ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Verity Indexing a Remote Server
Have you tried referring to the share as a drive like G:\Server\Path\To\My\Files where G is the drive letter assigned to the share. - Original Message - From: Bryan Batchelder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 8:11 AM Subject: Verity Indexing a Remote Server I am trying to create a verity collection that indexes a share on a remote server. (We have 2 front end clustered webservers, and a static data server - I am trying to index files on the static server, via a UNC path) I believe the systems are set up properly in regards to the user which the CF services are running as having proper permissions to the share. I can successfully create files on the remote server using CFFILE from the webservers using the same UNC path - so I would think that the verity indexer would be able to read those files. also of note is the fact that we currently use this file server to store our verity collections between servers - and that works fine. am I missing something? Here is the exact tag I use: cfindex action = refresh collection = somecollection key= \\Server\Path\To\My\Files type = path urlpath= ../images/mailings/ recurse= no Of course, when I change the key attribute to some local drive\directory (like D:\cf\is\ereet) it works just fine (and again, the collection datastructure itself is being stored on the static server) Also, when I try and use the CF Administrator to create the index, it gives me the same error. Am I forgetting something? Thanks in advance. Bryan Batchelder Web Application Developer ConnectWise, Inc. Phone: 813-935-7100 x 425 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT (maybe?): IIS5 CF authentication prob
That is the one that works for me is to go to the advanced user rights and set permission to log on to the server locally. Are you using IIS challenge response or any additional authentication? Bryan - Original Message - From: Cold Fusion [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 12:39 PM Subject: OT (maybe?): IIS5 CF authentication prob I'm having one of 'those days'... I just can't work this one out. It's probably more of an IIS issue than CF though, me thinks, but I've been looking so much I just can't see it anymore... so it's list help time... I'm just in the process of setting up a new (replacement) server. It's running Win2K SP1 (i.e. IIS 5.0) and CF Pro 4.5.1 SP2. The CF service logs in as LocalSystem. As things stand, the server has no problems spitting out anonymous CFM or plain old HTML files to browsers (anonymous access). That's cool, but I actually also to set up authenticated (by W2K) logins on the server to certain CFM pages (actually sub-folders containing CF apps) too. However, if I remove anonymous access to the site definition in IIS manager, or if I remove privs for the IUSR_ account from the relevant site folder, whilst I can then authenticate OK from a browser to access HTML files, accessing CFM files always bounces the authentication, finally settling on a 403 (ACL on resource) error. Here's the kicker: if I add the relevant W2K user account being used to the local 'administrators' group on the server, it then lets me in and the CFM pages load just fine. I though this might be related to 'administrators' by default having 'full control' on the site folder, but providing those privs to the relevant user (or their group) directly, even all the way up/down/across/inside/all over the directory tree, has no apparent effect. I can't see what 'administrators' has permission to that others don't... I'm assuming user policy details ('log-on locally' etc) are OK because authenticating HTML works OK. CFUSION/BIN has 'read/execute' for everyone set... So: what on earth did I miss and/or screw up??! Anyone any suggestions where to look? I get the feeling it's probably something simple I've missed though... ;-) SB ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Hosting Service Provider Edition Eliminated
Jim, What you asked for in the second paragraph is here, http://webteem.cf-developer.net/remotedev2001.cfm login as password The online docs are here. http://www.netwebapps.com/Accounts/index.cfm - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, April 29, 2001 9:04 PM Subject: Re: Hosting Service Provider Edition Eliminated Jeff, I'm very happy to see that Macromedia listens to its customers. Thank you. I haven't had the opportunity to check out CF 5 yet, so I don't know what features are planned for the Professional and Enterprise versions. As a very small web host, with maybe 30 domains, one thing that _did_ peak my curiosity was what features would be planned for a Service Provider Edition. I think someone was badly misinformed when they drew up the licensing and pricing for this product, but if indeed there is added value to someone doing shared hosting of CF server, there may well be a place for it. It's obviously too late to suggest significant changes for the CF 5 release, but I had wondered if we'd see some nice site-level management features, including some end-user domain management capabilities. Depending on the power of the management and security features bundled into this product, I could see an appropriate price somewhere between Pro and Enterprise, perhaps the cost of Pro plus 20-30%. Right now, the financial incentive for web hosts is still to use CF Pro over Enterprise for shared hosting. I hope to at least see some of the sand-box security features migrated into Pro, so that it IS a good fit for this environemant, and one that will further the stability and reputation of using CF for small sites. Jim -Original Message- From: Jeff Whatcott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Sunday, April 29, 2001 4:59 PM Subject: Hosting Service Provider Edition Eliminated Based on valued feedback from the community, we have changed our licensing plans for shared server hosting with ColdFusion Server 5. Here's what you need to know: 1. We do not plan to offer a Hosting Service Provider Edition of ColdFusion Server 5 at this time 2. We plan to license the Professional and Enterprise editions of ColdFusion Server 5 in a way that allows you to provide shared server hosting services 3. We plan to introduce the Professional and Enterprise editions of ColdFusion Server 5 with the same pricing as the 4.5 release The broad availability of high quality, affordable ColdFusion hosting services is important to the continued growth and success of the ColdFusion community. We recognize the role of our partners in making this happen, and we encourage partners who offer hosting services to participate our hosting partner programs, including the Hosting Certification Program. Your involvement will help us better meet your needs in the future. One of the most exciting things about the ColdFusion Server 5 release is that it was conceived based on suggestions and feedback from the ColdFusion developer community. We rely on your continued involvement. Keep it coming. If you have any questions, concerns, or suggestions regarding the ColdFusion business, including licensing and pricing issues, feel free to email me anytime. And as you start using ColdFusion Server 5 in the months ahead, be sure to send your ideas for new features and functionality to [EMAIL PROTECTED] Thanks, Jeff Whatcott Director, ColdFusion Product Marketing / Macromedia [EMAIL PROTECTED] 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: New CF5 Partner Hosting License
About a year ago I was really frustrated with the hassles of managing clients web sites that my company had developed applications for. Most end users are not permitted to connect to their host providers RDS, rather they have the FTP flavor of managing there files. Some ISP's have control panels so you can at least manage the datasources but control panels for CF are far an few between. Sounds like there will be added support for the hosting environment in CF 5 but maybe the license will be prohibitive to the smaller ISP's. What I did a year ago to alleviate this problem was build a tool that the ISP of my client could install for free and then I would give my client a free license to abort the 30 day trial. I can manage the clients datasources, verity, advanced security, log files and edit cfm templates right online. There are a multitude of articles on query best practices and the custom tag model thus far is a pretty fair method of creating reusable code. I guess for now with the tools that I use I will be ok with not upgrading to CF 5. It will be interesting to see the outcome of this in the future. Bryan LaPlante Network Web Applications Inc. http://www.netwebapps.com - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, April 28, 2001 10:40 AM Subject: RE: New CF5 Partner Hosting License Steve, Excellent points. Might I also add that some of us ISPs are actually web development shops and hosting companies as well. In our web development shop, some of our designers are just getting into application development. And these guys are fast learners. I have pointed them towards CF because it is a good RAD environment for them to learn in. They have already built some pretty impressive CF apps running on SQL. But when we give a quote for a web development job, we factor in the CF work, the CF License, as well as the increase in hosting that a CF site will cause. In many cases, our larger clients opt for a dedicated server. Since the bottom fell out of the PC server market, it is not unheard of to build a CF server that costs $1500 that will run Win2K, SQL Server, and CF all on the same box. This actually works pretty well for a small application, and we are doing this now. But add up the software cost: CF Pro: $1200 M$ SQL Server (only 5 licenses): $1400 Win2K: $600 (ASP Included Free) As much as I hate a command line interface, Linux, PHP and MySQL are starting to look attractive. Especially for these smaller sites that need their own box for security, whatever. I agree with you Steve, MM should drop the price on CF Server to gain market share. Market share is important. And for god's sake if you are going to try to get more revenue from hosting companies, then at least provide tools to make managing the security of the sites easier. IMHO the sandbox feature should be standard across the board. Maybe they should merge Enterprise and Professional editions to accomplish this. 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 -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:46 PM To: CF-Talk Subject: RE: New CF5 Partner Hosting License We have already been told by Allaire sales reps that there will substantial price increases for hosting companies with hundreds or thousands of domains/applications and that if we need licenses, the time to buy is now. This is from your own sales folks. Allaire has a well established history of announcing a fire sale on the current partner membership before a major price increase. This is a way to try and keep the partners from screaming too loud when the price change comes in and to generate a short spike in partner revenue before that program price is also increased. I would love to be surprised by a price decrease across the board for CF server licenses, but your own sales folks are telling us to buy now before the price goes up. Last time during the beta cycle we were promised sand boxing and other features that would make large scale hosting, ApSP, and shared hosting systems more secure. Then at the last moment, sand boxing and the other security enhancements were moved into a new version of software called CF Enterprise which was not covered by existing maintenance contracts for Pro. So folks had to scramble for new license agreements and when they did, they found that the price of CF went up with a five fold increase to some $5,000. Hence why many hosting companies are still with 4.0 and didn't upgrade to 4.5. Now taking a page from Microsoft's successful price increase of SQL Server to processor based and connection based licensing, McAllaire is looking to do the same thing. We have already heard from MM in past conference calls
caller scope
Going nuts friends, I could swear that I have used this syntax in the past, but I can not get it to work now. In custom tag getResult.cfm there is a query that uses the caller scope to make the query result set available to the calling page. cfquery name=caller.qry. select * from someTable /cfquery In the calling page I output cfoutput query=qry /cfoutput Error message says that the value of the output tag does not refer to the name of an available query. I also tried to cfset caller.qry = qry setting the name value for cfquery name=qry and that fails too. Any idea's. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: caller scope
that is exactly what I am doing except the caller.qry is hard coded in the custom tag. I got it to work except it returns a recordset of 0 now. - Original Message - From: DeVoil, Nick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 8:54 AM Subject: RE: caller scope Bryan I do it this way Calling page: cf_getResult queryname=qry cfoutput query=qry /cfoutput Tag: cfquery name=thisQuery. select * from someTable /cfquery cfset Caller.#Attributes.queryname# = thisQuery This uses one more assignment than strictly necessary, but it just seems neater that way. Nick -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 2:16 PM To: CF-Talk Subject: caller scope Going nuts friends, I could swear that I have used this syntax in the past, but I can not get it to work now. In custom tag getResult.cfm there is a query that uses the caller scope to make the query result set available to the calling page. cfquery name=caller.qry. select * from someTable /cfquery In the calling page I output cfoutput query=qry /cfoutput Error message says that the value of the output tag does not refer to the name of an available query. I also tried to cfset caller.qry = qry setting the name value for cfquery name=qry and that fails too. Any idea's. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: caller scope
I am feeling just a little bit stupid here, but as a good list participant I will fess up. The original code would have worked fine and if I had posted it verbatim you all might have beaten the life out of me. Thanks for not doing that!! Problem with cf_getResult was I forgot I had set this default at the top of the custom tag page. CFPARAM NAME=ATTRIBUTES.ID DEFAULT=0 Thus the query below was only being truthful, even though I did not pass ID= in the custom tag it was getting set by the default for attributes.id. cfquery name=Caller.qry datasource=#DATASOURCE# dbtype=ODBC Select * from someTable CFIF IsDefined(Attributes.ID) where tableID = #Attributes.ID# /CFIF /cfquery MAN I hate when I do that! - Original Message - From: DeVoil, Nick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 8:54 AM Subject: RE: caller scope Bryan I do it this way Calling page: cf_getResult queryname=qry cfoutput query=qry /cfoutput Tag: cfquery name=thisQuery. select * from someTable /cfquery cfset Caller.#Attributes.queryname# = thisQuery This uses one more assignment than strictly necessary, but it just seems neater that way. Nick -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 2:16 PM To: CF-Talk Subject: caller scope Going nuts friends, I could swear that I have used this syntax in the past, but I can not get it to work now. In custom tag getResult.cfm there is a query that uses the caller scope to make the query result set available to the calling page. cfquery name=caller.qry. select * from someTable /cfquery In the calling page I output cfoutput query=qry /cfoutput Error message says that the value of the output tag does not refer to the name of an available query. I also tried to cfset caller.qry = qry setting the name value for cfquery name=qry and that fails too. Any idea's. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Validate a string for a valid directory name?
try cfif directoryExists(path/to/directory/) code /cfif - Original Message - From: river [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 12:48 PM Subject: Validate a string for a valid directory name? What's the best way to validate a string for a valid directory name? I am trying to create a form that creates a folder with the name that's specified in the form. Entering a text MyDocument in a textbox and hitting Submit creates a folder with the name MyDocument. I need to check this string for the valid folder/directory name under Windows NT. What would be the best way of doing it? Is there a custom tag? Thank you for any help. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: get the directory a file is in.
I think it is getDirectoryFromPath(script_name) if you use script_name it will return the current directory otherwise just use the c:\wwwroot\1234\index.cfm approach. - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 10:04 PM Subject: Re: get the directory a file is in. ExpandPath('relativepath/filebeingrun.cfm') Is there a way to get the name of the directory a file that is being processed is in? Let's say, in a file C:\wwwroot\1234\index.cfm is there a way to retrieve C:\wwwroot\1234\ part in the index.cfm file? Thanks for any help. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: populating the query result to IFRAME
Not sure if this is what you mean, but try this. eval(document. + secNum + .style.display = ''; don't forget to alternate your single and double quotes. - Original Message - From: paul . [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 10:12 AM Subject: populating the query result to IFRAME HI Guys am trying to populate the query result to the IRAME , so that i can give the user to view result in the same page please check my code and suggest me. the seeror i get is style is not an object thanks -paul . Below is my code --- p align=centerfont face=Arial, Helvetica, sans-serif size=4bi Training/i/b/font/p cfif qry_get_events.recordcount gt 0 script language =javascript function doSection(secNum) { /* if(secNum.style.display == none) {secNum.style.display = ; } else {secNum.style.display = none; } */ secNum.style.display = ; } function noSection (secNum) { if(secNum.style.display == ) {secNum.style.display = none;} } /script table border=1 cellspacing=0 cellpadding=6 bordercolor=#00 align=center width=750 tr valign=top td bgcolor=#66font color=#FF size=2bfont face=Arial, Helvetica, sans-serifCourse Name /font/b/font/td td bgcolor=#66 align=centerfont color=#FF size=2bfont face=Arial, Helvetica, sans-serifScheduled Date /font/b/font/td td bgcolor=#66 align=centerfont color=#FF size=2bfont face=Arial, Helvetica, sans-serifOccurance Date /font/b/font/td td bgcolor=#66 align=centerfont color=#FF size=2bfont face=Arial, Helvetica, sans-serifNon-Participants/font/b/font/td td bgcolor=#66 align=centernbsp;/td /tr cfoutput query=qry_get_events cfif year(completion_date) eq 1001 cfset current_completion_date=Not completed yet cfelse cfset current_completion_date=#dateformat(completion_date, dd )# /cfif cfif year(training_date) eq 1001 cfset current_training_date=Not scheduled yet cfelse cfset current_training_date=#dateformat(training_date, dd )# /cfif tr valign=top bgcolor=##FF tdfont size=1 face=Arial, Helvetica, sans-serif cfif qry_get_training_courses.recordcount gt 1 cfloop index=loopcount from=1 to=#qry_get_training_courses.recordcount# cfif training_crse_idx eq qry_get_training_courses.rec_id[loopcount] #qry_get_training_courses.session_name[loopcount]# /cfif /cfloop /cfif /font/td td align=centerfont face=Arial, Helvetica, sans-serif size=1#current_training_date#/font/td td align=centerfont face=Arial, Helvetica, sans-serif size=1#current_completion_date#/font/td td align=centerfont face=Arial, Helvetica, sans-serif size=1a href=index.cfm?fuseaction=event_nonparticipants_vamp;event_idx=#rec_id#am p;traini ng_course_idx=#training_crse_idx#Non-participants/a/font/td td align=centerfont face=Arial, Helvetica, sans-serif size=1a class=anchorclass href=javascript:doSection(thesection)participants/a/font/td /tr a name = test input name=quarter_idx type=hidden value=#attributes.quarter_idx# div id =thesection onClick = noSection(thesection) STYLE=display:none iframe SRC=http://10.158.20.123/careadv/test/index.cfm?fuseaction=event_participan ts_vevent_idx=3training_course_idx=645 WIDTH=800 HEIGHT=200 /iframebr/br/ center a href=javascript:noSection(thesection) Close/a /center /div /a /cfoutput /table /cfif cfoutputinput name=quarter_idx type=hidden value=#attributes.quarter_idx#/cfoutput -- Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RSVP reminder
Just a quick reminder. If you haven't already registered for the Ben Forta meeting this Wednesday in Kansas City, go to http://www.kcfusion.org/ and RSVP for the meeting. All of the information for the meeting is there. Thanks Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Oh that's just great.
dude, go and get cf_avartree, it rocks - Original Message - From: Erika L Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 1:56 PM Subject: Oh that's just great. I just downloaded a tag from the Tag Gallery called CF_Debugthat I wanted to throw up on one of my hosted sites so that I could get some quick debugging info... Of course I unzipped it and it doesn't contain the Debugging tag, it's got some silly find and replace JS function. HELP! Does anybody out there have a debugging tag? Or let me know what the quick method is of outputting all the wonderful things we see at the bottom of the pages when we have debugging turned on? *** mumbles to herself, while she goes and loads up on caffeine laced with arsenic that may put her out of her misery. Erika You can talk a great philosophy, but if you can't be kind to people everyday then it doesn't mean that much to me. - unknown ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL INSERTS - return ID
select max(id) as maxID from tablename - Original Message - From: Matt Eschenbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 6:36 PM Subject: SQL INSERTS - return ID Anyone know a trick to return the ID of a record just Inserted into a table? Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.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: CFTRY / CFCATCH questions
There are no requirements on the order of cfcatch statements that I'm aware of. - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 6:45 PM Subject: CFTRY / CFCATCH questions I know that at least one CFCATCH must be put inside a CFTRY block. How picky is CF on the order of the tags, though? for example: CFTRY Some code CFCATCH type=Database /CFCATCH CFCATCH type=object /CFCATCH CFCATCH type=all /CFCATCH /CFTRY First off, can you use an 'all' catch with other specialized catches defined? Would a database exception catch at 'all' or would it catch at 'database'? If I changed the code around to look like this: CFTRY Some code CFCATCH type=all /CFCATCH CFCATCH type=Database /CFCATCH CFCATCH type=object /CFCATCH /CFTRY Then, where would a database exception catch? At 'all' or at 'database'? If I put the code after the CFCATCHs, would an error catch? Like this: CFTRY CFCATCH type=Database /CFCATCH CFCATCH type=object /CFCATCH CFCATCH type=all /CFCATCH Some code /CFTRY Thoughts, comments? Much thanks! Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out June 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: value of field not appear
try cfoutput input type=image name=imageName src=#getdosen.image# /cfoutput - Original Message - From: Haryono ... [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 9:04 PM Subject: value of field not appear Hallo, Source code: cfoutput input type=file name=image value=#getdosen.image# /cfoutput When i excute source code above in browser, value of field image is not appear. why? If I use: cfoutput #getdosen.image# /cfoutput value of getdosen.image is appear can you help me? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: New File Extension....
go to your IIS management console in NT4 it's under the option pack menu and W2k it's in the computer manager. Right click on the web site in question and go to properties and them to the home directory tab. Click on configure and you will see the extensions in there. Bryan - Original Message - From: "Neil Clark" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 20, 2001 9:22 AM Subject: New File Extension Anyone know how to set up their Web server (in this case IIS 4 and 5) to accept any file with the extension .xxx and then pass it to the CF server for processing as if it was anyother .cfm file? I have had a few replies from good sources from other sources indication that this is easy, but I am unsure on how to go about it; any one give me the instructions for a test? Neil !- Neil Clark Senior Web Applications Engineer Spectra / CF / XML MCB Digital Premier Allaire [Macromedia] Partner Tel: 020 8941 3232 Fax: 020 8941 4333 e-mail: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT Javascript question
In IE4 and up event.keyCode(13) is the enter key - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 20, 2001 12:45 PM Subject: Re: OT Javascript question i know there is in NS but i'm not sure about IE in NS you can enable event capturing and inherent to that is the type of event. i.e., a key stroke and the key depressed see developer.netscape.com for more on this script document.captureEvents(ONKEYPRESS); function myHandler(e){ //where e is the event type return e.type; } document.onkeypress=myHandler; /script ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SecurePack
If anyone downloaded the SecurePack from the Allaire DevX, I just realized that I did not include the file to auto create the security database, I only put in the tag editor for it. Sorry about that. The updated files should show up in the morning on Allaires site. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: HTML editor for idiots? recommendation?
Try Dreamweaver, if you can walk them through using it, the wysiwyg editor is a lot more code friendly than M$ - Original Message - From: "Peter Theobald" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 9:09 AM Subject: OT: HTML editor for idiots? recommendation? Sorry for the OT post... I have a client who needs to be able to make simple text changes to static HTML pages. I tried having him use FrontPage but he managed to destroy the entire site, which I had to restore from backups. Can someone recommend an HTML editor that will simply download ONE page, allow SIMPLE editing of text, and upload THAT page. Something that my grandmother could use (hint: she wonders why she never has to put new ice in her "icebox"). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFML not being executed
Couple of things to look for. Forgive me I am not sitting at my W2k machine but you need to go to computer manager and find the IIS manager. Right click on the default web site or the site in question and go to the home directory tab. Look at application settings and see if you have an entry for the name called default application. Click on the configure button and go to the add mappings tab. Look an see if you have an entry for .cfm pointed to c:\CFUSION\bin\iscf.dll or where ever you have cf installed. If you don't see all of this go back to the home directory and click on create to enable a default application for IIS to send script requests to. Start there and see if that fixes ya. Bryan - Original Message - From: "Duane Boudreau" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 12:24 PM Subject: CFML not being executed Just had a box put together with Win2k, IIS, CF 4.5.1 sp2 and for some reason it is not executing the CFML code. When I view the source the CFML code is still in the contained in the returned html. I've tried everything even reinstalling both CF and the OS. I checked the ISAPI filters, execute, everything I can think of, but nothing works. Any ideas TIA, Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Netscape equivalent of iframe
M$ is the only browser that will display a ppt in the browser, that I'm aware of. - Original Message - From: "Rosa, Issac" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 3:48 PM Subject: RE: Netscape equivalent of iframe I tried ilayer in the following code, but I get an NS error - "Alert! did not find a converter or decoder. ilayer id="myLayer" src="documents/powerpoint/mop_mission_stmt.ppt" height="480" width="600"ilayer Thank you, Issac Rosa IT - National Sales Marketing OLAP Specialist Team Lead Ofc: 407-658-3111 Cell: 407-342-0644 Fax: 407-971-2374 [EMAIL PROTECTED] -Original Message- From: JLB [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 2:25 PM To: CF-Talk Subject: RE: Netscape equivalent of iframe layer and Ilayer are the closest tags. But they are not nearly as easy to work with as iframes. -Original Message- From: Rosa, Issac [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:31 PM To: CF-Talk Subject: Netscape equivalent of iframe Does anyone know of an equivalent in Netscape to the IE tag iframe. NS6 supports the tag, but we are currently using NS4 as corp standard. I need to embed documents(.doc, .ppt, .xls, .pdf) that automatically load when the page loads. Any help or suggestions would be greatly appreciated. Thank you, Issac Rosa IT - National Sales Marketing OLAP Specialist Team Lead Ofc: 407-658-3111 Cell: 407-342-0644 Fax: 407-971-2374 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: input type='file'
I have a question about your script. Assuming the input looks like so form name="foo" input type="file" name="bar" /form does your script refer to the input as document.foo.bar.value; If so how did you work around the access denied js error that the browser gives me when I try this? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:25 AM Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: input type='file'
I've never gotten that to work for me. It always complains about object required or access denied when I refer to a client side file upload. It is my understanding that JavaScript can not access the content of the input type due to security issues. I will have to try your method. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:26 AM Subject: Re: input type='file' form action="something.cfm" method="post" enctype="multipart/form-data" name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);" this is the form heading. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:44 AM Subject: Re: input type='file' I have a question about your script. Assuming the input looks like so form name="foo" input type="file" name="bar" /form does your script refer to the input as document.foo.bar.value; If so how did you work around the access denied js error that the browser gives me when I try this? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:25 AM Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: input type='file'
dude, you are a genius. I have never gotten that to work. My hat is off to ya. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:53 AM Subject: Re: input type='file' just keep in mind that the form must come AFTER the script. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:36 AM Subject: Re: input type='file' I've never gotten that to work for me. It always complains about object required or access denied when I refer to a client side file upload. It is my understanding that JavaScript can not access the content of the input type due to security issues. I will have to try your method. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:26 AM Subject: Re: input type='file' form action="something.cfm" method="post" enctype="multipart/form-data" name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);" this is the form heading. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:44 AM Subject: Re: input type='file' I have a question about your script. Assuming the input looks like so form name="foo" input type="file" name="bar" /form does your script refer to the input as document.foo.bar.value; If so how did you work around the access denied js error that the browser gives me when I try this? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:25 AM Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CSS
input type="text" style="border:1px solid blue;" - Original Message - From: "Neil H." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 7:54 AM Subject: CSS I want to make "flat" select boxes, radio buttons, and checkboxes. What I mean is no shadow and a 1px border of a color. Anyone have any ideas? The browser for this app is always IE 5.x Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: ZIPPING with coldfusion
This one works great, http://www.forta.com/cf/tags/ I use it for my Custom tag wizard http://www.netwebapps.com/mytags/main.cfm - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:42 AM Subject: ZIPPING with coldfusion Could someone point to a good program/object I can use to easily zip a couple of 100s .txt files using CFEXCUTE or CFOBJECT? (Not in Developer's Exchange..) Thanks, Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: escaping ' in SQL
#PreserveSingleQuotes(string)# - Original Message - From: "Gil Barden" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 12:09 PM Subject: escaping ' in SQL Hi everyone, I have a question about how to pass an SQL statement through a text area box in a form while protecting the SQL statement. Below I have a self-submitting form, that passes the dynamic text through the text-area box and then passes to a query that is to be then displayed. Problem is, that the SQL gets re-parsed when I use the " ' " single tick for a string to a " " " double tick. I have tried htmlcodeFormat() and htmleditformat() with no success. The error I recieve is: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near 'n'. SQL = "select * from d_school_names where charter_school = ''n''" Here is my code: html head /head body bgcolor="#C0C0C0" cfif isdefined("form.submit") !--- Dynamice Query --- !--- cftry --- cfquery name="dynQuery" datasource="xxx" username="" password="" #form.sql# /cfquery !--- Outputting query --- cfset columns = ListtoArray(#dynQuery.ColumnList#) cfset numColumns = arraylen(#columns#) table border="1" cellpadding="1" cellspacing="1" thCurrent Row/th cfloop index="i" from="1" to="#numColumns#" cfoutputth#columns[i]#/th/cfoutput /cfloop cfloop query="dynQuery" tr td cfoutput#dynQuery.currentRow#/cfoutput /td cfloop index="i" from="1" to="#numColumns#" td cfoutput cfif evaluate(columns[i]) EQ "" nbsp; cfelse #evaluate(columns[i])# /cfif /cfoutput /td /cfloop /tr /cfloop /table !--- cfcatch type="Database" You have caused a database error! Please hit your back button and try again. /cfcatch !--- Catching any type of error. --- cfcatch type="Any" You have caused a database error! Please hit your back button and try again. /cfcatch /cftry --- !--- First time through form --- cfelse h3 Please Enter a SQL Statement below/h3 form action="#cgi.script_name#?#cgi.Query_String#" method="post" textarea cols="50" rows="5" name="SQL" /textarea br input type="Submit" name="submit" /form /cfif /body /html Gil Barden ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: ENcoding URL
no without useing a form post - Original Message - From: "Pooh Bear" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:37 PM Subject: ENcoding URL hey yall, is there a way to hide the values in the URL so people can't see them? like I am passing URL variables, like Something=4This=Hiyah is there a way to hide the values or display them differently ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ben Forta in KC
Hello everyone, I posted this the other day and I don't think I ever saw it come through, so here it is again. Ben Forta is coming to Kansas City to speak to our CFUG. go to http://www.kcfusion.org/ for details and RSVP for the meeting so we will know how many are coming. This event is sponsored by: Allaire/Macromedia GreenSoft Solutions, Inc. Network Web Applications, Inc. Human Kind Systems, Inc. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Creating Page Breaks to make page printable?
http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/pageBre akAfter.asp - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 6:20 PM Subject: Re: Creating Page Breaks to make page printable? Does anyone know of a way to force printing breaks of a document? You can do this with style sheets. -- This message sent compliments of db Technology http://www.dbtech.net/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Image / File Security
not sure how your pages are set up but we server our images dynamically so that if you were to just copy the url from the img tag on the site you would get a page that gets the image for you. That will allow you to do auth on users that attempt to obtain resources. If you need a solution for CF like advanced security that will run in a clustered environment check the one out at http://www.netwebapps.com/products/securityManager/introduction.cfm the custom tags it uses for authentication and authorization are free. Bryan - Original Message - From: "Jason" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 15, 2001 3:52 PM Subject: Image / File Security I am looking for suggestions on ways to incorporate protection of my files /images from deep linking. I currently log users in and verify them on a DB with CF however that doesn't stop them from linking back to a file at a later date. I can't really use advanced security because the Image server is on a different machine and the web servers are on another cluster. I also don't want to use NT challenge response because I would force the user to log in twice. I have seen some examples by people using Apache that use the ..htacess method (to verify refering URLor something of that nature) but since I am using IIS 5.0 this doesnt work for me. Anyone currently have a good way to do this? 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