> Thanx Dave!
You're welcome!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or on
Thanx Dave!
On Sun, Aug 8, 2010 at 9:16 PM, Dave Watts wrote:
> In SQL Server, anything beginning with "sp_" are stored procedures
> built into SQL Server. So, the driver invokes those SPs to create and
> invoke a new temporary SP. Temporary objects (including these SPs) are
> tied to the conne
> So does the driver just call that API on the DB and the procs are
> created inside the DB? What causes the procs to go away later? (I
> assume they're GC'd at some point otherwise you'd end up with millions
> of them in the DB :)
In SQL Server, anything beginning with "sp_" are stored procedure
On Sun, Aug 8, 2010 at 9:06 PM, Dave Watts wrote:
> Yes, the SQL Server JDBC drivers from both DataDirect and MS do this.
> You can prove this for yourself by looking at traffic with SQL
> Profiler in SQL Server. You'll see an initial call to sp_prepareexec
> followed by subsequent calls to sp_ex
I love this freakin' mailing list. I get smart just by asking questions.
;)
G!
On Mon, Aug 9, 2010 at 12:06 AM, Dave Watts wrote:
>
> > > Most people don't realize that when you send a parameterized query
> > > using cfquery to SQL Server, what happens behind the scenes is that
> > > ColdFusio
> > Most people don't realize that when you send a parameterized query
> > using cfquery to SQL Server, what happens behind the scenes is that
> > ColdFusion creates a temporary stored procedure on the server, then
> > executes that temporary stored procedure.
>
> Er, can you provide proof of that
On Sun, Aug 8, 2010 at 7:47 PM, Mike Chabot wrote:
> Most people don't realize that when you send a parameterized query
> using cfquery to SQL Server, what happens behind the scenes is that
> ColdFusion creates a temporary stored procedure on the server, then
> executes that temporary stored proc
> Does CF create that temporary stored procedure every time a single CFQuery
> is called? It seems like a bit of extra overhead.
No, these procedures are cached by the connection, so if someone else
has run the same query earlier the procedure will be pulled from
cache.
Dave Watts, CTO, Fig Lea
>>ColdFusion creates a temporary stored procedure on the server, then
executes that temporary stored procedure.
Does CF create that temporary stored procedure every time a single CFQuery
is called? It seems like a bit of extra overhead.
Curious,
G!
On Sun, Aug 8, 2010 at 10:47 PM, Mike Chabot
I wouldn't say that ORM systems have an "obvious advantage" in every
situation. There are plenty of good reasons to use stored procedures
that have nothing to do with efficiency. ORM systems and stored
procedures are not mutually exclusive. Many ORM systems allow you to
use stored procedures.
If
Thanks for all the replies, I'll have to consider my options now. He seems to
have taken this stubborn stance, at least I know what to get back at him with.
Thanks,
Matt
~|
Order the Adobe Coldfusion Anthology now!
http://www
On Sat, Aug 7, 2010 at 7:51 AM, Matthew Allen wrote:
> He has one valid reason in that we have one or two (not the majority of)
> applications having the need to access data from different platforms (.NET,
> PHP and CF).
You could create a simple REST API from CFML to expose the data those
app
ORM makes your App DB-independent. Stored procs make your DB app-independent.
If you have multiple apps platforms all needing to use the same data
logic in a common DB that won't change, it makes sense to use stored
procedures. If you have an app that you need to deploy out in the wild
against mu
No, inefficiency is not a solid argument. All 3 have their uses.
My experience has been that DBA = dislike ORM because they lose some
control. And since he's in charge
- Gabriel
On Sat, Aug 7, 2010 at 10:51 AM, Matthew Allen wrote:
>
> This is rather annoying, the software development mana
Double-execution of CFML code can happen when people close their
custom tags with a trailing slash, not realizing that the closing
slash causes a second-run of the custom tag. Most commonly
double-execution happens when users double-click submit buttons or
when a user gets frustrated at a slow pag
Firstly, install MS Fiddler and examine the HTTP requests being sent
from your browser when you click whatever button or link loads the
processing page.
All too many times I have seen a form with a submit button AND a
JavaScript onclick that are working together to submit the form more
than once.
On Wed, Jan 13, 2010 at 5:58 PM, Ali Awan wrote:
> And if that is true, then how come ColdFusion handles it differently when I
> pull that CF page out of that app, and run it by itself?
If that's the case, you know that it's not ColdFusion itself causing the error.
I don't think queries are var
Brad,
Thanks for the helpful suggestions.
In terms of numbers of inserts, well it's an insert statement within a cursor
loop.
There's 305 records being added so it loops 305 times and does an insert.
As I mentioned in my last post.
When I take my execution page out of the pseudo-fusebox app a
default behavior is to continue execution after an error and unless you
are using transactions properly some of the statements might be running
fine, while others are erroring.
~Brad
Original Message ----
Subject: Re: Stored Procedure throwing error in CF but ran successfully
From:
>The best way to troubleshoot this issue if it is reproducible is to
>start a SQL Server Profiler trace to observe exactly what the database
>is doing.
>-Mike Chabot
>
>
>> Mike, I am trying this at work and do not have the admin privileges to run
>> the SQL Server Profiler.
Another interesting
Mike,
Thanks for responding.
Another thing I forgot to mention is that when I run the procedure in SQL
Server directly it runs without error.
Also, and this is sporadic.
When I run the stored proc in coldfusion by itself, by doing an Exec statment
in a CFQuery. Sometimes it runs without erro
The best way to troubleshoot this issue if it is reproducible is to
start a SQL Server Profiler trace to observe exactly what the database
is doing.
Maybe the CF code is running twice, the first is working and the
second is failing.
-Mike Chabot
On Wed, Jan 13, 2010 at 2:40 PM, Ali Awan wrote:
Named parameters didn't work in CF7. There was a Hotfix that made them
work but I don't think it was ever part of the 7.0.1 or 7.0.2 release.
I don't know if it made it into CF 8 or not.
Chances are ColdFusion was defaulting to the usual practice of going off
the order of the proc param tags.
F
On Tue, Jul 1, 2008 at 2:55 PM, Brad Wood <[EMAIL PROTECTED]> wrote:
> Hmm, right off the bat, I don't think the browser would make any
> difference unless you have ColdFusion code that behaves differently
> depending on the browser. Perhaps something is being cached.
I cleared out the cache and
Hmm, right off the bat, I don't think the browser would make any
difference unless you have ColdFusion code that behaves differently
depending on the browser. Perhaps something is being cached.
Since getdate is the name of a function, maybe you should call your proc
something else.
Regardless, i
s."
Visit our website at http://www.reedexpo.com
-Original Message-
From: Dan G. Switzer, II
To: CF-Talk
Sent: Thu Nov 02 23:00:21 2006
Subject: RE: Stored Procedure oddity
>> if you look at the above code you'll see that the CFPROCPARAM
>> is missing the DBVARNAME pa
>> if you look at the above code you'll see that the CFPROCPARAM
>> is missing the DBVARNAME parameter. I don't know how it got
>> passed the CFDebugger into our production environment but it did.
>
>It's been a while since I've had to worry about CF 5, but I don't think
>that
>the DBVARNAME attrib
As far as my experience calling MS SQL 2000 stored procs, the order of
the inputs is all that matters-- the name I provide in the ColdFusion
call is completely arbitrary.
This could really screw things up when a DB person added a new input to
an existing proc in the middle of the parameter list wi
> Ben's book for CFMX6.0 says that DBVARNAME is required for
> supporting named notation.
>
> the variable @user_id is named in the stored procedure.
Just because it's named in the stored procedure doesn't mean that you have
to (or can) use named notation to invoke the stored procedure. I don't
CF-Talk
cc: (bcc: Scott A. Stewart/REAC/HHQ/HUD)
Subject: RE: Stored Procedure oddity
> I'm trying to fix an existing app in CF5.0
>
> if you look at the above code you'll see that the CFPROCPARAM
> is missing the DBVARNAME parameter. I do
> I'm trying to fix an existing app in CF5.0
>
> if you look at the above code you'll see that the CFPROCPARAM
> is missing the DBVARNAME parameter. I don't know how it got
> passed the CFDebugger into our production environment but it did.
It's been a while since I've had to worry about CF 5,
lk
Subject: Re: Stored Procedure Cached
Its Hostmysite.com's server so no.
On 10/4/06, Christine Davis <[EMAIL PROTECTED]> wrote:
>
> Connection Pooling in the Datasource generally returns that error when
> it expects a different column total. Can you turn off connection
Its Hostmysite.com's server so no.
On 10/4/06, Christine Davis <[EMAIL PROTECTED]> wrote:
>
> Connection Pooling in the Datasource generally returns that error when
> it expects a different column total. Can you turn off connection
> pooling for that Datasource?
>
> Thanks!
> Christine Davis
>
Connection Pooling in the Datasource generally returns that error when
it expects a different column total. Can you turn off connection
pooling for that Datasource?
Thanks!
Christine Davis
ColdFusion Lead
Nations Technical Services
Prairie Village, KS
913-748-8044 ext 4703
[EMAIL PROTECTED]
---
I don't know about oddball stuff for sure. To quote someone famous, "It
depends."
The best bet is to find where it will fit and where it relates in your data
model and stick it into those generated data objects. As a last resort,
there's nothing really stopping you from making an oddball database
Ok thanks for the advice,
however I have several multi-batch stored procedures that is used in
Fabrication software. Table relationships are all over the place. Can Reactor
utilize general purpose, oddball, misc, super cfc's for the data layer? I guess
I can place them in any of the autogenera
David,
Depending on what the stored proc does, there are a number of things you
could do.
Probably the best way to keep it in the reactor framework, is to find the
generated gateway, record, or whatever, and add a method right there.
For instance, if you have a stored procedure that creates an o
Is this a comma delimited list, or an xml document.
I use xml a lot when I want to pass in a variable length list of items
to change. Very handy MS SQl's XML functionality.
~Brad
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 11:41 AM
To:
Not sure if this works, I grabbed it from a bunch of snippets I have.
DECLARE @list VARCHAR(100), @loop BIT, @item INT
SET @list = '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15'
SET @loop = 1
WHILE @loop = 1 BEGIN
-- If we can't find the delimiter the last element is all that's left of
the list
If you want to pass comma separated IDs to a stored procedure then
use it in WHERE clause:
CREATE PROCEDURE dbo.getCountryNames
@inputIDs varchar(255)
AS
SELECT countryname FROM Countries
WHERE countryID in (@inputIDs)
GO
If you need to loop through a query inside a stored procedure, use
cursors.
Why not make a new SELECT statement in the countries table and put a
WHERE country_id IN (the list)?
Where "the list" is te 6,7,8, etc
Good luck!
Fabio Terracini
Protoculture wrote:
>I'm new to stored procedures ( in MS SQL ) and need help with the following
>query...
>
>Essentially what m
> so what I need to do in MSSQL is perform a query to grab that list of comma
> seperated
> numbers, put those numbers into an array OR a list and then loop over that
> array/list
> and and return the results ( which is a list of country names ).
What you're going to need to investigate to do
.
> D
> -Original Message-
> From: Al Everett [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 07, 2005 8:47 AM
> To: CF-Talk
> Subject: Re: Stored procedure error
> I've always found that error to be thrown by Oracle when
> it can't tell
> you wha
-
From: Al Everett [mailto:[EMAIL PROTECTED]
Sent: Monday, February 07, 2005 8:47 AM
To: CF-Talk
Subject: Re: Stored procedure error
I've always found that error to be thrown by Oracle when it can't tell
you what the error is. It is singularly unhelpful.
I would start with your pr
I've always found that error to be thrown by Oracle when it can't tell
you what the error is. It is singularly unhelpful.
I would start with your proc. Run it outside of CF to see if you get a
better error message.
On Sun, 6 Feb 2005 22:38:25 -0500, Doug Hyde <[EMAIL PROTECTED]> wrote:
> Anybody
Yes, but how does one go about creating a materialized view on SQL Server?
I've heard of it being done all the time in Oracle contexts, but I've
not heard a lot about it in the MS SQL Server world.
Incidentally, if you want to run ad-hoc queryies and still want the
performance of an Sproc, there'
Here is the skinny. A stored procedure is faster than an inline query
because it is precompiled on the database and most databases make
'plans' on the fastest way to execute the query.
A view is compiled as well. However when you query a view it executes
the view's sql then it executes your sql on
Will,
I believe that Stored Procs are more efficient since SQL will create
execution plans for them, while for views, they have to be created for each
execution.
Andy
-Original Message-
From: Will Tomlinson s
With everyone's help I'm pretty much wrapping up the functionality of my
cloth
Of course it can be done in Oracle.
You can have multiple recorders produced from one procedure.
Here's the equivalent in pl/sql for the example below:
snippet
create or replace procedure test(
p_username in varchar2,
p_password in varchar2
)
is
v_user_idnumber;
select user_id
i
On Wed, 2004-03-24 at 11:23, Burns, John D wrote:
> I've done simple stored procedures before to "increase performance"
> (which I already heard today doesn't necessarily do that) but I'm
> wanting to get into using SQL stored procedures for more in depth stuff.
> One thing I'm not sure on how it w
You can use a subselect and do it with a single query. I'm not 100% this
syntax (don't use SQL Server) is correct, but it's close:
select somethingelse
from anothertable
where userID = (
select userID
from users
where username = '#form.username#' and password = '#form.password#'
)
> -O
Shouldn't it be
CREATE PROCEDURE update_image_status_y
@image_id INT
AS
UPDATE images
SET image_document_head = 'y'
WHERE id = @image_id
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
Sent: maandag 17 november 2003 17:40
To: CF-Talk
Subject: Stored PROCEDURE syntax
THis i what
you are missing an AS after the name of your new procedure if you are using SQL.
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 10:40 AM
To: CF-Talk
Subject: Stored PROCEDURE syntax
THis i what i have
CREATE PROCEDURE update_image_status_y
(
@imag
Is images a reserved word in SQL?
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
Sent: 17 November 2003 16:40
To: CF-Talk
Subject: Stored PROCEDURE syntax
THis i what i have
CREATE PROCEDURE update_image_status_y
(
@image_id INT
)
UPDATE images
SET image_document_head = 'y'
WH
> THis i what i have
>
> CREATE PROCEDURE update_image_status_y
> (
> @image_id INT
> )
>
> UPDATE images
> SET image_document_head = 'y'
> WHERE id = @image_id
>
>
> But i get a "Incorrect SYntax near the keyword UPDATE" what's up?!
You left out the word "AS":
CREATE PROCEDURE procedure_na
INNER JOIN aesdocs.dbo.addresses a ON t.originalID = a.originalID
WHERE t.exactDistance <= @radius
GO
-Original Message-
From: Reece, Cynthia [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 1:51 PM
To: CF-Talk
Subject: RE: stored procedure doesn't return anything
SET NOCOUNT ON for the first select?
-Original Message-
From: Reece, Cynthia [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 1:51 PM
To: CF-Talk
Subject: RE: stored procedure doesn't return anything
Hello,
I am trying to run a stored procedure from coldfusion and r
Hello,
I am trying to run a stored procedure from coldfusion and return the
results. When i run the query in the query analyzer giving it the expected
data is works fine, but my coldfusion page says that there were no results.
I am attatching the procedure and the coldfusion code. Any suggestion
Can you call stored procedures inside a cfscript tag? I thought those
operations had to be outside a cfscript tag...
-Original Message-
From: Wjatscheslaw KRAVTCHENKO
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 12:12 PM
To: CF-Talk
Subject: Stored Procedure not found
Hi a
Input and output paramters belong before the "AS" statement... You're
declaring a local variable in your SP, not a parameter.
CREATE PROCEDURE sp_CheckUser
@UserName VARCHAR(50)
AS
- Original Message -
From: "Stan Winchester" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent:
-
>> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, September 26, 2002 2:45 PM
>> To: CF-Talk
>> Subject: RE: Stored procedure error
>>
>> I'm guessing this sp was working in MX 2 days ago and so
>> you're ruling
> out
&
it would work, and if it was false it would through the error.
I should have looked closer before posting.
> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 26, 2002 2:45 PM
> To: CF-Talk
> Subject: RE: Stored procedure
I'm guessing this sp was working in MX 2 days ago and so you're ruling out
an upgrade as being the reason for it's not working?
In CF 5 you would get this error if you left out a parameter prior to
@ccAuthCode expecting the db to be able to use the default value defined in
the stored procedure --
Chad,
Post code and the declaritive part of the SP. That might
help a bit more.
-mk
-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 11:33 AM
To: CF-Talk
Subject: Stored procedure error
Error Executing Database Query.
[Macromedia][SQLServer
Are you supplying the variables in the right order?
Your queryparams need to be in the same order as they are declared in the
SP.
Ade
-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2002 17:33
To: CF-Talk
Subject: Stored procedure error
Error Executing Datab
You guys sure it isn't @@rowcount?
Neil
- Original Message -
From: "Costas Piliotis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 08, 2002 8:50 PM
Subject: RE: Stored Procedure recordset.
> I think what you'
Oops, replace(myPost, 'java', 'javascript') :)
--
jon
mailto:[EMAIL PROTECTED]
Thursday, August 8, 2002, 8:55:59 PM, you wrote:
jh> IF EXISTS ( Select Foo FROM Bar Where Whatever = 1)
jh>-- result set returned
jh>BEGIN
jh>-- BEGIN is equiv to java { end is like java }
jh>END
IF EXISTS ( Select Foo FROM Bar Where Whatever = 1)
-- result set returned
BEGIN
-- BEGIN is equiv to java { end is like java }
END
ELSE
-- no results returned
BEGIN
END
--
jon
mailto:[EMAIL PROTECTED]
Thursday, August 8, 2002, 8:38:05 PM, you wrote:
NH> I want to do so
I think what you're looking for is @@recordcount that outputs the records
affected...
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 08, 2002 5:38 PM
To: CF-Talk
Subject: Stored Procedure recordset.
I want to do something in TSQL if results are return
a
varchar and let SQL do the work.
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 01 July 2002 10:30
To: CF-Talk
Subject: RE: Stored procedure problem
Would trying to put an empty string into the agendatime cause any problems?
-Original Message-
From: ang
Would trying to put an empty string into the agendatime cause any problems?
-Original Message-
From: angela alston [mailto:[EMAIL PROTECTED]]
Sent: 29 June 2002 05:08
To: CF-Talk
Subject: Re: Stored procedure problem
Thanks Joshua.
I ran the proc in the analyzer as you suggested &
I made a stored procedure that works great in the query analyzer. I do a
simple call to it with CF and it works fine. When I put it in a cfoutput
with the query defined I get 0 records back from the DB.
Thanks.
Here is some of the code
select id from dealers
where region = 'B
Phillip
Yes and yes... however, like hitting queries within a loop, you should be
careful or you will have a process that is slow and resource intensive - and
therefore not maintainable in the long run. As far as the cfoutput
query=""... that's no problem - except if you subsequently try to do a
> Can you call to a stored procedure in a cfloop and
have it work right?
Yes, as long as the procedure is called by cfquery or
cfstoredproc tag.
> Can you call to a stored procedure in a cfoutput with
the query named
> defined and have it work right?
Yes, as long as the procedure is called by
That kinda sucks!
Thanks alot for your input Mark.
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 2:29 PM
Subject: RE: Stored Procedure Problem
> Frank,
>
>
Frank,
Here's my experience:
You must pass the parameters in the same order as they are declared in SQL.
The named parameter feature (as I understand it) applies to Oracle - I also
believe it to be deprecated in CFMX. The parameters must be in the same
order - If you are assigning default value
Is it a comma delimited List??? if not, then have you specified the
delimiter? (I've been guilty of that once or twice...)
Shawn
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 1:55 PM
To: CF-Talk
Subject: RE: stored procedure with c
Thanks- I do have the "#ListGetAt(Grade, X)#"- I'll keep looking- I'm sure
it's something small...Friday afternoon-can't concentrate.
-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 4:00 PM
To: CF-Talk
Subject: RE
al Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 1:42 PM
To: CF-Talk
Subject: RE: stored procedure with cfloop?
Ok I'll look again at those, but I was pretty confident they were correct.
I was half wondering if I was accidentally trying to save the who
nt: Friday, May 24, 2002 3:40 PM
To: CF-Talk
Subject: RE: stored procedure with cfloop?
you want to do a loop IN the stored procedure? or call a stored proc
multiple times within a CFLoop?
If the latter, then yes, it's possible.
If the previous, then yes, you can do loops, but the routin
you want to do a loop IN the stored procedure? or call a stored proc
multiple times within a CFLoop?
If the latter, then yes, it's possible.
If the previous, then yes, you can do loops, but the routines are a little
different, and if you are looping over a recordset, then you need a cursor.
As
Try renaming your stored proc input parameter
CategoryJobDescrID to something else so it doesn't
have the same name as a database column.
--- Greg Jordan <[EMAIL PROTECTED]> wrote:
=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
___
T statement.
Regards
Stephen
- Original Message -
From: "Greg Jordan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 4:29 PM
Subject: RE: stored procedure - Ambiguous column name
> the def
!
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:18 AM
To: CF-Talk
Subject: Re: stored procedure - Ambiguous column name
Greg,
categoryJobDescrID is in both you categoryJobDescr and categoryJobListing
table.
The
no
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:21 AM
To: CF-Talk
Subject: RE: stored procedure - Ambiguous column name
> i've been trying to work this out for about a week and i
> am stumped. i keep getting an error re
Greg,
This error usually indicates a failure to properly alias during a join -
where the driver can't figure out which table to pull "jobdescId" from.
Mark
-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 9:42 AM
To: CF-Talk
Subject: stored
> i've been trying to work this out for about a week and i
> am stumped. i keep getting an error related to an ambiguous
> column name. I've checked the sp over and over (with my
> admittedly sub-par sql skills) and cannot find anything
> wrong. i've included the error and the sp below. any hel
Greg,
categoryJobDescrID is in both you categoryJobDescr and categoryJobListing
table.
The procedure looks ok, so I can only assume that you are passing through
categoryJobDescrID as one of the fields in @orderby without a tablename
prefix.
Regards
Stephen
- Original Message -
From: "G
methods to automate the insert statements.
HTH,
Chris
--
Original Message
From: ""<[EMAIL PROTECTED]>
Subject: RE: Stored Procedure problem (was Stored Process)
Date: Tue, 16 Apr 2002 16:22:41 +0100
>Try using execute(@thestatemen
Try using execute(@thestatement)
-Original Message-
From: Ryan Edgar [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 15:31
To: CF-Talk
Subject: RE:Stored Procedure problem (was Stored Process)
I am working alongside Jerry on this and we are still running into
problems.
The Stored Proc is
check everywhere a datatype is declared, DB, CF stored proc, the SP..
it's usually somewhere, just check the lot
-Original Message-
From: Ryan Edgar [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 15:31
To: CF-Talk
Subject: RE:Stored Procedure problem (was Stored Process)
I am worki
Reading this article might help in your situation :
http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp#Owners
hip
Unfortunately you need to register at this site to read the article :(
Jared Clinton
NEC Australia
-Original Message-
From: Matt Kornguth [mailto:[EMAIL P
Yes - the ording problem is a function of the RDBMS (according to the
documentation for Cfstoredproc).
-Original Message-
From: Rosa, Issac [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 6:55 AM
To: CF-Talk
Subject: RE: Stored Procedure Variables from CF
How about when
redith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 3:39 AM
To: CF-Talk
Subject: Re: Stored Procedure Variables from CF
THANKYOU for raising this issue... just playing with cfstoredproc and
couldn't understand why I was getting strange results
now I know why.
(this is definit
THANKYOU for raising this issue... just playing with cfstoredproc and
couldn't understand why I was getting strange results
now I know why.
(this is definitely something which is an exception to usual CF
behaviour)
"Rosa, Issac" wrote:
>
> When passing variables from ColdFusion to a MSSQL sto
;)
chill Tomo, chill.
> -Original Message-
> From: Tomo Smith [mailto:[EMAIL PROTECTED]]
> Sent: 18 March 2002 16:04
> To: CF-Talk
> Subject: Re: Stored Procedure Variables from CF
>
>
> read the question wrong then... damn you.
> - Original Messa
read the question wrong then... damn you.
- Original Message -
From: "Rich Wild" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 3:47 PM
Subject: RE: Stored Procedure Variables from CF
> thats not true Tomo.
>
&g
I could be wrong about that though
- Original Message -
From: "Tomo Smith" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 3:37 PM
Subject: Re: Stored Procedure Variables from CF
> no, not if you specify the vari
thats not true Tomo.
even if you specify the names, CF uses the order you declare them in. CF4.5
& CF5.
we're talking about in a call here
> -Original Message-
> From: Tomo Smith [mailto:[EMAIL PROTECTED]]
> Sent: 18 March 2002 15:37
> To: CF-Talk
> Subje
no, not if you specify the variable names. eg:
sp @test='test', @test2='test2'
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 3:11 PM
Subject: RE: Stored Procedure Variables
1 - 100 of 183 matches
Mail list logo
