I currently was working an ASPproject that involved MEMO and TEXT Fields. These two types of fields are the same just called different depending on what database your using. Memo Fields is used in Access 97 and TEXT Fields (or BLOB) is used in MS-SQL 7.0. Writing out these types of field types in ASP is different. I hadn't worked with them in a while until recently and discovered they can be a pain in the butt! I thought to myself, if I'm having problems I imagine I could share this information with my site visitors. I'm always seeing these questions in newsgroups and forums everywhere! Well here you go look no further, here is the method I used in a recent project! Might not be totally 100% certified perfect but, you know what it worked for me! Enjoy its FREE <%
' create conn as adodb.connection and open it
dim strconn
dim conn
dim rs
dim memofield
dim memofield2
'strconn = "Driver={SQL Server};SERVER=127.0.0.1;UID=loginid;PWD=password;DATABASE=yourdbname"
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("text.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn
sql = "select tblMemoFields.id, tblMemoFields.FavoriteSeason, tblMemoFields.FavoriteTree, tblMemoFields.MemoField, tblMemoFields.MemoField2 from tblMemoFields"
set rs = conn.execute(sql)
%>
<html>
<head><title></title>
</head>
<body>
<table border="1" cellpadding="1">
<%
do while not rs.eof
memofield = rs("MemoField")
memofield2 = rs("MemoField2")
response.write "<tr><td><b>" & rs("ID").name & "</b></td><td>" & rs("id") & "</td><td><b>" & rs("FavoriteSeason").name & "</b></td><td>" & rs("FavoriteSeason") & "</td><td><b>" & rs("FavoriteTree").name & "</b></td><td>" & rs("FavoriteTree") & "</td><td><b>MemoField #1:</b></td><td>" & memofield & "</td><td><b>MemoField #2</b></td><td>" & memofield2 & "</td></tr>"
rs.movenext
loop
%>
</table>
</body>
</html> | DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
More Database Code Articles
More By aspfree  developerWorks - FREE Tools!
|
This whitepaper presents the benefits of successfully introducing static analysis into your organization using IBM Rational Software Analyzer. Additionally, it identifies some common pitfalls that can hinder the effective use of static analysis tooling as well as presents 10 simple strategies designed to help you quickly realize the value of static analysis using Rational Software Analyzer.
FREE! Go There Now!
| | | |
Visit IBM developerWorks to download the latest trial version of IBM Data Studio V1.1 at no cost. IBM Data Studio is a comprehensive data management solution that helps you effectively design, develop, deploy and manage your data, databases, and database applications throughout the data management life cycle utilizing a consistent and integrated user interface. Unlike other client-side data management solutions that focus on only one aspect of the application lifecycle or database administration, Data Studio complements the Rational Software Delivery platform, providing unparalleled flexibility for a heterogeneous data server environment across platforms.
FREE! Go There Now!
| | | |
Visit IBM developerWorks to download a free trial of the Rational Host Access Transformation Services (HATS) Toolkit. The HATS toolkit provides a set of plug-ins for the IBM Rational Software Delivery Platform to help you easily extend your legacy applications. HATS makes your 3270 and 5250 applications available as HTML through the most popular Web browsers, while converting your host screens to a Web look and feel and it also enables you to develop new Web, portal, and rich-client applications.
FREE! Go There Now!
| | | |
Manage, govern, and share services across your organization by using WebSphere Service Registry and Repository. Follow the hands-on exercises to learn how to navigate the Web interface to publish, find, reuse, and update services.
FREE! Go There Now!
| | | |
IBM Enterprise Modernization solutions help organizations evolve core IT systems towards modern architectures and technologies—reducing the burden of maintenance and freeing up resources to develop new business requirements and capabilities. With the IBM Enterprise Modernization Sandbox for System z you can evaluate IBM Enterprise Modernization solutions focused on five key areas: Assets, Architectures, Skills, Processes and Infrastructures, and Investment. Each solution is based upon real customer experiences and offers a proven path to get you started with your modernization projects.
FREE! Go There Now!
| | | |
Discover how Rational tools and best practices for testing can make your job easier. The new Rational Testing eKits provide you with valuable resources – including demos, webcasts, tutorials, and articles – that help you address your specific testing needs across the software lifecycle. Five new eKits are available covering the topics of Requirements and Test Management, Functional Testing, Performance Testing, Code Quality and Embedded Systems, and SOA and Web Services Testing.
FREE! Go There Now!
| | | |
As organizations have grown increasingly dependent on online software, the risk of malicious attacks has also become far more serious. Fortunately, well-governed organizations can protect their Web applications by injecting vulnerability assessments and ethical hacks into their software development and delivery processes. This paper describes 12 of the most common hacker attacks and provides basic rules that you can follow to help create more hack-resistant Web applications.
FREE! Go There Now!
| | | |
Visit IBM developerWorks to try the IBM SOA Sandbox for connectivity. The SOA Sandbox for connectivity provides a trial environment with the tooling and components to help you explore how to effectively connect your infrastructure and integrate all of the people, processes and information in your company. Use the hosted sandbox to explore SOA techniques that streamline connecting existing IT assets together, as well as learn how to connect them to new business logic.
FREE! Go There Now!
| | | |
The Eclipse community is constantly working to extend Eclipse's functionality. In this webcast, learn about some of the most important and feature-rich projects under development. From multi-language support to plug-in development, tune in to see what Eclipse is capable of now.
FREE! Go There Now!
| | | |
User communities play an important role in communication and collaboration around products, solutions and other areas of special interest to members. Successful communities are able to provide the right mix of content and services to deliver a value proposition that resonates with each audience. Join Tom Inman, VP of Marketing for Information and Platform Solutions as he introduces the new LeverageINFORMATION community. During this webcast, learn about the value provided by the community and how customers and partners derive value from the community in addressing their own technical and business challenges.
FREE! Go There Now!
| | | |
All FREE IBM® developerWorks Tools!
| |
/ 3 
