Interesting arguments on "parametric query" and stored procedure's use with CF. Imho, the facts of the app itself, the developer's "comfortness" with tools at hand and the environment would be taken into consideration as well.
I'll address the "specific" of the second query here,
two points here:
job done, once you start
getting to complex
application development... cfQuery and SQL all over the application is
Messy.
Joe Eugene
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]
Sent: Friday, October 08, 2004 3:50 PM
To: CF-Talk
Subject: RE: SQL stored procedure
Stored procedures don't work the way you are expecting them to work, and you are discovering. When you're using cfquery you can use cf variables and cf logic to build a sql statement, and when the statement is all built it goes to the sql server (or access, or whatever) and then it's run. That mea
Jeff,
Not every query or block of code is a good choice for a stored procedure.
Stored procedures are only ONE reason to move off of access. The first query
is not working because of a datatype mismatch but it's not obvious where it
resides from just looking at the query (which looks fine). As for
Peter & Nick...
You da'Man! Thanks a ton, worked perfectly...
John
-Original Message-
From: Peter Stolz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 5:09 PM
To: CF-Talk
Subject: RE: SQL Stored Procedure Question...
Try:
CREATE PROCEDURE GetContacts @alpha
This is a multi-part message in MIME format.
--B9336A7DD898E0D1B5936117
Content-Type: multipart/alternative;
boundary="778FA7AB3A393FFA7903E735"
--778FA7AB3A393FFA7903E735
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854";
x-mac-creator="4D4F
Try:
CREATE PROCEDURE GetContacts @alpha varchar(1) AS
SELECT Contacts_Main.company
FROM Contacts_Main
WHERE (Contacts_Main.company LIKE @alpha + '%')
ORDER BY Contacts_Main.company
P
-Original Message-
From: Top-Link Tech (John Ceci) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, Septembe
LIKE @alpha + '%'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 2:36 PM
To: CF-Talk
Subject: SQL Stored Procedure Question...
Hey All,
Got a quick one for all of you...
I am implementing a stored procedure and I cant seem to g
8 matches
Mail list logo