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:
[WebDNA] Code Library (2013)
Running 2 two WebCatalog.acgi's (1996)
Access Denied! But why? (1997)
[Announce] DNAAds v1.0 (2003)
Random (2000)
frames & carts (1997)
[OT] SMTP access (2003)
Authenticate (1997)
email program problem (1998)
Data Entry ... Excel Style ... How To? (2001)
Separate SSL Server (1997)
Which GUI HTML editors work with WC ? (1997)
Payment Options: Check (2003)
alternatives for WebDNA (2004)
Our Webcat site launched (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Creating PDF (2004)
RAM variables (1997)
syntax question, not in online refernce (1997)
[random] only for 1-100??? (1997)