Search results for query: *

Hi all, i have a table with the following structure: entry_no ID item amount 1 123 item1 2 2 123 item2 1 3 123 item3 3 4 456 item1 1 5 456 item4 4 Now what i would like to achieve is...

Hi everyone, on SuSe 10.2. 64 bit version i get the following error when calling make install: make[3]: Leaving directory `/home/chris/downloads/postgresql-8.2.4/src/port' ./zic -d '/usr/local/pgsql/share/timezone' -p 'US/Eastern' ./data/africa ./data/antarctica ./data/asia ./data/australasia...

Hi all, I tried to configure the scope of some ports for the firewall on my windows 2003 server. What i want to do is to allow access to programs like CVS or VNC and file sharing based on ip address, so I entered the port for CVS for example and changed the scope to xxx.yyy.0.0/xxx.yyy.zzz.0...

Hi everybody, I hope somebody can help me out. Despite having indices on all fields involved in the WHERE clause the query takes just too long: Here's the query: SELECT a.allele_1, a.allele_2, a.snp_id FROM my_table a INNER JOIN another_table b USING (snp_id) WHERE NOT b.snp_id=null AND...

Hi everyone, instead of executing several queries like SELECT a FROM table WHERE id=1 and SELECT b FROM table WHERE id=2 I would like to combine the queries. I tried already using subqueries like SELECT (SELECT a FROM table WHERE id=1), (SELECT b FROM table WHERE id=2) but without...

Hi everyone, is there a way to get the files that were modified from a certain onwards and copy them to a different folder in order to make a backup of only those files that were modified? Thanks!

Hi, i have a table where i want to store which id occurs in which table, so the table looks basically like this: table_name id t1 1 t1 2 ... t2 150 t2 151 I have been trying to come up with a query that inserst...

Hi everyone! i have a table with around 57 million tuples, with the following columns: pid(varchar), crit(varchar), val1(varchar), val2(varchar). Example: pid crit val1 val2 p1 c1 x y p1 c2 x z p1 c3 y x ... What i am doing is to query...

Hi everyone! i have a table with around 57 million tuples, with the following columns: pid(varchar), crit(varchar), val1(varchar), val2(varchar). Example: pid crit val1 val2 p1 c1 x y p1 c2 x z p1 c3 y x ... What i am doing is to query...

Hi everyone, i have amongst others the columns pid(varchar) and insertDate(timestamp) and would like to obtain all distinct pid values ordered by insertDate. The problem, though, is that with the following query select distinct pid, insertDate from mytable order by insertDate returns all...

Hi everyone, i would like to do the following but don't know how: I want to allow only computers from a certain ip addressto access my windows server 2003, e.g. only computers with ip 123.123.x.x should be able to access the server. Thanks for any hints.

Hi everyone, i am pretty new to Windows 2003 and have encountered the following problem. I set up a fileserver on Windows 2003, but some users mentioned that it takes up to one minute to open files that don't exceed 100kb in size and it also takes very long for the file tree to be shown in...

Hi everyone, i have an xml file that looks like this: <myns:importDescription xmlns:myns='http://xml.netbeans.org/examples/targetNS' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'...

Hi, i am running tomcat 4 with jdk5 on debian and am supposed to install a webapp. So i copied everything into a folder but when i try to access the webapp i get the following error (output from the respective log file): 2006-05-31 14:00:38 default: init 2006-05-31 14:00:38 DatabaseManager...

Hi everyone, i have a table with one field called "formulaId", another called "criterion" and another called "value". The thing is that for each formula, there are more criteria possible and of course more values as each criterion needs a value. For example: formulaId criterion value...

Hi everyone, i have a table with one field called "formulaId", another called "criterion" and another called "value". The thing is that for each formula, there are more criteria possible and of course more values as each criterion needs a value. For example: formulaId criterion value...

Hello everyone, i have mysql 4.0.24 database and one table with two datetime rows (from_time and to_time). Now i want to make sure that no new entry is "between" an already existing entry in from_time and to_time. How can i do that?

Hello everyone, i am using tomcat 4.1 and have the problem that everytime i try to start up the server/my webapp i get the following error message: java.lang.NoClassDefFoundError: org/apache/tomcat/util/log/Log at org.apache.jasper.servlet.JspServlet.<init>(Unknown Source) The strange...

Hello! Maybe i am going completely insane or i just can't see an error, but everytime i try to log in to a database i get an error message like this: Access denied for user: 'root@%' to database 'myDB'. What confuses me about it is the "%". All the data concerning the server, the password are...

Hello! Is there a possibility to compare DATETIME with DATE? It's because I have a table with DATETIME columns but at one point i need to filter the DATETIME entries according to a certain DATE. Thanks!