Re: Data Type Search Problem

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56002
interpreted = N
texte = read too quickly. If you have data being passed and you are getting all records returned it is probably not just FieldNameBLNK=T (but it is good to include it). Maybe some checkers for date formating??? what does your search look like? Donovan Donovan Brooke wrote: > Lets see your search... > > I'm guessing you need a: > FieldNameBLNK=T > > Donovan > > > > Justin Carroll wrote: > >> I have a database with an end_date header. This contains either an >> actual end date (ie. 03/14/2004) or a 0 for no ending date. >> >> My problem is that when doing a search on the field I use >> end_datetype=date. This ruins the search by pulling every record of >> the database when searching for any keyword (ie. lakflsjdfkd - pulls >> all records). >> >> I need to have end_datetype=date in there because the data table in my >> html page has clickable headers to sort the database. >> >> Does anyone have any suggestions as to how I can work around this? >> Thanks. >> >> Justin Carroll -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Data Type Search Problem ( Justin Carroll 2004)
  2. Re: Data Type Search Problem ( Glenn Busbin 2004)
  3. Re: Data Type Search Problem ( Justin Carroll 2004)
  4. Re: Data Type Search Problem ( Donovan Brooke 2004)
  5. Re: Data Type Search Problem ( Justin Carroll 2004)
  6. Re: Data Type Search Problem ( Gary Krockover 2004)
  7. Re: Data Type Search Problem ( Justin Carroll 2004)
  8. Re: Data Type Search Problem ( Donovan Brooke 2004)
  9. Re: Data Type Search Problem ( Donovan Brooke 2004)
  10. Data Type Search Problem ( Justin Carroll 2004)
read too quickly. If you have data being passed and you are getting all records returned it is probably not just FieldNameBLNK=T (but it is good to include it). Maybe some checkers for date formating??? what does your search look like? Donovan Donovan Brooke wrote: > Lets see your search... > > I'm guessing you need a: > FieldNameBLNK=T > > Donovan > > > > Justin Carroll wrote: > >> I have a database with an end_date header. This contains either an >> actual end date (ie. 03/14/2004) or a 0 for no ending date. >> >> My problem is that when doing a search on the field I use >> end_datetype=date. This ruins the search by pulling every record of >> the database when searching for any keyword (ie. lakflsjdfkd - pulls >> all records). >> >> I need to have end_datetype=date in there because the data table in my >> html page has clickable headers to sort the database. >> >> Does anyone have any suggestions as to how I can work around this? >> Thanks. >> >> Justin Carroll -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/ Donovan Brooke

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:

emailer 150 (1997) Introduction/Tutorial/QuickStart (1997) RSS Feed (2004) Size limit for tmpl editor ? (1997) Interpret twice? (1997) Limit to Field Length in DB (1998) WebCat2 - [format thousands] (1997) frames & carts (1997) [redirect] question (2005) [format xs] freeze (1997) Date Range search (1997) RequiredFields template (1997) 'does not contain' operator needed ... (1997) Sorting a Search... (1998) RE: [WebDNA] Cannot get WebDNA and MySQL working. (2015) Am I going senile? (Price recalc based on quantity) (1997) Forms Search Questions (1997) followup to ws3 vs ws2.1 speed (1998) [lookup] is case-sensitive, [lookup] is case sensitive... (2003) MacWEEK article help needed (1996)