| Submit your comments on this article |
| Another minor change... |
| 2003-07-25 |
| PD e-mailed me, suggesting that when we switch to off-page comments (currently set at 150 combined articles and comments) I include the latest comment time and who dunnit. It takes another call to the database, but it seems to run okay. Let me know if there are any problems (see yesterday's Rantburg to see how it works — or wait until this afternoon...) |
| Posted by:Fred Pruitt |
| #14 I'm in - Thx for the Amazon link for us PayPal-challenged Rantburgers! |
| Posted by: PD 2003-7-25 11:56:45 PM |
| #13 Thank you. It helps! |
| Posted by: Fred 2003-7-25 11:22:00 PM |
| #12 I just deposited 25 clams in the tip jar. Hope that helps with expenses. |
| Posted by: Zhang Fei 2003-7-25 8:42:01 PM |
| #11 And I thank you for it. I now have a new hard drive and more memory, going into the swap machine at this moment. Not sure there's room to put the info up top... Unless I use tiny text... |
| Posted by: Fred 2003-7-25 8:08:30 PM |
| #10 I like it. Now I can see when Al-Aska Paul has taken time off from designing hydraulics to post a response - heh heh. BTW Fred - I tipped $25 earlier this week - I encourage the rest of you 'burgers to give early and often ;-) Frank |
| Posted by: Frank G 2003-7-25 7:33:36 PM |
| #9 The changes are great. Is it possible to put the name and time of the last updated comment up top beside each article heading? |
| Posted by: Zhang Fei 2003-7-25 6:07:16 PM |
| #8 SQL gurus do it with joins |
| Posted by: mojo 2003-7-25 4:13:56 PM |
| #7 Your wish = my command... |
| Posted by: Fred 2003-7-25 3:38:59 PM |
| #6 I can see it now, BTW, Fred, it looks SCSI - to use the Jobs pronunciation. You da man! And if you'll hook up with Amazon, I'll be very happy to hit the tip jar - with a hat tip to seafarious! PayPal doesn't work for me, as is the case with many thousands of others, and they can't figure it out. |
| Posted by: PD 2003-7-25 2:18:52 PM |
| #5 Time to hit the tip jar, ladies and gents... |
| Posted by: seafarious 2003-7-25 12:46:40 PM |
| #4 When populating this page, I expect you do return one set for the header (article titles), one set for the categories on the right-hand margin (Europe, Fifth Column, etc.), and then one for the articles and comments, so it would save some time in general, although it may not be applicable to the change you described. Sounds like the change you're describing is an additional join? |
| Posted by: Dar 2003-7-25 12:43:36 PM |
| #3 I've been thinking about migrating to SQL Server, but when I put the 'burg on our own web server I got SQL Slammed within 24 hours. I'm building a swap machine now, with more protection than we had when we first went up -- now it's a matter of not wating to rewrite an awful lot of SQL. |
| Posted by: Fred 2003-7-25 11:55:02 AM |
| #2 MySQL doesn't support stored procedures. Dammit. |
| Posted by: Fred 2003-7-25 11:51:41 AM |
| #1 Are you doing this through a stored proc? You can return multiple result sets and avoid hitting the database with multiple calls, depending on what tech you're using. E.g. CREATE PROCEDURE [spRantburg_Populate] AS Select Title, Body from tblArticles Select Count(*), TimeStamp from tblComments where blah, blah Then in code: Set adoRecordset = adoRecordSet.NextRecordset |
| Posted by: Dar 2003-7-25 11:40:55 AM |