79 : SELECT ID,FILE_num,FILElink,FILEchanged,FILEnotice_type,ACCOUNTdate_in,ACCOUNTstatus,ACCOUNTbalance,ACCOUNTstart,ACCOUNTend,PERSONfirstname,PERSONlastname,PERSONscrn_name,PERSONemail1,PERSONseeking,PERSON_addr,
80 : PERSON_city,PERSON_state,PERSON_zip,PERSON_country,PERSON_timezone,PERSONcontact,PERSONcon_num,PERSONvph_type,PERSONvph_dir,PERSONvph_num,PERSONvph_img,PERSONvph_img2,PERSONvph_stat,PERSONlivecam,PERSONlivecam2,PERSONjob_type,PERSONdesc,PERSONmessage,PERSONwebpage
81 : FROM VP_members2015_admin879e WHERE ((Mid(PERSONlivecam,1,10) = '#STATUS2#')) ORDER
82 : BY Mid(PERSONlivecam,25,2) DESC </CFQUERY></CFOUTPUT>
83 : </FONT>
|