Information From A Memo Field
I don't know what i am doing wrong. I have an access database,and One of my fields is
Memo format. So when i try to display the information in that field, I was unable to do so, nothing would come up in IE. but the data is there in the fields.something like this.
response.write(rs("description"))
when i changed the field to "text" format, everything worked perfectly fine, ASP was able to display the information stored in that field. But when i changed it back to memo, it would display nothing.is there like a special way of displaying information stored in a Memo field?
View Replies
ADVERTISEMENT
Here is what I am trying to do
filecont = objRS("contents")
filecont = replace(filecont,vbLF,",")
if i use the objRS instead of the filecont in the replace function i get the
same issue. If I do anything with this field (use InStr, or other menial
functions) I get no records can be displayed. The contents field is a memo
field within Access, i am wondering if this is causing the issue?
View Replies
View Related
I have an Access 2000 db with a memo field.Into the memo field I put text with bold attributes, URL etc etc
What I need to to is converting the rich text contained into the memo
field in plain text.That's because I truncate the string text but if, when I truncate it
there's a rich tag the code following the truncated string is corrupted.Don't know if it's clear enough.
Just to summarize:
1) memo field cointaining rich text
2) I need to transform it in plain text
View Replies
View Related
I know how to display a text field from an mdb file. You type: <%= CmdPopulateStates("fieldname") %>
where CmdPopulateStates is declared as:
Set CmdPopulateStates = Server.CreateObject("ADODB.Recordset")
But if 'fieldname' was a memo field rather than text field then the information isn't displayed. In fact, if it's anything other than text then it won't be displayed. How do I display other field types?
View Replies
View Related
i'd like to know if there is some way to detect whether a field is of type MEMO (i'm using MS Access) so to behave accordingly placing a textarea instead of a textbox in the UI.
View Replies
View Related
I have several asp pages that display information from an Access DB. Some of the fields are memo fields. If I use simpler queries such as:
SELECT * FROM " & MyTabla & " WHERE " & MyCriteria
the memo fields are retrieved and displayed Ok.
However, if I use more "complicated" queries such as:
SELECT " & selecti & " FROM " & MyJoin & " GROUP BY " &grupi & " HAVING " & MyCriteria
the memo fields get truncated after the first 255 characters, i.e. only the first 255 characters are returned, but the fields are larger and get retrieved ok if I use the "simpler" queries!
View Replies
View Related
I can't print the contents of an Access memo field. Every other field type displays fine but this one.
I saw an old thread saying that you should first assign the memo field to a variable but that also doesn't seem to work (please see the attached bit of code). The memo field is "Message". Code:
View Replies
View Related
I have a DSN connection for MySql with Asp. Used Text
field[Memo] to store the data. While displaying the data
its gives the error,if field is empty. But works well if
not empty. So pls help me to check the text/memo field
for empty/null. How?
View Replies
View Related
I am using access Memo field to store text of large size. If I use <%=memofield%> in simple display, it does not look like a formatted field and all text comes in a single line without any break.
Even If the text is same like what I am posting in this thread, out come will not have break in browser's display.
View Replies
View Related
i am testing if my memo field (access DB) has anything in it by doing
if isnull(rs("memofld")) then
do this
end if
The script is not picking up a valid value if it is null or not. I have also tried testing for it equalling "" but no lick either.
Read alot of stuff online with people having the same problem but no luck. I have tried selecting the memo field last in the sql query but this makes no difference.
View Replies
View Related
I have a memo field in my recordset that will have varying amounts of text inserted into it from an online form. This is then uploaded to a table cell. At the minute it is just going in one long line across the table. How can I get this text to wrap or line break at a table width of say 500px. Is this an html or asp solution?
View Replies
View Related
I have been doing adodb connections and using Access2000 for several lightweight websites. I have never had any problem with any of the SQL commands to insert, update, delete, etc.
I can insert a record into a memo field just fine ... up to a certain number of characters (nowhere near the 65K limit). After several hundred characters, the insert fails ... nothing happens ... the execute just idles and no insert is done. Anyone help? I have read about data types, etc., but everything I read sounds as if ASP and Access 2000 are suppose to handle the type conversions. They have been doing it up to this certain size.
View Replies
View Related
I'm using asp to retrieve data from a server and import that data in a client that uses MSAccess, into a memo field. The text hes line breaks 0D 0A (the usual DOS line breaks). However the client sees these line breaks as two squares!
The strange thing is that when I look at the exported text (yes, I also export text from the client to the server), it also contains the same line breaks. So the exported text from the memo field can look exactly the same as the imported text, and before the export the line breaks are correctly shown als line breaks, but after the import that same line breaks are shown as squares! I would like to see line breaks after the import and NO squares.
View Replies
View Related
I'm trying to insert this text into a memo field:
Set cnn = CreateObject("ADODB.Connection")
str = Server.MapPath("database/alumni.mdb")
strDB = "Provider=MICROSOFT.JET.OLEDB.4.0;Data Source=" & str
cnn.Open strDB
Set rst = CreateObject("ADODB.Recordset")
sql = "INSERT INTO tblMessage (MessageID, UserID, PostTypeID, Subject,
DatePosted, MessageText, Active) Values ('" & vMessageID & "','" &
vUser & "', " & vPostType & ",'" & vSubject & "','" & vDatePosted &
"','" & vMessageText & "',0)"
rst.Open sql, cnn, adOpenStatic, adLockOptimistic
vMessageText = "This is a test just to see if it will blow up on a
large comment. Just testing again. Don't mind me."
Can I put this into my database field or is it too much and if not,
how do I solve this issue. I need to be able to post messages and
input for large fields.
View Replies
View Related
Can anyone tell me on how to retain the information that was being key in previously and mark which field was being filled in incorrectly rather than reset all the field to previous value?
I have done checking like this but i think it is not quite user friendly:
function verifyBlank(thisForm){
if (thisForm.TeachersName.value == "none" || thisForm.Lab.value == 0 || thisForm.Class.value == 0 || thisForm.Subject.value == 0 || thisForm.PeriodFrom.value == 0 || thisForm.PeriodTo.value == 0 || thisForm.Day.value == "none" || thisForm.Month.value == "none" || thisForm.Year.value == "none")
{
alert('Incomplete information');
return false;
}
return true;
}
View Replies
View Related
I'm trying to delete some record information but only a set number of fields. when i run the following, it deletes all the record and not the field information in the given records:
set rs = server.CreateObject ("adodb.recordset")
StrSql = "DELETE field4, field5, field6," _
& " field7, field8, field9" _
& " FROM tblStock" _
& " WHERE field1 ='" & Request("loc") & "'" _
& " AND field2 ='" & Request("pdt") & "'" _
& " AND NumberOut =" & Request(" numberout")
'DEBUG ONLY
'Response.Write StrSql & "<br>"
'Response.End
cn.Execute StrSql
View Replies
View Related
I've been searching for an answer to this for quite some time now and have found nothing, so maybe (hopefully) someone out there will be able to help me.
At my work, we have a lot of folders for different jobs we've done. And right now, we have more than one person making the folders for all the new jobs that we get. I am trying to make a database were it will only show the jobs that have not had folders made. In order to do this, I've created a field titled "Initials". I want the webpage to pull up all the records where the Initials field is empty, but I'm having trouble doing that. I've tried a few different things and have found no success.
I'm not having a problem accesses the database or updating it, just displaying the right information. I'll give a little illustration (because I'm never good with words):
Say I have 3 jobs: Job #1, Job #2, and Job #3. Someone has already made job folders for Job #1, but Job #2 and Job #3 still need to be made. Since Job #1 has been made, that means there are initials in the initials field of the database and thus, I do not want that Job being displayed on the "To Be Made" page. Job #2 and Job #3 do not have initials in the initials field and as such, I want to display those jobs....
View Replies
View Related
I am designing a website and integrated database for my company. In one of my pages I print out a report in which there are many text fields. I create a query and populate an html table based on the results. A major problem I am having is that when I output a memo string to a cell all of the returns that have been recorded in the string show up as spaces. I know that the returns are indeed there, evidenced by printing out correctly in Microsoft Access.I need to find a way to recognize the returns, because this page is intended to be a somewhat formal report.
View Replies
View Related
this is really urgent and i cant seem to figure this out.I have his text area, once the user hits the save button, it tranfers the data to a memo datatype field in the database.
ok here's the thing...every time I copy paste something, this thing throws up a wierd error..:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '('text here....
I initially though it would ahve been becuase of the number of characters, but that was not the case.When i type things in and save , e'thing works fine
View Replies
View Related
i have an access database which i am displaying on a .asp page-the field i am using is a memo filed full of formatted text.
The code i have been used to using to keep the memo text formatting is: -
[<%=Replace(Recordset1.Fields.Item("Description").Value,chr(13),"<br>")%>]
But the site was created by someone else and the way they place this content is: -
[<%=productdescription%>]
Which obviously does not keep the memo text formatting
View Replies
View Related
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
When I cheked the code, the problematic line was:
rs_durandal("titulo")= rs("titulo")
rs_durandal("titulo") is a Varchar field in MYSQL, while rs("titulo") is a Memo field in Access.How can I solve this problem?
View Replies
View Related
I have built a search feature for a site which searches 4 fields,2 in one table and 2 in another.It's an Access database.It works a treat when searching for anything except something like "I'd", or "it's" etc.Anything with a hyphen in returns one result,or less than there in fact are.
My SQL statement is as follows:
strSQL = "select id as strID, tableID as strTableID, tagline as strTagline, content AS strContact FROM news where tagline LIKE '%" & searchString & "%' OR content LIKE '% " & searchString & "%' UNION ALL select id as strID, tableID as strTableID, tagline AS strTagline, content AS strContent from databank where tagline LIKE '%" & searchString & "%' OR content LIKE '%" & searchString & "%' ORDER BY strID"
View Replies
View Related
This is my first post here. I have been looking everywhere on the forums and
all over the net but i cannot find anything about this.
I did find one tutorial ages ago but didnt have a use for it at the time.
What i would like to do is have a page that cycles through a database and
display lets say the last 5 new records. Then display the first 200
characters of a memo field and have a "more" link which opens the full
record in a detail page?
View Replies
View Related
What would be the maxlength and size attribute of a Text Field in HTML where the backend Access Database field is of Memo Type?
View Replies
View Related
I need to be able to retieve variable length (>255 characters) messages which have been saved in a memo field in an access data base on the server. I am using the following code to test this : -
<%
set objconn = server.createobject ("ADODB.connection")
set objrec = server.createobject ("ADODB.recordset")
objconn.open "DSN=daters"
strsql = "SELECT DISTINCT messages.* FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,adcmdtext
%>
<%=objrec("text")%>
The message is found and retrieved but truncated to 255 characters as if it were an ACCESS text field not a memo field.
The message which is originally user created on another page, writes in full to the ACCESS memo field. Also, if I download the data, and retrieve the message offline via an ACCESS form, it displays fully. Seems then like an ADO issue in retrieving memo fields Probably my syntax?
View Replies
View Related
I stored several lines of information in a Access memo field.I use follow ASP response.write statement to display contain of the memo field.
Response.Write sa1("job_detail")
However, all the lines are mixed into one line. How can I show it in the original format?
View Replies
View Related
I have a memo field being called from the DB that needs to be outputted on screen. Every line that prints needs to be numbered whether the new line is formed from a text wrap or from a CrLf.
I am currently counting characters, when I reach 95 I insert a CrLf, increment the linecount, write the new line number and continue outputting. If a CrLf occurs before the 95 it simply increments and continues.
I also restrict the linecount to 40 before inserting a page break in case the output needs to be printed out. Code:
View Replies
View Related
I have an ASP that displays two MS Access memo fields in separate table cells just fine. However when I concatenate them with SQL as in "select fld1 & fld2 as temp...." to display them in one cell only part of the first field is displayed in the table. What is causing this?
View Replies
View Related
I'm using an Access database and asp to bring in a series of table contents to textarea fields so if wording wants changing in the database I can do it using an asp form. All works ok apart from a couple of records that are memo fields.
I have displayed the field contents by ..........
<%=(locationwords.Fields.Item("ftexta").Value)%>
and they are shown ok.
If i try and use the same syntax for bringing the memo field in to a textarea nothing is displayed.
<textarea name="textarea" cols="50" rows="2"><%=(locationwords.Fields.Item("ftexta").Value)%></textarea>
Any clues as to what i'm missing to get the text to appear so it can be modified and posted using a form.
View Replies
View Related
I've got the following code UPDATEing an access db (Field Type = Memo) with varying degrees of success: Code:
View Replies
View Related
I have an access database and am currenlty using classic asp for most of my coding and am trying to extract sentences from the memo field that contain specific strings, in this case "<b>"
The memo fields contain a lot of data so filtering becomes an issue, so i just want to be able to only display the sentences within the memo field i.e. between "." and "." OR beginning of record and "." OR "." and end of record that contain the string "<b>"
View Replies
View Related
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
View Replies
View Related
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
View Replies
View Related
