.
--
Richard Crawford, Programmer III
UC Davis Extension Distance Education Group
http://unexdlc.ucdavis.edu
http://www.extensiondlc.net
2901 K Street, Suite 200C
Sacramento, CA 95620
Tel: (916)327-7793
e-mail: [EMAIL PROTECTED
in the Spool directory.
What am I doing wrong? This has worked before, and no changes have been
made to our installation.
--
Richard Crawford, Programmer III
UC Davis Extension Distance Education Group
http://unexdlc.ucdavis.edu
http://www.extensiondlc.net
2901 K Street, Suite 200C
Sacramento, CA
On Thursday 02 June 2005 09:27, Calvin Ward wrote:
This is true code running in production I had to review once
(because there was an error somewhere)
http://www.mschopman.demon.nl/horror.txt
Oh, God. The horror! The horror! My eyes are melting! Aii!!
(And this only
On Thursday 02 June 2005 09:35, Kevin Aebig wrote:
Coldfusion... PHP... dotNET... truely guys, its all the same thing with
different implementations.
Now Perl on the other hand Why won't that language just die already...
For CGI scripting, Perl has its uses (though I personally haven't
On Thursday 02 June 2005 13:42, dave wrote:
I guess Simon is trying to say that if I buy a car and everytime it
breaks down they will send someone to fix it (even from germany) and he
thinks thats a BAD thing? I guess it would be better to take it down to
jimmy joes house and confer with
On Thursday 02 June 2005 14:14, Kevin Aebig wrote:
We can drop the example anytime... I'm sure everyone here is smart enough
to get it.
Sorry to bother you. I was hoping to expand on Dave's metaphor to explain why
I have a different viewpoint than he does. It certainly wasn't my intention
On Tuesday 31 May 2005 11:03, Joe Rinehart wrote:
The 'P' in LAMP usually refers to PHP - which is a pain to read,
write, and maintain unless you're very well versed in PHP ;);)
Wow. My experience has been very different. I find PHP very easy to work
with and quite intuitive, while Cold
On Tuesday 31 May 2005 12:42, Russ wrote:
In addition to phpmyadmin (which I've grown to love) there is also the
mysql control center and a couple of other GUI tools which have been
developed.
And for the hardcore, there's always the MySQL command line, which I would
frequently kill -- or at
On Tuesday 24 May 2005 06:54, S. Isaac Dealey wrote:
cfparam name=x default=
instead of this:
cfparam name=form.x default=
I'm still not entirely certain how that comes across as the question
he asked, except perhaps that he's trying to scope his variables as
say variables.x instead of
On Monday 23 May 2005 22:03, Jim Davis wrote:
The developer in question used it as an example of how hard it was to do
simple things in CF compared to Java in meeting. I wrote #listfirst(var,
-)# and #listlast(var, -)# on the whiteboard. ;^)
In general, I prefer to program in PHP since I
On Tuesday 24 May 2005 10:12, Jim Davis wrote:
In my company however this is the norm: we moved away from CF almost purely
on the say-so of the Java programmers like the one I mentioned and their
assertions that Java was easier to work with.
In short they produced complete crap and blamed the
On Tuesday 24 May 2005 16:57, Bryan Stevenson wrote:
How the heck does that change the window size in any browser? looks to me
that it hardcodes the window size to 200x200...which is what IE is
doing...what's that about the good browsers Dave?? ;-);-)
Uh oh... *donning asbestos pajamas*
--
It seems that on every Cold Fusion page that processes variables from a
previous page -- say a form and the page that processes the form -- every
variable on the form must be accounted for. This is fine if the form is
unchanging, but if the form is dynamic and might change every time it's
On Monday 23 May 2005 18:22, Ben Forta wrote:
FORM is a structure that contains all HTTP POST fields, and you can loop
through it easily.
Thanks! I'm trying to figure out some old code written by some previous
developers, and they used some incredibly complicated tricks to deal with
having
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
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
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
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
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
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
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.
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/)
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
I'm trying to track down a serious bug on our website, which is really
starting to annoy me.
Basic rundown: We have two servers, a development server and a
production server. The directory structure is identical in both servers
(with the exception of some permissions issues which should not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ben Doom wrote:
| On occasion, I've seen deleted .cfm files continue to work. I had to
| manually recompile the directory to make them go away, so I think that
| the compiled form gets cached and not deleted properly.
That might be the problem.
Barney Boisvert wrote:
Need to edit that. The 25th is the first day of Christmas, and the
12th day is the 5th of January of the next year (the day before
Epiphany, which is the 6th). But funny none the less.
I always thought that Epiphany *was* the twelfth day of Christmas. I
guess I just
I hope I'm explaining this right.
We have a Flash movie built by someone else outside of our department.
The movie takes in a number of values and then sends them to a Cold
Fusion script to send the values to the instructor via e-mail cfmail
. The Flash movie then continues.
I would like
dave wrote:
depends on how its getting its values
either add a few frames to the movie or get the values in the cfm file and
return to flash but ur gunna have to edit the flash movie to do it
cfdump aint gunna help at all
I was afraid of that. I do not have access to the source code of
Here's what I've tried so far:
Moving one test message from /Undelivr to /Spool. Of course there's a
typo in the name, so I changed it from Undelievered_Mailx to
Undelivered_Mailx. I also tried removing the Undelivered part
of the mail.
Once I had moved and renamed it, I restarted
Richard Crawford wrote:
Here's what I've tried so far:
Moving one test message from /Undelivr to /Spool. Of course there's a
typo in the name, so I changed it from Undelievered_Mailx to
Undelivered_Mailx. I also tried removing the Undelivered part
of the mail.
Once I had
In about two weeks, our mail server will be going down for a couple of
days. Consequently, any messages sent by Cold Fusion during that time
will not be delivered.
Does the CF server maintain these undelivered messages anywhere?
--
Richard S. Crawford
Programmer III: Oracle/Solaris Wrangler
Peterson, Andrew S. wrote:
C:\cfusionmx\mail\undelivr
Not sure of your path, but look for the undelivr folder. When the mail
server goes back online, cut and paste those files into the Spool
folder in the same directory
I'm actually running CF in a Solaris environment. I executed the
Venable, John wrote:
They will be in {cfroot}/Mail/Undelivr
Just respool and you should be good to go.
How does one respool?
--
Richard S. Crawford
Programmer III: Oracle/Solaris Wrangler
UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu)
2901 K Street, Suite 200C
Anders Green wrote:
At 03:58 PM 11/9/2004, you wrote:
In about two weeks, our mail server will be going down for a couple of
days. Consequently, any messages sent by Cold Fusion during that time
will not be delivered.
Does the CF server maintain these undelivered messages anywhere?
As
Al Everett wrote:
I always assumed that the current name was just
to have a directory name that was 8 characters
or less, for compatibility with something
ancient.
I was speaking to Richard Crawford's message:
I'm actually running CF in a Solaris environment. I executed the
following
Okay, this is complicated, and I apologize for that.
First of all, our website runs a mix of Cold Fusion and Perl scripts.
This is generally fine, except that Perl scripts don't run if the
context-root in included in the path to the script.
Is there a way to force the Cold Fusion server to
Barney Boisvert wrote:
You can't make CF do it, but you can certainly do that with
mod_rewrite.These two rules should be pretty close, though they
might not be perfect.(obviously assume your server has mod_rewrite
enabled):
RewriteEngine On
RewriteRule ^/cfmx(.*\.pl)$ /$1.pl [L]
The
I'm trying to figure out how to run some Cold Fusion scripts automatically.
For example: our users have logins that expire every three months.I'd
like to set up a script which would run each morning to scan all of the
users in the database, and send an e-mail to those users whose logins
will
Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
- Original Message -
From: Richard Crawford
To: CF-Talk
Sent: Monday, August 23, 2004 9:39 AM
Jochem van Dieten wrote:
Richard Crawford wrote:
We have a situation where we need to retrieve the text of all messages
sent through our servers with the CFMAIL tag over the past year to a
particular e-mail address.I have already looked at the mailsent.log
file, but it only indicates
We have a situation where we need to retrieve the text of all messages
sent through our servers with the CFMAIL tag over the past year to a
particular e-mail address.I have already looked at the mailsent.log
file, but it only indicates whether the mail was sent successfully or not.
Is there a
I'm using CFINCLUDE to bring in a file from another directory into my
current file.The problem is that the file being included contains
references to images in other folders, via relative paths.Thus, when I
load the main page into a browser, the images do not show up.
Is there a way around
I have the following bit of code:
cfstoredproc datasource=DLCampus procedure=dlc_sp_verifyLogin
debug=yes
cfprocparam type=in value=#trim(FORM.sLogin)#
cfsqltype=cf_sql_varchar
cfprocparam type=in value=#trim(FORM.sPassword)#
cfsqltype=cf_sql_varchar
cfprocparam type=in
Deanna Schneider wrote:
What database are you using? This sounds like something that would be best
handled at the database level, instead of running it through CF.
Deanna,
I'm using SQL Server 7.The problem is that the field with the
characters to be replaced is a TEXT field, and you can't
Deanna Schneider wrote:
Don't know SQL Server. Sorry. But, as for your 500 error - make sure that
show friendly http errors is turned off in your IE preferences. Then, you
should at least see more info.
That in itself isn't an issue (I don't use IE if I can possibly avoid
it).I had hoped
Burns, John D wrote:
Can anyone recommend webmail application that works with POP3 that works
well and has a good UI?CF would be nice, but not a necessity.It's a
Windows 2003 Server and we have PHP and ASP enabled.Easy to set up
would be a good thing.It's actually working with iMail installed
I have a set of strings that contain carriage returns.I'd like to go
through and strip them out.I figure the REPLACE function would do the
job but I'm not sure how to refer to the carriage returns.
INPUT STRING:
I am a string with a
carriage return
OUTPUT STRING:
I am a string with a
Actually, my question about replacing special characters (thanks to all
who answered, by the way) was part of a larger question.What I really
need to do is select all rows of one table, modify the value of one
field, and insert all of the rows, with that one modified field, into
another table.
Burns, John D wrote:
I asked a question earlier about transferring files from one server to
another automatically.The 2 servers are not on the same network and
the files that are being copied are sensitive HR-type files.What is
the most secure way to transfer files like that?Secure FTP?Is
?
John Burns
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 03, 2004 1:56 PM
To: CF-Talk
Subject: Re: Secure FTP?
Burns, John D wrote:
I asked a question earlier about transferring files from one server to
another
Using CFMX under JRun 4 on Solaris 9.
I've got a Cold Fusion script which uses the CFMAIL function to send the
results of a quiz to an instructor.Unfortunately, no matter what I do,
I can't get the mail to go through.I've checked that I'm using the
proper syntax for CFMAIL, that my mail server
Dave Watts wrote:
I've also checked the SQL in the SP's that CF calls, and
there seems to be nothing wrong there; when I run them in the
command line they only take a few seconds to run.However,
it takes several minutes for the login to process on the web.
I'm at a loss. Anyone got any ideas
I am at a loss here.
Here's the setup:
Webserver running Cold Fusion MX on JRun4 on Solaris9, talking to MS SQL
Server database on a different machine.
About two weeks ago, we started experiencing serious slow-downs on our
site.Neither computer is responsible -- the Solaris box is running
I'm trying to write a script which will take as an argument a table
name, then copy the data from that table in one table to an identical
table in another database (assuming that the target database has a blank
table with an identical structure).
Has anyone attempted this sort of task
Dick Applebaum wrote:
are the source and target db's
1) on the same db server?
2) on different db servers local to the same host
3) on different db servers local to different hosts.
4) are you trying to create an exact duplicate of the source in the
target or update the target?
what
Tony Weeg wrote:
why not use select into?
I am still looking for information about select into.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
Tony Weeg wrote:
ok...
here ya go...simple but effective.
select *
INTO server_B.something.dbo.database_B
from server_A.something.dbo.database_A
that will take everything from a to b, table structure etc.
tw
I must need more coffee this morning, because I can't find any reference
Doug James wrote:
Presuming M$ SQL Server, one could write a stored procedure the perform
the 'select into'. One note, if the goal is to be able to pass in any
source table and any matching destination table then the stored proc
would have to build a string and then use 'exec
Tony Weeg wrote:
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
wondering.
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 2:42 PM
To: CF-Talk
Subject: Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
Matthew Walker wrote:
Maybe you know this already but CF still processes content inside HTML
comments. So you shouldn't comment out CFML with HTML comment markup.
The strange thing is that the troublesome comment markers worked fine
before I rearranged some of the code inside the script to
I have a rather long script that I've been editing with HomeSite.When
I try to run it, I keep getting this error:
Context validation error for tag cfif.
The end tag /cfif requires a matching start tag.
I've gone over this code with a fine-toothed comb several times and even
rewritten big parts
J E VanOver wrote:
Can you postyour code?
Unmatched comment tags?
It turned out to be something similar.Some parts of the code contained
comments that started with !--- and some that started with !--.I
went ahead and replaced all of the latter with !--- and that seems to
have fixed it.
Barney Boisvert wrote:
With DMWX I've run into sporadic situations where it will replace certain
things with this big long string of nastiness that seems to be some form of
metadata markup about a given variable or tag.I've got a couple files in
my app (of about 2000) that I can't edit in DW,
I was receiving an error, Wrong number of type of parameters passed
whenever trying to call my Oracle stored procedure from Cold Fusion.I
received this error in one stored procedure, fixed it, and then got it
with another stored procedure.
Both of the stored procedures, as it turned out, were
After I've executed an Oracle Stored procedure and brought the results
into Cold Fusion, is there a way to close the ref cursor within Cold
Fusion?I've tried calling a second stored procedure that closes the
cursor, but this doesn't seem to do the trick.
Is it even necessary to close the
Deanna Schneider wrote:
My understanding is that if you use a cursor for it gets closed
implicitly.
I've used this syntax before (without closing) successfully:
BEGIN
OPEN mycursor FOR
select blah blah;
END;
That makes sense to me.It's what I've been assuming as well.
--
Richard S.
Consider this stored procedure (part of package DLC):
PROCEDURE dlc_mail_countMsg (
studentID IN number,
mailInfo OUT types.cursorType
)
AS
BEGIN
OPEN mailInfo FOR
SELECT
count(*) AS msgCount
FROM
tblMail
WHERE
mIndividID = studentID AND
mToType = 1 AND
, Richard Crawford wrote:
Well, I altered the stored procedure as follows:
=
PROCEDURE test_dlc_sp_getStudentInfo (
studentID IN number
)
as
studentInfo types.cursorType;
sFirst varchar2(50);
sLast varchar2(50);
sOrient char(1);
begin
open studentInfo
Janet,
Thanks for the suggestion.I tried it, but continue to receive the
unsupported data conversion error.
This is getting mighty frustrating.
Janet Schmitt wrote:
I would try something like this for the Oracle portion:
CREATE OR REPLACE
PACKAGE schemaname.studentpackage
IS
TYPE
Stacy Young wrote:
Perhaps I spoke too soon...I just remembered an unsolved mystery with
our CF servers relating to an occasional JDBC error involving
CF_SQL_NUMBER and a numeric field in oracle.
Thanks for the tip!
Stace
Stace,
How did you resolve the issue?I think I'm having
Janet Schmitt wrote:
Richard -
What is the format of the table tblStudentInfo?What are the datatypes
specified for sFirst, sLast, sOrient and studentId?
What is the CFSTOREDPROC code that was used to call this procedure?
Janet.
Janet,
Here is the table definition:
sampath nellutla wrote:
CFSTOREDPROC procedure= mySchema.myPackage.spl_proc_summary datasource=#request.datasource#
Based on my own understanding, this line:
cfprocparam cfsqltype=CF_SQL_REFCURSOR type=OUT
is unnecessary in CFMX+.
CFPROCRESULT NAME=rs1
/CFSTOREDPROC
Now if only I could
Janet Schmitt wrote:
3.Remove the close cursor statement from the package body.
Janet,
Turns out that #3, above, was all that I needed to do.I feel kinda
silly (why would I want to close the cursor if I wanted to read it later
on?!!?), but now the thing works!
Thank you very much!
--
bret wrote:
Me again-
The org I work for is currently running Oracle 8.1.7 and is looking to
upgrade. The question now is how does the new 10G Oracle version run
with CFMX, and does it require custom JDBC drivers. Anyone have
experience with this?
I'm assuming Oracle 9 runs jim dandy
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
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
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
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
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
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
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
Dave Watts wrote:
I'll look into ViennaSQL.I currently use the free version
of TOAD, which doesn't (as far as I can tell) allow me to
test stored procedures.
Well, the thing we want to test specifically is what happens when you call
it through JDBC. I don't think TOAD uses JDBC.
I
Adrocknaphobia wrote:
Use SQL*Plus to test your procedures.
Thanks.I've done so, and they both compile and run fine.It's where
I'm trying to return the ref cursor to Cold Fusion that it stops working.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group
Adrocknaphobia wrote:
Sorry, missed the begining of the thread, why do you guys think its an issue with JDBC?
Hi, Adam.
This is the error message I've been receiving:
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Unsupported data conversion.
--
Richard S. Crawford
Well, I altered the stored procedure as follows:
=
PROCEDURE test_dlc_sp_getStudentInfo (
studentID IN number
)
as
studentInfo types.cursorType;
sFirst varchar2(50);
sLast varchar2(50);
sOrient char(1);
begin
open studentInfo for
select
sFirst,
It yields this error:
Variable GETNAME is undefined
Rob wrote:
what does
cfdump var=#getName#
yield?
On Mon, 2004-03-08 at 15:25, Richard Crawford wrote:
Well, I altered the stored procedure as follows:
=
PROCEDURE test_dlc_sp_getStudentInfo
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
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
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
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
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
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)
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
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
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);
, 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
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
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
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
1 - 100 of 176 matches
Mail list logo