Re: Bug?

after the =? If so, it may be interpreting that as part of the value and choking on it. -- Phillip Beazley ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk

Re: Know a Good SQL Forum ?

[EMAIL PROTECTED] wrote: Does anyone know a good SQL, SQL Server 2000 forum? http://www.sswug.org/ -- Phillip Beazley -- I want to move to Theory - everything works there. ~| Introducing the Fusion Authority Quarterly

Re: announce: cfportal

At Monday, 8/14/2006 07:59 PM, you wrote: Just an FYI, www.coldfusionportal.org should work now. Can someone double check and see if it works for them? Yep, looks good. -- Phillip Beazley ~| Introducing the Fusion

Re: Did my own CF/SQL Server performance testing, my world is turned upside down.

is about the same that it would be when using a stored procedure. Try using the stored procedure not using cfstoredproc - maybe it's the culprit. -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600

Re: Anyone know of a description of each of the CFQUERYPARAM CFSQLTypes?

At 06:32 PM 1/15/2006, you wrote: Anyone know of a description of each of the CFQUERYPARAM CFSQLTypes? Something like this? -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600

Re: Anyone know of a description of each of the CFQUERYPARAM CFSQLTypes?

At 06:36 PM 1/15/2006, you wrote: Something like this? But actually visible. :) Try this: ftp://ftp.adminware.com/cfsql_datatypes_quickref.pdf -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600

RE: Stored Proc

it in the master database. That said, though, claiming it's detrimental to performance is wildly false. -Original Message- From: Phillip Beazley [mailto:[EMAIL PROTECTED] Sent: 03 December 2005 16:15 To: CF-Talk Subject: Re: Stored Proc Here's a small stored procedure that does the difference from two

RE: Stored Proc

checks the master database first, even if the stored procedure is qualified with the database name. From BOL. Exactly. As I said, I forgot about mentioning that this was to be created in the master database, otherwise you'd *not* want to use the prefix. -- Phillip Beazley Onvix -- Website

Re: Stored Proc

@mult = 1.0 ; select sqrt(power((69.1*(@[EMAIL PROTECTED])),2)+power((69.1*(@[EMAIL PROTECTED])*cos(@lat1/57.3)),2))[EMAIL PROTECTED] as distance go And example usage: exec dbo.sp_latLongDist 34.09011, -118.4065, 42.34892, -71.04651, 'nm' ; -- Phillip Beazley Onvix -- Website Hosting

Re: iMS or alternatives?

using it. -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start

Re: OT: MXNA down?

At 03:32 PM 10/20/2005, you wrote: Is MXNA down for anyone else? Works fine here... -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. ~| Logware

Re: OT: MXNA down?

a few hours. Weird, I'm not having any trouble. Seriously. :) -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. ~| Logware (www.logware.us): a new

Re: OT: MXNA down?

At 03:48 PM 10/20/2005, you wrote: You sure you are hitting http://weblogs.macromedia.com/mxna ? Erm, okay, now I'm not getting anything. Sorry. On 10/20/05, Phillip Beazley [EMAIL PROTECTED] wrote: At 03:40 PM 10/20/2005, you wrote: Ryan Guill wrote: Is MXNA down for anyone else

RE: WDDX Replacement Attempt (was RE: Ajax and CFCs)

. Whatcha think? I know this is weighing heavily on all your minds! ;^) How about DEML [dimmel] for data expression or exchange ML? -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600

RE: WDDX Replacement Attempt - Name?

At 04:21 PM 8/18/2005, you wrote: My personal favorite... XXL - XML Xchange Language Or for really big packets, XXXL - XML Xfer and Xchange Language. -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600

RE: WDDX Replacement Attempt - Name?

At 05:00 PM 8/18/2005, you wrote: Courier ... or possibly X-Courier... DataWinch DataSieve Windlass Puny X-Press PieHole :) LOL! DataBitch PacketWagon XMule XHNA (XHNA Has No Acronym) -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com

RE: Studio 8 announced

At 06:32 PM 8/13/2005, you wrote: I'm going to go buy one of the 'ugly' shirts for no other purpose than to piss you off when you see me wearing it. I got a bit distracted, but I want one, too. Uglier the better, please. -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce

Re: Embed styles in CFMAIL

Transitional//EN #theMessage# /cfmail When I view the source code of an email, it looks okay, but the styles do not render properly. Stan, Does theMessage contain a style block or are you referencing a stylesheet remotely? -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit

Re: CFXRegServer released

-- unfriendly cpu-hogs. Urg. I guess I'll just try downloading different versions and see if any of them work. But I do plan on it otherwise :) Hehe, cool. :) -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600

Re: CFXRegServer released

At 03:22 PM 11/21/2004, you wrote: I'm interested in any feedback on the software. Bugs. Thoughts on improvements, etc. How about BlueDragon support? ;) -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600

Re: timestamp in mssql

it in the insert statement or specify it explicitly like: INSERT INTO tblFeeds (dteFeedDate, strFilename) VALUES (getdate(), 'stuff') ; -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600

Re: timestamp in mssql

At 12:04 AM 11/22/2004, you wrote: Thanks for that -works a treat ! De nada! -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. ~| Special thanks to the CF

TeraTech Listening?

Howdy, all! Anyone know of a way to get ahold of someone at TeraTech at the conference today? -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

Re: OT- sql format question

Untested but looks good: SQRT(POWER((69.1*(zipCodes.latitude-39.166759)),2)+POWER((69.1*(zipCodes.longitude-84.53822)*COS(39.166759/57.3)),2) AS DistanceInMiles -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads

RE: OT- sql format question

)+POWER((69.1*(zipCodes.longitude-84.53822)*COS(39.166759/57.3)),2) 50 ; -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations

Re: OT: Blown Away Query

likely).Use [option] and see if that helps. (P.S. Don't use reserved words as a table or column name!):) -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe

Re: SQL help!

table1 WHERE id NOT IN (SELECT id FROM table2) SELECT * FROM table2 WHERE id NOT IN (SELECT id FROM table1) Not super-fab, but it'll show you what's in one that isn't in the other... -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578

Re: Coldfusion Web Image Editor

this too.I've been meaning to ask for days.I just need crop, though, or more specifically something that will allow like a blue box to be moved and resized over the image (i.e. this doesn't have to be real-time, I just need to crop coordinates). -- Phillip Beazley Onvix -- Website Hosting

Re: Coldfusion Web Image Editor

dhtml or Flash.:) -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: (Admin) Support drive

At 01:20 PM 6/15/2004, you wrote: We thank you for your support and hope to give you even more features in the future. $25 sent...:) -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message

Re: Compare 2 SQL Databases for structural changes?

/summary.htm -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Flex is out

At 02:09 PM 3/29/2004, you wrote: Why does it cost so much? Crack abuse? -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Access Coldfusion MX6.1 problems...sites keep dying

there? -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Access Coldfusion MX6.1 problems...sites keep dying

At 04:43 PM 2/27/2004, you wrote: You might want to ask that on a mailinglist for that application language. It can only use ODBC, period.I was wondering if there was an ODBC-to-JDBC bridge thingy, to bypass this problem. -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce

Re: Access Coldfusion MX6.1 problems...sites keep dying

At 06:54 PM 2/27/2004, you wrote: You might find a solution at OpenLink -- I was able to interface CFMX OS X to An Access Database running under VirtualPC Will take a look.Thanks! -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578

RE: New artwork available!

gospel. /sarcasm_mode Hehehe, yeah! Count me in, too. :) -- Phillip Beazley FutureSights -- Website Hosting, Development E-commerce Visit http://www.futuresights.com/ or call 727-578-9600. __ Signup for the Fusion Authority