Fwd: [WebDNA] Fails to recognize comma-separated db
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105391
interpreted = N
texte = --Apple-Mail-14-498359721 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hello everybody, and particularely Ken, Matt and Stuart. We would not = like to leave a bug if there is a problem with the Merge format. Please, = could you confirm there is indeed a problem of databases not read using = this format? in this case, woud you be so kind to post the field names = format and one or two lines of your databases. As explained in WebDNA website, the proper format is=20 ---------------------------------------------------------------- name,address,city,state,zip "Grant","1180 Central Ave","San Marcos","CA","92079" "PCS","11770 Bernardo Plaza Court","San Diego","CA","92128" ---------------------------------------------------------------- and it works, at least for me. Here a small test: just upload this to = any WebDNA served website and open "states2.dna" file with your browser. --Apple-Mail-14-498359721 Content-Disposition: attachment; filename=states2.dna Content-Type: application/octet-stream; name="states2.dna" Content-Transfer-Encoding: 7bit [search db=states2.db&geSTATEdata=1&refsort=1&max=10&startat=[starthere]] [shownext position=begin]
[start]-[end] | [/shownext] [shownext position=middle]
[start]-[end] | [/shownext] [shownext position=end]
[start]-[end] | [/shownext]
[founditems]
-[state][/founditems] [/search] --Apple-Mail-14-498359721 Content-Disposition: attachment; filename=states2.db Content-Type: application/octet-stream; name="states2.db" Content-Transfer-Encoding: 7bit ref,state "1","Alabama" "2","Alaska" "3","American Samoa" "4","Arizona" "5","Arkansas" "6","California" "7","Colorado" "8","Connecticut" "9","Delaware" "10","District of Columbia" "11","Florida" "12","Georgia" "13","Guam" "14","Hawaii" "15","Idaho" "16","Illinois" "17","Indiana" "18","Iowa" "19","Kansas" "20","Kentucky" "21","Louisiana" "22","Maine" "23","Maryland" "24","Massachusetts" "25","Michigan" "26","Minnesota" "27","Mississippi" "28","Missouri" "29","Montana" "30","Nebraska" "31","Nevada" "32","New Hampshire" "33","New Jersey" "34","New Mexico" "35","New York" "36","North Carolina" "37","North Dakota" "38","Northern Mariana","Islands" "39","Ohio" "40","Oklahoma" "41","Oregon" "42","Pennsylvania" "43","Puerto Rico" "44","Rhode Island" "45","South Carolina" "46","South Dakota" "47","Tennessee" "48","Texas" "49","U.S. Virgin Islands" "50","Utah" "51","Vermont" "52","Virginia" "53","Washington" "54","West Virginia" "55","Wisconsin" "56","Wyoming" --Apple-Mail-14-498359721 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii - chris Begin forwarded message: > From: christophe.billiottet@webdna.us > Date: June 22, 2010 22:40:02 GMT-03:00 > To:
> Subject: Re: [WebDNA] Fails to recognize comma-separated db > Reply-To: >=20 > Sorry, i cannot reproduce: do you follow the format explained at = http://www.webdna.us/database-format.dna? >=20 > for instance >=20 > ---------------------------------------------------------------- > name,address,city,state,zip > "Grant","1180 Central Ave","San Marcos","CA","92079" > "PCS","11770 Bernardo Plaza Court","San Diego","CA","92128" > ---------------------------------------------------------------- >=20 >=20 >=20 > Here a small example: >=20 >=20 > - chris > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D > WebDNA Software Corporation > 16192 Coastal Highway > Lewes, DE 19958 >=20 > On Jun 22, 2010, at 22:06, Stuart Tremain wrote: >=20 >> Me too ...... >>=20 >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> On 23/06/2010, at 10:30 AM, christophe.billiottet@webdna.us wrote: >>=20 >>> Anyone with the same problem Ken found? >>>=20 >>> - chris >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D >>> WebDNA Software Corporation >>> 16192 Coastal Highway >>> Lewes, DE 19958 >>>=20 >>> On Jun 22, 2010, at 21:24, Kenneth Grome wrote: >>>=20 >>>>=20 >>>>> Well, i have no idea: it is the first time i hear someone speaking = about such a problem. As far as i know, WebDNA started to read = comma-separated databases in 1997, this specific code has not been = changed since then. >>>>=20 >>>> Since it no longer works the way it did in 1997, maybe now is a = good time to remove the part of webdna's description that says it can = open and read comma-delimited db's without modification. >>>>=20 >>>> Sincerely, >>>> Kenneth Grome >>>> --------------------------------------------------------- >>>> 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 >>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 >>>=20 >>> --------------------------------------------------------- >>> 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 >>> old archives: http://dev.webdna.us/TalkListArchive/ >>> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category(8 >>=20 >> --------------------------------------------------------- >> 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 >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category(8 >=20 --Apple-Mail-14-498359721--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-14-498359721 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hello everybody, and particularely Ken, Matt and Stuart. We would not = like to leave a bug if there is a problem with the Merge format. Please, = could you confirm there is indeed a problem of databases not read using = this format? in this case, woud you be so kind to post the field names = format and one or two lines of your databases. As explained in WebDNA website, the proper format is=20 ---------------------------------------------------------------- name,address,city,state,zip "Grant","1180 Central Ave","San Marcos","CA","92079" "PCS","11770 Bernardo Plaza Court","San Diego","CA","92128" ---------------------------------------------------------------- and it works, at least for me. Here a small test: just upload this to = any WebDNA served website and open "states2.dna" file with your browser. --Apple-Mail-14-498359721 Content-Disposition: attachment; filename=states2.dna Content-Type: application/octet-stream; name="states2.dna" Content-Transfer-Encoding: 7bit [search db=states2.db&geSTATEdata=1&refsort=1&max=10&startat=[starthere]] [shownext position=begin] [start]-[end] | [/shownext] [shownext position=middle] [start]-[end] | [/shownext] [shownext position=end] [start]-[end] | [/shownext]
[founditems]
-[state][/founditems] [/search] --Apple-Mail-14-498359721 Content-Disposition: attachment; filename=states2.db Content-Type: application/octet-stream; name="states2.db" Content-Transfer-Encoding: 7bit ref,state "1","Alabama" "2","Alaska" "3","American Samoa" "4","Arizona" "5","Arkansas" "6","California" "7","Colorado" "8","Connecticut" "9","Delaware" "10","District of Columbia" "11","Florida" "12","Georgia" "13","Guam" "14","Hawaii" "15","Idaho" "16","Illinois" "17","Indiana" "18","Iowa" "19","Kansas" "20","Kentucky" "21","Louisiana" "22","Maine" "23","Maryland" "24","Massachusetts" "25","Michigan" "26","Minnesota" "27","Mississippi" "28","Missouri" "29","Montana" "30","Nebraska" "31","Nevada" "32","New Hampshire" "33","New Jersey" "34","New Mexico" "35","New York" "36","North Carolina" "37","North Dakota" "38","Northern Mariana","Islands" "39","Ohio" "40","Oklahoma" "41","Oregon" "42","Pennsylvania" "43","Puerto Rico" "44","Rhode Island" "45","South Carolina" "46","South Dakota" "47","Tennessee" "48","Texas" "49","U.S. Virgin Islands" "50","Utah" "51","Vermont" "52","Virginia" "53","Washington" "54","West Virginia" "55","Wisconsin" "56","Wyoming" --Apple-Mail-14-498359721 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii - chris Begin forwarded message: > From: christophe.billiottet@webdna.us > Date: June 22, 2010 22:40:02 GMT-03:00 > To: > Subject: Re: [WebDNA] Fails to recognize comma-separated db > Reply-To: >=20 > Sorry, i cannot reproduce: do you follow the format explained at = http://www.webdna.us/database-format.dna? >=20 > for instance >=20 > ---------------------------------------------------------------- > name,address,city,state,zip > "Grant","1180 Central Ave","San Marcos","CA","92079" > "PCS","11770 Bernardo Plaza Court","San Diego","CA","92128" > ---------------------------------------------------------------- >=20 >=20 >=20 > Here a small example: >=20 >=20 > - chris > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D > WebDNA Software Corporation > 16192 Coastal Highway > Lewes, DE 19958 >=20 > On Jun 22, 2010, at 22:06, Stuart Tremain wrote: >=20 >> Me too ...... >>=20 >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> On 23/06/2010, at 10:30 AM, christophe.billiottet@webdna.us wrote: >>=20 >>> Anyone with the same problem Ken found? >>>=20 >>> - chris >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D >>> WebDNA Software Corporation >>> 16192 Coastal Highway >>> Lewes, DE 19958 >>>=20 >>> On Jun 22, 2010, at 21:24, Kenneth Grome wrote: >>>=20 >>>>=20 >>>>> Well, i have no idea: it is the first time i hear someone speaking = about such a problem. As far as i know, WebDNA started to read = comma-separated databases in 1997, this specific code has not been = changed since then. >>>>=20 >>>> Since it no longer works the way it did in 1997, maybe now is a = good time to remove the part of webdna's description that says it can = open and read comma-delimited db's without modification. >>>>=20 >>>> Sincerely, >>>> Kenneth Grome >>>> --------------------------------------------------------- >>>> 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 >>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 >>>=20 >>> --------------------------------------------------------- >>> 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 >>> old archives: http://dev.webdna.us/TalkListArchive/ >>> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category(8 >>=20 >> --------------------------------------------------------- >> 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 >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category(8 >=20 --Apple-Mail-14-498359721--
christophe.billiottet@webdna.us
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:
SandBox and ImageMagick (2003)
unable to launch acgi in WebCat (1997)
WebDNA 5.0 Questions (2003)
Emailer (1997)
Mult. Field in mailme.tpl (2000)
Need help with emailer- 2 issues (1997)
WebCatalog vidoes (was: Prices Dropped) (1998)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
problem serving foreign languages text (1997)
listfiles-looking for slick solution (1997)
multiple search commands (1997)
WebCatalog/Mac 2.1b2 New Features (1997)
How do I get multiple unique numbers on one template? (2000)
Multiple prices (1997)
E-Mailer (WebCatb15acgiMac) (1997)
expired beta (1997)
serial number dishing (1997)
WebCat2: multiple currency support (1997)
4.0 send email ticks. . (2000)
[searchString] (1997)