By chance did you recently migrate and are using different credentials?
Possibly just a database permissions issue.
Byron Mann
Lead Engineer Architect
HostMySite.com
On Jul 19, 2013 5:47 PM, vernon broussard vernon.brouss...@la.gov wrote:
In ColdFusion 10 when trying to access one of our
In ColdFusion 10 when trying to access one of our gateway applications now I
get an error saying that Executing stored
procedures is not allowed. How do you enable stored procedures in this
version? Is it part of the install or can it be changed
within administrator?
CF 10 does not by
When you say you modified the stored proc and executed it do you
mean you executed an ALTER statement on the proc?
If you re-open the proc and the new parameter shows up, then I'm sure it
is saved.
Did you add the new parameter to the end of the list of params? Since
dbvarname is largely
and now it is working.
Very confusing to have a stored proc on a table that is modifying another table.
Thanks for the input though!
Chad
-Original Message-
From: b...@bradwood.com [mailto:b...@bradwood.com]
Sent: Wednesday, November 18, 2009 12:26 PM
To: cf-talk
Subject: RE: stored
By table1 and table2 I actually meant database1 and database2.
Im on a roll today...
-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com]
Sent: Wednesday, November 18, 2009 12:36 PM
To: cf-talk
Subject: RE: stored procedures
Never mind.. I was editing the wrong
Rick,
Um... This is not going to help. You will probably need to post the error
you are receiving and also the SP code. There's nothin inherently wrong with
the code below at first glance.
-mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
thanks greg, yes my hair is now growing back as we speak :)
and unfortunately for our company i am the DBA :) In fact me and my business
partner are the DBA's, programmers, designers, marketers, salesman etc.. but
thanks to all you guys on this site we are are getting better at other things,
hi greg thanks for your reply. I thought that may be it for a minute but yes it
is ticked - all of the allowed sql statements are ticked
Thanks
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
hi greg, just noticed that you said you were using a
mysql-connector-java-3.1.12.
i dont know if it makes any difference but i am using dreamweaver and have
setup a mysql connection through it. Queries work fine but not the stored
procedures. Do you think it may have something to do with the
Richard,
Although ColdFusion ships with MySQL database drivers, my sense is that
these bundled drivers may not support Stored Procs. (Just guessing.)
When I go into the ColdFusion Administrator, on the Data Sources page, the
Driver dropdown for Add New Data Source has for MySQL MySQL (3.x).
hi greg, you are a diamond :) I changed the driver over to the connector j 5.0
and added a new datasource not with mysql connection but with 'other' and set
the configuration manually. I tried it and couldnt believe that it is now
working. It does make alot of sense now that we know what it is.
Richard,
Glad to be of help. I hope that now you will have a great weekend, happy
holidays, etc. (and that your hair will grow back :-)
And more than that, I hope that with Scorpio the MySQL drivers bundled with
CF will be upgraded. (Anyone from the CF team at Adobe lurking here on this
list ?
Richard,
Just to confirm background stuff ...
Is the following enabled:
In ColdFusion Administrator -- Data Sources -- {select data source in
question} -- Advanced Settings -- Allowed SQL -- Stored Procedures
I am running stored procs with no problem with MySQL 5.0.19 with ColdFusion
7.0.2
What do the functions return?
On 4/25/06, Shawn McKee [EMAIL PROTECTED] wrote:
I have used lots of Oracle stored procedures using cfstoredproc but my
DBA
has now written several functions that I need to use. I have never had
any
luck accessing these via cfstoredproc and was wondering if it
I don't believe you can access functions directly from ColdFusion.
You'd have to write a stored proc that calls the function, I think.
On 4/25/06, Shawn McKee [EMAIL PROTECTED] wrote:
I have used lots of Oracle stored procedures using cfstoredproc but my DBA
has now written several functions
Are the functions part of an Oracle package? If so I can send ya the code to
use 'emjust a normal CFQUERYno use of CFSTOREDPROC
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
Integers, strings, etc. A single value for a given function.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:33 AM
To: CF-Talk
Subject: Re: Stored procedures
What do the functions return?
On 4/25/06, Shawn McKee [EMAIL PROTECTED] wrote
here's how ya get at a fucntion that is part of a package:
cfstoredproc procedure=schemaName.packageName.functionName
datasource=#datasource# username=#userid# password=#passwd#
cfprocparam type=In cfsqltype=CF_SQL_BIGINT dbvarname=varName1
value=varValue1
cfprocparam type=In
Yes they are part of an Oracle package.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:46 AM
To: CF-Talk
Subject: ***SPAM*** Re: Stored procedures
Are the functions part of an Oracle package? If so I can send ya the code
to
use 'em
, Shawn McKee [EMAIL PROTECTED] wrote:
Integers, strings, etc. A single value for a given function.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:33 AM
To: CF-Talk
Subject: Re: Stored procedures
What do the functions return?
On 4
If it is pure functions you are talking about, I am sure this will work:
cfquery...
Select some_oracle_user_defined_function(arg) from dual
/cfquery
-Original Message-
From: Shawn McKee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 9:27 AM
To: CF-Talk
Subject: Stored
Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:55 AM
To: CF-Talk
Subject: ***SPAM*** Re: Stored procedures
here's how ya get at a fucntion that is part of a package:
cfstoredproc procedure=schemaName.packageName.functionName
datasource=#datasource
No benefit really. Not in this instance.
-Original Message-
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED]
Sent: 01 March 2006 21:39
To: CF-Talk
Subject: Stored Procedures and when to use them
Hi guys,
I am just getting my head around stored procedures in SQL Server. One of
Sprocs are faster if you are doing multiple things in 1 call. The idea is
you are in the database already so go ahead and let the database do what it
does best. For general selects, inserts, updates, and deletes keeping it in
the app is fine.
It does come down to personal preference though. I
be
your vice as CF will choke on large sets like this.
-Original Message-
From: John C. Bland II [mailto:[EMAIL PROTECTED]
Sent: 02 March 2006 10:15
To: CF-Talk
Subject: Re: Stored Procedures and when to use them
Sprocs are faster if you are doing multiple things in 1 call. The idea
: John C. Bland II [mailto:[EMAIL PROTECTED]
Sent: 02 March 2006 10:15
To: CF-Talk
Subject: Re: Stored Procedures and when to use them
Sprocs are faster if you are doing multiple things in 1 call. The idea is
you are in the database already so go ahead and let the database do what
it
does
One of the nice things about stored procedures wv. inline sql is that
your database can tell you which procs are invalidated by a change to
your schema, which can be a big time saver in development.
/t
~|
Message:
An example. I had a set of queries to delete an organisation from one table
and then all the relative data in the database for that organisation. I wrote
it originally in CF but it was taking about 2 minutes, and timing out, to
procees. After putting the whole lot into a stored proc the
: Martin Thorpe [mailto:[EMAIL PROTECTED]
Sent: 02 March 2006 10:49
To: CF-Talk
Subject: Re: Stored Procedures and when to use them
An example. I had a set of queries to delete an organisation from one table
and then all the relative data in the database for that organisation. I
wrote
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED]
Is there any advantage having this type of query in a SP over
calling a simple CFC ??
Mike,
Stored Procedures were a good choice for me when I was working at a place
that had two, top-notch DBAs who could really analyze some of the more
to add to this question (and secretly bump it to the top of the list), how does
the newID() function work in this case?
mike
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233827
Archives:
Hi guys,
I am just getting my head around stored procedures in SQL Server. One of
the things I am trying to understand is when I should be using them.
I can't stand them myself. Used them in an application just for
*hits'n'giggles, then needed to go back and make a few changes later. It was
Dayum, dude...
And I thought *I* was long-winded... cl!
Someone who goes thru keyboards faster than I do! hehe
Heh. I dunno... I've had this little jobber here for several years. I
like it ... I actually got it at a little independant computer shop
around the corner from the place
No, not you, the other Jared!
Wow, how embarrassed must you be right now?!
:OD
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: 04 March 2005 03:43
To: CF-Talk
Subject: Re: Stored Procedures in a CFC
Well Ade, thankee...
Preachy doesn't float
I'm planning to respond to this thread, but it's going to have to wait
until at least when I get back from the office this evening. I just
got busy last night with some new framework features to encapsulate
and/or search keywords for reuse in queries and since it's all
downloaded here at the
embarrassed must you be right now?!
:OD
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: 04 March 2005 03:43
To: CF-Talk
Subject: Re: Stored Procedures in a CFC
Well Ade, thankee...
Preachy doesn't float with me, it elicits an instant bye-bye, talk
But, I do see you're using NOT isDefined(variables.var).
I've been using NOT structKeyExists(variables,varName)
(which I didn't know about until Sean yelled at me for
using the other method... ;)) and I can say that it
dramatically improves clarity, performance, and
readability. It
Isaac, you've given me an answer for something I'd given
up on, I wrap my
SPs in functions some of the time, but because I don't
want to call the SP
twice on one page I've always assigned to a local variable
and then accessed
the resultset via that variable. For example:
cfset qUser =
Dayum, dude...
And I thought *I* was long-winded... cl!
Someone who goes thru keyboards faster than I do! hehe
I just happened to be skimming the code example and saw the isDefined
thing. I saw it, and questioned it. Glad you weren't put out.
I'm all for annoying people, except people
I use structures to pass back multiple things from
functions, but I'm not so
sure you're right about not using an array. An array maps
to the
cfprocresult's resultset attribute(as it could equally to
it's name attrib)
but with the array you don't need to know the name used
only the number
Good question, I believe you will have to enter the two resultset objects
into a single CF complex object (such as a Structure) and return that as a
single value.
-Original Message-
From: Andy Jarrett [mailto:[EMAIL PROTECTED]
Sent: 03 March 2005 09:01
To: CF-Talk
Subject: Stored
Good question, I believe you will have to enter the two
resultset objects
into a single CF complex object (such as a Structure) and
return that as a
single value.
That would be my choice. I think a structure makes more sense for that
as this code:
cfset data = myCFC.getQueries()
cfloop
of
the resultset.
I hope that makes sense, I've just had a not so powerful power nap and I
tell ya, it hasn't done anything for my thinking just this minute.
Ade
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 03 March 2005 13:50
To: CF-Talk
Subject: RE: Stored Procedures
I would do it differently (then returning a struct/array with both
recordset). Please give comments/suggestions/whatevers as I'm just
thinking out loud.
In essence, your SP returns two recordsets which don't hold the same
data, they could be related but they are not the same. Why not create
two
I would
be happy to try it out!
Also the SP would probably not get called again and again internally for as
long as the Query/Query plan is cached on SQL Server.
-Original Message-
From: Marc Campeau [mailto:[EMAIL PROTECTED]
Sent: 03 March 2005 15:24
To: CF-Talk
Subject: Re: Stored
Subject: Re: Stored Procedures in a CFC
I would do it differently (then returning a struct/array with both
recordset). Please give comments/suggestions/whatevers as I'm just
thinking out loud.
In essence, your SP returns two recordsets which don't hold the same
data, they could be related
The cfstoredproc tag will return both queries regardless, you could
construct the function to return one of the callers choosing, but from a
simplistic approach returning both in either an array or a structure seems
more useful. The point I was making was that you either reference them as:
To: CF-Talk
Subject: Re: Stored Procedures in a CFC
The cfstoredproc tag will return both queries regardless, you could
construct the function to return one of the callers choosing, but from a
simplistic approach returning both in either an array or a structure seems
more useful. The point I
On Thu, 3 Mar 2005 13:54:45 -, Adrian Lynch
[EMAIL PROTECTED] wrote:
I use structures to pass back multiple things from functions, but I'm not so
sure you're right about not using an array. An array maps to the
cfprocresult's resultset attribute(as it could equally to it's name attrib)
but
(). That's what I'm saying(asking whether it's) bad. Would array
syntax not hide better what loadData() does?
-Original Message-
From: Marc Campeau [mailto:[EMAIL PROTECTED]
Sent: 03 March 2005 17:04
To: CF-Talk
Subject: Re: Stored Procedures in a CFC
The cfstoredproc tag will return both
slips me by.
Ade
-Original Message-
From: Sean Corfield [mailto:[EMAIL PROTECTED]
Sent: 03 March 2005 20:19
To: CF-Talk
Subject: Re: Stored Procedures in a CFC
On Thu, 3 Mar 2005 13:54:45 -, Adrian Lynch
[EMAIL PROTECTED] wrote:
I use structures to pass back multiple things from
I think for readability returning the values in a
structure is going
to do a.k.a S.Isaac
cfset data = myCFC.getQueries()
cfloop query=data.getUsers.../cfloop
cfloop query=data.getRoles.../cfloop
But the idea of going through a function to get the
different
recordsets, and referencing
Isaac,
A quick comment on your CFC snippet...
First of all, thanks for using real code instead of psuedo-code. I
know sometimes the shorthand is nice for the writer, but it's hell on
the reader. I do it myself, although lately I've been more inclined to
jump into HomeSite+ and write it up and
On Thu, 3 Mar 2005 20:51:45 -, Adrian Lynch
[EMAIL PROTECTED] wrote:
I don't see how using structures over arrays improves encapulation. Granted
standardising the naming of the resultsets will help but how can it be
better in having to know the names of two variables inside another
-Talk
Subject: Re: Stored Procedures in a CFC
On Thu, 3 Mar 2005 20:51:45 -, Adrian Lynch
[EMAIL PROTECTED] wrote:
I don't see how using structures over arrays improves encapulation.
Granted
standardising the naming of the resultsets will help but how can it be
better in having to know
Well Ade, thankee...
Preachy doesn't float with me, it elicits an instant bye-bye, talk
to the hand reaction. So I try to avoid it, though sometimes I fear I
fail anyway.
Thanks for the kudo.
(And glad to oblige, that's what community's all about!)
Laterz,
J
On Fri, 4 Mar 2005 01:36:02
Stored procedures are not meant to replace simple queries that have negligible affect on the server - queries that return a small amount of rows, or queries on tables with few indices.However, when your application becomes heavily data-dependant and complex then moving those queries to the
Stored procedures are NOT pre-compiled. This is a common made mistake.
Only the execution plan gets cached, but the stored procedure is
compiled upon execution.
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 ALAmersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort
--
- Original Message -
From: Micha Schopman [EMAIL PROTECTED]
Date: Thu, 26 Aug 2004 12:53:28 +0200
Subject: RE: stored procedures
To: CF-Talk [EMAIL PROTECTED]
Stored procedures are NOT pre-compiled. This is a common made mistake.
Only the execution plan gets cached, but the stored procedure
WWW: http://www.euservices.com/ http://www.euservices.com
__
-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 6:53 AM
To: CF-Talk
Subject: RE: stored procedures
Stored procedures
hey this might sound lame to some of you that use stored
procedures and i apologize, but what is the point or what
is the benefit rather?
from what i have read so far i havent seen a point, but
maybe i just dont understand the concept completely. whats
hard about saying cfquery.../
-
From: Bill Grover [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 13:53
To: CF-Talk
Subject: RE: stored procedures
True, but coming up with the execution plan is what takes the longest and
has the greatest impact on the server.So by having a SP once it is
executed and that execution plan is cached
Within SQL Server the execution plan is only re-generated on request
when the stored procedure contains statements which dynamically change
the stored procedure. Input and output parameters, have no effect on the
execution plan, they are pre-cached also even if they are not used.
I have increased
Subject: RE: stored procedures
That is where the benefit of SP's are, that once run all future runs are
significantly faster.
I think that this isn't always true. It depends what statements are within
the SP. It's possible that an SP could produce various execution plans and
the one that's cached might
And then there's also the fact that
stored procedures are immune to SQL injection attacks.
One sidenote, it is possible to use SQL Injection attacks on SQL Server
while still using stored procedures. For example using Full Text
Indexing commands, it is fairly simple to provide a SQL injection
Message -
From: Adrian Lynch [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 9:44 AM
Subject: RE: stored procedures
That is where the benefit of SP's are, that once run all future runs are
significantly faster.
I think that this isn't always true. It depends
Okay... without going out of your way to provide a means of creating
sql injection attacks. :P Seven years doing this work, I've only ever
heard of one person actually using SQL Server's full-text indexes (and
that was someone I wasn't working with)... doesn't mean that people
aren't, but my
Input and output parameters, have no effect on the
execution plan
Actually, they often have a *huge* impact on how a query execution plan is
compiled.My earlier post on this explains it a little.
Respectfully,
Adam Phillip Churvis
Member of Team Macromedia
Advanced Intensive Training:
* C#
Subject: RE: stored procedures
To: CF-Talk [EMAIL PROTECTED]
Stored procedures are NOT pre-compiled. This is a common made mistake.
Only the execution plan gets cached, but the stored procedure is
compiled upon execution.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
As far as I know this was only the case with versions before SQL Server
2000, not with 2000, but the DBA here is gonna do some testing with it.
I am curious if this is still the case.
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 ALAmersfoort
Tel 033-4535377, Fax
Janet Schmitt wrote:
In Oracle, stored procedures are compiled when you create them (i.e. run
the CREATE PROCEDURE/FUNCTION/PACKAGE/TRIGGER statement). The first time
you call an Oracle Stored Procedure it is loaded into Oracle's memory
(shared pool of the SGA).The stored procedure will
try adding a size to the varchar
CREATE PROC GetMessages
@fromid int,
@toid int,
@searchtext varchar(100)
should work
HTH
-Original Message-
From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 10:25
To: CF-Talk
Subject: Stored Procedures
I am
: Stored Procedures
try adding a size to the varchar
CREATE PROC GetMessages
@fromid int,
@toid int,
@searchtext varchar(100)
should work
HTH
-Original Message-
From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 10:25
To: CF-Talk
Subject: Stored
You are missing sinle quotes after the like I think. Use what you did
first.
-Original Message-
From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED]
Sent: vrijdag 20 februari 2004 11:57
To: CF-Talk
Subject: Re: [cftalk] RE: Stored Procedures
I have simplified
: [cftalk] RE: Stored Procedures
try adding a size to the varchar
CREATE PROC GetMessages
@fromid int,
@toid int,
@searchtext varchar(100)
should work
HTH
-Original Message-
From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 10:25
To: CF-Talk
Subject
Subject: Re: [cftalk] RE: Stored Procedures
I have simplified this to:
But get error [Macromedia][SQLServer JDBC Driver][SQLServer]Line
1: Incorrect syntax near 'a'.
Any more help please?
Allan
--
CREATE PROC GetMessages2
@searchtext
IF @searchtext ''
SET @query = @query +' AND M.Message LIKE '''+ '%' + @searchtext + '%'''
was the solution. Single Quotes Only.
Thanks
Allan
- Original Message -
From: Mike Townend
To: CF-Talk
Sent: Friday, February 20, 2004 12:03 PM
Subject: RE: [cftalk] RE: Stored Procedures
I'm not sure there is much point in using a stored proc
to build a SQL string and execute it, you'll get no
speed/efficiency benefit at all, in fact it will probably
be slower.
This is true, but if you use stored procedures exclusively for all database
access, you may be able to tighten
Try this..
--
CREATE PROCEDURE dbo.Q_CheckItem
@Items_id int
AS
SELECT card FROM Items WHERE Items_id = @Items_id
--
cfstoredproc procedure=Q_CheckItem datasource=#dsn#
password=#password# username=#username# returncode=Yes
cfprocparam type=In
Thanks Craig
I missed using the resultset.
I went to school in Surrey many years back.
Jack
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 6:49 AM
To: CF-Talk
Subject: RE: Stored Procedures problem
Try this..
--
CREATE
There are some on my server:
http://exciteworks.com/ec/sql.cfm
Josh Trefethen
http://exciteworks.com
Quoting James Johnson [EMAIL PROTECTED]:
Hi,
Can anyone point in the direction of some tutorials on Creating Stored
Procedures and Triggers in SQL Server?
TIA
We are using CF 5.0 to call stored procedures in mainframe
DB2.
...
This works fine except that under load we get abends on the
stored procedure unless we turn off the 'stay resident'
parameter in DB2 that keeps the stored procedure code
resident in memory. Of course this affects
I don't see why this would make any difference at all,
since the closing CFTRANSACTION tag marks the end of
the transaction,
Yes, we agree. Apparently this is not enough, though.
According to our IBM contact we need additional housekeeping
beyond what happens with CFTRANSACTION. We
(without pdf conversion all show up correctly)
wouldn't this indicate that the problem is NOT in the stored proc??
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
I'm converting a whack load of common queries to stored
procedures right now and I have started getting an error
whining about trying to open a datasource that is already
open.
The situation is that in some of my cftransaction blocks
I have a mix of included queries and included
MS-SQL Stored procedures are stored with their 'compiled' execution plan. If
you issue a query from an application, SQL Server has to determine the
execution plan before running ... determine which indices there are and which
one(s) would be the best to use. So if you use SPs you could gain
I agree with this in most cases. However it is not currently possible to cache
oracle stored procs in cf (except by assigning the results to session or
application variables). Also on most simple selects I found that the time for
processing was faster using embedded cf queries that calling a
If you are concerned about performance, converting cfquery's to stored
procedures is the best way to optimize an application. Even for selects.
jon
Stephen Hait wrote:
I've been wondering about using stored
procedures in templates instead of
embedding queries. Is there a good reason
for
Jon, thanks for your response.
Stephen
If you are concerned about performance, converting cfquery's to
stored procedures is the best way to optimize an application. Even
for selects.
jon
Stephen Hait wrote:
I've been wondering about using stored
procedures in templates instead of
Inside SQL Server 2000; Microsoft Press is a great reference with 'beyond
basic' material. You really need to master database skills to be a great
developer, so it's not too far off topic!
Here's a simple SELECT stored procedure; and how it's called in CF. I don't
use the CF stored procedure
On 8/1/01, Dave Watts penned:
Sounds like you may be confusing Stored Procedures, which can't be
done in Access (actually, you can save a query in Access and call it
using cfstoredproc, but I don't believe you can pass variables to
it), with Scheduled Tasks.
You can pass parameters to
On 8/1/01, Bruce, Rodney penned:
I have created a page of all the queries and have tried to add it to
the CF Administrator Scheduled tasks. But when I try to run it, CF admin
gives me a long list of possible reasons it can't run the task, all
dealing with URL. it can't be resolved, needs the
]]
Sent: Wednesday, August 01, 2001 3:54 PM
To: CF-Talk
Subject: Re: Stored Procedures
On 8/1/01, Bruce, Rodney penned:
I am using ACCESS, NT and IIS. I am trying to run a set of queries
as a stored procedure.
I have created a page of all the queries and have tried to add it to
the CF
On 8/1/01, Bruce, Rodney penned:
I am using ACCESS, NT and IIS. I am trying to run a set of queries
as a stored procedure.
I have created a page of all the queries and have tried to add it to
the CF Administrator Scheduled tasks. But when I try to run it, CF admin
gives me a long
Sounds like you may be confusing Stored Procedures, which can't be
done in Access (actually, you can save a query in Access and call it
using cfstoredproc, but I don't believe you can pass variables to
it), with Scheduled Tasks.
You can pass parameters to Access parameter queries with
yup
In theory you can run any SQL statement in CF. you can run multiple
statements by separating them with a semi colon.
to test if an SP exists the SQL code is:
IF EXISTS (SELECT * FROM sysobjects WHERE name = spname AND type = P)
BEGIN
-- do whatever here
ELSE
BEGIN
]]
Sent: Monday, 16 July 2001 9:37 PM
To: CF-Talk
Subject: RE: Stored Procedures
yup
In theory you can run any SQL statement in CF. you can run multiple
statements by separating them with a semi colon.
to test if an SP exists the SQL code is:
IF EXISTS (SELECT * FROM sysobjects WHERE
:09
To: CF-Talk
Subject: RE: Stored Procedures
So you are saying I could do this then
cfquery name=sp_Adduser datasource=datasource
IF not EXISTS (SELECT * FROM sysobjects WHERE name =
sp_Adduser1 AND type = P)
CREATE PROCEDURE sp_AddUser
@username varchar(50
: RE: Stored Procedures
Never tried it, you may have to put semi colons at the end of every
sql
statement if ODBC terms them as separate SQL stements. I would
suggest that
you write and call an SP that creates SP's for you.
-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED
this is not simple and certainly
challenging if you are only starting out with SP's!
-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: 16 July 2001 14:26
To: CF-Talk
Subject: RE: Stored Procedures
Which is what I am looking for, if it doesn't exist to create it... I am
new
1 - 100 of 152 matches
Mail list logo