Is there a way to get records containing a whole word? I've heard regular
expressions can do it, but I can't make one work in an ASP / MS Access SQL
Query
sSQL="SELECT PageTitle FROM Pages WHERE PageTitle LIKE '%cat%' "
rs.open etc
returns scatty, catatonic etc.
I have taken over a site which runs off a database with this table:
CREATE TABLE [trustee_download_history] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[file_id] [int] NOT NULL ,
[user_id] [int] NOT NULL ,
[date_download] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
The date_download column stores dates in a yyyy-mm-dd format.
I am normally a php/mysql programmer and need help creating a sql query to search thru this table for rows that fall b/w a start and end date.
I have a directory which I would like to search and list the latest file together with it date and time, I've found the following from w3schools for a particular file but do not know how to search a folder and sub folders for the latest file:
dim fs,f
set fs=Server.CreateObject("Scripting.FileSystemObject")
set f=fs.GetFile("c: est.txt")
Response.Write("File last modified on: ")
Response.Write(f.DateLastModified)
set f=nothing
set fs=nothing
I am taking over a script that was created by someone else. I am trying to do a search for one card that is listed in two different categories, and I only want it to bring the card up once.
<input name="Order card" type="button" id="Order card" onClick="MM_goToURL('top','http://home.amm.org/cards
/search.asp?title=DG006');return document.MM_returnValue" value="Order card">
Right now it is bring up a page with the same card listed twice. Which is correct, cause it is listed in category 2 and in category 4. I want it to bring up the card from category 4 with the title DG006. And only show the card once.
I need to give users the option to enter a zip-code in a html form, and then search through an excel-file for that zip-code. If any entries are found, then I have to output these as html.
How should i start? And what if several users tries to search the excel-file at once?
Basically I need to search the excel-file as I would search a db.
I've done a few searches on google, but haven't really found any relevant info.
I use asp to create a report, using content type I push it out as a word document. On my build this works fine, on my co workers it does not. The only difference between the two builds is I am on IE 5.5 sp2 and the other is 5.5 no sps. Unfortunatly I am in no position to get the machine and others like it onto sp 2 and the User agent variable is only returning 5.5.
The problem with the output on the no sps machine is that it opens in word with all the HTML tags visible Does anybody no a solution?
I am trying to create a word document via asp.
I keep getting this error:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is
denied to this object.
I am running window 2000 professional with IIS 5.0 installed.
I know it is a ntfs permissions error and that IUSR_ComputerName needs
permission to interface with word, i am just not sure which file needs to be
the recipient of these permissions. I have located 'word.exe' in program
files, set appropriate permission but no joy.
I have a system that Im about to start building it is in planning stage at the moment and if I was going to a database and keeping everything in HTML I would be right and not posting here at this stage.My client is after a system that they can register a new document enter in the basic information and on save, Create a Word document based on a Word Template prefilled with some of the data from the HTML form.
Can any one point me in the direction of some? tutorials/code/tips/prebuilt systems that I can donate or buy from the developer/
is it possible to produce a report of asp to ms word?
View Replies View RelatedWhat is the best way to generate a word-document with wbscript code?
I have a text string I would like to save as a word document on the server.
Any tutorials? or code examples?
I am creating a word document using asp.I have this on top of my asp page.
Response.ContentType="application/msword"
everything works fine.I am displaying some data in the table format.on some machines.may be old machines.the asp page opens up word document fine but the table tags are not rendered properly.
i get all the data fine but not displayed in the table format.instead i see <td> and other tags.it works on my machine(Windows XP) but it does this weird thing on windows 98 machine.what do i need to do to make sure it works fine on all the machines.
how to set a variable to contain the xml data from a file, including the xml tags too.
So if I have an xml file like:
<contact>
<name>Person</name>
</contact>
I want the variable to contain:
<contact>
<name>Person</name>
</contact>
I cant seem to figure out how to ensure that a whole word is replaced within a string. For example, if I have an array with two items, "mpeg" and "mpeg4" and the text to look for is "blah blah mpeg4 blah blah"
the text to match with is the array, which is in a loop. how can i prevent "mpeg" from matching with part of "mpeg4"? i only want the whole word to match. do i have to use regexp here? vbscript functions seem inadequate.
I want to do a Ms Word document in a ASP page. I can do it, With the code lines:
/////
Response.ContentType = "application/msword"
Response.AddHeader "content-disposition", "inline; filename=OrderFax.doc"
////
With these lines all document content show like a Word document.
But i can not change the MARGINS of this Word document.And Default
left/right margins are very bigs.
I try it, change the <body> attributes and with styles, but this don't work,
the margins are always the same.
How can i modify the margins of word document? I should do this with another method?
Can I modify PC client settings to change the defaults margins of word document create througt the web?
My problem, i got a string that may can contain more than one word, it can contain upto ten, now my problem is i gotta replace some of the words, but with Replace, you can only do one word at a time?
so how do i go about running thruogh the string and replacing all the relevant words, and putting them back into a string?
The following code hangs or gives me a "can not fire event" message
The code works from a windows app.
Fails in ASP.NET on the word.open call
I have done the following:
How to configure Office applications to run under a specific user account
http://support.microsoft.com/defaul...b;en-us;Q288367
Before doing the above the cod use to get an access denied on the
new word.application();
oWordApplic = new Word.Application();
object fileName = "filename.doc";
object readOnly = false;
object isVisible = true;
object missing = System.Reflection.Missing.Value;
// hangs here or returns cant fire event msg
oDoc = oWordApplic.Documents.Open(ref fileName, ref missing,ref readOnly,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref isVisible,ref missing,ref missing,ref missing,
ref missing);
Any ideas?
i want to make a program to find out and highlight a particular word on the browser using ASP and javascript.
View Replies View RelatedI'm currently working on an application that has to open word documents (word forms) and read and write data from/to it. But, unfortunately, the web server hasn't Word installed (my ISP...). Is there any other way to do that?
I'm currently investigating about working with rtf documents, but the syntax is turning me crazy!!! Any idea/dll/other way to do that?
I am maintaining quite a few asp applications. In one of those, I have to
change the response.redirect to a particular page. This application has more
than fifty asp pages. Instead of going through manually through each page to
find the response.redirect phrase, is there any tool that will find and
report all occurences of response.redirect (in the present scenario) among
all those fifty asp pages? If there is one I would like to know.
I'm trying to output some data from the db into a table but I'm getting a number of problems with the layout if all the words are together. The table stretches across the screen. I want to be able to output a number of words/characters and then insert a line break and then carry on with the rest of the output.
View Replies View RelatedI have a Word doc already created that I want to open from an asp page. I want it to open in Word and allow the user to modify if necessary. I currently have it opening (using href), but it is opening in IE. I think I should be able to do it with javascript to open word and then call that function on the link to the doc. Can someone give me some pointers?
View Replies View RelatedI have an MS Word template and wish to substitute certain values into certain parts of the document. I'm going to open the word doc using FSO. Is there any way to pass parameters in to a word doc when you open it like this?
View Replies View RelatedHow can I open/push data to WORD/EXCEL which was installed in client machine? Is it possible without using thirdpaty components?
View Replies View RelatedI 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.
i want to know that is it possible to copy from a word document and
paste it on to a textarea on a asp page.
when i do it normally bullets are not paste as it is .
it is changed into different symbol( inverted ?)
I need to save a lot of pages to a .doc MS Word file with one button click on my asp app.... can this be done ?.....I am thinking this .doc file will be saved on the server, so I can then download it to the users PC.
I can have the MS Word templates to fill out on the server , so do i create an asp page to fill out these templates and then save the file..then somehow download it automatically, hence it will end up on the users PC in a shared Dir...is this all possible?
I need to generate one document on the server and then send it to de client. I having problems of security when i try to open word by code. How can i do that?
View Replies View RelatedI've been looking (unsuccessfully) for a tutorial on creating Word documents from ASP. I know it can be done and have been able to find some references to various aspects of this, but nothing that spells out the process from beginning to end.
What I'm trying to accomplish is being able to generate a paper document using some information that is contained in an Access database. I have a ASP script that will generate the same info on the screen, but nothing that will put it on paper in a clean, professional format.
I am planning to use some kinda of search using a piece of word, for example, in the database i have:
Contrução
Constituição
Confraternização
Costura
Corte
So if, in the search field, i type: "Con" it should bring me the following result:
Contrução
Constituição
Confraternização
I dunno if this kinda of search has a 'special' name, but I would like to see any example of this in ASP and a database (Access/MySQL/MSSQL), if someone has it easy in hands and would like to share
I've done some research on how to do a MS Word merge with data I read
in an ASP application (using a SQL Server database).
I understand the concept since I've done it in a couple other
programming languages.
i want to know that is it possible to copy from a word document and
paste it on to a textarea on a asp page.
when i do it normally bullets are not paste as it is .
it is changed into different symbol( inverted ?).
I am creating a word document from an asp page. I have no problems
actaully creating the document and creating some tables that have data
in them. I am using Response.ContentType = "application/vnd.ms-word"
to create the actual document. My problem is that I want to place a
picture (which resides on the server) into the word document as well.
However all I seem to get is the place for the image but a picture of
an "x" meaning that the picture is missing.
is it posible to populate a microsoft word document from a database using a web browser. Here is the thing Currently i can get information from the db and create a form on a web browser page, but now i am trying to get that same form on a word document so that when printed it will not have the head and footer from a browsers page.
View Replies View Related