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

    Individual pieces in query run fast, whole thing runs very slow

    I've got a stored procedure that runs a number of different queries. Most of these involve doing joins, updates, and inserts with tables on two different servers. There are about 8 different queries that get run in this stored procedure. If I run them individually, there is one that takes 17...
  2. millerk

    updating dll, but not other files

    Yesterday, I made some changes to a web app, then copied only the dll to the server. I didn't change any other files on the site. When I first tested it, it worked fine. But a little bit later, I got reports it wasn't working. I'm assuming it has something to do with the fact that I only...
  3. millerk

    Adding DataMatrix barcodes to a report

    I need to be able to print DataMatrix 2D barcodes on a crystal report. The report will be viewed and printed with a report viewer object in MS Access. I know that there are a bunch of companies that sell components to generate 2D barcodes like this in Crystal. There is also free code available...
  4. millerk

    query that merges data from multiple rows

    Say I have these 2 tables ProductRules: ProductNum, RuleCode this table says that a particular rule applies to a particular product. RuleCountryLink: Rule Code, Country this table says that a particular rule is applicable to a particular country. So right now, I have a query that is something...
  5. millerk

    Accessing the request object within a web service?

    I'm new to web services, but I've got a basic web service with one web method working. With a regular aspx page, you have access to the Request object and can read whatever you need from it. Is there an equivalent to this for web services? I'd like to be able to access the soap request from...
  6. millerk

    Create sequence numbers in multi-record insert ?

    I have some sql that selects from multiple tables and does an insert into a single "report" table that I use for generating a crystal report and an electronic file for a client. So it's something like: INSERT INTO ReportTable(fields....) SELECT fields.... FROM Table1 join Table2... etc. WHERE...
  7. millerk

    Help with splitting a string (more complex than the Split function)

    I have a string variable that will usually be several hundred characters long. It is basically a paragraph that will be displayed on a report and included in an electronic file. The electronic file requires that it be split into multiple lines, each of which are no longer than 80 characters...
  8. millerk

    Vertical line not showing up in page header

    I'm generating PDF reports with Crystal for VS.Net. I've got a vertical line drawn from the report header through the page header, details, report footer, and page footer. The line shows up fine for all the sections except the page header. Is there any way to make this line visible in the page...
  9. millerk

    Can I limit a CheckboxList to single selection?

    I have a db search page that gives the option of doing a "sounds-like" search. There are 2 types of sounds-like they can pick from, but I also want them to be able to pick neither. So ideally, I'd like 2 checkboxes and I'd like the user to be able to select one or the other or neither. Is this...
  10. millerk

    How to display data from 1 main table and 4 supporting tables

    I've got 1 primary table and 4 other tables. Each of these other tables has a many-to-one relationship to my main table. For example: Person(SSN) Alias(SSN, FirstName, LastName) Address(SSN, Street, City, State) Phone(SSN, PhoneNum) Each person can have many aliases, many addresses, and many...
  11. millerk

    Ideas for displaying data from 1 main table and 4 related tables

    The simplest way to explain would be to give an example. Say I have a set of database tables like this: Person(SSN, DOB) Alias(SSN, FirstName, LastName) Address(SSN, Street, City, State) Phone(SSN, PhoneNum) Skill(SSN, SkillDescription) There's one person with a particular SSN and that person...
  12. millerk

    Help with SQL join issue (not sure how to describe it)

    OK, here's the issue. Say I have 3 tables (tblEntity, tblEntityName, tblEntityAddress) An entity represents a person. That person can have multiple names(aliases) and multiple addresses. So there is a one-to-many relationship between Entity and EntityName and a one-to-many relationship between...
  13. millerk

    Retrieve TotalPageCount in vb.net?

    I've got a VB.Net app that is generating reports and exporting them to pdf, xls, etc. I want to be able to capture the total page count of the generated report. I know there is a special field(or function) called TotalPageCount and I'm using that on the report itself. But is it possible to...
  14. millerk

    Design ideas for page to add records to multiple tables (many-to-one)?

    Hi, I need to build a page to add entries to several tables. There is one main table and 4 other tables that have foreign key relationships with the main table. The primary key in the main table is auto generated. I know I can insert into the first table, then grab the newly generated primary...
  15. millerk

    sp_oa procs and .Net in SQL 2005

    Hi, We've got a SQL 2000 db with several stored procedures that use the sp_OA automation stored procedures to call a VB6 dll that then calls a .Net dll. This all works fine in 2000, but we can't get it to work in 2005. The sp_OA works fine when creating the instance of the VB6 com object, but...
  16. millerk

    How to reference assembly NOT in same folder as app?

    My C# app needs to reference a .Net assembly that was built by one of our previous developers. Everything works fine when I add a reference to the dll and leave "Copy Local" set to true. But this dll is used by several different applications and on several different machines and already has...
  17. millerk

    Change color of row in Datagrid (winforms, NOT web)

    I've been scouring the web and I found a few examples that have to do with overriding the paint method. But I can't seem to figure out how to make this something that I can trigger, rather than being dependent on a condition. Does anyone have any examples or ideas? Thanks
  18. millerk

    Any way to commit changes in datagrid BEFORE changing rows?

    I have a datagrid that is bound to a dataset. I have a "Save" button that checks the RowState of each row in the dataset to know whether to update the db or not. I have a "Cancel" button that does a RejectChanges on the dataset. This all works fine. I want to be able to change the color of the...
  19. millerk

    Any career advice on moving from VB/SQL job to Java/C++/something else

    Hi, I've been doing VB/SQL development for 4 years now since getting my BSCS degree. Most of my time has been spent developing software to support a manufacturing environment. I'd really like to branch out and do something different, but without Java/C++/C work experience, the only jobs I seem...
  20. millerk

    Missing reference problem - wrong path keeps coming up

    Hi, Every time I open my VB project and try to compile it, I get a "cant find project or library". When I click OK, I get the Project->References window and I can see the missing reference. The problem is that it is pointing to a path where an old version of an app that I've uninstalled was...

Part and Inventory Search

Back
Top