We have an app with a protected area that just using a basic session check
in application.cfm. In the protected area there is a directory of PDFs. No
one can access them through the app without logging in. If the person knew
the url to the pdf though it would serve since application.cfm would
I imagine this is a common issue :
Let's say you have bunch of PDFs in a directory: /pdfs and the links to the
files in the site are behind a login so non-registered users cannot access
them. If a users knew the link to the file:
http://www.mysite.com/pdfs/sample.pdf they could still get to
It's a demo server we use to show clients works in progress, its behind our
firewall but is open on 80 for this purpose.
-Original Message-
From: Tom Chiverton [mailto:tom.chiver...@halliwells.com]
Sent: Thursday, May 28, 2009 4:24 AM
To: cf-talk
Subject: Re: (ot) Hacked by Fatal Error
[mailto:bayous...@gmail.com]
Sent: Thursday, May 28, 2009 10:12 AM
To: cf-talk
Subject: Re: (ot) Hacked by Fatal Error
How difficult was your ftp user/password?
--
Ryan
On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland
smulholl...@aimg.comwrote:
It's a demo server we use to show clients works
Has anyone seen this or had this occur - Basically they replace the default
docs in the wwwroot (index.htm, html, asp, default.htm, html, asp, etc.)
with a file with only html and css in it that shows a picture of Homer
Simpson and the massage Hacked By Fatal Error and something along the lines
Yeah, that is my concern. While nothing seems to be done to the server
except the defacing I want to make sure whoever got in this time can't get
back in. The server had a couple of win2k security updates waiting to be
applied that were applied after the fact. Yeah im figuring its IIS as well.
Looked at the air list and it doesn't seem to get much in the way of posts
so I figured I would throw it out here.
I am just getting started with AIR and wanted to see anyone's thoughts on
which road to go down in regards to air for the following.
I wanted to make a simple app that would
behavior was changed there - As I understand it, CF will
use the default transaction settings (eg dirty read, committed read ...)
2009/1/28 Scott Mulholland smulholl...@aimg.com
Out of nowhere today I had two different applications that utilize the
same
datasource begin throwing the error
Out of nowhere today I had two different applications that utilize the same
datasource begin throwing the error:
Data source DATASOURCENAME verification failed. The root cause was that:
java.sql.SQLException: Datasource names for all the database tags within
CFTRANSACTION must be the same.
Yeah, both are running.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2008 3:00 AM
To: CF-Talk
Subject: Re: Datasource Issue - CF7
Scott Mulholland wrote:
We had a test server recently run low on space and neo-query.xml became
corrupt
We had a test server recently run low on space and neo-query.xml became
corrupt. We replaced it with a backup but since them any Access datasources
and ODBC Socket datasources always say they are not found. If we try to
update them in the cf admin we get:
TCP/IP error, connection refused.
this
are you happy with the URL being used, if it is being generated dynamically
it may be malformed or incorrect.
Is it in a cf try?
Also, try dumping CFHTTP after the call - it will have a status code and
other info that my help
On Wed, Apr 16, 2008 at 9:03 PM, Scott Mulholland [EMAIL PROTECTED]
wrote
Anyone out there worked with iMIS IBO's and CF before? If so please contact
me off list if you'd be willing to answer a few questions and possibly
entertain a small integration project.
Thanks,
Scott
~|
Adobe® ColdFusion®
, can you browse to the URL?
Can you ping the domain?
Have firewall settings changed?
On Wed, Apr 16, 2008 at 7:05 AM, Scott Mulholland [EMAIL PROTECTED]
wrote:
I have a piece of code that has always worked that does a cfhttp to create
a
static file. The file it calls is on the same server
I have a piece of code that has always worked that does a cfhttp to create a
static file. The file it calls is on the same server/domain. Today the
cfhttp just keeps timing out. cfhttp calls to other urls not on the server
work without issue though. Anyone else experience anything like this?
I was using the step by step guide found here:
http://labs.fusionlink.com/katapult/index.cfm?page=articles/daylightsavings
to update my JVM.
The quick question*: Do you need to install the development tools option?
What makes me unsure is the statement:
**Remember the full SDK, the JRE
Thanks Damon. I had actually visited your blog this morning, among countless
others, before posting. I could not seem to find any clarity on the two
questions I had though.
Thanks,
Scott
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
Does anyone out there have any experience in working with this? If so
please contact me off list, I have a few questions regarding it.
Thanks,
Scott
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time-saving
Problem solved, turned out to be a dns caching issue on their network.
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 17, 2006 9:44 AM
To: CF-Talk
Subject: Re: Opening PDF issue
On Tuesday 17 October 2006 13:40, Scott Mulholland wrote:
Anyone
I have a page that has links to pdf files which open in a new window. Works
fine for 6 users (all in different locations) but 2 users (in same location)
can only open some of them. The ones that won't open give them the
following error:
HTTP Error 404.1 - File or directory not found: Web
..looked pretty much like Ortiz-Shamrock 2 without complaints on the
stoppage. Tito was just too strong for him I think.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion
Wrong list sorry :(
Meant for community...i must be punch drunk.
-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 11, 2006 8:40 AM
To: CF-Talk
Subject: Ortiz-Shamrock 3
...looked pretty much like Ortiz-Shamrock 2 without complaints
.
Ben Nadel
www.bennadel.com
-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 25, 2006 1:23 PM
To: CF-Talk
Subject: Odd Query issue
I have a query today that stopped working with an invalid column error. The
database did not change
return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Scott Mulholland [EMAIL PROTECTED
Yeah, its ms-sql, and yes, does seem silly that I hadn't done that yet ;)
Query analyzer gave me the same result for the update but with a better
error message, Invalid column job_id, Procedure jobs_UTrig. Looks like
it's an issue with one of my relationships/constraints.
Thanks,
Scott
Thanks for all help all, turns out a trigger on the table was referencing
the job_id field in a different table that was recently changed.
All the queries work now.
-Original Message-
From: Brian Rinaldi [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 26, 2006 1:34 PM
To: CF-Talk
I have a query today that stopped working with an invalid column error. The
database did not change. Select statements work on it but not updates.
Select * from jobs where job_id = 1 - works fine
Update jobs set status = 0 where job_id = 1 - results in Invalid column name
'job_id'.
Subject: Re: Odd Query issue
Maybe someone changed your datasource configuration.
--
Joseph Lamoree
On 25 Jul 2006, at 10:22, Scott Mulholland wrote:
I have a query today that stopped working with an invalid column
error. The
database did not change. Select statements work
Looking for an answer or some thoughts on a theoretical question:
Will a search engine respond more favorably in indexing a html file over a
cfm file (keywords, content, etc aside)?
For example would one of these urls jump out as being better in terms of
SEO:
Bryan,
Thanks for the input. We are doing the url rewriting currently, we were
just wondering if that was enough in terms of the url/filename for the SEO
side of things.
Thanks,
Scott
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 2:35
I know during it the icon in breeze was red showing the session was being
recorded. The adobe site also says the sessions will be available in the
future but nothing was said about it during the presentation.
-Original Message-
From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL
-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: Friday, March 17, 2006 4:15 PM
To: CF-Talk
Subject: Mail Spool stopped sending
An application of ours just stopped sending mail today. We do not manage
the server. The server was moved behind a firewall this morning
An application of ours just stopped sending mail today. We do not manage
the server. The server was moved behind a firewall this morning and mail
had been sent after that without issue. It uses the local smtp setting to
send and the connection verifies through the cfadmin.
The mail.log
I would second this setup, we have used it in a few applications with great
success.
-Original Message-
From: Justin D. Scott [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 9:48 AM
To: CF-Talk
Subject: RE: Accessing Network Drives
1) Is it possible to run CFFILE Exists on
Russ,
I have had great success running a DTS from CF in the past using the info in
this article:
http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS
Scott
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Monday, November 07, 2005 1:52 PM
To: CF-Talk
Subject:
I've recently inherited an access database that I am trying to do some
reporting on. One of the tables has the following structure:
Att_ID Type Values
410 ColorBlue
410 ColorOrange
410 ColorBlack
410 ColorOlive Drab (green)
410 Size
and all is only $200 and it will give you, I bet,
everything you need.
I agree with the others that building your own cart is the way to go,
but if time is an issue you can get x-cart up and running and loaded
with products in just a couple of days.
--Ferg
Scott Mulholland wrote:
Our plan
I'm currently evaluating some e-commerce solutions for an upcoming project.
Past postings have pointed me to look at cartweaver, cfwebstore and
ablecommerce. I have also looked at a couple of non-cf based solutions.
Are there any others that I should be looking at or dos anyone have any
Our plan is to roll our own out in the future, the creation of it is not a
factor for us on this one, the timeframe is so we are looking to go off the
shelf this time around.
-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10, 2005 10:04 AM
To:
at?
One of the sample apps that came with CF is a shopping cart, why not use
that as a base.
-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: 10 October 2005 22:13
To: CF-Talk
Subject: RE: Shopping Cart solution - any others to look at?
Our plan is to roll our own
Anyone know of any existing public resources for congressional contact
information (preferably email addresses)? Ideally some sort of feed or
export.
Thanks,
Scott
---
[This E-mail scanned for viruses by Declude Virus. Service provided by
Accurate Imaging, Inc.]
I was involved in a discussion earlier today about the feasibility of
building a control panel like solution to allow for users to maintain items
like domains, emails, etc. (think cpanel) on the linux platform. Not being
a linux person myself I was trying to find resources speaking to the
-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 22, 2005 4:08 PM
To: CF-Talk
Subject: Re: CF linux questions
Scott Mulholland wrote:
I was involved in a discussion earlier today about the feasibility of
building a control panel like solution to allow
Is there any difference in performance when accessing files on another
server between these two methods? The access would be in terms of cffile
and some zipping using a java based zip util.
Thanks,
Scott
---
[This E-mail scanned for viruses by Declude Virus. Service provided by
Accurate
Is the list up?
---
[This E-mail scanned for viruses by Declude Virus. Service provided by
Accurate Imaging, Inc.]
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
Options are always appreciated!
Thanks again.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 11, 2005 10:03 AM
To: CF-Talk
Subject: RE: Cached query - Any way to tell when it was cached?
I don't blame you. :) I'm just a big fan of options, so I
Is there a way, possibly as easy as an undocumented query variable
(query_name.CachedSince - one can dream no?), to return the timestamp of
when a query was last cached? Was looking for an easy way to have a This
report last generated on: X display an a page with a large recordset that
we
Thanks Justin, that did it. The dns was flushed yesterday but it seems CF
was not restarted. Restarted it and now it's fine.
Scott
-Original Message-
From: Justin D. Scott [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 10, 2005 12:09 PM
To: CF-Talk
Subject: RE: Mailserver verification
We recently moved our mailserver from one datacenter to another. Since the
move the mailserver won't verify in the cf admin on our dev and production
server when referenced by name (i.e. myserver.mydomain.com) but verifies
fine by IP. We have dropped the firewall to test and it still fails,
I think Ian's may be the way to go. I am using cachedwithin as the data
changes frequently so we cache it for 6 hours. I don't think cachedafter
will work.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 10, 2005 4:31 PM
To: CF-Talk
Subject: Re:
Yeah, for simplicities sake I'll go with the other one, heh.
Thanks for the help guys.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 10, 2005 7:19 PM
To: CF-Talk
Subject: RE: Cached query - Any way to tell when it was cached?
I think Ian's may
Can the Oracle thin drivers be used to connect to Oracle Db's from MX
Standard? I would imagine they could since the datasource type is other and
not Oracle. If not are there other/better alternatives? I have an Oracle
database I will need to connect to every so often from a test server that
a bridge to
the Oracle DB?
-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 06, 2005 7:17 AM
To: CF-Talk
Subject: Oracle thin driver in MX Standard
Can the Oracle thin drivers be used to connect to Oracle Db's from MX
Standard? I would imagine
Is there an easy way to do a mass delete with 2 pieces of criteria in the
where clause?
With one clause we are just using a subquery i.e delete from contracts
where accountno IN (select distinct accounts from cancels). I'm having
trouble seeing a way to do in a sql statement if we needed to
I might be having one actually...would that hold the pairings? I believe it
would as contractno's are unique to the accountnoyep, think I'm having a
Monday.
Well, thanks for opening my eyes to the obvious ;)
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent:
I was asked this question today by someone who received conflicting answers
on this and not knowing the answer I figured someone on here probably would:
What is the general practice in terms of licensing SQL server for use in a
web app? Is it the standard or the only option to go with the
Thanks Dave, I'll pass that along. Ironically they were told the opposite
by whoever answered the phone at MS ;)
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 5:55 PM
To: CF-Talk
Subject: RE: SQL licensing question
What is the general
I have a new machine that has xp pro on it. I'm installing cf 6.1 dev
and was wondering if there was any benefit to running it through IIS
instead of the self contained web server you can install with mx?
Does running cfmx on its own server and not IIS make it easier to also
run a .net
Yeah, it runs on 8500
-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED]
Sent: Monday, March 07, 2005 12:00 PM
To: CF-Talk
Subject: RE: Developer edition install question
I believe you will also have to use an alternative port with the stand
alone server, instead of port
, Fireworks, and CuteFTP all open at the same time. Gets
nasty, actually.
Sorry that got long, but it's not so simple a question.
Laterz,
J
On Mon, 7 Mar 2005 11:21:57 -0500, Scott Mulholland
[EMAIL PROTECTED] wrote:
I have a new machine that has xp pro on it. I'm installing cf 6.1 dev
No, win2000, cfmx6.1.
-Original Message-
From: Jehiah Czebotar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 8:06 PM
To: CF-Talk
Subject: Re: Error Oddity
for a template that does exist?
are you running on a linux machine where filenames are case sensitive ?
--
[EMAIL
Anyone encounter this error in the exception log:
Error,jrpp-256,02/20/05,14:12:55,,File not found: etc...
for a template that does exist? I noticed it in our logs this weekend.
We apparently also had an issue where the cfmx service just stopped
running, was trying to see if it could be
I am connecting to a new database run by another company and have been
experiencing an intermittent error:
[Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000:
maximum open cursors exceeded
When I talked to the DBA's who maintain the database they told me:
If your app is
Inline via cfquery
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 7:35 PM
To: CF-Talk
Subject: Re: Closing Oracle Cursors
Are you executing stored procedures or inline via cfquery?
-Adam
On Thu, 27 Jan 2005 17:44:12 -0500, Scott
I think its your use of cgi.referer. I have seen cases of Norton
Internet Security stripping that variable.
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 12:38 PM
To: CF-Talk
Subject: cfcontent and Norton firewall?
I'm using
-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 6:11 PM
To: CF-Talk
Subject: sql LIKE question
Is there any way to force LIKE to match on leading zeros? If I have a
query along the lines of:
select accountkey
from companies
where
?? How is it
defined?
Pascal
-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: 07 December 2004 00:11
To: CF-Talk
Subject: sql LIKE question
Is there any way to force LIKE to match on leading zeros? If I have a
query along the lines of:
select
Is there any way to force LIKE to match on leading zeros? If I have a
query along the lines of:
select accountkey
from companies
where accountno LIKE '%#searchString#%'
and I search with a string of: 0059
I am getting results like:
05976574
12343459
59748311
It treats it as if I
Recently upgraded a dev box to 6.1 and now I am experiencing these types
of errors:
Diagnostics: An exception occurred when establishing a FTP connection.
The cause of this exception was that: java.net.NoRouteToHostException:
No route to host: connect.
Diagnostics: An exception occurred when
Turns out that I can. Looking further it seems the ftp server sent back
a confirmation from their IP but not on port 21 so the firewall deemed
it an attack and blocked traffic from them so our connections were
dropping.
Thanks.
-Original Message-
From: Dave Watts [mailto:[EMAIL
In theory is there any downside to joining cross database. I'm using
sql server and was considering having my user data in one database and
my content data in an other. In some cases I would need to do something
like this as an example:
2 databases (MS SQL Server for arguments sake): USERS and
We have an application running on CFMX, SQL Server 2000, all MS Windows
2000 boxes. A few times (3 times in 1.5 yrs actually) we have
experienced the application just randomly returning a blank white screen
to the browser intermittently. It starts with one page, then others
start coming back the
:-)
On Fri, 19 Nov 2004 10:02:45 -0500, Scott Mulholland
[EMAIL PROTECTED] wrote:
In theory is there any downside to joining cross database. I'm using
sql server and was considering having my user data in one database and
my content data in an other. In some cases I would need to do
, 19 Nov 2004 10:38:27 -0500, Scott Mulholland
[EMAIL PROTECTED] wrote:
Well some user data would be stored in session vars, like the
account_id and such, but my example was more along the lines of if you
wanted to pull a list of articles to display the article and name of
the person who
Anyone else have this issue:
This task is set to execute at 6:15 each morning but as shown by the log
when the clocks went back the scheduler seems to have gone back an hour
with it??
The time still shows 6:15 in the scheduler but it has been running at
5:15 all this week.
Make sure your driver is DataDirect 3.3...I was using 3.1 and it would
not work, upgraded them and everything was fine.
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 10:58 AM
To: CF-Talk
Subject: RE: Oracle stored procedure returning a
Rachel,
The company I work for offers this, would it be ok to contact you off
list?
Thanks,
Scott
-Original Message-
From: Rachel Maxim [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 8:37 AM
To: CF-Talk
Subject: OT: Reliable SEO company recommendations?
My company is
Janet,
Thanks for your help.I just upgraded one of our servers to 6.1 (the
box I was using was just MX) and it worked with no issue now.Looks
like it was a driver version issue.
Thanks again for all your help with this, it is greatly appreciated!
Scott
-Original Message-
From: Janet
[mailto:[EMAIL PROTECTED]
Sent: Friday, September 17, 2004 10:33 AM
To: CF-Talk
Subject: SOLVED: Oracle Stored Procedure - another shot, now with
procedure code
Nice. So this was a 6.0 issue... good to know.
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Fri, 17
Janet,
That makes sense.I was able to get it to run in sql*plus now by doing:
VARIABLE rs REFCURSOR
execute :rs := test01.testpckg(:rs);
print rs
Thanks,
Scott
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 9:36 AM
To:
Thanks to all who have offered advice thus far.I have since been able
to get this running in SQL plus, but still get the same error in CF.
(MX, Enterprise edition, using default Oracle driver)
Error received: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line
1, column 7: PLS-00306: wrong
Thanks to all who have offered advice thus far.I have since been able
to get this running in SQL plus, but still get the same error in CF.
(MX, Enterprise edition, using default Oracle driver)
Error received: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line
1, column 7: PLS-00306: wrong
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 10:18 AM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
That cursor return needs to be set to IN OUT, not just OUT.
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED
logging in as the schema owner?
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Tue, 14 Sep 2004 10:57:27 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
Thanks Adam.The change has been made but I'm still getting the same
error.
Here
We are using the Oracle drivers that ship with MX Enterprise so
according to that technote we should be ok with ref cursors.
Thanks for the info Janet, I'm currently looking into having the cursor
defined along the lines of your last post.
Scott
-Original Message-
From: Janet
Janet,
I have the snippet now from them.This is how it's currently defined
(which looks like it's in line with what you posted aside from In Out):
Type ReturnSet is ref cursor;
Procedure testpckg(curReturnSet Out Returnset);
They had switched it before to be In Out for me and I still had
Janet/Adam,
First off thank you guys for all your help thus far, it is greatly
appreciated.They did switch it to IN OUT this morning for me and I had
the same results.
I checked the permissions using the queries Janet supplied:
For roles my user has CONNECT and CTXAPP.
For table
Deanna,
It is not one of my DBA's, it's an outside vendor so I do not want to
post the code.I have actually been changing the package name as well
for that reason in my posts.They can run it on their side with no
issue using pl/sql developer.I can also run the qry that the procedure
executes using
Adam,
I am thinking you may be right based on my last post regarding the
EXECUTE privilege.
Running it from SQL*PLUS has the same results:
SQL exec test01.testpckg;
BEGIN test01.testpckg; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in
Bob,
Just use the value that you would find in the tnsnames.ora file if you
had one on the machine.Make sense?
Scott
-Original Message-
From: Bob Flynn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 5:37 PM
To: CF-Talk
Subject: Setting up Oracle datasource in MX
I
Janet,
Thanks for the tip!
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSOROUT
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 9:23
Trying to call a stored procedure from Oracle that takes no parameters
and returns a cursor.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TESTPROC'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
I have
I do not have the package unfortunately.
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 12:49 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
What does the package specification for TESTPCKG look like?
At 01:10 PM 9/10/2004 -0400,
seen this error (usually when deploying an
application with a new schema) it comes back to privs.
Check the roles and grants you've given to the user you specified in
the datasource connection.
-Adam
On Fri, 10 Sep 2004 13:10:42 -0400, Scott Mulholland
[EMAIL PROTECTED] wrote
I was looking for a recommendation on a book that would give one a basis
or better understanding of SQL server admin/performance tuning.
I'm looking for a book that would be useful to someone with a working
knowledge of SQL server from the queries/stored procedures/DTS
package/table/db design
Norton Internet Security and similar products will strip it.
-Original Message-
From: Donnie Carvajal [mailto:[EMAIL PROTECTED]
Sent: Monday, July 12, 2004 10:41 AM
To: CF-Talk
Subject: CGI.HTTP_REFERER is blank!
I am trying to check the CGI.HTTP_REFERER variable to keep outside sites
I inherited a project today in which someone that used to work here
created a batch of images using the Fireworks MX data driven graphics
wizard and some xml generated using cold fusion.
I was wondering if anyone knew if it was at all possible to call the
functionality of that wizard via
I used to work for a DSL provider and we had to show availability from
Covad, Northpoint and Rhythms.All 3 offered XML interchanges that
would let you send the address and phone number and receive the
availabilty back for use in your system.Best to contact Sprint and see
if they offer something
Is there any rule of thumb or method for figuring out how to optimize
the number of queries to cache setting in Administrator?
Thanks,
Scott
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Have you tried calling it with cfexecute?
-Original Message-
From: Gunny [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 11:35 AM
To: CF-Talk
Subject: EXECUTING EXTERNAL PROGRAM
Really trying day, today.Will someone please think for me. I think
I've lost my mind.
I need to
1 - 100 of 179 matches
Mail list logo