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:

Email template names (1997) OLD PROBLEM (1997) [OT] DOD again (2003) Here we go again... (2006) Running 2 two WebCatalog.acgi's (1996) Protect (1997) New Website with Redakto CMS (2003) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Generating unique SKU from [cart] - FIXED! (1997) weight based shipping cost questions (1997) RE: Automatic thumbnail images (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997) [WebDNA] Problem saving returned value as a variable (2012) [WebDNA] return missing db number (2010) [replace] has protection feature like [delete]? (2000) Odd linefeed problem (2003) [WriteFile] problems (1997) DBCOMMITER (2004) Search in 2 or more catalogs (1997) Multiple Search Fields (1998)