Re: Anyone interested in Railo hosting?

2007-02-06 Thread Robertson-Ravo, Neil (RX)
Interesting, surely you should get Adobe to change ColdFusion to be as fast as Railo (though I haven't seen or used Railo so I would have take your work that it is faster!) "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a divis

Re: Anyone interested in Railo hosting?

2007-02-06 Thread Gert Franz
Hi Neil, i can easily post why this is: Railo, for a good reason which I will post down below does not support the following. 1: 2: 3: <--- this throwhs an error since a does not contain a key named "sub". It just contains a key named "sub.subkey". And all the texts in CFFM are defined lik

Re: Anyone interested in Railo hosting?

2007-02-06 Thread Robertson-Ravo, Neil (RX)
"for CFFM because CFFM "out of the box" doesn't work with Railo." Who's fault is that? Does CFFM work on ColdFusion and BD with no changes? Surely if it is CFML then it should be Adobe based CFML as the benchmark, guide. N "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadran

Re: Anyone interested in Railo hosting?

2007-02-06 Thread Robertson-Ravo, Neil (RX)
I dunno, CF4.5 and CF5 were solid. MX was crap in every way, 6.1 and up... Solid again. But yeah, I am not sure how anyone can say that Railo is better than any other CFML engine in every way?! "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1D

Re: Anyone interested in Railo hosting?

2007-02-06 Thread Gert Franz
Hi all together, I read all the posts from you guys saying that there should be no reason to host Railo since it is only compatible to version MX 6.1. And you know you are absolutely right, if you do not care for: - security - performance - price Why do people still start new hosting on Bluedrag

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Andrew Grosset
Very interesting alternative...though "cfstoredproc" needs adding before I can use it. Andrew. >Well all the ones that hear, that there are alternatives with low or no >costs at all. Like Railo or Smith. > >Greetings / GrĂ¼sse >Gert Franz >Customer Care >Railo Technologies GmbH >[EMAIL PROTECTED

Re: Browser taking too much time in rendering the table data on screen

2007-02-06 Thread hussain shaikh
I have tried setting fixed width for each column but the issue is since the length of the data in it varies the width is also varying according to it. So irrespective of the width of the cell, the table is adjusting the width to fit in the data becoz of which the tables are not aligning properly.

Re: FLEX Questions

2007-02-06 Thread Rick Root
On 2/6/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > Well I have been messing with Flash Forms quite a bit and I think that > they are pretty cool, so now I think I am ready to take the leap to FLEX. I have > been hearing a lot about it so I was wondering: > > 1. What books/sites do you all recomm

Re: automotive year, make, and model drop down

2007-02-06 Thread Jay Morris
>I built this application for a friend of mine and it really has not >gone anywhere. I have thousands of records that I have gathered from >about 6 different sources. Let me know if you are interested. John, I am interetsed in learning some more on the application you built, I will send you an em

Re: automotive year, make, and model drop down

2007-02-06 Thread Jay Morris
>I have what you are looking for. > >http://www.needaengine.com/request.cfm > >I built this application for a friend of mine and it really has not >gone anywhere. I have thousands of records that I have gathered from >about 6 different sources. Let me know if you are interested. > >Thanks > >John >

Re: Transact-SQL help

2007-02-06 Thread Rick Root
Jim, you make an excellent point that I hadn'e considered. However, in my blog entry on the topic, I'm actually doubling the size of the rectangle for the longitude, so I'm doing @lat1-(@[EMAIL PROTECTED]) so even though my range factor technically should be larger, I actually double it anyway,

Re: Anyone interested in Railo hosting?

2007-02-06 Thread Rick Root
On 2/6/07, Dale Fraser <[EMAIL PROTECTED]> wrote: > > I agree, unless your giving it away, I wouldn't pay for hosting on > anything > other than the official product, I only stand to loose stuff and gain > nothing. I recommend Bluedragon hosting for some of my clients who get VPS accounts at Vivi

Re: Anyone interested in Railo hosting?

2007-02-06 Thread AJ Mercer
Will you be waiting for version 1.1? I believe that will be very close to Adobe CF 7 On 2/7/07, Peter Boughton <[EMAIL PROTECTED]> wrote: > > Hello. > > In a month or two I'll be getting a dedicated server, and I've had a > thought: maybe I should go for the next server spec up, get Railo > Enter

Re: Help with query please.

2007-02-06 Thread Doug Brown
Well here is the offending code. Some of it is quite long especially the zip locator, so I will attempt to shorten it for the lists sake. Maybe someone can show me the best ways to handle this. First the zip locator runs and selects all zip codes that are within the specified criteria. 0-500 miles

Re: Anyone interested in Railo hosting?

2007-02-06 Thread Doug Brown
No comment... Doug B. - Original Message - From: "Dale Fraser" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, February 06, 2007 7:27 PM Subject: RE: Anyone interested in Railo hosting? > I agree, unless your giving it away, I wouldn't pay for hosting on anything > other than the

RE: FLEX Questions

2007-02-06 Thread Mark Fuqua
Here here! I despise thieves. At least if your "honest" enough to just use a pirated version, you're honest enough to admit what you're looking at in the mirror. Mark Fuqua -Original Message- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 9:32 PM To: CF-Tal

RE: FLEX Questions

2007-02-06 Thread Dale Fraser
I'm not sure this is much better than getting a pirated version. It is not the intention of the scheme, and if you're just not interested in buying it and have to resort to scams like this then you might just as well just get a pirated version. Not sure, but does paying the $79.95 make you sleep

RE: Anyone interested in Railo hosting?

2007-02-06 Thread Dale Fraser
I agree, unless your giving it away, I wouldn't pay for hosting on anything other than the official product, I only stand to loose stuff and gain nothing. Regards Dale Fraser http://dale.fraser.id.au/blog -Original Message- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Wednesda

Re: FLEX Questions

2007-02-06 Thread Ken Wilson
Flex Builder 2 Win or Mac $79.95 + free shipping. http://www.academicsuperstore.com/item/?tname=270585&title=Flex+Builder It does require qualifications but there are several categories (student, teacher, staff, home school, etc) and they'll tell you what is required since it varies based on the V

Re: Anyone interested in Railo hosting?

2007-02-06 Thread Matt Quackenbush
At the risk of sounding like a complete [EMAIL PROTECTED]&!, why would >anyone< want to go backwards and use Railo? I mean, it's still not even compatible with CF MX. I'm sure I speak for an extremely high percentage of CFers out there when I say, "Thank God we're not in the pre-MX days anymore!

Anyone interested in Railo hosting?

2007-02-06 Thread Peter Boughton
Hello. In a month or two I'll be getting a dedicated server, and I've had a thought: maybe I should go for the next server spec up, get Railo Enterprise, and offer Railo hosting. (for those unaware of what Railo is, it's a really excellent CFML engine, better than all other CFML engines in nearl

Re: ColdFusion on Apache is better than IIS?

2007-02-06 Thread James Holmes
Interestingly, this may in fact be true for livedocs at least: http://toolbar.netcraft.com/site_report?url=http://livedocs.macromedia.com JRun webserver shows for every entry. However,for www.adobe.com, wherein lies the CF powered forums (http://www.adobe.com/cfusion/webforums/forum/index.cfm):

RE: Referencing a CFC above the calling file.

2007-02-06 Thread Jaime Metcher
Ben, That's quite twisted. I'd even call it a bug. I wish I'd thought of it. This probably doesn't help Andy, but the way I deal with this is to use IIS virtual directories, not CF mappings, and remove all IIS permissions to the virtual directory. This addresses Peter Bell's security concerns

Re: Help with query please.

2007-02-06 Thread Alan Rother
That makes sense, you have several IN statements and without knowing much about your app, I'd say based on the names in your IN statements, you may have a lot of them. ZIPCODES, CITIES and STATES could be very large lists... That many lists in 3 different IN statements tied together using ORs... I

Re: ColdFusion on Apache is better than IIS?

2007-02-06 Thread John Paul Ashenfelter
On 2/2/07, Jacob Munson <[EMAIL PROTECTED]> wrote: > > "for static documents, a properly tuned IIS is best.. in many other > > instances Apache works better" > > Doh, sorry I accidentally hit send before I could explain myself! The > above quote is from another mailing list I'm on (not CF related)

Re: Help with query please.

2007-02-06 Thread Doug Brown
Well, this is the issue according to Microsoft. http://support.microsoft.com/kb/288095 Doug B. - Original Message - From: "Alan Rother" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, February 06, 2007 5:03 PM Subject: Re: Help with query please. > Hey Doug, > > Not sure what is exac

Re: Help with query please.

2007-02-06 Thread Alan Rother
Hey Doug, Not sure what is exactly happening, but what I would recommend is first, capture the output SQL from your CF. To do this, take all the SQL and put it into a CFSAVECONTENT Then dump that out and try using it in SQL Query Analyzer. It should help narrow down where the issue is. -- Alan

RE: FLEX Questions

2007-02-06 Thread Mark Fuqua
You guys are kidding, right? -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 5:46 PM To: CF-Talk Subject: RE: FLEX Questions So I have a daughter who is in HS. That counts? Bruce Yup, I assume she will let you use it won't she. Just like

RE: FLEX Questions

2007-02-06 Thread Mark Fuqua
Is Bruce a student? -Original Message- From: So Kenfused [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 5:11 PM To: CF-Talk Subject: Re: FLEX Questions FLEX Builder 2.0 with charting, Educational pricing $99.00. (price for students k-12, college, and teachers). Go to Adobe.c

Help with query please.

2007-02-06 Thread Doug Brown
Ok, cannot seem to get this to work. I get a stack overflow due to the IN clause in the query. Microsoft says this is an issue with SQL2K and I need to do the following... CREATE TABLE #IN_values (au_id char(4)) INSERT INTO #IN_values select au_id FROM Table_with_values_123456789... SELECT max(

Server Using Up all the memory

2007-02-06 Thread terry thon
I downloaded the latest patch from Microsoft and the memory is going wild. Running: CF 4.0 Windows 2000 server I have reloaded cold fusion. I cannot go back and unload the micro patch. cold fusion is the processes box is bouncing up and down using memory. I put in 1 gig of memory. Had 500 pri

RE: Referencing a CFC above the calling file.

2007-02-06 Thread Ben Nadel
Andy, I know that you already found a solution, but you might want to ake a peek at this one. I never used mapped paths and here is a solution that I have used before: http://www.bennadel.com/blog/348-Creating-ColdFusion-Components-In-Paren t-Directories-From-Sub-Directories-Without-Mapped-Paths.

Re: How do you handle 404's and SEO?

2007-02-06 Thread Casey Dougall
Well, you shouldn't have any 404's LOL, I laugh but I'm actually serious. If it was an old page in the index somewhere you should never let it reach a 404 error. Our SEO team would kill us if we let a site re-design go with a 404. Something I'm doing now on one of our sites since I don't even want

RE: Reading from an Excel file through ColdFusion.

2007-02-06 Thread Ben Nadel
No worries dude. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 12:35 AM To: CF-Talk Subjec

RE: FLEX Questions

2007-02-06 Thread Ian Skinner
So I have a daughter who is in HS. That counts? Bruce Yup, I assume she will let you use it won't she. Just like the 1st grade daughter some I know is letting him borrow her copy. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | ---

Re: FLEX Questions

2007-02-06 Thread Bruce Sorge
Thanks Brad. That helps. I would opt for the standard edition of course since any apps I write will be going to a hosting company. Bruce On 2/6/07, Brad Wood <[EMAIL PROTECTED]> wrote: > > 2. What skills beyond CF are required? > > I would like to point out that you DON'T need to know CF to make

RE: FLEX Questions

2007-02-06 Thread Brad Wood
2. What skills beyond CF are required? I would like to point out that you DON'T need to know CF to make Flex apps. Flex is a language all its own. You write mxml in some sort of editor, be it notepad or Flex builder. Then you compile that to a stand-alone swf. You don't have to have ANY serve

Re: FLEX Questions

2007-02-06 Thread Bruce Sorge
So I have a daughter who is in HS. That counts? Bruce On 2/6/07, Ian Skinner <[EMAIL PROTECTED]> wrote: > > Yup any creditionals proving you are currently taking at least one school > course, or your son or daughter or wife or co-worker is. > > > > ~~

RE: FLEX Questions

2007-02-06 Thread Ian Skinner
would it be safe to assume that there's some sort of credentials that you'd need to provide to prove that you were, indeed eligible for educational pricing? Yup any creditionals proving you are currently taking at least one school course, or your son or daughter or wife or co-worker is. ---

How do you handle 404's and SEO?

2007-02-06 Thread Matt Robertson
I have a client who feels that CF handling 404 errors is a problem with respect to SEO. He may be right. How do you folks handle a genuine 404 in your CF-based 404 handler? -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~~~

Re: Footer not displayed at the bottom of the page

2007-02-06 Thread So Kenfused
Then again isn't always some boob that creates the problem? Different boob, never mind. Charlie Griefer wrote: > On 2/6/07, Dawson, Michael <[EMAIL PROTECTED]> wrote: > >> What does a breast have to do with this problem? >> > > i'd hate to live in a world where there was a problem that bo

Re: FLEX Questions

2007-02-06 Thread Charlie Griefer
On 2/6/07, So Kenfused <[EMAIL PROTECTED]> wrote: > FLEX Builder 2.0 with charting, Educational pricing $99.00. (price for > students k-12, college, and teachers). Go to Adobe.com search for > educational pricing would it be safe to assume that there's some sort of credentials that you'd need to

Re: Footer not displayed at the bottom of the page

2007-02-06 Thread So Kenfused
Had he been paying attention to the screen and coding instead of the pair in the cube next to him he wouldn't be having these problems. Dawson, Michael wrote: > What does a breast have to do with this problem? > > -Original Message- > From: So Kenfused [mailto:[EMAIL PROTECTED] > Sent: T

Re: Footer not displayed at the bottom of the page

2007-02-06 Thread Charlie Griefer
On 2/6/07, Dawson, Michael <[EMAIL PROTECTED]> wrote: > What does a breast have to do with this problem? i'd hate to live in a world where there was a problem that boobs wouldn't solve. > -Original Message- > From: So Kenfused [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 06, 2007 2

Re: FLEX Questions

2007-02-06 Thread Charlie Griefer
On 2/6/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > Well I have been messing with Flash Forms quite a bit and I think that they > are pretty cool, so now I think I am ready to take the leap to FLEX. I have > been hearing a lot about it so I was wondering: > > 1. What books/sites do you all recommen

Re: FLEX Questions

2007-02-06 Thread So Kenfused
FLEX Builder 2.0 with charting, Educational pricing $99.00. (price for students k-12, college, and teachers). Go to Adobe.com search for educational pricing Bruce Sorge wrote: > Well I have been messing with Flash Forms quite a bit and I think that they > are pretty cool, so now I think I am re

RE: Footer not displayed at the bottom of the page

2007-02-06 Thread Dawson, Michael
What does a breast have to do with this problem? -Original Message- From: So Kenfused [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 2:47 PM To: CF-Talk Subject: Re: Footer not displayed at the bottom of the page I go tit to work by doing the following: ~

FLEX Questions

2007-02-06 Thread Bruce Sorge
Well I have been messing with Flash Forms quite a bit and I think that they are pretty cool, so now I think I am ready to take the leap to FLEX. I have been hearing a lot about it so I was wondering: 1. What books/sites do you all recommend to learn Flex? 2. What skills beyond CF are required? 3.

Re: Footer not displayed at the bottom of the page

2007-02-06 Thread So Kenfused
I go tit to work by doing the following: #1. I got rid of the extra /div. #2. I closed the font tag in your footer. #3. I put just above the footer. #3 will probably do it by itself however, the other fixes should be considered. I would probably rewrite a couple areas of this code such as

Re: Footer not displayed at the bottom of the page

2007-02-06 Thread So Kenfused
>I would suggest you check the HTML of that page with a W3C Checker as it >looks like you have missed a table element somewhere , or > > >-Original Message- >From: Frank Greene [mailto:[EMAIL PROTECTED] >Sent: 06 February 2007 18:13 >To: CF-Talk >Subject: Footer not displayed at the botto

Re: data source metadata

2007-02-06 Thread Robertson-Ravo, Neil (RX)
? Not sure what you mean (again) :-) "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. I

RE: data source metadata

2007-02-06 Thread Brad Wood
Lol. Until Adobe changes the format of the neo-query.xml file. ~Brad -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 3:07 PM To: CF-Talk Subject: Re: data source metadata Not sure what you mean? Surely reading the XML in via

Re: Footer not displayed at the bottom of the page

2007-02-06 Thread So Kenfused
What's with all the empty DIVs? It appears as though you may have one closing div more (9) than opening divs (8). I've not gotten to the table yet. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create

Re: data source metadata

2007-02-06 Thread Robertson-Ravo, Neil (RX)
Not sure what you mean? Surely reading the XML in via cffile etc it programmatic. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information whic

Re: Sporadic Slow Page Loads

2007-02-06 Thread Robertson-Ravo, Neil (RX)
Sounds like a Garbage Collection, probably due to not enough memory or incorrect collection type. Do you have SeeFusion/FusionReactor? You may also want to look into something called VisualGC from Sun to debug. T "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond

Re: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Eric Haskins
That SNAP server was the similar solution. Windows boxes can access it as a Mapped Drive or in our case the SNAP server is in the domain so it is a UNC share. The linux boxes access it via NFS so we have one repository for all our files. Now if I can get Serena Mover setup and running it would han

RE: data source metadata

2007-02-06 Thread Brad Wood
> If you own the server, just look at neo-query.xml. But that wouldn't be programmatically. > If you have access to the AdminAPI and on CF7, then yes. Yeah, that actually works as well as the service factory. The annoying thing is that if you specify your database in the jdbc url (like a SeeFus

Sporadic Slow Page Loads

2007-02-06 Thread Peter Sheats
Hey Everyone, I was wondering if anyone could give me some ideas on how to identify the cause of this problem. The Problem: Every 10 to 15 minutes pages on my site start to take anywhere from 8 seconds to more than 100 seconds to be processed. It appears to happen sporadically - no pattern th

Re: Transact-SQL help

2007-02-06 Thread Robertson-Ravo, Neil (RX)
We are quite lucky in that our Search Engine software has GeoSearch built in :-) it is damn impressive to have it however you get it though, for $5 it's a steal to get the data! "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingd

Re: Transact-SQL help

2007-02-06 Thread Jim Wright
Rick Root wrote: > Actually, I did a limitation by longitude as well, because at the equator, > the fudge factor is the same (approximatley 69 miles per degree)... > everything in the US is less than that but I figured what the heck. So I > draw the box on both lat and long, knowing that the longi

Re: Transact-SQL help

2007-02-06 Thread Rick Root
I blogged all this here: http://www.opensourcecf.com/1/2007/02/Determining-Zip-Code-Proximity.cfm ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doub

RE: Transact-SQL help

2007-02-06 Thread Russ
You can also not think about the math, precompute the distance tables, and then only keep data in there where the distance is -Original Message- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 06, 2007 3:10 PM > To: CF-Talk > Subject: Re: Transact-SQL help > > Actual

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Russ
I originally set up everything using UNC shares with DFS, but I felt it was a bit slow. I've since ended up using DFS just to replicate the data, and I still access all the data locally. We don't have a huge amount of data though... Lots of files, but total maybe <5gb. Russ > -Original

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Russ
And as long as you have Windows and your servers are members of the domain, then your environment should support it. I'm still looking for a similar thing for linux. Russ > -Original Message- > From: Paul Vernon [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 06, 2007 11:32 AM > To:

Re: data source metadata

2007-02-06 Thread Robertson-Ravo, Neil (RX)
If you have access to the AdminAPI and on CF7, then yes. If you own the server, just look at neo-query.xml. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. I

Re: Transact-SQL help

2007-02-06 Thread Rick Root
Actually, I did a limitation by longitude as well, because at the equator, the fudge factor is the same (approximatley 69 miles per degree)... everything in the US is less than that but I figured what the heck. So I draw the box on both lat and long, knowing that the longitude will actually encomp

data source metadata

2007-02-06 Thread Brad Wood
If I have a ColdFusion data source name, can I programmatically access information such as the database it is pointed to and/or the jdbc url? ~Brad ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & cr

Re: single session variable disappearing.

2007-02-06 Thread Claude Schneegans
>>Can anybody think of unusual reasons for a specific session variable to randomly disappear? Yeah, when CFHTTPing from a template, the called template is not aware of the current session and will open a new one. This one kept me busy for quite a while some times ;-) -- __

Re: Transact-SQL help

2007-02-06 Thread Jim Wright
Rick Root wrote: > > I like how you're limiting by latitude only and using the radius as well. > Thinking about limiting it by longitude made my head hurt...I thought about using some larger constant (like the 2 degrees that you used), but in Alaska, 2 degrees longitude only equates to about 4

Re: Query error

2007-02-06 Thread Doug Brown
I found it. I guess I have to many records to perform an IN search against the table and will need to use a temp table to do it. According to MS and using SQL2000 Doug B. - Original Message - From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, February 06, 2007 12:44 PM S

Re: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Eric Haskins
We use UNC shares in our current enviroment but now we are integrating Linux Apache boxes on the front end so in the interim we have a 1TB File (750Mb Raid 5) Server that does NFS and CIFS shares. We are moving to a Netapps Filer in a bit so we just picked up a SNAP Server to hold us over Eric O

Query error

2007-02-06 Thread Doug Brown
I get the following during a radius check on zipcodes when I choose say 500 miles from point x Internal Query Processor Error: The query processor ran out of stack space during query optimization Any Ideas? Doug B. ~| Upgrade

Re: Transact-SQL help

2007-02-06 Thread Rick Root
so many solutions, so little time! I like how you're limiting by latitude only and using the radius as well. Doing that actually lowered my execution time to 94ms ... =) On 2/6/07, Jim Wright <[EMAIL PROTECTED]> wrote: > > Russ wrote: > > No, I'm referring to: > > > > > http://www.houseoffusio

Re: Transact-SQL help

2007-02-06 Thread Rick Root
On 2/6/07, Russ <[EMAIL PROTECTED]> wrote: > No, I'm referring to: > > > http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818 Ah, no I hadn't seen that one. I've never used "CROSS JOIN" before.. interesting. However, my final solution actually does the same thing in ab

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Paul Vernon
> We use SVN to deploy to code to a single server, and then we > use DFS to automatically propagate the changes. That of course is the better option if your environment supports it :) Paul ~| Upgrade to Adobe ColdFusion MX7

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Paul Vernon
> You mentioned a program called Robocopy in this post. Can you > provide some additional information? > Robocopy is in the Windows Resource Kit AFAIK, it's a pretty powerful command line tool that you can script to keep folders in sync. As an example, robocopy C:\source \\server\C$\source

Re: Footer not displayed at the bottom of the page

2007-02-06 Thread Jim Wright
Frank Greene wrote: > Hello: > > In December I launched a 30 Gig SQL Server database with 140 ColdFusion > templates. > > I use the OnRequestEnd.cfm template to call the Footer.cfm template. > > For 139 of the templates the footer is displayed at the bottom of the page. > > In just one templat

RE: Footer not displayed at the bottom of the page

2007-02-06 Thread Big Mad Kev
I would suggest you check the HTML of that page with a W3C Checker as it looks like you have missed a table element somewhere , or -Original Message- From: Frank Greene [mailto:[EMAIL PROTECTED] Sent: 06 February 2007 18:13 To: CF-Talk Subject: Footer not displayed at the bottom of the

Re: Changes to Daylight Savings Time in 2007 may affect your data bases (DB2, Oracle and others)

2007-02-06 Thread sam komo
Folloed the recommendation from Adobe, tried applying the Java 1.4.2_11 patch from Sun. Now unable to restart my CF Administrator. How do I safe apply this update? Thanks Sam ~| Upgrade to Adobe ColdFusion MX7 Experience Fle

Footer not displayed at the bottom of the page

2007-02-06 Thread Frank Greene
Hello: In December I launched a 30 Gig SQL Server database with 140 ColdFusion templates. I use the OnRequestEnd.cfm template to call the Footer.cfm template. For 139 of the templates the footer is displayed at the bottom of the page. In just one template the footer is displayed, not at the bo

Re: Transact-SQL help

2007-02-06 Thread Jim Wright
Russ wrote: > No, I'm referring to: > > http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818 > That one is pretty quick here... SELECT b.* FROM tblzipcodes a CROSS JOIN tmpzipcodes b WHERE dbo.getDistance(a.latitude,a.longitude,b.latitude,b.longitude) < 10 AND a.zip = '2

Re: single session variable disappearing.

2007-02-06 Thread Les Mizzell
Ian Skinner wrote: > Do you have an underline in your site name? That can cause session variable > problems. Really? I have never seen this before myself. Is it underlines in the site name, or URLs? I'm having a session variable timeout problem myself on a multi-page form. All files are name

RE: single session variable disappearing.

2007-02-06 Thread Ian Skinner
Do you have an underline in your site name? That can cause session variable problems. Nope, somehow, somewhere the session timeout got set to one second! So, when a session times out, the cfid and cftoken values do not change? That seems a bit unintuitive. -- Ian Skinner Web

Re: MS Access ODBC driver could not be found

2007-02-06 Thread Cutter (CFRelated)
Has the Access DB been replaced with a more current version? I doubt you would be able to open an Access 2007 db with the currently available drivers, for instance. Cutter ___ http://blog.cutterscrossing.com Natasha Zhalkovsky wrote: > I have ColdFusion Administrator installed on my

RE: single session variable disappearing.

2007-02-06 Thread Huff, Jerome P.
Do you have an underline in your site name? That can cause session variable problems. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 1:01 PM To: CF-Talk Subject: single session variable disappearing. Can anybody think of unusual reasons

RE: single session variable disappearing.

2007-02-06 Thread Ian Skinner
> not a lot to go on there. Yeah, unfortunately yes, not much for me to go on either. > you sure it's being set properly (the setting isn't taking place inside of > a conditional block whose condition might not be met)? you sure you're > not deleting it somewhere else in the code? As best as I

Re: single session variable disappearing.

2007-02-06 Thread Charlie Griefer
not a lot to go on there. you sure it's being set properly (the setting isn't taking place inside of a conditional block whose condition might not be met)? you sure you're not deleting it somewhere else in the code? it's just one specific session variable? or it's all session variables other th

single session variable disappearing.

2007-02-06 Thread Ian Skinner
Can anybody think of unusual reasons for a specific session variable to randomly disappear? The session.cfid and session.cftoken values are working just fine, but a session variable I am setting is not consistently persisting from request to request. I am not having any luck finding out a rhym

RE: Transact-SQL help

2007-02-06 Thread Russ
No, I'm referring to: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818 Russ > -Original Message- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 06, 2007 12:42 PM > To: CF-Talk > Subject: Re: Transact-SQL help > > Russ, if you're referri

Re: OT: Transact-SQL help

2007-02-06 Thread Rick Root
On 2/6/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > This query is not indexable so it needs to do the math on each and every > row. Prequalify the rows by drawing an imaginary box on the map from > b.lat + X to b.lat -X and b.lon + X to b.lon -X and finding only the > points in that box (

Re: Transact-SQL help

2007-02-06 Thread Rick Root
Russ, if you're referring to this one: * http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268742 * works fine if you want to pass in the lat/long directly, but I'm trying to come up with a way to do

RE: moving from CF 4.5 to 7.0

2007-02-06 Thread WebSite CFtalk
http://www.google.com/search?q=cfmx7_migrating.pdf (-; -Original Message- From: So Kenfused [mailto:[EMAIL PROTECTED] Sent: 6. februar 2007 16:25 To: CF-Talk Subject: Re: moving from CF 4.5 to 7.0 If you could send that I would appreciate it. It would save me from having to search the a

Re: Survey Application, not polling

2007-02-06 Thread Raymond Camden
It's up to you. If you use wddx you can just serialize/deserialize one packet. If you want to use multiple cookies, you can just put one value in each cookie. You would need to carefully examine exactly what I put in the session scope though. On 2/6/07, coldfusion. developer @ att. net coldfusion.

RE: DevNet meta tag.

2007-02-06 Thread Big Mad Kev
I'm sure now that Devnet Has gone as has the right to use the server software, but ok to use the developer tools? May Be wrong -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 06 February 2007 17:13 To: CF-Talk Subject: DevNet meta tag. What is the current state of o

MS Access ODBC driver could not be found

2007-02-06 Thread Natasha Zhalkovsky
I have ColdFusion Administrator installed on my computer and MS Access database also on my computer. I have added this database as a datasource through Administrator, and it all worked fine for couple months. Last week when verifying datasources I received an error - Connection verification fail

Re: OT: Transact-SQL help

2007-02-06 Thread Jochem van Dieten
Rick Root wrote: > > syntax of my function: getDistance(zip1,long1,lat1,zip2,long2,lat2) > taking either the zip code or the lat/long for each... > SELECT * > FROM prospects A > WHERE > zipcode in > ( > SELECT B.zipcode > FROM zipcodes B > WHERE >getDistance('27502',0.0,0.0,'',B.lati

DevNet meta tag.

2007-02-06 Thread Ian Skinner
What is the current state of old dev-net licensed servers and the tag that is pre-pended to the output; and how this affects doc-types, web services and remote access development. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | -

Re: Survey Application, not polling

2007-02-06 Thread coldfusion . developer
Thanks Ray, I read the docs and Let me see if I'm getting this. I should switch from session managment to client managment using cookies. Then I should take that cookie variable and value and use wddx to serialize and then deserialize and then assign the value in the client.cookie value to th

RE: moving from CF 4.5 to 7.0

2007-02-06 Thread Tero Pikala
I upgraded couple of sites from CF5.0 -> CF7.0 few months ago, here's some things that required fixing: - cfsetting / catchexceptionsbypattern is no longer supported. I just removed it, can't remember what it is for. - cferror type="monitor" was changed to type="exception". Again, can't remember

RE: Transact-SQL help

2007-02-06 Thread Russ
Rick, Did you take a look at the query that I sent earlier? It takes only 3 seconds to run on my machine. Russ > -Original Message- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 06, 2007 11:49 AM > To: CF-Talk > Subject: OT: Transact-SQL help > > I've got my

  1   2   >