I want to pull 2 different recordsets using 2 different stored
procedures using the same Data Connection. Below is the code that I
currently have, but I'm getting an 'Object Required' error message. Am
I doing this correctly, or at least headed in the right direction? Can
someone tell me the most efficient way (provide a code example) to pull
2 different recordsets from the same Data Connection? Code:
Is there a way of using multiple recordsets with the same connection?
My recordset at the moment inserts data into the database, and i want to have a drop down box with data already within the database, as well as the insert recordset, is there a way of doing this?
Am having trouble opening multiple recordsets - keep getting the er:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/eft/postflight4.asp, line 146
Have checked the permissions and the user has full access.
Code:
im building a site for a clinic. they want to have a calendar which displays the times for each day that are available for appointments.
at the moment i have a calendar on my page. i want to display the correct times for each day. should i use one big recordset that gets all the times/dates from the db or cycle through each day and create a recordset for each day that there are times available (some days the clinic wont be open)?
if i go with the latter option, i could potentially have 30 recordsets open. is there a fast way to execute recordsets.
I don't even know if there can be more than one recordsets on the same page so I'll concentrate on my problem assuming I'll need only one recordset. This time I won't need anything solved for me, just your thoughts please. Here is the deal.
I have a form with checkboxes with one picture standing beside them. Than, there is a table with 6 columns and x-rows. Every column is a different category and has a different name.
What I need is to populate the rows with data from the database but that should be sorted in the proper category (column) of the html table. There is a connection between the row value and the picture in the recordset. The first thing I thought was to make a 6 different recordsets from the same database (I don't know if that is possible), but than I was confused with the 'Do until rsXXX.EOF' part.
I have a single access database file with several tables, two of which are tblPanels and tblAssignedPanels. The table tblPanels has a panel ID number and a name for the panel. In the table tblAssignedPanels, there is a record ID, the panel ID of the panel that has been assigned, and the user ID of the user account the panel has been assigned to.
Then, there is a third table (tblManuals) that has a manual ID, the ID of the panel the manual is for, and the path to the manual on the server. What I would like to do is have a repeat region that lists all the panel names (from tblPanels) that are assigned to the currently logged in user based on userID (assigned panels found in tblAssignedPanels), and makes each a link using the path in tblManuals.
I am trying to connect to two different database(Oracle and Access) in my ASP page.
I keeps getting the following error message
Error Type:
Provider (0x80004005)
Unspecified error
What would be the best way to do the multiple database connection?
I'm building a page to display a series of records but wanted to filter the results by location and display the resulting records under their own sub-heading.
All the records are in the one db table and there'll be a total of 5 queries.
I'm unsure whether I need to open and close the connection for each query, or whether it's better to open one connection, run all the queries and then close the connection at the end, if so, the resulting code would look like: Code:
I have several ASP pages, and some of them are using the same access Database and table.
Can I put the connection string somewhere centralized, so I can link to it ?
I have been using php for a while now but have recently had to start using asp. I have purchased some hosting from webfusion.co.uk but have been having trouble connecting to the sql server, could someone possible help me here as I don't know what is the correct code to use to start with let alone know where I have gone wrong.
View Replies View Relatedi'm trying to use an odbc driver to connect from an asp page to a data source (dbase) on unix sunsolaris. is this poss?
the driver is installed though i cant seem to do it through dreamweaver ultradev - can i do it through the ftp connection?
what would i input as the source on the following to initiate the connection in the asp page?
"Provider= "MSDASQL"; Data Source= server name ?
"Database=test;User ID=sa;Password=blabla"
or how would i do it using the followign as an include file ? Code:
How can i pass more then one variable (within "href"), so that i can read the variables in the url using "request.querystring"?
View Replies View RelatedI need to have a table with 3 fields whereby the user can input the data and insert into my database using this website. However, I need this table to be dynamic so that after the user input the info for the first row, the user can click on add another row button and another blank row comes out. then the user can input the info for the second row and so on.
I am using ASP in the end to insert the data. I need some advice on how to create this kind of table where the user can click on one button to add another row and then able to insert all data in the entire table into database using asp.
number filename filesize
1 aaa.asp 123MB
add more data
How do i update multiple records?I used to put the values in an array after splitting them.But what i noticed was , if there are values that are seperated with commas in the field value itself then it is taking the field value to be 2 in number.for eg:
if my field1 has value of abcd,defg and my field2 has value 123.When i update my field1 is updated with abcd and filed2 is updated with defg and so on? How can i overcome this?i want the values to be updated correctly into their respective field.
Currently I have a combo box that shows records from a Select query using Group By. So it only shows each record type once. I can currently search for records using the combo box but I want to search for multiple records in the combo box.
For example, if in the combo box it shows records: Adam, Bob, Carl,,,etc.. Right now if I click on Adam, the search will bring up all of the Adams. What I want to be able to do is to be able to click on multiple records such as Adam and Carl and have all of the Adam and Carls show up.
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID
1 4
1 7
1 9
1 10
etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
I thought its more space efficient of displaying the data in multiple columns (let's say 2 columns for now), instead of one loooooooooong column in a table, are there a simple script of coding that can do just that?
How about 3 columns?
how can I display multiple access data on hyperlink in ASP?? For example like I click on Monday link it will only display all the informaton about Monday and click tuesday will only display tuesday information on same page.
View Replies View RelatedI have 6 textboxes where user can input data (or can leave it blank). I need to insert all the data (if not blank) into the database. How should be SQL query be like? ...
View Replies View Relatedi have data in multiple access databases (not multiple tables within one database file) and was wondering if there is a way with ASP to display selected data on one webpage from these different databases?
View Replies View RelatedI have let say 100 record from database, then I wanted to display in 4 columns, so each column will have 25 records. hot to d that?
View Replies View Relatedwhen user click a button data will be fetched from database based upon condition and it will be exported to multiple sheets of a single excel work book. what I am doing, onclick of button in main page, I am invoking a new asp page through document.location.href=test.asp.
In test.asp page created a instance of excel.applicaion and then fetching data from backend and putting data to different workbook cells of the the excel and at the end making excel.visible=true but the problem is excel file not getting visible on client machine.
But when I remove some server side code and put the rest of code inside vbscripting tag in the main asp page then the excel file becomes visible on client machine. I am not getting the where the problem lies in the first part .
I Need to collect about 400 pieces of text information (of various types and sizes) in about seven forms in seven different pages and post all the data finally to a database. I would like to know what is the best mechanism to pass data from form1 through form 7.
Users should be able to go to previous pages and edit entered data. Should I pass them as hidden variables or retain them as session variables or are there other more efficient ways to do this?
Also, I want to be able to later retrieve the data and porpulate the forms with the data so that users can edit the data and post it again. I am using ASP to do this (not .net). Any help from a generous programmer?
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies View RelatedHow to export data from ms-access database to excel worksheet. mainly i need to export data to multiple worksheets. it is very urgent to us.
View Replies View RelatedI am new user of ASP and as well as this forum, i want to make a web page, to enter data,in which , first user login page, then he enter data on his authorize database, database names are same as user login name.
e.g if someone login as user xyz he must open xyz.mdb, and if other login as abc he must open only abc.mdb to enter data, and data entry page must validate fields such that numeric fields, text fields, numeric lenght, etc
im building a page which has a few while loops. this means that im inevitably going to end up with about 20 recordsets on the page. will this slow the page down at all? its quite a lot of hits to the database/server. the results the recordsets will be returning wont be that big though.
View Replies View RelatedMy ASP code creates an ADO recordset object on the server.
Later on the same page, I have a javascript code snippet that I use to
dynamically populate a drop-down box based on choices made in another
drop-down box. Can this javascript (or a server-side equivalent)
How do I create a recordset from another?
e.g.
sSQL1="SELECT * FROM ThisTable"
rs1.open sSQL1,conn
sSQL2="Select * from (rs1?) WHERE name='fred' "
rs2.open sSQL2,conn
I create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank.
It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank).
I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is:
([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
Is there a performance advantage to parsing thru a recordset verus using an array?
I'm currently trying to populate a listbox by returning data from my database, then either parsing thru the recordset until I reach the EOF, or putting the data into an array.
I have never sorted a recordset - using rs.Sort - i have no problem sorting it in SQL.
All the tutorials i get say that i have to use a client cursor location, so this is my code:
Let's say you have pages 1 | 2 | 3 | 4 | 5 and you're on page 3. How do you make the code so that 3 will be without url?
View Replies View Related