I have a report that I render out as PDF. I have two sections in my Details section of the report.
I want to format the background of each section. so one half will be one colour and the other half will be a different colour.
Anyone know how I can do this?My Details section simply consists of labels and database
fields.
I'm creating team pages. One page will be used for all teams and I will pass the teamID through the page. I'm using ASP/Access. Each page has the same info.
My question is how to best handle color for each team page? Should I store the HEX # in the database and use them in the CSS. i.e. each team would have a Main color, 2nd color, etc. I have not done this but I'm assuming I can.
In a regular drop down form element like below, is there a way to display associated colors with each option? Basically, I'd like it to look like Outlook's Label Control drop down that displays a small color block with each choice.
I need to add to my application a ComboBox in whic the user selects color. The comboBox shows the name of the color and the background of the word is in the color that says the word. The names and values of the colors must be read from MSSQL database.
I'm trying to do it with this code but this one has the colors and values given and not read from DB. Code:
Attached is my code. Its working fine and produces great results but all the rows are in the same color background (unless mouse-overed).
What would be interesting to see if I can get alternative colors working here... Can anyone dig in the code (maybe re-juggle) and help me with alternate row colors?
First Row to be #FFFFCC Second Row to be #CCCC99 when not mouseovered
I am putting the results from a database in a table using ASP. How can I get alternate colors in each row. (i.e. first row white, second grey, third white, forth grey, etc.)
There is a setting in IE for "Print background colors and images."
I've noticed that without checking this option, a web page will print CSS lines between table rows, but a background color of say the header won't. The below style will display the borders in print preview, but won't display the background color.
Does anyone know if it's possible to force background CSS or HTML colors to print without having the user change the default in IE to not print background colors? Code:
I 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.
I know how to alternate table row bgcolor by odd/even method but what I am trying to acheive is alternate colors by the date value in the database so that each row with the same date value has the same bgcolor. There maybe 3 red rows for 1st date, then 2 blue rows for 2nd date, then 6 red rows for next date etc.
I’m having an issue saving/reading an xml file.The source of this file is a the parameter of an object. Through the UI the user can change the value (xml string) of this parameter.
The problem is that the parameter needs the xml with > , < , and " instead of the > , < , " chars. However when I save it, the xml dom and even the fso save it with the actual xml chars. Other than a literal search, is there an easy way to convert the file to have the special chars?
Im looking for an online site that I can format or tidy ASP pages. If any one also knows of a software application that can format asp /html pages id be greatfull of that link too.
I'm having users enter a message into a textarea, but I'm having problems with the formatting. How do I add " " characters where they have pressed enter?
This is being entered into a MySQL database, so I have already replaced the ' with '.
I am requesting a variable for the users' network username:
<%=Request.ServerVariables("LOGON_USER")%>
This returns the following:
NETWORKJ.Bloggs
Instead I would like it to return J.Bloggs on it's own with out the "NETWORK" bit so basically I am saying how do I cut out the first 8 characters of a variable.
I have users typing in information into a text box. Sometimes this information can be lengthy and contain simple formatting such as spacess between lines and line numbering. For example:
1. List item number one
2. List item number two
I then have a report page that prints out this information. Unfortunately, the line spacing doesn't show up in the report. It's just all jumbled together. I'm just using <%= Notes %> to show the db field. Is there a way that I can show the formatting that was originally entered or do I need to use some kind of word processor like I am using to type this post?
I would like to know how to format phone numbers and ssn numbers in textbox. That is when I enter the phone number, it is going to the database as 000,000,0000. I want to have it as either 0000000000 or 000-000-0000. Likewise, for ssn also. I am really fed up with javascript, somehow, it doesn't work well for me. Always, get page errors and it is not that easy to find out the errors in javascript.....
I'm developing in ASP/VBScript using DreamweaberMX, w/ an Access 2000 DB as the data source. The source of the data is coming from a third party, which I get as a CSV and import into the database, updating it weekly.
Since I have no control over how the data is collected, I'm not sure how to fix this problem, but here it is.
This is a database of movies and among the many fields I import is one for the movie's length, expressed in HH:MM:SS. This comes into the Access DB as a Date/Time format, which means all the dates, displayed raw in the DB, look like "12:09:52 AM". Through data formatting, however, displaying it to the client as HH:MM:SS is no problem. (Display "12:36:00 AM" as military time (00:36:00) tells me the movie is 0 hrs, 36 minutes, 0 seconds long. Follow?)
But in an update form, which we'll use to correct errors (and there always seem to be errors in the running times of movies), I can't figure out how to display it in the HH:MM:SS format in an INPUT field and have it submit without throwing a data type mismatch error. It seems to want to display as "12:36:00 AM"
Converting the field to a text type is out of the question at this point, so I know I need to do some type of string manipulation prior to update. However, I'm lost ...
When e-mailing invoices and estimates, is there any way to customize the presentation of the e-mail beyond changing the message? Specifically, I'd like to add some html so the receiver can click on a link to pay online. As it is, I can type the URL in the message, but it appears only as text to the reader, not a hotlink, which, unfortunately, is quite vexing to some of my clients.
It would also be nice to add a company logo, etc. to the email body.
On this same subject, is it possible to send the entire invoice/estimate as HTML rather than an attached PDF? I haven't seen these options anywhere.
I'm currently doing some work with ASP and XML DOM.
Is there any way when saving XML to get ASP to save it in a formatted way? Similar to PHP's formatOutput setting? At the moment my xml is being appended on line e.g
<test>1</test><test>2</test> Is there a setting to get ASP to save XML like:
<test>1</test> <test>2</test>
The XML document I'm working on is fairly large and its proving very difficult to read through the xml at the moment.
I am needing to response.write a variable within a snippet of Javascript. My Javascript code that I need to response.write with the variable is below:-Code:
response.write ("imageArray[ImageNum++] = new imageItem(image_dir + ""variable here"");")
I can response.write the static Javascript string fine. The problem arises when I try and state a variable into where it says, 'variable here' The variable I need to include is Code: rs.Fields("ImgURL") Would someone please be able to show me the correct formatting for this Javascript string which includes the variable.
Is it possible to have line feeds/breaks automatically entered when the text wraps to a new line? I am using a <textarea> input on a form and using the <pre> tag when displaying the text to a html page (embedded in a .asp page). The text is being saved to a sql database. Returns seem to be displayed. But the wrapped text just displays as one long line.
I have a SQL 2000 table with data I display in three columns. The code I am using sorts the data horizontally but I need it sorted vertically. Here's the code I am using. Perhaps somebody can help me find a way to modify it.CODE
response.write "<table width='100%' cellpadding=1 cellspacing=0>" if not oMain.eof then count = 0 do while not oMain.eof if count mod 3 = 0 then 'there are 3 in the current row, so end the row and start a new one...
I am trying to display dates in a spreadsheet, but the dates need to be in a format that will allow them to be sorted in Excel. The datatype in the SQL Server database is datetime. In this case, I need to display the date only, not the time. But I don't want to change the datatype in the database because the time is used in other places.
So what I am doing is pulling it out of the database, then modifying it in ASP/VBScript by using the datevalue function. This results in values such as 3/31/2006, 4/3/2006, and 4/14/2006. The problem is, the ones with the single digit date (4/3/2006 in the sample data I just listed) messes up Excel's sorting capabilities. How can I force the dates to display in a 2-digit date format? It would probably be good to do the same for the month.
OK, I know about FormatPercent and it changes a decimal into a percentage, but is there an analagous function to change a percentage into a decimal value?
I have an ASP site pulling from a SQL Server. When I pull a text field from the database into a text area, it keeps the formatting. If I pull the data from the database on a response.write, all of the formatting is lost. how can I prevent this from occuring?
I am using the response.ContentType = "application/vnd.ms-excel"----Works GREAT! I send all my SQL querie info from my asp page to an excel spreadsheet. Now what I need to know is there some fuctions I can use to set all the format parameters of the spreadsheet i.e. font style and size, columns to autofit!!