|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Access multiuser / transactions / asp Posted by Patrick at 4/7/2004 6:01:48 PM Hi all
I'm getting this error message :
The table "MyTable" is already opened exclusively by another user or it is
already open throught the user interface and cannot be manipulated
programmatically
Of course Access User interface is not opened.
This happens when 2 users try to write to th...more >>
FORMATING NUMBERS IN ASP Posted by Stephen Cairns at 4/7/2004 7:36:02 AM I have the results of a stored procedure coming back in an asp successfully however it seems to be rounding up the number of decimal places I have. Here is an example of how my results are coming back and how I need them to come back:
Currentl
Pub Name Cal Price Copies Re
Belf...more >>
MaxRecords to make db call faster Posted by dw at 4/6/2004 10:07:06 AM Hello, all. We have a search page that can return many thousands of records
from a SQL Server 2000 database. We've noticed that it's slow -- mainly b/c
the stored procedure arranges the person's first, middle, last names into
'name' before returning the results. In addition, we're using recordset...more >>
simple stored procedure Posted by dave at 4/5/2004 10:46:43 PM Hi there!!
I want to try stored proceudre that copies one field data
from table1 to table2..
Can any one suggest how to write? I searched on net but
no success yet...
Thanx
dave...more >>
Random records (but with logic) Posted by Luke at 4/5/2004 8:25:02 PM Hi,
I need to extract randomly 5 records from the table "Questions". Now I use
SELECT TOP 5 FROM Questions ORDERBY NEWID()
And it works. The problem is that I need an additional thing: if SQL
extracts record with ID=4, then it should not extract record with ID=9,
because they are similar....more >>
What is the most efficient way to connect to a MySQL dbase? Posted by Mike Hill at 4/5/2004 7:37:18 PM I am setting up a data driven site and I will be using MySQL. What is the
best connection method to use. (ADO, etc..)
It will be hosed on a W2K Server.
Thanks,
Mikeal
...more >>
ADO Field Order Posted by Douglas at 4/5/2004 1:05:12 PM Sorry for the repost, I have had problems with my ISP(s) news servers... I'm
on my third news server and hopefully things have improved :P... grr
anyways...
Gday,
I need to retrieve a list of FieldNames from a table.
I've done this successfully using ADOX.
The question is, I want to ...more >>
Howto get the current file path with SSI Posted by Eranga Udesh at 4/5/2004 9:06:27 AM Hi All,
In my ASP file, located at the "/test" directory of the website, I include
another ASP file as below.
<!--#include file="../templates/_header.asp"-->
Inside the _header.asp file, how can I get the current file (_header.asp)
directory? I need to get the web relative/absolute direct...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Rendering large recordsets Posted by Ken McAndrew at 4/5/2004 8:51:14 AM I'm trying to work on some performance issues in a couple of areas. The
scenario is that I have an 8000+ recordset that's returned and intended to
be written to a drop-down list. This can take up to 10 minutes or more to
occur. I already have the query in a stored procedure, and I've set up
disc...more >>
There is no such professional who could solve my problem? Posted by Sajid at 4/5/2004 2:11:04 AM Hi all.
I am using ASP and SQL Server 2000
I have a requirement in which customer fills in a form. The provided form fields are searched against the coulmns in customer table. For example FirstName is searched against FirstName in the table and so on. If the form data
is same as that of a table...more >>
Incorrect RecordCount Posted by Scott at 4/4/2004 7:42:29 PM I'm trying to get the recordcount below if a user successfully logs in. The
' If RS.RecordCount=1 Then" part never works because the recordcount
returns -1 even if the user enters correct info.
I'm using SQL 2000. What's the trick to get a correct recordcount?
Public Function ProcessEmpl...more >>
ASP & Databases Posted by Jim Bowman at 4/4/2004 3:37:29 PM I am unable to insert a row in a database using an .asp
page. I am running IIS 5.1 that comes with Windows XP.
I can read a row from the database using an .asp page
that includes the SQL SELECT statement. But when I use
the sample code in Lesson 3 (Creating a Guest Book using
a Database...more >>
Adjusting string handling function for exceptions? Posted by Ken Fine at 4/3/2004 5:32:55 PM No joy on Macromedia's boards after a few days; maybe someone can help me
here.
I got an excellent string handling function off of planet-source-code.com
that converts text strings to proper case, i.e. "the REMAINS of the DAY" is
converted to "The Remains Of The Day".
This function is part...more >>
Error: Cannot create new connection because in manual or distributed transaction mode Posted by CJM at 4/2/2004 3:52:57 PM I have page that starts a transaction and runs several StoredProcs before
committing or rollingback. An initial SP create a header records, and then
the code goes into a loop and runs 4 other SP's once per iteration.
I'd had it working previous, but now I have changed one of the SPs and the
or...more >>
Error: Cannot create new connection because in manual or distributed transaction mode Posted by CJM at 4/2/2004 3:51:55 PM I have page that starts a transaction and runs several StoredProcs before
committing or rollingback. An initial SP create a header records, and then
the code goes into a loop and runs 4 other SP's once per iteration.
I'd had it working previous, but now I have changed one of the SPs and the
or...more >>
How do I give same value as primary key to other field Posted by Bob The ASP Builder at 4/2/2004 3:48:48 PM
In My database I want to give a field in a new row the same value as
the ID-filed (primary key) automatically gets - there must be a smart
way!!? ...more >>
Break for weekends? Posted by PorkyJr at 4/2/2004 2:59:50 PM
Looping through a record set based on calendar dates that the user
inputs. The asp page returns the results as advertised; however, it
would be very nice to have a sub-total based on the week (sub-totals
after every Saturday). Problem is that there is no guarantee of records
being there fo...more >>
ASP totals and sub-totals from an Access or SQL DB Posted by Laphan at 4/1/2004 9:02:41 PM Hi All
I know I posted a similar topic a few days ago, but I may have gone on a bit
of a rant with it.
Basically I want to know if it is possible to generate ASP-coded sub-totals
and totals on a basic recordset where the sub-totals are to break down say
by stock categories in a standard oRS...more >>
security: sql or win connections ? Posted by Hernán Castelo at 4/1/2004 5:55:20 PM hi
i have 4 accounts in sql : userType1...., 4
and .Asp pages that connect to sql2K using one of them
each account can only execute its stored procedures
each account have its own password
then i have the connection strings in an #include file
I readed that existence of a plain text connec...more >>
SQL Query problem... Posted by Mike Hill at 4/1/2004 4:09:49 PM Here is a query I am trying to execute.
SELECT ConsultantPIN, CFirstName, CLastName, Count(DateSubmitted) AS [Total]
FROM consultant_DS WHERE DateSubmitted >=#02/01/2004# and DateSubmitted
<=#2/29/2004# Group By ConsultantPIN, CFirstName, CLastName Order By Total
DESC;
My problem is that I ...more >>
Shopping Cart table issue Posted by amit.kela NO[at]SPAM colorado.edu at 4/1/2004 4:05:11 PM Hi,
I am using ASP on my webpage to pull up data from SQL tables. I am
using a Shopping cart page where the users can place orders.
The problem I have once the user has logged in and placed an order
the shopping cart table is empty (as it should be).
But when the user tries to place another...more >>
sql script won't run asp page Posted by tonyabishop NO[at]SPAM hcse.ca at 4/1/2004 8:07:46 AM Hi,
I'm developing a site with a public and members section. I'm using
vbscript, asp, and an access database. The login page is processed by
the members page. If you are a valid member the member page loads.
If not the member page redirects you to the restricted access page.
On the rest...more >>
Seperating data within a field Posted by darrenstahlhut NO[at]SPAM hotmail.com at 4/1/2004 2:41:58 AM Hi All,
I am designing a website for a tennis club. Each week Tennis Australia
release an excel spreadsheet of last weekend's results. I import this
into my access DB for use on the website.
"The problem"
The first coloumn of the spreadsheet is the clubname and division. I
need to seperate...more >>
Windows 2003 Server ODBC Error -Not a valid password - connecting to MS Access DB Posted by estrauss NO[at]SPAM naspers.com at 4/1/2004 2:12:55 AM We are currently busy moving our website from a NT4 Server to a
Windows 2003 Server. One of the site are making use of an MS access
DB. A DSN was setup for the website. The MS Access DB is only secured
by a password. When we try to access the page on the new Windows2003
Server we get:
Microso...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |