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!

Search results for query: *

  • Users: sila
  • Content: Threads
  • Order by date
  1. 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 =...
  2. 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>...
  3. 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...
  4. 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 =...
  5. 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...
  6. 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}...
  7. 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...
  8. 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
  9. 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...
  10. 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
  11. sila

    Problem with Multiple Summing in Join

    Hi, I need some help with my sql query below. The results I'm getting back for the Electorate is way higher than it should be, I think its somehow totalling it in both dbo.Candidate and dbo.DivElection. (dbo.Candidate has DivElecID in it numerous times due to the multiple candidates in a...
  12. sila

    Formatting Unbound Datagrid Columns

    Hi Can anyone tell me if I can do centering on a datagrid column when the datagrid does not use bound columns? Thanks
  13. sila

    Return Value Output

    Hi Can anyone tell me how I make the query below give me both return results as I run it now it only shows me the first one? Thanks ALTER PROCEDURE dbo.CES_CheckCountToCloseDown /**/ ( @ElecID as real ) AS declare @closedown int declare @allresultsin int set @closedown =( SELECT...
  14. sila

    Update Query

    Hi I need to add some code to the query below which also sets any records other than the winner who has the same DivElecID to 0. Any help greatly appreciated! update dbo.Candidate set Winner = 1 where DivElecId = @DivElecID and VotesReceived = (Select max(a.VotesReceived) from dbo.Candidate a...
  15. sila

    Datagrid to Show Address Format

    Hi I have a stored procedure that produces an postal address in the format: My Street, My Area, This Town MY POSTCODE However this needs to be out put into a datagrid which doesn't seem to want to show the format in this way. Does anyone have any ideas why this might be? Cheers Sila
  16. sila

    Select second largest value

    I have used the sql below to extract a max value but I now need to select the second largest value within the id. Does anyone know how to do this? SELECT MAX(VotesReceived) AS Expr1 FROM dbo.Candidate a WHERE (DivElecID = @DivElecID) Thanks
  17. sila

    Enter Key Problem

    Hi I have an asp.net page which has a datagrid with edit buttons. When clicked the edit buttons feed the field details into some textboxes on the same page where they can be edited, alternatively, a new record can be added by clicking a separate 'add new' button. If I click the 'add new' button...
  18. sila

    Datagrid Not Showing Top Record

    Hi I have a datagrid using a datareader to populate it. On running it the top record seems to be cut off each time in all cases. The stored procedure behind it is showing all records correctly? Any ideas greatly appreciated. Sila.
  19. sila

    Index was out of range

    Hi I'm getting the following error for the code below it: ---------------------------------------------------------- Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index ---------------------------------------------------------- Private Sub...
  20. sila

    Update Statement Help

    Hi I need to write a sql statement that does an update as the follwing the following: tab1.ceq_kit_ref needs to be set to be equal to tab2.kitchen_id where tab2.kit_ref = tab1.ceq_kit_ref All help greatly appreciated! Thanks.

Part and Inventory Search

Back
Top