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.
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.
is asp code able to do the extraction of text from PDF File without using a third party software?
View Replies View RelatedI'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!)
I want to strip email from the text. Some of my users may send me a string:
str = "This is email 1: Join Bytes! and here is email 2: <a
href="mailto:me@me.com">me@me.com</a>"
How do I parse the string to get email address only? mI know I may use instr() to determine if email address exists, but please, give me a hint on how to handle it next.
Alright, now I'm trying to combine time and date in one variable as such:
Combined = time & " " & date
But instead of getting 12:42:13 PM 6/12/2006, I just want to get 12:42 6/12. How do I strip off the last characters to just get the parts I want? Also, I'd really like to see the time in 24 hour(military) format, but I'm not sure how to accomplish that either.
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>
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?
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"?
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.
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 Relatedi 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
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?
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.
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.
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 RelatedBasically 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 RelatedI 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.
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?
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:
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 RelatedI 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>"
strSQL = "SELECT user_name, password FROM [tblLogin] WHERE user_name = '" & Request.Form("user_name") & "' AND password = '" & Request.Form("password") & "';"
Is using AND the correct way to use 2 comparisons in the WHERE part of the SQL??
I have a database table, that I need to sort by PART of the contents of a field (named rFieldName in the table):sample contents of this field are:Code:
qid_5_question_1
qid_12_question_5_0_1
qid_12_question_5_0_2
qid_12_question_5_1_1
qid_12_question_5_1_2
qid_12_question_5_2_1
qid_12_question_5_2_2
qid_12_question_5_3_1
qid_12_question_5_3_2
qid_6_question_2I need to sort his field by the value that appears AFTER the 3rd underscore, and if applicable BEFORE the 4th underscore
Is this possible - can you help please - I have no idea where to start on this as I've never had to try to do something like this before.
I would like to use the last 10 characters of a Session object. Is this possible in active server pages. I am familiar with the user of Right$ in visual basic but I after trying serveral conatations I have had to give up.
View Replies View Relatedhow do I get a reg exp to remove part of a string? -
I have: '/page/txtonly/index.asp' and I want to remove the '/txtonly' to end up with: '/bobby/index.asp'.
is it possible to reload just one table row with out reloading the entire page? Or reloading just a table? i'm not thinking it's possible but if it is it's worth asking a qustion.
View Replies View RelatedI need to limit how much of a record is printed to screen. I just want text up to the first full stop.
View Replies View RelatedFollowing java script code to get subscriber ID, its value is like 975683678-28_luxap01s.southernlinc.net, I want to leave number there and cut starting _ part, does anybody know how to remove the character starting underscore "_"? the final value is 975683678-28.
<%
subsciberID = Request.ServerVariables("HTTP_X_UP_SUBNO") ;
%>
I have a login page where i validate my user id and password... this part is done... I need to get the user id to the next page i am showing...
Example like:
-------------------------------
Login Page
userid : abc
pwd : XXXXX
Authentication Successful
---------------------------------
Next Page:
Welcome abc ---> i want it here
----------------------------------
Anyone can show me how shld i do it...
I am coding a login system with login form etc. and when users are denied access to a secure page within the secure area, I want to obviously send them to the login page to check who they are and check they are allowed to view the secure content of the site.
The problem I am having is that currently, if a user is denied access to a secure page, they are sent to the login page. Once they are granted access, they should be sent back to the page they were originally trying to view and not to the main menu.
(The secure area has lots of pages and users would not be happy if they had to trawl through hundreds of pages to try and find what they wanted.
I know I need to use the ServerVariables collection to retrieve the ("URL"), but I dont want to just use this as a querystring parameter when I send a user to the login page.
This would be insecure because someone out there would find my little login script and start using it on their own site by sending users to my login script to login, and then using the querystring parameter to redirect the user back to their own site.
All I want to do is select the part of the URL after the http://www.somedomainname.co.uk/manager/ part. I cannot use a Left select or right select option because my login script will be put onto lots of different websites, and I would have to change the Left select on each different site.
Basically, what I want to do is to group records according to the first letter of "username" (the primary key).
SQL = "SELECT order_date FROM cart_order WHERE username = 'A*' ORDER BY username"
I've tried using a 'wildcard' (*) in the SQL statement and it doesn't work. So, how does one filter out records according to the first letter of the cell's data?
I can come up with a page that displays some information. The information will always be displayed on specific part of the page, with auto refresh. But he doesn't want the whole page to be refreshed so that buttons and images around the information do not get
reloaded each time. Is this really possible?
Other pages on this site don't use frames, so this page can't use frams too. Creating an ActiveX control is also not an option of us ...