PBase

Hey Guys,

We have just added paging to the comments pages.
If you have 100 or fewer comments, they will all be on one page.

Enjoy!
-Emily

Yey! You guys are on a roll! Keep it up and thanks!

I noticed it as soon as I looked at my comments today.

Great job!

Well done --- great addition
Thank you

Thank You, Emily!

A very useful feature.

ray

Ahhh Nostalgia... I found my very first comment !
When you said 'it is next on my list' I never thought it would show up this soon - thanks

A suggestion: Would you please put the comment navigation bar at the bottom of the screen _in_addition_ to the top ? Most people will scroll down a 100 then have to scroll up again for the next set.

regds
arjun

emily wrote:Hey Guys,

We have just added paging to the comments pages.
If you have 100 or fewer comments, they will all be on one page.

Enjoy!
-Emily

Thanks this is cool.

Hello,

I get these error messages when trying to view my "Comment Management":

select comments failed L144 ORA-01847: day of month must be between 1 and last day of month (DBD ERROR: error possibly near <*> indicator at char 238 in 'SELECT c.code,c.id,c.comment_id,c.owner_id, to_char(c.creation_date,'DD-Mon-YYYY HH24:MI:SS'), c.poster_id, c.guest_name,c.guest_email, c.private_flag,c.display_flag, c.message FROM comments c WHERE owner_id = :p1 AND c.creation_date <= :<*>p2 AND c.creation_date > :p3 ORDER BY c.creation_date DESC ')
14-Jan-2006

or

select comments failed L144 ORA-01847: day of month must be between 1 and last day of month (DBD ERROR: OCIStmtExecute)
14-Jan-2006

Any clue why i can't access the page..?
Tks in advance,
MESS

Hi,

I've also been seeing the following error since this change has been applied and can no longer view any comments...

select comments failed L144 ORA-01847: day of month must be between 1 and last day of month (DBD ERROR: error possibly near <*> indicator at char 238 in 'SELECT c.code,c.id,c.comment_id,c.owner_id, to_char(c.creation_date,'DD-Mon-YYYY HH24:MI:SS'), c.poster_id, c.guest_name,c.guest_email, c.private_flag,c.display_flag, c.message FROM comments c WHERE owner_id = :p1 AND c.creation_date <= :<*>p2 AND c.creation_date > :p3 ORDER BY c.creation_date DESC ')
07-Sep-2005
No comments during this time period.

Regards,
Darren

It's working great here, and so is the forum. Thanks!

You may want to check your "to_date" functions. Not conclusive but just a thought for a place to start...from an Oracle DBA.

sdroberts wrote:You may want to check your "to_date" functions. Not conclusive but just a thought for a place to start...from an Oracle DBA.

Sorry, that was directed to the pBase folks, not something we members can do

As of 9:00 central it seems to be working just fine. I hardly browse through my comments anyway, but it was nice to go back to the first few.

Nice improvement! But...

Instead of just 'newer' and 'older' links, it would be useful to have a link to jump to the oldest comments without having to page through month after month. Direct links to several surrounding pages would be even more convenient.

Bug: When I did go back as far as possible, there was a label for 'oldest comments' in place of the 'older comments' link, but it didn't go anywhere. All my oldest comments (from 2004) were inaccessible until I manually edited the URL.

Hello,

I am also experiencing the inability to access my "comment management" page and receive the following error messages:

select comments failed L144 ORA-01847: day of month must be between 1 and last day of month (DBD ERROR: error possibly near <*> indicator at char 238 in 'SELECT c.code,c.id,c.comment_id,c.owner_id, to_char(c.creation_date,'DD-Mon-YYYY HH24:MI:SS'), c.poster_id, c.guest_name,c.guest_email, c.private_flag,c.display_flag, c.message FROM comments c WHERE owner_id = :p1 AND c.creation_date <= :<*>p2 AND c.creation_date > :p3 ORDER BY c.creation_date DESC ')
23-May-2004
No comments during this time period.

and...

select comments failed L144 ORA-01847: day of month must be between 1 and last day of month (DBD ERROR: OCIStmtExecute)
23-May-2004

Any help would be appreciated.

Thank you,
Bonnie