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 wOOdy-Soft 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 scottydd

  1. scottydd

    Convert letter to number

    Thanks for all your help, got what i needed Scott
  2. scottydd

    Convert letter to number

    I was wondering if someone can help me with this problem? I am getting a value from a datareader. This value is a letter. What i need to do is take this letter and increment it up by 1 letter (i.e. if the letter is a A I need to increment it to a B). Is there anyway I can do this using C#...
  3. scottydd

    Select MAX value

    Thanks, that worked.
  4. scottydd

    Select MAX value

    I think i got it: select a.dwg_no, max(a.dwg_rev), max(b.dwg_rev_seq) from dwgdetail a cross join dwgdetail b group by a.dwg_no Thank again, Scott
  5. scottydd

    Select MAX value

    gradley, that is what i am look for, but i forgot a column. I also have a dwg_no column. i need the dwg_no and the corresponding max dwg_rev and dwg_rev_seq. Sorry about that, been staring at the screen to long. Thanks again, Scott
  6. scottydd

    Select MAX value

    I was wondering if someone could help me with at query. I have 2 fields dwg_rev and dwg_rev_seq. dwg_rev is at single letter and dwg_rev_seq is a number or NULL. Can someone tell me how i could go about selecting the max letter and the corresponding max number? Thanks, Scott
  7. scottydd

    Error using C#

    I'm new to C#, and this will probably be a simple question. I am trying to do a simple IF statement, based on a DDL selection. if ( ddl_type.SelectedItem.Text = "COMMERCIAL" ) { Response.Write(BinNo); } When i do this I get the following error: CS0029: Cannot implicitly convert type...
  8. scottydd

    Hyperlink Datagrid

    I figured it out i just used some old code from my asp page. <asp:TemplateColumn> <ItemTemplate> <table> <tr> <td> <a href="file:<%#DataBinder.Eval(Container.DataItem, "server_location" )%>" target="_blank">Open File</a></td> </tr> </table>...
  9. scottydd

    Hyperlink Datagrid

    I would like to know if the following is possible using C#: I am querying a access database for 4 fields. I then use the first 3 fields in a datagrid. What I would like to do is use the 4th field (which is the location of a Word Document on my server) as the hyperlink for field 1, and have...
  10. scottydd

    Date only from a Access Database

    Thanks Jennifer works great.
  11. scottydd

    Date only from a Access Database

    I'm trying to figure out how to convert a DATE/TIME field in Access to just a Date using a select statement. Any help would be appreciated.
  12. scottydd

    open word document

    Great, thanks...One more question, this makes it open in a new windows. How can i make it open in the current window?
  13. scottydd

    open word document

    Is it possible to use a ONLOAD to auto open a word document when a page is loaded? If so could someone tell me how? Thanks, Scott
  14. scottydd

    Submit form and mailto

    Currently I have a form that is submitted to another page for printing. What I would like to do is to not only submit the form but also mail it to a person. Is this possible and if so how would I go about doing it?
  15. scottydd

    Submission of Dynamic Form

    If i use this method of submission, is it still possible to do form validation?
See more

Part and Inventory Search

Back
Top