On Thu, May 05, 2005 at 11:26:18AM -0400, Robert Tsai wrote:
> On Thu, May 05, 2005 at 12:38:32AM -0400, Chris Pinkham wrote:
> > 1) The "UPDATE table1, table2, tabl3 SET table1.column" syntax is
> > not valid for MySQL v3.x, so this will need to be changed to
> > something like the following and put after the performActualUpdate()
> > call.
> >
> > ----------------------------------------
> > QString thequery;
> > int recordid;
> > MSqlQuery query(MSqlQuery::InitCon());
> >
> > thequery = QString("SELECT r.recordid "
> > "FROM record r, recordingprofiles p, codecparams c "
> > "WHERE c.name = 'autotranscode' "
> > "AND c.value = 1 "
> > "AND c.profile = p.id "
> > "AND r.profile = p.name; ");
> > query.prepare(thequery);
> >
> > if (query.exec() && query.isActive() && query.size() > 0)
> > {
> > MSqlQuery query2(MSqlQuery::InitCon());
> > while (query.next())
> > {
> > recordid = query.value(0).toInt();
> >
> > thequery = QString("UPDATE record SET autotranscode = 1 "
> > "WHERE recordid = %1;").arg(recordid);
> > query2.prepare(thequery);
> > query2.exec();
> > }
> > }
> > }
> > ----------------------------------------
>
> *Grumble*. OK. I'll work on this. I can shuffle around the SQL as
> described above, but I don't think I'll be able to test it, as I
> only have a single FE/BE system with whatever the debian default
> MySQL is (presumably some 4.x version).Attached patch is based off of most recent CVS and incorporates MySQL-3.x-compatible SQL. --Rob
mythtv-transcoding.diff.bz2
Description: Binary data
signature.asc
Description: Digital signature
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
