Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bdc101

    SQL Server 2000 Server Change

    I agree with you Denny, but the decision was taken out of my hands. They want the reports in Reporting Services rebuilt from scratch before we do the server switch. They want all these changes done before the server switch so it is ready before we change over. If I restore the msdb database...
  2. bdc101

    SQL Server 2000 Server Change

    Thanks for the response Denny. The reason we do not want to restore this database is there are a lot of jobs for SSRS subscriptions. We set all our reports up to be automatically emailed every morning. If we restore the msdb database all those jobs will be there, and we do not want that. I...
  3. bdc101

    SQL Server 2000 Server Change

    We have an old server running SQL Server 2000 that we are replacing, and we are keeping SQL Server 2000 on the new server. The reporting department wants to rebuild Reporting Services 2000 on the new server instead of restoring the old copies when we do the switch. If I do not restore the msdb...
  4. bdc101

    SQL Server 2005 Database Mirroring Setup

    I have two questions: 1) Can one instance of sql server on a third server be the mirror for instances on multiple servers, i.e. database x on server x and database y on server y both have a mirror on server z? 2) A separate license is not required for the secondary instance if it is used solely...
  5. bdc101

    Schemabound View will not Update

    The primary key was proj_num and phone. There was a check constraint on the proj_num column to confirm the records from other project numbers do not get entered. I have it working now by removing all the check constraints and the primary key. I know that is not ideal, but it had to work now...
  6. bdc101

    Schemabound View will not Update

    I have a partitioned view that is schemabound to the underlying tables. There is a job that runs every minute that has a step which is supposed to update the view. When the job runs, that step fails with the following error message: UNION ALL view 'sl' is not updatable because a partitioning...
  7. bdc101

    problem with recordset

    I am using MySQL 5.0. I have run several simpler queries to test the DSN and conn and they run fine which is why I am so confused. Here is the response.written query: SELECT i.stateCD AS State, IFNULL(SUM(i.netamt),0) AS netAmt, IFNULL(COUNT(i.inv),0) AS OrderCount, MAX(YEAR(i.dtordrec2)) AS...
  8. bdc101

    problem with recordset

    Thanks for all the suggestions, and I apologize for not including the info I have gotten from responses already. I have used response.writes to glean the following information: 1. rsOrders.eof is true after I execute the query. 2. rsOrders.recordcount is -1 3. Since the recordset is at...
  9. bdc101

    problem with recordset

    Here is the for loop it starts on line 552 and ends on line 560. the query section I displayed earlier is on lines 159-263. The error occurs on the first line I try to access one of the arrays created in the earlier code. j = 0 For j = 0 to ubound(orderState) compareYear = CDbl(orderYear(j))...
  10. bdc101

    problem with recordset

    Microsoft VBScript runtime error '800a0009' Subscript out of range: 'UBound' /reports/outside-sales-reports/quarterly-report/generate-report.asp, line 552 This line is well below the lines I posted and is simply: For j = 0 to ubound(orderState) I ran some response.write...
  11. bdc101

    problem with recordset

    Hi DNG: Thanks, I did not catch that keyword. Changing the keyword did not fix the problem though. I ran this query in Navicat against the dB which is MySQL, and it works fine. Any other ideas? --- BDC
  12. bdc101

    problem with recordset

    Hello all: I am trying to run a query against a database in an asp page, and I am getting an empty recordset returned. I know there is data that should be returned by the database, and I know the query works because I can run it against the database manually with success. I cannot find what...
  13. bdc101

    error codes with msxml in vbs file

    I have tried several different values for the line ranging from 1 up to 180000. Originally the value was 1. --bdc101
  14. bdc101

    error codes with msxml in vbs file

    I am getting one of two error codes from a vbs file when the task scheduler in Windows Server 2003 tries to run it. The file is used to generate several different sales reports at night. The reports will still generate if someone is there to press ok within a certain amount of time on the...
  15. bdc101

    IF Statement only works on first run through For Loop

    Found the problem finally. I was forgetting to check the array "state" for special characters. There was a space in the data that was not supposed to be there. Thanks everyone for all the help. --bdc101
  16. bdc101

    IF Statement only works on first run through For Loop

    on error resume next" is not used anywhere. The program puts the recordsets in arrays now. I used the escape command and there are no special characters in the data. I am still having a problem with the second run through the loop. Should I cast my reset commands?
  17. bdc101

    IF Statement only works on first run through For Loop

    One more thing to add. This program is still working properly the first time it runs through the parent FOR loop for the state. It always encounters the problem on the second run through the parent FOR loop. This is adding to my frustration because if it can find the records and test true on...
  18. bdc101

    IF Statement only works on first run through For Loop

    Hello again. I have added some coed that is forcing every variable to be the data subtype I want now and I am still getting a false return on the compare. The data looks the same and the variables are the same subtype. I aplogize for being such a pest, but I just do not know what else to do...
  19. bdc101

    IF Statement only works on first run through For Loop

    The value is the one shown in the response.writes referenced earlier. Here is the code for the loops that put the quote data in arrays with the resposne.writes (the loop for order data is the same way): Dim quoteState(), quoteDollars(), quoteCount(), quoteYear(), i i = 0...
  20. bdc101

    IF Statement only works on first run through For Loop

    The data type for the results that are causing a problem are all field. How can I force a field data type into another type if using casts does not work? P.S. Thanks for all the help everyone. It's greatly appreciated.

Part and Inventory Search

Back
Top