Re: Mid function

On Apr 13, 1:49 am, allinris...@xxxxxxxxxxxxxx wrote:
On Apr 12, 9:52 pm, "Bob Butler" <no...@xxxxxxxxxxx> wrote:





<allinris...@xxxxxxxxxxxxxx> wrote in message

news:f626b9de-ee43-4f64-a8bc-b8cd691d07c3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi Friends

what happened to the mid() function?

I am really baffled. I have many other applications where I use the
mid function and they work fine.

but when i started working on a new project, it throws an error
invalid procedure call or argument

there is nothing complicated in the code
someVariable=mid(aStringVariable, 1, 5) ... that would extract the
first 5 characters of aStringVariable

I even tried CopyPasting a working piece of code from an OLD project.
It works fine in the OLD Project
But in the new project throws the above error

Any Microsoft mischief?

(In an ASP page also the samething happens)

My guess is that you have created a variable named 'mID' or a procedure or
module or something named 'mid'.  In regular VB I'd also suggest checking
Tools / References for anything flagged 'missing' but if the same code as
ASP produces the error then chances are it's a naming collision.  You can
try using VBA.Mid() instead and it that works then either you, or some
object you have referenced, has something named 'mid'.- Hide quoted text -

- Show quoted text -

..but Bob, this is not an isolated case. when I googled I have come
across people who had the same problems Not only with mid, but left,
right, instr also
As I see, it is something going wrong with the string functions. And
surprisingly, It works for a while say one or two days, then starts
throwing error..
again, it may rectify itself without anything being done. really Odd!

and while googling I had come across postings to the effect **mid
function is never supported in vba and asp** and **mid is an
unrecognized function** etc etc

try googling 'asp/vb mid function error' or similar phrases, you shall
see for yourself..

anyway, can anybody suggest an alternative for mid function?

Thanx- Hide quoted text -

- Show quoted text -

....I suspect some automatic updates is the culprit..
.

Relevant Pages

  • Re: Mid function
    ... invalid procedure call or argument ... first 5 characters of aStringVariable ... Tools / References for anything flagged 'missing' but if the same code as ... try googling 'asp/vb mid function error' or similar phrases, ...
    (microsoft.public.vb.general.discussion)
  • Re: Mid function
    ... I have many other applications where I use the ... invalid procedure call or argument ... In regular VB I'd also suggest checking Tools / References for anything flagged 'missing' but if the same code as ASP produces the error then chances are it's a naming collision. ...
    (microsoft.public.vb.general.discussion)
  • Re: ECC Performance on Processors
    ... In article, flip wrote: ... > does anyone know of any references (I've been googling all day and found ... > some dated sort of stuff) to performance numbers for things like ECDSA, ...
    (sci.crypt)
  • Re: How to pick Home and Away results from a list
    ... adapted it to suit actual references and some extra data ... To extract the "Home" data enter this formula as an array using the key ... The Venues column will have random order E.G. H,A,H,H,A,H,A etc ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Great bleeding hunks of Wagner
    ... Terry Simmons wrote: ... I tried googling it and got 31 references and the question did I mean ... for the Ride of the Valkyries, arranged by Sir Thomas ...
    (rec.music.classical)
Loading