low resource rdbms

2005-11-06 Thread Greg Morphis
What's the best free low resource RDBMS? I'm currently using Postgres, does MySQL use less? Has anyone installed the Oracle Express DBMS? It's a large install 100+MB, how is it on resources? -- Auxilium meum a Domino ~| Logware

Re: Strange DB behaviour

2005-11-06 Thread James Holmes
Set the number of pooled statements for the DNS to 0. On 11/5/05, Snake [EMAIL PROTECTED] wrote: The changes are always made via enterprise manager, and like I said, it's random. The problem only occurs once in a blue moon. ~|

Re: CF7 and 64-bit CPUs

2005-11-06 Thread Jorge Tejada
will it work on a linux 64-bit OS?, exactly RHEL4 On 11/3/05, Tim Blair [EMAIL PROTECTED] wrote: Will CF7 work on a 64-bit processor running with a 32-bit OS? The answer is yes: you just have to run a copy of the installer where the download hadn't aborted in the middle... Doh! Tim. --

Re: Strange DB behaviour

2005-11-06 Thread James Holmes
Sorry, that should be DSN not DNS. On 11/6/05, James Holmes [EMAIL PROTECTED] wrote: Set the number of pooled statements for the DNS to 0. On 11/5/05, Snake [EMAIL PROTECTED] wrote: The changes are always made via enterprise manager, and like I said, it's random. The problem only occurs

Just solved a troublesome memory leak running CFMX on W2k3 SP1

2005-11-06 Thread Paul Vernon
I'm posting this to CF-Talk as CFMX 6 and 7 paired with W2k3 SP1 seems to be the only common thread to this problem when Googling for a solution. Running on W2k3 SP1 Standard Server with CFMX running and accessing it via Terminal Services has had the annoying side effect of driving up the memory

Re: Just solved a troublesome memory leak running CFMX on W2k3 SP1

2005-11-06 Thread Douglas Knudsen
interesting. Curious, when you use TS, do you actually logout wehn done or just close the TS client? Closing the TS client leaves you logged in on the server. DK On 11/6/05, Paul Vernon [EMAIL PROTECTED] wrote: I'm posting this to CF-Talk as CFMX 6 and 7 paired with W2k3 SP1 seems to be the

RE: Convert Address to Latitude/Longitude

2005-11-06 Thread Emmet McGovern
Yeah. I looked at it a bit more and discovered he's probably just posting in the link to this location method (i.e.?1234+main+street,+city+zip). Then source scraping the lon+lat out. Not nearly as exciting as I had hoped and definitely against Google's terms of use. I was hoping for another API

GetTickCount() and application.cfc

2005-11-06 Thread Mark Leder
Trying to make the getTickCount() function work inside an application.cfc onRequestStart and onRequestEnd methods. The onRequestStart method returns the variable, but onRequestEnd does not (var can't be found by CF). I did a dump and the onRequestEnd vars do not appear. What am I doing wrong?

RE: GetTickCount() and application.cfc

2005-11-06 Thread Dawson, Michael
If you are dumping the onRequestEnd() vars on the same page, I wouldn't think they would appear because the page has already been generated. (I'm not positive, however.) You can use CFLOG or CFMAIL to send you this information. Also, did you try creating a variable, in the application.cfc, but

CF Upgrade to 7.0

2005-11-06 Thread Jim Curran
I am upgrading from MX 6.1 to 7.0 and the server has been Importing your ColdFusion settings. This might take a few minutes. for the past hour. The sites are working, but I cannot get into the Administrator because it is importing. There are Verity collections that need to be created, but I

Re: GetTickCount() and application.cfc

2005-11-06 Thread Sean Corfield
On 11/6/05, Mark Leder [EMAIL PROTECTED] wrote: Trying to make the getTickCount() function work inside an application.cfc onRequestStart and onRequestEnd methods. The onRequestStart method returns the variable, but onRequestEnd does not (var can't be found by CF). onRequestStart() returns a

Re: eclpise and dw playing together

2005-11-06 Thread Sean Corfield
On 11/5/05, dave [EMAIL PROTECTED] wrote: can they both read from the same folders without having to reimport the files in ecplise every time you switch between them? If you're editing the same file in both applications, this shouldn't surprise you. At least these applications let you know the

RE: Just solved a troublesome memory leak running CFMX on W2k3 SP1

2005-11-06 Thread Paul Vernon
Our procedure is to always, always, always log out It seems to be an issue with W2k3 SP1 directly but only when running CFMX. W2k3 SP0 never suffered from the problem and the only people that seem to complain about the memory leak are people running W2k3 SP1 and CFMX together Paul

CF 7.0 and Verity K2

2005-11-06 Thread Jim Curran
Anyone know how to disable using K2 on CF 7? The search indexing is taking forever compared to the old default Verity service. Any help would be greatly appreciated. - j James Curran Nylon Technology 6 West 14th Street 4th Floor New York, NY 10011 212.691.1134 phone 212.691.3477 fax [EMAIL

RE: CF 7.0 and Verity K2

2005-11-06 Thread Jeff Garza
K2 is the default for 7. VDK mode is gone. Jeff -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED] Sent: Sunday, November 06, 2005 12:23 PM To: CF-Talk Subject: CF 7.0 and Verity K2 Anyone know how to disable using K2 on CF 7? The search indexing is taking forever

RE: CF 7.0 and Verity K2

2005-11-06 Thread Jim Curran
Do you know why it is almost twice as slow as the old indexing methods? - j -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Sunday, November 06, 2005 2:30 PM To: CF-Talk Subject: RE: CF 7.0 and Verity K2 K2 is the default for 7. VDK mode is gone. Jeff

RE: GetTickCount() and application.cfc

2005-11-06 Thread Mark Leder
I don't mean to sound rude but have you read the chapter on Application.cfc in the ColdFusion MX 7 Developer's Guide? Valid question - Yes, several times over the past 4 months, again last night. Also, figured out the problem, onRequestStart code was fine. I moved the endingTick count vars

RE: CF 7.0 and Verity K2

2005-11-06 Thread Jeff Garza
That was noted during the beta... It is part of the trade-off of having much faster searches I guess. I do know that Verity is including a lot more information about each document now so that would definitely impact the time it takes to index each document. Wild guess here... Does your

Re: eclpise and dw playing together

2005-11-06 Thread dave
well this is all your damn fault sean!! actually, i guess I didn't word it correctly. No it doesn't suprise me but I saw sean using both and it makes good sense especially since flex and as i hear cfm are really gunna be using the ecplise ide I better get used to it, actually it sounds like mm

ot: happy bday will!

2005-11-06 Thread dave
yup ppl its wills bday, I know you all are poor but if we all kick in a couple of bucks we can get him a starter membership to hair club for men!! ;)~ haha hahaha jk... kinda happy bday wilber ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and

Re: eclpise and dw playing together

2005-11-06 Thread John C. Bland II
I haven't used it thoroughly but couldn't you just set your eclipse application for the same directory as your site files? If I were on my desktop I'd test but I can't at the moment. On 11/6/05, dave [EMAIL PROTECTED] wrote: well this is all your damn fault sean!! actually, i guess I didn't

Re: eclpise and dw playing together

2005-11-06 Thread Sean Corfield
On 11/6/05, dave [EMAIL PROTECTED] wrote: I wasn't saying that if you have dw and eclipse open with the same file in each, I was looking it at like sean uses it, I need dw for cssp layouts or for the presentation tier but would like to have ecplise open with the cfc's and data pier but not

Re: GetTickCount() and application.cfc

2005-11-06 Thread Sean Corfield
On 11/6/05, Mark Leder [EMAIL PROTECTED] wrote: Apparently, the onRequestEnd fires after the footer, so that's why the vars weren't being set. Yes the order of execution is: onApplicationStart() - if the app is not already initialized onSessionStart() - if the session is not already

Re: low resource rdbms

2005-11-06 Thread Greg Morphis
Anyone have any suggestions? On 11/6/05, Greg Morphis [EMAIL PROTECTED] wrote: What's the best free low resource RDBMS? I'm currently using Postgres, does MySQL use less? Has anyone installed the Oracle Express DBMS? It's a large install 100+MB, how is it on resources? -- Auxilium meum a

RE: low resource rdbms

2005-11-06 Thread Snake
MySQL seems pretty low from my experience. But I prefer Firebird SQL. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: 06 November 2005 23:20 To: CF-Talk Subject: Re: low resource rdbms Anyone have any suggestions? On 11/6/05, Greg Morphis [EMAIL PROTECTED]

RE: low resource rdbms

2005-11-06 Thread Dave Watts
What's the best free low resource RDBMS? If your only criteria is that it use few resources, I suspect an embedded database like Pointbase might be best. Pointbase is actually distributed with JRun. The only reason I know anything about it at all is that the MM JRun and Flex classes used to use

Re: ColdFusion MX 7.0.1 Cumulative Hot Fix 1 Available

2005-11-06 Thread dcooper
On 11/4/05, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: Makes sense, thanks. For those who might not have seen his thread, Mike Nimer noted that you currently *cannot* have the Flex 2 Adapter installed with this hotfix, as they have just uncovered an issue

Problem with fields in SQL 2000 DB

2005-11-06 Thread Yves Arsenault
Hello, I was given a small contract to build a front end for a MS SQL 2000 DB. The server used to build the front end is currently using BD as the cfml server. I was into the process of starting to code and I noticed something that is giving me a bit of a problem. I noticed that some of the

RE: Problem with fields in SQL 2000 DB

2005-11-06 Thread Dave Watts
I noticed that some of the table's field names are named with spaces.. like: First name So when I query this and dump the query, I see all the info.. When I try a cfoutput the First name field I get a Badly formatted template error I'm assuming that the space in the field name is

Re: Problem with fields in SQL 2000 DB

2005-11-06 Thread Jeff Garza
you need to alias your fields... SELECT [first name] AS fname FROM mytable You'll have to do this for any column that contains spaces... HTH, Jeff - Original Message - From: Yves Arsenault [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, November 06, 2005 6:06 PM

Re: Problem with fields in SQL 2000 DB

2005-11-06 Thread Yves Arsenault
haha That's the first thing I thought of I had tried the alias, but didn't use quotes. I'll use the quotes and try to have fun with this... Thanks, Yves On 11/6/05, Dave Watts [EMAIL PROTECTED] wrote: I noticed that some of the table's field names are named with spaces.. like: First

Re: Problem with fields in SQL 2000 DB

2005-11-06 Thread Yves Arsenault
Thanks Jeff! ;-) Yves On 11/6/05, Jeff Garza [EMAIL PROTECTED] wrote: you need to alias your fields... SELECT [first name] AS fname FROM mytable You'll have to do this for any column that contains spaces... HTH, Jeff - Original Message - From: Yves Arsenault [EMAIL

RE: happy bday will!

2005-11-06 Thread Bobby Hartsfield
Ruthless... lol ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Sunday, November 06, 2005 4:11 PM To: CF-Talk Subject: ot: happy bday will! yup ppl its wills bday, I know you all are poor but if we

Re: Special Characters (Unicode?)

2005-11-06 Thread Mike Rogan
Mike Rogan wrote: 1. Export data from FMP in CSV format, then import to SQL Server and how are you defining the sql server columns holding the text imported from that infernal database? The SQL Server columns are defined as ntext, but I have also tried nvarchar.

Bday boy needs some left outer join help

2005-11-06 Thread Will Tomlinson
I'm running a query on product SKUS for and edit form. The problem is I need to return a SKU even if there aren't options available for it. Right now it doesn't. Here's my query as of now: cfquery name=getskuinventory datasource=#VARIABLES.dsn# SELECT tblprod_SKUS.SKUID,

Re: Bday boy needs some left outer join help

2005-11-06 Thread Will Tomlinson
But how would I convert the 1st query (4 tables) to a full left join. I meant how would I convert the 1st query (4 tables) to a left outer join? Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time

Re: Bday boy needs some left outer join help

2005-11-06 Thread Tyler Fitch
Just keep writing LEFT OUTER JOIN FROM tblprod_SKUS LEFT OUTER JOIN tblSKUoptions ON tblprod_SKUS.SKUID = tblSKUoptions_rel.optionSKUID LEFT OUTER JOIN tblproducts ON tblprod_SKUS.SKU_prodID = tblproducts.prodID LEFT OUTER JOIN tblshiptimes ON tblprod_SKUS.shiptimeID = tblshiptimes.shiptimeID

Re: Bday boy needs some left outer join help

2005-11-06 Thread Will Tomlinson
Ok I'll give it a shot. I'm using cfqueryparam but hof took it out of my post. Thanks much! Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application

ColdFusion Reseller Accounts

2005-11-06 Thread Anne Girardeau
Anyone know of a good ColdFusion reseller service? The reason why I ask is because I'm currently working on a couple of projects that both need hosting. Now, I currently have a VPS with Apollo Hosting and could, in theory, host these new sites on my VPS. However, I personally don't want to

Re: Bday boy needs some left outer join help

2005-11-06 Thread Will Tomlinson
Tyler, I'm getting this error. It's the same one I've gotten thru this whole process: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tblSKUoptions_rel.optionSKUID =

RE: CF Upgrade to 7.0

2005-11-06 Thread Dawson, Michael
Check the install docs. I think there is a setting you can use that will basically say the import is complete. Or, you might try to access the site again. But, if you use IE on w2k3 server, make sure you allow the site in your browser. You might also try to access it from an IP address if it

RE: Problem with fields in SQL 2000 DB

2005-11-06 Thread Dawson, Michael
I would suggest creating a view, for each table. That way, you only need to alias the fields one time and then you can refer to the new field names in your SQL statement. M!ke -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Sunday, November 06, 2005 7:32 PM To:

onSessionEnd Error on 7.01

2005-11-06 Thread Steve Bryant
We just moved a site to a new server. The old server was running ColdFusion MX 7 while the new one is running ColdFusion MX 7.01. I suddenly started getting errors ( reported via onError() ) saying that onSessionEnd() couldn't be found. I added onSessionEnd to Application.cfc and I got a new

RE: ColdFusion Reseller Accounts

2005-11-06 Thread Andrew Stevens
Hi Anne, I can't vouch for them, as I've never used them: http://www.hostnexus.com/solutions/coldfusion.htm But I have considered one of their CF reseller options... I just couldn't commit. Has anyone else tried HostNexus? Cheers, AS -Original Message- From: Anne Girardeau