From a PHP background I could use mysql_num_rows() to get the number of selected rows from a SQL query. Looking through Google I can't see a way to do this with ASP.
One place I looked said you need to loop through all the selected fields and using an incrementing counter, which doesn't sound like a good idea :/
If this is the case (which I hope it isn't), is there any way like PHP which you can then tell the SQL object to go back to the begining so you can reloop it (if you catch my drift)?
I need to count the number of rows in a table, and set the number to a variable so I can use it as a sentinel for a control loop . I know I'm supposed to use Count(*) but i'm not quite sure of the syntax. for i=1 to (the number of rows in the table) if breakloop=true then exit for (CODE) next .
I have created a form which asks the user a series of questions. I am able to retrieve the information from the database but I need to know how many rows of data has been entered for each question.
For example I have a question which asks the user what age range they belong to. I need to find out how many rows of data has been added into this column in the database. Code:
i have written a code to change password. it works perfectly i.e. sql query "update is ok", now i want to display number of affected rows that i can inform user if password is changed or not. Code:
I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
in master batch table i have various master batch like 200701-0001 200701-0002 200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01 200701-0001-02 200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed, i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
Drop down value is selected and a query is performed on that value - I want the selected value to stay in the drop down field. Right now it goes back to the first value in the list once the submit button is clicked (it queries correctly).
When I come into the page there should be no value in the drop down list and when a value is selected it should stay in the field.
I have 2 drop down lists here. Supposingly, upon the selection of the 2nd drop down list, I should be able to see textbox entry allowing user to update data being displayed at the bottom. But in my case here, i see no response upon the selection of "selType" which is my second drop down list. But both also don't work. So any suggestion on how can I retrieve the 2nd drop down list' selected value
I have combobox that those value is based on my database. So i want to get the selected value in order to do another matching for the SQL statement. May i know how to get it? Is it just use for example WHERE column=' "&combobox&" '? use the combobox name.
I have an aspx file where i've put a placeholder element. On load i create dynamically a table which contains a checkbox and a radiobuttonlist in each tablerow . The radiobuttonlist contains two items (yes,no). Both the checkboxes and the radiobuttonlist are NOT autopostbacked ( .autopostback = false).
When i press the submit button a sub is run. My problem is that i can not get the selected items in the radiobuttonlists.This is caused cos in the page_load i call the sub that dinamically recreates the table described above and so all values are reset (there is a rdb.item(0).selected=true line in my code.
If i try to remove it, the radiobuttons keep their values or not,after each submit, without a pattern!). I've also tried to keep the values in a collection, instasiated in the page_load but i couldn't do so cos the table (that contains the checkboxes and radiobuttonlists) is not recognized at the beggining of the page_load (i guess it's not an object yet cos the sub that creates all that is at the end of page_load)....
I have a drop down select box that gets filled from database. I have to add "All" to this list which does not come from database. Also the default selected value should be the second value that is stored in array. For ex I have array of Countries names as America, Indonesia,china, Canada. My array gives me the value Myarray(intcount,0)(intcount,1) as America and so on (two dimensional array).
I want Indonesia as the default selected value when the page loads. Also I need to hardcode All at the end. Upn submitting the form the selected value fromthe drop down should get selected.
I've got this listbox and this text field on an ASP page. Now I want the item I click on in the listbox to appear in the text field and I can't find the code nowhere for what seems to me such an easy thing to do.
I have an asp-page where I want the user to make a selection with a listbox. When the user changes to another listboxelement the page gets reloaded and depending on the selection a different content is shown.
I got this working so far but when the page has been reloaded the listbox always displayes the first selection in the list and not the one which the user selected. Code:
I have different templates for different companies to be sent to the customer. first i get all the templates from the DB by giving: Select templates from tempates;
Now i want the user to select one..may be we can have a radio button displayed near the textarea in which i will be displaying the templates from DB. Once the agent selects one of the templates to be sent,that template should be sent as an email to the customer.
How do i go on achieving this ,with good formatted template in the DB?
I have a requirement where I need to have windows authentication enabled for only few ASP pages of my Site (Virtual Directory), rest of the pages should be enabled for anonymous access (No Authentication Dialog). Could some body guide in achieving solution for this.
Flow Steps
1. User visits the home page (One.asp page) No NT authentication dialog should appear.
2. The home page will have some Hyper links to other pages, on clicking on the Hyperlink it should prompt for NT Authentication Dialog (asking windows UserID and Password)
3. Once the UserID is validated by authentication process it should show the Target ASP (Two.asp) Page. The Target Page will have a link Named 'Back' which will redirect the User to 'One.asp'
4.Once user is redirected from Two.asp, if user clicks the Hyper Link it should prompt again for the authentication (Previous login information should be discarded, it should prompt again)
The Challenge i face is 1. Finding a solution to implement authentication for selected pages. 2. Logging off the User so that to Prompt the NT authentication dialog again.
I have a form with some textfields & checkboxes.One of the text field allows the user to select a file.When the user submits a form , I am inserting all textbox and checkbox values in a database.But, while performing insert I also want to upload the selected file on web server.Does any one know how to do that?
I have a Multi select box which I have populated with a list of choices. Is it possible to have a second Multi select box which is initially empty, yet when the user selects values from the first Multi Select box, they appear in the second multi select box? I'm sure I can easily do this by just posting the selection to a new page but I'd like to dynamically display the selected values on the same page.
I have a page that is showing X number of records. I have a column with a check box in front of each record. I would like the user to be able to select certain records by selecting the check box in front of the record and then have the user hit "Submit." They will then be taken to another page in which only the selected records are shown.
I'm having trouble with my SQL statement. I'm not quite sure how to word my SQL statement since I do not have a field in my recordset that points to the value in the checkbox.
In other words, I'm not sure how to carry the value of the checkbox over into my SQL statement when I don't have a field for it. Do I need to add a field, and then update the field on a confirmation page before I use a SQL statement to show me the selected records?
I have a dropdown menu with parents' names, and on the same page when a name is selected (through an onChange event), another drop dpwn boix containing student names change according to the parent selected.
But I want the Parent drop down box to contain the parent's name who was selected, and although the event works, it just keeps displaying the first name of the list of parents even after a different parent is selected.
I have a list box with a number of values (4) on a ASP form, the value is stored in a database field.
When a form to amend the record is loaded, I would like to display the list box with the currently held value as the seleceted item in the list box. e.g.
4 items in listbox A B C D
B selected and saved.
Amendment form displayed, List box contains A B C D, with B highlighted.
My site is a golf site where the players post in there own scores, a season consists of 6 weeks, each week earnings are given to all players depending where they finish.
I need to display the earnings for the season, (week 1 -6) added up and in the right order, what seems to be happening is the earnings are added up ok, just the positions are all wrong, ie if I go to ?seasonid=2&eventid=8 i display the total earnings for season 2 (event 7 - event 12) but in the finishing order for event 8. ORDER BY is working for current week, so dont think its that, I zipped up the code.
I have a simple form and want to submit a selected value of a combo box. so my combo box is named "selectname" and my form has action="file.asp?" what do I have to put after the question mark ?
how would I go about setting the <selected> attribute of a jump menu to one representing the current page? background info: i have a template-based site employing a jump menu as the navigation, but for usability's sake it needs to not reset back to the first option in the menu, but rather hang on to the current page as the 'selected' option. example of similar HTML showing the hard-coded 'selected' option I need to change: Code:
I have two date fields and i have in each one a calendar. I want these dates to be validated. They both should not be prior to the todays date and date 2 not to be prior to the date1. How can i do this people?