I have been used to paging through recordsets but until now have not come across this problem. When my sql select statement is based upon a SQL View it always returns -1 pages and this prevents the 'next page' / 'previous page' links from working. Should it be possible to do this or does th...more >>

Hi All If possible, could you please confirm what the ASP query syntax would be to add an extra field into an Access table at a particular position, eg after field4 and before field5. Thanks Robbie ...more >>

Hi! I am trying to pass a VBScript Date variable as value to an ADO adDate parameter of a stored procedure (which runs in an SQL Server). If I add the parameter like this: oCmd.Parameters.Append oCmd.CreateParameter( "@p_Date", adDate, adParamInput, , dParam) where oCmd is of type ADODB.Co...more >>

Hi, Using a login userid, I am trying to go to a asp page which will display the values for the particular record. The asp page has quite a few recordsets in the form of Access stored query. Now for the first recordset, I do not get an erro while for the second recordset, I am getting an erro...more >>

Hi Folks, I am using an html file that have a code that reads from an xml file and displays it in a grid. however the xml file is updated every 5 minutes, and the code read the data every 5 minutes.the problem is despite of updating ehe xml file the old xml file data still displayed, after...more >>

Who are you? ...more >>

Hi: Can someone please tell me why I'm getting this error? Previously the code worked perfectly. All on a sudden, I can't delete or update. ---------------------------------------- Error Type: Microsoft JET Database Engine (0x80004005) Could not delete from specified tables. /AprDelete.a...more >>

I currently use a pulldown which holds all customer names. When a customer is selected, it takes the user to a detail page. Basically using the autonumber ID field. Select * from myTable where ID = ID I would like to allow the user to navigate to previous or next records from the detail p...more >>

how could I using ASP to retrieve a blob from Oracle 8i? For instance: I have a table "blobtable" Field 1: customer_id number Field 2: customerphoto BLOB (all jpg) what code can retrieve the jpg file from Oracle and show it on the resulting ASP page? thanks in advance. ...more >>

I developed an ASP application, now I want to convert it to ASP.NET. However, I cannot implement it after I completely re-design. Can I develop new things with ASP.net and keep the original ASP. Is it possible that ASP page and ASPX page run at same Web Server at the same time? Thanks in advan...more >>

I've got more than one form on a single ASP page. The top combo box is populated from an access database with job titles. The field below it, in its own form, is a text field that one can put a new job title into, press the submit button and add the new title to the access table which is pop...more >>

Im trying to transfer an old asp/SQL server application to asp/MySQL and have run into a problem with SQL (Or suggest another news group?) My version of MySQL doesnt seem to support sub queries (and cant upgrade to the latest that does), so I cant use the existing SQL Is there any way to join w...more >>

I'm getting a SQL login error. Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'sa'. /msft/StraightASP.asp, line 7 I downloaded some files from MSFT. This one had an error, so I corrected it. The '=' was missing between Initial Catalog and PUBS. ...more >>

schedcheck = "Select Sched_Date,Sched_Start,Sched_End FROM Schedule WHERE Sched_Date = #"& strSched_Date &"# AND (Sched_Start BETWEEN # "& strSched_Start &" # AND # "& dateAdd("n",-1,strSched_End) &" # OR Sched_End BETWEEN # "& dateAdd("n",1,strSched_Start) &"# AND # "& strSched_End &"#) " se...more >>

Ive got a scheduling application using an Access db. Scheduling works fine but Im trying to implement a function to prevent scheduling conflicts. Im not sure if this is the way to go about it but below is what I have so far and it's not working. It schedules the event no matter what. What's w...more >>

Using ActivePDF Toolkit with a website. The site allows a user to submit information to a database, search, view and edit it. Now I want to add the option to save in PDF format after a search has been completed. Presently I have the search results populating a drop down box from which th...more >>

I have a select field populated by a field within the table of an access database. I can't seem to have the results alphabetized. Any helpful insight, anyone? The table is called jobtitles and the field is jobtitle. <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Provider=...more >>

Hi all, I'm using the "If Request" command to submit data from a form to a database only when the form is submitted. But for some reason the form data is submitted to the database on page load. Causing a problem because the values submitted are null. Q1) Can anyone look at the code and tell...more >>

How do i find a stored procedure or trigger that DOESN'T have SET NOCOUNT ON in it somewhere? Ben...more >>

I'm having a bit of a brain cramp and need a shove in the right direction. One thing that really bogs me down is having to go back and forth trying to catch every ASP page SNAFU when the database schema gets a subtle change like making an optional column (nulls allowed) a required column (not n...more >>

Hi, I am building a very small ASP page. I would like to check for the result of the sql statement in the page before opening the recordset. However, when I am running the page, it gives False as Response.write value of the sql statement. I have no idea why this is happening. Thanks in advance...more >>

Hi, I got a form where user inputs financial information. However, they can come back and edit the values before the deadline date of submission. I am designing just one form for input and edit/update for later changes. The way I am planning to write back-end code is: If Record exists for...more >>

Hello, I'm changing a website built by another. I notice that the writer doesn't ever close his recordsets, or set to nothing. But he does continually re-use the same variable (rs) throughout his code for different recordsets - always overwriting I guess. Is that ok coding? does it automatical...more >>

Hi, This is the followup of my earlier post. When I am issuing the first query comprising of just one table then, I get results back in asp page while when I run a query with joins I do not get back data in asp page. INITIAL CODE: myDSN="DRIVER={Microsoft Access Driver (*.mdb)}; " myDSN=myDS...more >>

Hi, I am trying to connect to a local Access Data from a ASP page. I do not have the latest version of JET 4.0 installed. Hence I am trying to use the native ODBC driver for Access: The following is the code for opening the sql. The z_SpecialCondition query is an Access query which is basical...more >>

Hi All Can any one help me please. I want to keep all IP addresses visiting my site, Is there any way to get the visitor's IP Number ( either using html or ASP [NOT .NET] ) Thank You in Advance M. Dwaikat ...more >>

Hi, I have a form with bunch of financial data fields. I need to display the data by use of back-end Access database. In order to fill in the value of the fields, I have to access three different Access queries in back-end database. My question is, can I simultaneously open those queries in ...more >>

Crossposted in general.asp - I guess this is a better newsgroup for my question - Sorry! Hi folks, I'm new in ASP so I need some help on a updatable query. I have an access db with the table SID_Master_Archief. From this table I would like to run a query showing six fields. The doc_date...more >>

I need to send an .ASP page as an email template using VBScript. I'd like to do so using CDONTS or CDOSYS. this is the dynamic email template http://www.womentowomen.info/emailtemplates/grid23.asp?id=122 the script needs to loop through a recordset and send emails using data from SQL 2000....more >>

Hi, I've got the following problem: I'm retrieving data from an SQL Server database (the data itslef was entered by an ASP form). And on an 'edit form' I want to display a checked box in the state corresponding to the value saved in the DB. But somehow that doesn't work!? SQL tells me...more >>

Hi, I've got the following problem: I'm retrieving data from an SQL Server database. And I want my form to display a checked box in the state corresponding to the value saved in the DB. But somehow that doesn't work!? SQL tells me the value is 1. My ASP page tells me it's 'True'?? S...more >>

Hi all, I am using a DSN to connect to the database! this connection works great and all is fine - EXCEPT - when I go to another page, it cant open the connection to get more information from the database! is this the way I have set up the asp coding? or the way the DSN is set up? or the fact t...more >>

Hi, Are there any known work-arounds the varchar(8000) limit on sent messages in XP_SMTP_SendMail? My current dynamic generated html messages are getting cut and I don't want to send them as attachments! Thanks in advance. Christian ...more >>

Im trying to work out an issue extracting the table schema from a database table. The script could be run against mySQL (MySQLProv, 4.0.22-nt ) , SQL server or Access With SQL, access, I can use #1 or #2 quite happily, however cant quite say the same for mySQL Using #1 for mySQL, the defi...more >>

The ADO is class object with an ID of <object CLASSID="CLSID:BD96C556-65A3-11D0-983A-00C04FC29E33" HEIGHT="1" ID="ADC" NAME="ADO" WIDTH="1"></object> This just from a web search : ---------- Remote Data Binding with Remote Data Service If your Web application provides clients with the abili...more >>

> does this mean you're trying to use ADO in client-side code? Its a page someone wrote sometime ago. The asp page was using Javascript inside it to run server side scripts. This refers to this thread, http://groups.google.com.au/groups?hl=en&lr=&threadm=Xns95B861E12F67eejj99%40194.109.133....more >>

Hello, I have a database driven web application that I want to distribute locally on a CD. Is this possible and how? I've read about a package called DWebPro that can do this, but the price tag is pretty steep. Thanks. ...more >>

In one old ASP application we have suddenly started to get the following error message: ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. The mysterious thing about this is that the code works well most of the tim...more >>

its seems to be having problems with some pages written in ASP on the intranet. The script debugger is calling this error: Error: ADO.Refresh is not a function Where ADO is an MS ADO object used in SQL retrieval. here is the code causing the problem. ADO.ExecuteOptions = 1; ADO.FetchOpt...more >>

In my store procedure i have variable and i assing to him diferent values. how can i pass this value to variable in my asp code. thanks ...more >>

I have an ASP application running on my server in which several users subscribe to. Each user has their own directory and their own Access database. Each user can download their own database to their local machine for backup purposes. Im looking for a Windows app or something I can script, ...more >>

Hi all again, Maybe, I'd better try to do this: How can it programmatically get/return the "Row source" or Rowsource property of a generic Table in a generic Access 2K database??? I found an example in VB: me!combobox.RowSource where "me" is the loaded form, but I am unable to apply it...more >>

When I purchased MS sql server 2000 Dev edition it came with an additional cd called ssql server reporting services......Could some help me understand what this is used for? The reason I aski is I am currently on a learing curve in generating sql queries that pull the necessary data out of th...more >>

I want to get a schema of all the tables in a database for documentation purposes, is it possible to retrieve the column name and datatype in sql server similiar to this: Column Data Type username varchar(40) human int password varchar(40) email varchar(80) role varchar(40) ...more >>

[This followup was posted to microsoft.public.inetserver.asp.db and a copy was sent to the cited author.] Hi, I have a W2k Server with SQLServer 2000 on it. Been using it for almost 3 years now to server a number of fairly small dynamic web sites. All my site connection strings make DSN...more >>

Is this possible? I will use the browser to nput data and use MS Access for generating reports? ...more >>

I have seen, when I get certain errors, that the browser can spit all the post data back out on the error page. Is there anyway to work with this post data? Like for instance, can I lump all the post data into a cookie? Thanks, Drew Laing ...more >>

Hi I am trying to retrieve information from the Access database using RADIO button. I am using UPDATE command in ASP. I am able to update the information using RADIO buttons. HOWEVER, I am not able to retrieve the previous value of Radio button (ie Yes/No) already available in the database befo...more >>

I have a page that has 75 textboxes, 25 each for Name, Relationship and YearsKnown. These are currently named Name1, Name2, Name3... Name25 Relationship1, Relationship2... Relationship25 YearsKnown1, YearsKnown2... YearsKnown25 How can I process this and insert only the data that is enter...more >>

I am using ASP 3 in IIS 6 with Server 2003. Just learning to use Stored Procedures and calling them using the ADO Command object. I have come across an error message whenever I try to use terms such as adInteger when using stored procedure parameters. The error is a VBScript error and says ...more >>