ive got a table filled by a recordset with a column named "STATUS"
each record is a sale transaction. the status of this transaction is either open or closed. right now the table displays whats in the database as is, but i want to add the functionality to be able to close a transaction from the table.
i was thinking of 2 methods, one would be a check to see if the field = open, and if it is, make that field a link to a small popup that verifies the user wants to close the transaction then does its lil sql thing aand updates the table.
the other way i was thinking was to check if its open and make it a drop down list that will update table when submitted.
im veering more toward the former idea(not a fan of drop downs)
this is a problem that is cropping up for the other developer here and i can't seem to find anything wrong. this code has worked for months and then the last couple of days it started sporadically not working. i'm thinking that it has to do with a performance issue but i'm not sure.
i don't use the ado .addnew or .update, so i'm a bit unfamiliar with the workings of it. here is a brief overview of the code.
ordRs.AddNew ... do the field updates ordRs.Update order = cint(ordRS.fields("order_id")
the problem is that order sometimes ends up as null, it's not getting the order_id field after the update. like is said, it's sporadic. anyone have any thoughts here?
The code below is a bit more representative of what I'm doing:
<!--#INCLUDE FILE="Database_Open.asp"--> <% sql ="SELECT * FROM CustomerBase WHERE " & _ "UserName='" & username & "' AND " & _ "SECRETWORD='" & password & "' "
RS.Open Sql, Connection, 3
IF RS.EOF THEN 'redirect code here ELSE RS.Fields("Fullname").value = "Bob" RS.Update %><!--#INCLUDE FILE="Database_Close.asp"--><% Response.Redirect ("Menu_Account.asp") END IF %>
I'm having a spot of trouble trying to update fields in a access database using asp. I can delete and add fields thru the asp page but when i attempt to modify the fields i get a page not found error message. Code:
i have a phone field in one of my tables. the data is pretty ate up. there's some numbers with .,- and extra spaces among other things. how can i do a mass update i would like to have all the phone numbers formated like this 555-555-5555 .
I have a asp form that has a dynamic drop-down box that a user selects a value from. Once the user makes a selection I use the onChange event to capture the selection and pass this value to a vbscript sub.
The sub then makes a adsi query using this value to retrieve additional information. This all works. I used a msgbox to display the retrieved value and it is correct. My problem is how do I update a field on the form with this retrieved value?
My products table has a weight field that I need to populate. A bunch of them have it and a bunch of them don't, but I need them all to have one. The weight is the same, 3, for all the records. I also have an Include field in that table. I want to make the weight field 3 for all records where the include field is true (it's a yes/no checkbox in access.)
I'm using Dreamweaver and I can build the SQL statement just fine but I'm not sure of how to loop through this to set the field for each of these records.
I am developing small asp application.There is a database called db.mdb and there are three tables(tblUser,tbsImport,tblcitylist) In tblcitylist there are two fiedls
1.Town 2.LReg
According to the relevent town there is a LReg (Lreg is a name already assign to the town) this part is ok.
In my tblUser there is a field called Town and LReg (Same as above table) But here LReg is empty.I mean there is a default value called "N/A"
I need to create a asp page for following purpose
* i need to read tblcitylist table and according to that I need to fill the LReg fields of TblUser Code:
Okay Whenever a user logs in we want to track the last time they logged in. My login script worked perfect before this now I can figure it out. All I did was add the way the table opens and the objRS.Update. Code:
I've declared a variable for the current date and want to use the UPDATE function to update the date field in a single record.
UPDATE lms_users Set leaver_date ="&MakeDate" WHERE user_id="473"
I know I have the date format in the variable as if I response.write it to the screen is displays correctly (28/08/2004). I must be doing something really silly, but can't see it.
I have a form where the first field is a dynamic drop-down that pulls from a db (Access). The fields associated with the query are task_id, task_name and task_rate. The field has the value of "task_id" and the label of "task_name".
In the second form field, I would like the default value to be determined by the selection made in the first field. Based on the selection of the first form field, I would like the default value of the this field (task_rate) to be populated with the associated task_rate value of the selection chosen above.
What I would like to happen on this page is that when a user selects a company name from a drop down list, his selection autopopulates the cID field based on the selection. The drop down list is getting its choices from the customer table.
As I am still a novice, I am sure there is a way to do it I have not been able to get it right. Code:
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate Home Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer) GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
I am trying to pass a hidden field value on a form into another field on the form so that it can then be inserted in the database, to enable me then to reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the other input field.)
The code for the text field that allows users to type an number into it for submission to the db is below, but what code do i need within the hidden field to populate this text field below so that users do not have to type the number in? Code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
it would display $100.00 when i go to insert that value into the database the value i get is $100.00 and i get an error, i need to get rid of the $ sign but not sure how to do it because the number range can be from 1 to a billion dollars.
I have this code for asp that if the value is null it insert a null instead of a blank, else i get an error message in access.
'Expiring_Premium = request.form("Expiring_Premium") if (request.form("Expiring_Premium")) ="" then Expiring_Premium = "Null" else _ Expiring_Premium = request.form("Expiring_Premium")
This is hard to explain, but I have wanted to know how to do this. Say you have a website, and you have a news box(where you can report all of your news), made of a picture(s), you know like something that says "news" at the top of the 'box', and the sides of the 'box' are a picture. I have wanted to know how to make one of these 'boxes' without having to use the <div> tag, and type as much text in there as i want, and it wouldnt mess up a table or anything, or realign it, because the <div> automatically wraps around the text, fitting perfectly to it. I was wondering if you can 'wrap' around the text without a <div>, but with pictures. Here is an example, this picture called ex.gif. I know it is a link menu, but what if you wanted to add a couple more links. How would you get the 'box' to automatically resize so that it does not messup the table. I am not even sure if this is capable in ASP, but I am sure somebody knows what I am talking about.
I have a guestbook form that inserts the fields into an Access Database. The database is residing in the "fpdb" folder that was created by FrontPage. The ASP page that writes the data into the databse uses the "recordset.addnew" method. The code was working fine a couple of weeks ago, and now all of a sudden the error message "Cannot update.Database or object is read-only" pops up. The ASP code or the database was not changed or modified in any way, neither were the permissions for the account.
I have quite strange problem and hope you guys can help me out or provide me with some tips. when using a update script: UPDATE categorys SET main_cat_default= '0', banner= '', b_link= '', external_text= 'Nākotnes parks', name = 'Arzemju muzika' WHERE (id = 115)
Then it messes up field EXTERNAL_TEXT. Instead of Nākotnes parks it saves it as Nakotnes parks. But! when I open Enterprise manager and type in Nākotnes parks manually then it saves it correctly. So I believe there is something with update command or smthing like that.I changed collation also to Latvian and this did not work.
For laptop users who have an ASP application running on their laptops - is there a way I can have it check when connected to the network (via the FSO lastmodifieddate) which files need to be updated (enhancements, etc.), then shoot the ASP pages that have changed down to the client?
body is containing a lot of text with vbcrlf in it.This is basically a form that is emailed and I want to save it to a db just in case the emails don't go through. For some reason the field in the db (access) is only containg the first line until the first vbcrlf
I am updating some pages "font "style color size" and a few words in several of my asp pages. Most of them will update but I have a few that refuse to even after rebooting the server and clearing the cache on my current computer.
