Stored Proc wizard

2002-07-26 Thread Phillip B
I think I saw something recently about a stored procedure wizard. I look in the archives but I didn't see what I was looking for. Some one posted a link to the site it could be down loaded from. Anyone know what I am talking about and can point me in the right direction? Thank you. Thank you

CFX_Image docs

2002-07-26 Thread Bryan Stevenson
Hey All, Does anybody have the docs for CFX_Image (current version 1.4.5 or older)?? TIA Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia

Re: CFMX Taking all CPU Resources?

2002-07-26 Thread Jesse Houwing
Joe Eugene wrote: The results were for TESTS THAT WERE RAN 15-18 HOURS AT A TIME.. So u know the pages have already been compiled and loaded. With or without trusted cache? Jesse __ Signup for the Fusion Authority news

Re: CFMX Taking all CPU Resources?

2002-07-26 Thread Jesse Houwing
Brook Davies wrote: Yikes. Is this on the first past or after the pages are compiled? I will ask again, does any one have a script to pre compile all pages within a directory? This would be a nice option to have in the administrator or at least a executable provided by MM. This came up

Re: CFMX Taking all CPU Resources?

2002-07-26 Thread Joe Eugene
The results were for TESTS THAT WERE RAN 15-18 HOURS AT A TIME.. So u know the pages have already been compiled and loaded. Joe - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 4:15 PM Subject: Re: CFMX Taking all CPU

RE: Setting and evaluating session variables

2002-07-26 Thread Cornillon, Matthieu
Gotcha. I was worried that I was off my head for a second. Anyhow, I wanted to second your advice to Robert that he use CFLOCK, along with an inclusion of some references that he might find helpful on the topic. After reading these, I found that I had a pretty decent idea of how to go ahead:

RE: CFPROCPARAM behavior change with MX+Oracle?

2002-07-26 Thread James Ang
Here's my $0.02.. I had to debug an app that uses MS SQL Server stored procs via cfstoredproc in many places. It was working in development testing, and started failing after deployment. Named notation with optional/default values for certain parameters was used. The app actually works with

Re: Table Locking Problems

2002-07-26 Thread I-Lin Kuo
Here's a good summary of SQL Server Locking http://www.swynk.com/friends/achigrik/SQL70Locks.asp --- Colin Murphy [EMAIL PROTECTED] wrote: Thanks for your help. I think I will dig out the SQL books and write a couple of stored procedures todo this. Colin = I-Lin Kuo Macromedia CF5

Re: CFMX Taking all CPU Resources?

2002-07-26 Thread Brook Davies
Yikes. Is this on the first past or after the pages are compiled? I will ask again, does any one have a script to pre compile all pages within a directory? This would be a nice option to have in the administrator or at least a executable provided by MM. At 03:46 PM 26/07/02 -0400, you

RE: site wide missing template handler not working in MX

2002-07-26 Thread Mike Byers
I had a problem with ours that I resolved. I will tell you how it is arranged and what I did. You can decide it is similar to your problem. We had an absolute path in cf5 that went to another drive letter and path for our file. In MX it uses relative paths only. It also has to be inside of

RE: record linking prob

2002-07-26 Thread Christopher Olive
it's because the CFOUTPUT doesn't have a queryname attached. any references to searchresults.fieldname will refer to the first record returned from that query (as correctly mentioned previously be several responses.) chris -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Douglas Brown
I suppose that is why I have not changed over, some of the things I see on the list is having to modify xml files to get things to work right and stuff and this was never an issue with CF thru 5. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Paris Lundis [EMAIL

RE: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Paris Lundis
Well the myths are fairly valid and speed of Java still if improved can't be that wonderful.. ideally, though it is heading in the better direction due to intelligence and not just faster processors... I will leave that to the code gods to figure... I haven't touched MX yet CF succeeded on

Re: Setting and evaluating session variables

2002-07-26 Thread Douglas Brown
P.S You also need to use locks on all your session varsJust to be on the safe side, and adhere to best coding practices etc...If you are not already doing so. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk

RE: DWMX is breaking my code HELP!HELP?

2002-07-26 Thread Mike Byers
I would like to know why Macromedia felt that a product like DWMX that changes code in simple operations such as these is superior to a product such as CF Studio which never did. I opened a file in DWMX and it changed the code. I opened it in CF Studio 5 and it changed nothing. WHY? Now I

RE: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Jesse Noller
Actually I would be interested to hear what the problems you have with cfhttp are. (it was prolly already sent ot the list, yes, but I tend to skim threads) Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Jon Hall

RE: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Dave Watts
If you're able to rewrite a little code, you might just use a Java alternative to CFHTTP instead; try the Jakarta io JSP tag library: http://jakarta.apache.org/taglibs/doc/io-doc/intro.html For everybody that is hosted on a shared host this is not an option, for them cfhttp just

RE: ARGH! CFMX is weird!

2002-07-26 Thread Christine Lawson
Brook, I was out of the office and in some meetings today and just saw some of your posts. Would it be possible for you to please send an update as to what point you're at now with your upgrade (what's working what's not). I see you posted about IIS too so I just wanted to see where exactly

Re: record linking prob

2002-07-26 Thread Douglas Brown
can we see the query please? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Doherty,Sean [NCR] [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 10:34 AM Subject: record linking prob Hey I am a newbie here and am having abit of troubles

Re: DWMX is breaking my code HELP!HELP?

2002-07-26 Thread S . Isaac Dealey
Try this as a pattern expression -- search before you replace to be sure and check all the hits: mmTranslatedValueOutline[[:alpha:]]*=[^]+? and replace it with nothing... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046

RE: looping over lists and queries in cfscript

2002-07-26 Thread jt
in CFMX can you use this syntax: Queryname.Record[i]? I have tried it and it gives me errors. (Of course, I am replacing queryname with a valid name of a query). Any ideas? -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 11:19 AM To:

RE: record linking prob

2002-07-26 Thread Doherty,Sean [NCR]
i got it to work ... i just used dreamweaver |-Original Message- |From: Christopher Olive [mailto:[EMAIL PROTECTED]] |Sent: Friday, July 26, 2002 2:01 PM |To: CF-Talk |Subject: RE: record linking prob | | |could you post the remaining code around it? i'm assuming |that you're using

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Jochem van Dieten
Dave Watts wrote: If you're able to rewrite a little code, you might just use a Java alternative to CFHTTP instead; try the Jakarta io JSP tag library: http://jakarta.apache.org/taglibs/doc/io-doc/intro.html For everybody that is hosted on a shared host this is not an option, for them

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Thane Sherrington
At 12:19 PM 7/26/02 -0700, Brook Davies wrote: cfhttp is a pos? Whats a pos? Piece of Shit. As opposed to poj (Piece Of Junk) which isn't as bad. T __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:

RE: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Van Vliet, Scott
FYI: Piece of S**t -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Brook Davies

Re: DWMX is breaking my code HELP!HELP?

2002-07-26 Thread Thane Sherrington
At 12:20 PM 7/26/02 -0700, Brook Davies wrote: Can anyone help me with, I'm totally screwed right now. Any regex wizards out there who wouldn't mind suggesting a way to get rid of all instances of the code DWMX is embedding in ALL of my tags? Please see below. Are you doing some kind of cut and

Re: Unique Identifier Field for CFMX

2002-07-26 Thread todd
Shahzad Butt(?!), Did you do what I suggested? cfdump var=#getUser# and take a look at what CFMX is actually returning! ~Todd On Fri, 26 Jul 2002, Shahzad.Butt wrote: Hi I've just migrated my code to CFMX Server. For some reason its giving error when I am trying to use

Unique Identifier Field for CFMX

2002-07-26 Thread Shahzad.Butt
Hi I've just migrated my code to CFMX Server. For some reason its giving error when I am trying to use Variable(PK_User_ID) From Query(GetUser). Only problem is that PK_User_ID is Uniqueidentifier. I mean in same Query if I use CFOUTPUT#GetUser.FirstName#/CFOUTPUT it does work but

Re: DWMX is breaking my code HELP!HELP?

2002-07-26 Thread Brook Davies
Can anyone help me with, I'm totally screwed right now. Any regex wizards out there who wouldn't mind suggesting a way to get rid of all instances of the code DWMX is embedding in ALL of my tags? Please see below. At 11:10 AM 26/07/02 -0700, you wrote: I just installed DWMX and setup a few

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Brook Davies
cfhttp is a pos? Whats a pos? At 02:51 PM 26/07/02 -0400, you wrote: In two of my major apps that I've been able to test, both have seen about a 100% increase in page execution with a single user. Even with debugging on. I'm quite happy with the speed. My main beef with MX is the broken COM

Workaround to CFHTTP GET with Cookie

2002-07-26 Thread Anthony Wenzel
There have been a number of posts about the problems with the CFHTTP tag, specifically regarding the inability to send cookies with an HTTP GET. Due to simplistic text nature of the HTTP protocol, there's a workaround. Since the way to send Cookies in a GET is by simply sending another line of

RE: OT JS Question

2002-07-26 Thread Van Vliet, Scott
Two things: 1) Use window.opener instead of just opener. Also make sure that the parent window that opened this child window is still opened (otherwise, it will not be defined. 2) name is a property of the form object, so if you are trying to set the value of a form field called name, it might

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Howie Hamlin
pos = piece of expletive deleted - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 3:19 PM Subject: Re: It's official: CFMX is 10% faster than CF5 cfhttp is a pos? Whats a pos?

Re: OT JS Question

2002-07-26 Thread Marlon Moyer
Have you tried self.opener Kris Pilles wrote: Any idea why this isn't working??? Tells me opener.document is not defined function setForm() { opener.document.Form1.name.value = document.name2.employees.value; self.close(); return false; } //--/script

Re: record linking prob

2002-07-26 Thread Jerry Johnson
What type of loop are you running to output each record of the query? Jerry Johnson [EMAIL PROTECTED] 07/26/02 01:56PM can we see the query please? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Doherty,Sean [NCR] [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED]

RE: record linking prob

2002-07-26 Thread Doherty,Sean [NCR]
here is the whole file ... not sure exactly what you want ... still learning here =) .. i need to sit down and go through it to see why it now works cfset CurrentPage=GetFileFromPath(GetTemplatePath()) cfparam name=PageNum_searchResults default=1 cfquery name=searchResults datasource=perd

Re: OT JS Question

2002-07-26 Thread S . Isaac Dealey
Kris Pilles wrote: Any idea why this isn't working??? Tells me opener.document is not defined function setForm() { opener.document.Form1.name.value = document.name2.employees.value; self.close(); return false; } //--/script You might want to qualify opener as window.opener

Re: Setting and evaluating session variables

2002-07-26 Thread Douglas Brown
Well, actually you will have to forgive me, I am thinking in a different scope of using sessions...In all my applications I set the CFID and CFTOKEN to temp vars and therefore I get a new pair on each browser. If he is not setting them like that, then they will expire when the application says

Re: Favourite Web Services so far?

2002-07-26 Thread Alex
I have not used it; I just think it's useful. There are probably alot more like it somewhere. http://www.codebump.com/services/zipcodelookup.asmx?wsdl On Fri, 26 Jul 2002, Michael Dinowitz wrote: where is that located? The distance from a zipcode is useful. On Fri, 26 Jul 2002, W

CFMX Taking all CPU Resources?

2002-07-26 Thread Joe Eugene
Hi all, Have seen some problems reported with CFMX. These are our testing results.. Window 2000 boxes for same CONTENT.. Testing done with MICROSOFT WEB APPLICATION STRESS TOOL JRun.exe is whats taking all the CPU on CFMX box

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Jochem van Dieten
Dave Watts wrote: For everybody that is hosted on a shared host this is not an option, for them cfhttp just has to work. http://www.macromedia.com/v1/handlers/index.cfm?ID=23046 MPSB02-04 - ColdFusion MX Enterprise Edition's JSP� functionality should be disabled in shared, hosted environments

Re: SQL Query

2002-07-26 Thread Paul Giesenhagen
Query worked great thanks folks .. it was simple huh? Paul Giesenhagen QuillDesign try... SELECT c.id, c.description FROM choicetable c WHERE c.productid = '#URL.productid#' AND c.id NOT IN ( SELECT pc.choiceid FROM productchoicetable pc WHERE pc.productid =

Re: Favourite Web Services so far?

2002-07-26 Thread Bryan Stevenson
and they are located where Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com

ListSort()

2002-07-26 Thread Jerry Johnson
I just noticed an odd feature of ListSort. When sorting a list of text, using the Text asc sort mode, longer objects appear before shorter objects, if they are otherwise equal. Motor Vehicles - Mild Brain Injury Motor Vehicles - Negligence - Leg Injuries Motor Vehicles - Negligence - No

RE: site wide missing template handler not working in MX

2002-07-26 Thread Brook Davies
Well, I am glad to hear that it IS working. I am simply referencing a file at the webroot. I have a feeling that CF might think the webroot is the standalone webroot. Maybe thats the problem. Does anyone know where the webroot is set? Brook At 03:00 PM 26/07/02 -0500, you wrote: I had a

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Jon Hall
Jesse, by george I've been screaming about cfhttp forever. :) 1) The most glaring problem is that cfhttpparam automatically urlencodes all form fields. This obviously creates all sorts of problems with xml packets. I can tell you that both UPS, and Tech-Data's xml api's have no clue what to do

dynamic body #DynamicContent#

2002-07-26 Thread Brian Scandale
How does one go about putting dynamic content into the body tag? you know... perhaps something like: body onload=#DynamicContentVariable# thanks Brian __ Structure your ColdFusion code with Fusebox. Get the official book at

RE: site wide missing template handler not working in MX

2002-07-26 Thread Mike Byers
CF stores it in the registry. I think that is the only place, but not sure. MX stores all kinds of things in xml files. But if you look in HKEY_LOCAL_MACHINE/SOFTWARE/MACROMEDIA/INSTALL DATA/COLDFUSION MX You will see it. Mike -Original Message- From: Brook Davies [mailto:[EMAIL

XML Questions (newbie)

2002-07-26 Thread Eric Hoffman
Okay, we are new to the XML game and using CF with it; argh, and have one or two general questions I think that after reading up are still a bit fuzzy on and would love if someone that has been down this road to drop us a quick line offlist. Basically, the questions are: we've made up the XML

Re: dynamic body #DynamicContent#

2002-07-26 Thread Jerry Johnson
First, you must set DynamicContentVariable to some value cfset DynamicContentVariable=loademup(); Then you must output the variable using cold fusion body onload=cfoutput#DynamicContentVariable#/cfoutput Finally, it must be saved as a .cfm file (or a file type handled by the Cold Fusion

Re: Stored Proc wizard

2002-07-26 Thread Douglas Brown
Only thing I know of is at http://www.aloha-webdesign.com Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Phillip B [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 1:33 PM Subject: Stored Proc wizard I think I saw something

Re: CFMX strange syntax required to output a query [crosspost]

2002-07-26 Thread Dick Applebaum
I am replying to my own original post so I can add a few comments. 1. The OpenBase people are looking into unusual results. 2. CFMX docs for cfquery include the following, but a search on dot notation did not yield anything enlightening. New in ColdFusion MX: ColdFusion supports dot

CFFTP Error message question

2002-07-26 Thread Jerry Johnson
Using the CFFTP tag, I very infrequently receive an error. cfftp.errorCode 3 cfftp.errorText 530 User jdoe cannot log in. The problem is there is no user anywhere called jdoe. Is this a generic message returned by CFFTP? Is it done to shield the actual user name? I've got more debug code in

Re: CFMX Taking all CPU Resources?

2002-07-26 Thread Joe Eugene
Trusted Cache was NOT turned on either of the servers (CFMX or CF 5.0) Joe - Original Message - From: Jesse Houwing [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 4:27 PM Subject: Re: CFMX Taking all CPU Resources? Joe Eugene wrote: The results were for

RE: CF 5 Availability

2002-07-26 Thread Mike Byers
I just purchased CF5Prof with a 2yr sub allowing me to upgrade to MX. I told them we already had 5 in place and need to stay there until ready to upgrade. They sold me 5 at MX's price and with the 2 yr subscription and I have to register and order upgrade immediately (probably 30 days) and all

Re: ListSort()

2002-07-26 Thread Critz
oi Jerry!! wouldn't it sort on the first letters then keep going down the list till it finds one different then sorts on those? - Critz Macromedia Certified Advanced ColdFusion Developer CFX_ChannelOP Network=Efnet Channel=ColdFusion Friday, July 26, 2002, 4:11:28 PM, you wrote:

Re: XML Questions (newbie)

2002-07-26 Thread Jon Hall
I'll assume that your xml code or packet is valid xml that the other side can understand it. After that it is fairly simple to send it along. You need to get the entire xml packet string into a variable. For examples sake: cfsavecontent var=xmlPacket foo cfoutput query=bars

Re: ListSort()

2002-07-26 Thread Jerry Johnson
Well, it appears to be putting them in that order on purpose. My previous example was the AFTER sort list. PRE sort was completely jumbled. I would have figured that it would sort like so (first and shortest): A AB AC ACE B But it is always doing AB ACE AC A B I was just wondering if there

Re: ListSort()

2002-07-26 Thread S . Isaac Dealey
I just noticed an odd feature of ListSort. When sorting a list of text, using the Text asc sort mode, longer objects appear before shorter objects, if they are otherwise equal. Motor Vehicles - Mild Brain Injury Motor Vehicles - Negligence - Leg Injuries Motor Vehicles - Negligence - No

Re: ListSort()

2002-07-26 Thread Brian Scandale
Seems just plain wrong to me... a bug? At 02:15 PM 7/26/02, you wrote: Well, it appears to be putting them in that order on purpose. My previous example was the AFTER sort list. PRE sort was completely jumbled. I would have figured that it would sort like so (first and shortest): A AB AC ACE

RE: multiple copies of list mail?

2002-07-26 Thread Sandy Clark
I'm getting 4 posts of every listing. My filters, rules haven't changed for weeks. Mikey D, HELP Fix this! I'm getting snowed under with dupes! -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:21 PM To: CF-Talk Subject: Re: multiple

Re: DWMX is breaking my code HELP!

2002-07-26 Thread Brook Davies
Sean, I've done everything listed here already, but still get the crap in my files. If I rename the translators directory it does not write this code to my files but generates a lot of errors. In DM 4.0 it was possible to disable the translators but I do not see this option in DWMX. Is there

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Sean A Corfield
On Friday, July 26, 2002, at 10:34 , Alex Hubner wrote Pure CF programmers are now being forced to know a little of Java, to take care of a lot of new things (such as text encoding, data types and stuff) that is suppressed by the easy of CF5 and previous versions. Well, I don't really think

Re: dynamic body #DynamicContent#

2002-07-26 Thread S . Isaac Dealey
You need to move your body tag down into the layout file ... Sorry, I was too terse with my question... I'll be a bit more verbose here. cfheader is used to put dynamic info into the head/head section of the html returned by CF to a browser making a request. I use it all the time to put in

Re: CFX_Image docs

2002-07-26 Thread Bryan Stevenson
That's correctI did receive acopy of the docs for 1.4 offlist, so I'm good to go Thanks all Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] -

Re: multiple copies of list mail?

2002-07-26 Thread Michael Dinowitz
When did it start and is it still happening? I'm getting 4 posts of every listing. My filters, rules haven't changed for weeks. Mikey D, HELP Fix this! I'm getting snowed under with dupes! -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday,

Re: OLAP

2002-07-26 Thread S . Isaac Dealey
Has anyone out there connected to MSSQL2000 OLAP cubes using CF? If you have, any suggestions? I'm tearing out my already thinning hair just trying to figure out if it's possible. Ideally, I'd like to be able to analyze a cube the same way folks do it using Excel or Access... I haven't, but

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Alex Hubner
-- Mensagem original --- De : Sean A Corfield [EMAIL PROTECTED] Well, I don't really think that's true. Compatibility with CF5 is pr etty good (especially considering CFMX is a complete rewrite!) so existin g CF5 continue to run just the same. Sorry but I have a

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Dick Applebaum
On Friday, July 26, 2002, at 02:51 PM, Sean A Corfield wrote: I'm sitting here with a Windows 2K laptop, a Linux laptop and a Mac G4 laptop. Each of them is happily running CFMX and I've had no need to mess with Java installation, third party torture or Wow! That's a pretty big lap you

Re: ListSort() - SOLVED

2002-07-26 Thread Brian Scandale
Gotta love them train rides ;-) At 03:20 PM 7/26/02, you wrote: Nope. cf_blush It turns out to be caused by low blood sugar. /cf_blush (I figured it out while on the train home) There was a . (period) at the end of each line, stripped off at display time. The text evaluates less than ., so

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Alex Hubner
Sean, I'm sorry. Re-reading you message I don't see any irony. Sorry my english sometimes traps me. Abraços! Alex -- Mensagem original --- De : Alex Hubner [EMAIL PROTECTED] Para: CF-Talk [EMAIL PROTECTED] Cc : Data: Fri, 26 Jul 2002 20:06:52 -0300

RE: Using Text lists variable in SQL IN operator

2002-07-26 Thread Christopher Olive
what's the actual problem? at a look, try putting 's around the IN clause stuff. (dbo.answer_rating.eval_email IN ('#manager_direct_staff#') -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 7:05 PM To: CF-Talk Subject: Using Text lists

Re: Using Text lists variable in SQL IN operator

2002-07-26 Thread Jon Hall
manager_direct_staff is just a list of the records that come back in the get_manager_staff.userid query column right? So get rid of that loop, and just change the second query to this: cfquery name=get_category_avg datasource=emp_review SELECT AVG(dbo.answer_rating.answer_value) as category_avg

Adventures in installing MX

2002-07-26 Thread Jon Hall
Ok, soI've installed the dev version of MX a few times on my personal machines, and I just started to put it on a server here at the office that had CF on it in the past. It looks like the machine went from 4.0 to 4.5, apparently this machine never went to 5. So I install MX,

Re: multiple copies of list mail?

2002-07-26 Thread Dave Carabetta
When did it start and is it still happening? Michael, I have to admit that this happens to me quite often, and has been going on for at least couple of months (I honestly cannot say give you an exact date though). I don't receive 4 of the same per say, but I do receive duplicates (2) quite

RE: Adventures in installing MX

2002-07-26 Thread Mike Brunt
When you tried to install CFMX did you select the Stand-Alone option? this is important if you already have another version of CF already using IIS as the web server. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making

Re: Adventures in installing MX

2002-07-26 Thread Jon Hall
No, I selected IIS. I wanted to upgrade the existing version. Nothing important runs on this server, so it's ok as far as that goes. I don't remember that being an issue when installing on my personal machines, maybe I should rtfm though... As a side note, I was just about to post a followup

RE: CFMX Taking all CPU Resources?

2002-07-26 Thread Joe Eugene
No we are not using any COM objects. Joe -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 6:38 PM To: CF-Talk Subject: Re: CFMX Taking all CPU Resources? Joe Eugene wrote: None of the below have IMPROVED Performance. 1. Trusted Cache

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Sean A Corfield
On Friday, July 26, 2002, at 04:06 , Alex Hubner wrote: Sorry but I have a different opinion on that. The reality shows a different thing, you can check it here, on MM support forums and all over the place. Yes, I realize that some people are having some problems with some specific language

Re: Adventures in installing MX

2002-07-26 Thread Brook Davies
Same thing happened to me on my second install, no option for IIS. So I installed the standalone. Then to transfer the settings you need to run this script: cf_root\runtime\jre\bin\java -cp cf_root\runtime\lib -jar cf_root\runtime\lib\wsconfig.jar -ws IIS -site 0 -filter-prefix-only -map

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Brook Davies
Sean, Ya know what, I am happy with CFMX so far, even though I've had a few struggles they are mostly to do with non-standard implementations. The other issues are more often than not already addressed in tech notes and this list has been helpful. Now If I can just get those SES urls ending

Weird error

2002-07-26 Thread Todd
First time I've ever seen an error message without a real error message (errr.. Axis errors not included) since beta, this is literally all that is displayed, no reason why, no nothing... The Error Occurred in D:\Dev\websites\famtoday\_ftlibrary\cfcs\system\registration.cfc: line 35 33 :

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Sean A Corfield
On Friday, July 26, 2002, at 06:56 , Brook Davies wrote: Ya know what, I am happy with CFMX so far, even though I've had a few struggles they are mostly to do with non-standard implementations. That's good to know - hopefully we can help you work through the remaining glitches. Now If I can

Re: Weird error

2002-07-26 Thread Sean A Corfield
On Friday, July 26, 2002, at 07:03 , Todd wrote: First time I've ever seen an error message without a real error message (errr.. Axis errors not included) since beta, this is literally all that is displayed, no reason why, no nothing... ... 35 : tempStruct.username =

Re: Weird error

2002-07-26 Thread Todd
An obscure message: Error,jrpp-41,07/26/02,22:04:38,myApp,null The specific sequence of files included or processed is: D:\Dev\websites\myapp\registration.cfm At 07:11 PM 7/26/2002 -0700, you wrote: On Friday, July 26, 2002, at 07:03 , Todd wrote: First time I've ever seen an error message

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Alex Hubner
Sean, your comments regarding CFMX versus CF5 are very sensate. I must confess that I agree with most of then. OK, that's good to know - and unfortunate for the Fusebox community I suspect. Out of curiosity, were you running with Trusted Cache enabl ed? No, I didn't tested it with trusted

One More XML Twist: BASE64 Encoding

2002-07-26 Thread Eric Hoffman
Steven Salter, are you out there? According to the archives you have run into this problem with UPS and wondered if you had any pointers or got it to work right. Can you drop me a line? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions

OT: SQL Server Trees

2002-07-26 Thread Costas Piliotis
I've seen numerous threads throughout this list discussing the need for trees stored in sql server. I came across this absolutely fantastic article at http://www.sqlteam.com/item.asp?ItemID=8866, where the author compares the two models for building trees: Adjacency List Model and Nested Set

Re: It's official: CFMX is 10% faster than CF5

2002-07-26 Thread Sean A Corfield
On Friday, July 26, 2002, at 07:29 , Alex Hubner wrote: Sean, your comments regarding CFMX versus CF5 are very sensate. I must confess that I agree with most of then. That's good since I hardly used CF5 - I always worry I'm on shaky ground there. I started using CF about August last year and

Re: Weird error

2002-07-26 Thread Sean A Corfield
On Friday, July 26, 2002, at 07:19 , Todd wrote: An obscure message: Error,jrpp-41,07/26/02,22:04:38,myApp,null The specific sequence of files included or processed is: D:\Dev\websites\myapp\registration.cfm Hmm, that just repeats what we already really know. What about the other log

Re: Weird error

2002-07-26 Thread Todd
Well, it's not null... I did a cfdump and there's data in there. All I was doing was encrypting, urlencoding... urldecoding.. decrypting. I had to switch to cfusion_encrypt() cfusion_decode() to get it to work. ~Todd At 08:24 PM 7/26/2002 -0700, you wrote: On Friday, July 26, 2002, at 07:19 ,

Re: Weird error

2002-07-26 Thread Todd
er.. cfusion_decrypt().. and, yes, I know it's undocumented code. I recall voting for it in the beta. ;) ~Todd At 11:42 PM 7/26/2002 -0400, you wrote: Well, it's not null... I did a cfdump and there's data in there. All I was doing was encrypting, urlencoding... urldecoding.. decrypting. I

If statement

2002-07-26 Thread Paul Giesenhagen
I have an if statement that I need to write, it is I am sure very simple, but for some reason i cannot think straight on it. Basically if this variable is a 0 or a then I don't want to process some stuff ... how would I write this? This code below doesn't work .. it still lets or 0's

Re: If statement

2002-07-26 Thread brook
How bout cfif variables.choiceValue !--- process stuff- -- /cfif At 11:34 PM 7/26/02 -0500, you wrote: I have an if statement that I need to write, it is I am sure very simple, but for some reason i cannot think straight on it. Basically if this variable is a 0 or a then I don't

Re: If statement

2002-07-26 Thread Paul Giesenhagen
Doesn't like it, says it can't convert to a boolean How bout cfif variables.choiceValue !--- process stuff- -- /cfif At 11:34 PM 7/26/02 -0500, you wrote: I have an if statement that I need to write, it is I am sure very simple, but for some reason i cannot think

Re: If statement

2002-07-26 Thread brook
Hmm, is that with CFMX or earlier? Try cfif val(variables.choiceValue) At 11:47 PM 7/26/02 -0500, you wrote: Doesn't like it, says it can't convert to a boolean How bout cfif variables.choiceValue !--- process stuff- -- /cfif At 11:34 PM 7/26/02 -0500, you

Re: If statement

2002-07-26 Thread Paul Giesenhagen
CF 5 ... and that did the trick ... thanks! Paul Giesenhagen QuillDesign - Original Message - From: brook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 27, 2002 12:07 AM Subject: Re: If statement Hmm, is that with CFMX or earlier? Try cfif

Creating tables on the fly or using one big table

2002-07-26 Thread brook
I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If

Re: If statement

2002-07-26 Thread Sean A Corfield
On Friday, July 26, 2002, at 09:34 , Paul Giesenhagen wrote: This code below doesn't work .. it still lets or 0's through... cfif (variables.choiceValue neq 0) OR (Len(variables.choiceValue) /cfif That code executes if the value is not equal to 0 or the length is not equal to 0. Plug in

Re: If statement

2002-07-26 Thread Paul Giesenhagen
That works too ... and makes sense ... Thank you Paul Giesenhagen QuillDesign On Friday, July 26, 2002, at 09:34 , Paul Giesenhagen wrote: This code below doesn't work .. it still lets or 0's through... cfif (variables.choiceValue neq 0) OR (Len(variables.choiceValue) /cfif That

<    1   2   3   >