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!

  • Congratulations strongm 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: A1Pat
  • Order by date
  1. A1Pat

    Batch UPDATE with DELETE function

    I haven't do thorought test yet, but what I did is I moved the whole delete function to the bottom of the code right after rs.update, and it works so far. So the mentality is that I just have to update the product first then delete it, if checked. Waste time, you bet! but it works for now...
  2. A1Pat

    Batch UPDATE with DELETE function

    I don't know!!! From the original While Loop we're working on, I got this message: Microsoft VBScript compilation (0x800A0400) Expected statement /admin/products/default.asp, line 410 wend which is the one you recommended. I don't know exactly why the error's there while the wend at the end...
  3. A1Pat

    Batch UPDATE with DELETE function

    'exit you loop" I looked it up and many online tutorials suggested I should change to utilize Do... Loop instead of While loop. Therefore, I can seem to find a good Exit While that works yet. So this is what I did rs.MoveFirst Do while not rs.eof ProductID=rs("ProductID") if...
  4. A1Pat

    Batch UPDATE with DELETE function

    I changed the "wend" you recommended to rs.movenext, the code proceeds properly until I try to delete the last item in the list. Now I'm getting a error message saying ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a...
  5. A1Pat

    Batch UPDATE with DELETE function

    I'm getting this: Error Type: Microsoft VBScript compilation (0x800A0400) Expected statement /admin/products/default.asp, line 407 wend
  6. A1Pat

    Batch UPDATE with DELETE function

    rs.MoveFirst while not rs.eof ProductID=rs("ProductID") if len(Request("delete" & ProductID)) > 0 then 'Delete records from Categories_Products mySQL = "DELETE FROM tblCatProd " _ & "WHERE ProductID = " & trim(Request("delete" & ProductID)) objConn.Execute mySQL...
  7. A1Pat

    Batch UPDATE with DELETE function

    Hello all, I'm not sure whether this question should be for this forum or should it belong to SQL forum, so please bear with me here... rs.MoveFirst while not rs.eof ProductID=rs("ProductID") if Session("esku") = 1 then rs("SKU")=Request("SKU" & ProductID) end if if...
  8. A1Pat

    Bulk Update set up

    Thanks onpnt, I'm checking the link out right now, hopefully it is the one.
  9. A1Pat

    Bulk Update set up

    Hi all, I'm creating a page that I can be able to do bulk updating a whole bunch of data at the same time. So far I'm having a page with all data displayed in edit mode, but I can seem to figure out how to update all of them once I hit Update button. I'm asking this question in this ASP forum...
  10. A1Pat

    Form name in a function

    Thank you monksnake for the explaination.
  11. A1Pat

    Form name in a function

    It works now, Dan. You forgot to tell me to replace the whole frm.WESPSDKMonitor with the cam. Thanks! Still, if you please explain the pros and cons of the eval() function.
  12. A1Pat

    Form name in a function

    Hi Dan, I tried like you suggested, but I got an error: Object Required. This really compels me to utilize the Eval() tool that you guys seemed to dislike so much. Would you please tell me the pros and cons why people should or should not use the eval(). I googled around but couldn't find a...
  13. A1Pat

    Form name in a function

    since this is a new development about the object, I did redo the form so that the objects will be # and the form name is only one. <TD align="center" valign="top"><FORM name="mySDK"> <% arrChannels = Split(Session("cam_no"), ",") x = 0 response.write "<table cellpadding='5'...
  14. A1Pat

    Form name in a function

    I had thought of that, but instead of having different # for WESPSDKMonitor, I did the form's names. Don't you think that serves the same purpose?
  15. A1Pat

    Form name in a function

    And do not forget, the form's elements that I mentioned have included <... onclick...> to activate Do_Connect function. Just to have you know. :-)
  16. A1Pat

    Form name in a function

    You are right, Dan. The whole coding in the page is not normal to me when I first look at it at all. I can show you the actual original form: <FORM name=mySDK> <OBJECT id=WESPSDKMonitor codeBase=./WESPSDK.cab#version=1,2,2,8 height=243 width=360...
  17. A1Pat

    Form name in a function

    Dan, I just quickly tried your code given on the above and I got an error: 'document.forms[...].element' is null or not an object As I understand, the WESPSDKMonitor is the camera ID name that was given inside the Object in each form. I tried: function Do_Connect() { var arrCams =...
  18. A1Pat

    Form name in a function

    Thank you all for your replies... To Dan, I'm sorry that I still 'till now haven't had a chance to test your code just yet, however, be asure that I will try it eventually as soon as possible cause I do want to learn a better and proper way for coding. To Monksnake, I tested your code because...
  19. A1Pat

    Form name in a function

    Hi all, I'm trying to modify this original function that is used to open a form when called: function Do_Connect() { mySDK.WESPSDKMonitor.ClientPullingMode = 0; mySDK.WESPSDKMonitor.Connect(); } and as you can see, the form name "mySDK" is located right in the beginning of the 2 lines...
  20. A1Pat

    Split an array in JS

    Nevermind... Thank you for NOT reply this stupid question. I either must be high or stupid to realize this line document.write(arrChannels[i]+'<br>'); ... Sorry anyone if you had to view the question. :-)

Part and Inventory Search

Back
Top