Solved

CreateParamter for Memo Field in ASP and Access

Posted on 2004-04-28
4
602 Views
Last Modified: 2012-08-14
I am using ASP and ACcess. What should I give in the CreateParameter function for vartype for MEmo field in the backend which is MS Access.

CMD_ISMP_INFO.Parameters.Append CMD_ISMP_INFO.CreateParameter("Description",adVarChar,adParamInput,255)
   


0
Comment
Question by:tech_question
  • 3
4 Comments
 

Author Comment

by:tech_question
ID: 10938974
CMD_ISMP_INFO.Parameters.Append CMD_ISMP_INFO.CreateParameter("Description",?,adParamInput,?)
   

Please fill in the "?" marks , the Description field is a Memo Field in Access Database. I am using ASP as front end .
0
 
LVL 11

Accepted Solution

by:
Slimshaneey earned 500 total points
ID: 10939013
Change adVarChar to

adLongVarChar
0
 
LVL 11

Expert Comment

by:Slimshaneey
ID: 10939030
ie
CMD_ISMP_INFO.Parameters.Append CMD_ISMP_INFO.CreateParameter("Description",adLongVarChar,adParamInput)
0
 
LVL 11

Expert Comment

by:Slimshaneey
ID: 10939071
If it throws an error for not specifiying the length, try this:
CMD_ISMP_INFO.Parameters.Append CMD_ISMP_INFO.CreateParameter("Description",adLongVarChar, adParamInput, 2147483647)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now