I don't think this is possible, but thought I would ask. Is there a way to trigger an onChange event. I have a couple of radio buttons and use ASP to change them at somepoint. When it does I want to trigger the onChange.
I have a list box that has a list of names, and i want when the user selects the name to bring some information from the database and put it below the drop down box. I think i need to use an onchase event but how do i get the page to refresh to show the new data, suggestions or examples woudl be great.
I have a usercontrol which contains ajax toolkit controls which I am using in a SharePoint siite. When the user clicks one of the buttons on the page it fires a series of events server side (creates a new project in project server, creates an new SharePoint site ... ) each of which take quite some time. I would like to display the successful completion of each event in the control to so the user can see what progress has been made.
I am struggling to understand how I can engineer the page to perform each task in turn, post the page back after each task has occurred (to update the UI that the task has been done) then fire the next server side event. It's easy to update a control with the status changes but the updated control is only displayed to the user when all of the server side events have completed.
I've decided after several failed attempts this is too difficult to do on my own. I know it's been done before and a tutorial or code must by lying around somewhere.
I have a Weekly Calendar
It's in a table with 7 columns and 22 rows
Across the top I have Monday thru Sunday
Down the side I have half-hour time increments - 8:00am - 10:00pm
I would like to display my events on the table, corresponding to their day and time. If it spans several hours I would like the event to span several rows.
Basically look like an Outlook Calendar.
I've tried this myself with five dozen if/then statments and embedded loops but it's a huge mess.
I'd like to find out how to simply do this in asp (not ready for .net yet), any ideas?
I have an ASP VBScript page with a dynamic table. Each row contains a dynamic price, a qty field, and a total. The total on each row changes (onChange() ) when a qty is entered (this works fine). I now need to total up the 'total' fields and put a 'GrandTotal' into a variable for later
I'm wondering if it's possible to write recordsets into HTML table cells, say, 3 columns wide using a loop? I've tried it but obviously I need to get 3 records out at a time so I can't detect the end of file. Any ideas?
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?
I'm trying to update several rows to the same table of a datbase using ASP & an access database.
But I can't seem to get it working. I can get it working for one row but more than that won't work. The amount of rows that need to updated is never the same.
I'm sure it sounds kinda nutty to display 200 columns and 500,000 rows of data. But I have been pulling data from a Lotus Notes database into Sql Server for a while now, but Lotus Notes is starting to crack, columns getting corrupted. Can't handle the volume of data and number of columns. Sql Server has no problem. But displaying the data is the big deal. The end users want to be able to scroll acros a page to the colum of their choice, or be able to scroll up or down.
I was thinking of breaking up the table into section, but this would reqire additional clicking to get to the next section of the table. Would it be feasable to have a 200 column table in asp? or should I stick with the section idea? I have to tell my dept something. They started out with Lotus Notes but couldn't query the data. I have been suggesting to migrate the project entirely to Sql Server/IIS. Notes can at least display all the columns.
I am creating a table with two rows(one of which is the header), and 8 column headings. In the 2nd row, i am trying to apply 3 different colours that span various length across the row. I want the row to loop adding one colour directly to the end of another, but adding this to the correct length of colspan for each colour.
The code below is what i have done so far, but i only get a blue colour in the 3rds cell. Eventually i would like to have a variable length of row, as i do not yet know how many rows i need (this will be dependant on something else). But i would like the colour method to be applied to each row.
Also i need to be able to make colspan variable so after each loop, it will be updated by the new column amount ....
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.
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).
I 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 want to add a row to library table. Table has total 7 fields. But I want to create the new row with 5 field data. When I run the following query in MS Access
strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES ('B-096','Hihihihihi','hello','Book','07/18/04')"
It successfully adds the row. But same thing I am trying with the following ASP code. It gives error, saying syntax error in INSERT into statement. 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:
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.
Im running a select statement to a database and wish to display the relevant records into a table. For some reason, its not liking this - can someone see why, and or tell me an easier way to produce an 'automatically generating' table of results.
<body bgcolor="#FFFFFF" text="#000000"> <!-- #include file="dbConn.asp" --> <!-- #include file="adovbs.inc"--> <h1>Your search results returned the following popup messages:</h1> <% Dim msgtype, title, message, url msgtype=request.form("type") title=request.form("title") message=request.form("msg") url=request.form("URL")
Dim adoDB, adors, strSQL set adoDB = Server.CreateObject("ADODB.Connection") adoDB.Open strConnection set adoRS = Server.CreateObject("ADODB.RecordSet") strSQL="SELECT PID,P_TITLE,P_MSG,P_URL,P_TYPE FROM POPUP WHERE (" If msgtype <> "" then strSQL=strSQL & "P_TYPE='" & msgtype & "' " If title <> "" then strSQL=strSQL & "OR P_TITLE LIKE '%" & title & "%' " If message <> "" then strSQL=strSQL & "OR P_MSG LIKE '%" & message & "%' " If url <> "" then strSQL=strSQL & "OR P_URL LIKE '%" & url & "%' " End if strSQL=strSQL & ")"
I want to do is search through a database based on what was selected on a form.It will be based on state, county, and category.Out of the search I just want one field out of the database, the email field. Now, at first I had one table to mess with so I was using this:
strSQL = "SELECT DISTINCT EMail FROM Info WHERE Category='" & category &"' AND State='" & state &"' AND County='" & county &"'"
the way the database is going to be set up now what I need to do is search through one table that will have all the states, counties, category, and UserID fields.Then it has the other table that will have a UserID field and an email field.So I guess it needs to go through the first table and depending on what state, cat, county were selected it will take that UserID and match it to the UserID in the email table and then pull the emails that match UserID.UserID? Would this use JOIN? UNION? How would this be done, to take the form info and search the one table and then depending on what userid matches the state, county, and category in that table it matches that userid to the userid in the email table and pulls the emails from the email field.
Quote: sqlConnect = "SELECT Users.User_ID, Users.Password, Users.Username, Event.Event_ID FROM Users LEFT JOIN Event ON Users.User_ID = Event.Admin_ID where Username = '" & Username & "'" set rs= Server.CreateObject ("ADODB.Recordset") rs.open sqlconnect, objconn, 3, 3 where username is an ASP variable of the username.
When I run this and I try to access a field from event I get an error i.e.
Quote: if rs("Event.Event_ID")<>")" then session("admin")= rs("Event.Event_ID") end if Does anyone know what is wrong?!?!?! It doesn't seem to be able to pick up the fields from the event table?
I'm trying to do a multiple count on different tables in my database, but it's not working. At the moment I have this SQL query, Code:
SELECT COUNT(*) AS articlecount, COUNT(*) AS faqcount FROM article, faq; This doesn't work though. If there are 2 articles, and 3 FAQs, it will still say 2 FAQs Can anyone give me the proper SQL query, if possible?
I've got quite 20 identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: sync all MDB designs (and/or data) esignated to match one I've added some fields/tables to OR go into all designated MDBs and create new field(s) or table(s).
I've began writing something like this that right now just does part of (b) but I'd rather find something that is much more slick and complete.
I am using a db to hold student data records. I currently display them in a roster based on their affiliation with a certain class. To edit a record I need to click the name of an individual, it opens an edit page, I make the changes, hit submit and return to the roster.
This is pretty standard stuff. What I would like to do is change one field of every record without opening each record individually. The idea comes from my Fantasy Fball league roster:
Where the example above says "ActiveReserve" is a pull down menu that lets me change who is playing week to week. I can then change each record, hit submit one time, and update the db. So how do they do it?
Does anyone know how to insert multiple records in the same table at the same time. This is what I have. I have a form with 6 fields and they are name prod1 through to prod 6. The table is called related products.
Basically this table is related to the main table called prod_parent. tried looking on google and couldn't find anything.
I need 2 colums of one table to equal the value of 2 columns on another table any time data is inserted there. Never messed with a trigger before so I'm want to get help so I dont screw something up.
table - dbo.lotinfo
column - idrma column - idlot
table - dbo.lotbd
column - idrma column - idlot
anytime lotinfo has data inserted in the above columns I need the respective columns in lotbd to equal the same thing automatically.
Any professional advise out there for a begginer with this subject?