"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 tag, I usually write my query first in my CF
page; and later on convert it to a sp. I then leave my CF code alone, but
replace the SQL with the sp call.
qry.cfm---------------
<cfquery datasource="myDs" name="test">
myStoredProcedure
@var1='test',
@var2=5
</cfquery>
-----------------------
In SQL Query manager:
----------------------
CREATE PROC myStoredProcedure
@var1 varchar(10),
@var2 int
AS
SELECT *
FROM testTable
WHERE condition = @var1
AND other = @var2
GO
-----------------
That's REAL basic, so get a book and you'll be flyin' in no time!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
