Hi ! got another problem...can't seem to get enough of them =) i have a table in my database called 'Accounts', which contains a bunch of users, with ID, username, password etc. in my main admin-page menu, i klick 'edit user' and all users in the db-table are listed nicely in a table. i've made...more >>

Hi I would like sort table. The table is createobject method (open a function and use SAP connection) and the table not use recordset. is it possible sort table for example or how can i sort table columns. Thanks set objTable = myFunc.tables ("Sales") objTable.sortColumn="SalesID", Asc...more >>

I am in the process of re-writing an .ASP to replace some recordset processing with a DOM object, and performing a transformation to present the data. My initial objective was to clean up the code, and further separate the logic from the presentation. Is there also a performance benefi...more >>

Hi All: I have been asked to create an ezine which basically is a monthly newsletter in the form of html email. I was wondering if anybody can provide me with any direction on this or point me to any resources that deal with this subject. Thanks Terry ...more >>

Hi folks ! I finally got my login-page to run, but the thing is that it seems to live a life of its own. sometimes i can log in and sometimes not. the script should redirect me to diferent pages depending if i enter the username & password of an "admin" or a "user" and checkes one of them in th...more >>

I am receiving the following error: ADODB.Connection error '800a0046' Permission Denied Here is my connection string on my web page: <% Dim SurveyConnection Set SurveyConnection=Server.CreateObject ("ADODB.Connection") SurveyConnection.Open "Driver={SQL Server};SERVER=KAFB43b;UID=sa...more >>

I am new to ASP.NET and IIS web applications, but not to SQL databases. I can successfully build Windows apps using Visual Studio that use ADO. However, for Web Forms, I created data connection and sqladapter to my SQL Server - Northwind - which I dragged from Server Explorer. I generate a...more >>

Hi Everyone, The following code runs in less than one second when used in an ASP page but when used in Session_onStart() in global.asa, the first page in a new session is delayed by more than thirty seconds. The code seems to work - its just slooow. Why is this so and how do I fix it? Dim...more >>

Whats happend to the ASP groups over the last couple of days - seem to be 'spam'ed to all over the place - used to be reasonably immune I assume all these "check this correction patch......." stuff must be from a new virus, not seen one hitting newgroups before - since MS never sends patches b...more >>

Is their a way i can group a bunch of records by their 'Type' And Order these records within each group by their category. I am using Jet Sql "Access". This is what i have so far.. rs.Open "SELECT Seminar_Id,Seminar_Category,Seminar_Title,Seminar_Venue,Seminar_Type FROM seminar Group By S...more >>

The following is the code, can someone please help me with the syntax please in the first line please Conn.Execute "UPDATE tblRentalProperty SET " _ & "tblPropertyType = '" & tblPropertyType & "', " _ & "tblRooms ='" & tblRooms & "', " _ & "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _ & "t...more >>

hi, whne I used this code to delete record from MS access DB thru Radio Button I'm always got a balnk ID === <% ID = request("ID") MySQL2= "Delete from soon where ID = " & ID & "" 'conn.Execute(MySQL2) response.write(MySQL2) 'response.redirect("soon1.asp") %> === Any idea ? A. J. ...more >>

Could anybody tell me please what the "1,2" refers to in the last line of this code and where I can get a list of the parts to this '.open' argument? ~~~ set conn=server.createobject("ADODB.Connection") set rsuser=server.createobject("ADODB.Recordset") strMDBpath = Server.MapPath("dbname.md...more >>

Hi, I'm new to asp coding database, but have been working with Web Design and MS Access for quite a few years. I'm access a db and am useing the following code (1) and all is well. When I replace the sql string with the code at (2) I get an "error '80004005' Unspecified error /quotes/quot...more >>

I just built an asp page taking values from sql server and need the currency in £. this worked for about a week and now my currency has changed to $ how do I correct this. My system locale is set to £ Thanks ...more >>

The following ASP code yields the following run-time error, I want to know which approaches for adding records. Using "Insert Into" statement or AddNew method in recordset object?? As I mentioned in previous post, when I use "Insert Into" SQL statement, it yields "ADODB.Recordset error '800a0e78'...more >>

The following ASP code yields the following error, but actually the new record is stored in database. The same error happens when the application deletes a record, such as sqlStmt ="delete from test where username='2323'" Any ideas? Thanks! <% Dim objRS, sqlStmt Set objRS = Server.Crea...more >>

Hi All ISP has told me that I should be using OLEDB connections instead of ODBC to get better ASP > ADO > Access DB performance. After a visit to ConnectionStrings.com this OLEDB seemed straightforward enough with a DB with no password and then I tried it with DB that has a password ... wha...more >>

Hi, My problem with dates is as follows: The date is automatically placed in a readonly text field in the dd/mm/yy format, when the record is added, the result in the database is dd/mm/yy but the wrong way around e.g. Date = 26/09/03 On the database Date= 03/09/2026 How can I get the r...more >>

Hi everyone. I have just discovered how to display an image from a database in the browser....changing the contenttype to "image/jpeg" and then binarywriting the file. That's all well and good but let's say the picture is actually a photo of an employee and this exists in the database with ...more >>

Can I have a local (using PWS on Win98) ASP page access a database over the Internet? I have an MS-Access database on a Web site that is updated by visitors. I want to have a local ASP page open it to display its contents -- can I? The eventual goal is to update a different MS-Access databas...more >>

i am trying to build a page but am having dificulties. description of the page below what is the best way to aproach this? ----------------------------------------------- user selects an item from a list generated from the db this then opens a page with the details of the item on the...more >>

for win2k adv serv, iis5.0, vb6.0 this connection string works using the public ip address but not the domain name? "Driver={Microsoft Access Driver (*.mdb)};//111.222.333.444/drive/dir1/dir2/dir3/access.mdb;Uid=;Pwd=" are the uid and pwd for the db only or for general file access in the rel...more >>

...more >>

Hi all, Trying to figure out how to generate a subwindow with data based on field values from a main window. The ASP application is mostly written in VBSCRIPT. Wants to: 1. Create the subwindow, NOW accomplished by javascript connected with search-button 2. Get the values from the fields i...more >>

Unspecified error C:\INETPUB\WWWROOT\WELCOME\../common/adovbs.inc, line 4 And line 4 is this Connect.Open "database" Its happening across the board too, on each database on this server. Same errors, but connecting to different databases. Any ideas? -- David Lozzi Associated Busine...more >>

I am wanting to check the existance of a table in my informix db before I query it, since if I query a table that does not exist, it'll blow up on me. Anyone know the syntax on this? My code currently looks like this: Set rsMachineOwner = Server.CreateObject("ADODB.Recordset") MOQ = "SELECT ...more >>

I notice that performance drops when using linked tables in two Access 97 databases instead of all tables in one database. I.e. the ASP page takes longer to load. Can anybody confirm this is normal? ...more >>

Ok, appologies and thanks in advance for this, but it can't just be me. Why can't I seem to get the simple examples in Microsoft's own ASP.Net book to work? Here's the scoop: I have VS.Net 2003 Professional installed. I installed MSDE from Microsoft's site, setting the sa password as part o...more >>

Ok, this probably seems like a strange post but I think Ive developed the ultimate solution to the paging (say, 10 records at a time) through a large recordset using ASP/SQL. The reason Im posting is so anyone can suggest any flaws with it, maybe someone out there has tried this method before. ...more >>

HI I use ASP with a Access2000 MDB as database, my asp has a form, not all the fileds must fill. When the form process input to Access, the Access do not allow the field is ''(null) How can I fix this ? Thanks Kelvin ...more >>

Im working on a small sales lead tracking application. One of the features requested by my client is to sort records by status. There are 6 different status values to which Ive assigned numbers - 1 thru 6. I can sort simply by ascending or descending but is it possible to sort in different ...more >>

Hi, I access SQL Server data through ASP page, but all extended characters (Turkish specific characters) display corrupted. The database language is Turkish and SQL Server 2000 runs on Windows 2003 Server Turkish. Have any idea how I can display the data correctly? Thanks in advance... ...more >>

I am very new to ASP/DB, so please bear with me. In my "add data" form, through checkboxes I am entering "Yes" values. (no "No" values, those are blank) Each checkbox equals a coloumn in my DB, if checked it places "Yes" as a value, if left unchecked it has no value. ( I know...I did not us...more >>

Can someone explain to me what the following error means: Active Server Pages error 'ASP 0240' Script Engine Exception name of folder and file from which the error came A Script Engine threw expection in 'C0000005' in 'IActiveScriptParse::ParseScriptText()' from 'CActiveScriptEngine::AddScri...more >>

Hi there, I have recently changed the connection string on a site that was working perfectly. I used an OLE DB connection with this code: var path = Server.MapPath("/bddir"); var MM_ss_bd_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" + path + "\\dbfile.mdb"; and changed it to...more >>

Hi, I am getting following error Microsoft OLE DB Provider for SQL Server error '80040e07' Operand type clash: nchar is incompatible with image When using .... Set ThumbParam = Server.CreateObject("adodb.parameter") ThumbParam.Name = "image_thumb" ThumbParam.Type = 128 ' adBinary Thum...more >>

Hello all, Thanks to the advice of Manohar Kamath, Bob Barrows, Curt, Chris and others, I restructured my database for "normalization" where I have a main table with a couple columns and then in the columns I've got ID numbers of items in other tables. The idea makes sense. However, when I ...more >>

Hi, i have a (little) Problem with connecting to the LDAP Server. I need to get a list of all Users and there LoginNames in the companie's activedirectory. The following code works in an normal vbs script: Set oContainer=GetObject("LDAP://OU=sar- dgf,DC=sar,DC=intern") But when I u...more >>

After I moved my ASP pages and an Access database from PWS in NT 4.0 to IIS 5.0 in XP Pro, I can't edit data in the database through the ASP web application. The error type is... Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. However, the datab...more >>

Using MSSQL Server. Is there any way I can force a select statement to return a result set? I have a query for which the column and table names are user specified. It's okay for the user to get no results, but I still need to know all the column names. The way I've been finding the column names...more >>

I need to provide someone access to an SQL database over the Internet. Would I better off just setting up a username/password for them to access the database directly? Or, should I have them access the data as XML through HTTP? In either case, I'm going to have to provide them with sample...more >>

Hi, I need some help. I have a on button click event that goes through a survey and reads the items they choose and then updates the current record. The problem I'm having is that nothing actually is written back to the database even though it runs the command even though an append query work...more >>

I have a problem, which I do not know if it can be done: I have a SQL statement, which has: (USER.first_name = UND.processor) OK, the problem is that the fieled 'processor' looks like: lastname, firstname I need to break out the just firstname in my sql statement. Please help???? T...more >>

Hello, this is the query : select IdBC, DateBc, montantHT From Table_BC, Table_LignesC where Table_BC.IdBC=Table_LignesC.IdBC order by Table_BC.IdBC COMPUTE SUM(montantHT) by Table_BC.IdBC I can acces to my selection (IdBC, DateBc, montantHT) But how can i reach the famous sum ? I've ...more >>

This parameter that is greater than 128 is part of a dynamic SQL statement. How do I get around this limit?? thanks, AJ...more >>

Hello, I am wodering for days now , which method is best when it comes to using common functions like database connectivity ? Also where to keep my business logic ? which is faster/better, using an inc file or using DDLs written in VB ? can anyone help me in this regard ? T...more >>

<% dim ORIG dim MSG dim KEYWORD strNum = request.QueryString("ORIG") ''get mobile number from VisualGSM strKey = lcase(request.QueryString("KEYWORD")) ''gets Keyword from VisualGSM strLongMsg = lcase(request.QueryString("MSG")) ''gets SMS message from VisualGSM strLongMsg = replace(strLongMsg...more >>

Good Evening All. I upgraded to SP4. Immediately I noticed that my ASP sql 2000 database application was only returning small amounts of data. Larger amounts of data (50 records) would time out. I removed SP4 and went back to SP3. Still issues. I re-applied SP3, still issues. I upd...more >>

MS Partner this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to continue keeping ...more >>