Re: Passing list to Stored Procedure..

2001-08-23 Thread Don Vawter
Ok I put them out there as is. I am no SQL Server Guru so I make no guarantees about efficiency. Also I wrote the functions to use any delimitter but I only use commas in my site. I have unit tested them with other delimitters but nothing extensive. They are I am in a hurry and I am the only one

RE: Passing list to Stored Procedure..

2001-08-23 Thread Darryl Lyons
Umm, it asks for a username/password :) -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 5:06 PM To: CF-Talk Subject: Re: Passing list to Stored Procedure.. Ok I put them out there as is. I am no SQL Server Guru so I make no guarantees

RE: Open Source Content Mananagent System

2001-08-23 Thread Thomas Chiverton
If Zope isn't an app server, what does it run on? Ie, Spectra runs on CF, what about Zope? Zope is written in Python, and runs through a web server the same way CGI's do. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: database connections in Studio

2001-08-23 Thread Thomas Chiverton
reads access violation at address 00617D40 in module 'cfstudio45.exe'. read of address . It then Get the Studio 5 beta 2. Much, *much* better than 4.5... ~~ Structure your ColdFusion code with Fusebox. Get the official book at

regexp for swear filter

2001-08-23 Thread Rich Wild
Dudes and laydeez, Would anyone perchance know how to create a regexp to replace instances of specific list items in a block of text, with their asterisked counterparts (of the same length)? What I mean by this: list = apple|banana|car text = this banana drove the car into the apple at high

Re: We've been assimilated...

2001-08-23 Thread Roger B .
On Wed, 22 Aug 2001 09:08:05 -0600, Shawn Grover [EMAIL PROTECTED] wrote: My experience says these problems are from non-compliant code (i.e. using p instead of p/p). Shawn, P does not require a closing tag in versions of HTML prior to XHTML. Any HTML4-era user-agent that depends upon a

RE: Four Selects Related.

2001-08-23 Thread Paul Ihrig
Aaron could you give me an example of this. i couldn't find any info on drop down lists that are related. also how to error check a dropdown list. thanks -paul -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 9:57 PM To: CF-Talk

RE: CF-Talk-list V1 #113

2001-08-23 Thread Bill Grover
Here is a section of a stored procedure I wrote that accepts a list then parses it apart. The purpose of this routine was to accept 2 lists. The first one is a list of part numbers (i.e. 1,2,3,4) and the 2nd is a list of divisions (i.e. E,P,E,M). Both lists have the same number of items in

RE: Access memo fields truncated in GROUP BY?

2001-08-23 Thread Aitken, Jeffrey
I take it that the 'Message' field is the Memo field? If so, try selecting that one last in the query... SELECT Max(Messages.TimeStamp) As NewMessage, Topics.Topic, Messages.Message FROM Messages INNER JOIN Topics ON Messages.TopicID=Topics.ID GROUP BY Topics.Topic, Messages.Message Other than

Re: Four Selects Related.

2001-08-23 Thread Aaron Rouse
The Advanced Form example on the pengoworks website has basically a two selects example on it and if you look at the source to the page you can see how it populates the multiple select box and then add on other boxes from there. However, once I make it in to work today I will send you a example

Re: Displaying the query output in a table

2001-08-23 Thread bajaria aslam
The example code you gave solved the problem. Thanks!!! --- Terry Troxel [EMAIL PROTECTED] wrote: You didn't signify what was not work in your code, which without your database would make solving your problem a little easier. At first glance it looks like you should have your starting and

CF-Talk to from wierdness

2001-08-23 Thread Carlisle, Eric
Was the list changed so that the FROM address is the sender and the TO address is [EMAIL PROTECTED]? If so, I'm wondering why this is the case. You can't post to the list anymore by hitting reply. Was that by design? It's no big deal, really. My only beef is that I can't find a way in

RE: CF-Talk to from wierdness

2001-08-23 Thread Adkins, Randy
I am using Outlook and it filters fine as well as hitting the reply which dumps it right back into CF-Talk. -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 8:57 AM To: CF-Talk Subject: CF-Talk to from wierdness Was the list changed

RE: CF-Talk to from wierdness

2001-08-23 Thread Carlisle, Eric
#($*#@()*#)@$*)@#(()#@$*@#*($ I'm not awake yet, sorry. :P Disregard. EC -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 9:04 AM To: CF-Talk Subject: RE: CF-Talk to from wierdness I am using Outlook and it filters fine as

Format Text

2001-08-23 Thread Dusty Tinashe Shoko
Hi ppl Short of first formatting text and then inserting the HTML into the Access DB is there a way of having the original (MS Word) document's format preserved when I add its text contents to a db via a form and then retrieve it later for displaying in the browser as html?

Coldfusion Level 1-3 at OSU :: who is teaching it?

2001-08-23 Thread Paul Ihrig
i just got clearance to spend money for the first time this year! my manager wants me to brush up on CF told me to take one of the classes at OSU. i want to know if any one on this list is teaching it what level i should take? been using cf for over 2 years now. thanks -paul

Re: Passing list to Stored Procedure..

2001-08-23 Thread Don Vawter
Sorry about the permissions problem. Maybe this will be better. If not, just contact me off list and I will email it to you. http://www.vawter.com/utilities/listfunctions.zip - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 23,

Re: Buggy log10 function in CF 5.0

2001-08-23 Thread G
Your situation got me thinking back to my old math days, Jason. When complaining why we had to learn how to estimate logarithms using Taylor Series, our teacher would remark what would you do, if the LOG button on your calculator suddenly quit working?. Seems rather fitting huh? Anyway, I was

INSERTing multiple rows efficiently

2001-08-23 Thread Correa, Orlando (ITSC)
I have the following query which inserts multiple rows based on a user's choice of checkboxes in an HTML form... This batch of inserts is created by looping over the prepared statement and adding the values and creating a new insert statement for each set, then sending the batch of inserts to

Re: Coldfusion Level 1-3 at OSU :: who is teaching it?

2001-08-23 Thread Dave Hannum
OSU is that: A) Ohio State Universty B) Oklahoma State University C) Oregon State University D) Other Dave Ohio Univeristy. Not to be confused with The Ohio State University. We're Ohio, The State University - Original Message - From: Paul Ihrig [EMAIL PROTECTED]

RE: CF-Talk to from wierdness

2001-08-23 Thread Andrew Scott
It has always been this way!! I use outlook and have not experienced the problem you have just described, I run rules for over 20 mailing lists and personal email accounts. The only beef I have is that Outlook XP will from time not apply the rules, and I have to manually run the rules to achieve

RE: Stock Quotes

2001-08-23 Thread Pete Freitag
One other option is to use CFX_SOAP http://www.cfdev.com/xml and use some of the Web Services on http://www.xmethods.com they have a Free Stock Quote web service listed (actually the tag comes with a stock quote lookeruper as an example). +++ Pete Freitag

RE: Coldfusion Level 1-3 at OSU :: who is teaching it?

2001-08-23 Thread Janine Jakim
I'd assume its A. The Ohio State Universitywhen I went there there was the assumption that there was 1 and only 1 OSU. If you talk to people there they woud say there are others? -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 9:59 AM

Structure notation

2001-08-23 Thread Tim Dempsey
Folks, Perhaps the collective wisdom of the list can enlighten me about the syntax available to reference structure elements. In Cold Fusion manuals and Studio help as well as in the Ben Forta books the way to reference elements of a structure is given as structure_name[element_name] But I

RE: CF and PDAs

2001-08-23 Thread Shawn Regan
I bought AppForge and it is great. Lets you build apps for the palm OS in the VB IDE using the VB language. Shawn Regan Applications Developer Pacific Technology Solutions -Original Message- From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 3:13

RE: Structure notation

2001-08-23 Thread Raymond Camden
Is this something new or has it always been available. Why doesn't the CF manuals or help mention it? Is there any danger in using object notation. It's always been like that. The [] notation is best for dynamic struct access, ie: CFSET KEY = Boo CFSET VAL = Struct[Key] This would output

RE: Structure notation

2001-08-23 Thread Rich Wild
I couldn't say structure.substructure.#Evaluate(#x#) You could say: evaluate(structure.substructure. x) -Original Message- From: Tim Dempsey [mailto:[EMAIL PROTECTED]] Sent: 23 August 2001 15:39 To: CF-Talk Subject: Structure notation Folks, Perhaps the

RE: Structure notation

2001-08-23 Thread Andrew Scott
When structures where introduced in CF4.0, the manual did show both ways of referencing. Both will work fine the same way. -Original Message- From: Tim Dempsey [mailto:[EMAIL PROTECTED]] Sent: Friday, 24 August 2001 12:39 AM To: CF-Talk Subject: Structure notation Folks, Perhaps the

RE: Open Source Content Mananagent System

2001-08-23 Thread Jos Yule
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Well, not to be too picky, but it also comes with its own HTTP server built in (medusa), but can also run as an add on to most servers (IIS, Apache etc). j -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent:

Re: CF and PDAs

2001-08-23 Thread Scott Van Vliet
You can also use Flash 4 WinCE NTE to create an interface, and use ActionScript to send/load variables from a CF Server - SVV - Original Message - From: Shawn Regan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 7:43 AM Subject: RE: CF and PDAs I

RE: CF and PDAs

2001-08-23 Thread Shawn Regan
I just looked at the demo of NS basic for the palm. I would stick with AppForge, you can buy the personial version of AppForge for $20. NS Basic is $100. It took me 10 mintues to shoot NS basic down. Its lacking a bit of things that AppForge has. Shawn Regan Applications Developer Pacific

RE: database connections in Studio

2001-08-23 Thread Jeffry Houser
At 02:07 AM 08/23/2001 -0700, you wrote: reads access violation at address 00617D40 in module 'cfstudio45.exe'. read of address . It then Get the Studio 5 beta 2. Much, *much* better than 4.5... It is more stable, I'll give it that. -- Jeffry Houser | mailto:[EMAIL PROTECTED]

RE: CF and PDAs

2001-08-23 Thread Shawn Regan
Your not talking about running CF sever on winCE are you scott? :) Shawn Regan Applications Developer Pacific Technology Solutions -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 7:58 AM To: CF-Talk Subject: Re: CF and PDAs You can

SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Amanda Stern
hello, I've been working on this query for a while and cant get it to work the way I need it to, i am close though.here is the problem - the cas table is keyed by [iCasacApptID], the cats table has a composite key of [iCasacApptID, cTreatSelectID]. So when I output the results if

RE: CF-Talk to from wierdness

2001-08-23 Thread Robert Long
That's funny, I have been having the same issue lately. My rule wasn't being used by Outlook and I had to do it manually. shrugs Thought it was just me and this new pc... -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 6:12 AM To:

RE: Coldfusion Level 1-3 at OSU :: who is teaching it?

2001-08-23 Thread Paul Ihrig
Ohio State University -paul -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 9:59 AM To: CF-Talk Subject: Re: Coldfusion Level 1-3 at OSU :: who is teaching it? OSU is that: A) Ohio State Universty B) Oklahoma State

RE: regexp for swear filter

2001-08-23 Thread Ryan Emerle
I want to be able to do this with a single regexp, rather than list looping over the text and replacing the index of the current loop iteration with its repeatstring('*', len(index)) counterpart - which is slow if I have to do this for many text blocks on the same page.. [...] would the following

RE: SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Shawn Regan
If I'm not mistaken, I think you the SQL statement needs a ORDER BY cTreatSelectID to use the group attribute in the cfoutput tag. Shawn Regan Applications Developer Pacific Technology Solutions -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Thursday, August

RE: CF and PDAs

2001-08-23 Thread Jos Yule
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The only thing is that folks would have to have VB in order to use AppForge, and even the 'learning' edition of VB is $150 (in Canada)... Just something to keep in mind... j -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]]

Re: Buggy log10 function in CF 5.0

2001-08-23 Thread Gonzo Rock
WOW! Way to go Brian! However, I vote that the ColdFusion Developers fix the function or rip it out of the package... no answer is better than wrong answers. By your demonstration, perhaps you can provide them with the expertise to repair their code. :-) At 08:41 AM 8/23/01 -0500, you

Re: Buggy log10 function in CF 5.0

2001-08-23 Thread G
Its interesting.calculators used Taylor Series to evaluate Log's and Ln's internally. I wonder if Cold Fusion does as well??? - Original Message - From: Gonzo Rock [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 11:09 AM Subject: Re: Buggy log10

SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Amanda Stern
hello, I've been working on this query for a while and cant get it to work the way I need it to, i am close though.here is the problem - the cas table is keyed by [iCasacApptID], the cats table has a composite key of [iCasacApptID, cTreatSelectID]. So when I output the results if

Graphics Automation

2001-08-23 Thread Fuon See Tu
ok, so a friend wants to be able to hook up a digital camera at the event, and connect it to a laptop with internet connection. At certain times in the day, he takes a snapshot. Ideally, we'd like the process after the snapshot to be automatedthat is...have the picture resized to a

RE: regexp for swear filter

2001-08-23 Thread Bryan Love
don't waste your time with regular expressions; in this case you already know what you want to replace and regular expressions are for times when you don't know exactly what your searching for. Use replaceList(), like this: badList = apple,banana,car; goodList = *,**,***; text = this

RE: regexp for swear filter

2001-08-23 Thread Rich Wild
now you see Bryan, I just knew there was someone intelligent out there! I knew I missing something. Funny how the little functions drop out of memory aint it? :) cheers again. May English pints rain down upon thee. -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]]

RE: Buggy log10 function in CF 5.0 (Rounding to Significant Digits)

2001-08-23 Thread Snyder, Jason
Thanks for all of your input. I figured out a way to get more consistent results. What I did was to add 0.0 to the number in hopes that it would force internal conversion to float or double. Once I did this I started getting consistent results. If any of you are interested here is the UDF

RE: SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Rice, John J
You may want to append an ORDER BY iCasacApptID to the second query in your UNION. -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 11:34 AM To: CF-Talk Subject: SQL help/group in CFOUTPUT not working?? hello, I've been working

RE: SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread C. Hatton Humphrey
I thought that when you were using an ORDER BY with a Union Select you used the column numbers instead of names, so adding Order By 3 to the bottom of the query should work HTH Hatton Humphrey -Original Message- From: Rice, John J [mailto:[EMAIL PROTECTED]] Sent: Thursday, August

RE: CF and PDAs

2001-08-23 Thread Scott Mulholland
No, I simply want to replicate some functionality of a web app I have. Query for a list of items to display...drill down by clicking an item to query for specific info to it...etc... all very basic. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August

.jar files?

2001-08-23 Thread Christian Abad
Folks: I am working on a Custom Tag in Java and I'm having some difficulties : Does ColdFusion recognize and un-jar .jar files if they are in the Class Path under Java Settings in the Administrator? So far, the only way I have been able to implement my Custom Tag to MANUALLY un-jar this

RE: CF and PDAs

2001-08-23 Thread Shawn Regan
Well if you have Visual Basic 6, I would think about AppForge its worth the $20. it goes up, Standard is $300 and Professional $700. The standard and professional have some nice features like, No coding needed Conduit stuff for syncing the pda to a ODBC on the PC. Shawn Regan Applications

CF 5.00 Beta 2: Accessing database list on local machine

2001-08-23 Thread James Taavon
I am having a problem listing my databases on my local machine. After selectiing localhost, I get the error message, An error occurred accessing the RDS server: The authentification failed. Any clues to why this is happening? Thanks, James ~~

CF 5.00 Beta 2: Accessing database list on local machine (UPDATE!)

2001-08-23 Thread James Taavon
I am having a problem listing my databases on my local machine. After selectiing localhost, I get the error message, An error occurred accessing the RDS server: The authentification failed. Any clues to why this is happening? This started happening after I downloaded CF 5.0 eval. Thanks, James

cfx problem

2001-08-23 Thread Jordan Saardchit
I'm having a problem registering a cfx, I registered the cfx, the dll is in the appropriate directory and permissions are fine but I keep getting an error saying that the dll can not be found. PLEASE HELP Thanks in advance The error looks like this: Error Diagnostic Information Error

RE: SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Rice, John J
I recomend NEVER using the ORDER BY with the column number syntax. It is easy to change the SELECT clause or have someone else come in and change it and your ORDER BY is then completely wrong. The GROUP BY would then also be broken. I ALWAYS reference columns by their name. ;) Best regards

RE: Four Selects Related.

2001-08-23 Thread Dan G. Switzer, II
Paul, There's now an example on-line of doing n-selects. The example only shows 3 levels, but the logic doesn't change at all for 4 levels. n-Related Select Boxes http://www.pengoworks.com/qForms/docs/examples/n-related_selectboxes.htm -Dan -Original Message- From: Paul Ihrig

OT: Way Slow web pages

2001-08-23 Thread Bruce, Rodney
sorry about the very broad question. but what are some things that could cause a web server to almost be 10times slower. web pages that were taking ~3,000ms are up to ~30,000. same with others that were at ~200ms are at ~2,000. is seems to be the query/db access time. it's affecting both

Re: OT: Way Slow web pages

2001-08-23 Thread Fuon See Tu
here are some things 1. Virus Scanner running on server 2. Low memory 3. Low HD space 4. Bad memory 5. Bad Connection 6. Virus 7. bad coding/scripting From: Bruce, Rodney [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: OT: Way Slow web pages

Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread O'Connor-Rose, Joshua
The following was posted on the CF forums about a week ago, this is a real bug. Does anybody know how I can tell Macromedia about this: ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread Bruce Sorge
The Allaire Beta Forum comes to mind - Original Message - From: O'Connor-Rose, Joshua [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 2:14 PM Subject: Bug in CF5 (Using CFQUERY to insert data) The following was posted on the CF forums about a week ago,

RE: OT: Way Slow web pages

2001-08-23 Thread Bruce, Rodney
1. yes, and has been, this speed problem is new 2. task manger shows RAM almost totally free 3. have over 60GBs free 4. will look into this, can you suggest some programs that can do this? 5. using a monitor on the server, no connection 6. Have updated dat file from Norton. Are there

RE: Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread O'Connor-Rose, Joshua
(-hmm, well that didn't work. Loving IE/Outlook combinations) The following was posted on the CF forums about a week ago, this is a real bug. Does anybody know how I can tell Macromedia about this: ~~ Structure your ColdFusion code with Fusebox.

RE: OT: Way Slow web pages

2001-08-23 Thread Shawn Grover
if you are accessing an MS Access database, open the db directly, and run the Compact and Repair database option. HTH Shawn Grover -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 1:21 PM To: CF-Talk Subject: RE: OT: Way Slow web pages

RE: Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread O'Connor-Rose, Joshua
(-hmm, well that didn't work again) forcing plain text now to see if that works. The following was posted on the CF forums about a week ago, this is a real bug. Does anybody know how I can tell Macromedia about this: It's not urgent, we do have a work around, but I just wanted to post this bug

RE: OT: Way Slow web pages

2001-08-23 Thread Mueller, Ben
Did you have this problem under an earlier version of CF? Ever since we upgraded our development server to CF 5, we've been getting these periodic slow-downs that we haven't been able to track down yet. We've only noticed it on a page which normally takes about a minute or two to complete.

Re: cfx problem

2001-08-23 Thread Keith Meade
Is it possible that another required DLL is missing? e.g. if the CFX is written in C++, do you need to install an MSVCRT??.dll ? Keith Meade [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread Bruce Sorge
I am still thinking that the proper place would be the Allaire Beta Forum. Go to http://beta.allaire.com and log in to report the issue. If you are not set up then you will need to apply. I presume though that since you have the beta that you are already a member. - Original Message -

RE: CF and PDAs

2001-08-23 Thread Jos Yule
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Well, ok, the conduit stuff is pretty key, and if you are looking for that kind of capability then VB/AppForge sounds like a great fit. I was more thinking for folks that don't have $$$ for VB but still want to do some pilot development. j ps. i

Re: Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread Kwang Suh
As near as I can tell, this is an issue with CF Server v5, not with Studio. CF Server is not a beta product (supposedly :) - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 1:45 PM Subject: Re: Bug in CF5 (Using CFQUERY

RE: Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread O'Connor-Rose, Joshua
Thanks, I will try that, however just to let you know this is the Released version of CF5 and not a beta. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 2:45 PM To: CF-Talk Subject: Re: Bug in CF5 (Using CFQUERY to insert data) I am

RE: Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread O'Connor-Rose, Joshua
As it turns out I was able to access the beta forums however the product CF5 server wasn't listed. Thanks for your help though -- I am still thinking that the proper place would be the Allaire Beta Forum. Go to http://beta.allaire.com and log in to report the issue. If you are not

Re: Bug in CF5 (Using CFQUERY to insert data)

2001-08-23 Thread Bruce Sorge
Never mind. I am stupid. For some reason I thought that you were talking about Studio beta 2. Go to http://www.allaire.com/Support/psprograms/index.cfm. Here you will be able to get support for this. If you choose the Single Issue option, and this is a true bug, then you will not be charged for

RE: OT: Way Slow web pages

2001-08-23 Thread Bruce, Rodney
We upgraded to CF5 in June and this is the first time this slow down has happened. I have stopped and restarted all the services, but for us this has not seem to help. Looking at the Debug info, the queries are running slow. taking up to 10X as long. a simple bd hit to get a page count is

Re: Structure notation

2001-08-23 Thread Joseph Thompson
structure.substructure['#Evaluate(##x##)#'] ?? This should be better: structure.substructure[x] - Original Message - From: Tim Dempsey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 7:39 AM Subject: Structure notation Folks, Perhaps the

RE: OT: Way Slow web pages

2001-08-23 Thread Bruce, Rodney
What are the newest ODBC drivers. maybe on reload I lost them. Looking I have ver 4.00.4403.02 dtd 8/8/99 Is there a newer on and if so, got the url? Thanks -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:32 PM To: CF-Talk

RE: OT: Way Slow web pages

2001-08-23 Thread Shawn Grover
before reloading CF.. try to reapply the latest MDAC. sounds like some of your db drivers may be the root cause. -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 2:01 PM To: CF-Talk Subject: RE: OT: Way Slow web pages We upgraded to CF5

Re: OT: Way Slow web pages

2001-08-23 Thread Kwang Suh
Go to http://www.microsoft.com/data. You can download the latest MDAC there. - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 2:17 PM Subject: RE: OT: Way Slow web pages What are the newest ODBC drivers. maybe

Re: OT: Way Slow web pages

2001-08-23 Thread Mahmut Basaran
Have you scanned your server for CODE RED? TH Mahmut Basaarn - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 10:31 PM Subject: RE: OT: Way Slow web pages if you are accessing an MS Access database, open the db

RE: OT: Way Slow web pages

2001-08-23 Thread Kelly Matthews
Well or at least installed the Code Red patch. I can't believe how many people still haven't installed the patch, and fail to realize the worm will not die until all servers are patched... *grrr* -Original Message- From: Mahmut Basaran [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24,

RE: OT: Way Slow web pages

2001-08-23 Thread Bruce, Rodney
Not connected to web yet, so I don't think its the worm. and I have already ran the patch. Am down loading the newest MDAC, hopefully that's it. Thanks for the suggestions -Original Message- From: Mahmut Basaran [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 1:20 PM

RE: CF and PDAs

2001-08-23 Thread Shawn Regan
Your right for the people that don't have the VB IDE already, NBasic is great. Shawn Regan Applications Developer Pacific Technology Solutions -Original Message- From: Jos Yule [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:52 PM To: CF-Talk Subject: RE: CF and PDAs

RE: cfx problem

2001-08-23 Thread Dave Watts
I'm having a problem registering a cfx, I registered the cfx, the dll is in the appropriate directory and permissions are fine but I keep getting an error saying that the dll can not be found. PLEASE HELP It's possible that there's a dependency on another file within the CFX DLL.

RE: OT: Way Slow web pages

2001-08-23 Thread Dave Watts
We set up a test page which sets a variable something like a million times (in a loop), and then prints the total elapsed time the page took to execute, using the getTickCount() feature. The strange part is that the execution time on the test page doesn't change, regardless of whether

RE: OT: Way Slow web pages

2001-08-23 Thread Bruce, Rodney
Downloaded the MDAC 2.6 , Loaded it, had not helped the speed problem. When I looked after the load, the drivers were the same, so we problem had the newest. But it was worth a try. looks like I might me left with the re-load, unless someone else has some for ideas, I am tapped. Again thanks

RE: OT: Way Slow web pages

2001-08-23 Thread Jeff Beer
Could it be that something is tieing up your bandwidth like a program gone haywire? Maybe even a bad NIC in that machine, or an improperly configured or broken router... Jeff Beer Senior Programmer Architect Hydrogen Media, Inc (727) 530-5500 x303 [EMAIL PROTECTED] -Original

RE: OT: Way Slow web pages

2001-08-23 Thread Bruce, Rodney
right now the server is stand alone, not connected to anything. we were developing on it, and when everything was up and running, were going to connect. thought we had everything going, then this speed issue hits. -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent:

Port for CFFTP

2001-08-23 Thread Robert Everland
I have limited ports open on my cf machine and am having problems getting ftp data, what ports need to be open to get ftp data. I opened 21, but it keeps saying bad port, though I was able to use ftp.exe and connect to where I wanted to go. Robert Everland III Dixon Ticonderoga Web Developer

Re: Port for CFFTP

2001-08-23 Thread Howie Hamlin
It all depends on how CF implements ftp. If it uses the PORT command then you need to have the specified port open. However, the kicker is that it is dynamic (note - the ftp protocol conversation is on port 21 but data transfer is not). Here's what I mean: client (in this case, CF)

RE: (Access)Selecting randomly record

2001-08-23 Thread Brent Goldman
Hi, You could first do a query to get the recordcount, and then do a second query, grabbing data using the #random(1,query1.recordCount)# function of CFML. -Brent -Original Message- From: Melly Masram [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 9:14 PM To: CF-Talk

RE: Structures

2001-08-23 Thread Brent Goldman
Hi, Structures can be global or on a client/session basis, depending on what scope they are put in to. Structures in the APPLICATION or SERVER scopes are global, while structures in other scopes on per request/client. -Brent -Original Message- From: Tilbrook, Peter [mailto:[EMAIL

Re: Port for CFFTP

2001-08-23 Thread Howie Hamlin
I just ran a cfftp test (cf 4.5) and cf does use the port command. Here's a log snippet: PORT 64,69,103,196,100,244 This shows that the cf server requested a port connection on port 31476. A subsequent test yielded: PORT 64,69,103,196,104,33 This is port 26657. So, as you can see the

Re: Access memo fields truncated in GROUP BY?

2001-08-23 Thread Joseph Thompson
Yes, Thank you for looking. Changing the order didn't work. Neither did checking the long text field in the CF administrator. Heck, in the ODBC control panel I tried adjusting the buffer and the MaxAcanRows values (I believe they let the driver determine what the data types are?) I feel

RE: CF-Talk to from wierdness

2001-08-23 Thread Brent Goldman
Hi, I'm using Outlook right now and everything works fine. When I click reply, it is addressed to CF-Talk like it should be, and my rules work fine to filter CF-Talk messages into the CF-Talk folder. Maybe you should try re-installing it? -Brent -Original Message- From: Carlisle,

RE: Access memo fields truncated in GROUP BY?

2001-08-23 Thread Leon Oosterwijk
Joseph, The problem here lies in Access/SQl Server not with Cold Fusion. If you wish to retrieve a big field with more than 255 chars you need to either specify this in at the end of your sql query or, if you are using complex query clauses as a separate query. I ran into this problem developing

RE: Structure notation

2001-08-23 Thread Brent Goldman
Hi, There are two different ways to reference a structure, dot-notation (struct.key) and associative-array notation (struct[key]). The dot notation usually works, unless the key starts with a numer. Then you need to use associative-array notation. To use dot-notation like you want to, try

RE: .jar files?

2001-08-23 Thread Brent Goldman
Hi, I was having the same problem. I spent hours on it, but I have no idea. Maybe someone else on this list knows. -Brent -Original Message- From: Christian Abad [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 10:53 AM To: CF-Talk Subject: .jar files? Folks: I am working

Re: Access memo fields truncated in GROUP BY?

2001-08-23 Thread Joseph Thompson
Interestingly enough I can have Access do the grouping internally (stored query) and get the values... I guess that will be my solution. If any one knows of a good reason not to do it this way please let me know. I take it that the 'Message' field is the Memo field? If so, try selecting

RE: Port for CFFTP

2001-08-23 Thread Robert Everland
That pretty much put a crimp in my plans as I had planned on using it on a development server, but for obvious reasons I only have certain ports open. Oh well. Bob Everland -Original Message- From: Howie Hamlin To: CF-Talk Sent: 8/23/01 6:39 PM Subject: Re: Port for CFFTP I just ran a

RE: regexp for swear filter

2001-08-23 Thread Bryan Love
oops, typo... listReplace(lcase(text),badList,goodList); should be replaceList(lcase(text),badList,goodList); Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED]

Creating CFX tags - DLL's and NT

2001-08-23 Thread Brian Fox
How can I force NT4.0 to reload a modified dll/cfx tag? Renaming the dll and adding it to the CFX list has become extremely tedious. Thanks, Brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at

  1   2   >