Re: Bug?
Doug Brown wrote: > Do not know if this is a bug or something normal, but if I have my query like > so...I get the following error. Notice where the is. I hunted > for hours trying to figure out where this was coming from. Can someone > confirm this? Is the difference the line break 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;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Did my own CF/SQL Server performance testing, my world is turned upside down.
On 5/20/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > Has anyone else found this to be the case? I'm really thinking about > ripping out all of my SP's and just using queries, it would make my > life easier on a number of levels. I have all of my queries as > methods in a CFC, so code reuse 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241056 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: 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229638 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: 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229637 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: Stored Proc
At 08:11 AM 12/5/2005, Robertson-Ravo, Neil (RX) wrote: > >> That said, though, claiming it's detrimental to performance is wildly >false. > >Erm, no it is true... check BOL. > >Naming it with "sp_" can reduce reduce performance. When you call a stored >procedure that starts with sp_, SQL Server always 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 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 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:226083 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: Stored Proc
At 03:51 AM 12/5/2005, you wrote: >NOTE: You should avoid using "sp_" as the prefix for user stored procedures >- it can be detrimental to performance. The purpose of that, in this case, is use in any database without having to specifically create the procedure in each when created in the master database. I'd forgotten about mentioning that. You'd also need to grant permissions to it, a la: grant execute on master..sp_latLongDist to public ; If you're not the administrator of the database server, though, yeah - you should probably not prefix it and probably can't create 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 >sets of latitude/longitude. > >create procedure dbo.sp_latLongDist @lat1 numeric, @long1 numeric, >@lat2 numeric, @long2 numeric, @units char(2) as >set nocount on ; >declare @mult numeric ; >if @units = 'km' set @mult = 1.852 else set @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, 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 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:226062 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: Stored Proc
Here's a small stored procedure that does the difference from two sets of latitude/longitude. create procedure dbo.sp_latLongDist @lat1 numeric, @long1 numeric, @lat2 numeric, @long2 numeric, @units char(2) as set nocount on ; declare @mult numeric ; if @units = 'km' set @mult = 1.852 else set @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, Development & E-commerce Visit http://www.onvix.com/ or call 727-578-9600. ~| 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:226018 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: iMS or alternatives?
At 08:00 PM 11/28/2005, you wrote: >I'm ready to give up on IIS SMTP for sending large volumes of mail from CF, >and am now looking at the inFusion Mail Server >(http://www.coolfusion.com/products/ims/index.cfm). Any opinions on this >or other solutions? iMS is simply fabulous, you can't go wrong 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 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:225493 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: 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? > > > > > >Yes, server crash, just as Mike & Christian boarded the afternoon plane > > >from Anaheim to SF. When they deboard we're trying some remote fixups. > > >With luck we'll be back in an hour, but without luck it may take 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 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:221737 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: OT: MXNA down?
At 03:40 PM 10/20/2005, you wrote: >Ryan Guill wrote: > > Is MXNA down for anyone else? > >Yes, server crash, just as Mike & Christian boarded the afternoon plane >from Anaheim to SF. When they deboard we're trying some remote fixups. >With luck we'll be back in an hour, but without luck it may take 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 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:221733 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: 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 (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:221730 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: 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/ or call 727-578-9600. ~| 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:215699 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: 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. ~| 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:215685 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: WDDX Replacement Attempt (was RE: Ajax and CFCs)
At 02:33 AM 8/18/2005, you wrote: >Well - it looks like "dataML" is already taken for something else anyway... >anybody got a good idea for a new name? > >I'm thinking either simple as in "dpml" (Depressed Press Markup Language) >which says absolutely NOTHING about what it does or esoteric like "Rosetta". > >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. ~| 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:215569 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: 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 Visit http://www.onvix.com/ or call 727-578-9600. ~| 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:214932 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: Embed styles in CFMAIL
At 01:18 AM 3/19/2005, you wrote: >How do you embed a style sheet in CFMAIL? > >I've tried the following: > > from="#request.email#" > subject="#emailSubject#" > server="#request.mailServer#" > type="HTML"> > >#theMessage# > > >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 http://www.onvix.com/ or call 727-578-9600. ~| 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:199450 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: CFXRegServer released
At 08:10 AM 11/22/2004, you wrote: >Well, that thought did already occur me me after the fact. :) >Just can't convince the stupid thing to install -- it's caiught in an >endless loop of "please select another location to extract installer >to". I always did hate installanywhere installers though -- 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. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185003 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: 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 Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184976 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: timestamp in mssql
At 11:43 PM 11/21/2004, you wrote: >hi - i can't seem to find a definitive naswer on this one. I have a MSSQL >( MSDE ) tbale with a field set to type timestamp. > >How on earth do I get coldfusion to insert a current datetimestamp into >this field ? > >I have tried: > > >INSERT INTO tblFeeds (dteFeedDate,strFilename) VALUES ( >#CreateODBCDateTime(Now())#, 'stuff') > > >Should I be using a timestamp field or a date time field DateTime is probably more appropriate. You can either set the default for the field to be getdate() and not include 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. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184973 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: 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. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184971 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
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 Settings] [Donations and Support]
Re: OT: Blown Away Query
At 09:09 PM 8/13/2004, you wrote: >Ok, this blows me away .. here is the query: > >INSERT INTO boatOptions (boatID,option) VALUES(13,'x') > >Simple enough? Well I am getting Syntax Errors with it.. > >BoatID = Int >option = VarChar (75) > >Am I missing something here ...? Option is a reserved word (most 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] [User Settings] [Donations and Support]
RE: OT- sql format question
At 03:02 PM 8/13/2004, Eric Creese wrote: >OOOPs it looks like I forgot to paste the rest: > > >WHERE >(((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))<50)); Okay... WHERE SQRT(POWER((69.1*(zipCodes.latitude-39.166759)),2)+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 and Support]
Re: OT- sql format question
At 02:38 PM 8/13/2004, you wrote: >This was written in access, can anyone convert to T-SQL >I keep doing it and keep missing something. > >SELECT zipCodes.*, >Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)) >AS DistanceInMiles 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] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL help!
At 03:18 PM 8/10/2004, you wrote: >This is probably basic, but my brain is not functioning at this point >today... > >I need to compare two tables. They both contain customer numbers. One table >mimics the other so the same data *should* be in each. It has come to my >attention that there are orphans in one of the tables. > >What I'd like to do is compare one table against the other, find the orphans >in that table and list them out. Then vice versa with the other table. > >I was attempting to do a Inner join but it didn't seem to work. Anyone with >ideas? You could do something like... SELECT * FROM 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-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Coldfusion Web Image Editor
At 10:55 AM 7/13/2004, you wrote: >The types of functions you are describing need not be client based. > >You could do this by just selecting an area of an image (a fairly easy >dhtml or flash function), then submitting the results to the server with >the imagename, function and select area. > >Most of the cf image tags can handle the crop or resize. > >Then return the result back to the browser, along with a "restore" button, >and even a history list of "steps" taken from the original image. That's all I need to do, really. Might be fairly easy for you, but I have no idea how to do that in either 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: Coldfusion Web Image Editor
At 10:23 AM 7/13/2004, you wrote: >Doest anyone know of a image editor that can be used in a webpage, >preferably not a java applet etc. It does not have to be the >"photoshop" of web browsers, but resize, crop etc would be great. The >cheapest, or free would be best like always! Ooo, damn, I need 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, 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] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compare 2 SQL Databases for structural changes?
At 02:53 PM 5/24/2004, Burns, John D wrote: >Sorry, I forgot to include this in my other post. > >I also need to know if anyone knows of any tools to compare 2 MS SQL >Databases for changes in structure. Ex: New tables, new fields, changes >in field types, etc. Thanks! http://www.red-gate.com/sql/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
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-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 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 12:28 PM 2/27/2004, you wrote: >I don't use MS SQL Server so I haven't compared it, but IIRC Paul >Hastings recommends it. >But the most important thing from this thread appears to be that >people need to stop using the JDBC-ODBC bridge (Type 1) and >switch to a JDBC Type 3 or Type 4 driver. Even if it is just to >shut down 2 more daemons :-) I use another application language that can only access ODBC, unfortunately, and I'm having issues with it reading Unicode data correctly (CFMX reads it just fine, but it's obviously not using ODBC). Are there any options for bridging 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: New artwork available!
At 03:45 PM 6/23/2002 -0400, you wrote: > > >Once you offer CFMX (official) support for Deerfield Website Pro I'll be >glad to put the powered by buttons on sites we create. > >Us website Pro religious fanatics are always willing to jump on the >bandwagon as long as you are preaching our gospel. > > 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 news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
