Hey, Good advice Madhivanan... I simply... ORDER BY BlogID, Date Thank you, a8le http://www.noteful.com - read and share anonymous online...
Hi Frank, Back now, my suppossive fix, is working out. Although the BlogID are all grouped together, the comments are not being ordered by the date...
Hey,<br /><br />After explaining how the resultset should look, I woke up and realized all I had to do was "ORDER BY ForeignKeyID". I was trying to...
Hi sorry, Here's more detail... The stored proc brings up a list of comments for a certain BLOG. The foreign key is a blogID. So as of right now,...
Hi all, How do we SELECT, FROM, WHERE, and GROUP BY all at once? The store proc below works, but I want to "group by" ForeignKeyID? CREATE...
i made the suggestted change. again, thank you for all the help and advice. -a8le http://www.noteful.com - read and share anonymous online secrets...
Got it working using...<br /><br /><pre id="code"><font face="courier" size="2" id="code"><br />CREATE PROCEDURE dbo.Blog_Comments_Add<br />@BlogID...
someone please... ? http://www.noteful.com - read and share anonymous online secrets and confessions.
*bump* http://www.noteful.com - read and share anonymous online secrets and confessions.
Hi all, Thank you for all the good ideas. The website is programmed using ASP.net v1.1. And before coming here I tried several times to make the...
Hi all, Is there a simple way using SQL to prevent redundant posts? I have a script that accepts post from users, it works and all. But if the...
Hi LuisMartin, can you please spell it out more... I don't understand your explaination. -a8le http://www.noteful.com - read and share anonymous...
hi all, how do we rename server when we are registering them... in MSSQL Enterprise Manager? thanks in advance, a8le http://www.noteful.com -...
it is, its just kinda hard to get in touch with them, and i can't do it on my own because of permissions issues. http://www.noteful.com - read and...
hi all, i have recently moved my website from one hosting company to another. everything (files and db) has finally be transferred over to the new...
Hi Madhivanan, It seems the best option for my situation is to upload the files to my db, and after playing around with it, VS.net 2k3 is giving me...
hi all, i am working on giving my users the ability to upload images to my site, and after some research i learned that i have the choice of storing...
hi all, my hosting package doesn't include full text cataloging... is there a way to have/get full text search capabilities without having it?...
Hi Adriaan, <br /><br />Well, that didn't work either, but hey, thanks again..... I have decided to take another route to getting the same...
Hi Adriaan, Thank You, for the reply and help. I really appreciate it. After, changing that part, all the blogs (with or without comments) show...
Separate names with a comma.
