RE: CFFILE Upload problems

[Dirk Sieber]

Well, managed to actually find the solution to this one - seems our
network folk back east put in a caching proxy that was causing the
problem.  When we excluded the IP address of the server, this went
away at least under IE.

Now I just have to try to figure out why when uploading files under
Firefox, I keep getting a dialogue box that says:
A script on this page may be busy, or may have stopped responding.  You
can stop it, etc...

Interestingly enough, if you hit 'cancel', the process completes, with
the file uploaded. 

> -Original Message-
> From: Jake Churchill [mailto:[EMAIL PROTECTED] 
> Sent: October 3, 2006 1:14 PM
> To: CF-Talk
> Subject: Re: CFFILE Upload problems
> 
> I saw this once but the server was out of Hard Drive space. 
> 
> Dirk Sieber wrote:
> > Hi everyone,
> >
> > We're still having continuing problems with uploading files 
> to one of our servers using:
> > CFFILE ACTION= "UPLOAD"
> >
> > and I'm wondering if anyone else has seen this.  Files 
> under about 100k or so are fine - above that, things get 
> erratic, with larger (ie 1MB+) files failing pretty much every time.
> >
> > We've put a sniffer on the connection, and what we're 
> seeing in the failed attempts is this:
> > -A lost segment notification from the client to the server
> > -A collection of duplicate ACKs from the server to the client, 
> > -Finally, we get:
> > HTTP/1.2 500 Internal Server Error
> > Server: Microsoft-IIS/5.0
> > etc, followed by
> > Jrun Servlet Error
> > 500 unexpected end of part
> >
> > This is on a Windows 2000 SP4 machine running MX 7
> >
> > There doesn't seem to be anything in any of the actual CF 
> logs that reflect this error.
> >
> > Anyone else seen this?  Any ideas??
> >
> > Thanks,
> > Dirk
> >
> > ~~~ 
> > Dirk Sieber 
> > ITSB - Public Works & Government Services Canada 
> > 641 - 800 Burrard Street 
> > Vancouver, BC V6Z 2V8 
> > *Phone (604) 666-9204 
> > * Fax: (604) 666-7482
> > *E-mail  [EMAIL PROTECTED]
> > ~~~ 
> >
> >
> >
> > 
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255512
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFFILE Upload problems

[Dirk Sieber]

Hi everyone,

We're still having continuing problems with uploading files to one of our 
servers using:
CFFILE ACTION= "UPLOAD"

and I'm wondering if anyone else has seen this.  Files under about 100k or so 
are fine - above that, things get erratic, with larger (ie 1MB+) files failing 
pretty much every time.

We've put a sniffer on the connection, and what we're seeing in the failed 
attempts is this:
-A lost segment notification from the client to the server
-A collection of duplicate ACKs from the server to the client, 
-Finally, we get:
HTTP/1.2 500 Internal Server Error
Server: Microsoft-IIS/5.0
etc, followed by
Jrun Servlet Error
500 unexpected end of part

This is on a Windows 2000 SP4 machine running MX 7

There doesn't seem to be anything in any of the actual CF logs that reflect 
this error.

Anyone else seen this?  Any ideas??

Thanks,
Dirk

~~~~~~~ 
Dirk Sieber 
ITSB - Public Works & Government Services Canada 
641 - 800 Burrard Street 
Vancouver, BC V6Z 2V8 
*Phone (604) 666-9204 
* Fax: (604) 666-7482
*E-mail  [EMAIL PROTECTED]
~~~ 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255254
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Releasing CFFile memory

[Dirk Sieber]

If there was, I'd appreciate it if someone could point me in the right
direction... 

> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED] 
> Sent: July 27, 2006 9:42 AM
> To: CF-Talk
> Subject: RE: Releasing CFFile memory
> 
> Wasn't there some code posted a few days/weeks ago on how to 
> read a large
> file using java?   
> 
> > -----Original Message-
> > From: Dirk Sieber [mailto:[EMAIL PROTECTED] 
> > Sent: Thursday, July 27, 2006 12:34 PM
> > To: CF-Talk
> > Subject: RE: Releasing CFFile memory
> > 
> > We've also seen a lot of issues using larger files with 
> > CFFile - we're currently looking at replacing it with a Java 
> > solution, but we haven't settled on anything yet.  If someone 
> > out there's already got a good solution, I'd like to hear about it.
> > 
> > Dirk
> >  
> > 
> > > -Original Message-
> > > From: Kervin L. Pierre [mailto:[EMAIL PROTECTED]
> > > Sent: July 27, 2006 8:59 AM
> > > To: CF-Talk
> > > Subject: Releasing CFFile memory
> > > 
> > > Hello,
> > > 
> > > Reading large files into memory using
> > > CFFile, in a loop, creates a memory leak.
> > > As anyone else seen this?
> > > 
> > > Even if the same variable is being used ColdFusion never 
> > releases the 
> > > memory of previous files.
> > > 
> > > It seems that at least some of that memory sticks around 
> even after 
> > > the script ends.
> > > We found that out, after we tried using multiple runs of 
> > the script to 
> > > allow the memory to be released in the end.
> > > 
> > > As anyone seen this behavior and have a workaround?
> > > 
> > > Best regards,
> > > Kervin
> > > 
> > > 
> > > 
> > 
> > 
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247888
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Releasing CFFile memory

[Dirk Sieber]

We've also seen a lot of issues using larger files with CFFile - we're
currently looking at replacing it with a Java solution, but we haven't
settled on anything yet.  If someone out there's already got a good
solution, I'd like to hear about it.

Dirk
 

> -Original Message-
> From: Kervin L. Pierre [mailto:[EMAIL PROTECTED] 
> Sent: July 27, 2006 8:59 AM
> To: CF-Talk
> Subject: Releasing CFFile memory
> 
> Hello,
> 
> Reading large files into memory using
> CFFile, in a loop, creates a memory leak.
> As anyone else seen this?
> 
> Even if the same variable is being used
> ColdFusion never releases the memory of
> previous files.
> 
> It seems that at least some of that memory
> sticks around even after the script ends.
> We found that out, after we tried using
> multiple runs of the script to allow the
> memory to be released in the end.
> 
> As anyone seen this behavior and have a
> workaround?
> 
> Best regards,
> Kervin
> 
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247885
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Replacements/alternatives for CFFILE upload?

[Dirk Sieber]

 
> Something is wrong.  I'd look at the network.  Maybe setting 
> the latency
> a little lower or higher or whatever that is could fix something.
> 
> Really, you shouldn't have a problem, I've used cffile over a 
> 14.4 with
> >MB files with no problems, other than slowness, as would be expected.

Hmmm... interesting.  I've actually got someone looking at the network
issue, but other forms of transfer (eg, FTPing a file to the same
server) seem to be fine.

> But if you have even a sluggish network, that normally allows 
> transmission
> of >MB files much faster, I'd wonder what's going on.  Have 
> you checked
> the network outside of CF?

See above. :)  I've just done some testing of my own - FTP transfers are
fine - approx 100 KB/sec sustained transfer rates to the server.
However, document uploads still time out.

Thanks,
Dirk
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240911
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: Replacements/alternatives for CFFILE upload?

[Dirk Sieber]

> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED] 
> Sent: May 17, 2006 12:36 PM
> To: CF-Talk
> Subject: Re: Replacements/alternatives for CFFILE upload?
> 
> Dirk Sieber wrote:
> > 
> > Can anyone out there recommend a good alternative?
> 
> FTP? =)

It might come to that. ;-)

> I've never had problems with cffile.  And since CFFILE *IS* 
> java (as all 
> coldfusion is), using java calls to handle file uploads probably 
> wouldn't make a difference.
> 
> An alternative would be to develop some kind of activex or 
> java control 
> that allowed you to browse for files on your local machine, 
> and submit 
> those files to a web service that you've written in coldfusion.  That 
> wouldn't be an HTTP POST, it's be soap/xml.  Then the web 
> service would 
> accept the file and verify it via some kind of checksum 
> passed in from 
> the activex control and tell the activex control that the file came 
> across okay.
> 
> Seems like a lot of work to me.
> 
> Exactly what kind of problems are you having with CFFILE anyway?
> 
> Rick

The issues that we're having is with transfers either taking an insanely
long time, or just timing out, and never completing.  It seems to just
be a size issue - as soon as we're talking about a MB or 2, odds of
completion go *way* down.  I'm sure that it's not helped that this is
over a (relatively) slow connection - it's not on our local LAN, but
then again, it's not exactly dial-up, either.

We're using this to give end-users of the site the ability to upload
documents that are then sorted, placed, & served appropriately based on
criteria they've entered.  So, straight FTP isn't a simple solution, as
then we have the file, but not the metadata we need.  And,
unfortunately, a lot of the user population is of the "what's a
computer" level, so complicated mechanisms aren't likely to be popular.

>From general talk about HTML input type=file stuff on-line, it seems
this isn't a terribly unusual problem, so I was hoping someone else
would've already found a better solution on this one.

Dirk 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240848
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

Replacements/alternatives for CFFILE upload?

[Dirk Sieber]

Hi all,

We're running into multiple problems with using CFFILE to upload
documents to one of our servers - it's located over a slowish link, and
anything over a couple of hundred k is causing the browser to time out
before the process completes.  From what I've been reading, the whole
HTML file upload process is rather dicey at best anyway.

Can anyone out there recommend a good alternative?  It doesn't have to
be fancy - all it needs to do is allow the user to specify one file, and
upload it to a directory determined by the application.  I've seen some
solutions involving java calls from CF, but they all seem to be geared
towards text files, and these files could be binary.

Thanks,
Dirk

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240799
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

Flash forms & CFSELECT

[Dirk Sieber]

Okay, so I'm undoubtably missing something incredibly stupid, but...

Decided to spend a few minutes playing around with the new Flash form
capabilities in MX7.  I have a simple select list, populated like so:

SELECT DISTINCT Location
FROM Cmn_Location
WHERE Deleted = 0
ORDER BY Location


and an incredibly simple form, like so:

 


Which works just as you'd expect.  Tried just changing the 'format' to
Flash, & adding a height & width:


 


And all I get is a Flash area with the outline of a box, with an
ever-spinning clock cursor while within the boundaries of it.

Tried putting a simple button inside the flash form:



 


And the button shows up, no problem - but still no list.

What totally obvious thing am I missing??

Thanks,
Dirk

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235593
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: Backup solution for small business?

[Dirk Sieber]

Many thanks to Jeff, Ken, Matt, and Snake for the suggestions - time to
grab a couple of eval copies & do some testing!

Dirk


> -Original Message-
> From: Jeff Fleitz [mailto:[EMAIL PROTECTED] 
> Sent: August 25, 2005 12:18 PM
> To: CF-Talk
> Subject: Re: OT: Backup solution for small business?
> 
> 
> Here's another one I have been using for a few years; 30 day 
> trial and costs $35
> 
> http://www.backupplus.net/
> 
> On 8/25/05, Dirk Sieber <[EMAIL PROTECTED]> wrote:
> > Hi everyone,
> > 
> > I've got an off-topic, but slightly web related question, 
> and figured
> > the list might have some answers...
> > 
> > I've got a client with a small network setup (1 Win2k 
> server, bunch of
> > XP/2000 clients), and they're looking for a backup solution 
> for their
> > server.  It's just one machine, running their website & 
> some other small
> > stuff, and most of the 'name-brand' backup solutions I'm 
> familiar with
> > seem to be total overkill for what they want - they're just 
> looking at
> > doing a nightly backup to removeable harddrives - being 
> able to handle
> > multiple days on the same media would be a plus.
> > 
> > Anyone have any recommendations for something that'd fit the bill?
> > 
> > Thanks!
> > Dirk

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

OT: Backup solution for small business?

[Dirk Sieber]

Hi everyone,

I've got an off-topic, but slightly web related question, and figured
the list might have some answers...

I've got a client with a small network setup (1 Win2k server, bunch of
XP/2000 clients), and they're looking for a backup solution for their
server.  It's just one machine, running their website & some other small
stuff, and most of the 'name-brand' backup solutions I'm familiar with
seem to be total overkill for what they want - they're just looking at
doing a nightly backup to removeable harddrives - being able to handle
multiple days on the same media would be a plus.

Anyone have any recommendations for something that'd fit the bill?

Thanks!
Dirk

~|
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:216347
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: Canadian CF hosting & CC processing?

[Dirk Sieber]

Rather delayed, but... just wanted to thank everyone for their
suggestions - looks like they're probably going with e-xact for CC
processing, and Crystaltech.com for hosting.

Thanks!

Dirk

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

Canadian CF hosting & CC processing?

[Dirk Sieber]

Okay, it seems to be a day for questions for me. :)  Can anyone
recommend a Canadian solution for:
A) CF hosting - CFMX prefered, if possible, and in Canada would be nice,
although not absolutely necessary.

B) A CF-friendly company that can handle Canadian on-line credit-card
authorizations - looking around on-line, seems all the big names are
geared to the US.  I'm new to this side of things, so I don't know if
that means they only deal in US currency transations, which would mean
two conversions for every sale (Cdn Customer->US $ charge->Cdn $ to the
company), or if it's an option to choose your currency.

I found an old reference to Pacific Online, but they don't seem to be
offering CF hosting anymore.  Also one for http://www.afpwebworks.com -
however, I'd prefer something a little closer to home, if possible, but
I'm checking them out - anyone have any comments on their service?

Thanks!
Dirk

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

Shopping carts & hosting

[Dirk Sieber]

My apologies  in advance - I know this has been answered before, but of course, 
I didn't need the information then...

Anyway, I'm looking for two things:

1) A shopping cart written in CF - This would be for a fairly low-traffic site, 
at least at this point.  I know I could write one, but at this point, I don't 
think it's worth re-inventing the wheel - I'm sure there's something out there 
that'd work.  Desired features:

-easy to update by people who aren't terribly computer knowledgeable

-simple to feature items, put items or classes of them on sale, etc.

-easy to integrate into an existing site.

-on-line credit card payment acceptance would be a big plus, with validation 
against some on-line processor.

-Free or low cost would be a plus.

2) A good place to host #1. :-)

Any advice, pointers, etc would be appreciated!  

Thanks,

Dirk

 



~|
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:210843
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: SUSPECT: RE: slow Java call - Determining physical length of string - Pt 2

[Dirk Sieber]

We're starting to run into that as well...some of the numbers seem to be
quite off - just when we thought we had a solution.  Anyone have any
other ideas on how we can accomplish this?  This doesn't have to be
cross-platform - any way to call a native Windows function to get the
correct size?

 
Thanks,
Dirk

	-Original Message-
	From: Craig Dudley [mailto:[EMAIL PROTECTED] 
	Sent: Tuesday, August 17, 2004 2:37 AM
	To: CF-Talk
	Subject: SUSPECT: RE: slow Java call - Determining physical
length of string - Pt 2
	
	
	I had a play with this myself, and found that the pixel width
retruned
	by the funtion is a LONG way out of the actual length of the
string
	rendered in a browser.
	
	e.g.
	
	 
	font_obj =
createobject("java","java.awt.Font").init('Arial',1,8);
	font_metrics_obj =
	
createobject("java","java.awt.Toolkit").getDefaultToolkit().getFontMetri
	cs(font_obj);
	Pixel_Width = font_metrics_obj.stringWidth('the pixel width is
miles
	out?');
	
	
	
	#Pixel_Width#
	
	
height="1"
	alt="" border="0">
	
	the
pixel
	width is miles out?
	
	
	You'll need a test gif of course.
	
	Still, I'm not sure why, maybe java just renders fonts entirely
	differently to browsers. I tried several fonts and many font
sizes, none
	of them are even close, or did I miss something?
	
	Craig.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SUSPECT: Re: slow Java call - Determining physical length of string - Pt 2

[Dirk Sieber]

I would definitely agree that the issue appears to be the instantiation
time - my problem here is that this is basically the first time I've
dealt with objects and/or Java in relation to CF.  So... how do I go
about reusing the FontMetrics object once I've created it?  You'll have
to excuse my ignorance. 

 
Creating one for each font variation, & then using the appropriate one
at the appropriate time definitely seems to make sense.  We're dealing
with a limited number of font/style combinations, so it's definitely
feasible.

 
Thanks,
Dirk

	-Original Message-
	From: Pete Freitag [mailto:[EMAIL PROTECTED] 
	Sent: Monday, August 16, 2004 12:53 PM
	To: CF-Talk
	Subject: SUSPECT: Re: slow Java call - Determining physical
length of string - Pt 2
	
	
	Hi Dirk,
	
	I think most of the slowness is in creating the objects not
calculating 
	the width. So if you can somehow cache or reuse the objects, it
is much 
	faster. You will notice that the following code is much faster
than 
	calling the UDF. So what I would suggest is that if your going
to be 
	using the same face, style and size that you just create the 
	FontMetrictsObject once, and reuse it:
	
	
	    face = "Arial";
	    style = "Plain";
	    size = 12;
	  if (Style EQ "Plain" OR Style EQ "Normal") {
	   Style = CreateObject("java", "java.awt.Font").PLAIN;
	  } else if (Style EQ "Bold") {
	   Style = CreateObject("java", "java.awt.Font").BOLD;
	  } else if (Style EQ "Italic") {
	   Style = CreateObject("java", "java.awt.Font").ITALIC;
	  }
	
	
	  FontObject = CreateObject("java","java.awt.Font").init(Face,
Style,Size);
	  FontMetricsObject = 
	
CreateObject("java","java.awt.Toolkit").getDefaultToolkit().getFontMetri
cs(FontObject);
	
	  
	
	
	
	    
width")>
	
	
	
	#tock-tick#ms
	
	Dirk Sieber wrote:
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SUSPECT: Re: slow Java call - Determining physical length of string - Pt 2

[Dirk Sieber]

Well, we'd thought about storing values - but that's basically the same
as the original idea of storing the width of each individual character,
and I think it would just become very unwieldy to manage.  It's a
possibility though, and I thank you for the idea!

	-Original Message-
	From: Nathan Strutz [mailto:[EMAIL PROTECTED] 
	Sent: Monday, August 16, 2004 12:36 PM
	To: CF-Talk
	Subject: SUSPECT: Re: slow Java call - Determining physical
length of string - Pt 2
	
	
	I'm not familiar with what exactly your app is doing, nor the
AWT 
	library, but app caching, yes. Might there be a way to store the
string 
	width with the string? For instance, if it's called from a
database, add 
	a field for width, and recalculate on insert and update, not on
select.
	
	Other than that I've got one last idea. What if you calculate
the length 
	of a word (assuming this is normal user-input text)? For
example, if 
	"The" will be 23px wide each time, save it and reuse it. It will
be more 
	calls to the FontObject initially, once per word instead of per 
	sentence, but will pay off once it caches a couple hundred
words.
	
	Ehh, maybe not the easiest, but perhaps worth a try.
	
	-nathan strutz
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

slow Java call - Determining physical length of string - Pt 2

[Dirk Sieber]

Hello again,

 
Last week, I posted regarding finding the actual length of a text string
(original question below), and, thanks to some helpful people, ended up
with the idea of instansiating the Java FontObject, which we turned into
a function, like this:

 
 
 
 

 
  if (Style EQ "Plain" OR Style EQ "Normal") {
   Style = CreateObject("java", "java.awt.Font").PLAIN;
  } else if (Style EQ "Bold") {
   Style = CreateObject("java", "java.awt.Font").BOLD;
  } else if (Style EQ "Italic") {
   Style = CreateObject("java", "java.awt.Font").ITALIC;
  }
  
  FontObject = CreateObject("java","java.awt.Font").init(Face, Style,
Size);
  FontMetricsObject =
CreateObject("java","java.awt.Toolkit").getDefaultToolkit().getFontMetri
cs(FontObject);
  
  return(FontMetricsObject.stringWidth(String));

 
 

 
Now, the problem - it works really well, but it's painfully slow - we're
sometimes calling this 50 times on a page, and it's causing the page
times to be in the 3-5 second range.  Removing the call drops it to a
few hundred milliseconds, so this seems to be the issue.

 
It's not completely intolerable, and it's much nicer than the 'keep a
table of all the character widths' way of doing things, so we'll stick
with it, but if anyone's got any ideas on a way to speed this up, I'm
all ears!

 
Thanks,
Dirk

> From: Dirk Sieber [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 11, 2004 11:13 AM
> To: CF-Talk
> Subject: Determining physical length of text string (not char count)
> 
> 
> Hello everyone,
> 
> We're trying to figure out if there's a way in CF to figure out the 
> actual, physical length of a string of text - eg, in pixels, inches, 
> whatever.
> 
> The issue - we need to be able to accept user data for a field, that 
> will eventually be printed to a PDF.  That PDF has strict specs as to 
> how long a line of text can be.  Of course, that'd be simple enough, 
> if it was printed in a fixed-width font... but it's not, and we don't 
> have the option of changing it.
> 
> So... I need to find a way to detemine how long a string of text will 
> be, given the font type, style, & point size.  Anyone have any ideas 
> how to do this from within CF?  (This is under MX, BTW).
> 
> Many thanks for any suggestions!
> Dirk
>  _
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SUSPECT: Re: Determining physical length of text string (not char count)

[Dirk Sieber]

Adam,

That's perfect - thank you! It does exactly what we're looking for.
We've rolled it into a function, and it's working perfectly.

Many thanks!
Dirk

-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 11, 2004 12:22 PM
To: CF-Talk
Subject: SUSPECT: Re: Determining physical length of text string (not
char count)

I came up with this (you could easily turn it into a function):

font_obj = createobject("java","java.awt.Font").init('Tahoma',1,8);
font_metrics_obj =
createobject("java","java.awt.Toolkit").getDefaultToolkit().getFontMetri
cs(font_obj);
Pixel_Width = font_metrics_obj.stringWidth('My co-worker is mean');

I have a question thoughI tried to do 
createobject("java","java.awt.FontMetrics").init(font_obj)  and it
gave me an error:
Unable to find a constructor for class java.awt.FontMetrics that
accepts parameters of type ( java.awt.Font )

Any ideas what I was doing wrong?

Adam H
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SUSPECT: Re: Determining physical length of text string (not char count)

[Dirk Sieber]

Adam,

 
That's perfect - thank you!  It does exactly what we're looking for.
We've rolled it into a function, and it's working perfectly.

 
Many thanks!
Dirk

	-Original Message-
	From: Adam Haskell [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, August 11, 2004 12:22 PM
	To: CF-Talk
	Subject: SUSPECT: Re: Determining physical length of text string
(not char count)
	
	
	I came up with this (you could easily turn it into a function):
	
	font_obj =
createobject("java","java.awt.Font").init('Tahoma',1,8);
	font_metrics_obj =
	
createobject("java","java.awt.Toolkit").getDefaultToolkit().getFontMetri
cs(font_obj);
	Pixel_Width = font_metrics_obj.stringWidth('My co-worker is
mean');
	
	I have a question thoughI tried to do 
	createobject("java","java.awt.FontMetrics").init(font_obj)  and
it
	gave me an error:
	Unable to find a constructor for class java.awt.FontMetrics that
	accepts parameters of type ( java.awt.Font )
	
	Any ideas what I was doing wrong?
	
	Adam H
	
	On Wed, 11 Aug 2004 11:34:06 -0500, Mark W. Breneman
	<[EMAIL PROTECTED]> wrote:
	> So if I understand you correctly you need to know how long
some text is, not
	> the number of letters that makes it up.
	> 
	> Just off the top of my head, if you know the font and point
size you will be
	> using in the PDF, you could build a look up table for each
letter and return
	> the pix with then add them together. You would need a record
for all chrs a
	> user would enter in your look up table.
	> 
	> Its not a good idea but
	> 
	> Mark W. Breneman
	> -Cold Fusion Developer
	> -Network Administrator
	>  Vivid Media
	>  [EMAIL PROTECTED]
	>  www.vividmedia.com 
	>  608.270.9770
	> 
	>  _
	> 
	> From: Dirk Sieber [mailto:[EMAIL PROTECTED]
	> Sent: Wednesday, August 11, 2004 11:13 AM
	> To: CF-Talk
	> Subject: Determining physical length of text string (not char
count)
	> 
	> 
	> Hello everyone,
	> 
	> We're trying to figure out if there's a way in CF to figure
out the
	> actual, physical length of a string of text - eg, in pixels,
inches,
	> whatever.
	> 
	> The issue - we need to be able to accept user data for a
field, that
	> will eventually be printed to a PDF.  That PDF has strict
specs as to
	> how long a line of text can be.  Of course, that'd be simple
enough, if
	> it was printed in a fixed-width font... but it's not, and we
don't have
	> the option of changing it.
	> 
	> So... I need to find a way to detemine how long a string of
text will
	> be, given the font type, style, & point size.  Anyone have any
ideas how
	> to do this from within CF?  (This is under MX, BTW).
	> 
	> Many thanks for any suggestions!
	> Dirk
	>  _
	> 
	> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SUSPECT: RE: Determining physical length of text string (not char count)

[Dirk Sieber]

Hi Mark,

 
Yes, that's exactly the issue - getting the number of characters making
up the string is simple.  This, unfortunately, is a bit more difficult.

 
Thanks for the suggestion - it's our fallback position, but we're still
looking for something a little easier/more versatile, if we can find it.

 
Dirk

	-Original Message-
	From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, August 11, 2004 9:34 AM
	To: CF-Talk
	Subject: SUSPECT: RE: Determining physical length of text string
(not char count)
	
	
	So if I understand you correctly you need to know how long some
text is, not
	the number of letters that makes it up.
	
	
	Just off the top of my head, if you know the font and point size
you will be
	using in the PDF, you could build a look up table for each
letter and return
	the pix with then add them together. You would need a record for
all chrs a
	user would enter in your look up table.
	
	
	Its not a good idea but
	
	
	Mark W. Breneman
	-Cold Fusion Developer
	-Network Administrator
	  Vivid Media
	  [EMAIL PROTECTED]
	  www.vividmedia.com  
	  608.270.9770
	
	  _____  
	
	From: Dirk Sieber [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, August 11, 2004 11:13 AM
	To: CF-Talk
	Subject: Determining physical length of text string (not char
count)
	
	Hello everyone,
	
	We're trying to figure out if there's a way in CF to figure out
the
	actual, physical length of a string of text - eg, in pixels,
inches,
	whatever.  
	
	The issue - we need to be able to accept user data for a field,
that
	will eventually be printed to a PDF.  That PDF has strict specs
as to
	how long a line of text can be.  Of course, that'd be simple
enough, if
	it was printed in a fixed-width font... but it's not, and we
don't have
	the option of changing it.
	
	So... I need to find a way to detemine how long a string of text
will
	be, given the font type, style, & point size.  Anyone have any
ideas how
	to do this from within CF?  (This is under MX, BTW).
	
	Many thanks for any suggestions!
	Dirk 
	  _ 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SUSPECT: Re: Determining physical length of text string (not char count)

[Dirk Sieber]

Well, I'm not terribly Java-knowledgeable at this point, but I'm not
afraid to start digging. :)  I'll take a look at that - thanks.

 
We actually thought of the table of widths approach, but it's incredibly
cumbersome, especially considering we need to deal with multiple point
sizes, and also variations (bold/italic).  I'm hoping to avoid that. :)

 
Thanks!
Dirk

	-Original Message-
	From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, August 11, 2004 9:25 AM
	To: CF-Talk
	Subject: SUSPECT: Re: Determining physical length of text string
(not char count)
	
	
	If you're not scared of Java, one approach would be to use the
	java.awt.FontMetrics class (probably via a temp image's Graphics
	instance), specifically the getStringBounds method.  That'll
give you
	all kinds of goodies about the font and strings written using
that
	font.
	
	If you don't want that complexity, you could record the pixel
width of
	each character in your desired font into a struct, and loop over
the
	string, summing up a length.  Won't be exactly perfect, because
of
	ligatures and kerning, but it should be close, and I believe
that'll
	never underestimate, but that'll might not be true.
	
	cheers,
	barneyb
	
	On Wed, 11 Aug 2004 12:12:31 -0400, Dirk Sieber
<[EMAIL PROTECTED]> wrote:
	> Hello everyone,
	> 
	> We're trying to figure out if there's a way in CF to figure
out the
	> actual, physical length of a string of text - eg, in pixels,
inches,
	> whatever.
	> 
	> The issue - we need to be able to accept user data for a
field, that
	> will eventually be printed to a PDF.  That PDF has strict
specs as to
	> how long a line of text can be.  Of course, that'd be simple
enough, if
	> it was printed in a fixed-width font... but it's not, and we
don't have
	> the option of changing it.
	> 
	> So... I need to find a way to detemine how long a string of
text will
	> be, given the font type, style, & point size.  Anyone have any
ideas how
	> to do this from within CF?  (This is under MX, BTW).
	> 
	> Many thanks for any suggestions!
	> Dirk
	
	-- 
	Barney Boisvert
	[EMAIL PROTECTED]
	360.319.6145
	http://www.barneyb.com 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Determining physical length of text string (not char count)

[Dirk Sieber]

Hello everyone,

 
We're trying to figure out if there's a way in CF to figure out the
actual, physical length of a string of text - eg, in pixels, inches,
whatever.  

 
The issue - we need to be able to accept user data for a field, that
will eventually be printed to a PDF.  That PDF has strict specs as to
how long a line of text can be.  Of course, that'd be simple enough, if
it was printed in a fixed-width font... but it's not, and we don't have
the option of changing it.

 
So... I need to find a way to detemine how long a string of text will
be, given the font type, style, & point size.  Anyone have any ideas how
to do this from within CF?  (This is under MX, BTW).

 
Many thanks for any suggestions!
Dirk
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Access Windows accounts through CF

[Dirk Sieber]

Thanks Dave - I'll check those out, as well as the Internet Hosting
toolkit that a few people mentioned.  Hopefully one of those will do the
trick!

 
Thanks everyone for your help!

Dirk

	-Original Message-
	From: David Delbridge [mailto:[EMAIL PROTECTED] 
	Sent: Thursday, November 27, 2003 5:08 PM
	To: CF-Talk
	Subject: Re: Access Windows accounts through CF
	
	
	Hi Dirk,
	
	There are some custom tags available for managing Windows users
--
	CFX_User (company defunct?), CF_NT_UserDB, CFX_NTUserManager,
etc.; all
	available for download in the Developer's Exchange.
	
	If you prefer to roll your own, you can call a VBScript with
CFExecute.
	
	I hope this is helpful.
	
	Dave
	
	-- 
	
	David M. Delbridge
	Circa 3000
	ColdFusion Hosting
	http://www.circa3k.com
	775-832-2445
	
	Dirk Sieber wrote:
	> 
	> Hi everyone,
	> 
	> I've recently had a request made to me for a specific piece of
	> functionality.  We run an FTP server that uses regular Windows
	> accounts
	> as logins.  I've been asked if there's a way to change
people's
	> passwords using CF on that box, as the people who FTP to it
don't have
	> regular access to it to change their own passwords, and we
don't
	> really
	> want to have the admin person have to handle  every change
request.
	> 
	> (Yes, they're aware that there's a lot of potential security
issues
	> involved, but they still want to do it).
	> 
	> I've done some searches, but haven't really turned up much.
Anyone
	> done
	> this before?  Code samples? ;-)
	> 
	> Thanks,
	> Dirk
	>    
  _  

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

Access Windows accounts through CF

[Dirk Sieber]

Hi everyone,

I've recently had a request made to me for a specific piece of
functionality.  We run an FTP server that uses regular Windows accounts
as logins.  I've been asked if there's a way to change people's
passwords using CF on that box, as the people who FTP to it don't have
regular access to it to change their own passwords, and we don't really
want to have the admin person have to handle  every change request.

(Yes, they're aware that there's a lot of potential security issues
involved, but they still want to do it).

I've done some searches, but haven't really turned up much.  Anyone done
this before?  Code samples? ;-)

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

RE: Odd Netscape/CFMX/IIS5 problem

[Dirk Sieber]

That did it  - forcing the text to ISO-8859-1 fixed the problem.
 
Thank you for reply - it's greatly appreciated!
 
Dirk
 

	-Original Message-
	From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
	Sent: Thursday, October 02, 2003 10:30 AM
	To: CF-Talk
	Subject: Re: Odd Netscape/CFMX/IIS5 problem
	
	
	>> It seems now
	that most of the time, all the text on the page is showing up as
small,
	hollow rectangles.
	
	This is probably because CFMX is sending the text as UTF-8 by
default instead of ISO-8859-1
	and the user has no font defined in his system to display
Unicode characters.
	
	
	
  _  

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

RE: Odd Netscape/CFMX/IIS5 problem

[Dirk Sieber]

Thanks for the suggestion - Note, however, that this happens to *all*
the text on the page - regular text, links - you name it.  It's very
weird, and only started happening after our move to W2k/CFMX - I'm just
trying to figure out what's changed.  One of our dev servers is still
running NT4/CF 4.5, and going to the same pages on it doesn't cause the
problem.
 
Anyone know if CFMX returns different header information for a page, or
anything that might affect this?
 
Dirk
 

	-Original Message-
	From: Ubqtous [mailto:[EMAIL PROTECTED] 
	Sent: Thursday, October 02, 2003 7:51 AM
	To: CF-Talk
	Subject: Re: Odd Netscape/CFMX/IIS5 problem
	
	
	Dirk,
	
	On 10/2/2003 at 10:35, you wrote:
	
	DS> I'm wondering if anyone's run into this before.  We recently
upgraded
	DS> one of our servers from NT4/CF 4.5 to Windows 2k/CF MX.  One
of the
	DS> applications running on the server uses a dynamically
generated menu -
	DS> lots of _javascript_.  Everything seemed to be running fine -
until one of
	DS> our clients, who's still running Netscape 4.61 (yes, I know
- but we
	DS> can't do anything about it) reported some weird behaviour.
It seems now
	DS> that most of the time, all the text on the page is showing
up as small,
	DS> hollow rectangles.
	
	DS> The text is actually still there - if you re-size the
browser window,
	DS> it'll show as regular text again... for a while.  If you
flip to another
	DS> window, & then flip back, it'll once again redraw as little
rectangles.
	DS> If you copy & paste the 'rectangles' into something else, it
shows up as
	DS> the correct text.  The links still work, etc - you just
can't tell what
	DS> anything says.  I'll be happy to provide screen shots upon
request. :)
	
	Are you using CSS to format the links? I've run into display
issues
	with older NN versions as well, specifically when using border
	formatting on buttons or form fields--buttons still appear
without
	formatting, but have a rectangle below them; form fields tend to
	disappear and get ignored by the form processor (though they are
in
	the browser source).
	
	If CSS is the culprit, I would say that the work around is to
either
	dumb down your CSS, or uses a browser sniffer and serve up
different
	style sheets accordingly.
	
	~ Ubqtous ~
	
  _  

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

Odd Netscape/CFMX/IIS5 problem

[Dirk Sieber]

Hi Folks,
 
I'm wondering if anyone's run into this before.  We recently upgraded
one of our servers from NT4/CF 4.5 to Windows 2k/CF MX.  One of the
applications running on the server uses a dynamically generated menu -
lots of _javascript_.  Everything seemed to be running fine - until one of
our clients, who's still running Netscape 4.61 (yes, I know - but we
can't do anything about it) reported some weird behaviour.  It seems now
that most of the time, all the text on the page is showing up as small,
hollow rectangles.
 
The text is actually still there - if you re-size the browser window,
it'll show as regular text again... for a while.  If you flip to another
window, & then flip back, it'll once again redraw as little rectangles.
If you copy & paste the 'rectangles' into something else, it shows up as
the correct text.  The links still work, etc - you just can't tell what
anything says.  I'll be happy to provide screen shots upon request. :)
 
Has anyone run into anything like this before?  Anyone have any
suggestions?
 
Thanks,
Dirk
 

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

RE: Slightly OT - Any good CFMX demos out there?

[Dirk Sieber]

Yes, I've seen Petmarket, and it does show well - I was just wondering if anyone out 
there had either seen or created anything else that they wouldn't mind us looking at.

Thanks,
Dirk


> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 9:02 AM
> To: CF-Talk
> Subject: Re: Slightly OT - Any good CFMX demos out there?
> 
> 
> Petmarket is Flashy and shows well -- I don't think it is too 
> heavy of 
> CFMX stuff, though
> 
> Dick
> 
> On Tuesday, September 17, 2002, at 08:54 AM, Dirk Sieber wrote:
> 
> > Hi everyone,
> >
> > Okay, so we're trying to convince the powers that be that 
> upgrading to 
> > CFMX is a good thing - and, as part of that, we've been 
> asked to find 
> > some demos of things you can do in MX that you just couldn't do in 
> > previous versions (or, at least, not easily).  Sad but 
> true, something 
> > flashy would probably go over well. ;-)
> >
> > Anyone have any good candidates that they'd like to nominate?
> >
> > Thanks,
> > Dirk
> > 
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Slightly OT - Any good CFMX demos out there?

[Dirk Sieber]

Hi everyone,

Okay, so we're trying to convince the powers that be that upgrading to CFMX is a good 
thing - and, as part of that, we've been asked to find some demos of things you can do 
in MX that you just couldn't do in previous versions (or, at least, not easily).  Sad 
but true, something flashy would probably go over well. ;-)

Anyone have any good candidates that they'd like to nominate?

Thanks,
Dirk
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Problem running CFMX demo

[Dirk Sieber]

Well, I think I've found the problem... now the question is, how do I fix it?  

After re-starting the machine, I checked the logs again, and found this:

Starting Macromedia JRun 4 (Build 46455), default server
08/24 07:21:27 warning Unable to open C:\CFusionMX\runtime/lib/license.properties
08/24 07:21:28 info JRun Naming Service listening on port 2901
Running on JRun4...
Starting ColdFusion services...
- Starting logging...
0 [main] INFO coldfusion.server  - Starting logging...
- Starting license...
481 [main] INFO coldfusion.server  - Starting license...
- Starting License server ...
551 [main] INFO coldfusion.server  - Starting License server ...
- A LicenseExpiredException has been thrown
coldfusion.server.ServiceException: A LicenseExpiredException has been thrown
at coldfusion.license.LicenseServiceImpl.load(LicenseServiceImpl.java:109)
at coldfusion.server.ServiceBase.start(ServiceBase.java:38)
at coldfusion.server.CFService.setupLicense(CFService.java:231)
[...]
---
in the default-out.log file.  I assume that this is because the demo version had been 
installed on this machine previously, and, I assume, expired.

Is there any way to "re-start" the demo, as it were, or am I destined to look for 
another machine to install this on?  We'd just like to make sure our CF 4.5 code is 
going to work under MX before shelling out to upgrade all our licenses...

Thanks,
Dirk


> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 24, 2002 7:23 AM
> To: '[EMAIL PROTECTED]'
> Cc: Dirk Sieber
> Subject: RE: Problem running CFMX demo
> 
> 
> > Well, I wanted to get around to actually testing CFMX, so I 
> > grabbed the demo download from Macromedia's site, and 
> > installed it.  However, when I try to go to the administrator 
> > page, I get a blank page.  Digging a little further, I found 
> > an error in the CF log, 
> > '[1]coldfusion.server.ServiceFactory$ServiceNotAvailableExcept
> > ion: The Runtime service is not available.'  (Snippet of log 
> > appended below).
> > 
> > This is on a W2k box, running SP2, no IIS.  I believe it once 
> > had the CFMX demo installed previously, although it's been 
> > removed, if that's relevant.
> > 
> > I've tried uninstalling & re-installing the demo - no 
> > difference.  The CFMX services are all running, according to 
> > the service control manager.  If I create a straight HTML 
> > file & drop it in the web root, I can retrieve it by going to 
> > localhost:8500/test.htm, so the web server portion is 
> > working...however, a simple .cfm file also returns nothing.
> > 
> > Any ideas?  Am I just missing something amazingly obvious? :)
> 
> You might try this:
> 
> 1. Uninstall CF MX.
> 2. Delete the \CFusionMX directory completely.
> 3. Reinstall CF MX.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF SQL Tool

[Dirk Sieber]

Well, the first piece of feedback I have is that when I download the .zip,
it says it's not a valid archive. ;-)

Dirk


> -Original Message-
> From: Clint Tredway [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 08, 2002 11:14 AM
> To: CF-Talk
> Subject: CF SQL Tool
> 
> 
> I have updated my SQL tool and if you would like to help beta 
> test it go here.
> 
> http://www.factorxsoftware.com/download/
> 
> I would appreciate any feedback. this is feature complete for 
> version 1 and I need help testing it for bugs.
> 
> To use the tool, just unzip it on your server and you are 
> good to go. It is not encrypted because there is no point to 
> encrypt it. It is also IE 5+ only. 
> 
> Thanks,
> Clint
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL query question

[Dirk Sieber]

So, this is where I start thinking that maybe there isn't that elusive easy
solution after all... ;-)

Thanks for your suggestions... I'm going to start playing around with them
now, and see what I can come up with. 

Dirk
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL query question

[Dirk Sieber]

Hi everyone,

Okay, I've been struggling with this one for a while, and I'm sure there's a
solution, but I'm just not seeing it.

I've got a collection of tables, among which are document, and attrib_xref.

In the attrib_xref table, there's (among others) the following columns:
DocID
AttribID
AttribValue

Each document can have multiple attributes, so there may be many lines in
this table, with the same DocID, but different AttribID/AttribValue pairs.

What I'd like to be able to do is an "and" search for multiple attributes,
so I'd like to be able to say that I'm looking for the document with
DocID=x, where AttribID=12 and it's corresponding value is 'some text', AND
where there's also a second Attrib_XRef record with DocID=x, where
AttribID=24 and it's corresponding value is 'some other text'

I also need this to be extensible - ie, a person may specify one attribute
pair, or 2, or 3, or... etc.

Any suggestions (short of re-designing the DB - that's out of my control,
unfortunately).

If someone can point me in the right direction, I'd really appreciate it...

Thanks,
Dirk

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Calculating Taxes (at least not CFMX topic :)

[Dirk Sieber]

Paul,

I had to deal with this for Canada a while back, so I'll put in my $0.02
(about, what, $0.05 Cdn these days? ;-)

What I did - defined a couple of tax fields, consisting of a description and
a tax rate, and then also defined a few other parameters for those fields.
The first was an order, detailing in which order the taxes should be
applied.  The second was a boolean - compounded, or not.  Yes meant that the
tax applied to the total plus the previous tax(es), no meant it was just
based on the original total, pre-tax.  You may want to add an 'active' field
- ie, is this tax charged?  In my case, I just assumed that a blank tax name
meant it was not applicable.

Then, with the aid of a lookup table to set the values appopriately for each
province, I was set.  I'd assume that you'd be able to extend this to handle
other countries.

Good luck - I hope this helped.

Dirk




> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 30, 2002 10:03 AM
> To: CF-Talk
> Subject: OT: Calculating Taxes (at least not CFMX topic :)
> 
> 
> I tried to ask this one awhile back without a response... 
> hopefully someone
> will have an answer for me (or at least direct me in the 
> right direction).
> 
> We are trying to cover our international market allowing companies in
> Australia, Canada, Europe ect.. to use our shopping cart 
> system.  We have
> been trying to figure out the best most "generic" way to 
> setup our taxing
> structures.
> 
> For the United States, it is pretty simple, does the product 
> offer taxing or
> not?  and if so, what state and what is the tax rate for that 
> state (not
> perfect but currently it works for most companies). So 
> State_tax X Total
> Cart = Tax Charge
> 
> Now if the retailer is in Australia or Canada we get into 
> HST/GST/PST type
> taxes ...how do you compute those various types of taxes ... 
> Then there is
> the VAT?  Is it similar to US tax?
> 
> My last question would be what is a flat tax, I have seen 
> that around, but
> is it just what it says, ...example: $10.00 flat tax no 
> matter how much your
> cart total is?  Or is the flat tax added on to the other taxes?
> 
> Many questions and if anyone has any knowledge that they would like to
> share, by all means ..Share and I appreciate it!
> 
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector - Commerce Builder
> 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: Payment terms

[Dirk Sieber]

Thanks Jeffry - I've gone ahead & subscribed to cf-jobs talk as well, and 
I'll watch the discussion over there as well.  This should be my last 
comment about this on the CF-Talk list, unless others want it to continue 
here.

To offer some additional data points:
-Yes, this is an hourly project.
-We're probably talking limited hours - to start, at least - For example, 
the first two things presented to me will probably take, at a rough guess, 
only about 10 hours.
-I don't think the retainer fee is too likely for this project, but I'll 
keep it in mind for the future.

Thanks for all your comments, and the comments of others.  This is 
definitely giving me a lot more information to think about before I put 
anything in writing. :)

Does anyone have a copy of a rather generic contract that I might be able 
to modify to fit?  I realize that this won't be as good as talking to a 
lawyer, but it's bound to be better than anything I  come up with.

Dirk

At 01:18 PM 4/11/2002, Jeffry Houser wrote:
 >
 >  Check out cf-jobs talk.  It is designed more for topics like this.  ( I
 >cc-ed that list, so others may have additional thoughts)
 >
 >  I strongly recommend getting something in writing with the client (and/or
 >talking to a lawyer to have him draw up a standard contract).
 >
 >  If you can get it... decide upon a retainer fee. Something like: "I the
 >developer gets paid four million dollars a month for 6 months, and I'll
 >take care of all your web development needs.  (BTW, You can outsource all
 >the work to me for 1 million a month).
 >
 >  I've done a bunch of Net30 contracts (Net30 means that I get paid in 30
 >days) where I would provide invoices during the first week of the month and
 >payment would be due in 30 days.  I'm no longer a fan of these type of
 >contracts.  ( Call it a significant sum in unpaid invoices; I had to get a
 >lawyer involved in one case, and it looks like I may be sending more
 >business down his way).
 >
 >  It sounds like you are dealing with an hourly project.  Here are some
 >things I might do.  They may ( or may not ) apply to your situation.
 >   Get two full weeks in advance upon signing of the contract and reduce it
 >from the invoice at the end of the contract.
 >   Do invoicing once a month.
 >   Client has five days after delivery to approve the functionality.  "No
 >comment" is considered approval.
 >   Client has five days of additional support when the delivered code 
goes live
 >   Unpaid invoices will accrue a monthly fee (define it as a percentage,
 >make the percentage larger than what you are getting in your checking /
 >savings accounts )
 >

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Payment terms

[Dirk Sieber]

Hi everyone,

This is a little off-topic, but I'm hoping some of you might be able to 
give me some good advice.  I'm going to be entering in a formal agreement 
to perform some enhancement/bug fix work for a client on a casual, but 
ongoing basis, and they're asking me for my payment terms.  Now, in the 
past, I've either always been paid COD, or been someone's employee, so this 
is a bit new to me. :)

I'd welcome comments on what everyone thinks is a 'fair' amount of time for 
payment.  My first thought was 1 week from delivery for bug testing - if 
nothing is reported in that week, the client is assumed to have signed off 
on the work (if they don't do so sooner), and payment is due within 30 days.

Thoughts?  Comments?

Thanks!
Dirk

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: date massaging

[Dirk Sieber]

Looking at the docs, it says:
Returns a date/time object from a string. ParseDateTime converts date/time
strings that are in the U.S. date format. Use LSParseDateTime for
international date parsing. 

And also:
Year values 0 - 29 are interpreted as 21st century dates. Year values 30 -
99 are interpreted as 20th century dates. 

That seems to imply that (maybe?) it only handles 2-digit years... which
would be very odd, but I've seen dumber things...

Oh, okay - looking at the LSParseDateTime docs, it says (pardon the no-doubt
bad formatting):
-
When passing a date/time value for the English (US) locale, the date/time
string can be in any of the following forms:  date/time Composition Example 
dd  
 "25 January 1999" 
 
hh:mm:ss
 "8:30:00" 
 
hh:mm:ss
 "20:30:00" 
 
 dd,  hh:mm:ss
 "January 25, 1999 8:30:00" 
 
hh:mm:ss mmm. dd, 
 "8:30:00 Jan. 25, 1999" 
 
m/dd/ hh:mm:ss
 "1/25/1999 8:30:00"  
--

Looks like numbers without a separator aren't supported... :-(

Dirk
 

> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 27, 2002 3:16 PM
> To: CF-Talk
> Subject: re: date massaging
> 
> 
> Dave wrote,
> 
> > just wondering, is there a reason you wouldn't use 
> > parseDateTime() for this? it takes a string and converts 
> > it to a cf date.
> 
> If I try this:
> 
> 
> 
> #thedate# 
> 
> I get this:
> 
> ''The date parameter of function ParseDateTime(date), which 
> is 03042002, does not represent a valid date''
> 
> Despite the fact that if I test the string against IsDate() 
> it verifies just fine.
> 
> --Matt--
> 
>  
>  
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: INACCESSIBLE_BOOT_DEVICE error on Win2k

[Dirk Sieber]

Hi David,

You might want to take a look at this page:
http://www.windowsreinstall.com/install/other/motherboard/problems.htm

They discuss this exact issue, and a variety of possible solutions.

Dirk


> -Original Message-
> From: David Grabbe [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, March 10, 2002 8:29 AM
> To: CF-Talk
> Subject: WOT: INACCESSIBLE_BOOT_DEVICE error on Win2k
> 
> 
> Hello all,
> 
> This is not even remotely a CF question  :)  but the 
> contributors to
> this list have a broad range of experience, so I'm hoping 
> somebody has run
> into this before and has a solution.
> 
> One of our older Win2k machines went down -- the 
> m-board is fried
> (bad power supply) but the HD seems to be OK.  I tried 
> hooking up the old HD
> with a new m-board/processor.  When I try to boot up, Windows 
> starts going
> through its normal boot sequence, but then always 
> "blue-screens" with a STOP
> error message that says "INACCESSIBLE_BOOT_DEVICE".  I've 
> gleaned enough
> from MSDN to know that Win2k doesn't like it when there is a radical
> hardware change (i.e. different motherboard and proc), but 
> their suggestion
> to "reinstall Windows" isn't an option at this point.  Has 
> anyone run into
> this before?  Any solutions?
> 
> Greatly appreciative,
> David
> 
> 
> 
> 
> David Grabbe
> Manager, Information Systems
> Church of the Great God
> [EMAIL PROTECTED] 
> http://www.cgg.org 
> 
> 
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Intranet apps

[Dirk Sieber]

If anyone's really stuck on this, it's pretty simple.
1) Go to weather.com
2) Do a search for the city you're looking for (eg, London, England)
3) Once you get to it's forecast page, click on the "printable forecast"
link under the "10 Day forecast" heading (lower left).
4) Look at the URL - this is the page you want to get.  In London's case,
it's:
http://www.weather.com/weather/local/UKXX0085

BTW, my thanks to Robert - your example got me interested in CFHTTP, and in
about 5 minutes, I managed to throw together a short routine that extracts
the weather for Vancouver, BC from www.theweathernetwork.com.  It's a bit
more complicated, since I'm stripping out the ad banner, and left and right
menu bars, but it's still basically only 4 lines of code.

I've only been working with CF for about 2 months, and I keep being amazed
at how simple things are...

Dirk


> -Original Message-
> From: John McCosker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 07, 2002 12:20 PM
> To: CF-Talk
> Subject: RE: Intranet apps
> 
> 
> >>
> 
> What if its the UK, or somewhere else that the US?
> 
> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 07, 2002 8:05 PM
> To: CF-Talk
> Subject: RE: Intranet apps
> 
> 
> Weather
> 
> 
>  URL="http://www.weather.com/weather/tendayprint/#Attributes.ZipCode#";
> METHOD="GET"
> PORT="80"
> RESOLVEURL="true">
>   
>  "HREF=""http://www.weather.com/";, "ALL")>   
> 
> 
> #OutPut#
> 
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
> 
> -Original Message-
> From: Bruce Holm [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 07, 2002 3:00 PM
> To: CF-Talk
> Subject: Re: Intranet apps
> 
> 
> I was looking for a conference room signup app only.  This would be a
> corporate wide, web browser accessible application.  Outlook requires 
> LDA
> P I
> believe and our company does not plan to run or support it. 
> (Don't ask 
> wh
> y)
> 
> For weather I'm aware of AccuWeather data feed in XML format but not 
> sure
> what they would charge.  I was hoping for a free app I could 
> integrate 
> in
> to
> the home page that shows current weather conditions for a local city, 
> lik
> e
> MyExite or MyLycos offers.
> 
> 
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 07, 2002 11:37 AM
> Subject: RE: Intranet apps
> 
> 
> > here's a few ideas:
> >
> > Conference room scheduler:  Do you use Outlook?  If so, make the
> > conference
> > room a person, and have people "invite" the conference room to
> > meetings.
> > Give an admin rights to handle the conference rooms schedule.  Make 
> the
> > schedule visible to all.
> >
> > There are a few sites that have data feeds of info that you can 
> legally
> > post
> > on your own site.  You want to look at www.moreover.com.  
> You can use
> >  to get the info.
> >
> > Kathryn Butterly
> > Web Developer
> > Washington Mutual Finance
> > 813 632-4490
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > From: Bruce Holm [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 07, 2002 2:30 PM
> > To: CF-Talk
> > Subject: Intranet apps
> >
> >
> > Does anyone know of a source for applications that can be integrated
> > into an Intranet?
> >
> > I'm looking for:
> >
> > * a conference room scheduler application
> >
> > * a weather application to display local weather conditions in real
> > time
> > in the corner of the Intranet home page
> >
> > * a stock ticker application that can be configured to only display 
> our
> >
> > company stock price movement (delayed quotes is fine) 
> during the day.
> >
> > Any help would be appreciated.
> >
> > -
> > Bruce Holm - Web Programmer
> > Lattice Semiconductor Corp.
> > [EMAIL PROTECTED]
> > -
> >
> >
> >
> > 
> 
> 
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: (ot) SQL Brain Fart

[Dirk Sieber]

Putting a 'distinct' into the select below should do it.  It sounds 
like you
have more than one record matching in your second table, which is why 
you're
getting multiples.

Dirk


> -Original Message-
> From: Owens, Howard [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 25, 2002 11:52 AM
> To:   CF-Talk
> Subject:  RE: (ot) SQL Brain Fart
> 
> Thanks for the quick responses, guys.
> 
> As for the query below -- that was my original query. Got multiples 
> with it,
> too.
> 
> I'll try C. Hatton Humphrey's suggestion -- after lunch.
> 
> H.
> 
> 
> Howard Owens
> Internet Operations Coordinator
> www.insidevc.com
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
> 
> 
> > -Original Message-
> > From:   Christopher Olive [SMTP:[EMAIL PROTECTED]]
> > Sent:   Friday, January 25, 2002 11:55 AM
> > To: CF-Talk
> > Subject:RE: (ot) SQL Brain Fart
> > 
> > why are you doing a subselect?  it's extremely slow compared to a 
> direct
> > join.
> > 
> > SELECT
> > t1.firstname
> > FROM
> > table1 t1, table2 t2
> > WHERE
> > t1.tableid = t2.tableid AND
> > t2.status = 'Paid'
> > 
> > 
> > 
> > christopher olive, cto, vp of web development
> > cresco technologies, inc
> > 410.825.0383
> > http://www.crescotech.com
> > 
> > 
> > -Original Message-
> > From: Owens, Howard [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, January 25, 2002 2:43 PM
> > To: CF-Talk
> > Subject: (ot) SQL Brain Fart
> > 
> > 
> > I'm just blanking out on how to do this query.
> > 
> > The query below is returning multiple duplicates of records.  I 
can't
> > figure
> > out why.  It looks to me like it shouldn't. Obviously, I'm missing
> > something:
> > 
> > SELECT FirstName
> > FROM table1
> > WHERE TableID IN ( SELECT TableID
> > FROM Table2
> > WHERE Status = 'Paid')
> > 
> > 
> > Obviously, I want only one copy of each record.
> > 
> > 
> > 
> > 
> > Howard Owens
> > Internet Operations Coordinator
> > www.insidevc.com
> > [EMAIL PROTECTED]
> > AIM: GoCatGo1956
> > 
> > 
> > 
> > 
> 
> 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Strange Inserts into MySQL database

[Dirk Sieber]

I ran across this on a tutorial site a few days ago - it's billed as a 
way
to stop this exact problem.  Hopefully this will help - I haven't 
gotten
around to trying it myself yet.

Dirk







How to block multiple form submits.






Dummy Form.












> -Original Message-
> From: Chad Gray [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 17, 2002 12:52 PM
> To:   CF-Talk
> Subject:  Re: Strange Inserts into MySQL database
> 
> I have come closer to figuring out how there are two updates running.
> 
> On a SGI Irix box running Netscape the user can double click the 
submit 
> button on the form.  I looked in the web log files and saw this:
> 
> 127.0.0.1, -, 1/16/02, 20:14:03, W3SVC, SERVER, 127.0.0.1, 172, 513, 
504, 
> 200, 0, POST, /employee/JOBLOGIN.CFM, -,
> 127.0.0.1, -, 1/16/02, 20:14:03, W3SVC, SERVER, 127.0.0.1, 203, 513, 
504, 
> 200, 0, POST, /employee/JOBLOGIN.CFM, -,
> 
> Is there any way to keep people from double clicking on the submit 
button 
> and getting two POSTs?
> 
> 
> 
> At 07:39 PM 1/16/2002 -0500, you wrote:
> >I am getting strange inserts every once and while.  Not all the 
time, it
> >has only happened 3 times in the last 4 months.  What is happening 
is
> >somehow people are getting two (one time a person got 40+) inserts 
into
> the
> >table when they should only get one insert.  Tonight i added a 

> >around the entire process, but im not sure if that will help.
> >
> >Why, or how could the insert run more then once?
> >Is there a better way to write the following code?
> >
> >
> >
> >
> >SELECT JOBNUM, EMPLOYEENUM, LOGOUT, LOGIN
> >FROM ACTIVITYLOG
> >WHERE (JOBNUM = #FORM.JOBNUM#) AND (EMPLOYEENUM = 
#FORM.EMPLOYEENUM#) 
>  AND
> >(LOGOUT is null) AND (LOGIN is not null)
> >
> >
> >
> >
> >
> >
> >INSERT INTO ACTIVITYLOG(
> 
>ACTIVITYDESCRIPTION,ACTIVITYID,COSTPERHOUR,JOBNUM,EMPLOYEENUM,EMPLOYEEN
AM
> E,
> LOGIN)
> >VALUES
> 
>('#ACTIVITYLOOKUP.ACTIVITYDESCRIPTION#','#ACTIVITYLOOKUP.ACTIVITYID#',#
AC
> TI
> 
VITYLOOKUP.COSTPERHOUR#,#FORM.JOBNUM#,#FORM.EMPLOYEENUM#,'#FORM.EMPLOYEE
NA
> ME
> #',#NOW()#)
> >
> >
> >
> >
> >
> >Thanks,
> >Chad
> >
> >
> 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: failure?

[Dirk Sieber]

Shouldn't this be reversed?  I'd think the arguements should go the 
other
way around...  (Assuming you're looking for the word 'Rework' in
Client.TravType, which seems to be what you're doing).

Dirk


> -Original Message-
> From: Brian Scandale [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 12:59 PM
> To:   CF-Talk
> Subject:   failure?
> 
> This tag does not seem to work like I would expect. Can anyone shed 
some
> light? Very little in the docs about this. I quote the only 
reference...
> 
> "CONTAINS determines whether the value on the left is contained in 
the
> value on the right. Returns true if it is."
> 
> 
> 
> 
> The above example returns true if client.travtype = "REWORK" 
> but returns false if it = "REWORK LOOP"
> 
> thank you
> 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists