them in any way, except to pull out a subset of their information. Would
definitely be nice to have the INSERT, UPDATE, and DELETE in some
situations, but there's nothing you can't get around with queryAddRow,
querySetCell, and a QofQ respectively.
Cheers,
barneyb
> -----Original Message-----
> From: Troy Simpson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 18, 2004 1:36 PM
> To: CF-Talk
> Subject: Re: How do I delete a row in a query?
>
> Thanks for the info.
> That was very helpful.
>
> Can you use Insert, Update, and Delete SQL statements with a QofQ?
>
> Sincerely,
> Troy
>
> Barney Boisvert wrote:
>
> > You can't. You can emulate the behaviour by running a
> SELECT * QofQ with a
> > WHERE clause that doesn't match the row you want to delete,
> but that's as
> > good as it gets.
> >
> > Cheers,
> > barneyb
> >
> > > -----Original Message-----
> > > From: Troy Simpson [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, February 18, 2004 11:04 AM
> > > To: CF-Talk
> > > Subject: How do I delete a row in a query?
> > >
> > > All,
> > >
> > > I have manually created a query by adding rows, columns, and
> > > then the data.
> > >
> > > I used query functions like QueryAddColumn, QueryAddRow,
> > > QueryNew, and
> > > QuerySetCell.
> > >
> > > How do I delete a row in a query result set?
> > >
> > > Thanks,
> > > Troy
> > >
> > >
> > >
> > > --
> > > Troy Simpson
> > > Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
> > > North Carolina State University Libraries
> > > Campus Box 7111 | Raleigh | North Carolina
> > > ph.919.515.3855 | fax.919.513.3330
> > > E-mail: [EMAIL PROTECTED]
> > >
> > >
> >
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
