i 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 RepliesI 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
I need script or a link to a tutorial that will allow me to do the following.
User enters username and password site checks the username and password against database1
if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens.
I am new to this forum and really looking forward to being involved in the community.
I'm trying to pull information from two different databases, use it, and then put it back into a database. The program I am writing is one which will keep track of exempt employees' absences. At the end of the year, employees get to rollover the sick days that they do not use. Herein lies the problem. The information on how many sick days an employee is in an AD download on one server. The information on how many days that employee has taken this year is on another. I need to take that information do a little math, and then add those days into a different table on the same server that the absences came off of to keep track of their "sick bank".
I would like to just Loop the information, but I cannot put recordsets inside recordsets and I cannot create a view from two separate servers, so I am at a stop sign. Can I just take all of the users and the amout of sick days they have and put them in a text file and then pull off of the text file? I'm not quit sure how to do this.
I need script or a link to a tutorial that will allow me to do the following.
User enters username and password
site checks the username and password against database1
if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens.
I am new to this forum and really looking forward to being involved in the community.
The code below gives error when executing the sql, because ODBC can't connect to the second database (DB_ANA). Code:
strConn = "driver={MYSQL ODBC 3.51 Driver}; "
strConn = strConn & " server=localhost;port=3306;Option=16834;
Database=db_cciaa;UID=ivmn;"
Conn.Open strConn
sql = "SELECT SC.COGNOME, NA.VIA FROM DB_CCIAA.TB_SELEZIONATE AS SC LEFT JOIN DB_ANA.TB_ANA AS NA ON (SC.COD_FISCALE = NA.CF)"
set rsProva = conn.execute (sql)
It seems to me incredible that I couldn't execute a join between different databases in MySql, also because it isn't possible to create links to different databases as in Access I do.
Can you pleaseeee let me know if what I am attempting to do is possible? ....and how. I have a Access database at backend of my ASP site. Is there a way in which I can design a page which will pick up only the records modified/added today in one database and add those to another database?
Is transfer of data between two databases possible?
I am trying to write a SELECT query in ASP to retrieve information from two databases (that must be kept seperate :-().
I have managed it using Access using something similar to the code included below, which I have modified for ASP. Looking around this seems to not be possible in ASP, instead the general recommendation is to link tables??? I would prefer to do it using ASP. Code:
I use a multiple select in a form in an asp page. When I go to the target page, I want to be able to read out the items selected on the previous page. How can I do that?
<form method="post" action="compare1.asp" name="Compare">
<select name="motorcycle" multiple size="20">
<%While not RSItems.eof%>
<option
value="<%=RSItems("ID")%>"><%=RSItems("Brand")%> <%=RSItems("Type")%>
<%
RSItems.movenext
wend
%>
</select>
</form>
How can I read out the items selected?
How do you use SQL to recall and add data to MS Access databases? or is there a seperate way? ...
View Replies View RelatedI cannot figure this out for the life of me. All the tutorials I've gone though give code (and from what it looks like, wrong code) with absolutely no explanation?
My ultimate end is to read the xls file into a mysql database.. but I need some method, way or idea of actually doing this. Presently the data is an a .mdb database (so I can save it to different formats) but I cannot use the .mdb itself to upload the info (server disallows reading and writing from .mdb).
I've looked all over and there is no detailed method of doing this (all I really need is just the basic code for connecting to a .xls sheet (excel sheet) and then reading the data from a line and displaying it on the screen (there is no present tutorial that explains that, least that I can find)
I know the basic way of doing this when you have a static set of
spreadsheets but I need to be able to process different spreadsheets
every day. These spreadsheets are sent to us by an outside auditing
firm without named ranges. They have a consistent format. Is there a
way to read a specific set of cells without having a named range? Or
is there a way to name a range with ASP? I am open to any options
here. Going through and creating named ranges is the only thing that
wont work sicnce it would take more work than processing the files by
hand.
I wanted to retrieve email from mail server based on POP3 protocol through ASP.refer some good tutorial or example code doing this.
View Replies View RelatedI am storing PDFs as Binary data in MS SQL but do not know how to open the PDF files in ASP. Seperately, how do I capture the filename when I do a multipart/form-data?
View Replies View RelatedIs anyone aware of a 255 character limit when reading data from a particular Excel cell? I'm experiencing when pulling straight text from an Excel spreadsheet, which otherwise works fine. Right at 255 characters, the data is truncated and I only see that bit of information.I've searched Google and came up with a few registry modifications, neither of which fixed the issue. Has anyone else ran into this?
View Replies View RelatedI have a master table employee , which contains the details of employees .
i have to upload the the data to this table from thye excel sheet by using asp.
that is -- what i have to do is , I have to provide a interface to browse the the excel sheet by user , afetr browsing the sheet user will submit the page and i have to read all the rows of excel sheet and update the table . if id exists in the table , then update the data otherwise append the data . Code:
I Would like to know the code for reading/writng binary data.
View Replies View Relatedi am not able to read alphabet data from csv file using VBscript. In the following it gives error when i try to read the first record itself.
it gives the following error.
Run-time error '-2147467259(80004005)'
[Microsoft][ODBC Text Driver] Numeric field Overflow.
I am writing a asp code that can take values from user in html form, process it and display it back in some kind of report.
the problem i m encountering is that I have a field which is numeric and I want to compare it with tax-table like for example:
if value in field is 6 then I have to look into table in pdf file (tax table form 1040ez) to compare it with the value and then write it to appropriate field. the problem i m facing is that it's in pdf and also the data is so large (4 pages in pdf) that i don;t know how tocompare it .....
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 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:
I 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 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 Related