Very difficult dtabase query - EXPERTS ONLY!

Report · May 26, 2006

I have very large database (about 50 records!!) and I must perform query
that I cannot do even though I have lots of experience. Here it is:
I must get all the data from a record where the record ID (ID) is 39. This
must get ALL data attached to this record.
I have been awake all night trying this and it will not work. Would a fellow
expert please help me please. EXPERTS ONLY - NO NOVICE.

Thanks.

My moto - If your best is not good enough then try even better, or go and
drink lots and lots of alcohol. If that does not work then do both together
XX.

Report · May 26, 2006

You can't possibly have a database with that many records. Of course it won't work. And 39 is a reserved word so fogedaboutit

Report · May 26, 2006

SELECT *
FROM theTable
WHERE theID=39

"THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
news:e56i9c$rpg$1@forums.macromedia.com...
>I have very large database (about 50 records!!) and I must perform query
>that I cannot do even though I have lots of experience. Here it is:
> I must get all the data from a record where the record ID (ID) is 39. This
> must get ALL data attached to this record.
> I have been awake all night trying this and it will not work. Would a
> fellow expert please help me please. EXPERTS ONLY - NO NOVICE.
>
> Thanks.
>
> My moto - If your best is not good enough then try even better, or go and
> drink lots and lots of alcohol. If that does not work then do both
> together XX.
>

Report · May 26, 2006

Hello Mr DownWithBugs. Thank you for your kindest reply but this does not
work. This is the reason I ask for Expert and not novice. Only expert such
as myself can help me with this question. Your experiences in web dev are
obviously limited and your knowledge is not enough to help me here. I ask
again - EXPERTS ONLY PLEASE. NO NOVICES SUCH AS MR DOWNWITHBUGS. Thankyou
for your attention.

My moto - If your best is not good enough then try even better, or go and
drink lots and lots of alcohol. If that does not work then do both together
XX.

"DownWithBugs" <Bugs@TMM.com> wrote in message
news:e570ct$fmc$1@forums.macromedia.com...
> SELECT *
> FROM theTable
> WHERE theID=39
>
>
> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
> news:e56i9c$rpg$1@forums.macromedia.com...
>>I have very large database (about 50 records!!) and I must perform query
>>that I cannot do even though I have lots of experience. Here it is:
>> I must get all the data from a record where the record ID (ID) is 39.
>> This must get ALL data attached to this record.
>> I have been awake all night trying this and it will not work. Would a
>> fellow expert please help me please. EXPERTS ONLY - NO NOVICE.
>>
>> Thanks.
>>
>> My moto - If your best is not good enough then try even better, or go and
>> drink lots and lots of alcohol. If that does not work then do both
>> together XX.
>>
>
>

Report · May 26, 2006

Note - I am deeply suspicious about the OP here. Answer at your own risk.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
news:e573f0$jl1$1@forums.macromedia.com...
> Hello Mr DownWithBugs. Thank you for your kindest reply but this does not
> work. This is the reason I ask for Expert and not novice. Only expert such
> as myself can help me with this question. Your experiences in web dev are
> obviously limited and your knowledge is not enough to help me here. I ask
> again - EXPERTS ONLY PLEASE. NO NOVICES SUCH AS MR DOWNWITHBUGS. Thankyou
> for your attention.
>
> My moto - If your best is not good enough then try even better, or go and
> drink lots and lots of alcohol. If that does not work then do both
> together XX.
>
> "DownWithBugs" <Bugs@TMM.com> wrote in message
> news:e570ct$fmc$1@forums.macromedia.com...
>> SELECT *
>> FROM theTable
>> WHERE theID=39
>>
>>
>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>> news:e56i9c$rpg$1@forums.macromedia.com...
>>>I have very large database (about 50 records!!) and I must perform query
>>>that I cannot do even though I have lots of experience. Here it is:
>>> I must get all the data from a record where the record ID (ID) is 39.
>>> This must get ALL data attached to this record.
>>> I have been awake all night trying this and it will not work. Would a
>>> fellow expert please help me please. EXPERTS ONLY - NO NOVICE.
>>>
>>> Thanks.
>>>
>>> My moto - If your best is not good enough then try even better, or go
>>> and drink lots and lots of alcohol. If that does not work then do both
>>> together XX.
>>>
>>
>>
>
>

Report · May 26, 2006

Fellow expert,

The answer provided was exactly correct for the question you asked. So
perhaps you're not providing enough detail or are not using the proper
terminology. So, I'll ask a few questions in return:

What database system are you using?
How many tables are in that database?
How many rows/records are in each table that you're trying to recover?
Does your database support views?
If you're trying to get data from multiple tables, have you tried using
INNER JOIN?

A few more details would be helpful.

Best regards,
Chris

Report · May 26, 2006

'Tis indeed possible ;-)

~C

Report · May 26, 2006

Yes, it's obvious now.

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:e573ik$jsp$1@forums.macromedia.com...
> Note - I am deeply suspicious about the OP here. Answer at your own risk.
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> http://www.dreamweavermx-templates.com - Template Triage!
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
> ==================
>
>
> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message

Report · May 26, 2006

Hello Mr Chris in Madison,

I ask question and you answer with question when I need answer. To be
oblijing I will answer your question.

What database system are you using? The one on my PC
How many tables are in that database? I don't understand
How many rows/records are in each table that you're trying to recover? as
above
Does your database support views? Yes, I can see it clearly
If you're trying to get data from multiple tables, have you tried using
INNER JOIN? No

Now that is out of the way would someone who is expert like myself please
help with my question instead of pretending they are helping in order to
look like expert. This is big big problem for me and I need to find an anser
to create this application that will pay me good money. I have long history
with web dev but cannot answer this. If it is too difficult for you kind
people here then please say and I will go to a no-novice forum where good
developers will answer this question I am sure. I am sure some kind person
with experiences like myself can help me with this.

Thankyou.

"Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in message
news:e5745k$km8$1@forums.macromedia.com...
> Fellow expert,
>
> The answer provided was exactly correct for the question you asked. So
> perhaps you're not providing enough detail or are not using the proper
> terminology. So, I'll ask a few questions in return:
>
> What database system are you using?
> How many tables are in that database?
> How many rows/records are in each table that you're trying to recover?
> Does your database support views?
> If you're trying to get data from multiple tables, have you tried using
> INNER JOIN?
>
> A few more details would be helpful.
>
> Best regards,
> Chris
>

Report · May 26, 2006

Bye bye now, it's been fun...

~C

Report · May 26, 2006

Try http://www.sqlteam.com/. I'm sure they'll be very helpful for an expert
such as yourself.

~C

Report · May 26, 2006

Thanks, Chris! I hadn't seen this one .. not sure where I've been since I
see they celebrated 5 years last summer! Bookmarked it tho.

I saw the original post in this thread very early this morning .. gave me a
good laugh from the point where I read that "50 records was a very large
database" .. with two exclamation points! lol.

Have a good holiday weekend!

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in message
news:e576e6$ngq$1@forums.macromedia.com...
> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for an
> expert such as yourself.
>
> ~C
>

Report · May 26, 2006

Why do you treat me with such hostileity Mr Chris in Madison? I only want
answer to my question. I am very tired as I have tried to solve my mystery
all day and night and need some help from fellow expert. I am not a stupid
person. Since moving here 3 years ago I teach myself 4 languages and evern
am developing my own language for programming. This will be very succesful
and make me a lot of money. Until then I need to webdev to make a living and
I am very good at it.

As you can see I am no novice but even the best need help. Please help me
someone who can.

My moto - If your best is not good enough then try even better, or go and
drink lots and lots of alcohol. If that does not work then do both together
XX.

"Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in message
news:e576e6$ngq$1@forums.macromedia.com...
> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for an
> expert such as yourself.
>
> ~C
>

Report · May 26, 2006

Mr Chris in Madison, now I see your meaing of your question. My database is
called Excel. Please help me experts.

Thankyou.

"THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
news:e576p9$nvo$1@forums.macromedia.com...
> Why do you treat me with such hostileity Mr Chris in Madison? I only want
> answer to my question. I am very tired as I have tried to solve my mystery
> all day and night and need some help from fellow expert. I am not a stupid
> person. Since moving here 3 years ago I teach myself 4 languages and evern
> am developing my own language for programming. This will be very succesful
> and make me a lot of money. Until then I need to webdev to make a living
> and I am very good at it.
>
> As you can see I am no novice but even the best need help. Please help me
> someone who can.
>
> My moto - If your best is not good enough then try even better, or go and
> drink lots and lots of alcohol. If that does not work then do both
> together
> XX.
>
> "Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in message
> news:e576e6$ngq$1@forums.macromedia.com...
>> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for an
>> expert such as yourself.
>>
>> ~C
>>
>
>

Report · May 26, 2006

Excel is a spreadsheet program .. not a database program. While it is
possible to use Excel with the appropriate driver, it is not recommended.

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
news:e577lj$p76$1@forums.macromedia.com...
> Mr Chris in Madison, now I see your meaing of your question. My database
> is called Excel. Please help me experts.
>
> Thankyou.
>
> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
> news:e576p9$nvo$1@forums.macromedia.com...
>> Why do you treat me with such hostileity Mr Chris in Madison? I only want
>> answer to my question. I am very tired as I have tried to solve my
>> mystery all day and night and need some help from fellow expert. I am not
>> a stupid person. Since moving here 3 years ago I teach myself 4 languages
>> and evern am developing my own language for programming. This will be
>> very succesful and make me a lot of money. Until then I need to webdev to
>> make a living and I am very good at it.
>>
>> As you can see I am no novice but even the best need help. Please help me
>> someone who can.
>>
>> My moto - If your best is not good enough then try even better, or go and
>> drink lots and lots of alcohol. If that does not work then do both
>> together
>> XX.
>>
>> "Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in
>> message news:e576e6$ngq$1@forums.macromedia.com...
>>> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for an
>>> expert such as yourself.
>>>
>>> ~C
>>>
>>
>>
>
>

Report · May 26, 2006

dude, an expert you're not. that's a starting point. you will also need
to stop assuming people don't know what they're talking about when you post
a question.

excel is not a database. if you're using excel, you need to quit and start
researching databases. I would suggest MySQL as it's simple and free.
Excel is very difficult to work with and is by no means meant for web
display, though it is possible.

you will need a webserver installed on your machine, for this I would
suggest XAMPP as it will install PHP 4 & 5 & MySQL in a one click install. A
web server is what is going to "translate" your code into a visable web
page.

FYI, a "large" database will contain a hundred tables and millions of
records. 50 records is an array. ;o)

if you need more help, drop your attitude, find some humility and I'm sure
people will be more than happy to help you.

Report · May 26, 2006

I am wrong. It is called SQL Sever edition 6.5. So sorry.
Are you an expert Nancy? Can you help please?

"Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
news:e57844$pno$1@forums.macromedia.com...
> Excel is a spreadsheet program .. not a database program. While it is
> possible to use Excel with the appropriate driver, it is not recommended.
>
>
> --
> Nancy Gill
> Adobe Community Expert
> BLOG: http://www.dmxwishes.com/blog.asp
> Author: Dreamweaver 8 e-book for the DMX Zone
> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
> Beginner's
> Guide, Mastering Macromedia Contribute
> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
> Development
>
>
> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
> news:e577lj$p76$1@forums.macromedia.com...
>> Mr Chris in Madison, now I see your meaing of your question. My database
>> is called Excel. Please help me experts.
>>
>> Thankyou.
>>
>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>> news:e576p9$nvo$1@forums.macromedia.com...
>>> Why do you treat me with such hostileity Mr Chris in Madison? I only
>>> want answer to my question. I am very tired as I have tried to solve my
>>> mystery all day and night and need some help from fellow expert. I am
>>> not a stupid person. Since moving here 3 years ago I teach myself 4
>>> languages and evern am developing my own language for programming. This
>>> will be very succesful and make me a lot of money. Until then I need to
>>> webdev to make a living and I am very good at it.
>>>
>>> As you can see I am no novice but even the best need help. Please help
>>> me someone who can.
>>>
>>> My moto - If your best is not good enough then try even better, or go
>>> and
>>> drink lots and lots of alcohol. If that does not work then do both
>>> together
>>> XX.
>>>
>>> "Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in
>>> message news:e576e6$ngq$1@forums.macromedia.com...
>>>> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for an
>>>> expert such as yourself.
>>>>
>>>> ~C
>>>>
>>>
>>>
>>
>>
>
>

Report · May 26, 2006

Mr Crash.

It is indeed you who has a problem. Ha Ha, (that is me laughing at your
attempt to understand Webdev). It is obvious to all that you know nothing
about webdev and so out of your frustration you like to kick and belittle a
true expert such as myself. My suggestion to you is to go away and do some
reading. Learn a little about what you pretend to know well. Your name
indeed is like your person. You are like a car crash - very harmfull!!!! Ha
ha ha ha ha ha ha.

Also, my name is not dude. I don't know any person by this name. Perhaps you
confuse me with someone else. This is good example of how frustrated you
are. Go and lie down for a while on a bed.

"crash" <crash@bcdcdigital.com> wrote in message
news:e578da$q5b$1@forums.macromedia.com...
> dude, an expert you're not. that's a starting point. you will also need
> to stop assuming people don't know what they're talking about when you
> post a question.
>
> excel is not a database. if you're using excel, you need to quit and
> start researching databases. I would suggest MySQL as it's simple and
> free. Excel is very difficult to work with and is by no means meant for
> web display, though it is possible.
>
> you will need a webserver installed on your machine, for this I would
> suggest XAMPP as it will install PHP 4 & 5 & MySQL in a one click install.
> A web server is what is going to "translate" your code into a visable web
> page.
>
> FYI, a "large" database will contain a hundred tables and millions of
> records. 50 records is an array. ;o)
>
> if you need more help, drop your attitude, find some humility and I'm sure
> people will be more than happy to help you.
>
>

Report · May 26, 2006

SQL Server 6.5 is VERY old .. after that was 7 and then 2000 and now 2005.
However .. I'm sure it will work (though I have never used that edition).
Are you able to connect successfully to the database?

As for your query, it's a simple one filter query on the ID number .. Down
with Bugs already gave you the code to make it work.

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"THE WEBDEV KING" <DONOTEMAILME@ME.COM> wrote in message
news:e578er$q73$1@forums.macromedia.com...
>I am wrong. It is called SQL Sever edition 6.5. So sorry.
> Are you an expert Nancy? Can you help please?
>
> "Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
> news:e57844$pno$1@forums.macromedia.com...
>> Excel is a spreadsheet program .. not a database program. While it is
>> possible to use Excel with the appropriate driver, it is not recommended.
>>
>>
>> --
>> Nancy Gill
>> Adobe Community Expert
>> BLOG: http://www.dmxwishes.com/blog.asp
>> Author: Dreamweaver 8 e-book for the DMX Zone
>> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
>> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
>> Beginner's
>> Guide, Mastering Macromedia Contribute
>> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
>> Development
>>
>>
>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>> news:e577lj$p76$1@forums.macromedia.com...
>>> Mr Chris in Madison, now I see your meaing of your question. My database
>>> is called Excel. Please help me experts.
>>>
>>> Thankyou.
>>>
>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>> news:e576p9$nvo$1@forums.macromedia.com...
>>>> Why do you treat me with such hostileity Mr Chris in Madison? I only
>>>> want answer to my question. I am very tired as I have tried to solve my
>>>> mystery all day and night and need some help from fellow expert. I am
>>>> not a stupid person. Since moving here 3 years ago I teach myself 4
>>>> languages and evern am developing my own language for programming. This
>>>> will be very succesful and make me a lot of money. Until then I need to
>>>> webdev to make a living and I am very good at it.
>>>>
>>>> As you can see I am no novice but even the best need help. Please help
>>>> me someone who can.
>>>>
>>>> My moto - If your best is not good enough then try even better, or go
>>>> and
>>>> drink lots and lots of alcohol. If that does not work then do both
>>>> together
>>>> XX.
>>>>
>>>> "Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in
>>>> message news:e576e6$ngq$1@forums.macromedia.com...
>>>>> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for an
>>>>> expert such as yourself.
>>>>>
>>>>> ~C
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Report · May 26, 2006

I try the code from Mr DownWithTheBugs and it doesnot work
SELECT *
FROM theTable
WHERE theID=39
I have nothing called * in my database and also nothing called theTable so I
know from this that he is not an expert just like Mr Chris In Madison and Mr
CarCrash (hehe). They are very angry people, not like you Mrs Nancy *Adobe
Community Expert who is kind and generous and willing to listen to a fellow
expert who is needing help. Did I tell you I know 4 languages? I think I
did.
Can you help please kind Mrs Nancy *Adobe Community Expert?

"Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
news:e578ui$qs5$1@forums.macromedia.com...
> SQL Server 6.5 is VERY old .. after that was 7 and then 2000 and now 2005.
> However .. I'm sure it will work (though I have never used that edition).
> Are you able to connect successfully to the database?
>
> As for your query, it's a simple one filter query on the ID number .. Down
> with Bugs already gave you the code to make it work.
>
>
> --
> Nancy Gill
> Adobe Community Expert
> BLOG: http://www.dmxwishes.com/blog.asp
> Author: Dreamweaver 8 e-book for the DMX Zone
> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
> Beginner's
> Guide, Mastering Macromedia Contribute
> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
> Development
>
>
> "THE WEBDEV KING" <DONOTEMAILME@ME.COM> wrote in message
> news:e578er$q73$1@forums.macromedia.com...
>>I am wrong. It is called SQL Sever edition 6.5. So sorry.
>> Are you an expert Nancy? Can you help please?
>>
>> "Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
>> news:e57844$pno$1@forums.macromedia.com...
>>> Excel is a spreadsheet program .. not a database program. While it is
>>> possible to use Excel with the appropriate driver, it is not
>>> recommended.
>>>
>>>
>>> --
>>> Nancy Gill
>>> Adobe Community Expert
>>> BLOG: http://www.dmxwishes.com/blog.asp
>>> Author: Dreamweaver 8 e-book for the DMX Zone
>>> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
>>> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
>>> Beginner's
>>> Guide, Mastering Macromedia Contribute
>>> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
>>> Development
>>>
>>>
>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>> news:e577lj$p76$1@forums.macromedia.com...
>>>> Mr Chris in Madison, now I see your meaing of your question. My
>>>> database is called Excel. Please help me experts.
>>>>
>>>> Thankyou.
>>>>
>>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>>> news:e576p9$nvo$1@forums.macromedia.com...
>>>>> Why do you treat me with such hostileity Mr Chris in Madison? I only
>>>>> want answer to my question. I am very tired as I have tried to solve
>>>>> my mystery all day and night and need some help from fellow expert. I
>>>>> am not a stupid person. Since moving here 3 years ago I teach myself 4
>>>>> languages and evern am developing my own language for programming.
>>>>> This will be very succesful and make me a lot of money. Until then I
>>>>> need to webdev to make a living and I am very good at it.
>>>>>
>>>>> As you can see I am no novice but even the best need help. Please help
>>>>> me someone who can.
>>>>>
>>>>> My moto - If your best is not good enough then try even better, or go
>>>>> and
>>>>> drink lots and lots of alcohol. If that does not work then do both
>>>>> together
>>>>> XX.
>>>>>
>>>>> "Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in
>>>>> message news:e576e6$ngq$1@forums.macromedia.com...
>>>>>> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for an
>>>>>> expert such as yourself.
>>>>>>
>>>>>> ~C
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Report · May 26, 2006

It was a generic example. Because DownWithBugs did not know what you called
your tables and columns, he used "theTable" and you have to substitute the
name of your real table for that value.

* means everything from the table .. all columns. It's a shorthand way of
saying it so you don't have to type all the names of all the columns in your
database table.

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"THE WEBDEV KING" <DONOTEMAILME@ME.COM> wrote in message
news:e579eg$rij$1@forums.macromedia.com...
>I try the code from Mr DownWithTheBugs and it doesnot work
> SELECT *
> FROM theTable
> WHERE theID=39
> I have nothing called * in my database and also nothing called theTable so
> I know from this that he is not an expert just like Mr Chris In Madison
> and Mr CarCrash (hehe). They are very angry people, not like you Mrs Nancy
> *Adobe Community Expert who is kind and generous and willing to listen to
> a fellow expert who is needing help. Did I tell you I know 4 languages? I
> think I did.
> Can you help please kind Mrs Nancy *Adobe Community Expert?
>
> "Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
> news:e578ui$qs5$1@forums.macromedia.com...
>> SQL Server 6.5 is VERY old .. after that was 7 and then 2000 and now
>> 2005. However .. I'm sure it will work (though I have never used that
>> edition). Are you able to connect successfully to the database?
>>
>> As for your query, it's a simple one filter query on the ID number ..
>> Down with Bugs already gave you the code to make it work.
>>
>>
>> --
>> Nancy Gill
>> Adobe Community Expert
>> BLOG: http://www.dmxwishes.com/blog.asp
>> Author: Dreamweaver 8 e-book for the DMX Zone
>> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
>> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
>> Beginner's
>> Guide, Mastering Macromedia Contribute
>> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
>> Development
>>
>>
>> "THE WEBDEV KING" <DONOTEMAILME@ME.COM> wrote in message
>> news:e578er$q73$1@forums.macromedia.com...
>>>I am wrong. It is called SQL Sever edition 6.5. So sorry.
>>> Are you an expert Nancy? Can you help please?
>>>
>>> "Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
>>> news:e57844$pno$1@forums.macromedia.com...
>>>> Excel is a spreadsheet program .. not a database program. While it is
>>>> possible to use Excel with the appropriate driver, it is not
>>>> recommended.
>>>>
>>>>
>>>> --
>>>> Nancy Gill
>>>> Adobe Community Expert
>>>> BLOG: http://www.dmxwishes.com/blog.asp
>>>> Author: Dreamweaver 8 e-book for the DMX Zone
>>>> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
>>>> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
>>>> Beginner's
>>>> Guide, Mastering Macromedia Contribute
>>>> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
>>>> Development
>>>>
>>>>
>>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>>> news:e577lj$p76$1@forums.macromedia.com...
>>>>> Mr Chris in Madison, now I see your meaing of your question. My
>>>>> database is called Excel. Please help me experts.
>>>>>
>>>>> Thankyou.
>>>>>
>>>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>>>> news:e576p9$nvo$1@forums.macromedia.com...
>>>>>> Why do you treat me with such hostileity Mr Chris in Madison? I only
>>>>>> want answer to my question. I am very tired as I have tried to solve
>>>>>> my mystery all day and night and need some help from fellow expert. I
>>>>>> am not a stupid person. Since moving here 3 years ago I teach myself
>>>>>> 4 languages and evern am developing my own language for programming.
>>>>>> This will be very succesful and make me a lot of money. Until then I
>>>>>> need to webdev to make a living and I am very good at it.
>>>>>>
>>>>>> As you can see I am no novice but even the best need help. Please
>>>>>> help me someone who can.
>>>>>>
>>>>>> My moto - If your best is not good enough then try even better, or go
>>>>>> and
>>>>>> drink lots and lots of alcohol. If that does not work then do both
>>>>>> together
>>>>>> XX.
>>>>>>
>>>>>> "Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in
>>>>>> message news:e576e6$ngq$1@forums.macromedia.com...
>>>>>>> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for
>>>>>>> an expert such as yourself.
>>>>>>>
>>>>>>> ~C
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Report · May 26, 2006

You guys are being strung along....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"THE WEBDEV KING" <DONOTEMAILME@ME.COM> wrote in message
news:e579eg$rij$1@forums.macromedia.com...
>I try the code from Mr DownWithTheBugs and it doesnot work
> SELECT *
> FROM theTable
> WHERE theID=39
> I have nothing called * in my database and also nothing called theTable so
> I know from this that he is not an expert just like Mr Chris In Madison
> and Mr CarCrash (hehe). They are very angry people, not like you Mrs Nancy
> *Adobe Community Expert who is kind and generous and willing to listen to
> a fellow expert who is needing help. Did I tell you I know 4 languages? I
> think I did.
> Can you help please kind Mrs Nancy *Adobe Community Expert?
>
> "Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
> news:e578ui$qs5$1@forums.macromedia.com...
>> SQL Server 6.5 is VERY old .. after that was 7 and then 2000 and now
>> 2005. However .. I'm sure it will work (though I have never used that
>> edition). Are you able to connect successfully to the database?
>>
>> As for your query, it's a simple one filter query on the ID number ..
>> Down with Bugs already gave you the code to make it work.
>>
>>
>> --
>> Nancy Gill
>> Adobe Community Expert
>> BLOG: http://www.dmxwishes.com/blog.asp
>> Author: Dreamweaver 8 e-book for the DMX Zone
>> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
>> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
>> Beginner's
>> Guide, Mastering Macromedia Contribute
>> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
>> Development
>>
>>
>> "THE WEBDEV KING" <DONOTEMAILME@ME.COM> wrote in message
>> news:e578er$q73$1@forums.macromedia.com...
>>>I am wrong. It is called SQL Sever edition 6.5. So sorry.
>>> Are you an expert Nancy? Can you help please?
>>>
>>> "Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
>>> news:e57844$pno$1@forums.macromedia.com...
>>>> Excel is a spreadsheet program .. not a database program. While it is
>>>> possible to use Excel with the appropriate driver, it is not
>>>> recommended.
>>>>
>>>>
>>>> --
>>>> Nancy Gill
>>>> Adobe Community Expert
>>>> BLOG: http://www.dmxwishes.com/blog.asp
>>>> Author: Dreamweaver 8 e-book for the DMX Zone
>>>> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
>>>> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
>>>> Beginner's
>>>> Guide, Mastering Macromedia Contribute
>>>> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
>>>> Development
>>>>
>>>>
>>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>>> news:e577lj$p76$1@forums.macromedia.com...
>>>>> Mr Chris in Madison, now I see your meaing of your question. My
>>>>> database is called Excel. Please help me experts.
>>>>>
>>>>> Thankyou.
>>>>>
>>>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>>>> news:e576p9$nvo$1@forums.macromedia.com...
>>>>>> Why do you treat me with such hostileity Mr Chris in Madison? I only
>>>>>> want answer to my question. I am very tired as I have tried to solve
>>>>>> my mystery all day and night and need some help from fellow expert. I
>>>>>> am not a stupid person. Since moving here 3 years ago I teach myself
>>>>>> 4 languages and evern am developing my own language for programming.
>>>>>> This will be very succesful and make me a lot of money. Until then I
>>>>>> need to webdev to make a living and I am very good at it.
>>>>>>
>>>>>> As you can see I am no novice but even the best need help. Please
>>>>>> help me someone who can.
>>>>>>
>>>>>> My moto - If your best is not good enough then try even better, or go
>>>>>> and
>>>>>> drink lots and lots of alcohol. If that does not work then do both
>>>>>> together
>>>>>> XX.
>>>>>>
>>>>>> "Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in
>>>>>> message news:e576e6$ngq$1@forums.macromedia.com...
>>>>>>> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for
>>>>>>> an expert such as yourself.
>>>>>>>
>>>>>>> ~C
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Report · May 26, 2006

The great benefits of PLONKing are definately shining through!

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:e579v0$s66$1@forums.macromedia.com...
> You guys are being strung along....
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)

Report · May 26, 2006

Please kind Mrs Nancy *Adobe Community Expert, I do not understand. What is
this generic. Is this database talk? I am not aware of this technology. You
are so kind Mrs Nancy *Adobe Community Expert and so very clever. Please
help.

"Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
news:e579sl$s3d$1@forums.macromedia.com...
> It was a generic example. Because DownWithBugs did not know what you
> called your tables and columns, he used "theTable" and you have to
> substitute the name of your real table for that value.
>
> * means everything from the table .. all columns. It's a shorthand way of
> saying it so you don't have to type all the names of all the columns in
> your database table.
>
>
> --
> Nancy Gill
> Adobe Community Expert
> BLOG: http://www.dmxwishes.com/blog.asp
> Author: Dreamweaver 8 e-book for the DMX Zone
> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
> Beginner's
> Guide, Mastering Macromedia Contribute
> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
> Development
>
>
> "THE WEBDEV KING" <DONOTEMAILME@ME.COM> wrote in message
> news:e579eg$rij$1@forums.macromedia.com...
>>I try the code from Mr DownWithTheBugs and it doesnot work
>> SELECT *
>> FROM theTable
>> WHERE theID=39
>> I have nothing called * in my database and also nothing called theTable
>> so I know from this that he is not an expert just like Mr Chris In
>> Madison and Mr CarCrash (hehe). They are very angry people, not like you
>> Mrs Nancy *Adobe Community Expert who is kind and generous and willing to
>> listen to a fellow expert who is needing help. Did I tell you I know 4
>> languages? I think I did.
>> Can you help please kind Mrs Nancy *Adobe Community Expert?
>>
>> "Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
>> news:e578ui$qs5$1@forums.macromedia.com...
>>> SQL Server 6.5 is VERY old .. after that was 7 and then 2000 and now
>>> 2005. However .. I'm sure it will work (though I have never used that
>>> edition). Are you able to connect successfully to the database?
>>>
>>> As for your query, it's a simple one filter query on the ID number ..
>>> Down with Bugs already gave you the code to make it work.
>>>
>>>
>>> --
>>> Nancy Gill
>>> Adobe Community Expert
>>> BLOG: http://www.dmxwishes.com/blog.asp
>>> Author: Dreamweaver 8 e-book for the DMX Zone
>>> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
>>> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
>>> Beginner's
>>> Guide, Mastering Macromedia Contribute
>>> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
>>> Development
>>>
>>>
>>> "THE WEBDEV KING" <DONOTEMAILME@ME.COM> wrote in message
>>> news:e578er$q73$1@forums.macromedia.com...
>>>>I am wrong. It is called SQL Sever edition 6.5. So sorry.
>>>> Are you an expert Nancy? Can you help please?
>>>>
>>>> "Nancy *Adobe Community Expert*" <nancy@webwish.com> wrote in message
>>>> news:e57844$pno$1@forums.macromedia.com...
>>>>> Excel is a spreadsheet program .. not a database program. While it is
>>>>> possible to use Excel with the appropriate driver, it is not
>>>>> recommended.
>>>>>
>>>>>
>>>>> --
>>>>> Nancy Gill
>>>>> Adobe Community Expert
>>>>> BLOG: http://www.dmxwishes.com/blog.asp
>>>>> Author: Dreamweaver 8 e-book for the DMX Zone
>>>>> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
>>>>> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
>>>>> Beginner's
>>>>> Guide, Mastering Macromedia Contribute
>>>>> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
>>>>> Development
>>>>>
>>>>>
>>>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>>>> news:e577lj$p76$1@forums.macromedia.com...
>>>>>> Mr Chris in Madison, now I see your meaing of your question. My
>>>>>> database is called Excel. Please help me experts.
>>>>>>
>>>>>> Thankyou.
>>>>>>
>>>>>> "THE WEBDEV KING" <DO NOT EMAIL ME@ME.COM> wrote in message
>>>>>> news:e576p9$nvo$1@forums.macromedia.com...
>>>>>>> Why do you treat me with such hostileity Mr Chris in Madison? I only
>>>>>>> want answer to my question. I am very tired as I have tried to solve
>>>>>>> my mystery all day and night and need some help from fellow expert.
>>>>>>> I am not a stupid person. Since moving here 3 years ago I teach
>>>>>>> myself 4 languages and evern am developing my own language for
>>>>>>> programming. This will be very succesful and make me a lot of money.
>>>>>>> Until then I need to webdev to make a living and I am very good at
>>>>>>> it.
>>>>>>>
>>>>>>> As you can see I am no novice but even the best need help. Please
>>>>>>> help me someone who can.
>>>>>>>
>>>>>>> My moto - If your best is not good enough then try even better, or
>>>>>>> go and
>>>>>>> drink lots and lots of alcohol. If that does not work then do both
>>>>>>> together
>>>>>>> XX.
>>>>>>>
>>>>>>> "Chris In Madison" <cowens@GOAWAYDIRTYRATSPAMMERScnw.com> wrote in
>>>>>>> message news:e576e6$ngq$1@forums.macromedia.com...
>>>>>>>> Try http://www.sqlteam.com/. I'm sure they'll be very helpful for
>>>>>>>> an expert such as yourself.
>>>>>>>>
>>>>>>>> ~C
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Report · May 26, 2006

sure dude.

good luck.