|
Which is better... IN() or EXISTS()
|
| |
Hello We're trying to resolve some performance issues and would be grateful for your thoughts on the benefits of each of these methods to get the same result. Which is more performant? SELECT Fields FROM Table WHERE FKeyField IN( SELECT KeyField FROM OtherTable WHERE OtherValue = 'FilterValue'... more »
|
|
|
DB to XML - Best way to automate
|
| |
I have two XML files that a generated from a database. Presently I have to go into my admin section to click a link that loads the pages that in turn create the pages. As my database is updated (new entries relating to property sales) this is a bit of a pain. Has anyone dealt with this issue before?... more »
|
|
|
Advice needed
|
| |
i need help on my download scam site the who is dns server is not working with my php database. can anyone help? you can email me directly or use this address Address: Truda 14-1 City: Saint-Petersburg State: Saint-Petersburg ZIP: 188934 Country: RU Phone: +7.9113234634 the site is [link]... more »
|
|
|
How to efficiently get a random set of records from a DB
|
| |
Hi All I use a MySQL DB with my ASP classic web app. I've been asked if I can create a routine whereby I get a random number of products (records) from the DB and display these on the site. Basically every time a visitor hits the home page, they want the site to display a random selection of say 6 products.... more »
|
|
|
asp
|
| |
And here's a similar handy reference: Visual Basic Scripting Edition VBScript Language Reference [link] Best regards, J. Paul Schmidt, Freelance Web and Database Developer [link] Access Database Sample, Web Database Sample, ASP Design Tips... more »
|
|
|
asp:menu
|
| |
Here's a handy little frames article that might give you some ideas: Inline Frames [link] Best regards, J. Paul Schmidt, Freelance Web and Database Developer [link] Access Database Sample, Web Database Sample, ASP Design Tips *** Sent via Developersdex [link] ***... more »
|
|
|
Active Server Pages error 'ASP 0113'
|
| |
"Active Server Pages error 'ASP 0113' Script timed out" I am still getting this error, and I am not sure how I could fix this. When I execute the query at SQL 2005, it only takes 8 seconds. The stored procedure for this report has been already went through Database Engine Tuning Advisor to put all the necessary indexes on the associated... more »
|
|
|
how to set Multiple Simultaneous connection in ORACLE
|
| |
hi frndz , I have developed the web application with the backend as ORACLE database , I configured my database in DEDICATED MODE.. Can u tell me how to configure no of simultaneous connection in ORACLE , where to configure that option ?.
|
|
|
How to use Multiple database connection using ASP
|
| |
Hi frndz Im developing a web application.. Here im using oracle as my database. In each necessary page im creating database connection and recordset then connecting to database normally as given below. Dim Conn Set Conn = Server.CreateObject("ADODB.Con nection") Dim ConnectionString ConnectionString = "Provider=OraOLEDB.Oracle.1;Pe rsist Security... more »
|
|
|
