Data Grid Or Data Matrix...
This seems a very complicated task, so I welcome any
input. My boss wants a data grid or matrix of the top 6
orders with ordered items, and products, for a particular
customer and he wants to see it like this:
products down the left side
orders across the top
number of items under the respective order number column
across from the corresponding product.
I hope that makes sense.
I have three tables. Products, Orders, Orderitems. I
don't even know where to start. Many thanks in advance
for any input offered.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Data Grid
need to enter many entries at a time related to my production. Like operatorID,operationNO,qty,nohours bla bla I already designed page. But its used to enter one record at a time. I want to allow user to enter all operators details for a specific date at a time. I tried using ADO Connection and ADO recordset. When set the properties, its displaying error. Its not connecting to database. How can i use this? or is there any tool having this feature for free? I am using access database. I want to use this in my LAN only.
View Replies !
View Related
Need Data Grid
I need to display data from a sql server 2000 db on an asp web page and I need a vertical split. Does anyone have any solutions? I really can't afford to spend much/any money so freeware/shareware or coding suggestions is what I am interested in.
View Replies !
View Related
Build Data Grid From XML
I have spent the past several weeks building an ASP.NET 2.0 Application that has a Users.xml file where all user information is stored. I am now designing the administrator tools and want to be able to sort through the records in the XML file. Essentially, I want to be able to build this: http://beta.asp.net/QuickStartv20/aspnet/samples/data/GridViewSorting_vb.aspx It seems that every example i hit is a sqlserver example and there doesn't seem to be very good sorting capabilities for XML. is this true? how do i acheive the above link? I would really appreciate any code examples or code links if you know/have them.
View Replies !
View Related
Pass Bill To Data To Ship To Data
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
View Replies !
View Related
Data Update To Data Base
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be. Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /admin/update.asp, line 111 line 11 is strName.execute I read it might be forbiden characters in the data base field names or spaces... but i don't have that. the names are userName, userLevel, ID, Password.
View Replies !
View Related
The Matrix
I have a database which stores moviereviews. I have a list on my site containing all movietitles,linking to the corresponding review. A movie like 'The Matrix' can ben found under the letter 'T' (the), but it should be placed under 'M' (matrix). Let's say I get a title from the database like this: <%=objrs("Title")%> or: response.write objrs("Title") How would I place 'The' behind 'Matrix'? (Matrix, The)
View Replies !
View Related
Matrix Class
I'm looking for a class or a library of functions for classic ASP 3.0 (no .NET) to manage matrix (bi-dimensional arrays) with simple math functions such as sum on the row/column, shift of row, shift of columns and so on... Does anybody know if there's something available on the net?
View Replies !
View Related
Dot Matrix Printing
I set up a small program for people at work to enter in information in one screen and then when they click 'Submit' it takes them to a screen that merely displays the info in the format required by the dot matrix printer. They then have to hit the IE print button to print the page. What I would like to do is when they click the 'submit' button, it automatically takes the data from the fields and sends them to the printer (no longer displaying the info in another screen). Is there a way to do this using asp? The printer is an OKIData ML 320.
View Replies !
View Related
Multilevel Call Matrix
I am trying to construct an application that will take you through a scenerio and based on the outcome of the scenario, will give you a variety of answers. Is there anybody who has done something similar who can point me in the right direction. Using ASP with SQL backend.
View Replies !
View Related
Passing Form Data Using ENCTYPE="multipart/form-data"
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag. On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
View Replies !
View Related
Force Grid
I got my excel doc to export but it has a white background, can i export it with with out the background and show the grid like a normal file
View Replies !
View Related
Grid Schedule
i have this event sign-up program that displays events from access databases and allows a user to click on a sign-up button to sign up for these events. currently when viewing an individual summary, the users see a listing of events they've signed up for, but it's been suggested to create a grid schedule for a better visual. these events cover a 9 day period (Friday through Saturday) and i was wondering if there's a relatively easy way to create a grid schedule for the users?
View Replies !
View Related
Grid & Menu
I have an ASP page which hosts a VS flexgrid control. I use a Menu.js file which will dispay the menu on each page of the application. But in some of the pages the sub menu goes inside the flexgrid. I tried putting the z-index property for the div which holds the Flexgrid but it didn't work. Is there any workaround for this.
View Replies !
View Related
Visibility Of Pagerstyle In Grid
I'd like to know whether its possible to hide the pagerstyle of a grid.In a webpage i hav a grid with paging that is supposed to be printed,so in a button click i'm calling a javascript to extract the grid <divto open it in a new window..in the same button click the pagerstyle should be set to false..Is there any way to do that?..
View Replies !
View Related
Displaying Records In A Grid
I have created a website using dreamweaver mx 2004 and access 2000 for the database. i want to display the results of a recordset in a grid with a different record in each grid. the grid will be fixed in width and the cells will be fixed in width and height but if more cells are required (eg more records to display) then they will be added to the bottom of the grid. at the minute its not working. This is a screenshot of what im sort of after.
View Replies !
View Related
Grid Reference Co-ords To Longitude
I have a database of UK postcodes with corresponding OS Grid references (easting and northing) but I need to convert these to longitude and latitude so that I can plot my postcodes on a Google Map.Does anyone know of a function which can do this?
View Replies !
View Related
Application To Find Closest Grid Reference
I'm building a 'spot the ball' gaming site where people choose a point on an image closest to where the ball should be. This works in Flash by assigning co-ordinates to that point. However, I need to do a database look-up when the competition is over, to see who has the closest point. I'm hoping to build an ASP application that will enable the administrator to enter the correct co-ordinates, then click a button to find the closest entry in the database. I can't think of an accurate automated way to do this. Has anyone built anything similar? What would be the best way to achieve this?
View Replies !
View Related
Filling Out The Missing Squares In My Picture Grid
Using ADO/ASP, I want to retrieve a list of pics from my db (which will be dynamic number of pics as a user will be uploading anything from 1 to 12 pics) and put them in a grid (table) of say 3 x 4 cells. I think this is easy to do if the user has uploaded 12 pics, as the recordset's recursive loop will create the table for me, but my problem is that what if they only upload 4, 5 or 7. How do I list these pics in my grid, but get the ASP to neatly finish off the 3 x 4 grid? If I just leave it to my recordset of say 7 recs then my 3 x 4 table is going to disjointed and unfinished.
View Replies !
View Related
Using Csv Data
how to call a csv file into a data array. I was told I can use : csvArr = split(csvLine, ",") So long as I have no embedded commas in any field. what Im not clear on is the syntax. how do I call the csv into the script (so the script knows to use the csv)
View Replies !
View Related
Add Data
I only want to input the following information if it is not a zero length string. Any ideas on how to do it? Crate&Barrel = Request.Form("Crate&Barrel") Crate&Barreladdress = Request.Form("Crate&Barreladdress")
View Replies !
View Related
XML Data
How can I display data from an XML file in ASP?I want to use an XML file instead of an Access or SQL database and would like to display this information the same as I would if I were using Access or SQL as the datasource.
View Replies !
View Related
Add New Data
how to add new data. i need to add new data after display the record from database. i click new button and the textbox will be empty. Wat is the code for add new data?
View Replies !
View Related
Getting Different Data
i'm trying to figure out how to use the same page to get different output using .asp?id=. I have a db table with 5 records & want to on my page to be able to with a listbox/menu be able to switch between these 5 records using the same page.
View Replies !
View Related
Get Data From Xml
I had write an asp file to get data from an xml named "data.xml" and below is the coding: Dim xml Set xml = Server.CreateObject("Microsoft.XMLDOM") xml.async = False xml.load (Server.MapPath("data.xml")) Dim fText1, fText2 fText1 = xml.documentElement.childNodes(0).text fText2 = xml.documentElement.childNodes(1).text Set xml = Nothing It's all Ok and can run. But my problem here is I want to call an xml file that I don't know its name (not "data.xml"). The xml file pass by the user who call my asp file. The user can pass the xml via anything for example asp or VB component. So I will not know exactly what the name of the xml file.
View Replies !
View Related
Add Data, DSN Is Specified
the actual question is as follows: i have setup a DSN called "pro" now i have tables in this database i m running oracle if i were using MS Access i know how to insert new fields by using the RS.Mode = adModeReadWrite how do i do it for oracle? not just inserting data into tables but also what r the commands that i have to give in the asp code page so that i can even update( edit ) and delete records.
View Replies !
View Related
Getting Certain Data Frm DB
I have a DB called users.mdb and it has the tables: Myusers- (fields) ID Name Password DOB Date joined Messages- (fields) ID Mailto Mailfrom Subject Content Postdate I am trying to develop inbox.asp, how do i get it to display the mail for each articular user, and no one elses mail?
View Replies !
View Related
Raw Data
some way to access to the content of the HTTP POST? Perhaps throw the request object or something similar to the $HTTP_RAW_POST_DATA gobal variable available in PHP.
View Replies !
View Related
Data To PDF
I am having a lot of problems with this, I am trying to create a pdf file from data submitted by the user via a form. Once the details are in the PDF the file needs moving into the secure area of the site. Anyone have a clue how to do this?
View Replies !
View Related
Get Xml Data
i am trying to use AJAX to get XML data from 3rd party site and display on my site. it works in IE, but does not work in Mozilla. i want to find a method where i can do that.
View Replies !
View Related
Data Listed OUt
anyone know any homepage that might help me to list the data out in a page. i wanna do it like in 2pages that one is going to be the one who maintain data. another one is to list all the data out from server...
View Replies !
View Related
Retrieve Data
I have two tables having similiar columns ( i had to do this to compare the values given to me, because both the table data came from different sources) The tables named are OFFICERS token full_name division EMPLOYEE token full_name division Now the table EMPLOYEE contains more than 5000 records and the table OFFICERS contains around 2400 records which are already present in the EMPLOYEE table. Now I want to build a query that will return me all the records in the EMPLOYEE table that are not present in the OFFICERS table. The criteria for comparing 'full_name'. so the query should return me 2600 records that are not present in the OFFICERS TABLE. I tried doing this " SELECT DISTINCT EMPLOYEE.full_name,EMPLOYEE.token,FROM EMPLOYEE,OFFICERS WHERE EMPLOYEE.full_name<> OFFICERS.full_name" But this query returns me records that is not present in the OFFICERS table as well as some more 1000 records which are present in both tables. thanks a lot
View Replies !
View Related
Post Data
in past, i learnt from the book to post data by action=post & input type=text now the post data is not from user input it is from a table which is generated by asp script i wish to generate a table with a check box at each row. when i select the check boxs, then the rows of the table will be posted to another html page any hints to me for doing this? Secondly, how about if rows of the table will be posted to a input box on another html page grateful if you could give me some hints.
View Replies !
View Related
Display New Data
there is a JavaScript/ASP function that that will check for new Private Message (PM) Inbox. New PM will be referred as "NEW" in the status field in the database and "READ" for all the old PM.hen there is a new PM, a popup will appear in my page. But I have to press the REFRESH BUTTON before I get the popup ALERT! Can this be done in AJAX? (Alert me without refreshing the page?)
View Replies !
View Related
Insert Data In My Db
I've been choosing to insert data ni my db using a recordset with methods AddNew and Update. I would like some advices to make my coding opractice better. For example: am I doing it right? Is there a better to do what I'm doing and so on...: Code: set rsExample = Server.CreateObject("ADODB.RecordSet") rsExample.Open "example", MyConn, adOpenStatic, adLockOptimistic, adCmdTable rsExample.AddNew rsExample("id")=id rsExample("firstName") = firstName rsExample("lastName") = firstName rsExample("subject") = subject rsExample("message") = message rsExample("new") = 1 rsExample("date") = now
View Replies !
View Related
Retrieve XML Data
I am trying to access the following site with an asp page. I am just starting out with XML URL This is my stats page for battlefield Vietnam. I have managed to get a local verison to work if I save the source code of the page above as an xml file on my server, and I use the following code: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Option Explicit %> <% Dim xmlDoc, root Dim success, player, strData, online ,rank, rp, score, kills, deaths, fttk, kdr Dim dpm, ftpm, mppr, medals, gold, silver, bronze, rounds Set xmlDoc = server.CreateObject("msxml2.DOMDocument") ' What I can't figure out is how to access the data from the external site.
View Replies !
View Related
Pass Data
In ASP, when we pass data between pages, we usually pass by query string. If we pass data by query string, that means we need to use submit button, not by regular button, and the form will pass to the server since it's GET or POST request. But if just form-to-form communication, why we need to send the form to the server? <form action="process.asp" method="get"> //form controls <input type="submit"> </form> For example, http://www.myserver.com?id=100&name=joe Form.QueryString("id") Form.QueryString("name")
View Replies !
View Related
Numbering The Data
When you pull out some certain data from the DB, this is generally how it looks like in a table... jill 123 jeff 444 alex 611 steve 244 But my question is that, how do you LIST the data beside them? its nothing to do with the table ID, its just when you pull the data out of the DB, you could use the ASP function ( I do believe there has to be one?) to number the data? This is how I mean... 1. jill 123 2. jeff 444 3. alex 611 4. steve 244
View Replies !
View Related
Download Data
We have to provide a facility on the client machines to download the data visible on a ASP page into an excel sheet. We are using WIN2k clients connected to WIN2k server with IE6.0 installed. The way we plan to implement it is that : a) provide a right click and download to excel button from the ASP page visible in IE. b) on click of download make a server call passing the appropriate command to send back the data in excel format. My questions are : Q1) Is there anyway to avoid the server call? I am not looking for OCX either? Q2) Are there any issues to do with memory leaks / deadlocks in case we use such office automation to generate a report in excel? Is there a way around?
View Replies !
View Related
|
TRACKER
