Jump to content

Welcome to Rune Tips, the first ever RuneScape help site. We aim to offer skill guides, quest guides, maps, calculators, informative databases, tips, and much more to help you get the most from the Massive Online Adventure Game, RuneScape, by Jagex Ltd © 2009.

Report Ad

Welcome to Forum.Tip.It
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. If you already have an account, login here - otherwise create an account for free today!

Guthorm

Guthorm

Member Since 06 May 2006
Offline Last Active Aug 24 2012 11:37 AM

SQL update problem

02 September 2010 - 09:10 PM

So I am importing some excel files into the access database, the problem here is the format. For example in excel I would have a question that would say

Who are the presidents of US - Washington
- Adams

the answers would be in bullet form, when I imported the file into access the two separated bullet points split up into two different rows instead of staying in one cell. So I would have a row with one line of response but without a question.

So this is what I am doing right now

Update Sheet1 Set Response = Response + (Select Response from Sheet1 where question is null and id = id + 1);

Sheet1 is the table name, Response is the column I want to update, id is the column with the ids in numeric orders.

I am trying to update the response with the response column plus response column with two criteras. It should be the row below the question I want to update, hence the id + 1, and the question column of the response should be null which is the where question is null come from. Basically any response without a question should move one up and merge with the row above it.

Problem is I am getting errors, so I am curious as to what did I do wrong. I am pretty newbie to SQL and I need to finish updating the damn thing by tomorrow, otherwise I will be burried by all the work I have to do.

So any ideas?

wut is dis

31 August 2010 - 01:54 PM

Gah, I can't link it for some reason, it is under announcements, thread is called successmessage.

Keep reading the thread, the mod posted messages like this all over the place, I guess is some kind of hint?

qfc- 0-1-114-77985

Totally forgot about on the forum works :P

If mankind invented the teleporter...

27 August 2010 - 05:04 PM

This is really a random thought. Let's say somehow scientists invented a device that enables humans to teleport anywhere/any place they wish to be. Now let's pretend all the possible side effects such as easy assassinations, two people teleport in the exact same spot at the same time etc etc does not exist.

If there is a chance that you will die or hurt every time you use it, and let's say the chance is equal to the death/injure rate of car+train+plane(basic transportation) accidents, would you use it?

A void dance quest guide mistake

11 August 2010 - 07:23 PM

Prayer potions are very important during this battle as the guardian can drain your prayer and heal itself during the battle.

^That tip is counter-intuitive, if you drink the pot the knight will heal even MORE off you. It has being suggested to drain all your prayers before fighting the guardian. The crewbies might want to change that, unless there is something I do not know.

Jagex is closing down botsites

29 July 2010 - 06:17 PM

I saw a topic on RSOF about Jagex closing down botsites, so I did a google search and they seems to be right. Rsbot.org, one of the biggest bot site is shutdown. I took a screenshot

EDIT: http://www.wipo.int/...d2010-0680.html

This I believe is the take down process, taken from RSC.


Posted Image

Err, discuss?