converting xls to csv
I have codes for saving in XLS, but need to change it in CSV format. What do you need to change? cfsavecontent variable=results cfcontent type=application/vnd.ms-excel table tr themployee/th thfirstname/th thmiddlename/th thlastname/th thaddr1/th thaddr2/th thcity/th thstate/th thzip/th thhmphonenbr/th thdatehired/th thtermdate/th thdepartment/th thdepartmen2/th thjobcode/th thjobdescrip/th thempstatus/th themergconta/th themergphone/th /tr cfoutput query=GetTP2000 tr td#employee#/td td#firstname#/td td#middlename#/td td#lastname#/td td#addr1#/td td#addr2#/td td#city#/td td#state#/td td#zip#/td td#hmphonenbr#/td td#datehired#/td td#termdate#/td td#department#/td td#departmen2#/td td#jobcode#/td td#jobdescrip#/td td#empstatus#/td td#emergconta#/td td#emergphone#/td /tr /cfoutput /table /cfsavecontent /body /html Cffile action=write file=D:\ bla.Get.xls output=#results# I need to keep the column headers above. tia ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247843 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfsearch help
Thank you so much all. jl On 7/6/06, Rob Wilkerson [EMAIL PROTECTED] wrote: John - open a word doc that isn't indexing with the title you'd like. Once it's open, click File Properties and you should be able to access the metadata. I told you that from memory, but if it's not correct let me know and I'll run it down further. On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: I don't use Word myself, just Writer, but there are Document Properties for each Word doc. Reindexing: Verity creates an index, much like what you would see in a book. Now imagine you add a new chapter to the book. Obviously the index has to be updated. Ditto for removing a chapter. The CFINDEX tag lets you perform operations to an existing index that will update the content. So basically the idea is this: When your app is being created, you typically do an index creation that gets ALL the data. Then in your Add/Edit/Delete operations, you update the index. If you download my Verity preso from last week, you will see I have an example CFC in there that shows this in action. On 7/6/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, How do you check the meta data? Can you tell me the steps for re-indexing? Thanks much. jl On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: Open the word documents and check the meta data. Ensure it is set to what you think it is. Also, do not forget that if you change the information, you then need to update the index. Verity won't know the file has changed unless you ask it to reindex the file. On 7/5/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, Did you check the documents with bad titles to make sure that they are set up right? I have tried many different ways, but no luck so far. How do you check bad titles? jl On 7/3/06, Raymond Camden [EMAIL PROTECTED] wrote: So you are saying sometimes the title is right, and sometimes not? Verity tries to find the title from the metadata of the document when indexing. Did you check the documents with bad titles to make sure that they are set up right? As for your second question, yes, using CF7. Simply add the contextPassages attribute to your cfsearch tag and check the contest column of the result. Oh - and get rid of that evalute. You can change it to maxRows = #Form.MaxRows + 1# On 7/1/06, John Lucania [EMAIL PROTECTED] wrote: I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245805 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfmail with attachment
I need to run this on the Scheduled Task daily. bla... cfcontent type=application/vnd.ms-excel table tr themployee/th thfirstname/th thmiddlename/th thlastname/th thaddr1/th thaddr2/th thcity/th thstate/th thzip/th thhmphonenbr/th thdatehired/th thtermdate/th thdepartment/th thdepartmen2/th thjobcode/th thjobdescrip/th thempstatus/th themergconta/th themergphone/th /tr cfoutput query=GetSourceDemoInfo tr td#myemployee#/td td#myfirstname#/td td#mymiddlename#/td td#mylastname#/td td#myaddr1#/td td#myaddr2#/td td#mycity#/td td#mystate#/td td#myzip#/td td#myhmphonenbr#/td td#mydatehired#/td td#mytermdate#/td td#mydepartment#/td td#mydepartmen2#/td td#myjobcode#/td td#myjobdescrip#/td td#myempstatus#/td td#myemergconta#/td td#myemergphone#/td /tr /cfoutput /table bla... How do you save the result onto a directory as an Excel file? Also, how do you e-mail this file as an attachment? tia jl ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245806 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmail with attachment
snake, The file name is TPHRDataExtractGet.xls. How do you attach it in cfmail?? jl On 7/8/06, Snake [EMAIL PROTECTED] wrote: Wrap it in cfsavecontent, then use cffile to save it. Then use cfmail to mail it. snake -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: 08 July 2006 17:54 To: CF-Talk Subject: cfmail with attachment I need to run this on the Scheduled Task daily. bla... cfcontent type=application/vnd.ms-excel table tr themployee/th thfirstname/th thmiddlename/th thlastname/th thaddr1/th thaddr2/th thcity/th thstate/th thzip/th thhmphonenbr/th thdatehired/th thtermdate/th thdepartment/th thdepartmen2/th thjobcode/th thjobdescrip/th thempstatus/th themergconta/th themergphone/th /tr cfoutput query=GetSourceDemoInfo tr td#myemployee#/td td#myfirstname#/td td#mymiddlename#/td td#mylastname#/td td#myaddr1#/td td#myaddr2#/td td#mycity#/td td#mystate#/td td#myzip#/td td#myhmphonenbr#/td td#mydatehired#/td td#mytermdate#/td td#mydepartment#/td td#mydepartmen2#/td td#myjobcode#/td td#myjobdescrip#/td td#myempstatus#/td td#myemergconta#/td td#myemergphone#/td /tr /cfoutput /table bla... How do you save the result onto a directory as an Excel file? Also, how do you e-mail this file as an attachment? tia jl ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245826 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfmail with attachment
Super, Daniel! John On 7/8/06, Daniel Kang [EMAIL PROTECTED] wrote: John, cfmailparam file=TPHRDataExtractGet.xls Hope this helps! Daniel On 7/8/06, John Lucania [EMAIL PROTECTED] wrote: snake, The file name is TPHRDataExtractGet.xls. How do you attach it in cfmail?? jl On 7/8/06, Snake [EMAIL PROTECTED] wrote: Wrap it in cfsavecontent, then use cffile to save it. Then use cfmail to mail it. snake -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: 08 July 2006 17:54 To: CF-Talk Subject: cfmail with attachment I need to run this on the Scheduled Task daily. bla... cfcontent type=application/vnd.ms-excel table tr themployee/th thfirstname/th thmiddlename/th thlastname/th thaddr1/th thaddr2/th thcity/th thstate/th thzip/th thhmphonenbr/th thdatehired/th thtermdate/th thdepartment/th thdepartmen2/th thjobcode/th thjobdescrip/th thempstatus/th themergconta/th themergphone/th /tr cfoutput query=GetSourceDemoInfo tr td#myemployee#/td td#myfirstname#/td td#mymiddlename#/td td#mylastname#/td td#myaddr1#/td td#myaddr2#/td td#mycity#/td td#mystate#/td td#myzip#/td td#myhmphonenbr#/td td#mydatehired#/td td#mytermdate#/td td#mydepartment#/td td#mydepartmen2#/td td#myjobcode#/td td#myjobdescrip#/td td#myempstatus#/td td#myemergconta#/td td#myemergphone#/td /tr /cfoutput /table bla... How do you save the result onto a directory as an Excel file? Also, how do you e-mail this file as an attachment? tia jl ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245829 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
File ftp from cfserver to a data server
I have an .xls file on cfserver and need to ftp the file to database server daily (= to be on the Schedule Task). The source path is \\intranet\dfs\HR\EMPList.xls and the target path is \\IntraEDU\E:\EMPData how do you accomplish this task? tia jl ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245830 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfsearch help
Raymond, How do you check the meta data? Can you tell me the steps for re-indexing? Thanks much. jl On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: Open the word documents and check the meta data. Ensure it is set to what you think it is. Also, do not forget that if you change the information, you then need to update the index. Verity won't know the file has changed unless you ask it to reindex the file. On 7/5/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, Did you check the documents with bad titles to make sure that they are set up right? I have tried many different ways, but no luck so far. How do you check bad titles? jl On 7/3/06, Raymond Camden [EMAIL PROTECTED] wrote: So you are saying sometimes the title is right, and sometimes not? Verity tries to find the title from the metadata of the document when indexing. Did you check the documents with bad titles to make sure that they are set up right? As for your second question, yes, using CF7. Simply add the contextPassages attribute to your cfsearch tag and check the contest column of the result. Oh - and get rid of that evalute. You can change it to maxRows = #Form.MaxRows + 1# On 7/1/06, John Lucania [EMAIL PROTECTED] wrote: I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245515 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfsearch help
I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245210 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cftry and cfcatch
Thank you so much, Pine et al. It works wonderful. jl On 2/8/06, John McKown [EMAIL PROTECTED] wrote: Sounds like you do not want TRY/CATCH... that is triggered on a failure. You really want to use CFSWITCH/CFCASE. -- John McKown President, Delaware.Net ICQ: 1812513 We host Fusebox.org and all of our apps are Fusebox/ColdFusion/BlueDragon compliant. John Lucania wrote: I have two queries: cfquery name=checksrv datasource=master SELECT @@SERVICENAME; /cfquery cfquery name=checkage datasource=master SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfquery I want to be notified through cfmail if 1) query checksrv doesn't return MSSQLSERVER then, MSSQLSERVER not returned in cfmail or query checkage doesn't return 2 then, Agent not returned 2 in cfmail or both of checksrv and checkage don't return then, MSSQLSERVER not returned and Agent not returned 2 in cfmail or 2) query checksrv cannot be run then, MSSQLSERVER Not Avail in cfmail or query checkage cannot be run then, Agent Not Avail in cfmail or both of checksrv and checkage cannot be run then, MSSQLSERVER Not Avail and Agent Not Avail in cfmail. Any ideas? tia, jl ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cftry and cfcatch
I have two queries: cfquery name=checksrv datasource=master SELECT @@SERVICENAME; /cfquery cfquery name=checkage datasource=master SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfquery I want to be notified through cfmail if 1) query checksrv doesn't return MSSQLSERVER then, MSSQLSERVER not returned in cfmail or query checkage doesn't return 2 then, Agent not returned 2 in cfmail or both of checksrv and checkage don't return then, MSSQLSERVER not returned and Agent not returned 2 in cfmail or 2) query checksrv cannot be run then, MSSQLSERVER Not Avail in cfmail or query checkage cannot be run then, Agent Not Avail in cfmail or both of checksrv and checkage cannot be run then, MSSQLSERVER Not Avail and Agent Not Avail in cfmail. Any ideas? tia, jl ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfmx services issue
Will/does cycling these services (ColdFusion MX Application Server, ColdFusion MX ODBC Agent, and/or ColdFusion MX ODBC Server) on CFMX Server cause the sql server agent/services of the sql database server connected to the CFMX Server stop and restart? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231425 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfmx services issue
Thanks so much! jl On 2/6/06, Adrian Lynch [EMAIL PROTECTED] wrote: I'd say no. The SQL services will stay as they are. Ade -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: 06 February 2006 15:08 To: CF-Talk Subject: cfmx services issue Will/does cycling these services (ColdFusion MX Application Server, ColdFusion MX ODBC Agent, and/or ColdFusion MX ODBC Server) on CFMX Server cause the sql server agent/services of the sql database server connected to the CFMX Server stop and restart? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231443 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL Server Monitor with CFMX
With CFMX, is there a way to monitor when SQL Server Agent/Service are stopped and stared? It seems that all of the information is stored at C:\Program Files\Microsoft SQL Server\MSSQL\LOG. Thank you, jl ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231562 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL Server Monitoring with CF
I want to monitor the sql server connected to CFMX. What I want is: - the total sizes the sql server drives - free sizes the drives - size of each database in cfmail. Any ideas? Please advise. jl ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX Server Monitoring
I want to monitor the CPU and Memory usage of CFMX Server when the CPU (i.e. 30%) and Memory (i.e. 100,000K) usage hits certain threshold so that I can know who runs heavy duty jobs and which process takes resources. I want this info in cfmail. Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Displaying data from XLS file
I have a datasource created with XLS as below: SELECT * FROM [HRJobPostings$] IN 'd:\\Inetpub\wwwroot\HRJobPostings\HRJobPostings.xls' 'EXCEL 5.0;' In a row for the column, Additional, it has: Experience should also include: configuring and monitoring of Cisco switches, routers, wireless, firewalls, VPN, and IDS; maintaining network security; developing and maintaining documentation related to the network; developing and managing organization-wide software deployment; being on call in support of a 24 x 7 organization. but when it is being displayed, it ONLY shows: Experience should also include: configuring and monitoring of Cisco switches, routers, wireless, firewalls, VPN, and IDS; maintaining network security; developing and maintaining documentation related to the network; developing and managing organization-w Why is ide software deployment; being on call in support of a 24 x 7 organization. not showing up? This means only 255 characters are showing up. I thought that it is the limitation with 'EXCEL 5.0;', but with this: SELECT * FROM [HRJobPostings$] IN 'd:\\Inetpub\wwwroot\HRJobPostings\HRJobPostings.xls' 'EXCEL 8.0;' I am getting the same result. How do you resolve this? jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227389 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfc
Can someone briefly educate me what is cfc, why we are using it, and pros and cons? jl ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226232 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfc
Thanks so much all. jl On 12/6/05, Andy Matthews [EMAIL PROTECTED] wrote: John... Here's a few links to get you started: http://www.macromedia.com/devnet/coldfusion/cfcs.html http://www.sitepoint.com/article/components-introduction http://www.sitepoint.com/forums/showthread.php?t=237829 and a google search: http://www.google.com/search?hl=enlr=rls=GGLG%2CGGLG%3A2005-20%2CGGLG%3Aen q=what+is+a+cfc%2C+coldfusion !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 12:01 PM To: CF-Talk Subject: cfc Can someone briefly educate me what is cfc, why we are using it, and pros and cons? jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cffile Error
\\SWPRINT\LAB_HEMA is a network printer. cfexecute works fine as long as there is a file. I think the issue is Cffile action=write file=D:\Inetpub\WWWROOT\BBDatabase\results.txt output=#results# doesn't generate a file. jl On 12/3/05, ColdFusion [EMAIL PROTECTED] wrote: Does ColdFusion Service have access to the network drive? \\SWPRINT\LAB_HEMA ??? -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Saturday, December 03, 2005 1:35 AM To: CF-Talk Subject: Cffile Error C:\CFusionMX\runtime\bincopy D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA The system cannot find the file specified. cfquery name=GetQryList datasource=BloodBank select * from PTBB where len(MRN) = 7 order by Lname /cfquery cfsavecontent variable=results table border=0 align=center tr td colspan=6 div align=centerbAuto-print Testing cfoutputat #TimeFormat(CreateODBCTime(Now()), HH:mm:ss tt)# on #DateFormat(CreateODBCDate(Now()), MM-DD-)#/cfoutput/b/div /td /tr tr td bgcolor=CC div align=centerbName/b/div /td td bgcolor=CC div align=centerbABO/b/div /td td bgcolor=CC div align=centerbRH/b/div /td td bgcolor=CC div align=centerbAntigen/b/div /td td bgcolor=CC div align=centerbAntibody/b/div /td /tr cfoutput query=GetQryList tr td bgcolor=FF#LName#, #FName#/td td bgcolor=FF#ABO#/td td bgcolor=FF#RH#/td td bgcolor=FF#Antigen#/td td bgcolor=FF#Antibody#/td /tr /cfoutput /table strong div align=centercfoutputfont color=99#GetQryList.RecordCount#/font/cfoutputfont color=99 Records Found/font/div /strong /cfsavecontent Cffile action=write file=D:\Inetpub\WWWROOT\BBDatabase\results.txt output=#results# cfexecute name=c:\copy.bat arguments=D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA outputfile=c:\BBBatch.txt/cfexecute How do you resolve this error? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226021 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cffile Error
Duh :-) You're right. jl On 12/3/05, Bobby Hartsfield [EMAIL PROTECTED] wrote: That would definitely cause a problem :) You are missing a quote at the end of your cffile tag after #results# ~Bobby ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Saturday, December 03, 2005 1:01 PM To: CF-Talk Subject: Re: Cffile Error \\SWPRINT\LAB_HEMA is a network printer. cfexecute works fine as long as there is a file. I think the issue is Cffile action=write file=D:\Inetpub\WWWROOT\BBDatabase\results.txt output=#results# doesn't generate a file. jl On 12/3/05, ColdFusion [EMAIL PROTECTED] wrote: Does ColdFusion Service have access to the network drive? \\SWPRINT\LAB_HEMA ??? -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Saturday, December 03, 2005 1:35 AM To: CF-Talk Subject: Cffile Error C:\CFusionMX\runtime\bincopy D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA The system cannot find the file specified. cfquery name=GetQryList datasource=BloodBank select * from PTBB where len(MRN) = 7 order by Lname /cfquery cfsavecontent variable=results table border=0 align=center tr td colspan=6 div align=centerbAuto-print Testing cfoutputat #TimeFormat(CreateODBCTime(Now()), HH:mm:ss tt)# on #DateFormat(CreateODBCDate(Now()), MM-DD-)#/cfoutput/b/div /td /tr tr td bgcolor=CC div align=centerbName/b/div /td td bgcolor=CC div align=centerbABO/b/div /td td bgcolor=CC div align=centerbRH/b/div /td td bgcolor=CC div align=centerbAntigen/b/div /td td bgcolor=CC div align=centerbAntibody/b/div /td /tr cfoutput query=GetQryList tr td bgcolor=FF#LName#, #FName#/td td bgcolor=FF#ABO#/td td bgcolor=FF#RH#/td td bgcolor=FF#Antigen#/td td bgcolor=FF#Antibody#/td /tr /cfoutput /table strong div align=centercfoutputfont color=99#GetQryList.RecordCount#/font/cfoutputfont color=99 Records Found/font/div /strong /cfsavecontent Cffile action=write file=D:\Inetpub\WWWROOT\BBDatabase\results.txt output=#results# cfexecute name=c:\copy.bat arguments=D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA outputfile=c:\BBBatch.txt/cfexecute How do you resolve this error? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226032 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Cffile Error
C:\CFusionMX\runtime\bincopy D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA The system cannot find the file specified. cfquery name=GetQryList datasource=BloodBank select * from PTBB where len(MRN) = 7 order by Lname /cfquery cfsavecontent variable=results table border=0 align=center tr td colspan=6 div align=centerbAuto-print Testing cfoutputat #TimeFormat(CreateODBCTime(Now()), HH:mm:ss tt)# on #DateFormat(CreateODBCDate(Now()), MM-DD-)#/cfoutput/b/div /td /tr tr td bgcolor=CC div align=centerbName/b/div /td td bgcolor=CC div align=centerbABO/b/div /td td bgcolor=CC div align=centerbRH/b/div /td td bgcolor=CC div align=centerbAntigen/b/div /td td bgcolor=CC div align=centerbAntibody/b/div /td /tr cfoutput query=GetQryList tr td bgcolor=FF#LName#, #FName#/td td bgcolor=FF#ABO#/td td bgcolor=FF#RH#/td td bgcolor=FF#Antigen#/td td bgcolor=FF#Antibody#/td /tr /cfoutput /table strong div align=centercfoutputfont color=99#GetQryList.RecordCount#/font/cfoutputfont color=99 Records Found/font/div /strong /cfsavecontent Cffile action=write file=D:\Inetpub\WWWROOT\BBDatabase\results.txt output=#results# cfexecute name=c:\copy.bat arguments=D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA outputfile=c:\BBBatch.txt/cfexecute How do you resolve this error? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226007 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfexecute error
What I am trying to do is sending print jobs to a network printer as a
scheduled task.
jl
On 11/30/05, Michael Traher [EMAIL PROTECTED] wrote:
Can you explain a bit more what you are trying to achieve?
I notice in docs for cfexecute that paths in examples all have \\ double
backslahes in windows paths. not sure why but...
On 11/30/05, John Lucania [EMAIL PROTECTED] wrote:
Can anyone help on this?
An exception occurred when invoking an external process.
The cause of this exception was that: java.io.IOException:
CreateProcess: c:\copy.bat
D:\Inetpub\WWWROOT\BBDatabase\QueryBatch.cfm 10.1.125.25 error=2.
The error occurred in D:\Inetpub\WWWROOT\BBDatabase\BBBatch.cfm: line 1
1 : cfexecute name=c:\copy.bat
arguments=#ExpandPath('QueryBatch.cfm')# 10.1.125.25
outputfile=c:\BBBatch.txt/cfexecute
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225692
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfexecute error
Can anyone help on this?
An exception occurred when invoking an external process.
The cause of this exception was that: java.io.IOException:
CreateProcess: c:\copy.bat
D:\Inetpub\WWWROOT\BBDatabase\QueryBatch.cfm 10.1.125.25 error=2.
The error occurred in D:\Inetpub\WWWROOT\BBDatabase\BBBatch.cfm: line 1
1 : cfexecute name=c:\copy.bat
arguments=#ExpandPath('QueryBatch.cfm')# 10.1.125.25
outputfile=c:\BBBatch.txt/cfexecute
2 :
*QueryBatch.cfm is below: **
cfquery name=GetQryList datasource=BloodBank
select *
from PTBB
where len(MRN) = 7
order by Lname
/cfquery
table border=0 align=center
tr
td colspan=6
div align=centerMarian, this is a test. Please let me know if you got
this one! Thank you, Daniel /div
/td
/tr
tr
td bgcolor=CC
div align=centerbName/b/div
/td
td bgcolor=CC
div align=centerbABO/b/div
/td
td bgcolor=CC
div align=centerbRH/b/div
/td
td bgcolor=CC
div align=centerbAntigen/b/div
/td
td bgcolor=CC
div align=centerbAntibody/b/div
/td
/tr
cfoutput query=GetQryList
tr
td bgcolor=FF#LName#, #FName#/td
td bgcolor=FF#ABO#/td
td bgcolor=FF#RH#/td
td bgcolor=FF#Antigen#/td
td bgcolor=FF#Antibody#/td
/tr
/cfoutput
/table
strong
div align=centercfoutputfont
color=99#GetQryList.RecordCount#/font/cfoutputfont
color=99
Records Found/font/div
/strong
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225658
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Monitor DSN
I often experience that Data Source Names got lost the connectivity due to various reasons such as power outage, reboot, network blip, etc. Is there a way to monitor the DSN connectivity loss through Scheduled Tasks (sending CFMAIL) or something else? It is CFMX. jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Monitor DSN
Mike, Can you share your codes with me? jl On 11/26/05, Mike Chabot [EMAIL PROTECTED] wrote: I have a monitor page in each of my applications that is called from an external server every five minutes. The monitor page runs a few essential queries to test database connectivity. If a query fails, I get an E-mail sent from the external server. If the entire page fails, I try to call an HTML page in that directory to see if the server is up. You could also buy a product like Whats Up Gold http://www.ipswitch.com/products/whatsup/index.asp to monitor your database server. -Mike Chabot On 11/26/05, John Lucania [EMAIL PROTECTED] wrote: I often experience that Data Source Names got lost the connectivity due to various reasons such as power outage, reboot, network blip, etc. Is there a way to monitor the DSN connectivity loss through Scheduled Tasks (sending CFMAIL) or something else? It is CFMX. jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225318 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Monitor CF Sever Directories
That is super. Thanks a bunch, Artur. jl On 11/22/05, Artur Kordowski [EMAIL PROTECTED] wrote: Hi John, to get total size, free space, files folders dates you can use the FileSystemObject CFC. It use the Windows COM API that makes you possible to get File System informations. You can download it here: http://download.newsight.de/FileSystemObject.zip A documentation is included. I hope it helps you. Cheers, Artur -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 22, 2005 2:00 AM To: CF-Talk Subject: Monitor CF Sever Directories How do you monitors the files systems (total size vs free space and the name of files with date of created/modified, size, and extension in the directories) of all directories on all drives on the CF server? jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224954 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FileSystemObject CFC v1.0 released
Artur, Can you show me how to put this in CFMAIL? I've tried a couple of ways, but no success. jl On 11/21/05, Artur Kordowski [EMAIL PROTECTED] wrote: I'm pleased to inform you about the release of the FileSystemObject CFC v1.0. With this CFC you can use the functionality of the Windows FileSystemObject COM API. The CFC including a detailed documentation is immediately available for download. Enjoy! http://download.newsight.de/FileSystemObject.zip Cheers, Artur ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225050 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SMS CF
I am utilizing a Microsoft Exchange Server for the cfmail connection, which has SMTP as the default protocol. Is there a way to change/specify the default protocol (SMTP) to something else, like SMS? jl ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224817 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SMS CF
So, SMTP is the only option in cfmail or can we change the protocol? jl On 11/21/05, Dawson, Michael [EMAIL PROTECTED] wrote: I don't really think there is a default protocol with Exchange, or any mail server. You choose to connect to Exchange using SMTP/POP/IMAP/MAPI/OWA/CDO/etc. I think you just need to choose one of those. If you are using CFMAIL, then you inherently use SMTP. M!ke -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Monday, November 21, 2005 10:29 AM To: CF-Talk Subject: SMS CF I am utilizing a Microsoft Exchange Server for the cfmail connection, which has SMTP as the default protocol. Is there a way to change/specify the default protocol (SMTP) to something else, like SMS? jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224819 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SMS CF
I am sending messages (e-mail) to pagers and getting many garbled messages on the pager. I have talked the wireless vendor, but it seems they don't know how to fix other than telling me to change the protocol. jl On 11/21/05, Sean Corfield [EMAIL PROTECTED] wrote: On 11/21/05, John Lucania [EMAIL PROTECTED] wrote: I am utilizing a Microsoft Exchange Server for the cfmail connection, which has SMTP as the default protocol. Is there a way to change/specify the default protocol (SMTP) to something else, like SMS? SMTP *is* the outbound mail protocol by definition. Exchange is an SMTP server. If you want to talk SMS, you'd need an SMS server. cfmail can talk to SMTP servers and POP3 servers (inbound mail). The SMS event gateway can talk to an SMS server. SMS != mail. Could you explain what problem you are trying to solve? -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224825 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Monitor CF Sever Directories
How do you monitors the files systems (total size vs free space and the name of files with date of created/modified, size, and extension in the directories) of all directories on all drives on the CF server? jl ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Automatically directed to a network printer
Tom, ok, can you show me an example? jl On 11/16/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Tuesday 15 November 2005 18:27, John Lucania wrote: It is MX on Windows 2003. I think you can still copy the file to prt: (with cfexecute) then. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224314 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Automatically directed to a network printer
I need hard copy printout of a cf query page monthly. Can it be automatically directed to a network printer and let it print out? jl ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224184 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Automatically directed to a network printer
That is great. It is MX on Windows 2003. jl On 11/15/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Tuesday 15 November 2005 15:24, John Lucania wrote: I need hard copy printout of a cf query page monthly. Can it be automatically directed to a network printer and let it print out? Yes. As you don't mention what O/S or version of CF you have, it is hard to be specific. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224222 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[SOT] avg hourly rate for mid and adv cf programmer
Morning, Gurus! What is the avg hourly rate for mid and adv cf programmer for gov/non-for-profit contract work in Wash DC area and surburb?The hourly rate won't include any benefits or whatsoever. jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223024 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SOT] avg hourly rate for mid and adv cf programmer
Holly. who is getting $200 or more? The salary is almost ~ $.5 mil then. jl On 11/3/05, Lee [EMAIL PROTECTED] wrote: I've heard of rates anywhere from $30 to $200 or more for established firms. I've also heard of much less for over seas contractors. Congress is looking at adding another 210,000 or so HB1 Visas which could trend those numbers lower. Lee On Thu, 3 Nov 2005 09:55:15 -0600 Kevin Aebig [EMAIL PROTECTED] wrote: Not sure about the DC area, but up here I go with $35/hour CDN which comes out to about 4 cents US... Kevin -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: November 3, 2005 9:39 AM To: CF-Talk Subject: [SOT] avg hourly rate for mid and adv cf programmer Morning, Gurus! What is the avg hourly rate for mid and adv cf programmer for gov/non-for-profit contract work in Wash DC area and surburb?The hourly rate won't include any benefits or whatsoever. jl ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223045 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SOT] avg hourly rate for mid and adv cf programmer
hmmm, makes sense. what if it is telecommuting work? jl On 11/3/05, dave [EMAIL PROTECTED] wrote: I know here in colorado that some firms have problems getting anyone if they only offer $45-$50 an hour w/benfits. Working on your own you should be able to charge $70-$150 an hour. I mostly base it off on a per page basis. basic set up fee $500 - $1000, basic template, css, xhtml, basic db, etc... $175 a page for cfm pages flash and other things like photo galleries and stuff is a minimal charge. Extensive graphics, I add on and pay my graphics guys $50 an hour. ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Tim Heald [EMAIL PROTECTED] Sent: Thursday, November 03, 2005 1:21 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: [SOT] avg hourly rate for mid and adv cf programmer I personally wouldn't take less than $60 an hour if it's a one person consulting gig. It would be less for someone that doesn't have a clearance around here. If your talking about a development company your probably looking around $130-$150 an hour, if it's W2 and the company is going to take care of social security and all that. Tim Heald [EMAIL PROTECTED] ColdFusion Developer Signal Solutions, Inc Work : 202-224-1224 Cell : 703-765-0618 -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 10:39 AM To: CF-Talk Subject: [SOT] avg hourly rate for mid and adv cf programmer Morning, Gurus! What is the avg hourly rate for mid and adv cf programmer for gov/non-for-profit contract work in Wash DC area and surburb? The hourly rate won't include any benefits or whatsoever. jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223053 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Scheduled Tasks CFMAIL
How do you get the messages, whether Scheduled Tasks were run successfully or not, via e-mail? If successful, name and time of Scheduled Tasks If failed, name and time of Scheduled Tasks and failed messages = why failed jl ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMAIL Suppress
Is it possible to suppress the content of CFMAIL? I am sending pages to end-users, and they don't need to see From:[EMAIL PROTECTED], Subject:, something that kinds of known stuff. jl ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: javax.mail.SendFailedException: 550 5.7.1
I mentioned that ** If I open Outlook and send e-mail to [EMAIL PROTECTED] and [EMAIL PROTECTED], messages go through with no issue. ** and ** If I send messages with CFMAIL, I get the error above. ** Then, the question I have which one (Outlook Server or CFMX Server) is generating the error? CFMX Server passes the message to Outlook Server fine, but is Outlook Server rejecting it and send it back to CFMX Server? Or, CFMX Server is rejecting it before sending to Outlook Server? jl On 10/13/05, Paul Vernon [EMAIL PROTECTED] wrote: This is probably a permissions issue or the relay settings on you mail server not including the IP of your CF server. Either you need to supply a username and password to the CF server in the CFMAIL admin area to authenticate with your mail server or you need to set up your mail server to let CF relay through it without authenticating. Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220883 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: javax.mail.SendFailedException: 550 5.7.1
Thanks a bunch, Daniel and others. Firewall was the cause. Relay was shut off. Daniel On 10/13/05, Daniel Kang [EMAIL PROTECTED] wrote: Have you checked firewall? Daniel On 10/13/05, Mark Fuqua [EMAIL PROTECTED] wrote: I don't know if this will help you, but it sure seems timely (posted early this morning) http://www.danvega.org/blog/client/index.cfm/2005/10/12/Sending-mail-with-CF Mail-A-problem--A-solution Mark Fuqua ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF CR
Crystal Reports (CR) running off of Oracle database is in place to run and get necessary queries and reports. However, unfortunately, the direct database connection between CF and the Oracle DB is not allowed per the contract (duh). The only connection I can have is though CR. How can you 1) connect CR 2) execute the CR as a scheduled task 3) get the query output 4) dump the query output into SQL DB? jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220959 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMAIL type: text/plain; charset=UTF-8
I am sending messages like below with CFMAIL. The format is type:
text/plain; charset=UTF-8. A few messages were received with weird
formats.
It must be From:[EMAIL PROTECTED], but From: bomA.
It must be Subject: Discharge, but Subject:Dh{{ha{gma-t_2~A(_10a?
What might have caused this?
jl
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220969
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMAIL type: text/plain; charset=UTF-8
from where???
jl
On 10/13/05, Bobby Hartsfield [EMAIL PROTECTED] wrote:
A bot is a likely culprit
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: John Lucania [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 7:30 PM
To: CF-Talk
Subject: CFMAIL type: text/plain; charset=UTF-8
I am sending messages like below with CFMAIL. The format is type:
text/plain; charset=UTF-8. A few messages were received with weird
formats.
It must be From:[EMAIL PROTECTED], but From: bomA.
It must be Subject: Discharge, but Subject:Dh{{ha{gma-t_2~A(_10a?
What might have caused this?
jl
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220973
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Date field allowing entry today or past
How do you make a date field allowing no entry beyond today? The date must be today or past, not future. jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220974 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMAIL type: text/plain; charset=UTF-8
LoL
jl
On 10/13/05, Dana [EMAIL PROTECTED] wrote:
The French are also popular in this respect.
On 10/13/05, Bobby Hartsfield [EMAIL PROTECTED] wrote:
I don't know... let's just blame Canada? :)
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 7:45 PM
To: CF-Talk
Subject: RE: CFMAIL type: text/plain; charset=UTF-8
A bot is a likely culprit
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: John Lucania [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 7:30 PM
To: CF-Talk
Subject: CFMAIL type: text/plain; charset=UTF-8
I am sending messages like below with CFMAIL. The format is type:
text/plain; charset=UTF-8. A few messages were received with weird
formats.
It must be From:[EMAIL PROTECTED], but From: bomA.
It must be Subject: Discharge, but Subject:Dh{{ha{gma-t_2~A(_10a?
What might have caused this?
jl
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220982
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Date field allowing entry today or past
Thank you, Tony Bobby -- That will work! jl On 10/13/05, Tony [EMAIL PROTECTED] wrote: some sort of javascript function that would do an onBlur event, if the fields value is a date and is now() then make the value = null, and send an alert() that notifies them of the error. tony from wish-i-could-write-javascript.com :( On 10/13/05, Bobby Hartsfield [EMAIL PROTECTED] wrote: cfif thedate lte now() It's a past or present date cfelse It's a future date /cfif ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 8:53 PM To: CF-Talk Subject: Date field allowing entry today or past How do you make a date field allowing no entry beyond today? The date must be today or past, not future. jl ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
javax.mail.SendFailedException: 550 5.7.1
cfloop query=A03 cfset THEFIN = A03.PTFIN cfset THEMRN = A03.PTMRN CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=No CFMAIL SUBJECT= Discharge FROM=[EMAIL PROTECTED] TO=[EMAIL PROTECTED]; [EMAIL PROTECTED] BCC=[EMAIL PROTECTED] Type =plain cfmailparam name=Reply-to value= [EMAIL PROTECTED] #PTRoomNo# /CFMAIL /CFPROCESSINGDIRECTIVE cfquery name=A03Yes datasource=PTINFO update PTINFOIncident set MsgSent ='Yes' where PTFIN ='#THEFIN#' and PTMRN = '#THEMRN#' /cfquery /cfloop Why is this generating this error? Invalid Addresses; nested exception is: javax.mail.SendFailedException: 550 5.7.1 Unable to relay for [EMAIL PROTECTED] ; nested exception is: javax.mail.SendFailedException: 550 5.7.1 Unable to relay for [EMAIL PROTECTED] If I open Outlook and send e-mail to [EMAIL PROTECTED] and [EMAIL PROTECTED], messages go through with no issue. If I send messages with CFMAIL, I get the error above. CF is connecting Outlook server, so I thought it should work fine. mailsend.log says: Moved undelivered mail: Mail62781.cfmail to C:\CFusionMX/Mail/Undelivr directory Mail62781.cfmail says: server: swexchange:25 from: [EMAIL PROTECTED] to: [EMAIL PROTECTED],[EMAIL PROTECTED] bcc: [EMAIL PROTECTED] subject: Discharge type: text/plain; charset=UTF-8 X-Mailer: ColdFusion MX Application Server body: body:N205 body: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220871 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
