How To Display A Memo Field In The Database On My Search Result Page?

[victoria_1018]

Hi all,
I had design a search engine. The whole program is working well except for displaying the remarks field.

Beside the remarks field, which is set to memo in the access database, the rest of the fields are set to text and have no problem when displaying the search result.

I had try ways to solve the problem but did not work. The only way that will make my program work is to change the remarks field in the database from memo to text, which is something I don¡¦t want to as my remarks field contains more than 255 characters.

Dose anyone know how to solve my problem?

Thank You
Regards
Victoria

[victoria_1018]

Sorry, I had forgotten to attach my program:eek:

Regards
Victoria

[whammy]

I haven't run into this problem myself, but I've heard you should select the memo field after everything else...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q175239

http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20187236.html

maybe those will help...

[BigDaddy]

That is true with text fields in sql server. I noticed I wasn't pulling anything back from a text field, along with 2 other fields, so I requested the other 2 first, then the text field. It worked after that.

[victoria_1018]

Hi,
I had read yours suggestion but I still can't get the program work. Is there any other methods to display the memo field and or ortherwise, is there any method to increase the text field characters to around 300?

Thank You Very Much

Regards

Victoria:o

[whammy]

I'm not sure, I did some research the other night and found those two articles, and some stuff on

AppendChunk() etc.

But I didn't find anything definitive. :(

However, I am using memo fields in my Access database with some entries that are probably over 2,000 characters with no problems. Perhaps it's in how you are defining your recordset or something?

:confused:

Can we see some of the code?

[victoria_1018]

Thank You Very Much, whammy. I will look in to it and see where is wrong in my program.

Regards
Victoria:o

[whammy]

Actually you need to use GetChunk() I think...

http://www.w3schools.com/ado/met_field_getchunk.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthgetchunk.asp

However, almost every reference I can find quotes microsoft's page there (the second link) word for word, and I cannot find a reference that makes sense to someone that isn't familiar with it.

Here, I did a bit more reasearch, maybe this will help...

http://www.faqts.com/knowledge_base/view.phtml/aid/4882

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20131614.html#1

http://p2p.wrox.com/archive/vb_certification/2001-11/2.asp

[victoria_1018]

Thank You whammy for taking time to do research om behalf of me.

I will look into it and do more research at the same time. I will let you know once I solve this program.

Regards
Victoria

[whammy]

Good luck. If you haven't solved this tomorrow, please post and I will see if any of the other developers I work with have some working code handy (that's one really cool thing about where I work). :)

P.S. This seemed like the most promising link to me:

http://www.faqts.com/knowledge_base/view.phtml/aid/4882