I have an asp page that creates a table from a Ingres II database. The headers at the top of the columns are hyperlinks that ad a order by to my list. This was all working fine until I added more choices with a drop down list view_type .
Now I am getting this error: ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. I am thinking it has to do with when my list is reordered it does not know which view type and is not going through the count. Code:
I have created a webpage with a form written in javascript for a user to enter information. Part of this form requires the user to type in information and then add it to a list, which is of the type <SELECT>. When the user submits the form, I want all the entries in the SELECT list to be entered into the database. If I use the command Request.Form("name"), where "name" is the name of the SELECT field, only the selected entry is retreived. I need to retreive all entries in the list. Does anyone know how I can do this?
I am using Dreamweaver MX to create ASP and MS SQL Server for database. I got a few fields like Value1 - Value5. So i have create the recordset of the 5 fields and i am extracting the total count of each field. Now i got 5 recordsets showing the total of each field. So is it possible to add the value of the 5 recordset together into one value? And is it possible to use the value of the recordset to do some simple math addition, subtraction, multiplication and division?
i am having trouble adding a recordset into the access database, the code seems to be working fine it passs and parses through all variables just fine without showing any errors and also when i access the recordset it displays the results, what the real issue is that the entry is not made into the database even though i use the Update command and i have also tried the BeginTrans and CommitTrans nothign seems to work and i am unable to figure out wats wrong with this code.
I am designing a website to records details of people who visit our company. When entering a visitors details I wish to record the company that they work for, to save the user time a dropdown list of companies is populated dynamically from the backend (Oracle) database. In the event of a company not existing in the database the user would have to go to the page to add a new company and then come back to the form meaning that they would lose anything they have already entered.
What I am trying to do is to enable the user to click on a link which will bring up a pop up window into which they may enter the new company, on closing down this popup the new company will be added to the dropdown list.
So far I have got the popup to display and to accept the user input and I have inserted this new company name into the database with a unique reference number generated by a sequence and before_update trigger. The following code is for the popup window and accepts user input, writes it to the database and closes the window: Code:
Let's say I have a dynamic list/menu, which gets its values from a database table, for example a list of contact people where the value is an ID number and the label is the name. However, if the value the user wants is not in the list I would like to place a hyperlink which will...
(1) open a small window, with an ASP form to allow the user to add a new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about. I don't like the idea of forcing the user to leave the current screen, go to some other form, add the entry they need to the lookup table, then come back; this seems like a logical approach, but just wondering how to make it work.
This seems like a common enough situation; anyone have any code samples or suggestions about how to do this?
I have a repeating table set up to display the results of a recordset. What I want to do is "attach" a layer on the side of it and have it be a different color with different text in it based on one of the results in the recordset.
I.e. say I have a field called "reponses", if it's value in one table is 1 I want a green layer with the word "yes" in it positioned next the table, in the next table if it's value is 2 I want a red layer with the word "no". Is something like this even possible?
How can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?
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 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 have a form on my asp page that sends data to an emailing script. I am working with other peoples code which is causing a lot of hassle. Is there any way of sending a Bcc address command from the form rather than the emailing script?
what do you think is the best way to implement an "add new row to table" functionalilty? am using asp(obviously )im currently using document.createElement with javascript, but im having a hard time retrieving the data.am also thinking if this is really the best way to do this.or if this would work with all other browsers other than IE...
how to add a password to using this connection string
<% set conn = server.createobject ("ADODB.connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("dat48372.mdb")) set rs = Server.CreateObject("ADODB.recordset") SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)" rs.Open SQL, conn showall=true %>
and I know that access table cannot have a picture in it, only a access form using OLE, but how do I get my asp page to display a picture for every record? The picture would be a picture of the product with the Stockcode as the filename - m001110.jpg?
I have an ASP page with a table that fills with records from a loop. Every row gets a link to another ASP page with data from the row. The link is written as <a href=newpage.asp?value1=xx&value2=yy .... and so on. Now I try to let the user specify a number that should be sent to the other page. But I do not want to clutter up every row with each an input field, so I thought instead I would place it above all the data rows. When the user clicks on the link, I want to include the input field to the querysting. The problem here is that I cannot figure out how to refer to the name of the input field.
I have just finished building my first shopping cart in asp and MS Access. Originally the shopping cart was to be built for products with no size and colour, however as usual the goal posts have moved and I now need to incorporate a size and colour option for each product. Could anyone explain to me how I can go about doing this i.e. adding the different sizes and colours in the admin website and then linking them to a specific product when it is displayed on the products page? I know they both need to be in a dynamic drop down box when displayed on the products page within the shopping cart, but I am just wondering how to read the correct values out from the table depending on which product is being displayed. I have a normal products table at the moment with general fields i.e ID, name, description etc.
I have a web page hosted by server1. I need to add a link to a web page hosted by server2. This part is simple. However, I also need to give the linked web page the user id for the user that was validated in server1 (it's in a session variable).
At first, I thought the following would work: mywebpageonserver1.asp: Response.AddHeader "MYUSERID", "whatever" Response.Redirect "http://server2/mywebpageonserver2.asp"
i have a page that enters numbers stored in different values e.g monday tuesday wednesday thursday friday into a database. is it possible in asp to add those values up and store the added up value in a seperate field in the database bascially total =monday+tuesday+wednesday+thursday+friday How would i do that in asp.
I need to add a ppicture to my Database.. The table is accessed through ASP Recordset but having troubles trying to insert an individual picture to each record?
I need to be able to add multiple records quickly, for example I need to add
name value abc 1 abc 2 abc 3 abc 4 abc 5 abc 6
etc etc, does each record have to be added separately, or is there a way I can add a chosen number of records, lets say 10, and have the value field increase by one each time?
sometimes I might have 30+ simple records that need adding quickly, and each time the first records value will be one, and each record after will increase by one, is there a way to solve this problem or does each record have to be added separately?
regarding adding or getting sum all of the numbers in the database fields example of the Fields:
Totay_Payment 10.00 20.00 30.00 40.00
My problem is i cant display the exact SUM of all numbers and it goes like this 10.0020.0030.0040.00 and i want the exact sum like this 100.00
heres the example of my script :
inTotalPayment = rsSumNumber("Total_Payment") Do While Not rsSumNumber.EOF intSum = intSum + intTotalPayment rsSumNumber.MoveNext Loop Response.Write(intsum)