| Groups | Blog | Home |
|
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 Display x number of records Posted by Dave Karmens at 4/14/2004 4:27:05 PM How could I display *only* x# of records even if the select statement
returns a value >x?...more >>
Replace into..?? Posted by Michael Posthoff at 4/14/2004 11:36:19 AM Hallo Group,
is there an equivelant/replacement of the MySQL Command "Replace Into" for
Access/MS SQLServer?
"Replace Into" does either inserting or updating of data, depending on
whether the record exists or not. And I would love to avoid 2 differnet
functions for this.
regards,
Michae...more >>
Passing ASP Variables Posted by Darren Woodbrey at 4/14/2004 10:38:21 AM I have a form that submits to a SQL database. The table in SQL uses an
identity field for the primary key called "entry". This is so I can get the
primary key to auto-increment. The form posts to a page with a SQL insert
statement. On this page I run a select statement to retrieve the entry
...more >>
Need help with recursively getting data from database Posted by Dragonhunter at 4/14/2004 4:10:00 AM Hello all,
I'm trying to make a simple database that stores notes in categories.
Notes can have multiple categories and categories can have other
categories as subcategories. A web page will list a category and any
subcategories and notes under it. Seems simple but when I try to
implement i...more >>
Requested resource in use Posted by RH at 4/13/2004 8:15:53 PM Win2K latest service packs
IIS 5.0
Connecting to an Access DB *2003)- simple userlogin page, checks userpass &
ID
I'm all of a sudden getting the message on the redirect page "requested
resource is in use"
I can't figure it out. Goes through the login handler, and in the URL shows
it's on ...more >>
Side bar category that opens up when clicked Posted by James at 4/13/2004 1:19:01 PM I'm trying to develop a suitable navigation structure for
my website, but I've gotten stumped trying to develop the
navigation. I would like a side bar that list the
categories then once a user clicks a category then it
opens the pages within the category. Here is a link to
what I want t...more >>
Problems with views from Firebird Posted by Cecil Westerhof at 4/13/2004 1:17:29 PM I have to maintain code written by someone else. It makes extensive use of
dynamic views and stored procedures. The strange thing is that when we
execute the statement "DROP VIEW MV_22_", that it never gives an error, but
is not always done. When I then try to delete it with Database Workbench, i...more >>
SQL error '80040e21' when adding more text than the Field can handle Posted by wwwacny NO[at]SPAM yahoo.com at 4/13/2004 10:11:25 AM I have a field in a table called description. I set the lenght to
7000 characters and the datatype to char on the description field.
Problem is that some people are putting more than 7000 characters into
the description field and are getting the error below. How can I
resolve this?
ERR...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error: SQL Server does not exist or access denied Posted by Dave Navarro at 4/13/2004 8:44:43 AM My client has a server running Windows 2003 Server and SQL Server 2000.
The sole purpose of the server is to run a single web site.
It was previously hosted with Verio and except for a problem backing up
the SQL database, it ran just fine.
Since it's been moved to the new web server we've...more >>
Dynamic invisable spacer Posted by Joe...B at 4/12/2004 11:41:02 PM Hello People
Just a quick question and possibly quite a simple one! I want to be able to dynamically change the size of a spacer image in some html I have
It is a kind of calendar and what I want to do is use a start date for a week then extend the image to a certain date. I realise a need to tu...more >>
Select Query Help Posted by Abul Hasan at 4/12/2004 6:01:53 PM Hello everyone,
I want to extract weekly report from access dataabse into recordset.
Scenario is as follows
WEEK Number of SMS
1 50
2 25
3 30
obviously Weeks should be reset when month changes.
Its u...more >>
getrows breaks if WHERE in sql Posted by DavidT at 4/12/2004 1:00:44 PM Hello all willing to assist. This should be simple but it's killing me. I
have this query (Access2k):
strsql="SELECT M.NewRingNum "
strsql= strsql & "FROM tblMain M "
strsql= strsql & "WHERE M.NewRingNum LIKE 'PH*' "
strsql= strsql & "ORDER BY M.NewRingNum;"
If run in access it retur...more >>
Insert issue Posted by insert into MS Access issue at 4/12/2004 7:01:04 AM I have the following code in an ASP page that is processing a form to create a new user. I keep getting the following error
Microsoft JET Database Engine (0x80040E14
Syntax error in INSERT INTO statement
The database is MS Access, the latest, I am able to perform select statements on it and do...more >>
Connect to Access 20002 on local computer Posted by Steve at 4/11/2004 5:09:29 PM Here's the code I'm trying to use; basic ASP code and it just reads the
records in the database: I want to use it on my local computer where this
file "ReadRecords.asp" and the "calgarywebconcepts.mdb" file are both in the
Inventory directory. I'm using Access 2002 and my problem seems to be in h...more >>
Please help Posted by Bhaskardeep Khaund at 4/11/2004 2:04:44 AM Hi,
I have been a silent memeber of this group from some time, though i never
posted anything. But now I had to....as I am facing a little problem. Please
help me. Thanks in advance.
Ok.....I am creating a site on ASP and SQL, which would essentially be
hosted in a third party server like I...more >>
Operation must use an updateable query. Posted by krunom at 4/11/2004 1:22:15 AM When i want to insert data in database with:
"conn.execute sql"
i get error message for this line:
"Operation must use an updateable query".
I read that i should change security options for folder that contains this
database...but in Windows2000 i DONT have security tag in folder
properties!...more >>
can i modify the content in the buffer of response(not response.buffer prep) Posted by xingye at 4/11/2004 1:00:00 AM
...more >>
IIS6 - Access bug Posted by Bob Barrows at 4/9/2004 9:13:04 PM http://support.microsoft.com/default.aspx?scid=kb;en-us;838306
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I don't
check it very often. If you must reply off-line, then remove the "NO SPAM"
...more >>
Problem connecting to local Access database - Unable to open registry key 'Temporary (volatile) Jet DSN ... Posted by Joe at 4/9/2004 6:43:12 PM Hi
I get the following error sporadically when running a sample in an MSDN ASP
tutorial:
Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Microsoft
Access Driver]General error Unable to open registry key 'Temporary
(volatile) Jet DSN for process 0xb88 Thread 0x9f4 DBC 0x2050064 ...more >>
asp login Posted by Detournay Kerckhaert at 4/9/2004 3:17:23 PM I'm trying to create a website login page/form that has a simple
UserName/Password feature. The page/form checks MS SQL Database Table to see
if the UserName/Password exists. If it exists, it sends the user to the page
depending on what UserName/Password they entered. I have a 'URL' field in
the...more >>
IIS problem Posted by Maarten at 4/9/2004 12:22:47 PM
Yesterday my ASP works fine in IIS (Xp Pro)
This morning i had a power power breakdown. After restart the same ASPages
works fine except non of the images want load in MSIE 6.0. After i copied
the path to the pictures in the adressebar the picture shows up in MSIE.
But when i run the ASP i...more >>
Date format change not working Posted by Sean at 4/9/2004 3:21:04 AM Im trying to change the date format entered into a textbox from dd/mm/yy to yyyy/mm/dd so as my stored procedure is run correclty. The date is entered in a textbox called date. I attemped to use the line:
newdate = year(lsDate) & "/" & month(lsDate) & "/" & Day(lsDate
in order to change the d...more >>
Field Maping Posted by Anand at 4/8/2004 6:33:18 PM Does anyone have an example of field mapping?
...more >>
Presenting Date & Time Info Posted by Bob The ASP Builder at 4/8/2004 5:33:43 AM In an Access 2000 Database I automatically in a table store the date
and time -information when a row has been created.The info is stored
in fields in a column named "Indate"
I have set the Datatype to "Date/time" and the standarvalue to "Now()"
- furthermore I have set the Format to "Short D...more >>
Change Date Format Posted by Stephen Cairns at 4/8/2004 3:36:03 AM I have a date being entered into a textbox in a dd/mm/yy format, however I need to be able to change this format to a yyyy/mm/dd in order to pass the date into a stored procedure and run some asp code. Does anyone know how to do this date format change in the background say on the onclick event of ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |