Extracting Sentences From Memo Fields Containing Specific Strings
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
ADVERTISEMENT
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
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 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 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?
View Replies
View Related
I have an array I want to split. This is the code I am currently using:Code:
<%
dim aSelected
aSelected = split(request.form("option"),",")
for i = 0 to ubound(aSelected)
response.write (aSelected(i) & ("<br>"))
next
%>
This splits the array no problem. The problem I have is that the different variables (if thats the word to use?) the array is holding is sentences that contain commas in themselves. So the split is splitting my sentences. How can I split the variables at the end of the sentences. (some sentences have periods some don't so I can't use the ".").
View Replies
View Related
I have an XML file that contains nodes and I'm having no problem extracting the information using ASP. However I can't seem to get the ID number from the deliverrequest node from the example below.
<!DOCTYPE xiamSMS SYSTEM "Message.dtd">
<xiam>
<deliverRequest id="10234690"> ''' Need to retrieve this number using
ASP
<to>test</to>
<from>number</from>
<content type="text">Test 2</content>
</deliverRequest>
</xiam>
View Replies
View Related
Is there an ASP way of extracting the height and width of a swf file so that
I can specify these dims when adding the whole OBJECT code to the web page?
View Replies
View Related
What string function(s) would I use to extract just the filename from an URL?
For example, if I have http://www.yourdomain.com/some_directory/some_file.asp, how do I extract just the "some_file.asp"?
View Replies
View Related
Is it possible to extract the first paragraph in a mysql text field? my code line to display all text:
<%=replace(Recordset.Fields.Item("article").Value, vbcrlf, "<p>")%>
I want to separate the 1st paragraph (article lead) from the others (article), without having one table for 1st paragraph and a second one for the rest of the text.
View Replies
View Related
I need a help in extracting files, thru ASP. Is that possible to extract files from .tar, .gzip and zip files thru ASP.
View Replies
View Related
i want to extract the number 38 from the URL below, using ASP what is the solution?
then store it as a variable.
http://pcol-webtest/default.asp?nc=4098&id=38
View Replies
View Related
is asp code able to do the extraction of text from PDF File without using a third party software?
View Replies
View Related
we have a site, that has a link to a online PC cart that we are registered with. Trouble is, when the user goes to the other site, we obviously no longer have our interface wrapped around the page.
We can do this with an iframe, but it wont vertically stretch the content (a scroll bar appears). Is there any way in ASP, to call a url, and say, insert that url into a <td></td> on our page?
View Replies
View Related
Not a problem with my code, but something I would like to add, (ASP
VBScript) at the moment I have a form where a user uploads their details
including a document (Doc, PDF, TXT, Docx) The document is uploaded to a
folder on the server with the address being stored in the database and I'm
tracking the user id through sessions.
What I would like to do after the upload is redirect to a blank page, where
some script extracts the data from the document and inserts it into another
field on the database associated with the user id, I think this may be called
parsing, but I'm at a complete loss, I don't suppose you guys have any ideas
on this do you.
View Replies
View Related
we have a database with a lot of products in it. and for some reason one fo the feilds is set up like "<img src="images/something/image.jpg" />". they should be set up without the html but because of the way they are set up theres no way i can use them outside of the root directory.
I need a way to just pull the first 10 characters off the string. which would be the <img src=" part, and then pull off the last 4 characters " />. so that i am just left with images/something/image.jpg.
I can sort of get the first part to work by using Mid(string,10)
but how can i remove the last 4 characters?
in php the function would do the ending characters if you made it a negative number. but Mid(Mid(string,10),-4) doesnt seem to work.
View Replies
View Related
Is there a way of processing an ASP page and placing the resulting HTML
source code into a TEXTAREA on another page?
I have a page that will be generated dynamically from database content.
However, I want a form on another page to have access to the compiled source
code for use in an electronic newsletter.
Manually I would load the dynamic page, view the source and copy it out. I
would then paste it into my form field on the relevant page.
View Replies
View Related
Is there a way of extracting only part of an entry retrieved from a SQL database. For instance, if I have an article of 4000 characters can I extract only the first line of the article and them put a link to the full article after the extracted text.
It is something I have been trying to master and will help me display my retrieved recordset data better.
View Replies
View Related
in my project, i want a label which shows the current value of all shares in the market whenever the user login to the application.how can i do that.how could i dynamically extract data from the shares website.
View Replies
View Related
Basically I want to be able to take the tempreature, pressure and wind and be able to use them as variables in calculating performance automatically for an aircraft. I've tried using the pull string method but can't work out how to seperate the variables.
View Replies
View Related
I have a website where people can add job vacancies to our database. In the admin section I can delete these vacancies but have trouble with selecting certain dates from the database.
For example if I wanted to delete all the jobs from the database for the 18/12/2003 I would select the date then all the jobs will appear on the screen and I can delete them. But if I select a date such as 06/12/2003 or 11/12/2003 it doesnt display anything from the database when I know there are a couple of hundred in there for those dates.
View Replies
View Related
I'd like to do the above, ideally in javascript but i'm aware of the security restrictions with accessing the DOM of a file not hosted on the same server - however i'm not looking to manipluate anything on the remote site, or handle any events (such as keylogging!). All i want is to have a piece of text on the remote site dupicated on my own site.
I'm happy to receive the html as a whole and split it up to get what i want, but i'm beginning to think the way forward is doing it server-side with asp.
Anyone know the best way to do this?
OR am i just being silly and there is a way to copy the contents of a remote page into my own page in javascript, split it up and only display what i need.
(btw im quite happy with the splitting up bit, no help needed there - i just need the blasted text in the first place!)
View Replies
View Related
Is it possible to extract data from SQL server to MS Excel ? Say if I have 2 tables (Membership and Profile) and extract some certain datas from those 2 tables; MemberID, Member Name, Birthday, Interest; could it be possible to extract them automatically everyday at 1 AM without me doing it manually?
Perhaps its possible to do it with Stored Procedure? or some other means?
View Replies
View Related
I am trying to add a feature to our inventory that will pass the current URL to a second site so that I can return to the original site later through a redirect. Basically, it is intended to work like this - you do a search, and are taken to a page where you can view the records.
You click on a record to view it and/or update it, and then you are returned to the original search results. I am having some trouble, and am hoping that someone can help me out.
I am placing the values that I want to keep (original URL, search terms, sort order, page number) into a string, and then using Server.URLEncode to encode it: Code:
View Replies
View Related
I have a bunch of html stored in a session variable. It's just a long string of html. I want to parse it to extract certain things out of it. I'm assuming I would use the Left, Mid and Right functions. But don't know exactly how to do it. Plus I need to find the information in the session variable too.
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
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
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
