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 TouchToneTommy 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: runmd
  • Content: Threads
  • Order by date
  1. runmd

    Determine Precision and Scale from a Numeric Column

    Is it possible to find out the precision and scale of a numeric column? I have a PL\SQL script that determines the max length of each column in a table. The script contains an IF block that reads the max length of columns that are of data type NUMBER, VARCHAR2, CHAR or any other data type. I...
  2. runmd

    ASP.NET runtime error: Cannot find table 0.

    I am working on some VB code to connect to an Oracle stored procedure and retrieve data. The stored procedure takes a string as input, constructs a SQL query into a string and uses a cursor to query and pull four fields of data. I have the four fields as an OUT parameter that I would like to...
  3. runmd

    Creating a Stored Procedure

    I would like to fire off an oracle stored procedure in a ASP.NET page that I will pass a query parameter (string variable) to assign to a where clause. I am concatenating the string to the rest of the SQL statement and would like to execute it. Do I use the EXEC() command? I would also like...
  4. runmd

    Sorting/Paging a GridView

    I have a GridView control that I attach data to in the Page_Load event. I have set AllowPaging and AllowSorting to True. The data comes from an oracle database so that means that the data binding is one way. The sorting and paging of data is a two way event so I have added two events to...
  5. runmd

    SqlDataSource Control and Hidded Field

    I am using a SqlDataSource control to pull data for a GridView control. I would like to use a value that is stored in a Hidden Field as part of the where clause. I get an Oracle invalid number error. The value of the Hidden Field is set on Page_Load and looks something like this: 2335 OR...
  6. runmd

    ListBox, Array and URL construction

    I'm throwing myself into ASP.NET with VB and there is no better way to learn it than by actually doing it. :-) I am currently working on a project where I want to utilize a SQLDataSource control, a ListBox control, a Button control, an array and a constructed URL to post a page. I'm writing a...
  7. runmd

    Combine data from two tables

    I have two tables of data with a county FIPS identifier. For anyone that does not know, it is comprised of a 2-digit state FIPS code and a 3-digit county FIPs code to create a unique identifier for each county. I have records where I have one per county or in some cases two per county in one...

Part and Inventory Search

Back
Top