I 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 Repliesim 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 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 aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedHave an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
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 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 Relatedhow to change a string to upper case.
View Replies View RelatedIs it possible to change the dropdown values in a <select> tag based on the Server Variables LOGON_USER?For instance, if userA is the LOGON_USER, the dropdown would show option 1, option 2, option 3, option 4. If userB is the LOGON_USER, the dropdown would show option 5, option 6, option 7, option 8.
View Replies View Relatedi ussually use www.domainname.com?uid=1111 .this one use request.quarystring right?so, what is the logic to change to www.domainname.com/1111
View Replies View RelatedI have a site with a simple admin tool (cut and paste text into a form field etc)henever someone copies in text with quotation marks, dollar/pound signs and then submits it to the database, the text shown on the front end contains ? marks instead.I have read this may be due to special characters or something, is there anyway to stop this
happening or filter it out as the admin is for general use by registered people.
I have made a case for changing values in the recordset but when I click on the submit buttom nothing happens. Can anyone see whats wrong?
View Replies View RelatedWe want the currently date display in the input box (asp code), if the user wants to change the date, they can pick a diff. date from "date picker calendar". It picks the date...and it works fine.
When I try to submit, it doesn't submit the Date that I picked. I view the source code, it seems like it doesn't change the New DATE that I picked from the calendar. How can make its value change?
Is it possible to change a variable name? I need to store some information to be displayed to the users in a variable but I need to change the name of this variable. So what I need to do is read some info from the db, create a recordset and then read the first row of the recordset and store the result in a variable named Answer_1, read the next line and store the result in the variable Answer_2, is it possible?
I tried the following code:
Answer_"" & Counter & "" = "" & rsResult("Answer") & ""
But it doesn't seem to work.
let's say I have this string in the DB:
s=100,101,102,103
and also id=101
how can I change "s" to be "100,102,103" ?
I want to check a string for a certain value then change that value to something else.
Example, user types in a value in a form "jim" , some code checks to see if the letter "m" is in the string. If it is it changes it to "t".
But we don't know if the string is jim everytime. Sometimes it could be "mark" or "quagmire". But for any string with letter "m" i want to change it to "t". So "mark" would become "tark", "quagmire" become "quatmire" Is this possible?