SQL Help

I have a list of files that a user can delete out of the database. I dont
want them to have to delete them one at a time, so i want them to be able to
check the ones they want with checkboxes. Im not sure how to use the SET
fieldname = 1
for ALL the checkboxes checked.

are ya with me? lol


thanks for any help!

jay

Re: SQL Help

James Jones wrote:
> I have a list of files that a user can delete out of the database. I
> dont want them to have to delete them one at a time, so i want them
> to be able to check the ones they want with checkboxes. Im not sure
> how to use the SET fieldname = 1
> for ALL the checkboxes checked.
>
> are ya with me? lol
>

Include the primary key value for each file in the checkbox names, Then loop
through the Request collection, extracting the primary key values from the
names and using the values to delete the appropriate rows.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: SQL Help

ok........i think i can try this.....i hope..........i meant records, not
files by the way, lol sorry




"Bob Barrows [MVP]" wrote in message
news:egwluDtlGHA.1972@TK2MSFTNGP05.phx.gbl...
> James Jones wrote:
>> I have a list of files that a user can delete out of the database. I
>> dont want them to have to delete them one at a time, so i want them
>> to be able to check the ones they want with checkboxes. Im not sure
>> how to use the SET fieldname = 1
>> for ALL the checkboxes checked.
>>
>> are ya with me? lol
>>
>
> Include the primary key value for each file in the checkbox names, Then
> loop through the Request collection, extracting the primary key values
> from the names and using the values to delete the appropriate rows.
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

Re: SQL Help

http://www.mikebrind.com/article.asp?article=21

--
Mike Brind


James Jones wrote:
> ok........i think i can try this.....i hope..........i meant records, not
> files by the way, lol sorry
>
>
>
>
> "Bob Barrows [MVP]" wrote in message
> news:egwluDtlGHA.1972@TK2MSFTNGP05.phx.gbl...
> > James Jones wrote:
> >> I have a list of files that a user can delete out of the database. I
> >> dont want them to have to delete them one at a time, so i want them
> >> to be able to check the ones they want with checkboxes. Im not sure
> >> how to use the SET fieldname = 1
> >> for ALL the checkboxes checked.
> >>
> >> are ya with me? lol
> >>
> >
> > Include the primary key value for each file in the checkbox names, Then
> > loop through the Request collection, extracting the primary key values
> > from the names and using the values to delete the appropriate rows.
> >
> > --
> > Microsoft MVP - ASP/ASP.NET
> > Please reply to the newsgroup. This email account is my spam trap so I
> > don't check it very often. If you must reply off-line, then remove the
> > "NO SPAM"
> >

Re: SQL Help

http://www.mikebrind.com/article.asp?id=&page=2




ADODB.Connection error '800a0e7c'

Parameter object is improperly defined. Inconsistent or incomplete
information was provided.

/article.asp, line 22





"James Jones" wrote in message
news:u2Tk1yslGHA.1552@TK2MSFTNGP04.phx.gbl...
>I have a list of files that a user can delete out of the database. I dont
>want them to have to delete them one at a time, so i want them to be able
>to check the ones they want with checkboxes. Im not sure how to use the SET
>fieldname = 1
> for ALL the checkboxes checked.
>
> are ya with me? lol
>
>
> thanks for any help!
>
> jay
>

Re: SQL Help

i found that ur pages are not getting the next page value for ur
paging.......

http://www.mikebrind.com/article.asp?id=&page=2

needs to be

http://www.mikebrind.com/article.asp?id=21&page=2


not sure whats goin on, lol




"James Jones" wrote in message
news:%23iEsEH5lGHA.1596@TK2MSFTNGP05.phx.gbl...
> http://www.mikebrind.com/article.asp?id=&page=2
>
>
>
>
> ADODB.Connection error '800a0e7c'
>
> Parameter object is improperly defined. Inconsistent or incomplete
> information was provided.
>
> /article.asp, line 22
>
>
>
>
>
> "James Jones" wrote in message
> news:u2Tk1yslGHA.1552@TK2MSFTNGP04.phx.gbl...
>>I have a list of files that a user can delete out of the database. I dont
>>want them to have to delete them one at a time, so i want them to be able
>>to check the ones they want with checkboxes. Im not sure how to use the
>>SET fieldname = 1
>> for ALL the checkboxes checked.
>>
>> are ya with me? lol
>>
>>
>> thanks for any help!
>>
>> jay
>>
>
>

Re: SQL Help

Thank you lol.

That's the only one that uses paging. I forgot to update the paging
code when I changed the rest of the site, prior to moving it to another
server.

--
Mike Brind

James Jones wrote:
> i found that ur pages are not getting the next page value for ur
> paging.......
>
> http://www.mikebrind.com/article.asp?id=&page=2
>
> needs to be
>
> http://www.mikebrind.com/article.asp?id=21&page=2
>
>
> not sure whats goin on, lol
>
>
>
>
> "James Jones" wrote in message
> news:%23iEsEH5lGHA.1596@TK2MSFTNGP05.phx.gbl...
> > http://www.mikebrind.com/article.asp?id=&page=2
> >
> >
> >
> >
> > ADODB.Connection error '800a0e7c'
> >
> > Parameter object is improperly defined. Inconsistent or incomplete
> > information was provided.
> >
> > /article.asp, line 22
> >
> >
> >
> >
> >
> > "James Jones" wrote in message
> > news:u2Tk1yslGHA.1552@TK2MSFTNGP04.phx.gbl...
> >>I have a list of files that a user can delete out of the database. I dont
> >>want them to have to delete them one at a time, so i want them to be able
> >>to check the ones they want with checkboxes. Im not sure how to use the
> >>SET fieldname = 1
> >> for ALL the checkboxes checked.
> >>
> >> are ya with me? lol
> >>
> >>
> >> thanks for any help!
> >>
> >> jay
> >>
> >
> >