Date & Dynamic Text

[WebSlave]

I have a news systems and I am having trouble displaying both the date from the database and the text.

Here is how my page is layed out:

HEADLINE (DATE (date/time in sql server)
Story (text) in sql server.

If I remove DATE then the Story Shows up.

Please advise.

Using 8.0.2 Update

[Newsgroup_User]

Hi,

When creating the recordset, you need to specify, by name, each field in the
SELECT statement and make sure that any (text) fields are last to be
specified.
SELECT date, story FROM table...etc as opposed to SELECT * FROM
table....etc.

When you remove date, only one field exists so story would display, I think!
:o)
Again, just a guess, but it sounds like it might be this. Hope this is
useful.

Regards
Nath.

"WebSlave" <webforumsuser@macromedia.com> wrote in message
news:ee21hc$giu$1@forums.macromedia.com...
>I have a news systems and I am having trouble displaying both the date from
>the
> database and the text.
>
> Here is how my page is layed out:
>
> HEADLINE (DATE (date/time in sql server)
> Story (text) in sql server.
>
> If I remove DATE then the Story Shows up.
>
> Please advise.
>
> Using 8.0.2 Update
>
>
>
>