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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|