SQLResult chokes on null values?

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 68118
interpreted = N
texte = 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/ 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)
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/ "Olin Lagon"

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:

[WebDNA] WebDNA crash and now emailer not working (2009) Why is [lookup] case sensitive? (2001) Lookup command (1998) Fault tolerance (2000) redirect with frames (1997) Adding Items to Cart (2003) Ken's Data Manager (finally available I think ...) (2005) Out of the woodwork (2007) converchars in sendmail context.... (2004) Re:Signal Raised (1997) IE Cache Problems... (1999) setitems, one more thing (1997) Associative lookup style? (1997) Summing fields (1997) Am I going senile? (Price recalc based on quantity) (1997) Errata: WCS Newbie question (1997) Grant, please help me ... (1997) index code (2005) Digest Format (2003) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)