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: Pro Bono Forms - URL
Darien, I'm a little behind on the lists I'm afraid - you still need the help? I'm between contracts at the moment, so if you do, please give me a yell and I'll knock up the forms you need. regards, Toby At 11:21 AM 8/8/2001, you wrote: This in in regards to the Pro Bono form help request. Sorry, forgot to include the URL. Site is 90% complete. http://209.25.246.197/ The site registration is going through now: www.4rkids.ws I will provide server access to a server with CF. The time frame is next Monday. I'm swamped with three commercial projects due in the next four days. This site has taken a lot of time, and I was hoping to have had it complete already. Darien Small Technical Information Officer iExpediter [EMAIL PROTECTED] - Original Message - From: CF-Talk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 6:36 AM Subject: CF-Talk-list V1 #82 CF-Talk-list Tue, 7 Aug 2001Volume 1 : Number 82 In this issue: RE: Locked Database Re: Locked Database Re: CF 5.0 Enterprise Server install problems Subject: RE: I dont understand session locking :( RE: Locked Database Lock the database? RE: Lock the database? Re: Locked Database RE: Locked Database RE: Lock the database? RE: Downloading Files via CFContent Subtract Null = Error Re: Subtract Null = Error RE: Subtract Null = Error RE: Subtract Null = Error Urgent ! CFHTTP Connection Failed RE: Urgent ! CFHTTP Connection Failed RE: Urgent ! CFHTTP Connection Failed ColdFusion Memory Leak RE: Cybersource RE: How can I insert a new record with no values? RE: Urgent ! CFHTTP Connection Failed RE: Urgent ! CFHTTP Connection Failed RE: Urgent ! CFHTTP Connection Failed Structure on Application Scope RE: embedding a MIME image to an email - HELP URGENTLY! Re: Structure on Application Scope RE: Urgent ! CFHTTP Connection Failed -- Date: Mon, 06 Aug 2001 19:41:00 -0700 From: Jay Sudowski - Handy Networks LLC [EMAIL PROTECTED] Subject: RE: Locked Database Message-ID: [EMAIL PROTECTED] Hi - Usually sending a bad query to the data source will break the lock. You can also set disable database connections in the CF Administrator. If you disable db connections, make sure you enable them again, otherwise your site won't work :-) Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: CFHelp [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 10:12 PM To: CF-Talk Subject: Locked Database Is there some code I can put into a page to unlock an access database? Rick Eidson Owner http://www.kchost.net/ KChost is getting ready to launch it's enews service Now you can moderate your own affordable newsletter Promote you products and services even sell advertising. Plans start at $5 a month for 500 emails. FREE Trial account. ~~ 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: getting values out of numbered form fields
Look at the Evaluate function -- e.g cfset strSQL = strSQL ID = Evaluate(PrintID#pos#) or - Original Message - From: Michael Wolter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 4:04 PM Subject: getting values out of numbered form fields I have a set of forms that allow the user to search a database, display matching records and then lets the user select specific records to print. The search displays matches in a form with check boxes for each record. So I need to loop through these numbered form fields, but I don't know how many there might be. The code I have is: cfloop condition=isdefined(chkPrint#pos#) cfset strSQL = strSQL ID = PrintID#pos# or cfset pos = pos + 1 /cfloop The part where I am checking for the existence of the field seems to work, but I can't figure out how to pull in the values from these fields and add them to my string. Thanks in advance for any insights. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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
Re: CFsetting through a loop - brainfart
Could you use a cfparam to default a value, just in case the user did not answer the question? e.g cfparam name=level#i# value= Then CF will have a value if it is not defined.. Tim P. - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 4:33 PM Subject: CFsetting through a loop - brainfart Hi - this has got to be an easy fix. I've got a dynamic form sending a dynamic amount of fields to a Query. The form fields Level#i# are radio buttons. Here's the code: cfloop index=i from=1 to=#x# cfset thisskillid = Evaluate(Skillidi) cfset thislevel = Evaluate(level i) cfset thisempid = #empid# cfquery name=getanswer datasource=personnel SELECT empid, skillid FROM tblMatrix WHERE empid=#thisempid# and skillid=#thisskillid# /cfquery cfif #getanswer.recordcount# is 0 cfquery name=insertrow datasource=personnel INSERT INTO tblMatrix (empid, skillid, skilllevel) VALUES (#empid#, #thisskillid#, #thislevel#) /cfquery cfelse cfquery name=updaterow datasource=personnel UPDATE tblMatrix SET skilllevel=#thislevel# WHERE empid=#thisempid# AND skillid=#thisskillid# /cfquery /cfif /cfloop The problem is that if the the user doesn't answer that particular question, say they don't answer the first question - then this is the error: An error occurred while evaluating the expression: thislevel = Evaluate(level i) Error near line 12, column 8. -- -- An error has occurred while processing the expression: level1 Error near line 1, column 1. -- -- Error resolving parameter LEVEL1 Okay, so how do I cfset Level#i# = ?? That snippet gives me an Invalid Parser Construct error, pointing to the first #. This has to be easy... its not coming to me and I've wasted far too much time on this little bit of code. Thanks in advance, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ 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
Oracle Stored Procedures
Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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: Oracle Stored Procedures
I dont believe you can use output parameters with Oracle I may be wrong? Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clint Tredway Sent: 09 August 2001 13:32 To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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: CFsetting through a loop - brainfart
Or use a CFINPUT on the form and make it a required field. Greg - Original Message - From: Tim Painter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 6:15 AM Subject: Re: CFsetting through a loop - brainfart Could you use a cfparam to default a value, just in case the user did not answer the question? e.g cfparam name=level#i# value= Then CF will have a value if it is not defined.. Tim P. - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 4:33 PM Subject: CFsetting through a loop - brainfart Hi - this has got to be an easy fix. I've got a dynamic form sending a dynamic amount of fields to a Query. The form fields Level#i# are radio buttons. Here's the code: cfloop index=i from=1 to=#x# cfset thisskillid = Evaluate(Skillidi) cfset thislevel = Evaluate(level i) cfset thisempid = #empid# cfquery name=getanswer datasource=personnel SELECT empid, skillid FROM tblMatrix WHERE empid=#thisempid# and skillid=#thisskillid# /cfquery cfif #getanswer.recordcount# is 0 cfquery name=insertrow datasource=personnel INSERT INTO tblMatrix (empid, skillid, skilllevel) VALUES (#empid#, #thisskillid#, #thislevel#) /cfquery cfelse cfquery name=updaterow datasource=personnel UPDATE tblMatrix SET skilllevel=#thislevel# WHERE empid=#thisempid# AND skillid=#thisskillid# /cfquery /cfif /cfloop The problem is that if the the user doesn't answer that particular question, say they don't answer the first question - then this is the error: An error occurred while evaluating the expression: thislevel = Evaluate(level i) Error near line 12, column 8. -- -- An error has occurred while processing the expression: level1 Error near line 1, column 1. -- -- Error resolving parameter LEVEL1 Okay, so how do I cfset Level#i# = ?? That snippet gives me an Invalid Parser Construct error, pointing to the first #. This has to be easy... its not coming to me and I've wasted far too much time on this little bit of code. Thanks in advance, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ 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: Oracle Stored Procedures
There is another stored procedure that is returning a one record result set... I am trying to get a procedure to return more than one record.. -- Original Message -- from: Alex Skinner [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 09 Aug 2001 13:38:28 +0100 I dont believe you can use output parameters with Oracle I may be wrong? Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clint Tredway Sent: 09 August 2001 13:32 To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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
CF and Verity Information Server
Anyone have any experience using a Verity server EXTERNAL to the CF Server? Running the Verity included with CF5 is hitting the server's performance too much so we set up a second server running Verity Information Server 3.7. But I haven't the foggiest idea where to begin telling CF5 to use that external server for search processing, etc. Can anyone point me to any documentation on this? Thanks -J ~~ 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
Lost CF Administrator Password
A few days ago, there were posts telling how to go into the registry and reset the CF Administrator password. I can't find it in the archives. Can someone tell me were in the registry to reset the Adminstrator password? CF 5 on Win2K. Our system administrator installed CF 5 a few days ago, but has misplaced the password. (and NO - it wasn't me . . . . LOL) Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ 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: Oracle Stored Procedures
Here's an example of a call I use to an Oracle stored procedure (creates a session id). This particular example uses strings instead of numeric, but you get the idea. This is just to give you the correct syntax. Instead of using cfprocresult, you have to use cfprocparam type=out for Oracle. CFSTOREDPROC PROCEDURE=OUR_SCHEMA.APP_SECURITY.CREATE_SESSION DATASOURCE=#Variables.ProdDSN# CFPROCRESULT NAME = SessID CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#uCase(form.userid)# CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#form.password# CFPROCPARAM TYPE=OUT CFSQLTYPE=CF_SQL_VARCHAR VARIABLE=SESSID /cfstoredproc Original Message Follows From: Alex Skinner [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Oracle Stored Procedures Date: Thu, 09 Aug 2001 13:38:28 +0100 I dont believe you can use output parameters with Oracle I may be wrong? Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clint Tredway Sent: 09 August 2001 13:32 To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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
Fw: Lost CF Administrator Password
Ahh - I just found it in the archives after all. http://www.mail-archive.com/cf-talk@houseoffusion.com/msg05663.html Thanks, Dave - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 8:55 AM Subject: Lost CF Administrator Password A few days ago, there were posts telling how to go into the registry and reset the CF Administrator password. I can't find it in the archives. Can someone tell me were in the registry to reset the Adminstrator password? CF 5 on Win2K. Our system administrator installed CF 5 a few days ago, but has misplaced the password. (and NO - it wasn't me . . . . LOL) Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ 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: FuseBox
I am almost done coding a site (more or less) using Fusebox. My $.02: The Good: - The naming conventions are good to use; it is good to have each app in its own folder. - You should always focus on code reuse, and FB helps. The Bad: - For small teams (I work alone), strictly following the fusedocs and some of the more specific rules is sort of silly. You always should keep in mind that some other poor shmuck might inherit your code, so it should be well documented none the less. The Bottom Line: - The rules are meant to be broken or bent to fit your situation anyway, so it is a good enough system. The most important thing is to have a methodology in the first place. --- Ben Morris Web Site Developer American Federation of Government Employees, AFL-CIO (202) 639-6448 http://www.afge.org Gonzo Rock [EMAIL PROTECTED] 08/08/01 05:31PM I want to solicit opinions on FuseBox... I'm brand new to CF and am wondering if I should really go down that road now or later... I have a huge app to build... actually already started. I am soliciting the downside positions... I can already predict the fanatical support from the upside contributors :-) And with that let the opinions begin Thankx, Oh... PS... I did a search of the cf-talk archives for FuseBox... But those whacky signatures;(see below) Show up as the majority of the messages for FuseBox... not to useful no? Txixtxax Cxaxnxex ~~ 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: Oracle Stored Procedures
Well, I just had my question answered. Oracle stored procedures do not return result sets. So, to get multiple records out of Oracle stored procs, you have to have the stored proc return an array of records and then have CF parse the array. Thanks to those who helped! Clint -- Original Message -- from: Terri Stocke [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 09 Aug 2001 12:56:26 + Here's an example of a call I use to an Oracle stored procedure (creates a session id). This particular example uses strings instead of numeric, but you get the idea. This is just to give you the correct syntax. Instead of using cfprocresult, you have to use cfprocparam type=out for Oracle. CFSTOREDPROC PROCEDURE=OUR_SCHEMA.APP_SECURITY.CREATE_SESSION DATASOURCE=#Variables.ProdDSN# CFPROCRESULT NAME = SessID CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#uCase(form.userid)# CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#form.password# CFPROCPARAM TYPE=OUT CFSQLTYPE=CF_SQL_VARCHAR VARIABLE=SESSID /cfstoredproc Original Message Follows From: Alex Skinner [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Oracle Stored Procedures Date: Thu, 09 Aug 2001 13:38:28 +0100 I dont believe you can use output parameters with Oracle I may be wrong? Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clint Tredway Sent: 09 August 2001 13:32 To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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: getting values out of numbered form fields
Evaluate() worked like a charm. Tim Painter -- you are a gentleman and a scholar. By the way, I was wrong when I said that the isdefined part was working, but I was able to get the code working like so: cfset tmpstr = chkPrint1 cfloop condition=isdefined(#tmpstr#) cfset strSQL = strSQL ID = evaluate(PrintID#pos#) or cfset pos = pos + 1 cfset tmpstr = chkPrint #pos# /cfloop I've had to work around this before. This will be a great help for dealing with complex forms. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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: Oracle Stored Procedures
From the CF 4.51 release notes: Oracle Reference Cursor Support This release supports the return of result sets via Oracle Reference Cursors through the Oracle 8 native driver and the ColdFusion stored procedure interface. The example below shows both the PL/SQL necessary for creating a procedure to return a result set and the CFML necessary for executing the procedure in ColdFusion. The example uses the Oracle SCOTT/TIGER login sample data. The final ColdFusion documentation for this release will contain additional information and examples. Example: Return of all rows in the DEPT table entirely through a package. PL/SQL CREATE OR REPLACE PACKAGE dept_data AS TYPE DeptTyp IS REF CURSOR RETURN dept%ROWTYPE; PROCEDURE refcurproc(pParam1 in out DeptTyp); END dept_data; CREATE OR REPLACE PACKAGE BODY dept_data AS PROCEDURE refcurproc(pParam1 in out deptTyp) IS BEGIN OPEN pParam1 FOR select * from dept; END refcurproc; end dept_data; CFML cfstoredproc procedure=dept_data.refcurproc datasource=my_oracle80_test username = scott password = tiger RETURNCODE=no cfprocparam type=Out cfsqltype=CF_SQL_REFCURSOR variable=param1 cfprocresult name = rs1 /cfstoredproc bThe first result set:/bbr hr cfoutput query = rs1 #dname#,#deptno# /cfoutput -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 8:32 AM To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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: Oracle Stored Procedures
You can return result sets from Oracle. You have to have a procparam of type CF_SQL_REFCURSOR and type OUT It has been a while since I have used Oracle and I can't remember whether you also have to include cfprocresult or not Hopefully someone who has used it more recently can give you the details, but you shouldn't have to be parsing arrays. - Original Message - From: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 7:12 AM Subject: RE: Oracle Stored Procedures Well, I just had my question answered. Oracle stored procedures do not return result sets. So, to get multiple records out of Oracle stored procs, you have to have the stored proc return an array of records and then have CF parse the array. Thanks to those who helped! Clint -- Original Message -- from: Terri Stocke [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 09 Aug 2001 12:56:26 + Here's an example of a call I use to an Oracle stored procedure (creates a session id). This particular example uses strings instead of numeric, but you get the idea. This is just to give you the correct syntax. Instead of using cfprocresult, you have to use cfprocparam type=out for Oracle. CFSTOREDPROC PROCEDURE=OUR_SCHEMA.APP_SECURITY.CREATE_SESSION DATASOURCE=#Variables.ProdDSN# CFPROCRESULT NAME = SessID CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#uCase(form.userid)# CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#form.password# CFPROCPARAM TYPE=OUT CFSQLTYPE=CF_SQL_VARCHAR VARIABLE=SESSID /cfstoredproc Original Message Follows From: Alex Skinner [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Oracle Stored Procedures Date: Thu, 09 Aug 2001 13:38:28 +0100 I dont believe you can use output parameters with Oracle I may be wrong? Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clint Tredway Sent: 09 August 2001 13:32 To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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
counting form fields
Is there any way to get a count of the number of fields that are returned from a form? Also, is there a way to get a count of the number of records selected by a cfquery? The only way I have found to do that is to do a second cfquery and use the count(*) function, but that seems to be double the work. In Visual Basic, I can just put .recordcount after the recordset name to get a count. Does Cold Fusion have anything like that? Thanks! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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: Oracle Stored Procedures
My company is still using CF 4.01. So unfortunately this will not help me at the moment. Thanks for the info! -- Original Message -- from: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 09 Aug 2001 09:23:08 -0400 From the CF 4.51 release notes: Oracle Reference Cursor Support This release supports the return of result sets via Oracle Reference Cursors through the Oracle 8 native driver and the ColdFusion stored procedure interface. The example below shows both the PL/SQL necessary for creating a procedure to return a result set and the CFML necessary for executing the procedure in ColdFusion. The example uses the Oracle SCOTT/TIGER login sample data. The final ColdFusion documentation for this release will contain additional information and examples. Example: Return of all rows in the DEPT table entirely through a package. PL/SQL CREATE OR REPLACE PACKAGE dept_data AS TYPE DeptTyp IS REF CURSOR RETURN dept%ROWTYPE; PROCEDURE refcurproc(pParam1 in out DeptTyp); END dept_data; CREATE OR REPLACE PACKAGE BODY dept_data AS PROCEDURE refcurproc(pParam1 in out deptTyp) IS BEGIN OPEN pParam1 FOR select * from dept; END refcurproc; end dept_data; CFML cfstoredproc procedure=dept_data.refcurproc datasource=my_oracle80_test username = scott password = tiger RETURNCODE=no cfprocparam type=Out cfsqltype=CF_SQL_REFCURSOR variable=param1 cfprocresult name = rs1 /cfstoredproc bThe first result set:/bbr hr cfoutput query = rs1 #dname#,#deptno# /cfoutput -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 8:32 AM To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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: FuseBox
I agree 100%. FuseBox is a great tool and allows you to deploy new sites rapidly, but not such a great idea to do starting out with a big project. Tool around with it first, learn the ins-and-outs and then begin to apply it to bigger apps. It is easy to use, but also easy to screw it up if you don't know what you're doing. In my old shop, we implemented a very clean version of it and was extremely easy to use. Where I'm currently at, they have a half-assed implementation of it and it is a royal pain in the you-know-what to debug. It's horrible. Get the book from Steve Nelson and Craig Girard (www.fusebox.org or www.secretagents.com). It spells it out very nicely. Good luck. In case you didn't know, there is a fusebox discussion forum through houseoffusion also. There are some really smart and helpful people over there that would fall over themselves trying to help you. (This means you Lee). Great resource. Michael Corrigan Programmer \- Original Message - From: Ken Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 6:36 PM Subject: RE: FuseBox I have a huge app to build... actually already started. While I happen to like FuseBox and use it for a lot of my projects (where appropriate), I'm not sure that I would suggest you dive into it for the first time on a huge app that is already underway. Particularly if the project is time sensitive. While it's not difficult to learn, it does involve changing the way you do some things and leaves it up to you to decide which parts of it you care to use and which you don't. That said, however, when you do get comfortable with it I think you'll find it speeds your development quite a bit. You will, of course, get lots of varied opinions about FuseBox here on CF-Talk...most equally valid from the perspective of the person expressing them. In the end you'll have to decide for yourself what's best for your situation. But do check it out and try to avoid falling for any of those old wivetales about it being mostly about file naming conventions or dictating directory structures. Ken ~~ 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: counting form fields
Not sure about counting the number of fields returned by a form, but... you can use: MyQueryName.RecordCount to show the number of results returned by a CF query. Alex -Original Message- From: Michael Wolter [SMTP:[EMAIL PROTECTED]] Sent: 09 August 2001 14:34 To: CF-Talk Subject: counting form fields Is there any way to get a count of the number of fields that are returned from a form? Also, is there a way to get a count of the number of records selected by a cfquery? The only way I have found to do that is to do a second cfquery and use the count(*) function, but that seems to be double the work. In Visual Basic, I can just put .recordcount after the recordset name to get a count. Does Cold Fusion have anything like that? Thanks! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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
CFMail output formatting
In the printed output which gets sent to someone (not using HTML formatting), how do you force carriage-returns? For example, var1 and var2 want to run together, without being separated by a space: #var1# #var2# /cfmail Thanks, Mark ~~ 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: counting form fields
for the number of form fields ListLen(Form.formfields) for the query just put queryname.recordcount Hope this helps Alex# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Wolter Sent: 09 August 2001 14:34 To: CF-Talk Subject: counting form fields Is there any way to get a count of the number of fields that are returned from a form? Also, is there a way to get a count of the number of records selected by a cfquery? The only way I have found to do that is to do a second cfquery and use the count(*) function, but that seems to be double the work. In Visual Basic, I can just put .recordcount after the recordset name to get a count. Does Cold Fusion have anything like that? Thanks! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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
RE: Oracle Stored Procedures
I've got a whopping 10 mos. of experience in the field so don't beat on me too harshly if I'm interpreting your question improperly. CF can handle a cursor set from Oracle. If this is not what you meant by result set, then what is the difference between a result set and a cursor set? I've included an example. Lonny Eckert Hesta Corporation [EMAIL PROTECTED] Hesta 610-230-2500 x147 *** Here is an example of a stored procedure call that receives the results of a cursor set: CFSTOREDPROC datasource=#Application.ptcl_ptcl_db# procedure=PKG_CS.fetch_hist_info returncode=No cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbvarname=p_employee_id value=#Session.SearchResult_EmployeeID# null=No cfprocparam type=Out cfsqltype=CF_SQL_REFCURSOR dbvarname=c_fetch_hist_info variable=procedure_result null=No cfprocresult name=hist_info /CFSTOREDPROC *** Use the procresult tag just as you would a query. In otherwords, a cfoutput tag dumping out the cursor sesults would simply be: cfoutput query=hist_info *** Here is an example of fetching data into a cursor set. The OPEN - FOR method is probably the simplest way of fetching data into a cursur set in Oracle. PROCEDURE fetch_hist_info ( p_employee_id IN NUMBER, c_fetch_hist_info OUT REFCURSORTYPE ) IS BEGIN OPEN c_fetch_hist_info FOR SELECT /*+ ORDERED */ to_char(effective_month,'MONTH, ') Mnth, decode(pe.benefit_type_id,1,'Transit',2,'Parking',3,'Van Pool','Unknown') Product, NVL(to_char(pe.amount,'$999.99'),'$0.00') Cost, to_char(pe.date_entered,'MM/DD/RR HH:MI:SS am') dt_entered, to_char(ps.date_entered,'MM/DD/RR HH:MI:SS am') dt_subscribed, DECODE(pe.status_id, 2, 'Inactivated',3,'Pending',4,'Cancelled',5,'Processed','Unknown') Status, ps.subscription_id sSubscriptionID, ps.Benefit_Type_id sBenefitTypeID, ps.Active_Flag sActiveFlag, ps.Purchasable_Pass_ID sPurchasablePassID, ps.Employee_ID sEmployeeID, NVL(to_char(ps.Expense_Amount,'$999.99'),'$0.00') sExpenseAmount, ps.Quantity sQuantity, ps.Expense_Operator_ID sExpenseOperatorID, ps.Hold_Flag sHoldFlag, to_char(ps.Date_Entered,'MM/DD/RR HH:MI:SS am') sDateEntered, NVL(to_char(ps.Cost,'$999.99'),'$0.00') sCost, pe.Expense_ID eExpenseID, pe.Benefit_Type_ID eBenefitTypeID, pe.Envelope_Num eEnvelopeNum, pe.Storage_Box_Num eStorageBoxNum, NVL(to_char(pe.Amount,'$999.99'),'$0.00') eAmount, pe.Operator_ID eOperatorID, pe.Order_ID eOrderID, pe.Status_ID eStatusID, pe.Envelope_Status eEnvelopeStatus, to_char(pe.Date_Entered,'MM/DD/RR HH:MI:SS am') eDateEntered, to_char(pe.Date_Processed,'MM/DD/RR HH:MI:SS am') eDateProcessed, pe.Audit_ID eAuditID, to_char(pe.Envelope_Received,'MM/DD/RR HH:MI:SS am') eEnvelopeReceived, pe.Subscription_ID eSubscriptionID, pe.Audit_Flag eAuditFlag, pe.Payroll_Processed_Flag ePayrollProcessedFlag, to_char(pe.Payroll_Processed_Date,'MM/DD/RR HH:MI:SS am') ePayrollProcessedDate FROMorders po, expenses pe, subscriptions ps WHERE po.employee_id = p_employee_id AND pe.order_id = po.order_id AND ps.subscription_id(+) = pe.subscription_id AND po.valid = 1 AND pe.status_id = 5 AND 1 = ps.active_flag(+) ORDER BYpe.date_entered desc; END fetch_hist_info; ~~ 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: Zachary Bedell
Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: (Admin) Duplicates
Did you notice that his name was surrounded by tick marks? His is the only one I can see that has that...Could that have contributed? Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 9:42 PM To: CF-Talk Subject: Re: (Admin) Duplicates I sent this earlier right after the slew of messages. Some people didn't see it. Yes, something went really bad and that message about renting SQL was duplicated a few times. I caught it before the 200+ copies of it hit the list. Sorry about that and I'm looking into what caused 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: counting form fields
This will count the fields, list the fields and tell you the value of the fields. CFSET Count = 0 CFLOOP INDEX=i LIST=#FORM.FieldNames# CFSET Count = Count + 1 CFOUTPUT#i# - #Evaluate(i)#/CFOUTPUTP /CFLOOP CFOUTPUT#Count#/CFCOUNT Dave - Original Message - From: Michael Wolter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 9:33 AM Subject: counting form fields Is there any way to get a count of the number of fields that are returned from a form? Also, is there a way to get a count of the number of records selected by a cfquery? The only way I have found to do that is to do a second cfquery and use the count(*) function, but that seems to be double the work. In Visual Basic, I can just put .recordcount after the recordset name to get a count. Does Cold Fusion have anything like that? Thanks! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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
cf4 cf5 verity
As we all know, there is a problem with CF4.5's verity engine and Adobe PDFs created in version 4 and later of Adobe Acrobat - they don't index. Having read around it seems that MM (then Allaire) didn't want to fix it for 4.5 and instead would put the fixed verity implementation into CF5. OK, thats fine - and we know have servers running CF5 using verity happily. But, we also have servers running CF4.5 with lots of small websites on them. We can upgrade these, but this will mean outage that we'd like to avoid if possible. To this end, I'd like to know if its possible to use the fixed Verity from CF5 in CF4.5 Anyone tried this / know if its possible / know how to do it / think I'm a fool? cheers for any help... --- Rich Wild Senior Web Developer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- ~~ 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: counting form fields
For the number of form fields use this instead: ListLen( FORM.FieldNames ) Remember that when you use an image form input to submit the form two extra fields will be sent (x and y coordinates of the mouse click). Also, unticked checkboxes will not be counted in and fields with the same name (especially radio buttons) will only be counted once. Hope this helps -Original Message- From: Alex Skinner [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:42 To: CF-Talk Subject: RE: counting form fields for the number of form fields ListLen(Form.formfields) for the query just put queryname.recordcount Hope this helps Alex# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Wolter Sent: 09 August 2001 14:34 To: CF-Talk Subject: counting form fields Is there any way to get a count of the number of fields that are returned from a form? Also, is there a way to get a count of the number of records selected by a cfquery? The only way I have found to do that is to do a second cfquery and use the count(*) function, but that seems to be double the work. In Visual Basic, I can just put .recordcount after the recordset name to get a count. Does Cold Fusion have anything like that? Thanks! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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
Re: counting form fields
Hi Michael, On the action page you can use the ListLen function and form.formfields [EMAIL PROTECTED] 08/09/01 09:33AM Is there any way to get a count of the number of fields that are returned from a form? Also, is there a way to get a count of the number of records selected by a cfquery? The only way I have found to do that is to do a second cfquery and use the count(*) function, but that seems to be double the work. In Visual Basic, I can just put .recordcount after the recordset name to get a count. Does Cold Fusion have anything like that? Thanks! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-| Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 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
POP/IP
Dear All Is there any way, using CF or not, of converting a POP address (e.g. pop.mail.yahoo.com) into their IP equivalents. I know you can use JavaScript with Netscape to recall IP addresses, but I need a solution which will work with IE5+. Any help much appreciated ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: I don't understand session locking :(
Maybe I am being a curmudgeon today, but it seems to me that if you ALWAYS need to lock session and application variables and would never want to use them without locks then Allaire should have coded that function into it's core design. Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 7:14 PM To: CF-Talk Subject: RE: I don't understand session locking :( Yes, you need to place a lock around any reads or writes of Session variables. If you don't lock reads as well as writes, and there's any possibility of the two operations happening simultaneously (and there usually is), then the lock you put on the write is useless by itself. ~~ 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: counting form fields
I'll add one more solution to this. The form scope in ColdFusion is actually treated as a structure. This means you can also find the number of form fields by doing something like this: #structCount(form)# Realize, however, that this count will include the actual form.fieldnames variable which doesn't truly get submitted by your form, but rather gets calculated by ColdFusion and added to the FORM scope/structure. This means in order to get the count of just the fields that were submitted, excluding form.fieldnames, you'd need to subtract one. #evaluate(structCount(form)-1)# Hope this helps, Tyson -Original Message- From: Michael Wolter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 8:34 AM To: CF-Talk Subject: counting form fields Is there any way to get a count of the number of fields that are returned from a form? Also, is there a way to get a count of the number of records selected by a cfquery? The only way I have found to do that is to do a second cfquery and use the count(*) function, but that seems to be double the work. In Visual Basic, I can just put .recordcount after the recordset name to get a count. Does Cold Fusion have anything like that? Thanks! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-| Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 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
RE: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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
relational select box
Can anyone give me a tip on how to have the contents of one select box update the contents of another from a relational DB? Emmet McGovern p.s. Good lord its HOT! ~~ 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: I don't understand session locking :(
had they done that, it likely would have placed a lock around each individual use. which would have been hard on performance. as they left it, you control what to lock, which allows you to place a single lock around a block of code. -Original Message- From: Dennis Powers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 9:07 AM To: CF-Talk Subject: RE: I don't understand session locking :( Maybe I am being a curmudgeon today, but it seems to me that if you ALWAYS need to lock session and application variables and would never want to use them without locks then Allaire should have coded that function into it's core design. Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 7:14 PM To: CF-Talk Subject: RE: I don't understand session locking :( Yes, you need to place a lock around any reads or writes of Session variables. If you don't lock reads as well as writes, and there's any possibility of the two operations happening simultaneously (and there usually is), then the lock you put on the write is useless by itself. ~~ 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: CFsetting through a loop - brainfart
Erika, You're getting this error because of how HTML forms work. When a user makes no selection for a given bank of radio buttons, checkboxes, or a select box, the actualy variable for that form widget does not get passed to the processing page. In order to get around your error, it would be easiest for you to just use the CFPARAM tag which will allow you to set a default value for a variable if it doesn't exist. You'd need to change your existing code along these lines: cfloop index=i from=1 to=#x# cfparam name=skillid#i# default= cfset thisskillid = Evaluate(Skillidi) cfparam name=level#i# default= cfset thislevel = Evaluate(level i) cfset thisempid = #empid# ... etc ... /cfloop This will eliminate the error, but it will now cause any of those missing variables to have a value of . You could replace this with any value you like. On the other hand, you could also make a change on the front-end to your form and simply make these form fields required through some error checking and validation. Otherwise, you're going to get some weird behavior from your queries when any of the variables were set equal to . Hope this helps, Tyson -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 3:34 PM To: CF-Talk Subject: CFsetting through a loop - brainfart Hi - this has got to be an easy fix. I've got a dynamic form sending a dynamic amount of fields to a Query. The form fields Level#i# are radio buttons. Here's the code: cfloop index=i from=1 to=#x# cfset thisskillid = Evaluate(Skillidi) cfset thislevel = Evaluate(level i) cfset thisempid = #empid# cfquery name=getanswer datasource=personnel SELECT empid, skillid FROM tblMatrix WHERE empid=#thisempid# and skillid=#thisskillid# /cfquery cfif #getanswer.recordcount# is 0 cfquery name=insertrow datasource=personnel INSERT INTO tblMatrix (empid, skillid, skilllevel) VALUES (#empid#, #thisskillid#, #thislevel#) /cfquery cfelse cfquery name=updaterow datasource=personnel UPDATE tblMatrix SET skilllevel=#thislevel# WHERE empid=#thisempid# AND skillid=#thisskillid# /cfquery /cfif /cfloop The problem is that if the the user doesn't answer that particular question, say they don't answer the first question - then this is the error: An error occurred while evaluating the expression: thislevel = Evaluate(level i) Error near line 12, column 8. An error has occurred while processing the expression: level1 Error near line 1, column 1. Error resolving parameter LEVEL1 Okay, so how do I cfset Level#i# = ?? That snippet gives me an Invalid Parser Construct error, pointing to the first #. This has to be easy... its not coming to me and I've wasted far too much time on this little bit of code. Thanks in advance, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ 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: Oracle Stored Procedures
Here is what I use to access an oracle sp: cfstoredproc datasource=#sid# procedure=package.proc returncode=no cfprocparam type=InOut cfsqltype=CF_SQL_VARCHAR variable=in_key value=#key# cfprocparam dbvarname=out_rec_csr variable=rec_cur cfsqltype=CF_SQL_REFCURSOR type=out cfprocresult name=get_links /cfstoredproc works fine for us. Frederic Alex Skinner wrote: I dont believe you can use output parameters with Oracle I may be wrong? Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clint Tredway Sent: 09 August 2001 13:32 To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ 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: counting form fields
You do realise that the form scope can be treated as an array. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 09 August 2001 14:39 To: CF-Talk Subject:RE: counting form fields Not sure about counting the number of fields returned by a form, but... you can use: MyQueryName.RecordCount to show the number of results returned by a CF query. Alex -Original Message- From: Michael Wolter [SMTP:[EMAIL PROTECTED]] Sent: 09 August 2001 14:34 To: CF-Talk Subject: counting form fields Is there any way to get a count of the number of fields that are returned from a form? Also, is there a way to get a count of the number of records selected by a cfquery? The only way I have found to do that is to do a second cfquery and use the count(*) function, but that seems to be double the work. In Visual Basic, I can just put .recordcount after the recordset name to get a count. Does Cold Fusion have anything like that? Thanks! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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
RE: getting values out of numbered form fields
Michael, There might be a better way to do this. The code you have right now is creating a uniquely named checkbox for each record found by the search. You might find your solution easier if you switched this and just did something like this on your search results page: !--- find records based on search criteria --- cfquery name=qSearch datasource=yourDSN select id, strName from yourTable where ... etc ... /cfquery !--- display matching records --- cfoutput query=qSearch #strName# input type=checkbox name=chkPrint value=#id#br /cfoutput So what you'd be doing here is creating a checkbox with the SAME name for every matching record, but assign the value of each checkbox based on the unique ID of a record. The reason you want to do this is because then when you submit your form, on the processing page you'll simply have one variable called chkPrint that will have a comma-delimited list of the IDs that you checked on the results page. Then you could just do something like this: cfloop list=#form.chkPrint# index=id cfset strSQL = #strSQL#ID=#id# or /cfloop Hope this makes sense. Regards, Tyson -Original Message- From: Michael Wolter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 3:04 PM To: CF-Talk Subject: getting values out of numbered form fields I have a set of forms that allow the user to search a database, display matching records and then lets the user select specific records to print. The search displays matches in a form with check boxes for each record. So I need to loop through these numbered form fields, but I don't know how many there might be. The code I have is: cfloop condition=isdefined(chkPrint#pos#) cfset strSQL = strSQL ID = PrintID#pos# or cfset pos = pos + 1 /cfloop The part where I am checking for the existence of the field seems to work, but I can't figure out how to pull in the values from these fields and add them to my string. Thanks in advance for any insights. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-| Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 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
RE: Zachary Bedell
oh dear that was bad. :-) ~~ 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: Zip Codes
Well, we've used it :) I just cut it out of a page, so it may need tweaking. I don't know of any other way to do it other then calculate against each lat/long other then precalculating some sort of matrix to try to weed out rows that you KNOW are not in the radius. It is spankin fast with US 5 digit zips. With +4 zipcodes, well, that's a lot of rows to calculate against, and I wouldn't so this. I'd have another table with the 5 digit zips, and returning the zips that match the radius, then do a +4 search. Remember that how many locations you have is not important to the zip-radius query. It just returns zipcodes that match - then query your 500+K row table for locations with those zipcodes. So, the flow would go like this: 1) Query to get Lat/Long (etc.) for User-Entered Zip code. 2) Query to get Zip5 zips within the radius of User-Entered Zip code (query against about 43,000 zip codes) 3) (Optional) Query against Zip+4 table filtering on the Zip5, so you are only hitting the rows that have the main zipcode returned by step 2 4) Query your location table for locations with the resulting zipcodes Paris Lundis wrote: Haven't tested the code below yet myself... ANyone used it before/yet? Had been looking for an elegant SQL based computation... I wrote a much more complicated and assumption oriented search to facilitate such... It works not on the circle basis but on a SQUARE basis... a small error margin in each corner :) I ask about folks using it to gauge both the speed of it compared to how I do it and the number of records everyone is using with it... I have some tables that computations need to run against upwards of 500k records quickly and usably so in a web setting.. My use for it is people searching for other people or places based on where they are or will be... QUite typical use I think... Interested in everyone's input.. -paris -Original Message- From: Edward Smith [EMAIL PROTECTED] Date: Tue, 07 Aug 2001 14:45:48 -0500 Subject: Re: Zip Codes Here's the important code - I think this works in Access, probably SQLServer as well. You need a database with zipcodes, longitude, and latitude. This assues Lon/Lat in degrees. This code takes in a radius, and returns all the zipcodes within that radius: CFPARAM NAME=Radius DEFAULT=1 CFQUERY NAME=Ziplookup DATASOURCE=ZipCodeDegrees select longitude,latitude from ZipCodes where ZipCode ='#Zip1#' /CFQUERY CFQUERY NAME=getCities DATASOURCE=ZipCodeDegrees SELECT ZipCode FROM ZipCodes WHERE SQR( ( LONGITUDE-(#Ziplookup.LONGITUDE#) )^2 + (LATITUDE-(#Ziplookup.LATITUDE#))^2 ) = (#RADIUS#)/60 /CFQUERY I'm sure this could be refined into a single query, if needs be. Here's the calculation for Lat/Long in radians: CFSET Bung = sin(SourceLatitude) * sin(DestinationLatitude) + cos(SourceLatitude) * cos(DestinationLatitude) * cos(DestinationLongitude - SourceLongitude) CFSET Mileage = 3963.0 * (ATN(-Bung / SQR(-Bung * Bung + 1)) + 1.570796326794895) Hope this helps. Rey Bango wrote: Hey all. I need to build a routine that will allow a site visitor to find a store within x miles of a specific zip code. Has anyone done this before and if so, would you mind lending some guidance? If anyone knows of a custom tag to do this, that would great. Thanks, Rey Bango Team Allaire... ~~ 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: Zachary Bedell
Oh...the irony ;) -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 15:22 To: CF-Talk Subject: RE: Zachary Bedell Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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
Dynamic array names
hi folks.. I'm having a real headache trying to set some values in an array. The problem revolves around the fact that the array name is dynamic. I've been trying to use ArraySet but its just crazy, it simply doesn't set the values. cfset ArraySet(evaluate(arrayname),1,10,bob) doesn't error, but it also doesn't actually set the values in the array. If I set the value manually as a test.. cfset ArraySet(MyArrayName,1,10,bob) then it works fine (and arrayname defintely = MyArrayName). Is there a way of using DE or something that I'm missing to get this to work or does someone maybe know of a better way to do this? I'm at my wits end (not a long journey) so all help would be gratefully receieved... thanks .jez Jeremy Becker ([EMAIL PROTECTED]) 100 High Street Wandsworth London SW18 4LA United Kingdom Tel: 020 8871 4240 Fax:020 8871 4584 http://www.bta.com Network Consultancy and Support for Windows 9x/NT and MacOS. Internet connectivity, solutions, and business services. This message is intended only for the use of the person(s) (The intended recipient(s)) to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by BTA. ~~ 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: Zachary Bedell
now you are spamming me! :) CF girl - Original Message - From: Will Swain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 10:22 AM Subject: RE: Zachary Bedell Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
Well, since the admin already wrote a notice about it, I think they know. Also, I've received your post five times. When do YOU become spam? John At 07:29 PM 8/8/01 -0400, you wrote: Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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
Locking session scope on existence checks
Do ya need to lock the session scope if you're just checking if a session var exists? Im well versed in why/how to lock for read and write, so no explanations will be needed in that area :) -Ryan ~~ 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: I don't understand session locking :(
Maybe I am being a curmudgeon today, but it seems to me that if you ALWAYS need to lock session and application variables and would never want to use them without locks then Allaire should have coded that function into it's core design. Maybe so. I can't speak to that, since I don't know enough about the internals of the CF server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ 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: I don't understand session locking :(
You make a very good point. My field experience on many different sites is deal with locking in the development/qa phase. Watch the Application and Server logs religiously and lock code as identified in these logs. Also watch the Application and Server logs on the live servers and lock code as identified in these logs. The bottom line is check these logs at least daily and whittle down the errors. I do not subscribe to the lock-everything school of thought and this is from direct real-world experience. Kind Regards - Mike Brunt Tel: 562.790.8631 Instant Messaging Handles: - AIM (AOL): MediaEmbee MSN: [EMAIL PROTECTED] Yahoo: MediaEmbeeYH -Original Message- From: Dennis Powers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 7:07 AM To: CF-Talk Subject: RE: I don't understand session locking :( Maybe I am being a curmudgeon today, but it seems to me that if you ALWAYS need to lock session and application variables and would never want to use them without locks then Allaire should have coded that function into it's core design. Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 7:14 PM To: CF-Talk Subject: RE: I don't understand session locking :( Yes, you need to place a lock around any reads or writes of Session variables. If you don't lock reads as well as writes, and there's any possibility of the two operations happening simultaneously (and there usually is), then the lock you put on the write is useless by itself. ~~ 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: Zachary Bedell
LOL! It doesn't pay to be a smart @ss does it G Ann -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 9:22 AM To: CF-Talk Subject: RE: Zachary Bedell Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Yipes - its raining ColdFusion 5 books
Pete Ruckelshaus wrote: Wow, that's sure not a sign that Cold Fusion is dying :-) CF is not going away. :-) There might be more CF books pound for pound than the total weight of Minnesota. There is a lot of momentum. ~~ 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: Zachary Bedell
He man. Sending an email that 21 times is a bit unnecessary. You're no better than Bruce... -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 7:22 AM To: CF-Talk Subject: RE: Zachary Bedell Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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: Zachary Bedell
I would like to invoke the noMoreEmail function 'noMoreEmail()' and pass it the name of the person that this email keeps comging from. :-) I got it a bazillion times. hehehe Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED] This Email contains MillenniuM Information Systems, LLC Privileged Information which is Customer or Business Sensitive. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 10:22 AM To: CF-Talk Subject: RE: Zachary Bedell Hey Bruce I got your message 3 times. are you spamming me? :-) Will -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 14:49 To: CF-Talk Subject: RE: Zachary Bedell Come on guy...I know you have a brain. HE is not spamming you. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 5:25 PM To: CF-Talk Subject: Zachary Bedell Is anyone else out there getting spammed by this guy or am I the only one? If others are, is there not a way we can remove him from the list? ~~ 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
CF Scheduler problem
Hi all, CF 4.5.1 SP2 Win 2K Server Local intranet I put a task in the Scheduler via the Admin page. (It uses cf_mail to send a test alpha pager message to a small group, with a corresponding confirm message to their mailbox.) Start date, no End date. Recurring daily at 11:00:00 Operation: HTTPRequest URL = .cfm page on a local box The day I put it in the scheduler (7/30/01), the task worked fine. The next day (7/31/01) it worked fine. Since then, it has not worked at all. Scheduler.log shows: Information,TID=752,08/01/01,10:52:35,Refreshing scheduled task list initiated. Information,TID=752,08/01/01,10:52:35,Refreshing scheduled task list completed. Information,TID=1424,08/01/01,11:00:35,Scheduled action Pagertest, template safari/it/frstest/mailtest.cfm submission initiated. Information,TID=1424,08/01/01,11:00:35,Scheduled action Pagertest, template safari/it/frstest/mailtest.cfm submitted successfully. But *only* on the first two days did the log show: Information,TID=752,07/31/01,15:46:35,Scheduling task Pagertest. Information,TID=752,07/31/01,15:46:35,Task Pagertest next scheduled submission is 11:00:00 AM. Any ideas? Thanks. Ben Braver Information Technology Ultramar Inc. Golden Eagle Refinery 150 Solano Way Martinez, CA 94553-1487 (925) 370-3673 voice (925) 370-3393 fax (510) 716-2557 pager [EMAIL PROTECTED] ~~ 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: Ben Forta and CF5 -- Coming to a CFUG Near You
Now that's a road trip I'd be willing to make... Vancouver - Anchorage =) -Original Message- From: Wayne Annis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 8:40 PM To: CF-Talk Subject: RE: Ben Forta and CF5 -- Coming to a CFUG Near You Yes, I live in Alaska and it would be great for us 'Northerners' to get some attention :) -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 6:11 PM To: CF-Talk Subject: RE: Ben Forta and CF5 -- Coming to a CFUG Near You I've done Seattle and Portland a couple of times, was in Portland not that long ago. But Alaska, now THAT sounds like a trip I need to do. :-) --- Ben -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 7:13 PM To: CF-Talk Subject: RE: Ben Forta and CF5 -- Coming to a CFUG Near You I wouldn't mind an Alaska tour =) Jk... Seriously though, it would be nice to see Vancouver/Seattle/Portland... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2007 12:09 PM To: CF-Talk Subject: RE: Ben Forta and CF5 -- Coming to a CFUG Near You How about the Buffalo/Toronto/Rochester area? Rich -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 2:40 PM To: CF-Talk Subject: RE: Ben Forta and CF5 -- Coming to a CFUG Near You I was in Southern CA last summer, these come first. But yep, I am due another West Coast visit. I'll make it happen. --- Ben -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 2:13 PM To: CF-Talk Subject: Re: Ben Forta and CF5 -- Coming to a CFUG Near You Come on Ben! Show Southern California some Love - SVV - Original Message - From: Phil Costa [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 10:52 AM Subject: Ben Forta and CF5 -- Coming to a CFUG Near You Macromedia's ColdFusion Evangelist Ben Forta is going on an 18-city User Group tour to present on ColdFusion 5. This is an excellent opportunity to get a first hand look at ColdFusion by one of the industry's best known presenters! Please join Macromedia and our awesome User Group community in a city near you. August 14, 2001 Chapel Hill, NC CFUG 7:00 PM Carroll Hall Room 111 UNC Campus Chapel Hill, NC 27599 http://www.ccfug.org/ August 15, 2001 New Orleans CFUG 7:00 PM McGlinchey Stafford Building 643 Magazine Street New Orleans, LA 70130 http://www.nocfug.org August 16, 2001 Oklahoma City CFUG 1:30 PM The Oklahoma University Health Sciences Center Campus Stanton L. Young Biomedical Research Center Seminar Room #109 975 N.E. 10th St Oklahoma City, Oklahoma 73104 http://idgweb4.ouhsc.edu/cfug/ August 20, 2001 Des Moines CFUG 6:30 PM GeoLearning, Inc. 4600 Westown Parkway Suite 301 West Des Moines, IA 50266 http://www.hungrycow.com/cfug/index.cfm August 21 Nashville CFUG 6:00 PM Caterpillar Financial Auditorium 2120 West End Ave. Nashville TN 37203 http://www.ncfug.org August 22, 2001 Long Island CFUG 7:00 PM Briarcliffe College 1055 Stewart Avenue Bethpage, New York 11714 http://www.licfug.org August 23, 2001 Annapolis CFUG 6:00 PM Calvary United Methodist Church Fellowship Hall 301 Rowe Boulevard Annapolis MD 21401 http://www.ancfug.com/ancfugmem.cfm August 27, 2001 Mid Michigan CFUG 7:00 PM Broad College of Michigan State University Room N105, 2nd floor East Lansing, MI http://www.bus.msu.edu/mmcfug/ August 28, 2001 Indianapolis CFUG 5:00 PM Northern Indiana Educational Services Center 56535 Magnetic Drive Mishawaka, Indiana 46545 http://www.nicufg.org/ August 29, 2001 State College CFUG 4:00 PM University Park Campus (Main Campus) of Penn State University Foster Auditorium of the Paterno Library State College, PA http://www.cfug-sc.org/ September 4, 2001 Las Vegas CFUG 7:00 PM Prestige Travel Executive Center - Aztec Room 6175 Spring Mountain Road Las Vegas, NV 89146 http://www.sncfug.com September 5, 2001 Minneapolis CFUG 6:30 PM Space150.com 212 3rd Ave N, Suite 150 Minneapolis, MN 55401 http://www.colderfusion.com/ September 6, 2001 St. Louis CFUG 6:00 PM Microsoft Building 1 City Place St. Louis, MO 63141 http://www.psiwebstudio.com/cfug/ September 10, 2001 Hampton Roads CFUG 7:00 PM Navy Family Services Center 7928 14th Norfolk, VA http://www.hrcfug.org/ September 11, 2001 Northern Virginia CFUG 7:00 PM 2214 Rock Hill Road Herndon, VA http://www.figleaf.com September 12, 2001 Washington DC CFUG Morning session: 9:00 AM - Noon Evening session: 6:30 PM - 9:30 PM Fig Leaf Software/RFF Conference Center 1400 16th Street, NW (Lobby Level) Washington DC 20036 http://www.figleaf.com September 13, 2001 East-Central Illiniois CFUG 6:30 PM Human Kinetics 1607 North Market Street Champaign, IL http://www.ecicfug.org Phil Costa Sr. Product Marketing Manager / Macromedia [EMAIL PROTECTED]