Re: [WebDNA] line/Row Insert

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113608
interpreted = N
texte = 1203 --001a113f7ca28385170550612873 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable maybe to have it REWRITTEN is where to go, but I'm thinking of altering the Unique Sequential ID or index by simulating an up/down movement of rows from the users viewpoint... On Mon, May 22, 2017 at 10:34 AM, Brian Fries wrote: > Using WebDNA=E2=80=99s database contexts - REPLACE and APPEND - every new= record > you add is added at the end of the .db file. > > Typically, if you care about the order of the records, that is handled by > the sort options in your SEARCH context. > > If you truly need a row in between two others for some reason (I can=E2= =80=99t > think of why, but maybe you have a good case), you=E2=80=99ll have to res= ort to > other means, such as manually editing the .db file in a spreadsheet or a > text editor, or using WebDNA=E2=80=99s INCLUDE to read the file into a TE= XT > variable, manipulate the text to add the line where you want it, then use > WRITEFILE to write it back to disk (makeing sure WebDNA does not have the > database open in the meantime, or it may overwrite your changes). > > - Brian > > On May 21, 2017, at 2:30 PM, Sgbc Cebu wrote: > > Dear TalkList: > > Is it possible to insert a new line, that is between existing rows, insid= e > a db? > > Thanks > > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.u= s > --001a113f7ca28385170550612873 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
maybe to have it REWRITTEN is where to go, but I'm thi= nking of altering the Unique Sequential ID or index by simulating an up/dow= n movement of rows from the users viewpoint...

On Mon, May 22, 2017 at 10:34 AM, Br= ian Fries <iphonzie@gmail.com> wrote:
Using WebDNA=E2=80=99s database contexts - REPLACE and APPEND - = every new record you add is added at the end of the .db file.

Typically, if you care about the order of the records, that is handle= d by the sort options in your SEARCH context.

If y= ou truly need a row in between two others for some reason (I can=E2=80=99t = think of why, but maybe you have a good case), you=E2=80=99ll have to resor= t to other means, such as manually editing the .db file in a spreadsheet or= a text editor, or using WebDNA=E2=80=99s INCLUDE to read the file into a T= EXT variable, manipulate the text to add the line where you want it, then u= se WRITEFILE to write it back to disk (makeing sure WebDNA does not have th= e database open in the meantime, or it may overwrite your changes).

- Brian

On May 21, 2017, at 2:30 PM, Sgbc Cebu <sgbccebu@gmail.com> wrote:
Dear TalkList:

Is it possible to insert a new l= ine, that is between existing rows, inside a db?

Thanks

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --001a113f7ca28385170550612873-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] line/Row Insert (Sgbc Cebu 2017)
  2. Re: [WebDNA] line/Row Insert (Brian Fries 2017)
  3. [BULK] Re: [WebDNA] line/Row Insert ("WJ Starck, DDS" 2017)
  4. [WebDNA] line/Row Insert (Sgbc Cebu 2017)
1203 --001a113f7ca28385170550612873 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable maybe to have it REWRITTEN is where to go, but I'm thinking of altering the Unique Sequential ID or index by simulating an up/down movement of rows from the users viewpoint... On Mon, May 22, 2017 at 10:34 AM, Brian Fries wrote: > Using WebDNA=E2=80=99s database contexts - REPLACE and APPEND - every new= record > you add is added at the end of the .db file. > > Typically, if you care about the order of the records, that is handled by > the sort options in your SEARCH context. > > If you truly need a row in between two others for some reason (I can=E2= =80=99t > think of why, but maybe you have a good case), you=E2=80=99ll have to res= ort to > other means, such as manually editing the .db file in a spreadsheet or a > text editor, or using WebDNA=E2=80=99s INCLUDE to read the file into a TE= XT > variable, manipulate the text to add the line where you want it, then use > WRITEFILE to write it back to disk (makeing sure WebDNA does not have the > database open in the meantime, or it may overwrite your changes). > > - Brian > > On May 21, 2017, at 2:30 PM, Sgbc Cebu wrote: > > Dear TalkList: > > Is it possible to insert a new line, that is between existing rows, insid= e > a db? > > Thanks > > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.u= s > --001a113f7ca28385170550612873 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
maybe to have it REWRITTEN is where to go, but I'm thi= nking of altering the Unique Sequential ID or index by simulating an up/dow= n movement of rows from the users viewpoint...

On Mon, May 22, 2017 at 10:34 AM, Br= ian Fries <iphonzie@gmail.com> wrote:
Using WebDNA=E2=80=99s database contexts - REPLACE and APPEND - = every new record you add is added at the end of the .db file.

Typically, if you care about the order of the records, that is handle= d by the sort options in your SEARCH context.

If y= ou truly need a row in between two others for some reason (I can=E2=80=99t = think of why, but maybe you have a good case), you=E2=80=99ll have to resor= t to other means, such as manually editing the .db file in a spreadsheet or= a text editor, or using WebDNA=E2=80=99s INCLUDE to read the file into a T= EXT variable, manipulate the text to add the line where you want it, then u= se WRITEFILE to write it back to disk (makeing sure WebDNA does not have th= e database open in the meantime, or it may overwrite your changes).

- Brian

On May 21, 2017, at 2:30 PM, Sgbc Cebu <sgbccebu@gmail.com> wrote:
Dear TalkList:

Is it possible to insert a new l= ine, that is between existing rows, inside a db?

Thanks

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --001a113f7ca28385170550612873-- . Sgbc Cebu

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:

WebDNA 5.x & iTools 7 & Apache 2 (2003) [WebDNA] Free Hosting Amazon (2011) Re2: Calculating multiple shipping... (1997) Simple Store (2000) Multiple catalog databases and showcart (1997) Include vs. lookup? (1998) Credit Card Checking?? (1998) Multiple SSL Keys (1998) WCS Newbie question (1997) Scoping rules in WebDNA 4.0 (2000) A sendmail warning (2005) New York City sales tax database needed (1997) Browser Reloads and AddlineItem (1997) RE: [WebDNA] PHP Array translated to Webdna (2010) RE: IIS4b2 and WebCatalog b19 (1997) Processing all html files through WebCat or Typhoon (1998) Parse question (2005) 2.0Beta Command Ref (can't find this instruction) (1997) Help with sorting search results sorting (1998) Bug Report, maybe (1997)