Archived Months
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


all groups > inetserver asp db > december 2003 > threads for december 29 - 31, 2003

Filter by week: 1 2 3 4 5

Free ASP resource!
Posted by Me at 12/31/2003 10:57:45 PM
Hi! could someone plz tell me where can i found some asp free resources. such as asp guestbook and forums ... Thanks in advance ...more >>

SQL Database in ASP
Posted by Robert Cohen at 12/31/2003 3:33:52 PM
Hello All, I don't know if this is the right group or not to discuss this issue = with, but I am hoping so. I have an SQL database and am trying to use = frontpage as my interface. I am able to query the database fine and = present the data on a webpage; however, I want a way to modify- ad...more >>

SQL Statement looping
Posted by PorkyJr at 12/31/2003 1:39:46 PM
Trying to pull a report from an access 2k database that grabs the top 5 records for each day in a range (inputed by user). Yes, I know that the * character is not a good idea, but I put it here for brevity. Here is my SQL Statement: LTQry = "SELECT TOP 5 * FROM History " & _ "W...more >>

Help with OLEDB connection string
Posted by Matt at 12/30/2003 4:51:50 PM
Hi, I'm following the below example in order to create a connection to my Access database. My question is, is it possible to include the username and password as part of the connection string? I've tried appending "UID=username;PWD=passsord" to the cst connection string, but I get a "Not a ...more >>

help me with crystal reports.
Posted by haode at 12/30/2003 4:37:54 PM
I'm in trouble with reporting data on web with crystal reports. for me it's not easy to find some sample codes(ASP). does anyone have some example asp codes? I use Windows 2k server and SQL server 2k. TIA. ...more >>

no records
Posted by Jen at 12/30/2003 2:52:20 PM
Hi, I am writing a jsp page to get data from db. <%@ Language=VBScript %> <!-- #include file="ConnString.asp" --> <html> <head> </head> <body> <% dim rsLook dim sSql dim arResults dim i Set objCon = server.createobject("adodb.connection") objCon.open strConnString sSql = ...more >>

Simple but complex report
Posted by AstrA at 12/30/2003 12:49:02 PM
Hi All Wondered if you could help. Basically I have 2 tables that contain all the data I want for my report, but I need to put it in a particular way and I need to display it in an ASP page so my queries got to be manual rather than an MS Excel/Query 'munge'. To be honest, the report itse...more >>

OLEDB connection string help
Posted by Gabriel at 12/30/2003 12:20:05 PM
I'm trying to connect to a SQL Server using dsn-less connection string such as "PROVIDER=SQLOLEDB;DATA SOURCE=SQLSERVER;UID=DOMAIN\username;PWD=password;DATABASE =myDB" I know it works with Standard SQL Server authentication but is it possible to use Windows authentication like in the exam...more >>



Storing Images in SQL Server - ASP storage and retrieve
Posted by Michael Walton at 12/30/2003 12:04:54 PM
I need some help, because I am utterly confused with how to do this. I have 2 things that I need to figure out, and could use some sample code or just some general direction: 1) I need to build an admin page that allows me to browse to the file that I want stored in SQL Server 2000 in an imag...more >>

search query doesn't work
Posted by m.krechting NO[at]SPAM chello.nl at 12/30/2003 9:07:28 AM
Hi ALL, I have made a record search form with several search options. However some of them work and others don't. The first four work but the last six don't. 'WeaponSearch Class_Initialize Event @2-0BECB200 Private Sub Class_Initialize() Visible = True Set Errors = N...more >>

Complex situation
Posted by Mike at 12/30/2003 7:34:29 AM
OK, here's the scenerio. One department here uses the same Access database (on a network) for various reasons, all different, but with the same data. Now, I've created a separate SQL Server db to house new applicants via a website. The SQL Server sits alone and cannot see any network...more >>

ASP - Server Not Found
Posted by Arthur E Oliver at 12/29/2003 8:42:42 PM
I am at my wits end. Could someone please help. I developed a web on a Win2000 Server\IIS machine and it worked perfectly on that machine. I have since bought a new computer and installed Win Server 2003. I then installed all my software from the other Win2000 Server computer. When I run my web ...more >>

how to display data in 3 columns by 4 rows format
Posted by addi_s NO[at]SPAM hotmail.com at 12/29/2003 8:21:12 PM
All, I will be eternally greatful if someone can provide snippet of code, URL or reference material that shows how to display data in a "n colums * n rows" format. I am new to ASP and have looked everywhere that I could, but I have not found an example where data can be formatted to be dis...more >>

get id number from sql table
Posted by shows NO[at]SPAM hillstax.org at 12/29/2003 12:55:59 PM
I have a asp page that updates a sql table. after the table receives the update a id number is auto generated. How do I pass that number to the second page. I was trying to use @@identity but I'm not sure how to use it or ever were. Do I call the @@identity on the second page? Please help...more >>

Transaction Error
Posted by Niel at 12/29/2003 9:44:18 AM
Hi, I am working on ASP 3.0 with MS SQL 2000. We have an online registration form where in once the information is submitted (along with credit card info.) the information is taken on another asp page where i have set the page level transaction (transaction = required) on. Once the infor...more >>

Connection from ASP Page to Oracle Fails
Posted by Brian at 12/29/2003 9:06:47 AM
I am trying to connect to our corporate Oracle database to query some data in an ASP page. My experience with ASP has always been with SQL Server and Access databases, but I figured I could get a connection string to work. I tried using the following connection string: "Driver={Microsoft OD...more >>

Function Problem
Posted by MyaTiX at 12/29/2003 5:00:07 AM
Hi, I have the following function below used to make a couple of calculations however as soon as I have two records the function calculation is wrong. EG: Record 1: tmprs(0) = 1 tmprs(1) = 100 tmprs(2) = 20 tmprs(3) = 25 Record 2: tmprs(0) = 1 tmprs(1) = 1000 tmprs(2) = 10 tmpr...more >>

Thanks for the help!
Posted by MyaTiX at 12/29/2003 1:50:35 AM
Hi Ray, Thanks for the help! I managed to sort it! ...more >>


DevelopmentNow Blog