Install Microsoft.Jet
Hi all, I have tried to import the excel to db , but i get the following error, The OLE DB provider Microsoft.Jet.OLEDB.4.0 has not been registered. how can i install the Microsoft.Jet? System Info: OS Name Microsoft(R) Windows(R) Server 2003, Enterprise Edition for 64-Bit Itanium-based Systems System Type Itanium (TM) -based System Processor ia64 Family 31 Model 1 Stepping 5 GenuineIntel ~1300 Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to Get file modified time and date of file by using builtin function or procedure in sql?
Hi All, how to Get file modified time and date of file by using builtin function or procedure in sql? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to Get file modified time and date of file by using builtin function or procedure in sql?
Ananda Kumar wrote: which file are u talking about. regards anandkl Ordinary temp file.. say example in C:\output.txt Actually i have given that file as input to some procedure, based on that modification time we have calculate some details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to Get file modified time and date of file by using builtin function or procedure in sql?
Ananda Kumar wrote: you can do that using OS command, any specific reason u want to use stored proc to get this information. OS Command? could you explain with examples? because, I have more # of input files.. thats why iam going to procedure.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do I get the file names from a certain directory in SQL?
Hi all, How do I get the file names from a certain directory in SQL? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do I get the file names from a certain directory in SQL?
Martijn Tonies wrote: Hey, How do I get the file names from a certain directory in SQL? It seems to me that you're trying to do things that are beyong SQL really. SQL is about the database, not about a file system. Yes, by creating a DBMS that allows you to write functions that interact with the file system, you can do these things, but I wonder if it's the right way to go. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com I accept that.. but my requirement is , I have some no of Excel files..I just need to check the modified time of the files ,if it is modified currently then I need to open those files and convert the excel data to database.. otherwise i didnt change anything in my database.. how can i going to achieve that? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: WHERE .... IN
How about: WHERE ( field1 LIKE '123,%' OR field1 LIKE '*,123,%' OR field1 LIKE '%,123' OR field1 = '123' ) Note that this could that a long time on large tables. You'd be better off to normalize your tables ;) How can we normalize the tables? could you explain bit more? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query for details
Hi all, I have one table as following AccessDetails DateTimeUserName SiteName StatusVirus_Category |2008-04-23 | 14:27:38 | 172.16.1.40| en.wikipedia.org | A | unclassified | | 2008-04-23 | 14:27:39 | 172.16.1.40| en.wikipedia.org | A | unclassified | | 2008-04-23 | 14:27:40 | 172.16.1.92 | www.google.com | D | Internet | | 2008-04-23 | 14:27:40 | 172.16.1.40 | en.wikipedia.org | A | unclassified | | 2008-04-23 | 14:27:41 | 172.16.1.40 | en.wikipedia.org | O | Internet | | 2008-04-23 | 14:27:42 | 172.16.1.40 | en.wikipedia.org | A | unclassified | | 2008-04-23 | 14:27:42 | 172.16.1.40 | en.wikipedia.org | O | unclassified | | 2008-04-23 | 14:27:43 | 172.16.1.40| en.wikipedia.org | A| unclassified | | 2008-04-23 | 14:27:43 | 172.16.1.40| meta.wikimedia.org | A| unclassified | | 2008-04-23 | 14:27:47 | 172.16.1.34 | googletb.skype.com | D | unclassified | from the above table , i need the details of , how many total users, how total accessed sited,how many total denied sites ,how many total overridden sites and how many total sites(accessed+denied+overridden) for particular Virus_Category with Date and Time. In above table the Status shows A for accessed sites, D for Denied sites,O for Overridden sites.. how can i form the query?? Thanks,
Query problem
Hi all, Iam having the one table name called AccessDetails and data inside that tables is following, DateTime UserName SiteName ScanType Status Virus_Category | 2008-04-16 | 13:05:31 | 172.16.1.22 | - | www.veer.com |C | A| unclassified | | 2008-04-16 | 13:05:31 | 172.16.1.52 | - | blogactiv.eu |C | O | unclassified | | 2008-04-16 | 13:05:32 | 172.16.1.22 | - | www.veer.com |V | A| Internet | | 2008-04-16 | 13:05:32 | 172.16.1.52 | - | www.verylowsodium.com |C | D| unclassified | | 2008-04-16 | 13:05:32 | 172.16.1.52 | - | blogactiv.eu |V | A | unclassified | In that , I need to calculate the number of total sites , number of total Accessed Sites,number of total Denied Sites and number of total Overriden Sites based on the particular Virus_Category,UserName,Date How can form the query to achieve that?? I have used the following query but the total site is not correctly displayed.. select count(a.UserName),sum(b.totalsites),sum(a.Allow),sum(a.Denied),sum(a.Over),sum(b.totalconn) from (select a.UserName,sum(a.Allow) as Allow,sum(a.Denied) as Denied,sum(a.Over) as Over from (select UserName,case Status when 'A' then count(distinct SiteName) else 0 END as Allow ,case Status when 'D' then count(distinct SiteName) else 0 END as Denied,case Status when 'O' then count(distinct SiteName) else 0 END as Over from AccessDetails where Virus_category = 'unclassified ' and Date='2008-04-16' and Date='2008-04-16' and ScanType='C' group by UserName, Status) a group by a.UserName) a left join (select UserName,count(distinct SiteName)as totalsites, count(Time)as totalconn from AccessDetails where Virus_category = 'unclassified ' and Date='2008-04-16' and Date='2008-04-16' and ScanType='C' and Virus_category '-' and UserName '-' group by UserName)b on a.UserName=b.UserName where b.totalsites is not null Thanks In Advance ,
