User Profile

Collapse

Profile Sidebar

Collapse
karen987
karen987
Joined: Mar 29 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • karen987
    replied to how to add 2 hours to code which shows server time in asp page
    in ASP Classic
    Yes the code above does show the time it shows like this, and it moved it 2 hours forward,

    10:12:00 PM when the time was 8.12pm here.

    so yes, it works. But actually that's not what i wanted,

    Sorry i didn't explain it right, or maybe you misunderstood. Let me briefly sum it up.

    I have this code
    Code:
    <%= FormatDateTime(POSTED,DATE_F) %>
    which shows as

    3/21/2008    ...
    See more | Go to post

      Leave a comment:

    • karen987
      replied to how to add 2 hours to code which shows server time in asp page
      in ASP Classic
      im not sure what "hard code 2" means, as im totally html illiterate. I'm not even sure if i used your example above (1st one) correctly.
      Should the first code you gave have gone on the asp page itself? I presume so, and i assume i would need to change it on other pages which i have. I don't know what "session variable" is.

      Basically, my problem is that the server is in another country to the one i want...
      See more | Go to post

        Leave a comment:

      • karen987
        replied to how to add 2 hours to code which shows server time in asp page
        in ASP Classic
        Sorry it didn't work, and that's because the code isn't using the config. asp file.

        Someone told me to use a global.asa file that would change the time . I'm using this, but it nothing happens, can anyone see what i need to change here? I need to move the time 2 hours forward, the hour, which means at 20pm it should show the next day's date.

        Thanks in advance.

        I'm using this code now and it doesn't change        ...
        See more | Go to post

          Leave a comment:

        • karen987
          replied to how to add 2 hours to code which shows server time in asp page
          in ASP Classic
          thanks i'll try it. Thank you...
          See more | Go to post

            Leave a comment:

          • karen987
            replied to how to add 2 hours to code which shows server time in asp page
            in ASP Classic
            I have a news weblog with asp pages. I need to make a system wide change so that the articles are showing 2 hours ahead in the public view. This is because the server is in another country. I'd need to be able to adjust for daylight saving.

            I think the common file for this is the include file "config.asp ", and i have included the code below.

            Here is a page example which shows the political news in posted...
            See more | Go to post

              Leave a comment:

            • karen987
              started a topic how to add 2 hours to code which shows server time in asp page
              in ASP Classic

              how to add 2 hours to code which shows server time in asp page

              This code is for a comments section on a news article. Each comment shows the time. The page is an asp page.

              I'd like to add 2 hours, hopefully within the code below to make the time show 2 hours ahead, i'd need to be able to adjust it for daylight saving in future.

              This code:
              Code:
              <%=FormatDateTime(C_DATE,3)%>
              shows the time like this

              "4:34:20 AM"
              ...
              See more | Go to post
              • karen987
                started a topic how to add a brief message when a page is blank
                in ASP Classic

                how to add a brief message when a page is blank

                the page below is called "todays newslog" and it automatically draws out news articles posted within a 24 hour period. It is an asp page updated each midnight.

                During the time Midnight to whenver the first article is added, the page is blank. I would like to add this statement to the blank page only, so that it doesn't show after the first article is added. ie. it should only until news is added.

                "No                ...
                See more | Go to post
                • karen987
                  replied to how to make text follow in a new line and fit into a cell without widening it
                  in HTML CSS
                  OK now i have some code, which chops the long url, to fit it into the 150px wide cell, as before it was making the cell wider. I used wordwrap.

                  It works, but what happens is that the url gets chopped, and the chopped bit, doesn't carry on in the next line. It works in the link though, but i'd like the whole link (url) to show, it can carry on the next line and line after if need be.

                  This is what im using, but on the...
                  See more | Go to post

                    Leave a comment:

                  • karen987
                    replied to how to make text follow in a new line and fit into a cell without widening it
                    in HTML CSS
                    i actually discovered the right code, that needs modifying, i didn't post it above, it was the wrong code.
                    Here is what i have at the present, and using your suggestionms, which doesn't chop the url, it still makes the table cell longer. Bear in mind the url that is pulled is like one very long word, it's a headache, what a silly problem

                    ive even tried adding the style from dreamweaver, to the "email" and "web...
                    See more | Go to post

                      Leave a comment:

                    • karen987
                      replied to how to make text follow in a new line and fit into a cell without widening it
                      in HTML CSS
                      <td class="aTitle" valign="top">
                      <!-- Left Column -->
                      <a class="RelatedA rticle" href="view.asp? ID=<%=trim(RS(" ID"))%>"><%=tri m(RS("fldTITLE" ))%></a><br /></td>

                      and on the css styles page i added

                      td.acolumn {
                      width: 150px;
                      overflow: hidden;
                      }

                      ...
                      See more | Go to post

                        Leave a comment:

                      • karen987
                        started a topic how to make text follow in a new line and fit into a cell without widening it
                        in HTML CSS

                        how to make text follow in a new line and fit into a cell without widening it

                        I have a column in a table, which draws out info from a database. The column is 150px wide. I want it to remain this wide, even if one word is longer. What happens now is that if i put in a web address which is long, it makes the columner wider. I want to make it trunucate the url so that it ends after 150px has been reached and continues to the next line. If i have a word longer than 460px i will have the same problem.

                        Any solutions...
                        See more | Go to post
                        • karen987
                          replied to how to pull out a specific category from a database
                          in SQL Server
                          actually it works now, and the answer was above, you just weren't articulating it so that i could understand. Somebody else simply said:

                          From the page where the link is , put
                          http://www.yourpageand directories..as p?CID=37

                          and it worked. as simple as that. The code on the page above stays CID,

                          Thanks anyway:)...
                          See more | Go to post

                            Leave a comment:

                          • karen987
                            replied to how to pull out a specific category from a database
                            in SQL Server
                            Iburak, sorry about this, but i don't get what your'e saying. Are you saying i should put
                            http://www.yor_page_URL_he re.asp?CID=37

                            where CID is?

                            There are 3 places where it is, so where should i put it? pls mention the line number from the code i posted in my first post.

                            Sorry about this, i'm a total novice. Thanks for your patience. Much appreciated....
                            See more | Go to post

                              Leave a comment:

                            • karen987
                              replied to how to pull out a specific category from a database
                              in SQL Server
                              Thank you iburyak,

                              I tried this,by replacing "CID" with "37" but it didn't work. It still pulled up all the authors

                              Code:
                              IF IS_VALID_ID(CID) THEN
		 	CID_SQL = " WHERE ID IN (SELECT fldAID FROM nm_tbl_news WHERE ID IN (SELECT fldNEWS_ID FROM nm_tbl_news_cate WHERE fldCATE_ID = " & [B]37 [/B] & "))"
		 END IF
		
		
		Call OPEN_DB()
                              ...
                              See more | Go to post

                                Leave a comment:

                              • karen987
                                started a topic how to pull out a specific category from a database
                                in SQL Server

                                how to pull out a specific category from a database

                                The code below is for an asp page that pulls out a list of authors in a given category, from a news weblog. In this case, the category id (CID) is "37" . So the page should list all authors from category "37"

                                However it seems to pull out authors from all the categories. I think the code may be misplaced a bit, can anyone see what is wrong with it? It needs to be tweaked so that it only draws out from category "37"                                ...
                                See more | Go to post
                                • karen987
                                  replied to Drawing meta tags from a database in an asp page
                                  in ASP Classic
                                  I will try that, Jared, thanks for the tips.
                                  See more | Go to post

                                    Leave a comment:

                                  • karen987
                                    replied to Drawing meta tags from a database in an asp page
                                    in ASP Classic
                                    actually i've changed the format now, i no longer need the inc.header.asp page,

                                    so i'm going to put the code at the top of the view.asp page, which is like this, however, it's not picking up the Title. I want the title of the article to be the title of the page, and the meta tags content for description and keywords. The code is as above, so where do i put the

                                    the code to view.asp is in the first post i posted in this...
                                    See more | Go to post

                                      Leave a comment:

                                    • karen987
                                      replied to Drawing meta tags from a database in an asp page
                                      in ASP Classic
                                      Sorry i forgot to add, I'm not html literate, so i'd appreciate it if anyone could show me exactly what to put on both pages
                                      See more | Go to post

                                        Leave a comment:

                                      • karen987
                                        started a topic Drawing meta tags from a database in an asp page
                                        in ASP Classic

                                        Drawing meta tags from a database in an asp page

                                        I want to draw out records from the database, and use them in my meta tags. I only want to use one record, which is called "TITLE", and i want to use this in the "title", "keywords", and "descriptio n", in other word the content of all 3 is "TITLE"

                                        I have page called "view.asp" whose relevant code is as below. The meta tags are in "inc.header.asp " file.
                                        ...
                                        See more | Go to post
                                        • karen987
                                          replied to How do i add dynamic meta tags to a database driven asp page
                                          in ASP Classic
                                          "sigh"
                                          OK now i tried this, and the error went.

                                          Code:
                                          <% 
title = "TITLE"

meta_description = "TITLE"
 
meta_keywords = "TITLE"
 
%> 
<!--#include file="inc_header.asp"-->
                                          however, when i went to check view.asp on the web under "view source"
                                          this code was at the top of the...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...