I have an ASP file that retrieves records from an Access database and displays them in the browser. The problem is that the records come out unsorted. I need to sort them by entry date. I have a field in the table called "EntryDate" that is in the format MM/DD/YYYY. Can I sort by this field? If so, what would the SQL statement be?
View RepliesI wanted to if this is possible in asp. I want to display records in a table then when the user sees it he has the option to sort it. like in table the headers there will be an arrow for each column and then clicking on it the records are sorted. Can someone tell me how this can be done.
View Replies View RelatedI'm working on getting a list of links to other forms on my database to show up in an order determined by an additional field in a database. This line right here works for this (note the bold part is what I'm editing):
Set rs = cnnSimple.Execute("SELECT * FROM [resource domain] where RESID= """ & rstSimple.Fields("RESID").value & """ ORDER BY [Links].Precedence ASC;")
But I actually don't want to sort by Precedence (that's being used for sorting another field). Instead I want to sort by another colum in the same form called BelongOrder. I try this simply by doing:
Set rs = cnnSimple.Execute("SELECT * FROM [resource domain] where RESID= """ & rstSimple.Fields("RESID").value & """ ORDER BY [Links].BelongOrder ASC;")
But I get the following error:
Microsoft JET Database Engineerror '80040e10' ....
Is the CASE statement allowed when querying an Access database? Assuming so, what is the correct syntax? Code:
View Replies View RelatedIs there a way to GROUP records from an MS Access database?I'm using Dreamweaver Ultradev 4.0-programming in VB Script.Macromedia says that stored procedures aren't available when using MS Access (Only MS SQL) and Grouping isn't available using MS Access.Id like to query the database and group the records like so
Category A
-- Item 1
-- Item 2
-- Item 3
Category B
-- Item 5
-- Item 6
-- Item 7
i believe there's a way to hand code the query to work with MS Access.
Anyone know if it is possible to update/insert a database record into a dynamically specified field.
The code I have here holds data in an asp session, ownerId, storeid and product type.
I can insert a record into the Productcat table, fields OwnerId and surfboards, no problem.
But what I would like is to insert the ownerid then insert poduct type into the field sepcified in the session variable (session("prodtype")) and/or strprodtpye
For Example
Insert OwnerId + product type into productcat into fileds ownerId and field labled ''strprodtype'' (variable, surfboard, wetsuit, boots, etc)
SQLstatement = "INSERT INTO Productcat (Ownerid,'"&strprodtype&"') "
I have tried using different methods, but the closest I got was IIS error msg ='field not found ("Surfboards", "wetsuits", "boots", etc)' Code:
I am trying to provide a paged listing of Access DB table data using ADO. I have a problem using the AbsolutePage method. I am using the following:
[VBS]
objRs.Open strSQL, objDbConn, adOpenStatic, adLockReadOnly, adCmdText
objRs.PageSize = 5
objRs.CacheSize = 5
objRs.MoveFirst
objRs.AbsolutePage = 24
Response.Write(objRs.AbsolutePage)
Do While objRs.AbsolutePage = 24 And Not objPubRs.EOF
Response.Write(objRs("data"))
objRs.MoveNext
Loop
[/VBS]
The line "Response.Write(objRs.AbsolutePage)" writes "-1" and the loop does not write any data.
If I remove the "objRs.AbsolutePage = 24 And" from the loop test it will write recordset data starting with the proper page position but continues to the end of the recordset (including all following pages).
With objRs.AbsolutePage reporting -1 I cannot test out of the loop based on the recordset page number.
I have a single table.
ID Code Description Colour Qty
1 0001 T-Shirt Black 5
2 0002 Soccer Ball Red 1
3 0001 T-Shirt Black 2
4 0001 T-Shirt Navy 6
What I need to do using ASP is take record 1 and merge it with record 3. By this I mean I need to show only a singular qty for the product code 0001.
i.e.
ID Code Description Colour Qty
1 0001 T-Shirt Black 7
2 0002 Soccer Ball Red 1
4 0001 T-Shirt Navy 6
Is it poss to move records from one table to another using ms access db to arcive records and how would i do that.
View Replies View Relatedi've googeled to find a asp-script that can compare all the records in two
different access databases the mdb's have exactly the same tables what i want is that (the output) all the differences comes in a html-table in a webpage can anybody help me, are give me a example ?
I have an access db from which I would like to display records in a formatted manner. I can display all the records one after the other on one page no problem, but I would like to display maybe 6 records on one page (3 across, 2 down). I would then need a page break for printing purposes.
Displaying all the records on one page would be fine if I can put a page break in so that they print correctly. I currently have it fomatted correctly, but my loop is not working correctly. Instead of different records displaying, I have 6 of the same record displaying, then the next record displaying 6 times, etc.
Even if it's better to do this over multiple pages, that would be fine as long as I can print the report with all records by clicking Print only once. Maybe even display the records on multiple pages with next and previous buttons, but when the user clicks print, then it would print a report from access.
I hope this all makes sense. Does anyone have any ideas or suggestions or pointers on the best way to do this both for viewing and printing purposes? Code:
I made an asp that I insert records in an MS Access Database. I do insert them allright. But I want to check before inserting if this customer already exists. I try to do that by checking lastname and name (p_eponimo and p_onoma) but seems not to work ....
View Replies View Relatedhow to do a dnsless connection to an access database and then insert records. The database name is members and table name is member_info.
View Replies View RelatedI am adding simple records to a fairly simple access database with the following code
rsEntry.Fields("Player1") = ShortName(Player1)
rsEntry.Fields("Player2") = ShortName(Player2)
'Write the updated recordset to the database
rsEntry.Update
rsEntry.Close
adoCon.Close
Set rsEntry = Nothing
Set adoCon = Nothing
How can I SIMPLY :-) prevent duplicate records from being added? I know I can set the index property on the fields but that mean handling the errors - not sure how to do this.
OR I could write the code to seach the DB before update - which may be the only way :-(
Is there a simple way?
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:
I am trying set up a page where the user can view records chosen by the year.
I want to use a dropdown menu/list. Having trouble figuring out the sql behind this.
My db table has about 10 fields in it, one of which is the year this record was created. i want the enduser to be able to enter the page, and first step is to select a year to view. Again, i want this to be chosen using a drop down menu. After clicking I would like the page to show a simple table pulling up all the records from that year.
i know this sounds simple enough, but i cannot find this info/tutorial anywhere.. you guys are my only hope.
We have an ASP site that hits up an Access database of categories of
products and products. (e.g. Categories = Napkins, Tablecloths;
Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60
Tablecloths)
We currently have select boxes that when you select a category, it
populates the next select box with the proper list of products (i.e. I
select Napkins as a category, I get a listing of the Napkins)
We would like to put a clickable link before each of these select
boxes that would pull up a pop up with links from the records from the
proper table.
(e.g. I click the categories link and a popup with html
anchor tags of Napkins and Tablecloths appear) I click on the Napkins
anchor and it populates the Categories Select box with Categories and
Napkins being selected.
I've had an ASP project dumped on me written in VBScript. I'm actually a
C#/ASP.NET developer and am struggling trying to find a way to sort the
result of a XPath query executed using SelectNodes?
I'd rather not rely on external XSL files if possible.
I have this database that contains four columns (ID, Name, Qty1, Qty2). I can display the data on an ASP just fine but what I want is to display the data in Ascending order of the total number between Qty1 and Qty2 of each record (Qty1 + Qty2 = QtyTotal). Obviously the total number is not stored somewhere in the database. So how can I accomplish this?
View Replies View RelatedThe 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 try to find a script in ASP that combines sorting and paging. I already found various scripts that do one or the other but none does it both. I know I should combine them, but it is very difficult at my level of asp knowledge.
View Replies View RelatedI wanna ask how to do the following sorting function, for example
Name Age
Brian 22
Alice 17
Patrick 21
when click on name, it will sort by
Alice
Brain
Patrick
when click on age, it will sort by
17
21
22
Is it execute the SQL by hyperlink..? Can anyone give me an example?
I created a script which suppose to sort on 2 fields. Everything works fine with no errors except when I click on the field that suppose to sort the data it does nothing.
This is the code: Created on test table name Reports2 3 fields id, r_date, r_doc_title
Code:
Can someone please explain to me why the hyperlinked column headings will sort in Firefox and IE 7 but not in IE6. Code:
View Replies View RelatedI have a set of records which are sorted AtoZ in display. Problem comes is like:
A.1
A.10
A.2
A.20
A.3
A.4
A.5
A.6
A.7
A.8
A.9
Actually A.10 is required after A.9 and A.20 after A.19.
I have searched for this, but found that on every page it sorts records like this. Also, I can not sort items based on ID (auto increment) because certain items are added at later time and some first.
I need a array with x numbers (1 to x) mixed. Like this:
Using 4 numbers (1 to 4), i need:
array(1) = 3
array(2) = 2
array(3) = 4
array(4) = 1
This is random. I make this: Code:
I'm programming as ASP site to show the results of dynamically querying a MS Access database and outputting the results in a table. I've got that part to work. But, what I can't get to work is for the header row of the table to be links to sort the data ascending or descending by that particular field. All I can get to work is having a little +/- next to the column header and those sort it, but I can't figure out how to get the headers themselves to do both sorts when clicked.....can anyone out there help??? Thank you in advance!!! Also, if anyone knows about Access 2000, I've never tried doing this in it before, but I need to export one of the field to be links to HTML pages that describe those seminars, has anyone done that? Just figured I'd ask while I'm typing this
View Replies View RelatedIs there any way to sort the files and folders according to different things (i.e. size, date, etc.)? I'm using For...Next loops.
View Replies View RelatedI have never sorted a recordset - using rs.Sort - i have no problem sorting it in SQL.
All the tutorials i get say that i have to use a client cursor location, so this is my code:
I have the following code which connects to an access database table and prints out each record. For some reason, the ASC is not sorting the records for me. Can anyone see the problem? Code:
View Replies View RelatedI have a table that is just dumping an entire database data. I would like to have the values of the columns re-sort the data. Not the column heads for the data displayed under the column head varies.
For example, one column, Components, displays 80 components types and another column, Category, displays 40 categories types. When a visitor clicks on one of the component values, it should then display only that data. I've done this before but, it has been a very long time. I remember creating a link surrounding the recordset in my table but what was written.
I'm trying to display number of records query and the results I'm getting are only for 10 and not the total number of records queried. For example if I query field "CA" and I know California has 12 records it still only gives me 10 records. Attached is the script.
View Replies View Relatedcan you tell me how to sorted table, and how to make the paging?
View Replies View Related