Re: Activeedit 2.5
What about the various ActiveX plugins for Netscape? Do they work? Are they supported? |+| |Eric A. Laney |As we know, the value of pi is a transcendental | |Systems Engineer|figure without resolution. | |LAN Optimization|| |Team|| |Verizon Data| - Spock, Wolf in the Fold, stardate 3615.4.| |Services|| |Voice: 813.978.4404 || |Pager: 888.985.8519 || |+| Date: Mon, 20 Aug 2001 10:27:46 -0400 From: Gary Kraeger [EMAIL PROTECTED] Subject: Re: Activeedit 2.5 Message-ID: 01f401c12984$48a72520$[EMAIL PROTECTED] No we have yet to make Activedit for Netscape. We are currently developing Activedit in java that will work in both browsers. It is due out in late October when Activedit 3.0 hits the street. Gary CFDEV.COM http://www.cfdev.com 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: GTE problem
CFAS read the press release that GTE is now Verizon. Sorry, couldn't resist. =B) |-+---| |Eric A. Laney|Religion without science is blind. Science without| |Systems Engineer |religion is lame. | |LAN Optimization Team| | |Verizon Data Services| | |Voice: 813.978.4404 | - Albert Einstein| |Pager: 888.985.8519 | | |-+---| This has peaked my curiosity, Pete. How could a CFAS become unstable to the point where it's unable to parse perfectly legitimate CFML, but only specific pieces? And why GTE and not LT or LTE etc etc? I'm glad you got the issue resolvedbut I'd love to hear a cause. Brian 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: CF5 adding extra quote marks to cfquery
ColdFusion is protecting what it believes to be data by escaping your quote marks. If you were trying to insert values into the database with dynamic CF code, you'd need this functionality to make sure all the data got to the right place. CF has no way to automatically know which one you're trying to do. Use the PreserveSingleQuotes() function to prevent this behavior. |-+---| |Eric A. Laney|Sure, 90% of all software is crap. That's because 90% | |Systems Engineer |of everything is crap.| |LAN Optimization | | |Team | | |Voice: |- Mary Shaw, Carnegie-Mellon University| |813.978.4404 | | |Pager: | | |888.985.8519 | | |-+---| Thomas Chiverton thomas.chiverton@eTo: CF-Talk [EMAIL PROTECTED] xodus.net cc: Subject: CF5 adding extra quote marks to cfquery 08/01/2001 06:22 AM Please respond to cf-talk I'm playing with some UDF's, and have this section of code -- cfoutput where:br #MakeWhereClause(CreateRecordID( qQuery))# /cfoutput cfquery name=qDoesit datasource=#request.dbname# select * from actuals where #MakeWhereClause(CreateRecordID( qQuery))# /cfquery -- This produces: -- where: dateid='04-Jan-01' and gcljobno=200140206 and taskid='GCL001' and starttime='09:00' and resourceid='tchiverton' -- Then the error: -- ODBC Error Code = S1000 (General error) [Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended SQL = select * from actuals where dateid=''04-Jan-01'' and gcljobno=200140206 and taskid=''GCL001'' and starttime=''09:00'' and resourceid=''tchiverton'' -- So although my MakeWhere UDF is returning a correctly escaped SQL string, when it goes inside the cfquery, and does the same bit of code, CF seems to be adding extra quote marks. Is this known behaviour ? Any way to run it off ? Other pleas for help appreciated ? :-) Regards, Thomas Chiverton Intranet Architect 01565 757 909 Another fine development by Boring Sigs Inc. ~~ 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: locking error
It means that whatever value you had for the timeout attribute in your cflock tag was too short. You received the error message because you had throwontimeout=yes. Instead of removing the locks, either increase the timeout value or consider moving from a scope lock to a name lock so you can lock only what you have to, rather than locking all the variables of an entire class across all applications on the server. |---+-| |Eric A. Laney |One's real life is often the life that one does | |Systems Engineer |not lead.| |LAN Optimization Team | | |Voice: 813.978.4404| | |Pager: 888.985.8519| | |---+-| Steven Dworman To: CF-Talk [EMAIL PROTECTED] dwormans@msucc: .eduSubject: locking error 07/31/2001 11:35 AM Please respond to cf-talk Can someone explain this error to me? I took out the locks in the application.cfm file when I got this error message. Unable to acquire lock for single threaded sessions within timeout period. Please raise the request timeout limit to lengthen the time available to acquire the lock. The error occurred while processing an element with a general identifier of (CFAPPLICATION), occupying document position (1:1) to (4:58) in the template file /data1/entdocs/devwww.vzncontract.com/cfm/vzncontract/vzn/Application.cfm ~~ 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: 2 JavaScript questions
function toForm(theForm, theField) { document.theForm.theField.focus(); } and then called it by: onLoad=toForm('form1','Firstname') The problem is that what you're passing into the function is a string, not a form object. The way JS works, it's going to expect a form object. Instead, try this: function toForm(theField) { theField.focus(); } onLoad=toForm(document.form1.Firstname) To answer your second question, you'll have to get into the form's collection of elements. There's way too much to go over right here all at once, but the nutshell version is that in the same way you can say document.form1.Firstname, you can also say document.form1.elements[0] if the Firstname field is the first field in the form. As bad as their browser was / is, Netscape still has the best online documentation on JavaScript. The O'Reilly book is probably better, but I haven't seen it myself to say for sure. JavaScript Reference: http://developer.netscape.com/docs/manuals/communicator/jsref/index.htm JavaScript Reference in PDF: http://developer.netscape.com/docs/manuals/js/client/jsguide/ClientGuideJS13.pdf |+| |Eric A. Laney |Time wounds all heels.| |Systems Engineer|| |LAN Optimization Team || |Voice: 813.978.4404 | - Jane Ace| |Pager: 888.985.8519 || |+| ~~ 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: Exception Handling in SQL?
This is an ideal place for BEGIN TRAN / COMMIT TRAN / ROLLBACK TRAN. I've done this in the past with SQL Server 7.0 and it works great. DECLARE @ErrNum int SET @ErrNum = 0 -- delete the line item BEGIN TRAN delete Invoice_Line_Item Where Invoice_Line_Item_ID = @Line_Item_ID set @ErrNum = @ErrNum + @@error -- lots more SQL code can go here if you want if @ErrNum 0 begin -- an error has occured while deleting ROLLBACK TRAN print @ErrNum return @ErrNum end else begin COMMIT TRAN end |+| |Eric A. Laney |Time wounds all heels.| |Systems Engineer|| |LAN Optimization Team || |Voice: 813.978.4404 | - Jane Ace| |Pager: 888.985.8519 || |+| Shawn Grover sgrover@OBJECTTo: CF-Talk [EMAIL PROTECTED] WORKS.com cc: Subject: Exception Handling in SQL? 07/31/2001 04:07 PM Please respond to cf-talk We are using SQL Server 7, and need to delete records. However, we need to intercept if a foriegn key constraint error is thrown. SQL Server seems to be throwing an exception as soon as the error is encountered, and not giving our script a chance to handle the error. Is there anyway around this? Other than checking the foriegn key tables first that is... here's what we are trying thus far: -- delete the line item delete Invoice_Line_Item Where Invoice_Line_Item_ID = @Line_Item_ID set @Error = @@error if @Error 0 begin -- an error has occured while deleting print @Error return @Error end - An exception is being thrown before the Print statement, we need to avoid the exception. Thanks. Shawn Grover ~~ 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: CFEXECUTE and the quote symbol
I recommend that you forego using cfexecute and look instead at two different resources: 1. CF_ADSI at http://www.cfcomet.com/ which is a COM .dll that encapsulates the ADSI calls to do this sort of thing so you can call it from cfobject. 2. Intranet / Hosting Toolkit at http://www.intrafoundation.com/ihtk.html - while I haven't used this one myself, it looks to be a fairly complete package that uses CFX tags instead of a COM object. |-+---| |Eric A. |There are many who are uncomfortable with what we have created.| |Laney|It is almost a biological rebellion. A profound revulsion | |Systems |against the planned communities, the programming, the | |Engineer |sterilized, artfully balanced atmospheres. They hunger for an | |LAN |Eden, where spring comes. | |Optimizat| | |ion Team |We all do. The cave is deep in our memories. | |Voice: | | |813.978.4| | |404 | - Spock and Kirk, The Way to Eden, stardate 5832.3.| |Pager: | | |888.985.8| | |519 | | |-+---| Chad Gray chad@attach.To: CF-Talk [EMAIL PROTECTED] net cc: Subject: CFEXECUTE and the quote symbol 07/30/2001 12:52 PM Please respond to cf-talk Hello, Im trying to automate the Win2K command Net User to add users to the computer. The problem im running into is i need to use a inside of the argument. Well when CF sees the it thinks it is the end of the CFEXECUTE tag. Anyway to escape this quote symbol? I tried using quot; but that did not work. cfexecute name=c:\winnt\system32\net.exe arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:BILLYBOB /expires:never /passwordchg:no /passwordreq:yes outputfile=c:\output.txt /cfexecute ~~ 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: forcing downloads
Opera 5.12 on Windows 2000 Pro through paranoid corporate firewall reports Connection closed by remote server. |--+--| |Eric A. Laney |Happiness:| |Systems Engineer |An agreeable sensation arising from contemplating the | |LAN Optimization |misery of another.| |Team | | |Voice:| | |813.978.4404 | | |Pager:| | |888.985.8519 | | |--+--| Dick Applebaum To: CF-Talk [EMAIL PROTECTED] dick@lacara.cc: com Subject: RE: forcing downloads 07/27/2001 08:08 AM Please respond to cf-talk Hi folks.. can anyone help us out with this one, it should be so simple and I just can't accept all the hassle we've been having to try and figure it out. What we want to do is have the user click a link to a cfm file, that cfm file then returns a file (for arguements sake a .xls file) which starts to download to the users machine (forcing download rather than returning to browser). We've tried using CFCONTENT and setting the type to unknown, this will start the file downloading all right but the name that appears in the dialog boxes is the name of the orginal cfm file that was called rather than the name of the actual file (i.e. saves as download.cfm rather than file2download.xls ) surely this is a simple operation? ... I really hope somebody can make me look stoopid with the answer.. in hope .jez Jeremy Becker ([EMAIL PROTECTED]) This thread pops up ever week or so... There are several problems with different browsers platforms (incompatibilities, partial implementations and outright bugs) Based on help from several others, I think that the following will work on most current browsers. It downloads either a text file or a TSV file which normally would be displayed. It gets the correct name (must be supplied with the form or the link) I have testes successfully on: Mac IE 5.x Mac NN 4.x Win IE 4.x Win IE 5.x Win NN 4.x If you can test it on any other platforms, it would help. the URL: http://.instasales.com/Samples/DownloadFile/DownloadFile.cfm Give it a try! Dick The Source: CFSETTING ENABLECFOUTPUTONLY=YES !--- --- !--- StandAloneDownload.cfm --- !--- --- !--- Requests a download then performs that download --- !--- --- !--- Due to a Bug in MSIE 5.x , we must include the File Name in --- !--- the Form or Link URL of the page called to invoke the--- !--- download.--- !--- --- !--- We do this in the form: --- !--- --- !--- TemplateName.cfm/FileName/ --- !---
Re: Regular Expression Help
Being a Perl programmer also, this is one of the things that really frustrates me about CF's regular expressions. Okay, so back in the day, Allaire decided to go with POSIX-style character classes. That still doesn't explain to me why you have to put the extra square brackets in there, and it doesn't explain why I can't write: [:digit:]{3}-?[:digit:]{4} to describe a US-style telephone number without an area code. I work with three different software packages that all support regular expressions, but there's nothing regular about them. They all use different notations, they all have quirks, and I still have to look it up in order to remember which regular expression I'm using. Maybe I'm missing something, but I haven't been able to take my knowledge of regexp that I learned from Perl and apply it to CF with any semblance of consistency. |--+--| |Eric A. Laney |Happiness:| |Systems Engineer |An agreeable sensation arising from contemplating the | |LAN Optimization |misery of another.| |Team | | |Voice:| | |813.978.4404 | | |Pager:| | |888.985.8519 | | |--+--| Dain Anderson To: CF-Talk [EMAIL PROTECTED] DainAnderson@cc: nc.rr.comSubject: Re: Regular Expression Help 07/27/2001 08:28 AM Please respond to cf-talk John, Your assumption is correct. The part that may have confused you originally is that POSIX-style character classes (ie, [:punct:]) are surrounded by brackets and colons, in addition to the bracket set that defines the entire character class, such as [[:alpha:][:punct:][:cntrl:]] etc... Numeric charcter classes are special in that you can use a hyphen for any range of numbers, such as [0-9], [0-3], [3-7], etc. which emcompass every number in that specific range. Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: John Barleycorn [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 27, 2001 1:39 AM Subject: Re: Regular Expression Help Dain, thank you very much. Is it safe to assume then that anything else i want to search for can be added by placing the definition inside another pair of brackets? REFindNoCase([[:Alpha:][0-3][ ][:Punct:]], myString) (added [0-3] and [ ] to find a space) thanks. From: Dain Anderson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Regular Expression Help Date: Thu, 26 Jul 2001 21:02:45 -0400 John, You almost had it (too many brackets): cfif REFindNoCase([[:Alpha:][:Punct:]], myString) Alpha characters or punctuation were found. cfelse No alpha characters or punctuation found. /cfif If you need to get the position of the first occurance of these characters, use subexpressions: cfset mystring = 1234.ABCD !--- Use the 'returnsubexpressions' parameter to get the position --- cfset something = REFindNoCase([[:Alpha:][:Punct:]], myString, 1, True) cfif something.pos[1] cfoutput Characters found at position: #something.pos[1]#BR /cfoutput cfelse No alpha characters or punctuation found. /cfif Dain Anderson Caretaker, CF Comet
RE: Hooking to Lotus Notes.
I'm using Notes 5.0.8, there are no Notes ODBC drivers on my workstation. Unless I missed something in the client install. I know that you can get to Notes via COM, but for hard-core web applications that's a pretty unreliable access method. If I find out anything more, I'll definitely let everyone know. This would be useful functionality for me, too. |-+---| |Eric A. Laney|Worry is a human emotion. | |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 | - Spock, Journey to Babel, stardate 3842..4.| |Pager: 888.985.8519 | | |-+---| A.Little@open .ac.uk To: CF-Talk [EMAIL PROTECTED] cc: 07/27/2001 Subject: RE: Hooking to Lotus Notes. 09:38 AM Please respond to cf-talk Yes you can use ODBC to link to a Notes db. I'm not so sure about linking to a remote Notes db though. I know for Notes 4.5 to get the ODBC working you needed to have a Notes client installed, so you may need to install a Notes client on your CF server. This may of course be different for Notes 5. :) Alex -Original Message- From: Angél Stewart [SMTP:[EMAIL PROTECTED]] Sent: 27 July 2001 14:19 To: CF-Talk Subject: Hooking to Lotus Notes. Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine? I've never used this darn thing before, but apparently a client has this as one of their requirements, that data be read from a .nsf file at regular intervals, and then we write a file that can be imported into that same Lotus Notes database to a location on the server. -Gel ~~ 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: Hooking to Lotus Notes.- SOLUTION
Found it! http://www.lotus.com/download_kits.nsf/ You want to use the Select Product dropdown to download the Notes SQL 3.0 ODBC drivers. This package will install an ODBC driver for .nsf databases. You'll have to jump through Lotus' inane registration and login process, but what's a little spam between friends? |-+---| |Eric A. Laney|The great artist is the simplifier. | |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 |- Henri FrTdTric Amiel, Swiss poet, philosopher| |Pager: 888.985.8519 |(1821-1881)| |-+---| Angél Stewart To: CF-Talk [EMAIL PROTECTED] gel@carigamecc: r.com Subject: Hooking to Lotus Notes. 07/27/2001 09:18 AM Please respond to cf-talk Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine? I've never used this darn thing before, but apparently a client has this as one of their requirements, that data be read from a .nsf file at regular intervals, and then we write a file that can be imported into that same Lotus Notes database to a location on the server. -Gel ~~ 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: Hooking to Lotus Notes.- SOLUTION
Well, don't get excited just yet... I installed the drivers and attempted to connect to my local address book using CF and Notes SQL. I was able to set up the ODBC connection, and I even reverse-engineered the database structure using Visio 2002's Database Model template, but when I created a CF test page and did a cfquery, it immediately crashed cfserver.exe. CF server 4.5.2 Pro on Win2K Pro SP2, 256MB RAM, Lotus Notes R5.0.8, Notes SQL 3.0 |+| |Eric A. Laney |We didn't inherit the land from our fathers. We are| |Systems Engineer|borrowing it from our children.| |LAN Optimization|| |Team|| |Voice: | - Amish belief| |813.978.4404|| |Pager: || |888.985.8519|| |+| Angél Stewart To: CF-Talk [EMAIL PROTECTED] gel@carigamecc: r.com Subject: RE: Hooking to Lotus Notes.- SOLUTION 07/27/2001 10:49 AM Please respond to cf-talk Yes thats it! Thank you ! I've been scouring the Lotus Notes site but apparently wasn't looking in the right place heh heh. It's interesting that no one seems to have actually USED the ODBC driver to hook to notes for an application though.. :) *wiggles happily* -Gel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Found it! http://www.lotus.com/download_kits.nsf/ You want to use the Select Product dropdown to download the Notes SQL 3.0 ODBC drivers. This package will install an ODBC driver for .nsf databases. You'll have to jump through Lotus' inane registration and login process, but what's a little spam between friends? ~~ 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: double post - JavaScript and windows
I'm a little fuzzy on my JavaScript DOM, but I think you can use opener.location.href = 'x'; |---+-| |Eric A. Laney |You now have Asian Flu. | |Systems Engineer | | |LAN Optimization Team | | |Voice: 813.978.4404|- Today's Fortune| |Pager: 888.985.8519| | |---+-| Will Swain will@hothorsTo: CF-Talk [EMAIL PROTECTED] e.com cc: Subject: double post - JavaScript and windows 07/27/2001 11:47 AM Please respond to cf-talk Hi, Just a quick one. I have a window that is opened through clicking on a a href in another window. There is a link in this second window, which when clicked I want to open a page in the first window. Any ideas? Will Swain Hot Horse Ltd http://www.hothorse.com e: [EMAIL PROTECTED] t: 01273 675375 ~~ 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: Browser Sniffing and Serving StyleSheets
You'll want to check #CGI.HTTP_USER_AGENT# and then parse it for the browser and OS values. A Macintosh will always have Mac somewhere in the string, but Windows does not always put Win or Windows in the string. So, if it doesn't say Mac, assume it's Windows. It could be Unix, but Unix doesn't consistently put a value in the user agent string either. Besides, Unix browsers are almost always closer to Windows than to Macintosh in terms of browser functions. Internet Explorer will always report MSIE somewhere in the string. Opera will report Opera unless it is set to spoof itself as some other browser. Netscape does not consistently put a value into the string, so do the same as with the OS and assume Netscape if you don't find either of these other two. |-+---| |Eric A. Laney|The closed mouth swallows no flies.| |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 | - Spanish proverb| |Pager: 888.985.8519 | | |-+---| Dasher dasher@bentmTo: CF-Talk [EMAIL PROTECTED] edia.comcc: Subject: Browser Sniffing and Serving StyleSheets 07/25/2001 12:11 PM Please respond to cf-talk I need to sniff the operating system (Mac or PC) and browser (Netscape or IE) type using Cold Fusion, then serve that particular configuration a particular StyleSheet based on that info. Does anyone have a solution or know where I could look for this information? Thanks! -- Dasher [EMAIL PROTECTED] http://www.bentmedia.com/ Bent Media, Inc. 128 South Clark Street New Orleans, LA 70119-6103 Phone - 504.488.2848 x19 Fax - 504.488.2979 ~~ 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 Server memory use grows
My SQL Server 7.0 box has 512MB and does nothing but SQL. The last time I rebooted it to do a hotfix, it was running with over 400MB of RAM dedicated to SQL Server. The only problem I run into is when I get a big spike of activity and the server runs out of Locks. I'll be moving my Client variable data store to a different SQL server soon, which should alleviate that problem. In short, I don't think 140MB is anywhere close to being a problem. |-+---| |Eric A. Laney|The closed mouth swallows no flies.| |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 | - Spanish proverb| |Pager: 888.985.8519 | | |-+---| John Fix 3rd john3list@corTo: CF-Talk [EMAIL PROTECTED] nells.comcc: Subject: RE: SQL Server memory use grows 07/25/2001 12:31 PM Please respond to cf-talk There's 512mb installed right now. OK, if that doesn't seem out of line, then I'll leave it for a longer period next time and see what happens. Thanks! John -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 10:46 AM To: CF-Talk Subject: RE: SQL Server memory use grows 140MB? that sounds like SQL, not a memory leak. you can restrict the amount of memory (or range thereof) SQL uses. how much RAM is on your SQL server? it really shouldn't be less than 512MB and ideally, 1GB+. -Original Message- From: John Fix 3rd [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 7:27 AM To: CF-Talk Subject: SQL Server memory use grows I finally moved some of our Cold Fusion Access databases to SQL Server 7 on a separate server. Things are running well, but I notice that over several days SQL uses more and more memory. It starts at about 40mb but is now running at about 90mb. When I restarted the service a few days ago, it was up to about 140mb. Sounds like a memory leak somewhere, but I need some ideas where to look. Thanks! John www.cornells.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: Hebrew in SQL
Without using Unicode, the only way to do it is to reset your code page to one that includes hebrew characters. However, you can only do that when you install the server. |-+---| |Eric A. Laney|The closed mouth swallows no flies.| |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 | - Spanish proverb| |Pager: 888.985.8519 | | |-+---| Michael Lugassy To: CF-Talk [EMAIL PROTECTED] cfusion@imvacc: mp.com Subject: Hebrew in SQL 07/25/2001 01:39 PM Please respond to cf-talk Do you know if I can put hebrew characters inside a SQL 7.0 database? I want to enable full-text searching via MS-SQL capability, Will one of MSSQL versions will support it? Do I need a hebrew supported operating system for that? (I don't want to use unicode) Thanks, Michael. ~~ 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: Browser Sniffing and Serving StyleSheets
Nothing, unless JavaScript is turned off. Probably only 1% of the users would even know where to go to turn it off, but if you do it from CF then you even get that 1%. |-+---| |Eric A. Laney|The closed mouth swallows no flies.| |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 | - Spanish proverb| |Pager: 888.985.8519 | | |-+---| Scott Van Vliet scottv@juxtinteraTo: CF-Talk [EMAIL PROTECTED] ctive.comcc: Subject: Re: Browser Sniffing and Serving StyleSheets 07/25/2001 01:04 PM Please respond to cf-talk What's wrong with JavaScript Detection?: if ( navigator.userAgent.indexOf('Win') == -1 ) { document.write('link rel=stylesheet href=NonWindows.css'); } else { document.write('link rel=stylesheet href=Windows.css'); } - SVV - Original Message - From: Dasher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 9:11 AM Subject: Browser Sniffing and Serving StyleSheets I need to sniff the operating system (Mac or PC) and browser (Netscape or IE) type using Cold Fusion, then serve that particular configuration a particular StyleSheet based on that info. Does anyone have a solution or know where I could look for this information? Thanks! -- Dasher [EMAIL PROTECTED] http://www.bentmedia.com/ Bent Media, Inc. 128 South Clark Street New Orleans, LA 70119-6103 Phone - 504.488.2848 x19 Fax - 504.488.2979 ~~ 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 Server memory use grows
According to Microsoft's documentation (for what that's worth) SQL Server will not dynamically allocate memory if that allocation would cause swapping. The OS might, but not SQL Server. |--+--| |Eric A. Laney |A beautiful woman is the hell of the soul, the purgatory | |Systems |of the purse, and the paradise of the eyes. | |Engineer | | |LAN | | |Optimization | - Fontenelle| |Team | | |Voice:| | |813.978.4404 | | |Pager:| | |888.985.8519 | | |--+--| tom muck tommuck@basic-druTo: CF-Talk [EMAIL PROTECTED] mbeat.comcc: Subject: Re: SQL Server memory use grows 07/25/2001 01:22 PM Please respond to cf-talk You shouldn't have to wait and see. There is a specified amount used by SQL Server which you can find out by right-clicking on the server in the Enterprise Manager and then click the Memory tab. I think it's set to 768 megs by default as the max and 0 as the min. You can also specify a fixed amount of memory. If you only have 512, you should set it to well below this value so that it doesn't start using virtual memory. tom www.basic-ultradev.com John Fix 3rd [EMAIL PROTECTED] wrote in message 000601c11527$39372e30$6a2f43ce@MONSTER">news:000601c11527$39372e30$6a2f43ce@MONSTER... There's 512mb installed right now. OK, if that doesn't seem out of line, then I'll leave it for a longer period next time and see what happens. Thanks! John ~~ 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: Country - States Database
I don't have a reference for the states, but here's a link to all of the countries as defined by ISO 3166 (dated 1997-08-07): ftp://ftp.ripe.net/iso3166-countrycodes |--+--| |Eric A. Laney |A beautiful woman is the hell of the soul, the purgatory | |Systems |of the purse, and the paradise of the eyes. | |Engineer | | |LAN | | |Optimization | - Fontenelle| |Team | | |Voice:| | |813.978.4404 | | |Pager:| | |888.985.8519 | | |--+--| Kirk Boecker kirk_b@howard-edTo: CF-Talk [EMAIL PROTECTED] wards.com cc: Subject: Country - States Database 07/25/2001 01:23 PM Please respond to cf-talk Does anyone know where I might find a global database of Countries and their States? I have seen some that cover the US and Canada, but I need a global one. Any help would be appreciated Kirk ~~ 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: Country - States Database
Here's what I have in one of my databases... Mexico isn't complete, but I'm pretty sure that Canada is. My partner even threw in two of Sweden's as a bonus. AB Alberta Canada BC British ColumbiaCanada MB ManitobaCanada NB New Brunswick Canada NF NewfoundlandCanada NT Northwest Terr. Nunavut Canada NS Nova Scotia Canada ON Ontario Canada PE Prince Edward IslandCanada QC Quebec Canada SK SaskatchewanCanada YK Yukon Canada DF Distrito FederalMexico MX Mexico Mexico JO Jonkoping Sweden UP Uppland Sweden AL Alabama United States of America AK Alaska United States of America AZ Arizona United States of America AR ArkansasUnited States of America CA California United States of America CO ColoradoUnited States of America CT Connecticut United States of America DE DelawareUnited States of America FL Florida United States of America GA Georgia United States of America HI Hawaii United States of America ID Idaho United States of America IL IllinoisUnited States of America IN Indiana United States of America IA IowaUnited States of America KS Kansas United States of America KY KentuckyUnited States of America LA Louisiana United States of America ME Maine United States of America MD MarylandUnited States of America MA Massachusetts United States of America MI MichiganUnited States of America MN Minnesota United States of America MS Mississippi United States of America MO MissouriUnited States of America MT Montana United States of America NE NebraskaUnited States of America NV Nevada United States of America NH New Hampshire United States of America NJ New Jersey United States of America NM New Mexico United States of America NY New YorkUnited States of America NC North Carolina United States of America ND North DakotaUnited States of America OH OhioUnited States of America OK OklahomaUnited States of America OR Oregon United States of America PA PennsylvaniaUnited States of America RI Rhode IslandUnited States of America SC South Carolina United States of America SD South DakotaUnited States of America TN Tennessee United States of America TX Texas United States of America UT UtahUnited States of America VT Vermont United States of America VA VirginiaUnited States of America WA Washington United States of America WV West Virginia United States of America WI Wisconsin United States of America WY Wyoming United States of America |+| |Eric A. Laney |People who have no faults are terrible; there is no way | |Systems Engineer|of taking advantage of them.| |LAN Optimization|| |Team|| |Voice: || |813.978.4404|| |Pager: || |888.985.8519|| |+|
Re: SQL Server memory use grows
Well, with my server, it means my pager goes off! =B) Seriously, the server will wait for a free lock until it times out, at which point it throws an ODBC error back to the person whose request could not get locked and an SQL error to the server's error event engine. If you want the exact text, I'll dig through a log file and get it. It's not a very pretty situation, since the user does get a big, nasty ODBC error in their face (if you don't have an error handling framework in place) and there's no telling what stored procedure or automatic maintenance job might have gotten whacked. The good part is that the server doesn't start disk swapping, because SQL Server stops trying to allocate Locks when the next lock allocation would force a swap. It also throws the error instead of violating your dB integrity, so the worst thing is that your user waits a minute and then tries again. I highly recommend that you set up your SQL Server event engine with your email address and pager number, and have it notify you of these sorts of things. It's really easy to do from Enterprise Manager, and it sure makes you look good when you can know of the problem ahead of your boss... |--+--| |Eric A. Laney |All the little things you and I understand and expect from| |Systems |life, such as: equality; kindness; justice... | |Engineer | | |LAN | | |Optimization |- Spock, The Cloud Minders, stardate 5818.4.| |Team | | |Voice:| | |813.978.4404 | | |Pager:| | |888.985.8519 | | |--+--| Bill DavidsonTo: CF-Talk [EMAIL PROTECTED] bill@intragecc: t.com Subject: Re: SQL Server memory use grows 07/25/2001 05:07 PM Please respond to cf-talk Eric - What's the behavior when it runs out of locks? Regards. -Bill www.brainbox.tv - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 1:27 PM Subject: RE: SQL Server memory use grows My SQL Server 7.0 box has 512MB and does nothing but SQL. The last time I rebooted it to do a hotfix, it was running with over 400MB of RAM dedicated to SQL Server. The only problem I run into is when I get a big spike of activity and the server runs out of Locks. I'll be moving my Client variable data store to a different SQL server soon, which should alleviate that problem. In short, I don't think 140MB is anywhere close to being a problem. |-+---| |Eric A. Laney|The closed mouth swallows no flies. | |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 | - Spanish proverb| |Pager: 888.985.8519 | | |-+---| John Fix 3rd john3list@corTo: CF-Talk [EMAIL PROTECTED]