I am semi-new to ASP. I'm in the process of making several reports and I wanted to condense one of our reports to fit nicely on a web page. This report consists of about 5 different queries.
I want to make a table like the one below in ASP. I thought I would just make a table and go from there but I quickly realized I can't.
I have the same layout for a few dozen pages and want to know if there is an asp code or something else that would allow it to load 1x and only the new content reload.
View Replies View RelatedI need a page or set of pages to allow a user to mange the file system under a certain folder. This certain folder will be determined by authentication and db checks. So the user will need to be able to Rename files or folders, Delete files or folders and move files or folders.
I can handle writing the code to do this but I am stuck on a user interface. Does anyone have a good example they would be willing to show me?
I have a lot pages on my web site, and I don't want to go through and make each one. So I want to have a querystring to load each pages layout from my ms access database, and I don't know where to start.
View Replies View RelatedI am currently migrating my MS Access Program to ASP. My only problem is I cannot migrate my report since the layout is different. Is there a way where I can use WYSIWYG format?
View Replies View RelatedI have coded my pages in HTML and named them as ASP. I would like to use a trailing string i.e. domain.com/page.asp@somthing=4 . which pulls from a database of plan names and corresponding prices over a user selected interval. I want to offer pricing over these intervals:
1month
3months
6months
12months
24months
with a percentage discount being offered for each greater length of time. The user should be able to use radio buttons to select how to pay and after this a paypal button should be generated with the designated amount.
Now that I have layed out what my intensions are, does anyone have any ideas of how to complete my goals using ASP? and if ASP will not do the trick does anyone know of a better/differnat way to do this.
I have the following problem. As some of you already know (because they already helped me a lot), I am showing data in a table. The first code is correct. It shows my numbers with two digits behind the comma and negative numbers in brackets and in red. Code:
View Replies View RelatedI am building my own webpage using HTML, Access DB and ASP. I have built the HTML pages but I have one query. I posted this in HTML forum already and was told to ask here. I have a form that is filled in by the web administrator that must be displayed on main page. It is a timetable for a cinema and the information can be submitted into a database table.
I only want to have a maximum of 3 rows in the table, one for each screen. Is this possible? My other query is when Im extracting the film information from the db table to the users page I want it to look lilke something resembling this:
Screen: 1 Screen: 2 Screen: 3
Film: Oceans 12 Film: The Village Film: Shrek
Mon: 8.00 Mon: 8.00 Mon: 8.00
Tue: 8.00 Tue: 8.00 Tue: 8.00
Wed: 8.00 Wed: 8.00 Wed: 8.00
Thu: 8.00 Thu: 8.00 Thu: 8.00
Fri: 8.00 Fri: 8.00 Fri: 8.00
Do I create a html table for each that is overwritten once, say, "The Terminal" is entered instead of "Oceans 12" in screen 1 by the administrator?
I have a repeating region set up in Dreamweaver for products. At the minute, when processed the records come out like this (one after the other)
x
x
x
x
x
However, I want to have three in a row (until end of table)
x x x
x x x
x x
Is there anyway to accomplish this?
The link for the photos are requested from the server and so the photo
appears on screen. I can produce a long list by using the response.write ***
& "<br>" or whatever. but is it possible to have it start on the next line
after say 5 photos in a line. i.e. where each - is a photo
- - - - -
- - - - -
- - - - -
rather then
- - - - - - - - - - - - - -
or
-
-
-
-
etc.
I was wondering is there is a way to neaten up or rather seperate the main layout and the asp codes? For example, to have a main.asp(which is solely the design and layout) and include other .asp files that retrives and records the records.
View Replies View RelatedI have a table layed out in SQL 2000 like the following:
Username Date Hours Period
john 1/1 10 1
john 1/2 20 1
How simple is it for me to build a data entry form in ASP that would display this with input boxs for the hours field. The problem is I need it to span left to right on th eweb page.
Period 1
1/1 1/2 etc------------>
box box
SUBMIT BUTTON.
The key to the look would be the current period.
if there's a better way to seperate my asp code from the main layout? like to have an index.asp(solely the layout and design) and just include other .asp files to display the records.
View Replies View Related<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=hardware.xls" %>
I'm using the above lines to generate a spreadsheet from a recordset. One of the recordset fields has HTML data.
Whenever the spreadsheet is generated,it will place some of the HTML data into new rows. Same appropriate column,but different rows. Is there a way around this?Is there an easy to create a DBF or CSV file that would work?
i am having a problemn thinking on a solution to make a web application.
This is the scenario: I have to make an application that should catch some
user data on the screen and pass it to a database. Here is the problemn: the
data that the user will pass is huge. I am talking about some columns and 27
rows.
3 rows as caption rows and the other 24 to get the data. How can i do
that? I thought about making columns with textboxes (with ids like R1C1,
R2C2, R1C4...) in a dynamic table inside a form and submit it.
But the boss
wants an excel spreadsheet look into it. I am relutant about using OWC
because first, i don't know if the users will have the office installed and
secondly because if they do have office installed, how can i know what
version of office is everybody using? Code:
I have created an asp page that resemebles that of a spreadsheet. It contains mostly javascript functions. The page functions ok except when there are a significant amount of row entered. Then there is a delay tabbing from cell to cell -- but only cells that have function(s) associated with it. Is there something that I can do to speed this up?
View Replies View RelatedI'm creating a spreadsheet online via ASP. I have the following at the page
top...
<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
It works fine for some 60+ manufacturer listings. However, it balks on one
single manufacturer. By chance, this manuf has 18,000+ records. The others,
less than 10,000. Is there a limit to the number of records I can convert to
XLS...?
I have my excel spreadsheet generating just fine. What I'm trying to do is format each cell to something other than "general" I've figure out how to format to currency:
<td>$<%=variable%></td>
I really need to format to "text" though. Anyone have a good link to a chart that explains how to format to all of the different possibilites, or just how to format to text?
I'm successfully using Response.ContentType = "application/vnd.ms-excel" to generate an Excel spreadsheet from an asp page and a SQL Server database.One of the columns contains data that is a long number (13 characters eg. 1122334444566).The spreadsheet does not display the number correctly because the column is formatted as 'General' so it displays 1.12233E+12.To correct this in Excel I simply change the column type to number. How do I get around this in asp.
I know I could use fso to create the spreadsheet on the server using a template, but I prefer to do it on the client side so that I don't accumulate a whole lot of xls files on the server.
I didnt build the worksheet yet because I was stuck at the line Set oSS = CreateObject("OWC10.Spreadsheet")
I get this error
Error Type:
(0x8002801D)
Library not registered.
/gcrm/DailyRCReport/genExcelOWC10.asp, line 18 .
I am writing an ASP page that uses the Spreadsheet Office 200o Web Component. I need a cell to open up a popup window when clicked. I can only get a new page to display using hyperlink. I want this to be a popup page like the one you can create using window.open().
Can this be done? Can I do this using some window/Spreadsheet events, can a SpreadSheet cell contain a call to a javascript method? I would like one of the columns to contain not only a hyperlink but also be displayed as an image of type *.gif. Is this doable?
I got a problem while running an application. The code for this is as follows:
aList = Split(strMsg,";")
For nX = 0 to UBound(aList)
strarry=split(aList(nX),"_")
var_year=left(strarry(2),4)
var_month=mid(strarry(2),5,2)
var_day=mid(strarry(2),7,2)
var_date=var_day&"-"&var_month&"-"&var_year
var_time1=mid(strarry(2),9,2)
var_time2=mid(strarry(2),11,2)
var_time=var_time1&":"&var_time2
set rs1=conn.execute("insert into tbl_BackupfileInfo(Filename,Createddate,Createdtim e)values('" &aList(nX)&"','"&var_date&"','"&var_time&"')")
Next
while runnig this application some times it works fine .But some times it giving an error
Error Type:Microsoft VBScript runtime (0x800A000D) Type mismatch: 'UBound'.
What is the syntax to connect to an excel spreadsheet as well displaying contents of a column.
View Replies View RelatedI have created a Spreadsheet object that I need to stream directly to a file through the browser. I can not save this file, that I would then stream, to the web server, even though this would save me a lot of aggravation.
Since Microsoft seems to see no value in providing any documentation for their OWC 11 components, I am just one of many developers groping around trying to find how to use this.
I have a report that the user can view either on a page with HTML or they can open it in Excel.
I am attempting to change the content type with this statement:
response.contentType = "application/vnd.ms-excel"
But it appears that when I do this I lose all my request variables and my recordset is null.
I am creating a website in which users will be able to query an sql database by several different criteria (i.e.- name, department,supplier, part#, date). What will return to the user will be a webpage with the column headings that they selected in their search criteria (i.e.- name, supplier, part#) and below those column headings, a list of the results.
I want the user to be able to print this report or export it to an excel file, this is the part that is tripping me up.Any ideas about this? Am I going about it all wrong?
How to using asp script update data in Excel Spreadsheet with style (ie, Bold, Font Size ..) ? Is it possible to do that ?
View Replies View RelatedI'm using the Excel application object to create a
spreadsheet from a recordset. Everything seems to work
fine except any date fields are not displaying properly.
For example 4/18/2004 is displaying as 38095 in the
spreadsheet.
I loop through the recordset to display each row. The
line that actually writes out the field is:
objSpreadsheet.Cells(iRow, iCol).Value = objField.Value
Any suggestions?
I am just wondering if this is possible to do?
View Replies View RelatedI am trying to import an excel spread sheet, my first step is to be able to see the spreadsheet on the webpage, Code:
View Replies View RelatedWhat would be involved with having an Excel spreadsheet displayed in an ASP page? The additional problem is that the file name changes on a monthly basis. For example, this month's file name is 'Feb 2005.xls'.
View Replies View RelatedI would like to know if and how it would be possible to create an
entry-screen that allows the user to enter data in a database, using a
spreadsheet/table-like entry screen. The screen would start of having
headers for each column/field and an empty row underneath. When each column
in the row is filled in, the user must have an option to add another row.
I'm look for the code/explanation that helps me set up the entry screen, and
the ASP code to add the entered data in the database.
I can imagine that each entered row is added to the table when a new row is
added, or a button is pressed and then the screen refreshes with the newly
entered information and a new row...
I have asp project where large volume of data entry would be done. I am
trying to find out if there is any tool that can allow me to build asp
application where the forms would be like excel spreadsheet.