numero = 45155
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Gary Krockover
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...