Looks like your code should be:
holder += ' -w \"PLAN_WELL_SITES_BOTM_SDE_VIEW.SN_PLAN_SUB_FK =
plan_submittals.sn_plan_sub '
holder += 'AND plan_submittals.PLAN_SUB_CODE = \'l\'\"' + sde_conn
If holder = ""
and then both of the lines above are executed, minus the + sde_conn at the
end of the second line,
print(holder) should output:
-w "PLAN_WELL_SITES_BOTM_SDE_VIEW.SN_PLAN_SUB_FK =
plan_submittals.sn_plan_sub AND plan_submittals.PLAN_SUB_CODE = 'l'"
And if that's what you're going for, that should be it [?]
On Wed, Sep 10, 2014 at 2:01 PM, joe johannesburg <jdj2005@gmail.com> wrote:
> what is the error returned and do a print of holder after the last line
> and paste the result.
> On Wed, Sep 10, 2014 at 1:47 PM, Diann Smith <diann170@gmail.com> wrote:
>
>> can someone help me with this python script?
>>
>> #WHERE CLAUSE
>> holder += ' -w "PLAN_WELL_SITES_BOTM_SDE_VIEW.SN_PLAN_SUB_FK =
>> plan_submittals.sn_plan_sub '
>> holder += 'AND plan_submittals.PLAN_SUB_CODE = 'I'" + sde_conn
>>
>> I says the offending problem is the : = 'I ' "
>>
>> Can someone let me know how to change this
>>
>> Thanks
>> Barbara
>>
>
>
___________________
Nolug mailing list
nolug@nolug.org
This archive was generated by hypermail 2.2.0 : 09/11/14 CDT