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 strongm 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. ashishsmith

    Compare 2 Tables

    This was the same code, I was suggested before, but It's not working and the error goes like this: Syntax error (missing operator) in query expression 'march.[Target App] FROM feb JOIN march ON feb.Vulnerabilities=march. Vulnerabilities AND............And feb.[Original Date]=march.[Original...
  2. ashishsmith

    Compare 2 Tables

    I am using Ms Access Database but assume SQL Query Language is always same, whatever it is; here is my query: UPDATE feb SET ID=march.ID, [Scan Group]=march.[Scan Group], [Scan Date]=march.[Scan Date], [Vuln ID]=march.[Vuln ID], CVE=march.CVE, Vulnerability=march.Vulnerability...
  3. ashishsmith

    Compare 2 Tables

    I copied the same code. It says Syntax error(missing operator) in query expression 'march.[Target App] From march'. If I try putting , after march.[Target App] than it says syntax error in update statement. I don't know whats wrong with this now. Please help... Ashish Smith
  4. ashishsmith

    Compare 2 Tables

    I am using Ms Access Database but assume SQL Query Language is always same, whatever it is; here is my query: UPDATE feb SET ID=march.ID, [Scan Group]=march.[Scan Group], [Scan Date]=march.[Scan Date], [Vuln ID]=march.[Vuln ID], CVE=march.CVE, Vulnerability=march.Vulnerability...
  5. ashishsmith

    Compare 2 Tables

    UPDATE query doesn't work with FROM, it can only have SET and WHERE. I tried your query for update it soesn't work. What should I do? Thank you, Amar Shah
  6. ashishsmith

    Compare 2 Tables

    I have 2 tables february and march, both of them have 11 fields and there is no primary key (no unique key). Data from both the tables have to be in 1 table. There is one condition to fulfill, if fixed 4 fields which has the same data in both the tables than overwrite the data from february...
  7. ashishsmith

    Unable to upload the files to FTP server

    I can login via ftp username and password. After successfully logged in I cannot send the file, it says access denied... Can you help me.. in this Similiar problem Ashish Smith
  8. ashishsmith

    Calendar Database

    I have to make a database for a calendar and i am thinking about getting a databse ready to ge t the calendar updated and store the events. Does any one have ideo for a design fo a calendar. Thank you, Ashish smith
  9. ashishsmith

    Automatically Change the Attribute

    thank u guy u havebeen gret help. ASA i test it tonight will let u know. thank u, Ashish Smith
  10. ashishsmith

    Automatically Change the Attribute

    oh great. Thank you very much for your help. I will try it tonight and if it works, it's good to go else i would keep researching on how to get the stored procedure run automatically every night, is it possible through DOS prompt same as DTS package can be executed remotely through a DOS...
  11. ashishsmith

    Automatically Change the Attribute

    Thank you very much.I guess this would resolve my issue. Let me check it and I would getback to you if I have any problems. That is correct, I will have to update all the records so that every record has up-to-date flags and the operations depending on this flag runs smoothely. Just a question...
  12. ashishsmith

    Automatically Change the Attribute

    I have designed a Data Base on SQL Server Database. I want to change an attribute in that Data Base according to the date. There are 2 things, Difference of Date and Flag. I want to change the value of Flag from 0 to 1 when Difference of Date is between 1 <= x <= 30. If the Difference of Date...
  13. ashishsmith

    Java Script to Print back-to-back

    But is there a way to instigate not just by JS than using anything. Is there any way using JS, Cold Fusion or anything? Thank you, Ashish Smith
  14. ashishsmith

    Java Script to Print back-to-back

    Hello All, I know, I have asked the same question in Cold Fusion, but after reading some replies. I guess Java Script would the right place to ask something like this. I have an application which shows all the records of last week. What I need to do each week is print all the...
  15. ashishsmith

    I get errors for Java Scripts

    Yes JS is enables on that machine and everything JVE is also running. I don't know still there is a problem. Ashish Smith
  16. ashishsmith

    how to get a report printed double sided

    Yeah I am looking for a kind of java script to print the records back to back instead of wasting 2 pages for one record. Is it possible? Thank you, Amar Shah
  17. ashishsmith

    I get errors for Java Scripts

    This doesn't work, my friend. Thank you atleast for trying to help me. Oh one more thing if you can help me in this. I have a print icon, which prints the records. I want to print them back to back. Is there an option where i can straight away load that option as checked through java script...
  18. ashishsmith

    I get errors for Java Scripts

    Yep Every browsers are same and they are same version because they are supported by the company. Ashish Smith
  19. ashishsmith

    I get errors for Java Scripts

    Ok here is my code to limit text area to its maximum limit if the user goes beyond the max limit Ashish Smith <!--- START: JAVASCRIPT: Limit TextArea ---> <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function textCounter(field,cntfield,maxlimit) { if (field.value.length > maxlimit) // if too...
  20. ashishsmith

    I get errors for Java Scripts

    Well, I can't send you the link because it is an internal page, I mean it is on intranet and not on internet. Sorry for that. But I can explain you the error Error : 'undefined' is null or not an object This is the error I get when I press a key in the field where Java Script checks if the...

Part and Inventory Search

Back
Top