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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by A1Pat

  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. :-)
See more

Part and Inventory Search

Back
Top