Re: SQLResult chokes on null values?

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 68119
interpreted = N
texte = Are you trying to return just the records that have a NULL value in that field? Forewarning, webdna's native SQL sometimes can be strange. -Adam Olin Lagon wrote: > Heh anyone have problems with SQLResult choking when it gets to a null > value? It just stops rendering a page once it gets to a field where the > value is null. For instance, page stops rendering right after the field is > called on the null value: > > [SQLConnect dbType=MySQL&...&var=conn1][/SQLConnect] > > [SQLExecute conn_ref=conn1&result_var=rs1] select * from TABLE; > [/SQLExecute] > > [SQLResult result_ref=rs1] > [numFound] records found
> [FoundItems] > [the field which has a null value]
> [/FoundItems] > [/SQLResult] > > Any ideas? Thanks! Olin > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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: SQLResult chokes on null values? ( "Olin Lagon" 2006)
  2. Re: SQLResult chokes on null values? ( "Adam O'Connor" 2006)
  3. SQLResult chokes on null values? ( "Olin Lagon" 2006)
Are you trying to return just the records that have a NULL value in that field? Forewarning, webdna's native SQL sometimes can be strange. -Adam Olin Lagon wrote: > Heh anyone have problems with SQLResult choking when it gets to a null > value? It just stops rendering a page once it gets to a field where the > value is null. For instance, page stops rendering right after the field is > called on the null value: > > [SQLConnect dbType=MySQL&...&var=conn1][/SQLConnect] > > [SQLExecute conn_ref=conn1&result_var=rs1] select * from TABLE; > [/SQLExecute] > > [SQLResult result_ref=rs1] > [numFound] records found
> [founditems] > [the field which has a null value]
> [/FoundItems] > [/SQLResult] > > Any ideas? Thanks! Olin > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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/ "Adam O'Connor"

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:

RE: Cart Template (1997) Cancel Subscription (1996) Nesting WebDNA in JavaScript (2003) adding time (2003) AppleScript/.db (was:FTP to WebStar) (2001) Shownext never shows next...still (1997) Repeating Fields (1997) problem (1998) OLD PROBLEM (1997) php vs WebCatalog (2000) Sendmail truncation in Eudora Clients (1998) [WebDNA] Moving sites to a HostGator dedicated server (2008) Add to Cart & List of Products (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) WebCatalog2 Feature Feedback (1996) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Mac 3.0.5b11 PI -- template cache and aliases (1999) Secure server question (1997) Size limit for tmpl editor ? (1997) Where's Cart Created ? (1997)