Re: [WebDNA] Connect to MS SQL
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110395
interpreted = N
texte = --Apple-Mail=_E5DCBDD5-2927-4DCD-BB76-B3EDB6465D69Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-ascii[SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&pwd=3Dpass&conn=_var=3Dconn1]Connected successfully[/SQLconnect][SQLexecute conn_ref=3Dconn1&result_var=3Drs1]select firstName,lastName from employees;[/SQLexecute][SQLresult result_ref=3Drs1][numfound] records found
First Name | Last Name |
[founditems][firstName] | [lastName] |
[/founditems]
[/SQLresult]On May 22, 2013, at 4:40 AM, Stuart Tremain
wrote:> Is it possible to connect to MS SQL with WebDNA 6.2 on Linux ?>=20> Regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us>=20--Apple-Mail=_E5DCBDD5-2927-4DCD-BB76-B3EDB6465D69Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-ascii[SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&=;pwd=3Dpass&conn_var=3Dconn1]
Connected =successfully
[/SQLconnect]
[SQLexecute =conn_ref=3Dconn1&result_var=3Drs1]
select firstName,lastName from =employees;
[/SQLexecute]
[SQLresult =result_ref=3Drs1]
[numfound] records found<br>
<table =border=3D1><tr><th>First Name</th><th>Last =Name</th></tr>
[founditems]
<tr><td>[firstName]</td><td>=[lastName]</td></tr>
[/founditems]
</table>
[/S=QLresult]
Is it possible to connect to MS SQL with WebDNA 6.2 on =Linux ?
Regards
Stuart Tremain
IDFK Web =Developments
AUSTRALIA
webdna@idfk.com.au
<=br>---------------------------------------------------------
This =message is sent to you because you are subscribed to
the mailing list =<talk@webdna.us>.
To unsubscribe, E-mail to: =<talk-leave@webdna.us>
archives: =http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: =support@webdna.us
=--Apple-Mail=_E5DCBDD5-2927-4DCD-BB76-B3EDB6465D69--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_E5DCBDD5-2927-4DCD-BB76-B3EDB6465D69Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-ascii[SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&pwd=3Dpass&conn=_var=3Dconn1]Connected successfully[/SQLconnect][SQLexecute conn_ref=3Dconn1&result_var=3Drs1]select firstName,lastName from employees;[/SQLexecute][SQLresult result_ref=3Drs1][numfound] records found
First Name | Last Name |
[founditems][firstName] | [lastName] |
[/founditems]
[/SQLresult]On May 22, 2013, at 4:40 AM, Stuart Tremain wrote:> Is it possible to connect to MS SQL with WebDNA 6.2 on Linux ?>=20> Regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us>=20--Apple-Mail=_E5DCBDD5-2927-4DCD-BB76-B3EDB6465D69Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-ascii[SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&=;pwd=3Dpass&conn_var=3Dconn1]
Connected =successfully
[/SQLconnect]
[SQLexecute =conn_ref=3Dconn1&result_var=3Drs1]
select firstName,lastName from =employees;
[/SQLexecute]
[SQLresult =result_ref=3Drs1]
[numfound] records found<br>
<table =border=3D1><tr><th>First Name</th><th>Last =Name</th></tr>
[founditems]
<tr><td>[firstName]</td><td>=[lastName]</td></tr>
[/founditems]
</table>
[/S=QLresult]
Is it possible to connect to MS SQL with WebDNA 6.2 on =Linux ?
Regards
Stuart Tremain
IDFK Web =Developments
AUSTRALIA
webdna@idfk.com.au
<=br>---------------------------------------------------------
This =message is sent to you because you are subscribed to
the mailing list =<talk@webdna.us>.
To unsubscribe, E-mail to: =<talk-leave@webdna.us>
archives: =http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: =support@webdna.us
=--Apple-Mail=_E5DCBDD5-2927-4DCD-BB76-B3EDB6465D69--
Jeffrey Jones
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:
OT: Safari/Mac - frames and iframes acting weird (2007)
[WebDNA] WebDNA Crashing or Not **YES** (2008)
Entering the Serial Number (2003)
[SearchString] problem with [search] context (1997)
absolute paths for databases? (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
Listfiles context (2000)
eAuthorize experience ... ? (2002)
DNS Lookup 2 (2000)
[SHOWIF AND/OR] (1997)
remotely creating and populating a stock inventory db - almost there! (1999)
docs for WebCatalog2 (1997)
[showif]/[hideif] question (1997)
how many (hideif & showifs) is too many? (2001)
Multi-processor Mac info ... (1997)
[cart] (1998)
RE: too many nested [xxx] (1997)
Price problem (1997)
shownext (1997)
WebCatalog Upgrade Pricing? (1997)