Type Mismatch using Format()

[Catherine Lynn Smith]

OK, newbie here - I am trying to figure how how in the heck I can use
the Format command to pre-format integers to display a fixed length
supplimenting leading zeros when needed.

According to the RTFM rigors I have been going through all morning, I
just give Format an expression with the first value being either
numeric or string. But when I try either it spits out a type mismatch
error. I have tried it with the recordset from the SQL, with a local
variable and with a constant value in both string and numeric. I have
tried using various type conversions like CDec or CInt or CStr - I
keep getting the same error. I have tried removing all the optional
parameters and just giving it a value like:

Format(123)

or

Format("123")

I am beginning to realize why I avoided microsoft languages and
platforms for so long - I am about to TTFM (throw the fekkin manual)

Help!

Kathy Lynn

 

[CJM]

Is there a Format() function in VBScript? I couldnt see one...

See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtorifunctions.asp

Of the top of my head, you could do something similar to the following:
sPaddedString = Left('00000', 5-Len(iMyInteger)) & iMyInteger 'For 5-chr
strings/numbers

[PS. I haven't actually tested this!]

Chris

 

[Aaron Bertrand - MVP]

OK, newbie here - I am trying to figure how how in the heck I can use

the Format command to pre-format integers to display a fixed length
supplimenting leading zeros when needed.

There is no format() in VBScript. For padding integers, see
http://www.aspfaq.com/2300

 

[Catherine Lynn Smith]

There is no format() in VBScript. For padding integers, see
http://www.aspfaq.com/2300

oh - hmmm

Then perhaps I am more newbie then I thought - I did a web search on
google for '"visual basic" asp "format function"' and found the
following link. So VBScript does 'not' inherit all visual basic
functions?

http://msdn.microsoft.com/library/d...n-us/vbcn7/html/vaconformatchangesinvbnet.asp

KL

 

[Aaron Bertrand - MVP]

Correct, VBScript is more or less a subset of Visual Basic.

http://tech.irt.org/articles/js117/

http://www.soldierx.com/books/Teach Yourself VBScript in 21 Days/ch20.htm

There is no format() in VBScript. For padding integers, see
http://www.aspfaq.com/2300

oh - hmmm

Then perhaps I am more newbie then I thought - I did a web search on
google for '"visual basic" asp "format function"' and found the
following link. So VBScript does 'not' inherit all visual basic
functions?

http://msdn.microsoft.com/library/d...n-us/vbcn7/html/vaconformatchangesinvbnet.asp

KL[/QUOTE]