Determine of var is String or Array

[!TG]

How do I determine if a variable is an array or a string?
I want to send a variable to a function, but sometimes it will be an
array and sometimes a string.
Each must be treated differently I assume.
I want to write string to DB field and Array in as comma separated
string to DB Field

 

[Ray Costanzo [MVP]]

IsArray maybe? What language are you writing in?

http://msdn.microsoft.com/library/en-us/script56/html/vsfctIsArray.asp

TypeName?
http://msdn.microsoft.com/library/en-us/script56/html/vsfctTypeName.asp


Download WSH documentation:
http://www.microsoft.com/downloads/details.aspx?FamilyId=01592C48-207D-4BE1-8A76-1C4099D7BBB9

Ray at work

 

[!TG]

IsArray maybe? What language are you writing in?

http://msdn.microsoft.com/library/en-us/script56/html/vsfctIsArray.asp

TypeName?
http://msdn.microsoft.com/library/en-us/script56/html/vsfctTypeName.asp


Download WSH documentation:
http://www.microsoft.com/downloads/details.aspx?FamilyId=01592C48-207D-4BE1-8A76-1C4099D7BBB9

Ray at work

That worked, Thanks!
VBScript was the language

 

[!TG]

IsArray maybe? What language are you writing in?

http://msdn.microsoft.com/library/en-us/script56/html/vsfctIsArray.asp

TypeName?
http://msdn.microsoft.com/library/en-us/script56/html/vsfctTypeName.asp


Download WSH documentation:
http://www.microsoft.com/downloads/details.aspx?FamilyId=01592C48-207D-4BE1-8A76-1C4099D7BBB9

Ray at work

Would you happen to know now how I can put the values into a string now?
My code is:
ThisArray = Array("Hi","There","How","Are","You")
dim x
For Each x in ThisArray
sLIN = cstr(ThisArray(x))
Response.Write(sLIN)
Next

That returned Type mismatch: 'Hi'

Trying to write ThisArray(x) directlt also gives the same error

 

[Tim Williams]

response.write join(ThisArray," ")

Tim

 

[Roland Hall]

in message
: response.write join(ThisArray," ")

If delimiter is omitted, space is used: Response.Write join(ThisArray)

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp