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.-AdamOlin 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:
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.-AdamOlin 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:
WebCommerce: Folder organization ? (1997)
Fun with dates (1997)
Email notification to one of multiple vendors ? (1997)
shownext problems (1998)
[WebDNA] Windows v7 (2011)
from product to cart to orders folder in one operation? (2000)
Possible Bug in 2.0b15.acgi (1997)
[WriteFile] problems (1997)
CSS in HTML emails? (2003)
Purchased cart being overwritten - still !?? (1997)
[WebDNA] Using WebDNA with MAMP (2010)
SEARCH Peram (2003)
Hiding HTML and page breaks (1997)
I think WebDNA-Talk died ... :( (1997)
[shownext] and descending order (1997)
More Discount Pricing thoughts/efforts (1998)
WebCat2: Formulas.db question (1997)
Setting up shop (1997)
Search returns all, not 20 (1997)
problem: search crashes webstar (1997)