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!

  • Congratulations Chriss Miller 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. LuvASP

    Connection.execute RecordsAffected Problem

    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...
  2. LuvASP

    Update page without refreshing entire page.

    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...
  3. LuvASP

    Execution of SQL Query and quit

    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.
  4. LuvASP

    'Date format' problems with ASP & Oracle

    VBScript doesn't accept "format" by itself so you have to use the "formatdatetime". Look online or in MSDN for this function.
  5. LuvASP

    DSN Rights Problem

    dsn="CSOLPhone" You need to specify the username and password also in this string. dsn="CSOLPhone,UID=youdbuserid,PWD=dbuserpassword"
  6. LuvASP

    Connection String Problem

    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...
  7. LuvASP

    I am using the following queries to

    Thank you very much. It worked.
  8. LuvASP

    I am using the following queries to

    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...
  9. LuvASP

    Storing DB Connection String - ideas??

    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...
  10. LuvASP

    Capturing submitted form values

    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...
  11. LuvASP

    Update Info on Exchange

    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...
  12. LuvASP

    Update Info on Exchange

    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...
  13. LuvASP

    COM To Exchange

    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...
  14. LuvASP

    Replication between 2000 and 7.0

    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.
  15. LuvASP

    Sourcesafe Error

    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 &quot;Add to SourceControl&quot; from Interdev it gives me the following error: &quot;cannot establish source control for the web application...
  16. LuvASP

    Debug Question

    never mind found the answer. I have to set my working mode to LOCAL instead of MASTER. That did it. Yay.
  17. LuvASP

    Debug Question

    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...
  18. LuvASP

    Automatic Window resizing

    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.
  19. LuvASP

    Automatic Window resizing

    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...
  20. LuvASP

    Selectbox Value To ASP

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

Part and Inventory Search

Back
Top