mySQL parameterized querues - resetting the parameter

Options
RobertPenridge
RobertPenridge Member
in Connectors

I setup a parameterized query that pulls just incremental data based on IDs.

 

I initially set the parater to zero and on the first pull it retrieved all rows as expected.  On subsequent runs it's pulling just the new records as expected.

 

Is there a way to 'reset' the parameter so that will will re-pull all rows in the table?

Comments

  • RobertPenridge
    RobertPenridge Member
    Options

    The only solution I could figure out was to adjust the SQL so that my `id` field had a hardcoded value of zero, ie...

     

    select 0 as id from mytable...

     

    That way the internally remembered value became zero.  I then reverted the SQL to the original settings.

Categories