Hello, I hope you can help me with this issue... I need to be able to retrieve the values in a form that is dynamically created. I have the following in the form, for example: First Name Last Name Date Ken Smith 9/30/2004 Jim Jones 9/30/2004 Mike Alder 9/30/2004 Everything in the...more >>

Hi folks, I'm pulling subtotals from several tables. I've written the query below, and was wondering if some sort of join structure would make more sense. Thanks TomB Declare @MealsSubtotal money Declare @MealsPST money Declare @MealsGST money Declare @MealsTotal money Declare @Even...more >>

I have a table called responses: RID int identity, Question1 int, Question2 int, Question3 int The user has the choice of answering questions with a value of 1 = good, 2 = OK, 3 = bad. OK, I ran this query to get the number of good, Ok, and bad results: ---------Query Start ---------...more >>

I have an ASP code like this (in wochange.asp): ========================== <% Set objWO = server.CreateObject("MaxAsp.WoAccess") set rs = objWO.WoStUpdate(request.form("Wonum"), request("Status"), request.form("HiddenID")) set objWO = nothing %> =========================== And I have a DLL ...more >>

Hi All! I am using POST in my page, but there are some places where I provide generated "links" to detail pages etc and I revert to building a query string in the URL to provide the page with appropriate data. I heard that there is something called "sql injection" attacks or something.. and...more >>

Hi All, I am trying to change all of the software I have written for my company into web based applications. So far I have managed with the transition. I have got to a point where I am trying to retrieve a variable from one form to another. The source form comprises of a file upload using AS...more >>

Hi All, I am accessing a memo field with a line like this: <%=(pagesRs.Fields.Item("notes").Value)%> but I find the text is being cut off at 256 characters. Is there a special way to access a memo field? Any advice would be most appreciated! Rob :) ...more >>

I receive error when connecting to MS access DB with password. Microsoft JET Database Engine error '80004005' Could not find installable ISAM. /lpo/common/cnlocalpo.asp, line 4 Here is my string: cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AccessDB\LocalPOData.md...more >>

Hi, I have two tables. One contains Titles of Music. The other one contains Scores. The relationship is based as follow: Titles!TitlesID is linked with Scores!TitlesID (Many scores can exist for the same title). In the Scores table, there is also a field call "VisibleForWeb" (True/False...more >>

Hi I have a form where the content of a TEXTAREA are one of the values posted to an .asp page which insert the values into a SQL database. For years I've had several converting routines to deal with "programming" charatcers such as ;@*'- which makes the SQL statement fail. Is ther a "smooth" ...more >>

Hi All Sorry to be irate, but the whole concept of Server.MapPaths really has me in a tiswas!! In order to confirm once and for all, could you please advise me on the following: 1) There is no difference in putting '/' or '\' in the Server.MapPath param, eg Server.MapPath("/fred/test.asp...more >>

Can someone give me some sample code on how one would go about executing a command line "command" from within an ASP form? We need to run an application called GnuPG which allows us to encrypt an email. Preferably some documentation directly on this would be good but any other docuemtnation...more >>

I read text files in ASP on server side, then try to enter data into a database in SQL Server. The files are in ibm852 (1250) coding - at least that's the code page with which they are shown properly when putting the lines read on the output. However, when I enter them into the SQL Server (cur...more >>

Hello all... I'm working on a report to show turn around time for jobs. Each job fits into a single category, and I'm trying to show the time from start to finish. sort of like... category start_month finish_months Oct 03 Nov...more >>

I have an ASP app that creates a text file from data in a SQL 2000 database (both SQL and IIS are on Windows 2003 servers, but not on the same server). This process works fine on some clients (IE 5 or IE 6 sp1), but some of our other clients (same versions of IE that work at other client sites) n...more >>

Hello guys I have one table called tblUsers which contain userid and password. The table is in microsoft database. Basically I'm developing login page tht validate with table data userid and password. Below is my sql sql = "Select * From tbluser where user_id='"&Request.form ("tx_user...more >>

Hi, I have an ASP.NET application (C#) on a 3 user system. The pages are relatively simply (datagrid ect.) consisting only of a few ASP pages. There is nothing too suggest an extremely high user usage, however the application has of late had to restart once a day due to high memory usage (60%)...more >>

I have created a site shopping cart in ASP.net. I am using ASP session object's SessionID on non SSL connection to track session. While adding products to cart DB I insert product and SessionID in table. All products and cart status pages are on non SSL connection. On checkout to get secure...more >>

For web application development what is the prefered datatype for storing dollar amounts in SQL Server 2000. decimal : smallmoney ?? ...more >>

I'm having a very frustrating problem...I've got two pages, each of which are supposed to do basically the same thing, but from two different tables. Both use SELECT TOP n in the SQL statement to get only a certain number of records. One of them works (only returns 3 rows) and the other does n...more >>

My web hosting service just upgraded from Windows NT4 to Windows Server 2003. My web pages kinda stopped working after this move. After playing around and finding out why it wasn't working, I narrowed it down to this: I cannot open 2 connections to the same MS Access database on the same page. ...more >>

From what I can tell by looking through the responses this appears to be a general problem that often results in general responses. To help anyone who wishes to provide assistance, I will provide as much information as possible: Webserver: W2K Server, IIS 5.0, ASP not ASPX, Share Point/FP Ext...more >>

I have an asp page that opens a large sql table of email addresses and sends an email newsletter to each recipient. My problem is that the table contains over 8,000 addresses and the page times out after sending about 800 emails. I've tried using Response.Flush after every group of 25, but th...more >>

Hi! Why doesn't the following code work? Sub Session_OnEnd Dim Conn Set Conn = Server.CreateObject("ADODB.Connection") Conn.ConnectionString = Application("Connection_String") Conn.Open 'here is the error .... End Sub A Conn object is created the same way in Session_OnStart and...more >>

Can anyone tell my why I'm getting the following error, please, and recommend how to fix? Microsoft JET Database Engine error '80040e11' Invalid field definition 'ID_subtype' in definition of index or relationship SEE DOWN BELOW WHERE I SAY "ERROR IS HERE" [clip] set objColumn = serve...more >>

Hi all, I have been coding in ASP for a while now using VB script as my language of choice. Just wondering what the prefered language for most professional developers out there is.. Is jscript or javascript a better option...?? Why???? AK Replys appreciated!!!! ...more >>

I am planning to migrate my exisiting MS Access program that uses yes/no fields (checkbox). Can ASP identifies checkbox field of ms access? I am planning to use the same database and use msacess for report generation and web browser for encoding to the database. Hope you could help me. Me ...more >>

I'm inserting this 00111 into a one column table in sql server 2000. It keeps changing the value to 111. How can I get it to insert the information keeping the leading zeros? Please let me know. James...more >>

I have a strange problem (to me at least). I am using SQL Server 2000 with ASP and ADO. I created a stored procedure as a user and granted permissions to it to my 'webuser' user that I use to connect to the db. I can execute this sp just fine if I connect with my own login but when I try to us...more >>

Okay I think my title line was worded misleadingly. So here goes again. I've got quite 20 identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: (a) sy...more >>

Hi - I've got quite a few identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: (a) sync all MDBs designated to match one I've added some fields/table...more >>

I've got a webpage that calls some stored procedures with input variables. The procedures return recordsets and also some output variables. We're trying to get the values of the output variables. I've done this using the method I found in MSDN, as shown in the code below. The problem is that we ...more >>

HI, DO YOU KNOW THIS ERROR??? Tipo di errore: Errore di compilazione di Microsoft VBScript (0x800A0411) Nome ridefinito /pcwitalia/LMS/Select2/BASKET/adovbs.inc, line 14, column 6 Const adOpenForwardOnly = 0 ...more >>

I need to be able to create highly formatted text in Word, copy and paste it into a form on a webpage, post it to an Access database using ASP and query the database and present the formatted text in a webpage using ASP. Just to make matters a little worse, I also want to be able to search the...more >>

Hi All, I think this problem might be my SQL, but I am not too sure at this point. I have the following tables: The pages stores string data about a bunch of url's. pages: - title (pk) - pageUrl - notes The subjects tables stores a list of string keywords I wish to relate to the url...more >>

Sincere apologies to the repliers who read and replied to my previous effort. It was late at night and I clearly hadn't put down all the required information. I am getting the following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Ac...more >>

Hi, I would like to know how retrieve the primary key value in a local variable when I use the SQL INSERT statement to add the record to a table. The primary key is recipient_id in the resipient table. Here is the code I'm using: FUNCTION addRecipient( orderID ) sqlString = "INSERT INTO re...more >>

I downloaded this asp script and I cannot get it to work as my reference book does not give examples like this. the asp file is in the "WWW" directory and is called vote_db.asp the access db file is in a directory called 'DB" and is called votes_db.mdb the DSN is called votes_db (i chos...more >>

Im trying to fetch the details of the database design in this way : Set objRS = objConn.Execute("Select TOP 1, ColumnName,ColumnName,ColumnName,ColumnName, * from Table") For each fld in objRS.fields att= att& fld.name &","& fld.definedsize & "," & fld.Type &"," Next Works ...more >>

Hello, If I do this: SELECT bla FROM a, b, c WHERE a.fff = AND b.sfdd = AND c.asa = is it any faster than doing something like this?: SELECT bla FROM a LEFT JOIN a stuff LEFT JOIN b stuff LEFT JOIN c stuff Thanks, Mike...more >>

Hello - I recently purchased Camtasia for our training folks to begin recording videos on how to use various inhouse applications both for our customers and internal users that access our Extranet website. If anyone is familiar with Camtasia, they should know that it can output files in var...more >>

I know that we can write some queries and save that queries within Access I would like to know can I access thoese saved queries in ASP? Just like ASP call SQL Server's stored procedure Thanks ...more >>

Hi, I have some questions about recordset and memory size. I have a Access table with 1 field: one text (50 char). The table contains 20000 records. Question 1) When following code between <% %>is executed, everything happens on the server, right? Sofar, there is no transfert to the client...more >>

Hello guys I have table called theList in sql server 2000 and field say postcode tht containts postcode. I want to search records, 2 records up and 2 records and one exactly match exactly tht match user input post code... for example let's say we have data like this... 2345 2785 45...more >>

Here is the problem I am having. I have this script: var1 = Request.Form("date") var2 = Request.Form("course") var3 = Request.Form("addey") var4 = Request.Form("par") var5 = Request.Form("rnd1") var6 = Request.Form("rnd2") var7 = Request.Form("rnd3") var8 = Request.Form("rnd4") var9 = Re...more >>

The text below is the SQL statement used in Access to generate a valid query SQL = "SELECT tSNOBsTeamSelections.TeamName, tSNOBsTeamSelections.Player, PlayerPerformances.Total FROM tSNOBsTeamSelections LEFT JOIN PlayerPerformances ON tSNOBsTeamSelections.Player = PlayerPerformances.Player G...more >>

Hello, I am trying to write a function that uses .getRows and processes the array into an array of scripting.dictionary obejcts. The problem has been returning the array of dictionary objects. Here's my code: Function getDictFromRecordSet(strQuery, arrFields, intStart, intRows) Dim arrR...more >>

Hi All Could somebody post me the conn string I would use to enable my ASP page on 1 remote web server to connect to an SQL db on a completely different remote SQL server (windows 2000), which uses Windows authentication. SQL authentication I am fine with, but Windows authen confuses me as...more >>

Hi All I'm having problems connecting to a remote SQL server with my ASP page, even though I know this page works fine on another remote SQL Server that I ran it on. Basically my ASP page is on a remote web server (ie with my ISP) and it queries and reports data back from an SQL Server o...more >>

Hi! I use DB Paging from asp101 (http://www.asp101.com/samples/viewasp.asp?file=db%5Fpaging%2Easp) and works properly. I want to modify the page navigation because if I have 4000+ records and I want to view 20 records per page, meaning to say, it will write page 1 to 200 beneath the page. I h...more >>