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!

Recent content by BuGlen

  1. BuGlen

    Detect redirect of a WebRequest

    I'm writing a console utility to download specific files from web sites. The problem I'm running into is that some web admins have taken it upon themselves to not return a 404 error of the URI of the file is incorrect. Instead they redirect the request to another page on the site to provide...
  2. BuGlen

    A RegEx grouping challenge

    Absolutely, and thanks. Your standard INI file is formatted with key-value pairs in sections like this: [Section One] Key1=Value1 Key2=Value2 Key3=Value3 [Section Two] Key4=Value4 Key5=Value5 ... I would like to retrieve the data like this (if it's possible), using named groups...
  3. BuGlen

    A RegEx grouping challenge

    I'm studying RegEx patterns for use in C# and I'm trying to find out if a subgroup scenerio is possible. I'm parsing an INI file and I'd like to return a single matches collection that contains the section, key, and value information for each entry. Here's what I have for patterns so far...
  4. BuGlen

    VB.NET or ASP.NET ???

    These are the simple considerations I usually make: Windows App: Localized distribution, utility based applications, heavy processing, light data transfer. Web App: Wide distribution, heavy transactional data applications, centralized business processes, simple interface. Hope this helps...
  5. BuGlen

    ComponentOne in VB.NET

    ComponentOne has their own newsgroup server and you should be able to get some decent support for their controls in the newsgroups: news.componentone.com Hope this helps. - Glen Know thy data.
  6. BuGlen

    Sharepoint application advise

    From what you described, it sounds more like a project / time allocation database than a timesheets application. I've done something similar to this using lookup type fields for the project and task. These project and task items were kept in different lists and maintained seperately. Also...
  7. BuGlen

    Select Case & Parameter Arrays

    I'm having a bit of problem with the Select Case logical expression in my formula. I have several parameter parameter fields that return arrays of values (using the Allow Multiple Values option). I'm trying to assign a group name based on which parameter array the item is found. Here's my...
  8. BuGlen

    Database locking.

    One way I've found to get around the locking issue is to copy the DB to another location, compact the copy, then overwrite the original with the copy. You would not want to do this during the hours where there might actually be a user updating the database for any reason. But if you schedule...
  9. BuGlen

    Using WITH NOLOCK

    I can tell you from our experience that the NOLOCK option in the queries does help with blocking issues that can occur on the database. As mentioned, this will allow for "dirty reads", but since most reports include filters such as date/time parameters it should not be an issue. An alternative...
  10. BuGlen

    Change datasource on deploy?

    We have CR 10 and CR Enterprise Server. When developing reports in the CR designer, I would like to set the datasource to the development SQL server and be able to change the source before deploying it to the enterprise server. This is standard practice in any development area in our...
  11. BuGlen

    Ways To Speed Up Split Database on Network

    Two ideas to consider: 1. Local data caching. Instead of binding the objects in the front end of the database directly to the back-end data, create empty copies of the data tables in the front-end and populate with filtered data from the back-end depending on the operation. This will speed...
  12. BuGlen

    Got a char need to convert to Date

    Hi Sanj, You can use the Cast() function to accomplish what you want, but you will need to rearrange the position of the date values in the string because it expects the YYMMDD format in a 6 digit expression. Here's an example of how you might use it: declare @DateString varchar(6) set...
  13. BuGlen

    Reporting Services Forum(s)?

    A question for the forum admins: Can you please set up forums for SQL Server Reporting Services? It's a relatively new product (January of 2004), but it's quickly becoming a hot topic in the Business Intelligence community. Two forums would probably be appropriate (one for setup & admin, and...
  14. BuGlen

    Mass E-Mail Code

    That's similar to what I had in the first example with some revision. You could also use the second example with the following changes to send a single email to each person using late binding and without overloading your memory. (note the changes in blue text) Public Sub Command0_Click()...
  15. BuGlen

    Mass E-Mail Code

    Hi Thanyellin, You could set the reference to Outlook under Tools->References in the VBA IDE. However, I don't generally recommend a direct reference to an Office application as that reference will break if the user has (or installs) a different version of the application. The best way is to...
See more

Part and Inventory Search

Back
Top