I would like to embed an include that fetches the top 3 or 5 most recent topics on my message boards and have them show up on my home page or any other page. They would be linked to that topic discussion. If you look at the bottom of SitePoint.com it would be like that include. I'm using the Snitz Forums on my site if that helps. Is there an easy way to do that?
View RepliesOn a forum system, what is the most effective way of determining whether a user has read a topic since the last reply?
View Replies View RelatedI'm working on the ASP forum and have a little problem. I don't know how to check if topics and forums are read or unread. I have an idea. In table topics i add column with name IDS that stores ID numbers of users that read the topic. So when somebody writes a post in the topic, the IDS empties.
When you open the topic your ID is stored in IDS. There is no problem with topics but i don't know how to do that with forums, because there could be more unread topics in one forum. how you guys do this. So how do you check if there are some unread topics in forum and if the topic is unread. With cookies? sessions?
I'm looking for some direction in writing a SELECT statement that will allow me to identify the three most recent records in a table-specifically their unique ID numbers.
Because the records may not be continuous or sequential due to a record being deleted from the table in another part of the app.I can not do something simple like order the statement by DESC and then grab the largest ID.and subtract 1 and 2 from that number to get the three ID's I'm looking for.
I'm using SQL to pull records from our db but my query is returning all results in the db table and I only want the most recent entry. There is a date_time column in the format MMDDYYYY HH:MM:SS and I'm using that to order by then writing only the first line which works, but is very slow since there are a lot of records to go through.
What I'm looking for is a way to only retrieve that most recent record instead of pulling them all, then ordering them. Would I be able to use the MAX function for something like this? Does MAX work with a date_time field?
We log hundreds of SQL injection attempts per day -- the type with
CAST(0x44004500... AS VARCHAR(4000)). It amuses me that the last thing the
attack does is DEALLOCATE its cursor. My SQL Server DBA tells me this makes
no difference. So...
Are these hackers cargo cultists? Or am I missing something?
I have created an asp form which I want to use to retrieve attachment from my site users. I am using Aspupload Component on sever to upload attach file on server at specific location. Although I am able to upload attach file on server. Also I created to retrieve attachment from mail its not working.
Can any one help me out to make form or code to retrieve uploaded file as attachment through mail.
Here is file where user fill his information and attach his CV....