RE: SQL Server Enterprise Manager alternatives?
Embarcaderro rapidsql is okay... www.embarcaderro.com Perhaps you could try query analyzer?CREATE TABLE works pretty good too... -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 23, 2001 10:06 AM To: CF-Talk Subject: RE: SQL Server Enterprise Manager alternatives? Info Assistant from http://www.resultdata.com is excellent. David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2001 9:58 PM To: CF-Talk Subject: SQL Server Enterprise Manager alternatives? Hi all, I know this has come up in the past, and I was wondering if anyone had found anything to replace SQL Server's Enterprise Manager? I have a client on crappy shared hosting, and their SQL Server machine has about half a million databases on it (exaggeration). Enterprise Manager hangs/timesout trying to get a list of everything on the server. I need to add some tables and I would really like to avoid doing it the hard/manual way. Thanks, Kay. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[EMAIL PROTECTED]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Competency Test
http://www.brainbench.com/ These guys I believe have one for free... Pretty tough one too on sql theory actually... -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 12:26 PM To: CF-Talk Subject: OT: SQL Competency Test Good Afternoon, Does anyone know of a free SQL Competency test available? I am looking for one to give to job applicants, to determine their level of knowledge Thanks in advance Dave Sueltenfuss Application Developer Certified ColdFusion MX Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: setting sql isolation levels within cfquery
If in doubt, you can use lock hints instead: SELECT * FROM mytable (nolock) UPDATE mytable WITH (rowlock) set field = value Etc... In cfquery blocks it may be safer than isolation level statements... -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:57 PM To: CF-Talk Subject: setting sql isolation levels within cfquery When setting the an isolation level on a transaction within a cfquery block affect future queries on the same connection? This page seems a bit contradictory on the subject. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ set-set_74bw.asp If so, should I just reset the isolation level to REPEATABLE READ at the end of the query? Any potential downsides to this? cfquery datasource=#this.dsn# name=nextEst SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRANSACTION SELECT * FROM ... COMMIT TRANSACTION SET TRANSACTION ISOLATION LEVEL REPEATABLE READ /cfquery The thing I want to avoid is having a connection in the connection pool stuck on SERIALIZABLE... -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Majordomo archives
I haven't got a clue where to begin on this. A client of mine wants to get a mailing list going, and we're leaning towards Majordomo or Listserv. Problem is that I don't know what the heck the archives look like. He was intersted in mhonarc to parse the archives, but that looks to be more trouble than just building a cf engine to do it (that, and I'm paid by the hour...) I haven't the knowledge to do this myself... I know it'll be just text files, but what do the look like, and where on the server do I find them? Thanks eh! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help!
Easiest thing to do is not use MS Access... Your GAL should be accessible through LDAP. Consider using CFLDAP to access instead. Added bonus is that you don't have to use two layers...Check with your exchange admin about using LDAP to access the GAL. Here's an article on it: http://www.cfmcentral.com/tips/gettip.cfm?id=8 -Original Message- From: Conaway, Amy C [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:35 AM To: CF-Talk Subject: Help! Hi, I have linked a Global Address List to a MS Access table. As far as I can tell it went smoothly and the linked table is fully readable. The problem is I cant seem to reference it in a query at all...Access just freezes. Does anyone have any ideas? THX!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Canadian Latitudes/Longitudes postal codes
I'm building a site that's gonna need the the distance between two points... I hypothersize that I can get this with Latitudes and Longitudes for a given location. I'll know the postal codes. I can get the addresses or postal codes... Anyone know where I can get a list for Canada? It appears there's tonnes of web services providing the data for US zip codes (at least on http://uddi.microsoft.com ), but apparantly nothing for Canada :( Thoughts? Anyone had to deal with a similar issue to this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Canadian Latitudes/Longitudes postal codes
Ah... If only I had the budget :) Of course we all want to get it for free lol... -Original Message- From: David K [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 3:04 PM To: CF-Talk Subject: Re: Canadian Latitudes/Longitudes postal codes We built one of those apps recently. We sourced the DB here... http://www.zipinfo.com/ --David - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:49 PM Subject: SOT: Canadian Latitudes/Longitudes postal codes I'm building a site that's gonna need the the distance between two points... I hypothersize that I can get this with Latitudes and Longitudes for a given location. I'll know the postal codes. I can get the addresses or postal codes... Anyone know where I can get a list for Canada? It appears there's tonnes of web services providing the data for US zip codes (at least on http://uddi.microsoft.com ), but apparantly nothing for Canada :( Thoughts? Anyone had to deal with a similar issue to this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Think you are a SQL GURU? Try figuring this one out.
Actually, there's a dll you can get to add regex support to sql server too. http://databasepronews.com/articles/0220df.html I rule. -Original Message- From: Wjatscheslaw Kravtchenko [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 4:25 PM To: CF-Talk Subject: OT: Think you are a SQL GURU? Try figuring this one out. Hey Eric, It's not SQL it's more for PERL and Regular Expressions. I am not too familiar with regular expressions in ColdFusion but I'm sure that they are no RegEx in SQL. Another thing what could do it would be kdb from KX Systems but again you need to learn k. If you can drop me the csv file (please not more than 3 mb). I can have a look. SL Here is the challenge. Have a table with a column called NAME and the column contains both names of businesses and individuals. Business names are stored as is , example ABC Company. Individuals are stored as last name first name middle initial, example Public John Q. I need to get this information into another table where the biz name can be stored in the first name field no problem but I need to parse and individuals name so I can put the individual's first name in the first name column and their last name in the last name column. Figure it out and I will send you a prize. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stored Procedure not found
Can you call stored procedures inside a cfscript tag? I thought those operations had to be outside a cfscript tag... -Original Message- From: Wjatscheslaw KRAVTCHENKO [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 12:12 PM To: CF-Talk Subject: Stored Procedure not found Hi all, If I call the stored procedure from a CFScript and it returns not found - what could be misconfigured? The stored procedure can be accessed from all other tools like SQL Advantage. Cheers. SL ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Application Design
I'd personally recommend Embarcadero's ER/Studio for database design. It has way better features than Visio, for it is specific... http://www.embarcadero.com/products/erstudio/index.asp I believe Sybase and Oracle also have good database design tools... Looks like Adalon though is a pretty cool wireframe app... I may have to try that out myself... -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 9:39 AM To: CF-Talk Subject: Re: CF Application Design With Visio Enterprise, you can create ER diagrams and forward-engineer database tables with all their relationships defined. Regular Visio will only reverse-engineer Access and SQL-Server databases, but that can be a big help if you need a graphical representation. I'm not sure if you can just bolt onto anything through ODBC, though. I haven't really dug into it that much. - Jim Joshua Miller wrote: VISIO, it's not specifically for Web Application design, but it works really well for modelling all sorts of processes including databases and networks. When you signup for Microsoft's partner program you get VISIO and a whole boatload of other software for internal use. I think we paid $99 for the whole shebang including development copies of Windows Server 2003, Office, etc. Just another option ... Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-0801 ext. 254 *** * * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] *** * * -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 11:22 AM To: CF-Talk Subject: RE: CF Application Design Michael, take a look at NAWT (not another wireframe tool) at strangetactics.com it serves at least part of the process and it is free. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 8:14 AM To: CF-Talk Subject: CF Application Design Does anyone know of any tools available that are free or very cheap that help layout a new application? I am pushing for Adalon here, but its an uphill battle... I am trying to find a tool to aid in the restructuring and redesign of our main application that currently has NO documentation and NO initial design specs... sad story yes... and very frustrating. Thanks, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I knew your name was Neo
Yay! Redhat 8 and 9 support! Finally :) -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 9:50 AM To: CF-Talk Subject: Re: I knew your name was Neo On Wednesday, July 9, 2003, at 04:13 AM, Ben Koshy wrote: Updater 3 seems to have resolved most of the major issues. Not a great start for early adopters though. I hope they're taking note... I would just like to make sure that people know that Macromedia absolutely has been taking note, and with RedSky, you will see a huge improvement with respect to not just installation, but in many other areas, as well. Macromedia chose to spend a great deal of time and energy on RedSky, and to give it away for free, rather than working on an entirely new version of the product precisely because we have been taking note, and we realized that RedSky was the right move. Believe me when I say that RedSky is something for us to get very excited about. Christian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Array vs. temp table
I know there aren't arrays in SQL Server... Dunno about Oracle. From what I understand, a 2-dimensional array is a table, so there's never been a need for array vars in sql server. And in sql server, you can have table variables which behave like temprary tables but are stored in memory, which further makes them behave more like normal arrays. -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 12:01 PM To: CF-Talk Subject: Array vs. temp table Under what circumstances would you use an array vs. a temp table in a programming language such as PL\SQL. is there really a difference? CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IIS and making SES URLs work [WAS: Search Engine Optimization ]
Dumb q... SES urls... Are they even required any more? I mean, the smarter engines follow links through your site, so is it really necessary? -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 2:26 PM To: CF-Talk Subject: IIS and making SES URLs work [WAS: Search Engine Optimization] At 14:07 08/07/2003 -0700, you wrote: I can't see what this security issue has to do with SE friendly URLs, please explain? To make SES urls work (i.e. foo.cfm/parm/value) you have to shut OFF the setting for verify that pages exist in IIS. I've been trying to figure out why that method worked on one server but not another, but I've never found a setting in IIS similar to verify that pages exist. Could you point out where this option is set in the IIS Management Console? Gyrus [EMAIL PROTECTED] play: http://norlonto.net/ work: http://tengai.co.uk/ PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Conditional SQL Query Not Working
Wow... join conditions in the where clause... Haven't seen those for years :) Looks like you have a cartesian join between organizations and the rest of your dataset... Need to join organizations to something. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 6:17 AM To: CF-Talk Subject: Conditional SQL Query Not Working I have a form, that asks for a number of 'conditions' in order to find an attendee for a course. The problem is, I've put together a query that returns too many results / not the correct results. Every row returned is returned multiple times. I'm wondering if I'm needing a join somewhere... or if there is a more efficient way to make this work. Thank you in advance for your help! cfquery name=criteria datasource=#DSN# SELECT * FROMattendee, users, courses, organizations WHERE attendee.users_id = users.id AND attendee.assigneddate = courses.id !--- Limit query results by profession --- cfif form.profession NEQ 'all' AND users.profession = '#form.profession#' /cfif !--- Limit query results by progress in program --- cfif form.progress EQ 'certified' AND attendee.gradnum 'Pending' cfelseif form.progress EQ 'failed' AND attendee.postassign = 'Failed' cfelseif form.progress EQ 'incomplete' AND attendee.gradnum = 'Pending' cfelseif form.progress EQ 'withdrawn' AND attendee.withdrawn = '1' /cfif !--- Limit query results by organization training was received from --- cfif form.org_id NEQ 'all' AND courses.org = #form.org_id# /cfif !--- Limit query results by date --- cfif (len(form.start_date) GT 1) AND (len(form.end_date) GT 1) AND courses.s1_startdate #form.start_date# AND courses.s1_enddate #form.end_date# /cfif ORDER BY users.lname ASC /cfquery *** *** *** The query: *** *** *** The form: form name=find_attendee action=report_attendee.cfm method=post table tr td width=125Profession:/td td colspan=3 select name=profession option value=allAll/option cfoutput query=profession option value=#profession.profession##profession.profession#/option /cfoutput /select /td /tr tr td width=125Start Date:/td td width=175input type=text name=start_datenbsp;a href=javascript:ShowCalendar('find_attendee', 'start_date')img src=images/cal.gif width=16 height=16 border=0 alt=Click Here to Pick up the date/a/td td width=125End Date:/td td width=175input type=text name=end_datenbsp;a href=javascript:ShowCalendar('find_attendee', 'end_date')img src=images/cal.gif width=16 height=16 border=0 alt=Click Here to Pick up the date/a/td /tr tr td width=125Took Training From:/td td colspan=3 select name=org_id option value=allAll/option cfoutput query=org_admin option value=#org_admin.id##org_admin.org_abbr#/option /cfoutput /select /td /tr tr td width=125Progress:/td td colspan=3 select name=progress option value=allAll/option option value=certifiedCertified/option option value=failedFailed/option option value=incompleteIncomplete/option option value=withdrawnWithdrawn/option /select /td /tr tr td width=125nbsp/td td colspan=3 align=leftinput type=submit name=submit value=Search!/td /tr /form ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: unnecessary jsessionid in the url
AFAIK, addtoken=no in the cflocation tag should do it... At least in CF5 :) -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 4:25 PM To: CF-Talk Subject: unnecessary jsessionid in the url Hello All, I'm trying to do a cflocation and there is a jsessionid appended to the url... but like this LoginPage.cfm;JSESSIONID=80301173431057274626375 the semicolon is causing the page not to be displayed.. how do I get it so it doesn't append the jsessionid? Thanks, ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Content Management System
Tried this one yet? http://sourceforge.net/projects/cosmoscf/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:00 PM To: CF-Talk Subject: Re: Content Management System I should add that it should be cheap ( $500). I tried contentmonger lite, but I don't want users playing with paths. - Original Message - From: [EMAIL PROTECTED] Date: Wednesday, July 2, 2003 4:21 pm Subject: Content Management System Does anyone know of a CMS that's easy to use that runs on CF4.5/SQL Server 7? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Content Management System
Or this one? http://sourceforge.net/projects/modus/ -Original Message- From: Costas Piliotis Sent: Wednesday, July 02, 2003 4:06 PM To: CF-Talk Subject: RE: Content Management System Tried this one yet? http://sourceforge.net/projects/cosmoscf/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:00 PM To: CF-Talk Subject: Re: Content Management System I should add that it should be cheap ( $500). I tried contentmonger lite, but I don't want users playing with paths. - Original Message - From: [EMAIL PROTECTED] Date: Wednesday, July 2, 2003 4:21 pm Subject: Content Management System Does anyone know of a CMS that's easy to use that runs on CF4.5/SQL Server 7? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFX_IMAGE
Hahahahahahahahahahahaha... Sorry... Had to do it... Looks nice... Really... -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 2:31 PM To: CF-Talk Subject: RE: CFX_IMAGE Who ever wants it, http://relativepath.net/cfximage/cfx_image.zip Docs are included Just don't laugh at my home page. I got bored one day and have not had time to fix it :-) Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Hassan Arteaga RodrÃguez [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 7:28 PM To: CF-Talk Subject: Re: CFX_IMAGE I'd like to receive it also. Regards -- M. Sc. Hassan Arteaga Rodriguez Microsoft Certified System Engineer WEB Programmer. Network Admin -Original Message- From: Tim Do [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 2 Jul 2003 14:11:34 -0700 Subject: CFX_IMAGE Can somebody send me this tag? I can seem to download it from MM Thanks! http://www.wng.com/ Tim Do Programmer/Analyst Western National Group 949.862.6231 www.wng.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware Disable Right-Click
Watch out for the windows keys too... Dunno if they get disabled... Stuff like window key - d, ctrl-esc... And the stupid key next to the window key that we all wonder what exactly it does... That's also a right-click... Are there special Kiosk keyboards that are missing all the function keys? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 11:34 AM To: CF-Talk Subject: RE: Hardware Disable Right-Click That's a great idea. Thanks. Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: RE: Hardware Disable Right-Click How about take apart the mouse and break the switch under the right button? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Homesite + question
There's plenty of information on this in the past... Forta has been quite vocal on that subject... Per Forta, MM depracated cf studio because they figured there's no point in maintaining three web development IDE's. I recon that MM actually felt that two was too many, although their user bases differ. Those of us with a gig of ram and a P4 3 ghz may actually PREFER DWMX... Those of us who hate waiting for an application that's a resource pig to load just to edit a text file feel it's overkill for what we need. Here's an interesting fact. I was comparing CF and PHP a while ago, and came across some threads. Most attributed the success of a cf developer to the excellent IDE that cf developers had. Now that was an uneducated opinion, but still holds some merrit. And now MM phases out the IDE that really made most of us like cf in the first place. MM claims they listen to developers. Lol yeah right. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 2:52 PM To: CF-Talk Subject: Re: Homesite + question - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 26, 2003 2:28 PM Subject: RE: Homesite + question Yes, I know HS+ exists, but is it going to be around for the next iteration of tools, or just DW? I'd actually like to hear an 'official' answer on this as well (if there is one). I've been pretty vocal in various forums about my disappoinment of losing CF Studio. And yes, I've been using HS+ and been fairly happy with it. I guess I just have this uncomfortable feeling whenever I use it that it's just meant to be there and available to us 'coders' during this transitional period. I don't begrudge MM marketing DWMX, or anybody who wants to use it. But the lack of publicity behind Homesite+ (i mean c'mon...it's not at all a widely known fact that it's included on the DWMX cd) makes it seem that it's not a product that MM is really 'behind'. / $0.02 charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFGURU Help Needed
Ah yes. I had this too... Couple things... What version of Apache you using? Also, on redhat 9, when I did that, I had to chown root.root jrunserver.store to get it to start. Dunno if that'll help u or not... -Original Message- From: Jodie A [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 11:21 AM To: CF-Talk Subject: CFGURU Help Needed I rebooted my server and now CFMX (Updater 3, Solaris) will not start. It stops at the starting Verity point: Information,main,06/25/03,09:04:04,,Starting license... Information,main,06/25/03,09:04:04,,Starting License server ... Information,main,06/25/03,09:04:05,,Starting scheduler... Information,main,06/25/03,09:04:05,,Starting debugging... Information,main,06/25/03,09:04:05,,Starting sql... Information,main,06/25/03,09:04:05,,Starting mail... Information,main,06/25/03,09:04:05,,Starting verity... Now I can't get it started - does ayone know why this would happen and how to fix it? Thanks. Jodie _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFGURU Help Needed
Is netscape support with updater 3? I know the versioning for Apache was very specific... Honestly, if it worked before updater, I'd just roll it back... -Original Message- From: Jodie A [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 11:43 AM To: CF-Talk Subject: RE: CFGURU Help Needed It's actually Netscape - no change with chown. Any other advice? From: Costas Piliotis [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CFGURU Help Needed Date: Wed, 25 Jun 2003 11:28:10 -0700 Ah yes. I had this too... Couple things... What version of Apache you using? Also, on redhat 9, when I did that, I had to chown root.root jrunserver.store to get it to start. Dunno if that'll help u or not... -Original Message- From: Jodie A [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 11:21 AM To: CF-Talk Subject: CFGURU Help Needed I rebooted my server and now CFMX (Updater 3, Solaris) will not start. It stops at the starting Verity point: Information,main,06/25/03,09:04:04,,Starting license... Information,main,06/25/03,09:04:04,,Starting License server ... Information,main,06/25/03,09:04:05,,Starting scheduler... Information,main,06/25/03,09:04:05,,Starting debugging... Information,main,06/25/03,09:04:05,,Starting sql... Information,main,06/25/03,09:04:05,,Starting mail... Information,main,06/25/03,09:04:05,,Starting verity... Now I can't get it started - does ayone know why this would happen and how to fix it? Thanks. Jodie _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Passing session from .aspx to .cfm and back
Sorry to jump into this thread a bit late, but why not use client variables in cfmx, store them in a database, and write a .net object or function or whatever that parses those variables out into asp.not variables... And write another one to pass them back... Just use cdata / cglobal tables. And then when you transfer the session back to cf, add the cfid / cftoken attributes and the session will continue on I recon... Anyone want to correct me on this? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 12:26 PM To: CF-Talk Subject: Re: Passing session from .aspx to .cfm and back Mike Kear wrote: Sorry if I'm asking really basic questions here, but I'm dealing with a programmer who is on sabbatical in Poland, and is doing the work in his spare time there, (so I can't talk to him on the phone) and he loves to blind people with jargon. So he'll give me gobbledegook and I'll have to decipher it. He wont change anything on his side of the site, I'll have to do all the adjusting to fit what he's doing. That's how it is. Anyway ... are Basic Authentication and Digest Authentication the terms the .aspx programmer will know it by? He should know the terms, they are straight from the RFC on HTTP authentication (2617). And to hand back to the .aspx site a user who's still showing as authenticated, all I have to do is use cfheader to include whatever headers were included with the .aspx page that the user came over with. Is that right? The idea is that after being initially challenged the browser will automatically include credentials with every request to documents on the same level or lower in the directory structure of the site. If you use Digest authentication, you can even designate other sites (by name) that should be authenticated with the same credentials. So you don't start a session on both the .aspx and the .cfm side when the user logs in, you just start it on one side. And whenever the user hits a page in the other language, credentials are included so you can start a session on that moment. cflogin can work automatically with HTTP authentication. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: List of all running applications?
Why not point client variables to a database and just do a select distinct app from cdata Even if you don't use them, every session from every application gets an entry into that table... -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 3:11 AM To: CF-Talk Subject: List of all running applications? Hello! Is there a simple way to find out which applications are currently running and access their application variables structure? The server scope does not seem to provide such information. A solution/workaround I've been thinking about would be to add the following stuff to each Application.cfm: The background: I would like to edit Applications variables for Application A+B+C+D from Application E. Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF or .net?
In general, .net provides you with a whole new way of thinking about writing web apps. Lots of xml integration, very object oriented, tonnes of different language support: C#, vb.net, delhpi, etc etc... Forget everything you learned about writing a web app in ColdFusion. Dot Net is a whole new game. It's more like writing a VB app than a web app really. You have to think in terms of UML, object creation, components, and the like, rather than spaghetti code like in ASP, PHP, or CF. In fact, dot net tries to seperacte code from presentation. They have this feature called code-behind where all your code is in a separate vb file. CFML is more like spaghetti code, it's just nicer looking and easier for the naked eye to read. CF has better platform support. It'll run in Window$ or Linux, or a bunch of *nix flavours or on OSX server... With bluedragon, it'll run on any J2EE compliant platform like Websphere, BEA Weblogic, etc. Both platforms pre-compile. Performance differences are neglidgable really. The biggest performance drain on any web app is the database time anyway. We're talking about milliseconds of differences between the platforms. There's some drawbacks to dot net. Things that took a few minutes in cf are a royal pain in dot net. For example. Let's say you are using the data grid object to output a recordset, and you wanted to add category headings so that you'd have output like this: Group1 Field 1 Field2 Field3 Field 1 Field2 Field3 Field 1 Field2 Field3 Group 2 Field 1 Field2 Field3 Field 1 Field2 Field3 Field 1 Field2 Field3 In asp.net, this is a royal pain. Took us a few months before we found out how, and it wasn't pretty. You can do this in a few minutes in cfmx using the cfoutput group =... tag. CFMX is great for Rapid Development. Sometimes, time to market is crucial to the success of a web app. Ebay is one of the many countless examples of first-past-the-post theory. How many other auction sites were out there that failed? However, if programming in an n-tier enviroment, COM / CORBA integration is important to your app, then CFMX can get tricky. COM support in ColdFusion has always blown goats. It just doesn't work well for anything complicated. Too many things you can't do. You have to get into writing cfx tags if you want that kind of support. If you bill by the hour, dot net is the platform you want. You'll get paid for a much longer project than with a CFMX project :) -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:25 AM To: CF-Talk Subject: RE: CF or .net? Actually I am looking for some fair comparisons of the two products (CF and .net) to present to our group. -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:41 AM To: CF-Talk Subject: Re: CF or .net? On Friday, Jun 20, 2003, at 08:07 US/Pacific, Josh Remus wrote: On top of that fact, if Macromedia does not have reduced pricing for you, BlueDragon would be free as long as you don't need to deploy it on a J2EE server. And as long as you don't need: - cfexecute - cfobject - cfwddx See New Atlanta's website for more information about what is not included in the free server edition: http://www.newatlanta.com/products/bluedragon/product_info/ cfml_tag_support.cfm You'd also want to read their compatibility guide closely... Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problems with a query going from CF 5 to CFMX
And dumb question here, but finnished? Isn't it finished (with only one n)? Maybe it's spelled correctly in the database and not in your code? =) Finnished... Is that a way of being made a person from Finland? Some kind of metamorphosis or something? -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:02 AM To: CF-Talk Subject: Re: Problems with a query going from CF 5 to CFMX On Thursday, Jun 19, 2003, at 07:08 US/Pacific, Jochem van Dieten wrote: Bruce Sorge wrote: cfscript finnishedWorkflow = duplicate(session.workflow.process); /cfscript cfquery dbtype=query name=getMaxActivePage SELECT * FROM finnishedWorkflow WHERE Bit = 1 ORDER BY Priority /cfquery Isn't bit a reserved word? Yes. Try this instead: cfquery dbtype=query name=getMaxActivePage SELECT * FROM finnishedWorkflow WHERE [Bit] = 1 ORDER BY Priority /cfquery i.e., use [ ] to 'escape' the keyword so it can be used as a column name. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: session variables vs client variables
Been there. You'll benefit from all my pains here: In a nutshell, Crystal uses simple cookies instead of fancy cookies. Every report parameter is stored as a cookie. Real stupid setup if you ask me. There's a browser limitation on how many cookies a single site is allowed to set. There's some good reasons for this. What you really should do is run reports from a separate domain, and keep the cookies separate. Alternatively, you'll need a method to recover the cfid and cftoken from time to time when crystal decides to eat up resources. Good luck. -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:32 AM To: CF-Talk Subject: session variables vs client variables We're having a problem with sessions being dropped while viewing crystal reports. Crystal sets a cookie for each parameter passed to a report and drops whatever existing cookies there are... so users are being logged out after viewing crystal reports. I'm thinking about changing all session variables to client variables and storing them in the database. I haven't used client variables before and wanted to make sure first. Would I just set it up in cfmx admin and replace all variables scope from session to client? Is the timeout mgmt only done thru cfmx admin? Also... just need to change how I delete sessions with DeleteClientVariable? Anything else? Thanks in advance, Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Switching to OLE DB
Please, help... Our ColdFusion 5 services have been crashing and restarting lately, and I've been thinking of converting to OLEDB drivers instead of ODBC to see if the memory leak is related to the use of ODBC alone. It's not much, but it'll help I'm sure. So naturally, I piced the SQLOLEDB drivers first. Those are great. I get this error: Unknown Data Access Error. every time I try to envoke a stored procedure. Pretty uninformative. I've found little information on this, and those who had the problem never got an answer... Fine. I figured let's try using MSDASQL instead... Not the best to use an OLEDB to ODBC bridge, but still, at least it's not just ODBC. I am particularly trying to find the source of the memory leaks. So with MSDASQL, I get an error message on stored procedures with output variabls: Miltiple-Step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I found this article on that: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269495 Well, the key already exists for MSDASQL, so that kb article does nothing for me. I have tried with MDAC 2.6 and MDAC 2.7... Any thoughts on what to do next? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Switching to OLE DB
Hmm... So oledb no work... That sux... -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:57 PM To: CF-Talk Subject: Re: Switching to OLE DB [whoops, newsgroup users, i posted to only the newsgroup the first time] When I tried OLEDB, I had a couple of problems. One, a query would fail for some mysterious reason (a connection problem) one in, maybe 1000 queries, but I could never get it to fail myself, nor could I nail down why it was happening. I went back to ODBC, and it never happened again. Someone else confirmed similar problems. Two, (my memory's foggier on this one) I could not retrieve more than one text field per query... terribly annoying when 1 were needed. Jamie On Wed, 18 Jun 2003 12:21:29 -0700, in cf-talk you wrote: Please, help... Our ColdFusion 5 services have been crashing and restarting lately, and I've been thinking of converting to OLEDB drivers instead of ODBC to see if the memory leak is related to the use of ODBC alone. It's not much, but it'll help I'm sure. So naturally, I piced the SQLOLEDB drivers first. Those are great. I get this error: Unknown Data Access Error. every time I try to envoke a stored procedure. Pretty uninformative. I've found little information on this, and those who had the problem never got an answer... Fine. I figured let's try using MSDASQL instead... Not the best to use an OLEDB to ODBC bridge, but still, at least it's not just ODBC. I am particularly trying to find the source of the memory leaks. So with MSDASQL, I get an error message on stored procedures with output variabls: Miltiple-Step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I found this article on that: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269495 Well, the key already exists for MSDASQL, so that kb article does nothing for me. I have tried with MDAC 2.6 and MDAC 2.7... Any thoughts on what to do next? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL
Don't think anyone really understand the question... -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 10:49 AM To: CF-Talk Subject: Re: SQL No takers?... :-) - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 11:28 AM Subject: OT: SQL Does anyone have any links to some articles or information regarding the breakdown of a data structure into transactional tables and reporting/lookup tables in SQL 2K? Much Appreciated, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Switching to OLE DB
Hmmm... I probably should have checked the archives first :-) -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:53 PM To: CF-Talk Subject: Re: Switching to OLE DB Well, I don't know if it's that clear cut, but I initially switched to oledb, thinking that it was the *way to go*, because it was more native and faster than odbc. When I posted my problems, the few cftalkers that responded said that oledb was probably *not* the way to go. :-/ Hopefully, others will chime in, and have *all* the answers. Jamie On Wed, 18 Jun 2003 13:24:58 -0700, in cf-talk you wrote: Hmm... So oledb no work... That sux... -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:57 PM To: CF-Talk Subject: Re: Switching to OLE DB [whoops, newsgroup users, i posted to only the newsgroup the first time] When I tried OLEDB, I had a couple of problems. One, a query would fail for some mysterious reason (a connection problem) one in, maybe 1000 queries, but I could never get it to fail myself, nor could I nail down why it was happening. I went back to ODBC, and it never happened again. Someone else confirmed similar problems. Two, (my memory's foggier on this one) I could not retrieve more than one text field per query... terribly annoying when 1 were needed. Jamie On Wed, 18 Jun 2003 12:21:29 -0700, in cf-talk you wrote: Please, help... Our ColdFusion 5 services have been crashing and restarting lately, and I've been thinking of converting to OLEDB drivers instead of ODBC to see if the memory leak is related to the use of ODBC alone. It's not much, but it'll help I'm sure. So naturally, I piced the SQLOLEDB drivers first. Those are great. I get this error: Unknown Data Access Error. every time I try to envoke a stored procedure. Pretty uninformative. I've found little information on this, and those who had the problem never got an answer... Fine. I figured let's try using MSDASQL instead... Not the best to use an OLEDB to ODBC bridge, but still, at least it's not just ODBC. I am particularly trying to find the source of the memory leaks. So with MSDASQL, I get an error message on stored procedures with output variabls: Miltiple-Step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I found this article on that: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269495 Well, the key already exists for MSDASQL, so that kb article does nothing for me. I have tried with MDAC 2.6 and MDAC 2.7... Any thoughts on what to do next? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Storing Credit Card Info
If I'm not mistaken though, you can adhere to those rules by storing the authorization number. Much safer than storing the cc#... And still proof that you got the transaction. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:58 PM To: CF-Talk Subject: Re: Storing Credit Card Info If I remember correctly, the Visa/MasterCard rules REQUIRE you to keep record of all transactions for a period of time (2 years?). Many people do this via a database... some print to hard copy. -Novak - Original Message - From: Tim Laureska [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:47 AM Subject: RE: Storing Credit Card Info I'm about to embark on processing CC transactions for the first time as well ... Isn't it best to not record the CC information in a database at all if possible... just transmit the CC info securely as possible to a processor (ex. Authorize.net) ? I know some sites (ex. Amazon etc.) do maintain this info though in a DB for frequent buyers ... Are there any advantages that make it imperative to deep this info in a db Tim -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:39 AM To: CF-Talk Subject: RE: Storing Credit Card Info Isaac, I think this book has been recommended here before... 'Translucent Databases' by Peter Wayner. It deals with all sorts of database/encryption issues. Gl, alex -Original Message- From: Issac Rosa [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 7:02 PM To: CF-Talk Subject: Storing Credit Card Info My client has a need to store credit card. What's the best, cost effective, most secure way of doing this? Is it just better to capture the information in the db and then download to a local db, and keep off the server? I'm curious to know what others are doing in this situation. Currently, the application and db (MySQL) are on a shared server. Thanks, Issac ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL
Hmm... Correct me if I'm wrong, but are you your reports using a dirty read from the database? By default, sql server locks a record from a select statement. Not good for reporting. If you use appropriate nolock commands in the from clause or SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED you shouldn't slow the application down one bit. Force a dirty read. But I like Dave's suggestion the best... Copy it of replicate it to another server and run reports off of that... That's what we do for some of the more intense reports... -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:15 PM To: CF-Talk Subject: Re: SQL Exactly. Basically if people try to generate reports off of the data, the app slows way down because the tables being used to gather the reporting data are also needed by the application, etc... Mike - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 5:07 PM Subject: Re: SQL Michael Tangorre wrote: does anyone have any links or references that will shed some light on breaking an appliction data structure (sql server database) down into transactional and reporting/lookup databases to enhance performance. I am looking for some advantages and disadvantages in doing so, and maybe some examples... I'll bite :-) If I understand your question correctly you have some large datasets that is in regular use (transactional as in OLTP), but that is also used for reporting and analysis. And since the reporting takes quite a large time, you are wondering whether it is worth breaking the rules of normalization to add some summary tables to the schema, probably maintained by triggers, so the analysis is a bit faster. Right? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Switching to OLE DB
Reason I was thinking that was because of the old MDAC memory leak... We restart the services at around 3am to circumvent that memory leak. You know, the on Microsoft says isn't their fault and Macromedia says it's Microsoft's fault... Anyway, I found that the crash I was experiencing also had people saying it's mdac related... Definitely not a database issue. It's been running great forever. But anyway, I found the same thing... -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:25 PM To: CF-Talk Subject: RE: Switching to OLE DB You'll find people on both sides of the fence with this one. In all the research I've done it looks like ODBC seems to be the better choice. I've heard that OLE can be buggier than ODBC and many of the performance improvements that some people attribute to OLE are just myth. Anyhow, I HIGHLY doubt that switching will make any difference one way or another. Maybe your problem is DB related - maybe not - but it almost certainly is not related to your choice of ODBC or OLE drivers. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:18 PM To: CF-Talk Subject: RE: Switching to OLE DB Hmmm... I probably should have checked the archives first :-) -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:53 PM To: CF-Talk Subject: Re: Switching to OLE DB Well, I don't know if it's that clear cut, but I initially switched to oledb, thinking that it was the *way to go*, because it was more native and faster than odbc. When I posted my problems, the few cftalkers that responded said that oledb was probably *not* the way to go. :-/ Hopefully, others will chime in, and have *all* the answers. Jamie On Wed, 18 Jun 2003 13:24:58 -0700, in cf-talk you wrote: Hmm... So oledb no work... That sux... -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:57 PM To: CF-Talk Subject: Re: Switching to OLE DB [whoops, newsgroup users, i posted to only the newsgroup the first time] When I tried OLEDB, I had a couple of problems. One, a query would fail for some mysterious reason (a connection problem) one in, maybe 1000 queries, but I could never get it to fail myself, nor could I nail down why it was happening. I went back to ODBC, and it never happened again. Someone else confirmed similar problems. Two, (my memory's foggier on this one) I could not retrieve more than one text field per query... terribly annoying when 1 were needed. Jamie On Wed, 18 Jun 2003 12:21:29 -0700, in cf-talk you wrote: Please, help... Our ColdFusion 5 services have been crashing and restarting lately, and I've been thinking of converting to OLEDB drivers instead of ODBC to see if the memory leak is related to the use of ODBC alone. It's not much, but it'll help I'm sure. So naturally, I piced the SQLOLEDB drivers first. Those are great. I get this error: Unknown Data Access Error. every time I try to envoke a stored procedure. Pretty uninformative. I've found little information on this, and those who had the problem never got an answer... Fine. I figured let's try using MSDASQL instead... Not the best to use an OLEDB to ODBC bridge, but still, at least it's not just ODBC. I am particularly trying to find the source of the memory leaks. So with MSDASQL, I get an error message on stored procedures with output variabls: Miltiple-Step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I found this article on that: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269495 Well, the key already exists for MSDASQL, so that kb article does nothing for me. I have tried with MDAC 2.6 and MDAC 2.7... Any thoughts on what to do next? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web-based telnet client?
I think you're looking at the wrong technology imho... You can probably just find an ActiveX control or an Applet that'll do that... Probably don't need to use ColdFusion... Maybe some javascript with the applet or some vbscript with the activex control... A quick search on google gets you this one: http://javassh.org/ Here's more info on it: http://javassh.org/wiki-view?oid=408180808080808080808080808084neotis -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:04 AM To: CF-Talk Subject: Web-based telnet client? Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for commonly executed commands. Could be very handy for the sysadmin that can't remember obscure telnet commands. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hyphen in a variable name?
...or why not just alias that column name in your query? Select [product-code] as productcode From Wouldn't that save some processing time? Keep the load off cf? Best practice to just avoid hyphens and spaces in column names. Use camelCase to denote extra words. -Original Message- From: Matt Kornguth [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:00 AM To: CF-Talk Subject: RE: Hyphen in a variable name? Do a search for 'renamequerycolumns' at http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn10 5viewName=Exchange%20Search. Should be the only resulting file. Also, you may need the CFX_QueryColumns tag as well (also available at MM). If you have any problems, let me know, I'll forward to you separately. Matt -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 12:47 PM To: CF-Talk Subject: Re: Hyphen in a variable name? Matt, Looks interesting. Where can I get the tag from MM? Regards, JB Matt Kornguth wrote: James, Don't know if this will help, but take a look at the RenameQueryColumns custom tag. Called like this: CF_RenameQueryColumns QUERY=getProductName ACTION=MAKESAFE NEWQUERY=getProductNameRenamed MAKEUNIQUE=Yes USEUNDERSCORE=No This will turn product-code into productcode. Works really well. I need to use it constantly as I connect via ODBC to a Progress db that uses hyphens all over the place. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 11:49 AM To: CF-Talk Subject: Hyphen in a variable name? Hello All: Does anyone know how to use a hyphen in a variable name for a cfoutput? For example: cfset my-name = Jim cfoutput#my-name#/cfoutput I'm outputting a field in a LDAP server that has a hyphen in its name and I can't seem to output it in ColdFusion. Regards, James Blaha ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hyphen in a variable name?
With what database? I mean, every rdbms out there should support aliased fields... That's been around like forever... At list since the Ansi-88 standard... Heck, even MS Access allows you to alias fields... -Original Message- From: Matt Kornguth [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:17 AM To: CF-Talk Subject: RE: Hyphen in a variable name? Don't want to speak for James, but the aliasing never worked for me. And I tried every possible combination ... But then again that might have just been a limitation of the ODBC driver I need to use. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 1:09 PM To: CF-Talk Subject: RE: Hyphen in a variable name? ...or why not just alias that column name in your query? Select [product-code] as productcode From Wouldn't that save some processing time? Keep the load off cf? Best practice to just avoid hyphens and spaces in column names. Use camelCase to denote extra words. -Original Message- From: Matt Kornguth [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:00 AM To: CF-Talk Subject: RE: Hyphen in a variable name? Do a search for 'renamequerycolumns' at http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn10 5viewName=Exchange%20Search. Should be the only resulting file. Also, you may need the CFX_QueryColumns tag as well (also available at MM). If you have any problems, let me know, I'll forward to you separately. Matt -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 12:47 PM To: CF-Talk Subject: Re: Hyphen in a variable name? Matt, Looks interesting. Where can I get the tag from MM? Regards, JB Matt Kornguth wrote: James, Don't know if this will help, but take a look at the RenameQueryColumns custom tag. Called like this: CF_RenameQueryColumns QUERY=getProductName ACTION=MAKESAFE NEWQUERY=getProductNameRenamed MAKEUNIQUE=Yes USEUNDERSCORE=No This will turn product-code into productcode. Works really well. I need to use it constantly as I connect via ODBC to a Progress db that uses hyphens all over the place. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 11:49 AM To: CF-Talk Subject: Hyphen in a variable name? Hello All: Does anyone know how to use a hyphen in a variable name for a cfoutput? For example: cfset my-name = Jim cfoutput#my-name#/cfoutput I'm outputting a field in a LDAP server that has a hyphen in its name and I can't seem to output it in ColdFusion. Regards, James Blaha ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX on Cobalt RaQ550
Nobody has I guess? -Original Message- From: Costas Piliotis Sent: Wednesday, June 11, 2003 11:53 AM To: CF-Talk Subject: CFMX on Cobalt RaQ550 I have a client of mine who has colocated his server, and the colo facility is having trouble installing cfmx onto that box running the Linux 2.4 Multitasking operating systen as Sun calls it. They've apparantly installed it on other Cobalt servers, but are having major troubles with this one... Has anyone gotten CFMX to work on this appliance? Anything quirky in the installation I should be aware of? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Pagination (Next n records) for an inner join and grouped out put...
This is really one place SQL Server can learn from MySQL... A LIMIT function would be perfect... Why not just use the maxrows and startrow function in the cfquery tag? For the most part it works quite well actually... -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 11:22 AM To: CF-Talk Subject: Pagination (Next n records) for an inner join and grouped output... I've got an inner join that I'm trying to make work with paging the records and I *think* I see what the problem is, but I don't know how to proceed... The inner joins are working correctly. In fact, when I go to output, I simply group them by property ID, and I get the right number of Properties, and the right rates for each property...but the pagination is ALL wonky. I'm using Dreamweaver's Next N results, which is fairly easy to understand, and normally works great... Here's my query: cfif IsDefined(URL.Bedrooms) cfquery name=getMyListings datasource=#Application.DSN# SELECT * FROM (tblRentalLocations INNER JOIN tblRentalProperties ON tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID) INNER JOIN tblRentalRates ON tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID cfif URL.Bedrooms NEQ 'ANY' WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms# /cfif ORDER BY tblRentalProperties.PropertyName, tblRentalRates.RatesOrder, tblRentalRates.RatesLength Desc /cfquery /cfif My Next N code looks like this: cfset MaxRows_getMyListings=10 cfset StartRow_getMyListings=Min((PageNum_getMyListings-1)*MaxRows_getMyListings+1 ,Max(getMyListings.RecordCount,1)) cfset EndRow_getMyListings=Min(StartRow_getMyListings+MaxRows_getMyListings-1,getM yListings.RecordCount) cfset TotalPages_getMyListings=Ceiling(getMyListings.RecordCount/MaxRows_getMyList ings) cfset QueryString_getMyListings=Iif(CGI.QUERY_STRING NEQ ,DE(CGI.QUERY_STRING),DE()) cfset tempPos=ListContainsNoCase(QueryString_getMyListings,PageNum_getMyListings= ,) cfif tempPos NEQ 0 cfset QueryString_getMyListings=ListDeleteAt(QueryString_getMyListings,tempPos, ) /cfif Now, here's where it gets wonky. On the query, the actual recordcount is the total number of rows returned, when I use the grouped output and nest my cfoutput tags, it works perfectly, but it gives me a wrong recordCount and that, in turn, throws the next n browsing all to heck and back. I THINK I should somehow be totalling the number of unique PropertyIDs there are in the query, and use that instead of recordCount...am I on the right track? I tried COUNT(PropertyID) AS PropertyCount but that didn't work, it won't let you use that AND a * in the same query, and when I went to all the trouble to place all my fieldnames in there, it didn't work either... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Not creating sessions???
Have you created an application in IIS? If the site doesn't have an application name, IIS may not be sending the headers to write the cookie to keep the session... -Original Message- From: Staff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:22 PM To: CF-Talk Subject: CF Not creating sessions??? HELP HELP HELP . . . Anyone got any idea why CF may not create sessions?? I simply moved a working functional CF site to another WIn2K Advanced server, just like the one it came from, and for some reason CF5 will not hold the create and maintain a session. Try to log in and it keeps bumping me back to log in page . . . I determined it is not creating and maintaining a session . . . I uninstalled and reinstalled CF and same shit . . . anone got any ideas??? I can only think to reinstall . . .OS . . .and all . . . jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Not creating sessions???
In particular, check under the Home Directory tab of your site in IIS. Ensure there is an application name there. I think that may be the cause... Just a hunch though really... -Original Message- From: Costas Piliotis Sent: Thursday, June 12, 2003 3:26 PM To: CF-Talk Subject: RE: CF Not creating sessions??? Have you created an application in IIS? If the site doesn't have an application name, IIS may not be sending the headers to write the cookie to keep the session... -Original Message- From: Staff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:22 PM To: CF-Talk Subject: CF Not creating sessions??? HELP HELP HELP . . . Anyone got any idea why CF may not create sessions?? I simply moved a working functional CF site to another WIn2K Advanced server, just like the one it came from, and for some reason CF5 will not hold the create and maintain a session. Try to log in and it keeps bumping me back to log in page . . . I determined it is not creating and maintaining a session . . . I uninstalled and reinstalled CF and same shit . . . anone got any ideas??? I can only think to reinstall . . .OS . . .and all . . . jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output...
Actually, in sql server, you can do this on one query using derived tables too... Kinda like doing two queries, but not quite... Same idea though... -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:32 PM To: CF-Talk Subject: RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output... No you can't. When you use aggregate functions in an SQL statement you MUST put all of the fields you are selecting into the GROUP BY clause. That means you will need two queries since you want to select more fields than you want to GROUP BY. I wouldn't look down on yourself too much for that. Two queries is not that big a deal. It's when you put queries inside loops that you deserve to be shot ;) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 2:03 PM To: CF-Talk Subject: Re: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output... on 6/12/03 4:47 PM, Bryan Love at [EMAIL PROTECTED] wrote: Post the code you are using to output the query. The information you are trying to display could make or break this effort. I'm assuming you have something like this: cfoutput query=foo group=propertyID #propertyID# ? cfoutput #some info#... /cfoutput /cfoutput That's exactly my output... and you want to outputsay...10 propertyIDs per page? Without running the SELECT COUNT DISTINCT... you will only be able to use next page and previous page links because you won't know how many total pages there are. Can I somehow calculate that DURING the inner join query below? I tried to add it to the SELECT statement with disastrous results... cfif IsDefined(URL.Bedrooms) cfquery name=getMyListings datasource=#Application.DSN# SELECT * FROM (tblRentalLocations INNER JOIN tblRentalProperties ON tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID) INNER JOIN tblRentalRates ON tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID cfif URL.Bedrooms NEQ 'ANY' WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms# /cfif ORDER BY tblRentalProperties.PropertyName, tblRentalRates.RatesOrder, tblRentalRates.RatesLength Desc /cfquery /cfif ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT~ but a good laugh:)
That was my favourite thing about interdev 6 ... pnbsp;/p all over the place. Ugliest code ever. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 2:37 PM To: CF-Talk Subject: RE: OT~ but a good laugh:) I have a couple of hosting clients who insist on using FrontPage. They have great looking sites, until you look at two of them and realise they've got templates from some site somewhere and just changed the text. Then I get emails complaining how slow they are to load, and I see that the 150x50 images are actually 1800x600 images displayed at 150x50 so they download the whole large uncompressed file. Add to that all the burden code they have with fragmented tags, font tags on and off everywhere, empty paragraph tags, empty font tags, additional and unnecessary style tags etc etc.. and you can take a page from 150kb down to about 15mb without doing a lot of thinking. Oh and don't try to look at their sites with Netscape. I do hope this new version is better. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED] Sent: Friday, 13 June 2003 7:08 AM To: CF-Talk Subject: Re: OT~ but a good laugh:) as usual you are correct jochem heres the rest: Microsoft announce FrontPage 2003 We've really focused on generating clean, industry-standard HTML code. they claim. We expect it to produce proprietary, MS-oriented mark-up that only works in IE6. But then we're cynical. Click here http://rss.com.com/2100-1012_3-1015009.html?type=pt%02%22=rsstag=feed; subj=news to read more. Any of you going to stop using DMX and start using FrontPage? Tell us by mailing Bruce Lawson mailto:[EMAIL PROTECTED] - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 12, 2003 5:00 PM Subject: Re: OT~ but a good laugh:) Dave Lyons wrote: Microsoft announce FrontPage 2003 We've really focused on generating clean, industry-standard HTML code. they claim. That would be quite a change. IIRC, during the anti-trust trials Bill Gates himself has delivered sworn testimony that Frontpage is designed to only work with IE. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX on Cobalt RaQ550
I have a client of mine who has colocated his server, and the colo facility is having trouble installing cfmx onto that box running the Linux 2.4 Multitasking operating systen as Sun calls it. They've apparantly installed it on other Cobalt servers, but are having major troubles with this one... Has anyone gotten CFMX to work on this appliance? Anything quirky in the installation I should be aware of? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there an END WHILE for CFLOOP?
Sort of... cfif ArrayRows = 69 cfexit method=LOOP /cfif -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:42 PM To: CF-Talk Subject: Is there an END WHILE for CFLOOP? I'm looping over an array like so: cfloop from=1 to=#ArrayLen(application.myArray)# index=ArrayRows ...blahblahblah... /cfloop Is there a way for me to stop execution of a as soon as the loop code finds what it wants? i.e. cfif foo is barendwhile goes here/cfif --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 9 Jun 2003 17:20:25 -0500 I've been thinking about some ideas on how to stop running scripts, like an ABORT button. This is the first thought I came up with. Any other ideas? This comes up for me because I have several LONG running scripts that occassionally, I might want to stop w/o having to bounce the cf server to do so... ... hrm... I would probably use some sort of progress meter on the long-running page you might want to halt -- which will slow it down some overall also, although probably not a noticeable amount in most cases... What you really need is a way to interract with the running page from the client side -- which means, another page load, which is fine, it's just a matter of figuring out how that is accomplished... The fileexists() isn't a bad idea -- you could for instance have a stop button that produces a popup window that says stopping the process, please wait, which then creates the halt flag on the server. Use cfflush after the button is displayed and before the long running process begins, so that the button is visible and then display the progress below the button. When the long running process sees the flag file it deletes it, aborts the process, closes the popup window and displays a message indicating that the process has been cancelled. I wouldn't worry terribly muc h about the time it takes to perfor hth s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there an END WHILE for CFLOOP?
Eww ick? Doesn't work? -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:52 PM To: CF-Talk Subject: RE: Is there an END WHILE for CFLOOP? Ewww ick... try cfbreak instead... :) Sort of... cfif ArrayRows = 69 cfexit method=LOOP /cfif -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:42 PM To: CF-Talk Subject: Is there an END WHILE for CFLOOP? I'm looping over an array like so: cfloop from=1 to=#ArrayLen(application.myArray)# index=ArrayRows ...blahblahblah... /cfloop Is there a way for me to stop execution of a as soon as the loop code finds what it wants? i.e. cfif foo is barendwhile goes here/cfif --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 9 Jun 2003 17:20:25 -0500 I've been thinking about some ideas on how to stop running scripts, like an ABORT button. This is the first thought I came up with. Any other ideas? This comes up for me because I have several LONG running scripts that occassionally, I might want to stop w/o having to bounce the cf server to do so... ... hrm... I would probably use some sort of progress meter on the long-running page you might want to halt -- which will slow it down some overall also, although probably not a noticeable amount in most cases... What you really need is a way to interract with the running page from the client side -- which means, another page load, which is fine, it's just a matter of figuring out how that is accomplished... The fileexists() isn't a bad idea -- you could for instance have a stop button that produces a popup window that says stopping the process, please wait, which then creates the halt flag on the server. Use cfflush after the button is displayed and before the long running process begins, so that the button is visible and then display the progress below the button. When the long running process sees the flag file it deletes it, aborts the process, closes the popup window and displays a message indicating that the process has been cancelled. I wouldn't worry terribly muc h about the time it takes to perfor hth s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there an END WHILE for CFLOOP?
Oh... I need to RTFM again :) My bad -Original Message- From: Costas Piliotis Sent: Monday, June 09, 2003 4:39 PM To: CF-Talk Subject: RE: Is there an END WHILE for CFLOOP? Eww ick? Doesn't work? -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:52 PM To: CF-Talk Subject: RE: Is there an END WHILE for CFLOOP? Ewww ick... try cfbreak instead... :) Sort of... cfif ArrayRows = 69 cfexit method=LOOP /cfif -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:42 PM To: CF-Talk Subject: Is there an END WHILE for CFLOOP? I'm looping over an array like so: cfloop from=1 to=#ArrayLen(application.myArray)# index=ArrayRows ...blahblahblah... /cfloop Is there a way for me to stop execution of a as soon as the loop code finds what it wants? i.e. cfif foo is barendwhile goes here/cfif --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 9 Jun 2003 17:20:25 -0500 I've been thinking about some ideas on how to stop running scripts, like an ABORT button. This is the first thought I came up with. Any other ideas? This comes up for me because I have several LONG running scripts that occassionally, I might want to stop w/o having to bounce the cf server to do so... ... hrm... I would probably use some sort of progress meter on the long-running page you might want to halt -- which will slow it down some overall also, although probably not a noticeable amount in most cases... What you really need is a way to interract with the running page from the client side -- which means, another page load, which is fine, it's just a matter of figuring out how that is accomplished... The fileexists() isn't a bad idea -- you could for instance have a stop button that produces a popup window that says stopping the process, please wait, which then creates the halt flag on the server. Use cfflush after the button is displayed and before the long running process begins, so that the button is visible and then display the progress below the button. When the long running process sees the flag file it deletes it, aborts the process, closes the popup window and displays a message indicating that the process has been cancelled. I wouldn't worry terribly muc h about the time it takes to perfor hth s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: csv files
Here. Convert query and filename as you like: cfquery datasource=#application.ds# name=test select branchid, branchname from tblbranches /cfquery cfoutput query=test cfset myvar = cfloop list=#test.columnlist# index=mycol cfset myvar = myvar , evaluate(test. mycol) /cfloop cfset myvar = right(myvar, len(myvar) - 1) cffile action=APPEND file=\\yvrworptest\worp\test.csv output=#myvar# /cfoutput -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:31 AM To: CF-Talk Subject: csv files Shoot me dead if this has been asked and answered, but pelase respond nonetheless so that my replacement can jump right in: what is the easiest way to create a csv file from a query? What I have is a custom tag that takes a runs a query and need to genenrate a csv file and then save it to the server using cffile. TIA, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: csv files
Actually, for large files, jon hall is correct... Use DTS, not CF. CF is good for samller recordsets. Eventually the http request will time out or something... And end users get sick of waiting. Alternatively, and if you hafta use cf, inside the cfloop statement, I'd use cfflush to create some kind of feedback for the end user about completion... Although cfflush slows things down, the feedback to the end user is quite valuable and can keep them waiting instead of hitting refresh... Before cfflush, we'd fake it with an animaged gif or something... That worked well too... -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 12:44 PM To: CF-Talk Subject: RE: csv files However, do NOT do that for very large (50,000+ records) reports. Write each line at a time. It may be counter-intuitive, but apparently, appending data to a variables takes exponentially longer as the variable grows bigger... don't do a CFFILE ACTION=append, that'll be slow like nothing else. Build the entire file in memory, and then write it with a single CFFILE. If your memory won't handle it, then break it down into chunks (maybe a few hundred or a thousand records each), and write those chunks to the file, rather than each record. --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:47 AM To: CF-Talk Subject: RE: csv files Here. Convert query and filename as you like: cfquery datasource=#application.ds# name=test select branchid, branchname from tblbranches /cfquery cfoutput query=test cfset myvar = cfloop list=#test.columnlist# index=mycol cfset myvar = myvar , evaluate(test. mycol) /cfloop cfset myvar = right(myvar, len(myvar) - 1) cffile action=APPEND file=\\yvrworptest\worp\test.csv output=#myvar# /cfoutput -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:31 AM To: CF-Talk Subject: csv files Shoot me dead if this has been asked and answered, but pelase respond nonetheless so that my replacement can jump right in: what is the easiest way to create a csv file from a query? What I have is a custom tag that takes a runs a query and need to genenrate a csv file and then save it to the server using cffile. TIA, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RedHat 7.2 support (WAS Re: CFMX on Redhat 9 with Apache2 2.0 .46)
So the only thing they are doing is adding Verity support to it then? Everything else seems to work like a charm (After HOURS of playing and researching the file I had to chown on to get it to work...) -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 1:49 PM To: CF-Talk Subject: RE: RedHat 7.2 support (WAS Re: CFMX on Redhat 9 with Apache2 2.0 .46) CFMX currently works on Redhat 8 but verity doesn't work and it's not an officially supported platform by Macromedia. So if you don't care about that you don't need to wait for RedSky. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ It'd be nice to see that MM catches up to support at least Redhat 8... RedSky (code-name for the upcoming ColdFusion MX maintenance release) will support RedHat 7.3, 8, 9 and SuSE Linux 8. Well, an important caveat of that statement is that CFSearch/K2 will not be supported on those platforms, only RH 6.2-7.2 and SuSE 7. For some, that's an important consideration, I would imagine. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using CFOBJECT in CF50 to query LDAP?
Why not just use cfldap or cfauthenticate (depending on what you need to do)? -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:44 PM To: CF-Talk Subject: Using CFOBJECT in CF50 to query LDAP? Has, anyone out there ever used CFOBJECT to query a JavaBean for LDAP authentication, if so is it possible to share a bit of example code? Kind Regards - Mike Brunt ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Search Friendly URLs in CFMX
Please correct me if I'm wrong, but aren't all urls now search engine friendly? I mean, I know Google's algorithm for spidering sites is pretty advanced. It doesn't just index every document, but rather follows links throughout your site instead... It doesn't index documents that don't have a link to them, and the old trick of putting white text on a white background fails too... They've gotten pretty clever afaik... -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 1:00 PM To: CF-Talk Subject: Search Friendly URLs in CFMX Can someone please point me to a recent discussion/solution to search friendly URLs in MX? I'm sure this has been beaten into the ground, but, as usual, I'm not getting very far with the houseoffusion cf-talk search function (because it bites ;) I was about to jump right into the cf_FakeURL way to do it (I currently have sites that use a URL Replacer IIS ISAPI filter, but want to do it in CFML instead), but I saw some buzz about cf_FakeURL not working with CFMX, so I wanted the latest scoop. Thanks, Jamie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT: URL length
Older browsers only support URLS 255 characters or less. We found IE, up to 5.0 had this limit. IE 5.5 or better supports longer URL's. Not sure about nutscrape and opera though, but I recon the same constraint applies... I don't think it's IIS 5 that ignores the url's... We require on our internal apps that IE5.5 or better be used. That's one of the reasons we did that. I can list others, but I don't need to get into another browser debate :-) -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 1:19 PM To: CF-Talk Subject: RE: SOT: URL length Our installation of IIS 5 ignores URLs that are too long. One of my coworkers was trying to push a multithousand character string (contents of an email) via the URL and got confused when it acted like the request never got made. For a real good developer, they got some real blind spots. :-) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: jon hall [mailto:[EMAIL PROTECTED] : Sent: Wednesday, June 04, 2003 4:05 PM : To: CF-Talk : Subject: Re: SOT: URL length : : : FYI, The HTTP RFC at the W3C says both clients and servers should : be able to : handle URL's of unbounded length. : : Reality is totally different, and I've never run into a URL length : issue, but I remember hearing somewhere that very old versions of some : browsers would crash on urls that were too long. : -- : jon : mailto:[EMAIL PROTECTED] : : Wednesday, June 4, 2003, 2:56:10 PM, you wrote: : : SID http by the browser, and the web server. You can of course : check out the RFC's for the http protocol, although I can't tell : you where to find them or how much various browsers and webservers : SID stick to that standard in this repsect. : : SID If you're concerned about the length of the url I'd : recommend checking into storing some of that data in the session : or another shared scope. : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JS help
And btw... Limited nutscrape 4.xx support for that commmand btw... -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 8:30 AM To: CF-Talk Subject: RE: JS help innerText is what you are after. You'll need to locate the relevant anchor object using DOM and then once you have that object it is just: anchorObject.innerText; That should set you on your way, André -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 16:25 To: CF-Talk Subject: OT: JS help Ok, this is an odd request but: I was curiosu if it is possible with javascript to reference the value of the text contained inbetween the a href=mylink.htm?search=JavascripforMyValueThevalue/a Any help would be awesome. I need to do this with JS only Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RedHat 7.2 support (WAS Re: CFMX on Redhat 9 with Apache2 2.0 .46)
Generally though, most of us hacks who use linux refuse to pay for Redhat enterprise =) It'd be nice to see that MM catches up to support at least Redhat 8... -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 5:54 AM To: CF-Talk Subject: RedHat 7.2 support (WAS Re: CFMX on Redhat 9 with Apache2 2.0.46) - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 31, 2003 1:42 PM Subject: CFMX on Redhat 9 with Apache2 2.0.46 Apparantly I'm not the only one having troubles with this. Everything AFAIK btw, redhat is gonna stop supporting redhat 7.2, so I hope MM starts supporting Redhat 8 and Redhat 9... RedHat is stopping the support of RH7.x Standard and Pro -- the Enterprise server is still based on 7.2 and has a 5 year support horizon. Of course this is all a plan to move you from the one-time $149 fee for RH Pro to the $349-$2999/year subscription for RH Enterprise, but that's the cost of the support. Or you can do a major OS upgrade every 12-18 months which is the RH X release schedule. Regards, John Paul Ashenfelter CTO/TransitionPoint ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Signal 11 - Corrected
You know, I had the same issue this weekend. I know I personally never capitalize unix file names, so this was an unwelcome surprise. Oh well. Only had to learn that lesson once I recon... -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 10:16 AM To: CF-Talk Subject: Signal 11 - Corrected I would like to extend my thanks to Both Mike (?) and Steve in their efforts in assisting in resolving this issue. I know reading is fundamental and this showed it's ugly head that I knew that Linux was case-sensitive but never crossed my mind that on Linux that it HAD to be a CAPITAL A on the Application.cfm tag. Much Appreciated!! Everything is flowing as desired!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: UNC / Share Path in CFFILE (CFMX)
Have you tried reversing the slashes? Just a hunch, but if it's using file:// to access the file you should consider using regular slashes instead of backslashes... -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 9:58 AM To: CF-Talk Subject: UNC / Share Path in CFFILE (CFMX) Has anybody used a UNC / Share path in a cffile tag before for the destination? I am trying to upload a file using a web page / site on one server and have the file deposited on another server. The cffile tag I am using is as follows cffile action=upload filefield=form.imageName destination\\pt-ws1.rsn.hp.com\ImageServer\RemoteGadgets\slideShow... However, I am getting the following error message ... The destination directory file://\\pt-ws1.rsn.hp.com\ImageServer\RemoteGadgets\slideShow \\pt-ws1.rsn.hp.com\ImageServer\RemoteGadgets\slideShow specified in the CFFILE tag is invalid. The directory either does not exist or is not accessible by this tag. Any suggestions? I have checked permissions on both the share and file access - currently 'everyone' has full permissions in both. Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX on Redhat 9 with Apache2 2.0.46
Apparantly I'm not the only one having troubles with this. Everything installs fine, and the processes all start succesfully. Per this thread: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10threadid =589661 I went and commented out the following from httpd.conf: JRunConfig Serverstore /opt/coldfusionmx/runtime/lib/wsconfig/1/jrunserver.store Everything seems to work. What get's messed up if I do this? AFAIK btw, redhat is gonna stop supporting redhat 7.2, so I hope MM starts supporting Redhat 8 and Redhat 9... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX on Redhat 9 with Apache2 2.0.46
And after reading this, I should clarify... It stalls unless I comment that line out in httpd.conf Everything SEEMS to work okay now with that line commented. Just wondering what the side-effects are of that... -Original Message- From: Costas Piliotis Sent: Saturday, May 31, 2003 10:43 AM To: CF-Talk Subject: CFMX on Redhat 9 with Apache2 2.0.46 Apparantly I'm not the only one having troubles with this. Everything installs fine, and the processes all start succesfully. Per this thread: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10threadid =589661 I went and commented out the following from httpd.conf: JRunConfig Serverstore /opt/coldfusionmx/runtime/lib/wsconfig/1/jrunserver.store Everything seems to work. What get's messed up if I do this? AFAIK btw, redhat is gonna stop supporting redhat 7.2, so I hope MM starts supporting Redhat 8 and Redhat 9... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX on Redhat 9 with Apache2 2.0.46
Actually, I'm an idiot... If I actually read further, I just had to chown root.root jrunserver.store So I have cfmx on apache 2 on redhat 9 running. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10threadid =589661 Friggin' quirky though... -Original Message- From: Costas Piliotis Sent: Saturday, May 31, 2003 10:54 AM To: CF-Talk Subject: RE: CFMX on Redhat 9 with Apache2 2.0.46 And after reading this, I should clarify... It stalls unless I comment that line out in httpd.conf Everything SEEMS to work okay now with that line commented. Just wondering what the side-effects are of that... -Original Message- From: Costas Piliotis Sent: Saturday, May 31, 2003 10:43 AM To: CF-Talk Subject: CFMX on Redhat 9 with Apache2 2.0.46 Apparantly I'm not the only one having troubles with this. Everything installs fine, and the processes all start succesfully. Per this thread: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10threadid =589661 I went and commented out the following from httpd.conf: JRunConfig Serverstore /opt/coldfusionmx/runtime/lib/wsconfig/1/jrunserver.store Everything seems to work. What get's messed up if I do this? AFAIK btw, redhat is gonna stop supporting redhat 7.2, so I hope MM starts supporting Redhat 8 and Redhat 9... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Redhat 9, Apache 2.0.40 Woes
Argh... Caught in RPM hell! Anyways... Trying to install cfmx over apache 2.0.40 on redhat 9... Should be compatible. Don't even get me started on my httpd 2.0.43 problems... Anyway... can't start httpd. Keeps giving me an error about mod_jrun.c. Says it's not compatible with this version of apache. I've installed the cfmx updater and it's upgraded succesfully per mm's kb article. Anyone else had this problem? My httpd.conf is pointing to mod_jrun20.so correctly... Per mm, if I run updater 3, it should be compatible woth 2.0.40. Argh... Very frustrating... I know die hard linux fans will tell me to rtfm or something, but you know, for those folks who boast about the superiority, there's a few things that the penguin is a bit of a pain with... And yes, I know I can compile from source. More troubles there. I wish there was a FreeBSD port for cfmx... It'd probably work :) Nonetheless, it's just for development, so I'm gonna run as standalone for now. Anyone got any suggestions what I can do to get it to run under apache2? Thanks in advance eh... Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F: 604.320.6568 E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Voyus Canada Inc. client engagement contract http://www.voyus.com/ http://www.voyus.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Redhat 9, Apache 2.0.40 Woes
Just saw that in the release notes... Thanks eh... It was funny... What happened was I got the error message, about not being compatible. Searching for it finds me an article that states I need to run the cfmx updater. I didn't realize that I was running updater 3, and the article pertained to the first updater. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 10:08 AM To: CF-Talk Subject: RE: Redhat 9, Apache 2.0.40 Woes CFMX U3 requires Apache 2.0.43 or better in the 2.0 series if I remember correctly RedHat doesn't release new versions when it upgrades it's RPMs, it backports the changes to the existing version. So you'll never get a RedHat RPM for RH8 or 9 that is newer than apache 2.0.40, even though it contains all the changes up through 2.0.46. Just compile apache from source. It's pretty trivial. If you specify the redhat file layout, you shouldn't have to change anything about your server config, although I can't say that for sure, as I use the standard apache layout. cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 8:07 AM To: CF-Talk Subject: Redhat 9, Apache 2.0.40 Woes Argh... Caught in RPM hell! Anyways... Trying to install cfmx over apache 2.0.40 on redhat 9... Should be compatible. Don't even get me started on my httpd 2.0.43 problems... Anyway... can't start httpd. Keeps giving me an error about mod_jrun.c. Says it's not compatible with this version of apache. I've installed the cfmx updater and it's upgraded succesfully per mm's kb article. Anyone else had this problem? My httpd.conf is pointing to mod_jrun20.so correctly... Per mm, if I run updater 3, it should be compatible woth 2.0.40. Argh... Very frustrating... I know die hard linux fans will tell me to rtfm or something, but you know, for those folks who boast about the superiority, there's a few things that the penguin is a bit of a pain with... And yes, I know I can compile from source. More troubles there. I wish there was a FreeBSD port for cfmx... It'd probably work :) Nonetheless, it's just for development, so I'm gonna run as standalone for now. Anyone got any suggestions what I can do to get it to run under apache2? Thanks in advance eh... Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F: 604.320.6568 E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Voyus Canada Inc. client engagement contract http://www.voyus.com/ http://www.voyus.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PHP Equiv of cfoutput group
AFAIK I don't think there is one really... You'd probably just hafta do it manually: Something like: $checkvar = ; while ($row = mysql_fetch_object($result)) { if ($row-field1 != $checkvar) { //This would be your summary row. $checkvar = $row; } echo ($row-field2); //etc, etc, etc } Forgive me if the syntax is a bit off... I still write PHP with a book beside me :) -Original Message- From: cfmail [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 9:14 AM To: CF-Talk Subject: OT: PHP Equiv of cfoutput group Sorry of the ot post, but does anyone know of the equivilent of cfoutput query= group= group= ability. Thanks in advance. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL Full text or Verity Search
I have a choice to use one of thse. Which would you guys recommend? I know the MSSQL full text is buggy, so I use verity, but I haven't had any experience with mySQL Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F: 604.320.6568 E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Voyus Canada Inc. client engagement contract http://www.voyus.com/ http://www.voyus.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hiding JavaScript codes
Okay okay... I know Dave... You're right of course... The browser has to read the file, ergo it can be downloaded and viewed. However that being said, it still somewhat helps, even a little... Any web developer with a modicum of common sense I have a modicum of common sense, I was just trying to help the guy out so he can keep dumb people out at least... To simply say you can't doesn't do anyone any good. I may have understated how simple it was... I for one wouldn't go to that much effort to borrow a snippet. There's so much out there that if someone really doesn't want me to take it, I'll just move on. Chances are he isn't the first one to come up with that script idea, and won't be the last. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 7:40 PM To: CF-Talk Subject: RE: Hiding JavaScript codes Actually, you kind of can I think... You can use a cfm file as a .js file to emulate a javascript file. Change the extension to .cfm... Careful, cf studio won't correctly parse it, but nonetheless it'll work... Just tested it. cfparam name=cgi.http_referer default= cfif cgi.http_referer eq cfabort/cfif at the top. Then, in your script, just enter: script language=javascript src=temp.cfm/script In THEORY, the .js will come up blank unless it's called from another file on your site. Tweak it as you wish. It should keep prying eyes from reading your .js file. This isn't 100% bulletproof, but should work for the most part. You can of course get more anal on the file and verify the referer more carefully. If prying eyes are being used in concert with a brain (or just common, off-the-shelf software), this won't stop them from seeing your Javascript. I know, you cannot for sure, 100% hide it... Cgi variables can be spoofed. Still better than leaving it wide open if you want to lock it down... It's like your house. Just because someone can break a window doesn't mean you should leave the door unlocked. Nothing is really 100% secure. But it protects you from everyone but the elite hacker. This is a poor analogy. Perhaps a better one would be locking your door, but leaving the key under the mat. But that doesn't really do justice to the situation either. The simple fact is, securing your house is quite a bit different from securing application code, and you simply can't secure code that is being downloaded to the client. Any web developer with a modicum of common sense knows that for your browser to run Javascript, it has to be downloaded to the browser. If your browser can get to it, so can the web developer. Knowing this, it's pretty trivial to figure out how to do this - just send the same message to the server that your browser sends. (Or, for that matter, just fetch it from the browser cache.) You certainly don't have to be an elite hacker to do this. The only way for one to do this is if they know how to pass their own http headers. And then they need to know that you're looking at that particular cgi variable, and they need to know what you're comparing to as well. Too much trouble for a little piece of javascript IMHO... It's no trouble at all. Again, the developer doesn't have to know what variable you're checking against - it really doesn't matter at all. All the developer has to do is send the same HTTP request that your browser sent. Since HTTP requests are just text, this is a very easy thing to do. Any packet sniffer or recording proxy will tell you exactly what that text is. I've recently started using EffeTech HTTP Sniffer for this sort of thing - it just does HTTP, but it will let you refetch any file automatically, among other things. But you don't have to spend $40 to do this - you can use free tools like Ethereal. Finally, keep in mind that your approach means more (unnecessary) work for your CF server, and defeats the primary purpose of using external source files in the first place - caching! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Outer Join
Don't even need csite in that query then. Just write it like this: SELECT cp.payid, cp.name, cp.url, #url.id# as [id] FROM cpay cp LEFT OUTER JOIN cpayment p ON cp.payid = p.payid -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:42 PM To: CF-Talk Subject: OT: Outer Join I am having trouble with a query (which I am sure is simple). Query: SELECT cp.payid, cp.name, cp.url, c.id FROM cpay cp LEFT OUTER JOIN cpayment p ON cp.payid = p.payid INNER JOIN csite c ON c.id = p.id WHERE c.id = #url.id# What I need is to have all of the CP.PAYID records show up, if the URL.ID value is 0 (no records with ID 0) then I just want to have the whole list of cp.payid's display with c.id as NULL ... if the ID is valid, I STILL want to have the whole list of cp.payid's displayed, but with the c.id loaded with the url.id. Where am I missing this ... Thanks folks Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Verity to index sql server.
Hi folks. I hate SQL Server full-text indexing, so I have a rather large verity index on a recordset that I'm having trouble with. I've written a cfm file that'll refresh the index, and am able to envoke it through a browser. Takes forever, Currently, we have a nightly job that goes and refreshes the index. Problem is, the timeout on my site is 100s, and the timeout on the scheduled task is 1s... But the task times out with the site timeout... I don't want to raise the timeout on my site, but I'd sure like this scheduled job to refresh my index... Any thoughts? I've tried adding ?requesttimeout=1 and that works from a browser, and fails on the task... Thanks for any help... Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F: 604.320.6568 E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Voyus Canada Inc. client engagement contract http://www.voyus.com/ http://www.voyus.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Verity to index sql server.
I actually used the cf administrator to registered the scheduled event... You can also secify it there... Probably the same thing... I set it to be 1s in the administrator Any other thoughts? -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 3:36 PM To: CF-Talk Subject: RE: Verity to index sql server. If you are using Cfschedule, there is a field for requesttimeout - j -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 6:31 PM To: CF-Talk Subject: Verity to index sql server. Hi folks. I hate SQL Server full-text indexing, so I have a rather large verity index on a recordset that I'm having trouble with. I've written a cfm file that'll refresh the index, and am able to envoke it through a browser. Takes forever, Currently, we have a nightly job that goes and refreshes the index. Problem is, the timeout on my site is 100s, and the timeout on the scheduled task is 1s... But the task times out with the site timeout... I don't want to raise the timeout on my site, but I'd sure like this scheduled job to refresh my index... Any thoughts? I've tried adding ?requesttimeout=1 and that works from a browser, and fails on the task... Thanks for any help... Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F: 604.320.6568 E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Voyus Canada Inc. client engagement contract http://www.voyus.com/ http://www.voyus.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Verity to index sql server.
I'm actually just guessing it's timing out... The scheduler log isn't being very specific, and my only guess is that it's timing out. All I see in my scheduler is: Error message for task: 'Create KnowledgeBase' is 'Connection Failure. Status code unavailable.' Kinda useless if u ask me... -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 3:38 PM To: CF-Talk Subject: RE: Verity to index sql server. I don't know which version of CF server you are running however on mine one of the fields when creating/editting the task is for request time out. Also, you should be able to put the RTO in the url for the url param just as you do in a browser. Hope that helps -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 3:31 PM To: CF-Talk Subject: Verity to index sql server. Hi folks. I hate SQL Server full-text indexing, so I have a rather large verity index on a recordset that I'm having trouble with. I've written a cfm file that'll refresh the index, and am able to envoke it through a browser. Takes forever, Currently, we have a nightly job that goes and refreshes the index. Problem is, the timeout on my site is 100s, and the timeout on the scheduled task is 1s... But the task times out with the site timeout... I don't want to raise the timeout on my site, but I'd sure like this scheduled job to refresh my index... Any thoughts? I've tried adding ?requesttimeout=1 and that works from a browser, and fails on the task... Thanks for any help... Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F: 604.320.6568 E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Voyus Canada Inc. client engagement contract http://www.voyus.com/ http://www.voyus.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session state / cookies within frame???
Thanks Justin... That's a pretty funky solution... Never even heard of P3P before... Thanks for the insight... -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 11:10 PM To: CF-Talk Subject: Re: Session state / cookies within frame??? IE6 disables third-party cookies by default, which is why your cookies would not be getting set if displayed within a frameset (assuming the domain name of your client site is different from your own). You can get around this by placing a P3P header in your IIS configuration to tell IIS to allow the cookies. We have to do this on our ZonkBoard web site (www.zonkboard.com, shameless plug) because the nature of the app is to sit in an IFRAME on the user's site. We use cookies within the app to store the end user's name/url so they don't have to type it every time they post. This has the added effect of storing the name/url/session cookies across any site with a ZonkBoard on it. The P3P header makes it all possible. Here is the P3P header we use in IIS to make it happen: P3P: CP=NOI DSP COR OPTa BUS OTC Google for P3P to find more info and the link to get IBM's P3P policy editor. It's pretty neat stuff. -Justin Scott, Vice President Sceiron Interactive, Inc. http://www.sceiron.com [[: Creativity is not Obsolete :]] - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 8:23 PM Subject: Session state / cookies within frame??? Just noticed that a client of our wants our site within a frame from their own site. Normally, cf sets cookies on the client with the site information. We already disallow clients who block cookies (Flame on...), but I don't understand why IE disallows cookies from cross site frames. I'm now somehow tasked with appending cfid and cftoken to every hyperlink, every javascript, every form tag, and every cflocation tag. Argh. Anyone care to enlighten me why this is so? Thanks muchly! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I ORDER BY RANDOM ?
Nice! Great idea!!! Very clever... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:42 PM To: CF-Talk Subject: Re: How can I ORDER BY RANDOM ? I don't think I've seen this mentioned yet. Another way you can randomly order your results is to say: SELECT * FROM TABLE WHERE your criteria here ORDER BY NewId() I've found this works well in SQL Server 2000 but starts to slow down if you have a large number of records. Still, I've done it on 1,000 records or so without any problems. -Novak - Original Message - From: Tom Forbes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 2:44 PM Subject: RE: How can I ORDER BY RANDOM ? Hi Russ, I did that, but I get an error stating that there is no column in the db named SortOrder. Here is the modified query: CFQUERY NAME=GetAllCompaniesWithMiniSites DATASOURCE=MedMallDs DBTYPE=ODBC SELECT CompanyTbl.*, Rnd() as SortOrder FROM CompanyTbl WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes' ORDER BY CompanyTbl.ClassOfService, SortOrder /CFQUERY Thanks, Tom At 04:10 PM 4/3/03 -0600, you wrote: If your database has a random number generator function, you can try: SELECT tblCompany.*, Random() as SortOrder FROM tblCompany ORDER by SortOrder HTH--haven't tried it myself. Russ -Original Message- From: Tom Forbes [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:06 PM To: CF-Talk Subject: How can I ORDER BY RANDOM ? Dear CF'ers: I have searched my CF books for a clue, but am unable to find an example of what I am trying to do. I need to modify the below query so that my results are still ordered by ClassOfService (a number between 1 and 4) - BUT, the CompanyName needs to be displayed in a RANDOM ORDER each time the query is run, rather than its current alphabetical order. This will give all companies that participate an even advantage of being selected rather than those that begin with the first letters of the alphabet. Can someone please point me in the right direction? I have studied the CF RANDOM tag but can't figure out how to apply it. CFQUERY NAME=GetAllCompaniesWithMiniSites DATASOURCE=MedMallDs DBTYPE=ODBC SELECT * FROM CompanyTbl WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes' ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName /CFQUERY Thanks very much!! Tom Forbes ** * Tom Forbes, Forbes Consulting, Inc. TEL: 407-772-3427 FAX: 407-772-3428 Visit www.medmatrix.com for Medical Equipment Web Sites! E-Mail Subscription at www.medmatrix.com/mail_list.htm ** * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hiding JavaScript codes
Actually, you kind of can I think... You can use a cfm file as a .js file to emulate a javascript file. Change the extension to .cfm... Careful, cf studio won't correctly parse it, but nonetheless it'll work... Just tested it. cfparam name=cgi.http_referer default= cfif cgi.http_referer eq cfabort/cfif at the top. Then, in your script, just enter: script language=javascript src=temp.cfm/script In THEORY, the .js will come up blank unless it's called from another file on your site. Tweak it as you wish. It should keep prying eyes from reading your .js file. This isn't 100% bulletproof, but should work for the most part. You can of course get more anal on the file and verify the referer more carefully. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 11:35 AM To: CF-Talk Subject: RE: Hiding JavaScript codes The part I'm not sure about is, that it maybe possible to put the javascript.js file in a non-web directory. This isn't possible. If you don't put it in a web-accessible directory, your web browser won't be able to fetch it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hiding JavaScript codes
I know, you cannot for sure, 100% hide it... Cgi variables can be spoofed. Still better than leaving it wide open if you want to lock it down... It's like your house. Just because someone can break a window doesn't mean you should leave the door unlocked. Nothing is really 100% secure. But it protects you from everyone but the elite hacker. The only way for one to do this is if they know how to pass their own http headers. And then they need to know that you're looking at that particular cgi variable, and they need to know what you're comparing to as well. Too much trouble for a little piece of javascript IMHO... -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 5:48 PM To: CF-Talk Subject: RE: Hiding JavaScript codes However, you can fake the referer value. Repeat after me - you cannot hide JavaScript. JavaScript is run on the client. Therefore the client (and therefore the user) MUST have access to it. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 7:40 PM To: CF-Talk Subject: RE: Hiding JavaScript codes Actually, you kind of can I think... You can use a cfm file as a .js file to emulate a javascript file. Change the extension to .cfm... Careful, cf studio won't correctly parse it, but nonetheless it'll work... Just tested it. cfparam name=cgi.http_referer default= cfif cgi.http_referer eq cfabort/cfif at the top. Then, in your script, just enter: script language=javascript src=temp.cfm/script In THEORY, the .js will come up blank unless it's called from another file on your site. Tweak it as you wish. It should keep prying eyes from reading your .js file. This isn't 100% bulletproof, but should work for the most part. You can of course get more anal on the file and verify the referer more carefully. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 11:35 AM To: CF-Talk Subject: RE: Hiding JavaScript codes The part I'm not sure about is, that it maybe possible to put the javascript.js file in a non-web directory. This isn't possible. If you don't put it in a web-accessible directory, your web browser won't be able to fetch it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Learned something today (Oracle)
From what I know about SQL Server's behaviour, it will allow for that syntax until it reaches a character then it'll stop. In our Accpac database, we have invoices stored. Our older invoices have INV01 or whatever for invoice numbers. Now they're imported from the database I built and the invoice number is an autonumber integer. Anyway... I routinely forget it's a char field, and forget the quotes. I always get Error converting 'INV01' to integer data type (or something like that)... So I suspect it converts each record to int first before doing the where condition. I'd bet Oracle does something similar. Probably something in the standard that allows for that kind of a comparison. It'd be nice if it did it the other way and converted the where criteria to char, but that could yield much different results, especially if you use greater than or less than signs. So to accommodate for other operators, it likely does the casting the other way. -Original Message- From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 3:10 PM To: CF-Talk Subject: RE: Learned something today (Oracle) Is there orderno field a VARCHAR(2) or an number field? If it's a VARCHAR, then it is supposed to be surrounded in quotes. If it's numeric, it should not be in quotes (I don't even think it WOULD work). -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 5:58 PM To: CF-Talk Subject: Learned something today (Oracle) I couldn't understand why some queries on tables selecting using the primary key (orderno) was taking so long... In this instance the field in the database is a varchar field, but it's holding a numeric value. (Don't ask me why, that's another discussion) If I did the query like this: SELECT FROM orderheader WHERE orderno = 60134445 It took like 40 secs! If I did the query like this: SELECT FROM orderheader WHERE orderno = '60134445' Bam! tiny milliseconds... Like it should be. I never realized that the (lack of) quotes was the problem. What causes this slowdown exactly? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Session state / cookies within frame???
Just noticed that a client of our wants our site within a frame from their own site. Normally, cf sets cookies on the client with the site information. We already disallow clients who block cookies (Flame on...), but I don't understand why IE disallows cookies from cross site frames. I'm now somehow tasked with appending cfid and cftoken to every hyperlink, every javascript, every form tag, and every cflocation tag. Argh. Anyone care to enlighten me why this is so? Thanks muchly! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session state / cookies within frame???
Yeah, that's the odd part... And I'm actually able to duplicate it. If I add cfid and cftoken to the end of the url, the problem goes away... It seems the session data is lost in every time a user changes pages... Odd... Very Odd... -Original Message- From: Buckland, Ramon [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 6:00 PM To: CF-Talk Subject: RE: Session state / cookies within frame??? Hi Costas, IE if told to accept a cookie, will accept it from whereever it comes (banner ads)(think doubleclick.com) frames .. Only thing I can think of is that they are actually pulling your content from there server via a cfhttp (or lang equivalent) and pulling your content into a local frame of theirs is it a standard FrameSet with your URL in the src ? -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 April 2003 11:23 AM To: CF-Talk Subject: Session state / cookies within frame??? Just noticed that a client of our wants our site within a frame from their own site. Normally, cf sets cookies on the client with the site information. We already disallow clients who block cookies (Flame on...), but I don't understand why IE disallows cookies from cross site frames. I'm now somehow tasked with appending cfid and cftoken to every hyperlink, every javascript, every form tag, and every cflocation tag. Argh. Anyone care to enlighten me why this is so? Thanks muchly! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Free SQL Server
Have any of you ever considered MSDE? It comes on the Office CD's and is free with your MS Office licence. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:12 AM To: CF-Talk Subject: RE: Free SQL Server I don't like to see it either, but who encouraged it? I also don't like to see knee-jerk criminalization of innocent discussions. Jerry Johnson [EMAIL PROTECTED] 03/19/03 11:40AM Yep, just dont like to see people openly encouranging piracyno offence of course :-) -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 16:09 To: CF-Talk Subject: RE: Free SQL Server Why? All I'm doing is informing someone as to what's out there, not how to use it. P2P software, including Kazaa; Grokster; etc., have various legitimate uses. They're not limited to trading pirated software. ColdFusion has several built-in tags that could be dangerous or annoying (CFFILE, CFREGISTRY, CFMAIL, etc.) but do we have to think before responding that to delete a file, use CFFILE? Or, to access a person's username use CFREGISTRY? Or, to send email to a thousand people use CFMAIL? No, because we're simply providing the information how to use the tool. Otherwise, we'd have to add a little warning to half the posts to this list (WARNING: I don't advocate using dangerous/illicit item for things that are morally/legally objectionable.). The membership of this list is chock full of professionals, people that, in my mind, are mature enough to make their own decisions as to how to use the information they receive from the list's other members. If someone were to ask something that can only be illegal (how do I hack into the FBI's servers?) I wouldn't answer. But if someone asks a question that, on its face, is appropriate, I *AM* going to answer and leave it to the person that asked to decide for herself how to use that information. That said, my apologies to the list for cluttering it up with this nonsense. If anyone wants to continue this offline, feel free to email me directly. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 10:08 AM To: CF-Talk Subject: RE: Free SQL Server Maybe so, but its one of those think before you post scenarios -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 14:41 To: CF-Talk Subject: RE: Free SQL Server Oh, for the love of god... I am *NOT* advocating software piracy. I was simply answering Bryan's question. Mike Haggerty mentioned Grokster in one of his posts. Bryan responded that he didn't know what Grokster was. So I responded, in answer to his question, with a list of other P2P software that he might have heard of. Jeez. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 4:52 AM To: CF-Talk Subject: RE: Free SQL Server Stupid, very stupid thing to say... To answer the Q. yes you can get a 'free' version of SQL but it will be for development only and you cannot use it for production - it is also limited in its feature set and it has physical database limitations. N -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 20:39 To: CF-Talk Subject: RE: Free SQL Server Think Kazaa, aimster, napster, etc. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 1:28 PM To: CF-Talk Subject: Re: Free SQL Server grokster?? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Haggerty, Mike [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 9:43 AM Subject: RE: Free SQL Server Besides grokster, I know of no way of getting SQL Server 2000 for free. I believe you can get special pricing with an MSDN subscription. M -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:33 AM To: CF-Talk
RE: Free SQL Server
I tried to read that thread... It was real long... My bad... The licence is for the database server, not the tools from what I understand... I've never seen a licence agreement from Microsoft for the sql server database tools... Here's now I look at it. I buy CAL's for XP. I don't get media with each CAL. Ergo it's the Licence that's important to own, not necessarily the software. If you aren't using the sql server database that you've downloaded, it's kinda hard to say that's piracy... You're using the tools... It's unclear if you need the licence to run EM and ISQL etc... There's always Embarcaderro rapid SQL... -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 12:40 PM To: CF-Talk Subject: RE: Free SQL Server Have any of you ever considered MSDE? :) Too funny. Costas, read down the thread (or this email). This was the surrounding theme of the discussion and also how to get Enterprise Manager. I guess we're right back where we started. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 2:13 PM To: CF-Talk Subject: RE: Free SQL Server Have any of you ever considered MSDE? It comes on the Office CD's and is free with your MS Office licence. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:12 AM To: CF-Talk Subject: RE: Free SQL Server I don't like to see it either, but who encouraged it? I also don't like to see knee-jerk criminalization of innocent discussions. Jerry Johnson [EMAIL PROTECTED] 03/19/03 11:40AM Yep, just dont like to see people openly encouranging piracyno offence of course :-) -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 16:09 To: CF-Talk Subject: RE: Free SQL Server Why? All I'm doing is informing someone as to what's out there, not how to use it. P2P software, including Kazaa; Grokster; etc., have various legitimate uses. They're not limited to trading pirated software. ColdFusion has several built-in tags that could be dangerous or annoying (CFFILE, CFREGISTRY, CFMAIL, etc.) but do we have to think before responding that to delete a file, use CFFILE? Or, to access a person's username use CFREGISTRY? Or, to send email to a thousand people use CFMAIL? No, because we're simply providing the information how to use the tool. Otherwise, we'd have to add a little warning to half the posts to this list (WARNING: I don't advocate using dangerous/illicit item for things that are morally/legally objectionable.). The membership of this list is chock full of professionals, people that, in my mind, are mature enough to make their own decisions as to how to use the information they receive from the list's other members. If someone were to ask something that can only be illegal (how do I hack into the FBI's servers?) I wouldn't answer. But if someone asks a question that, on its face, is appropriate, I *AM* going to answer and leave it to the person that asked to decide for herself how to use that information. That said, my apologies to the list for cluttering it up with this nonsense. If anyone wants to continue this offline, feel free to email me directly. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 10:08 AM To: CF-Talk Subject: RE: Free SQL Server Maybe so, but its one of those think before you post scenarios -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 14:41 To: CF-Talk Subject: RE: Free SQL Server Oh, for the love of god... I am *NOT* advocating software piracy. I was simply answering Bryan's question. Mike Haggerty mentioned Grokster in one of his posts. Bryan responded that he didn't know what Grokster was. So I responded, in answer to his question, with a list of other P2P software that he might have heard of. Jeez. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 4:52 AM To: CF-Talk Subject: RE: Free SQL Server Stupid, very stupid thing to say... To answer the Q. yes you can get a 'free' version of SQL but it will be for development only and you cannot use it for production - it is also limited in its feature set and it has physical database limitations. N -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 20:39 To: CF-Talk Subject: RE: Free SQL Server Think Kazaa, aimster, napster, etc. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301
RE: My First CF Site (Critique Request)
Also, the select box for navigating... Consider switching it to some DHTML navigation or something... There's a tonne of info in there that you could really explore. I agree... The menu at the top would work much better... Usually good is a small menu at the base with the same links repeated in plain html for handy navigation on larger articles and the like. I also agree. Back button is redundant. Home can be part of your menu. -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 9:42 AM To: CF-Talk Subject: RE: My First CF Site (Critique Request) -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 11:59 AM To: CF-Talk Subject: My First CF Site (Critique Request) Sorry if this is a bit OT, but I was hoping to get some feedback on my first CF site: http://makeover.sllboces.org For what they're worth: 1) The body and link text is REALLY, REALLY small. Too small to read comfortably. Also you've set your font sizes up in a such a way that the browser contols for resizing the text do NOT work. This is most likely because you used pixel sizes in the style sheet. Consider either using relative sizes in the sheet or making mutliple versions of the style sheet available for use by people that need larger text. 3) I would really consider moving your menu to the top of the page. It's nice and experimental and all, but is your audience really experimental? If (as I think it is) your audience may NOT be advanced computer users make it as easy for them as possible and adopt a plain vanilla structure: menu at the top, logo in the upper right, etc. 4) At least on my screens (LCDs) the text of the Of Interest links is illegible when being moused-over (the green is too overpowering). 5) The logo is just gi-freakin'-normous - but it's very simple. I would consider shrinking it down personally. The image of the interested guy is nice - I would probably push something like that larger before the logo. 6) If you shrunk the logo and moved things around you might then consider taking the Quick Links out of a single select box and using multiple boxes (one per group). This would allow people to eliminate a lot of the scrolling needed in that box (right now there are 10 screens of links within that select box). Also the text for that select is also REALLY, REALLY small. Also you might link to a single, plain HTML page with all of those links for those that like to see all their options in front of them. I also wouldn't repeat the quick links in two different places as you have. For the inner pages: 1) I would drop your back link. It's cute, but completely redundant and doesn't offer anything - again I would REALLY consider moving the menu to the TOP of the page. That's about it off the top of my head. Damn I'm a picky bastard. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: win 2000 professional for web server?
Actually, win2k pro will give you glitches. IIS won't allow more than ten connections, and a web based connection DOES count. Consider trying Apache on win2k pro instead. That's a MUCH better work around. I've seen win2k pro deny connections on a web server before for too many concurrent connections. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 4:35 PM To: CF-Talk Subject: RE: win 2000 professional for web server? I am setting up a web server with CF 5.0 on a win2kpro box and I read in the CF 5.0 installation manual that win2kpro is not recommended because it only allows 10 concurrent TCP/IP connections. This means that only 10 concurrent users can access the website right? Or are there connections used for internal things that would limit concurrent users further? Database connections, SMTP connections, FTP connections, management connections, backup connections etc. etc. etc. all reduce that number. If you run DNS even that reduces the number during zone transfers. Actually, I don't think this is true. I think you can have more than ten concurrent TCP/IP connections. You just can't support more than ten concurrent authenticated or SSL connections through the version of IIS that comes with Win2K Pro. I'm not 100% sure about this, though, and don't have a machine handy to test. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: (cross post) SQL row numbering
Sort of... SELECT IDENTITY(int,1,1) as ID_Num, [name], Age INTO #tempTbl FROM myTable SELECT * FROM #tempTbl That's the only way afaik... #tempTbl will be built automatically. No need to declare it or create it. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 3:06 PM To: CF-Talk Subject: Re: OT: (cross post) SQL row numbering Matthew Small wrote: How can I get SQL server to automatically number my rows of a recordset, as I retrieve it? If I have the following information in a table (example data) NameAge Joe 20 Sally 14 Jim 15 And I do a query: Select somefunction() as rownum, name, age from table Doesn't SQL server support sequences? In that case somefunction would be next value expression. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: MM Suprises Wall Street - Can more be done?
While I appreciate the fact that ASP.Net is a pretty decent platform, I have to disagree with certain ideas. First, ASP.Net has been slow to adopt. ASP developers are forced to re-learn everything. There are a lot of things that only took a few minutes in Asp that are downright tricky in .net. Take for example a data grid you output. Let's say you wanted to do groupings of the table you're outputting. Something very simple to do in cf using the cfoutput group=foo tag. In ASP it's simple too. Has anyone actually tried to do something like that in asp.net? It took us months to find a straight answer on how to do that. It seems that there is a lot of things you have to do WAY differently, and that has met a lot of resistance. I can't see ASP.Net creeping up and taking over. I'd worry about PHP before I'd worry about asp.net. PHP from what I see is the most popular server-side scripting language in use today. And is a heck of a lot more flexible than asp.net. -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 9:33 AM To: CF-Talk Subject: Re: OT: MM Suprises Wall Street - Can more be done? On Friday, Jan 24, 2003, at 07:37 US/Pacific, S V wrote: Well great, but I see Asp.net creaping up and quickly too. As a product is seems to be more widely accepted and possibly will eclipse JSP/JAVA and others in a very short time. I very much doubt that. I think we may see an increasing divide between Windows and Unix in terms of ASP.NET and Java - I don't really see ASP.NET spreading out onto Unix much, even with efforts like MONO etc. Also, because of ASP.NET's indigenous nature on Windows, I don't see Java eating away too much there. A lot comes down to whether you want to use Windows or Unix. Here at Macromedia, we use Windows and Mac desktops and laptops but on the server side we're mostly Solaris. The SF-hosted portions of the website (all the static content, the current BroadVision-powered Online Store and Macromedia Exchanges etc) are all Solaris (Apache, Oracle). The Newton-hosted portions, inherited from Allaire, are all Windows (webforums, the current DevEx system, the events system, the partners system and the knowledge base). The Newton-hosted portions are powered by ColdFusion (a mixture of versions from 4.5 up to MX with a couple of Spectra systems). We are developing a new website, powered by ColdFusion MX, and hosted mostly here in SF on Solaris. I can't too many details yet but I'll be talking about the new site at MXDU (http://www.mxdu.com/). We're hosting a 6m page views a day website so our choice of platform may not match yours and we already had most of the Solaris hardware we needed - to switch to Windows would have been prohibitively expensive. If we were starting from scratch, I suspect we'd look more closely at Linux. I think Linux is a very interesting price/performance proposition: cheap hardware, lightweight / high performance O/S, lots of free software tools, great community support. seems that every where I go , clients want to do in in ASP/ASP.Net, while CF gets less respect. It seems to me that CF is not as ubiquitous as ASP/ASP.Net. It would be nice to see CF get the press coverage more frequently .. Any ideas??? Write articles about CF success stories and submit them to magazines. Seriously. Explain to your potential clients how much more cost-effective a ColdFusion solution will be than an ASP.NET solution. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim/iChat: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.macromedia.com/go/arch_blog ColdFusion MX and JRun 4 now available for Mac OS X! http://www.macromedia.com/go/cfmxosx ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: updating large verity collection
A good start would be to view the estimated execution plan in query analyzer... It'll show which index you're using on that query... Chances are it's not the right query. Make sure it isn't doing a table scan... That's usually what slows it down... -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 4:21 PM To: CF-Talk Subject: RE: updating large verity collection The query is probably running slowly because you dont have the appropriate indexes defined and applied. Look up how to manage indexes correctly in sql server books online, its worthwhile. -Jared Clinton. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 11:09 AM To: CF-Talk Subject: updating large verity collection So how do you guys handle updating very large collections? From a query (I'm using MSSQL Server). CF 5.0 As I understand it, I can update incrementally, without overwriting the previous updates, but I'm not sure how to do it. CFQUERY has a Maxrows attribute, but apparently not a startrow/endrow pair. I thought I would try something like this: SELECT ARCHIVE_ID blah, blah, blah, FROM table WHERE ARCHIVE_ID BETWEEN 1 and 1 i.e. between #form.startrow# and #form.endrow# But in query analyizer, this query takes FOREVER to run. What are my other options? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT Javascript Navigation
So for browser detection, it's pretty easy. Just use the variable http_user_info. Here's a list of all the possible values (not including spiders): http://www.zytrax.com/tech/web/browser_ids.htm Thing is, you can use CONTAINS and DOES NOT CONTAIN to pretty much determine OS and Browser. Write a UDF or Custom Tag to get that pretty easy, or there are plenty of them already available, although they may not return exactly what you're looking for... I'd not worry too much. Remember, eye candy should be used to only enhance a site, not become the basis for it. Have an alternative navigation system for those who are Browser Challeneged or something too, so that way you don't alienate people. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 4:25 PM To: CF-Talk Subject: SOT Javascript Navigation OK - all you MAC guru's - I'm finishing up a brand new CF ecommerce site using Javascript/DHTML/Stylesheets to generate dropdown tiered menus and pulling the nav data from my database It's the first time I've ever done this kind of nav menu (ok - it's ancient technology I know...) and it's awesome on PCs but on Macs running IE 5, IE 5.1 or Netscape 4.7 the entire navigation menu shows up half way down the page from where it's supposed to be positioned! Either I need to know how to fix the code if that's the problem, or how to detect someone viewing the site with a Mac and IE or Netscape Also, if ANYONE has AOL (MAC AND OR PC) please also look and let me know if the nav menu on the left is positioned just below the Advanced Search link as it should be instead of halfway down the page??? www.brionanet.com/firstavenue/sites/modstor ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML-type Syntax with CF Tags
You could of course steer away from using cf_myCT and instead just use the cfmodule file=myCF tag... Not as eloquent, but if that's the only real rule breakdown, then you can disregard that feature... -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:57 PM To: CF-Talk Subject: Re: XML-type Syntax with CF Tags On Monday, Jan 13, 2003, at 19:31 US/Pacific, Dave Carabetta wrote: On the one hand, since CFML looks so much like HTML's tag-based syntax, I'm guessing people do it for consistency to comply with XHTML standards. Yes, I do it so that my source files look consistent with XHTML. Further, in certain instances (i.e., custom tags), does the trailing slash cause the tag to be executed twice? For example, would the following syntax cause myCT to be run twice? Yes, invoking a custom tag with a closing tag like this: cf_myCT / is equivalent to invoking it with an empty body: cf_myCT/cf_myCT My custom tags - few in number - are coded to be called like that and behave correctly. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: unknown exception condition within cfstoredproc - win2k iis5 cf5 mssql2000
Looks fine to me... I'd try double-checking the data types and paraeters as well... -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:23 PM To: CF-Talk Subject: unknown exception condition within cfstoredproc - win2k iis5 cf5 mssql2000 I'm running CF5 on Win2k IIS5 with mssql2000 and getting unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFStoredProc::endTag The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (40:1) to (41:64) in the template file C:\CFUSIONMX\WWWROOT\DEV\TAPESTRY44E\_TAG\_OBJ\TAP_LIBRARYUPDATE.CFM. from this stored procedure: cfstoredproc procedure=tap_LibraryUpdate datasource=#request.tap.dsn# username=#request.tap.dsnusr# password=#request.tap.dsnpwd# cfprocparam type=In dbvarname=ID value=#attributes.ID# cfsqltype=cf_sql_integer cfprocparam type=in dbvarname=Name value=#attributes.Name# cfsqltype=cf_sql_varchar cfprocparam type=in dbvarname=RevisedBy value=#attributes.RevisedBy# cfsqltype=cf_sql_integer cfprocparam type=in dbvarname=Description value=#attributes.Description#cfsqltype=cf_sql_longvarchar cfprocparam type=in dbvarname=wddx value=#attributes.wddx# cfsqltype=cf_sql_longvarchar cfprocparam type=in dbvarname=Parent value=#attributes.Parent# cfsqltype=cf_sql_integer null=#yesnoformat(not isnumeric(attributes.parent))# cfprocparam type=in dbvarname=UpdateInterval value=#attributes.Update Interval# cfsqltype=cf_sql_varchar null=#yesnoformat(not len(attributes.updateinterval))# cfprocparam type=in dbvarname=dtNextUpdate value=#attributes.dtNextU pdate# cfsqltype=cf_sql_timestampnull=#yesnoformat(not isdate(attributes.dtNextUpdate))# cfprocparam type=in dbvarname=ExpirationDate value=#attributes.Expira tionDate# cfsqltype=cf_sql_timestamp null=#yesnoformat(not isdate(attributes.expirationdate))# cfprocparam type=in dbvarname=FileExtension value=#attributes.FileExt ension#cfsqltype=cf_sql_varchar null=#yesnoformat(not len(attributes.FileExtension))# /cfstoredproc Anybody see anything out of the ordinary? s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
Easy. cfcontent file=foo.gif type=application/whatever cfquery datasource=#application.ds# ...tracking query here... /cfquery You include the image, and some server-side code to process it. Done it a few times... -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:52 AM To: CF-Talk Subject: web beacons Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ASP to ColdFusion
Woo hoo... Another convert :-) A quick search on google gets some good introductury tutorials... http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tutoria l2.html http://www.macromedia.com/support/coldfusion/tutorial_index.html http://kongtechnology.com/index.asp?im=cf1 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:53 AM To: CF-Talk Subject: ASP to ColdFusion I'm originally an ASP developer now working with ColdFusion...Does anyone know of any resources that would help in the conversion? (ASP-CF translations, tutorials, etc.) Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
Oh yeah, and you can pass url parameters to that image as well... So let's say you send an email to employeeid 145. You can add a parameter the the src of the gif file in the html email you send him as such: img src=http://www.myserver.com/image.cfm?id=145; Then in the source... Of image.cfm, something like this appears: cfcontent file=foo.gif type=application/whatever cfquery datasource=#application.ds# insert into someTable (employeeid, date) values (#val(url.id)#, getdate()) /cfquery -Original Message- From: Costas Piliotis Sent: Monday, January 13, 2003 10:00 AM To: CF-Talk Subject: RE: web beacons Easy. cfcontent file=foo.gif type=application/whatever cfquery datasource=#application.ds# ...tracking query here... /cfquery You include the image, and some server-side code to process it. Done it a few times... -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:52 AM To: CF-Talk Subject: web beacons Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query help!
CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#createODBCDateTime(now())# type=cf_sql_timestamp /CFQUERY -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:21 AM To: CF-Talk Subject: Re: Query help! Please look at the help docs for cfqueryparam. It takes at least two params, one for value and another for type. You should specify the type. Also note that you don't have to format the date when passing to cfqueryparam. Best regards, Sam BTW, a lot of people don't use cfqueryparam until they have worked with CF for a while. I'm glad to see you're doing things the right way from the outset (that was your post about being a recent convert from ASP, right?). At 01:02 PM 1/13/2003, you wrote: Can someone tell me what's wrong with this line: CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#formatdate(now(),mm-dd-yy)# /CFQUERY I can't figure out how to get a date query to work right... Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
You're just referring to the mod_rewrite feature in apache... It takes this: http://www.mailmate.be/bcn.jpg?imagx=6.4891.1927023596 And rewrites it as: http://www.mailmate.be/imagx/6.4891.1927023596/bcn.jpg -Original Message- From: DDB Lists [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:59 AM To: CF-Talk Subject: Re: web beacons I got images like this: img src=http://www.mailmate.be/imagx/6.4891.1927023596/bcn.jpg; this contains the mail id, the person's id and a checksum digit Server side is a url rewriting mechanism that changes the link to imagx.cfm?linkid=... img=bcn.jpg and then a cold fusion page to take care of the rest - Original Message - From: Justin Greene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 7:54 PM Subject: RE: web beacons The more sophisticated web bugs do not use a parameter, but instead actually use the filename itself to identify the individual and each email has a different image being requested. Quite effective in HTML email and on web pages. Justin -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:24 PM To: CF-Talk Subject: RE: web beacons Yep.. One of the ways that spammers, these days, collect info on valid email addresses when using HTML email campaigns. You simply view the email, and BAM.. they know your email address is good. Old news | -Original Message- | From: Costas Piliotis [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 10:04 AM | To: CF-Talk | Subject: RE: web beacons | | | Oh yeah, and you can pass url parameters to that image as well... | So let's say you send an email to employeeid 145. | | You can add a parameter the the src of the gif file in the html | email you send him as such: | | img src=http://www.myserver.com/image.cfm?id=145; | | Then in the source... Of image.cfm, something like this | appears: cfcontent file=foo.gif type=application/whatever | cfquery datasource=#application.ds# insert into someTable | (employeeid, date) values (#val(url.id)#, getdate()) | /cfquery | | -Original Message- | From: Costas Piliotis | Sent: Monday, January 13, 2003 10:00 AM | To: CF-Talk | Subject: RE: web beacons | | | Easy. | | cfcontent file=foo.gif type=application/whatever cfquery | datasource=#application.ds# ...tracking query here... | /cfquery | | You include the image, and some server-side code to process it. | Done it a few times... | | -Original Message- | From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 9:52 AM | To: CF-Talk | Subject: web beacons | | | Yahoo is using something called web beacons. Can anyone simply | explain how a single pixel gif is used as a web beacon. | http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Top 10 Web App Security Flaws
Very interesting... Don't know if I agree with the order of them, but still a pretty damn good read actually... -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:13 AM To: CF-Talk Subject: Top 10 Web App Security Flaws Interesting list can be found here: http://www.owasp.org/ (via SlashDot) H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
I think that has to do with search engine friendly sites, not web beacons... -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:47 AM To: CF-Talk Subject: RE: web beacons Ben Forta wrote it. A Cure for Arachnophobia : http://www.sys-con.com/coldfusion/article.cfm?id=388 ~Todd At 07:39 PM 1/13/2003 +, you wrote: There was an article in the Cold Fusion Developers Journal awhile ago about this - not sure when but I can look in the old issues that I have. Mario -Original Message- From: DDB Lists [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:59 PM To: CF-Talk Subject: Re: web beacons I got images like this: img src=http://www.mailmate.be/imagx/6.4891.1927023596/bcn.jpg; this contains the mail id, the person's id and a checksum digit Server side is a url rewriting mechanism that changes the link to imagx.cfm?linkid=... img=bcn.jpg and then a cold fusion page to take care of the rest -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.com/ -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons (stop caching)
Shouldn't really cache though if UserID is different for each time the beacon is called should it? -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:29 PM To: CF-Talk Subject: RE: web beacons (stop caching) Make it unique. For example, add some unique value to it like: IMG SRC=http://www.domain.dom/getWebBug.cfm?UserID=5PageID=6Random=52; WIDTH=1 HEIGHT=1 -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 4:11 PM To: CF-Talk Subject: RE: web beacons (stop caching) How do you stop proxy servers and browsers from caching the beacon? e ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: UNSUBSCRIBE
Link seems to work fine for me... Maybe the internet is broken... -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 7:08 AM To: CF-Talk Subject: RE: UNSUBSCRIBE Nuts. The auto unsubscribe link at the bottom of the email isn't working. How do I unsubscribe? Thanks, Ryan -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:06 AM To: CF-Talk Subject: UNSUBSCRIBE UNSUBSCRIBE ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS CF?
Can we hold you you to that? Pretty bold statement IMHO... -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 2:12 AM To: CF-Talk Subject: RE: MS CF? : http://theregister.co.uk/content/4/28667.html I'll have to kill myself if this happens. Really. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Issue: Change row color on mouse over in Netscape 4.7
I actually think it's getting to be a good time to force them to upgrade. There was a time where websites started coming along that had a minimum Nutscrape 4/IE 4 requirement. Why not take a moment and raise the bar to IE 5 / Nutscrape 6 /Opera 6 / Mozilla 1.0... Makes sense to me... -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 12:55 PM To: CF-Talk Subject: Re: Issue: Change row color on mouse over in Netscape 4.7 You won't get it to work, NS 4.7's CSS and DHTML support is very weak. I'm also real sure that you can't use an onMouseOver event on a TR or a TD in 4.7 However, from a philosophical perspective (and I don't mean to get OT or cause a furor), if your users are about average as far as browser stats, I wouldn't even bother to offer anything beyond a basic, presentable layout in NS4.x since they are a very small minority (5% on our site). But that's just me, I love browsers with solid CSS support :-) Pete - Original Message - From: James Blaha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 1:17 PM Subject: Issue: Change row color on mouse over in Netscape 4.7 Hello Everyone: I've spent too many hours on this I hit a wall. I'm using the code below to alternate row color for my table and when you mouse over each row it should change the background color for the row. It works in IE 5+ and Netscape 6+ but I can't get it to work in Netscape 4.7 any ideas? TR valign=top bgcolor=###iif(currentrow MOD 2,DE('BFCCE6'),DE('D8DFE1'))# onmouseover=this.style.backgroundColor='##FAF7B8'; window.status='My Window Message';return true; onmouseout=this.style.backgroundColor='###iif(currentrow MOD 2,DE('BFCCE6'),DE('D8DFE1'))#'; window.status=''; return true; Bonus Question: I'm working within a framed page it possible when the user mouse's over the row to send a value to a window.status for Netscape 4.7? Regards, James Blaha ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: refresh iframe
Just reload like you would a normal window... Make sure you use the id attribute of the tag, not the name attribute of it. iframeid.location.href.reload(); Yes, it's src, not href... Although an iframe is also a window, and a window has the href attribute, so I think you can use either... -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:46 PM To: CF-Talk Subject: RE: refresh iframe If I remember correctly iframes have an href property you can set to change/update the page. Like an image. i.e. .matchList.href = 'blah.html' this is just off the top of my head though so I could be crazy wrong. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: E. Keith Dodd [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:18 PM To: CF-Talk Subject: OT: refresh iframe Have 2 iframes in a page: iframe names are matchList and matchDetail. When making certain updates in a matchDetail template, want to refresh the template in matchList. Have done this in standard frames with something like the code below in the main frame to refresh a list in a side frame: Script parent.List.location=myList.cfm /script Is there something similar for iframes? Tried script matchList.location=myList.cfm /script but that didn't do it. Thanks for any suggestions. E. Keith Dodd Wings of Eagles Services www.wingserv.com - [This E-mail scanned for viruses by declude AntiVirus Software] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: mySQL equivalent of MS Access Money fieldtype?
If I'm not mistaken, there's a float or decimal data type in mysql... Trying to remember off the top of my head. Use that data type. Also, try this: #val(Form.UCPaymentAmount)# It will remove all unnecessary formatting and convert the form value to a number each time. Should work fine for what you need. Just make sure you round your numbers off consistantly all the time... That's the real place you need to be careful at. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:10 AM To: CF-Talk Subject: RE: mySQL equivalent of MS Access Money fieldtype? I'm running into some of the very problems you mention. I tried Decimal as the field type, but 100.5 gets rounded up to 101.00...not good. I tried Integer, but when, for example, 100.50 gets entered into a formfield, then inserted into the db, it gets truncated to 100. How do I set up Integer to retain 2 decimal places? Also, I'm trying to setup the mySQL db fieldtype and CF processing such that if a user inputs $100.50, which is not a number, mySQL won't reject it. I tried setting up the CF input line with various combinations of functions, such as: cfqueryparam cfsqltype=CF_SQL_INTEGER Value=#LSCurrentFormat(LSParseNumber(Form.UCPaymentAmount))# but I haven't been able to find the right combo to allow users to input either 100.50, 100.5, or $100.50 and still get the right number into the db without rounding or truncating and back out for display on the CF page. Clues? Rick -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 12:26 PM To: CF-Talk Subject: Re: mySQL equivalent of MS Access Money fieldtype? On Tuesday, Dec 17, 2002, at 07:41 US/Pacific, Stephen Moretti wrote: INT is INTEGER which means that there's no decimal places Not much good for real money that I'm afraid. Integer is the safer way to represent money - as pennies - because that way you avoid rounding errors. Financial applications should never use floating point to represent dollars (or whatever). If you take 0.00 and add 0.01 a hundred times, you're quite likely to get something which does not equal 1.00 because of inherent inaccuracies in floating point representation. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Issue: Change row color on mouse over in Netscape 4.7
I'm not sure, but does nutscrape 4.7 even support dhtml? I'm not sure it supports the onmouseover/onmouseout events... Why bother? Nutscrape 4.xx users are fast on the decline, so if you make it look okay for them and great for everyone else, don't worry about it... There's a tonne of sites that forego features when nutscrape users hit their sites. Just the way it works. If you use a crappy, four year old browser, you don't deserve the right to see the eye candy. What's next, rollovers in Lynx? Let the flames begin! -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:18 AM To: CF-Talk Subject: Issue: Change row color on mouse over in Netscape 4.7 Hello Everyone: I've spent too many hours on this I hit a wall. I'm using the code below to alternate row color for my table and when you mouse over each row it should change the background color for the row. It works in IE 5+ and Netscape 6+ but I can't get it to work in Netscape 4.7 any ideas? TR valign=top bgcolor=###iif(currentrow MOD 2,DE('BFCCE6'),DE('D8DFE1'))# onmouseover=this.style.backgroundColor='##FAF7B8'; window.status='My Window Message';return true; onmouseout=this.style.backgroundColor='###iif(currentrow MOD 2,DE('BFCCE6'),DE('D8DFE1'))#'; window.status=''; return true; Bonus Question: I'm working within a framed page it possible when the user mouse's over the row to send a value to a window.status for Netscape 4.7? Regards, James Blaha ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm