SQL weirdness
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27756
interpreted = N
texte = I have a statement with an inner join between too related tables.Something like this: SELECT Products.OEM_PN, Prodaux.Weight FROM (Products LEFT JOIN Prodaux ON Products.OEM_PN = Prodaux.OEM_PN) INNER JOIN Products on Products.OEM_PN = Prodaux.OEM_PN WHEREOne of the table does not always have a record for the selected index.Therefore Prodaux.Weight should be forced to Null. The problem is that, instead of having [Prodaux.Weight] equal to nothing, WebCatalog gives it a weird content, sometimes the content of a part of the template.Weird, weird. Is it because of the Null character? ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
| |
- SQL weirdness (Nicolas Verhaeghe 2000)
|
I have a statement with an inner join between too related tables.Something like this: SELECT Products.OEM_PN, Prodaux.Weight FROM (Products LEFT JOIN Prodaux ON Products.OEM_PN = Prodaux.OEM_PN) INNER JOIN Products on Products.OEM_PN = Prodaux.OEM_PN WHEREOne of the table does not always have a record for the selected index.Therefore Prodaux.Weight should be forced to Null. The problem is that, instead of having [Prodaux.Weight] equal to nothing, WebCatalog gives it a weird content, sometimes the content of a part of the template.Weird, weird. Is it because of the Null character? ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Nicolas Verhaeghe
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: Purchased cart being overwritten (1997)
Re1000001: Setting up shop (1997)
AppleScript question (1997)
Just Testing (1997)
search for all (1998)
Grep question [parsing variables] problem (2003)
CommandSecurity? (1997)
PCS Frames (1997)
Car Database (2002)
where to put code (1998)
HELP WITH DATES (1997)
Problems getting parameters passed into email. (1997)
requiredfields HELP!! (2001)
Typhoon 4 -- yes or no? (2000)
Webmerchant confirmation hooks? (1997)
syntax question, not in online refernce (1997)
[/application] error? (1997)
Nested Lookups (1998)
[WebDNA] Acceleratin Search / Index Performance in a Formum Service (2013)
Question on the sandbox (2003)