Recent content by wrbodine

So other ideas on how to view sp values from an app: 1. If your stored procedure isn't currently returning a select statement, one thing you could do is build a SELECT statement inside the stored procedure, made up of variables that you want to view the values of. So the last line of the sp...

Hi, On our Internet site we have a handful of pages that are called using https:// as secure pages. These pages are listed in an if statement, which calls them as https:// if they are in the list. We added a new .asp page to this if statement, and for some reason, with this page only, the...

Thanks much k, That helped me figure out what was going on; when I tried a different way of connecting (using OLE DB) I found one of the tables didn't have proper permissions for the SQL account we were using.... Thanx again [thumbsup2]

Hi, We are creating a new Crystal Report (8.5) that uses a dsn, with a stored procedure from SQL Server 2000. The stored procedure uses a linked server in the select statement, with a fully qualified name in the join, something like Select LTABLE.field1, local.field2 from local join...

Hi, We have an asp.net project that we're copying from our development web server to the live web server (IIS 5.0, Windows 2000). This was giving us some problems just moving the pages, so we created a deployement project within Visual Studio .NET and it worked great. Now we want to use...

Hi, I have an .asp page that submits to an .aspx page, which has a COM+ component call to a .dll created with VS .NET. I made a change in code to the .dll, changing the connection string for what server the database is on, and the SQL user it uses. So I re-created all the COM+ stuff (server...

Thanx, that makes sense; probably easier with the number of views we have to just change them but that could really help in the case of more of them....

Hi, Another thread had the following, for tables. Is there something like this for views? from another thread: The followig script changes the table owner for all tables in the current database to 'dbo' if not already 'dbo'. The script uses the undocumented system stored procedure...

Hi, We're wanting to bring up an pop-up when the user clicks on a hyperlink, and have the user select an item on the pop-up screen. Then, once they select this item and click on a button (or a link or whatever) it would close this window and, on the original screen, the info from this pop-up...

Hi, Check out the following link, in the section on Windows Installer. This enables you to create your project in a virtual directory that you create on the new web server. This is very useful for moving a project from one server to another...

Hi, How would we access the Global Address List (with valid user e-mail addresses) on our Intranet? We're on Exchange 2000.... Thanks, Ray

Hi, We have .asp pages on our Intranet with an application that we want to be able to send e-mails through. How would we access the Global Address List (and the e-mail addresses in it) through script on this .asp page? We're on Exchange 2000. Thanks much, Ray

Well, this is resolved now! It was an .aspx issue, that I found while debugging through the code. I needed to add the dispose method call to the component, and this fixed it. I guess it was using a cached copy of the component, so it was calling the code, but it hung in the .aspx page at...

Hi, Thanks much for the input. I am returning the ID from the component (which has error trapping), and it returns fine to the page, which also means I'm getting no errors from the component. I added a trasaction to the component, and am committing it right after the Insert. When I've made...

Thanks so much Paul! That took care of things; really really helpful post! Have a good one, Ray