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

    New Datafiles?

    Is it considered Oracle best practice to create new datafiles, or expand existing ones as they become full? Cheers, James
  2. jgoodman00

    Restore RMAN backup onto different server?

    As a SQL Server person, I am trying to recover our live Oracle database to a test server just to prove the backups work. We have a weekly full database backup using RMAN, along with the control file and archive logs. I would like to recover the database using the backup, and archive logs onto a...
  3. jgoodman00

    MSGRID.Grid Not Loaded?

    I am looking at an application which was written in VB6 (I think although it might be VB4). A number of the forms attempt to use the MSGRID.Grid control, which I dont have. When I attempt to load the forms into the designer they show as PictureBox controls, & when they are loaded at runtime...
  4. jgoodman00

    MSGRID.Grid Not Loaded?

    I am looking at an application which was written in VB6 (I think although it might be VB4). A number of the forms attempt to use the MSGRID.Grid control, which I dont have. When I attempt to load the forms into the designer they show as PictureBox controls, & when they are loaded at runtime...
  5. jgoodman00

    RRAS Clients cannot ping, but server can?

    I have a demand dial VPN which connects from a Win2K server to a remote WinXP Pro machine. The network for our office is 192.168.10.0/24 The network for the remote location is 192.168.12.0/24 I configured the demand dial connection as appropriate. I added a static route onto our broadband...
  6. jgoodman00

    Table or Panels?

    In the standard web page layout of a header bar along the top, menu bar on the left, content in the middle & footer bar along the bottom what is the preffered method of implementing this? I currently use tables to position objects where I want them, but I am not sure if this is the best...
  7. jgoodman00

    Correct Application?

    We currently have to produce a period report which contains mostly text, but with some data from a database of ours. It is currently produced from a Microsoft Word Template, but I dont like the way the user has to manually remember to refresh the linked table data. The report is approximately...
  8. jgoodman00

    DataAdapter, DataView, DataTable?

    I have a view, qryStorageLocationSelector which I need to use to populate a series of 4 listboxes. The view has the following columns: Level1ID, Level1, Level2ID, Level2, Level3ID, Level3, Level4ID, Level4, LocationID Obviously, there can be multiple occurances of Level1,2,3,4 values etc. I...
  9. jgoodman00

    Use Styles.css with Control.CssClass?

    At the moment, I am referencing the styles.css value in the html portion (e.g. <H1><asp:label...></h1>) of my control declarations. Is there a way to use the CssClass property of the control itself? James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com
  10. jgoodman00

    Access Is Denied...

    Ok, I had an ASP.NET application which after much trouble worked on a server, SERVER1. I need to move this application to another server, DC2. Both are domain controllers, both are running the same OS, SP etc. The files are stored in C:\NET\App on SERVER1 & D:\NET\App on DC2. I tried...
  11. jgoodman00

    Calculate Percentage

    I have the following query results & I need to calculate the perct column based on the total for a type (e.g. Bramble). Type Priority Count Perct Bramble A 25 62.5 Bramble B 15 37.5 Any suggestions? James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com
  12. jgoodman00

    Calculate Percentage Between Rows

    I am having a bit of a moment to myself & canont think how to do this. I have the following results returned in a query: Type: Priority: Count: Perct: Bramble A 25 62.5 Bramble A 15 37.5 I need to calculate the Perct column. Any suggestions? James Goodman MCSE...
  13. jgoodman00

    Where to start?

    I regularly (every week) fly for work. To do this at the moment, I have to manually check the website of the couriers I use (Primarily Easyjet, BA, BMI). This is a repetitive task which takes quite a lot of time, so I was thinking about automating it. Basically, I need to collect the prices...
  14. jgoodman00

    @SQLParam Null?

    I am executing some SQL to insert a record into my underlying DB. I have a number of parameters, one of which is a date field. This may or may not be null. If it is null, I want null inserted, rather than the 01/01/1901 default. I am therefore using the following, which I am sure worked a few...
  15. jgoodman00

    Move a function from aspx page to module?

    I am using a dropdown within a datagrid to edit existing records in an underlying table. I used the example from 4guysfromrolla.com & modified the GetSelIndex function slightly for my needs. I currently have it on my aspx page. Function GetSelIndex(ByRef TableName As String, ByRef...
  16. jgoodman00

    DataGrid, DataAdapter, SP Parameters?

    I have an sp with paramaters like this: ALTER PROCEDURE dbo.SomeProc ( @SortBy varchar(50) = NULL @ShowComplete bit = 0 @StaffID int = NULL ) AS DECLARE @SQL varchar(2500) SET @SQL = 'SELECT StaffID, Status FROM SomeTable ' IF @StaffID IS NOT NULL SET @SQL = @SQL + ' WHERE StaffID =...
  17. jgoodman00

    Form Control Inheritance?

    I am writing a PocketPC app, & have a number of forms which load into a single panel control. These forms contain a series of tab-pages. Examples of tabs would be location, data, work etc. The location tab is common for all types of record & every form needs a location tab, containing the same...
  18. jgoodman00

    Credit Card Processing

    I have customized a site based on the IBUYSPY microsoft sample. I need to process credit cards in order to take payments. I presume the easiest way is to use a 3rd party merchant service? This being so, can anybody recommend any card processing companies (preferably UK)? It needs to handle...
  19. jgoodman00

    Multiple subforms into Panel?

    The following is related to a Mobile .NET application I am experimenting with. I have a main form, which has the following controls: 2 x Combo boxes. 1 x Command Button 1 x Panel control I then have two (at this stage but it will increase) other forms. I want to load the forms into the panel...
  20. jgoodman00

    Access Denied Error?

    I have written a small ASP.NET application. I developed it on my workstation & it works perfectly. It is basically a small data-entry app which connects to a SQL Server DB. It uses Windows Authentication to Authenticate users. I have set IDENTITY IMPERSONATE="TRUE". Happy with the app, I...

Part and Inventory Search

Back
Top