[thelist] Converting VBScript from Access to SQL

Eric Engelmann eric.engelmann at geonetric.com
Tue Nov 19 20:24:01 CST 2002


1. Make sure you have Option Explicit on at the top, and have dimmed all
variables.

2. Make sure you DO NOT have On Error Resume Next up above somewhere.

3. Step through it, response.writing the variables out at each step, so you
know where the error is.

For example, Response.Write the "zip" variable to make sure you actually
have something to Split, and then loop through. If its blank, then you have
no loop, and no update.

4. Actually, where is "zip" defined? Am I missing something?

zipcode_array = Split(zip,",")

maybe should be

Dim zip
zip = RS.Fields("zip").Value
zipcode_array = Split(zip,",")

?

- Eric






More information about the thelist mailing list