First Name | Last =Name |
---|---|
[firstName] | [lastName] |
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?=--Apple-Mail=_9C59A5D9-59C2-4E7A-BD23-5803168CBC62-- Associated Messages, from the most recent to the oldest:On Jun =26, 2013, at 7:16 PM, Stuart Tremain <webdna@idfk.com.au> =wrote:Thanks Alex.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listIt 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_Jobssetonlinelocation =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.HTHAlex---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list
=div>On Jun 7, 2013, at 9:02 PM, =Stuart Tremain <webdna@idfk.com.au> =wrote:AlexWould 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.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn 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---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list=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.=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn 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.HTHAlex---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn May 22, 2013, at 12:21 PM, Jeffrey Jones <jjones@synergos.com> =wrote:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list[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.To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us
--Apple-Mail=_9C59A5D9-59C2-4E7A-BD23-5803168CBC62Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiAlexAfter starting WebDNA on Mac (System 8 from memory) and then spending 14 =years on Windows server I have just spent the last 3 months developing =on Ubuntu 12.04, it has been a delight to be able to use some of the =tools that exist in the Linux world to develop some of the systems that =I have been asked to do.Moving a site from Windows to Linux will almost work with a straight FTP =transfer, the only problems I had were the fact that the reference to =[include] files and dbs is case sensitive. File paths are a little =different too when doing uploads and fiddling with Imagemagick, nothing =that can't be solved within a few hours.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 28/06/2013, at 4:40 AM, Alex McCombie
- Re: [WebDNA] Connect to MS SQL (Alex McCombie
2013) - Re: [WebDNA] Connect to MS SQL (Stuart Tremain
2013) - Re: [WebDNA] Connect to MS SQL (Stuart Tremain
2013) - Re: [WebDNA] Connect to MS SQL (Alex McCombie
2013) - Re: [WebDNA] Connect to MS SQL (Donovan Brooke
2013) - Re: [WebDNA] Connect to MS SQL (Alex McCombie
2013) - Re: [WebDNA] Connect to MS SQL (Stuart Tremain
2013) - Re: [WebDNA] Connect to MS SQL (Alex McCombie
2013) - Re: [WebDNA] Connect to MS SQL (Stuart Tremain
2013) - Re: [WebDNA] Connect to MS SQL (Alex McCombie
2013) - Re: [WebDNA] Connect to MS SQL (Stuart Tremain
2013) - Re: [WebDNA] Connect to MS SQL (Alex McCombie
2013) - Re: [WebDNA] Connect to MS SQL (Jeffrey Jones
2013) - Re: [WebDNA] Connect to MS SQL (Jeffrey Jones
2013) - [WebDNA] Connect to MS SQL (Stuart Tremain
2013) =wrote:> Well that's good to know for me as I was considering moving off the =winbox.>=20> 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.>=20>=20>=20> Dna-SQL is the core of everything we write.>=20> I haven't looked at upgrading in a long time. there still is a =migration path for Windows server correct?>=20>=20>=20> On Jun 26, 2013, at 7:16 PM, Stuart Tremain =wrote:>=20>> 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
>>>>>>>>>>>>>>>> [/SQLresult]>>>>>>>>=20>>>>>>>> On May 22, 2013, at 4:40 AM, Stuart Tremain =
>>>>>>>> [founditems]>>>>>>>> First Name Last =Name >>>>>>>> [/founditems]>>>>>>>> [firstName] [lastName] 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>=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=_9C59A5D9-59C2-4E7A-BD23-5803168CBC62Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiAlex After starting WebDNA on Mac (System 8 from =memory) and then spending 14 years on Windows server I have just spent =the last 3 months developing on Ubuntu 12.04, it has been a delight to =be able to use some of the tools that exist in the Linux world to =develop some of the systems that I have been asked to =do.Moving a site from Windows to Linux will =almost work with a straight FTP transfer, the only problems I had were =the fact that the reference to [include] files and dbs is case =sensitive. File paths are a little different too when doing uploads and =fiddling with Imagemagick, nothing that can't be solved within a few =hours.On 28/06/2013, at 4:40 AM, Alex McCombie <info@adventureskies.com> =wrote: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?=--Apple-Mail=_9C59A5D9-59C2-4E7A-BD23-5803168CBC62-- Stuart TremainOn Jun =26, 2013, at 7:16 PM, Stuart Tremain <webdna@idfk.com.au> =wrote:Thanks Alex.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listIt 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_Jobssetonlinelocation =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.HTHAlex---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list
=div>On Jun 7, 2013, at 9:02 PM, =Stuart Tremain <webdna@idfk.com.au> =wrote:AlexWould 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.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn 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.Its pretty much the =only way we do things now so the Data is also simultaneously available =to FMPRO, ACCESS, EXCEL, =etc.Alex---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list=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.=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn 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.HTHAlex---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn May 22, 2013, at 12:21 PM, Jeffrey Jones <jjones@synergos.com> =wrote:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list[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.To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us
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:
Ok here is a question? (1997) Uh...can someone help me out with the b10? (1997) New command suggestion (was Modifying databasesmanually) (1997) TCPConnect strange behaviour (2004) webstar in demo (2000) Perl programmer needed (2002) Rhapsody? (1997) PCS Frames-Default page is solution! (1997) Text data with spaces in them... (1997) [shownext] and sort (1998) DON'T use old cart file! (1997) Calendar Snippet Problems (1998) More news on 5.0 (2003) Purchase Plugin Missing (1996) [searchString] (1997) LookUp Tag (1997) [WriteFile] problems (1997) [WebDNA] [OT] - One Man. One Road. (2010) WCS Newbie question (1997) Securing a Directory (2000)