re: SQL Server question re table names - still stuck

2009-12-11 Thread Larry Soo

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?

2009-12-11 Thread Azadi Saryev

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

2009-12-11 Thread Ezra Parker

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

2009-12-11 Thread Leigh

 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?

2009-12-11 Thread Glyn Jackson

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

2009-12-11 Thread Barry Mcconaghey

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?

2009-12-11 Thread Leigh

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?

2009-12-11 Thread Jason Fisher

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?

2009-12-11 Thread Dave Watts

 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?

2009-12-11 Thread Azadi Saryev

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

2009-12-11 Thread webmaster

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

2009-12-11 Thread Jessica Kennedy

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

2009-12-11 Thread Rick Faircloth

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?

2009-12-11 Thread Dave Watts

 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

2009-12-11 Thread Christophe Maso

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

2009-12-11 Thread brad

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?

2009-12-11 Thread Azadi Saryev

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

2009-12-11 Thread Dave Phillips

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

2009-12-11 Thread Rick Faircloth

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

2009-12-11 Thread Donnie Carvajal

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

2009-12-11 Thread Tony Bentley

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

2009-12-11 Thread Donnie Carvajal

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?

2009-12-11 Thread Dave Watts

 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?

2009-12-11 Thread Azadi Saryev

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

2009-12-11 Thread Christophe Maso

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?

2009-12-11 Thread Azadi Saryev

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

2009-12-11 Thread Justin Scott

 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

2009-12-11 Thread Justin Scott

 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

2009-12-11 Thread webmaster

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

2009-12-11 Thread Mark Kruger

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

2009-12-11 Thread Justin Scott

 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

2009-12-11 Thread Donnie Carvajal

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

2009-12-11 Thread Leigh

 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

2009-12-11 Thread Barry Mcconaghey

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...)

2009-12-11 Thread Brook Davies

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

2009-12-11 Thread Larry Soo

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...

2009-12-11 Thread Justin Scott

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...

2009-12-11 Thread Mark Kruger

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...

2009-12-11 Thread Kevan Stannard

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...

2009-12-11 Thread Justin Scott

 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...

2009-12-11 Thread James Holmes

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...

2009-12-11 Thread Justin Scott

 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...

2009-12-11 Thread Mark Kruger

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

2009-12-11 Thread Ezra Parker

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