i need to go through a list of items and check to see if items on list 1 are on list 2 and vise-versa. so im going to look at item 1 on list 1, and go through all the items on list 2. if i find a match, ill update the record on list 1, if i dont find a match ill update the record on list 2.
im going to need a nested loop. in c++ i know how i could do this, but im not sure as how to do it in vbs/asp. can you do for each "record" in "myrecordset"? or do i have to get the number of records in the table and run the loop that many times? which would be eaister?
how to selct from a database all records that have the same Company Name and have that information automatically change depending on who is logged in, based on there Company Name.If Acme company has 5 members signed up I want any of those users that login be able to view all other users from that company.Is there a way of writing the script to do this?
I've had a look around for a few hours for a solution to this problem but can't really find one so maybe someone can help or point me in the right direction.I have a database with fields like Name Date Project Hours worked etc and i want to make an online form where the user can type in their name and the date and it will show the record that contains there name and that date.
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".
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<% Dim conn Dim rs Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Set cmd = Server.CreateObject("ADODB.Recordset") conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa" conn.Open
how to query data which spesific the number of record from 'start' to the 'end'?let say i have 20 records,then i only wanto to query record from row number 10th to 16th like that.
I want to know the number of records in my database when performing a query by sql. I am getting -1 as number of records.
<% connectme="DSN=hotel" sqltemp="SELECT Count([All Rooms].Engaged) AS CountOfFREEROOM FROM [All Rooms] GROUP BY [All Rooms].Engaged HAVING ((([All Rooms].Engaged)=False));" set rstemp=Server.CreateObject("adodb.Recordset") rstemp.open sqltemp, connectme, adopenstatic howmanyrecs=rstemp.recordcount response.write howmanyrecs & " records in<br>" & sqltemp rstemp.close set rstemp=nothing %>
my project is on an online hotel reservation. I want to have the number of rooms available each time the page loads.
I have built and app where people can add records to a database the problem is while the next page is loading some people are impatient and click refresh adding another same record with slightly different time stamp.
Is there anyway to limit the number of records insterted to my SQL database from my asp pages to one.
I'm trying to set up a "simple" page to display six items at a time in a 2 col x 3 row grid I've succeeded in doing this and displaying all the records but am struggling to only display six at a time I've searched on recordset paging and no one seems to cover this sort of problem Anyone any ideas? Code:
I'm trying to specify how many records to be display per page. I put a limit of 40 records and i'm getting only 2 per page. The number of pages it seems ok but the records displayed are only 2 instead of 40. Code:
I have an articles_tbl . How do i create a select statement which only brings back the latest 3 records added to this table (the database has a field called 'date_added') so the information of when they were added is present.
I was just wondering how to bring back only THREE records and showing them, instead of bringing back the entire table content and then showing three out of them..
I have an Access table with (among others) a number type field.
I'm building a web form which will add a new record to the same table. My problem is as follows:
I need to retrieve the (number) value from the previous record and increase it by 1 when submitting the new record. Also, this number should reset to 1 whenever a new year occurs.
I'm trying to display records from a table in a sql database.The problem is, every month a new table is created, so I don't know what the name of that table is going to be. It there a way that I can make sure the sql only reads from the latest created table?
I've created a form where the user should be able to select an option, then a second list will be populated based on that selection. The next part is where I am running into trouble.
The user can also select a time window which can limit their search, if they so choose. Code:
I know I've asked this before, and other people have too. But when I use that igrep search thing, almost all of the search results are scambled (when you clikc on a search result, its just a scambled up thread).So I'll ask again, because I have forgotten. I know that to count the entries in a recordset, you usethe following code...Code:
RS.RecordCount
But I know that you need something else, something about a client-side pointer? Without it Im just receiving -1 each time.
Say i have 100 rows in a table and i make a query:"Select * from table", i will get all the 100 rows displayed, but what i want to do is to display 20rows in a page and then have 'Next' and 'Previous' links to navigate through the records 20 by 20. This is in fact exactly as in this forum where only 20 posts are displayed sorted by most recent ones and so on.
SQL="SELECT title,body FROM cinema WHERE date_end > #" &date()& "#"
cinema is a table which contains announcements about cinema title,body (txt fields)are columns of my a table called cinema date_end(DATE/Time Field): is a date (DD/MM/YYYY, short format).This date shows when the announcements expire .But SQL returns all the announcements that the table contains even those that have already expired. Why??I cant find any mistake.
Trying to duplicate the functionality found on this page:
I have a new table i've created that stores peoples search queries:
INDEX, SEARCH, COOKIEID, CID, SUCCESS, DATE
I have a seperate table that stores my product data, including the keywords. My search function uses a LIKE %%examplekeyword to match searchs to the DESCRIP column in this inventory table.
How can I make one SQL query to display the same results as on the the example page? It's easy enough to SELECT the results, but how do I do a count of how many instances of that search word exist, inside the same SQL statement?
There is something wrong with the adding code. It will add sometimes. It's a large database where I have to add records to multiple tables.
The products table doesn't work correctly. Maybe there's a typo somewhere that I don't notice. Please look at the bolded part of my code and see if you can catch something. Code:
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?
I am new to ASP and I want to use a query which links one record in a table to another record in the same table to display a list of values. The query lists the names of all managers (the managers staff no is held in the reports_to field of an employee)
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT DISTINCT p2.Surname + ', ' + p2.[First name] AS Expr1 FROM People p1 INNER JOIN People p2 ON p1.reports_to = p2.[Staff no] WHERE (p1.[Staff no] IS NOT NULL)",con,3,3 while not rs.EOF %> <option value="<%=rs("p2.surname")%></option> <% rs.MoveNext wend rs.Close
However it doesn't like the alias (p2). Is it possible to return a list from this type of query?
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'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)
Joe Bloggs ---> 100 Closed
Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:
When I summit this form, It called another asp2.On this asp2, I would like to retrived all the fields values from ASP1, using id.Is there any way I can retreive fields values using id.
I am retreiving the records and placing them in the original form with stuff going in its own text boxes and all. i have a few checkboxes and when i retreive the records,i want to even see the checks in the checkboxes.
so that the user can see all the info abt that record and if they want to uncheck any. they can do so. So how do i retreive those checks in the checkboxes?
