User Profile

Collapse

Profile Sidebar

Collapse
jdom
jdom
Last Activity: Aug 19 '09, 07:23 PM
Joined: Sep 15 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jdom
    replied to MultiSelect List boxes as query parameters
    in ASP Classic
    MultiSelect List boxes as query parameters

    can you guide to some kind of tutorial how to this

    Thank you
    See more | Go to post

      Leave a comment:

    • jdom
      started a topic MultiSelect List boxes as query parameters
      in ASP Classic

      MultiSelect List boxes as query parameters

      i am trying to pass the value "comapre" of 2,3, or 4 checkbox to next page
      but i am getting errors.
      Application uses a value of the wrong type for the current operation. LINE
      rsSearch_cmd.Pa rameters.Append rsSearch_cmd.Cr eateParameter(" param1", 5, 1, -1, rsSearch__MMCol Param) ' adDouble

      Query string is like this

      compare.asp?com pare=466&compar e=4600

      Code:
      <%
      ...
      See more | Go to post
      • jdom
        replied to Application uses a value of the wrong type for the current operation
        in ASP Classic
        Any one has any idea?

        Thank you
        See more | Go to post

          Leave a comment:

        • jdom
          started a topic Application uses a value of the wrong type for the current operation
          in ASP Classic

          Application uses a value of the wrong type for the current operation

          i have been struggling with this error for a while , i changed to many times to make sure no error but no luck


          Error on line 29
          strsql.Paramete rs("@columna") = strmake




          <%

          Dim objCN ' ADO Connection object
          Dim objRS ' ADO Recordset object
          Dim strsql ' SQL query string
          Dim RecordsArray ' To hold the Array returned by GetRows
          ...
          See more | Go to post
          • jdom
            replied to Type mismatch: 'arrOutput3'
            in ASP Classic
            Any suggestion please. Thank you
            See more | Go to post

              Leave a comment:

            • jdom
              started a topic Type mismatch: 'arrOutput3'
              in ASP Classic

              Type mismatch: 'arrOutput3'

              i have this script that's be giving me errors what ever i do. if you could please help
              Type mismatch: 'arrOutput3' Line: 38
              <select name="model" onchange="getpa ge(<% Response.Write ""&arrOutput3(1 ,i)&"" %>,this.value)" >


              The entire script:

              <% set objDBConnection 3 = Server.CreateOb ject("ADODB.Con nection")
              objDBConnection 3.ConnectionTim eout...
              See more | Go to post
              • jdom
                replied to GetROWS and request.querystring
                in ASP Classic
                Anyone has any suggestion please
                See more | Go to post

                  Leave a comment:

                • jdom
                  replied to GetROWS and request.querystring
                  in ASP Classic
                  Subscript out of range

                  This new question can't find where to post a new one. anyway

                  i have this code that is giving me a seriouse of error:
                  Subscript out of range: '-40'
                  line : strid = aResults(0, iRowLoop)

                  <% objDBConnection .Open "DATABASE"
                  set objDBCommand = Server.CreateOb ject("ADODB.Com mand")
                  objDBCommand.Ac tiveConnection = objDBConnection
                  ...
                  See more | Go to post

                    Leave a comment:

                  • jdom
                    started a topic GetROWS and request.querystring
                    in ASP Classic

                    GetROWS and request.querystring

                    have this code but not sure how i can use querystring from another search form page to define the CAT_ID = ? AND MAKE = ?
                    Thank you

                    Code:
                    <%@ Language=VBScript %>
<% Option Explicit %>
<%


Dim objCN ' ADO Connection object
Dim objRS ' ADO Recordset object
Dim strsql ' SQL query string
Dim RecordsArray ' To hold the Array returned by GetRows
Dim
                    ...
                    See more | Go to post
                    Last edited by DrBunchman; Sep 24 '08, 07:34 AM. Reason: Added [Code] Tags - Please use the '#' button
                    • jdom
                      started a topic Pagination with SQL Server 2005
                      in ASP Classic

                      Pagination with SQL Server 2005

                      I am new to stored procedure. I would like to call this to my asp page but just don't have clue how to.
                      Reason i have to this because i have a largedata base.

                      Here is the query from my database:
                      Code:
                      SELECT AD_ID,make, model, year, imagea, ad_dated FROM ADS WHERE Make = "BMW" ORDER BY AD_ID DESC
                      Make is querystring

                      I did try but with no success. if anyone can help or guide me to a sample...
                      See more | Go to post
                      Last edited by DrBunchman; Sep 16 '08, 07:06 AM. Reason: Added [Code] Tags - Please use the '#' button
                      No activity results to display
                      Show More
                      Working...