I have the SQL 2000 server with a database table having one 'text' data type column. This column stores the general text message (normally body of the email message) which the thrid party application inserts in I wanted to query this column and display on the html page using ASP The ASP code ret...more >>

I am using Table Editor 0.81 Beta, a generic database editor which I downloaded from the Internet, to edit my online Access database. The problem is that when I try to edit tables whose values are in Cyrillic characters instead of the correct values I see question marks ("???????.???" or something l...more >>

Ive got a db table with the fields Product_Name and Product_Price. I want to display a pulldown containing the product names and display the price of the selected product in a text box. Currently, I can do the pulldown but to populate the price text box, I have to refresh the page. How can ...more >>

Hi! Any one has Idea, How to use Server.Transfer and Server.Execute, When I tried to use these methods I got an eror: Server object error 'ASP 0230 : 80004005' Server.Transfer Error /SISWeb/portal_logon.asp, line 40 The call to Server.Transfer failed while loading the page. anybody is t...more >>

I am trying to run 2 queries against a Access2k database on a single ASP page. I have one query working beautifully, but am not sure how to execute the second one. At the top of the ASP page, I have: DIM objConn SET objConn=Server.CreateObject("ADODB.Connection") objConn.ConnectionString="D...more >>

When attempting to view information dynamically I get the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /autoforms/ViewContent.asp, line 8 The automaticall...more >>

Hi all, I need to dynamically pass records to my sql database using form with asp or javascript. Does any one has sample code for client side and server side or know where could I find some sample? Thanks for any advise. *** Sent via Developersdex http://www.developersdex.com *** Don't j...more >>

I changed the datatype of a field in a SQL Server 2000 database from nvarchar to ntext, but now nothing is being displayed. The "Body" column of the datatable used to be nvarchar(8000) and the below code works fine. However once I changed the datatype of "Body" from nvarchar to ntext, it no lon...more >>

When a web visitor has his/her browser text size set to large, my web page gets messed up. How can I fix the size of certain text (to medium)? I appreciate any help on this. Ken...more >>

Please help! I'm banging my head against a wall here. This is my first stab at ASP. I'm able to pass vars from a form to a search results page from Access for all fields EXCEPT date. I understand I need to use "#" around the date. Here is my form: This is my query code: rs_cal.Source ...more >>

Hello, Here's a good one for you guys. I appreciate any help you can provide. ClinShipPartNumber.asp Currently I have this page which displays a listing of part numbers in my database. I'm looping through the recordset and counting at the same time and assigning the unique number to the...more >>

I am trying to upload an image to the server from the browser using a form and an ADODB binary stream. The file successfully saves to the correct loaction and appears to be the correct size, but it wont display. When it opens it is all just binary like symbols. Here is the code: <%@LANGUAGE...more >>

Hi, Am getting the following error: cpeaut32 error '800a753c' Invalid enum value. & the code is as follows : set MyParam = session("Param").Item(4) NewParamValue = Request("prompt3") Call Myparam.SetCurrentValue(CDate(NewParamValue), 16) the stored proc refered in this repo...more >>

Hi, I hope someone can help. Any good developer will know how to correct this but I am just a beginner. The code below is for paging through my recordset. In the sql query, the parameters in the 'where' clause are passed from my index page. The code shows the first page of my recordset alr...more >>

I'm stumped. I can get the data adapter to fill with test results, but how do I tie it all together? I've got an adapter, a connection and a datagrid. How do I connect the dots? ...more >>

I am using an authoring program called Authorware to send student scores to ASP pages which send SQL INSERT and UPDATE statements to an Access database. Everything works well as long as I provide a value for each variable that places a value in one of the Access database fields. For both...more >>

Hi, I'm trying to do a sql query on a date column, like this SELECT * FROM [PSUSA] WHERE Call_Date = #04/01/2004# No errors in the statement, but 0 recordsets found. I have plenty dates with this. Also, my actual contents in Call_Date field has time as well. I just need to query on dat...more >>

How do I get around the recordset error "Item not found" due to a field not being listed? I run several queries according to what the user selects, and some of those queries don't always contain the same fields, but the template for the output is the same, so I would like to say something to the...more >>

I use ASP + SQL server 2000, one day I noticed that my scripts work rather slow... I found that it happens when I use 2 or more queries, for example, the following script <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "server3", "", "" Response.Write Now & "<br>" sql="SELEC...more >>

I am needing some help with a few asp pages and a login script. Let me start by describing my project. I am trying to connect to a database and verify a users login and password, then based on that login information display 3 pages based on their login. On the home page if they are NOT log...more >>

I am getting the adapter.fill method error if the web application is left unattented for sometime and if the user clicks a link or next button which access data. Is this due to script timeout or session timeout.If it is then how to avoid this I need to take the user to login page if there is a time...more >>

Hey all I'm not sure if there's anything that can be done about this or not. I'm displaying the contents of two different tables (using Access for development purposes, but when I go live we'll convert it o SQL Server) on an ASP page. One table, called NewAccts, contains (surprise) new accounts. T...more >>

Searched the NG but no luck. Im displaying records from an Access2000 db in a table. The table is within a form and each record(row) has a checkbox next to it. I need to create an update statement that will update each record that has its checkbox checked. How can I do this? Thanks! ...more >>

Can someone point me in the right direction. I want to be able to post a calander, with appointments that are drawn from a database. like someone makes an appointment, then they will show up on the calander with the booking that they made. so others can se what spots are open, and can also make ...more >>

I am having problems connecting to a MS Access DB that is on a network server (not local) through ADO/ASP. Here is the latest version of my connection string: 'set connmajors = server.CreateObject("ADODB.Connection") 'connmajors.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\server\a...more >>

HI There, I am trying to execute a union query which returns the total value of the OptionPrice column (amongst other things), when the results are returned the value returned by the union is correct but I cannot access this value via the recordset on my page, I have tried to alias the query h...more >>

Big apols. I posted this in the general one when I think I should have posted it in this one as it is more relevant. Please don't berate me! Rgds Rob ======================= Hi All I've noticed on quite a few ASP sites that when they have a 'MyAccount' section they transfer the sit...more >>

I'm trying to get asp to conect to a MySQL database, I've tried copying a few examples online that I found [there doesn't seem to be many!!] and I always get a 500 error with the code below. what am i doing wrong? any examples of a working connection string anyone could show me would be fantasti...more >>

Hi All If I run the below query: SELECT s.THUMBPIC, sd.STOCKNAME, s.STOCKID, sm.MANUNAME, s.QTYINSTOCK, (sp.NETAMOUNT + sp.TAXAMOUNT) AS PRICE FROM STOCK s, STOCKDESCS sd, STOCKMANUFACTURERS sm, STOCKPRICES sp WHERE s.STOCKID=sd.STOCKID AND s.MANUID=sm.MANUID AND s.STOCKID=sp.STOCKID AND sd...more >>

Hi All! Could someone please give me an example of a connection string for a flat file database or point me to a good resource for how I can build one? Thank you for any advice! Rob :) ...more >>

Hi I am trying to get the XML out of my Microsoft Access database, I am able to get the records from the database however not in the XML format. below is the ASP code for the same. What could be the problem. <%@ language=JScript %> <% Response.ContentType = "text/xml" var lobjXMLDa...more >>

I am writing an asp.net webpage. It has some code behind it that uses data from an excel spreadsheet. My problem is that instead of having the excel spreadsheet reside on the server with my asp.net webpage, I would like the spreadsheet to reside on the users computer. This way everyone has there o...more >>

What's the most efficient method for using multiple select statements from different tables? Open db connection once or open connection for each query? ...more >>

I built a database and asp display to be used in an intranet enviroment. All work well except one problem The main list has an edit link next to each person in the db. Each person has 6 check boxex being displayed representing products they have used. the problem is when you go to e...more >>

First, I apologize if this is posted in the wrong area ... it has to do with mySQL and ASP ... I had two fields in a mySQL table: cost quantity Both were of the type Int. I needed decimal places for the Cost field so changed both to be Numeric (also tried this with the type being decimal)...more >>

Hi, Before I've queried my Access DB using ASP pages. The SQL string then could contain: SELECT * FROM table1 WHERE date1>=Now(). This time round my DB is on a SQL Server and I'm still using ASP for this. But now the Now() function returns an error message!? 'Now is not a recognized func...more >>

I have an ASP app on the itranet with network users logging on with their network credentials. All the users have the same permissions to the folders as I do The app works fine when I run it. When another user tries it, the error says: "Microsoft Jet database engine error 80004005 canno...more >>

Does anyone have a simple code that will verify whether or not the DSN I had the ISP set up is working? I can't seem to get it right... Thanks, Jeremy...more >>

I have a web form with several fields. If I copy & paste from a RTF document into a field, the javascript validation and field length are bypassed and cause the form to fail. Any ideas? ...more >>

I have two sites: www.site_A.com & www.site_A_news.com Site_A is in d:\webs\site_a & uses an Access DB in d:\webs\site_a\data\db.mdb Site_A_news is in d:\webs\site_a\site_a_news also requires access to that Access Database. How should I setup the connection string so both webs can sh...more >>

Hi All Can I just confirm, is it true that Session Vars and Cookies from my main http site will all be lost when I ask the user to transfer over to the secure (https) side of my site? Although the http and https sites are hosted on the same ISP they are under different domains (as well as p...more >>

Hi All I submitted my schema last time and I think the verbose nature of my query put people off. In which case, I have simplified it into the below logic, which will hopefully make sense. I have one table (no special indexes or constraints - yet) that holds different currency prices. I...more >>

Is it possible to get the total number of rows and specify where clause in the same stored procedure. For instance, I am trying to get the the total number of widgets that = 'Toys' so I can get a percentage of widgets = 'Toys' for the widget category. Is it possible?...more >>

I need to save my user login information and am trying to use Session.Add("USERID","NAME"); But then how do I get that information out into a local variable? Thanks, Bryan ...more >>

I have an mdb stored in the "db" folder on an intranet webserver. The mdb is queried via ASP and Jet ole db connection. My permissions are all except "full control" Users can logon using their network user names/passwords. The problem is running the report that connects to the mdb, it gives a va...more >>

Hi, I'm new at this and having a problem on doing a query for multiple tables. Note: all tables have the same fields as well. Below is a what I tried. ---------------------------------------------- Error: The specified field 'call_back' could refer to more than one table listed in the FRO...more >>

OK, I know there has to be a better way to do this, hopefully someone can shed some light on this subject. Using SQLServer 2000 and VBscript ASP, I have a product page which is pulling data from many different tables: Tbl_Summary, Tbl_features, Tbl_Price, Tbl_Reviews, etc. using ProductID as ...more >>

HI There, I was wondering how I can add the total the value intTotalTax as I am processing a loop. I would have done this in the query but I wanted to break the display down showing all tax and totals seperate. Is there anyway I can acheive this in asp and just have one total value (intTotalTa...more >>

Hi, I've written an sproc which inserts customer data into a SQL table, then stores a variable as the unique id of the row (@orderid) ... then inserts data into abother table using this parameter @orderid The problem I have is although I can execute this sproc from my asp code ... I need ...more >>

Ive got a form that posts to an Access db and a few of the fields are of "number" type in the database. These fields do not require data to submit the form but if they are submitted empty, I get "Syntax error in INSERT INTO statement". Is there any way around this other than giving the fiel...more >>