Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cesaru

  1. cesaru

    susbtracting time and counting minutes elapsed

    thanks.. I think I got it. (a.end_dtim-a.start_dtim)::interval minute(9) to minute::char(10)::int) As elapsed_time hope it helps someone.
  2. cesaru

    susbtracting time and counting minutes elapsed

    Hello, I'm trying to get a total of how many minutes an assigment too to be completed userid carlosh Assignment 12345 start_dtim 2010-05-23 16:02:17 end_dtim 2010-05-23 16:27:53 userid emilyc Assignment 12346 start_dtim 2010-05-23...
  3. cesaru

    Sql to insert multiple records how to

    HI, I'm trying to insert multiple records in one statemtn to my my informix db. I tried the following insert to [table] (col1,col2,col3) values ('value1','name1'),('value2','name2') but it dit nod work I also tried union insert to [table] (col1,col2,col3) select ('value1','name1') union...
  4. cesaru

    CASE And GROUP BY problem

    This is great! Hoewever, if i change the criteria in the first group, the query seems to take very long. SELECT DISTINCT A.item,B.StateName FROM table1 A,table2 B WHERE A.staterecord=B.staterecord and a.salesgroup = 1 AND (SELECT COUNT(DISTINCT StateName) FROM table1 X,table2 Y WHERE...
  5. cesaru

    CASE And GROUP BY problem

    oh you are good! Thank you very much one last question if you don't mind. I've been searching for an answer about this for a while. in sql server I can do a subquery in the FROM... select item from (select * from ....) I don't think to be able to do this informix. my workaround was to do...
  6. cesaru

    CASE And GROUP BY problem

    I'm trying to use CASE in the group by clause and I'm having a bit of a problem. for example SELECT CASE WHEN Order_Date IS NULL THEN 'Unknown' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 0 AND 6 THEN 'Recent' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 6 AND 18 THEN...
  7. cesaru

    same table query...

    Thanks! it worked like a charm...
  8. cesaru

    same table query...

    Hi, I'm trying to compare 2 sets of data from the same table. for example status Recd# Date COM 1000 08/20/2008 COM 1001 08/20/2008 AVL 1002 08/20/2008 AVL 1000 08/20/2008 AVL 1001 08/20/2008 The result i'm looking for is records with AVL status that are not in COM status...
  9. cesaru

    Advanced GridView question/issue

    Yes you can...have them enable in the rowdatabound. How many columns with checkboxes do you have? You can set up teh gridivew to autogenerate columns but also add the template column with a checkbox on it. on rowdatabound you can hide\unhide the column if you want. you can set the...
  10. cesaru

    trying to create login with sql table users

    I'm starting too but I think taht the login control works only with the sqlserver security database. "I think" that if you are making you own login method....
  11. cesaru

    Advanced GridView question/issue

    What you want is to be able to edit all rows and update at once?
  12. cesaru

    Best practice in creating an update form web page?

    What I have done this by using the example in this link. http://aspadvice.com/blogs/azamsharp/archive/2006/12/18/GridView-Update-All-Rows-At-Once.aspx it worked well and very fast. I"m sure you can use the repeater for this too.
  13. cesaru

    two different data sources to one gridview how?

    Thanks! I found this good example for anybody who is looking for the same thing. http://home.hot.rr.com/graye/Articles/DataTableJoins.htm but I wonder if for my case the following could be simpler. I have my sqlexpress db with some data and I wanted to related to a informix db. is it...
  14. cesaru

    two different data sources to one gridview how?

    I want to union to different table from two different datasources one is an informix db and the other an Sql Express db. The two tables are not the same but they share common columns. any ideas will be greeeeeat! thank you very much!
  15. cesaru

    Lock cursor in textbox

    thanks... you get me the idea. I came up with the onclick on the body. <body onclick ="document.forms[0].stagingfield.focus();" that works.. thanks!
See more

Part and Inventory Search

Back
Top