Search results for query: *

I am executing an Insert query through connection object: set conn = server.CreateObject("ADODB.connection") conn.Open constr conn.execute "INSERT INTO table1(val) SELECT val FROM table2", recs, adAsyncExecute I keep getting a -1 in recs. What am I doing wrong...

I have seen a website in action where when something changes in the database the ASP gets updated without getting refreshed. Unfortunately, I have not been able to find anything on the net for this. I believe this is possible by having an activeX control which contains winsock component...

Is there any way to start execution of a query on SQL Server and quit instead of waiting for the complete execution of the query. Is this possible in ASP or am I just dreaming. I want to avoid writing a service.

I am using the following queries to get the WeekStarting date and WeekEnding date depending on today's date. For e.g. the weekstarting date for today would be 6/18(Monday) and weekending would be 6/24(Sunday). (Select dateadd(d, -(datepart(dw,getdate())-2), getdate())) as weekstarting (Select...

I have an ASP web application that uses COM as the middle-tier. COM communicates with a SQL Server database and in COM we have the DSN-Less connection string to connect to the database. I don't know how safe this actually is and am looking for alternatives to storing the database connection...

Can someone point me in the right direction. I want to update an Exchange profile via COM. I have written code to fetch information from the exchange server and that I am using in ASP via a COM object using ADSI objects. I would like to go a step further and update that information via COM as...

Can someone point me in the right direction. I want to update an Exchange profile via COM. I have written code to fetch information from the exchange server and that I am using in ASP via a COM object using ADSI objects. I would like to go a step further and update that information via COM as...

Can someone point me in the right direction. I want to update an Exchange profile via COM. I have written code to fetch information from the exchange server and that I am using in ASP via a COM object using ADSI objects. I would like to go a step further and update that information via COM as...

Does SQL Server 2000 support replication to a 7.0 database. My source database resides on a SQL Server 2000 box and the destination database resides on a SQL Server 7.0 box. Will the replication work? Thanks.

I'm having no luck getting my Interdev project in Sourcesafe. Please help! I have installed Sourcesafe Server on the Web server and everytime I try to "Add to SourceControl" from Interdev it gives me the following error: "cannot establish source control for the web application...

I am trying to debug ASP code in Interdev. The project is created on my local machine and points to an external server. I have enabled server-side script debugging on both IIS's (my machine and on the server itself). Everytime I hit the play button it tells me that it won't be able to debug all...

I'm trying to find a property of the Javascript Window object that resizes the window according to the content presented. I open a window using the OPEN method specifying some features with the height and width, scrollbars, resizable etc. I want the window to resize automatically according to...

How do I pass the selectbox value to my ASP code without reloading the page. I have an onchange event for the selectbox where I am executing some ASP code but I can't figure out how to pass the value to server-side ASP code. Is reloading the form the only solution to this. I would appreciate...

Can one pass a parameter to the TOP part of the select statement through a Stored Procedure, e.g.<br><br>CREATE PROC sp_TopSelect (@sp_param int)<br>AS<br>SELECT TOP @sp_param field1,field2,fieldn<br>FROM Table....<br>----<br><br>EXEC sp_TopSelect 5<br>---- <br><br>The above example doesn't work...