anyways what id like to do is in my "do while" loop i want to create different background colours so its easier to read with large tables.
I know the code should be something like:
If variaiable isnot true then
bgcolour = blue
Else
bg colour = red
end if
i am, however, not quite sure ont he correct syntax for it?
I have no idea how to code a table where each table row is a diffrent colour. EX. Row 1 is RED Row 2 is Blue. Row 3 is Red again.
View Replies View RelatedThere is something wrong in this. I couldn't figure it out.
I have three: Keyword, Keywordb, Keywordc
I had inserted: strSearchFor, two, three (same function)
Code:
In a form I'm creating several asp text boxes for user input. When I look at these in IE or Firefox one or two are coloured yellow with a border, whereas the rest are the normal white with a thin blue border.
There is nothing I can see in the code that does this, and with a bit of testing I can force this condition by adding text outside the text box. Very weird. Has anybody seen this behaviour before. I'm using Dreamweaver MX 2004, but I'm feeling it's not DW at fault here.
I have got the following PHP code which I am trying to convert to
ASP.cant find a replace function for Unset in asp which will discard the variable
if ($categoryid == "all")
{
$sql = "SELECT * FROM products where shopinspection=$shopinspection";
unset($HTTP_POST_VARS['categoryid']);
unset($HTTP_POST_VARS['shopinspection']);
}
else
{
$sql = "SELECT * FROM products where categoryid = $categoryid";
unset($HTTP_POST_VARS['categoryid']);
}
unset($HTTP_POST_VARS['Submit']);
while (list($key, $value) = each($HTTP_POST_VARS))
{
if ($value != "" )
{
$sql = $sql .=" AND $key=$value";
//$sql = $sql .=" AND solesource = $solesource";
//echo "<strong>$value</strong>";
if there is any alternative software to MS Access for creating .mdb file?
View Replies View RelatedIs is possible to pass parameters with this URL:
www.mysite.com/article/sports/football
instead of the usual method:
http://www.mysite.com/article.asp?c...tegory=football
And, if I need to add more parameters at a later time, may I then use
something like:
http://www.mysite.com/article/sport...321&language=EN
Also, I am using ASP, not ASP.NET.
i have read a few articles saying that you can run IIS on XP home but it does not look too reliable to me and am not too willing to try, so is there an alternative set-up i can use to test my ASP before uploading?
i say this as all ftp hosts seem to want your code pre-tested before uploading .
Looking for a way to switch between submit buttons. The default will be "start" and when the tech clicks on that, the button will start a timer, which I have already set.
The button then will switch to "stop" and when a tech has completed a job and clicks "stop" the timer will also stop and switch the button back to start.
I know how to track the time for each tech that starts and stops a job. I need a jumpstart on how to switch onclicks for two buttons.
I would like to set up an ASP page that sends an e-mail, but the server I'm working on doesn't have CDONTS installed for security reasons. I don't have any control over the server. Are there any alternatives to using CDONTS that will work or a better option?
View Replies View RelatedIs there any other way or trick to include an asp file in my ASP file than the classic html #include. In fact my filename (which is to be included) will be coming from database and #include statement doesn't support any kind of variables.
View Replies View RelatedI know this is not a core .asp issue, but I'll try anyway. I've used the TEXTAREA element for a while, but as you know it's limited when it comes to formating part of the text inside a TEXTAREA.Does anyone have expirience using other text cointainer objects (Java/ActiveX), which is easy to use and easy to read values from when sending a form to a procedure .asp page?
View Replies View Relateddoes someone knows what's the alternative of Iframe. Actually I have to use IFrame and it works in IE but NS 4.74 to NS 4.78 doesn't support IFrame.
So, I have to use alternative of IFrame so that my application can work in both IE and NS 4.74 to NS 4.78
I'm using ASP and I need to generate a ZIP file that contains a list of files that I'm pulling from a database. I've determined WinZip's command line parameters so that I can use it, the problem is I'm unsure how to run WinZip on the server.
Set WshShell = Server.CreateObject("WScript.Shell")
WshShell.Run("c:winzip.exe")
Assuming this would work, how do I get the process to terminate upon completion? I can't have 20-30 WinZip applications running on the server, I need it to handle what I send to it and then close. Maybe I'm taking the entirely wrong approach here.
I have an asp file that gathers info from a form and sends to the database. im now changing the location of the database from the root path. I think that because of this i cannot use Server.MapPath method of sending data.
Coudl someone please help me out and let me know how i would change the code? Im quite new to this as you could probably see. Code:
Is there an alternative for CDONTS.NewMail for sending email? according to this article , CDONTS.NewMail works only on Windows NT/2000 Operating Systems.
Is there an alternative class that works on Windows XP to send email?
Is there another command in asp that I can use to send users to a different page.
I use response.redirect alot in our site and I suspect it is causing us ranking trouble as it is basically a 302 redirect.
I use it like this.
If user is not logged on > send him/her to the log on page and attach a variable showing where the redirection came from so they can return easily.
Is there another way?
I would like to know if there is alterntiave to using Select Case?I have over 80 files that a user can select from a drop down list and 'read'. Rather than writing out 80+ lines with INC files, what is the other less code option?
View Replies View RelatedGood:
246/10 = 24.6
round(24.6) = 25
Bad:
246/100 = 2.46
round(2.46) = 2 (I want 3)
If I have a decimal, I want to round up. Always. How do I achieve this in ASP?
i am using cookies to save a users login information which is then used again on another page to save data to a database. This works fine on certain clients' machines, but on others there is an error. Am i right in saying that it is because cookies are not enabled on their machines? If so, is there another way i can do this?
View Replies View RelatedIs there a free ( has to be free ) web server that can run active
server pages like pws?
I'm trying to build a contact form using ASP. The form works properly but the code I found has "Response.write "Your email..." which appears on a white page after the form is successfully submitted. Is there a different function I can use that will redirect the use to another .html page (like a "thank you for submitting...") instead? Code:
View Replies View RelatedAre you suffering from the same problem? In the past, you want to access to a secured page protected by Windows Authentication (e.g. Exchange OWA), you will make such redirection "http://usernameassword@domain/exchange/".
However, because of security and Microsoft's latest patch, it will be no longer working. I wonder what we could do now if we want to do the same.
In VB there is a command that can be used to convert a string into proper case, e.g...
msgbox StrConv("HELLO", 3)
Would say "Hello". However, there is no such function in ASP (it seems to be one of the few commands that was not exported into VBS....god I miss DoEvents too....used to abuse that command.....lol).
Anyway, do you guys know any methods that can be used to do the same thing? Basically I have a name all in CAPS, and I want it to be converted into Proper case so that it's easier on my visitor's eyes when they see it.
I'm using CDONTS and am trying to send an email out which displays in HTML for HTML-enabled clients, and plain text for non-HTML clients. Unfortunately I am using IIS4 so CDOSYS is not available (so I can't use the handy .Textbody or .HTMLBody properties). How would I go about it with CDONTS?
View Replies View RelatedMy users have to select an value from a fixed selection of values. The
obvious choice of control for such a requirement is to use a <select> (i.e.
a combo box).
My problem is that sometimes, these combo boxes will have a *large* number
of values. There could be any number of values in them from 5 to 5 million
(unlikely it would be this large but possible).
Obviously 5 million is far too much to populate a <select> control with.
Does anyone have any suggestion as to how a user could select a value from a
*potentially* very large selection of values (i.e a suitable alternative to
the <select> control)?
Having just "discovered" it myself, I thought I'd draw everyone's attention to the fact that the WinHTTP 5.x object (which is used behind the scenes by our good friend the ServerXMLHTTP object) can be used directly in scripts.
This is useful because the ServerXMLHTTP object encapsulates XML-related functionality which is unnecessary for performing most simple HTTP requests, and thus by using the WinHTTP object directly you achieve higher performance, scalability, and reduced memory consumption... AND WinHTTP offers quite a few features that ServerXMLHTTP does not expose - including the ability to specify a proxy (and an exclusion list) from within the script (or to acquire them from Internet Explorer's settings), IPv6 support, and HTTPS/SSL support!
For more information .....
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 Related