Re: [Nolug] python

From: Cruz Molina <freethinkingaway_at_gmail.com>
Date: Wed, 10 Sep 2014 15:16:53 -0500
Message-ID: <CAEX9GvMMvdwJXLhwD98+89Jy26n3dHh1tDLUUL6izhSi-R-71A@mail.gmail.com>

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

Received on 09/10/14

This archive was generated by hypermail 2.2.0 : 09/11/14 CDT