Hi there
I have a query that I have developed which is working, however it is not
working correctly.
It is for some reason pulling 2 or 3 of the same records from the database
in some cases and only 1 record from the database in other cases.
Even after looking at the query for some time I cant see why this is
happening.
Here is the query below:
Select *
From
tbl_advertisers a,
photo p,
tbl_listing_type l,
photo_category pc
Where (a.advertiserid = p.advertiserid
And a.listingid = l.listingid
And p.catid = pc.id
And a.listingid = #url.listingid#)
If anyone wants to see the results that I am getting at present here is the
URL:
http://202.157.179.158/csandbdirectory only the beauty & spas link is
working at the time of sending this email.
Thanks in advance.
Pete
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266218
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
