Re: SQL question

2009-02-16 Thread Brian Kotek
I've always known it as selecting a literal value. So "SELECT 1" is "select the literal value 1". On Mon, Feb 16, 2009 at 7:41 PM, Mike Soultanian wrote: > > I was curious if anyone knows how you describe the following SQL > functionality: > > SELECT 'mike' as name > > returns a single column n

Re: Railo Install on JBoss?

2009-02-16 Thread Paul Hastings
Jeff Chastain wrote: > First off, is there a mailing list / forum for Railo? I looked around the > Railo site and did not see anything obvious there. http://tech.groups.yahoo.com/group/railo_talk/ ~| Adobe® ColdFusion® 8 softw

RE: Is it possible to use cflocation in a cffunction?

2009-02-16 Thread Rick Faircloth
Nevermind...found it. I had removed the comma after formval, before the success area. (I knew it would have nothing to do with a "}" directly... > -Original Message- > From: Rick Faircloth [mailto:r...@whitestonemedia.com] > Sent: Monday, February 16, 2009 10:34 PM > To: cf-talk > Subje

Railo Install on JBoss?

2009-02-16 Thread Jeff Chastain
First off, is there a mailing list / forum for Railo? I looked around the Railo site and did not see anything obvious there. Second, I am trying to setup Railo on a JBoss 5.0 server. I pulled down the latest WAR file from the Railo site, and exploded it to \server\default\deploy\railo.war.

RE: Is it possible to use cflocation in a cffunction?

2009-02-16 Thread Rick Faircloth
Hmmm...I'm getting this error now: "missing } after property list" "success: function(response) {\n" which refers to this section: success: function(response) { location.href = "floor_duty_

RE: Is it possible to use cflocation in a cffunction?

2009-02-16 Thread Rick Faircloth
Alright! That sounds good. Thanks for the tip, Jason! Rick > -Original Message- > From: Jason Fisher [mailto:ja...@wanax.com] > Sent: Monday, February 16, 2009 9:29 PM > To: cf-talk > Subject: Re: Is it possible to use cflocation in a cffunction? > > > Ajax doesn't run in the calling

Re: Is it possible to use cflocation in a cffunction?

2009-02-16 Thread Jason Fisher
Ajax doesn't run in the calling page's request, it runs in its own request and "comes back" to the calling page via your designated callback function. So, send a packet back to the callback that sets a local var for the selected_date and then triggers: location.href = "../cfm/floor_duty_print

Is it possible to use cflocation in a cffunction?

2009-02-16 Thread Rick Faircloth
I know this is probably a bit of "hackery", but... I'm trying to find an easy way to go from a jQuery AJAX function to a cffunction method, then from there, use a cflocation to jump to a page to print a schedule. I send my variables to the method via AJAX, (there's not an actual form on the page

Re: SQL question

2009-02-16 Thread Dave Watts
> I was curious if anyone knows how you describe the following SQL > functionality: > > ... > > The last one is obvious as it's SQL arithmetic, but what are the first > two examples? Are those also examples of "SQL arithmetic" as well? I > can't find this kind of SQL functionality described or d

Re: SQL question

2009-02-16 Thread Mike Kear
The first two examples are selecting the literal value 'mike' and '1' In the first example, you are telling SQL to give the column containing 'mike' a name of 'name'. A practical example of where you might use this behaviour might be : SELECT 'Invoice' as doctype, invoiceno, invoicedate, am

SQL question

2009-02-16 Thread Mike Soultanian
I was curious if anyone knows how you describe the following SQL functionality: SELECT 'mike' as name returns a single column named "name" with a single row containing "mike" I also know you can do stuff like: SELECT 1 Which returns a column named "1" with a single row containing "1", or: S

Re: SQL Replication Models

2009-02-16 Thread Don L
>> Those do not appear to be very challenging requirements. You could >> probably even do this without any of the built-in replication at all >> but with just incremental backups. How have you currently configured >> your backups? Do you notice a performance impact when you run a full >> backup? D

Re: Setting row colors dynamically with cfgrid AJAX

2009-02-16 Thread Jason Fisher
Not directly related to the cfgrid question, but if you think you're having trouble with blocks needing to be in the for any reason (browser or otherwise), try this: