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/de...ifunctions.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]

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message news:<Oi**************@TK2MSFTNGP12.phx.gbl>...

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

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/de...gesinvbnet.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%...0Days/ch20.htm


"Catherine Lynn Smith" <kl*****@hotmail.com> wrote in message
news:5f**************************@posting.google.c om...

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message news:<Oi**************@TK2MSFTNGP12.phx.gbl>...

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

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/de...gesinvbnet.asp
KL