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 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 hbutt

  1. hbutt

    Populating a drop down list with data returned from a stored procedure

    yes list2. load_list2() will be executed when a value is selected from list1. the value from list1 is then converted to a string and passed to the stored procedure which is then fired off and returns the CORRECT results. but when i click submit the selected value in list2 defaults back to the...
  2. hbutt

    Populating a drop down list with data returned from a stored procedure

    Here is the sub procedure that should load the list: Sub Load_list2() Dim conn As New SqlConnection(SqlConnection_1) Dim cmd As New SqlCommand("[Causes_Clause]", conn) Dim da As New SqlDataAdapter(cmd) cmd.CommandType = CommandType.StoredProcedure...
  3. hbutt

    Populating a drop down list with data returned from a stored procedure

    hi, list1 has postback and is checked in the page load so it doesnt keep doing so continuously, using the : If Not Page.IsPostBack Then method, which seems to work for it, its just list2 which uses the value selected in list1 for a stored proc to bring back the corresponding values. thanks...
  4. hbutt

    Populating a drop down list with data returned from a stored procedure

    Here is the sub procedure that should load the list: Sub Load_list2() Dim conn As New SqlConnection(SqlConnection_1) Dim cmd As New SqlCommand("[Causes_Clause]", conn) Dim da As New SqlDataAdapter(cmd) cmd.CommandType = CommandType.StoredProcedure...
  5. hbutt

    Populating a drop down list with data returned from a stored procedure

    Hi there, im creating a basic application, where a user will select a value from a drop downlist (list1) . the value selected in list1 is stored in a variable and passed to a stored procedure which brings back the data for list2. so far i can get list2 populated but when i to select an option...
  6. hbutt

    Populating a drop down list with data returned from a stored procedure

    Hi there, im creating a basic application, where a user will select a value from a drop downlist (list1) . the value selected in list1 is stored in a variable and passed to a stored procedure which brings back the data for list2. so far i can get list2 populated but when i to select an option...
  7. hbutt

    is it possible to insert dynamic values into a table via a form?

    the form field values i want to enter into the database table are the same as the table fields. the query i thought about using for this is similar to this, i dont know if it is correct at all. INSERT INTO CustomerDetails VALUES (Cust_ID, CompanyName, Forename, Surname, HouseNo, Address...
  8. hbutt

    is it possible to insert dynamic values into a table via a form?

    i wanted to take dynamic values from a form and insert them into a table. i tried to create a query that would allow me to do this via the form, i havent been able to do so. i wanted to know if this was possible and using a pk var that is of auto number type. any help is much appreciated.
  9. hbutt

    what is the purpose of data mining and why do we need it?

    hi there, i apologise in advance if any members find this question annoying, but i need help in understanding what the purpose of data mining is and why do we need it, with regards to data warehouses and data sets. thanx in advance. hb
  10. hbutt

    how to check if a query returns any rows?

    hi, im having trouble checking to see if any rows have been returned. here is the code: public static void CC_Validate(String a) { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:SQL_ODBC_DEMO2"; Connection con =...
  11. hbutt

    how to connect to ms sql server?

    windows 2000
  12. hbutt

    how to connect to ms sql server?

    hi, just wanted to know if anyone new how to connect to ms sql server with php? thanks hbutt
  13. hbutt

    Connecting MS SQL Server with Java

    hi, there ive been having problems in connecting to MS SQL Server through java, could someone help me, as im struggling to do so. thanks in advance. kind regards hbutt.
  14. hbutt

    Help needed with maths function and calculation urgent!

    hi there i just wanted to know if there was a way doing the following mathematical equation more easily. static float distanceToBuilding(TravellerSprite travellersprite, BuildingSprite buildingsprite) { float f = (float)buildingsprite.xcoord - travellersprite.xcoord...
  15. hbutt

    Using Vectors to store values

    hi there this what i actually need to do A constructor which takes two parameters; the users name (a string) and the users cipher key (a string). A Vigenere cipher matrix is initialised if the key is valid (same rules as the last class) and the users name is valid. The users name is invalid if...

Part and Inventory Search

Back
Top