Avatar of JohnMac328
JohnMac328
Flag for United States of America asked on

SQL Stored procedure to insert records from form

I am using CF to enter data from a form.  Can the same be done with a stored procedure?

Here is the coldfusion form

<cfquery name="AddVideo" datasource="#datasource#">
                INSERT INTO VideoList
                (CategoryID, Video_Name, Length, Production_Company, Credits, Availability, NumTests)
                VALUES (<cfqueryparam cfsqltype="CF_SQL_INteger"  value="#FORM.CategoryID#">,
                        <cfqueryparam cfsqltype="CF_SQL_VARCHAR"  value="#FORM.Video_Name#">,
                        <cfqueryparam cfsqltype="CF_SQL_VARCHAR"  value="#FORM.Length#">,
                        <cfqueryparam cfsqltype="CF_SQL_VARCHAR"  value="#FORM.Production_Company#">,
                        <cfqueryparam cfsqltype="CF_SQL_INteger"  value="#FORM.Credits#">,
                        <cfqueryparam cfsqltype="CF_SQL_INteger"  value="#FORM.Availability#">,
                         <cfqueryparam cfsqltype="CF_SQL_INteger"  value="#FORM.NumTests#">)
                       
        </cfquery>
SQLColdFusion Language

Avatar of undefined
Last Comment
JohnMac328

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
erikTsomik

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
JohnMac328

ASKER
Great - that does make sense now.
JohnMac328

ASKER
Great job
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck