What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: [WebDNA] Text Variable in Search

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105377
interpreted = N
texte = This is a multi-part message in MIME format. ------=_NextPart_000_0021_01CB1080.7F18A150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable correction (forgot an ampersand): [search db=3Dinc/content.db&geSKUdata=3D0&SKUtype=3Dnum&SKUsort=3D1] From: Dan Strong=20 Sent: Sunday, June 20, 2010 1:54 PM To: talk@webdna.us=20 Subject: Re: [WebDNA] Text Variable in Search From: sgbc cebu=20 Sent: Sunday, June 20, 2010 1:29 PM To: talk@webdna.us=20 Subject: [WebDNA] Text Variable in Search Not totally sure what you're trying to do, but your argument (ge) = requires that SKU is *greater than or equal to* 0, so you also need to = tell the search query to treat the SKU field as a number for this = search, otherwise it can't make a numerical comparison: [search db=3Dinc/content.db&geSKUdata=3D0&SKUtype=3DnumSKUsort=3D1] [founditems] [showif [url][Slideshow][/url]=3D[url]YES[/url]] [text]YES=3DRockU[/text] [/showif] [/founditems] [/search] [YES] Also, not sure why you double-bracketed [Slideshow], but I removed the = second set of brackets, and if there are more than one SKUs that are = greater than or equal to 0 then you're going to get the value for the = last record in the [founditems] loop. If you are just making an example for learning purposes then hopefully = my code will help your understanding, but if this is fr an actual = project, I'd want to know more about what you're trying to do before I = said my code was the best solution.=20 -Dan ---------------------------------------- Had difficulty of pulling a text variable via a database. Please consider this code: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D [text]YES=3DRockU[/text] [search db=3Dinc/content.db&geSKUdata=3D0&SKUsort=3D1] [founditems] [[Slideshow]] [/founditems] [/search] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D Where [SlideShow] either will get a YES or a NO from database. The problem is when [SlideShow] tells "YES". It will appear "[Yes]" on the page instead of "Rocku" Thanks ------=_NextPart_000_0021_01CB1080.7F18A150 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
correction (forgot an = ampersand):
[search=20 db=3Dinc/content.db&geSKUdata=3D0&SKUtype=3Dnum&SKUsort=3D1]<= /FONT>
 

From: Dan Strong
Sent: Sunday, June 20, 2010 1:54 PM
To: talk@webdna.us
Subject: Re: [WebDNA] Text Variable in = Search

 

From: sgbc cebu
Sent: Sunday, June 20, 2010 1:29 PM
To: talk@webdna.us
Subject: [WebDNA] Text Variable in Search
Not totally sure what you're trying to = do, but your=20 argument (ge) requires that SKU is *greater than or equal to* 0, so you = also=20 need to tell the search query to treat the SKU field as a number = for this=20 search, otherwise it can't make a numerical comparison:
 
[search=20 db=3Dinc/content.db&geSKUdata=3D0&SKUtype=3DnumSKUsort=3D1]
&n= bsp;   [founditems]
        [showif = [url][Slideshow][/url]=3D[url]YES[/url]]
           &n= bsp;[text]YES=3DRockU[/text]
        [/showif]
    [/founditems]
[/search]
 
[YES]
 
Also, not sure why you double-bracketed = [Slideshow], but I removed the second set of brackets, and if there are = more=20 than one SKUs that are greater than or equal to 0 then you're going to = get the=20 value for the last record in the [founditems] loop.
 
If you are just making an example for = learning=20 purposes then hopefully my code will help your understanding, but = if this=20 is fr an actual project, I'd want to know more about what you're trying = to do=20 before I said my code was the best solution. 
 
-Dan
----------------------------------------


Had difficulty of pulling a text variable via a=20 database.

Please consider this=20 code:

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

[text]YES=3DRockU[/text]

[search=20 db=3Dinc/content.db&geSKUdata=3D0&SKUsort=3D1]
[founditems]
[[Slideshow]]

[/founditems]
[/search]

=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D

Where=20 [SlideShow] either will get a YES or a NO from database.

The = problem is=20 when [SlideShow] tells "YES".
It will appear "[Yes]" on the page = instead of=20 "Rocku"

Thanks
------=_NextPart_000_0021_01CB1080.7F18A150-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Text Variable in Search (sgbc cebu 2010)
  2. Re: [WebDNA] Text Variable in Search ("Terry Wilson" 2010)
  3. Re: [WebDNA] Text Variable in Search ("Dan Strong" 2010)
  4. Re: [WebDNA] Text Variable in Search ("Dan Strong" 2010)
  5. [WebDNA] Text Variable in Search (sgbc cebu 2010)
This is a multi-part message in MIME format. ------=_NextPart_000_0021_01CB1080.7F18A150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable correction (forgot an ampersand): [search db=3Dinc/content.db&geSKUdata=3D0&SKUtype=3Dnum&SKUsort=3D1] From: Dan Strong=20 Sent: Sunday, June 20, 2010 1:54 PM To: talk@webdna.us=20 Subject: Re: [WebDNA] Text Variable in Search From: sgbc cebu=20 Sent: Sunday, June 20, 2010 1:29 PM To: talk@webdna.us=20 Subject: [WebDNA] Text Variable in Search Not totally sure what you're trying to do, but your argument (ge) = requires that SKU is *greater than or equal to* 0, so you also need to = tell the search query to treat the SKU field as a number for this = search, otherwise it can't make a numerical comparison: [search db=3Dinc/content.db&geSKUdata=3D0&SKUtype=3DnumSKUsort=3D1] [founditems] [showif [url][Slideshow][/url]=3D[url]YES[/url]] [text]YES=3DRockU[/text] [/showif] [/founditems] [/search] [YES] Also, not sure why you double-bracketed [Slideshow], but I removed the = second set of brackets, and if there are more than one SKUs that are = greater than or equal to 0 then you're going to get the value for the = last record in the [founditems] loop. If you are just making an example for learning purposes then hopefully = my code will help your understanding, but if this is fr an actual = project, I'd want to know more about what you're trying to do before I = said my code was the best solution.=20 -Dan ---------------------------------------- Had difficulty of pulling a text variable via a database. Please consider this code: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D [text]YES=3DRockU[/text] [search db=3Dinc/content.db&geSKUdata=3D0&SKUsort=3D1] [founditems] [[Slideshow]] [/founditems] [/search] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D Where [SlideShow] either will get a YES or a NO from database. The problem is when [SlideShow] tells "YES". It will appear "[Yes]" on the page instead of "Rocku" Thanks ------=_NextPart_000_0021_01CB1080.7F18A150 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
correction (forgot an = ampersand):
[search=20 db=3Dinc/content.db&geSKUdata=3D0&SKUtype=3Dnum&SKUsort=3D1]<= /FONT>
 

From: Dan Strong
Sent: Sunday, June 20, 2010 1:54 PM
Subject: Re: [WebDNA] Text Variable in = Search

 

From: sgbc cebu
Sent: Sunday, June 20, 2010 1:29 PM
Subject: [WebDNA] Text Variable in Search
Not totally sure what you're trying to = do, but your=20 argument (ge) requires that SKU is *greater than or equal to* 0, so you = also=20 need to tell the search query to treat the SKU field as a number = for this=20 search, otherwise it can't make a numerical comparison:
 
[search=20 db=3Dinc/content.db&geSKUdata=3D0&SKUtype=3DnumSKUsort=3D1]
&n= bsp;   [founditems]
        [showif = [url][Slideshow][/url]=3D[url]YES[/url]]
           &n= bsp;[text]YES=3DRockU[/text]
        [/showif]
    [/founditems]
[/search]
 
[YES]
 
Also, not sure why you double-bracketed = [Slideshow], but I removed the second set of brackets, and if there are = more=20 than one SKUs that are greater than or equal to 0 then you're going to = get the=20 value for the last record in the [founditems] loop.
 
If you are just making an example for = learning=20 purposes then hopefully my code will help your understanding, but = if this=20 is fr an actual project, I'd want to know more about what you're trying = to do=20 before I said my code was the best solution. 
 
-Dan
----------------------------------------


Had difficulty of pulling a text variable via a=20 database.

Please consider this=20 code:

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

[text]YES=3DRockU[/text]

[search=20 db=3Dinc/content.db&geSKUdata=3D0&SKUsort=3D1]
[founditems]
[[Slideshow]]

[/founditems]
[/search]

=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D

Where=20 [SlideShow] either will get a YES or a NO from database.

The = problem is=20 when [SlideShow] tells "YES".
It will appear "[Yes]" on the page = instead of=20 "Rocku"

Thanks
------=_NextPart_000_0021_01CB1080.7F18A150-- "Dan Strong"

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:

What is WebDNA (1997) Emailer (2002) Where is Orders.db appended? (2000) [WebDNA] What version of linux (2009) Emailer help....! (1997) Bug Report, maybe (1997) Web Catalog vs. ICAT (1997) Trouble with formula.db (1997) purchase plugin (1996) formula??? (2000) Another question (1997) Questions (1998) Secure Server (1999) Multiple download orders of the same product? (1997) Adding Message to Order (1997) [cart]'s ever get recycled? (2000) WebCatalog f2 Installation (1997) international time (1997) Bug? (1997) WebSTAR 2.1 freezes my Mac (1997)