opf3. It supports inheritance, interfaces and allows me to use IList rather than a specific collection type. It supports Linq as well. It pretty much lets me do what I want and does not (IHMO) get in my way.

hth Al

I know that's why I said good catch... when I saw the rownum I was thinking of it as ( SELECT col1, col2,ROW_NUMBER() OVER (PARTITION BY col1_id ORDER BY col1) AS rownum FROM employee ) where rownum < 200 My bad..

hth Al

http://www.techonthenet.com/oracle/triggers/before_insert.php[^]

hth Al

You mean SQLDeveloper- it's an IDE from Oracle (FREE) - Never been a TOAD guy either but it does do explain plans, intellisense, run scripts and even do a diff between schemas.

hth Al

Good catch, try asking tom.... http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html[^]

hth Al

They both have their advantages and disadvantages...

hth Al

[Code] where rownum <=200 [/code] Your where clause references a "rownum" column... Your select statement does not produce a column named "rownum"...

hth Al

run this is SQLDeveloper and set serveroutput on; declare md date default '01-JUL-08'; begin select '01-JUL-08' into md from dual; dbms_output.put_line( md ); end;

hth Al

DevForce from IdeaBlade and Opf3.

hth Al

I think it's actually Plain old CLR objects

hth Al

I use it and it works fine. The one thing I don't like about it is that just like alot of other ORM/Frameworks you have to learn their query language. Their new version will be using Linq To Entities (so it won't be out until that is) so that problem is going away. The biggest thing I like about it over some other ORM tools is that you get a great deal of control over the code generated. Check out the developers guide which goes into a ton of detail and their videos. Their senior architect wrote this CP article http://www.codeproject.com/KB/architecture/ORM_Vietnam.aspx[^] so that should give you an idea of what their about also.

hth Al

Couldon't you used "exec sp_help sproc_name_here"?

hth Al

Hola guys, Fantastic job on the update - haven't seen a 500 error in a while. On the forum if someone is not logged in their last visit displays as 1 January of year 1, maybe it would be better to leave the label blank or just state they aren't logged in. Obviously pretty low importance, just thought I'd let you know.

hth Al

Apache running .Net - is that via Mono?

-Al

I really like the asp.net controls from telerik and their support is great. I've found dev express better for wincontrols. Devexpress also makes two other things I really like - Refactor! and Code Rush.

hth Al

no, I have Response.AddHeader("Content-Disposition", "attachment; filename=" & file.Name) I tried using inline vice attachment - but there was no difference.

-Al

I have an file management tool that has just one problem that I can not figure out. The files are stored in an MsSQL 2005 db and can be retrieved with no problem. The problem comes when the response object renames it. Example if the file is name "file 1.doc" then when the IE response sends it to the client it is renamed "file_1.doc" but FF renames it "File" with no "1" or file extension rendering it useless. Any ideas on what could be causing this and what can be done to stop it?

-Al

3.0 will also give you better web services via WSE 3.0 so there are benefits of 3.0 over 2.0 that exist, just not much that is specific to web development. WSE and WCF are independent of the presentation. As your in development 3.5 / VS 2008 will be coming out and both 2.0/3.0 should be easy to upgrade so I don't think you can go wrong with either. It's just a preference for me to try a use the newest version of whatever on new projects.

hth Al

3.0 doesn't really changes anything from 2.0 for web development. If you are getting ready to begin development and still analyzing you may consider looking at 3.5 with Visual Studio 2008 since it offers things that actually affect web devs. A few examples: -Linq (if you don't know find out, it's amazing.) -javascript debugging -split code/design screen like DreamWeaver (Finally!) -You get to pick the target framework (2.-, 3.0 or 3.5) -design time support for nested master pages If it's a fairly simple app though then 2.0 will more than suffice.

hth Al

When people start complain about performance, pretend to be in deep thought over what could be the cause and then suggest you change the char to bit and be a hero!

hth Al