Page 1 of 1

What is Gimble in SQL? Tried googling but no answer

Posted: Mon Nov 07, 2005 2:17 pm
by myleow
What is Gimble in SQL? I found this in a code that i am maintaining and there aren't any documentation on it.

Code: Select all

$sql="insert into discussion
 (author_name,
 author_email,
 message,
 subject)
 values
 ('$author_name GIMBLE',
 '$author_email GIMBLE',
 '$message GIMBLE',
 '$subject GIMBLE')";
Its just an INSERT statement, and its for MySQL 4.0

Posted: Mon Nov 07, 2005 2:22 pm
by Ambush Commander
Well, what the SQL would expand to would be

Code: Select all

$author_name = 'Mr. Wiggles';
$author_name = 'wiggles@example.com';
$message = 'Hi everybody! This is a great forum!';
$subject = 'Hello World';
$sql="insert into discussion
 (author_name,
 author_email,
 message,
 subject)
 values
 ('$author_name GIMBLE',
 '$author_email GIMBLE',
 '$message GIMBLE',
 '$subject GIMBLE')";
echo $sql;

Code: Select all

insert into discussion
 (author_name,
 author_email,
 message,
 subject)
 values
 ('Mr. Wiggles GIMBLE',
 'wiggles@example.com GIMBLE',
 'Hi everybody! This is a great forum! GIMBLE',
 'Hello World GIMBLE')
So literally, you store whatever the string is, plus GIMBLE at the very end. It doesn't make much sense though.

Posted: Mon Nov 07, 2005 2:25 pm
by Weirdan
hmm... never heard of anything like that... what app is that query from?

Posted: Mon Nov 07, 2005 4:52 pm
by myleow
Custom app for a company i work for. Its passed down from a previous programmer so i have no clue what it is. But i am guessing that it has nothing to do with SQL.

Posted: Mon Nov 07, 2005 4:53 pm
by Ambush Commander
Yup. Do a code search and find all instances of GIMBLE. It probably is a magic keyword.

Posted: Mon Nov 07, 2005 7:08 pm
by feyd
are you sure it's not supposed to be GIMBAL ?

http://dictionary.reference.com/search?r=2&q=gimbal

Posted: Tue Nov 08, 2005 12:43 am
by n00b Saibot
feyd wrote:are you sure it's not supposed to be GIMBAL ?

http://dictionary.reference.com/search?r=2&q=gimbal
how does that connect to code here :?

Posted: Tue Nov 08, 2005 12:49 am
by feyd
gimble and gimbal, same pronounciation..

Posted: Tue Nov 08, 2005 1:08 am
by Sequalit
mabye he put it there just so he knows the data is from the server?

or probably just being silly.

Posted: Tue Nov 08, 2005 2:55 am
by n00b Saibot
I'd take it as a keyword/place-holder entity which would be replaced somewhere in output...