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 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.
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?
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 am looking for a script in which I can replace any word in one table (which corresponds) to other table with a link....
To for example when the name Bill Clinton is in a large piece of text in TABLE1 and Bill Clinton is a row in TABLE2 then I want Bill Clinton in the text to display as a link leading to a page where there's more info on Bill Clinton from TABLE2
I am trying to create an application feature for an inventory database and I am wondering about the most efficient way to process the updates. Here's the background information: Code:
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 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 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 have an asp page with a form, which has a lot of fields 30 to 40 .Is there an easier way to loop through all the fields submitted to the insert page or is the only way to do it using the standard, request.form for each field and then INSERT INTO Reports (ReportID, ReceivedDa very lengthy for this amount of fields. Perhaps there is a way of looping through some sort of collection ?
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 am creating a dynamic website using ASP and an MS Access backend DB. I am a little confused with how to go about things and am now facing the following problem. I want a large volume of text to be loaded dynamically on my page but don't really understand how i should be storing this text as the database fields will only hold a max 255 chars.
Obviously this is not large enough to store all of the text i may need and so where should i be storing the text? The only idea i had was storing the text in an external text file to which i point to with the database field (i.e. database holds the path to the txt instead of the actual text itself).....is this possible? or more to the point is there a better way? How would this normally be accomplished?
I am trying to create an ASP page that processes a large block of text that is posted to the page. The data block is approximately 500K. The only was I can figure to get the posted text into a string is using BinaryToString. Is there another way to just get the body of text that is posted?
I have read that there can be a periodic problem when reading large varchar or text fields from SQL server (or memo fields from Access)--they can sometimes come up as empty strings.
What I have been unable to find out is whether this problem is still around in recent versions of MDAC (>= 2.8). Does anyone know whether this problem still occurs--is it still necessary to follow the steps in that aspfaq article?
I've a large database that I am working with. The problem is right now I've so many sample data in the datbase all the testing data in it. I want to clear the database and reset the AutoNumber so that it starts at 1 and goes up by one.I know that its possible in Access and I've done it before, problem is the tables have relationship and lots of them.
the way I know to rest the AutoNumber require me to break the relationship but it will take very long time for me to rectreate them again and I might not get them same at the end.Is there a way to rest the AutoNumber without having to break the relationship?
principally I'm a photographer, and in the absence of any image galleries I could make sense of I created my own asp pages in Dreamweaver displaying images from a path stored in a database. These can then be paged through, all done using server behaviours in Dreamweaver. However, because I wanted to include some text next to my images, again a field in the database, I have to scale them down. I would like to give the user the option to see a larger version of the image on display, preferably in a pop-up window that is then closed by the user before they continue scrolling through the images....
I have an asp page that returns a table from my database. Only about 6 columns from the table are shown on this page. I have the ID column set up as a dynamic link to a 'details' page, so a user can view the rest of the record data.
My database has been growing rapidly, and now when the page is run i get the error "page cannot be displayed".
I believe this is due to how large my database table is because if i delete records the page works fine, as it did when the system was first running. Right now there are 4600 rows in the database and will be growing.
How do I fix this problem, I cannot get rid of any records.
Oh yea, and if i delete the line of code that contains the link, the page works fine and shows the entire table.
Here is the code for the link: <A HREF="details.asp?<%= "JOB_NO=" & rsResults.Fields.Item("JOB_NO").Value %>"><%=(rsResults.Fields.Item("JOB_NO").Value)%></A>
I am trying to pass a hidden field value on a form into another field on the form so that it can then be inserted in the database, to enable me then to reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the other input field.)
The code for the text field that allows users to type an number into it for submission to the db is below, but what code do i need within the hidden field to populate this text field below so that users do not have to type the number in? Code:
i have a field with a list of wrong ID (random) and i wish to replac them with a sequential (auto-increment) value. how to remove the valu and to add in the sequential ID?
when I try to save this text with "&" character , it saves only the first part of the text , for example : aaa&bbb , the result is only aaa . realy dont know how to solve it .
