August 2007 - users-list

[MonetDB-users] trading symbol
by Hollis Jankoed 15 Aug '07

15 Aug '07

1 0

[MonetDB-users] This is why MegaDik is the greatest breakthrough product in the history of male enhancement!
by Jaclyn Wade 15 Aug '07

15 Aug '07

We have mulitiple distribution centres around the world, and endever to get you your packet as quick as possable. All orders will be processed and dispatched within 24hrs. Your online shopping is safe & secure with EliteHerbal... also very discreet and private with no indication of penis enlargement on the bottle, package or billing receipt.http://kamsd.comWomen view men with a larger penis size as being more sexually attractive and sexually capable. An overall larger penis size also means a larger surface area, which stimulates more nerve endings, resulting in a more pleasurable experience for both you and your partner. A larger and more muscular penis is also more of a natural, visual turn on for women.

1 0

[MonetDB-users] New portfolio-monetdb-users
by Hae Robertsson 12 Aug '07

12 Aug '07

1 0

[MonetDB-users] Once you go beyond the three configurations above all bets are off.
by sajid nessler 11 Aug '07

11 Aug '07

H.u-g*e N+e.w*s To Impac t C*Y+T-V Chin_a Yo'uTV C+o.r.p-. Symbol_: C Y'T,V We h'a'v'e alre*ady s'e*e-n CYTV+'s mar-ket imp'act befo,re climb ,ing to o-v e.r $2.0-0 w i t h n+e w,s'. Pr,ess Release+: Chin_a YouTV+'s CnBo-o W-e'b S_i_t_e Ra-nks N o*.'1 on Micro,sof t L.i-v'e Sea rch En-gine CnBo+o Traf'fic Incre*,ases 4.9.% O-v'e_r T.w o M,onths R-e+a+d t+h e ne.ws, th.ink abou*t t-h,e impact , and j u,m.p on t,h i*s fi,rst th*ing Tom-o.rrow morni-ng_! $0.'42 is a g i+f_t at t'h i.s pric*e...... Do y'o-u,r homew''ork a'n d wa.tch t.h i*s t*rade Monda.y morn_ing.

1 0

[MonetDB-users] insert syntax in example
by Zoltan Tomory 10 Aug '07

10 Aug '07

The documentation examples at 3.1.6.1 have two variations: Insert into TABLE (COL, ...) values (COL*,...); which works where the values match the pattern of columns specified Insert into TABLE values (COL,...); which seems not to work Is this a typo in the documentation or have I committed a syntax error? Also, I have syntax question about something I have not tried out. If I have a column I use for Last Name, how could I insert 'O'Connell' as the field is delimited with single quotes? TIA Zoltan Tomory zoltan.tomory(a)mobot.org

2 1

[MonetDB-users] Connecting to MonetDB servers using JDBC
by Pradeep Gowda 10 Aug '07

10 Aug '07

Hi, I'm trying to connect to the Monetdb using Java on Linux (Ubuntu 7.04/i386). I used the example java program given on the MonetDB site. $ javac -cp jdbcclient-1.6.jar:. MJDBCTest.java $ java -cp jdbcclient-1.6.jar:. MJDBCTest I'm getting a persistent error:. Exception in thread "main" java.sql.SQLException: java.net.URISyntaxException: Expected scheme name at index 0: :monetdb://127.0.0.1:50002/mytest2?lang=sql&user=monetdb at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:217) at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:157) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at MJDBCTest.main(MJDBCTest.java:14) The Java code is attached below for reference: import java.sql.*;^M public class MJDBCTest {^M public static void main(String[] args) throws Exception {^M // make sure the driver is loaded^M Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");^M Connection con = DriverManager.getConnection("jdbc:monetdb://localhost/mytest2", "monetdb", "monetdb");^M Statement st = con.createStatement();^M ResultSet rs;^M ^M rs = st.executeQuery("SELECT * from foobar");^M // get meta data and print columns with their type^M ResultSetMetaData md = rs.getMetaData();^M for (int i = 1; i <= md.getColumnCount(); i++) {^M System.out.print(md.getColumnName(i) + ":" +^M md.getColumnTypeName(i) + "\t");^M }^M System.out.println("");^M // print the data: only the first 5 rows, while there probably are^M // a lot more. This shouldn't cause any problems afterwards since the^M // result should get properly discarded on the next query^M for (int i = 0; rs.next() && i < 5; i++) {^M for (int j = 1; j <= md.getColumnCount(); j++) {^M System.out.print(rs.getString(j) + "\t");^M }^M System.out.println("");^M }^M ^M // tell the driver to only return 5 rows, it can optimize on this^M // value, and will not fetch any more than 5 rows.^M //st.setMaxRows(5);^M // we ask the database for 22 rows, while we set the JDBC driver to^M // 5 rows, this shouldn't be a problem at all...^M rs = st.executeQuery("select * from foobar limit 2");^M // read till the driver says there are no rows left^M for (int i = 0; rs.next(); i++) {^M System.out.print("[" + rs.getString(1) + "]");^M System.out.print("[" + rs.getString(2) + "]\n");^M ^M }^M con.close();^M }^M } -- Home: http://btbytes.com Heart: http://sampada.net

2 7

[MonetDB-users] Magic stick
by Isaac Romo 10 Aug '07

10 Aug '07

1 0

[MonetDB-users] (no subject)
by lilaben Lovett 09 Aug '07

09 Aug '07

LIVE FROM THE STREET! Sym: (P R T H) Price: .088 Announces the Opening of Two New Stores by (P.I.NKSH.E.ETS: P R T H) is pleased to announce that Puerto Rico 7, Inc. has opened two new stores. The stores are recorded as Pinero II and Borinquen Towers. Both locations were researched demographically to deliver above average sales due to high traffic streets and communities directly surrounding the stores. The Management team believes that the stores will each quickly reach an annualized run rate of 1.2 Million dollars of sales. IMAGINE IF YOU HAD THE CHANCE TO BUY A WAL-MART FRANCHISE IN MEXICO RIGHT WHEN IT FIRST OPENED ITS DOORS THERE AND ALL YOU NEEDED WAS A SMALL STAKE TO GET IN. Hurry, we see this stock starting to make the turn NOW.

1 0

[MonetDB-users] How do I access new database?
by Zoltan Tomory 08 Aug '07

08 Aug '07

It's been a while since I used SQL. I created a database using CREATE SCHEMA CAT1; I thought I used to use USE CAT1; to get into a database, but MonetDB did not like it. I confirmed creation of the schema with SELECT * FROM SCHEMAS; What am I doing wrong? Zoltan Tomory zoltan.tomory(a)mobot.org

2 1

[MonetDB-users] local time zone
by Colin Foss 08 Aug '07

08 Aug '07

How can I configure the local time zone for MonetDB? Upon login, "select current_timezone" returns 0. set time zone local always resets the offset to 0. Can I change this to follow my server's GMT offset including DST?

2 3