Searching Access Databases And Their Embedded Documents.
I've had a look and found a few items on searching a database but I need something a bit more complicated.
I want to store documents in a database, I also want to have a web page view and pdf download of the documents available (easy enough if I just embed the URL of the locations). The problem is I want to also be able to provide a search page that allows the user to search the documents and the database (for authors, date etc) using the same page.
So the question is what's the best way to start with the database and pdf docs and end up with a web view and search engine for it. The database is Access btw.
View Replies
ADVERTISEMENT
I'm making a new database that is to store details about word/pdf documents. I need to have a search function that can search through the content of the file. Is this possible? [I'm using Access].
View Replies
View Related
I'm trying to design a simple website with 2 dynamic searching functions. The first is the user enters text into a search box, clicks on the search button and then connects to a sql or access database and brings back those records that are LIKE the search phrase. It's my intention to then have a detailsview link on the searches so the user can drill through.I'm designing an online version of my catalog so that the user can browse by page. I also want the user to enter a page number and then click go and that would then take the user to the corresponding page in the catalog. I'm guessing I'll need to declare If 1 then open page1.html, if 2 then open page2.html.
I know I'm close but not close enough and my knowledge has been well and truly stretched and I must have read and read my Dummies book about 20 times over the last week.
View Replies
View Related
In a search form how does one stop the form from running when a certain character is entered.
Such as "%" also even if i add 5 of the characters. I have been to a few sites and this goes and gets all the records.
View Replies
View Related
For my ICT (computers) project at college I'm using an Access database, and I now have a problem with that. Basically the way it works is that the user enters their details in a form page (here). This then does the usual thing; runs a script which inputs the data into a database and then displays a thank you message.
the problem I'm having is that whenever I input punctuation into the form, it refuses to work; it comes back with a 500 server error. This is understandably quite irritating, as I'm setting up a mailing list that needs to incorporate a list of email addresses
View Replies
View Related
I have a search page with an access database in the background.
When you type in a keyword, it brings the related article up.
Is it possible for this to display a hyperlink??? When i choose hyperlink in the access field it displays thefollowing on the screen: Code:
View Replies
View Related
Currently I have a site running in ASP on Access databases. Should I make the switch to ASP.net/SQL? I don't know much about the two. Can someone tell me?
Also, how easy would it be to convert ASP coding to ASP.net and Access DB's to SQL?
View Replies
View Related
Is there a way to upload a file first to a directory (which is have done) and then either upload it to a database or referance it within a database
View Replies
View Related
i've googeled to find a asp-script that can compare all the records in two
different access databases the mdb's have exactly the same tables what i want is that (the output) all the differences comes in a html-table in a webpage can anybody help me, are give me a example ?
View Replies
View Related
How do you use SQL to recall and add data to MS Access databases? or is there a seperate way? ...
View Replies
View Related
I have a simple intranet for the company I work for and I am attempting to create a phone listing and search tool for it. The list has a simple 500 record access db.
Presently I have a page which displays the entire db. What I'd like to do is have a form at the top of the page that lists the entire db where a person could type in any word... Name, office location etc and have the result ported out on a new page with only items matching the search criteria. Code:
View Replies
View Related
if I can search a access db. I have a cm system where all data for pages are held in db field updateable by the user but I want to search the page_text field of the db so that I can offer a site search on my site. I have done it with SQL db but I not done with access?
View Replies
View Related
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
View Replies
View Related
my problem is that i want to convert my web pages into Arabic. and for
this I have already install Arabic font in my pc but the problem is that
once i select that specific Arabic font the text is still written in
English . Can u please suggest me some embedded Arabic fonts which are
when selected will write Arabic rather than English.
View Replies
View Related
My readers that are lotus note user receive the mails I send using cdonts with image displayed as attachement in place of inline.
I read http://www-1.ibm.com/support/docvie...uid=swg27002572
that say "for displaying image inline in lotus you must set correct
mime header as content disposition : inline"
however I can't achieve it with cdonts : my mime header is stuck to
"content disposition : attachemnt" and I can't see how to change it.
I read somewhere that using attachurl instead of attachfile will fix
it but my test did not achieve this way.Any of you experienced sending inline image to lotus note users with cdonts ?
View Replies
View Related
I have a checkbox in a form and i want it to create a session if clicked. If it is not checked the session is deleted. I have tried the code below but it always creates the session even if the check box isnt clicked.
<input type="checkbox" id="txtValidate" onClick="<%session("checked")= "true"%>" />
View Replies
View Related
I have a logon field including user name and password, which is stored to an access DB. Many websites have a logon and password field integrated into the page. I want the field to always be there.
When successfully logged on, the user will have access to other pages that I designate.
I have a complete web page and I want to stick the code from the working logon field, etc in the page w/o redesigning it around the existing logon.asp page.
I am asking if this is something I can do with the skills that I currently possess? Remember, I'm a novice .asp programmer, but an experienced web designed. We're working on the "dynamic" in web page design.
View Replies
View Related
I want to know when we embed javascript or vbscript in asp pages where the script runs whether on client's browser or web server? also is there any possibilities like in asp.net we have "runat" wherein we can specify sever or client option available when we are programing in asp.
View Replies
View Related
I have embedded a flash movie (.swf) in my web page - but I don't know how to put the "play,pause,stop,volume" controls to the video.I need the movie to share with my colleagues at work using our local web server.
View Replies
View Related
I want to send email in html format with containing more images added dynamically using cdo.message method. can you pls explain any body one how to do this. i alredy done this, but it send only one picture with that email. here i posted my code also. pls any one tell me what is the problem in this code.
theSchema="http://schemas.microsoft.com/cdo/configuration/"
Set cdoConfig = server.CreateObject("CDO.Configuration")
cdoConfig.Fields.Item(theSchema & "sendusing")= 2
cdoConfig.Fields.Item(theSchema & "smtpserver")= "smtp server"
cdoConfig.Fields.Update
Set mail = Server.CreateObject("CDO.Message")
html = "<html>"
html = html & "<head>"
html = html & "<meta http-equiv=""Content-Type"""
html = html & "content=""text/html; charset=iso-8859-1"">"
html = html & "</head>"
html = html & "<body>"
html = html & "<p><font face=""Arial"" ><b>Name: " & name & "</b></font></p>"
html = html & "<p><font face=""Arial""><b>Company Name: " & cname & "</b></font></p>"
html = html & "<p><font face=""Arial""><b>Country: " & ctry & "</b></font></p>"
html = html & "<p><font face=""Arial""><b>E-mail: " & email & "</b></font></p>"
html = html & "<p><font face=""Arial""><b>Details: " & remarks & "</b></font></p>"
html = html & "<p> </p>"
for i = 0 to ubound(iid)
html = html & "<img border=""0"" src=""" & "http://www.abcd.com/img/" & fnme(i) & """></td>"
next
html = html & "</body>"
html = html & "</html>"
mail.From= emailFrom
mail.Configuration=cdoConfig
mail.To = emailTo
mail.Subject = emailSubject
mail.HTMLBody = html
mail.Send
set mail = nothing
set cdoConfig = nothing
View Replies
View Related
I have an application in ASP that exports to Word using the Response.ContentType method.
The application references another ASP page through the img tag that uses a Response.BinaryWrite (of an img content type) for its output.
In other words:
App A.ASP contains the code: [...] <%Response.ContentType =
"application/vnd-msword"%> [...] <img src="B.ASP">
Then B.ASP contains the code: [...] <%Response.ContentType = "image/png"%>
[...] <%Response.BinaryWrite BinaryObject%> [...]
When Word opens and the document is saved, it references the images as links. I need to have these images be embedded as the file will need to be emailed outside of the network.
I can go in and manually break the links and save them as embedded files, but this process needs to be automated as users will not know how to do this.
Is there a way to force these images to be embedded instead of referenced as links when the Word doc is intially created?
View Replies
View Related
I have been using the CDONTS.Newmail object for a number of years to send
nicely formatted HTML Emails with inline images.
I am now trying to switch over to using CDO and I cannot reproduce this
functionality. I am using the AddAttachment method instead of the old
AttachURL method but the attached images just show as separately attached
files rather than in line in the HTML.
According to MSDN:
"If you populate the HTMLBody property before calling the AddAttachment
method, any inline images are displayed as part of the message."
Well, I am doing that but it is not working. The images show up as if I had
attached them using the old AttachFile method.
Code follows....
View Replies
View Related
I have created a word template containing logos. I want to be able to open the document and dynamically add data to it and save the file as something else. the problem is when I use the streamobject method it does not work! I can only add data if the file is a notepad (unicode file). Is there any way to do this? I can't find any ttutorials on the web.
Also I know how to write word documents using html and I cant use this method because when I open the document the image will not display. Is there a way to keep the image contained within the document?
If I can get either of the methods above to work that it would have solved my problem!
Or if anyone knows of other ways to creating a word document using logo's and dyanmic data then please let us know.
View Replies
View Related
I have a HTML page with field data on, I would like to know if in ASP i am to pick up that field data and send it to a Word document, the application this data comes from is hosted in an IIS box and uses an ISAPI filter to parse the data from SQL tables to that GUI for the user. This function is need for an individual page at a time, & unfortunately I'm still quite new to ASP so I'm not sure if this is possible.
View Replies
View Related
I have a documentation management system written with ASP.This is a simple system.I want to upload necessary documents and create folders when necessary delete folders etc.When uploading documents I should select both the uploaded file & also the target location.Because I have many many folders and subfolders.
View Replies
View Related
If there a way using ASP to delete files from a folder on the server if the file doesnt exist in the database.
I have heard of something called FSO (File System Object) but not sure how to use it - does anyone know of an ASP method or how to mate ASP and FSO?
View Replies
View Related
I have a client who needs to be able to upload confidential documents (.doc and PDF) to a "hidden" area within their website so other members of their organization can later view them at their convenience. This area would be restricted by logins and passwords, but it also needs to be secure enough that no outsiders could gain access to these documents if they tried.
I've read on here about placing files in a directory outside of the root directory and then reading them back with a script but I'm wondering if there are other options that would be even more secure than this. Maybe with using some sort of file encryption or something else used in conjunction with files outside the root. I would be open to any 3rd party commercial software if someone has had good experience with it. Does anyone have suggestions to offer?
View Replies
View Related
I am using what seems to be a straight forward script but am getting an error, is the term Funtion not accepted in aspupload?:
the error is:
Microsoft VBScript compilation error '800a03ea'
Syntax error
/legacyUploadscript.asp, line 15
Function isValidFile(filename)
The script I have created is this: ...
View Replies
View Related
May I know how I can create a set of word documents using ASP? Is there any sample code available on the web for such document generation system?
View Replies
View Related
I am working in an intranet/extranet application in which the user should be able to see some documents (specially doc and pdf). These documents will be stored in a safe place in the server preventing anybody from downloading them directly from the URL.
In order to achieve this, I have made an activeX component which takes the original file and stream it to the client. I have basically two questions/problems.
First, is there a way to manipulate the document generated dinamically in order to change the way it is displayed in the browser(zoom factor,etc)? By default it depends on the client configuration. Maybe I could use an application.word object in the ASP but the problem is that I don't have the document in a file, I only have a stream sent from the server.
Another question is, how can I avoid the download dialog(open/download file prompt) on the client? I always want the document to be displayed on the browser. I know this is for security reasons, but can this be configured in some way through the IIS options for the web site? Code:
View Replies
View Related
Here's a quick query for any ASP/MS Office gurus out there!
When attempting to use the following code:
Set WordApp = CreateObject("word.application")
I get the following error message:
ActiveX component can't create object: 'word.application'
Could this be because MS Office is not installed on my server? Or is there another reason for this error message?
View Replies
View Related
I'm using ASP to create a word document using response.contenttype=("application/msword"), which works fine, but I want to do some formatting to the page setup (such as change the margin sizes) before delivering it to the client.
View Replies
View Related
I have been struggling with this for a couple days now and wanted to see if anyone can point me in the right direction... I am generating an RTF document using ASP and the FileSystemObject from values selected in a form and database values. I have had no problem creating the document and even using some pretty advanced RTF formatting but I cannot figure out how to add an image to the document.
I have read in many places that it is possible and I know there are third-party components that claim to do it but I wanted to see if anyone had any sample code to do this using ASP and the FileSystemObject. I have an image stored on the server and I want to include it within the RTF document.
View Replies
View Related
