Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 problem with memo fields		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

n8pbm
Junior Member

USA
212 Posts
Posted - 24 August 2003 :  20:18:18  Show Profile  Visit n8pbm's Homepage
I have customized the registration forum to send a email to me if someone wants to join our club along with joining the forum. There are a few fields they need to answer to qualify for membership. One of those fields is a memo field in Access. The problem I am having is the email sends all the information except that memo field. I tried to put it in a variable first but still have the same results. So now I am out of ideas. Anyone want to give me suggestions?

Here is my custom code:

strsubject = "GLPUC Registration "
				strMessage = "Hello Mike"  & vbNewline & vbNewline
				strMessage = strMessage & "The following member wishes to join GLPUC: " & vbNewline
				strMessage = strMessage & "Name: " & rsKey("M_FIRSTNAME") & " " & rsKey("M_LASTNAME") & vbNewline
				strMessage = strMessage & "Trailer: " & trim(rsKey("M_TRAILER")) & vbNewline <--This one does not show up.
				strMessage = strMessage & "City: " & chkString(rsKey("M_CITY"),"SQLString") & vbNewline
				strMessage = strMessage & "State: " & chkString(rsKey("M_STATE"),"SQLString") & vbNewline
				strMessage = strMessage & "Tow Vehicle: " & strETow & vbNewline
				strMessage = strMessage & "Username: " & chkString(rsKey("M_NAME"),"SQLString") & vbNewLine
				strMessage = strMessage & "Email: " & chkString(rsKey("M_EMAIL"),"SQLString") & vbNewline 
				strMessage = strMessage & "Homepage: " & chkString(rsKey("M_HOMEPAGE"),"SQLString") & vbNewlin

M_TRAILER is a memo field that does not show up in the email. I do get the Trailer: part, just no data after it.

Thanks
Mike
Great Lakes Pop Up Club Camping

Doug G
Support Moderator

USA
6493 Posts
Posted - 24 August 2003 :  21:04:10  Show Profile
You could put a response.write rsKey("M_TRAILER") in the code for debugging, just to see if you're getting the memo data from the database or not.
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 25 August 2003 :  05:21:36  Show Profile  Visit HuwR's Homepage
what does your select statement look like ? ie what order are you defining the fields in the select statement, make sure that the meo field is the last field in your select statement
Go to Top of Page

n8pbm
Junior Member

USA
212 Posts
Posted - 25 August 2003 :  08:07:45  Show Profile  Visit n8pbm's Homepage
I did not know it made a difference where the memo field is in the select statement. I know it is not last in the SQL statement. What if you have more than one memo field? Do you put them all last in the SQL statement?

I'll try moving the field and also do a response.write for debugging if it does not work.

Thanks
Mike
Great Lakes Pop Up Club Camping
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 25 August 2003 :  09:18:37  Show Profile  Visit Gremlin's Homepage
Yes move all the memo fields to the end of the query.

Bit of info on why here

http://www.learnasp.com/learn/faqdbmemo.asp
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=80
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 25 August 2003 :  13:10:37  Show Profile
quote:
Originally posted by n8pbm

I did not know it made a difference where the memo field is in the select statement. I know it is not last in the SQL statement. What if you have more than one memo field? Do you put them all last in the SQL statement?

I'll try moving the field and also do a response.write for debugging if it does not work.

Thanks

Some versions of MDAC and ADO have problems when blob fields are not at the end of the select statement. Some versions don't seem to care. To be safe, just get in the habit of putting blobs at the end of your selects.
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

n8pbm
Junior Member

USA
212 Posts
Posted - 28 August 2003 :  17:57:45  Show Profile  Visit n8pbm's Homepage
Thanks for all the information. It appeared I had two problems. I did not have the memo field last in the SQL statement and I refered to it twice. after fixing both it is now working.

Thanks again - the links helped.
Mike
Great Lakes Pop Up Club Camping
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 29 August 2003 :  03:33:05  Show Profile  Visit Gremlin's Homepage
Glad to hear you got it working.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.41 seconds. Powered By: Snitz Forums 2000 Version 3.4.07