Updating Records With A Join
Through the form action I want to be able to update the existing record. Is it possible to run an update through a join? The statement selects a ticket and the associated contact. The user should be able to change the contents of any field and then hit the submit button the update save the ticket. Code:
View Replies
ADVERTISEMENT
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
View Replies
View Related
what is there i need to look up and add to my code so that if more than one user is logged on to my site and edits information such as stock levels other users aren't under the impression there is stock when it has just been givin out to someone else? the easy was is just to have one user to access it at any one time but i think there will be about 5 -10 users at anyone time viewing the info and if 2 ppl update records at the same time how is it done?
View Replies
View Related
i want to know how to update records by login
i mean to say when a user will login by his name and password his records of his name n password from the database will dispay on page and he will be able to update
after login m redirecting the page to update.asp .
how can i move the values how parameters i.e loginname and password.
View Replies
View Related
I have created a page that calls multiple records from an access database. I would like for the user to go through and update the data, press update and it updates to the database and returns to the same page.
this has been accomplished all bar one thing, it doesn’t update the database! What have I missed? Code:
View Replies
View Related
Those anyone knows how can I update several rows in a table using form fields with ASP?.
I'm using oracle9i.
View Replies
View Related
I have a master/detail table configuration in a SQL database.Each record in the master table can have many records, which are stored in the details table.I need to create an update page that will allow the user to view, update or add new records within the details table that is associated to a master table record.
So, say I have 7 fields in the detail table and I'm pulling 20 records from the table that is associated to a specific master record. I would have 20 rows each with 7 columns that need to be updated or added to.
The columns contain dropdown menus,which will hold the value from each field in the detail table But,I also need to pull data from other tables that will hold the other values for the dropdown menus.
View Replies
View Related
I'm trying to update records in the database and the script I'm using is giving me an error:
Type mismatch
/Action_Item/action_items/view_action.asp, line 79
Whis is referring to this line:
response.Write("<tr bgcolor=""" & strBgColor & """><td width=""150"">" & lclArray(0,rowCounter) & "</td>" _
& "<td>" & lclArray(1,rowCounter) & "</td>" _
& "<td>" & lclArray(2,rowCounter) & "</td>" _
& "<td>" & lclArray(3,rowCounter) & "</td>" _
& "<td>" & lclArray(4,rowCounter) & "</td>" _
& "<td>" & lclArray(5,rowCounter) & "</td>" _
& "<td>" & lclArray(6,rowCounter) & "</td>" _
& "<td>" & "<a href='edit_action.asp?action_id=" & RS("action_id") & "'>"&"<img src='edit.gif' border="" alt="">"& "</a></td>" ) ....
View Replies
View Related
I need a code that will update multiple records on a list thru checkbox.
If the record is selected, the details that was updated on the selected
record will copy the same value as what is updated.
View Replies
View Related
I am having trouble getting records to insert and update properly. This is not a consistent problem. It is intermittent. The page will allow me to correctly update 2 or 3 times generally, however after that it will double up the data in the insert and update.
Here is the code I am using. Code:
View Replies
View Related
I am having trouble with the edit, update and deleting of records. I got the codes from a user in a different forum. Now I can't find ant help from that forum. Here is a link to a zip file with the pages and database in it.
bkdphoto.com/problem.zip
Simply open the listings.asp page then click on one of the Edit or Delete labels. I am getting the following message when I do:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/Tests/New Folder2/delete.asp, line 7
View Replies
View Related
I got an asp page that supposed to add,delete records from access 2000 mdb file. It loads all the records but when i try to delete or update i get these errrors. Code:
View Replies
View Related
I have a database generated form that I would like users to be able to update by selecting a checkbox. Say the page displayed has six records on it and the user wants to delete one or more of the records. They would click the checkbox and hit a "delete" button.
Then the database would be updated and the user redirected back to the page that would now show all the records that weren't deleted. Sort of like Yahoo mail, you get a list of all the bulk mail, select the ones that you want to delete, hit a delete button, and the page is updated to show what e-mail is left. How do I do this using ASP?
View Replies
View Related
I am trying to create a record set using data from two tables. I am using the following code-
Dim objRS
oracleConnection.CommandText = "SELECT CONTACT.CONT_FNAME, LOGIN.LOGN_USER_EMAIL " &_
"FROM CONTACT INNER JOIN LOGIN ON CONTACT.LOGN_ID= LOGIN.LOGN_ID WHERE CONTACT.CONT_ID LIKE 3"
oracleConnection.CommandType = adCmdText
Set objRS = oracleConnection.Execute
Set oracleConnection = Nothing
While Not objRS.EOF
Response.Write objRS("CONT_FNAME") & " " & objRS("LOGN_USER_EMAIL")
objRS.MoveNext
Wend
I am getting an error at the line
Set objRS = oracleConnection.Execute
The error is
SQL command not properly ended
View Replies
View Related
I have three tables in the DB MySQL:
TABLE_V = id, codebar, description
TABLE_C = id, codeplu, description
TABLE_M = id, internalcode, description
In the tables TABLE_V and TABLE_M for each record the descriptions are the same, Is different in the table TABLE_C.
Relations in the tables:
TABLE_V.CODEBAR ===> TABLE_C.CODEPLU
TABLE_V.DESCRIPTION ===> TABLE_M.DESCRIPTION
TABLE_C.CODEPLU ===> TABLE_M.INTERNALCODE
I must query INNER JOIN into three tables to extract CODES and corresponding DESCRIPTIONS, its possible ?
View Replies
View Related
I can't seem to get the syntax right for an inner join statement, its based on one main table and two linked tables,
From Employee inner join((Department ON Employee.Department_Code=Department.Department_Cod e) Location ON Employee.Location_Code=Location.Location_Code)
or something to that effect. Employee is the main table and Dept,Location contain all dept/location codes+descriptions.I'm sure its pretty simple just can't get it right.
View Replies
View Related
I have 2 tables I want use join to use their data its working but it will return twice of each record.
this:
strSQL = "SELECT Foods.*,SeFoods.* From Foods INNER JOIN SeFoods ON Foods.food_id = SeFoods.food_id WHERE SeFoods.type = 1 ORDER BY seFoods.sf_id DESC;" .....
View Replies
View Related
I need to insert simple SQL Queries (joins) in an ASP page.
Select Count (*) from
Fileindexqueue Q,
Domains D,
Files F
Where D.ID = Q.DOMAINID
and Q.FILEID = F.ID
and D.NAME = 'GAINS_GTN'
My ASP code where queries can be inserted looks somewhat like this:
strSQL = "SELECT COUNT(*) AS COUNTOF FROM FILEINDEXQUEUE where (SERVERFLAG = 'Failed')"
objRec.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly, adCmdText
Response.Write "<P Class=""clsMono"">Files Failed   : <b>" & objRec("COUNTOF") & "</b>"
objRec.Close ...
View Replies
View Related
in this code, Code:
strSql = "SELECT tblClippings.fldClippingID, tblTopics.fldTopicName, tblMessages.fldMessageID, tblMessages.fldMessageTitle, tblMessages.fldMessageCreated, tblPeople.fldPersonDisplayName, tblMessages.fldTopicID FROM tblTopics.fldTopicID INNER JOIN (tblPeople INNER JOIN (tblClippings INNER JOIN tblMessages tblClippings.fldB_MessageID = tblMessages.fldMessageID) ON tblPeople.fldMemberID = tblMessages.fldPersonID) ON tblTopics.fldTopicID = tblMessages.fldTopicID WHERE (tblClippings.fldB_MemberID=" & iPersonID & ")"
after the FROM statement, I am getting confused. It gives error message. I think the problem is just about here,
FROM tblTopics.fldTopicID INNER JOIN (tblPeople INNER JOIN (tblClippings INNER JOIN tblMessages tblClippings.fldB_MessageID =
View Replies
View Related
I am in the process of creating an ASP application to read a SQL Database. I
have imported the database from an Access Database. The Database holds
Client details, such as Agent Name, Address, Telephone. etc. in a table
called Client Code:
View Replies
View Related
I have been racking my brain with this and I just can't seem to figure it out. Here is what I am trying to do. I have 3 tables named Registration, Events, and Customer.
I want to produce a page that lists all events and the number of attendees and who is attending each event. I assume that the only way to do this is by using an inner join and I am having a hard time grasping it.
My registration page has three fields
(customernumber,eventid,eventdate)
My events page has five fields
(eventid,eventdate,place,description,numberofattendees)
and my customer table has three fields that I need to use
(firstname,middlename,lastname,customernumber)
View Replies
View Related
<!--#Include Virtual="/bug/adovbs.inc"-->
<title>Bug Status Board</title>
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog =
techsupportBT; User Id = sa; Password="
Set rs = server.CreateObject("ADODB.Recordset")
sSQL="SELECT T.BugIndex, T.[Date Entered], T.DESCRIPTION,"
sSQL= ssql &" T.Company, T.Technician, T.Developer, T.PROGRAM, "
sSQL= ssql &" T.Status, T.PRIORITY, T.[Version Fix], n.noc"
sSQL= ssql &"FROM TSHIGHISSUES INNER JOIN noc ON T.BugIndex =
n.bugindex "
set rs=conn.Execute(ssql)
and this is the error message that I get Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'INNER'
I cannot find an example anywhere that helps with this situation. This works fine in SQL, but for some reason asp is being a pain.
View Replies
View Related
I'm trying to select all the records from a table (usergames) based on the username. I want to then display all the records based on the title of the pin which is my inner join statement. Can I do this or is it easier to just have another sql statement?
sql = "SELECT usergames.pin AS gamecount, searchtable.title FROM usergames INNER JOIN searchtable ON usergames.pin = searchtable.pin WHERE usergames.username = '"&username&"' ORDER BY searchtable.title DESC"
View Replies
View Related
Basically I'm trying to combine an SQL inner join with a delete statement, like:Code:
var cnn = Server.CreateObject('ADODB.Connection');
cnn.Open(Application('cnn'));
cnn.Execute('delete * from editors_sections inner join editors on editors_sections.editor_id = editors.editor_id where editor_id='+intEditorId+' and editor.isSectionOne=0 or editor.isSectionTwo=0 or editor.isSectionThree=0');
cnn.Close();
But it gives me the following error:
Incorrect syntax near '*'.
Can this be done, and if so, can anyone see where I'm going wrong (I'm using JScript if that makes any difference?)
View Replies
View Related
i was just wondering if it is possible to join more than one table with sql.
I am currently joining the tables care, and images with inner join;Code:
cnnSimple.Execute("SELECT * FROM [care] INNER JOIN [images] ON care.english = images.english WHERE care.english = 'whatever' ")
I have a third table, 'video' that i would also like to join(at video.english) and display on the page.
View Replies
View Related
How can i insert a data using a join statement
insert into partmaster.p, execmaster.e(e.execno, e.model, e.battqty, p.partno, p.parttype, p.itemtype, p.stacklength, p.line, p.execno)
values('1234567890', 'GBM', '2', '9876543210', 'AR', 'M', '29V', '2', '1234567890')
i have a few input box for the user to enter. but as u can see that both tables has execno. it's for both tables to connect. that's why i want to check on how i can key in one input box insert into execno in two different tables
View Replies
View Related
I've got three tables:
tblEvent
--------
Id (PK) | Event_Name
tblDelegate
--------
Id (PK) | Delegate_Name
tblBooking
--------
Id (PK) | Event_Id (FK) | Delegate_Id (FK)
I need to retrieve a recordset with the following information:
Booking Id | Event_Name | Delegate_Name
Can anyone see how to do a SELECT statement to do this?
View Replies
View Related
I have a table in my DB called members. In that table, I have 2 tables I
will be using "username" and "points"
Now, I also have a table called all_matches. This table contains every match
report. Over 25,000 of them. I have a "username" field an "outcome" field an
"username1" field and "extra_match" field.
What I need to do, is make a query that takes the username from table
"members" and find :
using the "username" field in the members table, i need to obtain stats
that give me the following. Code:
View Replies
View Related
Tables spec:
drop1 - autonumber
drop2 - autonumber
drop1id in drop2 - number
strsql = "SELECT drop2.drop2id, drop2.drop2, drop2.drop1id"
strsql = strsql & " FROM drop2 INNER JOIN drop1 ON drop1.drop1ID = drop2.drop1id where drop2.drop1id = " & drop1id
error msg:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'drop2.drop1id='.
View Replies
View Related
strSQL = "SELECT x.CountryId, x.CountryName, y.SiteId, y.SiteName, z.LocationId, z.Level FROM TableCountry AS x"
strSQL = strSQL & " INNER JOIN TableSite AS y ON (x.CountryId = y.CountryId)"
strSQL = strSQL & " INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)"
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression '(x.CountryId = y.CountryId) INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)'.
/system1.asp, line 21
View Replies
View Related
What am I doing wrong in this statement?
SELECT * FROM hebbooktable INNER JOIN hebrewbibletable ON hebbooktable.book = hebrewbibletable.book WHERE text_data LIKE '%bra%' ORDER BY id ASC
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
View Replies
View Related
I have a MSAccess 2000 mdb where 2 tables must be connected with a fieldname "book_spoke".
This is what I have so far. Is it right? The purpose is to find within the search result all the book_spoke s and link with the proper url for each book_spoke. Code:
View Replies
View Related