Re: ot: lcd monitors
Hi Dave, I managed to get hold of a Compaq 7020 which has been really good to me. With DV input and built in speakers which was a must for me. Andy J www.andyjarrett.co.uk On Sat, 18 Dec 2004 18:07:17 -0500, dave [EMAIL PROTECTED] wrote: any recommends on a 17 lcd? and not a $1000 one either mostly standard stuff not much gaming but occasionally ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188220 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion security framework
On 12/10/04 6:58 PM, Jim Davis wrote: I've uploaded a zip of the CFCs involved to: ftp://ftp.depressedpress.com/FTP/cfc_DepressedPress.zip I am trying to understand your code, but it's a bit hard w/o knowing the db tables and relationships ... Can you provide the db schema (e.g. Erwin) and the SQL script? Thanks a lot. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188221 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: SQL
Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The output shows bascially whether the user has passed all courses. So user 1 would be an overall 'Pass' mark as all courses are completed. Yet user 2 would be an overall 'Fail' as he/she has one more course to pass. Oh and this is a QoQ that i have to do this in. Any help appreciated Regards Andy J www.andyjarrett.co.uk ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188222 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
time to cluster, I thinkL
I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. How do I get this idea off the ground, and how would you do things differently, assuming there's a shoestring budget for this.?? I'd want 2 machines each running IIS and CFMX6.1. Both IIS's would share both CFMX instances. Assume I have 4-5 cf apps running on virtual hostnames on the web servers, but only one is massive Here are my questions. Assuming I have windows 2K servers, how can I Get uploaded files to propagate across both machines in near real time? Do they share a third machine's MSSQL 2k? or do I set up 2 sql servers, one on each box, with replication? (Can both machines push replication to each other, or does one always have to be the master?) Please advise on a low cost, (hopefully software-based) 2 machine clustering setup with CF, MSSQL and IIS. Thanks! NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL
Whats the question? On Mon, 20 Dec 2004 11:50:34 +, Andy Jarrett [EMAIL PROTECTED] wrote: Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The output shows bascially whether the user has passed all courses. So user 1 would be an overall 'Pass' mark as all courses are completed. Yet user 2 would be an overall 'Fail' as he/she has one more course to pass. Oh and this is a QoQ that i have to do this in. Any help appreciated Regards Andy J www.andyjarrett.co.uk ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188224 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL
Opps badly worded post sorry. Im trying to create a QoQ SQL statement that would return whether user 1 has passed or failed by checking that all his grades are passes? I've just been playing with another method were i am using the QoQ to return the users marks then just by checking that the amount of pass marks equals the amount of entries for the user. Hope this makes sense Andy J On Mon, 20 Dec 2004 13:23:04 +0100, Mark Drew [EMAIL PROTECTED] wrote: Whats the question? On Mon, 20 Dec 2004 11:50:34 +, Andy Jarrett [EMAIL PROTECTED] wrote: Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The output shows bascially whether the user has passed all courses. So user 1 would be an overall 'Pass' mark as all courses are completed. Yet user 2 would be an overall 'Fail' as he/she has one more course to pass. Oh and this is a QoQ that i have to do this in. Any help appreciated Regards Andy J www.andyjarrett.co.uk ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188225 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL
Hey Andy, Instead of seeing if they're all Pass, why not just see if there are any failed? For user 1: cffunction name=userFailed returntype=boolean cfargument name=qGrades type=query cfargument name=userId type=numeric cfset var qGetGrades = / cfquery dbType=query name=qGetGrades SELECT userId WHERE grade = 'fail' AND userId = cfqueryparam cfsqltype=cf_sql_int value=#arguments.userId# /cfquery !--- Return 0 if there are no failures, int other than 0 (true) if there is a failure --- cfreturn qGetGrades.recordCount / /cffunction -joe On Mon, 20 Dec 2004 12:32:12 +, Andy Jarrett [EMAIL PROTECTED] wrote: Opps badly worded post sorry. Im trying to create a QoQ SQL statement that would return whether user 1 has passed or failed by checking that all his grades are passes? I've just been playing with another method were i am using the QoQ to return the users marks then just by checking that the amount of pass marks equals the amount of entries for the user. Hope this makes sense Andy J On Mon, 20 Dec 2004 13:23:04 +0100, Mark Drew [EMAIL PROTECTED] wrote: Whats the question? On Mon, 20 Dec 2004 11:50:34 +, Andy Jarrett [EMAIL PROTECTED] wrote: Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The output shows bascially whether the user has passed all courses. So user 1 would be an overall 'Pass' mark as all courses are completed. Yet user 2 would be an overall 'Fail' as he/she has one more course to pass. Oh and this is a QoQ that i have to do this in. Any help appreciated Regards Andy J www.andyjarrett.co.uk ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188226 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL
I don' think you can get those who passed and failed in the same query using QofQ. Getting those who failed is easy: cfquery name=qOverall dbtype=query SELECT DISTINCt userid FROM q WHERE pass = 'fail' /cfquery Then you can use your first query and CF to display passed and failed: PaAscal -Original Message- From: Andy Jarrett [mailto:[EMAIL PROTECTED] Sent: 20 December 2004 12:51 To: CF-Talk Subject: OT: SQL Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The output shows bascially whether the user has passed all courses. So user 1 would be an overall 'Pass' mark as all courses are completed. Yet user 2 would be an overall 'Fail' as he/she has one more course to pass. Oh and this is a QoQ that i have to do this in. Any help appreciated Regards Andy J www.andyjarrett.co.uk ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL
Or you could Count(mark) where it equals fail and count where it equals pass total them and there you go :D On Mon, 20 Dec 2004 07:41:15 -0500, Joe Rinehart [EMAIL PROTECTED] wrote: Hey Andy, Instead of seeing if they're all Pass, why not just see if there are any failed? For user 1: cffunction name=userFailed returntype=boolean cfargument name=qGrades type=query cfargument name=userId type=numeric cfset var qGetGrades = / cfquery dbType=query name=qGetGrades SELECT userId WHERE grade = 'fail' AND userId = cfqueryparam cfsqltype=cf_sql_int value=#arguments.userId# /cfquery !--- Return 0 if there are no failures, int other than 0 (true) if there is a failure --- cfreturn qGetGrades.recordCount / /cffunction -joe On Mon, 20 Dec 2004 12:32:12 +, Andy Jarrett [EMAIL PROTECTED] wrote: Opps badly worded post sorry. Im trying to create a QoQ SQL statement that would return whether user 1 has passed or failed by checking that all his grades are passes? I've just been playing with another method were i am using the QoQ to return the users marks then just by checking that the amount of pass marks equals the amount of entries for the user. Hope this makes sense Andy J On Mon, 20 Dec 2004 13:23:04 +0100, Mark Drew [EMAIL PROTECTED] wrote: Whats the question? On Mon, 20 Dec 2004 11:50:34 +, Andy Jarrett [EMAIL PROTECTED] wrote: Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The output shows bascially whether the user has passed all courses. So user 1 would be an overall 'Pass' mark as all courses are completed. Yet user 2 would be an overall 'Fail' as he/she has one more course to pass. Oh and this is a QoQ that i have to do this in. Any help appreciated Regards Andy J www.andyjarrett.co.uk ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188228 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to detect if a session has timed out?
While not comletely foolproof I have done using a cookie that keeps track of the clients view of whether they are logged in or not. If the cookie says they are logged in, but there is no session, then the session has timed out. Just need to set it to something to indicate they are logged in, then remove it when they logout. Cheers Mike Kear [EMAIL PROTECTED] wrote: I have an application where we want to tell the user that their session has timed out through inactivity (if it has). I know how to detect if a session no longer exists, but how do you tell if it's timed out (rather than the person closing the browser or logging out)? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Win a castle for NYE with your mates and Yahoo! Messenger ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188229 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model
S.Isaac Dealey wrote: S.Isaac Dealey wrote: Mime-Version: 1.0 Content-Type: text/plain so after all this time, there's still no standard that allows an adequate means of specifying something as simple as height 100% ... because according to the w3c, 100% of the height of an airplane discludes its canopy and landing gear and 100% of its length discludes its propeller and tail-fins... Things aren't as simple as that. I believe that the W3C box model builds on established norms in typesetting. The real crackheads are the idiots who gave us Microsoft's alternative box model when the W3C one was already around. Except that with the w3c box model there are still a small number of very simple things which are ... I hate to say it, but _FLAT_IMPOSSIBLE_ to accomplish. Whereas this is not the case with the MS box model. An example would be helpful. Whether the w3c box model is based on typesetting norms imo is irrelevant, given that the dominant medium for HTML is _NOT_ print. Maybe so, it it has to deal with people who are coming from a print background. What matters is that a viewable page can be formatted in a consistent manner which allows us full control over the display -- which we don't have with the w3c model. Full control, shmull control: there'll always be a browser that screws up in some way. As soon as the page leaves the server, there goes our control over how it's displayed. My efforts to support the w3c model are based on the idea that it's better to have a _BROKEN_ standard than no standard. That's fair, but I don't see *how* exactly it's broken? A pain at times, yes, but calling it broken seems a little much. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL
Joe, Sorry, but to add to your solution another problem ( i don't do this on purpose, promise). It will also return 0 where the is no user there, in which case you get a false positive. Mark, you'd have to do the counts as 2 different SQL's statements which was something i was trying to avoid. I've now created a UDF which checks the occurance of a word in a string/list. So with the SQL SELECT userId WHERE userId = 'xx' I am using ValueList() and my UDF for checking that the occurance of pass equals the recordcount. On Mon, 20 Dec 2004 13:45:59 +0100, Mark Drew [EMAIL PROTECTED] wrote: Or you could Count(mark) where it equals fail and count where it equals pass total them and there you go :D On Mon, 20 Dec 2004 07:41:15 -0500, Joe Rinehart [EMAIL PROTECTED] wrote: Hey Andy, Instead of seeing if they're all Pass, why not just see if there are any failed? For user 1: cffunction name=userFailed returntype=boolean cfargument name=qGrades type=query cfargument name=userId type=numeric cfset var qGetGrades = / cfquery dbType=query name=qGetGrades SELECT userId WHERE grade = 'fail' AND userId = cfqueryparam cfsqltype=cf_sql_int value=#arguments.userId# /cfquery !--- Return 0 if there are no failures, int other than 0 (true) if there is a failure --- cfreturn qGetGrades.recordCount / /cffunction -joe On Mon, 20 Dec 2004 12:32:12 +, Andy Jarrett [EMAIL PROTECTED] wrote: Opps badly worded post sorry. Im trying to create a QoQ SQL statement that would return whether user 1 has passed or failed by checking that all his grades are passes? I've just been playing with another method were i am using the QoQ to return the users marks then just by checking that the amount of pass marks equals the amount of entries for the user. Hope this makes sense Andy J On Mon, 20 Dec 2004 13:23:04 +0100, Mark Drew [EMAIL PROTECTED] wrote: Whats the question? On Mon, 20 Dec 2004 11:50:34 +, Andy Jarrett [EMAIL PROTECTED] wrote: Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The output shows bascially whether the user has passed all courses. So user 1 would be an overall 'Pass' mark as all courses are completed. Yet user 2 would be an overall 'Fail' as he/she has one more course to pass. Oh and this is a QoQ that i have to do this in. Any help appreciated Regards Andy J www.andyjarrett.co.uk ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
updating my date_added from a form fails
I have an Oracle database with a record where when I update it with now() it works. From that point on, for editing, I carry the date_added through a hidden form field which has the source of INPUT TYPE='Hidden' NAME='date_added' VALUE='2004-12-20 08:50:51.0' When I try and use that hidden form field with the date to update the record, I get the following error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended :Error Executing Database Query. update giving_leavesset name = 'daniel', date_added = 2004-12-20 08:50:51.0, recipients_fname = 'Robins', recipients_lname = 'Ventura', recipients_mi = 'b', address= '10472 outter_space ct', city = 'scaggsville', state = 'md', zip= '20723', phone= '301-776-3926', email= '[EMAIL PROTECTED]', charge_card= 'VISA/MC', charge_number= '12345679', charge_month= 02, charge_year= 2006, check_information= '', leaf_choices= '5,3,4', line_1= 'We love your mustache', line_2= 'Mr. Ventura', line_3= 'and your fashion sense.', line_4= 'Love dad', line_5= '2004', fund= 'Health and Society Visiting Professorship', fund_other= '', status= 'Reserved' where leaf_number = 5 As I said, this works if I insert Now() and this date started as a Now() update. This is an Oracle database and the field is of type DATE. Without that field in the update the query works fine. Here's the query that's failing with that above error: CFQUERY NAME=makeEdit DATASOURCE=dpch update giving_leaves set name = '#Form.name#', date_added = #Form.date_added#, recipients_fname = '#Form.recipients_fname#', recipients_lname = '#Form.recipients_lname#', recipients_mi = '#Form.recipients_mi#', address= '#Form.address#', city = '#Form.city#', state = '#Form.state#', zip= '#Form.zip#', phone= '#Form.phone#', email= '#Form.email#', charge_card= '#Form.charge_card#', charge_number= '#Form.charge_number#', charge_month= #Form.charge_month#, charge_year= #Form.charge_year#, check_information= '#Form.check_information#', leaf_choices= '#leaf_choices#', line_1= '#Form.line_1#', line_2= '#Form.line_2#', line_3= '#Form.line_3#', line_4= '#Form.line_4#', line_5= '#Form.line_5#', fund= '#Form.fund#', fund_other= '#Form.fund_other#', status= '#Form.status#' where leaf_number = #Form.leaf_number# /CFQUERY I've looked at this for awhile and hope I'm missing something obvious. Thanks for any comments. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188232 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: updating my date_added from a form fails
try wrapping Form.date_added in a createODBCDateTime() function (or just a createODBCDate() if you don't need time). On Mon, 20 Dec 2004 09:03:27 -0500, Daniel Kessler [EMAIL PROTECTED] wrote: I have an Oracle database with a record where when I update it with now() it works. From that point on, for editing, I carry the date_added through a hidden form field which has the source of INPUT TYPE='Hidden' NAME='date_added' VALUE='2004-12-20 08:50:51.0' When I try and use that hidden form field with the date to update the record, I get the following error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended :Error Executing Database Query. update giving_leavesset name = 'daniel', date_added = 2004-12-20 08:50:51.0, recipients_fname = 'Robins', recipients_lname = 'Ventura', recipients_mi = 'b', address= '10472 outter_space ct', city = 'scaggsville', state = 'md', zip= '20723', phone= '301-776-3926', email= '[EMAIL PROTECTED]', charge_card= 'VISA/MC', charge_number= '12345679', charge_month= 02, charge_year= 2006, check_information= '', leaf_choices= '5,3,4', line_1= 'We love your mustache', line_2= 'Mr. Ventura', line_3= 'and your fashion sense.', line_4= 'Love dad', line_5= '2004', fund= 'Health and Society Visiting Professorship', fund_other= '', status= 'Reserved' where leaf_number = 5 As I said, this works if I insert Now() and this date started as a Now() update. This is an Oracle database and the field is of type DATE. Without that field in the update the query works fine. Here's the query that's failing with that above error: CFQUERY NAME=makeEdit DATASOURCE=dpch update giving_leaves set name = '#Form.name#', date_added = #Form.date_added#, recipients_fname = '#Form.recipients_fname#', recipients_lname = '#Form.recipients_lname#', recipients_mi = '#Form.recipients_mi#', address= '#Form.address#', city = '#Form.city#', state = '#Form.state#', zip= '#Form.zip#', phone= '#Form.phone#', email= '#Form.email#', charge_card= '#Form.charge_card#', charge_number= '#Form.charge_number#', charge_month= #Form.charge_month#, charge_year= #Form.charge_year#, check_information= '#Form.check_information#', leaf_choices= '#leaf_choices#', line_1= '#Form.line_1#', line_2= '#Form.line_2#', line_3= '#Form.line_3#', line_4= '#Form.line_4#', line_5= '#Form.line_5#', fund= '#Form.fund#', fund_other= '#Form.fund_other#', status= '#Form.status#' where leaf_number = #Form.leaf_number# /CFQUERY I've looked at this for awhile and hope I'm missing something obvious. Thanks for any comments. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188233 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I thinkL
Katz, Dov B (IT) wrote: I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. Which problem? Jochem ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model
S.Isaac Dealey wrote: S.Isaac Dealey wrote: Except that with the w3c box model there are still a small number of very simple things which are ... I hate to say it, but _FLAT_IMPOSSIBLE_ to accomplish. Whereas this is not the case with the MS box model. An example would be helpful. You must have missed the first message in this thread... Here's the archive url: http://www.houseoffusion.com/cf_lists/messages.cfm/threadid:37168/foru mid:4 What matters is that a viewable page can be formatted in a consistent manner which allows us full control over the display -- which we don't have with the w3c model. Full control, shmull control: there'll always be a browser that screws up in some way. As soon as the page leaves the server, there goes our control over how it's displayed. Except I'm not talking about every browser. I'm not talking about Konqueror not rendering correctly -- I'm talking about not having control even when using a browser which is said to render the box model correctly. My efforts to support the w3c model are based on the idea that it's better to have a _BROKEN_ standard than no standard. That's fair, but I don't see *how* exactly it's broken? A pain at times, yes, but calling it broken seems a little much. Two iframes side by side which together fill the screen horizontally having a fixed amount of space between the iframe and the window edge and a fixed amount of space between each other and which also fill the remainder of the height of the window after a header and footer div are placed above and below them, and which don't degenerated into one above and one below when the browser is shrunk horizontally. If you can accomplish that in Firefox or IE6 with the appropriate doctype, I'd be mighty impressed, and I'd amend/retract what I've said. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: updating my date_added from a form fails
Thanks Charlie, that worked great. I guess I assumed that since form value number works fine as a number, date would do the same. Guess it works this way since date is more complex. I appreciate the help. May your code go smoothly today. try wrapping Form.date_added in a createODBCDateTime() function (or just a createODBCDate() if you don't need time). On Mon, 20 Dec 2004 09:03:27 -0500, Daniel Kessler [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I thinkL
Sorry for not making clearer My problem now is heavy load, and general risk of availability by having a SPoF. Both would be mitigated by a more load balanced, redundant system... -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:13 AM To: CF-Talk Subject: Re: time to cluster, I thinkL Katz, Dov B (IT) wrote: I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. Which problem? Jochem ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I thinkL
I'm going to be blasted for this, but clustering is the last resort, not first. 1. Do you have seperate boxes for DB and webserver? (no) 2. Are they maxed in ram? (probably) 3. Are they peaked? (?) 4. Is your network set up tight? (no as it's one server) Just moving the SQL to a new box will extend the life/power of your setup. The box you have now looks good, but is taxed by non-web serving operations. I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. How do I get this idea off the ground, and how would you do things differently, assuming there's a shoestring budget for this.?? I'd want 2 machines each running IIS and CFMX6.1. Both IIS's would share both CFMX instances. Assume I have 4-5 cf apps running on virtual hostnames on the web servers, but only one is massive Here are my questions. Assuming I have windows 2K servers, how can I Get uploaded files to propagate across both machines in near real time? Do they share a third machine's MSSQL 2k? or do I set up 2 sql servers, one on each box, with replication? (Can both machines push replication to each other, or does one always have to be the master?) Please advise on a low cost, (hopefully software-based) 2 machine clustering setup with CF, MSSQL and IIS. Thanks! NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I thinkL
IMHO I think the first step, assuming you only have a budget for 1 extra machine, would be to move your MSSQL installation onto a separate box to free up some more resources for CF. This'll save you a bit too as you should have most of the software licenses you need too. After you've done that you could look at adding extra CF servers and hardware/software load balancing in. Perhaps it'd be best to have the busy site on it's own high spec. shiny new box and keep the quiet sites on the existing server. My 2p worth, Ant ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I think
I hear you... So let me give this a try and see if things get any better. Assuming both boxes are on the same network, do you see any network latency cost involved? -Dov -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:26 AM To: CF-Talk Subject: Re: time to cluster, I thinkL I'm going to be blasted for this, but clustering is the last resort, not first. 1. Do you have seperate boxes for DB and webserver? (no) 2. Are they maxed in ram? (probably) 3. Are they peaked? (?) 4. Is your network set up tight? (no as it's one server) Just moving the SQL to a new box will extend the life/power of your setup. The box you have now looks good, but is taxed by non-web serving operations. I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. How do I get this idea off the ground, and how would you do things differently, assuming there's a shoestring budget for this.?? I'd want 2 machines each running IIS and CFMX6.1. Both IIS's would share both CFMX instances. Assume I have 4-5 cf apps running on virtual hostnames on the web servers, but only one is massive Here are my questions. Assuming I have windows 2K servers, how can I Get uploaded files to propagate across both machines in near real time? Do they share a third machine's MSSQL 2k? or do I set up 2 sql servers, one on each box, with replication? (Can both machines push replication to each other, or does one always have to be the master?) Please advise on a low cost, (hopefully software-based) 2 machine clustering setup with CF, MSSQL and IIS. Thanks! NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I thinkL
Katz, Dov B (IT) wrote: Sorry for not making clearer My problem now is heavy load Moving the database to a separate box from the application / webserver would be the first step. general risk of availability by having a SPoF. It is better to have a SPoF with 99.8% uptime then 2 systems with 95% uptime each :-) Jochem ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I think
This is how I'd do it. The web server has 2 nic cards. The first is set to the external network only and is used for traffic. The second is set to internal only and is used to transfer data to the box from the SQL. This removes excess traffic from the network. The 'net stuff' should be on it's own network segment from internal business and dev to again optimize the connections. The less non-essential packets the better. This may be overkill, but I hear you... So let me give this a try and see if things get any better. Assuming both boxes are on the same network, do you see any network latency cost involved? -Dov -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:26 AM To: CF-Talk Subject: Re: time to cluster, I thinkL I'm going to be blasted for this, but clustering is the last resort, not first. 1. Do you have seperate boxes for DB and webserver? (no) 2. Are they maxed in ram? (probably) 3. Are they peaked? (?) 4. Is your network set up tight? (no as it's one server) Just moving the SQL to a new box will extend the life/power of your setup. The box you have now looks good, but is taxed by non-web serving operations. I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. How do I get this idea off the ground, and how would you do things differently, assuming there's a shoestring budget for this.?? I'd want 2 machines each running IIS and CFMX6.1. Both IIS's would share both CFMX instances. Assume I have 4-5 cf apps running on virtual hostnames on the web servers, but only one is massive Here are my questions. Assuming I have windows 2K servers, how can I Get uploaded files to propagate across both machines in near real time? Do they share a third machine's MSSQL 2k? or do I set up 2 sql servers, one on each box, with replication? (Can both machines push replication to each other, or does one always have to be the master?) Please advise on a low cost, (hopefully software-based) 2 machine clustering setup with CF, MSSQL and IIS. Thanks! NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I think
You could do that with a crossover cable from the Web server to the DB server, right? No need for extra switches or anything like that. - Matt Small -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:53 AM To: CF-Talk Subject: Re: time to cluster, I think This is how I'd do it. The web server has 2 nic cards. The first is set to the external network only and is used for traffic. The second is set to internal only and is used to transfer data to the box from the SQL. This removes excess traffic from the network. The 'net stuff' should be on it's own network segment from internal business and dev to again optimize the connections. The less non-essential packets the better. This may be overkill, but I hear you... So let me give this a try and see if things get any better. Assuming both boxes are on the same network, do you see any network latency cost involved? -Dov -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:26 AM To: CF-Talk Subject: Re: time to cluster, I thinkL I'm going to be blasted for this, but clustering is the last resort, not first. 1. Do you have seperate boxes for DB and webserver? (no) 2. Are they maxed in ram? (probably) 3. Are they peaked? (?) 4. Is your network set up tight? (no as it's one server) Just moving the SQL to a new box will extend the life/power of your setup. The box you have now looks good, but is taxed by non-web serving operations. I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. How do I get this idea off the ground, and how would you do things differently, assuming there's a shoestring budget for this.?? I'd want 2 machines each running IIS and CFMX6.1. Both IIS's would share both CFMX instances. Assume I have 4-5 cf apps running on virtual hostnames on the web servers, but only one is massive Here are my questions. Assuming I have windows 2K servers, how can I Get uploaded files to propagate across both machines in near real time? Do they share a third machine's MSSQL 2k? or do I set up 2 sql servers, one on each box, with replication? (Can both machines push replication to each other, or does one always have to be the master?) Please advise on a low cost, (hopefully software-based) 2 machine clustering setup with CF, MSSQL and IIS. Thanks! NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I think
I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. How do I get this idea off the ground, and how would you do things differently, assuming there's a shoestring budget for this.?? I'd want 2 machines each running IIS and CFMX6.1. Both IIS's would share both CFMX instances. Assume I have 4-5 cf apps running on virtual hostnames on the web servers, but only one is massive Here are my questions. Assuming I have windows 2K servers, how can I Get uploaded files to propagate across both machines in near real time? Do they share a third machine's MSSQL 2k? or do I set up 2 sql servers, one on each box, with replication? (Can both machines push replication to each other, or does one always have to be the master?) Please advise on a low cost, (hopefully software-based) 2 machine clustering setup with CF, MSSQL and IIS. Unfortunately, you don't usually find clustering and low cost in the same sentence. As others have already mentioned, there are lots of things you can do before moving to a cluster. The biggest single thing you need to do is deploy a dedicated database server on a separate machine. You'd want to do this whether you cluster your web or application servers, or not. To cluster CFMX or run multiple CFMX instances per server, you'd need to purchase one CFMX Enterprise license per machine. Right now, you're running CFMX Professional. So, that would be pretty expensive right there. You could cluster your web server software using the NLB functionality built into Windows. I've set this up before for people using CFMX Professional. In this case, you'd need to avoid using Session variables or use sticky sessions to ensure that users only get sent to one cluster member. If you use sticky sessions, you don't get full load-balancing, since if a server goes down the users on that server will lose their session data. While NLB is cheap, being built into Windows Server 2003 (I'm not sure about previous versions), it's not as nice as hardware load-balancers by a long shot in my opinion. As Mike D has said, there's probably room for improvement within your application code and current infrastructure. I would disagree that you should necessarily spend your resources there, though. While I'm all for improving the performance of applications in general, you will have to decide whether it's cheaper to spend time optimizing your applications or to invest in clustering or other hardware solutions. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I think
You could do that with a crossover cable from the Web server to the DB server, right? No need for extra switches or anything like that. Yes, I'm sure you could. However, within these sorts of environments, typically there's an internal network used for hosting databases and other internal services. At least, that's been my experience. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I think
It is better to have a SPoF with 99.8% uptime then 2 systems with 95% uptime each :-) I'm not sure I'd agree with that, as long as only one system is down at any given time! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cftree on client
Hi all. Is there a way to let the users select files on their own file system and upload them. I am not talking about the browse button that you get with cffile. Something similar to cftree, but on the client side. thanks. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188247 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I think
Thanks for all the valuable input. I've been improving the code, but it seems that growth of usership is constantly outpacing me (which is a good thing, I guess). I had written something much like the CF_Accelerate tag by brandon purcell, but mine can take a mode parameter to store to File (for larger content), RAM_AS_Content (like his), RAM_AS_Query (to actually cache cfquery results), or RAM_AS_Struct (to cache cfstructs). This has proven tremendously helpful in reducing load. On a separate note, does anyone know the ULIMIT in windows of maximum open sockets in CFMX's JVM by default? When CFMX bombs out, it's because of a (out of buffer space, max connections reached?) error I'm trying to narrow that down. I suspected a cfscheduled RSS type feed generator, and suspended it, but am curious what else is leaking connections (I guess I need to run some netstats on this one when I see it happen) I'm going to get a DB server set up and part out that portion of the infrastructure. That, as you all seem to agree, should be a better investment than any sort of clustering infrastructure, simply to solve a load issue. Thanks as always for the helpful info! -Dov -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 10:08 AM To: CF-Talk Subject: RE: time to cluster, I think I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. This is what i was thinking would solve the problem for me, in theory. How do I get this idea off the ground, and how would you do things differently, assuming there's a shoestring budget for this.?? I'd want 2 machines each running IIS and CFMX6.1. Both IIS's would share both CFMX instances. Assume I have 4-5 cf apps running on virtual hostnames on the web servers, but only one is massive Here are my questions. Assuming I have windows 2K servers, how can I Get uploaded files to propagate across both machines in near real time? Do they share a third machine's MSSQL 2k? or do I set up 2 sql servers, one on each box, with replication? (Can both machines push replication to each other, or does one always have to be the master?) Please advise on a low cost, (hopefully software-based) 2 machine clustering setup with CF, MSSQL and IIS. Unfortunately, you don't usually find clustering and low cost in the same sentence. As others have already mentioned, there are lots of things you can do before moving to a cluster. The biggest single thing you need to do is deploy a dedicated database server on a separate machine. You'd want to do this whether you cluster your web or application servers, or not. To cluster CFMX or run multiple CFMX instances per server, you'd need to purchase one CFMX Enterprise license per machine. Right now, you're running CFMX Professional. So, that would be pretty expensive right there. You could cluster your web server software using the NLB functionality built into Windows. I've set this up before for people using CFMX Professional. In this case, you'd need to avoid using Session variables or use sticky sessions to ensure that users only get sent to one cluster member. If you use sticky sessions, you don't get full load-balancing, since if a server goes down the users on that server will lose their session data. While NLB is cheap, being built into Windows Server 2003 (I'm not sure about previous versions), it's not as nice as hardware load-balancers by a long shot in my opinion. As Mike D has said, there's probably room for improvement within your application code and current infrastructure. I would disagree that you should necessarily spend your resources there, though. While I'm all for improving the performance of applications in general, you will have to decide whether it's cheaper to spend time optimizing your applications or to invest in clustering or other hardware solutions. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: updating my date_added from a form fails
Or even better, use cfqueryparam -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 20 December 2004 15:09 To: CF-Talk Subject: Re: updating my date_added from a form fails try wrapping Form.date_added in a createODBCDateTime() function (or just a createODBCDate() if you don't need time). On Mon, 20 Dec 2004 09:03:27 -0500, Daniel Kessler [EMAIL PROTECTED] wrote: I have an Oracle database with a record where when I update it with now() it works. From that point on, for editing, I carry the date_added through a hidden form field which has the source of INPUT TYPE='Hidden' NAME='date_added' VALUE='2004-12-20 08:50:51.0' When I try and use that hidden form field with the date to update the record, I get the following error: ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion security framework
-Original Message- From: The Wolf [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 6:46 AM To: CF-Talk Subject: Re: ColdFusion security framework On 12/10/04 6:58 PM, Jim Davis wrote: I've uploaded a zip of the CFCs involved to: ftp://ftp.depressedpress.com/FTP/cfc_DepressedPress.zip I am trying to understand your code, but it's a bit hard w/o knowing the db tables and relationships ... Can you provide the db schema (e.g. Erwin) and the SQL script? All of the table generation code is the following CFC: \cfc_DepressedPress\Security\DB_SQLServer2000\DP_SecurityConfiguration_Broke r.cfc (This is the installation/uninstallation configuration CFC.) There are essentially only two methods here: install (create data tables and populate them with initial parameters and the administrator account) and uninstall (destroy the tables). That code is generated partly from SQL Server 2000 and so might need tweaking for other DBs (probably just the removal of [dbo] I would think - the code is very simple.) Is that what you're looking for? Jim Davis ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: updating my date_added from a form fails
i still wrap date/time values in createODBCDate() functions inside of cfqueryparam tags. probably overkill, but old habits and all... :) On Mon, 20 Dec 2004 16:11:47 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Or even better, use cfqueryparam -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 20 December 2004 15:09 To: CF-Talk Subject: Re: updating my date_added from a form fails try wrapping Form.date_added in a createODBCDateTime() function (or just a createODBCDate() if you don't need time). On Mon, 20 Dec 2004 09:03:27 -0500, Daniel Kessler [EMAIL PROTECTED] wrote: I have an Oracle database with a record where when I update it with now() it works. From that point on, for editing, I carry the date_added through a hidden form field which has the source of INPUT TYPE='Hidden' NAME='date_added' VALUE='2004-12-20 08:50:51.0' When I try and use that hidden form field with the date to update the record, I get the following error: ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cftree on client
Ken, No - ColdFusion is purely server-side, and can't do anything with the client's filesystem. Using the input type=file name=...'s Browse button will show you whatever their client browser's default mode of handling it is, which in Windows will be the open file dialog. This is the 'tree' most people are used to. -Joe On Mon, 20 Dec 2004 10:10:22 -0500, Ken [EMAIL PROTECTED] wrote: Hi all. Is there a way to let the users select files on their own file system and upload them. I am not talking about the browse button that you get with cffile. Something similar to cftree, but on the client side. thanks. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: updating my date_added from a form fails
Why are you even updating it - if you're just setting it back to the same created date? Also, you can use oracles default sysdate right in your table definition so that you don't have to add a date at all - if you are really just tracking the added date and not the updated date. - Original Message - From: daniel kessler [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, December 20, 2004 7:19 AM Subject: Re: updating my date_added from a form fails Thanks Charlie, that worked great. I guess I assumed that since form value number works fine as a number, date would do the same. Guess it works this way since date is more complex. I appreciate the help. May your code go smoothly today. try wrapping Form.date_added in a createODBCDateTime() function (or just a createODBCDate() if you don't need time). On Mon, 20 Dec 2004 09:03:27 -0500, Daniel Kessler [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model
S.Isaac Dealey wrote: S.Isaac Dealey wrote: S.Isaac Dealey wrote: Except that with the w3c box model there are still a small number of very simple things which are ... I hate to say it, but _FLAT_IMPOSSIBLE_ to accomplish. Whereas this is not the case with the MS box model. An example would be helpful. You must have missed the first message in this thread... Here's the archive url: http://www.houseoffusion.com/cf_lists/messages.cfm/threadid:37168/foru mid:4 Ah, either AVG or Thunderbird must've decided to clip that. What matters is that a viewable page can be formatted in a consistent manner which allows us full control over the display -- which we don't have with the w3c model. Full control, shmull control: there'll always be a browser that screws up in some way. As soon as the page leaves the server, there goes our control over how it's displayed. Except I'm not talking about every browser. I'm not talking about Konqueror not rendering correctly -- I'm talking about not having control even when using a browser which is said to render the box model correctly. My efforts to support the w3c model are based on the idea that it's better to have a _BROKEN_ standard than no standard. That's fair, but I don't see *how* exactly it's broken? A pain at times, yes, but calling it broken seems a little much. Two iframes side by side which together fill the screen horizontally having a fixed amount of space between the iframe and the window edge and a fixed amount of space between each other and which also fill the remainder of the height of the window after a header and footer div are placed above and below them, and which don't degenerated into one above and one below when the browser is shrunk horizontally. If you can accomplish that in Firefox or IE6 with the appropriate doctype, I'd be mighty impressed, and I'd amend/retract what I've said. Well, your problems are manyfold. Firstly, you're depending on behaviour that was never mandated in the specs, that being that a height of 100% means 100% of the available window area or available area. The specs, for better or for worse, don't recogise this usage because it's meaningless in the broader context of positioning, which is that positioning is done on the basis of the total rendering area of the page, not just the current viewport. You'll get this behaviour *without* the doctype because that's how it was treated by browsers in the past. This is quirks mode, and there be funkiness. If IE wasn't so braindead, it'd support fixed positioning. In this case, you could position your elements wherever you liked relative to the four sides of the screen. This is possible in Firefox, but not in IE, because MS have slowly let IE die. Your problem isn't with the spec--and definitely not with the box model, which doesn't even come up here--but with a lack of implementation of the spec. However, depending on what you're trying to write, frames are probably a better way of doing this anyway. All you seem to be doing is trying to emulate them anyway, and iframes in this context are a bit icky anyway. I'll throw the fixed positioning code your way if you like. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I think
Actually, I was suggesting to throw more ram at the machine and seperate the webserver from the SQL. While I do like tight code and DB, it's not the first thing to add; Ram is. I have 5 levels of optimization: 1. Code 2. DB structure 3. Hardware 4. Network 5. Server settings Code and DB take time to do and is the last resort unless you know of a specific bottleneck. Network is usually out of the hands of the box owner. Server settings are easy to do in some cases (turn off services) and harder to do in others (what to uninstall, etc.). Hardware is the easiest thing to work with. Throwing Ram at a box can result in a big jump. Multiple processors is good as well. Seperate boxes for DB and webserver is like the second thing to do past extra ram. My initial order is: basic server settings ram seperate servers code review 1 (errors/big bottlenecks) DB review 1 (really bad tables, adding SP) For those with more time than money, the code and DB move up above things that cost like hardware, but only if money is an issue. As Mike D has said, there's probably room for improvement within your application code and current infrastructure. I would disagree that you should necessarily spend your resources there, though. While I'm all for improving the performance of applications in general, you will have to decide whether it's cheaper to spend time optimizing your applications or to invest in clustering or other hardware solutions. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I thinkL
On Mon, 20 Dec 2004 09:26:18 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm going to be blasted for this, but clustering is the last resort, not first. I would be surprised if anyone blasts you. 1. Do you have seperate boxes for DB and webserver? (no) This would be the first thing I'd suggest (and what everyone else seems to suggest). People need clustering for failover more than they need it for handling load, e.g., macromedia.com runs on a cluster but that's mostly to give us 100% uptime even when we're making new releases of the website (we take half the servers out of the cluster and build to those, test the apps, put them back in the cluster, pull the other half, build, test, put them back). And clustering definitely isn't entry level - it's expensive. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Dynamic Forms Help
Hello all, In a CFFORM I have a dynamically populated CFSELECT that generates a list of entities, where value = NUMBER (of entity) and display = NAME (of entity) What I am trying to do is paste the name of the selected entity into a TEXTAREA below, depending on the selection. Is this possible? Any help will be most welcome. Please reply privately if you prefer. Many thanks in advance, Pedro http://www.pedromendes.com http://www.pedromendes.com/ ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I thinkL
Why do you want to cluster? If it is for reliability, then that is ok. But if you need speed, you may be best off just putting the IIS/CF on one computer and the MSSQL2K on the other computer, since you already have one license of each. The computers are cheaper than the licenses. If you do it your way, you will need another license of each. One other possibility if you have a heavy load of video or graphic or PDFs, is to set up a 3rd server, hopefully linux to save on that OS license, just to serve the graphic and static stuff. When I first started, I made the mistake of having everything on one server.. IIS/ SQL server and REAL video server. The real video got too busy and slowed down everything. What I do now is have the Video on a separate server (hosted elsewhere:), so if it gets bogged down, it doesn't affect the speed of the website itself. Al Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz processors, and a gig of ram. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic Forms Help
dunno if the cfform generated code will affect this, but try adding the following to your cfselect tag: onchange=this.form.TEXTAREA_NAME.value = this.options[this.selectedIndex].text On Mon, 20 Dec 2004 16:07:49 -, Pedro Mendes [EMAIL PROTECTED] wrote: Hello all, In a CFFORM I have a dynamically populated CFSELECT that generates a list of entities, where value = NUMBER (of entity) and display = NAME (of entity) What I am trying to do is paste the name of the selected entity into a TEXTAREA below, depending on the selection. Is this possible? Any help will be most welcome. Please reply privately if you prefer. Many thanks in advance, Pedro http://www.pedromendes.com http://www.pedromendes.com/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I thinkL
Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? I'm just curious how many hits these sites are getting that you're seeing bad enough performance to warrant this. Might help me in planning ahead some. John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:03 AM To: CF-Talk Subject: Re: time to cluster, I thinkL On Mon, 20 Dec 2004 09:26:18 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm going to be blasted for this, but clustering is the last resort, not first. I would be surprised if anyone blasts you. 1. Do you have seperate boxes for DB and webserver? (no) This would be the first thing I'd suggest (and what everyone else seems to suggest). People need clustering for failover more than they need it for handling load, e.g., macromedia.com runs on a cluster but that's mostly to give us 100% uptime even when we're making new releases of the website (we take half the servers out of the cluster and build to those, test the apps, put them back in the cluster, pull the other half, build, test, put them back). And clustering definitely isn't entry level - it's expensive. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Need help with summary report, please
I have a table where 25 codes are captured. The underlying columns in the database are: Code1 Code2 .. .. Code25 I need to extract a list of DISTINCT values entered in ALL of the columns, and the count of each of those values across all 25 columns. Note that it is possible to have NO value in a given field. Over all 25 columns, there are a total of 9770 values (not distint) so we are talking about a fair number of entries. Desired result is something like this: CodeCount 123.4 115 124.6 101 .. .. .. What is the most efficient way to do this? CF6.1 Win2k3 Server Access 2002 TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I thinkL
On the heavy site, exceeding 600k page views a day, and pages are pretty large - www.onlysimchas.com Rightnow it's stable, but it spikes to 90-95% cpu during high load times... Moving the DB will probably bring me some more stability while the internals get more renovation.. -dov -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:22 AM To: CF-Talk Subject: RE: time to cluster, I thinkL Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? I'm just curious how many hits these sites are getting that you're seeing bad enough performance to warrant this. Might help me in planning ahead some. John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:03 AM To: CF-Talk Subject: Re: time to cluster, I thinkL On Mon, 20 Dec 2004 09:26:18 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm going to be blasted for this, but clustering is the last resort, not first. I would be surprised if anyone blasts you. 1. Do you have seperate boxes for DB and webserver? (no) This would be the first thing I'd suggest (and what everyone else seems to suggest). People need clustering for failover more than they need it for handling load, e.g., macromedia.com runs on a cluster but that's mostly to give us 100% uptime even when we're making new releases of the website (we take half the servers out of the cluster and build to those, test the apps, put them back in the cluster, pull the other half, build, test, put them back). And clustering definitely isn't entry level - it's expensive. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I thinkL
Burns, John D wrote: Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? It isn't so much about having to split, but wanting to split. I don't want to run a database server on the server that also runs the application server and the webserver: - I like the security of an extra layer in front of my database - I want issues to be isolated in one tier, instead of being on a machine that does many things that influence eachother - I want to properly dimension hardware for each tier, without having to oversize it because it has to be good at everything Jochem ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JS issue
Yeah it was the missing return in the function call.
I didnt want the onSubmit because this form had 2 submit buttons.
I needed this to be a separate function, however that got it and I
appreciate it!
On Fri, 17 Dec 2004 15:54:57 -0500, Ray Champagne [EMAIL PROTECTED] wrote:
How are you calling the function?
You should be calling it like this:
onSubmit=javascript: return subForm();
and add:
return true;
to the else clause.
This drove me crazy a few weeks ago.
Ray
At 03:52 PM 12/17/2004, you wrote:
I have a button which calls a JS function
I'm checking to see if a date is prior to another.. if not then the
function should alert the user and return out of the function. If it's
prior to the end date then the function should change the action of
the form and then submit the form.
I have this..
function subForm()
{
if (document.siteReferrals.StartDate.value
document.siteReferrals.EndDate.value)
{
alert(Your Start Date must be before your End Date);
return false;
}
else
{
document.siteReferrals.action='Report-SiteReferrals.cfm';
document.siteReferrals.submit();
}
}
No matter what it always submits the page.
Even if it alerts me that the start date is greater then the end date.
--
Auxilium meum a Domino
~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188264
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Hey, question about Dreamweaver, Fireworks, checking out files, etc...
Is there a way that anyone knows of, for you to somehow link your site with fireworks? If I keep a PNG file in a library folder in my site, I check the source PNG file in, so that if anyone needs to change the PNG file, they have to check it out, just like pages within the site, etc. But that only works if you're checking out the file from within Dreamweaver. If, say, you open the PNG by simply launching Fireworks and opening the PNG file, you've bypassed the check in/check out process Dreamweaver uses, and what's worse, when you go to save the file, you're told you can't, because the file's locked. Typical solution is to make your changes to the PNG file, export the working graphic, then close the PNG without saving your file, pretty much making the whole reason for checking it out pointless... So what I was wondering was, is anyone using Fireworks/Dreamweaver in their workflow and have a way to check out a file in Fireworks before working on it? I really dig the application linking between the two, but if you mess up and go outside of the dreamweaver workflow, it basically stops working...or is that just the way it's designed? ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I thinkL
We have a cluster setup for one of our clients using enterprise and hardware loadbalancing. The sql servers are on internal IP's routing traffic through the secondary nic on the webservers. The site gets roughly 10-16000 visits per day with around 50,000 page views. Every page hits the database. It primarily serves images and video. We also host the sister company of this client. They get roughly the same amount of traffic. This site is on cfmx pro with the sql server running separate on internal IP's. It is a duplicate application of the parent site. All machines are dual 3ghz xeons with 4 gigs of ram and raid1 with a hotswap. So far the only difference is administrative and equipment costs. When something goes wrong we spend far more time on the cluster than we ever would on the pro machine. There is still the availability advantage but I'm not sure the cost factor outweighs the one hour of downtime it would take to restore the site should some disaster happen. My advice would be to keep it as simple stupid as possible for as long as possible. Separate the sql, double check that you have all the performance tips in check for your cf installation and then consider clustering if it doesn't help. On a side note... I noticed you have google adwords. Has it been worth the real estate? Emmet -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:33 AM To: CF-Talk Subject: RE: time to cluster, I thinkL On the heavy site, exceeding 600k page views a day, and pages are pretty large - www.onlysimchas.com Rightnow it's stable, but it spikes to 90-95% cpu during high load times... Moving the DB will probably bring me some more stability while the internals get more renovation.. -dov -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:22 AM To: CF-Talk Subject: RE: time to cluster, I thinkL Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? I'm just curious how many hits these sites are getting that you're seeing bad enough performance to warrant this. Might help me in planning ahead some. John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:03 AM To: CF-Talk Subject: Re: time to cluster, I thinkL On Mon, 20 Dec 2004 09:26:18 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm going to be blasted for this, but clustering is the last resort, not first. I would be surprised if anyone blasts you. 1. Do you have seperate boxes for DB and webserver? (no) This would be the first thing I'd suggest (and what everyone else seems to suggest). People need clustering for failover more than they need it for handling load, e.g., macromedia.com runs on a cluster but that's mostly to give us 100% uptime even when we're making new releases of the website (we take half the servers out of the cluster and build to those, test the apps, put them back in the cluster, pull the other half, build, test, put them back). And clustering definitely isn't entry level - it's expensive. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Question from a beginner on visible invisible divs
Hi, I am hoping someone can point me to a tutorial or link(s) explaining how I might be able to created visible/invisible divs. My navigation system is made up a myriad of hikes broken down into categories. I would like to create functionality that presents the page collapsed showing the categories and if the user clicks the category expands the hikes in the category. Anyone know a good source of information on how this is done? Another example of what I am after is myyahoo where you can expand and minimize sections of content you have selected. Any advice appreciated Thanks, John ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Force user to the login page automatically
I have an Application.cfm which timeout the session in 15 min. How is it possible to redirect the user to the logout page automatically when the session expires. i.e. user is on add.cfm page. and he left the screen there and came back to computer after 25 min and he is still on this page. he fill up all the fields and when he submit the button he was prompt to re-login. I want to show the use right when he come back he should see the logout page. how to re-direct the browser automatically to the loguout page when session expired. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I thinkL
In addition, a default install of SQL Server, for instance, will pre-allocate just about all system resources to the SQL Server instance or balance them out among multiple instances. This provides performance benefits over a model in which resources have to be allocated on the fly. From my experience, it actually takes quite a bit of work to convince SQL Server that it's not the only application on the server. In particular, watching SQL Server duke it out with the Sun JVM over memory is not a pretty sight. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:42 AM To: CF-Talk Subject: Re: time to cluster, I thinkL Burns, John D wrote: Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? It isn't so much about having to split, but wanting to split. I don't want to run a database server on the server that also runs the application server and the webserver: - I like the security of an extra layer in front of my database - I want issues to be isolated in one tier, instead of being on a machine that does many things that influence eachother - I want to properly dimension hardware for each tier, without having to oversize it because it has to be good at everything Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I thinkL
With a lot of traffic (At least for my website), it practically pays for dedicated hosting. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:08 PM To: CF-Talk Subject: RE: time to cluster, I thinkL We have a cluster setup for one of our clients using enterprise and hardware loadbalancing. The sql servers are on internal IP's routing traffic through the secondary nic on the webservers. The site gets roughly 10-16000 visits per day with around 50,000 page views. Every page hits the database. It primarily serves images and video. We also host the sister company of this client. They get roughly the same amount of traffic. This site is on cfmx pro with the sql server running separate on internal IP's. It is a duplicate application of the parent site. All machines are dual 3ghz xeons with 4 gigs of ram and raid1 with a hotswap. So far the only difference is administrative and equipment costs. When something goes wrong we spend far more time on the cluster than we ever would on the pro machine. There is still the availability advantage but I'm not sure the cost factor outweighs the one hour of downtime it would take to restore the site should some disaster happen. My advice would be to keep it as simple stupid as possible for as long as possible. Separate the sql, double check that you have all the performance tips in check for your cf installation and then consider clustering if it doesn't help. On a side note... I noticed you have google adwords. Has it been worth the real estate? Emmet -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:33 AM To: CF-Talk Subject: RE: time to cluster, I thinkL On the heavy site, exceeding 600k page views a day, and pages are pretty large - www.onlysimchas.com Rightnow it's stable, but it spikes to 90-95% cpu during high load times... Moving the DB will probably bring me some more stability while the internals get more renovation.. -dov -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:22 AM To: CF-Talk Subject: RE: time to cluster, I thinkL Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? I'm just curious how many hits these sites are getting that you're seeing bad enough performance to warrant this. Might help me in planning ahead some. John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:03 AM To: CF-Talk Subject: Re: time to cluster, I thinkL On Mon, 20 Dec 2004 09:26:18 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm going to be blasted for this, but clustering is the last resort, not first. I would be surprised if anyone blasts you. 1. Do you have seperate boxes for DB and webserver? (no) This would be the first thing I'd suggest (and what everyone else seems to suggest). People need clustering for failover more than they need it for handling load, e.g., macromedia.com runs on a cluster but that's mostly to give us 100% uptime even when we're making new releases of the website (we take half the servers out of the cluster and build to those, test the apps, put them back in the cluster, pull the other half, build, test, put them back). And clustering definitely isn't entry level - it's expensive. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Test Posting
My last posting did not work, I think. So, I am testing my ability to post. Jerry ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Force user to the login page automatically
Use a timed javascript redirect. Set the timeout length the same as the session length. You could even do it with a meta refresh. emmet -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:15 AM To: CF-Talk Subject: Force user to the login page automatically I have an Application.cfm which timeout the session in 15 min. How is it possible to redirect the user to the logout page automatically when the session expires. i.e. user is on add.cfm page. and he left the screen there and came back to computer after 25 min and he is still on this page. he fill up all the fields and when he submit the button he was prompt to re-login. I want to show the use right when he come back he should see the logout page. how to re-direct the browser automatically to the loguout page when session expired. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question from a beginner on visible invisible divs
What you want is the display attribute.
Divs display is normally set at inline
IE
div id='divBlock' style=display:block;
You can set this to none using JS.
document.getElementById('divBlock').style.display='none';
and to set it back
document.getElementById('divBlock').style.display='inline';
I use the msdn reference located here..
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/objects.asp
On Mon, 20 Dec 2004 09:11:38 -0800, John Munyan [EMAIL PROTECTED] wrote:
Hi, I am hoping someone can point me to a tutorial or link(s) explaining how
I might be able to created visible/invisible divs. My navigation system is
made up a myriad of hikes broken down into categories. I would like to
create functionality that presents the page collapsed showing the categories
and if the user clicks the category expands the hikes in the category.
Anyone know a good source of information on how this is done?
Another example of what I am after is myyahoo where you can expand and
minimize sections of content you have selected.
Any advice appreciated
Thanks,
John
~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188273
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
database query
I have two tables in my DB: Companies: company_ID (PK) company_name etc Contacts: contact_company_FK (FK linked to company_ID) contact_name etc What I need to do is query the DB and get all the companies and all the contacts associated with that company, even if there are no contacts for a particular company. I am passing in the #company_ID# to the page. I think what I am supposed to be doing is a LEFT JOIN, but I can't get the syntax to work correctly. Anybody got any ideas for this? I am using the evil MS Access DB and CFMX 6.1. Thanks! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Test Posting
You are able. At 11:23 AM 12/20/2004, you wrote: My last posting did not work, I think. So, I am testing my ability to post. Jerry ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I thinkL
With a lot of traffic (At least for my website), it practically pays for dedicated hosting. On a side note... I noticed you have google adwords. Has it been worth the real estate? Emmet NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: time to cluster, I thinkL
Thanks... I always wondered. I own a couple of hi traffic travel portals for our area and was hesitant to give advertising space up for something like that. e -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:18 PM To: CF-Talk Subject: RE: time to cluster, I thinkL With a lot of traffic (At least for my website), it practically pays for dedicated hosting. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:08 PM To: CF-Talk Subject: RE: time to cluster, I thinkL We have a cluster setup for one of our clients using enterprise and hardware loadbalancing. The sql servers are on internal IP's routing traffic through the secondary nic on the webservers. The site gets roughly 10-16000 visits per day with around 50,000 page views. Every page hits the database. It primarily serves images and video. We also host the sister company of this client. They get roughly the same amount of traffic. This site is on cfmx pro with the sql server running separate on internal IP's. It is a duplicate application of the parent site. All machines are dual 3ghz xeons with 4 gigs of ram and raid1 with a hotswap. So far the only difference is administrative and equipment costs. When something goes wrong we spend far more time on the cluster than we ever would on the pro machine. There is still the availability advantage but I'm not sure the cost factor outweighs the one hour of downtime it would take to restore the site should some disaster happen. My advice would be to keep it as simple stupid as possible for as long as possible. Separate the sql, double check that you have all the performance tips in check for your cf installation and then consider clustering if it doesn't help. On a side note... I noticed you have google adwords. Has it been worth the real estate? Emmet -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:33 AM To: CF-Talk Subject: RE: time to cluster, I thinkL On the heavy site, exceeding 600k page views a day, and pages are pretty large - www.onlysimchas.com Rightnow it's stable, but it spikes to 90-95% cpu during high load times... Moving the DB will probably bring me some more stability while the internals get more renovation.. -dov -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:22 AM To: CF-Talk Subject: RE: time to cluster, I thinkL Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? I'm just curious how many hits these sites are getting that you're seeing bad enough performance to warrant this. Might help me in planning ahead some. John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:03 AM To: CF-Talk Subject: Re: time to cluster, I thinkL On Mon, 20 Dec 2004 09:26:18 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm going to be blasted for this, but clustering is the last resort, not first. I would be surprised if anyone blasts you. 1. Do you have seperate boxes for DB and webserver? (no) This would be the first thing I'd suggest (and what everyone else seems to suggest). People need clustering for failover more than they need it for handling load, e.g., macromedia.com runs on a cluster but that's mostly to give us 100% uptime even when we're making new releases of the website (we take half the servers out of the cluster and build to those, test the apps, put them back in the cluster, pull the other half, build, test, put them back). And clustering definitely isn't entry level - it's expensive. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question from a beginner on visible invisible divs
A quick Google search will find all the info you need on hide/show div. I'd carefully consider your desired navigation If you have 100's of hike you would have to load ALL of them in ONE RQUEST to populate all the hidden divs. That could really suck if these hikes are highly visual.lotsa graphics etc. ;-) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: John Munyan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, December 20, 2004 9:11 AM Subject: Question from a beginner on visible invisible divs Hi, I am hoping someone can point me to a tutorial or link(s) explaining how I might be able to created visible/invisible divs. My navigation system is made up a myriad of hikes broken down into categories. I would like to create functionality that presents the page collapsed showing the categories and if the user clicks the category expands the hikes in the category. Anyone know a good source of information on how this is done? Another example of what I am after is myyahoo where you can expand and minimize sections of content you have selected. Any advice appreciated Thanks, John ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Force user to the login page automatically
You mean to put the blow code in application.cfm??
InvalidTag language=JavaScript!--
setTimeout('Redirect()',4000);
function Redirect()
{
location.href = '../htmljavascript.htm';
}
// --/script
Use a timed javascript redirect. Set the timeout length the same as the
session length. You could even do it with a meta refresh.
emmet
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Monday, December 20, 2004 11:15 AM
To: CF-Talk
Subject: Force user to the login page automatically
I have an Application.cfm which timeout the session in 15 min.
How is it possible to redirect the user to the logout page automatically
when the session expires.
i.e. user is on add.cfm page.
and he left the screen there and came back to computer after 25 min and he
is still on this page. he fill up all the fields and when he submit the
button he was prompt to re-login.
I want to show the use right when he come back he should see the logout
page.
how to re-direct the browser automatically to the loguout page when session
expired.
~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188279
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
HTTP header containing CFID cookie is being ignored
My CFM pages are a simple HTML form and a response page containing enough CFML to display CFID, CFTOKEN, and a CLIENT variable or two. These pages work exactly as expected in Internet Explorer and I have watched the HTTP header traffic here and this is also as expected. These pages do not work as expected when I use a testing application (Canoo Webtest) to fill in and submit the form. If I turn on debugging in Webtest, I can watch the HTTP header traffic flowing back and forth between Webtest and my server and when I try to run the same pages that worked in IE, I can see that the cookie coming from Webtest is being ignored by my server. In other words, 1) the server starts by setting a cookie in the browser with: Set-Cookie: CFID=118341; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; 2) the browser will send a header containing: Cookie: CFID=118341 3) the server will then reply with: Set-Cookie: CFID=118342; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; So, the server is not accepting CFID=118315 for some reason and issuing the next increment in CFID to the browser. The client variable does exist on the server though because if I pass CFID and CFTOKEN in the action URL of the form, Webtest can submit the form just as well as Internet Explorer. Examination of the headers in this URL-passed case shows that the server recognizes the CFID and CFTOKEN from the URL and responds with an identical CFID and CFTOKEN in the Set-Cookie header of the next response. I can't figure out why the cookie information in the Webtest-initiated request is being ignored by our server. The headers appear to be formatted correctly. Here is an example of the trace and you will see where the server accepts URL-appended parameters and ignores cookie header information. In this example, I start at working.cfm, which submits to security_router.cfm with CFID and CFTOKEN in the action URL. Notice that the browser is also responding with the initial header information, but the server only recognizes the URL version (a 118351 value proven to work consistently). The browser then dutifully accepts the new CFID value which it will use in its next request. Finally, working.cfm is loaded a second time as a final test and here we stop. The browser CFID cookie is ignored on the second working.cfm load, but, in this case, there is no URL to save the day and the server increments the CFID in its next response. Again, this all works fine in Internet Explorer and all settings in CFAPPLICATION are set correctly. Anyone have any ideas? Jerry [testSpec] DEBUG (httpclient.wire.header) - GET /personal/pgh009/_TESTING/center/templates/working.cfm HTTP/1.1[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - User-Agent: Mozilla/4.0 (compatible; MSIE 6.0b; Windows 98)[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Host: test.allied.nwie.net[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - [\r][\n] [testSpec] DEBUG (httpclient.wire.header) - HTTP/1.1 200 OK[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Server: Microsoft-IIS/5.0[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Date: Wed, 15 Dec 2004 20:16:16 GMT[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Pragma: no-cache[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Cache-Control: no-cache[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Expires: Monday, 01 Jan 1980 15:20 GMT[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Connection: close[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Content-type: text/html[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Page-Completion-Status: Normal[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Page-Completion-Status: Normal[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Set-Cookie: CFID=118341; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/;[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Set-Cookie: CFTOKEN=4d7a427%2D31a7af1b%2D5d61%2D415a%2D9bcc%2D75a5aa5aee29; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/;[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - POST /personal/pgh009/_TESTING/center/templates/security_router.cfm?CFID=118315CFTOKEN=5183111-9%20fcc7411-1b5e-40b9-a49a-10fb201ee036 HTTP/1.1[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - User-Agent: Mozilla/4.0 (compatible; MSIE 6.0b; Windows 98)[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Host: test.allied.nwie.net[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Cookie: CFID=118341[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Cookie: CFTOKEN=4d7a427%2D31a7af1b%2D5d61%2D415a%2D9bcc%2D75a5aa5aee29[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Content-Length: 41[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Content-Type: application/x-www-form-urlencoded[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - [\r][\n] [testSpec] DEBUG (httpclient.wire.header) - HTTP/1.1 100 Continue[\r][\n] [testSpec] DEBUG (httpclient.wire.header) - Server: Microsoft-IIS/5.0[\r][\n] [testSpec]
RE: database query
Select company_ID, company_name, contact_company_FK, contact_name From companies LEFT OUTER JOIN Contacts ON company_ID = contact_company_FK Or RIGHT -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:23 PM To: CF-Talk Subject: database query I have two tables in my DB: Companies: company_ID (PK) company_name etc Contacts: contact_company_FK (FK linked to company_ID) contact_name etc What I need to do is query the DB and get all the companies and all the contacts associated with that company, even if there are no contacts for a particular company. I am passing in the #company_ID# to the page. I think what I am supposed to be doing is a LEFT JOIN, but I can't get the syntax to work correctly. Anybody got any ideas for this? I am using the evil MS Access DB and CFMX 6.1. Thanks! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Force user to the login page automatically
Sure, or in the header if its shared amongst all the pages.
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Monday, December 20, 2004 11:32 AM
To: CF-Talk
Subject: Re: Force user to the login page automatically
You mean to put the blow code in application.cfm??
InvalidTag language=JavaScript!--
setTimeout('Redirect()',4000);
function Redirect()
{
location.href = '../htmljavascript.htm';
}
// --/script
Use a timed javascript redirect. Set the timeout length the same as the
session length. You could even do it with a meta refresh.
emmet
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Monday, December 20, 2004 11:15 AM
To: CF-Talk
Subject: Force user to the login page automatically
I have an Application.cfm which timeout the session in 15 min.
How is it possible to redirect the user to the logout page automatically
when the session expires.
i.e. user is on add.cfm page.
and he left the screen there and came back to computer after 25 min and he
is still on this page. he fill up all the fields and when he submit the
button he was prompt to re-login.
I want to show the use right when he come back he should see the logout
page.
how to re-direct the browser automatically to the loguout page when session
expired.
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188282
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: database query
Yea, that is what I did, but keep getting an error saying Join not supported Here is a copy of the error message I get: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Join expression not supported. The error occurred in D:\CFusionMX\wwwroot\Data\CV_ADMIN\pages\view.cfm: line 13 Maybe this is specific to Access? Ray At 12:35 PM 12/20/2004, you wrote: Select company_ID, company_name, contact_company_FK, contact_name From companies LEFT OUTER JOIN Contacts ON company_ID = contact_company_FK Or RIGHT -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:23 PM To: CF-Talk Subject: database query I have two tables in my DB: Companies: company_ID (PK) company_name etc Contacts: contact_company_FK (FK linked to company_ID) contact_name etc What I need to do is query the DB and get all the companies and all the contacts associated with that company, even if there are no contacts for a particular company. I am passing in the #company_ID# to the page. I think what I am supposed to be doing is a LEFT JOIN, but I can't get the syntax to work correctly. Anybody got any ideas for this? I am using the evil MS Access DB and CFMX 6.1. Thanks! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question from a beginner on visible invisible divs
This is more of a general HTML/Dynamic HTML/javascript type question rather than CF, so there might be better forums for this question. There are proabaly several ways to do this but here is one. Give your div an id attribute with a unique name. Say div id=hike1 and also give it a style attribute. For simplicity I will show the style inline but as you probably know there are better ways to specify styles. div id=hike1 style=display:none On some clickable item have the attribute onclick=document.all.hike1.style.display='inline'; This will make the div contents appear. If you want the same clickable item to toggle the div visible and invisible then you will need to do a bit more javascript to check what the current value of document.all.hike1.style.display is and set the opposite. Of course you can mix this javascript stuff with CF code if required e.g. onclick=document.all.#current_hike#.style.display='#current_hike_display_mode#'; :-) Hope that helps (HTH) On Mon, 20 Dec 2004 09:11:38 -0800, John Munyan [EMAIL PROTECTED] wrote: Hi, I am hoping someone can point me to a tutorial or link(s) explaining how I might be able to created visible/invisible divs. My navigation system is made up a myriad of hikes broken down into categories. I would like to create functionality that presents the page collapsed showing the categories and if the user clicks the category expands the hikes in the category. Anyone know a good source of information on how this is done? Another example of what I am after is myyahoo where you can expand and minimize sections of content you have selected. Any advice appreciated Thanks, John ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Advertising Re: time to cluster, I thinkL
I've found that its worth it based on size and placement. I have the HoF site set to 760 wide content with the remainder as ads. These are seen by most without getting in the way of content. Thanks... I always wondered. I own a couple of hi traffic travel portals for our area and was hesitant to give advertising space up for something like that. e -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:18 PM To: CF-Talk Subject: RE: time to cluster, I thinkL With a lot of traffic (At least for my website), it practically pays for dedicated hosting. On a side note... I noticed you have google adwords. Has it been worth the real estate? ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: updating my date_added from a form fails
Why are you even updating it - if you're just setting it back to the same created date? Also, you can use oracles default sysdate right in your table definition so that you don't have to add a date at all - if you are really just tracking the added date and not the updated date. I'm updating it because initially, the 603 records (giving tree leaves) that I need are previously entered as blank. I then do an insert through an update. In this case though, they can change their leaf number, so I update the previous one to blank and update another to have the new date, so I'm basically carrying the info over to a different record.. So it's not the same date, but really overwriting the null value of the new record (wow lotsa quotes in this reply). And right, I should've used sysdate instead of now(), but I didn't think of it as I did the writing. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: time to cluster, I thinkL
Just my two cents.. We currently run couple of sites that do about.. constant 7Mbps on single CPU 3GB RAM CFMX Pro Server. The system crahses out at around 18-20Mbps (days after Thanksgiving) DB is on a seperate box and seperate nic.. When doing cost estimates keep in mind the cost for upgrades to the firewall.. .. just updated.. to Cisco Pix 100Mbps and RackSpace is charging extra $360.00 month.. (on top of $250 before) For dedicated hosting I higly recommend RackSpace.. nice tech support and good turnaround on updates and new installs. You can also look into moving images and static content off the system.. might free up some resources.. For going to load balancing there is no magic number.. I've seen some application run at 75Mbps through output.. (MOD Perl - Cache - SharedMem - Custom Compiled Apache at 2048 users) and seen others crash at 1mbps.. Clean up the code.. off put as much processing to the DB as you can.. use StoredProcs, Cfqueryparam.. use good coding practice.. etc.. etc.. -- Regards Farooq Emmet McGovern wrote: Thanks... I always wondered. I own a couple of hi traffic travel portals for our area and was hesitant to give advertising space up for something like that. e -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:18 PM To: CF-Talk Subject: RE: time to cluster, I thinkL With a lot of traffic (At least for my website), it practically pays for dedicated hosting. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Can cfmail scale?
Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of emails to be sent in a short period of time. This is not for spamming but to notify customers if the service they had subscribed to is being disrupted. They estimate the need to send up to 120K emails in 5-10 min. Can this be done with a CF only solution or another approach is needed. Thanks Victor ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can cfmail scale?
One of the big selling points of MX was the speedier email. I _believe_ the quote was 1 million emails an hour for CFMX Enterprise. On Mon, 20 Dec 2004 13:07:00 -0500, Victor Moore [EMAIL PROTECTED] wrote: Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of emails to be sent in a short period of time. This is not for spamming but to notify customers if the service they had subscribed to is being disrupted. They estimate the need to send up to 120K emails in 5-10 min. Can this be done with a CF only solution or another approach is needed. Thanks Victor ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188289 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: database query
Try: Select company_ID, company_name, contact_company_FK, contact_name From companies, Contacts Where company_ID(+) = contact_company_FK On Mon, 20 Dec 2004 12:37:24 -0500, Ray Champagne [EMAIL PROTECTED] wrote: Yea, that is what I did, but keep getting an error saying Join not supported Here is a copy of the error message I get: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Join expression not supported. The error occurred in D:\CFusionMX\wwwroot\Data\CV_ADMIN\pages\view.cfm: line 13 Maybe this is specific to Access? Ray At 12:35 PM 12/20/2004, you wrote: Select company_ID, company_name, contact_company_FK, contact_name From companies LEFT OUTER JOIN Contacts ON company_ID = contact_company_FK Or RIGHT -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:23 PM To: CF-Talk Subject: database query I have two tables in my DB: Companies: company_ID (PK) company_name etc Contacts: contact_company_FK (FK linked to company_ID) contact_name etc What I need to do is query the DB and get all the companies and all the contacts associated with that company, even if there are no contacts for a particular company. I am passing in the #company_ID# to the page. I think what I am supposed to be doing is a LEFT JOIN, but I can't get the syntax to work correctly. Anybody got any ideas for this? I am using the evil MS Access DB and CFMX 6.1. Thanks! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can cfmail scale?
Yes. No problem. However the bottleneck most likly won't be CFMX but your mail server. Make sure to check off.. Maintain connection to SMTP server -- Regards, Farooq Victor Moore wrote: Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of emails to be sent in a short period of time. This is not for spamming but to notify customers if the service they had subscribed to is being disrupted. They estimate the need to send up to 120K emails in 5-10 min. Can this be done with a CF only solution or another approach is needed. Thanks Victor ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can cfmail scale?
Correct, back before 6.1 shipped we clocked Enterprise at over 1,000,000 messages an hour on a dual-CPU box. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 1:16 PM To: CF-Talk Subject: Re: Can cfmail scale? One of the big selling points of MX was the speedier email. I _believe_ the quote was 1 million emails an hour for CFMX Enterprise. On Mon, 20 Dec 2004 13:07:00 -0500, Victor Moore [EMAIL PROTECTED] wrote: Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of emails to be sent in a short period of time. This is not for spamming but to notify customers if the service they had subscribed to is being disrupted. They estimate the need to send up to 120K emails in 5-10 min. Can this be done with a CF only solution or another approach is needed. Thanks Victor ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: database query
Yea, it doesn't like that either. From my Googling, I have found that Access doesn't like the join clause syntax (duh) but I have yet to find the solution. Ray At 01:16 PM 12/20/2004, you wrote: Try: Select company_ID, company_name, contact_company_FK, contact_name From companies, Contacts Where company_ID(+) = contact_company_FK On Mon, 20 Dec 2004 12:37:24 -0500, Ray Champagne [EMAIL PROTECTED] wrote: Yea, that is what I did, but keep getting an error saying Join not supported Here is a copy of the error message I get: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Join expression not supported. The error occurred in D:\CFusionMX\wwwroot\Data\CV_ADMIN\pages\view.cfm: line 13 Maybe this is specific to Access? Ray At 12:35 PM 12/20/2004, you wrote: Select company_ID, company_name, contact_company_FK, contact_name From companies LEFT OUTER JOIN Contacts ON company_ID = contact_company_FK Or RIGHT -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:23 PM To: CF-Talk Subject: database query I have two tables in my DB: Companies: company_ID (PK) company_name etc Contacts: contact_company_FK (FK linked to company_ID) contact_name etc What I need to do is query the DB and get all the companies and all the contacts associated with that company, even if there are no contacts for a particular company. I am passing in the #company_ID# to the page. I think what I am supposed to be doing is a LEFT JOIN, but I can't get the syntax to work correctly. Anybody got any ideas for this? I am using the evil MS Access DB and CFMX 6.1. Thanks! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can cfmail scale?
I have read the article and that's the reason I thought that CFMX might work. Can multiple email servers be specified or just the one (and backup) in CFadmin? What will be a decent hardware platform to support this? Are there any white papers on this? Thanks Victor On Mon, 20 Dec 2004 13:18:33 -0500, Umer Farooq [EMAIL PROTECTED] wrote: Yes. No problem. However the bottleneck most likly won't be CFMX but your mail server. Make sure to check off.. Maintain connection to SMTP server -- Regards, Farooq Victor Moore wrote: Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of emails to be sent in a short period of time. This is not for spamming but to notify customers if the service they had subscribed to is being disrupted. They estimate the need to send up to 120K emails in 5-10 min. Can this be done with a CF only solution or another approach is needed. Thanks Victor ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: database query
From my Googling, I have found that Access doesn't like the join clause syntax (duh) but I have yet to find the solution. I don't work with Access much, but I'm pretty sure it does in fact support explicit JOIN syntax. I would recommend that you try creating the query within Access' own query builder, then either running that query using CFSTOREDPROC or CFQUERY or copying the SQL into your CFQUERY tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188295 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can cfmail scale?
Victor, no, not multiple. Backup (failover) servers may be specified. The key to successfully sending a large volume of mail is to allocate enough mail processing threads, make sure the mail server can handle concurrent logins and all those threads, and keep SMTP connections open. -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 1:30 PM To: CF-Talk Subject: Re: Can cfmail scale? I have read the article and that's the reason I thought that CFMX might work. Can multiple email servers be specified or just the one (and backup) in CFadmin? What will be a decent hardware platform to support this? Are there any white papers on this? Thanks Victor On Mon, 20 Dec 2004 13:18:33 -0500, Umer Farooq [EMAIL PROTECTED] wrote: Yes. No problem. However the bottleneck most likly won't be CFMX but your mail server. Make sure to check off.. Maintain connection to SMTP server -- Regards, Farooq Victor Moore wrote: Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of emails to be sent in a short period of time. This is not for spamming but to notify customers if the service they had subscribed to is being disrupted. They estimate the need to send up to 120K emails in 5-10 min. Can this be done with a CF only solution or another approach is needed. Thanks Victor ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188296 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model
Well, your problems are manyfold. Firstly, you're depending on behaviour that was never mandated in the specs, that being that a height of 100% means 100% of the available window area or available area. I don't think he's depending on this behavior. He's lamenting the fact that CSS doesn't support a mechanism for sizing elements relative to the available space. In HTML all heights and widths are based on the available area, not the size of the containing block. I also think he's hoping that someone will prove him wrong. :) The specs, for better or for worse, don't recogise this usage because it's meaningless in the broader context of positioning, which is that positioning is done on the basis of the total rendering area of the page, not just the current viewport. I don't think it's positioning we're discussing here: it's sizing. If all your elements are positioned relative to one another, there's no reason you can't support sizing based on available heights and widths (as was the case in HTML). Once you add absolute positioning to the mix, it gets a bit trickier. You'll get this behaviour *without* the doctype because that's how it was treated by browsers in the past. This is quirks mode, and there be funkiness. I think Isaac's aware of this. If IE wasn't so braindead, it'd support fixed positioning. In this case, you could position your elements wherever you liked relative to the four sides of the screen. This is possible in Firefox, but not in IE, because MS have slowly let IE die. Fixed positioning is possible in Internet Explorer. It is even possible in versions of Internet Explorer which pre-date the Mozilla project. Again, this is not about positioning, it's about sizing elements. Also, Microsoft has not let Internet Explorer die. They are going to tie Internet Explorer upgrades to new releases of the operating system. Personally, I wish they hadn't made this decision, but that's their currently announced intention. Your problem isn't with the spec--and definitely not with the box model, which doesn't even come up here--but with a lack of implementation of the spec. I think you've misunderstood the nature of the problem. It is most definitely an issue with the spec. Whether or not you consider it to be a fault of the spec (I do), is up for debate. Here's a few links on the subject: http://www.quirksmode.org/css/100percheight.html http://www.webmasterworld.com/forum83/200.htm However, none of the solutions mentioned in these articles completely solves Isaac's problem. In fact, Isaac only got as far as he did because he mixed html table tags with divs. Isaac, I've included some code below which seems to solve at least part of the problem I think you were running into. I've added height and widths to the html and body elements (I think you were already doing this). I've also added them to each element all the way down. The theory is that if you don't specify either height or width on one element, that element will default to auto. Auto translates to the size of the content. Since this can't be calculated until after the element is rendered, any element within it can't use relative sizes. However, I was unable to eliminate the vertical scroll bar. I'm not even quite sure where this is coming from. My guess is it's the window chrome. Perhaps you could set the height of the body tag onload with JavaScript? Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; html style=height: 100%; width: 100%; head title/title /head body style=height: 100%; width: 100%; margin: 0px; div style=height:100%; padding-bottom: 100px; table border=1 cellpadding=0 cellspacing=3 style=width:100%; height:100%; tr style=height:40px; width: 100%; td id=doc_title colspan=2 style=height:40px;onTap Framework/td /tr tr style=height:20px; width: 100%; td id=doc_ladder colspan=2 style=height:20px;Home/td /tr tr td colspan=2 style=height:80%; width: 100%; div style=height:100%; width:100%; table border=0 cellpadding=0 cellspacing=0 style=height:100%; width: 100%; tr td style=padding: 2px; height:100%; width: 250px; iframe name=nav_frame_menu frameborder=1 height=100% width=250/iframe /td td style=padding: 2px;
RE: database query
Hey everyone: Thanks for the pointers and tips. I found the problem. It was painfully simple. I needed to specify which table I wanted to pull the fields from. I still have to get the select all out of there and only pull what I need, but here is the working query statement: cfquery name=q_get_company_n_contacts datasource=#datasource# dbtype=odbc SELECT * FROM companies LEFT OUTER JOIN contacts ON companies.company_ID = contacts.contact_company_FK WHERE companies.company_ID = cfqueryparam cfsqltype=cf_sql_integer value=#company_ID# /cfquery Thanks! Ray At 01:40 PM 12/20/2004, you wrote: From my Googling, I have found that Access doesn't like the join clause syntax (duh) but I have yet to find the solution. I don't work with Access much, but I'm pretty sure it does in fact support explicit JOIN syntax. I would recommend that you try creating the query within Access' own query builder, then either running that query using CFSTOREDPROC or CFQUERY or copying the SQL into your CFQUERY tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can cfmail scale?
No.. just single and the backup(enterprise only) Whitepaper on the performance.. the hardware used in it.. from todays.. standard is nothing.. my desktop is 3x better :-).. but gives you an idea.. of the power.. http://www.macromedia.com/software/coldfusion/whitepapers/pdf/6_1/cfmx61_performancebrief.pdf -- Regards, Farooq Victor Moore wrote: I have read the article and that's the reason I thought that CFMX might work. Can multiple email servers be specified or just the one (and backup) in CFadmin? What will be a decent hardware platform to support this? Are there any white papers on this? Thanks Victor On Mon, 20 Dec 2004 13:18:33 -0500, Umer Farooq [EMAIL PROTECTED] wrote: Yes. No problem. However the bottleneck most likly won't be CFMX but your mail server. Make sure to check off.. Maintain connection to SMTP server -- Regards, Farooq Victor Moore wrote: Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of emails to be sent in a short period of time. This is not for spamming but to notify customers if the service they had subscribed to is being disrupted. They estimate the need to send up to 120K emails in 5-10 min. Can this be done with a CF only solution or another approach is needed. Thanks Victor ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
help! cfobject and abcpdf
hi all - newbie in desperate need of step-bystep instructions on how to install/register the abcpdf object and how to call it with cfobject using CF5 on windows 2k. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: database query
Hah... I was just about to post that you need a where clause. I've been messing with it for the last half hour! I need to ban list reading during work hours. I want my 1/2 hour back! -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 1:38 PM To: CF-Talk Subject: RE: database query Hey everyone: Thanks for the pointers and tips. I found the problem. It was painfully simple. I needed to specify which table I wanted to pull the fields from. I still have to get the select all out of there and only pull what I need, but here is the working query statement: cfquery name=q_get_company_n_contacts datasource=#datasource# dbtype=odbc SELECT * FROM companies LEFT OUTER JOIN contacts ON companies.company_ID = contacts.contact_company_FK WHERE companies.company_ID = cfqueryparam cfsqltype=cf_sql_integer value=#company_ID# /cfquery Thanks! Ray At 01:40 PM 12/20/2004, you wrote: From my Googling, I have found that Access doesn't like the join clause syntax (duh) but I have yet to find the solution. I don't work with Access much, but I'm pretty sure it does in fact support explicit JOIN syntax. I would recommend that you try creating the query within Access' own query builder, then either running that query using CFSTOREDPROC or CFQUERY or copying the SQL into your CFQUERY tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Plum V1.0 Release Candidate is now available for download
Productivity Enhancement today released the Release Candidate of its new product, Plum, which combines a code generator with a comprehensive application framework and an effective rapid development methodology. Plum can build a complete website with full administrative control over a large relational database in a matter of minutes, and building custom business logic and workflows on top of the Plum Framework is simple and straightforward. You will need a new Beta License Key to run the Release Candidate. The instructions for requesting one appear when you launch Plum. Here is a more complete list of what Plum can do: http://www.productivityenhancement.com/plum/WhatPlumCanDo.cfm You can download the Plum Release Candidate here: http://www.productivityenhancement.com/plum/DownloadPlum.cfm Please use our support system for all your support needs: http://www.productivityenhancement.com/support Tell us what you like and don't like on the Plum Discussion List: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm We sincerely hope you like Plum! :) Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188302 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: database query
LOL...thanks for your efforts! Are u subscribed to the cf-community list? If not, and you're prone to getting distracted easily, I would not recommend it. I lose hours sometimes, then end up having to make the lost time up later in the day. People with ADD (I suspect I have it) should steer clear of lists like these! If you're ever in New Hampshire, I will buy you a beer for your efforts. :) Don't know why anyone would be here right now, though. It is like a blizzard outside my window! Thanks again! Ray At 01:47 PM 12/20/2004, you wrote: Hah... I was just about to post that you need a where clause. I've been messing with it for the last half hour! I need to ban list reading during work hours. I want my 1/2 hour back! -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 1:38 PM To: CF-Talk Subject: RE: database query Hey everyone: Thanks for the pointers and tips. I found the problem. It was painfully simple. I needed to specify which table I wanted to pull the fields from. I still have to get the select all out of there and only pull what I need, but here is the working query statement: cfquery name=q_get_company_n_contacts datasource=#datasource# dbtype=odbc SELECT * FROM companies LEFT OUTER JOIN contacts ON companies.company_ID = contacts.contact_company_FK WHERE companies.company_ID = cfqueryparam cfsqltype=cf_sql_integer value=#company_ID# /cfquery Thanks! Ray At 01:40 PM 12/20/2004, you wrote: From my Googling, I have found that Access doesn't like the join clause syntax (duh) but I have yet to find the solution. I don't work with Access much, but I'm pretty sure it does in fact support explicit JOIN syntax. I would recommend that you try creating the query within Access' own query builder, then either running that query using CFSTOREDPROC or CFQUERY or copying the SQL into your CFQUERY tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JS issue
Just curious, but don't you have to convert the form fields to date objects before they can be compared like that? Or are they in a format so they can be compared as strings? Yeah it was the missing return in the function call. I didnt want the onSubmit because this form had 2 submit buttons. I needed this to be a separate function, however that got it and I appreciate it! On Fri, 17 Dec 2004 15:54:57 -0500, Ray Champagne [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188304 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JS issue
Not sure but it works just like that, no converting needed. I was thinking that it would have to be date objects myself but hit that submit on accident and it worked so I havent fooled with it. The dates will be in a mm/dd/ or m/d/yy or m/d/yy or mm/dd/yy format, not sure if that helps or not. On Mon, 20 Dec 2004 14:02:17 -0400, Larry White [EMAIL PROTECTED] wrote: Just curious, but don't you have to convert the form fields to date objects before they can be compared like that? Or are they in a format so they can be compared as strings? Yeah it was the missing return in the function call. I didnt want the onSubmit because this form had 2 submit buttons. I needed this to be a separate function, however that got it and I appreciate it! On Fri, 17 Dec 2004 15:54:57 -0500, Ray Champagne [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188305 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfobject and abcpdf
hi all - please help a newbie. i've never registered a com object on my cf server and i don't know how to call it from the cfobject tag. i could really use some step-by-step instructions. thanks so much, eric ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JS issue
You may want to try comparing something like 9/10/04 and 11/10/04 and see if it works correctly. Datewise, of course Nov is after Sept, but alphabetically 9 would sort higher than 1. It may be by accident the two strings you submitted worked out OK, but not all of them will. Not sure but it works just like that, no converting needed. I was thinking that it would have to be date objects myself but hit that submit on accident and it worked so I havent fooled with it. The dates will be in a mm/dd/ or m/d/yy or m/d/yy or mm/dd/yy format, not sure if that helps or not. On Mon, 20 Dec 2004 14:02:17 -0400, Larry White [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfobject and abcpdf
i've never registered a com object on my cf server and i don't know how to call it from the cfobject tag. You register COM DLLs using regsvr32.exe, which you can call from the command line like so: regsvr32 mydll.dll As for the rest, the specifics will depend on the COM object in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188308 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Plum
If any of you had a problem with requesting a Beta License Key for the Plum Release Candidate, the problem has now been fixed (I forgot to add the new version to the Licensing Wizard). Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JS issue
Doh! good call! I added.. var sDate=new Date(document.siteReferrals.StartDate.value); var eDate=new Date(document.siteReferrals.EndDate.value); and then compared sDate to eDate and this fixed it.. Thanks a bunch! On Mon, 20 Dec 2004 14:21:58 -0400, Larry White [EMAIL PROTECTED] wrote: You may want to try comparing something like 9/10/04 and 11/10/04 and see if it works correctly. Datewise, of course Nov is after Sept, but alphabetically 9 would sort higher than 1. It may be by accident the two strings you submitted worked out OK, but not all of them will. Not sure but it works just like that, no converting needed. I was thinking that it would have to be date objects myself but hit that submit on accident and it worked so I havent fooled with it. The dates will be in a mm/dd/ or m/d/yy or m/d/yy or mm/dd/yy format, not sure if that helps or not. On Mon, 20 Dec 2004 14:02:17 -0400, Larry White [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to detect if a session has timed out?
It depends on how you are handling the logout. If on login you set Session.Userid, for example, to their true userid and on logout you set it to something like '9', that could flag the fact they have logged out but their session has not expired. Just closing the browser doesn't necessarily end the session. What is the difference between a session that no longer exists, and one that has timed out? Once the session times out, it will cease to exist. The JavaScript suggestion is very ingenious, but not server-side if that is what you need. At 12:01 PM 12/19/2004, you wrote: -- Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer AIM: Reboog711 | Phone: 1-203-379-0773 -- My Books: http://www.instantcoldfusion.com My Recording Studio: http://www.fcfstudios.com My Energetic Acoustic Rock Band: http://www.farcryfly.com -- When did Reality Become TV ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Datestamp
After switching a cold fusion application from an access database to mysql I have some strange problems that I am not 100% sure on. Image issues no thumbnails showing up I assume it's related to the original storage location of the images. However one issue I can't seem to correct and has me stumped there is a time/date stamp that is recorded anytime a bid for an item is submitted. In access this was working fine no issues and no problems what so ever. Under mysql this snip of code. TIME: #TimeFormat(now(), 'HH:MM:SS')#br DATE: #DateFormat(now(), 'MM/DD/')#br /em br br span style=size: 9px;Please do not respond to this email./span /span /cfmail cfset theTime = TimeFormat(now(), HH:MM:SS) cfset theDate = DateFormat(now(), MM/DD/) cfquery name=createItemNotes datasource=#DS# INSERT INTO tblItemNotes (itemID, itemStatusID, itemListPrice, locationID, itemNotes, agent, dateEntered, timeEntered) VALUES (#getItemDetail.itemID#, #getItemDetail.itemStatusID#, #getItemDetail.itemListPrice#, #getItemDetail.locationID#, 'OFFER SUBMITTEDbr BY: #form.OfferName#br CONTACT INFO: #form.offercontact#br AMOUNT: $#form.offeramount#', 'WEB USER', '#theDate#', '#theTime#') Now to test this problem I have submitted offers on items today and then run a report that checks for current open bids and the bids I placed today are coming up with a November 30th 2002 date stamp this has left me completely boggled and I don't understand what could be causing this issue. I have verified all time/dates on all servers that are used for this application/database are reporting correct time and date. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188312 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Datestamp
Use CFQUERYPARAM and your problems will vanish. MySQL is picky about using strings as date literals, so it's getting screwed up. CF formats the default MySQL date value (-00-00 00:00:00) as 11/30/02 for some reason. If you look in the DB, it'll be all zeros though. cheers, barneyb On Mon, 20 Dec 2004 12:44:37 -0700, Jason Smith [EMAIL PROTECTED] wrote: After switching a cold fusion application from an access database to mysql I have some strange problems that I am not 100% sure on. Image issues no thumbnails showing up I assume it's related to the original storage location of the images. However one issue I can't seem to correct and has me stumped there is a time/date stamp that is recorded anytime a bid for an item is submitted. In access this was working fine no issues and no problems what so ever. Under mysql this snip of code. TIME: #TimeFormat(now(), 'HH:MM:SS')#br DATE: #DateFormat(now(), 'MM/DD/')#br /em br br span style=size: 9px;Please do not respond to this email./span /span /cfmail cfset theTime = TimeFormat(now(), HH:MM:SS) cfset theDate = DateFormat(now(), MM/DD/) cfquery name=createItemNotes datasource=#DS# INSERT INTO tblItemNotes (itemID, itemStatusID, itemListPrice, locationID, itemNotes, agent, dateEntered, timeEntered) VALUES (#getItemDetail.itemID#, #getItemDetail.itemStatusID#, #getItemDetail.itemListPrice#, #getItemDetail.locationID#, 'OFFER SUBMITTEDbr BY: #form.OfferName#br CONTACT INFO: #form.offercontact#br AMOUNT: $#form.offeramount#', 'WEB USER', '#theDate#', '#theTime#') Now to test this problem I have submitted offers on items today and then run a report that checks for current open bids and the bids I placed today are coming up with a November 30th 2002 date stamp this has left me completely boggled and I don't understand what could be causing this issue. I have verified all time/dates on all servers that are used for this application/database are reporting correct time and date. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: database query
Ray, use the Access query builder wizard. Select your two tables. If the join line between them doesn't show up automatically, drag the field you want to join from one table to the other. Right click on the line and read the join options. One of the three should be the join you're looking for. - Original Message - From: Ray Champagne [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, December 20, 2004 12:21 PM Subject: Re: database query Yea, it doesn't like that either. From my Googling, I have found that Access doesn't like the join clause syntax (duh) but I have yet to find the solution. Ray At 01:16 PM 12/20/2004, you wrote: Try: Select company_ID, company_name, contact_company_FK, contact_name From companies, Contacts Where company_ID(+) = contact_company_FK On Mon, 20 Dec 2004 12:37:24 -0500, Ray Champagne [EMAIL PROTECTED] wrote: Yea, that is what I did, but keep getting an error saying Join not supported Here is a copy of the error message I get: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Join expression not supported. The error occurred in D:\CFusionMX\wwwroot\Data\CV_ADMIN\pages\view.cfm: line 13 Maybe this is specific to Access? Ray At 12:35 PM 12/20/2004, you wrote: Select company_ID, company_name, contact_company_FK, contact_name From companies LEFT OUTER JOIN Contacts ON company_ID = contact_company_FK Or RIGHT -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:23 PM To: CF-Talk Subject: database query I have two tables in my DB: Companies: company_ID (PK) company_name etc Contacts: contact_company_FK (FK linked to company_ID) contact_name etc What I need to do is query the DB and get all the companies and all the contacts associated with that company, even if there are no contacts for a particular company. I am passing in the #company_ID# to the page. I think what I am supposed to be doing is a LEFT JOIN, but I can't get the syntax to work correctly. Anybody got any ideas for this? I am using the evil MS Access DB and CFMX 6.1. Thanks! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188314 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
AW: AW: IgniteFusion anyone?
Beta will be out in January, and we already use it in a production environment... Cheers Gert -Ursprüngliche Nachricht- Von: Ryan Jones [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 17. Dezember 2004 08:50 An: CF-Talk Betreff: Re: AW: IgniteFusion anyone? Gert, is Railo ready for a production environment? I understood it was still in Alpha. Am I mistaken? But you remember them ... -Ursprüngliche Nachricht- Von: Eric Hoffman [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 16. Dezember 2004 18:17 An: CF-Talk Betreff: RE: IgniteFusion anyone? I am disturbed by the burning tennis ball chickens. -Original Message- From: Gert Franz [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 7:05 AM To: CF-Talk Subject: AW: IgniteFusion anyone? Why don't you give Railo a chance. www.railo.ch Cheers Gert ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion security framework
On 12/20/04 4:17 PM, Jim Davis wrote: Is that what you're looking for? Yes, thanks for the hint! Your security framework is probably very good, but a bit too complex for my needs, I am trying to come up with an easier one for my requirements... Thanks. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Major PHP flaw??
Hey All, I just had this sent to me from a local ISP, but without any specificsanybody know anything? I must say it's nice to see that it's no effecting Windows Servers for a change ;-) ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Major PHP flaw??
and the line monster ate ithere we go for try # 2: Security Notice: There has been an anouncement of a serious security problem with all current versions of PHP, a scripting language that you may be using on your site. PHP is used for many free forum, message board and link management scripts. A security flaw in PHP can allow the whole server to be compromised by hackers who can then damage or deface all the sites on that server. This flaw is already being exploited, so time is of the escence in fixing this. This is an unacceptable security risk to WeDoHosting.com Customers. If you are hosting your service on our Windows servers, you may ignore this notice since this is not applicable to Windows servers. If you are not using PHP on your website, then you may ignore this notice as well. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, December 20, 2004 12:43 PM Subject: Major PHP flaw?? Hey All, I just had this sent to me from a local ISP, but without any specificsanybody know anything? I must say it's nice to see that it's no effecting Windows Servers for a change ;-) ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188318 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion built-in tags and permission-based security framework
Hi all,
I need to implement a new security framework for my ColdFusion
applications (CMS, etc.).
I used a role-based security model in the past and I found it too
strict, that's why I would like to implement a permission-based security
framework now.
Check out the following article about the benefits of a permission-based
security model over role-based one:
Rethinking Roles-based Security
http://www.halhelms.com/index.cfm?fuseaction=newsletters.showissue=052203_rolesBasedSecurity
I came up with the following database schema (Oracle), that should be
sufficient to implement a permission-based security model, like the one
outlined in the above article:
CREATE TABLE Person (
PersonIDINTEGER NOT NULL,
FirstName VARCHAR2(40) NOT NULL,
LastNameVARCHAR2(40) NOT NULL,
PRIMARY KEY (PersonID)
);
CREATE TABLE Group (
GroupID INTEGER NOT NULL,
GroupName VARCHAR2(20) NOT NULL,
GroupDescriptionVARCHAR2(40) NOT NULL,
PRIMARY KEY (GroupID)
);
CREATE TABLE Person_Group (
PersonIDINTEGER NOT NULL,
GroupID INTEGER NOT NULL,
FOREIGN KEY (GroupID) REFERENCES Group,
FOREIGN KEY (PersonID) REFERENCES Person
);
CREATE TABLE Permission (
PermissionIDINTEGER NOT NULL,
PermissionName VARCHAR2(20) NOT NULL,
PermissionDescription VARCHAR2(40) NOT NULL,
PRIMARY KEY (PermissionID)
);
CREATE TABLE Group_Permission (
GroupID INTEGER NOT NULL,
PermissionIDINTEGER NOT NULL,
FOREIGN KEY (PermissionID) REFERENCES Permission,
FOREIGN KEY (GroupID) REFERENCES Group
);
Let me make a quick example of how this database schema is supposed to work:
- My sample person is a member of the 'Admin' Group;
- The admin Group has several Permissions: 'addUser', 'modifyUser',
'removeUser', 'addDocument', 'modifyDocument', 'deleteDocument', etc.;
- The sample person will be able to access all the features that require
any of the Permissions above: add, modify and delete users and documents;
Now I have to start coding the CFML files and I am not sure if I should
use the ColdFusion built-in security tags and functions: cflogin,
cfloginuser, IsUserInRole, etc.
If I got it right, what is called a 'role' in the ColdFusion built-in
tags and functions is a 'Permission' in my database schema.
So when my sample user logs into the system, I should have the following
code (of course the username/password and roles assignation will be
dynamic in the production code):
cfloginuser name=myuser password=mypasswd
roles=addUser,modifyUser,removeUser,addDocument,
modifyDocument,deleteDocument
And I should use the following code to check if the user is authorized
to add a document:
cfif IsUserInRole(addDocument)
*authorized*
cfelse
*not autorized*
/cfif
If this is the correct use of the tags and functions, I am a bit worried
about the ColdFusion built-in security framework scalability.
Will it still work fine if I add a lot (e.g. 50-100) 'roles'
('Permissions' according to my db schema) to each user using the
cfloginuser tag? Any slowdown or memory problem on the server?
Do you think I should use custom UDFs or CFCs instead?
Also, I'd like to hear any suggestion or criticism about the security
framework I want to implement ... I am sure I am missing something. :-)
Thanks a lot.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188319
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
