numero = 45157
interpreted = N
texte = I'm just testing at the moment and at this point it is a number, but I will want it to be a string match.[Formvariables] loop:1,template,IGroupAdmin:Applications (Mac OS 9):WebSTAR Server Suite 4. 2:ClassPicsTest:picresults.tpl 2,startat,1 3,max,1 4,AD_NUMBERdata,1234 5,SearchPic,Go Get It!> From: Gary Krockover > Reply-To: (WebCatalog Talk) > Date: Tue, 12 Nov 2002 15:06:30 -0600 > To: (WebCatalog Talk) > Subject: Re: search problem > > Is Ad_Number really a number? I thought your first post said it was a text > field. Might of misread it though. If not a number, take out the > &type=num. Then again, I don't see why Ad_Number would be anything but a > number :) > > I guess you're passing the value via the form. If you put a formvariables > at the top of the page, is the value passing correctly? > > > > Would be all you needed on the form to pass that value (don't need your > search in the form). > > I've seen the value=[input][/input] part recommended here and have begun > to use it myself. It shouldn't cause the issue either way though. > > GK > > | Tried that, if I use ne for my comparison I find the record. This is too > | weird, I must be on drugs. > | > | This does not work: > | [search db=classpic.db&eqAD_Numberdatarq=[Ad_Number]&Ad_Numbertype=num] > | > | This does: > | [search db=classpic.db&neAD_Numberdatarq=[Ad_Number]&Ad_Numbertype=num] > | > | but this would find everything. > | > | > From: Gary Krockover > | > Reply-To: (WebCatalog Talk) > | > Date: Tue, 12 Nov 2002 14:51:22 -0600 > | > To: (WebCatalog Talk) > | > Subject: Re: search problem > | > > | > So you're not using a search context then? If you are using a context, > then > | > use the > | > [search db=classpic.db&eqAD_Numberdatarq=[Ad_Number]] > | > > | > If not, then use: > | > > | > > | > etc... > | > > | > etc... > | > > | > GK > | > > | > > | > | I had on my search > page. > | > | > | > | > From: Gary Krockover > | > | > Reply-To: (WebCatalog Talk) > | > | > Date: Tue, 12 Nov 2002 14:39:55 -0600 > | > | > To: (WebCatalog Talk) > | > | > Subject: Re: search problem > | > | > > | > | > Are you making it a required match? > | > | > > | > | > [search db=classpic.db&eqAD_NumberdataRQ=[Ad_Number]] > | > | > > | > | > GK > | > | > > | > | > > | > | > | I must be brain dead after the holiday weekend. I need a search > to > | > give > | > | > me > | > | > | an exact match of a string. I'm only searching on one field, but > I'm > | > | > | obviously missing something. > | > | > | > | > | > | My search is: > | > | > | > | > | > | [search db=classpic.db&eqAD_Numberdata=[Ad_Number]] > | > | > | > | > | > | [founditems]... > | > | > | [/founditems] > | > | > | > | > | > | [/search] > | > | > | > | > | > | I'm passing the data from a form using one field only and it must > be > | > an > | > | > | exact match. AD_Numberdata is the text field name. > | > | > | > | > | > | Any help would be great. > | > | > | > | > | > | TIA > | > | > | > | > | > | Ken M > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I'm just testing at the moment and at this point it is a number, but I will want it to be a string match.[formvariables] loop:1,template,IGroupAdmin:Applications (Mac OS 9):WebSTAR Server Suite 4. 2:ClassPicsTest:picresults.tpl 2,startat,1 3,max,1 4,AD_NUMBERdata,1234 5,SearchPic,Go Get It!> From: Gary Krockover > Reply-To: (WebCatalog Talk) > Date: Tue, 12 Nov 2002 15:06:30 -0600 > To: (WebCatalog Talk) > Subject: Re: search problem > > Is Ad_Number really a number? I thought your first post said it was a text > field. Might of misread it though. If not a number, take out the > &type=num. Then again, I don't see why Ad_Number would be anything but a > number :) > > I guess you're passing the value via the form. If you put a formvariables > at the top of the page, is the value passing correctly? > > > > Would be all you needed on the form to pass that value (don't need your > search in the form). > > I've seen the value=[input][/input] part recommended here and have begun > to use it myself. It shouldn't cause the issue either way though. > > GK > > | Tried that, if I use ne for my comparison I find the record. This is too > | weird, I must be on drugs. > | > | This does not work: > | [search db=classpic.db&eqAD_Numberdatarq=[Ad_Number]&Ad_Numbertype=num] > | > | This does: > | [search db=classpic.db&neAD_Numberdatarq=[Ad_Number]&Ad_Numbertype=num] > | > | but this would find everything. > | > | > From: Gary Krockover > | > Reply-To: (WebCatalog Talk) > | > Date: Tue, 12 Nov 2002 14:51:22 -0600 > | > To: (WebCatalog Talk) > | > Subject: Re: search problem > | > > | > So you're not using a search context then? If you are using a context, > then > | > use the > | > [search db=classpic.db&eqAD_Numberdatarq=[Ad_Number]] > | > > | > If not, then use: > | > > | > > | > etc... > | > > | > etc... > | > > | > GK > | > > | > > | > | I had on my search > page. > | > | > | > | > From: Gary Krockover > | > | > Reply-To: (WebCatalog Talk) > | > | > Date: Tue, 12 Nov 2002 14:39:55 -0600 > | > | > To: (WebCatalog Talk) > | > | > Subject: Re: search problem > | > | > > | > | > Are you making it a required match? > | > | > > | > | > [search db=classpic.db&eqAD_NumberdataRQ=[Ad_Number]] > | > | > > | > | > GK > | > | > > | > | > > | > | > | I must be brain dead after the holiday weekend. I need a search > to > | > give > | > | > me > | > | > | an exact match of a string. I'm only searching on one field, but > I'm > | > | > | obviously missing something. > | > | > | > | > | > | My search is: > | > | > | > | > | > | [search db=classpic.db&eqAD_Numberdata=[Ad_Number]] > | > | > | > | > | > | [founditems]... > | > | > | [/founditems] > | > | > | > | > | > | [/search] > | > | > | > | > | > | I'm passing the data from a form using one field only and it must > be > | > an > | > | > | exact match. AD_Numberdata is the text field name. > | > | > | > | > | > | Any help would be great. > | > | > | > | > | > | TIA > | > | > | > | > | > | Ken M > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Ken MacMurchy
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...