Search results for query: *

I'm using mysql currently, and i want to lock a record, update it, and get the current id. For example, I have a table with a field called nextmsg (int). On my sql statement, i want to update the nextmsg + 1, and get the new value. I was doing the following: set rslck =...

I've located a slow moving SPO and narrowed it down to the following. I've simplified it here for ease of reading (in actuality, the second contains is not a contains, but an openrowset on something else, but for the problem is still the same) Select a,b,c FROM table1 WHERE (date_retrieved...

I have 3 machines. machine 1. Sql server 2000. windows 2000 server. updated to MDAC 2.62.7926.1 machine 2. windows 2000 server. updated to MDAC 2.62.7400.1 this seems ok, since they say its the same version, only the version # is different. However, machine 3. windows 2000 pro...

I have an ole db provider that i call this way select filename from mpaole...[this is my input] however, if my input exceeds 128 characters, I'm given the error 103 that the maximum length is 128 characters. I know this deal's with quotes, and setting QUOTED_IDENTIFIER OFF, however, there...

In my system (SQL 2000) i had snapshot replication working fine. However, I am learning about transactional replication, and I have a few questions. 1) why is there still a snapshot being made? I thought transact was supposed to just make a list of the changes that were made and then send...

normally i open my recordset like so: set objRS = Server.CreateObject("ADODB.Recordset") objRS.LockType = 1 'adLockReadOnly objRS.CursorType = 0 'adOpenForwardOnly but now i want to use this method so I can use input parameters in my SPO for recordcounts. Does this method...

I have a list of states by number. If I do this, it works fine: select * from states where state_id IN ('15,25,30') (state_id is an int) however i want to pass it into a spo. so I can call: exec statelist '15,25,30' however it doesn't work this way: create procedure statelist as...

I have my snapshot replication with a push subscription working on two database servers. However the full text catalogs aren't being pushed from one machine to the other during this process. I'm forced to rebuild the catalog on the subscriber machine every time the replication takes place...

I've been creating full text indexes on several SQL server 2000 machines (running windows 2000). However recently I deleted a full text catalog, and recreated it on a table with 2 fields, and now everytime i try to populate the table it won't. It says its rebuilding, but the index remains at 0...

I've gotten Microsoft Index server to work with SQL server 2000 before by creating a linked server, however that only works when the Index Server is on the same machine as SQL. Now my index server is on a separate machine, but I can't figure out how to set up a linked server from the SQL 2000...

I'm working with Stored Procedures and CRecordset. I'm just trying to figure out the syntax. I finally figured out the syntax to the SPO but I can only get the one to work that doesn't take input. For example: strSQL = "{CALL spotest}"; rs->Open(CRecordset::dynaset, strSQL...

set mycon = Server.CreateObject("ADODB.Connection") mycon.Open "mydb", "", "" set results = mycon.Execute(sql) .... process recordset results ... mycon.close -------------- is that the proper way to close out the page (I'm using ASP) i've seen...