Re: [WebDNA] Problem reading field from .db

This WebDNA talk-list message is from

2010

It keeps the original formatting. numero = 105692
interpreted = N
texte = Yeah! That's what it was. Thank you Brian.sfbOn Aug 6, 2010, at 5:20 PM, Brian Fries wrote:> It looks like you've got an extra space in your field headers - the ="ONOFF" field is actually named "ONOFF(space)">=20> Brian Fries> BrainScan Software>=20>=20> On Aug 6, 2010, at 1:19 PM, wrote:>=20>> Hi All,>> I need a fresh set of eyes to look at my code.>> It's not reading a field from a .db, and I can't tell why. =20>> I've been at it for over an hour, and I can't find the problem.>>=20>> Below is the code, followed by the entire .db both are short.>> The code is part of an [include filename] so a lot of the html is =left out.>> The .db field name is INOUT.>> In the second pulldown list It's not showing the data from the .db, =it's only showing the field title [ONOFF], while at the same time it is =showing the other data from the .db from the [Job] field.>>=20>> Thanks for any help,>> Steve Braun>> sbraun1@twcny.rr.com>> ____________________________________________________________________>>=20>> >> >> =09>> >> >>

>>  Select:   >> >> Edit a Job=20>> [search =db=3D../timeclock/Job.db&geSKUTdata=3D1&eqONOFFdatarq=3DYes&asJOBsort=3D1]=[founditems]>> [hideif [SKUT]=3D999]=20>> [Job]>> [/hideif]>> [/founditems][/search] =20>>

>>  Select:   >> >> Activate a Job=20>> [search =db=3D../timeclock/Job.db&geSKUTdata=3D1&asJOBsort=3D1][founditems]>> [hideif [SKUT]=3D999]=20>> [Job] [ONOFF]=09>> [/hideif]>> [/founditems][/search] =20>>

>>=20>>=20>>=20>>=20>>=20>>=20>>=20>>=20>>=20>> SKUTONOFF JobDescription>> 999Yes=09>> 1003NoPlowing Snow=09>> 1009YesParking lot Sweeping=09>> 1010YesHerbicide Spraying=09>> 1011YesMowing Crew=09>> 1012YesSunoco Cleanup=09>> 1016YesFence job=09>> 1018YesManwaringManwaring level gravel=20>> 1019YesShop Clean UpThis is used to track time people spend =cleaning the Shop and putting away tools.>> 1021YesShop - Mechanic=09>> 1022YesOtherUse this field to add custom information>> 1023YesAlliance bank oswegoThey want us to repair the =asphalt curb where the plow hit it.=20>> 1024YesOnondaga County Spraying=09>> 1025Yes53 Beech Lane? WaterlineRepair water line - =Chris Stupp>> 1028YesSunoco SprayingRail Yard has been Sprayed but the fence =line and other areas around site need to be done.=20>> 1029YesSyracuse Energy Rail YardRail yard still needs =spraying>> 1030YesSithe-CamproadAdd topsoil, remove stump, seed>> 1031YesSithe-Culvert PipeAdd posts>> 1032YesSithe-Topsoil RepairRepair yard near electric yard, =herbicide spill>> 1033YesSithe-Hercide sprayingFollow around pond>>=20>>=20>>=20>>=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>> Bug Reporting: support@webdna.us>=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> Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Problem reading field from .db (Stephen Braun 2010) Re: [WebDNA] Problem reading field from .db (Brian Fries 2010) [WebDNA] Problem reading field from .db ( 2010)

Yeah! That's what it was. Thank you Brian.sfbOn Aug 6, 2010, at 5:20 PM, Brian Fries wrote:> It looks like you've got an extra space in your field headers - the ="ONOFF" field is actually named "ONOFF(space)">=20> Brian Fries> BrainScan Software>=20>=20> On Aug 6, 2010, at 1:19 PM, wrote:>=20>> Hi All,>> I need a fresh set of eyes to look at my code.>> It's not reading a field from a .db, and I can't tell why. =20>> I've been at it for over an hour, and I can't find the problem.>>=20>> Below is the code, followed by the entire .db both are short.>> The code is part of an [include filename] so a lot of the html is =left out.>> The .db field name is INOUT.>> In the second pulldown list It's not showing the data from the .db, =it's only showing the field title [ONOFF], while at the same time it is =showing the other data from the .db from the [Job] field.>>=20>> Thanks for any help,>> Steve Braun>> sbraun1@twcny.rr.com>> ____________________________________________________________________>>=20>> >> >> =09>> >> >>

>>  Select:   >> >> Edit a Job=20>> [search =db=3D../timeclock/Job.db&geSKUTdata=3D1&eqONOFFdatarq=3DYes&asJOBsort=3D1]=[founditems]>> [hideif [SKUT]=3D999]=20>> [Job]>> [/hideif]>> [/founditems][/search] =20>>

>>  Select:   >> >> Activate a Job=20>> [search =db=3D../timeclock/Job.db&geSKUTdata=3D1&asJOBsort=3D1][founditems]>> [hideif [SKUT]=3D999]=20>> [Job] [ONOFF]=09>> [/hideif]>> [/founditems][/search] =20>>

>>=20>>=20>>=20>>=20>>=20>>=20>>=20>>=20>>=20>> SKUTONOFF JobDescription>> 999Yes=09>> 1003NoPlowing Snow=09>> 1009YesParking lot Sweeping=09>> 1010YesHerbicide Spraying=09>> 1011YesMowing Crew=09>> 1012YesSunoco Cleanup=09>> 1016YesFence job=09>> 1018YesManwaringManwaring level gravel=20>> 1019YesShop Clean UpThis is used to track time people spend =cleaning the Shop and putting away tools.>> 1021YesShop - Mechanic=09>> 1022YesOtherUse this field to add custom information>> 1023YesAlliance bank oswegoThey want us to repair the =asphalt curb where the plow hit it.=20>> 1024YesOnondaga County Spraying=09>> 1025Yes53 Beech Lane? WaterlineRepair water line - =Chris Stupp>> 1028YesSunoco SprayingRail Yard has been Sprayed but the fence =line and other areas around site need to be done.=20>> 1029YesSyracuse Energy Rail YardRail yard still needs =spraying>> 1030YesSithe-CamproadAdd topsoil, remove stump, seed>> 1031YesSithe-Culvert PipeAdd posts>> 1032YesSithe-Topsoil RepairRepair yard near electric yard, =herbicide spill>> 1033YesSithe-Hercide sprayingFollow around pond>>=20>>=20>>=20>>=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>> Bug Reporting: support@webdna.us>=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> Bug Reporting: support@webdna.us Stephen Braun

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:

WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Items XX to XX shown (1997) [Announce] WebCatalog 2.1 Released (1998) WebCat2 - many [carts] on one template page? (1997) selling? (2001) Platform Switch (1997) [OT] Internet connection problem (2003) Help formatting search results w/ table (1997) Form Weirdness (2002) Email Formatting and Encryption (1998) Is using [URL] recommended even on an email address? (1999) WEBCAT with SQL backend. Help please! (2000) Showif date range comparison (1999) Universal root for WC errors? (1997) WebCat Stuff (2001) [WebDNA] Date and Time as numbers (2009) HELP WITH DATES (1997) WebCat2b12plugin - [search] is broken ... not! (1997) Frames (1997) RAM to disk - well correction. (2002)