MSDE / CFTransaction
When I use cftransaction around queries run against a MSDE datasource - Username and Password passed in the CFQuery tag rather than stored in the Datasource - then I get a warning error in my Application Log: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01 The transaction processing appears to be honoured and roles-back if not all queries complete. As there seems to be no problem, why am I getting this warning and can I do anything about it? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223159 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: Cfchart hanging
Try it anyway - we just yesterday had a similar problem where my site could get a chart no problems, while every other site on the server couldn't, even with identical sandboxes. We then added explicit read/write access to the chart cache for an account that couldn't and it worked like mine (which had no such access). On 11/4/05, Snake [EMAIL PROTECTED] wrote: Yes sandboxing is in use, but we use it on all servers, and cfchart works on those. Russ -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 00:18 To: CF-Talk Subject: Re: Cfchart hanging Do you use sandboxing? If so, allow the sandbox access to the the chart cache directory. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223160 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: MSDE / CFTransaction
What happens if u do put the username/passwor dinto the DSN ? -Original Message- From: Peter Shaw [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 07:10 To: CF-Talk Subject: MSDE / CFTransaction When I use cftransaction around queries run against a MSDE datasource - Username and Password passed in the CFQuery tag rather than stored in the Datasource - then I get a warning error in my Application Log: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01 The transaction processing appears to be honoured and roles-back if not all queries complete. As there seems to be no problem, why am I getting this warning and can I do anything about it? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223161 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: Passing null dates via WDDX
You can't pass an empty date, but you can pass a null. From http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/xml45.htm Null values in WDDX are not associated with a type such as number or string. The cfwddx tag converts WDDX Nulls to empty strings. On 11/4/05, Chris Velevitch [EMAIL PROTECTED] wrote: How do you pass null dates via wddx? When I try passing:- var name='resetdate' datetime/datetime /var as part of my wddx data, cfwddx action='wddx2cfml' generates an invalid WDDX packet error. This data will be inserted in a database where this column will access nulls. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223162 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: Cfchart hanging
Dammit, it's the exact same problem and solution I had last time. I decided to blog it this time so I don't forget again :-) http://lordmichaels.blogspot.com/ -- Russ -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 08:42 To: CF-Talk Subject: Re: Cfchart hanging Try it anyway - we just yesterday had a similar problem where my site could get a chart no problems, while every other site on the server couldn't, even with identical sandboxes. We then added explicit read/write access to the chart cache for an account that couldn't and it worked like mine (which had no such access). On 11/4/05, Snake [EMAIL PROTECTED] wrote: Yes sandboxing is in use, but we use it on all servers, and cfchart works on those. Russ -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 00:18 To: CF-Talk Subject: Re: Cfchart hanging Do you use sandboxing? If so, allow the sandbox access to the the chart cache directory. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223163 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: what do you use instead of cfx_openimage?
Just using the available underlying methods in the JVM. -Original Message- From: Sebastian Mork [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 00:43 To: CF-Talk Subject: what do you use instead of cfx_openimage? is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223164 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: what do you use instead of cfx_openimage?
Alagad Imaging Component. No custom tag to install, no Java to explore, just a CFC to drop in. And it works. It does a lot, and I think it's well worth the price - I think it's like $75. On 11/3/05, Sebastian Mork [EMAIL PROTECTED] wrote: is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223166 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
OT: New Updates
A new update for the Zip CFC is available. There was a bug running the CFC on ColdFusion MX 6, but now it is fixed. You can download the Zip v1.2 CFC here: http://download.newsight.de/com/Zip.zip I have also updated the ColdFusion Functions for ActionScript. I add new string functions and few new list functions. You can download the new version here: http://download.newsight.de/as/CFFunctions.zip Enjoy! Artur ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223167 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: what do you use instead of cfx_openimage?
I use Massimo Foti's tmt_img for resizing images and getting dimensions. It's free and it works great. Email me offline if you need some code samples. Pete ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223168 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: what do you use instead of cfx_openimage?
Is Alagad capable of automatically resizing an image uploaded by someone to a site? I would imagine so, but just checking -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 6:29 AM To: CF-Talk Subject: Re: what do you use instead of cfx_openimage? Alagad Imaging Component. No custom tag to install, no Java to explore, just a CFC to drop in. And it works. It does a lot, and I think it's well worth the price - I think it's like $75. On 11/3/05, Sebastian Mork [EMAIL PROTECTED] wrote: is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223169 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: what do you use instead of cfx_openimage?
there's not much it can't do...to be honest! On 11/4/05, Tim Laureska [EMAIL PROTECTED] wrote: Is Alagad capable of automatically resizing an image uploaded by someone to a site? I would imagine so, but just checking -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 6:29 AM To: CF-Talk Subject: Re: what do you use instead of cfx_openimage? Alagad Imaging Component. No custom tag to install, no Java to explore, just a CFC to drop in. And it works. It does a lot, and I think it's well worth the price - I think it's like $75. On 11/3/05, Sebastian Mork [EMAIL PROTECTED] wrote: is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223170 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: what do you use instead of cfx_openimage?
Pete... I guess I would ask the same question about the tmt_img component... Does it have the capabilities to automatically resize an image uploaded by someone to a site? Thanks Tim -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 6:42 AM To: CF-Talk Subject: Re: what do you use instead of cfx_openimage? I use Massimo Foti's tmt_img for resizing images and getting dimensions. It's free and it works great. Email me offline if you need some code samples. Pete ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223171 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: what do you use instead of cfx_openimage?
thanks for your suggestions.. well, in my app I used cfx_openimage (and now tried cfx_image) but since a few days the cfx produces 500 errors (500 null, java servlet error) as I read here (sandbox vs. cfx) http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:40918 the sandbox-security maybe a problem.. the strange thing is, it worked for months on the server my app is running (shared host.env.,cfmx7, sandbox security) and I dont wanna change everything. so I tried cfx_image, too instead of cfx_openimage.. I always get 500 errs now. hmm maybe someone has an idea? or I'll have to try an alternative tool -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 19:48:46 -0500 Claude Schneegans [EMAIL PROTECTED] wrote: what are you using? CFX_image -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223172 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: MSDE / CFTransaction
The same thing happened with Oracle for us. We moved everything that required a transaction to stored procs, or creating special datasources when converting to stored procs was unreasonable. I don't think we ever did find out the underlying cause. On 11/4/05, Peter Shaw [EMAIL PROTECTED] wrote: When I use cftransaction around queries run against a MSDE datasource - Username and Password passed in the CFQuery tag rather than stored in the Datasource - then I get a warning error in my Application Log: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01 The transaction processing appears to be honoured and roles-back if not all queries complete. As there seems to be no problem, why am I getting this warning and can I do anything about it? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223173 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: what do you use instead of cfx_openimage?
I'll look at Massimo Foti's tmt_img .. thx -- Sebastian Mork [EMAIL PROTECTED] -- On Fri, 4 Nov 2005 06:42:04 -0500 Pete Ruckelshaus [EMAIL PROTECTED] wrote: I use Massimo Foti's tmt_img for resizing images and getting dimensions. It's free and it works great. Email me offline if you need some code samples. Pete ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223174 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
SOLVED: Need query help please
Here's my final solution for the query - a self-join. cfquery name=getimages datasource= SELECT TBIG.prodimagefilename AS FullSizeImageFilename, TLITTLE.prodimagefilename AS ThumbnailImageFilename FROM tblimages_rel TBIG, tblimages_rel TLITTLE WHERE TBIG.prodID = #URL.prodID# !--- Matches only rows of product ID you want in the full-size version of table --- AND TBIG.prodID = TLITTLE.prodID !--- Joins the two versions of the table --- AND TBIG.ImageTypeID = 2 !--- tells it to limit this table to full-size images --- AND TLITTLE.ImageTypeID = 1 !--- tells it to limit this table to thumbnail images --- /cfquery Thanks for the tips. And thanks matthieu for this sql. Will ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223165 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: what do you use instead of cfx_openimage?
I use Massimo's tmt_img CFC. it works perfectly for those things. http://www.olimpo.ch/tmt/cfc/tmt_img/ !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Sebastian Mork [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 6:43 PM To: CF-Talk Subject: what do you use instead of cfx_openimage? is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223175 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: MSDE / CFTransaction
Deanna is right on. For some reason cftransaction makes seperate db calls outside of the cfquery and it does not use the the username/password specified in the cfquery. If you do not store the username/password in the DSN (which you shouldn't) you are going to get theses errors. Like Deanna, we just removed all transactional processing out of CF and into stored procedures. -Adam On 11/4/05, Deanna Schneider [EMAIL PROTECTED] wrote: The same thing happened with Oracle for us. We moved everything that required a transaction to stored procs, or creating special datasources when converting to stored procs was unreasonable. I don't think we ever did find out the underlying cause. On 11/4/05, Peter Shaw [EMAIL PROTECTED] wrote: When I use cftransaction around queries run against a MSDE datasource - Username and Password passed in the CFQuery tag rather than stored in the Datasource - then I get a warning error in my Application Log: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01 The transaction processing appears to be honoured and roles-back if not all queries complete. As there seems to be no problem, why am I getting this warning and can I do anything about it? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223176 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
XML Is or NOT?
This may be a basic question, but I am recieving some XML and it could be a valid response or it could be an error response... BOTH are valid XML, but they are formatted differently. I need to check to see if it is the error or not ... If I check for the error XML, and it is not, it errors out saying it isn't valid XML... how do you check to see if it is a particular XML document and not error if it is not? Make sense? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223177 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 webservice consumed via .NET
My thoughts - I *think* if you were to create a .NET object that mirrors the structure of the query object, .NET would probably be able to use the query type returned from CF. However, it would probably be easiest to serialize the output of the query into an XML string and just pass it via the webservice as a string, which could easily be read by .NET. - Matt Small -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 4:58 PM To: CF-Talk Subject: CF webservice consumed via .NET Hey All, I've read lots of old posts saying the WDSL datatype of QueryBean (which is what CF queries get passed as from CF web services). I can't find anything recent.. One old post says nothing but CF can convert that datatype back into a query So...can .NET consume CF web service that returns a query? If so...please shed some light ;-) TIA 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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223178 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 Is or NOT?
Check the HTTP headers. It's somewhat common to throw a 500 response in the event of an error. -Adam On 11/4/05, Paul Giesenhagen [EMAIL PROTECTED] wrote: This may be a basic question, but I am recieving some XML and it could be a valid response or it could be an error response... BOTH are valid XML, but they are formatted differently. I need to check to see if it is the error or not ... If I check for the error XML, and it is not, it errors out saying it isn't valid XML... how do you check to see if it is a particular XML document and not error if it is not? Make sense? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223179 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 Is or NOT?
One of the nodes of the XML string is NOT there unless it is an error .. XMLResponse.thisPacket.error If all is fine with the request the .error is not there ... how do I check to see if .error element is defined ... Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Adrocknaphobia [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, November 04, 2005 8:26 AM Subject: Re: XML Is or NOT? Check the HTTP headers. It's somewhat common to throw a 500 response in the event of an error. -Adam On 11/4/05, Paul Giesenhagen [EMAIL PROTECTED] wrote: This may be a basic question, but I am recieving some XML and it could be a valid response or it could be an error response... BOTH are valid XML, but they are formatted differently. I need to check to see if it is the error or not ... If I check for the error XML, and it is not, it errors out saying it isn't valid XML... how do you check to see if it is a particular XML document and not error if it is not? Make sense? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223180 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: MSDE / CFTransaction
That's interesting. So doe sthis mean that CFTRANSACTION doesn't work unless your username/passwor dare in the DSN? Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 14:04 To: CF-Talk Subject: Re: MSDE / CFTransaction Deanna is right on. For some reason cftransaction makes seperate db calls outside of the cfquery and it does not use the the username/password specified in the cfquery. If you do not store the username/password in the DSN (which you shouldn't) you are going to get theses errors. Like Deanna, we just removed all transactional processing out of CF and into stored procedures. -Adam On 11/4/05, Deanna Schneider [EMAIL PROTECTED] wrote: The same thing happened with Oracle for us. We moved everything that required a transaction to stored procs, or creating special datasources when converting to stored procs was unreasonable. I don't think we ever did find out the underlying cause. On 11/4/05, Peter Shaw [EMAIL PROTECTED] wrote: When I use cftransaction around queries run against a MSDE datasource - Username and Password passed in the CFQuery tag rather than stored in the Datasource - then I get a warning error in my Application Log: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01 The transaction processing appears to be honoured and roles-back if not all queries complete. As there seems to be no problem, why am I getting this warning and can I do anything about it? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223181 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: [SPAM : 8.1] Re: Rumors from Max...
No, wasn't Heaven's Gate the last decent movie Warren Beatty ever made? Warren Beatty is a CF user? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223182 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
flash forms flipping a panel
is it possible to flip a panel around 180 degrees?.. so it's upside down? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223183 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: flash forms flipping a panel
Turn your monitor upside down. -Original Message- From: Alexander Hinkley [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 14:47 To: CF-Talk Subject: flash forms flipping a panel is it possible to flip a panel around 180 degrees?.. so it's upside down? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223184 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: XOR
This is not strictly true. 1 and 2, evaluated as booleans, are both true. However, they are not equal. So, (1 XOR 2) != (1 neq 2) --Ben the nitpicker Doom Claude Schneegans wrote: real world example where you would need a statement like this? Not really, actually, because (a XOR b) is equivalent to (a NEQ b) which is much more intuitive. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223185 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: what do you use instead of cfx_openimage?
There's no such thing as automatically unless you're talking about the new gateway processes in CF7. Everything has to have code behind it to TELL it to do something. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 6:14 AM To: CF-Talk Subject: RE: what do you use instead of cfx_openimage? Pete... I guess I would ask the same question about the tmt_img component... Does it have the capabilities to automatically resize an image uploaded by someone to a site? Thanks Tim -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 6:42 AM To: CF-Talk Subject: Re: what do you use instead of cfx_openimage? I use Massimo Foti's tmt_img for resizing images and getting dimensions. It's free and it works great. Email me offline if you need some code samples. Pete ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223186 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: [SPAM : 8.1] Re: Rumors from Max..
That was a scandalous comment, but I have to agree with him. If CF didn't make the move to Java when it did, I doubt it would have the market penetration it does today. (At least speaking from the federal government perspective) -Adam On 11/2/05, Terry Troxel [EMAIL PROTECTED] wrote: Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel -Original Message- From: Stephen Cassady [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 5:23 PM To: CF-Talk Subject: [SPAM : 8.1] Re: Rumors from Max.. (1) Full Open Source would be bad: who would pay to keep Ben's beard well trimmed? (2) If there is a movement to Open Source CF, then I would suggest the following: a) Standard becomes Free. Does almost everything. b) Enterprise remains cost, but drops in price (I would keep paying for that) c) the Split between Standard and Enterprise is handled the same way Red Hat handles their free and non-free code. They get paid for advanced versions, which keeps a development team, and those features move down into the free version. d) I'm totally excited about Adobe + ColdFusion: a platform for them to continue their push of web-changing technology, more resources, an even better brand name from recognition and acceptance, a wide group of people to market to. I think there is powerful synergy. e) Full open source = slowed development of platform and the inability to do what they did between 5 and 6 (which was needed to save the product) - open source could never muster the time, talent, costs, or (most importantly) the political consensus to make such a major change to a product. Stephen Cassady I still like my ColdFusion very much thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223187 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: [SPAM : 8.1] Re: Rumors from Max..
If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223188 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: flash forms flipping a panel
while retaining the right-up-sidedness of the rest of the page... sorry forgot to add that bit... On 11/4/05, Snake [EMAIL PROTECTED] wrote: Turn your monitor upside down. -Original Message- From: Alexander Hinkley [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 14:47 To: CF-Talk Subject: flash forms flipping a panel is it possible to flip a panel around 180 degrees?.. so it's upside down? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223189 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 join a table to a set of values not in a table.
Here is the solution I put together. Any comments on how this could be
simplified.
cfscript
currentDate = arguments.beginDate;
dateString = SELECT TO_DATE(' dateFormat(currentDate,mm/dd/)
', 'mm/dd/') AllDates FROM DUAL;
currentDate = dateAdd(d,1,currentDate);
while (dateCompare(currentDate,arguments.endDate) LTE 0)
{
dateString = dateString UNION ;
dateString = dateSTring SELECT TO_DATE('
dateFormat(currentDate,mm/dd/) ', 'mm/dd/') AllDates FROM DUAL;
currentDate = dateAdd(d,1,currentDate);
}
/cfscript
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223190
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 join a table to a set of values not in a table.
Our DBA created a days table with days and weekending column from 2002
until 2009 for us... That would have made it a lot simplier, heh.
And it's not all that large either. 2922 rows, 2 columns.. not large at all.
Then you could have done it all within SQL and not have to rely on CF.
On 11/4/05, Ian Skinner [EMAIL PROTECTED] wrote:
Here is the solution I put together. Any comments on how this could be
simplified.
cfscript
currentDate = arguments.beginDate;
dateString = SELECT TO_DATE('
dateFormat(currentDate,mm/dd/) ', 'mm/dd/') AllDates FROM DUAL;
currentDate = dateAdd(d,1,currentDate);
while (dateCompare(currentDate,arguments.endDate) LTE 0)
{
dateString = dateString UNION ;
dateString = dateSTring SELECT TO_DATE('
dateFormat(currentDate,mm/dd/) ', 'mm/dd/') AllDates FROM DUAL;
currentDate = dateAdd(d,1,currentDate);
}
/cfscript
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223191
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: [SPAM : 8.1] Re: Rumors from Max..
So forget about the java improvements. The fact that everything is exposed in structs now is worth its weight in gold. I'm moving over my last CF 5 server to CF 7 within the next few days. I can't wait to be able to do proper debugging with halfway decent diagnostics. Never had any connectivity issues with db's. If anything they work better. Sure you have to remake the odbc connections into jdbc. Never had a problem with SQL, mySQL or Access. You have to add Oracle drivers but thats not the end of the world. Then there's the U word. And the acronym CFC is similarly telling. Hey if you think CF5 is It, stay there. But you're sitting on a dead-end platform and its going to slowly become increasingly more difficult to drop in software from the community as people drop CF5 compatibility. I'm doing that with my next product release. Its time. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223192 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 join a table to a set of values not in a table.
quote Our DBA created a days table with days and weekending column from 2002 until 2009 for us... That would have made it a lot simpler, heh. And it's not all that large either. 2922 rows, 2 columns.. not large at all. Then you could have done it all within SQL and not have to rely on CF. /quote That was proposed, but for some reason, it did not go over with our senior DBA. Yes it would have been easier. Ours would have to be a bit bigger. The date range would have to be 1987 or so to some time in the future. But still would have been easier. The ultimate solution IMHO is a stored procedure. But no one here has created stored procedures that return record sets. So this solution is a good stop gap until I can figure out the stored procedure solution. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223193 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: [SPAM : 8.1] Re: Rumors from Max..
Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223194 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: what do you use instead of cfx_openimage?
Many people use our tag, cfx_imagecr3. Some hosts install it on all their servers. Efflare ImageCR 3 http://efflare.com/products/cfx_imagecr $75 personal license http://efflare.com/purchase?personal -- CrystalM is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223195 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: [SPAM : 8.1] Re: Rumors from Max..
Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. which would be never in my own personal experience running a CFMX server I mean, since we're being all anecdotal and stuff... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223196 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: [SPAM : 8.1] Re: Rumors from Max..
Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223197 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
No ColdFusion Search Service
I just installed a copy of CF 7.01 to do some testing for a client migration from 5 to 7 and there is no search service installed. I installed it as a 30day trial and didn't get any errors in the installation log. anyone have any idea why i wouldn't have the search service? I need this to test the verity collection scritps they have on there site. TIA jonese ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223198 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: XOR
XOR is more succinct where there are more than 2 terms. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 6:13 PM To: CF-Talk Subject: Re: XOR XOR coerces it's operands to boolean, while NEQ doesn't. Exact. But what I mean is that if someone has to use an XOR operator, the situation is actually a NEQ issue, he will think of NEQ first, and do what must be done to make sure both operands are boolean. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223199 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: [SPAM : 8.1] Re: Rumors from Max..
Umm, We actually support both CF5 and CFMX in our environment. Both are pretty stable for what they do. But things like CFCs in CFMX do make life a whole lot easier. George On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223200 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
FW: Strange DB behaviour
This is a weird problem we have once in a blue moon, I keep forgetting to ask if anyone else has had it. Sometimes a developer adds a new table or a new field to an exisitng data, or even a new row of data. But ColdFusion thinks it doesn't exist. We get an error saying no such table or column, and the resultset will not include the new row. And no the queries are not being cached (as least not in the code). I had experienced this on many different servers in different locations, and it appears to be random. I have had to reboot the server in most cases to get rid of the problem. -- Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223201 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 join a table to a set of values not in a table.
That method is actually detailed in the Oracle SQL books from Oracle Press. It may seem redundant, but it is the most optimum method as far as performance is concerned. -Adam On 11/4/05, Greg Morphis [EMAIL PROTECTED] wrote: Our DBA created a days table with days and weekending column from 2002 until 2009 for us... That would have made it a lot simplier, heh. And it's not all that large either. 2922 rows, 2 columns.. not large at all. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223202 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: No ColdFusion Search Service
Search services and ODBC services are optional installation choices. I don't know if you can add them after the fact without doing a re-install. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223203 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: [SPAM : 8.1] Re: Rumors from Max..
CF 6+ only sucked until I got my house in order, codewise. Now the only time I need to restart/reboot is when MS introduces a new security patch. I've got a client that moved from CF5 to 6.1 just a couple months ago (they had an unused Enterprise license already and didn't want to pay for 7) and they were going thru the MX sucks what up phase until I went in and tweaked the server settings back to reality, moved a couple of Access db's to SQL Server and hunted up some silly code. Nobody ever wants to hear its their own fault but time after time you see buggy servers made that way by suboptimal code and setup. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223204 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 MX 7.0.1 Cumulative Hot Fix 1 Available
FYI, we just released ColdFusion MX 7.0.1 Cumulative Hot Fix 1 (CHF1). This CHF is recommended for customers running ColdFusion MX 7.0.1 if they are experiencing one or more of the specific fixed issues listed, and then only to ColdFusion MX 7.0.1. Get it here: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=aae43964 Regards, Damon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223205 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: [SPAM : 8.1] Re: Rumors from Max..
dude, 7 is the bomb and i dont know how else to say it. and do this, stay on 5, so that when we are on scorpio we can laugh even louder. :) jk really, but seriously, i would def. make the upgrade WAYY worth it. tw On 11/4/05, Matt Robertson [EMAIL PROTECTED] wrote: CF 6+ only sucked until I got my house in order, codewise. Now the only time I need to restart/reboot is when MS introduces a new security patch. I've got a client that moved from CF5 to 6.1 just a couple months ago (they had an unused Enterprise license already and didn't want to pay for 7) and they were going thru the MX sucks what up phase until I went in and tweaked the server settings back to reality, moved a couple of Access db's to SQL Server and hunted up some silly code. Nobody ever wants to hear its their own fault but time after time you see buggy servers made that way by suboptimal code and setup. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223206 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 7 Trial/Developer: Make if CF Std with S/N?
With any luck I am building a server this weekend. I'll be doing it via Terminal Server connections. One of the things I want to do is download CF7 from MM and put in my CF7 SN to make it a live CF7 Standard box. Thats do-able, right? I use the Trial (not the Developer) for this? I have a jpg of the CD in its sleeve (with the all-important label w/SN) and a copy of the sales invoice. Nothing else. And is the current build online the latest? Its 7.0.1 and includes the new HF1? Or do I need to add HF1 myself? -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223207 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
Javascript Automatic Time Validation Correction
Does anybody have any code available that will automatically reformat time entered into a form field onchange()? For instance, if someone enters 10am it will automatically convert it to 10:00 AM. This only being one case. I'm sure someone has needed this before, so I figured I'd check here before we write it ourselves. Thanks Ryan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223208 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 6.0 and VSpider
I am working through a problem and I do not have extensive knowledge regarding Verity and the Spider that come with CFMX 6. I did however have this working at one point, but it is now NOT working. Let me recap. I made the necessary change the k2Server.ini file. I have it running as a Service. The INI files reads for my collection: [Coll-0] collPath=C:\CFusionMX\verity\collections\SABORSearch\file collAlias=SABORSearch_file topicSet= knowledgeBase= onLine=2 I created my collection and it is located local to the box. I created a BAT file for scheduling the spider to run nightly. The BAT file looks like this: @echo off cd c:\cfusionmx\lib\_nti40\bin vspider -cgiok -collection C:\CFusionMX\verity\collections\SABORSearch -common c:\cfusionmx\lib\common -start http://localhost/sabor -indinclude * Within the CF Administrator, the Connected Local Verity Collections is in this state: SABORSearchYES YESYES english C:\CFusionMX\verity\collections\SABORSearch\ And the Connected Verity Collections is in this state: localhost 9901 YES NO 125000 Like I said, this was working. The PARTS directory for the collection had about 10 GB of files in it. This is a large site and it was crawling a lot of pages. Each day's catalog looked to be about 500 MB. I have repaired the collection, indexed the collection, optomized the collection, and most recently purged the collection, still nothing will run. Recently, the Spider has stopped working and just hangs right after the Info 2005/10/27 10:28:37 (ind005006) Licensed for local host spidering. This is where is always hangs, until it consumes the memory on the server, 2GB. This server is a Dual Processor 3.0, with 2GB RAM so I do not think the hardware is an issue. I am sure I am just missing something in the configuration, but I have no idea what. Any help would be appreciated. Thanks, Vance Duke -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/161 - Release Date: 11/3/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223209 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: what do you use instead of cfx_openimage?
We are using imagecr3, very good, very stable. gabe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 10:55 AM To: CF-Talk Subject: Re: what do you use instead of cfx_openimage? Many people use our tag, cfx_imagecr3. Some hosts install it on all their servers. Efflare ImageCR 3 http://efflare.com/products/cfx_imagecr $75 personal license http://efflare.com/purchase?personal -- CrystalM is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223210 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 Is or NOT?
-Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 9:09 AM To: CF-Talk Subject: XML Is or NOT? This may be a basic question, but I am recieving some XML and it could be a valid response or it could be an error response... BOTH are valid XML, but they are formatted differently. I need to check to see if it is the error or not ... If I check for the error XML, and it is not, it errors out saying it isn't valid XML... how do you check to see if it is a particular XML document and not error if it is not? Personally if this at all standardized in your organization I'd create an XSD for each of the scenarios (error or data)... you can then XMLValidate to validate the packet against the XSD's to determine what kind of XML you've got. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223211 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
what's wrong with list processing?
I am trying to parse the following kind of file (multiple files - each file containing multiple data lines): Label1 value1 Lavel2 value2 Etc. I am getting the following error: The element at position 2 of dimension 1, of array variable quot;LISTRECORD,quot; cannot be found. What am I doing wrong from the following: !--- look through each file --- cfloop query=get_spd_input cfif FileExists(#application.workdir#speedplot\#spdinput_id#.spdo.ftr) !--- read the file --- cffile action=read file=#application.workdir#speedplot\#spdinput_id#.spdo.ftr variable=myText doing filecfoutput #spdinput_id#.spdo.ftr/cfoutputp/p !--- turn each line into a member of an array --- cfloop index=rc list=#myText# delimiters=#Chr(10)# cfset ListRecord = listtoarray(rc,#chr(10)#) cfloop index=i from=1 to=#arraylen(ListRecord)# cfquery datasource=#application.datasource# name=insertspdo insert into SPDFeatures(spdinput_id, label,Feature_val,filedate) values(#spdinput_id#,#listRecord[1]#,#ListRecord[2]#,'11/04/2005') /cfquery /cfloop /cfloop /cfif /cfloop data inserted into database ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223212 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 Is or NOT?
No this is not something I can do ... I get what I get .. I just have to check to see if XMLResponse.Package.ERROR is valid or not ... Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Jim Davis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, November 04, 2005 10:33 AM Subject: RE: XML Is or NOT? -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 9:09 AM To: CF-Talk Subject: XML Is or NOT? This may be a basic question, but I am recieving some XML and it could be a valid response or it could be an error response... BOTH are valid XML, but they are formatted differently. I need to check to see if it is the error or not ... If I check for the error XML, and it is not, it errors out saying it isn't valid XML... how do you check to see if it is a particular XML document and not error if it is not? Personally if this at all standardized in your organization I'd create an XSD for each of the scenarios (error or data)... you can then XMLValidate to validate the packet against the XSD's to determine what kind of XML you've got. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223213 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 7 Trial/Developer: Make if CF Std with S/N?
just enter the full serial whilst you're installing it...it'll be fine I doubt HF1 would be applied already to 7.0.1 downloads though, jb On 11/4/05, Matt Robertson [EMAIL PROTECTED] wrote: With any luck I am building a server this weekend. I'll be doing it via Terminal Server connections. One of the things I want to do is download CF7 from MM and put in my CF7 SN to make it a live CF7 Standard box. Thats do-able, right? I use the Trial (not the Developer) for this? I have a jpg of the CD in its sleeve (with the all-important label w/SN) and a copy of the sales invoice. Nothing else. And is the current build online the latest? Its 7.0.1 and includes the new HF1? Or do I need to add HF1 myself? -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223214 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: Caching, caching what is doing all this caching?!
there is a known issue with DW that if you use it to upload files to the server that the date timestamp doesn't get updated. the fix is to turn off (uncheck) maintain synchronization information within each site definition jonese Here is the MM page that discusses this issue: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=viewid=KC.a3f38dcfextid=a3f38dcfdialogID=18779259iterationID=2sessionID=4830e633dd9b346b1270stateID=0+0+18781194mode=simple#cf_view -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223215 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 webservice consumed via .NET
I *think* if you were to create a .NET object that mirrors the structure of the query object, .NET would probably be able to use the query type returned from CF. However, it would probably be easiest to serialize the output of the query into an XML string and just pass it via the webservice as a string, which could easily be read by .NET. - Matt Small Thanks Matt... I'm trying to avoid looping over the query to convert it to an XML stringwhen you return thousands of records it sure slows down the service ;-) I'll do it if I have to though. Anybody else have 2 cents to addI know you're out there and I know you've bumped into thiswhere's Barney B. and Dave W.?? ;-) How about structures returned from CF web servicesdoes .NET choke on those as well? TIA 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223216 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 7 Trial/Developer: Make if CF Std with S/N?
just enter the full serial whilst you're installing it...it'll be fine I doubt HF1 would be applied already to 7.0.1 downloads though, jb On 11/4/05, Matt Robertson [EMAIL PROTECTED] wrote: Correct, you can enter your CF7 serial during install or post-install via the Admin. The latest downloadable CF7 bits are 7.0.1. You can apply the CHF1 for CFMX 7.0.1 to that install also via the Admin on the System Information page (click the Update button). Regards Damon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223217 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
Special Characters (Unicode?)
Hey everyone! I have a Filemaker Pro database table that needs to be imported to SQL Server (product data for online store). In order to do this, I tried two approaches. 1. Export data from FMP in CSV format, then import to SQL Server 2. Set up ODBC connection to FMP, then import to SQL Server Both are successful - in that they import the data without errors. The problem is that some columns in the original FMP data contain many special characters (Unicode?), such as bullets, carriage returns, TM symbols, etc. Using the first approach, these characters are preserved in the database after completing the import, but are then displayed on pages as either bizarre symbols or the letter N, depending on the machine accessing the page (see example below). Using the second approach (ODBC), the characters are removed completely during the import. Is there any way that I can preserve/convert the characters for output? It will be a *ton* of work for my client if I use the second approach and they have to manually insert carriage returns, TM's, etc. for thousands of products. Sample HTML output using approach 1 (note the N's): Six Feet Underground 2. Big Shot Dead 3. Know What I Mean? 4. Whatâs Wrong With You (featuring Lady Tigra) 5. A Strong Woman 6. Rough Enough 7. Whatâs The Meaning? 8. Gotta Stay Strong 9. Home Of The Brave 10. Playerâs Theme 11. Burn In Hell 12. Break What? 13. Along In The Graveyard 14. Barking Up The Wrong Tree 15. I Understand That Thanks! Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223218 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: [SPAM : 8.1] Re: Rumors from Max..
Thanks guys. I really do appreciate the input as to why go to CF7. I have all my sites hosted at places that support cf5 only and I guess I will have to dl the developer CF7 if it's available and try it on my Laptop to get up to speed. I have a lot of my stuff using providex odbc Drivers for some clients that have MAS90 Accounting software and therein Lies my reluctance as I do not have any experience switching to a java version If one exists. Terry -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 10:08 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. CF 6+ only sucked until I got my house in order, codewise. Now the only time I need to restart/reboot is when MS introduces a new security patch. I've got a client that moved from CF5 to 6.1 just a couple months ago (they had an unused Enterprise license already and didn't want to pay for 7) and they were going thru the MX sucks what up phase until I went in and tweaked the server settings back to reality, moved a couple of Access db's to SQL Server and hunted up some silly code. Nobody ever wants to hear its their own fault but time after time you see buggy servers made that way by suboptimal code and setup. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223219 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: what's wrong with list processing?
Fixed. Sorry to bother the list. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 8:35 AM To: CF-Talk Subject: what's wrong with list processing? I am trying to parse the following kind of file (multiple files - each file containing multiple data lines): Label1 value1 Lavel2 value2 Etc. I am getting the following error: The element at position 2 of dimension 1, of array variable quot;LISTRECORD,quot; cannot be found. What am I doing wrong from the following: !--- look through each file --- cfloop query=get_spd_input cfif FileExists(#application.workdir#speedplot\#spdinput_id#.spdo.ftr) !--- read the file --- cffile action=read file=#application.workdir#speedplot\#spdinput_id#.spdo.ftr variable=myText doing filecfoutput #spdinput_id#.spdo.ftr/cfoutputp/p !--- turn each line into a member of an array --- cfloop index=rc list=#myText# delimiters=#Chr(10)# cfset ListRecord = listtoarray(rc,#chr(10)#) cfloop index=i from=1 to=#arraylen(ListRecord)# cfquery datasource=#application.datasource# name=insertspdo insert into SPDFeatures(spdinput_id, label,Feature_val,filedate) values(#spdinput_id#,#listRecord[1]#,#ListRecord[2]#,'11/04/2005') /cfquery /cfloop /cfloop /cfif /cfloop data inserted into database ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223220 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: [SPAM : 8.1] Re: Rumors from Max..
Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:58 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223221 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: [SPAM : 8.1] Re: Rumors from Max..
lets see. access cf5 what stone is it that you reside under? sql server and cfmx7 = the way the light and the truth! tw On 11/4/05, Snake [EMAIL PROTECTED] wrote: Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:58 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223222 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: [SPAM : 8.1] Re: Rumors from Max..
I think that likely has more to do with the database drivers than CF itself. If a site is getting so much traffic that its access DB is causing problems, it may be time to move up to MSDE or SQL Server. -Justin -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 12:13 PM To: CF-Talk Subject: RE: [SPAM : 8.1] Re: Rumors from Max.. Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:58 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223223 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: [SPAM : 8.1] Re: Rumors from Max..
You need to run Oracle. We have problems with some sites we migrated from CF5 to MX6.1 Our problem is related to something that should never been done with CF in the first place but it was done and makes it hard to argue against it after so much time. Both of them have to deal with pulling down large chunks of data then parsing over that and doing inserts. After a lot of trial and error though we have managed to at least make it work in MX On 11/4/05, Snake [EMAIL PROTECTED] wrote: Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223224 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: [SPAM : 8.1] Re: Rumors from Max..
Tony, A lot of people still use CF5, and almost all our customers CF5 or CFMX or whatever use Access. This is of course their choice and has nothing to do with me or anyone else being under a rock. Russ -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 17:15 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. lets see. access cf5 what stone is it that you reside under? sql server and cfmx7 = the way the light and the truth! tw On 11/4/05, Snake [EMAIL PROTECTED] wrote: Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:58 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223225 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: [SPAM : 8.1] Re: Rumors from Max..
If you know how to concince all the Access users to do that, I am open to suggestions, because they don't listen to me. Russ -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 17:12 To: CF-Talk Subject: RE: [SPAM : 8.1] Re: Rumors from Max.. I think that likely has more to do with the database drivers than CF itself. If a site is getting so much traffic that its access DB is causing problems, it may be time to move up to MSDE or SQL Server. -Justin -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 12:13 PM To: CF-Talk Subject: RE: [SPAM : 8.1] Re: Rumors from Max.. Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:58 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223226 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: [SPAM : 8.1] Re: Rumors from Max..
NEED Like my wife NEEDS new shoes. To date I have done just fine with SQL Server and haven't found a NEED to spend £50k on Oracle. Russ -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 17:23 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. You need to run Oracle. We have problems with some sites we migrated from CF5 to MX6.1 Our problem is related to something that should never been done with CF in the first place but it was done and makes it hard to argue against it after so much time. Both of them have to deal with pulling down large chunks of data then parsing over that and doing inserts. After a lot of trial and error though we have managed to at least make it work in MX On 11/4/05, Snake [EMAIL PROTECTED] wrote: Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223227 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 MX 7.0.1 Cumulative Hot Fix 1 Available
On 11/4/05, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: FYI, we just released ColdFusion MX 7.0.1 Cumulative Hot Fix 1 (CHF1). This CHF is recommended for customers running ColdFusion MX 7.0.1 if they are experiencing one or more of the specific fixed issues listed, and then only to ColdFusion MX 7.0.1. Get it here: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=aae43964 I just installed this on my Linux box (and restarted the instance), and while the class path reflects the updated jar file, the Update Level line on the System Information page only notes my CF Adapter jar file. Also, my version number is still at 7,0,1,116466. Does the presence of the jar in my class path mean that everything's OK? Seems like a bug (albeit cosmetic) that could confuse admins as to their exact patch level. Regards, Dave. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223228 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: [SPAM : 8.1] Re: Rumors from Max..
On 11/4/05, Snake [EMAIL PROTECTED] wrote: Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Are you using the MS Access with Unicode Support drivers? Or are you using the MS Access drivers? If you are using the latter, you are making a bridge to ODBC from JDBC and back again. Very much more overhead and, as per MM best practice, ODBC bridges should not be used in a production environment on CF6+ due to the overhead it introduces. The 'unicode support' drivers, on the other hand, are native. Wouldn't surprise me to learn that they leave behind the memory leaks that Access ODBC gifted to the world. The difference between the two drivers may wind up being only that one works right under load and the other doesn't. However I have seen one instance where searches didn't return the same results and the customer had to fall back to ODBC and suffer. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223229 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: [SPAM : 8.1] Re: Rumors from Max..
Actuallyyour cash outlay for Oracle is zero. Oracle 10G Express just came out and its free. However it sounds like you're an ISP and I doubt you're going to find much use for it if your environment is shared-server mom-and-pop web sites running access. Try the native Access drivers if you haven;'t already gone there. That usually solves people's problems, and if you've already done that, you mentioned people using too many connections. In the bad old days of CF4+ the connection limit was recommended to be 7 to keep Access from frying. I'd go there next. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223230 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 7 Trial/Developer: Make if CF Std with S/N?
Beauty. Thanks guys! Now all I have to do is hope the server gets built before the tech staff takes the weekend off. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223231 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: [SPAM : 8.1] Re: Rumors from Max..
That can be used for hosting prod websites? I figured it could but been too lazy to read up on it. On 11/4/05, Matt Robertson [EMAIL PROTECTED] wrote: Actuallyyour cash outlay for Oracle is zero. Oracle 10G Express just came out and its free. However it sounds like you're an ISP and I doubt you're going to find much use for it if your environment is shared-server mom-and-pop web sites running access. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223232 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: [SPAM : 8.1] Re: Rumors from Max..
I think the solution to that is to allow at most one single connection to an Access Db. Mikey used to run this on Access, (I'm not sure if he switched or not) and he had a lot of success doing so. Using Access is fine, that's why there's a driver for it. - Matt Small -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 12:13 PM To: CF-Talk Subject: RE: [SPAM : 8.1] Re: Rumors from Max.. Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:58 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223233 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 webservice consumed via .NET
Looping over thousands of records to pass over a webservice is probably going to be slow anyway, isn't it? I ran into this exact same situation - I serialized about 14000 records returned from the DB into XML to pass to a .NET webservice. It took forever to process. I was never sure whether it was the fact that I was serializing it, or the fact that I was passing 14000 records across the network to a webservice to process. Perhaps you could send each row, one at a time? Might that be faster than serialization/deserialization? I was going to quote Joe Rinehart on doing this kind of stuff, but I think you'd be better of reading it yourself. http://webservices.sys-con.com/read/47199.htm - Matt Small; -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 11:50 AM To: CF-Talk Subject: Re: CF webservice consumed via .NET I *think* if you were to create a .NET object that mirrors the structure of the query object, .NET would probably be able to use the query type returned from CF. However, it would probably be easiest to serialize the output of the query into an XML string and just pass it via the webservice as a string, which could easily be read by .NET. - Matt Small Thanks Matt... I'm trying to avoid looping over the query to convert it to an XML stringwhen you return thousands of records it sure slows down the service ;-) I'll do it if I have to though. Anybody else have 2 cents to addI know you're out there and I know you've bumped into thiswhere's Barney B. and Dave W.?? ;-) How about structures returned from CF web servicesdoes .NET choke on those as well? TIA 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223234 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 webservice consumed via .NET
Looping over thousands of records to pass over a webservice is probably going to be slow anyway, isn't it? If you have to pass the result as an XML stringthen yes the above is true and why I'm asking for alternative solutions (like why the hell can't CF return something useful to languages other than CF) ;-) I ran into this exact same situation - I serialized about 14000 records returned from the DB into XML to pass to a .NET webservice. It took forever to process. I was never sure whether it was the fact that I was serializing it, or the fact that I was passing 14000 records across the network to a webservice to process. Perhaps you could send each row, one at a time? Might that be faster than serialization/deserialization? I'm curious what you mean by serialized? are you using a function to do this (if so it's looping anyways)? or looping and converting each row to XML? BTW..in my tests...the conversion of a query to an XML string was 100% the cause of major slow down (like 5 times slower than just returning the query) Thans Matt 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223235 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 webservice consumed via .NET
Serialization is just another term for conversion to XML. From Wikipedia: Serialization involves taking a data structure or object and encoding it into a regular and usually architecture-independent form... However, on this note, perhaps there's a faster way to serialize using the underlying java engine, using something like stringbuilder rather than looping in CF. Anyone out there know? Maybe this would be an incredibly useful custom tag? Even better, I know that a WDDX add-in for .NET exists, I've not used it though. Is there a chance that CFWDDX tag would be faster? - Matt Small -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:04 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Looping over thousands of records to pass over a webservice is probably going to be slow anyway, isn't it? If you have to pass the result as an XML stringthen yes the above is true and why I'm asking for alternative solutions (like why the hell can't CF return something useful to languages other than CF) ;-) I ran into this exact same situation - I serialized about 14000 records returned from the DB into XML to pass to a .NET webservice. It took forever to process. I was never sure whether it was the fact that I was serializing it, or the fact that I was passing 14000 records across the network to a webservice to process. Perhaps you could send each row, one at a time? Might that be faster than serialization/deserialization? I'm curious what you mean by serialized? are you using a function to do this (if so it's looping anyways)? or looping and converting each row to XML? BTW..in my tests...the conversion of a query to an XML string was 100% the cause of major slow down (like 5 times slower than just returning the query) Thans Matt 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223236 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: [SPAM : 8.1] Re: Rumors from Max..
No I have not used the unicode drivers, so would not suffer form the problems you specify. I have setup using that driver a couple of times, and things just didn't work properly. Russ -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 17:35 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. On 11/4/05, Snake [EMAIL PROTECTED] wrote: Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Are you using the MS Access with Unicode Support drivers? Or are you using the MS Access drivers? If you are using the latter, you are making a bridge to ODBC from JDBC and back again. Very much more overhead and, as per MM best practice, ODBC bridges should not be used in a production environment on CF6+ due to the overhead it introduces. The 'unicode support' drivers, on the other hand, are native. Wouldn't surprise me to learn that they leave behind the memory leaks that Access ODBC gifted to the world. The difference between the two drivers may wind up being only that one works right under load and the other doesn't. However I have seen one instance where searches didn't return the same results and the customer had to fall back to ODBC and suffer. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223237 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: [SPAM : 8.1] Re: Rumors from Max..
I have actually tried that, doesn't appear to help. -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 17:51 To: CF-Talk Subject: RE: [SPAM : 8.1] Re: Rumors from Max.. I think the solution to that is to allow at most one single connection to an Access Db. Mikey used to run this on Access, (I'm not sure if he switched or not) and he had a lot of success doing so. Using Access is fine, that's why there's a driver for it. - Matt Small -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 12:13 PM To: CF-Talk Subject: RE: [SPAM : 8.1] Re: Rumors from Max.. Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:58 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223238 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 webservice consumed via .NET
Thanks Mattjust makin sure we were talkin the same language...we are ;-) and yep...if there's a fatser way to serialize (convert to XML)...BRING IT!! ;-) 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223239 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: SP UDF parameter meta data
Hello All,
I was wondering if anyone knows how I can access parameters expected by a
UDF in MSSQL? I know that I can use the following to retrieve the expected
parameters for a SP, but how can I do the same for a UDF?
select name
FROM syscolumns
WHERE id = OBJECT_ID('sp_myProcedure')
Anyone have any ideas?
Rich Kroll
Application Developer
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223240
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 Is or NOT?
Ok, let me ask this a different way: If, I do this: cfif IsXMLElem(XMLResponse.RateV2Response.Package.Error) Some code cfelse More code /cfif AND there is no ERROR node/element, then CF produces this error: --- Element RATEV2RESPONSE.PACKAGE.ERROR is undefined in XMLRESPONSE --- Basically I am wanting to see if package.ERROR is there ... if it is not, then process normally.. The IsXMLElem fuction doesn't catch this. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, November 04, 2005 8:09 AM Subject: XML Is or NOT? This may be a basic question, but I am recieving some XML and it could be a valid response or it could be an error response... BOTH are valid XML, but they are formatted differently. I need to check to see if it is the error or not ... If I check for the error XML, and it is not, it errors out saying it isn't valid XML... how do you check to see if it is a particular XML document and not error if it is not? Make sense? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223241 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: [SPAM : 8.1] Re: Rumors from Max..
You can use the free version of Oracle XE. XE = eXtreme Edition! (well not really, but it sounds cooler) -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: NEED Like my wife NEEDS new shoes. To date I have done just fine with SQL Server and haven't found a NEED to spend £50k on Oracle. Russ -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 17:23 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. You need to run Oracle. We have problems with some sites we migrated from CF5 to MX6.1 Our problem is related to something that should never been done with CF in the first place but it was done and makes it hard to argue against it after so much time. Both of them have to deal with pulling down large chunks of data then parsing over that and doing inserts. After a lot of trial and error though we have managed to at least make it work in MX On 11/4/05, Snake [EMAIL PROTECTED] wrote: Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223242 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 webservice consumed via .NET
-Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:15 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Thanks Mattjust makin sure we were talkin the same language...we are ;-) and yep...if there's a fatser way to serialize (convert to XML)...BRING IT!! ;-) Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223243 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 Is or NOT?
-Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:22 PM To: CF-Talk Subject: Re: XML Is or NOT? Ok, let me ask this a different way: If, I do this: cfif IsXMLElem(XMLResponse.RateV2Response.Package.Error) Some code cfelse More code /cfif AND there is no ERROR node/element, then CF produces this error: --- Element RATEV2RESPONSE.PACKAGE.ERROR is undefined in XMLRESPONSE --- Basically I am wanting to see if package.ERROR is there ... if it is not, then process normally.. The IsXMLElem fuction doesn't catch this. I think there's a note about this in the docs... try using IsDefined() first, then IsXMLElem (which assumes you're giving it something to check - not something or nothing). Essentially a CF XML doc is just a struct - you can use struct functions and the like as well. Jim Davis ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223244 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 webservice consumed via .NET
Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis DOH!there's a damn fine idea Jim ;-) It's Oracle 9i...any idea if it will return XML...and example would be great? Thanks 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223245 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
CFCHART Percentage Values
Anybody know how to get CFCHART to display percentage values without ROUNDING up? From what I can tell, the current behavior ALWAYS rounds up. So, a value of 19.1% gets displayed as 20%. cfchart show3d=yes chartheight=350 chartwidth=400 font=Times labelformat=percent scalefrom=0 scaleto=1 title=Summary of Portfolio at September 30, 2005: cfchartseries type=pie cfchartdata item=Bonds 35.9% value=.359 cfchartdata item=Canadian Equities 40.9% value=.407 cfchartdata item=US Equities 19.2% value=.195 cfchartdata item=Cash Equivalents 3.9% value=.039 /cfchartseries /cfchart ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223246 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: Verity is being acquired
http://news.com.com/Autonomy+to+buy+competitor+Verity/2100-1011_3-593289 5.html Verity is being acquired by Autonomy for $500 million. From the article, Analysts have commented that Cambridge-based Autonomy is paying a premium for California-based Verity--a 30 percent rise over Thursday's closing share price--but it could be worth it for the revenue boost. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223247 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 MX 7.0.1 Cumulative Hot Fix 1 Available
On 11/4/05, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: FYI, we just released ColdFusion MX 7.0.1 Cumulative Hot Fix 1 (CHF1). This CHF is recommended for customers running ColdFusion MX 7.0.1 if they are experiencing one or more of the specific fixed issues listed, and then only to ColdFusion MX 7.0.1. Get it here: http://www.macromedia.com/cfusion/knowledgebase/index. cfm?id=aae43964 I just installed this on my Linux box (and restarted the instance), and while the class path reflects the updated jar file, the Update Level line on the System Information page only notes my CF Adapter jar file. Also, my version number is still at 7,0,1,116466. Does the presence of the jar in my class path mean that everything's OK? Seems like a bug (albeit cosmetic) that could confuse admins as to their exact patch level. Regards, Dave. Yes, sorry about that. We chose the one-off hotfix method to deliver the Flex 2 Adapter Alpha, and could probably have done something more sophisticated with more time. For now, yes, everything should be good to go as you are. The general plan is to have the Flex 2 Adapter made part of the product going forward, so it'll be a baked-in part of the bits in the future. Damon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223248 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: CFCHART Percentage Values
CORRECTION: OOPS! The tag rounds UP or DOWN. Anyhow, I still need to know how to defeat the rounding and have 19.3% displayed as 19.3% . cfchart show3d=yes chartheight=350 chartwidth=400 font=Times labelformat=percent scalefrom=0 scaleto=1 title=Summary of Portfolio at September 30, 2005: cfchartseries type=pie cfchartdata item=Bonds 35.9% value=.359 cfchartdata item=Canadian Equities 40.9% value=.409 cfchartdata item=US Equities 19.3% value=.193 cfchartdata item=Cash Equivalents 3.9% value=.039 /cfchartseries /cfchart ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223249 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: First ever SP, on Oracle even.
http://www.talkingtree.com/blog/index.cfm?mode=entryentry=B37A824E-50DA-0559-A08F2CDFB58A8248 Using this example, I was able to create the included SP. Yeah for me, I then moved on to try and create a SP that returns a result set rather then a simple value. Using the example found on this page: http://www.orafusion.com/oracf_pls.htm. I was able to get a sp created. When I tried to access it in my ColdFusion page: cfstoredproc procedure=sosusr.rc.rset datasource=SMFVL returncode=no cfprocparam type=out cfsqltype=cf_sql_refcursor variable=v cfprocresult name=table1Data /cfstoredproc I got this error: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]The specified SQL type is not supported by this driver. For my first attempt, I was using the Oracle driver included in my developer [set up in an Enterprise configuration] edition of CFMX6.1. While I am about to head off and trial-and-error experiment with other drives I have avalible to me (CFMX 7.0.1 Oracle, Oracle Thin Client, Oracle ODBC, Microsoft Oracle ODBC), can anybody give me a hint on what driver might work best for this? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223250 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: [SPAM : 8.1] Re: Rumors from Max..
On 11/4/05, Snake [EMAIL PROTECTED] wrote: No I have not used the unicode drivers, so would not suffer form the problems you specify. I have setup using that driver a couple of times, and things just didn't work properly. Actually the problems I referenced are all native to the drivers YOU are using. The Unicode ones are the ones that work right. If you aren't throttling your connections to Access I would say that is definitely bad. Couple that to a throttling of CF itself would probably make it more survivable but a lesser performer (i.e. reduce the number of concurrent threads). Then also reduce the amount of time before CF considers something 'timed out'. I think the default is 90 seconds, which means you would be allowing a 90,000 ms process to execute. But in a shared environment with basically no quality control on the programmers uploading their select*fromgigatable order by unindexed_field , where you allow stuff like old Access db's whose data doesn't support Unicode You're pretty well screwed. But thats not CF's fault. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223251 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 webservice consumed via .NET
-Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:48 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis DOH!there's a damn fine idea Jim ;-) It's Oracle 9i...any idea if it will return XML...and example would be great? Sorry - I've not actually DONE this (and I don't have any experience with Oracle)... it was just a thought. I know that I could do it SQL Server using string concatenation (just building the XML manually) - I assume the same is true for Oracle. In SQL Server you can also use COM objects or (in 2005) built SPs using JavaScript, perhaps you can do the same (or similar) in Oracle? Now that I'm thinking about it maybe I should work on a YODEL serializer for SQL Server 2005... Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223252 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 webservice consumed via .NET
I know next to nothing about Oracle, but here's an interesting thing I found via Google: http://www.oracle.com/technology/oramag/oracle/03-may/o33xml.html - Matt Small -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 2:28 PM To: CF-Talk Subject: RE: CF webservice consumed via .NET -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:48 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis DOH!there's a damn fine idea Jim ;-) It's Oracle 9i...any idea if it will return XML...and example would be great? Sorry - I've not actually DONE this (and I don't have any experience with Oracle)... it was just a thought. I know that I could do it SQL Server using string concatenation (just building the XML manually) - I assume the same is true for Oracle. In SQL Server you can also use COM objects or (in 2005) built SPs using JavaScript, perhaps you can do the same (or similar) in Oracle? Now that I'm thinking about it maybe I should work on a YODEL serializer for SQL Server 2005... Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223253 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 MX 7.0.1 Cumulative Hot Fix 1 Available
On 11/4/05, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: On 11/4/05, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: FYI, we just released ColdFusion MX 7.0.1 Cumulative Hot Fix 1 (CHF1). This CHF is recommended for customers running ColdFusion MX 7.0.1 if they are experiencing one or more of the specific fixed issues listed, and then only to ColdFusion MX 7.0.1. Get it here: http://www.macromedia.com/cfusion/knowledgebase/index. cfm?id=aae43964 I just installed this on my Linux box (and restarted the instance), and while the class path reflects the updated jar file, the Update Level line on the System Information page only notes my CF Adapter jar file. Also, my version number is still at 7,0,1,116466. Does the presence of the jar in my class path mean that everything's OK? Seems like a bug (albeit cosmetic) that could confuse admins as to their exact patch level. Regards, Dave. Yes, sorry about that. We chose the one-off hotfix method to deliver the Flex 2 Adapter Alpha, and could probably have done something more sophisticated with more time. For now, yes, everything should be good to go as you are. The general plan is to have the Flex 2 Adapter made part of the product going forward, so it'll be a baked-in part of the bits in the future. Makes sense, thanks. For those who might not have seen his thread, Mike Nimer noted that you currently *cannot* have the Flex 2 Adapter installed with this hotfix, as they have just uncovered an issue with it. Regards, Dave. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223254 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: First ever SP, on Oracle even.
Drop the cfprocparam all together. You only need the cfprocresult. Be careful, alot of the OraFusion stuff is out of date and innacurate. -Adam On 11/4/05, Ian Skinner [EMAIL PROTECTED] wrote: http://www.talkingtree.com/blog/index.cfm?mode=entryentry=B37A824E-50DA-0559-A08F2CDFB58A8248 Using this example, I was able to create the included SP. Yeah for me, I then moved on to try and create a SP that returns a result set rather then a simple value. Using the example found on this page: http://www.orafusion.com/oracf_pls.htm. I was able to get a sp created. When I tried to access it in my ColdFusion page: cfstoredproc procedure=sosusr.rc.rset datasource=SMFVL returncode=no cfprocparam type=out cfsqltype=cf_sql_refcursor variable=v cfprocresult name=table1Data /cfstoredproc I got this error: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]The specified SQL type is not supported by this driver. For my first attempt, I was using the Oracle driver included in my developer [set up in an Enterprise configuration] edition of CFMX6.1. While I am about to head off and trial-and-error experiment with other drives I have avalible to me (CFMX 7.0.1 Oracle, Oracle Thin Client, Oracle ODBC, Microsoft Oracle ODBC), can anybody give me a hint on what driver might work best for this? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223255 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 webservice consumed via .NET
Jim I think transforming the columns returned using string functions might not quite do it (as you're missing nodes and headers etc.)...so not a complete and valid XML string. That said, I know that some DBs will return XML (and consume it) instead of a standard recordset (but I don't know if Oracle can or how to do it if it does). Anybody? 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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223256 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 Is or NOT?
I tried: cfif IsDefined(#XMLResponse.RateV2Response.Package.Error#) And recieved this error: Element RATEV2RESPONSE.PACKAGE.ERROR is undefined in XMLRESPONSE. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Jim Davis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, November 04, 2005 12:39 PM Subject: RE: XML Is or NOT? -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:22 PM To: CF-Talk Subject: Re: XML Is or NOT? Ok, let me ask this a different way: If, I do this: cfif IsXMLElem(XMLResponse.RateV2Response.Package.Error) Some code cfelse More code /cfif AND there is no ERROR node/element, then CF produces this error: --- Element RATEV2RESPONSE.PACKAGE.ERROR is undefined in XMLRESPONSE --- Basically I am wanting to see if package.ERROR is there ... if it is not, then process normally.. The IsXMLElem fuction doesn't catch this. I think there's a note about this in the docs... try using IsDefined() first, then IsXMLElem (which assumes you're giving it something to check - not something or nothing). Essentially a CF XML doc is just a struct - you can use struct functions and the like as well. Jim Davis ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223257 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: formatting a date in cfgrid
i did the update this morning.. i still get the same results.. http://single-dads.us/grid.jpg the petid field shows the format of the date as it comes from the db... via remoting.. On 10/28/05, Mike Nimer [EMAIL PROTECTED] wrote: Upgrade to 7.0.1, we fixed some bugs in cfgrid in the updater. I think this was fixed as well. ---nimer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223259 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
