Very well put Marc. I guess I was trying to make the same points in my long winded post. The key I see is that IT, accounting, and other departments need to work together as a whole. If the company is lucky enough to have someone that can cross multiple areas, they need to realize the value of that person. IT does not need to automatically assume that accountants don't know enough to write their own code and mini applications and accountants need to realize that there are some IT individuals that understand their data enough to give them what they need. Unfortunately most of the time, these two groups are more worried about who is stepping on their "area" of the business. As I previously stated, accountants should not be forced to learn TSQL or VBA if they do not want to. While I think it is wise to learn, the opportunity should be taken to realize this application is obviously needed and if resources permit, IT should volunteer to take the reins and develop it properly if not done so.

Jeremy Oldham

As an accountant who also learned how to write TSQL, PL/SQL, java, VBA, VB.Net, C#, etc. etc., I can only say that it helps me in my job tremendously to know both sides of the coin. IMHO no one should be forced to learn something they don't want to. Accountants were hired to be accountants, IT guys were hired to take care of the technical side. Where I work, we have an IT department that only wants to work on the large stuff. Several times in the past we have had the occasion where we requested a report, only to be told it couldn't be done. 30 minutes later, I had written the report. When we re-submitted the request from a higher level, IT said they could write the report, it would take three months and they didn't want anything I had written. IMHO this is not the way things should work. I realize that I may not be the best programmer, TSQL writer in the world and would love to have the IT department look at every single line of code I write to ensure I am not putting anything on the server in harm. I say all this to say, it should not hurt to have accountants that can write some code. You as the DBA should however be able to look at server loads and if problems exist, have a good enough relationship with said accountants that you can review what they have written and make improvements, while using that time to explain why what you improved is better. I promise that an accountant that has taken the time to learn some TSQL/VBA code will appreciate the training. You should use the opportunity you have now to volunteer to take over the mini-application if the FD does not really want to handle it. It is obvious that the written application is important to the accounting department and he may feel as if they have no choice but to learn VBA/TSQL. By being open to helping out, you are gaining another ally in the corporation, one who may control the purse strings. Sorry for the long post. :)

Jeremy Oldham

The incident happened here in Oklahoma where I live. The former Mayor of Oklahoma City Kirk Humphrey stated in the local news that this is a kid 98% of America would have as their son. The "pipe bomb" was a CO2 cartridge with gun powder. To me this is a tougher issue to judge than just reading the surface. While I ask what kind of idiot could he be after 9/11 to not check all his bags before going to the airport, the "pipe bomb" had no shrapnel or detonator's with it. I do think you are right David in that some of it probably had to do with his relationship to the former mayor, but I also think the circumstances played in his favor as well. Part of me says throw him in jail for a while for being an idiot and the other part says, maybe he just made a mistake. The part I don't buy is that the former mayor says he is a good kid and no harm, no foul. I say that the terrorist play the part of the good citizen right before they kill those around them. Jeremy Oldham

I can see some stuff you shouldn't be able to see as well. Mainly the layout of an Air Force Base, complete with aiplanes on the runway. :wtf: Jeremy Oldham

There was an ABC news video on the web about two weeks ago about him. His father is in jail for 3 years for abusing his wife. They basically said this kid was not allowed to play with any friends. He was not allowed to eat anything except salad and the "drinks" his father made for him. One bodybuilding family agreed to help promote him and when the began being concerned with his well being, the father told them if they did anything to ruin their source of income he would kill them. The family told one story where they were in New York for a promotion. After all was over, they went out to have some New York pizza and while the father had pizza, "Little Hercules" was forced to eat salad. Now the kid has said that hus father was abusive to both him and his mother. He does however enjoy working out still. Jeremy Oldham

Anders, When you click the update button, the datagrid is probably databinding in the page load event. Therefor, the changed value is being changed back to the original value when it databinds. If this is the case, you need to test for Page.IsPostback and if it is not a postback (meaning first page load instead of a postback), then you bind the datagrid. I hope I have made sense. If not, let me know and I can explain further. I am typing with one hand, so hopefully, I do not have too many typos. Jeremy Oldham

What database are you using? If you are using MS SQL Server then you would have the following: SELECT firstname + ' ' + Lastname as Name, Year(Birthday) as Year, Email FROM CardTable ORDER BY Cardnumber Asc Jeremy Oldham

I won't go in to the optimization discussion, but another way to do the same query without the case statements in the where clause is as follows: CREATE PROCEDURE GetProducts ( @Name varchar(20), @Status int = NULL, @FromTime datetime = NULL, @ToTime datetime = NULL) AS BEGIN SELECT [Name], [Status], [RegistrationTime] FROM [Products] WHERE [Name]=IsNull(@Name, [Name]) AND [Status]=IsNull(@Status, [Status]) AND [RegistrationTime]>=IsNull(@FromTimestamp, [RegistrationTime]) AND [RegistrationTime]<=IsNull(@ToTimestamp, [RegistrationTime]) ORDER BY [RegistrationTime] END; Hope this helps. Jeremy Oldham

Not sure how cross browser friendly they are but you could try the following: Free Text Box[^] Cute Editor[^] Rich Text Box[^] Jeremy Oldham

Hey Terry. Congratulations on loosing some of the pounds. I am in the same boat as well. My first year of college, I played soccer everyday and weight a slim 150 pounds. 13 years later and I was up to 300 pounds. My father weighed 380 pounds and had the stomach surgery last November. He now weighs 250 and is looking great. Long story short, his weight loss got me motivated to do something about my own weight. I started about three months ago and I now weigh 263 as of this morning. Maybe we could kepp each other motivated on lossing the weight. I too would like to get below 200. Good luck! Jeremy Oldham

I have found SQL Team[^] a valuable resource, especially when you start to get into more complex SQL statements. Hope this helps! Jeremy Oldham

Check out Forms Creator [^] available at www.snowcovered.com[^]. I think it will do what you are wanting to. Jeremy Oldham

A couple of things to check. It appears that you are trying to assign a int, float or char datatype to the "Checked" value of the checkbox. This should be a boolean datatype. In order to properly do this, you either need to add a helper function or add a new column to the query for HasRoom. If you use a helper function, you will want to pass the roomnumber value to it and if it is not null, return true. Function HasRoom(roomnumber as int) If roomnumber = '' then return false else return True End Function Then you would call this from the datagrid. Checked=<%# HasRoom(Databinder.Eval(container.dataitem, "roomnumber)) %> Hope this helps. Jeremy Oldham

Why not have a Configuration table that specifies the attributes for the configuration. Then put a Configuration ID in the Product or ProductDetails table, which ever one makes more sense to you, to link the configuration to the productId. Jeremy Oldham

Sure you can hide the header. In your code-behind, add the following to the Datagrid's ItemDataBound Event:

     If e.Item.ItemType = ListItemType.Header then
          e.Item.Visible = False
     End If

Hope this helps. Jeremy Oldham

Ensure that the page is set for Unicode encoding. I had trouble with this in SQL Server. I could input Russian characters through Query Analyzer and they would store correctly in the database, but when I entered the information through my web form, nothing but question marks. I change the page encoding to UTF-8 and all was well. Jeremy Oldham

stefan, Take a look at the following article. http://www.sqlteam.com/item.asp?ItemID=256[^] Jeremy Oldham

Your Welcome. Also, NBC News[^] Jeremy Oldham

Reuters http://www.reuters.com/newsArticle.jhtml;jsessionid=CJK3HZAM200ZMCRBAE0CFFA?type=topNews&storyID=2521303[^] Jeremy Oldham

pradipta wrote: the query u have written only to retrive those DOB which will lie within this week.But DOB means only the month and day will be same whatever may be the year... Sorry about that. Who knows where my mind has be drifting. :-O Try the following: SELECT t.myName, cast(cast(Month(getdate()) as varchar(2)) + '/' + cast(Day(getdate())as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime), cast(cast(Month(t.DOB)as varchar(2)) + '/' + cast(Day(t.DOB)as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime) FROM DOB AS t WHERE datediff(d, cast(cast(Month(getdate()) as varchar(2)) + '/' + cast(Day(getdate())as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime), cast(cast(Month(t.DOB)as varchar(2)) + '/' + cast(Day(t.DOB)as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime)) Between 0 and 6 Let me know for sure that this works properly. Jeremy Oldham