Re: Another Disturbing MX Error

2002-12-19 Thread Jesse Houwing
Sean A Corfield wrote: On Wednesday, Dec 18, 2002, at 12:11 US/Pacific, Mark Johnson wrote: I like the theory, but there is one part that doesn't make sense. This error continued to happen until i restarted the service and more explicitily killed jrun. There are about twenty of the errors

OT: browser stats, mozilla rising

2002-12-19 Thread Zac Spitzer
few interesting stories around the web today about mozilla's market share rising... this is the stats from heise.de a big german news site, where mozilla based browsers now accounting for 19.4% of users

CFMX / JVM

2002-12-19 Thread Robertson-Ravo, Neil (RX)
What JVM do Macromedia recommend to use for performance etc...? Is there on? What does everyone else use? (that said, I still cannot get my ColdFusion MX server to start at boot time!) ~| Archives:

RE: How to do this without the subselect?

2002-12-19 Thread stas
Break it into 2 queries. CFQUERY Name=GetWaivers1 Datasource=#DSN# Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY cfset filter = valuelist(getWaivers1,clientID) CFQUERY Name=GetWaivers

MX Support # 44972

2002-12-19 Thread Robertson-Ravo, Neil (RX)
This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a

Re: How to do this without the subselect?

2002-12-19 Thread Zac Spitzer
Rick Faircloth wrote: Hi, all. How can I get the same results as this query with using the subselect? CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) =

Re: Best Way To Integrate Separate Web Sites using CF

2002-12-19 Thread Dick Applebaum
OK, It appears that you want to just be able to access another sites database records and files rather than to make sure that the databases/files of these sites are synchronized (contain each other's data). You can do this with a web service on each site that receives a request (from

Re: Best Way To Integrate Separate Web Sites using CF

2002-12-19 Thread Jon Hall
Sounds like you are using Access...if a better db server is not in the budget, you might want to investigate MySQL. That would allow you to make remote db connections. -- jon mailto:[EMAIL PROTECTED] Thursday, December 19, 2002, 1:15:56 AM, you wrote: C The databases will be on separate

RE: cferror

2002-12-19 Thread Tim Laureska
Rick... sorry I didn't respond sooner about your initial blank screen .. I think that was the same problemquestion -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 2:04 AM To: CF-Talk Subject: RE: cferror Thanks for the in-depth

RE: MX Support # 44972

2002-12-19 Thread John Wilker
I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless

RE: MX Support # 44972

2002-12-19 Thread Robertson-Ravo, Neil (RX)
Yep, I dont think its 100% across the board, buts obviously been flagged as an issue : I am experiencing the problem on XP Pro at the momemt. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 12:10 To: CF-Talk Subject: RE: MX Support # 44972 I have

Semi-OT: NASD Tech Regulations...

2002-12-19 Thread Andrew Golden
I have a possible job coming up to replace a clients god-forsaken Goldmine system. They are concerned about the NASD regulations and claim that Goldmine is a NASD approved software package. I have searched and come up empty handed and they didn't seem too sure of what regulations/compliance

RE: MX Support # 44972

2002-12-19 Thread Tony Weeg
no problems whatsoever, windowsXP Pro, IIS5, CFMX, reboots restarts, no matter what, 2 servers and 3 dev machines, all work fine and the same, updater 2. ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce

RE: OT: AOL?

2002-12-19 Thread Kris Pilles
How can I test to ensure that my RDNS is working??? Do I have to have an entry for every domain in reverse DNS??? -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:18 AM To: CF-Talk Subject: RE: OT: AOL? AOL has their own internal

Re: MX Support # 44972

2002-12-19 Thread James Blaha
Ola All: There is a know bug with this and a work around configuration, search the Macromedia Online Forums it was posted about 4 months ago. If you cant find it email me personally I'll see if I can dig it up. Regards, James Blaha Robertson-Ravo, Neil (RX) wrote: Yep, I dont think its 100%

RE: MX Support # 44972

2002-12-19 Thread Robertson-Ravo, Neil (RX)
Yep, as I said its obvisously not 100% across the board, but it is severe enough to be flagged to be fixed/researched. One question : Are your MX installs all on C:\ ? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 13:58 To: CF-Talk Subject: RE: MX

Page Breaks for Printing

2002-12-19 Thread Chad
Has anyone figured out how to make page breaks for printing? I.E. have the user click one button to print all of the new orders. Each order on a separate piece of 8.5x11 paper. Javascript? Generate a PDF? Thanks! ~| Archives:

RE: MX Support # 44972

2002-12-19 Thread Robertson-Ravo, Neil (RX)
Post it here, this is where it would benefit. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:03 To: CF-Talk Subject: Re: MX Support # 44972 Ola All: There is a know bug with this and a work around configuration, search the Macromedia Online

RE: Page Breaks for Printing

2002-12-19 Thread Timothy Heald
CSS. Think it may be IE only. Look at these properties: page-break-after page-break-before page-break-inside You can then set up divs or p blocks that will throw a page break right where you want it. We did this with some success for printing out course certificates and stuff before. Tim

RE: Page Breaks for Printing

2002-12-19 Thread Jason Lees (National Express)
We use page breaks, and its a simple tag extention of the classic paragraph Tag p STYLE=page-break-before: always The Complication is deciding on the location to place the Tag. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Chad

Re: Page Breaks for Printing

2002-12-19 Thread Pete Ruckelshaus
CSS holds the answer. style type=text/css BR.pageEnd{page-break-after: always;} /style . . . This line should be above the break br class=pageEnd This line should be after the page break. This only works in CSS2 compliant browsers. Hope this helps, Pete - Original Message -

RE: Page Breaks for Printing

2002-12-19 Thread Chad
Oh cool.. thanks... I have control of what browser the user has so this should work! -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:08 AM To: CF-Talk Subject: RE: Page Breaks for Printing CSS. Think it may be IE only. Look

RE: MX Support # 44972

2002-12-19 Thread Tony Weeg
none of my mx installs are on c:\ they are all on other drives, I like to keep c:\ for the OS and let all apps/servers/programs run on d:\ e:\ etc... ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce

RE: MX Support # 44972

2002-12-19 Thread Christine Lawson
Hi Neil, It happens on my machine. I suspect it's been something that occurs with those of us who have done multiple installs - I could be wrong but I know you and I have! I posted a workaround that I'm using to the list a while ago: Set the cfmx service to be dependent on another service, so

Re: Page Breaks for Printing

2002-12-19 Thread Jeffry Houser
This might be useful. http://www.cfconf.org/cfun-02/talks/DynamicallyGeneratingPDF_files/sld003.cfm Generating PDFs is also a valid option. I've heard that giving the HTML file with a .doc extension instead of html will open it in word, which will render the HTML as a document with page

Requirements gathering for the full lifecycle development process

2002-12-19 Thread Timothy Heald
Hi, Wondering if anyone has any good resources for following the full lifecycle development process? Documents, forms things of that nature. I usually either fly by the seat of my pants, or follow FLiP procedures, but now that I am at State I am required to provide far more

RE: How to do this without the subselect?

2002-12-19 Thread Rick Faircloth
Hi, Zac. I played around a bit with the left outer join before mailing to the list, but couldn't work out the syntax for this query. In the original message I did leave out a line which complicates the query. The original query with the subselect looked like the one below. The part about

RE: MX Support # 44972

2002-12-19 Thread Robertson-Ravo, Neil (RX)
:-) wahoo, I will have a look -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:16 To: CF-Talk Subject: RE: MX Support # 44972 Hi Neil, It happens on my machine. I suspect it's been something that occurs with those of us who have done

Re: Page Breaks for Printing

2002-12-19 Thread Jochem van Dieten
Quoting Chad [EMAIL PROTECTED]: Has anyone figured out how to make page breaks for printing? http://www.w3.org/TR/REC-CSS2/page.html Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: How to do this without the subselect?

2002-12-19 Thread Jochem van Dieten
Quoting Rick Faircloth [EMAIL PROTECTED]: Since the where statement is taken by the #MultipleWaivers... line, it doesn't leave room for another where statement such as where UW.ClientID is NULL... Shouldn't it be RW.ClientID IS NULL. Jochem

Updaters...Culmulitive?

2002-12-19 Thread Robertson-Ravo, Neil (RX)
Are they? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list

RE: OT: AOL?

2002-12-19 Thread Len Conrad
How can I test to ensure that my RDNS is working??? dig -x ip.ad.re.ss dig for win32 can be had at ftp.isc.org. or free registration to get to this page: http://preview.samspade.org/t/ or: http://www.dnsstuff.com/ Do I have to have an entry for every domain in reverse DNS??? The critical

Re: Updaters...Culmulitive?

2002-12-19 Thread Jochem van Dieten
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: Are they? Release notes :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

Re: Updaters...Culmulitive?

2002-12-19 Thread Stephen Moretti
- Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 2:26 PM Subject: Updaters...Culmulitive? Are they? Yes. ~| Archives:

Re: Please help me achieve this with CF and Javascrip please

2002-12-19 Thread Ian Vaughan
Hi Neil I e-mailed a question to you at the start of December. What I was and still am trying to achieve was creating related selects generated from one database table and you provided me with some code. I am getting somewhere with this now and there is only one small part that needs to be

RE: Updaters...Culmulitive?

2002-12-19 Thread Robertson-Ravo, Neil (RX)
what?! and read something without just clicking OK I think not my man... -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:37 To: CF-Talk Subject: Re: Updaters...Culmulitive? Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: Are

RE: Please help me achieve this with CF and Javascrip please

2002-12-19 Thread Robertson-Ravo, Neil (RX)
which Neil?! -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:42 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Hi Neil I e-mailed a question to you at the start of December. What I was and still am trying to

Re: Please help me achieve this with CF and Javascrip please

2002-12-19 Thread Ian Vaughan
Sorry guys Ignore that last post.. sent it to the wrong address ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4

Re: MX Support # 44972

2002-12-19 Thread James Blaha
All: Permanent fix would be to setup CFMX as a dependency on your web server service. I think someone just posting on this in regards to IIS. MX was such a headache we decided to stick with 5 for our production environment there are way to many little bugs out there in MX. Plus there are

RE: Please help me achieve this with CF and Javascrip please

2002-12-19 Thread Ben Doom
Without digging too deeply, I notice you refer to ChapterArray#category# and later ChapterArray#catno# -- I'm betting that the category and catno aren't the same for a given row of your query, else you wouldn't have both columns. I bet that's giving you your error -- or at least would cause

RE: Please help me achieve this with CF and Javascrip please

2002-12-19 Thread Kevin Gilchrist
Do whichever Neil a favor and send the generated page source, makes it easier to debug dynamically generated JavaScript. ;-) -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:47 AM To: CF-Talk Subject: Re: Please help me achieve this with

Re: Please help me achieve this with CF and Javascrip please

2002-12-19 Thread Stephen Moretti
Ian, Did you have a look at the twoselectsrelated custom tag? It might be a little out of date and may need tidying up a little, but that will do exactly what you're attempting. Hope this helps Regards Stephen - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL

Re: CFMX / JVM

2002-12-19 Thread Samuel R. Neff
I don't think there is an official recommendation. I believe the IBM one is bundled with CFMX and many have reported problems with CFHTTP fixed only by installing a new JVM--the SUN one in particular. I've read reports that the BEA JVM, JRockit, is a lot faster than IBM SUN JVM. Also, CFMX

Re: MX Support # 44972

2002-12-19 Thread James Blaha
Christine, I believe this is an internal JRUN issue with the service startup. Macromedia told be at one time months back to just not log into the server right away upon reboot that fixed the issue about 40% of the time. I personally removed all registry keys and even reformatted a server I

RE: cferror

2002-12-19 Thread Rick Faircloth
No problem, Tim. Sometimes it's hard to keep up with these mailing list conversations! Thanks for your help! Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 6:27 AM To: CF-Talk Subject: RE: cferror Rick... sorry I didn't

RE: How to do this without the subselect?

2002-12-19 Thread Rick Faircloth
Hi, Jochem. Shouldn't it be RW.ClientID IS NULL Now, that's a good question. I've always used subselects to get around having to spend time with those unfriendly (at least to me!) joins. I don't know enough about the fine points of joinery to answer that. Suggestions on how to setup the code

MX and Apache 2.0.43

2002-12-19 Thread Haggerty, Mike
I have installed updater 2 and am trying to get MX to work with Apache 2.0.43 on a Win2K box with no success. I don't have the error message in front of me, something about requiring #some long number# and having #some long number#, please contact the vendor for the appropriate version. Anyone

RE: How to do this without the subselect?

2002-12-19 Thread Jochem van Dieten
Quoting Rick Faircloth [EMAIL PROTECTED]: Now, that's a good question. I've always used subselects to get around having to spend time with those unfriendly (at least to me!) joins. Then maybe MySQL isn't the database for you :) Select UW.UtilityWaiverID from

Re: How to do this without the subselect?

2002-12-19 Thread Stephen Moretti
Quoting Rick Faircloth [EMAIL PROTECTED]: Since the where statement is taken by the #MultipleWaivers... line, it doesn't leave room for another where statement such as where UW.ClientID is NULL... Shouldn't it be RW.ClientID IS NULL. You're probably right Two possibles...

IIS or CFMX

2002-12-19 Thread Steve
Which is preferable to use with Coldfusion when running on Windoze box? I have ColdFusion MX installed as standalone, but judging from some comments I've seen over the last few days, others are using IIS to serve the pages. ~|

Re: IIS or CFMX

2002-12-19 Thread James Blaha
Steve, If your going to run MX, IIS would be your best bet with all the bugs it has Macromedia seems to be catering to IIS fixes first. Are you talking production or test? If your testing and its your local machine we run a CF5 shop but we test for MX so I run IIS locally for CF5 and use the

RE: Updaters...Culmulitive?

2002-12-19 Thread Aaron Johnson
what?! and read something without just clicking OK I think not my man... -- Yeah... actually just trying reading them online: http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx_updater.html AJ -- Aaron Johnson http://cephas.net/blog/ [EMAIL PROTECTED]

RE: How can I modify this query so mySQL will be happy?

2002-12-19 Thread Matt Robertson
Yes, I didn't figure DayName() would do much good without some re-coding. Good that you found DayofMonth(). Didn't know about that one. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

RE: How can I modify this query so mySQL will be happy?

2002-12-19 Thread S . Isaac Dealey
There's also DateFormat(mydate,d) which returns the same value, but DayOfMonth() makes a lot more sense when you're reading someone else's code. ;) Yes, I didn't figure DayName() would do much good without some re-coding. Good that you found DayofMonth(). Didn't know about that one.

Re: IIS or CFMX

2002-12-19 Thread Stephen Moretti
Which is preferable to use with Coldfusion when running on Windoze box? I have ColdFusion MX installed as standalone, but judging from some comments I've seen over the last few days, others are using IIS to serve the pages. I believe the notes say somewhere that the web server that comes as a

Is there a Better Way to do this?

2002-12-19 Thread Kelly Matthews
Ok here is what i am doing and I am just trying to find out if 1. there is a better way and 2. if it can be done on the SQL side (as a stored proc) instaed of the CF side. Just not all that familiar with looping outside of CF. ANyway I have one table that is a dictionary with about 1500 words.

Re: Setting the focus to form select box item.

2002-12-19 Thread Scott Brady
SelectedIndex is a read-only property in all browsers except Navigator 3 (O'Reilly's JavaScript: The Definitive Guide). Yeah, well that's what I get for writing out the code without testing it . . . . Just change that line to: form.mySelect[0].selected = true; // Select the first index

Re: How can I modify this query so mySQL will be happy?

2002-12-19 Thread Jochem van Dieten
S. Isaac Dealey wrote: There's also DateFormat(mydate,d) which returns the same value, but DayOfMonth() makes a lot more sense when you're reading someone else's code. There is also an SQL standard EXTRACT function, that will work in other SQL compliant databases. Unless of course you prefer

Re: IIS or CFMX

2002-12-19 Thread Steve
On 12/19/2002 11:35 AM, Stephen Moretti pounded the keyboard with stubby fingers to type: I believe the notes say somewhere that the web server that comes as a part of JRun and used for the standalone version of CFMX is not production strength. Ah ok then. Nothing wrong with using the JRun

RE: How to do this without the subselect?

2002-12-19 Thread Rick Faircloth
These two didn't work out, Stephen. Looks like Jochem's solution did it. I think the two solutions you suggested didn't work because they both required that the RentalWaiverDate's had to match the Form dates. Because the only hits in the query would be those that did have matching RentalWaiver

RE: How to do this without the subselect?

2002-12-19 Thread Rick Faircloth
Quoting Jochem.. Then maybe MySQL isn't the database for you :) You may be right...perhaps I should got back to Access... at least it was *advanced* enough to handle sub-selects... :o) Thanks for your help! You can pick up your tickets for your Hawaiian cruise at the front desk! Rick

RE: How to do this without the subselect?

2002-12-19 Thread Rick Faircloth
Still don't know why Stas' idea didn't work with the two queries and a valuelist. Ideas? Kept getting the error that CF couldn't define ClientID in the cfset statement... Rick CFQUERY Name=GetWaivers1 Datasource=#DSN# Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) =

Re: How can I modify this query so mySQL will be happy?

2002-12-19 Thread S . Isaac Dealey
S. Isaac Dealey wrote: There's also DateFormat(mydate,d) which returns the same value, but DayOfMonth() makes a lot more sense when you're reading someone else's code. There is also an SQL standard EXTRACT function, that will work in other SQL compliant databases. Unless of course you

CFEXECUTE aborting on Solaris

2002-12-19 Thread Cathy Taylor
We have a really odd problem I hope somebody else has come across (and solved!). One of our applications allows users to upload a zip file and then does a CFEXECUTE to run the /usr/bin/unzip function. After a while it just stops working with the following error: The process /usr/bin/unzip

RE: Is there a Better Way to do this?

2002-12-19 Thread Ben Doom
I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. --Ben Doom Programmer

Re: How to do this without the subselect?

2002-12-19 Thread Stephen Moretti
These two didn't work out, Stephen. Never mind Looks like Jochem's solution did it. My first one should have been the same as Jochem's just wasn't paying attention and stuck the RW date checks in the wrong place... :o/ I think the two solutions you suggested didn't work because they

RE: CFEXECUTE aborting on Solaris

2002-12-19 Thread Ryan Farrell
We called Macromedia on this one back when we had a support plan. The official fix is to restart the server when you notice the problem. Gah! Ryan -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:02 AM To: CF-Talk Subject: CFEXECUTE

RE: MX and Apache 2.0.43

2002-12-19 Thread Dave Watts
I have installed updater 2 and am trying to get MX to work with Apache 2.0.43 on a Win2K box with no success. I don't have the error message in front of me, something about requiring #some long number# and having #some long number#, please contact the vendor for the appropriate version.

RE: Is there a Better Way to do this?

2002-12-19 Thread Tony Weeg
select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like '%#word#%') can be done like this, without the () around the %#word#% part ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc.

RE: Is there a Better Way to do this?

2002-12-19 Thread Tony Weeg
typo, without the ) at the very end. ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL

RE: Is there a Better Way to do this?

2002-12-19 Thread S . Isaac Dealey
I did this for an FAQ not long ago... something like this worked for me select dictionary.word from dictionary inner join dreams on dreams.dream like '%' + dictionary.word + '%' order by dictionary.word In the case of my faq the user was entering another question and the text of the question was

RE: Is there a Better Way to do this?

2002-12-19 Thread Ben Doom
If you pound the word like that, won't you get whatever is stored in a cf variable named 'word' instead of the contents of the word column from the outer select? Or am I missing something? --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From:

RE: How to do this without the subselect?

2002-12-19 Thread Rick Faircloth
~lol~ yeah that's it Of course that makes the rest of us that didn't quite get it right dense too... ;o) No, the difference is, you hadn't already spent half a day and night trying to figure out how to code the query! I had! :o) Rick -Original Message- From: Stephen Moretti

CFMX App Server Failing?

2002-12-19 Thread Jeff D. Chastain
I have a copy of CFMX Pro installed on my laptop (Win2K Pro). It is setup to utilize IIS if that matters. Whenever I boot my laptop however, the App Server fails. The error in the event log is that the CFMX App Server service terminated with service specific error 2. Anybody got any idea what

RE: Is there a Better Way to do this?

2002-12-19 Thread Ben Doom
Aye, that's what I was trying to think of. Too much blood in my caffiene stream this morning. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 12:28 PM : To:

RE: How to do this without the subselect?

2002-12-19 Thread Rick Faircloth
Hey, Jochem... Since you've got a good grip on how the joins work, would my explanation for my notes concerning why this query works be accurate? Notes: This query works to select UtilityWaivers that were issued within a given month and which were issued without an accompanying RentalWaiver.

Re: Is there a Better Way to do this?

2002-12-19 Thread Stephen Moretti
I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT

RE: Is there a Better Way to do this?

2002-12-19 Thread S . Isaac Dealey
Nasty thing that blood... I say who needs it. ;) Aye, that's what I was trying to think of. Too much blood in my caffiene stream this morning. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: S. Isaac Dealey [mailto:[EMAIL

Re: Is there a Better Way to do this?

2002-12-19 Thread S . Isaac Dealey
I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT

Re: CFMX App Server Failing?

2002-12-19 Thread Stephen Moretti
Jeff, I have a copy of CFMX Pro installed on my laptop (Win2K Pro). It is setup to utilize IIS if that matters. Whenever I boot my laptop however, the App Server fails. The error in the event log is that the CFMX App Server service terminated with service specific error 2. Anybody got

Re: Is there a Better Way to do this?

2002-12-19 Thread Stephen Moretti
Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... ~sigh~ Right! that does it You are of course correct Too much darkness outside now...

RE: CFMX App Server Failing?

2002-12-19 Thread Jeff D. Chastain
Stephen, I checked the logs again and the message is exactly as I stated, no file name included. If I restart the service a couple of times and maybe do a restart on the laptop, it will eventually work. This seems to only occur after a cold boot, not after I just do a restart. Thanks -- Jeff

Simplest translation of simple XML file to CF5 structure?

2002-12-19 Thread Jon Block
Lets pretend that abc.xml contains... ?xml version=1.0? book authorjon/author titlea question/title /book What is the most easy way to magically turn that into a coldfusion structure where I can do #book.author# and #book.title#? There has GOT to be a CF5 xmlParse() UDF out there

Re: Is there a Better Way to do this?

2002-12-19 Thread Kelly Matthews
No you were correct I only want to pull the dictionary words that were found in the dream. The code you gave me worked great the only issue i see now for example let's say the word is FEEL then it pulls EEL out of the dictionary. IS there a way to avoid that? I'm not a SQL wizard and am

Self Join Question

2002-12-19 Thread Les Mizzell
Almost got a self join working the way I want, but not quite... I've got a table of Office Branches. Some of them are MAIN BRANCHES (value main under sub_branch in table). Others are SUB BRANCHES and would have the branch_ID of the main branch listed in the sub_branch cell. So, I need a self

RE: Is there a Better Way to do this?

2002-12-19 Thread webguy
Quick guess, change like ('%' + word + '%') to like (word) ??/ WG -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 17:52 To: CF-Talk Subject: Re: Is there a Better Way to do this? No you were correct I only want to pull the dictionary

Re: CFMX / JVM

2002-12-19 Thread Sean A Corfield
On Thursday, Dec 19, 2002, at 06:53 US/Pacific, Samuel R. Neff wrote: I don't think there is an official recommendation. I think you're right because the question has been asked and gone unanswered here before. I believe the IBM one is bundled with CFMX and many have reported problems with

Re: MX and Apache 2.0.43

2002-12-19 Thread Sean A Corfield
On Thursday, Dec 19, 2002, at 07:08 US/Pacific, Haggerty, Mike wrote: I have installed updater 2 and am trying to get MX to work with Apache 2.0.43 on a Win2K box with no success. I don't have the error message in front of me, something about requiring #some long number# and having #some

Re: Is there a Better Way to do this?

2002-12-19 Thread S . Isaac Dealey
Yea, there's a couple things you can do ... Make sure that every word in the dream is bounded by spaces You can do this with a couple regular expressions like this: cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^ [:alpha:]]),\1 \2,ALL) cfset dreamtext = REReplace(dreamtext,([^

ODBC Data Source [Merant dBase/FoxPro Driver]

2002-12-19 Thread Bruce, Rodney S HQISEC/Veridian IT Services
hi all Does anyone have any experience with ODBC Data Source [Merant dBase/FoxPro Driver] in CF admin? I haven't used it before and cant seem to find any examples. I have tried the simple queries: cfquery name=Qtransferrequests datasource=temp1610 dbtype=ODBC SELECT STATION, ORG_ELMT

Re: Is there a Better Way to do this?

2002-12-19 Thread Kelly Matthews
awesome thanks :))) From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Is there a Better Way to do this? Date: Thu, 19 Dec 2002 13:26:40 -0500 Yea, there's a couple things you can do ... Make sure that every word in the dream is

RE: Is there a Better Way to do this?

2002-12-19 Thread S . Isaac Dealey
Quick guess, change like ('%' + word + '%') to like (word) At least in sql server afaik ( not sure about other db's, but I suspect it's fairly standard ) using like word is the same as using = word because the db is looking for a wildcard % or _ ( single character wildcard in sql server

Re: Is there a Better Way to do this?

2002-12-19 Thread S . Isaac Dealey
That's what we're here for. :) awesome thanks :))) From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Is there a Better Way to do this? Date: Thu, 19 Dec 2002 13:26:40 -0500 Yea, there's a couple things you can do ... Make sure

CFMail - Multiple Attachments

2002-12-19 Thread Casey C Cook
Hello, I would think this is an easy question, but I have not easily found the answer yet. Is it possible to send multiple attachments out with cfmail, and can the number of attachments and attachment names be dynamically determined based on user selections within the application. Basically Im

Re: CFMail - Multiple Attachments

2002-12-19 Thread S . Isaac Dealey
Hello, I would think this is an easy question, but I have not easily found the answer yet. Is it possible to send multiple attachments out with cfmail, and can the number of attachments and attachment names be dynamically determined based on user selections within the application.

Re: CFMail - Multiple Attachments

2002-12-19 Thread Casey C Cook
Perfect. Thanks a bunch Isaac. Just needed a confirmation before providing an estimate on amount of time needed to build the functionality. CC

Re: CFMail - Multiple Attachments

2002-12-19 Thread Pablo Varando
Here's a tutorial on this also: http://tutorial27.easycfm.com/ Pablo I would think this is an easy question, but I have not easily found the answer yet. Is it possible to send multiple attachments out with cfmail, and can the number of attachments and attachment names be

ColdFusion and DDE

2002-12-19 Thread Jacob
Is it possible to use DDE links in ColdFusion? Jacob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ:

Re: CFMail - Multiple Attachments

2002-12-19 Thread S . Isaac Dealey
Welcome. :) Perfect. Thanks a bunch Isaac. Just needed a confirmation before providing an estimate on amount of time needed to build the functionality. CC S. Isaac Dealey infoTo: CF-Talk [EMAIL PROTECTED]

RE: ColdFusion and DDE

2002-12-19 Thread Ben Doom
Um... Are you referring to Windows Drag'n'drop? If so, that's going to be browser-dependent unless you are talking about CFStudio. And, to be honest, I can't really think of anything you could dnd to a CF page except file uploads. If that's not what you're talking about then I'm lost anyway.

  1   2   >