Re: [WebDNA] Connect to MS SQL

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110477
interpreted = N
texte = --Apple-Mail=_836F1EEB-72F1-4CB3-A8EE-79F97A6B33F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Well that's good to know for me as I was considering moving off the = winbox. But if the code isn't portable (which I guess I don't understand because = its just sending string to the ODBC manager) then that's a nogo for me. Dna-SQL is the core of everything we write. I haven't looked at upgrading in a long time. there still is a migration = path for Windows server correct? On Jun 26, 2013, at 7:16 PM, Stuart Tremain wrote: > Thanks Alex. >=20 > It doesn't work on Linux build :( >=20 > Would be very nice to do it that way. >=20 >=20 >=20 > On 26/06/2013, at 10:55 PM, Alex McCombie = wrote: >=20 >> Sorry for the delay Stuart. I missed this message. >>=20 >> Keep in mind I am on a winbox and it's as easy as setting up a DSN. >>=20 >> Once that is done it basically straight SQL syntax. >>=20 >>=20 >> Here is one I was just working on: >>=20 >>=20 >> [SQL = dsn=3DDSNNAME&username=3DYOURUSERNAME&password=3DYOURPASSWORD&statement=3D= Update HRJOB_Jobs=20 >> set=20 >> onlinelocation =3D '[onlinelocation]', >> title =3D '[ConvertWords = db=3D/databases/Sqlconversions.db][titleSKU][/ConvertWords]',=20 >> Description =3D '[descSKU]',=20 >> filled =3D '[skufilled]',=20 >> datefilled =3D '[datefilledsku]',=20 >> active =3D '[skuactive]' where JobSKU =3D '[sku]';] >> [/SQL] >>=20 >>=20 >> Basically I can almost take any SQL and drop it in the [SQL] tag and = have it work. Some oddities every now and then will special characters. = But it works like a charm and is who we do almost everything with = WebDNA. >>=20 >> HTH >> Alex >>=20 >>=20 >>=20 >> On Jun 7, 2013, at 9:02 PM, Stuart Tremain = wrote: >>=20 >>> Alex >>>=20 >>> Would you please send me an example.=20 >>>=20 >>> I have a connection working using [SHELL] but would like to try with = the WebDNA method, i keep getting "Error: SQL not supported". >>>=20 >>> I believe this to be true with the latest Linux build. >>>=20 >>> Thanks. >>>=20 >>>=20 >>> Regards >>>=20 >>> Stuart Tremain >>> IDFK Web Developments >>> AUSTRALIA >>> webdna@idfk.com.au >>>=20 >>>=20 >>>=20 >>>=20 >>> On 25/05/2013, at 12:52 PM, Alex McCombie = wrote: >>>=20 >>>> Yep.. I had it running at one point on a Mac version as well. >>>> The only trick is your OS needs to be able to setup an ODBC = connection to MSSQL. >>>> Webdna [sql] tag is just sending the SQL string to the ODBC and = then on to MS. >>>>=20 >>>> Its pretty much the only way we do things now so the Data is also = simultaneously available to FMPRO, ACCESS, EXCEL, etc. >>>>=20 >>>> Alex >>>>=20 >>>>=20 >>>> On May 23, 2013, at 7:13 PM, Stuart Tremain = wrote: >>>>=20 >>>>> Thanks Alex, I knew that someone was connecting as I recalled some = mention of it on the list. >>>>>=20 >>>>> I have a few issues with the Windows build and am moving = everything to Ubuntu and need to find a way to make the MSSQL = connection. There are a few tools around which I will check out over the = next week but wondered if someone was already doing it. >>>>>=20 >>>>>=20 >>>>> Regards >>>>>=20 >>>>> Stuart Tremain >>>>> IDFK Web Developments >>>>> AUSTRALIA >>>>> webdna@idfk.com.au >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>> On 24/05/2013, at 1:50 AM, Alex McCombie = wrote: >>>>>=20 >>>>>> Don't know about the linux issue, but nearly all my code is Wedna = 6.0 connecting to MSSQL Server 2000. 2005, 2008. >>>>>>=20 >>>>>> We are running the windows version though and using the standard = System DSN for the ODBC connectivity. >>>>>>=20 >>>>>> With only minor issues, we do this flawlessly. >>>>>>=20 >>>>>> HTH >>>>>> Alex >>>>>>=20 >>>>>>=20 >>>>>> On May 22, 2013, at 12:21 PM, Jeffrey Jones = wrote: >>>>>>=20 >>>>>>> [SQLconnect = dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&pwd=3Dpass&conn= _var=3Dconn1] >>>>>>> Connected successfully >>>>>>>=20 >>>>>>> [/SQLconnect] >>>>>>>=20 >>>>>>> [SQLexecute conn_ref=3Dconn1&result_var=3Drs1] >>>>>>> select firstName,lastName from employees; >>>>>>> [/SQLexecute] >>>>>>>=20 >>>>>>> [SQLresult result_ref=3Drs1] >>>>>>> [numfound] records found
>>>>>>> >>>>>>> [founditems] >>>>>>> >>>>>>> [/founditems] >>>>>>>
First NameLast Name
[firstName][lastName]
>>>>>>> [/SQLresult] >>>>>>>=20 >>>>>>> On May 22, 2013, at 4:40 AM, Stuart Tremain = wrote: >>>>>>>=20 >>>>>>>> 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 >>>>>>>=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 >>>>>> --------------------------------------------------------- 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 >>>>> --------------------------------------------------------- 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 >>>> --------------------------------------------------------- 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 >>> --------------------------------------------------------- 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 >> --------------------------------------------------------- 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 > --------------------------------------------------------- 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 --Apple-Mail=_836F1EEB-72F1-4CB3-A8EE-79F97A6B33F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Well = that's good to know for me as I was considering moving off the = winbox.

But if the code isn't portable (which I guess = I don't understand because its just sending string to the ODBC manager) = then that's a nogo for = me.



Dna-SQL is = the core of everything we write.

I haven't = looked at upgrading in a long time. there still is a migration path for = Windows server = correct?



On Jun = 26, 2013, at 7:16 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Thanks Alex.

It doesn't work on Linux build = :(

Would be very nice to do it that = way.



On = 26/06/2013, at 10:55 PM, Alex McCombie <info@adventureskies.com> = wrote:

Sorry = for the delay Stuart. I missed this message.

Keep in = mind I am on a winbox and it's as easy as setting up a = DSN.

Once that is done it basically straight = SQL syntax.


Here is one I was = just working on:


[SQL = dsn=3DDSNNAME&username=3DYOURUSERNAME&password=3DYOURPASSWORD&= statement=3DUpdate = HRJOB_Jobs 
set 
onlinelocation =3D = '[onlinelocation]',
title =3D '[ConvertWords = db=3D/databases/Sqlconversions.db][titleSKU][/ConvertWords]', 
<= div>Description =3D '[descSKU]', 
filled =3D = '[skufilled]', 
datefilled =3D = '[datefilledsku]', 
active =3D '[skuactive]' where JobSKU = =3D = '[sku]';]
[/SQL]


Basical= ly I can almost take any SQL and drop it in the [SQL] tag and have it = work. Some oddities every now and then will special characters. But it = works like a charm and is who we do almost everything with = WebDNA.

HTH
Alex



On Jun 7, 2013, at 9:02 PM, = Stuart Tremain <webdna@idfk.com.au> = wrote:

Alex

Would you please send me an = example. 

I have a connection working = using [SHELL] but would like to try with the WebDNA method, i keep = getting "Error: SQL not supported".

I believe = this to be true with the latest Linux = build.

Thanks.


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 25/05/2013, at 12:52 PM, Alex McCombie <info@adventureskies.com> = wrote:

Yep.. = I had it running at one point on a Mac version as well.
The only = trick is your OS needs to be able to setup an ODBC connection to = MSSQL.
Webdna [sql] tag is just sending the SQL string to the = ODBC and then on to MS.

Its pretty much the = only way we do things now so the Data is also simultaneously available = to FMPRO, ACCESS, EXCEL, = etc.

Alex


= On May 23, 2013, at 7:13 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Thanks Alex, I knew that someone was connecting as I recalled some = mention of it on the list.

I have a few issues with = the Windows build and am moving everything to Ubuntu and need to find a = way to make the MSSQL connection. There are a few tools around which I = will check out over the next week but wondered if someone was already = doing it.


=
Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 24/05/2013, at 1:50 AM, Alex McCombie <info@adventureskies.com> = wrote:

Don't = know about the linux issue, but nearly all my code is Wedna 6.0 = connecting to MSSQL Server 2000. 2005, 2008.

We are = running the windows version though and using the standard System DSN for = the ODBC connectivity.

With only minor issues, = we do this = flawlessly.

HTH
Alex


On May 22, 2013, at 12:21 PM, Jeffrey Jones <jjones@synergos.com> = wrote:

[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]

On May 22, 2013, at 4:40 AM, = Stuart Tremain <webdna@idfk.com.au> = wrote:

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>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
Bug Reporting: support@webdna.us


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_836F1EEB-72F1-4CB3-A8EE-79F97A6B33F4-- 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=_836F1EEB-72F1-4CB3-A8EE-79F97A6B33F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Well that's good to know for me as I was considering moving off the = winbox. But if the code isn't portable (which I guess I don't understand because = its just sending string to the ODBC manager) then that's a nogo for me. Dna-SQL is the core of everything we write. I haven't looked at upgrading in a long time. there still is a migration = path for Windows server correct? On Jun 26, 2013, at 7:16 PM, Stuart Tremain wrote: > Thanks Alex. >=20 > It doesn't work on Linux build :( >=20 > Would be very nice to do it that way. >=20 >=20 >=20 > On 26/06/2013, at 10:55 PM, Alex McCombie = wrote: >=20 >> Sorry for the delay Stuart. I missed this message. >>=20 >> Keep in mind I am on a winbox and it's as easy as setting up a DSN. >>=20 >> Once that is done it basically straight SQL syntax. >>=20 >>=20 >> Here is one I was just working on: >>=20 >>=20 >> [SQL = dsn=3DDSNNAME&username=3DYOURUSERNAME&password=3DYOURPASSWORD&statement=3D= Update HRJOB_Jobs=20 >> set=20 >> onlinelocation =3D '[onlinelocation]', >> title =3D '[ConvertWords = db=3D/databases/Sqlconversions.db][titleSKU][/ConvertWords]',=20 >> Description =3D '[descSKU]',=20 >> filled =3D '[skufilled]',=20 >> datefilled =3D '[datefilledsku]',=20 >> active =3D '[skuactive]' where JobSKU =3D '[sku]';] >> [/SQL] >>=20 >>=20 >> Basically I can almost take any SQL and drop it in the [SQL] tag and = have it work. Some oddities every now and then will special characters. = But it works like a charm and is who we do almost everything with = WebDNA. >>=20 >> HTH >> Alex >>=20 >>=20 >>=20 >> On Jun 7, 2013, at 9:02 PM, Stuart Tremain = wrote: >>=20 >>> Alex >>>=20 >>> Would you please send me an example.=20 >>>=20 >>> I have a connection working using [shell] but would like to try with = the WebDNA method, i keep getting "Error: SQL not supported". >>>=20 >>> I believe this to be true with the latest Linux build. >>>=20 >>> Thanks. >>>=20 >>>=20 >>> Regards >>>=20 >>> Stuart Tremain >>> IDFK Web Developments >>> AUSTRALIA >>> webdna@idfk.com.au >>>=20 >>>=20 >>>=20 >>>=20 >>> On 25/05/2013, at 12:52 PM, Alex McCombie = wrote: >>>=20 >>>> Yep.. I had it running at one point on a Mac version as well. >>>> The only trick is your OS needs to be able to setup an ODBC = connection to MSSQL. >>>> Webdna [SQL] tag is just sending the SQL string to the ODBC and = then on to MS. >>>>=20 >>>> Its pretty much the only way we do things now so the Data is also = simultaneously available to FMPRO, ACCESS, EXCEL, etc. >>>>=20 >>>> Alex >>>>=20 >>>>=20 >>>> On May 23, 2013, at 7:13 PM, Stuart Tremain = wrote: >>>>=20 >>>>> Thanks Alex, I knew that someone was connecting as I recalled some = mention of it on the list. >>>>>=20 >>>>> I have a few issues with the Windows build and am moving = everything to Ubuntu and need to find a way to make the MSSQL = connection. There are a few tools around which I will check out over the = next week but wondered if someone was already doing it. >>>>>=20 >>>>>=20 >>>>> Regards >>>>>=20 >>>>> Stuart Tremain >>>>> IDFK Web Developments >>>>> AUSTRALIA >>>>> webdna@idfk.com.au >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>> On 24/05/2013, at 1:50 AM, Alex McCombie = wrote: >>>>>=20 >>>>>> Don't know about the linux issue, but nearly all my code is Wedna = 6.0 connecting to MSSQL Server 2000. 2005, 2008. >>>>>>=20 >>>>>> We are running the windows version though and using the standard = System DSN for the ODBC connectivity. >>>>>>=20 >>>>>> With only minor issues, we do this flawlessly. >>>>>>=20 >>>>>> HTH >>>>>> Alex >>>>>>=20 >>>>>>=20 >>>>>> On May 22, 2013, at 12:21 PM, Jeffrey Jones = wrote: >>>>>>=20 >>>>>>> [SQLconnect = dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&pwd=3Dpass&conn= _var=3Dconn1] >>>>>>> Connected successfully >>>>>>>=20 >>>>>>> [/SQLconnect] >>>>>>>=20 >>>>>>> [SQLexecute conn_ref=3Dconn1&result_var=3Drs1] >>>>>>> select firstName,lastName from employees; >>>>>>> [/SQLexecute] >>>>>>>=20 >>>>>>> [SQLresult result_ref=3Drs1] >>>>>>> [numfound] records found
>>>>>>> >>>>>>> [founditems] >>>>>>> >>>>>>> [/founditems] >>>>>>>
First NameLast Name
[firstName][lastName]
>>>>>>> [/SQLresult] >>>>>>>=20 >>>>>>> On May 22, 2013, at 4:40 AM, Stuart Tremain = wrote: >>>>>>>=20 >>>>>>>> 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 >>>>>>>=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 >>>>>> --------------------------------------------------------- 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 >>>>> --------------------------------------------------------- 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 >>>> --------------------------------------------------------- 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 >>> --------------------------------------------------------- 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 >> --------------------------------------------------------- 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 > --------------------------------------------------------- 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 --Apple-Mail=_836F1EEB-72F1-4CB3-A8EE-79F97A6B33F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Well = that's good to know for me as I was considering moving off the = winbox.

But if the code isn't portable (which I guess = I don't understand because its just sending string to the ODBC manager) = then that's a nogo for = me.



Dna-SQL is = the core of everything we write.

I haven't = looked at upgrading in a long time. there still is a migration path for = Windows server = correct?



On Jun = 26, 2013, at 7:16 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Thanks Alex.

It doesn't work on Linux build = :(

Would be very nice to do it that = way.



On = 26/06/2013, at 10:55 PM, Alex McCombie <info@adventureskies.com> = wrote:

Sorry = for the delay Stuart. I missed this message.

Keep in = mind I am on a winbox and it's as easy as setting up a = DSN.

Once that is done it basically straight = SQL syntax.


Here is one I was = just working on:


[SQL = dsn=3DDSNNAME&username=3DYOURUSERNAME&password=3DYOURPASSWORD&= statement=3DUpdate = HRJOB_Jobs 
set 
onlinelocation =3D = '[onlinelocation]',
title =3D '[ConvertWords = db=3D/databases/Sqlconversions.db][titleSKU][/ConvertWords]', 
<= div>Description =3D '[descSKU]', 
filled =3D = '[skufilled]', 
datefilled =3D = '[datefilledsku]', 
active =3D '[skuactive]' where JobSKU = =3D = '[sku]';]
[/SQL]


Basical= ly I can almost take any SQL and drop it in the [SQL] tag and have it = work. Some oddities every now and then will special characters. But it = works like a charm and is who we do almost everything with = WebDNA.

HTH
Alex



On Jun 7, 2013, at 9:02 PM, = Stuart Tremain <webdna@idfk.com.au> = wrote:

Alex

Would you please send me an = example. 

I have a connection working = using [shell] but would like to try with the WebDNA method, i keep = getting "Error: SQL not supported".

I believe = this to be true with the latest Linux = build.

Thanks.


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 25/05/2013, at 12:52 PM, Alex McCombie <info@adventureskies.com> = wrote:

Yep.. = I had it running at one point on a Mac version as well.
The only = trick is your OS needs to be able to setup an ODBC connection to = MSSQL.
Webdna [SQL] tag is just sending the SQL string to the = ODBC and then on to MS.

Its pretty much the = only way we do things now so the Data is also simultaneously available = to FMPRO, ACCESS, EXCEL, = etc.

Alex


= On May 23, 2013, at 7:13 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Thanks Alex, I knew that someone was connecting as I recalled some = mention of it on the list.

I have a few issues with = the Windows build and am moving everything to Ubuntu and need to find a = way to make the MSSQL connection. There are a few tools around which I = will check out over the next week but wondered if someone was already = doing it.


=
Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 24/05/2013, at 1:50 AM, Alex McCombie <info@adventureskies.com> = wrote:

Don't = know about the linux issue, but nearly all my code is Wedna 6.0 = connecting to MSSQL Server 2000. 2005, 2008.

We are = running the windows version though and using the standard System DSN for = the ODBC connectivity.

With only minor issues, = we do this = flawlessly.

HTH
Alex


On May 22, 2013, at 12:21 PM, Jeffrey Jones <jjones@synergos.com> = wrote:

[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]

On May 22, 2013, at 4:40 AM, = Stuart Tremain <webdna@idfk.com.au> = wrote:

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>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
Bug Reporting: support@webdna.us


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_836F1EEB-72F1-4CB3-A8EE-79F97A6B33F4-- 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:

re:check boxes (1997) TCP Connect (1999) Virtual Postcards (1998) PCS Frames (1997) [WebDNA] fastcgi 7+ & [cart]? (2010) 2nd WebCatalog2 Feature Request (1996) WebCatalog2 Feature Feedback (1996) WebCat2 several catalogs? (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) [WebDNA] question posted by Jess (sgbc cebu) (2011) MISTAKE in last post: Adding multiple items to Cart (1999) How can I record purchases to a database? (1998) WebCat2: Items xx to xx shown, etc. (1997) different show next (1997) RE: Credit card processing - UK (1997) Mac Vs WindowsNT (1997) calculating tax rates, mail order solutions and version 2 (1997) Re:no [search] with NT (1997) referrer usage (1997) WC2.0 Memory Requirements (1997)