RE: Java help - convert -D command line option to CF?

2007-12-08 Thread Hareni Venkatramanan 
Perhaps, you can try to instantiate java.lang.System and set the system
property in the coldfusion code?
Something like,

cfset sys = createObject(java, java.lang.System)
cfset sys.setProperty(com.java4less.vision.maxarea, 9)

Hope that helps.

Thanks,
Hareni

-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED] 
Sent: 08 December 2007 04:19
To: CF-Talk
Subject: Java help - convert -D command line option to CF?

I am converting a little java code into CF8.   The sample Java program I

am working from is meant to be run with this command line option:

-Dcom.java4less.vision.maxarea=90

Without having that set, my results in ColdFusion are not working very 
well.   Anyone know how I can do something like the above in 
ColdFusion?   I have no vision object to work with or anything, I'm 
only working with 1 instantiated java object and there is no maxarea 
property or setter in that object.

I imagine I could change ColdFusion's JVM start up parameters to include

that option, but I don't really like that idea.

-Ryan




~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: Using custom java classes with MX 7

2007-12-06 Thread Hareni Venkatramanan 
Hi Dave,

You need to place the .class files in
C:\CFusionMX7\wwwroot\WEB-INF\classes dir  or add the path to the class
file to the classpath specified on the JVM and Java Settings page in the
ColdFusion MX Administrator.


http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/ht
ml/wwhelp.htm?context=ColdFusion_Documentationfile=1561.htm will
give you more information on this.

Thanks,
Hareni


-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED] 
Sent: 05 December 2007 19:49
To: CF-Talk
Subject: Using custom java classes with MX 7

Greetings,

I haven't really had the opportunity to use Java with ColdFusion very
much and it's been a long time...

Where do I place a java class called cftest.class that resides in a
java package called davepack? 
I put package in the C:\CFusionMX7\wwwroot\WEB-INF directory but it
says it can't find the class?

Here's how I'm attempting to use the class in CF, I think the code
syntax is correct.

cfobject type=java action=create class=davepack/cftest
name=cftest
cfset void = cftest.init() 
cfset status = cftest.myTestMethod()


Thanks,
 
Dave Bosky | Information Services | HTC | direct:  843-369-8613 | fax:
843-369-7178 | [EMAIL PROTECTED]

**
HTC Disclaimer:  The information contained in this message may be
privileged and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution or copying of
this communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.
**




~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: fixing a piece of code

2007-10-30 Thread Hareni Venkatramanan 
Hi Toby,

There is an extra #) in the insert query inside your cfloop tag. If you
remove it, it should work fine.

Thanks,
Hareni
Adobe CF team

-Original Message-
From: Toby King [mailto:[EMAIL PROTECTED] 
Sent: 30 October 2007 18:48
To: CF-Talk
Subject: fixing a piece of code

Hi there

I have a 2 programs one which displays dual select boxes on the screen.
A user click on  a persons name in the left-hand selection box and move
the name to the right-hand box and vice versa.

A button is at the bottom of the screen and when the user presses the
button the names in the right hand sidebox will then be used to update a
table in the database.

The trouble is that the code isnt working and  cant see why:

I keep getting an error:

Context validation error for the cfloop tag.  
The start tag must have a matching end tag. An explicit end tag can be
provided by adding /cfloop. If the body of the tag is empty, you can
use the shortcut cfloop .../. 

Here is the code that I have:

cfquery name=qdeleterecs datasource=#request.db_dsn#
username=#request.db_login# password=#request.db_pwd#
DELETE
FROM tbl_onshift
/CFQUERY

cfloop list=#girls# index=q 
 cfquery name=qinsertrecs datasource=#request.db_dsn#
username=#request.db_login# password=#request.db_pwd#
  INSERT INTO tbl_onshift (girlid, girlwname) 
  VALUES ('#q#', #form.girlwname#)#) 
 /cfquery 
/cfloop 

Any thoughts would be greatly appreciated - I have been stuck on this
for a couple of hours.

Regards






~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: Coldfusion 8 Adminapi Datasource problem

2007-10-22 Thread Hareni Venkatramanan 
Hi John,

In the function myObj.setMSSQL(), the values of timeout and interval
are specified in seconds ( pl. refer
cf_root/CFIDE/adminapi/datasource.cfc for APIs), whereas in admin, the
interval and timeout values are displayed in mins. Therefore, in your
example (20/60) is rounded off to zero.

Thanks,
Hareni

-Original Message-
From: John Elkins [mailto:[EMAIL PROTECTED] 
Sent: 20 October 2007 06:57
To: CF-Talk
Subject: Re: Coldfusion 8 Adminapi Datasource problem

Care to show the code?




Care to show the code?


Sure. I used an example from CF8 live docs... which actually has an
error:

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=basico
nfig_37.html

(setStringParameterAsUnicode should be
sendStringParametersAsUnicode)

myObj.setMSSQL(driver=MSSQLServer, 
name = #newdsn#, 
host = #databaseServerIP#, 
port = 1433,
database = #dbname#,
username = #databaseUID#,
password = #databasePWD#,
login_timeout = 30,
timeout = 20,
interval = 7,
buffer = 64000,
blob_buffer = 64000,
sendStringParametersAsUnicode = true,
description = ,
pooling = true,
maxpooledstatements = 1000,
enableMaxConnections = false,
maxConnections = 0,
enable_clob = false,
enable_blob = false,
disable = false,
selectmethod = direct,
storedProc = true,
alter = true,
grant = false,
select = true,
update = true,
create = true,
delete = true,
drop = true,
revoke = false );
}

I am setting Timeout = 20 and Interval = 7.  The datasource gets created
properly with all the other parameters specified, but these remain 0's.

Thanks,

John 



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

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

RE: error with ColdFusion 8 ODBC Agent

2007-10-04 Thread Hareni Venkatramanan 
Hi Jim,

Just a small check, in the line

createObject(component,cfide.adminapi.administrator).login(admin)

Instead of admin, you need to provide your admin password. Is your
admin password the same?


Thanks,
Hareni


-Original Message-
From: Jim Easterly [mailto:[EMAIL PROTECTED] 
Sent: 04 October 2007 01:04
To: CF-Talk
Subject: Re: error with ColdFusion 8 ODBC Agent

Hi,
I have this same issue on a fresh install of CF8 Standard edition using
IIS.  When I run the scripts it returns this message,

The current user is not authorized to invoke this method.

I am logged in as the Administrator.

How should these .cfm pages be run?


Hi Matthew,

Sometimes, it might happen that the ODBC services Coldfusion8 ODBC
Agent
and Coldfusion 8 ODBC Server do not get installed properly for new J2EE
deployment and in services property the path keeps pointing to an old
deployment directory and hence they do not start up. 

What you can do is, remove the existing ODBC services using
remove-odbcservices.cfm having the script given below:

cfscript


createObject(component,cfide.adminapi.administrator).login(admin)
;

myObj =
createObject(component,cfide.adminapi.datasource);

writeOutput(Removing ODBC Services...br);

returnValue = myObj.removeODBCservice();

writeOutput(ODBC Services removed);

/cfscript



And then, install the ODBC services using install-odbcservices.cfm
having the script given below:

cfscript


createObject(component,cfide.adminapi.administrator).login(admin)
;

myObj =
createObject(component,cfide.adminapi.datasource);

writeOutput(Installing ODBC Services...br);

returnValue = myObj.installODBCservice();

writeOutput(ODBC Services installed);

/cfscript

Then, try starting ColdFusion ODBC Server service.

Thanks,
Hareni

I am trying to add a datasource to my new install of CF8 developer
edition.  When I went to do so in cf admin, the admin said The
ColdFusion ODBC Server service is not running or has not been
installed.  So I figured the service wasn't set to automatic and went
into services to start it up.  When I tried to start the service, I got
this error:
Could not start the ColdFusion 8 Odbc Server service on Local computer.
Error 3 The system cannot find the path specified.
 
I did a clean install of windows and CF 8. 



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: HELP! RE: error with ColdFusion 8 ODBC Agent

2007-10-03 Thread Hareni Venkatramanan 
Hi Mark,

You need to be logged in as admin to avoid getting this error. Can you
try running the scripts from CFIDE/administrator directory?

Thanks,
Hareni
Adobe CF team

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: 29 September 2007 20:41
To: CF-Talk
Subject: HELP! RE: error with ColdFusion 8 ODBC Agent

I just did an install on a production server and cannot get this script
to
run.  I get this error:

The current user is not authorized to invoke this method

What am I doing wrong?  How do I fix?  Uninstalling and reinstalling CF8
is
not an option, since I have all the mappings, cf and cfx tags and
browserhawk installed and running.

Mark

-Original Message-
From: Hareni Venkatramanan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 22, 2007 2:17 AM
To: CF-Talk
Subject: RE: error with ColdFusion 8 ODBC Agent

Hi Matthew,

Sometimes, it might happen that the ODBC services Coldfusion8 ODBC Agent
and Coldfusion 8 ODBC Server do not get installed properly for new J2EE
deployment and in services property the path keeps pointing to an old
deployment directory and hence they do not start up. 

What you can do is, remove the existing ODBC services using
remove-odbcservices.cfm having the script given below:

cfscript


createObject(component,cfide.adminapi.administrator).login(admin);

myObj =
createObject(component,cfide.adminapi.datasource);

writeOutput(Removing ODBC Services...br);

returnValue = myObj.removeODBCservice();

writeOutput(ODBC Services removed);

/cfscript



And then, install the ODBC services using install-odbcservices.cfm
having the script given below:

cfscript


createObject(component,cfide.adminapi.administrator).login(admin);

myObj =
createObject(component,cfide.adminapi.datasource);

writeOutput(Installing ODBC Services...br);

returnValue = myObj.installODBCservice();

writeOutput(ODBC Services installed);

/cfscript

Then, try starting ColdFusion ODBC Server service.

Thanks,
Hareni

-Original Message-
From: Matthew Smith [mailto:[EMAIL PROTECTED] 
Sent: 22 August 2007 01:25
To: CF-Talk
Subject: error with ColdFusion 8 ODBC Agent

I am trying to add a datasource to my new install of CF8 developer
edition.  When I went to do so in cf admin, the admin said The
ColdFusion ODBC Server service is not running or has not been
installed.  So I figured the service wasn't set to automatic and went
into services to start it up.  When I tried to start the service, I got
this error:
Could not start the ColdFusion 8 Odbc Server service on Local computer.
Error 3 The system cannot find the path specified.
 
I did a clean install of windows and CF 8.
 









~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: CF 8 Sample DBs

2007-09-26 Thread Hareni Venkatramanan 
Hi,

You can make use of the functions in CFIDE/adminapi/datasource to
install the sample dbs.

Run this script:

cfset cfusion = server.coldfusion.rootdir
cfset sep = createObject(java, java.io.File).separator
cfscript
datasource = createObject(component,
CFIDE.adminapi.datasource);
datasource.setDerbyEmbedded(name=cfdocexamples
, database=cfusion 
#sep#db#sep#cfdocexamples
);
datasource.setDerbyEmbedded(name=cfbookclub
, database=cfusion 
#sep#db#sep#bookclub
);
datasource.setDerbyEmbedded(name=cfartgallery
,database=cfusion 
#sep#db#sep#artgallery
);
datasource.setDerbyEmbedded(name=cfcodeexplorer
,database=cfusion 
#sep#db#sep#cfcodeexplorer
);

/cfscript

Make sure that you have the .cfm file in CFIDE/administrator folder else
the above script will throw an exception mentioning that the current
user is not authorized to invoke the method.

Thanks,
Hareni



-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] 
Sent: 26 September 2007 20:14
To: CF-Talk
Subject: CF 8 Sample DBs

Anyone know how to install the sample db's for CF8 after the server has 
already been installed without them? Just the db's?

-- 
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com



~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: error with ColdFusion 8 ODBC Agent

2007-08-22 Thread Hareni Venkatramanan 
Hi Matthew,

Sometimes, it might happen that the ODBC services Coldfusion8 ODBC Agent
and Coldfusion 8 ODBC Server do not get installed properly for new J2EE
deployment and in services property the path keeps pointing to an old
deployment directory and hence they do not start up. 

What you can do is, remove the existing ODBC services using
remove-odbcservices.cfm having the script given below:

cfscript


createObject(component,cfide.adminapi.administrator).login(admin);

myObj =
createObject(component,cfide.adminapi.datasource);

writeOutput(Removing ODBC Services...br);

returnValue = myObj.removeODBCservice();

writeOutput(ODBC Services removed);

/cfscript



And then, install the ODBC services using install-odbcservices.cfm
having the script given below:

cfscript


createObject(component,cfide.adminapi.administrator).login(admin);

myObj =
createObject(component,cfide.adminapi.datasource);

writeOutput(Installing ODBC Services...br);

returnValue = myObj.installODBCservice();

writeOutput(ODBC Services installed);

/cfscript

Then, try starting ColdFusion ODBC Server service.

Thanks,
Hareni

-Original Message-
From: Matthew Smith [mailto:[EMAIL PROTECTED] 
Sent: 22 August 2007 01:25
To: CF-Talk
Subject: error with ColdFusion 8 ODBC Agent

I am trying to add a datasource to my new install of CF8 developer
edition.  When I went to do so in cf admin, the admin said The
ColdFusion ODBC Server service is not running or has not been
installed.  So I figured the service wasn't set to automatic and went
into services to start it up.  When I tried to start the service, I got
this error:
Could not start the ColdFusion 8 Odbc Server service on Local computer.
Error 3 The system cannot find the path specified.
 
I did a clean install of windows and CF 8.
 





~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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

RE: Formatting a Date for MSSQL

2007-08-21 Thread Hareni Venkatramanan 
Hi Rob,

I tried something like this and it worked fine for me:

Here is my stored proc in sql 2000 which inserts a datetime value into a
table testdate:

CREATE procedure updatedate
@startdate datetime
as
begin
insert into testdate values (@startdate);
end

GO


And here is the coldfusion code that I used to execute the stored proc:

cfset foo = createDateTime(2000, 1 , 1 , 0, 0, 0)

cfstoredproc procedure=updatedate datasource=testtrigger
username=sa password=admin
cfprocparam type=IN cfsqltype=cf_sql_date value=#foo#
/cfstoredproc


This one worked without any hassles. Are you doing anything different
from this? If yes, can you post the code here?

-Original Message-
From: Rob Parkhill [mailto:[EMAIL PROTECTED] 
Sent: 21 August 2007 03:08
To: CF-Talk
Subject: Formatting a Date for MSSQL

I have been banging my head against the wall all afternoon.  I am trying
to update a table in SQL 2000 with a date time column using a stored
procedure.  The procedure is set to recieve the variable as a Datetime
format for SQL, I am sending it as a CF_SQL_Date type and have used
about as many combinations of creating the date that I can think of...
CreateDate - CreateDateTime - CreateODBCDate -CreateODBCDatetime

They all give me the same error that a variable of type varchar cannot
be converted to datetime - in the stored procedure.  So the variable
itself is what? a varchar??? even though it should be a datetime...  I
have done some googling, but to no avail...

If anyone can shed some light for me, that would be great!

Thanks,

Rob 



~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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