Recent content by Yale

thanks damber and sheco! i'll try to implement your recommended solutions... hopefully, i'll be able to do everything correctly... or else... you'll hear from me again... ;D -Yale

damber, i've read the thread... thanks! anyways, i have a few more questions -- we are thinking of creating a "lock procedure" ...this lock procedure will be called every time that an existing request is opened... it will basically check if a record is checked-out to someone... if it's not...

Hello, Is it possible to implement a 'Check-in/Check-out' or 'Form Locking' Functionality in an application that is using classical ASP and SQL? Basically, what needs to be done is that if an existing request form is being edited by one user, no other user should be able to edit the same...

Help! I am getting the following error message -- Server object error 'ASP 0177 : 800a8019' Server.CreateObject Failed /includes/incRetrieveCookie.asp, line 7 800a8019 Line 7 points to the following code -- Set oStateMgtSvc = server.CreateObject("SD_ICBAM.CStateMgtSvc") We have already...

if for example i use "nolock" in my transaction query (say query1)... then query1 will not block other transactions that may come after it (i.e. running query 1 will not lock any data)... is that correct? thanks so much, yale :)

how do i resolve blocking issues? is there something that i could place in a sql script for it to avoid causing the blocking of transactions? thanks, YALE

i have a follow-up question... how do i resolve the blocking issue? is there something that i could place in the sql script that is causing the blocking of transactions? thanks again! YALE

hi zhavic, "mytable" is a table... anyways, good news -- we've already found-out what is causing the issue... you are correct... all transactions are being blocked by another running transaction... we were able to determine this using sp_who2... thanks, yale

help!!! how come a simple "select top 1 * from mytable" times-out when the statement is supposed to just display a single row? how do i solve this? thanks, yale

<script language="VBScript"> Function validateForm() dim origURL origURL = Trim(document.frmURLinfo.txtSourceURL.value) document.frmURLinfo.txtgeneratedURL.value = --> i want this field's value to be the url encoded value of origURL... how do i do that? "server.URLEncode(origURL)" does not...

yes... as i've said... the same piece of code (with the same user id and same password) achieves different results in different servers... mapping is successful in server 1... mapping fails in server 2... :(

Any reason why the same piece of code that maps a folder in another server WORKS in one environment/server and FAILS in another environment/server? Sample code: dim oNet Set oNet = Server.CreateObject("WScript.Network") oNet.MapNetworkDrive "R:", "\\nbwtr12pu\folder", False, "thisistheID"...

ok... how come the same piece of code on different servers have different results? on one server, no error occurs... on the other server, that error happens... :S thanks again, yale

I'd like to know... What are the possible causes of the following error? VBScript runtime Error Number: -2146827850 Description: Object doesn't support this property or method: 'Exec' Any input would be greatly appreciated... Thanks, Yale

hmmm... can i just set the command timeout "within" the stored procedure itself? is that possible? if yes, how? thanks, yale