Re: Linux ODBC and the ODBC Bridge
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35093
interpreted = N
texte = OK, the answer is more like this: any SQL query that you can run throughODBC will work in WebCat. What feature do you want to use in mySQL thatyou'd don't know how to use in WebCat? It is not obvious how to do UPDATE or INSERT from WebCat, but SELECT seems obvious. If you tell us what you want to do, it will be much easier to respond.This is untested but seems reasonable:[search db=my.db&neFIELD1data=[BLANK]][founditems][SQL dsn=mydsn&statement=insert into DB values ([field1],[field2])][/sql][/founditems][/search]This should insert records into the ODBC database DB for all records inmy.db that do not have FIELD1=[BLANK].Was this what you were looking for?John PeacockNitai @ Eyework wrote:> > On 24.7.2000 7:08 pm, John Peacock
wrote:> > > 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...> > Ok, the question was more like:> > Do all SQL commands work with WebCat and if so where is this stated and how> can I learn it?> > I have a project coming up and they want their mySQL to work with my WebCat> templates.> > 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/
Associated Messages, from the most recent to the oldest:
OK, the answer is more like this: any SQL query that you can run throughODBC will work in WebCat. What feature do you want to use in mySQL thatyou'd don't know how to use in WebCat? It is not obvious how to do UPDATE or INSERT from WebCat, but SELECT seems obvious. If you tell us what you want to do, it will be much easier to respond.This is untested but seems reasonable:[search db=my.db&neFIELD1data=[BLANK]][founditems][SQL dsn=mydsn&statement=insert into DB values ([field1],[field2])][/sql][/founditems][/search]This should insert records into the ODBC database DB for all records inmy.db that do not have FIELD1=[BLANK].Was this what you were looking for?John PeacockNitai @ Eyework wrote:> > On 24.7.2000 7:08 pm, John Peacock wrote:> > > 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...> > Ok, the question was more like:> > Do all SQL commands work with WebCat and if so where is this stated and how> can I learn it?> > I have a project coming up and they want their mySQL to work with my WebCat> templates.> > 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/
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:
Showif date > other date (2004)
writing db to disk (1997)
Re:trouble (1997)
Help name our technology! (1997)
unable to launch acgi in WebCat (1997)
Shhh, very quiet. (2006)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[SubTotal] ??? (1998)
[WebDNA] OT: Indexing PDF on iTools / apache2 (2008)
Enhancement Request for WebCatalog-NT (1996)
[WriteFile] problems (1997)
OT Comcast high speed internet issues (2005)
username = 115 (1999)
Email troubles (2005)
Protect (1997)
RequiredFields template (1997)
E-mail loop ! (1997)
Showif -what am I missing??? (1999)
[WebDNA] "Safe Write for Database" setting.... (2016)
C is for cookie - that's good enough for me... (2001)