Hi all, I'm new in ASP so, I have an access db with a table called IMAGES. It has two fields (IID and ImagePathAndFile). IID has the ID of the main table WEAPON and ImagePathAndFile holds the path to an images on the HD. I want a new window to popup with the image when i click on the name ...more >>

Hello everyone, I have recently developed a web application across my clients intranet. We used ASP with Interdev 6.0 and SQL server as the backend. They have now come to me asking me to develop some reports that can be accessed via a drill down within the app. They don't have Crystal Report...more >>

I want to set up SQL Server on Windows XP Pro so that I can use the database capabilities of ASP and IIS. I am probably using some incorrect settings, but I am not sure what they are. Here is what I am currently doing: When I run sqlservr.exe I see the following: 2003-12-19 15:51:28.20 ser...more >>

I have a simple query to retrieve total order amount by customers, ie, selet customers.customer_id, customers.customer_name, sum(orders.order_amount) as total_orders from customers inner join, etc, etc... which work fine but only retrieves those customers for which there are orders.... a...more >>

I am trying to connect to an Oracle db with my ASP page. I have a system DSN which works just fine (I can use it to connect to the database through Access). Here is the code I am using: dim objConn set objConn = Server.CreateObject ("ADODB.Connection") objConn.Open "DSN=ORDERS; Uid=...more >>

I am executing the following SQL on an Access table from ASP UPDATE MYTABLE SET MYCOUNT=(MYCOUNT + 1) Unfortunately this seems to add 2! If I add 2 in the code, the actual result is +4! If I do -1, then the result is -2. If I change MYCOUNT to an Integer from a Long Integer it works...more >>

Hello, I have searched the web and can't find a solution, but this must (maybe) be common. I am creating an asp page that connects to an access database which contains linked SQL tables. I can query and manipulate data in tables that aren't linked, but when I try to run a query (qry...more >>

When we are search google our keywords . google get some our page. Our home page name is index.html index html include left and right html. so google get left or right html. and we would like if someone click the page then open home page. ( if opening page is not in frame then redirect ndex.html...more >>

I am trying to get the SQL statement right for querying an Access 2k database I would like to obtain the first record of Event A and the last record of Event B of each day. This is what I have for a query. When I run it, I get "Syntax Error (Missing Operator)in query expression LAST [T...more >>

I have a dbase that has about 30 tables in it. How can I delete a record out of all of the tables without doing 30 DELETE statements? Example: SQLstmt = "DELETE * FROM fd_1 WHERE CustomerSSN = '111-22-3333'" Set RS = conn.execute(SQLstmt) SQLstmt = "DELETE * FROM fd_2 WHERE CustomerSSN ...more >>

I have a form that writes to an Access 2002 dbase. It contains 20 tables named RD_1, RD_2.........RD_20. I only want to write to the table if the information exists. I do not want to write the primary key and have the remaining attributes null. My sql script is as follows: (CustomerSSN = ...more >>

Hi, I'm trying to catch the error with following code and my code will stop executing before getting to on error resume next. What is wrong with it? 'I'm executing a stored procedure Set objRS = objCon.Execute(strQuery) 'I will not get to this line if there is an error like 'unique constra...more >>

I have IIS logs that are parsed into a SQL database, and then the database is called by an asp page. My only issue is having duplicate entries in the log from the same source, date, error, etc. What can I do to prevent the asp page from displaying duplicate entries. I'm still in the pro...more >>

I got problem to insert or update new record into the Access database. For your information, I run my ASP program on Win XP Professional SP1(service pack 1)with IIS 5.1 and ASP.NET v1.1. I''m using Access database version 2002. I can read the database file, but can''t add new record to ...more >>

Sorry this isn't necissarily ASP, but it is VBScript & ADO and I figure that you all would be the best to ask. I am using a VBScript that reads a binary file and imports all that information into a database. The file is a proprietary financial database, and I am reading out names, accounts, a...more >>

Having an issue. Trying to create an ASP search page that queries SQL 2k database based on some set and some variable criteria. The problem, I think, lies in how I am presenting the SQL statement to the SQL server. Thanks in advance. Code follows: ============= noodle="SELECT Custom...more >>

> I have ASP 3.0 and I cannot change that, but how can I > upload a file using ASP? Also, when a file is passed from > a form how do you obtain it? I know with data you would > usually do Request.Form("file"). Does this also work with > files? ...more >>

Hi, Is it possible to connect to Access file located on another web server using ASP 3.0? Thanx, Neven ...more >>

I am connecting to SQL server 2000 via ASP using an ADO recordset and OLEDB connection. Occasionally I execute queries though the execute method of the connection. Just recently this has started giving a timeout expired error but will allow me to delete via the recordset delete method. It's not a...more >>

Hi. I have two fields that users can search for. Either room number or Phone number. They can also put both a room number and a phone number and search using both fields. However, this produces the default behavior of returning all results if nothing is entered into either field. Here's what...more >>

Hello, Well I'm finally switching to DSN-Less connection! But, of course, the transition has not been without error :+) Here is my error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name too long /clientside/clientnewstest2.asp...more >>

How do I check to see if a checked box is check on the following page? This is what I have. What am I doing wrong? <%If Request("chkDirection") = 1 Then Response.Write "True" & Request("PssWrd") Else Response.Write "False" & Request("chkDirection") & Request("PssWrd") End If%> chkD...more >>

I read an article that you need to load winsock in eVB to run ASP on a PPC. > > Code Walkthrough > > The first thing you need to publish a Web Service is a Web server. You > > probably know that there is no Web server in a Pocket PC, and > > therefore we need to create one first. You can do th...more >>

I have a standard install IIS server running with Windows Authentication on our Small Business Server at work (1024/512 ADSL). I'm running a small asp web site that generates pages from our sales database of around 1k per page (no graphix, just text). I'm using a PDA (HP iPAQ) and a Bluetooth ...more >>

Can anyone give me some advice on what I need to use XPath or XQuery to access data stored in an XML tree? Do I need any proprietary components or DLLs, or does the Internet Explorer install give me everything needed? Thanks in advance Rae Macleman ...more >>

Hi, ive got this script for aspin.com that wraps text to a specified no of characters. Only problem is, it doesnt account for line breaks (so any shorter lines dont get a vbCrLf and the alignment is messed up further down the line) Can anyone help with this. Cheers Function WordWrap(strTextToB...more >>

Hi I'm developing an online shopping cart. When user modifies a record, it generates following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Could not save; currently locked by user 'admin' on machine 'XYZ'. ...../ad...more >>