You could use the SQL Server function GetDate() - that'll return both the date and the time. To do so do this :- strSQL = "INSERT INTO v_deal_history (dealID,...
Hi Group, I'm having a problem with cookies. I am using IIS5 on my local machine to develop a web site. I have created a logon page that checks the username...
Hi I have am using following code to generate a word document from a web site using ASP thusly: Response.ContentType = "application/msword" Response.AddHeader...
I have a database .asp that I want to write an if then statement for, I want to be able to change the color of the table cell based on the response from the...
Here you go (replace GetValueFromDatabase() with your value from the DB) :- dim boolRed boolRed = GetValueFromDatabase() response.write "<td bgcolor=""#" if...
hello friends i have a huge customerhistory table, which stores every action done on a customer. i need to query out conditions where there was some specific...
i had the same problem. what i did is instead of creating a virtual directory, i put the files inside wwwroot folder, and it worked. ... From: Darryl To:...
Okay--this is the script I have on my page: Dim boolred boolred = GetValueFromDatabase("Response") response.write "<td bgcolor=""#" if boolred = true then ...
What is "GetValueFromDatabase?" That needs to be a function that you've defined. You must have just copied and pasted this code from somewhere but didn't...
Costanzo, Ray
rcostanzo@...
Jul 1, 2003 6:07 pm
5777
What is GetValueFromDatabase("Response")? Show us the script you use to get the value from the database....
I asked earlier for help writing an if the statement that will allow me to change to table cell color depending upon the value in the database. This is the...
Is the value in the WHERE a variable (e.g., WHERE id = "&Request.Form("Id"))? If so have you checked to make sure there is a value in the variable? When I...
An example. rs = recordset, foo=columnname. Ray at work ... ...
Costanzo, Ray
rcostanzo@...
Jul 1, 2003 6:38 pm
5783
Both of those if else statements will work. I like Chris's. <% if rs("foo") = somevalue then strbgcolor = "RED" else strbgcolor = "GRAY" end if %> <TR> <TD...
You're not stupid. You're just trying to run a marathon while you're still a zygote. Did you see the part where someone wrote "(replace ...
Costanzo, Ray
rcostanzo@...
Jul 1, 2003 6:41 pm
5785
Sorry to keep bothering you--you probably are thinking "what an idiot"(haha) This is the tag I have in my document. It is not working--do you see a problem--...
Unless "Now" is both your table name and your DNS name and "OnTidbits" is really what you are calling the variable for your recordset....... The problem is...
Hi Jess,,,, ,,,, I often use this form of writing inline asp code: <% if rs("field1") = "true" then %> <td bgcolor="#FF0000"> whatever </td> <% else %> <td...
you have to use a defined object. (recordset object and field name) rsWhatever("fieldname") you create that by this: set rsWhatever = conn.execute(sql) //...
Hello,,,, ,,,, I never really used server behaviors that much, but here's a good site. http://www.fwzone.net bedgawk@... wrote: can anyone suggest a...
"rs" is the recordset you create e.g., <% sql = "select * from tablename" set rs = conn.execute(sql) %> "foo" is the name of the database field name you are...
You are NOT!! stupid. Most of the mistakes you've made, I've made twice over. All of us has been there. You are stupid when you don't bother to ask. If not,...
you can also make it look more sensical and just use single apostrophes. e.g. response.write("<td bgcolor='##0000FF'>whatever</td>") that's what i use anyway....
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
