A thread for boring computer questions.

I want to enter in names for each item in the table I'm working on. A lot of them start with articles, and I want them to be sorted by name, but I want them to be presented without putting the articles at the end of each name. How can I do this? Is there some sort of function that I can add to the varchar type to not count leading articles when sorting, but still present them when in a list?

Thanks!

can iChat do group chats on rendezvous?

Thanks!

Here's the deal: the company I work for often produces PowerPoint presentations for clients but we're now getting to the stage where our clients know their way around PowerPoint and we need to take it to the next level. I'm suggesting we go down the DVD route and take the movie clips, slides and soundtracks, and edit them in FCP and then burn a DVD which the presenter can navigate using the chapters.

What format does FCP/DVDSP use for editing the video? When we use video crews, normally we end up with a video tape that is turned into an MPEG and embedded into the .ppt - what format(s) can I get from the crew that I can then use in FCP/DVDSP? If the crew uses a purely analogue tape process, how can I get this into FCP in high enough quality for it to look like proper footage in the result?

Most of our clients use PowerPoint and some of the final product will need to include PowerPoint-like functionality. I've heard that Keynote can read PC .ppt files and export a movie file. I'm thinking that there must be ways of manipulating the DVD controls so that a series of DVD chapters can be navigated in the same click-run-click-run way. Can anyone verify this?

Keynote will do what you say but interactivity will be removed, but you can put that back in in DVDSP if you need it. The best thing to do would be to encode each slide's animations as a movie and then make each slide a 'chapter' on the DVD then people can jump around slides using the forward and back buttons on the DVD player, or access them through a menu or other controls you build into the DVD with DVDSP.

I guess what I'll do with Keynote is to import the client's .ppt, tidy it up (Keynote's transitions look way nicer than PowerPoint's) and then export as a straight movie. I can then edit in video segments with FCP and then put in chapter markers/scripts with DVDSP. In film DVD bonus features, you sometimes get galleries of images where you have to press a button to advance to the next image - I'm guessing that I can set up something similar in DVDSP to mimic the slideshow of PowerPoint.

ok i think i figured it out: an 80g disk is actually 80 billion bytes. but a gigabyte is actually 1,048,576 bytes. so, 80,000,000,000 / 1,048,576 = 76.293 GB as seen by the computer. ITS A FUCKING SCAM!!

for one thing, your orig math is goofy. you are "missing" 3.14, not 4. we already turned that down by one, so now it's 2.14. consider that your estimations of 3 and 4 gig respectively might be both low. now we could be down to 1 gig.

um ok i see yeh ron yr right i thk. hm. time fr new HD space.

Check again. I bet the amount your computer's missing, is in fact, 3.141592653589793238462643383279502884197169399375105820974944592307816406286208998628034825342117067982148086513282306647093844609550582231725359408128481117450284102701938521105559644622948954930381964428810975665933446128475648233786783165271201909145648566923460348610454326648213393607260249141273724587006606315588174881520920962829254091715364367892590360011330530548820466521384146951941511609433057270365759591953092186117381932611793105118548074462379962749567351885752724 8912279381830119491298336733624406566430GB.

i.e. it's gone maths mad.

Erm.

Upgrading to XP may not solve the problem, but you can usually upgrade to XP without wiping your drive or your files. If you decide to do it, though, it's always prudent to back up anything you don't want to lose, especially items in the "My Documents" folder or on your desktop.

w. media player but seemingly no realplayer.

why am i so dense?

But yes, that would work. It was my initial suggestion, but I decided that changing preferences would (ideally) be the better route to go.

My computer is an AMD running Windows 98, and I have cable internet through Comcast. Plenty of memory and processor speed. Any ideas? This scares me, as my home computer connection is crucial to my work/livelihood. It's been happening frequently (and I just bought this computer). Thanks for any help/ideas.