Here with a more appropriate subject line... -----Original Message----- From: fleming [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 5:30 PM To: '[EMAIL PROTECTED]' Subject: RE: Protecting Content / content leeching... A CF method? Hello Everyone, Does anyone know what syntax works for SQL Query using CF 4.5.1 (Solaris) and Foxpro v3.0 ODBC connection for a statement like this: <cfquery name="q_sogrp" datasource="abc" dbtype="ODBC"> SELECT pohdr.po_number, pohdr.vend_name, pohdr.vendor_id, pohdr.po_amount, pohdr.org_po_dt, pohdr.pay_term, pohdr.ship_to_nm, pohdr.ord_status, podtl.itm_glmoco, podtl.ln_sta, podtl.ln_no, podtl.prom_dock FROM pohdr, podtl <!---FROM (pohdr INNERJOIN podtl ON (pohdr.po_number=podtl.po_number AND pohdr.vendor_id=podtl.vendor_id))---> #where# order by pohdr.po_number </cfquery> When I test on my server with NT installation of cf 4.5.1, it works fine but not on the client solaris server. Any suggestions are very much appreciated. Thanks, Nehal ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
