[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Perl/SQL - UPDATE Queries
On Mon, Jul 02, 2001 at 02:26:39PM -0600, Russ Mann wrote:
> How would you do this in a [perl] block?
>
$Tag->query({sql => "update table set foo='bar'"});
> -----Original Message-----
> From: interchange-users-admin@developer.akopia.com
> [mailto:interchange-users-admin@developer.akopia.com]On Behalf Of Jason
> Kohles
> Sent: Monday, July 02, 2001 1:52 PM
> To: interchange-users@developer.akopia.com
> Subject: Re: [ic] Perl/SQL - UPDATE Queries
>
>
> On Mon, Jul 02, 2001 at 01:52:07PM -0600, Russ Mann wrote:
> > Hello List,
> >
> > How can I run UPDATE SQL queries within a regular IC page? Does anyone do
> > this? All the examples are of SELECT queries, but that doesn't do me any
> > good.
> >
> Exactly the same way...
> [query sql="update table set foo='bar'"]
>
>
> > Thank you.
> >
> > Russ
> >
> > -----Original Message-----
> > Sent: Friday, June 29, 2001 4:27 PM
> > Subject: RE: [ic] Perl/SQL
> >
> >
> > I can't seem to get any of these things to work with what I'm trying to
> do.
> >
> > I need to be able to run queries like this:
> > @tables is an array including everything that has a username field in it.
> >
> > foreach $table (@tables) {
> > UPDATE $table SET username='$new_username' WHERE username =
> '$old_username'
> > }
> >
> > Which method would you use to do this?
> >
> > R
> >
> > -----Original Message-----
> > From: interchange-users-admin@developer.akopia.com
> > [mailto:interchange-users-admin@developer.akopia.com]On Behalf Of Mark
> > Johnson
> > Sent: Friday, June 29, 2001 1:57 PM
> > To: interchange-users@developer.akopia.com
> > Subject: Re: [ic] Perl/SQL
> >
> >
> > MANY options, but the main ones:
> >
> > In embedded perl, use the %Db object's query method
> >
> > http://interchange.redhat.com/cgi-bin/ic/dev/icconfig_30.html
> >
> > As its own tag, use the [query] tag.
> >
> > [query list=1 sql="select * from foobar"]
> > Field Value
> > ----- -----
> > code [sql-code]
> > foocol [sql-param foocol]
> > barcol [sql-param barcol]
> > [/query]
> >
> > Russ Mann wrote:
> > >
> > > Hello,
> > >
> > > How do I execute an SQL statement from within a [perl] bock?
> > >
> > > Or, how do I execute an arbitrary SQL statement from a regular page?
> > >
> > > Thanks,
> > >
> > > Russ
> > > _______________________________________________
> > > Interchange-users mailing list
> > > Interchange-users@lists.akopia.com
> > > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> > --
> > Mark Johnson
> > Senior Systems Architect - Professional Services
> > Red Hat, Inc.
> > E-Business Solutions
> > markj@redhat.com
> > 703-456-2912
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
>
> --
> Red Hat E-Business Solutions Jason Kohles
> 11480 Sunset Hills Road Senior System Architect
> Reston, VA 20190 jkohles@redhat.com
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
--
Red Hat E-Business Solutions Jason Kohles
11480 Sunset Hills Road Senior System Architect
Reston, VA 20190 jkohles@redhat.com
