Re: [WebDNA] copy some database fields into a new database

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112683
interpreted = N
texte = 266--Apple-Mail=_5D8F504B-0CBE-4A6B-9B51-D30245ECE5C4Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiTo clarify, are you trying to copy a few columns of all 3100 records to =a new database, or copy X number of rows from one database to another?=20=It sounds like you want to do this:[writefile file=3Dnew.db]IDfield1field2field3[/writefile][search db=3Doriginal.db&neIDfield=3D[blank]][founditems][appendfile file=3Dnew.db&secure=3DF][index] =[originaldb-field-a][originaldb-field-d] [originaldb-field-f][/appendfile][/founditems][/search]in this case, the [founditems] is doing the work of a looping type =functionality.=20-Brian B. Burton> On Mar 24, 2016, at 3:23 PM, Rich Kwas =wrote:>=20> I have a db with 3100+ records> I need to copy some fields from this db into a brand new db.>=20> Would using [Loop] be a good way to do this?> Another way?>=20> I tried to use [loop] but I got into an endless loop where nothing but =blank records was being written into a new db. I was searching for "all" =the records and then appending certain fields into the new db. I had to =pull the plug on the pc after 43,000 records, couldn't figure out a way =to break the loop.>=20> [Loop] isn't explained in great detail in the docs and the one sample =is pretty simple...> I've never needed to use the [loop] context I guess so never utilized =it before.>=20>=20> Rich> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_5D8F504B-0CBE-4A6B-9B51-D30245ECE5C4Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiTo clarify, are you trying to copy a few columns of all 3100 =records to a new database, or copy X number of rows from one database to =another?

It =sounds like you want to do this:

[writefile file=3Dnew.db]ID=field1=field2=field3

[/writefile]

[search =db=3Doriginal.db&neIDfield=3D[blank]]

=[founditems]

[appendfile =file=3Dnew.db&secure=3DF][index] [originaldb-field-a]=[originaldb-field-d] [originaldb-field-f]

[/appendfile]

=[/founditems]

[/search]

in this case, the =[founditems] is doing the work of a looping type =functionality.

-Brian B. =Burton

On Mar 24, 2016, at 3:23 PM, Rich Kwas <richkwasniewski@yahoo.com> wrote:

I =have a db with 3100+ records
I =need to copy some fields from this db into a brand new db.

Would using [Loop] be a good way to do this?
Another way?

I tried to use [loop] but I got into an endless =loop where nothing but blank records was being written into a new db. I =was searching for "all" the records and then appending certain fields =into the new db. I had to pull the plug on the pc after 43,000 records, =couldn't figure out a way to break the loop.

[Loop] isn't explained in great detail in the =docs and the one sample is pretty simple...
I've =never needed to use the [loop] context I guess so never utilized it =before.

Rich
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--Apple-Mail=_5D8F504B-0CBE-4A6B-9B51-D30245ECE5C4--. Associated Messages, from the most recent to the oldest:

Re: [WebDNA] copy some database fields into a new database (Rich Kwas 2016)
Re: [WebDNA] copy some database fields into a new database (Brian Burton 2016)
Re: [WebDNA] copy some database fields into a new database (Rich Kwas 2016)
Re: [WebDNA] copy some database fields into a new database (Brian Burton 2016)
[WebDNA] copy some database fields into a new database (Rich Kwas 2016)

266--Apple-Mail=_5D8F504B-0CBE-4A6B-9B51-D30245ECE5C4Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiTo clarify, are you trying to copy a few columns of all 3100 records to =a new database, or copy X number of rows from one database to another?=20=It sounds like you want to do this:[writefile file=3Dnew.db]IDfield1field2field3[/writefile][search db=3Doriginal.db&neIDfield=3D[blank]][founditems][appendfile file=3Dnew.db&secure=3DF][index] =[originaldb-field-a][originaldb-field-d] [originaldb-field-f][/appendfile][/founditems][/search]in this case, the [founditems] is doing the work of a looping type =functionality.=20-Brian B. Burton> On Mar 24, 2016, at 3:23 PM, Rich Kwas =wrote:>=20> I have a db with 3100+ records> I need to copy some fields from this db into a brand new db.>=20> Would using [loop] be a good way to do this?> Another way?>=20> I tried to use [loop] but I got into an endless loop where nothing but =blank records was being written into a new db. I was searching for "all" =the records and then appending certain fields into the new db. I had to =pull the plug on the pc after 43,000 records, couldn't figure out a way =to break the loop.>=20> [loop] isn't explained in great detail in the docs and the one sample =is pretty simple...> I've never needed to use the [loop] context I guess so never utilized =it before.>=20>=20> Rich> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_5D8F504B-0CBE-4A6B-9B51-D30245ECE5C4Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiTo clarify, are you trying to copy a few columns of all 3100 =records to a new database, or copy X number of rows from one database to =another?