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 TouchToneTommy 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 BradEdwards

  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...
See more

Part and Inventory Search

Back
Top