Unusual Query Help Request

1001 Webs wrote:
> On Nov 11, 1:36 am, "Ana C. Dent" <anaced...@hotmail.com> wrote:
>> JerryStuckle <jstuck...@attglobal.net> wrote innews:57ydndMGpf3Tj6vanZ2dnUVZ_rzinZ2d@comcast.co m:
>>
>>
>>
>>> No, issue the DESCRIBE command for each table and paste the output here.
>> REDUNDANCY is the best way to teach idiots.
>> REDUNDANCY is the best way to teach idiots.
>> REDUNDANCY is the best way to teach idiots.
>> REDUNDANCY is the best way to teach idiots.
>> REDUNDANCY is the best way to teach idiots.
>> REDUNDANCY is the best way to teach idiots.
>>
>> You can lead some folks to knowledge, but you can't always make them think.
> Careful there, Ana.
> When left without arguments, Jerry will resort to beating you up as he
> did with his wife:
>
> Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
> Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
> Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE, JERRY D )
>
>

ROFLMAO! This troll is following me around all over the internet now!

For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
Spain. He thinks he's a web designer/developer, but he isn't.

He's just another troll. But he isn't even as smart as the hatter.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Nov 13, 1:41 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> 1001 Webs wrote:
> > On Nov 11, 1:36 am, "Ana C. Dent" <anaced...@hotmail.com> wrote:
> >> JerryStuckle <jstuck...@attglobal.net> wrote innews:57ydndMGpf3Tj6vanZ2dnUVZ_rzinZ2d@comcast.co m:
>
> >>> No, issue the DESCRIBE command for each table and paste the output here.
> >> REDUNDANCY is the best way to teach idiots.
> >> REDUNDANCY is the best way to teach idiots.
> >> REDUNDANCY is the best way to teach idiots.
> >> REDUNDANCY is the best way to teach idiots.
> >> REDUNDANCY is the best way to teach idiots.
> >> REDUNDANCY is the best way to teach idiots.
>
> >> You can lead some folks to knowledge, but you can't always make them think.
> > Careful there, Ana.
> > When left without arguments,Jerrywill resort to beating you up as he
> > did with his wife:
>
> > Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
> > Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
> > Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE,JERRYD )
>
> ROFLMAO! This troll is following me around all over the internet now!
>
> For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
> Spain. He thinks he's a web designer/developer, but he isn't.


Taxpayer Services Division

Entity Name: SMARTECH HOMES, INC.
Dept ID #: D07297567

Principal Office (Current): 9920 BRIXTON LANE, BETHESDA, MD 20817
Resident Agent (Current): JERRY D. STUCKLE, 9920 BRIXTON LANE,
BETHESDA, MD 20817

DEPT. ACTION - FORFEITURE 10/06/2006 12:03-AM
THE ENTITY WAS FORFEITED FOR FAILURE TO FILE PROPERTY RETURN FOR 2005.
For a Maryland entity, its existence has been ended by the State for
some delinquency.

Good Standing: No

-----------------------------------------------------
Kind Regards,

Rafael Martinez-Minuesa

www.1001webs.net
Puerto Marina, Benalmadena,
MALAGA - 29630
Spain
Phone: +34.620443347
EmailAddress: info-at-1001webs.net

1001 Webs wrote:
> On Nov 13, 1:41 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> 1001 Webs wrote:
>>> On Nov 11, 1:36 am, "Ana C. Dent" <anaced...@hotmail.com> wrote:
>>>> JerryStuckle <jstuck...@attglobal.net> wrote innews:57ydndMGpf3Tj6vanZ2dnUVZ_rzinZ2d@comcast.co m:
>>>>> No, issue the DESCRIBE command for each table and paste the output here.
>>>> REDUNDANCY is the best way to teach idiots.
>>>> REDUNDANCY is the best way to teach idiots.
>>>> REDUNDANCY is the best way to teach idiots.
>>>> REDUNDANCY is the best way to teach idiots.
>>>> REDUNDANCY is the best way to teach idiots.
>>>> REDUNDANCY is the best way to teach idiots.
>>>> You can lead some folks to knowledge, but you can't always make them think.
>>> Careful there, Ana.
>>> When left without arguments,Jerrywill resort to beating you up as he
>>> did with his wife:
>>> Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
>>> Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
>>> Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE,JERRYD )
>> ROFLMAO! This troll is following me around all over the internet now!
>>
>> For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
>> Spain. He thinks he's a web designer/developer, but he isn't.
>
>
> Taxpayer Services Division
>
> Entity Name: SMARTECH HOMES, INC.
> Dept ID #: D07297567
>
> Principal Office (Current): 9920 BRIXTON LANE, BETHESDA, MD 20817
> Resident Agent (Current): JERRY D. STUCKLE, 9920 BRIXTON LANE,
> BETHESDA, MD 20817
>
> DEPT. ACTION - FORFEITURE 10/06/2006 12:03-AM
> THE ENTITY WAS FORFEITED FOR FAILURE TO FILE PROPERTY RETURN FOR 2005.
> For a Maryland entity, its existence has been ended by the State for
> some delinquency.
>
> Good Standing: No
>
> -----------------------------------------------------
> Kind Regards,
>
> Rafael Martinez-Minuesa
>
> www.1001webs.net
> Puerto Marina, Benalmadena,
> MALAGA - 29630
> Spain
> Phone: +34.620443347
> EmailAddress: info-at-1001webs.net
>
>

ROFLMAO! Keep trying, loser!

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

cov wrote:
<snip>

There are several Business Intellegence tools like iReport and Pentaho Report
Designer that use a tool called SQLeonardo. It allows you to litterally drop and
drag to create your queries.

Once you get the queries you want you can just cut the SQL back into your PHP code.

http://www.jasperforge.org/jaspersof...gence/ireport/
or
http://www.pentaho.com/products/reporting/
but download from http://sourceforge.net/project/showf...roup_id=140317

On Mon, 12 Nov 2007 20:28:31 GMT, Michael Austin
<notknown@thistime.inf> wrote:


>now that we have seen you table definitions - there are several ways to
>possibly concatenate the colums when doing your searches like ANSI
>Standard concatenate using the double "pipe" symbol:
>
>area.conveyors||equipname.conveyors = area.motors||equipname.motors
>and area.conveyors||equipname.conveyors = area.equipcontacts ||
>equipname.equipcontacts "
>
>Also see the Mysql docs for concat statement.


Thank you very much - appreciate the help. :-)

On Tue, 13 Nov 2007 10:13:10 -0500, Walter Vaughan
<wvaughan@steelerubber.com> wrote:

>cov wrote:
><snip>
>
>There are several Business Intellegence tools like iReport and Pentaho Report
>Designer that use a tool called SQLeonardo. It allows you to litterally drop and
>drag to create your queries.
>
>Once you get the queries you want you can just cut the SQL back into your PHP code.
>
>http://www.jasperforge.org/jaspersof...gence/ireport/
> or
>http://www.pentaho.com/products/reporting/
>but download from http://sourceforge.net/project/showf...roup_id=140317

Pretty cool. Hey thank you very much. SQLeonardo looks pretty slick.