I've decided after several failed attempts this is too difficult to do
on my own. I know it's been done before and a tutorial or code must
by lying around somewhere.
I have a Weekly Calendar
It's in a table with 7 columns and 22 rows
Across the top I have Monday thru Sunday
Down the side I have half-hour time increments - 8:00am - 10:00pm
I would like to display my events on the table, corresponding to their
day and time. If it spans several hours I would like the event to
span several rows.
Basically look like an Outlook Calendar.
I've tried this myself with five dozen if/then statments and embedded
loops but it's a huge mess.
I'd like to find out how to simply do this in asp (not ready for .net yet), any
ideas?
I know I have seen some free ASP calendars before, and even did a search of this NG, but couldn't find any references to any. I went to 4guysfromrolla and asp101, but they only .NET calendars as far as I could see.
I'm specifically looking for something that's free and has a page for editing or adding events.
I have created a table that I want to fill with calculated values. I have given ID's to each cell. This must NOT be the way since I can't address these ID's. How do I store values in table cells from my PostBack?
I have an interesting problem and am looking for some advice. I am hoping to build an asp whereby records are pulled from SQL Server. These records will be merely file locations for thumbnail images I hope to display in a grid.
Rather than having a grid be constructed row-to-row, I was wondering if it is at all possible to dynamically construct this grid as a table of thumbnails whereby each cell (perhaps 5-6 columns across) represents one record? I have no idea how one would construct this loop that spans columns AND rows rather than just rows.
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
I am not sure where to post my question on Crystal Reports, hope I am in the right place...
I am printing a report with many columns such that they won't fit into 1 page landscape.. I was just wondering if there is a way in crystal report to print the other columns (not fit into 1st page) into the next page?
I would like to dulicate a selected record. Sounds easy enough like performing another INSERT operation. However, that solution only works if the datasource is only one table.
I have 4 different tables all linked to the main table through a unique primary key (auto number). When a user clicks a button to clone a record, all related records from the other tables must also be duplicated using the newly assigned ID that matches the one from the main table.
Hopefully I didn't confuse you. Consider it like a multi-step process of filling out different web-based forms but using the same unique id.
I don't know the first place to start on creating duplicate entries based on existing records. If you can start me with the code, I could probably follow the logic. THe difficult part for me to conceptualize is how to carry this new ID to all the other tables.
I need to sum the values in different cells of an excel sheet which im getting from data base and which is in a loop and the number of entries depends on the user.
I've seen lots of posts on this and other boards, but nothing seems to work for me. I need to import data from an Excel spreadsheet using ASP. None of the ranges in the spreadsheet are named. I'm using this code:Code:
<% Set ExcelConn = Server.CreateObject("ADODB.Connection") Set ExcelRS = Server.CreateObject("ADODB.Recordset") ExcelConn.Provider = "Microsoft.Jet.OLEDB.4.0" ExcelConn.Properties("Extended Properties").Value = "Excel 8.0" ExcelConn.Open "c:inetpubwwwrootaspcalendar est.xls"
set ExcelRS = ExcelConn.Execute ("SELECT * FROM [Sheet1$]")
Response.Write(ExcelRS($A$1))
%> I've tried every variation on "ExcelRS($A$1)" that I can think of - I've seen "ExcelRS(1,1)" used, but that doesn't work... What is the syntax for accessing Excel data by cell coordinates?
I get data out of a database and the user can save this data on his disk in Excel format. Some cells has a large lenght of numbers (eg. 20060512000000). If I open the excel file, the cell where that number is in shows the following : 2.00605E+13.
I have to go into Format Cell and convert this to 'Number' and no decimal places. Is there a way in ASP to define the cells ?
if i have an standard excel file and i have data in there in specific cells. Is it possible to have some upload facility that will be able to paste it to specific asp form textboxes?
e.g if the data in the excel file was in cell c4, i would want to paste it into textbox4. Is that possible.
OR
Is it possible to upload an excel file and to put specifc data from different cells directly into an access database.
e.g excel file -c4 i would want to paste it to rs("test4")
I have an ASP page that loops through a SQL Server 2000 table, then downloads an Excel sheet the users can save, etc. Works fine, except, I see that in one particular "comments" field the Excel sheet returns a #VALUE! error in the cell when there is a large amount of text. I've looked through the MSKB, MSDN and many ng posts to see if there is a workaround or solution to this, inclduing looking at the xlWorksheet properties (I've tried 'xlWorksheet.Cells(iRow, 11).WrapText = True), played with Orientation, etc. But to no avail.
I need to come up with an if statement that will basically take a large list of records and place each one into its own table cell, and when the cells reach a max of 5 in a row, start a new row and repeat. How can I go about this?
I am developing an application which uses data represented using color codes, in an MS-Excel worksheet. The application has to assign values based on the backgroundcolor of a cell. Like, Black = 0, Red=1, Green=2.
How to determine the background of the cell in ASP?
One of my programmers is using Office Web Components in classic ASP to create, fill and format an Excel spreadsheet. Everything is fine except when he creates Merged cells the performance drops dramatically. He has investigated the 'Center Across Cells' alternative but cannot get it working using Office Web Comonents.
Has anyone come across this problem or even better has a solution?
Is there a command within ASP similar to the Do Events command in VB6. The problem I have is that an asp page that I have written outputs many lines after extracting data from WMI. In total there are about 1000 lines generated which are displayed within the browser and saved to a database. The browser displays the correct results and they are saved into the database. But the browser only displays the results after it has completed the entire script. Is it possible to get it to output lines before continuing with the rest of the script so I can display a section at a time.
I have ASP which uses a stored Query in a Access 2000 database mdb to update a table. I am only adding records. No changing information in the records of the database. Just adding records. I also have a form that looks like this form: http://support.microsoft.com/?scid=kb;en-us;198466 So I have my Query and I have my form. All the necessary information for the form comes from the ASP page. What I need to do is provide the information from ASP to the form so that it's code can populate the table. Any suggestions how this might be accomplished with the above example? Events? Or a discussion somewhere on the Net to bind a form to data submitted from an ASP?
I have a list box that has a list of names, and i want when the user selects the name to bring some information from the database and put it below the drop down box. I think i need to use an onchase event but how do i get the page to refresh to show the new data, suggestions or examples woudl be great.
I am downloading a stream which contains XML in my ASP page. I want to have MSXML XMLDocument load this in async mode, and call events as it would in VB. I am new to ASP, is there a way of hooking into the events using ASP? Code:
beeing from swedeni´ve the text in swedish. But I hope u understand. I´ve a calendar http://www45.brinkster.com/ovaasp/cal.asp
Now I want to list events, so each event gets to the correct date (i.e in the correct table-cel)
I´ve managed to list in the wat I want http://www45.brinkster.com/ovaasp/list.asp
But when I trying to put the events in the calendar, I can´t get the repeating events correct . U can see for yourselfs http://www45.brinkster.com/ovaasp/error_jun.asp if you check next month + button "forward" Eken Cup, i Solna should be writen to 3 - 7th jun
The project i am working on just now requires me to provide users with a link to download articles stored on the sites FTP server.This is not a problem to do, however, i also need to keep a record of who downloads what and when. I therefore have a downloads tablein my DB for storingthis info. The problem is, when the user clicks on the download link i need the document to be downloaded, AND a query to be executed to record the info into the DB table. I effectivley need the link to action these 2 eventssimultaneously!! Not sure if this is possible.
I recently had to build an FTP server for all of our clients to send us files. I am now asked to do something I have never done, I need to be able to alert via email any other useable method everytime new files are ftp'd into client folders on the ftp server. Can this be done?
Trying to implement a list of online users in my application. I have SQL Server database, table Users with a column called Status, that is set to 1 if the user is online or to 0 if the user is offline.
I wrote a VBScript sub for database update, but the problem is when I try to execute it on page onLoad event or onUnload event, the onUnload event overwrites the onLoad one right away. I suspect it has something to do with server-side vs. client-side scripting.