Displaying Information From Access Db
I am trying to better a process our dept. now uses. Currently a person updates a Word document throughout the day of of actions items, basically a list of issues with due dates, responsible parties, comments, etc..At the end of the day the file is converted to a PDF and posted on the intranet.
Seems a little stale. Is ASP and a MS access database a good approach to providing real-time reporting to ther client? i.e. a person could push a button labeled "action items" and be returned a printable, decently formatted page?
View Replies
ADVERTISEMENT
I've been searching for an answer to this for quite some time now and have found nothing, so maybe (hopefully) someone out there will be able to help me.
At my work, we have a lot of folders for different jobs we've done. And right now, we have more than one person making the folders for all the new jobs that we get. I am trying to make a database were it will only show the jobs that have not had folders made. In order to do this, I've created a field titled "Initials". I want the webpage to pull up all the records where the Initials field is empty, but I'm having trouble doing that. I've tried a few different things and have found no success.
I'm not having a problem accesses the database or updating it, just displaying the right information. I'll give a little illustration (because I'm never good with words):
Say I have 3 jobs: Job #1, Job #2, and Job #3. Someone has already made job folders for Job #1, but Job #2 and Job #3 still need to be made. Since Job #1 has been made, that means there are initials in the initials field of the database and thus, I do not want that Job being displayed on the "To Be Made" page. Job #2 and Job #3 do not have initials in the initials field and as such, I want to display those jobs....
View Replies
View Related
how to export ms-access tables information to excel sheet using ASP....
View Replies
View Related
It all seems to work well, but takes a large amount of time for the entire page to load, I guess due to the amount of records that get displayed, or maybe its the repeat region. So, Is there anything I can do in my asp code to speed these things up. Code:
View Replies
View Related
I have a commercial database written in access and I'm trying to display some images, jpegs, stored in the DB on web page. My code is as follows:
Response.ContentType = "image/jpeg"
sql = "SELECT PartImage FROM Parts WHERE ShortID='AAPTM01'"
Set rs = AMConn.execute(sql)
If not rs.eof Then
PicSize = rs("PartImage").ActualSize
if PicSize > 0 then
Response.BinaryWrite
rs("PartImage").GetChunk(rs("PartImage").ActualSize)
end if
End If
set rs = nothing
All i get on the page is the image not found icon with the red cross in IE.
What could possibly be going on?
View Replies
View Related
I need to display multi-paragraph articles from a field in my database, but every time they display, they come up as one long paragraph with no line breaks, even though there are breaks within the database field.
I am using MS Access 2000 with field "data type" set to Memo and MM Dreamweaver UltraDev. What do I have to do to get the line breaks in the appropriate spots?
View Replies
View Related
i am producing a e-commerce website using ASP. My database is MS access using a database called products.But heres my problem, the database holds the images using a OLE object. But when i come to view the data on the website, i can get the data showing such as price, product id and other information but when i try and view the images from the database on the webpage it comes up all garbled like wildcards.
View Replies
View Related
I know not to store images inside a Db table using the ole method, but I don't know how to call an image to accompany text in a for loop script.I can provide the unfinished script (missing is the coding of the fields: Pic1, Pic2, Pic3, Pic4) for inspection.
View Replies
View Related
I am trying to display a vaule from access (which is set to currency in access) as a currency (2 dp) on a web page. Here is the code: code:
Dim rsDB
Dim strSQL
Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )
rsDB.Open strSQL, Application("strConn" )%>
<p><b>Product:</b> <%=rsDB("ProductName" )%></p>
<p><b>£</b><%=rsDB("ProductPrice" )%></p>
<% rsDB.Close %>
Should be easy enough, but I'm just starting out.
View Replies
View Related
I have an Access database set up with a number of text fields and a hyperlink field which references a different image per record. I am trying write ASP code to retrieve allt his data and images onto a web page. I have the data but the images are causing a problem.
The code I am using is as follows:
For the data: ....
View Replies
View Related
I've created a db field with Memo type, and I have stored some text with
carriage returns (no html) So the 3 words start on a differnt line. In
access this displays correctly ( each word starts on a new line).
However when I display these on a web page all the words appear on the same
line.
I need the words to be displayed on a seperate line.
View Replies
View Related
I have a drop down list which pulls Names from a column called 'Name' from an SQL Server view.
In this view is another column called 'ref' and each person has their own unique ref no.
I have linked a drop down list to the Name column (so user can pick name from the list) but now after selecting a particular name, I want my page to also display the corresponding ref for that particular name underneath.
The ref can be displayed just as text on the page.
View Replies
View Related
Using ASP, I'm fetching a currency datatype from an Access database. When displaying the results, it shows "2" instead of "$2.00"
I know about FormatCurrency, but if the datatype is currency, should it not come out looking like currency?
View Replies
View Related
I am calling the values from a table and displaying them in a table, no biggie, i have not used a for loop to create the Html table, rather i have created it myself using a for loop so i can specify the table values i want.
What i am calling from the table is All of the fixtures for the football games in a season but i want to put a seperator or insert a spece of some sort just to seperate the fixtures by date otherwise it just comes out in a long list of fixtures, no nice on the eyes.
here is the code from selecting the data form the table to displaying it:
View Replies
View Related
I have a database page with a table. I am using ASP and MSSQL on a Windows 2003 machine.
When I get the database information displayed in the table, I have something like the following:
<table>
<tr><td>row1</td><td>row1</td><td>row1</td<td>row1</td>
</tr>
</table>
The table has a total of 167 row that would be divided into five categories.
How can i get the above table to show:
<tr><td>row1</td><td>row2</td><td>row3</td><td>row4</td></tr>
View Replies
View Related
i'm trying to add the data of such client, some of his data have been added already but if i'm going to add or update his data (additional info.) what happened is the data is being added into new row not on the specific client. Code:
View Replies
View Related
I would like to email detailed error information from my website when an
error occurs.
I tried to use "On Error Resume Next" and if an error occurs check the Err
object and the AspError object returned by Server.GetLastError(), but I
didn't get the same amount of details as I can see on the browser's window
if I don't set "On Error Resume Next".
Is there a way to get detailed information from IIS ?
View Replies
View Related
I'm have a page which requires considerable database processing before writing the results to the page. I therefore wish to have a "Please wait message" up on the screen whilst the main page is processed.
I've tried Response.redirect hoping that the previous page will stay until all processing on th main page is complete and id drawn but this is not the case.
View Replies
View Related
When I submit information i post it to a page and when it’s reloaded it runs as code accordingly if I refresh it re runs the asp because the information is still posted. How do I clear the posted information? Or possibly after it runs the asp code alter a value in the posted information.
View Replies
View Related
I would like to have my application send a 'request' to an ASP page on my server. something like:-
http://www.mydomain.com/registration.asp?name="Fred"&age="25"
The browser then displays the full URL including the
parameters: name="Fred" and age="25"
Is there any way I can send the parameters without them appearing in the URL.
View Replies
View Related
how can i retrieve information on a form page that once previously submitted by the user so that when the user goes back to that form page it will remember what they inputted instead of having them to retype it again? do i have to use session? can somebody please help me... what would be the easiest and most efficient for a newbie to tackle this problem?
View Replies
View Related
I have an update page, when user changes their info. Click update button then go to the update.asp:Code:
LastName= Request.Form("LastName")
Conn.Execute "Update UserInfo SET UserID='" & UserID & "'
'Send an email to confirm…
'Thanks for updating your information
If I refresh the page, it keep sending email. How can we prevent sending email if he/she keep refreshing the page (do not want to disable the refresh button).
View Replies
View Related
I've an ASP page in wich the customer write his card number for the payment. How can I make this information secure when it's sent to the server?
View Replies
View Related
I have a login page, which is not in SSL. However, the script that processes this information is. While that information passes to the login page to the page that processes this information, is this information encrypted?
View Replies
View Related
I'm trying to make a web site that get user hardware information (processor's id and motherboard's id, one of them at least).there's been already one week and nothing yet.I have 2 servers:
windows 2003 server
windows XP professional
both have wmi and iis
View Replies
View Related
I am looking for tutorial and/or help on regards to accessing information using SOAP using ASP. I'm proficient in ASP, but know ver little about SOAP and XML.
View Replies
View Related
how do i insert two bits of information (email and emailend) into the one database field "email"?
Code:
SQL = "Insert INTO users (uid,pwd,firstname,lastname,email) Values ('" & uid & "','" & pwd & "','" & firstname & "','" &
lastname & "','" & email & "')"
how can you do that?
View Replies
View Related
I use ASP to check users data they submit. In particular, I'm checking for credit cards and I also use a server component DynuCreditCard. It basically affirms that the number "could be" a real credit card number.
Anyway, I cannot get through the website without having a legit CC#. None of the handful of testers that help cannot get through without a legit CC#. About once a month some user gets through with a blank credit card field. How do you troubleshoot something like that? I can't replicate the problem. Do you just say... "oh well... there was a computer glitch"...? How can I approach this problem?
View Replies
View Related
If i have a combo box, automatically when the user changes the item, i want to display information from the database within a textbox, without having to go to the next page.
Currently i only know how to do this by going onto another page.
In VB it was a simple case of calling a procedure, how does it work in ASP? If i need to call a procedure, how would i do this in ASP. The example in w3schools passes the variables, can i do it without it?
View Replies
View Related
How do i search for user based on specific fields? I have a checkbox beside each field of Name, User ID, Email. There's a textbox beside each field for the user to fill up. How it suppose to work is the user would fill up the textboxes and check the appropriate fields to search on.
It can have a combination of searches like he can search on the name and the user ID or all 3 fields. I was thinking is it possible to store the textbox information into the checkbox of that field and retireve the information?
View Replies
View Related
I have a table that contains information that I need to export to a .csv file without manually saving the file, e.g click a button, information is passed and saved. I have no problem geting the information from the table, just exporting it into a .csv and then saving.
View Replies
View Related
I am working on a project involving pulling information from Active Directory (Name, email address, contact no.) and sticking this information in some SQL tables. Using ASP, How do I enable windows authentication (username and password from active directory) ?.
In other words, when the incharge user wants to login to the tables on the web, he must use his/her windows username and password ? On the same project, I want to assign different groups with different security levels. (something similar to the Active Directory security groups), and let the admin asign rights to each group in order to control access and privilege of each user within a group.
View Replies
View Related
how to store information after the ? in the url in form fields. i.e. http://url/test.asp?User=Rob in Form Field UserName .
View Replies
View Related
