Re: [Nolug] python

thanks a lot for your help I think I got it

'AND plan_submittals.PLAN_SUB_CODE = ' " 'I' ' " ' + sde_conn

Thanks for your help

On Wed, Sep 10, 2014 at 3:16 PM, Cruz Molina <freethinkingaway@gmail.com>
wrote:

> 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