Re: CFMX server is crashing
CFMX 6.0 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184844 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 server is crashing
Which version u r using ? 6.1 or 6.1 with the updater??? regards Vishnu Prasad > Our CFMX server is crashing quite offen once in 15 days or in a month. > > I checked in the log, but i found no fault. > CFMX server was not fully down but retrival of page was dead slow. > > After restarting the server it is working fine...but i need to know > the cause for the crash > > Thanks ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184843 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 server is crashing
Our CFMX server is crashing quite offen once in 15 days or in a month. I checked in the log, but i found no fault. CFMX server was not fully down but retrival of page was dead slow. After restarting the server it is working fine...but i need to know the cause for the crash Thanks ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184842 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: Counting and looping
Probably a way to do it within ur SQL or how about using QofQ? SELECT count(id) as cnt FROM summary GROUP BY major Doug, On Thu, 18 Nov 2004 15:56:32 -0700, Broner, Mark, CON, OASD(HA)/TMA <[EMAIL PROTECTED]> wrote: > Jim, > > The loop you have only appends all the totals to the one variable. So you > are probably getting a total for all variables. > What you need to do is within the loop dynamically set the variable to each > majorcode and append to that variable instead of to the one variables. I > think if you used the query loop option you would have much better success > with this. > > > > This way you can set which major code it is on by record reference and the > total to that variable. > > HTH > Mark > > > > > -Original Message- > From: James Watkins [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 18, 2004 3:28 PM > To: CF-Talk > Subject: Counting and looping > > I am trying to count individual id's in each major but can't see to get the > thing right. Any help would be appreciated: (Oracle SQL) > > > SELECT distinct > majr_code1 major, > id, count(id) tstuds, > last_name, > first_name, > styp_code stype, > camp_code, > total_credit_hours chrs, > ests_code rstatus, > sysdate, > > decode(camp_code,'1','Clarkesville','2','Blairsville','3','Currahee','9' > ,'Internet') > camp >from as_student_enrollment_summary >where term_code_key = '#term#' > and levl_code = '50' > and registered_ind = 'Y' > and camp_code like '#campus#' > Group by > majr_code1, > id, > last_name, > first_name, > styp_code, > camp_code, > total_credit_hours, > ests_code, > sysdate >order by #sort# > > > > > > > > > > Jim Watkins > VP Technology & Institutional Services > 706 781-2305 - Blairsville > 706 754-7850 - Clarkesville > [EMAIL PROTECTED] > http://www.northgatech.edu > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184841 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: ColdFusion 5.0 supports Web Services?
Hey Amy, Representational State Transfer. -Joe On Thu, 18 Nov 2004 19:26:58 -0400, amy chiu <[EMAIL PROTECTED]> wrote: > Can you tell me what REST stands for so that I can google it. > > > > >Alternatively, you could go the REST route, which is nowhere near as > >painful. Or XML-RPC even. > > > >K. > > > >-- > >Keith Gaughan, Developer > >Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland > >http://digital-crew.com/ > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184840 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: Deleting class files
Thanks. I will set up a batch job to delete any files greater than 24 hours and see what happens. Jacob At 04:05 PM 11/18/2004, you wrote: >Yeah, they're only there for efficiency reasons, primarily with >soon-after-startup situations. MM recommends leaving that option >checked for production servers, but it's not a big deal, unless you've >got a hell of a lot of templates and functions. > >I'd probably leave it checked and just set up a cronjob that'll go >delete stuff in there periodically. maybe check disk utilization >every night and if it's greater than X, clear some out. > >cheers, >barneyb > > >On Thu, 18 Nov 2004 15:54:04 -0800, Jacob <[EMAIL PROTECTED]> wrote: > > Well, I found out why I was running out of disk space on my servers. I was > > saving the class files in ColdFusion MX. How that I have stopped saving > > them, can I safely delete all the class files in the directory > > c:\CFusionMX\wwwront\web-inf\cfclasses ? > > > > Only 5 GBs worth... > > > > Thanks in advance, > > Jacob > > >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com/blog/ > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184839 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: Losing Session Variable
Scott, I have a very similar situation (I think) in which a second jsessionid is created when displaying a home page from a directory e.g. http://www.myhost.com/homedir/ - and the second session means that the session vars that were initially created are gone. Have you found anything to help work around this? Any leads at all - I've been looking everywhere. nick cabell [EMAIL PROTECTED] >I've seen this general topic come up in the past, but I haven't been >able to find an example in the archives that matches our current >situation. > >We have a multi-step form process. When you submit the form step 1, >you get to step 2 just fine. When you submit step 2, you should end up >at step 3. However, we're finding that the jsessionid changes going >from step 2 to the action page of step 2 (doing a dump in the >application.cfm file shows that it happens right away). The cfid and >cftoken stay the same. > >This happens on both a production box and a stage box. [The >production box isn't actually live yet, because we are changing hosts >to this new production box this weekend] > >I believe I just found the issue. It's the multipart enctype. That >causes the session id to change. > >Any ideas why? > >Scott > >-- >- >Scott Brady >http://www.scottbrady.net/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184838 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: ColdFusion 5.0 supports Web Services?
Can you tell me what REST stands for so that I can google it. > >Alternatively, you could go the REST route, which is nowhere near as >painful. Or XML-RPC even. > >K. > >-- >Keith Gaughan, Developer >Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland >http://digital-crew.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184837 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: XML via OLEDB
Your best bet would be to use CF, since you are familiar with it.. There is a whole lot of info on xmlSearch in the CFDOCS, if you have them installed.. Basically it works like this: Now you have an XML object you can query with xmlSearch or access like a structure and arrays depending on how you created your XML file... -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 9:56 AM To: CF-Talk Subject: RE: XML via OLEDB Thank you for your reply. Where can I get more information on: xmlSearch, and OPENXML? What is the simplest way to read and modify values in XML files? Do I have to do the parsing in Cold Fusion all myself or is there a way I can access each item as a "property" somehow where I can just change a value? Sorry if my questions are lame... I am new to working with XML files in CF. -Dustin CF MX 6.1 -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:04 PM To: CF-Talk Subject: RE: XML via OLEDB Not sure what your reason are for specifically wanting an OLEDB Driver (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/ht m/xmloledbprovider_1ar6.asp), but there are many ways (easier) to query an XML file: 1. read it with cffile, parse it and search it with xmlSearch 2. read it with cffile, pass it to an SP and use OPENXML to search it 3. you can store the files in a XML database http://exist.sourceforge.net/ 4. plus many more ways -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184836 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: Deleting class files
Yeah, they're only there for efficiency reasons, primarily with soon-after-startup situations. MM recommends leaving that option checked for production servers, but it's not a big deal, unless you've got a hell of a lot of templates and functions. I'd probably leave it checked and just set up a cronjob that'll go delete stuff in there periodically. maybe check disk utilization every night and if it's greater than X, clear some out. cheers, barneyb On Thu, 18 Nov 2004 15:54:04 -0800, Jacob <[EMAIL PROTECTED]> wrote: > Well, I found out why I was running out of disk space on my servers. I was > saving the class files in ColdFusion MX. How that I have stopped saving > them, can I safely delete all the class files in the directory > c:\CFusionMX\wwwront\web-inf\cfclasses ? > > Only 5 GBs worth... > > Thanks in advance, > Jacob > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184835 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: Macromedia gives up on the server market in Australia and wal ks away.
> Apples and oranges can be compared, but they're still not the same. > > Flash remoting comes with CFMX. It helps enable RIAs. > > .NET remoting is supposedly more on par with EJBs, enterprise-grade > distributed computing. EJB support, btw, comes with CFMX Enterprise, as > JRun is a full J2EE server. Hi Nathan, Sorry, didn't mean to imply they were the "same." They are, however, sort of similar - each exists for intra-platform communication in a binary format, as opposed to an open, 'chatty' format like SOAP. MM is just nice enough to extend the Flash remoting format to other platforms. I think the more direct Java equivalent is the Java Remote Method Invocation (RMI). -joe -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/client/jComponents.cfm ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184834 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
Deleting class files
Well, I found out why I was running out of disk space on my servers. I was saving the class files in ColdFusion MX. How that I have stopped saving them, can I safely delete all the class files in the directory c:\CFusionMX\wwwront\web-inf\cfclasses ? Only 5 GBs worth... Thanks in advance, Jacob ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184833 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: XML via OLEDB
Thank you for your reply. Where can I get more information on: xmlSearch, and OPENXML? What is the simplest way to read and modify values in XML files? Do I have to do the parsing in Cold Fusion all myself or is there a way I can access each item as a "property" somehow where I can just change a value? Sorry if my questions are lame... I am new to working with XML files in CF. -Dustin CF MX 6.1 -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:04 PM To: CF-Talk Subject: RE: XML via OLEDB Not sure what your reason are for specifically wanting an OLEDB Driver (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/ht m/xmloledbprovider_1ar6.asp), but there are many ways (easier) to query an XML file: 1. read it with cffile, parse it and search it with xmlSearch 2. read it with cffile, pass it to an SP and use OPENXML to search it 3. you can store the files in a XML database http://exist.sourceforge.net/ 4. plus many more ways -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184832 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: XML via OLEDB
Not sure what your reason are for specifically wanting an OLEDB Driver (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/ht m/xmloledbprovider_1ar6.asp), but there are many ways (easier) to query an XML file: 1. read it with cffile, parse it and search it with xmlSearch 2. read it with cffile, pass it to an SP and use OPENXML to search it 3. you can store the files in a XML database http://exist.sourceforge.net/ 4. plus many more ways -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184831 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: Counting and looping
Jim, The loop you have only appends all the totals to the one variable. So you are probably getting a total for all variables. What you need to do is within the loop dynamically set the variable to each majorcode and append to that variable instead of to the one variables. I think if you used the query loop option you would have much better success with this. This way you can set which major code it is on by record reference and the total to that variable. HTH Mark -Original Message- From: James Watkins [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:28 PM To: CF-Talk Subject: Counting and looping I am trying to count individual id's in each major but can't see to get the thing right. Any help would be appreciated: (Oracle SQL) SELECT distinct majr_code1 major, id, count(id) tstuds, last_name, first_name, styp_code stype, camp_code, total_credit_hours chrs, ests_code rstatus, sysdate, decode(camp_code,'1','Clarkesville','2','Blairsville','3','Currahee','9' ,'Internet') camp from as_student_enrollment_summary where term_code_key = '#term#' and levl_code = '50' and registered_ind = 'Y' and camp_code like '#campus#' Group by majr_code1, id, last_name, first_name, styp_code, camp_code, total_credit_hours, ests_code, sysdate order by #sort# Jim Watkins VP Technology & Institutional Services 706 781-2305 - Blairsville 706 754-7850 - Clarkesville [EMAIL PROTECTED] http://www.northgatech.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184830 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 Swiff Charting?
Is swiff Chart (http://www.globfx.com) the only real solution. The chart generation software is a little pricy. US $899/server. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184829 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: ColdFusion 5.0 supports Web Services?
Barney Boisvert wrote: > Only CFMX provides built-in tools for publishing and consuming web services. > > There's no reason you can't use CF5 for web services work, but CF > isn't going to help you in any way, so you'll have to manually do all > the SOAP and WSDL stuff manually, which would be a nightmare. Alternatively, you could go the REST route, which is nowhere near as painful. Or XML-RPC even. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184828 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: XML via OLEDB
Sorry, I didn't read your post properly. SQL XML support does not apply here. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:37 AM To: CF-Talk Subject: RE: XML via OLEDB On MS SQL you could install "SQL XML Support in IIS" and then you can query it with Xpath (xmlSearch in CF).. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184827 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: XML via OLEDB
On MS SQL you could install "SQL XML Support in IIS" and then you can query it with Xpath (xmlSearch in CF).. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184826 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
OT: XML via OLEDB
Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184825 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
Counting and looping
I am trying to count individual id's in each major but can't see to get the thing right. Any help would be appreciated: (Oracle SQL) SELECT distinct majr_code1 major, id, count(id) tstuds, last_name, first_name, styp_code stype, camp_code, total_credit_hours chrs, ests_code rstatus, sysdate, decode(camp_code,'1','Clarkesville','2','Blairsville','3','Currahee','9' ,'Internet') camp from as_student_enrollment_summary where term_code_key = '#term#' and levl_code = '50' and registered_ind = 'Y' and camp_code like '#campus#' Group by majr_code1, id, last_name, first_name, styp_code, camp_code, total_credit_hours, ests_code, sysdate order by #sort# Jim Watkins VP Technology & Institutional Services 706 781-2305 - Blairsville 706 754-7850 - Clarkesville [EMAIL PROTECTED] http://www.northgatech.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184824 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: SQL Help Needed
Okay, here's what I've come up with we'll see how it goes... SELECT lanesID, subcategoryID, name, availability, price, srp, cost, description FROM dolls_backup INSERT INTO tblProducts(ProdName, ProdDesc, ProdSRP, ProdPrice, ProdCost, SubcatID) VALUES (dolls_backup.name, dolls_backup.description, dolls_backup.srp, dolls_backup.cost, dolls_backup.subcategoryID) ~ Donna On Thu, 18 Nov 2004 13:49:06 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote: > You'll have to check on the exact syntax, but something like this should work: > > INSERT INTO myTable > (col1, col2, col3) > SELECT col4, col5, col6 > FROM otherTable > > The SELECT can be as complex as you want, as long as the columns it > returns are the same number and type as what is needed by the INSERT > portion. > > cheers, > barneyb > > On Thu, 18 Nov 2004 15:33:40 -0600, Donna French <[EMAIL PROTECTED]> wrote: > > I am redesigning an SQL database and need to know if it's possible to > > select specific tables/columns from the original into specific > > tables/columns in the new database. I know I can select the columns I > > want but moving them into a specified column in the new db that isn't > > the same structure is what I'm not sure of. > > > > Any help appreciated. > > > > -- > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/blog/ > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184823 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: MX Methodologies (Mach2?? Fusebox??)
> From: Ali Awan [mailto:[EMAIL PROTECTED] > Thanks Mike and Doug, for pointing me in the right direction. > I'm still pretty fuzzy on the whole thing. I still can't > figure out how to define listeners and events, in a way that > makes sense for the applications I write and work on. > For now I'll probably stick to Fusebox 4, and troll the lists > you mentioned to see if I get struck by lightning and it all > makes sense to me :) > I mean I understand the MVC concepts and OO programming in > theory, just not the practical uses of it, vis a vis mach-ii and CF. > Thanks anyway, > Ali Keep at it and ask lots of questions. I haven't met anyone on any of the lists who isn't more than happy to explain concepts, share some insight into best practices, or even share some example code. Start out small with a basic application Model it out. Ask questions about your model and architecture and go from there. When jumping into CFCs, I started out with a simple application which I called "Contact Manager" which was nothing more than a big rolodex. It will click sooner or later for you... Just keep at it. Are you on the CFCDev list? Listen in there for insight as well as the forums previously mentioned. Good luck! Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184822 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: MX Methodologies (Mach2?? Fusebox??)
Thanks Mike and Doug, for pointing me in the right direction. I'm still pretty fuzzy on the whole thing. I still can't figure out how to define listeners and events, in a way that makes sense for the applications I write and work on. For now I'll probably stick to Fusebox 4, and troll the lists you mentioned to see if I get struck by lightning and it all makes sense to me :) I mean I understand the MVC concepts and OO programming in theory, just not the practical uses of it, vis a vis mach-ii and CF. Thanks anyway, Ali > I was wondering if anyone on here has had any experience upgrading > their CF apps (pre-MX) to the Mach2 framework? > > If so, how would you advise someone who was attempting to upgrade an > app written for CF 5.0 to Mach2. (I'm upgrading to MX also, obviously). > > > I have seen examples of Mach2, like Shopping Cart apps, etc. This > seems to work nicely when there are clearly defined objects, events, > etc. But as most of us know, not all Cold Fusion or web apps can be > neatly organized into objects, events etc. > > Anyway, I just wanted to start a discussion, to see if anyone else has > converted an app that wasn't as clearly defined as a shopping cart, to > Mach2 and what advise they may have, or what pitfalls they encountered. > Additionally in some cases is it better just to stick with the Fusebox > framework on MX? > > Thanks, Ali ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184821 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: SQL Help Needed
You'll have to check on the exact syntax, but something like this should work: INSERT INTO myTable (col1, col2, col3) SELECT col4, col5, col6 FROM otherTable The SELECT can be as complex as you want, as long as the columns it returns are the same number and type as what is needed by the INSERT portion. cheers, barneyb On Thu, 18 Nov 2004 15:33:40 -0600, Donna French <[EMAIL PROTECTED]> wrote: > I am redesigning an SQL database and need to know if it's possible to > select specific tables/columns from the original into specific > tables/columns in the new database. I know I can select the columns I > want but moving them into a specified column in the new db that isn't > the same structure is what I'm not sure of. > > Any help appreciated. > > -- -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184820 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 Help Needed
I am redesigning an SQL database and need to know if it's possible to select specific tables/columns from the original into specific tables/columns in the new database. I know I can select the columns I want but moving them into a specified column in the new db that isn't the same structure is what I'm not sure of. Any help appreciated. -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184819 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: ColdFusion 5.0 supports Web Services?
Only CFMX provides built-in tools for publishing and consuming web services. There's no reason you can't use CF5 for web services work, but CF isn't going to help you in any way, so you'll have to manually do all the SOAP and WSDL stuff manually, which would be a nightmare. cheers, barneyb On Thu, 18 Nov 2004 16:24:12 -0400, amy chiu <[EMAIL PROTECTED]> wrote: > Does anyone know if coldfusion 5.0 supports web services or does it have to > be coldFusion MX? > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184818 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
ColdFusion 5.0 supports Web Services?
Does anyone know if coldfusion 5.0 supports web services or does it have to be coldFusion MX? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184817 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: SQL Datasource
GOT THE SERVER NAME RIGHT? YOU MAY HAVE TO USE THE NAME OF YOUR LOCAL MACHINE -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:05 PM To: CF-Talk Subject: SQL Datasource I'm trying to setup a SQL Server datasource and keep getting an error. I've imported my database locally from the remote server using DTS, and have named the datasource, database, appropriate datasource type. Any suggestions welcome. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184816 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: Macromedia gives up on the server market in Australia and wal ks away.
> >>remoting~ comes with cfml built in even, does it with .net? no, > > Why would it come with .NET? Fast binary remoting comes with .NET. Apples and oranges can be compared, but they're still not the same. Flash remoting comes with CFMX. It helps enable RIAs. .NET remoting is supposedly more on par with EJBs, enterprise-grade distributed computing. EJB support, btw, comes with CFMX Enterprise, as JRun is a full J2EE server. You can get Flash Remoting (the product) for .NET from Macromedia for a few hundred bucks. .NET's closer equivalent to CFMX's remoting is web services, consummable by a Flash client, though much more 'chatty' than remoting. At least they're easy to implement. -nathan strutz ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184815 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 Datasource
I'm trying to setup a SQL Server datasource and keep getting an error. I've imported my database locally from the remote server using DTS, and have named the datasource, database, appropriate datasource type. Any suggestions welcome. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184813 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: CF integration w/ "warped text" graphic challenges?
glad to hear that... it's pretty useful... i make unsubscribers work to get off the spam list LOL >>> [EMAIL PROTECTED] 11/18/2004 1:01:57 PM >>> At 02:04 PM 11/18/2004, Lawrence Ng wrote: >try this... > >http://www.emerle.net/programming/display.cfm/t/cfx_captcha Ahhh. Now that is easy. :) Works perfectly. Anders ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184814 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: CF integration w/ "warped text" graphic challenges?
At 02:04 PM 11/18/2004, Lawrence Ng wrote: >try this... > >http://www.emerle.net/programming/display.cfm/t/cfx_captcha Ahhh. Now that is easy. :) Works perfectly. Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | | Do you like Evite? This is better: http://RSVPtracker.com/| +===+ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184812 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: Reference to complex var not destroyed
> Yes ok I get it now, *ignore* my last email... Sorry, too late! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184811 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: Reference to complex var not destroyed
> If you look at one of my emails where I says I set it in the > server scope, you will see that the above statement is not > true, which is *the only thing this email is about*. It doesn't matter which scope contains the reference. The only salient point that you have to understand is that when you create a structure and put it in a variable, that variable isn't the structure itself but simply a reference to that structure. This works the same way in any other language that differentiates between stack and heap variables. http://www.phptr.com/articles/article.asp?p=31755&seqNum=8 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184810 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: Reference to complex var not destroyed
Yes ok I get it now, *ignore* my last email... There is still a reference, i.e. the one in the server scope itself.. OK, I understand it now. So, references change, but do not get deleted when one of the references get deleted. Ok all clear, thanks. Taco Fleur > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Friday, 19 November 2004 12:55 AM > To: CF-Talk > Subject: RE: Reference to complex var not destroyed > > > > I don't think you understand me correctly, I understand that > > a REFERENCE is created and not a copy of the structure > > itself, if you read my message again you might see this. > > > > My question is: why is the reference not destroyed when the > > original structure is? When I update the original structure > > with another value the reference is updated, but why not > > destroyed? > > No, I understood you correctly. When you create a structure > using, say, StructNew, you're actually creating two things - > the structure itself, and a reference to the structure. The > structure itself can have as many references as you like, and > they all point you back to the actual structure. > > bar = foo> > > The structure itself will stick around as long as there's at > least one reference still around. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184809 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: Reference to complex var not destroyed
Hi Dave, > The structure itself will stick around as long as there's at > least one reference still around. If you look at one of my emails where I says I set it in the server scope, you will see that the above statement is not true, which is *the only thing this email is about*. > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184808 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: ColdFusion Crashing The Web Server
yeah, I have noticed this too. In CF5 we could 'restart after n bad threads' Even then, CF has never handled dead DSNs gracefully at all. I don't know how other app servers handle it though, maybe similar. Heck, I just had two threads run over 65,000 secs according to my logs. That's just odd. It maybe that some of these settings in CF5 were relied upon too much, allowing us to write bad code, eh? I'm now starting to add timeout="x" to all my cfquery tags, somethign that is probably a best practise, eh? wish cftry had a timeout attribute too... Doug On Thu, 18 Nov 2004 13:41:55 -0500, Ben Rogers <[EMAIL PROTECTED]> wrote: > We've noticed that, with ColdFusion MX, problems tend to cascade through the > system, crashing ColdFusion MX and the Web server in turn. The types of > problems I'm talking about include database connectivity issues, as well as > flash remoting and web service issues. > > This didn't used to be the case with ColdFusion 5. In ColdFusion 5, database > problems might tie up threads and eventually cause ColdFusion to stop > responding until the database problem was resolved. I don't recall that this > ever actually crashed the ColdFusion service, much less brought down the Web > server. > > So, I'm wondering, is this truly how ColdFusion MX behaves, or have we > configured something improperly? Having said that, I should note that we > leave most settings at their default unless we have a good reason to change > them. > > We're seeing this problem on Windows Server 2000 and 2003 talking to a > couple different Microsoft SQL Server boxes. We've tried installing the > latest ColdFusion MX updater. That doesn't seem to have helped. > > It happens when, for instance, connection timeouts occur while querying the > database. In a recent case, a flash movie was making many failed web service > requests. The volume of the requests themselves wasn't the problem. It > appeared to be related more to the fact that the requests were generating > Axis faults. > > I should note that we're a hosting provider, so we host a lot of content > that we haven't developed ourselves. We also host non-ColdFusion sites. So, > when a ColdFusion problem starts affecting static sites, ASP.Net and classic > ASP sites, it's a pretty big issue for us. > > Ben Rogers > http://www.c4.net > v.508.240.0051 > f.508.240.0057 > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184807 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: SQL Query using 'FOR XML' & Coldfusion
Here it is, -- Author: Taco Fleur ([EMAIL PROTECTED]) -- Function: Returns an XML string from a FOR XML clause -- Credit: I could not have come this far without the help of Hillaire from Experts-Exchange. -- Copyright: This code can be used freely as long as this header remains intact. -- Requirements: MS SQL 2000 (SP3) -- Known issues: The current limit of the returned XML document is 4000 CREATE PROCEDURE [dbo].[sp_forXML] ( @serverName VARCHAR(40), @databaseName VARCHAR(40), @selectStatement TEXT, @xml NVARCHAR(4000) OUTPUT ) AS DECLARE @returnCode INT, -- the status code returned from calls to sp_OA @objStream INT, -- the ADO stream object @objCommand INT, -- the ADO command object @errorSource VARCHAR(2550), @errorDescription VARCHAR(2550), @connectionString VARCHAR(1000), @filesize INT, @objProperty INT, @objOutputStream INT SET @connectionString = 'Data Source=' + @serverName + '; Provider=SQLOLEDB; Initial Catalog=' + @databaseName + '; Integrated Security=SSPI' EXEC @returnCode = sp_OACreate 'ADODB.Stream', @objStream OUTPUT IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error ADODB.Stream: ', @errorSource, @errorDescription END EXEC @returnCode = sp_OACreate 'ADODB.Command', @objCommand OUTPUT IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error ADODB.Command: ', @errorSource, @errorDescription END EXEC @returnCode = sp_OASetProperty @objCommand, 'ActiveConnection', @connectionString IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error ActiveConnection: ', @errorSource, @errorDescription END EXEC @returnCode = sp_OASetProperty @objCommand, 'CommandText', @selectStatement IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error CommandText: ', @errorSource, @errorDescription END EXEC @returnCode = sp_OAMethod @objStream,'Open' IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Open: ', @errorSource, @errorDescription END --Get a pointer to the properties collection EXEC @returnCode = sp_OAGetProperty @objCommand, 'Properties', @objProperty OUTPUT IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Properties: ', @errorSource, @errorDescription END -- Get a pointer to the "Output Stream" property EXEC @returnCode = sp_OAMethod @objProperty, 'Item', @objOutputStream OUT, 'Output Stream' IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Item: ', @errorSource, @errorDescription END -- Set Property value EXEC @returnCode = sp_OASetProperty @objOutputStream, 'Value', @objStream IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Value: ', @errorSource, @errorDescription END -- Invoke execute method EXEC sp_OAMethod @objCommand, 'Execute', null, null, null, 1024 IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Execute: ', @errorSource, @errorDescription END -- Check output stream size EXEC @returnCode = sp_OAGetProperty @objStream, 'Size', @fileSize OUT IF @filesize < 4000 BEGIN -- ReadText EXEC @returnCode = sp_OAMethod @objStream,'ReadText', @xml OUT IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error ReadText: ', @errorSource, @errorDescription END END ELSE BEGIN SET @xml = 'Output is too large to fit nvarchar(4000) variable' END SELECT @xml AS 'Result' -- Clean up. EXEC @returnCode = sp_OADestroy @objStream EXEC @returnCode = sp_OADestroy @objCommand EXEC @returnCode = sp_OADestroy @objProperty EXEC @returnCode = sp_OADestroy @objOutputStream GO DECLARE @RC int DECLARE @xml nvarchar(4000) DECLARE @serverName VARCHAR(40) DECLARE @databaseName VARCHAR(40) SET @databaseName = DB_NAME() EXEC [
Re: What sets the domain in default CFID cookies?
Mark, I understand your recommendation - thinking about doing that but it's not getting the core of the problem, I think. So I reduced my testing environment so that anyone can now duplicate the most basic part of the problem - dual sessionids in the same bowser "session". It's quite bizarre. I have the simplest of cfapplication tags - and j2ee sessions are enabled in CFADMIN. Using Firefox, you can request for all browser cookies to be prompted - I did this. Using this url --> http://localhost:8500/mes/testprog/ returns me the mes\testprog\index.cfm home page, right? BUT IT CAUSES TWO jsessionid cookies to be written. My index.cfm page has nothing at all in it but some text. Now restart the browser (to flush the memory cookies) and try the FULL url http://localhost:8500/mes/testprog/index.cfm NOW IT ONLY WRITES ONLY A SINGLE jsessionid cookie. The reason this is a problem is that the session vars created in the application.cfm are associated with the FIRST jsessionid, not with the LAST one that is active when I need to use them. THe problem goes away if I refresh the browser, but that is not acceptable and the client insists on letting users come to the home page using http://host/path/ Any ideas how to have my session vars associated with the current session? > Hi > If that cflocation is changing your user's host name then I'd suggest > changing the cflocation, probably by removing the relative path stuff > and using either a path that starts with "/" (without http), or, to be > double-sure, putting the whole url there (http://#CGI. > HTTP_HOST#/blah/blah). (This assumes that the host name is correct on > the page where the cflocation is. If it's already changed by then > then this won't work.) > > I do suggest checking your logs to be really sure that the host name > switch is not happening earlier, maybe though a stray link or > something on your site. > > Mark ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184804 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 / IIS Crash
yep...time to get outside there Lawrence ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184805 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: SQL Query using 'FOR XML' & Coldfusion
u know we're getting old when we forget the time... LOL ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184801 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: Oracle SQL date compare question...
That is just it, I didnt know why I was doing it that way at the time.. I just knew it worked ;) Anyways, Thanks! On Thu, 18 Nov 2004 13:18:16 -0600, Deanna Schneider <[EMAIL PROTECTED]> wrote: > You may want to document why you're doing it that way so that someone > following you would know your intent. > > she who speaks from experience... > -d > > > > - Original Message - > From: "Greg Morphis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, November 18, 2004 9:54 AM > Subject: Re: Oracle SQL date compare question... > > > aha... yeah it defaults to midnight, I did some research.. > > I already had a fix, as noted in my previous message but thanks for > > the explaniation > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184803 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: error loading cfx dll
Thanks Dave (and Lewis) for the suggestions. I ran depends.exe on it on the server and there didn't seem to be any missing or otherwise problematic dll files. Back to the drawing board.. Steve >> Anyway, I've put a cfx tag (CFX_ResolveDNS.dll) in my >> C:\CFusionMX\CustomTags directory. I've registered it in CF >> Admin, but each time we try to load up the test page we get >> an error of "Unable to Load Library". > >Are there any dependencies within the library? You might load it up in >Dependency Walker (depends.exe) to find out. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184802 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: Oracle SQL date compare question...
You may want to document why you're doing it that way so that someone following you would know your intent. she who speaks from experience... -d - Original Message - From: "Greg Morphis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 18, 2004 9:54 AM Subject: Re: Oracle SQL date compare question... > aha... yeah it defaults to midnight, I did some research.. > I already had a fix, as noted in my previous message but thanks for > the explaniation > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184799 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: CF Scheduled Tasks not working
D'oh, I figured it out. It was a typo in the url that the browser fixed for me when I pasted it into the address bar. Ugh Thanks On Thu, 18 Nov 2004 13:17:27 -0500, George Abraham <[EMAIL PROTECTED]> wrote: > Could be authentications issues if the pages are behind an application > security wall. > > George > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184800 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: SQL Query using 'FOR XML' & Coldfusion
Oh my, that was almost 2 years ago... where does the time go... On Thu, 18 Nov 2004 11:14:16 -0800, Rob <[EMAIL PROTECTED]> wrote: > http://216.239.57.104/search?q=cache:DCTbFs36U50J:www.houseoffusion.com/cf_lists/index.cfm/method%3Dmessages%26threadid%3D19430%26forumid%3D4+%22for+xml%22+coldfusion+%22rob+rohan%22&hl=en > > > > > On Thu, 18 Nov 2004 10:27:05 -, Andy McShane <[EMAIL PROTECTED]> wrote: > > Can you remember at all how you handled the column names? i.e. > > > > > > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > > -Original Message- > > From: Rob [mailto:[EMAIL PROTECTED] > > Sent: 17 November 2004 17:42 > > To: CF-Talk > > Subject: Re: SQL Query using 'FOR XML' & Coldfusion > > > > Yes, you have to loop over the query columns and build a new string > > with the columns data. > > > > The way you go about it is pretty wacky and I forget the syntax, but I > > (and others) have posted how to do it to the list at one point so it > > should be in the archive (it was like a year ago though) > > > > On Wed, 17 Nov 2004 07:58:42 -0400, Andy Mcshane <[EMAIL PROTECTED]> wrote: > > > Hi all. I am trying to utilise the SQL2000 'FOR XML' functionality to > > return the results of a stored procedure, called from Coldfusion using > > 'CFStoredProc', as an XML string to my Coldfusion app. I am having a few > > problems; > > > > > > When I run the query in the SQL query window the results are exactly as I > > want, when I then call the stored procedure from Coldfusion app I get a > > recordset with multiple rows instead of one record containing a string and > > when I look at the 'ColumnList' property of the query I have mulitple > > columns with a naming convention as > > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > > > > Has anybody managed to use this SQL 'FOR XML' functionality in a > > Coldfusion app before? > > > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184798 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: Load pages from 2 different domains...
> From: Alex Ninan [mailto:[EMAIL PROTECTED] > I have a page a.htm on "www.a.com" and b.htm on "www.b.com" > Is there a way to create a new page (c.htm) on "www.a.com" to > show the a.htm followed by b.htm > I trying this without using frames. Look into: cfhhtp Michael T. Tangorre ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184797 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: SQL Query using 'FOR XML' & Coldfusion
http://216.239.57.104/search?q=cache:DCTbFs36U50J:www.houseoffusion.com/cf_lists/index.cfm/method%3Dmessages%26threadid%3D19430%26forumid%3D4+%22for+xml%22+coldfusion+%22rob+rohan%22&hl=en On Thu, 18 Nov 2004 10:27:05 -, Andy McShane <[EMAIL PROTECTED]> wrote: > Can you remember at all how you handled the column names? i.e. > > > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > -Original Message- > From: Rob [mailto:[EMAIL PROTECTED] > Sent: 17 November 2004 17:42 > To: CF-Talk > Subject: Re: SQL Query using 'FOR XML' & Coldfusion > > Yes, you have to loop over the query columns and build a new string > with the columns data. > > The way you go about it is pretty wacky and I forget the syntax, but I > (and others) have posted how to do it to the list at one point so it > should be in the archive (it was like a year ago though) > > On Wed, 17 Nov 2004 07:58:42 -0400, Andy Mcshane <[EMAIL PROTECTED]> wrote: > > Hi all. I am trying to utilise the SQL2000 'FOR XML' functionality to > return the results of a stored procedure, called from Coldfusion using > 'CFStoredProc', as an XML string to my Coldfusion app. I am having a few > problems; > > > > When I run the query in the SQL query window the results are exactly as I > want, when I then call the stored procedure from Coldfusion app I get a > recordset with multiple rows instead of one record containing a string and > when I look at the 'ColumnList' property of the query I have mulitple > columns with a naming convention as > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > > Has anybody managed to use this SQL 'FOR XML' functionality in a > Coldfusion app before? > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184796 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
Load pages from 2 different domains...
Hi, I have a page a.htm on "www.a.com" and b.htm on "www.b.com" Is there a way to create a new page (c.htm) on "www.a.com" to show the a.htm followed by b.htm I trying this without using frames. Let me know yur thoughts Joe ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184795 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: Spectra
I am a fan.. but storing content in db's where you have to loop through all of them or use verity to find a boolean is a bit much! MD On Thu, 18 Nov 2004 12:50:12 -0600, Raymond Camden <[EMAIL PROTECTED]> wrote: > Here here - I think I must be one of the few "fans" left. (Of course, > I wouldn't use it myself anymore. ;) > > On Thu, 18 Nov 2004 17:58:28 -, Robertson-Ravo, Neil (RX) > > > <[EMAIL PROTECTED]> wrote: > > Granted...it was good while it lasted ;-) Have a squizz at FarCry > > > > > > > > -Original Message- > > From: Rick Root [mailto:[EMAIL PROTECTED] > > Sent: 18 November 2004 17:58 > > To: CF-Talk > > Subject: Re: Spectra > > > > [EMAIL PROTECTED] wrote: > > > I'm evaluating cheap/free CMS systems and one of the criteria is 3rd part > > > modules > > > > Spectra is not an option if you value your sanity. > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184794 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: Whois Query by Zipcode of Registrant
> Anyone know how to do a query (either using CF or even an > offline or online tool) to do a whois query and get a list > of all domains owned by registrants within a certain zipcode? I don't think most registrars will let you search whois databases by zipcode. I also don't think most registrars will allow bulk whois queries any more. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184793 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: CF integration w/ "warped text" graphic challenges?
try this... http://www.emerle.net/programming/display.cfm/t/cfx_captcha ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184792 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: CF integration w/ "warped text" graphic challenges?
At 01:24 PM 11/18/2004, you wrote: >Anders, > >Search for "CAPTCHA" :) Ahh. Thanks. I've found lots of research and articles now. Still no utilities yet. I'd like to be able to CFexecute something that would generate a .gif with text I chose, warped to its liking. That would make this all easy. :) Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | | Do you like Evite? This is better: http://RSVPtracker.com/| +===+ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184791 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
Whois Query by Zipcode of Registrant
Anyone know how to do a query (either using CF or even an offline or online tool) to do a whois query and get a list of all domains owned by registrants within a certain zipcode? I know this group will have the answer or know someone who does. Thanks. Michael Pool ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184790 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: Spectra
Here here - I think I must be one of the few "fans" left. (Of course, I wouldn't use it myself anymore. ;) On Thu, 18 Nov 2004 17:58:28 -, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > Granted...it was good while it lasted ;-) Have a squizz at FarCry > > > > -Original Message- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: 18 November 2004 17:58 > To: CF-Talk > Subject: Re: Spectra > > [EMAIL PROTECTED] wrote: > > I'm evaluating cheap/free CMS systems and one of the criteria is 3rd part > > modules > > Spectra is not an option if you value your sanity. > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184789 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: Xml from SQL 2k
http://www.houseoffusion.com/lists.cfm/link=m:4:17429:89212 -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 12:19 PM To: CF-Talk Subject: Re: Xml from SQL 2k I have been desperately searching for something similar to this. From my Coldfusion page I execute a stored procedure that extracts data from my SQL database into an XML format and returns it to my page. My problem is how do I handle back in CF? When I query my #query.recordcount# I have multiple records. When I do a of the query I can all of the XML data that I want. I would like to be able to loop through the recordset and rebuild all of the individual back into one string ready for XML parsing. When I try to do I notice that Each record has only 1 column with a wierd name like 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the value of this column using the column name I get an error '"18A1," on line 14, column 23, is not a valid identifer name.'. Does anybody know how I can loop through the results of my query and rebuild my single XML string, this problem is driving me mad!!! > > Thanx Mr.Dave > > > > > > - Original Message - > > From: "Dave Watts" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, October 11, 2001 12:24 PM > > Subject: RE: Xml from SQL 2k > > > > > > > > Can any one tell me where can i find an article related to > > > > xml with CF The database is sql server 2000.And I want to > > > > generate the xml from sql 2000. > > > > > > We had a CFUG presentation covering some of this, that you might > > find > > > useful. > > > http://www.figleaf. > com/figleafhome/cfug/2001/CFUGApr2001/sql2000xml. > > zip > > > > > > Dave Watts, CTO, Fig Leaf Software > > > http://www.figleaf.com/ > > > voice: (202) 797-5496 > > > > > I have been desperately searching for something similar to this. From > my Coldfusion page I execute a stored procedure that extracts data > from my SQL database into an XML format and returns it to my page. My > problem is how do I handle back in CF? When I query my #query. > recordcount# I have multiple records. When I do a of the > query I can all of the XML data that I want. I would like to be able > to loop through the recordset and rebuild all of the individual back > into one string ready for XML parsing. When I try to do I notice that > Each record has only 1 column with a wierd name like > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the > value of this column using the column name I get an error '"18A1," on > line 14, column 23, is not a valid identifer name.'. > Does anybody know how I can loop through the results of my query and > rebuild my single XML string, this problem is driving me mad!!! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184788 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
ColdFusion Crashing The Web Server
We've noticed that, with ColdFusion MX, problems tend to cascade through the system, crashing ColdFusion MX and the Web server in turn. The types of problems I'm talking about include database connectivity issues, as well as flash remoting and web service issues. This didn't used to be the case with ColdFusion 5. In ColdFusion 5, database problems might tie up threads and eventually cause ColdFusion to stop responding until the database problem was resolved. I don't recall that this ever actually crashed the ColdFusion service, much less brought down the Web server. So, I'm wondering, is this truly how ColdFusion MX behaves, or have we configured something improperly? Having said that, I should note that we leave most settings at their default unless we have a good reason to change them. We're seeing this problem on Windows Server 2000 and 2003 talking to a couple different Microsoft SQL Server boxes. We've tried installing the latest ColdFusion MX updater. That doesn't seem to have helped. It happens when, for instance, connection timeouts occur while querying the database. In a recent case, a flash movie was making many failed web service requests. The volume of the requests themselves wasn't the problem. It appeared to be related more to the fact that the requests were generating Axis faults. I should note that we're a hosting provider, so we host a lot of content that we haven't developed ourselves. We also host non-ColdFusion sites. So, when a ColdFusion problem starts affecting static sites, ASP.Net and classic ASP sites, it's a pretty big issue for us. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184787 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: Outsourcing
At one of my previous jobs, about 4-5 years ago, they decided to out source an entire project to an Indian based company. The final product did function, but the problem the company I worked for ran into was that the documentation made little sense to anyone and just the flow of how things worked also made little sense. In the end they ended up scrapping it and rebuilding it internally, was a costly experiment. Now some of that probably could have been avoided had a extremely detailed spec been made up for the project and then handed over to the out sourced firm. They always blamed it on cultural differences and how the outsourced company just looked and thought about problems in a different manner. I do some freelance work here and there. Usually the biggest "obstacle" is adjusting to what ever standards they have already set in. However after being exposed to so many different methods, it really has not been a big "obstacle" in quite some time. I actually enjoy adjusting to the different methods, it helps me better myself IMHO. -- Aaron Rouse http://www.happyhacker.com/ On Thu, 18 Nov 2004 10:24:15 -0800, Rob <[EMAIL PROTECTED]> wrote: > I am not in charge of the overseas outsourced project here - but I am > watching it happen. There are many things people are not thinking of > when it comes to outsourcing overseas, and I find it kind of funny to > watch. Here are some of the good ones > > * CVS, network, database access is / can be insanely slow for them as > they are across the world. > * Communications with other parts of the project (only some modules > are being handled overseas, and their is not like dev list that anyone > posts changes too so people keep breaking other peoples stuff) > * I work with some of their code, but never met any of them or talk to > them directly - they have a proxy guy here - who is very nice, but I > have to ask him questions then get an answer in a couple days. > > All the uppers where drooling at paying engineers like 2 dollars an > hour, but things, I think, people are totally overlooking are the > details. > > * If they steal all our ideas, are we going to sue them... does an > international lawyer, and court costs null the savings? Not that they > have no honor, but its a possibility. > * If you're outsourcing, then it's probably not feasible to get on a > plane, fly over there and find out whats going on (at least of this > example Calif -> India) > * If your communications setup in house is ok to bad, it seems to get > really bad when outsourcing - esp. when overseas. > * If you think its going to "save the project", you're probably wrong. > > And I have noticed an odd thing too - when I work with local > programmers, they tend to do extra stuff... you know those "hey thats > cool good idea" kind of things. While the outsourced guys seem to > fulfill the requirements (mostly) they don't seem to go the extra > mile. > > ...ranting from the Pit... > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184786 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: Outsourcing
On a humorous note, I think we should start outsourcing CEOs, and board members - there would be a great cost savings an we could forgo golden parachutes :) On Thu, 18 Nov 2004 10:24:15 -0800, Rob <[EMAIL PROTECTED]> wrote: > I am not in charge of the overseas outsourced project here - but I am > watching it happen. There are many things people are not thinking of > when it comes to outsourcing overseas, and I find it kind of funny to > watch. Here are some of the good ones > > * CVS, network, database access is / can be insanely slow for them as > they are across the world. > * Communications with other parts of the project (only some modules > are being handled overseas, and their is not like dev list that anyone > posts changes too so people keep breaking other peoples stuff) > * I work with some of their code, but never met any of them or talk to > them directly - they have a proxy guy here - who is very nice, but I > have to ask him questions then get an answer in a couple days. > > All the uppers where drooling at paying engineers like 2 dollars an > hour, but things, I think, people are totally overlooking are the > details. > > * If they steal all our ideas, are we going to sue them... does an > international lawyer, and court costs null the savings? Not that they > have no honor, but its a possibility. > * If you're outsourcing, then it's probably not feasible to get on a > plane, fly over there and find out whats going on (at least of this > example Calif -> India) > * If your communications setup in house is ok to bad, it seems to get > really bad when outsourcing - esp. when overseas. > * If you think its going to "save the project", you're probably wrong. > > And I have noticed an odd thing too - when I work with local > programmers, they tend to do extra stuff... you know those "hey thats > cool good idea" kind of things. While the outsourced guys seem to > fulfill the requirements (mostly) they don't seem to go the extra > mile. > > ...ranting from the Pit... > > > > On Thu, 18 Nov 2004 08:55:19 -0500, Ryan Emerle <[EMAIL PROTECTED]> wrote: > > Has anyone had any success outsourcing large projects, or portions of > > large projects, overseas or to temporary/freelance employees? Any > > pros/cons to either? Any resources you can offer to someone exploring > > his options? > > > > Basically, we're looking to supplement our current resources while the > > company grows. Unfortunately our timeline does not allow much > > flexibility to train new full/part time employees. > > > > Any help would be appreciated. Personal experiences would be extremely > > helpful. > > > > Thanks! > > -- > > Ryan Emerle > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184785 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: error loading cfx dll
Steve Logan wrote: >I'm relatively new to CFMX 6.1 (though I do have a handfull of CF5 >servers I'm in charge of). This one is CFMX 6.1 / Windows 2000 >Advanced Server. > >Anyway, I've put a cfx tag (CFX_ResolveDNS.dll) in my >C:\CFusionMX\CustomTags directory. I've registered it in CF Admin, >but each time we try to load up the test page we get an error of >"Unable to Load Library". > > Well, off hand it smells like a C++? CFX tag that's trying to load another external .dll for some purpose. As to what DLL it's trying to load ... one would guess something with a MFC in front of it's name (i.e., MFC*.dll). Or perhaps whatever DLL's they use for doing networking. (Microsoft's networking API confused and frustrated me so I just ended up writting my own. Have ever used MS's so I'm very unfamiliar with it. Sorry.) Sec. (grabbed it.) Not much documentation on it. Or source to look at. Anyway, that does indicate a DLL it's assume is on the machine isn't there, or at least, in somewhere where it's not expecting it. You just need to get the domain name of an ip? Um. I don't have time at the moment to explain how to do do it (I'm a bit time stressed at the moment) but you can use my udpclient or tcpclient com to chat with dns servers to do such. Perhaps I could be nice one weekend and just throw together a new CFX (with source) to replace that tag if I have the time. /-) >I've tried all versions of letter case - cfx_resolvedns, >CFX_ResolveDNS etc. - no help. To see if it's a permissions issue, I >temporarily gave the CustomTags folder and the specific dll Everyone / >Full Control privs - no help (also, there is another cfx tag in that >folder that is working fine and I've matched the security permissions >between the two DLLs to no avail). > >Not sure if this stack trace info is any help, but here it is: >Stack Trace (click to expand) >at >cfCFX_ResolveDNS2ecfm142035402.runPage(D:\UserHome\varady\CFX_ResolveDNS.cfm:32) > >coldfusion.tagext.DerivedNativeCFXException: Unable to load library > at coldfusion.tagext.NativeCfx.processRequest(Native Method) > at coldfusion.tagext.CfxTag.doStartTag(CfxTag.java:110) > at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) > at > cfCFX_ResolveDNS2ecfm142035402.runPage(D:\UserHome\varady\CFX_ResolveDNS.cfm:32) > > >12:44:40.040 - coldfusion.tagext.DerivedNativeCFXException - in >D:\UserHome\varady\CFX_ResolveDNS.cfm : line 32 > Unable to load library > >Any ideas? > >Thanks! >Steve > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184784 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: Outsourcing
I am not in charge of the overseas outsourced project here - but I am watching it happen. There are many things people are not thinking of when it comes to outsourcing overseas, and I find it kind of funny to watch. Here are some of the good ones * CVS, network, database access is / can be insanely slow for them as they are across the world. * Communications with other parts of the project (only some modules are being handled overseas, and their is not like dev list that anyone posts changes too so people keep breaking other peoples stuff) * I work with some of their code, but never met any of them or talk to them directly - they have a proxy guy here - who is very nice, but I have to ask him questions then get an answer in a couple days. All the uppers where drooling at paying engineers like 2 dollars an hour, but things, I think, people are totally overlooking are the details. * If they steal all our ideas, are we going to sue them... does an international lawyer, and court costs null the savings? Not that they have no honor, but its a possibility. * If you're outsourcing, then it's probably not feasible to get on a plane, fly over there and find out whats going on (at least of this example Calif -> India) * If your communications setup in house is ok to bad, it seems to get really bad when outsourcing - esp. when overseas. * If you think its going to "save the project", you're probably wrong. And I have noticed an odd thing too - when I work with local programmers, they tend to do extra stuff... you know those "hey thats cool good idea" kind of things. While the outsourced guys seem to fulfill the requirements (mostly) they don't seem to go the extra mile. ...ranting from the Pit... On Thu, 18 Nov 2004 08:55:19 -0500, Ryan Emerle <[EMAIL PROTECTED]> wrote: > Has anyone had any success outsourcing large projects, or portions of > large projects, overseas or to temporary/freelance employees? Any > pros/cons to either? Any resources you can offer to someone exploring > his options? > > Basically, we're looking to supplement our current resources while the > company grows. Unfortunately our timeline does not allow much > flexibility to train new full/part time employees. > > Any help would be appreciated. Personal experiences would be extremely > helpful. > > Thanks! > -- > Ryan Emerle > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184782 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: CF integration w/ "warped text" graphic challenges?
Anders, Search for "CAPTCHA" :) -joe On Thu, 18 Nov 2004 12:54:47 -0500, Anders Green <[EMAIL PROTECTED]> wrote: > I'd guess that we've all seen them by now: > The little graphic with some wavy lines, or > circles, as the background, containing some > warped text or numbers. You type in the code, > and this prevents machines from being able > to sign up. > > I googled... but looking for "warped" on the > internet is almost as bad as searching for pr0n. > > Anyone know of any utilities or packages? > > Anders > +===+ > |Anders Green Email: [EMAIL PROTECTED] | > | Home: 919.303.0218 | > |Off Road Rally Racing Team: http://LinaRacing.com/ | > | Do you like Evite? This is better: http://RSVPtracker.com/| > +===+ > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184783 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: Xml from SQL 2k
I have been desperately searching for something similar to this. From my Coldfusion page I execute a stored procedure that extracts data from my SQL database into an XML format and returns it to my page. My problem is how do I handle back in CF? When I query my #query.recordcount# I have multiple records. When I do a of the query I can all of the XML data that I want. I would like to be able to loop through the recordset and rebuild all of the individual back into one string ready for XML parsing. When I try to do I notice that Each record has only 1 column with a wierd name like 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the value of this column using the column name I get an error '"18A1," on line 14, column 23, is not a valid identifer name.'. Does anybody know how I can loop through the results of my query and rebuild my single XML string, this problem is driving me mad!!! > > Thanx Mr.Dave > > > > > > - Original Message - > > From: "Dave Watts" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, October 11, 2001 12:24 PM > > Subject: RE: Xml from SQL 2k > > > > > > > > Can any one tell me where can i find an article related to > > > > xml with CF The database is sql server 2000.And I want to > > > > generate the xml from sql 2000. > > > > > > We had a CFUG presentation covering some of this, that you might > > find > > > useful. > > > http://www.figleaf. > com/figleafhome/cfug/2001/CFUGApr2001/sql2000xml. > > zip > > > > > > Dave Watts, CTO, Fig Leaf Software > > > http://www.figleaf.com/ > > > voice: (202) 797-5496 > > > > > ~~ > > Your ad could be here. Monies from ads go to support these lists and > > > provide more resources for the community. http://www.fusionauthority. > > > com/ads.cfm > > I have been desperately searching for something similar to this. From > my Coldfusion page I execute a stored procedure that extracts data > from my SQL database into an XML format and returns it to my page. My > problem is how do I handle back in CF? When I query my #query. > recordcount# I have multiple records. When I do a of the > query I can all of the XML data that I want. I would like to be able > to loop through the recordset and rebuild all of the individual back > into one string ready for XML parsing. When I try to do I notice that > Each record has only 1 column with a wierd name like > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the > value of this column using the column name I get an error '"18A1," on > line 14, column 23, is not a valid identifer name.'. > Does anybody know how I can loop through the results of my query and > rebuild my single XML string, this problem is driving me mad!!! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184781 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: CF Scheduled Tasks not working
Could be authentications issues if the pages are behind an application security wall. George On Thu, 18 Nov 2004 12:01:19 -0600, Phill B <[EMAIL PROTECTED]> wrote: > I have 3 task that are set up in CFMX. They worked last week but now > they give errors when I run them in the CF admin. If I copy and paste > the page url into a browser, it works fine. > > The log files show the pages as running with out error. > > Any ideas? > > -- > Phillip B. > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184780 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: Xml from SQL 2k
> Thanx Mr.Dave > > > - Original Message - > From: "Dave Watts" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, October 11, 2001 12:24 PM > Subject: RE: Xml from SQL 2k > > > > > Can any one tell me where can i find an article related to > > > xml with CF The database is sql server 2000.And I want to > > > generate the xml from sql 2000. > > > > We had a CFUG presentation covering some of this, that you might > find > > useful. > > http://www.figleaf.com/figleafhome/cfug/2001/CFUGApr2001/sql2000xml. > zip > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > voice: (202) 797-5496 > > > ~~ > Your ad could be here. Monies from ads go to support these lists and > provide more resources for the community. http://www.fusionauthority. > com/ads.cfm I have been desperately searching for something similar to this. From my Coldfusion page I execute a stored procedure that extracts data from my SQL database into an XML format and returns it to my page. My problem is how do I handle back in CF? When I query my #query.recordcount# I have multiple records. When I do a of the query I can all of the XML data that I want. I would like to be able to loop through the recordset and rebuild all of the individual back into one string ready for XML parsing. When I try to do I notice that Each record has only 1 column with a wierd name like 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the value of this column using the column name I get an error '"18A1," on line 14, column 23, is not a valid identifer name.'. Does anybody know how I can loop through the results of my query and rebuild my single XML string, this problem is driving me mad!!! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184779 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 / IIS Crash
I'm not sure if its MX though.. it may be linux that is stabilizing it. I did both ... develop on win machines and handed it off to the penguin to go live. have your win2k box up and running along side the linux box and keep them running... let's see who gets knocked down. even then, I don't think its an even comparision because you won't get the same transactions on the windows box as u do the nix one since its the live one... wouldn't it be funny if the windows one comes down and there is little activity on it... LOL ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184778 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 / IIS Crash
Mike, you reckon it would be dodgy connectors? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 16:45 To: CF-Talk Subject: RE: CFMX / IIS Crash > Anyone ever seen the situation where IIS comes to blows where IIS crashes > when in use with CFMX - no real sign of why...just stops!? Yes. I'm trying to find out what the cause it now. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184777 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 / IIS Crash
reason why I'm interested is that I'm going to build 2 windows box to see how things go with transactional oeprations: 1. MX with apache and SQL Server 2. MX with IIS and SQL Server and if I'm really bored during the holidays ... compare it with 1.1 MX with apache and Oracle 9 or 10g 2.1 MX with IIS and Oracle 9 or 10g =) >>> [EMAIL PROTECTED] 11/18/2004 9:53:28 AM >>> Lawrence Ng wrote: >I wonder if the same would happen if one were to use Apache (if it's >IIS crashing or root of it in the first place) > > I'm using both at the moment (because it was driving me crazy trying to get CFMX 6.1 to even load an admin page without hanging up the machine a while back). Had it running CFMX for two or three weeks now and Apache works smooth and fine. So far. There were a lot of problems over the last year or so which I was blaming on CFMX (cursing it for being unusable since jumping to Java) but since I had the inspiration to try a different web server the other day when I HAD to run some CFM ... been wondering if I should have just been cursing Microsoft instead. At least in part. Anyway, to answer you, it does seem that (COM issues aside) all the problems I've been having with CFMX (at least recently) go away with Apache. Hrm. -- --Lewis Sellers (AKA min) Intrafoundation Software http://www.intrafoundation.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184776 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 Scheduled Tasks not working
I have 3 task that are set up in CFMX. They worked last week but now they give errors when I run them in the CF admin. If I copy and paste the page url into a browser, it works fine. The log files show the pages as running with out error. Any ideas? -- Phillip B. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184775 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: Spectra
Granted...it was good while it lasted ;-) Have a squizz at FarCry -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 17:58 To: CF-Talk Subject: Re: Spectra [EMAIL PROTECTED] wrote: > I'm evaluating cheap/free CMS systems and one of the criteria is 3rd part > modules Spectra is not an option if you value your sanity. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184774 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: CFMX / IIS Crash
Along these lines...we have one site right now that we develop on Windows 2000 Server and fire the files up to the production Linux server running Apache...apart from setting some path vars differently depending on which environment is detected...all code is identical and all runs 100% smooth as silk ;-) gotta love CF!! Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.comtiny.cfm/54 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184773 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: CFMX / IIS Crash
Hey Lewis, thanks for that info... interesting to say the least. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184772 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: Spectra
[EMAIL PROTECTED] wrote: > I'm evaluating cheap/free CMS systems and one of the criteria is 3rd part > modules Spectra is not an option if you value your sanity. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184771 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: CFMX / IIS Crash
Mmmm, it may be an option -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 17:53 To: CF-Talk Subject: Re: CFMX / IIS Crash Lawrence Ng wrote: >I wonder if the same would happen if one were to use Apache (if it's >IIS crashing or root of it in the first place) > > I'm using both at the moment (because it was driving me crazy trying to get CFMX 6.1 to even load an admin page without hanging up the machine a while back). Had it running CFMX for two or three weeks now and Apache works smooth and fine. So far. There were a lot of problems over the last year or so which I was blaming on CFMX (cursing it for being unusable since jumping to Java) but since I had the inspiration to try a different web server the other day when I HAD to run some CFM ... been wondering if I should have just been cursing Microsoft instead. At least in part. Anyway, to answer you, it does seem that (COM issues aside) all the problems I've been having with CFMX (at least recently) go away with Apache. Hrm. -- --Lewis Sellers (AKA min) Intrafoundation Software http://www.intrafoundation.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184770 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 / IIS Crash
Lawrence Ng wrote: >I wonder if the same would happen if one were to use Apache (if it's >IIS crashing or root of it in the first place) > > I'm using both at the moment (because it was driving me crazy trying to get CFMX 6.1 to even load an admin page without hanging up the machine a while back). Had it running CFMX for two or three weeks now and Apache works smooth and fine. So far. There were a lot of problems over the last year or so which I was blaming on CFMX (cursing it for being unusable since jumping to Java) but since I had the inspiration to try a different web server the other day when I HAD to run some CFM ... been wondering if I should have just been cursing Microsoft instead. At least in part. Anyway, to answer you, it does seem that (COM issues aside) all the problems I've been having with CFMX (at least recently) go away with Apache. Hrm. -- --Lewis Sellers (AKA min) Intrafoundation Software http://www.intrafoundation.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184769 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 integration w/ "warped text" graphic challenges?
I'd guess that we've all seen them by now: The little graphic with some wavy lines, or circles, as the background, containing some warped text or numbers. You type in the code, and this prevents machines from being able to sign up. I googled... but looking for "warped" on the internet is almost as bad as searching for pr0n. Anyone know of any utilities or packages? Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | | Do you like Evite? This is better: http://RSVPtracker.com/| +===+ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184768 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: error loading cfx dll
> Anyway, I've put a cfx tag (CFX_ResolveDNS.dll) in my > C:\CFusionMX\CustomTags directory. I've registered it in CF > Admin, but each time we try to load up the test page we get > an error of "Unable to Load Library". Are there any dependencies within the library? You might load it up in Dependency Walker (depends.exe) to find out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184767 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
CFX_FILE not creating a file when writing?
My host disabled the CFFILE tag and installed a CFX_FILE tag. The CFX_FILE tag will write to an existing file, but doesn't automatically create a file when the file doesn't exists. Unfortunately, I can't find documentation that specifically addresses how to create a file with CFX_FILE or some other way? This is important because archive purposes we want a date/time tag in the file name. Any ideas? Thanks, Nick ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184766 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
error loading cfx dll
I'm relatively new to CFMX 6.1 (though I do have a handfull of CF5 servers I'm in charge of). This one is CFMX 6.1 / Windows 2000 Advanced Server. Anyway, I've put a cfx tag (CFX_ResolveDNS.dll) in my C:\CFusionMX\CustomTags directory. I've registered it in CF Admin, but each time we try to load up the test page we get an error of "Unable to Load Library". I've tried all versions of letter case - cfx_resolvedns, CFX_ResolveDNS etc. - no help. To see if it's a permissions issue, I temporarily gave the CustomTags folder and the specific dll Everyone / Full Control privs - no help (also, there is another cfx tag in that folder that is working fine and I've matched the security permissions between the two DLLs to no avail). Not sure if this stack trace info is any help, but here it is: Stack Trace (click to expand) at cfCFX_ResolveDNS2ecfm142035402.runPage(D:\UserHome\varady\CFX_ResolveDNS.cfm:32) coldfusion.tagext.DerivedNativeCFXException: Unable to load library at coldfusion.tagext.NativeCfx.processRequest(Native Method) at coldfusion.tagext.CfxTag.doStartTag(CfxTag.java:110) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) at cfCFX_ResolveDNS2ecfm142035402.runPage(D:\UserHome\varady\CFX_ResolveDNS.cfm:32) 12:44:40.040 - coldfusion.tagext.DerivedNativeCFXException - in D:\UserHome\varady\CFX_ResolveDNS.cfm : line 32 Unable to load library Any ideas? Thanks! Steve ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184765 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: CFMX / IIS Crash
hehe...that was a learning exercise todon't make a public fool of yourself ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com/54 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184764 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: CFMX / IIS Crash
yes I remembered that as well. This is more as a learning exercise and who knows might come in handy when we need to sell the idea to our clients, mgmt, etc. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184763 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: Verity Collection
What I seem to be having more of a problem with is the return url and the
correct indexing of the search and it's settings. Is there a good site that
shows some solid tutorials about settings up and correctly indexing verity
collections in the Cold Fusion Administrator?
At 07:45 PM 11/17/2004, you wrote:
>ok, this code seems kosher. But you want to index actual files on ur
>server in addition to the above? You should be able to followt the
>above code as a template, the big diff will be the cfindex tag. Check
>out
>http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/indexSearch.htm
>they have a great write up on how to mosh it all out. After you do a
>cfsearch, use cfdump on the result and examine all the fields, it
>looks like you outputted the urlpath filed and teh actual path too.
>
>HTH
>
>Doug
>
>
>On Wed, 17 Nov 2004 14:42:06 -0700, Jason Smith
><[EMAIL PROTECTED]> wrote:
> > The original developer of this web site made a serious mess, I'm still
> > looking for certain files to make changes I personally have never seen a
> > web site with so many useless files in so many locations but as I said I'm
> > new to cold fusion so if you can point me in the direction of what file is
> > most likely to contain the information you need it would help tremendously.
> >
> > Now like I said I have done some things with different cold fusion sites
> > however this is the first cf application I have seen that does not use a
> > global file for anything it would appear he puts all code in every file.
> > Plain and simple the entire application needs a rewrite but I'm really not
> > sure where all strings are that you might need to see.
> >
> > As far as I can tell this is the search info you might be looking for.
> >
> >
> > > collection="itemCollection"
> > name="mySearchQuery"
> > type="simple"
> > criteria="'#exactSearch#'"
> > language="english"
> > external="no">
> > EXACT
> > MATCHES FOR '#UCASE(exactSearch)#'.
> > #mySearchQuery.recordCount#
> > Matching Items
> >
> >
> >
> >
> >
> > > REReplace(mySearchQuery.summary, "<[^>]*>", "", "ALL")>
> >
> > > ReplaceNoCase(searchSummary, "#exactSearch#", "#exactSearch#", "ALL")>
> >
> >
> > > style="font-family: verdana; font-size: 10px;">#iCount# > iCount + 1>. >
> href="#Request.RelRootPath#search/itemDetail_#mySearchQuery.key#.html">#MySearchQuery.Title#
> > > neq 0>#DollarFormat(mySearchQuery.custom2)#
> >
> >
> >
> > > isDefined('mySearchQuery.custom1') and mySearchQuery.custom1 neq "" and
> > mySearchQuery.custom1 neq " ">
> > > href="#Request.RelRootPath#search/itemDetail_#mySearchQuery.key#.html"
> > title="View Details of #MySearchQuery.Title#"> >
> src="#Request.RelRootPath#zimages/uploadedItemImages/thumbnail/#mySearchQuery.custom1#"
> > title="#MySearchQuery.Title#" alt="Used Business Equipment, SAVE MONEY"
> > height="45px">
> >
> > > href="#Request.RelRootPath#search/itemDetail_#mySearchQuery.key#.html"
> > title="View Details of #MySearchQuery.Title#"> > src="#Request.RelRootPath#zimages/noImageFiller.gif" height="45px">
> >
> >
> > #searchSummary# (#Round(score * 100)#% Match)
> >
> >
> >
> >
> >
> > THERE WERE NO EXACT MATCHES FOR
> > '#UCASE(exactSearch)#'.
> >
> >
> >
> >
> >
> > And assuming I have found the information you looking for this would be the
> > cfindex guess.
> >
> >
> >
> > SELECT itemName, itemDescription, itemKeywords, itemID,
> > itemThumbnail, itemListPrice, itemLeaseNumber
> > FROM tblItem, tblkItemStatus
> > WHERE tblItem.itemStatusID = tblkItemStatus.itemStatusID
> > AND tblkItemStatus.itemStatusMainID = 2
> >
> >
> >
> > > collection="itemCollection"
> > action="refresh"
> > type="custom"
> > body="itemName, itemDescription, itemKeywords, itemLeaseNumber"
> > custom1="itemThumbnail"
> > custom2="itemListPrice"
> > key="itemID"
> > title="itemName"
> > query="getItems">
> > > subject="COLLECTION INDEXING"
Re: CFMX / IIS Crash
LOL...reminds me of a competition MS had once...put a Windows box outside their firewall and said "hack it if you can"it crashed before anyone had a chance ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com.cfm/54 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184761 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 / IIS Crash
it would be interesting to see the test results of having 2 windows machines running the exact hardware specs, OS and patches installed, MX and databases but one is running IIS and the other Apache. they are turned on the same time and presto... the game's afoot! hmmm... =) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184760 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: CFMX / IIS Crash
Yeah..maybe but if you are bound to MS you have no choice... -Original Message- From: Lawrence Ng [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 17:05 To: CF-Talk Subject: RE: CFMX / IIS Crash I wonder if the same would happen if one were to use Apache (if it's IIS crashing or root of it in the first place) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184759 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: CFMX / IIS Crash
I wonder if the same would happen if one were to use Apache (if it's IIS crashing or root of it in the first place) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184758 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: CFMX / IIS Crash
Hmmm, really..very strange. Keep me posted if you find anything helpful. Are you finding that all of a sudden CF queues build up and then bam...nada? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 16:45 To: CF-Talk Subject: RE: CFMX / IIS Crash > Anyone ever seen the situation where IIS comes to blows where IIS crashes > when in use with CFMX - no real sign of why...just stops!? Yes. I'm trying to find out what the cause it now. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184757 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: Reference to complex var not destroyed
> To make a long story short, you guys are saying a reference > does not get deleted when the reference to the object (or the > object) gets deleted, and this is normal behavior. > > It's the following comments though that are still vague, "it > could be" and "maybe". I'm just trying to fully understand > what is *really* going on ;-) > > > It could be that, when you delete the last reference to the > > object, CF deletes the object itself. Or maybe CF doesn't and > > the garbage collector does it later. Well, to be perfectly honest, from a functionality perspective you simply don't need to know that. All that matters to you is that once you destroy all the references to an object, you can no longer access that object. Unless you're dealing with relatively obscure performance tuning stuff, you don't have to know much about garbage collection. That's the appeal of garbage collection - you don't have to manually destroy objects like you would in languages like C++. > In the end what I was hoping for was that when I set a > complex structure in the application scope and then create a > reference to it in the server scope, the one in the server > scope get deleted when the application scope times out.. That's not going to happen, for the reasons I've mentioned. If you want to get rid of something that is passed by reference, you will have to delete all of the references to that thing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184756 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: CFMX / IIS Crash
> Anyone ever seen the situation where IIS comes to blows where IIS crashes > when in use with CFMX - no real sign of why...just stops!? Yes. I'm trying to find out what the cause it now. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184755 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: Macromedia gives up on the server market in Australia and wal ks away.
> Arguments about shorter product development times, Blackstone > etc. were reacted on with ".. ASP.NET is our future, we are > done with Macromedia". I don't know if you caught my response yesterday, but you may want to investigate BlueDragon.NET, which will let you keep most or all of your investment in your current codebase while letting you run within the .NET Framework. BlueDragon.NET is a first-class .NET environment, and generates the same MSIL that ASP.NET does - and has fantastic integration with ASP.NET. It's still in beta, but should be available within an acceptable timeframe for your use. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184754 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: Outsourcing
There was just a post about IIS failing for no sane reason. I'm getting that as well which is why HoF looks like its down. I'm on it. > -Original Message- > From: Douglas Knudsen [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 18, 2004 11:32 AM > To: CF-Talk > Subject: Re: SOT: Outsourcing > > why not post arequest for developers over on cf-jobs? There are many > frelance and contractors around that may be interested as well as > part-time frelancers, like myself, that would be interested. Also, > you can post job related questions/discussions on cf-jobstalk, IIRC. > See http://www.houseoffusion.com/cf_lists/ > > Yo Mike D, http://www.houseoffusion.com/cf_lists/ is down? I can't > get to it. Could just be a DNS failure in my company though. > > Doug > > > On Thu, 18 Nov 2004 08:55:19 -0500, Ryan Emerle <[EMAIL PROTECTED]> wrote: > > Has anyone had any success outsourcing large projects, or portions of > > large projects, overseas or to temporary/freelance employees? Any > > pros/cons to either? Any resources you can offer to someone exploring > > his options? > > > > Basically, we're looking to supplement our current resources while the > > company grows. Unfortunately our timeline does not allow much > > flexibility to train new full/part time employees. > > > > Any help would be appreciated. Personal experiences would be extremely > helpful. > > > > Thanks! > > -- > > Ryan Emerle > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184753 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: Image color info?
> I > know it doesn't support cmyk so that format should either > blow up or come back with unknown. What is the point in recommending a commercial product that someone would have to pay for when you state that you KNOW it doesn't support one of the formats in question? Especially when you take into account the fact that CFX_ImageInfoMX has already been recommended and confirmed to work. -- Jay ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184752 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: Outsourcing
why not post arequest for developers over on cf-jobs? There are many frelance and contractors around that may be interested as well as part-time frelancers, like myself, that would be interested. Also, you can post job related questions/discussions on cf-jobstalk, IIRC. See http://www.houseoffusion.com/cf_lists/ Yo Mike D, http://www.houseoffusion.com/cf_lists/ is down? I can't get to it. Could just be a DNS failure in my company though. Doug On Thu, 18 Nov 2004 08:55:19 -0500, Ryan Emerle <[EMAIL PROTECTED]> wrote: > Has anyone had any success outsourcing large projects, or portions of > large projects, overseas or to temporary/freelance employees? Any > pros/cons to either? Any resources you can offer to someone exploring > his options? > > Basically, we're looking to supplement our current resources while the > company grows. Unfortunately our timeline does not allow much > flexibility to train new full/part time employees. > > Any help would be appreciated. Personal experiences would be extremely > helpful. > > Thanks! > -- > Ryan Emerle > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184751 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: Macromedia gives up on the server market in Australia and wal ks away.
> [quote]Well, actually, have you checked out ASP.NET > 2.0[/quote] no not really and i wont until billy comes over > and sucks a fart outta my azz and refunds me all the money > hes ripped me off for! haha Luckily, i dont have to work for > anyone, especially where'd i'd be in a position to have to > support some crap azz'd company like m$. Everyone works for someone - if you're your own boss, you work for your customers, right? If you can give your customers a better deal using a product from company XYZ rather than company ABC, but you choose not to because you fell that "Billy ripped you off", you may well get fired if you know what I mean. > sure maybe the stuff is good and great but i also have a > choice and my choice is to give my devotion to a decent > company..aka MM and i dont use anything that that the others > have that cfm doesnt but i am also a salesman and selling cfm > aint that hard! If you're looking for decency within a publicly traded company, you're wasting your time. What makes Macromedia good is the quality of their products. To the extent that there are better products available, you'd be foolish to stick with Macromedia because they're "decent", whatever that means. Personally, I think that for most web development tasks, Macromedia tools are better than their competition, and I choose to use their tools as a result. But they don't have my devotion for one minute, let me tell you. Save your devotion for Mom and apple pie; it's not a wise business practice. I choose to use their tools because they're better, and I can do better things for my customers with their tools. I'm confident that they're going in the right direction with their development, especially with Breeze, Flex and Blackstone. But that doesn't mean that I don't want to know what else is out there, and it doesn't mean that for some applications there aren't better solutions. > now come on dave, i didnt ever say u couldnt use other things > to connect to those. Hell, if u could pop out a turd with > info in it, flash could probably get the info out! That wasnt > what i was saying at all. now was flex and remoting built around > cfm? U BETCHA! and u cant say it wasnt, sure u can use other things > too but flash w/remoting, and flex where really built around using > cfm as the backend. Watch the vids on MM they even say so, then > look at it. Do you think you can do without so many ass references? I like ass references as much as the next guy, maybe more, but this is probably not the best place for them. In any case, I'm incapable of producing turds that are well-formed, in the XML sense of the term. Anyway, I defy you to point out where anyone from Macromedia says that either Flex or Flash Remoting were built around CF as the back end. CFMX comes with Flash Remoting because Flash Remoting is a Java server application, not because there's anything special about using CFMX with Flash Remoting as opposed to using any J2EE application with Flash Remoting. If you buy a standalone JRun license, you get Flash Remoting. > flex~ same almost, sure u can use anything to get data in but > it was made to really work with cfml and maybe thats why u > can run flex straight within your cfml code. as far as i know > you cant do that with the others right? Sure you can! Flex code is simply a declarative language expressed using XML, so you can generate Flex code with JSP/servlets, I'd guess. It's worth pointing out that, with a default install of both CFMX and Flex on top of JRun, neither works directly with the other as they get installed into separate JRun servers. You have to install them both within the same JRun server (requiring a decent amount of futzing with text configuration files) to get this effect, I think. I suspect that most Flex customers are not CFMX customers, either. The Flex course that Macromedia offers doesn't even mention using Flex with CFMX, if I recall correctly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184750 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: An exception occurred when executing a Com method
> This is not a JAVA component, I am aware that coldfusion is not good > to initiate the NON JAVA Components. > But this component is perfectly working in ASP. There must be a way to > work around to initiate the component in coldfuion. > > Is any software which creates the virtual environment (which is used > by ASP). > > Anything which is possible to create the object with the COM component. > > > The following is my code. > type="com"> > > its not generating the error on this line, its generating error when I > dump it. > > What does it means, the component will create when I use it or the > component will create with the line of code I wrote above? > > > thanks all ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184749 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: Macromedia gives up on the server market in Australia and wal ks away.
Those of us in IT can't just look at the technology anymore. We must adopt a mgmt mindset. Like anything else, if there are more say MS/ or Java/JSP or PHPor other developers than CF developers then it would stand to reason that mgmt would prefer to look at a platform that has a larger base. I think their mindset is that the more people there are using a particular platform, there would be more support for it. I'm not saying this may be the case but as most of you correctly pointed out, we should use the technology for what mgmt wants to support (note that I did say the best. If mgmt supports it, then you'll have better support) and to deliver their projects on time and at a reasonable costs. If I was running a company, I'd want to know how this technology is saving me money, time and making me more profitable. =) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184748 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: Oracle SQL date compare question...
aha... yeah it defaults to midnight, I did some research.. I already had a fix, as noted in my previous message but thanks for the explaniation On Thu, 18 Nov 2004 09:21:45 -0600, Deanna Schneider <[EMAIL PROTECTED]> wrote: > Because there's no such thing in Oracle as a date without a time. It > defaults to midnight, I believe, on a standard install. So, while you may > not have put a time in - it is in there. > > You have two options - format the startdate and finishdate to truncate their > time portions - so that you're just limiting on date OR add time portions to > your periodend (23:59:59) and periodstart (00:00:01). > > -d > > > > > > in the above instance periodend = '11/30/2004' > > and periodstart = '11/30/2004' > > > > so why doesnt > > WHERE t.startdate (+) <= p.periodend > > AND t.finishdate (+) >= p.periodstart > > pick up that task? > > But > > WHERE t.startdate (+) <= p.periodend + 1 > > AND t.finishdate (+) >= p.periodstart > > does > > and without the joins > > WHERE trunc(t.startdate) <= p.periodend > > AND trunc(t.finishdate) >= p.periodstart > > works. > > > > Can someone explain?.. > > > > Thanks! > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184747 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 / IIS Crash
Anyone ever seen the situation where IIS comes to blows where IIS crashes when in use with CFMX - no real sign of why...just stops!? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184746 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: Outsourcing
We've outsourced oversees and domestically. I think everyone involved in my company agreed that the oversees work was a disaster. The code that came back sometimes worked, sometimes didn't. Managing the project was a huge time sink. And the time difference it made everything an order of magnitude more difficult. Domestically has been only slightly better. I think there were a few problems - on both sides. We have an incredibly complex business model. Therefore, anything we do ends up very complex. I think the person managing the project could have done a better job at identifying and communicating our needs. And, I don't think the consultants did a very good job of asking questions. The end result, is something that works, but the code is written with poor coding standards, is poorly documented (no commenting), and is so brittle that indications are that it will take twice as much work to implement customizations. My best suggestion if you are going to outsource is to require that you get example code from whomever is actually going to be coding the project. Then have one of your developers pick it apart to get an idea of whether it meets your standards. --Jeff On 11/18/2004 8:55 AM, Ryan Emerle wrote: > Has anyone had any success outsourcing large projects, or portions of > large projects, overseas or to temporary/freelance employees? Any > pros/cons to either? Any resources you can offer to someone exploring > his options? > > Basically, we're looking to supplement our current resources while the > company grows. Unfortunately our timeline does not allow much > flexibility to train new full/part time employees. > > Any help would be appreciated. Personal experiences would be extremely > helpful. > > Thanks! > -- > Ryan Emerle > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184745 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
