Index 55, size 33

2003-06-04 Thread Richard Crawford
I received this error when browsing to a .cfm page that had previously worked (I had made one slight change to the page). Now I receive the Index 55, Size 33 error when I browse to that page. What does this error mean? How can I address it?

RE: Index 55, size 33

2003-06-04 Thread Richard Crawford
Hm, that makes me wonder if I can just bulk delete a bunch of the classes in that directory without destroying anything? At 03:53 PM 6/3/2003 -0500, you wrote: yup, you will have to delete the class file in your CFusionMX\wwwroot\WEB-INF\cfclasses dir to get it to work again. i usually search

...But the pages are there!

2003-06-05 Thread Richard Crawford
Thanks to all who replied to my question about index 55, size 33. I deleted the .class files, and that seems to have solved the problem. Now, however, I have a different problem. How can it be possible that my server doesn't see files that are actually there? For example, I tell my browser

Re: ...But the pages are there!

2003-06-05 Thread Richard Crawford
I'm on Solaris, which is, of course, case-sensitive. Believe you me, that was the first thing I checked (we're in the process of upgrading our web servers from Windows/IIS to Solaris/Apache, so we've got quite a few of those case-sensitivity issues coming up). At 11:38 AM 6/4/2003 -0400, you

Re: ...But the pages are there!

2003-06-05 Thread Richard Crawford
Seems to be a permissions issue. It worked when I CHMOD'ed the files to 755; they were set at 700. At 11:51 AM 6/4/2003 -0400, you wrote: another suggestion is checking the permissions on the directory itself. ~| Archives:

Re: ...But the pages are there!

2003-06-05 Thread Richard Crawford
Okay, TRUST ME when I say that I'm not associated with that site! Ugh. I had no idea mysite.com was an actual site. I'll be more discriminating in the future. (The site I'm at is http://unexdlc.ucdavis.edu -- though I'm working on the development server, which is not currently available to

CFIF interpreted as SQL?!!?

2003-06-05 Thread Richard Crawford
This error puzzles me. It looks like the CFMX interpreter is trying to interpret a conditional statement as a SQL command, which is weird. Error Executing Database Query. Data source not found. The error occurred in /space/usr/jrun4/servers/default/cfusion/DLC/index.cfm: line 33 31 : 32 :

RE: CFIF interpreted as SQL?!!?

2003-06-05 Thread Richard Crawford
Hm. Unfortunately, when I try to open the Cold Fusion administrator, I get an error that reads, 500 Null. The stack trace looks like this: 06/04 13:13:31 error java.lang.NoClassDefFoundError at javax.crypto.Cipher.getInstance([DashoPro-V1.2-120198]) at

RE: CFIF interpreted as SQL?!!?

2003-06-05 Thread Richard Crawford
Hm. Earlier, I had removed those files to a temporary directory to try to fix another problem. Restoring them fixed the 500 Null problem. Thanks for the hint! I should have this thing licked in about a century or so. At 09:28 PM 6/4/2003 +0100, you wrote: Try Deleting everything in

RE: CFIF interpreted as SQL?!!?

2003-06-05 Thread Richard Crawford
Okay, it *almost* works. But when I try to go to the admin page, I usually can't get past the login page. If I do get past the login page, then the login box apears in one of the frames of the login page, then refreshes back to the main login screen. On the one occasion when that didn't

Context validation error for tag cfif

2003-06-09 Thread Richard Crawford
Received this error this morning when browsing to cfm pages. As far as I can tell, nothing has changed, but this error has suddenly shown up out of nowhere, and no cfm pages can be viewed. ~| Archives:

Re: Context validation error for tag cfif

2003-06-09 Thread Richard Crawford
Apparently something is hosed deep in our server. At 12:48 PM 6/9/2003 -0400, you wrote: Speaking of application.cfm, don't stop considering that if there is no application.cfm in the directory in question. If ColdFusion does not find an application.cfm in the current directory, I believe it

Permissions

2003-06-09 Thread Richard Crawford
On a *nix based system, can the permissions of the various files associated with Cold Fusion affect its ability to run? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

Re: Permissions

2003-06-09 Thread Richard Crawford
I'm basically just grasping at straws here. Every single file within the cfusion directory is owned by the user 'cfusion'. Cfusion is run by the same user. I'm still receiving the same error I've received before -- Cold Fusion is just not being interpreted, even though my JRun logs show that

Re: Permissions

2003-06-09 Thread Richard Crawford
As I mentioned, the error gets thrown no matter what CFML code is being interpreted. Actually, at this point it all seems moot. Loading any page now presents a index/size error, and deleting the appropriate files from the cache just makes things worse. I have no idea why our department chose

Re: Permissions

2003-06-09 Thread Richard Crawford
At 03:35 PM 6/9/2003 -0400, you wrote: cold fusion aka coldfusion is wonderful. go try those other more stable and usable technologies and we will see ya back here soon;) (My rant in response is at the bottom of this e-mail. You may ignore or flame me as you see fit, but I think it would be

Re: Permissions

2003-06-09 Thread Richard Crawford
At 04:23 PM 6/9/2003 -0400, you wrote: cfinclude page2.cfm # Yes, page2.cfm exists. It should be: cfinclude template=page2.cfm I'm not sure if that was a typo or not, but that would definitely cause your error, as the MX compiler wouldn't even be able to compile that, let alone cause a

Re: Permissions

2003-06-09 Thread Richard Crawford
Hm. I'm wondering if, at this point, it would be worth simply reinstalling Cold Fusion. At 01:54 PM 6/9/2003 -0700, you wrote: At 04:23 PM 6/9/2003 -0400, you wrote: cfinclude page2.cfm # Yes, page2.cfm exists. It should be: cfinclude template=page2.cfm I'm not sure if that was a

Re: Permissions

2003-06-09 Thread Richard Crawford
Sorry, I thought I gave that information. CF Code: Irrelevant. I could post more CF code, but since *ALL* CF code throws the errors that I mentioned, it doesn't seem useful. This is a server error, as far as I can tell, not a coding error. Version of MX: I'm afraid that I can't track down a

Reinstalled everything... still not working...

2003-06-10 Thread Richard Crawford
I backed up all of my data files, deleted Cold Fusion and JRun, and reinstalled everything from scratch. I first installed JRun 4, then the JRun 4 service pack 1a updater. Then I installed Cold Fusion, then the Cold Fusion MX Updater 3. All of the installations seemed to work fine, with no

Re: Reinstalled everything... still not working...

2003-06-10 Thread Richard Crawford
Bad form to reply to my own post, I know. Solved part of the problem, at least. The trick was to go into all of the JRun configuration files and comment out everything that had anything to do with Apache Axis. CFMX now starts with no error messages. I still am experiencing a problem,

RE: Reinstalled everything... still not working...

2003-06-10 Thread Richard Crawford
The latest one... but keep an eye out for another e-mail I sent with this same subject line. At 01:20 PM 6/10/2003 -0700, you wrote: Which ColdFusion installer did you use? The same one as before or did you download the latest one from Macromedia's website? chris

Re: Reinstalled everything... still not working...

2003-06-10 Thread Richard Crawford
Dave, You were correct. For some reason I had to remove, then re-install the JRun connector to Apache. That seems to have solved some of the problems. Thanks for the tip. :) I'm having one last problem with the server, but it may be a datasource connection problem. If so, I will have to

Re: Reinstalled everything... still not working...

2003-06-10 Thread Richard Crawford
Yeah... Technique 2 is what I wound up using. After a brief tussle with the administrator page, wherein I found that our server wants the database's IP address instead of the server name (I have a note in to our netadmin guy about that), I got everything up and running on our development

RE: Whaling? Whaling? C'mon people....

2003-06-16 Thread Richard Crawford
Abalone. People who post personal rants to lists like this are just being shellfish. At 03:04 PM 6/16/2003 -0400, you wrote: :: I'm sure he didn't do it on porpoise. Naw, he did it just for the halibut... ~| Archives:

Administrator Issue: mail not being logged

2003-06-16 Thread Richard Crawford
I've got two servers, Trinity and Neo. As far as I can tell, the installation of CFMX on Neo (our production server) is identical to the installation of CFMX on Trinity. They even point to the same datasource (until next week, when we go live with Neo). For some reason, though, mail is not

Internationalization Issue

2003-07-03 Thread Richard Crawford
To be honest, I have no idea where to even begin with this one -- whether it's a Solaris issue, an Apache issue, a Cold Fusion issue, or a JRun issue. The problem is this: we have as part of our website a Spanish class, which requires students to input their replies in a form by entering

Re: Internationalization Issue

2003-07-03 Thread Richard Crawford
At 04:52 PM 7/3/2003 -0400, Gabriel Robichaud wrote: I had a similar issue on win2k and added the following to my Application.cfm file : cfcontent type = text/html; charset = ISO-8859-1 and it solved all my foreign euro-accents problems. Thanks for the suggestion. Unfortunately, it didn't work

CFMX Charting and Graphing causing server hiccups

2003-07-07 Thread Richard Crawford
When one of our developers performs some charting functions under CF on our JRun enabled Solaris server, everyone else trying to browse to that server gets a 404 error. This morning, I enabled charting and graphing for one of our web developers who is developing a set of tools that will

RE: I knew your name was Neo

2003-07-08 Thread Richard Crawford
At 02:03 PM 7/8/2003 +1000, you wrote: It takes a while to get used to CFMX, when I first installed it I also was very angry like you. It's quite a difference between the install of pre CFMX and MX. There is a lot more tweaking to be done with CFMX. But give it time and you'll start to love it.

The death of a session variable?

2003-07-29 Thread Richard Crawford
This is an odd one. We're running CFMX on top of JRun on a Solaris 9 server, all of the most recent patches, server upgrades, software updaters, etc., applied. Our application makes heavy use of session variables to track our users. Recently, we've discovered that if someone logs in to our

Session Variables Breaking in IE

2003-07-29 Thread Richard Crawford
Related to my earlier problem, where sessions seem to bust completely if the user clears their cache and all of their cookies while logged in to our site. I've gotten this error: Parameter 1 of function IsDefined, which is now

Re: Session Variables Breaking in IE (REPOST)

2003-07-29 Thread Richard Crawford
Just a repost of my question. Further notes: this only happens in IE, and only if a user clears their cache and their cookies while logged in to the session. Any attempt to log in to the website after doing that fails with the error message that I've listed below, which I am at a loss to

Re: The death of a session variable?

2003-07-29 Thread Richard Crawford
Jeremy, Thanks for writing back, I really appreciate it. We are indeed using IE6; however, I don't believe that this is the problem. I cleared out all cookies and temporary files, then made sure the allow session cookies checkbox was checked. I got the same problem. I also have the system

Re: The death of a session variable?

2003-07-29 Thread Richard Crawford
At 01:57 PM 7/29/2003 -0700, you wrote: Is there a way to detect if the Session Cookies are blocked and ask the user to enable them? Brook Brook, Thanks for replying. Even on my own machine, where I've allowed session cookies to be set, I get the same problem. This problem didn't even show

Re: The death of a session variable?

2003-07-29 Thread Richard Crawford
At 02:14 PM 7/29/2003 -0700, you wrote: Are you using a personal firewall. I recently upgraded to Zone Alarm pro for my workstation and it caused a lot of problems with cookies. Even when the cookie settings are disabled, I have problems with it being turned on - on some sites. Brook, Again,

RE: The death of a session variable?

2003-07-29 Thread Richard Crawford
At 05:13 PM 7/29/2003 -0400, you wrote: What the problem ended up to be was the servers that were having the problems had been patched. As it turns out there was a security issue (IIS) with domain names that had an underscore in them. The patch that was provided by Microsoft simply disallowed a

The Ongoing Saga of the Dead Session Variable

2003-07-31 Thread Richard Crawford
rebooting the server. None of these has helped. Any thoughts at all would be greatly appreciated. Thanks! Richard Crawford Systems Administrator UC Davis Distance Learning Group ~| Archives: http://www.houseoffusion.com

RE: The Ongoing Saga of the Dead Session Variable

2003-07-31 Thread Richard Crawford
At 12:59 PM 7/31/2003 -0400, you wrote: It hasn't been running on CFMX for years, though, right? Was it on CF 5 or a previous version earlier? Well, yeah. Heh. My bad. It's been running CFMX just fine for a few months, but 4.5 prior to that. In CF 4 and earlier, the values for CFID and

RE: The Ongoing Saga of the Dead Session Variable

2003-07-31 Thread Richard Crawford
To be honest (and to answer Dave and Andre): I have absolutely no idea why the session variable contains the CFID and CFTOKEN numbers as part of the variable name. None. It certainly isn't how I would have done it. Unfortunately the person who programmed it is no longer in our department so

RE: RE: The Ongoing Saga of the Dead Session Variable

2003-07-31 Thread Richard Crawford
Is there a way to clean out the cfid's? Does that question even make sense? At 12:26 PM 7/31/2003 -0600, you wrote: I suspect part of the problem is that even after turning off the cfid as a uuid feature (which may require restarting ColdFusion or possibly JRUN), some cfid's are still holding

RE: RE: RE: The Ongoing Saga of the Dead Session Variable

2003-07-31 Thread Richard Crawford
Shutting down the client computer certainly hasn't helped. Seriously. We have a theory that perhaps the session variables that are stored in the server's memory might be causing some part of the problem. Is there an easy way to delete those? At 12:48 PM 7/31/2003 -0600, you wrote: This will

RE: The Ongoing Saga of the Dead Session Variable

2003-07-31 Thread Richard Crawford
That's the weird thing. The code base is exactly the same on both our development and production servers. At 12:52 PM 7/31/2003 -0700, you wrote: Is the production server using Integers or UUIDs for the tokens? ~| Archives:

RE: The Ongoing Saga of the Dead Session Variable

2003-08-01 Thread Richard Crawford
At 07:08 AM 8/1/2003 -0700, Ian Skinner wrote: But are ALL the Server Setting the same as well? They are indeed. I personally built both servers from scratch. The only difference is in the database servers. We have a production database and a development database, and both of them run MS-SQL

RE: selling blood

2003-08-01 Thread Richard Crawford
Perhaps an cry for help from a long-unemployed programmer? At 02:06 PM 8/1/2003 -0400, you wrote: WTF? Is this a desperate cry for attention? M -Original Message- From: LI, Chunshen (Don) [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 2:00 PM To: CF-Talk Subject: OT: selling

Re: OT: stupid ?

2003-08-04 Thread Richard Crawford
At 11:43 PM 8/1/2003 -0400, you wrote: is there a way that i can have someone use an app on my comp in my IIS webroot folder? maybe by going through my IP address and then into my comp if i turn firewall off? anyone know if this is possible? What is your goal? Remote administration of your

RE: The Ongoing Saga of the Dead Session Variable - SOLVED

2003-08-04 Thread Richard Crawford
If my brain had been switched on, I would have noticed that while Enable UUID Cookies was enabled on our development server, the one with the problems, it was disabled on our production server, which had no problems. Duh. I disabled it and had all my users clear their caches and cookies.

Incompletely Included Template

2003-08-14 Thread Richard Crawford
We have two pages, very similar, that each include the same template. On one page, the template is called successfully; in the other, only about half of the template winds up being included (seriously -- one word is actually cut in half). The rest of the page is blank, and no other code

Outputting Data as an Excel File

2003-08-27 Thread Richard Crawford
We have Cold Fusion MX running on top of JRun 4 on a Solaris 9 server. We have a need to output data as an actual Excel file -- apparently, a plain old .csv file won't do. Is there any way to do this using Cold Fusion? ~|

Escaping #

2005-04-07 Thread Richard Crawford
I have to do something like this: replace bob #1 with bob \#1 I tried, cfset downLoadFile = replace(attachment.attName, \#, \\#, all) But that only gave me an error; I suspect that CF is still trying to process the octothorpe as a variable delimiter. Is there a way to escape the # so that I

Re: macromedia and Adobe?!

2005-04-18 Thread Richard Crawford
On Monday 18 April 2005 09:47, Connie DeCinko wrote: I think he was just looking for an excuse, any excuse to ditch CF.  Now he thinks he has it. Whereas in our office we'll be migrating from CF to PHP over the next few months. But that's been in the works for over a year now. -- Richard S.

Re: macromedia and Adobe?!

2005-04-18 Thread Richard Crawford
On Monday 18 April 2005 14:40, Damien McKenna wrote: Let's face it, the internet needs and overhaul at this stage, and RIA's show promise. Several companies have attempted to provide an alternative method of interacting with the internet.  One of the best was Rebol (http://www.rebol.com/)

Re: import from MySQL to MS SQL

2005-05-05 Thread Richard Crawford
On Thursday 05 May 2005 10:32, Bryan Stevenson wrote: MySQL is not file based like Access. You need to have a copy of MySQL installed and running. I do JochemMySQL 4.1.11...with an imported copy of the live database ;-);-) As I mentionedI can't figure out how to setup the ODBC

Re: import from MySQL to MS SQL

2005-05-05 Thread Richard Crawford
On Thursday 05 May 2005 10:53, Bryan Stevenson wrote: LMAO...I was waiting for this one...umm Richard...it's because MySQL no matter what anybody says is not an enterprise level DB (yet)refrerential integrity comes to mind ;-);-) Heh. Well, note that I didn't go into *why* it boggled my

Re: import from MySQL to MS SQL

2005-05-05 Thread Richard Crawford
On Thursday 05 May 2005 13:09, Bryan Stevenson wrote: Personally, even for the biggest sites I've run, I've never needed a full-fledged enterprise level database.  If I did, though, I'd probably go with Oracle or some other vendor and that's exactly where we're headingbut the VC has to

Re: import from MySQL to MS SQL

2005-05-05 Thread Richard Crawford
On Thursday 05 May 2005 10:53, Bryan Stevenson wrote: LMAO...I was waiting for this one...umm Richard...it's because MySQL no matter what anybody says is not an enterprise level DB (yet)refrerential integrity comes to mind ;-);-) Heh. Well, note that I didn't go into *why* it boggled my

Re: import from MySQL to MS SQL

2005-05-05 Thread Richard Crawford
On Thursday 05 May 2005 14:46, Bryan Stevenson wrote: Here's some justification for all you MySQL fans Ya wanna know why 21 tables are not importing??...huh...do ya?? Because MySQL has allowed NULLS to be entered into NOT NULL fields!!! MySQL can kiss my. Free = data corruption

Re: import from MySQL to MS SQL

2005-05-05 Thread Richard Crawford
On Thursday 05 May 2005 15:01, Bryan Stevenson wrote: Yeah...but if apply the NOT NULL rrule after...it still shouldn't let you if there are NULLs in the data ;-);-) (not that this is the case here...straight import from live DB to local MySQL.and off to MS SQL) I don't see how it's

Editing Files In-Line

2003-09-23 Thread Richard Crawford
Is there a way in Cold Fusion to make changes to a text file without actually opening that file? Suppose, for example, that I have a file "myfile.html" which contains the string "***REPLACE_THIS***". How can I have Cold Fusion replace that string in the file?

Re: ICANN asks VeriSign to pull redirect service

2003-09-23 Thread Richard Crawford
Matt Robertson wrote: I have SBC DSL. I wonder if they're doing it. There was some talk (over my head) about some ISPs blocking this. Many ISP's were updating the BIND software on the DNS routers to route mistyped URL's to nonexistent domains, bypassing Verisign's hijack. To my

Re: Editing Files In-Line

2003-09-23 Thread Richard Crawford
This is the code I'm using: cffile action=copy mode=0777 source=/space/usr/jrun4/servers/default/cfusion/DLC/include/disboard/wwwboard.html destination=/space/usr/jrun4/servers/default/cfusion/DLC/Campus/Courses/#course.xURL#/extras/disboard/#nNumber#/ cffile action=read

A Personal Request

2003-09-23 Thread Richard Crawford
When posting a message on a new topic to the list, could you all please start a new topic rather than replying to an old one and changing the subject line? Otherwise, those of us who uses e-mail clients which thread messages (Thunderbird, Mutt, etc.) wind up getting confused... and I need no

Re: Editing Files In-Line - SOLVED

2003-09-23 Thread Richard Crawford
I figured it out. My file was being changed successfully, but then being overwritten by the original file because of a cffile action=copy tag that I'd forgotten to remove. So now I am off to get another cup of coffee. Oy.

String or binary data would be truncated.

2003-09-26 Thread Richard Crawford
I received this message (String or binary data would be truncated) while trying to open a file through a website.Any idea what could be causing this error? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Problem upgrading CFMX to MX6.1 for JRun 4

2003-10-13 Thread Richard Crawford
According to the instructions for upgrading MX to MX 6.1, I must first undeploy Cold Fusion MX before deploying Cold Fusion MX 6.1; the instructions for undeploying say to simply delete the cfusion directory from your server. This confuses me, since that directory is where all of the Cold

Re: Problem upgrading CFMX to MX6.1 for JRun 4

2003-10-13 Thread Richard Crawford
Dave Carabetta wrote: As a side note, I'd suggest moving your site outside the JRun installation directory just for easier maintenance. This allows stuff like upgrading MX to occur without having to worry about losing my site! ;) I don't know why I was under the impression that the

Re: html emails with javascript in outlook

2003-10-15 Thread Richard Crawford
Kevin Graeme wrote: On a related, related note: the new Outlook 2003 will disable images from an external source. Why anyone would want to use Outlook is beyond me, personally.Oh, there are some legitimate reasons to spread worms and viruses.But beyond that, I can't see any other purpose to

Re: html emails with javascript in outlook

2003-10-15 Thread Richard Crawford
Tangorre, Michael wrote: such as??? Eudora.Pegasus.And, my personal favorite, Thunderbird, which is open-source and can be easily extended with, say, a calendar.None of these will allow a worm to automatically spread itself through your address book.Heck, if you wipe MS Office off your hard

My data is too controlled!

2004-02-05 Thread Richard Crawford
I received this error today: Invalid data too controlled for CFSQLTYPE CF_SQL_TINYINT ...and I have no idea what it means.I did a Google web search and a Google groups search, but could find absolutely nothing.Does anyone have any ideas? [Todays Threads] [This Message] [Subscription]

Security Issue?

2004-02-09 Thread Richard Crawford
We've discovered that if go to our website, and remove the cfmx context root from the URL, you can see the Cold Fusion code behind the website. I'm guessing that this is probably due to a configuration error somewhere in our system.I'm not sure how much of a security risk this is since we

Re: Security Issue?

2004-02-09 Thread Richard Crawford
Tony Weeg wrote: http://www.domain.com/test.cfm?tony=1 what cfmx context are you talking about? In our setup, the URL looks like this: http://www.our-domain.edu/cfmx/site/index.cfm When users go to www.out-domain.edu, they are automatically redirected to the site as written above. Does

Re: Security Issue?

2004-02-09 Thread Richard Crawford
Ben Forta wrote: This is a guess, but ... If the default context (/) maps to \jrun\servers\default, and /cfmx maps to \jrun\servers\default\cf, and CF is not installed in the default context, then yes, any files requested from url/cf/ would indeed return the files without CF processing

Security Documentation

2004-02-13 Thread Richard Crawford
I'm looking for some good websites dedicated to issues of security for Cold Fusion and JRun.Anyone got any suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Cold Fusion and Oracle Stored Procedures

2004-02-23 Thread Richard Crawford
I am having difficulty passing values from an Oracle Stored Procedure to Cold Fusion. Here is the stored procedure: == CREATE OR REPLACE procedure dlc_sp_verifyLogin ( sLogin IN varchar2, sPassword IN varchar2, sRemoteAddr IN varchar2, sBrowser IN

A further issue with CF and Oracle SP's

2004-02-23 Thread Richard Crawford
When I pass a value back to a variable from a stored procedure in Oracle, the variable invariably takes on a value of 1 instead of whatever was determined in the stored procedure. For example, here is where the stored procedure is called: cfstoredproc datasource=mydata procedure=myproc

Re: Cold Fusion and Oracle Stored Procedures

2004-02-23 Thread Richard Crawford
Plunkett, Matt wrote: Don't use a cfprocresult unless you're getting a ref cursor back.Just refer to the variable as cookieId. Matt, Thanks for the suggestion.But as I research this, I'm finding more and more disturbing indications that Oracle Stored Procedures do not return result sets.

Re: Cold Fusion and Oracle Stored Procedures

2004-02-24 Thread Richard Crawford
Scott Brady wrote: Try swapping the last two cfprocparams.Assuming you're using CFMX, CFMX no longer uses the dbvarname attribute (at least for Oracle, not sure about other databases), so the order in which you provide the parameters needs to match the order they're defined in the

Re: Cold Fusion and Oracle Stored Procedures

2004-02-24 Thread Richard Crawford
Thomas Chiverton wrote: On Monday 23 Feb 2004 23:37 pm, Richard Crawford wrote: more disturbing indications that Oracle Stored Procedures do not return result sets. I am investigating this today / yesterday. Using cfprocresult works, with Oracle 9i and CFMX6.1 under weblogic, using

Re: Cold Fusion and Oracle Stored Procedures

2004-02-24 Thread Richard Crawford
Thomas Chiverton wrote: Solution: Use native CFMX drivers. Which is a shame :-( I dunno if it's worth putting in on the wish list... I figured out to return a ref cursor, and this appears to return a result set fine.However, now I'm getting an error reading, [Oracle JDBC Driver]Unsupported

Re: Cold Fusion and Oracle Stored Procedures

2004-02-24 Thread Richard Crawford
Rob Rohan wrote: On Tue, 2004-02-24 at 11:50, Richard Crawford wrote: Thomas Chiverton wrote: Solution: Use native CFMX drivers. Which is a shame :-( I dunno if it's worth putting in on the wish list... I figured out to return a ref cursor, and this appears to return a result set

Re: Cold Fusion and Oracle Stored Procedures

2004-02-24 Thread Richard Crawford
Rob Rohan wrote: That just passes along the problem from the driver/database it cant tell you the line number of the stored proc if it was not given Here is the revised SP in Oracle: CREATE OR REPLACE procedure

Re: Cold Fusion and Oracle Stored Procedures

2004-02-24 Thread Richard Crawford
Plunkett, Matt wrote: -Original Message- From: Richard Crawford Sent: Tuesday, February 24, 2004 3:24 PM To: CF-Talk Subject: Re: Cold Fusion and Oracle Stored Procedures CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN int, studentInfo in out types.cursorType

Re: Cold Fusion and Oracle Stored Procedures

2004-02-24 Thread Richard Crawford
Plunkett, Matt wrote: -Original Message- From: Richard Crawford Sent: Tuesday, February 24, 2004 4:12 PM To: CF-Talk Subject: Re: Cold Fusion and Oracle Stored Procedures Can you run your procedure directly in Oracle? It compiles just dandy. But what happens when you run

Oracle and Cold Fusion

2004-03-01 Thread Richard Crawford
Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1);

Re: Oracle and Cold Fusion

2004-03-01 Thread Richard Crawford
, then it gives an error telling me that the procresult is not defined. On Mon, 2004-03-01 at 16:38, Richard Crawford wrote: Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo

Re: Oracle and Cold Fusion

2004-03-02 Thread Richard Crawford
Deanna Schneider wrote: Have you tried using GenericCursorType for your cursor type? That works for me. (I can give you a sample stored proc that's working for me, if that would be helpful.) I'd appreciate that.I tried using GenericCursorType, and the SP would not compile, throwing this

Re: Oracle and Cold Fusion

2004-03-02 Thread Richard Crawford
Rob wrote: Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine.I've gone out of my way to make them all match.If I remove the refcursor from the procedure call, then it

Number of files in a directory

2004-03-02 Thread Richard Crawford
If I'm right, then this code snippet.. = cfdirectory directory=#pDir1# action="" name=daList sort=name filter=les* cfset p = #daList.RecordCount# = would return to p the number of files in the

Re: Number of files in a directory - RESOLVED

2004-03-02 Thread Richard Crawford
Ben Doom wrote: Okay, yeah.That's way smarter than my suggestions.:-) --Ben Doom Nando wrote: Richard, I do this kind of stuff with a Q of Q, and it works well. cfdirectory returns a query. Maybe try that. Something like: cfdirectory directory=#pDir1# action="" name=daList cfquery

Trimming a string after last instance of / character

2004-03-02 Thread Richard Crawford
Given a string that contains a directory name (e.g., /var/www/html/files/classes/admin), what is the best way to trim all of the characters off the last instance of the / character? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)

Re: Trimming a string after last instance of / character

2004-03-02 Thread Richard Crawford
Stevenson, Christopher wrote: Given a string that contains a directory name (e.g., /var/www/html/files/classes/admin), what is the best way to trim all of the characters off the last instance of the / character? listdeleteat(string, listlen(string, '/'), '/'); Or

Re: Trimming a string after last instance of / character - RESOLVED

2004-03-02 Thread Richard Crawford
This is what I used: cfset pathDir=#GetDirectoryFromPath(CGI.PATH_TRANSLATED)# cfset trimpathDir=listdeleteat(#pathDir#, listlen(#pathDir#,'/'), '/') / Adding the final / at the end turned out to be key. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group

Re: Can someone recommend a good web development browser?

2004-03-04 Thread Richard Crawford
Kevin Graeme wrote: I usually develop with IE on a PC, but I would really like a browser that shows me the *time* taken to request each object in a web request. Also, if it could show me the http headers of the request and response, that would be sweet. I've currently got a page thats

Cold Fusion and Oracle

2004-03-08 Thread Richard Crawford
The endless issues go on.Sigh. Does anyone know of a very good resource detailing the issues involved with hooking Cold Fusion up to Oracle? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays

Re: Cold Fusion and Oracle

2004-03-08 Thread Richard Crawford
Kristopher Pilles wrote: What kind of issues are ya having?I have use CF and oracle together extensively... perhaps i can help Kristopher, I've posted about my issues before, but I'll happily do so again.:) I have a stored procedure written in PL/SQL, which I'm attempting to call from Cold

Re: Cold Fusion and Oracle

2004-03-08 Thread Richard Crawford
Richard Crawford wrote: Kristopher Pilles wrote: What kind of issues are ya having?I have use CF and oracle together extensively... perhaps i can help Kristopher, I've posted about my issues before, but I'll happily do so again.:) I have a stored procedure written in PL/SQL, which

Re: Cold Fusion and Oracle

2004-03-08 Thread Richard Crawford
Dave Watts wrote: I have a stored procedure written in PL/SQL, which I'm attempting to call from Cold Fusion, but only errors are generated. Here is the stored procedure: Unfortunately, it didn't come through. But anyway, have you tried calling this stored procedure from SQL*Plus? How

Re: Cold Fusion and Oracle

2004-03-08 Thread Richard Crawford
Doug Keen wrote: I've had similar issues when migrating a CF/Oracle app from CF 4.5 to CF 6.1.During that adventure I found this resource: http://www.blinex.com/~sam/CF_SQL_TYPES.cfm This chart maps CF_SQL_TYPE's to types specific to different database platforms, including Oracle.In your

Re: Cold Fusion and Oracle

2004-03-08 Thread Richard Crawford
got the same error when I tried again. Nick Han [EMAIL PROTECTED] 03/08/04 11:28AM Richard Crawford wrote: Kristopher Pilles wrote: What kind of issues are ya having?I have use CF and oracle together extensively... perhaps i can help Kristopher, I've posted about my issues

Re: Cold Fusion and Oracle

2004-03-08 Thread Richard Crawford
Doug Keen wrote: Is types.cursorType a REF CURSOR (not your plain-vanilla CURSOR)?If not, I think that may be another potential cause of your error... try changing types.cursorType to be a REF CURSOR and delete your FETCH ... INTO statement from the proc. Hm.It actually IS a REF CURSOR.I

  1   2   >