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.
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.
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.
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:
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.
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.
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.
how do i get data from a user on one page and display the result on the other page actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
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:
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?
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.
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.
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?
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?
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.
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?..
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.
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?
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?
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.
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.
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?
