User Profile

Collapse

Profile Sidebar

Collapse
Jaye
Jaye
Last Activity: Apr 13 '07, 02:54 PM
Joined: Feb 28 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jaye
    replied to Using a loop to input all the values of an array into an SQL query.
    in ASP Classic
    That looks good. I have been working on it for the past couple of days but with numerous errors. I'm trying to break it down and take it piece by piece. I'm not sure how I'm going to append the data to the previous record if the clientname is the same. I'll work on it some more and post my code. Thanks again for your help.
    See more | Go to post

      Leave a comment:

    • Jaye
      replied to Using a loop to input all the values of an array into an SQL query.
      in ASP Classic
      Ok...I think I may have straightened out the date issue...but now I am really having trouble trying to figure out how to generate letters for each customer properly. When I query the database, I get multiple entries for a given person, which is ok...but not sure how to manipulate the recordset to generate only one letter per person listing all the products they have bought in a given time period. Here is a sample of the data output from getstring...
      See more | Go to post

        Leave a comment:

      • Jaye
        started a topic Conversion of SAS date format into Oracle date format
        in Oracle

        Conversion of SAS date format into Oracle date format

        Hi. I was wondering if anyone knows how to convert dates in the SAS format into an Oracle date format without the use of third party software. I'd like to be able to run a procedure that would convert the imported SAS dates into Oracle formatted dates - but I don't know if it is even possible. I'm sure it has to be...but I don't know how to go about it. I found this article:

        http://support.sas.com/techsup/technote/ts566d.html...
        See more | Go to post
        • Jaye
          replied to Using a loop to input all the values of an array into an SQL query.
          in ASP Classic
          Hey Jared!

          So glad to see you! Thanks for all your help thus far. I am still working on this code. To answer your question, yes, I am using ADO.

          I am attempting to use the getString method now, so far it works...but I have to get it to work the way I need it to for these form letters that need to be generated. I tried getRows yesterday, but didn't have any luck with it. There was a syntax error somewhere or something...
          See more | Go to post

            Leave a comment:

          • Jaye
            replied to Using a loop to input all the values of an array into an SQL query.
            in ASP Classic
            OK...just found the error in my code, instead of typing i=i+2, I typed i=1+2. So no more time out error. I will test the recordset portion now. I am thinking of using the GetRows() method. I will post results. Any advice would be appreciated, thanks....
            See more | Go to post

              Leave a comment:

            • Jaye
              replied to Using a loop to input all the values of an array into an SQL query.
              in ASP Classic
              Ok I attempted this again. But I wanted to test it a piece at a time. Splitting the array works great and the SQL query is constructed properly - but, if I choose more than two names it takes forever to get the test output, which in this case is just a response.write sqltxt, where sqltxt=my select statement. I am now getting this error:

              Active Server Pages error 'ASP 0113'

              Script timed out

              The maximum...
              See more | Go to post

                Leave a comment:

              • Jaye
                replied to Using a loop to input all the values of an array into an SQL query.
                in ASP Classic
                Well, I gave it a try and I messed it up somewhere...or probably in a few places. I used the code you suggested and got the following error:

                Microsoft VBScript runtime error '800a000d'
                Type mismatch

                I know this is because I did not declare the variable to hold the resulting recordset(s) as an array. I'm not 100% sure how to do this, but I'll keep trying and if I still can't get it, I'll post my code here. ...
                See more | Go to post

                  Leave a comment:

                • Jaye
                  replied to Using a loop to input all the values of an array into an SQL query.
                  in ASP Classic
                  Thanks Jared, I will try this and let you know how it goes!
                  See more | Go to post

                    Leave a comment:

                  • Jaye
                    started a topic Using a loop to input all the values of an array into an SQL query.
                    in ASP Classic

                    Using a loop to input all the values of an array into an SQL query.

                    Hi. I am a relative newbie to ASP and I am working on an application that uses ASP and an Oracle 9i database. I have a form that allows the user to query the database by selecting a client name(s) from a listbox and also set a time period for the search by selecting a start date and end date. Once the query is executed a form letter(s) is (are) generated to the client(s) that details the products that have been purchased during the time period...
                    See more | Go to post
                    • Jaye
                      replied to Trouble with Form validation code
                      in Javascript
                      Thanks for the quick reply!

                      I checked the form for the numvars value, and it's not in the form, so that explains the error. I must have deleted it in the course of cutting and pasting snippets of code here and there.

                      I think I am going to start the whole thing from scratch and see how it goes. I found a good beginner's article on form validation, so I'll go through that and see if I can get this to work properly....
                      See more | Go to post

                        Leave a comment:

                      • Jaye
                        started a topic Trouble with Form validation code
                        in Javascript

                        Trouble with Form validation code

                        Hi. I'm having some trouble with the code I'm using to validate a form. The form is used to query a database and users can enter multiple search criteria separated by commas. Since search criteria varies, some fields may be left blank, however, I want to prevent an empty form from being submitted. I have written the code, but it's not working. I have changed it several times and now I'm just getting more and more confused. I'm new to javascript,...
                        See more | Go to post
                        No activity results to display
                        Show More
                        Working...