PDA

Click to See Complete Forum and Search --> : Data type 'memo' Problem


equuelus
Feb 18th, 2001, 03:18 AM
Greetings,

Guys, I have a problem here. You see, I can't seem to put a memo data type into my database. I need the memo data type because i will be putting articles in the database.

Okey, if putting an article in a database is not good, then how am I going to sort my articles out via a database. Is it by putting the sources of the document in the database does any good? I really need to sort out my articles like the ones in websites that has tutorials in it. Can anybody here are able to solve this problem? Thanks in advance to those who reply.

Shafee
Feb 18th, 2001, 08:17 PM
Are you using an Access database? What is the problem? Are you getting an error?

equuelus
Feb 18th, 2001, 10:23 PM
Yea. I am using Ms Access. I'm getting an error for inserting data into the database. The datatype i am inserting into the field of the database is 'memo'. Does Ms. Access suport this feature?

Okey, lets get things more simpler here. What I am trying to do is a web-based learning system that enables students to learn online and teachers submit tutorials online. The question is how should I sort those tutorials? Sould I insert the tutorial in the database itself or make a new text file for every single tutorial and stores the path for the text file in the database. The tutorial will also include graphics.

Another thing, if the best solution is creating new txt files for every tutorials, could you please provide me information about the properties and method of creating a new text file. Thanks in advance.

Shafee
Feb 20th, 2001, 04:30 AM
Access databases support memo data type.
If you insert the tutorial in the database, you do not need to create a text file for each tutorial. You can use asp to do the job.


Set con = Server.CreateObject("ADODB.Connection")
Set rst = Server.CreateObject("ADODB.Recordset")
con.Open myconnectionstring 'Set the connection string as you want.
rst.CursorType = 3
rst.Open "YourTable", con

'Suppose your memo field is Tutorial

Response.Write rst("Tutorial")