I am displaying the table using ASPGRID.In Edit mode,the column2 displays an array of values.On selection of a value from Column2 the column3 value should be automatically populated based on the Column2 value.
The cell change event of column2 should be captured and display the column3 values based on the column2 value. Is there any way to track the cell change?
I have virtual directory where I run test.asp page with only this code inside:
<%Response.Write now()%>
As a result, if I go into the IE and browse for the test.asp page, I get :
1/22/2004 14:18:04
If I copy this page on some other(existing) virtual directory, I get as a
result 22.1.2004 14:19:06
If I create a new virtual directory and I copy the page there, I get :
1/22/2004 14:18:04
Seems like that IIS takes english date format even if my regional setting is
:
d.M.yyyy and I would like that date on the page is always like this:
22.1.2004 14:19:06
Where I can change this setting?
I have to upload one excel file. In that excel file I need to check the availability of data in particular cells and also the worksheet name. If the data is not available at particular cell, say for eg: $F1, an error should be thrown to user saying that the data is manadatory. How to do that? How to read the particular cell in ASP? If anybody knows the code, please send the same.
View Replies View RelatedI have been toying with various resources I have found on here and the web - but would like to know specifically how to get the contents of an excel cell on a particular sheet using .asp?.
View Replies View RelatedI am not sure if this is possible but is there a way to change the color of a datagrid cell when a condition is met? For example, let's say if percent_changed >10 then change cell color to orange if percent_changed >25 then change cell color to red.
View Replies View RelatedIs it possible to set a cell property in Excel from an ASP page. We have numerical data that is taken from a database and then displayed in Excel. I would like ideally all the data to be set at 2 decimal places, is there anyway of setting this from the ASP page?
View Replies View RelatedI have a table with coloured cells. I want to print out the table via IE with the coloured cells. But the outcome of the table does not have the cells coloured.
Are there ways to force out the colouring of the cells in the print outs?Either via php/asp/css or any means.
My asp page pulls from the database into a table for example
Name ITEM1 ITEM2 ITEM3
AName AITEM ANOTHER SOMETHING
What i want to do is create a mouseover based on what that content is, rather like when you hold your mouse over a image and view what the alt tage says i want it to display a short description of what the item means: I.E
Name ITEM1 ITEM2 ITEM3
AName AITEM ANOTHER SOMETHING <---- users mouseover "Something = Something that has a description"
This has to be dynamic based on the value in the table cell
Anyone have any ideas?
I came across a problem when importing my data results into Excel. The whole table outputs perfectly but a particular field which is generally large (13 characters long) presents as some random integer which shouldn't be the case. I click on Tools -> Format Cells and change its value to number and to 0 decimal places and great it works.
Am I able to do this before I get into Excel? Or would this always have to be done by the user?
Is anyone aware of a 255 character limit when reading data from a particular Excel cell? I'm experiencing when pulling straight text from an Excel spreadsheet, which otherwise works fine. Right at 255 characters, the data is truncated and I only see that bit of information.I've searched Google and came up with a few registry modifications, neither of which fixed the issue. Has anyone else ran into this?
View Replies View RelatedI have a basic page for which I have included some of the code for at the
end of this message. It may not run correctly as I have cropped out a lot
of code.
I am trying to handle the click event for a cell. From the code you should
be able to see that I am handling the mouse over event and would like to
link to another page via the cell click.
I addition, but not too important at the moment, I would like to pass a
string or two across to the called page. For example link to the next page
and within that page identify which cell was clicked and possible pass a
string for the image used in the clicked cell. Code:
What ASP code can I use, for an ASP-generated spreadsheet, to force a cell to wrap if the content is longer than the width I have specified for that cell?
View Replies View RelatedI have a situation where I need to send a text message to a cell phone. Any ideas?
View Replies View RelatedIm trying to read an Excel file using OLE DB. I have around 500 characters in one cell. But the program is reading only 255 characters. How do i make my program to read all characters?
View Replies View RelatedIs there a way of having a cells bg color change depending on its content? And what would be the best way of doing it?
I am wanting to use a traffic light style system for coloring number content cells. 0-33 Red, 34-66 Amber, 67> Green
I have an asp page where im creating dynamic rows on an onclick function and textboxes are created in the dynamic rows and when i submit the asp page it goes to another asp page, where i whant the values entered in the textboxes of dynamically created row of the previous asp page. Code:
View Replies View RelatedI an using ASP to read a database table and generate an HTML table
which is save via FSO with a file extension of .xls which opens up
in MS-Excel. I am inserting several lines of text into a cell and would
like to force a line break between them.
I recorded an MS-Excel macro so see how Alt-Enter was captured
which turned out to be Chr(10) which is the same as vbLf (right?)
I tried inserting that in character in the text but it didn't show up as
a line break in MS-Excel.
I created a web page from Excel2000, using "Save as web page..."...Publish
function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side?
For example, the value of Cell(1,2), Cell(2,3)....
I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
if it is possible to change the location of the dlls of an application, by default, the assemblies of an application is loaded in the bin folder in the applications folder, can i change some configurations to save these dlls in another location?i'm using asp v1.1 and .net studio 2003.
View Replies View Relatediam having problem ,relating to update a column in Access file in ASP
'Change' is column name , rs is recordset object ,and i want to update the values in 'Change' column by return values from a function .Iam using vb script in asp
rs ("Change").value = function()
this is generating error, and won't work
does anybody here have codes for "change password"?i am using dreamweaver 8 and MS Access
View Replies View RelatedWith global.asa application variables can be set. Later can a script in your
application change the value of those variables. But when IIS is restarted
the old values are used again. Is there a way to get the changes that are
done into global.asa?
I need to generate a pdf file in classic asp script. It uses the arial font . But i need to change the font of the pdf file to Century Gothic. I am currently using fpdf.asp file to generate the pdf. Can anyone tell me how to change the font to Century? It would be pleasure if anyone could provide me the code for doing it.
View Replies View RelatedI want to have two pull down menus, 1 for continents and the other for
countries. On selecting the continent how can I change the menu of another
pulldown or how to display the list of corresponding countries in that. And if no continent is selected then nothing should appear in countries pulldown.
my management has now decided that wants the crystal report that I have developed to be available with 5 different options. The only thing really changing is the where clause of my sql statement that Crystal Reports uses in the expert wizard to create the report. All of the fields remain the same. Is there way to set parameters for sql statement that would changed "where" clause in displaying crystal report in crystalreportviewer to (where xfield=parameter1, x2field=parameter2, etc.)
View Replies View RelatedI have some dynamic pages like asp files and the data comes from database.
What I need is to display the page content to diffrent languages.
Suppose user selects Germany and the page content changes to german language.
With ASP is it possible to dynamically change the <title> tag depending on what record I am viewing? I know that you can do this isn ASP.net and PHP but was wandering if its possible in ASP too
View Replies View RelatedI just moved my website from a Win2000 server to a Win2003 server. On the old server, we would prompt for the user name and password via the WWW-Authenticate header, retrieve the Base64 values provided by the user from Request("HTTP_AUTHORIZATION"), decode them, and validate the user against our database.However, after moving to Win2003 server, the user is no longer prompted for the user name and password. The HTTP_AUTHORIZATION comes back immediately, and decoding it reveals a very long string of garbage.
Obviously something has changed between these two version of IIS. Anyone
know what the problem may be?
I have a html page that contain a form, I want to change windows registry, this key (LegalNoticeText) to amount of the text box in the form how I can do this?
View Replies View RelatedI have a combo which has 2 values.I want when its value is changed then its value should be display in a text box.
View Replies View RelatedI have been trying to use If Then Else Statements and CSS to make different table rows change to different text colors based on a field that is queried. For instance when displaying a row of data that has the Memo field marked as rework I would like all the text colored Red.I have 3 different instances that I need to work with. Can someone point me in the right direction to make this work?
View Replies View RelatedUsing a DetailsView to update data in SQL 2005, How do I change the default "Update" hyperlink to a more user friendly button?
View Replies View Related