ok ok, I found what my problem was and actually it was within the values of the fields inside the Data Base but the code ended like this
[code=asp]
<% While ((Repeat1__numR ows <> 0) AND (NOT rs_selecciona_p restamos.EOF)) %>
<%
dim sClass,valorcam po
'Test to see if you want to change the background colour
...
jullianps
Last Activity: Mar 5 '08, 11:05 PM
Joined: Feb 27 '08
Location:
-
First of anything thanks for the response, I tried your suggestion and looks like it might be the solution to my problem, I did exactly what you suggested but apparently I am doing something wrong, the code looks ok but at the same time it is not working well, look at the code please and on the IF statement the decision always go to the last ELSE as if the other 2 comparisons were not succesful when indeed there are values that should make those...Leave a comment:
-
Assign CSS Style to a Data Grid Row
I have an ASP page where I have a "Repeat region" which is populated dinamycally from a Database, everything works perfectly, the thing is that I thought it would be cool to fill a row or to set its background color (for that single row) if the value of one of the fields = something in particular, and I've tried making a function that changes the style through VBscript and Java Script then trying to call the function each time or on every...Last edited by markrawlingson; Mar 4 '08, 12:31 AM. Reason: Added code tags. Please use code tags when posting ([code=asp]'some code [/code]) -
Assigning Styles Dinamycally to a data grid!
HI everyone, here is my question and I hope it isn't or it hasn't been posted before, probably it has but I spent a few minutes looking through the forums and with the search feature and nothing could solve or help me with my problem so here I go.
I have an ASP page where I have a "Repeat region" which is populated dinamycally from a Database, everything works perfectly, the thing is that I thought it would be cool to fill... -
Awesome, Worked like a charm I ended up adding a trigger for Insert and this was the simple Update statement that made it work
CREATE TRIGGER [Add2hours] ON [DB].[dbo].[Table]
FOR INSERT
AS
Update fileslog set date_time=DATEA DD(hh, 2, date_time)
Thanks for the tip
MarcoLeave a comment:
-
Thanks so much Ive opened the link and it looks like what I need !
MarcoLeave a comment:
-
Add 2 hours to a time value!
Hi Guys and lets start by saying that this is my first post, I would like to thank in advance to those who can give me a hand and lets start with the quesiton...
The problem probably could sound super easy for some of you but I cant figure out how to do it yet, I have a Datetime field on a MS SQL server DB and it gets its default value through Getdate() and it works fine but the problem is that I need to add 2 hours to the ending time...
No activity results to display
Leave a comment: