This is probably a simple question, but how does one format a table such that if a field is a certain value, then it will have a specific color.
For example, in the code below, if the specific field named "Year" is '2004' then I want it to appear in red, otherwise it should appear in black. Code:
i have an simple invoice sheet and in "total" coloumn i need to put a formula like IF < 8.50 THEN VALUE =8.50.it is something like we dont do delivery less then 8.50 so if the TOTAL is less than 8.50 then it should turn in to 8.50 automatically.
View Replies View RelatedI'm writing an article which contains quite a bit of ASP code in the examples. What I would like is to show this code, in HTML, using pretty color farmatting techniques.
Things like comments in green, keywords in blue, operators in red, the kind of color formatting that text editors have. Does anybody know of any tools which can take ASP code as plain text and produce color formatted HTML output?
I know php has some nice color-code formatting, where it will show the file in nice colors
(highlight_source..)
An example of what I am talking about is located here:
http://dev.zaireweb.com/source.php?source.php
Is there a way to do this in ASP
Given a value in a database (Access) of type Currency how do I write a conditional statement such as the following:
if rs("price") > "$1,000,000" Then
Response.Write " Luxury Home"
End If
When I try this it writes out Luxury Home for every record, regardless of the value in Price.
how to have table alternate color everytime im using for and next statement..? example:
Code:
<%
for a = 1 to 10
'write td here with alternate color..
next
%>
im looking for code examples or assistance in creating a table that will alternate the row colors whilst highlighting a row in a diff colour when i move the cursor over it and when i click the row open a new url passing one of the column ref so i can drill down to the next level.
View Replies View RelatedI am creating a table with two rows(one of which is the header), and 8 column headings. In the 2nd row, i am trying to apply 3 different colours that span various length across the row. I want the row to loop adding one colour directly to the end of another, but adding this to the correct length of colspan for each colour.
The code below is what i have done so far, but i only get a blue colour in the 3rds cell.
Eventually i would like to have a variable length of row, as i do not yet know how many rows i need (this will be dependant on something else). But i would like the colour method to be applied to each row.
Also i need to be able to make colspan variable so after each loop, it will be updated by the new column amount ....
I retrieved data from a couple different oracle databases and presented it in table format. The problem I run into is displayed below. Equipment and number are in one table, and number, name, and date are in another. I'm trying to figure out what asp code I need to display it as described below, if that is possible. This is how the information is displayed.
Number ..........Name ........Date .........Equipment
5555 ..............same ........1/1/2005 ......valve
5555 ..............same ........1/1/2005 .......pump
5555 ..............same.........1/1/2005 .......breaker
I want it displayed like this on the same row.
Number ..........Name ........Date .......Equipment
5555 ..............same ........1/1/2005 ....valve
.................................................. ....pump
.................................................. ....breaker
I am pulling legislation information and expiry dates from an access database and posting to the web. The expiry dates in access are formatted as Month Day, Year (EG.. January 1, 2006) But when they are pulled from the database to the web, they come out as 01/01/06. I know that the format we have in access is simply a mask, however we require that format be carried through.
This is likely a simple solution, however I am new to ASP and can't seem to locate any information on this. I have searched the forum for related info on this but can't find anything that relates to my specific situation.
Here's the code we are using so far...
Code:
<%
Do While NOT Recordset.Eof 'i.e. carry on looping through while there are records
Response.write "<tr><td>"'open row and first cell
Response.write Recordset("Legislation")
Response.write "</td>"'close first cell
Response.write "<td>"'open second cell
Response.write Recordset("Repealed")
Response.write " "
Response.write Recordset("Expiry_Date")
Response.write "</td></tr>" 'close row
Recordset.MoveNext 'move on to the next record
Loop
%>
I have also found and implemented the following code:
Code:
dt=recordset("Expiry_date")
dt=Month(dt)&"/"&day(dt)&"/"&year(dt)
response.write(dt)
This lets me change the positions of the numbers, but I can't figure out how to make it display the full month name and full year.
I have problem to print out a table data only the data witch have the field paid yes..
I used
pi.Open "select * from invoicees where paid like '"&yes&"', "DSN=anitel"
What's wrong
I have a product table in Access, like this:
product_id | product_name | product_quantity
I need to be able to do an SQL update on this table to subtract 1 from the product_quantity field.I could do this with two SQL queries (SELECT product_quantity, then subtract 1, then UPDATE table) but I'm sure there must be a way just to run one query which subtracts 1 from the field. how to do this?
I am developing small asp application.There is a database called db.mdb and there are three tables(tblUser,tbsImport,tblcitylist) In tblcitylist there are two fiedls
1.Town
2.LReg
According to the relevent town there is a LReg (Lreg is a name already assign to the town)
this part is ok.
In my tblUser there is a field called Town and LReg (Same as above table)
But here LReg is empty.I mean there is a default value called "N/A"
I need to create a asp page for following purpose
* i need to read tblcitylist table and according to that I need to fill the LReg fields of TblUser Code:
I have more than one date field on my ASP forms (and in the sister MS Access table) I can not write (created the record in Access table) to the table UNLESS there is date data in ALL the date fields on the ASP form.
I need to be able to have the user enter only one date, then do back at a later time and enter the other date.I am using the short date format in Access table (MM/DD/YYYY) When there is only one date field (on ASP form and in Access table) the date is written and the record is created.
What i am trying to do is Update data in a table with data in another table but i want to update 2 fields in the destination table with data from 1 field in another table.
These are the table i have and their fields:
*CUPFirstRound* - Table1
GameId
GameDate
Home
Away
HomeScore
AwayScore
Winner
There are 8 rows in this table, thereofre the GameID's go from 1 to 8 Code:
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)
I can retrieve the recordset from the database and display the field data
results in rows of a table but have the entire 60 character string in one
cell. I need to break that string apart and put each semi-colon delimited
value in it's own cell. Then move to the next record and do the same thing
in the next row of the table. - and so on
I'm using ASP, VB Script with DMSII Database and OLEDB
Does anyone have some code examples on how to break this field apart and
then arrange the data into an html table on a webpage?
I need a way of putting say 10 to 20 bullet points in one table field in an
Access database
- say seperate them with a special character, then build a bulletted list on
my page.
If I can get the page to detect each special character, insert a new bullet
and move on to the next occurance in the string... Code:
I have a form with a list/menu where you select the year you were born. Now, when I submit this form, it creates a new register in my database etc.
How can I use a conditional to redirect a person that for example was born in 1987 or less?
if request.form("year")="1987" then%> is this the correct way to start?
I have a ton of dynamic pages that I need an asp conditional to run on.I know the urls of all the pages and I want to know if there is an easy way to write a conditional statement that if they are on a specific page that it outputs something depending on the url they are on. Is there an easy way to do this?
View Replies View RelatedI have the following simple conditional on my page,
If EmpIDError <> 1 Then
'Show Input items
End If
Now I need to add another conditional to this,
If PosIDError <> 1 Then
'Show input items
End If
So I made it like this,
If EmpIDError <> 1 OR PosIDError <> 1 Then
But the problem is that if PosIDError = 1, then it still shows the input
items. But if I take the EmpIDError <> 1 out then it works with no
problems. Why would this be like this?
I've got the following VB in an ASP page and can't see why it won't work
<% if Request.QueryString(Failed=="N")%> The Failed variable is N <% else
%>The failed variable is not N<% end if %>
I'm calling the page as thepage.asp?Failed=N
I have written a small library for ASP, and I tried to keep it in a modular fashion, splitting my library in some files.
Then I have a file named "framework.asp" that include all the other files.
The problem is that I can't reuse code internally to my library because if for example:
framwork.asp include:
- utils.asp
-html.asp
Then html.asp include:
-utils.asp
If the programmer include framework.asp would have 2 times the same file utils.asp in his ASP page! Code:
I have a code for executing a stored procedure and returning a recordset wrapped in an IF statement. If the statement is true the code executes. If the statement is false the code is skipped.
On the page, I want to display a message if the Recordset returned from the stored procedure is empty.
<% If rs.BOF or rs.EOF Then %>
Message
<% End If %>
Running the above code will return an error message if the recordset object doesn't exist...i.e. if the stored procedure hasn't executed and returned the recordset object.
How can I write the code to include that condition?
Will this work in asp 3.0:
If True Then
<!-- #include file="test1.asp" -->
Else
<!-- #include file="test2.asp" -->
End If
One of my asp pages can be loaded in two ways - it may be submitted to itself (and therefore contains user data) or it can be loaded by clicking on a link on my menu, and consequently all fields are empty.
If the fields contain values (ie. the submit button was pressed), i want to load data from my database into an array, but if it is accessed via a link, i don't want this data to be loaded. So essentially, i want to know if there is some form of conditional compilation or something in asp (i know it technically shouldn't be called that, but i'm coming from a c++ background, so...) similar to the #if and #elif type directives in C
I can't place the code in a subprogram and selectively call it, because I want the arrays to be global so all my client-side scripts can access the data I'm using VBScript for the asp scripting.
I have a shopping cart that I want to load items in that come from a huge scrolling form. In other words, when someone clicks on a category in our site, it scrolls out all the items in that category, maybe 30 or more. I have text boxes next to each item so somone can enter a number, then press submit form button at the bottom of the form, and
send those slections to the shopping cart.
The problem is, many of the text boxes are empty, yet they are still being sent to the shopping cart as a quatity of 0. Is there a way for sql to ignore a value if the variable is zero, or only get the sql statement to run if a variable is > 0?
I am not too sure wats wrong w the if-else statement below!
<%if(grp==grp2)%>
{
<%if (start==req || end==req)%>
{
<%=grp%>
<%=start%>
<%=end%>
}
<%else%>
{
<%="There is no such record found"%>
}
}
<%else%>
{
<%="There is no such record found!"%>
}
<%endif%>
Error: 'else' without 'if'.
else
^
displays content IF several conditions exist or display's nothing if it doesn't?
Basically, in english this is what I'm trying to do:
IF a record exists
WHERE session(userID) = idByUserID in 'notes'
AND
WHERE userID = idAboutUserID in 'notes'
THEN
display from the record fieldnames 'LastUpdate' and 'note'
ELSE
don't display anything
I have a 'primary' intranet website and a 'secondary' backup of this site as
well. I would like to programmatically have the effect that if the
primary site is (page not found 404) not available, for it to access the
secondary site or at least be able to add a message with (or instead of) the
404 error dialog that the primary site is down and give the user a link to
the alternative (secondary) site.
Ok I know this is simple but I cannot get it to work.
on the URL I have:
.../default.asp?strCode=xxx
I then have:
If Request.QueryString("strCode") = "xxx" Then
Response.Write "code is XXX"
End If
So for some reason it is not evaluating the queryString and does not enter into the conditional. Why?
I'm trying to not show some data dependant on date but it never works right.
<% If Request.QueryString("EventDate") > DateAdd("d",6,Date()) Then %>
I have used similar routines before and it worked fine but this time i'm using a QueryString instead of a database field.
URLURLI need help writiing an advanced conditional statement.I want to display an image if two recordset values = 1 or other various number combinations.
This statement works with one, how could I edit this statement to include two recordsets values? Say I want to add another feild say "recent" to this statement and it has a value of 2
Code:
<% if Recordset1.Fields.Item("progress").Value = 1 then ' Adv Conditional Region %>
<% end if ' Recordset1.Fields.Item("progress").Value = 1 %>
I'm just trying to figure out what the colon : does in this code:
<%If (Not isNull(COLOR)) Then If (COLOR = "Blue") Then Response.Write("SELECTED") : Response.Write("")
I thought it may be the ASP version of the Ternary operator, but it doesn't have the same effect. Is it just another way to concatenate? or a reverse concatenate?
or maybe a addition of an empty string to make sure that the output from the response.write statement is a string and not a number?
If the second response statement has a value then it prints it e.g. Code: