date:20050923

How do I do a sort on records that already have been searched and are 
displayed? 

I have a button that's called ascend and when clicked I want it to sort the 
selected records displayed but it sorts and displays the entire record count. 

For example on the search on lname it finds 7 records. In the display screen 
for those 7 records I want to sort them and the cfif isdefind takes care of 
that but of course it doesn't know the #form.lname# of the initial search and 
sorts through and displays all records. I guess I use a variable of some sort? 
Sorry its been a while.

Any help appreciated. Thanks.

Robert O.

Here is the code:

cfquery name=Getpc datasource=pc_inventory
SELECT * FROM inventory where 0 = 0

CFIF IsDefined(FORM.lname) and form.lname NEQ  
And lname LIKE '#FORM.lname#%'
/CFIF 

CFIF IsDefined(form.ascend.x)
Order by pcname desc
CFELSE
Order By ID DESC
/cfif

/cfquery




-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005
 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219048
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Sort records searched

I'd take a look at this:
http://www.activewidgets.com/


!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 7:44 AM
To: CF-Talk
Subject: Sort records searched


How do I do a sort on records that already have been searched and are
displayed?

I have a button that's called ascend and when clicked I want it to sort
the selected records displayed but it sorts and displays the entire record
count.

For example on the search on lname it finds 7 records. In the display screen
for those 7 records I want to sort them and the cfif isdefind takes care of
that but of course it doesn't know the #form.lname# of the initial search
and sorts through and displays all records. I guess I use a variable of some
sort? Sorry its been a while.

Any help appreciated. Thanks.

Robert O.

Here is the code:

cfquery name=Getpc datasource=pc_inventory
SELECT * FROM inventory where 0 = 0

CFIF IsDefined(FORM.lname) and form.lname NEQ 
And lname LIKE '#FORM.lname#%'
/CFIF

CFIF IsDefined(form.ascend.x)
Order by pcname desc
CFELSE
Order By ID DESC
/cfif

/cfquery




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219049
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: How to debug Could not generate stub objects for web service invocation error

2005-09-23 Thread Mark A Kruger

Victor,

Don't give up too soon :)  Make sure and test the obvious - like is the URL
resolvable on the server (not on your local machine - but the server
it'self.

-Mark

-Original Message-
From: Victor Moore [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 6:40 PM
To: CF-Talk
Subject: Re: How to debug Could not generate stub objects for web
service invocation error


Hi Barney,
 Thanks for the quick response.
 It's an internal service at one customer.
we are doing some tests so the service it's very simple and it has only 2
string arguments. We are trying a proof of concept at this point and
unfortunately it doesn't look good :(
 regards
Victor

 On 9/22/05, Barney Boisvert [EMAIL PROTECTED] wrote:

 Perhaps it's a service that CF simply can't call? For instance, it
 uses data types that CF doesn't support. What's the service in
 question?

 cheers,
 barneyb

 On 9/22/05, Victor Moore [EMAIL PROTECTED] wrote:
  Hi,
  I am trying to invoke a web service on a webObjects server and I get the
  Could not generate stub objects for web service invocation error.
  If I access the wsdl in the browser, it display properly and I can see
 that
  the method I'm calling exists and I'm passing the proper arguments.
  I have no control over the web service.
  Any gurus out there that can provide any insight?
  Thanks
  Victor
 

 --
 Barney Boisvert
 [EMAIL PROTECTED]
 360.319.6145
 http://www.barneyb.com/

 Got Gmail? I have 100 invites.





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219050
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Sort records searched

2005-09-23 Thread Michael Traher

do you just need to make sure that form.lname is still available for the
second select?
 if that is the case then maybe the answer would be to have the display
logic and the select as part of the cfm page in someway.
 for example
 cfparam name=form.lname default=
cfif structkeyexists(form,mainsubmit) or
structkeyexists(form,ascendbutton)
 !--- in here do your select ---
 /cfif
 !--- display your form here with action=thispage so that it submits to
itself and ascend button also submits form ---
 If it seems wrong to have query and display logic in the same page then put
them in separate files and use cfinclude to tidy things up.
 hope that helps

 On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:

 How do I do a sort on records that already have been searched and are
 displayed?

 I have a button that's called ascend and when clicked I want it to sort
 the selected records displayed but it sorts and displays the entire record
 count.

 For example on the search on lname it finds 7 records. In the display
 screen for those 7 records I want to sort them and the cfif isdefind takes
 care of that but of course it doesn't know the #form.lname# of the initial
 search and sorts through and displays all records. I guess I use a variable
 of some sort? Sorry its been a while.

 Any help appreciated. Thanks.

 Robert O.

 Here is the code:

 cfquery name=Getpc datasource=pc_inventory
 SELECT * FROM inventory where 0 = 0

 CFIF IsDefined(FORM.lname) and form.lname NEQ 
 And lname LIKE '#FORM.lname#%'
 /CFIF

 CFIF IsDefined(form.ascend.x)
 Order by pcname desc
 CFELSE
 Order By ID DESC
 /cfif

 /cfquery




 --
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005



 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219051
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What version of the JVM is ColdFusion/JRun Using?

2005-09-23 Thread Douglas Knudsen

1.5 is supported under the latest JRun updater, but CF is not.  Note
that the last time I looked at this, can't use a JVM  1.4.2_05 with
CF.

http://www.macromedia.com/support/documentation/en/jrun/4/releasenotes_4_updater6.html#resolved

DK

On 9/23/05, Troy Simpson [EMAIL PROTECTED] wrote:
 Does Macromedia certify the various JVMs with JRun/ColdFusion?
 For example, has Macromedia certify Sun's 1.5 JVM?
  Thanks,
 Troy

 --
 Troy Simpson
 Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
 North Carolina State University Libraries
 Campus Box 7111 | Raleigh | North Carolina
 ph.919.515.3855 | fax.919.513.3330
 E-mail: [EMAIL PROTECTED]


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219052
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Credit card storage

2005-09-23 Thread Montgomery Chris Ctr AFSFC/SFPA

I started down a similar path for a client. What I ended up doing, instead,
was to write the order forms and processing code in CF and then I converted
the final order confirmation page to ASP.net and passed all form values to
that for submission to the Cybersource site. My boss knows .NET, so he was
nice enough to step thru the CF processing code with me and we wrote the
form processing form together to send the post to Cybersource. If anyone
wants a copy of that, lemme know. Cheers.

-- 
//SIGNED//
Chris Montgomery, Contractor 
HQ AF Security Forces Center, Antiterrorism Branch 
1517 Billy Mitchell Blvd, Bldg 954 
Lackland AFB, TX 78236-0119 
DSN 312.945.7150
Comm 210.925.7150


 -Original Message-
 From: David Livingston [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 22, 2005 1:35 PM
 To: CF-Talk
 Subject: Re: Credit card storage
 
 
 Bank of America  now uses cybersource (http://cybersource.com) as  
 their processing service. They do not provide any api's or support  
 for coldfusion. I ended up using their php solution and calling it  
 from the command line using cfexecute. Not the cleanest solution but  
 it works.
 
 FYI
 
 Dave

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219053
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CF Studio Updater for MX 6.1

2005-09-23 Thread Montgomery Chris Ctr AFSFC/SFPA

I'm trying to locate the updater for CF Studio 5. I've started using CF MX
6.1 both at home and here at work but all I can find for updaters is MX 7.
Anyone got the URL for the link to the 6.0/6.1 updater(s)? Thanks.

-- 
//SIGNED//
Chris Montgomery, Contractor 
HQ AF Security Forces Center, Antiterrorism Branch 
1517 Billy Mitchell Blvd, Bldg 954 
Lackland AFB, TX 78236-0119 
DSN 312.945.7150
Comm 210.925.7150

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219054
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to debug Could not generate stub objects for web service invocation error

2005-09-23 Thread Victor Moore

Well I'm trying, but I run out of ideas.
 Yes, the url is resolvable from the server and displays the wsdl.
 I was wondering if there is anyway to see the SOAP header generated by
cfinvoke? If I could see it then maybe I can see something ..but as I said
it's a pretty basic service. The customer is moving to a SOAP architecture
and we have to be able to communicate. They are a java shop and if I cannot
connect from CF (they say it's working fine from some of their java apps)
they will phase CF out. At this point I don't know what to look for. I have
done searchs and found a number of people having this problem but no really
solution.
They are running CFMX 6.1 version 6,1,0,63958 and the test server is running
on Windows XP Professional with IIS. The production server will run on
Windows2003 IIS6 (yes, I know but it's not my call. )

Thanks
Victor
 On 9/23/05, Mark A Kruger [EMAIL PROTECTED] wrote:

 Victor,

 Don't give up too soon :) Make sure and test the obvious - like is the
 URL
 resolvable on the server (not on your local machine - but the server
 it'self.

 -Mark

 -Original Message-
 From: Victor Moore [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 22, 2005 6:40 PM
 To: CF-Talk
 Subject: Re: How to debug Could not generate stub objects for web
 service invocation error


 Hi Barney,
 Thanks for the quick response.
 It's an internal service at one customer.
 we are doing some tests so the service it's very simple and it has only 2
 string arguments. We are trying a proof of concept at this point and
 unfortunately it doesn't look good :(
 regards
 Victor

 On 9/22/05, Barney Boisvert [EMAIL PROTECTED] wrote:
 
  Perhaps it's a service that CF simply can't call? For instance, it
  uses data types that CF doesn't support. What's the service in
  question?
 
  cheers,
  barneyb
 
  On 9/22/05, Victor Moore [EMAIL PROTECTED] wrote:
   Hi,
   I am trying to invoke a web service on a webObjects server and I get
 the
   Could not generate stub objects for web service invocation error.
   If I access the wsdl in the browser, it display properly and I can see
  that
   the method I'm calling exists and I'm passing the proper arguments.
   I have no control over the web service.
   Any gurus out there that can provide any insight?
   Thanks
   Victor
  
 
  --
  Barney Boisvert
  [EMAIL PROTECTED]
  360.319.6145
  http://www.barneyb.com/
 
  Got Gmail? I have 100 invites.
 
 



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219055
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to get an Array returned by Oracle Stored Procedure

Quinn,

I waited before responding hoping someone may offer a solution.
Unfortunately as far as I know, there aren't any JDBC drivers that
will convert a PL/SQL table to a ColdFusion array.

Your best option may be to return a ref cursor with two columns (index
 value) and write a function to convert it to a ColdFusion array.

-Adam

On 9/22/05, Quinn Ng [EMAIL PROTECTED] wrote:
 Hi All,

 I am trying to find a way to access the Array of
 varchars being retuned by a Oracle Stored procedure in
 ColdFusion MX 7.

 CFPORCPARAM no longer allows Maxrows as an attribute
 and I am hence not able to get the value of this
 parameter.

 Please note that Oracle Package has the following Type
 - which is an Array of varchars

 TYPE char_array IS TABLE OF VARCHAR2(20)
INDEX BY BINARY_INTEGER;

 PROCEDURE PROC_ISTABLEOF_ARRAY (outField OUT
 char_array) ;

 My CF code is :- (I get error with this)

  CFSTOREDPROC
   procedure=MetaData.PROC_ISTABLEOF_ARRAY
   datasource=mydatasource
  CFPROCPARAM type=Out
 cfsqltype=CF_SQL_VARCHAR
 variable=FieldName
 
 /CFSTOREDPROC
 CFSET qry = QueryNew()
 CFSET RC=QueryAddColumn(qry, FieldColumn,
 FieldName)
 CFTABLE QUERY =qry COLHEADERS
   CFCOL
  HEADER = FIELD  NAME
  TEXT = #qry.FieldColumn#
 /CFTABLE




 __
 Yahoo! Mail - PC Magazine Editors' Choice 2005
 http://mail.yahoo.com

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219056
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Credit card storage

2005-09-23 Thread Bud

And now they've redone it to Cybersource... I looked over the docs not so
long ago and I don't think I have ever seen a more complex payment gateway
interface, ever.

I just got done integrating my cf_ezcart with Cybersource. This was 
the worst interface I've worked with out of any so far. UGH
-- 

Bud Schneehagen - Tropical Web Creations, Inc.

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Web Based Solutions / eCommerce Development  Hosting
http://www.twcreations.com/ - http://www.cf-ezcart.com/
Toll Free: 877.207.6397 - Local  Int'l Phone/Fax: 386.789.0968

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219057
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: How to debug Could not generate stub objects for web service invocation error

2005-09-23 Thread Mark A Kruger

Yes - there's a command line tool that comes with the server that will allow
you to see the headers and the SOAP packets. It's called TCP Monitor. You
can run it and view the raw SOAP request/response exchange.

Here's a technote:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentationfile=1556.htm


In addition, if your clients service is in Java, then you can likely access
it using cfobject calls to java classes. That's exactly what we did with the
Paypal API - because we couldn't get cfinvoke to work due to certificate
issues.

Also... XP for testing 2003 for production?  How do you know it will work?

-Mark



-Original Message-
From: Victor Moore [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 8:32 AM
To: CF-Talk
Subject: Re: How to debug Could not generate stub objects for web
service invocation error


Well I'm trying, but I run out of ideas.
 Yes, the url is resolvable from the server and displays the wsdl.
 I was wondering if there is anyway to see the SOAP header generated by
cfinvoke? If I could see it then maybe I can see something ..but as I said
it's a pretty basic service. The customer is moving to a SOAP architecture
and we have to be able to communicate. They are a java shop and if I cannot
connect from CF (they say it's working fine from some of their java apps)
they will phase CF out. At this point I don't know what to look for. I have
done searchs and found a number of people having this problem but no really
solution.
They are running CFMX 6.1 version 6,1,0,63958 and the test server is running
on Windows XP Professional with IIS. The production server will run on
Windows2003 IIS6 (yes, I know but it's not my call. )

Thanks
Victor
 On 9/23/05, Mark A Kruger [EMAIL PROTECTED] wrote:

 Victor,

 Don't give up too soon :) Make sure and test the obvious - like is the
 URL
 resolvable on the server (not on your local machine - but the server
 it'self.

 -Mark

 -Original Message-
 From: Victor Moore [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 22, 2005 6:40 PM
 To: CF-Talk
 Subject: Re: How to debug Could not generate stub objects for web
 service invocation error


 Hi Barney,
 Thanks for the quick response.
 It's an internal service at one customer.
 we are doing some tests so the service it's very simple and it has only 2
 string arguments. We are trying a proof of concept at this point and
 unfortunately it doesn't look good :(
 regards
 Victor

 On 9/22/05, Barney Boisvert [EMAIL PROTECTED] wrote:
 
  Perhaps it's a service that CF simply can't call? For instance, it
  uses data types that CF doesn't support. What's the service in
  question?
 
  cheers,
  barneyb
 
  On 9/22/05, Victor Moore [EMAIL PROTECTED] wrote:
   Hi,
   I am trying to invoke a web service on a webObjects server and I get
 the
   Could not generate stub objects for web service invocation error.
   If I access the wsdl in the browser, it display properly and I can see
  that
   the method I'm calling exists and I'm passing the proper arguments.
   I have no control over the web service.
   Any gurus out there that can provide any insight?
   Thanks
   Victor
  
 
  --
  Barney Boisvert
  [EMAIL PROTECTED]
  360.319.6145
  http://www.barneyb.com/
 
  Got Gmail? I have 100 invites.
 
 







~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219058
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Track Visitor Country/City from IP address.

2005-09-23 Thread Dimo Michailov

Why not http://www.hostip.info/ ?

It's free, has an API, or you can download the entire database and
play with it yourself?



On 9/23/05, Paul Hastings [EMAIL PROTECTED] wrote:
 Nomad wrote:
  I am looking for something free (if available).

 for country level maybe this:

 http://www.sustainablegis.com/projects/geoLocator/

 i don't trust data below country level much.

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219059
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Ecom for accepting checks - suggestions

2005-09-23 Thread Steve Kahn

Anyone know of a tag that allows ecommerce for accepting checks, rather than 
credit cards?

I know cc is best, but this is a client based request. Thanks everyone.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219060
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What version of the JVM is ColdFusion/JRun Using?

On 9/23/05, Douglas Knudsen [EMAIL PROTECTED] wrote:
1.5 is supported under the latest JRun updater, but CF is not. Note
that the last time I looked at this, can't use a JVM 1.4.2_05 with
CF.

http://www.macromedia.com/support/documentation/en/jrun/4/releasenotes_4_updater6.html#resolved

The system requirements page says that CF is certified with Sun JDK
1.4.2_06. I do know that others (I think it was Dave Watts) noted that
it was specifically CFLDAP that broke in later versions of the JVM. We
have been testing against 1.4.2_09 for a while now and everything on
our site (including web services) works without issue. Then again, we
don't use CFLDAP.

As for the 1.5 JVM, I believe it was the Axis engine specifically that
had problems. There was a switch (search the archives) you could add
to the jvm.config file to basically get ColdFusion running under 1.5
as long as you weren't using web services (and, hence, the Axis
engine). As Doug noted, JRun with Updater 6 does officially support
the 1.5 JVM, but ColdFusion (any version) does not.

Regards,
Dave.

~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219061
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54

Please Help! - cfstoredproc with REF Cursor as out param

2005-09-23 Thread Quinn Ng

Please read my problem below - which I had posted a
couple of days ago.
I am basically trying to get a REF CURSOR as an output
from the stored procedure in my CF code.

I continue to face this problem i.e get error
PLS-00306: wrong number or types of arguments in
call to 'GET_METADATA' ORA-06550: line 1, column 7

I was told that there was issue with some versions of
CF with some Oracle Drivers.
But could someone tell me what do I need to do to fix
it?
Also I didnt really find much info on it on this
website.

I have tried this on CF MX 7 with Oracle 10g
I am using Oracle Database 10g  Release 2 (10.2.0.1.0)
JDBC Drivers in this case.

and also CF MX 6 Developer Edition with Oracle 9i
I am using the (macromedia datadirect ?)default driver
in this case

Thanks in advance !


 
 Hi all,
 
 I am trying to call a stored procedure which has 3
 input params and 1 out apram which is a refcursor.
 I am using CF MX 7
 
 I am getting this error -
 PLS-00306: wrong number or types of arguments in
 call
 to 'GET_METADATA' ORA-06550: line 1, column 7
 
 This is my CF Code for calling the Stored Procedure
 :-
 ===
  CFSTOREDPROC procedure = METADATA.get_Metadata
 dataSource = mydatasource
 returnCode = No
 
 CFPROCPARAM type = IN
  CFSQLType = CF_SQL_NUMERIC
  value = pageid
 
 CFPROCPARAM type = IN
  CFSQLType = CF_SQL_VARCHAR
  value = myFormName
 
 CFPROCPARAM type = IN
  CFSQLType = CF_SQL_VARCHAR
  value = myfieldName
 

 CFPROCRESULT name = metadataResult
   /CFSTOREDPROC
 
 
 
 Below is the PACKAGE definition :-
 PACKAGE METADATA
 IS
 
 TYPE metadata_recordtype IS RECORD
 (
 fieldName FORMINPUTCONTROL.FIELDNAME%TYPE,
 fieldValue DATA_FIELDVALUE.fieldvalue%TYPE
 ) ;
 
 TYPE metadata_curtype IS REF CURSOR RETURN 
 metadata_recordtype;
 
 
 PROCEDURE get_metadata(
   PAGEID IN Data_FieldValue.PageId%Type,
   FORMNAME  IN FORMCONTROL.FormName%Type,
   INHERIT_FIELDNAME IN
 FormInputControl.fieldname%Type,
   METADATA_CURVAROUTmetadata_curtype
  );
  END Metadata;
 
 
 Please help !
 
 Thanks in advance,
 kn
 
 
 
   
   

__
 
 Yahoo! for Good 
 Donate to the Hurricane Katrina relief effort. 
 http://store.yahoo.com/redcross-donate3/ 
 
 




__ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219062
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

On 9/23/05, Quinn Ng [EMAIL PROTECTED] wrote:
 Please read my problem below - which I had posted a
 couple of days ago.
 I am basically trying to get a REF CURSOR as an output
 from the stored procedure in my CF code.

 I continue to face this problem i.e get error
 PLS-00306: wrong number or types of arguments in
 call to 'GET_METADATA' ORA-06550: line 1, column 7

 I was told that there was issue with some versions of
 CF with some Oracle Drivers.
 But could someone tell me what do I need to do to fix
 it?
 Also I didnt really find much info on it on this
 website.

 I have tried this on CF MX 7 with Oracle 10g
 I am using Oracle Database 10g  Release 2 (10.2.0.1.0)
 JDBC Drivers in this case.

 and also CF MX 6 Developer Edition with Oracle 9i
 I am using the (macromedia datadirect ?)default driver
 in this case


You cannot use Oracle 10g Release 2 with ColdFusion MX if you have
stored procedures that return ref cursors. The DataDirect drivers,
version 3.3 and 3.4, that ship with ColdFusion MX (all versions) do
not properly support the release. DataDirect 3.5, which you can
download for a 15-day trial directly from the DataDirect site, does
indeed work, and I know Macromedia has verified the issue (I filed the
bug, which is how I know) and is internally investigating a future
solution to the issue.

Regards,
Dave.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219063
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query timeouts

2005-09-23 Thread Michael Dinowitz

A CFQUERY can have multiple SQL statements in it and the timeout is applied to 
each statement. The timeout is passed to the DB and is the DB's issue, not CFs 
issue. This means that if the driver for the DB does not support timeouts being 
passed, the timeout attribute is pointless.
I'm still trying other things, but

I've had mixed results with that.  From the docs :

Maximum number of seconds that each action of a query is permitted to
execute before returning an error. The cumulative time may exceed this
value.

For JDBC statements, ColdFusion sets this attribute. For other
drivers, check driver documentation.

I have yet to understand what is each action of a query.  The
timeout does work, its just not always as expected though.  We use
Oracle exclusively, dunno about other RDBMS.

DK

On 9/22/05, Michael Dinowitz [EMAIL PROTECTED] wrote:


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219064
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

Dave,

Curious if you trie granting SYS.ALL_ARGUMENTS to the schema owner?

-Adam

On 9/23/05, Dave Carabetta [EMAIL PROTECTED] wrote:
 On 9/23/05, Quinn Ng [EMAIL PROTECTED] wrote:
  Please read my problem below - which I had posted a
  couple of days ago.
  I am basically trying to get a REF CURSOR as an output
  from the stored procedure in my CF code.
 
  I continue to face this problem i.e get error
  PLS-00306: wrong number or types of arguments in
  call to 'GET_METADATA' ORA-06550: line 1, column 7
 
  I was told that there was issue with some versions of
  CF with some Oracle Drivers.
  But could someone tell me what do I need to do to fix
  it?
  Also I didnt really find much info on it on this
  website.
 
  I have tried this on CF MX 7 with Oracle 10g
  I am using Oracle Database 10g  Release 2 (10.2.0.1.0)
  JDBC Drivers in this case.
 
  and also CF MX 6 Developer Edition with Oracle 9i
  I am using the (macromedia datadirect ?)default driver
  in this case
 

 You cannot use Oracle 10g Release 2 with ColdFusion MX if you have
 stored procedures that return ref cursors. The DataDirect drivers,
 version 3.3 and 3.4, that ship with ColdFusion MX (all versions) do
 not properly support the release. DataDirect 3.5, which you can
 download for a 15-day trial directly from the DataDirect site, does
 indeed work, and I know Macromedia has verified the issue (I filed the
 bug, which is how I know) and is internally investigating a future
 solution to the issue.

 Regards,
 Dave.

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219065
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CFMX 7 Upgrade - CF Admin Settings Didn't Transfer

2005-09-23 Thread Pam Richmond

The upgrade to CFMX 7 (from 6.1) deleted everything in CF Admin including all 
the datasources. Copying most of the xml files from the 6.1 version from the 
lib directory to same location in the 7 version appeared to return all the 
settings, but none of the datasources worked and resubmitting them without 
changes did not work either. Reentering them from scratch is working -- but 
it's time consuming. According to the CF documentation, CF 7 is supposed to 
automatically transfer the CF Admin settings from 6. This was on our 
development server. We're running Windows 2003 Server, IIS 6.

We now have to upgrade our production server. Any ideas how to avoid this same 
problem next time? 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219066
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: hit tracking service

2005-09-23 Thread RADEMAKERS Tanguy

Hello,

My company is looking for some form of hit tracking service - something
that would allow us to tag pages with an identifier and then consult
reports of visits, visitors, etc by tag. Basically something like those
annoying hit counters, but more professionally done and with the ability
to tag any number of pages on an ad-hoc basis. We already have log
analysis software, we're looking for something easier to use from the
point of view of the content publishers (who are not capable of writing
webtrends reports). The idea is that we would provide them with a simple
cf custom tag that implements the page tracking tag, which they could
implement wherever they want (passing in params like the logical tag
name they want the page(s) to be tracked under). We've looked at
solutions from Coremetrics and Websidestory that can do this kind of
thing, but they are much to powerful for our needs (we do about a
million pageviews a month, these guys start at five million) and would
take a major effort to put into place. 

Our one big requirement is that this should be available as a service -
zero software installation on our site.

Has anybody here used or heard of such a service?

Regs,
/t


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219067
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

On 9/23/05, Adrocknaphobia [EMAIL PROTECTED] wrote:
 Dave,

 Curious if you trie granting SYS.ALL_ARGUMENTS to the schema owner?


What does that grant do exactly? I'll have my DBA temporarily grant it
to see if it makes a difference, but I don't know what the above
allows?

Regards,
Dave.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219068
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

2005-09-23 Thread kugh ng

Thanks for replying Dave.
It seems to be a very big bug - of not being able to use oracle ref cursors 
with coldfusion ! Big for me beacuse I cannot imagine how data driven 
applications can then be developed on coldfusion

Could you tell me how do I replace the version 3.3/3.4 DataDirect driver - with 
the 3.5 version that works?
I mean is there some path/procedure to follow to be able to replace this 
properly and ask ColdFusion to use the new version instead?

Thanks much

On 9/23/05, Quinn Ng [EMAIL PROTECTED] wrote:

You cannot use Oracle 10g Release 2 with ColdFusion MX if you have
stored procedures that return ref cursors. The DataDirect drivers,
version 3.3 and 3.4, that ship with ColdFusion MX (all versions) do
not properly support the release. DataDirect 3.5, which you can
download for a 15-day trial directly from the DataDirect site, does
indeed work, and I know Macromedia has verified the issue (I filed the
bug, which is how I know) and is internally investigating a future
solution to the issue.

Regards,
Dave.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219069
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: parsing out a google list

 Once I did that it worked fine.

Ok, now you just have to buy the tag ! ;-)


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219070
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: hit tracking service

2005-09-23 Thread Jerry Johnson

I've had to use the hitbox service, and the clients were pretty happy
with the simplicity of the code and the resulting reports.

On 9/23/05, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote:
 Hello,

 My company is looking for some form of hit tracking service - something
 that would allow us to tag pages with an identifier and then consult
 reports of visits, visitors, etc by tag. Basically something like those

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219071
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: hit tracking service

2005-09-23 Thread Albert Bussolino

2005/9/23, RADEMAKERS Tanguy [EMAIL PROTECTED]:


 My company is looking for some form of hit tracking service - something
 that would allow us to tag pages with an identifier and then consult
 reports of visits, visitors, etc by tag.

 Hi,
take a look at Clicktrack, thay also offer it as a hosted service:
http://www.clicktracks.com/products/analyzer/hosted.php
 --
Albert


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219073
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
 Thanks for replying Dave.
 It seems to be a very big bug - of not being able to use oracle ref cursors 
 with coldfusion ! Big for me beacuse I cannot imagine how data driven 
 applications can then be developed on coldfusion

Well it's hard to hold DataDirect accountable for not being compatible
with the most recent version of Oracle. These issues do not exist in
previous Oracle versions.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219072
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What version of the JVM is ColdFusion/JRun Using?

 1.5 is supported under the latest JRun updater, but CF is not.

ROL, Java is supposed to makes applications machine undependant, but 
in fact they are more than machine dependant, they are VERSION 
dependant. ;-)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219074
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

page load times on a shared server

2005-09-23 Thread Ray Champagne

is there a way to see page load times when one doesn't have the ability 
to turn on debugging or any access to the cfadmin?  some kind of tag or 
maybe some java?

Ray


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219075
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

 What does that grant do exactly?

On a traditonal locked-down database, a number of the more common
roles are revoked from the schema owner. One of these roles permits
select on SYS.ALL_ARGUMENTS. If the schema owner does not have this
grant, it cannot read the spec of a procedure properly. Which is a
very common cause for the wrong number or types of arguments error.

I'm just taking a wild guess that the new Oracle release may have made
a privelege change... but who knows... Oracle sucks.

-Adam

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219076
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Is using a trigger to return the identity OK or Bad?

2005-09-23 Thread Mike Chabot

I was testing out insert triggers using DataDirect 3.4 drivers in CFMX
6.1 and noticed the problem mentioned below where the JRun CPU usage
spikes to 99% and never goes down until the service is bounced.
Removing the insert trigger makes the problem go away. Does anyone
know a good solution for this? For now I have reverted to the 3.3
drivers, although the 3.3 drivers have problems of their own. I am
thinking about trying out Microsoft's JDBC drivers to see if those are
better.

Thank you,
Mike Chabot

On 7/20/05, Bert Dawson [EMAIL PROTECTED] wrote:
 Years ago i picked up a way of returning the value inserted into an
 Identity column in SQL server, by adding a trigger to that table:

 CREATE TRIGGER get_my_id ON dbo.my_table
 FOR INSERT
 AS
 SELECT  my_id AS my_new_id
 FROMINSERTED
 GO

 Then i can run:

 cfquery name=q_test datasource=#dsn#
INSERT INTO my_table (my_text)
VALUES ('foo')
 /cfquery

 my new id = #q_test.my_new_id#

 I know i can use @@IDENTITY or SCOPE_IDENTITY(), but i was wondering
 if the trigger method is a Bad thing to do...

 Its worked from CF4 to CFMX7, but barfs with the DataDirect 3.4
 drivers: the insert happens, but JRun sits at 50%.

 Does that mean there's a bug with the driver, or something wrong with my code?

 Cheers
 Bert

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219077
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: ColdFusion MX 7 : New Features Survey

 We are conducting a survey to get feedback on the new features in 
ColdFusion MX 7.

The first question:
Which new features in ColdFusion MX 7 have you used so far?
is abusively mandatory.

In making answer to this question mandatory, you discart people who did 
not use
any of the new features just because none of them was useful for them, 
then you are
making your survey biased.


-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219078
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Please Help! - cfstoredproc with REF Cursor as out param

2005-09-23 Thread Dave Watts

 Could you tell me how do I replace the version 3.3/3.4 
 DataDirect driver - with the 3.5 version that works?
 I mean is there some path/procedure to follow to be able to 
 replace this properly and ask ColdFusion to use the new 
 version instead?

Technically, it's easy to use any external JDBC driver instead of the ones
that come with CFMX. However, until DataDirect provides a new version to
Macromedia, you would have to purchase the driver from DataDirect to do
this, and it isn't cheap - around $4k if I recall correctly. You might
instead try Oracle's own JDBC drivers, which presumably have been updated to
support 10g R2.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219079
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: ColdFusion MX 7 : New Features Survey

2005-09-23 Thread Dave Watts

  We are conducting a survey to get feedback on the new 
  features in ColdFusion MX 7.
 
 The first question:
 Which new features in ColdFusion MX 7 have you used so far?
 is abusively mandatory.
 
 In making answer to this question mandatory, you discart 
 people who did not use any of the new features just because 
 none of them was useful for them, then you are making your 
 survey biased.

If you haven't used the new features, what sort of useful feedback can you
provide about the new features?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219080
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: hit tracking service

2005-09-23 Thread Tanguy Rademakers

Hi Albert,

Their output seems to be more focused on people as opposed to pages - something 
a marketing person would want to see. What i'm missing here is the ability to 
track a page or group of pages and see traffic/hit stats for those pages. 
Think... executive toy...

/t

 Hi,
take a look at Clicktrack, thay also offer it as a hosted service:
http://www.clicktracks.com/products/analyzer/hosted.php
 --
Albert

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219081
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: ColdFusion MX 7 : New Features Survey

Yes, but the very next question asks which ones are you planning on using.

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 11:10 AM
To: CF-Talk
Subject: RE: ColdFusion MX 7 : New Features Survey


  We are conducting a survey to get feedback on the new
  features in ColdFusion MX 7.

 The first question:
 Which new features in ColdFusion MX 7 have you used so far?
 is abusively mandatory.

 In making answer to this question mandatory, you discart
 people who did not use any of the new features just because
 none of them was useful for them, then you are making your
 survey biased.

If you haven't used the new features, what sort of useful feedback can you
provide about the new features?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219082
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: hit tracking service

2005-09-23 Thread Tanguy Rademakers

I've had to use the hitbox service, and the clients were pretty happy
with the simplicity of the code and the resulting reports.

Jerry,

Thanks for the info. I signed up for their online demo and it looks pretty 
basic - i'm looking for something more.. executive. Think lots of pretty graphs 
and not too many buttons ;)

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219083
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

On 9/23/05, Adrocknaphobia [EMAIL PROTECTED] wrote:
  What does that grant do exactly?

 On a traditonal locked-down database, a number of the more common
 roles are revoked from the schema owner. One of these roles permits
 select on SYS.ALL_ARGUMENTS. If the schema owner does not have this
 grant, it cannot read the spec of a procedure properly. Which is a
 very common cause for the wrong number or types of arguments error.

 I'm just taking a wild guess that the new Oracle release may have made
 a privelege change... but who knows... Oracle sucks.


I see what you're saying now. The user I'm connecting as already had
SELECT permissions from this view and it didn't make a difference with
the 3.3/3.4 set. It looks like something fundamentally changed between
10g R1 and R2 on Oracle's side and the various vendors need to catch
up. As I said, I downloaded the DD 3.5 SP1 trial set and everything
worked again without needing to changes roles/permissions/privileges,
so it's a question now of Macromedia working with DataDirect to get an
updated driver set and fully QA-ing them before releasing to the
masses. With that in mind, I can't see an updated driver set being
released imminently. I do know that Macromedia is on the case though.

Regards,
Dave.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219084
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: ColdFusion MX 7 : New Features Survey

2005-09-23 Thread Jim Davis

 -Original Message-
 From: Claude Schneegans [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 23, 2005 11:56 AM
 To: CF-Talk
 Subject: Re: ColdFusion MX 7 : New Features Survey

  We are conducting a survey to get feedback on the new features in
 ColdFusion MX 7.

 The first question:
 Which new features in ColdFusion MX 7 have you used so far?
 is abusively mandatory.

 In making answer to this question mandatory, you discart people who did
 not use
 any of the new features just because none of them was useful for them,
 then you are
 making your survey biased.

Exactly - also you don't ask which of are forced to use Professional and so
would really g*ddammed LOVE to event gateways but can't because of the
arbitrary decision that they're enterprise only.

Several of the features on the list are Enterprise only - without knowing
which version the respondent is talking about you're skewing the numbers
sumptin' fierce.  ;^)

Jim Davis

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219085
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
 Thanks for replying Dave.
 It seems to be a very big bug - of not being able to use oracle ref cursors 
 with coldfusion ! Big for me beacuse I cannot imagine how data driven 
 applications can then be developed on coldfusion

 Could you tell me how do I replace the version 3.3/3.4 DataDirect driver - 
 with the 3.5 version that works?
 I mean is there some path/procedure to follow to be able to replace this 
 properly and ask ColdFusion to use the new version instead?


Well, it's a bug, but not one the Macromedia or DataDirect introduced.
It's really a change in functionality on Oracle's end that is now
effecting third-party vendors. If you'd like to use the DD driver
trial, so you can at least move ahead for 15 days, go to their site,
sign up for the trial, download the drivers, and run the installer for
them. This will lay down the appropriate jar files with the correct
trial license. Then drop base.jar and oracle.jar into your
/servers/lib directory and restart ColdFusion.

To configure the driver in the MX Admin:

1) Under Driver, choose Other
2) The driver settings are:

JDBC URL: jdbc:datadirect:oracle://[servername]:[portnumber]; 
SID=[your SID];  sendStringParametersAsUnicode=false; 
MaxPooledStatements=300;

Driver Class: com.ddtek.jdbc.oracle.OracleDriver
Driver Name: com.ddtek.jdbc.oracle.OracleDriver

Username/Password as appropriate for your instance.

Note that the JDBC URL is all one line.

If you don't want to go through this trouble, you'll need to sit tight
while Macromedia fixes things up. Since Oracle 10g R2 is less than a
month old (well, Linux came out about 2 months ago), time will be
needed by all vendors to QA the updates.

Regards,
Dave.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219086
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Track Visitor Country/City from IP address.

2005-09-23 Thread Paul Hastings

Dimo Michailov wrote:
 Why not http://www.hostip.info/ ?
 
 It's free, has an API, or you can download the entire database and
 play with it yourself?

nigel's java stuff is just plain faster (the country-ip range db is in 
the jar). and you can also play w/the source if you care too. and of 
course the CFC also does more for you out of the box (figuring out 
locales, etc.). oh  it's also free.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219087
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

mapping directories in cf devloper edition

2005-09-23 Thread Michael Dinowitz

I'm using the CF developer edition on internal web server and I'd like to map 
another drive. Does anyone know the xml file and location to do this? 
Basically, I have an external drive with 250 meg of comics that I'd like to 
provide to a publisher to look through. Mapping the internal webserver to it 
would be the best solution and if someone knows before I dig in, it'll save me 
time.

Thanks

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219088
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What version of the JVM is ColdFusion/JRun Using?

2005-09-23 Thread Paul Hastings

Dave Carabetta wrote:
 As for the 1.5 JVM, I believe it was the Axis engine specifically that
 had problems. There was a switch (search the archives) you could add

also cfreport has issues (font rendering gets blown up). and maybe flash 
forms as well.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219089
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: ColdFusion MX 7 : New Features Survey

 If you haven't used the new features, what sort of useful feedback 
can you
provide about the new features?

As I said, if none of the new features is useful, this is an information 
a survey should take in account.
If you prevent people for who nothing is useful to answer, your survey 
is biased.

This is just like not counting blank ballots in election results.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219090
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: OT: hit tracking service

2005-09-23 Thread Kevin Aebig

DeepMetrix has all the eye candy anyone could need... it's exactly what you
want.

Kevin

-Original Message-
From: Tanguy Rademakers [mailto:[EMAIL PROTECTED] 
Sent: September 23, 2005 10:08 AM
To: CF-Talk
Subject: Re: OT: hit tracking service

I've had to use the hitbox service, and the clients were pretty happy
with the simplicity of the code and the resulting reports.

Jerry,

Thanks for the info. I signed up for their online demo and it looks pretty
basic - i'm looking for something more.. executive. Think lots of pretty
graphs and not too many buttons ;)

/t

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219091
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: ColdFusion MX 7 : New Features Survey

 Yes, but the very next question asks which ones are you planning on 
using.

Correct, but if you do not check at least one of the options in the 
first question, you're not allowed
to go to next step.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219093
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: mapping directories in cf devloper edition

On 9/23/05, Michael Dinowitz [EMAIL PROTECTED] wrote:
 I'm using the CF developer edition on internal web server and I'd like to map 
 another drive. Does anyone know the xml file and location to do this? 
 Basically, I have an external drive with 250 meg of comics that I'd like to 
 provide to a publisher to look through. Mapping the internal webserver to it 
 would be the best solution and if someone knows before I dig in, it'll save 
 me time.


In /WEB-INF/jrun-web.xml, add your mapping like so:

virtual-mapping
  resource-path/mycomics/resource-path
  system-pathD:/path/to/my/comics/system-path
/virtual-mapping

Restart the instance and off you go.

Regards,
Dave.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219092
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What version of the JVM is ColdFusion/JRun Using?

On 9/23/05, Paul Hastings [EMAIL PROTECTED] wrote:
 Dave Carabetta wrote:
  As for the 1.5 JVM, I believe it was the Axis engine specifically that
  had problems. There was a switch (search the archives) you could add

 also cfreport has issues (font rendering gets blown up). and maybe flash
 forms as well.


Ah, right, I remember you bringing this up previously Paul. Good catch.

Regards,
Dave.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219094
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: page load times on a shared server

2005-09-23 Thread Matt Robertson

cfsetting showdebugoutput=Yes enablecfoutputonly=NO
 but I doubt it will work on a shared box. This isn't much but its what I
use for a quick/dirty idea:
 On line 1 of application.cfm:
 cfset request.starttime=gettickcount()
 and maybe on the end of OnRequestEnd.cfm if appropriate:
 cfoutput
p class=Tiny#int(gettickcount()-request.starttime)#
/cfoutput
 Or use it to time specific blocks of code and display in onrequestend.

--
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com http://mysecretbase.com


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219095
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: page load times on a shared server

2005-09-23 Thread Kevin Aebig

!-- At top of page... --
cfset tcPreLoad = gettickcount()/


!-- At bottom of page... --
cfset tcPostLoad = gettickcount()/
cfoutput#tcPostLoad-tcPreLoad#/cfoutputms

Cheers,

Kevin

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: September 23, 2005 9:46 AM
To: CF-Talk
Subject: page load times on a shared server 

is there a way to see page load times when one doesn't have the ability 
to turn on debugging or any access to the cfadmin?  some kind of tag or 
maybe some java?

Ray




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219096
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: ColdFusion MX 7 : New Features Survey

2005-09-23 Thread Matt Robertson

On 9/23/05, Dave Watts [EMAIL PROTECTED] wrote:

 If you haven't used the new features, what sort of useful feedback can you
 provide about the new features?

 That the new features were not found to be useful by X%, thereby begging
other questions.
 I'm not saying anything about CF7, only about the test methodology. I agree
its written in such a way as to provide skewed results.
 --
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com http://mysecretbase.com


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219097
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: hit tracking service

 My company is looking for some form of hit tracking service - something
that would allow us to tag pages with an identifier and then consult
reports of visits, visitors, etc by tag.

I just developed something similar for a customer. Me too I find 
ridiculous information like
http://www.houseoffusion.com/lists.cfm/link=i:4:219067; has been hit 
1234 times...
My system works with the page title, so it is much more intuitive and, 
as far as a title is defined in the
page, it does not need any special code in the templates.
Of course, it only works for CF templates, not for plain HTML pages.

I may consider make a comercial tag with it.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219098
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What version of the JVM is ColdFusion/JRun Using?

2005-09-23 Thread Paul Hastings

Dave Carabetta wrote:
 Ah, right, I remember you bringing this up previously Paul. Good catch.

actually that was dean who figured out 1.5 was the culprit when my 
reports started looking like i was on LSD.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219099
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Credit card storage

2005-09-23 Thread Matt Robertson

If you want to write something generic for one or two of my clients I may
have a job for you. I have some clients using my CMS for signup stuff that
needs this, and one of them is a BofA customer. Let me know off-list if
you're interested.
 Cheers,

--
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com http://mysecretbase.com


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219100
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RSS Parser

2005-09-23 Thread Johnny Le

Does anyone know if the com.macromedia.rssu.Parser component is included in 
CFMX 7?  If not, and I don't have DRK 4, how do I get it?
Thank you.

Johnny

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219101
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

cflogin frustration

2005-09-23 Thread Bob Flynn

Now that weâve moved to CF7 we are reworking our authentication system and 
taking advantage of application.cfc. We have written a cflogin block into the 
onRequestStart function but it does not seem to be setting the user. Here is 
the code block we have boiled it down to for testing.

cffunction name=onRequestStart returnType=void output=false
cflogin
   cfif NOT IsDefined(cflogin)
cfloginuser name=reflynn password=password roles=none /
cflocation url=http://espn.com;
   cfelse
cflocation url=http://google.com;
   /cfif
/cflogin
/cffunction

Every time we hit the page it redirects to ESPN. Everything I read tells me 
itâs pretty straightforward. We must be doing something very simple 
incorrectly. Any pointers greatly appreciated.

Bob

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219102
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: RSS Parser

I don't know about that parser, but I've used this one:
http://mxblogspace.journurl.com/users/admin/index.cfm?mode=articleentry=8874
from Roger Benningfield.  It works really well.

cheers,
barneyb

On 9/23/05, Johnny Le [EMAIL PROTECTED] wrote:
 Does anyone know if the com.macromedia.rssu.Parser component is included in 
 CFMX 7?  If not, and I don't have DRK 4, how do I get it?
 Thank you.

 Johnny



--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219103
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

2005-09-23 Thread kugh ng

I am using the default driver (i.e data direct driver) for Oracle 9i - which is 
not a new version
I get problems with REF cursor with it too.

Hence dont know how would the upgrade to recent Oracle driver help anyways.

?

 On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
  Thanks for replying Dave.
  It seems to be a very big bug - of not being able to use oracle ref 
 cursors with coldfusion ! Big for me beacuse I cannot imagine how data 
 driven applications can then be developed on coldfusion
 
 Well it's hard to hold DataDirect accountable for not being 
 compatible
 with the most recent version of Oracle. These issues do not exist in
 previous Oracle versions.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219104
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

SQL Server 2000 Driver for JDBC

2005-09-23 Thread Mike Chabot

The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1 to
hang when certain insert triggers are executed. I reverted to the 3.3
drivers, but those have other problems with them. I just installed the
Microsoft JDBC sp3 driver in hopes that it is better, and I am
wondering if anybody has any experience using this alternate driver? I
have only done minimal testing with the new driver, but it seems to
work.

SQL Server 2000 Driver for JDBC Service Pack 3
http://www.microsoft.com/downloads/details.aspx?familyid=07287b11-0502-461a-b138-2aa54bfdc03adisplaylang=en#affinity

Thank you,
Mike Chabot

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219105
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Updated MX6 to 6.1 and the world went kablooy -- IMMEDIATE HELP, Please

2005-09-23 Thread Ian Skinner

We just attempted to upgrade a box from MX6.0 with the 6.1 updater.  The 
updater seemed to run fine and completed it job, theoretically.  But now the 
box will not server up any CFM pages.  When attempting to retrieve a CFM page, 
all we get is a blank page in the browser.  HTML pages serve up fine.  This 
includes the administrator, just a blank page.

What can we check to see what may have gone wrong?  What could we possibly do 
to fix this?  And would just jumping over the 6.1 and going to 7 without 
correcting this issue be a good or bad idea?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219106
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Updated MX6 to 6.1 and the world went kablooy -- IMMEDIATE HELP, Please

On 9/23/05, Ian Skinner [EMAIL PROTECTED] wrote:
 We just attempted to upgrade a box from MX6.0 with the 6.1 updater.  The 
 updater seemed to run fine and completed it job, theoretically.  But now the 
 box will not server up any CFM pages.  When attempting to retrieve a CFM 
 page, all we get is a blank page in the browser.  HTML pages serve up fine.  
 This includes the administrator, just a blank page.


Have you tried re-installing the web server connector?


 What can we check to see what may have gone wrong?  What could we possibly do 
 to fix this?  And would just jumping over the 6.1 and going to 7 without 
 correcting this issue be a good or bad idea?


Have you checked the log file generated by the installer? Any
warnings, non-fatal errors, or errors? I think that an update to 7
would be a bit too reactive unless you've already done internal
testing against it to make sure your site works. Check your installer
log and wsconfig.log files and see what they say first.

Regards,
Dave.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219107
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

Kugh,

You have a different issue then. CF works fine with everything prior
to Oracle 10g r2.

-Adam

On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
 I am using the default driver (i.e data direct driver) for Oracle 9i - which 
 is not a new version
 I get problems with REF cursor with it too.

 Hence dont know how would the upgrade to recent Oracle driver help anyways.

 ?

  On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
   Thanks for replying Dave.
   It seems to be a very big bug - of not being able to use oracle ref
  cursors with coldfusion ! Big for me beacuse I cannot imagine how data
  driven applications can then be developed on coldfusion
 
  Well it's hard to hold DataDirect accountable for not being
  compatible
  with the most recent version of Oracle. These issues do not exist in
  previous Oracle versions.

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219108
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: ColdFusion MX 7 : New Features Survey

 I agree its written in such a way as to provide skewed results.

This is going OT (please CF_comunity paranoids abstain...;-), but I 
remember a survey I had to compile
when I was working in the Computer Center at university.
The survey was made over a prison community, and one question was 
something like:
« Do you know that masturbation is not bad? »
Kind of way to make sure that the survey says 100% people in prison 
think masturbation is OK ;-)

Note: all my comments in this thread DO NOT imply that I consider no new 
feature in CFMX is useful, neither they mean that I have any opinion 
about the virtue nor the evil effects of masturbation.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219109
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Updated MX6 to 6.1 and the world went kablooy -- IMMEDIATE HELP, Please

2005-09-23 Thread Ken Ketsdever

We found the following in the wsconfig.log file:

jrunx.connectorinstaller.ConnectorInstallerException: Error creating IIS
filter JRun Connector Filter for web site All (0)
at
jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
:157)
at
jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
:68)
at
jrunx.connectorinstaller.ConnectorInstaller.installConnector(ConnectorIn
staller.java:270)
at
jrunx.connectorinstaller.ConnectorInstaller.doIt(ConnectorInstaller.java
:227)
at
jrunx.connectorinstaller.ConnectorInstaller.main(ConnectorInstaller.java
:547)


Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219110
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

String Search!!!!

2005-09-23 Thread Aldon Moore

How do I search a string for the first space   between characters?

This should be so easy converted to This should

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219111
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: ColdFusion MX 7 : New Features Survey

2005-09-23 Thread Matt Osbun

This morning, I made a comment to the effect of That may be the oddest
thing I hear all day.

And then this comes up...

Matt Osbun
Applications Manager
Health Systems, International


-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 23, 2005 12:57 PM
To: CF-Talk
Subject: Re: ColdFusion MX 7 : New Features Survey


This is going OT (please CF_comunity paranoids abstain...;-), but I 
remember a survey I had to compile
when I was working in the Computer Center at university.
The survey was made over a prison community, and one question was 
something like:
 Do you know that masturbation is not bad? 
Kind of way to make sure that the survey says 100% people in prison 
think masturbation is OK ;-)

Note: all my comments in this thread DO NOT imply that I consider no new

feature in CFMX is useful, neither they mean that I have any opinion 
about the virtue nor the evil effects of masturbation.



CONFIDENTIALITY NOTICE:  The information contained in this transmission, 
including any attachments, is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure, or distribution is prohibited by Federal law. If you are not 
the intended recipient of this message, you are notified that you may not 
disclose, print, copy, or disseminate this information. If you have received 
this transmission in error, please reply to the sender and delete or destroy 
the message. Unauthorized interception of this transmission may be a violation 
of criminal law.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219112
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Updated MX6 to 6.1 and the world went kablooy -- IMMEDIATE HELP, Please

So yeah, you need to re-run wsconfig.

-Ada,

On 9/23/05, Ken Ketsdever [EMAIL PROTECTED] wrote:
 We found the following in the wsconfig.log file:

 jrunx.connectorinstaller.ConnectorInstallerException: Error creating IIS
 filter JRun Connector Filter for web site All (0)
at
 jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
 :157)
at
 jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
 :68)
at
 jrunx.connectorinstaller.ConnectorInstaller.installConnector(ConnectorIn
 staller.java:270)
at
 jrunx.connectorinstaller.ConnectorInstaller.doIt(ConnectorInstaller.java
 :227)
at
 jrunx.connectorinstaller.ConnectorInstaller.main(ConnectorInstaller.java
 :547)


 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.



 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219113
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: String Search!!!!

Don't you mean converted to This?  left(string, find( , string) -
1) should do it.

cheers,
barneyb

On 9/23/05, Aldon Moore [EMAIL PROTECTED] wrote:
 How do I search a string for the first space   between characters?

 This should be so easy converted to This should



--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219114
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

2005-09-23 Thread Stephen Dupre

 Could you tell me how do I replace the version 3.3/3.4 
 DataDirect driver - with the 3.5 version that works?
 I mean is there some path/procedure to follow to be able to 
 replace this properly and ask ColdFusion to use the new 
 version instead?

Technically, it's easy to use any external JDBC driver instead of the ones
that come with CFMX. However, until DataDirect provides a new version to
Macromedia, you would have to purchase the driver from DataDirect to do
this, and it isn't cheap - around $4k if I recall correctly. You might
instead try Oracle's own JDBC drivers, which presumably have been updated to
support 10g R2.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!

The 3.5 drivers that fix this problem are going into beta today.  We expect 
after this short beta, we'll release the 3.5 drivers as a hotfix for the Oracle 
problem with 10gR2.  There's no need to go out and buy other drivers.  The 15 
day trial would work too.  The URLs are slightly different with the un-branded 
drivers:
Class: com.ddtek.jdbc.oracle.OracleDriver
URL: jdbc:datadirect:oracle://server1:1521;ServiceName=serviceName; 

If you want to get in on the beta, let me know.  It's starting today.

Stephen Dupre
Macromedia QA

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219115
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Updated MX6 to 6.1 and the world went kablooy -- IMMEDIATE HELP, Please

On 9/23/05, Ken Ketsdever [EMAIL PROTECTED] wrote:
 We found the following in the wsconfig.log file:

 jrunx.connectorinstaller.ConnectorInstallerException: Error creating IIS
 filter JRun Connector Filter for web site All (0)
 at
 jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
 :157)
 at
 jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
 :68)
 at
 jrunx.connectorinstaller.ConnectorInstaller.installConnector(ConnectorIn
 staller.java:270)
 at
 jrunx.connectorinstaller.ConnectorInstaller.doIt(ConnectorInstaller.java
 :227)
 at
 jrunx.connectorinstaller.ConnectorInstaller.main(ConnectorInstaller.java
 :547)



OK, that definitely gives you a focus point. Have you tried
uninstalling/re-installing the web server connector using the wsconfig
utility?

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/config12.htm#wp1118876

Regards,
Dave.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219116
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: String Search!!!!

2005-09-23 Thread Aldon

The string is dynamic so the value changes!

-Original Message-
From: Aldon Moore [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:16 PM
To: CF-Talk
Subject: String Search

How do I search a string for the first space   between characters?

This should be so easy converted to This should

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219117
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: ColdFusion MX 7 : New Features Survey

 Do you know that masturbation is not bad?

I'm not touching that one.

-Adam

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219118
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL Server 2000 Driver for JDBC

2005-09-23 Thread Stephen Dupre

 The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1 
 to
 hang when certain insert triggers are executed. I reverted to the 3.3
 drivers, but those have other problems with them. I just installed 
 the
 Microsoft JDBC sp3 driver in hopes that it is better, and I am
 wondering if anybody has any experience using this alternate driver? 
 I
 have only done minimal testing with the new driver, but it seems to
 work.
 
 SQL Server 2000 Driver for JDBC Service Pack 3
 http://www.microsoft.com/downloads/details.
aspx?f amilyid=07287b11-0502-461a-b138-2aa54bfdc03adisplaylang=en#affinity
 
 Thank you,
 Mike 
Chabot

This was fixed in 3.4 build 57 (only build 50 is on the /support/coldfusion 
site).

It's also fixed in 3.5.  We're starting the beta today for 3.5 drivers so you 
might be a good candidate.  Send me an email.

Here is the DataDirect defect.
DEF0001750  When using the executeUpdate() method to execute an INSERT 
statement on a table with an INSERT trigger, the update count from the trigger 
was returned instead of the count from the actual INSERT statement.

Stephen Dupre
Macromedia QA
[EMAIL PROTECTED]

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219119
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: ColdFusion MX 7 : New Features Survey

I am.  tee-hee.

On 9/23/05, Adrocknaphobia [EMAIL PROTECTED] wrote:
  Do you know that masturbation is not bad?

 I'm not touching that one.

 -Adam


--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219120
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

find identical records

I know this one must be easy, but I'm not a guru w/SQL yet.

How do I construct an SQL query that will list all records that have an 
identical field?

For example, listing all records that contain an identical number in the 
serialnumber column.

I did:

Select distinct serialnumber from inventory
order by serialnumber asc

to get the unique records.

Robert O.

-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005
 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219121
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: find identical records

SELECT serialnumber, count(*) AS rowCount
FROM inventory
GROUP BY serialnumber
HAVING rowCount  1

That should give you a list of serials that exist more than once,
along with how many instances there are.  And update your AVG, it says
it's out of date.

cheers,
barneyb

On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:
 I know this one must be easy, but I'm not a guru w/SQL yet.

 How do I construct an SQL query that will list all records that have an 
 identical field?

 For example, listing all records that contain an identical number in the 
 serialnumber column.

 I did:

 Select distinct serialnumber from inventory
 order by serialnumber asc

 to get the unique records.

 Robert O.


--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219122
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: String Search!!!!

You said you needed to find the first instance of a space in a string, but
your example showed finding the 3rd instance of a string.

Which is it?

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Aldon [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 1:22 PM
To: CF-Talk
Subject: RE: String Search


The string is dynamic so the value changes!

-Original Message-
From: Aldon Moore [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:16 PM
To: CF-Talk
Subject: String Search


How do I search a string for the first space   between characters?

This should be so easy converted to This should





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219123
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: ColdFusion MX 7 : New Features Survey

NICE!

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 1:16 PM
To: CF-Talk
Subject: Re: ColdFusion MX 7 : New Features Survey


I am.  tee-hee.

On 9/23/05, Adrocknaphobia [EMAIL PROTECTED] wrote:
  Do you know that masturbation is not bad?

 I'm not touching that one.

 -Adam


--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219124
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: find identical records

2005-09-23 Thread Matthew Small

Select A.serialnumber from table1 as A, table1 as B
Where A.serialnumber = B.serialnumber and A.Id  b.Id
Order by serialnumber, Id

 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 23, 2005 2:22 PM
To: CF-Talk
Subject: find identical records

I know this one must be easy, but I'm not a guru w/SQL yet.

How do I construct an SQL query that will list all records that have an
identical field?

For example, listing all records that contain an identical number in the
serialnumber column.

I did:

Select distinct serialnumber from inventory
order by serialnumber asc

to get the unique records.

Robert O.

-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005
 




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219125
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: find identical records

Thanks Barney.

It says Incorrect syntax near the keyword rowcount

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:27 PM
To: CF-Talk
Subject: Re: find identical records

SELECT serialnumber, count(*) AS rowCount
FROM inventory
GROUP BY serialnumber
HAVING rowCount  1

That should give you a list of serials that exist more than once,
along with how many instances there are.  And update your AVG, it says
it's out of date.

cheers,
barneyb

On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:
 I know this one must be easy, but I'm not a guru w/SQL yet.

 How do I construct an SQL query that will list all records that have an 
 identical field?

 For example, listing all records that contain an identical number in the 
 serialnumber column.

 I did:

 Select distinct serialnumber from inventory
 order by serialnumber asc

 to get the unique records.

 Robert O.

--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219126
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: find identical records

Thanks Matt.

This gives an ambiguous column name error

-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:31 PM
To: CF-Talk
Subject: RE: find identical records


Select A.serialnumber from table1 as A, table1 as B
Where A.serialnumber = B.serialnumber and A.Id  b.Id
Order by serialnumber, Id

 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 23, 2005 2:22 PM
To: CF-Talk
Subject: find identical records

I know this one must be easy, but I'm not a guru w/SQL yet.

How do I construct an SQL query that will list all records that have an
identical field?

For example, listing all records that contain an identical number in the
serialnumber column.

I did:

Select distinct serialnumber from inventory
order by serialnumber asc

to get the unique records.

Robert O.

-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005
 






~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219127
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: find identical records

What DB are you using?  Perhaps that's a reserved word, and needs to
be escaped/changed?

cheers,
barneyb

On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:
 Thanks Barney.

 It says Incorrect syntax near the keyword rowcount

 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 23, 2005 2:27 PM
 To: CF-Talk
 Subject: Re: find identical records


 SELECT serialnumber, count(*) AS rowCount
 FROM inventory
 GROUP BY serialnumber
 HAVING rowCount  1

 That should give you a list of serials that exist more than once,
 along with how many instances there are.  And update your AVG, it says
 it's out of date.

 cheers,
 barneyb
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219128
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: find identical records

2005-09-23 Thread Matthew Small

Sorry - 

Order by A.serialnumber, A.Id
 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 23, 2005 2:39 PM
To: CF-Talk
Subject: RE: find identical records

Thanks Matt.

This gives an ambiguous column name error

-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:31 PM
To: CF-Talk
Subject: RE: find identical records


Select A.serialnumber from table1 as A, table1 as B
Where A.serialnumber = B.serialnumber and A.Id  b.Id
Order by serialnumber, Id

 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 23, 2005 2:22 PM
To: CF-Talk
Subject: find identical records

I know this one must be easy, but I'm not a guru w/SQL yet.

How do I construct an SQL query that will list all records that have an
identical field?

For example, listing all records that contain an identical number in the
serialnumber column.

I did:

Select distinct serialnumber from inventory
order by serialnumber asc

to get the unique records.

Robert O.

-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005
 








~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219129
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: page load times on a shared server

2005-09-23 Thread Raymund Champagne

Thanks Kevin and Matt.  I think I'll give Kevin's a try and see where it gets 
me.

!-- At top of page... --
cfset tcPreLoad = gettickcount()/


!-- At bottom of page... --
cfset tcPostLoad = gettickcount()/
cfoutput#tcPostLoad-tcPreLoad#/cfoutputms

Cheers,

Kevin

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: September 23, 2005 9:46 AM
To: CF-Talk
Subject: page load times on a shared server 

is there a way to see page load times when one doesn't have the ability 
to turn on debugging or any access to the cfadmin?  some kind of tag or 
maybe some java?

Ray

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219130
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

problems with Verity on Solaris 8 with CFMX 7

2005-09-23 Thread Jennifer Larkin

We installed CFMX 7 to our development box on Monday. (It's a Solaris
8 machine with a previous install of cf 6.1 and Verity.) We have been
working ever since to get Verity working and we are about to hit our
deadline. We have installed every language pack we can find and we are
still having issues with locales. The code is running on Windows with
CFMX 7 and Verity just fine. But when we try to create indexes in a
foreign language we get exceptions.

Our current hurdle is that when we run this code:
 cfcollection  action=CREATE path=/hiding/our/collection/path/
collection=partners_2_3 language=french 

followed by this code:
 cfindex   type=custom collection=partners_2_3  language=french
 query=processed  title=title  key=contentid 
body=title,contentbody action=refresh custom2=urlpath 

We get this error on the CFIndex:
Language mismatch for collection partners_2_3.  The language you
specified, english, does not match the collection language of french.

Even though we specify French in the CFIndex tag, Verity receives that
we specified English. We have 800 collections involving many different
languages. We assume that this would fail for all languages, not just
French, but we haven't taken out French to test this.

Help!

Thanks
--
I must remember to honor the power of the off switch. Omi of Xiaolin Showdown

Now blogging
http://www.blivit.org/blog/index.cfm
http://www.blivit.org/mr_urc/index.cfm

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219131
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: find identical records

On 9/23/05, Barney Boisvert [EMAIL PROTECTED] wrote:
 What DB are you using?  Perhaps that's a reserved word, and needs to
 be escaped/changed?


In Oracle, you'd do:

SELECT serialnumber, count(*) AS rowCount
FROM inventory
GROUP BY serialnumber
HAVING COUNT(*)  1

Oracle doesn't like the reference to the rowCount alias in the HAVING
clause. I'm not sure how other RDBMS's deal with that.

Regards,
Dave.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219132
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Updated MX6 to 6.1 and the world went kablooy -- IMMEDIATE HELP, Please

2005-09-23 Thread Ken Ketsdever

We have not tried to run the wsconfig.exe file several times.  It seems
to hang on starting and or stopping web services.


-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 23, 2005 11:09 AM
To: CF-Talk
Subject: Re: Updated MX6 to 6.1 and the world went kablooy -- IMMEDIATE
HELP, Please

On 9/23/05, Ken Ketsdever [EMAIL PROTECTED] wrote:
 We found the following in the wsconfig.log file:

 jrunx.connectorinstaller.ConnectorInstallerException: Error creating
IIS
 filter JRun Connector Filter for web site All (0)
 at

jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
 :157)
 at

jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
 :68)
 at

jrunx.connectorinstaller.ConnectorInstaller.installConnector(ConnectorIn
 staller.java:270)
 at

jrunx.connectorinstaller.ConnectorInstaller.doIt(ConnectorInstaller.java
 :227)
 at

jrunx.connectorinstaller.ConnectorInstaller.main(ConnectorInstaller.java
 :547)



OK, that definitely gives you a focus point. Have you tried
uninstalling/re-installing the web server connector using the wsconfig
utility?

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/config12.htm#wp11
18876

Regards,
Dave.



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219133
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: find identical records

Using SQL

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:39 PM
To: CF-Talk
Subject: Re: find identical records

What DB are you using?  Perhaps that's a reserved word, and needs to
be escaped/changed?

cheers,
barneyb

On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:
 Thanks Barney.

 It says Incorrect syntax near the keyword rowcount

 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 23, 2005 2:27 PM
 To: CF-Talk
 Subject: Re: find identical records

 SELECT serialnumber, count(*) AS rowCount
 FROM inventory
 GROUP BY serialnumber
 HAVING rowCount  1

 That should give you a list of serials that exist more than once,
 along with how many instances there are.  And update your AVG, it says
 it's out of date.

 cheers,
 barneyb
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219134
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: find identical records

Meaning.. MySQL?  MS SQL Server?  Oracle?  PostgreSQL?  Something else?

On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:
 Using SQL

 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 23, 2005 2:39 PM
 To: CF-Talk
 Subject: Re: find identical records

 What DB are you using?  Perhaps that's a reserved word, and needs to
 be escaped/changed?

 cheers,
 barneyb

--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219135
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: find identical records

2005-09-23 Thread Hua Wei

 
In MSSQL , ROWCOUNT is a Setting for Operations Against Remote Tables

Try this:
SELECT serialnumber, count(*) 
FROM inventory 
GROUP BY serialnumber 
HAVING count(*)  1

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 23, 2005 2:54 PM
To: CF-Talk
Subject: RE: find identical records

Using SQL

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:39 PM
To: CF-Talk
Subject: Re: find identical records


What DB are you using?  Perhaps that's a reserved word, and needs to be 
escaped/changed?

cheers,
barneyb

On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:
 Thanks Barney.

 It says Incorrect syntax near the keyword rowcount

 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 23, 2005 2:27 PM
 To: CF-Talk
 Subject: Re: find identical records


 SELECT serialnumber, count(*) AS rowCount FROM inventory GROUP BY 
 serialnumber HAVING rowCount  1

 That should give you a list of serials that exist more than once, 
 along with how many instances there are.  And update your AVG, it says 
 it's out of date.

 cheers,
 barneyb
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219136
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Please Help! - cfstoredproc with REF Cursor as out param

2005-09-23 Thread kugh ng

OK then I am back to where I started.
What do I need to do to solve this problem? I have been struggling with this 
for some days now. SO someone please let me know what I need to do here

I get error PLS-00306: wrong number or types of arguments in call to 
'GET_METADATA' ORA-06550: line 1, column 7

But the procedure works perfectly from Oracle SQL prompt. I get error only when 
calling from CF code.

I am using CF MX 7  with Oracle 10.1.0.3.0.

I am facing the same ditto problem with CF MX 6 Developer edition with Oracle 
9.2.0.5

To recap again I use the following CF code :-

= CFSTOREDPROC procedure = METADATA.get_Metadata
dataSource = mydatasource
returnCode = No

CFPROCPARAM type = IN
CFSQLType = CF_SQL_NUMERIC
value = pageid

CFPROCPARAM type = IN
CFSQLType = CF_SQL_VARCHAR
value = myFormName

CFPROCPARAM type = IN
CFSQLType = CF_SQL_VARCHAR
value = myfieldName


CFPROCRESULT name = metadataResult
/CFSTOREDPROC

And this is the definition of my Oracle Stored Procedure :-
==

PACKAGE METADATA
IS

TYPE metadata_recordtype IS RECORD
(
fieldName FORMINPUTCONTROL.FIELDNAME%TYPE,
fieldValue DATA_FIELDVALUE.fieldvalue%TYPE
) ;

TYPE metadata_curtype IS REF CURSOR RETURN metadata_recordtype;


PROCEDURE get_metadata(
PAGEID IN Data_FieldValue.PageId%Type,
FORMNAME IN FORMCONTROL.FormName%Type,
INHERIT_FIELDNAME IN FormInputControl.fieldname%Type,
METADATA_CURVAR OUT metadata_curtype
);
END Metadata;



Kugh,

You have a different issue then. CF works fine with everything prior
to Oracle 10g r2.

-Adam

On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219137
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: String Search!!!!

2005-09-23 Thread Josh Nathanson

I think Aldon wants to return everything before the second space, correct? 
So just two words with a space between them?

Maybe something like this - looping over the string and flagging occurences 
of a space, then taking the left characters when the second space is 
discovered.  Kinda bulky but it should work.

cfset flag=0
cfloop from=1 to=Len(theString) index=theChar
cfset thischar=Mid(theString, theChar, 1
cfif thischar is  
cfset flag = flag + 1
cfif flag = 2
cfset finalstring = Left(theString, theChar - 1)
cfbreak
/cfloop

Didn't test it but something like that should work ok - finalstring being 
what you are looking for.



- Original Message - 
From: Aldon [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, September 23, 2005 11:22 AM
Subject: RE: String Search


 The string is dynamic so the value changes!

 -Original Message-
 From: Aldon Moore [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 23, 2005 2:16 PM
 To: CF-Talk
 Subject: String Search


 How do I search a string for the first space   between characters?

 This should be so easy converted to This should



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219138
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Updated MX6 to 6.1 and the world went kablooy -- IMMEDIATE HELP, Please