Hi All Somebody kindly sent me a routine to do this sometime ago, but for the life of me I can't work out how it works and would prefer to use a simpler method so that I can resolve any future issues with it. Basically I have an array populated from a recordset getrows and I want to crea...more >>

We are trying to connect to an Oracle database using ASP w/jscript and we can't get any response from the server, the browser just hangs. Any suggestions on how to test the connection or any connection information please?...more >>

Dear Sir/Madam, I am working on a web site which talks to a sql server in the backend. I need to make the web page searchable on non-english characters. So on the main page you can type non-english characters in a textbox and then click on "Submit" button. On the next page, I will display t...more >>

The following routine is part of a custom VBscript class in my = webapplication: Public Sub wsAddColumnIndex(p_sTable, p_sColumn, p_bUnique) Dim l_oIndex Set l_oIndex =3D Server.Createobject("ADOX.Index") wsFeedback("  Creating index On Column: " & p_sColumn) With l...more >>

When I call my ASP script to connect to my database, to return a series of records, does the server cache the results and dump the series of records to the screen all at the sametime? or does the server display each record on the screen when it has been caught? Basically, i want to know if th...more >>

Hi, I was/am having a problem with a web hosting company (verio.com) running Windows Server 2003. The problem is as follows: The site I am working on (http://www.codebot.org) uses active server pages to loaded up various rss feeds and parse them into pretty response documents. This works g...more >>

I have an application that has worked fine for more than 2 years. Suddenly the users and I get an error message when trying to open the MySql database for writing. The web host says that I may have a too complicated script or anything else. So far no help from them. The page stops and shows "O...more >>

Hi there, Could you point me to a good resource for creating my data access layer? I have my database, I have me front end, but I want a nice layer between them so I can just call functions in my code behind to return me a list etc or the contacts of my page. I'm coding system to log contr...more >>

Here we go: IIS 6.0, win2k3, using Classic ASP and the Microsoft client for Oracle connecting to Oracle 9.2.0.7 (latest patch). The problems started appearing 2 days after the Oracle server was upgraded. 2 of our sites with Huge, nested, multi-table queries started having problems insert...more >>

Within a block of programming to call a adCmdStoredProc through the ADODB.Command object (appending parameters, etc), can the recordeset be retrieved with set rs = adoCmd.execute as well as output parameters with myoutparameter = .Parameters("@myoutparameter").Value i...more >>

With ASP can I query an XML file for a record, just like I would a database table and fill the data values into variables? I have a product list in XML and want to fill a web template with individual product data. If the XML is structured like this: <product id="productid" name="Product Na...more >>

Guys, I really need help with this. I need to creat a login page for the website. Its an existing site that connects to SQL 7 with a local user in the database called 'maya'. It was written by a former employee I want to be able to creat a table(called user) that has username & passwor...more >>

Hello dex members, you've been great help to me ,and i'm hopeing to find the answer to my problem here . i'm creating this php loop to build a site map each level of this loop have font but when i run this code it only reads the font size and doen't read the color.this is the code please re...more >>

In my database i have a table that contains topics and it is related to another table which contains subtopics. What i have to do is delete a record in the topics but i allso have to delete the related records in the sub topics (as they are related). Is there a easier way to do this then havin...more >>

Hi i have a page that pulls information from a database it has around 80 records each day its run, the problem is that the view it uses is built fdrom many smaller views which use a lot of outer joins, so the search takes approx 30 secs a go. I have coded the ability to sort on column heading...more >>

Hey All, I am very early in the development of the Database and the ASP page and looking for the opinions of the Gurus for an approach that will give me the best page performances. I am building a form which will have several "Yes/No/Not Applicable" questions. The page will send the data...more >>

Hi, is there any way of passing a javascript variable over to a asp variable so i can write it to my database. Thanks...more >>

I'm storing a calculation in a variable and I want to then take that variable and update the db right after it is calculated. I can get all 172 records to show the overall calculation on the page, but not in the db. I'm not having any success, it keeps all of the db records at .000 Below ...more >>

ARRRRRRRGGGGGHHHHH!! Please can you help, I'm going round the bend with this. I have a simple and small table called STOCKCATS, which I need to query to get back a dataset in a particular order, but although it looks simple I can't get it to work. My table schema plus sample data to see the...more >>

Ok, so I am learning ASP by just piecing stuff together and learning from what I can find online. I have a SQL command set in a variable called strSqlCommand. I also have something setup like this: Set db = Server.CreateObject("ADODB.Connection") Then I have a line in my script like this: se...more >>

I'm trying to put together a little sql server asp project first on my pwn machine under IIS, then on a clients machine. I'm using the following connect string: Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={SQL Server};SERVER=computer;DATABASE=thedatabasename;UID=use...more >>

hello guies , I'm facing this problem ,i'm using front page to creat my web site . and i tried to include a file in all the pages my site so that i can change one page to effect other pages without the need to edit every page separatly. but when i updated this single page it did't effect the...more >>

I see a lot of posts on this topic in a lot of different groups that all seem to give the "standard" approach of appending a unique identifier to the end of the ID/Name string. Example:- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <form id="...more >>

Hi all: We have a web site set up where we can enter data into a database, then display it in a web page. The table includes a fields named ptsID, team, points, totPoints, and tourn. The form we are using to enter data includes a name field, a tourn field, and a pts field. When submitte...more >>

hi everyone: i have an asp page where i have to read an excel file and upload a worksheet named "Tarifa" to a table in a sql server database. the problem is that sends me this error: Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC Excel Driver] The Micr...more >>

Hi folks. I need advice. 2 options, which do you think is the better option to display/retrieve/report on the data. Keep in mind reporting (Crystal), SQL Performance, VB Code, usability, architecture. Case 1: On a web page I would like to render a dropdown list <single-select>. Eg: Yes...more >>

I'm getting an ID number from a list of teams. Then I have a table with 4 fields: id, awayteam, hometeam, result. When I run my loop, it seems like I'm losing the teamid field for some reason. The part with the IF statment always defaults to the ELSE. Any suggestions? TIA teamid ...more >>

I think this is a fairly basic question and the frustrating thing is I've figured it out before but it's been a few years... I'm using IIS and ASP to interact with an Access database. I can successfully open a table and display records. However when I try and add a new record I get an error "...more >>

Hello, I think I saw an aspfaq about this but I cannot find it. How do I fix this so I get rid of the nested sql statements? set conn = server.CreateObject ("ADODB.Connection") conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=\\brink-premfs1\sites\[deleted];" & _ "P...more >>

We have moved an Internet and Intranet site over to our IIS 6 MS Small Business Server 2003. The Internet site works fine, but was done by a company recently. The Intranet site is older and we're having problems from the get go. The first thing I've hit a problem with, I cannot seem to track d...more >>

This is a copy of a message I previously posted in a Microsoft Access = Newsgroup, but it was suggested to me that my problem is ASP related and = not Access, and hence I'm posting in this newsgroup now instead. Hi everyone, I've got quite a specific query that I'm trying to resolve with = Mi...more >>

Hello, Here's my code: <% Randomize() randNum = (CInt(1000 * Rnd) + 1) * -1 set conn = server.CreateObject ("ADODB.Connection") conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=\\brink-premfs1\sites\[deleted];" & _ "Persist Security Info=False" sql ...more >>

Hi, We have a ASP/VBscript webapplication which runs without problems on = lots of webservers.=20 However, recently we installed the application on a shared hosting = account for one of our clients and we've had nothing but trouble with = it. Currently we're having some vague problems agai...more >>

Hi All Wondered if you could help me with the below query. I have 1 simple table called STOCKCATS that consists of 2 fields. These fields are called CATID and LEVEL. The contents of this table are as follows: CATID LEVEL cat01 <nothing> cat02 <nothing> cat03 ca...more >>

I have a table of persons that have a Personal id (Not auto Number) which is a Primary key. When i do a insert i have to check if it allready exists in the table. I do this by by doing a select of that Personal id and if its not there then i insert it. Is there a way to do that in one step, s...more >>

Ok...been working with ASP for a while and something that has always stumped me: My SQL statement is like so: SELECT * FROM tutorSessions INNER JOIN tutors On tutorSessions.provider_id = tutors.provider_id INNER JOIN students ON tutorSessions.student_id = students.id Now, in my tutors ta...more >>

I would like to have a stored procedure that returns the maxium value given the value of two input parameters. I have written the following code: CREATE PROCEDURE ProcMaxResponse @MemberNumber int, @Action nvarchar(80), @NextNumber int OUT AS SELECT MAX(fldResponse) AS fldResponse FROM tblP...more >>

When passing a large block of text to an MS SQL Stored procedure using teh command object and the parameters collection, what value should I use for the size? The field in the SQL table is defined as ntext. When the page was originally written the authors used ado recordset to populate the ...more >>

Hello I have a very quick question... can someone tell me what I need to add to my select statements to prevent them from locking any records. I have a busy website where information is viewed frequently and updated infrequently. Most lists etc. are cached in arrays within the Application ...more >>