Re: [WebDNA] Text Variable in Search
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105376
interpreted = N
texte = This is a multi-part message in MIME format. ------=_NextPart_000_000E_01CB1080.29C4C210 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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_000E_01CB1080.29C4C210 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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_000E_01CB1080.29C4C210--
Associated Messages, from the most recent to the oldest:
This is a multi-part message in MIME format. ------=_NextPart_000_000E_01CB1080.29C4C210 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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_000E_01CB1080.29C4C210 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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_000E_01CB1080.29C4C210--
"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:
setting cookies for another domain? (2002)
Something wrong with this list? (2006)
Adding Header Values with [SetHeader] (1998)
[ReturnRaw] and hiding FORM data (2003)
Upgrading from version (1998)
Mac Webcat 3.0.3b1 memory leak redirect inside search (1998)
Question re: FlushDatabases (1997)
Summing fields (1997)
WebCat 4.0.1 (2000)
Time/date formatting %X doesn't work ... (1997)
For those of you not on the WebCatalog Beta... (1997)
Checking Webdna is running (2007)
Sub Totals (2000)
[LOOKUP] (1997)
taxTotal, grandTotal (1997)
please anybody help (2005)
[OT] BBedit Blank Line removal (2003)
Separating My File Field (2004)
Sort Order on a page search (1997)
RE: WebCat and image maps (1997)