Re: SQL Support in 6.0
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56181
interpreted = N
texte = >=20> Are you referring to the old [SQL] context? The new SQL contexts does =not> use ODBC to communicate with a MySQL server.No. I am referring to the new commands. And the question was about =MSSQL, not MySQL.If I execute this:[SQLExecute ref=3DMyConnection&var=3DMyResults]exec getAuthorsAndBooks @AuthorName =3D 'Smith'[/SQLExecute]And the Stored Procedure named getAuthorsAndBooks looks something like =this:CREATE PROC getAuthorsAndBooks=20@Author varchar(20)AS=20Select FirstName, LastName from Authors WHERE Author =3D @AuthorNameSelect Title from Books WHERE Author =3D @AuthorNameGOHow does the SQLResults parse the two different results sets?Also, if I happen to put in invalid SQL, like this:[SQLExecute ref=3DMyConnection&var=3DMyResults]exec getAuthorsAndBooks @AuthorName =3D Smith[/SQLExecute]Does that mean that the Server Message gets returned where the ='SQLExecute' command is on my WebDNA page?=20"Server: Msg 207, Level 16, State 3, Line 1Invalid column name 'johnson'."And, again, what is the timeline for supporting MSSQL with these new =commands?=20Thanks.- Trevor>=20> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Crist, Trevor> Sent: Tuesday, February 17, 2004 11:50 AM> To: WebDNA Talk> Subject: SQL Support in 6.0>=20>=20> What is the timeline for support of MSSQL?>=20> Also, I don't see any way for the new SQL features to handle:> - Returns of multiple rowsets (typical when executing a stored =procedure)> - Ability to handle error and other message types that are generated =by> the SQL server.>=20> These two issues in my mind are the biggest limitations with WebCat's =SQL> support (aside from the ODBC bottlenecks).>=20> Are there plans to add this support? If so, what is the timeline?>=20> We have begun moving much of our system over to .asp. However, if =these> features are supported, we will buy version 6 and keep on using =WebDNA.>=20> Thanks.>=20> - Trevor>=20>=20>=20> ---> Outgoing mail is certified Virus Free.> Checked by AVG anti-virus system (http://www.grisoft.com).> Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004>=20>=20> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/>=20> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/>=20> ---> Incoming mail is certified Virus Free.> Checked by AVG anti-virus system (http://www.grisoft.com).> Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004>=20---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004=20-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>=20> Are you referring to the old [SQL] context? The new SQL contexts does =not> use ODBC to communicate with a MySQL server.No. I am referring to the new commands. And the question was about =MSSQL, not MySQL.If I execute this:[SQLExecute ref=3DMyConnection&var=3DMyResults]exec getAuthorsAndBooks @AuthorName =3D 'Smith'[/SQLExecute]And the Stored Procedure named getAuthorsAndBooks looks something like =this:CREATE PROC getAuthorsAndBooks=20@Author varchar(20)AS=20Select FirstName, LastName from Authors WHERE Author =3D @AuthorNameSelect Title from Books WHERE Author =3D @AuthorNameGOHow does the SQLResults parse the two different results sets?Also, if I happen to put in invalid SQL, like this:[SQLExecute ref=3DMyConnection&var=3DMyResults]exec getAuthorsAndBooks @AuthorName =3D Smith[/SQLExecute]Does that mean that the Server Message gets returned where the ='SQLExecute' command is on my WebDNA page?=20"Server: Msg 207, Level 16, State 3, Line 1Invalid column name 'johnson'."And, again, what is the timeline for supporting MSSQL with these new =commands?=20Thanks.- Trevor>=20> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Crist, Trevor> Sent: Tuesday, February 17, 2004 11:50 AM> To: WebDNA Talk> Subject: SQL Support in 6.0>=20>=20> What is the timeline for support of MSSQL?>=20> Also, I don't see any way for the new SQL features to handle:> - Returns of multiple rowsets (typical when executing a stored =procedure)> - Ability to handle error and other message types that are generated =by> the SQL server.>=20> These two issues in my mind are the biggest limitations with WebCat's =SQL> support (aside from the ODBC bottlenecks).>=20> Are there plans to add this support? If so, what is the timeline?>=20> We have begun moving much of our system over to .asp. However, if =these> features are supported, we will buy version 6 and keep on using =WebDNA.>=20> Thanks.>=20> - Trevor>=20>=20>=20> ---> Outgoing mail is certified Virus Free.> Checked by AVG anti-virus system (http://www.grisoft.com).> Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004>=20>=20> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/>=20> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/>=20> ---> Incoming mail is certified Virus Free.> Checked by AVG anti-virus system (http://www.grisoft.com).> Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004>=20---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004=20-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Crist, Trevor"
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:
Encrypted Databases (2000)
encrypt (2000)
shipcost (1997)
General WebCatalog Questions (1997)
WebCat2.0 acgi vs plugin (1997)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Searching multiple Databases (1997)
More on the email templates (1997)
[OT] : Chat Room on OSX (2003)
suggestion (1997)
foreign languages, email, webcat (1998)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
Removing [showif] makes a big difference in speed (1997)
[WebDNA] Two file tags don't work as expected (2009)
Multi Actions (1999)
[append] and SSL (1997)
Web DNA rates (2000)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Slow applescript context ... (2000)
Some Advise needed (1997)