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? employee firstname middlename lastname addr1 addr2 city state zip hmphonenbr datehired termdate department departmen2 jobcode jobdescrip empstatus emergconta emergphone #employee# #firstname# #middlename# #lastname# #addr1# #addr2# #city# #state# #zip# #hmphonenbr# #datehired# #termdate# #department# #departmen2# #jobcode# #jobdescrip# #empstatus# #emergconta# #emergphone# 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
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: cfmail with attachment
Super, Daniel! John On 7/8/06, Daniel Kang <[EMAIL PROTECTED]> wrote: > John, > > > > 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... > > > > > > > > > > > > > > > employee > > > firstname > > > middlename > > > lastname > > > addr1 > > > addr2 > > > city > > > state > > > zip > > > hmphonenbr > > > datehired > > > termdate > > > department > > > departmen2 > > > jobcode > > > jobdescrip > > > empstatus > > > emergconta > > > emergphone > > > > > > > > > > > > #myemployee# > > > #myfirstname# > > > #mymiddlename# > > > #mylastname# > > > #myaddr1# > > > #myaddr2# > > > #mycity# > > > #mystate# > > > #myzip# > > > #myhmphonenbr# > > > #mydatehired# > > > #mytermdate# > > > #mydepartment# > > > #mydepartmen2# > > > #myjobcode# > > > #myjobdescrip# > > > #myempstatus# > > > #myemergconta# > > > #myemergphone# > > > > > > > > > > > > > > > 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
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... > > > > > employee > firstname > middlename > lastname > addr1 > addr2 > city > state > zip > hmphonenbr > datehired > termdate > department > departmen2 > jobcode > jobdescrip > empstatus > emergconta > emergphone > > > > #myemployee# > #myfirstname# > #mymiddlename# > #mylastname# > #myaddr1# > #myaddr2# > #mycity# > #mystate# > #myzip# > #myhmphonenbr# > #mydatehired# > #mytermdate# > #mydepartment# > #mydepartmen2# > #myjobcode# > #myjobdescrip# > #myempstatus# > #myemergconta# > #myemergphone# > > > > > 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
cfmail with attachment
I need to run this on the Scheduled Task daily. bla... employee firstname middlename lastname addr1 addr2 city state zip hmphonenbr datehired termdate department departmen2 jobcode jobdescrip empstatus emergconta emergphone #myemployee# #myfirstname# #mymiddlename# #mylastname# #myaddr1# #myaddr2# #mycity# #mystate# #myzip# #myhmphonenbr# #mydatehired# #mytermdate# #mydepartment# #mydepartmen2# #myjobcode# #myjobdescrip# #myempstatus# #myemergconta# #myemergphone# 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: 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. > > > > > > > > > > > > > > > > > > > > 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
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. > > > > > > > > > > > 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
Re: cfsearch help
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. > > > > > 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:245471 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. 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: > > > > > >SELECT @@SERVICENAME; > > > > > > > >SELECT count (program_name) > >FROM master.dbo.sysprocesses > >WITH (NOLOCK) > >WHERE program_name LIKE '%Agent%' > > > > > >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: SELECT @@SERVICENAME; SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' 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
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
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
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
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
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
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
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=en&lr=&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
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: 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. > > works fine as long as there is a file. > > I think the issue is 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\bin>copy > > D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA The system > > cannot find the file specified. > > > > select * from PTBB > where > > len(MRN) = 7 order by Lname > > > > > > > > Auto-print Testing at > > #TimeFormat(CreateODBCTime(Now()), "HH:mm:ss tt")# on > > #DateFormat(CreateODBCDate(Now()), "MM-DD-")# > > > > > > > > > > Name > > > > > > ABO > > > > > > RH > > > > > > Antigen > > > > > > Antibody > > > > > > > > > > #LName#, #FName# > > #ABO# > > #RH# > > #Antigen# > > #Antibody# > > > > > > > > > > > color="99">#GetQryList.RecordCount# > color="99"> > > Records Found > > > > > > > > > file="D:\Inetpub\WWWROOT\BBDatabase\results.txt" output="#results#> > > > > > arguments="D:\Inetpub\WWWROOT\BBDatabase\results.txt > > \\SWPRINT\LAB_HEMA" outputfile="c:\BBBatch.txt"> > > > > 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
Re: Cffile Error
\\SWPRINT\LAB_HEMA is a network printer. works fine as long as there is a file. I think the issue is mailto:[EMAIL PROTECTED] > Sent: Saturday, December 03, 2005 1:35 AM > To: CF-Talk > Subject: Cffile Error > > C:\CFusionMX\runtime\bin>copy > D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA The system > cannot find the file specified. > > select * from PTBB where > len(MRN) = 7 order by Lname > > > > Auto-print Testing at > #TimeFormat(CreateODBCTime(Now()), "HH:mm:ss tt")# on > #DateFormat(CreateODBCDate(Now()), "MM-DD-")# > > > > > Name > > > ABO > > > RH > > > Antigen > > > Antibody > > > > > #LName#, #FName# > #ABO# > #RH# > #Antigen# > #Antibody# > > > > > color="99">#GetQryList.RecordCount# color="99"> > Records Found > > > > file="D:\Inetpub\WWWROOT\BBDatabase\results.txt" output="#results#> > > arguments="D:\Inetpub\WWWROOT\BBDatabase\results.txt > \\SWPRINT\LAB_HEMA" outputfile="c:\BBBatch.txt"> > > 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
Cffile Error
C:\CFusionMX\runtime\bin>copy D:\Inetpub\WWWROOT\BBDatabase\results.txt \\SWPRINT\LAB_HEMA The system cannot find the file specified. select * from PTBB where len(MRN) = 7 order by Lname Auto-print Testing at #TimeFormat(CreateODBCTime(Now()), "HH:mm:ss tt")# on #DateFormat(CreateODBCDate(Now()), "MM-DD-")# Name ABO RH Antigen Antibody #LName#, #FName# #ABO# #RH# #Antigen# #Antibody# #GetQryList.RecordCount# Records Found 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 : > arguments="#ExpandPath('QueryBatch.cfm')# 10.1.125.25" > > outputfile="c:\BBBatch.txt"> > > > > > > > ~| 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 : 2 : *QueryBatch.cfm is below: ** select * from PTBB where len(MRN) = 7 order by Lname Marian, this is a test. Please let me know if you got this one! Thank you, Daniel Name ABO RH Antigen Antibody #LName#, #FName# #ABO# #RH# #Antigen# #Antibody# #GetQryList.RecordCount# Records Found ~| 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
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
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: 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
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
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: 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. > > 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
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
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: 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
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
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: [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 > 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
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
[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
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: 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: > > > > It's a past or present date > > > > It's a future date > > > > > > > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. > > 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
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: b>omA". > > 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
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
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: b>omA". > 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
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: b>omA". 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
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
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
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
javax.mail.SendFailedException: 550 5.7.1
#PTRoomNo# update PTINFOIncident set MsgSent ='Yes' where PTFIN ='#THEFIN#' and PTMRN = '#THEMRN#' 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