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:

WebCatalog [FoundItems] Problem - AGAIN - (1997) FlushDatabase Suggestion (1998) when is failing to [URL]ize values in a comparison risky? (1999) Forms Search Questions (1997) corrupted jpgs (2003) GoLive CyberStudio 1.0.1 (1997) Verify entry into a text field (2005) Emailer error 571 (1998) Rendering out a page (1997) page chokes on hideif when false and ignored (1998) creating a ShipCosts database (1997) Sku numbers (1997) URGENT! ACGI Stopped!!!! (1997) Customizing WebDelivery.html (1998) Upgrading old WebCat Database Files (1997) switching users (1998) OSX Continued (2000) WebCat2b13 Command Reference Doc error (1997) Search Engine questions ... (2002) .html to .tpl; ***TIP (1998)