In the <cfprocresult> tag, is the name attribute the name of the column you
want to display? In other words do I need one for each of the 6
columns(Name, Detaildata, Status, Time, Logon_name0, SMSID0) I will be
displaying?
<cfstoredproc procedure="Michael" datasource="#Datasource#"
username="#def_SQLNamehistory#" password="#def_SQLpasshistory#">
<cfprocparam Type="In"
DBVARNAME="@JOBID"
VALUE="#Form.jobID#"
CFSQLTYPE="cf_sql_varchar">
<cfprocresult name="Name0">
</cfstoredproc>
</cfoutput>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Clint Tredway
Sent: Friday, March 30, 2001 8:28 PM
To: [EMAIL PROTECTED]
Subject: RE: Stored Procedure Result sets and OLEDB DSNs
The first thing I see is this:
I took the single quotes out aroung @JobID in your where statement
create procedure Michael @JOBID varchar (30) AS
SELECT T1.DetailData, T1.Time, T2.LogOn_Name0, T2.Name0, T1.Status,
T2.SMSID0
FROM dbo.JobDetails as T1,dbo.Identification as T2
WHERE T1.JobID = @JOBID
AND (T1.DetailData = (T2.Domain0 + char(124) + T2.SMSID0))
ORDER BY Status, Name0, LogOn_Name0, Time
I will bet that was causing your problem. Inside your stored procedure, you
do not need single quotes around parameters because you tell the db when you
declare the parameter what type it is.
Try that.
--
Clint Tredway
www.factorxsoftware.com
--
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
