I'd like to sort my stored procedure by the column name I pass in...how would I do so? CREATE PROCEDURE dbo.spHelpDeskGetItemsForHistory ( @SortBy varchar(11), @SortDirection varchar(4) ) AS SET NOCOUNT ON SELECT tblHelpDeskCategories.DisplayName AS Category, tblHelpDeskProblems....more >>

I want to create ASP page that shows the schedule of TV station. Since each day's (Monday - Sunday) schedule is different, and I want each day will display the schedule on that day of a week. I wonder if I need to create 7 different ASP pages and call different one on each day? This is just my i...more >>

Hi All, can i create a template in word and just put all the infomation from database using ASP? i have to do: 1. collect the information from the ASP forms in Oracle 2. the information what i collected should be inserted into an default word template. For the above , i need a sam...more >>

Hello All, I have a classical ASP form with multi-rows and multi-columns that allows users to enter multiple records at once. How do you check input forms for errors and, if necessary, display messages plus row number and field to the user? Thanks! Jean ...more >>

I have a form that queries a database by "day". The form values are the days of the week, but I want to add a value for "no preference" where the results would be all values. I tried to string together all of the days (i.e.: "Monday" AND "Tuesday" AND...) in the form value, but the query can'...more >>

I've run into this problem recently and I haven't been able to pin it on anything. I've been doing ADO connections to Access databases for small databases before, but now they aren't working. I've double-checked the ASP code on two different pages, one that works and the new one and they a...more >>

I'm made an .ASP application that uses 1 .mdb for login authentication, and 1 for my main database. My page is automated so that 1 file is created and filled with data from the main .mdb, then the application updates my database so I know which records have been downloaded and which have not. I...more >>

Hi i am trying to see if the query return some data but i am getting error:(0x80020009) Exception occurred. here is the code: if rstPart("partID")<0 then response.redirect("new_part_no.asp") end if thanks ...more >>

Hi I am saving data from ASP to an access database which has linked tables, i keep getting this errror: Microsoft JET Database Engine (0x80004005) The Microsoft Jet database engine cannot open the file 'I:\Access Database\980211be.mdb'. It is already opened exclusively by another user, or ...more >>

Can someone remind me on how to run IIS (and therefore be able to execute ASP scripts) without being connected to the internet. If I remember correctly it involves a loopback adapter. Thanks Terry ...more >>

Many moons ago, I did an SSADM course... in it I learnt the formal meanings of 'Compound' & 'Composite' keys... Recently, I was talking with a colleague, and where he used 'Composite', I used 'Compound', but strangely neither of us noticed the discrepancy and both of us were clear and in agree...more >>

I am having problems dowloading files bigger than 3 megs with .asp from an access db. Does server 2003 have a default download limit. Uploads I have been able to resolve. Thanks...more >>

This is the error that I get: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. It worked previously before I installed Jet 4.0 SP 8 b/c Access 2003 requested it. Database is in Access 2002 format. This is what I'm doing. ------------------------------...more >>

hi everybody ! now i have finally managed to build a upload/download file-part in my application, and it's working just fine, except for one detail. i use a simple form where the user can choose a file to upload. a also have a checkbox that should be checked if the file is a 'released' version,...more >>

I've looked at BOL and through dejanews for a solution (similar post from Lamine Darbouche on 30th July in this group) but cannot find a solution. I am trying to replace text within a field using the SP below. Alter Procedure cc_globalBodyReplace ( @toReplace varchar(255), @replaceWith ...more >>

I want to determine the operating system using ASP (or VBScript inside of ASP). I tried to get it using the Request. ServerVariables(EnvironmentVariable) method. On the web page about ASP in which I found this method, it gave a list of possible values for the EnvironmentVariable parameter. One o...more >>

+++++++++++++++++++++++++++++++++++++++++++++++++ REY, please don't reply to this post. I need someone to help me with this. +++++++++++++++++++++++++++++++++++++++++++++++++ Hi, I have no idea how to write .bat scripts, can you help me write one? Here is a pseudo code of what I would like th...more >>

I have to insert new records by a add_form.asp. the database is access. When I submit a record, if the DATE textbox is empty, I have an error because it appear access doesn't want empty record in date field!! I said "yes" to allow null in table properties Can someone help me? this is the e...more >>

I need to build a web page that allows the user to select a text file and click a button to import the file into a database table. Does anyone have any code that shows how to read a text file line by line and save that data into an ODBC database (not SQL Server)? The text file is not delimited...more >>

Hi, I have no idea how to write .bat scripts, can you help me write one? Here is a pseudo code of what I would like the .bat script do. For intFolder = 1 to 100 For intFileNumber = 1 to 20 IF k:\o\intFolder\intFileNumber.wmv file does not exist, THEN exit loop. sse45.ex...more >>

How can i build the easiest way an script which enables me to display an x amount of records per page? Friendly greetings, André ...more >>

Hi all, I have a field in Table A that must be updated whenever a record is added to Table B. Table A will always only contain one single record and one of the fields gets updated whenever Table B gets a record added. This is basically how I currently have it in ASP: 1. User inputs data int...more >>

hi!! This is my problem. Im planing this without success *i have 3 tables table1 table2 and table3... *The tables have some fields with the same name for example both table 2 and table 3 have the field "age" *The field id is a key select * from a table1, b table2, c table3 where a.id=ses...more >>

Hello, I have a classical ASP web data entry form with 20 rows that allows users to enter multiple records at once, my questions are: a.. How do you determine the number of rows entered by a user on the web form? b.. How do you save multi records to database? Please assist me. Tha...more >>

Say I ran a query that pulled 100 records with 10 fields into a RecordSet I'll call "rsQryResult" How would I: 1. write this data to a .csv text file and 2. Send the file to the user, with the "Open, Save, Cancel" download box appearing for them? Also, Can I set a variable value according to w...more >>

Hi Everybody: I have been given the task of creating an online coupon. The major challenge that I see right now is controlling printing so that only one particular coupon can be printed. If anyone knows how I can disable the printer after a coupon has been printed I would appreciate it. I u...more >>

I downloaded a simple login package that uses asp files to look in an access database, then go to an authorized user page or an unauthorized user page, depending on the result. Note: I'm working offline, trying to test this file locally. all the files required are in the same folder.- When I logi...more >>

I am attempting to write my first ASP code, and I'm having a rather tough time. My desired end product is this: A client clicks the link on my webpage that allows him to a logon and password. (There will only be 3-5 users) Immediately upon successful authentication, a query will access a da...more >>

Greetings On my ASP application I want to retrieve the number (Recordset.recordCount property) of records affected by a select statement, but I keep getting -1. Even with an example of W3Schools (avaiable at http://www.w3schools.com/ado/prop_rs_recordcount.asp) I get -1 and not the record...more >>

i'm trying to read data from SQL Server database using data reader and assigned it to a label in my asp.net web application. but when the button is clicked, nothing appears. please help, thanks. Private Sub btnTesting_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handl...more >>

Greetings I'm having problems adding records to an access database. What I want to do is very simple. Here is my code. __CODE_START__ dim sqlStatement sqlStatement="insert into Records(artist,album,format,label,tracks,year) values ('Pink Floyd','THE WALL','2CD','EMI',99,1979)" dim da...more >>

Using asp/ado/IE: Let say I have a recordset contianing 1000 records. I don't want to show *all* 1000 records in one long table on a page so how do I go about only showing say 25 at a time and putting a button or link at the bottom that says 'Next>>' and after clicking that the next 25 records s...more >>

I've a server (W2K Server SP4) where my sites can access to Access db. Sometimes, starts this error: Microsoft JET Database Engine error '80004005' Unspecified error /news.asp, line 65 If I restart the server all goes ok. What can be? thanks ...more >>

I have a SQL Server 2000 stored procedure that I execute from an ASP page. This stored procedure in return fires a trigger that sometimes takes awhile to finish processing (for various, known and reasonable reasons). I'm wondering how to call this stored procedure in ASP and then return contro...more >>

I know that vb has the len() function that will return the number of characters in a string. Does T-SQL have an equivelent for querying fields? For example, I would like to write a query that returns the number of records who's password field is < 7 characters? can I? ...more >>

(using IE/asp/ado) I have a few reports that all take the same parameter. I would like to give one input box and put 3 buttons next to that one inputbox for selecting which report to run on that parameter. I have 2 questions concerning this: 1) How do I pass to the asp code which button was p...more >>

I just started messing with asp/ado and have already worked through some issues with the help of this newsgroup. Thank you all so far for all the help! So far I just have one asp page that contians a form to input one parameter for a query/report. The same asp process the query. The form post...more >>

Is there a Setlocale code to display the euro symbol? example SetLocale("en-gb") will display currency formating (FormatCurrency) with the pound symbol. What about the euro? ...more >>

Good evening to everybody! Seen my bad knowledges ASP, and my little leisure time is for a long time that i looking for in the various websites (hotscript, etc etc) a script for the management of the articles / news for my personal web page a script would serve me with the possibility to inse...more >>

I'm storing questions for a user-defined quiz. I can store them in the order they are entered without any problem. But... The user needs to have the ability to re-order the questions if they wish, or insert a question etc... Currently, for the re-ordering, I'm either having to postback for e...more >>

I am new to asp/ado (I'll be starting with that line for a few months I'm sure!) and I need to learn a good way to display data from a recordset in a nice 'report-like' fashion in Internet Explorer using asp/ado with vbscript. Thus far I have just had to display records from a recordset in a t...more >>

Does somebody know how i can show an 'showmessage' containing the = build-sql string from my ASP page just before it does a POST to the = msacces database? Or can i save the result to disk just before it does a = POST? Friendly greetings, Andr=E9...more >>

Hi. I'm trying to retreive a Image in ASP from a Interbase Database stored in a Blob, the image format is a JPEG, any idea? -- Lic. Daniel Olivares ...more >>

Hi; The primary key in a table (SQL Server 2000) is: Numeric (9). Previously in our code the Primary key was INT but we decided to change it to numeric and now I can not get the code to work. How can one change a variable in ASP to NUMERIC datatype? I have tried: VARTYPE (Field) and ...more >>

I am not sure if this is the right place or not but here goes. I am new to ASP and I have inherited an ASP site. We are in the process of converting the Access database to an SQL 2000 one. I am getting the following error when we connect to the SQL database, but it works fine in Access. Can some...more >>

Hi everyone! I have a problem with a Access query that i have moved from a server with Swedish date format to a new server with US date format (mm/dd/yyyy). The query looks like this: SELECT id,name,datestamp FROM cafe WHERE datestamp BETWEEN #2003-10-01# AND #2003-10-23# ORDER BY id ...more >>

We have a copy of SQL Server purchased a few years ago and it has never been unpacked. We want to use it now with a few concerns. I appreciate if you could help to answer the following questions : - 1.) Does SQL Server 7 run on Windows 2000 server? 2.) If I install a new copy of SQL Se...more >>

Hi, My Script to run a Command-Line from ASP does not work. No errors are returned either. It is on IIS. The directory where the script exists is on Drive I:, The executable .exe is on Drive D: Do you see any problems with the script below? Can you help me modify it? <% Dim objWSS ...more >>

I am new to asp/ado (well and sql server)... this has been driving me mad for hours now. I have created an SQL statment using access query design. I used the sql view to get the actual sql statement to use in an asp/ado page. The data is on an sql 2000 server. So all I had to do is change the ta...more >>

Hi Guys Wonder if anybody has found a way round this one. First show a menu linking system as follows: 0 - 9 A B C D E F G H I J .... etc to Z Now I've already done it on MS Access driven sites, whereby you click on one of the above links and it displays all 'data lines' that sta...more >>