Messages

51

Developer's Corner / Re: grr SQL and C#

« on: February 27, 2007, 12:54 PM »

maybe I'm mis-reading but:
string scope = null;
            try
            {
                OleDbCommand tableSearch = connection.CreateCommand();
                tableSearch.CommandText = "SELECT * FROM coursework WHERE DateDue BETWEEN '" + System.DateTime.Now.Date.ToString() +  "' AND '" + scope+ "'";//sql command
 

will give you:
"SELECT * FROM coursework WHERE DateDue BETWEEN '2/27/2007' AND ''"

and that would give the error you describe.  Perhaps you'l wnat to put in a parameter:

                tableSearch.CommandText = "SELECT * FROM coursework WHERE DateDue BETWEEN getdate() AND @scope ";//sql command

and then give the parameter in code the same name. 

Also FYI:  "SELECT *" isn't a good practice, it's easy, but can cause problems in the future.

52

Post New Requests Here / Re: IDEA: 3D Stereo Windows

« on: February 01, 2007, 01:52 PM »

Right, drawing & rendering to Direct3D is one way.  I was suggesting a simpler method that would simply take each open window and calculate a left and right offset based on the windows depth/Z order.  (You know how when you open lots of windows in ... "Windows", they start to pile on each other right?), and -then- generating either a red/blue/color composite view of the entire screen or two seperate screens.

So I was hoping that this simplified method would be... "snack-able", but, as has been said below it probably goes beyond that.

53

Post New Requests Here / Re: IDEA: 3D Stereo Windows

« on: February 01, 2007, 10:19 AM »

   I guess I *am* that much of a nerd! ,

Still, with 3D monitors coming soon (for example "http://www.sharpsystems.com/products/3d/") I'm thinking this isn't too unrealistic,... or perhaps this is too much for a coding snack?

54

Post New Requests Here / IDEA: 3D Stereo Windows

« on: January 29, 2007, 11:48 AM »

It would be cool (maybe useful?) if there was an app that would create two screens from the Windows UI (one for the right eye and one for the left) using the window depth (z order) so that it would be steroscopic when preceieved, with real depth-preception depth. 

It would be cool if the output from  this app could be either a Blue/Red transparet overlay on one monitor (to use Blue/Red 3d glasses on) or output to two seperate monitors (VR glasses?).  (do a search in fickr for Stereophotography, most of these you have to cross your eyes on, but you get the concept.)  Windows has depth information about it's windows allready so the app should have all the information it needs.

I'm thinking the mouse would not sink down when travelling across "lower" windows.

Am I just a nerd or what?  Anyone else think this would be cool? 

55

General Software Discussion / Re: program to visually design a database?

« on: January 04, 2007, 10:16 AM »

I think FreeMind is cross platform compatible (I think it uses the Java VM), so that should run on the big L.

56

General Software Discussion / Re: CustomBar

« on: December 18, 2006, 10:21 AM »

Yay!

57

General Software Discussion / Re: CustomBar

« on: December 15, 2006, 05:11 PM »

Actually, I use the "WallMaster" wallpaper manager and I'm pretty sure it has a feature to hide the desktop icons, even when not using XP.

58

General Software Discussion / Re: CustomBar

« on: December 15, 2006, 01:30 PM »

Glad to help!

I know people aways say how much they hate MS, but hey, I'll say it again (See my post about icon overlay for recent files): 

Sometimes you have to give 'em credit!  Windows is pretty good software! 

59

General Software Discussion / Re: CustomBar

« on: December 15, 2006, 01:12 PM »

Yeah, see below \/ \/ \/

Did it stick to the side of the screen?  What options are listed when you right click in the toolbar (not an icon on it)?

60

General Software Discussion / Re: CustomBar

« on: December 15, 2006, 01:00 PM »

Sorry to confuse with the "hidden" comment.  I forgot to say that I hide my the icons on my desktop so i can enjoy my wallpaper!

If the toolbar you add is the "Desktop" then icons for -every item- will show up in the toolbar.  It's like having an auto-hide copy of your desktop!  It is so useful!  especially considering it's already built in to Windows! 

Basically the Toolbar feature lets you point to a folder (in this case I suggested the "Desktop Folder"), so you could have "My Documents" as an auto-hide tool bar too!

Would someone tell me if my steps worked?

61

General Software Discussion / Re: CustomBar

« on: December 15, 2006, 12:40 PM »

Well, I say XP, because that's what I use, but the steps are easy enough to try, you might want to see if 2K will do it   

62

General Software Discussion / Re: CustomBar

« on: December 15, 2006, 12:23 PM »

(I don't know if this has what you need but just as an FYI....  )

Without installing any other software you can create an auto-hidining launch bar in Windows XP. 
1.  Right click on the task bar and go to Toolbars and select Desktop (if it isn't there pick it from New Toolbar).  This will add the desktop to your task bar. 

2.  Now take the "handle" (the little vertical bump) of this toolbar and drag it to the far left/right/top of the screen (away from the taskbar).  This should "attach" the new toolbar on the side of the screen. 

3.  You can then select Auto-Hide (and other task bar type settings) for this tool bar (via properties) independant of the Windows Task bar.  Personally I take off the Text and Title and switch the icons to smaller.

Tell me if this doesn't work for you, because I might have forgot a step.  I have an auto-hiding toolbar with the "Desktop" in it (with my desktop icons hidden) and it is invalulable to me because I don't have to minimize anything to open an app.

Yeah, you shouldn't need any third party stuff for this, it's quite a nice feature and I use it everyday.

63

Living Room / Re: Real code vs. Code in the movies

« on: December 07, 2006, 05:49 PM »

I love how on CSI (I know there's lots of stuff to rant about on this show) every single database on whole entire the planet is connected into one easly queried app!  Forget HIPAA, privacy, data-sharing legislation and who knows what other legal and technological roadblocks exist!

I love to see a few episodes that say "sorry boss, we don't have access to that database", or "okay boss I should be able get clearance for that data in 3 months"

Not to mention all of their hugeo flat panel screens are constantly graphing and charing 3d images and spyrographic animations!  obviously they parallel processing fingerprints or something, which of course is graphically intensive!

There's my rant

64

General Software Discussion / Re: General brainstorming for Note-taking software

« on: December 04, 2006, 03:42 PM »

IMHO Freemind is the best note taking/thought organizing software bar-none.  It's free too!

65

General Software Discussion / Re: Wanted Photo Slideshow on DVD (1000s of photos)

« on: November 28, 2006, 10:27 AM »

Do you think the limit is 99 folders in the root or 99 folders limit including nested folders?  Let's say it branched out, like in my case, in years like this:

2001
   \____Jan
   \____Feb
   \____etc.
2002
   \____Jan
   \____Feb
   \____etc.

So this would be 8 folders, but only 2 in the root and 12 in each year folder.  (okay I know maybe I'm a bit over-organized!  , obsesive compulsive organizer perhaps?). 

I guess I'm wondering if it's 99 total folders or could I have 99 folders each with sub 99 folders? 9801 folders?

Thanks for bearing with my weird questions.

66

General Software Discussion / Re: Wanted Photo Slideshow on DVD (1000s of photos)

« on: November 28, 2006, 10:00 AM »

Thanks for the suggestions everyone, I'm gonna try the "trail" of ProShow Gold.  Maybe this will be Xmas!

Also, lanux128, when it says "Create a new silde show" for shows with more than 99 photos, do you think it means that only one DVD can have 99 photos or folders?

67

General Software Discussion / Wanted Photo Slideshow on DVD (1000s of photos)

« on: November 27, 2006, 12:15 PM »

I have 1000s of photo's I'd like to make "browse-able" on a standard DVD player.  My photo's (mostly JPGs) are organized in folders by year and then by upload date.

I've tried using Roxio DVD maker but for some reason after adding two or three folders worth it runs out of space (4GB max?).  I suspect that it is making Full Motion video out of my still photo's (60 fps? 2 seconds each photo + transition ?)

I'd like to be able to pick a year/folder and then select play and see all of the photo's from that folder and child folders.

Heard of anything like this?

68

Post New Requests Here / Re: IDEA: Icon/Color overlay based on "last modified" date

« on: May 23, 2006, 03:35 PM »

I do want to say that I found somewhat of a workaround that kind-of answers this coding request.
(I did get a nice email from the Xentient folks and they said they'd consider the feature in the future.)

Here's how it goes:
Switch the explore view to Details and sort by Date Modified Descending.  (This is what I always used to use) and then if you use View-Arrange Icons by (Date modified should already be selected) and then Pick "Show in Groups" it works rather nicely.  It shows the files modified "today", "yesterday", "last week" etc in descending order by "details" view.  Which is rather nice! 

So in the end, I need to thank good ol' Microsoft for thinking of this!  C'mon, you have to admit they do build fairly good software sometimes!

69

Post New Requests Here / Re: IDEA: Icon/Color overlay based on "last modified" date

« on: May 17, 2006, 08:57 AM »

The thumbnails tool in windows only works when you have "thumbnails" selected as the view, this tool below shows the picture for the icon in any view.

But alas, the color labeling is only for a specific file or type of file, it's not customizable by date modified.

Maybe some day I'll have time to learn how to write shell extensions!

70

Post New Requests Here / Re: IDEA: Icon/Color overlay based on "last modified" date

« on: May 16, 2006, 02:35 PM »

Thanks for pointing that one out.  I'll have to check it out... when I have 30 "optimal" days for the trial!
I'll have to see if it can determine the color automatically!

71

Post New Requests Here / Re: IDEA: Icon/Color overlay based on "last modified" date

« on: May 15, 2006, 09:39 AM »

Are we two the only ones that think this would be helpful?  Do you think this idea is too big for a coding snack?   

(typo fix)

72

Post New Requests Here / IDEA: Icon/Color overlay based on "last modified" date

« on: May 01, 2006, 12:24 PM »

Idea:

I think it would be cool to have a Shell Icon Overlay that overlaid icons based on when they were last modified.  For example,  Files modifed in the last 7 days would have a "red" icon overlay, and files modified in the last 30 days would have an "orange" icon overlay. 

This would be helpful because it would point out recent docs without having to change to "details" view in explorer.  The icon files used for the overlay could use the alpha channel to look transparent, thus preserving the base icon image.  Ideally the icon overlays and "ages" of files would be configurable. 

I suspect this could be done by implementing your own handler from IShellIconOverlayIdentifier (see http://msdn.microsof...noverlayhandlers.asp)
But I'm not that advanced in my skills to do it.

Lemme know if you think this would be cool.

JF

73

Post New Requests Here / Coming Soon: Rename images with Date Picture Taken (by folder)

« on: February 14, 2006, 11:17 AM »

FYI: 
I wrote a little app that renames images with Date Picture Taken (by folder), because I couldn't find anything like it on the web already.   I'll be uploading it soon.  I also added "Use Date Modified" as an option in case the photo's don't have the Date Picture Taken property.  (When used in the default mode it only renames files with the Date Picture Taken property.)

thefritz_j

74

Post New Requests Here / Re: IDEA: Copying files, timestamp existing files and copy new ones in

« on: October 07, 2005, 09:27 AM »

Yeah, numbers or a timestamp would be great.  So... it sounds like there's a need.  Is it likely to be included in the ContextMenu commander soon? 

75

Post New Requests Here / IDEA: Copying files, timestamp existing files and copy new ones in

« on: October 05, 2005, 02:46 PM »

A cool shell extension that would really help me out would be when you copy files to a different folder if the files already exist rename the existing file with a time stamp and then copy the new files in.

Example:

Directory of C:\files

C:\files\wow.txt

User copy and pastes (or drags and drops) a "wow.txt" file from another path/folder.  (H:\nice\wow.txt).
In addition to the "Replace existing file" a second option is shown: "Timestamp old file and keep new file".

If the user selects the second here is the directory of C:\files

C:\files\wow.txt (new)
C:\files\wow-20041231-0823.txt (old)

This would help me so much!