Re: Queertrons?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13700
interpreted = N
texte = In response to my question: > I've flushed the databases and the caches, but that doesn't help. >I've restarted the server. No help. Even more curious, if I do a search of >title or description, the missing products appear, but if I try to add >them to the cart, a totally different item appears in the cart.Grant Hulbert wrote: >Sounds like you may have duplicate skus in your database, or maybe the >database doesn't contain what you think it does. Perhaps the category field >has slipped over one column or something like that (extra tabs, carriage >returns, etc.). When you examine the database manually, does it look like >everything's lined up all right? Grant, you're right, it all goes back to the dbase. I used Excel to build the database, then saved it in text. The problem was, when I'd re-sized the columns to fit my screen, I'd shrunk the SKU column such that only two digits would fit. SKUs after 99 became ##, and that's what transfered to text. Thank you very much. Now, if you could just tell me why [sendmail] doesn't send mail, I'll be able to open for business... and yes, the emailer program is in the startup file.Cheers, Lurch Webmaster and Virtual Barkeep... ...Lover of fine whiskey, fast women, and faster airplanes... ...not necessarily in that order :P
Associated Messages, from the most recent to the oldest:
In response to my question: > I've flushed the databases and the caches, but that doesn't help. >I've restarted the server. No help. Even more curious, if I do a search of >title or description, the missing products appear, but if I try to add >them to the cart, a totally different item appears in the cart.Grant Hulbert wrote: >Sounds like you may have duplicate skus in your database, or maybe the >database doesn't contain what you think it does. Perhaps the category field >has slipped over one column or something like that (extra tabs, carriage >returns, etc.). When you examine the database manually, does it look like >everything's lined up all right? Grant, you're right, it all goes back to the dbase. I used Excel to build the database, then saved it in text. The problem was, when I'd re-sized the columns to fit my screen, I'd shrunk the SKU column such that only two digits would fit. SKUs after 99 became ##, and that's what transfered to text. Thank you very much. Now, if you could just tell me why
[sendmail] doesn't send mail, I'll be able to open for business... and yes, the emailer program is in the startup file.Cheers, Lurch Webmaster and Virtual Barkeep... ...Lover of fine whiskey, fast women, and faster airplanes... ...not necessarily in that order :P
Joe R. Richardson
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[2]: when is failing to [URL]ize values in a comparison ri (1999)
[WebDNA] Successful, working WebDNA7/CentOS install? (2013)
Gold on the list ... Was Authorize.net? (2003)
Here's how to kill a Butler Database. (1997)
Limit to Field Length in DB (1998)
[BULK] [WebDNA] abstraction code can be tricky... (2012)
Spawn doesn't work as advertised ... (2000)
Sending Email (2004)
A quickie question (1997)
Protect Tag and Groups (1998)
RE: Loss in form (1998)
serial number dishing (1997)
Emailer.Out (1998)
Permission denied? (2004)
BGcolor (1997)
Hiding HTML and page breaks (1997)
Re:Version 2.0 and 1.6 simultaneous (1997)
TRAINING videos - Prove IT. (1998)
WebCat2b13MacPlugIn - syntax to convert date (1997)
WebCat2 Append problem (B14Macacgi) (1997)