I am developing a website and in particular, a shopping cart for the company I work for and I have everything working fine. This website is written in ASP. When you add a product to the database, it adds it along with a UserID based on a Session variable.
Everything is working fine regarding the user functionality of updating particular product quantity and options. However I am having trouble finding any information on how to send the contents of that recordset via email, when the user decides he is ready to send it. I have no trouble sending forms and such via CDOSYS and ASP but how can I send the contents of an entire recordset?
I have an 2000 Access database that stores job listings from potential employers for a school. I would like to be able to display the date on a webpage the last time the database was updated (inputed through asp natch').
The database is not updated everyday so that won't work but something like the database was updated on Monday 11/24/2003, I would want it to say "New job listings as of Monday, 11/24/2003" if it were checked on Tuesday or whenever. Code:
i want to display my record on asp page as follows:
custid ordernum 1 101 1 102 3 104 3 105
that is with only the ones with more than 1 order. how can i manipulate the display...and i cant(i mean i have no permissions) change my query to do this.
im wanting to display a full recordset from an access database and sort it by the "map" field seen below which works but i get this error between my second last and last records when theyre displayed:
ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed.
I have this code that displays record sets at random, but some of time the results are less than the minimum set, which is 5 records. It is less, or none at all. What I need is for the asp to display records randomly on each submit.
Currently, the asp runs so that the whole recordset is different, i.e. Random. I am a little concerned about the load on the server by running such a script....perhaps someone can clarify.
'Set the number of records to display on each page by the constant set at the top of the script Code:
I'm trying to create a page that uses a recordset to display user information such as: username, email address, first and last name. As soon as the page loads I would like the user information to be displayed. I have a user database, I just need to know how to get the recordset to display the information specific to the user that is logged in.
column2: I like apples. I like bananas. I like grapes.
I'm trying to have it where the choices from column1 are provided on the form, and based on the what was chosen on the form the corresponding choices from column2 are display on the page.
I have a simple recordset which selects various fields from an SQL table on my ASP page and displays them accordingly. However, ones of the fields is set to DATETIME(starttime). How do I get that field to display the time rather than both the time and the appended date?
This thread is not so much a big problem, but more to receive comments on my approach. You may have some other tips or advices of where to go or where absolutely not to go with my attempts. Code:
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 a select element in a form on a page with some options. When i submit thet form and the target asp page is executed, i want to find retrieve all the values in that select element on the page...?
thru request.form("sel") i am able to retrieve only the vaue selected by the user.
I am wanting to do this but am not able to do it. I have two fields: first name and last name and then submit button. When i hit submit button ,according to the name entered in the first field ,some results are displayed from database. Now when i hit submit ,the contents of my fields are cleared and i dont want that...i want the name to be still displayed in the textboxes... How do i do this? I dont want to basically clear the form contents on submit.
I am currently working on ASP. Users will input their contents into a textarea. The problem is that when they input and I retrieve them from the database, they will use the textarea space that was allocated to them and display exactly it is. For example the text area given is 500px and i only give the display part of 250px. Despite that, it will fill up and scrollbars will appear on my bottom of the webpage and have to scroll to the right. how i can display all text with the break lines in between yet still confined to the space of 250px.
I want to read a classic HTML Form using the ASP Request object on the server. This is a common approach. But how can I read all the contents of a listbox (the <select> tag)
Does anyone know of any issues interacting with asp pages from within Flash when you use Control>TestMovie ? i.e. When using a send and load, Flash seems to want to open my asp file (and return the contents in Flash) rather than run it and return a name/value pair as I'm expecting.
I have successfully been able to load text from an SQL-DB into a <textarea>.Now I need to save the edited text back to the DB But I can't seem to extract the value from the <textarea> into a vbscript-variable.
When the user clicks the submit button under the textarea I need the text to be saved into a variable, how?
I'm trying to figure out if there is an easy way to combine the contents of two arrays into one array. Order does not matter, I just want them all together. I'm sort of new to working with arrays, so I don't know if there is a really basic way to do this.
I am creating a website which has a form for registration. I am not using any database or server side coding. The form details should be sent through an email to me. I tried the action = "emailto:me@myaddress.com" but it only fires my outlook when the submit button is clicked.if it could be done the way I want?
I have worked in PHP / MySQL. But never worked in ASP/MSSQL. At the moment, i ma stuck with a problem. Hope someone here can figure it out.I have a list of countries in a Page. When the user MOUSE Over any Country, through Javascript, a small layer <DIV> appear that shows some data about that country. Up till now that XML File is filed MANUALLY.
Now that Data is changing frequently. What we want is that to do the same thing described above through database. Like when the user mouse over any country, that will load XML and connect the Database, extract info and then show in the same DIV layer. Or alternatively, there might be some sript, that will RUN AUTOMATICALLY daily or weekly and update all the countries data XML files. please guide me how to achieve this in ASP + MSSQL + XML + Javascriptor any combination of these.
I'm trying to access and iterate through POST variables. I'm thinking of something similar to PHP, where on a submit it creates a POST object, which is an associative array of all the variables. Is ASP the same way? Is there any way to see what is in the array and have access to it's contents without knowing the contents beforehand?
The reason I ask is because I have about 100 check boxes, and the user only checks a number of them - each check box is named differently. I want to, on the post page, to find out which ones were checked, short of putting an if else or select to check all 100 of them. Is there an easier way? I tried printing out the post: Response.Write(Request.Form()), and all that gave me was the querystring .
I'm trying to compare fields in two recordsets. I'm having fun with apparently empty fields. In order to avoid displaying meaningless messages, I need to know what is in these fields - e.g. is it a space, a null, an empty string, or what?
I'm not much of a programmer - how do you display the contents of the field using asp, for example, to return the ascii character code? Or is there a simple way to check for non-printing character codes?
I want to display two times which are entered in a form right beside each other. I dont want to use a <td> as this takes up too much space, so i atte,pted to do something like this, but it isn't working:
I have an ASP website that is reliant on user generated content. How do I stop SQL injection attacks without the need to replace words like , Join, Select, Delete etc.
I need to do the following in the asp project. The form contains the file upload component and textarea objects. After the user uploads the word file (using file upload), the entire contents of the word file should be copied to the textarea and displayed.