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 Chriss Miller 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: skerr
  • Order by date
  1. skerr

    JDBC error trying to connect to MS access db on remote NT 4.0 server

    I am running ColdFusion server MX 6.0 on a Windows 2000server. In Administrator I am trying to connect to an MS Access datasource on a remote NT 4.0 server. I have tried to connect using ODBC sockets and MS Access and neither will work. I have the ColdFusion services all set to run with my...
    • skerr
    • Thread
    • Replies: 0
    • Forum: Adobe
  2. skerr

    Query Help - use of MAX returns all rows for an ID - I want only one

    Worked perfectly - thank you. I do have one more issue with this query. I now realize that the results of this query should not include any RequestID that appears in another query (Completed Requests). Any further advice would really be appreciated. Thanks.
  3. skerr

    Query Help - use of MAX returns all rows for an ID - I want only one

    I have the following table: ReqStatusID AutoNumber Unique Identifier for table RequestID Number Unique Identifier for the Request Table StatusID Number Unique Identifier for the Status Description Table StatusDte Date/Time Date status added for a request Detail Text Detail for status...
  4. skerr

    Calculate Sum for Word text form fields

    Never mind - I figured it out. I just didn't know how to remove the thread.
  5. skerr

    Calculate Sum for Word text form fields

    In Word 2000 I have a table with a column of 13 text form fields (type = number & format = currency). In the last row of this column I would like to sum the currency in the text form fields. Is it posible to perform a calculation on text form fields in protected mode? Thanks for any help.
  6. skerr

    Alter Column results in Incorect syntax near 'Column'

    I ran this query against the pubs database and it runs successfully ALTER TABLE publishers ALTER COLUMN state CHAR(25) I change the table & field names for my db as follows: ALTER TABLE customquery ALTER COLUMN toclause CHAR(25) and run against my database and I get the following error -...
  7. skerr

    Model Database won't attach in SQL 7.0

    I have restarted the Server and I still don't see model. I misled you - I did not detach master, I first changed all of my system supplied databases to a new drive (E: to d:) and then I detached all of the system database and then I copied master and all of the system database files. ServerA...
  8. skerr

    Model Database won't attach in SQL 7.0

    I used sp_detach_db to detach the master, model and msdb databases on ServerA and then used sp_attach_db to attach the master, model and msdb databases on ServerB. The attach process completed successfully for all databases (and I did start SQL Server with trace flag 3608 for the detach and...

Part and Inventory Search

Back
Top