I've modified the SQL directly before. It hadn't quite clicked that you can use LENGTH on the right side of an equals sign. Thanks for the query.
Thanks, Max Goldstein Operations Director WMFO Medford On Mon, Dec 2, 2013 at 10:13 PM, Karl Koscher <super...@uwave.fm> wrote: > Probably the easiest (but somewhat hackish) way to do it is directly from > the mysql CLI. Grab the password from /etc/rd.conf, and do the following: > > $ mysql -u rduser -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 17818 > Server version: 5.5.34-0ubuntu0.12.04.1-log (Ubuntu) > > Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights > reserved. > > Oracle is a registered trademark of Oracle Corporation and/or its > affiliates. Other names may be trademarks of their respective > owners. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input > statement. > > mysql> use Rivendell; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> update CUTS set START_POINT = 0, END_POINT = LENGTH where > CART_NUMBER >= 10010 and CART_NUMBER <= 10178; > Query OK, 168 rows affected (0.09 sec) > Rows matched: 168 Changed: 168 Warnings: 0 > > mysql> quit > Bye > > > Of course, you'll probably want to change the start and end cart numbers. > > > > > On Mon, Dec 2, 2013 at 6:38 PM, Max Goldstein, Operations Director < > o...@wmfo.org> wrote: > >> Good to hear nothing was permanently lost. If we wanted to push the Start >> and Stop markers to the ends of every cut/cart in a particular group as a >> batch operation, what do you suggest? >> >> Thanks, >> >> Max Goldstein >> Operations Director >> WMFO Medford >> >> >> On Mon, Dec 2, 2013 at 11:44 AM, Andy Sayler <a...@wmfo.org> wrote: >> >>> Thanks, Fred! >>> >>> >>> On Mon, Dec 2, 2013 at 9:42 AM, Fred Gleason >>> <fr...@paravelsystems.com>wrote: >>> >>>> On Dec 2, 2013, at 10:49 08, Andy Sayler <a...@wmfo.org> wrote: >>>> >>>> > I think the issue for us is that it seems to be set to -30 dBFS by >>>> default (i.e. if you don't use the auto trim flag at all). Can anyone >>>> confirm that? >>>> >>>> Yes, that is correct for versions through v2.5.5. >>>> >>>> >>>> > Also, does the auto trim setting actually affect the output wav file, >>>> or just it just affect metadata (e.g. by setting a cutoff in the database, >>>> etc). Asked another way, is there a way to adjust/undo the auto-trim >>>> setting for tracks that have already been imported? >>>> >>>> It affects only the positioning of the Start and Stop markers. The >>>> underlying audio for the entire track as input is intact in the audio >>>> store. >>>> >>>> So yes, this can be changed in RDLibrary to ‘get back’ the missing >>>> fades. >>>> >>>> Cheers! >>>> >>>> >>>> >>>> |-------------------------------------------------------------------------| >>>> | Frederick F. Gleason, Jr. | Chief Developer >>>> | >>>> | | Paravel Systems >>>> | >>>> >>>> |-------------------------------------------------------------------------| >>>> | Call on God, but row away from the rocks. >>>> | >>>> | -- Indian proverb >>>> | >>>> >>>> |-------------------------------------------------------------------------| >>>> >>>> _______________________________________________ >>>> Rivendell-dev mailing list >>>> Rivendell-dev@lists.rivendellaudio.org >>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>> >>> >>> >>> _______________________________________________ >>> Rivendell-dev mailing list >>> Rivendell-dev@lists.rivendellaudio.org >>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>> >>> >> >> _______________________________________________ >> Rivendell-dev mailing list >> Rivendell-dev@lists.rivendellaudio.org >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >> >> >
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
