Ok, Here is my problem which is plaguing me, to a point where I don't know where to start. My boss wants data pulled from a page that contains a HTML table with values in that table, he wants the table to opened, and parsed then stored into an access database for our own use. Now the data is ...more >>

I am working with code I did not write for a web app that used to run on an Access database. Due to performance problems I'm trying to move the app to a different server running SQL Server 2000 SP4 and IIS 6 running on Server 2003 with MDAC 2.8 SP2. On the new server, one of the queries is fai...more >>

I have IIS server installed on XP-pro. I also have Norton Internet Security installed. I can run simple ASP programs without any problem. But when I use forms with post method and call an asp in action, it does not pass any data to ASP. Request.Form method on a form field does not return an...more >>

Hey all Sorry, you'll have to excuse my newbieness. I'm developing a simple web app in DRW to display some products stored in an Access DB. The web site seems to work fine, but I keep getting this error: Provider error '80004005' Unspecified error /giftything/product_pages/productdetai...more >>

Hi, I made a form where visitors can introduce data. I use this: strsql="INSERT INTO mytable (field1,field2 ...) values('" & lol & "',#" & dat & ...)" My problem is that when someone introduces a quotation mark, i get a error and the insert fails (e.g. nam'e). How can i prevent that? Co...more >>

Hi, RE: SQL2K, ASP -------------------- I am trying to secure a data entry page and want to avoid any sql injections. Is there a way I can use Command.Parameters with a query (instead of a storedproc). Any solution? Thnx...more >>

when i try to write cookie on ASP page with the line like this <% Response.Cookie ("username")="test1" %> i get the message: object doesn't support this property ormethod: 'cookie' i use windows 2000 server any suggestion? thank you ...more >>

Hi I have created my Rich Text Editor, and it all works fine. However I have come accross a problem when trying to insert the data into a database. I have put the iframe into a form and am using the normal request("ifame id")to try to collect the data. however it does not seem to want ...more >>

Hi, I have a problem and do not know how to connect an ASP page to an Oracle database via ODBC. How can I do that? Thanks for your help. Rgs, John...more >>

HI guys, I am ASP dveloper i had IIS installed on my comp for quite some time, but did not use it for few months and now when i try to start the service i get CANNOT start WORLD WIDE WEB service ERROR 87 : Incorrect parameter I have reinstalled IIS , checked the related files, MY OS is wi...more >>

tahnks ...more >>

hi all, i have the following fields.... Document_Name, Document_No, Document_Date, Order_No, Order_Date, Peripheral The first 5 you can understand, peripheral is a memo field which contains all less important (but important!) details like Address1, Address2, Place_Of_Delivery in a ...more >>

Hi all, Newbie post here so apologies in advance.... I have a 'Call log' form that enters details of a job into an access database (works a treat) and then redirects to a page that will enable you to print those details onto a call sheet. In the database, the first field is an ID field w...more >>

Hi. We've got a classic ASP app that needs to connect to a SQL Server 2000 db via Windows (domain) authentication. How is this done? I've found articles on ASP.NET but not ASP. Some code examples can really help (what the connection string should be, etc.) Help please :) ...more >>

Hi All, I had been assigned a task to develop a program which require to access MS Access data in multiple sites from our headquater. Few questions, 1. Can we access the Access DB by using IP without mapping to the remote directory? (There is a fix connection within this 2 sites. "Private...more >>

Hello everyone, I'm using the following procedure to do two functions. 1) Extract all zip codes from a database of American zip codes, which falls within a 15 miles radius from a predefined zip code (variable @zipcode) Then... 2) Compare the results to a zip code column in a customers tabl...more >>

greetings all... I know this is more of a db question, but I'm hoping that my fellow asp folk will take pitty on me and help me out. If someone could provide me with some insight as to how I should break up and normailze these tables I'd be most appreciative. I am struggling with putting my ow...more >>

Hi, I am a Business student in my last year and for my final year project I am trying to build an online booking appointment system for a beauty shop I am using dream-weaver MX, ASP (VBScript), and an Access database. I have a limited knowledge of any programming aspects on my ap...more >>

Bumping to mitigate effects of OP's incorrectly set system clock. -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" ...more >>

Hi Everyone, Can any one spot the error is this procedure, or the ASP code to call it below. The procedure consists of two parts. 1) Seach function to extract all zipcodes from a zip code database, which fall within a 15 miles radius from a predefined zip code (variable @zipcode) 2) Th...more >>

Thanks in advance. I have the feeling I've made a small rookie oversight either in Access or with my asp page and need some troubleshooting. First, here's the firefox error page I'm getting: Press Release Output Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Mic...more >>

Hi, I'm a low level coder, so please bear with me. I have a table in a database with a field called 'company' I want to display the value of that field in my application when there is a value in the database, and display 'N/A' in the app when there is no value. The code I have is as foll...more >>

Hello everyone. I apologize for this newbie question but after searching the 'net I am at a loss. I also posted this request to microsoft.public.frontpage.programming and hope this is okay. I have a database with two tables. The first, table 1, is for the user information and the second, ta...more >>

Hi Can anyone please assist with this. Is there any way that I can extract a specific cell value from an uploaded XLS sheet into an ASP form field? eg MyXLS.xls - Sheet1 - cell A3 -----> MyFormField Thanks C. ...more >>

Does ASP take care of multi user log in? For example, The first user hit login page and enter user name and password. ASP engine sends data to first user. What happens if second user online. Does ASP ask second user to login again. ASP should send out different data to second user. I mea...more >>

Is it possible to creat event using ASP. For example, I need to do something when user click dropdown box. I need an event for the dropdown box on click. If yes, can you pleasee give a simple example code. Your information is great appreciated,...more >>

Does ASP supoort SQL server store procedures? Should I just have Excute MyStoreProc @MyParam1, @MyPram2 in the command text? Thanks millions,...more >>

Hi, I would like to have bound control to display. For example, to have a text box to have customer number and a drop down box for customer type look up customer type table. Can you please give me one example for this kind task? Thanks milions, ...more >>

<% Set myMail=CreateObject("CDO.Message") myMail.Subject="Sending email with CDO" myMail.From="mymail@mydomain.com" myMail.To="someone@somedomain.com" myMail.TextBody="This is a message." myMail.Send set myMail=nothing %> I use above code to send mail, but I got Error Type: CDO.Message....more >>

I hope this is the right forum for this question. Until a couple of days ago, when I was developing on my local host I was able to test my asp pages with the access database, which they query, open. Now I am getting a error: "Microsoft JET Database Engine (0x80004005) Could not use ''; fi...more >>

I have a connect string like following: sConnString = "Provider=SQLOLEDB.1;User ID=sa;password=mypassword;Initial Catalog=MyDatabase;Data Source =MyServer;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096" I got error connection. I think I have trusted connection to SQL ser...more >>

I wnated to write a connection to my SQL server, but I got fail. The folowing is my code. Can you please tell me where I am wrong? <% set conn = Server.CreateObject("ADODB.Connection") set cmd = Server.CreateObject("ADODB.Command") sConnString = "Provider=SQLOLEDB.1;User ID...more >>

I am seeking to hand-roll my own blog in ASP.NET 2.0 and SQLExpress=20 2005. Why? Because I can. Because I will gain experience. The one thing that has me stumped at square one is inline images. That=20 is, images inline with the actual content of the blog itself. Is there=20 an example that I...more >>

<%=20 @ LANGUAGE=3D"VBSCRIPT"=20 %> <%=20 Option explicit response.expires =3D 0 %> <!-- #include file=3D"adovbs.inc" --> <!-- #include file=3D"MyInclude.asp" --> <% 'Data MUST be validated first Dim cnGoodsInStock , rsCompanies, rsSuppliers Dim Cn, sql, Rs Set cnGoodsInStock =3...more >>

Hi, I need to run a complex (for me!) query on one table and am getting nowhere. It's for a menu/submenu system. I have three tables involved: Content, Categories, and Content-Category Links (CCLinks). The "CCLinks" table groups Content and Categories by pairing their IDs and assigning a...more >>

I want to make Server.ScriptTimeout to infinity and tried to set to 0 but it does not work. Can you please give more ideas? Thanks Yuba, CA ...more >>

I have a stored procedure that is called from an ASP page and it takes about 3 minutes to execute. When I run it from QA it takes about 4 seconds. Simple SQL Select works fine the problem is only with stored procedures. Server is runnig W2003 and SQL2000 I've also installed SQL locally on Wi...more >>

I am inserting data into an access database. The problem is that quotes in the field terminiate the string. If the input value is 24" plug all I get in the database is 24 How can I fix this? ...more >>

I got an web and its control panel. In that i got 3 ODBC Connection fro MS Acess and another is MSDE but i don't how configure and program it. In MSDE i got DATABASE NAME and another ADMIN USER can any one tell me how to use MSDE for my web page i don't have any idea how to use this MSDE. ...more >>

Hi, Could someone please point me to a very remedial tutorial on self-joins (and maybe the other types of join statements)? I understand the basic concepts -- I've done lots of simple SQL queries and a few inner joins -- but still need something written in the most accessible way possibl...more >>

I have to validate a form witch is like this. It works well exept for = whats in bold. It should then connect thru a recordsett and check = another table in the database for a simular number. This it will not do. = Nothing seems to happend. I must have done somthing wrong so i hove ther = is som...more >>