split problem

[daveigh]

Why do i seem to get this error:

Microsoft VBScript runtime error '800a000d'
Type mismatch

On this line:
ref = Split(rs("referrer&quot)

???


_______________CRYOcoustic_____________

 

[tsuji]

Hello daveigh,

<quote>
Returns a zero-based, one-dimensional array containing a specified number of substrings.

Split(expression[, delimiter[, count[, compare]]])
Arguments
expression 
Required. String expression containing substrings and delimiters. If expression is a zero-length string, Split returns an empty array, that is, an array with no elements and no data. 
delimiter 
Optional. String character used to identify substring limits. If omitted, the space character (&quot; &quot;) is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned. 
count 
Optional. Number of substrings to be returned; -1 indicates that all substrings are returned. 
compare 
Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values. 
</quote>

So basically you ask yourself, split with respect to what "delimter".

regards - tsuji

 

[daveigh]

changed my code to:

ref = Split(rs("referrer&quot,",&quot

still it returns the same error..

_______________CRYOcoustic_____________

 

[tsuji]

daveigh,

There usually is no magic. You have to make sure rs("referer&quot return a string.

- tsuji

 

[daveigh]

yes, there is. i tried to debug it by using response.write rs("referrer&quot and this string appears:

,google,

and what i wanted to do is to display it this way:


google

thats why i used split with a delimeter of "," but that error appears...

_______________CRYOcoustic_____________

 

[PHV]

Have you tried this ?

ref = Split(CStr(rs("referrer")),",")

Hope This Help
PH.

 

[daveigh]

yes i tried, PHV, but the same error occurs...tnx for ur help anyway...im still debugging it...


_______________CRYOcoustic_____________

 

[JayValkyr]

Heya Dave..

Why don't you just use replace functionality..

Ref = replace(rs("referrer&quot, "," ,"&quot

Should do the trick

Jay

 

[mrmovie]

well, you should get the same error message if you try and use the replace function. thats assuming you have implemented the split function correctly

i would go so far as to explicitly set all the param

aArray = Split(CStr(rs("reffer&quot, ",",-1,1)

if that still doesnt work then you either are not returning a string or should i say something that cant be converted to a string, or its null i guess.

check the variant type before each split call and also check for IsNull

 

[JayValkyr]

Heya again..

The following line will split your "referrer" column into an array:

ref = Split(rs("referrer&quot,",&quot

If you try to use this ref variable without an array number you'll end up with the type mismatch error message.
->

wscript.echo(ref) 'will return that error message

Actually you'll have an array with 3 columns according to your ",google," example (2 commas = 3 columns )

wscript.echo(ref(0)) 'will return an empty value
wscript.echo(ref(1)) 'will return google
wscript.echo(ref(2)) 'will return an empty value

So I'd suggest you to replace those commas rather that split your recordset value into columns..
In case you don't really need all those splitted values..

Jay