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=20 Select FirstName, LastName from Authors WHERE Author =3D @AuthorName Select Title from Books WHERE Author =3D @AuthorName GO How 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 1 Invalid column name 'johnson'." And, again, what is the timeline for supporting MSSQL with these new = commands?=20 Thanks. - 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:

    
  1. Re: SQL Support in 6.0 ( "Steve Contreras" 2004)
  2. Re: SQL Support in 6.0 ( "Crist, Trevor" 2004)
  3. Re: SQL Support in 6.0 ( "Scott Anderson" 2004)
  4. SQL Support in 6.0 ( "Crist, Trevor" 2004)
>=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=20 Select FirstName, LastName from Authors WHERE Author =3D @AuthorName Select Title from Books WHERE Author =3D @AuthorName GO How 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 1 Invalid column name 'johnson'." And, again, what is the timeline for supporting MSSQL with these new = commands?=20 Thanks. - 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:

Multiple Search Fields (1998) webcat in the subject line - SMSI (2002) Digest for 4/18/97 (1997) can pull down menu do a ONCHANGE= without Java script? (2000) Interfacing WebMerchant to www.fedex.com (1997) OT : Sound Files (2002) OS Accessing FTP from Browser (2000) Image Pirating [protecting against] (2003) Experience with creating real dynamic solutions?????? (1998) HELP!!! (1998) GuestBook example (1997) Umm...about those log files? (Off Topic) (1997) all records returned. (1997) printing twice? and fix (1997) Alternating colors (1997) WebTen? (1997) Re:no template caching (1997) WebCat2 - [format thousands] (1997) Credit card types (1997) emailer stuck (1997)