Search results for query: *

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

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

I have a Java Script in my Cold Fusion page where I am limiting 3 fields to 500 characters and Java Script is used to truncate the field. It works fine on all computers except one and in there whenever my cursor enters the field with Java script and I start typing something It gives me an error...

I have created an application which shows the records in a reporting tool. Now, each tuesday I have to print all the records which are around 50 records each week and are of approximately 2 pages. To save paper and reduce the paper work, I want to program my appliation in cold fusion using any...

I don't is it possible or not. Can I get values in different fields and combine it and store in a database in one field? For example, First Name :- Ashish Last Name :- P Middle Initial :- Smith This would be asked on the web page and get stored as Full Name :-...

Hello, I have established a reporting system, which displays the summary of records in the tabular form. I have added view and edit icons, to view click view and to edit click edit. I also want add print icon to just click print and would print the record without even going into the...

I want to do this: convert 3.1425 to 3.14. I know we can output it with the use of set precision but i want to store the value so that it can be used for further calculations. Say like arr[i]=3.1425 and I want to multiply or plug arr[i]'s value in the function with arr[i]=3.14...

Hello Everybody, I have created a page which would have summary of each records starting from last week tuesday to this week's tuesday in a table. Each tuesday I have to click on each record and print their hard copy for our meeting. Instead of doing that I want to have a function on...

How to store a hostname or computername into a variable and want to use that name to net send a message in a batch file. Any Help with this? Ashish Smith

I want to count the number of rows from one table and count the number of rows in another table, and then want to compare them to see if the table is getting updated or not? SELECT (SELECT COUNT(*) FROM temp_apps_venus_ports) AS Count_1...

I have question regarding SQL Tables. I update my tables by DTS packages every Friday morning. These are millions of data, there is no way I can compare the new data and the old data manually because most of them are same. I have 2 things to ask, • How to see the last modified date of the...

How to Compare 2 MS SQL Tables, that if they are same or not? I have a temp table which has old data and a new table which deletes old data and updates with new data.

Project alloted to me is, I have extract data from Ms Access database, massage the data in certain way to store in the sql server database. I also need to create a sql server database. I have to do all these in c++. Can anyone help? Thank you, Ashish Smith

I have a file to be transfered to the server through ftp and want to execute a batch file on the server which produces 2 text files and after that want those two files to get back to me on my pc. I am successful in opening a ftp session sending a file to the program and receiving 2 text files...