Arrays & Disarray

Results 1 to 3 of 3

Thread: Arrays & Disarray

  1. #1 Guest

    Default Arrays & Disarray

    I&#039m trying to use an array to hold a value generated by a stored procedure (generated via "objCmd.Parameters("@NewKey")" phrase seen below). But, when i try and store it in an array (e.g., strIListKey(1)) i get a type mistmatch error. If i store it in just a plain, vanilla strIListKey it works fine. Any idea why the different behaivor between an array and non-array?<BR><BR>dim strNoWorks(3)<BR>objCmd.Execute<BR>strWorks = objCmd.Parameters("@NewKey")<BR>strNoWorks(1) = objCmd.Parameters("@NewKey")<BR><BR>Any help on this? I search the FAQ&#039s, etc. without avail.<BR>Thanks!<BR><BR>.rob adams<BR>

  2. #2
    Sateesh Guest

    Default RE: Arrays & Disarray

    Check for the single or double quotes in the string that you are assigning to the array, you cannot store variables with quotes in an array

  3. #3
    Join Date
    Dec 1969

    Default RE: Arrays & Disarray

    you might try .text or .value as well, as in <BR>strNoWorks(1) = objCmd.Parameters("@NewKey").text OR<BR>strNoWorks(1) = objCmd.Parameters("@NewKey").value

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts