Re: Appending Data into a Table from Another Table in MySQL
INSERT INTO maintable (col1, col2, ..., colN) SELECT col1, col2, ..., colN FROM table2 Azadi On 23/04/2011 11:51 , Scott Williams wrote: Hello geniuses! I've been largely successful exporting my Access database into MySQL, but have one problem. The SQL dump file for one of my tables is just a smidge too large to import (the host limits the size to 2048, and my sql file is 2137). Anyway, I just broke the table into two, Table1 and Table2. I intended to just just append Table 2 onto Table1, but now that I'm trying to do it, I realize that I don't know how. Any suggestions? Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problem Using QueryNew
My first time using created queries, I can't understand why this is putting the same value on every row. cfset stock = QueryNew(StockTitle, Varchar) cfoutput cfloop from=1 to=#stockTable.recordcount# index=R cfset newrow = QueryAddRow(stock,1) cfset temp = QuerySetCell(Stock, stockTitle, #stockTable.stockTitle#, R) /cfloop /cfoutput cfoutput query=stock #stock.stockTitle#br / /cfoutput No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3591 - Release Date: 04/23/11 07:36:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
You are using a simple cfloop from to, instead of a cfquery or a cfloop query. Because of this, when you call #stockTable.stockTitle#, it defaults to the first line of the query. Either change your loop to a cfloop query=stockTable Or change your data call to #stockTable.stockTitle[R]# William -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Saturday, April 23, 2011 9:45 AM To: cf-talk Subject: Problem Using QueryNew My first time using created queries, I can't understand why this is putting the same value on every row. cfset stock = QueryNew(StockTitle, Varchar) cfoutput cfloop from=1 to=#stockTable.recordcount# index=R cfset newrow = QueryAddRow(stock,1) cfset temp = QuerySetCell(Stock, stockTitle, #stockTable.stockTitle#, R) /cfloop /cfoutput cfoutput query=stock #stock.stockTitle#br / /cfoutput No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3591 - Release Date: 04/23/11 07:36:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
IIS Question
Hi All - I have a IIS/coldfusion question. I am working with a client, who has both production and development stuff on the same machine. He has two drives, C and E. C drive has development files and E drive has production. The IIS configuration points to E drive. C drive the has the following structure: C:/ - Coldfusion 9 - Inetpub - coldfusion files E:/ - Web - coldfusion files But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question Thanks a lot. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
IIS Question
Hi All - I have a IIS/coldfusion question. I am working with a client, who has both production and development stuff on the same machine. He has two drives, C and E. C drive has development files and E drive has production. The IIS configuration points to E drive. C drive the has the following structure: C:/ - Coldfusion 9 - Inetpub - coldfusion files E:/ - Web - coldfusion files But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question Thanks a lot. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
You'd likely want to defined two iis sites, one for dev and one for prod. For each site, the home directory should be the respective code base for each, and you'd want to add a virtual directory pointing to cfide on each. The differing drives should be no problem. Hope that helps! Charlie On Apr 23, 2011, at 1:15 PM, fun and learning funandlrnn...@gmail.com wrote: Hi All - I have a IIS/coldfusion question. I am working with a client, who has both production and development stuff on the same machine. He has two drives, C and E. C drive has development files and E drive has production. The IIS configuration points to E drive. C drive the has the following structure: C:/ - Coldfusion 9 - Inetpub - coldfusion files E:/ - Web - coldfusion files But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question Thanks a lot. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
Right click the web site in IIS and click on click on the home directory path. This will tell you where IIS is looking on a per site basis. Hope this helps. Thanks, Brian On Apr 23, 2011, at 1:15 PM, fun and learning funandlrnn...@gmail.com wrote: Hi All - I have a IIS/coldfusion question. I am working with a client, who has both production and development stuff on the same machine. He has two drives, C and E. C drive has development files and E drive has production. The IIS configuration points to E drive. C drive the has the following structure: C:/ - Coldfusion 9 - Inetpub - coldfusion files E:/ - Web - coldfusion files But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question Thanks a lot. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question A single IIS server can have many IIS sites, or virtual servers. These can point to wherever you want them to point. Presumably, this machine has at least two IIS sites. You can view the list of sites in the IIS management console, and can right-click on each as Brian mentioned to see the filesystem location where each points. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Appending Data into a Table from Another Table in MySQL
That did it. Thanks Azadi! Scott From: Azadi Saryev azadi.sar...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, April 23, 2011 2:41 AM Subject: Re: Appending Data into a Table from Another Table in MySQL INSERT INTO maintable (col1, col2, ..., colN) SELECT col1, col2, ..., colN FROM table2 Azadi On 23/04/2011 11:51 , Scott Williams wrote: Hello geniuses! I've been largely successful exporting my Access database into MySQL, but have one problem. The SQL dump file for one of my tables is just a smidge too large to import (the host limits the size to 2048, and my sql file is 2137). Anyway, I just broke the table into two, Table1 and Table2. I intended to just just append Table 2 onto Table1, but now that I'm trying to do it, I realize that I don't know how. Any suggestions? Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
as you are running both development and production on the same server I would also suggest you take measures to isolate them as this is a very bad setup you have as your untested development code could take down CF and thus the live site. I suggest you run CF multi in server mode and run 2 instances, 1 for live and one for dev. You should run every site on its own application pool to avoid any iis issues. If you have no idea what any of that means, then you really shouldn't be trying to manage a production web server for your client, so you should speak with your host about management services or at least a hosting control panel that will do it for you. For windows I recommend Website Panel. On Sat, Apr 23, 2011 at 8:06 PM, Dave Watts dwa...@figleaf.com wrote: But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question A single IIS server can have many IIS sites, or virtual servers. These can point to wherever you want them to point. Presumably, this machine has at least two IIS sites. You can view the list of sites in the IIS management console, and can right-click on each as Brian mentioned to see the filesystem location where each points. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
Many thanks, Will. Obvious now I look at it again, duh me. Anyhoo, I had this (probably dumb) idea of combining sever fulltext search query results into one table, turning into a lot more work than I expected (+ learning curve). Maybe there is a better way of going about this:- Scenario - Cart Structure Main Categories - Sub Categories = Products = Product Options I want to search in fields from two tables at a time. So it will output two groupings :- 1. List of product/options 2. Categories (main and sub) Currently, I've added all four tables to the FULLTEXT catalog. I'm running 4 queries on that from CF, each one looks like this: cfquery datasource=#application.dsn# name=stockTable SELECT TOP 100 PERCENT Search_Table.RANK, dbo.list_stock_shop.catMainID, dbo.list_stock_shop.catmainDisplay, dbo.list_stock_shop.openClosed, dbo.list_stock_shop.catMainDescr, dbo.list_stock_shop.catMainFullDescr, dbo.list_stock_shop.catMainPhoto, dbo.list_stock_shop.catSubID, dbo.list_stock_shop.catSubDisplay, dbo.list_stock_shop.grid, dbo.list_stock_shop.catSubDescr, dbo.list_stock_shop.catSubFullDescr, dbo.list_stock_shop.catSubPhoto, dbo.list_stock_shop.stockID, dbo.list_stock_shop.created, dbo.list_stock_shop.stockDisplay, dbo.list_stock_shop.stockTitle, dbo.list_stock_shop.taxRate, dbo.list_stock_shop.stockDescr, dbo.list_stock_shop.stockDescrShort, dbo.list_stock_shop.taxExempt, dbo.list_stock_shop.delivery, dbo.list_stock_shop.navAdmin, dbo.list_stock_shop.stockItemID, dbo.list_stock_shop.stockItemDisplay, dbo.list_stock_shop.cost, dbo.list_stock_shop.price, dbo.list_stock_shop.salePrice, dbo.list_stock_shop.itemTitle, dbo.list_stock_shop.itemDescr, dbo.list_stock_shop.stockItemPhoto, dbo.list_stock_shop.inStock, dbo.list_stock_shop.onOrder, dbo.list_stock_shop.allocated, dbo.list_stock_shop.soldQuan, dbo.list_stock_shop.minQuan, dbo.list_stock_shop.maxQuan, dbo.list_stock_shop.reorderQuan, dbo.list_stock_shop.saleFrom, dbo.list_stock_shop.saleTo, dbo.list_stock_shop.projected FROM FREETEXTTABLE(tbl_stock, *, '#myCleanSearch#', 1000) Search_Table INNER JOIN dbo.list_stock_shop ON Search_Table.[KEY] = dbo.list_stock_shop.stockID ORDER BY Search_Table.RANK DESC /cfquery Ignore the o/d on the field list, I'll cut to minimum when I'm done. My solution as it is will work, but it feels very ugly and process heavy. What I wonder is, can the search be run on more than one table into the catalog at one time? Am I going about this the right way? Jenny -Original Message- From: William Seiter [mailto:will...@seiter.com] Sent: 23 April 2011 17:51 To: cf-talk Subject: RE: Problem Using QueryNew You are using a simple cfloop from to, instead of a cfquery or a cfloop query. Because of this, when you call #stockTable.stockTitle#, it defaults to the first line of the query. Either change your loop to a cfloop query=stockTable Or change your data call to #stockTable.stockTitle[R]# William -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Saturday, April 23, 2011 9:45 AM To: cf-talk Subject: Problem Using QueryNew My first time using created queries, I can't understand why this is putting the same value on every row. cfset stock = QueryNew(StockTitle, Varchar) cfoutput cfloop from=1 to=#stockTable.recordcount# index=R cfset newrow = QueryAddRow(stock,1) cfset temp = QuerySetCell(Stock, stockTitle, #stockTable.stockTitle#, R) /cfloop /cfoutput cfoutput query=stock #stock.stockTitle#br / /cfoutput No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3591 - Release Date: 04/23/11 07:36:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
Seems to me it would a lot more efficient to make a view in your database that only returns the two fields you want to search on plus any fields you need for search criteria. Or do a select with a join that returns the fields. Once you do that, they are already in a query, so you wouldn't need to make another query to hold them. On Sat, Apr 23, 2011 at 4:21 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Many thanks, Will. Obvious now I look at it again, duh me. Anyhoo, I had this (probably dumb) idea of combining sever fulltext search query results into one table, turning into a lot more work than I expected (+ learning curve). Maybe there is a better way of going about this: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS Question
Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and avoid the problem. The only issue then is the database, as you are unlikely to be running a server o/s on your pc, assuming the database requires a server o/s - I'm using MS SQL, for example. But yes, separate everything out. 2 web sites in IIS, 2 databases, 2 CF DB connections, etc with very clear and regulated naming conventions. Jenny Gavin-Wear Fast Track Online http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 23 April 2011 20:58 To: cf-talk Subject: Re: IIS Question as you are running both development and production on the same server I would also suggest you take measures to isolate them as this is a very bad setup you have as your untested development code could take down CF and thus the live site. I suggest you run CF multi in server mode and run 2 instances, 1 for live and one for dev. You should run every site on its own application pool to avoid any iis issues. If you have no idea what any of that means, then you really shouldn't be trying to manage a production web server for your client, so you should speak with your host about management services or at least a hosting control panel that will do it for you. For windows I recommend Website Panel. On Sat, Apr 23, 2011 at 8:06 PM, Dave Watts dwa...@figleaf.com wrote: But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question A single IIS server can have many IIS sites, or virtual servers. These can point to wherever you want them to point. Presumably, this machine has at least two IIS sites. You can view the list of sites in the IIS management console, and can right-click on each as Brian mentioned to see the filesystem location where each points. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
Jenny i'm not sure what evidence you have to quality that statement, but you couldn't be more wrong, bad code sure can take down a web server and even a database server, it happens every day. With 10+ years in the hosting business I personally see it happen all the time and consult with many customers to diagnose and fix the cause of the problem. On Sun, Apr 24, 2011 at 12:31 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and avoid the problem. The only issue then is the database, as you are unlikely to be running a server o/s on your pc, assuming the database requires a server o/s - I'm using MS SQL, for example. But yes, separate everything out. 2 web sites in IIS, 2 databases, 2 CF DB connections, etc with very clear and regulated naming conventions. Jenny Gavin-Wear Fast Track Online http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 23 April 2011 20:58 To: cf-talk Subject: Re: IIS Question as you are running both development and production on the same server I would also suggest you take measures to isolate them as this is a very bad setup you have as your untested development code could take down CF and thus the live site. I suggest you run CF multi in server mode and run 2 instances, 1 for live and one for dev. You should run every site on its own application pool to avoid any iis issues. If you have no idea what any of that means, then you really shouldn't be trying to manage a production web server for your client, so you should speak with your host about management services or at least a hosting control panel that will do it for you. For windows I recommend Website Panel. On Sat, Apr 23, 2011 at 8:06 PM, Dave Watts dwa...@figleaf.com wrote: But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question A single IIS server can have many IIS sites, or virtual servers. These can point to wherever you want them to point. Presumably, this machine has at least two IIS sites. You can view the list of sites in the IIS management console, and can right-click on each as Brian mentioned to see the filesystem location where each points. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
Hi Maureen, Many thanks for the reply. Taking the first two queries. In Product I search on title, short description and long description. In Product Options I search on the option title and description. I tried some tests joining the tables:- cfquery dbtype=query name=product select stockID from stockTable left outer join stockItemsTable ON stockItemsTable.stockID = stockTable.stockID /cfquery I assume I need to use a left outer join. Although the stocktable and stockitemstable individually returned results, I can't get the combined tables to produce anything. As I understand it FREETEXTTABLE can only search on one table at a time? I can't use a database view in the fulltext catalogue? If I can it answers all my problems. Jenny -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 00:26 To: cf-talk Subject: Re: Problem Using QueryNew Seems to me it would a lot more efficient to make a view in your database that only returns the two fields you want to search on plus any fields you need for search criteria. Or do a select with a join that returns the fields. Once you do that, they are already in a query, so you wouldn't need to make another query to hold them. On Sat, Apr 23, 2011 at 4:21 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Many thanks, Will. Obvious now I look at it again, duh me. Anyhoo, I had this (probably dumb) idea of combining sever fulltext search query results into one table, turning into a lot more work than I expected (+ learning curve). Maybe there is a better way of going about this: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS Question
Russ, I agree with you 100% but in Jenny's defense perhaps she meant this code rather than code in general. I have a few sites that are so simple I could see them in that light I suppose. Still as best practice I totally agree with you. In fact, such code is what keeps our business growing (ha). -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Saturday, April 23, 2011 6:43 PM To: cf-talk Subject: Re: IIS Question Jenny i'm not sure what evidence you have to quality that statement, but you couldn't be more wrong, bad code sure can take down a web server and even a database server, it happens every day. With 10+ years in the hosting business I personally see it happen all the time and consult with many customers to diagnose and fix the cause of the problem. On Sun, Apr 24, 2011 at 12:31 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and avoid the problem. The only issue then is the database, as you are unlikely to be running a server o/s on your pc, assuming the database requires a server o/s - I'm using MS SQL, for example. But yes, separate everything out. 2 web sites in IIS, 2 databases, 2 CF DB connections, etc with very clear and regulated naming conventions. Jenny Gavin-Wear Fast Track Online http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 23 April 2011 20:58 To: cf-talk Subject: Re: IIS Question as you are running both development and production on the same server I would also suggest you take measures to isolate them as this is a very bad setup you have as your untested development code could take down CF and thus the live site. I suggest you run CF multi in server mode and run 2 instances, 1 for live and one for dev. You should run every site on its own application pool to avoid any iis issues. If you have no idea what any of that means, then you really shouldn't be trying to manage a production web server for your client, so you should speak with your host about management services or at least a hosting control panel that will do it for you. For windows I recommend Website Panel. On Sat, Apr 23, 2011 at 8:06 PM, Dave Watts dwa...@figleaf.com wrote: But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question A single IIS server can have many IIS sites, or virtual servers. These can point to wherever you want them to point. Presumably, this machine has at least two IIS sites. You can view the list of sites in the IIS management console, and can right-click on each as Brian mentioned to see the filesystem location where each points. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS Question
The physical directory location is listed in the configuration. You can have multiple directories from multiple drives listed in a web site. When you point to a directory that is outside of the root, you are creating virtual directories (aka aliases in Apache), so yes, you can have files in multiple locations on multiple drives. -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Saturday, April 23, 2011 12:08 PM To: cf-talk Subject: IIS Question Hi All - I have a IIS/coldfusion question. I am working with a client, who has both production and development stuff on the same machine. He has two drives, C and E. C drive has development files and E drive has production. The IIS configuration points to E drive. C drive the has the following structure: C:/ - Coldfusion 9 - Inetpub - coldfusion files E:/ - Web - coldfusion files But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question Thanks a lot. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS Question
I have certainly done it before :-D -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Saturday, April 23, 2011 06:43 PM To: cf-talk Subject: Re: IIS Question Jenny i'm not sure what evidence you have to quality that statement, but you couldn't be more wrong, bad code sure can take down a web server and even a database server, it happens every day. With 10+ years in the hosting business I personally see it happen all the time and consult with many customers to diagnose and fix the cause of the problem. On Sun, Apr 24, 2011 at 12:31 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and avoid the problem. The only issue then is the database, as you are unlikely to be running a server o/s on your pc, assuming the database requires a server o/s - I'm using MS SQL, for example. But yes, separate everything out. 2 web sites in IIS, 2 databases, 2 CF DB connections, etc with very clear and regulated naming conventions. Jenny Gavin-Wear Fast Track Online http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 23 April 2011 20:58 To: cf-talk Subject: Re: IIS Question as you are running both development and production on the same server I would also suggest you take measures to isolate them as this is a very bad setup you have as your untested development code could take down CF and thus the live site. I suggest you run CF multi in server mode and run 2 instances, 1 for live and one for dev. You should run every site on its own application pool to avoid any iis issues. If you have no idea what any of that means, then you really shouldn't be trying to manage a production web server for your client, so you should speak with your host about management services or at least a hosting control panel that will do it for you. For windows I recommend Website Panel. On Sat, Apr 23, 2011 at 8:06 PM, Dave Watts dwa...@figleaf.com wrote: But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question A single IIS server can have many IIS sites, or virtual servers. These can point to wherever you want them to point. Presumably, this machine has at least two IIS sites. You can view the list of sites in the IIS management console, and can right-click on each as Brian mentioned to see the filesystem location where each points. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS Question
Hi Russ, With 30 years in the IT business and over 20 of them as an IT Manager I am fully aware of the implications of server vulnerability. A hosting environment is a very different scenario to a single developer using a single server for testing and live applications. Sure, in an ideal world we'd all love to run on dedicated and managed live servers well apart from our test environment. Having run with hosted, dedicated, managed servers for some years I have found their up-time is no better than I am able to achieve with my own local server which I manage. (For what it's worth I have the tested stats to prove that.) Unless a dedicated server can be assured in a hosting enviromnent you are sharing a server with god knows who. As you know as a Host, you can't vet the quality of the developers using your servers, or whoever else they might let tinker with their web sites. Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 00:43 To: cf-talk Subject: Re: IIS Question Jenny i'm not sure what evidence you have to quality that statement, but you couldn't be more wrong, bad code sure can take down a web server and even a database server, it happens every day. With 10+ years in the hosting business I personally see it happen all the time and consult with many customers to diagnose and fix the cause of the problem. On Sun, Apr 24, 2011 at 12:31 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and avoid the problem. The only issue then is the database, as you are unlikely to be running a server o/s on your pc, assuming the database requires a server o/s - I'm using MS SQL, for example. But yes, separate everything out. 2 web sites in IIS, 2 databases, 2 CF DB connections, etc with very clear and regulated naming conventions. Jenny Gavin-Wear Fast Track Online http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 23 April 2011 20:58 To: cf-talk Subject: Re: IIS Question as you are running both development and production on the same server I would also suggest you take measures to isolate them as this is a very bad setup you have as your untested development code could take down CF and thus the live site. I suggest you run CF multi in server mode and run 2 instances, 1 for live and one for dev. You should run every site on its own application pool to avoid any iis issues. If you have no idea what any of that means, then you really shouldn't be trying to manage a production web server for your client, so you should speak with your host about management services or at least a hosting control panel that will do it for you. For windows I recommend Website Panel. On Sat, Apr 23, 2011 at 8:06 PM, Dave Watts dwa...@figleaf.com wrote: But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question A single IIS server can have many IIS sites, or virtual servers. These can point to wherever you want them to point. Presumably, this machine has at least two IIS sites. You can view the list of sites in the IIS management console, and can right-click on each as Brian mentioned to see the filesystem location where each points. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS Question
@ the original poster who left no name. Don't forget to set up your virtual CFIDE directories for each site. Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3592 - Release Date: 04/23/11 07:36:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
I think what you want is an inner join. An inner join gives you ONLY the records in the Product Table that have matching ids in the Product Options table. An outer join will give you all the records in the Product Table but only those in Product Options that with matching ids. So if your tables look like this: Product ___ id type 1 boat 2 ship 3 plane 4 car 5 truck Product Option option_id option_product_id option 12 cargo 22 container 34 sedan 44 suv 6null convertible An inner join will return Product_id product_name option_id option_product_id option 2 ship1 2 cargo 2 ship2 2 container 4 car 3 4 sedan 4 car 4 4 suv An outer join will return Product_id product_name option_id option_product_id option 1 boatnull null null 2 ship 1 2 cargo 2 ship 2 2 container 3 plane null null null 4 car 3 4 sedan 4 car 4 4 suv 5 truck null null null On Sat, Apr 23, 2011 at 4:58 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Maureen, Many thanks for the reply. Taking the first two queries. In Product I search on title, short description and long description. In Product Options I search on the option title and description. I tried some tests joining the tables:- cfquery dbtype=query name=product select stockID from stockTable left outer join stockItemsTable ON stockItemsTable.stockID = stockTable.stockID /cfquery I assume I need to use a left outer join. Although the stocktable and stockitemstable individually returned results, I can't get the combined tables to produce anything. As I understand it FREETEXTTABLE can only search on one table at a time? I can't use a database view in the fulltext catalogue? If I can it answers all my problem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
On Sat, Apr 23, 2011 at 4:58 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: As I understand it FREETEXTTABLE can only search on one table at a time? I can't use a database view in the fulltext catalogue? If I can it answers all my problems. I've never used FREETEXTTABLE on a view, but I don't see why it wouldn't work, as the structure returned by a view looks just like a table ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
Hi Maureen, I found it is possible to create indexed views and add them to a fulltext catalog, however, among a longgg list of constraints MS say that the views cannot contain Ntext fields, which rules out that option for me. http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 00:26 To: cf-talk Subject: Re: Problem Using QueryNew Seems to me it would a lot more efficient to make a view in your database that only returns the two fields you want to search on plus any fields you need for search criteria. Or do a select with a join that returns the fields. Once you do that, they are already in a query, so you wouldn't need to make another query to hold them. On Sat, Apr 23, 2011 at 4:21 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Many thanks, Will. Obvious now I look at it again, duh me. Anyhoo, I had this (probably dumb) idea of combining sever fulltext search query results into one table, turning into a lot more work than I expected (+ learning curve). Maybe there is a better way of going about this: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
Are you still running SQL Server 2000, and if not, is that still the case for the version of SQL you are running? On Sat, Apr 23, 2011 at 5:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Maureen, I found it is possible to create indexed views and add them to a fulltext catalog, however, among a longgg list of constraints MS say that the views cannot contain Ntext fields, which rules out that option for me. http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
I'm still on SQL 2000. Sadly it can't be done in SQL 2008 either: The view cannot include text, ntext, or image columns, even if they are not referenced in the CREATE INDEX statement. http://msdn.microsoft.com/en-us/library/ms191432.aspx -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 01:33 To: cf-talk Subject: Re: Problem Using QueryNew Are you still running SQL Server 2000, and if not, is that still the case for the version of SQL you are running? On Sat, Apr 23, 2011 at 5:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Maureen, I found it is possible to create indexed views and add them to a fulltext catalog, however, among a longgg list of constraints MS say that the views cannot contain Ntext fields, which rules out that option for me. http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
So you believe that code can only bring a server down in a hosted environment and that hosting a live production site off your local development machine (presumably running off a ADSL connection) is not better than a server in a data centre with monitoring, power generators, professional peering and bandwidth.. Crikey, I don't even know what to say in response to that, obviously your 30 years in I.T have been well spent, well done. On Sun, Apr 24, 2011 at 1:11 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, With 30 years in the IT business and over 20 of them as an IT Manager I am fully aware of the implications of server vulnerability. A hosting environment is a very different scenario to a single developer using a single server for testing and live applications. Sure, in an ideal world we'd all love to run on dedicated and managed live servers well apart from our test environment. Having run with hosted, dedicated, managed servers for some years I have found their up-time is no better than I am able to achieve with my own local server which I manage. (For what it's worth I have the tested stats to prove that.) Unless a dedicated server can be assured in a hosting enviromnent you are sharing a server with god knows who. As you know as a Host, you can't vet the quality of the developers using your servers, or whoever else they might let tinker with their web sites. Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 00:43 To: cf-talk Subject: Re: IIS Question Jenny i'm not sure what evidence you have to quality that statement, but you couldn't be more wrong, bad code sure can take down a web server and even a database server, it happens every day. With 10+ years in the hosting business I personally see it happen all the time and consult with many customers to diagnose and fix the cause of the problem. On Sun, Apr 24, 2011 at 12:31 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and avoid the problem. The only issue then is the database, as you are unlikely to be running a server o/s on your pc, assuming the database requires a server o/s - I'm using MS SQL, for example. But yes, separate everything out. 2 web sites in IIS, 2 databases, 2 CF DB connections, etc with very clear and regulated naming conventions. Jenny Gavin-Wear Fast Track Online http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 23 April 2011 20:58 To: cf-talk Subject: Re: IIS Question as you are running both development and production on the same server I would also suggest you take measures to isolate them as this is a very bad setup you have as your untested development code could take down CF and thus the live site. I suggest you run CF multi in server mode and run 2 instances, 1 for live and one for dev. You should run every site on its own application pool to avoid any iis issues. If you have no idea what any of that means, then you really shouldn't be trying to manage a production web server for your client, so you should speak with your host about management services or at least a hosting control panel that will do it for you. For windows I recommend Website Panel. On Sat, Apr 23, 2011 at 8:06 PM, Dave Watts dwa...@figleaf.com wrote: But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question A single IIS server can have many IIS sites, or virtual servers. These can point to wherever you want them to point. Presumably, this machine has at least two IIS sites. You can view the list of sites in the IIS management console, and can right-click on each as Brian mentioned to see the filesystem location where each points. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
Darn. That bites. Maybe a different searching mechanism if the simple query doesn't work. Or a temp table. On Sat, Apr 23, 2011 at 5:45 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm still on SQL 2000. Sadly it can't be done in SQL 2008 either: The view cannot include text, ntext, or image columns, even if they are not referenced in the CREATE INDEX statement. http://msdn.microsoft.com/en-us/library/ms191432.aspx ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
Change all your ntext to nvarchar(MAX), if you can. And run an UPDATE to free up space after the conversion, too ;) ALTER TABLE myTable ALTER COLUMN myNText nvarchar(MAX); UPDATE myTable SET myNText = myNText; That lets SQL keep the first set of chars locally, and only points to the LOB when it needs to (only records that really have long values in myNText). nvarchar(MAX) is the new ntext, and ntext is being deprecated, so it's a good move at any rate. On 4/23/2011 8:29 PM, Jenny Gavin-Wear wrote: Hi Maureen, I found it is possible to create indexed views and add them to a fulltext catalog, however, among a longgg list of constraints MS say that the views cannot contain Ntext fields, which rules out that option for me. http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 00:26 To: cf-talk Subject: Re: Problem Using QueryNew Seems to me it would a lot more efficient to make a view in your database that only returns the two fields you want to search on plus any fields you need for search criteria. Or do a select with a join that returns the fields. Once you do that, they are already in a query, so you wouldn't need to make another query to hold them. On Sat, Apr 23, 2011 at 4:21 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Many thanks, Will. Obvious now I look at it again, duh me. Anyhoo, I had this (probably dumb) idea of combining sever fulltext search query results into one table, turning into a lot more work than I expected (+ learning curve). Maybe there is a better way of going about this: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
See your point, but the actual likely hood of taking down a server with code is pretty small. My experience has been directly the opposite of this over the last fifteen years or so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS Question
Russ, 1. No, I do not believe that it is only possible for code to bring a server down in a hosted environment, I never said that. 2. The bandwidth requirement I have matches my needs, thanks for asking. 3. I don't take holidays and I'm pretty much here 24/7 so my support to my customers is _at_least_ as fast as yours. 4. I test my code on my own PC running CF. 5. I don't see that it's any of your business how I choose to run my business. 6. I certainly don't see why I should qualify myself to you. You make too many assumptions before asking questions about a persons enviromnent and circumstances. Russ, most of the time in CF-Talk I see you being a really helpful guy, but I do wish you would stop to think a little before behaving so poorly - and I'm being polite! Maybe with a little more experience, even age, you'll be able to handle yourself better. Not everyone can afford what you are offering, did you stop to think about that? You have no idea how many sites I am running on my server or what the traffic is like. I do, I see great performance, my customers agree. Not that it's any of your business, but I have all the peering I need to run one server, thank you. The original poster asked a very straight forward question, he didn't ask to have his circumstances analyzed by you. Jenny -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 02:05 To: cf-talk Subject: Re: IIS Question So you believe that code can only bring a server down in a hosted environment and that hosting a live production site off your local development machine (presumably running off a ADSL connection) is not better than a server in a data centre with monitoring, power generators, professional peering and bandwidth.. Crikey, I don't even know what to say in response to that, obviously your 30 years in I.T have been well spent, well done. On Sun, Apr 24, 2011 at 1:11 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, With 30 years in the IT business and over 20 of them as an IT Manager I am fully aware of the implications of server vulnerability. A hosting environment is a very different scenario to a single developer using a single server for testing and live applications. Sure, in an ideal world we'd all love to run on dedicated and managed live servers well apart from our test environment. Having run with hosted, dedicated, managed servers for some years I have found their up-time is no better than I am able to achieve with my own local server which I manage. (For what it's worth I have the tested stats to prove that.) Unless a dedicated server can be assured in a hosting enviromnent you are sharing a server with god knows who. As you know as a Host, you can't vet the quality of the developers using your servers, or whoever else they might let tinker with their web sites. Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 00:43 To: cf-talk Subject: Re: IIS Question Jenny i'm not sure what evidence you have to quality that statement, but you couldn't be more wrong, bad code sure can take down a web server and even a database server, it happens every day. With 10+ years in the hosting business I personally see it happen all the time and consult with many customers to diagnose and fix the cause of the problem. On Sun, Apr 24, 2011 at 12:31 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and avoid the problem. The only issue then is the database, as you are unlikely to be running a server o/s on your pc, assuming the database requires a server o/s - I'm using MS SQL, for example. But yes, separate everything out. 2 web sites in IIS, 2 databases, 2 CF DB connections, etc with very clear and regulated naming conventions. Jenny Gavin-Wear Fast Track Online http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 23 April 2011 20:58 To: cf-talk Subject: Re: IIS Question as you are running both development and production on the same server I would also suggest you take measures to isolate them as this is a very bad setup you have as your untested development code could take down CF and thus the live site. I suggest you run CF multi in server mode and run 2 instances, 1 for live and one for dev. You should run every site on its own application pool to avoid any iis issues. If you have no idea what any of that means, then you really shouldn't be trying to manage a production web server for your client, so you should speak with your host about management services or at least
RE: IIS Question
Point taken, but I can only speak from my own experience. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 24 April 2011 02:27 To: cf-talk Subject: Re: IIS Question See your point, but the actual likely hood of taking down a server with code is pretty small. My experience has been directly the opposite of this over the last fifteen years or so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343938 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
Hi Maureen, I really like your thinking, but I'm not sure that will achieve what I need, I'll definitely test it out tomorrow though, many thanks for your input, much appreciated. One niggle is that having to use two queries really messes up using the Ranking. Jenny -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 01:28 To: cf-talk Subject: Re: Problem Using QueryNew No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3592 - Release Date: 04/23/11 07:36:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
Hi Jason, Many thanks for your reply, it would be great if this will work on SQL 2000. I tried testing this: ALTER TABLE testing ALTER COLUMN testing nvarchar(MAX); Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'MAX'. I Googled a bit and found a couple of postings from people saying that using nvarchar(max) truncated their existing data. I'm a bit confused about what you say about: That lets SQL keep the first set of chars locally, and only points to the LOB when it needs to (only records that really have long values in myNText). Could you explain a little more, please? nvarchar(MAX) is the new ntext, and ntext is being deprecated, so it's a good move at any rate. Thanks for the warning on this. Jenny -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 24 April 2011 02:18 To: cf-talk Subject: Re: Problem Using QueryNew Change all your ntext to nvarchar(MAX), if you can. And run an UPDATE to free up space after the conversion, too ;) ALTER TABLE myTable ALTER COLUMN myNText nvarchar(MAX); UPDATE myTable SET myNText = myNText; That lets SQL keep the first set of chars locally, and only points to the LOB when it needs to (only records that really have long values in myNText). nvarchar(MAX) is the new ntext, and ntext is being deprecated, so it's a good move at any rate. On 4/23/2011 8:29 PM, Jenny Gavin-Wear wrote: Hi Maureen, I found it is possible to create indexed views and add them to a fulltext catalog, however, among a longgg list of constraints MS say that the views cannot contain Ntext fields, which rules out that option for me. http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 00:26 To: cf-talk Subject: Re: Problem Using QueryNew Seems to me it would a lot more efficient to make a view in your database that only returns the two fields you want to search on plus any fields you need for search criteria. Or do a select with a join that returns the fields. Once you do that, they are already in a query, so you wouldn't need to make another query to hold them. On Sat, Apr 23, 2011 at 4:21 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Many thanks, Will. Obvious now I look at it again, duh me. Anyhoo, I had this (probably dumb) idea of combining sever fulltext search query results into one table, turning into a lot more work than I expected (+ learning curve). Maybe there is a better way of going about this: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
Varchar(max) was added to mssql 2005 2000 has a limit of Varchar(8060) Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
Actually Jenny I was ONLY quoting your own statements BACK, so I did not make any assumptions, you may want to read back your own emails to avoid contradictions like this. A little friendly advice, If you want your business to be private and think it is not anyone else's business what you do, then a good idea would be don't post it on a public list, and certainly don't brag about it, otherwise you are opening it up for discussion, that is after all the purpose of a discussion list. I realise some people don't have much money, but as the only thing I have offered is free advice I don't think that is relevant to this topic as at no point have I tried to sell anyone anything to anyone. As for my needing more experience and age, LOL, I wont try to brag as you did, but you may want to take your own advice about making assumptions there. NUFF SAID! On Sun, Apr 24, 2011 at 2:29 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Russ, 1. No, I do not believe that it is only possible for code to bring a server down in a hosted environment, I never said that. 2. The bandwidth requirement I have matches my needs, thanks for asking. 3. I don't take holidays and I'm pretty much here 24/7 so my support to my customers is _at_least_ as fast as yours. 4. I test my code on my own PC running CF. 5. I don't see that it's any of your business how I choose to run my business. 6. I certainly don't see why I should qualify myself to you. You make too many assumptions before asking questions about a persons enviromnent and circumstances. Russ, most of the time in CF-Talk I see you being a really helpful guy, but I do wish you would stop to think a little before behaving so poorly - and I'm being polite! Maybe with a little more experience, even age, you'll be able to handle yourself better. Not everyone can afford what you are offering, did you stop to think about that? You have no idea how many sites I am running on my server or what the traffic is like. I do, I see great performance, my customers agree. Not that it's any of your business, but I have all the peering I need to run one server, thank you. The original poster asked a very straight forward question, he didn't ask to have his circumstances analyzed by you. Jenny -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 02:05 To: cf-talk Subject: Re: IIS Question So you believe that code can only bring a server down in a hosted environment and that hosting a live production site off your local development machine (presumably running off a ADSL connection) is not better than a server in a data centre with monitoring, power generators, professional peering and bandwidth.. Crikey, I don't even know what to say in response to that, obviously your 30 years in I.T have been well spent, well done. On Sun, Apr 24, 2011 at 1:11 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, With 30 years in the IT business and over 20 of them as an IT Manager I am fully aware of the implications of server vulnerability. A hosting environment is a very different scenario to a single developer using a single server for testing and live applications. Sure, in an ideal world we'd all love to run on dedicated and managed live servers well apart from our test environment. Having run with hosted, dedicated, managed servers for some years I have found their up-time is no better than I am able to achieve with my own local server which I manage. (For what it's worth I have the tested stats to prove that.) Unless a dedicated server can be assured in a hosting enviromnent you are sharing a server with god knows who. As you know as a Host, you can't vet the quality of the developers using your servers, or whoever else they might let tinker with their web sites. Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 00:43 To: cf-talk Subject: Re: IIS Question Jenny i'm not sure what evidence you have to quality that statement, but you couldn't be more wrong, bad code sure can take down a web server and even a database server, it happens every day. With 10+ years in the hosting business I personally see it happen all the time and consult with many customers to diagnose and fix the cause of the problem. On Sun, Apr 24, 2011 at 12:31 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and avoid the problem. The only issue then is the database, as you are unlikely to be running a server o/s on your pc, assuming the database requires a server o/s -
RE: Any secure data transfer methods avaiable for very large files?
Hi Kamru, Sorry for my late reply. This link will give you a good idea of what a VPN could do for you: http://technet.microsoft.com/en-us/library/bb742566.aspx It is unlikely to be a cheap solution, but it will have the potential to be a robust and secure solution. Something you could consider if your requirement for shifting data is not just a short term need. My own experience is particularly with Checkpoint Firewall 1 which has an option VPN module. This is pretty expensive stuff, but I am sure there are lots of cheaper solutions out there. If you think this is a direction you would like to go in, I'll gladly help you sort out a viable solution. (Not provide, but help you find, to be clear.) Take care, Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -Original Message- From: Kamru Miah [mailto:k.m...@csl.gov.uk] Sent: 19 April 2011 12:20 To: cf-talk Subject: Re: Any secure data transfer methods avaiable for very large files? Hi Jenny, Thanks for you reply. Apologies for not answering sooner, as I could not connect to houseoffusion.com last Friday (15/4/2011) for some technical reason. No, I have not thought about VPN. Would that allow an upload of up to 50 GB data from UK and downloaded from another European country securely and reliably? What VPN product do I need to consider? Any pointers will be appreciated. Many Thanks, Kamru -- Have you thought of using a VPN? Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3592 - Release Date: 04/23/11 07:36:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
If you are using SQL Server 2000, to avoid truncation you can use TEXT or nText fields instead. These are BLOBS and are not contained by the max row length. The combined max row size for all other fields is 8060, anything above this will be truncated. Since SQL Server 2005 these were depreciated in favour of the new VarChar(max) data type. -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
Ah, yeah, pretty sure nvarchar(MAX) was added in SQL 2005, unfortunately. So, to explain further, ntext holds only a pointer to the actual content elsewhere on the server, held in a Large Object (LOB). nvarchar(MAX) holds the first 8k of data in the table, so to speak, and then only pushes overflow data out via pointer. Since oftentimes the data in ntext fields isn't really that long (but the column has to account for those times it *is* long), by using MAX you actually save space and end up with an indexable column. The UPDATE basically pulls the first 8k of data into the table, replacing the old ntext pointer with the new MAX structure. Pete Freitag had an entry on it: http://www.petefreitag.com/item/734.cfm He further linked to another post about why to run the additional UPDATE as well: http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx On 4/23/2011 9:56 PM, Jenny Gavin-Wear wrote: Hi Jason, Many thanks for your reply, it would be great if this will work on SQL 2000. I tried testing this: ALTER TABLE testing ALTER COLUMN testing nvarchar(MAX); Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'MAX'. I Googled a bit and found a couple of postings from people saying that using nvarchar(max) truncated their existing data. I'm a bit confused about what you say about: That lets SQL keep the first set of chars locally, and only points to the LOB when it needs to (only records that really have long values in myNText). Could you explain a little more, please? nvarchar(MAX) is the new ntext, and ntext is being deprecated, so it's a good move at any rate. Thanks for the warning on this. Jenny -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 24 April 2011 02:18 To: cf-talk Subject: Re: Problem Using QueryNew Change all your ntext to nvarchar(MAX), if you can. And run an UPDATE to free up space after the conversion, too ;) ALTER TABLE myTable ALTER COLUMN myNText nvarchar(MAX); UPDATE myTable SET myNText = myNText; That lets SQL keep the first set of chars locally, and only points to the LOB when it needs to (only records that really have long values in myNText). nvarchar(MAX) is the new ntext, and ntext is being deprecated, so it's a good move at any rate. On 4/23/2011 8:29 PM, Jenny Gavin-Wear wrote: Hi Maureen, I found it is possible to create indexed views and add them to a fulltext catalog, however, among a longgg list of constraints MS say that the views cannot contain Ntext fields, which rules out that option for me. http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 00:26 To: cf-talk Subject: Re: Problem Using QueryNew Seems to me it would a lot more efficient to make a view in your database that only returns the two fields you want to search on plus any fields you need for search criteria. Or do a select with a join that returns the fields. Once you do that, they are already in a query, so you wouldn't need to make another query to hold them. On Sat, Apr 23, 2011 at 4:21 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Many thanks, Will. Obvious now I look at it again, duh me. Anyhoo, I had this (probably dumb) idea of combining sever fulltext search query results into one table, turning into a lot more work than I expected (+ learning curve). Maybe there is a better way of going about this: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343945 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
Be sure to enable the blob/clob option(s) on the CF datasource if you go with those datatypes. That one bites me all the time. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Saturday, April 23, 2011 10:29 PM To: cf-talk Subject: Re: Problem Using QueryNew If you are using SQL Server 2000, to avoid truncation you can use TEXT or nText fields instead. These are BLOBS and are not contained by the max row length. The combined max row size for all other fields is 8060, anything above this will be truncated. Since SQL Server 2005 these were depreciated in favour of the new VarChar(max) data type. -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
She's already using ntext. She is trying to figure a way to search two different ntext fields in two different related tables returned by the same query using FREETEXTTABLE On Sat, Apr 23, 2011 at 7:28 PM, Russ Michaels r...@michaels.me.uk wrote: If you are using SQL Server 2000, to avoid truncation you can use TEXT or nText fields instead. These are BLOBS and are not contained by the max row length. The combined max row size for all other fields is 8060, anything above this will be truncated. Since SQL Server 2005 these were depreciated in favour of the new VarChar(max) data type. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS Question
You're not worth my time. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 03:21 To: cf-talk Subject: Re: IIS Question Actually Jenny I was ONLY quoting your own statements BACK, so I did not make any assumptions, you may want to read back your own emails to avoid contradictions like this. A little friendly advice, If you want your business to be private and think it is not anyone else's business what you do, then a good idea would be don't post it on a public list, and certainly don't brag about it, otherwise you are opening it up for discussion, that is after all the purpose of a discussion list. I realise some people don't have much money, but as the only thing I have offered is free advice I don't think that is relevant to this topic as at no point have I tried to sell anyone anything to anyone. As for my needing more experience and age, LOL, I wont try to brag as you did, but you may want to take your own advice about making assumptions there. NUFF SAID! On Sun, Apr 24, 2011 at 2:29 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Russ, 1. No, I do not believe that it is only possible for code to bring a server down in a hosted environment, I never said that. 2. The bandwidth requirement I have matches my needs, thanks for asking. 3. I don't take holidays and I'm pretty much here 24/7 so my support to my customers is _at_least_ as fast as yours. 4. I test my code on my own PC running CF. 5. I don't see that it's any of your business how I choose to run my business. 6. I certainly don't see why I should qualify myself to you. You make too many assumptions before asking questions about a persons enviromnent and circumstances. Russ, most of the time in CF-Talk I see you being a really helpful guy, but I do wish you would stop to think a little before behaving so poorly - and I'm being polite! Maybe with a little more experience, even age, you'll be able to handle yourself better. Not everyone can afford what you are offering, did you stop to think about that? You have no idea how many sites I am running on my server or what the traffic is like. I do, I see great performance, my customers agree. Not that it's any of your business, but I have all the peering I need to run one server, thank you. The original poster asked a very straight forward question, he didn't ask to have his circumstances analyzed by you. Jenny -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 02:05 To: cf-talk Subject: Re: IIS Question So you believe that code can only bring a server down in a hosted environment and that hosting a live production site off your local development machine (presumably running off a ADSL connection) is not better than a server in a data centre with monitoring, power generators, professional peering and bandwidth.. Crikey, I don't even know what to say in response to that, obviously your 30 years in I.T have been well spent, well done. On Sun, Apr 24, 2011 at 1:11 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, With 30 years in the IT business and over 20 of them as an IT Manager I am fully aware of the implications of server vulnerability. A hosting environment is a very different scenario to a single developer using a single server for testing and live applications. Sure, in an ideal world we'd all love to run on dedicated and managed live servers well apart from our test environment. Having run with hosted, dedicated, managed servers for some years I have found their up-time is no better than I am able to achieve with my own local server which I manage. (For what it's worth I have the tested stats to prove that.) Unless a dedicated server can be assured in a hosting enviromnent you are sharing a server with god knows who. As you know as a Host, you can't vet the quality of the developers using your servers, or whoever else they might let tinker with their web sites. Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 24 April 2011 00:43 To: cf-talk Subject: Re: IIS Question Jenny i'm not sure what evidence you have to quality that statement, but you couldn't be more wrong, bad code sure can take down a web server and even a database server, it happens every day. With 10+ years in the hosting business I personally see it happen all the time and consult with many customers to diagnose and fix the cause of the problem. On Sun, Apr 24, 2011 at 12:31 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Russ, See your point, but the actual likely hood of taking down a server with code is pretty small. You can always set up IIS/CF on your local PC anyway and
RE: Problem Using QueryNew
That's awesome, Jason, many thanks for explaining. I'm not using ntext fields extensively, so if I upgrade my SQL later it's not going to be a big head ache. -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 24 April 2011 03:30 To: cf-talk Subject: Re: Problem Using QueryNew Ah, yeah, pretty sure nvarchar(MAX) was added in SQL 2005, unfortunately. So, to explain further, ntext holds only a pointer to the actual content elsewhere on the server, held in a Large Object (LOB). nvarchar(MAX) holds the first 8k of data in the table, so to speak, and then only pushes overflow data out via pointer. Since oftentimes the data in ntext fields isn't really that long (but the column has to account for those times it *is* long), by using MAX you actually save space and end up with an indexable column. The UPDATE basically pulls the first 8k of data into the table, replacing the old ntext pointer with the new MAX structure. Pete Freitag had an entry on it: http://www.petefreitag.com/item/734.cfm He further linked to another post about why to run the additional UPDATE as well: http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarchar max-in-sql-2005.aspx On 4/23/2011 9:56 PM, Jenny Gavin-Wear wrote: Hi Jason, Many thanks for your reply, it would be great if this will work on SQL 2000. I tried testing this: ALTER TABLE testing ALTER COLUMN testing nvarchar(MAX); Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'MAX'. I Googled a bit and found a couple of postings from people saying that using nvarchar(max) truncated their existing data. I'm a bit confused about what you say about: That lets SQL keep the first set of chars locally, and only points to the LOB when it needs to (only records that really have long values in myNText). Could you explain a little more, please? nvarchar(MAX) is the new ntext, and ntext is being deprecated, so it's a good move at any rate. Thanks for the warning on this. Jenny -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 24 April 2011 02:18 To: cf-talk Subject: Re: Problem Using QueryNew Change all your ntext to nvarchar(MAX), if you can. And run an UPDATE to free up space after the conversion, too ;) ALTER TABLE myTable ALTER COLUMN myNText nvarchar(MAX); UPDATE myTable SET myNText = myNText; That lets SQL keep the first set of chars locally, and only points to the LOB when it needs to (only records that really have long values in myNText). nvarchar(MAX) is the new ntext, and ntext is being deprecated, so it's a good move at any rate. On 4/23/2011 8:29 PM, Jenny Gavin-Wear wrote: Hi Maureen, I found it is possible to create indexed views and add them to a fulltext catalog, however, among a longgg list of constraints MS say that the views cannot contain Ntext fields, which rules out that option for me. http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 00:26 To: cf-talk Subject: Re: Problem Using QueryNew Seems to me it would a lot more efficient to make a view in your database that only returns the two fields you want to search on plus any fields you need for search criteria. Or do a select with a join that returns the fields. Once you do that, they are already in a query, so you wouldn't need to make another query to hold them. On Sat, Apr 23, 2011 at 4:21 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Many thanks, Will. Obvious now I look at it again, duh me. Anyhoo, I had this (probably dumb) idea of combining sever fulltext search query results into one table, turning into a lot more work than I expected (+ learning curve). Maybe there is a better way of going about this: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
Thanks Bobby, I did indeed miss that! -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: 24 April 2011 03:38 To: cf-talk Subject: RE: Problem Using QueryNew Be sure to enable the blob/clob option(s) on the CF datasource if you go with those datatypes. That one bites me all the time. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3592 - Release Date: 04/23/11 07:36:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: OT question - is this real or phishing?
I wish all countries followed Australia's example. -Original Message- From: Kym Kovan [mailto:dev-li...@mbcomms.net.au] Sent: 21 April 2011 02:32 To: cf-talk Subject: Re: OT question - is this real or phishing? On 21/04/2011 09:49, Russ Michaels wrote: anyone can register any domain, it is an automated system, seriously, do you think someone manually checks every single domain to see whether it might be infringing on anyone else's name or copyright. sorry to disillusion you but that is exactly what happens in some countries, not everyone is a casual as the USA :-) Try registering a .com.au without a registered company name in Australia, you'll be questioned by the registrar as to your bona-fides. -- Yours, Kym Kovan mbcomms.net.au No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3592 - Release Date: 04/23/11 07:36:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
