Recent content by ashishsmith

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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