recordset error

[-D-]

I have the following recordset: SELECT FTE_CLASS_GROUP_NBR_DSCR FROM
dbo.DLIST_FTE_CLASS_GROUP WHERE FTE_GRP_ID IS NOT NULL I ammended the sql to
the following: SELECT LEFT( FTE_CLASS_GROUP_NBR_DSCR, 7) FROM
dbo.DLIST_FTE_CLASS_GROUP WHERE FTE_GRP_ID IS NOT NULL This removed some extra
characters in the resultset that I didn't need. Problem is, the fieldname in
the resultset is now empty or blank?? I don't know what happened? If go back
to my original sql the fieldname is there and everything works fine. Anyone
know what is causing this? Thanks, -D-

[-D-]

I found the problem...I needed to create an alias for my column in the statement.
Thanks,
-D-

[malcster2]

i'm setting up a recordset in a php page in dm8 , from a small database with 2
tables. i've set up a small sql script to pick up specific data, and that
works. however, when i click ok to complete the setup, i get the message 'TYPE
ERROR: After node has no properties'...please help, i cannot find any help on
dw8 help pages

[Lionstone]

That sounds like the kind of DW error that you'd get after installing a
"rogue" extension that was written either improperly or for a different
version of DW. What extensions have you installed?

"malcster2" <webforumsuser@macromedia.com> wrote in message
news:dkoh5c$fh7$1@forums.macromedia.com...

> i'm setting up a recordset in a php page in dm8 , from a small database
> with 2
> tables. i've set up a small sql script to pick up specific data, and that
> works. however, when i click ok to complete the setup, i get the message
> 'TYPE
> ERROR: After node has no properties'...please help, i cannot find any help
> on
> dw8 help pages
>

[malcster2]

THANKS!! mate, that was exactly what it was. i had installed an extension
designed from dm mx, and i'm running dm 8. cheers.

the extension in question, was from inter akt mx suite, if anyone else should
come across the problem.

thanks again

[Lionstone]

No problem. :)

"malcster2" <webforumsuser@macromedia.com> wrote in message
news:dkqr8n$3ar$1@forums.macromedia.com...

> THANKS!! mate, that was exactly what it was. i had installed an extension
> designed from dm mx, and i'm running dm 8. cheers.
>
> the extension in question, was from inter akt mx suite, if anyone else
> should
> come across the problem.
>
> thanks again
>