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
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...
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...
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.