OT: ISP & Privacy - does your isp do this???
My ISP has asked everyone to agree to a new terms and conditions statement, that seems to permit them to do anything they like with my private information. Here are the clauses that concern me: [quote] 14.2 Company may collect, store, transfer and/or disclose to third parties, for any purpose (including where required by a credit reference provider or any Law), any information or data (whether confidential or not) relating to Customer's registration to the Service, use of the Service or this Agreement including data. 14.3 Upon written request by Customer, Company must notify Customer of any data or information collected, stored, transferred and/or disclosed by it to a third party. [/quote] If I'm reading this right, they can disclose any details in the registration data they have (name address, phone numbers, my age, occupation, credit card details, bank account details, computer type) to anyone they like. I have no right to refuse, and they don't have to disclose to me they've done it unless I ask in writing. I think this is outrageous but they say it's "quite normal" amongst ISPs. Is it? Have any of you guys been asked to agree to this kind of blank cheque? Cheers, Mike Kear AFP Webworks Windsor, NSW, Australia ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:
Thank you, Jim, Scott, and Howard, for the help. #message# does work. Jim McAtee wrote: > The scope of the variable you've specified would be variables, so use: > > #variables.message# > > or just: > > #message# > > Jim > > - Original Message - > From: "Nathan Chen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 5:12 PM > Subject: > > > Hi, Everyone, > > > > I am having a problem with tag trying to read > > a text file and display the file content. I basically copied the syntax > > from CFML Language Reference book as follow: > > > > > > When I did #file.message#, I got > > "Error resolving parameter FILE.MESSAGE > > Before you can access any file status variables you must execute at > > least one CFFILE tag." > > > > I put and in the same page. I thought I already > > executed the tag. Does anyone have any idea? I am using CF 4.5. > > Thanks. > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Delay function in CFM
If you are running windows and can load a cfx I have a simple sleep cfx you can have... Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "ycnyon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 2:40 AM Subject: Re: Delay function in CFM > Hi, > > I am looking for a CFM function where it delays a specific amount of time > before it proceeds to the next line of instruction. > > Thanks. > > 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 > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Apache vs IIS speed on Windows
I ran tests on Apache 1.12 on windows NT 4.0/sp 5 on a dual PIII 600 with 256MB ram. Serving a .5K file it was able to push about 750 pages/sec. Serving a 14K file it dropped to about 525 pages/sec, but I also noted that the 100MB network was saturated. Probably was bottlenecking the LAN (I think this works out to about 60Mbits not counting network overhead). I never got to the follow up test which were to deliver a .CFM page with only HTML in it (test the speed of the Cold Fusion module and test a .CFM page with a database call that does nothing. Also did not get to test the other web servers (website and IIS and Apache on Linux) as intended. Justin -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 10:27 PM To: CF-Talk Subject: Apach vs IIS speed on Windows We all know the security concerns and what not, but what is a speed comparrison between the two. Like how many pages per second can I expect Apache to have and how many can I expect IIS to have. I would like to use Apache but not if it is gonna hurt me speed wise. I stay on top of the security issues by unmapping everything but CFM. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Delay function in CFM
Hi, I am looking for a CFM function where it delays a specific amount of time before it proceeds to the next line of instruction. Thanks. 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: Percentages
Why not use: FinalWeight = 1165 - (.12 x 1165) Result: 1025 Rich -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 10:15 PM To: CF-Talk Subject: Percentages Is their a way with CF to use "percent" functions. eg: FinalWeight = 1165 - (12% x 1165) Result: 1025 "12%" could be a negative value, eg: FinalWeight = 1165 - (-12% x 1165) Thanks! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271-2671 Fax: +61-2-6271-2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Percentages
Just use FinalWeight = 1165 - (0.12 * 1165) it means the same thing. ++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 10:15 PM To: CF-Talk Subject: Percentages Is their a way with CF to use "percent" functions. eg: FinalWeight = 1165 - (12% x 1165) Result: 1025 "12%" could be a negative value, eg: FinalWeight = 1165 - (-12% x 1165) Thanks! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271-2671 Fax: +61-2-6271-2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Apach vs IIS speed on Windows
We all know the security concerns and what not, but what is a speed comparrison between the two. Like how many pages per second can I expect Apache to have and how many can I expect IIS to have. I would like to use Apache but not if it is gonna hurt me speed wise. I stay on top of the security issues by unmapping everything but CFM. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Percentages
Sounds like a UDF in the making. Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 10:15 PM To: CF-Talk Subject: Percentages Is their a way with CF to use "percent" functions. eg: FinalWeight = 1165 - (12% x 1165) Result: 1025 "12%" could be a negative value, eg: FinalWeight = 1165 - (-12% x 1165) Thanks! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271-2671 Fax: +61-2-6271-2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ~~ 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
CFLDAP, SSL and Active Directory
Hi All I read on Allaire's site some information about using CFLDAP with Microsoft Active Directory. I got it working, and I must say it is very cool. However, I by default all that data is moving across the network in clear text, so I want to use CFLDAP's SSL option to encrypt the traffic. Here is where the problem lies. When trying to use SSL in my CFLDAP tag, I get "error connecting with server". In the Allaire article, they recommend that you install MS Certificate Services on your Acitive Directory server. This provides the server with a certificate that it can use to encrypt the traffic. So far so good. However, the CFLDAP tag, in order to use SSL, requires a path to a certificate database (usually cert7.db) to validate the authenticity of certificates. I can't make it work, and I am thinking that this is probably because the cert7.db file contains validation data for Verisign and other public cert authorities, but DOESN'T contain validation data for my MS Cert Server's credentials. My question is, if this is the problem, does anyone know how I can edit or create my own .db file to allow SSL? Or, does anyone have any other ideas? Anyone gotten SSL to work with CFLDAP while using privately-generated certificates? Thanks in advance! Brian Kotek 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
Percentages
Is their a way with CF to use "percent" functions. eg: FinalWeight = 1165 - (12% x 1165) Result: 1025 "12%" could be a negative value, eg: FinalWeight = 1165 - (-12% x 1165) Thanks! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271-2671 Fax: +61-2-6271-2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ~~ 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
OT: SQL- Column datatype on an empty table
Hi all, I'm needing to get a list of the datatypes and maxlength properties of the columns of an empty table (I'd like to auto generate the tags). SQL_VARIANT_PROPERTY does the trick on a non-empty table but I'm not working with populated tables. Any ideas? I'm using SQL Server 2000. Thanks, Bill ~~ 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:
The scope of the variable you've specified would be variables, so use: #variables.message# or just: #message# Jim - Original Message - From: "Nathan Chen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 5:12 PM Subject: > Hi, Everyone, > > I am having a problem with tag trying to read > a text file and display the file content. I basically copied the syntax > from CFML Language Reference book as follow: > > > When I did #file.message#, I got > "Error resolving parameter FILE.MESSAGE > Before you can access any file status variables you must execute at > least one CFFILE tag." > > I put and in the same page. I thought I already > executed the tag. Does anyone have any idea? I am using CF 4.5. > Thanks. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:
Nathan, The variable is not in the file scope. You just call it as #message#. The CFFILE scope is used when you do a CFFILE ACTION="upload". It returns a list of parameters about the file. The file scope has also been deprecated, you should use CFFILE. when the situation calls for it. Hope this helps Scott Cavanaugh Software Developer Online Operations Salem Communications -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 4:13 PM To: CF-Talk Subject: Hi, Everyone, I am having a problem with tag trying to read a text file and display the file content. I basically copied the syntax from CFML Language Reference book as follow: When I did #file.message#, I got "Error resolving parameter FILE.MESSAGE Before you can access any file status variables you must execute at least one CFFILE tag." I put and in the same page. I thought I already executed the tag. Does anyone have any idea? I am using CF 4.5. Thanks. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:
CFFile can be disabled by your server administrator. Is CFFile enabled on your server? H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 > -Original Message- > From: Nathan Chen [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 4:13 PM > To: CF-Talk > Subject: > > Hi, Everyone, > > I am having a problem with tag trying to read > a text file and display the file content. I basically copied the syntax > from CFML Language Reference book as follow: > > > When I did #file.message#, I got > "Error resolving parameter FILE.MESSAGE > Before you can access any file status variables you must execute at > least one CFFILE tag." > > I put and in the same page. I thought I already > executed the tag. Does anyone have any idea? I am using CF 4.5. > Thanks. > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf-talk@houseoffusion.com
Hi, Everyone, I am having a problem with tag trying to read a text file and display the file content. I basically copied the syntax from CFML Language Reference book as follow: When I did #file.message#, I got "Error resolving parameter FILE.MESSAGE Before you can access any file status variables you must execute at least one CFFILE tag." I put and in the same page. I thought I already executed the tag. Does anyone have any idea? I am using CF 4.5. Thanks. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
reading an XLS file into a query...
Hello All, Here's what I want to do: User uploads an XLS file (column names will always be consistent) - this I've got figured out. CF reads the XLS file into a query and dumps the data into a SQL table. - part of this I can't figure out. I know how to read from a text file and do an import into SQL that way, however, my problem is that I need to read DIRECTLY from an XLS file that has been uploaded. NO DSN connections are allowed. I'm thinking maybe a COM object? What do you all think? Where should I start hunting for knowledge? I've tried CFFILE, CFHTTP, and CFCONTENT. None of those do the trick. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Way OT: Content Manager
Forgot to add this to my post. Yes people are doing what you want to do. There are a ton of resources out there. http://www.google.com/search?hl=en&q=xml+word+document+vba jon - Original Message - From: "cf kaizen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 2:41 PM Subject: Way OT: Content Manager > Hi, > > I've got a contentManager app, and I've got typical > users who don't want to use it :-) I'd like to > simplify things for them by placing a button on a > custom menu bar in MS word that would essentially > upload the text to a db. Obviously, at least part of > this would have to be done using VBA. If you have any > information/resources that would be helpful to me, > including whether anyone has done this already, please > share! > > Thanks! > Andrew > > > ~~ 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: Way OT: Content Manager
Neat idea... I have zero VBA experience, so I dont know how hard it would be to add the button and stick the content of the document in a variable, and possibly handle images. However, once you have that, you are going to need to do an insert the content into a database, so either you need an odbc dsn on the users machine or connect to the remote database from within the program by specifying the connect string, ADO is probably your best bet in this case. Another possibility is taking the content and serializing it via WDDX and just posting it to a page on your CF Server, which can handle the database stuff. There is a WDDX com object in the sdk that you could call from the VBA script. I think the hard part will be handling images inline in the document though. VBA _probably_ provides a way to grab any images out of the document. WDDX supports binary base64 encoded content, but I haven't played around with sending files across the wire that way. It should work though. Good luck! jon - Original Message - From: "cf kaizen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 2:41 PM Subject: Way OT: Content Manager > Hi, > > I've got a contentManager app, and I've got typical > users who don't want to use it :-) I'd like to > simplify things for them by placing a button on a > custom menu bar in MS word that would essentially > upload the text to a db. Obviously, at least part of > this would have to be done using VBA. If you have any > information/resources that would be helpful to me, > including whether anyone has done this already, please > share! > > Thanks! > Andrew > > > ~~ 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: Removing Special Chars
It won't catch everything, but try PreserveSingleQuotes()
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 3:13 PM
To: CF-Talk
Subject: Removing Special Chars
Whats the best script to remove and replace special characters that will
make sql2000k error out
thxw!
[MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark
before the character string 'DATABASE ERROR:
Type: DATABASE
Message: ODBC Error Code = 37000 (Syntax error or access violation)
Detail: [MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation
mark before the character string 'CORPORATE CHALLENGER PILOTS A major
corporate operator seeks to appoint two captains and a copilot to ...
SQL = "insert into errortracking(errordate,errormessage)
values('2001-09-24 15:48:16','DATABASE ERROR:
Type: DATABASE
Message: ODBC Error Code = 37000 (Syntax error or access violation)
Detail: [MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation
mark before the character string ''CORPORATE CHALLENGER PILOTS A major
corporate operator seeks to appoint two captains and a copilot to be
based in Melbourne Australia One of the captain positions will have the
responsibility of Senior Pilot The successful applicants will be
expected to operate the corporate aircraft in the capacity of aircraft
captain and copilot In additi...
SQL = "Insert into
job(jobid,creationdate,createdby,companyid,password,
jobtitle,companyname,contactname,address,city,state,zip,country,phone,fa
x
,province, email, active,datecancelled,description,position,status,
specificposition,relocation,salarymin,salarymax,areaofcountry,
willingtoworkshifts,jobstate,jobcountry,jobcitizen,jobrighttowork,jobtyp
e
ofcompany,
jobarea,jobcountries,jobrace,jobsex,jobaircraft,jobrated,jobminhoursinai
r
craft,
mintotalhours,minmrecphours,minmtjethours,mintprphours,maxtotalhours,job
p
hysicalclass,
minhelihours,minpichours,minfehours,mintihours,jobprivs,jobhs,jobtradesc
h
ool,
job2college,job4college,job4collegemajor,jobgraddegree,jobgradmajor,jobf
e
written,
jobatpwritten,jobmilitarytrained,jobpriorexp,jobpayinterviewcosts,jobpro
f
iletest,
jobpayfortrainingifjob,willingtopayifdeducted,jobminage,jobmaxage,curren
c
y,jobfccclass1,
jobfccclass2,jobfccclass3,jobdirofmaint,jobdirofmaintmonths,jobqualityco
n
trol,
jobqualitycontrolmonths,jobmaintsuper,jobmaintsupermonths,jobdar,jobdarm
o
nths,
jobder,jobdermonths,jobhelimaint,jobhelimaintmonths,jobmonthslinemaint,
jobmonthslinemaintaircraft,jobmonthsaircraftoh,jobmonthsaircraftohaircra
f
t,
jobmonthengineoh,jobmonthengineohengine,jobmonthsaccessoriesoh,jobmonths
a
ccessoriesohaccess,jobmonthsmanufacturing,jobmonthsmanufacturingaircraft
,
jobpublicexp,jobenglish,jobrussian,
jobspanish,jobfrench,jobjapanese,jobchinese,jobgerman,jobother,jobminwei
g
ht,jobmaxweight,
jobminheight,jobmaxheight,joblefteyewoglass,jobrighteyewoglass,jobleftey
e
wglass,jobrighteyewglass,jobcorrectedwglass,jobcorrectedwoglass,jobinfli
g
htmanager,jobcorpfaexp,
jobchieffltatt,jobfainst,jobdiroftrainingfa,joblinecheck,joblicensedispa
t
ch,jobyearsdomexp,
jobyearsinternationalexp,jobewins,jobetops,jobflightcontrol,jobtypeofexp
e
rience,
jobwantexpareasus,jobwantexpareas,jobtraineddispatcher,jobsuperviseddisp
a
tcher,
jobmilitarydispatcher,jobassistantdispatcher,jobdispatchprivs,custom,ema
i
ljob,internaljobid)
values(1246752,''2001-09-24'',''WEBUSER'',19930,''PASSWORD'', '' '',
''Advanced Aircraft Electronics'', ''Bill Caldwell'', ''1845 N. Marshall
Ave'', ''El Cajon'', ''CA'', ''92020-1122'', ''USA'', ''619-449-4037'',
''619-449-6394'', '' '', '' '', ''Y'', ''10/24/01'',''CORPORATE
CHALLENGER PILOTS A major corporate operator seeks to appoint two
captains and a copilot to be based in Melbourne Australia One of the
captain positions will have the responsibility of Senior Pilot The
successful applicants will be expected to operate the corporate aircraft
in the capacity of aircraft captain and copilot In addition to normal
flight duties the pilots will be expected to assist the Senior Pilot in
co-ordinating training licensing and rostering of flight and cabin
crew flight despatch and management of flight safety The successful
candidates will have right of residency in Australia and hold a valid
Australian ATPL Preference will be given to applicants with a CL604
command type rating and 100 hours in command on type In addition
applicants will meet or exceed the following 3000 hours total time 2500
hours in command 1500 hours in aircraft above 5700 kg MTOW 500 hours in
command of multi engine aircraft 500 hours in command of turbine
aircraft Extensive international experience in the corporate aviation
environment Applicants must have good communication and representational
skills with exposure to VIP passengers and be able to work effectively
as part of a small team The nature of corporate a
Re: `NOT in` CFQuery problem
Thanks for the quick response. Unfortunately it didn't work though :(
I changed the 2nd query from what you gave me, because one of your brackets
generated an error
SELECT * FROM members
WHERE subscribe_date = #CreateODBCDate(DateAdd("d", -30, today))#
AND (email NOT in '#QuotedValueList(surveyemail)#')
...but afterwards got an error with the QuoteValueList function:
"Parameter 1 of function QuotedValueList which is now "surveyemail" must be
a fully qualified column name of the form Query.ColumnName"
Any ideas?
Cheers
Will
- Original Message -
From: "Koo Pai Lao" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Monday, September 24, 2001 11:02 PM
Subject: Re: `NOT in` CFQuery problem
> The problem with your code is that at the last list append, there would be
a
> comma at the end. :P Finally, the quotedvaluelist function sets your
values
> inside singlequotes.
>
> do this
>
>
>
>
> SELECT semail FROM survey
>
>
>
>
>
>
>
>
>
> SELECT * FROM members
> WHERE subscribe_date = #CreateODBCDate(DateAdd("d", -30, today))#
> AND (email NOT in '#(QuotedValueList(surveyemail))#')
>
>
>
>
>
> >
> >
> >
> >
> >SELECT semail FROM survey
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >SELECT * FROM members
> >WHERE subscribe_date = #CreateODBCDate(DateAdd("d", -30, today))#
> >AND (email NOT in '#surveyemail#')
> >
> >
> >
> >Will
> >
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: `NOT in` CFQuery problem
The problem with your code is that at the last list append, there would be a
comma at the end. :P Finally, the quotedvaluelist function sets your values
inside singlequotes.
do this
SELECT semail FROM survey
SELECT * FROM members
WHERE subscribe_date = #CreateODBCDate(DateAdd("d", -30, today))#
AND (email NOT in '#(QuotedValueList(surveyemail))#')
>
>
>
>
>SELECT semail FROM survey
>
>
>
>
>
>
>
>
>
>SELECT * FROM members
>WHERE subscribe_date = #CreateODBCDate(DateAdd("d", -30, today))#
>AND (email NOT in '#surveyemail#')
>
>
>
>Will
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
`NOT in` CFQuery problem
Hi.
One of my queries selects all emails from a Survey table. In the 2nd query,
I need to select all *members* who subscribed on a particular date but
exclude those found in the existing query. I'm sure I've done something
like this in the past using "NOT in," but am failing miserably here. The 2
queries are (unfortunately) on 2 different datasources.
Any advice'd be much appreciated.
SELECT semail FROM survey
SELECT * FROM members
WHERE subscribe_date = #CreateODBCDate(DateAdd("d", -30, today))#
AND (email NOT in '#surveyemail#')
Will
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf and apache
Correct. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 11:43 AM To: CF-Talk Subject: RE: cf and apache For the windows version of the module? -jesse -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 11:16 AM To: CF-Talk Subject: RE: cf and apache After a few conversations MM agreed to compile it and said it would be available in a few weeks. That was at the end of August. I have asked for an update but have not gotten a reply. Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 12:25 PM To: CF-Talk Subject: RE: cf and apache Actually, now that you mention it, I forgot about that EAPI thing going on. I get the error on startup (only when using the OpenSSL compiled version) about the module, but it's been running fine and we've been hitting it pretty hard. What's the latest on the replacement module? > Which version of apache are you running and what platform? I have found > that SSL on win32 with 1.3.20 apache required an EAPI Cold Fusion module and > MM has not yet made it available (though they said that they would after the > discussions on the list and some back and forth with their support people). > > Justin > > -Original Message- > From: Tony Schreiber [mailto:[EMAIL PROTECTED]] > Sent: Saturday, September 22, 2001 9:43 PM > To: CF-Talk > Subject: RE: cf and apache > > Works great with SSL too. No problems. It was a little tricky setting it > up the first time, but I'm using OpenSSL with no issues. > > And of course, the first time, I was trying to import certificates created > with Netscape server. THAT was a fun thing to do. > > > Works great so long as you do not need SSL. Been running it for almost 3 > > years without a problem. > > > > -Original Message- > > From: Ben Whalley [mailto:[EMAIL PROTECTED]] > > Sent: Friday, September 21, 2001 9:53 AM > > To: CF-Talk > > Subject: cf and apache > > > > How much experience do people have with CF and Apache? Anything to be > aware > > of if switching from IIS. We are just about to buy a new box and with all > > these nightmares people are having with nimba etc thought it might be a > good > > idea. > > > > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stock Quotes
Dow-Jones requires a $6,000 license fee to run it's stock ticker on a Web site. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 > -Original Message- > From: Billy Cravens [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 12:06 PM > To: CF-Talk > Subject: RE: Stock Quotes > > There's always cf_StockGrabber (I'm not sure of the legality of this - > it grabs a CSV from Yahoo and parses it - this CSV is available freely > on the website, so I can't see a big problem) > > --- > Billy Cravens > Web Development, EDS > [EMAIL PROTECTED] > > > -Original Message- > From: Ronald Winn [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 10:09 AM > To: CF-Talk > Subject: Stock Quotes > > > Any ideas on a good service that allows web servers to obtain stock > quotes (preferably free). I'm building a flash and generator interface > to display a stock ticker. > > Thanks > Ron > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: twoselectsrelated
I played with both of those tags a while back and didn't really like them. I was probably doing something wrong though. I decided to just write my own, it was a lot easier than figuring out those tags... :) Unfortunately this does not work in NS4 (works in IE4+, NS6). It's probably something easy, but I haven't gotten a chance to look at it yet. Here is the code. SELECT State, Region FROM Locations //sets up javascript array with the two related query columns. State/Regions in my case. regions = new Array();#state# = new Array(); #state#[0] = '#region#'; #state#[1] = '#state#'; regions[#counter#] = #state#; //When the select is changed, this loops through the array and looks for the selected state. //If a match is found it is appended to the regions select box. function getRegion(elem) { //this line resets the select box, but leaves the first option. document.entry.region.options.length = 1; for (i = 0; i != regions.length; i++) { if (regions[i][1] == elem.value) { var o = new Option(regions[i][0], regions[i][0], false, false); document.forms[0].region.options[document.entry.region.length] = o; } } } Entire State jon - Original Message - From: "Steven Dworman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 10:27 AM Subject: twoselectsrelated > I've been playing with twoselectsrelated, and for some reason I'm running > into a bind. I have a multipart form where I'm storing the data using the > following methodology. I take the data and throw it into an array > and store the array in a structure and then finally keep it in a WDDX > packet. The problem I'm having with the tag is when I want to go back and > update data. I am using it to populate a select box of > countries and upon a selection a select box of states/provinces will appear > (which is what the tag is intended to do). When I attempt to update the > data, the country select box has the selected value selected, > however, the state/province select box is empty. I've updated the tag to > accept default values, using the same code from threeselectsrelated. Any > suggestions? > > > > > Steven D Dworman > - > Web Consultant > Systems Administrator > > ComSpec International - http://www.comspec-intnl.com > phone: 248.647.8841 > cell: 734.972.9676 > - > EMPOWER-XL ***Software for Higher Education*** > http://www.empower-xl.com > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stock Quotes
There's always cf_StockGrabber (I'm not sure of the legality of this - it grabs a CSV from Yahoo and parses it - this CSV is available freely on the website, so I can't see a big problem) --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Ronald Winn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 10:09 AM To: CF-Talk Subject: Stock Quotes Any ideas on a good service that allows web servers to obtain stock quotes (preferably free). I'm building a flash and generator interface to display a stock ticker. Thanks Ron ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Carriage Returns with CFFILE
I didn't have a lot of luck with the tags for some reason, but give it a shot. JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 4:47 PM To: CF-Talk Subject: RE: Carriage Returns with CFFILE Or even #fulltext# Perhaps you should write the file with #Chr(10)# instead? That's what I usually do, then replace it with when I output. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 3:18 PM To: CF-Talk Subject: RE: Carriage Returns with CFFILE Write the file: retrieve it with: show it on screen with normal text formatting with: #paragraphformat(FULLTEXT)# JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: Chris Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:29 AM To: CF-Talk Subject: Carriage Returns with CFFILE Hi, I'm having some difficulty writing a simple DOS text file with CFFILE ACTION="write" I'm creating the file in a variable ie outputtext = line1 & chr(13) & line2 ...etc; But cold fusion seems to be interpreting the carriage returns and/or line feeds. I need to get a regular DOS texrt file, ie new lines are CR/LF pairs. I've tried outputting CF/LF's, CR's and LF's but when I look at the file I don't end up with CR/LF's. How do I tell cold fusion what I want? -- - Chris Jensen [EMAIL PROTECTED] Educational Experience (Australia) Postal Address: PO Box 860, Newcastle NSW 2300 Freecall: 1-800-025 270 International: +61-2-4923 8222 Fax:(02) 4942 1991 International: +61-2-4942 1991 Visit our online Toy store! http://www.toysandmore.com.au/ - FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ ~~ 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: Carriage Returns with CFFILE
Or even #fulltext# Perhaps you should write the file with #Chr(10)# instead? That's what I usually do, then replace it with when I output. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 3:18 PM To: CF-Talk Subject: RE: Carriage Returns with CFFILE Write the file: retrieve it with: show it on screen with normal text formatting with: #paragraphformat(FULLTEXT)# JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: Chris Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:29 AM To: CF-Talk Subject: Carriage Returns with CFFILE Hi, I'm having some difficulty writing a simple DOS text file with CFFILE ACTION="write" I'm creating the file in a variable ie outputtext = line1 & chr(13) & line2 ...etc; But cold fusion seems to be interpreting the carriage returns and/or line feeds. I need to get a regular DOS texrt file, ie new lines are CR/LF pairs. I've tried outputting CF/LF's, CR's and LF's but when I look at the file I don't end up with CR/LF's. How do I tell cold fusion what I want? -- - Chris Jensen [EMAIL PROTECTED] Educational Experience (Australia) Postal Address: PO Box 860, Newcastle NSW 2300 Freecall: 1-800-025 270 International: +61-2-4923 8222 Fax:(02) 4942 1991 International: +61-2-4942 1991 Visit our online Toy store! http://www.toysandmore.com.au/ - FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL on 5.0
Every message that gets dropped into the mail spool just sits there. Every message after that is a 0KB file and the message is never actually written. This obviously locks up the spooler, and indexing fails once the CF mail spooler is locked up. Any suggestions at all. There are only 25-50 messages a day sent through this machine, but it is causing problems. Not many messages, but there are important. Once I stop the CF service and pull the first message out (that is created, but won't go) then restart the service and dump that message back into the spool file, it goes without a problem, until the message is added to the spool and then it locks again. PLEASE HELP Thank you, Christian Watt Webmaster SkillPath Seminars ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Way OT: Content Manager
I know that the DHTMLEdit control (in IE4+) can handle copied and pasted text from Word. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: cf kaizen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 1:41 PM To: CF-Talk Subject: Way OT: Content Manager Hi, I've got a contentManager app, and I've got typical users who don't want to use it :-) I'd like to simplify things for them by placing a button on a custom menu bar in MS word that would essentially upload the text to a db. Obviously, at least part of this would have to be done using VBA. If you have any information/resources that would be helpful to me, including whether anyone has done this already, please share! Thanks! Andrew ~~ 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: Carriage Returns with CFFILE
Write the file: retrieve it with: show it on screen with normal text formatting with: #paragraphformat(FULLTEXT)# JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: Chris Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:29 AM To: CF-Talk Subject: Carriage Returns with CFFILE Hi, I'm having some difficulty writing a simple DOS text file with CFFILE ACTION="write" I'm creating the file in a variable ie outputtext = line1 & chr(13) & line2 ...etc; But cold fusion seems to be interpreting the carriage returns and/or line feeds. I need to get a regular DOS texrt file, ie new lines are CR/LF pairs. I've tried outputting CF/LF's, CR's and LF's but when I look at the file I don't end up with CR/LF's. How do I tell cold fusion what I want? -- - Chris Jensen [EMAIL PROTECTED] Educational Experience (Australia) Postal Address: PO Box 860, Newcastle NSW 2300 Freecall: 1-800-025 270 International: +61-2-4923 8222 Fax:(02) 4942 1991 International: +61-2-4942 1991 Visit our online Toy store! http://www.toysandmore.com.au/ - FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ ~~ 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: cfhttp Connection failure
A number of reasons. Proxy server? Perhaps the site expects a particular user agent? --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 11:14 AM To: CF-Talk Subject: cfhttp Connection failure What could cause this using CFHTTP when I can go to the URL directly in my browser? Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Removing Special Chars
Whats the best script to remove and replace special characters that will
make sql2000k error out
thxw!
[MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark
before the character string 'DATABASE ERROR:
Type: DATABASE
Message: ODBC Error Code = 37000 (Syntax error or access violation)
Detail: [MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation
mark before the character string 'CORPORATE CHALLENGER PILOTS A major
corporate operator seeks to appoint two captains and a copilot to ...
SQL = "insert into errortracking(errordate,errormessage)
values('2001-09-24 15:48:16','DATABASE ERROR:
Type: DATABASE
Message: ODBC Error Code = 37000 (Syntax error or access violation)
Detail: [MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation
mark before the character string ''CORPORATE CHALLENGER PILOTS A major
corporate operator seeks to appoint two captains and a copilot to be
based in Melbourne Australia One of the captain positions will have the
responsibility of Senior Pilot The successful applicants will be
expected to operate the corporate aircraft in the capacity of aircraft
captain and copilot In additi...
SQL = "Insert into
job(jobid,creationdate,createdby,companyid,password,
jobtitle,companyname,contactname,address,city,state,zip,country,phone,fax
,province, email, active,datecancelled,description,position,status,
specificposition,relocation,salarymin,salarymax,areaofcountry,
willingtoworkshifts,jobstate,jobcountry,jobcitizen,jobrighttowork,jobtype
ofcompany,
jobarea,jobcountries,jobrace,jobsex,jobaircraft,jobrated,jobminhoursinair
craft,
mintotalhours,minmrecphours,minmtjethours,mintprphours,maxtotalhours,jobp
hysicalclass,
minhelihours,minpichours,minfehours,mintihours,jobprivs,jobhs,jobtradesch
ool,
job2college,job4college,job4collegemajor,jobgraddegree,jobgradmajor,jobfe
written,
jobatpwritten,jobmilitarytrained,jobpriorexp,jobpayinterviewcosts,jobprof
iletest,
jobpayfortrainingifjob,willingtopayifdeducted,jobminage,jobmaxage,currenc
y,jobfccclass1,
jobfccclass2,jobfccclass3,jobdirofmaint,jobdirofmaintmonths,jobqualitycon
trol,
jobqualitycontrolmonths,jobmaintsuper,jobmaintsupermonths,jobdar,jobdarmo
nths,
jobder,jobdermonths,jobhelimaint,jobhelimaintmonths,jobmonthslinemaint,
jobmonthslinemaintaircraft,jobmonthsaircraftoh,jobmonthsaircraftohaircraf
t,
jobmonthengineoh,jobmonthengineohengine,jobmonthsaccessoriesoh,jobmonthsa
ccessoriesohaccess,jobmonthsmanufacturing,jobmonthsmanufacturingaircraft,
jobpublicexp,jobenglish,jobrussian,
jobspanish,jobfrench,jobjapanese,jobchinese,jobgerman,jobother,jobminweig
ht,jobmaxweight,
jobminheight,jobmaxheight,joblefteyewoglass,jobrighteyewoglass,joblefteye
wglass,jobrighteyewglass,jobcorrectedwglass,jobcorrectedwoglass,jobinflig
htmanager,jobcorpfaexp,
jobchieffltatt,jobfainst,jobdiroftrainingfa,joblinecheck,joblicensedispat
ch,jobyearsdomexp,
jobyearsinternationalexp,jobewins,jobetops,jobflightcontrol,jobtypeofexpe
rience,
jobwantexpareasus,jobwantexpareas,jobtraineddispatcher,jobsuperviseddispa
tcher,
jobmilitarydispatcher,jobassistantdispatcher,jobdispatchprivs,custom,emai
ljob,internaljobid)
values(1246752,''2001-09-24'',''WEBUSER'',19930,''PASSWORD'', '' '',
''Advanced Aircraft Electronics'', ''Bill Caldwell'', ''1845 N. Marshall
Ave'', ''El Cajon'', ''CA'', ''92020-1122'', ''USA'', ''619-449-4037'',
''619-449-6394'', '' '', '' '', ''Y'', ''10/24/01'',''CORPORATE
CHALLENGER PILOTS A major corporate operator seeks to appoint two
captains and a copilot to be based in Melbourne Australia One of the
captain positions will have the responsibility of Senior Pilot The
successful applicants will be expected to operate the corporate aircraft
in the capacity of aircraft captain and copilot In addition to normal
flight duties the pilots will be expected to assist the Senior Pilot in
coÂordinating training licensing and rostering of flight and cabin
crew flight despatch and management of flight safety The successful
candidates will have right of residency in Australia and hold a valid
Australian ATPL Preference will be given to applicants with a CL604
command type rating and 100 hours in command on type In addition
applicants will meet or exceed the following 3000 hours total time 2500
hours in command 1500 hours in aircraft above 5700 kg MTOW 500 hours in
command of multi engine aircraft 500 hours in command of turbine
aircraft Extensive international experience in the corporate aviation
environment Applicants must have good communication and representational
skills with exposure to VIP passengers and be able to work effectively
as part of a small team The nature of corporate aviation is such that
individuals will be expected to manage all administrative aspects
associated with international operations The incumbents must have sound
knowledge of Australian Civil Aviation Regulations and international
aviation standards The successful candidates will fly extensively
intern
Re: Error 232
[Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. I found this error in the application.log file for CF Server I have plenty of paging/swap disk space (all the HD's have plenty of space also)... Any idea what temporary disk space this error is referring to? At 03:56 PM 9/24/2001 -0400, you wrote: >I ran into this error this morning. I noticed the CPU was pegged at 100% >so i rebooted the box. > >I could not find the error on MS's web site, but i think it has to do with >Databases. > >"Error","TID=218","09/24/01","8:53:30","Error number 232 occurred >attempting to close connection to web server." >"Error","TID=218","09/24/01","8:53:30","Windows NT error number 232 occurred." > > > >At 06:31 PM 9/24/2001 +0100, you wrote: > >Hi, > > > >I am getting NT error 232 when I run some of the pages in my CF application. > >I have looked through the archive and see several other people have suffered > >from it but none of the suggested answers seem to cure it. > > > >Does anyone know what causes it ? > > > >Kevin Roche > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Error 232
http://www.tera-it.com/html/server/docs/WINERROR.HTM -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 3:56 PM To: CF-Talk Subject: Re: Error 232 I ran into this error this morning. I noticed the CPU was pegged at 100% so i rebooted the box. I could not find the error on MS's web site, but i think it has to do with Databases. "Error","TID=218","09/24/01","8:53:30","Error number 232 occurred attempting to close connection to web server." "Error","TID=218","09/24/01","8:53:30","Windows NT error number 232 occurred." At 06:31 PM 9/24/2001 +0100, you wrote: >Hi, > >I am getting NT error 232 when I run some of the pages in my CF application. >I have looked through the archive and see several other people have suffered >from it but none of the suggested answers seem to cure it. > >Does anyone know what causes it ? > >Kevin Roche > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error 232
I ran into this error this morning. I noticed the CPU was pegged at 100% so i rebooted the box. I could not find the error on MS's web site, but i think it has to do with Databases. "Error","TID=218","09/24/01","8:53:30","Error number 232 occurred attempting to close connection to web server." "Error","TID=218","09/24/01","8:53:30","Windows NT error number 232 occurred." At 06:31 PM 9/24/2001 +0100, you wrote: >Hi, > >I am getting NT error 232 when I run some of the pages in my CF application. >I have looked through the archive and see several other people have suffered >from it but none of the suggested answers seem to cure it. > >Does anyone know what causes it ? > >Kevin Roche > ~~ 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
AW: ezEdit
Lenny, on a small project I created the output (with cfoutput I guess) above the ezEdit input-window. Then I put a remark that the user should select the text and do a copy and paste in a textarea (below in another window). Then the data is stored in a memo-field. (INSERT INTO with a cfquery) Works well. Isn't that comfortable but was easy to implement and the customer said, it would be o.k. for him as I did it. Uwe -Ursprüngliche Nachricht- Von: Lenny Sorey [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 23. September 2001 22:14 An: CF-Talk Betreff: ezEdit Anyone have any examples (that you wouldn't mind sharing) of saving the HTMLsource field via WYSIWYG to an SQL database field using ezEdit as the WYSIWYG editor? Any help would be greatly appreciated. Regards, Lenny R. Sorey FatDot.com [EMAIL PROTECTED] 601-856-1736 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing info from one window to another
Try this: parent.document.frmName.frmField.value --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 10:49 AM To: CF-Talk Subject: Passing info from one window to another Can someone tell me the best way to grab values from a form that is in a main window and use them to display data in a new window. I can write to the second window but I can't figure out how to grab 3 form fields I have in my main window and have CF grab those value in my second window. For example. I have an order entry form for sales people to enter in orders, they then have a button to submit the order and another button to verify the customers credit card number. The "Verify Credit Card" button opens a new window which uses the cfx_paymentnet custom tag. I can use javascript to write to that page but I can't figure out how to pass variables so the cfx_paymentnet tag can grab the values it needs. I hope I am clear on this. Any help would be greatly appreciated. Thank You, Ben Densmore ~~ 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
CFPop [CF:4.5]
Hi All, Using CF4.5, how do you or can you determine if there is an attachment to an email. If you can determine and the email has an attachment, how do you grab the contents? Thanks Duane ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX
Done up to 70k with no issues -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 12:34 PM To: CF-Talk Subject: WDDX Is there any limit to the length that a string can be inside a wddx packet? TIA, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AHHHHHHHH Netscape HTML Question
I commented the mistakes I see and got rid of the tab formatting so it doesn't all wrap.  Bob <--- Make this colspan=3 or add 2 more cells to this row  Bob   <--- Why is this closing td tag here? Again, needs 2 more rows or a colspan. Width should add up to 620. Test -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: AHHHHHHHH Netscape HTML Question
6 of one, half dozen of another. Actually, I think he is just forgetting to open the new table cell after closing the initial one for that row, also, he is defining the width as 4 but that doesn't make much sense since the corresponding table cell above this one is 10 pixels and that just won't work. Alex -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:28 PM To: CF-Talk Subject: RE: A Netscape HTML Question Acutally he juts had an extra -Original Message- From: Alex Santantonio [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:18 PM To: CF-Talk Subject: RE: A Netscape HTML Question You are missing a on line 31 just before you are opening your 3rd nested table. You have a lot of nested tables that are unnecessary, and I don't think with your current layout it will do quite what you are intending. Try this instead. Untitled  Bob   Bob   Test -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:02 PM To: CF-Talk Subject: A Netscape HTML Question This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Way OT: Content Manager
Hi, I've got a contentManager app, and I've got typical users who don't want to use it :-) I'd like to simplify things for them by placing a button on a custom menu bar in MS word that would essentially upload the text to a db. Obviously, at least part of this would have to be done using VBA. If you have any information/resources that would be helpful to me, including whether anyone has done this already, please share! Thanks! Andrew ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Passing the results from the
Make sure you have session management activated...then ... Then on your other template page... The directory listing is: #stDirFileName[RecNo]# #stDirFileSize[RecNo]# Give that a whirl...this has not been tested, but should give you the idea on how to complete it. Bruce [EMAIL PROTECTED] - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 10:32 AM Subject: Re: Passing the results from the At 10:28 AM 9/24/01 -0700, you wrote: > >There are multiple ways to pass it. What directory info are you wanting to > >pass? > > > All the information from the Name, Type etc. > > >You can pass info from one template to another via: > > Session vars > > Client vars > > Application vars > > Form fields > > URL parameters > > etc > > > >You may want to store the directory info you want into a structure or array, > >scope it as a Session variable, then reference it on the next template. > > Yikes. How do I do that? > > > >Bruce > >[EMAIL PROTECTED] > > > >- Original Message - > >From: <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Monday, September 24, 2001 10:00 AM > >Subject: Re: Passing the results from the > > > > > > How can I pass the results from the > > > > > Name > > > Size > > > Type..etc > > > > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AHHHHHHHH Netscape HTML Question
Your first "Bob" line and the third blank line in the nested table are missing "colspan=3" in the TD tags. What works for me is to set each table to a different width and border color. That way you can see what cells are in each table, where they are laid out, and any missing columns, etc. John P.S. I've attached the code with the colors, etc changed. Untitled  Bob  Bob   Test ~~ 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: AHHHHHHHH Netscape HTML Question
Actually...look at line 29. you're trying to put a table inside a but you closed the before created the table. Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Alex Santantonio [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:18 PM To: CF-Talk Subject: RE: A Netscape HTML Question You are missing a on line 31 just before you are opening your 3rd nested table. You have a lot of nested tables that are unnecessary, and I don't think with your current layout it will do quite what you are intending. Try this instead. Untitled  Bob   Bob   Test -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:02 PM To: CF-Talk Subject: A Netscape HTML Question This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ 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: AHHHHHHHH Netscape HTML Question
Acutally he juts had an extra -Original Message- From: Alex Santantonio [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:18 PM To: CF-Talk Subject: RE: A Netscape HTML Question You are missing a on line 31 just before you are opening your 3rd nested table. You have a lot of nested tables that are unnecessary, and I don't think with your current layout it will do quite what you are intending. Try this instead. Untitled  Bob   Bob   Test -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:02 PM To: CF-Talk Subject: A Netscape HTML Question This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AHHHHHHHH Netscape HTML Question
In this section of code: Â Test you're closing your td at the top and then closing another td that doesn't have an accompanying open tag at the bottom. That *might* be your problem. Kamie Robert Everland wrote: > This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from > going over and over and over and over again trying to see something. > Hopefully a new set of eyes will find it. > > > > > > Untitled > > > bgcolor="#FF" text="#00"> > > > > Â > > cellpadding="0"> > > > Bob > > > > Â > > Bob > > align="right">Â > > > Â > > > width="616" colspan="2" nowrap> > Test > > > > > > > > > > > > > > > Robert Everland III > Dixon Ticonderoga > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AHHHHHHHH Netscape HTML Question
 --- snip --- Right here, you are opening a new table in the middle of nothing. If I remember, Netscape has issues with malformed tables. Todd - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 2:02 PM Subject: A Netscape HTML Question > This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from > going over and over and over and over again trying to see something. > Hopefully a new set of eyes will find it. > > > > > > Untitled > > > bgcolor="#FF" text="#00"> > > > > >  > > cellpadding="0"> > > > Bob > > > >  > > Bob > > align="right"> > > >  > > > width="616" colspan="2" nowrap> > Test > > > > > > > > > > > > > > > > Robert Everland III > Dixon Ticonderoga > ~~ 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: Passing the results from the
I'm dumping the session variables but something strange is happening. Â #name# Notice the results. It always lists the last filename in the direectory? act.dat Key = CFID (Value = 33) Key = CFTOKEN (Value = 50259171) Key = FILENAME (Value = uniform_act.job) Key = LOGGEDIN (Value = FALSE) Key = SESSIONID (Value = MYAPPLICATION_33_50259171) act_test.dat Key = CFID (Value = 33) Key = CFTOKEN (Value = 50259171) Key = FILENAME (Value = uniform_act.job) Key = LOGGEDIN (Value = FALSE) Key = SESSIONID (Value = MYAPPLICATION_33_50259171) At 10:28 AM 9/24/01 -0700, you wrote: >There are multiple ways to pass it. What directory info are you wanting to >pass? > >You can pass info from one template to another via: > Session vars > Client vars > Application vars > Form fields > URL parameters > etc > >You may want to store the directory info you want into a structure or array, >scope it as a Session variable, then reference it on the next template. > >Bruce >[EMAIL PROTECTED] > >- Original Message - >From: <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Monday, September 24, 2001 10:00 AM >Subject: Re: Passing the results from the > > > How can I pass the results from the > > > Name > > Size > > Type..etc > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: AHHHHHHHH Netscape HTML Question
4.77 Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:16 PM To: CF-Talk Subject: RE: A Netscape HTML Question Works for me in netscape 4.7. what version of 4 are you using? Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:02 PM To: CF-Talk Subject: A Netscape HTML Question This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ 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: AHHHHHHHH Netscape HTML Question
Didn't work in 4.7 for me, only a partial table showed... found the problem already though... He had an extram tag closed too early. -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:16 PM To: CF-Talk Subject: RE: A Netscape HTML Question Works for me in netscape 4.7. what version of 4 are you using? Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:02 PM To: CF-Talk Subject: A Netscape HTML Question This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ 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: AHHHHHHHH Netscape HTML Question
Remove the from  Should be  You close it later down the page... -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:02 PM To: CF-Talk Subject: A Netscape HTML Question This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: AHHHHHHHH Netscape HTML Question
You are missing a on line 31 just before you are opening your 3rd nested table. You have a lot of nested tables that are unnecessary, and I don't think with your current layout it will do quite what you are intending. Try this instead. Untitled  Bob   Bob   Test -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:02 PM To: CF-Talk Subject: A Netscape HTML Question This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ 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: AHHHHHHHH Netscape HTML Question
Works for me in netscape 4.7. what version of 4 are you using? Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:02 PM To: CF-Talk Subject: A Netscape HTML Question This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
AHHHHHHHH Netscape HTML Question
This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt from going over and over and over and over again trying to see something. Hopefully a new set of eyes will find it. Untitled  Bob  Bob   Test Robert Everland III Dixon Ticonderoga ~~ 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: OT: E-mail Services
Yes - I know it can be done; I'm just looking for recommendations on companies that provide e-mail services. Swishmail.com is one, for example; they host mail for your domain and let you configure your own accounts and check e-mail via the web or POP. I just wanted to see if anyone else had any experience with other services that might be less expensive and/or have better service. BTW, I'm on cable modem and Roadrunner won't manage e-mail for my domain unless I change to a business account. The ISP that houses our co-lo box is a small outfit and they don't have a web-based administration for setting up accounts or checking mail. You have to call them for every change and can only access your mail with a POP client. That is why we resorted to running our own mail server in the first place, but we just can't keep the box up 100% of the time. Sorry my question was confusing, but I appreciate you taking the time to respond. Jackson >Â I don't know how to implement it, but I do know that it was ( >fairly >easily ) done by a UNIX guy I used to work with. >Â Mail stuff (I.E. smtp requests?) can easily be redirected to one >place >while http requests are directed to another. > >Â Â ( wouldn't it have made more sense to contact your ISP in the >first >place ? ) > >At 10:13 AM 09/24/2001 -0400, you wrote: >>I am looking for any recommendations you cf-talk guys might have >>Â about e-mail services for hosting the e-mail for my domain. >> >>I share a co-located server with a few other developers for work >>Â we do on the side and we have been running our own mail server >>Â for awhile, but because we use this box for development >>Â purposes, it isn't up 100% of the time. Â I'd like to continue to >>Â do my own web hosting, but would like to move my e-mail hosting >>Â to another provider. Â The ISP that hosts our server does all our >>Â DNS so I should be able to have my mail directed to another >>Â server. >> >>I would like to be able to add and manage my e-mail accounts over >>Â the web, be able to access mail from a typical POP3 client, but >>Â also have a web-based interface for checking mail when I'm >>Â without my laptop. >> >>Any suggestions or recommendations you'd like to share - I'd >>Â appreciate it. >> >>Thanks >> >>Jackson Moore >>[EMAIL PROTECTED] >> >> > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Search Engines
Google does not charge for search engine listings, as suggested below. You can buy ads on google that use the keywords, but they do not effect the rankings in the engine one bit. In google's creators are very strongly opposed to such practices, I don't think you will ever have to pay for listings in google. I've done a lot of research about google, and the way google does sort its search results is a combination of a PageRank, and the IR score. PageRank is defined as a recurrence that is completely dependant on the backwards links (links on other peoples sites, pointing to yours to your page. The number of links on a page that links to you mitigates your PageRank. A link to your page will have the best impact on your page rank if, the page linking to you has a high page rank, and the total number of links of that site is low. A site with a high PageRank and a large number of outbound links can nullify its effect on your page rank. Since each backward linkÂ’s PageRank/Total Links is summed, your PageRank cannot be lowered by a link, and is always increased slightly by each backward link your page has. The IR score is based on keyword placement on your site font sizes, title text, meta info, and text inside links, linking to your page. If you focus on improving your page rank (finding site to link to you) you will get more hits from google, and from the sites that link to you. Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 6:55 AM To: CF-Talk Subject: RE: Search Engines Hi, The whole issue of whether you have to pay for search engines or not is very complex and much more detailed than simply do I have to pay or not. You will not get listed on certain engines if you don't subscribe to certain directories and are unlikely to get a good position unless you pay for some, such as Google, . The best sites I have found that tell you everything about searchengines are: http://searchengineforums.com - where you get help from fellow developers/marketing people http://www.searchenginewatch.com/ - good updated info on all major search engines A critical directory appears to be Inktomi,which is where some searchengines get their sites list from, from reading peoples input in searchengine forums. You can register on this with: http://www.positiontech.com/inktomi/faq.htm#1 (but go to the other sites first and see what you think from peoples comments) To sum up and use a generalisation, if you have a personal site you can get on enough engines for free but it may take months, but if you have money to spend then you can get a better ranking, much faster, and can have your site automatically re-submitted regularly when you pay. Declan Maher Web Applications Developer -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: 23 September 2001 17:01 To: CF-Talk Subject: RE: Search Engines You don't have to pay. Do it yourself. I do. Just go to each of the search engines, and register a site with them. .. Capture the form you submit, and put that code into a CF template yourself. I have made one where I put in the keywords, description, basic information enough to fill in all the forms in all the sites I want to submit to. Then on the template page I have, I fill in my site name once, site address once, description once, name once, etc etc. and select a classification for each search engine, the drop down menus are taken off the site's own form. Then the submit button on the action page sends off the information needed by each site in turn, and puts a confirming page up. "submitted to altavista... submitted to hotbot ... etc " Hope this helps. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 10:27 PM To: CF-Talk Subject: Search Engines Hi All, this may be a bit off topic, but i need/advise on where and how i can register a site in the top search engines. I know there are all these sites where you can do it but do you have recommendations? My other question is, why do we have to pay for this, or what does paying provide from those where you don't have to pay do? I thought there were robots that go around linking from page to page and indexing the webpages..so that when a search is run the pages relevant are found, so what does paying do? thanks! Heidi Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-ar
Re: Ways to pass variables
wddx or cookie On Mon, 24 Sep 2001, Mike Tangorre wrote: > hidden form fields > > > - Original Message - > From: "Michael S. Kimmett" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 1:02 PM > Subject: Ways to pass variables > > > > Ok, one more question. I have a client that does not want variables > > passed through the URL ( security reasons ). But I am having problems > > passing a variable through a form (see previous message). Session > > variables are a not permitted on thie project. Does anyone have another > > idea on how to move variables and their values from page to page? > > > > Thanks in advance. > > > > --Michael > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ways to pass variables
well then client vars is another way. -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 1:30 PM To: CF-Talk Subject: Re: Ways to pass variables Hidden form fields can be views in the HTML page source view...so not ideal for security reasons either. It's less blatantly obvious but still viewable to prying eyes. Bruce [EMAIL PROTECTED] - Original Message - From: "Mike Tangorre" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 10:23 AM Subject: Re: Ways to pass variables > hidden form fields > > > - Original Message - > From: "Michael S. Kimmett" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 1:02 PM > Subject: Ways to pass variables > > > > Ok, one more question. I have a client that does not want variables > > passed through the URL ( security reasons ). But I am having problems > > passing a variable through a form (see previous message). Session > > variables are a not permitted on thie project. Does anyone have another > > idea on how to move variables and their values from page to page? > > > > Thanks in advance. > > > > --Michael > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ways to pass variables
good call Bruce, that thought didn't even come into mind.. :-) - Original Message - From: "Bruce Holm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 1:30 PM Subject: Re: Ways to pass variables > Hidden form fields can be views in the HTML page source view...so not ideal > for security reasons either. It's less blatantly obvious but still viewable > to prying eyes. > > Bruce > [EMAIL PROTECTED] > > - Original Message - > From: "Mike Tangorre" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 10:23 AM > Subject: Re: Ways to pass variables > > > > hidden form fields > > > > > > - Original Message - > > From: "Michael S. Kimmett" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, September 24, 2001 1:02 PM > > Subject: Ways to pass variables > > > > > > > Ok, one more question. I have a client that does not want variables > > > passed through the URL ( security reasons ). But I am having problems > > > passing a variable through a form (see previous message). Session > > > variables are a not permitted on thie project. Does anyone have another > > > idea on how to move variables and their values from page to page? > > > > > > Thanks in advance. > > > > > > --Michael > > > > > > > > > ~~ 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: Passing the results from the
At 10:28 AM 9/24/01 -0700, you wrote: >There are multiple ways to pass it. What directory info are you wanting to >pass? All the information from the Name, Type etc. >You can pass info from one template to another via: > Session vars > Client vars > Application vars > Form fields > URL parameters > etc > >You may want to store the directory info you want into a structure or array, >scope it as a Session variable, then reference it on the next template. Yikes. How do I do that? >Bruce >[EMAIL PROTECTED] > >- Original Message - >From: <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Monday, September 24, 2001 10:00 AM >Subject: Re: Passing the results from the > > > How can I pass the results from the > > > Name > > Size > > Type..etc > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WDDX
Hello Duane, http://www.w3.org/TR/REC-xml is the XML specifications, I haven't seen any specific limits while transmitting a packet via WDDX. I would just take note of the physical connection available (T1, 56k, etc), as if the packet is too big you'll wind up causing timeouts, possible dataloss, etc. Cheers, Mike Randolph AbleCommerce Duane Boudreau wrote: > Is there any limit to the length that a string can be inside a wddx packet? > > TIA, > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing the results from the
Hi, You could save them in a session variable or pass them in a form field. Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 September 2001 18:01 To: CF-Talk Subject: Re: Passing the results from the 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: Ways to pass variables
Hidden form fields can be views in the HTML page source view...so not ideal for security reasons either. It's less blatantly obvious but still viewable to prying eyes. Bruce [EMAIL PROTECTED] - Original Message - From: "Mike Tangorre" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 10:23 AM Subject: Re: Ways to pass variables > hidden form fields > > > - Original Message - > From: "Michael S. Kimmett" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 1:02 PM > Subject: Ways to pass variables > > > > Ok, one more question. I have a client that does not want variables > > passed through the URL ( security reasons ). But I am having problems > > passing a variable through a form (see previous message). Session > > variables are a not permitted on thie project. Does anyone have another > > idea on how to move variables and their values from page to page? > > > > Thanks in advance. > > > > --Michael > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error 232
Hi, I am getting NT error 232 when I run some of the pages in my CF application. I have looked through the archive and see several other people have suffered from it but none of the suggested answers seem to cure it. Does anyone know what causes it ? Kevin Roche ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Passing the results from the
There are multiple ways to pass it. What directory info are you wanting to pass? You can pass info from one template to another via: Session vars Client vars Application vars Form fields URL parameters etc You may want to store the directory info you want into a structure or array, scope it as a Session variable, then reference it on the next template. Bruce [EMAIL PROTECTED] - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 10:00 AM Subject: Re: Passing the results from the How can I pass the results from the > Name > Size > Type..etc > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CPU 100% notification?
Is there a fix for the 100%CPU problem with CF 4.5 yet? Also does anyone know of a way to send a notification email when the CF server pegs at 100%CPU and wont come back down? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ways to pass variables
hidden form fields - Original Message - From: "Michael S. Kimmett" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 1:02 PM Subject: Ways to pass variables > Ok, one more question. I have a client that does not want variables > passed through the URL ( security reasons ). But I am having problems > passing a variable through a form (see previous message). Session > variables are a not permitted on thie project. Does anyone have another > idea on how to move variables and their values from page to page? > > Thanks in advance. > > --Michael > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ways to pass variables
How about client variables? - Original Message - From: "Michael S. Kimmett" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 12:02 PM Subject: Ways to pass variables > Ok, one more question. I have a client that does not want variables > passed through the URL ( security reasons ). But I am having problems > passing a variable through a form (see previous message). Session > variables are a not permitted on thie project. Does anyone have another > idea on how to move variables and their values from page to page? > > Thanks in advance. > > --Michael > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ways to pass variables
Ok, one more question. I have a client that does not want variables passed through the URL ( security reasons ). But I am having problems passing a variable through a form (see previous message). Session variables are a not permitted on thie project. Does anyone have another idea on how to move variables and their values from page to page? Thanks in advance. --Michael ~~ 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
Software Migration
Hello. Our company is upgrading from SQL Server 7.0 to SQL Server 2K and from Cold Fusion 4.01 to Cold Fusion 5.0. Does anyone know a site online or any documentation discussing upgrading issues? What I am mainly concerned with is how things will function when we upgrade. What are the differences between the above mentioned versions... any comparison charts out there? Thanks for any help. Mike Tangorre ~~ 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: Passing the results from the
How can I pass the results from the http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cf removing extra spaces
Does anyone know how to keep CF from stripping extra spaces (ie. seven) from a form submission? I am trying to get a form to submit a value (example: abc 123) to java object, but when I get the output before I go to the java object I see (example: abc 123). Is there any way to keep this from happening? BTW: When I insert ascii spaces to the value before I send the value through the form, the form keeps the extra white space but Java can not read the ascii characters. I am using CF4.5 and the CFFORM tags. Thanks in advance. --Michael ~~ 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: CFCASE Issue
The syntax of cfswitch/cfcase is ... ... ... The only place where other statements should go is in the ... If you place statements anywhere else within the cfswitch/cfcase construct, then the interpreter doesn't really know how to interpret it and you'll get an error message (if you're lucky) Even though your cfcase and cftransaction appear properly nested, you should think of the cfcase and cfswitch together as a complex tag, and inserting the cftransaction in the middle between the two messes up the nesting. --- Bruce Sorge <[EMAIL PROTECTED]> wrote: > OK.This error message is pretty straightforward: > CFCASE > > CFCASE tag cannot appear after a CFDEFAULTCASE tag. > > The error occurred while processing an element with > a general identifier > of (CFCASE), occupying document position (24:2) to > (24:28). > > However the issue is that I do NOT have a > CFDEFAULTCASE tag ANYWHERE in > the application. My code is as follows: > > > > >procedure="DeleteBCON"> > cfsqltype="CF_SQL_INTEGER" > value="#Form.Autonumber#"> > > >procedure="ReInsertOldTest"> > cfsqltype="CF_SQL_INTEGER" > value="#Form.Autonumber#"> > > >procedure="DeleteBCONOld"> > cfsqltype="CF_SQL_INTEGER" > value="#Form.Autonumber#"> > > > > > So what I did was to switch the CFTRANSACTION and > the CFCASE tags > around, and the application worked. Could someone > please tell me what > gives? I am happy that it worked, but I am just > curious why I was told > that there was a problem with a tag when that tag is > not present. > > Thanks, > > Bruce = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: E-mail Services
You might want to take a look at what my company does - UltraDNS. We do DNS hosting and URL/email forwarding services - you could create and forward as many aliases as needed into a 3rd party email account. In fact, you could just use 'wildcard' forwarding and point *@yourdomain.com to one email account elsewhere. Cost starts @ $10 a month. And we're 100% CF-powered. :) - Rachel Luxemburg Sr. Product Manager, UltraDNS http://www.ultradns.com Voice: (650) 227-2684 -Original Message- From: Jackson Moore (CFTalk) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 7:14 AM To: CF-Talk Subject: OT: E-mail Services I am looking for any recommendations you cf-talk guys might have about e-mail services for hosting the e-mail for my domain. I share a co-located server with a few other developers for work we do on the side and we have been running our own mail server for awhile, but because we use this box for development purposes, it isn't up 100% of the time. I'd like to continue to do my own web hosting, but would like to move my e-mail hosting to another provider. The ISP that hosts our server does all our DNS so I should be able to have my mail directed to another server. I would like to be able to add and manage my e-mail accounts over the web, be able to access mail from a typical POP3 client, but also have a web-based interface for checking mail when I'm without my laptop. Any suggestions or recommendations you'd like to share - I'd appreciate it. Thanks Jackson Moore [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: E-mail Services
It's part of the package. Yes, the registration fee is the top price ($35/year), where you can instead get yearly fees for much lower, but getting web-based DNS and one free email address (web & POP3 accessible) is worth the extra few bucks a year. And they seem to have their TTL set pretty low, so changes seem to propagate quickly. And no, this isn't a sales pitch. :) Your individual mileage may vary. Kevin - Original Message - From: "Gary Kraeger" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 9:21 AM Subject: Re: E-mail Services > Kevin: > > Were do you find there web based dns > > gary > - Original Message - > From: "Kevin Derby" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 11:24 AM > Subject: Re: E-mail Services > > > > My personal suggestion: shift your domain registrar to register.com. The > > have web-based DNS, relatively cheap email hosting, and it's all > web-driven. > > Everything you list is available. > > > > Kevin > > > > - Original Message - > > From: "Jackson Moore (CFTalk)" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, September 24, 2001 7:13 AM > > Subject: OT: E-mail Services > > > > > > > I am looking for any recommendations you cf-talk guys might have > > > about e-mail services for hosting the e-mail for my domain. > > > > > > I share a co-located server with a few other developers for work > > > we do on the side and we have been running our own mail server > > > for awhile, but because we use this box for development > > > purposes, it isn't up 100% of the time. I'd like to continue to > > > do my own web hosting, but would like to move my e-mail hosting > > > to another provider. The ISP that hosts our server does all our > > > DNS so I should be able to have my mail directed to another > > > server. > > > > > > I would like to be able to add and manage my e-mail accounts over > > > the web, be able to access mail from a typical POP3 client, but > > > also have a web-based interface for checking mail when I'm > > > without my laptop. > > > > > > Any suggestions or recommendations you'd like to share - I'd > > > appreciate it. > > > > > > Thanks > > > > > > Jackson Moore > > > [EMAIL PROTECTED] > > > > > > > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Absolute Path Usage
You need a mapping setup in the CF Administrators by the hosting company, if they will do that for you. -Gary > -Original Message- > From: Bruce Holm [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 11:30 AM > To: CF-Talk > Subject: Absolute Path Usage > > > I have a NT based hosting company hosting a domain for me. They support > CF and Access for the db. > When I use CFINCLUDE relative paths work fine. But I'm finding that if > I specify an absolute path starting with the web root "/" it doesn't > find the template. For example I have a "global" directory in the top > level directory. If I try to CFINCLUDE template="/global/foo.cfm" it > won't find it. > > How can I use absolute paths in this situation? Is there a function or > code segment that will tell me how to reference templates using an > absolute path? I tried the GetBaseTemplatePath() function but it > returns a path from the machine root "d:\html\users\...\html\..." which > when used as an absolute path doesn't seem to work either. > > - > Bruce Holm - Web Programmer > Lattice Semiconductor Corp. > [EMAIL PROTECTED] > - > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WDDX
Is there any limit to the length that a string can be inside a wddx packet? TIA, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio 5.0
Its now a Release Candidate, so not sure you still can beta it, but try contacting [EMAIL PROTECTED] or [EMAIL PROTECTED] Will -Original Message- From: Mike Tangorre [mailto:[EMAIL PROTECTED]] Sent: 23 September 2001 22:12 To: CF-Talk Subject: Studio 5.0 Does anyone know the email to get in contact with Allaire to betatest studio 5.0.. is it still in beta? I am a student here at Alfred University and we use CF down in the Web department, and we were considering beta testing. When I goto Beta.Allaire.com, I cannot find an email or number to call in order to get in touch with them. Any help would be appreciated. Thanks, Mike Tangorre ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Absolute Path Usage
I have a NT based hosting company hosting a domain for me. They support CF and Access for the db. When I use CFINCLUDE relative paths work fine. But I'm finding that if I specify an absolute path starting with the web root "/" it doesn't find the template. For example I have a "global" directory in the top level directory. If I try to CFINCLUDE template="/global/foo.cfm" it won't find it. How can I use absolute paths in this situation? Is there a function or code segment that will tell me how to reference templates using an absolute path? I tried the GetBaseTemplatePath() function but it returns a path from the machine root "d:\html\users\...\html\..." which when used as an absolute path doesn't seem to work either. - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [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: E-mail Services
Kevin: Were do you find there web based dns gary - Original Message - From: "Kevin Derby" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 11:24 AM Subject: Re: E-mail Services > My personal suggestion: shift your domain registrar to register.com. The > have web-based DNS, relatively cheap email hosting, and it's all web-driven. > Everything you list is available. > > Kevin > > - Original Message - > From: "Jackson Moore (CFTalk)" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 7:13 AM > Subject: OT: E-mail Services > > > > I am looking for any recommendations you cf-talk guys might have > > about e-mail services for hosting the e-mail for my domain. > > > > I share a co-located server with a few other developers for work > > we do on the side and we have been running our own mail server > > for awhile, but because we use this box for development > > purposes, it isn't up 100% of the time. I'd like to continue to > > do my own web hosting, but would like to move my e-mail hosting > > to another provider. The ISP that hosts our server does all our > > DNS so I should be able to have my mail directed to another > > server. > > > > I would like to be able to add and manage my e-mail accounts over > > the web, be able to access mail from a typical POP3 client, but > > also have a web-based interface for checking mail when I'm > > without my laptop. > > > > Any suggestions or recommendations you'd like to share - I'd > > appreciate it. > > > > Thanks > > > > Jackson Moore > > [EMAIL PROTECTED] > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing a recordset INTO an Oracle Stored Procedure
Deanna,
Sorry, the proper code snippet should look like this:
empRS = QueryNew("l_emp_number,l_first_name");
for(i = 1;i lte 3;i = i + 1){
QueryAddRow(empRS);
QuerySetCell(empRS,"l_emp_number",i);
QuerySetCell(empRS,"l_first_name","Tester" & i);
}
And the Oracle Stored procedure is defined something like this:
TYPE tRecordset IS REF CURSOR;
..
PROCEDURE Test1(
In_Employee IN tRecordset)
IS
l_Emp_Number varchar2(100);
l_First_Name varchar2(100);
BEGIN
loop
fetch In_Employee into l_Emp_Number, l_First_Name;
insert into flextesttable
values
(l_Emp_Number,l_First_Name);
exit when In_Employee%notfound;
end loop;
close In_Employee;
end if;
commit;
END Test1;
The above code still produces the Oracle Error:
ORA-24338: statement handle not executed
And this is caused by the "fetch..." line, where Oracle is saying you cannot
fetch from this ref cursor, until it is opened, except a ref cursor by
definition is already open.
If you know of any way that a recordset can be passed in to an Oracle Stored
Procedure, I would be will ing to give it a try.
Thanks,
Maurice.
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 6:39 AM
To: CF-Talk
Subject: Re: Passing a recordset INTO an Oracle Stored Procedure
Maurice,
In your code, you indicate no value is being passed in. Is that what you
meant to indicate? I would guess that Oracle would balk at an in parameter
with no value unless you have a default value set up in your stored proc.
> <-Really? No value?
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Certified Master ColdFusion 5 Developer
I found this to be the case as well. I took the CF5 exam a little over a month ago. My Web App Construction Kit 4.0 book had been long well-worn (the 5.0 version came out a week or two after my exam, so I didn't have it in advance). My Developer Study Guide was read cover-to-cover twice and I also had read the (wrox) Professional CF 5.0 book. Even though I *thought* I had covered all the "new" 5.0 features in the Professional CF 5.0 book (and liked the book very much), I still saw stuff on the exam that I had never seen before. References to tags I didn't know if they truly existed (in 5.0) or were just a trick and some other 5.0 features that I was like, "huh?" to. I don't know. Maybe Ben's 5.0 book covers more of the 5.0 features than the Professional book does. If so, I would recommend studying with that. I think Chris' suggestion of just going through the CF documentation would benefit anyone preparing for the exam, as well. My two cents. Kamie Chris Bohill wrote: > One of the Guys in our place took the exam recently. He had been using > the Study book as well, but found that there were a substantial number > of Questions relating to new features within CF5, which the current > study guide does not cover. > > My advice would be to print off a copy of the new CF5 features (Tags and > Functions) and learn them in conjunction with the study guide. > > Cheers, > > Chris Bohill > BIZNET > > -Original Message- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] > Sent: 24 September 2001 15:48 > To: CF-Talk > Subject: RE: Certified Master ColdFusion 5 Developer > > On the line of the Allaire certification, I've always wondered on one > thing. > The sample exam at forta.com has 25 questions and (that I can see) does > not > enforce a time limit. Maybe I've just always answered within the > restrictions, tho. > > How many questions are there on the exam, or is that not something that > can > be said? I'm a volunteer examiner for the Amateur Radio community and > our > exams are set up so that there are x number of questions out of each > section > (there are 10 sections for each exam), totaling y. Is it something like > that for the Allaire cert? > > I have the study book and am planning on taking my test sometime in the > next > 3-6 months, as time allows. > > If these questions are out of line then I apologize ahead of time. > > Hatton Humphrey > > > Brainbnech is easy comparatively, you get like 60 or 90 seconds per > > question. I just took the Allaire CF 5.0 exam and did not do so > > well... the > > questions for the cf 5 exam (form allaire) are much harder than those > at > > Brainbench. > > > > :-) > > > > Mike > > > > > has anyone taken both tests, how do they compare for difficulty? > > > Mark > > > > > > Brainbench and Allaires test are like apples and oranges.. :-) > > > > Brainbench do a Master Cert - I can't remember my score but it was > > > > enough. > > > > > > > > Tristram Charnley > > ~~ 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
query of query and aliasing
Hi folks, I've searched for this answer, but haven't been able to find anything. Does query of query not support aliasing? If I try to do either a table or a column alias, I get an error: SELECTa.shortdate, a.totalmilkavg as youravg, b.totalmilkavg as allavg FROMmyresults a, myresults b WHEREb.shortdate = a.shortdate ANDa.yours = 1 ANDb.yours = 0 This is the error I get: PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag If I do a version that eliminates the self-join and the column alias, it works just fine. Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf and apache
For the windows version of the module? -jesse -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 11:16 AM To: CF-Talk Subject: RE: cf and apache After a few conversations MM agreed to compile it and said it would be available in a few weeks. That was at the end of August. I have asked for an update but have not gotten a reply. Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 12:25 PM To: CF-Talk Subject: RE: cf and apache Actually, now that you mention it, I forgot about that EAPI thing going on. I get the error on startup (only when using the OpenSSL compiled version) about the module, but it's been running fine and we've been hitting it pretty hard. What's the latest on the replacement module? > Which version of apache are you running and what platform? I have found > that SSL on win32 with 1.3.20 apache required an EAPI Cold Fusion module and > MM has not yet made it available (though they said that they would after the > discussions on the list and some back and forth with their support people). > > Justin > > -Original Message- > From: Tony Schreiber [mailto:[EMAIL PROTECTED]] > Sent: Saturday, September 22, 2001 9:43 PM > To: CF-Talk > Subject: RE: cf and apache > > Works great with SSL too. No problems. It was a little tricky setting it > up the first time, but I'm using OpenSSL with no issues. > > And of course, the first time, I was trying to import certificates created > with Netscape server. THAT was a fun thing to do. > > > Works great so long as you do not need SSL. Been running it for almost 3 > > years without a problem. > > > > -Original Message- > > From: Ben Whalley [mailto:[EMAIL PROTECTED]] > > Sent: Friday, September 21, 2001 9:53 AM > > To: CF-Talk > > Subject: cf and apache > > > > How much experience do people have with CF and Apache? Anything to be > aware > > of if switching from IIS. We are just about to buy a new box and with all > > these nightmares people are having with nimba etc thought it might be a > good > > idea. > > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: File information
Sure, just use CGI.SCRIPT_NAME. Or: thispage = getfilefrompath(getbasetemplatepath()); === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Kevin Derby [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 11:04 AM > To: CF-Talk > Subject: Re: File information > > > Can you make this truly dynamic, where you feed it the name > of itself (via CGI variable) to get the datelastmodified field? > > Kevin > > - Original Message - > From: "Raymond Camden" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 5:48 AM > Subject: RE: File information > > > > You can use CFDIRECTORY, pass it a filter with the file > name, and you > > will get information back. If you are using CF5 on Windows, you can > > find a few UDFs to get this information as well. > > > > http://www.cflib.org/library.cfm?ID=8 > > > > > == > > = > > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > > > Email: [EMAIL PROTECTED] > > Yahoo IM : morpheus > > > > "My ally is the Force, and a powerful ally it is." - Yoda > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, September 24, 2001 8:23 AM > > > To: CF-Talk > > > Subject: Re: File information > > > > > > > > > Hi, > > > > > > Is there a CF tag that displays all the information on a > file (name, > > > size, last modified..etc)? I have some Javascript code that does > > > this, but was > > > just wondering if there was some CF code. > > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: E-mail Services
My personal suggestion: shift your domain registrar to register.com. The have web-based DNS, relatively cheap email hosting, and it's all web-driven. Everything you list is available. Kevin - Original Message - From: "Jackson Moore (CFTalk)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 7:13 AM Subject: OT: E-mail Services > I am looking for any recommendations you cf-talk guys might have > about e-mail services for hosting the e-mail for my domain. > > I share a co-located server with a few other developers for work > we do on the side and we have been running our own mail server > for awhile, but because we use this box for development > purposes, it isn't up 100% of the time. I'd like to continue to > do my own web hosting, but would like to move my e-mail hosting > to another provider. The ISP that hosts our server does all our > DNS so I should be able to have my mail directed to another > server. > > I would like to be able to add and manage my e-mail accounts over > the web, be able to access mail from a typical POP3 client, but > also have a web-based interface for checking mail when I'm > without my laptop. > > Any suggestions or recommendations you'd like to share - I'd > appreciate it. > > Thanks > > Jackson Moore > [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: SQL - Oracle Functions
Not one function, but a combination of two should serve your purpose... select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'), A.event_type, A.event, B.name, B.description from table_a A, table_b B where upper(B.name) = substr(upper(a.event), instr(a.event, '.', -1), 2) A quick explanation, substr(string, start position, length) We know the field and the length, so now we need the start position instr(string, field to find, start position) Putting a start position of -1 tells oracle to work from the end of the list. Hope this works, since I don't have your data to test. If you still have problems, let me know. Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 10:46 AM To: CF-Talk Subject: SQL - Oracle Functions Let me see if I can explain this clearly...I am trying to join 2 tables, using a field from table A to match just a part of a field in table B (re-working of my tables and what I store will fix this, but I want to see if it can be done in my current setup) select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'), A.event_type, A.event, B.name, B.description from table_a A, table_b B where B.name = "a part of A.event" A.event is a long string of data, stored from a system log, which I can parse out the name for display purposes with the following cf code: #Ucase(ListLast(GetToken(event, 2, chr(10)), '.'))# select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'), A.event_type, A.event, B.name, B.description from table_a A, table_b B where upper(B.name) = '#Ucase(ListLast(GetToken(A.event, 2, chr(10)), '.'))#' The above does not work, since it does not know the value of A.event. Are there any Oracle functions that can achieve this result? If not I will just rework the table to parse out the name prior to insertion and store it in table A to do a straight join (A.name = B.name) Thanks, Scott ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFCASE Issue
OK.This error message is pretty straightforward: CFCASE CFCASE tag cannot appear after a CFDEFAULTCASE tag. The error occurred while processing an element with a general identifier of (CFCASE), occupying document position (24:2) to (24:28). However the issue is that I do NOT have a CFDEFAULTCASE tag ANYWHERE in the application. My code is as follows: So what I did was to switch the CFTRANSACTION and the CFCASE tags around, and the application worked. Could someone please tell me what gives? I am happy that it worked, but I am just curious why I was told that there was a problem with a tag when that tag is not present. Thanks, Bruce ~~ 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: Recursively calling CFCONTENT
> I have a list of PDF documents I want the user to be able to > download using CFCONTENT. I've been unable to write the code > to recursively call CFCONTENT since no code after that tag is > executed. Is there a way to do this? Should I be looking at > some other method to accomplish this? Any suggestions are > appreciated. No, you can't recursively call CFCONTENT via server-side code. Basically, for any one HTTP request, you can only send one HTTP response. You could perhaps get the outcome you want using a combination of JavaScript, frames and CFCONTENT, however. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFSILENT
Hi Bruce - no problem for the mail, I'm just glad it helped clear a few
things up. The general rule I use to decide whether or not to build the
content as a big string and then dump it either incrementally or at the
end is a bit rough but basically:
If the template/custom tag is primarily a data processing tag with little
output, build the string.
If the template/custom tag is primarily an output tag with little data
processing then just write the output directly.
For anything in between I break the page down into chunks where each
major chunk is either data or output and apply the rule that way. When
it's easier just to write out the content directly I'll maybe manually
remove some of the white space between tags so I have longer lines of
harder-to-read code but when it's only a CFSET or two, sometimes the
ease justifies it. For more complex code though I would never do that.
It's a question of balancing how legible your code is against the
quality of the HTML generated.
Another useful tag (albeit hardly used I would bet) is
CFPROCESSINGDIRECTIVE.
You can use this tag to suppress additional white space generated by CFML
and I think if you were to turn this on before you go into your CFLOOP,
it would help a great deal. This is actually one of those tags that I
would be inclined to back you on your comments about the lang ref :) It's
worth trying the tag in a few different places to see how to use it since
the manual is a bit vague on it but it _is_ useful.
If you have access to your CF Administration, ensure that "Suppress
white space by default" is enabled as this seems to save you some work.
A final suggestion on the example you gave below would be to replace
your blocks of CFSETs with CFSCRIPTs. There's a general consensus that
3 or more CFSETs in a row will be faster as a block of assignments in
a CFSCRIPT block, i.e. if you replace:
with
PrevUpdateType = 0;
subHeaderLine = "";
CurVID = qGetUserAgents.vid;
ProcAMIDList = "";
You should see a performance gain. Of course for 4 CFSETs you're not really
going to see a 10ms gain in isolation but in the long term, and more so as
the number of assignments scales up, you will see a benefit.
What you might not realise though is that any code within a CFSCRIPT block
produces no white space! So the code above written as
PrevUpdateType = 0;
subHeaderLine = "";
CurVID = qGetUserAgents.vid;
ProcAMIDList = "";
would look exactly the same as the code above when viewed in the HTML source
produced! I'm one of those people who loves CFSCRIPT (a load of people love
it, a load of people hate it) and unless I'm performing a single CFSET,
I use it all the time since the syntax is much cleaner, especially for
struct operations and functions that return no value.
In fact, looking at the code you posted again, you could replace all of
it by a CFSCRIPT switch block, using WriteOutput() to render the document
headers, i.e.
// Check if the type changed...time to put up a new sub-header label if so
if( stAMIDdocUType[CurAMID] neq PrevUpdateType )
{
switch( stAMIDdocUType[CurAMID] )
{
case "1":
{
WriteOutput( 'New Documents:' );
subHeaderLine = cr
& "New Information (placed on the website since "
& Dateformat(LastReportDate, 'mmm dd, ')
& " 12:00am):";
SummaryLabel = "Description: ";
break;
}
case "2":
{
WriteOutput( 'Modified Documents:' );
subHeaderLine = cr
& "Modified Information (since "
& Dateformat(LastReportDate, 'mmm dd, ')
& " 12:00am):";
SummaryLabel = "Modifications: ";
break;
}
}
}
// Construct the email message body for TEXT email msg and store
// it in a structure indexed by VID
// ... etc. ...
> As for my comments about the Language Ref Manual...
> The CFSILENT tag is one example. You gave me more info that the book
> and it's important info.
No problem ;)
Another place to read for useful function info is the release notes.
4.5.1 SP-2 introduced a few new struct functions which are just sooo
useful. It looks like they were added to implement a few of Spectra's
slower custom tags as C++ functions, but whatever the reason, StructSort
and StructKeyFind are just too handy.
For a lang ref which hopefully has more of the info you need try getting
the CF5 docs from the Allaire site unless you're already using CF5 of
course.
I've not had a chance to really jump into 5 since the beta program but the
core functions are largely the same so hopefully the docs will have been
updated.
> For another example, take a look at the CreateODBCDa
Re: Find in-coming form fields
- Original Message - From: "Steven Monaghan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 9:33 AM Subject: Find in-coming form fields > I have a situation where I need to accept a form, but I don't know the names > of the form fields that are set. > > I can't access the posting form, since it's hidden in someone else's app, so > I can't find the names that way. I want to build a simple page where I can > accept the post, then dump out all of the values in memory into an e-mail. > I looked at the tag, but that requires the variable name. > > I'm new to Cold Fusion, so please indulge me if this is a simple task. > > Thanks for any help, > Steve > - > Steven Monaghan > Oracle DBA / Cold Fusion Developer > MSC Industrial Direct Co., Inc. > Melville, NY > [EMAIL PROTECTED] > http://www.mscdirect.com > - > > > This e-mail is intended for the use of the addressee(s) only and may contain > privileged, confidential, or proprietary information that is exempt from > disclosure under law. If you are not the intended recipient, please do not > read, copy, use or disclose the contents of this communication to others. > Please notify the sender that you have received this e-mail in error by > replying to the e-mail. Please then delete the e-mail and destroy any > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL - Oracle Functions
You could probably do something like this with a combination of instr and substr...something like upper(substr(a.event, 2, instr(a.event, chr(10))) But, my guess is that you're going to end up with a boggy query. As a temporary fix, I'd create another field in your table, run the above on a.event and populate the field. You can write a trigger to do this automatically when a new item is added to the database, too. Hope that helps. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf and apache
After a few conversations MM agreed to compile it and said it would be available in a few weeks. That was at the end of August. I have asked for an update but have not gotten a reply. Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 12:25 PM To: CF-Talk Subject: RE: cf and apache Actually, now that you mention it, I forgot about that EAPI thing going on. I get the error on startup (only when using the OpenSSL compiled version) about the module, but it's been running fine and we've been hitting it pretty hard. What's the latest on the replacement module? > Which version of apache are you running and what platform? I have found > that SSL on win32 with 1.3.20 apache required an EAPI Cold Fusion module and > MM has not yet made it available (though they said that they would after the > discussions on the list and some back and forth with their support people). > > Justin > > -Original Message- > From: Tony Schreiber [mailto:[EMAIL PROTECTED]] > Sent: Saturday, September 22, 2001 9:43 PM > To: CF-Talk > Subject: RE: cf and apache > > Works great with SSL too. No problems. It was a little tricky setting it > up the first time, but I'm using OpenSSL with no issues. > > And of course, the first time, I was trying to import certificates created > with Netscape server. THAT was a fun thing to do. > > > Works great so long as you do not need SSL. Been running it for almost 3 > > years without a problem. > > > > -Original Message- > > From: Ben Whalley [mailto:[EMAIL PROTECTED]] > > Sent: Friday, September 21, 2001 9:53 AM > > To: CF-Talk > > Subject: cf and apache > > > > How much experience do people have with CF and Apache? Anything to be > aware > > of if switching from IIS. We are just about to buy a new box and with all > > these nightmares people are having with nimba etc thought it might be a > good > > idea. > > > > > > ~~ 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: SQL - Oracle Functions
try this. It works in Oracle's SQL: .. where A.event like '%' || B.name || '%' (Beware, though, any indexes you have on A.event and B.name may not work in this sort of statement. Run it through Oracle's Explain Plan to see.) Maurice. -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 7:46 AM To: CF-Talk Subject: SQL - Oracle Functions Let me see if I can explain this clearly...I am trying to join 2 tables, using a field from table A to match just a part of a field in table B (re-working of my tables and what I store will fix this, but I want to see if it can be done in my current setup) select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'), A.event_type, A.event, B.name, B.description from table_a A, table_b B where B.name = "a part of A.event" A.event is a long string of data, stored from a system log, which I can parse out the name for display purposes with the following cf code: #Ucase(ListLast(GetToken(event, 2, chr(10)), '.'))# select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'), A.event_type, A.event, B.name, B.description from table_a A, table_b B where upper(B.name) = '#Ucase(ListLast(GetToken(A.event, 2, chr(10)), '.'))#' The above does not work, since it does not know the value of A.event. Are there any Oracle functions that can achieve this result? If not I will just rework the table to parse out the name prior to insertion and store it in table A to do a straight join (A.name = B.name) Thanks, Scott ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find in-coming form fields
When a form is submitted CF provides a variable, "FieldNames", which
includes a comma-separated list of all the form fields. You could do
something like this if you wanted to find out what you were getting:
#curfield# - #Evaluate("form.#curfield#")#
C. Hatton Humphrey, Developer
Fisher, Towne & Associates
716-839-2141 x336
[EMAIL PROTECTED]
> -Original Message-
> From: Steven Monaghan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 24, 2001 10:34 AM
> To: CF-Talk
> Subject: Find in-coming form fields
>
>
> I have a situation where I need to accept a form, but I don't
> know the names
> of the form fields that are set.
>
> I can't access the posting form, since it's hidden in someone
> else's app, so
> I can't find the names that way. I want to build a simple page
> where I can
> accept the post, then dump out all of the values in memory into an e-mail.
> I looked at the tag, but that requires the variable name.
>
> I'm new to Cold Fusion, so please indulge me if this is a simple task.
>
> Thanks for any help,
> Steve
> -
> Steven Monaghan
> Oracle DBA / Cold Fusion Developer
> MSC Industrial Direct Co., Inc.
> Melville, NY
> [EMAIL PROTECTED]
> http://www.mscdirect.com
> -
>
>
> This e-mail is intended for the use of the addressee(s) only and
> may contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law. If you are not the intended recipient,
> please do not
> read, copy, use or disclose the contents of this communication to others.
> Please notify the sender that you have received this e-mail in error by
> replying to the e-mail. Please then delete the e-mail and destroy any
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: File information
Can you make this truly dynamic, where you feed it the name of itself (via CGI variable) to get the datelastmodified field? Kevin - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 5:48 AM Subject: RE: File information > You can use CFDIRECTORY, pass it a filter with the file name, and you > will get information back. If you are using CF5 on Windows, you can find > a few UDFs to get this information as well. > > http://www.cflib.org/library.cfm?ID=8 > > === > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > Email: [EMAIL PROTECTED] > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 24, 2001 8:23 AM > > To: CF-Talk > > Subject: Re: File information > > > > > > Hi, > > > > Is there a CF tag that displays all the information on a file > > (name, size, > > last modified..etc)? I have some Javascript code that does > > this, but was > > just wondering if there was some CF code. > > > ~~ 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: Certified Master ColdFusion 5 Developer
One of the Guys in our place took the exam recently. He had been using the Study book as well, but found that there were a substantial number of Questions relating to new features within CF5, which the current study guide does not cover. My advice would be to print off a copy of the new CF5 features (Tags and Functions) and learn them in conjunction with the study guide. Cheers, Chris Bohill BIZNET -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: 24 September 2001 15:48 To: CF-Talk Subject: RE: Certified Master ColdFusion 5 Developer On the line of the Allaire certification, I've always wondered on one thing. The sample exam at forta.com has 25 questions and (that I can see) does not enforce a time limit. Maybe I've just always answered within the restrictions, tho. How many questions are there on the exam, or is that not something that can be said? I'm a volunteer examiner for the Amateur Radio community and our exams are set up so that there are x number of questions out of each section (there are 10 sections for each exam), totaling y. Is it something like that for the Allaire cert? I have the study book and am planning on taking my test sometime in the next 3-6 months, as time allows. If these questions are out of line then I apologize ahead of time. Hatton Humphrey > Brainbnech is easy comparatively, you get like 60 or 90 seconds per > question. I just took the Allaire CF 5.0 exam and did not do so > well... the > questions for the cf 5 exam (form allaire) are much harder than those at > Brainbench. > > :-) > > Mike > > > has anyone taken both tests, how do they compare for difficulty? > > Mark > > > > Brainbench and Allaires test are like apples and oranges.. :-) > > > Brainbench do a Master Cert - I can't remember my score but it was > > > enough. > > > > > > Tristram Charnley ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
