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

    Can't get execCommand and 'fontsize' to work with pt or px

    Hi, I'm trying to dynamically edit selected text using execCommand and fontsize as the passed command. [i.e. execCommand(fontsize,'',4) ]. The problem is that this works fine for relative browser sizes, but I need it to work for absolute sizes as well - either points or pixels. I've scoured...
  2. shepherd

    Is there a way to Test For open Transactions?

    I have a few procedures which uses transactions within access to ensure data consistency. What I'm wondering is, how can I test if a connection has an ongoing, uncommitted transaction or not. I'm trying to create a routine in my error handler to rollback any open transactions if any errors...
  3. shepherd

    Filegroup w/ Multiple Files on Single Disk

    Quick question - Would creating a filegroup comprised of multiple physical files only be advantageous if each of those physical files is located on a separate physical drive or array? I'm wondering if there are any benefits to creating a secondary filegroup that has more than one data file if...
  4. shepherd

    Data Environment Pros and Cons

    Hi - Recently, a friend of mine was telling me how great the data environment tool in VB is. I've always done this work by hand (ado). Does anyone have any info, or experience on the pros and cons of using the designer instead of coding connections manually? I'm wondering what type of...
  5. shepherd

    Displaying True/False as checkbox

    Hello! I have a query which returns multiple records to a user. I can't figure out how to display checkboxes instead of True/False fields in the results. Are there any list controls, or grid contols that allow for displaying boolean fields as checkboxes or similar graphical representations on...
  6. shepherd

    Group by Date

    I need to create a rollup table, with the data grouped by day. The field that I will be grouping by is a standard datetime field which records the exact time a transaction is made. Is there an efficient way to do this? When I run a cast or convert to int on the date field, it rounds up (so a...
  7. shepherd

    Optimizing a query

    I have a 6 GB log file which i have to import daily. I'm using DTS to import this data into a SQL table, and the process up to that point is streamlined. Afterwards, I need to process the data and input into a separate table that will always contain about a billion rows. The table has a...

Part and Inventory Search

Back
Top