Hide A News Item

I have added a new field in my database for the news items, basically a boolean value (true or false) for the display or hide of a news article. I have simple added to my queries WHERE newsDisplay, and that does the job except now I have one query qhich is actually causing me a small problem, due to the query already having a where clause.

like below:

dbSelectQuery("SELECT * FROM tblNews WHERE newsID ORDER BY newsDate DESC")

So that leaves me a little puzzled as to going about this query which should solve the small issue, I was even thinking is there a way I can use an if operator. Something along the lines of if newsDisplay = true or checked then do something else. Someone must know. I just dont think you can actually use an if statement on a sql query? Any tips would be perfect . PS - The new field I have added is newsDisplay as a yes/no in an access database.

View Replies


ADVERTISEMENT

How To Hide Category If Assoc. Item Field Is Empty

I have an index.asp page that displays my database items, along with their respective categories. The categories are an include page (left.asp). How can I hide the category if there aren't any items for that category? Here are the 2 pages below....

View Replies View Related

RSS News Feeds And XML

I have written a RSS News Fees application for my site, by I want to limit the number of news items to only 5 instead of the 10 that Reuters sends. Here is the main code:

View Replies View Related

Asp News Archive

As the client uploads the December news story, it replaces the November story and adds November to a dropdown menu on the news page.For example, all archived months stories can be accessed from the dropdown menu and the current month is visible on the page.
Hope this makes sense! Can anyone help, or point me in the way of some script I can download?

View Replies View Related

News Lettor

I put together a simple link for people who want to submit their email address to receive a newsletter. People are directed to the correct page but when they try to submit their address, the following error comes up:

Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC Driver Manager] Data source name too long
/emailnewsletter.asp, line 76

Line 76 in /emailnewsletter.asp says:
MM_editCmd.ActiveConnection = MM_editConnection;

Here is the whole text for emailnewsletter.asp: Code:

View Replies View Related

Automate News

Everyday of my life the last year has started by searching through a lot websites in order to find the latest news, and then making a link to that news from my webpage. What I have always dreamt about is some kind of automation.

Is it possible to make a script in ASP that searches through a website and gathers info on title, URL and such, and then automatically inserting it into my website (via for instance a SQL database)?

View Replies View Related

XML For News Feeds

I have made an ASP page that dynamically creates an XML page from articles stored in an Access Database. It works great and i was well pleased with myself.I was then sitting back admiring my own work when i suddenly thought.The page ends in .asp and not .xml.So i downloaded some free feed readers and news readers and they all found the feed with no problem and i thought i was going to be alright then it clicked - What if the "person" who wants to add my feed to their own site for example, has their site written in PHP?

I wrote a little PHP script that dynamically inserts feeds and sure enough, it will not accept a feed URL ending in .asp. It's (of course) fine if it ends in .xml So, (sorry for going on) Im wondering on your thoughts about this and what you would do? How LESS efective do you think an XML feed ending in .asp is?

View Replies View Related

News Archive

i want to add this portion to my site.i want to display category of news depending on date.i want to display such news one month back from current date.

View Replies View Related

ASP News Script

My site is currently 90% asp, which has created a huge problem when tryign to find a free news/journal script to put on my site. Do you know any good free news scripts that allow you to do the normal stuff: post news, admin login, upload pics, user comments (optional), keep an archive of all the old stuff past X posts, ect?

I could in theory, write my own script but I do not have that kinda time on my hands either.

View Replies View Related

RSS News Feed

Anyone know the code to retrieve and display an rss news feed ?

View Replies View Related

Rss News Feeds

I'm trying to make an ASP page with VS .NET 03 using VB as the language and I want the page to display an Rss News Feed as page content form another RSS News Feed on a web page served by another one of my IIS srevers, I don't know how to do this it sounds simple enuf but were do I start is it a simple one line of code deal or it it complex to do I havent really played around with Rss news Feeds much give me some feed back .

View Replies View Related

News Reader

How can I get my reader (outlook express) to purge out the threads that are "Message is no longer available on the server" Is there a way?

View Replies View Related

News Items

This is my scenario. On the left of the screen, I have a list of news items, which are updated by the user and inserted into a database, and then they are dynamically displayed on screen from the database.
Now what I want is that if a user clicks a hyperlink from the left of the screen on a news item, the relevant text is displayed on the right. What I did up till now was that if I point on a news Item to the left of the screen, I know which item in the recordset it is since I created a counter.

View Replies View Related

News Scrollbar

I would like to add a horizontal news scrollbar added to my page that is fed by an ACCESS db. Does anyone have a link of where I can find a script for something like this?

View Replies View Related

Develop A News Bulletin

I have to develop a news bulletin system for my website. Plz can someone help with suitable links or examples to develop this. Im using asp with vbscript and sqlserver backend.

View Replies View Related

Creating News Archive

i have a created a CMS in which newstitle, the newsdetails and date(automatically inserted using the date() function) that it is added is inserted into an access db.
Now what i want to do is to create a news archive list which groups the news item added by month, so let's for the month of july all news are grouped into a heading call july(2007).

View Replies View Related

Sending A News Article

I am using asp to create a form where you can send the news article to a friend, and it actually sends the entire article. The problems the article contains <br>,<b>,<i> tags, and when I send the email it shows up like this Quote:

in the Holy Land: The Ideal and the Real. </b><br>
<br><br><br>
The lecture is co-sponsored by the Center for Middle Eastern Studies at
North Park University,

I discovered the replace function. Replace(body, "<br>", chr(09)). That got rid of all the <br> tags, but there are still <b>, <i> tags in there. Is there a way to do a multiple replace like Replace(body, "<br>",chr(09) & "<b>", Chr(09))? I tried it and it did not work. Is there a way to do that?

View Replies View Related

News Include File

I'm trying to include file if ?news=news by this code but is not working. Code:

<% news_page = request.queryString("news")

if news_page <> "" then

include file="test.asp"

end if
%>

View Replies View Related

News System Without Database

I have a news page on a web site that now needs to be seperated in to a number of 'views' (eg. so that each user sees a different set of articles). I would like to stay away from using 20 include files!

I know how to do this with php but this time I don't have the luxury of being in an environment I'm familiar with. I also need to do this without a database, and in the most economical way possible.

View Replies View Related

Connect To News Server

can anyone tell me if it is possible to use asp to connect to a news group, such as this?

View Replies View Related

Create Blog/news Archive In Asp

I have being trying a create a dynamic news section on my web site for a while now and I cant get it to work.

I would link the home page to display the four newest news items and then a link to a news archive on a seperate page.

The news archive will have links ordered by YEAR then MONTH, similar to the following page: Code:

View Replies View Related

Complete News Script, Comment And Check

Just finished creating my own news script and was wondering if someone could look at it for me comment on it, how secure is it etc.

View Replies View Related

Hide Until

I want to hide a submit button until all parts of the form are completed, the form contains 7 rows of radio boxes which are in groups(5 in each grp) when all are selected i want the button to appear but the page not needing to be refreshed, any ideas?

View Replies View Related

How To Hide

I migrated a mysql DB into a MSSQL DB. In this DB all chars like "blank"
or @ are encoded in...whats it called in english? :)
you know, when a blank is "+" or @ is "%40"... :)
How do I resolve those "%20"s back into a readable character or a blank
with asp?
Plus: How do I convert blanks into + again to write them back into the DB.

View Replies View Related

Hide The Value

i m passing value through href link.
like this
Code:

<% while not rs.eof
%>
<tr><td style="font-weight:bold">::</td><td ><a href="<%=rs("newsurl")%>&id=<%=rs("newsurl")%>" style="font-family:sans-serif;font-size:12px"><%=rs("headline")%></a></td></tr>
<%
rs.movenext()
wend
%>

and this value appers in address bar.any way to hide this whole value in address bar

View Replies View Related

Hide The Values

I have an Invoice.asp page which displays the number of products ordered by size. I would like to make the 0 values invisisble on the page. Can any1 help?
Below is some code that applys what i would like to do this using text fields.

<%
If O("S4") = 0 Then
txtValue4 = ""
Else
txtValue4 = O("S4")
End If
%>

<input name="textfield4" type="text" value="<%=txtValue4%>" size="1" maxlength="3">

"O("S4")" is the recordset name and "txtValue4" is the initial value of the textfield.

Does anyone know how to alter this piece of code so that it applys to only the recordset "O("S4")" and not the textfield, alowing me to get rid of the textfields?

View Replies View Related

Best Method To Hide

What's the best method to hide, or not show a certain record when doing a pull from a database, as in I am pulling a list with a dozen category's and I don't what to show one of them.

View Replies View Related

Hide Code

Is possible to build a old ASP application in order to give to final user an application that hide its code?

View Replies View Related

Hide Drop-down Box

I need to hide a drop down box. For a car search page, if the user selects "NEW" the mileage drop-down dissappears, but if the user selects "USED" than the mileage drop down appears. I need this on the server side, so I would be needing to use VBScript.

View Replies View Related

Hide Hyperlinks

Can anyone provide the code to hide hyperlinks (change to background colour?) if the files they link to do not exist?

View Replies View Related

Hide ASP Or Php Code

How can i make sure my ASP code is hidden on my web server when soebody accesses the ASP page? I want to do all I can to protect against this. The other day I was at a web page and instead of seeing the results of the page, the entire page was displayed to me as text and you couldd see all the asp code.

View Replies View Related

Hide Your ASP Code

Is this posible? You wrap a javascript function around all of your ASP code, link it externaly, and simply call your function later. I wonder if this could be done?if yes, how about the performance. Does it stay the same?

View Replies View Related

Hide The URL In Address Bar

I want to hide the web URL that gets displayed in the address bar every time we visit the web site, say first time we login and we get the url www.something.com. and next time when we navigate through the web site we also get the web page location and name on the address bar, is there a way to stop this and displaying only the starting web address www.something.com where ever we visit the web page form the current site, and with out using HTML FRAMES is there any login in this so that i can use it with any script language like javascript and vbscript.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved