Coldfusion fails to start

2011-08-19 Thread Duncan

Hi Folks,

I have been patching up a new CF801 install today, and have reached the
point of running the Jrun updater 7.

Up to this point I had successfully installed patches and had CF running
fine on the built in JVM, and then on 6u27.

To install updater 7, I had to install JDK 1.4.2_19 so the installer would
work. Having done that, and having both JVM's installed, I happily ran the
updater to Jrun4 update 7

CF will now not restart. I have put the JVM config, and followed the steps
on a cftalk thread that reports exactly the same error as I have

in the c:\Jrun4\logs\admin-out.log I see this:

Error loading: C:/Program Files/Java/jdk1.6.0_27/jre\bin\server\jvm.dll
Error loading: C:/JRun4/jre\bin\server\jvm.dll

I have uninstalled the 6u27, restarted etc and cant get a win here.

I also followed a thread about msvcr71.dll creeping in somewhere, and have
spotted this, and replaced the file, although the file sizes were identical.


I have not gone to a reinstall of CF yet, because I am hoping someone can
shed some light on this for me.

Any help greatly appreciated.

64bit CF801 Enterprise, std JVM. Standalone machine with Win 2008 web
edition, 64 bit. Done the 801 updater 4 as well, everything was running fine
until doing the 1.4 and jrun updater. .

-- 
Duncan I Loxton
duncan.lox...@gmail.com


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346858
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Coldfusion fails to start

2011-08-19 Thread Wil Genovese

Read this and see if it covers your situation 

http://www.trunkful.com/index.cfm/2011/3/31/ColdFusion-Security-Update-Breaks-ColdFusion

Wil Genovese

One man with courage makes a majority. - Andrew Jackson


On Aug 19, 2011, at 2:27 AM, Duncan duncan.lox...@gmail.com wrote:

 
 Hi Folks,
 
 I have been patching up a new CF801 install today, and have reached the
 point of running the Jrun updater 7.
 
 Up to this point I had successfully installed patches and had CF running
 fine on the built in JVM, and then on 6u27.
 
 To install updater 7, I had to install JDK 1.4.2_19 so the installer would
 work. Having done that, and having both JVM's installed, I happily ran the
 updater to Jrun4 update 7
 
 CF will now not restart. I have put the JVM config, and followed the steps
 on a cftalk thread that reports exactly the same error as I have
 
 in the c:\Jrun4\logs\admin-out.log I see this:
 
 Error loading: C:/Program Files/Java/jdk1.6.0_27/jre\bin\server\jvm.dll
 Error loading: C:/JRun4/jre\bin\server\jvm.dll
 
 I have uninstalled the 6u27, restarted etc and cant get a win here.
 
 I also followed a thread about msvcr71.dll creeping in somewhere, and have
 spotted this, and replaced the file, although the file sizes were identical.
 
 
 I have not gone to a reinstall of CF yet, because I am hoping someone can
 shed some light on this for me.
 
 Any help greatly appreciated.
 
 64bit CF801 Enterprise, std JVM. Standalone machine with Win 2008 web
 edition, 64 bit. Done the 801 updater 4 as well, everything was running fine
 until doing the 1.4 and jrun updater. .
 
 -- 
 Duncan I Loxton
 duncan.lox...@gmail.com
 
 
 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346859
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Invoke Java method

2011-08-19 Thread Isidro Pimentel

Thank you soo much for your help. I am starting to get it but now I am
getting another error Missing argument name.
When using named parameters to a function, every parameter must have a
name.

(JavaCast(string,getPageContext().getServletContext()),JavaCast(string,
getPageContext().getResponse()),JavaCast(string,getPageContext().getAuthn
Context),JavaCast(string,SESSION.mail),(string,getPageContext().getattr
ibutes));



On 8/18/11 3:06 PM, Leigh cfsearch...@yahoo.com wrote:


 They are strings. Additionally, all of those values for now
 are null except mail which is a session variable.

I am not sure what you mean by null in this context ;) Are you saying
you are not sure what to pass into the method OR that the method allows
to skip those parameters and pass in null (ie nothing)?

If it is the former, those are java objects. You can grab them from the
getPageContext() function.

ie getPageContext().getServletContext()
ie getPageContext().getResponse()

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e
0811cbec22c24-787f.html




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


(ot) MS SSIS (BIDS) 2008 options

2011-08-19 Thread DURETTE, STEVEN J (ATTASIAIT)

Hi all,

Sorry for the OT, but my Google foo has failed me!

When trying to save a SSIS package to a server one of the options is Protection 
Level and it defaults to Encrypt data with User Key. The policy in our shop 
is to use Rely on server storage and roles for access control. It is a major 
annoyance to always have to change it and when people forget we have to delete 
the package and start over again.  Does anyone know if there is an xml file or 
something we can edit to change the default?

Thanks,
Steve


__


Steven Durette
SR Specialist - Application Developer

ATT

Network - Construction  Engineering
2020 Bancroft St, Server Room (8)
Port Huron, MI 48060
P: 810.984.6684
F: 810.984.9649
M: 810.841.4829
steven.j.dure...@att.com

att.com

[att_rp_hz_email_signature.jpg]



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346861
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Can't Delete Sessions Programmatically

2011-08-19 Thread Pete Freitag

On Thu, Aug 18, 2011 at 5:50 PM, Richard Steele r...@photoeye.com wrote:


 Thanks Peter, that's helpful. Any thoughts about the Session is Invalid
 problem? Richard.


One cause for that exception is if your session variable timeouts don't
match the J2EE session timeout (configured in jrun-web.xml and defaults to
30 minutes).

So if the J2EE timeout is less than your session timeout, you can run into
this condition. One thing that might remedy the situation would be to add
the following to your onSessionStart() in Application.cfc:

cfset
getPageContext().getRequest().getSession().setMaxInactiveInterval(numSeconds)


Where numSeconds matches the length of your ColdFusion session timeout. I've
never tried that solution, but it seams to me like it might work, please let
us know.


--
Pete Freitag - Adobe Community Professional
http://foundeo.com/ - ColdFusion Consulting  Products
http://petefreitag.com/ - My Blog
http://hackmycf.com - Is your ColdFusion Server Secure?


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346862
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Email Labs Mailing List API

2011-08-19 Thread Brian Cain

Does anyone have experience setting up an API call to the EMailLabs API?  It 
accepts SOAP requests, but I am looking for a little jump start.

Thanks,
Brian Cain 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Invoke Java method

2011-08-19 Thread Leigh

Think about what the code is doing for a second :) It is still trying to pass 
in all strings instead of a mix of strings and complex objects. 

It may not seem like it, but using a java method is not much different than 
calling a plain old CF function. Both define what arguments they expect as well 
the type (array, date, string, etcetera).

Take the CF function arrayLen(). It expects to receive an array and complains 
loudly if you accidentally pass in the wrong type of value, like a string or 
number: 

   cfset x = arrayLen(thisWillFail)

That is what your current code is doing. It is passing in the right +number+ of 
arguments. They are just the wrong type of values.

  sendResponse(javax.servlet.ServletContext, )

sendReponse expects a javax.servlet.ServletContext object as the first 
argument. Do a cfdump of getPageContext().getServletContext(). You will see 
that is exactly what it returns. But instead of passing it in as is, the code 
tries to convert it into string first:

JavaCast(string, getPageContext().getServletContext() )

Obviously that does work because your method exepcts a ServletContext object 
there, not a string. So get rid of the javacast. In fact get rid of all of 
them. I doubt you even need them to call this particular method.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346864
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: (ot) MS SSIS (BIDS) 2008 options

2011-08-19 Thread Mike Chabot

Steve,
Yes, there is an SSIS template file that you can modify to use as the basis
of all new SSIS files. The setting in question comes from the default
template (which is an XML file). This works for most of the file choices
that you see when creating a new file inside of Visual Studio. The template
files are inside of the Visual Studio folder on a user's hard drive.

As far as sharing templates across a group and keeping all of them is sync,
that is a different problem, as the templates are located in folders on each
developer's workstation.

Search for SSIS Package Template

You shouldn't have to delete the package and start over again based on that
encryption setting. Just have the package creator open the package, change
the setting, and resave it.

-Mike Chabot

http://www.linkedin.com/in/chabot
On Fri, Aug 19, 2011 at 11:45 AM, DURETTE, STEVEN J (ATTASIAIT) 
sd1...@att.com wrote:


 Hi all,

 Sorry for the OT, but my Google foo has failed me!

 When trying to save a SSIS package to a server one of the options is
 Protection Level and it defaults to Encrypt data with User Key. The policy
 in our shop is to use Rely on server storage and roles for access control.
 It is a major annoyance to always have to change it and when people forget
 we have to delete the package and start over again.  Does anyone know if
 there is an xml file or something we can edit to change the default?

 Thanks,
 Steve



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346865
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


(ot) Stopping Railo via an ANT task

2011-08-19 Thread Brook Davies

Sorry for the OT post, I'm stuck on this.

Trying to get Railo Express to stop via an ANT task. The java code is the
same as in stop.bat. Note, calling stop.bat directly is not working for me
either.

target name=stopRailo description=Stopping Railo Server
echo message=Stoping Railo../

java jar=tools/build/railo/lib/start.jar
   dir=tools/build/railo/
fork=true
   failonerror=true
arg value=-DSTOP.PORT=8887/
arg value=-DSTOP.KEY=railo/
   arg value=--stop/
/java

echo message=Railo Stopped../
/target

I get this error, and can still connect to localhost:

 [java] java.net.ConnectException: Connection refused: connect
 [java] at java.net.PlainSocketImpl.socketConnect(Native Method)
 [java] at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
 [java] at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
 [java] at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
 [java] at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
 [java] at java.net.Socket.connect(Socket.java:525)
 [java] at java.net.Socket.connect(Socket.java:475)
 [java] at java.net.Socket.init(Socket.java:372)
 [java] at java.net.Socket.init(Socket.java:215)
 [java] at org.eclipse.jetty.start.Main.stop(Main.java:1096)
 [java] at
org.eclipse.jetty.start.Main.parseCommandLine(Main.java:136)
 [java] at org.eclipse.jetty.start.Main.main(Main.java:81)
 [java] Usage: java -jar start.jar [options] [properties] [configs]
 [java]java -jar start.jar --help  # for more information

I can't get it to stop no matter what I try...

Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346866
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Database fail over advice

2011-08-19 Thread Mallory Woods

Greetings,

My boss has asked me to come up with a plan of action in case one of our
databases is off line or if we loose connectivity to it.
In this setup we have one DB in one location and another one at a different
ISP. I think he wants a solution in which if its possible that CF would be
able to make the
change if some sort of situation were to occur and we can't reach site A.

One thing that I thought of would be to run a simple query and if it times
out or we get a DB error then we would switch to the alternate DB. I have
just started thinking about this scenario and since
I have never been tasked with this type of challenge before I thought I
would ask.

Thanks,

Mallory Woods


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346867
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Database fail over advice

2011-08-19 Thread Russ Michaels

I presume you already have the database clustering sorted and just want to
handle the CF DSN side of things ?
The easy way to do this is to have 2 DSN's, one pointing to each server.
In your OnRequest method simply check the database connection, if it fails,
switch to the other DSN.

Russ

On Fri, Aug 19, 2011 at 9:10 PM, Mallory Woods mallory.wo...@gmail.comwrote:


 Greetings,

 My boss has asked me to come up with a plan of action in case one of our
 databases is off line or if we loose connectivity to it.
 In this setup we have one DB in one location and another one at a different
 ISP. I think he wants a solution in which if its possible that CF would be
 able to make the
 change if some sort of situation were to occur and we can't reach site A.

 One thing that I thought of would be to run a simple query and if it times
 out or we get a DB error then we would switch to the alternate DB. I have
 just started thinking about this scenario and since
 I have never been tasked with this type of challenge before I thought I
 would ask.

 Thanks,

 Mallory Woods


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346868
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Database fail over advice

2011-08-19 Thread Wil Genovese

Mallory,

A while back one of the CFGURU's, Mike Brunt, did an excellent presentation at 
CF.Objective() 2009 called the Server of Doom.  What he covered in the preso 
was performance and redundancy.  His slide show is still on SlideSix  
http://slidesix.com/view/mbruntcfwhisperercfobjective09

The last section covers the database performance and a simple but effective 
failover setup.  It involves user SQL Server express as a witness server to 
determine when failover is needed.

Mike's blog is here 
http://www.cfwhisperer.com/post.cfm/cfobjective-powerepoint-on-coldfusion-and-database-performance





Wil Genovese
Sr. Web Application Developer/
Systems Administrator
CF Webtools
www.cfwebtools.com

wilg...@trunkful.com
www.trunkful.com

On Aug 19, 2011, at 3:10 PM, Mallory Woods wrote:

 
 Greetings,
 
 My boss has asked me to come up with a plan of action in case one of our
 databases is off line or if we loose connectivity to it.
 In this setup we have one DB in one location and another one at a different
 ISP. I think he wants a solution in which if its possible that CF would be
 able to make the
 change if some sort of situation were to occur and we can't reach site A.
 
 One thing that I thought of would be to run a simple query and if it times
 out or we get a DB error then we would switch to the alternate DB. I have
 just started thinking about this scenario and since
 I have never been tasked with this type of challenge before I thought I
 would ask.
 
 Thanks,
 
 Mallory Woods
 
 
 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346869
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: (ot) Stopping Railo via an ANT task (SOLVED)

2011-08-19 Thread Brook Davies

It looks like I had somehow spawned multiple processes and they were not
getting stopped correctly. I think this happened when a build failed. Please
disregard..

Brook

-Original Message-
From: Brook Davies [mailto:br...@logiforms.com] 
Sent: August-19-11 1:08 PM
To: cf-talk
Subject: (ot) Stopping Railo via an ANT task


Sorry for the OT post, I'm stuck on this.

Trying to get Railo Express to stop via an ANT task. The java code is the
same as in stop.bat. Note, calling stop.bat directly is not working for me
either.

target name=stopRailo description=Stopping Railo Server echo
message=Stoping Railo../

java jar=tools/build/railo/lib/start.jar
   dir=tools/build/railo/
fork=true
   failonerror=true
arg value=-DSTOP.PORT=8887/
arg value=-DSTOP.KEY=railo/
   arg value=--stop/
/java

echo message=Railo Stopped../
/target

I get this error, and can still connect to localhost:

 [java] java.net.ConnectException: Connection refused: connect
 [java] at java.net.PlainSocketImpl.socketConnect(Native Method)
 [java] at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
 [java] at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
 [java] at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
 [java] at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
 [java] at java.net.Socket.connect(Socket.java:525)
 [java] at java.net.Socket.connect(Socket.java:475)
 [java] at java.net.Socket.init(Socket.java:372)
 [java] at java.net.Socket.init(Socket.java:215)
 [java] at org.eclipse.jetty.start.Main.stop(Main.java:1096)
 [java] at
org.eclipse.jetty.start.Main.parseCommandLine(Main.java:136)
 [java] at org.eclipse.jetty.start.Main.main(Main.java:81)
 [java] Usage: java -jar start.jar [options] [properties] [configs]
 [java]java -jar start.jar --help  # for more information

I can't get it to stop no matter what I try...

Brook





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346870
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Database fail over advice

2011-08-19 Thread Mallory Woods

Russ  Wil Thanks I will be looking at that slideshow.

On Fri, Aug 19, 2011 at 4:20 PM, Wil Genovese jugg...@trunkful.com wrote:


 Mallory,

 A while back one of the CFGURU's, Mike Brunt, did an excellent presentation
 at CF.Objective() 2009 called the Server of Doom.  What he covered in the
 preso was performance and redundancy.  His slide show is still on SlideSix
 http://slidesix.com/view/mbruntcfwhisperercfobjective09

 The last section covers the database performance and a simple but effective
 failover setup.  It involves user SQL Server express as a witness server
 to determine when failover is needed.

 Mike's blog is here
 http://www.cfwhisperer.com/post.cfm/cfobjective-powerepoint-on-coldfusion-and-database-performance





 Wil Genovese
 Sr. Web Application Developer/
 Systems Administrator
 CF Webtools
 www.cfwebtools.com

 wilg...@trunkful.com
 www.trunkful.com

 On Aug 19, 2011, at 3:10 PM, Mallory Woods wrote:

 
  Greetings,
 
  My boss has asked me to come up with a plan of action in case one of our
  databases is off line or if we loose connectivity to it.
  In this setup we have one DB in one location and another one at a
 different
  ISP. I think he wants a solution in which if its possible that CF would
 be
  able to make the
  change if some sort of situation were to occur and we can't reach site A.
 
  One thing that I thought of would be to run a simple query and if it
 times
  out or we get a DB error then we would switch to the alternate DB. I have
  just started thinking about this scenario and since
  I have never been tasked with this type of challenge before I thought I
  would ask.
 
  Thanks,
 
  Mallory Woods
 
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfselect bind not working...

2011-08-19 Thread Pete Ruckelshaus

Have a pair of related select lists...first one is country, then when the
country is selected, states load in the second select.  The first select,
which gets its data from a CFC, works fine, but when the page loads, it
gives a Bind failed, element not found: country error.  The pertinent
code:

The form fields in the CFM page:

tr valign=middle
td align=right class=formNotRequiredCountry:/td
 tdcfselect name=country
bind=cfc:site.extensions.cfc.utils.getCountries() bindonload=true
display=printable_name value=country style=width:
100%;/cfselect/td
 /tr
tr valign=middle
td align=right class=formNotRequiredState:/td
 tdcfselect name=state
bind=cfc:site.extensions.cfc.utils.getstates({country})
display=stateValue value=state style=width: 100%;/cfselect/td
 /tr

And the methods in the CFC:

cfcomponent
cffunction name=getCountries access=remote returntype=query
 cfquery name=getCountries datasource=#application.dsn#
SELECT DISTINCT FBB.country, UC.printable_name
 FROM _tblFBBuilders FBB
LEFT JOIN tblUtilCountry UC
 ON FBB.country = UC.iso
UNION
 SELECT '' AS country, ' - Select Country - ' AS printable_name
 ORDER BY UC.printable_name
/cfquery
 cfreturn getCountries
/cffunction
cffunction name=getstates access=remote
cfargument name=country required=yes
cfquery name=getStates datasource=#application.dsn#
 SELECT DISTINCT FBB.state, FBB.state AS stateValue
FROM _tblFBBuilders FBB
 WHERE FBB.country = cfqueryparam cfsqltype=CF_SQL_CHAR
value=#arguments.country#
 UNION
SELECT '' AS state, ' - Select State - ' AS stateValue
 ORDER BY FBB.state
/cfquery
 cfreturn getstates
/cffunction
/cfcomponent


Any obvious mistakes here?

Thanks,

Pete


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346872
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm