Comments by tokano (Top 18 by date)

I still have a question here. What if some rows already have the value which is the same as in the other row and i would like to overwrite it, not cumulate it (sum). What could i do then?

Here is the picture of what i mean:

http://shrani.si/f/3g/F0/zA1BEAY/untitled.png

See those two rows having the same time, but some values are in the second row also. I would like to merge them.

Thanks for your answer. I've run it and it actually done what it should, many thanx! I've been looking into the SUM function, and i dont understand it well. Doesnt sum (summa) cumulate those numbers then?

Edit: i see it actually does, doesnt it? But the other columns joined are empty, therefore no value is changed. Am i right?

Oh thank you very much! Can i ask you to edit your solution a bit, because so many "&" and quotes are in, i'm getting confused.

Is also there any way to join two sql querys? Because first i order them by date and time, then i want to execute the query u wrote.

Thnx

P.s.: And how can i continue if u have more then 2 columns as shown on the picture?

From sample as s1
inner join sample as s2
inner join sample as s3...etc?

edit : thank for your contribution, but the statement with SUM and group BY is easier for me, and does the same work!

Right on Griff! :) Works like a charm. Its not faster on my case, cause i have to loop trought records, but, it fill the whole CSV to the database without errors! Thank you very much!

I see where this is going, 1 million records? Nice, just the thing i need. I will analyze the code and try to implement it in my project. Thanx for the link. I will report back for results!

Greets

I have tried it this way but the error is still there. The first time i've programmed the function it went to 340k entries. So 100k missing, no error till there! But now the error appears sooner..

The problem is still there, huh :(

Well the picture i gave you, gives me the 3D feeling.

This one: http://static.usenix.org/event/usenix05/tech/freenix/full_papers/kirsch/kirsch_html/img/street.jpg

I dont want all the fancy texture and red dots..just the road in this kind of perspective.. What i get is in the first post, the first picture.

No problem about the answer..

Well, i do not know what should i FIX to make my road look like 3D. I just pointed out two of the things i might have the problem with. Maybe the solution is a third one. I thought that if i get draw the x y z coordinates, everything will be ok from that point on..but nope..it looks like 2D:S

Well yes, maybe i will have to draw different things..but the question is still simple. How to get this '3D LOOK' on the road i am drawing.. I got all the 3 coordinates, still the object looks like 2D. There is something i am not doing right..and any help in this direction would be usefull..

Maybe i am just searching for someone to push me in one direction i should search for the solution..

Exactly!

Thank you both very much, for help! I hope i'll be meeting you guys more with answers and questions:)

Here is the picture, what is drawn when going trough the loop.

http://postimage.org/image/mqf9h21op/

It's definitly not what i'm looking for. It should be more then one line:)) And you can see on the picture how i need to change the camera (translate) to see my drawn object.

Now when i've read the answer from Marcus Kramer, i found out that something has happened! I'm on the right track now! Here are the results!

http://postimage.org/image/urhg4phbj/

I think the whole problem was, that i had initiated the begin and end in the loop, and that's why it always "RESET" the other lines..and eventually showed just the last one.

Well i got gauss krueger coordinates stored in a txt file, from a "walk" i made. After reading the txt file i store these coordinates in a two dimensional array.

Example:
<pre lang='cs'>
coordinate[0,0] = x
coordinate[0,1] = y
coordinate[0,2] = z</pre>

And then
<pre lang='cs'>
coordinate[1,0] = x
coordinate[1,1] = y
coordinate[1,2] = z</pre> ...and so on!

So i want now to place every single 'dot' of this into <pre lang='cs'>Gl.glVertex3f(float x, float y, float z)</pre>

I use <pre>Gl.glBegin(Gl.GL_LINE_STRIP);<pre>

And after all this done in a loop, a terain connected with all these dots and lines should show up.

I hope i've give more information then before! Thnx for replying!

I do know, but when i make my while statement it doesnt want to draw the result. It just makes one line, not all of them