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:

Root Folder problems cont. (1998) formulas.db ?? (1998) RE: [WebDNA] Security Images (Captcha) (2008) Grouping Fields in Context (1999) Looking for a special Image Upload Script (2004) can WC render sites out? (1997) Progress !! WAS: Trouble with formula.db (1997) X etc.... (1999) shownext url search (2001) HomePage Caution (1997) Location of Webcat site in folder hierarchy (1997) Re:Virtual hosting and webcatNT (1997) Calender code (2005) [append] problem (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Still Stumped on ShowNext...HELP! (1997) tcpconnect/tcpsend frustrations (2002) [SHOWIF AND/OR] (1997) XML version of WebDNA docs? (2000) Using Plug-In while running 1.6.1 (1997)