|
|
|
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 |
Retrieving autonumber Posted by Paulo Roberto at 8/28/2007 10:08:54 PM Hi, how can I retrieve a ID from a AutoNumber field on MS Access after an
insert into instruction?
Is it possible to be done?
Thanks!
...more >>
Problems with Stored Procedure and Date Posted by Jerry at 8/24/2007 2:42:28 PM I apologize if this is a double post. I tried earlier and it didn't
appear to post.
I'm passing data to a stored procedure in SQL Server 2000 and am
having trouble with the date parameters. If I pass a date it works. If
I don't pass any data I get the following error:
ADODB.Command error '800...more >>
Still Not Resolved Posted by Jack at 8/22/2007 8:40:04 AM Hi,
I want to display two fiels from a query in a combo box. I am checking to
make sure that the the selected fields do generate value. However, in the
combo box, I have only one field that is being displayed instead of two
fields. I would like to know whether this can be solved in the existi...more >>
trying to capture IP address of PC that submits data to Access db Posted by Larry D at 8/21/2007 5:19:16 PM I have a form on a site where users submit some data. I have had a problem
with someone submitting garbage data, I can delete it but would like to stop
it. I started capturing IP addresses using the code below to write the IP to
the access db where the other data goes. I have submitted the for...more >>
How to rewind a recordset from Cmd.Execute Posted by michael sorens at 8/21/2007 3:40:00 PM I want to invoke the Execute method of a Command to obtain a record set, then
reuse that record set twice. A rough code outline appears below. It appears
that the record set return from Command.Execute is non-rewindable, however;
upon attempting the second "MoveFirst" I get this error:
"error...more >>
Problem with retrieving values in a combo box from a query Posted by Jack at 8/21/2007 11:12:01 AM Hi,
I am trying to retrieve values from a query in a list box. However, it is
giving me no recordset. Although I get recordset when I query this access
database. Any help for resolution on this is appreciated. Thanks
CODE:
<%
Dim oConn
Dim oRS
Dim vCS
Dim sqltxt
set oConn=server.Cre...more >>
I cant run asp.net web application Posted by rajesh at 8/21/2007 12:38:19 AM I cant run asp.net web application
project.. error is windows authentication is not set..
my os is windowsXP
help me plzzz...more >>
ASP Classic: Database problem Posted by schurst30 at 8/20/2007 6:50:04 AM Hi, I am currently trying to get back into ASP and have begun looking at an
old webpage I developed some years ago, it was fully functional back in 2002
and I had it up and running with no problems. I have just recently bought a
new PC with Windows Vista Home Premium on it and installed IIS. W...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
GroupBy GridView Posted by chakris at 8/13/2007 4:56:02 AM Hi,
I got stuck with GridView control while binding it from a datatable. As my
requirement is i want to show my grid in "Group By" passion. Suppose i have
feilds like Order,OrderDetails,OrderDate and i want to Group this by
OrderDate in a hierarchical passion. Can any one suggest me for ache...more >>
Detect the name of the ASP.NET user Posted by Vilhelm at 8/9/2007 11:54:02 AM I am making a ASP.NET application that connects to a database.
I want to distrtibute this to my customers that may have different Windows
OS, so my installer must handle different windows versions.
In my installer I am using the following SQL statement to enable ASP.NET to
connect to my da...more >>
newbie problem with stored procedure return value Posted by microsoft at 8/9/2007 10:00:03 AM For the life of me I cannot get the following stored procedure to return a
value in a classic asp vbscript page. Can someone please help a poor soul?
Here is the SP that returns the next order number available for use:
CREATE PROCEDURE ap_GetOrderNumber2
AS
SET NOCOUNT ON
DECLARE @nextOr...more >>
XPost: Problem with IIS 7 and DB's Posted by Jan K. van Dalen at 8/8/2007 12:32:57 AM Ok, I wrote test (ASP, ASP.Net & PHP) all of them hitting the same database.
This is the first time I try to connect to a DB under Vista/II7 and it seems
that I'm missing setting some type of security but don't know what.
When test the ODBC connection everything works fine, when executed fro...more >>
Outputting a bitmap from an Access database Posted by jason NO[at]SPAM careermatrix.com at 8/7/2007 7:00:26 AM I have an access database with a field of "OLE Object" that has
bitmaps. I'm trying to output these bitmaps to an ASP page viewed in a
webbrowser.
This is how I'm attempting to do this now:
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=GLGInventory"
strSQL = "SELECT *...more >>
generating html Posted by SOC at 8/6/2007 12:00:00 AM (Further to "24hrs static content".....many thanks)
Currently our web site is pulling all pages from a database, dependent on
querystrings.
I wish to set up different system:
index.asp lists a selection of links to pages, but instead of
href="/page.asp?a=10&b=20"
the link will be
href="/...more >>
Constructing secure queries in classic ASP Posted by michael sorens at 8/2/2007 10:46:03 AM I am familiar with the SqlCommand object available in .NET (VBScript or C#)
which provides a powerful security feature by using a template in conjunction
with SqlParameters. I have been searching without success to determine
whether classic ASP with VBScript has something equivalent. Does it?...more >>
database connection issue Posted by BigSam at 8/2/2007 9:48:05 AM We are moving to SQL2k5 & attempting to utilize mirrored databases. I gave a
connection string to our developers to use in the ASP (classic) pages:
"Provider=SQLNCLI;Server=10.0.0.1;Failover Partner=10.0.0.2;Initial
Catalog=dbName;UID=SQL User Name;Pwd=Password;"
When the database is Principal...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |