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 SkipVought 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. shanegarcia

    Getting the Computer Name from T-SQL

    Hi, I'm writing a trigger that logs updates to the database as part of audit requirements. I can get the SQL Login name of the user who made the changes but I'm also being asked to log the workstation used to perform the update. Is there a way to do this in SQL? I'm using Windows 2000 and SQL...
  2. shanegarcia

    Stored procedure problem...

    This is the stored procedure that I'm trying to call, however, when I get the resultset in Crystal it only shows the header table... Any ideas on how I can get the other tables (i.e. details, etc.) Any inputs would be greatly appreciated... Thanks.... <STORED PROCEDURE CODE> if exists...
  3. shanegarcia

    How do I call a stored procedure involving 3 result tables?

    This is the stored procedure that I'm trying to call, however, when I get the resultset in Crystal it only shows the header table... Any ideas on how I can get the other tables (i.e. details, etc.) Any inputs would be greatly appreciated... Thanks.... <STORED PROCEDURE CODE> if exists...
  4. shanegarcia

    How do I set the database location for a large number of CR reports?

    Hi, Is there a way for me to set the database location for a large number of CR reports? For example, from a test server to a live server without having to go in and set each one individually? We're talking 200+ reports here... Alternatively, could you suggest a way for me to do this...
  5. shanegarcia

    ADO resultset returns an EOF when called from a proc in ASP

    Hi Palooka, Your tip about the different approach and not using the array did it for me. I got the code to work. Still can't get the reason why it won't work when called from a sub though. Anyway, thanks for all the help. Really appreciate it.... =) Shane
  6. shanegarcia

    ADO resultset returns an EOF when called from a proc in ASP

    Palooka, Thanks for the help. I will try your suggestions and see if I can get the code to work.
  7. shanegarcia

    ADO resultset returns an EOF when called as a procedure...

    Yes, I've actually done Response.Write debugging already that's why I saw that the subsequent calls were getting EOF... Ok, here's the procedure code that I call....I've cut out some of the code, namely the other Response.writes...to make it shorter but none of the important stuff... Sub...
  8. shanegarcia

    ADO resultset returns an EOF when called from a proc in ASP

    Ok, here's the procedure code that I call....I've cut out some of the code, namely the other Response.writes...to make it shorter but none of the important stuff... Sub ShowData(strSQL, ctr) Dim AdoConn, adrsICD, ConnStr Dim intRecordsAffected Set AdoConn =...
  9. shanegarcia

    ADO resultset returns an EOF when called from a proc in ASP

    Hi, I have an ASP program that queries a SQL database based on multiple user selections stored in an array. I then SPLIT() the array to get at individual items. My problem is that after the initial pass (which gets data successfully), the second call of the sub with the corresponding parameters...
  10. shanegarcia

    ADO resultset returns an EOF when called as a procedure...

    Hi, I have an ASP program that queries a SQL database based on multiple user selections stored in an array. I then SPLIT() the array to get at individual items. My problem is that after the initial pass (which gets data successfully), the second call of the sub with the corresponding parameters...

Part and Inventory Search

Back
Top