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:
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:
Reserved word? (2005)
Support ?? (1997)
SiteEdit Pro Update Announcement (1997)
What is WebDNA (1997)
OT: passing variables to .asp (2000)
re:check boxes (1997)
Trouble Searching (1999)
database search help (2003)
fresh eyes needed. Append won't work. (2000)
Thanks for tips, more quest (1997)
WebDNA 5.0 Questions (2003)
no template caching (1997)
multi-paragraph fields (1997)
pc (1997)
A quickie question (1997)
WebCat2final1 crashes (1997)
WebCatalog/WebMerchant Manuals Available (1998)
Attention eCommerce Sites (deadline 12/12) (1997)
Email within tmpl ? (1997)
[Replace] (2000)