I am using a calendar, and I want the calendar to show a different color on the date if there is something with in that recordset. So if there is an event for that date display a color else do nothing. Im not sure how to do this?
View Repliesi would like to display the records in red color for the paid member.and blue color for free member.using database. i m not geeting the correct.
[code]
<% If membership='paid' Then%>
<font color="red"><%RS(Product_name)%></font>
<%else%>
<font color="Blue"><%RS(Product_name)%></font>
<%end if%>
[code]
When there are no records for the certain row in my table I recieve this error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/admin/Fixture.asp, line 0
i'm trying to determine if a record is empty and when it's not, it has to show that record
to test, I put three X's in the code:
the content of rs("opmerking") isn't shown but the three X's are there:
Does someone know why ? Here is my code:
[.asp with VBSCRIPT and MS ACCESS]
I have a Recordset that pulls data if 'Promotion' field in data base contains 'promo' and subsequently displays data from a field called 'TourTitle' on my ASP page..
However if the 'Promotion' field is empty in the database, I get an error on my page.. I have tried to use the following, but it is not working..
Code: ...
I always run into issues when a record set is returned empty because the WHERE clause in my SQL weeds everything out. What do you think is the most elegant way to test if there are any records to loop through?
View Replies View RelatedI have certain fields in my DB that are empty.
(In asp)
Code:
groupName=rsGroup("Namn")
if groupName="" then
groupName="(Missing name)"
End If
How do I test if the current field/record in the recordset is empty?
I so thought I had this down and I was getting excited, but when I ran it, it didn't work. I've tried a few different things and I can't get it to work (not smart enough I guess). Code:
View Replies View Relatedi have a news page which a user can update etc add new news articals etc etc.The page which is to display the news needs to start at the second artical, ie if a user has posted a news artical on the 20/11/2005 .
a other person comes along and posts one on the 22/11/2005 i need to ignore the 1st one and display the second (20/11/2005) do i create a query when doing my record set or is it a asp thing on the page.im using ASP VBScript and a access database. Im not 100% with asp im still learning so if u could expalin exactly how to do this .
.asp, vbscript, ms Access
I want to display a list of records on my page, like this:
California - Los Angeles - Sheraton
- Los Angeles - Meridian
- San Diego - Mercury
Colorado - Denver - ..................
ie. only display first instance of California..
Can this be done..
I need to limit how much of a record is printed to screen. I just want text up to the first full stop.
View Replies View RelatedI have the below code. I am trying to send information to a subroutine, I am getting an Object Required Error.
<input type="button" name="pSearch" value="Search"
onclick="DisplayRecords()">
Then in my ASP page I have this
Sub DisplayRecords()
dim conn
dim strsql
dim mycount
I want to display all records from the database based on keyword entered by user. As for example,
ContactName Title Phone
xxxxxxx xxxx xxxxx
xxxx xxxxx xxxx
xxxxx - xxxxxx
I want to add another column (to display no. of record), as for example,
No. ContactName Title Phone
1. xxxxxxx xxxx xxxxx
2. xxxx xxxxx xxxx
3. xxxxx - xxxxxx
Is it possible?
i am trying to figure out the best way to display records. I have a page which pulls multiple data from mulitple tables in multiple queries. In order to get the page layout to put the records in the right spot i would like to be able to display each record invidually.
Is there a way to echo a record to a spot instead of using a datagrid? I know in php i can specify the database recordset and then echo the value for that particular record. Does asp have the equivalent to this?
I've situation where I just want to displaying first five record in the database. I've search in this forum but could'nt find it.
View Replies View RelatedOn the webpage, I want to display like this:
I use Response.write objRS("FieldName") to display the value of a record .I guess a number of chars is allowed to display a part of record.
When a selection is made from a list (lstpos) - single selection allowed, (for example a user selecting engineer), it retrieves all the duties (it may b a duty i.e. 1 record OR many duties i.e. more than 1 record) an engineer performs (each one on a different line) from a table and automatically displays text boxes next to each duty so that the user can input "scores" for each duty (rate the engineer).
How to do this?
Next this data needs to be input in a table when the user clicks a button (ADD or OK) in the format :
user duty score
user1 duty1 score1
user1 duty2 score2
user1 duty3 score3
etc...
Anyone has an idea how to do this?
How would I get the max record + 1 to auto-populate in the GMVINC form field? I have a feeling that my query is not correct. Code:
View Replies View RelatedI have data outputted to the table such as (where * are dividers):
Name 01 * Category 1
Name 02 * Category 1
Name 03 * Category 2
Name 04 * Category 2
Name 05 * Category 2
Name 06 * Category 2
Name 07 * Category 3
Name 08 * Category 3
Name 09 * Category 4
Name 10 * Category 5
Name 11 * Category 5
I want each "Category" to have it's own background color, aletranting colors would be ideal so:
Name 01 * Category 1 (Background Color #fff)
Name 02 * Category 1 (Background Color #fff)
Name 03 * Category 2 (Background Color #ffc)
Name 04 * Category 2 (Background Color #ffc)
Name 05 * Category 2 (Background Color #ffc)
Name 06 * Category 2 (Background Color #ffc)
Name 07 * Category 3 (Background Color #fff)
Name 08 * Category 3 (Background Color #fff)
Name 09 * Category 4 (Background Color #ffc)
Name 10 * Category 5 (Background Color #fff)
Name 11 * Category 5 (Background Color #ffc)
i want to give font color red to each head line ..how to concanate with this '<%=RS1("headline")%>';
Do while NOT RS1.EOF
%>
theSummaries[<%=i%>] = '<%=RS1("headline")%>';
theSiteLinks[<%=i%>] = '';
<%
i = i+1
rs1.movenext()
Loop%>
I have got a peculiar requirement. I want to distinquish between the color codes.
I have got two text fields and i will enter the color codes there. The first text field will have background color The second will have text color.
I want to validate if background color is dark then only light colors should be entered in text. and vice versa.
Is there a way to control the hypertext color. I noticed mine are blue when not clicked and red/purple when checked. Is there a way I can make them say white and blue?
View Replies View RelatedI have built an asp app that sends an e-card to selected recipients along
with the text entered by the user. Well, on some machines the text is not
visible because the background color of the table is not going across
correct. The background color is supposed to be teal with white letters.
However the background is going across white with withe letters on some
machines. I am using the same browser (version and everything) as one of the
machines that can't see it the correct way. I am able to see it fine. I have
put in the back color for all of the cells the table, etc but it's still
going through white. What would cause this to happen?
I was asked to incorporate colour options for items sold in my shopping cart such as pens.So if I am selling a pen that comes in 4 or 5 or more colours, then I have to create the number of types of collours for the pen. I am looking at creating a colour dropdowns for individual items , but I am not sure how I can do this in backend.I am using Access database and using ASP programming. This is the link which is an example of what I mentioned http://www.27905398.com/product_inf...9a4aed0a18fb81d .appreciate if anyone familliar with this function
View Replies View RelatedIve created a web page that queries a db and i have that all working fine. What i dont have though and would like to be able to do is get the page to highlight rows according to one colums value, ie
Colum1 Colum2
Row 1 50 Test <-- would like to the be highlihted lite blue for instance
Row 2 90 Test2 <-- would like this to be highlighted red for instance
does anyone know how to make a pop up color chooser so that people can click a button that pops up a thing of colors and then they select from it? i'd even take the color options thing that is at the top of this scrren when writing messages but i need a way to choose colors easily.
any suggestions? also it doesn't have to be in asp, i'm figuring it might be better suited for js or something but i don't really know js and most of my site is in asp...
i've been playing around with this code but can't seem to get it to work. When the check box is clicked the row should change to a color, not sure on why its not working, any ideas? Code:
View Replies View RelatedI'm gettin some numbers out af a db, and would like it to give certain numbers different color. lets say that all numbers 4 should be red, and all numbers 5 should be green.Is that possible
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
I know the basic 8, how do i find any others besides those 8? do you use hex codes? should also note that i need to be able to match the vbcolor to a hex color.
View Replies View RelatedI load data from dtb and would be nice to have different color for loaded colors, e.g. blue and light blue. I don�t know how to make it. Here is my code which loads data from dtb: Code:
View Replies View RelatedAnyone have code for a color chart. Specifically a chart that when clicked passes the hex value through querystring or a form. I could make one, but I'm just feeling lazy today.
View Replies View Related