Hello all, I've developed a website system that stores all the pages of a website into a database table (id int, content text). Is there a way that a user could say type all their editing (underlines, bolds, colors, etc.) in a separate place then insert it into a database that will th...more >>

Running W2K, Access 2000 with all updates prior to SP4. Running into two errors. Attempting to recreate a Microsoft ASP "Guestbook" example. (About 3/5ths of the way down this page: http://msdn.microsoft.com/library/en-us/dnasp/html/asptutorial.asp?frame=tru e) Set up the DB and ODBC. Editted t...more >>

I'm trying to select records which have a FIELD_VALUE = x, y, or z. I've tried several things and I can't seem to make it work correctly. Here is the code I am using on SQL Server 7. SELECT * FROM dbPub WHERE FIELD_VALUE = "1", "2", "3" I'm rather new at working with SQL statements, so any...more >>

I have a problem with adding a record to my MDB database. I know how to add products, but as soon as I use a checkbox to add "selected" or "not selected", I get the message "Error desc. -> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression." How do I add a chec...more >>

Hi, I have been charged with redesigning my companys intranet. The Intranet uses sql server as the backend db. Currently the intanet uses windows authentication. Access to the tables from the asp code is via a combination of sp's and direct "select" "update" "delete" and update statements. O...more >>

How in ASP can I check to see if a stored proc is running?? The reason being is that when I execute this specific stored proc, it takes a while.. and I dont want the user to execute it again.... Let me know please. Jason Burton talon@starloop.com ...more >>

I am using SQL Server 7.0. I have a table with a field called PARENT_ID, which has a numerical value entered for those which have a logical parent, and has an empty value for those that do not. I want to select the records which have a PARENT_ID = '' (Parent_ID equal to nothing). The followin...more >>

I'm new at ASP. I'm trying to access some info out of an access database and i get this error. I've set up the ODBC correctly (I think), so I'm not sure what's causing this error...Any Ideas would be appreciated. w i l l -----ERROR------ Technical Information (for support personnel) Err...more >>

Hello, i'm having a problem while downloading files on my server. When someone downloads a file ( push ) from the website, the system refuses to continue browsing while the download is going on. Any way to help this problem ? I run IIS with ASP. Marc ...more >>

Hi, One page passes a strIssueNo to another, so on the 2nd page: Dim IssueNo IssueNo = Request.Item("strIssueNo") This 2nd page is designed to create a new record in a database table, however I get a Type Mismatch error. This is the line that adds the issue number: rsAddNote.Fields("I...more >>

Database: Access 2000 MDAC Version: 2.7 Provider: Microsoft.Jet.OLEDB.4.0 Is there a way to access the number of records affected when executing a query as a method of the connection object? For example, using the Execute method of the connection I do the following: sql = _ "EXEC spInsert...more >>

Hi I am looking for a business portal app that allows lot of ads on the front page and featured businesses etc plus the usual portal stuff. As this would be free for companies to advertise, I am looking for something that is relatively cheaper. Thanks Regards ...more >>

Hi, I have an Access database with a query that selects a set of records from one table (work categories) and inserts them (multiple rows) in to a timesheet table, along with the employee's name and selected week number (both of which are variables inputted by the user). i.e. each record from...more >>

I have a form that will have a combo box repeated several times (continuous form, one for each record), it's going to cause a problem if each has to have it's own set of [option value=] lists against it as there may be several hundred combo boxes and several hundred items in the dropdown list fo...more >>

Apologies for the length of this mail but code is included. Have a page that pulls data from one database & displays the results, using a loop to display each record on the page: The select Query: strSQLtickets = "SELECT CALL.CALLID,CALASGN.ID20OPERID,CALL.CALLDAT,CALL.NAME,CUSEMAIL.NOTET...more >>

Tried MS Guestbook ASP/database demonstration. Received coding error while putting the page into motion. Would someone confirm if it is a coding error or user setup error. http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid =28000522 TIA, Dave ...more >>

Hi I'm looking for the best webinterface for editing database data, for example publishing a table with foreign keys shown as a dropdown. I don't care what database the interface is for (MSSQL, MySQL, Oracle, MySQL, Access, Filemaker, PostgreSQL, ...), and the price of the software is also "i...more >>

SQL = "DELETE FROM table WHERE ID IN (1, 9, 15, 20)" The above statement is for deleting records in access using checkboxes on a form (deletes records with ID 1, 9, 15, 20). How can I use the same principle for mySQL? -- ryanbNOSPAM006@hotNOSPAMmail.com (remove the NOSPAMs to reply by e...more >>

I would like to construct a custom DB editor / viewer as an ASP novice. One of the requirements is to be able to show only the records that apply to a given user. Can anyone point me to some sample code that might explain how to use session variables that would Select * From MyTable Where UserID...more >>

Hi, I am getting this error from my asp page: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified It's been working fine but it's just giving me this error this morning. What may cause this...more >>

I'm in the process of writing a system that stores the pages of a website into a database, is it possible that those pages be found via a search engine like Google? If not, is there are way around this? Thank you for all your help!...more >>

Could you advise if I am doing anything wrong? Page: bdConnect.asp <% Set DataConn = Server.CreateObject("ADODB.Connection") 'DataConn.ConnectionTimeout = 15 'DataConn.CommandTimeout = 30 'DataConn.mode = 16 DataConn.provider="MSDASQL.1" DataConn.Open "Driver={Microsoft Visual FoxPro Dri...more >>

plz send asp in details ----------------------------- This message is posted by http://Asp.ForumsZone.com ...more >>

Hi, I am fairly new to ASP so please forgive any possible stupidity. I have a series of ASP pages that read/write to an Access database. One of the pages queries a table using an SQL statement - "SELECT * FROM TABLE WHERE DATEFIELD = #2/07/2003#" this is the query that I am using. In...more >>

Text box doesn't have 'DataSource' property. Is there any way where I can bind the text box to a data source field.? Thanks...more >>

Under IIS 5.1 and Frontpage Extensions 2002 I can read pure ASP like <%=now()%> but when I try to read a ASP page with a Database reference, the page dont't open - nothing appear even a error... I've already reinstalled IIS and Frontpage Extensions, MsDAC but nothing!... What's the problem? ...more >>

Hello Group, been lurking for a while now, great source of info. A little help if you will? I have two tables: Applicant1 Applicant2 I have one form with details for App1 and App2. Can I somehow insert the necessary values from the App1 fields into table1 and the App2 fields into table...more >>

hello.. i just bought a book called "Learn ASP.NET in 21 days"..lol I am running win2k pro...i installed iis and the .net stuff...now... when i try and do the tutorials it will only recognize .asp files...but my book says to save them as .aspx...ill be the first to admin im a noob at this ...more >>

Dear Friends Hope you all doing great. Few days ago I asked you all for a coment on using Access and ASP. I got many replies. In one of the replies, Dear Tom B, suggested me to use Code One for setting recordsets. And he also suggested me to use OLEDB connection instead of the one I am using...more >>

Is there a way to get a row from one table and write it directly into another table? Most of the columns are named the same, but their are a few that need to be ignored in the source table and a few which must be filled in through user-entered values in the second table. Any links or code exam...more >>

I have data on a website homepage from a remote sql server. When the remote server is unavailable, the page will fail. How can I replace the data that should be displayed with an error message, rather than the whole page failing? THanks Leslie...more >>

I'm looking for some sample code that functions as an Access table editor. I had one that gave me a table grid with the hyperlink options to edit, insert or delete on every row, but it was hard for me to edit as I needed to becasue it just used response.write for all html as it was called with f...more >>