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.
MySql="UPDATE country SET country.country_name='" & country_name & "' WHERE country.country_id =" & country_id & ";" Hi, My question relates to the quotes in the above query. I was able to find my probem by searching the forum, but I am interested in knowing why I must use single quotes around the following: Code:
I have been trying to do this code but I cannot make it works. Could you help debugging the code.I dont know if the code is in the correct syntax or not.
I place this code at the top of all my page to check an invalid user that are trying to access the page without logging in. When they are success, I want to update a field to store the current time ("LastActive" field)
When the user login, I ask for their Username and password!and then, reffering to this username, update the LastActive field.
strQuery2 = "Update tbCard_Temp Set tbCard_Temp.Id='tbCardSwipe.Id From tbCardSwipe'" and i get this message [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tbCardSwipe.Id From tbCardSwipe'.
with the syntax below wouldn't it update all acct stats with the name potential client where before the values were set to 0? Am I writing this correctly? User_info is the table and i don't know whether or not if it goes in there. update user_info set acct_stat Potential Client where acct_stat = "0";
I'm having trouble with an SQL UPDATE string updating Microsoft Access 2000 with jet engine using ASP classic. I can't see what could be going wrong, as far as I can tell it's fine. I have tried surrounding my field names with brackets [] to no avail.
I am trying to modify and update a column in the access dB by using a form on the first page, and then the update sql statement on the second page.
For some reason the error its throwing at me is this
Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /willdata/password.asp, line 34
When I use the same update statement directly into the access dB it works, if I even hard code in values in the ASP page I still get an error - I now cannot see for looking: Code:
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
Wondered if someone could help me out. Ive got a database with 3 fields,
id - (autonumber) name - (text) status - (yes/no)
What I'm trying to do is display all the database contents on a web page so I can see all 3 fields etc, but then have a checkbox to represent the 'status' field so I can tick / untick multiple entries at the same time.(kinda batch update)!I know how to display things on web pages and how to bring back single records into a form and update them one at at time but it would be nice to change things all in one go
how to update multiple records on one submit. Say for example i have number of records on a html table, user performs changes on some of the records, and hits the submit button at the end and all these value have to be updated into the sql query.
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'm trying to update an acccess database using asp.net (vb.net) Can anyone tell me why the following code does not update the columns
Dim sqlUpdate As String = "UPDATE tblForumMaster SET Replies = @Replies, LastUser= @LastUser WHERE ID = @MasterID"
Dim objCmdUpdate As New OleDbCommand(sqlUpdate, objConn) objCmdUpdate.Parameters.Add("@Replies", intReplies) objCmdUpdate.Parameters.Add("@MasterID", Request.QueryString("MasterForumID")) objCmdUpdate.Parameters.Add("@LastUser", strUserName)
No errors are produced so the syntax passes but the update does not happen.
I have 3 tables Employees, nationalities, Companies.
I can easily use a join to retrieve all the data I need from all three tables.Now my problem is updating those tables.I want to be able to update all three tables in one swoop. That is, how do I update all three tables with one update statement? Is this even possible?
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?
I havecracking my head to solve this problem. I am doing a project on Online form. But because the there is too much field for a table, i have to split it up into 3 tables. I need to know how to update the 3 tables simultaneously, when i submit the form.
After the page (transactions.asp) loads I want to allow the user to enter the number of transactions into the provided textboxes. Then, when the user clicks submit, I need to have all the hidden fields as well as the number of transactions values inserted into the transactions table of my database?
I have attached the database should you have any questions about the db table values and fields. Please let me know if you have any questions or need more information or files.
I have form to update multiple data at one time. One of the field is Inspection_Dt. I want to update this field using calendar. But when i click on the calendar, it will refresh the page. 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 a shoppingcart which is saved in an array. When the user goes to the checkout and and presses the order button the contents of the array gets saved in a databasetable. This all works fine.
The problem that I have is that I want the articles that the user ordered get subtracted from the Quantity I have got in my database. But I don't know how to tell the database which records have to be updated. Code:
I'm trying to create a single form to update multiple records in a database (Access). Similar to an update qty's in a shopping basket, whereby, on submit/update it passes and updates each record, without using the ONCHANGE feature (otherwise this would become an extremely laborious task in this application)
I've tried passing and updating an array but to no avail (maybe I'm doing something wrong)
Also, I can't seem to grab the contents of the form text field, even though I'm dynamically assigning names to each text field.
Should I be using Javascript to handle the change in values, if so, anyone got any sample code/helpful links?