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

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

    update record and get return ID

    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 =...
  2. unseth

    weird stored procedure slowness

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

    MDAC 2.6, 2.7, openrowset patch

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

    OLEDB provider error - maximum length is 128

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

    transactional replication

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

    adOpenForwardOnly and input parameters

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

    using IN and an integer list

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

    snapshot replication w/full text catalogs

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

    FULL TEXT INDEXES

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

    Index Server and SQL 2000

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

    CRecordset and Stored Procedures

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

    Asp; is a close good enough?

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

Part and Inventory Search

Back
Top