Professional Web Applications Themes

stored procedure value - Dreamweaver AppDev

How can I bind a stored procedure value to a page? I've executed a stored procedure and there should be two column values created...i.e. col1 and col2 that are returned for use in the page. Is there a way to debug the the stored precedure execute command to see what is returned? Here is my SP execute code: If Request.Form('Submit') <> '' Then set cmdAlloAmts = Server.CreateObject('ADODB.Command') cmdAlloAmts.ActiveConnection = MM_DBConn_STRING cmdAlloAmts.CommandText = 'dbo.app_get_alloc_ABR' cmdAlloAmts.Parameters.Append cmdAlloAmts.CreateParameter('RETURN_VALUE', 3, 4) cmdAlloAmts.Parameters.Append cmdAlloAmts.CreateParameter('alloc_type', 200, 1,20,cmdAlloAmts__alloc_type) cmdAlloAmts.Parameters.Append cmdAlloAmts.CreateParameter('ddo', 200, 1,3,cmdAlloAmts__ddo) cmdAlloAmts.Parameters.Append cmdAlloAmts.CreateParameter('ay', 200, 1,4,cmdAlloAmts__ay) cmdAlloAmts.CommandType = 4 cmdAlloAmts.CommandTimeout = 0 cmdAlloAmts.Prepared = true setcmdAlloAmts.Execute End ...

  1. #1

    Default stored procedure value

    How can I bind a stored procedure value to a page? I've executed a stored
    procedure and there should be two column values created...i.e. col1 and col2
    that are returned for use in the page. Is there a way to debug the the stored
    precedure execute command to see what is returned? Here is my SP execute code:
    If Request.Form('Submit') <> '' Then set cmdAlloAmts =
    Server.CreateObject('ADODB.Command') cmdAlloAmts.ActiveConnection =
    MM_DBConn_STRING cmdAlloAmts.CommandText = 'dbo.app_get_alloc_ABR'
    cmdAlloAmts.Parameters.Append cmdAlloAmts.CreateParameter('RETURN_VALUE', 3,
    4) cmdAlloAmts.Parameters.Append cmdAlloAmts.CreateParameter('alloc_type',
    200, 1,20,cmdAlloAmts__alloc_type) cmdAlloAmts.Parameters.Append
    cmdAlloAmts.CreateParameter('ddo', 200, 1,3,cmdAlloAmts__ddo)
    cmdAlloAmts.Parameters.Append cmdAlloAmts.CreateParameter('ay', 200,
    1,4,cmdAlloAmts__ay) cmdAlloAmts.CommandType = 4 cmdAlloAmts.CommandTimeout = 0
    cmdAlloAmts.Prepared = true setcmdAlloAmts.Execute End If Any help is
    appreciated. Thanks. -D-

    -D- Guest

  2. #2

    Default Re: stored procedure value

    I re-wrote the code to execute the stored procedure as follows: Dim
    cmdAlloAmts__alloc_type cmdAlloAmts__alloc_type = '' if(Request('allo_type') <>
    '') then cmdAlloAmts__alloc_type = Request('allo_type') Dim cmdAlloAmts__ddo
    cmdAlloAmts__ddo = '' if(Request('ddomenu') <> '') then cmdAlloAmts__ddo =
    Request('ddomenu') Dim cmdAlloAmts__ay cmdAlloAmts__ay = '' if(Request('AY')
    <> '') then cmdAlloAmts__ay = Request('AY') If Request.Form('Submit') <> ''
    Then Query_Allo_Amt = 'exec app_get_alloc_ABR 'STRATEGY', 'AUS', 2005' Set
    rsAlloAmts = Server.CreateObject('ADODB.Recordset') rsAlloAmts.ActiveConnection
    = MM_DBConn_STRING rsAlloAmts.Source = Query_Allo_Amt rsAlloAmts.CursorType = 0
    rsAlloAmts.CursorLocation = 2 rsAlloAmts.LockType = 1 rsAlloAmts.Open() End If
    I have the values hard-coded into the SP execute line, but I need to replace
    the hard-coded values with variables before the SP executes. I think I need to
    use REPLACE, but not sure how to re-write the SQL line with the variables
    included. How do I re-write the line to replace the hard-coded values with the
    variables? I tried: Query_Allo_Amt = 'exec app_get_alloc_ABR' +
    Replace(cmdAlloAmts__alloc_type) + Replace(cmdAlloAmts__ddo) +
    Replace(cmdAlloAmts__ay) + ''' I received the following error: Wrong number
    of arguments or invalid property assignment Thanks for any help! -D-

    -D- Guest

Similar Threads

  1. Stored Procedure
    By Aaron Bertrand - MVP in forum ASP.NET
    Replies: 13
    Last Post: July 5th, 05:43 AM
  2. stored procedure help
    By Maria in forum Dreamweaver AppDev
    Replies: 3
    Last Post: April 20th, 06:55 PM
  3. Using a stored procedure
    By MarkWright in forum Coldfusion Database Access
    Replies: 13
    Last Post: April 15th, 05:53 PM
  4. Stored procedure?
    By SG via DotNetMonster.com in forum ASP.NET Web Services
    Replies: 0
    Last Post: February 23rd, 01:06 PM
  5. help with a stored procedure
    By Jason Tesser in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: January 3rd, 05:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139