Re: CFMX problems with null variables

2004-04-13 Thread Kym Kovan
Hello KDJ,

This is the very first time I post something, although I've been signed up 
to it for years. I'd like to greet you all first of all :)

And greetings from DownUnder :-)

Whenever I have a form and I send its contents to another cf document, if 
one of the fields was empty, it interprets the variable as not existant. I.e.

input name=testtext type=text

On the next page, if I left that field blank, when trying to do a 
#testtext# it says it doesn't exist.

This is a browser dependent problem. If you do:

input name=testtext type=text value=

then most browsers will send an empty variable (except extremely old Netscape AFAIK) if there is no entry made.

That problem wouldn't be so big if it wasn't that today I realized that it 
happens with loops. For example:

cfloop index=nopi list=black||yellow| |green delimiters=|
cfoutputMy Color is: #nopi# /cfoutputbr
/cfloop

It returns:

My Color is: black
My Color is: yellow
My Color is:
My Color is: green

See what I mean? Since the 2nd element is empty, the internal variable just 
doesn't exist...

This is standard CF behaviour with lists. Adjacent delimiters are treated as one delimiter so you need to put something between them. Try something like:
cfset listVariable = replace(listVariable, ||, | |, all)
That will force the delimiters apart and then you can strip out the spacer afterwards if you need to.

--

Yours,

Kym
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Flex Flash Tree Menu performance resolved, again?

2004-04-13 Thread Whittingham, P
Dick,

 
It works for me. Does flex create a source file (FLA), or just the swf ? It seems to take time for loading. Message appears immediately, but the loading messages starts the 1st time the pages runs. Its appears on other times later(ie. refresh), but loads faster. Are you using CFMX enterprise or standard?

 
TIA,
Patrick Whittingham
United Space Alliance

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]
Sent: Monday, April 12, 2004 8:55 PM
To: CF-Talk
Subject: Flex Flash Tree Menu performance resolved, again?

I sent the email (below) earlier but noone could access the examples.

I think it is fixed now --long story -- trying to get things working 
with latest JVM.

HTH

Dick

There were several threads last week re the poor performance of the
Flex Flash tree menu.

I commented that the one on the Flex Code explorer was one of the
slowest I'd seen.

I wrote my own Flex Tree example and the performance was consistent
with the Code Explorer -- disappointing.

Christian Cantrell suggested a resolution -- set the openDuration
parameter of the tree function to 0 (the default is 250 ms):

mx:Tree openDuration=0 

This does resolve the jerkiness and most of the delay when opening and
closing nodes.

you can see the difference at:

http://67.124.145.42/cfusion/Flex/CFFlexTree.cfm

vs

http://67.124.145.42/cfusion/Flex/CFFlexTree1.cfm

1)Get both up side-by-side.

2) Then, starting at the bottom, open enough nodes to get the scroll
bar working pretty good,

3) Scroll to the top and open/close the top node

If there is delay downloading, it is because the site is on my dev box,
along with MySQL, Sybase, and a couple of real-time streamers.

HTH

Dick 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: What is this?

2004-04-13 Thread Thomas Chiverton
On Tuesday 13 Apr 2004 03:02 am, Dick Applebaum wrote:
 Can I do anything to reject/detect/sabotage the sender to discourage
 this sort of thing?

Yes, you can come up with a mod_rewrite rule to 404 it or whatever..
In general the request will be coming from a zombie / own3d computer, so there 
is not much you can do.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Flex Flash Tree Menu performance resolved, again?

2004-04-13 Thread Dick Applebaum
On Apr 13, 2004, at 3:49 AM, Whittingham, P wrote:

  It works for me. Does flex create a source file (FLA), or just the 
 swf ? It seems to take time for loading. Message appears immediately, 
 but the loading messages starts the 1st time the pages runs. Its 
 appears on other times later(ie. refresh), but loads faster. Are you 
 using CFMX enterprise or standard?

Flex doesn't need a FLA (Flash Source file).

A Flex document is, in fact, a source file containing XML and Action 
Script that defines the structure and procedure of the client-side 
application.

you can see a simple example of CF creating a Flex source at Ben's Blog:

http://www.forta.com/blog/index.cfm?mode=eentry=1038

The Flex source gets compiled to a .SWF file

I am using CFMX for J2EE/JRun which is the equivalent of Enterprise.

One final comment.

I haven't done much Flex coding yet, but I really like it compared to 
Flash coding--- no timeline/movie orientation, and no Flash IDE (which 
drives me crazy!)

HTH

Dick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX cfhttp bug?

2004-04-13 Thread Dick Applebaum
Yes, with no effect.

On Apr 12, 2004, at 9:45 PM, Geoff Bowers wrote:

 Have you tried specifying a specific character set with the appropriate
attribute in CFHTTP?

-- geoff
http://www.daemon.com.au/

Dick Applebaum wrote:
 I ran into an odd bug? when trying to upgrade CF 5 program to CFMX 
 6.1.

 The program populates a db from a text file using CFHTTP.

 I used the actual program and text file from CF 5.

 I couldn't find any discussion of this in LiveDocs.

 This cost me several hours of frustration, as the error message is 
 not  
 obviously (to me) referring to a data error.

 Is there a way around this -- I really want to use the bullet char 
 in  
 the text file)?

 (used the same technique on a bunch of older CF sites)

 TIA

 Dick

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
I am outputting style name values using CF query-results. I'm 

making those values available to _javascript_ in a variable so I 

can use the values in an onClick event. 

If I only needed the variable's last style name value returned 

by the query, I could use the following:

 cfoutput
 script language=_javascript_ type=text/_javascript_
!--
function targetid(){
return #menu_bmarkLink#;
}
--
 /script
 /cfoutput

 cfoutput query=Q_menu
 li A HREF="" cfif q_menu.menu_nonBmarkLink neq 
#q_menu.menu_nonBmarkLink# cfelse##Ans
>
ext#  /a  /li
 /cfoutput

The complication arises because I want each iteration of the 

onClick event to hold a different value for the style name 

variable. 

What do I have to do to iterate through the style name values 

from the query so each onClick event iteration has a different 

value - like this:
 liA HREF="" cfif q_menu.menu_nonBmarkLink neq 
#q_menu.menu_nonBmarkLink# cfelse##Ans
 
/cfif#q_menu.menu_Text#  /a  /li

 li A HREF="" cfif q_menu.menu_nonBmarkLink neq 
#q_menu.menu_nonBmarkLink# cfelse##Ans
 
/cfif#q_menu.menu_Text#  /a  /li

 li A HREF="" cfif q_menu.menu_nonBmarkLink neq 
#q_menu.menu_nonBmarkLink# cfelse##Ans
 /cfif#q_menu.menu_Text#
 /a  /li

Thank you in advance!! I've got an app in development that 

hinges on this code!!!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Odd CF / Javascript Question

2004-04-13 Thread Jeff Waris
Here is an interesting one.

 
Is there a way to use a _javascript_ trigger like onclick to update a record
in a database WITHOUT calling a new CF template and refreshing the screen?
The idea is that there are multiple check boxes on the screen, each
representing a record. A user clicks the check box and it updates the
associated record with a CFQUERY update.Any help would be appreciated.

Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Odd CF / Javascript Question

2004-04-13 Thread Thomas Chiverton
On Tuesday 13 Apr 2004 13:02 pm, Jeff Waris (Jeff Waris [EMAIL PROTECTED]) 
wrote:
 Is there a way to use a _javascript_ trigger like onclick to update a
 record in a database WITHOUT calling a new CF template and refreshing the
 screen? The idea is that there are multiple check boxes on the screen, each

Search for 'neuromancer' in the archives.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Odd CF / Javascript Question

2004-04-13 Thread Tangorre, Michael
 Is there a way to use a _javascript_ trigger like onclick to 
 update a record in a database WITHOUT calling a new CF 
 template and refreshing the screen?
 The idea is that there are multiple check boxes on the 
 screen, each representing a record. A user clicks the check 
 box and it updates the associated record with a CFQUERY 
 update.Any help would be appreciated.

You need to use something server side to interact with the DB to update
the record, _javascript_ is client side. However, you can look into the JSAPI
client/server gateway at http://www.pengoworks.com/. Read up on the gateway,
I think it is probably what you are looking for. Some others will chime in
with some more recent discussions on this gateway topic, but I have only
used the one referenced above.

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Odd CF / Javascript Question

2004-04-13 Thread Pascal Peters
You can not do it without calling a CF template, but you can do it
without refreshing your screen. Create a hidden frame to handle requests
to the server without refreshing the current screen. Call the template
to update the record in that hidden frame. 

Pascal

 -Original Message-
 From: Jeff Waris [mailto:[EMAIL PROTECTED] 
 Sent: dinsdag 13 april 2004 14:02
 To: CF-Talk
 Subject: Odd CF / _javascript_ Question
 
 Here is an interesting one.

 Is there a way to use a _javascript_ trigger like onclick to 
 update a record in a database WITHOUT calling a new CF 
 template and refreshing the screen?
 The idea is that there are multiple check boxes on the 
 screen, each representing a record. A user clicks the check 
 box and it updates the associated record with a CFQUERY 
 update.Any help would be appreciated.


 
 Jeff
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: RDS servlet errors

2004-04-13 Thread Thomas Chiverton
On Monday 12 Apr 2004 18:33 pm, [EMAIL PROTECTED] wrote:
 D:\inetpub\wwwroot\scenario1\myminutes\index.htm.LCK (The system cannot
 find the file specified) java.io.FileNotFoundException:

Isn't that how DreamWeaver does it's locking ? Maybe that is causing files to 
vanish halfway through something.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Configuration and Settings Migration Wizard ( WAS Re: help, cfmx 6.1 just hangs! )

2004-04-13 Thread Thomas Chiverton
On Saturday 10 Apr 2004 23:34 pm, Josh [EMAIL PROTECTED] wrote:
 For those of you familiar with the install process the first screen is
 the Configuration and Settings Migration Wizard
 It comes up just fine, but after I enter my admin password...it hangs.

I guess it is trying to migrate something it can't - did you completly rm all 
previous CF installs ?
Do you have remotly mounted filesystems (that could cause a directory search 
to hang, for instance) ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




checking form elements in CF with JavaScript

2004-04-13 Thread Roberto Perez
Hi all,

Im trying to use a simple _javascript_ form validation with my CF code. The 
validation should check both text fields and radio buttons/checkboxes. So 
far the radio button part does not work. This is the code:

script language='_javascript_'
!--
function check_form()
{
for (i = 0; i  document.forms[0].elements.length; i++)
{
checkElement = document.forms[0].elements[i];
if (checkElement.name == 'InstEthn') {if (checkElement.value.length  255) 
{ alert(text too long.); return false;} }
if (checkElement.name == 'InstLang') {if (checkElement.value.length  255) 
{ alert(text too long.); return false;} }
if (checkElement.name == 'InstEthn') {if (checkElement.value.length  1) { 
alert(The Instructor Ethnicity field is empty.); return false;}}
if (checkElement.name == 'InstLang') {if (checkElement.value.group1 == 
undefined) { alert(Question 3 was not answered.); return false;}}

As it is now, the InstLang field gives the user the Question 3 was not 
answered message, even when that radio button is checked.

Any alternatives/fixes for this code?

Thanks a lot,

Roberto Perez
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Dick Applebaum
You can do what you want -- but I can't understand your code -- so here 
goes

cfquery name=getStyle
SELECT styleName FROM styleDB
/cfquery

cfoutput query=getStyle
brsome stuff #styleName# some other stuff
/cfoutput

will provide getStyle.RecordCount linesof output, 1 for each row in 
the query

the #styleName# in each line of output will contain the styleName 
corresponding to the one in getStyle.CurrentRow

HTH

Dick

On Apr 13, 2004, at 5:07 AM, Joy Holman wrote:

 I am outputting style name values using CF query-results. I'm

making those values available to _javascript_ in a variable so I

can use the values in an onClick event.

If I only needed the variable's last style name value returned

by the query, I could use the following:

 cfoutput
 script language=_javascript_ type=text/_javascript_
!--
function targetid(){
return #menu_bmarkLink#;
}
--
 /script
 /cfoutput

 cfoutput query=Q_menu
 li A HREF="" cfif q_menu.menu_nonBmarkLink neq
#q_menu.menu_nonBmarkLink# cfelse##Ans
>
ext#  /a  /li
 /cfoutput

The complication arises because I want each iteration of the

onClick event to hold a different value for the style name

variable.

What do I have to do to iterate through the style name values

from the query so each onClick event iteration has a different

value - like this:
 liA HREF="" cfif q_menu.menu_nonBmarkLink neq
#q_menu.menu_nonBmarkLink# cfelse##Ans
>
/cfif#q_menu.menu_Text#  /a  /li

 li A HREF="" cfif q_menu.menu_nonBmarkLink neq
#q_menu.menu_nonBmarkLink# cfelse##Ans
>
/cfif#q_menu.menu_Text#  /a  /li

 li A HREF="" cfif q_menu.menu_nonBmarkLink neq
#q_menu.menu_nonBmarkLink# cfelse##Ans
 /cfif#q_menu.menu_Text#
 /a  /li

Thank you in advance!! I've got an app in development that

hinges on this code!!!

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: RDS servlet errors

2004-04-13 Thread Douglas.Knudsen
yup, did some digging and it seems these errors are related to DWMX.Now, the thing is, I just tested this, I have the check in/out turned off in DWMX, yet I still see these errors.Seems DWMX is doing something wrong here.

 
Doug

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 8:40 AM
To: CF-Talk
Subject: Re: RDS servlet errors

On Monday 12 Apr 2004 18:33 pm, [EMAIL PROTECTED] wrote:
 D:\inetpub\wwwroot\scenario1\myminutes\index.htm.LCK (The system cannot
 find the file specified) java.io.FileNotFoundException:

Isn't that how DreamWeaver does it's locking ? Maybe that is causing files to 
vanish halfway through something.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.*** 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Configuration and Settings Migration Wizard ( WAS Re: help, cfmx 6.1 just hangs! )

2004-04-13 Thread Christine Lawson
Yes, you can bypass that wizard by editing the adminconfig.xml file, check
out this technote about the wizard hanging o Installing ODBC Services and
apply the same steps:
http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink.htm
#hangs
http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink.ht
m#hangs 

Christine

-Original Message-
From: Josh [mailto:[EMAIL PROTECTED] 
Sent: Saturday, April 10, 2004 6:35 PM
To: CF-Talk
Subject: Configuration and Settings Migration Wizard ( WAS Re: help, cfmx
6.1 just hangs! )

OK, I have narrowed this down further.I have installed and reinstalled 
CF a few times.I can get .cfm files running, but I cannot get past the 
initial admin screen after install.

For those of you familiar with the install process the first screen is 
the Configuration and Settings Migration Wizard 

It comes up just fine, but after I enter my admin password...it hangs. 

Does anyone know technically what this screen does behind the scenes?
Is there a workaround for this?Can I bypass this screen by editing the 
xml config files directly?

Thanks!

-Josh

Josh wrote:

 We are running Apache 2.0.46

 Any ideas?

 Much Thanks

 Dave Watts wrote:

   I am running CFMX 6.1 on RHEL3 with Apache.
 
  What version of Apache are you using?
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  phone: 202-797-5496
  fax: 202-797-5444
 


_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Using ABS in CF 5

2004-04-13 Thread Kristen Winsor
Why would 3E-005be shown when using
#abs(NumberFormat(getRate.Rate)'_.__'))#?

instead of0.25, which is the value in the db (and the value
returned when Select ABS(.25) is run)

If I take the abs away, the number is shown correctly...?

Thanks
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Using ABS in CF 5

2004-04-13 Thread Philip Arnold
 From: Kristen Winsor
 
 Why would 3E-005be shown when using 
 #abs(NumberFormat(getRate.Rate)'_.__'))#?
 
 instead of0.25, which is the value in the db (and the 
 value returned when Select ABS(.25) is run)
 
 If I take the abs away, the number is shown correctly...?

Try putting the ABS() inside the NUMBERFORMAT()

What's happening is that you're specifying the format, then telling CF
to display it how it wants with the ABS()
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
I'm at my wit's end here, folks.I don't know why my idiotic hello world web service just isn't working.Here's a path to my madness:

helloworld.cfc

cfcomponent
	cffunction name=getMessage access=remote returntype=string output=false
		cfargument name=name type=string required=yes
		cfreturn Hello   arguments.name  , web service is working.
	/cffunction
/cfcomponent

---

hello_component.cfm (to check if the CFC is working)

cfinvoke component=helloworld
 method=getMessage
 returnvariable=aString
	cfinvokeargument name=name value=Bozo/
/cfinvoke

cfoutput#aString#/cfoutput

Output: Hello Bozo, web service is working.

---

helloworld.cfc?wsdl

Output: works fine, displays the XML

---

hello.cfm

cfinvoke webservice=http://localhost/ws/helloworld.cfc?wsdl
 method=getMessage
 returnvariable=aString
	cfinvokeargument name=name value=Bozo/
/cfinvoke

cfoutput#aString#/cfoutput

Output:

Could not generate stub objects for web service invocation. Name: http://localhost/ws/helloworld.cfc?wsdl. WSDL: http://localhost/ws/helloworld.cfc?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=1: Missing whitespace before SYSTEM literal URI.

--

What the hell am I doing wrong?Any ideas?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Using ABS in CF 5

2004-04-13 Thread Tony Weeg
what are you looking to end up with if the value that you start with is
0.25

tony. 

-Original Message-
From: Kristen Winsor [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:16 AM
To: CF-Talk
Subject: Using ABS in CF 5

Why would 3E-005be shown when using
#abs(NumberFormat(getRate.Rate)'_.__'))#?

instead of0.25, which is the value in the db (and the value returned
when Select ABS(.25) is run)

If I take the abs away, the number is shown correctly...?

Thanks
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Using ABS in CF 5

2004-04-13 Thread Pascal Peters
It looks like it rounds the number. Try
#NumberFormat(abs(getRate.Rate),'_.__')#

 -Original Message-
 From: Kristen Winsor [mailto:[EMAIL PROTECTED] 
 Sent: dinsdag 13 april 2004 15:16
 To: CF-Talk
 Subject: Using ABS in CF 5
 
 Why would 3E-005be shown when using
 #abs(NumberFormat(getRate.Rate)'_.__'))#?

The parantheses are wrong, but I suppose it's a typo in the mail.

 
 instead of0.25, which is the value in the db (and the 
 value returned when Select ABS(.25) is run)
 
 If I take the abs away, the number is shown correctly...?
 
 Thanks
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
Hello Everybody, I'm really hoping that someone will
help me.

A lot of people have used the cfx_getImage tag to open
up office documents (word,excel, blah). I thought I'll
use it to do the same. The documents are stored on the
database table as binary objects.

I registered the cfx tag in the administrator. I'm
calling it on the page like this:

cfquery name=getAttachmentDetails datasource=db
 select * from Attachment where id = '#url.id#'
/cfquery

CFX_GETIMAGE 
 DATASOURCE=db
 USER=dbUserName
 PASSWORD=dbPassword
 SQL=select filename FROM Attachment WHERE id =
'#url.id#'
OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName#

I get this error message:

The error occurred in
E:\inetpub\wwwroot\viewattachment.cfm: line 8

 
6 : CFX_GETIMAGE 
7 : 	DATASOURCE=db
8 : 	USER=dbUserName
9 : 	PASSWORD=dbPassword
10 : 	SQL=select filename FROM Attachment WHERE id =
'#url.id#'

 
(USER=dbUserName is in bold)

SQL:select filename FROM Attachment WHERE id =
'01057870'
SQLExecDirect Failed szSqlState = S0002 
pfNativeError = 208
szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object name 'Attachment'.
pcbErrorMsg = 93

Does anybody know why I'm getting this error? I would
really appreciate your help

Regards,
cfcoder

	
		
__
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOT: JS select box question

2004-04-13 Thread Tim Laureska
I have a form for entering the billing address and shipping address.
I've found a js script that works very nicely for copying the contents
of text fields from the billing fields to the shipping fields when a
checkbox is checked.

The problem comes in when trying to copy the state selected in the
billing section drop down box to the shipping state selection drop down
box I'm not sure that's possible, but I'm sure this has been
addressed before.

Does anyone have a recommendation for this?

TIA

Tim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS select box question

2004-04-13 Thread Tony Weeg
tim, 

not really an answer, but if they are just saying yes this address is this
address make the field a text box, and disabled...

why would they need to change it if they are saying, this is correct, and
make these fields match the above fields 

tw

-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:44 AM
To: CF-Talk
Subject: SOT: JS select box question

I have a form for entering the billing address and shipping address.
I've found a js script that works very nicely for copying the contents of
text fields from the billing fields to the shipping fields when a checkbox
is checked.

The problem comes in when trying to copy the state selected in the billing
section drop down box to the shipping state selection drop down box I'm
not sure that's possible, but I'm sure this has been addressed before.

Does anyone have a recommendation for this?

TIA

Tim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS select box question

2004-04-13 Thread Pascal Peters
document.theForm.shippingState.selectedIndex =
document.theForm.billingState.selectedIndex; 

Assuming your two selects have the same options

Pascal

 -Original Message-
 From: Tim Laureska [mailto:[EMAIL PROTECTED] 
 Sent: dinsdag 13 april 2004 15:44
 To: CF-Talk
 Subject: SOT: JS select box question
 
 I have a form for entering the billing address and shipping address.
 I've found a js script that works very nicely for copying the 
 contents of text fields from the billing fields to the 
 shipping fields when a checkbox is checked.
 
 The problem comes in when trying to copy the state selected 
 in the billing section drop down box to the shipping state 
 selection drop down box I'm not sure that's possible, but 
 I'm sure this has been addressed before.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX problems with null variables

2004-04-13 Thread Dave Carabetta
From: Kym Kovan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: CFMX problems with null variables
Date: Tue, 13 Apr 2004 17:07:56 +1000

Hello KDJ,

 This is the very first time I post something, although I've been signed 
up
 to it for years. I'd like to greet you all first of all :)

And greetings from DownUnder :-)

 Whenever I have a form and I send its contents to another cf document, if
 one of the fields was empty, it interprets the variable as not existant. 
I.e.
 
 input name=testtext type=text
 
 On the next page, if I left that field blank, when trying to do a
 #testtext# it says it doesn't exist.

This is a browser dependent problem. If you do:

input name=testtext type=text value=

then most browsers will send an empty variable (except extremely old 
Netscape AFAIK) if there is no entry made.

 That problem wouldn't be so big if it wasn't that today I realized that 
it
 happens with loops. For example:
 
 cfloop index=nopi list=black||yellow| |green delimiters=|
 cfoutputMy Color is: #nopi# /cfoutputbr
 /cfloop
 
 It returns:
 
 My Color is: black
 My Color is: yellow
 My Color is:
 My Color is: green
 
 See what I mean? Since the 2nd element is empty, the internal variable 
just
 doesn't exist...

This is standard CF behaviour with lists. Adjacent delimiters are treated 
as one delimiter so you need to put something between them. Try something 
like:
cfset listVariable = replace(listVariable, ||, | |, all)
That will force the delimiters apart and then you can strip out the spacer 
afterwards if you need to.


Or you could use this UDF to change your list to an array with nulls and 
loop over the array instead:

http://www.cflib.org/udf.cfm?id=1022

Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
btw, my application is running on cfmx. I just can't see why the code would error. I've checked the value passed to the USER attribute and it is correct.

Hello Everybody, I'm really hoping that someone will
help me.

A lot of people have used the cfx_getImage tag to open
up office documents (word,excel, blah). I thought I'll
use it to do the same. The documents are stored on the
database table as binary objects.

I registered the cfx tag in the administrator. I'm
calling it on the page like this:

cfquery name=getAttachmentDetails datasource=db
 select * from Attachment where id = '#url.id#'
/cfquery


CFX_GETIMAGE 
 DATASOURCE=db
 USER=dbUserName
 PASSWORD=dbPassword
 SQL=select filename FROM Attachment WHERE id =
'#url.id#'
OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName#

I get this error message:

The error occurred in
E:\inetpub\wwwroot\viewattachment.cfm: line 8
 
6 : CFX_GETIMAGE 
7 : 	DATASOURCE=db
8 : 	USER=dbUserName
9 : 	PASSWORD=dbPassword
10 : 	SQL=select filename FROM Attachment WHERE id =
'#url.id#'
 
(USER=dbUserName is in bold)

SQL:select filename FROM Attachment WHERE id =
'01057870'
SQLExecDirect Failed szSqlState = S0002 
pfNativeError = 208
szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object name 'Attachment'.
pcbErrorMsg = 93

Does anybody know why I'm getting this error? I would
really appreciate your help

Regards,
cfcoder


	
		
__
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Michael Corbridge
Sung,

Don't get too frustrated.

The problem here is that you are not invoking the webservice through the
correct path,Try:

cfinvoke webservice=http://localhost:8500/ws/helloworld.cfc?wsdl
http://localhost:8500/ws/helloworld.cfc?wsdl 

Let me know how it goes,

Michael Corbridge

_

From: Sung Woo [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:31 AM
To: CF-Talk
Subject: Web Services and CFMX6.1 -- Why doesn't it work?

I'm at my wit's end here, folks.I don't know why my idiotic hello world
web service just isn't working.Here's a path to my madness:

helloworld.cfc

cfcomponent
cffunction name=getMessage access=remote returntype=string
output=false
cfargument name=name type=string required=yes
cfreturn Hello   arguments.name  , web service is working.
/cffunction
/cfcomponent

---

hello_component.cfm (to check if the CFC is working)

cfinvoke component=helloworld
method=getMessage
returnvariable=aString
cfinvokeargument name=name value=Bozo/
/cfinvoke

cfoutput#aString#/cfoutput

Output: Hello Bozo, web service is working.

---

helloworld.cfc?wsdl

Output: works fine, displays the XML

---

hello.cfm

cfinvoke webservice=http://localhost/ws/helloworld.cfc?wsdl
method=getMessage
returnvariable=aString
cfinvokeargument name=name value=Bozo/
/cfinvoke

cfoutput#aString#/cfoutput

Output:

Could not generate stub objects for web service invocation. Name:
http://localhost/ws/helloworld.cfc?wsdl. WSDL:
http://localhost/ws/helloworld.cfc?wsdl. org.xml.sax.SAXException: Fatal
Error: URI=null Line=1: Missing whitespace before SYSTEM literal URI.

--

What the hell am I doing wrong?Any ideas?

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS select box question

2004-04-13 Thread Tim Laureska
Yeah, I guess you're right... I think I'm trying to make this more
complicated than it needs to be 

I wanted to make it kinda cool so that when they clicked the checkbox
that says use same address for shipping it filled in the shipping
fields with those entries in the billing address fields... I'm going to
get coffee now

I might try Pascal's suggestion

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:42 AM
To: CF-Talk
Subject: RE: JS select box question

tim, 

not really an answer, but if they are just saying yes this address is
this
address make the field a text box, and disabled...

why would they need to change it if they are saying, this is correct,
and
make these fields match the above fields 

tw

-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:44 AM
To: CF-Talk
Subject: SOT: JS select box question

I have a form for entering the billing address and shipping address.
I've found a js script that works very nicely for copying the contents
of
text fields from the billing fields to the shipping fields when a
checkbox
is checked.

The problem comes in when trying to copy the state selected in the
billing
section drop down box to the shipping state selection drop down box
I'm
not sure that's possible, but I'm sure this has been addressed before.

Does anyone have a recommendation for this?

TIA

Tim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: checking form elements in CF with JavaScript

2004-04-13 Thread Alisa Thomson
Try checking for the checked attribute instead of the value attribute.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS select box question

2004-04-13 Thread Tony Weeg
oh yeah, of course, his is the way to do it but, in my estimation a bit
unneeded, since a drop down is for choices, and a text box for something
that is absolute...but truly its up to you and how you want to design it...

later
tw

-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 10:03 AM
To: CF-Talk
Subject: RE: JS select box question

Yeah, I guess you're right... I think I'm trying to make this more
complicated than it needs to be 

I wanted to make it kinda cool so that when they clicked the checkbox that
says use same address for shipping it filled in the shipping fields with
those entries in the billing address fields... I'm going to get coffee now

I might try Pascal's suggestion

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 9:42 AM
To: CF-Talk
Subject: RE: JS select box question

tim, 

not really an answer, but if they are just saying yes this address is this
address make the field a text box, and disabled...

why would they need to change it if they are saying, this is correct, and
make these fields match the above fields 

tw

-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 9:44 AM
To: CF-Talk
Subject: SOT: JS select box question

I have a form for entering the billing address and shipping address.
I've found a js script that works very nicely for copying the contents of
text fields from the billing fields to the shipping fields when a checkbox
is checked.

The problem comes in when trying to copy the state selected in the billing
section drop down box to the shipping state selection drop down box
I'm
not sure that's possible, but I'm sure this has been addressed before.

Does anyone have a recommendation for this?

TIA

Tim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS select box question

2004-04-13 Thread Tim Laureska
Just a note of thanks Pascal.. those couple lines of code worked

-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 10:03 AM
To: CF-Talk
Subject: RE: JS select box question

Yeah, I guess you're right... I think I'm trying to make this more
complicated than it needs to be 

I wanted to make it kinda cool so that when they clicked the checkbox
that says use same address for shipping it filled in the shipping
fields with those entries in the billing address fields... I'm going to
get coffee now

I might try Pascal's suggestion

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:42 AM
To: CF-Talk
Subject: RE: JS select box question

tim, 

not really an answer, but if they are just saying yes this address is
this
address make the field a text box, and disabled...

why would they need to change it if they are saying, this is correct,
and
make these fields match the above fields 

tw

-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:44 AM
To: CF-Talk
Subject: SOT: JS select box question

I have a form for entering the billing address and shipping address.
I've found a js script that works very nicely for copying the contents
of
text fields from the billing fields to the shipping fields when a
checkbox
is checked.

The problem comes in when trying to copy the state selected in the
billing
section drop down box to the shipping state selection drop down box
I'm
not sure that's possible, but I'm sure this has been addressed before.

Does anyone have a recommendation for this?

TIA

Tim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX JRun Services on Windows 2000

2004-04-13 Thread Adrocknaphobia
CFMX for J2EE, Windows 2000.

I've got a number of CF instance running on the server. However only 3 services are running connected to JRun. Admin, Default, and CFusion. (The 3 default instances jrun creates when you install CF)

When the server is rebooted, only the 3 default services are restarted. All other instances are not.

Looking into the services that are there, shows the same executable (jrunsvc.exe), yet there are no startup parameters to differentiate them. I'm curious as to what the difference is between the three since they all run the same executable.

A solution, which seems a bit sloppy, is to create a scheduled task that runs on system startup, which makes the appropriate command line execution. (jrun.exe -start myCFInstance)

Is there anyway to add these instance as services like the default cfusion one that is created during the initial install of the server?

-adam
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
Hi Michael,

Thanks, but that doesn't seem to work, either.

I don't understand why I'd use port 8500...I'm not using the built-in webserver, I'm using IIS?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Disappearing/reappearing application variables...

2004-04-13 Thread Tyler Silcox
Is there any reason application variables would disappear before the
application timeout set in Application.cfm file?

 
I have the following code, which initializes an application based CFC if it
does not already exist.I put in a cflog tag to let me know how often it
rebuilds itself and it seems to re-initialize every 1-2 hours, even though I
have the application timeout set to 12 hours in the cfapplication tag (and
the server timeout is still set to the default 2 days for application vars.)

 
cfif NOT StructKeyExists(application, SomeCFC) OR 0
 cflock name=CreateSomeCFC#application.ApplicationName# timeout=10
throwontimeout=Yes type=Exclusive
cfscript
// i create the SomeCFC
application.SomeCFC=CreateObject(component, SomeCFC).Init();
/cfscript
 /cflock
 !--- i update the SomeCFC log file ---
 cflog text=SomeCFC initialized [#GetBaseTemplatePath()# ::
#cgi.Remote_Addr#] file=SomeCFC
/cfif

 
The CFC contains a semi-boatload of configuration data, cached structs, etc;
but I've definitely worked with larger amounts of persistent data
before...could this be an issue?Is there anyway to check how much is too
much with memory vars?As usual, any help would be greatly appreciated-

 
Tyler S

 
PS: I'm also going to add another conditional statement within the lock to
re-check if the struct exists, I've just been forcing the re-init by
changing the 0 to a 1
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Recipe Application

2004-04-13 Thread Issac Rosa
Does anyone know of a good recipe application?No specific
requirements, so open to all suggestions.



TIA,

Issac
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




How to streamline a request that uses many cfquery statements?

2004-04-13 Thread Earl, George
This feels like a dumb question, but here goes . . .

Am I correct that in a CF template that has, say, 15 cfquery statements the
cfquery statements are submitted one at a time with each subsequent cfquery
not submitted until the previous cfquery returns? I.e., if all 15 queries
have to run and there is no logic in the markup that arranges or rearranges
the order in which the queries run do they run one at a time in sequence
from top to bottom?

Is there a way to have multiple queries running from the same cf template at
the same time? 

We produce a report that is essentially three reports bundled into one and
displayed one after the other. Currently we run 15 queries (3*5) to create
this report and it takes 3 - 3 1/2 minutes for the queries to complete.
Logically it seems that we could run the three report processes concurrently
and independently and then assemble them into the final report when the
answer sets come back which should dramatically speed up the process. Is
there a way to do this with CF?

(We're using Oracle 8i, CF5, migrating to CFMX 6.1, on Windows 2000 Advanced
Server.)

Thanks!

George
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Disappearing/reappearing application variables...

2004-04-13 Thread Tangorre, Michael
 Is there any reason application variables would disappear 
 before the application timeout set in Application.cfm file?

If the application timeout in the CF Administrator is less than what it is
set in your cfapplication tag.Did you check the admin setting?

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How to streamline a request that uses many cfquery statements?

2004-04-13 Thread Pascal Peters
Stored Procedures? 

 -Original Message-
 From: Earl, George [mailto:[EMAIL PROTECTED] 
 Sent: dinsdag 13 april 2004 16:40
 To: CF-Talk
 Subject: How to streamline a request that uses many cfquery 
 statements?
 
 This feels like a dumb question, but here goes . . .
 
 Am I correct that in a CF template that has, say, 15 cfquery 
 statements the cfquery statements are submitted one at a time 
 with each subsequent cfquery not submitted until the previous 
 cfquery returns? I.e., if all 15 queries have to run and 
 there is no logic in the markup that arranges or rearranges 
 the order in which the queries run do they run one at a time 
 in sequence from top to bottom?
 
 Is there a way to have multiple queries running from the same 
 cf template at the same time? 
 
 We produce a report that is essentially three reports bundled 
 into one and displayed one after the other. Currently we run 
 15 queries (3*5) to create this report and it takes 3 - 3 1/2 
 minutes for the queries to complete.
 Logically it seems that we could run the three report 
 processes concurrently and independently and then assemble 
 them into the final report when the answer sets come back 
 which should dramatically speed up the process. Is there a 
 way to do this with CF?
 
 (We're using Oracle 8i, CF5, migrating to CFMX 6.1, on 
 Windows 2000 Advanced
 Server.)
 
 Thanks!
 
 George
 [EMAIL PROTECTED]
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




MX: Scheduler firing off too often

2004-04-13 Thread Scott Weikert
Hey folks -

I've got an MX box (Windows) with a oddly behaving scheduler. I've got a 
single task in the list, that fires off once every three minutes. I've got 
the task aborting early, but not before it sends me a quickie time-stamped 
email. Every once in a while, I'll get two or three emails with the same 
time (sans seconds) on it.

I did this due to prior behavior of this box's scheduler - when testing 
this particular task, when I added it to the scheduler initially, it worked 
great. Took it out... put it back... then it was running TWICE. Took it 
out... put it back again... it would run THREE times.

Any thoughts on what the issue may be, and how to resolve it?

Thanks in advance,
--Scott
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Michael Corbridge
Sung,

Sorry - my bad,I connect up to the built in webserver for testing.
However, I note that I get the same error you get if the path to the cfc is
incorrect.

Can you browse the cfc?

_

From: Sung Woo [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 10:21 AM
To: CF-Talk
Subject: Re: Web Services and CFMX6.1 -- Why doesn't it work?

Hi Michael,

Thanks, but that doesn't seem to work, either.

I don't understand why I'd use port 8500...I'm not using the built-in
webserver, I'm using IIS?

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MX: Scheduler firing off too often

2004-04-13 Thread Scott Weikert
Ack, should have said Linux instead of Windows there.

At 08:45 AM 4/13/2004, you wrote:
Hey folks -

I've got an MX box (Windows) with a oddly behaving scheduler. I've got a
single task in the list, that fires off once every three minutes. I've got
the task aborting early, but not before it sends me a quickie time-stamped
email. Every once in a while, I'll get two or three emails with the same
time (sans seconds) on it.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: How to streamline a request that uses many cfquery statements?

2004-04-13 Thread Deanna Schneider
Sounds like you should be doing some stored procedures.

- Original Message - 
From: Earl, George  We produce a report that is essentially three reports
bundled into one and
 displayed one after the other. Currently we run 15 queries (3*5) to create
 this report and it takes 3 - 3 1/2 minutes for the queries to complete.
 Logically it seems that we could run the three report processes
concurrently
 and independently and then assemble them into the final report when the
 answer sets come back which should dramatically speed up the process. Is
 there a way to do this with CF?

 (We're using Oracle 8i, CF5, migrating to CFMX 6.1, on Windows 2000
Advanced
 Server.)

 Thanks!

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Recipe Application

2004-04-13 Thread Burns, John D
A friend developed planyourmeals.com

Not sure if he's making the code available (or if you need the code) but
it allows people to share recipes, and once you choose a recipe, it
gives you a weekly shopping list based on the meals you plan.

John 

-Original Message-
From: Issac Rosa [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 10:37 AM
To: CF-Talk
Subject: Recipe Application

Does anyone know of a good recipe application?No specific
requirements, so open to all suggestions.



TIA,

Issac
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX JRun Services on Windows 2000

2004-04-13 Thread Dave Watts
 Is there anyway to add these instance as services like the 
 default cfusion one that is created during the initial 
 install of the server?

You need to register them as services by running jrunsvc.exe from the
command line with the appropriate parameters.

jrunsvc -install cfusion2 cfusion2 (or something like that).

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: How to streamline a request that uses many cfquery statements?

2004-04-13 Thread Jochem van Dieten
Earl, George said:

 Am I correct that in a CF template that has, say, 15 cfquery
 statements the cfquery statements are submitted one at a time with
 each subsequent cfquery not submitted until the previous cfquery
 returns? I.e., if all 15 queries have to run and there is no logic
 in the markup that arranges or rearranges the order in which the
 queries run do they run one at a time in sequence from top to
 bottom?

Correct.

 Is there a way to have multiple queries running from the same cf
 template at the same time?

Write a multi-threaded Java/C customtag.

 We produce a report that is essentially three reports bundled into
 one and displayed one after the other. Currently we run 15 queries
 (3*5) to create this report and it takes 3 - 3 1/2 minutes for the
 queries to complete. Logically it seems that we could run the three
 report processes concurrently and independently and then assemble
 them into the final report when the answer sets come back which
 should dramatically speed up the process.

Not necessarily. If the db-server is continuously stressed out
concurrent queries will not help. There even is a considerable chance
they will hurt, for instance through trashing the buffers.

Jochem
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX JRun Services on Windows 2000

2004-04-13 Thread Hua Wei
Adam,

You can try this command to add a CF server service on Windows:
{Jrun_home}\binjrunsvc -install cfusion2 Macromedia JRun CFusion2
Server Macromedia JRun CFusion2 Server

 
Hua

-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 10:19 AM
To: CF-Talk
Subject: CFMX JRun Services on Windows 2000

CFMX for J2EE, Windows 2000.

I've got a number of CF instance running on the server. However only 3
services are running connected to JRun. Admin, Default, and CFusion.
(The 3 default instances jrun creates when you install CF)

When the server is rebooted, only the 3 default services are restarted.
All other instances are not.

Looking into the services that are there, shows the same executable
(jrunsvc.exe), yet there are no startup parameters to differentiate
them. I'm curious as to what the difference is between the three since
they all run the same executable.

A solution, which seems a bit sloppy, is to create a scheduled task that
runs on system startup, which makes the appropriate command line
execution. (jrun.exe -start myCFInstance)

Is there anyway to add these instance as services like the default
cfusion one that is created during the initial install of the server?

-adam
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
Yup, I can browse it just fine.If I use the ?wsdl after the helloworld.cfc, I generate the XML file fine, too.

And even stranger...I'm doing this because we're evaluating Vignette, which has nice interactivity with web services.This web service is recognized and fully usable by Vignette!So it only fails here, on CFMX.Very, very strange...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Ryan Kime
Sung Woo,

Try hitting this in your web browser: http://localhost/ws/helloworld.cfc

What do you get? If it's a blank page then webservices are set up correctly,
if you get an error, then there's still work to be done. Let us know what
you get.

Ryan

-Original Message-
From: Sung Woo [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:21 AM
To: CF-Talk
Subject: Re: Web Services and CFMX6.1 -- Why doesn't it work?

Hi Michael,

Thanks, but that doesn't seem to work, either.

I don't understand why I'd use port 8500...I'm not using the built-in
webserver, I'm using IIS?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MX: Scheduler firing off too often

2004-04-13 Thread Sung Woo
Scott, I have the same issue with my CFMX 6.1 box on W2K.It only happens sometimes, maybe once every month.I haven't found a cure for it, only a workaround.I have a lengthy scheduled task that runs at 3am once a week, but if it runs during business hours, it can create some problems.So I wrapped a simple CFIF statement around it -- i.e., cfif this script is running before 2:55am or after 3:15am, then don't run it.

Yeah, it's stupid, but it's a workaround.Since you have yours firing off pretty often, I'm not sure if this will work for you...but maybe other people will have some ideas.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
I don't get a blank page, but I do get a redirect to the component browser, which looks something like this:

ws.helloworld
Component helloworld 

hierarchy: WEB-INF.cftags.component
ws.helloworld

 
path: E:\webroot\ws\helloworld.cfc
properties: 

methods: getMessage 
* - private method 

getMessage
remote string getMessage ( required string name ) 

Output: supressed
Parameters:
name: string, required, name
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Hua Wei
I tested on my server, it worked. So the code is fine. You may want to
check your server config. 

Hua

-Original Message-
From: Sung Woo [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:31 AM
To: CF-Talk
Subject: Web Services and CFMX6.1 -- Why doesn't it work?

I'm at my wit's end here, folks.I don't know why my idiotic hello
world web service just isn't working.Here's a path to my madness:

helloworld.cfc

cfcomponent
	cffunction name=getMessage access=remote
returntype=string output=false
		cfargument name=name type=string required=yes
		cfreturn Hello   arguments.name  , web service is
working.
	/cffunction
/cfcomponent

---

hello_component.cfm (to check if the CFC is working)

cfinvoke component=helloworld
 method=getMessage
 returnvariable=aString
	cfinvokeargument name=name value=Bozo/ /cfinvoke

cfoutput#aString#/cfoutput

Output: Hello Bozo, web service is working.

---

helloworld.cfc?wsdl

Output: works fine, displays the XML

---

hello.cfm

cfinvoke webservice=http://localhost/ws/helloworld.cfc?wsdl
 method=getMessage
 returnvariable=aString
	cfinvokeargument name=name value=Bozo/ /cfinvoke

cfoutput#aString#/cfoutput

Output:

Could not generate stub objects for web service invocation. Name:
http://localhost/ws/helloworld.cfc?wsdl. WSDL:
http://localhost/ws/helloworld.cfc?wsdl. org.xml.sax.SAXException: Fatal
Error: URI=null Line=1: Missing whitespace before SYSTEM literal URI.

--

What the hell am I doing wrong?Any ideas?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOLVED: CFMX JRun Services on Windows 2000

2004-04-13 Thread Adrocknaphobia
Thanks, that did the trick.
-adam

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 13, 2004 02:56 PM
 To: 'CF-Talk'
 Subject: RE: CFMX JRun Services on Windows 2000
 
  Is there anyway to add these instance as services like the 
  default cfusion one that is created during the initial 
  install of the server?
 
 You need to register them as services by running jrunsvc.exe from the
 command line with the appropriate parameters.
 
 jrunsvc -install cfusion2 cfusion2 (or something like that).
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 phone: 202-797-5496
 fax: 202-797-5444
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Ryan Kime
You said IIS, do you have the virtual directory for JrunScripts in this web?

 
-Original Message-
From: Sung Woo [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 10:02 AM
To: CF-Talk
Subject: Re: Web Services and CFMX6.1 -- Why doesn't it work?

I don't get a blank page, but I do get a redirect to the component browser,
which looks something like this:

ws.helloworld
Component helloworld 

hierarchy: WEB-INF.cftags.component
ws.helloworld

path: E:\webroot\ws\helloworld.cfc
properties: 

methods: getMessage 
* - private method 

getMessage
remote string getMessage ( required string name ) 

Output: supressed
Parameters:
name: string, required, name 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Disappearing/reappearing application variables...

2004-04-13 Thread Tyler Silcox
Yea, the Administrator's timeout for application vars is set to 2 days, and
I have my cfapplication tag asking for 12 hours...any other ideas?

 
Tyler

_

From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 10:43 AM
To: CF-Talk
Subject: RE: Disappearing/reappearing application variables...

 Is there any reason application variables would disappear 
 before the application timeout set in Application.cfm file?

If the application timeout in the CF Administrator is less than what it is
set in your cfapplication tag.Did you check the admin setting?

Mike 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Stay in Domain...?

2004-04-13 Thread Bailey, Neal
Ok I have one for you...

 
I have this site that I am working on... http://65.218.34.47
http://65.218.34.47/and it is going to be somewhat template based for
our users. Basically we have Division leaders that will get one of these
sites to help with recruiting new people. Each site will be personalized for
the Division things like menus, schedules, testimonials and a few other
things will be dynamic information. What I would like to do also is have it
to where if the recruiting division has their own domain name like
www.recruitme.com http://www.recruitme.com/and I have the domain
pointing to our servers, how can I make the site stay in the domain when the
main site is www.ugaonline.com http://www.ugaonline.com/ . Does this make
sense?...

 
We will have about 130 recruiting divisions that will all have their own
domain name. But we have only one website. I would like anyone with the
domain name to stay in their domain when someone is referred from their site
instead of being redirected like I have done in the past. 

 
Is there a way to do this... I was planning on reading the host header and
using ColdFusion to determine the incoming site and display the recruiting
districts information dynamically using the domain name as unique variable. 

 
Any ideas... thanks.. 

 
Neal Bailey
Internet Marketing Manager
E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Disappearing/reappearing application variables...

2004-04-13 Thread Adrocknaphobia
Are there any other application.cfm on this server instnace. If so do they all have different application names?

-Adam

 -Original Message-
 From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 13, 2004 02:43 PM
 To: 'CF-Talk'
 Subject: RE: Disappearing/reappearing application variables...
 
  Is there any reason application variables would disappear 
  before the application timeout set in Application.cfm file?
 
 If the application timeout in the CF Administrator is less than what it is
 set in your cfapplication tag.Did you check the admin setting?
 
 Mike
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
can someone please respond to my post!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
Thanks for all your help, guys.I tried the snippet on my production server, and sure enough, it runs just fine.So I guess it is my server config.What could it be, though?I don't understand what inside CF could cause this, when all evidence points to the file being exactly where it should be.The Mappings on both production and test are identical...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
Ryan -- yes, I do have that vdir on both production and test...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Stay in Domain...?

2004-04-13 Thread Burns, John D
Well, the easiest way would be to just make all of your links relative.
Then, no matter what name they come in on, everything works.If you
have to provide full domain names, just use cgi.http_host to get the
current domain name/host that the user came in on.

John Burns 

-Original Message-
From: Bailey, Neal [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 11:09 AM
To: CF-Talk
Subject: Stay in Domain...?

Ok I have one for you...

 
I have this site that I am working on... http://65.218.34.47
http://65.218.34.47/and it is going to be somewhat template based
for our users. Basically we have Division leaders that will get one of
these sites to help with recruiting new people. Each site will be
personalized for the Division things like menus, schedules, testimonials
and a few other things will be dynamic information. What I would like to
do also is have it to where if the recruiting division has their own
domain name like www.recruitme.com http://www.recruitme.com/and I
have the domain pointing to our servers, how can I make the site stay in
the domain when the main site is www.ugaonline.com
http://www.ugaonline.com/ . Does this make sense?...

 
We will have about 130 recruiting divisions that will all have their own
domain name. But we have only one website. I would like anyone with the
domain name to stay in their domain when someone is referred from their
site instead of being redirected like I have done in the past. 

 
Is there a way to do this... I was planning on reading the host header
and using ColdFusion to determine the incoming site and display the
recruiting districts information dynamically using the domain name as
unique variable. 

 
Any ideas... thanks.. 

 
Neal Bailey
Internet Marketing Manager
E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread Hua Wei
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Attachment'.
This error says the table Attachment doesn't exist in the database.
Does it exist in your DATASOURCE=db?

-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:33 AM
To: CF-Talk
Subject: cfx_getImage error! Don't know what's causing it

Hello Everybody, I'm really hoping that someone will help me.

A lot of people have used the cfx_getImage tag to open up office
documents (word,excel, blah). I thought I'll use it to do the same. The
documents are stored on the database table as binary objects.

I registered the cfx tag in the administrator. I'm calling it on the
page like this:

cfquery name=getAttachmentDetails datasource=dbselect * from
Attachment where id = '#url.id#'
/cfquery

CFX_GETIMAGE
 DATASOURCE=db
 USER=dbUserName
 PASSWORD=dbPassword
 SQL=select filename FROM Attachment WHERE id = '#url.id#'
OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil
eName#

I get this error message:

The error occurred in
E:\inetpub\wwwroot\viewattachment.cfm: line 8

 
6 : CFX_GETIMAGE 
7 : 	DATASOURCE=db
8 : 	USER=dbUserName
9 : 	PASSWORD=dbPassword
10 : 	SQL=select filename FROM Attachment WHERE id =
'#url.id#'

 
(USER=dbUserName is in bold)

SQL:select filename FROM Attachment WHERE id = '01057870'
SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg =
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Attachment'.
pcbErrorMsg = 93

Does anybody know why I'm getting this error? I would really appreciate
your help

Regards,
cfcoder

	
		
__
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
this is what is dumped in the Stack Trace:

coldfusion.tagext.DerivedNativeCFXException: Error occurred in tag CFX_GETIMAGE
	at coldfusion.tagext.NativeCfx.processRequest(Native Method)
	at coldfusion.tagext.CfxTag.doStartTag(CfxTag.java:110)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
	at cfviewattachment2ecfm50240.runPage(E:\inetpub\wwwroot\tempDocumentsFolder\viewattachment.cfm:8)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:105)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX JRun Services on Windows 2000

2004-04-13 Thread Adrocknaphobia
ok, now how can I get rid of the default 'cfusion' instance. When I try jrunsvc -remove cfusion, it says the specified service does nto exist.

-adam

 -Original Message-
 From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 13, 2004 03:06 PM
 To: 'CF-Talk'
 Subject: SOLVED:CFMX JRun Services on Windows 2000
 
 Thanks, that did the trick.
 -adam
 
  -Original Message-
  From: Dave Watts [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, April 13, 2004 02:56 PM
  To: 'CF-Talk'
  Subject: RE: CFMX JRun Services on Windows 2000
  
   Is there anyway to add these instance as services like the 
   default cfusion one that is created during the initial 
   install of the server?
  
  You need to register them as services by running jrunsvc.exe from the
  command line with the appropriate parameters.
  
  jrunsvc -install cfusion2 cfusion2 (or something like that).
  
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  phone: 202-797-5496
  fax: 202-797-5444
  
  
  
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
yes it does. I've double checked it. I don't have the source for the dll (.cpp file). I was using the getImage.dll on another project and thought I can reuse it. Tell me, does the .cpp file specify the dsn name? Because if it does then I'll get this error because the dsn name used in that project is different from the dsn name I'm using on this project.

Do you have the .cpp files for this dll?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MX: Scheduler firing off too often

2004-04-13 Thread Mark W. Breneman
In that email, that you are sending to your self, you may also want to add a
few CGI vars to see where and what is calling that cfm page.One time
Google some how found a .cfm page that I had scheduler set to run once a
week and every time Google spidered the site it would run that page.

HTTP_REFERER: b#CGI.HTTP_REFERER#/bbr

HTTP_USER_AGENT: b#CGI.HTTP_USER_AGENT#/bbr 

REMOTE_ADDR: b#CGI.REMOTE_ADDR#/bbr

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
http://www.vividmedia.com www.vividmedia.com
608.270.9770

_

From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:48 AM
To: CF-Talk
Subject: Re: MX: Scheduler firing off too often

Ack, should have said Linux instead of Windows there.

At 08:45 AM 4/13/2004, you wrote:
Hey folks -

I've got an MX box (Windows) with a oddly behaving scheduler. I've got a
single task in the list, that fires off once every three minutes. I've got
the task aborting early, but not before it sends me a quickie time-stamped
email. Every once in a while, I'll get two or three emails with the same
time (sans seconds) on it.

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: flash remoting books

2004-04-13 Thread Christian Cantrell
I recommend Tom's book, as well.I worked on the ColdFusion section, 
so I know it's comprehensive.:)

Christian

On Apr 12, 2004, at 11:49 AM, Dave Carabetta wrote:

 
Sorry for the crosspost all . . .


I know that Tom Muck's book Flash Remoting: The Definitive Guide has
gotten solid reviews. I looked at it in a bookstore once and it seemed
pretty comprehensive. I just don't do much with remoting, so I can't 
 give
you any real world feedback.

http://www.amazon.com/exec/obidos/ASIN/059600401X/104-8416979-6521558

Regards,
Dave.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
I'm placing the query results of several fields into an HTML list. The href of each generated link includes an onClick event. Because of that, I need to create a _javascript_ variable that holds the values of the style name field from the query. I don't know how to populate the style name variable for each list item.

Thanks for your interest and your assistance.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
I changed the code a select statement a bit. I appended 'dbo.' before the table name. 

CFX_GETIMAGE 
DATASOURCE=db 
USER=dbUserName 
PASSWORD=dbPassword 
SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' 
OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil 
eName# 

This was the error I was getting before I made the above change:

SQL:select filename FROM Attachment WHERE id = '01057870' 
SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = 
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 
'Attachment'. 
pcbErrorMsg = 93 

And this is what I get now:

SQL:select filename FROM Attachment WHERE id = '01057870'
SQLExecDirect Failed szSqlState = S0002 
pfNativeError = 208
szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'.
pcbErrorMsg = 97

Notice the difference in the pcbErrorMsg value. Does that tell you anything?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT: Web + v5.0

2004-04-13 Thread Ciliotta, Mario
Has anyone heard of this product:Web + v5.0 -- It is supposed to be easier
to use and less expensive than CF.

 
Mario
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread Burns, John D
Any chance attachment is a reserved keyword?Maybe you should do select
[filename] from dbo.[Attachment] where id = '01057870'

I don't know if that would make any difference, but I know I've had
trouble in the past with using reserved words.

John Burns 

-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 11:52 AM
To: CF-Talk
Subject: Re: cfx_getImage error! Don't know what's causing it

I changed the code a select statement a bit. I appended 'dbo.' before
the table name. 

CFX_GETIMAGE
DATASOURCE=db 
USER=dbUserName 
PASSWORD=dbPassword 
SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' 
OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil
eName# 

This was the error I was getting before I made the above change:

SQL:select filename FROM Attachment WHERE id = '01057870' 
SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg =
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Attachment'. 
pcbErrorMsg = 93 

And this is what I get now:

SQL:select filename FROM Attachment WHERE id = '01057870'
SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg =
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'dbo.CallComments_attachment'.
pcbErrorMsg = 97

Notice the difference in the pcbErrorMsg value. Does that tell you
anything?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




PDF Report Generation from ColdFusion

2004-04-13 Thread Ruben Ghosal
I posted this message earlier. Does anybody know how to create a report in PDF format from an existing ColdFusion report?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX JRun Services on Windows 2000

2004-04-13 Thread Dave Watts
 ok, now how can I get rid of the default 'cfusion' instance. 
 When I try jrunsvc -remove cfusion, it says the specified 
 service does nto exist.

I think the default service name is Macromedia JRun CFusion Server.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Disappearing/reappearing application variables...

2004-04-13 Thread Tyler Silcox
Yep, it's a brand new CFMX install, with three separate sites with 3
separate application names.

 
Someone was complaining about a JRun connection closed error a couple days
ago and I'm beginning to wonder if the server's hanging, then restarting
itself, which would then cause my application vars to reset.

 
But when I view the logs, the only log file I can find that says anything
about ColdFusion starting/stopping is the server.log, and the only record it
has of ColdFusion started was 5 days ago when the server was first
installed...is this the correct place for checking CFMX service
starts/restarts to check my theory, or is there somewhere else I can look?

 
Tyler S

_

From: Adrocknaphobia [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 11:13 AM
To: CF-Talk
Subject: Re: Disappearing/reappearing application variables...

Are there any other application.cfm on this server instnace. If so do they
all have different application names?

-Adam

 -Original Message-
 From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 13, 2004 02:43 PM
 To: 'CF-Talk'
 Subject: RE: Disappearing/reappearing application variables...
 
  Is there any reason application variables would disappear 
  before the application timeout set in Application.cfm file?
 
 If the application timeout in the CF Administrator is less than what it is
 set in your cfapplication tag.Did you check the admin setting?
 
 Mike
 
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Bryan Stevenson
Some sample code would really help here as JS is picky about syntax.

That said...

I'll assume you're popping open a window ;-)

here's some psuedo-code

cfoutput
>
/cfoutput

Then have a _javascript_ function in the HEAD block that takes 2 arguments.So all you're doing is setting the values of the arguments passed to the function with CF vars.

Hope that helps

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Joy Holman 
To: CF-Talk 
Sent: Tuesday, April 13, 2004 8:44 AM
Subject: Re: passing multiple CF vaules to a _javascript_ variable

I'm placing the query results of several fields into an HTML list. The href of each generated link includes an onClick event. Because of that, I need to create a _javascript_ variable that holds the values of the style name field from the query. I don't know how to populate the style name variable for each list item.

Thanks for your interest and your assistance.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread Hua Wei
Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'dbo.CallComments_attachment'.

Table CallComments_attachment doesn't exist in the database? Or it isn't
owned by dbo? 

-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 11:52 AM
To: CF-Talk
Subject: Re: cfx_getImage error! Don't know what's causing it

I changed the code a select statement a bit. I appended 'dbo.' before
the table name. 

CFX_GETIMAGE
DATASOURCE=db 
USER=dbUserName 
PASSWORD=dbPassword 
SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' 
OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil
eName# 

This was the error I was getting before I made the above change:

SQL:select filename FROM Attachment WHERE id = '01057870' 
SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg =
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Attachment'. 
pcbErrorMsg = 93 

And this is what I get now:

SQL:select filename FROM Attachment WHERE id = '01057870'
SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg =
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'dbo.CallComments_attachment'.
pcbErrorMsg = 97

Notice the difference in the pcbErrorMsg value. Does that tell you
anything?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: PDF Report Generation from ColdFusion

2004-04-13 Thread Burns, John D
People already responded to you.There are many custom tags out there
to convert to PDF.I believe the macromedia exchance has html2pdf which
will convert a page you output using CF to PDF.

John Burns 

-Original Message-
From: Ruben Ghosal [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 11:58 AM
To: CF-Talk
Subject: PDF Report Generation from ColdFusion

I posted this message earlier. Does anybody know how to create a report
in PDF format from an existing ColdFusion report?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Access 2003 ODBC

2004-04-13 Thread Jim McAtee
- Original Message - 
From: Samuel R. Neff [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 12, 2004 8:07 PM
Subject: RE: Access 2003 ODBC

 Access 2000 is the last major release of the Jet engine, so the data
portion
 of the database, what you're using through CF, is exactly the same for
 Access 2000 and Access 2003.There's no point in upgrading for just a
data
 back-end.

 The Jet team was disbanded soon after Access 2000 was released, most of
them
 going to the MSDE group.MS is interested in migrating everyone to
 MSDE/MSSQL and blindly ignoring the fact that you need a DBA to use
these
 options.

 HTH,

Thanks.That helps, but it's still not clear whether that means you can
or cannot use an Access 2003 with the last version of the Jet engine.
There's no reason to 'upgrade' to Access 2003, just that someone with
Access 2003 installed on their workstations would probably find it more
convenient to use Access 2003 on the server.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
I've got my code in the first post of this thread. Based on the 

code you've written, it looks like I would get all the values in 

one onClick event. I need to generate one value per onClick. Each 

onClick is within an li that holds other query results, so I 

can't just loop through the stylename variable within one 

onClick. Am I making any sense?

Thanks for your help.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Access 2003 ODBC

2004-04-13 Thread Dave Watts
 Thanks. That helps, but it's still not clear whether that 
 means you can or cannot use an Access 2003 with the last 
 version of the Jet engine. There's no reason to 'upgrade' 
 to Access 2003, just that someone with Access 2003 installed 
 on their workstations would probably find it more convenient 
 to use Access 2003 on the server.

There's no need to have any version of Access on the server. If you have the
latest version of Jet on your server, it can read Access 2000 and 2003
files, without requiring any additional installation. Jet used to be bundled
with MDAC, but it's now available separately (although you'll still want the
latest version of MDAC too, typically):

http://msdn.microsoft.com/data/downloads/updates/default.aspx#jet

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MX: Scheduler firing off too often

2004-04-13 Thread Scott Weikert
At 09:35 AM 4/13/2004, you wrote:
In that email, that you are sending to your self, you may also want to add a
few CGI vars to see where and what is calling that cfm page.One time
Google some how found a .cfm page that I had scheduler set to run once a
week and every time Google spidered the site it would run that page.

That's a damn fine idea. Thanks!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Dick Applebaum
where do you want to loop thru the style name?

1) when creating the html/js with CF/

2) when the user initiates the js onClick?

if 1) above, where  what format is the list of styles?

Dick

On Apr 13, 2004, at 9:23 AM, Joy Holman wrote:

 I've got my code in the first post of this thread. Based on the

code you've written, it looks like I would get all the values in

one onClick event. I need to generate one value per onClick. Each

onClick is within an li that holds other query results, so I

can't just loop through the stylename variable within one

onClick. Am I making any sense?

Thanks for your help.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web + v5.0

2004-04-13 Thread Tony Weeg
oddly enough I hadnt until I checked my mail today, I got a cd today to
mario.

someone must have gotten ahold of our addresses/titles/etc, and sent this
out..i bet we arent the only ones on this list to have gotten their promo
cd.

I wonder who gave our info away???

tony 

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 11:53 AM
To: CF-Talk
Subject: OT: Web + v5.0

Has anyone heard of this product:Web + v5.0 -- It is supposed to be easier
to use and less expensive than CF.

 
Mario
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX JRun Services on Windows 2000

2004-04-13 Thread Adrocknaphobia
Thanks again. I had tried the full display name, but I neglected the quotes before.

-adam

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 13, 2004 04:04 PM
 To: 'CF-Talk'
 Subject: RE: CFMX JRun Services on Windows 2000
 
  ok, now how can I get rid of the default 'cfusion' instance. 
  When I try jrunsvc -remove cfusion, it says the specified 
  service does nto exist.
 
 I think the default service name is Macromedia JRun CFusion Server.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 phone: 202-797-5496
 fax: 202-797-5444
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web + v5.0

2004-04-13 Thread Tony Weeg
not to mention the freakin thing uses #'s 

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 12:34 PM
To: CF-Talk
Subject: RE: Web + v5.0

oddly enough I hadnt until I checked my mail today, I got a cd today to
mario.

someone must have gotten ahold of our addresses/titles/etc, and sent this
out..i bet we arent the only ones on this list to have gotten their promo
cd.

I wonder who gave our info away???

tony 

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 11:53 AM
To: CF-Talk
Subject: OT: Web + v5.0

Has anyone heard of this product:Web + v5.0 -- It is supposed to be easier
to use and less expensive than CF.

 
Mario
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
Yes, I want to output the stylenames as the html code is generated.
Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas.
Here's the code with the CF list.

cfqueryname=q_menu datasource=mchfaq
SELECT * from qa_menu
order by menu_sortText
/cfquery
cfoutput
cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)#

script language=_javascript_ type=text/_javascript_
!--
function targetid(){
return #bmarklinkList#;
}
--
/script
/cfoutput

ul
cfoutput query=q_menu
liAHREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans 
 /a/li 
/cfoutput
/ul

Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick.

I've substituted style name values where the js goes, like so:
liA HREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans
 /a /li

liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink#cfelse##Ans
 /a /li

liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink# cfelse##Ans
 /li

I'd really like this to work. I think I could use this code a lot.
Thanks again.
Joy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How many class files do YOU have?

2004-04-13 Thread Mark Johnson
Brook,
Well I was curious about your question so i went ahead and took a look at
how many class files we have.We also create cfm files on the fly for new
accounts etc.On checking we have 25,759 class files in the cfclasses
directory.All the suggestions below are accurate.Be sure to set your
template cache as high as is reasonable with the memory you have.Also the
jvm settings mentioned are very important.These things should all make a
huge difference in your performance.

 
Mark

-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]
Sent: Friday, April 09, 2004 12:25 PM
To: CF-Talk
Subject: How many class files do YOU have?

I repoted to this list awhile ago about really long start up times for one 
of my apps on the first run. It seems that this problem has been resolved 
by defragging the HD? The C:\CFusionMX\wwwroot\WEB-INF\cfclasses folder had 
a lot of fragmented files as well as other areas on the HD. Does that make 
sense?

Anyhow, I have 6,591 class files in my class folder taking up about 80 
megs. So, I am curious now how many class files ya'll have on your servers?

And another question related to disk usage; what are the guidelines for a 
paging file and is it needed if you have lots of physical ram? The reason I 
ask is because I wonder if a fragmented HD, and a page file on that disk 
might cause problems. I've had some JavaOutOfMemory errors, so I am looking 
for answers everywhere :)

Brook 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Bryan Stevenson
I didn't see any code and without it I'm afraid I'm not getting you.I can say that what I posted will work...it shows you the how to get the vars into JS...it's up to you to pass the correct vars based on your code (nested loops etc.) ;-)

If you can re-post the code I'm sure the lights will come on ;-)

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Joy Holman 
To: CF-Talk 
Sent: Tuesday, April 13, 2004 9:23 AM
Subject: Re: passing multiple CF vaules to a _javascript_ variable

I've got my code in the first post of this thread. Based on the 

code you've written, it looks like I would get all the values in 

one onClick event. I need to generate one value per onClick. Each 

onClick is within an li that holds other query results, so I 

can't just loop through the stylename variable within one 

onClick. Am I making any sense?

Thanks for your help.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web + v5.0

2004-04-13 Thread Josh Remus
I have to say that I'm amazed every time I find one of these smaller web
application servers/scripting languages.Don't we have enough?PLEASE?
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 12:46 PM
To: CF-Talk
Subject: RE: Web + v5.0

not to mention the freakin thing uses #'s

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 12:34 PM
To: CF-Talk
Subject: RE: Web + v5.0

oddly enough I hadnt until I checked my mail today, I got a cd today to
mario.

someone must have gotten ahold of our addresses/titles/etc, and sent this
out..i bet we arent the only ones on this list to have gotten their promo
cd.

I wonder who gave our info away???

tony

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 11:53 AM
To: CF-Talk
Subject: OT: Web + v5.0

Has anyone heard of this product:Web + v5.0 -- It is supposed to be
easier
to use and less expensive than CF.

Mario
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MX: Scheduler firing off too often

2004-04-13 Thread Mark W. Breneman
If you find that the page is being run by something other than CFSCHEDULE
try something like this

cfif left(http_user_agent,10) is not CFSCHEDULEcfabort/cfif



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770

_

From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 11:29 AM
To: CF-Talk
Subject: RE: MX: Scheduler firing off too often

At 09:35 AM 4/13/2004, you wrote:
In that email, that you are sending to your self, you may also want to add
a
few CGI vars to see where and what is calling that cfm page.One time
Google some how found a .cfm page that I had scheduler set to run once a
week and every time Google spidered the site it would run that page.

That's a damn fine idea. Thanks!

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
I finally figured out why I was getting the error. I went to the ODBC Administrator under Administrative Tools and re-configured the dsn. For some reason my database was not selected under the change the default database to section. I set it to db tested the connection successfully and it all works.

Thank you all for your help.
Best Regards,
cfcoder
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Dick Applebaum
You use a SELECT *

This is usually a bad habit as it makes the SQL engine do extra work  
degrades performance -- in this case, it also causes confusion.'

What is the name of the column in the query that contains the style 
name?

Dick
On Apr 13, 2004, at 9:53 AM, Joy Holman wrote:

 Yes, I want to output the stylenames as the html code is generated.
Sorry, I added the list after sending the previous code. (Actually, I 
 don't care if I have a list of the stylenames or not; I just want to 
 get one of the style name values from the query into each of the 
 onClick events.) The format of the list is defaulted to commas.
Here's the code with the CF list.

cfquery  name=q_menu datasource=mchfaq
SELECT * from qa_menu
order by menu_sortText
/cfquery
cfoutput
cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)#

script language=_javascript_ type=text/_javascript_
!--
function targetid(){
return #bmarklinkList#;
}
--
/script
/cfoutput

ul
cfoutput query=q_menu
liA  HREF="" q_menu.menu_nonBmarkLink neq 
 #q_menu.menu_nonBmarkLink#cfelse##Ans
 
 /a/li
/cfoutput
/ul

Basically, if the href value is an external URL, ignore the rest of 
 the if statement. If the href value is a bookmark link, have the href 
 go to a specific position on the page, (#Ans), and using CSS display 
 the previously hidden content of the style names in the onClick.

I've substituted style name values where the js goes, like so:
liA HREF="" q_menu.menu_nonBmarkLink neq 
 #q_menu.menu_nonBmarkLink#cfelse##Ans
 
 /a /li

liA  HREF="" q_menu.menu_nonBmarkLink 
 neq#q_menu.menu_nonBmarkLink#cfelse##Ans
 
 /a /li

liA  HREF="" q_menu.menu_nonBmarkLink 
 neq#q_menu.menu_nonBmarkLink# cfelse##Ans
 
 /li

I'd really like this to work. I think I could use this code a lot.
Thanks again.
Joy

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
Yes, I want to output the stylenames as the html code is generated. 
Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. 
Here's the code with the CF list. 

cfqueryname=q_menu datasource=mchfaq 
SELECT * from qa_menu 
order by menu_sortText 
/cfquery 
cfoutput 
cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)# 

script language=_javascript_ type=text/_javascript_ 
!-- 
function targetid(){ 
return #bmarklinkList#; 
} 
-- 
/script 
/cfoutput 

ul 
cfoutput query=q_menu 
liAHREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans 
 /a/li 
/cfoutput 
/ul 

Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. 

I've substituted style name values where the js goes, like so: 
liA HREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans 
 /a /li 

liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink#cfelse##Ans 
 /a /li 

liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink# cfelse##Ans 
 /li 

I'd really like this to work. I think I could use this code a lot. 
Thanks again. 
Joy

 I didn't see any code and without it I'm afraid I'm not getting you.
 I can say that what I posted will work...it shows you the how to get 
 the vars into JS...it's up to you to pass the correct vars based on 
 your code (nested loops etc.) ;-)
 
 If you can re-post the code I'm sure the lights will come on ;-)
 
 Bryan Stevenson B.Comm.
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 t. 250.920.8830
 e. [EMAIL PROTECTED]
 
 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com

 - Original Message - 

 From: Joy Holman 

 To: CF-Talk 

 Sent: Tuesday, April 13, 2004 9:23 AM

 Subject: Re: passing multiple CF vaules to a _javascript_ variable
 
 

 I've got my code in the first post of this thread. Based on the 
 

 code you've written, it looks like I would get all the values in 
 

 one onClick event. I need to generate one value per onClick. Each 
 

 onClick is within an li that holds other query results, so I 
 

 can't just loop through the stylename variable within one 
 

 onClick. Am I making any sense?
 

 Thanks for your help.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
Yes, I want to output the stylenames as the html code is generated. 
Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. 
Here's the code with the CF list. 

cfqueryname=q_menu datasource=mchfaq 
SELECT * from qa_menu 
order by menu_sortText 
/cfquery 
cfoutput 
cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)# 

script language=_javascript_ type=text/_javascript_ 
!-- 
function targetid(){ 
return #bmarklinkList#; 
} 
-- 
/script 
/cfoutput 

ul 
cfoutput query=q_menu 
liAHREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans 
 /a/li 
/cfoutput 
/ul 

Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. 

I've substituted style name values where the js goes, like so: 
liA HREF="" q_menu.menu_nonBmarkLink neq #q_menu.menu_nonBmarkLink#cfelse##Ans 
 /a /li 

liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink#cfelse##Ans 
 /a /li 

liAHREF="" q_menu.menu_nonBmarkLink neq#q_menu.menu_nonBmarkLink# cfelse##Ans 
 /li 

Thanks. 
Joy

where do you want to loop thru the style name?

1) when creating the html/js with CF/

2) when the user initiates the js onClick?

if 1) above, where  what format is the list of styles?

Dick



On Apr 13, 2004, at 9:23 AM, Joy Holman wrote:


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Web + v5.0

2004-04-13 Thread Scott Brady
Tony Weeg wrote:

 I wonder who gave our info away???

Maybe if more of us had clicked on those ads in the cf-talk mails, 
Michael wouldn't have had to sell our info.

:)

Seriously, it's a good question. I can't imagine Macromedia would have.
Is everyone who's received this Web+ CD subscribed to the CF Developer's 
Journal?I wouldn't put it past Sys-Con.

Scott

-- 
---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
I finally got it to work. I went to the ODBC section under Administrative Tools re-configured the settings explicting selecting my database under the change the default database to section of the DSN Configuration. I don't know why it didn't select it in the first place, but it don't matter now, it just works. Thank you all for your help
cfcoder
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
Have a different problem now, actually I have a question. If the user makes changes to the document, is it possible to save the changes directly back to the database when the user selects the File-Save option from the menu or ctrl-s.

CFX_GETIMAGE 
DATASOURCE=db 
USER=dbUserName 
PASSWORD=dbPassword 
SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' 
OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName#

CFHEADER NAME=Content-Type VALUE=application/msexcel
CFHEADER NAME=Content-Disposition VALUE=inline; filename=testDoc.xls
CFCONTENT TYPE=application/msexcel FILE=E:\inetpub\wwwroot\testDocs.xls deletefile=Yes

The above code loads the document in a browser.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
menu_bmarkLink is the name of the column in the query that contains the style 
name

You use a SELECT *

This is usually a bad habit as it makes the SQL engine do extra work  
degrades performance -- in this case, it also causes confusion.'

What is the name of the column in the query that contains the style 
name?

Dick
On Apr 13, 2004, at 9:53 AM, Joy Holman wrote:


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfx_getImage error! Don't know what's causing it

2004-04-13 Thread cf coder
Have a different problem now, actually I have a question. If the user makes changes to the document, is it possible to save the changes directly back to the database when the user selects the File-Save option from the menu or ctrl-s.

CFX_GETIMAGE 
DATASOURCE=db 
USER=dbUserName 
PASSWORD=dbPassword 
SQL=select filename FROM dbo.Attachment WHERE id = '#url.id#' 
OUTPUT=E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName#

CFHEADER NAME=Content-Type VALUE=application/msexcel
CFHEADER NAME=Content-Disposition VALUE=inline; filename=testDoc.xls
CFCONTENT TYPE=application/msexcel FILE=E:\inetpub\wwwroot\testDocs.xls deletefile=Yes

The above code opens the document in a new browser
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Null Pointer from CFQUERY

2004-04-13 Thread Alisa Thomson
I am testing out an application that we want to migrate to CFMX (currently CF5).I am getting a NullPointerException from one of my queries when I use jConnect 5.5 (Sybase 12.5) instead of the Sybase driver that ships with CFMX.We want to use jConnect because all of our Java apps use that and we ran into other issues with the driver that ships with CFMX.Here is the query:

CFQUERY NAME=NameTest DATASOURCE=jConn
SELECT FirstNme
FROM etrade..Bank
WHERE BankId = 'WF'
/CFQUERY

As you can see, there are no variables in the query so the NullPointerException is not caused by an undefined var.The FROM clause is referencing a view that actually references another view in another database.We have other queries set up this same way that work fine under jConnect 5.5. The stacktrace just says:

java.lang.NullPointerException

no other information.Anyone have any ideas?

Thanks in advance.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




  1   2   >