Hi,

I am using the following piece of code to populate a DB from a form.

dim intCounter
For intCounter = 1 To Request.Form.Count
    Dim sFormElementName
    sFormElementName = Request.Form.key(intCounter)
    Dim sFormElementValue
    sFormElementValue = Server.HTMLEncode(Request.Form.item(sFormElementNa me))
    If sFormElementValue <> "" And sFormElementValue <> "No Answer" And sFormElementName <> "Submit" And sFormElementName <> "page" Then
        oRSallUsers(sFormElementName) = sFormElementValue
    End If
    oRSallUsers.Update
Next


For some reason it won’t populate fields in the DB of ‘memo’ type, but works just fine on all other data types. I’m using an Access DB. Any help would be much appreciated.

Thanks, Mischa

Can you do a response.write of sFormElementValue and see if the memo field values get stored into this properly?

Are you using a <textarea>in your form for getting the memo field value? Can you post that html code too?

Cheers!

_________________________
- Vijay G
Strive for Perfection

Vijay,

I actually had a “Response.Write” like this in the code, but I removed as it wasn’t directly involved with the DB issue. It writes the value just fine, so the “memo fields” are being stored properly.


Sure, html code from form:

<form action="signUp.asp" method="post" name="signUpInfo" id="signUpInfo">
    â€¦.
<textarea name="DescribeYourSelf" cols="50" rows="4" id="DescribeYourSelf"></textarea>
….
</form>


Thanks, M

Mischa,

Just noticed. You are using this code within your FOR loop. Anyways I don't think that would be the cause for not getting your memo field values in the DB.

oRSallUsers.Update

Can you move that outside the FOR loop? because this tries to update the DB for every field and hits the DB many times which can be done at the end after storing all the values in the recordset.

Also I believe you are just doing an update, as I don't see an ADDNEW() method there before the FOR loop.

Can you post some sample data that you are trying to update in the memo field. I would like to take a look at it if that could give us some clue.

Just a thought, why don't you construct an SQL statement for UPDATE and run that from you ASP page and see if that too fails to do the job?

Cheers!

_________________________
- Vijay G
Strive for Perfection

Hi
 access this link to have an idea of accessing memo fields

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=138

Magically this started working again! I mean it – like magic. I ran it again with the field as ‘memo’ and it got correctly populated. Tried it a bunch more times: no problem. Maybe I was working too long yesterday – started to lose it.

Anyway, thanks, gents

Hi Mischa,

Glad, that it works. But wondering if there was any change made to get that worked.

Cheers!

_________________________
- Vijay G
Strive for Perfection