Hello all -- I recently stumbled across a great company with wonderful products for easy integration within ASP pages. I've even created a community forum to support the products on my site. Please feel free to visit. http://www.micro-mess.com/forum/index.php?c=9 http://www.xigla.com T...more >>

Hi! Working with an MS Access database from an ASP webpage and I'm getting an Exception error... Error Type: (0x80020009) Exception occurred. /Projects/App/Mypage.asp, line 184 The SQL statement looks like so... strSQL = "SELECT Cat, MyNote FROM Notes WHERE KeyLink = " & SelKey rsS...more >>

Applies to: Microsoft Front Page 2000, Microsoft Access 2000 Operating System: Windows 2000 Professional Web Server: IIS 5.0 I've created a very basic registration page called register.asp which = consists of a form requesting a username & password, I then used the = database wizard within FP...more >>

I have a form where a user enters their name, date etc. i also want them to be able to click on a browse button and select a file which will then appear in a textbox. when they press submit i want the file name and path to be put into the database. e.g. "C:\windows\work\work.doc". Basically I d...more >>

What syntax would you use to dupe a record? Thanks! -- Scotter ...more >>

I have a decimal datatype set to precision 5 and scale 2. When I try to insert a new record via ASP using a stored procedure, my numbers are rounded with no decimals (e.g., 2.2 becomes 2, 2.6 becomes 3, etc.). How can I make sure the values being entered on my web page are inserted as they are ...more >>

Hi, I need to fetch a value in an Access db, so i use a form to pass the parameter for the SQL statement fromVB client to ASP. After the submit line in VBscript, i expect the value in order to test it and go further in VBscript. But my problem is when clicking on the button, that the VB code ...more >>

I'm tring the the following where strDBtoOpen is the UNC path to an Access Database: ..ASP page ADO Connection object Source property. cn.Source = "SELECT DD.* FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','" & strDBtoOpen & "';'admin';'', DueDiligence) as DD WHERE ReviewedBy IS NOT NULL" ...more >>

Hi, I need an input! I am working on an ASP web application that allow customers to order products from the web site. The products pages show only 20 products at a time, I would like to avoid to requery the table every time the user to navigate between pages (I do not know big the table could...more >>

When I use ADOX to get columns(fields) of a table, they are auto-sorted alphabetically by name. I need to get the list of field names as they appear when I open the MDB file and view details of the table. I tried using open schema with following code causing this error msg: "Item cannot be foun...more >>

When I use ADOX to get columns(fields) of a table, they are *auto-sorted alphabetically by name*. I need to get the list of field names as they appear when I open the MDB file and view details of the table, *not* sorted by field name alphabetically. I tried using open schema with following code...more >>

I see columns collection has only following properties: Attributes, DefinedSize, Name, NumericScale, ParentCatalog, Precision, Properties, RelatedColumn, SortOrder, Type So is "maxlength" somehow part of "attributes" or "properties" property? If so, can you please give me an example of how i...more >>

I have a form with ship to customer and bill to customer fields. Both of these are required fields. I want to put a check box in the form and if the check box is checked then the value of the ship to customer is loaded into the bill to customer. I need this to happen before the form is submi...more >>

Hi All, I need some help optimising my object design. Since one article has 1+ authors, I assume the logical way to represent this is for my Article object to have a Authors property, of type "array", capable of representing any number of authors. The code I have written (below) works, but...more >>

Hi - I'm finding tons of examples out there on how to create a table or enumerate thru tables and same with fields but what if I just want to PICK a table I know the name of so that I can read or write fields to it? I imagine it is something like: Set Cat = Server.CreateObject("ADOX.Catal...more >>

I have just read the following by Bob Barrows on another post and am extremely concerned as (like him) I have spent a long time developing an application using disconnected ADO recordsets. "I gave up trying to use recordsets in the client about a year ago.....Unfortunately, we kept running i...more >>

Hi I have one table with two field in sql server 2000. Table data looks like this: Field1 Field2 Admin Active Admin Passive Sales Active Sales Passive Systems Active Systems Active Admin Passive Sales Passive Can any one suggest how to write sql query to elimi...more >>

Apart from the obvious (the style of the function is all wrong, etc.) can someone tell me what's wrong here. I can't get the values of the return and output parameter from my stored procedrue. After: Set localrs = cmd.Execute I expect the values of all 3 parameters to be available but I c...more >>

I have an ASP application with MS Access 2002 backend. This application I have 20 copies of running on the same server. Each application is a different web site. When I come up with a change - usually adding a field to one of the tables in that app - right now I have to manually go into design...more >>

Hi, In 'test.htm', there are two Select, one visible, the other invisible. The second becomes visible only if the number of records in a Access table <2. There is also a button to start the VB-procedure. I choose first a value into the first Select (sel1), then i click on the button to start ...more >>

Hi All I'm really going to show my naivety now, but should I be using locks where possible when my ASP/MySQL DB site is posting data back to the DB? I don't have that many sequential (shall we say) posts and for example, to post an order into my DB it contains the header page data as 1 post ...more >>

Whats wrong with my code? I have my AccessDB with 1000 records on tblItems. When I try to write the Pagecount on the screen, it writes "-1". Hope you might help. <% Set conn= Server.CreateObject("ADODB.Connection") conn.Open "FileDSN=file.dsn" strSQL = "SELECT * FROM tblItems ORDER BY Cat...more >>

I was trying to write an SQL statment that will do a string search in an Access 2000 database. But I can't seem to figure out how to do it so that the search is case-INsensitive. Here's the SQL I have so far: SELECT autoQuesID,fldQuesTitle,fldBody FROM tblFAQ_Question WHERE fldBody LIKE '...more >>

I was wondering if there was any site with a public domain example of how league tables (such as football/soccer tables) could be maintained using ASP and Access databases. Thanks Arthur Turnbull...more >>

I am running a third-party web application (mainly ASP and specific pages with their own extension that are processed by a third-party ISAPI dll) on a Windows 2000 Server (IIS 5.0) which is also a domain controller and has MS SQL 2000 installed. Anonymous access in IIS for this application is se...more >>

Hi, I try to execute request on a ms-access database but I have a problem with date. the "myDate" field's format is "date/time" my request is: SELECT myCode, myStuff, myDATE FROM myTable WHERE myDate = #05/21/2004# in ms-access interface, it works fine ! I get real good lines but wh...more >>

Hi, This function always return and empty RecordSet (R.eof=True) the problem is probably the way I pass the parameter in the CommandText. To avoid looking at all code first look at this I think my mistake is '[@prmClientNo]' but it does not give any error message. Any help will be appreciate!...more >>

Hi all, Is it possible ASP accessing Lotus Notes with ADO OLEDB or ODBC?? Does anybody has sample to send me? e-mail: vilmar9820@yahoo.com Thanks, --------------------------------------- Vilmar Brazão de Oliveira HI-TEC Informática ...more >>

Please help. Trying to update a record using ASP but within a single page i.e. no submit button. Code below. Thanks in advance - ASP Novice! <% Dim objRS__MMColParam objRS__MMColParam = "1" If (Request.Form("cartId") <> "") Then objRS__MMColParam = Request.Form("cartId") End If %>...more >>

I am trying to hide a text field using VBscript *** if firstname = "test" Then msgbox ("hello") form.txtlastname.visible = fales end if *** The message box appears correctly if I enter test, but I am unable to hide the textfield. I've tried a million different things, would appreciate...more >>

I got 800a03fc this error when I execute an ASP file which involves retrieving data from an MS-Access 2000 database. Any fixes. Thanx RAJ....more >>

Hi All I know this isn't an SQL syntax NG per say (esp MySQL), but there are far more legible gurus in here than the MySQL groups so I hope you will bear with me. All I want to know is if there is a sort of IF ... THEN ... ELSE command in MySQL? The reason being that if a product code exis...more >>

Hi All I used to be able to page through data using the old: oRSv.CursorLocation = 3 ... ... ... ... ... ... oRSv.PageSize = cMax TotalPages = oRSv.PageCount oRSv.AbsolutePage = RSPage ii = 1 Do while not oRSv.EOF and not ii > cMax .... .... ... .... ... ... etc But now I've...more >>

Hi I have got access table with two date/time field namely field1 and field2. I made one html form that inputs two dates (it's not mandatory field in form,user can leave blank as well) and submit to asp page that insert data into table. my sql statement is sql = "insert into table (field1,...more >>

Hello, I have a database that has a primary key for username. I'm using an ASP page to allow people to register on line, I have username set as primary key. When they try to click to add theirselves to the db through the ASP page, they receive an error - primary key violation. Is ther...more >>

Why do I get the message "Operation must use an updateable query" on an Update, Insert and Delete. Mind you the site worked fine before a recent re-install of IIS 5.0. I'm using an Access Database. Thanks...more >>

Hi, Can I ask some advice in regards database solutions and content management solutions.? Do you have a philosophy on what is the best for databases - ASP, JSP, Cold fusion, PHP, etc. My company website site is going to be rebuilt and I am the lucky one to do this but I am unsure of the nee...more >>

I have the following code. Should I close and release the database objects before run response.redirect("some url")? or will the response.redirect automatically close the database object/connection like the end of asp script? I am using IIS 3. ....... var cmd = Server.CreateObject("ADODB.Com...more >>

I use mySQL but can connect. Here is my code: Set myconn = Server.CreateObject("ADODB.Connection") myconn.Open "ODBC; Driver=Sybase SQL Anywhere 5.0;" & _ "DefaultDir=c:\inetpub\dbase\;" & _ "Dbf=c:\inetpub\dbase\mydb.db;" & _ "Uid=dba;" & _ "Pwd=...more >>

Hi On my local server the physical db path is "C:/Inetpub/wwwroot/StaffDiary/Cal.mdb". I am using the virtual path as conn.Open Server.MapPath("Cal.mdb") but I am getting a; Microsoft JET Database Engine (0x80004005) Unspecified error error. What am I doing wrong? Thanks Regards ...more >>

Hi I am getting an unspecified 0x80004005 error accessing my access db. What steps can I take to find out where the problem lies? Thanks Regards ...more >>

How can I export my access db structure (and query/procedure), and import them to mySQL db? In SQL Server, it has function to 'Generate SQL'. In Sybase Watcom, it has 'Unload database'. ...more >>

Hi I really don't know anymore how to solve this problem. I bought .NET thinking i can debug my way out of it but still no cigar. This very simple piece of code does not work: Now here some things before looking at the code: 1. In .NET and IE and IIS I've set all possible debugging ...more >>

Hi All If this should be in .asp.general rather than db please accept my apols. It is based round a problem with my ASP/MySQL DB so hopefully I've posted correctly. I've created a CMS that allows the user to upload their own company logo gif (to be displayed top left of every page) and thi...more >>

Hi I have a very simple script that seems to work OK inserting into an Access table from a CSV file. The problem I have is that the first column (stored as text) has student ID numbers - some start with 100... others start with a character like K or M. It inserts the 100... IDs but not t...more >>

Applies to: Microsoft FrontPage 2000, Microsoft Access 2000, IIS 5.0 Operating System: Microsoft Windows 2000 Professional I am trying to protect a portion of a web site by allowing users to = register a username and password & then login with those details, but so = far I am having only margi...more >>

I want to take the post data from a form, validate it etc and then post it out to another page.(on a different site) Is there a way in vbscript to post a form automatically i.e. user completes form & submits via post Process data & validate Post data to 3rd party page Thanks in advance ...more >>

I seem to recall reading the SQL Server DE can be used to develop SQL Server DB's, however the information now suggests that that is not the case. I'm looking at using a SQL Server DB for the backend of my website. What do I need to purchase in order to be able to develop the db on my laptop...more >>

I am developing a web based application that will have about 1000 users. It will be hosted on a Windows 2003 Server and written in ASP, ASP.NET. Which database should I use and why? Access 2003? MySQL? Oracle? Microsoft SQL 2000? Thanks, Jerry ...more >>

an app i've written using FP2000 and Access 2000works well enough, but the server, after a few days, slows down and needs to be rebooted to speed things up again. some of the pages i've written use the wizards in FP, but many of the update pages i've used by writing them in just ASP. I *think*...more >>