Stored Procedure Problem

Robert Everland III Sat, 03 Feb 2001 14:58:07 -0800

        I am having problems passing to variables to a stored procedure. Am i doing
this right? The only time it updates is if the ID and Entry are the same
number.

<cfstoredproc procedure="sp_addvote" datasource="UCFHotties"
dbname="UCFHotties">

                <!---  CFPROCPARAM tags --->
                <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ID"
value="#ID#" null="No">

                <!---  CFPROCPARAM tags --->
                <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@entry"
value="#entry#" null="No">
        </CFSTOREDPROC>


Bob Everland


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Stored Procedure Problem

Reply via email to