Spaces being truncated in query / MID function gone?

[hb]

SELECT COUNT(DISTINCT PRES_CYCL_ID)
is being changed to
SELECT COUNT(DISTINCTPRES_CYCL_ID)

If I response.Write the query, I see the space and the query is OK. But
somewhere along the way to the DB, the space is removed between DISTINCT and
PRES_CYCL_ID. What could cause this behavior? Would it also be the same
reason the MID() function stopped working, too?

[Bob Barrows [MVP]]

hb wrote:

> SELECT COUNT(DISTINCT PRES_CYCL_ID)
> is being changed to
> SELECT COUNT(DISTINCTPRES_CYCL_ID)
>
> If I response.Write the query, I see the space and the query is OK.
> But somewhere along the way to the DB, the space is removed between
> DISTINCT and PRES_CYCL_ID. What could cause this behavior?

That is strange. You should view the source of the page to verify that the
sql statement actually has a space there rather than  

It would help to see the code that generates this string.

> Would it
> also be the same reason the MID() function stopped working, too?

Huh? When did the Mid() function stop working?? What are you talking about?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[hb]

> hb wrote:

> > SELECT COUNT(DISTINCT PRES_CYCL_ID)
> > is being changed to
> > SELECT COUNT(DISTINCTPRES_CYCL_ID)
> >
> > If I response.Write the query, I see the space and the query is OK.
> > But somewhere along the way to the DB, the space is removed between
> > DISTINCT and PRES_CYCL_ID. What could cause this behavior?

>
> That is strange. You should view the source of the page to verify that the
> sql statement actually has a space there rather than  

Figured this part out... Needed up update some patches on the oracle client.

> > Would it
> > also be the same reason the MID() function stopped working, too?

>
> Huh? When did the Mid() function stop working?? What are you talking

about?

Good question. The Mid() function in ASP VbScript no longer works. It's an
unrecognized function.

[Bob Barrows [MVP]]

hb wrote:

> Good question. The Mid() function in ASP VbScript no longer works.
> It's an unrecognized function.

Show me how to reproduce the error. You may be attempting to use the Mid()
statement, which has never been supported in vbscript:

s = "abd"
Mid(s,3,1) = "c"
' if this is VB/VBA, s now contains "abc"

as opposed to the Mid() function:

s = Mid("abc",3,1)
's now contains "c"

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[hb]

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:euuBkSDNEHA.1312@TK2MSFTNGP12.phx.gbl...

> hb wrote:

> > Good question. The Mid() function in ASP VbScript no longer works.
> > It's an unrecognized function.

>
> Show me how to reproduce the error. You may be attempting to use the

Mid()

> statement, which has never been supported in vbscript:
>
> s = "abd"
> Mid(s,3,1) = "c"
> ' if this is VB/VBA, s now contains "abc"
>
> as opposed to the Mid() function:
>
> s = Mid("abc",3,1)
> 's now contains "c"
>
> Bob Barrows

Here's the code:

LOC = INSTR(szStructCFG," ") 'note the double space
if MID(szStructCfg,LOC,1) = " " THEN
szStructCFG = LEFT(paramStructCFG,LOC-1)
end if

This code used to work till we rebuilt the web server (Win2k Server). Here
is the error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'MID'

[Ray at]

Take a look at the value of LOC and I think you'll see your problem.

LOC = INSTR(szStructCFG," ") 'note the double space
RESPONSE.WRITE "THE VALUE OF LOC IS " & LOC
if MID(szStructCfg,LOC,1) = " " THEN
szStructCFG = LEFT(paramStructCFG,LOC-1)
end if

Ray at work

"hb" <hbranyan.SPAMBLOCK@merc.mercer.edu> wrote in message
news:2g1p6tF3luf7U1@uni-berlin.de...

> Here's the code:
>
> LOC = INSTR(szStructCFG," ") 'note the double space
> if MID(szStructCfg,LOC,1) = " " THEN
> szStructCFG = LEFT(paramStructCFG,LOC-1)
> end if
>
> This code used to work till we rebuilt the web server (Win2k Server). Here
> is the error:
> Microsoft VBScript runtime error '800a0005'
> Invalid procedure call or argument: 'MID'
>
>
>

[hb]

"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:uZgupDFNEHA.796@TK2MSFTNGP12.phx.gbl...

> Take a look at the value of LOC and I think you'll see your problem.
>
> LOC = INSTR(szStructCFG," ") 'note the double space
> RESPONSE.WRITE "THE VALUE OF LOC IS " & LOC
> if MID(szStructCfg,LOC,1) = " " THEN
> szStructCFG = LEFT(paramStructCFG,LOC-1)
> end if
>
> Ray at work

I think you are right. thanks