all groups > inetserver asp db > july 2003 > threads for july 29 - 31, 2003
Filter by week: 1 2 3 4 5
Need Help in DALLAS Customizing ASP application
Posted by martino rivaplata at 7/31/2003 5:45:16 PM
Hello,
I am trying to customize an existing ASP application. This
ASP already contains drop down list boxes containing
dimension members from an Analysis Services Database and
retrieves data into excel and publish it to the Web via
IIS.
What I need is to add to this existing ASP applic... more >>
IIS hangs when openning a connection w MSDAORA provider (0x80040e22)
Posted by Martin Plechsmid at 7/31/2003 3:58:06 PM
Hello.
The script below opens an ADO connection to an Oracle DB. When run from the
command line (cscript), it works. But when run from an ASP page, the IIS
hangs during the "oracon.Open()" command (details below).
I've done further investigation (see below), but am unable to find a
solution. ... more >>
Displaying one field in two <td>s per <tr>
Posted by howard.brock NO[at]SPAM virgin.net at 7/31/2003 12:24:24 PM
Hi,
I'm trying to display all the records in one database field in a table
with 2 <td>s per <TR> but don't know how to do it (or even if it can
be done).
e.g. <tr><td> fieldA.record 1 </td><td> fieldA.record2 </td></tr>
<tr><td> fieldA.record 3 </td><td> fieldA.record4 </td></tr>
At... more >>
Request.Form is blank??
Posted by b_naick NO[at]SPAM yahoo.ca at 7/31/2003 11:46:27 AM
I am experiencing a strange problem.. I've got a basic form with
METHOD = POST and ACTION = "saveInput.asp". The form has over approx
100 fields.
In saveInput.asp, I am able to sucessully write out the input values..
For example, Request.Form("userName") returns the appropriate value.
Howev... more >>
Using an asp page to return a sql query
Posted by cswartz NO[at]SPAM stromberg.com at 7/31/2003 10:05:43 AM
I know that there must be a way to do this, but in my limited
knowledge I am stuck.
I am using 2 tables
1. "BTstatus"
BugIndex
Date Entered
Company
Technician
Developer
PROGRAM
Status
PRIORITY
2."noc"
Bugindex
# of calls
Description
Bug index is the common key
I would like ... more >>
Access denied when creating Access application object
Posted by Bill Murphy at 7/31/2003 4:02:29 AM
In an ASP file I am running the following in VBScript in order to extract
data from an Access 2002 MDB file which is physically located in the virtual
directory in PWS along with the ASP file:
dim objAccess
set objAccess = Server.CreateObject("Access.Application")
When the second li... more >>
INSERT or UPDATE
Posted by Bingo at 7/30/2003 4:12:20 PM
Hi there.
I have this problem here :
I want to insert a record if it does not already exist, or to update it if
it does (based on index of course).
Can I do this with a simple SQL query?
Thanks!
Bingo
... more >>
Getting Return Value of Stored Procedure
Posted by Vipul Pathak at 7/30/2003 1:01:29 PM
Hello Friends !
I have the Following Code, that Executes a Stored Procedure and Attempt to
read a Returned Integer Value from the StoredProc.
But It gives Error ...
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
recordset not writing to page
Posted by Kevin at 7/30/2003 12:42:35 PM
Hi,
Access2000 db, w2k, iis5
I am trying to write a couple recordsets to a page and the page doesn't
throw an error, but it doesn't actualy write the data either -- just the
intervening html. Can anyone spot my error -- I've been looking at it over
an hour now, changing this and that -- and... more >>
Replace function
Posted by Lamine Darbouche at 7/30/2003 11:09:39 AM
Please help,
I want to replace a string within field in a table with a nother string.
I am using the replace function but I am doing something wrong.
my code is:
UPDATE authors SET au_lname = Replace(au_lname,'cheryl','frannk')
What am I doing wrong?
Regards
Lamine
... more >>
How to write an image to db
Posted by Ralf Pelzl at 7/30/2003 9:53:30 AM
Hello,
how do i write an image from a file source to a database on sql-server via
asp ? e.g:
I try to store file c:\temp\test.jpg in the field "picture" in a recordset.
The field "picture" is datatype image. How to do this ?
... more >>
who can help me... my first asp project...
Posted by netje at 7/30/2003 9:38:10 AM
Hi,
I thought i had my asp script working....
It is a news script with a access db...
At this point i can't seem to be able to edit, delete records anymore... I
had this running, but now... for a reason i can't seem to find.. and i have
seached.. more than once!
who can hel... more >>
Running SQL DTS packages via ASP.NET
Posted by Carl Reid at 7/30/2003 6:12:40 AM
I have the above working on a machine that is both the SQL
server and the IIS webserver. My DTS package creates a
spreadsheet and this is all OK. The ASPNET account has
been given rights to run the DTS Package and also to
create the spreadsheet. A RCW has been created and
registered in the... more >>
Session Variables
Posted by tmurray0539 at 7/30/2003 2:53:57 AM
Hi all:
Does the use of Session variables create cookies on the client's
computer? I was told that this is the case but I am not in agreement. I
would like to be enlightened on the subject.
Thanks
Terry
... more >>
Wondering for a better web db solution/software/language?
Posted by Michael at 7/29/2003 4:06:49 PM
Hi, All
Can anyone advice me which kind of software if better to utilize to
development an web database application?
I have more than 20 tables, many user interface/forms, reports, controll.
It's hardly to design/code with HTML +ASP only, I am wondering if there is
any software can support no... more >>
Load Empty Recordset
Posted by Gary D. Rezek at 7/29/2003 3:23:29 PM
Hi All,
Is it possible to load an empty recordset into a page for the purpose of setting up the page for a new record?
The following code
(there is also a Case "edit" and a Case "delete" which work fine)
CASE "add"
strSQL = "SELECT * "
strSQL = strSQL & "FROM tblPatents " strSQL = strSQL & "WH... more >>
Adding a new column in Access
Posted by Peter Richards at 7/29/2003 2:31:04 PM
Hi,
Using the following ASP code:
<%
UpdateDB("ALTER TABLE tblConfig ADD SIMVersion varchar(10) NULL AFTER
Version" )
' Subroutine to update the database and check for any errors that
occured
Sub UpdateDB(strSQLCommand)
If Not Application("Debug") Then
On Error... more >>
Appication name in SQL Server connection string
Posted by Ray at <%=sLocation% at 7/29/2003 11:37:17 AM
Hi group,
Does anyone know how I can pass an application name in my connection string
and have it be recognized by SQL Server? I have this string:
Driver={SQL
Server};Server=TheServerName;Database=TheDatabase;Uid=TheUsername;Pwd=ThePas
sword;Application Name=RaysApp;
When I execute quer... more >>
|