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 bkrike 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 sila

  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.
See more

Part and Inventory Search

Back
Top