issues with last post

-

hi, setting topic list forum, , want show when last post was. have table topics, , table responses. these tables linked together.

on topic list page have query

select * topics
left outer join topic_messages
on topics.id_topics=topic_messages.id_topics_messages

however when output query repeating topics in relation how many many messages there have been specific top...
the way have found display topics once remove join in query , have
select * topics

but means can no longer draw "last post" info messages table...

any ideas of how round this???cheers

read cfml reference manual. specifically, read cfoutput tag , it's group attribute. if don't have manual, google <cfoutput>


More discussions in Advanced Techniques


adobe

Comments

Post a Comment

Popular posts from this blog

Thread: PKI Client 5.00 install (for eToken Pro)

-
my company uses aladdin etoken pro authentication on vpn connections. etoken requires pki client application on client machine before os recognize it. app , token work fine on xp, use ubuntu on laptop. aladdin has offered linux version of client, rpm. convinced our internal guys rpms, , i've been trying work couple days. begin with, hp pavilion dv4-1435dx laptop running jaunty 64-bit. - started out converting .rpm .deb using alien: code: sudo alien -d pkiclient-5.00.28-0.x86_64.rpm - worked fine , got nice little .deb - next, ran .deb install client: code: sudo dpkg -i pkiclient_5.00.28-1_amd64.deb - , executed without errors/issues. pdf rpm said there should launcher @ applications > etoken > start etoken pki client, didn't exist. figured might because installed deb instead of rpm. bounced box, still wasn't there. no big deal... - install network manager can configure vpn connection use token: code: sudo aptit...
Read more

ATmega2560-Arduino Pin Mapping

-
hi community, in last days working on project using arduino mega 2560. on planning pin using found bugs in atmega2560-arduino pin mapping . if right there labels (such pwm) in 'mapped pin name' @ wrong row ( mixed pin numbers right one...) in attachment openoffice calc , pdf file corrected table. ( hope ;-) ) i post here tab separated table : code: [select] arduino mega 2560 pin mapping table atmega 2560 pin out arduino mega function nr name function function function mapped pin name function function datasheet 1 pg5 oc0b digital pin 04 pwm 2 pe0 rxd0 pcint8 digital pin 00 rx0 (usart0 receive pin, programming data input or pin change interrupt 8) 3 pe1 txd0 digital pin 01 tx0 (usart0 transmit pin or programming data output) 4 pe2 xck0 ain0 (usart0 external clock  input/output) 5 pe3 oc3a ain1 digital pin 05 pwm 6 pe4 ...
Read more

listen to event

-
i have class extend nothing, possible have class listening events? i found no way this, unless pass object(like displayobject) constructor. quote: public class myclass{ public myclass(){ addeventlistener(event.enter_frame, onenterframe); } private function onenterframe(event:event):void{...} } thankyou hi, you can have class listen events produced other classes, if want own class generate events, need extend eventdispatcher class. btw, displayobject , it's descendants can produce enterframe event. More discussions in Flex (Read Only) adobe
Read more