What is Gimble in SQL? Tried googling but no answer

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
myleow
Forum Contributor
Posts: 194
Joined: Mon Jun 21, 2004 7:05 pm
Location: California

What is Gimble in SQL? Tried googling but no answer

Post 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
User avatar
Ambush Commander
DevNet Master
Posts: 3698
Joined: Mon Oct 25, 2004 9:29 pm
Location: New Jersey, US

Post 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.
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

hmm... never heard of anything like that... what app is that query from?
myleow
Forum Contributor
Posts: 194
Joined: Mon Jun 21, 2004 7:05 pm
Location: California

Post 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.
User avatar
Ambush Commander
DevNet Master
Posts: 3698
Joined: Mon Oct 25, 2004 9:29 pm
Location: New Jersey, US

Post by Ambush Commander »

Yup. Do a code search and find all instances of GIMBLE. It probably is a magic keyword.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

are you sure it's not supposed to be GIMBAL ?

http://dictionary.reference.com/search?r=2&q=gimbal
User avatar
n00b Saibot
DevNet Resident
Posts: 1452
Joined: Fri Dec 24, 2004 2:59 am
Location: Lucknow, UP, India
Contact:

Post 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 :?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

gimble and gimbal, same pronounciation..
Sequalit
Forum Commoner
Posts: 75
Joined: Wed Oct 12, 2005 9:57 pm
Location: Texas

Post by Sequalit »

mabye he put it there just so he knows the data is from the server?

or probably just being silly.
User avatar
n00b Saibot
DevNet Resident
Posts: 1452
Joined: Fri Dec 24, 2004 2:59 am
Location: Lucknow, UP, India
Contact:

Post by n00b Saibot »

I'd take it as a keyword/place-holder entity which would be replaced somewhere in output...
Post Reply