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
Posted: Tue Nov 08, 2005 12:43 am
by n00b Saibot
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...