Re: [WebDNA] Problem reading field from .db

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105691
interpreted = N
texte = It looks like you've got an extra space in your field headers - the = "ONOFF" field is actually named "ONOFF(space)" Brian Fries BrainScan Software On Aug 6, 2010, at 1:19 PM, wrote: > 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:    > 
> 
Select:    > 
>=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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Problem reading field from .db (Stephen Braun 2010)
  2. Re: [WebDNA] Problem reading field from .db (Brian Fries 2010)
  3. [WebDNA] Problem reading field from .db ( 2010)
It looks like you've got an extra space in your field headers - the = "ONOFF" field is actually named "ONOFF(space)" Brian Fries BrainScan Software On Aug 6, 2010, at 1:19 PM, wrote: > 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:    > 
> 
Select:    > 
>=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 Brian Fries

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:

WebDNA Windows 5.0 sendmail bug (2003) Shipping Formula % (2003) [LOOKUP] (1997) FM PRO Compatibility Issue - Single Database w/oConversions (1997) WebCat2 beta FTP site (1997) webdna preferences (2005) Initiating NewCart (1997) Need relative path explanation (1997) [recordrank]? (2000) Download Question (1997) Opinion: [input] should be called [output] ... (1997) Separate SSL Server (1997) docs for WebCatalog2 (1997) Emailer file formats (1998) PIXO (1997) Big Databases (1997) Any user support forums or is the Talklist it? (2007) Product Name in AdminResults.inc (2001) Emailer setup (1997) Leap Day Triggers? (2000)