Skip to main content
M
mcnoodles
Participant
August 31, 2009
Question

OPENQUERY , OPENROWSET

  • August 31, 2009
  • 1 reply
  • 1060 views

Trying to run a query against an Oracle server using OpenQuery and/or OpenRowSet.

Using the following query and getting "SQL Command not properly ended" with either OpenQuery or OpenRowSet.

SQL   Select * FROM OPENROWSET('MSDAORA', 'LINKDV', 'SENDD', 'yamaha', ' select DISTINCT PB_Preflight.Deal_number, PB_Preflight.job_number, PB_Preflight.cycle_number, generic_cycle.Status_code, generic_cycle.Date_created, generic_cycle.Date_Modified, generic_cycle.Date_into_manufctng, generic_cycle.Date_due_to_Client, generic_cycle.date_complete_by, generic_cycle.site_id_mfg, generic_cycle.site_id_created, generic_cycle.Service_Level_type, SENDD.V_PB_CUST_REQS.Print_status, deal.name as deal_name, site.Name_short, market_segment.MARKET_CATEGORY, deal.site_id as deal_site_id, job.site_id as job_site_id, SENDD.V_PB_CUST_REQS.transfer_request From PB_Preflight, generic_cycle, SENDD.V_PB_CUST_REQS, deal, job, site, market_segment Where PB_Preflight.DEAL_NUMBER = generic_cycle.DEAL_NUMBER and PB_Preflight.JOB_NUMBER = generic_cycle.JOB_NUMBER and PB_Preflight.cycle_number = generic_cycle.cycle_number and SENDD.V_PB_CUST_REQS.deal_number = generic_cycle.deal_number and SENDD.V_PB_CUST_REQS.job_number = generic_cycle.job_number and SENDD.V_PB_CUST_REQS.cycle_number = generic_cycle.cycle_number and job.deal_number = generic_cycle.deal_number and job.job_number = generic_cycle.job_number and generic_cycle.SITE_ID_MFG = site.site_id and deal.deal_number = generic_cycle.deal_number and deal.MARKET_SEGMENT_ID = market_segment.MARKET_SEGMENT_ID and (GENERIC_CYCLE.Date_Modified >= to_date (''26-Aug-2000 03:50:12'',''dd-mon-yyyyhh24:MI:SS'') or GENERIC_CYCLE.Date_created >= to_date (''26-Aug-2000 03:50:12'',''dd-mon-yyyyhh24:MI:SS'') or deal.Date_Modified >= to_date (''26-Aug-2000 03:50:12'',''dd-mon-yyyyhh24:MI:SS'') or deal.Date_created >= to_date (''26-Aug-2000 03:50:12'',''dd-mon-yyyyhh24:MI:SS'') or job.Date_Modified >= to_date (''26-Aug-2000 03:50:12'',''dd-mon-yyyyhh24:MI:SS'') or PB_Preflight.last_mod_date >= to_date (''26-Aug-2000 03:50:12'',''dd-mon-yyyyhh24:MI:SS'') or PB_Preflight.create_date >= to_date (''26-Aug-2000 03:50:12'',''dd-mon-yyyyhh24:MI:SS'')) ')


Any suggestions would be greatly appreciated!

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    August 31, 2009

    Probably those double quotes you're using.  A better solution would be to convert those strings to coldfusion datetime variables and use cfqueryparam.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices