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" = "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>