I want to include in a web page a statement something like: "The above data was last modified on nn/nn/nnnn" Using MSAccess I see that on the Tables window and using the 'Details' icon or the 'properties' icon for the table in question there is a modified date recorded. Can this date be e...more >>

I have a JS ajax function that calls an ASP page every minute to check whether a record is free for editing. It is on a PW protected site with a 1 hour timeout. For some reason, when the browser is left open & unused, the session is not timing out. I'm presuming the ajax call refreshes the s...more >>

Hi, I have a connection string defined in a global.asa file.. Am I referencing this correctly from this script? the connection string is defined as application("bureaudb") <% Dim strFullname, strUsername, strPassword, strImportdirectory, strExportdirectory, strVerifypword Dim adoCo...more >>

how is it possible to show error messages in regards to connection strings?...more >>

i have a memo field in an access database. the ASP page enters data to this field just fine.... however the following test (dont ask): Hello Charlie, you have no idea who I am but I thought you should know that your wife has been spending your mortgage money on things other than paying the...more >>

if i have an ASP page that does INSERT's and SELECT's from an access database, what happens if more than 1 web user hits the db at the same time? can it handle it ok or do i have to do something in my code? ...more >>

I have an ASP file (shown below) which I call from an HTM page to query a database table. It works correctly if I pass it the correct connection string. I am trying to make it fail with a proper error message if I change the UserID value in my connection string to a non-existing user (as an ...more >>

I am well-versed in Windows Forms but am new to Web Forms with ASP.NET. I want to create a simple application that loads all rows of a SQLServer table into a DataGrid, then allow the user to filter the rows on-the-fly via entry in a TextBox. I have done this in a WinForm application by ...more >>

We're using SQL-Server2000 as follows... There is a form at this asp-application where we enter a word with .cz-chars like this: 'Ohřvače'. All this form, as well as other settings are set to UTF-8. Output is ok, even in the sql-string we can see the word written correctly, but in database,...more >>

Hello: I have a SQL question. If this is the improper board to post this question on, please let me know where you would suggest I post it. I have a SALES table with the following schema and structure. ID Status Date -- ------ ---- 1 Open 1-1-2000 2 ...more >>

hi everyone. i have the following code that pulls a random record from an access database: Randomize() randNum = CInt((oRS.RecordCount - 1) * Rnd) oRS.Move randNum Response.Write(oRS("FIELD1") ) this works fine. it opens a recordset, gets a count of numrecords, then moves to a random re...more >>

I hate to admit it, but I have never realy used any debugging (not sure how to actully do it), and now I need to figure out how. I have a 5MB access db that I am doing simple stuff with. it's just a customer db that I am displaying by a 'date' field. All has been working well for quite some t...more >>

I have a Column in the Table named EMAIL which containd all the email addresses. Now I want to create mailto links for the entries of this column. I used something like this inside the Do while Not objRs.EOF loop. Response.write "<A HREF = 'mailto:" & objrs("EMAIL") & "'>" & objrs("EMAIL") ...more >>

My web server is running Win2k3 server with IIS 6.0 and all service packs installed. the database is on a Windows 2000 Adv. Server machine running SQL 2000 and all updates installed. Everything works properly but every 2-6 hours, the web server will begin to give database connection errors an...more >>

have an ASP page that generates a random quote from an access db. i need to include a button that says "next" and when clicked a new quote should be displayed. right now theres just a simple <a href> tag that points to the same page. this reloads the page and displays a new quote. but there ...more >>

Hello all I am looking for a recommenation on a Database access method (for MS SQL, MSDE), any white paper, some infomation or even some code snipplets on how to read and write to MS SQL in a pure HTML environment. Thanks in advance, George From http://www.developmentnow.com/g/61_0_0_0_0_...more >>

This is a real strange problem. I have some asp code (javascript) that sends a simple update sql command to mysql 5. my sql is this UPDATE Users SET YouGotMail = -1 WHERE pas_User = 'Clive' and when it's sent to the database this is the error Error Type: Microsoft OLE DB Provider for ODB...more >>

Hello All, Can anyone here suggest me a solution to solve my follwoing problem? 1) I got a .aspx page and on that page i got a combo box and a command button. Combo box displays records from the database. I wanted to generate a report which is based on the record that user selects from t...more >>

i wish to update a record by clicking a button without saving in a popup window. Can i do it by asp, vbs or javascript? Thanks a lot. tony ...more >>

I've just recently gotten into website design. I've got a website useing .asp pages, and currently one page is pulling in information from a database to display on the page. However I run into a problem where, if I have Access open, to say add more data to a table, or add new tables/forms/etc....more >>

2 issues. The second one came up trying to solve the first. First - On my local machine XP Pro SP2 IIS6 I have 2 ASP pages connecting to an Access 2000 DB, using DSN-less ODBC (I know - but that's the second problem). The structure looks like root subweb db roster meetin...more >>

Hi All, I have the following query: SELECT ID, First(Company_Name) AS Company, First([level]) AS pkgLevel, First(QueryNbr) AS QueryN FROM CompaniesByName GROUP BY ID What i need to do is add an order by clause! Essentially i need to order by the 4 & 2 columns ASC. I do...more >>

Hi all, I am (using ASP.net 2.0 in Visual Web developer 2005 Express Edit) trying to set up an asp front end to a music DB which has 2 main tables: 1) MUSIC - containing music release information (eg label, artist, name, date reviewed) 2) ISSUES - containing 3 columns - 1) a list of issue...more >>

In a KB article (http://support.microsoft.com/kb/299974/), it is stated: "When you run Microsoft Jet in an IIS environment, it is recommended that you use the native Jet OLE DB Provider in place of the Microsoft Access ODBC driver. The Microsoft Access ODBC driver (Jet ODBC driver) can have sta...more >>

I have the following ASP code, which is looking at an Access database and table: objRS.CursorLocation = adUseClient strUser = Trim(Request.Form("Contributor")) strPword = Trim(Request.Form("Password")) strQuery = "SELECT [ProperName] FROM [AuthUser] ...more >>

Hi All Here is a link where u can download source code of ASP shopping cart. Its totally free and hassle free download. The only thing is that the poster has broken the source code in various zip files. Anyways the code is nice for starters so you can try here is the link http://www50...more >>

i have a SQL query that selects a certain column from a table, then based on the recordset.count generates a random number and does a MoveTo(randomnumber). this works fine but i want to do it as a stored query. my stored query is named "random". when i execute it like this: Set oRS = oConn.E...more >>

I have 2 tables in an Access DB. An ID may have 1,2 or 3 rows. The g columns may be have either NULL, an F, or a P. I want to select IDs where none of the rows for that ID contains an F, and find the name in another table Another table contains IDs and names ID g1 g2 g3 g4 sem ----------...more >>

When trying to insert data into an Access DB (ASP/VBScript), I get this message: Error Type: Microsoft JET Database Engine (0x80040E57) The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. I was trying to insert 8 characters into a t...more >>

Hi there. First of all, sorry for my poor english. I have a problem that I don't know how to resolve. I want to make a dynamic image gallery. With an ASP script, I will read the images from a folder and display them on a table, for example. The script is something like this: <%@ Language...more >>

asp page writes to a "memo" field in access. if the form contains: line1 line2 line3 when i submit the page, only "line1" is written to the DB. anyone know how i fix this? ...more >>

Hello. We have some .asp pages running on our W2K Server machine that calls and runs some stored procedures that's on our other W2K Server SQL Server 2000 machine. We are using https for these web .asp pages and was wondering if there was any way to speed up the process of the .asp pages out...more >>

the web app that im creating will allow a user to input their email address, and a "story" (for lack of a better term). i have no way of knowing if this story will be 2 words or thousands of characters. i imagine i would put some kind of limit on the field at some point so that people could...more >>

I have an asp page in which i get recordsets from a access db , when i do a query from the asp page i get EOF (no rs),but then i make the same Query inside access, and i get the data, then i return again to my asp page and for some reasone it gives me some data back, and allways after i do th...more >>

I thought JET was discontinued but I have no confirmation from an "official" page. Comments? -- <%= Clinton Gallagher NET csgallagher AT metromilwaukee.com URL http://clintongallagher.metromilwaukee.com/ MAP 43°2'17"N 88°2'37"W : 43°2'17"N 88°2'37"W ...more >>

hi everyone. building a website for a client and have a few questions related to best practices, what i should use etc... the site will use a database to store info entered by users. each visit will allow the user to input no more than 2 fields: email address, and a comment field. the site has...more >>

Hi, I started developing a project using access and am new to SQL server. One of the scripts I have updates a table entry using access no problem yet throws an error with SQL server on line "RS_Utility.execute(strSQL)". Is there a difference between a standard update statement between Access an...more >>

Hello Everybody, I have the following ASP 3.0 code with Sqlserver 2000 Db: <% Dim ProvStrDb, OBJdbConnection Dim RsRegistraAccesso, SqlRegistraAccesso Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- LockTypeEnum Values ---- Co...more >>

I have an Access database with a table called "Content" in it, with keyfields "Element" (Text) and "ContentID" (Number). I am trying to access a record I have in there which has the following values: Element = 'Contact', ContentID = 1. Relevant code looks like this: <!--#include file="Connect...more >>

Hello all, I am new to classic ASP , i am basically a .NET developer. But i got a issue to solve at work which relates to ASP. We have a classic ASP app which has Sql server credentials in connection string. Since this is not secure , we are thinking of making it as Integrated security....more >>

I'm looking to add a multi-level listbox to my page. Essentially I need what ebay had (has?) where as you select something from level 1 it writes an ID into a textbox and alters what appears in level 2. Then when you select something from level 2 it writes a corresponding ID into the textbox a...more >>