[RESOLVED] UPDATE QUERY issue

dariuc

is it possible to do something like this?


"UPDATE `Persons` SET `Age` = `Age`+1
WHERE FirstName = 'Peter' AND LastName = 'Griffin'");

i don't think it is.

but i just thought i'd ask.

dagon

that should work as posted.

dariuc

ok thanks. I'll try it out.

dagon

you will probably get further if you actully try things before posting😉

dariuc

normally i do. but i dont remember ever studying anything about that.

it didnt work but i made my own workaround for it.

dagon

Does work. But if you prefer some other way, that's your call.

dariuc

"UPDATE `Persons` SET `Age` = `Age`+1

doesn't work for me.

but as i said it's not really a big deal. i figured out how to do what i want in a more roundabout way.

thanks neway

Weedpacket

dariuc wrote:
doesn't work for me.

Since I doubt the DBMS has a "dariuc_is_using_me" switch to disable this particular functionality, then the mistake is probably somewhere else in your code.

dariuc

i could do without your smart a** comments. thanks 🙂

I am sure I make mistakes quite often.
I'm also sure since your on the internet being a smart a** and condescending that you have NEVER done something so crazy as to mis-code or make a mistake.

Point blank IT didn't work for me, who cares why? that doesn't change the fact that when i tried it , it didnt work. He may be right and he knows how to implement it, but that also didn't change the fact that i already figured out a different way to do it.

You have an immature mindset if you feel the need to come here and post something like that, especially when you weren't even offering to help fix the problem.

The truth of the matter is i could do without you guys help altogether if ANYONE is going to be an a** about it and that's just point blank truth.

I simply asked a question. And it got met with a snide remark (why don't you actually try code first. How stupid does that even sound? I asked a question) Um.. because it's a question. Last time i checked it was neither illegal nor unconstitutional to ask one and also no one put a gun to either of your heads and made you reply. Nine times out of ten if i experimented on it first and did it wrong in all the ways i tried to implement it without knowing i was wrong to begin with i wouldn't learn ANYTHING.

If you wouldn't try to be negative from the get go people might just be more receptive to your responses. And in return you'd get alot LESS negative replies.

Weedpacket

Actually, the response was that what you wrote should work as given. If it doesn't work for you then the fault must be somewhere else in your code.

dariuc wrote:
Nine times out of ten if i experimented on it first and did it wrong in all the ways i tried to implement it without knowing i was wrong to begin with i wouldn't learn ANYTHING

That's how learning works.

Thomas Alva Edison wrote:
Genius is 1% inspiration and 99% perspiration

why don't you actually try code first. How stupid does that even sound? I asked a question

When looking through these forums before you posted you might have seen that this a very common response to your type of post. Usually trying it for yourself is a lot faster than posting and waiting for a response. (See also the second link in this post.)

you weren't even offering to help fix the problem.

You asked a question, you got an answer. It was a correct answer for the question that was given (it's not our fault if it was the wrong question). You said that it didn't work for you, for which the only rational explanation is that the problem isn't with what you asked but something else.

Point blank IT didn't work for me, who cares why?

Well, I certainly don't; dagon probably doesn't either. It's your code and you're the one who's responsible for it, so I presume you do.

Sorry to hear that you weren't able to learn what was wrong with your code, but I'm glad you managed to work around it.

no one put a gun to either of your heads and made you reply

Gee, maybe we do care. At least enough to answer.