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.
dsn="CSOLPhone"
You need to specify the username and password also in this string.
dsn="CSOLPhone,UID=youdbuserid,PWD=dbuserpassword"
I don't think its anything to do with the version of IIS.
Try using this string:
"Provider=SQLOLEDB;Data Source=Yourservername;Initial Catalog=Yourdatabasename;User ID=dbuser;Password=dbuserpassword;"
The connection string should really be the same for both dev and production...
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...
Why don't you create an <iframe> in the HTML page and call an ASP page in the iframe to do the processing. Your page will always be an HTML page but when you click SUBMIT it will process in the iframe. You will have to write Javascript to call the iframe so that it can call the processing ASP...
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...
Instead of giving the user the ability to resize the window, have the window dynamically resized on its own depending on the amount of content presented in the window. In other words, display all content without having scrollbars.
Hope this make sense.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.