Hi I have 2 textboxes - from & to. Assume I enter number 1 in "from" and "10" in to - I want the ASP to return : 1,2,3,4,5,6,7,8,9,10 and insert this into access database over 10 rows into the 'number' field. Anyone got any ideas how to do this? TIA Oli ...more >>

Hi, I'm using: SearchString = request.Form("SearchString") 'works fine TodaysDate = Date() 'gives todays date correclt formatted strsql = "SELECT * FROM tblListOwners WHERE (((listOwner1) Like '%" & SearchString & "%') AND ((listCloseDate)>=" & TodaysDate & ")) OR (((listOwner2) Like '%" ...more >>

Group, On a W2K3 / IIS 6.0 Server, we have a Web Site reading an .mdb fine. When it tries to save, it generates the following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /w...more >>

Hai , I am shine from India, a web programmer. I want to know about how to create a domain search page using ASP. Any suggestions would be greatly appreciated. Thanx in advance regards shine...more >>

I have migrated all the data from MS Access 97 to MS Access 2000. For unknown reason, my ASP prgram can't retrieve any chinese characters on the web page . It only shows "?". What's wrong? It used to work fine. Please advise and many thanks ...more >>

Hi, Working on a solution where we are using XML as a means to export and import various data. Are Using ADO to save to (export ) XML using adPersistXML and then XSL to convert to an element-based XML. Is there an easy way to INSERT data from an element-based XML into ONE database-t...more >>

Hi, I'm trying to select fileds that are in the results of a SP. So I have the table "tblItem" itemID int Identity Key, itemName varchar (100), itemDate smalldatetime I have a SP "p_getItemID" which is lets say SELECT TOP 10 itemID FROM tblItem Now what I want to do is: SELEC...more >>

Hey all, I'm trying to do the following in ASP : - Determine the parameters(field names and data types) of a table . - Create a new table with these same parameters. - Insert all data from first table into copied table. Any suggestions as to what a reliabl...more >>

I am getting the error message below in the event log for a windows 2003/sql server 2000 web and database server, any ideas? I seem to be experiencing problems with asp pages connecting to sql server. The data buffer created for the "ODBC" service in the "C:\WINDOWS\system32\ODBC32.DLL" librar...more >>

I can't figure out why this code segment will not print line 4 if the condition is true. 1 <%If NOT IsNull(rs_shiurim("Tuesday")) Then %> 2 <tr> 3 <td width="13%"><strong>Tuesday</strong></td> 4 <td width="87%"><%=rs_shiurim("Tuesday")%></td> 5 </tr> 6 <% End If %> Line 2, 3 an...more >>

In MS Access, there is an interface to draw the relationsip between tables. Do I really have to draw the relationship to obtain databse data? Thanks in advance ...more >>

It's weird! I am writing an asp code to retireving data from the MS access. Any records before today will not be populated. It works fine except that I could not get any result for the month of January 2004 and October 2004 at all. What's wrong. please asvise. Many thanks! Dim get...more >>

I am confused. I need to access data on a mainfram IBM DB2 database. Is it as simple as setting up a ODBC DB2 driver. Or does a data conversion need to take place?...more >>

Running ASP pages that query a SQL2k box. I have this SQL statement that works when I plug it into Query Analyzer, but it does not work when I have it in ASP page. Dim noodle Set noodle="SELECT Customers.[Company Name], Customers.State, Schedule.PurchaseType, Schedule.[Equipment Amount] ...more >>

I've recently upgraded the server to latest SQL 2000. Started getting a lot of errors "UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'. " Checked the MSKB, which said we needed to add the following once we opened the connection conn.Execute "SET ARITHAB...more >>

Dear All, How could I make a menu have many sub-menus, note that the menu and sub-menus items come from database. Ex: a menu have items like: Products | Auctions | Orders the menu items above all come from a table in a DataBase, and if On Mouse Over or On Click events happens for an...more >>

Can I use my GLOBAL.ASA file to open a database connection before each page loads? Would someone mind posting a very simple example? I tried to make it work but couldn't. Thanks! ...more >>

I Currently have an asp website created manually (not using frontpage)with an access db. The way it works now the iusr- account needs read/write access to the database or else the pages display errors. I don't want to leave these permissions because they pose a great security risk and also the ...more >>

What are the different ways to fire stored procedures in a SQL 2000 server? Which is better? I have seen simply: set rs = conn.execute("sproc") and I have also seen massive command.parameter ... bla bla ... ...more >>

ÈçÌ⣺ SQL SERVERµÄTEXTÀàÐÍÊÇMEMOµÄ£¬ÎÒʹÓÃÏÂÃæµÄÓï¾ä³ö´í£¬¸÷λ°ï¸ö棿 <%=rs1.fields("memo").value%> ...more >>

Hello, can anyone give me some hints about updating a sql server database with MsAccess database info on a remote desktop machine, the idea is to write an access application to gather some data and then update the sql server via asp-scripts on a webserver with sql behind it. I've already worke...more >>

Hi, I'm trying to write a simple ASP page which retrieve data from an Access DB. However, the recordset.open method always fails, and I can't get anything, even though the connection is open. Any advises? Shay...more >>

Hi, i have a very irriting problem that i have written a short piece of code to demonstrate. The problem is that my aspx page is not fully refreshed after an event, which is delegated to an ImageButton during runtime, is fired. Any suggestions would be great. This code is the c# behind a webfor...more >>

I was wondering what is the best method of accomplishing an update within Asp using Access? I was going to going to use the update method of an ado recordset, but I thought I would ask in case there is a more efficient way to do it. Thanks Terry ...more >>

Hi, I have been using access 2000 for two years on WINDOWS NT to display dynamic aweb page using ASP My ISP has now changed to Windows 2003, and I am having major problems displaying information from MEMO fields within the Access 2000 database. I have not had any problems before displaying...more >>

We are running asp (not asp.net) and vb com dll web sites on a machine which also has sql server 2000 sp3a running and uses Windows Server 2003. We recently migrated from Windows 2000 (same database) where we had no problems. However on the new machine, despite much being much more powerful and ...more >>

Hi, Im trying to get his SQl to work but run thru a query analiser tells me there is a syntax error and in the browser returns no results - any ideas? SELECT m.Username, m.Author_ID, au.Author_ID AS ActiveUserAuthorID FROM tblBuddyList bl INNER JOIN Members m ON bl.Buddy_ID = m.Author_ID ...more >>

I need someone to code some ASP pages for me. Don't have much money...but have lots of great ideas - willing to share profits and a little up front. I have a website on godaddy.com which offers ASP.net/PHP and 10 mySQL databases for a pretty good price. I need data from a form to be poste...more >>

Hi, Wondering if somebody can help me join these two statements to one! The first looks at a tblMembers with tblBuddyList and matches the data by Members.Author_ID and tblBuddyList.Buddy_ID etc. really looking to get all the info in one; ultimately I want to check that the tblBuddyList.Budd...more >>

i have this stored procedure... CREATE PROCEDURE p_sale_tax @locid INTEGER, @sdate VARCHAR(10), @edate VARCHAR(10) AS SET NOCOUNT ON SET @sdate = CONVERT(DATETIME, @sdate) SET @edate = CONVERT(DATETIME, @edate) SELECT masterheader.transactno, SUM(masterdetail.tax) as tax, sum(master...more >>

Hello People, I have a strange problem, one has been asked a few times on the ASP general list. But my SQL DB hosts say the problem is an Open Connection problem. What happens is this, I have a complete ASP site driven by a MS SQL DB, but every so often, ASP Pages stop responding, no t...more >>

Hi, I'm building an ecommerce website. When a user logs into my site, I want to create a temporary table (say called 'ShoppingCart') in my database. I'm currently using MS Access, but may use SQL in the future. Since I cannot create a temporary table in Access, I want to create the table and ...more >>

Hi, I have a table with a camp "Fecha" (it is datetime).I insert a date in this format: dd/mm/yy (for example 01/11/2003) but in the table the insert value is 1/1/1900. I insert the value using ASP code. What is the problem? Thanks and regards. ...more >>

I hope this is the right ng for this....If not, I'm sorry.... I have an ASP driven web site that has many forms that update to an Access dbase. One of the tables in that dbase contains an email address field. I need to have those e-mail addresses usable for both sending individual e-mails as ...more >>

Hi, I've got the following problem and I don't know how to make this (if it's possible at all): I want to make a form where the user can enter a criteria and then, after pushing a button or link, a certain table in a certain DB is updated. So it's not about updating a single record, but ...more >>

Hey folks, i'm _trying_ to get a dependent list box example working from this example/tutorial found at http://www.asp101.com/resources/DependentLists.asp. The tutorial originally had an access DB, but i've since changed that to sql server (maybe thats the problem!?) Well, i've run into plent...more >>

Hi, Does anybody knows, how can I configure (add or change) ODBC Data Source programmaticaly from ASP (or ASP.NET)? Thanx ...more >>

Hi. How ya doing? You guys are great. I am stumped. You know when you right-click on an image or other file, you get the properties sheet. Then you take the Summary tab. How do I read the Summary tab with ASP or Vb? Thanks so much! Jeff Clark ...more >>

The following code works when I connect to one of my sql server databases but doesnot work on the other one. The database that this code works is a SQL Server 7.0 and the one on which it doesnot work is SQL Server 6 or 6.5 I get the following error. Can anyone help me please? Select TOP 5 TA...more >>

Hi All We have a search page for one of our applications which connects to a SQL Server database in SYDNEY. The IIS server on which the ASP page resides is based in LONDON. The performance of the search page is not great. It does work but takes about 25 secs to display the results. Can a...more >>

We have just migrated from a windows 2000 server running classic asp/sql server web sites without the .net framework installed to windows 2003. Despite having the same traffic levels sql server on the new machine seems to be using up much more RAM than before. I suspect that their may be unclo...more >>

Does anyone know what the problem with this code is: <% If NOT(rs_shiurim("Daily") = "") Then %> <tr> <td width="13%"><strong>DAILY</strong></td> <td width="87%"><%=rs_shiurim("Daily")%></td> </tr> It only prints "DAILY" when the string is NOT "" Thanks Shimon ...more >>

Hi, Hope someone can help. The ASP below correctly gets the data out of the Access DB but when I click update it does not. Anything obviously wrong? TIA, Oli ------------------ <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="../Connections/users.asp" --> <% ' *** Edit Oper...more >>

<INPUT TYPE=BUTTON NAME=cmdUpdate onclick="oRS.udpatebatch ()" Value="Update Records"> Any wrongs in this script? DS...more >>

I just went to an online coupon site (entertainment.com) and noticed that if I print out a coupon the server is aware of it because a page on the site lets you know if you are allowed to print out anymore of the same coupon and if so how many. I have already been informed by someone seeing a pr...more >>

I have an ASP site running in IIS 5.0 using ASP 3.0. I am making a SQL call to a DB2 database on our AS-400. The site has been running fine for 6 months and suddenly I'm getting sporadic 80040e14 errors in the log files. The log file message is as follows: 2003-11-19 16:32:17 12.35.121.12 - ...more >>

Hi I am simple problem please help. I want to write a simple query to search for particular occurance of the string in any part of the field. The fieldname is TapeNum and I wish to display all rows where tapenum has the characters 'ASP' I wrote the following query select tapenum fro...more >>

Hi Using ADO, when I run the 'sp_columns' strored procedure for a particular table in my database it returns all information correctly. However, when I try to run a query on the same table (or any table for that matter) I get an error saying the table doesn't exist in the database. ...more >>

Hi everybody: I have a seen a few sites that seem to know my name once I have left their site and returned without me logging in. I have a feeling that this feature can be implemented with Application variables within a Global.asa file. But I am not sure how to go about doing it. Can anyone ...more >>

I want to relate 2 tables in Access or SQL for a one to many. I would like to find an example in .Net for data entry for this structure. For example, I would like customer info at the top of the page and customer history at the bottom. Maybe the details section can be in a editable grid control ...more >>