Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
onClick didn't understand a CF variable like: "#linkStyle#". It wants _javascript_. I don't know how to make the _javascript_ variable I create from the CF variable return each of the different values in the onClick event.

I get:
> menu item one: ...>
    
> menu item two: ...>
    
> menu item two: ...>

How can I make the _javascript_ variable I create from the CF variable loop through the values properly?

Thanks for trying to help with this problem.

> But by the time the code gets to the browser, #linkStyle#  will have 
> been replaced by exactly what you show us here
    
> menu item one: ...>
    
> menu item two: ...>
    
> menu item two: ...>
> 
> "view source" from your browser might help clear things up for you.
> 
> Or like Dick, I don't understand :(

 
> 
  
> - Original Message - 
  
> From: Joy Holman 
  
> To: CF-Talk 
  
> Sent: Tuesday, April 13, 2004 4:12 PM
  
> Subject: Re: passing multiple CF vaules to a _javascript_ variable
> 
> 
  
> Would this information help explain what I need?
> 
  
> Here's where the styles comes in:
  
> I have a CSS stylesheet with these values:
  
> #FellSvc{display:none;}
  
> #MinorRts{display:none;}
  
> #AmnInf{display:none;}
  
> #AnteSter{display:none;}
> 
  
> In the db table, I have a column for the same styles from the 
> stylesheet. Let's say the column name is "linkStyle" (like Dick's 
> example). Another column in the db table has the text for the menu 
> link that displays on the page.
> 
  
> When a user clicks on a menu link (generated by the CF code prior to 
> the user interaction), an assoicated DIV with an ID equal to the 
> stylename displays its content because the onClick event tells the 
> matching style in the stylesheet to change "display=none" to 
> "display=block".
> 
  
> Using Dick's example, just change the end to something like this:
  
> >Now, iterating over the query:
  
> >
  
> >
  
> >
> #linkName# 
  
> >
> 
  
> Now, that doesn't work because #linkStyle# is CF and onClick needs js.
> 
  
> I don't know how to loop through this onClick variable to get the 
> range of values to be produced - one for each iteration of the results, 
> like:
  
> menu item one: ...>
  
> menu item two: ...>
  
> menu item two: ...>
  
> etc.
> 
  
> Does that help?
> 
  
> I need to be gone for a few hours, but I'll check back.
  
> Thank you and Dick so much for sticking with me on this!!!
> 
  
> > It sounds like you need to combine the results from the 2 queries 
> into 
  
> > a single query objectOR write a more complex query to join all 
> the 
  
> > tables involved to produce a single recordset.
  
> > 
  
> > 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 11:55 AM
    
> 
  
> > Subject: Re: passing multiple CF vaules to a _javascript_ variable
  
> > 
  
> > 
    
> 
  
> > The rendered output is a menu of links. One query column 
    
> 
  
> > returns the text for a link, another query column returns the target 
> 
  
> > for the link. The style name column is used in an onClick event to 
> set 
  
> > a CSS style to display content when clicked.
  
> > 
    
> 
  
> > The style name doesn't display on screen. 
  
> > 
    
> 
  
> > I'm able to generate all the values I need except for all the
    
> 
  
> > stylename values. If I only had one result from the query, it would 
> 
  
> > work fine. But I can't get the style name value to change as 
  
> > additional menu items are generated from the query results. Maybe 
> what 
  
> > I need is help with _javascript_.
  
> > 
    
> 
  
> > I don't know how to explain it any better. I guess that's a drawback 
> 
  
> > of not being able to talk in real time. Thanks for your efforts. 
> I'll 
  
> > keep at it. 
  
> > 
    
> 
  
> > event.
  
> > 
    
> 
  
> > From the query results, I create the js: target() which returns 
  
> > 
    
> 
  
> > the value of the stylename field. How do I loop over the 
  
> > 
    
> 
  
> > stylename values so that I get one value per onClick event which 
  
> > 
    
> 
  
> > is generates multiple times based on the number of records in 
  
> > 
    
> 
  
> > the query?
  
> > 
    
> 
  
> > >I am sorry...
    
> 
  
> > >
    
> 
  
> > >I can't understand what you are trying to do.
    
> 
  
> > >
    
> 
  
> > >It is a simple matter to include the value of a column from the 
> query 
  
> > 
    
> 
  
> > >in a line of text generated within the output 

RE: OT ? Emulation

2004-04-13 Thread Nathan C. Smith
On Unix: Wget.  PHP has it's own version of CFHTTP using the CURLlib.
Certainly Perl has something - or more than one option- as well.

 
-Nate

-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 1:13 PM
To: CF-Talk
Subject: OT ?  Emulation

Well maybe heresy, instead of OT ;-)

Does anyone know of good non-CF scripts, Perl, CGI, etc. that perform the 
same function as ?

Thanks,

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




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

2004-04-13 Thread brobborb
how long do these reports take to process? hehe
  - Original Message - 
  From: Steve Nelson 
  To: CF-Talk 
  Sent: Tuesday, April 13, 2004 8:56 PM
  Subject: RE: How to streamline a request that uses many cfquery statements?

  Maybe I'm wrong, but I think even if you use a stored procedure it's going
  to process in series. I doubt it's going to give you a huge performance
  boost. I posted a handful of tests on my blog (http://steve.secretagents.com
   ) last week comparing cfquery to
  cfstoredproc. Another option is to process the report before the user
  accesses it. Like have a scheduled process that runs in the middle of the
  night, or every hour or every 1 minute and saves the output to a static
  file. That would be very easy to do with cfschedule, but has the downside of
  potentially being out of sync with the live data. Of course, there are
  tricks to get around that. If you're interested in hearing them let me know.

  Steve Nelson

    _  

  From: Earl, George [mailto:[EMAIL PROTECTED] 
  Sent: Tuesday, April 13, 2004 10:40 AM
  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]




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

2004-04-13 Thread Steve Nelson
Maybe I'm wrong, but I think even if you use a stored procedure it's going
to process in series. I doubt it's going to give you a huge performance
boost. I posted a handful of tests on my blog (http://steve.secretagents.com
 ) last week comparing cfquery to
cfstoredproc. Another option is to process the report before the user
accesses it. Like have a scheduled process that runs in the middle of the
night, or every hour or every 1 minute and saves the output to a static
file. That would be very easy to do with cfschedule, but has the downside of
potentially being out of sync with the live data. Of course, there are
tricks to get around that. If you're interested in hearing them let me know.

Steve Nelson

  _  

From: Earl, George [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 10:40 AM
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]




Re: SOT: Flash Remoting vs Web Services vs XML

2004-04-13 Thread Brook Davies
I tend to like Flash Remoting and I think it has been proven to be a bit 
faster than consuming web services. And since the code in the CFC is the 
same for flash remoting as it is for web service's you should be cool on 
the CFMX side of things.

Flash works really nicely with CFMX and remoting is super fast. The net 
connection debugger is a great tool for seeing what is going back and forth 
to the server. I recommend Colin Moock's book  'Flash Remoting' the 
definitive guide.

I just moved from CFMX programming only to actionscript 2.0 - it was a huge 
shock to the system since I hadn't done much scripting before and did not 
understand OOP. But after struggling for a while (especially with the scope 
chain) I really like the way remoting and CFMX work together. Combine that 
with databinding and dataholders, its pretty cool.

You should search the archives of the flash coders and/or flashnewbies 
lists (http://chattyfig.figleaf.com/
  - maybe subscribe) to see if the answer to this has been covered. There 
was also an article on MM specifically about when to use what technology 
(remoting,web services, xml).

Brook

At 03:14 PM 4/13/2004, you wrote:

>Are you asking how the above options compare?
>
>If so, then a Google search on term "'flash remoting' 'web services'" pulls
>up existing assets on choosing between server-specific binary and
>server-independent XML/SOAP. (There are other discussions, too, but they're
>mixed in with other hits on those two query phrases.)
>
>... or is it that you already read Steven Webster's article at DevNet (the
>top hit on the above term), and have an additional question? or...?
>
> > ...  am having a bit of a hard time deciding which route
> > to pursue
>
>Well, it's trite of me, but one reliable approach is to keep things as
>simple as possible to solve the problem. You're already using ColdFusion so
>I'm assuming you can produce web services for consumption. Is there a
>reason why you couldn't go this way, and would instead be considering the
>tighter connectivity of the remoting approach...?
>
>(There are RIA mailing lists out there, but they tend to be focused on user
>experience rather than plumbing type, but I may not yet understand what is
>being sought.)
>
>Hmm, or maybe it's "What's an easy way to approach creating data-driven UIs
>in the Macromedia Flash authoring environment?" If so, then there's a
>portal which seems tuned to this need:
>http://www.macromedia.com/devnet/mx/flash/data_integration.html
>
>Or...?
>
>jd
>
>
>John Dowdell, Macromedia Developer Support, San Francisco
>(Best to reply on-list, to avoid my mighty spam filters!)
>Technotes: http://www.macromedia.com/support/search/
>Column: http://www.macromedia.com/desdev/jd_forum/
>Technical daily diary: http://www.macromedia.com/go/blog_jd
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[Fast 
>  Unsubscribe] [User Settings]
>
>--
>
>[]
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: SOT: Flash Remoting vs Web Services vs XML

2004-04-13 Thread John Dowdell
Are you asking how the above options compare?

If so, then a Google search on term "'flash remoting' 'web services'" pulls
up existing assets on choosing between server-specific binary and
server-independent XML/SOAP. (There are other discussions, too, but they're
mixed in with other hits on those two query phrases.)

... or is it that you already read Steven Webster's article at DevNet (the
top hit on the above term), and have an additional question? or...?

> ...  am having a bit of a hard time deciding which route
> to pursue

Well, it's trite of me, but one reliable approach is to keep things as
simple as possible to solve the problem. You're already using ColdFusion so
I'm assuming you can produce web services for consumption. Is there a
reason why you couldn't go this way, and would instead be considering the
tighter connectivity of the remoting approach...?

(There are RIA mailing lists out there, but they tend to be focused on user
experience rather than plumbing type, but I may not yet understand what is
being sought.)

Hmm, or maybe it's "What's an easy way to approach creating data-driven UIs
in the Macromedia Flash authoring environment?" If so, then there's a
portal which seems tuned to this need:
http://www.macromedia.com/devnet/mx/flash/data_integration.html

Or...?

jd


John Dowdell, Macromedia Developer Support, San Francisco
(Best to reply on-list, to avoid my mighty spam filters!)
Technotes: http://www.macromedia.com/support/search/
Column: http://www.macromedia.com/desdev/jd_forum/
Technical daily diary: http://www.macromedia.com/go/blog_jd
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: OT ? Emulation

2004-04-13 Thread Dick Applebaum
AFAIK, you can do the equivalent of CFHTTP with ASP (3rd-party add-on), 
PHP, and Perl -- wouldn't surprisme if jsp also has the capability,

You should be able to google for:  cfhttp equivalent  -- I found 
php fopen() that way

HTH

Dick

On Apr 13, 2004, at 11:13 AM, Nick Baker wrote:

> Well maybe heresy, instead of OT ;-)
>
>  Does anyone know of good non-CF scripts, Perl, CGI, etc. that perform 
> the
>  same function as ?
>
>  Thanks,
>
>  Nick
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX6.1 updater

2004-04-13 Thread Mark W. Breneman
I thought I heard about a new service pack for CF too, but a few weeks about
Ben had this to say,



"The next planned version of ColdFusion is codenamed "Blackstone", and
version numbers, pricing, etc., have yet to be discussed at all.

But, and this is my own opinion here, I doubt that there will be another
maintenance release for CFMX any time soon. CFMX needed updates, which is
why we released service packs and then v6.1, But 6.1 has proven to be
reliable and solid and arguably one of the best ColdFusion's ever, and so a
maintenance release is unlikely.

Bottom line, use 6.1 now, and stay tuned for announcements from MM." - Ben
Forta February 23

CF-Talk - Subject: Re: Question regarding CFMX 6.2

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

  _  

From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 3:37 PM
To: CF-Talk
Subject: Re: CFMX6.1 updater

AIT said:
> Hey does anyone have any idea when an updater for CFMX6.1 might be
> out?

I seem to recall somebody commenting that an updater was 'under
consideration'. Probably your best bet is
http://www.macromedia.com/go/wish/

Jochem

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




Re: SOT: Flash Remoting vs Web Services vs XML

2004-04-13 Thread Dick Applebaum
On Apr 13, 2004, at 1:46 PM, Chris Alvarado wrote:

> I don't really know much about Flex other than the few articles I have
>  read and the little bit of sample code I have seen. The problems I 
> have
>  with going the Flex route are as follows:
>
>  1) this project is extremely time sensitive.
>
>  - thus the web service route seems more feasible. I already know how 
> to
>  program a web service using CF (CFCs) and consuming a web service with
>  Flash is supposed to be pretty straight forward. Learning Flex (the 
> way
>  I take it) and integrating CF would be quite a bit more time consuming
>  than simply using AS to handle data returned by CF.

You can do it almost exactly the same with FlexFlash -- you have action 
script and remoting

But, on a time sensitive project, you are wise to go with familiar, 
established approaches -- rather than trying to learn & implement a 
release 1.0 product.

>  2) the interfaces that the design team has come up with for this 
> project
>  are VERY detailed and do have quite a bit of animation

Flash may be preferable for this reason too!

>
>  I guess the biggest challenge at the moment is making these decisions.
>  At the moment the choice seems pretty simple as I stated above. Web
>  Services + Flash, as I already know how to develop Web Services so all
>  that would be needed it so learn how to consume said web services with
>  Flash. However, the last thing I want to do is head down the wrong 
> path.
>  Id like to explore all the options out there and I agree, Flex seems
>  like a very viable option if this application had been designed to
>  harness it from the get go.
>
>

It does sound as if web services are in order for this project, at this 
time.

You should be able to get all you need for interfacing Flash with web 
services from Chapter 9 of the server geek book.

At some later time, when the pressure's off, you may wish to 
investigate the alternative of Flash Remoting -- binary data 
interchange rather than XML -- possible better performance & lower 
bandwidth.

HTH

Dick

>
>  -chris.alvarado
>
>  [ application developer ]
>
>  4 Guys Interactive, Inc.
>
>  281.807.4344 x1716
>
>
>
>_  
>
>  From: Dick Applebaum [mailto:[EMAIL PROTECTED]
>  Sent: Tuesday, April 13, 2004 3:06 PM
>  To: CF-Talk
>  Subject: Re: SOT: Flash Remoting vs Web Services vs XML
>
>  Have you considered Flex (or as I like to call it FlexFlash)
>
>  In my very limited experience Flex programming of RIAs is much easier
>  than Flash programming unless you are into heavy animation, visual
>  effects, etc.
>
>  You can get all you need for development with the Flex evaluation CD.
>
>  Then you can install flex to run in conjunction with CFMX -- which is
>  the best of both worlds (server-side power and client-side RIA)
>
>  The big barrier may be the price of Flex but I understand that 
> this
>  may be negotiable.
>
>  Your timeframe may also be a consideration -- there have been hints
>  that the next release of CFMX (BlackGuard, BlackHart, BlackMagic,
>  BlackBeauty, BlackStone, whatever) will include Flex capabilities.
>
>  The way it  (current CFMX Flex) appears to work is this:
>
>  1) You create CF templates with imbedded (or included) Flex source
>  containing special XML (MXXML) and ActionScript (similar to
>  _javascript_).
>
>  The CF template gets compiled to Java Byte code
>
>  The Flash portion of the template gets compiled to a SWF
>
>  Both are served to the requestor;
>
>  Here are the headers for a very simple CFMX Flex program (a Menu Tree)
>
>  "GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753
>  "GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753
>  "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244
>  "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244
>  "GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257
>  "GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257
>  "GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528
>  "GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528
>  "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656
>  "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656
>
>  It appears as if there are separate requests generated for:
>
>  1) the cf template
>  2) flex js
>  3) flex history
>  4) a swf containing the Flex portion of the CF template (mxml.swf)
>  5) a generic swf
>
>  This is quite a fewf connections for a simple program, but I am told
>  that as complexity increases, there should be fewer connections than
>  with a typical html page.
>
>  FlexFlash and Flash remoting tend to change the way you program -- not
>  always for the better
>
>  1) rather then populate the initial page with initial data as with
>  CF/HTML it is cleaner to do the following with FR:
>--download the RIA client
>--the client, when loaded, makes the request for initial data.
>  2) from a programming standpoint it is easy to ignore the overhead of
>  exchanging large XML

Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Dick Applebaum
On Apr 13, 2004, at 1:07 PM, Joy Holman wrote:

> Here's where the styles comes in:
>  I have a CSS stylesheet with these values:
>  #FellSvc{display:none;}
>  #MinorRts{display:none;}
>  #AmnInf{display:none;}
>  #AnteSter{display:none;}
>
>  In the db table, I have a column for the same styles from the 
> stylesheet. Let's say the column name is "linkStyle" (like your 
> example). Another column in the db table has the text for the menu 
> link that displays on the page.
>
>  When a user clicks on a menu link (generated by the CF code prior to 
> the user interaction), an assoicated DIV with an ID equal to the 
> stylename displays its content because the onClick event tells the 
> matching style in the stylesheet to change "display=none" to 
> "display=block".
>
>  Using your example, just change the end to something like this:
>  >Now, iterating over the query:
>  >
>  >
>  >
> #linkName# 
>  >
>
>  Now, that doesn't work because #linkStyle# is CF and onClick needs js.

but #linkStyle# is just the name of a CF variable, a container, if you 
will (this one just cones from the db).

that container can contain anything you want it to, for example:


'




myFunction( ) {

	alert("Hi");
}
'
/>


so in your example, the columns in the current row of the query contain:

columnName    Content
--    ---
linkName  Apple

linkURL   www.apple.com

linkStyle MinorRts

if column named linkStyle in the current row of the database contains 
MinorRts

then outputting:


#linkName# 

will yield:


Apple 

As I understand it, that is exactly what you want.

The next row will have different values so the next link will reflect 
this

HTH

Dick

>  I don't know how to loop through this onClick variable to get the 
> range of values to be produced - one for each iteration of the 
> results, like:
>  menu item one: ...>
>  menu item two: ...>
>  menu item two: ...>
>  etc.
>
>  Does that help?
>
>  >I realize that you are trying to create a list of links -- what I 
> can't
>  >understand is where the dynamic data is supposed to come from
>  >
>  >I would write something like:
>  >
>  >
>  >   SELECT  linkName, linkURL, linkStyle FROM linkTable
>  >
>  >
>  >yields a query containing:
>  >
>  >linkName    linkURL linkStyle
>  >--  --  --
>  >Apple   www.apple.com   colorful
>  >Macromedia  www.macromedia.com  flashy
>  >Microsoft   www.microsoft.com   opportunistic
>  >
>  >Now, iterating over the query:
>  >
>  >
>  > #linkName# 
>  >
>  >
>  >
>  >yields:
>  >
>  > Apple 
>  > Macromedia 
>  > Microsoft 
>  >
>  >I know this is not exactly what you want, but using the same 
> technique,
>  >can you show me what you want?
>  >
>  >Dick
>  >
>  >
>  >On Apr 13, 2004, at 11:55 AM, Joy Holman wrote:
>  >
>  >>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: SOT: Spammed from post to cf-talk

2004-04-13 Thread Scott Weikert
At 01:36 PM 4/13/2004, Dick wrote:
>I just got spammed with the subject line of a post I made to cf-talk.
>
>Where should I forward the spam msg to add the abuser to the filter?

Chances are, you got spammed directly. Spammers have been farming this list 
for emails it seems - I just got another spam on this list-specific email 
for Viagra etc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SOT: Flash Remoting vs Web Services vs XML

2004-04-13 Thread Chris Alvarado
I don't really know much about Flex other than the few articles I have
read and the little bit of sample code I have seen. The problems I have
with going the Flex route are as follows:

1) this project is extremely time sensitive.

- thus the web service route seems more feasible. I already know how to
program a web service using CF (CFCs) and consuming a web service with
Flash is supposed to be pretty straight forward. Learning Flex (the way
I take it) and integrating CF would be quite a bit more time consuming
than simply using AS to handle data returned by CF.

2) the interfaces that the design team has come up with for this project
are VERY detailed and do have quite a bit of animation



I guess the biggest challenge at the moment is making these decisions.
At the moment the choice seems pretty simple as I stated above. Web
Services + Flash, as I already know how to develop Web Services so all
that would be needed it so learn how to consume said web services with
Flash. However, the last thing I want to do is head down the wrong path.
Id like to explore all the options out there and I agree, Flex seems
like a very viable option if this application had been designed to
harness it from the get go.



-chris.alvarado

[ application developer ]

4 Guys Interactive, Inc.

281.807.4344 x1716



  _  

From: Dick Applebaum [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 3:06 PM
To: CF-Talk
Subject: Re: SOT: Flash Remoting vs Web Services vs XML

Have you considered Flex (or as I like to call it FlexFlash)

In my very limited experience Flex programming of RIAs is much easier 
than Flash programming unless you are into heavy animation, visual 
effects, etc.

You can get all you need for development with the Flex evaluation CD.

Then you can install flex to run in conjunction with CFMX -- which is 
the best of both worlds (server-side power and client-side RIA)

The big barrier may be the price of Flex but I understand that this 
may be negotiable.

Your timeframe may also be a consideration -- there have been hints 
that the next release of CFMX (BlackGuard, BlackHart, BlackMagic, 
BlackBeauty, BlackStone, whatever) will include Flex capabilities.

The way it  (current CFMX Flex) appears to work is this:

1) You create CF templates with imbedded (or included) Flex source 
containing special XML (MXXML) and ActionScript (similar to 
_javascript_).

The CF template gets compiled to Java Byte code

The Flash portion of the template gets compiled to a SWF

Both are served to the requestor;

Here are the headers for a very simple CFMX Flex program (a Menu Tree)

"GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753
"GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753
"GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244
"GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244
"GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257
"GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257
"GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528
"GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528
"GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656
"GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656

It appears as if there are separate requests generated for:

1) the cf template
2) flex js
3) flex history
4) a swf containing the Flex portion of the CF template (mxml.swf)
5) a generic swf

This is quite a fewf connections for a simple program, but I am told 
that as complexity increases, there should be fewer connections than 
with a typical html page.

FlexFlash and Flash remoting tend to change the way you program -- not 
always for the better

1) rather then populate the initial page with initial data as with 
CF/HTML it is cleaner to do the following with FR:
  --download the RIA client
  --the client, when loaded, makes the request for initial data.
2) from a programming standpoint it is easy to ignore the overhead of 
exchanging large XML packets between host and client
3) if you give a lot of capability to the client (updating records on 
the client with out contacting the host) you can add orders of 
magnitude of complexity to the host (lockouts, deadlocks, 
synchronization) and to the RIA client -- what happens if the browser 
crashes after you've made 20 minutes of updates?
4) Multiple browser windows with a Flash RIA clients, each consume 
client resources even when inactive. They compete with each other and 
other desktop apps.

So, everything you've learned with CF still applies -- Flash can 
improve the UI, and the UE (User Experience)  --

but, better to be a little skeptical

HTH

Dick

On Apr 13, 2004, at 12:06 PM, Chris Alvarado wrote:)
> Hello all,
>
>  I am starting a new project that will require some fairly heavy Flash

> /
>  CF integration including but not limited to: visual display of data
>  stored in a database, insertion of data into a database supplied in
>  Flash forms, a complete security model that requires not only
> 

Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Dave Francis
But by the time the code gets to the browser, #linkStyle#  will have been replaced by exactly what you show us here
    menu item one: ...>
    menu item two: ...>
    menu item two: ...>

"view source" from your browser might help clear things up for you.

Or like Dick, I don't understand :(

 
  - Original Message - 
  From: Joy Holman 
  To: CF-Talk 
  Sent: Tuesday, April 13, 2004 4:12 PM
  Subject: Re: passing multiple CF vaules to a _javascript_ variable

  Would this information help explain what I need?

  Here's where the styles comes in:
  I have a CSS stylesheet with these values:
  #FellSvc{display:none;}
  #MinorRts{display:none;}
  #AmnInf{display:none;}
  #AnteSter{display:none;}

  In the db table, I have a column for the same styles from the stylesheet. Let's say the column name is "linkStyle" (like Dick's example). Another column in the db table has the text for the menu link that displays on the page.

  When a user clicks on a menu link (generated by the CF code prior to the user interaction), an assoicated DIV with an ID equal to the stylename displays its content because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block".

  Using Dick's example, just change the end to something like this:
  >Now, iterating over the query:
  >
  >
  >
  >

  Now, that doesn't work because #linkStyle# is CF and onClick needs js.
  I don't know how to loop through this onClick variable to get the range of values to be produced - one for each iteration of the results, like:
  menu item one: ...>
  menu item two: ...>
  menu item two: ...>
  etc.

  Does that help?

  I need to be gone for a few hours, but I'll check back.
  Thank you and Dick so much for sticking with me on this!!!

  > It sounds like you need to combine the results from the 2 queries into 
  > a single query objectOR write a more complex query to join all the 
  > tables involved to produce a single recordset.
  > 
  > 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 11:55 AM
    
  > Subject: Re: passing multiple CF vaules to a _javascript_ variable
  > 
  > 
    
  > The rendered output is a menu of links. One query column 
    
  > returns the text for a link, another query column returns the target 
  > for the link. The style name column is used in an onClick event to set 
  > a CSS style to display content when clicked.
  > 
    
  > The style name doesn't display on screen. 
  > 
    
  > I'm able to generate all the values I need except for all the
    
  > stylename values. If I only had one result from the query, it would 
  > work fine. But I can't get the style name value to change as 
  > additional menu items are generated from the query results. Maybe what 
  > I need is help with _javascript_.
  > 
    
  > I don't know how to explain it any better. I guess that's a drawback 
  > of not being able to talk in real time. Thanks for your efforts. I'll 
  > keep at it. 
  > 
    
  > event.
  > 
    
  > From the query results, I create the js: target() which returns 
  > 
    
  > the value of the stylename field. How do I loop over the 
  > 
    
  > stylename values so that I get one value per onClick event which 
  > 
    
  > is generates multiple times based on the number of records in 
  > 
    
  > the query?
  > 
    
  > >I am sorry...
    
  > >
    
  > >I can't understand what you are trying to do.
    
  > >
    
  > >It is a simple matter to include the value of a column from the query 
  > 
    
  > >in a line of text generated within the output tags...
    
  > >
    
  > >But you are already doing that...
    
  > >
    
  > >
    
  > >Maybe this would help me to help you:
    
  > >
    
  > >1) show me a few lines of the rendered output that you desire--- no 
  > CF 
    
  > >tags, just the rendered output.
    
  > >
    
  > >2) put an asterisk or something in front of each value in the 
  > rendered 
    
  > >output that you want to dynamically create with your CF code,
    
  > >
    
  > >3) Run your query and display the output of enough rows showing the 
    
  > >columns & their values that contain the dynamic data
    
  > >
    
  > >
    
  > >HTH
    
  > >
    
  > >Dick
    
  > >
    
  > >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote:
    
  > >
    
  > >>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




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

2004-04-13 Thread Dave Watts
> > Sounds like you should be doing some stored procedures.
> 
> I assume that you both mean that the CF template would call 
> one stored procedure that on the database (Oracle) we could 
> have break out the queries in subsets that would run in 
> concurrent processes? 

To the best of my knowledge, stored procedures by themselves will not allow
you to perform asynchronous queries. That's why Jochem suggested a
multithreaded custom tag.

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:
> I said:
>> 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.
>
> Jochem said:
>> 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.
>
> Point taken. It was one of our database people who asked if CF would
> allow us to run queries concurrently, so I hope he would have your
> concerns in mind.

Sounds like they are really looking for something outside the database
as they have exhausted the possibilities inside it. That would leave
you with a Java/C custom tag.

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




RE: Put a link in a textarea

2004-04-13 Thread Rollo, Jeff
I liked the ActivateURL (certainly saves some work) so I guess I will
display the text in an iframe or div.  Thanks for all your help.

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 4:25 PM
To: CF-Talk
Subject: Re: Put a link in a textarea

Ooopsmy badyes that UDF is only intended for outside of form tags.

Now that said it seems a bit odd to be displaying a record in a form??  If
it's in a form then it's meant to be edited not "used" (i.e. user following
links etc.)but then again...what do I know about your application ;-)

I'm not 100% surebut about 99.9% sure that you can't do what you're
after (and obviously I think you shouldn't do it anyway...hehe).

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: Rollo, Jeff 
  To: CF-Talk 
  Sent: Tuesday, April 13, 2004 1:06 PM
  Subject: RE: Put a link in a textarea

  At first glance, it looks like it puts an 
  But if this is displayed in a textarea, it would just display the text
with
  a 
  link.  Or am I wrong here.

  -Original Message-
  From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, April 13, 2004 3:51 PM
  To: CF-Talk
  Subject: Re: Put a link in a textarea

  Yep...go to www.cflib.org and grab the UDF named ActivateURL.works
like
  a charm ;-)

  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: [EMAIL PROTECTED] [EMAIL PROTECTED] 
    To: CF-Talk 
    Sent: Tuesday, April 13, 2004 12:50 PM
    Subject: Put a link in a textarea

    Is there a way that a user can enter a URL in a textarea and have the
link
  actually display and work as a hyperlink?  For example:

    
  class="noborder"> blah blah blah http://www.houseoffusion.com/ blah blah
  blah 
    _ 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX6.1 updater

2004-04-13 Thread Jochem van Dieten
AIT said:
> Hey does anyone have any idea when an updater for CFMX6.1 might be
> out?

I seem to recall somebody commenting that an updater was 'under
consideration'. Probably your best bet is
http://www.macromedia.com/go/wish/

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




Re: Put a link in a textarea

2004-04-13 Thread Bryan Stevenson
Ooopsmy badyes that UDF is only intended for outside of form tags.

Now that said it seems a bit odd to be displaying a record in a form??  If it's in a form then it's meant to be edited not "used" (i.e. user following links etc.)but then again...what do I know about your application ;-)

I'm not 100% surebut about 99.9% sure that you can't do what you're after (and obviously I think you shouldn't do it anyway...hehe).

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: Rollo, Jeff 
  To: CF-Talk 
  Sent: Tuesday, April 13, 2004 1:06 PM
  Subject: RE: Put a link in a textarea

  At first glance, it looks like it puts an 
  But if this is displayed in a textarea, it would just display the text with
  a 
  link.  Or am I wrong here.

  -Original Message-
  From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, April 13, 2004 3:51 PM
  To: CF-Talk
  Subject: Re: Put a link in a textarea

  Yep...go to www.cflib.org and grab the UDF named ActivateURL.works like
  a charm ;-)

  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: [EMAIL PROTECTED] [EMAIL PROTECTED] 
    To: CF-Talk 
    Sent: Tuesday, April 13, 2004 12:50 PM
    Subject: Put a link in a textarea

    Is there a way that a user can enter a URL in a textarea and have the link
  actually display and work as a hyperlink?  For example:

    
  class="noborder"> blah blah blah http://www.houseoffusion.com/ blah blah
  blah 
    _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Put a link in a textarea

2004-04-13 Thread Burns, John D
You cannot display anything in the actual  except for text.
You can use an IFRAME if you want to display the HTML equivalent. The
ActivateURL takes text that someone types in and turns the links into
active links by surrounding the text with  .

John Burns 

-Original Message-
From: Rollo, Jeff [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 4:06 PM
To: CF-Talk
Subject: RE: Put a link in a textarea

    At first glance, it looks like it puts an 
link.
But if this is displayed in a textarea, it would just display the text
with a 
hyper link.  Or am I wrong here.

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 3:51 PM
To: CF-Talk
Subject: Re: Put a link in a textarea

Yep...go to www.cflib.org and grab the UDF named ActivateURL.works
like a charm ;-)

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: [EMAIL PROTECTED] [EMAIL PROTECTED]
  To: CF-Talk
  Sent: Tuesday, April 13, 2004 12:50 PM
  Subject: Put a link in a textarea

  Is there a way that a user can enter a URL in a textarea and have the
link actually display and work as a hyperlink?  For example:

  
class="noborder"> blah blah blah http://www.houseoffusion.com/ blah blah
blah
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
Would this information help explain what I need?

Here's where the styles comes in:
I have a CSS stylesheet with these values:
#FellSvc{display:none;}
#MinorRts{display:none;}
#AmnInf{display:none;}
#AnteSter{display:none;}

In the db table, I have a column for the same styles from the stylesheet. Let's say the column name is "linkStyle" (like Dick's example). Another column in the db table has the text for the menu link that displays on the page.

When a user clicks on a menu link (generated by the CF code prior to the user interaction), an assoicated DIV with an ID equal to the stylename displays its content because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block".

Using Dick's example, just change the end to something like this:
>Now, iterating over the query:
>
>
>
>

Now, that doesn't work because #linkStyle# is CF and onClick needs js.
I don't know how to loop through this onClick variable to get the range of values to be produced - one for each iteration of the results, like:
menu item one: ...>
menu item two: ...>
menu item two: ...>
etc.

Does that help?

I need to be gone for a few hours, but I'll check back.
Thank you and Dick so much for sticking with me on this!!!

> It sounds like you need to combine the results from the 2 queries into 
> a single query objectOR write a more complex query to join all the 
> tables involved to produce a single recordset.
> 
> 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 11:55 AM
  
> Subject: Re: passing multiple CF vaules to a _javascript_ variable
> 
> 
  
> The rendered output is a menu of links. One query column 
  
> returns the text for a link, another query column returns the target 
> for the link. The style name column is used in an onClick event to set 
> a CSS style to display content when clicked.
> 
  
> The style name doesn't display on screen. 
> 
  
> I'm able to generate all the values I need except for all the
  
> stylename values. If I only had one result from the query, it would 
> work fine. But I can't get the style name value to change as 
> additional menu items are generated from the query results. Maybe what 
> I need is help with _javascript_.
> 
  
> I don't know how to explain it any better. I guess that's a drawback 
> of not being able to talk in real time. Thanks for your efforts. I'll 
> keep at it. 
> 
  
> event.
> 
  
> From the query results, I create the js: target() which returns 
> 
  
> the value of the stylename field. How do I loop over the 
> 
  
> stylename values so that I get one value per onClick event which 
> 
  
> is generates multiple times based on the number of records in 
> 
  
> the query?
> 
  
> >I am sorry...
  
> >
  
> >I can't understand what you are trying to do.
  
> >
  
> >It is a simple matter to include the value of a column from the query 
> 
  
> >in a line of text generated within the output tags...
  
> >
  
> >But you are already doing that...
  
> >
  
> >
  
> >Maybe this would help me to help you:
  
> >
  
> >1) show me a few lines of the rendered output that you desire--- no 
> CF 
  
> >tags, just the rendered output.
  
> >
  
> >2) put an asterisk or something in front of each value in the 
> rendered 
  
> >output that you want to dynamically create with your CF code,
  
> >
  
> >3) Run your query and display the output of enough rows showing the 
  
> >columns & their values that contain the dynamic data
  
> >
  
> >
  
> >HTH
  
> >
  
> >Dick
  
> >
  
> >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote:
  
> >
  
> >>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
Here's where the styles comes in:
I have a CSS stylesheet with these values:
#FellSvc{display:none;}
#MinorRts{display:none;}
#AmnInf{display:none;}
#AnteSter{display:none;}

In the db table, I have a column for the same styles from the stylesheet. Let's say the column name is "linkStyle" (like your example). Another column in the db table has the text for the menu link that displays on the page.

When a user clicks on a menu link (generated by the CF code prior to the user interaction), an assoicated DIV with an ID equal to the stylename displays its content because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block".

Using your example, just change the end to something like this:
>Now, iterating over the query:
>
>
>
>

Now, that doesn't work because #linkStyle# is CF and onClick needs js.
I don't know how to loop through this onClick variable to get the range of values to be produced - one for each iteration of the results, like:
menu item one: ...>
menu item two: ...>
menu item two: ...>
etc.

Does that help?

>I realize that you are trying to create a list of links -- what I can't 
>understand is where the dynamic data is supposed to come from
>
>I would write something like:
>
>
>   SELECT  linkName, linkURL, linkStyle FROM linkTable
>
>
>yields a query containing:
>
>linkName    linkURL linkStyle
>--  --  --
>Apple   www.apple.com   colorful
>Macromedia  www.macromedia.com  flashy
>Microsoft   www.microsoft.com   opportunistic
>
>Now, iterating over the query:
>
>
> #linkName# 
>
>
>
>yields:
>
> Apple 
> Macromedia 
> Microsoft 
>
>I know this is not exactly what you want, but using the same technique, 
>can you show me what you want?
>
>Dick
>
>
>On Apr 13, 2004, at 11:55 AM, Joy Holman wrote:
>
>>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Put a link in a textarea

2004-04-13 Thread Rollo, Jeff
At first glance, it looks like it puts an 
But if this is displayed in a textarea, it would just display the text with
a 
link.  Or am I wrong here.

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 3:51 PM
To: CF-Talk
Subject: Re: Put a link in a textarea

Yep...go to www.cflib.org and grab the UDF named ActivateURL.works like
a charm ;-)

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: [EMAIL PROTECTED] [EMAIL PROTECTED] 
  To: CF-Talk 
  Sent: Tuesday, April 13, 2004 12:50 PM
  Subject: Put a link in a textarea

  Is there a way that a user can enter a URL in a textarea and have the link
actually display and work as a hyperlink?  For example:

  
class="noborder"> blah blah blah http://www.houseoffusion.com/ blah blah
blah 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Import a Text file to MYSQL

2004-04-13 Thread Barney Boisvert
Using CF to convert the file into an INSERT statement would be quite slow,
I'd imagine, though you could probably restore some of the performance by
buffering (using a StringBuffer, for example).

LOAD DATA INFILE is going to be as fast as you can do it.  I've never used
it for more than a few thousand records, but it was blazing fast, and all
the load is on the DB (not CF), which is very nice.  I'm not going to say
that it won't be a burden on the server, but it'll be relatively small for
that many records.

And if you're replacing the all the data (as opposed to adding new data),
make sure you use TRUNCATE TABLE rather than DELETE.  It drops and recreates
the table, rather than deleting each row, so it's enormously faster when
you've got a big table and you need to delete all the rows.

Cheers,
barneyb

> -Original Message-
> From: Mickael [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, April 13, 2004 12:32 PM
> To: CF-Talk
> Subject: Re: Import a Text file to MYSQL
> 
> Hi Barney,
> 
> I have over 1 million records to import daily would that not 
> be very taxing on the server?
>   - Original Message - 
>   From: Barney Boisvert 
>   To: CF-Talk 
>   Sent: Tuesday, April 13, 2004 3:16 PM
>   Subject: RE: Import a Text file to MYSQL
> 
> 
>   You can use LOAD DATA INFILE if you have sufficient 
> privileges on the server
>   and the file format is acceptable.  If not, it's pretty 
> simple to do some
>   text manipulation and convert text into a multi-line INSERT 
> statement:
> 
>   INSERT INTO tabl
>   (col1, col2, col3)
>   VALUES
>   ('11', '12', '13'),
>   ('21', '22', '23'),
>   ('31', '32', '33'),
>   .
>   ('n1', 'n2', 'n3)
> 
>   Basically, it goes like this: replace all "'" with "\'", 
> add "('" to the
>   start of every line, add "')" to the end, replace "," with 
> "','", prepend
>   the INSERT  VALUES stuff, and then remove the trailing comma.
> 
>   Cheers,
>   barneyb
> 
>   > -Original Message-
>   > From: Mickael [mailto:[EMAIL PROTECTED] 
>   > Sent: Tuesday, April 13, 2004 12:06 PM
>   > To: CF-Talk
>   > Subject: Import a Text file to MYSQL
>   > 
>   > Hello All,
>   > 
>   > Can you import a text file to MYSQL with CF.  I would like to 
>   > take a text file that is exported to Access then Drop/Create 
>   > the table with CF in MYSQL then import the file in its 
>   > entirety to create the table. 
>   > 
>   > This sounds simple enough in theory, how can this be done in 
>   > CF and MYSQL I don't really have any experience with MYSQL
>   > 
>   > Thanks in advance
>   > 
>   > Mike
>   > 
>   > 
>   >
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: SOT: Flash Remoting vs Web Services vs XML

2004-04-13 Thread Dick Applebaum
Have you considered Flex (or as I like to call it FlexFlash)

In my very limited experience Flex programming of RIAs is much easier 
than Flash programming unless you are into heavy animation, visual 
effects, etc.

You can get all you need for development with the Flex evaluation CD.

Then you can install flex to run in conjunction with CFMX -- which is 
the best of both worlds (server-side power and client-side RIA)

The big barrier may be the price of Flex but I understand that this 
may be negotiable.

Your timeframe may also be a consideration -- there have been hints 
that the next release of CFMX (BlackGuard, BlackHart, BlackMagic, 
BlackBeauty, BlackStone, whatever) will include Flex capabilities.

The way it  (current CFMX Flex) appears to work is this:

1) You create CF templates with imbedded (or included) Flex source 
containing special XML (MXXML) and ActionScript (similar to 
_javascript_).

The CF template gets compiled to Java Byte code

The Flash portion of the template gets compiled to a SWF

Both are served to the requestor;

Here are the headers for a very simple CFMX Flex program (a Menu Tree)

"GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753
"GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753
"GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244
"GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244
"GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257
"GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257
"GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528
"GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528
"GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656
"GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656

It appears as if there are separate requests generated for:

1) the cf template
2) flex js
3) flex history
4) a swf containing the Flex portion of the CF template (mxml.swf)
5) a generic swf

This is quite a fewf connections for a simple program, but I am told 
that as complexity increases, there should be fewer connections than 
with a typical html page.

FlexFlash and Flash remoting tend to change the way you program -- not 
always for the better

1) rather then populate the initial page with initial data as with 
CF/HTML it is cleaner to do the following with FR:
  --download the RIA client
  --the client, when loaded, makes the request for initial data.
2) from a programming standpoint it is easy to ignore the overhead of 
exchanging large XML packets between host and client
3) if you give a lot of capability to the client (updating records on 
the client with out contacting the host) you can add orders of 
magnitude of complexity to the host (lockouts, deadlocks, 
synchronization) and to the RIA client -- what happens if the browser 
crashes after you've made 20 minutes of updates?
4) Multiple browser windows with a Flash RIA clients, each consume 
client resources even when inactive. They compete with each other and 
other desktop apps.

So, everything you've learned with CF still applies -- Flash can 
improve the UI, and the UE (User Experience)  --

but, better to be a little skeptical

HTH

Dick

On Apr 13, 2004, at 12:06 PM, Chris Alvarado wrote:)
> Hello all,
>
>  I am starting a new project that will require some fairly heavy Flash 
> /
>  CF integration including but not limited to: visual display of data
>  stored in a database, insertion of data into a database supplied in
>  Flash forms, a complete security model that requires not only
>  authentication but user level access restrictions (role based model). 
> I
>  just ready the article on Macromedia DevNet about the various options
>  for developing RIAs (Remoting, Web Services, XML) and am having a bit 
> of
>  a hard time deciding which route to pursue. Are there any RIA specific
>  mailing lists etc that anyone can recommend. Additionally can anyone
>  here point me in the right direction? I am a complete rookie when it
>  comes to Flash but have nearly 7years of CF experience so the CF
>  concepts are easy to grasp for me, im just sort of a bit inundated 
> with
>  the Flash portion. If anyone has any suggestions on where to get 
> started
>  they would be greatly appreciated. I picked up "Macromedia Flash MX
>  Profession 2004 for Server Geeks" and it seems like an excellent book,
>  but if anyone has any other suggestions that would fit well within the
>  project described above I would really appreciate it.
>
>  Thanks everyone,
>
>  Looking forward to seeing any feedback.
>
>  -chris.alvarado
>
>  [ application developer ]
>
>  4 Guys Interactive, Inc.
>
>  281.807.4344 x1716
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Put a link in a textarea

2004-04-13 Thread Bryan Stevenson
Yep...go to www.cflib.org and grab the UDF named ActivateURL.works like a charm ;-)

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: [EMAIL PROTECTED] [EMAIL PROTECTED] 
  To: CF-Talk 
  Sent: Tuesday, April 13, 2004 12:50 PM
  Subject: Put a link in a textarea

  Is there a way that a user can enter a URL in a textarea and have the link actually display and work as a hyperlink?  For example:

   blah blah blah http://www.houseoffusion.com/ blah blah blah
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Put a link in a textarea

2004-04-13 Thread rolloj
Is there a way that a user can enter a URL in a textarea and have the link actually display and work as a hyperlink?  For example:

 blah blah blah http://www.houseoffusion.com/ blah blah blah
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX6.1 updater

2004-04-13 Thread DURETTE, STEVEN J (AIT)
Hey does anyone have any idea when an updater for CFMX6.1 might be out?

I just had to re-image my web server and re-install.  Now most of my time is
being spent dling and installing HotFixes and Security updates for
ColdFusion.

An updater would be really helpful about now as I am up to 14
hotfix/security updates with more to go.

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




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
Could you give me some pseudo code to work with? I guess this is exactly where I'm stuck. I've only got the one table and one query. Everything I need is in there. I just can't figure out how to make the value needed on the onClick event be unique for each event generated by the outputting of the query results. I don't know how to loop through the that variable's values correctly.

I appreciate your help.

Joy Holman

> It sounds like you need to combine the results from the 2 queries into 
> a single query objectOR write a more complex query to join all the 
> tables involved to produce a single recordset.
> 
> 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 11:55 AM
  
> Subject: Re: passing multiple CF vaules to a _javascript_ variable
> 
> 
  
> The rendered output is a menu of links. One query column 
  
> returns the text for a link, another query column returns the target 
> for the link. The style name column is used in an onClick event to set 
> a CSS style to display content when clicked.
> 
  
> The style name doesn't display on screen. 
> 
  
> I'm able to generate all the values I need except for all the
  
> stylename values. If I only had one result from the query, it would 
> work fine. But I can't get the style name value to change as 
> additional menu items are generated from the query results. Maybe what 
> I need is help with _javascript_.
> 
  
> I don't know how to explain it any better. I guess that's a drawback 
> of not being able to talk in real time. Thanks for your efforts. I'll 
> keep at it. 
> 
  
> event.
> 
  
> From the query results, I create the js: target() which returns 
> 
  
> the value of the stylename field. How do I loop over the 
> 
  
> stylename values so that I get one value per onClick event which 
> 
  
> is generates multiple times based on the number of records in 
> 
  
> the query?
> 
  
> >I am sorry...
  
> >
  
> >I can't understand what you are trying to do.
  
> >
  
> >It is a simple matter to include the value of a column from the query 
> 
  
> >in a line of text generated within the output tags...
  
> >
  
> >But you are already doing that...
  
> >
  
> >
  
> >Maybe this would help me to help you:
  
> >
  
> >1) show me a few lines of the rendered output that you desire--- no 
> CF 
  
> >tags, just the rendered output.
  
> >
  
> >2) put an asterisk or something in front of each value in the 
> rendered 
  
> >output that you want to dynamically create with your CF code,
  
> >
  
> >3) Run your query and display the output of enough rows showing the 
  
> >columns & their values that contain the dynamic data
  
> >
  
> >
  
> >HTH
  
> >
  
> >Dick
  
> >
  
> >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote:
  
> >
  
> >>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT ? Emulation

2004-04-13 Thread Nick Baker
Well maybe heresy, instead of OT ;-)

Does anyone know of good non-CF scripts, Perl, CGI, etc. that perform the 
same function as ?

Thanks,

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




Re: Import a Text file to MYSQL

2004-04-13 Thread Mickael
Hi Barney,

I have over 1 million records to import daily would that not be very taxing on the server?
  - Original Message - 
  From: Barney Boisvert 
  To: CF-Talk 
  Sent: Tuesday, April 13, 2004 3:16 PM
  Subject: RE: Import a Text file to MYSQL

  You can use LOAD DATA INFILE if you have sufficient privileges on the server
  and the file format is acceptable.  If not, it's pretty simple to do some
  text manipulation and convert text into a multi-line INSERT statement:

  INSERT INTO tabl
  (col1, col2, col3)
  VALUES
  ('11', '12', '13'),
  ('21', '22', '23'),
  ('31', '32', '33'),
  .
  ('n1', 'n2', 'n3)

  Basically, it goes like this: replace all "'" with "\'", add "('" to the
  start of every line, add "')" to the end, replace "," with "','", prepend
  the INSERT  VALUES stuff, and then remove the trailing comma.

  Cheers,
  barneyb

  > -Original Message-
  > From: Mickael [mailto:[EMAIL PROTECTED] 
  > Sent: Tuesday, April 13, 2004 12:06 PM
  > To: CF-Talk
  > Subject: Import a Text file to MYSQL
  > 
  > Hello All,
  > 
  > Can you import a text file to MYSQL with CF.  I would like to 
  > take a text file that is exported to Access then Drop/Create 
  > the table with CF in MYSQL then import the file in its 
  > entirety to create the table. 
  > 
  > This sounds simple enough in theory, how can this be done in 
  > CF and MYSQL I don't really have any experience with MYSQL
  > 
  > Thanks in advance
  > 
  > Mike
  > 
  > 
  >
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOT: Spammed from post to cf-talk

2004-04-13 Thread Dick Applebaum
I just got spammed with the subject line of a post I made to cf-talk.

Where should I forward the spam msg to add the abuser to the filter?

TIA

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




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

2004-04-13 Thread Earl, George
I asked:
> Is there a way to have multiple queries running from the same 
> cf template at the same time? 

Pascal said:
> Stored Procedures? 

Deanna said:
> Sounds like you should be doing some stored procedures.

I assume that you both mean that the CF template would call one stored
procedure that on the database (Oracle) we could have break out the queries
in subsets that would run in concurrent processes? 

Jochem said:
> Write a multi-threaded Java/C customtag.

Whoo-boy, that would be fun - we are just starting to wrap our heads around
the migration from CF 5 to CFMX . . .

I said:
> 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.

Jochem said:
> 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.

Point taken. It was one of our database people who asked if CF would allow
us to run queries concurrently, so I hope he would have your concerns in
mind.

Thanks all!

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




Re: Recipe Application

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

Hmm... I can't resist.

No requirements? That sounds like a recipe for disaster.

:D

sorry, that was terrible.

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




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Dick Applebaum
I realize that you are trying to create a list of links -- what I can't 
understand is where the dynamic data is supposed to come from

I would write something like:


   SELECT  linkName, linkURL, linkStyle FROM linkTable


yields a query containing:

linkName    linkURL linkStyle
--  --  --
Apple   www.apple.com   colorful
Macromedia  www.macromedia.com  flashy
Microsoft   www.microsoft.com   opportunistic

Now, iterating over the query:


 #linkName# 


yields:

 Apple 
 Macromedia 
 Microsoft 

I know this is not exactly what you want, but using the same technique, 
can you show me what you want?

Dick

On Apr 13, 2004, at 11:55 AM, Joy Holman wrote:

> The rendered output is a menu of links. One query column
>  returns the text for a link, another query column returns the target 
> for the link. The style name column is used in an onClick event to set 
> a CSS style to display content when clicked.
>
>  The style name doesn't display on screen.
>
>  I'm able to generate all the values I need except for all the
>  stylename values. If I only had one result from the query, it would 
> work fine. But I can't get the style name value to change as 
> additional menu items are generated from the query results. Maybe what 
> I need is help with _javascript_.
>
>  I don't know how to explain it any better. I guess that's a drawback 
> of not being able to talk in real time. Thanks for your efforts. I'll 
> keep at it.
>
>  event.
>
>  From the query results, I create the js: target() which returns
>
>  the value of the stylename field. How do I loop over the
>
>  stylename values so that I get one value per onClick event which
>
>  is generates multiple times based on the number of records in
>
>  the query?
>
>  >I am sorry...
>  >
>  >I can't understand what you are trying to do.
>  >
>  >It is a simple matter to include the value of a column from the query
>  >in a line of text generated within the output tags...
>  >
>  >But you are already doing that...
>  >
>  >
>  >Maybe this would help me to help you:
>  >
>  >1) show me a few lines of the rendered output that you desire--- no 
> CF
>  >tags, just the rendered output.
>  >
>  >2) put an asterisk or something in front of each value in the 
> rendered
>  >output that you want to dynamically create with your CF code,
>  >
>  >3) Run your query and display the output of enough rows showing the
>  >columns & their values that contain the dynamic data
>  >
>  >
>  >HTH
>  >
>  >Dick
>  >
>  >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote:
>  >
>  >>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Import a Text file to MYSQL

2004-04-13 Thread Barney Boisvert
You can use LOAD DATA INFILE if you have sufficient privileges on the server
and the file format is acceptable.  If not, it's pretty simple to do some
text manipulation and convert text into a multi-line INSERT statement:

INSERT INTO tabl
	(col1, col2, col3)
VALUES
	('11', '12', '13'),
	('21', '22', '23'),
	('31', '32', '33'),
	.
	('n1', 'n2', 'n3)

Basically, it goes like this: replace all "'" with "\'", add "('" to the
start of every line, add "')" to the end, replace "," with "','", prepend
the INSERT  VALUES stuff, and then remove the trailing comma.

Cheers,
barneyb

> -Original Message-
> From: Mickael [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, April 13, 2004 12:06 PM
> To: CF-Talk
> Subject: Import a Text file to MYSQL
> 
> Hello All,
> 
> Can you import a text file to MYSQL with CF.  I would like to 
> take a text file that is exported to Access then Drop/Create 
> the table with CF in MYSQL then import the file in its 
> entirety to create the table. 
> 
> This sounds simple enough in theory, how can this be done in 
> CF and MYSQL I don't really have any experience with MYSQL
> 
> Thanks in advance
> 
> Mike
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Import a Text file to MYSQL

2004-04-13 Thread Mickael
Hello All,

Can you import a text file to MYSQL with CF.  I would like to take a text file that is exported to Access then Drop/Create the table with CF in MYSQL then import the file in its entirety to create the table. 

This sounds simple enough in theory, how can this be done in CF and MYSQL I don't really have any experience with MYSQL

Thanks in advance

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




SOT: Flash Remoting vs Web Services vs XML

2004-04-13 Thread Chris Alvarado
Hello all,

I am starting a new project that will require some fairly heavy Flash /
CF integration including but not limited to: visual display of data
stored in a database, insertion of data into a database supplied in
Flash forms, a complete security model that requires not only
authentication but user level access restrictions (role based model). I
just ready the article on Macromedia DevNet about the various options
for developing RIAs (Remoting, Web Services, XML) and am having a bit of
a hard time deciding which route to pursue. Are there any RIA specific
mailing lists etc that anyone can recommend. Additionally can anyone
here point me in the right direction? I am a complete rookie when it
comes to Flash but have nearly 7years of CF experience so the CF
concepts are easy to grasp for me, im just sort of a bit inundated with
the Flash portion. If anyone has any suggestions on where to get started
they would be greatly appreciated. I picked up "Macromedia Flash MX
Profession 2004 for Server Geeks" and it seems like an excellent book,
but if anyone has any other suggestions that would fit well within the
project described above I would really appreciate it.

Thanks everyone,

Looking forward to seeing any feedback.

-chris.alvarado

[ application developer ]

4 Guys Interactive, Inc.

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




RE: email folder

2004-04-13 Thread Kurt Knazek
C:\CFusionMX\Mail

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 2:54 PM
To: CF-Talk
Subject: email folder

hey

where is the email folder for cfmx?

the one where spooled messages go before sending.

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

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




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Bryan Stevenson
It sounds like you need to combine the results from the 2 queries into a single query objectOR write a more complex query to join all the tables involved to produce a single recordset.

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 11:55 AM
  Subject: Re: passing multiple CF vaules to a _javascript_ variable

  The rendered output is a menu of links. One query column 
  returns the text for a link, another query column returns the target for the link. The style name column is used in an onClick event to set a CSS style to display content when clicked.

  The style name doesn't display on screen. 

  I'm able to generate all the values I need except for all the
  stylename values. If I only had one result from the query, it would work fine. But I can't get the style name value to change as additional menu items are generated from the query results. Maybe what I need is help with _javascript_.

  I don't know how to explain it any better. I guess that's a drawback of not being able to talk in real time. Thanks for your efforts. I'll keep at it. 

  event.

  From the query results, I create the js: target() which returns 

  the value of the stylename field. How do I loop over the 

  stylename values so that I get one value per onClick event which 

  is generates multiple times based on the number of records in 

  the query?

  >I am sorry...
  >
  >I can't understand what you are trying to do.
  >
  >It is a simple matter to include the value of a column from the query 
  >in a line of text generated within the output tags...
  >
  >But you are already doing that...
  >
  >
  >Maybe this would help me to help you:
  >
  >1) show me a few lines of the rendered output that you desire--- no CF 
  >tags, just the rendered output.
  >
  >2) put an asterisk or something in front of each value in the rendered 
  >output that you want to dynamically create with your CF code,
  >
  >3) Run your query and display the output of enough rows showing the 
  >columns & their values that contain the dynamic data
  >
  >
  >HTH
  >
  >Dick
  >
  >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote:
  >
  >>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Web + v5.0

2004-04-13 Thread Josh Remus
I'm in the same boat, I have no association with CFDJ.
  -Original Message-
  From: Burns, John D [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, April 13, 2004 1:36 PM
  To: CF-Talk
  Subject: RE: Web + v5.0

  I didn't receive the Web + thing, and I'm not subscribed to anything
  with my address except Macromedia.  So maybe your CFDJ theory is
  correct.

  John

  -Original Message-
  From: Scott Brady [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, April 13, 2004 1:12 PM
  To: CF-Talk
  Subject: Re: Web + v5.0

  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]




email folder

2004-04-13 Thread Tony Weeg
hey

where is the email folder for cfmx?

the one where spooled messages go before sending.

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Joy Holman
The rendered output is a menu of links. One query column 
returns the text for a link, another query column returns the target for the link. The style name column is used in an onClick event to set a CSS style to display content when clicked.

The style name doesn't display on screen. 

I'm able to generate all the values I need except for all the
stylename values. If I only had one result from the query, it would work fine. But I can't get the style name value to change as additional menu items are generated from the query results. Maybe what I need is help with _javascript_.

I don't know how to explain it any better. I guess that's a drawback of not being able to talk in real time. Thanks for your efforts. I'll keep at it. 

event.

>From the query results, I create the js: target() which returns 

the value of the stylename field. How do I loop over the 

stylename values so that I get one value per onClick event which 

is generates multiple times based on the number of records in 

the query?

>I am sorry...
>
>I can't understand what you are trying to do.
>
>It is a simple matter to include the value of a column from the query 
>in a line of text generated within the output tags...
>
>But you are already doing that...
>
>
>Maybe this would help me to help you:
>
>1) show me a few lines of the rendered output that you desire--- no CF 
>tags, just the rendered output.
>
>2) put an asterisk or something in front of each value in the rendered 
>output that you want to dynamically create with your CF code,
>
>3) Run your query and display the output of enough rows showing the 
>columns & their values that contain the dynamic data
>
>
>HTH
>
>Dick
>
>On Apr 13, 2004, at 10:16 AM, Joy Holman wrote:
>
>>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Access 2003 ODBC

2004-04-13 Thread Jim McAtee
- Original Message - 
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 13, 2004 10:29 AM
Subject: RE: Access 2003 ODBC

> 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

Just found that Access 2003 (and Access 2002? didn't know there was a
2002) by default use the same file format as Access 2000.

http://www.microsoft.com/office/access/prodinfo/overview.mspx
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Access 2003 ODBC

2004-04-13 Thread Jim McAtee
- Original Message - 
From: "Claude Schneegans" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 13, 2004 11:31 AM
Subject: Re: Access 2003 ODBC

> >>would probably find it more convenient to use Access 2003 on the 
> >>server.
> 
> As far as CF is concerned, there is NO Access on the server: only an
> Access file and an ODBC driver.

Yeah, we know that.  Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How many class files do YOU have?

2004-04-13 Thread Brook Davies
A 6.1 thing? What version are you running?

Brook

At 11:08 AM 4/13/2004, you wrote:

>Brook,
>
>
>We don't have the option of compiling them to memory as I think that is only
>a 6.1 thing.  Regarding the template cache size.  It is based on the number
>of files that you think will be in use at one time.  In our case not all
>24,000 cf files will be used all the time so we set it to some reasonable
>percentage of those files.  75 - 80%.  In your case you could probably do
>all of them with no ill effects.
>
>
>Mark
>
>-Original Message-
>From: Brook Davies [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, April 13, 2004 10:33 AM
>To: CF-Talk
>Subject: RE: How many class files do YOU have?
>
>I thought Brandon said that with that many class files you would be better
>off not storing the class files to the HD and compiling them to memory at
>run time instead? Also, is the template cache setting the number of cfm
>templates or expected resulting class files?
>
>Bradon also wrote:
>"I have some info on my blog http://bpurcell.org but to fix this bump up
>the -XX:MaxPermSize value in your jvm.config to 192 or 256 it should get
>rid of the problem."
>
>Can I bump it up to 512?
>
>Also, do these numbers look okay?
>
>Description: JAR Launcher
>Version: 4.00..63824
>Handle count: 721
>Threads: 50
>Page fault count: 405529
>Peak working set size: 1,118,192.00 KB
>Working set size: 1,113,800.00 KB
>Peak page file usage: 1,115,992.00 KB
>Page file usage: 1,110,392.00 KB
>Total memory usage: 2,224,192.00 KB
>Command line: C:\CFusionMX\runtime\bin\jrun.exe
>
>Brook
>
>At 09:55 AM 4/13/2004, you wrote:
>
> >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]
> >
> >--
> >
> >[]
> >
>   _
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[Fast 
>  Unsubscribe] [User Settings]
>
>--
>
>[]
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: passing multiple CF vaules to a javascript variable

2004-04-13 Thread Dick Applebaum
I am sorry...

I can't understand what you are trying to do.

It is a simple matter to include the value of a column from the query 
in a line of text generated within the output tags...

But you are already doing that...

Maybe this would help me to help you:

1) show me a few lines of the rendered output that you desire--- no CF 
tags, just the rendered output.

2) put an asterisk or something in front of each value in the rendered 
output that you want to dynamically create with your CF code,

3) Run your query and display the output of enough rows showing the 
columns & their values that contain the dynamic data

HTH

Dick

On Apr 13, 2004, at 10:16 AM, Joy Holman wrote:

> "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: MX: Scheduler firing off too often

2004-04-13 Thread Scott Weikert
MX 6.1 on a Linux box. See my initial post in this thread for more info.

At 11:55 AM 4/13/2004, you wrote:
>What version of CF u using? We had this happen with CF5 on
>Solaris...every once and a while it went nuts and ran items 5 times
>every few seconds!
>
>It's been months on 6.1 without incident though...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How many class files do YOU have?

2004-04-13 Thread Mark Johnson
Brook,

 
We don't have the option of compiling them to memory as I think that is only
a 6.1 thing.  Regarding the template cache size.  It is based on the number
of files that you think will be in use at one time.  In our case not all
24,000 cf files will be used all the time so we set it to some reasonable
percentage of those files.  75 - 80%.  In your case you could probably do
all of them with no ill effects.

 
Mark

-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 10:33 AM
To: CF-Talk
Subject: RE: How many class files do YOU have?

I thought Brandon said that with that many class files you would be better 
off not storing the class files to the HD and compiling them to memory at 
run time instead? Also, is the template cache setting the number of cfm 
templates or expected resulting class files?

Bradon also wrote:
"I have some info on my blog http://bpurcell.org but to fix this bump up 
the -XX:MaxPermSize value in your jvm.config to 192 or 256 it should get 
rid of the problem."

Can I bump it up to 512?

Also, do these numbers look okay?

Description: JAR Launcher
Version: 4.00..63824
Handle count: 721
Threads: 50
Page fault count: 405529
Peak working set size: 1,118,192.00 KB
Working set size: 1,113,800.00 KB
Peak page file usage: 1,115,992.00 KB
Page file usage: 1,110,392.00 KB
Total memory usage: 2,224,192.00 KB
Command line: C:\CFusionMX\runtime\bin\jrun.exe

Brook

At 09:55 AM 4/13/2004, you wrote:

>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]
>
>--
>
>[]
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MX: Scheduler firing off too often

2004-04-13 Thread Stacy Young
What version of CF u using? We had this happen with CF5 on
Solaris...every once and a while it went nuts and ran items 5 times
every few seconds!

It's been months on 6.1 without incident though...

Stace

  _  

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

At 11:46 AM 4/13/2004, you wrote:
>You can also turn on schedule task logging in the admin.

In the end, though, my problem still stands - what if the scheduler is 
firing off a task multiple times when it should only fire it off once,
at 
any given time? What should I look for/at as far as correcting this
behavior.

FYI the task in question has been firing off every three minutes, once,
for 
the past couple or three hours without issue, but I'm not going to count
on 
that behavior continuing.

--Scott

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




RE: MX: Scheduler firing off too often

2004-04-13 Thread Scott Weikert
At 11:46 AM 4/13/2004, you wrote:
>You can also turn on schedule task logging in the admin.

In the end, though, my problem still stands - what if the scheduler is 
firing off a task multiple times when it should only fire it off once, at 
any given time? What should I look for/at as far as correcting this behavior.

FYI the task in question has been firing off every three minutes, once, for 
the past couple or three hours without issue, but I'm not going to count on 
that behavior continuing.

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




RE: MX: Scheduler firing off too often

2004-04-13 Thread Stacy Young
You can also turn on schedule task logging in the admin.

Stace

  _  

From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 12:29 PM
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: Email Not Being Sent from Local Server (CF5)

2004-04-13 Thread Tom Jordahl
You will need to upgrade to ColdFusion MX 6.1, where SMTP authentication was
added as a feature.

You can't do it with CF 5.

--
Tom Jordahl
Macromedia Server Development

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 09, 2004 3:32 PM
To: CF-Talk
Subject: Re: Email Not Being Sent from Local Server (CF5)

Chris Montgomery wrote:
> Friday, April 9, 2004, 2:09:34 PM, Jochem van Dieten wrote:
>> 
>> mail.log
> 
> Ok, so this is saying that authentication is required. I didn't have
> this problem when I was running Win2k, but anywayif I check the
> box for " Verify Mail Server Connection" in CF Admin, I get the
> message "ColdFusion connected to your server. Verification completed
> without error." I don't understand what's happening.

Verification only does a HELO, it doesn't actually try to send a 
message.

> Also, how does
> one provide authentication data for the mail server...I am not seeing
> a way to enter that anywhere.

With the username and password attributes of cfmail.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
 - Loesje

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




RE: track cferrors

2004-04-13 Thread Burns, John D
You could create a small error-tracking system that stores the errors in
a database and then make a place where you can view them.  When an error
occurs, insert the error into the DB and redirect the user to an error
page with a message. (if that fits your application)  

John Burns 

-Original Message-
From: Robert Redpath [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 1:35 PM
To: CF-Talk
Subject: track cferrors

How do you guys track cferrors? 

I do not have access to the cf administrator so I use a form which
emails me the errors from the error template.  But I am looking for a
better way to view the errors since the solution I use requires the user
to back page 2x to get out of an error (I have a _javascript_ back button
that goes back to the original page but most users instinctively hit the
back button) and sometimes the errors don't get mailed with all the
error codes.

Here is what I use:
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Null Pointer from CFQUERY

2004-04-13 Thread Mark W. Breneman
Is it the double dots in etrade..Bank that is causing your problem? 

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

  _  

From: Alisa Thomson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 12:25 PM
To: CF-Talk
Subject: Null Pointer from CFQUERY

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:

  
 SELECT FirstNme
 FROM etrade..Bank
 WHERE BankId = 'WF'
  

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]




RE: Web + v5.0

2004-04-13 Thread Burns, John D
I didn't receive the Web + thing, and I'm not subscribed to anything
with my address except Macromedia.  So maybe your CFDJ theory is
correct.

John 

-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 1:12 PM
To: CF-Talk
Subject: Re: Web + v5.0

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]




track cferrors

2004-04-13 Thread Robert Redpath
How do you guys track cferrors? 

I do not have access to the cf administrator so I use a form which emails me
the errors from the error template.  But I am looking for a better way to
view the errors since the solution I use requires the user to back page 2x
to get out of an error (I have a _javascript_ back button that goes back to
the original page but most users instinctively hit the back button) and
sometimes the errors don't get mailed with all the error codes.

Here is what I use:
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Access 2003 ODBC

2004-04-13 Thread Claude Schneegans
>>would probably find it more convenient to use Access 2003 on the server.

As far as CF is concerned, there is NO Access on the server: only an Access file and an ODBC driver.
The Access application is not used.
The file can be Access 95, 97 2000 or 2003, it does not really make a big difference.

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How many class files do YOU have?

2004-04-13 Thread Brook Davies
I thought Brandon said that with that many class files you would be better 
off not storing the class files to the HD and compiling them to memory at 
run time instead? Also, is the template cache setting the number of cfm 
templates or expected resulting class files?

Bradon also wrote:
"I have some info on my blog http://bpurcell.org but to fix this bump up 
the -XX:MaxPermSize value in your jvm.config to 192 or 256 it should get 
rid of the problem."

Can I bump it up to 512?

Also, do these numbers look okay?

Description: JAR Launcher
Version: 4.00..63824
Handle count: 721
Threads: 50
Page fault count: 405529
Peak working set size: 1,118,192.00 KB
Working set size: 1,113,800.00 KB
Peak page file usage: 1,115,992.00 KB
Page file usage: 1,110,392.00 KB
Total memory usage: 2,224,192.00 KB
Command line: C:\CFusionMX\runtime\bin\jrun.exe

Brook

At 09:55 AM 4/13/2004, you wrote:

>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]
>
>--
>
>[]
>
 [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:

  
 SELECT FirstNme
 FROM etrade..Bank
 WHERE BankId = 'WF'
  

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]




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.


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





The above code opens the document in a new 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.


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





The above code loads the document in a browser.
 [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: 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: 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. 

 
SELECT * from qa_menu 
order by menu_sortText 
 
 
 

 

"#q_menu.menu_nonBmarkLink#">"##Ans" 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: "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans" 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: 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. 

 
SELECT * from qa_menu 
order by menu_sortText 
 
 
 

 

"#q_menu.menu_nonBmarkLink#">"##Ans" 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: "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans" 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 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 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.
>
>  
>  SELECT * from qa_menu
>  order by menu_sortText
>  
>  
>  
>
>  
>  
>   >   > >   >   >   > "">"#q_menu.menu_nonBmarkLink#">"##Ans" >   > >   >   > >  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: >   > "#q_menu.menu_nonBmarkLink#">"##Ans" >   > > >   > neq"">"#q_menu.menu_nonBmarkLink#">"##Ans" >   > > >   > neq"">"#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans" >   > > >  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: 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: 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





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


SELECT * from qa_menu
order by menu_sortText






"#q_menu.menu_nonBmarkLink#">"##Ans" 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: "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans" 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: 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: 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
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 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  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: 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: 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: 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  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 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: 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: 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. 


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


  >


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: 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: 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]




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


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 cf coder
I changed the code a select statement a bit. I appended 'dbo.' before the table name. 


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: 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: 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: 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: #CGI.HTTP_REFERER#

HTTP_USER_AGENT: #CGI.HTTP_USER_AGENT# 

REMOTE_ADDR: #CGI.REMOTE_ADDR#

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

  select * from
Attachment where id = '#url.id#'



 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 : 
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: 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
  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   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
 . 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:   [EMAIL PROTECTED]
 [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: 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]




  1   2   >