I have multiple fields (BLM, WHM, RNG, MNK) each with a numeric value. How can I search across these fields for each record and find the highest number.
Example:
Name BLM WHM RNG MNK
----------------------------------
Jason 19 52 33 18
What I want it to do is return and display Jason WHM 52
And I want to do this for every record in the table.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I want a way to be able to add up to 99 new items into a table. I've search around but haven't found much. I think I am using the wrong word or function?
Entry page would look like:
1. var1, var2, var3,... var10
2. var1, var2, var3,... var10
3. var1, var2, var3,... var10
4. var1, var2, var3,... var10
5. var1, var2, var3,... var10
99. var1, var2, var3,... var10
I can't do a "INSERT INTO table_blah Values()" . Should I look towards an Array? I suck at those.
Visually, the page will look somewhat like a spreadsheet. It could have
hundreds of records (rows) displayed. I want to enable the user to edit any
one or any number of records and any fields, then click a save button to
UPDATE the SQL table. I'd like to use stored procedures if possible. How is
this done? Where do I start?
I need to have a table with 3 fields whereby the user can input the data and insert into my database using this website. However, I need this table to be dynamic so that after the user input the info for the first row, the user can click on add another row button and another blank row comes out. then the user can input the info for the second row and so on.
I am using ASP in the end to insert the data. I need some advice on how to create this kind of table where the user can click on one button to add another row and then able to insert all data in the entire table into database using asp.
number filename filesize
1 aaa.asp 123MB
add more data
if i have an online invoice and i want to insert all the items of the form into different rows of a table.
is it possible and can get the code ?
How do you group multiple rows from a sql recordset on a unique id in ASP? (ie: I get 5 rows for id=9, but just want to display the top row based on my Order By).
View Replies View RelatedI use Access Data Base 2000 and ASP configuration. My case is that I constructed a Editable Grid with 5 columnar labels so that I derive many rows from database for the client to choose from by the help of check boxes that I externally added for each row. What I have to do is after client chooses the rows by clicking the check boxes and then clicking on the submit button.
I would like to insert the marked rows with labels(4 or 5 labels)into a differant database table from the one where the data was first drived. BTW, within the editable grid I have 4 submit buttons and each button should insert checked rows into differant data base tables.
I am try to insert data from a form in to an access db When a store is added this asp page writes to two tables in the database But the product data need to be add to 5 individual row but I get this Error Identity cannot be determined for newly inserted rows.
I think I am writing The data into the same row every time. What can I do to make sure I a creating a new row every time I update rsproduct Code:
I've got a little user poll system and I'm trying to create an 'edit' form. The form relates to 2 database tables, one holds the poll details (title, start date, end date, etc) and the other holds the answers/options (answer_id, answer, etc). I've successfully setup the form so it updates the poll details but I can't work out how to update the answers? Code:
View Replies View RelatedI can trigger these events successfully if table only has one row:
Sub InputField_OnChange()
......
End Sub
But, these events cannot be fired if table has more than one row, why?
I need to set up my front end app to update multiple fields with the same entry. See below.
Database: Testing
Columns:
Recdte
Invdte
So in this case, the user would need to update the Invdte with the current date for all rows where the Recdte is a given value. I know how to do this in SQL but not in ASP.
how to inner join multiple fields.
I have 1 table SCHEMA1 wich contains:
id|wedstrijd|speler1|speler2|speler3|speler4
1 1 1 2 3 4
2 2 2 1 4 3
The other table SPELERS contains
id|speler|naam
1 1 Jan
2 2 Piet
3 3 Klaas
4 4 Henk
I would like to have te next result:
wedstrijd|speler1|speler2|speler3|speler4
1 jan piet klaas henk
2 piet jan henk klaas
Can anybody help, because i'm lost......?
Is it possible to do an update on a recordset like this?display all the fields in a form and let the user pick which ones to update? What happens if they pick, say, two of the total to update, and leave the rest of the form fields blank? Would that update the chosen records and leave the rest of them blank or null?
View Replies View Relatedhow do i add afew items into a database of only a field name?
for example if there is only item_1.. it will add item_1 only. but if there is item_1 & item_2. how do i add them to the database name ("Items No")?
I have 4 number fields in the same table and need to display the lowest number from all 4 fields, is this possible?
View Replies View RelatedI have 4 tables first table category (category_id and category name in it)
second table artist (artist_id, category_id, artistname in it)
third table album (id, artist_id, album_title in it)
forth table song (id, album_id, title in it)
I'm selecting category in first page
I'm selecting artist in second page
I'm selecting album in third page
I'm requesting, collecting and posting all id's to the next page.
this is the question!!
How can I read from database
1- category name when I was selected in first page
2- artist name when I was selected in second page
3- album name when I was selected in third page
I've got 4 records in my lovely database table. The table contains 5 fields, lets say: id, number, name, age and sex. All I want to do is to get all the values (form all 4 records) of the "number" field and put all 4 of the values in to one variable.
The output have to look something like this : numbers: 001, 002, 003, 004.
I tired, honestly, I really did. But didn't find a solution.
How to create multiple text fields and will be submit when press a "enter key" ...
View Replies View RelatedIs there any way that I can break up text in a text field to spread across multiple fields in an access database? I've got a FAQ section that I want admins to be able to edit via an online interface. Unfortunately, it often doesn't fit into the 255 character restriction that access has. Any ideas?
View Replies View RelatedI'm having trouble passing hidden fields between forms. I have a total of four forms. I have the 1st form passing its field to the 2nd form, and the 2nd form passing its field to the 3rd form, but the 1st form's field then is not passed into the 3rd form. So obviously, my summary form (the 4th form) is not getting the 1st form's field or the 2nd form's field, only the 3rd form's field. Code:
View Replies View RelatedI am using this script to submit my form fields into the body of my email:
***********************************************
Dim strBody
dim ix, formElementName, formElementValue
strBody = "Results of form submitted at " & Now() & vbCrLf & CrLf
For ix = 1 to Request.Form.Count
formElementName = Request.Form.Key(ix)
formElementValue = Request.Form.Item(ix)
strBody = strBody & (formElementName & ": " & formElementValue & vbCrLf)
Next
***********************************************
I'm completely new to vbscript and have been searching all over the net for an example of this script being used with mutliple fields with absolutely no luck.
The closest I've come to getting something back from this thing is when I tested the script with these elements:
FormElementName = Request.Form.Key("Name")
formElementValue = Request.Form.Item("Name")
formElementName = Request.Form.Key("Telephone")
formElementValue = Request.Form.Item("Telephone")
formElementName = Request.Form.Key("Email")
formElementValue = Request.Form.Item("Email")
Which produced this result:
Email: Email
Email: Email
Email: Email
Its seems the answer to my problem lies in defining the 'Key' and possibly the 'Item' parameters but I haven't been able to find any documentation on these terms. Can someone out there please save me from what probably is a very simple solution?
I have a form on one page where someone selects a bunch of options and details about a specific category. Then on the next page they fill out a form with contact information, name, address, email, etc.
Well what I want to know is when they click Submit on that contact form is there a way to have it so it goes through and searches the database for any that match the state and county(which they will select from a )??
So what I basically want right now is for the first form to be filled out, then the second form to be filled out, then when they are submitted it will go through the database and select everyone in there with that state and county, then on the next page display the results of both forms AND the matches in the db(obviously whatever fields I want it to display).
I already have both forms(basic html), I already have the dynamic dropdown for state and county(classic asp), what Im wondering is how do I put that dynamic dropdown in the contact form and then when submitted it will go through and search the db based on what was selected there. Would this be some sort of onClick for the submit button tellin it to search the db based on the dropdown or how would I get started on something like this?
There will be other information on the dropdown like name address email so one problem I was wondering about was my dropdown menu. When you select the state it refreshes the page and then loads the counties, so wouldnt that erase anything that was filled out on the form?
I could make it so they actually type the name of their state and county but that causes problems too because if they mispell either then it wont return any results.
How do you return the highest value in a recordset of maybe 100 records?Is it necessary to run 2 recordsets?I was hoping it was as simple as Max([Price]), but no luck.
View Replies View Relatedi am trying to pull from my mySQL database the highest ocurring value of one field.
example:
name / value
peter / 6
alex / 7
ethan /5
thomas / 6
brett / 7
ryan / 6
albert / 6
if this was a table, i need to get "6"
I am fairly familiar with asp, but with non-traditional training.
I've got a database that has 5 numeric values for each record. I'm trying to figure out how to have the records sorted alphabetically, but highlight the highest value in the table for each column. So in other words, the table shows up with one record in each row, with a total of 6 columns (the name plus 5 columns). I want the highest value in each column to be emphasized.
So the final product would end up looking like the code at the bottom of this message.
I've pulled the records from the Access database and am able to sort them alphabetically and get the table to appear. What I was thinking is that at the top I'd define variables that correspond to the highest record for each column. Then in the table code I'd set the colour of each cell using an 'if then'.
So I have 3 specific questions:
- Is that the best way to do it? I don't want the page to take 20 minutes to load because I'm overloading the server.
- how would you set the variables at the top of the page?
- how would you write the if then in the middle of the table to change the background colour of the cell if that value (or values, in case there's a tie) is the highest of all the records? Code:
I'm so full of questions these days. I've got a hidden input in a form that I want to be set to 1 more than the highest number in the colum "userid" of my table "users" in my database.
Is this possible? If so, how?
Code:
<%
dim userid
userid = MaxNumberInDB + 1
%>
<input name="userid" type="hidden" value="<%=userid%>" />
Like that, but how would you find the "MaxNumberInDB" ?
I'm currently running my personal website off of my home computer which is running Windows XP Home. I'm not using IIS for my webserver.
I'm wondering what the best ASP servers are that I can utilize on my home system. Any suggestions?
I am learning them and using them in a project simultaneously. I felt VBscript is a little primitive when it comes to error handling. I mean I can't put "On Error Resume Next" command before every code line of the program. That's one of the problem I came across so far - and for me it is a major draw back to develop a application with no or little error-handling.
which is better to use along with ASP - VBScript or JScript or JavaScript. As I don't have experience using them, I can't judge which is better to use in a real time project.
When there are mutliple ASP version installed on the same machine there
will be corresponding directories under "WINDOWSMicrosoft.NETFramework"
Ex: my webserver has following ASP folders
C:WINDOWSMicrosoft.NETFrameworkv1.0.3705
C:WINDOWSMicrosoft.NETFrameworkv1.1.4322
1) Can I have one website using v1.0.3705 and other using v1.1.4322?
2) How to know the ASP version that is being used?
I am trying to do a search and let the user choose the sort order. I am using a form with an text input box to enter the search value and a combo box to choose the sort field. The search works fine but it won't sort: Code:
View Replies View RelatedI have an ASP form which only includes an option list. The list is dynamically created but includes a default value, which is an instruction "Select a group".
The code is shown at bottom. I want to ensure the user does not submit the form with the default value selected. Code:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.