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.
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?
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?
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.
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:
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.
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?
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
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?
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?
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.
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!
I am working on a project that involves importing IIS Log files into a SQL Server database (and these logfiles are big --> Some up to 2GB in size).
Up until now I thought that DTS or the BULK INSERT command was the fastest method out there, but still proves to be long (taking an average of 45mns to an hour to process each log file).
Because I have to import the log files from three web heads in my cluster (therefore 2GB log files per server times three servers), this really throws off the concept of "real time" or near "real time" reporting.
So that begs the question. WHAT IS THE MOST EFFICIENT, AND QUICKEST TEXT-FILE TO SQL SERVER IMPORTING TOOL, METHODOLOGY, SAMPLE CODE, WHATEVER, OUT THERE??? Code:
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.
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.
I've got a csv file which I will need to import into an access db via asp. The csv file will be imported every day of each month so there will be duplicates which will not need to be imported.
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
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?
I have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while .
Importing EXCEL worksheet into existing ACCESS tables is possible.
Is there any way i could import EXCEL worksheet into an existing ACCESS table using ASP code.Something like, i could upload a EXCEL file from a browser and then it can be imported into an existing table And if possible also check for duplicate keys and update those records. If no records exist then insert them.
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?
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?
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews headline content
tblDatabank filename description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
at one page it works fine and when i use the same kind of code to update another TEXT field it doesn't update and the I.E. loading bar increases very slowly and the next page never loads someone suggested to use .appendchunk i used rs.appendchunk and i got the error "object doesn't support this property or method" he also said that .appendchunk cannot be used to update nvarchar.
i removed the code to update TEXT field and the page loaded as expected (normally)! Why one text field worked fine while the other didn't?
i have a table in which i have many text boxes, they are named as a1,a2,a3,a4 to a16 the next row is b1,b2,b3 to b16 and so on up to G1,G2 etc, where the user enters his data, what i want to do is only allow the user to enter numbers, which can have decimals if required,
how can this be done, also i have another set of textboxes through which i want to loop and prevent user the user from entering the same data in more then one box how can this be done any help will be appreciated thank you.these are the text boxes a1,b1,c1,d1,e1 etc which is actually the first column in the table.
I am trying to write some code that inserts or updates a text field in my SQL Server 2000 database. The SQL statement is created using a submit from a form, and the text is coming from a <textarea>, and therefore being placed into the SQL statement via a Request("field"). However, due to limitations in SQL Server 2000 and text fields, I can not use a simple Update or Insert command with text over 8000 bytes.
Does anybody have any sample statements that will help me update that field with larger amounts of data? I have tried using the WRITETEXT function and UPDATETEXT function with little or no success.
