RE: Cfmodule and execution mode end.

2000-07-11 Thread Larry Meadors

That is one COOL trick!

 [EMAIL PROTECTED] 07/10/00 11:16PM 
Call it in the form:

cfmodule template="/tags/mytag.cfm" something /cfmodule

-Original Message-
From: Jared Clinton [mailto:[EMAIL PROTECTED]] 
Subject: Cfmodule and execution mode end.

I'm wondering, if I use cfmodule instead of the shorthand customtag call ..
how do I duplicate the
ThisTag.ExecutionMode is "END" situation.

For instance:
cf_mytag something /cf_mytag
works.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfx tags w/ java are NOT, I repeat NOT a pain! 8-)

2000-07-05 Thread Larry Meadors

 [EMAIL PROTECTED] 07/05/00 11:22AM 
Both did not reload for me.
I guess the only difference I can see is that your
on AS/400 and I'm on NT.
No, I'm not running on an as/400, I'm just using some classes to access our as/400 - 
I'm running on NT.

Has anyone on NT been able to get the reload option
of Java CFX's to work?  (and if so, any trick?)
The trick for me was to just put the class files in the c:\cfusion\java\classes\ 
directory.

Larry

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFX API to create a structure?

2000-06-28 Thread Larry Meadors

Hmm, I just had an epiphany. I could use XML (or WDDX) to pass them in and out.

I'll try it and follow up in the next week...

Larry

 [EMAIL PROTECTED] 06/27/00 01:52PM 

 Can you create a structure in a cfx?

 I haven't seen a way to do it yet.

 I guess I could return a query, but I'd prefer structures so I
 can nest them...

 Any ideas?

Um, nothing in the CFXAPI as I recall can do that.

If you're wanting to something you can cfloop through you CAN create queries
with different names. For instance, with CFX_UserManager it's set up so you
can tell the name of the query through the QUERY="?" parameter.

Ie, you call for a list of NT users with QUERY="Users". Then you can cfloop
through the Users query and call for their localqroups putting them in
QUERY="Localgroups". And then do a nested cfloop through the Localgroups
query. (Printing out their usernames, then a list of the localgroups they're
apart of.)

I believe that's about it. The CFXAPI allows for only one query to be
returned per CFX call. Far as I know. So

--min


--
Archives: http://www.eGroups.com/list/cf-talk 
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFX API to create a structure?

2000-06-27 Thread Larry Meadors

Can you create a structure in a cfx?

I haven't seen a way to do it yet. 

I guess I could return a query, but I'd prefer structures so I can nest them...

Any ideas?

Larry


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Java and CF

2000-06-23 Thread Larry Meadors

I've used createobject() successfully. Didn't look to closely at the mem use. Is it 
possible that the mem use you're seeing is the jvm?

We just had a thread about cfx tags in java. Read it before going that route unles you 
*like* to restart services...

   ;-)

Larry

 [EMAIL PROTECTED] 06/23/00 11:08AM 
Using CFOBJECT is not the best way eh?

So 4.5 now allows CFX's to be written in Java I always thought it was just
C?  If I recompile the Java Code will I have to register the  CFX's again

-Original Message-
From: Conrad, Christopher [mailto:[EMAIL PROTECTED]] 

CFX_J or CFX's on 4.5x

 -Original Message-
 From: Trahan, Shane [SMTP:[EMAIL PROTECTED]] 
 
 What is the best way to use Java and CF? I have tried using CFOBJECT but
 have had alot of problems with it not releasing memory etc..  How can I
 best leverage Java and CF?
 
 If anyone has any insight into Java and CFOBJECT please let me know!! I have
 been trying to figure out why CFOBJECT doesn't release the memory after
 the class has been called from the CFOBJECT


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: cfscript

2000-06-22 Thread Larry Meadors

No. For that matter, you can't even write a cfscript function.

 [EMAIL PROTECTED] 06/22/00 10:43AM 
Can I call a cfscript function through a link like a javascript function.

Like ...

a href="javascript:function_name('arg','arg')"blah/a


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: foxpro deletes

2000-06-20 Thread Larry Meadors

Instead of an isapi dll, why not do it with a com object created in vfp6? I haven't 
tried this, but you should be able to use cfobject to create the com object and pack 
the files.

Larry

 [EMAIL PROTECTED] 06/20/00 01:47AM 

I came up against the problem of Packing a Foxpro database some weeks ago.
It's not possible to do this using ODBC.

A programmer working with me tell's me it's possible to do this from Delphi.
I'm not sure whether it's possible to do this using D5 and ADO or whether it
requires D4 using the Borland Database engine (BDE).

The Delphi 4/BDE approach wouldn't be so attractive as it would involve
installing more software on the server.

A medium/long term project of mine would be to write an ISAPI DLL which
takes a table name as a parameter and PACK's the table. The DLL could then
be invoked from a CF page which could be scheduled to run on a Sunday night.

-Original Message-
From: Paige Chandler [mailto:[EMAIL PROTECTED]] 

Keep in mind that although Howie's advice may suffice because the deleted
records will not appear, they will still be present in the data table. The
FoxPro "Pack" command performs the following which of course can be
replicated: Copy to FileName for Not Deleted(), Rename OldFile, Rename
Newfile. Of course you would be advised to verify that the copy was
successful.

- Original Message -
From: John Featherstone [EMAIL PROTECTED]

 I would appreciate help in deleting records from a Foxpro table. When you
 issue the 'delete' command via CF/odbc, this merely marks the record for
 deletion. to actually delete the record, Foxpro requires the 'PACK' command.
 If this is not done, CF will continue to display those records marked for
 deletion. How do I permanently remove records from the table via CF/odbc?
 Thanks in advance


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfx tags w/ java are NOT, I repeat NOT a pain! 8-)

2000-06-20 Thread Larry Meadors

Here's my setup - strikingly similar to yours! ;-)

Load JVM when starting: checked
JVM path: C:\JRun\jre\bin\classic\jvm.dll
Class path: C:\java\jt400.zip (for my IBM AS/400 specific needs, irrelevant for this)
Init heap: 1024
Max heap: 16384
System options: (empty)
Imp. options: (empty)
CFX jar path: d:\cfusion\java\classes

In d:\cfusion\java\classes I have these files:
cfx.jar - comes w/ CF
hi.class - my compiled tag
hi.java - my tag's source

The tag source:
import com.allaire.cfx.* ;
public class hi implements CustomTag {
   public void processRequest( Request request, Response response )
throws Exception {
response.write( "Hi.") ;
   }
}

In the cfadmin  cfx tags page I registered my class as "hi", not "hi.class".

The cfm page that I'm testing reads like this:
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
htmlheadtitleUntitled/title/head
bodycfoutput
#gettickcount()#
cfx_hi reload="always"
#gettickcount()#
/cfoutput/body
/html

That's everything I know. Hope it helps you catch the joy. ;-)

If you have more questions, I'll answer as best I can.

Larry

 [EMAIL PROTECTED] 06/20/00 09:20AM 
Larry,

Great!!!
(for you, anyway)  :-)

I tried that before, and now again, after your success,
and it still does not work.  I changed my java code,
re-complied, made sure the reload="always" was there,
the .class file re-compiled to the correct dir,
and it still did not work.  I have the class file
in the Java/classes dir.   I originally had RELOAD="Always",
so I tried your case (of RELOAD) and that still did not work.
Although when the CF server stops and start, it works!

One question, in the CF Admin in the Edit Java CFX Tag 
do you have the '.class' on the Class Name text field.  I have 
Class Name:  HelloColdFusion
Should it be HelloColdFusion.class ?

When I add the .class, my cfm file errors out with this cmd.

Here is my cmd:
CFX_HelloColdFusion NAME="Jim" reload="always"

Any comments / suggestion would be great!


PS.  Here are my Java Settings: (if that helps!)
Java Virtual Machine Path: c:\jrun\jre\bin\classic
Class Path: C:\CFUSION\Java\classes
CFX Jar Path: C:\CFUSION\Java\classes


Thanks!

Jim


-Original Message-
From: Larry Meadors [mailto:[EMAIL PROTECTED]] 

WOO HOO!

Put your compiled class file in the cfusion\java\classes directory.

Register it w/ CFAdmin.

Use this syntax:

 cfx_hi reload="always"

And it'll work! It really works! COOL!

Larry (gleefully going to get a soda ;-)

 [EMAIL PROTECTED] 06/19/00 01:54PM 
 Larry,

 I (and many other per both this and Allaire's Forums )
 have had the same problem and have not found a
 resolution to this yet.  If you find one, definitely
 pass it along!

 I also have tried the 'reload' in the cfx tag, but that
 did not work either.

If any of you ever get java cfx's working, please post how to the list.
There were a couple of c cfx's of mine I was thinking of converting over but
I'm not even going think of wasting the time fooling with it until it's
working properly.

--min


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



cfx tags w/ java are a pain

2000-06-19 Thread Larry Meadors

Am I missing something?

I'm writing my first java cfx tag for CF4.5, and to get an new version after I compile 
it I have to restart the cf services.

I know there's a better way. 

The docs talk about "modifying the coldfusion.cfx.class.reload setting of the 
config/jvm.init file" but after looking high and low on the web server, I could find 
no such animal. Thinking maybe it got moved into the registry, I searched for 
coldfusion.cfx.class, but to no avail.

There's talk about a reload attribute too, but it's unclear whether that is for the 
tag (i.e., cfx_test reload="always") or where it goes. I haven't yet tried putting 
the class in the classes directory yet (I just saw that) and will try that (with 
reload="always" in the tag) next. 

If I see anything helpful, I'll pass it along here.

If any one has any helpful hints, I'd sure appreciate them!

Larry

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfx tags w/ java are NOT, I repeat NOT a pain! 8-)

2000-06-19 Thread Larry Meadors

WOO HOO!

Put your compiled class file in the cfusion\java\classes directory.

Register it w/ CFAdmin.

Use this syntax:

 cfx_hi reload="always"

And it'll work! It really works! COOL!

Larry (gleefully going to get a soda ;-)

 [EMAIL PROTECTED] 06/19/00 01:54PM 
 Larry,

 I (and many other per both this and Allaire's Forums )
 have had the same problem and have not found a
 resolution to this yet.  If you find one, definitely
 pass it along!

 I also have tried the 'reload' in the cfx tag, but that
 did not work either.

If any of you ever get java cfx's working, please post how to the list.
There were a couple of c cfx's of mine I was thinking of converting over but
I'm not even going think of wasting the time fooling with it until it's
working properly.

--min


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [Re: [Re: [Re: personal oracle 8i]]]

2000-06-17 Thread Larry Meadors

CF4.5, Oracle Personal 8i, NT4(sp5).

 [EMAIL PROTECTED]
OK, I am using Windows 98 and Personal Oracle 8i. I already have the NT
machine with CF and Oracle 8i enterprise edition. I want to migrate the
configuration from NT machine to the windows 98 machine, but the CF server can
not connect to the personal oracle 8i. Do you use personal oracle or
enterprise edition?

 [EMAIL PROTECTED]
 Sorry, I wish I had more details. Mine just worked, and I've only done it on NT4.
 
 [EMAIL PROTECTED]
 I've tried that way. But the CF still can't connect to the datasource. Can you
 give me more detail setting in tnsnames and listener?
 Notes: I am using Windows 98, not NT.
 
 [EMAIL PROTECTED] 
 Thanks. So you are saying that I must install the personal oracle server and
 personal oracle client in the same machine, and configure the CF server to
 connect to the database using sql net from oracle personal client?
 
 [EMAIL PROTECTED]
 I got it working. Did you install the client part on the server? The default
 driver that comes w/NT won't do.

 [EMAIL PROTECTED]
 Does anybody ever use CF server connect to Personal Oracle 8i? I tried but it can't 
work.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: CF logins, authenticate against Novell NDS???how?

2000-06-06 Thread Larry Meadors

http://www.novell.com/products/nds/
http://developer.novell.com/nds/

Their eDirectory product (based on NDS) is supposed to be a pretty impressive piece of 
work. Used by cnn and several other big names...

Larry

 [EMAIL PROTECTED] 06/02/00 11:56AM 

Lanny et al...,

Care to point us NDS "newbies" in the right direction via URL to stuff on
integrating NDS w/ cf4.5?

Any help appreciated

Steve

- Original Message -

 Don't forget LDAP with NDS. With NDS8 and CF 4.5 it is blazingly fast
 and 4.5 supports SLDAP for security.

 Lanny


  Larry Meadors [EMAIL PROTECTED] Wednesday, May 31, 2000 
 We've used NDS for NT and basic authentication. That works pretty well
 because the NDS users get replicated as NT users. Easy to set up too.

 With CF 4.5's enhancements to cfheader, you can really use any data
 source to do basic authentication. We're also looking into using
 Novell's ODBC driver for NDS and there's also an ActiveX control that
 might work. Note: ODBC and ActiveX are not supported with CF by Novell
 (translation: "If it works, great, but if it doesn't, tough.").

 There are also some JAVA classes from Novell that are supposed to work
 with the NDS. You might be able to use them (potentially from a cfx) to
 create other authentication schemes.

  [EMAIL PROTECTED] 05/31/00 08:45AM 
 Does any one have any info on how to use NDS to build in a login to a
 cf app?

 My maneger wants me to start  working with real authenticated user
 info, instead of just Data that i have enterd into a mdb.
 i dont really know where to start.
 any Guidence would be wonderful!


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [Re: [Re: personal oracle 8i]]

2000-06-06 Thread Larry Meadors

Sorry, I wish I had more details. Mine just worked, and I've only done it on NT4.

 [EMAIL PROTECTED] 06/02/00 01:34PM 
I've tried that way. But the CF still can't connect to the datasource. Can you
give me more detail setting in tnsnames and listener?
Notes: I am using Windows 98, not NT.

Thanks.

Irwan

"Larry Meadors" [EMAIL PROTECTED] wrote:
 Exactly! ;-)
 
  [EMAIL PROTECTED] 06/01/00 09:11AM 
 Thanks. So you are saying that I must install the personal oracle server
and
 personal oracle client in the same machine, and configure the CF server to
 connect to the database using sql net from oracle personal client?
 
 Irwan
 
 "Larry Meadors" [EMAIL PROTECTED] wrote:
  I got it working. Did you install the client part on the server? The
default
 driver that comes w/NT won't do.
  
  Larry
  
   [EMAIL PROTECTED] 05/31/00 10:04AM 
  Does anybody ever use CF server connect to Personal Oracle 8i? I tried but it 
can't work.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: query help - find duplicates

2000-06-03 Thread Larry Meadors

This always works for me:

SELECT po,line, count(po) as test from table group by po, line having test  1

You may not need the "as" for your db.

Good luck!

Larry

 [EMAIL PROTECTED] 06/01/00 10:21AM 
Im trying to create a primary key and cannot because I have a few duplicate
entries.  There should not be any so I am trying to find them.  The key
consists of 2 fields(po,line), Im trying to run a query that will only
display the duplicates, this is what Im trying.

SELECT po,line from table where po = po AND line = line

how can I change this so it only display's the duplicate entries?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [Re: personal oracle 8i]

2000-06-01 Thread Larry Meadors

Exactly! ;-)

 [EMAIL PROTECTED] 06/01/00 09:11AM 
Thanks. So you are saying that I must install the personal oracle server and
personal oracle client in the same machine, and configure the CF server to
connect to the database using sql net from oracle personal client?

Irwan

"Larry Meadors" [EMAIL PROTECTED] wrote:
 I got it working. Did you install the client part on the server? The default
driver that comes w/NT won't do.
 
 Larry
 
  [EMAIL PROTECTED] 05/31/00 10:04AM 
 Does anybody ever use CF server connect to Personal Oracle 8i? I tried but
it can't work.
 


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: personal oracle 8i

2000-05-31 Thread Larry Meadors

I got it working. Did you install the client part on the server? The default driver 
that comes w/NT won't do.

Larry

 [EMAIL PROTECTED] 05/31/00 10:04AM 
Does anybody ever use CF server connect to Personal Oracle 8i? I tried but it can't 
work.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: CF logins, authenticate against Novell NDS???how?

2000-05-31 Thread Larry Meadors

We've used NDS for NT and basic authentication. That works pretty well because the NDS 
users get replicated as NT users. Easy to set up too.

With CF 4.5's enhancements to cfheader, you can really use any data source to do 
basic authentication. We're also looking into using Novell's ODBC driver for NDS and 
there's also an ActiveX control that might work. Note: ODBC and ActiveX are not 
supported with CF by Novell (translation: "If it works, great, but if it doesn't, 
tough.").

There are also some JAVA classes from Novell that are supposed to work with the NDS. 
You might be able to use them (potentially from a cfx) to create other authentication 
schemes. 

Fun fun fun!

Larry

 [EMAIL PROTECTED] 05/31/00 08:45AM 
Does any one have any info on how to use NDS to build in a login to a cf
app?

My maneger wants me to start  working with real authenticated user info, 
instead of just Data that i have enterd into a mdb.

i dont really know where to start.

any Guidence would be wonderful!


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Some beginner questions

2000-05-31 Thread Larry Meadors

One thing to add/correct from Philip's response:

#cgi.query_string# contains url parameters. 

You can reference those as url.variablename (or just variablename) to get the values 
most of the time. 

One exception to look out for on that is if you have a url like this: 
index.cfm?a=5a=6a=7

When the same variable is named several times, the variable only gets the last value 
in the url, not all three. In that case, you have to use the List*() functions to get 
the variables...

HTH
Larry

 [EMAIL PROTECTED] 05/31/00 11:07AM 
 1) Can I call a JavaScript function from CF?
   Smth. like CFSET x = f(y)

   where f is a JavaScript function.

   I tried CFSET x = f(y), but it didn't work.

Firstly, CF is SERVER-side, JavaScript is CLIENT-site, they are mutually exclusive
Secondly, Why not write the code in CFScript and just run it on the variable?
CFScript
y=y+10;
y=y*x;
y=y-z;
/CFScript
Or whatever... but you can't create and call functions in CFScript.

 2) How do I manage strings containing special characters as dbl.
 quote (i.e. ")
   Should I prefix them with something.

   I'd like to have an output like

   say "hello"

Double the quotes... cfset s="say ""hello""" or cfset s="say
quot;helloquot;" will display the quotes properly (older browsers dislike
" as an output)

 3) How can I get the value of each field in a query string?
   I know the #cgi.query_string# which returns the entire
 query string, but I
 want to access specific fields

#myQuery.ColumnList# is a comma separated list of the fields called in a
query, note that
select * from myTable
fields will be in the order that CF decides.

Philip Arnold

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: CFInclude-Problem

2000-05-22 Thread Larry Meadors

You can't pass parameters with an include. 

You have several options:
1 - Change navigation_e to look for attributes.page
  cfmodule (look up the syntax ;-)
2 - Change navigation_e to look for attributes.page
  cf_navigation_e page="services"
3 - No changes to navigation_e
  cfset page="services"
  cfinclude template="navigation_e.cfm"

I'd lean towards one of the first 2 options...

Larry


 [EMAIL PROTECTED] 05/22/00 09:02AM 
Can s.o. tell me why this isn't possible ?

cfinclude template="navigation_e.cfm?page=services"

It throws an CFInclude-Template-error !
Ideas what to do instead ?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Boolean fields in Foxpro

2000-05-16 Thread Larry Meadors

The VFP ODBC driver also has a setting that will allow you to ignore deleted records. 

That would be easier and if you add an index tag on DELETED(), it's optimizable too! 
;-)

Larry

 [EMAIL PROTECTED] 05/15/00 03:43PM 
Michael,

Not a problem getting back.  I have never tried to do a pack via ODBC.
Pack is a native FoxPro command and as such I don't believe you can do it
from the ODBC driver.

It sounds like in order to physically remove the records you will need to
write a FoxPro program that will pack the database for you.  BTW, to do a
pack you will need exclusive use of the table(s).  So part of this process
will be to insure that everyone is out of the database before doing the
pack, or it will fail.

Are you having problems when the records are deleted having them retrieved?
 The way we deal with this is to have a field in the record that marks the
record as "deleted" without relying on FoxPro's deleted flag.  Usually we
use a DateTime field like tablename_deleted_datetime.  The default value of
this field is NULL and when we want to delete the record we store the
current datetime in the field.  Then when we select records we add 'AND
ISNULL(table_deleted_datetime)' to the where clause to filter these
records.  Make sure to set an index on the table for this field so your
query is Rushmore Optimizable.

FYI, if it appears that my responses are a bit slow I appologize.  I'm on
vacation from 5/15 until 5/30 but, as you can tell, I do check my E-Mail
once a day.  Also I only get the digest version so depending on when the
CF-Talk is delivered and I check mail will dictate when I reply.

Talk to you soon.

Bill Grover
Supervisor, IS
EU Services, Inc.
649 N Horners Ln
Rockville MD 20850

Phone:  301-424-3300 x396
FAX:301-424-3300 x1396#
E-Mail: [EMAIL PROTECTED] 

 Original Message 
Date: Mon, 15 May 2000 15:51:53 +0100
From: Michael O Reilly [EMAIL PROTECTED]
To: [EMAIL PROTECTED] 
Subject: RE: Boolean fields in Foxpro
Message-ID: ECE6504EA487D3118D8A00805F59102E7EB2BA@NT_BACKUP

Bill,

Apologies for not replying. The ISDN link for web and e-mail died on
Thursday and didn't come back until today.
After removing the Boolean field from the table, I discovered that the
numeric field I assumed was working correctly had been causing my problem
all along.
I am now able to add, modify and delete records using SQL.
I now have another problem. In Foxpro, records are marked for deletion. They
are only actually deleted when a PACK command is issued.
SQL delete command's only mark the record deleted. 
I want to schedule a .cfm which will pack all the tables once a week.

Do you know anything about sending 'PACK' command to Foxpro within SQL.
I'm sure this problem would affect all Xbase derived databases.

Regards
Michael O'Reilly
Analyst Programmer
TransAer


--
Archives: http://www.eGroups.com/list/cf-talk 
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: REVERSE QUESTION --- Is there anything that Cold Fusioncan do that ASP can't do?

2000-05-12 Thread Larry Meadors

My dream is for cfscript to support ActiveX scripting engines like ASP, so I could use 
javascript, vb script, perlscript, etc...

I suspect this wouldn't work on Solaris or Linux tho...

I want to have my cake and eat it too dammit! ;-)

Larry

 [EMAIL PROTECTED] 05/12/00 05:55AM 
While I've found anything I've wanted to do in CF is possible, it can to a
bit of a mess to code things at times, the more script v's tag method of
coding in ASP, does make for neater code sometimes ; and neater = less
mistakes :-)
Hopefully CF5 will have the ability to create functions in cfscript + more
functionally in cfscript generally.


~Justin MacCarthy


--
Archives: http://www.eGroups.com/list/cf-talk 
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: REVERSE QUESTION --- Is there anything that Cold Fusioncan do that ASP can't do?

2000-05-12 Thread Larry Meadors

I agree, and you can sorta do that now. ;-)

Look at this:

squareit.cfm
cfparam name="attributes.return"
cfparam name="attributes.x"
cfset temp = SetVariable("caller.#attributes.return#", attributes.x * attributes.x)

test.cfm
cfset y = 5
cf_squareit return = "z" x = 5
cfoutput#z#/cfoutput

It would be cleaner to say z = squareit(5), but the two really are the same.

Larry



 [EMAIL PROTECTED]  5/12  5:11p 
 Hopefully CF5 will have the ability to create functions in cfscript   more
 functionally in cfscript generally.

What would be cool is if we could write functions _also_ in CFML much like a
custom tag but with the ability to return a value then we  can do away
with the break in modularity by writing a return for a simple custom tag straight
into a variable in the caller.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Custom tag question

2000-05-12 Thread Larry Meadors

Are you looking for thistag.generatedcontent?

Larry

 [EMAIL PROTECTED]  5/12  8:07p 
For instance if I use a custom tag like this:
cfset var = "text"
cf_customTag
Long #var# string with variables embedded...
/cf_CustomTag

How do I capture what is nested within the tags into a variable in custom
tag template? Will it be possible to resolve the string so that a variable
can be assigned "Long text string with variables embedded..." within the
template?

Does anyone have any ideas?

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CGI.HTTP_AUTHORIZATION?

2000-05-10 Thread Larry Meadors

I'm using WebSite 2.3.7 with CF 4.5.1, and the CGI.HTTP_AUTHORIZATION variable doesn't 
show up.

Am I missing something?

Larry

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: REVERSE QUESTION --- Is there anything that Cold Fusioncan do that ASP can't do?

2000-05-09 Thread Larry Meadors

A big one for me is the nice integration with java (CFXs and 4.5's 
CreateObject("java", ...) function). I haven't seen anything like that with asp.

Someone mentioned ChiliSoft's ASP, but can it use the other ActiveX scripting engines 
(PerlScript, etc...)?

 [EMAIL PROTECTED]  5/ 8  7:34p 
Many people responded with some extremely small things.

So, I would like to ask the opposite question:
Is there anything that COLD FUSION can do that ASP can't do?

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Boolean fields in Foxpro

2000-05-09 Thread Larry Meadors

I know this works:

CFQUERY
INSERT INTO Tablename (BooleanField) VALUES (.T.)
CFQUERY

Larry
 [EMAIL PROTECTED] 05/09/00 01:50AM 
I can't believe that this is causing me so much grief.
Last night I tried the following

CFQUERY
INSERT INTO (Tablename.BooleanField)
VALUES ('.T.')
 CFQUERY

I also tried 
VALUES (.T.)
VALUES ('T')
VALUES (T)
VALUES ('#.T.#')

and none of these work.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Imp Atten: New Virus Info

2000-05-08 Thread Larry Meadors

It's a hoax:

http://www.symantec.com/avcenter/venc/data/wobbler-hoax.html

Bookmark this page:
http://www.symantec.com/avcenter/hoax.html

Larry

 [EMAIL PROTECTED] 05/08/00 09:37AM 
Don't now up to what extent it is true.
But Prevention is better than Cure


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Is there anything that ASP can do and CF cannot?

2000-05-05 Thread Larry Meadors

One thing I've wanted from CF and haven't seen is an equivalent to the flush() method 
of the response object. It sends the page contents that have been created so far back 
to the browser.

Another thing I've heard (I don't know the exact objects - are you reading this 
Chris?) is that CF can't get beyond the first dot in COM objects:
 myObj.someCollection[1].subCollection[1].item

Normally, you would work around this by getting someCollection from myObj, then 
subCollection from that variable. But I've heard that this doesn't always work either.

Larry

 [EMAIL PROTECTED] 05/05/00 10:02AM 
I was just wondering if there is something that cannot
be done in CF and can be done in ASP? Has anyone
encountered such an instance.

My understanding is that Active Server Pages (ASP) are
theoretically equivalent to Cold Fusion Pages but
using Microsoft proprietary programming.  My guess is
that we can do the same thing with Cold Fusion what we
can do in ASP.It wouldn't surprise me if Microsoft has
placed barriers to using other environments with its
products such as MS SQL Server.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: CF VFP ODBC

2000-05-01 Thread Larry Meadors

No, sorry, I never reported it. 

If you're serious about the COM option, Rick Strahl wrote a book on using vfp6 as a 
com server for internet applications - "Internet Applications with Visual FoxPro 6.0" 
that you might look into.

Good luck! ;-)

Larry

 [EMAIL PROTECTED] 04/29/00 06:40AM 
Larry, did you ever report this bug to MS?

I'll have to consider the COM option

--- Original message 
I had the same problem - 25 items was as far as I could go. 

If you're comfortable with VFP, you might consider creating a 
com object to get the data you want. If you choose that route, 
make sure you use VFP6 since it handles threads better...


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Very Weird INSERT Problem

2000-05-01 Thread Larry Meadors

You don't want a where in your insert. Try this: 

INSERT INTO USACopy (BusUnitID, ID) VALUES (8, 3)

Larry

 [EMAIL PROTECTED] 05/01/00 11:08AM 
I have tried everything, changing the name of the query, recreating the 
table, Naming the field different names and I still get the error:

Missing semicolon (;) at end of SQL statement.

I even tried adding the semicolon and then it says:

Characters found at end of SqL statement.

It is just a simple insert statement going into a table in ACCESS.

cfquery datasource="synergy" name="TryToInsert"
INSERT INTO USACopy(BusUnitID)
VALUES(8)
WHERE ID = 3
/cfquery


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Context for cfparam

2000-04-27 Thread Larry Meadors

Not always. ;-)

cfparam name="bob" default="123"
cfparam name="url.bob" default="234"
cfparam name="form.bob" default="345"
cfparam name="attributes.bob" default="456"
cfoutput
bob = #bob# br
url.bob = #url.bob# br
form.bob = #form.bob# br
attributes.bob = #attributes.bob# br
/cfoutput


 [EMAIL PROTECTED] 04/27/00 05:24AM 
VARIABLE.blah

peace,
holly





"Dana Larose" [EMAIL PROTECTED] on 04/26/2000 05:19:26 PM

Please respond to [EMAIL PROTECTED] 

   
 To:[EMAIL PROTECTED]  
   
 cc:(bcc: Holly C MacDonald-Korth/IRM/FRBOG/US)
   
   
   
 SubjectContext for cfparam  
 : 
   





Hmm...I couldn't find this in any of the manuals, so I decided to ask you
guys:

If I have a form variable, I can call it Form.blah, if it is a Session
variable, I can name it Session.blah.

But what is the context for variables set with cfparam or cfset?

I.e. if I have cfparam name="blah" default="" how do I do X.blah?

Thanks!

Dana


--
Archives: http://www.eGroups.com/list/cf-talk 
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



--
Archives: http://www.eGroups.com/list/cf-talk 
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: joining tables from a DB

2000-04-27 Thread Larry Meadors

A few things:

Do any of the tables have 0 records? If they do, you'll get nothing unless you do an 
outer join.

Also, you're doing what's called a "cartesian join", pronounced "call-from-admin 
join".  ;-)

To keep your phone from ringing, you need some type of join condition in your query to 
tell the db how they are related. The syntax is db specific, but this works in every 
one I've used:

SELECT * 
 FROM TABLE1, TABLE2, TABLE3 
 where table1.field = table2.field 
  and table1.field = table3.field

Of course you'll need to substitute real field and table names in there to indicate 
how the tables are related. 

Another (minor) point: don't select * unless you really, really need all the fields. 
It'll be slower than just selecting the fields you need because of the amount of data 
coming across the wire.

Good luck!
Larry

 [EMAIL PROTECTED] 04/27/00 11:35AM 
I'm trying to SELECT info from three tables and I keep getting 0 records
found heres my statement.

SELECT *
FROM TABLE1, TABLE2, TABLE3

Anyone see anything I could be doing wrong?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: VisualFoxpro Datasource

2000-04-19 Thread Larry Meadors

Are there data files with the database? They would have dbf/cdx/fpt extensions - at 
least one dbf file per table and potentially one cdx file and one fpt file per table.

Also, be careful using VFP data - the vfp odbc driver only allows queries (select  
update) around 250 characters long...

Larry

 [EMAIL PROTECTED] 04/19/00 10:21AM 

Can anyone tell me what is needed to setup a Visual Foxpro datasource?

I have the .dbc, .dct, and .dcx files

I can verify the datasource in the Cold Fusion administrator but when I try to open 
the tables in Studio I get an error.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Anyone selling CF Server cheap?

2000-04-05 Thread Larry Meadors

Have you looked into cf express, the free but limited version of CF?:
http://www.allaire.com/cfexpress/

Feature comparison:
http://www.allaire.com/products/coldfusion/techinfo/features/cf4Matrix.cfm

Larry
 [EMAIL PROTECTED] 04/04/00 11:47PM 
I have that version. I need to setup this prototype on a server and allow access to 
several folks to test it.

 -Original Message-
I you buy cf studio .. there is a Single-User version of cf server that comes with it 
on the cd
It's a little cheaper

  -Message d'origine-
I am looking for a copy of CF server pro but don't have the $1200. yet but need to 
create a prototype on my server. Does anyone have 4.0 version they want to sell?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: OT: Onchange submit

2000-04-04 Thread Larry Meadors

Try this:

form action="index.cfm"
SELECT NAME="PayType" ONCHANGE="this.form.submit()"
/form

 [EMAIL PROTECTED] 04/04/00 05:19AM 
I want a form to be submitted when the user makes a change in a select box. The form 
name 
is "Employeeform". This doesn't work:

SELECT NAME="PayType" ONCHANGE="document.Employeeform.action='index.cfm';
document.Employeeform.submit()"


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: View-Source in IE

2000-04-03 Thread Larry Meadors

File - Save As...

 [EMAIL PROTECTED] 04/03/00 09:40AM 
The coldfusion server, after executing a request/file
, sends only pure html to the browser. Is there a way
to catch this pure html code and save it as a file?

Thanks
Aslam 

__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com 
--
Archives: http://www.eGroups.com/list/cf-talk 
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Javascript Arrgh!!

2000-03-31 Thread Larry Meadors

I don't think that the form object in ie4 has an onClick method, the button does.

Also (and this is just a style thing) I think I'd break the onClick into a seperate 
function like this:

script
function SetAction(oForm, sAction){
  oForm.action = sAction;
};
function SetActionAndSubmit(oForm, sAction){
  SetAction(oForm, sAction);
  oForm.submit();
};
/script

INPUT TYPE="Button" VALUE="lt;lt;nbsp;Top" Name="Top" 
onClick="SetActionAndSubmit(this.form, 'search.cfm?cStartLot=Top');"
INPUT TYPE="Button" VALUE="gt;gt;nbsp;Bottom" Name="Bottom" 
onClick="SetActionAndSubmit(this.form, 'search.cfm?cStartLot=Bottom');"
etc...

A bit more readable?

HTH
Larry


 [EMAIL PROTECTED] 03/31/00 08:53AM 
Can any of you javascript gurus out there lend a helping hand ???


This works in netscape 4.x, but fails in i.e. 4 with a message that says :

"object doesn't support this property or method."

It looks like it's failing on the semi-colon after the word top

Changing the type from button to submit, makes the onclick "work", but the 
cstartlot does not get passed onto the next page.

fyi, there will be 3 or 4 of these buttons in the form, each with a 
different startlot that needs to be passed onto search.cfm.

INPUT TYPE="Button"
VALUE="lt;lt;nbsp;Top"
Name="Top"
onClick="document.CatNav.action='search.cfm?cStartLot=Top';document.CatNav. 
onClick="document.CatNav.action='search.cfm?cStartLot=Top';document.CatNav.s 
ubmit()"



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



[OT] Buying certificates

2000-03-30 Thread Larry Meadors

I'm looking into buying a certificate in the next 3-6 months, and am looking for 
input. 

I know there are several certificate authorities. Who do *you* buy certificates from? 
Why did you choose them? How are they to work with?

Larry

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [OT] Buying certificates

2000-03-30 Thread Larry Meadors

Thanks! This is just the kind of info I'm looking for!

 [EMAIL PROTECTED] 03/30/00 11:43AM 
I have gone the Verisign (http://www.verisign.com) route in the past. 
But their certificates are expensive, and the company was totaly
unresponsive to me when I had a question about a certificate I bought
for my personal site.

I have since moved my site to Media3.net (great guys BTW) and am using a
certificate from Equifax.  Same level of 128-bit security but you get to
keep the certificate when you move servers, which I did not get with
Verisign and my old ISP.  Also, Equifax is having a special right now,
only $45 to get a one year certificate if you purchase it before May
15th, I think.  Much cheaper than Verisign's $300 or so.

Larry Meadors wrote:
 I'm looking into buying a certificate in the next 3-6 months, and am looking for 
input.
 I know there are several certificate authorities. Who do *you* buy certificates 
from? Why did you choose them? How are they to work with?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Automated Error pages

2000-03-30 Thread Larry Meadors

I haven't done this, but I know you can use cfoutput. 

Couldn't you create a form with hidden fields containing your error message and submit 
it automatically using javascript?

Larry

 [EMAIL PROTECTED] 03/30/00 02:02PM 
I am trying to work on making an automated error page. Thing is stupid
cferror doesn't let you use any tags in your error page. So what I have to
do is mailto:[EMAIL PROTECTED]?subject=errorbody=errortext only thing is
once it hits some text in there it craps out on the body part. Has anyone
done something like this?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



iPlanet Web Server

2000-03-29 Thread Larry Meadors

Does CF run on the iPlanet Web Server? I see both support NSAPI, so I presume the 
answer is "yes".

Also is anyone out there familiar with WebSite or IIS using it? How does it compare?

Larry


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.