Re: better way to code?

2005-01-27 Thread Barney Boisvert
I'd say that any application that allows file paths to come from the
URL is wrong, no matter the code.  Second, any application that allows
mixed relative and absolute paths for the same file is asking for
trouble.  And third, make sure you check for a leading "/" as well, or
you code will puke on *nix.

Now as for the coding style, the former is definitely better, though
the whole block should be in a CFTRY..CFCATCH.  In the second example,
you need a CFTRY around the second CFFILE, and having multiple nested
CFTRY..CFCATCH blocks gets too nasty to quick.  Chances are good that
if that scenario arises, you'd be better off doing some abstraction
with either includes, UDFs, or a CFC.  But again, I think it's
unlikely you would ever be in this scenario with a well designed
application.

Also, don't use CONTAINS as your operator, use mid(url.dir, 2, 1) and
see if it's a colon.

cheers,
barneyb

On Thu, 27 Jan 2005 23:43:25 -0400, Johnny Le <[EMAIL PROTECTED]> wrote:
> Which method of programming do you consider is better?
> 
> This one:
> 
>
> 
>output="">
> 
> 
> or this one:
> 
> 
>
>
>   output="">
>
> 
> 
> I know that the first one is most people use, but the second one is more 
> interesting.  It seems to use the power of CF more. So let me know what you 
> think.
> 
> Johnny
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192061
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Blackstone and XHTML

2005-01-27 Thread Sean Corfield
On Fri, 28 Jan 2005 01:10:16 -0500, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> You might also have a look at the onTap framework -- which has much
> more robust, bulletproof and reuseable (but no more difficult to use)
> form validation features.

That is *way* more complex than the equivalent Blackstone form!

Blackstone's XML forms allow you to specify just the plain fields
without formatting and have an automatic XSL transformation applied to
create nicely lined up form fields and labels...

For example, the following simple form:










With no other code, this produces:

http://www.corfield.org/articles/stuff/ike.gif

(I didn't both mapping Ike's radio button stuff)

Form labels are automatic and aligned. Required fields are indicated
with a red *.
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 5 invites to give away!

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192060
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Frequent Server Restart

2005-01-27 Thread Barney Boisvert
First thing I'd do is find another host, and then let them worry about
their problem.  But I'm a heartless bastard when it comes to people
not doing their job, when it's the only thing they have to do.  If
they can't even get time synchronization right, it shouldn't be much
surprise that they can't keep CF running consistently.  Without having
access to the server to monitor other things (memory usage, CF/JRun
logs, web server logs, etc), it's hard to even guess what the issue
might be, though.

cheers,
barneyb

On Thu, 27 Jan 2005 23:45:16 -0400, Andrew Grosset <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I have a site (that is not yet public) which is on a shared server with a 
> major CF hosting company running MX 6.1 . In the last nine days the server 
> has been restarted nine times including twice today.
> 
> The server restarts are monitored by scheduling cfscheduler to call a 
> template once an hour that checks if a specific application variable is 
> defined, if it's not it emails me and resets the application variable.
> 
> They are also unable to synchronise the server time with nist.time.gov but 
> that is a separate issue.
> 
> Any suggestions as to what they (the hosting Co) and I can do?
> 
> Andrew.
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 7 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192059
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Barney Boisvert
You're not alone.  It's my editor of choice for simple stuff.  Very
easy to customize, and it's themes stuff makes it amazingly simple to
expose different capabilities to different users, or in different
editing situations.  Still use HTMLArea for heavy lifting (the plugin
architecture, while complex, is very helpful), but with the success
I've had with TinyMCE, that might change.

cheers,
barneyb

On Thu, 27 Jan 2005 20:09:18 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> Am I the only one retarded enough to use TinyMCE? Why do I like it so much? 
> Is something wrong with me?
> 
> Just wondering...
> 
> Will
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 7 invites.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192058
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Blackstone and XHTML

2005-01-27 Thread S . Isaac Dealey
> Is Blackstone going to take care of this non XHTML
> compliant code CF writes for cfform? Everything is
> uppercase.

> I'm trying to make all my stuff XHTML compliant, and I
> like using cfform/validation because I'm extremely lazy!

> Will

You might also have a look at the onTap framework -- which has much
more robust, bulletproof and reuseable (but no more difficult to use)
form validation features.

quick example:


  http://www.fusiontap.com"; tap:dbtable="product">


  
Product Name

  

  
  
Product Category

  


  

  
  
Status

  

  
  

  List Price
  

  


  Available Date
  

  

  

  


This form is actually a little more complicated than is entirely
necessary for the sake of demonstrating features. At the top you see
the attribute tap:dbtable="product" in the form tag which tells the
framework that the forms values being entered will ultimately reside
in this table and the framework uses the meta-data from that table in
your database to automate required, date and numeric field
information. The tap:dbtable attribute could be placed in any element
in your xhtml, not just the form and affects all child-elements.

Within the input elements, the tap:label attribute identifies the
label used in form validators (both server and client-side), so for
example when a user fails to provide a value for the productname
field/column (which will be required if the products.columnname column
in your database is not nullable), both client and server validation
will use the contents of the identified  element to display the
name of the input element to the user.

Assuming the listprice column is numeric and the availabledate column
is a date/timestamp column in your database, these columns will both
be automatically validated as numeric and date values respectively in
both client and server validation. The element  will make these values required if they aren't
already required due to matching columns in the product table being
not-nullable. The tap:validate="numeric" attribute in the listprice
field will ensure this value is numeric if it's not already numeric as
a result of database integration.

The tap:highlight tag at the top will cause elements which fail to
validate to be colored (default is yellow) to alert the user
immediately to what elements need to be corrected.

Both the category (select) and product status (radio buttons) fields
will have options automatically generated from the database if these
columns are foreign keys in the products table. The tap:dbfilter tag
will limit the list of options to those records in the theoretical
productcategory table where the "active" column has a value of 1.
Unlike cfselect the extra  tag in the select element will
appear at the top instead of the bottom of the select list.

You might also notice that none of the input elements in this form
contain any value attributes. By default the form is populated with
matching values in the attributes scope (a combination of form and url
variables). By filling the attributes scope with default values from a
database query it's easy to use the same form for both insert and
update tasks without any modification. (It's also just plain good
separation of presentation from model.) The framework also ensures
that all these values are properly formatted with htmleditformat()
before being displayed in the xhtml returned to the browser.

s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://macromedia.breezecentral.com/p49777853/
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192057
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


re: better way to code?

2005-01-27 Thread dave

wouldnt using cfcase & cfswitch be more "correct"?


From: Johnny Le <[EMAIL PROTECTED]>
Sent: Thursday, January 27, 2005 11:42 PM
To: CF-Talk 
Subject: better way to code? 

Which method of programming do you consider is better?

This one:

or this one:

I know that the first one is most people use, but the second one is more 
interesting. It seems to use the power of CF more. So let me know what you 
think.

Johnny



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192056
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: better way to code?

2005-01-27 Thread Taco Fleur
First one, second one should throw an error. 

And I would make it


 




 

But then again its pretty dangerous allowing the path to come from the url
if this website has public access.




-- 
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com


-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED] 
Sent: Friday, 28 January 2005 1:43 PM
To: CF-Talk
Subject: better way to code?

Which method of programming do you consider is better?

This one:

   

   

or this one:


   
   
 
   


I know that the first one is most people use, but the second one is more
interesting.  It seems to use the power of CF more. So let me know what you
think.

Johnny



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192055
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Frequent Server Restart

2005-01-27 Thread Andrew Grosset
Hi,

I have a site (that is not yet public) which is on a shared server with a major 
CF hosting company running MX 6.1 . In the last nine days the server has been 
restarted nine times including twice today.
   
The server restarts are monitored by scheduling cfscheduler to call a template 
once an hour that checks if a specific application variable is defined, if it's 
not it emails me and resets the application variable.

They are also unable to synchronise the server time with nist.time.gov but that 
is a separate issue.

Any suggestions as to what they (the hosting Co) and I can do?

Andrew.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192054
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


better way to code?

2005-01-27 Thread Johnny Le
Which method of programming do you consider is better?

This one:

   

  


or this one:


   
   
 
   


I know that the first one is most people use, but the second one is more 
interesting.  It seems to use the power of CF more. So let me know what you 
think.

Johnny

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192053
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF-Talk: CFID & CFTOKEN in URL (in CF5)

2005-01-27 Thread Paul Smith
My main objective is to set cookies that expire when the visitor closes 
their browser.

What do you suggest?  Please be specific.  I've been away from 
cfapplication a long time.

best,  paul

At 07:01 PM 1/27/2005, you wrote:
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192052
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Magictag

2005-01-27 Thread Howie Hamlin
Windows error 3 means that the path was not found.  Try wrapping the executable 
name with double quotes or try using the typical short name for program files 
(progra~1).  Also, make sure that the path is correct :)

HTH,

Howie

--- On Thursday, January 27, 2005 5:23 PM, Qasim Rasheed scribed: ---
>
> I am trying ti incorporate magictag by Algad for a client who is
> currently running CF5. However it is giving me the following error.
> Any help is greatly appreciated.
> 
> Error Diagnostic Information
> ImageMagick execution produced an error.
> 
> Type: COM.ALLAIRE.COLDFUSION.CFEXECUTE.OUTPUTERROR
> Message: Cannot execute C:\Program
> Files\ImageMagick-6.0.1-Q16\convert.exe 
> Detail: Windows NT error 3 occurred.
> 
> 
> The error occurred while processing an element with a general
> identifier of (CFTHROW), occupying document position (307:5) to
> (322:15) in the template file
> C:\CFUSION\CUSTOMTAGS\MAGICKTAG\MAGICKTAG.CFM.
> 
> Thanks
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192051
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: J2EE Sessions

2005-01-27 Thread Nathan Strutz
You're a bit confused. You can only do session replication with CFMX 
Enterprise. In that situation, you're relying on the underlying J2EE 
server, which is why you have to use JSessionID's.

Seeing as enterprise costs ~$4k more than pro, you're better off getting 
a few boxes and a hardware load balancer.

-nathan strutz
http://www.dopefly.com/


Brook Davies wrote:
> I'm trying to cluster 2 CFMX Pro servers using J2EE session vars. I'm told 
> its possible.
> 
> Does this require, that when I installed CFMX I selected the "J2EE 
> configuration (Coldfusion MX with Jrun4)" as opposed to the standard 
> "Server Configuration" option? I've been reaidng up on J2EE sessions vars, 
> but have not found how to cluster them.  Can someone point me to an article 
> or some more info?
> 
> Brook Davies
> logiforms.com
> 
> 
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192050
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Blackstone and XHTML

2005-01-27 Thread Jim Davis
> -Original Message-
> From: Will Tomlinson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 27, 2005 8:02 PM
> To: CF-Talk
> Subject: Blackstone and XHTML
> 
> Is Blackstone going to take care of this non XHTML compliant code CF
> writes for cfform? Everything is uppercase.
> 
> I'm trying to make all my stuff XHTML compliant, and I like using
> cfform/validation because I'm extremely lazy!

I believe so.  I see the guy that wrote most of that now and again - I'll
pass on the frustration.  ;^)

Jim Davis





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192049
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Closing Oracle Cursors

2005-01-27 Thread Douglas Knudsen
I had a similar experience
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=27718&forumid=4

maybe since the DB connections are maintained and pooled...or
something?  Before CFMX I never saw this error.  I had our DBA up the
limit and no issue since then.

Doug


On Thu, 27 Jan 2005 19:34:54 -0500, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> Are you executing stored procedures or inline via cfquery?
> 
> -Adam
> 
> On Thu, 27 Jan 2005 17:44:12 -0500, Scott Mulholland
> <[EMAIL PROTECTED]> wrote:
> > I am connecting to a new database run by another company and have been
> > experiencing an intermittent error:
> >
> > [Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000:
> > maximum open cursors exceeded
> >
> > When I talked to the DBA's who maintain the database they told me:
> >
> > If your app is erroring out with the "max opened cursors exceeded"
> > error, then its usually an indicator that your app is not explicity
> > closing all cursors that it is opening. Each insert or select sequence
> > statement would be an implicit cursor in Oracle.   Coldfusion should
> > close the cursors.
> >
> > Anyone know how to go about this?  I worked with Oracle about 3 years
> > ago regularly and don't remember this ever coming up?  Is this possibly
> > version dependent?
> >
> > Thanks,
> > Scott
> >
> > ---
> > [This E-mail scanned for viruses by Declude Virus]
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192048
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Russ Unger
So, anyone want to make a quick $20 and help me finish setting up my
FCK?  I seem to be hitting some brickwalls that shouldn't be that major.

Email off-list if you can do this via AIM and I'm your new friend with
Paypal.

> -Original Message-
> From: Russ Unger [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, January 27, 2005 7:58 PM
> To: CF-Talk
> Subject: RE: WYSIWYG Rich Text Area Editor
> 
> 
> > umm . yeah
> > 
> >  jk, lol, i do too
> >  so much easier to use then fck
> 
> You know, not an entirely untrue statement.
> 
> Sure, I've just begun diving into fck, but there's A LOT left to be
> desired for documentation and how to set up things like custom menus,
> how to turn on uploading of images, etc.
> 
> That's really what stings about this--because it really doesn't look
> like it's all that difficult, but there's a learning curve to 
> get warmed
> up to it without any appropriate help/docs or even real-world examples
> with it.
> 
> Bah.
> 
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192047
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Closing Oracle Cursors

2005-01-27 Thread Scott Mulholland
Inline via cfquery

-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 7:35 PM
To: CF-Talk
Subject: Re: Closing Oracle Cursors


Are you executing stored procedures or inline via cfquery?

-Adam


On Thu, 27 Jan 2005 17:44:12 -0500, Scott Mulholland
<[EMAIL PROTECTED]> wrote:
> I am connecting to a new database run by another company and have been

> experiencing an intermittent error:
> 
> [Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: 
> maximum open cursors exceeded
> 
> When I talked to the DBA's who maintain the database they told me:
> 
> If your app is erroring out with the "max opened cursors exceeded" 
> error, then its usually an indicator that your app is not explicity 
> closing all cursors that it is opening. Each insert or select sequence
> statement would be an implicit cursor in Oracle.   Coldfusion should
> close the cursors.
> 
> Anyone know how to go about this?  I worked with Oracle about 3 years 
> ago regularly and don't remember this ever coming up?  Is this 
> possibly version dependent?
> 
> Thanks,
> Scott
> 
> ---
> [This E-mail scanned for viruses by Declude Virus]
> 
> 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192046
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: WYSIWYG Rich Text Area Editor

2005-01-27 Thread James Holmes
I use TinyMCE and I still think it's superior to the others, for our
purposes. I really like being able point Mac / Linux users to Firefox, in
which it still works on those platforms.

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Friday, 28 January 2005 8:09 AM
To: CF-Talk
Subject: Re: WYSIWYG Rich Text Area Editor

Am I the only one retarded enough to use TinyMCE? Why do I like it so much?
Is something wrong with me? 

Just wondering...

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192045
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


J2EE Sessions

2005-01-27 Thread Brook Davies
I'm trying to cluster 2 CFMX Pro servers using J2EE session vars. I'm told 
its possible.

Does this require, that when I installed CFMX I selected the "J2EE 
configuration (Coldfusion MX with Jrun4)" as opposed to the standard 
"Server Configuration" option? I've been reaidng up on J2EE sessions vars, 
but have not found how to cluster them.  Can someone point me to an article 
or some more info?

Brook Davies
logiforms.com



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192044
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFID & CFTOKEN in URL (in CF5)

2005-01-27 Thread Keith Gaughan
Paul Smith wrote:

> I'm re-doing a website to use Cookies to maintain state for sessions.  I'm 
> only setting cookies in the browser.  I assume the coding below will delete 
> cookies in the visitor's browser when they close it.  Not interested at 
> this time in setting any cookies on the visitor's hard drive.  My 
> application.cfm includes the following:
> 
>name="syp"
>   clientmanagement="Yes"
>   SessionManagement="yes"
>   setclientcookies="Yes"
>  >
> 
>
>
> 
> But when the home page is opened the following URL appears in the browser 
> window:
> 
> http://dev.smarteryellowpages.com/index.cfm?CFID=49911&CFTOKEN=63451286
> 
> How do I delete the display of CFID/CFTOKEN and their values in the URL?

You realise that you're doing something that CF does itself when you've
got session management on? CF stores those in cookies itself if it can,
otherwise it maintains the session using URL rewriting, which is what
you saw. However, if turns out that the browser accepts cookies, it
stops using URL rewriting.

Is there any particular reason why you're doing this? If it's that you
want the contents of the session itself in cookies (thought I can't
fathom why), then why not just use client variables?

K.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://digital-crew.com/

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192043
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Blackstone and XHTML

2005-01-27 Thread Will Tomlinson
Is Blackstone going to take care of this non XHTML compliant code CF writes for 
cfform? Everything is uppercase. 

I'm trying to make all my stuff XHTML compliant, and I like using 
cfform/validation because I'm extremely lazy! 

Will

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192042
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Russ Unger
> umm . yeah
> 
>  jk, lol, i do too
>  so much easier to use then fck

You know, not an entirely untrue statement.

Sure, I've just begun diving into fck, but there's A LOT left to be
desired for documentation and how to set up things like custom menus,
how to turn on uploading of images, etc.

That's really what stings about this--because it really doesn't look
like it's all that difficult, but there's a learning curve to get warmed
up to it without any appropriate help/docs or even real-world examples
with it.

Bah.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192041
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Will Tomlinson
> umm . yeah
> jk, lol, i do too
 so much easier to use then fck

Up pops super dave to slam me! I'm shocked!   :)

Hey, how about shootin' me an email. We got some things to discuss! 

Will

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192040
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


CFID & CFTOKEN in URL (in CF5)

2005-01-27 Thread Paul Smith
I'm re-doing a website to use Cookies to maintain state for sessions.  I'm 
only setting cookies in the browser.  I assume the coding below will delete 
cookies in the visitor's browser when they close it.  Not interested at 
this time in setting any cookies on the visitor's hard drive.  My 
application.cfm includes the following:



   
   

But when the home page is opened the following URL appears in the browser 
window:

http://dev.smarteryellowpages.com/index.cfm?CFID=49911&CFTOKEN=63451286

How do I delete the display of CFID/CFTOKEN and their values in the URL?

best,  paul




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192039
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread dave

umm . yeah

 jk, lol, i do too
 so much easier to use then fck


From: Will Tomlinson <[EMAIL PROTECTED]>
Sent: Thursday, January 27, 2005 8:08 PM
To: CF-Talk 
Subject: Re: WYSIWYG Rich Text Area Editor 

Am I the only one retarded enough to use TinyMCE? Why do I like it so much? Is 
something wrong with me? 

Just wondering...

Will



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192038
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Lesson / Tutorial Websites

2005-01-27 Thread Will Tomlinson
I'm no advanced CF'er but learned it pretty quick with just a few books. 

In order of precedence

1. Anything with the name Forta on it!
2. CF certification developer study guide (actually was great for learning for 
me)
3. WACK

Oh hang on...all those are Forta! oops!

You read though them, and you can do some damage

Will

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192037
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Will Tomlinson
Am I the only one retarded enough to use TinyMCE? Why do I like it so much? Is 
something wrong with me? 

Just wondering...

Will

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192036
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Closing Oracle Cursors

2005-01-27 Thread Adrocknaphobia
Are you executing stored procedures or inline via cfquery?

-Adam


On Thu, 27 Jan 2005 17:44:12 -0500, Scott Mulholland
<[EMAIL PROTECTED]> wrote:
> I am connecting to a new database run by another company and have been
> experiencing an intermittent error:
> 
> [Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000:
> maximum open cursors exceeded
> 
> When I talked to the DBA's who maintain the database they told me:
> 
> If your app is erroring out with the "max opened cursors exceeded"
> error, then its usually an indicator that your app is not explicity
> closing all cursors that it is opening. Each insert or select sequence
> statement would be an implicit cursor in Oracle.   Coldfusion should
> close the cursors.
> 
> Anyone know how to go about this?  I worked with Oracle about 3 years
> ago regularly and don't remember this ever coming up?  Is this possibly
> version dependent?
> 
> Thanks,
> Scott
> 
> ---
> [This E-mail scanned for viruses by Declude Virus]
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192035
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Robert Munn
I have used HTMLArea 3, and it is pretty good, but it is a pain in the ass to 
configure correctly. 

By far the best HTML editor I have used is the newest version of the old 
Spectra editor, eWebeditPro. It supports CSS, XHTML, file uploading, even image 
manipulation. If you bu the +XML version, it allows you to configure XML 
templates where users only have certain writable fields inside the editor that 
they can change- like Dreamweaver templates only right inside the editor on the 
site. Really nice. 

Downside? They say it is cross-browser compatible, but I have never been able 
to get it to work with Firefox, so it is Windows/IE only in my apps. And oh 
yeah, it's not free or even cheap if you plan to use it with a lot of users. 
For a small number of Windows users it is a great solution. 

>Russ wrote:

>That said, I've been searching for a WYSIWYG Rich Text Area Editor that
>allows users to control the normal aspects and allows for the uploading of
>images with the content, with the controls at my discretion.

...
>
>Does anyone have any recommedations or even any guidance to help me out
>with this?  I'm not opposed to a "build my own" solution, assuming it
>comes with a tutorial and a paint-by-numbers guide. (that's tongue in
>cheeck)

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192034
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Date problem between Coldfusion 5 and MX

2005-01-27 Thread Larry White
Use This:




#faqdate#



>Hi everyone,
>
>I'm upgrading a site from Coldfusion 5 to MX but I have a date bug.
>In Coldfusion 5, I got the "last modified date" of a file and converted 
>it with DateFormat like this :
>
>
>
>filter="dspFaq.cfm">
>
>
>
>My faqDate.DatelastModified with CF5 is like this : "*01/17/2005 
>10:53:00 AM*"
>But with  MX, I get this : *"lundi 17 janvier 2005 10 h 53 CET"
>*So of course, the left() function can't be used with this string and it 
>bugs. I used a artisanal trick to solve this problem, but I'd like to 
>understand how MX deals with the system dates, which functions I could 
>use...
>
>Thanks a lot,
>-- 
>
>*Nath* 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192033
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT SQL date/time default

2005-01-27 Thread Larry White
Instead of len(trim(form.side1collectionsdate)) it would
probably be better to use IsDate(form.side1collectionsdate)
Otherwise anything they type in, date or not, would be
entered.


> Thanks Ian, Randy, and Michael!
> 
> Your suggestions combined helped me. Now I understand (and better 
> appreciate) using  especially since it also makes things 
> more secure.
> 
> This line worked: 
>  CFSQLTYPE="CF_SQL_VARCHAR" null="#yesNoFormat(NOT len(trim(form.
> side1collectionsdate)))#">
> 
> Robert O.
> 
> -Original Message-
> From: Ian Skinner [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 27, 2005 1:06 PM
> To: CF-Talk
> Subject: RE: OT SQL date/time default
> 
> 
> That is probably your problem.  I presume that form.formdate is a text 
> field.  And a empty text field is ' which is completely different then 
> NULL.  So you are inserting a value into the date field, a value of an 
> empty string, but a value none the less.
> 
> For situations like this and many other good reasons you should read 
> up on the  tag.
> 
> To fix your date issue trying changing this line
> 
...
> '#form.formdate#',
> 
> To
> 
>  null="#yesNoFormat(NOT len(trim(form.formdate)))#">
> 
> Now looking at your code example, you seem to be inserting your date 
> as a string, not a date?  Is the field in the database a date field or 
> a char|varchar field?
> 
> PS you should change your other inserts to queryparams as well.
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> 
> 
...
> -Original Message-
...
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
...
> Sent: Thursday, January 27, 2005 9:56 AM
...
> To: CF-Talk
...
> Subject: RE: OT SQL date/time default
...
> 
...
> Ian, Randy,
...
> 
...
> Just a plain insert and I fear that is the problem...only I don't 
> work
...
> with CF enough to know the coding tips.
...
> 
...
> Here it is below:
...
> 
...
> 
...
> Insert into off
...
> (
...
> formdate,
...
> admin,
...
> side1collectionsdate,
...
> side2collectionsdate,
...
> side3collectionsdate,
...
> side4collectionsdate,
...
> side5collectionsdate
...
> )
...
> VALUES
...
> (
...
> '#form.formdate#',
...
> '#form.admin#',
...
> '#form.side1collectionsdate#',
...
> '#form.side2collectionsdate#',
...
> '#form.side3collectionsdate#',
...
> '#form.side4collectionsdate#',
...
> '#form.side5collectionsdate#'
...
> )
...
> 
> 
> Confidentiality Notice:  This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message. 
> 
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192032
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ORDER BY on a query within a query

2005-01-27 Thread Larry White
It doesn't make any difference whether The Order By is in the
inner or outer select. The inner select is really a view, so you
can order the view, or the select statement running against the
view. Same results. The results are weird though.


>Can you show us what Oracle is getting? the query from the debug output?
>
>
>
>On Thu, 27 Jan 2005 14:27:14 -0400, daniel kessler <[EMAIL PROTECTED]> wrote:
>>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192031
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Barney Boisvert
Safari doesn't come with included HTML-editing abilities like Mozilla
and IE do.  So if you have to support Safari, you'll need to pick up a
full-fledged editing tool, mostly likely written in Java.  If it's
Java, it'll run anywhere, though you'll mostly likely pay out the
nose.

If you can skip Safari and just deal with Mozilla (and derivatives)
then any of the editors mentioned in the thread aside from soEditor
should meet your needs.

cheers,
barneyb

On Thu, 27 Jan 2005 17:17:52 -0500, Troy Montour <[EMAIL PROTECTED]> wrote:
> Hello everyone,
> sorry going to jump on board with this question since the place I'm working 
> at is running macs.. So I'm looking for a mac/win option for a WYSIWYG Rich 
> Text Area Editor.
> 
> would the same suggestions work or would you suggest something different?
> 
> Thank you
> Troy Montour
> 
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 6 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192030
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Troy Montour
Hello everyone,
sorry going to jump on board with this question since the place I'm working at 
is running macs.. So I'm looking for a mac/win option for a WYSIWYG Rich Text 
Area Editor.

would the same suggestions work or would you suggest something different?

Thank you
Troy Montour 

 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192029
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Closing Oracle Cursors

2005-01-27 Thread Scott Mulholland
I am connecting to a new database run by another company and have been
experiencing an intermittent error:
 
[Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000:
maximum open cursors exceeded
 
When I talked to the DBA's who maintain the database they told me:
 
If your app is erroring out with the "max opened cursors exceeded"
error, then its usually an indicator that your app is not explicity
closing all cursors that it is opening. Each insert or select sequence
statement would be an implicit cursor in Oracle.   Coldfusion should
close the cursors.
 
Anyone know how to go about this?  I worked with Oracle about 3 years
ago regularly and don't remember this ever coming up?  Is this possibly
version dependent?
 
Thanks,
Scott

---
[This E-mail scanned for viruses by Declude Virus]


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192028
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Barney Boisvert
I was teasing.  I've done much the same thing with multi-editor
environments.  Never got more than 4 in the mix, but it worked quite
well.  The harder part was making all the editors functionally
equivalent (or at least close), because we'd done a fair amount of
doctoring, particularly with the image and link dialogs, for the
application in question.

cheers,
barneyb


On Thu, 27 Jan 2005 14:19:26 -0800, Rob <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Jan 2005 11:15:55 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> > Russ, all three editors are cross platform.  I use all three on
> > Windows and OSX, using IE and FireFox.  I don't think any of them work
> > in Safari, but who uses that?  ;)
> 
> Hey! I do from time to time...
> 
> For one of my closed source projects I wrote a little compatibility
> layer and allowed the client to choose which one they wanted to use
> (all the open ones, a couple commercial, and a java one for us safari
> guys). It's pretty cool and if you write it all generic like, you
> could use it for all sorts of projects. - maybe someone could write an
> open one...
> 
> I say, use'em all :)
> 
> --
> ~Blog~
> http://www.robrohan.com
> ~The cfml plug-in for eclipse~
> http://cfeclipse.tigris.org
> ~open source xslt IDE~
> http://treebeard.sourceforge.net
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 6 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192027
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Magictag

2005-01-27 Thread Qasim Rasheed
I am trying ti incorporate magictag by Algad for a client who is
currently running CF5. However it is giving me the following error.
Any help is greatly appreciated.

Error Diagnostic Information
ImageMagick execution produced an error.

Type: COM.ALLAIRE.COLDFUSION.CFEXECUTE.OUTPUTERROR 
Message: Cannot execute C:\Program Files\ImageMagick-6.0.1-Q16\convert.exe 
Detail: Windows NT error 3 occurred. 


The error occurred while processing an element with a general
identifier of (CFTHROW), occupying document position (307:5) to
(322:15) in the template file
C:\CFUSION\CUSTOMTAGS\MAGICKTAG\MAGICKTAG.CFM.

Thanks

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192026
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Rob
On Thu, 27 Jan 2005 11:15:55 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> Russ, all three editors are cross platform.  I use all three on
> Windows and OSX, using IE and FireFox.  I don't think any of them work
> in Safari, but who uses that?  ;)

Hey! I do from time to time...

For one of my closed source projects I wrote a little compatibility
layer and allowed the client to choose which one they wanted to use
(all the open ones, a couple commercial, and a java one for us safari
guys). It's pretty cool and if you write it all generic like, you
could use it for all sorts of projects. - maybe someone could write an
open one...

I say, use'em all :) 

-- 
~Blog~
http://www.robrohan.com
~The cfml plug-in for eclipse~
http://cfeclipse.tigris.org
~open source xslt IDE~
http://treebeard.sourceforge.net

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192025
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Barney Boisvert
They both have word sweepers.  HTMLArea's seems to work better than
soEditors, but it's not bulletproof.  I added a few tweaks to the
soEditor sweeper to catch some stuff it missed, and I've got both
running with pretty good success.

cheers,
barneyb

On Thu, 27 Jan 2005 16:18:06 -0500, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> Barney, does soEdit or HTMLArea have the ability to run any types of
> HTML cleaner like a word HTML cleaner on paste?
> 
> -Adam
> 
> 


-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 6 invites.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192024
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread russ
So far, with all of the research I've done--and thanks very much to
everyone and all of the opinions (seems like this has been/is a really
healthy thread, btw), I think I'm going with a couple of options:

For the "public facing", anyone-can-add-them "Comments" thingy, I'll
probably use tmt_xhtmleditorpro.  Just seems to make more sense at this
point in time to sort of be more restrictive/limited on the front end.

For the "internal facing", only the authors and editors will see it, I'll
probably implement FCKEditor.  The nice functionality within will be
great, but still may be too much for some of the authors, so I may end up
regressing to xhtmleditorpro.  Advantage is that FCK works with a lot more
browsers and I can cripple it to the minimums, so it's a tough call.

It'll be an interesting evening, I'm sure.

Thanks again, everyone!



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192023
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread David Brown
soEdit does, but it does not work very well.
- Original Message - 
From: "Adrocknaphobia" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, January 27, 2005 4:18 PM
Subject: Re: WYSIWYG Rich Text Area Editor


> Barney, does soEdit or HTMLArea have the ability to run any types of
> HTML cleaner like a word HTML cleaner on paste?
>
> -Adam
>
> On Thu, 27 Jan 2005 13:00:53 -0800, Barney Boisvert <[EMAIL PROTECTED]> 
> wrote:
>> if all you care about is windows, you might look at soEditor.  It's
>> not free (anymore), but it's pretty good.  We used it (and are still
>> using it) though we're migrating to HTMLArea for the platform
>> independance, which has become more and more important over the past
>> 6-8 months.
>>
>> Of the WYSIWYG editors I've played with, it seems to generate the best
>> HTML code in terms of maintaining structure, but it's still a jumbled
>> mess.  And like every decent editor out there (including all the ones
>> mentioned thus far) you can disable the color/font/whatever buttons
>> and only let your users type and apply CSS classes that you've
>> predefined..
>>
>> cheers,
>> barneyb
>>
>> On Thu, 27 Jan 2005 15:33:29 -0500, Adrocknaphobia
>> <[EMAIL PROTECTED]> wrote:
>> > Well I have _several_ issues with it. Remember I'm not using the beta
>> > version, so maybe these issue have been resolved. Mainly it's the end
>> > users who have serious complaints ranging from how it pastes from
>> > other applications, hard returns, inability to use borderless tables
>> > (ie when you set the broder to 0 in the editor the border is no longer
>> > displayed in the editor, meaning you have no way of knowing what cell
>> > you are editing and such).
>> >
>> > Here is an email I just received while typing this up.
>> >
>> > "Our big issue today is that editing submitted reports (in both the
>> > executive and the risc tool) changes the format of submissions so that
>> > every paragraph becomes its own picture.  You can't deal with spacing
>> > anymore, and all previous formatting goes out the window.  Yick! "
>> >
>> > From my point of view, the code is a bit sloppy and unmanagable. The
>> > HTML it generates is less than desireable. I just want clean XHTML
>> > consiting of only base tags, so that external style sheets can be
>> > applied and fonts/sizes/colors are not determined by the user.
>> >
>> > The fckEditor just isn't cutting it, so I'm looking for alternatives.
>> > I only have to worry about IE5.5+.
>> >
>> > -Adam
>> >
>> --
>> Barney Boisvert
>> [EMAIL PROTECTED]
>> 360.319.6145
>> http://www.barneyb.com/
>>
>> Got Gmail? I have 6 invites.
>>
>>
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192022
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Adrocknaphobia
Barney, does soEdit or HTMLArea have the ability to run any types of
HTML cleaner like a word HTML cleaner on paste?

-Adam


On Thu, 27 Jan 2005 13:00:53 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> if all you care about is windows, you might look at soEditor.  It's
> not free (anymore), but it's pretty good.  We used it (and are still
> using it) though we're migrating to HTMLArea for the platform
> independance, which has become more and more important over the past
> 6-8 months.
> 
> Of the WYSIWYG editors I've played with, it seems to generate the best
> HTML code in terms of maintaining structure, but it's still a jumbled
> mess.  And like every decent editor out there (including all the ones
> mentioned thus far) you can disable the color/font/whatever buttons
> and only let your users type and apply CSS classes that you've
> predefined..
> 
> cheers,
> barneyb
> 
> On Thu, 27 Jan 2005 15:33:29 -0500, Adrocknaphobia
> <[EMAIL PROTECTED]> wrote:
> > Well I have _several_ issues with it. Remember I'm not using the beta
> > version, so maybe these issue have been resolved. Mainly it's the end
> > users who have serious complaints ranging from how it pastes from
> > other applications, hard returns, inability to use borderless tables
> > (ie when you set the broder to 0 in the editor the border is no longer
> > displayed in the editor, meaning you have no way of knowing what cell
> > you are editing and such).
> >
> > Here is an email I just received while typing this up.
> >
> > "Our big issue today is that editing submitted reports (in both the
> > executive and the risc tool) changes the format of submissions so that
> > every paragraph becomes its own picture.  You can't deal with spacing
> > anymore, and all previous formatting goes out the window.  Yick! "
> >
> > From my point of view, the code is a bit sloppy and unmanagable. The
> > HTML it generates is less than desireable. I just want clean XHTML
> > consiting of only base tags, so that external style sheets can be
> > applied and fonts/sizes/colors are not determined by the user.
> >
> > The fckEditor just isn't cutting it, so I'm looking for alternatives.
> > I only have to worry about IE5.5+.
> >
> > -Adam
> > 
> --
> Barney Boisvert
> [EMAIL PROTECTED]
> 360.319.6145
> http://www.barneyb.com/
> 
> Got Gmail? I have 6 invites.
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192021
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Stripping variables from CF templates?

2005-01-27 Thread Claude Schneegans
 >>Any tools or snippets that can do that?

This kind of job is for CF_REextract (lool at the address below)
It is able to read the files for you and will return all hits in a query,
togethet with the string found, the index in the file and the length, etc.


-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192020
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


List Attributes in an objectclass in LDAP

2005-01-27 Thread David Brown
In our LDAP server not all attributes have been created in the =
objectclass I need to update.   For example:

homeInfo objectclass exists for the user, but attribute mobile may not.  =
You can't update an attribute if it doe not exist.  So you have to =
create it first.  I may also need to create the objectclass.  To do that =
I first query the CN (user record) pull back the objectclass attribute.  =
>From there I treat that as list and look for the ojectclass that I need =
in the list.  If it does not exists then I create the objectclass.  I =
would like to do the same thing with the attributes that I need to =
create.  I would like to query the CN record and pull back all of the =
attributes for one objectclass and then evaulate what attributes I need =
to the list.  If one does not exists then create it before I try to =
update it.

Here is the code I have so for.  It will query the LDAP sever pull back =
the objectclass list for a CN record then loop over the two =
objectclasses I need to exists.  If not then create objectclass.  If the =
objectclass did not exists then of course I need to loop over all of the =
attributes and create each one.

The problem lies if the objectclass already exists, but dome of the =
attributes does not.  They will vary form CN to CN.





=20

=20


 
  
  =20
  
   
  
 =20
=20

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192019
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Burns, John D
Yeah, the new FCK has a setting in the config for XHTML compliance and
seems to handle a lot of things a lot better.  Code seems cleaner as
well, though it written to be quite flexible so can get very confusing.
For instance, the file upload screen uses a standard HTML window with
Javascript that makes a call to whatever "connector" you use (CFM, ASP,
etc) that queries the list of files and returns an XML document to the
originating HTML page that parses it and displays it with javascript.
This makes it easy to make your own connector because it just needs to
pass back an XML document in the format that the HTML page expected but
can be pretty tedious to change the display of the data. There is also a
setting for style sheet to be used within the editor in the config file.
However, the one thing that I don't see at this point is the ability to
do font styles with a drop-down, select-type tool.  I put in a request
for that though.  The new version seems much, much better 


John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer

-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 3:33 PM
To: CF-Talk
Subject: Re: WYSIWYG Rich Text Area Editor

Well I have _several_ issues with it. Remember I'm not using the beta
version, so maybe these issue have been resolved. Mainly it's the end
users who have serious complaints ranging from how it pastes from other
applications, hard returns, inability to use borderless tables (ie when
you set the broder to 0 in the editor the border is no longer displayed
in the editor, meaning you have no way of knowing what cell you are
editing and such).

Here is an email I just received while typing this up.

"Our big issue today is that editing submitted reports (in both the
executive and the risc tool) changes the format of submissions so that
every paragraph becomes its own picture.  You can't deal with spacing
anymore, and all previous formatting goes out the window.  Yick! "

>From my point of view, the code is a bit sloppy and unmanagable. The
HTML it generates is less than desireable. I just want clean XHTML
consiting of only base tags, so that external style sheets can be
applied and fonts/sizes/colors are not determined by the user.

The fckEditor just isn't cutting it, so I'm looking for alternatives.
I only have to worry about IE5.5+.

-Adam

On Thu, 27 Jan 2005 14:28:34 -0500, Tony Weeg <[EMAIL PROTECTED]>
wrote:
> sup adrock
> 
> whats ur beef with fckedit?
> 
> i got it working nice for a client...
> 
> tw
> 
> 
> On Thu, 27 Jan 2005 11:15:55 -0800, Barney Boisvert
<[EMAIL PROTECTED]> wrote:
> > Russ, all three editors are cross platform.  I use all three on 
> > Windows and OSX, using IE and FireFox.  I don't think any of them 
> > work in Safari, but who uses that?  ;)
> >
> > Adam, I haven't developed with FCKEditor, only used it as a "user".
> > However, I've mostly heard good things about it.  The other two I do

> > actively use in projects I develop, and they're pretty slick.
> > HTMLArea is more complicated than TinyMCE, but consequently more 
> > flexible.
> >
> > cheers,
> > barneyb
> >
> > On Thu, 27 Jan 2005 12:40:50 -0500 (EST), [EMAIL PROTECTED] 
> > <[EMAIL PROTECTED]> wrote:
> > > Apologies to the list for massive emails--appears I've misread the

> > > docs on HTMLArea and that it WILL work for me...
> > >
> > > My bad.
> > >
> > > > HTMLArea appears to be Windows only solution?  No worries, just 
> > > > adding clarification that I need something cross-platform (win 
> > > > and lin), so was hoping to work within a CFMX solution as 
> > > > opposed to a javascript solution that has dependencies.  Based 
> > > > upon other comments, I'll take a look at TinyMCE now, but hope
my additional info helpse.
> > > >
> > > > Thanks!
> > > >
> > > > Russ
> > > >
> > > >> On Thu, 27 Jan 2005 10:07:42 -0800, Barney Boisvert 
> > > >> <[EMAIL PROTECTED]>
> > > >> wrote:
> > > >>> FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical 
> > > >>> order) are three free options that I've used and liked.  All 
> > > >>> have different characterisics, but any would probably searve 
> > > >>> as a suitable base point for your project.
> > > >>>
> > > >>> cheers,
> > > >>> barneyb
> > > >>>
> > > >>> On Thu, 27 Jan 2005 11:45:06 -0500 (EST), 
> > > >>> [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > > >>> > I'll apologize in advance; the HoF server is really, really 
> > > >>> > dragging
> > > >>> on me
> > > >>> > today, so my attempts at a search on the topic were 
> > > >>> > pretty...  Well,
> > > >>> I
> > > >>> > didn't get very far.
> > > >>> >
> > > >>> > That said, I've been searching for a WYSIWYG Rich Text Area 
> > > >>> > Editor
> > > >>> that
> > > >>> > allows users to control the normal aspects and allows for 
> > > >>> > the
> > > >>> uploading of
> > > >>> > images with the content, with the controls at my discretion.
> > > >>> >
> > > >>> > I've checked into ActivEd

Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Barney Boisvert
if all you care about is windows, you might look at soEditor.  It's
not free (anymore), but it's pretty good.  We used it (and are still
using it) though we're migrating to HTMLArea for the platform
independance, which has become more and more important over the past
6-8 months.

Of the WYSIWYG editors I've played with, it seems to generate the best
HTML code in terms of maintaining structure, but it's still a jumbled
mess.  And like every decent editor out there (including all the ones
mentioned thus far) you can disable the color/font/whatever buttons
and only let your users type and apply CSS classes that you've
predefined..

cheers,
barneyb

On Thu, 27 Jan 2005 15:33:29 -0500, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> Well I have _several_ issues with it. Remember I'm not using the beta
> version, so maybe these issue have been resolved. Mainly it's the end
> users who have serious complaints ranging from how it pastes from
> other applications, hard returns, inability to use borderless tables
> (ie when you set the broder to 0 in the editor the border is no longer
> displayed in the editor, meaning you have no way of knowing what cell
> you are editing and such).
> 
> Here is an email I just received while typing this up.
> 
> "Our big issue today is that editing submitted reports (in both the
> executive and the risc tool) changes the format of submissions so that
> every paragraph becomes its own picture.  You can't deal with spacing
> anymore, and all previous formatting goes out the window.  Yick! "
> 
> From my point of view, the code is a bit sloppy and unmanagable. The
> HTML it generates is less than desireable. I just want clean XHTML
> consiting of only base tags, so that external style sheets can be
> applied and fonts/sizes/colors are not determined by the user.
> 
> The fckEditor just isn't cutting it, so I'm looking for alternatives.
> I only have to worry about IE5.5+.
> 
> -Adam
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 6 invites.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192017
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Stripping variables from CF templates?

2005-01-27 Thread Ben Doom
Off the top of my head, you could use:

session\.[a-z0-9."[]]+

would work, but it's not tested and probably could use refinement.

--Ben

Nick Baker wrote:
> MX 6.1
> 
> And, thanks,
> 
> Nick
> 
> 
> At 01:37 PM 1/27/2005, you wrote:
> 
>>What CF version?
>>
>>Also, if you want to end up with really good solutions, I'd move this to
>>the CF-Regex list.  It's fairly low traffic, so nearly every question
>>gets hammered with good answers.
>>
>>--Ben
>>
>>Nick Baker wrote:
>>
>>>Any hints on how to create a regex to extract the complete session.XXX or
>>>server.mydomain.XXX would be appreciated?
>>
>>
>>
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192016
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Adrocknaphobia
Massimo,

You know man, you had me sold on this wehn I first started looking,
but then everyon onthis list jumped on the fckEditor bandwagon, and a
few people at MAX swore by it so I thought I would give it try.

I should have gone with yours. :-P

Oh well, live and learn.

-Adam


On Thu, 27 Jan 2005 21:12:41 +0100, Massimo, Tiziana e Federica
<[EMAIL PROTECTED]> wrote:
> > I'm using FCKEditor right now, which I'm not happy with at all. (Using
> > the latest release, not the current beta). How clean is HTMLArea and
> > TinyMCE HTML code thats generated? I only want to selected base HTML
> > tags like p, h1, etc. Which mean there needs to be some sort of Word
> > pasted html cleaning.
> 
> If cleaning Word's garbage is important for you this could be worth a look:
> 
> http://www.olimpo.ch/tmt/tag/tmt_xhtmleditorPro/
> 
> Be advised is not as sophisticated as other alternatives and works only on
> IE/Win
> 
> 
> Massimo Foti
> DW tools: http://www.massimocorner.com
> CF tools:  http://www.olimpo.ch/tmt/
> 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192015
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Adrocknaphobia
Well I have _several_ issues with it. Remember I'm not using the beta
version, so maybe these issue have been resolved. Mainly it's the end
users who have serious complaints ranging from how it pastes from
other applications, hard returns, inability to use borderless tables
(ie when you set the broder to 0 in the editor the border is no longer
displayed in the editor, meaning you have no way of knowing what cell
you are editing and such).

Here is an email I just received while typing this up.

"Our big issue today is that editing submitted reports (in both the
executive and the risc tool) changes the format of submissions so that
every paragraph becomes its own picture.  You can't deal with spacing
anymore, and all previous formatting goes out the window.  Yick! "

>From my point of view, the code is a bit sloppy and unmanagable. The
HTML it generates is less than desireable. I just want clean XHTML
consiting of only base tags, so that external style sheets can be
applied and fonts/sizes/colors are not determined by the user.

The fckEditor just isn't cutting it, so I'm looking for alternatives.
I only have to worry about IE5.5+.

-Adam

On Thu, 27 Jan 2005 14:28:34 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote:
> sup adrock
> 
> whats ur beef with fckedit?
> 
> i got it working nice for a client...
> 
> tw
> 
> 
> On Thu, 27 Jan 2005 11:15:55 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> > Russ, all three editors are cross platform.  I use all three on
> > Windows and OSX, using IE and FireFox.  I don't think any of them work
> > in Safari, but who uses that?  ;)
> >
> > Adam, I haven't developed with FCKEditor, only used it as a "user".
> > However, I've mostly heard good things about it.  The other two I do
> > actively use in projects I develop, and they're pretty slick.
> > HTMLArea is more complicated than TinyMCE, but consequently more
> > flexible.
> >
> > cheers,
> > barneyb
> >
> > On Thu, 27 Jan 2005 12:40:50 -0500 (EST), [EMAIL PROTECTED]
> > <[EMAIL PROTECTED]> wrote:
> > > Apologies to the list for massive emails--appears I've misread the docs on
> > > HTMLArea and that it WILL work for me...
> > >
> > > My bad.
> > >
> > > > HTMLArea appears to be Windows only solution?  No worries, just adding
> > > > clarification that I need something cross-platform (win and lin), so was
> > > > hoping to work within a CFMX solution as opposed to a javascript 
> > > > solution
> > > > that has dependencies.  Based upon other comments, I'll take a look at
> > > > TinyMCE now, but hope my additional info helpse.
> > > >
> > > > Thanks!
> > > >
> > > > Russ
> > > >
> > > >> On Thu, 27 Jan 2005 10:07:42 -0800, Barney Boisvert
> > > >> <[EMAIL PROTECTED]>
> > > >> wrote:
> > > >>> FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical order) are
> > > >>> three free options that I've used and liked.  All have different
> > > >>> characterisics, but any would probably searve as a suitable base point
> > > >>> for your project.
> > > >>>
> > > >>> cheers,
> > > >>> barneyb
> > > >>>
> > > >>> On Thu, 27 Jan 2005 11:45:06 -0500 (EST), [EMAIL PROTECTED]
> > > >>> <[EMAIL PROTECTED]> wrote:
> > > >>> > I'll apologize in advance; the HoF server is really, really dragging
> > > >>> on me
> > > >>> > today, so my attempts at a search on the topic were pretty...  Well,
> > > >>> I
> > > >>> > didn't get very far.
> > > >>> >
> > > >>> > That said, I've been searching for a WYSIWYG Rich Text Area Editor
> > > >>> that
> > > >>> > allows users to control the normal aspects and allows for the
> > > >>> uploading of
> > > >>> > images with the content, with the controls at my discretion.
> > > >>> >
> > > >>> > I've checked into ActivEdit--and it looks great, to be honest.
> > > >>> Perhaps a
> > > >>> > little steep for my "personal project" budget, but in the end that
> > > >>> may
> > > >>> > appear to be the best solution.
> > > >>> >
> > > >>> > Does anyone have any recommedations or even any guidance to help me
> > > >>> out
> > > >>> > with this?  I'm not opposed to a "build my own" solution, assuming 
> > > >>> > it
> > > >>> > comes with a tutorial and a paint-by-numbers guide. (that's tongue 
> > > >>> > in
> > > >>> > cheeck)
> > > >>> >
> > > >>> > Thanks in advance,
> > > >>> >
> > > >>> > Russ
> > > >>> >
> > > >>>
> > > >>> --
> > > >>> Barney Boisvert
> > > >>> [EMAIL PROTECTED]
> > > >>> 360.319.6145
> > > >>> http://www.barneyb.com/
> > > >>>
> > > >>> Got Gmail? I have 6 invites.
> > > >>>
> > > >>>
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> >
> >
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192014
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/c

Re: Stripping variables from CF templates?

2005-01-27 Thread Nick Baker
MX 6.1

And, thanks,

Nick


At 01:37 PM 1/27/2005, you wrote:
>What CF version?
>
>Also, if you want to end up with really good solutions, I'd move this to
>the CF-Regex list.  It's fairly low traffic, so nearly every question
>gets hammered with good answers.
>
>--Ben
>
>Nick Baker wrote:
> > Any hints on how to create a regex to extract the complete session.XXX or
> > server.mydomain.XXX would be appreciated?
>
>
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192013
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


WOT HP vs. IBM terminal types

2005-01-27 Thread Ian Skinner
This is only remotely connected to a ColdFusion issue, but I find this to be a 
very smart and responsive group.

I am trying to educate myself on terminal types.  Specifically, is there any 
possibility that an application that supports connections through the IBM 3270 
terminal type, but is installed on a HP UX computer, can be accessed with this 
protocol?  We currently use VT1xx terminal emulation to access this program, 
but I have a tool that also supports IBM 3270 and is supposedly much easier to 
use in that configuration.  But I can not find anybody who understands what I 
am asking, and I know so little about what I am talking about that it has been 
hard to get a good answer to this question.

Can anybody here help me out, to get an answer or at least enough correct 
information to intelligently ask the question?

Thank You

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192012
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Jared Rypka-Hauer - CMG, LLC
blogCity uses HTMLArea, and I really really like it.

Of all the ones I've seen I like it the best.

Laterz,
J


On Thu, 27 Jan 2005 15:08:17 -0500, Burns, John D
<[EMAIL PROTECTED]> wrote:
> He's just not smart enough to use it :-) Just kidding Adam. Though, I am
> curious what problems he's having with FCK.  I like it very much.  I've
> had a few issues, but I'm customizing it and stuff.  I can't wait til
> the final release comes out so I know my customizations will be good for
> a year or so.  Right now, when I update it with new versions, I have to
> be careful not to overwrite any files I customized.
> 
> John Burns
> Certified Advanced ColdFusion MX Developer
> AI-ES Aeronautics, Web Developer
>
>


-- 
Continuum Media Group LLC
Burnsville, MN 55337
http://www.web-relevant.com
http://cfobjective.blogspot.com

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192011
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Barney Boisvert
Totally off-topic now, but this is exactly the kind of issue that
version control was designed to alleviate.  You just make your changes
willy-nilly, and then when a new release of the third-party code is
made, you check it in and merge your copy into it.  No messing with
overwritten files, and no lost changes.  Most of the time, it doesn't
require any manual intervention beyond hitting the 'merge' button.

cheers,
barneyb

On Thu, 27 Jan 2005 15:08:17 -0500, Burns, John D
<[EMAIL PROTECTED]> wrote:
> He's just not smart enough to use it :-) Just kidding Adam. Though, I am
> curious what problems he's having with FCK.  I like it very much.  I've
> had a few issues, but I'm customizing it and stuff.  I can't wait til
> the final release comes out so I know my customizations will be good for
> a year or so.  Right now, when I update it with new versions, I have to
> be careful not to overwrite any files I customized.
> 
> John Burns
> Certified Advanced ColdFusion MX Developer
> AI-ES Aeronautics, Web Developer
> 


-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 6 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192010
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


OT: Free WIKI web services?

2005-01-27 Thread Jake McKee
Sorry for the off-topic post, but

Does anyone know of a good, free, and password-protectable WIKI?

I might be willing to pay a reasonable amount if I can keep the content 
private and the service is stable.

Thanks!
Jake


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192009
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Massimo, Tiziana e Federica
> I'm using FCKEditor right now, which I'm not happy with at all. (Using
> the latest release, not the current beta). How clean is HTMLArea and
> TinyMCE HTML code thats generated? I only want to selected base HTML
> tags like p, h1, etc. Which mean there needs to be some sort of Word
> pasted html cleaning.

If cleaning Word's garbage is important for you this could be worth a look:

http://www.olimpo.ch/tmt/tag/tmt_xhtmleditorPro/

Be advised is not as sophisticated as other alternatives and works only on
IE/Win


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192008
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Burns, John D
He's just not smart enough to use it :-) Just kidding Adam. Though, I am
curious what problems he's having with FCK.  I like it very much.  I've
had a few issues, but I'm customizing it and stuff.  I can't wait til
the final release comes out so I know my customizations will be good for
a year or so.  Right now, when I update it with new versions, I have to
be careful not to overwrite any files I customized. 


John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 2:29 PM
To: CF-Talk
Subject: Re: WYSIWYG Rich Text Area Editor

sup adrock

whats ur beef with fckedit?

i got it working nice for a client...

tw


On Thu, 27 Jan 2005 11:15:55 -0800, Barney Boisvert
<[EMAIL PROTECTED]> wrote:
> Russ, all three editors are cross platform.  I use all three on 
> Windows and OSX, using IE and FireFox.  I don't think any of them work

> in Safari, but who uses that?  ;)
> 
> Adam, I haven't developed with FCKEditor, only used it as a "user".
> However, I've mostly heard good things about it.  The other two I do 
> actively use in projects I develop, and they're pretty slick.
> HTMLArea is more complicated than TinyMCE, but consequently more 
> flexible.
> 
> cheers,
> barneyb
> 
> On Thu, 27 Jan 2005 12:40:50 -0500 (EST), [EMAIL PROTECTED] 
> <[EMAIL PROTECTED]> wrote:
> > Apologies to the list for massive emails--appears I've misread the 
> > docs on HTMLArea and that it WILL work for me...
> >
> > My bad.
> >
> > > HTMLArea appears to be Windows only solution?  No worries, just 
> > > adding clarification that I need something cross-platform (win and

> > > lin), so was hoping to work within a CFMX solution as opposed to a

> > > javascript solution that has dependencies.  Based upon other 
> > > comments, I'll take a look at TinyMCE now, but hope my additional
info helpse.
> > >
> > > Thanks!
> > >
> > > Russ
> > >
> > >> On Thu, 27 Jan 2005 10:07:42 -0800, Barney Boisvert 
> > >> <[EMAIL PROTECTED]>
> > >> wrote:
> > >>> FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical order) 
> > >>> are three free options that I've used and liked.  All have 
> > >>> different characterisics, but any would probably searve as a 
> > >>> suitable base point for your project.
> > >>>
> > >>> cheers,
> > >>> barneyb
> > >>>
> > >>> On Thu, 27 Jan 2005 11:45:06 -0500 (EST), 
> > >>> [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > >>> > I'll apologize in advance; the HoF server is really, really 
> > >>> > dragging
> > >>> on me
> > >>> > today, so my attempts at a search on the topic were pretty...

> > >>> > Well,
> > >>> I
> > >>> > didn't get very far.
> > >>> >
> > >>> > That said, I've been searching for a WYSIWYG Rich Text Area 
> > >>> > Editor
> > >>> that
> > >>> > allows users to control the normal aspects and allows for the
> > >>> uploading of
> > >>> > images with the content, with the controls at my discretion.
> > >>> >
> > >>> > I've checked into ActivEdit--and it looks great, to be honest.
> > >>> Perhaps a
> > >>> > little steep for my "personal project" budget, but in the end 
> > >>> > that
> > >>> may
> > >>> > appear to be the best solution.
> > >>> >
> > >>> > Does anyone have any recommedations or even any guidance to 
> > >>> > help me
> > >>> out
> > >>> > with this?  I'm not opposed to a "build my own" solution, 
> > >>> > assuming it comes with a tutorial and a paint-by-numbers 
> > >>> > guide. (that's tongue in
> > >>> > cheeck)
> > >>> >
> > >>> > Thanks in advance,
> > >>> >
> > >>> > Russ
> > >>> >
> > >>>
> > >>> --
> > >>> Barney Boisvert
> > >>> [EMAIL PROTECTED]
> > >>> 360.319.6145
> > >>> http://www.barneyb.com/
> > >>>
> > >>> Got Gmail? I have 6 invites.
> > >>>
> > >>>
> > >>
> > >>
> > >
> > >
> >
> >
> 
> 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192007
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Left join works in Access NOT in SQL 7

2005-01-27 Thread Dave Watts
> This ended up working 
> 
> UPDATEtbl_keeplist2
>   SET  tbl_keeplist2.status = 'D'
>   FROM tbl_keeplist2
>   LEFT JOIN 
> tbl_keeplist2_daily ON 
>   tbl_keeplist2.ID = 
> tbl_keeplist2_daily.ID
>   WHERE
> tbl_keeplist2_daily.status = 'P'
>   OR 
> tbl_keeplist2_daily.ID Is Null
> tbl_keeplist2_daily may or may not still have the original 
> ID's in it.

I didn't see that you were doing an outer join in the original query.

> Now I have this original query in Access
> 
> UPDATEtbl_keeplist2 
> RIGHT JOIN tbl_moddate ON tbl_keeplist2.ID = tbl_moddate.ID
> SET   tbl_keeplist2.status = 'R'
> 
> Which does not work so I tried this in SQL server
> 
> 
> UPDATE  tbl_keeplist2
> SET   tbl_keeplist2.status = 'R'
> FROMtbl_keeplist2
> RIGHT JOIN tbl_moddate ON tbl_keeplist2.ID = tbl_moddate.ID
> 
> Which returns
> 
> UPDATE over nullable side of outer join query on table 
> 'tbl_keeplist2'.

I'm a bit surprised that the original query works in Access. If you have a
record in tbl_moddate but not a matching record in tbl_keeplist2, how would
you update tbl_keeplist2? Is the point of your query to update records in
tbl_keeplist2 only if there's a matching record in tbl_moddate? If so, I
think you can probably solve your problem easily using a subquery:

UPDATE  tbl_keeplist2
SET status = 'R'
WHERE   ID IN
(SELECT ID
 FROM tbl_moddate)

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192006
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ORDER BY on a query within a query

2005-01-27 Thread Greg Morphis
Can you show us what Oracle is getting? the query from the debug output?



On Thu, 27 Jan 2005 14:27:14 -0400, daniel kessler <[EMAIL PROTECTED]> wrote:
> >I can't speak for Oracle specifically, but in general, the outer select
> >is not required to return the results in the same order as the
> >subselect.  Try moving the ORDER BY to the outer select and see if that
> >works.  I'm far from sure this is your problem, but it's certainly
> >something to try.
> 
> That didn't seem to work.  I replaced from the inner ORDER BY on-down with:
> 
>  ORDER BY UPPER(agency)
>  ) WHERE r >=  cfsqltype="cf_sql_integer"> AND r <=  cfsqltype="cf_sql_integer">
>ORDER BY UPPER(agency)
> 
> I also tried the ORDER BY just on the outside query.
> 
> Both gave the same results as I had previously.
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192006
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Stripping variables from CF templates?

2005-01-27 Thread Ben Doom
What CF version?

Also, if you want to end up with really good solutions, I'd move this to 
the CF-Regex list.  It's fairly low traffic, so nearly every question 
gets hammered with good answers.

--Ben

Nick Baker wrote:
> Any hints on how to create a regex to extract the complete session.XXX or 
> server.mydomain.XXX would be appreciated?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192004
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ORDER BY on a query within a query

2005-01-27 Thread Deanna Schneider
Are you testing this query in oracle, or just from your cf output? Also, are 
you expecting that Oracle will order the numbers in the varchar2 field as 
numbers? It won't happen. Varchar2 fields are ordered by ascii or unicode 
character number, I believe, which is why they're case sensitive.

Try running just the inner query in an oracle client. Get the results you 
expect? No? Then, somethings going on there.

- Original Message - 
From: "daniel kessler" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, January 27, 2005 12:27 PM
Subject: Re: ORDER BY on a query within a query


> >I can't speak for Oracle specifically, but in general, the outer select
>>is not required to return the results in the same order as the
>>subselect.  Try moving the ORDER BY to the outer select and see if that
>>works.  I'm far from sure this is your problem, but it's certainly
>>something to try.
>
> That didn't seem to work.  I replaced from the inner ORDER BY on-down 
> with:
>
>  ORDER BY UPPER(agency)
>  ) WHERE r >=  cfsqltype="cf_sql_integer"> AND r <=  cfsqltype="cf_sql_integer">
> ORDER BY UPPER(agency)
>
> I also tried the ORDER BY just on the outside query.
>
> Both gave the same results as I had previously.
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192003
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Has anyone done anything like this? File manipulation.

2005-01-27 Thread Jeff Waris
Thanks all..

Meta Refresh and Cfdirectory with a specific file filter worked like a
charm!

Jeff


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192002
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Tony Weeg
sup adrock

whats ur beef with fckedit?

i got it working nice for a client...

tw


On Thu, 27 Jan 2005 11:15:55 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> Russ, all three editors are cross platform.  I use all three on
> Windows and OSX, using IE and FireFox.  I don't think any of them work
> in Safari, but who uses that?  ;)
> 
> Adam, I haven't developed with FCKEditor, only used it as a "user".
> However, I've mostly heard good things about it.  The other two I do
> actively use in projects I develop, and they're pretty slick.
> HTMLArea is more complicated than TinyMCE, but consequently more
> flexible.
> 
> cheers,
> barneyb
> 
> On Thu, 27 Jan 2005 12:40:50 -0500 (EST), [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> > Apologies to the list for massive emails--appears I've misread the docs on
> > HTMLArea and that it WILL work for me...
> >
> > My bad.
> >
> > > HTMLArea appears to be Windows only solution?  No worries, just adding
> > > clarification that I need something cross-platform (win and lin), so was
> > > hoping to work within a CFMX solution as opposed to a javascript solution
> > > that has dependencies.  Based upon other comments, I'll take a look at
> > > TinyMCE now, but hope my additional info helpse.
> > >
> > > Thanks!
> > >
> > > Russ
> > >
> > >> On Thu, 27 Jan 2005 10:07:42 -0800, Barney Boisvert
> > >> <[EMAIL PROTECTED]>
> > >> wrote:
> > >>> FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical order) are
> > >>> three free options that I've used and liked.  All have different
> > >>> characterisics, but any would probably searve as a suitable base point
> > >>> for your project.
> > >>>
> > >>> cheers,
> > >>> barneyb
> > >>>
> > >>> On Thu, 27 Jan 2005 11:45:06 -0500 (EST), [EMAIL PROTECTED]
> > >>> <[EMAIL PROTECTED]> wrote:
> > >>> > I'll apologize in advance; the HoF server is really, really dragging
> > >>> on me
> > >>> > today, so my attempts at a search on the topic were pretty...  Well,
> > >>> I
> > >>> > didn't get very far.
> > >>> >
> > >>> > That said, I've been searching for a WYSIWYG Rich Text Area Editor
> > >>> that
> > >>> > allows users to control the normal aspects and allows for the
> > >>> uploading of
> > >>> > images with the content, with the controls at my discretion.
> > >>> >
> > >>> > I've checked into ActivEdit--and it looks great, to be honest.
> > >>> Perhaps a
> > >>> > little steep for my "personal project" budget, but in the end that
> > >>> may
> > >>> > appear to be the best solution.
> > >>> >
> > >>> > Does anyone have any recommedations or even any guidance to help me
> > >>> out
> > >>> > with this?  I'm not opposed to a "build my own" solution, assuming it
> > >>> > comes with a tutorial and a paint-by-numbers guide. (that's tongue in
> > >>> > cheeck)
> > >>> >
> > >>> > Thanks in advance,
> > >>> >
> > >>> > Russ
> > >>> >
> > >>>
> > >>> --
> > >>> Barney Boisvert
> > >>> [EMAIL PROTECTED]
> > >>> 360.319.6145
> > >>> http://www.barneyb.com/
> > >>>
> > >>> Got Gmail? I have 6 invites.
> > >>>
> > >>>
> > >>
> > >>
> > >
> > >
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192001
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Stripping variables from CF templates?

2005-01-27 Thread Nick Baker
Ben,

One of the reasons I was considering the approach of a variable map was to 
get into understand the scheme. My thought process seems to grasp the 
overall picture better when I can see how variables are used. Plus makes 
debugging strategy more meaning.

Your suggestions using regex and Paul's suggestion of searching all files 
with CFFile makes a lot of sense. My regex is limited. Finding the scope 
part of session.XXX or server.mydomain.XXX is within my capabilities. It is 
extracting the entire variable that I am struggling. If we could take that 
one step further and also extract how the variable was used, e.g., cfset or 
?, then we would have created a great post documenting tool ;-)

Any hints on how to create a regex to extract the complete session.XXX or 
server.mydomain.XXX would be appreciated?

Nick


At 01:01 PM 1/27/2005, you wrote:
>So, if I'm reading this right, what you're looking for is a way to
>compare variable use across templates, particularly where they might be
>conflicting in/with background processing, right?  Assuming so, here's
>where I'd start
>
>Since the background processes are most likely to be having issues with
>shared scopes, I'd start by adding a separate template that just dumps
>the application and server scopes, then doing a find across the
>application for all instances of each of the variables in those scopes.
>
>If that didn't lead me to the problems, I'd look for unscoped variables.
>   This is going to be a PITA, but the basic idea (at least what I've
>thought of) is to first look for all hashed values in the code, then
>look in all the  tags.  Yeah, annoying.  Personally, I'd create a
>copy of the code and do some serious reductions on it using regex, but
>I'm a regex junkie.  :-)  Any way you slice it, this is going to be a
>royal pain.
>
>HTH.  If there's more I can help with, feel free to let me know.
>
>--Ben
>
>Nick Baker wrote:
> > Ben,
> >
> > The reason is to get a good pic of the variable usage strategy. I 
> inherited
> > some fairly large CF code that is a little buggy. There is some background
> > event processing going on and appears a few variables are possibly being
> > stepped on. The variable naming conventions makes me suspect there may be
> > duplicate uses of variable names.
> >
> > CFDump maybe my best option, but calling templates could affect ongoing
> > background events.
> >
> > Nick
> >
> > At 11:06 AM 1/27/2005, you wrote:
> >
> >>You could always cfdump the various scopes at the bottom of the page...
> >>
> >>I'm not sure what your intent is, though.  What are you trying to do
> >>with this information?
> >>
> >>--Ben
> >>
> >>Nick Baker wrote:
> >>
> >>>How can you strip variables such as session and server variables from
> >>>existing code?  Leaving a map of variables used by template.
> >>>
> >>>Unfortunately, all of the variables were not initialized in 
> CFAPPLICATIONS.
> >>>
> >>>Any tools or snippets that can do that?
> >>>
> >>>Thanks,
> >>>
> >>>Nick
> >>>
> >>>
> >>>
> >>
> >>
> >
> >
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192000
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ORDER BY on a query within a query

2005-01-27 Thread daniel kessler
>I can't speak for Oracle specifically, but in general, the outer select 
>is not required to return the results in the same order as the 
>subselect.  Try moving the ORDER BY to the outer select and see if that 
>works.  I'm far from sure this is your problem, but it's certainly 
>something to try.

That didn't seem to work.  I replaced from the inner ORDER BY on-down with:

  ORDER BY UPPER(agency)
  ) WHERE r >=  AND r <= 
ORDER BY UPPER(agency)

I also tried the ORDER BY just on the outside query.

Both gave the same results as I had previously.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191999
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Scott Stroz
I have been using the beta version of fckEditor 2, and its pretty damn good.


On Thu, 27 Jan 2005 11:45:06 -0500 (EST), [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> I'll apologize in advance; the HoF server is really, really dragging on me
> today, so my attempts at a search on the topic were pretty...  Well, I
> didn't get very far.
> 
> That said, I've been searching for a WYSIWYG Rich Text Area Editor that
> allows users to control the normal aspects and allows for the uploading of
> images with the content, with the controls at my discretion.
> 
> I've checked into ActivEdit--and it looks great, to be honest.  Perhaps a
> little steep for my "personal project" budget, but in the end that may
> appear to be the best solution.
> 
> Does anyone have any recommedations or even any guidance to help me out
> with this?  I'm not opposed to a "build my own" solution, assuming it
> comes with a tutorial and a paint-by-numbers guide. (that's tongue in
> cheeck)
> 
> Thanks in advance,
> 
> Russ
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191998
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Left join works in Access NOT in SQL 7

2005-01-27 Thread Ryan Roskilly
This ended up working 

UPDATEtbl_keeplist2
SET  tbl_keeplist2.status = 'D'
FROM tbl_keeplist2
LEFT JOIN tbl_keeplist2_daily ON 
tbl_keeplist2.ID = 
tbl_keeplist2_daily.ID
WHEREtbl_keeplist2_daily.status = 'P'
OR tbl_keeplist2_daily.ID Is Null   
tbl_keeplist2_daily may or may not still have the original ID's in it. 

Now I have this original query in Access

UPDATE  tbl_keeplist2 
RIGHT JOIN tbl_moddate ON tbl_keeplist2.ID = tbl_moddate.ID
SET tbl_keeplist2.status = 'R'

Which does not work so I tried this in SQL server


UPDATE  tbl_keeplist2
SET tbl_keeplist2.status = 'R'
FROMtbl_keeplist2
RIGHT JOIN tbl_moddate ON tbl_keeplist2.ID = tbl_moddate.ID

Which returns

UPDATE over nullable side of outer join query on table 'tbl_keeplist2'.




>> Entering () around that just gave me another syntax error. 
>
>I think you'll have to do your join within a subquery, like this:
>
>UPDATE tbl_keeplist2
>SETstatus = 'D'
>WHERE  ID IN
>   (SELECT ID
>FROM   tbl_keeplist2_daily
>WHERE  status = 'P')
>
>I'm not sure why you'd have a possibility of a NULL in the ID column of
>tbl_keeplist2_daily, since you couldn't join against tbl_keeplist2 in that
>case.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Software provides the highest caliber vendor-authorized 
>instruction at our training centers in Washington DC, Atlanta, 
>Chicago, Baltimore, Northern Virginia, or on-site at your location. 
>Visit http://training.figleaf.com/ for more information!

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191997
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT: PHP equivalent of cfhtmlhead

2005-01-27 Thread Figy, Kam
You could hack around something like that with ...


...



...



#header#
#body#


I dunno if PHP has anything analogous to cfsavecontent but if so that
might be a good option. It modularizes your layout too, which is nice.

kam 

-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 25, 2005 1:57 PM
To: CF-Talk
Subject: RE: OT: PHP equivalent of cfhtmlhead

> -Original Message-
> From: Figy, Kam [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 25, 2005 4:48 PM
> To: CF-Talk
> Subject: RE: OT: PHP equivalent of cfhtmlhead
> 
> It's also convenient if you want to have a global header include but 
> have page titles on a per-page basis.

I use CFHTMLHEAD a lot - but I do wish there was a more generic
processing for it.

I'd like to be able to set an "include point" someplace on the page then
later throw some content to it.

For example I grab a tickcount from the beginning of application.cfm and
at the end of OnRequestEnd.cfm.  I then dump that to the output.  But of
course that information is outside the HTML tags (since I use Custom
Tags to include Headers and Footers outside of the auto-includes).

It would be nice to set a place for that information: something like:



And then later use something like:



(Or something like that)

This is clearly what CFHTMLHEAD is doing already - I'd just like to make
it more generic.

Jim Davis







~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191996
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Barney Boisvert
Russ, all three editors are cross platform.  I use all three on
Windows and OSX, using IE and FireFox.  I don't think any of them work
in Safari, but who uses that?  ;)

Adam, I haven't developed with FCKEditor, only used it as a "user". 
However, I've mostly heard good things about it.  The other two I do
actively use in projects I develop, and they're pretty slick. 
HTMLArea is more complicated than TinyMCE, but consequently more
flexible.

cheers,
barneyb

On Thu, 27 Jan 2005 12:40:50 -0500 (EST), [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Apologies to the list for massive emails--appears I've misread the docs on
> HTMLArea and that it WILL work for me...
> 
> My bad.
> 
> > HTMLArea appears to be Windows only solution?  No worries, just adding
> > clarification that I need something cross-platform (win and lin), so was
> > hoping to work within a CFMX solution as opposed to a javascript solution
> > that has dependencies.  Based upon other comments, I'll take a look at
> > TinyMCE now, but hope my additional info helpse.
> >
> > Thanks!
> >
> > Russ
> >
> >> On Thu, 27 Jan 2005 10:07:42 -0800, Barney Boisvert
> >> <[EMAIL PROTECTED]>
> >> wrote:
> >>> FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical order) are
> >>> three free options that I've used and liked.  All have different
> >>> characterisics, but any would probably searve as a suitable base point
> >>> for your project.
> >>>
> >>> cheers,
> >>> barneyb
> >>>
> >>> On Thu, 27 Jan 2005 11:45:06 -0500 (EST), [EMAIL PROTECTED]
> >>> <[EMAIL PROTECTED]> wrote:
> >>> > I'll apologize in advance; the HoF server is really, really dragging
> >>> on me
> >>> > today, so my attempts at a search on the topic were pretty...  Well,
> >>> I
> >>> > didn't get very far.
> >>> >
> >>> > That said, I've been searching for a WYSIWYG Rich Text Area Editor
> >>> that
> >>> > allows users to control the normal aspects and allows for the
> >>> uploading of
> >>> > images with the content, with the controls at my discretion.
> >>> >
> >>> > I've checked into ActivEdit--and it looks great, to be honest.
> >>> Perhaps a
> >>> > little steep for my "personal project" budget, but in the end that
> >>> may
> >>> > appear to be the best solution.
> >>> >
> >>> > Does anyone have any recommedations or even any guidance to help me
> >>> out
> >>> > with this?  I'm not opposed to a "build my own" solution, assuming it
> >>> > comes with a tutorial and a paint-by-numbers guide. (that's tongue in
> >>> > cheeck)
> >>> >
> >>> > Thanks in advance,
> >>> >
> >>> > Russ
> >>> >
> >>>
> >>> --
> >>> Barney Boisvert
> >>> [EMAIL PROTECTED]
> >>> 360.319.6145
> >>> http://www.barneyb.com/
> >>>
> >>> Got Gmail? I have 6 invites.
> >>>
> >>>
> >>
> >>
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191995
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ORDER BY on a query within a query

2005-01-27 Thread Ben Doom
I can't speak for Oracle specifically, but in general, the outer select 
is not required to return the results in the same order as the 
subselect.  Try moving the ORDER BY to the outer select and see if that 
works.  I'm far from sure this is your problem, but it's certainly 
something to try.

--Ben

Daniel Kessler wrote:
> I have a query in a query that grabs all the hits and then returns 
> the first 10 (thanks again folks!).  It does an ORDER BY on agency 
> which is an Oracle varchar2(100).  The ORDER BY is in the first query 
> and the second query just grabs 10 at a time.  Largely it does this 
> correctly, but I've noticed some oddities with the ordering.  First, 
> it seems to order caps and lowercase separately like a1, a2, A1, A2 
> and it seems order them within the 10 instead of within the whole (I 
> think).
> Also, if you go here: 
> http://hhp.umd.edu/studentservices/internships.cfm   and click search 
> for a blank search, it provides a search list with agencies 1-9 begin 
> with an "a" while agency 10 begins with a "d".  Click on page 2 and 
> agencies 11-20 begin with  an "a".I added an UPPER to the inner 
> query ORDER BY to try and fix it, but it didn't. Seems right to me 
> though.
> 
> Here's the query
> 
>  SELECT *
>  FROM
>  (
>SELECT 
> d.service_population,agency,city,state,salary_status,int_agency_id, 
> ROWNUM AS r, COUNT(agency) OVER() AS rowcount
>FROM internships d
>WHERE 1=1
>
>  AND UPPER(agency) LIKE  value="%#UCase(Form.Agency)#%" cfsqltype="cf_sql_varchar">
>  
>  
>  AND UPPER(city) LIKE  value="%#UCase(Form.city)#%" cfsqltype="cf_sql_varchar">
>  
>ORDER BY UPPER(agency)
>  ) WHERE r >=  cfsqltype="cf_sql_integer"> AND r <=  value="#url.end_num#" cfsqltype="cf_sql_integer">


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191994
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Has anyone done anything like this? File manipulation.

2005-01-27 Thread Ben Doom
I do that a lot with things that aren't easily scanned as "xx% done".  A 
page to manually re-index a Verity collection, for example.  I write a 
"Be patient, don't hit cancel or you screw the pooch" message, cfflush 
it, and when the processing is done, I use JS to hide that message and 
display an "all done!" message.  Since this is being done background, 
and not in the context of the page call, you can't take exactly the same 
approach, but you can still continue to let the user know that the 
system is working.

--Ben

Mark Drew wrote:
> Does the file increase tho? most of these functions create the file
> (0bytes) as the handle, then do the processing in memory and when
> finished dump the result into a file and close the file handle.
> 
> so you will have from 0 to hero but no inbetween
> 
> Is this what you would use? not a progress bar but a "still doing" bar?
> 
> MD
> 
> 
> On Thu, 27 Jan 2005 11:51:44 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> 
>>If filesize==0, push a page with a meta tag redirect or a JS timeout
>>that reloads the page after some number of seconds.  If filesize>0, push
>>the contents instead.
>>
>>--Ben
>>
>>Jeff Waris wrote:
>>
>>>I kick a process off to create a report that is converted to a PDF using
>>>CFEXECUTE. The report is not created instantaneously and may take some time
>>>depending how many pages there are. Once created, the PDF sits in a
>>>directory. This part is working fine.
>>>
>>>As the report starts to run. It creates a 0 byte PDF file. It then sits in
>>>the directory at 0 bytes until it finishes, then displays a file size. The
>>>process takes about .25-.5 second per page and it wouldn't be uncommon to
>>>have a 200 page report. So the existence of this PDF could take upwards of a
>>>minute to show.
>>>
>>>What I would like to do is spawn a new window and within that window keep
>>>checking for the existence of that file and once the file is in the
>>>directory and more than 0 bytes to  to the PDF and display it
>>>in the new window or timeout after a certain period of time and display a
>>>try again or give the option to start the creation process over.
>>>
>>>Has anyone done anything like this? I know that you would use cfdirectory
>>>for a lot of it BUT am unsure how to do the checking/timeout loop properly.
>>>
>>>Thanks.
>>>Jeff
>>>
>>>
>>>
>>
>>
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191993
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Stripping variables from CF templates?

2005-01-27 Thread Ben Doom
So, if I'm reading this right, what you're looking for is a way to 
compare variable use across templates, particularly where they might be 
conflicting in/with background processing, right?  Assuming so, here's 
where I'd start

Since the background processes are most likely to be having issues with 
shared scopes, I'd start by adding a separate template that just dumps 
the application and server scopes, then doing a find across the 
application for all instances of each of the variables in those scopes.

If that didn't lead me to the problems, I'd look for unscoped variables. 
  This is going to be a PITA, but the basic idea (at least what I've 
thought of) is to first look for all hashed values in the code, then 
look in all the  tags.  Yeah, annoying.  Personally, I'd create a 
copy of the code and do some serious reductions on it using regex, but 
I'm a regex junkie.  :-)  Any way you slice it, this is going to be a 
royal pain.

HTH.  If there's more I can help with, feel free to let me know.

--Ben

Nick Baker wrote:
> Ben,
> 
> The reason is to get a good pic of the variable usage strategy. I inherited 
> some fairly large CF code that is a little buggy. There is some background 
> event processing going on and appears a few variables are possibly being 
> stepped on. The variable naming conventions makes me suspect there may be 
> duplicate uses of variable names.
> 
> CFDump maybe my best option, but calling templates could affect ongoing 
> background events.
> 
> Nick
> 
> At 11:06 AM 1/27/2005, you wrote:
> 
>>You could always cfdump the various scopes at the bottom of the page...
>>
>>I'm not sure what your intent is, though.  What are you trying to do
>>with this information?
>>
>>--Ben
>>
>>Nick Baker wrote:
>>
>>>How can you strip variables such as session and server variables from
>>>existing code?  Leaving a map of variables used by template.
>>>
>>>Unfortunately, all of the variables were not initialized in CFAPPLICATIONS.
>>>
>>>Any tools or snippets that can do that?
>>>
>>>Thanks,
>>>
>>>Nick
>>>
>>>
>>>
>>
>>
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191992
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread russ
Apologies to the list for massive emails--appears I've misread the docs on
HTMLArea and that it WILL work for me...

My bad.

> HTMLArea appears to be Windows only solution?  No worries, just adding
> clarification that I need something cross-platform (win and lin), so was
> hoping to work within a CFMX solution as opposed to a javascript solution
> that has dependencies.  Based upon other comments, I'll take a look at
> TinyMCE now, but hope my additional info helpse.
>
> Thanks!
>
> Russ
>
>> On Thu, 27 Jan 2005 10:07:42 -0800, Barney Boisvert
>> <[EMAIL PROTECTED]>
>> wrote:
>>> FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical order) are
>>> three free options that I've used and liked.  All have different
>>> characterisics, but any would probably searve as a suitable base point
>>> for your project.
>>>
>>> cheers,
>>> barneyb
>>>
>>> On Thu, 27 Jan 2005 11:45:06 -0500 (EST), [EMAIL PROTECTED]
>>> <[EMAIL PROTECTED]> wrote:
>>> > I'll apologize in advance; the HoF server is really, really dragging
>>> on me
>>> > today, so my attempts at a search on the topic were pretty...  Well,
>>> I
>>> > didn't get very far.
>>> >
>>> > That said, I've been searching for a WYSIWYG Rich Text Area Editor
>>> that
>>> > allows users to control the normal aspects and allows for the
>>> uploading of
>>> > images with the content, with the controls at my discretion.
>>> >
>>> > I've checked into ActivEdit--and it looks great, to be honest.
>>> Perhaps a
>>> > little steep for my "personal project" budget, but in the end that
>>> may
>>> > appear to be the best solution.
>>> >
>>> > Does anyone have any recommedations or even any guidance to help me
>>> out
>>> > with this?  I'm not opposed to a "build my own" solution, assuming it
>>> > comes with a tutorial and a paint-by-numbers guide. (that's tongue in
>>> > cheeck)
>>> >
>>> > Thanks in advance,
>>> >
>>> > Russ
>>> >
>>>
>>> --
>>> Barney Boisvert
>>> [EMAIL PROTECTED]
>>> 360.319.6145
>>> http://www.barneyb.com/
>>>
>>> Got Gmail? I have 6 invites.
>>>
>>>
>>
>>
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191991
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread russ
Barney--

HTMLArea appears to be Windows only solution?  No worries, just adding
clarification that I need something cross-platform (win and lin), so was
hoping to work within a CFMX solution as opposed to a javascript solution
that has dependencies.  Based upon other comments, I'll take a look at
TinyMCE now, but hope my additional info helpse.

Thanks!

Russ

> On Thu, 27 Jan 2005 10:07:42 -0800, Barney Boisvert <[EMAIL PROTECTED]>
> wrote:
>> FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical order) are
>> three free options that I've used and liked.  All have different
>> characterisics, but any would probably searve as a suitable base point
>> for your project.
>>
>> cheers,
>> barneyb
>>
>> On Thu, 27 Jan 2005 11:45:06 -0500 (EST), [EMAIL PROTECTED]
>> <[EMAIL PROTECTED]> wrote:
>> > I'll apologize in advance; the HoF server is really, really dragging
>> on me
>> > today, so my attempts at a search on the topic were pretty...  Well, I
>> > didn't get very far.
>> >
>> > That said, I've been searching for a WYSIWYG Rich Text Area Editor
>> that
>> > allows users to control the normal aspects and allows for the
>> uploading of
>> > images with the content, with the controls at my discretion.
>> >
>> > I've checked into ActivEdit--and it looks great, to be honest.
>> Perhaps a
>> > little steep for my "personal project" budget, but in the end that may
>> > appear to be the best solution.
>> >
>> > Does anyone have any recommedations or even any guidance to help me
>> out
>> > with this?  I'm not opposed to a "build my own" solution, assuming it
>> > comes with a tutorial and a paint-by-numbers guide. (that's tongue in
>> > cheeck)
>> >
>> > Thanks in advance,
>> >
>> > Russ
>> >
>>
>> --
>> Barney Boisvert
>> [EMAIL PROTECTED]
>> 360.319.6145
>> http://www.barneyb.com/
>>
>> Got Gmail? I have 6 invites.
>>
>>
>
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191990
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Has anyone done anything like this? File manipulation.

2005-01-27 Thread Mark Drew
I think the solution here as has been mentinoed is to do a page that
refreshes to itself (meta refresh) and checks a) the existence of the
file, and b) the size of the file

if the size is bigger than 0, then stop the refresh and show a lovely
"Ping! Cooked!" message (sound is optional)

MD


On Thu, 27 Jan 2005 13:11:02 -0500, Jeff Waris <[EMAIL PROTECTED]> wrote:
> Mark,
> 
> That's exactly what it does, Creates the 0 byte file, processes and then
> dumps the full contents to a file.. NO in between. So yeah, what I am
> looking for is a "Still Doing" bar.
> 
> Jeff
> 
> 
> > -Original Message-
> > From: Mark Drew [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, January 27, 2005 12:41 PM
> > To: CF-Talk
> > Subject: Re: Has anyone done anything like this? File manipulation.
> >
> >
> > Does the file increase tho? most of these functions create the file
> > (0bytes) as the handle, then do the processing in memory and
> > when finished dump the result into a file and close the file handle.
> >
> > so you will have from 0 to hero but no inbetween
> >
> > Is this what you would use? not a progress bar but a "still
> > doing" bar?
> >
> > MD
> >
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191989
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Error using MSXMLDOM

2005-01-27 Thread Mike Nicholls
You're going to kick yourself ;-)
It looks like you forgot to double up the quotes in your XPath expression to
escape them from CF.  Try this: 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, 28 January 2005 5:09 a.m.
To: CF-Talk
Subject: Error using MSXMLDOM

 I'm experimenting with using the MSXMLDOM. I getting an error I cant get
around..


Here's the code








 



And here's the error

Invalid CFML construct found on line 20 at column 89.  
ColdFusion was looking at the following text:
#

The CFML compiler was processing:an expression beginning with
"objXMLDOM.SelectSingleNode", on line 20, column 35.This message is usually
caused by a problem in the expressions structure.

a CFSET tag beginning on line 20, column 18.  
  
The error occurred in
C:\inetpub\wwwroot\Docwf\StandardParagraphs\act_KillPG.cfm: line 20
Called from C:\inetpub\wwwroot\Docwf\StandardParagraphs\fbx_Switch.cfm: line
55
Called from C:\inetpub\wwwroot\Docwf\fbx_fusebox30_CF50.cfm: line 241
Called from C:\inetpub\wwwroot\Docwf\fbx_fusebox30_CF50.cfm: line 1
Called from C:\inetpub\wwwroot\Docwf\fbx_fusebox30_CF50.cfm: line 1
Called from C:\inetpub\wwwroot\Docwf\index.cfm: line 37
 
18 :
19 : 
20 :
21 :
22 : 



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.0 - Release Date: 01/27/2005
 





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191988
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Left join works in Access NOT in SQL 7

2005-01-27 Thread Dave Watts
> Entering () around that just gave me another syntax error. 
> Another forum gave me the following but it stats
> 
> Invalid object name 'tbl_keeplist2_daily'.
> 
> UPDATE tbl_keeplist2 
> SET   status = 'D'
> FROM tbl_keeplist2
> LEFT JOIN tbl_keeplist2_daily ON 
> tbl_keeplist2.ID = tbl_keeplist2_daily.ID
> WHERE tbl_keeplist2_daily.status = 'P'
> OR tbl_keeplist2_daily.ID Is Null

I think you'll have to do your join within a subquery, like this:

UPDATE  tbl_keeplist2
SET status = 'D'
WHERE   ID IN
(SELECT ID
 FROM   tbl_keeplist2_daily
 WHERE  status = 'P')

I'm not sure why you'd have a possibility of a NULL in the ID column of
tbl_keeplist2_daily, since you couldn't join against tbl_keeplist2 in that
case.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191987
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


ORDER BY on a query within a query

2005-01-27 Thread Daniel Kessler
I have a query in a query that grabs all the hits and then returns 
the first 10 (thanks again folks!).  It does an ORDER BY on agency 
which is an Oracle varchar2(100).  The ORDER BY is in the first query 
and the second query just grabs 10 at a time.  Largely it does this 
correctly, but I've noticed some oddities with the ordering.  First, 
it seems to order caps and lowercase separately like a1, a2, A1, A2 
and it seems order them within the 10 instead of within the whole (I 
think).
Also, if you go here: 
http://hhp.umd.edu/studentservices/internships.cfm   and click search 
for a blank search, it provides a search list with agencies 1-9 begin 
with an "a" while agency 10 begins with a "d".  Click on page 2 and 
agencies 11-20 begin with  an "a".I added an UPPER to the inner 
query ORDER BY to try and fix it, but it didn't. Seems right to me 
though.

Here's the query

 SELECT *
 FROM
 (
   SELECT 
d.service_population,agency,city,state,salary_status,int_agency_id, 
ROWNUM AS r, COUNT(agency) OVER() AS rowcount
   FROM internships d
   WHERE 1=1
   
 AND UPPER(agency) LIKE 
 
 
 AND UPPER(city) LIKE 
 
   ORDER BY UPPER(agency)
 ) WHERE r >=  AND r <= 
-- 
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191986
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Left join works in Access NOT in SQL 7

2005-01-27 Thread Ryan Roskilly
Entering () around that just gave me another syntax error. Another forum gave 
me the following but it stats

Invalid object name 'tbl_keeplist2_daily'.

UPDATE tbl_keeplist2 
SET   status = 'D'
FROM tbl_keeplist2
LEFT JOIN tbl_keeplist2_daily ON 
tbl_keeplist2.ID = tbl_keeplist2_daily.ID
WHERE tbl_keeplist2_daily.status = 'P'
OR tbl_keeplist2_daily.ID Is Null


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191985
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Robert Orlini
Thanks Ian, Randy, and Michael!

Your suggestions combined helped me. Now I understand (and better appreciate) 
using  especially since it also makes things more secure.

This line worked: 


Robert O.

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 1:06 PM
To: CF-Talk
Subject: RE: OT SQL date/time default


That is probably your problem.  I presume that form.formdate is a text field.  
And a empty text field is '' which is completely different then NULL.  So you 
are inserting a value into the date field, a value of an empty string, but a 
value none the less.

For situations like this and many other good reasons you should read up on the 
 tag.

To fix your date issue trying changing this line

...'#form.formdate#',

To



Now looking at your code example, you seem to be inserting your date as a 
string, not a date?  Is the field in the database a date field or a 
char|varchar field?

PS you should change your other inserts to queryparams as well.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning



...-Original Message-
...From: Robert Orlini [mailto:[EMAIL PROTECTED]
...Sent: Thursday, January 27, 2005 9:56 AM
...To: CF-Talk
...Subject: RE: OT SQL date/time default
...
...Ian, Randy,
...
...Just a plain insert and I fear that is the problem...only I don't work
...with CF enough to know the coding tips.
...
...Here it is below:
...
...
...Insert into off
...(
...formdate,
...admin,
...side1collectionsdate,
...side2collectionsdate,
...side3collectionsdate,
...side4collectionsdate,
...side5collectionsdate
...)
...VALUES
...(
...'#form.formdate#',
...'#form.admin#',
...'#form.side1collectionsdate#',
...'#form.side2collectionsdate#',
...'#form.side3collectionsdate#',
...'#form.side4collectionsdate#',
...'#form.side5collectionsdate#'
...)
...

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191984
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Adrocknaphobia
Barney,

I'm using FCKEditor right now, which I'm not happy with at all. (Using
the latest release, not the current beta). How clean is HTMLArea and
TinyMCE HTML code thats generated? I only want to selected base HTML
tags like p, h1, etc. Which mean there needs to be some sort of Word
pasted html cleaning.

Just wondering what your opions are?

-Adam


On Thu, 27 Jan 2005 10:07:42 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical order) are
> three free options that I've used and liked.  All have different
> characterisics, but any would probably searve as a suitable base point
> for your project.
> 
> cheers,
> barneyb
> 
> On Thu, 27 Jan 2005 11:45:06 -0500 (EST), [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> > I'll apologize in advance; the HoF server is really, really dragging on me
> > today, so my attempts at a search on the topic were pretty...  Well, I
> > didn't get very far.
> >
> > That said, I've been searching for a WYSIWYG Rich Text Area Editor that
> > allows users to control the normal aspects and allows for the uploading of
> > images with the content, with the controls at my discretion.
> >
> > I've checked into ActivEdit--and it looks great, to be honest.  Perhaps a
> > little steep for my "personal project" budget, but in the end that may
> > appear to be the best solution.
> >
> > Does anyone have any recommedations or even any guidance to help me out
> > with this?  I'm not opposed to a "build my own" solution, assuming it
> > comes with a tutorial and a paint-by-numbers guide. (that's tongue in
> > cheeck)
> >
> > Thanks in advance,
> >
> > Russ
> >
> 
> --
> Barney Boisvert
> [EMAIL PROTECTED]
> 360.319.6145
> http://www.barneyb.com/
> 
> Got Gmail? I have 6 invites.
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191983
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Calvin Ward
HTMLArea is really nice.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 11:45 AM
To: CF-Talk
Subject: WYSIWYG Rich Text Area Editor

I'll apologize in advance; the HoF server is really, really dragging on me
today, so my attempts at a search on the topic were pretty...  Well, I
didn't get very far.

That said, I've been searching for a WYSIWYG Rich Text Area Editor that
allows users to control the normal aspects and allows for the uploading of
images with the content, with the controls at my discretion.

I've checked into ActivEdit--and it looks great, to be honest.  Perhaps a
little steep for my "personal project" budget, but in the end that may
appear to be the best solution.

Does anyone have any recommedations or even any guidance to help me out
with this?  I'm not opposed to a "build my own" solution, assuming it
comes with a tutorial and a paint-by-numbers guide. (that's tongue in
cheeck)

Thanks in advance,

Russ




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191982
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ListToArray a multi form drop-down

2005-01-27 Thread daniel kessler
I tried using ListChangeDelims but couldn't get it to do what I needed so I 
went to replacing chars.  Now I have it as:

And when I go to display item 4 for any reason or query with it, I change it 
then with a replace(the_item,"|",",","All")
That was the ugly answer but it worked.

Thanks everyone.

> I would replace all commas in the values by pipe characters, then have 
> a comma separted list...
> Then in the template processing the form, replace the comma delimiter 
> by another character,
> and all pipes back to commas.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191981
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Left join works in Access NOT in SQL 7

2005-01-27 Thread Adkins, Randy
If I am correct, you need to surround the JOIN statement with ( ) 

Something like:
UPDATE tbl_keeplist2 
( LEFT JOIN tbl_keeplist2_daily ON tbl_keeplist2.ID =
tbl_keeplist2_daily.ID )

Not a true SQL Guru but I think that is proper and would be read by both
SQL and Access

-Original Message-
From: Ryan Roskilly [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 12:14 PM
To: CF-Talk
Subject: Left join works in Access NOT in SQL 7

This has worked for years in Access

UPDATE tbl_keeplist2 
LEFT JOIN tbl_keeplist2_daily ON 
tbl_keeplist2.ID = tbl_keeplist2_daily.ID

SET   tbl_keeplist2.status = 'D'

WHERE tbl_keeplist2_daily.status = 'P'
OR tbl_keeplist2_daily.ID Is Null

But no luck in SQL 7 I get the following error.

Incorrect syntax near the keyword 'LEFT'.

Any ideas?



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191980
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Left join works in Access NOT in SQL 7

2005-01-27 Thread Ryan Roskilly
This has worked for years in Access

UPDATE tbl_keeplist2 
LEFT JOIN tbl_keeplist2_daily ON 
tbl_keeplist2.ID = tbl_keeplist2_daily.ID

SET   tbl_keeplist2.status = 'D'

WHERE tbl_keeplist2_daily.status = 'P'
OR tbl_keeplist2_daily.ID Is Null

But no luck in SQL 7 I get the following error.

Incorrect syntax near the keyword 'LEFT'.

Any ideas?

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191979
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Has anyone done anything like this? File manipulation.

2005-01-27 Thread Jeff Waris
Mark,

That's exactly what it does, Creates the 0 byte file, processes and then
dumps the full contents to a file.. NO in between. So yeah, what I am
looking for is a "Still Doing" bar. 

Jeff
 

 

> -Original Message-
> From: Mark Drew [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, January 27, 2005 12:41 PM
> To: CF-Talk
> Subject: Re: Has anyone done anything like this? File manipulation.
> 
> 
> Does the file increase tho? most of these functions create the file
> (0bytes) as the handle, then do the processing in memory and 
> when finished dump the result into a file and close the file handle.
> 
> so you will have from 0 to hero but no inbetween
> 
> Is this what you would use? not a progress bar but a "still 
> doing" bar?
> 
> MD
> 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191978
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Stripping variables from CF templates?

2005-01-27 Thread Paul
If the variables are scoped properly in the code (big if, I know) you could
read the cfm files using CFFILE, search for the various scope prefixes
within the code, and output a report for each template. Maybe not the best
solution if the code wasn't written well to begin with, but it could be
automated and wouldn't affect the background events.

-Paul

-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 10:54 AM
To: CF-Talk
Subject: Re: Stripping variables from CF templates?

Ben,

The reason is to get a good pic of the variable usage strategy. I inherited 
some fairly large CF code that is a little buggy. There is some background 
event processing going on and appears a few variables are possibly being 
stepped on. The variable naming conventions makes me suspect there may be 
duplicate uses of variable names.

CFDump maybe my best option, but calling templates could affect ongoing 
background events.

Nick

At 11:06 AM 1/27/2005, you wrote:
>You could always cfdump the various scopes at the bottom of the page...
>
>I'm not sure what your intent is, though.  What are you trying to do
>with this information?
>
>--Ben
>
>Nick Baker wrote:
> > How can you strip variables such as session and server variables from
> > existing code?  Leaving a map of variables used by template.
> >
> > Unfortunately, all of the variables were not initialized in
CFAPPLICATIONS.
> >
> > Any tools or snippets that can do that?
> >
> > Thanks,
> >
> > Nick
> >
> >
> >
>
>



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191977
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Barney Boisvert
FCKEditor, HTMLArea, and TinyMCE (listed in alphabetical order) are
three free options that I've used and liked.  All have different
characterisics, but any would probably searve as a suitable base point
for your project.

cheers,
barneyb

On Thu, 27 Jan 2005 11:45:06 -0500 (EST), [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> I'll apologize in advance; the HoF server is really, really dragging on me
> today, so my attempts at a search on the topic were pretty...  Well, I
> didn't get very far.
> 
> That said, I've been searching for a WYSIWYG Rich Text Area Editor that
> allows users to control the normal aspects and allows for the uploading of
> images with the content, with the controls at my discretion.
> 
> I've checked into ActivEdit--and it looks great, to be honest.  Perhaps a
> little steep for my "personal project" budget, but in the end that may
> appear to be the best solution.
> 
> Does anyone have any recommedations or even any guidance to help me out
> with this?  I'm not opposed to a "build my own" solution, assuming it
> comes with a tutorial and a paint-by-numbers guide. (that's tongue in
> cheeck)
> 
> Thanks in advance,
> 
> Russ
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 6 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191976
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: WYSIWYG Rich Text Area Editor

2005-01-27 Thread Cynthia Reece
I've used SoEditor and enjoyed it.  There is(used to be) a free version
but I think they are phasing it out as we speak. 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 11:45 AM
To: CF-Talk
Subject: WYSIWYG Rich Text Area Editor

I'll apologize in advance; the HoF server is really, really dragging on
me today, so my attempts at a search on the topic were pretty...  Well,
I didn't get very far.

That said, I've been searching for a WYSIWYG Rich Text Area Editor that
allows users to control the normal aspects and allows for the uploading
of images with the content, with the controls at my discretion.

I've checked into ActivEdit--and it looks great, to be honest.  Perhaps
a little steep for my "personal project" budget, but in the end that may
appear to be the best solution.

Does anyone have any recommedations or even any guidance to help me out
with this?  I'm not opposed to a "build my own" solution, assuming it
comes with a tutorial and a paint-by-numbers guide. (that's tongue in
cheeck)

Thanks in advance,

Russ




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191975
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Ian Skinner
That is probably your problem.  I presume that form.formdate is a text field.  
And a empty text field is '' which is completely different then NULL.  So you 
are inserting a value into the date field, a value of an empty string, but a 
value none the less.

For situations like this and many other good reasons you should read up on the 
 tag.

To fix your date issue trying changing this line

...'#form.formdate#',

To



Now looking at your code example, you seem to be inserting your date as a 
string, not a date?  Is the field in the database a date field or a 
char|varchar field?

PS you should change your other inserts to queryparams as well.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning



...-Original Message-
...From: Robert Orlini [mailto:[EMAIL PROTECTED]
...Sent: Thursday, January 27, 2005 9:56 AM
...To: CF-Talk
...Subject: RE: OT SQL date/time default
...
...Ian, Randy,
...
...Just a plain insert and I fear that is the problem...only I don't work
...with CF enough to know the coding tips.
...
...Here it is below:
...
...
...Insert into off
...(
...formdate,
...admin,
...side1collectionsdate,
...side2collectionsdate,
...side3collectionsdate,
...side4collectionsdate,
...side5collectionsdate
...)
...VALUES
...(
...'#form.formdate#',
...'#form.admin#',
...'#form.side1collectionsdate#',
...'#form.side2collectionsdate#',
...'#form.side3collectionsdate#',
...'#form.side4collectionsdate#',
...'#form.side5collectionsdate#'
...)
...

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191974
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Adkins, Randy
Try the following:
Insert into off
(
formdate,
admin,
side1collectionsdate,
side2collectionsdate,
side3collectionsdate,
side4collectionsdate,
side5collectionsdate
)
VALUES
(
,
'#form.admin#',
,
,
,
,

)
 



-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 12:56 PM
To: CF-Talk
Subject: RE: OT SQL date/time default

Ian, Randy,

Just a plain insert and I fear that is the problem...only I don't work
with CF enough to know the coding tips.

Here it is below:


Insert into off
(
formdate,
admin,
side1collectionsdate,
side2collectionsdate,
side3collectionsdate,
side4collectionsdate,
side5collectionsdate
)
VALUES
(
'#form.formdate#',
'#form.admin#',
'#form.side1collectionsdate#',
'#form.side2collectionsdate#',
'#form.side3collectionsdate#',
'#form.side4collectionsdate#',
'#form.side5collectionsdate#'
)

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:45 PM
To: CF-Talk
Subject: RE: OT SQL date/time default


On the INSERT query are you setting the field to '' or NULL?

If you use 

myDate = '' then yes you will more than likely get that Type of date,
try using myDate = NULL

 

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:37 PM
To: CF-Talk
Subject: RE: OT SQL date/time default

Randy default is now (null) and allow nulls is checked, but when filed
is blank and submitted 1/1/1900 is inserted.

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:07 PM
To: CF-Talk
Subject: RE: OT SQL date/time default


Check to see if the Default Value of the field is set.
Else you can insert a NULL to the field based on the INSERT query


-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:03 PM
To: CF-Talk
Subject: OT SQL date/time default

I have a form that if the date field is blank SQL automatically inserts
the date of 1/1/1900 and then this displays.

How can I have it leave this field blank? The column is set as datetime
in design view.

Thx.

Robert O.












~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191973
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


WYSIWYG Rich Text Area Editor

2005-01-27 Thread russ
I'll apologize in advance; the HoF server is really, really dragging on me
today, so my attempts at a search on the topic were pretty...  Well, I
didn't get very far.

That said, I've been searching for a WYSIWYG Rich Text Area Editor that
allows users to control the normal aspects and allows for the uploading of
images with the content, with the controls at my discretion.

I've checked into ActivEdit--and it looks great, to be honest.  Perhaps a
little steep for my "personal project" budget, but in the end that may
appear to be the best solution.

Does anyone have any recommedations or even any guidance to help me out
with this?  I'm not opposed to a "build my own" solution, assuming it
comes with a tutorial and a paint-by-numbers guide. (that's tongue in
cheeck)

Thanks in advance,

Russ


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191972
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Michael T. Tangorre
> From: Robert Orlini [mailto:[EMAIL PROTECTED] 
> I have a form that if the date field is blank SQL 
> automatically inserts the date of 1/1/1900 and then this displays. 
> How can I have it leave this field blank? The column is set 
> as datetime in design view.

Make sure the field will accept a NULL in the DB. In your query you can then
use cfquery param as follows:



If the condition in the null attribute returns "Yes" the value in the value
attribute is ignored and NULL is passed in... Else it is used.

Mike




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191971
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: IE6-SP1 (MS04-040 Update) Locks JRun Admin

2005-01-27 Thread Adrocknaphobia
No. These are very clean servers. Aside from a locked-down OS, the
only software installed was CFMX Enterprise for J2EE. Absoluetly
nothing else. (Full patched JRun4 w/ updater 4)

Again, IE is _crashing_. Its not that the popup just doest show up,
its that IE locks up. This is actually only one side-effect we are
seeing with this patch, however its this issue that renders the JRun
Admin Console useless.

-Adam


On Thu, 27 Jan 2005 15:42:54 -, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> Do  you have the Google Bar or even worse : a HotBar installed?
> 
> 
> -Original Message-
> From: Adrocknaphobia [mailto:[EMAIL PROTECTED] 
> 
> Sent: 27 January 2005 15:39
> To: CF-Talk
> Subject: Re: IE6-SP1 (MS04-040 Update) Locks JRun Admin
> 
> Well I'm running win2k server not XP which may be the difference and
> this is IE6 SP1. Not sure how that relates to XP SP2.
> 
> Unfortunately it's not a matter of just disabling pop-ups. IE actually
> comes to a complete halt and crashes when I click 'Create a New
> Server' which spawn a new window.
> 
> - Adam
> 
> On Thu, 27 Jan 2005 15:19:33 -, Robertson-Ravo, Neil (RX)
> <[EMAIL PROTECTED]> wrote:
> > IndeedI allowed popups and its all sweet.
> >
> >
> > -Original Message-
> > From: Mark Drew [mailto:[EMAIL PROTECTED]
> > Sent: 27 January 2005 15:20
> > To: CF-Talk
> > Subject: Re: IE6-SP1 (MS04-040 Update) Locks JRun Admin
> >
> > I think the problem here is that IE SP2 blocks popup windows, thus not
> > allowing JRun admin to finish the task.
> >
> > Check your security preferences in IE with regards to popup windows
> >
> > Regards
> >
> > Mark Drew
> >
> > On Thu, 27 Jan 2005 14:17:41 -, Robertson-Ravo, Neil (RX)
> > <[EMAIL PROTECTED]> wrote:
> > > Working fine here..
> > >
> > > IE6 Fully Updated
> > > XP SP2
> > >
> > > What updater have you got on JRun?
> > >
> > >
> > > -Original Message-
> > > From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
> > > Sent: 27 January 2005 14:18
> > > To: CF-Talk
> > > Subject: Re: IE6-SP1 (MS04-040 Update) Locks JRun Admin
> > >
> > > No, it is def IE. Once I rolled back the patch the JRun Admin console
> > > ceased to lock up. I've tested this on 4-5 servers (all which have
> > > been patched). Unfortunately Firefox or any other browser is not an
> > > option as they are not approved software for use on .gov servers
> > >
> > > Any word from MM on a hot-fix for JRun?
> > >
> > > -Adam
> > >
> > > On Wed, 19 Jan 2005 08:55:14 +, Andy Allan <[EMAIL PROTECTED]>
> > wrote:
> > > > As I only use CF Standard (only install CF/JRun in 30 day trial mode
> > > > when I'm keeping myself handy with multiple instances/clustering) I've
> > > > obviously not run into the issue.
> > > >
> > > > Then again (and I don't mean this as a solution to your problem) I use
> > > > Firefox rather than IE.
> > > >
> > > > Check the JMC with another browser, and check each JMC from different
> > > > machines if possible. Maybe it's IE, maybe it's IE just on one PC???
> > > >
> > > > Andy
> > > >
> > > > On Tue, 18 Jan 2005 13:27:05 -0500, Adrocknaphobia
> > > > <[EMAIL PROTECTED]> wrote:
> > > > > Am I the only person in the world dealing with this issue? Or do
> > > > > subsequent IE patches resolve this issue?
> > > > >
> > > > > -Adam
> > > > >
> > > > > On Mon, 17 Jan 2005 15:00:33 -0500, Adrocknaphobia
> > > > > <[EMAIL PROTECTED]> wrote:
> > > > > > FYI:
> > > > > >
> > > > > > JRun Admin console locks up Internet Explorer after applying the
> > > > > > following IE6 SP1 security patch:
> > > > > >
> > > > > > http://support.microsoft.com/kb/889293
> > > > > >
> > > > > > When attempting to create a new server (which spawn a new window)
> > > > > > Internet Explorer locks up.
> > > > > >
> > > > > > I can verify that this behavior is occuring on at least 6 of my
> > > > > > servers I just looked at. I can't seem to find any support
> > information
> > > > > > from MM on the subject. I am seeing this in different versions of
> > > > > > JRun4.
> > > > > >
> > > > > > Anyone else dealing with this?
> > > > > >
> > > > > > -Adam
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191970
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Robert Orlini
Ian, Randy,

Just a plain insert and I fear that is the problem...only I don't work with CF 
enough to know the coding tips.

Here it is below:


Insert into off 
(
formdate,
admin,
side1collectionsdate,
side2collectionsdate,
side3collectionsdate,
side4collectionsdate,
side5collectionsdate
)
VALUES 
(
'#form.formdate#',
'#form.admin#',
'#form.side1collectionsdate#',
'#form.side2collectionsdate#',
'#form.side3collectionsdate#',
'#form.side4collectionsdate#',
'#form.side5collectionsdate#'
)

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:45 PM
To: CF-Talk
Subject: RE: OT SQL date/time default


On the INSERT query are you setting the field to '' or
NULL?

If you use 

myDate = '' then yes you will more than likely get that
Type of date, try using 
myDate = NULL

 

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 12:37 PM
To: CF-Talk
Subject: RE: OT SQL date/time default

Randy default is now (null) and allow nulls is checked, but when filed
is blank and submitted 1/1/1900 is inserted.

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:07 PM
To: CF-Talk
Subject: RE: OT SQL date/time default


Check to see if the Default Value of the field is set.
Else you can insert a NULL to the field based on the INSERT query


-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:03 PM
To: CF-Talk
Subject: OT SQL date/time default

I have a form that if the date field is blank SQL automatically inserts
the date of 1/1/1900 and then this displays.

How can I have it leave this field blank? The column is set as datetime
in design view.

Thx.

Robert O.










~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191969
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Stripping variables from CF templates?

2005-01-27 Thread Nick Baker
Ben,

The reason is to get a good pic of the variable usage strategy. I inherited 
some fairly large CF code that is a little buggy. There is some background 
event processing going on and appears a few variables are possibly being 
stepped on. The variable naming conventions makes me suspect there may be 
duplicate uses of variable names.

CFDump maybe my best option, but calling templates could affect ongoing 
background events.

Nick

At 11:06 AM 1/27/2005, you wrote:
>You could always cfdump the various scopes at the bottom of the page...
>
>I'm not sure what your intent is, though.  What are you trying to do
>with this information?
>
>--Ben
>
>Nick Baker wrote:
> > How can you strip variables such as session and server variables from
> > existing code?  Leaving a map of variables used by template.
> >
> > Unfortunately, all of the variables were not initialized in CFAPPLICATIONS.
> >
> > Any tools or snippets that can do that?
> >
> > Thanks,
> >
> > Nick
> >
> >
> >
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191968
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Ian Skinner
Or if you are using cfqueryparam as you really really really should be.




--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning



...-Original Message-
...From: Adkins, Randy [mailto:[EMAIL PROTECTED]
...Sent: Thursday, January 27, 2005 9:45 AM
...To: CF-Talk
...Subject: RE: OT SQL date/time default
...
...On the INSERT query are you setting the field to '' or
...NULL?
...
...If you use
...
...myDate = '' then yes you will more than likely get that
...Type of date, try using
...myDate = NULL

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191967
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Ian Skinner
What does the insert look like, sounds like a value of some sort is being 
created.  It may be being done at the insert logic not the database logic.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning



...-Original Message-
...From: Robert Orlini [mailto:[EMAIL PROTECTED]
...Sent: Thursday, January 27, 2005 9:36 AM
...To: CF-Talk
...Subject: RE: OT SQL date/time default
...
...Ian,
...
...NULL in default and Allow Nulls checked off. Still leaves the 1/1/1900
...date if field is left blank
...
...-Original Message-
...From: Ian Skinner [mailto:[EMAIL PROTECTED]
...Sent: Thursday, January 27, 2005 12:06 PM
...To: CF-Talk
...Subject: RE: OT SQL date/time default
...
...
...Allow nulls and set the default as null in the table description?
...
...
...--
...Ian Skinner
...Web Programmer
...BloodSource
...www.BloodSource.org
...Sacramento, CA
...
..."C code. C code run. Run code run. Please!"
...- Cynthia Dunning
...
...
...
..-Original Message-
..From: Robert Orlini [mailto:[EMAIL PROTECTED]
..Sent: Thursday, January 27, 2005 9:03 AM
..To: CF-Talk
..Subject: OT SQL date/time default
..
..I have a form that if the date field is blank SQL automatically
...inserts
..the date of 1/1/1900 and then this displays.
..
..How can I have it leave this field blank? The column is set as
...datetime
..in design view.
..
..Thx.
..
..Robert O.
..
..
..
...
...
...
...

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191966
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Adkins, Randy
On the INSERT query are you setting the field to '' or
NULL?

If you use 

myDate = '' then yes you will more than likely get that
Type of date, try using 
myDate = NULL

 

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 12:37 PM
To: CF-Talk
Subject: RE: OT SQL date/time default

Randy default is now (null) and allow nulls is checked, but when filed
is blank and submitted 1/1/1900 is inserted.

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:07 PM
To: CF-Talk
Subject: RE: OT SQL date/time default


Check to see if the Default Value of the field is set.
Else you can insert a NULL to the field based on the INSERT query


-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:03 PM
To: CF-Talk
Subject: OT SQL date/time default

I have a form that if the date field is blank SQL automatically inserts
the date of 1/1/1900 and then this displays.

How can I have it leave this field blank? The column is set as datetime
in design view.

Thx.

Robert O.








~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191965
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Has anyone done anything like this? File manipulation.

2005-01-27 Thread Mark Drew
Does the file increase tho? most of these functions create the file
(0bytes) as the handle, then do the processing in memory and when
finished dump the result into a file and close the file handle.

so you will have from 0 to hero but no inbetween

Is this what you would use? not a progress bar but a "still doing" bar?

MD


On Thu, 27 Jan 2005 11:51:44 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> If filesize==0, push a page with a meta tag redirect or a JS timeout
> that reloads the page after some number of seconds.  If filesize>0, push
> the contents instead.
> 
> --Ben
> 
> Jeff Waris wrote:
> > I kick a process off to create a report that is converted to a PDF using
> > CFEXECUTE. The report is not created instantaneously and may take some time
> > depending how many pages there are. Once created, the PDF sits in a
> > directory. This part is working fine.
> >
> > As the report starts to run. It creates a 0 byte PDF file. It then sits in
> > the directory at 0 bytes until it finishes, then displays a file size. The
> > process takes about .25-.5 second per page and it wouldn't be uncommon to
> > have a 200 page report. So the existence of this PDF could take upwards of a
> > minute to show.
> >
> > What I would like to do is spawn a new window and within that window keep
> > checking for the existence of that file and once the file is in the
> > directory and more than 0 bytes to  to the PDF and display it
> > in the new window or timeout after a certain period of time and display a
> > try again or give the option to start the creation process over.
> >
> > Has anyone done anything like this? I know that you would use cfdirectory
> > for a lot of it BUT am unsure how to do the checking/timeout loop properly.
> >
> > Thanks.
> > Jeff
> >
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191964
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Robert Orlini
Randy default is now (null) and allow nulls is checked, but when filed is blank 
and submitted 1/1/1900 is inserted.

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:07 PM
To: CF-Talk
Subject: RE: OT SQL date/time default


Check to see if the Default Value of the field is set.
Else you can insert a NULL to the field based on the INSERT query


-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 27, 2005 12:03 PM
To: CF-Talk
Subject: OT SQL date/time default

I have a form that if the date field is blank SQL automatically inserts
the date of 1/1/1900 and then this displays.

How can I have it leave this field blank? The column is set as datetime
in design view.

Thx.

Robert O.






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191963
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT SQL date/time default

2005-01-27 Thread Robert Orlini
Ian,

NULL in default and Allow Nulls checked off. Still leaves the 1/1/1900 date if 
field is left blank

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:06 PM
To: CF-Talk
Subject: RE: OT SQL date/time default


Allow nulls and set the default as null in the table description?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning



...-Original Message-
...From: Robert Orlini [mailto:[EMAIL PROTECTED]
...Sent: Thursday, January 27, 2005 9:03 AM
...To: CF-Talk
...Subject: OT SQL date/time default
...
...I have a form that if the date field is blank SQL automatically inserts
...the date of 1/1/1900 and then this displays.
...
...How can I have it leave this field blank? The column is set as datetime
...in design view.
...
...Thx.
...
...Robert O.
...
...
...



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191962
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


  1   2   >