Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 13th, 2019, 03:49 AM
Registered User
Join Date: Feb 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Question Pass values to stored procedure where input values has changed

I am working on a Classic ASP project where I am updating multiple records in a table with single Submit button. Each row has select box and text box and user can update all the rows. While sending parameters to stored procedure , I want to pass only those values where input values ( select box or text box ) have been changed. I can't figure how should I do that. sCycleTime(Id) and sComment(id) contains values of Select Box and Textbox of all the rows. sProfile(id) and sProcess_Step_Sequence(Id) are two id's binded in each Select box and Textbox. Eg: DrpDwn_1_4 and Txtbox_1_4 and so on...
sQry = ""
    For Id = 0 to 22
    response.Write ("this is " & l_comments)
        If Trim(sProcess_Step_Sequence (Id)) <> "" Then
            If Trim(sQry) = "" Then
                sQry = sProfile(id) & "~" & sCycleTime(Id) & "`" & sProcess_Step_Sequence(Id) & "^" & sComment(id)
                sQry = sQry & "!" & sProfile(id) & "~" & sCycleTime(Id) & "`" & sProcess_Step_Sequence(Id)& "^" & sComment(id)
            End If

        End If

    objCommand.CommandText = "EXEC usp_UPDATE_Dual_Code_Cycle_Times_and_Comments '" & sQry & "' ; "

Similar Threads
Thread Thread Starter Forum Replies Last Post
Values getting changed while returning/receiving veeruu .NET Web Services 4 January 17th, 2008 08:54 AM
how to pass value to stored procedure? hertendreef SQL Server 2005 3 February 23rd, 2007 11:43 AM
Returning Values from a Stored Procedure kadjw SQL Server ASP 1 September 13th, 2006 12:08 PM
update values of changed cells into database using changusee2k PHP Databases 0 March 9th, 2006 01:05 PM
Help with DreamweaverMX and Stored Procedure input Chc325 Dreamweaver (all versions) 3 October 8th, 2004 01:49 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.