Re: Linux ODBC and the ODBC Bridge
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35083
interpreted = N
texte = I am not assuming that people only know WebCat, or also know SQL. I was making a joke based on the fact that the SQL standard has been extended up the wazoo by everyone and their brother. Writing plain vanilla SQL is hard, since you will always be biased by what implementation you first learned on. If you know SQL already, you can use it within WebCat just like any other app that uses queries.As for using SQL within WebCat, it works pretty much like an ordinary [search] context. The docs are as complete as they need to be to get someone started. Your SQL column names become [fieldnames] within the [lineitems] context. I have only toyed with it, so I don't know if column aliases work as might be expected (i.e. select field1 as myfield... might show up in WebCat as [field1] not [myfield]) .The WebCat docs are not an appropriate place for SQL documentation, since SQL is vastly influenced by the exact backend database involved.No offense intendedJohn PeacockNicolas Verhaeghe wrote: > > John, > > Just imagine for ONE SECOND that people do not only know WebDNA. > > Thanks a lot. > > ----- Original Message ----- > From: John Peacock
> To: WebCatalog Talk > Sent: Monday, July 24, 2000 10:08 AM > Subject: Re: Linux ODBC and the ODBC Bridge > > SQL is a standard (Ha, ha, ha, I kill myself) so it is pretty much up to > you to know SQL. WebCat is not going to teach you to do SQL queries... > > John Peacock > > Nitai @ Eyework wrote: > > > > On 24.7.2000 6:52 pm, Nicolas Verhaeghe wrote: > > > > > is WebCatalog. The choice is yours. But you want the website to display > the > > > same products, and you want it up to date as far as prices and > availability > > > are concerned. You can automate the import of this database into a flat > > > file, and automate the flushing of the database in WebCat. Or you can do > it > > > using something more standard to the industry. > > > > To jump in to this topic. How hard is it to adjust WebCat to speak with > > mySQL or SQL that is? > > > > There is not much mentioned about SQL in the WebCat docs. > > > > Sincerely, > > Nitai > > > > -- > > Ecommerce für Ihre Ziele > > Eyework - http://eyework.net/ > > > > EMail: Info@eyework.net > > Tel: +41 (0)52 / 654 15 58, Fax: +41 (0)52 / 654 15 59 > > > > ------------------------------------------------------------- > > 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://search.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://search.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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I am not assuming that people only know WebCat, or also know SQL. I was making a joke based on the fact that the SQL standard has been extended up the wazoo by everyone and their brother. Writing plain vanilla SQL is hard, since you will always be biased by what implementation you first learned on. If you know SQL already, you can use it within WebCat just like any other app that uses queries.As for using SQL within WebCat, it works pretty much like an ordinary [search] context. The docs are as complete as they need to be to get someone started. Your SQL column names become [fieldnames] within the [lineitems] context. I have only toyed with it, so I don't know if column aliases work as might be expected (i.e. select field1 as myfield... might show up in WebCat as [field1] not [myfield]) .The WebCat docs are not an appropriate place for SQL documentation, since SQL is vastly influenced by the exact backend database involved.No offense intendedJohn PeacockNicolas Verhaeghe wrote: > > John, > > Just imagine for ONE SECOND that people do not only know WebDNA. > > Thanks a lot. > > ----- Original Message ----- > From: John Peacock > To: WebCatalog Talk > Sent: Monday, July 24, 2000 10:08 AM > Subject: Re: Linux ODBC and the ODBC Bridge > > SQL is a standard (Ha, ha, ha, I kill myself) so it is pretty much up to > you to know SQL. WebCat is not going to teach you to do SQL queries... > > John Peacock > > Nitai @ Eyework wrote: > > > > On 24.7.2000 6:52 pm, Nicolas Verhaeghe wrote: > > > > > is WebCatalog. The choice is yours. But you want the website to display > the > > > same products, and you want it up to date as far as prices and > availability > > > are concerned. You can automate the import of this database into a flat > > > file, and automate the flushing of the database in WebCat. Or you can do > it > > > using something more standard to the industry. > > > > To jump in to this topic. How hard is it to adjust WebCat to speak with > > mySQL or SQL that is? > > > > There is not much mentioned about SQL in the WebCat docs. > > > > Sincerely, > > Nitai > > > > -- > > Ecommerce für Ihre Ziele > > Eyework - http://eyework.net/ > > > > EMail: Info@eyework.net > > Tel: +41 (0)52 / 654 15 58, Fax: +41 (0)52 / 654 15 59 > > > > ------------------------------------------------------------- > > 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://search.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://search.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://search.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://search.smithmicro.com/
John Peacock
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:
Ok here is a question? (1997)
[WebDNA] How to code a 301 redirect (2008)
WebCommerce: Folder organization ? (1997)
RE: Server Traffic Simulation (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Frames and WebCat (1997)
[OT] SQL and Crackers (2000)
Re1000002: Setting up shop (1997)
How to redirect based on price subtotal? (1998)
Sorting by date (1997)
Banners (1997)
form data submission gets truncated (1997)
Document Contains No Data! (1997)
Robust WebDNA Job Manager / Accountant (2006)
Showif dates... (2002)
Can [formvariables] do this? (2000)
Pulling Captions from JPGs (2003)
Weird G3 Happenings. (1998)
[WebDNA] php/mySQL version of WebDNA Speed Test? (2009)
authorizenet and netscape (2002)