Webmaster Forum / ASP / Database Access / February 2004

I may be posting to completely the wrong newsgroup, but I need to ask.
Basically I have created a shop cart that displays the current running total
in the header of my site so that it appears at the top of every page.
This value is updated when the customer adds to the basket, but ...

I have to maintain a piece of code. One of the things that is done is a
create procedure:
CREATE PROCEDURE PROC_22_
RETURNS(IEXTENSION INTEGER,CNTICALLINGNBR INTEGER,CNTIDIALEDNBR

I am experiencing a problem in developing an ASP.NET application which
will run in tandem with an existing "classic" ASP app. Some users of
the ASP app are entering text in their native languages (japanese and
chinese) using native code pages (eg Big5 and shift_jis). The

Doesn anyyone know the proper lines of ASP code to sucessfully retrieve a pdf file from SQL server.  Everytime I run my code I get gibberish all over the screen.  I would like it to prompt me to save the file to disk
Thanks
-Jeff

Im pulling out of my dbase a record nuber however when I response.write it I
get strange results:
Ie:
r = RS1("recid")

I have 3 tables with an ip column that i would like to get into 1 coloumn
with an query
Table 1 columns
ID, IP

I have some experince with ASP and databases in General, however Stored
Procedures are new.
I need to call a stored procedure and have bene told I need to to the
following:

what has happenened to the 2004 posts

     Date: 02/26/2004 01:00PM PST
     Here is the code.
     '------------------------------------------------'
     '-  Gets Managers details such as name & email  -'

If a host suggests poor performance is possibly due to 'open database'
connections and Im fairly sure that Ive closed everything - what is an easy
method to test for connections that havent been cleaned up? (assuming 1000's
of pages)

Ive cleaned the code up a wee bit to see if it makes it easier to spot were i've went wrong.  Hope this helps, thanks agai
Sea
<
Option Explicit

I have the following:
sub readcsv
    dim csv_dsn, csv_filename, csv_oconn, csv_rs, csv_sql, itm
    csv_dsn = "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _

I am very knew to asp and Im having problems returning the results from my stored procedure in the browser.  The asp code and the html form code is below.  Can anyone guide me as to where I've went wrong. Im not sure if I've referred to the asp code in the right place, and I ...

I have a query which produces different results in the Access query builder
and in an ASP page (via ADO)
An example of the query is:
----------------------------------------------------------

I have inherited the following code from an existing system login asp page in my company.  I am connecting to the same database and have been told to use the same connection code from below because it works fine.  Im unsure exactly which code to keep and which code to extract.  A ...