Hi Guys!
Can anybody figure out why this stored procedure is converting my varchar to
"2"? Write your own <CFSET> for the datasource variable MyDSN and run this:
<CFSET DateTimeVarChar="#DateFormat(Now(), 'yyyy-mm-dd')# #TimeFormat(Now(),
'HH:mm:ss')#">
<CFQUERY NAME="CheckProcedure" DATASOURCE="#MyDSN#" DBTYPE="ODBC">
SELECT COUNT(*)
FROM sysobjects
WHERE
(OBJECTPROPERTY(id, N'IsProcedure') = 1)
AND (name = N'sp_Test')
</CFQUERY>
<CFIF CheckProcedure.COMPUTED_COLUMN_1><CFQUERY NAME="DeleteProcedure"
DATASOURCE="#MyDSN#" DBTYPE="ODBC">
DROP PROCEDURE sp_Test
</CFQUERY></CFIF>
<CFQUERY NAME="CreateProcedure" DATASOURCE="#MyDSN#" DBTYPE="ODBC">
CREATE PROCEDURE sp_Test
@DateTimeVarChar [varchar]
AS
SELECT @DateTimeVarChar
-- DECLARE @Test_Assignment [datetime]
-- SET @Test_Assignment = CAST(@DateTimeVarChar AS datetime)
</CFQUERY>
<!--- Use the cfquery method of calling the stored procedure --->
<CFQUERY NAME="CallProcedure" DATASOURCE="HHSS_DB" DBTYPE="ODBC">
{ CALL sp_Test('#DateTimeVarChar#') }
</CFQUERY>
<CFDUMP VAR="#CallProcedure#">
Thanx
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
