Re: model-glue on shared servers

2006-05-22 Thread Mike Kear
The docs for Model-Glue and for Reactor lag behind the product somewhat. It's a struggle to keep them in synch with the product because it's moving ahead so fast. I dont want to rehash the VERY LONG thread that went on the Reactor list a while back, but I'll give you a brief synopsis -

Re: model-glue on shared servers

2006-05-22 Thread dave
thanks mike, i will look over these in am. Don't worry, it WONT be running on iis, you should know that by now!! haha ~Dave the disruptor~ From: Mike Kear [EMAIL PROTECTED] Sent: Monday, May 22, 2006 3:24 AM To: CF-Talk cf-talk@houseoffusion.com

Re: model-glue on shared servers

2006-05-22 Thread Nick Tong - TalkWebSolutions.co.uk
I have a 'MGR' quick start on my site: http://wapurl.co.uk/?YORN902 On 22/05/06, dave [EMAIL PROTECTED] wrote: thanks mike, i will look over these in am. Don't worry, it WONT be running on iis, you should know that by now!! haha ~Dave the disruptor~

Re: model-glue on shared servers

2006-05-22 Thread Nick Tong - TalkWebSolutions.co.uk
I have a 'MGR' quick start on my site: http://wapurl.co.uk/?YORN902 -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk shorturls: http://wapurl.co.uk ~| Message:

Re: switch from siteObject to FCKEditor

2006-05-22 Thread Nick Tong - TalkWebSolutions.co.uk
Another one to look at is: http://tinymce.moxiecode.com/ On 21/05/06, Pete Jordan [EMAIL PROTECTED] wrote: Pete Ruckelshaus wrote: Really? Is that in the documentation somewhere, or can you provide a code sample? Also, any idea if it's possible to specify the image file upload path

Re: How to get several resultsets from SP

2006-05-22 Thread Tom Chiverton
On Friday 19 May 2006 18:00, Adrian Lynch wrote: Conditional logic might change the number. But the definition of a SP is fixed. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited

Re: reading parent form variables

2006-05-22 Thread daniel kessler
Once you have submitted to the parent page, you could then call the iframe using URL parameters that match your form fields... you submit form fields x and y to the parent page. The parent page then calls the iframe with something like: iframe src=responseframe.cfm?x=#x#y=#y#/iframe I

RE: How to get several resultsets from SP

2006-05-22 Thread Adrian Lynch
But not what it returns. The following in an SP will potentially return two or three result sets which means your proc result tags can be askew. SELECT * FROM Table1 IF @param = 1 SELECT * FROM Table2 SELECT * FROM Table3 Adrian -Original Message- From: Tom Chiverton

Re: How to get several resultsets from SP

2006-05-22 Thread Tom Chiverton
On Monday 22 May 2006 12:30, Adrian Lynch wrote: SELECT * FROM Table1 IF @param = 1 SELECT * FROM Table2 SELECT * FROM Table3 In which case 3 result sets are returned, and one of them will be null. 3 sets are always returned because that is how the SP is defined, no ? -- Tom

cfprocparam cfsqltype XML ?

2006-05-22 Thread Rich Tretola
I have a stored proc that is returning a sql 2005 xml datatype. The sql server docs say to use LONGVARCHAR as the data type but I am getting the same error whether I call the proc from a java class or a coldfusion page. Implicit conversion from data type xml to varchar is not allowed. Anyone

Re: Google Analytics?

2006-05-22 Thread Michael Dinowitz
That's the difference between marketting and what the software actually reports. 8.5 is now version 9.0 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241119 Archives:

Possible in SQL?

2006-05-22 Thread Jeremy Bunton
Hello, I have a table that looks something like this. Com1 genderfname lname 001 M Matt Smith 001 M Bill Wright 005 FKara Brown 005 M Mike White What I need

Re: Possible in SQL?

2006-05-22 Thread Jim Wright
You could do it with a subquery select * from sometable a WHERE a.gender = 'M' AND lname = (SELECT max(lname) FROM foo WHERE com1=a.com1) (of course, this assumes that lname is unique within a com1, which may not be the case...you may need to add on a identity field to make sure you only get

Re: Possible in SQL?

2006-05-22 Thread Jim Wright
fixing my query...I had used used foo as the tablename originally, and not changed it in both places... select * from sometable a WHERE a.gender = 'M' AND lname = (SELECT max(lname) FROM sometable WHERE com1=a.com1) -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257

RE: Possible in SQL?

2006-05-22 Thread Snake
I would have thought distinct would do what you want, are you sure you use dit correctly. Select distinct com1, gender, fname, lname FROM mytable WHERE gender = 'M' Group by com1, gender, fname, lname - Snake -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: 22

RE: Google Analytics?

2006-05-22 Thread Mike Klostermeyer
Since it appears many here use Google Analytics, I have a question. Does anyone use it over an SSL connection (during the checkout process of a cart, for example)? I can't figure out how to use it without throwing browser security warnings (domain name does not match, etc.). Any way around

OT: CF jobs listings?

2006-05-22 Thread Burns, John D
Ok, I know it's off topic but I figured you all would know. My company is looking to hire some new CF developers and are planning to post to the CF-Jobs list but we were wondering if anyone knows of other good places to post CF job openings. Anyone with experience or information would be extremely

Table Desing

2006-05-22 Thread Richard Dillman
I'm workin on a contact management system and im at the bit where you create the company the contact is with. Am I being too anal to ask for type of company: option value=-Select One-/option option value=DBADoing Business As/option option value=INCIncorporated/option option value=LLCLimited

RE: CF jobs listings?

2006-05-22 Thread Andy Matthews
Where in the country are you? My CFUG posts job listings, but they have to be in the Nashville area. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original

RE: CF jobs listings?

2006-05-22 Thread Dave Watts
Ok, I know it's off topic but I figured you all would know. My company is looking to hire some new CF developers and are planning to post to the CF-Jobs list but we were wondering if anyone knows of other good places to post CF job openings. Anyone with experience or information would be

RE: Google Analytics?

2006-05-22 Thread Dave Watts
Since it appears many here use Google Analytics, I have a question. Does anyone use it over an SSL connection (during the checkout process of a cart, for example)? I can't figure out how to use it without throwing browser security warnings (domain name does not match, etc.). Any way

RE: CF jobs listings?

2006-05-22 Thread Burns, John D
We are in the Southern Maryland area. About an hour and half south of DC. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 9:29 AM To: CF-Talk

re: Currency Converter

2006-05-22 Thread Michael Wolfe
Mike, I've used oanda.com for several projects. -- Mike Wolfe From: Mike | NZSolutions Ltd [EMAIL PROTECTED] Sent: Sunday, May 21, 2006 10:10 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Currency

CFC Weird 500 Error

2006-05-22 Thread Sam Farmer
Something strange has just started happening on our production server. CreateObject calls to cfc's cause CF to output this and then stop: 500 cfConventionSessionUtility2ecfc1296777452$funcSEARCHSESSIONS I can catch it using cferror and I get this stack trace: java.lang.NoClassDefFoundError:

Re: Currency Converter

2006-05-22 Thread Larry Lyons
Hi guys, I am looking for a currency converter to include on a clients site. What are people's favourites - something coldfusion orientated would be cool. Basically I just need the visitor to be able to see the displayed price (NZ Dollars) in their own currency - it does no need to alter any

Re: Currency Converter

2006-05-22 Thread Larry Lyons
Hi guys, I've generally used the currency converter web service from Xmethods.net: http://www.antiwrap.com/?1005 It works really well. hth, larry For some reason that link didn't work on the web archive, so lets try the original URL:

RE: Google Analytics?

2006-05-22 Thread Ken Ketsdever
I've tried to register a couple of times over the past few weeks currently it appears as though you need an invitation or to register for access at some later date. Does anyone have the ability to send an invitation? Ken Confidentiality Notice: This message including any attachments is for

RE: Suggestion for the mods...RE: what does application.home point to?

2006-05-22 Thread Everett, Al \(NIH/NIGMS\) [C]
I sort ALL of my mailing lists into separate folders (or, in Gmail, labels). If I didn't, my inbox would be overwhelmed by it. I usually read mailing list mail during my down times. Anything that's in my inbox was sent directly to me and I usually need to act on it relatively soon. My Outlook

Re: Google Analytics?

2006-05-22 Thread Neil Middleton
Looking around in my login of analytics it would appear you need to ask Google for one.. http://www.google.com/analytics/sign_up.html Neil On 5/22/06, Ken Ketsdever [EMAIL PROTECTED] wrote: I've tried to register a couple of times over the past few weeks currently it appears as though you

Re: Google Analytics?

2006-05-22 Thread Jeff Small
Looking around in my login of analytics it would appear you need to ask Google for one.. http://www.google.com/analytics/sign_up.html Yep, it took me about a month to get an invite. Thanks for all the words! I'm actually quite excited about it now.

RE: Google Analytics?

2006-05-22 Thread Paul
This must no longer be true; I just set up Analytics last month on our SSL site and after searching their online help for SSL and following the instructions, all is working well. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 7:37 AM To: CF-Talk

RE: HELP I'm drowning in a sea of encoding.

2006-05-22 Thread Ian Skinner
Can't think of any... you could be extra safe and be sure your database is set to the same encoding. I'll try and remember that. In this case there is no database involved; the app uses simple xml files. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA

RE: Possible in SQL?

2006-05-22 Thread Jeremy Bunton
I tried that. That will give you records with com1 showing up more than once since the names ect are not distinct sql returns all the combinations. If it would only give me one per change in com1 I would be done. Jeremy -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent:

RE: Google Analytics?

2006-05-22 Thread Dave Watts
This must no longer be true; I just set up Analytics last month on our SSL site and after searching their online help for SSL and following the instructions, all is working well. Maybe it was just a temporary glitch. The SSL certificate seems to be fine now. Dave Watts, CTO, Fig Leaf

Re: Currency Converter

2006-05-22 Thread Josh Nathanson
I'm using xe.com with good results. It's easy to use, just insert some javascript. If you've got good JS skills you can tweak it to blend in with your site. There's a free version that doesn't update the conversion rates as often, or a paid version that updates the rates daily. -- Josh

RE: Currency Converter

2006-05-22 Thread Adkins, Randy
Wish there was something like that for Mortgage rates :-) -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 12:25 PM To: CF-Talk Subject: Re: Currency Converter I'm using xe.com with good results. It's easy to use, just insert some

RE: Possible in SQL?

2006-05-22 Thread Dave Watts
I have a table that looks something like this. Com1 genderfname lname 001 M Matt Smith 001 M Bill Wright 005 FKara Brown 005 M Mike White What I

Javascript image reorder package

2006-05-22 Thread Philip K. Dunn
Anyone know of a javascript package available to re-order images on-screen? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241146 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription:

cfqueryparam BIND list limit

2006-05-22 Thread Billy Jamme
Hello All, I'm having some DB issues and I'm wondering if I could get some help with it. I'm running CFMX7, and MSSQL2k. On this specific task, I'm using the IN or NOT IN clauses in sql to grab a set of records. The problem occurs when I attempt to use cfqueryparam to fetch a 2100+ item list

RE: cfqueryparam BIND list limit

2006-05-22 Thread Everett, Al \(NIH/NIGMS\) [C]
I used to get around Oracle's 1000-item list limit by breaking up the list into an array of lists then looping over the array and putting OR between each iteration. I expect that there is a much more elegant way to do it with a temporary table. -Original Message- From: Billy Jamme

RE: Google Analytics?

2006-05-22 Thread Mike Klostermeyer
I'm still getting the security warning. Any ideas what I need to do? Mike -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 11:24 AM To: CF-Talk Subject: RE: Google Analytics? This must no longer be true; I just set up Analytics last month on

Having problem with query and multiple tables.

2006-05-22 Thread Michael Grove
I have a query calling on data in multiple tables. The database is MS Access. Here is the query that I am using SELECT p.name, p.product_id, p.content_id, p.creationdate, h.hits AS hits, h.clickthroughs AS clicks, s.pagetitle, s.parent, c.pagetitle AS category FROM Products p, Product_Hits h,

RE: Google Analytics?

2006-05-22 Thread Dave Watts
I'm still getting the security warning. Any ideas what I need to do? Use this URL for your secure pages: https://ssl.google-analytics.com/urchin.js Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our

RE: Having problem with query and multiple tables.

2006-05-22 Thread Dave Watts
I have a query calling on data in multiple tables. The database is MS Access. Here is the query that I am using SELECTp.name, p.product_id, p.content_id, p.creationdate, h.hits AS hits, h.clickthroughs AS clicks, s.pagetitle, s.parent, c.pagetitle AS category FROM Products p,

RE: Having problem with query and multiple tables.

2006-05-22 Thread WebMistress
You would have to do a left join. Now this Is untested and it's been a long time since I've written one of these but it's something like SELECT p.name, p.product_id, p.content_id, p.creationdate, h.hits AS hits, h.clickthroughs AS clicks, s.pagetitle, s.parent, c.pagetitle AS category

I think I've discovered a bug in CFMX

2006-05-22 Thread Jon Block
Reading this I know it might sound like an Apache bug, but I only get the undesired behavior when I request certain types of CFM pages. Please read and help me!. SYMPTOM - Web browser seems to lose connection with the web server when making CFM requests that take a long time (over 10

Re: MaxHeapSize + MaxPermSize

2006-05-22 Thread Dante Orlando
Thanks for all of your replies. First of all, I was really just looking for the whys rather than any particular recommendation on what values to set these params to. As far as the permanent generation being part of the heap, I have been able to verify that the permenent generation (i.e.

RE: Google Analytics?

2006-05-22 Thread Aldon
I have found Google Analytics to increase load time making my pages slower. Has anyone found a solution to this? Al -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 12:10 PM To: CF-Talk Subject: RE: Google Analytics? This must no longer be true; I just

RE: MaxHeapSize + MaxPermSize

2006-05-22 Thread Snake
I have to wonder what one does if they have a CF server that requires more than 1.8gb RAM for the JVM, say u have some big heavy site sthat do a lot of caching of big files/queries? -Original Message- From: Dante Orlando [mailto:[EMAIL PROTECTED] Sent: 22 May 2006 19:41 To: CF-Talk

RE: Server Backup Solutions

2006-05-22 Thread Adkins, Randy
I use the standard NT Backup that comes with Windows. I made sure my drive mappings were setup and then scheduled Backups from that to a tape. Now ideally would be awesome to have the auto-tape changer System. I have seen it before but the project I am on, well Lets say we do with what we have

Re: QQ: What's the least intensive way to...

2006-05-22 Thread Charlie Griefer
cfset myIP = 255.255.255.0 / cfset firstThree = listDeleteAt(myIP, listLen(myIP, '.'), '.') / On 5/22/06, Che Vilnonis [EMAIL PROTECTED] wrote: What's the least intensive way to.. get the first 3 octets of any ip address? Che Vilnonis Application Developer Advertising Systems

RE: QQ: What's the least intensive way to...

2006-05-22 Thread Che Vilnonis
Thank you! My solution was much more convuluted. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 4:13 PM To: CF-Talk Subject: Re: QQ: What's the least intensive way to... cfset myIP = 255.255.255.0 / cfset firstThree = listDeleteAt(myIP,

Re: Server Backup Solutions

2006-05-22 Thread Philip K. Dunn
For years I have been backing up to hard drives on the data server (NT/SQLS7) and then distributing those files (.bak) to other servers using scheduled ftp or PCAnywhere sessions. I maintain a 4 day rotation in different directories. I am not as diligent with transaction files only maintaining

RE: Server Backup Solutions

2006-05-22 Thread Emmet McGovern
Both http://www.acronis.com and http://www.ultrabac.com offer great products. We use both. Not sure what price range you're looking for. $699 to $999 per server is a great price to pay if you ever need to put your disaster recovery plan to work. -e -Original Message- From: Mike

Re: Google Analytics?

2006-05-22 Thread Nick Tong - TalkWebSolutions.co.uk
Mike, Did you check out my post? Aldon, . it can be slower but be sure to put the script at the end of you page - just before the /body tag. HTH On 22/05/06, Aldon [EMAIL PROTECTED] wrote: I have found Google Analytics to increase load time making my pages slower. Has anyone found a solution

Re: Server Backup Solutions

2006-05-22 Thread Jim McAtee
Rotation of backups can easily be done with Windows scripting or batch files. I do this with my personal computers at home, backing up to an NAS on my network. I use the Windows scheduler to run the backup batch file each night. The batch file fires NTBackup, setting a destination backup

RE: Server Backup Solutions

2006-05-22 Thread Rick Faircloth
Try www.2brightsparks.comSyncBackSE $20 or so...I run backup services for some of my customers to an FTP here at my studio. Works like a charm...and it's VERY inexpensive... Rick -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 4:15 PM

RE: Google Analytics?

2006-05-22 Thread Mike Klostermeyer
Found the problem. I had the wrong SSL URL. Doh! Thanks for everyone's help. Mike -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 3:36 PM To: CF-Talk Subject: Re: Google Analytics? Mike, Did you check out my post?

RE: Server Backup Solutions

2006-05-22 Thread Mike Klostermeyer
Thanks, everyone. I'll add to the list one that I just found: http://www.backup4all.com/. Seems to cover most of my needs, all for $45. I'll check this one out as well. Mike -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 4:03 PM To: CF-Talk

Re: Server Backup Solutions

2006-05-22 Thread Ken Ferguson
At my last job, we started backing up to a rotating pair of USB 2.0 external HD's. It worked perfectly. We would switch them out on Monday AM, with last weeks going off-site and the other one coming in. The backups were done with Ghost and they were so handy! We'd have one new image for every

RE: Server Backup Solutions

2006-05-22 Thread Rick Faircloth
Backup4All looks good...very similar to SyncBackSE...I'm just waiting for one of these vendors to offer block-level differential backup. Now *that* will be terrific! Rick -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 5:15 PM To: CF-Talk

RE: MaxHeapSize + MaxPermSize

2006-05-22 Thread Snake
Well I spose I should of added, on a non enterprise license then :-) Multiple instances is the method that I have used thus far. Snake -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 22 May 2006 20:29 To: CF-Talk Subject: RE: MaxHeapSize + MaxPermSize I have to

RE: Server Backup Solutions

2006-05-22 Thread Snake
I have heard a lot of people rave about backup for workgroups. Snake ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241179 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription:

Re: Announcing SeeFusion 3.3

2006-05-22 Thread Patrick Quinn
Hi Jordan. From what we know of Server JX from our discussions with New Atlanta, SeeFusion should work fine on that edition of BlueDragon. As far as we know, it will NOT work on BlueDragon Server (which apparently is built on an older version of ServletExec under the covers; one that doesn't

confused on error

2006-05-22 Thread joe velez
Hey - I am looking at this error and spinning my wheels trying to figure out WHY I'm getting it. If I add a WHERE statement to the query below it works fine, so why not a simple select * from table ?? Any ideas? I can't find any information online. Server: CFMX6.1 ACCESS DB Thanks JV

Re: confused on error

2006-05-22 Thread Charlie Griefer
is ID a numeric datatype or a string? if it's a string you'll need single quotes around '#id#' (or better yet, a cfqueryparam) On 5/22/06, joe velez [EMAIL PROTECTED] wrote: Hey - I am looking at this error and spinning my wheels trying to figure out WHY I'm getting it. If I add a WHERE

Re: confused on error

2006-05-22 Thread Joe Velez
to answer your q, ID is a # (auto inc) ... but I'm using Access database. (yea lets not get into WHY) anyways .. the error is not occuring because of the WHERE portion. that actually works perfect! however, a simple select * from TABLE statement is causing an error. Strange, huh? -

Verity issues with MX 7

2006-05-22 Thread John Crawford
My company recently upgraded a server from 6.1 to 7.0.1. After doing the upgrade we discovered that our verity functionality has broken. The indexing is taking roughly 50 times longer to complete, and once it does, it does not seem that the collections have been created (the search results

Re: confused on error

2006-05-22 Thread Charlie Griefer
ah sorry, my bad. i read your examples backwards. SQLSTATE HY109 refers to an invalid cursor. Is this just a straightforward select statement from a basic database table or is there more going on behind the scenes (like a cursor)? On 5/22/06, Joe Velez [EMAIL PROTECTED] wrote: to answer your

RE: Suggestion for the mods...RE: what does application.home point to?

2006-05-22 Thread Eric Roberts
That is how I am doing it now...it just makes it easier to have something in the subject for visual purposes. Eric -Original Message- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Monday, 22 May 2006 09:26 To: CF-Talk Subject: RE: Suggestion for the mods...RE: what

RE: confused on error

2006-05-22 Thread Dave Watts
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Record is deleted. 1 : cfquery name='get_vtwo' datasource='#dsn#' 2 : select * 3 : from RETURN_AUTHORIZATION SQLselect * from RETURN_AUTHORIZATION

RE: Javascript image reorder package

2006-05-22 Thread Eric Roberts
Try dynamicdrive.com Eric -Original Message- From: Philip K. Dunn [mailto:[EMAIL PROTECTED] Sent: Monday, 22 May 2006 12:08 To: CF-Talk Subject: Javascript image reorder package Anyone know of a javascript package available to re-order images on-screen?

Re: Suggestion for the mods...RE: what does application.home point to?

2006-05-22 Thread Charlie Griefer
but if they're all in the cf-talk folder...why the need for any additional visual cues? :) On 5/22/06, Eric Roberts [EMAIL PROTECTED] wrote: That is how I am doing it now...it just makes it easier to have something in the subject for visual purposes. Eric -Original Message- From:

Re: confused on error

2006-05-22 Thread Jim Wright
That Record is Deleted message can be an indication that you have a corrupt database. I would close all connections to the db, make a backup copy, then do a compact and repair. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257

Re: Verity issues with MX 7

2006-05-22 Thread Duncan
The verity core is different in what was shipped in 7 from the version shipped in 6. Verity version in 6.1 was about 4 I tyhink, and in MX7 the verity version is also 7. This means any collections created by your mx6.1 box wont work on 7 and will need to be recreated in the new verity format.