I am trying to build a simple page in classic ASP code that queries a SQL table based on user input. I have sample code, but it isn't quite what I want... On page init I don't want a listing of all the records for LastName in Authors (Pubs), but it is listing them. I can move the list to ...more >>

Hi I have 2 tables, one called SCR and one called userdetails SCR table contains details of a change Userdetails contains information about a user All the data is entered via asp on our intranet One of the SCR fields is Username One of the Userdetails fields is also Username Both tabl...more >>

I have a comment block on a form on my page. I want to store the value of that form in a field in my database. Everything works fine until the user types an apostrophe in their comments. Such as "don't do this". This appostrophe messes up my sql statement to insert the the value in the...more >>

I was hoping to get some opinions on how best to approach a problem: A customer will browse our web site selecting .ppt presentations he/she wishes to download. In the background, these presentations are merged into ONE presentation, which is then downloaded by the customer. My employer is c...more >>

It never fails, if I install patches or just reboot, all of my ASP pages that call anythin from an Access will simple time out. Page that call the same things from other databases, like Interbase work fine. Any help would be appreciated. ...more >>

Hey folks, hope you all had a good weekend. Here's this mornings dilema for me. I have my query, which when ran in Query Analyzer, gives me back nice neat little rows with the percentages. "SELECT fit, count(*) * 100.00/ (select count (*) from internal) as [Percent] FROM internal GROUP by f...more >>

Hi Everyone, I am trying to figure why the data of an Access database changed when displayed in a web-based administrative tool. The column data type is Memo, since text can't hold the length of the data. The data itself is a code of a page (this is sort of small content mangement system.) ...more >>

I am not sure what is goint on. Here's my code inWeekStart = "11" inWeekEnd = "14" Compyear = "2003" Dim rsSQL, strSQL, cmSQL dim objReportBuild set objReportBuild = server.CreateObject("Area_Sales.cZoneMnthReport") set rsSQL = objReportBuild.ZoneMnthReport(inWeekStart, inWeekEnd, Compy...more >>

Hi again ! Thanks for all help ! my scripts are now running perfectly. just one thing left i want to take care of. if i try to insert a record in the database that allready exists, i get an error message, which ofcourse is natural since duplicates are not soposed to exist in a relational db. th...more >>

ASP pages that query SQL database (not on the IIS box) run slower as time passes but once the IIS is restarted they start running faster. any solutions???...more >>

Hi, I'm using an access database and found following problem : I have a table X with 2 records : record 1 & record 2. I execute following procedure with 2 steps : 1. The procedure deletes records 1 : connection.execute "delete from X record 1" 2. The procedure adds record 1 again using ...more >>

I am trying to display a PDF from SQL. All I am getting=20 is garbage that looks like this: %PDF-1.3 %=E2=E3=CF=D3 37 0 obj << /Linearized 1 /O 39 /H [ 1000=20 378 ] /L 168312 /E 75831 /N 4 /T 167454 >> endobj xref 37=20 28 0000000016 00000 n 0000000907 00000 n 000000 My code is as follows, ...more >>

One of my developers is working on a .Net web app that has a wee bit o legacy code in Page_Onload: .... Dim MySelect as String = "SELECT User FROM DUAL" Dim rs as ADODB.RecordSet rs.Open(MySelect,Conn) rs.MoveFirst UNam = rs.Fields("User").Value .... This code gets invoked separately fr...more >>

Microsoft OLE DB Provider for ODBC Drivers error '80040e57' do you know what is this error ? thx ...more >>

Earlier on this board, I got a solution from Ray (thanks again) on how to run a querry to see if a table exists and it works fine in Access. But when I try to run it through an ASP page I get this permissions error: "Record(s) cannot be read; no read permission on 'MSysObjects'." I kn...more >>

hi ! had to come right back... this time i'm trying to do a multiple insert. in my admin website i want to add users to a specific project. i klick that option and all projects are listed nicely. i chose project, then i get all available users listed with a checkbox in front of each one. i che...more >>

in an ASP page i loop through my record set and i need to put some records in an array but i can't figure it out, can u please help me ? <% i = 1 Do While Not objpaginaRS.EOF ArrayPages(i) = objpaginaRS("paginaid") i= i+ 1 objpaginaRS.MoveNext Loop %> <% ShowArrayInTable(Arr...more >>

Hi, I'm using an Access 2000 database with my ASP application, and the db has a link to a text file. Previously, the text file and the db were in the same folder and everything worked fine. But after I moved the text file into a subfolder (in the same folder where the db is located), ...more >>

I'm experiencing the following error message: Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'cDbl' /auction/auction_biditem.asp, line 19 my code: <% else 'Login Check p_auction_id = request.form("p_auction_id") p_bid = cDbl(Request.form("p_bid")) se...more >>

Hi, I have an asp page which is called with posted data from a previous asp page containing a form, one of the posted fields in SvrName which is from a multiple select element and contains a comma delim list of server names. I then split this list into the array of servers. I then want to...more >>

Bump ...more >>

I need to insert some form values into a database, I am able to do so using a custom query in the DRW in Frontpage ( 2002 ). ( Where form is page1.asp sending results to page2.asp which actually does the insert ) But what I really want to do ( for additional flexibility ) is to do the ins...more >>

I am trying to get this code going but always the following error message: Error Type: Microsoft VBScript compilation (0x800A0401) Expected end of statement /hbgary/webdev/functions/functions.asp, line 367, column 64 rs = "SELECT Body.G1, Body.G2, Body.content FROM Body Where G1="1" And G2=...more >>

How do I set up my SQL Server database so I can call tables, views, etc using just their names in my script instead of [myDomain\myLogin].tblName? When I created tables using the sa account this was not an issue, but my administrator will not let me use the sa account any more. What can ...more >>

MS Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to conti...more >>

Greetings. I am trying to connect to both an oracle db and an access db. I know this is possible but my problem I think stems from the fact that I am using a recordset object as a parameter for my access query. Ex. \\adodb connections\\ set rs = "oracle connection" do while not rs.eof ...more >>

Microsoft User this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to maintain the security of your computer from these vulnera...more >>

I am trying to do a search within query results: My first search executes fine, but my second search uses the WHERE parameters of my first search. For Instance if my first search was "Keyword: stein" (which company manufactures them), and I would like to see which of those companies would b...more >>

My client moved to a new server now my asp code will not update his Access mdb. There are no error messages. ...more >>

I have a database that I'm pulling out to an ASP page... I am looking for a wildcard string in a field. If the wildcard is found I just want ONE object (the one with the latest date) with the same name found. EXAMPLE: Table: DataVars Name QCode Alt TimeStamp John Q1324 HHH ...more >>

Hello In my ASP page I am trying to ascertain whether a randomly generated ID = starts with certain characters that are not allowed or has been used = before. When the SQL statement for latter is executed I get: Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expi...more >>

Hi ! back again... got this problem with multiple delete with checkboxes. when i click the 'Delete user' link i get all users in the db listed nicely in a table with a checkbox in front of each one. i then want to click as many as i want and delete them from the database. this last procedure i...more >>

I need to run a querry from an asp page only if a certain table exists in the data base. Is there any kind of method that can look at the database (Access) and tell me whether or not a certain table exists before running the querry? Thanks...more >>

Hi, I am trying to build a web based system using asp.net and sql server. I would like to know on how to dynamically create a webpage from a webpage, and at the same time dynamically create the database in the back end. For instance, there is a maintenance page in the client side where us...more >>