I'm having a bit of a problem and I was hoping someone could help me out. I'm trying to create an interface for manipulating historical stock prices obtained through finance.yahoo.com. I need to make a recordset contain the data of a CSV file that Yahoo returns, but the catch is that I want to pass the data along by pointing the recordset to the URL of the CSV files on the Yahoo server.
Yahoo creates its CSV files dynamically through the querystring of its URL (see below), and I would use inputs to my interface to manipulate the URL for specific ticker symbols, dates, etc. I guess the simplest example is that a user could input a ticker to my interface, the recordset would somehow "call" the URL for the correct data, and then that data would be in the recordset, where I could manipulate it, before returning the information back to the user.
I'm just stumped on how to get the CSV data into the recordset on the fly, just by calling the URL.
The following link is an example of what Yahoo does. Manipulating the querystring changes the ticker, date range, and level of detail. You can also change the table.csv to table.txt and return the actual data in one big text file. Code:
I have a web page that submits a form to a database. Each time a form is submitted, I need to assign it a unique case number and insert the case number into the database along with the information entered in the form.
I am able to insert all the data into the database, but am not sure how to generate the case number to insert. Is there a way to do this based on number from the previous entry, like just add 1 to it?
I'm trying to create an interface for manipulating historical stock prices obtained through finance.yahoo.com. I need to make a recordset contain the data of a CSV file that Yahoo returns, but the catch is that I want to pass the data along by pointing the recordset to the URL of the CSV files on the Yahoo server.
Yahoo creates its CSV files dynamically through the querystring of its URL (see below), and I would use inputs to my interface to manipulate the URL for specific ticker symbols, dates, etc.
I guess the simplest example is that a user could input a ticker to my interface, the recordset would somehow "call" the URL for the correct data, and then that data would be in the recordset, where I could manipulate it, before returning the information back to the user.
I'm just stumped on how to get the CSV data into the recordset on the fly, just by calling the URL.
The following link is an example of what Yahoo does. Manipulating the querystring changes the ticker, date range, and level of detail. You can also change the table.csv to table.txt and return the actual data in one big text file. Code:
I’m in the middle of designing a simple website poll... nothing to fancy a simply question and results type thing... however I’ve hit a problem in that I cannot figure out how to add one to the running total when a vote is cast. For example:
Do you like this website:
A: Yes Lots – radio button if selected adds one to yeslots column B: It’s ok - radio button if selected adds one to Itsok column C: It could be improved - radio button if selected adds one to Itcouldbeimproved column
And of course we’re using an Access database for this one.
I have a page where the user logins in and is taken to another page. On this page i want them to insert data into another table within my database.
At the moment however it just enters data into the database once. I'm assuming it�s because I don't have a recordset set up. How do get the ID of the user so that it will insert the new data into the relevant recordset.
I have a page that pulls 'member' registration information from a table similar to a bulk delete with checkboxes. This works fine, it pulls all of the member info. What I want to do is have the selected records added to a new table known as courses.
Sort of a bulk registration system where I have a list of members, put in the start date, end date, course name and course number once and it populates for all of the members in the new table adding the member info with the course info. Code:
I have a simple application setup where people can submit a request for a sample of our product to be mailed to them. It's a very simple form with name and address information. I have a page setup where our warehouse guys can pull up current requests and then the plan is to use USPS.com to print shipping lables.
While it's already a big time saver, they're still having to either copy/paste or re-type the information into USPS.com's forms. Knowing the names of the form fields on their site, is there a way I can populate their forms with the data in my recordset from my details page?
For instance, they pull up the current requests and they click into the details page for one of them which lists the person's name and address. If I have the USPS.com page open in another window and on the screen which contains the form fields is there a way to call that page and populate those fields accordingly?
I put in a request recently for a script which would return 9 random numbers between 1 and 30. I got a reply which gave me this script, which writes them out.
It works great, but in the loop that writes them out, instead I would like to assign each value to a variable, such as img1,img2,img3,img4, etc. in the for loop, is this possible, or should I write out 9 statement lines, each assigning a value to a variable. I intend to plug the values into a java applet which rotates images.
Come to think of it, I could just put each value of the array right into the img tag, no? <img src="images/<%=random_number(1)=>.jpg"> Code:
If Request.Form("resScreen") = "1024x768" Then screenSize = "big" Else screenSize = "small" End If
this works fine, but when this page is reloaded, it doesn't find this Request.Form("resScreen") (this form is also on another page, which explains why) but can I store this variable "big" the first time it loads somehow?
For Each objitem in Request.Form if request.form(objitem).count > 0 then For intLoop = 1 to Request.Form(objitem).count Objitem = request.form(objitem) End if Next
server error in line of "end if"
I want to collect the values from the form and assign a variable to each value field
I am using Visual Studio I have created a website using HTML code and the pages look fine I now need to do the following.
I have a picture where if some one clicks on it it then needs to query an SQL database and return on a different page the results. How do I assign a sql database to my website and how do I connect to it ?
I'm retrieving the screen resoltion with javascript code, but i can't assign the correct value to asp. the response.write is displaying zero (0) for screen res., although when i do a document.write in the javascript part, then my screen res. is 1004 ...
I have this simple application that I put together using ASP. It has an html form that submits to an access database through a simple ASP file. It’s a survey form basically. One of the departments here wants to get some feedback from their students and in return for filling out the survey they will be entered into a drawing for a gift certificate. The catch is that the survey is anonymous. What they want to happen is each person is given a unique number at the end of the survey and they will pick one of those numbers randomly to see who the winner is. How can I possibly do this? I am stuck.
I think I may know what I need to do:
Pull a unique number from a database and post it onto the HTML form near the submit button. Notate on the page that the user write the number down and when they hit submit it is inserted into the database along with the record. I have absolutely no idea how to do that.
The HTML form submits into the database using this "add.asp" file:
I'm setting the title attribute of an input box to assign a tooltip. If I assign title the value "Agent does not exist", when hovering over the textbox the tooltip will only display "Agent" it's the same with all my tooltips (only the first word is displayed).
Before there was XML my world was in order, I would once a year write some small ASP script, it would perhaps take me all weekend, but it was doable, now the devil has entered my life, in form of an XML file ... Code:
I am trying to update an integer field in an Access database with a null value (ie, make the field empty). It currently has an integer in it. Here's the code I've tried, which normally works for all other updates:
Is it possible to assign javascript variables values to ASP?
e.g. How would I store the following JS variable as an ASP variable in VBScript?
<script type="text/javascript"> var intJavaScriptNumber = 25; </script>
The problem is I've got about 50 of these variables on a page, and they all need to be used in a simple equation which slows the browser down. If I could get them all into ASP then I could process this server side much more comfortably.
Currently, my repeat region is showing all of my repeated records that are being brought in from my database. I would like to display these records in a confirmation page, but I am having problems having them display in my confirmation page.
I tried to assign a hidden value to the repeat region, but I am getting no data to come across. Below is the code that I'm using: Code:
I am bringing in a repeated field from a database and I would like to assign values to radio buttons to be associated with each record. The number of repeated fields will be different for each person, so I cannot enter values for each repeated record. I need a way to assign a variable as well as a value to each record that is being brought in from the database. For instance:
Radio Button Value 3 4 5
Repeated Record 1 O O O Repeated Record 2 O O O Repeated Record 3 O O O
I had received some great code from Memnoch, but it created one group for the entire Repeated field, so I was only able to select one radio button for all of the repeated fields. I need to select them seperately and I then need to Request the variable so that i can add, multiply and divide that variable with other repeated variables.
I have a form.htm page where the user enters an ID to retrieve addresses. Then PAGE1.ASP displays the addresses. From here the user selects an address and submits. Then PAGE3.ASP brings back further information. My question is how do I use one field from the address information on PAGE2.ASP to display on PAGE3.ASP? I know how to do it with textboxs and such but cant get RS data to hope page to page. I get no errors or anthing.
On PAGE2.ASP I have : <input type="hidden" name="CLIENTHIDDEN" value="<%=RS1("CICL_LNG_NM") %>"></td>
On PAGE3.ASP I have: clientname = request.form("CLIENTHIDDEN")
and to display: <td class=rt width="110" height="1">Business Name:</td><td width="849" class=rt height="1"><% =clientname%></td>
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. ../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page: GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have one application folder containing all ASP code files. I want host multiple sites pointing to same code. Can I do this ? If YES then how I can assign diffrent global.asa to each application...
I have it at the moment that on the main default.asp there is a recordset that will display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be. Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /admin/update.asp, line 111 line 11 is strName.execute I read it might be forbiden characters in the data base field names or spaces... but i don't have that. the names are userName, userLevel, ID, Password.
