I have a form that users use to register with the site. On this form there are checkboxes all with the same name but different values. I am creating another page that will allow users to login and edit their information.
Since all the data from the checkboxes are stored on the database under the same field name and separated by commas; how do I dynamically create a set of the checked checkboxes that the user originally entered along with the other checkboxes the user did not click?
I have a problem with retreiving non repeatable values from database.(this is a shopping cart application)I wrote the query as below,but it didn't work
sql="SET ROWCOUNT 10 select distinct(product_name),pdate from addcart order by pdate desc".
Actually iwant to see recently viewed produts name (max 10) for this iam retrieving values from addcart table. By executing above query iam getting 10 products name but they are repeatable.
I am generating between 5 - 15 dynamic checkboxes in a specific database search. The user will at most only select 1-2, maybe 3 checkboxes at a time. Through a form, i want to find out what checkboxes were clicked and get the value contained in the checkbox.
Can any of you suggest a suitable method of doing it? i assume i'd be using a 'for' loop, if i can get a foot up on how i'd go about doing this
I have a feedback form which user completes and data is submitted to db. I then want to allow user to edit this form so I retrieve values from db and populate the textboxes. This is working fine. My question is how do I set checkboxes and radio buttons to reflect these values?
It must be something like 'if value is ?? then check the box', but what is the correct syntax and is this code placed within the actual radio box/checkbox?
I have a MS Access Database. I have a page where i do a search for a item by date, I select a date and then all the information from the database that i requested appears.
From all the information that appears I want to be able to tick the ones that I want to delete or a select all button and click delete and all the ones that where ticked will be deleted from the database.
I am loading a table from a database which all works great, I have checkboxes beside each database entry which is great. I want Delete, Modify and Add buttons underneath the table which I have also and that is great.
Problem is I want these buttons to be able to know which check box(s) I have selected and delete all info from tblProspect that matches that ProspectId when the delete button is pressed.
I want all info from tblProspect that matches ProspectId to be copied to tblClients when the make a member button is pressed and delete the info from tblProspect. Then I want the button that says Modify Prospect to load a page that shows the prospect information, where it can be modified and then have an update button which will change the information in tblProspect.
ACK I can't wrap my head around this tonight for some reason and it is driving me nuts, I keep trying different code and deleting it. Code:
I have the following database sturcture: tblUnits unitID, UnitTitle
tblObjectives objID(PIK), unitID (FK), objTitle
I display a form with drop down select list based on the results of a query on tblUnits when user selects an option from select list I display the correct Objectives (in the form of chekcboxes) for that option.i want to store user choices in another table :
tblUserObjectives userID(PIK), objID, selected (not sure if this is reserved word in access?).
I would also like to display the choices to the user when the form has been submited. Can someone tell me with the last table structure, query and how to approach this problem.
I am tring to create a front end for this Access Database someone has given me and i have trawled through these and other forums for the answer to my question but have not found anything!!
I have used 4 checkboxes in a form with 4 different names, when i try and create a record in the access database which uses the Yes/No Field Type it displays the error, " Provider error '80020005'
type mismatch" when trying to right the value into the field!
Can i get any asp sample codes to retreive photo's from access database For instances:To get codes on your pages Response.write...... similiar for images.
I created form for web page and connected that page to MS SQL database. I don't know how to put database data to according cells. For instance, to get data for Classroom, Date, ets. Code:
I have to develop an online quiz on my website. the site is developed in ASP. i have a access database of the questions, the multiple ans.s and the correct ans. every quest. has an unique id.
i want a way by which any 10 'unique' quests. will be selected from the database everytime an user takes the test.
I have a DB table, which contains the name of a image file stored in a folder. What i need to do is somehow retreive this image and display it in an asp page?
I'm a newb - so if this is a stupid question, my apologies.
I have a simple form that users fill out and then that info is written to a database. What I'd like to do is perform a calcution on a number and then write those numbers to other records in the database.
So for instance, if someone enters 12 in one field1, it would multiply that by 3 and that would be saved as field2, then mulitply it by 45 and that would be field3, then add field2 and field3 and save that as field4.
I was thiking of passing the form variables to a second page instead of writing them to the database, then using variables in the second page to perform the calculations and then have the second page write all the info to the database, but I thought there had to be a better solution.
We have a fairly large datbase containing thousands of part numbers, product names and pricing. We used to update new pricing changes individually by hand. However, now that our database has grown substantially, I'm wondering what the best method would be to keep the pricing current on our database?
We can obtain new price lists in excel format, however, the part numbers the mfgs use may not necessarily coincide with the part numbers we have. Should I just write some SQL script? Look into using XML? What would be the most efficient way to tackle this problem?
I was playing around in FrontPage and I noticed that you could insert an ActiveX control for a calendar. I would like to be able to use this to integrate with a database - for example, I would like to be able to click on a day of the month and have the page display all data associated with that date (sort of a select * from database where date = "date_clicked_on")
I am trying to add entries in a database together and place the summed value into a text box. Like a total ordered type function for an ecommerce site. I have a field called ArmChairs in my database and based on how many people buy them, I want to know how many I need to have shipped.
I am really struggling with this last bit and would be really appreciative if someone has some code examples.
This is my error in ASP. In my database i am having one field called title which contains some string including spaces . when i get this value into textbox in my web page value is displaying but after space is not displaying .
I want to populate a listbox from a database. This listBox will contain the value of the Table PK. Whenever i chose an ID the input fields in the form below will change corresponding to the PK.
I have a dynamic table asp/vb that is returning records as expected. There are 7 fields that are returning boolean values based on whether there is or is not a meeting on those given days.
My table is returning TRUE and FALSE and all I want to do is create an if or select statement that will detect the values in these fields and change them as follows:
If true, then field = "R" (Wingdings2 R is a checked box) If false, then field = "T"(Wingdings2 returns a x'd out box)
I made a 2 web surveys with identical code. Although the code is similar in both, values on the last page of one of the survey do not go in the database.
I have tried playing around (coz I really dont understand what the problem is), but nothing works. The same code works on the other survey with absolutely no problems.All thats there in my survey to insert values is
.Fields ("fieldname") = Request.value ("name of text box") .update
Any suggestions? If someones willing to help me out quick, I will post my code.
I have a registration form that I'm making and I need to get the count of available spots for each class session. I can't get the array to return something like "0,0,0,0,0,0". Is there a way to do this? There are 6 total classes and they are named 1, 2, 3, 4, 5, and 6.
When you start out, each count will be 0 (meaning no one signed up yet) which makes the openSpots variable equal to 35 (maximum # allowed). Code:
We use an ASP application in which we send out emails using cdo for various events.
At present the email text is hard coded into the code. for example
strMessage = "Dear " & rs("firstname") strMessage = strMessage & "Your request has been approved with reference id " & rs("id")
This causes an administration overhead as everytime the text of the message needs to be changed we need to alter the code to incorporate text or database values.
What we want is to store the message text into a table so it can be altered by the application administrators through GUI by adding the text through freetext entry and field names though a dropdown. Code:
I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
I have an asp page, which displays graphical images.I am using Flipper graph in my application.
There is a link in the asp page "Click to view Image file",On clicking on this link,The graphical image need to be stored(Preferably in the server machine) and has to be opened in a new browser window.
To explain in detail. On clicking of that link"Click to view Image file" a function is called which does the following
1)Save the image file(.gif file) on the server machine Graph.ImagetoGif("Location to be saved",100,200); 2) Opens the image on a new browser window.
window.open('from location from where the image is to be retreived',100,some more properties) So i need the image file to be saved in the server and retreived from the server.
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
