This is Interesting: Free Magazines for Graphics designers and webmasters  


Home > Archive > Dreamweaver > March 2004 > Hey Murry, Ya Out there?





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Hey Murry, Ya Out there?
Wally Kolcz

2004-03-31, 1:35 pm

I am trying to work on a dynamic web site that has the SQL inside the
hyperlink. I want it to pull information out of a database for the city and
the businesses in that city.

I have 2 tables: CatCity and CatType. CatCity is a number 1 - 32 (which is
the city) and CatType is a number 1 - 20 (which is a type of business in a
city).

When I try
http://www.carryoutmenus.com/listin...y=16&CatType=2, I
only get the city to pull up and it displays all the types of businesses in
that city with no response from the CatType. Am I writing the correct string
code?

It seems to work fine in the Macromedia forum when they have 2 identifiers
(catid and threadid):
http://www.macromedia.com/cfusion/w....cfm?catid=189&
threadid=803084



Murray *TMM*

2004-03-31, 1:35 pm

Wally:

Show me the SQL select statement on the receiving page, please.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver MX
(If you *MUST* email me, don't LAUGH when you do so!)
==================
news://forums.macromedia.com/macromedia.dreamweaver - THE BEST WAY TO GET
ANSWERS
==================
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
==================

"Wally Kolcz" <wkolcz@comcast.net> wrote in message
news:c4eq5g$l2p$1@forums.macromedia.com...
> I am trying to work on a dynamic web site that has the SQL inside the
> hyperlink. I want it to pull information out of a database for the city

and
> the businesses in that city.
>
> I have 2 tables: CatCity and CatType. CatCity is a number 1 - 32 (which

is
> the city) and CatType is a number 1 - 20 (which is a type of business in a
> city).
>
> When I try
> http://www.carryoutmenus.com/listin...y=16&CatType=2,

I
> only get the city to pull up and it displays all the types of businesses

in
> that city with no response from the CatType. Am I writing the correct

string
> code?
>
> It seems to work fine in the Macromedia forum when they have 2 identifiers
> (catid and threadid):
>

http://www.macromedia.com/cfusion/w....cfm?catid=189&
> threadid=803084
>
>
>



RobGT

2004-03-31, 1:36 pm

Try to stick to one thread per discussion, it makes the lives of those
helping and following the thread much easier.
Cheers,
Rob http://robgt.com/
Extensions: http://robgt.com/products/index.asp
Tutorials: http://robgt.com/tutorials/index.asp
Blog: http://blog.robgt.com/


Wally Kolcz

2004-03-31, 1:37 pm

Its only a Select * from restaurants
Is that where my problem lays?

"Murray *TMM*" <forums@HAHAgreat-web-sights.com> wrote in message
news:c4eq8r$l6c$1@forums.macromedia.com...
> Wally:
>
> Show me the SQL select statement on the receiving page, please.
>
> --
> Murray --- ICQ 71997575
> Team Macromedia Volunteer for Dreamweaver MX
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> news://forums.macromedia.com/macromedia.dreamweaver - THE BEST WAY TO GET
> ANSWERS
> ==================
> 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
> ==================
>
> "Wally Kolcz" <wkolcz@comcast.net> wrote in message
> news:c4eq5g$l2p$1@forums.macromedia.com...
> and
> is
a[color=darkred]
http://www.carryoutmenus.com/listin...y=16&CatType=2,[color=darkred]
> I
> in
> string
identifiers[color=darkred]
>

http://www.macromedia.com/cfusion/w....cfm?catid=189&
>
>



Murray *TMM*

2004-03-31, 1:37 pm

Sure. It should be selecting on the parameters passed in the URL

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver MX
(If you *MUST* email me, don't LAUGH when you do so!)
==================
news://forums.macromedia.com/macromedia.dreamweaver - THE BEST WAY TO GET
ANSWERS
==================
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
==================

"Wally Kolcz" <wkolcz@comcast.net> wrote in message
news:c4etqp$qo7$1@forums.macromedia.com...
> Its only a Select * from restaurants
> Is that where my problem lays?
>
> "Murray *TMM*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:c4eq8r$l6c$1@forums.macromedia.com...
GET[color=darkred]
city[color=darkred]
(which[color=darkred]
in[color=darkred]
> a
> http://www.carryoutmenus.com/listin...y=16&CatType=2,
businesses[color=darkred]
> identifiers
>

http://www.macromedia.com/cfusion/w....cfm?catid=189&
>
>



Wally Kolcz

2004-03-31, 1:37 pm

How then would I pass the other information to create the contents for the
page?
So it should read SELECT CatCity, CatType FROM Restuarants

"Murray *TMM*" <forums@HAHAgreat-web-sights.com> wrote in message
news:c4eubf$rj1$1@forums.macromedia.com...
> Sure. It should be selecting on the parameters passed in the URL
>
> --
> Murray --- ICQ 71997575
> Team Macromedia Volunteer for Dreamweaver MX
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> news://forums.macromedia.com/macromedia.dreamweaver - THE BEST WAY TO GET
> ANSWERS
> ==================
> 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
> ==================
>
> "Wally Kolcz" <wkolcz@comcast.net> wrote in message
> news:c4etqp$qo7$1@forums.macromedia.com...
> GET
the[color=darkred]
> city
> (which
business[color=darkred]
> in
http://www.carryoutmenus.com/listin...y=16&CatType=2,[color=darkred]
> businesses
correct[color=darkred]
>

http://www.macromedia.com/cfusion/w....cfm?catid=189&
>
>



Wally Kolcz

2004-03-31, 1:37 pm

Opps, think I misunderstood what you said.

It isnt filtering only the businesses that fit the second parameter. It just
shows all the businesses that are in that city. Any ideas?


Sponsored Links


Copyright 2003 - 2008 forum4designers.com  Software forum  Computer Hardware reviews