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:
Download URL & access on the fly ? (1997)
Strange conversions (2001)
RE: [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (2020)
[WriteFile] problems (1997)
Summary search -- speed (1997)
international time (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Problems appending to database (1997)
WebCat2 - Getting to the browser's username/password data (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Multiple copies (1999)
Sort on time (2003)
using showpage and showcart commands (1996)
search results (1998)
REPOST: Large founditems loops (2000)
Shipping charges depending on tax rate? (1997)
info (1997)
Help! Missing [showif] or [hideif] (2000)
Looking up two prices in Formulas.db (1997)
RequiredFields template (1997)