Re: [WebDNA] [Delete] doesn delete all...

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104100
interpreted = N
texte =
The other way probably messed up the internal indexing and couldn't delete the right recods


On Thu,= 3 Dec 2009 16:30:13 +0100
Lawrence Banahan <lawrence@authorsimage.com> wrote:
> I just tried it, and it'= s fine, but I'm still surprised
>the other way didn't work properly...
> Lawrence
>
> Le 3= d=E9c. 09 =E0 15:23, Terry Wilson a =E9crit :
>
>> Did you try it this way instead:
>>
&g= t;> [DELETE
>>db=3Dcoord.db&eqMOISdatarq=3D[v1]&eqAN= NEEdatarq=3D[v2]]
>>
>> Terry
>>
>>
>> On Thu, 03 Dec 2009 12:09:24 +0= 100
>> Lawrence <lawrence@authorsimage.com> wrote:
>> > Hi,
>>= >
>> > I have something strange...
>> > I want to delete some line in a db every mont= h.
>> > I have setup 2 variables that searches in my db.
>> > But I need to run this code seve= ral times before all
>>the
>> >value get erased...
>> >
&= gt;> > Has any body got an idea...
>> > Expect copying the same code several times on th= e same
>> >page...
>> >
>> > I have the following code
>> > mois:[v1= ]<br>
>> > annee=3D[v2]<br>
>> >
>> > [search
>&= gt; >db=3Dcoord.db&eqMOISdatarq=3D[v1]&eqANNEEdatarq=3D[v2]&am= p;asSKUsort=3D1]
>> > [founditems][DELETE db=3Dcoord.db&eqSKUdata=3D[sku]]
>>= > [/founditems][/search]
>> >
>> > Thanks for any ideas
>> > Lawrence
&= gt;> >
>> >
>>---------------------------------------------------------
= >> > This message is sent to you because you are subscribed
>> >to
>> > the mailin= g list <talk@webdna.us>.
>> > To unsubscribe, E-mail to: <talk-leave@webdna.us>
>> > = archives: http://mail.webdna.us/list/talk@webdna.us
>> > old archives: http://dev.webdna.us/TalkListArchive/
>> >= Bug Reporting:
>> >http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288>>
>>
>

=A0
Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [Delete] doesn delete all... (Kenneth Grome 2009)
  2. Re: [WebDNA] [Delete] doesn delete all... ("Terry Wilson" 2009)
  3. Re: [WebDNA] [Delete] doesn delete all... (Lawrence Banahan 2009)
  4. Re: [WebDNA] [Delete] doesn delete all... ("Terry Wilson" 2009)
  5. [WebDNA] [Delete] doesn delete all... (Lawrence 2009)
The other way probably messed up the internal indexing and couldn't delete the right recods


On Thu,= 3 Dec 2009 16:30:13 +0100
Lawrence Banahan <lawrence@authorsimage.com> wrote:
> I just tried it, and it'= s fine, but I'm still surprised
>the other way didn't work properly...
> Lawrence
>
> Le 3= d=E9c. 09 =E0 15:23, Terry Wilson a =E9crit :
>
>> Did you try it this way instead:
>>
&g= t;> [DELETE
>>db=3Dcoord.db&eqMOISdatarq=3D[v1]&eqAN= NEEdatarq=3D[v2]]
>>
>> Terry
>>
>>
>> On Thu, 03 Dec 2009 12:09:24 +0= 100
>> Lawrence <lawrence@authorsimage.com> wrote:
>> > Hi,
>>= >
>> > I have something strange...
>> > I want to delete some line in a db every mont= h.
>> > I have setup 2 variables that searches in my db.
>> > But I need to run this code seve= ral times before all
>>the
>> >value get erased...
>> >
&= gt;> > Has any body got an idea...
>> > Expect copying the same code several times on th= e same
>> >page...
>> >
>> > I have the following code
>> > mois:[v1= ]<br>
>> > annee=3D[v2]<br>
>> >
>> > [search
>&= gt; >db=3Dcoord.db&eqMOISdatarq=3D[v1]&eqANNEEdatarq=3D[v2]&am= p;asSKUsort=3D1]
>> > [founditems][DELETE db=3Dcoord.db&eqSKUdata=3D[sku]]
>>= > [/founditems][/search]
>> >
>> > Thanks for any ideas
>> > Lawrence
&= gt;> >
>> >
>>---------------------------------------------------------
= >> > This message is sent to you because you are subscribed
>> >to
>> > the mailin= g list <talk@webdna.us>.
>> > To unsubscribe, E-mail to: <talk-leave@webdna.us>
>> > = archives: http://mail.webdna.us/list/talk@webdna.us
>> > old archives: http://dev.webdna.us/TalkListArchive/
>> >= Bug Reporting:
>> >http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288>>
>>
>

=A0
"Terry Wilson"

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

TeaRoom Search page (2000) WebCat2b12plugin - [search] is broken ... not! (1997) Interesting speed comparison .. (2003) capitalize each word? (2002) creator code (1997) Guest Book (2002) Show first couple of lines. (2003) formula.db question (1997) How can I record purchases to a database? (1998) [cart] tag (2000) Client-side Image Maps and WebCat (what's a database-drivensite)? (1998) Mime Headers for Mail (1998) Emailer [cart] file names (1997) RAM variables (1997) Help please (2004) E-Mail (1998) math with multiple [founditems] (1999) [WriteFile] problems (1997) 2.0 Info (1997) WebCommerce: Folder organization ? (1997)