CF5.0 INSERT ERROR (URGENT)
hi i juz upgraded my server to CF5.0. When we try to do a insert, we realised that CF will automatically append a lot of garbage together with the values. Why is this so ?? and what can we do to resolve this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access memo fields truncated in GROUP BY?
Solution (well... sort of) This adds 5-10% to the query time but at least it works. No "Aggregate Function" = No GROUP BY = No truncation... I get that 5% back by storing the query in Access and calling that query through CF/ODBC SQL. What a day... =8-Þ (Special thanks again to Leon for convincing me to workaround this problem rather than continue "searching for a solution") SELECT Topics.Topic, Messages.Message, (SELECT TOP 1 Messages.TimeStamp FROM Messages WHERE Topics.ID=Messages.TopicID) AS NewestForumPost, > Stupid Query that just isn't going to work :-( > > > 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 > > EOF > -Joseph Thompson > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access memo fields truncated in GROUP BY?
Leon, thanks for that. I take back what I said about "native Access" queries allowing "memo" fields. They also truncate to 255 chars. >Leon 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 an ASP site once. I ended up using a separate SQL statement to get the memo fields like so: >Joseph (on Glue) > 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. Jeffry (a good guess) > > I take it that the 'Message' field is the Memo field? If so, try > > selecting that one last in the query... Stupid Query that just isn't going to work :-( > > 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 EOF -Joseph Thompson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfm-resources and default.htm
Hi People, Are any other users of the fabulous cfm-resources bronze service finding that default.htm is being served instead of index.cfm on their site? Or is it just me? Pablo? Tito? Thanks Mark Ireland [EMAIL PROTECTED] www.indiemusicdvd.com www.indiemusicdvd.com/index.cfm see what I mean? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: coldfusion and 31-bit numbers
Sorry to say but that's old news. Basically, CF only allows a 32 bit number for INTEGERS. This article I wrote about a year back gives a full rundown as well as all the functions that are affected. http://www.fusionauthority.com/alert/index.cfm?alertid=30#tech1 You can get around it by writing your own UDF to do the math for you rather than using the 'basic' CF functions. > Hi, > > You know, I just found a really huge ColdFusion limitation. It can only > work with numbers smaller than 2147483647, which is the same as 7FFF in > hex, 177 in OCT, and 111 in binary. It > seems that ColdFusion only allocated 31 bits of memory to each number (I > counted the 1's in binary). Because of this limitation, you can't use the > MOD operator, or the FormatBaseN and InputBaseN functions, of ColdFusion > using numbers bigger than 31 bits. It seems odd how ColdFusion would limit > a programmer like this. Are there any ways to get around this? > > -Brent > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating CFX tags - DLL's and NT
I'd imagine that you could use: Regsvr32 /u your.dll to unregister it and Regsvr32 your.dll to reregister it Not sure how effective this will be if you are keeping the DLL loaded.\ - Jay Sudowski -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 7:43 PM To: CF-Talk Subject: Creating CFX tags - DLL's and NT 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 http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Way Slow web pages
Make sure you don't have a corrupted entry in the database. If you're querying a field that has corrupt data, you can experience these symptoms. Also, make sure you have no rogue scripts running. Dave - Original Message - From: "Mueller, Ben" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 3:32 PM Subject: RE: OT: Way Slow web pages > 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. The page reads over a file directory, parses out some data > from those files (some XML, some CF) and inserts information into our > database (SQL 7). I've stripped the code down in an attempt to isolate bad > code, but so far I haven't found an obvious culprit. Also, we've checked > all the standard things: hanging threads, memory leaks, etc, and so far all > of that stuff looks normal. > > 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 the > slow-down is happening or not. > > We never saw this problem under 4.5, and cycling the service fixes the > problem. > > Granted, we haven't had as much time as we'd like to isolate the problem, so > it could be a configuration problem on our server, or bad code, but the > problem cropped up just after we upgraded to CF 5. > > > > > -Original Message- > From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 2:21 PM > To: CF-Talk > Subject: RE: OT: Way Slow web pages > > > 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 virus it will not catch. > 7. Coding/scripting is the same when the pages were running fine. same > page/code was running ~200, is not at ~2,000. > > > -Original Message- > From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 12:11 PM > To: CF-Talk > Subject: Re: OT: Way Slow web pages > > > 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 > >Date: Thu, 23 Aug 2001 12:04:37 -0700 > > > >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 Access and > >SQL backed web pages. > > > >Access itself seems to be running fine. but SQL Manager seems to be > >running > >real slow. takes over 2 mins to just display a list of the tables when a > >db > >is chosen. and then almost 4 mins to display the design table. > > > >I have reviewed the logs, the only listing, but is not consistent is that > >the administrator account fails on accessing \winlogon Object type: > >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. > >but this is not going on all the time. This will happen for about 3 mins > >then stop. > > > >the changes to the server I can think of, MS office and SQL 7 have both > >been > >reloaded. This is not an active server, once this problem gets fixed, it > >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual > >800mhz CPUs. using CF 5. > >I have tried to turn the different services off,(CF, WEB, SQL), but this > >does not affect the problem. > >I am at a loss. any suggestions will be appreciated. > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Send SMS
Hi Is there anybody from singapore who have tried to send sms message with Coldfusion? I urgently need to know how it can be done. Any help will be much appreciated. Jaime Hoi ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
coldfusion and 31-bit numbers
Hi, You know, I just found a really huge ColdFusion limitation. It can only work with numbers smaller than 2147483647, which is the same as 7FFF in hex, 177 in OCT, and 111 in binary. It seems that ColdFusion only allocated 31 bits of memory to each number (I counted the 1's in binary). Because of this limitation, you can't use the MOD operator, or the FormatBaseN and InputBaseN functions, of ColdFusion using numbers bigger than 31 bits. It seems odd how ColdFusion would limit a programmer like this. Are there any ways to get around this? -Brent ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Graphics Automation
It sounds like our product activescan from www.cfdev.com would handle that with a little bit of programming and a scheduled task. Gary cfdev.com http://www.cfdev.com - Original Message - From: "Fuon See Tu" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 12:33 PM Subject: Graphics Automation > 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 certain > width (but keeping the proportions), then uploaded to the web. does anyone > know of a way to do this? or a close way? hehe > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating CFX tags - DLL's and NT
Unselect "Keep Library Loaded" option. See cf administrator. Mike > -Original Message- > From: Brian Fox [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 4:43 PM > To: CF-Talk > Subject: Creating CFX tags - DLL's and NT > > 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 http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: .jar files?
>On Thu, 23 Aug 2001, Christian Abad wrote: > Does ColdFusion recognize and "un-jar" .jar files if they are in the "Class > Path" under Java Settings in the Administrator? yes, the jar file ITSELF (not the directory) must be on the classpath in the cfadministrator ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Creating CFX tags - DLL's and NT
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 http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: regexp for swear filter
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]
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 9:40 AM
To: CF-Talk
Subject: RE: regexp for swear filter
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 banana drove the car into the apple at high speed. The apple
was upset."
listReplace(lcase(text),badList,goodList);
result = "this ** drove the *** into the at high speed, The
was upset."
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 2:54 AM
To: CF-Talk
Subject: regexp for swear filter
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 speed. The apple
was upset."
result = "this ** drove the *** into the at high speed, The
was upset."
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 work (bearing in mind I'm not great at regexps)?
rereplacenocase(thistext, "#list#", "#rereplace(list, '[^\|]', '*',
'ALL')#", "ALL")
hmmm even I'm not sure about that.
---
Rich Wild
Senior Web Developer
---
e-mango.com ltd Tel: 01202 587 400
Lansdowne Place Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth Mailto:[EMAIL PROTECTED]
BH8 8EW, UK http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Port for CFFTP
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 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 port used is dynamic. Please let me know if I can help any further. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 6:09 PM Subject: Port for CFFTP > 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 Extraordinaire > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access memo fields truncated in GROUP BY?
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 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 that??? > > HTH, > Jeff > > -Original Message- > From: Joseph Thompson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 10:18 PM > To: CF-Talk > Subject: Access memo fields truncated in GROUP BY? > > Something I hadn't noticed before. What's up with Access, Memo fields, > and > joins? > > If you include a memo field in a GROUP BY it gets truncated to 255 > chars... > not the desired effect here. If I remove the MAX() ..and then don't > require > the GROUP BY then the field is not truncated... > > If there is a solution I would love to hear it. (feeling perplexed) > > (the simplified non-working query) > > > SELECT > Messages.Message, > Max(Messages.TimeStamp) As NewMessage, > Topics.Topic > FROM > Messages INNER JOIN Topics ON Messages.TopicID=Topics.ID > GROUP BY > Topics.Topic, > Messages.Message > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: .jar files?
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 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 archive and copy the classes into the sub-directory of what is set in the "Class Path". (This is very messy...) Any ideas on how to make ColdFusion 4.51 Server recognize these .jar files so I can leave the ENTIRE archive in a single directory? Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Structure notation
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 this:
#evaluate("structure.substructure." & x)#
-Brent
-Original Message-
From: Tim Dempsey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 7:39 AM
To: CF-Talk
Subject: Structure notation
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 have seen examples of structure_name.element_name being allowed and
now I see that the new O'Reilly ColdFusion book lists object notation like
that as one of the ways to reference structure elements.
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.
Is either one the preferred notation for any reason? Better performance?
More accepted style? etc. etc.
I found one case where the bracket notation seemed to be required: the name
of the element was itself a variable, specifically, the result of a
function. For example:
I couldn't say structure.substructure.#Evaluate("#x#")
How come?
Thanks for any insight you can give.
-- Tim Dempsey
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access memo fields truncated in GROUP BY?
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 an ASP site once. I ended up using a separate SQL statement to get the memo fields like so: query: a Select ID,stuff,stuff FROM foo,bar WHERE Query: b Select longfield FROM foo WHERE ID = b.ID There is more information about this on the net if you search for the ODBC Error message you get back. Leon -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 5:41 PM To: CF-Talk Subject: Re: Access memo fields truncated in GROUP BY? 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 better know that I have found other people with the same "unresolved" problem: I have a "workaround" in mind but this evening I will continue to poke around. > 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 that??? > > HTH, > Jeff > > -Original Message- > From: Joseph Thompson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 10:18 PM > To: CF-Talk > Subject: Access memo fields truncated in GROUP BY? > > Something I hadn't noticed before. What's up with Access, Memo fields, > and > joins? > > If you include a memo field in a GROUP BY it gets truncated to 255 > chars... > not the desired effect here. If I remove the MAX() ..and then don't > require > the GROUP BY then the field is not truncated... > > If there is a solution I would love to hear it. (feeling perplexed) > > (the simplified non-working query) > > > SELECT > Messages.Message, > Max(Messages.TimeStamp) As NewMessage, > Topics.Topic > FROM > Messages INNER JOIN Topics ON Messages.TopicID=Topics.ID > GROUP BY > Topics.Topic, > Messages.Message > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk "to & from" wierdness
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, Eric [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 5:57 AM To: CF-Talk Subject: CF-Talk "to & from" wierdness 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 Outlook to throw a message into a folder based on the content of the TO field (why dosn't Qualcomm make an enterprise Eudora client ;). Eric Carlisle ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access memo fields truncated in GROUP BY?
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 better know that I have found other people with the same "unresolved" problem: I have a "workaround" in mind but this evening I will continue to poke around. > 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 that??? > > HTH, > Jeff > > -Original Message- > From: Joseph Thompson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 10:18 PM > To: CF-Talk > Subject: Access memo fields truncated in GROUP BY? > > Something I hadn't noticed before. What's up with Access, Memo fields, > and > joins? > > If you include a memo field in a GROUP BY it gets truncated to 255 > chars... > not the desired effect here. If I remove the MAX() ..and then don't > require > the GROUP BY then the field is not truncated... > > If there is a solution I would love to hear it. (feeling perplexed) > > (the simplified non-working query) > > > SELECT > Messages.Message, > Max(Messages.TimeStamp) As NewMessage, > Topics.Topic > FROM > Messages INNER JOIN Topics ON Messages.TopicID=Topics.ID > GROUP BY > Topics.Topic, > Messages.Message > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Port for CFFTP
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 port used is dynamic. Please let me know if I can help any further. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 6:09 PM Subject: Port for CFFTP > 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 Extraordinaire > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Structures
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 PROTECTED]] Sent: Wednesday, August 22, 2001 10:07 PM To: CF-Talk Subject: Structures Can structures be utilised on a per client/session basis or are they global? Also does anyone know how to "stress test" a server online? Cheers! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (Access)Selecting randomly record
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 Subject: (Access)Selecting randomly record hello.. Can anyone of you help me in this prob below: how to randomly pull out data from the database. Let say I have 20 records in my database..and i want to randomly pull out the data by displaying 5 records at at a time. Does anyone of you know how to do? thanx... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Port for CFFTP
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) connects to ftp server client sends PORT command to specify a *client side* port for data transfer. data transfer is now accomplished by the ftp server connecting to the specified port on the client for data transfer. If the client does not specify a port then port 20 is used on the client side by default. If the client uses new ftp protocol features then the server supplies the data port (PASV command) Here is an example PORT command: PORT 25,50,75,1,12,55 The first four numbers refer to the IP address of the client. The last two are the port (in the above example the port is 12*256+55=3127) So, bottom line is that if CF uses the old style PORT interface then you need to have all your incoming ports available for ftp data transfer. Please let me know if you need more information... HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 6:09 PM Subject: Port for CFFTP > 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 Extraordinaire > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Port for CFFTP
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 Extraordinaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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: Thursday, August 23, 2001 2:57 PM To: CF-Talk Subject: RE: OT: Way Slow web pages 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 Message- > From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 5:43 PM > To: CF-Talk > Subject: RE: OT: Way Slow web pages > > > > 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 for all the suggestions and help. > > -Original Message- > From: Kwang Suh [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 1:20 PM > To: CF-Talk > Subject: Re: OT: Way Slow web pages > > > 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 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 > > Subject: RE: OT: Way Slow web pages > > > > > > 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 > > > > > > 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 virus it > will not catch. > > 7. Coding/scripting is the same when the pages were > running fine. same > > page/code was running ~200, is not at ~2,000. > > > > > > -Original Message- > > From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 23, 2001 12:11 PM > > To: CF-Talk > > Subject: Re: OT: Way Slow web pages > > > > > > 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 > > >Date: Thu, 23 Aug 2001 12:04:37 -0700 > > > > > >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 Access and > > >SQL backed web pages. > > > > > >Access itself seems to be running fine. but SQL Manager > seems to be > > >running > > >real slow. takes over 2 mins to just display a list of > the tables when a > > >db > > >is chosen. and then almost 4 mins to display the design table. > > > > > >I have reviewed the logs, the only listing, but is not > consistent is that > > >the administrator account fails on accessing \winlogon > Object type: > > >desktop. EventID: 560 looks to be trying the access > \winlogon once a > sec. > > >but this is not going on all the time. This will happen > for about 3 mins > > >then stop. > > > > > >the changes to the server I can think of, MS office and > SQL 7 have both > > >been > > >reloaded. This is not an active server, once this problem > gets fixed, it > > >will be, so work load is not a factor. It is a WINNT 4.0, > 1 GB RAM, dual > > >800mhz CPUs. using CF 5. > > >I have tried to turn the different services off,(CF, WEB, > SQL), but this > > >does not affect the problem. > > >I am at a loss. any suggestions will be appreciated. > > > > > > > > > ~~ St
RE: OT: Way Slow web pages
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 Message- > From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 5:43 PM > To: CF-Talk > Subject: RE: OT: Way Slow web pages > > > > 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 for all the suggestions and help. > > -Original Message- > From: Kwang Suh [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 1:20 PM > To: CF-Talk > Subject: Re: OT: Way Slow web pages > > > 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 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 > > Subject: RE: OT: Way Slow web pages > > > > > > 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 > > > > > > 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 virus it > will not catch. > > 7. Coding/scripting is the same when the pages were > running fine. same > > page/code was running ~200, is not at ~2,000. > > > > > > -Original Message- > > From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 23, 2001 12:11 PM > > To: CF-Talk > > Subject: Re: OT: Way Slow web pages > > > > > > 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 > > >Date: Thu, 23 Aug 2001 12:04:37 -0700 > > > > > >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 Access and > > >SQL backed web pages. > > > > > >Access itself seems to be running fine. but SQL Manager > seems to be > > >running > > >real slow. takes over 2 mins to just display a list of > the tables when a > > >db > > >is chosen. and then almost 4 mins to display the design table. > > > > > >I have reviewed the logs, the only listing, but is not > consistent is that > > >the administrator account fails on accessing \winlogon > Object type: > > >desktop. EventID: 560 looks to be trying the access > \winlogon once a > sec. > > >but this is not going on all the time. This will happen > for about 3 mins > > >then stop. > > > > > >the changes to the server I can think of, MS office and > SQL 7 have both > > >been > > >reloaded. This is not an active server, once this problem > gets fixed, it > > >will be, so work load is not a factor. It is a WINNT 4.0, > 1 GB RAM, dual > > >800mhz CPUs. using CF 5. > > >I have tried to turn the different services off,(CF, WEB, > SQL), but this > > >does not affect the problem. > > >I am at a loss. any suggestions will be appreciated. > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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 for all the suggestions and help. -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 1:20 PM To: CF-Talk Subject: Re: OT: Way Slow web pages 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 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 > Subject: RE: OT: Way Slow web pages > > > 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 > > > 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 virus it will not catch. > 7. Coding/scripting is the same when the pages were running fine. same > page/code was running ~200, is not at ~2,000. > > > -Original Message- > From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 12:11 PM > To: CF-Talk > Subject: Re: OT: Way Slow web pages > > > 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 > >Date: Thu, 23 Aug 2001 12:04:37 -0700 > > > >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 Access and > >SQL backed web pages. > > > >Access itself seems to be running fine. but SQL Manager seems to be > >running > >real slow. takes over 2 mins to just display a list of the tables when a > >db > >is chosen. and then almost 4 mins to display the design table. > > > >I have reviewed the logs, the only listing, but is not consistent is that > >the administrator account fails on accessing \winlogon Object type: > >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. > >but this is not going on all the time. This will happen for about 3 mins > >then stop. > > > >the changes to the server I can think of, MS office and SQL 7 have both > >been > >reloaded. This is not an active server, once this problem gets fixed, it > >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual > >800mhz CPUs. using CF 5. > >I have tried to turn the different services off,(CF, WEB, SQL), but this > >does not affect the problem. > >I am at a loss. any suggestions will be appreciated. > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
> 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 the slow-down is happening > or not. In this case, maybe your problem isn't with the CF service itself, but rather with the communication between the service and the web server. I don't know how you'd fix that; you might search for "ISAPI" on http://support.microsoft.com/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfx problem
> 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. You can find this out using the Dependency Checker tool (depends.exe) which comes with the NT 4 Resource Kit, or with the Windows 2000 Support Tools (which are on the Windows 2000 Server CD). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and PDAs
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 -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 think the nsBasic folks are releasing some conduit tools soon as well.. pps. this topic is pretty far off topic now, eh? > -Original Message- > From: Shawn Regan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 1:52 PM > To: CF-Talk > Subject: RE: CF and PDAs > > > 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 Developer > Pacific Technology Solutions > -BEGIN PGP SIGNATURE- Version: PGP 6.5.8 iQA/AwUBO4Ve894WdA43RP/AEQJx7ACbBqRNJf6oIKDk4kFOacm8QN/wfhUAn2xG Ry63hGC1Cg1UJUgoh0g+xA7i =LXMl -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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 To: CF-Talk Subject: Re: OT: Way Slow web pages 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 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 > > > 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 virus it will not catch. > 7. Coding/scripting is the same when the pages were running fine. same > page/code was running ~200, is not at ~2,000. > > > -Original Message- > From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 12:11 PM > To: CF-Talk > Subject: Re: OT: Way Slow web pages > > > 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 > >Date: Thu, 23 Aug 2001 12:04:37 -0700 > > > >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 Access and > >SQL backed web pages. > > > >Access itself seems to be running fine. but SQL Manager seems to be > >running > >real slow. takes over 2 mins to just display a list of the tables when a > >db > >is chosen. and then almost 4 mins to display the design table. > > > >I have reviewed the logs, the only listing, but is not consistent is that > >the administrator account fails on accessing \winlogon Object type: > >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. > >but this is not going on all the time. This will happen for about 3 mins > >then stop. > > > >the changes to the server I can think of, MS office and SQL 7 have both > >been > >reloaded. This is not an active server, once this problem gets fixed, it > >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual > >800mhz CPUs. using CF 5. > >I have tried to turn the different services off,(CF, WEB, SQL), but this > >does not affect the problem. > >I am at a loss. any suggestions will be appreciated. > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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, 2001 4:20 PM To: CF-Talk Subject: Re: OT: Way Slow web pages 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 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 > > > 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 virus it will not catch. > 7. Coding/scripting is the same when the pages were running fine. same > page/code was running ~200, is not at ~2,000. > > > -Original Message- > From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 12:11 PM > To: CF-Talk > Subject: Re: OT: Way Slow web pages > > > 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 > >Date: Thu, 23 Aug 2001 12:04:37 -0700 > > > >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 Access and > >SQL backed web pages. > > > >Access itself seems to be running fine. but SQL Manager seems to be > >running > >real slow. takes over 2 mins to just display a list of the tables when a > >db > >is chosen. and then almost 4 mins to display the design table. > > > >I have reviewed the logs, the only listing, but is not consistent is that > >the administrator account fails on accessing \winlogon Object type: > >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. > >but this is not going on all the time. This will happen for about 3 mins > >then stop. > > > >the changes to the server I can think of, MS office and SQL 7 have both > >been > >reloaded. This is not an active server, once this problem gets fixed, it > >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual > >800mhz CPUs. using CF 5. > >I have tried to turn the different services off,(CF, WEB, SQL), but this > >does not affect the problem. > >I am at a loss. any suggestions will be appreciated. > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Way Slow web pages
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 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 > > > 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 virus it will not catch. > 7. Coding/scripting is the same when the pages were running fine. same > page/code was running ~200, is not at ~2,000. > > > -Original Message- > From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 12:11 PM > To: CF-Talk > Subject: Re: OT: Way Slow web pages > > > 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 > >Date: Thu, 23 Aug 2001 12:04:37 -0700 > > > >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 Access and > >SQL backed web pages. > > > >Access itself seems to be running fine. but SQL Manager seems to be > >running > >real slow. takes over 2 mins to just display a list of the tables when a > >db > >is chosen. and then almost 4 mins to display the design table. > > > >I have reviewed the logs, the only listing, but is not consistent is that > >the administrator account fails on accessing \winlogon Object type: > >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. > >but this is not going on all the time. This will happen for about 3 mins > >then stop. > > > >the changes to the server I can think of, MS office and SQL 7 have both > >been > >reloaded. This is not an active server, once this problem gets fixed, it > >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual > >800mhz CPUs. using CF 5. > >I have tried to turn the different services off,(CF, WEB, SQL), but this > >does not affect the problem. > >I am at a loss. any suggestions will be appreciated. > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Way Slow web pages
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 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 > Subject: RE: OT: Way Slow web pages > > > 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 > > > 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 virus it will not catch. > 7. Coding/scripting is the same when the pages were running fine. same > page/code was running ~200, is not at ~2,000. > > > -Original Message- > From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 12:11 PM > To: CF-Talk > Subject: Re: OT: Way Slow web pages > > > 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 > >Date: Thu, 23 Aug 2001 12:04:37 -0700 > > > >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 Access and > >SQL backed web pages. > > > >Access itself seems to be running fine. but SQL Manager seems to be > >running > >real slow. takes over 2 mins to just display a list of the tables when a > >db > >is chosen. and then almost 4 mins to display the design table. > > > >I have reviewed the logs, the only listing, but is not consistent is that > >the administrator account fails on accessing \winlogon Object type: > >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. > >but this is not going on all the time. This will happen for about 3 mins > >then stop. > > > >the changes to the server I can think of, MS office and SQL 7 have both > >been > >reloaded. This is not an active server, once this problem gets fixed, it > >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual > >800mhz CPUs. using CF 5. > >I have tried to turn the different services off,(CF, WEB, SQL), but this > >does not affect the problem. > >I am at a loss. any suggestions will be appreciated. > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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 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 taking ~900ms. the few pages without any queries seem to ok. This is happening in both ACCESS and SQL 7, We are testing the same pages with both and both are taking this performance hit, so its not just Access being slow or SQL having a problem. Next option I can think of which I DON'T want to do would be to reload CF. just reloaded SQL and ACCESS. Thanks for the info -Original Message- From: Mueller, Ben [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:33 PM To: CF-Talk Subject: RE: OT: Way Slow web pages 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. The page reads over a file directory, parses out some data from those files (some XML, some CF) and inserts information into our database (SQL 7). I've stripped the code down in an attempt to isolate bad code, but so far I haven't found an obvious culprit. Also, we've checked all the standard things: hanging threads, memory leaks, etc, and so far all of that stuff looks normal. 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 the slow-down is happening or not. We never saw this problem under 4.5, and cycling the service fixes the problem. Granted, we haven't had as much time as we'd like to isolate the problem, so it could be a configuration problem on our server, or bad code, but the problem cropped up just after we upgraded to CF 5. -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 2:21 PM To: CF-Talk Subject: RE: OT: Way Slow web pages 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 virus it will not catch. 7. Coding/scripting is the same when the pages were running fine. same page/code was running ~200, is not at ~2,000. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:11 PM To: CF-Talk Subject: Re: OT: Way Slow web pages 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 >Date: Thu, 23 Aug 2001 12:04:37 -0700 > >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 Access and >SQL backed web pages. > >Access itself seems to be running fine. but SQL Manager seems to be >running >real slow. takes over 2 mins to just display a list of the tables when a >db >is chosen. and then almost 4 mins to display the design table. > >I have reviewed the logs, the only listing, but is not consistent is that >the administrator account fails on accessing \winlogon Object type: >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. >but this is not going on all the time. This will happen for about 3 mins >then stop. > >the changes to the server I can think of, MS office and SQL 7 have both >been >reloaded. This is not an active server, once this problem gets fixed, it >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual >800mhz CPUs. using CF 5. >I have tried to turn the different services off,(CF, WEB, SQL), but this >does not affect the problem. >I am at a loss. any suggestions will be appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofi
RE: OT: Way Slow web pages
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 Subject: RE: OT: Way Slow web pages 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 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 virus it will not catch. 7. Coding/scripting is the same when the pages were running fine. same page/code was running ~200, is not at ~2,000. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:11 PM To: CF-Talk Subject: Re: OT: Way Slow web pages 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 >Date: Thu, 23 Aug 2001 12:04:37 -0700 > >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 Access and >SQL backed web pages. > >Access itself seems to be running fine. but SQL Manager seems to be >running >real slow. takes over 2 mins to just display a list of the tables when a >db >is chosen. and then almost 4 mins to display the design table. > >I have reviewed the logs, the only listing, but is not consistent is that >the administrator account fails on accessing \winlogon Object type: >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. >but this is not going on all the time. This will happen for about 3 mins >then stop. > >the changes to the server I can think of, MS office and SQL 7 have both >been >reloaded. This is not an active server, once this problem gets fixed, it >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual >800mhz CPUs. using CF 5. >I have tried to turn the different services off,(CF, WEB, SQL), but this >does not affect the problem. >I am at a loss. any suggestions will be appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Structure notation
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 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 have seen examples of structure_name.element_name being allowed and
> now I see that the new O'Reilly ColdFusion book lists object notation like
> that as one of the ways to reference structure elements.
>
> 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.
>
> Is either one the preferred notation for any reason? Better performance?
> More accepted style? etc. etc.
>
> I found one case where the bracket notation seemed to be required: the
name
> of the element was itself a variable, specifically, the result of a
> function. For example:
>
>
>
> I couldn't say structure.substructure.#Evaluate("#x#")
>
> How come?
>
> Thanks for any insight you can give.
>
>
> -- Tim Dempsey
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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 taking ~900ms. the few pages without any queries seem to ok. This is happening in both ACCESS and SQL 7, We are testing the same pages with both and both are taking this performance hit, so its not just Access being slow or SQL having a problem. Next option I can think of which I DON'T want to do would be to reload CF. just reloaded SQL and ACCESS. Thanks for the info -Original Message- From: Mueller, Ben [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:33 PM To: CF-Talk Subject: RE: OT: Way Slow web pages 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. The page reads over a file directory, parses out some data from those files (some XML, some CF) and inserts information into our database (SQL 7). I've stripped the code down in an attempt to isolate bad code, but so far I haven't found an obvious culprit. Also, we've checked all the standard things: hanging threads, memory leaks, etc, and so far all of that stuff looks normal. 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 the slow-down is happening or not. We never saw this problem under 4.5, and cycling the service fixes the problem. Granted, we haven't had as much time as we'd like to isolate the problem, so it could be a configuration problem on our server, or bad code, but the problem cropped up just after we upgraded to CF 5. -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 2:21 PM To: CF-Talk Subject: RE: OT: Way Slow web pages 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 virus it will not catch. 7. Coding/scripting is the same when the pages were running fine. same page/code was running ~200, is not at ~2,000. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:11 PM To: CF-Talk Subject: Re: OT: Way Slow web pages 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 >Date: Thu, 23 Aug 2001 12:04:37 -0700 > >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 Access and >SQL backed web pages. > >Access itself seems to be running fine. but SQL Manager seems to be >running >real slow. takes over 2 mins to just display a list of the tables when a >db >is chosen. and then almost 4 mins to display the design table. > >I have reviewed the logs, the only listing, but is not consistent is that >the administrator account fails on accessing \winlogon Object type: >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. >but this is not going on all the time. This will happen for about 3 mins >then stop. > >the changes to the server I can think of, MS office and SQL 7 have both >been >reloaded. This is not an active server, once this problem gets fixed, it >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual >800mhz CPUs. using CF 5. >I have tried to turn the different services off,(CF, WEB, SQL), but this >does not affect the problem. >I am at a loss. any suggestions will be appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bug in CF5 (Using CFQUERY to insert data)
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 the support. - Original Message - From: "O'Connor-Rose, Joshua" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 2:47 PM Subject: RE: Bug in CF5 (Using CFQUERY to insert data) > 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 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 - > From: "O'Connor-Rose, Joshua" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, August 23, 2001 2:29 PM > Subject: RE: Bug in CF5 (Using CFQUERY to insert data) > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bug in CF5 (Using CFQUERY to insert data)
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 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 - From: "O'Connor-Rose, Joshua" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 2:29 PM Subject: RE: Bug in CF5 (Using CFQUERY to insert data) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bug in CF5 (Using CFQUERY to insert data)
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 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 - From: "O'Connor-Rose, Joshua" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 2:29 PM Subject: RE: Bug in CF5 (Using CFQUERY to insert data) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bug in CF5 (Using CFQUERY to insert data)
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 to insert data) > 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 - > From: "O'Connor-Rose, Joshua" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, August 23, 2001 2:29 PM > Subject: RE: Bug in CF5 (Using CFQUERY to insert data) > > > > (-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 somewhere. (Where should we post bugs?) > > > > > > -- > > First for the searchers out there: Unexpected exception[3] > > (this is the error that comes up in the server log when this error occurs) > > > > I can crash CF5 for sure every time the following conditions exists. > > > > 1. My application uses a datasource for client management. (either by > > default as set up in the administrator or defined by the clientStorage > > attribute of the cfapplication tag). And also has client management turned > > on. > > > > 2. I use cfquery to insert a row into a table where: > > -the datasource is the same datasource that clientStorage is pointing to > > -A value that is not being set in the insert statement does not accept > nulls > > and has no default value set in the database. > > -the database is either MS-SQL7 or MS-SQL2000 and the connection is ODBC > > > > 3. This is the strange one > > CFPARAM is set on the page to certain named values (not all will make it > > crash) > > So far the only names I have tested are "test" and "legalReferers" (both > > will crash CF5) and "subButton" (won't crash cf5) (maybe it's the letter > > 'e'?) > > > > --- > > Symptoms: (to describe how this bug acts) > > You call a page that has the conditions above set on it: > > > > Instead of getting the expected error: > > > > > > << > > ODBC Error Code = 23000 (Integrity constraint violation) > > > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value > NULL > > into column 'NoDefault', table 'testCFcrash.dbo.CrashTest'; column does > not > > allow nulls. insert fails. >> > > > > (etc.) > > > > You get something that looks like this: > > > > > > << > > Error Diagnostic Information > > Error occurred for unknown cause. > > > > Normally the reason for this error is that a critical system resource > (such > > as memory or disk space) has been expended. You should check the available > > disk space on all of your drives to make sure you have not run out. You > > should also make sure that you are not running out of memory by running > the > > Performance Monitor and observing the effect of your application on free > > system memory. > > > > Another reason for this error may be that your ODBC driver is generating a > > general protection fault. To help verify that your driver is funtioning > > properly you should attempt to submit the query which is causing this > error > > to the data source using another ODBC application (such as MS Access or MS > > Query). > > >> > > > > > > > > Eventually if this page is called repeatedly or similar inserts are > > attempted repeatedly. Other messages may show up: > > > > > > > > << > > Request canceled or ignored by serverServer busy or unable to fulfill > > request. The server is unable to fulfill your request due to extremely > high > > traffic or an unexpected internal error. Please attempt your request again > > (if you are repeatedly unsuccessful you should notify the site > > administrator). (Location Code: 26) > > >> > > > > > > > > or similar server unavailable messages will happen. Sometimes while I was > > testing CF would recover all on it's own (actually most times) by > restarting > > the service itself. There were other times when we had to start the server > > ourselves (but that may have been a test of patience) In either case it > > really shouldn't have gotten that far. > > ---end of symptoms > > > > I've attached a zipped version of my test page (cfapplication included in > > the page for testing.) ---this is on the allaire forums site--- > > -- > -- > > - > > > > Oh and be car
RE: CF and PDAs
-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 think the nsBasic folks are releasing some conduit tools soon as well.. pps. this topic is pretty far off topic now, eh? > -Original Message- > From: Shawn Regan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 1:52 PM > To: CF-Talk > Subject: RE: CF and PDAs > > > 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 Developer > Pacific Technology Solutions > -BEGIN PGP SIGNATURE- Version: PGP 6.5.8 iQA/AwUBO4Ve894WdA43RP/AEQJx7ACbBqRNJf6oIKDk4kFOacm8QN/wfhUAn2xG Ry63hGC1Cg1UJUgoh0g+xA7i =LXMl -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bug in CF5 (Using CFQUERY to insert data)
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 - From: "O'Connor-Rose, Joshua" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 2:29 PM Subject: RE: Bug in CF5 (Using CFQUERY to insert data) > (-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 somewhere. (Where should we post bugs?) > > > -- > First for the searchers out there: Unexpected exception[3] > (this is the error that comes up in the server log when this error occurs) > > I can crash CF5 for sure every time the following conditions exists. > > 1. My application uses a datasource for client management. (either by > default as set up in the administrator or defined by the clientStorage > attribute of the cfapplication tag). And also has client management turned > on. > > 2. I use cfquery to insert a row into a table where: > -the datasource is the same datasource that clientStorage is pointing to > -A value that is not being set in the insert statement does not accept nulls > and has no default value set in the database. > -the database is either MS-SQL7 or MS-SQL2000 and the connection is ODBC > > 3. This is the strange one > CFPARAM is set on the page to certain named values (not all will make it > crash) > So far the only names I have tested are "test" and "legalReferers" (both > will crash CF5) and "subButton" (won't crash cf5) (maybe it's the letter > 'e'?) > > --- > Symptoms: (to describe how this bug acts) > You call a page that has the conditions above set on it: > > Instead of getting the expected error: > > > << > ODBC Error Code = 23000 (Integrity constraint violation) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL > into column 'NoDefault', table 'testCFcrash.dbo.CrashTest'; column does not > allow nulls. insert fails. >> > > (etc.) > > You get something that looks like this: > > > << > Error Diagnostic Information > Error occurred for unknown cause. > > Normally the reason for this error is that a critical system resource (such > as memory or disk space) has been expended. You should check the available > disk space on all of your drives to make sure you have not run out. You > should also make sure that you are not running out of memory by running the > Performance Monitor and observing the effect of your application on free > system memory. > > Another reason for this error may be that your ODBC driver is generating a > general protection fault. To help verify that your driver is funtioning > properly you should attempt to submit the query which is causing this error > to the data source using another ODBC application (such as MS Access or MS > Query). > >> > > > > Eventually if this page is called repeatedly or similar inserts are > attempted repeatedly. Other messages may show up: > > > > << > Request canceled or ignored by serverServer busy or unable to fulfill > request. The server is unable to fulfill your request due to extremely high > traffic or an unexpected internal error. Please attempt your request again > (if you are repeatedly unsuccessful you should notify the site > administrator). (Location Code: 26) > >> > > > > or similar server unavailable messages will happen. Sometimes while I was > testing CF would recover all on it's own (actually most times) by restarting > the service itself. There were other times when we had to start the server > ourselves (but that may have been a test of patience) In either case it > really shouldn't have gotten that far. > ---end of symptoms > > I've attached a zipped version of my test page (cfapplication included in > the page for testing.) ---this is on the allaire forums site--- > -- -- > - > > Oh and be careful when you are updating your site and removing variables no > longer needed that still exist in the database. > > > > Could some one follow this up with where we should post bugs. > > Joshua O'Connor-Rose > Cognitive Arts > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?side
Re: cfx problem
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 http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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. The page reads over a file directory, parses out some data from those files (some XML, some CF) and inserts information into our database (SQL 7). I've stripped the code down in an attempt to isolate bad code, but so far I haven't found an obvious culprit. Also, we've checked all the standard things: hanging threads, memory leaks, etc, and so far all of that stuff looks normal. 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 the slow-down is happening or not. We never saw this problem under 4.5, and cycling the service fixes the problem. Granted, we haven't had as much time as we'd like to isolate the problem, so it could be a configuration problem on our server, or bad code, but the problem cropped up just after we upgraded to CF 5. -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 2:21 PM To: CF-Talk Subject: RE: OT: Way Slow web pages 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 virus it will not catch. 7. Coding/scripting is the same when the pages were running fine. same page/code was running ~200, is not at ~2,000. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:11 PM To: CF-Talk Subject: Re: OT: Way Slow web pages 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 >Date: Thu, 23 Aug 2001 12:04:37 -0700 > >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 Access and >SQL backed web pages. > >Access itself seems to be running fine. but SQL Manager seems to be >running >real slow. takes over 2 mins to just display a list of the tables when a >db >is chosen. and then almost 4 mins to display the design table. > >I have reviewed the logs, the only listing, but is not consistent is that >the administrator account fails on accessing \winlogon Object type: >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. >but this is not going on all the time. This will happen for about 3 mins >then stop. > >the changes to the server I can think of, MS office and SQL 7 have both >been >reloaded. This is not an active server, once this problem gets fixed, it >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual >800mhz CPUs. using CF 5. >I have tried to turn the different services off,(CF, WEB, SQL), but this >does not affect the problem. >I am at a loss. any suggestions will be appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bug in CF5 (Using CFQUERY to insert data)
(-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 somewhere. (Where should we post bugs?) -- First for the searchers out there: Unexpected exception[3] (this is the error that comes up in the server log when this error occurs) I can crash CF5 for sure every time the following conditions exists. 1. My application uses a datasource for client management. (either by default as set up in the administrator or defined by the clientStorage attribute of the cfapplication tag). And also has client management turned on. 2. I use cfquery to insert a row into a table where: -the datasource is the same datasource that clientStorage is pointing to -A value that is not being set in the insert statement does not accept nulls and has no default value set in the database. -the database is either MS-SQL7 or MS-SQL2000 and the connection is ODBC 3. This is the strange one CFPARAM is set on the page to certain named values (not all will make it crash) So far the only names I have tested are "test" and "legalReferers" (both will crash CF5) and "subButton" (won't crash cf5) (maybe it's the letter 'e'?) --- Symptoms: (to describe how this bug acts) You call a page that has the conditions above set on it: Instead of getting the expected error: << ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'NoDefault', table 'testCFcrash.dbo.CrashTest'; column does not allow nulls. insert fails. >> (etc.) You get something that looks like this: << Error Diagnostic Information Error occurred for unknown cause. Normally the reason for this error is that a critical system resource (such as memory or disk space) has been expended. You should check the available disk space on all of your drives to make sure you have not run out. You should also make sure that you are not running out of memory by running the Performance Monitor and observing the effect of your application on free system memory. Another reason for this error may be that your ODBC driver is generating a general protection fault. To help verify that your driver is funtioning properly you should attempt to submit the query which is causing this error to the data source using another ODBC application (such as MS Access or MS Query). >> Eventually if this page is called repeatedly or similar inserts are attempted repeatedly. Other messages may show up: << Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) >> or similar server unavailable messages will happen. Sometimes while I was testing CF would recover all on it's own (actually most times) by restarting the service itself. There were other times when we had to start the server ourselves (but that may have been a test of patience) In either case it really shouldn't have gotten that far. ---end of symptoms I've attached a zipped version of my test page (cfapplication included in the page for testing.) ---this is on the allaire forums site--- - Oh and be careful when you are updating your site and removing variables no longer needed that still exist in the database. Could some one follow this up with where we should post bugs. Joshua O'Connor-Rose Cognitive Arts ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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 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 virus it will not catch. 7. Coding/scripting is the same when the pages were running fine. same page/code was running ~200, is not at ~2,000. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:11 PM To: CF-Talk Subject: Re: OT: Way Slow web pages 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 >Date: Thu, 23 Aug 2001 12:04:37 -0700 > >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 Access and >SQL backed web pages. > >Access itself seems to be running fine. but SQL Manager seems to be >running >real slow. takes over 2 mins to just display a list of the tables when a >db >is chosen. and then almost 4 mins to display the design table. > >I have reviewed the logs, the only listing, but is not consistent is that >the administrator account fails on accessing \winlogon Object type: >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. >but this is not going on all the time. This will happen for about 3 mins >then stop. > >the changes to the server I can think of, MS office and SQL 7 have both >been >reloaded. This is not an active server, once this problem gets fixed, it >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual >800mhz CPUs. using CF 5. >I have tried to turn the different services off,(CF, WEB, SQL), but this >does not affect the problem. >I am at a loss. any suggestions will be appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bug in CF5 (Using CFQUERY to insert data)
(-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. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Way Slow web pages
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 virus it will not catch. 7. Coding/scripting is the same when the pages were running fine. same page/code was running ~200, is not at ~2,000. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 12:11 PM To: CF-Talk Subject: Re: OT: Way Slow web pages 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 >Date: Thu, 23 Aug 2001 12:04:37 -0700 > >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 Access and >SQL backed web pages. > >Access itself seems to be running fine. but SQL Manager seems to be >running >real slow. takes over 2 mins to just display a list of the tables when a >db >is chosen. and then almost 4 mins to display the design table. > >I have reviewed the logs, the only listing, but is not consistent is that >the administrator account fails on accessing \winlogon Object type: >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. >but this is not going on all the time. This will happen for about 3 mins >then stop. > >the changes to the server I can think of, MS office and SQL 7 have both >been >reloaded. This is not an active server, once this problem gets fixed, it >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual >800mhz CPUs. using CF 5. >I have tried to turn the different services off,(CF, WEB, SQL), but this >does not affect the problem. >I am at a loss. any suggestions will be appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bug in CF5 (Using CFQUERY to insert data)
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, 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 http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Bug in CF5 (Using CFQUERY to insert data)
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 http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Way Slow web pages
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 >Date: Thu, 23 Aug 2001 12:04:37 -0700 > >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 Access and >SQL backed web pages. > >Access itself seems to be running fine. but SQL Manager seems to be >running >real slow. takes over 2 mins to just display a list of the tables when a >db >is chosen. and then almost 4 mins to display the design table. > >I have reviewed the logs, the only listing, but is not consistent is that >the administrator account fails on accessing \winlogon Object type: >desktop. EventID: 560 looks to be trying the access \winlogon once a sec. >but this is not going on all the time. This will happen for about 3 mins >then stop. > >the changes to the server I can think of, MS office and SQL 7 have both >been >reloaded. This is not an active server, once this problem gets fixed, it >will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual >800mhz CPUs. using CF 5. >I have tried to turn the different services off,(CF, WEB, SQL), but this >does not affect the problem. >I am at a loss. any suggestions will be appreciated. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Way Slow web pages
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 Access and SQL backed web pages. Access itself seems to be running fine. but SQL Manager seems to be running real slow. takes over 2 mins to just display a list of the tables when a db is chosen. and then almost 4 mins to display the design table. I have reviewed the logs, the only listing, but is not consistent is that the administrator account fails on accessing \winlogon Object type: desktop. EventID: 560 looks to be trying the access \winlogon once a sec. but this is not going on all the time. This will happen for about 3 mins then stop. the changes to the server I can think of, MS office and SQL 7 have both been reloaded. This is not an active server, once this problem gets fixed, it will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual 800mhz CPUs. using CF 5. I have tried to turn the different services off,(CF, WEB, SQL), but this does not affect the problem. I am at a loss. any suggestions will be appreciated. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Four Selects Related.
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 [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 7:32 AM > To: CF-Talk > Subject: RE: Four Selects Related. > > 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 > Subject: Re: Four Selects Related. > > > I am up to ten related boxes now via qForms populate() function and > everything works great. Also love the error checking I am able to > establish > via qForms. > > Snipe - > > > - Original Message - > From: "Paul Ihrig" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 22, 2001 8:13 PM > Subject: RE: Four Selects Related. > > > > your going to have to give a demo at cfug > > or have you done this already? > > > > -paul > > > > -Original Message- > > From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 22, 2001 1:33 PM > > To: CF-Talk > > Subject: RE: Four Selects Related. > > > > > > Paul, > > > > Using qForms it's pretty easy to this. Since it's OO-orientated, doing 4 > > isn't much different from doing 2. I know people that have done as many > > as 8 related select boxes (and somebody has probably done more than > > that.) > > > > qForms: > > http://www.pengoworks.com/qForms/ > > > > -Dan > > > > > -Original Message- > > > From: Paul Ihrig [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, August 22, 2001 11:41 AM > > > To: CF-Talk > > > Subject: Four Selects Related. > > > > > > Good afternoon. > > > i was looking at Three Selects Related (Nate Weiss) > > > > > > i need to be able to do 4 Selects Related. > > > if any one knows of a tag that would do this i would appreciate it. > > > > > > if you could also cc me directly i would appreciate it, since i am > > having > > > problems with external mail at the moment. > > > > > > -paul > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL help/group in CFOUTPUT not working??????
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 -Rice -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 1:12 PM To: CF-Talk Subject: RE: SQL help/group in CFOUTPUT not working?? 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 23, 2001 1:00 PM > To: CF-Talk > Subject: RE: SQL help/group in CFOUTPUT not working?? > > > > 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 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 iCasacApptID is found in > the cats table twice, then two records are outputed in > my report instead of oneso, if there are 2 > TreatSelects to one CasacApptID, then I want that to > be one row..I though that > > > > #QRYtp.TreatSelect# > > > > > would accomplish thisbut it isnt. here is my code > belowcan anyone see what I am missing... > > Thanks yet again! > > > > > > > > > > Select cas.iClientID , >cd1.vCodeDecode as TreatSelect, >cas.iCasacApptID, >'#treatCount.TreatProgID#' as TrueProgID, >'#treatCount.TreatProg#' as TrueProg, >'#treatCount.HRACode#' as TrueHRA > From CasacAppt cas, > CasacApptTreatSelect cats, > CodeDecode cd1 > Where '#treatCount.TreatProgID#' = cas.iTreatProgID > and cas.iCasacApptID = cats.iCasacApptID > AND cats.cTreatSelectID = cd1.icodedecodeID > AND cas.dCasacDate = '#variables.DBeginDate#' > AND cas.dCasacDate <= '#variables.dEndDate#' > AND cas.iCasacApptID in (select cs.icasacApptID > from CasacApptTreatSelect cs) > > Union > > Select cas.iClientID , > 'None' as TreatSelect, > cas.iCasacApptID, > '#treatCount.TreatProgID#' as TrueProgID, > '#treatCount.TreatProg#' as TrueProg, > '#treatCount.HRACode#' as TrueHRA > From CasacAppt cas, > CodeDecode cd1, > Client cl > Where cas.iClientID = cl.iClientID > AND '#treatCount.TreatProgID#' = cas.iTreatProgID > > AND cas.dCasacDate >= '#variables.DBeginDate#' > AND cas.dCasacDate <= '#variables.dEndDate#' > AND cas.iCasacApptID not in (select > cs.icasacApptID from CasacApptTreatSelect cs) > > > > > > > >#QRYtp.iCasacApptID# >#QRYtp.TrueProg# >#QRYtp.iClientID# > > > > > #QRYtp.TreatSelect# > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfx problem
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 loading cfx custom tag library The library associated with the custom tag cfx_BRANCHSUM (C:\CFusion\cfx\branchsum.dll) was not found. Please check the LibraryPath entry for this tag in the custom tag database to verify that the library file exists and is accessible by the Cold Fusion service. The error occurred while processing an element with a general identifier of (CFX_BRANCHSUM), occupying document position (5:1) to (7:20). Jordon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 5.00 Beta 2: Accessing database list on local machine (UPDATE!)
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 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 5.00 Beta 2: Accessing database list on local machine
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 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and PDAs
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 Developer Pacific Technology Solutions -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 10:28 AM To: CF-Talk Subject: RE: CF and PDAs 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 23, 2001 11:31 AM To: CF-Talk Subject: RE: CF and PDAs 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 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 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 PM > To: CF-Talk > Subject: RE: CF and PDAs > > > > There's also a program called AppForge which integrates into Visual > Basic which lets you write the program once and then it translates it > for use on CE as well as Palm OS > > > > > > -Original Message- > > From: Scott Mulholland [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 22, 2001 6:42 AM > > To: CF-Talk > > Subject: CF and PDAs > > > > > > I want to make some basic database querying and result > > displaying capabilities for wireless pdas or docked pdas > > using cf...I would like it to work with Palm and CE devices. > > > > Can anyone point me in the direction of some resources or > > where to start. > > > > Thanks in advance! > > > > Scott Mulholland > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
.jar files?
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 archive and copy the classes into the sub-directory of what is set in the "Class Path". (This is very messy...) Any ideas on how to make ColdFusion 4.51 Server recognize these .jar files so I can leave the ENTIRE archive in a single directory? Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and PDAs
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 23, 2001 11:31 AM To: CF-Talk Subject: RE: CF and PDAs 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 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 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 PM > To: CF-Talk > Subject: RE: CF and PDAs > > > > There's also a program called AppForge which integrates into Visual > Basic which lets you write the program once and then it translates it > for use on CE as well as Palm OS > > > > > > -Original Message- > > From: Scott Mulholland [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 22, 2001 6:42 AM > > To: CF-Talk > > Subject: CF and PDAs > > > > > > I want to make some basic database querying and result > > displaying capabilities for wireless pdas or docked pdas > > using cf...I would like it to work with Palm and CE devices. > > > > Can anyone point me in the direction of some resources or > > where to start. > > > > Thanks in advance! > > > > Scott Mulholland > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL help/group in CFOUTPUT not working??????
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 23, 2001 1:00 PM > To: CF-Talk > Subject: RE: SQL help/group in CFOUTPUT not working?? > > > > 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 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 iCasacApptID is found in > the cats table twice, then two records are outputed in > my report instead of oneso, if there are 2 > TreatSelects to one CasacApptID, then I want that to > be one row..I though that > > > > #QRYtp.TreatSelect# > > > > > would accomplish thisbut it isnt. here is my code > belowcan anyone see what I am missing... > > Thanks yet again! > > > > > > > > > > Select cas.iClientID , >cd1.vCodeDecode as TreatSelect, >cas.iCasacApptID, >'#treatCount.TreatProgID#' as TrueProgID, >'#treatCount.TreatProg#' as TrueProg, >'#treatCount.HRACode#' as TrueHRA > From CasacAppt cas, > CasacApptTreatSelect cats, > CodeDecode cd1 > Where '#treatCount.TreatProgID#' = cas.iTreatProgID > and cas.iCasacApptID = cats.iCasacApptID > AND cats.cTreatSelectID = cd1.icodedecodeID > AND cas.dCasacDate = '#variables.DBeginDate#' > AND cas.dCasacDate <= '#variables.dEndDate#' > AND cas.iCasacApptID in (select cs.icasacApptID > from CasacApptTreatSelect cs) > > Union > > Select cas.iClientID , > 'None' as TreatSelect, > cas.iCasacApptID, > '#treatCount.TreatProgID#' as TrueProgID, > '#treatCount.TreatProg#' as TrueProg, > '#treatCount.HRACode#' as TrueHRA > From CasacAppt cas, > CodeDecode cd1, > Client cl > Where cas.iClientID = cl.iClientID > AND '#treatCount.TreatProgID#' = cas.iTreatProgID > > AND cas.dCasacDate >= '#variables.DBeginDate#' > AND cas.dCasacDate <= '#variables.dEndDate#' > AND cas.iCasacApptID not in (select > cs.icasacApptID from CasacApptTreatSelect cs) > > > > > > > >#QRYtp.iCasacApptID# >#QRYtp.TrueProg# >#QRYtp.iClientID# > > > > > #QRYtp.TreatSelect# > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL help/group in CFOUTPUT not working??????
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 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 iCasacApptID is found in the cats table twice, then two records are outputed in my report instead of oneso, if there are 2 TreatSelects to one CasacApptID, then I want that to be one row..I though that #QRYtp.TreatSelect# would accomplish thisbut it isnt. here is my code belowcan anyone see what I am missing... Thanks yet again! Select cas.iClientID , cd1.vCodeDecode as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA >From CasacAppt cas, CasacApptTreatSelect cats, CodeDecode cd1 Where '#treatCount.TreatProgID#' = cas.iTreatProgID and cas.iCasacApptID = cats.iCasacApptID AND cats.cTreatSelectID = cd1.icodedecodeID AND cas.dCasacDate = '#variables.DBeginDate#' AND cas.dCasacDate <= '#variables.dEndDate#' AND cas.iCasacApptID in (select cs.icasacApptID from CasacApptTreatSelect cs) Union Select cas.iClientID , 'None' as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA >From CasacAppt cas, CodeDecode cd1, Client cl Where cas.iClientID = cl.iClientID AND '#treatCount.TreatProgID#' = cas.iTreatProgID AND cas.dCasacDate >= '#variables.DBeginDate#' AND cas.dCasacDate <= '#variables.dEndDate#' AND cas.iCasacApptID not in (select cs.icasacApptID from CasacApptTreatSelect cs) #QRYtp.iCasacApptID# #QRYtp.TrueProg# #QRYtp.iClientID# #QRYtp.TreatSelect# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Buggy log10 function in CF 5.0 (Rounding to Significant Digits)
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 that I was working on to round to a specified number of significant digits:
(Please tell me what you think before I try to post it to cflib or something like
that.)
//Name: RSigFig
//By: Jason Snyder
//Purpose: Round to specified number of significant digits.
//Parameters:
// 1. fInput - Number to process.
// 2. iDigits - The number of significant digits to return.
//Return: Number rounded to specified # of signficant digits.
function RSigFig(fInput, iDigits) {
//Local Variables
var iLog = 0;
var iTemp = 0;
var fReturn = 0;
//Execution
if (fInput NEQ 0) { //If not zero round to significant digits.
iLog=Int(Log10(Sgn(fInput)*fInput+0.0));
iTemp=Round(fInput / (10^(iLog-iDigits+1)));
//return(Log10(fInput+0.0)); //Debugging
fReturn=iTemp*(10^(iLog-iDigits+1));
} //End (Round to significant digits.)
Return(fReturn);
} //End (RSigFig)
Note: I noticed that on some decimal place numbers like 1.15 when I tell it to round
to two significant figures it rounds down to 1.1 while if I put 1.16 it will round to
1.2. In the cases that I tested where the rounding left only whole numbers I did not
see the problem.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: regexp for swear filter
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]]
> Sent: 23 August 2001 17:40
> To: CF-Talk
> Subject: RE: regexp for swear filter
>
>
> 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 banana drove the car into the apple at high
> speed. The apple
> was upset."
>
> listReplace(lcase(text),badList,goodList);
>
> result = "this ** drove the *** into the at high
> speed, The
> was upset."
>
>
> Bryan Love ACP
> Internet Application Developer
> Telecommunication Systems Inc.
> [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: Rich Wild [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 23, 2001 2:54 AM
> To: CF-Talk
> Subject: regexp for swear filter
>
>
> 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
> speed. The apple
> was upset."
>
> result = "this ** drove the *** into the at high
> speed, The
> was upset."
>
> 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 work (bearing in mind I'm not great at regexps)?
>
> rereplacenocase(thistext, "#list#", "#rereplace(list, '[^\|]', '*',
> 'ALL')#", "ALL")
>
> hmmm even I'm not sure about that.
>
> ---
> Rich Wild
> Senior Web Developer
>
> ---
> e-mango.com ltd Tel: 01202 587 400
> Lansdowne Place Fax: 01202 587 401
> 17 Holdenhurst Road
> Bournemouth Mailto:[EMAIL PROTECTED]
> BH8 8EW, UK http://www.e-mango.com
> ---
> This message may contain information which is legally
> privileged and/or confidential. If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of e-mango.com ltd,
> unless otherwise explicitly and independently indicated
> by an authorised representative of e-mango.com ltd.
> ---
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: regexp for swear filter
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 banana drove the car into the apple at high speed. The apple
was upset."
listReplace(lcase(text),badList,goodList);
result = "this ** drove the *** into the at high speed, The
was upset."
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 2:54 AM
To: CF-Talk
Subject: regexp for swear filter
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 speed. The apple
was upset."
result = "this ** drove the *** into the at high speed, The
was upset."
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 work (bearing in mind I'm not great at regexps)?
rereplacenocase(thistext, "#list#", "#rereplace(list, '[^\|]', '*',
'ALL')#", "ALL")
hmmm even I'm not sure about that.
---
Rich Wild
Senior Web Developer
---
e-mango.com ltd Tel: 01202 587 400
Lansdowne Place Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth Mailto:[EMAIL PROTECTED]
BH8 8EW, UK http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Graphics Automation
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 certain width (but keeping the proportions), then uploaded to the web. does anyone know of a way to do this? or a close way? hehe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL help/group in CFOUTPUT not working??????
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 iCasacApptID is found in the cats table twice, then two records are outputed in my report instead of oneso, if there are 2 TreatSelects to one CasacApptID, then I want that to be one row..I though that #QRYtp.TreatSelect# would accomplish thisbut it isnt. here is my code belowcan anyone see what I am missing... Thanks yet again! Select cas.iClientID , cd1.vCodeDecode as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA >From CasacAppt cas, CasacApptTreatSelect cats, CodeDecode cd1 Where '#treatCount.TreatProgID#' = cas.iTreatProgID and cas.iCasacApptID = cats.iCasacApptID AND cats.cTreatSelectID = cd1.icodedecodeID AND cas.dCasacDate = '#variables.DBeginDate#' AND cas.dCasacDate <= '#variables.dEndDate#' AND cas.iCasacApptID in (select cs.icasacApptID from CasacApptTreatSelect cs) Union Select cas.iClientID , 'None' as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA >From CasacAppt cas, CodeDecode cd1, Client cl Where cas.iClientID = cl.iClientID AND '#treatCount.TreatProgID#' = cas.iTreatProgID AND cas.dCasacDate >= '#variables.DBeginDate#' AND cas.dCasacDate <= '#variables.dEndDate#' AND cas.iCasacApptID not in (select cs.icasacApptID from CasacApptTreatSelect cs) #QRYtp.iCasacApptID# #QRYtp.TrueProg# #QRYtp.iClientID# #QRYtp.TreatSelect# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Buggy log10 function in CF 5.0
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 function in CF 5.0 > 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 wrote: > >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 able to find a Taylor Series that gives a "close fit" for a > >natural logarithm (LN). Using that series, I wrote a little cfloop that > >will, given an input value and a precision variable, use the Taylor Series > >to give a close estimate of the Log base 10 of the input value. Check it > >out: > > > > > > > > > > > > > > >(Input_Variable-1)/(Input_Variable+1) )^(x+(x-1)) )> > > > > > > > > > > > > > >You've now got the natural log of the input value, as well as the Log base > >10. As you probably know, the Taylor Series is only a close estimation of > >the actual value. The higher your precision value, the closer the > >estimation is to the actual value. With a precision value of 10, i got > >precision within 1/1000th of the actual value. Not bad. > > > >Anyway, I hope this helpseven if it doesn't, its been kinda fun :) > > > >Brian > >- Original Message - > >From: "Snyder, Jason" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Wednesday, August 22, 2001 6:30 PM > >Subject: Buggy log10 function in CF 5.0 > > > > > >> I wrote a UDF that uses the log10 function and I noticed something was a > >bit fishy. When I isolated the log10 function and fed it 31 it spit out > >1.49136169383. When I fed it 32 it spit out 3. (I was expecting something > >more like 1.50514997832.) I went to cflib like what was suggested in a > >previous message and picked up logN. At first this was looking better but > >then I noticed something fishy once again. I noticed that when the input > >value is 9 on base 10 [logN(9,10)] it returned 9. My calculator comes up > >with 0.95424250943932 which seems much more reasonable. What can I do short > >of using cfx if I need something that can do logarithms? > >> > >> > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Buggy log10 function in CF 5.0
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 wrote: >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 able to find a Taylor Series that gives a "close fit" for a >natural logarithm (LN). Using that series, I wrote a little cfloop that >will, given an input value and a precision variable, use the Taylor Series >to give a close estimate of the Log base 10 of the input value. Check it >out: > > > > > > > (Input_Variable-1)/(Input_Variable+1) )^(x+(x-1)) )> > > > > > > >You've now got the natural log of the input value, as well as the Log base >10. As you probably know, the Taylor Series is only a close estimation of >the actual value. The higher your precision value, the closer the >estimation is to the actual value. With a precision value of 10, i got >precision within 1/1000th of the actual value. Not bad. > >Anyway, I hope this helpseven if it doesn't, its been kinda fun :) > >Brian >- Original Message - >From: "Snyder, Jason" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, August 22, 2001 6:30 PM >Subject: Buggy log10 function in CF 5.0 > > >> I wrote a UDF that uses the log10 function and I noticed something was a >bit fishy. When I isolated the log10 function and fed it 31 it spit out >1.49136169383. When I fed it 32 it spit out 3. (I was expecting something >more like 1.50514997832.) I went to cflib like what was suggested in a >previous message and picked up logN. At first this was looking better but >then I noticed something fishy once again. I noticed that when the input >value is 9 on base 10 [logN(9,10)] it returned 9. My calculator comes up >with 0.95424250943932 which seems much more reasonable. What can I do short >of using cfx if I need something that can do logarithms? >> >> > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and PDAs
-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]] > Sent: Thursday, August 23, 2001 11:06 AM > To: CF-Talk > Subject: RE: CF and PDAs > > > 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 Technology Solutions > > -Original Message- > From: Shawn Regan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 7:44 AM > To: CF-Talk > Subject: RE: CF and PDAs > > > 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 PM > To: CF-Talk > Subject: RE: CF and PDAs > > > > There's also a program called AppForge which integrates into Visual > Basic which lets you write the program once and then it translates > it for use on CE as well as Palm OS > > > > > > -Original Message- > > From: Scott Mulholland [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 22, 2001 6:42 AM > > To: CF-Talk > > Subject: CF and PDAs > > > > > > I want to make some basic database querying and result > > displaying capabilities for wireless pdas or docked pdas > > using cf...I would like it to work with Palm and CE devices. > > > > Can anyone point me in the direction of some resources or > > where to start. > > > > Thanks in advance! > > > > Scott Mulholland > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL help/group in CFOUTPUT not working??????
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 23, 2001 8:34 AM To: CF-Talk Subject: SQL help/group in CFOUTPUT not working?? 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 iCasacApptID is found in the cats table twice, then two records are outputed in my report instead of oneso, if there are 2 TreatSelects to one CasacApptID, then I want that to be one row..I though that #QRYtp.TreatSelect# would accomplish thisbut it isnt. here is my code belowcan anyone see what I am missing... Thanks yet again! Select cas.iClientID , cd1.vCodeDecode as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA >From CasacAppt cas, CasacApptTreatSelect cats, CodeDecode cd1 Where '#treatCount.TreatProgID#' = cas.iTreatProgID and cas.iCasacApptID = cats.iCasacApptID AND cats.cTreatSelectID = cd1.icodedecodeID AND cas.dCasacDate = '#variables.DBeginDate#' AND cas.dCasacDate <= '#variables.dEndDate#' AND cas.iCasacApptID in (select cs.icasacApptID from CasacApptTreatSelect cs) Union Select cas.iClientID , 'None' as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA >From CasacAppt cas, CodeDecode cd1, Client cl Where cas.iClientID = cl.iClientID AND '#treatCount.TreatProgID#' = cas.iTreatProgID AND cas.dCasacDate >= '#variables.DBeginDate#' AND cas.dCasacDate <= '#variables.dEndDate#' AND cas.iCasacApptID not in (select cs.icasacApptID from CasacApptTreatSelect cs) #QRYtp.iCasacApptID# #QRYtp.TrueProg# #QRYtp.iClientID# #QRYtp.TreatSelect# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: regexp for swear filter
>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 work (bearing in mind I'm not great at regexps)?
>
>rereplacenocase(thistext, "#list#", "#rereplace(list, '[^\|]', '*',
>'ALL')#", "ALL")
You may be able to use REFind to get the Pos and Len of the substring
matched by the regexp. I don't think it'd be a one-liner, maybe two
or three, but you wouldn't need a loop.
I haven't tried to do this, but i would imagine that would be a good place
to start.
-Ryan
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Level 1-3 at OSU :: who is teaching it?
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 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]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 9:40 AM Subject: Coldfusion Level 1-3 at OSU :: who is teaching it? > 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 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk "to & from" wierdness
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. 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: CF-Talk Subject: RE: CF-Talk "to & from" wierdness 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 it. But this is not a fault with this list... -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Thursday, 23 August 2001 10:57 PM To: CF-Talk Subject: CF-Talk "to & from" wierdness 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 Outlook to throw a message into a folder based on the content of the TO field (why dosn't Qualcomm make an enterprise Eudora client ;). Eric Carlisle ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL help/group in CFOUTPUT not working??????
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 iCasacApptID is found in the cats table twice, then two records are outputed in my report instead of oneso, if there are 2 TreatSelects to one CasacApptID, then I want that to be one row..I though that #QRYtp.TreatSelect# would accomplish thisbut it isnt. here is my code belowcan anyone see what I am missing... Thanks yet again! Select cas.iClientID , cd1.vCodeDecode as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA >From CasacAppt cas, CasacApptTreatSelect cats, CodeDecode cd1 Where '#treatCount.TreatProgID#' = cas.iTreatProgID and cas.iCasacApptID = cats.iCasacApptID AND cats.cTreatSelectID = cd1.icodedecodeID AND cas.dCasacDate = '#variables.DBeginDate#' AND cas.dCasacDate <= '#variables.dEndDate#' AND cas.iCasacApptID in (select cs.icasacApptID from CasacApptTreatSelect cs) Union Select cas.iClientID , 'None' as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA >From CasacAppt cas, CodeDecode cd1, Client cl Where cas.iClientID = cl.iClientID AND '#treatCount.TreatProgID#' = cas.iTreatProgID AND cas.dCasacDate >= '#variables.DBeginDate#' AND cas.dCasacDate <= '#variables.dEndDate#' AND cas.iCasacApptID not in (select cs.icasacApptID from CasacApptTreatSelect cs) #QRYtp.iCasacApptID# #QRYtp.TrueProg# #QRYtp.iClientID# #QRYtp.TreatSelect# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and PDAs
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 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 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 PM > To: CF-Talk > Subject: RE: CF and PDAs > > > > There's also a program called AppForge which integrates into Visual > Basic which lets you write the program once and then it translates it > for use on CE as well as Palm OS > > > > > > -Original Message- > > From: Scott Mulholland [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 22, 2001 6:42 AM > > To: CF-Talk > > Subject: CF and PDAs > > > > > > I want to make some basic database querying and result > > displaying capabilities for wireless pdas or docked pdas > > using cf...I would like it to work with Palm and CE devices. > > > > Can anyone point me in the direction of some resources or > > where to start. > > > > Thanks in advance! > > > > Scott Mulholland > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database connections in Studio
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] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- I'm looking for a room-mate in the Hartford CT area, starting in August -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 http://www.instantcoldfusion.com -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Change is good ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and PDAs
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 Technology Solutions -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 7:44 AM To: CF-Talk Subject: RE: CF and PDAs 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 PM To: CF-Talk Subject: RE: CF and PDAs There's also a program called AppForge which integrates into Visual Basic which lets you write the program once and then it translates it for use on CE as well as Palm OS > > -Original Message- > From: Scott Mulholland [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 6:42 AM > To: CF-Talk > Subject: CF and PDAs > > > I want to make some basic database querying and result > displaying capabilities for wireless pdas or docked pdas > using cf...I would like it to work with Palm and CE devices. > > Can anyone point me in the direction of some resources or > where to start. > > Thanks in advance! > > Scott Mulholland ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and PDAs
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 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 PM > To: CF-Talk > Subject: RE: CF and PDAs > > > > There's also a program called AppForge which integrates into Visual > Basic which lets you write the program once and then it translates it > for use on CE as well as Palm OS > > > > > > -Original Message- > > From: Scott Mulholland [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 22, 2001 6:42 AM > > To: CF-Talk > > Subject: CF and PDAs > > > > > > I want to make some basic database querying and result > > displaying capabilities for wireless pdas or docked pdas > > using cf...I would like it to work with Palm and CE devices. > > > > Can anyone point me in the direction of some resources or > > where to start. > > > > Thanks in advance! > > > > Scott Mulholland > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Open Source Content Mananagent System
-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: Thursday, August 23, 2001 4:59 AM > To: CF-Talk > Subject: RE: Open Source Content Mananagent System > > > > 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 http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Structure notation
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 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 have seen examples of structure_name.element_name being allowed
and
now I see that the new O'Reilly ColdFusion book lists object notation
like
that as one of the ways to reference structure elements.
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.
Is either one the preferred notation for any reason? Better performance?
More accepted style? etc. etc.
I found one case where the bracket notation seemed to be required: the
name
of the element was itself a variable, specifically, the result of a
function. For example:
I couldn't say structure.substructure.#Evaluate("#x#")
How come?
Thanks for any insight you can give.
-- Tim Dempsey
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Structure notation
> 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 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 have seen examples of structure_name.element_name being
> allowed and
> now I see that the new O'Reilly ColdFusion book lists object
> notation like
> that as one of the ways to reference structure elements.
>
> 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.
>
> Is either one the preferred notation for any reason? Better
> performance?
> More accepted style? etc. etc.
>
> I found one case where the bracket notation seemed to be
> required: the name
> of the element was itself a variable, specifically, the result of a
> function. For example:
>
>
>
> I couldn't say structure.substructure.#Evaluate("#x#")
>
> How come?
>
> Thanks for any insight you can give.
>
>
> -- Tim Dempsey
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Structure notation
> 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: This would output Struct.Boo. If you did Struct.Key, it would treat "Key" as the literal name for the key. So, if you need to output a key and don't know the name at runtime, you would use [] notation. You _could_ do an Evaluate on the dot format, but that stinks for two reasons, one, it's slow, secondly, if the dynamic key was "Ray Camden", then you would get an error trying to evaluate Struct.Ray Camden, which isn't a valid variable. Struct["Ray Camden"] is though. > Is either one the preferred notation for any reason? Better performance? > More accepted style? etc. etc. Use what makes sense. I use dot notation for simple stuff, ie, struct.name, etc. In general, if I know the key name at design time, I use dot notation. If I don't, I use []. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and PDAs
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 PM To: CF-Talk Subject: RE: CF and PDAs There's also a program called AppForge which integrates into Visual Basic which lets you write the program once and then it translates it for use on CE as well as Palm OS > > -Original Message- > From: Scott Mulholland [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 6:42 AM > To: CF-Talk > Subject: CF and PDAs > > > I want to make some basic database querying and result > displaying capabilities for wireless pdas or docked pdas > using cf...I would like it to work with Palm and CE devices. > > Can anyone point me in the direction of some resources or > where to start. > > Thanks in advance! > > Scott Mulholland ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Structure notation
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 have seen examples of structure_name.element_name being allowed and
now I see that the new O'Reilly ColdFusion book lists object notation like
that as one of the ways to reference structure elements.
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.
Is either one the preferred notation for any reason? Better performance?
More accepted style? etc. etc.
I found one case where the bracket notation seemed to be required: the name
of the element was itself a variable, specifically, the result of a
function. For example:
I couldn't say structure.substructure.#Evaluate("#x#")
How come?
Thanks for any insight you can give.
-- Tim Dempsey
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Level 1-3 at OSU :: who is teaching it?
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 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 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]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 9:40 AM Subject: Coldfusion Level 1-3 at OSU :: who is teaching it? > 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 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stock Quotes
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 ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developers Resources http://www.cfdev.com/ -Original Message- From: nyon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 9:44 PM To: CF-Talk Subject: Re: Stock Quotes please forward any replies you get. Thanks Nyon - Original Message - From: Ronald Winn <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Wednesday, August 22, 2001 11:08 PM Subject: Stock Quotes > Any ideas on a good service that allows web servers to obtain stock > quotes (preferably free). I'm building a flash and generator interface > to display a stock ticker. > > Thanks > Ron > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk "to & from" wierdness
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 it. But this is not a fault with this list... -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Thursday, 23 August 2001 10:57 PM To: CF-Talk Subject: CF-Talk "to & from" wierdness 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 Outlook to throw a message into a folder based on the content of the TO field (why dosn't Qualcomm make an enterprise Eudora client ;). Eric Carlisle ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Coldfusion Level 1-3 at OSU :: who is teaching it?
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]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 9:40 AM Subject: Coldfusion Level 1-3 at OSU :: who is teaching it? > 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 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
INSERTing multiple rows efficiently
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 the db (SQL Server 2000) at once... Is there a better/faster/more efficient way to do this...? I'd like to pass a block of values at once via an array or structure or table variable to insert multiple rows at once...? I don't know if moving this into an sproc would help the transaction times? Other suggested options...? INSERT INTO user_interest (my_uid,myinterest_id) VALUES (, ); qry_user_interest_insert (Records=0, Time=50ms) SQL = INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); INSERT INTO user_interest (my_uid,my_interest_id) VALUES (?,?); Query Parameter Value(s) - Parameter #1 = 1 Parameter #2 = 17 Parameter #3 = 1 Parameter #4 = 1 Parameter #5 = 1 Parameter #6 = 2 Parameter #7 = 1 Parameter #8 = 3 Parameter #9 = 1 Parameter #10 = 26 Parameter #11 = 1 Parameter #12 = 18 Parameter #13 = 1 Parameter #14 = 19 Parameter #15 = 1 Parameter #16 = 20 Parameter #17 = 1 Parameter #18 = 4 Parameter #19 = 1 Parameter #20 = 32 Parameter #21 = 1 Parameter #22 = 5 Parameter #23 = 1 Parameter #24 = 36 Parameter #25 = 1 Parameter #26 = 21 Parameter #27 = 1 Parameter #28 = 6 Parameter #29 = 1 Parameter #30 = 22 Parameter #31 = 1 Parameter #32 = 23 Parameter #33 = 1 Parameter #34 = 24 Parameter #35 = 1 Parameter #36 = 7 Parameter #37 = 1 Parameter #38 = 8 Parameter #39 = 1 Parameter #40 = 9 Parameter #41 = 1 Parameter #42 = 10 Parameter #43 = 1 Parameter #44 = 25 Parameter #45 = 1 Parameter #46 = 11 Parameter #47 = 1 Parameter #48 = 12 Parameter #49 = 1 Parameter #50 = 35 Parameter #51 = 1 Parameter #52 = 27 Parameter #53 = 1 Parameter #54 = 28 Parameter #55 = 1 Parameter #56 = 29 Parameter #57 = 1 Parameter #58 = 33 Parameter #59 = 1 Parameter #60 = 13 Parameter #61 = 1 Parameter #62 = 14 Parameter #63 = 1 Parameter #64 = 15 Parameter #65 = 1 Parameter #66 = 30 Parameter #67 = 1 Parameter #68 = 31 Parameter #69 = 1 Parameter #70 = 16 Parameter #71 = 1 Parameter #72 = 34 Thanks, Orlando ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusio
Re: Buggy log10 function in CF 5.0
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 able to find a Taylor Series that gives a "close fit" for a natural logarithm (LN). Using that series, I wrote a little cfloop that will, given an input value and a precision variable, use the Taylor Series to give a close estimate of the Log base 10 of the input value. Check it out: You've now got the natural log of the input value, as well as the Log base 10. As you probably know, the Taylor Series is only a close estimation of the actual value. The higher your precision value, the closer the estimation is to the actual value. With a precision value of 10, i got precision within 1/1000th of the actual value. Not bad. Anyway, I hope this helpseven if it doesn't, its been kinda fun :) Brian - Original Message - From: "Snyder, Jason" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 22, 2001 6:30 PM Subject: Buggy log10 function in CF 5.0 > I wrote a UDF that uses the log10 function and I noticed something was a bit fishy. When I isolated the log10 function and fed it 31 it spit out 1.49136169383. When I fed it 32 it spit out 3. (I was expecting something more like 1.50514997832.) I went to cflib like what was suggested in a previous message and picked up logN. At first this was looking better but then I noticed something fishy once again. I noticed that when the input value is 9 on base 10 [logN(9,10)] it returned 9. My calculator comes up with 0.95424250943932 which seems much more reasonable. What can I do short of using cfx if I need something that can do logarithms? > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Passing list to Stored Procedure..
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, 2001 1:06 AM 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 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 who uses them documented" They were wriiten in SQL Server 2000 > but AFAIK they should work in 7 also. > > http://www.cyberroomies.com/data/listfunctions.zip > > > Enjoy > > - Original Message - > From: "Don Vawter" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 22, 2001 8:02 PM > Subject: Re: Passing list to Stored Procedure.. > > > > i routinely pass a comma delimited list to SQL Server stored procs. I just > > wrote a few simple udfs in sql server to parse the list when it gets it. > > > > - Original Message - > > From: "Darryl Lyons" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, August 22, 2001 4:50 PM > > Subject: SOT: Passing list to Stored Procedure.. > > > > > > > Does anyone know if you can pass a list of values to a stored procedure > > via > > > CF? This is mainly needed because the list values would be drawn from an > > > unspecified datasource (e.g. a list of user groups stored in a session > > > var).. > > > > > > --- > > > Regards, > > > > > > Darryl Lyons > > > Senior Systems Developer > > > Fuzion: http://www.fuzion.com.au > > > > > > Email : [EMAIL PROTECTED] > > > Phone : (07) 3620 1000 > > > Fax : (07) 3620 1001 > > > Technical Support : 1300 888 480 > > > > > > 'merging business + technology' > > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Coldfusion Level 1-3 at OSU :: who is teaching it?
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 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Format Text
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? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk "to & from" wierdness
#($*#@()*#)@$*)@#(()#@$*@#*($ 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 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 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 Outlook to throw a message into a folder based on the content of the TO field (why dosn't Qualcomm make an enterprise Eudora client ;). Eric Carlisle ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk "to & from" wierdness
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 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 Outlook to throw a message into a folder based on the content of the TO field (why dosn't Qualcomm make an enterprise Eudora client ;). Eric Carlisle ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
