RE: Complex Database System
Uh yehI'm in the middle of one! I am storing complex structures of user data in SQL tables and pulling them into CF as Structures. About 5 databases. One holds a table containing 1/2 million recs and another holds user data which we expect could be around 3 million users after 3 yearsso the database has been built to cope. I may utilise WDDX by the time I've finished too although not sure if I need to as yet. What do you wanna know? A -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: 11 January 2001 15:11 To: CF-Talk Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Complex Database System
I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. Any e-commerce site using ColdFusion is using complex data types. Also, how do you know other types of CF sites arn't using complex data types? --=@ greg @=-- - Original Message - From: "Foggy, Doreen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 10:11 AM Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex Database System
Let me see if I can help clarifyyou're asking if CF can be used as the front end for a complex database? The answer is...OF COURSE! And it will do it in a much more maintainable way than ASP will. If the database is properly designed, it doesn't matter what front end you put on it. If the database is poorly designed, it won't matter what front end you put on it. CF and ASP don't have any significant differences as far as functionality goes. They have a great deal of difference as far as speed of development and ease of maintainance goes. CF wins both hands down. Brian -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:11 AM To: CF-Talk Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex Database System
I am not criticizing any ColdFusion sites. I am only looking to obtain information from the forum concerning the use of ColdFusion as an application and how it compares to ASP with a backend database (SQL SERVER 7.0). I am on a deadline and I need to make a presentation soon. I am gather information...Please let me know the pro's and con's of using ColdFusion. Thank You in advance for you help -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:26 AM To: CF-Talk Subject: Re: Complex Database System I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. Any e-commerce site using ColdFusion is using complex data types. Also, how do you know other types of CF sites arn't using complex data types? --=@ greg @=-- - Original Message - From: "Foggy, Doreen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 10:11 AM Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex Database System
Thanks Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:45 AM To: CF-Talk Subject: RE: Complex Database System Let me see if I can help clarifyyou're asking if CF can be used as the front end for a complex database? The answer is...OF COURSE! And it will do it in a much more maintainable way than ASP will. If the database is properly designed, it doesn't matter what front end you put on it. If the database is poorly designed, it won't matter what front end you put on it. CF and ASP don't have any significant differences as far as functionality goes. They have a great deal of difference as far as speed of development and ease of maintainance goes. CF wins both hands down. Brian -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:11 AM To: CF-Talk Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex Database System
Talk to webserve @ LMCO EIS in Orlando, they have projects that are written in CF. -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 1:28 PM To: CF-Talk Subject: RE: Complex Database System Thanks Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:45 AM To: CF-Talk Subject: RE: Complex Database System Let me see if I can help clarifyyou're asking if CF can be used as the front end for a complex database? The answer is...OF COURSE! And it will do it in a much more maintainable way than ASP will. If the database is properly designed, it doesn't matter what front end you put on it. If the database is poorly designed, it won't matter what front end you put on it. CF and ASP don't have any significant differences as far as functionality goes. They have a great deal of difference as far as speed of development and ease of maintainance goes. CF wins both hands down. Brian -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:11 AM To: CF-Talk Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex Database System
Here are some reviews of a few relative technologies: http://www.zdnet.com/enterprise/stories/linux/0,12249,2646052,00.html http://www.zdnet.com/eweek/stories/general/0,11011,2646051,00.html Here are a few product comparisons between ColdFusion and ASP. Keep in mind that they are both biased towards ColdFusion. Ironically, the latter was written by a developer who now codes in Zope. http://www.houseoffusion.com/hof/body/asp.cfm http://www.swynk.com/friends/murphy/ironic_isnt_it.asp Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:11 AM To: CF-Talk Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Complex Database System
I have developed extensive CF applications using SQL Server 6.5 and 7 as the back ends. E-commerce, etc. with very complex databases. CF can certainly handle the job. As can ASP. If don't know either of them, IMHO CF is the easier of the 2 to learn. I think a definition of "complex database system" would be useful. There is no way to tell just by looking at the resulting HTML generated by an application, how complex its backend might be. DC - Original Message - From: "Foggy, Doreen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 13:33 Subject: RE: Complex Database System I may have questions later but for now I will do some research on WDDX...thank you. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:20 AM To: CF-Talk Subject: RE: Complex Database System Uh yehI'm in the middle of one! I am storing complex structures of user data in SQL tables and pulling them into CF as Structures. About 5 databases. One holds a table containing 1/2 million recs and another holds user data which we expect could be around 3 million users after 3 yearsso the database has been built to cope. I may utilise WDDX by the time I've finished too although not sure if I need to as yet. What do you wanna know? A -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: 11 January 2001 15:11 To: CF-Talk Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Complex Database System
I am not criticizing any ColdFusion sites. I'm sorry, I didn't mean for you to interpret my e-mail as being disgruntled at your post. I was just wondering what lead you to believe that sites weren't using complex data types. The fact is that ColdFusion actually makes storing complex data types to a database (e.g. for shopping carts or whatever) easier than ASP and JSP. I think CF does a great job with complex data types. --=@ greg @=-- - Original Message - From: "Foggy, Doreen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 1:23 PM Subject: RE: Complex Database System I am not criticizing any ColdFusion sites. I am only looking to obtain information from the forum concerning the use of ColdFusion as an application and how it compares to ASP with a backend database (SQL SERVER 7.0). I am on a deadline and I need to make a presentation soon. I am gather information...Please let me know the pro's and con's of using ColdFusion. Thank You in advance for you help -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:26 AM To: CF-Talk Subject: Re: Complex Database System I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. Any e-commerce site using ColdFusion is using complex data types. Also, how do you know other types of CF sites arn't using complex data types? --=@ greg @=-- - Original Message - From: "Foggy, Doreen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 10:11 AM Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Complex Database System
Nope ... no complex db backends anywhere using ColdFusion .. only the great and Powerful ASP can handle that kinda "hard CORE" stuff. :-) Uhhh... kidding of course. How do YOU or better yet, your UPPER mgmnt, define a complex data structure? talk to the folks over at : www.figleaf.com www.granularity.com ( I know that these guys just did a very big/complex CF project for an Int'l co on par w/ Lockheed/Martin) www.gtriad.com HTH, Steve - Original Message - From: "Foggy, Doreen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 10:11 AM Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Complex Database System
And in the end, it shouldn't matter how simple or complex the database model is... if the database is built right, and you build your queries right, CF (or most anything that can tap into a DB) can handle it... - Original Message - From: "Stephen M. Aylor" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 12:44 PM Subject: Re: Complex Database System Nope ... no complex db backends anywhere using ColdFusion .. only the great and Powerful ASP can handle that kinda "hard CORE" stuff. :-) Uhhh... kidding of course. How do YOU or better yet, your UPPER mgmnt, define a complex data structure? talk to the folks over at : www.figleaf.com www.granularity.com ( I know that these guys just did a very big/complex CF project for an Int'l co on par w/ Lockheed/Martin) www.gtriad.com HTH, Steve - Original Message - From: "Foggy, Doreen" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 10:11 AM Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists