SQL Server :: Getting Last Value From Database And Check For Posts
Jan 20, 2011
topic - topicid (pk),sub, message (content), catid(fk), createdby, createddate, updatedby, updatedon, viewers( count of views)
post - postid(pk), topicid(fk), post (content), createdby, createddate, updatedby, updatedon.
As i told in my last post, I am designing a forums website. I am not able to design the query to retrieve the topics for a category for example say catid=1. I want to display it in a grid view as done in every forums.
I made some query :
SELECT Topic.Sub, Topic.CreatedBy,COUNT(Topic.viewers) from topic where catid=1
group by Topic.Sub,Topic.CreatedBy
This is for retrieving the topic name from the subject and the createdby giving the topic starter and the total no. of views of that topic.
Now i want to make a query from the post table displaying the last post in the topic and if the post does not exist, i want to display the 1st post from the topic table as the last post done.
View 22 Replies
Similar Messages:
Jun 22, 2010
I have a website where people can send an email to a group of people and then choose to have that letter posted on our website.
The problem has now become that I get so many of them, I can't keep up with doing it manually. What I'd like to do is have it go to a database and then have it automatically update the site. So, one page will have "teasers" with the Author's name, etc and a few lines of the letter and then it links to another page that has the entire letter.
Can anyone tell me if:
a) that's possible
b) how to implement it
Doing it manually has gotten out of control!
View 2 Replies
Feb 6, 2011
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
View 33 Replies
Sep 18, 2010
I have the following code in a stored procedure to retrieve all posts:
[Code]....
However, I am having trouble selecting posts by their tag..
View 9 Replies
Jan 19, 2010
I have a site in development with several web services (ASMX) that post important data to my database. When I navigate to the ASMX file in my browser, I can fill in the form with the parameters and post to the DB. If someone finds the URL to my WS, they can severely alter my database. I want to prevent people from being able to post to my WS publicly. So far, I've thought of two things that may but I'd like to know if there are any other ways:
Check to see if the HTTP Referrer to the WS method is the domain the WS is on Add an additional parameter called Key to all important WS methods and have this be an encrypted "password." Then encrypt my stored password on the WS side and compare if the keys match.
View 3 Replies
Oct 26, 2010
There are 2 tables [forumitems] and [forumitemsblog]
forumitems has the itemid,itemdescription,datecreated,whocreated fields
forumsitemsblog has the itemid,blog
I need to show how many posts are in each item description using the itemid so like count(blog) where itemid=itemid
[Code]....
View 5 Replies
Jul 13, 2010
Before a subscription to a newsletter and the record will be inserted, i'd like to check if the record already exist ina sql-server database. This what i've got as dusfar
adres = TxtEmail.Text
DBConn.Open()
If adres <> "" Then
Try
DBCmd = New SqlCommand("SELECT COUNT(*) FROM TBL_Subscribers WHERE email = @adres)", DBConn)
''Add
DBCmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = adres
DBCmd.ExecuteScalar()
DBAdap = New SqlDataAdapter("SELECT * FROM TBL_Subscribers ORDER BY ActivateDate", DBConn)
DBAdap.Fill(DS)
Catch exp As Exception
Response.Write(exp)
End Try
End if
View 4 Replies
Jan 27, 2010
I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.
I need to know two things:
(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.
(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?
View 2 Replies
Apr 24, 2010
I am using Javascript to alter the innerHTML attribute of a <td> and I need to get that info back in the form submittal. The <td> corrosponds to an <asp:TableCell> on the server-side, where the Text attribute is set to an initial value.
The user cannot enter the value in this particular field. Instead, its value is set by me (via client-side script) based on actions that the user performs. But this field is useless to me if I can't see its value on the server-side as well.
I'd like to avoid using a read-only textbox, because those are difficult to resize dynamically. Can an <asp:Label> be used as form data? Is there any way to achive this without letting the user manually enter the data? Or is there a simpler way to store a string as a variable somewhere and send it back as form-data?
View 2 Replies
Jan 18, 2011
I am designing a forums website. I have prepared two tables - topic and post
topic - topicid (pk),sub, message (content), replies (count of replies), catid(fk), createdby, createddate, updatedby, updatedon, viewers( count of views)
post - postid(pk), topicid(fk), post (content), createdby, createddate, updatedby, updatedon.
retrieving data from both tables in posts page where the 1st post is in the topic table and rest i.e. replies are in the post table.
View 8 Replies
Jul 22, 2010
Clicking the save button on my webform that's on our dev server:
http://DevServer/Page.aspx
Posts back to the same page on my local machine:
http://LocalMachine/Page.aspx
How does the DevServer even know my computer exists? I haven't hardcoded any URLS in my code.
View 2 Replies
Jun 28, 2010
How to validate check box/ check box list in Model?
View 1 Replies
Aug 3, 2010
I have several web sequential pages which will modify a record and its child records in the database, called a "project". Such a project is currently passed between pages using its database ID in the URL parameters.
A project has some information specific to itself, and also consists of one or more Tasks, which each have information specific to itself.
Is it faster (alternatively, more maintainable or more easily understood) to hit the database each time I need to query the same project (and its tasks), or should I query the database once (either once for each page or once for all pages and save to Session) and check the saved object rather than the database?
View 2 Replies
Nov 17, 2010
I'm trying to save and update contacts. I can add new contacts, but when I try to update a contact it will be inserted as a new contact in the database. I can't understand what I'm doing wrong.
[Code]....
View 9 Replies
Jun 18, 2010
I am using Facebook Toolkit. I have appKey and appSecret, but I dont want that visitor need to conenct to facebook. I will use my login/passwork to get my wall posts.
View 1 Replies
Mar 14, 2011
I am doing my final year project and have decided to make a website in asp.net. For that I'll be using Micrsoft Visual Studio 2008. I'm making a Real ESTATE properties website. I want to know how to localize or create new posts in asp.net( like in WORDPRESS) and also when I hit SEARCH it should search for the desired keyword or the searched post.
If post is not possible then it should display pages...
View 1 Replies
Mar 16, 2011
On my site I've got a section which displays the latest tweets from my twitter account. I used Twitterizer to read latest tweets from my account and bind them to a Repeater However, with Twitter's new security, I can't use this as I must use oAuth.
What is the best way of returning tweets from an account?
View 2 Replies
Jul 22, 2010
I have a project in VS 2010 and works great in my dev environment, including a single post that has the def:
[Code]....
But when I publish to another box, I get an error "Could not instantiate file name generator.". This only occurs on the post, all the other ActionResults work fine.
View 2 Replies
Jul 23, 2010
I am working on asp.net. and i want to implement partial posts in my application. my situation is like that i dont want to url changed in address bar and even page should not refreshed at all.
for that i used script manager and update panel but still page refreshes and url also changes.
View 1 Replies
Jan 25, 2011
Need the steps to show my facebook wall posts on my asp.net webiste/
View 3 Replies
Sep 29, 2010
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
View 3 Replies
Aug 16, 2010
I've seen this done a few times in C# but I'm afraid my knowledg doesn't extend into converting this to vb.net. I'm simply looking to examine a checkboxlist and then send the checked values to a database table. It's the actual inserting into the database that i'm not sure what to do with.
Here is some code...
VBNET Code:
Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim ckbox As ListItem
Dim ckboxlist As CheckBoxList
Dim profile_id_int As TextBox
ckboxlist = CType(Me.FormView1.FindControl("Checkboxlist1"), CheckBoxList)
profile_id_int = CType(Me.FormView1.FindControl("staff_payroll_int"), TextBox)
For Each ckbox In ckboxlist.Items
If ckbox.Selected = True Then
'insert record in profile_skill_link table
Try
'Create a New Connection for the Stored Procedure
Dim myConnection As New Data.SqlClient.SqlConnection(Me.SqlDataSource3.ConnectionString)
Dim mysql As String
myConnection.Open()
mysql = "Insert into staff_profile_string_link(staff_profile_int, skill_id_int) values('" + ckboxlist.SelectedItem.Text + "','" + id_int.Text + "';)"
'MsgBox(mysql)
'insert into database here
Catch ex As Exception
Response.Redirect("~/GenericErrorPage.aspx", False)
End Try
End If
Next
End Sub
View 3 Replies
Jan 16, 2011
I have Page which has some database values in It . The current database value is say x then i want an event to be fired if the database value changes I want the Page to check the Database value in every 5 Seconds .
View 2 Replies
Jul 11, 2010
i want to some checking every word which comes from database .
I want to check every character and charactor , so how can i done it ?
View 1 Replies
Sep 13, 2010
I have a forgot password page in which i need to ask from the user his user id to provide him his password from the database and it is working but what to do if anyone enters any wrong user id.
View 6 Replies
