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:

Test (2002) Carts & cookies (1999) Am on the list? (1997) Locking up with WebCatalog... (1997) Problems with [Applescript] (1997) Look out kiwis! (2003) RE: Languages (1997) japanese characters (1997) upgrading (1997) when is date system date or order date? (1997) Re:trouble (1997) 'RequiredField' Question (1998) F3 crashing server (1997) Upgrading old WebCat Database Files (1997) Sample Tearoom Search Error (1997) CustomerType - WebDNA Variable (2004) GuestBook example (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) CGI Request Time Out (1997) docs for WebCatalog2 (1997)