--Apple-Mail=_BF8C4835-7B6F-4177-9809-C161F5D96C3F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Keith
This = example may help
First make your MySQL connection:
In = this case I use an external DB, you could put in localhost, = etc
[SQLConnect = dbType=3DMySQL&host=3D
db.mydomain.com&database=3Dmydatabase&uid=3Dusernam= e&pwd=3Dpassword&conn_var=3DMYCONNECTION][/SQLConnect]
Then using the variable = MYCONNECTION I do the query:
Here the results are = held in a variable names RES-STOCK
[SQLExecute = conn_ref=3D MYCONNECTION&result_var=3DRES-STOCK]
select T3Q_NEXTDUE, T3Q_TOTAL, T3Q_OL, T3Q_CN, T3Q_MP, = T3Q_SY, T3Q_ME
from t3stock
WHERE T3Q_ILC =3D "[ITEMLOOKUPCODE]"
[/SQLExecute]
Then get the results = from the query:
[SQLResult result_ref=3DRES-STOCK][!]
= [/!][FOUNDITEMS][!]
= [/!][TEXT]STOCK_NEXTDUE=3D[T3Q_NEXTDUE][/TEXT][!]
= [/!][TEXT]STOCK_TOTAL=3D[T3Q_OL][/TEXT][!]
= [/!][TEXT]STOCK_OL=3D[T3Q_OL][/TEXT][!]
= [/!][TEXT]STOCK_CN=3D[T3Q_CN][/TEXT][!]
= [/!][TEXT]STOCK_MP=3D[T3Q_MP][/TEXT][!]
= [/!][TEXT]STOCK_SY=3D[T3Q_SY][/TEXT][!]
= [/!][TEXT]STOCK_ME=3D[T3Q_ME][/TEXT][!]
= [/!][/FOUNDITEMS][!]
[/!][/SQLResult]
Kind regards
Stuart Tremain
IDFK Web Developments
AUSTRALIA
I=E2=80=99v= e been trying to get my WebDNA to connect to MySQL and have not been = able to do so with version (6.2 with Centos5) or version (8.0 with = Centos6). I posted in the regular forums and was advised to try = here. Basically, I started out on my 6.2 WebDNA server and = followed the setup directions for the DSN setup which, I can connect to = my MySQL via a DSN with isql and perform queries and such. If I = try to use WebDNA, I get the error: MySQL not supported. If I = tried to use the SQLCONNECT method I get the error: INVALID VALUE (MySQL) FOR PARAMETER: = type.
After a couple of postings in the forums, I was told I = don=E2=80=99t need to use the DSN method because WebDNA supports MySQL = natively (though I tried both method). I then figured, I would = give it a try on my version 8 WebDNA server and, I still am getting the = same exact messages. I=E2=80=99ve been sifting through any = postings I can find and I can=E2=80=99t find any form of resolution.
Any help = is greatly appreciated.
KS
= --Apple-Mail=_BF8C4835-7B6F-4177-9809-C161F5D96C3F--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_BF8C4835-7B6F-4177-9809-C161F5D96C3F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Keith This example may help First make your MySQL connection: In this case I use an external DB, you could put in localhost, etc [SQLConnect = dbType=3DMySQL&host=3Ddb.mydomain.com&database=3Dmydatabase&uid=3Dusername= &pwd=3Dpassword&conn_var=3DMYCONNECTION][/SQLConnect] Then using the variable MYCONNECTION I do the query: Here the results are held in a variable names RES-STOCK [SQLExecute conn_ref=3D MYCONNECTION&result_var=3DRES-STOCK] select T3Q_NEXTDUE, T3Q_TOTAL, T3Q_OL, T3Q_CN, T3Q_MP, T3Q_SY, T3Q_ME from t3stock WHERE T3Q_ILC =3D "[ITEMLOOKUPCODE]" [/SQLExecute] Then get the results from the query: [SQLResult result_ref=3DRES-STOCK]
[!] [/!]
[founditems][!] [/!]
[text]STOCK_NEXTDUE=3D[T3Q_NEXTDUE][/TEXT]
[!] [/!]
[text]STOCK_TOTAL=3D[T3Q_OL][/TEXT]
[!] [/!]
[text]STOCK_OL=3D[T3Q_OL][/TEXT]
[!] [/!]
[text]STOCK_CN=3D[T3Q_CN][/TEXT]
[!] [/!]
[text]STOCK_MP=3D[T3Q_MP][/TEXT]
[!] [/!]
[text]STOCK_SY=3D[T3Q_SY][/TEXT]
[!] [/!]
[text]STOCK_ME=3D[T3Q_ME][/TEXT]
[!] [/!][/FOUNDITEMS]
[!] [/!][/SQLResult] Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 5 Apr 2015, at 10:20, Keith Scarzafava
= wrote: >=20 > I=E2=80=99ve been trying to get my WebDNA to connect to MySQL and have = not been able to do so with version (6.2 with Centos5) or version (8.0 = with Centos6). I posted in the regular forums and was advised to try = here. Basically, I started out on my 6.2 WebDNA server and followed the = setup directions for the DSN setup which, I can connect to my MySQL via = a DSN with isql and perform queries and such. If I try to use WebDNA, I = get the error: MySQL not supported. If I tried to use the SQLCONNECT = method I get the error: INVALID VALUE (MySQL) FOR PARAMETER: type. > =20 > After a couple of postings in the forums, I was told I don=E2=80=99t = need to use the DSN method because WebDNA supports MySQL natively = (though I tried both method). I then figured, I would give it a try on = my version 8 WebDNA server and, I still am getting the same exact = messages. I=E2=80=99ve been sifting through any postings I can find and = I can=E2=80=99t find any form of resolution. > =20 > Any help is greatly appreciated. > =20 > KS > =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 --Apple-Mail=_BF8C4835-7B6F-4177-9809-C161F5D96C3F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Keith
This = example may help
First make your MySQL connection:
In = this case I use an external DB, you could put in localhost, = etc
[SQLConnect = dbType=3DMySQL&host=3D
db.mydomain.com&database=3Dmydatabase&uid=3Dusernam= e&pwd=3Dpassword&conn_var=3DMYCONNECTION][/SQLConnect]
Then using the variable = MYCONNECTION I do the query:
Here the results are = held in a variable names RES-STOCK
[SQLExecute = conn_ref=3D MYCONNECTION&result_var=3DRES-STOCK]
select T3Q_NEXTDUE, T3Q_TOTAL, T3Q_OL, T3Q_CN, T3Q_MP, = T3Q_SY, T3Q_ME
from t3stock
WHERE T3Q_ILC =3D "[ITEMLOOKUPCODE]"
[/SQLExecute]
Then get the results = from the query:
[SQLResult result_ref=3DRES-STOCK]
[!] = [/!]
[text]STOCK_NEXTDUE=3D[T3Q_NEXTDUE][/TEXT]
[!] [/!][/SQLResult]