date:20040721

>I'm looking for information related to best-practices or tips and
>tricks.  I'm sure there are things that MACR hasn't covered in their
>documentation.

I run Enterprise on my servers. I don't have anything setup in the J2EE config today (where you can run multiple instances) but I plan to setup a new set of servers coming in soon under that config. I also like the archive and deploy features. I'm not sure if that's an enterprise-only feature, but it is great for deploying the same application to multiple servers. It allows you to copy everything- server settings, dsn's, application folders. 

I would also look at deploying against Websphere or another J2EE package if you go the Enterprise route. JRun is fine, but as you scale you may want something more robust. I haven't gone that route yet, but it is under consideration. My company has a very strong relationship with IBM so we would probably go with Websphere (which is supposed to be the fastest, most robust J2EE server for CF Enterprise anyway). Licensing costs are obviously a consideration, but the truth is the license costs are a small part of the overall investment in enterprise Web apps.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Need Help Bad!!

2004-07-21 Thread Matthew Walker

Well there are really two parts to this problem: how the form would work,
and what the interface would look like. One simple way to do it would simply
be to generate a lot of order lines (i.e. more than you need, say 100 or so)
and hide most of them using style="display:none", then just reveal the next
one as needed. I presume you need a field for product SKU or whatever along
with quantity. So I'd simply label the fields like this:

sku_1, sku_2, sku_3,. and qty_1, qty_2, qty_3,.. You can then in your
handler page loop through the full set of 100 or so fields, and access the
values..









Add this order line to the database







  _  

From: Kevin Rosenthal [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 22 July 2004 8:29 a.m.
To: CF-Talk
Subject: Need Help Bad!!

Hi everyone,

OK, here is my problem. I am a very new ColdFusion programmer and I have
been asked to write an Order Entry program for my fathers Clothing
Manufacturing Company. I have my tables all set using one for the main order
detail and another for the detail lines. I also have a customer table to
hold that info. Here is the hold up. I want to create an entry screen for
the order where the user can enter as many detail lines as they like without
having to redraw the screen after each line. I was thinking of putting the
detail lines into an array to be written to the DB once the order page is
complete. 

Any help or suggestions??

Thanks,
Kevin

-- 
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.253 / Virus Database: 263.4.7 - Release Date: 7/19/2004

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

Resources for CF MX Enterprise

2004-07-21 Thread Dawson, Michael

Other than the LiveDocs, can anyone point me to information about the
Enterprise class of CFMX?  Our new VP is asking me and the other web
developer to place both of our sites on the same server.  He also
requires that we use Windows 2003 Network Load Balancing.

 
To allow for the clustering, we have gotten approval for a couple
licenses of CF Enterprise.  Other than the too-high cost, this product
is awesome.  I love the ability to create multiple instances and assign
an instance to an individual web site.

 
I'm looking for information related to best-practices or tips and
tricks.  I'm sure there are things that MACR hasn't covered in their
documentation.

 
Thanks for any help!

 
M!ke
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

CF Hack

2004-07-21 Thread Paul Wilson

Hi 

 
I've had the following files uploaded to one of my dev servers

 
get_registry_keys.cfm
kill_keys_commit.cfm
make_keys.cfm

 
Anyone seen this before?

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

Re: Strange dynamic Evaluate function

2004-07-21 Thread Don

Never mind, I have a fix to it.

> calculation and dynamic evaluation:
> 
> 
> 
> 
> 
> 
> 
> 
> 
> the above would fail while the line below (without dynamic evaluation) 
> won't.
> 
> 
> 
> I guess, CF fails to evaluate/ignore "*" and the like, so, it breaks 
> right here.  Fix, alternative?  Where am I?  
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Strange dynamic Evaluate function

2004-07-21 Thread Don

calculation and dynamic evaluation:









the above would fail while the line below (without dynamic evaluation) won't.



I guess, CF fails to evaluate/ignore "*" and the like, so, it breaks right here.  Fix, alternative?  Where am I?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Urgent help needed Please Simon.....

2004-07-21 Thread Sangeeta Karmokar

Can anyone help me

I am new to CF. we have backend as MySql and I am trying to inser into 
a database created in SQL using this query: 

  
 
  
INSERT INTO members 
  
(name,email) 
  
VALUES ('#name#','#email#') 

  
But it is not adding to the database, the submit is just going to the 
query page and we can see all these codes in browsers... 

I think the problem will be as u mentioned coldfusion is not parsing c
ode before handing it over to the webserver. we are working on Mac OS 
X with MySql. 

How to fix this problem... 
I really need help... 

  
Sangeeta

>Yes Simon I have closed the query, I forgot to paste it and I have sav
>ed as thanks.cfm. 
>I think the problem will be as u mentioned coldfusion is not parsing c
>ode before handing it over to the webserver. we are working on Mac OS 
>X with MySql. 
>
>How to fix this problem...
>
>It was working fine on PC, this is the first time we are 
>trying on Mac OS X. 
>
>Sangeeta 
>
>
>
>>Simon
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Odd db error

2004-07-21 Thread Rob

On Wed, 21 Jul 2004 14:35:05 -0700, Nathan Strutz <[EMAIL PROTECTED]> wrote:
> Rob,
> 
> This could be a few little things, but most importantly, hit up the CFMX
> hot fixes page:
> 
> http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm
> 
> and make sure you have the latest database drivers (v 3.3). While you're
> there, you may want to look into all the other ones. I do really
> recommend you install them all, especially anything related to
> databases, cfquery and cfqueryparam.

Updated the macromedia_drivers.zip one and that seems to have cleared
up the problem. Time will tell, but it looks good.

Thanks Nathan :)

-- 
~The cfml plug-in for eclipse~
http://cfeclipse.tigris.org 
~open source xslt IDE~
http://treebeard.sourceforge.net
~open source XML database~
http://ashpool.sourceforge.net
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Still having trouble making CFMX stable

>What do you use for load Balancing?
>

Cisco Content Manager, the old Arrowpoint stuff. Nice product. Like so many things Cisco sells it has a cryptic command-line interface, but it works very well.

Also, I will note that under current conditions with 2 GB of RAM per server, the servers only go down every couple of weeks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: MySQL cfqueryparam single quote problem

2004-07-21 Thread Jochem van Dieten

Philip Arnold wrote:

> Not sure if this has been answered (Gmail hasn't grouped any responses)
> 
> Anyways, CFQUERYPARM can have a problem with putting functions inside
> of it's VALUE attribute, so I'd say do the UPPER() before you run the
> query, and then use that

http://www.macromedia.com/support/coldfusion/ts/documents/quotes_hotfix.htm

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

Re: UDF within a Custom Tag

2004-07-21 Thread Raymond Camden

It is definitely a bug. It was fixed in either 6.0 or 6.1. And thank
goodness it was. :)

-Ray

On Wed, 21 Jul 2004 17:23:32 -0400, Jamie Jackson <[EMAIL PROTECTED]> wrote:
> On Wed, 21 Jul 2004 15:39:19 -0500, in cf-talk you wrote:
> 
> >Jamie - If you are on CF5 you only have 2 choices really...
> >
> >Use the request scope. You would define the UDF in the request BEFORE
> >you call the custom tag. Ie, Application.cfm may cfinclude a file of
> >UDFs where each UDF is copied to the request scope. You would call the
> >UDF in the CT by using request.foo()
> >
> >In the custom tag, use cfinclude to include the file only in
> >executionMode = start.
> 
> Hi Ray,
> 
> I am already using the request scope, I just wanted to know what/if I
> was doing wrong when trying the UDF declaration within the CT. Since
> what I was doing is *theoretically* right, I'm satisfied to consider
> this a bug, and will continue to use the request scope workaround.
> 
> Thanks for validating the request scope workaround and offering the
> second (cfinclude) workaround.
> 
> So, umm, "case closed" or something. ;-)
> 
> Thanks,
> Jamie
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Odd db error

2004-07-21 Thread Nathan Strutz

Rob,

This could be a few little things, but most importantly, hit up the CFMX 
hot fixes page:

http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm

and make sure you have the latest database drivers (v 3.3). While you're 
there, you may want to look into all the other ones. I do really 
recommend you install them all, especially anything related to 
databases, cfquery and cfqueryparam.

-nathan

Rob wrote:

> I've just finished updating a site from MX6.0 to MX6.1 and there is a
> (very very) long process that will eventually throw the following
> error into the exception log, but never stops the request - it just
> hangs the resources.
> 
> "Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]No
> more data available to read. The specific sequence of files included
> or processed is: \blahblah.cfm "
> coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing
> Database Query.
> 
> I've searched google and haven't found much. This is a schedule task
> process that runs at like 3:00AM so I'd like it not to do that :)
> 
> There are ... several ... thing that the code should do that it
> doesn't (like db timeouts and such), but I am asked why it worked in 6
> and not 6.1 (this app is going away and they don't really want to
> rewrite large portions of the code)
> 
> Winders2K
> MX Version: 6,1,0,63958
> SQL2K
> 
> Any help / pointers / links would most appreciated
> 
> Thanks
> Rob
> 
> -- 
> ~The cfml plug-in for eclipse~
> http://cfeclipse.tigris.org
> ~open source xslt IDE~
> http://treebeard.sourceforge.net
> ~open source XML database~
> http://ashpool.sourceforge.net
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

On Wed, 21 Jul 2004 15:39:19 -0500, in cf-talk you wrote:

>Jamie - If you are on CF5 you only have 2 choices really...
>
>Use the request scope. You would define the UDF in the request BEFORE
>you call the custom tag. Ie, Application.cfm may cfinclude a file of
>UDFs where each UDF is copied to the request scope. You would call the
>UDF in the CT by using request.foo()
>
>In the custom tag, use cfinclude to include the file only in
>executionMode = start.

Hi Ray,

I am already using the request scope, I just wanted to know what/if I
was doing wrong when trying the UDF declaration within the CT. Since
what I was doing is *theoretically* right, I'm satisfied to consider
this a bug, and will continue to use the request scope workaround.

Thanks for validating the request scope workaround and offering the
second (cfinclude) workaround.

So, umm, "case closed" or something. ;-)

Thanks,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Register a dsn in coldfusion code

2004-07-21 Thread Julia Young

This is the function that I wrote when I execute it the datasource shows up in the administrator but when i try to verify it there is an error. The administrator knows the name of the datasource and where the file is but it just doesn't recognize it as a registered datasource.


		
		
		
		
			factory = CreateObject("java", "coldfusion.server.ServiceFactory");
			
			datasources = factory.datasourceservice.getDataSources();
		
	
		

		
		
		
		
		
		
		
		
		
		
		
		
		
			
		
		
		
		
	

I tried adding the store and restart methods but I still got the same error. I also tried the method you used (with a minor change for ms access) but sadly, the same error.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Odd db error

2004-07-21 Thread Rob

I've just finished updating a site from MX6.0 to MX6.1 and there is a
(very very) long process that will eventually throw the following
error into the exception log, but never stops the request - it just
hangs the resources.

"Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]No
more data available to read. The specific sequence of files included
or processed is: \blahblah.cfm "
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing
Database Query.

I've searched google and haven't found much. This is a schedule task
process that runs at like 3:00AM so I'd like it not to do that :)

There are ... several ... thing that the code should do that it
doesn't (like db timeouts and such), but I am asked why it worked in 6
and not 6.1 (this app is going away and they don't really want to
rewrite large portions of the code)

Winders2K
MX Version: 6,1,0,63958
SQL2K

Any help / pointers / links would most appreciated

Thanks
Rob

-- 
~The cfml plug-in for eclipse~
http://cfeclipse.tigris.org 
~open source xslt IDE~
http://treebeard.sourceforge.net
~open source XML database~
http://ashpool.sourceforge.net
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Well if you want them to keep adding line items without refreshing the screen then you could use DHTML to update a layer with each new line item added. At the same time you could add the the line item details to to hidden form field values holding lists of product IDs and quantities via _javascript_.

That way it's all done client side until the "checkout" button is pressed...then you have the hidden form field data to parse through and insert the order details into the DB.

HTH

Cheers

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

- Original Message -
From: Kevin Rosenthal
To: CF-Talk
Sent: Wednesday, July 21, 2004 1:29 PM
Subject: Need Help Bad!!

Hi everyone,

OK, here is my problem. I am a very new ColdFusion programmer and I have
been asked to write an Order Entry program for my fathers Clothing
Manufacturing Company. I have my tables all set using one for the main order
detail and another for the detail lines. I also have a customer table to
hold that info. Here is the hold up. I want to create an entry screen for
the order where the user can enter as many detail lines as they like without
having to redraw the screen after each line. I was thinking of putting the
detail lines into an array to be written to the DB once the order page is
complete.

Any help or suggestions??

Thanks,
Kevin

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.253 / Virus Database: 263.4.7 - Release Date: 7/19/2004
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]

Re: Need Help Bad!!

2004-07-21 Thread Tony Weeg

why rebuild the wheel, there are plenty of shopping cart apps, that
you could probably hack around to get what you want, and then from
there, you could LEARN alot about application setupjust an idea.

http://www.quilldesign.com/

look for sitedirector, it rocks!

tw

On Wed, 21 Jul 2004 16:29:05 -0400, Kevin Rosenthal
<[EMAIL PROTECTED]> wrote:
> Hi everyone,
> 
> OK, here is my problem. I am a very new ColdFusion programmer and I have
> been asked to write an Order Entry program for my fathers Clothing
> Manufacturing Company. I have my tables all set using one for the main order
> detail and another for the detail lines. I also have a customer table to
> hold that info. Here is the hold up. I want to create an entry screen for
> the order where the user can enter as many detail lines as they like without
> having to redraw the screen after each line. I was thinking of putting the
> detail lines into an array to be written to the DB once the order page is
> complete.
> 
> Any help or suggestions??
> 
> Thanks,
> Kevin
> 
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG Anti-Virus (http://www.grisoft.com).
> Version: 7.0.253 / Virus Database: 263.4.7 - Release Date: 7/19/2004
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

2004-07-21 Thread Raymond Camden

Jamie - If you are on CF5 you only have 2 choices really...

Use the request scope. You would define the UDF in the request BEFORE
you call the custom tag. Ie, Application.cfm may cfinclude a file of
UDFs where each UDF is copied to the request scope. You would call the
UDF in the CT by using request.foo()

In the custom tag, use cfinclude to include the file only in
executionMode = start.

Both of those will work.

On Wed, 21 Jul 2004 16:02:03 -0400, Jamie Jackson <[EMAIL PROTECTED]> wrote:
> On Wed, 21 Jul 2004 15:53:27 -0400, in cf-talk you wrote:
> 
> >>>I just tried your suggestion, and it behaved the same as if I didn't
> >
> >I encountered the same problem once and no suggestion was able to get around the problem.
> >It looks like the function is compiled twice, no matter any CFIF you may put aroud it,
> >even 
> 
> Yup, that's what I'm seeing.
> 
> Thanks for confirming the behavior,
> Jamie
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: DB field setup

2004-07-21 Thread daniel kessler

OK, this is what I came up with.  There are actually two lookups, so 4 tables.  I'd appreciate it someone would look them over.

create table PEOPLE_DEPT (
    id NUMBER Primary Key,
    dept VARCHAR2(100)
)

create table PEOPLE_JOBTYPE (
    id NUMBER Primary Key,
    jobType VARCHAR2(100)
)

create table PEOPLE_USERS (
    id NUMBER Primary Key,
    dateModified date,
***DO I REMOVE THIS REFERENCE? AND THE DEPT ONE?***
    jobType_id NUMBER Foreign Key REFERENCES PEOPLE_JOBTYPE(id),  
    fname VARCHAR2(100),
    lname VARCHAR2(100),
    title VARCHAR2(100),
    dept NUMBER Foreign Key REFERENCES PEOPLE_PEOPLE_DEPT(id),
    phone VARCHAR2(50),
    location VARCHAR2(200),
    email VARCHAR2(100),
    summary VARCHAR2(3000),
    imagePath VARCHAR2(200),
    link VARCHAR2(200)
)

create table PEOPLE_GROUP (
    recordID NUMBER Primary Key,
    user_id NUMBER Foreign Key REFERENCES PEOPLE_USERS(id)
    dept_id NUMBER Foreign Key REFERENCES PEOPLE_DEPT(id)
    jobType_id NUMBER Foreign Key REFERENCES PEOPLE_JOBTYPE(id)
	
)

So then, if they have multiple checkboxes selected for jobType and Dept, then I add them once for each jobType and once for each Dept, conceivably adding someone to the DB 8 times.

Is this right?

>No, I'm suggesting the following:
>
>GROUPS
>GroupID	GroupName
>1		Family Studies
>2		Kinnesiology
>
>USERS
>UserID	UserName
>1		John Burns
>2		Daniel Kessler
>
>USERGROUPS
>UserID	GroupID
>1		1
>2		1
>2		2
>
>Which would mean that John Burns is in Family Studies while Daniel
>Kessler is in Family Studies and Kinnesiology.  I hope that helps.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Need Help Bad!!

2004-07-21 Thread Kevin Rosenthal

Hi everyone,

 
OK, here is my problem. I am a very new ColdFusion programmer and I have
been asked to write an Order Entry program for my fathers Clothing
Manufacturing Company. I have my tables all set using one for the main order
detail and another for the detail lines. I also have a customer table to
hold that info. Here is the hold up. I want to create an entry screen for
the order where the user can enter as many detail lines as they like without
having to redraw the screen after each line. I was thinking of putting the
detail lines into an array to be written to the DB once the order page is
complete. 

 
Any help or suggestions??

 
Thanks,
Kevin

-- 
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.253 / Virus Database: 263.4.7 - Release Date: 7/19/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Ecommerce site work...

2004-07-21 Thread Andrew Spear

I second the vote for SiteDirector (http://www.quilldesign.com).  Used it for several sites.  Cheap and effective.

Andrew

>Hello,
> 
>I am not sure if there was a mail alias at HOF  to direct this to.So please
>don't be peeved, maybe you can direct me to some good sites? Is there a
>place anyone knows of where I can find a (mostly) pre-made eCommerce
>web-site for sale? I need a login, shopping cart, dynamic database,
>automated emails for certain things,etc... and a few other items.
>I would like to just use something pretty much pre-made and just change my
>colors, headmast graphics,etc... and be done with it.
>Even if it was not a site for CF would be ok like php/mysql or whatever...
>I can tweak some of the code for my emails,etc... but I cannot build the
>whole thing on my own.
>I did find one such site but if I ever go to a different hosting company I
>can only take my database with me , not the site.
>
>~/Wayne
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Send Fax through Internet

2004-07-21 Thread Matthew Fusfield

Have you considered J2 (http://www.j2.com/)? I use their service
mainly to receive faxes, but their sending rates are reasonable and
very easy to use. It works entirely via email, and can accept
attachments such as PDF, Word, or HTML.

Matt

On Wed, 21 Jul 2004 12:41:04 -0400, Anne Girardeau <[EMAIL PROTECTED]> wrote:
> I'm interested in setting up an application that will allow news releases to be faxed to various media outlets.  My question is, does anyone know of a good application or service that will allow me to accomplish this?  Any help would be appreciated.
> 
> 
> 
> --Anne
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Still having trouble making CFMX stable

2004-07-21 Thread Ken Ferguson

Brook, can you tell if this is happening on any specific template? A lot
of people might remember the issue I had (which nobody was ever able to
figure out) several months ago; Jrun was dying every few minutes. I
mean, it just died and restarted. Actually, the error was "unable to
connect to JRun...", but the CFMX was actually dying and restarting. 

This is going to make you scratch your head too. I figured out what was
causing it. Actually, that's not exactly true. I figured out what bit of
code was causing it, but not WHAT was causing it. I had a cfinclude in
my header.cfm file that was just one of many. There wasn't ANYTHING
complex in this file, just some content. When I removed this cfinclude
from the file and pasted the code into it, all worked fine. When I
created a new file and cfincluded that it broke again. I couldn't figure
it out. I asked everyone in the world I could find (several CFUG lists)
and they all said, "damn, that's strange - it doesn't make any sense."
But it was happening, so I just pasted the code in instead of including
it and it hasn't happened again. It's been several months. I'm serious
when I say that there wasn't anything complex happening in there. The
ONLY cf tag in the whole bit of code, was a cfif statement wrapped
around and image. The only reason I ever found this is that I just
happened to remember that I had recently stripped out that code and put
it in an included file and I realized that I had done that at around the
time it all started. So, even though I knew it COULDN'T be that, I
changed it and...

Sorry to be of ABSOLUTELY NO HELP whatsoever, but maybe you have this
same kind of thing happening.



  _  

From: Brook Davies [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 12:08 PM
To: CF-Talk
Subject: RE: Still having trouble making CFMX stable

I've installed almost all the patches. All the ones that look like the
are 
relevant and would cause major issues. I might just go ahead and install

the rest of them tonight (dev server first) just to be sure. I don't
really 
know what else to check because I am not seeing jack in the logs..

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

Re: UDF within a Custom Tag

On Wed, 21 Jul 2004 15:53:27 -0400, in cf-talk you wrote:

>>>I just tried your suggestion, and it behaved the same as if I didn't
>
>I encountered the same problem once and no suggestion was able to get around the problem.
>It looks like the function is compiled twice, no matter any CFIF you may put aroud it,
>even 

Yup, that's what I'm seeing.

Thanks for confirming the behavior,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Still having trouble making CFMX stable

errr... thanks ;)

At 12:39 PM 7/21/2004, you wrote:
>Brook, can you tell if this is happening on any specific template? A lot
>of people might remember the issue I had (which nobody was ever able to
>figure out) several months ago; Jrun was dying every few minutes. I
>mean, it just died and restarted. Actually, the error was "unable to
>connect to JRun...", but the CFMX was actually dying and restarting.
>
>This is going to make you scratch your head too. I figured out what was
>causing it. Actually, that's not exactly true. I figured out what bit of
>code was causing it, but not WHAT was causing it. I had a cfinclude in
>my header.cfm file that was just one of many. There wasn't ANYTHING
>complex in this file, just some content. When I removed this cfinclude
>from the file and pasted the code into it, all worked fine. When I
>created a new file and cfincluded that it broke again. I couldn't figure
>it out. I asked everyone in the world I could find (several CFUG lists)
>and they all said, "damn, that's strange - it doesn't make any sense."
>But it was happening, so I just pasted the code in instead of including
>it and it hasn't happened again. It's been several months. I'm serious
>when I say that there wasn't anything complex happening in there. The
>ONLY cf tag in the whole bit of code, was a cfif statement wrapped
>around and image. The only reason I ever found this is that I just
>happened to remember that I had recently stripped out that code and put
>it in an included file and I realized that I had done that at around the
>time it all started. So, even though I knew it COULDN'T be that, I
>changed it and...
>
>Sorry to be of ABSOLUTELY NO HELP whatsoever, but maybe you have this
>same kind of thing happening.
>
>
>
>   _
>
>From: Brook Davies [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, July 21, 2004 12:08 PM
>To: CF-Talk
>Subject: RE: Still having trouble making CFMX stable
>
>I've installed almost all the patches. All the ones that look like the
>are
>relevant and would cause major issues. I might just go ahead and install
>
>the rest of them tonight (dev server first) just to be sure. I don't
>really
>know what else to check because I am not seeing jack in the logs..
>
>Brook
>
>At 09:24 AM 7/21/2004, you wrote:
> >Are you saving your class files?  Is your server fully patched? We had
>a
> >nightmare with MX behaving badly when we first installed it but it all
>seems
> >fine now after a few tweaks and debug effort...
> >
> >We found that it was out client vars causing problems when stored in
>the
> >registry..
> >
> >
> >
> >    _
> >
> >From: Brook Davies [mailto:[EMAIL PROTECTED]
> >Sent: 21 July 2004 17:11
> >To: CF-Talk
> >Subject: Still having trouble making CFMX stable
> >
> >I am still getting daily crashes, today our webserver has crashed
>twice.
> >Today what happened the first time was that IIS 5.0 (on win2k) crashes
>and
> >was automatically restarted by the service recovery setting. However,
>the
> >connection to Jrun was lost and requests to cfm pages returned the
>unable
> >to connect to jrun error.
> >
> >Also, I have been getting crashes where jrun.exe continues to run but
>all
> >requests for cfm pages return the same unable to connect to jrun error
>as
> >though the service was not running. IIS did not crash, the connection
>to
> >jrun was apparently just lost.
> >
> >I took some of the advise I got last week and increased the max heap to
>756
> >megs and also brought the minimum up aswell. I also added some hourly
> >cleanup scripts to remove data from the application scope, and this
>does
> >seem to be keep memory usage a bit lower.
> >
> >I've been through all the log files and there is nothing that stands
>out. I
> >don't know what else do to except possibly rebuild the server.
> >
> >Brook
> >
> >    _
> >
> >--
> >[Todays Threads]
> >[This Message]
> >[Subscription]
> >[
>Fast
> >  Unsubscribe] [User Settings]
> >[
>on&business=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclic
>k>Donations
> >and Support]
> >
> >--
> >
> >42c8eb8.jpg
> >
>
>   _
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[Fast 
>  Unsubscribe] [User Settings] 
>[Donations 
>and Support]
>
>--
>
>[]
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

On Wed, 21 Jul 2004 12:43:39 -0700, in cf-talk you wrote:

>You can also just do isdefined('doTocOption') to see if the function has 
>been created.

Normally, maybe; however, not within the context of a Custom Tag (it
just doesn't work). :-/

Thanks,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

On Wed, 21 Jul 2004 15:39:05 -0400, in cf-talk you wrote:

>Shouldn't you be doing this?
>
>
>
>  function doTocOption(myQuery, contextFilePrefix) { 
>    ...
>  }
>
>

Yes, sorry, just a typo in the post, but not in my experiment.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Urgent help needed Please Simon.....

2004-07-21 Thread Sangeeta Karmokar

Yes Simon I have closed the query, I forgot to paste it and I have sav
ed as thanks.cfm. 
I think the problem will be as u mentioned coldfusion is not parsing c
ode before handing it over to the webserver. we are working on Mac OS 
X with MySql. 

How to fix this problem...

It was working fine on PC, this is the first time we are 
trying on Mac OS X. 

Sangeeta 

>Yes Simon I have closed the query, I forgot to paste it and I have 
> saved as thanks.cfm.
> I think the problem will be as u mentioned coldfusion is not parsing 
> code before handing it over to the webserver. we are working on Mac OS 
> X with MySql. It was working fine on PC, this is the first time we are 
> trying on Mac.
> 
> Sangeeta 
> 
> >On Tue, 20 Jul 2004 17:21:17 -0400, Sangeeta Karmokar
> ><[EMAIL PROTECTED]> wrote:
> >
> >If I understand correctly you are able to view the raw cf code in 
> your
> >browser - is that correct? If so, then coldfusion is not parsing the
> >code before handing it over to  the webserver. 1st things first - is
> >the page called something.cfm? If not, change it to a cfm extension
> >and then try again.  If not - what web server are you using and on
> >which platform.
> >Also, you forgot to close your cfquery tag up there - could that be 
> a
> >simpler answer?
> >
>Simon
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

2004-07-21 Thread Claude Schneegans

>>You can also just do isdefined('doTocOption') to see if the function has
been created.

No matter what you test in the CFIF, even , the function will be compiled,
once on start, and once on end.
IMO It is definitely a bug.

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

One-to-Many Query and Nav Question

2004-07-21 Thread hammerin hankster

I've got a one-to-many table (Clients and Occupants) and I'd like to build an interface screen similar to what Access forms provides. That is, I can navigate the occupants using the prev/next button and I can also navigate the clients using a differnet prev/next button.  

Here's my query to pull all the clients and associated occupant data.


SELECT  DISTINCT occupantid, tbloccupants.clientname, occname, occtype, ext, tbloccupants.acctstatus, suiteid, dddid,
 occcell, occemail, occphserial, occemail, occremoteoffice, occhome, occpager, occvmbox, accesscardno, cardassigned,
 cardreturned, nokeys, furnitureno, dateentered, tbloccupants.comments, occip
FROM  tblMasterClients, tbloccupants

where   tblmasterclients.clientname = tbloccupants.clientname

ORDER BY tbloccupants.clientname


Make sense?

Thanks!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

2004-07-21 Thread Claude Schneegans

>>I just tried your suggestion, and it behaved the same as if I didn't

I encountered the same problem once and no suggestion was able to get around the problem.
It looks like the function is compiled twice, no matter any CFIF you may put aroud it,
even 

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: DB field setup

Not really, you can do joins and such to get all of the information.
For instance...

Select *
>From usergroups
 left join users on usergroups.userID = users.userID
 left join groups on usergroups.groupid = groups.groupID
Where usergroups.userID = 2

This would return a record set like:

UserID	GroupID	UserName		GroupName
2		1		Daniel Kessler 	FamilyStudies
2		2		Daniel Kessler	Kinnesiology

Then you can use the  group attribute to group by user ID so
you don't output multiple names for each user but only output the name
once but output each groupname individually.  You may want to read up on
SQL joins as well as CFOUTPUT a little more but it will definitely make
life easier.

John

-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 3:30 PM
To: CF-Talk
Subject: Re: DB field setup

Yeah, I believe it does make sense, and I think if my head doesn't
explode within 10 minutes, I'll probably last the night.

So anytime I have a list of anything within a list when I don't want to
do "a|b|c", I go to a lookup table and abstract (if that's the right
term) both sets.  What I was missing mentally is having multiple entries
for a person in the user/groups section.

I guess this means that I can't just use CF Query="" to root through a
list and have to do my own looping to up the loop numbers through vars
with multiple people entries.

>No, I'm suggesting the following:
>
>GROUPS
>GroupID	GroupName
>1		Family Studies
>2		Kinnesiology
>
>USERS
>UserID	UserName
>1		John Burns
>2		Daniel Kessler
>
>USERGROUPS
>UserID	GroupID
>1		1
>2		1
>2		2
>
>Which would mean that John Burns is in Family Studies while Daniel 
>Kessler is in Family Studies and Kinnesiology.  I hope that helps.
>
>John Burns
>
>-Original Message-
>From: daniel kessler [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, July 21, 2004 2:22 PM
>To: CF-Talk
>Subject: Re: DB field setup
>
>>Seems like you need a lookup table (in case the possibilities ever 
>>increase from 3 to X).  Then you can either store the IDs in a 
>>comma-delimited list or do another lookup table where you insert the 
>>userID and the type they are.  Then each user can be in multiple
>places.
>
>While I agree that I probably need a lookup table, I don't really 
>understand your suggestions.  Are you suggesting a Family_Studies 
>tables with a set of names?  And would I do an INNER JOIN to grab that 
>information?
>
>I'm a bit new to DBs.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Send Fax through Internet

2004-07-21 Thread Jordan Michaels

Any suggestions on a linux version of this? All of our CFMX and BD 
servers run on linux.

Thanks in advance!
-JM

Andrew Spear wrote:

> I've been using ProtoFax for about 3 years and it works great.  We 
> send out a bunch of faxes every day and it's held up nicely.  The best 
> part is that it will take HTML and convert it to a fax.  So you can 
> basically just do a CFSaveContent around some HTML/CF code and save 
> the file to the ProtoFax "drop folder", and presto the file is fax 
> offed.  You have to add some header info in the file (fax number, 
> subject) though.  I have a custom tag that does all this if you're 
> interested.
>
> Best Regards-
> Andrew
>
> >http://www.protofax.com/
> >
> >We never needed it, but it came with AbleCommerce.  There's a licensing
> >fee, but it has a custom tag to connect it to your CF apps.
> >
> >--Jeff

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

You can also just do isdefined('doTocOption') to see if the function has 
been created.

Brook

At 12:39 PM 7/21/2004, you wrote:
>Shouldn't you be doing this?
>
>
>
>   function doTocOption(myQuery, contextFilePrefix) {
> ...
>   }
>
>
>
>or
>
>
>
>   function doTocOption(myQuery, contextFilePrefix) {
> ...
>   }
>
>
>
>Qasim
>
>- Original Message -
>From: Jamie Jackson <[EMAIL PROTECTED]>
>Date: Wed, 21 Jul 2004 14:12:24 -0400
>Subject: Re: UDF within a Custom Tag
>To: CF-Talk <[EMAIL PROTECTED]>
>
>On Wed, 21 Jul 2004 13:29:40 -0400, in cf-talk you wrote:
>
> >What about using isCustomFunction() or isFunction from
> >http://cflib.org/udf.cfm?ID=286
> >
> >Qasim
>
>I just tried your suggestion, and it behaved the same as if I didn't
>have the conditional in there at all:
>
>
>
>   function doTocOption(myQuery, contextFilePrefix) {
> ...
>   }
>
>
>
>The error associated with the above is:
>"Routines cannot be declared more than once.
>
>The routine doTocOption has been declared twice in different
>templates."
>
>Thanks for the reply,
>
>Jamie
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[Fast 
>  Unsubscribe] [User Settings] 
>[Donations 
>and Support]
>
>--
>
>[]
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Still having trouble making CFMX stable

2004-07-21 Thread Ken Ferguson

Brook, can you tell if this is happening on any specific template? A lot
of people might remember the issue I had (which nobody was ever able to
figure out) several months ago; Jrun was dying every few minutes. I
mean, it just died and restarted. Actually, the error was "unable to
connect to JRun...", but the CFMX was actually dying and restarting. 

This is going to make you scratch your head too. I figured out what was
causing it. Actually, that's not exactly true. I figured out what bit of
code was causing it, but not WHAT was causing it. I had a cfinclude in
my header.cfm file that was just one of many. There wasn't ANYTHING
complex in this file, just some content. When I removed this cfinclude
from the file and pasted the code into it, all worked fine. When I
created a new file and cfincluded that it broke again. I couldn't figure
it out. I asked everyone in the world I could find (several CFUG lists)
and they all said, "damn, that's strange - it doesn't make any sense."
But it was happening, so I just pasted the code in instead of including
it and it hasn't happened again. It's been several months. I'm serious
when I say that there wasn't anything complex happening in there. The
ONLY cf tag in the whole bit of code, was a cfif statement wrapped
around and image. The only reason I ever found this is that I just
happened to remember that I had recently stripped out that code and put
it in an included file and I realized that I had done that at around the
time it all started. So, even though I knew it COULDN'T be that, I
changed it and...

Sorry to be of ABSOLUTELY NO HELP whatsoever, but maybe you have this
same kind of thing happening.

  _  

From: Brook Davies [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 12:08 PM
To: CF-Talk
Subject: RE: Still having trouble making CFMX stable

I've installed almost all the patches. All the ones that look like the
are 
relevant and would cause major issues. I might just go ahead and install

the rest of them tonight (dev server first) just to be sure. I don't
really 
know what else to check because I am not seeing jack in the logs..

Brook

At 09:24 AM 7/21/2004, you wrote:
>Are you saving your class files?  Is your server fully patched? We had
a
>nightmare with MX behaving badly when we first installed it but it all
seems
>fine now after a few tweaks and debug effort...
>
>We found that it was out client vars causing problems when stored in
the
>registry..
>
>
>
>    _
>
>From: Brook Davies [mailto:[EMAIL PROTECTED]
>Sent: 21 July 2004 17:11
>To: CF-Talk
>Subject: Still having trouble making CFMX stable
>
>I am still getting daily crashes, today our webserver has crashed
twice.
>Today what happened the first time was that IIS 5.0 (on win2k) crashes
and
>was automatically restarted by the service recovery setting. However,
the
>connection to Jrun was lost and requests to cfm pages returned the
unable
>to connect to jrun error.
>
>Also, I have been getting crashes where jrun.exe continues to run but
all
>requests for cfm pages return the same unable to connect to jrun error
as
>though the service was not running. IIS did not crash, the connection
to
>jrun was apparently just lost.
>
>I took some of the advise I got last week and increased the max heap to
756
>megs and also brought the minimum up aswell. I also added some hourly
>cleanup scripts to remove data from the application scope, and this
does
>seem to be keep memory usage a bit lower.
>
>I've been through all the log files and there is nothing that stands
out. I
>don't know what else do to except possibly rebuild the server.
>
>Brook
>
>    _
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[
Fast 
>  Unsubscribe] [User Settings] 
>[
on&business=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclic
k>Donations 
>and Support]
>
>--
>
>42c8eb8.jpg
>

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

Re: UDF within a Custom Tag

2004-07-21 Thread Qasim Rasheed

Shouldn't you be doing this?



  function doTocOption(myQuery, contextFilePrefix) { 
    ...
  }



or 



  function doTocOption(myQuery, contextFilePrefix) { 
    ...
  }



Qasim

- Original Message -
From: Jamie Jackson <[EMAIL PROTECTED]>
Date: Wed, 21 Jul 2004 14:12:24 -0400
Subject: Re: UDF within a Custom Tag
To: CF-Talk <[EMAIL PROTECTED]>

On Wed, 21 Jul 2004 13:29:40 -0400, in cf-talk you wrote:

>What about using isCustomFunction() or isFunction from
>http://cflib.org/udf.cfm?ID=286
>
>Qasim

I just tried your suggestion, and it behaved the same as if I didn't
have the conditional in there at all:



  function doTocOption(myQuery, contextFilePrefix) { 
    ...
  }



The error associated with the above is:
"Routines cannot be declared more than once.

The routine doTocOption has been declared twice in different
templates."

Thanks for the reply,

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

Re: DB field setup

2004-07-21 Thread daniel kessler

Yeah, I believe it does make sense, and I think if my head doesn't explode within 10 minutes, I'll probably last the night.

So anytime I have a list of anything within a list when I don't want to do "a|b|c", I go to a lookup table and abstract (if that's the right term) both sets.  What I was missing mentally is having multiple entries for a person in the user/groups section.

I guess this means that I can't just use CF Query="" to root through a list and have to do my own looping to up the loop numbers through vars with multiple people entries.

>No, I'm suggesting the following:
>
>GROUPS
>GroupID	GroupName
>1		Family Studies
>2		Kinnesiology
>
>USERS
>UserID	UserName
>1		John Burns
>2		Daniel Kessler
>
>USERGROUPS
>UserID	GroupID
>1		1
>2		1
>2		2
>
>Which would mean that John Burns is in Family Studies while Daniel
>Kessler is in Family Studies and Kinnesiology.  I hope that helps.
>
>John Burns 
>
>-Original Message-
>From: daniel kessler [mailto:[EMAIL PROTECTED] 
>Sent: Wednesday, July 21, 2004 2:22 PM
>To: CF-Talk
>Subject: Re: DB field setup
>
>>Seems like you need a lookup table (in case the possibilities ever 
>>increase from 3 to X).  Then you can either store the IDs in a 
>>comma-delimited list or do another lookup table where you insert the 
>>userID and the type they are.  Then each user can be in multiple
>places.
>
>While I agree that I probably need a lookup table, I don't really
>understand your suggestions.  Are you suggesting a Family_Studies tables
>with a set of names?  And would I do an INNER JOIN to grab that
>information?  
>
>I'm a bit new to DBs.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Send Fax through Internet

2004-07-21 Thread Tangorre, Michael

> Andrew,
> This looks like a potentially good alternative except I don't 
> have a fax modem :(  Our IT guys are looking into Captaris to 
> implement organization wide and that of course would solve my 
> problem then and there.  If not, however, this may be a good 
> stop gap if I can get a fax modem for the server.
> --Anne

Just a heads up with Captaris... The API documentation sucks.. Or at elast
it did. I would call all the time with questions and one day the guy said we
needed to spend $5,000 on a service contract to get things going... They
eventually helped us out and backed off the ridiculous request.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Still having trouble making CFMX stable

I'm curious, does an application become more unstable as its memory usage 
grows? Is there a potential for more problems when an application holds on 
to large amounts of memory.

Brook

At 11:09 AM 7/21/2004, you wrote:
>Brook,
>
>If you think that the problem is memory related, then there are also some 
>other things that can be taking up memory besides application variables. 
>Take a look at cached queries, session variables (you may want to lower 
>timouts, or use them less), your template cache may be too large.
>
>__
>Pete Freitag
>http://www.cfdev.com/
>Author of the CFMX Developers Cookbook
>http://www.petefreitag.com/bookshelf/
>
>Brook Davies wrote:
>
> > I am still getting daily crashes, today our webserver has crashed twice.
> > Today what happened the first time was that IIS 5.0 (on win2k) crashes
> > and
> > was automatically restarted by the service recovery setting. However, the
> > connection to Jrun was lost and requests to cfm pages returned the unable
> > to connect to jrun error.
> >
> > Also, I have been getting crashes where jrun.exe continues to run but all
> > requests for cfm pages return the same unable to connect to jrun error as
> > though the service was not running. IIS did not crash, the connection to
> > jrun was apparently just lost.
> >
> > I took some of the advise I got last week and increased the max heap
> > to 756
> > megs and also brought the minimum up aswell. I also added some hourly
> > cleanup scripts to remove data from the application scope, and this does
> > seem to be keep memory usage a bit lower.
> >
> > I've been through all the log files and there is nothing that stands
> > out. I
> > don't know what else do to except possibly rebuild the server.
> >
> > Brook
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[Fast 
>  Unsubscribe] [User Settings] 
>[Donations 
>and Support]
>
>--
>
>[]
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Still having trouble making CFMX stable

What do you use for load Balancing?

At 12:16 PM 7/21/2004, you wrote:
> >Also, I have been getting crashes where jrun.exe continues to run but all
> >requests for cfm pages return the same unable to connect to jrun error as
> >though the service was not running. IIS did not crash, the connection to
> >jrun was apparently just lost.
> >
>
>I believe this is a JRun memory issue, I have some similar issues on two 
>servers. I have thought about switching to Websphere but I'm not that keen 
>to part with thousands of dollars for the licenses if I can help it. I am 
>running the two servers load-balanced, so I just deal with it as needed 
>for now.
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[Fast 
>  Unsubscribe] [User Settings] 
>[Donations 
>and Support]
>
>--
>
>4a5e4bb.jpg
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Still having trouble making CFMX stable

BTW I upped the RAM on the servers to 2 GB from 1 GB, adjusted the heap size, and that made a big difference.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Send Fax through Internet

Andrew,

This looks like a potentially good alternative except I don't have a fax modem :(  Our IT guys are looking into Captaris to implement organization wide and that of course would solve my problem then and there.  If not, however, this may be a good stop gap if I can get a fax modem for the server.

--Anne

> I've been using ProtoFax for about 3 years and it works great.  We 
> send out a bunch of faxes every day and it's held up nicely.  The best 
> part is that it will take HTML and convert it to a fax.  So you can 
> basically just do a CFSaveContent around some HTML/CF code and save 
> the file to the ProtoFax "drop folder", and presto the file is fax 
> offed.  You have to add some header info in the file (fax number, 
> subject) though.  I have a custom tag that does all this if you're 
> interested.
> 
> Best Regards-
> Andrew
> 
> >http://www.protofax.com/
> >
> >We never needed it, but it came with AbleCommerce.  There's a 
> licensing 
> >fee, but it has a custom tag to connect it to your CF apps.
> >
>--Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Still having trouble making CFMX stable

>Also, I have been getting crashes where jrun.exe continues to run but all 
>requests for cfm pages return the same unable to connect to jrun error as 
>though the service was not running. IIS did not crash, the connection to 
>jrun was apparently just lost.
>

I believe this is a JRun memory issue, I have some similar issues on two servers. I have thought about switching to Websphere but I'm not that keen to part with thousands of dollars for the licenses if I can help it. I am running the two servers load-balanced, so I just deal with it as needed for now.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: DB field setup

2004-07-21 Thread Deanna Schneider

Daniel,
You'd have two new tables:

Category (or whatever these things really are)
    categoryID number PK
    name varchar2(300)

And your join table I usually concat the two names of the other tables so,
so imagining these are people here...

PersonCategory
    categoryID number PK FK
    personID PK FK

When someone selects kiniseology, you'd add their personid (if we're talking
people here) and the id for kiniseology to the "personcategory" table.

When you want to get people and their categories, you'd just join the two
tables

SELECT p.personid, c.name AS category
FROM    person p, personcategory x, category c
WHERE    p.personid = x.personid
ANDx.categoryid = c.categoryid

Make sense?

- Original Message - 
From: "daniel kessler" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 21, 2004 1:22 PM
Subject: Re: DB field setup

> >Seems like you need a lookup table (in case the possibilities ever
> >increase from 3 to X).  Then you can either store the IDs in a
> >comma-delimited list or do another lookup table where you insert the
> >userID and the type they are.  Then each user can be in multiple places.
>
> While I agree that I probably need a lookup table, I don't really
understand your suggestions.  Are you suggesting a Family_Studies tables
with a set of names?  And would I do an INNER JOIN to grab that information?
>
> I'm a bit new to DBs.
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Anti-Virus Software on a Server

> I am wondering people's thoughts on the idea of having anti-virus 
> software running on a ColdFusion server?

My company runs AV virus software on our servers. We also run ISS RealSecure Server to protect our critical server infrastructure. That may be above and beyond your needs, but ISS makes small-office products as well.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Ecommerce site work...

>Is there a
>place anyone knows of where I can find a (mostly) pre-made eCommerce
>web-site for sale

Check the Macromedia Exchange:

http://www.macromedia.com/cfusion/exchange/

Search for ecommerce, there is a lot of stuff there.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Ecommerce site work...

2004-07-21 Thread Ketan Patel

SIteDirector from www.quilldesign.com  

  _  

From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 1:08 PM
To: CF-Talk
Subject: RE: Ecommerce site work...

 
Miva Merchant is a pretty good 'out of the box' app that we have used
before.

There is a pretty good user group out there for them too.

http://www.miva.com

At 01:05 PM 7/21/2004, you wrote:
>
>Hello,
>
>I am not sure if there was a mail alias at HOF  to direct this to.So please
>don't be peeved, maybe you can direct me to some good sites? Is there a
>place anyone knows of where I can find a (mostly) pre-made eCommerce
>web-site for sale? I need a login, shopping cart, dynamic database,
>automated emails for certain things,etc... and a few other items.
>I would like to just use something pretty much pre-made and just change my
>colors, headmast graphics,etc... and be done with it.
>Even if it was not a site for CF would be ok like php/mysql or whatever...
>I can tweak some of the code for my emails,etc... but I cannot build the
>whole thing on my own.
>I did find one such site but if I ever go to a different hosting company I
>can only take my database with me , not the site.
>
>~/Wayne
>
>
>
>
>
>
>
>
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: DB field setup

No, I'm suggesting the following:

GROUPS
GroupID	GroupName
1		Family Studies
2		Kinnesiology

USERS
UserID	UserName
1		John Burns
2		Daniel Kessler

USERGROUPS
UserID	GroupID
1		1
2		1
2		2

Which would mean that John Burns is in Family Studies while Daniel
Kessler is in Family Studies and Kinnesiology.  I hope that helps.

John Burns 

-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 2:22 PM
To: CF-Talk
Subject: Re: DB field setup

>Seems like you need a lookup table (in case the possibilities ever 
>increase from 3 to X).  Then you can either store the IDs in a 
>comma-delimited list or do another lookup table where you insert the 
>userID and the type they are.  Then each user can be in multiple
places.

While I agree that I probably need a lookup table, I don't really
understand your suggestions.  Are you suggesting a Family_Studies tables
with a set of names?  And would I do an INNER JOIN to grab that
information?  

I'm a bit new to DBs.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Anti-Virus Software on a Server

2004-07-21 Thread Jochem van Dieten

Mike Chabot wrote:
> 
> Are people uploading .exe or .vbs files onto the server?

Yes.

> A ColdFusion rule that prevents these files from being saved would be the better strategy, and even this I would consider to be more of a hack attempt than an actual virus. I do not know of any virus that is capable of automatically uploading itself to servers via Web-based forms, but I suppose this is an avenue future virus writers can explore.

I would presume that one would solve this from a server integrity 
point of view by so called 'write or execute' ACLs on the 
filesystem and in the webserver. Doesn't protect visitors with 
vulnerable browsers, but it does protect your server.

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

Re: DB field setup

2004-07-21 Thread Jeff Langevin

Use three tables something like what's below.  The has multiple entries 
for each user.  HTH.

--Jeff

tblUsers
   PK_tblUsers
   userName
   firstName
   ...

tblSubjects
   PK_tblSubjects
   subject
   description
   ...

tblUserSubjects
   FK_tblUsers
   FK_tblSubjects

On 7/21/2004 1:43 PM, Daniel Kessler wrote:

> I had a dropdown that had three entries: kinesiology, family studies,
> public and community health.  So in my Oracle DB, I had a field TYPE
> VARCHAR2(100) to take that information, as is.  Now I find that
> someone can be in more than one spot, so instead of a dropdown, I now
> have a checkbox for each entry.  Is the standard way to deal with
> this to have three database fields like:
> 
> isFamilyStudies INT,
> isKinseology INT,
> isPublicAndCommunityHealth INT,
> 
> It seems kinda inflexible that I would have to add a row each time I
> added to that list, but if that's how it's done then ok.
> -- 
> 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
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Ecommerce site work...

2004-07-21 Thread Damien McKenna

On Jul 21, 2004, at 1:05 PM, Wayne Burlingame ((wburling)) wrote:
> where I can find a (mostly) pre-made eCommerce web-site for sale?

Seeing as you are not restricting yourself to CF (I don't know of any 
CF ones), you might consider osCommerce (http://www.oscommerce.com/).  
It is a system written in PHP/MySQL that I've used before.  It gives an 
Amazon-like interface with different categories, etc.  One of the best 
aspects is of osCommerce is that it has a large array of 3rd party 
add-ons to further enhance the core system.  Enjoy.
-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Nothing endures but change." - Heraclitus
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Send Fax through Internet

2004-07-21 Thread Andrew Spear

I've been using ProtoFax for about 3 years and it works great.  We send out a bunch of faxes every day and it's held up nicely.  The best part is that it will take HTML and convert it to a fax.  So you can basically just do a CFSaveContent around some HTML/CF code and save the file to the ProtoFax "drop folder", and presto the file is fax offed.  You have to add some header info in the file (fax number, subject) though.  I have a custom tag that does all this if you're interested.

Best Regards-
Andrew

>http://www.protofax.com/
>
>We never needed it, but it came with AbleCommerce.  There's a licensing 
>fee, but it has a custom tag to connect it to your CF apps.
>
>--Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: DB field setup

2004-07-21 Thread daniel kessler

>Seems like you need a lookup table (in case the possibilities ever
>increase from 3 to X).  Then you can either store the IDs in a
>comma-delimited list or do another lookup table where you insert the
>userID and the type they are.  Then each user can be in multiple places.

While I agree that I probably need a lookup table, I don't really understand your suggestions.  Are you suggesting a Family_Studies tables with a set of names?  And would I do an INNER JOIN to grab that information?  

I'm a bit new to DBs.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Ecommerce site work...

2004-07-21 Thread Rick Faircloth

Opinions on using PayPal for those of us who want to create our own shopping
carts,
but just need payment processing?  Other options that are easy to use for
those of us
who haven't built any e-commerce sites, but are about to?

Rick

  -Original Message-
  From: Ray Champagne [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, July 21, 2004 1:08 PM
  To: CF-Talk
  Subject: RE: Ecommerce site work...

  Miva Merchant is a pretty good 'out of the box' app that we have used
before.

  There is a pretty good user group out there for them too.

  http://www.miva.com

  At 01:05 PM 7/21/2004, you wrote:
  >
  >Hello,
  >
  >I am not sure if there was a mail alias at HOF  to direct this to.So
please
  >don't be peeved, maybe you can direct me to some good sites? Is there a
  >place anyone knows of where I can find a (mostly) pre-made eCommerce
  >web-site for sale? I need a login, shopping cart, dynamic database,
  >automated emails for certain things,etc... and a few other items.
  >I would like to just use something pretty much pre-made and just change
my
  >colors, headmast graphics,etc... and be done with it.
  >Even if it was not a site for CF would be ok like php/mysql or
whatever...
  >I can tweak some of the code for my emails,etc... but I cannot build the
  >whole thing on my own.
  >I did find one such site but if I ever go to a different hosting company
I
  >can only take my database with me , not the site.
  >
  >~/Wayne
  >
  >
  >
  >
  >
  >
  >
  >
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

On Wed, 21 Jul 2004 13:29:40 -0400, in cf-talk you wrote:

>What about using isCustomFunction() or isFunction from
>http://cflib.org/udf.cfm?ID=286
>
>Qasim

I just tried your suggestion, and it behaved the same as if I didn't
have the conditional in there at all:



  function doTocOption(myQuery, contextFilePrefix) { 
    ...
  }



The error associated with the above is:
"Routines cannot be declared more than once.

The routine doTocOption has been declared twice in different
templates."

Thanks for the reply,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Still having trouble making CFMX stable

2004-07-21 Thread Pete Freitag

Brook,

If you think that the problem is memory related, then there are also some other things that can be taking up memory besides application variables. Take a look at cached queries, session variables (you may want to lower timouts, or use them less), your template cache may be too large.

__
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/

Brook Davies wrote:

> I am still getting daily crashes, today our webserver has crashed twice.
> Today what happened the first time was that IIS 5.0 (on win2k) crashes 
> and
> was automatically restarted by the service recovery setting. However, the
> connection to Jrun was lost and requests to cfm pages returned the unable
> to connect to jrun error.
>
> Also, I have been getting crashes where jrun.exe continues to run but all
> requests for cfm pages return the same unable to connect to jrun error as
> though the service was not running. IIS did not crash, the connection to
> jrun was apparently just lost.
>
> I took some of the advise I got last week and increased the max heap 
> to 756
> megs and also brought the minimum up aswell. I also added some hourly
> cleanup scripts to remove data from the application scope, and this does
> seem to be keep memory usage a bit lower.
>
> I've been through all the log files and there is nothing that stands 
> out. I
> don't know what else do to except possibly rebuild the server.
>
> Brook
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Anti-Virus Software on a Server

I can see what you're saying there.  I agree with an earlier post then
that you should at least have an active scan of certain directories
(where uploads occur).

John 

-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 1:53 PM
To: CF-Talk
Subject: Re: Anti-Virus Software on a Server

>While AV Software may not protect against windows and other security 
>holes, if your CF server allows any uploads of files or anything, I'd 
>definitely say AV Software is a GOOD THING.
>
>John

I am not suggesting that people should stop running AV software. Rather,
I am making the case that realtime protection may be more detrimental
than beneficial for servers.

Even with a site where people upload files, the risk of viruses damaging
the server in this manner is not that substantial in my view. What is
someone going to upload? The most common case is a Word doc with a
macrovirus. I have not seen a macrovirus is a long time, but I am sure
they are still around and have the capability of infecting old versions
of MS Word. It would be nice to rid these files of the macroviruses
before someone downloads the doc. However, these viruses are not the
type that bring down a server. Are people uploading .exe or .vbs files
onto the server? A ColdFusion rule that prevents these files from being
saved would be the better strategy, and even this I would consider to be
more of a hack attempt than an actual virus. I do not know of any virus
that is capable of automatically uploading itself to servers via
Web-based forms, but I suppose this is an avenue future virus writers
can explore.

Thank you,
Mike Chabot
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Send Fax through Internet

2004-07-21 Thread Jeff Langevin

http://www.protofax.com/

We never needed it, but it came with AbleCommerce.  There's a licensing 
fee, but it has a custom tag to connect it to your CF apps.

--Jeff

On 7/21/2004 1:15 PM, Anne Girardeau wrote:

> Thanks Mike.  I took a look around but I wasn't able to find the API you 
> were referring to. Would you happen to know what fees Captaris charges 
> for their service?
> 
> Thanks so much,
> --Anne
> 
>  >> I'm interested in setting up an application that will allow
>  >> news releases to be faxed to various media outlets.  My
>  >> question is, does anyone know of a good application or
>  >> service that will allow me to accomplish this?  Any help
>  >> would be appreciated.
>  >
>  >Check out Captaris.com
>  >
>  >Awhile back at a very shitty job I used to have I was asked to integrate a
>  >fax component into a marketing application and used an API from Captaris
>  >Medialinq. It took a couple days to get the code working and the API was
>  >"ok". The faxes did send out though and it was all web based.
>  >
>  >Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: DB field setup

Seems like you need a lookup table (in case the possibilities ever
increase from 3 to X).  Then you can either store the IDs in a
comma-delimited list or do another lookup table where you insert the
userID and the type they are.  Then each user can be in multiple places.

John 

-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 1:44 PM
To: CF-Talk
Subject: DB field setup

I had a dropdown that had three entries: kinesiology, family studies,
public and community health.  So in my Oracle DB, I had a field TYPE
VARCHAR2(100) to take that information, as is.  Now I find that someone
can be in more than one spot, so instead of a dropdown, I now have a
checkbox for each entry.  Is the standard way to deal with this to have
three database fields like:

isFamilyStudies INT,
isKinseology INT,
isPublicAndCommunityHealth INT,

It seems kinda inflexible that I would have to add a row each time I
added to that list, but if that's how it's done then ok.
--
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
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Anti-Virus Software on a Server

2004-07-21 Thread Mike Chabot

>While AV Software may not protect against windows and other security
>holes, if your CF server allows any uploads of files or anything, I'd
>definitely say AV Software is a GOOD THING.
>
>John 

I am not suggesting that people should stop running AV software. Rather, I am making the case that realtime protection may be more detrimental than beneficial for servers.

Even with a site where people upload files, the risk of viruses damaging the server in this manner is not that substantial in my view. What is someone going to upload? The most common case is a Word doc with a macrovirus. I have not seen a macrovirus is a long time, but I am sure they are still around and have the capability of infecting old versions of MS Word. It would be nice to rid these files of the macroviruses before someone downloads the doc. However, these viruses are not the type that bring down a server. Are people uploading .exe or .vbs files onto the server? A ColdFusion rule that prevents these files from being saved would be the better strategy, and even this I would consider to be more of a hack attempt than an actual virus. I do not know of any virus that is capable of automatically uploading itself to servers via Web-based forms, but I suppose this is an avenue future virus writers can explore.

Thank you,
Mike Chabot
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

DB field setup

2004-07-21 Thread Daniel Kessler

I had a dropdown that had three entries: kinesiology, family studies, 
public and community health.  So in my Oracle DB, I had a field TYPE 
VARCHAR2(100) to take that information, as is.  Now I find that 
someone can be in more than one spot, so instead of a dropdown, I now 
have a checkbox for each entry.  Is the standard way to deal with 
this to have three database fields like:

isFamilyStudies INT,
isKinseology INT,
isPublicAndCommunityHealth INT,

It seems kinda inflexible that I would have to add a row each time I 
added to that list, but if that's how it's done then ok.
-- 
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
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Anti-Virus Software on a Server

2004-07-21 Thread Mike Chabot

>There are reasons to run a good A/V application on a server, as while the most
>visible method of virus propagation is via email, there are still plenty that
>infect (compromise) servers via UDP and other unprotected ports.   The SQL
>Slammer worm is but one of these. A good firewall is also a near imperative as
>well.  Any server that offers file upload/downloads needs to have real-time A/V
>scanning as well, even it is a performance hit.

I was thinking that we should do virus scans of the temp upload folder as well as the final destination folder for these uploaded files. However, I do not think NAV is intended to be used to only perform realtime protection on selected folders. You can easily set up exclusion folders and rules, but I do not believe you can set up inclusion rules. 

As for PrismAV, we already have a site license for NAV, and NAV is clearly one the best AntiVirus software products there is. So how about this strategy:
1. identify the folders that will be used for uploading files
2. monitor those folders for changes every five minutes using a batch file (or even using CF itself).
3. if a change is detected, have NAV scan the specific file that was changed.

Seems reasonable to me, although I have never run NAV from the command line to accomplish step 3. One potential problem would be what happens with a folder that changes too frequently. NAV would constantly be starting up and shutting down. I could probably come up with some sort of queuing feature, and offload the scans to another computer so the processor is not tied up so much. Perhaps NAV realtime protection is actually more efficient than doing this periodic check and I would be better off using a lot of exclusion rules.

For SQL Server, what I have read is that you should not use AntiVirus software on a SQL Server box, but if you do, exclude the database and log files from being scanned. Maybe someone has a good list of general exclusion rules for a CF server.

I do not believe NAV would have done anything to prevent the Slammer Worm from doing its damage, and I have my doubts as to NAV's ability to protect against other worms that propogate via security holes in MS server software products. Our hardware firewall blocks every port but the Web ports. 

Has anyone actually seen their AV program catch and prevent a virus on their servers? The NAV logs record a history of everything that has been found, so it is not too difficult to check. The only thing I have seen is when a virus that rampaged through our desktops put files onto the network shares it could find. An infected file was on the domain controller, but it just sat there harmlessly. It is somewhat of a zen question. If an virus file is on a computer and nobody is around to click it, is it really a virus. NAV thinks so, but from a practical standpoint, a nighly non-realtime scan is sufficient.

Thank you,
Mike Chabot
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag

2004-07-21 Thread Qasim Rasheed

What about using isCustomFunction() or isFunction from
http://cflib.org/udf.cfm?ID=286

Qasim

- Original Message -
From: Jamie Jackson <[EMAIL PROTECTED]>
Date: Wed, 21 Jul 2004 11:51:39 -0400
Subject: Re: UDF within a Custom Tag
To: CF-Talk <[EMAIL PROTECTED]>

On Wed, 21 Jul 2004 16:38:03 +0100, in cf-talk you wrote:

>You are getting this error as by default Custom Tags are called twice
>internally AFAIK..

So are UDFs not allowed within Custom Tags?

I also tried wrapping the function declaration in a testing
conditional:

function doOption() {
...
}

But CF complains that doOption is a complex variable, and it can't
test for its definition. Is there a way to do an existence test on
UDFs, or is there a cleaner way to do UDFs in Custom Tags?

Thanks,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Send Fax through Internet

Thanks Mike.  I took a look around but I wasn't able to find the API you were referring to. Would you happen to know what fees Captaris charges for their service?

Thanks so much,
--Anne

>> I'm interested in setting up an application that will allow 
>> news releases to be faxed to various media outlets.  My 
>> question is, does anyone know of a good application or 
>> service that will allow me to accomplish this?  Any help 
>> would be appreciated.
>
>Check out Captaris.com
>
>Awhile back at a very shitty job I used to have I was asked to integrate a
>fax component into a marketing application and used an API from Captaris
>Medialinq. It took a couple days to get the code working and the API was
>"ok". The faxes did send out though and it was all web based.
>
>Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Ecommerce site work...

2004-07-21 Thread Bryan Stevenson

There are so many offerings like you describe it's not even funny. Most ISPs offer some kind of out-of-the-box shopping vart enabled template based site setup.there are also loads of companies selling the same idea.

I'm sure others on this list may have some specific products to point you to...but I would think a quick search on Google will get you heading in the right direction ;-)

Cheers

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

- Original Message -
From: Wayne Burlingame (wburling)
To: CF-Talk
Sent: Wednesday, July 21, 2004 10:05 AM
Subject: RE: Ecommerce site work...

Hello,

I am not sure if there was a mail alias at HOF to direct this to.So please
don't be peeved, maybe you can direct me to some good sites? Is there a
place anyone knows of where I can find a (mostly) pre-made eCommerce
web-site for sale? I need a login, shopping cart, dynamic database,
automated emails for certain things,etc... and a few other items.
I would like to just use something pretty much pre-made and just change my
colors, headmast graphics,etc... and be done with it.
Even if it was not a site for CF would be ok like php/mysql or whatever...
I can tweak some of the code for my emails,etc... but I cannot build the
whole thing on my own.
I did find one such site but if I ever go to a different hosting company I
can only take my database with me , not the site.

~/Wayne
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]

RE: Ecommerce site work...

2004-07-21 Thread Ray Champagne

Miva Merchant is a pretty good 'out of the box' app that we have used before.

There is a pretty good user group out there for them too.

http://www.miva.com

At 01:05 PM 7/21/2004, you wrote:
>
>Hello,
>
>I am not sure if there was a mail alias at HOF  to direct this to.So please
>don't be peeved, maybe you can direct me to some good sites? Is there a
>place anyone knows of where I can find a (mostly) pre-made eCommerce
>web-site for sale? I need a login, shopping cart, dynamic database,
>automated emails for certain things,etc... and a few other items.
>I would like to just use something pretty much pre-made and just change my
>colors, headmast graphics,etc... and be done with it.
>Even if it was not a site for CF would be ok like php/mysql or whatever...
>I can tweak some of the code for my emails,etc... but I cannot build the
>whole thing on my own.
>I did find one such site but if I ever go to a different hosting company I
>can only take my database with me , not the site.
>
>~/Wayne
>
>
>
>
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Still having trouble making CFMX stable

I've installed almost all the patches. All the ones that look like the are 
relevant and would cause major issues. I might just go ahead and install 
the rest of them tonight (dev server first) just to be sure. I don't really 
know what else to check because I am not seeing jack in the logs..

Brook

At 09:24 AM 7/21/2004, you wrote:
>Are you saving your class files?  Is your server fully patched? We had a
>nightmare with MX behaving badly when we first installed it but it all seems
>fine now after a few tweaks and debug effort...
>
>We found that it was out client vars causing problems when stored in the
>registry..
>
>
>
>    _
>
>From: Brook Davies [mailto:[EMAIL PROTECTED]
>Sent: 21 July 2004 17:11
>To: CF-Talk
>Subject: Still having trouble making CFMX stable
>
>I am still getting daily crashes, today our webserver has crashed twice.
>Today what happened the first time was that IIS 5.0 (on win2k) crashes and
>was automatically restarted by the service recovery setting. However, the
>connection to Jrun was lost and requests to cfm pages returned the unable
>to connect to jrun error.
>
>Also, I have been getting crashes where jrun.exe continues to run but all
>requests for cfm pages return the same unable to connect to jrun error as
>though the service was not running. IIS did not crash, the connection to
>jrun was apparently just lost.
>
>I took some of the advise I got last week and increased the max heap to 756
>megs and also brought the minimum up aswell. I also added some hourly
>cleanup scripts to remove data from the application scope, and this does
>seem to be keep memory usage a bit lower.
>
>I've been through all the log files and there is nothing that stands out. I
>don't know what else do to except possibly rebuild the server.
>
>Brook
>
>    _
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[Fast 
>  Unsubscribe] [User Settings] 
>[Donations 
>and Support]
>
>--
>
>42c8eb8.jpg
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Send Fax through Internet

Thanks Dov.  This looks relatively promising.  However, since I work for a state agency that's very tight-fisted with its money, I may have a hard time convincing them the 11 cents a minute charge would be worth it.

--Anne

>I once looked into this for a friend, and came across this:
> 
>http://www.faxaway.com
> 
>HTH
>-dov
> 
> 
>Dov Katz
>Enterprise & Client Technology
>Morgan Stanley
>750 7th Avenue | 34th Floor | NYC 10019
>[EMAIL PROTECTED]
> 
>
>  _  
>
>From: Anne Girardeau [mailto:[EMAIL PROTECTED] 
>Sent: Wednesday, July 21, 2004 12:41 PM
>To: CF-Talk
>Subject: Send Fax through Internet
>
>
>I'm interested in setting up an application that will allow news
>releases to be faxed to various media outlets.  My question is, does
>anyone know of a good application or service that will allow me to
>accomplish this?  Any help would be appreciated.
>
>--Anne 
>  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: MySQL cfqueryparam single quote problem

2004-07-21 Thread Philip Arnold

Not sure if this has been answered (Gmail hasn't grouped any responses)

Anyways, CFQUERYPARM can have a problem with putting functions inside
of it's VALUE attribute, so I'd say do the UPPER() before you run the
query, and then use that

HTH

On Mon, 19 Jul 2004 11:42:26 -0400, Chris Gottshall wrote:
> I have an application with a user login screen. Only users with apostrophes in their names are unable to log in. My database is MySQL 3.23.52 and I'm using the most recent update of CFMX.  If I query for a certain record using phpMyAdmin, I see the escape sequence \' replaces all single quotes. So, I have tried manually replacing all single quotes with slash-quote. And I have tried both with and without cfqueryparam tags.  Here are four scenerios that I have tested out, and the outcomes of each.
> 
> 1. No escape character with single quote; using cfqueryparam - query does not fail, but no record is returned
> 
> 2. Using escape character with single quote; and using cfqueryparam - query does not fail, but no record is returned
> 
> 3. Using escape character with single quote; no cfqueryparam - passing it straight in between single quotes - query fails to execute due to the value passed in for the name
> 
> 4. No escape character with single quote; no cfqueryparam  (passing it '#strName#') - query executes and the correct record is returned
> 
> However, I do not feel comfortable trusting just any user data in the last name field. I want to use cfqueryparam to prevent potential sql injections. Here is part of my query that fails:
> 
> SELECT FIRSTNAME, LASTNAME
> FROM T_USER
> WHERE UPPER(T_USER.LASTNAME) = 
> 
> But, this works:
> SELECT FIRSTNAME, LASTNAME
> FROM T_USER
> WHERE UPPER(T_USER.LASTNAME) = '#UCase(queryLastName)#'
> 
> Any help is appreciated.  Thanks.
> 
> -Chris
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Ecommerce site work...

2004-07-21 Thread Wayne Burlingame \(wburling\)

Hello,

 
I am not sure if there was a mail alias at HOF  to direct this to.So please
don't be peeved, maybe you can direct me to some good sites? Is there a
place anyone knows of where I can find a (mostly) pre-made eCommerce
web-site for sale? I need a login, shopping cart, dynamic database,
automated emails for certain things,etc... and a few other items.
I would like to just use something pretty much pre-made and just change my
colors, headmast graphics,etc... and be done with it.
Even if it was not a site for CF would be ok like php/mysql or whatever...
I can tweak some of the code for my emails,etc... but I cannot build the
whole thing on my own.
I did find one such site but if I ever go to a different hosting company I
can only take my database with me , not the site.

~/Wayne
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Dinowitz_Debug

2004-07-21 Thread Philip Arnold

Found an error:

Unable to write CFFORM _javascript_ functions.  
   
The error occurred in
C:\CFusionMX\wwwroot\WEB-INF\debug\dinowitz_debug.cfm: line 372

I'm using lots of CFFLUSH tags, so it can't get to the header
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Send Fax through Internet

2004-07-21 Thread Mark Drew

Again, dont quote me on this, but one of the windows services is the
fax gateway service, I am sure you could set up a windows box as a fax
gateway?

MD

On Wed, 21 Jul 2004 12:53:57 -0400, Tangorre, Michael
<[EMAIL PROTECTED]> wrote:
> > I'm interested in setting up an application that will allow
> > news releases to be faxed to various media outlets.  My
> > question is, does anyone know of a good application or
> > service that will allow me to accomplish this?  Any help
> > would be appreciated.
> 
> Check out Captaris.com
> 
> Awhile back at a very shitty job I used to have I was asked to integrate a
> fax component into a marketing application and used an API from Captaris
> Medialinq. It took a couple days to get the code working and the API was
> "ok". The faxes did send out though and it was all web based.
> 
> Mike
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Send Fax through Internet

2004-07-21 Thread Tangorre, Michael

> I'm interested in setting up an application that will allow 
> news releases to be faxed to various media outlets.  My 
> question is, does anyone know of a good application or 
> service that will allow me to accomplish this?  Any help 
> would be appreciated.

Check out Captaris.com

Awhile back at a very shitty job I used to have I was asked to integrate a
fax component into a marketing application and used an API from Captaris
Medialinq. It took a couple days to get the code working and the API was
"ok". The faxes did send out though and it was all web based.

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

Re: UDF within a Custom Tag

On Wed, 21 Jul 2004 17:36:07 +0100, in cf-talk you wrote:

>I believe this is a known bug - stumbled across it myself a while back.
>Since then I have resorted to declaring udfs outside a tag
> 
>Kola

Darn, should have been easy to have private methods in Custom Tags. Oh
well, thanks for the sanity check.

Thanks,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Send Fax through Internet

2004-07-21 Thread Katz, Dov B (IT)

I once looked into this for a friend, and came across this:

 
http://www.faxaway.com

 
HTH
-dov

Dov Katz
Enterprise & Client Technology
Morgan Stanley
750 7th Avenue | 34th Floor | NYC 10019
[EMAIL PROTECTED]

  _  

From: Anne Girardeau [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 12:41 PM
To: CF-Talk
Subject: Send Fax through Internet

I'm interested in setting up an application that will allow news
releases to be faxed to various media outlets.  My question is, does
anyone know of a good application or service that will allow me to
accomplish this?  Any help would be appreciated.

--Anne 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Send Fax through Internet

I'm interested in setting up an application that will allow news releases to be faxed to various media outlets.  My question is, does anyone know of a good application or service that will allow me to accomplish this?  Any help would be appreciated.

--Anne
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: JRunScripts Folder / Virtual Directory

2004-07-21 Thread Steven Erat

The IIS virtual path for JRunScripts is needed for the JRun ISAPI filter.
If JRun ISAPI filter makes a match, it uses /JRunScripts/jrun.dll

 
For example, if the jrun.ini parameter for ignoresuffixmap is set to false,
then if J2EE sessions are used and jsessionid is in the URL, the JRun ISAPI
filter will match the .cfm request and properly handle the ;jsessionid.  If
ignoresuffixmap is true, then the JRun ISAPI filter does not match the .cfm
and IIS attempts to match the .cfm;jsessionid but throws 404 instead.  

 
A JRun connector log shows how JRunScripts is used during a match like this:

 
2004-07-14 11:57:14 jrISAPI[filter:1216] In filter: notification =
0x4000
2004-07-14 11:57:14 jrISAPI[filter:1216] JRun Filter got url:
'/test.cfm;jsessionid=08301521611089820628281'
2004-07-14 11:57:14 jrISAPI[filter:1216]    HOST: serat03:90
2004-07-14 11:57:14 jrISAPI[filter:1216] filtering
/test.cfm;jsessionid=08301521611089820628281 (/test.cfm) HOST=serat03:90
2004-07-14 11:57:14 jrISAPI[filter:1216] filterRequest:   matched *.CFM
2004-07-14 11:57:14 jrISAPI[filter:1216] JRun Filter mapped url to:
'/JRunScripts/jrun.dll/test.cfm;jsessionid=08301521611089820628281'.

 
-Steve

  _  

From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 21, 2004 11:14 AM
To: CF-Talk
Subject: JRunScripts Folder / Virtual Directory

Hey All,

What is the scoop with the JRunScripts folder?  Is this actually required in
IIS?  I am not 100% confident running this if its not required...I did
notice that all of these files have read acess disabled so I suppose that's
a good thing!

N



This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: UDF within a Custom Tag