64 bit CF on 32 bit IIS

2010-03-15 Thread Michael Dinowitz
Lets say I have a 64 bit install of CF on Win 2003/IIS 6. If I move the IIS to 32 bit mode, will I lose the advantage of 64 bit CF? Do I have to make any changes to the CF connectors? Thanks -- Michael Dinowitz ~| Want to

RE: 64 bit CF on 32 bit IIS

2010-03-15 Thread Andrew Scott
You going to run the Enterprise version, and is ColdFusion V8 or V9? -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, 15 March 2010 5:40 PM To: cf-talk Subject: 64 bit CF on 32 bit IIS Lets say I have a 64 bit install of CF on Win 2003/IIS

Re: 64 bit CF on 32 bit IIS

2010-03-15 Thread Michael Dinowitz
ColdFusion 9 Enterprise -- Michael Dinowitz On Mon, Mar 15, 2010 at 3:41 AM, Andrew Scott andr...@andyscott.id.au wrote: You going to run the Enterprise version, and is ColdFusion V8 or V9? -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent:

RE: Easy Regex question?

2010-03-15 Thread Che Vilnonis
Carol, I used... reReplaceNoCase(myHTML, table.*?.*?/table, , ALL) -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Saturday, March 13, 2010 10:01 AM To: cf-talk Subject: RE: Easy Regex question? Rereplace(html, table.*?/table, , all') Or

Re: Fastest Hardware for ColdFusion 9?

2010-03-15 Thread John Foster
We normally see about 12 requests / machine / sec during peak load. I agree that 64 bit should help by making it possible to use more RAM. We're currently running 32bit with 1.25 GB allocated to the JVM and often come within 10 - 15% of the available JVM RAM on single machines for short

Re: 64 bit CF on 32 bit IIS

2010-03-15 Thread Alan Rother
If I move the IIS to 32 bit mode, will I lose the advantage of 64 bit CF? No, CF couldn't care less what's serving it. The 64 bit advantage comes from the underlying JVM it's using. As long as it's 64 bit hardware, a 64 bit OS and a 64 bit JVM, then the 64 bit version of CF9 will work as

Re: how to maintain source code

2010-03-15 Thread Greg Luce
I recommend setting up a free account with unfuddle.com and in 10 minutes you'll have your codebase in SVN. -- Greg Luce Luce Consulting Services, Inc. www.luceconsulting.net (863) 273-0289 On Sun, Mar 14, 2010 at 11:31 PM, Barney Boisvert bboisv...@gmail.comwrote: Version control

RE: Fastest Hardware for ColdFusion 9?

2010-03-15 Thread Mark A. Kruger
I have found it's really difficult to make a significant dent in 8 cores with a single use machine of any sort... (especially if they have adequate L2 cache - which incidentally is often more important than speed on a processor). It always seems underutilized unless it is a DB server servicing

Repeating Data - Unsure of my use of cfquery

2010-03-15 Thread Steven Sprouse
I posted a few days ago about having multiple cfquery statements in the same document. After some troubleshooting, I finally figured out how to do this. I began building my test form, which is populated from fields in a database, I'm running into a problem where the data is just being

Re: Repeating Data - Unsure of my use of cfquery

2010-03-15 Thread Steven Sprouse
My Code: (link to live page - http://www2.ccboe.com/summeracademy/app/emp/index.cfm) cfquery name=getSchools datasource=filemaker_schools SELECT SchNum, SchoolBrief FROM SCHOOLS ORDER BY SchoolBrief /cfquery cfquery name=getSrastaff datasource=filemaker_srmastaff SELECT ApplySubject,

Re: Repeating Data - Unsure of my use of cfquery

2010-03-15 Thread Barney Boisvert
Your second query is the problem, both the repeating data and the slowness. You have a full outer join of five tables, which is not what you want. You need inner joins. Here is a simple reference that might help you on your way: http://www.sql-tutorial.net/SQL-JOIN.asp Has a million

Re: Repeating Data - Unsure of my use of cfquery

2010-03-15 Thread James Holmes
Looking at the way the data are used, the OP probably needs five queries. The queries are just building options in select inputs. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 15 March 2010 22:36, Barney Boisvert bboisv...@gmail.com wrote: Your second

Re: 64 bit CF on 32 bit IIS

2010-03-15 Thread Dave Watts
Not entirely sure, but I think you'll need to completely un-install IIS to make this change. If so, then yes you would need to update the connectors. You should be able to just run the connector.bat file... But I'm not sure, I've never tried to run the 32 bit IIS on a 64 bit windows install.

Re: 64 bit CF on 32 bit IIS

2010-03-15 Thread Dave Watts
Lets say I have a 64 bit install of CF on Win 2003/IIS 6. If I move the IIS to 32 bit mode, will I lose the advantage of 64 bit CF? Do I have to make any changes to the CF connectors? No, CF will still do its 64-bit thing. But I'm not sure whether the out-of-the-box connectors will work with

Re: Repeating Data - Unsure of my use of cfquery

2010-03-15 Thread Steven Sprouse
Barney, would that require that the different tables have a linking relationship? I think that's my problem. There is no common field shared among these tables. ~| Want to reach the ColdFusion community with something they

Re: Repeating Data - Unsure of my use of cfquery

2010-03-15 Thread James Holmes
Just separate each table into its own query. Use the data from the right table in the right place and the problem is solved. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 15 March 2010 22:39, Steven Sprouse sspro...@ccboe.com wrote: Barney, would that

Re: Repeating Data - Unsure of my use of cfquery

2010-03-15 Thread Steven Sprouse
You guys are awesome. Sometimes it's the easiest things... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

back up sql database after passwords for user table cleared or hashed?

2010-03-15 Thread morchella
Hey Guys. i need to BACKUP DATABASE Northwind TO DISK='C:\Northwind.BAK' WITH MEDIAPASSWORD='mssqltips' but i have a user table, with passwords i need to hash or remove. but i am not sure how to do this with out messing up the data, i need to keep.. thanks for any ideas.. -m

Re: back up sql database after passwords for user table cleared or hashed?

2010-03-15 Thread morchella
nm. just copy db to new db name. edit out crap, back up, and done. On Mon, Mar 15, 2010 at 11:08 AM, morchella morchella.delici...@gmail.com wrote: Hey Guys. i need to BACKUP DATABASE Northwind TO DISK='C:\Northwind.BAK' WITH MEDIAPASSWORD='mssqltips' but i have a user table, with

Re: Easy Regex question?

2010-03-15 Thread Carol F
Thanks Bobby and Che! On Mon, Mar 15, 2010 at 6:00 AM, Che Vilnonis ch...@asitv.com wrote: Carol, I used... reReplaceNoCase(myHTML, table.*?.*?/table, , ALL) -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Saturday, March 13, 2010 10:01 AM To:

linkedin api

2010-03-15 Thread Hugo Ahlenius
Hi, I was just looking for options to have a nicely laid out and current CV, when I realized that I have all that information kept current in linkedin anyways, so I might as well just look into accessing that and prepare a nice html document using my cf engine. Does anyone know of any

RE: linkedin api

2010-03-15 Thread Andy Matthews
Sounds like the world needs someone to build a ColdFusion wrapper for the LinkedIn API Hugo. You up to the challenge? andy -Original Message- From: Hugo Ahlenius [mailto:hugo.ahlen...@nordpil.com] Sent: Monday, March 15, 2010 11:08 AM To: cf-talk Subject: linkedin api Hi, I was

Re: 64 bit CF on 32 bit IIS

2010-03-15 Thread Judah McAuley
Is it at all possible to upgrade to Win2K8? If so, you could use the URL Rewriting in IIS7 and dump Ionic. It has worked out quite well for us thus far. We had to tweak the rules some (we were using Helicon before) but since then has been solid. Otherwise, I'd suggest looking at Apache and

Re: 64 bit CF on 32 bit IIS

2010-03-15 Thread Christopher Stowell
Also with IIS6 your locked in to using 32bit or 64bit application pools across the board (its all shared) but with II7 you can mix and match the application pools where some run 32bit and others run 64bit. From: Judah McAuley ju...@wiredotter.com To: cf-talk

Interesting dir listed in error output.

2010-03-15 Thread DeMarco, Alex
This is coming from CFMX 9.. at cfsavecontent2ecfm1472308084.runPage(E:\cf9_final\cfusion\wwwroot\WEB-IN F\cftags\savecontent.cfm:11) Our CFMX 9 is a prod build, we never had this on an E:\ drive... Strange.. - Alex ~| Want

Re: Interesting dir listed in error output.

2010-03-15 Thread Dave Watts
This is coming from CFMX 9.. at cfsavecontent2ecfm1472308084.runPage(E:\cf9_final\cfusion\wwwroot\WEB-IN F\cftags\savecontent.cfm:11) Our CFMX 9 is a prod build, we never had this on an E:\ drive... This is the normal and expected behavior with errors from precompiled files from Adobe (CF

Re: 64 bit CF on 32 bit IIS

2010-03-15 Thread Jordan Michaels
To reiterate what others have said in a different way, no, you will not loose CF's 64-bit functionality. The Application Pool's settings only effect the IIS connector, which matters little. The one possible hang-up would be if the connectors were compiled for 32-bit support. If they weren't,

listgetat problem...

2010-03-15 Thread Les Irvin
Hi all - I'm trying to (unsuccessfully) import a comma delimited text file (from an MLS service) into a MySQL db and looping over the file using listgetat in this manner: ... '#listgetAt('#index#',4, ',')#', '#listgetAt('#index#',5, ',')#', '#listgetAt('#index#',6, ',')#' ... I'm suspecting

Re: listgetat problem...

2010-03-15 Thread Barney Boisvert
The CSV format is not a comma-delimited list per line. It's richer than that. So you can't just use the list functions on it, you need an actual CSV parser. One isn't hard to write (and there are several valid approaches), but the easiest course of action is to just grab one that is already

cfform validate onsubmit issue

2010-03-15 Thread Mark Atkinson
Howdy folks, Googled extensively and searched the docs - forgive me if I'm missing something. Have a cfform on a secure subdomain with its own certificate using validateat=onSubmit for several text fields, which is being skipped. It also doesn't work on the secure subdomain if the request is

Re: Fastest Hardware for ColdFusion 9?

2010-03-15 Thread Larry Lyons
Depending on how much cash you want to part with, look at a 64 node Apple X-Serve system. I experimented with this when I worked for a biotech firm - they were using it for genomics and proteomics research. This thing was scary fast - and the load it could handle was astounding.

Re: cfform validate onsubmit issue

2010-03-15 Thread Dave Watts
Googled extensively and searched the docs - forgive me if I'm missing something. Have a cfform on a secure subdomain with its own certificate using validateat=onSubmit for several text fields, which is being skipped. It also doesn't work on the secure subdomain if the request is not secure

Re: cfform validate onsubmit issue

2010-03-15 Thread Mark Atkinson
Dang! Of course! It's Monday. Created a virtual directory under the secure subdomain pointing to the local path to that directory. Many thanks. -- Mark Atkinson AOCS Web | www.aocs.org 217-693-4839 Dave Watts wrote: Googled extensively and searched the docs - forgive me if I'm missing

Re: listgetat problem...

2010-03-15 Thread rex
listGetAt() sees the , inside the double-quotes as a list item. So it sees this piece of text as two items in the text lstText: cfset lstText = this is one, this is another one / cfoutput#listLen(lstText, ,)#/cfoutput Instead of doing this via CF, try leveraging MySQL's text

Re: listgetat problem...

2010-03-15 Thread rex
this better illustrates what I meant cfset lstText = 'this is one, this is another one, this should be second item' / cfoutput#listLen(lstText, ,)#/cfoutput It will output 3 rex wrote: listGetAt() sees the , inside the double-quotes as a list item. So it sees this piece of text as

Get the UTC offset of a future date

2010-03-15 Thread Judah McAuley
I just ran into a problem in one of my apps with the daylight savings time changeover and I'm not sure about the best way to deal with it. I import appointments that are scheduled out in the future. When the appointments come in in UTC format, I need to calculate the local time for the event.

iText version in CF9

2010-03-15 Thread Craigsell
I jsut started working with iText version 5.0.1 from my CF8 8.0.0 instance. Soon we will be migrating to CF9. Does anyone know the itext version that ships with CF9 and if there are any differences with the latest version? I know the new version was refactored so that it no longer conflicts

aes--any way to encrypt a hex encoded string in CF?

2010-03-15 Thread megan cytron
I am trying to match the encryption results on a box running BBj and just can't quite get there... This is how they are encrypting: 1. AES/CFC/NoPadding 2. IV of zero () Which is no problem. When encrypting 1234567891234567, I get this result:

RE: aes--any way to encrypt a hex encoded string in CF?

2010-03-15 Thread Mark A. Kruger
You need formatBaseN( ) Hex is really just base 16 instead of base 10. So... cfscript X = 1234567891234567; X = Ucase(FormatBaseN(x,16)); X = x 10 /cfscript You get the idea -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com

Re: aes--any way to encrypt a hex encoded string in CF?

2010-03-15 Thread megan cytron
Hey Mark-- Thanks for the response. My understanding is that they are converting 1234567891234567 as a string, not as a number, so that when they encode the card number they get: 1234567891234567 -- hex: 31323334353637383931323334353637 When I encrypt 1234567891234567 using cfencrypt and hex

Re: Get the UTC offset of a future date

2010-03-15 Thread Paul Hastings
http://www.sustainablegis.com/projects/tz/testTZCFC.cfm ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

RE: aes--any way to encrypt a hex encoded string in CF?

2010-03-15 Thread Mark A. Kruger
I see what you mean... have you tried using javacast? Cast each item as a string inside a variable, then manipulate them with formatBaseN( ) and then concatenate (or whatever the order is). Make sure your are concat'ing variables not constancts Note... Cfset x = var1 var2 var3/ But... cfset

Re: how to maintain source code

2010-03-15 Thread Kevin Pepperman
Using Git, CSV or subversion is super easy with Eclipse. You can maintain a local repo that tracks the changes you do, and also allows you to synch with a remote repo when you want to push a final code change. I like Git and Github a lot since it is free and easy to collaborate with, and I

Re: aes--any way to encrypt a hex encoded string in CF?

2010-03-15 Thread denstar
On Mon, Mar 15, 2010 at 6:30 PM, megan cytron wrote: ... cfset encoding = hex cfset iv=BinaryDecode(, Hex) cfset key = ToBase64(BinaryDecode(SECRETKEYHERE, Hex)) cfset algorithm = AES/CBC/NoPadding cfset str =1234567891234567 cfset enc = Encrypt(str, key,