re: SQL Server question re table names - still stuck
I wrote: A client asked me to see if I could get a copy of his old web site up and running. I did a restore of the backed up database onto my PC. The problem is that all the table names have the name of the database prepended to them. When I view the tables in SQL Server Manager, the table, city, is named abc.city, where oldabc is the name of the database from which the data was backed up from. For the sake of this example, newabc is the database name I used on my own machine, to which the backup data was restored to. brad wrote: I can't say I've ever seen that one before, but you could just do a loop over the contents of INFORMATION_SCHEMA.TABLES and build/exec an ALTER statement for each one. http://technet.microsoft.com/en-us/library/ms190273.aspx How many tables are there? If there are under 75, you might be just as fast renaming them them by hand. Well, I tried renaming them by hand but it won't work. Using the SQL Server Manger, I right-clicked on the table and then clicked on RENAME. The table name, when I right-clicked on it, said something like: abc.city. But when the RENAME edit box came up, it contained only city. So the table isn't actually named abc.city. It is only presenting the table that way, and when I do a query in CF, it expects me to also refer to the table with that database name prefix. Hmm...ok, here's the exact scenario: 1) I'm imported the data from a backup file and named the database canadianofficespace. 2) When I look at the tables in SQL Server Manager, it prefixes every table name with canadianofficespacecom, which is not the name of the database. I presume it's the name of the database that it originally came from. 3) When I do a CFQuery, it won't work unless I write the table name as canadianofficespacecom.city, instead of just city. Can anyone help me out here? This is well beyond my SQL Server knowledge. ...lars ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF9 instance in CF8 multiserver - context root problem?
hello fellow cftalkers, i have changed my dev environment to a CF8 multi-server setup, and then installed CF9 as an instance in it. cf8 instance has context root set to /, and cf9 is set to use /cf9 context root. this all is on Win XP with Apache 2.2 as web server. while everything else seems to work fine (so far, at least), one problem i have come across is: trying to use cfmap tag, the script tags cf9 inserts for google maps api and mapiconmaker scripts end up with src looking like src=/cf9http://..; which, obviously, fails to load the scripts. is it some setting in the instance's setup in jrun i am missing, or have incorrect? or something in the instance's administrator i need to change? any other info i need to post here? also, can both my cf8 and cf9 instances have context root set to / ? i have tried changing cf9 instance's context root to /, but if then fails to restart the service it seems... thanks for any help! -- Azadi Saryev ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server question re table names - still stuck
I didn't see a mention of which version of SQL Server you're running, but it sounds to me like canadianofficespacecom is either an object owner or a schema: http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server I'm assuming that it's most likely SQL Server 2005 or 2008, in which case the simplest fix would probably be to change the default schema for the user that you specified in your CF datasource. To do this, access the properties for the user in question and you will see a default schema field -- change the value to canadianofficespacecom and you should then be able to query the tables without the prefix. HTH, -- Ezra Parker On Fri, Dec 11, 2009 at 1:07 AM, Larry Soo l...@bc4x4.com wrote: I wrote: A client asked me to see if I could get a copy of his old web site up and running. I did a restore of the backed up database onto my PC. The problem is that all the table names have the name of the database prepended to them. When I view the tables in SQL Server Manager, the table, city, is named abc.city, where oldabc is the name of the database from which the data was backed up from. For the sake of this example, newabc is the database name I used on my own machine, to which the backup data was restored to. brad wrote: I can't say I've ever seen that one before, but you could just do a loop over the contents of INFORMATION_SCHEMA.TABLES and build/exec an ALTER statement for each one. http://technet.microsoft.com/en-us/library/ms190273.aspx How many tables are there? If there are under 75, you might be just as fast renaming them them by hand. Well, I tried renaming them by hand but it won't work. Using the SQL Server Manger, I right-clicked on the table and then clicked on RENAME. The table name, when I right-clicked on it, said something like: abc.city. But when the RENAME edit box came up, it contained only city. So the table isn't actually named abc.city. It is only presenting the table that way, and when I do a query in CF, it expects me to also refer to the table with that database name prefix. Hmm...ok, here's the exact scenario: 1) I'm imported the data from a backup file and named the database canadianofficespace. 2) When I look at the tables in SQL Server Manager, it prefixes every table name with canadianofficespacecom, which is not the name of the database. I presume it's the name of the database that it originally came from. 3) When I do a CFQuery, it won't work unless I write the table name as canadianofficespacecom.city, instead of just city. Can anyone help me out here? This is well beyond my SQL Server knowledge. ...lars ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server question re table names - still stuck
but it sounds to me like canadianofficespacecom is either an object owner or a schema: +1 That would make more sense than being part of the actual table name. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
detect multiples?
I have a loop which counts, I need to detect multiples of 6 i.e loop count is it a multiple of 6? true else do nothing is there a tag that does this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Working With Images
Hello. I was ask to help build a dynamic website for a volunteer fire department were they could add news and photos. Iâm having trouble with the photos. Does anybody know of a free or paid website were I can find some coldfusion code to add, edit, update, and delete images. I would like to be able to add the images to a database and have CF8 crop the images too. Thanks for your time, Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: detect multiples?
You can use the modulus operator (ie MOD) cfif someNumber MOD 6 EQ 0 the number is a multiple of 6 .. or the value is 0 /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: detect multiples?
The following will only execute the stuff inside the CFIF statement if the count is *not* a multiple of 6. cfloop from=1 to=96 index=i cfif i mod 6 !--- do whatever you need to --- /cfif /cfloop ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9 instance in CF8 multiserver - context root problem?
i have changed my dev environment to a CF8 multi-server setup, and then installed CF9 as an instance in it. cf8 instance has context root set to /, and cf9 is set to use /cf9 context root. this all is on Win XP with Apache 2.2 as web server. In general, I would recommend that you install CF 9 as multi-server, and then install CF 8 as an instance in that. This guarantees that you get the latest version of JRun. Honestly, I'm not sure if there are any differences between the version of JRun with CF 8 and with CF 9, but I wouldn't be surprised if there were some small, poorly-documented differences. also, can both my cf8 and cf9 instances have context root set to / ? i have tried changing cf9 instance's context root to /, but if then fails to restart the service it seems... You can't have two J2EE apps with the same context root attached to the same virtual web server. The context root is used by the web server (or more accurately, by the JRun module installed into the web server, I guess) to determine how to route requests. In my own case, I've simply set up multiple virtual web servers - easy enough to do in Apache - and configured my CF instances to point at those web servers. They can then all have the / context root. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9 instance in CF8 multiserver - context root problem?
thanks for your answer, Dave! setting up virtual Apache servers - something tells me it is not the same as vhosts, is it? but google seems to think it is... could you point me to where i can find more info on how to set them up? if it is same as vhosts, then that's how i have it set up, too. i was following Matt Quackenbush's instructions in setting up cf9 with cf8 from here: http://www.quackfuzed.com/index.cfm/2009/10/18/Learning-CF9-Installing-CF9-Alongside-CF8 and, as i said, everything works just fine except the src attribute of external scripts cf inserts into the page ends up prefixed with the instance's context root /cf9... your help is very much appreciated, Dave. Azadi Saryev On 11/12/2009 22:29, Dave Watts wrote: i have changed my dev environment to a CF8 multi-server setup, and then installed CF9 as an instance in it. cf8 instance has context root set to /, and cf9 is set to use /cf9 context root. this all is on Win XP with Apache 2.2 as web server. In general, I would recommend that you install CF 9 as multi-server, and then install CF 8 as an instance in that. This guarantees that you get the latest version of JRun. Honestly, I'm not sure if there are any differences between the version of JRun with CF 8 and with CF 9, but I wouldn't be surprised if there were some small, poorly-documented differences. also, can both my cf8 and cf9 instances have context root set to / ? i have tried changing cf9 instance's context root to /, but if then fails to restart the service it seems... You can't have two J2EE apps with the same context root attached to the same virtual web server. The context root is used by the web server (or more accurately, by the JRun module installed into the web server, I guess) to determine how to route requests. In my own case, I've simply set up multiple virtual web servers - easy enough to do in Apache - and configured my CF instances to point at those web servers. They can then all have the / context root. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Faster SMTP
This is an actual mail server though correct? My mail server is not the issue it spools out fine. It's the CF Spooler that is my bottleneck. -Original Message- From: Erik-Jan Jaquet [mailto:erik...@toomba.nl] Sent: Thursday, December 10, 2009 10:44 AM To: cf-talk Subject: Re: Faster SMTP We're using Infusion Mail server for this kinf of thing. Works really well and its really fast. http://www.coolfusion.com/downloads/index.cfm?CFID=951923CFTOKEN=252379 43 Kind regards, Erik-Jan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working With Images
try googling cfimage, or if you like learning by example, download galleon forums and play around with the avatar uploader. i'm sure there are more (and possibly better) examples but it's the first thing that comes to mind Hello. I was ask to help build a dynamic website for a volunteer fire department were they could add news and photos. Iâm having trouble with the photos. Does anybody know of a free or paid website were I can find some coldfusion code to add, edit, update, and delete images. I would like to be able to add the images to a database and have CF8 crop the images too. Thanks for your time, Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Working With Images
Hi, Barry... Did you ever get any private response for your image-handling issue? (I see that no one has responded publicly...) Rick -Original Message- From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] Sent: Friday, December 11, 2009 7:55 AM To: cf-talk Subject: Working With Images Hello. I was ask to help build a dynamic website for a volunteer fire department were they could add news and photos. Iââ¬â¢m having trouble with the photos. Does anybody know of a free or paid website were I can find some coldfusion code to add, edit, update, and delete images. I would like to be able to add the images to a database and have CF8 crop the images too. Thanks for your time, Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9 instance in CF8 multiserver - context root problem?
setting up virtual Apache servers - something tells me it is not the same as vhosts, is it? but google seems to think it is... could you point me to where i can find more info on how to set them up? Yes, it's the same. You have to put the instance-specific JRun directives in each vhost, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cftransaction
Hi all, I understand the gist of cftransaction, but I've tried using it with a conditional rollback on an action page in the below example and it doesn't seem to work. saveDataToDatabase() submits data to a stored procedure, which always returns a string: empty string if the data was saved, or a message stating what the problem was if not. cfset allReturnMessages = cftransaction cfloop cfset returnMessage = someCFC.saveDataToDatabase() cfset allReturnMessages = allReturnMessages returnMessage br /cfloop cfif len(trim(allReturnMessages)) cftransaction action=rollback / /cfif /cftransaction I'm not including cftry in this example, just to illustrate that I'm not looking for a database or other type of CF error per se - rather, I'm looking for any return message from the stored proc that isn't an empty string, such as sorry - everything is otherwise kosher, but this stored proc is coded not to save the data if field x is above value y. That's not a database error as far as CF is concerned, so cftry wouldn't catch it. But in testing this code, I've found that the rollback doesn't take place, even when the cfif statement is true. Am I not using cftransaction correctly? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Server question re table names - still stuck
Hmm, what's the chance the extra part isn't really the database name, but it is the owner name. Kind of like the default owner is dbo and your full path to a table is database.dbo.tablename. Perhaps it is databasename.somethingyoudontpect.tablename. Perhaps you need to look at altering the owner or schema of the table instead of the actual name. What version of SQL server are you on again? I'm not sure if I've ever had one table name show up, but when I go to rename it, another one appears. Also, what happens when you try and script a rename? http://technet.microsoft.com/en-us/library/aa275462%28SQL.80%29.aspx ~Brad Original Message Subject: re: SQL Server question re table names - still stuck From: Larry Soo l...@bc4x4.com Date: Fri, December 11, 2009 3:07 am To: cf-talk cf-talk@houseoffusion.com How many tables are there? If there are under 75, you might be just as fast renaming them them by hand. Well, I tried renaming them by hand but it won't work. Using the SQL Server Manger, I right-clicked on the table and then clicked on RENAME. The table name, when I right-clicked on it, said something like: abc.city. But when the RENAME edit box came up, it contained only city. So the table isn't actually named abc.city. It is only presenting the table that way, and when I do a query in CF, it expects me to also refer to the table with that database name prefix. Hmm...ok, here's the exact scenario: 1) I'm imported the data from a backup file and named the database canadianofficespace. 2) When I look at the tables in SQL Server Manager, it prefixes every table name with canadianofficespacecom, which is not the name of the database. I presume it's the name of the database that it originally came from. 3) When I do a CFQuery, it won't work unless I write the table name as canadianofficespacecom.city, instead of just city. Can anyone help me out here? This is well beyond my SQL Server knowledge. ...lars ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9 instance in CF8 multiserver - context root problem?
that's exactly how i have it - a different jrun directive in the cf9 vhost. this is in my httpd.conf: IfModule mod_jrun22.c JRunConfig Verbose false JRunConfig Apialloc false JRunConfig Ignoresuffixmap false JRunConfig Serverstore D:/JRun4/lib/wsconfig/1/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51020 AddHandler jrun-handler .cfm .cfc .cfr /IfModule and this is my vhost def for cf9: VirtualHost 127.0.0.1:80 DocumentRoot D:/Inetpub/cf9root ServerName cf9dev ServerAlias cf9dev Alias /CFIDE/ D:/JRun4/servers/cf9/cfusion-ear/cfusion-war/CFIDE/ JRunConfig Apialloc false JRunConfig Serverstore D:/JRun4/lib/wsconfig/cf9/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51002 Directory D:\JRun4\servers\cf9\cfusion-ear\cfusion-war\CFIDE Options Indexes FollowSymLinks AllowOverride None Order allow,deny Allow from all /Directory ErrorLog logs/cf9dev-error.log CustomLog logs/cf9dev-access.log common /VirtualHost i guess something else is at play here... Azadi Saryev On 12/12/2009 00:39, Dave Watts wrote: setting up virtual Apache servers - something tells me it is not the same as vhosts, is it? but google seems to think it is... could you point me to where i can find more info on how to set them up? Yes, it's the same. You have to put the instance-specific JRun directives in each vhost, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cftransaction
I'm pretty sure the rollback is not occurring because your cfstoredproc call inside your saveDataToDatabase() function is running in it's own transaction. I think you'd need to include a rollback; command inside your stored procedure if you have a failure. Dave -Original Message- From: Christophe Maso [mailto:zum...@hotmail.com] Sent: Friday, December 11, 2009 10:12 AM To: cf-talk Subject: cftransaction Hi all, I understand the gist of cftransaction, but I've tried using it with a conditional rollback on an action page in the below example and it doesn't seem to work. saveDataToDatabase() submits data to a stored procedure, which always returns a string: empty string if the data was saved, or a message stating what the problem was if not. cfset allReturnMessages = cftransaction cfloop cfset returnMessage = someCFC.saveDataToDatabase() cfset allReturnMessages = allReturnMessages returnMessage br /cfloop cfif len(trim(allReturnMessages)) cftransaction action=rollback / /cfif /cftransaction I'm not including cftry in this example, just to illustrate that I'm not looking for a database or other type of CF error per se - rather, I'm looking for any return message from the stored proc that isn't an empty string, such as sorry - everything is otherwise kosher, but this stored proc is coded not to save the data if field x is above value y. That's not a database error as far as CF is concerned, so cftry wouldn't catch it. But in testing this code, I've found that the rollback doesn't take place, even when the cfif statement is true. Am I not using cftransaction correctly? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Working With Images
Yes, google cfimage and check out the google docs, etc. After checking that out, let me know if you need any more assistance understanding how to put it all together. Rick -Original Message- From: Jessica Kennedy [mailto:police_kidnapped_your_child...@yahoo.com] Sent: Friday, December 11, 2009 10:43 AM To: cf-talk Subject: Re: Working With Images try googling cfimage, or if you like learning by example, download galleon forums and play around with the avatar uploader. i'm sure there are more (and possibly better) examples but it's the first thing that comes to mind Hello. I was ask to help build a dynamic website for a volunteer fire department were they could add news and photos. Iââ¬â¢m having trouble with the photos. Does anybody know of a free or paid website were I can find some coldfusion code to add, edit, update, and delete images. I would like to be able to add the images to a database and have CF8 crop the images too. Thanks for your time, Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftransaction
The way the code is written, the cfif will never be true because it will always have br in so the length will never be below 4. Hi all, I understand the gist of cftransaction, but I've tried using it with a conditional rollback on an action page in the below example and it doesn't seem to work. saveDataToDatabase() submits data to a stored procedure, which always returns a string: empty string if the data was saved, or a message stating what the problem was if not. cfset allReturnMessages = cftransaction cfloop cfset returnMessage = someCFC.saveDataToDatabase() cfset allReturnMessages = allReturnMessages returnMessage br /cfloop cfif len(trim(allReturnMessages)) cftransaction action=rollback / /cfif /cftransaction I'm not including cftry in this example, just to illustrate that I'm not looking for a database or other type of CF error per se - rather, I'm looking for any return message from the stored proc that isn't an empty string, such as sorry - everything is otherwise kosher, but this stored proc is coded not to save the data if field x is above value y. That's not a database error as far as CF is concerned, so cftry wouldn't catch it. But in testing this code, I've found that the rollback doesn't take place, even when the cfif statement is true. Am I not using cftransaction correctly? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working With Images
Barry, Try installing this product I built. It handles single level categories and uses fckeditor for editing the image description but also does sorting, crop, rotate, many categories to one image relationships, etc. It also works with mysql and mssql. http://cfimagemanager/downloads/cfimagemanager_5.7.09.4pm.zip Send me an email offline using the contact form. http://cfimagemanager.com/contact.cfm This is something I build, had plans on supporting and extending but other projects got in the way. You need to download and install fckeditor, have cf8 on your server and have a datasource to mysql or mssql for it to work properly. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftransaction
Nevermind, I read the cfif backwards. I was thinking it was looking for an empty string. In that case, the cfif will always be true. This doesn't explain the rollback issue, but once the rollback is fixed, it will always rollback. Do you have any commits in your stored procedure? If so, the rollback will be after the commit and won't matter? I beleive a GO statement will also commit and the rollback will be too late. The way the code is written, the cfif will never be true because it will always have br in so the length will never be below 4. Hi all, I understand the gist of cftransaction, but I've tried using it with a conditional rollback on an action page in the below example and it doesn't seem to work. saveDataToDatabase() submits data to a stored procedure, which always returns a string: empty string if the data was saved, or a message stating what the problem was if not. cfset allReturnMessages = cftransaction cfloop cfset returnMessage = someCFC.saveDataToDatabase() cfset allReturnMessages = allReturnMessages returnMessage br /cfloop cfif len(trim(allReturnMessages)) cftransaction action=rollback / /cfif /cftransaction I'm not including cftry in this example, just to illustrate that I'm not looking for a database or other type of CF error per se - rather, I'm looking for any return message from the stored proc that isn't an empty string, such as sorry - everything is otherwise kosher, but this stored proc is coded not to save the data if field x is above value y. That's not a database error as far as CF is concerned, so cftry wouldn't catch it. But in testing this code, I've found that the rollback doesn't take place, even when the cfif statement is true. Am I not using cftransaction correctly? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9 instance in CF8 multiserver - context root problem?
that's exactly how i have it - a different jrun directive in the cf9 vhost. Set up separate vhosts for each. Each should have its own settings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9 instance in CF8 multiserver - context root problem?
i went and manually edited the context-root setting in the instance's jrun-web.xml and all is good now! trying to set context root to / in JMC did not work, but manually editing jrun-web.xml did the trick. strangely, though, in JMC now the instance's context root appears just empty, not / ... also, i was under the impression that the instance's context root setting was set in cfusion-ear\META-INF\application.xml, but apparently it is not as i had it set to / there all along... bonus - i do not have to use /cf9 in the urls any more either. thanks for your help, Dave! you got me looking into more things and i finally figured it out. jrun's livedocs were surprisingly helpful in pointing me to the context-root in jrun-web.xml Azadi Saryev On 12/12/2009 00:39, Dave Watts wrote: setting up virtual Apache servers - something tells me it is not the same as vhosts, is it? but google seems to think it is... could you point me to where i can find more info on how to set them up? Yes, it's the same. You have to put the instance-specific JRun directives in each vhost, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftransaction
Good catch - you're right; I would normally include a cfif to append the return string and the br to allReturnMessages only if the return string isn't empty. The stored proc was written by someone else, so I'm not 100% sure what's happening with it, which is part of the problem. I suppose what I should be asking is - is it even possible to do what I'm trying to do? Which is, loop over a variable number of records to be saved or updated, and after the loop has finished, test to see if ANY of them have gotten a positive-length string back from the proc, and if so, rol lback ALL of them? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF9 instance in CF8 multiserver - context root problem?
yea, i do have a separate named vhost set up for each website. but you do not need separate jrun settings for each vhost - only for those that must use a server instance different from the global one defined in httpd.conf (in my case all my other sites use a cf8 instance; only one uses cf9 for testing/playing) Azadi Saryev On 12/12/2009 02:13, Dave Watts wrote: Set up separate vhosts for each. Each should have its own settings. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Faster SMTP
I've never used the Windows SMTP service for this, anyone know if it runs multiple threads and how configurable it is? It does, and it's smoking fast. As for configurable, it takes mail and sends it out, not a lot of options there. It does give you some control over where to copy bounces to, what IP to send from, etc. -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Faster SMTP
This is an actual mail server though correct? My mail server is not the issue it spools out fine. It's the CF Spooler that is my bottleneck. Bypass it. Some mail servers have a place where a message file can be written or copied to and it will pick it up and process it. The Microsoft SMTP spooler has a folder under mailroot called pickup specifically for this purpose. ModusMail has a similar option. I'm not sure about MDaemon and Smartermail, but they're fairly mature products and I'd expect they do as well. You can write files out a lot faster than CF's spooler can move the mail via SMTP. -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Faster SMTP
So all I would need to do is recreate the txt file that is those .cfmail files or is there more to it than that? Thanks, Patrick J Hedgepath Pegasus Web Productions webmas...@pegweb.com (803)-996-0578 On Dec 11, 2009, at 2:11 PM, Justin Scott jscott-li...@gravityfree.com wrote: This is an actual mail server though correct? My mail server is not the issue it spools out fine. It's the CF Spooler that is my bottleneck. Bypass it. Some mail servers have a place where a message file can be written or copied to and it will pick it up and process it. The Microsoft SMTP spooler has a folder under mailroot called pickup specifically for this purpose. ModusMail has a similar option. I'm not sure about MDaemon and Smartermail, but they're fairly mature products and I'd expect they do as well. You can write files out a lot faster than CF's spooler can move the mail via SMTP. -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Faster SMTP
There is more to it than that. Javamail translates the spooler file into smtp commands which result in the file on the SMTP server. Get ahold of one of the .eml files from the /queue directory of the IIS SMTP server.. That's the one you need to emulate. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: Friday, December 11, 2009 1:14 PM To: cf-talk Subject: Re: Faster SMTP So all I would need to do is recreate the txt file that is those .cfmail files or is there more to it than that? Thanks, Patrick J Hedgepath Pegasus Web Productions webmas...@pegweb.com (803)-996-0578 On Dec 11, 2009, at 2:11 PM, Justin Scott jscott-li...@gravityfree.com wrote: This is an actual mail server though correct? My mail server is not the issue it spools out fine. It's the CF Spooler that is my bottleneck. Bypass it. Some mail servers have a place where a message file can be written or copied to and it will pick it up and process it. The Microsoft SMTP spooler has a folder under mailroot called pickup specifically for this purpose. ModusMail has a similar option. I'm not sure about MDaemon and Smartermail, but they're fairly mature products and I'd expect they do as well. You can write files out a lot faster than CF's spooler can move the mail via SMTP. -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Faster SMTP
So all I would need to do is recreate the txt file that is those .cfmail files or is there more to it than that? Those are formatted specifically for ColdFusion. Most mail servers want a .msg file formatted with all of your usual headers, one per line, then two line breaks and the message body, such as: To: someone some...@example.com From: sender sen...@example.com Subject: Some subject line Reply-To: re...@example.com Your message here... -- Justin Scott | GravityFree The Smart Business Web Agency 1960 Stickney Point Road, Suite 210 Sarasota, FL 34231 941.927.7674 x115 800.207.4431 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftransaction
The way the CFTransaction tag works is CF is putting the TRANSACTION statements in the T-SQL it sends to the server. So the rollback tag will rollback any transactions that haven't been committed. You could have 100's of queries running with Inserts/deletes/updates and everything will rollback. It's the same if you wrote a T-SQL and started it with BEGIN TRANSACTION and ended it with ROLLBACK TRANSACTION. This is great way to test stuff, because nothing gets committed, but all of the steps occur. Good catch - you're right; I would normally include a cfif to append the return string and the br to allReturnMessages only if the return string isn't empty. The stored proc was written by someone else, so I'm not 100% sure what's happening with it, which is part of the problem. I suppose what I should be asking is - is it even possible to do what I'm trying to do? Which is, loop over a variable number of records to be saved or updated, and after the loop has finished, test to see if ANY of them have gotten a positive-length string back from the proc, and if so, rol lback ALL of them? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftransaction
I suppose what I should be asking is - is it even possible to do what I'm trying to do? Yes. Unless, as someone else mentioned, the procedure you are calling is using its own transaction. Is it? -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working With Images
Hi Rick. I already tried googling cfimage but I have been unsuccessful in finding any good CRUD with CF8 Images. Barry Yes, google cfimage and check out the google docs, etc. After checking that out, let me know if you need any more assistance understanding how to put it all together. Rick -Original Message- From: Jessica Kennedy [mailto:police_kidnapped_your_child...@yahoo. com] Sent: Friday, December 11, 2009 10:43 AM To: cf-talk Subject: Re: Working With Images try googling cfimage, or if you like learning by example, download galleon forums and play around with the avatar uploader. i'm sure there are more (and possibly better) examples but it's the first thing that comes to mind Hello. I was ask to help build a dynamic website for a volunteer fire department were they could add news and photos. Iââ¬â¢m having trouble with the photos. Does anybody know of a free or paid website were I can find some coldfusion code to add, edit, update, and delete images. I would like to be able to add the images to a database and have CF8 crop the images too. Thanks for your time, Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Faster SMTP (Infusion Mailserver...)
Erik, You said We're using Infusion Mail server for this kinf of thing. Works really well and its really fast. When was the last time you were able to contact **anyone** at infusion? As far as I know they are no longer in business and its impossible to reach anyone there. I am also using infusion mailserver and I love it, but it looks like there toe up, so I would be careful about recommending them. Correct me if I'm wrong, I really hope I am wrong cause I want to buy a new license but there nobody home. Does Anyone have any info on this?? Brook -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: December-11-09 7:55 AM To: cf-talk Subject: RE: Faster SMTP This is an actual mail server though correct? My mail server is not the issue it spools out fine. It's the CF Spooler that is my bottleneck. -Original Message- From: Erik-Jan Jaquet [mailto:erik...@toomba.nl] Sent: Thursday, December 10, 2009 10:44 AM To: cf-talk Subject: Re: Faster SMTP We're using Infusion Mail server for this kinf of thing. Works really well and its really fast. http://www.coolfusion.com/downloads/index.cfm?CFID=951923CFTOKEN=252379 43 Kind regards, Erik-Jan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: SQL Server question re table names - still stuck
Recap of problem: I imported an old, backed up SQL Server file. Now, when I view the tables or try to access them in CF, it requires me to prefix all table names with canadianofficespacecom.. Ezra Parker wrote: I didn't see a mention of which version of SQL Server you're running, but it sounds to me like canadianofficespacecom is either an object owner or a schema: I'm using SQL Server 2008...and the database is a few years old...possibly pre-dating 2005 or even older. I'm assuming that it's most likely SQL Server 2005 or 2008, in which case the simplest fix would probably be to change the default schema for the user that you specified in your CF datasource. To do this, access the properties for the user in question and you will see a default schema field -- change the value to canadianofficespacecom and you should then be able to query the tables without the prefix. I tried that. The username I was using is SA. The default schema was master so I changed it to canadianofficespacecom. The weird thing is that when I click on the OK button and the dialog closes, when I re-open it, it still shows the default schema as being master. It doesn't report an error. brad wrote: What version of SQL server are you on again? I'm not sure if I've ever had one table name show up, but when I go to rename it, another one appears. Also, what happens when you try and script a rename? I haven't tried to script a rename because the manual renaming didn't work. FYI I'm on SQL Server 2008. Here's a screen shot of the users and schemas: http://www.bc4x4.com/temp/cos-screenshot.jpg BTW, when I look at user dbo, I see that its Database Role Membership lists it as having db_owner status. So would I be correct in assuming that the problem I'm having is that the default schema for dbo is master instead of canadianofficespacecom? (Thank you to everyone for your help so far.) ...lars ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329113 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
For consideration...
I'm tired of writing form input validation routines over and over again. Using CFINPUT and its validation options work great for the front end, but it's still a pain to write input validation on the server-side, and the rules between the two can get out of sync, and the built-in validation rules don't have as much flexibility as server-side rules do. I'm working on a project where I have some flexible time to write a new tool and wanted to see if there would be any interest in the community in a tool defined as such: A form library that would allow a form with all of its properties and validation requirements to be defined in one place (likely a JSON file) which would then 1) Generate the form for display (optional), 2) provide for AJAX-based client-side validation, and 3) provide server-side validation. The core library would have a number of built-in validation options and allow for new rules to be added as needed without changing the core library files. My thought is that this would help speed development by centralizing form definitions and properties and make input validation on both the client and server side consistent and reliable without having to constantly write and rewrite huge blocks of cfif/cfelseif code for each form. Thoughts? Opinions? Bad idea? Someone already release something that does this? If it sounds like something you could use, please let me know. If it's pursued, it would be released free for the community to use, but I don't want to waste time building it if something similar exists or nobody else could benefit from it. Any feedback appreciated. -Justin Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329114 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: For consideration...
I like it in principle but what is your idea of ajax based server side validation... Server side validation needs to always be done prior to the server uitlizing the inputs (inserting into the DB etc). You can't validate using an ajax request and THEN submit the form values using a submit request... You sumbit the form and then validate... Otherwise your validation is easily circumvented and of no value... Right? Am I missing something? Are you talking about ajax submissions encorporating validation? -Mark -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Friday, December 11, 2009 4:55 PM To: cf-talk Subject: For consideration... I'm tired of writing form input validation routines over and over again. Using CFINPUT and its validation options work great for the front end, but it's still a pain to write input validation on the server-side, and the rules between the two can get out of sync, and the built-in validation rules don't have as much flexibility as server-side rules do. I'm working on a project where I have some flexible time to write a new tool and wanted to see if there would be any interest in the community in a tool defined as such: A form library that would allow a form with all of its properties and validation requirements to be defined in one place (likely a JSON file) which would then 1) Generate the form for display (optional), 2) provide for AJAX-based client-side validation, and 3) provide server-side validation. The core library would have a number of built-in validation options and allow for new rules to be added as needed without changing the core library files. My thought is that this would help speed development by centralizing form definitions and properties and make input validation on both the client and server side consistent and reliable without having to constantly write and rewrite huge blocks of cfif/cfelseif code for each form. Thoughts? Opinions? Bad idea? Someone already release something that does this? If it sounds like something you could use, please let me know. If it's pursued, it would be released free for the community to use, but I don't want to waste time building it if something similar exists or nobody else could benefit from it. Any feedback appreciated. -Justin Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329115 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: For consideration...
I haven't tried these but they may be what you are looking for http://www.validatethis.org/ http://www.validatethis.org/http://thor.riaforge.org/ http://thor.riaforge.org/ 2009/12/12 Justin Scott jscott-li...@gravityfree.com I'm tired of writing form input validation routines over and over again. Using CFINPUT and its validation options work great for the front end, but it's still a pain to write input validation on the server-side, and the rules between the two can get out of sync, and the built-in validation rules don't have as much flexibility as server-side rules do. I'm working on a project where I have some flexible time to write a new tool and wanted to see if there would be any interest in the community in a tool defined as such: A form library that would allow a form with all of its properties and validation requirements to be defined in one place (likely a JSON file) which would then 1) Generate the form for display (optional), 2) provide for AJAX-based client-side validation, and 3) provide server-side validation. The core library would have a number of built-in validation options and allow for new rules to be added as needed without changing the core library files. My thought is that this would help speed development by centralizing form definitions and properties and make input validation on both the client and server side consistent and reliable without having to constantly write and rewrite huge blocks of cfif/cfelseif code for each form. Thoughts? Opinions? Bad idea? Someone already release something that does this? If it sounds like something you could use, please let me know. If it's pursued, it would be released free for the community to use, but I don't want to waste time building it if something similar exists or nobody else could benefit from it. Any feedback appreciated. -Justin Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329116 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: For consideration...
I like it in principle but what is your idea of ajax based server side validation... Server side validation needs to It would use JavaScript to push the form data to a validation routine on the server before the form is posted to give the user a better experience as a preferred method. If JavaScript were disabled then the form would post and the form data would be run through the validation process on the server as a fall-back. It would use the same validation engine for client-side and server-side so they would always be in sync and follow the same rules and not be able to be bypassed. -Justin Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: For consideration...
The app can do both. The idea is to write one set of server-side validation routines in CF. The app then uses AJAX to check fields as the used fills them out, for the benefit of the user; it also checks them server side on submission to ensure data integrity and prevent circumvention of the validation routines. A framework to easily apply the validation at both ends would make it all a low maintenance thing - the validation need only be written once and can be maintained in one place. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/12/12 Mark Kruger mkru...@cfwebtools.com: You can't validate using an ajax request and THEN submit the form values using a submit request... You sumbit the form and then validate... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: For consideration...
I haven't tried these but they may be what you are looking for http://www.validatethis.org/ That looks very promising and similar to what I had in mind. I certainly don't want to reinvent the wheel if this does what it appears to say it does. I'll check it out over the weekend and post back. -Justin Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: For consideration...
Got... Clever. I see exactly what you are getting at. The use of ajax for client side makes the validation run the exact same routines. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Friday, December 11, 2009 5:35 PM To: cf-talk Subject: Re: For consideration... The app can do both. The idea is to write one set of server-side validation routines in CF. The app then uses AJAX to check fields as the used fills them out, for the benefit of the user; it also checks them server side on submission to ensure data integrity and prevent circumvention of the validation routines. A framework to easily apply the validation at both ends would make it all a low maintenance thing - the validation need only be written once and can be maintained in one place. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/12/12 Mark Kruger mkru...@cfwebtools.com: You can't validate using an ajax request and THEN submit the form values using a submit request... You sumbit the form and then validate... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server question re table names - still stuck
On Fri, Dec 11, 2009 at 2:53 PM, Larry Soo l...@bc4x4.com wrote: So would I be correct in assuming that the problem I'm having is that the default schema for dbo is master instead of canadianofficespacecom? I believe so, yes. In order to resolve this from the user side of things you're going to need to connect as a different user, as you will not be able to change the default schema of the sa user, as noted here: http://msdn.microsoft.com/en-us/library/ms176060.aspx The value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role. All members of the sysadmin fixed server role have a default schema of dbo. So I would suggest creating a canadianofficespacecom login to correspond to the canadianofficespacecom user in your DB, and then executing the following T-SQL script: USE canadianofficespace; ALTER USER canadianofficespacecom WITH LOGIN = canadianofficespacecom, DEFAULT_SCHEMA = canadianofficespacecom; GO (As a side note, I had thought you could change the default schema in the GUI interface, but after trying it out it appears I was mistaken about this -- sorry for the misinformation there.) If this runs successfully, then change the DSN to connect with the new user name and password and you should be good to go. The alternative option would be to change the schema for the tables to dbo, but if it were me I would prefer changing users anyway in order to avoid connecting as sa. Please post back if you run into any problems. -- Ezra Parker ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4