[WebDNA] Re: question posted by Jess (sgbc cebu)
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106448
interpreted = N
texte = --Apple-Mail-3-980717034Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiJess,=20try this (below).(untested. but you please test.. and say what happens.) (if you get =stuck it may be because you have not tried to code this yourself... and =so have not flushed out what info more we would need to help you here =more.) =20-Govinda------------------------[!]---START var init---[/!][showif =[URL][firstString][/URL]=3D[URL][raw][firstString][/raw][/URL]][text][URL]=[firstString][/URL]=3D07[/text][/showif][showif =[URL][secondString][/URL]=3D[URL][raw][secondString][/raw][/URL]][text][UR=L][secondString][/URL]=3D253[/text][/showif][!]---END var init-----[/!][if ("[URL][formSubmitted][/URL]"=3D"T")][then][table name=3Dsorter&fields=3DTBLsku][/table][text]searchValue=3D[firstString]-[secondString][/text][Search db=3Dyour.db&eqSKUdatarq=3D[URL][searchValue][/URL=]][FoundItems][Append =table=3Dsorter]TBLsku=3D[URL][SKU][/URL][/Append][/FoundItems][/Search][text]msg2User=3Danother?[/text][/then][else][text]msg2User=3Dstart[/text][/else][/if]
Untitled[Switch value=3D[URL][msg2User][/URL]][Case value=3D[URL]start[/URL]]
Please input what you want to search =for:
[/Case][Case value=3D[URL]another?[/URL]]
Here is what your search found:
[Search =table=3Dsorter&neTBLskudatarq=3DfindZemAll&asTBLskusort=3D1&max=3D500]
SKU |
[FoundItems]=[TBLsku] |
[/FoundItems]
[/Search]
Care to submit again?:
[/Case][Default]
Please input what you want to search =for:
[/Default][/Switch]
On 2011-03-29, at 7:44 AM, sgbc cebu wrote:> Hello Kenneth,>=20> To recall, we've met once you were yet here in Cebu.>=20> Anyway, am trying to build a database if perhaps to showcase =capabilities of webDNA in my contractual work in a government agency =here in the Philippines. This company uses Oracle which, at most is =being complained about the way it was implemented / setup... not to =mention the politics behind while its yet at its developing stage.>=20> Could there be someone who could do the sales stuff for webDNA =(admittedly I'm not good at that).>=20> Heres my question...>=20> How to search either 07-253 or 7253 from a database containing the =result for 07-253 using perhaps a delimiter within a form?>=20> I'm replying to talk@webdna.us expecting to join the loop of =conversation, is this correct?>=20> Thanks to all.>=20> Jess>=20>=20>=20>=20>=20>=20> 2011/3/27 Kenneth Grome
> > Ken, I have a question to pose to you with the whole> > community listening:> >> > Would you be willing to build this system, speculatively,> > on your own time, with the purpose of selling and> > supporting it ...>=20> Dan, I wish I could but I cannot. I need paid work at this> time in my life.>=20>=20> > Or would you be willing to come up with a cost estimate> > and then let the list team up and pay you for it?>=20> I'm not trying to rain on your parade but I have to be> honest when I say that really don't think there are enough> of us in existence to fund such a project. If I am correct> it would be a waste of my time to create an estimate.>=20> But I'm certainly willing to come up with a cost estimate> after you secure commitments for the majority of my> "guesstimate" of the project cost.>=20>=20> > You can count on your first $100 from me personally and I'm> > sure WSC can be convinced to pitch in as well.>=20> Thanks Dan. I know that WSC is interested so perhaps this> can be a collaborative project with both WebDNA users and> WSC funding the effort.>=20> I have thought about a project like this very seripusly> during the past year. Although I have no estimate yet, my> gut tells me that $20-25K is a more realistic figure than the> $10K you gave as an example.>=20> If you can get commitments for at least half this amount I> would be encouraged to think that it may be possible.>=20> Sincerely,> Kenneth Grome> ---------------------------------------------------------> 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>=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------------Govinda--Apple-Mail-3-980717034Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-ascii
try this =(below).
(untested. but you please test.. and say what =happens.) (if you get stuck it may be because you have not tried =to code this yourself... and so have not flushed out what info more we =would need to help you here more.) =
-Govinda
--------=----------------
<!DOCTYPE html PUBLIC ="-//W3C//DTD XHTML 1.0 Transitional//EN"
[!]---START var =init---[/!]
[showif =[URL][firstString][/URL]=3D[URL][raw][firstString][/raw][/URL]][text][URL]=[firstString][/URL]=3D07[/text][/showif]
[showif =[URL][secondString][/URL]=3D[URL][raw][secondString][/raw][/URL]][text][UR=L][secondString][/URL]=3D253[/text][/showif]
[!]---END var =init-----[/!]
[if =("[URL][formSubmitted][/URL]"=3D"T")]
=[then]
[table =name=3Dsorter&fields=3DTBLsku][/table]
=[text]searchValue=3D[firstString]-[secondString][/text]
<=span class=3D"Apple-tab-span" style=3D"white-space:pre">=[Search =db=3Dyour.db&eqSKUdatarq=3D[URL][searchValue][/URL]]
=[FoundItems]
[Append =table=3Dsorter]TBLsku=3D[URL][SKU][/URL][/Append]
=[/FoundItems]
[/Search]
=[text]msg2User=3Danother?[/text]
=[/then]
[else]
=[text]msg2User=3Dstart[/text]
=[/else]
[/if]
<head>
<meta =http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8" =/>
=<title>Untitled</title>
</head>
<body>[Switch =value=3D[URL][msg2User][/URL]]
[Case =value=3D[URL]start[/URL]]
<h3>Please =input what you want to search for:</h3>
=[/Case]
[Case =value=3D[URL]another?[/URL]]
<h2>Here is =what your search found:</h2>
=[Search =table=3Dsorter&neTBLskudatarq=3DfindZemAll&asTBLskusort=3D1&ma=x=3D500]
=<table>
=<tr>
=<th>SKU</th>
=</tr>
=[FoundItems]
=<tr>
=<td>[TBLsku]</td>
=</tr>
=[/FoundItems]
=</table>
=[/Search]
<h3>Care to =submit again?:</h3>
[/Case]
=[Default]
<h3>Please =input what you want to search for:</h3>
=[/Default]
[/Switch]
<form =action=3D"" method=3D"post">
<input =name=3D"firstString" type=3D"text" value=3D"[input][firstString][/input]" =/> -
<input =name=3D"secondString" type=3D"text" =value=3D"[input][secondString][/input]" />
=<input name=3D"formSubmitted" type=3D"hidden" value=3D"T" =/>
=<br /><br />
=<input name=3D"submit" type=3D"submit" value=3D"submit" =/>
=</form>
</body>
</html>
= =--Apple-Mail-3-980717034--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-3-980717034Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiJess,=20try this (below).(untested. but you please test.. and say what happens.) (if you get =stuck it may be because you have not tried to code this yourself... and =so have not flushed out what info more we would need to help you here =more.) =20-Govinda------------------------
[!]---START var init---[/!][showif =
[url][firstString][/URL]=3D
[url][raw][firstString][/raw][/URL]]
[text][url]=[firstString][/URL]=3D07[/text][/showif][showif =
[url][secondString][/URL]=3D
[url][raw][secondString][/raw][/URL]]
[text][UR=L][secondString][/URL]=3D253[/text][/showif]
[!]---END var init-----[/!][if ("
[url][formSubmitted][/URL]"=3D"T")][then][table name=3Dsorter&fields=3DTBLsku][/table]
[text]searchValue=3D[firstString]-[secondString][/text][Search db=3Dyour.db&eqSKUdatarq=3D
[url][searchValue][/URL=]]
[founditems][Append =table=3Dsorter]TBLsku=3D
[url][SKU][/URL][/Append][/FoundItems][/Search]
[text]msg2User=3Danother?[/text][/then][else]
[text]msg2User=3Dstart[/text][/else][/if]
Untitled[Switch value=3D
[url][msg2User][/URL]][Case value=3D
[url]start[/URL]]
Please input what you want to search =for:
[/Case][Case value=3D
[url]another?[/URL]]
Here is what your search found:
[Search =table=3Dsorter&neTBLskudatarq=3DfindZemAll&asTBLskusort=3D1&max=3D500]
[/Search]
Care to submit again?:
[/Case][Default]
Please input what you want to search =for:
[/Default][/Switch]
On 2011-03-29, at 7:44 AM, sgbc cebu wrote:> Hello Kenneth,>=20> To recall, we've met once you were yet here in Cebu.>=20> Anyway, am trying to build a database if perhaps to showcase =capabilities of webDNA in my contractual work in a government agency =here in the Philippines. This company uses Oracle which, at most is =being complained about the way it was implemented / setup... not to =mention the politics behind while its yet at its developing stage.>=20> Could there be someone who could do the sales stuff for webDNA =(admittedly I'm not good at that).>=20> Heres my question...>=20> How to search either 07-253 or 7253 from a database containing the =result for 07-253 using perhaps a delimiter within a form?>=20> I'm replying to talk@webdna.us expecting to join the loop of =conversation, is this correct?>=20> Thanks to all.>=20> Jess>=20>=20>=20>=20>=20>=20> 2011/3/27 Kenneth Grome
> > Ken, I have a question to pose to you with the whole> > community listening:> >> > Would you be willing to build this system, speculatively,> > on your own time, with the purpose of selling and> > supporting it ...>=20> Dan, I wish I could but I cannot. I need paid work at this> time in my life.>=20>=20> > Or would you be willing to come up with a cost estimate> > and then let the list team up and pay you for it?>=20> I'm not trying to rain on your parade but I have to be> honest when I say that really don't think there are enough> of us in existence to fund such a project. If I am correct> it would be a waste of my time to create an estimate.>=20> But I'm certainly willing to come up with a cost estimate> after you secure commitments for the majority of my> "guesstimate" of the project cost.>=20>=20> > You can count on your first $100 from me personally and I'm> > sure WSC can be convinced to pitch in as well.>=20> Thanks Dan. I know that WSC is interested so perhaps this> can be a collaborative project with both WebDNA users and> WSC funding the effort.>=20> I have thought about a project like this very seripusly> during the past year. Although I have no estimate yet, my> gut tells me that $20-25K is a more realistic figure than the> $10K you gave as an example.>=20> If you can get commitments for at least half this amount I> would be encouraged to think that it may be possible.>=20> Sincerely,> Kenneth Grome> ---------------------------------------------------------> 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>=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------------Govinda--Apple-Mail-3-980717034Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-ascii
try this =(below).
(untested. but you please test.. and say what =happens.) (if you get stuck it may be because you have not tried =to code this yourself... and so have not flushed out what info more we =would need to help you here more.) =
-Govinda
--------=----------------
<!DOCTYPE html PUBLIC ="-//W3C//DTD XHTML 1.0 Transitional//EN"
[!]---START var =init---[/!]
[showif =
[url][secondString][/URL]=3D
[url][raw][secondString][/raw][/URL]]
[text][UR=L][secondString][/URL]=3D253[/text][/showif]
[!]---END var =init-----[/!]
[if =("
[url][formSubmitted][/URL]"=3D"T")]
=[then]
[table =name=3Dsorter&fields=3DTBLsku][/table]
=[text]searchValue=3D[firstString]-[secondString][/text]
<=span class=3D"Apple-tab-span" style=3D"white-space:pre">=[Search =db=3Dyour.db&eqSKUdatarq=3D
[url][searchValue][/URL]]
[Append =table=3Dsorter]TBLsku=3D
[url][SKU][/URL][/Append]
=[/FoundItems]
[/Search]
=[text]msg2User=3Danother?[/text]
=[/then]
[else]
=[text]msg2User=3Dstart[/text]
=[/else]
[/if]
<head>
<meta =http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8" =/>
=<title>Untitled</title>
</head>
<body>[Switch =value=3D
[url][msg2User][/URL]]
[Case =value=3D
[url]start[/URL]]
<h3>Please =input what you want to search for:</h3>
=[/Case]
[Case =value=3D
[url]another?[/URL]]
<h2>Here is =what your search found:</h2>
=[Search =table=3Dsorter&neTBLskudatarq=3DfindZemAll&asTBLskusort=3D1&ma=x=3D500]
=<table>
=<tr>
=<th>SKU</th>
=</tr>
=<tr>
=<td>[TBLsku]</td>
=</tr>
=[/FoundItems]
=</table>
=[/Search]
<h3>Care to =submit again?:</h3>
[/Case]
=[Default]
<h3>Please =input what you want to search for:</h3>
=[/Default]
[/Switch]
<form =action=3D"" method=3D"post">
<input =name=3D"firstString" type=3D"text" value=3D"
[input][firstString][/input]" =/> -
<input =name=3D"secondString" type=3D"text" =value=3D"
[input][secondString][/input]" />
=<input name=3D"formSubmitted" type=3D"hidden" value=3D"T" =/>
=<br /><br />
=<input name=3D"submit" type=3D"submit" value=3D"submit" =/>
=</form>
</body>
</html>
=