Dynamic Variable Array in ASP (Form Text Input)

[brainlpb]

I'm trying to adapt a PHP shopping cart code to ASP:

The cart outputs the SQL product list to a HTML a page where the client enters the quantity they want of each SKU:

<FORM ACTION="page.as p" METHOD=POST>
<INPUT TYPE="TEXT" NAME="SKU[123451]" SIZE="3" VALUE="">
<INPUT TYPE="TEXT" NAME="SKU[123452]" SIZE="3" VALUE="">
<INPUT TYPE="TEXT" NAME="SKU[123453]" SIZE="3" VALUE="">
<INPUT TYPE="TEXT" NAME="SKU[123454]" SIZE="3" VALUE="">
</FORM>

Is there a quick way (ie an array method) without having to parse the entire Request.Form string manually? PHP uses a foreach string that is arranged differently than ASP.

I need ASP code to loop through and find each SKU/QUANTITY in Request.Form to run SQL insert commands:

INSERT INTO product (QUANTITY, SKU) values (x, '123451')
INSERT INTO product (QUANTITY, SKU) values (x, '123452')
INSERT INTO product (QUANTITY, SKU) values (x, '123453')
INSERT INTO product (QUANTITY, SKU) values (x, '123454')

Thanks!

[markrawlingson]

I would use this...

<%
For Each oItem In Request.Form
     If InStr(oItem,"SKU") > 0 Then
          sSQL = "INSERT INTO product (QUANTITY, SKU) values (" & Request.Form(oItem) & ", '" & oItem & "')"
     End If
NEXT
%>
 

oItem is the name of each object within the Request.Form object. So for your example, it would represent SKU[123451] - To get the data from that object you Request.Form(oI tem)

It's basically a dynamic loop through everything that was submitted in the form on the previous page. I've put an If statement in there for you because you don't want to insert a new record into your database unless it's an actual item (if you had something like a hidden form field, or checkbox - it would throw an error)

[brainlpb]

Many thanks!

Is there a way to see that SKU[12345] is an array though without having to Left, Mid, or Right "SKU[" & "]" out of the variable?

[markrawlingson]

You mean you want to detect whether the object has "SKU" within it.. like if you wanted to check SKU[123456] to see if it contained the word "SKU" ?

That's what Instr() does.

Instr(stringtoc heck, string to search for)

Returns a numerical value indicating the amount of times your search term was found within the string.

[brainlpb]

No, just strip the SKU[] wrapper on the fly rather than like:

SKU = Replace(oItem," SKU[","")
SKU = Replace(SKU,"]","")

PHP seems to be able to figure out that

SKU[12345]

is

SKU = "12345"

without all the manual parsing... and pairs it with the appropriate quantity.

[brainlpb]

It all seems so simply done in PHP:

foreach ($_REQUEST['pricing'] as $pricingID => $quantity) {
if (intval($quanti ty) > 0) {
$invoice->addRegistratio n($pricingID, intval($quantit y));
}
}

[markrawlingson]

That depends on the scenario really. For your situation if you wanted to strip the SKU[] and just keep the 123451 value.. my collegue and i wrote a nice function for it...

 
  Function Val( sValuePrivate )
    Set oRegExp = New RegExp
    oRegExp.Pattern = "[^0123456789\.]"
    oRegExp.IgnoreCase = True
    oRegExp.Global = True
    Val = Abs( oRegExp.Replace( "0" & sValuePrivate, "" ) )
    Set oRegExp = Nothing
  End Function
 
 

This function basically tears out all string values and leaves you with just a numerical value. For instance.. SKU[123456] will return as 123456. "hello my name as mark" will return as 0 because it does not contain a numerical value.