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...
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...
'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...
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...
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...
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...
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...
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.
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...
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'...
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...
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 =...
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...
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...
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.
:-)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.