MSDE / CFTransaction

2005-11-04 Thread Peter Shaw
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

Re: Cfchart hanging

2005-11-04 Thread James Holmes
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

RE: MSDE / CFTransaction

2005-11-04 Thread Snake
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

Re: Passing null dates via WDDX

2005-11-04 Thread James Holmes
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

RE: Cfchart hanging

2005-11-04 Thread Snake
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:

RE: what do you use instead of cfx_openimage?

2005-11-04 Thread Robertson-Ravo, Neil (RX)
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

Re: what do you use instead of cfx_openimage?

2005-11-04 Thread Joe Rinehart
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

OT: New Updates

2005-11-04 Thread newsight
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

Re: what do you use instead of cfx_openimage?

2005-11-04 Thread Pete Ruckelshaus
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

RE: what do you use instead of cfx_openimage?

2005-11-04 Thread Tim Laureska
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

Re: what do you use instead of cfx_openimage?

2005-11-04 Thread John Beynon
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]

RE: what do you use instead of cfx_openimage?

2005-11-04 Thread Tim Laureska
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

Re: what do you use instead of cfx_openimage?

2005-11-04 Thread Sebastian Mork
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

Re: MSDE / CFTransaction

2005-11-04 Thread Deanna Schneider
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:

Re: what do you use instead of cfx_openimage?

2005-11-04 Thread Sebastian Mork
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

SOLVED: Need query help please

2005-11-04 Thread Will Tomlinson
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

RE: what do you use instead of cfx_openimage?

2005-11-04 Thread Andy Matthews
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

Re: MSDE / CFTransaction

2005-11-04 Thread Adrocknaphobia
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

XML Is or NOT?

2005-11-04 Thread Paul Giesenhagen
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

RE: CF webservice consumed via .NET

2005-11-04 Thread Matthew Small
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

Re: XML Is or NOT?

2005-11-04 Thread Adrocknaphobia
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

Re: XML Is or NOT?

2005-11-04 Thread Paul Giesenhagen
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

RE: MSDE / CFTransaction

2005-11-04 Thread Snake
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

Re: [SPAM : 8.1] Re: Rumors from Max...

2005-11-04 Thread Jeff Small
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

flash forms flipping a panel

2005-11-04 Thread Alexander Hinkley
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

RE: flash forms flipping a panel

2005-11-04 Thread Snake
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?

Re: XOR

2005-11-04 Thread Ben Doom
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

RE: what do you use instead of cfx_openimage?

2005-11-04 Thread Andy Matthews
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 --//-

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Adrocknaphobia
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Adrocknaphobia
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

Re: flash forms flipping a panel

2005-11-04 Thread Alexander Hinkley
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

RE: SQL join a table to a set of values not in a table.

2005-11-04 Thread Ian Skinner
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);

Re: SQL join a table to a set of values not in a table.

2005-11-04 Thread Greg Morphis
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Matt Robertson
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

RE: SQL join a table to a set of values not in a table.

2005-11-04 Thread Ian Skinner
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.

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Snake
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

Re: what do you use instead of cfx_openimage?

2005-11-04 Thread cftalk
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Jeff Small
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...

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Adrocknaphobia
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-

No ColdFusion Search Service

2005-11-04 Thread jonese
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

RE: XOR

2005-11-04 Thread Dave Francis
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread George Abraham
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

FW: Strange DB behaviour

2005-11-04 Thread Snake
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,

Re: SQL join a table to a set of values not in a table.

2005-11-04 Thread Adrocknaphobia
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

RE: No ColdFusion Search Service

2005-11-04 Thread Ian Skinner
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Matt Robertson
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

ColdFusion MX 7.0.1 Cumulative Hot Fix 1 Available

2005-11-04 Thread dcooper
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:

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Tony
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

CF 7 Trial/Developer: Make if CF Std with S/N?

2005-11-04 Thread Matt Robertson
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

Javascript Automatic Time Validation Correction

2005-11-04 Thread Ryan Mannion
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

CFMX 6.0 and VSpider

2005-11-04 Thread Vance M. Duke
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

RE: what do you use instead of cfx_openimage?

2005-11-04 Thread gabriel l smallman
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

RE: XML Is or NOT?

2005-11-04 Thread Jim Davis
-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

what's wrong with list processing?

2005-11-04 Thread Richard Colman
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

Re: XML Is or NOT?

2005-11-04 Thread Paul Giesenhagen
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

Re: CF 7 Trial/Developer: Make if CF Std with S/N?

2005-11-04 Thread John Beynon
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.

RE: Caching, caching what is doing all this caching?!

2005-11-04 Thread Ian Skinner
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:

Re: CF webservice consumed via .NET

2005-11-04 Thread Bryan Stevenson
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

Re: CF 7 Trial/Developer: Make if CF Std with S/N?

2005-11-04 Thread dcooper
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

Special Characters (Unicode?)

2005-11-04 Thread Mike Rogan
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

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Terry Troxel
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

RE: what's wrong with list processing?

2005-11-04 Thread Richard Colman
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

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Snake
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Tony
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

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Justin D. Scott
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,

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Aaron Rouse
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

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Snake
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

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Snake
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

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Snake
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

Re: ColdFusion MX 7.0.1 Cumulative Hot Fix 1 Available

2005-11-04 Thread Dave Carabetta
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Matt Robertson
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Matt Robertson
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

Re: CF 7 Trial/Developer: Make if CF Std with S/N?

2005-11-04 Thread Matt Robertson
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Aaron Rouse
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

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Matthew Small
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

RE: CF webservice consumed via .NET

2005-11-04 Thread Matthew Small
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

Re: CF webservice consumed via .NET

2005-11-04 Thread Bryan Stevenson
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

RE: CF webservice consumed via .NET

2005-11-04 Thread Matthew Small
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

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Snake
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:

RE: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Snake
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

Re: CF webservice consumed via .NET

2005-11-04 Thread Bryan Stevenson
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

OT: SP UDF parameter meta data

2005-11-04 Thread Rich Kroll
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

Re: XML Is or NOT?

2005-11-04 Thread Paul Giesenhagen
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Adrocknaphobia
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.

RE: CF webservice consumed via .NET

2005-11-04 Thread Jim Davis
-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

RE: XML Is or NOT?

2005-11-04 Thread Jim Davis
-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

Re: CF webservice consumed via .NET

2005-11-04 Thread Bryan Stevenson
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

CFCHART Percentage Values

2005-11-04 Thread Jay Greer
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

OT: Verity is being acquired

2005-11-04 Thread Munson, Jacob
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

Re: ColdFusion MX 7.0.1 Cumulative Hot Fix 1 Available

2005-11-04 Thread dcooper
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

Re: CFCHART Percentage Values

2005-11-04 Thread Jay Greer
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:

RE: First ever SP, on Oracle even.

2005-11-04 Thread Ian Skinner
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

Re: [SPAM : 8.1] Re: Rumors from Max..

2005-11-04 Thread Matt Robertson
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

RE: CF webservice consumed via .NET

2005-11-04 Thread Jim Davis
-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

RE: CF webservice consumed via .NET

2005-11-04 Thread Matthew Small
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

Re: ColdFusion MX 7.0.1 Cumulative Hot Fix 1 Available

2005-11-04 Thread Dave Carabetta
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

Re: First ever SP, on Oracle even.

2005-11-04 Thread Adrocknaphobia
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

Re: CF webservice consumed via .NET

2005-11-04 Thread Bryan Stevenson
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

Re: XML Is or NOT?

2005-11-04 Thread Paul Giesenhagen
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]

Re: formatting a date in cfgrid

2005-11-04 Thread Alexander Hinkley
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

  1   2   >