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
I just modified a SQL table field's datatype from char to text to accomodate more text, and suddenly the results are not being displayed on my webpage. Has anyone encountered this before?
I just stumbled into something which kinda of makes sense but I'm not 100% sure about.
I have a field as nvarchar.
I had the sql checking it: select blar from blar where blar = 0
weird thing is in the enterprise manager DTS the query parsed as ok. Overall the DTS failed because it came across some characters it said it couldn't handle.
The query changed to: select blar from blar where blar = '0'
and everything worked fine from there on.
---
What I'm wondering is, can nvarchar accept numeric values as well as string values?
if it can then the above all makes sense, if it doesn't... have I just found a bug?
I m updating a table which contains a field with datatype=ntext. I use a stored procedure to insert/update data in it. SP's parameter's data type is ntext. Following is the code in which i created the parameter.
Code: SET objParam1 = objComm.CreateParameter("@xmltempSrc",adLongVarChar,adParamInput,1073741823,txtXmlConte nt) objComm.Parameters.Append objParam1
when i execute it, it give error as : Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type text to ntext.
I need to write a function that takes four inputs and returns a value based on that. For example, the inputs are name, country, state and city.
I have 25 rows and 5 columns of data. The data would be like this.
Jay, USA, CA, san francisco, san mateo, san bernadino, oakland, berkeley Mike, Canada, Ottawa, montreal, toronto, edmunton, niagara, london
if the input values are jay, usa, ca, san mateo- the function needs to return the next value in the row which is "san bernadino".
If I could store these values in the database, I could just write a query that would give me the output. But don;t want to make a trip to the database. Code:
I have a problem to use the bit field, I know that accept the value 0 like false and -1 like true.
When I do the insert into and i put value -1 i receive an arror, if i put 1 and i try to read no the database i receive ever the value false. How can i correctly use this datatype?
I have a table (MSSQL 2000 server) with a column called "Content" whose datatype is text. Now I'm trying to insert data into the table using a stored procedure. What is the ADO constant that I should use to insert value into that column? Code:
If execute the following sql on my MySQL database -
sqlremove = "UPDATE fib_note SET fib_note_actdone = 1 WHERE fib_note_id = '" &Request("id") &"' "
It seems to also be effecting another field in my table called fib_note_timestamp which is a timestamp data type with a default value of current_timestamp. How come and how can I stop this?
I encountered a problem where I am retrieving a field from a recordset that is in the Money datatype and I then store it into a variable, exampe;
cur_BBOAmount = rsgetBBOAmount("BBO_Amount")
I am now trying to see the contents of cur_BBOAmount but nothing is showing up. In my if statements, I checked against blanks, I checked if it was zero, and I checked if it was Null, but nothing seems to work. I checked the variable type using response.write typename(cur_BBOAmount) and that returned the Currency datatype.
My question is, how can I test the value of this variable that is of the currency datatype?
I'm updating a record by opening a recordset, setting the fields and the updating it with objRS.Update.
I need to set an image datatype to NULL. objRS("field") = NULL works for datatypes int and varchar but not for datatype image, although there is no error - the image field still contains the image!
I'm using SQL server and running an UPDATE statement including image = NULL works.
I am repeatedly getting the error message 'error converting datatype varchar to bit'. I am passing a varchar variable to a stored procedure (where it is also a varchar) and then trying to write it to a table (where it is also a varchar).
' If you use SQL Server, the connecton string must look something like this: ' Connect = "Provider=SQLOLEDB;Server=MYSRV;Database=master;UID=sa;PWD=xxx"
Set db = Server.CreateObject("ADODB.Connection") db.Open Connect
SQL = "SELECT * FROM MYIMAGES where id = " & Request("id") Set rs = db.Execute( SQL ) If rs.EOF Then Response.End
' Send actual file Response.BinaryWrite rs("image_blob")
Response.ContentType = "application/octet-stream"
' Let the browser know the file name Response.AddHeader "Content-Disposition", "attachment;filename=" & Trim(rs("filename"))
' Let the browser know the file size Response.AddHeader "Content-Length", CStr(rs("filesize"))
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.
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 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"
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?
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 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 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!
