Hi!
I want to show intro of the newest news on my startpage. But I only would like to show the subject and part of the message and if you klick on the subject you can se the whole news...how can I do that?
I have an mySQL database with the news.
I havn't found any thread with this topic...
Zäta
hi everyone, trying to make updates to a news area on a website through an update form.
have a table (news) with one row (news).
the record set displays correctly in my update form in a browser. after changing content and clicking update however, error displayed:
You have an error in your SQL syntax near 'WHERE news ='contents for news area'' at line 1
corresponding code:
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "newsForm")) {
$updateSQL = sprintf("UPDATE news WHERE news =%s",
GetSQLValueString($_POST['news'], "text"));
have tried multiple variations of the sql command. my question is do i have to add a row such as news_id and reference this as a primary key in order to use the UPDATE command? I have tried to do this but perhaps I should keep trying with that rather than with a single-row database. . .
it's just unclear where i should be looking. thanks anyone for your advice.
chris
I am being moved to a group whose applications use SQL server quite extensively (apparently). I have never used SQL server, however I have (at school) taken an SQL course in DB2. I`m interested in seeing if anyone has any recommendations for a good book I could read at an introduction level on SQL server. I`m not sure what version they`re using but I would assume it`s fairly current. Besides, I`m not looking for version-specific information. Can anyone help me out with some references? Thank you in advance.
View 1 Replies View RelatedI installed what I thought was the trial version for SQL 2005 server. How do I check how much time is remaining on my trial, or if I'm even running a trial version at all?
Thanks
I am currently reading the Intro to Oracle 9i: SQL course and plan on taking the 1z0-007 exam. I would like to practice with some of the questions in the back of the guide, but don't have the scripts to build the tables. I could type them out by hand, but thought I would first check here to see if anyone has, or knows where I can find, the scripts to build these tables so I can save myself some time.
Thanks
Shava
Hi guys,
From my DTS is like this:
DTSDestination("Tex") = replace(DTSSource("Tex"),Chr(13) & Chr(10), "<br>")
And now I try unsuccesfully this one on a Derived Column task
REPLACE([Tex], Chr(13), " " )
TIA
hi how i can make news bar related with DB ?
Hi,
I'm building a straightforward-ish news site. Currently, the story details (e.g. headline, description, author, date) are stored in a SQL DB. The news is categorised and the category details are also stored in an SQL table.
However - what is the best way to store the actual news article?
At the moment, when the user enters a story, they input the details and article text. The details are saved in the DB and the text is saved as an XML file with filename corresponding to the article DB primary key. When the story is "read" the app pulls the details from the DB and loads up the appropriate XML file from disk.
For various reasons, I need to keep the article stored as XML, either in a file or in the DB. The DB provides for faster sorting and retrieval, and I don't want to store large amounts of data (i.e. the article itself) in the DB if avoidable.
I guess there are a few ways to do it -
1. Store details in DB and article as XML file.2. Store details and article in same DB table3. Store details in one DB table and articles in another
I would imagine that 3 would be the best, but would there be a performance hit? What is the maximum size of field (i.e. article size) I can have in a table?
Cheers
Graham Wilson.
so last week i finally downloaded and installed SQL Server 2005, and along with that, i downloaded Studio Express (i had previoulsy been using MSDE with WinSQL by Synametrics)
anyhow, today i got an alert from google (you guys use those, right?) that there's a free copy of something called SQL Prompt available from Red Gate
i tried it, and i like it!!
see http://builder.com.com/5100-6388_14-6085249.html?part=rss&subj=bldr
I have read an article about Reporting Services that was rather critical regarding a number of topics. But, this article was from 2005 and I assume that there have been some improvements in Reporting Services since then. Or?
If so, are there any good places where you can find the news? I haven€™t been able to find a good site for news in, in this case, Reporting Services.
Hello all,
I have been reading these forums for a while but I am now a new member and relatively new to SQL (< 1 year exp).
In a project that I am currently working on I would like to include information related to current market news. An example would be news updates for certain companies that are generated from the Wall Street Journal or MarketWatch. The application would only be used internally and information would only be shared within the organization.
What I'd like to find out is:
Has anyone else worked with or developed something like this? If so, can you please share some insight.Would I need to purchase a Corproate License to use this information or would a personal account that can access the information be enough?What would be the best way to feed the database with this information? E-mails to the server, SSIS, etc.
Thank you for your help and I look forward to learning from you insight and experience.
Hello..
I want to upgrade my website to asp.net 2.0 and I want to add a Daily news to website.and 10 to 15 news will be added daily , so after a year we have almost 4000 entry in the database.
For designing this DB what is your advice on how to store news in database?Is it better to create same tables for each year ? for exampletblNews_2005tblNews_2006
Or just to make one table and have all news stored in that ? its gonna be huge after years , isnt that make any problems?
ThanksRegards.