Topic awaiting preservation: Stored procedure questions (Page 1 of 1)

Hey all,

I've got a table with a varchar field... is it possible to store a "stored procedure" within the varchar? Say something simple like NOW(); and upon selecting I would get the current date? I guess I'm just a little confused on how to call the procedures...

edit2: whew, having a rough day... using MySql 5 btw.
edit: I can't spell either... if someone wants to fix my post title that would be great, mucho thanks

(Edited by redroy on 07-15-2008 23:58)

(Edited by redroy on 07-16-2008 02:57)

uh... I have a gut feeling that your concepts are of on serveral levels .

First, I believe a stored procedure is something that you run instead of a complete query.
Second, The whole point of it is being compiled - something that wouldn't be possible if it was 'stored in a varchar'.
Third, when would you want this to be run? When the row's read? Or when it's stored?
Fourth, You can simple select *, now() as currentTime from table; - not that it makes much sense with the current time though.

Hope this allivates some of your problems,
so long,

->Tyberius Prime

You could also create TIMESTAMP or DATETIME fields in the record if you are trying to keep track of when the record was created or modified.

.



-- not necessarily stoned... just beautiful.

SET s = [YOUR QUERY TO GET YOUR STATEMENT]

PREPARE stmt1 FROM @s;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;

The above is just a guess never actually tried that.

Dan
Code Town | Zombie Head | How Much TP? | Feed The Blob

warmage: and 100% against everything stored procedures are actually meant for - at least if you do this each time

Yes, but Redroy just asked how to do it, not what the best practice would be.

Redroy, if you were to elaborate on the problem you are trying to solve there will most likely be a better way to address it, as TP has said it is pretty bad practice, and potentially very dangerous.

Dan
Code Town | Zombie Head | How Much TP? | Feed The Blob

After further looking into my "problem", which is basically working on a badly thought out and coded website, I'm thinking I'll save much grief by overhauling now. When I get a chance though I'd like to get back and pick your brains on this topic though (as obviously I haven't a clue).