SQL newbie

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40485
interpreted = N
texte = I have a client that wants me to do a SQL INSERT to a database table when my storefront sells one of his products. Do I need to set up ODBC-type stuff (drivers, etc) on my server to do this or do I just build the WebDNA command? Not having done this before, I'm hoping that I can just do something like:[SQL dsn=http://www.clientDomain.com/public/testDatabase.db&statement=INSERT] etc... [/SQL] I'm not familiar with the syntax of the dsn defnition, so I'm not sure if this is possible. Am I on the right track?Thanks, BrianBrian Wachter Stoneport Technologies, LLC (207) 772-3826 ------------------------------------------------------------- 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:

    
  1. Re: SQL newbie (Brian Wachter 2002)
  2. Re: SQL newbie (Pedro Rivera 2002)
  3. SQL newbie (Brian Wachter 2002)
I have a client that wants me to do a SQL INSERT to a database table when my storefront sells one of his products. Do I need to set up ODBC-type stuff (drivers, etc) on my server to do this or do I just build the WebDNA command? Not having done this before, I'm hoping that I can just do something like:[SQL dsn=http://www.clientDomain.com/public/testDatabase.db&statement=INSERT] etc... [/SQL] I'm not familiar with the syntax of the dsn defnition, so I'm not sure if this is possible. Am I on the right track?Thanks, BrianBrian Wachter Stoneport Technologies, LLC (207) 772-3826 ------------------------------------------------------------- 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/ Brian Wachter

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:

WebCat2 - [format thousands] (1997) Upload files (2004) form data submission gets truncated (1997) [WriteFile] problems (1997) Emailer on NT not working. (1999) Calculating Shipping charges for multiple items andqtys > 1 (1997) Draft Manual, Tutorial, and more (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Time/date formatting %X doesn't work ... (1997) dbQuickView 2.0 (2005) WebCat2b15MacPlugin - [protect] (1997) Micro-managing External Links (2006) webten vs. webstar (1998) Simple way to create unique SKU (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) WebMerchant 1.6 and SHTML (1997) [HIDEIF] inside [FOUNDITEM] (1997) Search/sort in URL Was: GuestBook example (1997) Searchable list archive (1997) RE: Shopping Cart Questions (1998)