I seem to be having a little trouble. Hopefully some of you can help me.<br>
In an ASP script using VBScript I am having a problem concatenating the parameters dynamically in a "request.form" statement. I know that the referenced fields exist and that they have data. Please help!<br>
<br>
Here is the code:<br>
--------------------------------<br>
for i=0 to ubound(arrayString)<br>
updSQL = "SELECT * FROM PUBLISHMASTER WHERE PUBLISHMASTER.SKU = '" & arrayString(i) & "';"<br>
updRS.Open updSQL,Connect,adOpenStatic,adLockOptimistic<br>
if i <= recLimit AND (request.form("buttonName"
= "nextButton" OR request.form("buttonName"
= "backButton"
THEN<br>
updRS("ACTIONTYPE"
= request.form(arrayString(i) & "_ACTIONTYPE"
<br>
updRS("SHORTDESCRIPTION"
= request.form(arrayString(i) & "_SHORTDESC"
<br>
updRS("IMAGEFILENAME"
= request.form(arrayString(i) & "_IMAGEFILENAME"
<br>
updRS("DESCRIPTION"
= request.form(arrayString(i) & "_DESC"
<br>
updRS("FEATURES"
= request.form(arrayString(i) & "_FEATURES"
<br>
updRS("DEALERSELLPRICE"
= CInt(request.form(arrayString(i) & "_DEALERSELLPRICE"
) <br>
updRS("DEALERCOST"
= CInt(request.form(arrayString(i) & "_DEALERCOST"
)<br>
updRS("MSRP"
= CInt(request.form(arrayString(i) & "_MSRP"
)<br>
updRS("SELECTEDITEM"
= request.form(arrayString(i) & "_sel"
<br>
updRS.Update<br>
end if <br>
i = i + 1<br>
updRS.Close<br>
next <br>
--------------------------------------------<br>
<br>
Thank you<br>
In an ASP script using VBScript I am having a problem concatenating the parameters dynamically in a "request.form" statement. I know that the referenced fields exist and that they have data. Please help!<br>
<br>
Here is the code:<br>
--------------------------------<br>
for i=0 to ubound(arrayString)<br>
updSQL = "SELECT * FROM PUBLISHMASTER WHERE PUBLISHMASTER.SKU = '" & arrayString(i) & "';"<br>
updRS.Open updSQL,Connect,adOpenStatic,adLockOptimistic<br>
if i <= recLimit AND (request.form("buttonName"
updRS("ACTIONTYPE"
updRS("SHORTDESCRIPTION"
updRS("IMAGEFILENAME"
updRS("DESCRIPTION"
updRS("FEATURES"
updRS("DEALERSELLPRICE"
updRS("DEALERCOST"
updRS("MSRP"
updRS("SELECTEDITEM"
updRS.Update<br>
end if <br>
i = i + 1<br>
updRS.Close<br>
next <br>
--------------------------------------------<br>
<br>
Thank you<br>