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

  • Users: sila
  • Order by date
  1. sila

    Trimming Data

    Thanks Rhys666.
  2. sila

    Trimming Data

    Hi I am needing to trim out empty spaces in my datafield before the code below. I thought Trim(lit1.Text) would do this but this does not work Trim(lit1.Text) If IsDBNull(lit1.Text) Or lit1.Text = "" Then lit1.Text = "" Else lit1.Text =...
  3. sila

    Data Reader with no Value

    Thanks ca8msm.
  4. sila

    Data Reader with no Value

    Thanks, I dont suppose you could give me a little example of this in situ to get me started, plus aspx or vb side placing etc? Thanks.
  5. sila

    Data Reader with no Value

    Hi Based on the code below how would I get the data item "Address1", for instance, not to show if the value in it was "n/a or empty"? I would also prefer that a gap was not left in its place if possible. Any help appreciated. Thanks. <HTML> <HEAD> <title>mem_memberid_address</title>...
  6. sila

    Case Statement Help

    Hi Based on the sql statement below how do I get the address fields to show N/A when the ShowAddress field is 0? ALTER PROCEDURE dbo.CES_MEMSelectMemberIDAddress ( @MemberID as varchar(10) ) AS /* SET NOCOUNT ON */ SELECT Address1, Address2, Address3, Address4, Postcode...
  7. sila

    Variable into Mailto

    Thanks ca8msm!
  8. sila

    Variable into Mailto

    The part where you have me@here.com is where the value will be changing for various email addresses, does what you have given me above cover that? If my email variable is called MemberEmail, where would it go? Thanks
  9. sila

    Variable into Mailto

    Hi I'm getting an email address out of a database using the following.... Me.SqlConnection1.Open() dtrCabinetEmail = Me.SqlComm_SelectCabinetEmail.ExecuteReader If dtrCabinetEmail.Read Then Email = dtrCabinetEmail("committee_email") Me.lblEmail.Text =...
  10. sila

    Multi Table Select Statement

    Cheers James!
  11. sila

    Multi Table Select Statement

    James One more question on this query I've just realised! Both the tables CommitteeMembers and AdvisoryGroupMembers also have a field called 'position' which links to a table called Position where the position_name can be selected for the committee/advisory group how do I go about adding this...
  12. sila

    Multi Table Select Statement

    Thanks again James.
  13. sila

    Multi Table Select Statement

    Hi I hope someone can halp me, I have the following tables: Members member_id CommitteeMembers committee_member_id committee_id member_id Committees committee_id committee_name AdvisoryGroupMembers advisory_member_id advisory_group_id member_id AdvisoryGroups advisory_group_id...
  14. sila

    Adding Values to URL String

    Hi I am using a datagrid hyperlink column to go to the following URL. I need the section which says <Name> in the url below to be the name of the person with the ID. How do I go about adding this to the URL Format String - aboutme.htm?MemberID={0}...
  15. sila

    Strip Out Data from Field

    Thanks that worked a treat.
  16. sila

    Strip Out Data from Field

    Hi I hope someone can help me with this problem. In the query below there may be some ForeName1 fields where there is a name e.g. Joseph (Joe). How can I use the query to strip out any instances where there is a name in brackets and leave the main name only as I need to put this into a url...
  17. sila

    ASP.Net and Column Types

    Hi A quick question. In ASP.Net can someone tell me if it is possible to have hyperlink columns in anything but datagrids? i.e. can I make a data repeater have hyperlink columns and mailto columns? Thanks
  18. sila

    SQL Trigger Help Needed

    Hi I have a table with a field in it caled CountToClose, this is set to a date 09/05/2005 14:32:49 and after 4 days have elapsed another field in the database called CloseDown needs to be set to 1. I assume I need a trigger for this to happen but have not ever done this before and dont know...
  19. sila

    Response.Redirect and Session Variable

    Hi Can anyone tell me if you can use session variables to do response.redirect? Im storing an id in the one below but keep getting - "comma, ')', or valid expression continuation expected" on the elecid part? Me.Response.Redirect("hwelection.aspx?id= Session.Item("elecid") Thanks
  20. sila

    Problem with Multiple Summing in Join

    Thanks alot James, thats exactly it - brilliant!

Part and Inventory Search

Back
Top