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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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!
  16. cesaru

    Lock cursor in textbox

    Hi, I'm creating a small single data entry form for a handheld. I have a "staging" textbox where people enters data and the stagingtextbox then sends to other textboxes depending on the data. The problem i'm having is that because the handheld is touchscreen if the user touches the form...
  17. cesaru

    Copy value from text 1 to other textboxes depending on value

    dwarfthrower, thank you very, very much! you rock man! this was awesome.... the only think is that i hope it works on the IE on the handheld. This will make life easier. Muchas Gracias!
  18. cesaru

    Copy value from text 1 to other textboxes depending on value

    Sorry I should have said client side html textbox. No server side textbox. this is what I need to do type or scaned to a text box ( no server side) then when press ENTER key check for first letter if starts with "T" then copy that value to a server side textbox. Hope i'm clearer this time...
  19. cesaru

    Copy value from text 1 to other textboxes depending on value

    Hello, I have a small asp.net formview with 4 textboxes where the user is using a scanner to scan barcodes. What I want to do is to have a html Scan Textbox outside the formview control where the user scans the barcode and if the data starts with the letter "T" then copy that value to the...

Part and Inventory Search

Back
Top