Richard Mentecky
|
| Posted: 11/27/2002, 6:24 PM |
|
Has anyone else seen this behavour?
I select a link from a grid that takes me to the record page and the record
is fine but all memos are blank.
I am running ASP/IIS and an Access database.
Thanks,
Rick
|
|
|
 |
DonB
|
| Posted: 11/27/2002, 7:44 PM |
|
I don't have the specifics at hand, but it is an ADO problem/quirk. Also,
be certain that you have "Memo" for the TextArea control (not "Text").
The problem is documented at support.microsoft.com in article Q175239,
"Place the BLOB/Text Fields at the End of the Query."
"Richard Mentecky" <mentecky@adelphia.net> wrote in message
news:as3uoa$cqu$1@news.codecharge.com...
> Has anyone else seen this behavour?
>
> I select a link from a grid that takes me to the record page and the
record
> is fine but all memos are blank.
>
> I am running ASP/IIS and an Access database.
>
> Thanks,
>
> Rick
>
>
|
|
|
|
Richard Mentecky
|
| Posted: 11/28/2002, 8:44 AM |
|
Don,
Thanks for the quick answer.
I read that faq and I did as suggested, even though I am running XP Pro. I
put the BLOB fields at the end of the query, I even moved them to the end of
the table. Still No Go.
I found an ugly work around, but I'd really like to make it work as it
should. I found that Memos work fine in Grids. So, for now I am putting the
record in a grid with a query that qill only return one record.
Thanks for your help,
Rick
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:as43eb$l0g$1@news.codecharge.com...
> I don't have the specifics at hand, but it is an ADO problem/quirk. Also,
> be certain that you have "Memo" for the TextArea control (not "Text").
>
> The problem is documented at support.microsoft.com in article Q175239,
> "Place the BLOB/Text Fields at the End of the Query."
>
>
> "Richard Mentecky" <mentecky@adelphia.net> wrote in message
>news:as3uoa$cqu$1@news.codecharge.com...
> > Has anyone else seen this behavour?
> >
> > I select a link from a grid that takes me to the record page and the
> record
> > is fine but all memos are blank.
> >
> > I am running ASP/IIS and an Access database.
> >
> > Thanks,
> >
> > Rick
> >
> >
>
>
|
|
|
|
Richard Mentecky
|
| Posted: 11/28/2002, 9:42 AM |
|
I found a cleaner fix if anyone is interested. I still have no clue why the
problem occurs though.
In my Memo field I set "Source Type" to Code Expression. I then set "Control
Source" to do a CCDLookup. This seems to work fine.
My control source looks like this:
CCDLookUp("Description", "Games", "GameID=" &
CCToSQL(Request.QueryString("GameID"),"Integer") , DBinternet)
Anyway thanks for the suggestions.
Rick
"Richard Mentecky" <mentecky@adelphia.net> wrote in message
news:as5h5g$amg$1@news.codecharge.com...
> Don,
>
> Thanks for the quick answer.
>
> I read that faq and I did as suggested, even though I am running XP Pro. I
> put the BLOB fields at the end of the query, I even moved them to the end
of
> the table. Still No Go.
>
> I found an ugly work around, but I'd really like to make it work as it
> should. I found that Memos work fine in Grids. So, for now I am putting
the
> record in a grid with a query that qill only return one record.
>
> Thanks for your help,
>
> Rick
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
>news:as43eb$l0g$1@news.codecharge.com...
> > I don't have the specifics at hand, but it is an ADO problem/quirk.
Also,
> > be certain that you have "Memo" for the TextArea control (not "Text").
> >
> > The problem is documented at support.microsoft.com in article Q175239,
> > "Place the BLOB/Text Fields at the End of the Query."
> >
> >
> > "Richard Mentecky" <mentecky@adelphia.net> wrote in message
> >news:as3uoa$cqu$1@news.codecharge.com...
> > > Has anyone else seen this behavour?
> > >
> > > I select a link from a grid that takes me to the record page and the
> > record
> > > is fine but all memos are blank.
> > >
> > > I am running ASP/IIS and an Access database.
> > >
> > > Thanks,
> > >
> > > Rick
> > >
> > >
> >
> >
>
>
|
|
|
|
|
