Re: SQL Server question re table names - still stuck

On Fri, Dec 11, 2009 at 2:53 PM, Larry Soo 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 nee

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 [mailt

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

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 valida

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

Re: For consideration...

I haven't tried these but they may be what you are looking for http://www.validatethis.org/ http://thor.riaforge.org/ 2009/12/12 Justin Scott > > I'm tired of writing form input validation routines over and over again. > Using CFINPUT

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 reques

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 d

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

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 inf

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

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

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 rollbac

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 bo

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)

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" wrote: > >> This is an actual mail server thoug

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

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

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 tes

Re: cftransaction

Good catch - you're right; I would normally include a cfif to append the return string and the "" 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 wha

Re: CF9 instance in CF8 multiserver - context root problem?

i went and manually edited the 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 un

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 traini

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, th

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/cfimage

Re: cftransaction

The way the code is written, the cfif will never be true because it will always have "" 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 t

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 1

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

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: JRunConfig Verbose false JRunConfig Apialloc false JRunConfig Ignoresuffixmap false JRunConfig Serverstore "D:/JRun4/lib/wsconfig/1/jrunserver.store" JRunConfig Bootstrap 127

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

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

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, t

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

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

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 SMT

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

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 instal

re: detect multiples?

The following will only execute the stuff inside the CFIF statement if the count is *not* a multiple of 6. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion maili

Re: detect multiples?

You can use the modulus operator (ie MOD) the number is a multiple of 6 .. or the value is 0 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing list

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

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 th

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 someth

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

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

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 Ser