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!

  • 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: *

  • Users: asrg
  • Order by date
  1. asrg

    update Db table button

    Hi .. all the code works for updating a text field in the table, so inserting text is fine.orks great Im just not sure how to up date a yes/no field (formatted as True/False) ... I assumed that putting the word true as the update would work...
  2. asrg

    update Db table button

    Hi im trying to updat an Access Db table (tasking)using a button. It does work if im updating a text field but not when Im updating a true/false field. The code that im stuck on is "&update=true". This will place the text "true" into a text field but wont change the conditon in the True/False...
  3. asrg

    Distinctrow issues - want more detailed output

    Thanks so much, Im new, so these code snippets help me understand the use in real world. Great , worked first time :-)
  4. asrg

    Distinctrow issues - want more detailed output

    Hi .. I'm trying to do the following: I have 2 tables, tblcustomer and tblorders. I want the output to show the last order (tblorders.orderdate) date of the individual customers =================================================== Select DistinctRow tblcustomer.surname From tblcustomer Inner...
  5. asrg

    Distinctrow issues

    Hey thanks buddy ... Im from Access background and trying to up my game. Works fine .. many thanks
  6. asrg

    Distinctrow issues

    Hi .. I'm new to SQL and trying to do the following: I have 2 tables, tblcustomer and tblorders. I want the output to show the last order (tblorders.orderdate) date of the individual customers =================================================== Select DistinctRow tblcustomer.surname From...
  7. asrg

    IF ELSEIF STATEMENTS

    Its attention to the small details in life ... lesson learnt :-)
  8. asrg

    IF ELSEIF STATEMENTS

    Thanks guys, it works great. Makitso, (openlist.Fields.Item("telcall").Value is true/false. Code ------ this works great Many thanks Makeitso <% if (openlist.Fields.Item("telcall").Value) then response.write ("<img src='../images/icons/mobile_phone.gif' alt='True'>") elseif...
  9. asrg

    IF ELSEIF STATEMENTS

    Hi .. My page is connected to an Access DB running on IIS 7. Im simply trying to show an image if the condition is true. I have 4 conditions looking at True/False fileds in the Db.. Ive Tried this code but no real luck ... Just get error /fusion/css/Z.ASP, line 187 elseif...

Part and Inventory Search

Back
Top