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 SkipVought 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: *

  1. BradEdwards

    one-to-many compare problem

    Johpje, thanks for the reply, however that will not work for me. The software used to scan is third-party, I'm just updating records in the table because the software does not handle this. We will have a process that runs at night to do handle all of the marking of inactive/active status...
  2. BradEdwards

    one-to-many compare problem

    I have a system in which I scan in signature cards (sigcards). These sig cards have keywords on them called CIFKey. They can have one or more CIFKeys on them. The docnum for the sig card is stored in one table and the keywords are stored in another and linked by docnum. So I have a...
  3. BradEdwards

    joining 2 tables based on multiple records???

    Very impressive vongrunt. I checked it against some test data and it works perfectly. I'm still trying to figure out why it works, but very impressive. Thanks a lot.
  4. BradEdwards

    joining 2 tables based on multiple records???

    Very interesting. I'll give that a shot and let you know how that works. Thanks a bunch.
  5. BradEdwards

    joining 2 tables based on multiple records???

    oic. > So if itemNum has N CIFs, any related Acct# must have EXACTLY N CIFs too? No more, no less? That is correct.
  6. BradEdwards

    joining 2 tables based on multiple records???

    vongrunt, The 2 tables that you created are what I already have. I need another table that tells me what Acct#'s I need to add to the itemnum's (sig cards). So in my first example the final table would look like this Create Table AddAccts ( itemnum int Acct# int ) --matches Acct#...
  7. BradEdwards

    joining 2 tables based on multiple records???

    Okay Patrick I'll try this again...but I knew this would be hard to explain... I'm scanning signature cards for bank customers into an imaging system. The Sig Cards have 2 keywords (indexes) on them...Account # and CIF #. The CIF # is a unique number used to identify a customer. When we scan...
  8. BradEdwards

    joining 2 tables based on multiple records???

    I have a table with Acct #'s and CIF #'s. Some Accts have multiple customers associated with them (ie. Husband and wife). See Example below. example: Acct# CIF# 123 CIF01 123 CIF02 345 CIF01 567 CIF03 789 CIF02 789 CIF03 We have an imaging system where we scan in Signature...
  9. BradEdwards

    Need list of properties associated with a specific item??

    following is some sample asp code: Dim docProperties On Error Resume Next set docProperties = documentDataProvider.GetDocumentProperties( docID, requestProperties ) If Err.number <> 0 Then Err.Clear On Error Goto 0 webService.PresentError response, documentDataProvider...
  10. BradEdwards

    Web Share Aliases in 2000 Server IIS 5.0

    I'm not sure what I did but when I went to setup a web share for our wwwinc directory I accidently put in &quot;/include&quot; with the forward slash. This somehow caused the alias/share to be hidden or something because now when I try to reshare the wwwinc directory as &quot;include&quot; a...
  11. BradEdwards

    Sending output from Stored Procedure via ASP

    I created the following (simple) Stored Procedure. The real one is a lot more detailed but I created this simple one to make sure that it worked CREATE PROCEDURE spTest AS Create Table #Date ( Branch int, ) INSERT INTO #Data (Branch) (SELECT Branch FROM tblSalesInc) SELECT Branch from...
  12. BradEdwards

    Passing form variable to JavaScript/ASP function

    Here's what's going on...I have a page that loads and creates the following input boxes: Date Employee Number Employee Name Customer Name Product Referral Add button The employee would enter their Employee Number and I would like the Employee Name field to populate automatically based on the...
  13. BradEdwards

    Passing form variable to JavaScript/ASP function

    Tim, I think I figured out my problem but I still don't have a solution. I'm not POSTing the form data. The page loads with the input boxes and then I start entering information. The data never gets posted so using the Request.Form method probably won't work for me right?? Anyway hope that...
  14. BradEdwards

    Passing form variable to JavaScript/ASP function

    Hey Tim, Here is my code (simplified). I just can't seem to figure it out. If you see something I don't please let me know. I dont't think it's pulling the value from the form. Thanks. filename= test.asp <html> <head> <TITLE>Employee Name Test</TITLE> </head> <body> <br> <Script...
  15. BradEdwards

    Passing form variable to JavaScript/ASP function

    I have a form, let's say for simplicity sake, with 2 input fields <input type=&quot;text&quot; name=&quot;empNum&quot; onchange=&quot;empName.value=GetUserName(this.value)&quot;> <input type=&quot;text&quot; name=&quot;empName&quot;> Now i have a db that stores all the employee information...
  16. BradEdwards

    Linking REMOTE access database to SQL Server

    I'm running MSSQL 2000 and trying to link to an Access 97 database on a separate Novell Server. It seems that everything I've read says that the Access db needs to reside locally on the SQL Server. Is there anyway around this?? I have 24 db's that are downloaded on a nightly basis from our...
  17. BradEdwards

    Referencing an Access table in an SQL pass through query

    I want to write an SQL Pass Through query that takes records from an Access database and inserts them into my SQL Database. I know I can write an Append query or do a db.execute (&quot;Insert....&quot;), but from what I've read, the only way I can use qdf.execute dbRunAsync is if I'm using and...
  18. BradEdwards

    Fastest way to insert records into SQL from Acess

    Hey Terry, I am using a linked table but I'm still using the db.execute in my vb code. Here is what my code looks like: strSQL = &quot;INSERT INTO tblJournal SELECT * FROM Journal ORDER BY Journal.BRN, Journal.BOX, Journal.SEQ&quot; db.execute strSQL tblJournal is the linked table to the SQL...
  19. BradEdwards

    Fastest way to insert records into SQL from Acess

    I have 24 facilities in which we download a journal.mdb every night. In the morning I run a program that I wrote in VB that consolidates all 24 journal.mdb files into one file. This creates one big journal.mdb file which has anywhere from 15-20,000 records in it. I added to my VB program a...
  20. BradEdwards

    Running EXEC( ) command in Stored Procedure

    I made 2 simple changes to my stored procedure and now it takes 3 times as long to run it. Here is the part of the code where I've made the changes: Here was my code before: CREATE PROCEDURE spStaffingModelsRpt ( @StartDate datetime, @EndDate datetime ) AS CREATE TABLE #Data (...

Part and Inventory Search

Back
Top