Re: [WebDNA] SQLdisconnect / sqlrelease

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106516
interpreted = N
texte = Tommy, you are using ODBC. [SQLdisconnect] and [SQLrelease] are working = with MySQL only. - chris On Apr 10, 2011, at 17:27, Tommy Bell wrote: > I inheriteted a webdna system, and the SQL statements are usually of = the form >=20 > [SQL dsn=3D[unurl][dsn][/unurl]&statement=3DrunStatement @sQuery = =3D'[samecast_statement]'] > [foundItems][text show=3DF]titler=3D[titles][hideif = [index]=3D1],[/hideif] '[DB_TITEL]'[/text][/foundItems] > [/sql] > where [samecast_statement] is a previously defined variable with a = query in it >=20 > or >=20 > [SQL dsn=3D[unurl][dsn][/unurl]&statement=3DSELECT DB_TITEL from = persontitler where DB_PERSON=3D'[person]' group by DB_TITEL] > [foundItems] > =1D[text show=3DF]titler=3D[titler][hideif [index]=3D1],[/hideif] = '[DB_TITEL]'[/text] > [/foundItems] > =1D=1D=1D [/sql] >=20 > I am using MSSQL and I am running out of sql connections, can anyone = tell me where to place sqldisconnect or sqlrelease so i can limit the = number of connections to my server? >=20 > Regards > Tommy > --------------------------------------------------------- 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] SQLdisconnect / sqlrelease (christophe.billiottet@webdna.us 2011)
  2. [WebDNA] SQLdisconnect / sqlrelease (Tommy Bell 2011)
Tommy, you are using ODBC. [SQLdisconnect] and [SQLrelease] are working = with MySQL only. - chris On Apr 10, 2011, at 17:27, Tommy Bell wrote: > I inheriteted a webdna system, and the SQL statements are usually of = the form >=20 > [SQL dsn=3D[unurl][dsn][/unurl]&statement=3DrunStatement @sQuery = =3D'[samecast_statement]'] > [founditems][text show=3DF]titler=3D[titles][hideif = [index]=3D1],[/hideif] '[DB_TITEL]'[/text][/foundItems] > [/sql] > where [samecast_statement] is a previously defined variable with a = query in it >=20 > or >=20 > [SQL dsn=3D[unurl][dsn][/unurl]&statement=3DSELECT DB_TITEL from = persontitler where DB_PERSON=3D'[person]' group by DB_TITEL] > [founditems] > =1D[text show=3DF]titler=3D[titler][hideif [index]=3D1],[/hideif] = '[DB_TITEL]'[/text] > [/foundItems] > =1D=1D=1D [/sql] >=20 > I am using MSSQL and I am running out of sql connections, can anyone = tell me where to place sqldisconnect or sqlrelease so i can limit the = number of connections to my server? >=20 > Regards > Tommy > --------------------------------------------------------- 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 christophe.billiottet@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:

Plugin or CGI or both (1997) Ampersand Character (&) (1997) Big Databases (1997) Webten + Webcat running smooth (1998) Databases going to sleep (1998) Stumpted Again (1997) Trouble with formula.db + more explanation (1997) TRAINING videos - Prove IT. (1998) Strange search... (2001) Validation (2000) file upload type restrictions? (2001) authenticate (1999) Does webcatalog recognise NULL values? (1998) Upgrading old WebCat Database Files (1997) WebCatalog f2 Installation (1997) indexing dates (1998) [redirect..] (2006) WebCat2b15MacPlugin - [protect] (1997) [WebDNA] PayPal IPN (was: paypal FINALLY!!!!) (2009) WebCat2b13 Command Reference Doc error (1997)