Pull Specific Line From Txt
I would like to collect financial data from the stock exchange into the asp web page.
Complete daily results are in txt format on a fixed URL. Soo far I managed to pull the data on my web page, but now would like to select only specific rows. Unfortunatly the rows are not fixed, but each one has a 4 digit code on the beggining.
So I would like to create asp code which would select n rows from txt page based on specific code on the beginning - for example 0020. In the SQL would look like this one SELECT * FROM file.txt WHERE the beggining of the row = 0020
Is that possible in asp ?
View Replies
ADVERTISEMENT
i have a remove user and change password script written, but the only thing they are missing is the actual text file editing part. i have the file open because i have read it, but how can i delete a line that matches with 'OldLine' and put 'NewLine' where it was with a couple of lines of code?
View Replies
View Related
After looking all over the place and finding codes in vb and in php I even had asked several people on other boards but none of them knew how to do it I say the best way to learn this .asp .aspx junk is to DO IT yourself although Ive scripted in the past with the mIRC client which is why I know programming and html but if anyone is looking for the code this is how its done Code:
View Replies
View Related
I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
View Replies
View Related
I have an encrypted .txt file created by asp. Its formatted with lines etc. Title followed by description underneath. I need to read this into ASP now, and parse it line by line. On each line read, run the function to unencrpt and add line to a new file.
Its the line by line Im having trouble with. If i do the full textstream no formatting takes place coz im adding the fulltextstream all in one addline call. How can I loop through lines ?
View Replies
View Related
I know how to enter data to a SQL database from a form.
I am making a form where the user inputs some numbers.
Than other users login to this other place and I want the
number that the person imputed to be shown in a field
multipled at a certain price. I am unsure how to pull the
numbers down to display them and do the multiplcation.
The multiplication will show up in another place on the
page.
Does this make sense?
View Replies
View Related
I am trying to create a pull down box with no button. I need a script that will allow passing one parameter from the sending page to a single template page (jetTemp.asp).
I found this script that I cannot get to work:
<html>
<form name="guideform">
<select name="guidelinks" onChange="window.location='jetTemp.asp?' + document.guideform.guidelinks.options[document.guideform.guidelinks.selectedIndex].value">
<option selected value="PullDown.htm">--Choose--</option>
<option value="size=small">Small Jets</option>
<option value="size=medium">Medium Jets</option>
<option value="size=large">Large Jets</option>
</select>
</form>
</html>
I understand that I need a query in the target page to pickup the parameter.
View Replies
View Related
I have a site that I am trying to pull a text file into from one of my sites on the WWW.
What I am trying to do is have an ASP file go out and every so offten pull a text file and save it to the local folder.Is this possible?
View Replies
View Related
I'm writing a site scraper (bot, etc.) that needs to log into a site (i have the username and password), then redirect to a particular page and then pull that content into a variable so I can manipulate it.
I'm using ASPHttp to try to pull this off. However, I CANNOT get by the login. According to ASPHttp this should be possible, but I cannot make it happen. I would not imagine this would be too hard to do. Perhaps ASPHttp is not the right tool.
View Replies
View Related
Ok im trien to make a sql pull statement that pulls duplicates of item_name . can someone give me a hand with this.
View Replies
View Related
http://www.google.com/search?biw=868&hl=en&q=http%3A%2F%2Fwww.dimplesanddandelions.com%2Ftest.asp&btnG=Google+Search
I get this result by using: Request.ServerVariables("HTTP_REFERER")
I'd like to pull the www.google.com out of it and save it as a session variable for conversion tracking. Is there an easy way do that using ASP?
View Replies
View Related
I have a script that pulls certain details from a script and emails them to the user. However if a user has purchased something more than once there will be 2 records with the same email address and ovviously the first one will always be displyed.
How do I ensure that it is the last record of that email address that is pulled?
Code:
<%
dim conn
dim sql
dim sqlstring
Dim rsCheckUser, TransactionID
set conn=Server.CreateObject("ADODB.Connection")
View Replies
View Related
Does anyone know how I can do the following:
I have a url like so:
http://www.domainname.com/folder/subfolder/page.asp
I want to pull out as a variable the following
/folder/subfolder/
View Replies
View Related
I'm receiving a resultset from a stored procedure & at other times a query from SQL Server.
I need to pull the metadata from the results that I receive. More specifically, I need to know if a field is a Float datatype. This will then determine how I display the results on the web, FormatCurrency().
View Replies
View Related
i have a pull down menu with categories and the link but unfortunately it doesnt go to that pages at all. does anyone knows what's the problem:
<select name="select">
<option>Browse Our Catalogue</option>
<option value="http://www.mellon.com.sg/Shop/computer_accessories.asp">Computer Accessories</option>
<option value="http://www.mellon.com.sg/Shop/custom_made.asp">Custom Made Products</option>
</select>
View Replies
View Related
I stated to someone in a different post, perhaps different NG, that since I
have 3rd party cookies blocked in IE and after a recent windows security
update, ads with 3rd party cookies do not load the page. Code:
View Replies
View Related
this is a continuation of my little login page I am setting up.
the login pages authenticates the user using Active Directory.
I also have a Database locally in MSSQL that has the users ref number (primary key, incrementing) first name, last name, and user id (same user id as ldap/AD etc)
what I want to do is when the user logs in the page will call the Database and grab the full name as well as the ref number. Later in the page if the user submits a form to add data to another database I want it to populate a column in a table using the ref number. that should be rather easy once I actually have that ref number.so how would I tell the page to go to my database and grab his ref number (as well as his name to be able to display Welcome first Lastname instead of userid?
View Replies
View Related
I need a menu in one of my asp pages. A click on one hyperlink should display its pull down menu of the other related hyperlinks ... as that appears in search option this forums. As an example... main link will be Alphabets. A click on it or on focus.. it should display a drop down list of other related hyperlinks.
View Replies
View Related
Pull text in from a simple notepad file on the server...simply looking for the code to place on page...I had it working in root but when I uploaded to server it din't function..checked permissions etc.
View Replies
View Related
I'm not sure if this is possible or not, but I thought some one here should be able to tell me how it can be done. I'm building a site that will allow people to enter information about their company into a database, the information is then displayed in a profile page for them. They can enter things like news and events. This all works fine and dandy, but now I have had an idea.
Is it possible to be able to publish something for each company so that they can display the same information on their own website? I am thinking it would be something similar to an RSS feed.
Has anyone done anything like this before? The site right now is ASP with a MSSQL backend. The sites that will be posting the published information may be a variety of hosting platforms, if a certain platform is required then we will make it as a requirement.
View Replies
View Related
i was trying to find a way to link my pull-down menu with a column in a table in Microsoft Access using ASP. As I add new records to the database, I would like the pull-down menu to update also.
Once the submit button has been clicked, a table is inserted into the page with the information from the row in the database.
View Replies
View Related
I have a database I built with Access with a Users_Table holding User_ID, User_Name, etc. A Posts_Table, with Post_Content, Post_ID, Post_DateandTime, Thread_ID (pointing to whichever thread the post is in from the Threads_Table), User_ID (pointing to the user who made the post in the Users_Table). Also a Threads_Table, with Thread_ID, and Thread_Title, etc.
I want to pull the Posts content, Post DateandTime, User who posted it, and thread title from the database (the page simply knows the ThreadID and the idea is to select all posts with that ThreadID). Could anyone help me create the SQL I need for this. I understand Inner Joins, and this would be the perfect place for them I would have thought, but I cannot get an inner join to work here. perhaps because this is an access created database,.
View Replies
View Related
it possible to pull the information from a query located inside the .mdb database already, instead of pulling the information from the tables ?
View Replies
View Related
Trying to figure out how to make a pulldown menu, which when something is selected, another pulldown menu comes up with limited options (based on the input from the first). I've seen examples using Jscript, but none using VB. The rest of my page is done in VB. Any suggestions? Is this possible?
View Replies
View Related
I have created a page that pulls up my data from an access database. A value has a link that goes to a detail page that I want to show all of the information for that value that was clicked.
How do I pass that value and then pull up the information for that value? Do I need to give you my code?
View Replies
View Related
I'm looking to display information pulled from a database based on
information the user puts into a text box. The user will enter their
sales rep number and I want to hit a table and return their name as
soon as they tab off of the text box. Any ideas or help would be
appreciated
View Replies
View Related
It s very basic question..but stil i am getting a bit confused.I want to have two radio buttons which can be selected as well be deselected. The value shud be inserted in the DB.
How should i go on doing this. Also if i want to see my selection when i return back to the order page..how should i pull it from DB and display the radio button with the dot in it(checked )?
View Replies
View Related
I have been asked to try and write a program that basically pulls some info from a sql database and automatically emails it to an email address on a certain day of the week .
So if anyone can offer advice or if they know of any script or tutorials online.
View Replies
View Related
i am trying to pull records from a table in access using a Select...From...Where query.
I want the WHERE part to do this:
WHERE Gamedate >= (#"&Today&"#) <=(#"&Future&"#)
Today and Future are variables that look like this
Today = Date() 'Todays Dats
Future = Date()+7 'Todays date + 7 days
I have tried this without the variables and used the values that i have stored in the variables directly. And i have tried without the hash marks when i Do use the variables but it is not giving me the results i need.
When i do not use the variables i get a "(Missing Operator)" error.
View Replies
View Related
I was able to alternately change the rows colors, but this time lets say I have 10 records in a table taken from my database. How do i put colors on rows where value(certain value from a field) is lets say greater than 10?
Like for example I want to highlight only those student number greater than 10.
View Replies
View Related
I have a program that needs to rely on the date for Sundays on a given month. Here's an example:
Today is 3/18/2005 (Friday). When a user logs into my page, I need to grab the date that the past Sunday fell on (3/13/2005)
If the user logged in on 3/24/2005 (a thursday), I would need to grab 3/20/2005 (that sunday)
Any ideas in vbscript?
View Replies
View Related
Ok let me explain what I am trying to do as easily as I can. I have a table in my access database that I am connecting to. I select a specific id number using my SQL statement. Now what I am trying to do is scroll through that records row and get the column name of that column along with the value of that cell. I hope that isn't to confusing. Now I'm not sure whether this would be done using ASP or done in my SQL statement. Code:
View Replies
View Related
I am working on a college project which has a user area and a page where only a user can access their information and no one elses.I am trying to do a select statment to read specific information from a field without reading any other users info.
The code below is for a drop down menu for payment months i have stored in a database...
Here is what i have got so far...
Code:
Set oRs = Conn.Execute("SELECT [Payment_Period] FROM wages WHERE [Staff_ID]=" & staffid" ORDER BY [fullname]")
View Replies
View Related
