Re: Apache webserver and CF
Michael, Is there a database call in the Application.cfm file of your app? If there is it could explain the odbc error you are getting. As for the mappings/missing images where you using absolute or relative paths? Are the paths stored in the database as well? I would check this out first to be sure path info is correct for the machine you are currently on. Also I have worked on apps that have parsed the gettemplatepath() output to set the web root. If the actual paths are different on your machine than they were on the production box all links will be broken. Even if the directory configuration is exactly the same on the boxes if the production box is unix and you are using windows any paths based on the template path will be different (/ unix vs \ windows). Michael S. Kimmett wrote: I am having troubles with a ColdFusion application that I have moved from my company's test webserver to my personal machine. My machine is running Win 98, Apache 1.17, CFServer 4.5sp2. The test server that was running the application without any problems was running WinNT, IIS, CFServer 4.5sp2. I have made all the mappings in my Apache ..conf file that were made for IIS. I have made all the CFServer mappings on my machine that were on the test machine. So at this point none of the mapped paths are working. In an attempt to test the application using the non-mapping address ( Non Mapped Address: http://localhost/client/inprogress/index.cfm Mapped Address: http://localhost/ABC ) when I hit the index.cfm page I am getting broken images ( I have an template that I am including on the index page that is setting variables that are called in the app which reference the mapped URL address) as well as this weird ODBC error: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'CGLOBAL'. Date/Time: 06/15/01 09:08:07 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98) Remote Address: 127.0.0.1 What is weird about this error is that their is no DB connection made on this template (index.cfm). Does anyone have an idea as to why I am having all this trouble with this app? Has anyone else had a similar experience? I am looking for some advice on what to do. Thanks in advance. --Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Interesting Date issue
Well if you copied the code exactly here you are missing a ) CFSET Today = Dateformat(Now(), mm/dd/yy should be CFSET Today = Dateformat(Now(), mm/dd/yy) Kevin Schmidt wrote: Ok...either I am doing something stupid or something is wrong here. This is on CF 5.0 I am using CFSET Today = Dateformat(Now(), mm/dd/yy and then inserting today into a database table. I end up with 12/31/1899. Here is the really tricky part. After that date is set I use DateAdd to add a month to it and insert it into the database at the same time as the other and I get the correct date. Any ideas. By the way I changed the today code to CFSET Today = CreateODBCDate(Now()) and it is fine. But I am still curious as to why the other way was producing that result??? Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating multiple rows!
Try using PART_ID =751 OR PART_ID =752 instead of PART_ID =751 AND PART_ID =752 or try PART_ID IN ('751,752') not sure if that is correct syntax off the top of my head. Mark Smyth wrote: Ben your code there is trying to update a product which has a productId of 751 AND 752 it won't find it HTH Mark -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 16:25 To: CF-Talk Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? CFQUERY NAME=engineeringinfo DATASOURCE=Biosreference DBTYPE=ODBC Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben /CFQUERY ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dhtml menu
Try Hiermenus http://www.webreference.com/dhtml/ If you need to use cf to dynamically create the menus I have gotten it to work this way... you will need to modify the scripts a bit though. Email me off list if you want to see what I have done to integrate this with cf. Thanks, Frederic Mak Wing Lok wrote: did anyone know is there any dhtml menu CF tags that can work in IE and Netscape, i tried CF_dhtmlMenu but it only works on IE, i need a CF tag that will work on both browser. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: deleting records in a dbase III table
Are you getting an error? If so what is it please post the code and I'll take a look... I have worked a bit with dbf files and may be able to help. Also helpfull would be the os and cf version you are using. Thanks, Frederic Terry Troxel wrote: I am stumped as to why I cannot delete records from a dbase III dbf file that is defined as an odbc source using the MS dbase 3 ODBC driver. I can update, insert, but no delete. Any and all suggestions would be greatly appreciated. Terry The datasource is defined as test.dbf and pointing to the directory the dbf files are located. The table I am using is work.dbf. I am using delete from work ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFSToredProcedures
Darren, I have run into this problem as well. One way I delt with it, if you have enough ram, is you can write the resultset to a session variable and reference it that wayI guess it depends on the size of the resultset and how many users will be making requests to the search engine as to whether this will be of any use in your situation. You can also code something into the Application.cfm page that would look for a certain url or form variable associated with the search results and if it wasn't there delete the variable holding the recordset so you didn't tie up resources when the user was no longer paging through the set. Frederic Darren Nickerson wrote: Of course..here's an example of how to can an SP using CF... CFSTOREDPROC Procedure=proc name DATASOURCE=datasource RETURNCODE=Yes CFPROCPARAM TYPE=In DBVARNAME=dbvarname1 CFSQLTYPE=data type1 VALUE=value1 CFPROCPARAM TYPE=In DBVARNAME=dbvarname2 CFSQLTYPE=data type1 VALUE=value2 CFPROCRESULT name=results /CFSTOREDPROC cfoutput query=results. ... ... /cfoutput You can also pass get the SP to pass back output params aswell as multiple resultsets. We would love to be able to use ORACLE stored procedures to power a search facility on our site, but we have been bitten by one of the MAJOR shortcomings of CFSTOREDPROC. Whereas you can cache results sets using CFQUERY (CACHEWITHIN attribute), we don't seem to be able to do this with CFSTOREDPROC. We're trying to display the results of a large query using a pager . . . results 1-10 of 300, 11-20 of 300, next page, next page, etc etc. We've had to abandon the stored procedure approach, because to display page 2 we have to execute the stored procedure all over again and pull in the results with a REFCURSOR. If the results come from a CFQUERY there's no problem, displaying page 2 takes advantage of the cached results set and display is lightning fast without ever hitting the database. Unless I'm wrong this is something you really need to take into account when considering using stored procedures. If you want to be able to reuse the query results you really should use CFQUERY. -Darren ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and custom style sheets
Just a note here, I tried to map .js files to cf in iis and it didn't parse them as cf when called as LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I would bet it doesn't like css files much better in that format. If anyone has had any luck configuring cf to parse these files I would like to get your method. Thanks, Frederic Sean Daniels wrote: On 5/10/01 1:27 PM Scott Weikert wrote: LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I've had some hassles trying to link the page like this... it doesn't seem to properly execute the CF code within. Anyone out there tried to do this same thing, and succeeded? Input would be most welcome. Two suggestions: 1. Make a new style sheet for each option, and use: cfoutput LINK REL=Style Sheet TYPE=text/css HREF=#attributes.stylesheet#.cfm /cfoutput Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Parsing .js files in cf...was CF and custom style sheets
I take your point. I have had a reason for trying to parse .js files through cf though. I was trying to use CF to dynamically generate the menu arrays in the dhtml HierMenu scripts. This would not work because any cf code that I tried to use was being caught as a js syntax error because it was not being parsed by cf. I could modify the version 3.X scripts and get them to work with coldfusion but I have tried just about everything to get the 4.X version to work with cf but they do not seem compatible. I tried adding .js files to be parsed by cfserver but that didn't work. I didn't get an error but the menus did not get built. Has anyone had any luck using hiermenus 4.X with cf? [EMAIL PROTECTED] wrote: Note to note... All I did was LINK REL=StyleSheet TYPE=text/css HREF=style.cfm, with no changes to iis, and it worked fine. (Which doesn't affect my earlier point that there's nothing gained in doing this.) Robert -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:59 AM To: CF-Talk Subject: Re: CF and custom style sheets Just a note here, I tried to map .js files to cf in iis and it didn't parse them as cf when called as LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I would bet it doesn't like css files much better in that format. If anyone has had any luck configuring cf to parse these files I would like to get your method. Thanks, Frederic Sean Daniels wrote: On 5/10/01 1:27 PM Scott Weikert wrote: LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I've had some hassles trying to link the page like this... it doesn't seem to properly execute the CF code within. Anyone out there tried to do this same thing, and succeeded? Input would be most welcome. Two suggestions: 1. Make a new style sheet for each option, and use: cfoutput LINK REL=Style Sheet TYPE=text/css HREF=#attributes.stylesheet#.cfm /cfoutput Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Finding the last item in a loop
Try This cfset count=0 cfloop query=qry_show_event_sponsors cfset count=(count+1) #EventSponserName#cfif count LT qry_show_event_sponsors.recordcount,/cfif /cfloop Chris Martin wrote: IS it possible to find the last item in a loop? Right now I have this: cfloop query=qry_show_event_sponsors #EventSponserName#, /cfloop Is it possible to check if the #EventSponsorName# is the last item in the record set, and then not display the comma? I.E. cfloop query=qry_show_event_sponsors #EventSponserName#cfif something,/cfif /cfloop Thanks in advance Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NEED HELP!
Heidi, It looks like the table you are trying two insert into (PeopleDirectory) does not exist in the SQL database represented in the YALLA datasource. Heidi Belal wrote: can some one tell me the reason for this error and how i can solve the problem? Thanks! Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'PeopleDirectory'. SQL = "INSERT into PeopleDirectory (FirstName, LastName, HomeAddress, HomePhone, Mobile, JobDescription, Department) VALUES ('Heidi', 'Belal', 'whatever', 23232, 23232, 'whatever', 'whatever')" Data Source = "YALLA" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (8:1) to (8:27) in the template file C:\INETPUB\WWWROOT\YALLANESA3ED\ADMIN\SQL_ADDPERSON.CFM. Date/Time: 04/18/01 13:02:47 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 217.52.80.114 HTTP Referer: http://217.52.80.114/yallanesa3ed/admin/index.cfm?method=PeopleDirectory Query String: method=AddPerson = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF 4.5 ent on Solaris
We have used oracle sp's to return cursors like so: cfstoredproc datasource="#SID#" procedure="AKC.PKG_COMPREC.pr_get_skip_fail" returncode="no" cfprocparam dbvarname="in_cde_comp_group" cfsqltype="cf_sql_varchar" value="#in_cde_comp_group#" type="in" cfprocparam dbvarname="in_cde_product_type" cfsqltype="cf_sql_varchar" value="#in_cde_product_type#" type="in" cfprocparam dbvarname="out_return_code" variable="out_return_code" cfsqltype="cf_sql_float" type="out" cfprocparam dbvarname="csr_group_for_events" variable="csr_group_for_events" cfsqltype="CF_SQL_REFCURSOR" type="inout" cfprocresult name="get_skip_fail" /cfstoredproc Also you can convert pl/sql tables to a query as follows: cfstoredproc datasource="#SID#" procedure="AKC.pkg_code_table_values.PR_all_breeds_by_comp_no_var" returncode="no" cfprocparam dbvarname="in_cde_competition_type" cfsqltype="cf_sql_varchar" value="#in_cde_comp_group#" type="in" cfprocparam dbvarname="out_t_cde_bvg_num" variable="out_t_cde_bvg_num" cfsqltype="cf_sql_varchar" maxrows="200" type="out" cfprocparam dbvarname="out_t_desc_bvg" variable="out_t_desc_bvg" cfsqltype="cf_sql_varchar" maxrows="200" type="out" /cfstoredproc cfset PR_GROUPS_BREEDS=QueryNew("") cfset rc=QueryAddColumn(PR_GROUPS_BREEDS, "out_t_cde_bvg_num", out_t_cde_bvg_num) cfset rc=QueryAddColumn(PR_GROUPS_BREEDS, "out_t_desc_bvg", out_t_desc_bvg) I don't know if that helps but it's all I can offer. Frederic [EMAIL PROTECTED] wrote: I don't know if there are solaris-specific issues. In CF 4.0x it was only possible to do this with ugly kludges. With CF 4.5x it can be done using the CFSTOREDPROC tag; it's only documented in the "new features in 4.5" file in an area titled "Oracle Reference Cursor Support". I've used the feature on NT 4 without problems. -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 10:39 AM To: CF-Talk Subject: CF 4.5 ent on Solaris We have an application that will be running on CF 4.5 Enterprise on Solaris 2.6, against an Oracle 8i 8.15 database (also on Solaris). I'm told there will be an issue with Oracle returning recordsets using stored procedures in CF. Evidently the cursor type specified by CF in the connection is incompatible with Oracle stored procs. Does anyone have any information on this issue? I need to make some decisions before we create the development environment, etc. Thanks in advance, Jeff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Application varriables
I have seen alot of post lately about the "horrid deficincies" of using application variables. If application scoped variables are so "bad" why are they even offered as a solution? I have found that using application scoped variables work fine for the applications I have used them in. Admitidly we are using a single server and are not looking at clustering in the near future. However the applications where I use the session scope are fault tolerant in that if we do cluster the information contained within the session can be "rebuilt" transparently on an other server if one goes down. If you code for the possibility of this and the work-around is sound then what difference does it make if the variables are client or session scoped? I would really like to know for sure for future implementations. Thanks / \__ Frederic Valone (@\___ Webmaster / O American Kennel Club /(_/ /_/ U ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
query troubles
hello, Can anyone show me what is wrong with this query? I know that I really should use another method to put this information into the database (triggers or sps come to mind) but I am using dbf files exported out of access on a unix box to prototype the app and they do not support these functions. Here is the error ODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC dBase driver]Missing VALUES keyword in INSERT statement SQL = "insert into HERDING, WORKING, TOY, TERRIER, SPORTING, NON_SPOR, HOUND (HERDING.SHOW_ID, WORKING.SHOW_ID, TOY.SHOW_ID, TERRIER.SHOW_ID, SPORTING.SHOW_ID, NON_SPOR.SHOW_ID, HOUND.SHOW_ID) values (14, 14, 14, 14, 14, 14, 14)" and here is the query cfquery name="insert_show_id" datasource="#dsds#" dbtype="ODBC" insert into HERDING, WORKING, TOY, TERRIER, SPORTING, NON_SPOR, HOUND (HERDING.SHOW_ID, WORKING.SHOW_ID, TOY.SHOW_ID, TERRIER.SHOW_ID, SPORTING.SHOW_ID, NON_SPOR.SHOW_ID, HOUND.SHOW_ID) values(#trim(show_id)#, #trim(show_id)#, #trim(show_id)#, #trim(show_id)#, #trim(show_id)#, #trim(show_id)#, #trim(show_id)#) /cfquery I also tried it with cfquery name="insert_show_id" datasource="#dsds#" dbtype="ODBC" insert into HERDING, WORKING, TOY, TERRIER, SPORTING, NON_SPOR, HOUND (SHOW_ID) values(#trim(show_id)#) /cfquery / \__ Frederic Valone (@\___ Webmaster / O American Kennel Club /(_/ /_/ U ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: query troubles
Yeah thanks, That was my thought too kinda through me off with the error though. So much for trying thatI can just loop over the tablenames list and get the same result I was looking for .. I was just hoping on a more efficient method. Thanks again, Frederic "Hayes, David" wrote: I believe you can only insert into 1 table per insert statement; you'll have to break it into multiple statements. -Original Message----- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 12:47 PM To: CF-Talk Subject: query troubles hello, Can anyone show me what is wrong with this query? I know that I really should use another method to put this information into the database (triggers or sps come to mind) but I am using dbf files exported out of access on a unix box to prototype the app and they do not support these functions. Here is the error ODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC dBase driver]Missing VALUES keyword in INSERT statement SQL = "insert into HERDING, WORKING, TOY, TERRIER, SPORTING, NON_SPOR, HOUND (HERDING.SHOW_ID, WORKING.SHOW_ID, TOY.SHOW_ID, TERRIER.SHOW_ID, SPORTING.SHOW_ID, NON_SPOR.SHOW_ID, HOUND.SHOW_ID) values (14, 14, 14, 14, 14, 14, 14)" and here is the query cfquery name="insert_show_id" datasource="#dsds#" dbtype="ODBC" insert into HERDING, WORKING, TOY, TERRIER, SPORTING, NON_SPOR, HOUND (HERDING.SHOW_ID, WORKING.SHOW_ID, TOY.SHOW_ID, TERRIER.SHOW_ID, SPORTING.SHOW_ID, NON_SPOR.SHOW_ID, HOUND.SHOW_ID) values(#trim(show_id)#, #trim(show_id)#, #trim(show_id)#, #trim(show_id)#, #trim(show_id)#, #trim(show_id)#, #trim(show_id)#) /cfquery I also tried it with cfquery name="insert_show_id" datasource="#dsds#" dbtype="ODBC" insert into HERDING, WORKING, TOY, TERRIER, SPORTING, NON_SPOR, HOUND (SHOW_ID) values(#trim(show_id)#) /cfquery / \__ Frederic Valone (@\___ Webmaster / O American Kennel Club /(_/ /_/ U ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Migration from NT4 to Solaris
I have found through my experiences that CF on NT4 has been a better performer and had more stability than on Solaris. Most of my experiences were pre cf 4.5.1 but I still find NT to be preferable for running the CF server and the web server. Capolinea wrote: Hello to all CF Guru, I was asked by my boss to look for informations in order to migrate a web site from NT4 to Solaris We are running CF 451 US Enterprise on 2 front server and a database Oracle 8i running on another server. Is it worth doing that? What the pro and cons? Any ideas, experience or advice would be GREATLY appreciate... merçi à tous! Regards, Rémi van der Deure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: isdefined obsolete?
Tim This can be the case when I single programmer, no matter what level has a problem... if that problem then persists after re-writing the code and you then pass the questionable code over to two other programmers to to check and they still have the same issue the problem is probibaly not that everyone overlooked a simple syntax error. Please kill this thread now I do not feel like defending my experiences any more (I already have conformation that others have experienced the same problem) Thanks to all for their input. Frederic Tim Fields wrote: Gentlemen, It seems most likely that there was some variety of a syntax error in the errant IsDefined() condition. How many times have you stared at code convinced it should work only to suddenly see a extraneous or missing character like a single quote? Sometimes we are looking at the forest not the trees. I'd suggest that when perplexed about a single line of code not functioning properly, start by doing the old proof reading method of reading the line backwards. Also I've occasionally found it helpful to print out the code in color and then used various colored highlighters to mark up the code, especially helpful with breaking down regular expressions. Sorry that's a bit Off Topic and probably not real useful to advanced programmers, but it would seem to address what is most likely at the root of this IsDefined "problem". Tim Fields -Original Message- From: Ruslan Sivak [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 12:25 PM To: CF-Talk Subject: RE: "isdefined" obsolete? The only time I had a problem using isDefined is when I forgot to use quotation marks around the variable. The other thing is I don't think isdefined works well on structs, you have to use StructKeyExists. -Original Message----- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 1:48 PM To: CF-Talk Subject: Re: "isdefined" obsolete? If you see my previous response you'll see I tried all forms of syntax... even those I "knew" were incorrect as stated the problem was not logical so I tried illogical solutions as well. This happened I would say two years or more ago... so I doubt very much I was using 4.5.1 as it hadn't been released...I only mentioned the whole issue as an FYI. I see it did happen for someone else on the list as well. Frederic Philip Arnold - ASP wrote: Sorry to contadict you Adrian, but I can say with complete conviction (and no explanation at all) that these experiences did happen...I know that obviously a variable either exists or doesn't. That doesn't mean that in every instance a function will work though. I replaced the isdefined function (after checking to be sure the syntax was correct) with parameterexists and it worked. I switched it back to isdefined and it did not. I did it in more than one instance and I confirmed the issue and verified the results of the workaround with other cf programmers on site. As long as the quotes are around the variable name, then it will work - unless you're running a not-upgraded version of CF (4.0 or 4.5 rather than 4.0.1 and 4.5.1 SP2) I've never had a problem with isDefined(), and it's much easier to use than ParameterExists(), especially if you're using dynamic names isDefined("form.#i#") is easier than Evaluate("ParameterExists(form.#i#)") for obvious reasons although both should work exactly the same Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WOT: Serving to the web using W2K, IIS and DSL
I have a ADSL (runs faster downstream than up) and have no trouble hosting web sites off of this setup. Jeffry Houser wrote: It depends upon the terms and conditions of her agreement with the DSL company. To host something, all you need is an internet connection. You can do it on a dial-up (although you won't get very good performance). All cable modem agreements I've seen forbid using the cable modem to host a server. DSL? Have her check her agreement. It would depend upon whether you have Asynchronous DSL or Synchronous DSL. (One has the same speed both ways, one is faster at downloading than sending, I forget which is which). I imagine same speed both ways would allow it, but one-way speed would not. Of course, that all depends on the agreement. At 05:53 AM 02/26/2001 -0700, you wrote: Sorry for the off-topic post. I have a co-worker halfway across the nation who is building some GIS applications using ARC IMS. She's running a W2K machine, IIS and has a DSL connection to the web. Can she serve her own applications to the web so the rest of the team can see what she's doing? A point in the right direction would be much appreciated! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: isdefined obsolete?
I have always had intermittent trouble with the isdefined() function most of the time it worked but in some instances it seemed not toI always got the functionality I needed back by switching to parameterexists(). I know isdefined is supposed o be the "preferred" method but it was inconsistent for me so I have ended up using parameterexists for all my variable checking needs. Just my experiences... yours are probably different, but I am sorry to see parameterexists() depreciated. Frederic Philip Arnold - ASP wrote: Do I recall correctly that "isdefined" is no longer valid for use in CF? Yes, as are CFOUTPUT, CFQUERY and CFINCLUDE... they just took them right out... yup, just took them right out... This is like them taking Gullible out of the dictionary, right? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: isdefined obsolete?
Sorry to contadict you Adrian, but I can say with complete conviction (and no explanation at all) that these experiences did happen...I know that obviously a variable either exists or doesn't. That doesn't mean that in every instance a function will work though. I replaced the isdefined function (after checking to be sure the syntax was correct) with parameterexists and it worked. I switched it back to isdefined and it did not. I did it in more than one instance and I confirmed the issue and verified the results of the workaround with other cf programmers on site. Why would I say the problem did arise and have such a simple a workaround if it was a figment of my imagination or some other underlying issue totally seperate from the cf function? I do not remember what version of CFAS or on what platform it was running (I do know it wasn't 4.5x. I also no longer have the exact pages where I had the issue off the top of my head. I have been programming in cf for 5 years now so the jobsites where the pages reside are not necessarily available to me now anyway I replaced the isdefined function on them anyway so I couldn't find them even if I had access. All I am saying is that you cannot tell me what happened or that it could't without working on the applications I did in the environment I was working in. I always say "if it doesn't work do what it takes to corrrect it" In this case I did not get stuck on the fact that the problem was totally illogical. I simply made it work. In this case it was as simple as a change of function. I have seen postings up here for issues that should never have come up logically speaking yet they do. I would think it is more productive to say "that is an interesting issue...how did it happen" in any of these cases. Than to say "that can't happen because" Whenever I try that one on the users of applications I have worked on I am reminded that I do not have all the answers. sorry about the typo I hope I won't be graded on it ;-) Frederic Aidan Whitehall wrote: Oh yeah, I have the same problem. Sometimes functions work and sometimes they don't. I reckon it depends on the weather... Sorry to be sarcastic, but how can you say "most of the time it worked but in some instances it seemed not to" with any conviction? Variables either exist or they don't; there's not a lot of scope for anything in-between. I am sorry to see parameterexists() depreciated. I'm not. It's more to type;-) And it's "deprecated", BTW. Depreciation is what your car does over time. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: isdefined obsolete?
If you see my previous response you'll see I tried all forms of syntax... even those I "knew" were incorrect as stated the problem was not logical so I tried illogical solutions as well. This happened I would say two years or more ago... so I doubt very much I was using 4.5.1 as it hadn't been released...I only mentioned the whole issue as an FYI. I see it did happen for someone else on the list as well. Frederic Philip Arnold - ASP wrote: Sorry to contadict you Adrian, but I can say with complete conviction (and no explanation at all) that these experiences did happen...I know that obviously a variable either exists or doesn't. That doesn't mean that in every instance a function will work though. I replaced the isdefined function (after checking to be sure the syntax was correct) with parameterexists and it worked. I switched it back to isdefined and it did not. I did it in more than one instance and I confirmed the issue and verified the results of the workaround with other cf programmers on site. As long as the quotes are around the variable name, then it will work - unless you're running a not-upgraded version of CF (4.0 or 4.5 rather than 4.0.1 and 4.5.1 SP2) I've never had a problem with isDefined(), and it's much easier to use than ParameterExists(), especially if you're using dynamic names isDefined("form.#i#") is easier than Evaluate("ParameterExists(form.#i#)") for obvious reasons although both should work exactly the same Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
stored proc trouble
I have created a stored proc in SQL 7 and for some reason cannot get it to "work" using the input params I need. here is the proc: CREATE PROCEDURE CONSULTINFO @user_n nvarchar, @pass_w nvarchar, @user_id int AS select u.cons_id, u.user_n, u.pass_w,c.first_n, c.last_n, c.phone, c.email, c.city, c.state_id, c.level_id, c.resume, c.enterdate, c.availability, c.type from reg_users u, consultants c where u.pass_w = "@pass_w" and u.user_n="@user_n" in the above I added the user_id field after for checking purposes. If I run the proc using the user_id as the in param the proc returns a row correctly. (I have also tried using single quotes in the where clause and no quotes, neither helped) I have checked the values of the user_n and pass_w and they are correct ( a cfquery using the same values returns the right info) here is the cf code: cfquery name="TEST" datasource="jobs_db" dbtype="ODBC" SELECT u.cons_id, u.user_n, u.pass_w,c.first_n, c.last_n, c.phone, c.email, c.city, c.state_id, c.level_id, c.resume, c.enterdate, c.availability, c.type FROM dbo.CONSULTANTS C, dbo.REG_USERS U WHERE (U.USER_N='#user_n#' and U.PASS_W='#pass_w#') and (C.CONS_ID=U.CONS_ID) /cfquery !--- CFSTOREDPROC tag --- CFSTOREDPROC PROCEDURE="consultinfo" DATASOURCE="jobs_db" DEBUG !--- CFPROCRESULT tags --- CFPROCRESULT NAME = cons !--- CFPROCPARAM tags --- CFPROCPARAM TYPE="IN" cfsqltype="CF_SQL_VARCHAR" VALUE="#user_n#"DBVARNAME=@user_n CFPROCPARAM TYPE="IN" cfsqltype="CF_SQL_VARCHAR" VALUE="#pass_w#"DBVARNAME=@pass_w !--- this line was added for testing using the user_id and it then returned the information I needed --- !---CFPROCPARAM TYPE="IN" cfsqltype="CF_SQL_INTEGER" VALUE="1"DBVARNAME=@user_id!--- !--- Close the CFSTOREDPROC tag --- /CFSTOREDPROC h3The Results Information test/h3 CFOUTPUT#cons.recordcount# br#cons.USER_N# /CFOUTPUT I have also tried hard-coding the values of @used_n and @pass_w in both the cf and the stored proc with no better results. Any ideas on what I am doing wrong? thanks, Frederic -- / \__ Frederic Valone (@\___ Webmaster / O American Kennel Club /(_/ /_/ U ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: stored proc trouble
Thanks Eric I'll try that when I get home. Eric Barr wrote: A couple of things could be going wrong 1) nvarchar . is used for Unicode text. Do you need Unicode text ? 2) when declaring a nchar or nvarchar when n is not specified in a data definition or variable declaration statement, the default length is 1. 3) their is no need for quotes in your WHERE clause 4) You might want to upgrade your JOIN syntax ...some types of Joins in SQL 7 and newer can product "Unpredictable Results" when you put the join clause in the WHERE clause. And, personally I find that my queries are a bit clearer when I use the ANSI join syntax Your statement might read : CREATE PROCEDURE CONSULTINFO @user_n varchar (50), @pass_w varchar (50), @user_id int AS SELECT u.cons_id, u.user_n, u.pass_w, c.first_n, c.last_n, c.phone, c.email, c.city, c.state_id, c.level_id, c.resume, c.enterdate, c.availability, c.type FROMreg_users u ON c.cons_id = u.cons_id INNER JOIN consultants c WHERE u.pass_w = @pass_w AND u.user_n=@user_n Hope this helps. -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message----- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 11:58 AM To: CF-Talk Subject: stored proc trouble I have created a stored proc in SQL 7 and for some reason cannot get it to "work" using the input params I need. here is the proc: CREATE PROCEDURE CONSULTINFO @user_n nvarchar, @pass_w nvarchar, @user_id int AS select u.cons_id, u.user_n, u.pass_w,c.first_n, c.last_n, c.phone, c.email, c.city, c.state_id, c.level_id, c.resume, c.enterdate, c.availability, c.type from reg_users u, consultants c where u.pass_w = "@pass_w" and u.user_n="@user_n" in the above I added the user_id field after for checking purposes. If I run the proc using the user_id as the in param the proc returns a row correctly. (I have also tried using single quotes in the where clause and no quotes, neither helped) I have checked the values of the user_n and pass_w and they are correct ( a cfquery using the same values returns the right info) here is the cf code: cfquery name="TEST" datasource="jobs_db" dbtype="ODBC" SELECT u.cons_id, u.user_n, u.pass_w,c.first_n, c.last_n, c.phone, c.email, c.city, c.state_id, c.level_id, c.resume, c.enterdate, c.availability, c.type FROM dbo.CONSULTANTS C, dbo.REG_USERS U WHERE (U.USER_N='#user_n#' and U.PASS_W='#pass_w#') and (C.CONS_ID=U.CONS_ID) /cfquery !--- CFSTOREDPROC tag --- CFSTOREDPROC PROCEDURE="consultinfo" DATASOURCE="jobs_db" DEBUG !--- CFPROCRESULT tags --- CFPROCRESULT NAME = cons !--- CFPROCPARAM tags --- CFPROCPARAM TYPE="IN" cfsqltype="CF_SQL_VARCHAR" VALUE="#user_n#"DBVARNAME=@user_n CFPROCPARAM TYPE="IN" cfsqltype="CF_SQL_VARCHAR" VALUE="#pass_w#"DBVARNAME=@pass_w !--- this line was added for testing using the user_id and it then returned the information I needed --- !---CFPROCPARAM TYPE="IN" cfsqltype="CF_SQL_INTEGER" VALUE="1"DBVARNAME=@user_id!--- !--- Close the CFSTOREDPROC tag --- /CFSTOREDPROC h3The Results Information test/h3 CFOUTPUT#cons.recordcount# br#cons.USER_N# /CFOUTPUT I have also tried hard-coding the values of @used_n and @pass_w in both the cf and the stored proc with no better results. Any ideas on what I am doing wrong? thanks, Frederic -- / \__ Frederic Valone (@\___ Webmaster / O American Kennel Club /(_/ /_/ U ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
studio 4.5.2 upgrade error issues
I just finished upgrading to 4.5.2 from the beta I was running and am now unable to conect to any of the datasource panes on my rds servers. Here is the error Error loading type library/dll Any ideas what I can do to fix this? the beta worked fine for me but it expires on wed. Thanks -- / \__ Frederic Valone (@\___ Webmaster / O American Kennel Club /(_/ /_/ U ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: data in columns
If you are already selecting only the rows where cbi like 'CBI' then you will not get any of the rows where cbi is empty so you could just use the variable get.recordcount to get a count of rows. PS You cannot to my knowledge use the cf set as you have there referencing a column in the query from within the cfquery tag. Hope that helps, Frederic Robert Orlini wrote: Hello, I'm still a newbie with this one though I've tried. How can I count data in certain columns of a table for each record. Some records have no data in this field of the column so of course I don't want that counted. I kept it VERY VERY simple below. I've tried different configurations, but #cbicount# always returns a blank. Any help is always appreciated. Thank you. Robert O. -- Below I'm trying to count how many times CBI appears in the cbi column and display the total tally in the #cbicount# variable: cfquery name="Get" datasource="wweb" SELECT id, cbi FROM wweb Where cbi like 'CBI' cfif cbi EQ "CBI" cfset cbicount + 1 /cfif /cfquery CFOUTPUT #cbiCount# /CFOUTPUT ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Web Based SQL Manager
Where can I get this tool? I would love to try it out. Thanks Fred Clint Tredway wrote: Would any of you be interested in a web based SQL Server7 Manager(its free)? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: LARGE QUERY RETURNS
We are running a solaris quad 450 with a gig of ram and still get slow page display on large pages. So I do not know that more ram and another proccessor will help that much. Thanks, Frederic. Greg Wolfinger wrote: Now is there anything i can do to cut down on the time it takes to show those, other then doing a Next Previous system?? Beef up your server with some more RAM and a second processor. --Greg - Original Message - From: "William J Wheatley" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 05, 2001 10:52 AM Subject: LARGE QUERY RETURNS Ok I have found that when i return alot of returns to a page, 5000+ it adds quite a bit of time to the processing on the CF side with displaying the information as opposed to it being database bottleneck. In Fact the database is Hustling returning the 70,000 records in about 4 seconds but it takes CF quiet a bit of time to display them. Now is there anything i can do to cut down on the time it takes to show those, other then doing a Next Previous system?? Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Generating unique values
I just checked this out by generating a loop of 50 uuid's and found that none of the values are incremented by 1 they differ in various ways although the last portion of the id is the same in all cases. Here is the list that was generated 00075D9C-F809-1A51-B7D6809AFF5FEEB7 00075E16-F809-1A51-B7D6809AFF5FEEB7 00075E7D-F809-1A51-B7D6809AFF5FEEB7 00075EE1-F809-1A51-B7D6809AFF5FEEB7 00075F44-F809-1A51-B7D6809AFF5FEEB7 00075FA6-F809-1A51-B7D6809AFF5FEEB7 00076009-F809-1A51-B7D6809AFF5FEEB7 0007606B-F809-1A51-B7D6809AFF5FEEB7 000760CD-F809-1A51-B7D6809AFF5FEEB7 00076130-F809-1A51-B7D6809AFF5FEEB7 00076192-F809-1A51-B7D6809AFF5FEEB7 000761F4-F809-1A51-B7D6809AFF5FEEB7 00076257-F809-1A51-B7D6809AFF5FEEB7 000762B9-F809-1A51-B7D6809AFF5FEEB7 0007631B-F809-1A51-B7D6809AFF5FEEB7 0007637D-F809-1A51-B7D6809AFF5FEEB7 000763DF-F809-1A51-B7D6809AFF5FEEB7 00076441-F809-1A51-B7D6809AFF5FEEB7 000764A3-F809-1A51-B7D6809AFF5FEEB7 00076505-F809-1A51-B7D6809AFF5FEEB7 00076567-F809-1A51-B7D6809AFF5FEEB7 000765C9-F809-1A51-B7D6809AFF5FEEB7 0007662B-F809-1A51-B7D6809AFF5FEEB7 0007668C-F809-1A51-B7D6809AFF5FEEB7 000766EE-F809-1A51-B7D6809AFF5FEEB7 00076750-F809-1A51-B7D6809AFF5FEEB7 000767B2-F809-1A51-B7D6809AFF5FEEB7 00076815-F809-1A51-B7D6809AFF5FEEB7 00076877-F809-1A51-B7D6809AFF5FEEB7 000768D9-F809-1A51-B7D6809AFF5FEEB7 0007693B-F809-1A51-B7D6809AFF5FEEB7 000769A0-F809-1A51-B7D6809AFF5FEEB7 00076A04-F809-1A51-B7D6809AFF5FEEB7 00076A66-F809-1A51-B7D6809AFF5FEEB7 0007B06A-F809-1A51-B7D6809AFF5FEEB7 0007B0EE-F809-1A51-B7D6809AFF5FEEB7 0007B156-F809-1A51-B7D6809AFF5FEEB7 0007B1BB-F809-1A51-B7D6809AFF5FEEB7 0007B21D-F809-1A51-B7D6809AFF5FEEB7 0007B27E-F809-1A51-B7D6809AFF5FEEB7 0007B2E0-F809-1A51-B7D6809AFF5FEEB7 0007B342-F809-1A51-B7D6809AFF5FEEB7 0007B3A3-F809-1A51-B7D6809AFF5FEEB7 0007B405-F809-1A51-B7D6809AFF5FEEB7 0007B467-F809-1A51-B7D6809AFF5FEEB7 0007B4C8-F809-1A51-B7D6809AFF5FEEB7 0007B52A-F809-1A51-B7D6809AFF5FEEB7 0007B58C-F809-1A51-B7D6809AFF5FEEB7 0007B5EE-F809-1A51-B7D6809AFF5FEEB7 0007B64F-F809-1A51-B7D6809AFF5FEEB7 Tuesday, January 02, 2001, 6:15:41 AM, you wrote: J But it doesn't create values which are not easy to guess. J Two consecutive UUID will have similar values + 1 J Justin -Original Message- From: listmb [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 31, 2000 10:01 PM To: CF-Talk Subject: Re[2]: Generating unique values Thanks Nick, That was just what I was looking for! Best, WayGee Hello Nick, Sunday, December 31, 2000, 4:00:40 PM, you wrote: NM You can use the CreateUUID function. NM It generates a Universally Unique ID. It does contain both letters and numbers. NM At 03:58 PM 12/31/2000 -0500, you wrote: Hi, Being new to cold fusion (1 week), can anyone let me know if there is a way to create unique random numbers or strings in cold fusion? It should not be iterative or easily guessed. This would help alot! -- Best regards, WayGee mailto:[EMAIL PROTECTED] NM J ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Alternative To SQL Server Enterprise Manager
Id like to take a look at it Clint Clint Tredway wrote: One more thing, this is CF based. It will run on the web server so you cna get to it anywhere. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:10 PM To: CF-Talk Subject: RE: Alternative To SQL Server Enterprise Manager Actually, I'd like to find something that my clients can use, to login to their SQL database and make changes. Also, that will work with the security of the SQL server to keep unwanted eyes out of other DB's. (Kinda like what MySQL will do.) Lee -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 9:58 AM To: CF-Talk Subject: RE: Alternative To SQL Server Enterprise Manager DB Artisan and ERStudio are pretty slick. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 8:18 AM To: CF-Talk Subject: OT: Alternative To SQL Server Enterprise Manager I'm wondering if any CF'ers here has found an affordable alternative to SQL Server's Enterprise Manager? I had found SQL Navigator from http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking in a lot of areas, as well as buggy as h*ll... Enterprise Manager gives a lot of functionality, but mostly operates as an SDI application where multiple windows would be tremendously useful, plus a way to filter the system objects out of the view? Plus provide a data browser, a way to change the properties of a table, build indexes, build stored procedures, change/add/delete data, etc... Does anyone know of such a critter? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox
Just to insert my two cents worth, I inherited a site that I have now see was supposed to follow the fusebox methodology. It has been a nightmare trying to figure out what they were trying to do. I may be wrong but it seems to me that too have an include on the index page point to an action file that simply points to a display file was not the proper implementation. Just from looking the fusebox docs over once I see that what I would think is the proper implementation of this would be more like this 1)an include on the index page that points to an action file that does and action 2)an include on the index page below the action file that points to a query file 3)an include on the index page below the query file that points to a display file that may show the results returned based on the action and query file. Am I correct in this? I will admit that the methodology is a good thing to have to structure code and make it easier for a new programmer to come in and see what is going on. However in this case the documentation was nearly nonexistant and the fact that some of the includes stayed within the directory structure and others did not made this application extremely hard to follow. I am not the only programmer here that felt the same way about this application. I am not saying that the methodology is wrong...quite the contrary it seems to be simple and expandable. I am saying that no matter what methodolgy someone uses, the results you get will depend on how well you understand what the methodology is doing, how well you document your work and how closely you follow the specs of the methodology. Thanks Frederic ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF 4.51sp2 Memory Usage Plateau
What versions of the net8 and mdac drivers are susceptable to the memory leak? Frederic Dave Watts wrote: At what point is memory usage excessive: When memory usage exceeds physical memory? When memory is x% of swap? Still trying to get a handle on what the memory plateau is for CF This is a hard question to answer. Generally, you want to assume that all available memory will be available (and potentially used) by CF - you don't want to run CF and other services on the same machine. Because of the performance penalty incurred by releasing and reacquiring memory, CF 4.5.x simply retains all memory used. So, the question becomes, how much memory does your application need? You can generally determine this by capacity planning tests. You want to provide as much memory in the server as your application requires - memory is cheap. The problem with CF 4.5.x memory allocation isn't that it might consume all the available server memory, but rather that if you have any memory leaks, the effects of those leaks will cause the server to run out of memory to consume; in this state, the server will eventually become unresponsive and will require a restart. The biggest cause of memory leaks, in my experience, has been the database drivers used by CF. For example, there are memory leaks in several versions of MDAC drivers, as well as within versions of the Oracle Net8 client. 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: PL/SQL
We use cf and pl/sql stored procs extensively. What exactly are you trying to do? Jeff Britts wrote: Anyone have any luck running PL/SQL through ColdFusion? The simple stuff seems to work ok, but if you throw it something complex it chokes. Jeff Britts ColdFusion Engineer e-Dialog ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Hangs
We have always had trouble with cf on solaris doing this. the issue is much better with cf 4.51 sp1 though we still have problems. I have been told alot of the old code needs to be optimized (some pages seem to be running over 1000 miliseconds under noload conditions. We are running a single solaris quad processor machine with a gig of ram, apache/stronghold and oracle. Most of the issues in the longrunning pages seem to come from cf's inability to handle a pl/sql cursor in stored procs. The new version of cf and cf sqltype make it possible for us to go back and re-engineer these bottlenecks... I will trey to keep you updated on the performance improvements we get if youd like. On a related note we are getting a really strange error that kept cf and our site down for hours the other evening. We took down the databases for backup. Cold fusion errored out and then seemed to come back up (all the services said they were functioning) However we recieved the usual error you get when the server is down or restarting. In the mean time (6 hours) nothing was written to any of the cf logs. Has anyone encountered this before? [EMAIL PROTECTED] wrote: We are running Cold Fusion on Solaris here. Periodically the server will hang and not serve back anymore Cold Fusion requests. We are able to send http requests to port 80 and Apache responds but Cold Fusion seems dead in the water. After all is said and done the services have to be killed and restarted. Anyone else having similar problems with *nix flavors of CF? Any help would be GREATLY appreciated. chris.alvarado cold.fusion - developer [phone] 512.794.6563 [email] [EMAIL PROTECTED] [web] http://www.tmanage.com Privileged/Confidential Information may be contained in this message. It is not for use or disclosure outside TManage without a written proprietary agreement. If you are not the addressee indicated in this message, or agent responsible for delivery, you may not copy or deliver this message to anyone. Please notify the sender as soon as possible and immediately destroy this message and its attachments entirely. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Big companies using CF
I did alot of work on the EPA intranet with CF "Janssen Dolores Y (Contractor)" wrote: yes, there are various DoD organzations using CF -- Dee Janssen Web Developer LESCO/LOGSA 256-955-9579 [EMAIL PROTECTED] -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 3:43 PM To: CF-Talk Subject: Re: Big companies using CF I had Advanced CF training with Dave acouple months ago and there were some DoD people in there. Tim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Big companies using CF
The American Kennel Club has a large website done in CF www.akc.org -- / \__ Frederic Valone (@\___ Webmaster /O American Kennel Club/ (_/ /_/ U ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists