fs_admin

2003-04-02 Thread Jack Ince
Installation works perfect with MX, but falters with CF5.0.

CFFILE chokes on nameconflict

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Form Building software

2003-03-28 Thread Jack Ince
I would be interested also. I like this kind of application.
TIA

-Original Message-
From: Clint [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 5:47 AM
To: CF-Talk
Subject: Re: Form Building software


I have also just built a simple form builder that builds a form off of a SQL
Server table.

You just point it at a table and it generates a form. If anyone is
interested I will put it in a zip file
so that it can be downloaded.

Clint

- Original Message -
From: Massimo, Tiziana e Federica [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 28, 2003 7:30 AM
Subject: Re: Form Building software


 Thane Sherrington [EMAIL PROTECTED] wrote in message
 news:[EMAIL PROTECTED]
  Is there any good software out there that will allow me to build simple
  forms for CF (I'm in the process of designing my own, but if there's
  something done, why reinvent the wheel?)  I'm tired of creating the
 largely
  repetitive code for database entry forms and the connected
  add/update/delete scripts.


 Dreamweaver MX can really speed up that part of the job. I would suggest
to
 give it a try

 
 Massimo Foti
 Team Macromedia Volunteer for Dreamweaver
 Certified Dreamweaver MX Developer
 Certified Advanced ColdFusion MX Developer
 http://www.macromedia.com/go/team
 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFC Flash connection

2003-03-20 Thread Jack Ince
I can not get flash to find the connection.
Been messing with this for two days and can not get the hang of it,
I hope Hal Helm's book will clear it up, but in the meantime --- HELP
--
Flash action:

if (inited == undefined) {
inited = true;
var gwURL = http://localhost:8500/flashservices/gateway;;
NetServices.setDefaultGatewayURL(gwURL);
gw = NetServices.createGatewayConnection();
categoryService = gw.getService(test.category, this);
categoryService.GetCategories();
}
 -
Cfc in the same Test folder:

!--- category.cfc ---
CFCOMPONENT
CFFUNCTION NAME=GetCategories
ACCESS=remote
RETURNTYPE=query
OUTPUT=false

!--- Get departments ---
CFQUERY NAME=Categories username=sa password= 
DATASOURCE=Exec_exec
SELECT *
FROM Maincat
ORDER BY maincat
/CFQUERY
CFRETURN Categories
/CFFUNCTION

/CFCOMPONENT 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfgrid issues

2003-03-11 Thread Jack Ince
I have the same problem. Old cfgrid worked (slow) and I could insert,
delete, and update.
Now I can not update -- the form fields do not get filled out correctly. I
have asked about this on several different forums, but no one answers.
These people have a product that is supposed to be good.
http://216.74.28.185/products/cfgrid/index.cfm

-Original Message-
From: charlie griefer [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 2:21 PM
To: CF-Talk
Subject: cfgrid issues


Hey All:

Having some issues with cfgrid.

I inherited this application that uses cfgrid to allow certain staff members
to update a db table directly.

This was built on CF 4.5, and we're now on 5.0 (we have been for around 6
months now).  I don't know if it just broke now (which would be weird), or
if I just wasn't made aware of it since our upgrade.

In any event, I'm getting an error on the form's action page.  I'm
outputting a #cfcatch.message#, and getting 'Grid crossref not found'
(crossref being the name of the grid on the form page).

A cfdump var=#form# shows a field named crossref, but no value in it  (I
do have the enablecab=yes attribute in the cfform).  I also just replaced
the cfjava2.jar file in webroot\cfide\classes with one that I downloaded
from MM's site (as noted in technote 17998 located at
http://www.macromedia.com/support/coldfusion/ts/documents/tn17998.htm).

Still, no success.

I have very little experience with cfform and the java form controls, so I'm
not sure where to even begin with troubleshooting/debugging this.

Any advice would be greatly appreciated.

Thx,
Charlie

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Foxpro databases: does CF use indexes?

2003-03-10 Thread Jack Ince
Foxpro is independent of CF.
When you submit you cfquery all data gathering is passed off to Foxpro. From
there Foxpro will proceed just like it was a Foxpro request, and will use
any index it can. I assume that your management has upgraded to Visual FP if
they are so concerned about the speed.

-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 7:22 AM
To: CF-Talk
Subject: Foxpro databases: does CF use indexes?


Management here has seen time-to-production decimated since I introduced
Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy
Foxpro databases.

If I have CF read some Foxpro database files (.dbf), will it use the
database index files (.cdx) automatically?

How could I tell?

How could I *prove to management* that it indeed is using them?

If not, can I explicitly use them? How?

Thanks in advance for your help...

Ed Gordon

---

Old so Soon,
Smart so Late,
When I'm Learning,
... Life is Great!



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Stored Procedures problem

2003-03-06 Thread Jack Ince
I am having troouble with stored procedures. I would like to use the currect
protocol if possible.
  My stored procedure:

  --

  CREATE PROCEDURE dbo.Q_CheckItem

  @Items_id int,

  @card varchar(20) output

  AS

  BEGIN

  SELECT

  card

  FROM

  Items

  WHERE

  Items_id = @Items_id

  END

  GO

  ---

  On the page : This returns a blank card field.

  cfstoredproc procedure=Q_CheckItem

  datasource=#dsn#

  password=#password#

  username=#username#

  returncode=Yes

  cfprocparam type=In

  cfsqltype=CF_SQL_INTEGER

  dbvarname=@items_id

  value=#form.items_id#

  cfprocparam type=InOut

  cfsqltype=CF_SQL_VARCHAR

  dbvarname=@card

  variable=card

  cfprocresult name=result

  cfprocresult name=card

  /cfstoredproc

  cfstoredproc procedure=Q_CheckItem

  datasource=#dsn#

  password=#password#

  username=#username#

  returncode=Yes

  cfprocparam type=In

  cfsqltype=CF_SQL_INTEGER

  dbvarname=@items_id

  value=#form.items_id#

  cfprocparam type=Out

  cfsqltype=CF_SQL_VARCHAR

  dbvarname=@card

  variable=card

  /cfstoredproc

  cfoutput

  #card#

  /cfoutput

  
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Stored Procedures problem

2003-03-06 Thread Jack Ince
Thanks Craig
I missed using the resultset.
I went to school in Surrey many years back.
Jack

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 6:49 AM
To: CF-Talk
Subject: RE: Stored Procedures problem


Try this..


--

  CREATE PROCEDURE dbo.Q_CheckItem

  @Items_id int

  AS

  SELECT card FROM Items WHERE Items_id = @Items_id

--

  cfstoredproc procedure=Q_CheckItem datasource=#dsn#
password=#password#  username=#username#  returncode=Yes
  cfprocparam type=In  cfsqltype=CF_SQL_INTEGER
dbvarname=@items_id  value=#form.items_id#
  cfprocresult name=card resultset=1
  /cfstoredproc

  cfoutput#card.card#/cfoutput

--


-Original Message-
From: Jack Ince [mailto:[EMAIL PROTECTED]
Sent: 06 March 2003 14:36
To: CF-Talk
Subject: Stored Procedures problem


I am having troouble with stored procedures. I would like to use the
currect protocol if possible.
  My stored procedure:

  --

  CREATE PROCEDURE dbo.Q_CheckItem

  @Items_id int,

  @card varchar(20) output

  AS

  BEGIN

  SELECT

  card

  FROM

  Items

  WHERE

  Items_id = @Items_id

  END

  GO

  ---

  On the page : This returns a blank card field.

  cfstoredproc procedure=Q_CheckItem

  datasource=#dsn#

  password=#password#

  username=#username#

  returncode=Yes

  cfprocparam type=In

  cfsqltype=CF_SQL_INTEGER

  dbvarname=@items_id

  value=#form.items_id#

  cfprocparam type=InOut

  cfsqltype=CF_SQL_VARCHAR

  dbvarname=@card

  variable=card

  cfprocresult name=result

  cfprocresult name=card

  /cfstoredproc

  cfstoredproc procedure=Q_CheckItem

  datasource=#dsn#

  password=#password#

  username=#username#

  returncode=Yes

  cfprocparam type=In

  cfsqltype=CF_SQL_INTEGER

  dbvarname=@items_id

  value=#form.items_id#

  cfprocparam type=Out

  cfsqltype=CF_SQL_VARCHAR

  dbvarname=@card

  variable=card

  /cfstoredproc

  cfoutput

  #card#

  /cfoutput




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CF_Grid error

2001-01-22 Thread Jack Ince

Hi
This is my first posting, and I really do need help.
I am using a CF_Grid for my client to input data.
It works on my machine and the ISP's machines, but not on the
clients.
The client has all java enabled etc.
tks
**
java.io.FileNotFoundException:
www.odd-lot.com:80//CFIDE/classes/allaire/controls/cfGridFormApp
let.class

java.lang.ClassNotFoundException:
allaire.controls.cfGridFormApplet
 at com/ms/vm/loader/URLClassLoader.loadClass
 at com/ms/vm/loader/URLClassLoader.loadClass
 at com/ms/applet/AppletPanel.processSentEvent
 at com/ms/applet/AppletPanel.processSentEvent
 at com/ms/applet/AppletPanel.run
 at java/lang/Thread.run
Microsoft (R) VM for Java (tm), 4.0 Release 4.79.0.2424
==



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF_Grid error

2001-01-22 Thread Jack Ince

I am using CFGRID as comes with the package

-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 8:38 AM
To: CF-Talk
Subject: Re: CF_Grid error


At 08:00 AM 1/22/01 -0800, you wrote:
Hi
This is my first posting, and I really do need help.
I am using a CF_Grid for my client to input data.
It works on my machine and the ISP's machines, but not on the
clients.
The client has all java enabled etc.

If you are talking about CFGrid (as opposed to a custom tag as
your message
implies), we have problems in netscape that we don't in IE. We
have
problems with Mac apparently also. When our Mac people have to
do
data-entry with the application that uses it, they come in to
this room to
use the PCs. CFGrid seems like a really good idea if you can
mandate the
environment, but it's being a pain in the butt. At least I
didn't do it.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists