Re: Application.cfc racing

2006-05-22 Thread James Holmes
>From the LiveDocs (http://livedocs.macromedia.com/coldfusion/7/htmldocs/0696.htm) Use this method for application initialization code; for example, use it to set Application scope variables, to determine whether a required data source or other resource is available, or to log the application

Application.cfc racing

2006-05-22 Thread Michael Dinowitz
I'm about to do some tests on application.cfc as it deals with the onApplicationStart and onSessionStart. The question is, if the application/session does not exist, does the method 'lock' and single thread the request to it or can multiple requests cause the start methods to run if they happen

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. Hop

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: 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- >

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: 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 : > 2 : select * > 3 : from RETURN_AUTHORIZATION > > SQLselect * from RETURN_AUTHORIZATION > DATASOURCE returns_version1 >

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 d

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 you

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 retur

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? - Origi

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 ) 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 statement to 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: 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 sup

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: http://www.hous

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 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 Su

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 d

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: 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? Ald

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 To:

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 fil

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 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 t

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 Kloster

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: 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... On 5/22/06, Che Vilnonis <[EMAIL PROTECTED]> wrote: > What's the lea

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

2006-05-22 Thread Charlie Griefer
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 Incorporated > 8470C Remington Avenue > Pennsauken, NJ 08110 > p: 856.488.2211 > f: 856.488.199

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

2006-05-22 Thread Che Vilnonis
What's the least intensive way to.. get the first 3 octets of any ip address? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com

RE: Server Backup Solutions

2006-05-22 Thread Mike Klostermeyer
Thanks. Now thinking about it, an ideal solution would be able to manage, say, a weeks worth of daily backups, on a rotating basis. Any other ideas? Mike -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 2:15 PM To: CF-Talk Subject: RE: Server B

Re: MaxHeapSize + MaxPermSize

2006-05-22 Thread Douglas Knudsen
exactly what I was thinking. Add in a couple more instances and cluster them up, eh? DK On 5/22/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > I have to wonder what one does if they have a CF server that > > > requires more than 1.8gb RAM for the JVM, > > > > Multiple Instances and clustering.

RE: MaxHeapSize + MaxPermSize

2006-05-22 Thread Dave Watts
> > I have to wonder what one does if they have a CF server that > > requires more than 1.8gb RAM for the JVM, > > Multiple Instances and clustering. If you're using multiple instances, each has its own JVM and memory space. One of the reasons for using multiple instances is to bypass the JVM mem

Re: MaxHeapSize + MaxPermSize

2006-05-22 Thread Andy Allan
Multiple Instances and clustering. Like most things, when you reach a certain point, it's better to introduce more hardware than simply keep throwing memory(or cpus) at it. On 22/05/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote: > Load balancing, I imagine. :-) > > On 5/22/06, Snake <[EMAIL PROTEC

Re: MaxHeapSize + MaxPermSize

2006-05-22 Thread Dante Orlando
According to my tests, it's a 1.6GB max for a jvm process, but to answer your question, you would either need to move to Linux/Unix, or 64bit Windows. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241161 Archives: h

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 or

Re: MaxHeapSize + MaxPermSize

2006-05-22 Thread Rob Wilkerson
Load balancing, I imagine. :-) On 5/22/06, Snake <[EMAIL PROTECTED]> wrote: > 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-

OT: Server Backup Solutions

2006-05-22 Thread Mike Klostermeyer
Curious if anyone has some suggestions for server backup software. I need to backup (probably to a separate drive cage) web servers and database servers in a Microsoft environment, and looking for any input or experiences. I don't need much, but some requirements are to be able to put backup proc

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 Subj

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 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. -XX:PermS

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 s

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 FROM

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 Product

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 tr

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, C

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

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 [mailto

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

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: http://www.

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 > > > >

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 javascript

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: 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 So

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: Mon

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: 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: 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 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 yo

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 ru

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: 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: http://www.xmethods.net/ve2/ViewListing.po?key=

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 a

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: cf

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 Subject: Currency Converter Hi guys, I

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 Subj

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 wa

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

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. -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 8:19 AM To: CF-Talk Subject: OT: CF jobs listings? Ok, I know it's off topic but I figured yo

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: -Select One- Doing Business As Incorporated Limited Liability Company Limited Liability Partnership National Association Limited Partnershi

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

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 this?

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 May

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 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

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: 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: http://www.houseoffusion.com/cf_lists/threads.c

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 els

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 Ch

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 [mailto:

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: > > I implemented the url variable variety. Thanks

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 liabilit

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

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: http://www.houseoffusion.com/lists.cfm/link

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 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 Subject: Re: model-glue on sh

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 -