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 bkrike 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: *

  • Users: soapdad
  • Content: Threads
  • Order by date
  1. soapdad

    ColdFusion/MSSQL - unable to add records

    I have an MSSQL database that I restored from a backup from my ISP's server onto my own local test server. When I attempt to run a ColdFusion script to add a record to a table it will not add the record, nor does it generate an error. I have the full debugging on in CF and it just says...
  2. soapdad

    copy tables between databases

    Does anyone have any suggestions on the best way to copy tables between two MSSQL databases? My ISP does not allow scheduled DTS jobs so that is not an option. I am creating an ASP application which will combine data from satellite tables on different databases into one master table. I can...
  3. soapdad

    SQL query problem

    Hello All, I am trying to create an update query on MSSQL using query analyzer and seem to be having a problem using a left join. I am using the following query: UPDATE Aorders LEFT JOIN orders ON Aorders.NewOrderID = orders.orderid SET orders.odate = Aorders.odate; and I am getting the...
  4. soapdad

    Connectiontimeout problem

    I am running a query to a remote MSSQL server off of my default page. Most of the time it works great, unless that server is down. In this case, it takes a very long time to load the page. I am trying to use connectiontimeout or commandtimeout to limit the amount of time we waste if the...

Part and Inventory Search

Back
Top