Re: [WebDNA] Connect to MS SQL

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110490
interpreted = N
texte = --Apple-Mail=_21E97D71-5FDF-49E9-A14F-F22A688F2556 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Yeah I am thinking this is not an ODBC thing though. When I do something wrong in the SQL statement I get a less than useful = ODBC error. SQL not supported sounds much more to me like a DNA error. As if it is = crippled at the DNA level. Can only guess though. Would still like ti know if Windows is on the path for an upgrade or if = it is going to die at 6.x Alex On Jun 27, 2013, at 6:49 PM, Stuart Tremain wrote: > Using [SQL] I get "Error: SQL not supported" >=20 > Would LOVE to be able to use it as Alex has suggested, maybe I don't = have the code correct, or maybe it is just not picking up the ODBC = connection. >=20 > [SQL dsn=3DFFTT&username=3DMyUsername&password=3DMyPassword&statement=3D= select StockCode SKU, QtyA AVAILABLE from jimstock s join = JimStockQtyView_XL v on v.StockNo =3D s.StockNo where v.LocNo =3D = (select LocNo from JimStockLocation where LocCode =3D 'NSW') and = stockcode =3D '[GETQTY]'] > [/SQL] --Apple-Mail=_21E97D71-5FDF-49E9-A14F-F22A688F2556 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Yeah = I am thinking this is not an ODBC thing though.
When I do something = wrong in the SQL statement I get a less than useful ODBC = error.

SQL not supported sounds much more to me = like a DNA error. As if it is crippled at the DNA level.
Can = only guess though.


Would still = like ti know if Windows is on the path for an upgrade or if it is going = to die at = 6.x


Alex

=

On Jun 27, 2013, at 6:49 PM, Stuart Tremain = <webdna@idfk.com.au> = wrote:

Using [SQL] I get "Error: SQL not = supported"

Would = LOVE to be able to use it as Alex has suggested, maybe I don't have the = code correct, or maybe it is just not picking up the ODBC = connection.

[SQL = dsn=3DFFTT&username=3DMyUsername&password=3DMyPassword&stateme= nt=3Dselect StockCode SKU, QtyA AVAILABLE from jimstock s join = JimStockQtyView_XL v on v.StockNo =3D s.StockNo where v.LocNo =3D = (select LocNo from JimStockLocation where LocCode =3D 'NSW') and = stockcode =3D '[GETQTY]']
[/SQL]

= --Apple-Mail=_21E97D71-5FDF-49E9-A14F-F22A688F2556-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  2. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  3. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  4. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  5. Re: [WebDNA] Connect to MS SQL (Donovan Brooke 2013)
  6. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  7. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  8. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  9. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  10. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  11. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  12. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  13. Re: [WebDNA] Connect to MS SQL (Jeffrey Jones 2013)
  14. Re: [WebDNA] Connect to MS SQL (Jeffrey Jones 2013)
  15. [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
--Apple-Mail=_21E97D71-5FDF-49E9-A14F-F22A688F2556 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Yeah I am thinking this is not an ODBC thing though. When I do something wrong in the SQL statement I get a less than useful = ODBC error. SQL not supported sounds much more to me like a DNA error. As if it is = crippled at the DNA level. Can only guess though. Would still like ti know if Windows is on the path for an upgrade or if = it is going to die at 6.x Alex On Jun 27, 2013, at 6:49 PM, Stuart Tremain wrote: > Using [SQL] I get "Error: SQL not supported" >=20 > Would LOVE to be able to use it as Alex has suggested, maybe I don't = have the code correct, or maybe it is just not picking up the ODBC = connection. >=20 > [SQL dsn=3DFFTT&username=3DMyUsername&password=3DMyPassword&statement=3D= select StockCode SKU, QtyA AVAILABLE from jimstock s join = JimStockQtyView_XL v on v.StockNo =3D s.StockNo where v.LocNo =3D = (select LocNo from JimStockLocation where LocCode =3D 'NSW') and = stockcode =3D '[GETQTY]'] > [/SQL] --Apple-Mail=_21E97D71-5FDF-49E9-A14F-F22A688F2556 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Yeah = I am thinking this is not an ODBC thing though.
When I do something = wrong in the SQL statement I get a less than useful ODBC = error.

SQL not supported sounds much more to me = like a DNA error. As if it is crippled at the DNA level.
Can = only guess though.


Would still = like ti know if Windows is on the path for an upgrade or if it is going = to die at = 6.x


Alex

=

On Jun 27, 2013, at 6:49 PM, Stuart Tremain = <webdna@idfk.com.au> = wrote:

Using [SQL] I get "Error: SQL not = supported"

Would = LOVE to be able to use it as Alex has suggested, maybe I don't have the = code correct, or maybe it is just not picking up the ODBC = connection.

[SQL = dsn=3DFFTT&username=3DMyUsername&password=3DMyPassword&stateme= nt=3Dselect StockCode SKU, QtyA AVAILABLE from jimstock s join = JimStockQtyView_XL v on v.StockNo =3D s.StockNo where v.LocNo =3D = (select LocNo from JimStockLocation where LocCode =3D 'NSW') and = stockcode =3D '[GETQTY]']
[/SQL]

= --Apple-Mail=_21E97D71-5FDF-49E9-A14F-F22A688F2556-- Alex McCombie

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:

Format all of a sudden doesn't work (1997) Max Record length (1997) [OT] Linux -> Winderz (2005) PCS Frames (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) RequiredFields template (1997) MySQL question (2005) SMSI: WebDNA Versions? (2002) WebMerchant (2003) showif and cart (1997) WebCat2b12 Mac.acgi--[searchstring] bug (1997) Secure server question (1997) Cart questions (1997) WebDNA and SQL (2003) European Convention (2004) PDF on the fly - how to? (2005) Using Plug-In while running 1.6.1 (1997) Emailer help....! (1997) Secured Order Forms (1998) [OT] Friday Time Waster (2003)