Recent content by soapdad

Ahhhh....a new tool to learn. I tried it with the same result, but Profiler shows some of the field entries in red, so I've got to figure out what that means. I might be adding unneeded quotes because those are the fields in red. This is what it showed: INSERT INTO Aff_Mgr_Sales_Tbl (...

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

I'm trying not to sound too dumb here, as I usually do very simplistic SQL stuff, so... Anyway, I normally open a connection to the database with a line like this: Connection.Open "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD="...

I guess I would have to establish two connections and then go this route? Thanks!

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

Thanks for the attempt. I just went out and bought a Microsoft book on SQL programming. I haven't gone into it yet, but I guess I could also do this in two passes. I was attempting to do it this way because I sometimes use Access to create a model query and then modify it in query analyzer...

I was using a left join after reading in the Access documentation that doing so would add any unmatched records to the second file. I wasn't sure if that would work in straight SQL. My goal is to update any record in the second file that has a match and add the orders from the first if there...

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

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